crash_reports

1 row where date = "2021-02-26", keywords contains "Crash" and "retrieved" is on date 2021-03-01

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

2100000154

Date:

2021-02-26

Time:

07:42

Address:

42 PARSONS ST

Speed limit:

30

Violation cited:

no

Narrative:

ON 2-26-21 AT APPROX. 0742HRS. WHILE WORKING N492 I TOOK A REPORT FOR MOTOR VEHICLE ACCIDENT. UPON ARRIVAL AT 42 PARSONS ST. I SPOKE TO THE OPERATOR OF VEHICLE #1. DRIVER STATES HE WAS BACKING ONTO THE RESIDENCE AT 42 PARSONS ST. TO EMPTY THE PORTA-POTTY AT THIS SITE. DRIVER STATES WHILE BACKING HE THOUGHT HE WAS CLEAR THE FIRE HYDRANT.BUT DIDN'T REALIZE HE WASN'T UNTIL HE HIT THE HYDRANT KNOCKING IT OVER. I TOOK 4 PICTURES OF THE HYDRANT AND PLACED THEM IN I.T. BOX. VEHICLE #1 HAD MINOR REAR LEFT DAMAGE. DRIVER REPORTED NO INJURY AND WAS ADVISED TO CONTACT HIS INSURANCE COMPANY. CITY OF NEWTON NOTIFIED TO GET THE HYDRANT. CLEARED WITHOUT FURTHER INCIDENT. CITY DPW NOTIFIED OF DAMAGE.

Keywords:

Crash, Fire, Pictures

Dcc:

Inattention

Report url:

report

Image url:

image

Latitude:

42.3511954

Longitude:

-71.2174191

Location:

42 Parsons St, West 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);