crash_reports

1 row where "datetime" is on date 2020-03-06, intersection = 0 and keywords contains "Solar"

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

2000000218

Date:

2020-03-06

Time:

02:19

Address:

258 CENTRE ST

Speed limit:

25

Violation cited:

no

Narrative:

On Friday, March 6, 2020 between approximately 0218 to 0220 hours MV1 was parked at 258 Centre St, Newton. At this time an unknown MV struck MV1 from behind and pushed it approximately 10 feet to the Sunoco Entrance (170 Galen St, Watertown). MV1 sustained heavy rear-end damage and was towed privately by the Sunoco owner with MV1 owner's permission. The Sunoco owners do not have a recording of the crash but has the recording of MV1 being pushed from behind into the camera view. The unknown MV was not seen in the camera recordings. MV1 owner was inside his residence at the time, and no injuries were reported.

Keywords:

Crash, Solar

Dcc:

Unknown

Report url:

report

Image url:

image

Latitude:

42.3591001

Longitude:

-71.1849675

Location:

258 Centre St, Newton, MA 02458, 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);