musiccaps_details (view)
1 row where musiccaps_aspects contains "banjo", musiccaps_aspects contains "e-bass", musiccaps_aspects contains "piano" and musiccaps_aspects contains "rock&roll/soul"
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 |
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;