musiccaps

1 row where aspect_list contains "bad mix", audioset_ids = "["/m/04rlf", "/m/05rwpb", "/m/06j6l", "/m/074ft"]" and audioset_ids contains "/m/04rlf"

✎ View and edit SQL

This data as json, CSV (advanced)

ytid ▼ url caption aspect_list audioset_names author_id start_s end_s is_balanced_subset is_audioset_eval audioset_ids
SG24NL2Xi3A The low quality recording features a hip hop song sung with an addictive flow by flat double male vocals over arpeggiated piano melody, boomy, layered bass and kick hits, soft crash cymbal and claps. It sounds muddy and messy as the mix of the song is bad making the frequencies clash with each other - especially in the low end. ["low quality", "hip hop", "arpeggiated piano melody", "boomy kick", "claps", "soft crash cymbal", "flat double male vocals", "boomy bass", "muddy", "messy", "bad mix", "addictive"] ["Music", "Independent music", "Rhythm and blues", "Song"] 4 30 40 1 1 ["/m/04rlf", "/m/05rwpb", "/m/06j6l", "/m/074ft"]

Advanced export

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

CSV options: 

CREATE TABLE [musiccaps] (
   [ytid] TEXT PRIMARY KEY,
   [url] TEXT,
   [caption] TEXT,
   [aspect_list] TEXT,
   [audioset_names] TEXT,
   [author_id] TEXT,
   [start_s] TEXT,
   [end_s] TEXT,
   [is_balanced_subset] INTEGER,
   [is_audioset_eval] INTEGER,
   [audioset_ids] TEXT
);