musiccaps_details (view)
1 row where musiccaps_aspects contains "acoustic drums", musiccaps_aspects contains "joyful", musiccaps_aspects contains "male vocals" and musiccaps_aspects contains "piano"
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 |
---|---|---|---|---|---|---|---|---|---|---|
Nathaniel Rateliff & The Night Sweats: NPR Music Tiny Desk Concerts | This is a live acoustic performance of a folk rock music piece. There are male vocals singing melodically in the lead. The melody consists of a wide range of elements such as the acoustic guitar, the bass guitar, the piano and the saxophone. The acoustic drums are being played with brushes in the rhythmic background. The atmosphere is easygoing and joyful. This piece could be playing in the soundtrack of a feelgood movie during a road trip scene. | 2015-11-17T13:00:00Z | NPR Music | November 17, 2015 by BOB BOILEN Nathaniel Rateliff and his band The Night Sweats are on fire, with concerts that get feet moving and bodies swaying, fueled by rhythm and booze. It wasn't always this way: In the past, Rateliff would be more easily described as a folk artist. When I saw him recently at a sold-out Sunday-night show in D.C., he expressed intense gratitude for the new audience that's found him. Much of that new crowd has embraced the big-band R&B of his new album, Nathaniel Rateliff & The Night Sweats, which was produced by Richard Swift and released on the legendary Stax Records. The record and its songs embrace not only Southern soul, but also the rockier side of soul made famous by Irish singer Van Morrison. Here at the Tiny Desk, Rateliff's body-shaking tunes take on a slightly more laid-back sound, served with a warm heart and suitable for a cold beer. Nathaniel Rateliff & The Night Sweats is available now. iTunes: https://itunes.apple.com/us/album/nathaniel-rateliff-night-sweats/id1004825165 Amazon: http://www.amazon.com/Nathaniel-Rateliff-The-Night-Sweats/dp/B00ZF3SIDI Set List "I Need Never Get Old" "Look It Here" "I've Been Failing You" "Mellow Out" Credits Producers: Bob Boilen, Morgan Walker; Audio Engineer: Josh Rogosin; Videographers: Morgan Walker, Nick Michael, Julia Reihs; Production Assistant: Kate Drozynski; Photo by Julia Reihs/NPR For more Tiny Desk Concerts, subscribe to our podcast: http://www.npr.org/podcasts/510292/tiny-desk-concerts-video | ["Country", "Music"] | ["folk rock", "soul", "acoustic live performance", "male vocals", "melodic singing", "acoustic guitars", "bass guitar", "saxophones", "piano", "acoustic drums", "easygoing", "joyful"] | 9 | 8KUV2TFTpGo | 912 |
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;