home / crashreports

home

Menu
  • GraphQL API

crash_reports

Table actions
  • GraphQL API for crash_reports

1 row where dcc contains "Unknown", keywords contains "Bus" and "retrieved" is on date 2021-05-19

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)

case_number ▼ date time address speed_limit violation_cited narrative keywords dcc report_url image_url latitude longitude
Case number:
2100000355
Date:
2021-05-17
Time:
16:00
Address:
ANITA CIR & CHESTNUT ST
Speed limit:
25
Violation cited:
no
Narrative:
This accident was reported approx. 8 hours later due to reporting party not familiar with laws in the U.S. Bicyclist #1 doesn't speak English well and needed her husband (Siarhei Byk) to translate. Bicyclist #1 stated on 05/17/2020 at approx. 1600 hrs., she was travelling southbound on Chestnut Street on the sidewalk. While crossing Anita Cir, MV#1 approached the intersection and collided into her. She was thrown onto the hood of MV#1 as a result of the collision. The OP. of MV#1 helped her into his car and drove her home. The OP. of MV#1 only gave her a business card and nothing else. The husband of Bicyclist #1 came home later and drove Bicyclist #1 to the hospital to be checked out. The husband of Bicyclist #1 called the OP. of MV#1 to get some car insurance information and was denied. The OP. of MV#1 stated he felt uncomfortable giving that information and they would talk the next day about it. The husband of Bicyclist #1 felt this was strange and decided to report it to the police after getting out of the hospital. Bicyclist #1 was wearing black pants and a blue shirt. She did not have a helmet on and didn't have any reflective clothing on. She sustained bruising to both legs and didn't get a concussion. Her bicycle gears and her wheel was damaged from the accident and pictures were taken by me. The brand of the bicycle is Infinity Hybrid and it cost approx. $350.00 USD when new. Bicyclist #1 describes the OP. of MV#1 as a white male around 50's - 60's years of age. She describes the vehicle that struck her as a red SUV. The OP. of MV#1 gave a business card with the name Ruth Robart out of 28 Richardson Rd., Newton 617-818-8660. Further investigation revealed a Ralph Robart out of that address with a similar age. Due to the time of night, the investigation would be postponed to daylight hours. At approx. 1550 hrs., I made contact with the OP. of MV#1. He stated he was stopped on Anita Cir., waiting to make a right turn onto Chestnut Street. When there was no more oncoming traffic to his left, he looked to the right and saw it was clear as well and started to accelerate. That's when Bicyclist #1 suddenly rode out from the sidewalk and they collided together. There's a 6 foot wall from a residence that blocked his vision to see further down the sidewalk. The OP. of MV#1 stated there was no damage to his vehicle.
Keywords:
Bike, Bus, Crash, Helmet, Hospital, Night, Pictures
Dcc:
Unknown
Report url:
report
Image url:
image
Latitude:
42.318103
Longitude:
-71.2259763
Location:
Anita Cir & Chestnut St, Newton, MA 02468, USA

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

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);
Powered by Datasette · Queries took 540.809ms