crash_reports

1 row where longitude = "-71.2276058" and "retrieved" is on date 2020-10-07

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

1900001094

Date:

2019-10-25

Time:

14:43

Address:

1321 WASHINGTON ST

Speed limit:

10

Violation cited:

no

Narrative:

The operator of MV1 (MA: 249AB2) stated he was operating his vehicle Westbound through the parking lot behind 1321 Washington Street, Newton. The operator stated he was attempting to pull over to the right side of the roadway to allow a vehicle traveling Eastbound through the parking lot by him. In doing so, MV1's passenger side door area made contact with the front crash guard of Newton Police cruiser N506 ( MA MVN: MP506B). I observed minor damage to the passenger side door area of MV1 and minor damage to the front crash guard of MV2. No injuries reported. Photos were taken and submitted to the IT Bureau.

Keywords:

Crash, Pictures

Dcc:

[]

Report url:

report

Image url:

image

Latitude:

42.3494467

Longitude:

-71.2276058

Location:

1321 Washington 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);