crash_reports

1 row where date = "2021-10-09" and "retrieved" is on date 2021-10-25

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

2100000800

Date:

2021-10-09

Time:

07:58

Address:

232 CALIFORNIA

Speed limit:

25

Violation cited:

no

Narrative:

MV1 while proceeding East bound on California Street struck parked MV2. MV1 continued straight and struck parked MV3. Owner of MV2 and MV3 were notified and completed an exchange of information with owner of MV1 Driver MV1 transported via Medic #3 to Newton-Wellesley Hospital for evaluation. MV1 towed to Tody's and a towed motor vehicle form was completed and filed.

Keywords:

Hospital

Dcc:

Lane departure

Report url:

report

Image url:

image

Latitude:

42.3646105

Longitude:

-71.1977411

Location:

232 California St, Newton, MA 02458, 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);