crash_reports

1 row where "date" is on date 2021-07-27, dcc = "[]" and keywords contains "Fire"

✎ View and edit SQL

This data as json, CSV (advanced)

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

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

Case number:

2100000557

Date:

2021-07-27

Time:

14:49

Address:

513 WASHINGTON ST

Speed limit:

25

Violation cited:

no

Narrative:

On 07/27/2021, while assigned to N494, I, Officer Conary, spoke with DEALE, Cathy (Operator of MV1) over the phone about a past hit and run. DEALE explained to me that she parked Westbound on Washington Street in front of 513 by the fire hydrant. Between 1200-1400 MV1 was hit on the driver side, and the mirror broke off. Operator of MV1 did not see any other vehicle standing by, she left the area and notified Newton Police. Operator of MV1 sent me pictures to confirm the damage. I went back to the area of where the accident was reported and confirmed glass and a pieces of a mirror on the side of the road.

Keywords:

Crash, Fire, Phone, Pictures

Dcc:

[]

Report url:

report

Image url:

image

Latitude:

42.3552254

Longitude:

-71.1940066

Location:

513 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);