crash_reports
3 rows where "datetime" is on date 2019-01-25, dcc = "[]" and intersection = 0
This data as json, CSV (advanced)
Suggested facets: speed_limit, hit_run, datetime (date), date (date), retrieved (date), keywords (array)
Case
number:
Date:
2019-01-25
Time:
13:35
Address:
74 BOWERS ST
Speed
limit:
25
Violation
cited:
no
Narrative:
On Friday 01/25/2019 at appx. 1:30 PM while on patrol in N 491 I was dispatched to 74 Bowers St for a report of a past hit and run. On arrival I spoke to Jamie Juskiewicz who stated she parked her vehicle legally around 11:30 AM. When she came back to her vehicle around 1:30 PM she realized that an unknown person struck her vehicle causing moderate damage to the drivers side and bumper. I did not observe any surveilance cameras and there were no witnesses. The other operator did not leave a note.
Keywords:
Moderate
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3511174
Longitude:
-71.2054164
Location:
Case
number:
Date:
2019-01-25
Time:
17:45
Address:
1743 BEACON ST
Speed
limit:
25
Violation
cited:
no
Narrative:
On January 25, 2019 at approximately 17:46 I responded to a motor vehicle hit and run. It was reported that a white pick-up truck crashed into a parked car and left the scene. I checked the area and was unable to find a vehicle matching the description. I responded to the crash location and spoke with the owner of MV1, who was not with his vehicle when it was struck. MV1 was parked legally on the shoulder of by 1743 Beacon St. The vehicle that struck MV1 left the travel lane and struck MV1 in the driver's side rear, causing damage. I spoke with the reporting party, Tim Leary, who heard the crash and saw a white Ford F-150 leaving the scene with damage on front passenger side. Leary did not see the license plate of the truck but thinks it was the 2006-2012 body style. The owner of MV1 was going to arrange for a private tow at a later time.
Keywords:
Crash
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3268914
Longitude:
-71.2349317
Location:
Case
number:
Date:
2019-01-25
Time:
13:42
Address:
43 GATE HOUSE RD
Speed
limit:
10
Violation
cited:
no
Narrative:
Operator 1 states she pulled into the driveway of 43 Gatehouse Rd. while pulling in her vehicle slid on a sheet of ice and slid into the garage. Tody's towing was called to remove the car from the garage. The vehicle and garage sustained minor damage and there were no injuries.
Keywords:
Ice
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3324596
Longitude:
-71.1643234
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);