musiccaps_details (view)
3 rows where musiccaps_aspects contains "energetic", musiccaps_aspects contains "shimmering cymbals" and musiccaps_aspects contains "uptempo"
This data as json, CSV (advanced)
musiccaps_aspects (array) 29 ✖
- energetic · 3 ✖
- low quality 3
- shimmering cymbals · 3 ✖
- uptempo · 3 ✖
- passionate 2
- punchy snare 2
- acoustic rhythm guitar melody 1
- clapping 1
- crowd noises 1
- distorted 1
- distorted repetitive female vocal 1
- electric guitar melody 1
- electro 1
- folk 1
- groovy bass 1
- groovy bass guitar 1
- groovy organ keys 1
- hypnotic 1
- live performance 1
- noisy 1
- pulsating buzzy bass 1
- punchy "4 on the floor" kick pattern 1
- punchy kick 1
- soulful 1
- steel guitar solo melody 1
- syncopated simple synth lead melody 1
- violin melody 1
- wide clapping 1
- wide percussive elements 1
musiccaps_names (array) 13 ✖
- Music 2
- Banjo 1
- Drum and bass 1
- Electric piano 1
- Electronic organ 1
- Guitar 1
- Keyboard (musical) 1
- Musical instrument 1
- Organ 1
- Piano 1
- Plucked string instrument 1
- Techno 1
- Trance music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Tony Lucas & Kris Brooks Shouting Music Praise Break Pt.1 | The low quality recording features groovy organ keys played over punchy kick and snare hits, shimmering cymbals and groovy bass guitar. It sounds energetic, passionate and uptempo. The recording is noisy. | 2009-10-12T04:12:24Z | Ovaljean | Tony Lucas & Kris Brooks playing Shouting Music at Temple St. Jude. Filmed by Anthony Holston, Ovaljean Productions | ["Organ", "Electric piano", "Electronic organ", "Keyboard (musical)", "Piano"] | ["low quality", "uptempo", "noisy", "groovy organ keys", "punchy snare", "punchy kick", "groovy bass guitar", "shimmering cymbals", "energetic", "passionate"] | 4 | 6gTrMRQPZMU | 776 | |
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 | |
Neon Lights - Every Heartbeat (Steve Hill Vs Technikal Mix) (HQ) | The low quality recording features an electro song that contains distorted, repetitive female vocals over pulsating buzzy bass, wide percussive elements, shimmering cymbals, punchy "4 on the floor" kick pattern, claps and syncopated simple synth lead melody. It sounds hypnotic, mainly because of the repetitiveness - especially of the synth lead. It also sounds energetic, uptempo and distorted - like something you would hear in clubs during the 00s. | 2010-04-03T01:32:42Z | HardTrancEnDance | Amazing ~ | ["Drum and bass", "Music", "Techno", "Trance music"] | ["low quality", "electro", "clapping", "distorted repetitive female vocal", "pulsating buzzy bass", "wide percussive elements", "shimmering cymbals", "punchy \"4 on the floor\" kick pattern", "syncopated simple synth lead melody", "hypnotic", "energetic", "uptempo", "distorted"] | 4 | nbIwdOQ7D8A | 4560 |
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;