crash_reports

1 row where "datetime" is on date 2020-10-07, intersection = 0 and "retrieved" is on date 2020-10-14

✎ View and edit SQL

This data as json, CSV (advanced)

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

case_number ▼	date	time	address	speed_limit	violation_cited	narrative	keywords	dcc	report_url	image_url	latitude	longitude

Case number:

2000000583

Date:

2020-10-07

Time:

17:53

Address:

11 MOSSFIELD RD

Speed limit:

20

Violation cited:

no

Narrative:

The operator of vehicle 1 stated she was traveling Westbound of Mossfield Rd when a large tree fell on top of her car. The tree which belongs to 11 Mossfield Rd landed on the hood, windshield and front half of the roof. The impact caused major damage to the vehicle. The occupants were able to exit the vehicle and reported no injuries. Pictures of the incident were taken by me and submitted to IT.

Keywords:

Crash, Pictures, Tree

Dcc:

[]

Report url:

report

Image url:

image

Latitude:

42.3257898

Longitude:

-71.2411798

Location:

11 Mossfield Rd, Waban, MA 02468, USA

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);