musiccaps
3 rows where aspect_list contains "medium to uptempo" and audioset_ids contains "/m/02rr_"
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 |
---|---|---|---|---|---|---|---|---|---|---|
LFW4yPH1z3M | Someone is playing a melody on an e-guitar with a tremolo effect. This song may be playing at home practicing guitar. | ["amateur recording", "e-guitar", "tremolo", "medium to uptempo"] | ["Echo", "Effects unit", "Guitar", "Music", "Musical instrument", "Plucked string instrument"] | 6 | 30 | 40 | 0 | 1 | ["/m/01jnbd", "/m/02rr_", "/m/0342h", "/m/04rlf", "/m/04szw", "/m/0fx80y"] | |
clefr8E-iZQ | Someone is playing an e-guitar with different effects over an acoustic drumgroove. Some of the sounds are panned to the right and left side of the speakers. This song may be playing at home practicing guitar. | ["amateur recording", "e-guitar", "acoustic drums", "shaker", "medium to uptempo"] | ["Blues", "Echo", "Effects unit", "Electric guitar", "Guitar", "Music", "Musical instrument", "Chorus effect", "Plucked string instrument"] | 6 | 30 | 40 | 1 | 1 | ["/m/0155w", "/m/01jnbd", "/m/02rr_", "/m/02sgy", "/m/0342h", "/m/04rlf", "/m/04szw", "/m/07m2kt", "/m/0fx80y"] | |
i_NNY_mgxIs | This song contains a digital drums playing a four on the floor groove with a big kick sound on every beat. A e-guitar is strumming rhythmic funky chords. Towards the end you can hear a synth string playing in a high register. This song may be playing for a advertisement. | ["electro/funk", "e-guitar", "digital drums", "bass", "synth string sound", "medium to uptempo"] | ["Echo", "Effects unit", "Music"] | 6 | 40 | 50 | 1 | 1 | ["/m/01jnbd", "/m/02rr_", "/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 );