musiccaps_details (view)
2 rows where musiccaps_aspects contains "energetic" and "youtube_published" is on date 2009-07-15
This data as json, CSV (advanced)
musiccaps_aspects (array) 24 ✖
- energetic · 2 ✖
- low quality 2
- punchy snare 2
- acoustic rhythm guitar melody 1
- aggressive 1
- boomy bass 1
- crowd cheering 1
- crowd noises 1
- distorted 1
- electric guitar melody 1
- electro 1
- folk 1
- groovy bass 1
- live performance 1
- mono 1
- muffled 1
- noisy 1
- passionate 1
- shimmering cymbals 1
- soulful 1
- steel guitar solo melody 1
- uptempo 1
- violin melody 1
- wide clapping 1
musiccaps_names (array) 9 ✖
- Music 2
- Banjo 1
- Crowd 1
- Electronic music 1
- Guitar 1
- Musical instrument 1
- Plucked string instrument 1
- Whoop 1
- Yell 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 | |
Prodigy Smack My Bitch Up EXIT 2009 - The Best | The low quality recording features an electro song played live and it consists of at least a punchy snare and a boomy bass. There are some crowd cheering noises in the background. It sounds muffled, energetic, aggressive and distorted as the recording is very noisy and in mono. | 2009-07-15T05:06:06Z | strika88BL | The Best Live Performance EVER. Look at 04:00 incredible moment. | ["Electronic music", "Crowd", "Music", "Whoop", "Yell"] | ["low quality", "muffled", "electro", "aggressive", "punchy snare", "boomy bass", "distorted", "noisy", "mono", "crowd cheering", "energetic"] | 4 | qtNTHnXOQew | 4831 |
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;