musiccaps_details (view)
3 rows where musiccaps_aspects contains "piano accompaniment", musiccaps_aspects contains "romantic" and musiccaps_aspects contains "steady drumming rhythm"
This data as json, CSV (advanced)
musiccaps_aspects (array) 52 ✖
- piano accompaniment · 3 ✖
- romantic · 3 ✖
- steady drumming rhythm · 3 ✖
- emotional 2
- male singer 2
- avant-garde 1
- avante-garde 1
- backup singers 1
- beautiful 1
- carefree 1
- cheerful 1
- clapping percussion 1
- courtship song 1
- fast tempo 1
- feel good 1
- female singer 1
- french jazz 1
- groovy rhythm 1
- guitar accompaniment 1
- guitar strumming rhythm 1
- hip hop dance music 1
- hip hop love songs 1
- infatuation 1
- it’s a wonderful life 1
- keyboard accompaniment 1
- lilting melody 1
- love at first sight 1
- love song 1
- madly in love 1
- medium tempo 1
- modern pop hits 1
- modern romantic hits 1
- percussive bass line 1
- pleasant 1
- poor audio quality 1
- pop love song 1
- retro hip hop hits 1
- retro hits 1
- retro jazz 1
- retro pop hits 1
- screaming vocals 1
- sentimental 1
- slow dance 1
- snare playing 1
- string section accompaniment 1
- strong bass line 1
- various percussion hits 1
- vintage jazz 1
- vintage pop 1
- violin playing countermelody 1
- vocal harmony 1
- vocal vibrato 1
musiccaps_names (array) 4 ✖
- Music 3
- Blues 1
- Exciting 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 |
---|---|---|---|---|---|---|---|---|---|---|
Gaby Moreno - "Blues de mar" (Audio Single) | A female singer sings this beautiful vintage French melody. The song is medium tempo with a steady drum rhythm, steady bass line, piano accompaniment , string section harmony and some lush snare play. The song is romantic and cheerful with an avant-garde nature. | 2012-10-18T23:56:00Z | Gaby Moreno | @Gaby_Moreno | ["Blues", "Music"] | ["female singer", "lilting melody", "vocal vibrato", "avant-garde", "string section accompaniment", "piano accompaniment", "steady drumming rhythm", "snare playing", "retro pop hits", "avante-garde", "french jazz", "retro jazz", "pleasant", "emotional", "it’s a wonderful life", "carefree", "love song", "retro hits", "vintage pop", "vintage jazz", "cheerful", "romantic"] | 1 | DgqPgNqW2hE | 1504 | |
KEL MITCHELL OFFICIAL "SAME CURL" VIDEO | A male singer sings this cool hip hop melody with backup singers in vocal harmony and screaming vocals. The song is medium tempo with a piano accompaniment, percussive bass line, steady drumming rhythm, clapping percussions, and keyboard accompaniment. The song is passionate like a courtship song. The song has bad audio quality. | 2007-09-06T23:27:32Z | Kel Mitchell | SUBSCRIBE HERE: http://tinyurl.com/kj7kuzo Kel Mitchell stand up previews: http://tinyurl.com/npxffcg R&B Kicked-Outz episodes: http://www.tinyurl.com/m4gvham Hotness or Hotmess: http://tinyurl.com/kbpysg5 Comedy tour dates: http://tinyurl.com/p6bdvos KEL MITCHELL LINKS TWITTER: http://tinyurl.com/l74krrx INSTAGRAM: http://tinyurl.com/oeoqq5j FACEBOOK: http://tinyurl.com/lc9zh8l WEBSITE: http://www.kelmitchell.net GOOGLE PLUS: http://tinyurl.com/qb4vza6 Booking for Kel Mitchell: http://tinyurl.com/le2w9xs Spoof Videos: http://tinyurl.com/n7rynk5 Kel Mitchell is an actor, comedian, dancer, musician, screenwriter, director and producer. GOD BLESS "Jesus will hold it together until you get it together" stay focused! Actor Kel Mitchell's OFFICIAL and very popular music video spoof "Same Curl" based on R. Kelly and Usher's "Same Girl" video. For more info on Kel Please Visit: http://www.KelMitchell.net And for all the haters....you can hate if you want to but you ain't stoppin' NOTHING! | ["Music", "Exciting music"] | ["male singer", "backup singers", "hip hop dance music", "vocal harmony", "screaming vocals", "steady drumming rhythm", "clapping percussion", "keyboard accompaniment", "piano accompaniment", "groovy rhythm", "various percussion hits", "hip hop love songs", "slow dance", "romantic", "courtship song", "madly in love", "infatuation", "love at first sight", "poor audio quality", "retro hip hop hits", "percussive bass line", "medium tempo"] | 1 | Q1pjymZOm6Q | 2590 | |
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;