crash_reports
2 rows where "date" is on date 2019-04-25, dcc contains "Inattention" and intersection = 0
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2019-04-25
Time:
10:21
Address:
545 GROVE ST
Speed
limit:
25
Violation
cited:
no
Narrative:
Operator of vehicle 1 states she was was driving southbound on Grove St when a squirrell ran out infront of her. She swerved right to avoid the squirrell and hit a utility poll. Operator 1 was checked on by Cataldo medics and signed a patient refusal. The vehicle was towed by AAA and utilites were notified about possible damage to the poll.
Keywords:
[]
Dcc:
Inattention
Report
url:
Image
url:
Latitude:
42.3306225
Longitude:
-71.258568
Location:
Case
number:
Date:
2019-04-25
Time:
10:28
Address:
87 BRANDEIS RD
Speed
limit:
30
Violation
cited:
no
Narrative:
Patrice Lys was operating vehicle #2 on Brandies Rd. Lys states that vehicle #1 was about to back out of the driveway so he stopped. Lys state that the vehicle did not back out so he started to drive again, at that point vehicle #1 backed out of the driveway and struck his vehicle on the left rear. Azad Chitchian was operating vehicle #1. Azad states that she saw vehicle #2 stop to let her out of her driveway, she then went to back out of her driveway and vehicle #2 struck her. Aghavni Gevorgyan was witness. Aghavni confirms Azad's version of events. Aghavni and Azad are known to each other. Azad was transported to NWH. I took pictures, no traffic officers working.
Keywords:
Pictures
Dcc:
Inattention
Report
url:
Image
url:
Latitude:
42.3140858
Longitude:
-71.1911506
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);