musiccaps_details (view)
5 rows where musiccaps_aspects contains "emotional", musiccaps_aspects contains "medium tempo" and musiccaps_aspects contains "nostalgic"
This data as json, CSV (advanced)
musiccaps_aspects (array) 75 ✖
- emotional · 5 ✖
- medium tempo · 5 ✖
- nostalgic · 5 ✖
- romantic 3
- bad audio quality 2
- instrumental music 2
- sentimental 2
- accordion accompaniment 1
- accordion players 1
- acoustic guitar accompaniment 1
- bach 1
- backup singers 1
- bow 1
- cellist 1
- cello 1
- cello suite 1
- cheerful 1
- choral music 1
- christmas carols 1
- christmas time 1
- dance rhythm 1
- december 1
- dissonant tambourine beats 1
- electric guitar rhythm 1
- energetic drumming 1
- entertaining 1
- exciting 1
- female singer 1
- fingering technique 1
- great composers 1
- groovy bass line 1
- groovy rhythm 1
- gypsy music influences 1
- home video 1
- idyllic fun 1
- keyboard harmony 1
- live recording 1
- low pitched notes 1
- male singer 1
- male vocalist 1
- melancholic 1
- mellow 1
- melodic 1
- melodious 1
- passionate 1
- piano accompaniment 1
- pleasant 1
- poignant 1
- pop 1
- pop hits 1
- positive 1
- practice session 1
- presents 1
- retro instrumental 1
- rhythmic acoustic guitar 1
- snowfall 1
- soft keyboard harmony 1
- soft pop 1
- soloist 1
- soundboard 1
- steady drumming 1
- steady drumming rhythm 1
- string bass drum kicks 1
- string bass line 1
- strings 1
- strong bass drum kicks 1
- strong bass line 1
- studio session 1
- subtle bass line 1
- sweet 1
- synth arrangement 1
- the good life 1
- vocal harmony 1
- western classical music 1
- winter wonderland 1
musiccaps_names (array) 10 ✖
- Music 3
- /t/dd00004 1
- Accordion 1
- Bowed string instrument 1
- Cello 1
- Christmas music 1
- Double bass 1
- Grunge 1
- Singing 1
- Soul music 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 | |
J.S.Bach - Cello Suite No.1 - Prelude - Double Bass | The song is an instrumental. The tempo is medium with a cellist playing a JS Bach tune with exemplary skill in a rehearsal session. The song has bad audio quality. The song is a western classical music tune. | 2014-09-03T19:30:44Z | TESEO | J.S.Bach - Suite No.1 for Double Bass BWV 1007 - Prelude - Plays Francesco Tesei - New Fan Page - https://www.facebook.com/Teseoguitar - SUBSCRIBE! http://www.youtube.com/user/teseoguitar?sub_confirmation=1 | ["Cello", "Double bass", "Bowed string instrument"] | ["cello suite", "cello", "cellist", "home video", "emotional", "passionate", "romantic", "nostalgic", "instrumental music", "medium tempo", "bad audio quality", "western classical music", "bach", "practice session", "live recording", "exciting", "low pitched notes", "strings", "soundboard", "fingering technique", "bow", "studio session", "great composers", "soloist"] | 1 | B1ixRtiUJ-U | 1194 | |
PABLITO CERRANO Y ARIEL TORRES A PURO CHAMAME | The song is an instrumental. The song is medium tempo with two accordion players playing on harmony and no other instrumentation. The music is romantic and passionate. The song has gypsy music roots. | 2012-11-01T00:48:18Z | RAM TOR | POR CONTRATACIONES COMUNICARSE AL( 03844)(15)468108 | ["Accordion"] | ["accordion players", "accordion accompaniment", "gypsy music influences", "emotional", "dance rhythm", "retro instrumental", "nostalgic", "entertaining", "cheerful", "positive", "the good life", "idyllic fun", "instrumental music", "bad audio quality", "groovy rhythm", "medium tempo"] | 1 | Jsk3ZUGvP-o | 2042 | |
Lie To Me opening theme - Music - Ryan Star - Brand New Day | A male vocalist sings this melodic pop song.The tempo is medium with energetic drumming, keyboard harmony, groovy bass lines, electric guitar harmony, acoustic guitar rhythm and dissonant tambourine beats. The is soft, calming, mellow, sentimental, emotional and nostalgic. This song is Pop Rock/Soft Rock. | 2009-04-17T03:37:09Z | Ricardo Miranda | Clipe da musica de abertura do seriado Lie To Me (Ryan Star - Brand New Day) Hello to all the video was made is not official Fan to Fan Olá a todos o video não é oficial foi feito de Fã para fã Os gráficos são baixos o vídeo foi feito com vários outros vídeos disponíveis no YT | ["Music", "Grunge"] | ["male vocalist", "medium tempo", "energetic drumming", "groovy bass line", "synth arrangement", "keyboard harmony", "electric guitar rhythm", "dissonant tambourine beats", "sweet", "melodious", "mellow", "romantic", "emotional", "sentimental", "nostalgic", "poignant", "acoustic guitar accompaniment"] | 7 | l9vYSBR9nio | 4377 | |
Arnel Pineda in AMO, 1988, singing "Lights" by Journey | A male vocalist sings this soft melody. The tempo is slow with a mellow keyboard harmony, steady drumming, subtle bass line and acoustic guitar accompaniment. The song is soft, romantic, melodic, emotional , sentimental, melancholic and pleasant. This song is classic Soft Rock. | 2008-03-22T11:10:43Z | ArnelPinedaFan | Audio only. Arnel Pineda with AMO, performing live "Lights" (originally by Journey) in 1998, almost 20 years before he became Journey's lead singer. Photos from Arnel's "journey" accompany the video. NOTE: Sorry I can't approve non-English comments because I don't understand them. | ["Singing", "Music", "Soul music", "/t/dd00004"] | ["male singer", "medium tempo", "soft keyboard harmony", "steady drumming", "subtle bass line", "rhythmic acoustic guitar", "romantic", "pleasant", "soft pop", "pop", "pop hits", "romantic", "sentimental", "emotional", "nostalgic", "melodic"] | 7 | thHSYzhoLo4 | 5057 |
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;