musiccaps_details (view)
5 rows where search matches "guitar", musiccaps_aspects contains "cheerful" and musiccaps_aspects contains "vocal harmony" sorted by youtube_id
This data as json, CSV (advanced)
musiccaps_aspects (array) 82 ✖
- cheerful · 5 ✖
- vocal harmony · 5 ✖
- medium tempo 4
- female singer 3
- romantic 3
- backup singers 2
- emotional 2
- guitar accompaniment 2
- happy 2
- keyboard accompaniment 2
- poor audio quality 2
- acapella 1
- acoustic guitar lead 1
- acoustic guitar strumming 1
- animal noises 1
- animated vocals 1
- average audio quality 1
- bouncy drum rhythm 1
- buoyant 1
- children’s song 1
- children’s songs 1
- dance rhythm 1
- electric guitar harmony 1
- energetic 1
- entertaining 1
- enthusiastic drumming 1
- ethnic percussions 1
- exciting 1
- feel good 1
- female backup singers 1
- female singers 1
- foreign language 1
- fresh 1
- fun 1
- funky bass lines 1
- groovy bass line 1
- groovy rhythm 1
- guitar lead 1
- heartfelt 1
- heavy noise 1
- hood old times 1
- keybiard accompaniment 1
- keyboard harmony 1
- latin dance song 1
- latin pop song 1
- life is good 1
- love song 1
- male backup singers 1
- male latin singer 1
- medium fast tempo 1
- passionate 1
- peppy 1
- percussive bas slime 1
- percussive bass line 1
- perky 1
- pleasant melody 1
- pop hits 1
- pop music 1
- pop song 1
- positive 1
- reggae music influences 1
- relaxing playlist 1
- retro pop hits 1
- retro pop song 1
- retro super hits 1
- simple 1
- song ending 1
- soulful singer 1
- steady drumming rhythm 1
- story telling 1
- string bass 1
- string bass line 1
- teen pop 1
- various percussion hits 1
- video soundtrack 1
- vintage pop song 1
- vintage super hits 1
- vivacious 1
- vocal crooning 1
- vocal duet 1
- yodelling sounds 1
- youthful 1
musiccaps_names (array) 8 ✖
- Music 5
- Happy music 3
- Singing 2
- Flamenco 1
- Guitar 1
- Jingle (music) 1
- Rhythm and blues 1
- Yodeling 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id ▼ | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Arizona Yodeler - DeZurik Sisters | Two female singers sing this delightful vocal duet in harmony. They make funny animated vocal effects like yodelling and funny animal noises. The song is medium fast tempo with a guitar accompaniment and no percussion. The song is cheerful and story telling in nature. The song is a vintage pop song with bad audio quality. | 2008-03-21T13:55:24Z | ebronken | I'm rather a vintage jazz man, country is only among my peripheral interests, but when a colleague of mine came to me saying "thou hast to hear this" and gave me a disc with transcriptions of the six cuts made by the DeZurik Sisters in 1938, I was completely overtaken. To my surprise none had posted any of these here on YouTube, so I decided to do the work, and have made this video using what is undoubtedly the most impressing of the six. If requested I might put out the rest, later. | ["Singing", "Yodeling", "Guitar", "Music"] | ["female singers", "animated vocals", "yodelling sounds", "relaxing playlist", "children’s songs", "animal noises", "medium tempo", "guitar accompaniment", "female singers", "vocal duet", "vocal harmony", "medium fast tempo", "poor audio quality", "story telling", "cheerful", "happy", "life is good", "hood old times", "vintage super hits", "heavy noise", "vintage pop song", "children’s song"] | 1 | DNYDyXn6qso | 1468 | |
豬之歌 - 香香 | A female singer sings this lovely melody with a choral harmony support. The song is medium tempo with a Steady drumming rhythm, various percussion, percussive bass line, keyboard accompaniment and guitar rhythm. The song slows down at the end. The song is emotional and exciting. | 2011-11-26T13:35:07Z | TigerleoAB | 豬之歌 詞/曲:毛慧 豬 你的鼻子有兩個孔 感冒時的你 還掛著鼻涕牛牛 豬 你有著黑漆漆的眼 望呀望呀望 也看不到邊 豬 你的耳朵是那麼大 呼扇呼扇 也聽不到我在罵你傻 豬 你的尾巴是卷又捲 原來跑跑跳跳 還離不開它 哦~~~ 豬頭豬腦豬身豬尾巴 從來不挑食的乖娃娃 每天睡到日曬三桿後 從不刷牙從不打架 豬 你的肚子是那麼鼓 一看就知道 受不了生活的苦 豬 你的皮膚是那麼白 上輩子一定投在 那富貴人家 哦~~~ 傳說你的祖先有八釘耙 算命先生說他命中犯桃花 見到漂亮姑娘 就嘻嘻哈哈 不會臉紅 不會害怕 豬頭豬腦豬身豬尾巴 從來不挑食的乖娃娃 每天睡到日曬三桿後 從不刷牙 從不打架 哦~~~ 傳說你的祖先有八釘耙 算命先生說他命中犯桃花 見到漂亮姑娘 就嘻嘻哈哈 不會臉紅 不會害怕 你很像他 咳咳嗯 | ["Music", "Happy music"] | ["female singer", "backup singers", "pop music", "percussive bass line", "song ending", "medium tempo", "keyboard accompaniment", "fun", "cheerful", "positive", "emotional", "romantic", "vocal harmony", "steady drumming rhythm", "percussive bas slime", "keyboard harmony", "ethnic percussions", "exciting", "energetic", "vocal harmony", "pop hits", "retro pop hits", "video soundtrack", "various percussion hits"] | 1 | Ur8O3h8S0K4 | 2947 | |
Bowl for Two - The Expendables | A male singer sings this cheerful melody with backup singers in vocal harmony. The song is medium tempo with a reggae style drum and guitar accompaniment, guitar lead and a groovy bass line. The song is romantic and cheerful . The song is a Latin pop dance song. The audio quality is average. | 2007-09-02T03:29:08Z | P3DRO2 | lovin it | ["Music", "Happy music"] | ["male latin singer", "backup singers", "vocal harmony", "keyboard accompaniment", "average audio quality", "groovy bass line", "guitar accompaniment", "guitar lead", "bouncy drum rhythm", "reggae music influences", "keybiard accompaniment", "entertaining", "cheerful", "romantic", "love song", "latin pop song", "latin dance song", "groovy rhythm"] | 1 | euAQCWBX6ns | 3904 | |
Happy Music 今こそハッピーな歌を! by misc | A female vocalist sings this chirpy song. The tempo is medium with a melodic electric guitar harmony, acoustic guitar lead, sprightly drumming, funky bass lines and peppy backup. The song is youthful, perky, cheerful, vivacious ,bubbly and in a foreign language.This song is teen pop/ Pop. | 2011-03-18T23:09:55Z | happymusicX | 悩みなんか 弾け飛んで 忘れちゃって 流しちゃって 太陽が笑うよ happy music 僕らはみんな宇宙のフレンズ 何が起きても独りじゃない 笑顔の数だけのハッピー 集めたらまわり出す ほら聴こえて繰るよ happy music (歌詞の一部より) 歌タイトル:太陽と猫と私 Vocal & Violin: misc (ミスク) Music arrangement: iNA (ex hide with spread beaver) 想像を超えた大災害に心が震えるけど、そんなときこそ、口ずさみたい歌に出会ったのでアップロードしたよ。これ聞きながら、駅まで歩いたら明るい気分になれたから。 | ["Jingle (music)", "Music", "Rhythm and blues", "Happy music"] | ["female singer", "medium tempo", "foreign language", "electric guitar harmony", "funky bass lines", "acoustic guitar lead", "enthusiastic drumming", "vocal harmony", "youthful", "pleasant melody", "simple", "fresh", "happy", "perky", "cheerful", "vivacious", "buoyant", "peppy", "pop song", "teen pop"] | 7 | gBuLpP4klvI | 4012 | |
Joan Armatrading - Love And Affection 1976 | A female singer sings this beautiful melody with male and female backup singers in vocal harmony. The song is medium tempo with an acoustic guitar playing rhythm and strong string bass line with no percussion instrumentation. The song is emotional and heartfelt. The song has acapella influences and is soulful. The song is of poor audio recording quality. | 2010-03-19T15:03:53Z | fritz51329 | Joan Armatrading - Love And Affection 1976 I am not in love But I'm open to persuasion East or West Where's the best For romancing With a friend I can smile But with a lover I could hold my head back I could really laugh Really laugh Thank you You took me dancing 'Cross the floor Cheek to cheek But with a lover I could really move Really move I could really dance Really dance Really dance Really dance I could really move Really move Really move Really move Now if I can feel the sun In my eyes And the rain on my face Why can't I Feel love I can really love Really love Really love Really love Really love Love love love love Love love love love Now I got all The friends that I want I may need more But I shall just stick to those That I have got With friends I still feel So insecure Little darling I believe you could Help me a lot Just take my hand And lead me where you will No conversation No wave goodnight Just make love With affection Sing me another love song But this time With a little dedication Sing it, sing it You know that's what I like Once more with feeling Give me love Give me love Give me love Love (Instrumental) Make love with affection Sing me another love song But this time With a little dedication Sing it, sing it You know that's what I like With affection Sing me another love song But this time With a little dedication Sing it, sing it You know that's what I like With affection With a little dedication Once more with feeling You know that's what I like | ["Singing", "Flamenco", "Music"] | ["female singer", "soulful singer", "poor audio quality", "male backup singers", "string bass line", "acoustic guitar strumming", "vocal harmony", "female backup singers", "retro pop song", "cheerful", "emotional", "retro super hits", "dance rhythm", "medium tempo", "string bass", "acapella", "passionate", "romantic", "heartfelt", "feel good", "vocal crooning"] | 1 | oag3I4VRXyM | 4645 |
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;