musiccaps_details (view)
3 rows where musiccaps_aspects contains "female singer", musiccaps_aspects contains "piano accompaniment" and musiccaps_aspects contains "steady drumming rhythm"
This data as json, CSV (advanced)
musiccaps_aspects (array) 53 ✖
- emotional 3
- female singer · 3 ✖
- piano accompaniment · 3 ✖
- steady drumming rhythm · 3 ✖
- melancholic 2
- avant-garde 1
- avante-garde 1
- backup singers 1
- booming bass line 1
- carefree 1
- chaotic harmony 1
- cheerful 1
- choral music 1
- christmas carols 1
- christmas time 1
- classic pop hits 1
- classic pop song 1
- december 1
- dreamscapes 1
- electric guitar tremolo tones 1
- french jazz 1
- grunge keyboard tones 1
- inspiring 1
- it’s a wonderful life 1
- lilting melody 1
- love song 1
- medium tempo 1
- nostalgic 1
- pleasant 1
- poor audio quality 1
- pop song 1
- presents 1
- retro hits 1
- retro jazz 1
- retro pop hits 1
- romantic 1
- sadness 1
- slow tempo 1
- snare playing 1
- snowfall 1
- string bass drum kicks 1
- string bass line 1
- string section accompaniment 1
- strong bass drum kicks 1
- strong bass line 1
- tambourine percussions 1
- traditional percussion rhythm 1
- trudging drum rhythm 1
- vintage jazz 1
- vintage pop 1
- vocal harmony 1
- vocal vibrato 1
- winter wonderland 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
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 | |
Gaby Moreno - "Blues de mar" (Audio Single) | A female singer sings this beautiful vintage French melody. The song is medium tempo with a steady drum rhythm, steady bass line, piano accompaniment , string section harmony and some lush snare play. The song is romantic and cheerful with an avant-garde nature. | 2012-10-18T23:56:00Z | Gaby Moreno | @Gaby_Moreno | ["Blues", "Music"] | ["female singer", "lilting melody", "vocal vibrato", "avant-garde", "string section accompaniment", "piano accompaniment", "steady drumming rhythm", "snare playing", "retro pop hits", "avante-garde", "french jazz", "retro jazz", "pleasant", "emotional", "it’s a wonderful life", "carefree", "love song", "retro hits", "vintage pop", "vintage jazz", "cheerful", "romantic"] | 1 | DgqPgNqW2hE | 1504 | |
Transistor OST - In Circles Mashup (Humming & Singing) | A female singer sings this poignant melody. The song is slow tempo with an electric guitar buzzing harmony, piano accompaniment, steady drumming rhythm, keyboard harmony, groovy bass line and Tambour percussions. The song is emotional and melancholic. The song is a poor quality recording of a classic pop song. | 2014-07-04T13:54:06Z | the Dragon Coffee | Lyrics: I hear you buzzing, a fly on the wall In through the window and up through the hall Flying in circles just trying to land I see you hurting I do what I can But I won't save you I won't save you Maybe you're looking for someone to blame Fighting for air while you circle the drain Never be sorry for your little time It's not when you get there, it's always the climb But I won't save you I won't save you I won't save you I won't save you ------------------------------------------------------ THANKS to the Supergiant Games for this AWESOME GAME, and Music! | ["Singing", "Humming", "Music", "Song"] | ["female singer", "grunge keyboard tones", "classic pop hits", "dreamscapes", "tambourine percussions", "steady drumming rhythm", "booming bass line", "traditional percussion rhythm", "chaotic harmony", "poor audio quality", "electric guitar tremolo tones", "piano accompaniment", "pop song", "classic pop song", "inspiring", "emotional", "slow tempo", "trudging drum rhythm", "sadness", "melancholic"] | 1 | z6SNngkMAug | 5457 |
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;