musiccaps
1 row where aspect_list contains "acoustic guitar" and aspect_list contains "footsteps"
This data as json, CSV (advanced)
aspect_list (array) 9 ✖
- acoustic 1
- acoustic guitar · 1 ✖
- christmas 1
- electric guitar 1
- festive 1
- footsteps · 1 ✖
- jingle 1
- male vocals 1
- rock 1
ytid ▼ | url | caption | aspect_list | audioset_names | author_id | start_s | end_s | is_balanced_subset | is_audioset_eval | audioset_ids |
---|---|---|---|---|---|---|---|---|---|---|
SLdVSirZMSI | This is an amateur acoustic rock performance of a Christmas song. There are three male voices singing the song. Two acoustic guitars and an electric guitar provide the melodic background. The players are stepping their foot on the ground for an added percussive effect to keep the rhythm. | ["rock", "acoustic", "jingle", "christmas", "male vocals", "acoustic guitar", "electric guitar", "footsteps", "festive"] | ["Christmas music", "Singing", "Guitar", "Music", "Song"] | 9 | 30 | 40 | 0 | 1 | ["/m/0140xf", "/m/015lz1", "/m/0342h", "/m/04rlf", "/m/074ft"] |
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 );