musiccaps_details (view)
3 rows where musiccaps_author = 8 and musiccaps_names contains "Reggae"
This data as json, CSV (advanced)
Suggested facets: youtube_published (date), musiccaps_names (array), musiccaps_aspects (array)
| video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
|---|---|---|---|---|---|---|---|---|---|---|
| Bob Marley & The Wailers - Stir It Up | Chill, tropical roots reggae music from the 1970's featuring a male vocalist, vocal harmonies, off beat guitar strums, phaser effect, a reggae drum beat and a simple bass part. | 2015-05-16T05:12:29Z | doogie Five-Four | Track 1 From Bob Marley & The Wailers - The Very Best of Bob Marley & The Wailers (Limited Edition) (2001) | ["Music", "Reggae", "Soul music"] | ["roots reggae", "chill", "tropical", "male vocals", "vocal harmony", "off beat guitar strums", "phaser", "1970's", "reggae drum beat", "simple bassline"] | 8 | AFWy1qyyMHE | 1092 | |
| 2pac blasphemy lyrics | Serious music in the gangster rap genre that features a strong male rapper with doubled vocals over a 90's hip hop beat. Deep bass drives the beat along with hand percussion, clap, electric piano, synth flute, and tambourine. | 2011-06-04T16:28:07Z | misslyricmaster1 | Thanks to kushclouds602 for requsting this song! More 2pac videos to come so keep checking ;) No copywrite intended, love for all, hatred for none. | ["Singing", "Reggae"] | ["90's hip hop", "gangster rap", "strong male rapper", "doubled vocals", "deep bass", "hand percussion", "clap", "electric piano", "synth flute", "tambourine", "serious"] | 8 | O3Cvn4yXrao | 2395 | |
| Louchie Lou & Michie One | Champagne & Wine | Dub reggae music featuring a drum fill, female vocal sample with effects, a smooth sine wave synth melody in the background, percussion and guitar. The mood is smooth and easy. | 2007-11-14T17:07:53Z | rn1432 | Louchie Lou & Michie One - Champagne & Wine Nice track from their first album 'II Be Free'. Louchie Lou & Michie One (Louise Gold and Michelle Charles) were a female Reggae-pop friendly duo from Camden, London, who formed in the early '90s during the rise of radio friendly reggae in Britain. Lyrics: Sweet a lil' baby This is my confession Sweet a lil' darlin' Gotta let me love you down Sweet a lil' baby Champagne and wine, I cry for thee Yeah, yeah yeah Champagne and wine, I cry for thee (Tell them, Louchie!) Baby, it's been a long time Since I've been watching you Darling, I'm tempted to touch you Boy, oh boy I want to whisper in your ear Words, sweeter than honey Can't resist these feelings Like a fire, I'm burnin', burnin', baby Baby, just cool me down And turn my life around Sweet a lil' baby This is my confession Sweet a lil' darlin' Gotta let me love you down Sweet a lil' baby Champagne and wine, I cry for thee Yeah, yeah yeah Champagne and wine, I cry for thee Hey Mr. Action You me a program You look sweet Centre of attention You take the spotlight Ah tru you shine bright You look neat Man, you are me first choice (c'mon!) Think you never know Me did look you long time ? major man de pon me mind Tempted to touch Ah true you're one of a kind Like a cassette I avi rewind Sweet a lil' baby This is my confession Sweet a lil' darlin' Gotta let me love you down Sweet a lil' baby Champagne and wine, I cry for thee Yeah, yeah yeah Champagne and wine, I cry for thee Like the stars, They twinkle in the sky See them in your eye Everybody wants a bit of lovin' Baby, let me be the one For your lovin' I will climb a mountain Swim the deep blue sea, yeah Baby, baby, let me be your lover Oh Hey Mr. Action You me a program You look sweet Centre of attraction You take the spotlight Ah tru you shine bright You look neat Man, you are me first choice (c'mon!) Think you never know Me did look you long time ? major man de pon me mind Tempted… | ["Drum roll", "Music", "Reggae"] | ["reggae", "drum fill", "sine wave synth melody", "effected female vocal sample", "dub", "guitar", "percussion", "smooth", "easy"] | 8 | zcc7dJIY7uc | 5498 |
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;