musiccaps
2 rows where aspect_list contains "vibrant" and audioset_ids contains "/m/0dl5d"
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"] | |
pp6eSGANq0Y | A female vocalist sings this spirited song. The tempo is fast with enthusiastic electric guitar harmony, slick drumming, groovy bass lines and synthesiser arrangements. The song is energetic, youthful, fun, pulsating, engaging and emphatic. This song is Alternative Rock. | ["female vocalist", "fast tempo", "vibrant electric guitars", "progressive rock", "symphonic rock", "alternative rock", "slick drumming", "synthesiser articulation", "vivacious", "youthful", "vibrant", "groovy bass lines", "engaging", "powerful", "rock", "classic rock", "soft rock"] | ["Singing", "Heavy metal", "Music", "Independent music", "Pop music", "Rock music", "Song", "Progressive rock"] | 7 | 80 | 90 | 1 | 1 | ["/m/015lz1", "/m/03lty", "/m/04rlf", "/m/05rwpb", "/m/064t9", "/m/06by7", "/m/074ft", "/m/0dl5d"] |
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 );