musiccaps_details (view)
5 rows where search matches "guitar", musiccaps_aspects contains "passionate" and musiccaps_aspects contains "uptempo" sorted by youtube_id
This data as json, CSV (advanced)
Suggested facets: youtube_published (date)
musiccaps_aspects (array) 38 ✖
- low quality 5
- passionate · 5 ✖
- uptempo · 5 ✖
- noisy 4
- energetic 3
- groovy bass 3
- live performance 3
- shimmering cymbals 3
- mono 2
- punchy snare 2
- acoustic rhythm guitar chords 1
- acoustic rhythm guitar melody 1
- banjo solo melody 1
- clapping 1
- cool 1
- country 1
- country blues 1
- crowd noises 1
- electric guitar melody 1
- electric guitar solo melody 1
- energetic drums 1
- folk 1
- fruity male vocal 1
- groovy 1
- groovy bass guitar 1
- groovy double bass 1
- groovy electric guitar melodies 1
- groovy organ keys 1
- mellow snare 1
- punchy kick 1
- soft kick hits 1
- soulful 1
- spanish guitar solo melody 1
- steel guitar solo melody 1
- sustained string melody 1
- vintage 1
- violin melody 1
- wide clapping 1
musiccaps_names (array) 18 ✖
- Music 4
- Guitar 3
- Musical instrument 3
- Plucked string instrument 3
- Banjo 2
- Bluegrass 2
- Swing music 2
- Blues 1
- Country 1
- Electric piano 1
- Electronic organ 1
- Jazz 1
- Keyboard (musical) 1
- Music of Latin America 1
- Organ 1
- Piano 1
- Rhythm and blues 1
- Singing 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id ▼ | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Tony Lucas & Kris Brooks Shouting Music Praise Break Pt.1 | The low quality recording features groovy organ keys played over punchy kick and snare hits, shimmering cymbals and groovy bass guitar. It sounds energetic, passionate and uptempo. The recording is noisy. | 2009-10-12T04:12:24Z | Ovaljean | Tony Lucas & Kris Brooks playing Shouting Music at Temple St. Jude. Filmed by Anthony Holston, Ovaljean Productions | ["Organ", "Electric piano", "Electronic organ", "Keyboard (musical)", "Piano"] | ["low quality", "uptempo", "noisy", "groovy organ keys", "punchy snare", "punchy kick", "groovy bass guitar", "shimmering cymbals", "energetic", "passionate"] | 4 | 6gTrMRQPZMU | 776 | |
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 | |
Blues, Country Blues, Rhythm & Blues | The low quality recording features a country blues song that consists of fruity male vocal singing over groovy electric guitar melodies, groovy bass, shimmering cymbals, mellow snare, soft kick hits and clapping. The recording is a bit noisy, as it is vintage, and it sounds passionate, groovy, uptempo and cool. | 2010-06-04T21:51:03Z | StrontiumDawg | 3 fine slices of blues music. Got my mojo workin' - Muddy Waters, Frankie - Missisipi John Hurt, Crawling up a hill - John Mayall | ["Blues", "Singing", "Swing music", "Country", "Music", "Rhythm and blues", "Music of Latin America"] | ["low quality", "country blues", "vintage", "noisy", "fruity male vocal", "groovy electric guitar melodies", "groovy bass", "shimmering cymbals", "mellow snare", "soft kick hits", "clapping", "uptempo", "groovy", "passionate", "cool"] | 4 | ZzyWbehtt0M | 3433 | |
Swing Amor "Rose Room" | The low quality recording features a live performance that consists of a Spanish guitar solo melody, groovy double bass and acoustic rhythm guitar chords. The recording is noisy, in mono and it sounds passionate and uptempo - like something you would dance to with your friends in a latin club. | 2008-12-02T16:54:14Z | hailletmusic | About SWING AMOR A gypsy swing band formed in 2004. Currently, the band performs in cafes and such based in Kumamoto Prefecture.In April 2006, their first album GYPSY SWING JAZZ was released. It includs 12 gems, from originals to standard Jazz tunes. In July 2007, they participated in a compilation album "DJANGO FESTIVAL4" which was released by a long-established Norwegian gypsy jazz label. In January 2009 the distribution of GYPSY SWING JAZZ will begin via iTunes stores in 22 nations. The recording of their second album, three years after the first, is scheduled as well. | ["Swing music", "Guitar", "Jazz", "Music", "Musical instrument", "Plucked string instrument", "Bluegrass"] | ["low quality", "spanish guitar solo melody", "live performance", "groovy double bass", "acoustic rhythm guitar chords", "noisy", "mono", "passionate", "uptempo"] | 4 | iUHqyjf3NcQ | 4191 | |
EARL SCRUGGS & STEVE MARTIN - DUELING BANJOS-EARLSCRUGGS DEAD AT 88-WEB-GIFTS.COM | The low quality recording features a live performance of a country song and it consists of banjo solo melody and electric guitar melody going back and forth, energetic drums, groovy bass and sustained strings melody playing in the background. The recording is noisy and in mono, and it sounds energetic and passionate. | 2012-03-29T13:51:03Z | TINKER2ELVIS | Scruggs died Wednesday morning at age 88 of natural causes. The legacy he helped build with bandleader Bill Monroe, guitarist Lester Flatt and the rest of the Blue Grass Boys was evident all around Nashville, where he died in an area hospital. His string-bending, mind-blowing way of picking helped transform a regional sound into a national passion. "It's not just bluegrass, it's American music," bluegrass fan turned country star Dierks Bentley said. "There's 17- or 18-year-old kids turning on today's country music and hearing that banjo and they have no idea where that came from. That sound has probably always been there for them and they don't realize someone invented that three-finger roll style of playing. You hear it everywhere | ["Banjo", "Guitar", "Music", "Musical instrument", "Plucked string instrument", "Bluegrass"] | ["low quality", "mono", "noisy", "live performance", "banjo solo melody", "electric guitar solo melody", "energetic drums", "groovy bass", "sustained string melody", "energetic", "passionate", "country", "uptempo"] | 4 | nqd7mXvHupU | 4581 |
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;