crash_reports

1 row where keywords contains "Hospital" and "retrieved" is on date 2021-08-06

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

2100000567

Date:

2021-07-28

Time:

16:30

Address:

991 WATERTOWN ST

Speed limit:

25

Violation cited:

no

Narrative:

MV1 was exiting the parking lot of 991 Watertown St when he collided with MV2. MV2 was travelling EB on Watertown St when she was struck on the drivers side by MV1. No injuries to Operator 1, Operator 2 was transported by Fallon ambulance with minor injuries. MV1 was driven from the scene with very minor damage. MV2 was parked on Watertown St awaiting Operator 2's release from the hospital. MV2 sustained minor damage to the drivers side Photos taken and placed into IT.

Keywords:

Ems, Hospital, Pictures

Dcc:

Glare

Report url:

report

Image url:

image

Latitude:

42.349735

Longitude:

-71.225836

Location:

991 Watertown St, Newton, MA 02465, 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);