crash_reports

1 row where date = "2021-07-02", "retrieved" is on date 2021-07-04 and speed_limit = 25

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

2100000485

Date:

2021-07-02

Time:

12:11

Address:

557 CALIFORNIA ST

Speed limit:

25

Violation cited:

no

Narrative:

Opr of V1 stated he was traveling westbound picking up the City of Newton trash. Opr of V1 slowed down and at this time was hit from behind by V2. Opr of V2 stated he was traveling behind the trash truck. At this time, he did not realize it was stopping to pick up trash and made contact with the trash truck. V2 suffered minor damage to the front right. No injuries reported.

Keywords:

[]

Dcc:

Inattention

Report url:

report

Image url:

image

Latitude:

42.3610997

Longitude:

-71.2105505

Location:

557 California St, Newton, MA 02460, 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);