crash_reports
2 rows where "datetime" is on date 2021-05-25, dcc = "["Unknown"]" and intersection = 0
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2021-05-25
Time:
13:40
Address:
272 CENTRE ST
Speed
limit:
35
Violation
cited:
no
Narrative:
ON 5/25/21 APPROXIMATELY 1340 I SPOKE TO KENNETH DAHLBECK WHO STATED HE WITNESSED A HIT AND RUN ACCIDENT. MR. DAHLBECK STATED MV#1 WAS PARKED ON THE STREET AT 272 CENTRE ST UNOCCUPIED AND WAS STRUCK BY MV#2 WHO WAS TURNING RIGHT OUT OF THE PARKING LOT. MR. DAHLBECK STATED THAT MV#2 LEFT THE SCENE. THERE WAS DAMAGE TO THE D/S REAR OF MV#1. I ATTEMPTED TO MAKE CONTACT WITH THE OWNERS OF BOTH VEHICLES WITH NEGATIVE RESULTS.
Keywords:
Crash
Dcc:
Unknown
Report
url:
Image
url:
Latitude:
42.3586868
Longitude:
-71.1848153
Location:
Case
number:
Date:
2021-05-25
Time:
18:24
Address:
1650 WASHINGTON ST
Speed
limit:
25
Violation
cited:
no
Narrative:
On 5/25/21, Newton Police responded to the rear parking lot of 1650 Washington St. for a past motor vehicle accident. Upon arrival, the vehicle owner of MV#1 stated she parked her vehicle, facing northbound in the rear parking lot at 0900 hrs. When she returned to her vehicle at 1800 hrs, there was a large scratch and scuff marks on the driver side front and rear door. Newton Police observed this damage and agree it is constant with either a sideswipe or collision with the front or rear bumper of another motor vehicle. The vehicle was not towed and was able to be driven from the scene. No surveillance cameras were observed in the immediate area.
Keywords:
Crash
Dcc:
Unknown
Report
url:
Image
url:
Latitude:
42.3417138
Longitude:
-71.2367944
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);