musiccaps_details (view)
1 row where musiccaps_aspects contains "pop ballad" and musiccaps_author = 3
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 |
|---|---|---|---|---|---|---|---|---|---|---|
| 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 |
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;