musiccaps_details (view)
2 rows where musiccaps_aspects contains "medium tempo", musiccaps_names contains "Flamenco" and musiccaps_names contains "Singing"
This data as json, CSV (advanced)
musiccaps_aspects (array) >30 ✖
- medium tempo · 2 ✖
- acapella 1
- acoustic guitar strumming 1
- ambient sounds 1
- cheerful 1
- dance rhythm 1
- emotional 1
- emphatic vocals 1
- feel good 1
- female backup singers 1
- female singer 1
- folk song 1
- haunting melody 1
- heartfelt 1
- lilting 1
- live audience 1
- live performance 1
- lively spanish guitar 1
- male backup singers 1
- male vocalist 1
- minimalist 1
- passionate 1
- people talking 1
- poor audio quality 1
- popular folk music 1
- powerful vocals 1
- regional music 1
- retro pop song 1
- retro super hits 1
- romantic 1
- …
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
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 | |
Joan Armatrading - Love And Affection 1976 | A female singer sings this beautiful melody with male and female backup singers in vocal harmony. The song is medium tempo with an acoustic guitar playing rhythm and strong string bass line with no percussion instrumentation. The song is emotional and heartfelt. The song has acapella influences and is soulful. The song is of poor audio recording quality. | 2010-03-19T15:03:53Z | fritz51329 | Joan Armatrading - Love And Affection 1976 I am not in love But I'm open to persuasion East or West Where's the best For romancing With a friend I can smile But with a lover I could hold my head back I could really laugh Really laugh Thank you You took me dancing 'Cross the floor Cheek to cheek But with a lover I could really move Really move I could really dance Really dance Really dance Really dance I could really move Really move Really move Really move Now if I can feel the sun In my eyes And the rain on my face Why can't I Feel love I can really love Really love Really love Really love Really love Love love love love Love love love love Now I got all The friends that I want I may need more But I shall just stick to those That I have got With friends I still feel So insecure Little darling I believe you could Help me a lot Just take my hand And lead me where you will No conversation No wave goodnight Just make love With affection Sing me another love song But this time With a little dedication Sing it, sing it You know that's what I like Once more with feeling Give me love Give me love Give me love Love (Instrumental) Make love with affection Sing me another love song But this time With a little dedication Sing it, sing it You know that's what I like With affection Sing me another love song But this time With a little dedication Sing it, sing it You know that's what I like With affection With a little dedication Once more with feeling You know that's what I like | ["Singing", "Flamenco", "Music"] | ["female singer", "soulful singer", "poor audio quality", "male backup singers", "string bass line", "acoustic guitar strumming", "vocal harmony", "female backup singers", "retro pop song", "cheerful", "emotional", "retro super hits", "dance rhythm", "medium tempo", "string bass", "acapella", "passionate", "romantic", "heartfelt", "feel good", "vocal crooning"] | 1 | oag3I4VRXyM | 4645 |
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;