musiccaps_details (view)
2 rows where musiccaps_aspects contains "song introduction" and musiccaps_aspects contains "spirited"
This data as json, CSV (advanced)
musiccaps_aspects (array) 40 ✖
- emotional 2
- piano accompaniment 2
- song introduction · 2 ✖
- spirited · 2 ✖
- acoustic song 1
- amateur pop music 1
- ambient noises 1
- breathing sounds 1
- cheerful 1
- classical music 1
- comically happy 1
- e erotic 1
- energetic 1
- fast tempo 1
- feeling loved 1
- free spirit 1
- fun 1
- guitar accompaniment 1
- happy 1
- hissing noises 1
- instrumental music 1
- lilting 1
- medium tempo 1
- new experiences 1
- party time 1
- passionate 1
- poor audio quality 1
- pop music 1
- pop song 1
- positive 1
- retro youtube pop 1
- rustling tones 1
- school recital 1
- scream and shout 1
- steady drumming rhythm 1
- strong bass line 1
- the first time 1
- vocal recital 1
- yodelling vocals 1
- youthful 1
musiccaps_names (array) 3 ✖
- Music 2
- Rustling leaves 1
- Yodeling 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Bayartsengel yodel | A male singer sings cheerful yodelling vocals. The song is fast tempo, with a steady drumming rhythm, groovy bass line, guitar accompaniment and piano playing enthusiastically. The song is cheerful and thoroughly entertaining. The song is a modern pop tune with yodelling to express happiness and free spirit. | 2011-06-09T11:54:50Z | ulzii bat | Bayartsengel yodel | ["Yodeling", "Music"] | ["fast tempo", "guitar accompaniment", "retro youtube pop", "song introduction", "scream and shout", "pop music", "amateur pop music", "free spirit", "energetic", "song introduction", "youthful", "e erotic", "new experiences", "feeling loved", "the first time", "comically happy", "piano accompaniment", "strong bass line", "steady drumming rhythm", "yodelling vocals", "cheerful", "happy", "positive", "emotional", "spirited", "fun", "party time"] | 1 | I-C14nCneBs | 1857 | |
Madison sings Who Has Seen the Wind | The song is an instrumental. The tempo is medium and has a piano accompaniment. The song has a lot of ambient noises like hissing, breathing and hushed tones. The song is emotional but of poor audio quality. | 2009-04-27T16:51:17Z | lmsouthern | Madison sings her competition solo, Who Has Seen the Wind, at the Choir Concert April 26th. | ["Music", "Rustling leaves"] | ["ambient noises", "piano accompaniment", "emotional", "lilting", "vocal recital", "passionate", "spirited", "classical music", "pop song", "acoustic song", "breathing sounds", "rustling tones", "instrumental music", "hissing noises", "poor audio quality", "school recital", "song introduction", "medium tempo", "classical music"] | 1 | oJyyNWuyig4 | 4616 |
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;