musiccaps_details (view)
3 rows where musiccaps_aspects contains "lively", musiccaps_aspects contains "percussion" and musiccaps_names contains "Traditional music"
This data as json, CSV (advanced)
musiccaps_aspects (array) 31 ✖
- lively · 3 ✖
- percussion · 3 ✖
- instrumental 2
- afro cuban dance 1
- amateur recording 1
- animated 1
- bongo 1
- bow stringed 1
- bright 1
- cajun music 1
- conga 1
- country music 1
- drums 1
- fast tempo 1
- fiddle 1
- four stringed instrument 1
- high pitched 1
- historical movie music 1
- live performance 1
- lute 1
- male vocals 1
- medieval music 1
- melodious 1
- spirited 1
- street performance 1
- string instrument 1
- timbale 1
- vibrant 1
- vielle 1
- violin 1
- western classical 1
musiccaps_names (array) 10 ✖
- Music 3
- Traditional music · 3 ✖
- Blues 1
- Bowed string instrument 1
- Country 1
- Dance music 1
- Jazz 1
- Musical instrument 1
- Speech 1
- Violin, fiddle 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Afro Cuban Rumba music and dance -- havana, cuba | This is an amateur recording of an Afro-cuban dance music performance. There are male vocals singing joyfully. There is a percussion orchestra made up of diverse elements such as the conga, the bongo and the timbales are playing in the rhythmic background. The atmosphere is lively and vibrant. Although the audio quality is not that great, this piece can still be sampled for use in beat-making. | 2009-03-26T00:28:54Z | mathmuse | live at the palenque -- vedado, havana, cuba | ["Blues", "Traditional music", "Music", "Speech", "Dance music"] | ["afro cuban dance", "amateur recording", "street performance", "male vocals", "percussion", "conga", "bongo", "timbale", "lively", "vibrant"] | 9 | 07mS0mSTDjY | 124 | |
Hesperion XXI Ancient Music part 2 | This is the live performance of a medieval music piece. The piece is instrumental. The main melody is being played by a vielle while the lute is playing a backing tune. The rhythm is provided by the drums and a chime bell percussion. The atmosphere is lively. This piece could be used in the soundtrack of a historical drama movie or a TV show that takes place during the medieval era. | 2007-08-31T14:06:42Z | TeodorFok | Ancient, Medieval, Church Music, Hesperion XXI | ["Traditional music", "Jazz", "Music"] | ["medieval music", "instrumental", "live performance", "vielle", "lute", "drums", "percussion", "lively", "historical movie music"] | 9 | 7zP5kNyDn88 | 895 | |
Dewey Balfa - Jai Ete Au Bal - Awesome Fiddlesticks | This music is a lively fiddle instrumental. The tempo is fast with a percussion accompaniment. The music is spirited, vibrant, enthusiastic,cheerful, happy , merry and sunny. This music is Country Folk. | 2008-02-03T02:16:58Z | Paul | Clip is taken from Yasha Aginsky's documentary "Les Blues de Balfa". It is an AWESOME film I would HIGHLY recommend. Dewey Balfa and his nephew Tony Balfa preforming Jai Ete Au Bal (I Went To The Dance). | ["Country", "Traditional music", "Music", "Musical instrument", "Violin, fiddle", "Bowed string instrument"] | ["instrumental", "fast tempo", "fiddle", "string instrument", "cajun music", "spirited", "bright", "melodious", "violin", "western classical", "four stringed instrument", "high pitched", "bow stringed", "country music", "lively", "animated", "percussion", "spirited"] | 7 | UFyOGqmITjM | 2901 |
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;