musiccaps_details (view)
2 rows where musiccaps_aspects contains "passionate", musiccaps_aspects contains "poor audio quality" and musiccaps_names contains "Folk music"
This data as json, CSV (advanced)
musiccaps_aspects (array) 31 ✖
- groovy music 2
- passionate · 2 ✖
- poor audio quality · 2 ✖
- adrenaline rush 1
- arabic dance music sultry vocals 1
- arabic music 1
- arabic percussion 1
- blues music 1
- classic guitar hits 1
- dance rhythm 1
- dance tunes 1
- dholak percussions 1
- energetic 1
- fast strumming rhythm 1
- fast tempo 1
- female singer 1
- groovy 1
- guitar player 1
- gypsy guitar music 1
- hooting 1
- instrumental music 1
- jazz blues 1
- keyboard accompaniment 1
- love songs 1
- medium tempo 1
- people cheering 1
- romantic 1
- soloist 1
- steady drumming rhythm 1
- tambourine percussion 1
- virtuous guitarist 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Rif Music 2018 | A female singer sings this sultry vocals. The song is medium tempo with traditional Arabic percussions playing steadily, tambourine percussion, keyboard accompaniment and a strong bass-line. The song is romantic and passionate. The audio quality is poor. | 2010-04-16T23:11:47Z | Moha Dulce Rifeño | www.Rifmelody.com | ["Folk music", "Music"] | ["female singer", "arabic music", "medium tempo", "poor audio quality", "groovy music", "arabic dance music sultry vocals", "tambourine percussion", "keyboard accompaniment", "steady drumming rhythm", "dholak percussions", "arabic percussion", "passionate", "romantic", "love songs", "dance tunes"] | 1 | 7dmT4SgS_EM | 869 | |
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;