crash_reports

1 row where "date" is on date 2021-09-24, dcc contains "Emotional" 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:

2100000755

Date:

2021-09-24

Time:

21:51

Address:

28 AUSTIN ST

Speed limit:

15

Violation cited:

no

Narrative:

The operator of MV1 stated as she was pulling out of the parking garage at 28 Austin Street she struck MV2 while it was parked in a parking spot. The operator of MV1 was involved in a domestic during this accident with the operator of MV2. After striking MV2 the operator drove out of the parking garage to the NPD to report the incident. MV1 sustained minor damage to the driver side front head light. The operator of MV2 and the vehicle have not been found and spoken too in regards to the accident, unknown damage at this time.

Keywords:

Crash

Dcc:

Emotional

Report url:

report

Image url:

image

Latitude:

42.3500754

Longitude:

-71.2082101

Location:

28 Austin 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);