musiccaps_details (view)
3 rows where musiccaps_aspects contains "echoes" and musiccaps_aspects contains "live performance"
This data as json, CSV (advanced)
musiccaps_aspects (array) 64 ✖
- echoes · 3 ✖
- instrumental music 3
- live performance · 3 ✖
- live audience 2
- medium tempo 2
- passionate 2
- amateur recording 1
- ambient noises 1
- ambient room noises 1
- angelic 1
- average audio quality 1
- awe 1
- bad audio quality 1
- brent nature sounds 1
- christmas 1
- country music 1
- cowboys 1
- dance rhythm 1
- demonstration 1
- drum solo 1
- drums maestro 1
- electric guitar 1
- emotional 1
- energetic 1
- epic stories 1
- ethereal tones 1
- exciting 1
- exemplary stick work 1
- gong 1
- gripping experience 1
- groovy 1
- groovy music 1
- groovy rhythm 1
- guitar band 1
- guitar pick percussions 1
- guitar solo 1
- gunslingers 1
- heavenly 1
- heroes and villains 1
- impressive playing 1
- legends 1
- nostalgia 1
- outdoors 1
- overtones 1
- playing different notes 1
- pulsating experience 1
- pulsating tones 1
- quartzophone 1
- quartzophonist 1
- retro drum hits 1
- rhythm guitars 1
- romantic 1
- scratching tones 1
- song covers 1
- story tellers 1
- strings scratched with plectrum percussions 1
- suspense 1
- syncopated rhythms 1
- technique 1
- tense 1
- the wild west 1
- vibrato 1
- virtuoso 1
- wonder 1
musiccaps_names (array) 14 ✖
- Bass drum 1
- Cowbell 1
- Drum 1
- Drum kit 1
- Guitar 1
- Harp 1
- Music 1
- Musical instrument 1
- Percussion 1
- Pizzicato 1
- Plucked string instrument 1
- Rimshot 1
- Snare drum 1
- Strum 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
The Good, the Bad and the Ugly / Reel Matawa by California Guitar Trio & Montreal Guitar Trio | The song is an instrumental. The song is medium tempo with a guitar playing lead and several guitarists playing harmony and accompaniment and a pick scratching guitar strings producing a percussive line. The song is immersive and has a classic country gun fight duel vibe to it. The song has ambient room noises. | 2009-11-19T18:55:29Z | MG3 : Montréal Guitare Trio / Montreal Guitar Trio | Montreal Guitar Trio & California Guitar Trio performed The Good, the Bad and the Ugly by Ennio Morricone followed by the Reel Matawa by Richard Forest at Palais Montcalm in Quebec City, October 23, 2009. | ["Guitar", "Music", "Musical instrument", "Strum", "Plucked string instrument"] | ["guitar band", "guitar solo", "scratching tones", "guitar pick percussions", "song covers", "strings scratched with plectrum percussions", "live performance", "live audience", "ambient room noises", "echoes", "average audio quality", "groovy music", "instrumental music", "country music", "tense", "suspense", "gunslingers", "groovy", "story tellers", "the wild west", "emotional", "passionate", "heroes and villains", "legends", "epic stories", "electric guitar", "rhythm guitars", "cowboys"] | 1 | 3w3fD54bNvU | 521 | |
Ascension sur le Quartzophone H1 (harpe) / Ascension on the Quartzophone H1 (harp) | The song is an instrumental. The tempo is medium with a quartzophone being played delicately by an expert producing ethereal pulsating tones of music. The song is emotional and beautiful. The audio quality with ambient nature sounds. | 2012-08-18T16:04:19Z | Mine Cristal | Gaudry Normand plays an original composition on the Quartzophone® H1 (harp). This unique instrument was invented by Mr. Normand, and is the result of 12 years of research and development. The Quartzophone instruments have a cristaline sound which is unique and heavenly! Made by hand at our workshop at Mine Cristal, the Quartzophone instruments have pure quartz crystal tubes (99.9% silica or SiO2). Now available at www.quartzophone.com. ©Gaudry Normand 2012 Gaudry Normand joue une composition originale sur la Quartzophone® H1 (harpe). Le design unique des instruments Quartzophone sont signés Gaudry Normand. Ces nouveaux instruments sont le fruit de plus de douze années de recherche et de développement. Elles ont le son cristallin et le timbre tout à fait unique. Fabriqués à la main avec des tubes de cristal de quartz pur à 99.9 % de silice (SiO2). Offerts à Mine Cristal, Bonsecours, Québec, Canada. Visitez notre site internet à www.Quartzophone.com. ©Gaudry Normand 2012 | ["Harp", "Pizzicato"] | ["quartzophone", "quartzophonist", "instrumental music", "ambient noises", "gong", "playing different notes", "pulsating tones", "vibrato", "echoes", "brent nature sounds", "live performance", "outdoors", "demonstration", "heavenly", "angelic", "overtones", "medium tempo", "passionate", "nostalgia", "romantic", "awe", "wonder", "christmas", "technique", "virtuoso", "ethereal tones"] | 1 | lDGQu122JdU | 4383 | |
Drums Steve Gadd Cowbell.wmv | The song is an instrumental. The tempo is medium with a maestro percussionist performing a solo drum solo in front of a live audience. The song is exciting and gripping. The audio quality is poor. | 2008-12-16T11:27:34Z | bestdrumvideos | Drums Steve Gadd | ["Cowbell", "Drum", "Drum kit", "Rimshot", "Snare drum", "Bass drum", "Percussion"] | ["drum solo", "live performance", "live audience", "gripping experience", "instrumental music", "echoes", "syncopated rhythms", "drums maestro", "impressive playing", "energetic", "medium tempo", "groovy rhythm", "bad audio quality", "amateur recording", "exciting", "pulsating experience", "exemplary stick work", "retro drum hits", "dance rhythm"] | 1 | nrj2zTr7U0o | 4584 |
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;