musiccaps_details (view)
3 rows where musiccaps_aspects contains "punchy kick" and musiccaps_aspects contains "saxophone solo melody"
This data as json, CSV (advanced)
musiccaps_aspects (array) 21 ✖
- passionate 3
- punchy kick · 3 ✖
- punchy snare 3
- saxophone solo melody · 3 ✖
- jazz 2
- live performance 2
- low quality 2
- shimmering hi hats 2
- electro 1
- energetic 1
- energetic cymbals 1
- filter mod bass 1
- groovy bass 1
- groovy double bass 1
- groovy piano chords 1
- manic tom roll 1
- mellow keys chords 1
- organ keys chords 1
- repetitive echoing electric guitar melody 1
- soulful 1
- upbeat 1
musiccaps_names (array) 13 ✖
- Bass drum 1
- Brass instrument 1
- Cowbell 1
- Drum 1
- Drum kit 1
- Jazz 1
- Keyboard (musical) 1
- Music 1
- Percussion 1
- Piano 1
- Rimshot 1
- Saxophone 1
- Snare drum 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Fender Rhodes Mark VII | The low quality recording features a live performance of a jazz song and it consists of a saxophone solo melody played over mellow keys chords, groovy bass, punchy snare and kick hits and shimmering hi hats. It sounds passionate and soulful. | 2007-01-29T02:12:06Z | alex.rodrigues | Namm Show report on New Rhodes MK 7 http://www.rhodespiano.com/namm_info.htm | ["Jazz", "Music", "Keyboard (musical)", "Piano"] | ["low quality", "jazz", "live performance", "saxophone solo melody", "shimmering hi hats", "punchy kick", "punchy snare", "mellow keys chords", "groovy bass", "passionate", "soulful"] | 4 | Oe_xSG_ic-c | 2455 | |
Las Vegas Strip Time Lapse | The low quality recording features an electro song that consists of a filter modulated bass, repetitive, echoing electric guitar melody, punchy kick and snare hits, shimmering hi hats and a saxophone solo melody played at the end. It sounds passionate and energetic. | 2013-05-25T08:17:27Z | Hadeer Abdulkareem | Boarding the fornt seats in the upper deck of the Deuce bus in Las Vegas May 2013, from Luxor until Circus Circus. This is the time-lapsed video of the trip. | ["Brass instrument", "Saxophone"] | ["low quality", "electro", "filter mod bass", "repetitive echoing electric guitar melody", "punchy kick", "punchy snare", "shimmering hi hats", "saxophone solo melody", "passionate", "energetic"] | 4 | P14zjckYFK0 | 2492 | |
Shirazette Tinnin - Inner Frustration | The low quality recording features a jazz live performance that consists of saxophone solo melody played over energetic cymbals, manic tom roll, punchy snare and kick hits, organ keys chords, groovy double bass and groovy piano chords. It sounds passionate and upbeat. | 2012-08-16T17:50:49Z | Latin Percussion | Shirazette Tinnin visits the LP studio to perform "Inner Frustration." Drums: Shirazette Tinnin Piano : Willerm Delisfort Piano: Rachel Eckroft Guitar: Seth Johnson Bass: Tom DiCarlo Saxophone: Camille Thurman LP LP204A Black Beauty Cowbell LP204A LP Americana Series Peruvian Cajon LP1439 | ["Cowbell", "Drum", "Drum kit", "Rimshot", "Snare drum", "Bass drum", "Percussion"] | ["live performance", "jazz", "saxophone solo melody", "manic tom roll", "energetic cymbals", "punchy snare", "organ keys chords", "groovy double bass", "punchy kick", "groovy piano chords", "passionate", "upbeat"] | 4 | t1ULMDpL35I | 4998 |
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;