musiccaps_details (view)
6 rows where musiccaps_aspects contains "modern pop hits" and musiccaps_aspects contains "romantic" sorted by youtube_link
This data as json, CSV (advanced)
musiccaps_aspects (array) 77 ✖
- emotional 6
- modern pop hits · 6 ✖
- romantic · 6 ✖
- male singer 5
- love song 3
- medium tempo 3
- poor audio quality 3
- steady drumming rhythm 3
- bad audio quality 2
- guitar accompaniment 2
- heartfelt 2
- inspiring 2
- madly in love 2
- memdium tempo 2
- piano accompaniment 2
- strong bass line 2
- vocal harmony 2
- amateur singer 1
- backup singers 1
- band audio quality 1
- beautiful 1
- clapping percussions 1
- crowds cheering 1
- cymbals crashing 1
- fast tempo 1
- feel good 1
- forgive me 1
- friendship 1
- girls screaming 1
- guitar lead 1
- guitar playing lead 1
- guitar rhythm 1
- guitar strumming rhythm 1
- hissing noises 1
- hissing sounds 1
- home music video 1
- humming vocals 1
- i’m sorry 1
- keyboard accompaniment 1
- keyboard harmony 1
- live shows 1
- love songs 1
- lyrical singing 1
- modern love 1
- modern r&b hits 1
- modern romantic hits 1
- motivational 1
- never give up on you 1
- organ accompaniment 1
- packed stadium 1
- passionate 1
- percussive bass line 1
- pop hits 1
- pop love song 1
- pop song 1
- pop song cover 1
- pop star sings live 1
- r&b 1
- sentimental 1
- slick percussion clicks 1
- song cover 1
- soul singer 1
- story telling 1
- string section playing rhythmically 1
- strong drumming rhythm 1
- tambourine accompaniment 1
- teen heartthrob 1
- teenage romance 1
- thumping bass line 1
- together for ever 1
- touching 1
- ukulele accompaniment 1
- ukulele playing rhythm 1
- violin playing countermelody 1
- young love 1
- youthful 1
- youtube music video 1
musiccaps_names (array) 11 ✖
- Music 5
- Happy music 1
- Humming 1
- Music of Asia 1
- Musical instrument 1
- Plucked string instrument 1
- Pop music 1
- Singing 1
- Tender music 1
- Ukulele 1
- Whoop 1
video | youtube_link ▼ | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Harry Styles | Best Vocals [Part 2] | A male singer sings various songs in live audience situations. The songs have a different tempo and are mostly accompanied by a band. The songs are sung at live venues with people screaming and cheering. The songs are modern pop hits , recorded in poor audio quality with hissing noises. | 2013-08-20T05:03:21Z | fr0zenintimeee | follow me i follow back :) ♡ https://twitter.com/fr0zentweets ♡ Tumblr: http://http://harryfml.tumblr.com/ (1D blog) i don't own any of these videos. I don't own any rights to this song. No copyright intended. | ["Singing", "Music", "Pop music", "Whoop"] | ["poor audio quality", "hissing noises", "pop star sings live", "live shows", "emotional", "passionate", "crowds cheering", "guitar accompaniment", "pop hits", "romantic", "girls screaming", "packed stadium", "pop hits", "teen heartthrob", "modern pop hits", "love songs", "romantic", "madly in love", "modern love", "teenage romance"] | 1 | pNlrM-GhFZU | 4705 | |
John Legend - Who Did That to You (Lyrics) from Django Unchained Soundtrack | A male singer sings this soulful melody with backup singers in vocal harmony. The song is medium tempo with an organ accompaniment, steady drumming , guitar rhythm and various percussion hits. The song is story telling and passionate in nature. The audio quality is very poor. | 2012-12-29T14:50:41Z | django unchained | The lyrics for John Legend's song - Who Did That To You fro the soundtrack of Quentin Tarantino's movie - Django Unchained buy this song at http://www.amazon.com/Who-Did-That-to-You/dp/B00AL3KI76 | ["Music of Asia"] | ["male singer", "bad audio quality", "modern pop hits", "bad audio quality", "medium tempo", "emotional", "inspiring", "motivational", "romantic", "never give up on you", "madly in love", "love song", "story telling", "soul singer", "vocal harmony", "organ accompaniment", "memdium tempo", "guitar rhythm", "steady drumming rhythm", "percussive bass line", "r&b", "modern r&b hits"] | 1 | ozjs2d_xlSI | 4674 | |
One Republic - Apologize (Lyrics) | A male singer sings this beautiful melody with backup singers in vocal harmony. The song is medium tempo with a percussive string section, strong bass line, guitar lead, steady drumming rhythm , keyboard accompaniment and various percussion clicks. The song is emotional and romantic. The song is of poor audio quality. | 2013-12-06T06:01:44Z | Giz Ruar | "Apologize" belongs to One Republic. From the "Dreaming Out Loud" album, 2006. http://onerepublic.com/ Please, suscribe to my channel. TY! My Facebook Official Page: https://www.facebook.com/GizelleSixxJ If you want a special lyric video, just let me know in a comment below the video and I'll try to make it. Thanks for watching. | ["Music", "Happy music"] | ["male singer", "backup singers", "guitar lead", "medium tempo", "steady drumming rhythm", "string section playing rhythmically", "cymbals crashing", "slick percussion clicks", "strong bass line", "keyboard harmony", "modern pop hits", "emotional", "romantic", "together for ever", "i’m sorry", "forgive me", "love song", "poor audio quality", "heartfelt", "vocal harmony", "clapping percussions"] | 1 | -wymN80CiYU | 105 | |
Please Don't Go - Joel Adams - 6 Minute Humming Repeat | A male singer sings this humming vocal. The song is medium tempo with a strong drumming rhythm, groovy bass slime, keyboard accompaniment, piano accompaniment and tambourine accompaniment . The song is emotional and romantic. The song is a modern pop love song with poor audio quality. | 2016-01-24T20:44:40Z | That’s Not Me | I've noticed plenty of you enjoy his humming so I created this repeated version! *Includes a few pictures of Joel* Hope you like it! :-) I found this guy in an ad at the beginning of a video I watched. AMAZING! I'm the sorry that towards the end, a little extra humming loop cut in for about a minute. This is my first video xD I triedddd! I also uploaded a longer 30 minute video! Created by Faith. All Right Reserved to the ORIGINAL by Joel Adams. Check out the full music video here! https://www.youtube.com/watch?v=S2oxFIsENgM Purchase it on iTunes! | ["Humming", "Music"] | ["male singer", "humming vocals", "thumping bass line", "keyboard accompaniment", "guitar playing lead", "lyrical singing", "modern pop hits", "romantic", "emotional", "youthful", "young love", "piano accompaniment", "poor audio quality", "hissing sounds", "tambourine accompaniment", "medium tempo", "strong drumming rhythm"] | 1 | 8CY7G2NrlxY | 902 | |
Skipinnish // Walking On The Waves [Official Music Video] (ORIGINAL) | A male singer sings this beautiful melody. The tempo is fast with a guitar strumming rhythm, strong bass line, violin playing countermelody, steady drumming rhythm and a guitar playing accompaniment. The song is fresh, innocent and romantic with a lot of heart. The song is a modern love song. | 2014-06-05T15:56:17Z | SKIPINNISH | Skipinnish - Walking On The Waves www.skipinnish.com Written and Directed: Bruce Carmichael & Ross B. Wilson Filmed and Edited: Bruce Carmichael Grading: Bjorn Tobiasson Lyrics: An island in the sunlight Laughter in the rain A whisky in the darkness It all feels just the same. Watch the sunset over Hynish See the twilight merge to dawn Hear the waves caress the shoreline As the island carries on. I've been walking, walking these shores all my days But with you by my side I am walking on the waves. There's two lovers on the machair And they walk down to the sand Their silhouettes are on the water As they paddle hand in hand. And it's a game of sweet surrender When there's nothing left to say And there are moments to remember Once these days are long away. I've been walking, walking these shores all my days But with you by my side I am walking on the waves. So you look out on the ocean See the headlands and the strands And you wonder what horizons Will shape tomorrow's plans And through the turning of the seasons And the cycle of the days Every drink's another reason To let tomorrow sail away. I've been walking, walking these shores all my days But with you by my side I am walking on the waves. The surging of the ocean, The breakers on the shore, The echoes of our bodies, To the lovers' dream we soar. I've been walking, walking these shores all my days But with you by my side I am walking on the waves. Written by A. Macphail and R. Robertson | ["Music", "Tender music"] | ["male singer", "strong bass line", "guitar strumming rhythm", "violin playing countermelody", "piano accompaniment", "steady drumming rhythm", "guitar accompaniment", "beautiful", "sentimental", "romantic", "modern pop hits", "pop love song", "modern romantic hits", "feel good", "emotional", "romantic", "fast tempo"] | 1 | xNn2UdI-kvA | 5327 | |
Ukulele Tutorial #54 (Count On Me, Bruno Mars) | A male singer sings this popular song. The tempo is medium with an ukulele playing rhythm accompanying the male vocals with no other instrumentation. The song is emotional and inspiring. The audio quality is bad. | 2010-07-06T19:06:01Z | Krankthat22 | NEW WEBSITE is up and running! Check it out and let me know what you think!! Feedback is much appreciated! Thank me later. Click here now! http://tinyurl.com/Krankthat22 Em - 0432 C - 0003 Am - 2000 F - 2010 Dm - 2210 G - 0121 verse/chorus C Em Am G F bridge #1 Dm Em F G Bridge #2 ("a shoulder to cry on" part of lyrics) Dm G C G | ["Music", "Musical instrument", "Ukulele", "Plucked string instrument"] | ["male singer", "ukulele accompaniment", "bad audio quality", "inspiring", "amateur singer", "ukulele playing rhythm", "memdium tempo", "song cover", "emotional", "love song", "romantic", "touching", "youtube music video", "friendship", "touching", "heartfelt", "pop song", "pop song cover", "modern pop hits", "band audio quality", "home music video"] | 1 | MpjN21Z93JY | 2302 |
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;