musiccaps_details (view)
5 rows where search matches "guitar", musiccaps_aspects contains "groovy", musiccaps_aspects contains "live performance" and musiccaps_aspects contains "passionate"
This data as json, CSV (advanced)
musiccaps_aspects (array) >30 ✖
- groovy · 5 ✖
- live performance · 5 ✖
- passionate · 5 ✖
- groovy bass 4
- low quality 4
- shimmering hi hats 3
- electric guitar melody 2
- funky 2
- jazz 2
- noisy 2
- punchy kick 2
- punchy snare 2
- accordion melody 1
- ambient room noises 1
- average audio quality 1
- country music 1
- cowboys 1
- crowd chattering 1
- echoes 1
- electric guitar 1
- emotional 1
- epic stories 1
- exciting background male vocal 1
- exotic 1
- flat male vocal 1
- folk 1
- funky electric guitar melody 1
- groovy music 1
- groovy piano melody 1
- groovy rhodes keys melody 1
- …
musiccaps_names (array) 18 ✖
- Music 3
- Music of Latin America 2
- Musical instrument 2
- Singing 2
- Accordion 1
- Electric piano 1
- Electronic organ 1
- Guitar 1
- Keyboard (musical) 1
- Orchestra 1
- Organ 1
- Piano 1
- Plucked string instrument 1
- Salsa music 1
- Ska 1
- Speech 1
- Strum 1
- Traditional music 1
youtube_published (date) 5 ✖
- 2009-04-24 1
- 2009-07-03 1
- 2009-11-19 1
- 2009-11-24 1
- 2011-11-22 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
The Good, the Bad and the Ugly / Reel Matawa by California Guitar Trio & Montreal Guitar Trio | The song is an instrumental. The song is medium tempo with a guitar playing lead and several guitarists playing harmony and accompaniment and a pick scratching guitar strings producing a percussive line. The song is immersive and has a classic country gun fight duel vibe to it. The song has ambient room noises. | 2009-11-19T18:55:29Z | MG3 : Montréal Guitare Trio / Montreal Guitar Trio | Montreal Guitar Trio & California Guitar Trio performed The Good, the Bad and the Ugly by Ennio Morricone followed by the Reel Matawa by Richard Forest at Palais Montcalm in Quebec City, October 23, 2009. | ["Guitar", "Music", "Musical instrument", "Strum", "Plucked string instrument"] | ["guitar band", "guitar solo", "scratching tones", "guitar pick percussions", "song covers", "strings scratched with plectrum percussions", "live performance", "live audience", "ambient room noises", "echoes", "average audio quality", "groovy music", "instrumental music", "country music", "tense", "suspense", "gunslingers", "groovy", "story tellers", "the wild west", "emotional", "passionate", "heroes and villains", "legends", "epic stories", "electric guitar", "rhythm guitars", "cowboys"] | 1 | 3w3fD54bNvU | 521 | |
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 |
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;