musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "punchy snare" and musiccaps_names contains "Harmonica"
This data as json, CSV (advanced)
Suggested facets: youtube_published (date)
musiccaps_aspects (array) 21 ✖
- groovy bass 2
- low quality 2
- passionate 2
- punchy snare · 2 ✖
- blues 1
- boomy kicks 1
- clapping 1
- electric guitar melody 1
- energetic 1
- folk 1
- groovy electric guitar chords 1
- harmonica solo 1
- harmonica solo melody 1
- joyful 1
- live performance 1
- mono 1
- noisy 1
- passionate female vocal 1
- shimmering cymbals 1
- shimmering hi hats 1
- whistling sound 1
musiccaps_names (array) 2 ✖
- Harmonica · 2 ✖
- Wind instrument, woodwind instrument 2
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 | |
Steve Miller mercury blues norton buffalo harmonica solo | The low quality recording features a live performance of blues songs and it consists of a harmonica solo melody played over groovy bass, punchy snare, shimmering cymbals and electric guitar melody. As it was recorded with a phone, there are some whistling crowd noises, aside from the fact that the recording is in mono and noisy. It still sounds energetic and passionate. | 2006-10-04T03:46:37Z | Sunshine Day | part of song with awesome harmonica solo by norton | ["Harmonica", "Wind instrument, woodwind instrument"] | ["low quality", "whistling sound", "mono", "noisy", "harmonica solo melody", "groovy bass", "punchy snare", "shimmering cymbals", "electric guitar melody", "live performance", "blues", "passionate", "energetic"] | 4 | ovomUNSo_uo | 4666 |
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;