crash_reports
1 row where "datetime" is on date 2020-03-06, dcc contains "Visibility obstructed" and intersection = 0
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2020-03-06
Time:
13:44
Address:
411 WATERTOWN ST
Speed
limit:
30
Violation
cited:
no
Narrative:
Operator #1 stated he was driving w/b on Watertown St just passing the Village Bank, #411 Watertown St when vehicle #2 backed out of the Village Bank parking lot causing the crash. Operator #1 later stated his view was blocked by a truck parked on Watertown St in front of the bank thus he never saw vehicle #2 backing out from the parking lot. Operator #2 stated he was attempting to back out from a parking space at #413 Watertown St when his vehicle was hit by vehicle #1 as he got out onto Watertown St. Operator #2 further reported that his view was obstructed by a truck that was parked facing west on Watertown St in front of the Village Bank. He never saw vehicle #2 coming as he was backing out onto Watertown St.
Keywords:
Crash
Dcc:
Visibility obstructed
Report
url:
Image
url:
Latitude:
42.3600229
Longitude:
-71.2026607
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);