musiccaps_details (view)
2 rows where musiccaps_aspects contains "easygoing" and "youtube_published" is on date 2015-11-17
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 | |
| Klajdi Haruni - O bo bo (Kenga Magjike 2015) | This is an Albanian pop music piece. There are male vocals singing melodically in the Albanian language. The main theme is being played on the clarinet while there is a melodic backing composed of the acoustic guitar, the electric guitar and the bass guitar. The rhythm is provided by a laid-back acoustic drum beat. The atmosphere is lively. This piece could be used as an opening theme for an Albanian sit-com. | 2015-11-17T17:00:02Z | KlajdiHaruniVEVO | Music video for O bo bo (Kenga Magjike 2015) performed by Klajdi Haruni. Site: http://www.threedots.al Facebook: https://www.facebook.com/klajdiharunithreedots?fref=ts Copyright (C) 2015 Threedots Production. http://vevo.ly/fQQQYu | ["Singing", "Swing music", "Pop music"] | ["albanian pop music", "male vocals", "melodic singing", "clarinet", "acoustic guitar", "electric guitat", "bass guitar", "acoustic drums", "easygoing", "lively"] | 9 | t5fW1-6iXZY | 5004 |
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;