musiccaps_details (view)
4 rows where musiccaps_aspects contains "amateur recording", musiccaps_aspects contains "instrumental", musiccaps_author = 0 and musiccaps_names contains "Musical instrument"
This data as json, CSV (advanced)
musiccaps_aspects (array) 25 ✖
- amateur recording · 4 ✖
- instrumental · 4 ✖
- moderate tempo 3
- no voices 3
- blues melody 2
- simple percussion 2
- accordion 1
- banjo 1
- bass 1
- blues bassline 1
- demo audio 1
- electric guitar 1
- folk song 1
- happy mood 1
- instructional audio 1
- no other instruments 1
- no voice 1
- overdriven guitar 1
- piano notes 1
- rock song 1
- slow tempo 1
- tambourine 1
- triangle 1
- vibrato 1
- violins 1
musiccaps_names (array) 13 ✖
- Music 4
- Musical instrument · 4 ✖
- Electric guitar 2
- Guitar 2
- Plucked string instrument 2
- Accordion 1
- Banjo 1
- Blues 1
- Bowed string instrument 1
- Effects unit 1
- Reverberation 1
- Tapping (guitar technique) 1
- Traditional music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
DOMINGUINHOS: VOZ, SANFONA E HISTÓRIAS DE VIDA | This folk song features an accordion playing the main melody. Another accordion plays a backing melody and chords. The bass plays a groovy lick based around the root note of the chord. A triangle plays the part of the percussion. This is a low quality audio and the percussion is not audible. This song can be played in a village fair. | 2013-08-04T16:20:08Z | MACÍLIO GOMES | Imagens cedidas pela TV Ceará Canal 5, de especial gravado com Dominguinhos para o programa Ceará Caboclo, apresentado aos domingos (10h) pelo nosso amigo Dilson Pinheiro, reprisado em 28/07/2013, em homenagem póstuma a um dos maiores sanfoneiros do Brasil (senão o maior). Músico nato virtuoso, cantor e compositor, mundialmente conhecido, querido e respeitado por todos. Conhecido como o pai dos sanfoneiros, pelos quais era reverenciado, mestre dos mestres, sua humildade e simplicidade eram do tamanho de sua grandeza. Dominguinhos fala de suas origens, da infância simples e humilde; das primeiras letras; do início da carreira; como conheceu Luiz Gonzaga. Na qualidade de mestre da sanfona, repassa lições de ritmo, a diferença da batida do baião e do forró. E por aí vai... | ["Traditional music", "Music", "Musical instrument", "Accordion"] | ["folk song", "accordion", "no voices", "triangle", "bass", "instrumental", "amateur recording", "moderate tempo"] | 0 | AJTU5RhF3S4 | 1102 | |
Classical Gas by Roy Clark Band Banjo Pickin' 1987 Live | This amateur recording features a rock song. The main melody is played on violins. This is accompanied by percussion playing with breaks matching the breaks in the violin parts. At the end, the violins play a sustained note and a banjo starts to play a melody. A tambourine is played on the first count of the second bar after the banjo starts to play. This is an uptempo song and has a happy feel. This instrumental song can be played in a coffee shop. | 2007-06-12T06:30:56Z | NelnetDude | Enjoy! | ["Banjo", "Music", "Musical instrument", "Bowed string instrument"] | ["amateur recording", "rock song", "instrumental", "no voices", "violins", "banjo", "tambourine", "simple percussion", "happy mood", "moderate tempo"] | 0 | MpWGx5odhh8 | 2301 | |
Fender Deluxe Reverb '65 Reissue Cranked up a bit! | This amateur recording features an overdriven guitar playing the main melody. This is a low quality recording and the volumes of the instruments are not professionally mixed. The overdriven guitar is loud. A piano plays a couple of notes in the beginning. The guitar is accompanied by percussion playing a simple beat in the background. The bass plays a blues style bassline. The tempo of this song is slow. The song is based on blues style. | 2012-08-01T12:50:32Z | Sam Rhodes | Just using my Gibson 339 into a Fender Deluxe Reverb Reissue turned up to 7 with a Dr Z Brake Lite on 4. | ["Reverberation", "Tapping (guitar technique)", "Effects unit", "Electric guitar", "Guitar", "Music", "Musical instrument", "Plucked string instrument"] | ["amateur recording", "blues melody", "overdriven guitar", "vibrato", "blues bassline", "simple percussion", "slow tempo", "no voice", "instrumental", "piano notes"] | 0 | Qe71m678qEU | 2632 | |
Fender Blues Jr. with Clean Sound - Demo - Blues Junior | This song features an electric guitar. The guitar starts off with a descending pentatonic run. A descending slide is played followed by a moderate tempo blues lick. There are no other instruments in this song. There is no voice in this song. This is an instrumental song with a blues mood. This song can be played as an instructional blues song. | 2009-03-23T05:35:56Z | JVStratocasters | More info of JV (Japan Vintage) Stratocasters (1982~1984) at http://www.youtube.com/jvs30thanniversary (My new channel, please subscribe!) Questions? Feel free to email me at jvstratocasters@yahoo.com Fender Japan - Squier Logo JV Stratocaster 1983 - 2TS Fender Blues Jr. Amp - Blues Junior Strings - Dean Markley 10-46 | ["Blues", "Electric guitar", "Guitar", "Music", "Musical instrument", "Plucked string instrument"] | ["electric guitar", "amateur recording", "blues melody", "no other instruments", "demo audio", "instructional audio", "no voices", "instrumental", "moderate tempo"] | 0 | vyNstX5b1V8 | 5223 |
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;