musiccaps_details (view)
5 rows where musiccaps_aspects contains "4 on the floor kick", musiccaps_aspects contains "clapping" and musiccaps_author = 4
This data as json, CSV (advanced)
musiccaps_aspects (array) 36 ✖
- 4 on the floor kick · 5 ✖
- clapping · 5 ✖
- energetic 4
- electro 3
- addictive 2
- groovy bass 2
- low quality 2
- uptempo 2
- acid bass 1
- addictive synth lead melody 1
- addictive violin melody 1
- echoing male vocal 1
- exotic 1
- groovy 1
- low pitched male vocal 1
- mono 1
- noisy 1
- passionate female vocal 1
- phone recording 1
- quiet snare roll 1
- repetitive synth lead melody 1
- reverberant background music 1
- shimmering hi hats 1
- shimmering shaker 1
- shimmering shakers 1
- short riser 1
- soft crash cymbal 1
- steel drums tropical melody 1
- sweeping sound effects 1
- synth flute melody 1
- synth keys melody 1
- tinny percussive elements 1
- tropical 1
- unbalanced stereo image 1
- urban latin 1
- wide reverberant percussive elements 1
musiccaps_names (array) 15 ✖
- Music 5
- Drum and bass 2
- Afrobeat 1
- Blues 1
- Dance music 1
- Disco 1
- Electronic dance music 1
- Electronica 1
- Heart murmur 1
- House music 1
- Music of Africa 1
- Musical instrument 1
- Techno 1
- Trance music 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 |
---|---|---|---|---|---|---|---|---|---|---|
Evil Techno - Darkness and Magic | The Electro song features an addictive synth lead melody playing over quiet snare roll, some claps and sweeping sound effects. In the second half of the loop, there is a "4 on the floor" kick patter. It is uptempo and it sounds energetic and sort of addictive. | 2011-04-16T14:51:02Z | Xeyrophobic | Download Evil Techno here(The first 8 tracks) ► http://sh.st/ymf9J | ["Drum and bass", "Music", "Techno", "Electronic dance music", "Dance music"] | ["clapping", "noisy", "quiet snare roll", "addictive synth lead melody", "4 on the floor kick", "energetic", "uptempo", "electro", "addictive", "sweeping sound effects"] | 4 | CyFsI_EYFQQ | 1421 | |
Heartbeat of home audition - Ceili Moore | The low quality recording features a reverberant background electro music that consists of claps, "4 on the floor" kick pattern and addictive violin melody. It is in mono and it sounds like it was recorded with a phone in a medium size room, as the music is playing through a speaker. | 2013-04-15T11:22:24Z | ceili moore | ["Heart murmur", "Music"] | ["low quality", "mono", "phone recording", "reverberant background music", "electro", "energetic", "clapping", "4 on the floor kick", "addictive violin melody"] | 4 | GcnLApOeCh0 | 1743 | ||
Pimp My Ride @ carscentral.blogspot.com | The Electro song features a low pitched male vocal talking over "4 on the floor" kick pattern, passionate female vocal melody, acid bass, claps, soft crash cymbal, shimmering hi hats and repetitive synth lead melody. Right before the drop in the second section of the loop, there is a short riser. It sounds energetic, like something you would listen to in clubs. | 2007-07-17T08:04:08Z | eastmail69 | Pimp My Ride @ carscentral.blogspot.com featuring 2 niece & unique bics both powered by steam engine and turbo jet respectively! Visit carscentral.blogspot.com | ["Disco", "Drum and bass", "House music", "Music", "Trance music", "Electronica"] | ["electro", "4 on the floor kick", "low pitched male vocal", "passionate female vocal", "acid bass", "shimmering hi hats", "clapping", "energetic", "short riser", "repetitive synth lead melody", "soft crash cymbal"] | 4 | UBfHLeCBBsA | 2891 | |
Davido -Skelewu lyrics | The Urban Latin song features an echoing male vocal singing repetitive lyrics over wide reverberant percussive elements, synth flute melody, claps, "4 on the floor" kick pattern, shimmering shaker, groovy bass and synth keys melody. It is uptempo and it sounds energetic and addictive, like something you would hear in clubs a lot. | 2013-10-25T20:55:09Z | Tai Kenny | I DO NOT CLAIM TO OWN ANY OF THE AUDIO USED IN THIS VIDEO. NO COPYRIGHT INTENDED!!!! | ["Afrobeat", "Music of Africa", "Music"] | ["urban latin", "wide reverberant percussive elements", "echoing male vocal", "synth flute melody", "clapping", "4 on the floor kick", "shimmering shaker", "groovy bass", "synth keys melody", "uptempo", "energetic", "addictive"] | 4 | ax8hXst_b5g | 3588 | |
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;