crash_reports
2 rows where "datetime" is on date 2019-01-02 and dcc contains "Unknown"
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array), dcc_code (array)
Case
number:
Date:
2019-01-02
Time:
10:15
Address:
250 BROOKLINE ST
Speed
limit:
10
Violation
cited:
no
Narrative:
MV1 was parked in the corner spot in the center island of the parking lot. MV2 was turning right around the MV to approach the dumpster and misjudged the distance and struck MV1. MV2 is a Waste Management truck contracted by the City of Newton. I took pictures and they were TOT IT.
Keywords:
Pictures
Dcc:
Unknown
Report
url:
Image
url:
Latitude:
42.3020871
Longitude:
-71.177714
Location:
Case
number:
Date:
2019-01-02
Time:
17:31
Address:
GROVE ST & WOODLAND RD
Speed
limit:
25
Violation
cited:
no
Narrative:
OPMV#1 Was traveling Northbound on Grove St when she came to a stop at the intersection of Grove St and Woodland Rd. OPMV#1 Stopped and then proceeded into the intersection and was struck by the OPMV#2. OPMV#1 Stated she stopped at the stop sign and was waiting for the other vehicle to go but they didn't move. So she started to move into the intersection and that's when she was struck by the OPMV#2. OPMV#2 Was traveling Westbound on Woodland Rd when she came to a stop at Woodland Rd and Grove St. OPMV#2 Stopped and then proceeded into the intersection and was struck by the OPMV#1. OPMV#2 Stated she stopped at the stop sign as the other vehicle did and happened to be entering the intersection at the same time when she was struck by the OPMV#1. Vehicle#1 was towed due to extensive damage. There were no injuries due to this accident.
Keywords:
Crash, Severe
Dcc:
Unknown
Report
url:
Image
url:
Latitude:
42.343275
Longitude:
-71.2485984
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);