home / crashreports

home

Menu
  • GraphQL API

crash_reports

Table actions
  • GraphQL API for crash_reports

1 row where keywords contains "Glare" and latitude = "42.3474099"

✎ 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:
2100000151
Date:
2021-02-24
Time:
16:41
Address:
ASH ST & COMMONWEALTH AVE
Speed limit:
25
Violation cited:
no
Narrative:
Operator #1 states that he was driving his work van (Patriot Mechanical) westbound on Commonwealth Ave near Ash St, when his vision became blinded by the sun which caused him to rear end vehicle #2. Vehicle #2 was stationary at the red light and subsequently hit vehicle #3 upon impact in a "domino effect". All operators were spoken to separately and their version of events are the same. It should be noted that while responding to this call, I did take note of the extreme solar glare on Commonwealth Ave westbound. All parties declined medical attention. Damage visible to me were as follows: -Vehicle #1 sustained heavy front end damage, towed by Tody's -Vehicle #2 had moderate rear end damage, towed by Tody's -Vehicle #3' s right rear passenger side above the wheel well had minor damage, possible tire damage as well. Vehicle was moved off to the side of the road and owner has their own tow coming.
Keywords:
Crash, Glare, Moderate, Solar
Dcc:
Glare
Report url:
report
Image url:
image
Latitude:
42.3474099
Longitude:
-71.2514322
Location:
Commonwealth Avenue & Ash St, Newton, MA 02466, 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 538.8ms