musiccaps_details (view)
3 rows where musiccaps_aspects contains "flat male vocal", musiccaps_aspects contains "funny" and musiccaps_author = 4
This data as json, CSV (advanced)
musiccaps_aspects (array) 27 ✖
- flat male vocal · 3 ✖
- funny · 3 ✖
- low quality 3
- parody 2
- bleating goat sound effect 1
- boomy bass 1
- crispy snare 1
- crowd cough 1
- electric guitar melody 1
- funny synth lead 1
- harmonized mixed vocal 1
- male cough 1
- metallic detuned percussion 1
- metallic impact 1
- mono 1
- noisy 1
- percussive elements 1
- pop 1
- scratching sound effect 1
- shimmering hi hats 1
- stuttering vocal effect 1
- stuttering vocal sound effect 1
- sustained strings 1
- weird 1
- wide layered vocals 1
- wide sustained strings melody 1
- wooden percussion hits 1
musiccaps_names (array) 8 ✖
- Music 3
- /t/dd00032 1
- Afrobeat 1
- Bell 1
- Carnatic music 1
- Mantra 1
- Speech 1
- Throat clearing 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 | |
funny video nivaaran cough syrup ad film | The low quality recording features a parody that contains metallic detuned percussion, funny synth lead, wide sustained string melody in the background, male and crow cough, wooden percussion hits layered with coughs and flat male vocals, alongside harmonized mixed vocals, singing over it. It sounds funny and weird - almost like a TV commercial. | 2011-09-06T16:05:17Z | cinebharathnews | its a funny creative ad | ["Carnatic music", "Mantra", "Music", "Throat clearing"] | ["low quality", "metallic detuned percussion", "funny synth lead", "wide sustained strings melody", "male cough", "crowd cough", "harmonized mixed vocal", "flat male vocal", "wooden percussion hits", "funny", "parody", "weird"] | 4 | Z7V7Curou7s | 3342 | |
Thomas & Friends ep 18 A Bad Day for Freddie | The low quality recording features a flat male vocal talking over electric guitar melody and sustained strings, with some metallic impact sound and stuttering vocal sound effect. It sounds funny and the recording is noisy and in mono. | 2008-07-24T18:28:24Z | Daniel Alsop | Here's the 2nd narrow gauge episode this time featrueing Fearless Freddie. | ["Bell", "Music", "Speech"] | ["low quality", "noisy", "mono", "flat male vocal", "stuttering vocal sound effect", "sustained strings", "electric guitar melody", "metallic impact", "funny"] | 4 | q7sK_xrJz-k | 4755 |
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;