crash_reports
1 row where "datetime" is on date 2021-04-07, dcc = "["Other improper action"]" and keywords contains "Crash"
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2021-04-07
Time:
11:54
Address:
WALKER ST & WATERTOWN ST
Speed
limit:
30
Violation
cited:
no
Narrative:
ON 4-7-21 AT APPROX. 1154HRS. WHILE WORKING N492 I TOOK A REPORT FOR MOTOR VEHICLE ACCIDENT HIT-AND-RUN. UPON ARRIVAL AT WATERTOWN ST AND WALKER ST. I SPOKE TO THE OPERATOR OF VEHICLE #1. DRIVER STATES SHE WAS HEADED W-BOUND ON WATERTOWN ST. AND STOPPED AT THE RED LIGHT. DRIVER STATES VEHICLE #2 PULLED UP TO THE LEFT OF HER. AT THIS TIME THE PASSENGER IN THE REAR OF VEHICLE #2 OPENED THE RIGHT PASSENGER SIDE DOOR AND HIT HER VEHICLE. SHE STATES THE PASSENGER CLOSED THE DOOR AND VEHICLE #2 TOOK A LEFT TURN ONTO WALKER AND SPED AWAY. DRIVER STATES SHE EXITED HER VEHICLE AND NOTICED DAMAGE TO THE LEFT REAR QTR. PANEL OF HER VEHICLE. DRIVER STATES SHE WAS UNABLE TO GET A LICENSE PLATE OF VEHICLE #2. DRIVER OF VEHICLE #1 REPORTED NO INJURIES. SHE HAD DAMAGE TO THE LEFT SIDE QTR. PANEL OF HER VEHICLE. ADVISED TO CONTACT HER INSURANCE COMPANY. CLEARED WITHOUT FURTHER INCIDENT.
Keywords:
Crash, Walk
Dcc:
Other improper action
Report
url:
Image
url:
Latitude:
42.3546945
Longitude:
-71.2121576
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);