musiccaps_details (view)
2 rows where musiccaps_aspects contains "flat male vocal" and musiccaps_aspects contains "percussive elements"
This data as json, CSV (advanced)
musiccaps_aspects (array) 23 ✖
- flat male vocal · 2 ✖
- low quality 2
- percussive elements · 2 ✖
- bleating goat sound effect 1
- boomy bass 1
- crispy snare 1
- crowd cheering 1
- crowd clapping 1
- energetic 1
- energetic crash cymbal 1
- exciting 1
- funny 1
- groovy bass 1
- groovy piano melody 1
- live performance 1
- loud 1
- parody 1
- pop 1
- salsa music 1
- scratching sound effect 1
- shimmering hi hats 1
- stuttering vocal effect 1
- wide layered vocals 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 | |
Salsa Colombiana al ritmo de la Sonora Carruseles [HQ].mp4 | The low quality recording features a live performance of salsa music and it consists of flat male vocal talking over microphone, followed by groovy piano melody, some percussive elements, groovy bass and energetic crash cymbals. There are some loud crowd cheering noises and claps. It sounds exciting and energetic. | 2010-06-30T17:32:30Z | SAMBABODY | Fransini from Sambabody dancing Salsa w/ Sonora Carruseles at Colombian Festival in Los Angeles. check class schedule at meetup.com/sambabody | ["Music", "Salsa music"] | ["low quality", "live performance", "salsa music", "percussive elements", "groovy piano melody", "energetic crash cymbal", "flat male vocal", "crowd cheering", "crowd clapping", "exciting", "energetic", "groovy bass", "loud"] | 4 | OQz8reoVQEI | 2438 |
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;