musiccaps_details (view)
3 rows where musiccaps_aspects contains "clapping" and musiccaps_aspects contains "crowd talking"
This data as json, CSV (advanced)
musiccaps_aspects (array) 19 ✖
- clapping · 3 ✖
- crowd talking · 3 ✖
- low quality 3
- noisy 3
- mono 2
- bagpipe melody 1
- compilation 1
- electric guitar lick 1
- emotional 1
- exciting 1
- female vocal mumbling 1
- female vocals 1
- gospel 1
- groovy piano melody 1
- harmonizing female vocals 1
- passionate 1
- punchy kick 1
- romantic 1
- weird 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Fifth Harmony - Funny Moments 2015 | The low quality recording features a compilation of a few different recordings that mostly consist of female vocals talking with each other and a loud crowd talking in the background. However, in the first section, there are also some claps and female vocals mumbling a song. The arrangement of the recordings is weird, but in context it probably makes sense. | 2015-04-17T09:38:55Z | Shem | Twitter: https://twitter.com/normariekordei Fifth Harmony funny and crazy moments I don't own any of the clip in this video, I just put them together Hope you enjoyed ! | ["Music", "Pop music", "Clapping"] | ["low quality", "female vocals", "clapping", "crowd talking", "noisy", "compilation", "weird", "female vocal mumbling"] | 4 | fH9CY48sfJY | 3938 | |
Nigerian-American Wedding Gospel Music Recessional | The low quality recording features a gospel song that consists of harmonizing female vocals singing over groovy piano melody and some clapping. There are crowd talking noises in the background, while the recording is in mono and noisy. It sounds emotional, passionate and romantic - like something you would hear at weddings. | 2008-08-20T09:16:25Z | tdavidray | The wedding of the Barrow-Magnus-Lawson ceremony ended with a performance of the gospel song 'Oh Happy Day' by Edwin Hawkins. The pianist/tenor is Timothy Ray. Alto, Jasmine Perkins. Soprano, Marqueline Dejean. Lead, Patrice Parker. The wedding ceremony was held at the Second Free Mission Baptist Church in New Orleans, LA. | ["Music", "Wedding music", "Happy music"] | ["low quality", "mono", "noisy", "crowd talking", "gospel", "clapping", "harmonizing female vocals", "groovy piano melody", "passionate", "emotional", "romantic"] | 4 | sytdnmy0sRs | 4991 | |
The PowerPipes | The low quality recording features a bagpipe melody, layered with an electric guitar lick and followed by punchy kick hits. In the background there are some crowd talking noises and claps. It sounds exciting and the recording is noisy and in mono. | 2009-08-26T10:25:54Z | fVZD | TPP featuring at pan ulica fest špancirfest :D | ["Bagpipes", "Wind instrument, woodwind instrument"] | ["low quality", "bagpipe melody", "clapping", "punchy kick", "crowd talking", "mono", "noisy", "electric guitar lick", "exciting"] | 4 | yAvqiPL-ssU | 5390 |
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;