musiccaps_details (view)
3 rows where musiccaps_aspects contains "exciting", musiccaps_aspects contains "flat male vocal" and musiccaps_aspects contains "punchy kick"
This data as json, CSV (advanced)
musiccaps_aspects (array) 23 ✖
- energetic 3
- exciting · 3 ✖
- flat male vocal · 3 ✖
- low quality 3
- punchy kick · 3 ✖
- punchy snare 3
- shimmering cymbals 2
- background male vocals 1
- brass melody 1
- electro 1
- funky electric guitar 1
- groovy 1
- groovy bass 1
- groovy bass guitar 1
- groovy synth keys melody 1
- hip hop 1
- mono 1
- noisy 1
- punk 1
- shimmering hi hats 1
- synth lead melody 1
- upbeat 1
- wide electric guitars 1
musiccaps_names (array) 10 ✖
- Music 3
- Background music 1
- Happy music 1
- Hip hop music 1
- Pop music 1
- Punk rock 1
- Rapping 1
- Scratching (performance technique) 1
- Singing 1
- Ska 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
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 | |
Pocket Rocket - See The Problem (Punk Rock Music Video) | The low quality recording features a punk song that contains flat male vocal singing over punchy kick and snare hits, shimmering cymbals, wide electric guitars and groovy bass guitar. It sounds energetic, exciting and upbeat - like something you would jump to at concerts. | 2006-09-22T06:12:51Z | powerswap | The first music video of the aspiring austrian punk-rock-band "Pocket Rocket". | ["Background music", "Music", "Punk rock", "Pop music", "Ska", "Happy music"] | ["punk", "energetic", "exciting", "groovy bass guitar", "wide electric guitars", "shimmering cymbals", "punchy snare", "punchy kick", "flat male vocal", "upbeat", "low quality"] | 4 | pbVYSktQ5jE | 4726 | |
Fabolous, Jay Z, & Young Jeezy F A B O L O U S Vol 2 Block On Smash | The low quality recording features a hip hop song that consists of a flat male vocal, alongside some background male vocals, rapping over punchy kick and snare hits, shimmering hi hats, funky electric guitar, brass melody, groovy synth keys melody and groovy bass. It sounds energetic, groovy and exciting. | 2009-08-07T17:12:38Z | briellehursl21 | ["Music", "Rapping", "Hip hop music"] | ["hip hop", "punchy snare", "punchy kick", "funky electric guitar", "brass melody", "groovy synth keys melody", "groovy bass", "shimmering hi hats", "flat male vocal", "background male vocals", "energetic", "groovy", "exciting", "low quality"] | 4 | x6U1gX5a_4M | 5304 |
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;