crash_reports

1 row where "datetime" is on date 2019-11-01, hit_run = 0 and speed_limit = 5

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

1900001119

Date:

2019-11-01

Time:

13:52

Address:

350 BOYLSTON ST (LOT)

Speed limit:

5

Violation cited:

no

Narrative:

OPER OF MV1 STATED THAT HE WAS TURNING IN A CIRCLE IN THE DRIVEWAY, WHEN MV2 PULLED OUT FROM THE GARAGE, AND TRIED TO SQUEEZE BY. THE VEHICLES COLLIDED CAUSING MODERATE DAMAGE TO THE FRONT PASS OF MV1 AND MODERATED DAMAGE TO THE DRIVER SIDE DOOR AREA OF MV2. OPER OF MV2 STATED THAT SHE WAS PULLING OUT OF THE GARAGE, WHEN MV1 DIDNT SEE HER AND STRUCK THE DRIVER SIDE DOOR.

Keywords:

Moderate

Dcc:

[]

Report url:

report

Image url:

image

Latitude:

42.3191216

Longitude:

-71.1828395

Location:

350 Boylston St, Newton, MA 02459, 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);