musiccaps_details (view)
3 rows where musiccaps_aspects contains "happy" and musiccaps_aspects contains "poor audio quality" sorted by youtube_id
This data as json, CSV (advanced)
musiccaps_aspects (array) 45 ✖
- happy · 3 ✖
- poor audio quality · 3 ✖
- cheerful 2
- accordion 1
- animal noises 1
- animated vocals 1
- aural development 1
- bell tones 1
- child development 1
- children’s song 1
- children’s songs 1
- emotional 1
- female singers 1
- female singing quarter 1
- guitar accompaniment 1
- harmonies 1
- heavy noise 1
- hood old times 1
- instrumental music 1
- kindergarten songs 1
- life is good 1
- live performance 1
- live recording 1
- medium fast tempo 1
- medium tempo 1
- motor engine sound 1
- motor skills 1
- music box harmony 1
- nursery rhyme 1
- percussion instruments 1
- positive 1
- relaxing playlist 1
- slow tempo 1
- story telling 1
- toddler tunes 1
- toddler’s attention 1
- upbeat 1
- vintage european 1
- vintage pop song 1
- vintage super hits 1
- violins 1
- visual stimulation 1
- vocal duet 1
- vocal harmony 1
- yodelling sounds 1
musiccaps_names (array) 10 ✖
- Music 3
- A capella 1
- Bell 1
- Bowed string instrument 1
- Classical music 1
- Guitar 1
- Musical instrument 1
- Singing 1
- Violin, fiddle 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 | |
Wii Music: Twinkle Twinkle Little Star, the Bell Chorus | The song is an instrumental. The tempo is slow with percussive instruments playing, bells percussions and a music box melody. The song is educational and designed for toddlers. The audio quality is pretty average. | 2008-10-30T23:53:45Z | Beastly Drohan | One of the best things about Wii Music is that you can arrange a song using the same instrument, creating some awesome choruses. With "Twinkle Twinkle Little Star" I created a bell chorus version. I honestly don't like the setting I chose, though. Anyways, forgive the video quality and enjoy! | ["Bell", "Music"] | ["nursery rhyme", "motor engine sound", "toddler’s attention", "aural development", "child development", "emotional", "happy", "positive", "visual stimulation", "motor skills", "percussion instruments", "bell tones", "music box harmony", "slow tempo", "instrumental music", "poor audio quality", "kindergarten songs", "toddler tunes"] | 1 | XykUpCigu4w | 3242 | |
Quartet "Salut Salon" | This is a live performance by a female vocal quartet. They harmonise their voices and sing in a vibrant and cheerful way. They sing in French. Later, we hear two violins playing in sync as well as an accordion. The recording quality of the audio is poor. | 2009-07-26T14:05:26Z | Dina Anunziata | "Heartache" concert of the Hamburgs quartet "Salut Salon" performed in St.Petersburg, Russia during "Week of Germany" | ["Music", "Musical instrument", "Violin, fiddle", "Classical music", "Bowed string instrument", "A capella"] | ["live recording", "live performance", "female singing quarter", "poor audio quality", "violins", "accordion", "cheerful", "happy", "upbeat", "harmonies", "vintage european"] | 3 | YErpnsceZw8 | 3268 |
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;