crash_reports

1 row where "datetime" is on date 2019-06-14, dcc = "["Inattention", "Unknown"]" and "retrieved" is on date 2020-10-06

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

1900000614

Date:

2019-06-14

Time:

15:03

Address:

483 DEDHAM ST

Speed limit:

30

Violation cited:

no

Narrative:

Vehicle 1 was travelling southbound on Dedham St. Vehicle 2 was travelling southbound on Dedham St. Vehicle 2 rear ended vehicle 1, while both cars were travelling straight ahead. There was major damage to the rear of vehicle 1, and moderate damage to the front right of vehicle 2. Vehicle 2 was towed to Todys lot. The operator of vehicle 1 was transported to NWH for minor injuries. The operator of vehicle 2 sustained no injuries, and signed a patient refusal.

Keywords:

Moderate

Dcc:

Inattention, Unknown

Report url:

report

Image url:

image

Latitude:

42.3040323

Longitude:

-71.1960518

Location:

483 Dedham St, Newton, MA 02459, 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);