musiccaps_details (view)

2 rows where search matches "ballad", musiccaps_aspects contains "male voice", 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) 5 ✖

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
Tony Wilson - just one time This pop ballad features two male voices singing in octaves. This is accompanied by percussion playing a simple beat. A bass plays the root notes of the chords. A piano plays the chords by striking them just once per bar. When the voice pauses between verses, another voice sings descending pattern vocables in falsetto. When the main voice resumes, a synth fill is played along with a muted guitar. The rest of the instruments continue to play their respective parts. This song has a romantic mood. This song can be played in a romantic movie. 2014-03-25T09:41:11Z Gvantsa Tsutsko https://www.youtube.com/channel/UCvW36-FtYjhZli7AsVAGVBw ["Funk", "Music", "Independent music", "Happy music"] ["pop ballad", "piano song", "simple percussion", "male voice", "romantic theme", "vocal harmony", "vocal octaves", "muted guitar", "bass", "synth fill"] 0 lV0-LMVpZLg 4405

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;