crash_reports

1 row where "datetime" is on date 2021-07-19, dcc_code = "[12]" and speed_limit = 15

✎ View and edit SQL

This data as json, CSV (advanced)

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

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

Case number:

2100000529

Date:

2021-07-19

Time:

18:44

Address:

75 ADAMS ST

Speed limit:

15

Violation cited:

no

Narrative:

MV1 was unoccupied and parked legally in a parking space belonging to 75 Adams St (Nonantum Boxing Club ) when MV2, operated by Robert David Rauh, hit MV1. MV2 was pulling out of a parking spot in the same lot when he miscalculated the turn and damaged MV1 rear driver's side bumper. Minor damage was observed on MV2 passenger side bumper. No injuries and both vehicles were safe to drive.

Keywords:

[]

Dcc:

Over-steering

Report url:

report

Image url:

image

Latitude:

42.3611837

Longitude:

-71.2044707

Location:

75 Adams 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);