musiccaps_details (view)
4 rows where search matches "guitar", musiccaps_aspects contains "joyful", musiccaps_aspects contains "live performance" and musiccaps_aspects contains "low quality"
This data as json, CSV (advanced)
musiccaps_aspects (array) 36 ✖
- joyful · 4 ✖
- live performance · 4 ✖
- low quality · 4 ✖
- emotional 2
- mono 2
- noisy 2
- passionate male vocal 2
- punchy snare 2
- acoustic guitar melody 1
- acoustic rhythm guitar 1
- acoustic rhythm guitar chords 1
- addictive 1
- country 1
- crowd cheering 1
- crowd clapping 1
- echoing passionate male vocal 1
- electric guitar melody 1
- folk 1
- groovy bass 1
- groovy bass guitar 1
- happy 1
- harmonica solo melody 1
- harmonizing male vocals 1
- hopeful 1
- passionate 1
- playback instrumental 1
- shimmering hi hats 1
- shimmering tambourine 1
- simple kick 1
- soft kick hits 1
- soul 1
- soulful 1
- steel guitar repetitive guitar 1
- sustained strings melody 1
- toms roll 1
- whistling 1
musiccaps_names (array) 7 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
"Chicken Reel" Annie & Mac Old Time Music Moment | The low quality recording features a live performance that consists of harmonica solo melody played over acoustic rhythm guitar chords. The recording is noisy, in mono and it sounds happy and joyful. | 2008-01-22T04:52:48Z | annieandmac | Traditional old time mountain stringband tune played here on harmonica with rhythm guitar. http://www.annieandmac.com | ["Harmonica", "Wind instrument, woodwind instrument"] | ["low quality", "noisy", "mono", "harmonica solo melody", "acoustic rhythm guitar chords", "happy", "joyful", "live performance"] | 4 | 4VbXYuCz4M0 | 577 | |
Gary Stewart She's Acting Single | The low quality recording features a live performance of a country song that consists of an acoustic rhythm guitar, groovy bass guitar, shimmering hi hats, simple kick, punchy snare and steel guitar repetitive melody. At the end of the loop, there is a short snippet of passionate male vocal singing, while at the beginning there is a crowd clapping sound. It sounds joyful and addictive. | 2008-07-26T23:11:42Z | bigruss2069 | My ALL TIME FAV Gary sings what all us men have felt at one time or another. Anyone familiar with Gary Stewart and his tragic ending, KNOWS that when this guy sang love songs, he sang them from the heart... I met him briefly in Oklahoma City at a dinner showplace called "Henson's" circa 1983 and was struck by how friendly and real this guy was. Gary, you will not be forgotten! | ["Blues", "Singing"] | ["low quality", "live performance", "country", "acoustic rhythm guitar", "groovy bass guitar", "shimmering hi hats", "simple kick", "punchy snare", "steel guitar repetitive guitar", "passionate male vocal", "crowd clapping", "joyful", "addictive"] | 4 | D9893od03Sc | 1444 | |
Toshi - Piya Re (UKU) | The low quality recording features a live performance of a folk song that consists of an echoing passionate male vocal singing over sustained strings melody, acoustic guitar melody and some crowd cheering and whistling sounds in the background. It sounds joyful, passionate and emotional overall. | 2009-04-12T19:01:17Z | MariumSaeed | ["Singing", "Music of Asia", "Music"] | ["low quality", "folk", "live performance", "echoing passionate male vocal", "sustained strings melody", "acoustic guitar melody", "crowd cheering", "whistling", "joyful", "passionate", "emotional"] | 4 | e1PG31QlQmc | 3836 | ||
New York Subway's Danny Small aka Singing Dragon | The low quality recording features a live performance of a soul song and it consists of passionate male vocal singing over playback instrumentals. The instrumental consists of a shimmering tambourine layered with punchy snare hits, soft kick hits, some toms rolls, groovy bass, electric guitar melody and harmonizing male vocals. It sounds emotional, soulful, hopeful and joyful. | 2010-03-07T21:11:15Z | BayardStudios | He calls himself the "Singing Dragon", his name is Mitchell Hughes aka Danny Small of Gheechee Records LLC aka the Singing Dragon and he was performing at the 14th St/6th Ave station. Originally from South Carolina, there is logic to the moniker Singing Dragon, he was born the same year as Bruce Lee in the Chinese calendar year of the Dragon, of Puerto Rican, Dominican, Cuban, Brazilian, Mexican and Guyanese and even Chinese descent. A marvel amongst subway performers, what a wonderful way to end a walkabout. Shot with a Canon 5D Mark II, Canon 16-35mm f/2.8L, recorded with the in-camera mic and moderately mixed in Final Cut Pro 6. | ["Music", "/t/dd00003"] | ["low quality", "live performance", "noisy", "mono", "passionate male vocal", "soul", "playback instrumental", "shimmering tambourine", "punchy snare", "groovy bass", "electric guitar melody", "soft kick hits", "toms roll", "harmonizing male vocals", "emotional", "hopeful", "joyful", "soulful"] | 4 | l1coM570kVw | 4370 |
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;