musiccaps_details (view)
2 rows where musiccaps_aspects contains "pastoral", musiccaps_author = 9 and musiccaps_names contains "Yodeling"
This data as json, CSV (advanced)
musiccaps_aspects (array) 15 ✖
- male vocal 2
- pastoral · 2 ✖
- yodeling 2
- accordion 1
- acoustic drums 1
- american 1
- bass guitar 1
- cheerful 1
- duet 1
- female vocal 1
- melodeon 1
- poor quality recording 1
- rapid singing 1
- swiss folk music 1
- upbeat 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 | |
Chicken Yodel - Kerry Christensen | This is a poor quality recording of a yodeling music piece. There is a male vocalist singing rapidly with the yodeling technique. The melody is being played by an accordion. There is a bass guitar playing in the background. The rhythm is provided by an upbeat acoustic drum beat. The atmosphere is cheerful. Despite the quality issue of the recording, it would suit well as a rural radio station music playing inside the car in a movie. | 2007-06-23T22:30:16Z | UnitedFan4Eva1 | Using RuneScape. Thanks To Madcrazykid1 ( Me ) MollyMoo22 ( My Sis ) --They are the main people-- If you wanna contact me, my MSN is josh.dude-@hotmail.co.uk Thanks! | ["Yodeling", "Music", "Music of Latin America"] | ["poor quality recording", "yodeling", "american", "male vocal", "rapid singing", "accordion", "bass guitar", "acoustic drums", "cheerful", "pastoral", "upbeat"] | 9 | s25X6KwBpxw | 4916 |
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;