crash_reports

1 row where "date" is on date 2019-06-16, keywords contains "Fire" and speed_limit = 25

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

1900000622

Date:

2019-06-16

Time:

14:40

Address:

CENTRE ST & HYDE AVE

Speed limit:

25

Violation cited:

no

Narrative:

Operator # 1 stated that he was coming to a stop in traffic while driving SB on Centre Street at Hyde Street when he was rear ended by vehicle #2. Operator #2 stated that he was driving SB on Centre Street, he saw the vehicle in front of him stopping. He attempted to stop but wasn't able too stop in time. He stated his car wouldn't stop due to the wet road. NFD was able to separate the two vehicle which were stuck by the tow hitch. Medics got 3 refusals. Vehicle #2 was towed.

Keywords:

Fire

Dcc:

Followed too closely, Too fast for conditions

Report url:

report

Image url:

image

Latitude:

42.3497298

Longitude:

-71.1869015

Location:

Hyde Ave & Centre St, Newton, MA 02458, 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);