crash_reports
2 rows where dcc = "["Inattention"]" and "retrieved" is on date 2021-03-05
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2021-03-01
Time:
05:54
Address:
CALIFORNIA ST & CRAFTS ST
Speed
limit:
30
Violation
cited:
no
Narrative:
Vehicle #1 a City of Newton Street Sweeper was traveling east on California St. at the intersection of California and Crafts when it stopped and reversed to go west in the east bound travel lane. At the same time Vehicle #2 was traveling south on Crafts St. and took a right turn to go east on California St. Once Vehicle #2 Made the turn onto California St. Vehicle #1 Reversed into its front end. Vehicle #1 sustained minor damage to its rear end. Vehicle #2 sustained minor damage to its front end. There were no injuries. Photos were taken of the damage and passed along to The Newton Police IT Bureau.
Keywords:
Pictures
Dcc:
Inattention
Report
url:
Image
url:
Latitude:
42.359357
Longitude:
-71.212863
Location:
Case
number:
Date:
2021-03-03
Time:
12:31
Address:
WASHINGTON ST & OFF RAMP
Speed
limit:
25
Violation
cited:
no
Narrative:
On 3/3/2021 at approx 1231hrs while assigned to 497 I responded to a crash in the area of Washington St near the 95 North Off ramp. Upon arrival I found Ma Reg L11012 a black Toyota pickup with extensive front right side damage and Ma Reg 6WE554 a black Mazda Sedan with extensive left side damage and airbag deployment in the center of Washington St. I spoke with the operator of the Mazda, Devon Ciriello who stated she was attempting to change into the left lane of Washington St EB, did not see the pickup colliding with it. I spoke with the operator of the Toyt, Gregory Antonioli who stated he was travelling EB on Washington St when the Mazda turned into his lane. Both signed patient refusals with Fallon Ambulance. Both vehicles towed by Todys.
Keywords:
Airbag, Crash, Ems, Severe
Dcc:
Inattention
Report
url:
Image
url:
Latitude:
42.3516966
Longitude:
-71.2078404
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);