crash_reports
2 rows where "datetime" is on date 2021-09-15, dcc = "["Inattention"]" and dcc_code = "[19]"
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), dcc (array)
Case
number:
Date:
2021-09-15
Time:
13:50
Address:
LEXINGTON ST & RIVER ST
Speed
limit:
25
Violation
cited:
no
Narrative:
The operator of MV#1 stated that he was stopped in traffic north bound on Lexington St near River St when he was rear ended by MV#2. The operator of MV#2, stated through a friend who arrived on the scene to interpret for him, that he was also traveling north on Lexington St directly behind MV#1 when he lost focus and rear ended MV#1. Operator #2 provided a Brazilian license and stated that he is a student and only in this country temporarily. No injuries and no tows.
Keywords:
[]
Dcc:
Inattention
Report
url:
Image
url:
Latitude:
42.357825
Longitude:
-71.2396119
Location:
Case
number:
Date:
2021-09-15
Time:
17:27
Address:
MANDALAY RD & WAVERLEY AVE
Speed
limit:
25
Violation
cited:
no
Narrative:
All Vehicles were traveling southbound on Waverly Ave approaching Ward St. MV2 rear ended MV3 causing a chain reaction and MV3 hitting MV1. MV2 was the vehicle that caused the chain reaction. Operator of MV1 was transported for evaluation. All vehicles drove away.
Keywords:
[]
Dcc:
Inattention
Report
url:
Image
url:
Latitude:
42.3408401
Longitude:
-71.1828723
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);