crash_reports
2 rows where dcc = "["Unknown"]", hit_run = 0 and "retrieved" is on date 2020-10-20
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2020-10-05
Time:
15:31
Address:
719 WASHINGTON ST
Speed
limit:
35
Violation
cited:
no
Narrative:
The operator of Vehicle #1 stated that she was travelling WestBound on Washington St when her vehicle was struck by Vehicle #2 when it drifted into her lane. The operator of Vehicle #2, a Cataldo Ambulance, stated that the vehicle was struck by Vehicle #1 when it drifted into her travel lane. All involved parties declined medical attention.
Keywords:
Ems
Dcc:
Unknown
Report
url:
Image
url:
Latitude:
42.3527843
Longitude:
-71.2030088
Location:
Case
number:
Date:
2020-10-14
Time:
09:01
Address:
277 ELLIOT ST
Speed
limit:
25
Violation
cited:
no
Narrative:
On Wednesday October 14, 2020 at approx. 0901 hours I responded to the area of 277 Elliot Street for a report of a two motor vehicle crash unknown injuries. Upon arrival on scene, Newton Fire personnel and medics were on scene for an evaluation. Both parties refused / advised treatment and signed patient refusals. I spoke with the oper of v1, she stated a vehicle in front of her stopped abruptly and she slammed on her brakes and was stopped when she felt impact from vehicle 2. Oper v2 stated that vehicle 1 stopped abruptly, he slammed on his brakes and due to the roadway being wet his vehicle slid into v1. He stated he had some irritation from the front air bag deploying. Witness stated a vehicle in front of him stopped abruptly to turn left, which caused him to stop abruptly, which caused chain reaction.
Keywords:
Crash, Fire
Dcc:
Unknown
Report
url:
Image
url:
Latitude:
42.3136373
Longitude:
-71.2206445
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);