musiccaps_details (view)
2 rows where musiccaps_aspects contains "retro dance hits", musiccaps_aspects contains "steady drumming rhythm" and musiccaps_names contains "Music"
This data as json, CSV (advanced)
musiccaps_aspects (array) 40 ✖
- retro dance hits · 2 ✖
- steady drumming rhythm · 2 ✖
- ambient hall noise 1
- booming bass line 1
- bouncy 1
- buzzing tones 1
- classic dance hits 1
- classic pop songs 1
- country dance 1
- couples dancing 1
- dance floor 1
- dance hall 1
- drum stick play 1
- emotional 1
- fiddle playing 1
- groo 1
- groovy bass line 1
- guitar accompaniment 1
- guitar lead 1
- guitar rhythm 1
- high gain noise 1
- instrumental music 1
- love song 1
- love you much 1
- male singer 1
- medium tempo 1
- people dancing 1
- poor audio quality 1
- reggae music 1
- retro hits 1
- retro ska 1
- rim shots 1
- romantic 1
- ska music 1
- ska song 1
- slow dance music 1
- slow tempo 1
- syncopated rhythms 1
- tropical paradise 1
- tropical vibes 1
musiccaps_names (array) 8 ✖
- Music · 2 ✖
- Country 1
- Jazz 1
- Reggae 1
- Singing 1
- Ska 1
- Swing music 1
- Tambourine 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Cowboy Cha Cha (partner dance) by Silver Spurs France | A male singer sings this retro pop melody. The song is medium tempo with a steady drumming rhythm, steady bass line, guitar accompaniment, and fiddler playing. The song is romantic and slow dance-like. The audio quality is very poor. | 2010-07-05T10:34:29Z | Shirley Davidson | Dance.......Cowboy Cha Cha Choreographed by Toshio Suzuki Music .......I Just Wanna Dance With You by George Strait Danced by dancers from Silver Spurs South West France at a social event July 2010. | ["Singing", "Country", "Music", "Tambourine"] | ["slow tempo", "slow dance music", "people dancing", "couples dancing", "dance hall", "dance floor", "ambient hall noise", "poor audio quality", "buzzing tones", "high gain noise", "male singer", "classic pop songs", "retro dance hits", "country dance", "emotional", "romantic", "fiddle playing", "guitar rhythm", "steady drumming rhythm", "love song", "love you much", "booming bass line"] | 1 | B8pesuUc8Ek | 1209 | |
Prince Buster - All my loving | The song is an instrumental. The tempo is medium with a distinctive reggae style backbeat drumming rhythm and a guitar playing rhythm along with a bass guitar solo. The song is extremely passionate and groovy in nature. The audio quality is poor. | 2008-09-12T17:27:26Z | Schmidthorst69 | Killer Rocksteady version of this alltime Beatles classic tune by the one and only voice of the people! | ["Swing music", "Jazz", "Music", "Reggae", "Ska"] | ["instrumental music", "reggae music", "drum stick play", "ska song", "classic dance hits", "tropical vibes", "medium tempo", "bouncy", "retro dance hits", "tropical paradise", "rim shots", "ska music", "retro ska", "syncopated rhythms", "guitar accompaniment", "groovy bass line", "instrumental music", "guitar lead", "retro hits", "steady drumming rhythm", "groo"] | 1 | SkFG5SoXsVk | 2784 |
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;