crash_reports
2 rows where dcc contains "Unknown" and "retrieved" is on date 2021-01-17
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2021-01-07
Time:
11:03
Address:
CHESTNUT ST & ELLIOT ST
Speed
limit:
25
Violation
cited:
no
Narrative:
Roselourdes Pierreadrien was operating vehicle #2 S/B on Chestnut St. Roselourdes states that she had a green light and was proceeding through the intersection and was struck on the right side by vehicle #1. Roselourdes vehicle rolled over and landed on its roof. Lourdes was able to free herself from the vehicle prior to my arrival. Stuart Schneller was operating vehicle #1 on Elliot St E/B. Stuart stated that he believed he had a green light when proceeding through the intersection. Both parties suffered injures and had a hard time recalling what had happened. Both parties transported to NWH and both vehicles towed by Tody's Off. Kane was on a detail nearby. Off. Kane states that she did not see the accident happen but heard it. Off. Kane then saw vehicle #2 roll onto its roof. Off. Kane then went over to the vehicle, broke the drivers side window, cut open the airbag and assisted Roselourdes from the vehicle. Off. Kane went to NWH for injuries to her hands where she was eventually discharged.
Keywords:
Airbag, Crash
Dcc:
Unknown
Report
url:
Image
url:
Latitude:
42.3128144
Longitude:
-71.2246681
Location:
Case
number:
Date:
2021-01-08
Time:
16:28
Address:
141 NEEDHAM ST
Speed
limit:
5
Violation
cited:
no
Narrative:
On January 8, 2021 at approximately 16:28 hours I, Officer Guarino, responded to the parking lot of 141 Needham St for a report of a MVA hit and run. Upon arraival, I spoke with the operator of MV1, who showed me a dent on the front driver's side of her vehicle. There was minor scratches and no visible paint transfer around the dent. The vehicle was parked in a handicapped parking spot adjacent to a cross walk. The operator of MV1 said that she had washed the vehicle last week and had just noticed the dent when she exited the store and that she would have noticed the damage when she entered. There were no visible cameras in the area that would have footage of the incident.
Keywords:
Walk
Dcc:
Unknown
Report
url:
Image
url:
Latitude:
42.3131214
Longitude:
-71.212987
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);