musiccaps_details (view)
4 rows where musiccaps_aspects contains "folk", musiccaps_author = 4 and musiccaps_names contains "Guitar"
This data as json, CSV (advanced)
musiccaps_aspects (array) 32 ✖
- folk · 4 ✖
- low quality 4
- passionate 3
- live performance 2
- noisy 2
- acoustic guitar solo melody 1
- acoustic rhythm guitar melody 1
- banjo melody 1
- crowd noises 1
- electric guitar melody 1
- energetic 1
- flat male vocal 1
- groovy acoustic guitar melody 1
- groovy bass 1
- harsh 1
- live perforamnce 1
- muddy 1
- nature sounds 1
- passionate male vocal 1
- punchy snare 1
- reverberant 1
- shimmering cymbals 1
- soulful 1
- steel guitar solo melody 1
- steel guitars melodies 1
- unbalanced stereo 1
- unbalanced stereo image 1
- upbeat 1
- uplifting 1
- uptempo 1
- violin melody 1
- wide clapping 1
musiccaps_names (array) 9 ✖
- Guitar · 4 ✖
- Music 4
- Musical instrument 4
- Plucked string instrument 4
- Banjo 3
- Acoustic guitar 1
- Country 1
- Singing 1
- Ukulele 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Foggy Mtn Breakdown (Must-Own DVD) | The low quality recording features a live performance of a folk song and it contains a steel guitar solo melody played over, acoustic rhythm guitar, electric guitar melody, shimmering cymbals, punchy snare, groovy bass, followed by violin melody, crowd noises and claps. It sounds passionate, uptempo, soulful and energetic. | 2009-07-15T05:50:54Z | jamesarthurjohnson | From All-Star Bluegrass Celebration DVD - Ricky Skaggs, Earl Scruggs, Vince Gill, Travis Tritt, Jerry Douglas, and on and on... | ["Banjo", "Guitar", "Music", "Musical instrument", "Plucked string instrument"] | ["low quality", "folk", "live performance", "wide clapping", "crowd noises", "steel guitar solo melody", "acoustic rhythm guitar melody", "groovy bass", "punchy snare", "shimmering cymbals", "electric guitar melody", "violin melody", "passionate", "uptempo", "soulful", "energetic"] | 4 | GuHDy--gWiM | 1758 | |
Nicholas Barron - Devil Dog - www.candyrat.com | The low quality recording features a folk song being covered by passionate male vocal and groovy acoustic guitar melody. It sounds uplifting and a bit harsh, muddy and unbalanced as far as the stereo image goes. | 2007-05-22T22:38:12Z | Candyrat Records | CD - AS I AM - http://www.candyrat.com Nicholas Barron http://www.nicholasbarron.com/ | ["Singing", "Guitar", "Acoustic guitar", "Music", "Musical instrument", "Ukulele", "Plucked string instrument"] | ["low quality", "passionate male vocal", "groovy acoustic guitar melody", "reverberant", "folk", "uplifting", "unbalanced stereo image", "harsh", "muddy"] | 4 | _RLsXrr0fQo | 3468 | |
Old Man Luedecke - I'm Fine (I Am, I Am) | The low quality recording features a short snippet of flat male vocals, followed by steel guitar melodies. It sounds passionate, even though the recording is very noisy. | 2012-10-01T19:57:33Z | AnalogSongs | Recorded live on the beach in Chester, NS with Old Man Luedecke and Joel E Hunt on mandolin. From the new album Tender is the Night, released October 2nd, 2012 http://oldmanluedecke.ca Video by Analog Songs: http://www.analogsongs.ca Camera and post production: Stephen Cooper and Katy Hopkins, Audio recording and post production: Cameron Dexter | ["Banjo", "Guitar", "Music", "Musical instrument", "Plucked string instrument"] | ["low quality", "noisy", "steel guitars melodies", "flat male vocal", "passionate", "folk", "live performance"] | 4 | kIEEDYowZhA | 4307 | |
Willow & Lee - Foggy Mountain Breakdown | The low quality recording features a live performance of a folk song and it consists of acoustic guitar solo melody, followed by banjo melody. The recording is noisy, there are some natural sounds - since it was performed outdoors and the stereo image is unbalanced due to the fact that the instruments are leaning towards the right channel of the stereo image. It still sounds passionate and upbeat. | 2014-06-01T14:36:03Z | WillowOsborne | 13-year Old Willow Osborne & Lee Marcus performs "Foggy Mountain Breakdown" at Dollywood, Pigeon Forge, TN. (May 2014) | ["Banjo", "Country", "Guitar", "Music", "Musical instrument", "Plucked string instrument"] | ["low quality", "noisy", "live perforamnce", "unbalanced stereo", "nature sounds", "acoustic guitar solo melody", "upbeat", "banjo melody", "folk", "passionate"] | 4 | qyCea2TuUV4 | 4840 |
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;