musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "live performance", musiccaps_aspects contains "punchy snare" and musiccaps_names contains "Guitar"
This data as json, CSV (advanced)
musiccaps_aspects (array) 24 ✖
- energetic 2
- live performance · 2 ✖
- low quality 2
- punchy snare · 2 ✖
- acoustic rhythm guitar melody 1
- aggressive 1
- aggressive electric guitar melodies 1
- crowd cheering 1
- crowd noises 1
- distorted bass guitar 1
- electric guitar melody 1
- energetic cymbals 1
- folk 1
- groovy bass 1
- manic drums 1
- metal 1
- passionate 1
- punchy double pedal kick 1
- shimmering cymbals 1
- soulful 1
- steel guitar solo melody 1
- uptempo 1
- violin melody 1
- wide clapping 1
musiccaps_names (array) 9 ✖
- Guitar · 2 ✖
- Music 2
- Angry music 1
- Banjo 1
- Drum 1
- Heavy metal 1
- Musical instrument 1
- Plucked string instrument 1
- Rock music 1
youtube_published (date) 2 ✖
- 2009-07-15 1
- 2010-09-01 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Foggy Mtn Breakdown (Must-Own DVD) | The low quality recording features a live performance of a folk song and it contains a steel guitar solo melody played over, acoustic rhythm guitar, electric guitar melody, shimmering cymbals, punchy snare, groovy bass, followed by violin melody, crowd noises and claps. It sounds passionate, uptempo, soulful and energetic. | 2009-07-15T05:50:54Z | jamesarthurjohnson | From All-Star Bluegrass Celebration DVD - Ricky Skaggs, Earl Scruggs, Vince Gill, Travis Tritt, Jerry Douglas, and on and on... | ["Banjo", "Guitar", "Music", "Musical instrument", "Plucked string instrument"] | ["low quality", "folk", "live performance", "wide clapping", "crowd noises", "steel guitar solo melody", "acoustic rhythm guitar melody", "groovy bass", "punchy snare", "shimmering cymbals", "electric guitar melody", "violin melody", "passionate", "uptempo", "soulful", "energetic"] | 4 | GuHDy--gWiM | 1758 | |
Pagan's Mind - God's Equation (Live at ProgPower USA X)(HD) | The low quality recording features a live performance of a metal song that consists of manic drums played over aggressive electric guitar melodies and distorted bass guitar. The drums consist of a punchy double pedal kick, punchy snare hits and energetic cymbals. There are some crowd cheering sounds in the background. It sounds aggressive, and energetic overall. | 2010-09-01T16:15:31Z | Pagan's Mind | Pagan's Mind live at ProgPower X in Atlanta, September 2009, performing "God's Equation" as part of the "Returning Heroes" concept. https://www.facebook.com/pagansmind/ http://www.pagansmind.com/ | ["Drum", "Guitar", "Heavy metal", "Music", "Rock music", "Angry music"] | ["low quality", "live performance", "metal", "aggressive", "energetic", "crowd cheering", "manic drums", "aggressive electric guitar melodies", "distorted bass guitar", "punchy double pedal kick", "punchy snare", "energetic cymbals"] | 4 | W7i4LkdSfjw | 3068 |
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;