musiccaps
2 rows where aspect_list contains "vibrant" and audioset_ids contains "/m/05r6t"
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 |
---|---|---|---|---|---|---|---|---|---|---|
3nbB3F-OdSM | A male vocalist sings this vigorous Rock song. The tempo is fast with enthusiastic electric guitar lead and harmonies, electric bass guitar and hard hitting drumming with cymbal rides. The song is passionate, youthful, enthusiastic, intense, compelling, boisterous and vigorous. This song is a Hard Rock/Heavy Metal song. | ["male vocalist", "energetic drumming", "loud electric guitar feedback", "electric guitar lead and harmony", "enthusiastic vocal backup", "youthful", "enthusiastic", "energetic", "vibrant", "boisterous", "voracious", "intense", "passionate", "metal", "hard rock", "rock music", "heavy metal", "electric bass guitar"] | ["Music", "Punk rock", "Progressive rock", "/t/dd00032"] | 7 | 30 | 40 | 0 | 1 | ["/m/04rlf", "/m/05r6t", "/m/0dl5d", "/t/dd00032"] | |
QqRrZzOY2xw | This is a rock opera piece. There is a male vocalist singing passionately with a choir of backing vocals. The piano plays the main theme with the electric guitar while a bass guitar plays in the background. The rhythmic background is provided by the acoustic drums playing a simple rock beat. There is an energetic atmosphere to the piece. This piece could be used at sports venues. It could also be playing in the background of a bar. | ["rock opera", "male vocal", "dramatic singing", "choir", "piano", "electric guitar", "bass guitar", "acoustic drums", "rising pattern", "vibrant", "energetic"] | ["Music", "Punk rock", "Grunge"] | 9 | 30 | 40 | 0 | 1 | ["/m/04rlf", "/m/05r6t", "/m/0dls3"] |
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 );