crash_reports
1 row where "date" is on date 2021-02-09, dcc_code = "[99]" and "retrieved" is on date 2021-02-19
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), dcc (array)
Case
number:
Date:
2021-02-09
Time:
11:06
Address:
164 VARICK RD
Speed
limit:
25
Violation
cited:
no
Narrative:
I responded to the area of Varick Rd@Quinobequin Rd. on 02/09/2021 at approx. 1106 hrs for a report of a past MVA/HR. I arrived in the area and was flagged down by vehicle owner De-Souza, Fernanda MA OLN#S64319275. She was with her vehicle MA Reg. 7115ZS; 2016 Niss/Murano color Red. The vehicle was parked on Varick Rd. directly in front of #164 Varick Rd. The vehicle had visible damage all along the drivers side which was facing the street. The vehicle appeared to have been sideswiped (probably by a plow truck). According to De-Souza the vehicle was parked unoccupied since approximately 0900 hrs to present. The MVA was unwitnessed and as of the time of this report no witnesses have been identified. The vehicle sustained body damage along the full length of the drivers side. The vehicle did not require towing service. De-Sousza has been advised to contact her insurance co. and a MVA report would be documented.
Keywords:
[]
Dcc:
Unknown
Report
url:
Image
url:
Latitude:
42.3246288
Longitude:
-71.2446111
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);