musiccaps_details (view)
4 rows where musiccaps_aspects contains "female singer", musiccaps_aspects contains "medium tempo" and musiccaps_aspects contains "piano accompaniment"
This data as json, CSV (advanced)
musiccaps_aspects (array) 56 ✖
- female singer · 4 ✖
- medium tempo · 4 ✖
- piano accompaniment · 4 ✖
- emotional 3
- bad audio quality 2
- melancholic 2
- romantic 2
- strong bass line 2
- acoustic love song 1
- amateur recording 1
- backup singers 1
- choral music 1
- christmas carols 1
- christmas time 1
- club 1
- december 1
- distorted vocals 1
- enthusiastic 1
- foreign language 1
- guitar accompaniment 1
- hissing noise 1
- home videos 1
- incoherent music 1
- inferior audio quality 1
- inspiring 1
- karaoke 1
- live performance 1
- missing you 1
- motivational 1
- nostalgia 1
- nostalgic 1
- off key singing 1
- old classics 1
- passionate 1
- poor audio quality 1
- pop cover 1
- pop song 1
- pop songs 1
- presents 1
- retro hits 1
- sad song 1
- snowfall 1
- song covers 1
- steady drumming rhythm 1
- story telling 1
- string bass drum kicks 1
- string bass line 1
- string section harmony 1
- strong bass drum kicks 1
- vibrato 1
- violin harmony 1
- vocal backup 1
- vocal harmony 1
- winter wonderland 1
- with you forever 1
- youthful 1
musiccaps_names (array) 7 ✖
- Music 4
- /t/dd00004 1
- Bell 1
- Christmas music 1
- Music of Asia 1
- Singing 1
- Tender music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
A time for us ~ lyrics ***there is a mistake with the name of singer. This is not Loreena*** | A female singer sings this lilting melody. The song is medium tempo with an acoustic guitar accompaniment, strong bass line, steady rhythm and piano accompaniment. The song has a bad audio quality. The song is emotional and nostalgic in nature. | 2010-08-25T18:09:52Z | CathCthrn | (Love Theme from Romeo and Juliet) (Words by Larry Kusik, Eddie Snyder / Music by Nino Rota) Lyrics A time for us, some day there'll be When chains are torn by courage born of a love that's free A time when dreams so long denied can flourish As we unveil the love we now must hide A time for us, at last to see A life worthwhile for you and me And with our love, through tears and thorns We will endure as we pass surely through every storm A time for us, some day there'll be a new world A world of shining hope for you and me A time for us, at last to see A life worthwhile for you and me And with our love, through tears and thorns We will endure as we pass surely through every storm A time for us, some day there'll be a new world A world of shining hope for you and me | ["Music", "Tender music"] | ["female singer", "bad audio quality", "medium tempo", "strong bass line", "guitar accompaniment", "pop song", "vibrato", "piano accompaniment", "string section harmony", "old classics", "retro hits", "story telling", "inspiring", "motivational", "emotional", "romantic", "nostalgia"] | 1 | 5Tq56BN8PCQ | 661 | |
Birdy - White Winter Hymnal [Audio] | A female singer sings this beautiful melody with vocal harmony. The song is medium tempo with a piano accompaniment, steady drumming rhythm, strong bass drum kicks and a steady bass line. The song is melancholic and emotional. The song is a modern Christmas carol. | 2011-10-31T14:07:06Z | Birdy | "White Winter Hymnal" by Fleet Foxes performed by Birdy from her self titled debut album. Birdy – Young Heart. The new album, out now: https://Birdy.lnk.to/Young-Heart Download Birdy's self titled album, now on iTunes: http://smarturl.it/birdy.albm.stnd As a gift from Birdy you can download this track for free! http://bit.ly/FreeBirdy Download Birdy's original track 'Without a Word' for free here: http://bit.ly/nNox56 Follow Birdy on: http://www.facebook.com/BirdyMusic http://www.twitter.com/OfficialBirdy http://instagram.com/Birdyinstagram https://www.tiktok.com/@birdy | ["Christmas music", "Music"] | ["female singer", "backup singers", "strong bass line", "strong bass drum kicks", "vocal harmony", "piano accompaniment", "medium tempo", "steady drumming rhythm", "string bass drum kicks", "string bass line", "melancholic", "choral music", "christmas carols", "winter wonderland", "emotional", "nostalgic", "christmas time", "december", "snowfall", "presents"] | 1 | 7LlKoQAvXUc | 834 | |
OPM Love Songs Medley by Kai Brosas | A female singer sings this beautiful melody. The tempo is medium with a piano or keyboard accompaniment and no other instrumentation. The song is emotional and passionate like a love song. The audio quality is very poor with a lot of hissing noise and distortion. | 2010-10-25T09:07:45Z | chelrada713 | ["Singing", "Bell", "Music"] | ["female singer", "poor audio quality", "hissing noise", "distorted vocals", "pop songs", "pop cover", "song covers", "piano accompaniment", "acoustic love song", "live performance", "club", "romantic", "emotional", "sad song", "passionate", "melancholic", "with you forever", "missing you", "passionate", "bad audio quality", "medium tempo"] | 1 | N8Fg3L1Cc5E | 2323 | ||
ジョウネツ | A female vocalist sings this pop song in a foreign language. The tempo is medium with karaoke music and vocal backup. The audio quality is inferior and the music is incoherent except for a violin harmony and piano accompaniment. This song is an amateur home video. | 2007-11-26T14:12:35Z | yupanntu | 熱い~ よっ釣れた(笑) | ["Music of Asia", "Music", "/t/dd00004"] | ["female singer", "medium tempo", "foreign language", "violin harmony", "piano accompaniment", "karaoke", "off key singing", "vocal backup", "incoherent music", "amateur recording", "inferior audio quality", "enthusiastic", "youthful", "home videos"] | 7 | jKWl63gozLE | 4246 |
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;