home / crashreports

home

Menu
  • GraphQL API

crash_reports

Table actions
  • GraphQL API for crash_reports

4 rows where "datetime" is on date 2019-10-04, intersection = 0 and "retrieved" is on date 2020-10-07

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: speed_limit, violation_cited, dcc, dcc_code, 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:
1900001009
Date:
2019-10-04
Time:
16:04
Address:
525 WALTHAM ST
Speed limit:
10
Violation cited:
no
Narrative:
Operator of MV#1 stated his car was parked in a metered spot in the parking lot behind West Newton Post Office, 525 Waltham St. Operator of MV#2 stated she was pulling into the parking lot and turning into a spot next to MV#1. She sideswiped MV#1. Minor damage to both vehicles. Both vehicles were able to be driven from the scene.
Keywords:
[]
Dcc:
Over-steering
Report url:
report
Image url:
image
Latitude:
42.3497196
Longitude:
-71.2265848
Location:
525 Waltham St, West Newton, MA 02465, USA
Case number:
1900001010
Date:
2019-10-04
Time:
15:18
Address:
56 ROOSEVELT RD
Speed limit:
25
Violation cited:
yes
Narrative:
Operator 1 of vehicle 1 was traveling w/b on Roosevelt Rd when Vehicle 2 hit the curb and collided with her vehicle. Major damage to vehicle 1 and was towed by todys towing. No injuries to Operator 1. Vehicle 2 was traveling at a high rate of speed e/b on Roosevelt rd when she hit the curb and collided with vehicle 2 head on. Vehicle 2 was on the wrong side of road during the collision. Operator 2 was not injured. Passenger 1 and 2 was not injured and medical refusals were obtained through their parents. Passenger 3 was injured and taken to the NWH with minor injuries. Vehicle 2 had major damage and was towed by todys towing. Operator 2 was issued MA citation T2015492 for c89s4A Marked Lanes, c90s8 Passenger Restriction (JOL) and c90s17 for Speed.
Keywords:
Citation, Speed
Dcc:
Too fast for conditions, Inattention
Report url:
report
Image url:
image
Latitude:
42.3140525
Longitude:
-71.1931463
Location:
56 Roosevelt Rd, Newton, MA 02459, USA
Case number:
1900001011
Date:
2019-10-04
Time:
22:47
Address:
256 ALBEMARLE RD
Speed limit:
25
Violation cited:
no
Narrative:
MV1 (MA Reg:2LM951; 2016 Ford Fusion) was traveling NORTH when it ran off the road hitting the median curb, then a "No Parking This Side" sign, then a tree on the Albemarle Rd median. MV1 operator, Cynthia Muzaki, stated that she saw something run across the road, swerved and collided with a pole then tree. Air bag deployment from the driver and passenger side deployed. Cynthia signed a refusal with the medics. Tody's towed the vehicle. Cynthia ordered an Uber back to her residence in Watertown. DPW notified about the sign that was damaged. Pictures of the scene were sent to IT.
Keywords:
Pictures, Tree
Dcc:
Over-steering
Report url:
report
Image url:
image
Latitude:
42.3576147
Longitude:
-71.2159572
Location:
256 Albemarle Rd, Newton, MA 02460, 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 396.491ms