crash_reports
3 rows where "datetime" is on date 2021-01-28, dcc = "[]" and intersection = 0
This data as json, CSV (advanced)
Suggested facets: speed_limit, hit_run, datetime (date), date (date), retrieved (date), keywords (array)
Case
number:
Date:
2021-01-28
Time:
11:24
Address:
300 BOYLSTON ST
Speed
limit:
30
Violation
cited:
no
Narrative:
ACCIDENT TOOK PLACE IN THE LOADING DOCK OF 300 BOYLSTON ST. THE VEHICLE OPERATOR LEFT WAS BACKING HIS VEHICLE INTO THE LOADING DOCK TO MAKE A DELIVERY. HE ACCIDENTALLY BACKED INTO AN OVERHEAD AIR CONDITIONING AND VENTILATION OVERHEAD DUCT. NO INJURIES REPORTED.
Keywords:
Crash
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3185796
Longitude:
-71.179849
Location:
Case
number:
Date:
2021-01-28
Time:
12:23
Address:
34 HURLEY PL
Speed
limit:
30
Violation
cited:
no
Narrative:
VEHICLE OPERATOR WAS TRAVELING DOWN HURLEY PLACE, IT WAS SNOWING OUTSIDE AND THE ROAD WAS SLIPPERY. DRIVER STATES AS SHE WAS DRIVING DOWN THE HILL HER VEHICLE STARTED TO SKID AND SHE SKIDDED INTO UTILITY POLE # 20/4. THERE WERE NO INJURIES, THE VEHICLE WAS ABLE TO DRIVE AND THERE WAS NO DAMAGE TO THE UTILITY POLE.
Keywords:
Snow
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3179704
Longitude:
-71.1896919
Location:
Case
number:
Date:
2021-01-28
Time:
18:45
Address:
21 COTTAGE PL
Speed
limit:
25
Violation
cited:
no
Narrative:
Owner of vehicle 1 states it was parked, unoccupied in front of 21 Cottage Pl. A loud noise was heard. Owner of vehicle 1 checked vehicle and noticed left rear had new scratches and dents. It should be noted owner of vehicle 1 saw an amazon delivery van driving down the street after loud noise was heard. Owner of vehicle 1 called amazon to file claim and obtain delivery/GPS locations. Owner of vehicle 1 called their insurance company, who then requested a police report be filed.
Keywords:
[]
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3535068
Longitude:
-71.2312952
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);