musiccaps_details (view)
3 rows where musiccaps_aspects contains "energetic", musiccaps_aspects contains "groovy piano chords" and musiccaps_aspects contains "shimmering hi hats"
This data as json, CSV (advanced)
musiccaps_aspects (array) 24 ✖
- energetic · 3 ✖
- groovy piano chords · 3 ✖
- shimmering hi hats · 3 ✖
- low quality 2
- punchy snare 2
- "4 on the floor" kick pattern 1
- addictive 1
- arpeggiated synth melody 1
- buzzy sustained synth lead 1
- claps 1
- drums solo 1
- electro pop 1
- exciting 1
- flat male vocal 1
- latin jazz 1
- low tom roll 1
- mono 1
- noisy 1
- punchy 808 bass 1
- punchy kick 1
- reggae/dub 1
- short reversed snare hit 1
- sustained synth pad chord 1
- wooden percussion 1
musiccaps_names (array) 14 ✖
- Music 2
- Bass drum 1
- Cymbal 1
- Dance music 1
- Disco 1
- Drum 1
- Drum kit 1
- Hi-hat 1
- House music 1
- Keys jangling 1
- Percussion 1
- Reggae 1
- Rimshot 1
- Ska 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Admiral Bailey-Jamaica 80`s Reggae Dancehall- AfricanSymbol Sound | The low quality recording features a reggae/dub song that consists of a flat male vocal singing over punchy 808 bass, punchy snare, shimmering hi hats and groovy piano chords. It sounds energetic, groovy and the recording is noisy and in mono - due to the fact that the sound is coming from the right channel only. | 2010-03-14T21:23:50Z | JAPAMAICAN | African Symbol Soundsystem @Damali Beach Montego Bay,Jamaica,31/Aug/1986 featuring Admiral Bailey and More.ジャマイカ80sサウンドのアフリカンシンボル秘蔵の映像。 http://africansymboljamaica.info http://www.myspace.com/africansymbolja ジャマイカ、モンテゴベイのダマリビーチで催されたフレンド・クラッシュUNIFICATIONⅡのラバダブのステージショー。 1986年8月31日収録。 Admiral Bailey,Echo Minott,Lt.Stichie,Lady G, Wolf Man,White Mice,General Leon...etc | ["Keys jangling", "Music", "Reggae", "Ska"] | ["low quality", "reggae/dub", "mono", "noisy", "flat male vocal", "punchy 808 bass", "punchy snare", "shimmering hi hats", "groovy piano chords", "energetic", "addictive"] | 4 | 03z0rpIkm5g | 115 | |
Mambo/Songo/Solo Drums (Latin Jazz Drumming) | The low quality recording features a latin jazz song played in the background over which a drums solo is played. The solo consists of shimmering hi hats, punchy snare and kick hits and low tom rolls, while the latin jazz song consists of groovy piano chords and wooden percussion. It sounds energetic and exciting. | 2011-05-13T11:31:17Z | Thomas Sienko | Mambo and Songo from Tommy Igoe's Groove Essentials. Groove 41 Fast, Groove 42 Slow. Hope you enjoy! | ["Cymbal", "Drum", "Drum kit", "Hi-hat", "Rimshot", "Bass drum", "Percussion"] | ["low quality", "latin jazz", "groovy piano chords", "wooden percussion", "drums solo", "punchy kick", "punchy snare", "low tom roll", "shimmering hi hats", "energetic", "exciting"] | 4 | MrMXYO2fzJ4 | 2303 | |
Whitney Houston - How will i know ( NDA & RATAJ Remix ) | The Electro Pop song features a buzzy sustained synth lead, "4 on the floor" kick, short reversed snare hits, claps, shimmering hi hats, groovy piano chords, sustained synth pad chord and arpeggiated synth melody. It sounds energetic and like something you would hear in clubs. | 2012-02-14T20:54:46Z | TED Thunder | Remix utworu Whitney Houston "How will i know" wykonany przez dwóch kościańskich DeeJay'i, Chrupka aka.NDA oraz RATAJA ! Miłego słuchania !! http://www14.zippyshare.com/v/87458949/file.html Kościan 14.02.2012 | ["Disco", "House music", "Music", "Dance music"] | ["electro pop", "buzzy sustained synth lead", "\"4 on the floor\" kick pattern", "short reversed snare hit", "claps", "shimmering hi hats", "groovy piano chords", "sustained synth pad chord", "energetic", "arpeggiated synth melody"] | 4 | Tsmx6Pb7CnU | 2874 |
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;