musiccaps_details (view)
3 rows where search matches "guitar", musiccaps_aspects contains "guitar rhythm", musiccaps_aspects contains "keyboard accompaniment" and musiccaps_aspects contains "romantic"
This data as json, CSV (advanced)
Suggested facets: youtube_published (date)
musiccaps_aspects (array) 42 ✖
- guitar rhythm · 3 ✖
- keyboard accompaniment · 3 ✖
- romantic · 3 ✖
- emotional 2
- male singer 2
- medium tempo 2
- retro pop hits 2
- steady drumming rhythm 2
- ambient room noise 1
- classic rock band 1
- cymbal crashes 1
- cymbals crashing 1
- dance club mix 1
- dance groove 1
- dance hits 1
- dance rhythm 1
- dance rhythm l 1
- energetic 1
- exercise playlist 1
- female singer 1
- footstep sounds 1
- funky music 1
- groovy drum rhythm 1
- groovy rhythm 1
- guitar accompaniment 1
- latin dance music 1
- latin oercussions 1
- live dance class 1
- love song 1
- love songs 1
- passionate 1
- percussion hit 1
- percussive bass line 1
- poor audio quality 1
- reggae style influences 1
- rock band 1
- room echoes 1
- slick drumming 1
- strong bass line 1
- strong percussive bass line 1
- workout music 1
- youthful 1
musiccaps_names (array) 4 ✖
- Music 3
- Independent music 1
- Reggae 1
- Tambourine 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Cha Cha Espana (Spain) -Line Dance (Demo & Teach) | A male singer sings this passionate melody. The song is medium tempo with guitar strumming rhythm, steady drumming rhythm, keyboard accompaniment and a percussive bass line. The song is romantic with a cool dance groove. The audio quality is poor. | 2011-09-04T22:49:49Z | 2011JulietBeginner | 32 Count, 4 Wall, Beginner Level Line Dance. Choreographed by Ira Weisburd & Motti Kotzer (dancewithira@comcast.net) (Published: September, 2011) Music: GOZAR LA VIDA by Julio Iglesias; Album: NOCHE DE CUATRO LUNAS; Year: 2000; Track: 1 Intro: 32 counts. Starts approx. 19 sec. into the song. NO TAGS, NO RESTARTS !! Danced by: Juliet Lam Videographer / Editor : Walt & Fang-Li Hsu. | ["Music", "Tambourine"] | ["male singer", "latin dance music", "live dance class", "dance rhythm", "footstep sounds", "ambient room noise", "room echoes", "medium tempo", "emotional", "groovy rhythm", "dance rhythm", "steady drumming rhythm", "strong bass line", "guitar rhythm", "keyboard accompaniment", "latin oercussions", "exercise playlist", "workout music", "poor audio quality", "romantic", "dance rhythm l"] | 1 | FCzMqo8kh1o | 1623 | |
High Tone ft Pupajim - Rub a Dub Anthem | A female singer sings this cool melody. The song is medium tempo with a percussive bass line, slick drumming rhythm, guitar accompaniment , keyboard accompaniment and various percussion hits. The song has a strong dance groove and retro pop in style. | 2010-05-19T17:31:01Z | Smashing Sound | Out back (jarring effect 17-05-2010) | ["Music", "Reggae"] | ["female singer", "strong percussive bass line", "reggae style influences", "groovy drum rhythm", "guitar rhythm", "slick drumming", "keyboard accompaniment", "funky music", "guitar accompaniment", "dance groove", "retro pop hits", "cymbal crashes", "romantic", "love songs", "dance hits", "dance club mix", "percussion hit"] | 1 | TabaOeYq2ek | 2848 | |
Missing from YouTube | A male singer sings this rock melody. The tempo is medium with a groovy bass line, guitar rhythm , keyboard accompaniment, and heavy rock drumming with cymbals crashing. The song is energetic and passionate. The song is a retro pop-rock song. | ["Music", "Independent music"] | ["male singer", "classic rock band", "cymbals crashing", "rock band", "emotional", "steady drumming rhythm", "medium tempo", "guitar rhythm", "keyboard accompaniment", "romantic", "emotional", "love song", "energetic", "youthful", "passionate", "retro pop hits", "percussive bass line"] | 1 | 4437 |
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;