musiccaps_details (view)
8 rows where musiccaps_aspects contains "fun", musiccaps_aspects contains "live performance" and musiccaps_aspects contains "noisy"
This data as json, CSV (advanced)
musiccaps_aspects (array) 55 ✖
- fun · 8 ✖
- live performance · 8 ✖
- low quality 8
- noisy · 8 ✖
- happy 7
- mono 3
- passionate 2
- reverberant 2
- acoustic rhythm guitar 1
- addictive synth lead melody 1
- arpeggiated and strummed banjo melody 1
- background harmonizing vocals 1
- big band 1
- big bend 1
- bright brass melody 1
- chaotic 1
- country 1
- cowbell percussion 1
- crowd chattering 1
- emotional 1
- emotional female vocal 1
- energetic 1
- energetic drums 1
- folk 1
- groovy acoustic rhythm guitar melody 1
- groovy double bass 1
- groovy double bass melody 1
- groovy mandoline melody 1
- groovy steel guitars melody 1
- groovy thin bass 1
- groovy trombone 1
- guitar melodies 1
- harmonica solo 1
- harmonizing female vocals 1
- harmonizing male vocals 1
- jazz 1
- joyful 1
- karaoke 1
- laughing 1
- mellow piano chords 1
- mellow piano melody 1
- mellow synth pad 1
- muffled pop song 1
- passionate female vocal 1
- passionate trumpet melody 1
- people chattering 1
- pop 1
- punchy snare 1
- rock-ish drums 1
- shimmering cymbals 1
- shimmering hi hats 1
- shoe tapping 1
- soft kick hits 1
- steel pan melody 1
- unbalanced stereo 1
musiccaps_names (array) 19 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Geminoid F singing a Japanese song @ Robots in motion @ Cityplaza, Hong Kong 2012.4.1 | The low quality recording features a, what it seems like, karaoke cover of a muffled pop song that consists of some guitar melodies and rock-ish drums, over which an emotional female vocal is singing. There are some laughing and chattering crowd sound effects in the background too. It sounds fun and emotional, but also noisy and kind of chaotic. | 2012-04-01T15:16:35Z | Amanda Lam | 太古城中心全互動機械人大博覽 2012.4.1 Robots in motion @ Cityplaza, Hong Kong 2012.4.1 | ["Music", "/t/dd00004"] | ["low quality", "muffled pop song", "noisy", "laughing", "people chattering", "live performance", "karaoke", "emotional", "fun", "rock-ish drums", "guitar melodies", "emotional female vocal", "chaotic"] | 4 | 16TsDMjHzYU | 238 | |
Welcome to Big Band Music - Swing and Jazz in Denmark | The low quality recording features a live performance of a jazz big bend that consists of passionate trumpet melody, over groovy double bass, shimmering cymbals and mellow piano chords. It sounds reverberant, happy, passionate and fun. The recording is a bit noisy and the sound is leaning towards the right channel, which makes the stereo image unbalanced. | 2010-02-04T21:07:14Z | Kurt Lykke Lindved | Randers Big Band is one of the best Big Bands in Denmark with more More than 30 years experience in the fields of swing, jazz and musicals - A dynamic band and popular in a greater part of the world. The repertoire is wide spread in styles and performances including the music from evergreens to our today`s modern tunes in swing and jazz. Several famous vocalists have been performing with the band and a yearly tradition like the New Year`s Brunch Concert is always popular and visited again and again by the same audience including the newcomers. | ["Brass instrument", "Saxophone", "Trombone"] | ["low quality", "noisy", "live performance", "unbalanced stereo", "reverberant", "passionate trumpet melody", "jazz", "big bend", "shimmering cymbals", "mellow piano chords", "groovy double bass", "passionate", "happy", "fun"] | 4 | S0W_zIUYwrE | 2733 | |
Melissa Manchester - You Should Hear How She Talks About You | The low quality recording features a live performance of a pop song that consists of passionate female vocals, alongside background harmonizing vocals, singing over energetic drums, groovy, thin bass, mellow synth pad and addictive synth lead melody. Even though the recording is noisy and in mono, it sounds energetic, happy and fun. | 2007-05-21T17:06:41Z | Guido Antonio Di Carlo | Melissa Manchester - You Should Hear How She Talks About You live at Solid Gold 1982 | ["Singing", "Independent music"] | ["low quality", "mono", "noisy", "pop", "live performance", "energetic drums", "groovy thin bass", "mellow synth pad", "addictive synth lead melody", "passionate female vocal", "background harmonizing vocals", "energetic", "happy", "fun"] | 4 | W_MZo88gzrA | 3107 | |
Doyle Lawson and Quicksilver performs "Sea of Life" at the High Country Bluegrass Festival | The low quality recording features a live performance of a country song and it consists of harmonizing male vocals singing over groovy steel guitar, groovy mandoline melody and groovy acoustic rhythm guitar chords. There are some crowd chattering noises in the background. It sounds passionate, happy and fun. | 2009-08-26T02:22:15Z | GrasshopperSlim | Doyle Lawson and Quicksilver performs "Sea of Life" at the High Country Bluegrass Festival in Boone North Carolina on July 25, 2009. | ["Banjo", "Country", "Music", "Bluegrass"] | ["low quality", "live performance", "country", "harmonizing male vocals", "groovy steel guitars melody", "noisy", "groovy mandoline melody", "groovy acoustic rhythm guitar melody", "passionate", "happy", "fun", "crowd chattering"] | 4 | ZX2fVPmUidA | 3388 | |
Andy Narell: Coffee Street | The low quality recording features a live performance of a big band that consists of shimmering hi hats, steel pan melody, punchy snare, soft kick hits, bright brass melody, groovy double bass melody and cowbell percussion. The recording is a bit noisy and it sounds happy and fun. | 2013-01-22T23:26:57Z | University of North Texas College Concerts | Coffee Street, (1998) by Andy Narell 2:00 Steel Band - Mark Ford, director One O'Clock Lab Band - Steve Weist, director Recorded Live, October 29, 2012 Winspear Hall, College of Music University of North Texas http://music.unt.edu More about UNT Percussion: http://music.unt.edu/pecussion | ["Music", "Steelpan"] | ["low quality", "live performance", "noisy", "big band", "shimmering hi hats", "punchy snare", "soft kick hits", "steel pan melody", "bright brass melody", "groovy double bass melody", "cowbell percussion", "fun", "happy"] | 4 | _fKntnlIYTQ | 3481 | |
Whiskey Before Breakfast | The low quality recording features a live performance of a folk song and it consists of harmonica solo melody over acoustic rhythm guitar chord progression. It sounds happy and fun. The recording is noisy and a bit reverberant as it was probably recorded with a poor quality microphone. | 2008-08-30T13:29:47Z | HarmonicaAcademy | Tony Eyers - Harmonica John Bridgland - Guitar | ["Harmonica", "Wind instrument, woodwind instrument"] | ["low quality", "live performance", "folk", "acoustic rhythm guitar", "harmonica solo", "happy", "fun", "noisy", "reverberant"] | 4 | drqKxGmdf8Y | 3820 | |
"Dueling Banjos" - Beginning Banjo Lesson (With Tab) | The low quality recording features an arpeggiated and strummed banjo melody. The recording is noisy, in mono and the melody sounds happy and fun. | 2012-04-02T18:31:36Z | happybanjodude | Link to tab: http://www.happybanjodude.com Tab for Part 2 available now! Follow me on twitter: http://www.twitter.com/happybanjodude | ["Banjo", "Music", "Mandolin", "Musical instrument", "Strum", "Plucked string instrument"] | ["live performance", "noisy", "arpeggiated and strummed banjo melody", "happy", "fun", "low quality", "mono"] | 4 | srEOZzpdhs8 | 4983 | |
The Sound of Music - The Lonely Goatherd | The low quality recording features a live performance that consists of harmonizing female vocals singing over mellow piano and groovy trombone melody. There are some shoe tapping sounds from performers. It sounds fun, happy, joyful and the recording is in mono and noisy. | 2009-04-28T01:33:41Z | Meagan Leanne | Meagan Leanne singing "The Lonely Goatherd" and "The Sound of Music" (The Hills Are Alive) for the final performance of Spencerville Adventist Academy's "The Sound of Music" in April of 2009. | ["Music", "/t/dd00032", "Exciting music"] | ["low quality", "mono", "live performance", "noisy", "groovy trombone", "mellow piano melody", "shoe tapping", "harmonizing female vocals", "fun", "happy", "joyful"] | 4 | zbCqre50eLM | 5497 |
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;