musiccaps_details (view)
2 rows where musiccaps_aspects contains "average audio quality", musiccaps_aspects contains "groovy music" and musiccaps_aspects contains "live performance"
This data as json, CSV (advanced)
musiccaps_aspects (array) 44 ✖
- average audio quality · 2 ✖
- emotional 2
- groovy music · 2 ✖
- live performance · 2 ✖
- passionate 2
- ambient room noises 1
- country music 1
- cowboys 1
- echoes 1
- electric guitar 1
- epic stories 1
- fast guitar strumming 1
- fast tempo 1
- flamenco guitar 1
- folk music 1
- folk singer 1
- groovy 1
- groovy tempo 1
- guitar accompaniment 1
- guitar band 1
- guitar pick percussions 1
- guitar solo 1
- gunslingers 1
- heroes and villains 1
- instrumental music 1
- latin singer 1
- legends 1
- live audience 1
- male singer 1
- passionate music 1
- passionate singing 1
- rhythm guitars 1
- romantic 1
- scratching tones 1
- song covers 1
- spirited 1
- spirited singing 1
- story tellers 1
- street musician 1
- strings scratched with plectrum percussions 1
- suspense 1
- tense 1
- the wild west 1
- traditional latin music 1
musiccaps_names (array) 9 ✖
- Music 2
- Flamenco 1
- Guitar 1
- Musical instrument 1
- Plucked string instrument 1
- Singing 1
- Song 1
- Strum 1
- Vocal music 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 | |
Flamenco en la calle. Cáceres | A male singer sings this spirited Latin vocal. The song is fast tempo with slick guitar strumming and percussive guitar accompaniment. The song is romantic and steeped in rich Latin classical music traditions. The song is about a Latin street musician playing folk music. The recording is of average quality. | 2016-01-22T12:08:16Z | Antonio Lara Arco | En pleno casco antiguo de la ciudad... | ["Singing", "Flamenco", "Music", "Song", "Vocal music"] | ["male singer", "latin singer", "average audio quality", "fast tempo", "groovy tempo", "fast guitar strumming", "guitar accompaniment", "groovy music", "romantic", "emotional", "passionate", "spirited", "passionate singing", "spirited singing", "flamenco guitar", "live performance", "street musician", "passionate music", "traditional latin music", "folk singer", "folk music"] | 1 | Bx726MYz6Uo | 1306 |
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;