musiccaps_details (view)
3 rows where musiccaps_aspects contains "energetic", musiccaps_aspects contains "shimmering hi hats" and musiccaps_names contains "Rhythm and blues"
This data as json, CSV (advanced)
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Big Mama Sound - Dub Plate Mix | The low quality recording features a reggae song sung by low flat male vocals, followed by repetitive synth lead melody, groovy bass, vocal chants, claps, punchy kick hits, shimmering hi hats and open hats. It sounds energetic, suspenseful and it is in mono. At one point the vocal cracks and it sounds out of tune for a split second. | 2010-01-06T22:42:54Z | Lila2339 | Big Mama Sound - Dub Plate Mix | ["Music", "Rhythm and blues", "Zing"] | ["low quality", "reggae", "low flat male vocal", "repetitive synth lead melody", "groovy bass", "punchy kick", "clapping", "shimmering hi hats", "shimmering open hat", "vocal chants", "energetic", "suspenseful", "mono", "voice crack"] | 4 | AcX1B_Pr-RQ | 1145 | |
BADDA BADDA VOL. 4 feat. TALAWAH SOUND - BILLY BAUNZ - JR. BLENDER - FR. 01.04.2011 | The Afrobeats song features a fruity male vocal rapping over stuttering and echoing siren sounds effects, echoing laser effects, punchy kick and snare hits, shimmering hi hats, smooth bass and short strings hits. It sounds groovy, energetic and chaotic due to the many siren sound effects. | 2011-03-25T22:28:37Z | baddabaddaHH | Get ready for BADDA BADDA #4 "Hamburg City tun up"! Doors open: 00:00 Ladies free till 1 o´clock after: ladies: 7€ ; gentlemen:8€ @ Planet Pauli - Spielbudenplatz 7-11 (Reeperbahn) Maddest dancehallmusic will be played as usual, brought to you by the residents: TALAWAH SOUND and BILLY BAUNZ. This time they will be supported by guest selekta: JR.BLENDER (SUPERSONIC SOUND) Check out: BADDA BADDA Promo Mix #4 by TALAWAH SOUND listen and download it here for free: http://soundcloud.com/baddabadda/badda-badda-mix-4-talawahsound http://www.facebook.com/baddabaddaHH http://www.baddabadda.de | ["Music of Africa", "Music", "Rhythm and blues", "Zing"] | ["afrobeats", "echoing laser effect", "stuttering echoing siren sound effect", "fruity male vocal", "punchy kick", "shimmering hi hats", "short strings hits", "smooth bass", "energetic", "chaotic", "punchy snare"] | 4 | jd94Ox7KJ9Q | 4268 | |
Anthony Hall - Breathe (New R&B Song 2010) | The low quality recording features a R&B song that consists of a passionate female vocal, alongside wide exhale sounds and wide repetitive female vocals, singing over claps, punchy kick, shimmering hi hats, synth lead melody and simple synth bass. It sounds energetic and exciting. | 2010-01-09T17:09:41Z | Janniiex3 | Hit me up on Facebook: Jannie NiCheer Introducing a hot new R&B-Artist: Anthony Hall :) ! enjoy the brandnew Single and leave a comment or rate :) thank you ;) almost daily new music :) | ["Music", "Pop music", "Rhythm and blues", "Hip hop music"] | ["low quality", "r&b", "synth lead melody", "wide exhale sounds", "passionate female vocal", "wide repetitive female vocals", "claps", "punchy kick", "shimmering hi hats", "simple synth bass", "energetic", "exciting"] | 4 | pELIBvAnbkY | 4692 |
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;