home / crashreports

home

Menu
  • GraphQL API

crash_reports

Table actions
  • GraphQL API for crash_reports

3 rows where dcc contains "Physical impairment", intersection = 0 and "retrieved" is on date 2020-10-07

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: violation_cited, datetime (date), date (date), retrieved (date), keywords (array), dcc (array)

case_number ▼ date time address speed_limit violation_cited narrative keywords dcc report_url image_url latitude longitude
Case number:
1900001008
Date:
2019-10-04
Time:
16:09
Address:
313 CALIFORNIA ST
Speed limit:
25
Violation cited:
yes
Narrative:
MV1 (MA Reg: 1LMD95; Honda Accord 2019) was traveling west on California St when it came to rest on the shoulder of the road. MV2, (MA Reg: 5YR125; Honda CRV 2019) helped MV1 come to a stop because it was parked. Minor damage to MV1 front driver bumper and MV2 scratch on the rear bumper. MV2 owner, Lourdes Meira, exited her residence at 313 California St to witness MV1 pressed against her vehicle. Meira called 911 because she observed the driver of MV1 unconscious or asleep. Fire arrived on scene and gave two doses of Narcan to MV1 operator, Keith Harrington. Harrington gained consciousness and medics transported to NWH. Harrington admitted to injecting heroin today prior to this incident. Harrington to be summons for 90/24G-OUI Drugs, 2nd offense and 90/24E-Negligent Operation (MA Uniform Citation:T2079021). Citation given in hand at NWH by Ofc. Guarinio. Tody's towed MV1, towed motor vehicle form filled out. Used syringe from MV1 center console safely disposed of in N492. Small silver container with white substance confiscated from center console beside used needle. Container was filed into property and evidence to be tested. An immediate threat was filed and faxed to RMV.
Keywords:
Citation, Fire
Dcc:
Physical impairment, Other improper action
Report url:
report
Image url:
image
Latitude:
42.3651852
Longitude:
-71.2014451
Location:
313 California St, Newton, MA 02458, USA
Case number:
1900001170
Date:
2019-11-13
Time:
21:37
Address:
1351 WASHINGTON ST
Speed limit:
25
Violation cited:
no
Narrative:
Operator of MV2 was parked in front of 1351 Washington Street with his directional on, waiting to enter traffic when MV1 sidewiped his vehicle. MV2 sustained scratches to the rear bumper, driver side front door, and driver side rear door. The driver's side mirror was also knocked off. MV1 did not appear to have any damage. Neither party reported any injuries from the accident. Operator of MV2 did not require a tow. MV1 was towed by Todys Towing due to the operator being transported to NWH for a medical evaluation.
Keywords:
Crash
Dcc:
Lane departure, Physical impairment
Report url:
report
Image url:
image
Latitude:
42.3490685
Longitude:
-71.2284991
Location:
1351 Washington St, West Newton, MA 02465, USA
Case number:
1900001189
Date:
2019-11-20
Time:
21:27
Address:
140 BRANDEIS RD
Speed limit:
25
Violation cited:
no
Narrative:
MV 1 was traveling eastbound on Brandeis Rd and struck a bush and the curb in front of Newton South High School. The front right tire was popped and left rear tire was popped. There was also significant damage to the undercarriage of the vehicle. Due to the vehicle being disabled on school grounds, it was towed by Tody's towing. Inventory sheet completed and filed. Refer to NPD incident 19050207. A city bush and curb was damaged from the accident noted in the crash diagram and property section.
Keywords:
Bus, Crash, School
Dcc:
Reckless driving, Physical impairment
Report url:
report
Image url:
image
Latitude:
42.3135234
Longitude:
-71.1865424
Location:
140 Brandeis Rd, Newton, MA 02459, USA

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

CREATE TABLE "crash_reports" (
   [case_number] TEXT PRIMARY KEY,
   [datetime] TEXT,
   [date] TEXT,
   [time] TEXT,
   [address] INTEGER,
   [street1] TEXT,
   [street2] TEXT,
   [intersection] INTEGER,
   [speed_limit] INTEGER,
   [hit_run] INTEGER,
   [violation_cited] INTEGER,
   [narrative] TEXT,
   [keywords] TEXT,
   [dcc] TEXT,
   [dcc_code] TEXT,
   [report_url] TEXT,
   [image_url] TEXT
, [geocoded_address] TEXT, [latitude] TEXT, [longitude] TEXT, [manual_geocode] INTEGER, [retrieved] TEXT);
Powered by Datasette · Queries took 359.595ms