musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "simple" and musiccaps_names contains "Rattle (instrument)" sorted by youtube_description
This data as json, CSV (advanced)
musiccaps_aspects (array) 39 ✖
- foreign language 2
- lively 2
- simple · 2 ✖
- acordion melody 1
- acoustic guitar accompaniment 1
- ambient outdoor sounds 1
- animated acoustic guitar rhythm 1
- bongos 1
- celebratory 1
- cheerful 1
- classic latin songs 1
- congas 1
- earnest singing 1
- engaging 1
- enthusiastic 1
- fast tempo 1
- female singer 1
- folk song 1
- guiro 1
- hand percussions 1
- happy 1
- latin folk songs 1
- latin music 1
- latin percussions 1
- male backup 1
- male vocalists 1
- medium tempo 1
- melodic 1
- muddled audio 1
- outdoor singing 1
- regional song 1
- shakers 1
- smal hand drum 1
- spanish music 1
- spirited 1
- steady bass line 1
- tambourine 1
- tambourine used as hand drum 1
- world music 1
musiccaps_names (array) 7 ✖
- Music 2
- Rattle (instrument) · 2 ✖
- Bowed string instrument 1
- Christian music 1
- Christmas music 1
- Mantra 1
- Musical instrument 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description ▼ | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
LLEGO DICIEMBRE CON SU ALEGRIA | A female vocalist sings this classic Spanish song. The tempo is medium with a lively accordion harmony, guiro , congas and bongos rhythm, steady bass line, and acoustic guitar accompaniment. The music is simple, light, happy, joyful, cheerful, celebratory and spirited with vocal backup.There are sounds of people cheering in the background. This is a Classic Latin Folk Song. | 2012-12-02T02:33:13Z | max pardo | LLEGO DICIEMBRE | ["Christmas music", "Christian music", "Music", "Rattle (instrument)"] | ["female singer", "medium tempo", "cheerful", "happy", "spirited", "celebratory", "simple", "classic latin songs", "lively", "latin folk songs", "latin percussions", "latin music", "spanish music", "guiro", "acordion melody", "foreign language", "world music", "congas", "bongos", "acoustic guitar accompaniment", "steady bass line", "male backup", "muddled audio"] | 7 | wQN7fRaPl2A | 5264 | |
SINCHI WAIRA. MANTRA SUMA AMBIWASKA | A group of male vocalists sing this folk song in a foreign language. The tempo is fast with minimalist instruments like a lively acoustic guitar harmony, shakers and tambourine beat;The vocals are energetic, youthful, earnest, cheerful , happy, simple and chirpy. | 2013-04-23T07:17:55Z | Daniel Ortega | Poderoso mantra de sanación. Taita John Muchavisoy, Nicolas Lozada y Cristiam Herrán. Centro de sanación SINCHI WAIRA. | ["Mantra", "Music", "Musical instrument", "Rattle (instrument)", "Bowed string instrument"] | ["male vocalists", "fast tempo", "foreign language", "tambourine", "tambourine used as hand drum", "animated acoustic guitar rhythm", "hand percussions", "shakers", "smal hand drum", "folk song", "regional song", "outdoor singing", "ambient outdoor sounds", "engaging", "lively", "simple", "earnest singing", "enthusiastic", "melodic"] | 7 | qbIPQGY8RRA | 4800 |
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;