level
2 rows where has_window_dance = 1 and song_ct = "[{"len":22,"color":"default"}]"
This data as json, CSV (advanced)
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ghosts-w-AM64AEKMVkH | Plastic Patina | ["Plastic Patina"] | ["Zack101155"] | spooky window dance nvvk sbjr kvj | [{"len":36,"color":"default"}] | 1 | 1 | 1 | 0 | 0 | 1 | 0 | 0 | 1 | 0.69 | https://codex.rhythm.cafe/ghosts-w-AM64AEKMVkH_icon.png | https://codex.rhythm.cafe/ghosts-w-AM64AEKMVkH.png | 2021-10-25 01:21:58 | 110.0 | 110.0 | 08e902c7a705636b2cc3996c3ec0348a10b3f0f1 | 1 | d3aedf2cc689776f4b32710899f031c184fb67b9 | 1 | Ghosts With Heartbeats | [{"len":22,"color":"default"}] | yeoldesheet | https://cdn.discordapp.com/attachments/611380148431749151/901885893072285696/Plastic_Patina_-_Ghosts_With_Heartbeats.rdzip | ["1p","slow","lo-fi","lofi","windowdance"] | https://codex.rhythm.cafe/ghosts-w-AM64AEKMVkH_thumbnail.png | 0 | https://cdn.discordapp.com/attachments/611380148431749151/901885893072285696/Plastic_Patina_-_Ghosts_With_Heartbeats.rdzip | https://codex.rhythm.cafe/ghosts-w-AM64AEKMVkH.rdzip | ||
| sukidaka-97KgaK6gw5B | Yuika | ["Yuika"] | ["Caprisk"] | (MASSIVE SEIZURE WARNING LIKE YOU GET FLASHBANGED HALFWAY THROUGH AND REQUIRES BETA) This is, as you can probably guess, my first level. I probably shouldn't have messed with window dance but here I am. [LEVEL DESCRIPTION] It seems the Cole and Nicole are lost in the bitterness of their relationship. Intern, can you help them with their heartache? | [{"len":350,"color":"default"}] | 0 | 1 | 1 | 0 | 0 | 1 | 1 | 0 | 1 | 0.84 | https://codex.rhythm.cafe/sukidaka-97KgaK6gw5B_icon.png | https://codex.rhythm.cafe/sukidaka-97KgaK6gw5B.png | 2026-02-21 23:26:58 | 165.0 | 100.0 | cd1c096dd419b76aab53388294bd620a6af7ff58 | 1 | 7ce1997968b87af847b0cf70d7b3db23e2364456 | 1 | Sukidakara (Duet ver.) | [{"len":22,"color":"default"}] | rdl | 1474973987695235204|1474973986877341850 | {"user_id":"858646431044075530","timestamp":"2026-02-22T03:40:02.358000+00:00"} | ["Cocole","Loghail","1P","2P","7beat","6beat","5beat","4beat","Oneshots","Syncopation","Window Dance","Wance","Because I like you","Romance."] | https://codex.rhythm.cafe/sukidaka-97KgaK6gw5B_thumbnail.png | 1 | https://cdn.discordapp.com/attachments/611380148431749151/1474973986877341850/Yuika_-_Sukidakara_Duet_ver..rdzip?ex=699bcc12&is=699a7a92&hm=3a2ed8eba38c768ac16c3932f1932530e72d2644e28748e8bbf8bfa0e97bd474& | https://codex.rhythm.cafe/sukidaka-97KgaK6gw5B.rdzip | 28d9a96a7411dbfcba9db6dcf8e20ccc |
Advanced export
JSON shape: default, array, newline-delimited, object
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);