crash_reports
3 rows where dcc = "[]", intersection = 0 and "retrieved" is on date 2021-02-01
This data as json, CSV (advanced)
Suggested facets: hit_run, 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-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);