musiccaps_details (view)
2 rows where musiccaps_aspects contains "shimmering hi hats", musiccaps_author = 4 and musiccaps_names contains "Afrobeat"
This data as json, CSV (advanced)
musiccaps_aspects (array) 21 ✖
- low quality 2
- shimmering hi hats · 2 ✖
- acid aggressive synth melody 1
- bleating goat sound effect 1
- boomy 808 bass 1
- boomy bass 1
- claps 1
- crispy snare 1
- electro 1
- energetic 1
- flat male vocal 1
- funny 1
- parody 1
- percussive elements 1
- pop 1
- repetitive synth lead melody 1
- scratching sound effect 1
- sizzling 1
- sizzling riser 1
- stuttering vocal effect 1
- wide layered vocals 1
musiccaps_names (array) 12 ✖
- Afrobeat · 2 ✖
- Music 2
- /t/dd00032 1
- Drum machine 1
- Dubstep 1
- Electronic dance music 1
- House music 1
- Musical instrument 1
- Sampler 1
- Synthesizer 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 |
---|---|---|---|---|---|---|---|---|---|---|
E você? Pra que você manda O QUÊEEEEEE? | The low quality recording features a pop song that consists of stuttering vocal effects, flat male vocal speaking alongside female vocal, bleating goat sound effect, some percussive elements, boomy bass, crispy snare and shimmering hi hats. There are some scratching effects in the left channel of the stereo field. It sounds funny and like it is a parody song. | 2016-05-07T01:25:41Z | CASA&VIDEO | Na hora de comprar o presente do Dia das Mães muita gente soltou o berro. Mas se você esqueceu de passar na Casa&Video, calma, ainda dá tempo. Fica ligado neste remix muito louco pra você se inspirar e garantir o presentão da mamãe mesmo depois de domingo. Mas já sabe, se o presente não for da CASA&VIDEO… O QUEEEEEEEEEEEEEEEEEEEEEEE? | ["Afrobeat", "Music", "/t/dd00032"] | ["low quality", "funny", "pop", "flat male vocal", "stuttering vocal effect", "wide layered vocals", "bleating goat sound effect", "percussive elements", "shimmering hi hats", "scratching sound effect", "boomy bass", "crispy snare", "parody"] | 4 | 6vM7Kv42Uv0 | 796 | |
EPROM - TWERKUL8 | The low quality recording features an electro song that consists of acid aggressive synth melody, repetitive synth lead melody, boomy 808 bass, claps and shimmering hi-hats. There is a sizzling riser in the first section of the loop. It sounds energetic and like something you would hear in an underground club. | 2011-04-05T12:06:37Z | Dubplate Police | Eprom's forthcoming track - Twerkul8 Massive footwork juke meets rave meets glitch hop tune!!!!! | ["Afrobeat", "Sampler", "House music", "Music", "Musical instrument", "Techno", "Trance music", "Dubstep", "Electronic dance music", "Drum machine", "Synthesizer"] | ["low quality", "sizzling", "electro", "acid aggressive synth melody", "repetitive synth lead melody", "boomy 808 bass", "claps", "shimmering hi hats", "energetic", "sizzling riser"] | 4 | INBx8CrIWcg | 1900 |
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;