musiccaps_details (view)
4 rows where musiccaps_aspects contains "happy", musiccaps_aspects contains "live performance", musiccaps_aspects contains "low quality" and musiccaps_aspects contains "mono"
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 |
---|---|---|---|---|---|---|---|---|---|---|
"Chicken Reel" Annie & Mac Old Time Music Moment | The low quality recording features a live performance that consists of harmonica solo melody played over acoustic rhythm guitar chords. The recording is noisy, in mono and it sounds happy and joyful. | 2008-01-22T04:52:48Z | annieandmac | Traditional old time mountain stringband tune played here on harmonica with rhythm guitar. http://www.annieandmac.com | ["Harmonica", "Wind instrument, woodwind instrument"] | ["low quality", "noisy", "mono", "harmonica solo melody", "acoustic rhythm guitar chords", "happy", "joyful", "live performance"] | 4 | 4VbXYuCz4M0 | 577 | |
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 | |
"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;