musiccaps_details (view)
2 rows where musiccaps_aspects contains "cheerful", musiccaps_aspects contains "youthful" and musiccaps_names contains "Singing"
This data as json, CSV (advanced)
musiccaps_aspects (array) 36 ✖
- cheerful · 2 ✖
- youthful · 2 ✖
- acoustic guitar accompaniment 1
- amateur home recording 1
- amateur video 1
- clapping 1
- clapping rhythm 1
- college humour 1
- desk tapping rhythm 1
- emphatic vocals 1
- entertaining 1
- enthusiastic 1
- fart jokes 1
- fast tempo 1
- female singer 1
- funny videos 1
- groovy 1
- happy 1
- having fun 1
- joyful 1
- killing time 1
- laughing 1
- lively 1
- made up songs 1
- make your own songs 1
- male vocalist 1
- medium tempo 1
- no harmony instrumentation 1
- party song 1
- people talking 1
- poor quality 1
- popular song 1
- singing along 1
- spanish guitar 1
- spanish song 1
- teen age fun 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Sergio el duende ( y yo le canto al amor...) | A male vocalist sings this energetic song. The tempo is fast emphatic vocals, bright acoustic guitar accompaniment and clap beat. The song is youthful, energetic, popular, cheerful, engaging and happy. The music is minimal with ambient sounds of people clapping, cheering, singing along and keeping beat with claps. The audio is distorted and muffled as it is an amateur home recording. | 2013-07-09T13:09:10Z | Maria Luisa Asencio | ["Singing", "Music", "Musical instrument", "Clapping"] | ["male vocalist", "fast tempo", "acoustic guitar accompaniment", "spanish guitar", "lively", "entertaining", "enthusiastic", "party song", "happy", "joyful", "cheerful", "youthful", "clapping", "singing along", "people talking", "emphatic vocals", "amateur home recording", "spanish song", "popular song"] | 7 | PN3Lx8RutmI | 2529 | ||
I be Farting | A female singer sings this casual melody. The tempo is medium with clapping and desk tapping percussion and no other instrumentation. The song is very casual and made up for fun. The song has poor audio quality. | 2010-05-02T02:34:49Z | Genesis19 | New SONG ------- FOLLOW http://www.twitter.com/woahitsbrittney http://www.twitter.com/qenesis | ["Singing", "Music", "Hands", "Clapping"] | ["female singer", "amateur video", "poor quality", "youthful", "teen age fun", "groovy", "made up songs", "cheerful", "college humour", "killing time", "having fun", "killing time", "make your own songs", "fart jokes", "laughing", "funny videos", "clapping rhythm", "desk tapping rhythm", "no harmony instrumentation", "medium tempo"] | 1 | Z8L3jychP14 | 3343 |
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;