musiccaps_details (view)
2 rows where musiccaps_aspects contains "breathy flute melody", musiccaps_aspects contains "shimmering shakers" and musiccaps_aspects contains "wooden percussions"
This data as json, CSV (advanced)
musiccaps_aspects (array) 14 ✖
- breathy flute melody · 2 ✖
- low quality 2
- shimmering shakers · 2 ✖
- wooden percussions · 2 ✖
- addictive 1
- folk 1
- groovy bass 1
- groovy piano melody 1
- happy 1
- joyful 1
- live performance 1
- passionate 1
- passionate female vocal 1
- sustained strings melody 1
musiccaps_names (array) 3 ✖
- Music 2
- Happy music 1
- Tambourine 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Sozan Namo ( Seny Pr Ihm )* kurdish Music * | The low quality recording features a folk song that consists of a wooden percussion, groovy bass, breathy flute melody, groovy piano melody, shimmering shakers and sustained strings melody. It sounds passionate, joyful and happy. | 2010-05-10T13:43:42Z | Hemmen A M | Best Song .......... | ["Music", "Happy music"] | ["low quality", "folk", "wooden percussions", "groovy bass", "breathy flute melody", "groovy piano melody", "sustained strings melody", "shimmering shakers", "passionate", "happy", "joyful"] | 4 | -mA_bqD1tgU | 83 | |
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;