crash_reports
1 row where address = "BEACON ST & WALNUT ST" and date = "2019-05-05"
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2019-05-05
Time:
21:05
Address:
BEACON ST & WALNUT ST
Speed
limit:
30
Violation
cited:
no
Narrative:
MV1 was travelling WB on Beacon St when MV2 cut across his lane of travel causing him to strike the passenger side of MV2. MV2 was attempting to turn NB onto Walnut St from Beacon when he was struck by MV1. Operator 2 states he believed he had enough time to make it across the intersection and believes MV1 was speeding. Operator 1 states he was operating at the speed limit (30MPH) and MV2 cut in front of him. Both parties had the green light at the intersection. No injuries reported by any party. Parent of operator 2 signed a patient refusal based upon the operators age. Both vehicles were towed due to air bag deployment. MV1 sustained minor damage to the front end. MV2 sustained moderate damage to the passenger side.
Keywords:
Moderate, Speed
Dcc:
Inattention
Report
url:
Image
url:
Latitude:
42.3308369
Longitude:
-71.2070206
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);