musiccaps
1 row where aspect_list contains "clarinet" and aspect_list contains "simple jazzy drum beat"
This data as json, CSV (advanced)
aspect_list (array) 9 ✖
- clarinet · 1 ✖
- fast bass playing 1
- fast paced electric guitar arpeggios 1
- intricate electric guitar licks 1
- jazz 1
- piano chords 1
- simple jazzy drum beat · 1 ✖
- speaking man 1
- upbeat jazzy music 1
ytid ▼ | url | caption | aspect_list | audioset_names | author_id | start_s | end_s | is_balanced_subset | is_audioset_eval | audioset_ids |
---|---|---|---|---|---|---|---|---|---|---|
aXDgw2fLHAA | This clip features two jazzy songs. The first one has a fast paced melody that's led by an electric guitar which plays intricate solos. The next song is led by a clarinet, it's more slow-paced and bouncy. | ["jazz", "clarinet", "fast bass playing", "upbeat jazzy music", "intricate electric guitar licks", "fast paced electric guitar arpeggios", "piano chords", "simple jazzy drum beat", "speaking man"] | ["Brass instrument", "Saxophone", "Trombone", "Trumpet", "Wind instrument, woodwind instrument"] | 3 | 70 | 80 | 0 | 0 | ["/m/01kcd", "/m/06ncr", "/m/07c6l", "/m/07gql", "/m/085jw"] |
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 );