crash_reports
2 rows where "datetime" is on date 2022-05-18, intersection = 0 and "retrieved" is on date 2022-05-31
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), dcc (array)
Case
number:
Date:
2022-05-18
Time:
05:43
Address:
1450 WASHINGTON ST
Speed
limit:
35
Violation
cited:
no
Narrative:
I responded to the area of 1450 Washington St for a report of an MVA/no injuries. I arrived on location and spoke with both operators. V1; NH Reg 9763AP, 2018 PTRB Truck color white. V1 operator; Ronald Cambria MA OLN#S29121402. V2; MA CON Reg W56789, 2020 Chev/PU color orange. V2 operator, Tony Bizarro MA OLN#S57968875. The two vehicles had a minor collision as they were both traveling parallel/ same direction eastbound on Washington St. V1 operator stated he was attempting to change lanes left to right. V2 was hit in the rear drivers side just behind the wheel well. minor damage was sustained. V1 sustained scratches along the front passenger side tire rim. There were no injuries reported as a result of the collision. Towing service was not required for either vehicle..
Keywords:
[]
Dcc:
Unknown
Report
url:
Image
url:
Latitude:
42.3465495
Longitude:
-71.2315075
Location:
Case
number:
Date:
2022-05-18
Time:
19:04
Address:
126 CHAPEL ST
Speed
limit:
0
Violation
cited:
no
Narrative:
V1 was parked behind 126 Chapel Street. Sometime after 11:00, V1 was struck by another vehicle. That unknown vehicle hit, ran and did not leave information behind. Report taken for insurance purposes.No cameras in the area.
Keywords:
[]
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3611226
Longitude:
-71.2001064
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);