musiccaps
2 rows where aspect_list contains "passionate" and audioset_ids contains "/m/05fw6t"
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 |
---|---|---|---|---|---|---|---|---|---|---|
98YBS2tdpdU | The low quality recording features a children's song that consists of passionate girls and boys singing over soft kick and snare hits, shimmering shakers located in the left channel of the stereo image, groovy bass, synth lead melody and groovy piano melody. It sounds soft, mellow, passionate, happy, fun and joyful - like something kids and babies would listen to. | ["low quality", "shimmering shakers", "groovy piano melody", "synth lead melody", "groovy bass", "soft kick", "soft snare", "passionate boys vocals", "passionate girls vocals", "children song", "soft", "mellow", "passionate", "happy", "fun", "joyful"] | ["Christmas music", "Music", "Music for children"] | 4 | 120 | 130 | 0 | 0 | ["/m/0140xf", "/m/04rlf", "/m/05fw6t"] | |
LTG-uVV_6q0 | The low quality recording features a cover of a rock song and it consists of a passionate girl vocal singing over acoustic rhythm guitar chords and simple bass guitar. It sounds passionate, emotional, heartfelt, mellow and soft. | ["low quality", "cover", "rock", "acoustic rhythm guitar", "simple bass guitar", "passionate girl vocal", "passionate", "emotional", "heartfelt", "mellow", "soft"] | ["Acoustic guitar", "Music", "Music for children"] | 4 | 30 | 40 | 0 | 0 | ["/m/042v_gx", "/m/04rlf", "/m/05fw6t"] |
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 );