musiccaps_details (view)
2 rows where musiccaps_aspects contains "funny" and musiccaps_names contains "/t/dd00032"
This data as json, CSV (advanced)
musiccaps_aspects (array) 19 ✖
- funny · 2 ✖
- bleating goat sound effect 1
- boomy bass 1
- brass 1
- crispy snare 1
- flat male vocal 1
- folk dance 1
- low quality 1
- male vocal 1
- mexican folk music 1
- parody 1
- percussive elements 1
- playful 1
- pop 1
- scratching sound effect 1
- shimmering hi hats 1
- shout-like singing 1
- stuttering vocal effect 1
- wide layered vocals 1
youtube_published (date) 2 ✖
- 2009-03-06 1
- 2016-05-07 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 | |
Los Pajaritos de Tacupa Michoacan-Flor De Limon | This is a Mexican folk music piece. There is a male vocal singing at a very elevated volume that resembles shouting. There is a brass melody playing alongside the vocal. The atmosphere of the piece is playful. The best use for this piece could be as an accompaniment for a folk dance. It could also be used in the soundtrack of a comedy movie or a TV show that takes place in Mexico. | 2009-03-06T01:36:01Z | Esekocho561 | ["Music", "/t/dd00032"] | ["mexican folk music", "male vocal", "shout-like singing", "brass", "playful", "funny", "folk dance"] | 9 | vKjC5HTH22o | 5173 |
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;