musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "male singer", musiccaps_aspects contains "piano accompaniment" and musiccaps_aspects contains "steady drumming rhythm"
This data as json, CSV (advanced)
musiccaps_aspects (array) 30 ✖
- emotional 2
- guitar accompaniment 2
- male singer · 2 ✖
- piano accompaniment · 2 ✖
- steady drumming rhythm · 2 ✖
- bad audio quality 1
- beautiful 1
- classic rock 1
- fast tempo 1
- feel good 1
- groovy rhythm 1
- guitar strumming rhythm 1
- keybiard accompaniment 1
- love songs 1
- medium tempo 1
- modern pop hits 1
- modern pop songs 1
- modern romantic hits 1
- new age 1
- passionate 1
- pop love song 1
- pop song 1
- realisation 1
- romantic 1
- romantic song 1
- sadness 1
- sentimental 1
- string bass line 1
- strong bass line 1
- violin playing countermelody 1
musiccaps_names (array) 3 ✖
- Music 2
- Christian 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 |
---|---|---|---|---|---|---|---|---|---|---|
Matthew Perryman Jones - Save you lyrics | A male singer sings this poignant love song. The song is medium tempo with a steady drumming rhythm, strong bass line, keyboard accompaniment, guitar accompaniment and percussion hits. The song is emotional and romantic. The song audio quality is bad. | 2010-08-30T19:02:00Z | dionyts91 | Matthew Perryman Jones' official website: http://mpjmusic.com this is one of the KYLE XY 's, ONE TREE HILL 's , PRETTY LITTLE LIARS' soundtracks !! i love it!! I M SORRY FOR POSSIBLE MISTAKES ON THE LYRICS!! i don't own any rights! | ["Christian music", "Music"] | ["male singer", "classic rock", "pop song", "bad audio quality", "medium tempo", "string bass line", "guitar accompaniment", "piano accompaniment", "keybiard accompaniment", "steady drumming rhythm", "emotional", "passionate", "groovy rhythm", "new age", "romantic song", "sadness", "realisation", "modern pop songs", "love songs"] | 1 | Jq2w30NYstQ | 2037 | |
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;