musiccaps_details (view)
6 rows where musiccaps_aspects contains "romantic" and musiccaps_author = 6
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 |
|---|---|---|---|---|---|---|---|---|---|---|
| Amor Secreto - Kendo Kaponi ( Lyrics ) | This song contains a piano playing a melody in the mid range and also in the higher register. A flute is adding another melody in the mid range. A digital drum is holding a simple groove before dropping out completely. A male voice is softly rapping/talking in the mid range then another male with an effect takes over singing in a higher pitch. In the background you can hear strings underlaying chords. This song may be playing with headphones daydreaming. | 2011-06-16T16:52:05Z | MsCuBaNiTa01 | ["Music", "Tender music"] | ["pop", "piano", "strings", "digital drums", "digital flute", "male voices singing/rapping", "romantic", "sensitive", "medium tempo"] | 6 | 6sWVG6GyJBU | 793 | ||
| Maybe It's You | Someone is playing a minor chord composition on an acoustic piano while a female voice is singing with a lot of reverb on her voice. This song may be playing on a karaoke night. | 2006-05-09T03:19:08Z | neo0802 | Music Video | ["Music", "Lullaby"] | ["pop-ballad", "acoustic piano", "female voice singing", "romantic", "slower tempo"] | 6 | 9UD7qz7DuVY | 1013 | |
| Dmitry Zharkov - Olga Kulikova | Final Slow Fox | Finland Open 2016 Grand Slam | An acoustic drum is playing a jazzy groove on the ride along with a bassline while an e-guitar is playing jazz chords with a lot of changes together with an acoustic piano rendering phrases with an uplifting melody. The singer's voice sounds low and romantic. This song may be playing while dancing with a partner. | 2016-03-26T13:14:27Z | in.media | Finland Open 2016 Grand Slam Standard Final Round Slow Foxtrot Dmitry Zharkov - Olga Kulikova | ["Singing", "Applause", "Music"] | ["jazz/ballad", "acoustic piano", "acoustic drums", "e-bass", "e-guitar", "male deep voice singing", "crowd cheering and clapping", "medium to uptempo", "romantic"] | 6 | HLz3N5nG8fQ | 1793 | |
| Neil Sedaka - Laughter In The Rain [w/ lyrics] | An acoustic drum is played along with a bassline, an acoustic guitar and piano all playing the same rhythm. Strings are playing a melody in the mid range along with the female singer that gets accompanied by backing vocals singing harmonies along. This song sounds romantic and cheerful. This song may be playing at the beginning scene of a rom-com movie. | 2011-06-01T19:40:57Z | cyberman000051 | "Laughter in the Rain" is a song recorded by Neil Sedaka, composed by him with lyrics by Phil Cody. It includes a 20-second saxophone solo by Jim Horn.[1] Cody reports writing the lyrics in about five minutes after smoking marijuana and falling asleep under a tree for a couple of hours. In the USA, "Laughter in the Rain" reached number one on the Billboard Hot 100 on February 1, 1975 (it was his first single to top the Hot 100 since 1962).[3] The song spent two weeks at the top of the adult contemporary chart. The song was likewise a major hit in Canada, reaching number two on the pop singles chart and number one on the Adult Contemporary chart. The song was also released in the UK where it spent nine weeks on the Singles Chart, peaking at No. 15 on June 22, 1974 | ["Music", "Independent music", "Psychedelic rock", "Song", "Soul music"] | ["pop", "strings", "acoustic drums", "piano", "e-bass", "acoustic drums", "female voice singing", "backing voices", "medium to uptempo", "romantic", "cheerful"] | 6 | VCusyLPrFCo | 2984 | |
| CHERYL BERDELL - Giving It All To You | This song contains an acoustic piano playing a melody in the mid- to high range along with a simple bassline playing long notes. A saxophone is playing a loud melody in a higher key. In the background you can hear strings and some fast percussive rolls. THe audio contains white noise. This song may be playing on a romantic date. | 2010-01-13T13:33:15Z | NaturalSoulBrother1 | Give it time to kick in and I'm pretty sure this is one of them tunes that will stay buzzing around your head for days to come. Great piece of Chicago Modern Soul and a great feel good tune as well. Hope you enjoy. | ["Brass instrument", "Saxophone"] | ["ballad", "acoustic piano", "strings", "e-bass", "saxophone", "percussion", "romantic"] | 6 | fKni4PUSxu4 | 3941 | |
| Beautiful Wedding Processional Music - Enya Only Time by Art-Strings Quartet of New York, NY | This audio contains a string section playing a romantic ballad. Violin and viola are playing the lead melody while celli are playing a rhythmic melody in the background. This song may be playing live for a wedding. | 2010-04-22T02:42:53Z | ArtStringsEnsembles | http://www.Art-Strings.com Art-Strings Quartet Tribute to Enya. Hear more of the Art-Strings Ensembles recordings at http://www.Art-Strings.com | ["Music", "Sad music"] | ["ballad", "orchestral", "string section", "celli", "violin", "romantic", "medium tempo"] | 6 | hkWOAj09_dY | 4134 |
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;