musiccaps_details (view)
3 rows where musiccaps_aspects contains "happy", musiccaps_aspects contains "instrumental", musiccaps_aspects contains "merry" and musiccaps_author = 7
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 |
---|---|---|---|---|---|---|---|---|---|---|
Jingle Bells - Techno Remix | This music is an upbeat instrumental of the popular Christmas carol, ‘Jingle Bells’. The tempo is fast with electronic arrangements and digital drumming. The music is buoyant, happy, cheerful, festive, perky, enthusiastic,energetic and high spirited. This song is a Techno Remix. | 2011-12-20T16:19:24Z | OX-DEXTER-XO | Remix By: TranceDevotee (From the Old Account) Original song: Jingle Bells (Written by James Lord Pierpont) ***I DO NOT claim ownership of this song as it belongs to its aforementioned owners*** | ["Electronic music", "Jingle (music)", "Music", "Techno"] | ["instrumental", "fast tempo", "electronic music", "digital music", "synthesiser arrangement", "digital drums", "techno music", "electronica", "electro pop", "techno pop", "edm", "jungle bells", "remix", "techno remix", "energetic", "enthusiastic", "punchy", "buoyant", "cheerful", "happy", "merry", "high-spirited"] | 7 | JOkuwbhMxbQ | 2000 | |
Tocata Enxovia CCB (Rancho do Ezequiel) | This music is a lively instrumental. The tempo is fast with the charming harmony of trumpet, saxophone, tuba and a rhythmic accordion accompaniment. The music is fresh, spirited,lively, pleasant, merry, cheerful, charming and entertaining. This music is a classical piece. | 2016-10-10T21:54:41Z | Doglinha Vieira | Acordeon Fabricio Sousafone Doglinha Trombone Ezequiel Saxofone Everton | ["Brass instrument", "Foghorn", "Music", "Musical instrument", "Trombone"] | ["instrumental", "fast tempo", "brass band", "tuba", "wind instruments", "wood wind", "acordion", "trombone", "trumpet", "saxophone", "melodious harmony", "pleasant harmonious", "cheerful", "happy", "merry", "classical"] | 7 | rOOBAGxxjBk | 4873 | |
Stand By Me (steel pan) | This music is a cheerful instrumental. The tempo is medium with the lead harmony on a Xylophone, energetic drumming, keyboard accompaniment and rhythmic acoustic guitar. The audio quality is inferior and the music is muffled and muddy. There are background sounds like people talking, laughing and ambient nature sounds like a breeze. The music is fun, youthful, simple, enjoyable, chirpy and vivacious. | 2008-02-13T06:13:56Z | svart3n | Steel Pan band at the 30th anniversary Flatbush Frolic in Brooklyn, NY, 2007. See the video in better quality @ http://youtu.be/LlCS3ZVutuk | ["Music", "Steelpan"] | ["instrumental", "medium tempo", "rhythmic acoustic guitar", "background sounds", "ambient nature sounds", "people talking", "sound of laughter", "cheering", "tapping", "merry", "happy", "chirpy", "cheerful", "’ enjoyable", "xylophone harmony", "energetic drumming", "muffled audio", "keyboard harmony", "lively beat", "catchy", "rhythmic beat", "pop song", "popular", "simple"] | 7 | tV3rvUSlVnY | 5043 |
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;