crash_reports

1 row where "datetime" is on date 2019-04-12, keywords = "["Citation"]" and keywords contains "Citation"

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

1900000370

Date:

2019-04-12

Time:

20:32

Address:

WASHINGTON ST & CENTRE ST

Speed limit:

30

Violation cited:

yes

Narrative:

MV1 stated he was attempting to "turn left" when the car to his left "went straight instead of left" subsequently striking his vehicle. MV1 was spun sideways and MV2 continued into Watertown. I then made contact with the operator of MV2 who admitted to striking MV1, however thought they weren't going to stop so he kept going as well. MV2 was cited for Leaving the Scene of Property Damage & Marked Lanes See incident report 19014042 for further information.

Keywords:

Citation

Dcc:

Inattention

Report url:

report

Image url:

image

Latitude:

42.3557988

Longitude:

-71.1865324

Location:

Centre St & Washington 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);