musiccaps
2 rows where audioset_ids contains "/m/042v_gx" and audioset_ids contains "/m/074ft" sorted by caption
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 |
---|---|---|---|---|---|---|---|---|---|---|
hTlIqICkbW8 | The low quality recording features an indie folk song that consists of wide harmonizing male vocals and acoustic rhythm guitar. In the second half of the loop, the lead female vocal appears, creating a perfect harmony with the previously mentioned male vocals. It sounds passionate, emotional and sad. | ["low quality", "wide harmonizing male vocals", "indie folk", "acoustic rhythm guitar", "lead female vocal", "passionate", "emotional", "sad"] | ["Folk music", "Acoustic guitar", "Music", "Independent music", "Song", "Strum", "Plucked string instrument"] | 4 | 60 | 70 | 0 | 1 | ["/m/02w4v", "/m/042v_gx", "/m/04rlf", "/m/05rwpb", "/m/074ft", "/m/07s0s5r", "/m/0fx80y"] | |
CzHZNJEV-3o | This clip features a nursery rhyme. The singer plays the guitar and sings in a calm and gentle tone. The singer misses some notes on the guitar - playing with some mistakes. The quality of the audio recording is low. | ["low quality audio", "acoustic guitar", "calm female vocal", "muffled recording", "missed guitar notes", "nursery rhyme"] | ["Acoustic guitar", "Music", "Music for children", "Steel guitar, slide guitar", "Song"] | 3 | 50 | 60 | 0 | 0 | ["/m/042v_gx", "/m/04rlf", "/m/05fw6t", "/m/06w87", "/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 );