musiccaps
2 rows where aspect_list contains "groovy" and audioset_ids = "["/m/01s0ps", "/m/05148p4", "/m/05r5c"]"
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 |
---|---|---|---|---|---|---|---|---|---|---|
ccsgja0XsWE | This music is an energetic instrumental. The tempo is fast with a synthesizer groove followed by instructions in a male voice and with another synthesiser groove. This is a synthesiser, demonstration, review or tutorial on how to add layers to a sound track. The music is energetic, youthful, enthusiastic, high-spirited , funky and pulsating. | ["instrumental", "fast tempo", "synthesiser arrangement", "bass track", "funk guitar track", "layering", "soundtrack", "synthesised bass", "synthesises funk guitar", "techno", "edm", "electro pop", "two seperate grooves", "male voice talking", "synth review", "synthesiser demonstration", "synthesiser lesson", "synthesiser tutorial", "lively", "funky", "groovy", "vivacious", "punchy", "catchy"] | ["Electric piano", "Keyboard (musical)", "Piano"] | 7 | 250 | 260 | 0 | 0 | ["/m/01s0ps", "/m/05148p4", "/m/05r5c"] | |
wC0mY7NzihY | The low quality recording features a digital piano, funky chords played over punchy kick, fat snare and shimmering hi hats. The digital piano uses a wah pedal effect, which makes it sound funky and groovy. | ["low quality", "digital piano funky chords", "punchy kick", "fat snare", "shimmering hi hats", "groovy", "wah pedal effect", "funky"] | ["Electric piano", "Keyboard (musical)", "Piano"] | 4 | 380 | 390 | 0 | 0 | ["/m/01s0ps", "/m/05148p4", "/m/05r5c"] |
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 );