crash_reports

1 row where "date" is on date 2019-03-09 and street1 = "SOUTH 135 WINCHESTER ST"

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

1900000253

Date:

2019-03-09

Time:

01:28

Address:

135 WINCHESTER ST

Speed limit:

25

Violation cited:

no

Narrative:

Operator of MV1 states she parked her vehicle on the street in front of 135 Winchester Street at approximately 8:00pm and when she came out to her vehicle at 1:28am there was damage to the front left fender and tire. No witnesses to the accident. MV1 was disabled due to the damage and towed by Tody's. UPDATE: On 03/10/2019, Timothy Grady came to the Newton Police Station to report he hit a vehicle on Winchester Street. He stated he thought he hit snow, but with the damage on the front right he realized he hit another vehilce and wanted to report it. Grady's statements (date, time, and location) matched with this hit and run. Grady was advised of the process.

Keywords:

Crash, Snow

Dcc:

Unknown

Report url:

report

Image url:

image

Latitude:

42.3154113

Longitude:

-71.209198

Location:

135 Winchester St, Newton, MA 02461, 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);