musiccaps_details (view)
4 rows where musiccaps_aspects contains "bass guitar", musiccaps_aspects contains "mandolin" and musiccaps_author = 9
This data as json, CSV (advanced)
musiccaps_aspects (array) 36 ✖
- bass guitar · 4 ✖
- mandolin · 4 ✖
- acoustic guitar 3
- bluegrass 2
- melodic singing 2
- acoustic drums 1
- adventurous 1
- american folk 1
- banjo 1
- country music 1
- cover 1
- cozy 1
- easygoing 1
- eccentric 1
- emotional 1
- female vocal 1
- fiddle 1
- friendly 1
- inspiring 1
- instrumental 1
- joyful 1
- male vocal 1
- male vocals 1
- medium tempo 1
- medium-to-high pitch singing 1
- movie music 1
- no singer 1
- nostalgic 1
- orchestra 1
- playful 1
- rural 1
- steady tempo 1
- touching 1
- ukulele 1
- video game music 1
- western music 1
musiccaps_names (array) 10 ✖
- Music 4
- Country 3
- Bluegrass 1
- Flamenco 1
- Music of Africa 1
- Pop music 1
- Psychedelic rock 1
- Rock music 1
- Salsa music 1
- Song 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Academy of Country Music Awards - Road to ACM Award - Band Perry Takes Vegas! | This is a country music piece. There is a female vocalist singing melodically as the lead at a medium-to-high range. A mandolin is playing the main theme while being backed by a bass guitar. The rhythmic background consists of a simple 4/4 acoustic drum beat. | 2011-04-03T18:39:30Z | CBS | Follow The Band Perry as they take on Vegas! Tune into the ACM Awards Sunday, April 3 at 8/7c | ["Country", "Music", "Psychedelic rock", "Pop music", "Rock music"] | ["country music", "female vocal", "medium-to-high pitch singing", "mandolin", "acoustic drums", "bass guitar", "touching", "emotional", "inspiring", "medium tempo"] | 9 | 2OI4QeokeRQ | 360 | |
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 | |
fuel - in bluegrass style - iron horse | This is a bluegrass cover of an originally heavy metal music piece. There is a male vocalist singing melodically in the lead. The tune is being played by the banjo, the mandolin and the acoustic guitar while the bass guitar is playing in the background. The atmosphere is playful and there is a rural feel to the piece. This piece could be used in the soundtrack of a comedy movie that takes place in the rural parts of the USA. | 2007-09-19T18:28:14Z | oddis123 | Fade to Bluegrass Tribute to Metallica is available at http://www.cmhrecords.com on iTunes and retailers nationwide. Kirk Hammett also likes this tribute! Check out the interview here: http://youtube.com/watch?v=jdh_0H77Dkc | ["Country", "Music", "Bluegrass"] | ["bluegrass", "cover", "male vocal", "melodic singing", "banjo", "mandolin", "acoustic guitar", "bass guitar", "playful", "easygoing", "rural"] | 9 | _AVegKwklcg | 3451 | |
cowboy music-instrumental | This is a Western music piece performed live by an orchestra. There is a mandolin playing the main melody. Many strummed instruments such as acoustic guitar and ukulele are being played in the melodic background. These sounds evoke an adventurous feeling This piece could be used in the soundtrack of a Western movie/TV series. It could also suit well in the soundtrack of a wild west themed video game like Red Dead Redemption. | 2011-07-30T10:27:10Z | shashirao20072001 | cowboy music-instrumental | ["Flamenco", "Music", "Salsa music"] | ["western music", "no singer", "instrumental", "orchestra", "mandolin", "ukulele", "acoustic guitar", "bass guitar", "adventurous", "eccentric", "movie music", "video game music"] | 9 | w9CxACZ5Oi0 | 5244 |
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;