musiccaps_details (view)
2 rows where musiccaps_aspects contains "guitar accompaniment" and musiccaps_aspects contains "modern pop hits"
This data as json, CSV (advanced)
musiccaps_aspects (array) 30 ✖
- emotional 2
- guitar accompaniment · 2 ✖
- modern pop hits · 2 ✖
- romantic 2
- beautiful 1
- crowds cheering 1
- fast tempo 1
- feel good 1
- girls screaming 1
- guitar strumming rhythm 1
- hissing noises 1
- live shows 1
- love songs 1
- madly in love 1
- male singer 1
- modern love 1
- modern romantic hits 1
- packed stadium 1
- passionate 1
- piano accompaniment 1
- poor audio quality 1
- pop hits 1
- pop love song 1
- pop star sings live 1
- sentimental 1
- steady drumming rhythm 1
- strong bass line 1
- teen heartthrob 1
- teenage romance 1
- violin playing countermelody 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 | |
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 |
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;