crash_reports

1 row where "datetime" is on date 2022-04-04, dcc contains "Inattention" and "retrieved" is on date 2022-04-21

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

22000272

Date:

2022-04-04

Time:

15:34

Address:

109 LEXINGTON ST

Speed limit:

30

Violation cited:

no

Narrative:

On 4/4/22 at approximately 1540 hours, I responded to 109 Lexington st for an accident. Upon arrival, MV1 stated that he was driving southbound on Lexington St when he thought he had hit the curb. His vehicle had minor damage to the front left side and had a flat tire. He reported no injuries. I spoke with the owner of MV2 stated that his vehicle was hit by MV1 causing damage to the right rear side and tire. The damage on Mv1 matched the damage on MV2. MV1 was towed by Todys. No injuries reported

Keywords:

Crash

Dcc:

Inattention

Report url:

report

Image url:

image

Latitude:

42.3565702

Longitude:

-71.240623

Location:

109 Lexington St, Auburndale, MA 02466, 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);