musiccaps_details (view)

3 rows where musiccaps_aspects contains "acoustic guitar" and musiccaps_names contains "Brass instrument"

✎ View and edit SQL

This data as json, CSV (advanced)

video youtube_link musiccaps_caption youtube_published youtube_channel youtube_description musiccaps_names musiccaps_aspects musiccaps_author youtube_id musiccaps_rowid
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
Coldplay - Hurts like Heaven (cover) This audio contains someone playing an acoustic piano along with an acoustic guitar strumming chords. Someone is playing a cajon with a fast paced groove and a tambourine. A horn takes the main melody in the midrange along with a male voice singing in a higher key. This song may be playing on the streets performed by buskers. 2012-02-10T14:22:31Z Retalianist Here's our latest cover, this time it's Hurts like Heaven by Coldplay and we brought the brass! It was rehearsed and shot in a couple of hours. Singing is too low but... enjoy anyway! Sheet Music : http://on.fb.me/13Y9f2G Shot and directed by Charlotte Audureau http://www.shuud.book.fr/ With Romain Olivieri, Nicolas Molac, Edward Vizard, Clément Charpentier-Leroy, Gautier Demollière and Pierre Lesmarie http://www.weareelessar.com http://www.myspace.com/astrazz ["Brass instrument", "French horn"] ["pop", "acoustic piano", "cajon", "horn", "acoustic guitar", "male voice singing", "tambourine", "uptempo"] 6 QDTCAxyXt80 2605
6 WHITE BOOMERS 2013 This song contains a piano playing short rhythmic chords along with an acoustic guitar and an upright bass playing the same melody. A brass melody is opening the scene. sound A male voice is singing in a higher register. This song may be playing while celebrating with the whole family on a national holiday. 2014-11-25T23:03:53Z Snapshot 21st Century   ["Brass instrument", "Trumpet"] ["country", "acoustic guitar", "piano", "acoustic drums", "upright bass", "male voice singing", "higher key", "brass", "uptempo", "uplifting energy"] 6 Qu76GhRO9Yk 2648

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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;