crash_reports
2 rows where date = "2020-01-16" and keywords contains "Citation"
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2020-01-16
Time:
10:30
Address:
1000 COMMONWEALTH AVE
Speed
limit:
5
Violation
cited:
yes
Narrative:
Witness stated he observed Mv#1 attempting to parallel park between two parked cars in the City Hall roundabout 1000 Commonwealth Ave. Witness stated #1 struck both cars during the unsuccessful attempt to park and left to go park in another spot. #1 passenger side front sideswiped Mv#2 driver's side rear; #1 driver's side rear end struck Mv#3 driver's side front end. #1 operator was located at the other parking spot. #1 stated he was unaware he struck both cars. #1 cited for failing to use care stopping starting and turning CO Ch19/Sec75.
Keywords:
Citation
Dcc:
Inattention
Report
url:
Image
url:
Latitude:
42.3373691
Longitude:
-71.2088415
Location:
Case
number:
Date:
2020-01-16
Time:
20:23
Address:
WALNUT ST & STONEY BREA RD
Speed
limit:
25
Violation
cited:
yes
Narrative:
Based on observations and statements made, the following occured. M/V#1 was traveling south on Walnut St. when M/V#2, traveling east on Stoney Brea Rd. attempted to cross Walnut St. and collided with M/V#1. The operator of M/V#2 stated that he was traveling east on Stoney Brea Rd. when M/V#1 came out of no where and collided with him. It should be noted that the stop sign at Stoney Brea Rd and Walnut St. is missing. The operator of M/V#2 was issued citation # T2013115 MGL Ch 89 s 8 Failure to yield.
Keywords:
Citation
Dcc:
Failed to yield
Report
url:
Image
url:
Latitude:
42.3172436
Longitude:
-71.2026793
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);