musiccaps_details (view)
5 rows where musiccaps_aspects contains "moderate tempo", musiccaps_aspects contains "reggae song", musiccaps_author = 0 and musiccaps_names contains "Music"
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 |
|---|---|---|---|---|---|---|---|---|---|---|
| 林司令BastardMarley - Season In The Sun [Official Music Video] | This reggae song features a male voice making an announcement in the beginning. A female voice sings a one-line melody. This is accompanied by the main male voice singing vocables in the background. Until this part, only a keyboard and guitar are playing a reggae rhythm. This is followed by the main male voice singing the main melody in a reggae style. This is accompanied by a kick driven percussion playing a simple beat. There are voices singing vocables in the background. The mood of this song is happy. This song can be played in a movie with a holiday theme. | 2015-08-20T12:00:09Z | UNTV | 作曲:林司令BastardMarley 作詞: 林司令BastardMarley MV影像製作:StayHighCrew 攝影:StayHighCrew 導演:StayHighCrew 剪接後製:StayHighCrew U.N官方SoundCloud: https://soundcloud.com/un_ent U.N官方粉絲專頁: Underground Nation / 地下國度 https://www.facebook.com/UndergroundNationTaiwan YSJ / 楊素貞: https://www.facebook.com/youngsouljaz.tw BastardMarley/林司令: https://www.facebook.com/BastardMarley Tipsy: https://www.facebook.com/TipsyKao1230 4PLAY / 四少: https://www.facebook.com/UN4play 大衛.蕭: https://www.facebook.com/therealdvd StayHighCrew: https://www.facebook.com/SHCProduction | ["Music", "Happy music"] | ["reggae song", "male voices", "female voice", "keyboard", "kick focused percussion", "guitar", "moderate tempo", "happy mood"] | 0 | 2JNY2SaMk7s | 351 | |
| Bob Marley - Get Up Stand Up + Lyrics | This reggae song features a male voice singing the main melody. Other male voices sing backing voices repeating the same melody in between lines. This is accompanied by percussion playing a simple melody using reggae rhythm. The bass plays a groovy bassline using runs within the scale. A guitar plays chords by muting technique producing a reggae rhythm. A keyboard plays chords in the background. This song can be played in a documentary about alleviating poverty. | 2011-02-25T13:27:55Z | Γιάννης P. | The God sign's Get Up Stand Up just enjoy the music. Peace,Love & Hope Brothers & Sisters for a better world. I don't have copyrights or anything like this. | ["Music", "Reggae"] | ["reggae song", "male voice", "male backing voice", "groovy bass", "reggae guitar", "percussion", "keyboard", "moderate tempo"] | 0 | BiPwCMlghhQ | 1278 | |
| Eric Donaldson - Jah Love | This reggae song features a male voice singing the main melody. This is accompanied by percussion playing a simple reggae beat. The bass plays notes in reggae style. A guitar plays fills in the beginning and in between lines. Hand claps are played in groups of two and one in an alternating pattern. This song can be played in a romantic movie. | 2010-01-24T10:52:12Z | NinjaBuziness | Album : Children Of Jah Label : Roots & Culture Records Released : 1999 | ["Music", "Soul music"] | ["reggae song", "male voice", "guitar", "bass", "simple percussion", "moderate tempo", "romantic mood", "hand claps"] | 0 | QHNREJJRTS4 | 2608 | |
| Christmas Remix - Sha-la-la (non-stop mix) | This reggae song features a male voice. He sings the first line and laughs at the end of the first sentence. He continues to sing the melody. The voice is accompanied by programmed percussion playing a simple beat. The bass plays the root notes of the chords. A keyboard plays chords in the background with a reggae feel. Another keyboard plays a fill in between lines. At the end, backing singers sing in harmony. This song has a holiday mood. This song can be played in a holiday movie. | 2010-12-11T06:20:36Z | brYaz 214 | an Christmas remix present "Sha-la-la (non-stop mix)" Remix all 14 songs in just 12:33 minutes All Christmas Remix songs: Christmas Remix - Sha-la-la (radio edit) Christmas Remix - Sha-la-la (non-stop mix) Christmas Remix - Dayang-dayang (radio edit) Christmas Remix - Dayang-dayang (non-stop mix) Download link: http://www.4shared.com/audio/OLTt4F6W/Sha_La_La__Non_Stop_Remix_.html type: Mp3 file name: Sha-la-la (non-stop mix) file size: 11.5mb(11,798kb) Hosting Site: 4shared | ["Christmas music", "Music"] | ["reggae song", "male voice", "holiday mood", "programmed percussion", "keyboard", "shaker", "moderate tempo"] | 0 | gWRfk8nCcPs | 4035 | |
| 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;