musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "emotional", musiccaps_aspects contains "low quality" and musiccaps_names contains "Jazz"
This data as json, CSV (advanced)
musiccaps_aspects (array) 16 ✖
- emotional · 2 ✖
- low quality · 2 ✖
- acoustic guitar strummed chord 1
- alternative/indie 1
- fruity male vocal 1
- groovy bass 1
- live performance 1
- low toms 1
- noisy 1
- nostalgic 1
- passionate 1
- passionate female vocal 1
- southern rock 1
- unbalanced stereo image 1
- wide electric guitar melody 1
- wooden percussive element 1
musiccaps_names (array) 5 ✖
- Jazz · 2 ✖
- Music 2
- Dance music 1
- Pop music 1
- Theme music 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 | |
WWE NXT New Official Theme Music - Wild & Young | The low quality recording features a southern rock song that consists of a fruity male vocal singing over groovy bass guitar, low toms and wide electric guitar melody. It sounds emotional and nostalgic. | 2010-02-21T17:26:22Z | UniverseOfWWE | ["Theme music", "Jazz", "Music", "Pop music", "Dance music"] | ["low quality", "southern rock", "wide electric guitar melody", "groovy bass", "low toms", "fruity male vocal", "emotional", "nostalgic"] | 4 | 53UF6F7D284 | 629 |
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;