crash_reports
2 rows where "datetime" is on date 2019-03-11 and keywords contains "Ice"
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2019-03-11
Time:
08:18
Address:
300 BOYLSTON ST
Speed
limit:
15
Violation
cited:
no
Narrative:
WHILE PULLING INTO THE PARKING AREA OF #300 BOYLSTON ST, MV#1 SLID ON ICE AND STRUCK A PARKED MV#2 (REAR ). MV#2 WAS PARKED (OCCUPIED) IN FRONT OF #300 BOYLSTON ST, WHEN MV#1 SLID INTO THE REAR OF THE VEHICLE. MV#1 WAS TOWED WITH MODERATE FRONT END DAMAGE.
Keywords:
Ice, Moderate
Dcc:
Swerving
Report
url:
Image
url:
Latitude:
42.3185796
Longitude:
-71.179849
Location:
Case
number:
Date:
2019-03-11
Time:
07:44
Address:
1897 WASHINGTON ST
Speed
limit:
35
Violation
cited:
no
Narrative:
The operator of MV#1 stated that she was traveling south on Washington St in the left hand lane when her MV was struck by MV#2. The operator of MV#2 stated that he was also traveling south on Washington St in the right hand lane directly next to MV#1 when his MV began to slide due to icy road conditions and his MV struck MV#1. No injuries & no citations
Keywords:
Citation, Ice
Dcc:
Unknown
Report
url:
Image
url:
Latitude:
42.3365452
Longitude:
-71.2460112
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);