crash_reports
4 rows where "date" is on date 2019-04-25, intersection = 0 and "retrieved" is on date 2020-10-06
This data as json, CSV (advanced)
Suggested facets: 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:
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);