musiccaps_details (view)
2 rows where musiccaps_aspects contains "medium to uptempo" and musiccaps_names contains "Pop music" sorted by youtube_id
This data as json, CSV (advanced)
musiccaps_aspects (array) 16 ✖
- e-bass 2
- female voice singing 2
- medium to uptempo · 2 ✖
- acoustic drums 1
- acoustic guitar 1
- acoustic piano 1
- banjo 1
- crowd sheering 1
- e-guitar 1
- male voice singing 1
- piano 1
- pop 1
- rock&roll/soul 1
- string section 1
- two songs 1
- upright bass 1
musiccaps_names (array) 5 ✖
- Music 2
- Pop music · 2 ✖
- Music of Asia 1
- Rock and roll 1
- Soul music 1
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 | |
[HQ] TELEPHONE live! by Lady Gaga & Beyonce feat. Sarah Geronimo | An e-bass and strings are playing a simple melody to elevate the atmosphere. In the background an acoustic piano is playing a melody along with the drums. Then a female voice starts singing while the crowd starts cheering. This song may be playing live during a tv-show. | 2010-07-19T13:18:56Z | jsv07 | [HQ] TELEPHONE live! by Lady Gaga & Beyonce performed by: Sarah Geronimo | ["Music of Asia", "Music", "Pop music", "Rock and roll"] | ["pop", "string section", "acoustic piano", "e-bass", "acoustic drums", "female voice singing", "crowd sheering", "medium to uptempo"] | 6 | vYP60jdTupc | 5190 |
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;