musiccaps_details (view)
5 rows where search matches "guitar", musiccaps_aspects contains "live performance" and musiccaps_names contains "Acoustic guitar" sorted by musiccaps_caption
This data as json, CSV (advanced)
musiccaps_aspects (array) >30 ✖
- live performance · 5 ✖
- low quality 4
- noisy 4
- emotional 3
- passionate 2
- accordion melody 1
- acoustic flamenco guitar melody 1
- acoustic rhythm guitar 1
- aggressive spanish guitar chord progression 1
- boomy 1
- buzzy 1
- cheerful 1
- clarinet 1
- concert 1
- crowd chattering 1
- fast tempo 1
- fruity male vocal 1
- happy 1
- hopeful 1
- instrumental 1
- lacking high frequencies 1
- latin instrumental music 1
- latin pop 1
- light 1
- lively tambourine beats 1
- mono 1
- passionate female vocal 1
- percussive arpeggiated acoustic guitar melody 1
- perky 1
- playful 1
- …
musiccaps_names (array) 13 ✖
- Acoustic guitar · 5 ✖
- Music 5
- Guitar 3
- Folk music 2
- Musical instrument 2
- Plucked string instrument 2
- Flamenco 1
- Middle Eastern music 1
- Music of Latin America 1
- Singing 1
- Steel guitar, slide guitar 1
- Tapping (guitar technique) 1
- Ukulele 1
youtube_published (date) 5 ✖
- 2007-04-22 1
- 2009-02-25 1
- 2010-10-07 1
- 2013-02-04 1
- 2013-12-20 1
video | youtube_link | musiccaps_caption ▼ | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
macanita (1er parte) en jerez 2007 | The low quality recording features a live performance of an aggressively strummed Spanish guitar and passionate female vocal singing on top of it. It is very noisy, but it sounds passionate and emotional. | 2007-04-22T17:43:07Z | Emilio Ancel | macanita (1er parte) en jerez 2007 | ["Singing", "Folk music", "Acoustic guitar", "Music", "Steel guitar, slide guitar"] | ["low quality", "aggressive spanish guitar chord progression", "noisy", "live performance", "passionate female vocal", "passionate", "emotional"] | 4 | DVuWm53IlVw | 1485 | |
Christie Lenee Two Handed Guitar Tapping - "Daylight Comes" - Female Guitarist Singer/Songwriter | The low quality recording features a live performance of the percussive & arpeggiated acoustic guitar melody. There are some crowd chattering noises in the background, by which we can definitely conclude that it is, in fact, a live performance. Sounds a bit boomy and the high frequencies of the guitar are lacking volume. | 2013-02-04T23:56:41Z | Christie Lenée | Solo Acoustic Performance at Infinity Hall Norfolk, CT on Nov 18th 2012- Original Song "Daylight Comes" by Christie Lenee, © 2012 All Rights Reserved, Protected by BMI, Christie Lenée and Muzik4Mind Global Publishing. Hear Studio version on website now! http://www.christielenee.com/ *Filmed by Chris LeFevre | ["Tapping (guitar technique)", "Guitar", "Acoustic guitar", "Music", "Musical instrument"] | ["low quality", "percussive arpeggiated acoustic guitar melody", "noisy", "crowd chattering", "live performance", "lacking high frequencies", "boomy"] | 4 | PNT3hW4qFpQ | 2530 | |
Guajira - flamenco | The low quality recording features a live performance that consists of an acoustic flamenco guitar melody. The recording is very noisy and buzzy, but you can still hear the passion and the emotion. | 2009-02-25T06:27:26Z | khusroks | Performed and choreographed by Behnaz Khusrokhan. | ["Flamenco", "Guitar", "Acoustic guitar", "Music", "Ukulele", "Plucked string instrument"] | ["low quality", "buzzy", "noisy", "acoustic flamenco guitar melody", "passionate", "emotional", "live performance"] | 4 | hgitRq_0410 | 4126 | |
Arany Zoltán & World Music Syndicate - La molinera | The low quality recording features a live performance that consists of fruity male vocal singing over accordion melody, acoustic rhythm guitar chords and shimmering bells. It sounds emotional and hopeful. The recording is a bit noisy and in mono, as it was probably recorded with a phone. | 2013-12-20T09:55:03Z | Arany Zoltán | https://www.facebook.com/Arany-Zolt%C3%A1n-Music-274856225999515/ http://aranyzoltan.hu/ Arany Zoltán - fiddle Gonda Szabolcs - guitar Gonda "Sikh" Zoltán - bass Huszti László - percussion Mangu Róbert - percussion Made by Kilincsfilm | ["Folk music", "Acoustic guitar", "Music", "Middle Eastern music"] | ["low quality", "live performance", "fruity male vocal", "accordion melody", "acoustic rhythm guitar", "shimmering bells", "emotional", "hopeful", "mono", "noisy"] | 4 | -nlkWWphiaM | 85 | |
Roda de Choro | Chorinho pra Você (Severino Araujo) | Instrumental SESC Brasil | This music is a lively instrumental. The tempo is fast with an animated clarinet lead, lively spanish guitar rhythm, ukulele accompaniment and bright tambourine /pandeireta beats. The music is upbeat, buoyant, peppy, cheerful, happy, playful and fun Latin Clarinet Instrumental. | 2010-10-07T06:57:12Z | Instrumental Sesc Brasil | A Roda de Choro nasceu na Virada Cultural de 2007, no Auditório Ibirapuera, sob organização de Danilo Brito. Desde sua criação, já aconteceu em diversos teatros e recebeu convidados como Carlos Malta, Laércio de Freitas, Toninho Ferragutti, Ricardo Herz, Danilo Brito, Alessandro Penezzi, Nelson Ayres, Oswaldinho do Acordeon e Gabriel Grossi, entre outros. No repertório, choros clássicos, passando por Pixinguinha, Jacob do Bandolim e algumas composições próprias. Formação: Alexandre Ribeiro - clarinete Léo Rodrigues - pandeiro Milton Mori - cavaquinho Luizinho 7 Cordas - violão 7 cordas Nelson Ayres - piano Toninho Ferragutii - acordeon Gênero: Choro Show que ocorreu no Teatro do Sesc Paulista dia 13/09/2010 • site oficial: https://www.instrumentalsescbrasil.org.br/ • assista aos shows ao vivo pelo https://www.youtube.com/instrumentalsescbrasil Inscreva-se no canal http://www.youtube.com/sescsp e fique por dentro de toda a programação que acontece nas unidades do Sesc no estado de São Paulo. Basta ter uma conta gratuita no Google. | ["Guitar", "Acoustic guitar", "Music", "Musical instrument", "Plucked string instrument", "Music of Latin America"] | ["instrumental", "fast tempo", "spirited", "clarinet", "ukele", "cheerful", "light", "perky", "happy", "playful", "latin instrumental music", "live performance", "concert", "wind instrument", "spanish guitar", "cheerful", "upbeat", "latin pop", "lively tambourine beats", "rhythmic acoustic guitar"] | 7 | c5NGOcNyF4g | 3678 |
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;