musiccaps_details (view)

2 rows where search matches "ballad", musiccaps_aspects contains "romantic song", musiccaps_author = 0 and musiccaps_names contains "Music"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: youtube_published (date)

musiccaps_names (array) 4 ✖

musiccaps_author 1 ✖

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
SWOOSH This pop ballad features a female voice singing the main melody. This is accompanied by percussion playing a simple beat in the background. The bass plays the root notes of the chords. A synth plays chords and fills. The sound of wheels on concrete can be heard. The mood of this song is romantic. A live recording sound is overdubbed on this song. 2015-07-14T14:58:23Z William Strobeck SWOOSH...A video for the Supreme/Nike SB GTS collection. Featuring: Alex Olson Kevin Bradley Brian Anderson & Sean Pablo 2015 @williamstrobeck ["Music", "Pop music", "Skateboard"] ["pop ballad", "moderate tempo", "female voice", "live recording over song", "synth backing", "simple percussion", "bass", "romantic song", "wheels on concrete sound", "ambient noises"] 0 9Ijpv6e57a4 990

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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;