musiccaps_details (view)
2 rows where musiccaps_names contains "A capella" and musiccaps_names contains "Classical music" sorted by video
This data as json, CSV (advanced)
musiccaps_aspects (array) 19 ✖
- accordion 1
- cheerful 1
- cover 1
- emotional 1
- female singing quarter 1
- happy 1
- harmonies 1
- harmonizing male vocals 1
- live performance 1
- live recording 1
- low quality 1
- noisy 1
- passionate male vocal 1
- phone recording 1
- poor audio quality 1
- simple acoustic guitar chords 1
- upbeat 1
- vintage european 1
- violins 1
musiccaps_names (array) 6 ✖
- A capella · 2 ✖
- Classical music · 2 ✖
- Music 2
- Bowed string instrument 1
- Musical instrument 1
- Violin, fiddle 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 | |
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;