musiccaps_details (view)
4 rows where musiccaps_aspects contains "energetic", musiccaps_aspects contains "exciting" and musiccaps_aspects contains "noisy"
This data as json, CSV (advanced)
musiccaps_aspects (array) 21 ✖
- energetic · 4 ✖
- exciting · 4 ✖
- low quality 4
- mono 4
- noisy · 4 ✖
- crowd harmonizing singing 1
- digital synth melody 1
- electro 1
- exciting male vocal 1
- flat male vocal 1
- folk 1
- joyful 1
- loud wooden percussion 1
- metronome beep 1
- phone recording 1
- punchy kick 1
- punchy snare 1
- shimmering cymbals 1
- snare roll 1
- synth lead melody 1
- uptempo 1
musiccaps_names (array) 8 ✖
- Music 3
- Drum 1
- Drum roll 1
- Folk music 1
- Percussion 1
- Scratching (performance technique) 1
- Singing 1
- Whoop 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Single Stroke Roll Speed - Drum Lesson (DRUMEO) | The low quality recording features a snare roll played over metronome beep. It sounds energetic and exciting, even though the recording is in mono and a bit noisy. | 2011-12-06T20:53:48Z | Drumeo | Learn The Drums Faster, Easier, Better: ► https://www.Drumeo.com/ Faster Hands & Feet (in 10 days) ► https://www.Drumeo.com/faster/ Study with your favorite drummers for a FREE 30-days: ►http://www.Drumeo.com/trial/ Follow us! ►Facebook: http://www.facebook.com/Drumeo/ ►Instagram: http://www.instagram.com/drumeoofficial/ ►Twitter: http://www.twitter.com/Drumeo/ View the resources for this lesson at: ►http://www.drumlessons.com/drum-lessons/drum-set-rudiments/single-stroke-roll-speed/ | ["Drum", "Drum roll", "Percussion"] | ["low quality", "snare roll", "metronome beep", "uptempo", "energetic", "exciting", "noisy", "mono"] | 4 | 8LYWfpPUokc | 914 | |
Jabbawockeez - Run This Town | The low quality recording features an electro song played on a device that produces the mono sound only. The song features a flat male vocal rapping, after which there is a drop that consists of punchy kick and snare hits, shimmering cymbals and synth lead melody. It sounds exciting and energetic, while the recording is noisy and in mono. | 2010-01-15T02:49:51Z | imajhaynation | http://jbwkz.com | ["Singing", "Scratching (performance technique)", "Music"] | ["low quality", "electro", "flat male vocal", "punchy kick", "punchy snare", "shimmering cymbals", "synth lead melody", "energetic", "exciting", "noisy", "mono"] | 4 | AzGtPHlrlzU | 1187 | |
Gajde cocek 2014 | The low quality recording features a folk song that consists of a digital synth melody played, after which there is an exciting male vocal. It sounds energetic and exciting. The recording is noisy and in mono. | 2014-01-17T07:10:40Z | Nikola Mladenovic | ["Folk music", "Music"] | ["low quality", "mono", "noisy", "exciting male vocal", "digital synth melody", "energetic", "exciting", "folk"] | 4 | T0tyLNN7SKA | 2804 | ||
AIESEC Turkey shout at NATCO before the Opening | The low quality recording features a crowd harmonized singing over loud wooden percussion. The recording is noisy, in mono and it sounds energetic, joyful and exciting. | 2011-05-24T08:40:49Z | Tatish | NATCO 2011 | ["Music", "Whoop"] | ["low quality", "noisy", "mono", "phone recording", "loud wooden percussion", "crowd harmonizing singing", "energetic", "exciting", "joyful"] | 4 | nf3LGAL1LZc | 4568 |
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;