crash_reports

Table actions

1 row where "datetime" is on date 2019-02-14 and keywords contains "Ice"

✎ View and edit SQL

This data as json, CSV (advanced)

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

Case number:
1900000189
Date:
2019-02-14
Time:
10:41
Address:
7 KENDALL ROAD
Speed limit:
25
Violation cited:
no
Narrative:
Operator of MV # 1 states that she took a right turn off of Parker Street on to Kendall Road when she lost control due to snow and ice on the right side of the road. The vehicle then veered off to the right over the curb and struck a United States Post Office Relay Mailbox knocking it completely over. The mailbox was located in front of 7 Kendall Road. No injuries reported by the operator and the vehicle sustained minor front end damage to the right side. I did observe an accumulation of snow and ice on the right side of Kendall Road that came out approximately one foot from the curb. Newton Center Post Office was notified regarding the mailbox. There was no mail in the box at the time.
Keywords:
Ice, Snow
Dcc:
[]
Report url:
report
Image url:
image
Latitude:
42.3168595
Longitude:
-71.1952349
Location:
7 Kendall 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);