musiccaps

1 row where aspect_list contains "electro house" and author_id = 7

✎ 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
7avMUhHOCR8 A male vocalist sings this enthusiastic Electro Hop. The tempo is fast with synthesiser articulation, Dj mixer and digital drum beats. The song has emphatic, insistent vocals, punchy, youthful, buoyant, funky,strong,psychedelic, persuasive, groovy and untiring. This song is a contemporary Electronic HIp-Hop. ["male vocalist", "fast tempo", "rap", "hip-hop", "edm", "funky", "drum machines", "electronica", "trap", "dance music", "club music", "electro hop", "heavy bass", "electro house", "edm trap", "rave music", "psychedelic", "hypnotic", "dj mixer", "electronic arrangements", "digital drums", "synthesiser articulation", "rhythmic patter", "vigorous vocals", "youthful", "incessant", "persuasive", "emphatic", "energetic", "enthusiastic"] ["Blues", "Music", "Pop music"] 7 30 40 0 0 ["/m/0155w", "/m/04rlf", "/m/064t9"]

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