crash_reports
2 rows where "datetime" is on date 2021-10-30 and intersection = 0
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), dcc (array)
Case
number:
Date:
2021-10-30
Time:
14:24
Address:
165 NEEDHAM ST
Speed
limit:
15
Violation
cited:
no
Narrative:
The owner of MV1 stated she went into Stop and Shop at 1350 hrs and when she came back outside to her vehicle at 1408 hrs, her vehicle had been hit on the rear driver side. Her vehicle was parked, facing southbound. There was minor damage to the rear driver side of the bumper. Unknown who had struck her vehicle.
Keywords:
[]
Dcc:
Unknown
Report
url:
Image
url:
Latitude:
42.3121478
Longitude:
-71.2138224
Location:
Case
number:
Date:
2021-10-30
Time:
18:14
Address:
18 CLAFLIN PL
Speed
limit:
30
Violation
cited:
no
Narrative:
Vehicle 1 was legally parked along the curb in front of 18 Claflin PL. The owner of Vehicle 1 stated she noticed the front driver side bumper was cracked and caved in on 10-31-21. The damage was not there on 10-30-21 when the vehicle was parked there. It appears due to Claflin Pl. being a dead end, a vehicle attempted a 3 point like turn and backed into Vehicle 1. Vehicle 1 was unnoccupied and did not need to be towed. There is no information on the other involved vehicle.
Keywords:
[]
Dcc:
Unknown
Report
url:
Image
url:
Latitude:
42.3482792
Longitude:
-71.2057934
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);