musiccaps_details (view)
8 rows where search matches "guitar", musiccaps_aspects contains "live performance", musiccaps_aspects contains "passionate" and musiccaps_aspects contains "shimmering hi hats"
This data as json, CSV (advanced)
musiccaps_aspects (array) >30 ✖
- live performance · 8 ✖
- low quality 8
- passionate · 8 ✖
- shimmering hi hats · 8 ✖
- noisy 5
- electric guitar melody 4
- emotional 4
- groovy bass 4
- punchy kick 4
- punchy snare 4
- groovy 3
- groovy bass guitar 3
- crowd clapping 2
- funky 2
- funky electric guitar melody 2
- jazz 2
- mono 2
- accordion melody 1
- acoustic rhythm guitar 1
- addictive 1
- classical 1
- crowd chattering 1
- distorted 1
- energetic 1
- folk 1
- folk rock 1
- groovy piano melody 1
- groovy rhodes keys melody 1
- harmonizing background vocals 1
- harmonizing vocals 1
- …
musiccaps_names (array) 25 ✖
- Music 6
- Singing 5
- Ska 2
- Song 2
- /t/dd00003 1
- Accordion 1
- Choir 1
- Christmas music 1
- Country 1
- Electric piano 1
- Electronic organ 1
- Gospel music 1
- Guitar 1
- Keyboard (musical) 1
- Music of Latin America 1
- Musical instrument 1
- Orchestra 1
- Organ 1
- Piano 1
- Pop music 1
- Rock and roll 1
- Rock music 1
- Speech 1
- Traditional music 1
- Wedding music 1
youtube_published (date) 8 ✖
- 2007-12-08 1
- 2009-04-24 1
- 2009-07-03 1
- 2010-09-19 1
- 2011-11-22 1
- 2012-03-10 1
- 2012-04-20 1
- 2014-12-23 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Sweet Memories- Tess Sears tribute to her mom Dawn Sears | The low quality recording features a classical live performance of sustained violin melody, shimmering hi hats, electric guitar melody, theremin solo melody and subtle female vocals at the end of the loop. There are some crowd clapping sounds in the background. It is noisy, in mono and it sounds passionate and emotional. | 2014-12-23T23:40:06Z | Tesla Dawn | Tess Sears sings her moms song Sweet Memories in memory of her mother Dawn Sears at the first Monday night Time Jumper meeting after her passing. | ["Singing", "Country", "Guitar", "Music", "Wedding music"] | ["classical", "sustained violin melody", "crowd clapping", "shimmering hi hats", "theremin solo", "subtle female vocal", "live performance", "electric guitar melody", "low quality", "noisy", "mono", "passionate", "emotional"] | 4 | -WvVG0wHcTc | 57 | |
Samuel Rossi Orchestra Ringo Story Goleada polka | The low quality recording features a live performance of a folk song that consists of an accordion melody playing over groovy bass, shimmering hi hats, punchy snare and electric guitar melody. There are crowd chattering noises in the background. It sounds passionate and groovy. | 2009-07-03T12:40:13Z | Tuttofisa | Samuel Rossi Orchestra Ringo Story Goleada polka | ["Singing", "Traditional music", "Music", "Musical instrument", "Orchestra", "Speech", "Music of Latin America", "Accordion"] | ["low quality", "live performance", "crowd chattering", "folk", "groovy bass", "accordion melody", "electric guitar melody", "shimmering hi hats", "punchy snare", "passionate", "groovy"] | 4 | ChqJYrmQIN4 | 1394 | |
Brian Auger - Compared to what (Live at Baked Potato) | The low quality recording features a live performance of a jazz song and it consists of a groovy bass guitar, groovy rhodes keys, electric guitar melody, shimmering hi hats, punchy kick and punchy snare hits. It sounds groovy, funky and passionate. The recording is noisy and in mono. | 2011-11-22T14:17:10Z | Bluedreams | The Brian Auger's Oblivion express live at "Baked Potato", Hollywood 2004. The Band is: Brian Auger - Hammond Organ, Keyboards and Electric piano Savannah Grace Auger - Vocals Derek Frank - Bass Karma D. Auger - Drums | ["Organ", "Electric piano", "Electronic organ", "Keyboard (musical)", "Piano"] | ["low quality", "jazz", "live performance", "mono", "noisy", "groovy bass", "groovy rhodes keys melody", "electric guitar melody", "shimmering hi hats", "punchy kick", "punchy snare", "funky", "groovy", "passionate"] | 4 | CrkxrgTiVyk | 1410 | |
Norske Artister - Venn | The low quality recording features a live performance of a rock song that contains harmonizing background vocals, alongside passionate female vocals, singing over wide electric guitar melody, punchy snare, groovy bass, punchy kick and shimmering hi hats and crash cymbals. It sounds emotional, passionate and addictive - thanks to that cadence. | 2007-12-08T21:06:41Z | Primož Dimnik | Norske Artister - Venn (Live) Espen Lind, Lene Marlin, Sivert Hoyem, Thomas Dybdahl; Espen Lind, Lene Marlin, Bertine Zetlitz, Sissel Kyrkjebø, Kurt Nilsen; Ravi, Morten Abel, ... | ["Singing", "Music", "Choir"] | ["low quality", "live performance", "rock", "harmonizing background vocals", "passionate female vocals", "wide electric guitar melody", "punchy snare", "groovy bass", "punchy kick", "shimmering hi hats", "emotional", "passionate", "addictive", "shimmering crash cymbal"] | 4 | EsssGCL-Axw | 1597 | |
Chuck Berry and Etta James - Rock N Roll Music | The low quality recording features a live performance of a rock & roll song performed by passionate female vocal and male vocal ad libs, followed by groovy piano melody, funky electric guitar melody, groovy bass guitar, shimmering hi hats, punchy snare and soft kick hits. It is a bit noisy and there are some subtle microphone feedback sounds in the middle of the performance. It sounds energetic, vintage and passionate. | 2012-03-10T00:09:38Z | John1948ThreeA | Chuck Berry (Charles Edward Anderson Berry - born Oct. 18, 1926, St. Louis, Mo., U.S.) singer, songwriter, and guitarist who was one of the most popular and influential performers in rhythm-and-blues and rock-and-roll music in the 1950s, '60s, and '70s. Raised in a working-class African-American neighbourhood on the north side of the highly segregated city of St. Louis, Berry grew up in a family proud of its African-American and Native-American ancestry. He gained early exposure to music through his family's participation in the choir of the Antioch Baptist Church, through the blues and country-western music he heard on the radio, and through music classes, especially at Sumner High School. Berry was still attending high school when he was sent to serve three years for armed robbery at a Missouri prison for young offenders. After his release and return to St. Louis, he worked at an auto plant, studied hairdressing, and played music in small nightclubs. Berry traveled to Chicago in search of a recording contract; Muddy Waters directed him to the Chess brothers. Leonard and Phil Chess signed him for their Chess label, and in 1955 his first recording session produced Maybellene (a country-and-western-influenced song that Berry had originally titled Ida Red), which stayed on the pop charts for 11 weeks, cresting at number five. Berry followed this success with extensive tours and hit after hit, including Roll Over Beethoven (1956), School Day (1957), Rock and Roll Music (1957), Sweet Little Sixteen (1958), Johnny B. Goode (1958), and Reelin' and Rockin' (1958). His vivid descriptions of consumer culture and teenage life, the distinctive sounds he coaxed from his guitar, and the rhythmic and melodic virtuosity of his piano player (Johnny Johnson) made Berry's songs staples in the repertoire of almost every rock-and-roll band. At the peak of his popularity, federal authorities prosecuted Berry for violating the Mann Act, alleging that he transported an underage female across state lines for immoral purposes. After tw… | ["Singing", "Music", "Pop music", "Rock music", "Ska", "Song", "Rock and roll"] | ["low quality", "male vocal ad libs", "passionate female vocal", "shimmering hi hats", "punchy snare", "soft kick", "groovy bass guitar", "funky electric guitar melody", "groovy piano melody", "rock & roll", "live performance", "subtle microphone feedback", "noisy", "energetic", "passionate", "vintage"] | 4 | QZoclbefgak | 2628 | |
Chiquilla. Interpretacion GRUPO FREE SOUNDS de Ensenada, BC | The low quality recording features a live performance of a regional Mexican song and it consists of passionate male vocal singing over groovy bass guitar, mellow synth keys melody and electric guitar melody, followed by shimmering tambourine, hi hats and punchy kick. It sounds passionate, emotional and soulful - like something you would hear at family gathering events. | 2012-04-20T18:44:22Z | victor lopez | PRESENTACION EN EL PROGRAMA LA VELADA DE SINTESIS TELEVISION TIJUANA (DERECHOS RESERVADOS) DEL GRUPO MUSICAL FREE SOUNDS DE ENSENADA, BC | ["Christmas music", "Gospel music", "Music", "Song"] | ["low quality", "live performance", "regional mexican", "passionate male vocal", "groovy bass guitar", "soft synth keys melody", "shimmering tambourine", "punchy kick", "electric guitar melody", "noisy", "passionate", "emotional", "soulful", "shimmering hi hats"] | 4 | RNwiEsjrhiQ | 2694 | |
Jon Cleary - When You Get Back (Live at Jazz Fest 2007) | The low quality recording features a live performance of a jazz song that consists of a wide passionate, harmonizing male vocals singing over punchy snare and kick hits, shimmering hi hats, groovy bass guitar, synth pad and funky electric guitar melody. It sounds funky, groovy and passionate. | 2009-04-24T23:01:22Z | Jon Cleary | Jon Cleary live at the New Orleans Jazz & Heritage Festival Follow Jon https://www.facebook.com/jonclearymusicofficial/ https://www.instagram.com/jonclearymusic/ https://twitter.com/jonclearymusic http://www.bandsintown.com/JonCleary | ["Ska"] | ["low quality", "noisy", "jazz", "live performance", "synth pad", "groovy bass", "funky electric guitar melody", "wide passionate harmonizing male vocals", "punchy kick", "punchy kick", "shimmering hi hats", "funky", "groovy", "passionate"] | 4 | _y07ENAx2_E | 3503 | |
Tracy Chapman and Bruce Springsteen - My Hometown (Live 2004) | The low quality recording features a live performance of a folk rock song that consists of harmonizing vocals singing over shimmering hi hats, snappy rimshots, groovy bass guitar and acoustic rhythm guitar, followed by some crowd claps. It sounds messy, muddy and distorted, but still emotional and passionate too. | 2010-09-19T11:10:04Z | Tracy Chapman Online | ♥ Subscribe our newsletter ► https://www.about-tracy-chapman.net/newsletter/ ♥ ♥ Subscribe Tracy Chapman Youtube Channel ► http://www.youtube.com/tchapmanfan ♥ See also ► Fan website : http://www.about-tracy-chapman.net/ ► Facebook: https://www.facebook.com/tracychapmanonline ► Instagram https://instagram.com/tracychapmanonline ► Twitter: https://twitter.com/tchapmanonline Order Tracy Chapman’s "Greatest Hits" on iTunes http://apple.co/1RtSdDu | Amazon: http://hyperurl.co/TC-GH Tracy Chapman and Bruce Springsteen perform "My hometown" in 2004. Low Quality rare video. | ["Singing", "Music", "/t/dd00003"] | ["low quality", "live performance", "folk rock", "distorted", "shimmering hi hats", "harmonizing vocals", "groovy bass guitar", "acoustic rhythm guitar", "snappy rimshots", "crowd clapping", "messy", "muddy", "emotional", "passionate"] | 4 | aPQTrv2B1sw | 3536 |
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;