crash_reports
3 rows where "datetime" is on date 2020-01-08, dcc = "["Unknown"]" and intersection = 0
This data as json, CSV (advanced)
Suggested facets: speed_limit, hit_run, datetime (date), date (date), retrieved (date), dcc (array)
Case
number:
Date:
2020-01-08
Time:
13:33
Address:
647 WASHINGTON ST
Speed
limit:
25
Violation
cited:
no
Narrative:
Miriam Plavin-Masterman states that she parked vehicle #2 at the Whole Foods on Washington St earlier today. When she came out she noticed someone struck her right rear bumper. Miriam stated that checked with the store to see if there was video surveillance and there was not. No witnesses at this time. report for insurance purposes.
Keywords:
[]
Dcc:
Unknown
Report
url:
Image
url:
Latitude:
42.3541087
Longitude:
-71.2000849
Location:
Case
number:
Date:
2020-01-08
Time:
13:31
Address:
9 BEACON PL
Speed
limit:
0
Violation
cited:
no
Narrative:
The owner of MV#1 stated she parked in the parking lot at 9 Beacon Pl. at 0800 hrs. At 1345 hrs. she noticed damaged to the drivers side font fender. There were no witnesses and the operator of MV#2 in unknown.
Keywords:
[]
Dcc:
Unknown
Report
url:
Image
url:
Latitude:
42.3305578
Longitude:
-71.1953741
Location:
Case
number:
Date:
2020-01-08
Time:
14:55
Address:
9 LILL AVE
Speed
limit:
25
Violation
cited:
no
Narrative:
The owner of MV#1 states that her MV was parked and unoccupied in front of #9 Lill Ave when MV#2 backed into it from the driveway across the street. The operator of MV#2 states that he was backing his MV out of the driveway across from #9 Lill Ave when the rear of his MV struck MV#1. No injuries, no tows.
Keywords:
[]
Dcc:
Unknown
Report
url:
Image
url:
Latitude:
42.3554912
Longitude:
-71.2367132
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);