crash_reports
2 rows where date = "2020-12-31" and "retrieved" is on date 2021-01-08
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2020-12-31
Time:
16:57
Address:
GROVE ST & CORNELL ST
Speed
limit:
25
Violation
cited:
no
Narrative:
The operator of vehicle 1 was travelling westbound on Cornell St. Vehicle 1 travelled through the intersection of Cornell and Grove St, and struck the stop sign on the opposite side of Cornell St. The stop sign was completely knocked over. Vehicle 1 was registered to 6 Colgate Cir. I observed vehicle 1 parked in the driveway at 6 Colgate Cir, there was minor damage to the front license plate. No one was injured. Photos were taken of the stop sign, and submitted to the IT bureau.
Keywords:
Pictures
Dcc:
Unknown
Report
url:
Image
url:
Latitude:
42.3295535
Longitude:
-71.2581248
Location:
Case
number:
Date:
2020-12-31
Time:
19:44
Address:
2370 COMMONWEALTH AVE
Speed
limit:
25
Violation
cited:
no
Narrative:
The operator of MV1(RI GW647) stated he had been involved in an accident in the area of 2370 Commonwealth avenue sometime around 6pm.According to the operator he was struck by a "boxy Jeep' which caused heavy damage to the front end of his vehicle, and caused the hood to unlatch and crack the windshield. MV1 was inoperable as a result. The operator was unable to provide any further identifying information on the other vehicle. The operator requested a private tow, and was uninjured. He was provided this report number.
Keywords:
Crash
Dcc:
Unknown
Report
url:
Image
url:
Latitude:
42.344635
Longitude:
-71.258199
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);