crash_reports
2 rows where dcc = "[]", intersection = 0 and "retrieved" is on date 2021-08-07
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array)
Case
number:
Date:
2021-07-30
Time:
12:56
Address:
871 BEACON ST
Speed
limit:
25
Violation
cited:
no
Narrative:
Vehicle 1 was parked legally on the westbound side of Beacon St in front of #871 unoccupied for approximately 15 minutes. When the operator returned she discovered another vehicle had struck her drivers side mirror. There were no witnesses or cameras in the area. The other vehicle left behind a maroon piece of plastic that had no markings or distinguishing features to help identify itself.
Keywords:
[]
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3304871
Longitude:
-71.1969263
Location:
Case
number:
Date:
2021-08-03
Time:
14:57
Address:
20 ST MARYS ST
Speed
limit:
15
Violation
cited:
no
Narrative:
Party of Motor Vehicle #1 stated their vehicle was parked in front of their home on St Mary's Street while they were away on vacation and was struck causing moderate front end damage. Party stated that they were having worked done on the home and the driveway was unavailable to park the vehicle. Party stated that their neighbor called them on Thursday 07/29/21 to inform them that their vehicle had been struck.
Keywords:
Moderate
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3309044
Longitude:
-71.262171
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);