musiccaps_details (view)
5 rows where musiccaps_aspects contains "emotional", musiccaps_aspects contains "groovy music" and musiccaps_aspects contains "live performance"
This data as json, CSV (advanced)
musiccaps_aspects (array) 88 ✖
- emotional · 5 ✖
- groovy music · 5 ✖
- live performance · 5 ✖
- instrumental music 4
- passionate 4
- live audience 3
- poor audio quality 3
- average audio quality 2
- romantic 2
- spirited 2
- acoustic guitar lead 1
- ambient room noises 1
- bad audio quality 1
- bass guitar 1
- blues dance music 1
- blues guitar 1
- blues legends 1
- cellist 1
- cello concerto 1
- concert hall 1
- conductor 1
- country blues band 1
- country blues hits 1
- country blues music 1
- country music 1
- cowboys 1
- dvorak 1
- echoes 1
- electric guitar 1
- enthusiastic 1
- epic stories 1
- exciting 1
- fast guitar strumming 1
- fast tempo 1
- flamenco guitar 1
- folk music 1
- folk singer 1
- great composers 1
- great technique 1
- groovy 1
- groovy tempo 1
- guitar accompaniment 1
- guitar band 1
- guitar pick percussions 1
- guitar solo 1
- guitars strumming 1
- gunslingers 1
- harp player 1
- heroes and villains 1
- jam session 1
- latin dance music 1
- latin percussions 1
- latin singer 1
- legends 1
- live in concert 1
- male singer 1
- medium tempo 1
- opera hall 1
- passionate music 1
- passionate singing 1
- percussive bass line 1
- philharmonic orchestra 1
- retro blues 1
- retro blues hits 1
- rhythm guitars 1
- scratching tones 1
- shakers percussions 1
- slick percussive rhythm 1
- song covers 1
- spirited singing 1
- steady rhythm 1
- steady rock drumming 1
- story tellers 1
- street musician 1
- string section 1
- strings scratched with plectrum percussions 1
- strong walking bass 1
- studio live sessions 1
- suspense 1
- tense 1
- the wild west 1
- timpani bangs loud 1
- traditional latin music 1
- traditional music 1
- violins playing harmony 1
- virtuously 1
- western classical music 1
- wind sections 1
musiccaps_names (array) 17 ✖
- Music 5
- Guitar 2
- Musical instrument 2
- Blues 1
- Bowed string instrument 1
- Cello 1
- Classical music 1
- Flamenco 1
- Orchestra 1
- Plucked string instrument 1
- Salsa music 1
- Singing 1
- Song 1
- Steel guitar, slide guitar 1
- Strum 1
- Violin, fiddle 1
- Vocal music 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 | |
Flamenco en la calle. Cáceres | A male singer sings this spirited Latin vocal. The song is fast tempo with slick guitar strumming and percussive guitar accompaniment. The song is romantic and steeped in rich Latin classical music traditions. The song is about a Latin street musician playing folk music. The recording is of average quality. | 2016-01-22T12:08:16Z | Antonio Lara Arco | En pleno casco antiguo de la ciudad... | ["Singing", "Flamenco", "Music", "Song", "Vocal music"] | ["male singer", "latin singer", "average audio quality", "fast tempo", "groovy tempo", "fast guitar strumming", "guitar accompaniment", "groovy music", "romantic", "emotional", "passionate", "spirited", "passionate singing", "spirited singing", "flamenco guitar", "live performance", "street musician", "passionate music", "traditional latin music", "folk singer", "folk music"] | 1 | Bx726MYz6Uo | 1306 | |
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 | |
Roy Rogers (slide guitar) - Look Over Yonders Wall | The song is an instrumental. The song is medium tempo, with an acoustic guitar playing blues, strong drumming rhythm, walking bass line and keyboard harmony. The song is exciting and has a dance rhythm. The audio quality is poor. | 2007-11-22T23:21:53Z | Vladimir BluesJammer | Roy Rogers (slide guitar) - performance from his video "Slide Guitar For Rock & Blues" http://www.homespuntapes.com | ["Blues", "Guitar", "Music", "Steel guitar, slide guitar"] | ["acoustic guitar lead", "country blues music", "poor audio quality", "instrumental music", "blues legends", "blues legends", "live performance", "live audience", "live in concert", "country blues band", "retro blues hits", "bad audio quality", "strong walking bass", "blues guitar", "steady rock drumming", "exciting", "enthusiastic", "retro blues", "country blues hits", "emotional", "enthusiastic", "groovy music", "blues dance music"] | 1 | hzznbzry5R8 | 4156 | |
Dvořák: Cello Concerto / Isserlis · Gilbert · Berliner Philharmoniker | The song is an instrumental. The tempo is medium with a cellist playing a virtuoso solo accompanied by a string section harmony, flutes in harmony and a loud banging timpani. The song is spirited and passionate with poor audio quality. The song is a western classical piece. | 2009-06-19T08:28:26Z | Berliner Philharmoniker | Full-length concert: http://www.digitalconcerthall.com/concert/27/?a=youtube&c=true Antonín Dvořák: Cello Concerto / Steven Isserlis, cello · Alan Gilbert, conductor · Berliner Philharmoniker / Recorded at the Berlin Philharmonie, 19 April 2009. The Berliner Philharmoniker's Digital Concert Hall: http://www.digitalconcerthall.com Subscribe to our newsletter: http://www.digitalconcerthall.com/newsletter Website of the Berliner Philharmoniker: http://www.berliner-philharmoniker.de | ["Cello", "Music", "Musical instrument", "Orchestra", "Violin, fiddle", "Classical music", "Bowed string instrument"] | ["cellist", "string section", "philharmonic orchestra", "cello concerto", "dvorak", "virtuously", "timpani bangs loud", "medium tempo", "wind sections", "violins playing harmony", "groovy music", "western classical music", "great composers", "conductor", "opera hall", "live audience", "live performance", "instrumental music", "passionate", "spirited", "emotional", "great technique", "poor audio quality", "concert hall"] | 1 | yrme-KRBvzk | 5445 |
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;