musiccaps_details (view)
3 rows where musiccaps_aspects contains "acoustic guitar strumming" and musiccaps_names contains "Singing" sorted by musiccaps_author
This data as json, CSV (advanced)
musiccaps_aspects (array) 39 ✖
- acoustic guitar strumming · 3 ✖
- acapella 1
- brass instrument 1
- cello counter melody 1
- cheerful 1
- cheerful male pop vocal 1
- dance rhythm 1
- duet 1
- electric bass guitar 1
- emotional 1
- energetic female pop vocal 1
- feel good 1
- female backup singers 1
- female singer 1
- happy-go-lucky 1
- heartfelt 1
- jazzy pop 1
- male backup singers 1
- male singer 1
- medium tempo 1
- melancholy 1
- musical vibes 1
- passionate 1
- piano accompaniment 1
- poor audio quality 1
- pop 1
- retro pop song 1
- retro super hits 1
- romantic 1
- simple bass 1
- slow rock drum beat 1
- soft rock 1
- soulful singer 1
- string bass 1
- string bass line 1
- sweet 1
- upbeat pop 1
- vocal crooning 1
- vocal harmony 1
musiccaps_names (array) 6 ✖
- Music 3
- Singing · 3 ✖
- Flamenco 1
- Happy music 1
- Pop music 1
- Tender music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author ▼ | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
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 | |
Daniella Monet - Lookin' Like Magic feat. Drake Bell ( Official Music Video ) | The song has a generally cheerful, happy-go-lucky vibe to it. It's got a male vocalist who has a zesty and vibrant voice, as well as a female vocalist that brings power to the song as well. There's a brass motif that follows one of the phrases by the male vocalist, and the drumming is generally upbeat and jazzy. | 2011-10-21T11:30:45Z | xDaniellaMonet | Music video by Daniella Monet & Drake Bell performing Lookin' Like Magic. (C) 2011 Viacom a unit of Nickelodeon. | ["Singing", "Music", "Pop music", "Happy music"] | ["musical vibes", "duet", "pop", "upbeat pop", "jazzy pop", "cheerful male pop vocal", "energetic female pop vocal", "acoustic guitar strumming", "brass instrument", "happy-go-lucky"] | 3 | oSg1VJHiPOE | 4631 | |
Alan Parsons Project - Time | A sweet, melancholy sounding soft rock song with a male singer accompanied by acoustic guitar strumming, a cello counter melody, piano, simple electric bass, and a slow rock drum beat. | 2009-09-09T07:18:53Z | BachChannel | No description. | ["Singing", "Music", "Tender music"] | ["soft rock", "cello counter melody", "male singer", "melancholy", "acoustic guitar strumming", "piano accompaniment", "sweet", "slow rock drum beat", "simple bass", "electric bass guitar"] | 8 | too9MtXBwts | 5068 |
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;