crash_reports
3 rows where "datetime" is on date 2021-01-26, dcc = "[]" and intersection = 0
This data as json, CSV (advanced)
Suggested facets: speed_limit, datetime (date), date (date), retrieved (date), keywords (array)
Case
number:
Date:
2021-01-26
Time:
16:48
Address:
23 NEEDHAM ST
Speed
limit:
10
Violation
cited:
no
Narrative:
Operator of MV1 backed into a pole anchor wire in the parking lot behind NewTV causing no damage to the pole and minor damage to the rear bumper of N499.
Keywords:
[]
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3163977
Longitude:
-71.2109845
Location:
Case
number:
Date:
2021-01-26
Time:
19:47
Address:
80 CHARLESBANK RD
Speed
limit:
25
Violation
cited:
no
Narrative:
On 1/26/2021, Newton Fire and Police were dispatched to Charlesbank Rd. and St. James St. for a single motor vehicle collision. Upon arrival, I observed Motor Vehicle #1 parked in the roadway with damage to its front end and under carriage. The operator stated; due to the snowy, wet, slippery conditions, her vehicle slid into the concrete median. The operator reported no injuries, however the vehicle was towed away from the scene by Tody's Towing Service.
Keywords:
Fire, Snow
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3585654
Longitude:
-71.1797224
Location:
Case
number:
Date:
2021-01-26
Time:
17:30
Address:
60 WEBSTER ST
Speed
limit:
25
Violation
cited:
no
Narrative:
On January 26, 2021 at approximately 1730 hours the weather condition at the time was snowy and the road conditions were slippery. Reporting party is the resident of 66 Webster St, and the property between 56 to 66 Webster St is maintained by the condo association. MV1 was operating on Webster St (a public way). MV1 struck two fences in front of 60 Webster St, causing an unknown amount of damage. The reporting party stated MV1 operator exited the vehicle and exchanged information. The reporting party wanted to notify Newton Police for insurance reasons.
Keywords:
Snow
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3498973
Longitude:
-71.2289777
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);