musiccaps_details (view)
3 rows where musiccaps_aspects contains "passionate" and musiccaps_names contains "Bass drum" sorted by musiccaps_caption
This data as json, CSV (advanced)
musiccaps_aspects (array) 38 ✖
- passionate · 3 ✖
- punchy snare 2
- addictive 1
- brush work 1
- buzzy synth lead melody 1
- dance rhythm 1
- dancing all night 1
- dj 1
- documentary soundtrack 1
- energetic crash cymbal 1
- energetic cymbals 1
- entertaining 1
- fast tempo 1
- funk music 1
- groovy bass 1
- groovy bass line 1
- groovy double bass 1
- groovy piano chords 1
- instrumental music 1
- jazz 1
- jazz fusion 1
- jazz music 1
- live performance 1
- low quality 1
- manic tom roll 1
- modern jazz hits 1
- noisy 1
- organ keys chords 1
- piano accompaniment 1
- punchy kick 1
- relaxing 1
- saxophone solo melody 1
- sophisticated 1
- techno jazz line 1
- thin kick hits 1
- upbeat 1
- wide harmonizing vocals 1
- wide toms 1
video | youtube_link | musiccaps_caption ▼ | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
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 | |
x..FirstLady..x Not okay with change | The low quality recording features a wide harmonizing vocals singing over wide toms, groovy bass, punchy snare, energetic crash cymbal, thin kick hits and buzzy synth lead melody. It sounds passionate and addictive thanks to that synth lead. The recording is noisy. | 2007-04-02T12:17:54Z | Susan Harrison | FABB song :p | ["Drum", "Drum kit", "Drum roll", "Rimshot", "Snare drum", "Bass drum", "Percussion"] | ["low quality", "wide harmonizing vocals", "wide toms", "punchy snare", "groovy bass", "thin kick hits", "buzzy synth lead melody", "addictive", "passionate", "energetic crash cymbal", "noisy"] | 4 | ow12iGt8z5Q | 4667 | |
Molecular Gastronomy - Molecular Egg Recipe | The song is an instrumental. The tempo is fast with a groovy jazz drumming rhythm with good brush works, strong bass line, piano accompaniment and various percussion hits. The song is groovy and energetic. The song is jazz fusion. | 2014-04-17T14:56:18Z | MOLECULE-R | Make a Molecular Egg with our Cuisine R-Evolution Kit and Receive 5$ to discover it here by subscribing to our newsletter: https://molecule-r.com/pages/about-molecule-r#news Click here to receive our 40 Free Recipe E-book: https://www.molecule-r.com/free-e-book More Molecule-R products here : https://molecule-r.com/collections/all-products | ["Cymbal", "Drum", "Drum kit", "Hi-hat", "Rimshot", "Snare drum", "Bass drum", "Percussion"] | ["jazz music", "groovy bass line", "jazz fusion", "dance rhythm", "dj", "modern jazz hits", "documentary soundtrack", "dancing all night", "sophisticated", "piano accompaniment", "brush work", "fast tempo", "instrumental music", "relaxing", "passionate", "techno jazz line", "funk music", "entertaining"] | 1 | f8QGA4vN6HY | 3924 |
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;