musiccaps_details (view)
1 row where search matches "guitar", musiccaps_aspects contains "live performance", musiccaps_aspects contains "passionate female vocal" and musiccaps_aspects contains "unbalanced stereo image"
This data as json, CSV (advanced)
musiccaps_aspects (array) 10 ✖
- acoustic guitar strummed chord 1
- alternative/indie 1
- emotional 1
- live performance · 1 ✖
- low quality 1
- noisy 1
- passionate 1
- passionate female vocal · 1 ✖
- unbalanced stereo image · 1 ✖
- wooden percussive element 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
The Wild Reeds: NPR Music Tiny Desk Concert | The low quality recording features a live performance of an Alternative/Indie song and it consists of passionate female vocal singing over acoustic guitar strummed chord and wooden percussive element. The recording is noisy and the vocal is slightly moving throughout the stereo image making it unbalanced. It sounds passionate and emotional. | 2015-11-20T18:04:16Z | NPR Music | November 20, 2015 by BOB BOILEN Great singers aren't easy to come by, so finding three in one band is something special. The Wild Reeds' music shines when Sharon Silva, Kinsey Lee and Mackenzie Howe harmonize, but each also takes a leading role — and that's the power of the L.A. band, whose songs are clear and memorable, potent and sometimes delicate. The Wild Reeds' 2014 debut album Blind And Brave only hints at the talent on display here. Here, the group opens with my favorite song from the record, "Where I'm Going," and then offers a taste of 2016 with two new ones. Next year ought to be a big year for The Wild Reeds, and this Tiny Desk Concert will show you what I mean. Blind And Brave is available now. iTunes: https://itunes.apple.com/us/album/blind-and-brave/id907588390 Amazon: http://www.amazon.com/Blind-Brave-The-Wild-Reeds/dp/B00MKFKGES Set List "Where I'm Going" "Everything Looks Better In Hindsight" "The World We Built" 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 | ["Jazz", "Music"] | ["low quality", "noisy", "alternative/indie", "wooden percussive element", "acoustic guitar strummed chord", "passionate female vocal", "emotional", "passionate", "live performance", "unbalanced stereo image"] | 4 | 0TiEO149Ydc | 173 |
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;