musiccaps_details (view)
4 rows where musiccaps_aspects contains "clapping", musiccaps_aspects contains "groovy" and musiccaps_author = 4
This data as json, CSV (advanced)
musiccaps_aspects (array) 34 ✖
- clapping · 4 ✖
- groovy · 4 ✖
- low quality 4
- energetic 2
- groovy bass 2
- punchy kick 2
- shimmering hi hats 2
- tinny percussive elements 2
- 4 on the floor kick 1
- commercial music 1
- cool 1
- country blues 1
- crowd chant 1
- exotic 1
- fruity male vocal 1
- groovy electric guitar melodies 1
- groovy synth bass 1
- instrumental 1
- mellow snare 1
- noisy 1
- passionate 1
- reverberant 1
- reverberant percussive elements 1
- shimmering cymbals 1
- shimmering shakers 1
- short brass hit 1
- short synth lead sustained note 1
- soft kick hits 1
- steel drums tropical melody 1
- tropical 1
- unbalanced stereo image 1
- uptempo 1
- vintage 1
- wide echoing effects 1
musiccaps_names (array) 15 ✖
- Music 4
- Blues 2
- Musical instrument 2
- Basketball bounce 1
- Country 1
- Drum machine 1
- Electronica 1
- Music of Latin America 1
- Rhythm and blues 1
- Sampler 1
- Singing 1
- Slam 1
- Swing music 1
- Synthesizer 1
- Wedding music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Roland Aira TR8 - 808 Day 8th August 2017 | The low quality recording features a reverberant instrumental that consists of punchy kick hits, claps, shimmering hi hats, bouncy and tinny percussive elements. There are wide echoing effects at one point of the loop. Sounds energetic and groovy, like something you would hear in underground clubs. | 2015-08-04T19:57:58Z | Carl Nilsson | Famous TR808 beats to celebrate the 8/08 day programmed on the TR8. The last minutes is an improvising jam session. | ["Sampler", "Music", "Musical instrument", "Drum machine", "Synthesizer", "Electronica"] | ["low quality", "reverberant", "instrumental", "clapping", "punchy kick", "shimmering hi hats", "tinny percussive elements", "wide echoing effects", "groovy", "energetic"] | 4 | DLJGT99uEh4 | 1466 | |
Slam Dunk Basketball Session Featuring ACRODUNK - Mega Slam Hoops® | The low quality recording features a commercial music that consists punchy kick, claps, shimmering hi hats, short brass hit layered with short sustained synth lead note, groovy synth bass that sounds like a siren, reverberant percussive elements and crowd chant at the end of the loop. It sounds energetic and groovy. | 2014-02-27T21:59:24Z | megaslamhoops | https://www.megaslamhoops.com ACRODUNK performed a slam dunk clinic to illustrate how they "Slam Like a Pro". Mega Slam Hoops® manufactures the best in ground basketball hoops for outdoor use. The adjustable basketball hoops for sale by Mega Slam Hoops® are designed to last a lifetime, include free shipping, free padding, and made with the thickest steel in the industry. https://www.megaslamhoops.com | ["Basketball bounce", "Music", "Slam"] | ["low quality", "commercial music", "punchy kick", "clapping", "shimmering hi hats", "short brass hit", "crowd chant", "reverberant percussive elements", "groovy synth bass", "energetic", "short synth lead sustained note", "groovy"] | 4 | LfbGHMumxIQ | 2211 | |
Blues, Country Blues, Rhythm & Blues | The low quality recording features a country blues song that consists of fruity male vocal singing over groovy electric guitar melodies, groovy bass, shimmering cymbals, mellow snare, soft kick hits and clapping. The recording is a bit noisy, as it is vintage, and it sounds passionate, groovy, uptempo and cool. | 2010-06-04T21:51:03Z | StrontiumDawg | 3 fine slices of blues music. Got my mojo workin' - Muddy Waters, Frankie - Missisipi John Hurt, Crawling up a hill - John Mayall | ["Blues", "Singing", "Swing music", "Country", "Music", "Rhythm and blues", "Music of Latin America"] | ["low quality", "country blues", "vintage", "noisy", "fruity male vocal", "groovy electric guitar melodies", "groovy bass", "shimmering cymbals", "mellow snare", "soft kick hits", "clapping", "uptempo", "groovy", "passionate", "cool"] | 4 | ZzyWbehtt0M | 3433 | |
Book Now Steel Drum Band Music Beach Weddings in Florida | The low quality recording features a cover with a steel drums tropical melody that plays over the playback instrumental in the background that consists of groovy bass, claps, "4 on the floor" kick pattern, shimmering shakers and tinny percussive elements. It sounds tropical, exotic and groovy, but it also has an unbalanced stereo image. | 2008-02-13T22:51:02Z | RythmTrail | Steel Drum music http://www.rythmtrail.com RythmTrail Tel 866 495 4522 Steel Drum Band and players for beach weddings in Florida. Hire live steel drum music for weddings, parties and corporate events. Never Gonna Give You Up on Steel Drums | ["Blues", "Music", "Musical instrument", "Wedding music"] | ["low quality", "steel drums tropical melody", "groovy bass", "clapping", "4 on the floor kick", "shimmering shakers", "tinny percussive elements", "unbalanced stereo image", "exotic", "groovy", "tropical"] | 4 | hDzmNYd_eaA | 4087 |
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;