crash_reports
1 row where "retrieved" is on date 2021-01-25 and speed_limit = 10
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2021-01-21
Time:
09:19
Address:
1250 WASHINGTON ST
Speed
limit:
10
Violation
cited:
no
Narrative:
ON 1-21-21 AT APPROX. 0919HRS. WHILE WORKING N492 I TOOK A REPORT FOR MOTOR VEHICLE ACCIDENT. UPON ARRIVAL AT 1250 WASHINGTON ST. ( DUNKIN DONUTS LOT ) I SPOKE TO THE OWNER OF VEHICLE #1. OWNER STATES HE HAD PARKED HIS VEHICLE ON THE LOT AND WAS ENTERING 1250 WASHINGTON ST TO GET A COFFEE. WHILE ENTERING HE SAW VEHICLE #2 ENTER THE LOT QUICKLY AND HIT THE LEFT REAR OF HIS PARKED MOTOR VEHICLE PUSHING HIS TRUCK OUT OF THE PARKING STALL AND INTO A CEMENT WALL. OWNERS GIRLFRIEND ( CAROLINE FITZGERALD) WAS IN THE FRONT SEAT PASSENGER SIDE WHEN THE CRASH OCCURRED. I SPOKE TO THE OPERATOR OF VEHICLE #2. DRIVER STATES HE WAS ENTERING THE PARKING LOT AT 1250 WASHINGTON ST. WHEN THE ACCELERATOR ON HIS VEHICLE GOT STUCK IN ACCELERATE AND HE WAS UNABLE TO AVOID HITTING VEHICLE #1. VEHICLE #1 HAD REAR LEFT AND FRONT RIGHT DAMAGE. VEHICLE #1 WAS STILL OPERATIONAL. VEHICLE #2 HAD FRONT LEFT END DAMAGE AND WAS TOWED BY TODYS. ALL PARTIES REPORTED NO INJURIES. THE PASSENGER OF VEHICLE #1 AND THE DRIVER OF VEHICLE #2 WERE EXAMINED BY THE MEDICS AND SIGNED PATIENT REFUSALS. THERE WAS NO DAMAGE TO THE PROPERTY AT 1250 WASHINGTON ST. CLEARED WITHOUT FURTHER INCIDENT.
Keywords:
Crash
Dcc:
Inattention
Report
url:
Image
url:
Latitude:
42.3491465
Longitude:
-71.2248445
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);