crash_reports
5 rows where date = "2019-04-25"
This data as json, CSV (advanced)
Suggested facets: intersection, speed_limit, hit_run, keywords, dcc, dcc_code, datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2019-04-25
Time:
10:21
Address:
545 GROVE ST
Speed
limit:
25
Violation
cited:
no
Narrative:
Operator of vehicle 1 states she was was driving southbound on Grove St when a squirrell ran out infront of her. She swerved right to avoid the squirrell and hit a utility poll. Operator 1 was checked on by Cataldo medics and signed a patient refusal. The vehicle was towed by AAA and utilites were notified about possible damage to the poll.
Keywords:
[]
Dcc:
Inattention
Report
url:
Image
url:
Latitude:
42.3306225
Longitude:
-71.258568
Location:
Case
number:
Date:
2019-04-25
Time:
10:28
Address:
87 BRANDEIS RD
Speed
limit:
30
Violation
cited:
no
Narrative:
Patrice Lys was operating vehicle #2 on Brandies Rd. Lys states that vehicle #1 was about to back out of the driveway so he stopped. Lys state that the vehicle did not back out so he started to drive again, at that point vehicle #1 backed out of the driveway and struck his vehicle on the left rear. Azad Chitchian was operating vehicle #1. Azad states that she saw vehicle #2 stop to let her out of her driveway, she then went to back out of her driveway and vehicle #2 struck her. Aghavni Gevorgyan was witness. Aghavni confirms Azad's version of events. Aghavni and Azad are known to each other. Azad was transported to NWH. I took pictures, no traffic officers working.
Keywords:
Pictures
Dcc:
Inattention
Report
url:
Image
url:
Latitude:
42.3140858
Longitude:
-71.1911506
Location:
Case
number:
Date:
2019-04-25
Time:
13:43
Address:
BEACON ST & CRESCENT AVE
Speed
limit:
25
Violation
cited:
no
Narrative:
I responded to the intersection of Crescent Ave.@Beacon st for a two car MVA at approx. 1343 hrs 04/25/2019. V1; MA reg 8738ES, 2010 toyt/Camry color gray operated by Kuller, Robert A. MA OLN S40421474. V1 operator was attempting to turn left onto Beacon St from Crescent Ave. There was on coming traffic on Beacon St. V1 operator who had been trying to make the turn was sticking out onto Beacon st. V1 operator put his vehicle in reverse and proceeded to back up for the oncoming traffic. V1 collided into V2 which was directly behind when he backed up. V2; MA Reg 6PA747, 2017 Jeep/Util. color white operated by Mesen, Alvarado MA OLN S31551122. V2 Operate's account of the collision was consistent with V1 operator without dispute. There was minor damage to both vehicles. Neither operator was injured as a result of the collision. No airbag deployment. Neither vehicle required towing service.
Keywords:
Airbag
Dcc:
Distracted
Report
url:
Image
url:
Latitude:
42.3303911
Longitude:
-71.1980873
Location:
Case
number:
Date:
2019-04-25
Time:
14:51
Address:
1369 WASHINGTON ST
Speed
limit:
5
Violation
cited:
no
Narrative:
On 3/25/19 the owner of vehicle #1 reports that on 3/24/19 while his wife was at work at the Village Bank his vehicle was hit by an unknown vehicle causing damage to the front grill. His wife is attempting to get video of the accident from the Village Bank security cameras. She will contact NPD Traffic Bureau if they are able to get video of incident.
Keywords:
Crash
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3488912
Longitude:
-71.2289819
Location:
Case
number:
Date:
2019-04-25
Time:
17:53
Address:
194 ADAMS ST
Speed
limit:
25
Violation
cited:
no
Narrative:
On 04/25/2019, at 1753 hrs, I responded to 193 Adams St for a two car MVA. Upon arrival, I observed MV1 to have front passenger side damage and MV2 to have rear passenger side damage. The operator of MV1 stated she was attempting to take a left turn out of her driveway and had difficulty seeing due to parked cars. She then collided with MV2 who was traveling northbound on Adams St. The operator of MV2 stated she was traveling northbound on Adams St when MV1 pulled out of a driveway and they collided. No injuries were reported and both vehicles were driven from the scene.
Keywords:
[]
Dcc:
Visibility obstructed
Report
url:
Image
url:
Latitude:
42.358515
Longitude:
-71.2000155
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);