crash_reports

1 row where date = "2022-04-27" and longitude = "-71.1823438"

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

22000346

Date:

2022-04-27

Time:

10:24

Address:

45 BEECHER TER

Speed limit:

20

Violation cited:

no

Narrative:

The operator of MV#1 stated she accelerated once within the driveway of 45 Beecher Ter. causing her to collide into the front right corner of the home. It appears the vehicle then slid approx. 5-10 feet into the fence which runs adjacent to the driveway causing damage to both the fence and retaining wall. Damage observed to the front right corner of 45 Beecher Ter. MV#1 sustained heavy damage to its front end and was towed by its owner. No injuries reported. Homeowner of 45 Beecher Ter. on scene and took photographs of damage to his property.

Keywords:

Pictures

Dcc:

Unknown

Report url:

report

Image url:

image

Latitude:

42.3216877

Longitude:

-71.1823438

Location:

45 Beecher Terrace, 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);