musiccaps_details (view)
6 rows where search matches "guitar", musiccaps_aspects contains "groovy", musiccaps_aspects contains "groovy bass" and musiccaps_aspects contains "live performance"
This data as json, CSV (advanced)
musiccaps_aspects (array) >30 ✖
- groovy · 6 ✖
- groovy bass · 6 ✖
- live performance · 6 ✖
- low quality 6
- passionate 4
- shimmering hi hats 4
- electric guitar melody 3
- punchy kick 3
- punchy snare 3
- flat male vocal 2
- funky 2
- jazz 2
- noisy 2
- accordion melody 1
- brass melody 1
- crowd chattering 1
- crowd cheering 1
- crowd clapping 1
- electric guitar solo melody 1
- energetic 1
- exciting 1
- exciting background male vocal 1
- exotic 1
- folk 1
- fun 1
- funky electric guitar melody 1
- groovy piano melody 1
- groovy rhodes keys melody 1
- harmonizing male vocals 1
- mono 1
- …
musiccaps_names (array) 17 ✖
- Music 3
- Music of Latin America 3
- Singing 3
- Salsa music 2
- Accordion 1
- Electric piano 1
- Electronic organ 1
- Keyboard (musical) 1
- Musical instrument 1
- Orchestra 1
- Organ 1
- Piano 1
- Punk rock 1
- Rock music 1
- Ska 1
- Speech 1
- Traditional music 1
youtube_published (date) 6 ✖
- 2009-04-24 1
- 2009-07-03 1
- 2009-11-24 1
- 2011-11-22 1
- 2015-11-13 1
- 2016-07-09 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
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 | |
Voltio - Medley De Salsa Carcelaria (Video En Vivo Desde Oso Blanco) | The low quality recording features a live performance of an urban latin song that consists of flat male vocal singing over groovy piano melody, groovy bass guitar, wooden percussive elements, wide toms, warm brass melody and widely spread claps. There is a short, exciting background male vocal in the middle of the loop. It sounds exotic, groovy and passionate. | 2009-11-24T21:07:11Z | VoltioVEVO | Music video by Voltio performing Medley De Salsa Carcelaria. (C) 2008 SONY BMG MUSIC ENTERTAINMENT (US Latin) LLC YouTube view counts pre-VEVO: 878 | ["Singing", "Music", "Music of Latin America", "Salsa music"] | ["low quality", "live performance", "urban latin", "wooden percussive elements", "wide toms", "warm brass", "groovy piano melody", "groovy bass", "flat male vocal", "wide claps", "passionate", "exotic", "groovy", "exciting background male vocal"] | 4 | FEuXIeWoCQQ | 1628 | |
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 | |
Reply1988 Go Kyung-pyo-Ryu Jun-yeol-Lee Dong-hwi, chnages to 'Fire Engine' for Hye-ri 151113 EP3 | The low quality recording features a live performance of a pop song that consists of harmonizing male vocals singing over punchy kick and snare, shimmering hi hats, groovy bass, brass melody and electric guitar melody. There are some crowd clapping and cheering sounds in the background. It sounds energetic, exciting and groovy. | 2015-11-13T12:53:53Z | tvN drama | tvN Family Comedy Drama Reply 1988 Every Fri-Sat 7:50PM Broadcast | ["Singing", "Music of Latin America"] | ["live performance", "low quality", "crowd clapping", "crowd cheering", "pop", "harmonizing male vocals", "punchy snare", "punchy kick", "shimmering hi hats", "groovy bass", "brass melody", "electric guitar melody", "groovy", "energetic", "exciting"] | 4 | oBBTqXQFTiA | 4608 | |
Si Tus Amigas Te Cuentan || La Timba Criolla || PERÚ MUSIC 2016 || SALSA KING | The low quality recording features a live performance with flat male vocals talking over electric guitar solo melody, shimmering and bright drums cymbals, snappy rimshots, groovy bass and simple piano chord progression. Sounds fun and groovy - like something you would dance to with your friends. | 2016-07-09T20:26:50Z | PERÚ MUSIC | AUDIO EXCELENTE SÍGUENOS EN FACEBOOK COMO PERÚ MUSIC https://www.facebook.com/Per%C3%BA-Music 865450980253654/?fref=ts | ["Music", "Punk rock", "Rock music", "Salsa music"] | ["low quality", "live performance", "electric guitar solo melody", "shimmering bright cymbals", "snappy rimshot", "groovy bass", "simple piano chord progression", "flat male vocal", "groovy", "fun"] | 4 | usrzF-0GbLY | 5141 |
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;