crash_reports

1 row where "date" is on date 2022-06-02, hit_run = 0 and speed_limit = 0

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

22000502

Date:

2022-06-02

Time:

18:41

Address:

48 NORTH GATE PK

Speed limit:

0

Violation cited:

no

Narrative:

MV1 pulled forward purposefully into parked and unoccupied MV2 to which crashed into the garage door in front of it. Minimal damage to MV1 if any, and MV2 had some rear end damage and front end damage. The garage door was bent inward to the point where it could no longer be opened or closed. No injuries or tows from the scene.

Keywords:

Crash

Dcc:

Reckless driving

Report url:

report

Image url:

image

Latitude:

42.3554109

Longitude:

-71.2258655

Location:

48 N Gate Park, 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);