crash_reports

1 row where "date" is on date 2021-01-28 and longitude = "-71.1727828"

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

2100000066

Date:

2021-01-28

Time:

17:40

Address:

BEACON ST & HAMMOND ST

Speed limit:

25

Violation cited:

no

Narrative:

MV1 was stopped at the traffic light at the corner of Hammond Street at Beacon Street. MV1 got the green light and proceeded to move forward, but had to stop due to a vehicle in front of MV1 that had slowed down. MV2 saw MV1 begin to move forward but did not see MV1 come to a stop. MV2 struck the rear of MV1 causing little damage to the rear bumper of MV1. The operator of MV1 stated she had some minor neck pains, but when medics arrived on scene the operator of MV1 signed a patient refusal form to seek further medical evaluation.

Keywords:

[]

Dcc:

Inattention

Report url:

report

Image url:

image

Latitude:

42.3328654

Longitude:

-71.1727828

Location:

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