crash_reports
1 row where date = "2022-06-16" and "retrieved" is on date 2022-06-21
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), dcc (array)
Case
number:
Date:
2022-06-16
Time:
15:52
Address:
1235 WASHINGTON ST
Speed
limit:
25
Violation
cited:
no
Narrative:
MV1 was pulling out of the parking lot of KG Motors with a dealership car. An employee at KG Motors, Dennis Cronin, was assisting in getting him out of the parking lot safely and into rush hour traffic on Washington St/West Newton Square. MV1 operator pulled out into the first WESTBOUND lane and Mr. Cronin stepped out on Washington St and tried to hold up traffic in the other WESTBOUND traffic lane. MV1 operator, William Bradshaw, believed that it was clear to pull further out into traffic when it collided with MV2. MV2 was driving WESTBOUND straight on Washington St when she thought she saw a man standing in the middle of traffic, she looked twice and when she did, she collided with MV1 who had pulled into her lane of travel. No injuries reported and both cars were drivable.
Keywords:
[]
Dcc:
Failed to yield
Report
url:
Image
url:
Latitude:
42.3494902
Longitude:
-71.2242412
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);