musiccaps_details (view)
1 row where musiccaps_aspects contains "ballad", musiccaps_aspects contains "minimal instruments", musiccaps_aspects contains "slow song", musiccaps_aspects contains "slow tempo" and musiccaps_names contains "Tender music"
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 |
---|---|---|---|---|---|---|---|---|---|---|
BEST LOVE SONG - "LOVE" original Austin Nix | This song is a ballad which features a male voice singing the main melody. This is accompanied by a plucked guitar playing arpeggiated chords. There are no other instruments. There is no percussion. The mood of this song is romantic. This song can be played in a romantic movie. | 2011-02-12T12:28:39Z | Ken Nix | Other Austin Nix Songs: https://www.youtube.com/watch?v=bgbALOjce3c - Twenty-One https://www.youtube.com/watch?v=KNb3A5xvDZM - Funny Valentine Song Austin Nix New YouTube Channel https://www.youtube.com/channel/UCVZwveAVgdWUOY13YNTdeXQ *****LYRICS***** Love can blind us or leave us deaf rip a beating heart from our chest find us gasping for air for the one who took our breath. love can tie us in a knot say silly words when were taking a shot in the dark to see if she likes us or not. and love is the only thing that seems real other than pain its all i feel The constant stream that melts my mind surreal love, its coarsing through my veins when i see you im finally sane unique and never the same waiting for the change. of love, its coarsing through my brain more addictive than cocaine even harder to explain even harder to obtain. love, takes us for a ride keeps us afraid to close our eyes we can't even chance blinking or she'll disapear by surprise. love, can make the ground tremble beneath our toes sneak around right under our nose keep us moving 'til theres no where left to go. love, can be the greatest feeling on this earth for me she came first no im not cursed, I'm only waiting for her heart to disperse. love, its coarsing through my veins when i see you im finally sane unique and never the same waiting for the change. of love, its coarsing through my brain more addictive than cocaine even harder to explain even harder to obtain. 2018 "best valentine song" | ["Music", "Tender music"] | ["ballad", "plucked guitar", "slow song", "romantic song", "male voice", "slow tempo", "minimal instruments", "no percussion"] | 0 | 8BJljuSm2Aw | 900 |
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;