level

2 rows where description_ct = "[]", has_holds = 1 and has_window_dance = 1

✎ View and edit SQL

This data as json, CSV (advanced)

CREATE TABLE "level" ("id" TEXT NOT NULL PRIMARY KEY, "artist" TEXT NOT NULL, "artist_tokens" JSON NOT NULL, "authors" JSON NOT NULL, "description" TEXT NOT NULL, "description_ct" JSON NOT NULL, "difficulty" INTEGER NOT NULL, "has_classics" INTEGER NOT NULL, "has_freetimes" INTEGER NOT NULL, "has_freezeshots" INTEGER NOT NULL, "has_holds" INTEGER NOT NULL, "has_oneshots" INTEGER NOT NULL, "has_skipshots" INTEGER NOT NULL, "has_squareshots" INTEGER NOT NULL, "has_window_dance" INTEGER NOT NULL, "hue" REAL NOT NULL, "icon" TEXT, "image" TEXT NOT NULL, "last_updated" DATETIME NOT NULL, "max_bpm" REAL NOT NULL, "min_bpm" REAL NOT NULL, "rdlevel_sha1" TEXT NOT NULL, "seizure_warning" INTEGER NOT NULL, "sha1" TEXT NOT NULL, "single_player" INTEGER NOT NULL, "song" TEXT NOT NULL, "song_ct" JSON NOT NULL, "source" TEXT NOT NULL, "source_iid" TEXT NOT NULL, "source_metadata" JSON, "tags" JSON NOT NULL, "thumb" TEXT, "two_player" INTEGER NOT NULL, "url" TEXT, "url2" TEXT NOT NULL, "rd_md5" TEXT);