musiccaps_details (view)
3 rows where musiccaps_aspects contains "retro dance hits" and musiccaps_aspects contains "steady drumming rhythm" sorted by musiccaps_caption
This data as json, CSV (advanced)
musiccaps_aspects (array) 54 ✖
- retro dance hits · 3 ✖
- steady drumming rhythm · 3 ✖
- male singer 2
- poor audio quality 2
- ambient hall noise 1
- booming bass line 1
- bouncy 1
- buzzing tones 1
- car horn playing percussively 1
- cheerful 1
- classic dance hits 1
- classic pop songs 1
- country dance 1
- couples dancing 1
- dance floor 1
- dance hall 1
- dance song 1
- drum stick play 1
- emotional 1
- energetic 1
- exciting 1
- female backup singers 1
- fiddle playing 1
- groo 1
- groovy bass line 1
- groovy dance rhythm 1
- guitar accompaniment 1
- guitar lead 1
- guitar rhythm 1
- high gain noise 1
- hip hop dance hits 1
- hip hop music 1
- hissing noise 1
- instrumental music 1
- keyboard accompaniment 1
- love song 1
- love you much 1
- medium tempo 1
- medium-fast tempo 1
- people dancing 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
- strong bass line 1
- syncopated rhythms 1
- tropical paradise 1
- tropical vibes 1
- vocal harmony 1
musiccaps_names (array) 10 ✖
- Music 2
- Brass instrument 1
- Country 1
- Jazz 1
- Reggae 1
- Singing 1
- Ska 1
- Swing music 1
- Tambourine 1
- Trumpet 1
video | youtube_link | musiccaps_caption ▼ | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Slam Trumpet - Quad City DJs vs. Skull Trumpet | A male singer sings this exciting melody with female backup singers in vocal harmony. The song is medium fast tempo with a strong bass line, steady drumming rhythm, keyboard accompaniment and a car horn playing percussively. The song has pretty bad audio quality. The song is a retro hip hop dance tune. | 2011-11-28T10:38:09Z | GravityGames | Is this the best Slam Jam Remix? | ["Brass instrument", "Trumpet"] | ["male singer", "hip hop music", "car horn playing percussively", "female backup singers", "groovy dance rhythm", "vocal harmony", "poor audio quality", "energetic", "exciting", "cheerful", "dance song", "retro dance hits", "hip hop dance hits", "steady drumming rhythm", "strong bass line", "keyboard accompaniment", "hissing noise", "medium-fast tempo"] | 1 | f4jW2H6V7gk | 3919 | |
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;