musiccaps_details (view)
4 rows where musiccaps_aspects contains "cover" and musiccaps_names contains "A capella"
This data as json, CSV (advanced)
musiccaps_aspects (array) 21 ✖
- cover · 4 ✖
- low quality 4
- noisy 4
- passionate 3
- emotional 2
- harmonizing male vocals 2
- mono 2
- pop 2
- "4 on the floor" kick 1
- acapella 1
- beatboxing 1
- energetic 1
- fun 1
- harmonizing female choir vocals 1
- harmonizing mixed vocals 1
- loud shoe tapping 1
- passionate male vocal 1
- phone recording 1
- rock 1
- roomy 1
- simple acoustic guitar chords 1
musiccaps_names (array) 8 ✖
- A capella · 4 ✖
- Choir 2
- Music 2
- Singing 2
- Classical music 1
- Song 1
- Tap 1
- Vocal music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
The Banana Boat Song ukulele cover with chords and lyrics - Harry Belafonte style (hopefully).wmv | The low quality recording features a cover of a song and it consists of passionate male vocals that together with the actual song's vocal, sounds harmonizing. There are simple acoustic guitar chords too. The recording is very noisy as it was probably recorded with a phone, but regardless it sounds emotional. | 2012-07-30T15:21:15Z | raffaport | Some calypso fun from a bygone age ... too piercing, man! | ["Music", "Classical music", "A capella"] | ["low quality", "cover", "harmonizing male vocals", "simple acoustic guitar chords", "emotional", "noisy", "phone recording", "passionate male vocal"] | 4 | BfMKdrK9D8M | 1272 | |
Surrey Harmony - Bohemian Rhapsody | The low quality recording features a cover of a rock song sung by harmonizing female choir vocals. The recording is noisy, in mono and it sounds emotional and passionate. | 2008-07-02T11:24:33Z | Emma Riley | Surrey Harmony's Barbershop version of Bohemian Rhapsody, sung in the Sweet Adelines Region 31 Showcase, May 2008. | ["Singing", "Song", "Choir", "A capella"] | ["low quality", "harmonizing female choir vocals", "emotional", "passionate", "noisy", "mono", "cover", "rock"] | 4 | FHC7gN3NnX8 | 1633 | |
Eternal Sound - Save the World/Don't You Worry Child (Pentatonix cover) | The low quality recording features an Acapella cover of a pop song and it consists of harmonizing mixed vocals singing and some beatboxing that mimics "4 on the floor" kick pattern. The recording is noisy and it sounds a bit roomy, since it was probably recorded with a phone. It sounds passionate and fun. | 2013-11-16T20:34:04Z | Eternal Sound | соло - Марина Лабунец | ["Music", "A capella"] | ["low quality", "beatboxing", "\"4 on the floor\" kick", "harmonizing mixed vocals", "pop", "cover", "fun", "passionate", "noisy", "roomy", "acapella"] | 4 | RVlXLa80vcE | 2708 | |
UC Men's Octet - Bohemian Rhapsody | The low quality recording features a cover of a pop song and it consists of harmonizing male vocals and loud shoe tapping that serves as a rhythm. The recording is in mono and very noisy, as it was probably recorded with a phone. It sounds passionate and energetic - even without the instruments. | 2006-02-25T06:59:48Z | sv02 | UC Berkeley Men's Octet at UC Choral Ensemble's Annual A Cappella For AIDS 2006 (originally from Fall Show set 2005) | ["Singing", "Tap", "Choir", "Vocal music", "A capella"] | ["low quality", "loud shoe tapping", "harmonizing male vocals", "pop", "cover", "noisy", "mono", "passionate", "energetic"] | 4 | XWhmLbnrtd0 | 3190 |
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;