musiccaps_details (view)
3 rows where musiccaps_aspects contains "addictive" and musiccaps_aspects contains "breathy flute melody" sorted by musiccaps_caption
This data as json, CSV (advanced)
musiccaps_aspects (array) 20 ✖
- addictive · 3 ✖
- breathy flute melody · 3 ✖
- low quality 3
- live performance 2
- addictive strings melody 1
- groovy strings chords 1
- joyful 1
- mono 1
- noisy 1
- passionate 1
- passionate female vocal 1
- roomy 1
- shimmering shakers 1
- simple bass 1
- soulful 1
- traditional 1
- traditional music 1
- wide acoustic guitar chords 1
- wooden percussions 1
- wooden percussive elements 1
musiccaps_names (array) 5 ✖
video | youtube_link | musiccaps_caption ▼ | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Fan Veil Bellydance by Zulay Maza @ Bozenka's Bellydance Academy | The low quality recording features a live performance and it consists of groovy strings chords, addictive strings melody, breathy flute melody, simple bass and wooden percussive elements. It is a bit noisy, roomy, mono, but still addictive and soulful. | 2009-07-02T04:25:23Z | Miamibellydancers | Fan Veil Bellydance by Zulay Maza @ Bozenka's Bellydance Academy | ["Music", "Harmonic"] | ["traditional music", "low quality", "live performance", "groovy strings chords", "addictive strings melody", "breathy flute melody", "wooden percussive elements", "simple bass", "addictive", "soulful", "noisy", "roomy", "mono"] | 4 | tWByqbOvYQE | 5045 | |
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 | |
♫ ♪ ♫ Irish Traditional Music ♪ ♫ ♪ ~ Matt Molloy & Donal Lunny | The low quality recording features a traditional song that consists of a breathy flute melody playing over wide acoustic guitar chords. It sounds addictive, joyful and passionate. | 2010-11-14T21:28:51Z | DJFozter | Two greats play two fine Irish reels. Tune #1 Master Crowley's Reel Tune #2 Roscommon Reel | ["Wind instrument, woodwind instrument", "Flute"] | ["low quality", "traditional", "wide acoustic guitar chords", "breathy flute melody", "addictive", "joyful", "passionate"] | 4 | nXfqAzdu8IY | 4548 |
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;