crash_reports

1 row where address = "197 PINE RIDGE RD" and "datetime" is on date 2020-11-27

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

2000000678

Date:

2020-11-27

Time:

16:10

Address:

197 PINE RIDGE RD

Speed limit:

25

Violation cited:

yes

Narrative:

Operator 1 of MV 1 stated he was traveling E/B on Pine Ridge Rd when somebody was crossing the street and caught him off guard. Operator 1 swerved off the roadway taking out a fence and into the yard of 197 Pine Ridge Rd where it flipped over and landed on the hood of the vehicle. Operator 1 had minor injuries and was transported to the NWH. The vehicle had major damage and was towed by todys towing. Pictures of the damage to the fence were taken and placed into IT for attachment to this report. Operator 1, Luis Corado, was issued MA Citation #T2014679 for c90s10 Operating without a license and c89s4A Marked Lanes.

Keywords:

Citation, Pictures

Dcc:

Unknown

Report url:

report

Image url:

image

Latitude:

42.3269506

Longitude:

-71.2294406

Location:

197 Pine Ridge Rd, Waban, MA 02468, 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);