crash_reports
2 rows where "datetime" is on date 2019-07-18, dcc = "[]" and intersection = 0
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array)
Case
number:
Date:
2019-07-18
Time:
11:24
Address:
85 BORDER ST
Speed
limit:
25
Violation
cited:
no
Narrative:
On 07/18/2019 Gladys Bisono came into NPD Headquarters to report a past-hit and run. Bisono states that between 1500hrs on 7/13/2019 and 1100hrs on 7/14/2019 her leased vehicle (Vehicle 1) was parked and unoccupied on the eastbound side of Border St near 85 Border St. During this time frame an unknown vehicle (Vehicle 2) struck vehicle 1. As a result of the impact Vehicle 1 sustained damage to its front end and front bumper. Vehicle 2 left the scene with out leaving any identifying information. No injuries were reported. No vehicles were towed. Bisono has since reported the crash to her insurance company who advised her to file a police report. At this time the identity of Vehicle 2 and its operator is unknown. Border St is a public way in the city of Newton.
Keywords:
Crash
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3484567
Longitude:
-71.2330765
Location:
Case
number:
Date:
2019-07-18
Time:
13:34
Address:
251 ADAMS ST
Speed
limit:
30
Violation
cited:
no
Narrative:
OPERATOR #1 STATED SHE WAS TRAVELLING N/B ON ADAMS ST JUST PASSED MIDDLE ST WHEN SHE HAD TO GO AROUND A PARKED UPS TRUCK. HOWEVER DUE TO ANOTHER VEHICLE COMING FROM THE OPPOSITE DIRECTION(S/B) SHE HAD TO MOVE OVER A LITTLE TO THE RIGHT TO AVOID THE ONCOMING VEHICLE, WHICH CAUSED HER TO SIDE SWIPE THE PARKED UPS TRUCK. THE UPS DRIVER WAS WITH THE TRUCK AT THE TIME OF THE CRASH. BOTH PARTIES HAD ALREADY EXCHANGED INFORMATION AND PHOTOGRAPHED THE DAMAGES TO THE VEHICLES. UPS SUPERVISOR WAS ALSO ON SCENE PRIOR TO MY ARRIVAL.
Keywords:
Crash, Pictures
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3568505
Longitude:
-71.1986229
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);