musiccaps
2 rows where audioset_ids contains "/m/042v_gx" and audioset_ids contains "/m/074ft"
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 |
---|---|---|---|---|---|---|---|---|---|---|
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"] | |
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"] |
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 );