crash_reports
2 rows where "datetime" is on date 2019-05-28, dcc = "[]" and intersection = 0
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array)
Case
number:
Date:
2019-05-28
Time:
08:39
Address:
697 WASHINGTON ST
Speed
limit:
25
Violation
cited:
no
Narrative:
Operator of vehicle one stated that while driving west bound near 697 Washington St her vehicle's passenger side mirror struck vehicle's two driver's side mirror. Operator of vehicle one stated that a large truck that was driving next to her vehicle west bound that was coming close to her vehicle. Vehicle two was parked unoccupied in front of 697 Washington St. Vehicle's one's passenger mirror was damaged and vehicle's two was not damaged. Neither vehicle required a tow and operator of vehicle one stated that she was not injured. I took photos of both vehicles and forward the disk to the NPD's IT Bureau.
Keywords:
Pictures
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3529253
Longitude:
-71.2021966
Location:
Case
number:
Date:
2019-05-28
Time:
21:58
Address:
330 ELLIOT ST
Speed
limit:
30
Violation
cited:
no
Narrative:
MV1 was parked eastbound at 330 Elliot St when it was struck by MV3 in the rear left corner. MV1 was pushed forward into the rear of MV2. Both vehicles were unoccupied. Reporting party stated MV3 was possibly a dark colored SUV, unknown registration, that fled the scene eastbound on Elliot. Officers checked the surrounding area for a dark colored SUV with front end damage with negative results. MV1 sustained heavy damage to the left rear corner and was towed from the scene by Tody's. MV2 sustained very minor damage to the rear end. Towed motor vehicle inventory form was filled out and submitted.
Keywords:
[]
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3127458
Longitude:
-71.2231738
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);