musiccaps_details (view)
2 rows where search matches "ballad", musiccaps_aspects contains "mellow" and musiccaps_names contains "Music" sorted by musiccaps_caption
This data as json, CSV (advanced)
musiccaps_aspects (array) 15 ✖
- mellow · 2 ✖
- acoustic guitar 1
- ballad 1
- bongo drums 1
- calming 1
- downtempo 1
- electric bass guitar bassline 1
- electric guitar arpeggio 1
- female vocal 1
- gentle male vocal 1
- male vocal 1
- melancholic 1
- pop ballad 1
- relaxing 1
- soft rock ballad 1
musiccaps_names (array) 3 ✖
- Music · 2 ✖
- A capella 1
- Wedding music 1
youtube_published (date) 2 ✖
- 2013-08-11 1
- 2015-04-27 1
video | youtube_link | musiccaps_caption ▼ | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
On Your Wedding Day (A Stepdad's Song) | The song features a calm, gentle male vocalist. It feels like a soft pop ballad, with a slight rock influence. There's an electric guitar arpeggio, bongo drums, and a prominent bassline. The song feels like it would be suitable as a loving dedication to someone. | 2013-08-11T02:29:43Z | Joe M | ©Copyright 2012 Joe Manzella All Rights Reserved This song is for Melissa: Happy First Anniversary, Sweetie! - Love Joe On Your Wedding Day (A Stepdad's Song) It wasn't really long ago that you were just a girl. I came into your life by chance and slowly shared your world. Through good times and some bad, still always proud to be your stepdad. And now here on your wedding day, as you dance by my side, I'm so thrilled 'cause I get to be stepfather of the bride. So as I hold your hand, this love for you is from your stepdad. (Bridge) Just call on me anytime, it's no bother Always know you'll be my daughter and I'll be there. Wherever this life shall choose to lead us there's a bond always between us,a tie we share and I'll always care. And so here on your wedding day I'm truly blessed to be your stepdad. | ["Music", "Wedding music"] | ["soft rock ballad", "ballad", "pop ballad", "electric bass guitar bassline", "gentle male vocal", "electric guitar arpeggio", "bongo drums", "relaxing", "mellow"] | 3 | OR_YbeqV5tA | 2439 | |
The Lone Bellow "Slip Slidin' Away" | This is an acoustic ballad that is sung in a melancholic manner by two male vocalists and a female vocalist. There is an acoustic guitar in the background playing a simple tune. The tempo and the general atmosphere of the song is relatively calm. The music could be played at a coffee shop in the background. | 2015-04-27T14:02:56Z | Ron Paris | The Lone Bellow doing a fantastic cover of Paul Simon's "Slip Slidin' Away". Recorded live at Virginia Arts Recording Studio in Charlottesville VA. A special Corner Lounge for 106.1 WCNR. Video by Ron Paris. | ["Music", "A capella"] | ["acoustic guitar", "male vocal", "female vocal", "melancholic", "calming", "downtempo", "mellow"] | 9 | 8r1y_Bz4VfQ | 955 |
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;