crash_reports

1 row where latitude = "42.3365124" and "retrieved" is on date 2022-05-23

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

22000400

Date:

2022-05-14

Time:

06:56

Address:

CENTRE ST & COMMONWEALTH AVE

Speed limit:

30

Violation cited:

no

Narrative:

MV-1 stated she proceeded N/B Center Street through the green light at Commonwealth Avenue and Centre Street. MV-2 stated he was proceeding W/B Commonwealth Avenue through a green light at Centre Street. MV-1 and MV-2 collided in the center of the intersection. Both parties stated they had the green light. Operator MV1 transported to NWH. Operator and passenger MV2 transported to Beth Israel Hospital Both vehicles towed via Tody's

Keywords:

Hospital

Dcc:

[]

Report url:

report

Image url:

image

Latitude:

42.3365124

Longitude:

-71.1932597

Location:

Commonwealth Ave & Centre 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);