home / crashreports

home

Menu
  • GraphQL API

crash_reports

Table actions
  • GraphQL API for crash_reports

2 rows where "datetime" is on date 2020-01-13 and keywords contains "Ped"

✎ 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:
2000000045
Date:
2020-01-13
Time:
14:14
Address:
WALNUT ST & WASHINGTON PK
Speed limit:
30
Violation cited:
no
Narrative:
ON 1-13-2020 AT APPROX. 1414HRS. WHILE WORKING N492 I TOOK A REPORT FOR MOTOR VEHICLE ACCIDENT. UPON ARRIVAL AT THE INTERSECTION OF WALNUT ST. AND WASHINGTON PK. I SPOKE TO THE OPERATOR OF VEHICLE #1. DRIVER STATES SHE WAS TRAVELING S-BOUND ON WALNUT AND STOPPED TO LET A PEDESTRIAN CROSS THE STREET. WHILE STOPPED SHE WAS HIT IN THE REAR BY VEHICLE #2. VEHICLE #2 STATES HE WAS TRAVELING S-BOUND ON WALNUT. HE STATES VEHICLE #1 STOPPED ABRUPTLY AND HE WAS UNABLE TO STOP ON THE WET PAVEMENT AND HIT HER VEHICLE. BOTH PARTIES REPORTED NO INJURIES AND SIGNED PATIENT REFUSALS. VEHICLE #1 HAD REAR END DAMAGE. VEHICLE #2 HAD MINOR FRONT END DAMAGE. BOTH VEHICLES WERE OPERATIONAL ALL PARTIES ADVISED TO CONTACT THEIR INSURANCE COMPANIES.
Keywords:
Crash, Ped
Dcc:
Inattention
Report url:
report
Image url:
image
Latitude:
42.3491491
Longitude:
-71.2068658
Location:
Washington Park & Walnut St, Newton, MA 02460, USA
Case number:
2000000048
Date:
2020-01-13
Time:
18:17
Address:
BEACON ST & HERRICK RD
Speed limit:
25
Violation cited:
no
Narrative:
On Monday January 13th 2020 at 1830, CHAN, Alyssa came into the front desk to report a past MVA vs pedestrian. At 1300, she was walking on Herrick Rd when she crossed by an entrance to a driveway by 17 Herrick Rd, when a vehicle pulled out and struck her. She states she was hit on her left side of her body and used her hand to brace herself against the car. The operator of MV1 asked her if she was ok, which she said she was, and then drove off. CHAN was later evaluated by her primary care physician, which advised her to monitor her wrist for any development of injury in the coming days. I spoke to the owner of MV1, who stated his son was driving the car today. Operator of MV1 stated he was pulling out of a driveway next to 17 Herrick Rd and looked both ways before pulling out, but did not see the pedestrian walking in front of his car. He states he got out and asked if she was ok, and she continued to walk away without talking. I did not observe any injuries on CHAN while speaking with her and she denied any further medical attention. No damage was reported on MV1.
Keywords:
Ped, Walk
Dcc:
Unknown
Report url:
report
Image url:
image
Latitude:
42.3301102
Longitude:
-71.194468
Location:
Beacon St & Herrick Rd, Newton, MA 02459, 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 365.111ms