musiccaps_details (view)
2 rows where musiccaps_aspects contains "buoyant", musiccaps_aspects contains "high-spirited" and musiccaps_aspects contains "instrumental"
This data as json, CSV (advanced)
musiccaps_aspects (array) 28 ✖
- buoyant · 2 ✖
- fast tempo 2
- high-spirited · 2 ✖
- instrumental · 2 ✖
- punchy 2
- cheerful 1
- digital drums 1
- digital music 1
- edm 1
- electro pop 1
- electronic music 1
- electronica 1
- energetic 1
- enthusiastic 1
- enthusiastic cello 1
- happy 1
- infectious drumming 1
- jungle bells 1
- lively acoustic guitar 1
- male vocalisation 1
- merry 1
- perky 1
- remix 1
- spirited harmonica lead 1
- synthesiser arrangement 1
- techno music 1
- techno pop 1
- techno remix 1
musiccaps_names (array) 6 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Rollin' & Tumblin' | This music is an energetic instrumental. The tempo is fast with a vivacious harmonica lead, lively guitar rhythm, enthusiastic cello and punchy drumming. The song starts with an enthusiastic vocal riff. The music is an upbeat, catchy, buoyant, peppy, youthful, energetic and lively Harmonica instrumental. | 2009-07-27T19:59:29Z | petermadcatruth | Madcat, Kane & Maxwell Street play "Rollin' & Tumblin" recorded live at the Creole Gallery in Lansing Michigan, January 11, 2009. For more information check out: http://www.madcatmusic.net/ Peter Madcat Ruth - harmonica, vocals Shari Kane - guitar Mark Schrock - string bass Mike Shimmin - drums | ["Harmonica", "Wind instrument, woodwind instrument"] | ["instrumental", "fast tempo", "spirited harmonica lead", "lively acoustic guitar", "enthusiastic cello", "infectious drumming", "male vocalisation", "punchy", "perky", "buoyant", "high-spirited"] | 7 | CRUd8kY3L70 | 1367 | |
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 |
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;