crash_reports
1 row where "date" is on date 2021-10-15 and longitude = "-71.2342846"
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2021-10-15
Time:
08:04
Address:
DERBY ST & MILO ST
Speed
limit:
30
Violation
cited:
no
Narrative:
ON 10-15-21 AT APPROX. 0804HRS. WHILE WORKING N492 I TOOK A REPORT FOR MOTOR VEHICLE ACCIDENT. UPON ARRIVAL AT THE INTERSECTION OF DERBY AND MILO ST. I SPOKE TO THE OPERATOR OF VEHICLE #1. DRIVER STATES SHE WAS TRAVELING E-BOUND ON DERBY ST. AS SHE APPROACHED THE INTERSECTION OF MILO AND DERBY SHE WAS BLINDED BY THE GLARE OF THE SUNLIGHT THAT WAS RISING IN THE EAST. DRIVER LOST SIGHT OF THE ROAD AND CRASHED INTO A LANDSCAPING TRAILER THAT WAS PARKED IN FRONT OF 258 DERBY ST. I SPOKE TO THE OWNER OF VEHICLE #2. THEY STATED THEY HEARD THE VEHICLE CRASH BUT DID NOT ACTUALLY SEE THE ACCIDENT. VEHICLE #1 HAD EXTENSIVE FRONT RIGHT END DAMAGE AND WAS TOWED BY PRIVATE TOW. VEHICLE #2 HAD NO DAMAGE AND WAS STILL OPERATIONAL. ALL PARTIES REPORTED NO INJURIES. ALL PARTIES ADVISED TO CONTACT THEIR INSURANCE COMPANIES. CLEARED WITHOUT FURTHER INCIDENT.
Keywords:
Crash, Glare, Severe, Solar
Dcc:
Glare
Report
url:
Image
url:
Latitude:
42.3599475
Longitude:
-71.2342846
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);