crash_reports
1 row where "datetime" is on date 2020-05-16, dcc = "["Unknown"]" and keywords contains "Phone"
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2020-05-16
Time:
10:57
Address:
23 LAKEWOOD RD
Speed
limit:
5
Violation
cited:
no
Narrative:
Mv#1 owner stated he parked his Mv on Lakewood Rd (opposite #23 driveway) at about 1000hrs this date. Owner stated he returned to his unoccupied parked Mv at about 1045hrs to find fresh light moderate driver's side front end damage with light scrape marks. A witness from #32 left a note indicating a beige or tan Range Rover unknown plates (Mv#2) backed into that front left bumper. I raised the witness who further stated she was on her porch and heard a noise but didn't see a collision. She stated it (#2) backed out from the driveway and observed it perpendicular to #1 trying to maneuver away from it and drive away. I raised occupant of #23 and spoke to #2 operator who was not on scene by cell phone. #2 operator was unaware of any collision. #2 texted pictures of his Mv's rear bumper. One picture appeared to show a light colored scrape on driver's side upper rear end. Mv#1 is dark blue. Mv#2 is bronze. Both parties agreed to exchange information. Both parties were advised the matter would be documented and to proceed further with their respective insurance companies.
Keywords:
Moderate, Phone, Pictures
Dcc:
Unknown
Report
url:
Image
url:
Latitude:
42.3261036
Longitude:
-71.2046099
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);