musiccaps_details (view)
6 rows where musiccaps_aspects contains "instrumental", musiccaps_aspects contains "medium tempo", musiccaps_aspects contains "melodious", musiccaps_author = 7 and musiccaps_names contains "Music"
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 |
---|---|---|---|---|---|---|---|---|---|---|
10 songs to play on mandolin that aren't bluegrass | This song is a mandolin instrumental. The tempo is medium with a lively melody on the mandolin. The music is minimalist without any other instruments. The music is high pitched, melodious and charming. This audio ends abruptly indicating that this could be a mandolin tutorial. | 2014-08-08T12:17:31Z | mandohat | I love bluegrass, but the mandolin is a great instrument for lots of styles! http://www.andyslessons.com ---Andy Hatfield, mandolin and guitarist | ["Music", "Mandolin"] | ["instrumental", "medium tempo", "mandolin", "folk", "classical", "jazz", "ethnic music", "country songs", "tutorial", "string instrument", "mandolin instrumental", "8 stringed instrument", "country song", "bluegrass", "high notes", "melodious", "sweet", "lute instrument", "soprano tone"] | 7 | 2ZogsGp-T4o | 381 | |
Cluck Old Hen - clawhammer banjo | This music is instrumental. The tempo is medium with an animated Banjo lead harmony. There is minimal instrumentation with cheerful ,popping vibrations of this beautiful instrument. It is lively ,spirited, cheerful and adds a beautiful layer to Country and Folk Songs. | 2012-03-18T20:37:35Z | Merit C | Playing Cluck Old Hen with a Deering Goodtime Openback Banjo. First clawhammer song I ever learned. | ["Banjo", "Guitar", "Acoustic guitar", "Music", "Musical instrument", "Plucked string instrument"] | ["instrumental", "medium tempo", "banjo", "popping", "cheerful", "stringed instrument", "lively", "spirited", "vibrations", "stringed instrument", "country music", "plucking", "folk music", "bluegrass", "african instrument", "melodious", "rhythmic"] | 7 | 4i9DgH80kDg | 597 | |
Music Maker 2008 Chillout & Ambient 2 Songs | This song is an instrumental. The tempo is medium with a melodious keyboard harmony, rhythmic guitar accompaniment, punchy drumming, subtle bass line, synth arrangement and tambourine beats. The music is soft, mellow, ambient, pleasant, uplifting, and mellifluous. | 2008-03-10T18:25:25Z | Jonas Bayerlein | magix music maker 2008 | ["Music", "Tender music"] | ["instrumental", "medium tempo", "steady drumming", "acoustic guitar", "keyboard harmony", "soft bass", "digital drum", "cymbals", "ambient", "elctronic music", "tambourine beats", "melodious", "soft", "calming", "soothing", "mood", "atmospheric", "ethereal", "enigmatic", "punchy beat"] | 7 | P240GHf9Eq4 | 2494 | |
Trinidad Music - Youth plays steelpan - Indian Trail Church | This music is instrumental. The tempo is medium with a melodic steel pan harmony. The audio quality however is inferior and amateur,so the music is muddled. There are ambient sounds of breeze and people talking , indicating that this is a live performance. | 2009-06-18T20:47:10Z | Home and Happy. | A youth pannist plays at Indian Trails Open Bible Church. Steelpans (also known as steeldrums or pans, and sometimes collectively with musicians as a steelband) is a musical instrument and a form of music originating from Trinidad. Steelpan musicians are called pannists. | ["Music", "Steelpan"] | ["white noise", "instrumental", "medium tempo", "steel pan", "amateur recording", "muddled audio", "steel drum", "inferior audio recording", "incoherent music", "melodious", "ambient sounds", "people talking", "breeze"] | 7 | _ALGXHquYkM | 3450 | |
C Harmonic Minor with a G Phrygian Ending | This music clip is an electric guitar solo lead instrumental. The tempo is fast with the guitarist playing a very emphatic, intense riff. No other instruments have been used. The music is loud, intense, engaging and catchy. | 2006-08-08T20:49:22Z | ahmedgarcia | C harmonic Minor with a G Phrygian ending. | ["Effects unit", "Electric guitar", "Music", "Harmonic", "Distortion"] | ["electric guitar", "instrumental", "string instrument", "external amplification", "vibrations", "skilful", "pop", "jazz", "country", "blues", "heavy metal", "lead instrument", "medium tempo", "sonic power", "amplified guitar", "melodious", "minimal instrumentation", "rock", "hard rock", "intense", "loud", "powerful"] | 7 | kaabXWuPWRg | 4332 | |
"Rain" on acoustic guitar Blueridge BR140A2 | This music is an acoustic instrumental. The tempo is medium with an acoustic guitar lead harmony, with minimalist instrumentation. The music is soft, soothing, pleasant, engaging, and delicate. | 2008-11-25T05:27:58Z | Jim Williams | "Rain" is an original song played on my Blueridge BR140A2 custom | ["Guitar", "Acoustic guitar", "Music", "Steel guitar, slide guitar", "Strum", "Plucked string instrument"] | ["instrumental", "medium tempo", "acoustic guitar harmony", "guitar lead", "stringed instrument", "dexterity", "melodious", "soothing", "pleasant", "vibrating strings", "no amplification", "six stringed guitar"] | 7 | z0w3Y8BGLQE | 5452 |
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;