home / orchard

level

1 row where description = "You know what to do, Intern.", seizure_warning = 1 and source = "rdl"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: last_updated (date), artist_tokens (array), authors (array), tags (array)

id ▼ artist artist_tokens authors description description_ct difficulty has_classics has_freetimes has_freezeshots has_holds has_oneshots has_skipshots has_squareshots has_window_dance hue icon image last_updated max_bpm min_bpm rdlevel_sha1 seizure_warning sha1 single_player song song_ct source source_iid source_metadata tags thumb two_player url url2 rd_md5
rainbow-buAKCQBYJDx WoodenToaster ["WoodenToaster"] ["lightfall"] You know what to do, Intern. [{"len":28,"color":"default"}] 0 0 0 1 0 1 0 1 1 0.5 https://codex.rhythm.cafe/rainbow-buAKCQBYJDx_icon.png https://codex.rhythm.cafe/rainbow-buAKCQBYJDx.png 2024-04-10 16:48:12 148.0 148.0 976c9b02ba471c50c56300c73a9d2fb95c9aec52 1 c4dd6e2aafc7c8f74fd5ccfbc2c52d59e61ec6e5 1 Rainbow Factory [{"len":15,"color":"default"}] rdl 1227722112865927261|1227722112794628167 {"user_id":"1186805163692929096","timestamp":"2024-04-10T20:49:21.681000+00:00"} ["electronic","oneshot","subdivision","burnshot","freezeshot","stutter","window dance","window resize","mlp","lucky"] https://codex.rhythm.cafe/rainbow-buAKCQBYJDx_thumbnail.png 0 https://cdn.discordapp.com/attachments/611380148431749151/1227722112794628167/WoodenToaster_-_Rainbow_Factory.rdzip?ex=66297051&is=6616fb51&hm=7429762bdd601052e819572abf1d4e3fe5c3a7ff24dd0b3ca9ff0266f0dbd250& https://codex.rhythm.cafe/rainbow-buAKCQBYJDx.rdzip  

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

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);
Powered by Datasette · Queries took 882.584ms