musiccaps
1 row where aspect_list contains "animated", aspect_list contains "emphatic percussion" and aspect_list contains "trumpet harmony"
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 |
---|---|---|---|---|---|---|---|---|---|---|
OH2SQhJqZDg | This music is an energetic Rock and Roll instrumental. The tempo is fast with animated, infectious drumming, lively trumpets and tambourine beats. The music is upbeat, pulsating, thumping, vivacious, bright, with a perky dance groove. This music is Rock and Roll. | ["instrumental", "fast tempo", "bright drumming", "dance groove", "animated", "energetic", "percussion", "emphatic percussion", "lively trumpets", "bass drums", "tambourine beats", "snare", "trumpet harmony", "brass band", "spirited", "animated", "enthusiastic", "swing", "rock and roll"] | ["Timpani", "Music of Asia", "Music"] | 7 | 0 | 10 | 1 | 1 | ["/m/011k_j", "/m/028sqc", "/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 );