musiccaps_details (view)
3 rows where musiccaps_aspects contains "cowboys" and musiccaps_aspects contains "spirited"
This data as json, CSV (advanced)
musiccaps_aspects (array) 64 ✖
- cowboys · 3 ✖
- spirited · 3 ✖
- emotional 2
- adrenaline rush 1
- ambient crowd noise 1
- auto harp 1
- banjo 1
- brass instruments harmony 1
- building anticipation 1
- catchy 1
- child singer 1
- country music 1
- country pop 1
- country side 1
- cymbals crashing 1
- drums playing loud in march style 1
- enthusiastic 1
- enthusiastic drumming 1
- fast tempo 1
- female singer 1
- fiddle 1
- folk music 1
- girl singing 1
- happy 1
- hero’s march 1
- instrumental music 1
- keyboard harmony 1
- latin brass band 1
- latin country music 1
- latin folk music 1
- latin music 1
- lawmen 1
- male bravado 1
- mandolin 1
- march like beat 1
- movie soundtrack 1
- ominous 1
- passionate 1
- people clapping 1
- people talking 1
- peppy 1
- powerful vocals 1
- powerfully voice 1
- regional music 1
- resonator 1
- romantic 1
- school concert 1
- sentimental 1
- sheriff 1
- slow tempo 1
- steady bass line 1
- story telling 1
- suspense 1
- tambourine beats 1
- traditional 1
- trumpet section plays triumphantly 1
- trumpets blaring 1
- tulna is playing loud 1
- vibrant 1
- vocal emphasis 1
- western movie 1
- yodelling music 1
- young vocalist 1
- youthful 1
musiccaps_names (array) 7 ✖
- Music 3
- Musical instrument 1
- Singing 1
- Song 1
- Timpani 1
- Vocal music 1
- Yodeling 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
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 | |
cutie girl singing (11 years old) | A young female vocalist sings this upbeat country song. The tempo is fast with keyboard harmony,enthusiastic drumming , rhythmic accompaniment of acoustic guitar, mandolin, fiddle, resonator, auto harp and dobro and tambourine beats. The song is fresh, youthful, energetic, vivacious, catchy, upbeat, simple and peppy. This song is Country Pop. | 2006-07-16T08:08:14Z | Trofimo | El origen de la Humanidad (la infancia) puede descubrirnos el origen de la música... | ["Yodeling", "Music", "Song"] | ["female singer", "fast tempo", "girl singing", "young vocalist", "peppy", "enthusiastic", "auto harp", "folk music", "regional music", "country side", "cowboys", "catchy", "country music", "country pop", "march like beat", "powerfully voice", "people clapping", "enthusiastic drumming", "fiddle", "mandolin", "resonator", "banjo", "tambourine beats", "youthful", "happy", "sentimental", "story telling", "powerful vocals", "vocal emphasis", "keyboard harmony", "spirited", "vibrant"] | 7 | hdlnugbWjKA | 4122 |
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;