crash_reports

1 row where latitude = "42.3308369" and "retrieved" is on date 2022-05-31

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

22000444

Date:

2022-05-25

Time:

07:52

Address:

BEACON ST & WALNUT ST

Speed limit:

30

Violation cited:

no

Narrative:

Operator of MV1 states he was traveling on Beacon Street somewhere in the area by Walnut Street when a green garbage truck (unknown make, model or registration plate) backed into his companies work truck and damaged the front windshield. Operator of MV1 states he doesn't think the operator of the garbage truck knew he struck MV1 and left the scene. Operator of MV1 will be contacting his employer for a private tow. No injuries.

Keywords:

[]

Dcc:

Unknown

Report url:

report

Image url:

image

Latitude:

42.3308369

Longitude:

-71.2070206

Location:

Beacon St & Walnut St, Newton, MA 02461, 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);