crash_reports

1 row where "date" is on date 2019-12-17, dcc contains "Unknown" and intersection = 0

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

1900001305

Date:

2019-12-17

Time:

21:45

Address:

276 CHURCH ST

Speed limit:

15

Violation cited:

no

Narrative:

Operator of MV1 stated between the hours of 2000 and 2200 his MV was struck, causing minor damage to his driver side mirror. Operator of MV1 stated he was not in the vehicle at the time and is unknown who had struck his mirror. MV1 was parked in the YMCA parking lot at the time of the accident. I was not able to speak with staff at the YMCA to see if they're cameras because it was closed.

Keywords:

Crash

Dcc:

Unknown

Report url:

report

Image url:

image

Latitude:

42.3545606

Longitude:

-71.1913595

Location:

276 Church 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);