musiccaps_details (view)
4 rows where musiccaps_aspects contains "average audio quality" and musiccaps_aspects contains "cheerful"
This data as json, CSV (advanced)
musiccaps_aspects (array) 65 ✖
- average audio quality · 4 ✖
- cheerful · 4 ✖
- energetic 2
- groovy bass line 2
- happy 2
- instrumental music 2
- medium tempo 2
- accordion melody 1
- amateur band 1
- amateur player 1
- backup singers 1
- bouncy drum rhythm 1
- celtic music influences 1
- childhood memories 1
- classic rock 1
- country music 1
- cymbals crashes 1
- dance rhythm 1
- distorted guitars 1
- electric guitar lead 1
- emotional 1
- entertaining 1
- excitement 1
- folk music 1
- full of cheer 1
- groovy rhythm 1
- guitar accompaniment 1
- guitar lead 1
- guitar strumming rhythm 1
- hobbyist 1
- irish jig 1
- keybiard accompaniment 1
- keyboard accompaniment 1
- latin dance song 1
- latin pop song 1
- love song 1
- male latin singer 1
- male singer 1
- mandolin playing 1
- medium fast tempo 1
- music demo 1
- music video 1
- no percussions 1
- nostalgic 1
- online music videos 1
- passionate 1
- percussive guitar strumming 1
- pleasant 1
- positive 1
- reggae music influences 1
- retro rock 1
- rock band 1
- rock music 1
- romantic 1
- soloist 1
- steady marching drumming rhythm 1
- string rock drumming 1
- studio recording 1
- tambourine percussions 1
- train journey 1
- vocal harmony 1
- walking bass line 1
- wonder 1
- youthful 1
- youtube music video 1
musiccaps_names (array) 9 ✖
- Music 4
- Banjo 1
- Christmas music 1
- Grunge 1
- Happy music 1
- Heavy metal 1
- Mandolin 1
- Progressive rock 1
- Punk rock 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Mandolin Madness | The song is an instrumental. The song is a medium tempo with a mandolin player playing a cheerful melody with no other instrumentation. The song is positive and has a delightful dance rhythm. The song has an average audio quality. | 2013-10-15T23:19:40Z | Kimsey Lutherie | A compilation of all my mandolin videos- just playing, no talking. Elkhorn, Gilchrist, Kentucky, Krishot, Weber, Stanley. | ["Banjo", "Music", "Mandolin"] | ["mandolin playing", "instrumental music", "medium tempo", "online music videos", "folk music", "youtube music video", "soloist", "hobbyist", "emotional", "country music", "dance rhythm", "celtic music influences", "irish jig", "no percussions", "music video", "average audio quality", "amateur player", "happy", "positive", "dance rhythm", "cheerful", "music demo"] | 1 | 4vsI0Kwn8jY | 618 | |
LGB #26814 German Steam Locomotive Class 99.23 (DCC Sound Decoder) | The song is an instrumental. The song is medium tempo with a walking bass line, steady drumming rhythm with cymbal crashes, guitar strumming rhythm and an accordion playing melody. The song is background music for a toy hobbyist video. The song is cheerful and reminiscent of a childhood adventure. | 2016-07-12T20:16:51Z | TrainWorldTV | LGB #26814 German Steam Locomotive Class 99.23 (DCC Sound Decoder) http://www.trainworld.com The model railroad equipment & accessories we sell are not toys, and are not intended for use by children under the age of 14, | ["Christmas music", "Music"] | ["instrumental music", "steady marching drumming rhythm", "nostalgic", "full of cheer", "average audio quality", "wonder", "accordion melody", "cymbals crashes", "guitar strumming rhythm", "walking bass line", "pleasant", "cheerful", "happy", "energetic", "excitement", "train journey", "childhood memories", "medium tempo", "amateur band"] | 1 | BsLFQV8HVZE | 1298 | |
Bowl for Two - The Expendables | A male singer sings this cheerful melody with backup singers in vocal harmony. The song is medium tempo with a reggae style drum and guitar accompaniment, guitar lead and a groovy bass line. The song is romantic and cheerful . The song is a Latin pop dance song. The audio quality is average. | 2007-09-02T03:29:08Z | P3DRO2 | lovin it | ["Music", "Happy music"] | ["male latin singer", "backup singers", "vocal harmony", "keyboard accompaniment", "average audio quality", "groovy bass line", "guitar accompaniment", "guitar lead", "bouncy drum rhythm", "reggae music influences", "keybiard accompaniment", "entertaining", "cheerful", "romantic", "love song", "latin pop song", "latin dance song", "groovy rhythm"] | 1 | euAQCWBX6ns | 3904 | |
ROCK 'N ROLL ICE CREAM - Marky Ramone & Missing Sound.mov | A male singer sings this rock melody. The song is medium fast tempo with a strong rock drumming rhythm, percussive bass line, distorted guitars playing rhythm and lead along with tambourine percussion. The song is energetic and cheerful. The song is a rock song with an average quality audio. | 2012-02-10T11:45:21Z | gian maria emendatori | ["Heavy metal", "Music", "Punk rock", "Progressive rock", "Grunge"] | ["male singer", "rock music", "classic rock", "string rock drumming", "average audio quality", "retro rock", "passionate", "rock band", "youthful", "energetic", "cheerful", "studio recording", "medium fast tempo", "string rock drumming", "tambourine percussions", "electric guitar lead", "percussive guitar strumming", "groovy bass line", "distorted guitars"] | 1 | fXhN3_gGpQw | 3957 |
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;