musiccaps_details (view)
3 rows where search matches "guitar", musiccaps_aspects contains "groovy bass", musiccaps_aspects contains "joyful" and musiccaps_aspects contains "punchy snare"
This data as json, CSV (advanced)
musiccaps_aspects (array) >30 ✖
- groovy bass · 3 ✖
- joyful · 3 ✖
- low quality 3
- punchy snare · 3 ✖
- electric guitar melody 2
- boomy kicks 1
- brass stabs 1
- clapping 1
- emotional 1
- energetic crash 1
- exciting 1
- folk 1
- fruity male vocal 1
- groovy electric guitar chords 1
- happy 1
- harmonica solo 1
- harmonizing male vocals 1
- hopeful 1
- live performance 1
- mono 1
- noisy 1
- passionate 1
- passionate female vocal 1
- passionate male vocal 1
- playback instrumental 1
- punchy kick 1
- shimmering hi hats 1
- shimmering shakers 1
- shimmering tambourine 1
- soft kick hits 1
- …
musiccaps_names (array) 6 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
It's Not the Bullet that Kills You (It's the Hole) | The low quality recording features a folk song that consists of a passionate female vocal singing over harmonica solo, groovy bass, shimmering hi hats, punchy snare, boomy kicks, groovy electric guitar melody and some claps. It sounds passionate and joyful. | 2011-04-15T23:19:29Z | cxbmusic | Track length = 3:47. Before Laurie Anderson had a record contract, she released this - her first single, apparently sponsored by the Holly Solomon Gallery for an installation (a jukebox containing this and a number of other songs including 'New York Social Life'). The song was dedicated to Chris Burden. The image is of Laurie Anderson in the 1970s. | ["Harmonica", "Wind instrument, woodwind instrument"] | ["low quality", "folk", "groovy bass", "harmonica solo", "clapping", "groovy electric guitar chords", "shimmering hi hats", "boomy kicks", "punchy snare", "passionate female vocal", "passionate", "joyful"] | 4 | -zA6LL78KYU | 106 | |
Boom Boom Room-J Paul Jr. | The low quality recording features a fruity male vocal singing over steel drums melody, electric guitar melody, brass stabs, punchy kick and snare hits, energetic crash cymbal, groovy bass, shimmering shakers and sustained organ keys chord. It sounds joyful, happy and exciting. | 2011-07-14T03:42:01Z | Bigzydecohal21 | Let Tha Rebel take u to the Boom Boom Room | ["Singing", "Funk", "Music"] | ["low quality", "steel drums melody", "electric guitar melody", "brass stabs", "sustained organ keys chord", "punchy snare", "punchy kick", "groovy bass", "energetic crash", "fruity male vocal", "shimmering shakers", "joyful", "happy", "exciting"] | 4 | d61plJ66vE8 | 3762 | |
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;