crash_reports
2 rows where dcc_code = "[97]" and speed_limit = 0
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2019-08-08
Time:
13:35
Address:
20 AUSTIN ST
Speed
limit:
0
Violation
cited:
no
Narrative:
The owner of MV#1 stated he came out to his vehicle and found a note that someone had struck it. There was damage on his passenger rear door of MV#1. I spoke with the operator of MV#2 who stated that MV#1 was parked too close to her vehicle and she opened her drivers door and struck the passenger side door of MV#1.
Keywords:
[]
Dcc:
Other improper action
Report
url:
Image
url:
Latitude:
42.3502776
Longitude:
-71.2075314
Location:
Case
number:
Date:
2021-01-30
Time:
13:26
Address:
624 WASHINGTON ST
Speed
limit:
0
Violation
cited:
no
Narrative:
On January 30th, 2021 at approximately 13:26 hours while assigned to N491 I responded to #624 Washington St, Santander Bank parking lot, for a hit & run MV crash. On my arrival I spoke with the R/P, victim and owner of vehicle #1. She reported she is employed at the bank and arrived at the employees parking lot at approximately 08:30 hours. She parked her vehicle a gray, 2014 Honda Civic, Ma reg. 5fk-747 in the S/E corner of the parking lot facing the7 Eleven store. She came out from work around 13:15 hours and noticed her rear drivers side had been struck by an unknown vehicle. Vehicle #2, left scene without making itself known.
Keywords:
Crash
Dcc:
Other improper action
Report
url:
Image
url:
Latitude:
42.3536407
Longitude:
-71.1992959
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);