musiccaps_details (view)
3 rows where musiccaps_aspects contains "fun", musiccaps_aspects contains "lively" and musiccaps_author = 7
This data as json, CSV (advanced)
musiccaps_aspects (array) 44 ✖
- enthusiastic 3
- fun · 3 ✖
- lively · 3 ✖
- cheerful 2
- fast tempo 2
- instrumental 2
- accordion melody 1
- accordion solo 1
- band 1
- brass 1
- brass band 1
- breezy 1
- bright 1
- buoyant 1
- carefree 1
- cheeky 1
- chirpy 1
- clarinet 1
- cymbals 1
- energetic 1
- engaging 1
- enthusiastic electric guitar 1
- female vocalist 1
- fresh 1
- funky bass lines 1
- hammond organ 1
- happy 1
- lighthearted 1
- lively baritone saxophone 1
- medium fast tempo 1
- peppy 1
- perky 1
- piano accompaniment 1
- playful 1
- punchy 1
- simple 1
- slick drumming 1
- spirited 1
- suggestive 1
- trombone 1
- trumpet 1
- tuba 1
- wind instrument 1
- youthful 1
musiccaps_names (array) 5 ✖
- Accordion 1
- Brass instrument 1
- Clarinet 1
- Independent music 1
- Music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Banda musicale dell'arma dei carabinieri.Italia.Москва.brass band | This music is a lively instrumental. The tempo is fast with an enthusiastic Brass and wind instrument harmony. The vigorous trumpets, trombone and tuba accompaniment, along with clanging cymbals and playful clarinet make for an upbeat, cheerful, happy, energetic and Perky Band Music. | 2012-09-04T16:25:29Z | umo61 | Спасская Башня.Кремль.Красная Площадь.Orchestra Carabineros.Militari orchestra Italia.оркестр Италии.духовые инструменты.winds. | ["Brass instrument", "Clarinet"] | ["instrumental", "fast tempo", "enthusiastic", "brass band", "cheerful", "happy", "bright", "fun", "engaging", "perky", "peppy", "bright", "energetic", "lively", "spirited", "cymbals", "clarinet", "trumpet", "tuba", "trombone", "wind instrument", "brass", "band", "engaging"] | 7 | Aak-VLHtFPM | 1142 | |
Minecraft Song ♪ "All About My Base" Minecraft Song Parody (Minecraft Animation) | A female vocalist sings this spirited pop. The tempo is fast with infectious piano melody, slick drumming, funky bass, baritone saxophone, Hammond organ accompaniment with enthusiastic vocals. The song is fresh, youthful, buoyant; energetic, high-spirited, cheeky, suggestive, playful and groovy. This is a hit Pop Song. | 2015-06-15T01:55:28Z | Lachlan | Download the Minecraft Song "All About My Base" on Itunes: http://bit.ly/AllAboutMyBase Come play Minecraft Factions with me on Treasure Wars! IP: Treasurewars.net Subscribe for more Awesome Minecraft Content http://bit.ly/LachlanSubscribe Gaming Channel: https://www.youtube.com/LachlanPlayz Lachlan All About My Bass (The original to the Parody): https://www.youtube.com/watch?v=7PCkvCPvDXk Credits: Animation: Latez Animations https://www.youtube.com/user/Boxmen6661 https://twitter.com/Boxm3n666 Vocals + Instrumentals + Lyrics by ShadyVox http://www.shadyvox.com https://twitter.com/ShadyVox http://www.youtube.com/user/ShadyVoxYT Singers: https://www.youtube.com/EileMontyVA/ www.twitter.com/EileMonty The Pack: Vik: https://www.youtube.com/user/Vikkstar123HD Rob: https://www.youtube.com/user/MrWoofless Preston: https://www.youtube.com/user/PrestonPlayz Mitch: https://www.youtube.com/user/TheBajanCanadian Jerome: https://www.youtube.com/user/JeromeASF My Links Twitter: https://twitter.com/LachlanYT Instagram: http://instagram.com/lachlanpower | ["Music", "Independent music"] | ["female vocalist", "fast tempo", "slick drumming", "punchy", "buoyant", "fun", "fresh", "suggestive", "enthusiastic electric guitar", "funky bass lines", "piano accompaniment", "lively baritone saxophone", "hammond organ", "lively", "enthusiastic", "youthful", "cheeky", "playful", "fun"] | 7 | YVEqyQjyy1Q | 3289 | |
online 2 battle il-2 video | This music is a simple and pleasing instrumental. The tempo is medium fast with a cheerful accordion harmony. The music is minimalist,simple, cheerful, happy, fun, carefree, jolly and lighthearted. | 2009-07-12T04:42:37Z | Technonoob | short vid of ingame footage | ["Accordion"] | ["instrumental", "medium fast tempo", "lighthearted", "accordion melody", "accordion solo", "lively", "simple", "fun", "breezy", "cheerful", "chirpy", "enthusiastic", "carefree"] | 7 | tDVOUsG52Jw | 5015 |
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;