crash_reports
2 rows where dcc contains "Visibility obstructed" and latitude = "42.3494467"
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2021-01-09
Time:
07:27
Address:
1321 WASHINGTON ST
Speed
limit:
20
Violation
cited:
no
Narrative:
ON 1-9-21 AT APPROX. 0727HRS. WHILE WORKING N492 I TOOK A REPORT FOR MOTOR VEHICLE ACCIDENT. UPON ARRIVAL AT THE REAR OF 1321 WASHINGTON ( NEWTON POLICE STATION PARKING LOT ) I SPOKE TO THE DRIVER OF VEHICLE #1. DRIVER STATES SHE WAS BACKING HER PERSONAL VEHICLE INTO ONE OF THE PARKING STALLS AT THE REAR OF THE POLICE STATION. SHE STATES WHILE BACKING SHE LIGHTLY TAPPED THE FRONT OF NEWTON POLICE VEHICLE 1309 WITH THE REAR OF HER VEHICLE. DRIVER STATES THERE WAS NO DAMAGE TO HER VEHICLE. THERE WAS A SLIGHT SCRAPE TO THE FRONT FENDER OF NEWTON VEHICLE 1309. DRIVER STATES HER VISIBILTY WAS OBSTRUCTED BY THE SUN SHINING IN THE REAR VIEW MIRROR. WHEN HER REAR PROXIMITY ALARM FAILED TO SOUND SHE THOUGHT SHE HAD CLEARED VEHICLE #2. APPROX. 8 PICTURES WERE TAKEN BY NEWTON 491 ( OFF CONARY ) AND WERE PLACED IN I.T. BOX. DRIVER REPORTED NO INJURIES. DRIVER ADVISED TO CONTACT HER INSURANCE COMPANY.
Keywords:
Crash, Pictures, Solar
Dcc:
Visibility obstructed
Report
url:
Image
url:
Latitude:
42.3494467
Longitude:
-71.2276058
Location:
Case
number:
Date:
2021-03-12
Time:
15:46
Address:
1321 WASHINGTON ST
Speed
limit:
15
Violation
cited:
no
Narrative:
Operator 1 was backing into a parking space behind 1321 Washington St when she struck unoccupied cruiser 492. Minor damage to the rear drivers quarter panel of N492. Minor damage to the rear passenger quarter panel of N526. No injuries reported, both vehicles were able to be driven from the scene.
Keywords:
[]
Dcc:
Visibility obstructed
Report
url:
Image
url:
Latitude:
42.3494467
Longitude:
-71.2276058
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);