crash_reports
2 rows where "datetime" is on date 2019-03-12 and hit_run = 1
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2019-03-12
Time:
14:36
Address:
30 TOWER RD
Speed
limit:
10
Violation
cited:
no
Narrative:
The owner of MV#1 stated he parked his vehicle in the parking lot of 30 Tower Rd and went inside the store to shop. He returned to his vehicle and discovered that the front and rear passenger side doors had been damaged. The owner of MV#1 stated he went back into the store in hopes to view surveillance videos of the accident but came up with negative results.
Keywords:
Crash
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3102612
Longitude:
-71.2156323
Location:
Case
number:
Date:
2019-03-12
Time:
15:24
Address:
1241 CENTRE ST
Speed
limit:
30
Violation
cited:
yes
Narrative:
Operator 1 was attempting to parallel park in a parking space in front of 1241 Centre St when she was sideswiped by MV2 who was attempting to pass her. No injuries reported. MV1 sustained minor rear drivers side damage. MV2 fled the scene prior to my arrival. NPD located the vehicle at the owners residence which had matching damage and paint transfer on the front passenger side. Multiple attempts were made to contact the owner with negative results, he will be mailed Mass Uniform Citation #T1440739 for leaving the scene ( property damage) and marked lane violation.
Keywords:
Citation
Dcc:
Lane departure, Reckless driving
Report
url:
Image
url:
Latitude:
42.3307248
Longitude:
-71.1948758
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);