crash_reports
2 rows where dcc contains "Followed too closely", intersection = 0 and "retrieved" is on date 2022-06-14
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2022-06-03
Time:
16:01
Address:
331 WALNUT ST
Speed
limit:
25
Violation
cited:
yes
Narrative:
MV 1 was traveling south bound on Walnut St in front of 331 Walnut when she followed MV 2 too closely and rear ended her. MV 1 sustained major damage to its front end and was towed by Tody's for it being disabled. The operator of MV 1, Ms. Perla Heredia, was cited for driving without a license, unregistered motor vehicle, and attaching incorrect plates on the vehicle (MA reg 2KYY53). A police incident report was also completed ( incident number 22019531) MV 2 was traveling straight southbound on Walnut St when she was rear ended. MV 2 sustained minor damage to her rear end. MV 2 was able to be driven away by the operator. MV 2 was advised of this crash report number. There were no injuries to either party.
Keywords:
Citation, Crash
Dcc:
Followed too closely
Report
url:
Image
url:
Latitude:
42.3497031
Longitude:
-71.2071277
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);