musiccaps_details (view)
5 rows where musiccaps_aspects contains "passionate singing" and musiccaps_author = 9
This data as json, CSV (advanced)
| 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 | |
| Queen - "We Are the Champions" Acapella (Vocals Only) Concert Mash-Up | This is an isolated vocal track of a rock opera piece. There are no instruments. A passionate male vocalist is singing melodically in the lead. There is a choir in the background providing medium-to-high pitched back vocals. There is an uplifting atmosphere. This piece could be used in remixes. Vocal samples can be lifted for DJ sets or beat-making. | 2015-12-30T08:49:25Z | Playback.fm | About video: http://playback.fm/blog/queen-we-are-the-champions-acapella/ - Follow us on Facebook: https://www.facebook.com/playbackapp We love Queen and Freddie Mercury, so we've edited 4 concert films including a rare recording session of "We Are The Champions" and synced them all up to the isolated vocals in honor of the late, great, Freddie Mercury. This video showcases his presence and consistency as the ultimate stage man. RIP Freddie. You are a rock god. | ["Chant", "Music"] | ["rock opera", "vocal track", "no instruments", "male vocal", "passionate singing", "choir", "dramatic", "uplifting", "vibrant"] | 9 | GF8QWSW0UbY | 1701 | |
| 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 | |
| Ustad Nusrat Fateh Ali Khan & Ustad Tari Khan Live | This is a live performance of a Hindustani classical music piece. There is a male vocalist singing passionately in the lead. The melody is being played by a gentle harmonium tune. The rhythmic background is provided by the tabla percussion. The atmosphere is vibrant. This piece could be used in the soundtrack of a movie with a North Indian setting. | 2011-07-22T20:14:08Z | Yogesh Jagdeo | Amazing Performance By Two Great Musicians Of All Time | ["Tabla", "Percussion"] | ["hindustani classical music", "live performance", "male vocal", "passionate singing", "harmonium", "tabla", "vibrant", "profound"] | 9 | ohikUtjUN7c | 4653 | |
| Keith Wonderboy Johnson "Time to Get Close to Jesus" {Official Video} | This is a Christian gospel music piece. There is a male vocalist singing passionately in the lead with a male choir that is at a relatively higher pitch than him singing in the back. The main melody is played by the keyboard and the electric guitar. There is a bass guitar that can be heard. The acoustic drums are playing an upbeat rhythm. The atmosphere is religious. This piece could be played at Christian religious events. | 2009-01-05T22:09:48Z | Daphanie Cassel | Official Video for the New Single, Time to Get Close to Jesus, from Keith Wonderboy Johnson & The Spiritual Voices. | ["Singing", "Music", "Ska"] | ["gospel", "christian", "male vocal", "passionate singing", "male choir", "keyboard", "electric guitar", "bass guitar", "acoustic drums", "religious", "spiritual", "devotional"] | 9 | xmSMAmnoRug | 5352 |
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;