musiccaps_details (view)
3 rows where musiccaps_author = 9, musiccaps_names contains "Music of Africa" and musiccaps_names contains "Song"
This data as json, CSV (advanced)
Suggested facets: youtube_published (date)
musiccaps_aspects (array) 31 ✖
- keyboard 2
- male vocals 2
- acoustic guitar 1
- american folk 1
- bass guitar 1
- bluegrass 1
- chill 1
- cozy 1
- dancehall 1
- dizzying 1
- dub 1
- electronic percussion 1
- energetic 1
- fiddle 1
- friendly 1
- high tempo 1
- jamaican 1
- joyful 1
- latin dance 1
- lively 1
- male vocal 1
- mandolin 1
- maraca 1
- medium-to-high pitch singing 1
- melodic singing 1
- nostalgic 1
- reggae 1
- repeated theme 1
- steady tempo 1
- trumpet 1
- vibrant 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
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 | |
Jucafri maraca | This is a latin dance piece. There are two vocals taking turns singing the same line repeatedly. There is a keyboard and a trumpet playing the main melody. A fast-paced electronic percussion is playing in the rhythmic background. This is a dizzyingly high tempo song. It is very danceable. This piece can be played in latin nightclubs and latin dance courses. | 2008-03-05T03:25:33Z | 2redrose22 | Jucafri dale maraca | ["Afrobeat", "Music of Africa", "Music", "Song", "Maraca"] | ["maraca", "latin dance", "male vocals", "repeated theme", "trumpet", "keyboard", "electronic percussion", "high tempo", "energetic", "dizzying"] | 9 | _yXtw_z2xf4 | 3506 | |
Capleton, Turbulence, Chuck Fender, Chrisinti, Bascom X, Major Chris, Anthony Cruz Passi new songs dancehall ska roots | This is a dancehall music piece. There is a male vocalist singing at a medium-to-high pitch with a Jamaican accent. In the background, there is a keyboard playing the main melody. The atmosphere of the piece is vibrant. This piece could be used at beach parties and summer/vacation themed movies or TV shows. | 2010-11-04T07:12:42Z | reggaedownload | ["Music of Africa", "Music", "Reggae", "Ska", "Song"] | ["dancehall", "reggae", "dub", "jamaican", "male vocal", "medium-to-high pitch singing", "keyboard", "chill", "vibrant", "lively"] | 9 | zfkPKRn8ah8 | 5502 |
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;