crash_reports

1 row where date = "2020-11-30" and keywords contains "Rain"

✎ 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:

2000000725

Date:

2020-11-30

Time:

15:17

Address:

276 WOODWARD ST

Speed limit:

30

Violation cited:

no

Narrative:

MV1 was driving Northbound on Woodward St. when a branch from a city tree fell onto the top of the vehicle. This occurred in front of 276 Woodward St. It should be noted that it was raining heavily during this time. Refer to incident #20053845 for further details.

Keywords:

Rain, Tree

Dcc:

[]

Report url:

report

Image url:

image

Latitude:

42.3236844

Longitude:

-71.2228025

Location:

276 Woodward St, 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);