crash_reports
2 rows where longitude = "-71.2252516"
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2019-09-03
Time:
10:04
Address:
CHESTNUT ST & DAVIS ST
Speed
limit:
30
Violation
cited:
no
Narrative:
ON 9-3-19 AT APPROX. 1004HRS. WHILE WORKING N492 I TOOK A REPORT FOR MOTOR VEHICLE ACCIDENT. UPON ARRIVAL AT THE INTERSECTION OF CHESTNUT ST AND DAVIS I TALKED TO THE OPERATOR OF VEHICLE #1. DRIVER STATES SHE WAS TRAVELING. S-BOUND ON CHESTNUT. AS SHE PASSED DAVIS ST. SHE WAS HIT IN THE RIGHT SIDE BY VEHICLE #2. DRIVER OF VEHICLE #2 STATES SHE WAS TRAVELING E-BOUND ON DAVIS . WHEN SHE SAW AN OPENING SHE ACCELERATED BUT DID NOT SEE VEHICLE #1. WHEN SHE DID SEE VEHICLE #1 SHE WAS UNABLE TO AVOID HITTING HER. VEHICLE #1 HAD RIGHT SIDE DAMAGE AND RIGHT SIDE AIRBAG DEPLOYMENT. VEHICLE WAS TOWED BY TODYS. VEHICLE #2 HAD FRONT RIGHT SIDE DAMAGE AND WAS TOWED BY TODYS. ALL PARTIES REPORTED NO INJURIES. ALL PARTIES ADVISED TO CONTACT THEIR INSURANCE COMPANIES. VEHICLE #1 OWNER ( MELISSA YANAGI ) ARRIVED ON SCENE TO PICK UP HER CHILDREN AND TO SIGN THE PATIENT REFUSALS. CLEARED WITHOUT FURTHER INCIDENT.
Keywords:
Airbag, Crash
Dcc:
Inattention
Report
url:
Image
url:
Latitude:
42.3485635
Longitude:
-71.2252516
Location:
Case
number:
Date:
2022-04-27
Time:
08:26
Address:
CHESTNUT ST & DAVIS ST
Speed
limit:
25
Violation
cited:
yes
Narrative:
The operator of Vehicle #1 stated that as he was travelling Southbound on Chestnut St, he collided with Vehicle #2 as it attempted to make a left turn from Davis St onto Chestnut St. The operator of Vehicle #2 stated that he looked prior to the left turn, but didn't see any vehicles in his path prior to the collision with Vehicle #1. The operator of Vehicle #1 was transported to Newton-Wellesley Hospital as a result of the collision. The operator of Vehicle #2 was seen by the medics, but declined to be transported. A routine query revealed that Vehicle #2 was unregistered. As a result, the vehicle was cited, and towed.
Keywords:
Citation, Hospital
Dcc:
Failed to yield
Report
url:
Image
url:
Latitude:
42.3485635
Longitude:
-71.2252516
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);