musiccaps_details (view)
2 rows where musiccaps_names contains "Drum and bass" and musiccaps_names contains "Reggae"
This data as json, CSV (advanced)
musiccaps_aspects (array) 26 ✖
- dance music 1
- dance tune 1
- dj 1
- drum machines 1
- electronic dance music 1
- funky bass 1
- groovy bass line 1
- hissing tones 1
- home studio 1
- instrumental music 1
- jam block 1
- male voice 1
- medium tempo 1
- moderate tempo 1
- poor audio quality hissing tones 1
- reggae drums 1
- reggae song 1
- rhythm mismatch 1
- shaker 1
- synth horn melody 1
- synth modules 1
- synthesisers 1
- techno drumming rhythm 1
- timbale 1
- turntables 1
- vocal harmony 1
youtube_published (date) 2 ✖
- 2008-07-21 1
- 2015-04-01 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Moskvin - ragga dub & enei - deep dnb "use your fingers" live looping mix (Drum pads 24 & korg kp3) | The song is an instrumental. The song is medium with a strong bass line, steady techno drumming rhythm, various percussion hits and a synth horn melody. The song has mismatched tempos and is amateurish in production. The audio quality is poor. | 2015-04-01T21:14:12Z | Moskvin | Moskvin - ragga dub & enei - deep dnb "use your fingers" live looping mix (Drum pads 24 & korg kp3) Download Drum Pads 24: Windows Phone Store: http://bit.ly/DrumPads24WP Google Play: https://play.google.com/store/apps/details?id=com.paullipnyagov.drumpads24 App Store: https://itunes.apple.com/app/id667945907 ------------------------------------------------------------------------------ Drum Pads 24: https://www.facebook.com/Drumpads | ["Drum and bass", "Music", "Reggae", "Dubstep"] | ["home studio", "dj", "turntables", "synthesisers", "poor audio quality hissing tones", "medium tempo", "synth modules", "drum machines", "rhythm mismatch", "dance music", "electronic dance music", "synth horn melody", "groovy bass line", "techno drumming rhythm", "dance tune", "hissing tones", "instrumental music"] | 1 | 8XBsesSEbbU | 925 | |
TWILIGHT CIRCUS DUB SOUND SYSTEM - BINGHI RIDDIM (VARIOUS ARTISTS) | This reggae song features a male voice singing the main melody. Another voice is singing in harmony with the main voice. This is accompanied by reggae percussion. A timbale is played on every third count. Jam blocks are also played in the background. The bass plays a funky bassline with a reggae feel. Synth sounds are played in the background. This song can be played in a bar. | 2008-07-21T12:16:12Z | Ryonik | One-riddim album on the Red-Hot 'Binghi Riddim' featuring Jamaican legends Sly Dunbar, Skully & Dean Fraser. Available now on Itunes and http://www.ebreggae.com TRACKLISTING Sugar Minott "Take It Slow" Tampanae "Musical Journey" Lutan Fyah "We Can Make It Work" Gregory Isaacs & Big Star "Touch Not" R.Mony & Johnny Builder "Only Time Will Tell" Daddy Shark "Earth Foundation" Mykal Rose "A Little Bit More" X-Facta "Welcome To The Garrison" Keke-I "Why Do You Fight" Anju Kumbz "Stand Up On Your Feet" Al Pancho & Ken Bob "Last Night" Flourgon "This World" Skully "Binghi Riddim" Check us out at: http://www.myspace.com/twilightcircus http://www.twilightcircus.com 'Wrestles with history's titans & leaves the ring commanding 'nuff respect' - SPIN Mag / Jeff Chang 'Among the best of any current reggae producers in the World' - Tape Op Mag / Larry Crane Ryan Moore has participated in nearly 100 album projects in various genres including work with The Legendary Pink Dots, Skinny Puppy, various Nettwerk Records albums, Sarah McLachlan, The Tear Garden, Keith Levine (P.I.L.), Ted Parsons (Prong), DJ Spooky, Single Gun Theory, Final Cut (Jeff Mills).. The following have worked with Twilight Circus: Sly Dunbar, Robbie Shakespeare, Dean Fraser, Michael Rose (Black Uhuru), Luciano, Mikey General, Big Youth, Skully, Vin Gordon (Bob Marley), Chinna Smith (Ziggy Marley), Eddie 'Tan Tan' Thornton (Aswad), Buttons (UB40), Ansel Collins, Style Scott (Dub Syndicate), Bobby Ellis (Studio One), Admiral Tibet, Jah Stitch, Sugar Minott, Queen Ifrica, Fred Locks, Max Romeo, Gregory Isaacs, Mafia&Fluxy, Cevin Key (Skinny Puppy), DJ Spooky, Mad Professor, Mike Pelanconi (Lily Allen), Steven Stanley, Jack Dangers | ["Drum and bass", "Music", "Reggae"] | ["reggae song", "male voice", "vocal harmony", "reggae drums", "funky bass", "moderate tempo", "shaker", "timbale", "jam block"] | 0 | s1JHUf3Q_F0 | 4911 |
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;