crash_reports
1 row where "datetime" is on date 2019-12-21, intersection = 0 and keywords contains "Severe"
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2019-12-21
Time:
15:41
Address:
1201 COMMONWEALTH AVE
Speed
limit:
30
Violation
cited:
no
Narrative:
ON 12-21-19 AT APPROX. 1541HRS. WHILE WORKING N492 I TOOK A REPORT FOR MOTOR VEHICLE ACCIDENT. UPON ARRIVAL AT 1201 COMMONWEALTH AVE. I SPOKE TO THE OPERATOR OF VEHICLE #1. DRIVER STATES SHE WAS TRAVELING E-BOUND ON COMM AVE. WHEN SHE SAW VEHICLE #2 CROSS THE DOUBLE YELLOW LINE AND HIT HER VEHICLE. VEHICLE #2 STATES HE WAS TRAVELING W-BOUND ON COMM AVE. HE REACHED FOR AN ITEM ON HIS PASSENGER SIDE FLOOR. HE STATES WHILE DOING SO HE LOST CONTROL OF HIS VEHICLE, CROSSED THE YELLOW LINE AND HIT VEHICLE #1. THERE WAS A WITNESS ON SCENE WHO STATED HE WAS TRAVELING E-BOUND ON COMM AVE. BEHIND VEHICLE #1. WHILE DRIVING HE SAW VEHICLE #2 CROSS THE YELLOW LINE AND HIT VEHICLE #1. VEHICLE #1 HAD EXTENSIVE LEFT SIDE DAMAGE AND AIRBAG DEPLOYMENT. VEHICLE #2 HAD EXTENSIVE LEFT SIDE DAMAGE AND AIRBAG DEPLOYMENT. ALL PARTIES REPORTED NO INJURIES AND SIGNED PATIENT REFUSALS. BOTH VEHICLES WERE TOWED BY TODYS. BASED ON THE TESTIMONIES OF BOTH DRIVERS AS WELL AS THE WITNESS OBSERVATIONS THE OPERATOR OF VEHICLE #2 WAS MAILED A CITATION ( T2079756, 89/4A, MARKED LANES VIOLATION ). ALL PARTIES ADVISED TO CONTACT THEIR INSURANCE COMPANIES.
Keywords:
Airbag, Citation, Crash, Severe
Dcc:
Lane departure
Report
url:
Image
url:
Latitude:
42.3372756
Longitude:
-71.216166
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);