crash_reports

1 row where "datetime" is on date 2022-06-25, dcc = "["Reckless driving"]" and intersection = 1

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

22000569

Date:

2022-06-25

Time:

22:12

Address:

CALIFORNIA ST & WYOMING RD

Speed limit:

25

Violation cited:

yes

Narrative:

MV1 stated she had just turned onto California St and was turning left when MV2 struck her causing heavy front end damage & airbag deployment. Operator of MV1 was evaluted by Fallon Medics for upper body pain and signed a patient refusal. MV2 was found abandoned close by on Bemis St @ Fair Oaks Ave. Both vehicles were removed from the scene by Tody's Towing. Operator of MV2 and his passenger complained of injuries, however refused to be evaluated. Operator of MV2 was cited with the following: M.G.L. 90/24A Leaving the Scene of Personal Injury M.G.L. 90/24C Leaving the Scene of Property Damage M.G.L. 90/24E Negligent Operation See incident report #22022661

Keywords:

Airbag, Citation

Dcc:

Reckless driving

Report url:

report

Image url:

image

Latitude:

 

Longitude:

 

Location:

None

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);