crash_reports
4 rows where dcc = "["Inattention"]", intersection = 0 and "retrieved" is on date 2021-11-16
This data as json, CSV (advanced)
Suggested facets: date, datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2021-11-03
Time:
11:03
Address:
791 WALNUT ST
Speed
limit:
25
Violation
cited:
no
Narrative:
Mv#1 was travelling on Walnut St S/B in the area of #762, slowing to a stop. Mv#2 operator was travelling directly behind #1 and rear ended #1. #2 could not stop in time as traffic was slowing to a stop. #1 sustained significant rear end damage. #1 operator was shaken up from impact, signed a patient refusal and was able to drive the vehicle away. #2 also sustained significant front end damage, both side airbags were deployed. #2 operator was not injured, signed a patient refusal and #2 was towed By Tody's.
Keywords:
Airbag, Crash
Dcc:
Inattention
Report
url:
Image
url:
Latitude:
42.3347705
Longitude:
-71.2088333
Location:
Case
number:
Date:
2021-11-06
Time:
11:16
Address:
40 BROOKS AVE
Speed
limit:
20
Violation
cited:
no
Narrative:
On November 6th, 2021 at approximately 11:16 hours while working N491 I responded to #40 Brooks Ave for a report of a MV crash. On my arrival I located one of the involved vehicles(#1), a 2013 Toyota Tacoma PU, NJ commercial plate, GUTR193. The operator who was standing outside of the truck stated that vehicle #2 was backing out from his driveway across the street #41 Brooks Ave, when he struck his companies truck which was parked in front of #40 Brooks Ave. Vehicle #2 was a gray 2000 Volvo S70, Ma plate 17EL24, operated by a Peter Lewitt. He was backing out of his driveway when backed into vehicle #1 which was parked across the street in front of #40 Brooks Ave. There were no injuries due to this accident and neither vehicle was towed.
Keywords:
Crash
Dcc:
Inattention
Report
url:
Image
url:
Latitude:
42.3524801
Longitude:
-71.2109682
Location:
Case
number:
Date:
2021-11-09
Time:
08:20
Address:
445 WASHINGTON ST
Speed
limit:
35
Violation
cited:
no
Narrative:
THE OPERATOR OF MV#1 STATED SHE WAS TRAVELING E/B ON WASHINGTON STREET WHEN SHE REAR-ENDED MV#2. THE OPERATOR OF MV#2 STATED SHE WAS STOPPED IN TRAFFIC WHEN SHE WAS REAR-ENDED BY MV#1. THERE WAS MAJOR FRONT-END DAMAGE TO MV#1 AND DAMAGED TO THE REAR END OF MV#2. MV#1 WAS TOWED BY TODY'S TOWING. THE OPERATOR OF MV#1 AND HER TWO PASSENGERS WERE TRANSPORTED TO NWH BY THE MEDICS FOR POSSIBLE INJURIES. MV#1 HAD FRONT AIRBAG DEPLOYMENT.
Keywords:
Airbag
Dcc:
Inattention
Report
url:
Image
url:
Latitude:
42.3559471
Longitude:
-71.1911042
Location:
Case
number:
Date:
2021-11-09
Time:
20:57
Address:
312 OTIS ST
Speed
limit:
25
Violation
cited:
no
Narrative:
MV1 was parked in front of 312 Otis St for a medical call and was struck by MV2 in a sideswipe manner. Operator 2 states he was backing the ambulance into the driveway of 312 Otis St when he struck MV1. Minimal damage to the rear drivers quarter panel of MV1 and minimal damage to MV2 rear passenger quarter panel. No injuries reported and photos taken to be attached to this report.
Keywords:
Ems, Pictures
Dcc:
Inattention
Report
url:
Image
url:
Latitude:
42.3450274
Longitude:
-71.2207178
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);