crash_reports
1 row where address = "NAHANTON ST & WELLS AVE" and date = "2019-10-23"
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2019-10-23
Time:
16:48
Address:
NAHANTON ST & WELLS AVE
Speed
limit:
30
Violation
cited:
yes
Narrative:
The operator of MV1 states that he was at a complete stop at a red light at the intersection of Nahanton Street and Wells Ave when he was rear ended by MV2. The operator of MV2 did not speak English well and was unable to explain exactly what happened. Upon further investigation the operator of MV2 did not have a valid Massachusetts drivers license and only presented me with a Brazilian drivers license despite being in the State for over 1 year. Therefore I issued the Operator of MV2, Carlos Roberto Da Silva Ferreira, Massachusetts Uniform Citation T2079296, for 90-10 Operating a Motor Vehicle without a valid drivers license. Both parties were evaluated by Medics and signed patient refusals. MV1 sustained minor damage to the rear bumper and was driven from the scene while MV2 sustained moderate damage to the front drivers side bumper and was towed from the scene by Todys.
Keywords:
Citation, Moderate
Dcc:
Inattention
Report
url:
Image
url:
Latitude:
42.2971091
Longitude:
-71.2040054
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);