home / crashreports

home

Menu
  • GraphQL API

crash_reports

Table actions
  • GraphQL API for crash_reports

1 row where "datetime" is on date 2020-09-26, "retrieved" is on date 2020-10-20 and violation_cited = 0

✎ 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:
2000000557
Date:
2020-09-26
Time:
15:54
Address:
327 WASHINGTON ST
Speed limit:
25
Violation cited:
no
Narrative:
Vehicle one was driving westbound on Washington St when he stated that he was looking at the buildings across from 327 Washington St. Vehicle one drifted into parked car, vehicle two. Vehicle two was parked and unoccupied in a parking spot in front of 327 Washington St. Vehicle two moved forward from the impact and struck vehicle three. It should be noted that vehicle two already had extensive damage to the front end of the vehicle prior to the crash holding the bumper intact with duck tape and clear tape. Vehicle three had minor damage to the rear end bumper. No injuries were reported on scene.
Keywords:
Crash, Severe
Dcc:
Inattention, Distracted
Report url:
report
Image url:
image
Latitude:
42.3569413
Longitude:
-71.1871127
Location:
327 Washington 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 283.722ms