musiccaps_details (view)
2 rows where musiccaps_aspects contains "addictive", musiccaps_aspects contains "passionate female vocal" and musiccaps_aspects contains "shimmering shakers"
This data as json, CSV (advanced)
musiccaps_aspects (array) 13 ✖
- addictive · 2 ✖
- passionate female vocal · 2 ✖
- shimmering shakers · 2 ✖
- breathy flute melody 1
- fade out 1
- groovy bass 1
- intimate 1
- live performance 1
- low quality 1
- passionate 1
- pop 1
- wide electric guitar melodies 1
- wooden percussions 1
musiccaps_names (array) 4 ✖
- Funk 1
- Music 1
- Singing 1
- Tambourine 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Nasty Girl by Destiny's Child | The Pop song features a passionate female vocal singing over groovy bass, wide electric guitar melodies and shimmering shakers, as the overall audio is slowly fading out. It sounds addictive, passionate and intimate. | 2007-04-15T07:50:17Z | Bubblez1636 | Destiny's Child's song, Nasty Girl, with a compilation of video footage they made AFTERWARDS. Funny | ["Singing", "Funk"] | ["pop", "passionate female vocal", "groovy bass", "wide electric guitar melodies", "shimmering shakers", "fade out", "addictive", "passionate", "intimate"] | 4 | C-7ubPOCeJk | 1314 | |
Bollywood Dance - Ringa Ringa - Slumdog Millionaire - http://www.bollywooddance.org.uk | The low quality recording features a live performance that consists of shimmering shakers, wooden percussion, breathy flute melody and passionate female vocals singing over it. It sounds very addictive, due to the lead vocal cadence. It is a bit reverberant, as it was recorded in a larger room, with a low quality microphone. | 2010-07-03T13:35:27Z | Mahadev Semwal | Students of Bollywood Dance Worldwide at Reading Berkshire learning Ringa Ringa from Slumdog Millionaire. More workshop related information at http://www.bollywooddance.org.uk/workshops More performance related information at http://www.bollywooddance.org.uk/videos More hen night related information at http://www.bollywooddance.org.uk/hennights | ["Music", "Tambourine"] | ["low quality", "shimmering shakers", "wooden percussions", "passionate female vocal", "live performance", "addictive", "breathy flute melody"] | 4 | uF1KTW5rT-s | 5102 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW musiccaps_details AS select musiccaps.url as video, json_object( 'label', coalesce(videos.title, 'Missing from YouTube'), 'href', musiccaps.url ) as youtube_link, musiccaps.caption as musiccaps_caption, videos.publishedAt as youtube_published, videos.channelTitle as youtube_channel, videos.description as youtube_description, musiccaps.audioset_names as musiccaps_names, musiccaps.aspect_list as musiccaps_aspects, musiccaps.author_id as musiccaps_author, videos.id as youtube_id, musiccaps.rowid as musiccaps_rowid from musiccaps left join videos on musiccaps.ytid = videos.id;