crash_reports

1 row where "datetime" is on date 2019-05-15, intersection = 0 and keywords contains "Phone"

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

1900000493

Date:

2019-05-15

Time:

12:27

Address:

35 PULSIFER ST

Speed limit:

30

Violation cited:

no

Narrative:

ON 5-15-19 AT APPROX. 1227HRS. WHILE WORKING N492 I TOOK A REPORT FOR HIT AND RUN MOTOR VEHICLE ACCIDENT. UPON ARRIVAL AT 35 PULSIFER I SPOKE TO THE OWNER OF VEHICLE #1. OWNER STATES HE WAS PARKED IN FRONT OF 35 PULSIFER AND WHEN HE RETURNED TO HIS CAR HE NOTICED A DENT ON THE LEFT FRONT FENDER. THERE WAS NOTE WITH A PHONE NUMBER ATTACHED TO HIS WINDSHIELD. WHEN HE CALLED THE NUMBER HE GOT NO RESPONSE. OWNER DOES NO KNOW WHO HIT HIS VEHICLE. OWNER WAS ADVISED TO CONTACT HIS INSURANCE COMPANY. VEHICLE #1 HAS MINOR FRONT END BUMPER DAMAGE. OWNER TOOK PICTURES OF THE DAMAGE.

Keywords:

Crash, Phone, Pictures

Dcc:

[]

Report url:

report

Image url:

image

Latitude:

42.3465437

Longitude:

-71.2053061

Location:

35 Pulsifer 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);