musiccaps_details (view)
3 rows where search matches "guitar", musiccaps_aspects contains "live performance", musiccaps_names contains "Flamenco" and musiccaps_names contains "Music of Latin America"
This data as json, CSV (advanced)
musiccaps_aspects (array) 29 ✖
- live performance · 3 ✖
- acoustic guitar 2
- emotional 2
- flamenco 2
- passionate singing 2
- spanish 2
- vibrant 2
- agitated 1
- ambient sounds 1
- cajon 1
- claps 1
- crowd cheering 1
- emphatic vocals 1
- female vocal 1
- folk song 1
- haunting melody 1
- lilting 1
- live audience 1
- lively spanish guitar 1
- male vocal 1
- male vocalist 1
- medium tempo 1
- minimalist 1
- people talking 1
- popular folk music 1
- powerful vocals 1
- regional music 1
- spanish song 1
- vocals 1
musiccaps_names (array) 7 ✖
youtube_published (date) 3 ✖
- 2010-08-06 1
- 2011-11-18 1
- 2015-04-27 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
MARIA TOLEDO- La loca (en directo desde el Teatro Lope de Vega de Sevilla) | This is a flamenco music piece being performed live. There is a female vocalist singing passionately in the Spanish language. The acoustic guitar is playing the melodic background while the rhythmic background is played by the cajon percussion and a group of musicians clapping in a syncopated manner. The atmosphere is vibrant and agitated. This piece could be used in the soundtrack of a soap opera or a romance/drama movie. It could also be playing in the background at a Spanish/Latin American cuisine restaurant. | 2011-11-18T17:11:15Z | MARÍA TOLEDO | Maria Toledo cantó en el teatro Lope de Vega de Sevilla el día 14-10-2011 junto a Jesús de Rosario a la guitarra, Lucky Losada al cajón y Amparo Lagares, Luis Carrasco Juan Diego y Juan Grande al compás. Vestida por Vicky Martín Berrocal Grabación video: Miguel Ángel Cárdaba. | ["Singing", "Flamenco", "Music", "Music of Latin America"] | ["flamenco", "live performance", "female vocal", "passionate singing", "acoustic guitar", "cajon", "claps", "vibrant", "emotional", "agitated", "spanish"] | 9 | C8VECv8kicU | 1336 | |
Antonio José canta por fandangos (Directo Málaga) | This is the live performance of a flamenco music piece. There is a male vocalist singing passionately in the Spanish language. An acoustic guitar strums a characteristic flamenco tune. Sounds of the crowd cheering can be heard in the background. The atmosphere is vibrant. | 2015-04-27T20:37:09Z | Carmen SV | Concierto sala Tenessee (Málaga) 26/04/2015 | ["Singing", "Flamenco", "Guitar", "Music", "Speech", "Music of Latin America"] | ["flamenco", "live performance", "spanish", "male vocal", "passionate singing", "acoustic guitar", "crowd cheering", "emotional", "vibrant"] | 9 | GUwBLItoJXk | 1727 | |
Juan Fernando canta fandangos de Huelva en Amsterdam | A male vocalist sings this powerful solo in a foreign language. The tempo is medium with a spanish guitar accompaniment. The song has minimalist music with captivating, lilting and almost haunting vocals. This is a live performance with ambient sounds of people talking. The audio quality is inferior as it is an amateur recording. This song is a Latin/Spanish Folk song. | 2010-08-06T14:25:01Z | coroflamenco | Juan Fernando en un concierta del cuadro de cante de la Peña Flamenca de Huelva y del coro flamenco Calle Real en Amsterdam. Toque Antonio Dovao, Ramón Jesús Díaz. Baile: Teresa Jaldón, Director de cine: Stijn van der Loo, studio BBH | ["Singing", "Yodeling", "Flamenco", "Music", "Music of Latin America"] | ["male vocalist", "medium tempo", "spanish song", "minimalist", "folk song", "regional music", "popular folk music", "lively spanish guitar", "emphatic vocals", "powerful vocals", "live performance", "live audience", "ambient sounds", "people talking", "lilting", "haunting melody", "vocals"] | 7 | _zQTlTCqMzs | 3508 |
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;