crash_reports

1 row where "date" is on date 2021-06-11, dcc = "["Unknown"]" and "retrieved" is on date 2021-06-14

✎ View and edit SQL

This data as json, CSV (advanced)

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

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

Case number:

2100000419

Date:

2021-06-11

Time:

13:47

Address:

WASHINGTON TER & WASHINGTON ST

Speed limit:

25

Violation cited:

no

Narrative:

Operator of V1 stated she was traveling east on Washington Street, turned left onto Washington Terr and had contact with V2. Operator of V2 stated she just pulled out of the parking space on the westbound lane of Washington Street she was traveling straight and V1 turned into her vehicle. All parties advised of the process, and there were no reported injuries.

Keywords:

[]

Dcc:

Unknown

Report url:

report

Image url:

image

Latitude:

42.3512902

Longitude:

-71.2091542

Location:

Washington Terrace & Washington St, Newton, MA 02460, 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);