crash_reports
2 rows where "date" is on date 2019-08-01 and speed_limit = 25
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2019-08-01
Time:
11:48
Address:
355 NEWTONVILLE AVE
Speed
limit:
25
Violation
cited:
no
Narrative:
OPERATOR #1 STATED SHE WAS TRAVELLING E/B ON NEWTONVILLE AVE APPROACHING THE INTERSECTION OF HARVARD ST WHEN ANOTHER VEHICLE COMING W/B ON NEWTONVILLE AVE FORCED HER TO HER RIGHT WHICH CAUSING HER TO SIDE SWIPE A PARKED VEHICLE. SHE FURTHER REPORTED IF SHE DIDN'T MOVE OVER TO HER RIGHT SHE WOULD HAVE WENT HEAD ON INTO THE ONCOMING VEHICLE. OWNER OF VEHICLE #2(PARKED CAR) WAS WORKING NEARBY WAS ON SCENE ON MY ARRIVAL. THEY BOTH HAD ALREADY EXCHANGED INFO AND HAD TAKEN PICTURES OF DAMAGE PRIOR TO POLICE ARRIVAL TO SCENE. DRIVER OF VEHICLE #1 REPORTED NO INJURIES AND HAD A PRIVATE COMPANY TOW HER CAR TO DIRECT TIRE DUE TO HER HITTING A CURB AFTER HITTING VEHICLE #2. NEWTONVILLE AVE ALLOWS PARKING ON THE EAST SIDE OF THE STREET. VEHICLES DRIVING E/B HAVE TO TRAVEL HALFWAY ON THE WRONG SIDE OF THE ROAD TO GET AROUND THEM THUS CAUSING A HAZARD WHEN VEHICLES ARE COMING WESTBOUND AT THE SAME TIME.
Keywords:
Pictures
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3513418
Longitude:
-71.2020573
Location:
Case
number:
Date:
2019-08-01
Time:
13:27
Address:
73 WOOD END RD
Speed
limit:
25
Violation
cited:
no
Narrative:
Mv#1 was travelling on Wood End Rd W/B passing by a parked Mv (#2) in front of #73. At the same time, an unknown Mv was travelling E/B on Wood End passing by #1. As a result, the unknown Mv caused #1 to squeeze over to its right causing #1 to sideswipe #2. Passenger side damage sustained to #1 and towed by Tody's. Driver's side damage sustained to #2. Attempts to call #2 owner were negative results. An exchange form note was left on #2.
Keywords:
[]
Dcc:
Unknown
Report
url:
Image
url:
Latitude:
42.3235103
Longitude:
-71.2118964
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);