musiccaps_details (view)
4 rows where search matches "guitar", musiccaps_aspects contains "instrumental music", musiccaps_aspects contains "live performance" and musiccaps_aspects contains "passionate"
This data as json, CSV (advanced)
musiccaps_aspects (array) 74 ✖
- instrumental music · 4 ✖
- live performance · 4 ✖
- passionate · 4 ✖
- emotional 3
- cheerful 2
- country music 2
- groovy music 2
- medium tempo 2
- poor audio quality 2
- the wild west 2
- traditional music 2
- acoustic guitar strumming 1
- ambient room noises 1
- average audio quality 1
- bad audio quality 1
- banjo 1
- bass guitar 1
- cello 1
- child performers 1
- composer 1
- country bluegrass 1
- country dance music 1
- country folk music 1
- cowboys 1
- dance music 1
- dance rhythm 1
- echoes 1
- electric guitar 1
- enthusiastic 1
- epic stories 1
- exciting 1
- fiddlers 1
- groovy 1
- groovy rhythm 1
- guitar band 1
- guitar pick percussions 1
- guitar solo 1
- guitar strumming 1
- guitars strumming 1
- gunslingers 1
- harp player 1
- heroes and villains 1
- jam session 1
- latin dance music 1
- latin percussions 1
- legends 1
- live audience 1
- never give up 1
- party music 1
- percussive bass line 1
- positive 1
- rhythm guitars 1
- romantic 1
- scratching tones 1
- shakers percussions 1
- slick percussive rhythm 1
- song covers 1
- spirited 1
- steady rhythm 1
- story tellers 1
- string harmony 1
- string quartet 1
- string trio 1
- strings scratched with plectrum percussions 1
- studio live sessions 1
- studio performance 1
- suspense 1
- tense 1
- the country life 1
- viola 1
- violin 1
- violinists 1
- wedding music 1
- western classical music 1
musiccaps_names (array) 12 ✖
- Music 3
- Bowed string instrument 2
- Musical instrument 2
- Plucked string instrument 2
- Banjo 1
- Cello 1
- Country 1
- Double bass 1
- Guitar 1
- Salsa music 1
- Strum 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 |
---|---|---|---|---|---|---|---|---|---|---|
The Good, the Bad and the Ugly / Reel Matawa by California Guitar Trio & Montreal Guitar Trio | The song is an instrumental. The song is medium tempo with a guitar playing lead and several guitarists playing harmony and accompaniment and a pick scratching guitar strings producing a percussive line. The song is immersive and has a classic country gun fight duel vibe to it. The song has ambient room noises. | 2009-11-19T18:55:29Z | MG3 : Montréal Guitare Trio / Montreal Guitar Trio | Montreal Guitar Trio & California Guitar Trio performed The Good, the Bad and the Ugly by Ennio Morricone followed by the Reel Matawa by Richard Forest at Palais Montcalm in Quebec City, October 23, 2009. | ["Guitar", "Music", "Musical instrument", "Strum", "Plucked string instrument"] | ["guitar band", "guitar solo", "scratching tones", "guitar pick percussions", "song covers", "strings scratched with plectrum percussions", "live performance", "live audience", "ambient room noises", "echoes", "average audio quality", "groovy music", "instrumental music", "country music", "tense", "suspense", "gunslingers", "groovy", "story tellers", "the wild west", "emotional", "passionate", "heroes and villains", "legends", "epic stories", "electric guitar", "rhythm guitars", "cowboys"] | 1 | 3w3fD54bNvU | 521 | |
sleepy man banjo boys vs mountain rhythm | The song is instrumental. The tempo is medium with a prolific fiddler playing melody and a banjo and guitar accompaniment. The song is adventurous and exciting. The song is a classic country instrumental. The song has poor audio quality. | 2011-05-15T21:20:57Z | RubenProducciones | blatle of banjos. read the description: friends can go to this link and give it a like, would help me a lot to back up videos like this :) http://www.youtube.com/watch?v=g1I7seXs6O4 | ["Banjo", "Country", "Music", "Musical instrument", "Plucked string instrument", "Bowed string instrument"] | ["violinists", "country music", "fiddlers", "child performers", "instrumental music", "guitar strumming", "country folk music", "live performance", "groovy rhythm", "country dance music", "the country life", "the wild west", "dance rhythm", "passionate", "emotional", "spirited", "never give up", "cheerful", "positive", "traditional music", "bad audio quality", "country bluegrass", "banjo", "medium tempo"] | 1 | O84YjlJ_Qw4 | 2402 | |
Canon 70D & Instrumental de Arpa (Instrumental Harp) | The song is an instrumental. The song is medium tempo with Latin percussions, guitar strumming rhythm, groovy bass line and keyboard percussions. The song is exciting and groovy. The song has poor audio quality. | 2014-02-25T04:22:49Z | Jimmy Pastrana | Arpa: Natanael Rios Cuatro: Ferney Cotinchara Bajo: Jimmy Pastrana Maracas: Elias Pertuz | ["Music", "Salsa music"] | ["latin dance music", "guitars strumming", "traditional music", "jam session", "emotional", "passionate", "romantic", "harp player", "poor audio quality", "percussive bass line", "steady rhythm", "bass guitar", "slick percussive rhythm", "studio live sessions", "instrumental music", "latin percussions", "shakers percussions", "groovy music", "live performance"] | 1 | aT7LGemDB40 | 3541 | |
J.Mouret - Rondeau String Quartet | The song is an instrumental. The song is medium tempo with a violin, viola, cello playing a string harmony accompanied by an acoustic guitar strumming chords. The song is a western classical music piece. | 2012-06-04T17:03:48Z | cellony | ["Cello", "Double bass", "Violin, fiddle", "Bowed string instrument"] | ["violin", "viola", "cello", "acoustic guitar strumming", "poor audio quality", "wedding music", "party music", "string quartet", "string trio", "string harmony", "instrumental music", "western classical music", "live performance", "studio performance", "medium tempo", "exciting", "cheerful", "dance music", "composer", "enthusiastic", "passionate", "exciting"] | 1 | fxznho_kNPY | 3995 |
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;