crash_reports
2 rows where "date" is on date 2019-06-22 and hit_run = 0
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2019-06-22
Time:
09:30
Address:
WALNUT ST & MADISON AVE
Speed
limit:
30
Violation
cited:
no
Narrative:
OPERATOR #1 STATED HE WAS GOING N/B ON WALNUT NEAR MADISON AVE ST WHEN HE STOPPED FOR A PEDESTRIAN CROSSING THE STREET. VEHICLE #2 THEN REAR ENDED HIM. OPERATOR #2 REPORTS SHE WAS GOING N/B ON WALNUT ST WHEN SHE OBSERVED ANOTHER VEHICLE BACKING INTO A PARKING SPACE. SHE THEN DROVE AROUND IT NOT SEEING VEHICLE #1 WAS STOPPED AHEAD. SHE WAS UNABLE TO REACT IN TIME TO STOP BEFORE CRASHING INTO THE REAR OF VEHICLE #1.
Keywords:
Crash, Ped
Dcc:
Visibility obstructed
Report
url:
Image
url:
Latitude:
42.3499376
Longitude:
-71.2068697
Location:
Case
number:
Date:
2019-06-22
Time:
13:33
Address:
1349 WASHINGTON ST
Speed
limit:
5
Violation
cited:
no
Narrative:
The operator of MV#1 stated that he had backed out of his parking spot at the rear of #1349 Washington St and about to drive forward when crash occurred with MV#2. The operator of MV#2 stated that he was also backing out of a parking spot at the rear of #1349 Washington St directly across from MV#1 when crash occurred with MV#1. No injuries, no tows.
Keywords:
Crash
Dcc:
Unknown
Report
url:
Image
url:
Latitude:
42.3490978
Longitude:
-71.2284527
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);