musiccaps_details (view)
3 rows where musiccaps_aspects contains "mandolin" and musiccaps_names contains "Song"
This data as json, CSV (advanced)
musiccaps_aspects (array) 58 ✖
- fiddle 3
- mandolin · 3 ✖
- enthusiastic 2
- fast tempo 2
- people clapping 2
- resonator 2
- spirited 2
- acoustic guitar 1
- ambient nature sounds 1
- american folk 1
- auto harp 1
- banjo 1
- bass guitar 1
- bluegrass 1
- breeze 1
- catchy 1
- cheering 1
- country music 1
- country pop 1
- country side 1
- cowboys 1
- cozy 1
- dobro 1
- energetic 1
- energetic vocals 1
- enthusiastic drumming 1
- falsetto 1
- female singer 1
- female vocalist 1
- folk music 1
- friendly 1
- girl singing 1
- happy 1
- high notes 1
- joyful 1
- keyboard harmony 1
- male vocals 1
- march like beat 1
- melodic singing 1
- normal voice to falsetto 1
- nostalgic 1
- peppy 1
- powerful vocals 1
- powerfully voice 1
- rapid change in pitch 1
- rapid singing 1
- regional music 1
- sentimental 1
- spirited drumming 1
- steady tempo 1
- story telling 1
- tambourine beats 1
- vibrant 1
- vigorous banjo accompaniment 1
- vocal emphasis 1
- vocalisation 1
- young vocalist 1
- youthful 1
youtube_published (date) 3 ✖
- 2006-07-16 1
- 2008-08-12 1
- 2014-02-20 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Lydia 5 yrs.old wins the Taylor Ware Yodel On Contest!! | A female vocalist sings this rather vigorous country song. The tempo is fast with vocalisation. The vocalist is yodelling vigorously and rhythmically to the accompaniment of an animated banjo, fiddle, resonator and mandolin harmony, vibrant drumming and. | 2008-08-12T02:50:34Z | Epps Music | Lydia yodeling Cowboy Sweetheart at Taylor Ware's Yodel On Contest in Tenn. | ["Singing", "Yodeling", "Music", "Song"] | ["female vocalist", "fast tempo", "falsetto", "high notes", "resonator", "people clapping", "cheering", "breeze", "ambient nature sounds", "energetic vocals", "spirited drumming", "vigorous banjo accompaniment", "mandolin", "fiddle", "dobro", "rapid singing", "energetic", "vocalisation", "spirited", "enthusiastic", "normal voice to falsetto", "rapid change in pitch"] | 7 | GuQFhmGqdog | 1760 | |
Paradise - Jim and Jesse McReynolds - High Lonesome: The Story of Bluegrass Music | This is a bluegrass music piece. Two male vocals are singing melodically in the lead. The tune is played by a rich chordophone background composed of the fiddle, the mandolin and the acoustic guitar. The atmosphere of the piece is joyful and nostalgic. It has a steady tempo. The piece could be used in the soundtrack of a movie or a TV series taking place in rural USA, especially in the scenes where there is some sense of yearning. It could be playing in the background at an American diner or a bar. | 2014-02-20T00:24:23Z | CMH Records | Paradise by Jim and Jesse McReynolds on CMH Records' High Lonesome: The Story of Bluegrass Music -- Available Now at CMH Records, iTunes, and Amazon!!! CMH Records: http://www.cmhrecords.com/web/page.as... iTunes: https://itunes.apple.com/us/album/hig... Amazon: http://www.amazon.com/High-Lonesome-S... Also be sure to connect with us on… Facebook: https://www.facebook.com/PickinOnSeries/ Instagram: https://www.instagram.com/cmhrecords/ Twitter: https://twitter.com/PickinOnSeries Pinterest: https://www.pinterest.com/cmhrecords/ Tumblr: http://cmhrecords.tumblr.com | ["Music of Africa", "Country", "Music", "Song"] | ["bluegrass", "american folk", "male vocals", "melodic singing", "mandolin", "fiddle", "acoustic guitar", "bass guitar", "joyful", "cozy", "friendly", "nostalgic", "steady tempo"] | 9 | ZiHlhUvmgzQ | 3406 | |
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;