musiccaps_details (view)
3 rows where musiccaps_aspects contains "tambourine" and musiccaps_names contains "Bowed string instrument"
This data as json, CSV (advanced)
musiccaps_aspects (array) 35 ✖
- tambourine · 3 ✖
- moderate tempo 2
- amateur recording 1
- ambient outdoor sounds 1
- animated acoustic guitar rhythm 1
- banjo 1
- earnest singing 1
- engaging 1
- enthusiastic 1
- fast tempo 1
- flute 1
- folk song 1
- foreign language 1
- hand percussions 1
- happy mood 1
- instrumental 1
- lively 1
- male vocalists 1
- male voice 1
- melodic 1
- middle eastern song 1
- no voices 1
- oud 1
- outdoor singing 1
- percussion 1
- qanun 1
- regional song 1
- rock song 1
- shakers 1
- simple 1
- simple percussion 1
- smal hand drum 1
- song for belly dance 1
- tambourine used as hand drum 1
- violins 1
musiccaps_names (array) 9 ✖
- Bowed string instrument · 3 ✖
- Music 3
- Musical instrument 2
- Banjo 1
- Bluegrass 1
- Folk music 1
- Mantra 1
- Middle Eastern music 1
- Rattle (instrument) 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Classical Gas by Roy Clark Band Banjo Pickin' 1987 Live | This amateur recording features a rock song. The main melody is played on violins. This is accompanied by percussion playing with breaks matching the breaks in the violin parts. At the end, the violins play a sustained note and a banjo starts to play a melody. A tambourine is played on the first count of the second bar after the banjo starts to play. This is an uptempo song and has a happy feel. This instrumental song can be played in a coffee shop. | 2007-06-12T06:30:56Z | NelnetDude | Enjoy! | ["Banjo", "Music", "Musical instrument", "Bowed string instrument"] | ["amateur recording", "rock song", "instrumental", "no voices", "violins", "banjo", "tambourine", "simple percussion", "happy mood", "moderate tempo"] | 0 | MpWGx5odhh8 | 2301 | |
LaurelBellydance - Middle Eastern Music & Dance Camp 2011 | This middle-eastern song features a male voice singing the main melody. An oud plays the same melody as the voice. This is accompanied by middle-eastern percussion instruments played with the hands. A tambourine is played to accent the percussion beats. After the voice, the main melody is played on a flute. This is accompanied by a qanun. This song can be played for a belly dance programme. | 2011-09-04T20:49:36Z | LaurelBellydance | www.laurelbellydance.com | ["Folk music", "Music", "Middle Eastern music", "Bluegrass", "Bowed string instrument"] | ["middle eastern song", "flute", "oud", "qanun", "percussion", "tambourine", "song for belly dance", "male voice", "moderate tempo"] | 0 | NHA1l_Czm38 | 2327 | |
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;