musiccaps_details (view)
3 rows where musiccaps_aspects contains "cowboys" and musiccaps_author = 1
This data as json, CSV (advanced)
musiccaps_aspects (array) 57 ✖
- cowboys · 3 ✖
- emotional 3
- instrumental music 2
- passionate 2
- spirited 2
- suspense 2
- adrenaline rush 1
- ambient crowd noise 1
- ambient room noises 1
- average audio quality 1
- brass instruments harmony 1
- building anticipation 1
- child singer 1
- country music 1
- cymbals crashing 1
- drums playing loud in march style 1
- echoes 1
- electric guitar 1
- epic stories 1
- groovy 1
- groovy music 1
- guitar band 1
- guitar pick percussions 1
- guitar solo 1
- gunslingers 1
- heroes and villains 1
- hero’s march 1
- latin brass band 1
- latin country music 1
- latin folk music 1
- latin music 1
- lawmen 1
- legends 1
- live audience 1
- live performance 1
- male bravado 1
- movie soundtrack 1
- ominous 1
- people talking 1
- rhythm guitars 1
- romantic 1
- school concert 1
- scratching tones 1
- sheriff 1
- slow tempo 1
- song covers 1
- steady bass line 1
- story tellers 1
- strings scratched with plectrum percussions 1
- tense 1
- the wild west 1
- traditional 1
- trumpet section plays triumphantly 1
- trumpets blaring 1
- tulna is playing loud 1
- western movie 1
- yodelling music 1
musiccaps_names (array) 8 ✖
- Music 3
- Musical instrument 2
- Guitar 1
- Plucked string instrument 1
- Singing 1
- Strum 1
- Timpani 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 | |
Sebastien De La Cruz, EL CHARRO DE ORO, EL PASTOR | A child singer sings this passionate Latin melody. The song is slow tempo with steady drumming, tambourine percussions, a strong bass line and brass instruments playing countermelody. The song is spirited and passionate. The song has poor audio quality and has ambient crowd noises. | 2009-12-04T04:56:07Z | Juan De La Cruz | MARIACHI VARGAS EXTRAVAGANZA 2009 EL PASTOR, 7YR OLD WOW, THIRD PLACE VOCAL FINALIST | ["Singing", "Music", "Musical instrument", "Vocal music"] | ["child singer", "latin music", "ambient crowd noise", "steady bass line", "cymbals crashing", "people talking", "trumpets blaring", "school concert", "latin folk music", "latin folk music", "traditional", "cowboys", "latin country music", "yodelling music", "spirited", "passionate", "romantic", "emotional", "brass instruments harmony", "slow tempo", "latin brass band"] | 1 | 6C0HoQe4Y-Y | 734 | |
Tombstone (1993) - Main movie teme | The song is an instrumental. The song is medium tempo with drums playing in march style and a brass section plays this triumphant harmony. The song is spirited and gives an adrenaline rush. The song is a western movie soundtrack with an average sound quality. | 2011-09-17T14:27:00Z | LittleDrinkerRu | Music by Bruce Broughton | ["Timpani", "Music"] | ["movie soundtrack", "western movie", "male bravado", "adrenaline rush", "cowboys", "sheriff", "lawmen", "drums playing loud in march style", "trumpet section plays triumphantly", "emotional", "spirited", "instrumental music", "ominous", "suspense", "building anticipation", "hero’s march", "tulna is playing loud"] | 1 | 6Yh7Cdm2GgY | 767 |
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;