home / crashreports

home

Menu
  • GraphQL API

crash_reports

Table actions
  • GraphQL API for crash_reports

2 rows where keywords contains "Hospital" and "retrieved" is on date 2021-05-03

✎ 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:
2100000280
Date:
2021-04-22
Time:
18:10
Address:
2014 WASHINGTON ST
Speed limit:
5
Violation cited:
no
Narrative:
MV#1 Was parked in the East side entrance parking garage when it was struck by an unknown vehicle. Uninvolved owner stated she parked the vehicle in the garage at approximately 1120Hrs and when she returned at approximately 1810Hrs she noticed damage to the left side of her vehicle. Should be noted there was a note left on the vehicle stating a Red Mazda MA REG#552GY2 possibly struck her vehicle. Due to the white scratch marks on the vehicle I don't think this is the vehicle that was involved. Traffic Bureau update (Officer Gaudet): I attempted to make contact with the registered owner of MA: 552GH2 (Mr. Franics Nolan, S60053602) with a negative result. A "Hit and Run" inquiry was mailed to Mr. Nolan. On Friday, April 30, 2021, I spoke with Mr. Nolan via telephone. Mr. Nolan stated that he was at Newton Wellesley Hospital on the day of the crash, but does not believe he was involved in a crash. I asked him to check his vehicle to see if there was any fresh damage. Mr. Nolan stated there was no damage to his vehicle. Mr. Nolan stated he parked in a Handicap parking spot on the second floor and there were not cars around him. No further action will be taken.
Keywords:
Crash, Hospital
Dcc:
[]
Report url:
report
Image url:
image
Latitude:
42.3306338
Longitude:
-71.2464373
Location:
2014 Washington St, Newton, MA 02462, USA
Case number:
2100000300
Date:
2021-05-01
Time:
16:52
Address:
BELMONT ST & TREMONT ST
Speed limit:
25
Violation cited:
no
Narrative:
Vehicle 1 was parked on Tremont St facing westbound in front of house number 243 Tremont St. Vehicle 2 was traveling westbound and hit vehicle 1 causing vehicle 2 to roll over 2 times before stopping upright in the middle of Tremont St in the Eastbound lane. Passenger of vehicle 2 was transported via ambulance to the hospital. Vehicle 1 owner was notified. Witness stated that she saw vehicle 2 traveling westbound on Tremont St and swerve and hit parked vehicle 1 and rolled over 2 times before landing correctly. Witness stated that speed was not a factor. Photos were taken and sent to IT.
Keywords:
Ems, Hospital, Pictures, Speed
Dcc:
Inattention
Report url:
report
Image url:
image
Latitude:
42.3534328
Longitude:
-71.1777072
Location:
Tremont St & Belmont St, Newton, MA 02458, 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 805.294ms