crash_reports
2 rows where "datetime" is on date 2019-03-04 and speed_limit = 10
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array)
Case
number:
Date:
2019-03-04
Time:
08:32
Address:
25 CHESTNUT ST
Speed
limit:
10
Violation
cited:
no
Narrative:
MV1 was backing into a snow covered parking space at 25 Chestnut St. The lot had not been plowed yet. As he was backing, the rear of the truck fishtailed slightly and struck parked MV2(city MV). There was a scratch to the drivers side mirror of MV2. The rear drivers tail light and quarter panel were damaged on MV1. I took pictures as did oper MV1. I transferred my pictures to IT.
Keywords:
Pictures, Snow
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3488353
Longitude:
-71.2257494
Location:
Case
number:
Date:
2019-03-04
Time:
11:01
Address:
199 WELLS AVE
Speed
limit:
10
Violation
cited:
no
Narrative:
OPERATOR OF MV#1 PARKED HIS VEHICLE IN THE LOT OF #199 WELLS AVE. UPON HIS RETURN TO THE VEHICLE, HE NOTICED A DENT IN THE FRONT PASSENGER QUARTER PANEL CAUSED FROM AN UNKNOWN VEHICLE.
Keywords:
[]
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.2960396
Longitude:
-71.1988318
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);