crash_reports
2 rows where dcc contains "Followed too closely", intersection = 0 and "retrieved" is on date 2021-11-12
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2021-11-04
Time:
15:59
Address:
CRAFTS ST
Speed
limit:
25
Violation
cited:
no
Narrative:
While traveling eastbound on Crafts St, LAWLER was operating Vehicle 1 and stopped at the stop light at the intersection with Linwood Ave. RAY was operating Vehicle 2 and was also traveling eastbound on Crafts St behind LAWLER and did not stop and made contact with the rear bumper of LAWLER's vehicle with the front bumper of her vehicle, causing minimal damage to LAWLER's vehicle and extensive damage to the front of her vehicle which appeared to be in excess of $1000. Neither party was able to explain how the collision occurred. There were no injuries reported. I facilitated the exchange of information between both drivers and both were allowed to drive away from the scene.
Keywords:
Severe
Dcc:
Signs/Signals, Followed too closely
Report
url:
Image
url:
Latitude:
42.358132
Longitude:
-71.21015
Location:
Case
number:
Date:
2021-11-08
Time:
15:05
Address:
73 LEXINGTON ST
Speed
limit:
25
Violation
cited:
no
Narrative:
Operator of MV1 states she was going south on Lexington street and had to stop abruptly for a school bus when she was then rear ened by MV2. Operator of MV2 states she traveling behind MV1 when she struck the rear of MV1 when she didnt stop in time. No reported injuries by either parties and neither vehicle was towed.
Keywords:
Bus, School
Dcc:
Followed too closely
Report
url:
Image
url:
Latitude:
42.3577593
Longitude:
-71.2398573
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);