musiccaps_details (view)
2 rows where musiccaps_aspects contains "groovy bass", musiccaps_aspects contains "punchy snare" and musiccaps_aspects contains "uptempo"
This data as json, CSV (advanced)
musiccaps_aspects (array) 18 ✖
- groovy bass · 2 ✖
- low quality 2
- punchy snare · 2 ✖
- uptempo · 2 ✖
- acoustic rhythm guitar melody 1
- aggressive vinyl scratching 1
- crowd noises 1
- electric guitar melody 1
- energetic 1
- folk 1
- live performance 1
- passionate 1
- reverberant 1
- shimmering cymbals 1
- soulful 1
- steel guitar solo melody 1
- violin melody 1
- wide clapping 1
musiccaps_names (array) 7 ✖
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 | |
SCRATCH MASTER - Spada vs Johnson | The low quality recording features an uptempo song, that consists of groovy bass and punchy kick and snare hits, being aggressively scratched by a DJ. It is very reverberant, as the sound diffuses and reflects in the space that the DJ is playing. | 2011-07-06T14:05:43Z | LUCManfredonia | Contest dj organizzato da Pandemia a r.l. presso il LUC Laboratorio Urbano Culturale "Peppino Impastato"di Manfredonia (FG) il 18 giugno 2011. www.lucmanfredonia.it | ["Scratching (performance technique)", "Music", "Scratch"] | ["low quality", "reverberant", "punchy snare", "groovy bass", "aggressive vinyl scratching", "uptempo"] | 4 | rh2D2OSxyw0 | 4896 |
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;