musiccaps_details (view)
3 rows where search matches "guitar", musiccaps_names contains "Reggae" and musiccaps_names contains "Swing music" sorted by youtube_description
This data as json, CSV (advanced)
Suggested facets: youtube_published (date)
musiccaps_aspects (array) 36 ✖
- acoustic drums 2
- e-bass 2
- e-guitar 2
- bongos 1
- bouncy 1
- brass section 1
- classic dance hits 1
- drum stick play 1
- fast tempo 1
- groo 1
- groovy bass line 1
- guitar accompaniment 1
- guitar lead 1
- instrumental music 1
- keys 1
- male voice singing 1
- medium tempo 1
- medium to uptempo 1
- percussion 1
- piano 1
- r&b/soul 1
- reggae music 1
- retro dance hits 1
- retro hits 1
- retro ska 1
- rim shots 1
- saxophone 1
- ska 1
- ska music 1
- ska song 1
- steady drumming rhythm 1
- syncopated rhythms 1
- tambourine 1
- tropical paradise 1
- tropical vibes 1
- uplifting energy 1
musiccaps_names (array) 8 ✖
- Music 3
- Reggae · 3 ✖
- Swing music · 3 ✖
- Jazz 1
- Music of Africa 1
- Musical instrument 1
- Ska 1
- Song 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description ▼ | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Revolucionario-Rompope Sound | An acoustic drum is playing along with a bassline giving the song a ska/reggae feeling. The e-guitar strumming on the offbeat supports that feeling while a keyboard is playing a bell-sounding chord. Bongos are setting little accents at the end. A saxophone is playing a melody along. This song may be playing at a festival outside while the sun is shining. | 2014-06-06T00:05:11Z | Zkanker Efrain Lorenzo Bautista | Demo! El facebook de la banda:https://www.facebook.com/bandda.rompoopee | ["Swing music", "Music of Africa", "Music", "Reggae"] | ["ska", "saxophone", "e-guitar", "acoustic drums", "percussion", "keys", "e-bass", "fast tempo", "uplifting energy"] | 6 | -kpR93atgd8 | 79 | |
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 | |
ARCHIE BELL & THE DRELLS - DANCING TO YOUR MUSIC (GLADES) | This song contains acoustic drums playing a groove along with an e-bass and a tambourine. A brass section is playing along with the drum fills and the bongos. A piano is playing a melody together with a guitar strumming chords in the mid range. The male singer sounds loud and soulful. This song may be playing in a rollerblade disco. | 2011-09-16T12:58:50Z | EddiesSoulSounds | More early 70's brilliance. This one from Texas giants Archie and the Drells who released this cracking mid-tempo dancer on the Miami based Gllades label from 1972. Great stuff! | ["Swing music", "Music", "Musical instrument", "Reggae", "Song"] | ["r&b/soul", "e-bass", "brass section", "e-guitar", "bongos", "acoustic drums", "male voice singing", "tambourine", "piano", "medium to uptempo"] | 6 | vx5iuWuE2Ng | 5220 |
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;