musiccaps_details (view)
2 rows where musiccaps_aspects contains "amateur recording", musiccaps_aspects contains "e-bass" and musiccaps_names contains "Brass instrument"
This data as json, CSV (advanced)
musiccaps_aspects (array) 13 ✖
- amateur recording · 2 ✖
- e-bass · 2 ✖
- acoustic drums 1
- acoustic guitar 1
- clarinet 1
- cuatro 1
- kids voice streaming 1
- medium to uptempo 1
- out of tune 1
- parody 1
- tambourine 1
- trumpets 1
- uptempo 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
AGK Angry German Kid vs Stacey Hedger-Star Wars Trumpet Solo | This audio contains an acoustic drum playing a groove along with a simple bassline. Trumpets are playing a melody that sounds out of tune and all over the place while a kids voice is streaming and you can hear some aggressive clicking sounds. This song may be playing for a parody video. | 2007-11-11T13:53:01Z | nexiva | Angry German Kid takes on his most talentless opponent yet: Stacey Hedger, from the infamous "Star Wars Trumpet Solo" pageant video. This continues the tradition of the AGK videos where fake english subtitles are overlayed the original vision, and intercut with a cult internet video. | ["Brass instrument", "Trumpet"] | ["amateur recording", "kids voice streaming", "trumpets", "acoustic drums", "e-bass", "out of tune", "parody", "medium to uptempo"] | 6 | -mB_XLq6g1g | 84 | |
Roda de Choro | Perigoso (Orlando Silveira) | Instrumental SESC Brasil | This audio contains someone playing a melody on a guitar in the midrange while someone else is strumming a melody on a cuatro in a higher key. Someone is playing a tambourine while a clarinet is playing a fast lead melody. This audio may be playing as a live concert. | 2010-10-07T06:12:32Z | Instrumental Sesc Brasil | A Roda de Choro nasceu na Virada Cultural de 2007, no Auditório Ibirapuera, sob organização de Danilo Brito. Desde sua criação, já aconteceu em diversos teatros e recebeu convidados como Carlos Malta, Laércio de Freitas, Toninho Ferragutti, Ricardo Herz, Danilo Brito, Alessandro Penezzi, Nelson Ayres, Oswaldinho do Acordeon e Gabriel Grossi, entre outros. No repertório, choros clássicos, passando por Pixinguinha, Jacob do Bandolim e algumas composições próprias. Formação: Alexandre Ribeiro - clarinete Léo Rodrigues - pandeiro Milton Mori - cavaquinho Luizinho 7 Cordas - violão 7 cordas Nelson Ayres - piano Toninho Ferragutii - acordeon Gênero: Choro Show que ocorreu no Teatro do Sesc Paulista dia 13/09/2010 • site oficial: http://instrumentalsescbrasil.org.br • assista aos shows ao vivo pelo http://facebook.com/sescsp Inscreva-se no canal http://www.youtube.com/sescsp e fique por dentro de toda a programação que acontece nas unidades do Sesc no estado de São Paulo. Basta ter uma conta gratuita no Google. | ["Brass instrument", "Clarinet"] | ["amateur recording", "acoustic guitar", "tambourine", "cuatro", "clarinet", "e-bass", "uptempo"] | 6 | 6uIOGE36tWo | 795 |
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;