crash_reports
2 rows where "datetime" is on date 2022-06-08, dcc contains "Followed too closely" and intersection = 0
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2022-06-08
Time:
14:29
Address:
1032 CENTRE ST
Speed
limit:
25
Violation
cited:
no
Narrative:
Oper # 1 stated she was stopping in traffic while going SB on Centre Street when she was rear ended by Veh # 2. Oper # 2 admitted fault saying he couldn't stop in time. No tows. No Injuries.
Keywords:
[]
Dcc:
Followed too closely
Report
url:
Image
url:
Latitude:
42.3369317
Longitude:
-71.1928679
Location:
Case
number:
Date:
2022-06-08
Time:
19:37
Address:
457 WALNUT ST
Speed
limit:
25
Violation
cited:
no
Narrative:
MV1 was traveling NORTHBOUND on Walnut St just passing Newton North High School when they stopped for pedestrians in the crosswalk at the intersection of Walnut St at Clyde St. MV2 traveling behind MV1 heading NORTHBOUND as well when they rear-ended MV1 not realizing that MV1 had stopped for pedestrians. MV1 sustained damage to its rear bumper and MV2 sustained heavy damage to its passenger front bumper and hood. No airbags deployed and no injuries reported. Tody's towed both vehicles.
Keywords:
Airbag, Crosswalk, Ped, School
Dcc:
Followed too closely
Report
url:
Image
url:
Latitude:
42.3451469
Longitude:
-71.2075289
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);