musiccaps
2 rows where aspect_list contains "energetic", aspect_list contains "passionate" and aspect_list contains "people talking"
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 |
---|---|---|---|---|---|---|---|---|---|---|
NcsYdCbKgcc | The song is an instrumental. The song is medium fast tempo with percussionists playing a groovy rhythm on three clap boxes. The sound quality is poor with a lot of ambient crowd noise. | ["clap box rhythm", "percussionist", "medium fast tempo", "live performance", "exciting", "energetic", "passionate", "drum demonstration", "youtube music video", "instrumental music", "ambient crowd noise", "groovy rhythm", "people talking", "bad audio quality", "percussion demonstration"] | ["Wood block", "Percussion"] | 1 | 90 | 100 | 0 | 0 | ["/m/01sm1g", "/m/0l14md"] | |
xL7Krm6FSWE | A male singer sings this vocals with a vocoder. The song is medium tempo with a groovy techno drumming rhythm and keyboard accompaniment. The song is passionate but an amateurish production. The audio quality is very poor. | ["vocoder", "male singers love performance", "poor audio quality", "jam session", "amateur jazz musician", "medium tempo", "amateur musician", "jazz musician", "keyboard accompaniment", "groovy music", "techno drumming rhythm", "poor audio quality", "people talking", "unimpressive", "excited", "energetic", "passionate", "ambient room noises"] | ["Singing", "Music", "Harmonic"] | 1 | 200 | 210 | 1 | 1 | ["/m/015lz1", "/m/04rlf", "/m/0b9m1"] |
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 );