musiccaps_details (view)
5 rows where musiccaps_aspects contains "bass guitar" and musiccaps_aspects contains "mandolin"
This data as json, CSV (advanced)
musiccaps_aspects (array) 55 ✖
- bass guitar · 5 ✖
- mandolin · 5 ✖
- acoustic guitar 4
- banjo 2
- bluegrass 2
- emotional 2
- fiddle 2
- medium tempo 2
- melodic singing 2
- acoustic drums 1
- adventurous 1
- american folk 1
- auto harp 1
- cello 1
- country love song 1
- country music 1
- country pop 1
- country song 1
- country song hits 1
- cover 1
- cozy 1
- duet 1
- easygoing 1
- eccentric 1
- electric guitar 1
- female vocal 1
- first love 1
- folk music 1
- friendly 1
- inspiring 1
- instrumental 1
- intense drumming 1
- joyful 1
- keyboard harmony 1
- love song 1
- male vocal 1
- male vocals 1
- medium-to-high pitch singing 1
- movie music 1
- no singer 1
- nostalgic 1
- orchestra 1
- passionate 1
- playful 1
- proposal song 1
- romantic 1
- rural 1
- song climax 1
- steady tempo 1
- touching 1
- ukulele 1
- video game music 1
- violins 1
- wedding song 1
- western music 1
musiccaps_names (array) 11 ✖
- Music 5
- Country 4
- Bluegrass 1
- Flamenco 1
- Music of Africa 1
- Pop music 1
- Psychedelic rock 1
- Rock music 1
- Salsa music 1
- Singing 1
- Song 1
youtube_published (date) 5 ✖
- 2007-09-19 1
- 2011-04-03 1
- 2011-07-01 1
- 2011-07-30 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 |
---|---|---|---|---|---|---|---|---|---|---|
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 | |
Country Top 10 Wedding Slow Songs - Twin Cities Wedding DJs MN | This song is a romantic duet. The tempo is medium with a plethora of instruments like the auto harp, fiddle, acoustic guitar, electric guitar, bass guitar, banjo,intense drumming, cello, violin harmony and vocal harmony. The song is a romantic, charming,emotional, passionate love song. The instrumentation style and music decibels indicate that this is the climax of a country love song. | 2011-07-01T05:49:25Z | TwinCities WeddingDJs | Top Ten Country slow songs. Twin Cities Wedding DJs MN. http://www.twincitiesweddingdjs.com These are the Top Ten Country slow songs for wedding receptions and company parties. *** The edited material is briefly referenced for educational purposes *** | ["Singing", "Country", "Music"] | ["duet", "medium tempo", "country song", "fiddle", "auto harp", "song climax", "country love song", "first love", "wedding song", "proposal song", "banjo", "mandolin", "acoustic guitar", "intense drumming", "keyboard harmony", "cello", "violins", "electric guitar", "bass guitar", "love song", "romantic", "passionate", "emotional", "country song hits", "country pop", "folk music"] | 7 | AagemOzvoZE | 1141 | |
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;