musiccaps_details (view)
2 rows where musiccaps_names contains "Flute" and "youtube_published" is on date 2012-12-14
This data as json, CSV (advanced)
musiccaps_aspects (array) 14 ✖
- breathy flute melody 1
- distorted 1
- duet 1
- female vocal 1
- low quality 1
- male vocal 1
- mellow strings melody 1
- melodeon 1
- noisy 1
- passionate 1
- pastoral 1
- soulful 1
- swiss folk music 1
- yodeling 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Jodelduett Vreni und Franz Stadelmann Escholzmatt | This is a Swiss folk music piece. There is a male vocal and there is a female vocal. They are yodeling as a duet. The melody in the background is being played by a melodeon. There is a pastoral feel to it. This piece could be used in the soundtrack of a movie that takes place in the Alps region. | 2012-12-14T22:29:28Z | entlebucher100 | http://sergeschmid.ch/jodelduett-franz-und--vreni-stadelmann---kapelle-paradisio.html | ["Yodeling", "Music", "Flute", "Accordion"] | ["swiss folk music", "yodeling", "male vocal", "female vocal", "duet", "melodeon", "pastoral"] | 9 | -W5c6CeUMPE | 56 | |
Raga Shuddha Sarang on Bansuri | The low quality recording features a breathy flute melody played over mellow strings melody. It sounds soulful and passionate. The recording is noisy and slightly distorted. | 2012-12-14T03:27:54Z | Bansuriflute | Http://www.bansuriflute.com Http://www.facebook.com/bansuriflute Raga Shuddha Sarang is an afternoon raga signifying the element of fire and heat. It is played here in form of free improvisation (alap) and two compositions in teentaal (rhythm of 16 beats) and Ektaal (12 beats). Accompanying on tabla is Vikas Yendluri. | ["Wind instrument, woodwind instrument", "Flute"] | ["low quality", "noisy", "breathy flute melody", "mellow strings melody", "soulful", "passionate", "distorted"] | 4 | GWcTd6XrQj4 | 1730 |
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;