musiccaps_details (view)
4 rows where musiccaps_aspects contains "claps" and musiccaps_aspects contains "disco"
This data as json, CSV (advanced)
musiccaps_aspects (array) 31 ✖
- claps · 4 ✖
- disco · 4 ✖
- funky 3
- groovy 3
- passionate 3
- punchy kick 3
- groovy bass 2
- punchy snare 2
- addictive 1
- brass melody 1
- dance 1
- eccentric 1
- electronic drums 1
- flat male vocal 1
- funk 1
- funky bass 1
- funky electric guitar melody 1
- funky synth lead melody 1
- harmonizing background vocals 1
- hip 1
- low quality 1
- organ 1
- passionate female vocal 1
- passionate male vocal 1
- piano melody 1
- shimmering hi hats 1
- simple hi hats 1
- sustained strings melody 1
- synth 1
- synth keys chords 1
- wide funky electric guitar melody 1
musiccaps_names (array) 5 ✖
- Music 4
- Disco 2
- Funk 2
- Exciting music 1
- Soul music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
TF2 Unusual - Hong kong Cone Disco Beat Down | This is a funk piece. It has an electronic drum beat with heavy use of claps in the rhythmic background. A synth with an organ sound is playing the melody, but it is filled with effects, so the sound is constantly changing. A fuzzy sounding bass is playing a funky groove in the background. There is an eccentric atmosphere. This piece could be used in the soundtracks of young-adult cartoons. | 2014-10-24T01:23:46Z | znoc! addme2bro | See Hong Kong Cone on all the classes for your convenience. | ["Disco", "Music"] | ["funk", "electronic drums", "claps", "organ", "synth", "funky bass", "groovy", "eccentric", "hip", "dance", "disco"] | 9 | EC_JNTVDrok | 1539 | |
Sick Funk Jam! Hug Me Squeeze Me! | The Disco song features a passionate female vocalist singing over a funky electric guitar melody, groovy bass, punchy kick and claps. It sounds passionate, funky and groovy - like something you would hear in clubs during the 80s. | 2010-06-21T23:33:22Z | turtle101392 | Debra Hurd- Hug me Squeeze Me | ["Funk", "Music", "Exciting music"] | ["disco", "low quality", "passionate female vocal", "funky electric guitar melody", "groovy bass", "punchy kick", "claps", "passionate", "funky", "groovy"] | 4 | lXrypwLQO3U | 4406 | |
*Classy Freak* | The Disco song features a flat male vocal singing over a wide funky electric guitar melody, groovy bass, synth keys chords, funky synth lead melody, punchy kick, punchy snare layered with some claps and simple hi hats. It sounds passionate, funky and groovy. | 2008-06-22T21:32:10Z | IwYlAj | PLAIR 1984 Label: P.A.R. | ["Funk", "Music"] | ["disco", "wide funky electric guitar melody", "synth keys chords", "funky synth lead melody", "groovy bass", "punchy kick", "punchy snare", "simple hi hats", "claps", "flat male vocal", "passionate", "funky", "groovy"] | 4 | p8xxC2um9xQ | 4688 | |
70's Disco Fever To 20 Songs | The Disco song features a passionate male vocal, alongside harmonizing background vocals, singing over sustained strings melody, piano melody, brass melody, punchy kick and snare hits, shimmering hi hats and some claps. It sounds funky, addictive and passionate - like something you would hear in clubs during the 70s. | 2010-08-16T05:53:04Z | djcrd09 | DJ CRD-These R My Top 20 Disco/Funk Groovin Songs..Enjoy..Hop U Like..Don't Forget 2 Subscribe And Comment djcrd09@yahoo.com | ["Disco", "Music", "Soul music"] | ["disco", "harmonizing background vocals", "passionate male vocal", "sustained strings melody", "piano melody", "brass melody", "punchy kick", "punchy snare", "shimmering hi hats", "claps", "funky", "addictive", "passionate"] | 4 | yzjbAxCnt7U | 5451 |
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;