musiccaps_details (view)
3 rows where musiccaps_aspects contains "e-bass", musiccaps_aspects contains "e-guitar", musiccaps_aspects contains "male voice singing" and musiccaps_aspects contains "medium to uptempo"
This data as json, CSV (advanced)
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Sweet Soul Music 31 Scorching Classics 1964 | A male voice is singing along to a blues/rock bassline and acoustic drums. A e-guitar and a banjo are playing the same melody as the bass. All the instruments are playing when the male voice is not singing. Then after fading out a new song starts with a percussive sound, an upright bass, piano and a female voice singing.This song may be playing in a bar. | 2009-11-28T18:40:58Z | BearFamilyRecords | Various Artists Sweet Soul Music 29 Scorching Classics 1964 (1-CD DigiPac with 96-page booklet. 29 tracks, playing time: 79:48) -- Here comes the eagerly anticipated sequel to our first five volumes of 'Sweet Soul Music,' as well as the highly acclaimed, award-winning R&B series 'Blowin' The Fuse.' This is ehe sound that influences musicians who weren't even born when it came out, like Amy Winehouse and Joss Stone! All the greatest and most influential soul hits of the 1960s, including some surprisingly hard-to-find selections! Every song is the original version. The ultimate soul collection spread across ten individual CDs! The soul-searing soundtrack to the 1960s! Massive, beautifully illustrated booklets with detailed notes, incredible vintage photos, and ephemera. -- Over the course of ten spectacular years, R&B morphed into soul music with a side order of funk, and became the soundtrack to a social revolution. The riveting story of that incredible decade is told in full for the first time on Bear Family's 'Sweet Soul Music' series. Some record companies have compiled anthologies from their own vaults, but Bear Family has gone the extra mile... and then some, licensing classic recordings from virtually every record label at the epicenter of '60s soul to compile the greatest hits with the finest sound quality. -- The second five volumes, available now, cover the years 1966-1970. Though gospel remained the bedrock of soul music, the sound was transforming fast, thanks to Motown, Stax, the regional innovations of Chicago, New Orleans, and Muscle Shoals, and the funk revolution, led by James Brown and Sly & The Family Stone. The civil rights and antiwar movements were now rolling full speed ahead, and the messages at the heart of the music were often as powerful and invigorating as the grooves themselves. The second half of this incredible story is just as fascinating as the first. Bill Dahl's track-by-track commentary provides extensive biographical info on every artist on every disc. -- The prelude to this seri… | ["Music", "Pop music", "Soul music"] | ["rock&roll/soul", "e-guitar", "e-bass", "acoustic guitar", "piano", "banjo", "two songs", "male voice singing", "female voice singing", "upright bass", "medium to uptempo"] | 6 | DGbMEkQerYs | 1458 | |
FUNK MONSTERS SUPER 70´s MEDLEY | A male voice is singing a melody in the midrange sounding like having fun while doing so. Backing vocals are shouting at the end of his phrase. In the background you can hear the instruments playing funky melodies; rhythms and grooves. What stands out is a flute playing a flute melody sounding like a traditional chinese melody and digital strings are playing in the midrange. This song may be playing celebrating graduation with costumes. | 2008-10-29T19:50:41Z | dodefonk | FUNK MONSTERS | ["Funk", "Music", "Happy music"] | ["funk", "e-bass", "acoustic drums", "piano", "transverse flute", "digital strings", "e-guitar", "male voice singing", "medium to uptempo", "positive energy"] | 6 | tUZB_Xf1m6k | 5040 | |
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;