musiccaps_details (view)
5 rows where musiccaps_aspects contains "upbeat", musiccaps_aspects contains "vibrant", musiccaps_author = 3 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 |
---|---|---|---|---|---|---|---|---|---|---|
FUNNY QAWALI OF SHOKI KHAN | This is a traditional, cultural South Asian song. It is upbeat, vibrant, cheerful. The lead singer sings in a fast paced and rhythmic way, connecting many words within a short span of musical time. The rest of the performers are clapping their hands, playing the tabla. This is a live performance. | 2010-08-04T10:48:03Z | Hussain Akram | ["Music", "Middle Eastern music"] | ["traditional south asian music", "old desi music", "fast paced rhythmic singing", "clapping hands", "live performance", "tabla playing", "upbeat", "vibrant"] | 3 | 0fiOM---7QI | 197 | ||
One On One - Body Music ( Disco Funk 1981 ) | This is a funky disco song. A song like this would be suitable for an eighties themed dance party. It has a groovy bassline, upbeat rhythmic percussion, and vibrant brass motifs. The singer sounds charming and energetic. The background singers are soulful and sharp on the beat with their vocals - they sing their notes almost in staccato, so that they can stay close to the beat and keep the song feeling groovy. | 2009-02-09T07:41:33Z | andersnordhagen | ["Funk", "Music"] | ["funky song", "disco style", "upbeat", "dance", "groovy bassline", "eighties", "vibrant", "soulful", "funky background vocals", "charismatic male lead vocals", "brass instruments", "trumpet", "calm electric piano"] | 3 | 9JeN1ld-3fY | 992 | ||
GHANA GOSPEL MUSIC PROJECT 2008 AKWAABA JUNIOR LTJBM BAND Ayeyie oo! | This is a live performance by an African music group in a gospel style. The drum pattern is intricate and there are other percussive elements like an occasional bongo and a wooden percussion instrument. The melodic elements are the vintage sounding electric piano as well as the vibrant and fun brass melody played on the trumpets. | 2008-09-09T12:42:40Z | livegospelbandghana | SHILOH EVANGELICAL GOSPEL MUSIC ACADEMY presente to the world Afric's No. 1 juvenile live gospel band, playing three fusions. African gospel music revolution fusion, playing high life reggea jazz etc. contact: neelante@journalist.com, tel: (+233) 244 654 400 / 277 338 172 | ["Gospel music", "Music", "Middle Eastern music"] | ["african music", "gospel", "trumpets", "upbeat", "vibrant", "electric bass guitar", "bongo drums", "intricate drum pattern", "wooden percussion instrument", "electric keyboard", "mellow groove", "medium tempo"] | 3 | C0eCERYt4bA | 1317 | |
Arthur Conley ~ Sweet Soul Music (1967) | This is an upbeat, soulful and funky song. It's got a catchy and fast paced rhythm which makes it good to dance to. The singer has a raspy and energetic voice. | 2011-10-24T15:04:43Z | TheOldrecordclub | This great soul song by "Arthur Conley" was released in 1967 and i believe this was the biggest hit song he had.He actually wrote this song with "Otis Redding" and the song was originally released on the Atco label. | ["Music", "Soul music"] | ["blues", "funky", "soulful", "upbeat", "dance", "vibrant", "groovy bassline", "rhythm & blues", "raspy male vocal", "energetic male vocalist", "simple drum beat"] | 3 | grE0lwTsSPg | 4060 | |
《吹奏楽コンサート》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;