crash_reports
2 rows where "datetime" is on date 2021-02-12, intersection = 0 and "retrieved" is on date 2021-02-22
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2021-02-12
Time:
16:47
Address:
330 LINWOOD AVE
Speed
limit:
25
Violation
cited:
no
Narrative:
MV1, was parked outside house #330 on Linwood Avenue between the hours of 0800-1430hrs. When reporting party, Rielly Smolinsky returned to her vehicle (owned/registered to her father, Edward Smolinsky) after 1430hrs, MV1 had significant damage to its front driver side, over the tire area. The vehicle was not disabled and no injuries reported as it was unoccupied. At this time, no one has claimed responsibility for damaging MV1.
Keywords:
[]
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.357234
Longitude:
-71.2109682
Location:
Case
number:
Date:
2021-02-12
Time:
23:25
Address:
996 WALNUT ST
Speed
limit:
30
Violation
cited:
yes
Narrative:
Operator of MV1 states he was traveling northbound on Walnut Street at a speed of approximately 45mph when he struck the snowbank with the front right tire causing the vehicle to leave the roadway, hit the utility pole and come to rest on the hood of the vehicle in the front yard of 996 Walnut Street. Operator of MV1 stated he was coming from a friends house where he consumed two alcoholic beverages. Operator of MV1 sustained injuries to his hand and forehead and was evaluated by Fallon medics who recommended transport to the hospital due to the severity of the crash. Pictures were taken of the scene. Tody's towing responded and took possession of the vehicle. Towed motor vehicle inventory form completed. Verizon and Eversource were notified for the utility pole. I issued Massachusetts Uniform Citation #T2012865 for the following: MGL Ch. 90 Sec. 24 OUI Alcohol, MGL Ch. 90 Sec. 24 (2) Operating to Endanger, Negligent, MGL Ch. 89 Sec. 4A Marked Lanes Violation and MGL Ch. 90 Sec. 17 Speeding greater than reasonable
Keywords:
Alcohol, Citation, Crash, Hospital, Pictures, Snow, Speed
Dcc:
Speeding, Reckless driving
Report
url:
Image
url:
Latitude:
42.3271198
Longitude:
-71.2060023
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);