crash_reports
2 rows where keywords contains "Pictures" and "retrieved" is on date 2021-02-01
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (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-22
Time:
08:17
Address:
101 GRANT AVE
Speed
limit:
25
Violation
cited:
no
Narrative:
On January 22, 2021 at approximately 08:17 hours I responded to a single motor vehicle crash in the area of Commonwealth Ave at Grant Ave. It was reported that a motor vehicle struck a tree and a fire hydrant. Upon arrival I spoke with MV1, who said that she was traveling southbound on Grant Ave when she saw a vehicle traveling northbound traveling close to the solid double line. MV 1 got nervous and swerved to the right causing her to jump the curb and strike a city tree. MV1 then reversed into a fire hydrant, causing it to become dislodged. Traffic Officer Ciccone responded and took pictures of the damages and Tody's removed the vehicle from the scene.
Keywords:
Crash, Fire, Pictures, Tree
Dcc:
Over-steering
Report
url:
Image
url:
Latitude:
42.3360899
Longitude:
-71.1863701
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);