musiccaps_details (view)
1 row where musiccaps_aspects contains "beautiful", musiccaps_aspects contains "modern pop hits", musiccaps_aspects contains "steady drumming rhythm" and musiccaps_aspects contains "violin playing countermelody"
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 |
---|---|---|---|---|---|---|---|---|---|---|
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;