crash_reports

1 row where "datetime" is on date 2020-07-15 and latitude = "42.3306338"

✎ View and edit SQL

This data as json, CSV (advanced)

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

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

Case number:

2000000380

Date:

2020-07-15

Time:

01:19

Address:

2014 WASHINGTON ST

Speed limit:

5

Violation cited:

no

Narrative:

On 7/15/2020 the operator of MV 1 was parked in the parking garage and as she was reversing the drivers side corner of her vehicle hit the concrete column. The column had pulled off the bumper and caused major damage. No injuries reported. Vehicle was towed by Todys

Keywords:

[]

Dcc:

[]

Report url:

report

Image url:

image

Latitude:

42.3306338

Longitude:

-71.2464373

Location:

2014 Washington St, Newton, MA 02462, 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);