crash_reports
2 rows where dcc = "[]", intersection = 0 and "retrieved" is on date 2021-01-25
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array)
Case
number:
Date:
2021-01-18
Time:
15:22
Address:
LOWELL AVE
Speed
limit:
30
Violation
cited:
no
Narrative:
MV1 was traveling northbound on Lowell Ave and was turning right into the rear Newton North parking lot off of Lowell Ave. MV1 used its turn signal and was traveling less than 5mph. The Bicyclist was traveling northbound on Lowell Ave and struck the MV. The Bicyclist suffered minor injuries.
Keywords:
Bike
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3473475
Longitude:
-71.2108849
Location:
Case
number:
Date:
2021-01-21
Time:
14:19
Address:
411 LEXINGTON ST
Speed
limit:
25
Violation
cited:
no
Narrative:
The operator of MV#1 stated that he was traveling south on Lexington St just past Commonwealth Ave when the passengers side rear of his MV was struck by MV#3. The force of the crash pushed MV#1 into oncoming north bound traffic and MV#1 struck MV#2. The operator of MV#2 stated that he was traveling north on Lexington St approaching Commonwealth Ave when his MV was struck by MV#1. The operator of MV#3 stated that she was parked in a parking spot on Lexington St just past Commonwealth Ave and was attempting to enter the south bound travel lane when her MV struck MV#1, which was pushed into MV#2. No injuries and MV#3 was towed from the scene at the owners request by Tody's.
Keywords:
Crash
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3475607
Longitude:
-71.2472272
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);