musiccaps_details (view)
4 rows where search matches "guitar", musiccaps_aspects contains "low quality", musiccaps_names contains "Banjo" and musiccaps_names contains "Country"
This data as json, CSV (advanced)
Suggested facets: youtube_published (date)
musiccaps_aspects (array) 30 ✖
- low quality · 4 ✖
- country 2
- folk 2
- fun 2
- happy 2
- live performance 2
- noisy 2
- passionate 2
- "4 on the floor" kick pattern 1
- acoustic guitar solo melody 1
- acoustic rhythm guitar chords 1
- acoustic steel guitar melody 1
- arpeggiated guitar melody 1
- banjo melody 1
- birds chirping 1
- crowd chattering 1
- crowd noises 1
- energetic 1
- flat girl vocal 1
- groovy acoustic rhythm guitar melody 1
- groovy bass 1
- groovy mandoline melody 1
- groovy steel guitars melody 1
- harmonizing male vocals 1
- live perforamnce 1
- nature sounds 1
- shimmering shaker 1
- unbalanced stereo 1
- upbeat 1
- walking bass guitar 1
musiccaps_names (array) 7 ✖
- Banjo · 4 ✖
- Country · 4 ✖
- Music 3
- Bluegrass 2
- Musical instrument 2
- Guitar 1
- Plucked string instrument 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
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 | |
Many A Mile | The low quality recording features a live performance of a country song that consists of a steel guitar melody, acoustic rhythm guitar chords and a walking bass guitar. There are some crowd noises in the background by which we can conclude that it is a live performance. | 2012-09-03T05:53:59Z | Ronnie's Bluegrass | Many A Mile by Mountain View at Mountaineer Opry House 2012 video by Ronnie's Bluegrass Videos | ["Banjo", "Country", "Music", "Musical instrument", "Bluegrass"] | ["low quality", "country", "live performance", "walking bass guitar", "acoustic rhythm guitar chords", "acoustic steel guitar melody", "crowd noises"] | 4 | dNK9bD3LNCc | 3779 | |
the sleepover club S01 ep 12 part 2: outdoor trip | The low quality recording features a flat girl vocal talking over a folk song that consists of an arpeggiated guitar melody played over groovy bass, shimmering shakers and "4 on the floor" kick pattern. There are some birds chirping sounds in the background. It sounds energetic, fun and happy. | 2009-06-06T04:26:32Z | lay low | ["Banjo", "Country"] | ["low quality", "flat girl vocal", "folk", "arpeggiated guitar melody", "shimmering shaker", "groovy bass", "\"4 on the floor\" kick pattern", "energetic", "fun", "happy", "birds chirping"] | 4 | ecS6SJGkhIw | 3885 | ||
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;