musiccaps_details (view)
3 rows where musiccaps_aspects contains "no instruments" and musiccaps_names contains "A capella"
This data as json, CSV (advanced)
musiccaps_aspects (array) 34 ✖
- no instruments · 3 ✖
- acapella 2
- alto 2
- amateur recording 2
- male voices 2
- slow tempo 2
- angelic 1
- bass 1
- celestial 1
- choir 1
- choral harmony 1
- christian hymn 1
- ethereal 1
- female singer 1
- female voices 1
- harmonious 1
- high notes 1
- inferior audio quality 1
- mediocre sound recording 1
- melodic 1
- no lyrics 1
- quality of 1
- romantic theme 1
- rustling 1
- scuffling 1
- seconds 1
- soprano 1
- soprano voices 1
- sound of chatter 1
- tenor 1
- vocables 1
- vocal harmony 1
- vocal vibrations 1
- whirring sound 1
musiccaps_names (array) 6 ✖
- A capella · 3 ✖
- Vocal music 2
- Christian music 1
- Gospel music 1
- Music 1
- Singing 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Fill the World With Love 6-09 | A female vocalist sings this mellifluous song.The tempo is slow with the vocalist singing a soprano, with alto choral harmony. There are sounds of rustling, whirring,scuttling and people talking in the background. The vocals are beautiful, mellifluous,and ethereal. | 2009-06-07T23:08:18Z | noodlebrain500 | Fill the World With Love 6-09 | ["Music", "Vocal music", "A capella"] | ["female singer", "high notes", "choral harmony", "ethereal", "vocal vibrations", "ethereal", "soprano", "alto", "whirring sound", "seconds", "melodic", "angelic", "celestial", "no instruments", "sound of chatter", "rustling", "scuffling", "harmonious", "amateur recording", "mediocre sound recording", "inferior audio quality", "quality of"] | 7 | -YIT4HBM__g | 61 | |
Deus mesmo revelou (Novo céu) | This song features a choir singing a Christian hymn. The voices sing one note followed by a higher note followed by a descending pattern. The female voices sing the soprano and alto voices. The male voices sing tenor and bass parts. There are no instruments in this song. This song is an acapella song. This song can be played in a church. | 2008-09-09T22:42:06Z | JC.areas | coral da casa de oração de Menino Jesus | ["Singing", "Gospel music", "Christian music", "A capella"] | ["choir", "male voices", "female voices", "christian hymn", "acapella", "no instruments", "slow tempo", "bass", "alto", "tenor", "soprano voices"] | 0 | bkXrQyDbKtk | 3645 | |
Bon Iver - For Emma A cappella | This song features a pop song being sung by male voices in acapella . The voices sing the different parts of a choir. They are singing vocables and not words. The voices sing in harmony. Voices are singing the bass; alto and tenor parts. The mood of this song is romantic. This is an amateur recording. This song can be played in a romantic movie. | 2010-02-16T16:53:38Z | mghadiri | All male a cappella group G-Tones at Grinnell College singing Bon Iver - For Emma for our Haiti benefit concert. | ["Vocal music", "A capella"] | ["amateur recording", "acapella", "male voices", "vocal harmony", "no instruments", "slow tempo", "vocables", "no lyrics", "romantic theme"] | 0 | qwz7oLASJqg | 4837 |
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;