crash_reports
2 rows where dcc contains "Followed too closely", intersection = 0 and "retrieved" is on date 2022-03-02
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2022-02-22
Time:
07:38
Address:
PARKER ST
Speed
limit:
25
Violation
cited:
no
Narrative:
Operator #1 stated she was stopped at a light while travelling northbound on Parker St (unknown intersection) when she was rear ended by an unknown vehicle. There was moderate damage to the rear passenger side of the vehicle. Operator could not provide a description of the vehicle. She was uninjured and was able to drive her car from the scene. Operator #1 was advised that a report would be on file and to contact her insurance company.
Keywords:
Moderate
Dcc:
Followed too closely
Report
url:
Image
url:
Latitude:
42.3174111
Longitude:
-71.1947348
Location:
Case
number:
Date:
2022-02-23
Time:
11:36
Address:
449 COMMONWEALTH AVE
Speed
limit:
35
Violation
cited:
no
Narrative:
Operator #1 stated he was driving the ambulance WB on Commonwealth Ave with out lights and sirens when he rear ended vehicle # 2. Vehicle # 2 was stopped due to red light ahead. Passenger #2 was in rear of ambulance with Passenger #3 (patient) when accident occurred.Lifeline sent another ambulance to finish the transport from Franciscan Childrens to Tauton State Hospital. No Tows No transports
Keywords:
Crash, Ems, Hospital
Dcc:
Followed too closely
Report
url:
Image
url:
Latitude:
42.3369953
Longitude:
-71.1846992
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);