crash_reports
2 rows where dcc contains "Emotional", intersection = 0 and "retrieved" is on date 2020-10-06
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), dcc (array)
Case
number:
Date:
2020-07-22
Time:
06:54
Address:
165 NEEDHAM ST
Speed
limit:
25
Violation
cited:
no
Narrative:
Based on observations and statements made, the following occoured. M/V#1 was traveling east on Needham St. when the operator abruptly turned left to enter 165 Neddham St. M/V#2 was traveling behind M/V#1, and collided with the left rear of M/V#1 as it turned left.
Keywords:
[]
Dcc:
Emotional, Unknown
Report
url:
Image
url:
Latitude:
42.3121478
Longitude:
-71.2138224
Location:
Case
number:
Date:
2020-08-09
Time:
14:43
Address:
197 CALIFORNIA ST
Speed
limit:
20
Violation
cited:
no
Narrative:
Opr of MC1 stated he was traveling straight attempting to leave the parking lot. Opr MC1 stated while he was trying to pull forward he was struck by V2. Opr of V2 stated he was attempting to leave the parking lot. Opr of V2 stated he was emotional and upset and tried to pass the two motorcycles. Opr of V2 stated he got too close and made contact with MC1. MC1 had minor damage and the Opr was seen by the Medics. V2 had minor damage and was seen by the Medics. Both signed patient refusals.
Keywords:
[]
Dcc:
Reckless driving, Emotional
Report
url:
Image
url:
Latitude:
42.3651092
Longitude:
-71.1963023
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);