crash_reports
4 rows where keywords contains "Airbag" and "retrieved" is on date 2021-11-16
This data as json, CSV (advanced)
Suggested facets: date, intersection, speed_limit, keywords, dcc, dcc_code, 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-05
Time:
09:13
Address:
CENTRE ST & COMMONWEALTH AVE
Speed
limit:
30
Violation
cited:
no
Narrative:
THE OPERATOR OF MV#1 STATED HE WAS TRAVELING WEST-BOUND ON COMMONWEALTH AVE WITH A GREEN LIGHT WHEN HE STRUCK MV#2. THE OPERATOR OF MV#2 STATED HE WAS TRAVELING NORTH-BOUND ON CENTRE STREET, GOT STUCK IN THE INTERSECTION, OBSTRUCTED BY SOME TYPE OF BUS, WHEN HE STRUCK MV#1. BOTH OPERATORS HAD NO INJURIES. MV#1 HAD DAMAGE TO THE D/S FRONT AND MV#2 HAD DAMAGE TO THE P/S FRONT. MV#2 WAS TOWED BY TODYS TOWING. THERE WAS NO AIRBAG DEPLOYMENT. THERE WERE NO INJURIES DUE TO THIS ACCIDENT.
Keywords:
Airbag, Bus, Crash
Dcc:
Visibility obstructed
Report
url:
Image
url:
Latitude:
42.3365124
Longitude:
-71.1932597
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:
11:11
Address:
PARK ST & WASHINGTON ST
Speed
limit:
30
Violation
cited:
no
Narrative:
THE OPERATOR OF MV#1 STATED HE WAS TRAVELING EAST-BOUND ON WASHINGTON STREET WHEN MV#2 TOOK A LEFT TURN IN FRONT OF HIS VEHICLE. THE OPERATOR OF MV#2 STATED THAT HE WAS TRAVELING EAST-BOUND ON WASHINGTON ST WHEN HE TOOK A LEFT TURN IN FRONT OF MV#1. MV#1 WAS IN THE LEFT LANE AND MV#2 WAS IN THE RIGHT LANE. THERE WAS FRONT END DAMAGE TO MV#1 AND DRIVER SIDE DAMAGE TO MV#2. MV#1 WAS TOWED BY TODY'S TOWING. THERE WAS NO AIRBAG DEPLOYMENT.
Keywords:
Airbag
Dcc:
Failed to yield
Report
url:
Image
url:
Latitude:
42.3564943
Longitude:
-71.182511
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);