crash_reports

1 row where "date" is on date 2021-01-20, dcc = "[]" and speed_limit = 0

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: datetime (date), date (date), retrieved (date), keywords (array)

case_number ▼	date	time	address	speed_limit	violation_cited	narrative	keywords	dcc	report_url	image_url	latitude	longitude

Case number:

2100000032

Date:

2021-01-20

Time:

13:29

Address:

200 BOYLSTON ST

Speed limit:

0

Violation cited:

no

Narrative:

The operator of MV1 stated she parked her department of public works city vehicle, MA REG M7917A in the public parking lot of Wegmans located at 200 Boylston street at 1pm and when she came back to her vehicle around 2pm she noticed minor damage to the drivers side panel. MV1 stated there were no witnesses and she does not recall what vehicle was parked next to her. There are no cameras in the area. Pictures of the damage were taken and submitted to the IT Bureau. MV1 was able to leave the scene without further incident.

Keywords:

Pictures

Dcc:

[]

Report url:

report

Image url:

image

Latitude:

42.3191343

Longitude:

-71.1756718

Location:

200 Boylston St, Chestnut Hill, MA 02467, 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);