musiccaps
2 rows where aspect_list contains "pop" and audioset_ids contains "/m/028ght"
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 |
---|---|---|---|---|---|---|---|---|---|---|
pHj8U-3RHc4 | The low quality recording features a live performance of a pop song and it consists of a passionate boy vocal singing over wide synth melody, reversed crash riser, punchy kick and snare hits, shimmering hi hats, groovy synth bass and later sustained synth bass. There is some crowd noise and cheering sounds. It sounds addictive, energetic and exciting. | ["low quality", "pop", "live performance", "crowd cheering", "crowd clapping", "passionate boy vocal", "wide synth melody", "reversed crash riser", "punchy kick", "punchy bass", "sustained synth bass", "groovy synth bass", "shimmering hi hats", "energetic", "exciting", "addictive"] | ["Applause", "Music of Asia", "Music"] | 4 | 30 | 40 | 0 | 0 | ["/m/028ght", "/m/028sqc", "/m/04rlf"] | |
qwI32Si0ipE | The low quality recording features a live performance of a pop song and it consists of passionate male vocal singing over synth keys melody, shimmering riser, simple hi hats, punchy kick and snare hits and synth pad chords. There were some widely spread crowd claps and cheering as they were excited. It sounds energetic, exciting and passionate. | ["low quality", "live performance", "pop", "passionate male vocal", "crowd clapping", "crowd cheering", "synth keys melody", "shimmering riser", "simple hi hats", "punchy snare", "punchy kick", "synth pad chords", "passionate", "energetic", "exciting"] | ["Applause", "Music"] | 4 | 30 | 40 | 1 | 1 | ["/m/028ght", "/m/04rlf"] |
Advanced export
JSON shape: default, array, newline-delimited, object
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 );