crash_reports
4 rows where dcc = "[]" and "retrieved" is on date 2021-02-01
This data as json, CSV (advanced)
Suggested facets: date, intersection, speed_limit, hit_run, violation_cited, keywords, datetime (date), date (date), retrieved (date), keywords (array)
Case
number:
Date:
2021-01-20
Time:
13:29
Address:
200 BOYLSTON ST
Speed
limit:
0
Violation
cited:
no
Narrative:
The operator of MV1 stated she parked her department of public works city vehicle, MA REG M7917A in the public parking lot of Wegmans located at 200 Boylston street at 1pm and when she came back to her vehicle around 2pm she noticed minor damage to the drivers side panel. MV1 stated there were no witnesses and she does not recall what vehicle was parked next to her. There are no cameras in the area. Pictures of the damage were taken and submitted to the IT Bureau. MV1 was able to leave the scene without further incident.
Keywords:
Pictures
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3191343
Longitude:
-71.1756718
Location:
Case
number:
Date:
2021-01-26
Time:
16:48
Address:
23 NEEDHAM ST
Speed
limit:
10
Violation
cited:
no
Narrative:
Operator of MV1 backed into a pole anchor wire in the parking lot behind NewTV causing no damage to the pole and minor damage to the rear bumper of N499.
Keywords:
[]
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3163977
Longitude:
-71.2109845
Location:
Case
number:
Date:
2021-01-26
Time:
19:47
Address:
LEXINGTON ST & STANIFORD ST
Speed
limit:
25
Violation
cited:
yes
Narrative:
MV1 operator stated she attempted to stop at the Staniford St at Lexington St (both public ways) stop sign. However, due to the snowy and slippery road conditions, MV1 operator stated she was unable to stop. MV1 operator entered Lexington St and sideswiped (opposite directions) MV3. MV1 sustained front bumper damage (no tow required), no injury reported at this time. MV2 operator stated he was driving northbound on Lexington St when he observed MV1 unable to stop at the Staniford St stop sign. MV2 operator stated he swerved to the right to avoid collision. MV2 jumped the right side curb, sideswiped a tree and ended in the bushes of 236 Lexington St. MV2 sustained front end damage to the MV and plow, and driver side (no tow required). No injuries reported at this time. MV3 operator stated she was operating southbound on Lexington St when she obserbed MV1 enter Lexington St. However, due to the weather conditions, MV3 was unable to stop in time and sideswiped MV1 (opposite direction) and sustain front bumper damage (no tow required). No injuries reported at this time.
Keywords:
Bus, Snow, Tree
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.35368
Longitude:
-71.244894
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);