musiccaps_details (view)
3 rows where search matches "guitar", musiccaps_aspects contains "jazz", musiccaps_aspects contains "shimmering hi hats" and musiccaps_author = 4
This data as json, CSV (advanced)
musiccaps_aspects (array) 21 ✖
- jazz · 3 ✖
- low quality 3
- noisy 3
- passionate 3
- shimmering hi hats · 3 ✖
- electric guitar melody 2
- funky 2
- groovy 2
- groovy bass 2
- live performance 2
- punchy kick 2
- applause 1
- funky electric guitar melody 1
- groovy piano chords 1
- groovy rhodes keys melody 1
- mono 1
- punchy snare 1
- reverberant 1
- snappy snare 1
- synth pad 1
- wide passionate harmonizing male vocals 1
musiccaps_names (array) 10 ✖
- Electric piano 1
- Electronic organ 1
- Guitar 1
- Jazz 1
- Keyboard (musical) 1
- Music 1
- Organ 1
- Piano 1
- Plucked string instrument 1
- Ska 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
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 | |
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 | |
Otis Rush - Sweet Little Angel - Berlin 1966 - one of his best performances | The low quality recording features a jazz song that consists of electric guitar melody, shimmering hi hats, snappy snare, groovy piano melody and some applause at the very beginning of the loop. The recording is noisy and it sounds passionate and reverberant. | 2009-06-20T04:10:47Z | gollincho | Otis Rush ;V/g , Little Brother Montgomery ; p , Jack Myers ; b , Fred Below ; d , Berlin ,16 Oct 1966 | ["Guitar", "Jazz", "Music", "Plucked string instrument"] | ["low quality", "applause", "noisy", "jazz", "electric guitar melody", "shimmering hi hats", "snappy snare", "groovy piano chords", "passionate", "reverberant"] | 4 | tMMjurLqYJQ | 5030 |
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;