musiccaps_details (view)
1 row where search matches "guitar", musiccaps_aspects contains "steel guitar solo melody" and musiccaps_names contains "Banjo" sorted by youtube_description
This data as json, CSV (advanced)
Suggested facets: youtube_published (date)
musiccaps_aspects (array) 16 ✖
- acoustic rhythm guitar melody 1
- crowd noises 1
- electric guitar melody 1
- energetic 1
- folk 1
- groovy bass 1
- live performance 1
- low quality 1
- passionate 1
- punchy snare 1
- shimmering cymbals 1
- soulful 1
- steel guitar solo melody · 1 ✖
- uptempo 1
- violin melody 1
- wide clapping 1
musiccaps_names (array) 5 ✖
- Banjo · 1 ✖
- Guitar 1
- Music 1
- Musical instrument 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 |
---|---|---|---|---|---|---|---|---|---|---|
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 |
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;