musiccaps_details (view)
3 rows where "youtube_published" is on date 2012-03-17 sorted by musiccaps_rowid
This data as json, CSV (advanced)
musiccaps_aspects (array) 43 ✖
- medium tempo 2
- ambient sounds 1
- cheeky 1
- cheesy organ 1
- christmas concert 1
- christmas song 1
- christmas time 1
- clapping 1
- dance groove 1
- dance music 1
- digital drum beats 1
- electro pop 1
- electronic music 1
- electronic sounds 1
- emphatic 1
- emphatic vocals 1
- energetic 1
- fast tempo 1
- female vocalist 1
- fun 1
- heavy reverb 1
- incoherent music 1
- jazzy 1
- keyboard harmony 1
- lead trombone melody 1
- live audience 1
- live performance 1
- male singer 1
- police siredn 1
- police siren 1
- poor audio quality 1
- powerful vocals 1
- quirky 1
- steady drumming 1
- swing pattern 1
- synth pop 1
- synthesiser arrangements 1
- teen singer 1
- triangle 1
- upbeat rhythm 1
- vivacious 1
- vocal backup 1
- youthful 1
musiccaps_names (array) 7 ✖
- Music 2
- Singing 2
- Brass instrument 1
- Choir 1
- Christmas music 1
- Field recording 1
- Trombone 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid ▼ |
---|---|---|---|---|---|---|---|---|---|---|
P-Bone | Eric Westerink | PinkBondSmoke | Quirky, cheeky, jazzy music featuring a lead trombone melody, a triangle playing a swing pattern, a cheesy organ and a medium tempo. | 2012-03-17T08:33:10Z | Eric Westerink | P-Bone-solo with tape | P-Bone: Eric Westerink | Tape: Eric Westerink | Pink Panter, James Bond, Smoke on the water | Arranged by Eric Westerink | West Sound Music | www.ericwesterink.nl | ["Brass instrument", "Trombone"] | ["lead trombone melody", "triangle", "swing pattern", "medium tempo", "cheesy organ", "jazzy", "quirky", "cheeky"] | 8 | AtWf5OAE8aM | 1180 | |
Justin Bieber singing Christmas songs in Washington 2011 (perfoming for Obama!).mp4 | A male vocalist sings this Christmas song. The tempo is medium with minimal instruments like keyboard harmony and steady drumming. The audio quality is inferior so the music is incoherent. This is a live performance with ambient sounds of people clapping and cheering. This is a contemporary Christmas Song. | 2012-03-17T20:04:17Z | virgi92dT | Yeeeee!!! 1. Mistletoe 2. Away in a manger 3. a classic Christmas song featuring with Obama | ["Christmas music", "Singing", "Music", "Choir"] | ["male singer", "teen singer", "medium tempo", "vocal backup", "keyboard harmony", "steady drumming", "poor audio quality", "incoherent music", "emphatic vocals", "live performance", "ambient sounds", "clapping", "christmas song", "christmas time", "christmas concert", "live performance", "live audience", "heavy reverb"] | 7 | ZNGJN30LCwM | 3369 | |
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;