musiccaps_details (view)
1 row where musiccaps_aspects contains "electro pop", musiccaps_aspects contains "emphatic", musiccaps_aspects contains "police siredn" and musiccaps_names contains "Field recording"
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 |
|---|---|---|---|---|---|---|---|---|---|---|
| CéAnne - Goat Down /dubplate/ - Goatmét Sound System (Man Down Riddim) | A female vocalist sings this vibrant song. The tempo is fast with synthesiser articulation, enthusiastic digital drum beats, electronic arrangements and sound of police siren in the background. The song is youthful, energetic, vivacious, simple, fun, engaging, groovy,with powerful and emphatic vocals. This song is Electro Pop/Synth Pop. | 2012-03-17T18:57:58Z | jameshungary | Best female voice inna Hungary!!!!! CéAnne (from Dubaku, The Mighty Fishers) true story: one gyal, one goat, one toilet! LYRICS: CÉANNE - GOAT DOWN DUBPLATE Go ahead Kecskemét! Countryside! Selecta James big up yourself! Toilet crew! GOATMÉT SOUND SYSTEM CéAnne tell you so ... Toma, Bogi, James, Moe Goatmét Sound System I didn't mean to change him life I know it wasn't right I can't even sleep at night can't get it off my mind I need to get inna the sight and teach the goats more What started out as a simple alleviation turned into a real sticky situation me just thinking of the sound that I'm facing I want the system around cause I didn't mean to shock him coulda been somebody's goat and I go to Goatmét since then oh I love this sound CHORUS! (2x) Rum pa pa pum Rum pa pa pum Rum pa pa pum GOAT DOWN (2x) Oh Moe, Bogi, Toma, I just shocked a goat down inna the goat station in front of the big goat town oh why It happened around 22 now it's called toilet crew when he really scared me too what you expect me to do if you're opening the door I had to accept the new name toilet gyal I didn't mean to let him down but it's too late to turn back now Don't know what I was thinking now he's over me knowing so I'm into Goatmét Sound cause I didn't mean to shock him coulda been somebody's goat and I go to Goatmét since then oh I love this sound CHORUS! I never thought I'd do it (3x) oh Goat what ever happened to me (3x) this sound grows into bigger boom them end the end the other sound so soon goats grows into bigger into bigger James yes you Bogi, Moe, Toma, goats tell me what I'm gonna do Rum pa pa pum Rum pa pa pum Rum pa pa pum mi seh one goat down whe mi seh Rum pa pa pum Rum pa pa pum Rum pa pa pum when mi went to goat town cause now I am a lyrical lyrical lyrical oh goat of mercy now i am a lyrical goat down selecta James please don't be critical run outta town none a them can bring me down (2x) Oh Moe, Bogi, Toma, I just shocked a goat down inna the goat station in front of the big goat town oh why face… | ["Singing", "Music", "Field recording"] | ["female vocalist", "fast tempo", "electronic music", "electro pop", "synth pop", "powerful vocals", "emphatic", "police siredn", "synthesiser arrangements", "digital drum beats", "electronic sounds", "upbeat rhythm", "dance music", "dance groove", "police siren", "youthful", "fun", "energetic", "vivacious"] | 7 | n615BjoN7fI | 4519 |
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;