musiccaps_details (view)
3 rows where musiccaps_aspects contains "claps" and musiccaps_aspects contains "groovy synth keys"
This data as json, CSV (advanced)
musiccaps_aspects (array) 29 ✖
- claps · 3 ✖
- groovy synth keys · 3 ✖
- low quality 3
- energetic 2
- exciting 2
- fun 2
- groovy bass 2
- shimmering hi hats 2
- addictive 1
- background male vocals 1
- chiptune 1
- funky electric guitar 1
- groovy 1
- happy 1
- high pitched vocal 1
- house 1
- joyful 1
- laser synth fx 1
- mono 1
- muddy 1
- passionate male vocal 1
- pop 1
- punchy "4 on the floor" kick pattern 1
- punchy 808 bass 1
- punchy kick 1
- repetitive synth lead melody 1
- shimmering shakers 1
- synth lead melody 1
- wide tinny percussions 1
musiccaps_names (array) 9 ✖
- Music 3
- Dance music 1
- Disco 1
- Electronica 1
- House music 1
- Middle Eastern music 1
- Rhythm and blues 1
- Soul music 1
- Techno 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
TALL BOY - HAR MAR SUPERSTAR (Official Music Video) | The low quality recording features a pop song that consists of a passionate male vocal, alongside background male vocals, singing over punchy 808 bass, claps, shimmering hi hats, wide tinny percussion, repetitive synth lead melody and groovy synth keys melody. It sounds groovy, addictive and exciting - like something you would hear in a club. | 2009-09-30T18:50:07Z | HarMarSuperstar | Har Mar Superstar, Eva Mendes, Alia Shawkat, Eric Wareheim, and a bevy of intergalactic beauties get wet and sparkly. Produced and directed by Tomorrow's Brightest Minds. For more information about Har Mar -- the man & his music -- visit harmarsuperstar.com. | ["Music", "Middle Eastern music", "Rhythm and blues", "Dance music"] | ["low quality", "pop", "wide tinny percussions", "punchy 808 bass", "groovy synth keys", "passionate male vocal", "background male vocals", "repetitive synth lead melody", "groovy", "addictive", "exciting", "claps", "shimmering hi hats"] | 4 | 2SenLjPbGzU | 366 | |
Youtube mix - Deep, Soulful, Underground Part 6 | The low quality recording features an electro house song that consists of punchy "4 on the floor" kick pattern, claps, funky electric guitar melody, groovy synth keys, groovy bass that glues everything together and shimmering shakers. It sounds a bit muddy, but also energetic, fun and exciting - like something you would hear in clubs during 70s and 80s a lot. | 2007-07-07T04:25:13Z | laurentkm3 | Cue Kids -- Fruity Grooves part 2 (In Love) Cajmere feat Dajae--Brighter Days (Original Mix) Laurent presents Center of the Earth Music - The Deep.The Soulful.The Underground. I do a live one hour deep, soulful, and underground mix show from 11am-noon every Tuesday EST at http://www.faderwave.net/ Just go to the website and look at the top left hand side where it says "TUNE IN NOW!" ENJOY!!!!! | ["House music", "Music", "Techno", "Soul music", "Electronica"] | ["low quality", "mono", "house", "punchy \"4 on the floor\" kick pattern", "claps", "funky electric guitar", "groovy synth keys", "groovy bass", "shimmering shakers", "energetic", "exciting", "fun", "muddy"] | 4 | EmSZKb0LdVM | 1587 | |
Alvin - Macarena | The low quality recording features a Chiptune music that consists of a high pitched vocal singing over groovy synth keys, synth lead melody, laser synth effects, punchy kick, claps, shimmering hi hats and groovy synth bass. It sounds energetic, fun, happy and joyful - like something kids would listen to. | 2008-03-23T23:02:32Z | xXxValerio94xXx | Alvin And The Chipmunks - Macarena | ["Disco", "Music"] | ["low quality", "chiptune", "high pitched vocal", "groovy synth keys", "synth lead melody", "laser synth fx", "punchy kick", "claps", "shimmering hi hats", "groovy bass", "energetic", "fun", "happy", "joyful"] | 4 | gpNzFsxwy5k | 4057 |
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;