crash_reports
2 rows where intersection = 1 and "retrieved" is on date 2021-06-14
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), dcc (array)
Case
number:
Date:
2021-06-11
Time:
09:20
Address:
CRAFTS ST & NORTH ST
Speed
limit:
30
Violation
cited:
no
Narrative:
ON 6-11-21 AT APPROX. 0920HRS. WHILE WORKING N492 I TOOK A REPORT FOR HIT AND RUN PROPERTY DAMAGE. UPON ARRIVAL AT THE INTERSECTION OF CRAFT AND NORTH ST. I NOTICED THAT THE TRAFFIC SIGNAL POLE HAD BEEN KNOCKED DOWN. REPORTING PARTY STATED THAT AN UNIDENTIFIABLE MOVING TRUCK HAD TAKEN A RIGHT TURN FROM NORTH ONTO CRAFT AND TOOK THE POLE DOWN. MOVING TRUCK WAS NO LONGER IN THE AREA. DAEGLE WAS NOTIFIED TO RESET THE TRAFFIC SIGNAL POLE. CLEARED WITHOUT FURTHER INCIDENT.
Keywords:
[]
Dcc:
Inattention
Report
url:
Image
url:
Latitude:
42.35977
Longitude:
-71.2156285
Location:
Case
number:
Date:
2021-06-11
Time:
13:47
Address:
WASHINGTON TER & WASHINGTON ST
Speed
limit:
25
Violation
cited:
no
Narrative:
Operator of V1 stated she was traveling east on Washington Street, turned left onto Washington Terr and had contact with V2. Operator of V2 stated she just pulled out of the parking space on the westbound lane of Washington Street she was traveling straight and V1 turned into her vehicle. All parties advised of the process, and there were no reported injuries.
Keywords:
[]
Dcc:
Unknown
Report
url:
Image
url:
Latitude:
42.3512902
Longitude:
-71.2091542
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);