musiccaps_details (view)
3 rows where musiccaps_aspects contains "dance rhythm" and musiccaps_aspects contains "soloist"
This data as json, CSV (advanced)
musiccaps_aspects (array) 51 ✖
- dance rhythm · 3 ✖
- instrumental music 3
- soloist · 3 ✖
- adrenaline rush 2
- groovy 2
- medium tempo 2
- amateur player 1
- attitude 1
- average audio quality 1
- bad audio quality 1
- blues music 1
- celtic music influences 1
- cheerful 1
- choreography 1
- classic guitar hits 1
- country music 1
- dance hits 1
- dance music 1
- drum solo 1
- emotional 1
- enegetic 1
- energetic 1
- fast strumming rhythm 1
- fast tempo 1
- folk music 1
- full of spunk 1
- groovy music 1
- guitar player 1
- gypsy guitar music 1
- happy 1
- heavy cymbal crashes 1
- hobbyist 1
- hooting 1
- irish jig 1
- jazz blues 1
- mandolin playing 1
- music demo 1
- music video 1
- no percussions 1
- online music videos 1
- passionate 1
- people cheering 1
- poor audio quality 1
- pop dance routine 1
- positive 1
- rhyming dance 1
- tempo 1
- virtuous guitarist 1
- young dancers 1
- youthful 1
- youtube music video 1
musiccaps_names (array) 11 ✖
- Music 2
- Banjo 1
- Bass drum 1
- Drum 1
- Drum kit 1
- Drum roll 1
- Folk music 1
- Mandolin 1
- Percussion 1
- Rimshot 1
- Snare drum 1
youtube_published (date) 3 ✖
- 2010-03-03 1
- 2011-07-03 1
- 2013-10-15 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Hyorin (SISTAR) - 미니스커트 (dance practice) DVhd | The song is an instrumental. The tempo is medium, featuring a drum solo with no other instrumentation, featuring a lot of stops, cymbals crashes and drum rolls. The song serves as a dance track for a group of dancers. The audio quality is deteriorated and generally poor. | 2011-07-03T16:03:44Z | Joshiii | DVhd CREATIONS (kpop compilations) KPop Final Omen - http://www.youtube.com/watch?v=Qf9sys83DDM Empty KPop - http://www.youtube.com/watch?v=tbBhgXw1xXM Checkout my channel for more Dance Versions and Dance Rehearsals... enjoy :) SUBSCRIBE!!! | ["Drum", "Drum kit", "Drum roll", "Rimshot", "Snare drum", "Bass drum", "Percussion"] | ["bad audio quality", "instrumental music", "enegetic", "youthful", "dance rhythm", "choreography", "young dancers", "youthful", "full of spunk", "attitude", "adrenaline rush", "pop dance routine", "medium tempo", "groovy", "heavy cymbal crashes", "dance music", "drum solo", "rhyming dance", "dance hits", "soloist", "tempo"] | 1 | 2gvyOxKuQPY | 397 | |
Mandolin Madness | The song is an instrumental. The song is a medium tempo with a mandolin player playing a cheerful melody with no other instrumentation. The song is positive and has a delightful dance rhythm. The song has an average audio quality. | 2013-10-15T23:19:40Z | Kimsey Lutherie | A compilation of all my mandolin videos- just playing, no talking. Elkhorn, Gilchrist, Kentucky, Krishot, Weber, Stanley. | ["Banjo", "Music", "Mandolin"] | ["mandolin playing", "instrumental music", "medium tempo", "online music videos", "folk music", "youtube music video", "soloist", "hobbyist", "emotional", "country music", "dance rhythm", "celtic music influences", "irish jig", "no percussions", "music video", "average audio quality", "amateur player", "happy", "positive", "dance rhythm", "cheerful", "music demo"] | 1 | 4vsI0Kwn8jY | 618 | |
Tommy Emmanuel - The best acoustic guitar live blues! | The song is an instrumental. The song is fast tempo with soloists playing an enthusiastic guitar strumming and harmony. The song is energetic and entertaining. The audio is poor and the song is played in front of a live audience that is cheering and hooting in approval. | 2010-03-03T19:34:12Z | kolipas | Firstly, I do not upload such kind of videos as I have only uploaded gaming (runescape) videos so far. However, I was totally hooked by this blues improvisation and it would be a crime if I didn't share it. So here it is. If you are interested about this artist, here is his official website. www.tommyemmanuel.com You can download his music there. If this video will get enough views and rates, I might upload similar ones in the future. Enjoy. acoustic guitar blues 12 bars runescape best ever funny awsome epic increadible sick improvisation freestyle live | ["Folk music", "Music"] | ["poor audio quality", "instrumental music", "virtuous guitarist", "classic guitar hits", "adrenaline rush", "people cheering", "groovy", "hooting", "guitar player", "soloist", "fast strumming rhythm", "energetic", "passionate", "dance rhythm", "groovy music", "jazz blues", "gypsy guitar music", "blues music", "fast tempo"] | 1 | E3F9bzeCgTQ | 1528 |
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;