crash_reports
1 row where date = "2022-01-23", intersection = 0 and keywords contains "Fire"
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2022-01-23
Time:
14:58
Address:
325 BEACON ST
Speed
limit:
25
Violation
cited:
no
Narrative:
On January 23, 2022 at approximately 1458 hours, I responded to the area of 325 Beacon St for a report of a 4 vehicle MVA with possible injury. Upon arrival with the Fire Department and EMS, I met with all the drivers. No injuries were reported on scene. MV1 operator states she was driving WB on Beacon St when MV2 came to a sudden stop and due to the sun's glare, did not see MV2 very well. MV1 operator then rear-ended MV2. I did not observe any damage to the front of MV1 or the rear of MV2. MV2 operator states she was driving WB on Beacon St when MV1 suddenly collided with her rear end. MV2 subsequently rear-ended MV3. I did observe damage to the front of MV2 and to the rear of MV3. MV3 operator states he was stopped, waiting for the cars to go since the light had just turned green, when he was suddenly rear-ended by MV2. MV3 subsequently rear-ended MV4. I did observe damage to the front of MV3 and the rear of MV4. MV4 operator states she was stopped in traffic when she was suddenly rear-ended by MV3. No vehicles were towed. No citations were issued.
Keywords:
Citation, Ems, Fire, Glare, Solar
Dcc:
Glare, Unknown
Report
url:
Image
url:
Latitude:
42.3333408
Longitude:
-71.1719303
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);