crash_reports

1 row where dcc = "[]" and "retrieved" is on date 2021-10-25

✎ View and edit SQL

This data as json, CSV (advanced)

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

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

Case number:

2100000820

Date:

2021-10-13

Time:

14:48

Address:

189 ADAMS ST

Speed limit:

25

Violation cited:

no

Narrative:

OPERATOR OF MV1 STATED SHE WAS TRAVELING NORTH ON ADAMS ST WHEN MV2 (UNKNOWN REG PLATE) TRAVELING IN THE OPPOSITE DIRECTION CROSSED OVER THE DOUBLE YELLOW LINES AND STRUCK HER VEHICLE CAUSING DAMAGE TO HER DRIVERS SIDE MIRROR. MV2 WAS AN SUV WHITE IN COLOR AND THE OPERATOR WAS DESCRIBED AS A WHITE MALE WITH GRAY HAIR AND GLASSES POSSIBLY IN HIS 50'S OR 60'S. MV 2 DID NOT STOP TO EXCHANGE INFORMATION AND NO INJURIES WERE REPORTED.

Keywords:

[]

Dcc:

[]

Report url:

report

Image url:

image

Latitude:

42.358424

Longitude:

-71.2004413

Location:

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