crash_reports
2 rows where "datetime" is on date 2022-06-14 and "retrieved" is on date 2022-07-26
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2022-06-14
Time:
13:11
Address:
1280 CENTRE ST
Speed
limit:
5
Violation
cited:
yes
Narrative:
On Tuesday 6/14/2022, at approx 1311hrs, while assigned to N496, I responded to the parking lot of 1280 Centre St in Newton for a MVA hit&run with a parked vehicle. There I observed fresh damage to the rear bumper of MV1. The owner of MV1 was notified of the accident and was given a report number. I was unable to locate the owner of MV2, Song Mai. Mai was cited for leaving the scene of property damage. MA citation number T2015014 was mailed to the address listed on Mai's registration. It should be noted that Mai has an extensive drivers history including leaving the scene of property damage.
Keywords:
Citation, Crash, Severe
Dcc:
Reckless driving
Report
url:
Image
url:
Latitude:
42.3296269
Longitude:
-71.1943762
Location:
Case
number:
Date:
2022-06-14
Time:
17:46
Address:
WALNUT ST & WATERTOWN ST
Speed
limit:
35
Violation
cited:
yes
Narrative:
MV1 was stopped in traffic heading WESTBOUND at the Walnut St/Watertown St red light with a few cars in front of him. The eastbound side of Watertown St has one lane that becomes two about 100ft before the red light intersection for a left turn only lane. MV1 was in the rightmost lane planning to continue straight on Watertown St. MV2 was behind MV1 heading WESTBOUND as well and planning to turn left onto Walnut St but the turn only lane wasn't clear yet so MV2 went around MV1, over the double yellow line and into the turn only lane. MV2 sideswiped MV1. MV1 sustained damage to its driver's front side. MV2 sustained damage to its passenger rear side. No injuries and both vehicles were still operable. MV2 operator was issued in hand MV citation for Marked Lanes 89/4A.
Keywords:
Citation
Dcc:
Signs/Signals
Report
url:
Image
url:
Latitude:
Longitude:
Location:
Advanced export
JSON shape: default, array, newline-delimited, object
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);