crash_reports
4 rows where "date" is on date 2019-03-10, intersection = 0 and "retrieved" is on date 2020-10-06
This data as json, CSV (advanced)
Suggested facets: speed_limit, dcc, dcc_code, datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2019-03-10
Time:
09:29
Address:
370 WOLCOTT ST
Speed
limit:
25
Violation
cited:
no
Narrative:
Motor vehicle 1 was traveling eastbound on Wolcott St when she lost control of the vehicle and exited the roadway. The vehicle went across the front lawn of #370 Wolcott causing damage to the property including several trees/bushes. The roadway was covered in snow due to recent snowfall at the time of the accident. The operator of the vehicle reported no injuries and the property owner was notified of the incident. Motor vehicle 1 was towed from the scene by Todys.
Keywords:
Crash, Snow, Tree
Dcc:
Too fast for conditions
Report
url:
Image
url:
Latitude:
42.3483447
Longitude:
-71.2429433
Location:
Case
number:
Date:
2019-03-10
Time:
11:53
Address:
304 LOWELL AVE
Speed
limit:
30
Violation
cited:
no
Narrative:
Page Davis states that she pulled over to the side of the road on Lowell Ave for an oncoming ambulance. Davis states that she looked in her mirror to enter the traffic lane. Davis saw vehicle #1 a distance back. Davis then went to enter the traffic lane and she was struck in the left rear by vehicle #1. Hanbo Lin was operating vehicle #1. Lin states that he saw vehicle #2 attempt to merge into traffic. Lin went to step on the brake and his vehicle slid into Davis due to the weather/road conditions. No injuries.
Keywords:
Ems
Dcc:
Inattention
Report
url:
Image
url:
Latitude:
42.3468164
Longitude:
-71.2106433
Location:
Case
number:
Date:
2019-03-10
Time:
13:57
Address:
897 WASHINGTON ST
Speed
limit:
30
Violation
cited:
no
Narrative:
M/V 1 TRAVELING WEST ON WASHINGTON ST APPROACHING 897 WASHINGTON ST. M/V 2 WAS EXITING DRIVEWAY ONTO WASHINGTON ST. M/V 1 HAD RIGHT OF WAY AND M/V2 STRUCK M/V 1 , NO INJURIES .M/V 3 IN DIAGRAM IS A PARKED VEHICLE. M/V 2 WAS TOWED AWAY BY TODY'S DUE TO EXCESSIVE DAMAGE.
Keywords:
[]
Dcc:
Inattention
Report
url:
Image
url:
Latitude:
42.3515762
Longitude:
-71.2095815
Location:
Case
number:
Date:
2019-03-10
Time:
15:54
Address:
18 STATION AVE
Speed
limit:
25
Violation
cited:
no
Narrative:
On March 10, 2019 at approximately 15:54 hours I responded to 18 Station Ave for a motor vehicle crash. Operator of MV1 said he was pulling out of a parking space on Station Ave and struck the side of MV2. There was no visible damage on MV1. MV1 admitted fault as MV2 had the right of way.
Keywords:
Crash
Dcc:
Failed to yield
Report
url:
Image
url:
Latitude:
42.3224637
Longitude:
-71.2056078
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);