crash_reports
3 rows where dcc = "[]", intersection = 0 and "retrieved" is on date 2021-02-26
This data as json, CSV (advanced)
Suggested facets: date, speed_limit, hit_run, keywords, datetime (date), date (date), retrieved (date), keywords (array)
Case
number:
Date:
2021-02-16
Time:
14:22
Address:
327 AUBURN ST
Speed
limit:
25
Violation
cited:
no
Narrative:
The owner of MV#1 states that his MV was parked and unoccupied across from #327 Auburn St. Sometime between 1-2PM, another unknown MV struck MV#1 and left the area. No injuries, no tows.
Keywords:
[]
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3467029
Longitude:
-71.2479551
Location:
Case
number:
Date:
2021-02-19
Time:
03:47
Address:
457 WASHINGTON ST
Speed
limit:
30
Violation
cited:
no
Narrative:
At approximately 0345HRs on Friday, February 19, 2021, I called off with an unoccupied DMV in the roadway, in front of 457 Washington St. While awaiting Todys Services, a party, identified through his MA Driver's license as Rajinder Kumar, approached me and stated he was the operator of said vehicle (MA Pass: 9LV189 ). Rajinder further went on to state that at approximately 0230HRs, today, he was operating the vehicle while traveling Westbound on Washington St., when it inexplicably experienced a problem with its tire and could no longer be operated. Upon viewing the vehicle, I noted that its front driver's side tire was completely dislodged from the control arm assembly and it appeared that the ball joint had snapped. I noted no other apparently related damage on the vehicle, nor any hazards in the roadway. It should also be noted that the vehicle had a valid MA Inspection Sticker, which indicated it has passed the state's safety standards as of October 31, 2020. Todys Services arrived and collected the vehicle. A towed motor vehicle form was completed/filled. I cleared without incident.
Keywords:
[]
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3558255
Longitude:
-71.1915915
Location:
Case
number:
Date:
2021-02-19
Time:
17:42
Address:
35 LEXINGTON ST
Speed
limit:
25
Violation
cited:
no
Narrative:
Oper v1 stated while traveling south on Lexington Street on a down hill slope her vehicle started to slide sideways due to black ice, and vehicle was uncontrollable and slide into Eversource pole # 254/ 5. Eversource was notified. Oper of v1 was evaluated by medics and signed patient refusal. Todys towing arrived on scene and towed vehicle to their tow lot. Weather was snowing roadway was snow/ice.
Keywords:
Ice, Snow
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3587904
Longitude:
-71.2396948
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);