musiccaps_details (view)
3 rows where musiccaps_aspects contains "cheerful", musiccaps_aspects contains "instrumental" and musiccaps_aspects contains "regional music"
This data as json, CSV (advanced)
musiccaps_aspects (array) 38 ✖
- cheerful · 3 ✖
- instrumental · 3 ✖
- regional music · 3 ✖
- celebratory 2
- country music 2
- folk music 2
- shakers 2
- sunny 2
- banjo 1
- bouncy 1
- charming 1
- classical 1
- country folk music 1
- energetic 1
- enthusiastic 1
- fast tempo 1
- festive 1
- fiddle 1
- flute 1
- folk dance 1
- folk song 1
- hand drums 1
- hand percussion 1
- happy 1
- joyful 1
- madal 1
- medium tempo 1
- melodic 1
- pedal steel guitar 1
- peppy 1
- pleasant 1
- sarangi 1
- simple 1
- simple joys 1
- string instrument 1
- stringed instrument harmony 1
- tambourine beats 1
- upbeat 1
musiccaps_names (array) 7 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
watra safi | This music is an energetic instrumental. The tempo is fast with a regional string instrument playing the lead with hand percussion like a small hand drum, tambourine and shaker beats. The music is lively, cheerful, happy, youthful, buoyant, enthusiastic, sunny and celebratory with a peppy dance groove. This music is Folk dance music. | 2011-12-31T18:18:01Z | watrasafi2012 | ["Music of Africa", "Music", "Musical instrument", "Rattle (instrument)"] | ["instrumental", "fast tempo", "tambourine beats", "peppy", "enthusiastic", "happy", "cheerful", "simple", "celebratory", "festive", "simple joys", "sunny", "bouncy", "folk music", "regional music", "folk dance", "stringed instrument harmony", "hand drums", "shakers"] | 7 | FAhfuP_xh5Y | 1620 | ||
Nickle-Harpa - Banjo duet at Clifftop 2011 | This music is a lively country music instrumental. The tempo is fast and upbeat with a banjo, and an instrument that sounds like a fiddle. The instrument is like pedal steel being played like a fiddle.the music is vibrant, vigorous, vivacious, cheerful, happy, sunny, happy and upbeat. This music is classic Country Pop. | 2012-06-02T19:10:19Z | banjowim | Here are 2 Swedisch tunes played as a duet on Banjo and Nyckle-Harpa.As played at the wedding of Rachel Eddy andChristian Herner at Clifftop 2011. Lovely combination of Crisp melodic banjo-picking and sweet sound of Nickle-Harpa. | ["Banjo", "Music", "Mandolin"] | ["instrumental", "banjo", "pedal steel guitar", "fiddle", "country music", "country folk music", "regional music", "upbeat", "energetic", "cheerful", "pleasant", "joyful", "sunny", "celebratory"] | 7 | crToMuDxmL8 | 3749 | |
Baraha Jewellery, Jordan, Hong Kong | This music is instrumental. The tempo is slow with a harmonious melody of string instruments, percussion and wind instruments which sound like the Indian Sarangi, dhol or madal , shakers and a flute. The music is classical, simple, enchanting and melodic. This song is a Folk song Instrumental. | 2012-09-06T16:53:26Z | DigitalEyeHK | Baraha Jewellery, Jordan, Hong Kong. www.barahajewellery.com. FOR MORE VIDEO http://www.jpthk.com | ["Traditional music", "Music"] | ["instrumental", "medium tempo", "flute", "string instrument", "cheerful", "charming", "classical", "melodic", "sarangi", "madal", "folk music", "country music", "regional music", "folk song", "shakers", "hand percussion"] | 7 | otVPTo72q4w | 4662 |
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;