crash_reports
3 rows where "datetime" is on date 2021-01-28 and "retrieved" is on date 2021-02-01
This data as json, CSV (advanced)
Suggested facets: intersection, hit_run, violation_cited, dcc, dcc_code, datetime (date), date (date), retrieved (date), dcc (array)
Case
number:
Date:
2021-01-28
Time:
12:26
Address:
180 NEEDHAM ST
Speed
limit:
25
Violation
cited:
no
Narrative:
Njavan Stewart-Okiwe states that he was operating vehicle #2 N/B on Needham St. Njavan came to a stop and vehicle #1 backed into him. Jill Fallon was operating vehicle #1 N/B on Needham St. Jill states that she was attempting to take a left turn into a parking lot. Jill states that there was a semi trailer coming out of the parking lot attempting to take a right turn S?B on Needham St. Jill states that she backed up so the semi trailer could make the turn but she did not see vehicle #2. Jill stated that it was her fault but she didn't see the car. No injures, no tows.
Keywords:
[]
Dcc:
Inattention
Report
url:
Image
url:
Latitude:
42.3116053
Longitude:
-71.2130334
Location:
Case
number:
Date:
2021-01-28
Time:
16:57
Address:
BRIDGE ST & WATERTOWN ST
Speed
limit:
25
Violation
cited:
yes
Narrative:
Operator of MV1 stated he was facing northbound on Bridge St. at the stop sign. Operator of MV1 then proceeded to enter Watertown Street, turning left, eastbound when he struck MV2. Operator of MV2 stated while traveling eastbound on Watertown St MV1 pulled out on to Watertown St and struck the front bumper of the vehicle. MV1 had minor damage to the hood. MV2 sustained major damage to the front bumper, hood and head lights. MV2 was towed by Todys Towing. Due to a language barrier with Operator of MV2, her friend Leilian Olivira translated.
Keywords:
[]
Dcc:
Inattention
Report
url:
Image
url:
Latitude:
42.3604294
Longitude:
-71.20168
Location:
Case
number:
Date:
2021-01-28
Time:
18:45
Address:
21 COTTAGE PL
Speed
limit:
25
Violation
cited:
no
Narrative:
Owner of vehicle 1 states it was parked, unoccupied in front of 21 Cottage Pl. A loud noise was heard. Owner of vehicle 1 checked vehicle and noticed left rear had new scratches and dents. It should be noted owner of vehicle 1 saw an amazon delivery van driving down the street after loud noise was heard. Owner of vehicle 1 called amazon to file claim and obtain delivery/GPS locations. Owner of vehicle 1 called their insurance company, who then requested a police report be filed.
Keywords:
[]
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3535068
Longitude:
-71.2312952
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);