musiccaps

2 rows where aspect_list contains "addictive" and audioset_names contains "Disco"

✎ 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
ojdqgnmcgYM The low quality recording features a pop song that consists a passionate female lead vocal, alongside harmonizing female vocal, singing over groovy synth bas, claps, shimmering hi hats, punchy "4 on the floor" kick pattern, electric guitar melody and short groovy synth keys chords. It sounds energetic, groovy and addictive. The recording is noisy. ["low quality", "pop", "groovy synth bass", "passionate female lead vocal", "harmonizing female vocal", "claps", "shimmering hi hats", "punchy \"4 on the floor\" kick pattern", "electric guitar melody", "short groovy synth keys chords", "energetic", "groovy", "addictive", "noisy"] ["Disco"] 4 80 90 0 0 ["/m/026z9"]
yzjbAxCnt7U The Disco song features a passionate male vocal, alongside harmonizing background vocals, singing over sustained strings melody, piano melody, brass melody, punchy kick and snare hits, shimmering hi hats and some claps. It sounds funky, addictive and passionate - like something you would hear in clubs during the 70s. ["disco", "harmonizing background vocals", "passionate male vocal", "sustained strings melody", "piano melody", "brass melody", "punchy kick", "punchy snare", "shimmering hi hats", "claps", "funky", "addictive", "passionate"] ["Disco", "Music", "Soul music"] 4 50 60 0 0 ["/m/026z9", "/m/04rlf", "/m/0gywn"]

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
);