musiccaps_details (view)
3 rows where musiccaps_aspects contains "jazz", musiccaps_aspects contains "live performance" and musiccaps_aspects contains "mono"
This data as json, CSV (advanced)
musiccaps_aspects (array) 23 ✖
- jazz · 3 ✖
- live performance · 3 ✖
- low quality 3
- mono · 3 ✖
- noisy 3
- groovy bass 2
- passionate 2
- punchy snare 2
- shimmering hi hats 2
- electric guitar melody 1
- funky 1
- groovy 1
- groovy piano melody 1
- groovy rhodes keys melody 1
- groovy soft drums 1
- passionate female vocal 1
- punchy kick 1
- saxophone melody 1
- saxophone solo 1
- shoe tapping 1
- smooth bass 1
- soft kick hits 1
- soulful 1
musiccaps_names (array) 11 ✖
- Music 2
- Blues 1
- Electric piano 1
- Electronic organ 1
- Harmonic 1
- Jazz 1
- Keyboard (musical) 1
- Organ 1
- Piano 1
- Singing 1
- Tap 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 | |
Tap Dance Battle | The low quality recording features a jazz song that consists of groovy soft drums, smooth bass and saxophone solo, over which there is shoe tapping. It sounds like it is a live performance and like something you would watch in a theatre. It is a bit noisy and in mono. | 2007-04-27T07:01:54Z | mapha25 | Beautiful manifestation of talent from these amazing tap dancers. | ["Music", "Tap"] | ["low quality", "mono", "jazz", "shoe tapping", "noisy", "saxophone solo", "smooth bass", "groovy soft drums", "live performance"] | 4 | IwdjPDw6o5I | 1953 | |
Shirley King - Let The Good Times Roll | The low quality recording features a live performance of a jazz song and it consists of a passionate female vocalist singing over groovy piano melody, saxophone melody, groovy bass, shimmering hi hats, punchy snare and soft kick hits. It sounds passionate, soulful and the recording is noisy and in mono. | 2008-11-26T05:14:33Z | Bob .Hampton | Daughter of the Blues Shirley King on B.B King's "Let The Good Times Roll". Performed at the VFW in Berwyn, IL at a benefit for Big Time Sarah's church | ["Blues", "Singing", "Jazz", "Music", "Harmonic"] | ["low quality", "live performance", "passionate female vocal", "groovy piano melody", "saxophone melody", "groovy bass", "shimmering hi hats", "punchy snare", "soft kick hits", "jazz", "passionate", "soulful", "noisy", "mono"] | 4 | mFcHGbnNtSQ | 4456 |
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;