musiccaps_details (view)
5 rows where musiccaps_aspects contains "hi-hats" 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 |
---|---|---|---|---|---|---|---|---|---|---|
Stickwitu - Male Version, Me Singing | The music contains an erotic male voice which is out of key and clearly in the foreground. In the background there's a sustained soft piano synth and a drum kit playing a mid pitch beat. The atmosphere is sexual and seductive. | 2010-11-14T12:44:11Z | 抵死仔 | I'm Kelmen...I'm from HK. I hope U all like this song !! Thanks !! Download this song:: http://www.box.net/shared/y7gythrrym | ["Music", "/m/05zppz", "Soul music", "/t/dd00003"] | ["r&b", "happy", "mid-pitched male vocals", "soft piano synth", "kick", "snare", "hi-hats", "upbeat", "out of key vocals", "mid tempo"] | 5 | DB38NRSHw9A | 1450 | |
Shain Caw - No Mercy | The song feels funky and soulful. There's a rumbling funky bassline, and an electric guitar playing intermittent licks. The drumming sticks on the hi-hats for the feeling of a build-up;. The female vocalist has a powerful, soulful voice. | 2010-07-12T21:30:43Z | Marc de Groot | From Shain Caws new album The Incredible Decibel. Filmed, directed and edited by Marc de Groot. | ["Funk", "Music", "Soul music"] | ["funky", "soulful", "groovy", "funky rhythmic bassline", "twangy electric guitar", "soulful female vocal", "powerful rich female vocal", "crackling effect", "hi-hats", "build-up", "electric guitar licks"] | 3 | KPnIFb7T7VM | 2080 | |
Haylee & Katie SNAP DANCE | Here we have an early 2000s hip hop song which features a grungy guitar and a high pitched synth riff. The recording is done live, and thus the poor audio quality. There is a lower bass-synth which has the characteristics of a trumpet and a repeated riff is played on it. | 2006-06-27T21:59:11Z | meghan36 | Yea Umm This Is My sister doing the SNap DAnce with her friend haylee (in the green) lol....This is awesome i mean whenever they go to wild Bills or Dance nights they jump in the middle of the Black Crowd and steal the show their snap DAncing is amazing...sometimes i wonder if they have black in them....lol CHECK IT OUT!!! | ["Scratching (performance technique)", "Music"] | ["hip hop", "hip hop drum pattern", "low trumpet-like synth", "high pitched string-synth", "hi-hats", "live recording", "low audio quality", "grungy electric guitar chord strumming", "2000s hip hop"] | 3 | TZGDukKAVS8 | 2844 | |
maghreb united celebration : maroc algerie tunisie 2011 - fonoune.com | This is an upbeat Arabic dance pop song. There's an energetic male singer with a heavily autotuned voice who sings to the beat. The beat features a four on the floor kick drum pattern and hi-hats being played in a pattern of 16th notes. There's a rapid repeated synth melody riff. The song would be heard at a dance club. | 2009-07-01T07:50:03Z | fonoune09 | http://www.filmze-streamiz.com/ Maghreb United "celebration" 2011 le nouveau morceau du 113 , maroc 2011, algerie 2011, tunisie 2011, music rai rap arabe la remix avec Reda taliani - Maroc, tunisie, algerie | ["Music of Africa", "Music"] | ["autotuned male vocal", "arabic dance pop", "heavy autotune", "rapid bright synth melody", "four on the floor", "dance", "hi-hats", "sixteenth notes"] | 3 | gAQiARaliPA | 4010 | |
《吹奏楽コンサート》Let's Swing!! | This is an upbeat swing style song with a choir of brass instruments playing a vibrant motif. The motif is a sort of crescendo that announces the next segment. It would be suitable as an intro to the arrival of a character in a musical or movie. | 2012-09-28T02:33:25Z | エムハチチャンネル | 【QC-190】Let's Swing!! 商品詳細はこちら→https://www.music8.com/products/detail3132.php 《収録曲》 0:00 メイク・ハー・マイン【MAKE HER MINE】 1:49 故郷の空 3:36 シング・シング・シング【SING,SING,SING】 | ["Swing music", "Brass instrument", "Music"] | ["orchestra", "brass instruments", "swing", "upbeat", "groovy", "swing genre", "vibrant", "hi-hats", "crescendo"] | 3 | pKFXFu8st9I | 4701 |
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;