musiccaps_details (view)
3 rows where musiccaps_aspects contains "energetic", musiccaps_aspects contains "upbeat" and musiccaps_author = 3
This data as json, CSV (advanced)
musiccaps_aspects (array) 25 ✖
- energetic · 3 ✖
- upbeat · 3 ✖
- acoustic guitar 1
- background laughter sounds 1
- build-up 1
- celebration 1
- dance 1
- east asian music 1
- fiesta 1
- flamenco guitarists 1
- fun 1
- intricate piano playing 1
- latin american music 1
- live performance 1
- maracas 1
- mariachi music 1
- mexican traditional music 1
- mexican vihuela 1
- nylon string guitar 1
- percussion 1
- percussion rhythm 1
- piano 1
- reverb 1
- stringed instrument 1
- timpani 1
musiccaps_names (array) 10 ✖
- Music 3
- Guitar 2
- Musical instrument 2
- Plucked string instrument 2
- Flamenco 1
- Folk music 1
- Percussion 1
- Rattle (instrument) 1
- Timpani 1
- Ukulele 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Faraon - Flamenco Rumba_20/11/2011@Barceloan | This is a recording of two flamenco guitarists playing a captivating latin american rhythm. It's upbeat and suitable for dancing. The one guitarist strums chords in the percussive flamenco style, while the other guitarist plays flamenco lead with arpeggios and licks. The performance is live and outside. There is reverb applied to the lead guitar. Both are playing on nylon strings. | 2011-11-24T17:50:51Z | Julian Kan | Spanish Guitar - Adrian Roman & Martin Sazandeh's performance at Cathedral, Gothic Quarter, Barcelona | ["Folk music", "Flamenco", "Guitar", "Music", "Musical instrument", "Plucked string instrument"] | ["live performance", "flamenco guitarists", "acoustic guitar", "nylon string guitar", "latin american music", "upbeat", "energetic", "dance", "reverb"] | 3 | KChjW89XOF0 | 2064 | |
jesus maria-requinto-pedacito de santander-torbellino.avi | This song has a traditional Mexican mariachi sound. It is fun, vibrant and energetic and is led by rhythmic and melodic playing on the Mexican Vihuela. The maracas add an element of rhythmic percussion. There are sounds of laughter in the background. | 2012-03-14T16:18:29Z | Ramon Donato Ardila Ariza | conjunto de eberto téllez-tiple, esposa-maracas, joselín luengas-requinto, interpretando el torbellino: pedacito de Satander, en una tienda en jesús maría-Santander-Colombia. Video tomado por Didimo Romero Ardila. | ["Guitar", "Music", "Musical instrument", "Rattle (instrument)", "Ukulele", "Plucked string instrument"] | ["maracas", "background laughter sounds", "mexican vihuela", "mexican traditional music", "percussion", "stringed instrument", "mariachi music", "fiesta", "celebration", "upbeat", "energetic", "fun"] | 3 | LjxhswBV1UA | 2217 | |
光の隙間 打楽器五重奏 Full | Some big and bold percussion instruments, namely timpanis, are used in this piece and create a bold and magnetic atmosphere. There is an intricate piano melody that comes in after the rhythmic percussive intro. The song fits into the east asian part of the world. | 2012-09-15T13:57:41Z | 味うに | 吹奏楽部打楽器(パーカッション)専用 光の隙間 Full 打楽器五重奏! アンサンブルコンテストに参加する方は、頑張ってください! ビブラ、グロッケン、マリンバ、ティンパニ、ドラム | ["Timpani", "Music", "Percussion"] | ["timpani", "percussion rhythm", "upbeat", "energetic", "build-up", "piano", "intricate piano playing", "east asian music"] | 3 | uknhELOFYmY | 5134 |
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;