crash_reports

Table actions

1 row where "date" is on date 2021-02-20, keywords contains "Crash" and "retrieved" is on date 2021-03-01

✎ View and edit SQL

This data as json, CSV (advanced)

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

Case number:
2100000138
Date:
2021-02-20
Time:
09:04
Address:
CHARLESBANK RD & ST JAMES TERR
Speed limit:
25
Violation cited:
no
Narrative:
On February 20th, 2021 at approximately 09:04 hours while working N491 I responded to a report of a past hit&run MV crash that involved two US postal mailboxes that had been struck near the intersection of Charlesbank Rd @ St James Terrace. On my arrival to the scene I located the first mailbox on the sidewalk near #93 Charlesbank Rd. The other mailbox was located on the property to #93 Charlesbank Rd upside down leaning up against the front of the house. Dispatch notified the postal authorities and they were going to respond to pick up their mailboxes. The vehicle involved in this MV crash appeared to be a Subaru based on the vehicles damaged parts found at the scene. The vehicle left scene heading W/B on Charlesbank Rd. #94 Charlesbank heard a loud noise around 01:15 this morning but thought it eas just a plow.
Keywords:
Crash
Dcc:
Reckless driving
Report url:
report
Image url:
image
Latitude:
42.3587668
Longitude:
-71.1802241
Location:
St James Terrace & Charlesbank Rd, 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);