crash_reports
2 rows where "datetime" is on date 2019-05-22, dcc = "[]" and intersection = 0
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array)
Case
number:
Date:
2019-05-22
Time:
08:29
Address:
23 KENILWORTH ST
Speed
limit:
25
Violation
cited:
no
Narrative:
Sometime between 5/21/2019 at 17:00 and 5/22/2019 at 08:00 someone struck motor vehicle 1 and left the area. There was glass on the ground where vehicle # 1 was parked.
Keywords:
[]
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3438767
Longitude:
-71.1810326
Location:
Case
number:
Date:
2019-05-22
Time:
20:06
Address:
230 COMMONWEALTH AVE
Speed
limit:
30
Violation
cited:
no
Narrative:
Operator 1 stated that he was driving eastbound on Commonwealth Ave in the right lane. He stated that operator 2 had driven into the side of his truck out of nowhere. He reported no injuries and the truck had minor damage. Operator 2 stated that he was driving eastbound on Commonwealth ave and had thought the truck was pulling into the first entrance to the Speedway and he merged over in the left lane to enter in the second entrance. The truck had continued straight and had not turned. No injuries reported and operator 2 vehicle was towed by Triple A
Keywords:
Speed
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3370323
Longitude:
-71.1751383
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);