level

1 row where has_window_dance = 1 and song_ct = "[{"len":39,"color":"default"}]"

✎ 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
this-is-R1uSJDWa9xt JVKE ["JVKE"] ["zeankun.dev"] Cole Brew and Nicole Ting seems to love each other. Well, that's just it. *DISCLAIMER: everything here is fanon, it's not canon with any relevant relationships. [{"len":161,"color":"default"}] 0 1 0 0 1 1 0 0 1 0.35 https://codex.rhythm.cafe/this-is-R1uSJDWa9xt_icon.png https://codex.rhythm.cafe/this-is-R1uSJDWa9xt.png 2024-03-09 05:36:26 154.0 67.0 b8c4a4ff7c4b499ef5f4debe89cd3a7b2ff5ea98 0 2054590193dca6859752cac3a000d97eef780d50 1 this is what falling in love feels like [{"len":39,"color":"default"}] rdl 1215790365865541804|1215790365672472768 {"user_id":"793983601288544286","timestamp":"2024-03-08T22:36:51.515000+00:00"} [] https://codex.rhythm.cafe/this-is-R1uSJDWa9xt_thumbnail.png 0 https://cdn.discordapp.com/attachments/611380148431749151/1215790365672472768/JVKE_-_this_is_what_falling_in_love_feels_like.rdzip?ex=65fe0803&is=65eb9303&hm=d3de4dd609b7c179d2203a94bed9ae202f65dbbdc84c325002f53dd732a3468a& https://codex.rhythm.cafe/this-is-R1uSJDWa9xt.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);