level

1 row where description = "for 2024 RD New Year ", 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)

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
gambit-RDn2LZvD9ZR 雄之助 ["雄之助"] ["sleepy101"] for 2024 RD New Year [{"len":21,"color":"default"}] 2 0 0 1 1 1 1 1 1 1.0 https://codex.rhythm.cafe/gambit-RDn2LZvD9ZR_icon.png https://codex.rhythm.cafe/gambit-RDn2LZvD9ZR.png 2024-01-13 23:03:30 137.0 137.0 ebad009ec5d63300263e14c41adccd2c24d2ab34 1 0ca1a53249c7d8e4fc996475175f386d6a496d8b 1 Gambit [{"len":6,"color":"default"}] rdl 1206606113458622474|1206606112753721344 {"user_id":"1156988031090302977","timestamp":"2024-02-12T14:21:55.106000+00:00"} [] https://codex.rhythm.cafe/gambit-RDn2LZvD9ZR_thumbnail.png 0 https://cdn.discordapp.com/attachments/611380148431749151/1206606112753721344/Gambit.rdzip?ex=65dc9e82&is=65ca2982&hm=94a79968ef88a1408c159d9cf6aef566f2e499d4f34ac8835ebd9f33f0bf1e13& https://codex.rhythm.cafe/gambit-RDn2LZvD9ZR.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);