crash_reports
3 rows where keywords = "[]" and "retrieved" is on date 2021-11-16
This data as json, CSV (advanced)
Suggested facets: intersection, hit_run, datetime (date), date (date), retrieved (date), dcc (array)
Case
number:
Date:
2021-10-27
Time:
19:51
Address:
1149 WASHINGTON ST
Speed
limit:
25
Violation
cited:
no
Narrative:
MV#1 was parked, unoccupied, facing eastbound in the area of 1155 Washington St. The operator stated he observed a "light" colored Tesla (unknown registration) which was parked in front of MV#1, back into the vehicle before continuing eastbound onto Washington St. A very small scratch was observed below the passenger side headlight. Incident documented for insurance purposes.
Keywords:
[]
Dcc:
Unknown
Report
url:
Image
url:
Latitude:
42.3495382
Longitude:
-71.2205749
Location:
Case
number:
Date:
2021-11-06
Time:
14:11
Address:
1148 CENTRE ST
Speed
limit:
25
Violation
cited:
no
Narrative:
Vehicle 1 was parked in a parking spot at 1148 Centre St. Owner saw a white SUV type vehicle back in to her vehicle and the drive away fleeing the area. There were no witnesses that came forward and no cameras in the area.
Keywords:
[]
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3329316
Longitude:
-71.1933784
Location:
Case
number:
Date:
2021-11-10
Time:
17:19
Address:
BOYLSTON ST & CHESTNUT ST
Speed
limit:
25
Violation
cited:
no
Narrative:
Operator of MV1 states she was traveling northbound on Chestnut St passing under the overpass bridge to Boylston St in congested traffic when MV2 struck MV1 on the drivers side of the vehicle. MV1 sustained damage to the left side corner panel. No injuries. Operator of MV2 states she was traveling eastbound on the short stretch of road between Quinobequin Rd and Chestnut St. Operator of MV2 states when entering the intersection to turn left onto Chestnut St, MV1 appeared coming from under the over pass bridge causing MV2 to collide with MV1. MV2 sustained front end damage and was towed from the scene. No injuries.
Keywords:
[]
Dcc:
Visibility obstructed
Report
url:
Image
url:
Latitude:
42.3169482
Longitude:
-71.2257627
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);