musiccaps_details (view)
4 rows where musiccaps_names contains "A capella" and musiccaps_names contains "Song"
This data as json, CSV (advanced)
musiccaps_aspects (array) 26 ✖
- emotional 2
- low quality 2
- mono 2
- noisy 2
- passionate 2
- slow tempo 2
- acoustic drums 1
- acoustic guitar 1
- acoustic guitars 1
- ballad 1
- cover 1
- crowd singing 1
- folklore 1
- fruity male vocal 1
- harmonizing female choir vocals 1
- joyful 1
- live performance 1
- lower to mid-range voices 1
- male choir singing 1
- melodic singing 1
- passionate harmonizing choir vocals 1
- pop music 1
- rock 1
- spanish 1
- teen female vocal 1
- traditional 1
musiccaps_names (array) 9 ✖
- A capella · 4 ✖
- Song · 4 ✖
- Music 3
- Choir 2
- Gospel music 2
- Singing 2
- Chant 1
- Christmas music 1
- Mantra 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Invencible/Music Club de Vázquez Sounds | This is a live performance of a pop music piece. There is a teenage female vocalist singing melodically in the Spanish language. An acoustic guitar plays the main tune while there is a slow tempo acoustic drum beat in the rhythmic background. The spectators are joining the song at a volume that is sometimes higher than the song itself and it creates an irritating aura. | 2014-09-29T02:14:40Z | Vázquez Sounds Support Mexico | Nuestras redes sociales: Facebook: http://bitly.com/1rW5VpV Youtube: http://bitly.com/1vpC2gw Instagram: http://bit.ly/1oHYlJB Twitter: http://bitly.com/1yEsrar Ask: http://bit.ly/1CKk6AM {Grabado por nosotros} Club de fans oficial. Vazquez Sounds en vivo (Live) | ["Singing", "Music", "Song", "A capella"] | ["live performance", "pop music", "ballad", "teen female vocal", "melodic singing", "acoustic guitar", "acoustic drums", "crowd singing", "emotional", "slow tempo", "spanish"] | 9 | BaMBwXQwK3g | 1263 | |
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 | |
GASP Monumental Serenata de Portalegre | Acoustic guitars are playing chords, tremolos and melodies while a male choir is singing the same melody along. This song may be playing at a folkfest. | 2009-11-06T23:08:07Z | Grupo Académico Serenatas de Portalegre | Monumental Serenata da Semana Académica de Portalegre O Grupo Académico de Serenatas de Portalegre foi fundado na década de noventa, por alguns elementos que pertenciam à Tuna Papasmisto ( Tuna mista do Politécnico de Portalegre ). Aquando do casamento de um casal de elementos da referida tuna, alguns elementos masculinos da mesma, querendo oferecer uma prenda especial ao casal, reuniam após os ensaios para ensaiar a referida prenda. Devido à qualidade desses ensaios, que ultrapassaram todas as expectativas dos tunos, iniciaram-se então as conversações com vista à formação Grupo Académico de Serenatas de Portalegre. Fundado na famosa casa nº 140 da Rua da Mouraria, na altura casa de Paulo Silva, aluno do 1º ano de Matemática e Ciências, foi marcada uma reunião onde foram discutidas as linhas mestras que regem ainda o hoje o grupo, fundado com o intuito de preencher uma lacuna existente na academia Portalegrense. Desde então o grupo continua a exercer as suas actividades até aos dias de hoje, desejando que o espírito académico se prolongue por muitos e muitos anos, através de uma renovação constante de novos elementos e novas mentalidades, sem nunca destorcer o verdadeiro significado do espírito de serenata. Para além da participação em várias semanas académicas e eventos em que o espírito de serenata se adeqúe, o Grupo Académico de Serenatas de Portalegre preza ainda pela continuidade da sua tradição de actuações nocturnas pelas ruas da cidade de Portalegre de janela em janela. | ["Christmas music", "Gospel music", "Mantra", "Chant", "Music", "Song", "A capella"] | ["folklore", "male choir singing", "lower to mid-range voices", "acoustic guitars", "slow tempo"] | 6 | Tp8PG2xae8c | 2867 | |
UNAM Choir - Ba Nyorilweng (Song of Prayer) | The low quality recording features passionate harmonizing choir vocals, alongside fruity male vocals. It sounds passionate, traditional and joyful. The recording is noisy and in mono. | 2011-12-02T23:42:18Z | GT Choir Ongwediva | The UNAM (University of Namibia) Choir performing at the UNAM Northern Campus during the October 2011 Northern Namibia Choral Extravaganza. | ["Gospel music", "Music", "Song", "Choir", "A capella"] | ["low quality", "mono", "noisy", "passionate harmonizing choir vocals", "fruity male vocal", "traditional", "joyful", "passionate"] | 4 | rizanOQM61k | 4897 |
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;