musiccaps_details (view)
3 rows where musiccaps_aspects contains "noisy", musiccaps_aspects contains "sustained strings" and musiccaps_names contains "Music"
This data as json, CSV (advanced)
musiccaps_aspects (array) 22 ✖
- low quality 3
- noisy · 3 ✖
- sustained strings · 3 ✖
- choir 1
- crushed 1
- distorted 1
- electric guitar melody 1
- flat male vocal 1
- funny 1
- happy 1
- heartful 1
- inaudible 1
- joyful 1
- kids laughing 1
- live performance 1
- low male vocal 1
- male laughing 1
- metallic impact 1
- mono 1
- plastic impacts 1
- stuttering vocal sound effect 1
- wide synth pad 1
musiccaps_names (array) 7 ✖
- Music · 3 ✖
- Baby laughter 1
- Bell 1
- Chuckle, chortle 1
- Giggle 1
- Scary music 1
- Speech 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Halloween Scary Music, Evil Theme | The low quality recording features a live performance that's barely audible and it consists of sustained strings and a choir. It sounds crushed, distorted and very noisy, as it was recorded with a broken microphone. | 2007-12-14T21:16:12Z | holidayhaunting | This is a Video of our Halloween Display using a piece of music called Halloween Scary Music, Evil Theme. http://holidayhaunting.uuuq.com | ["Music", "Scary music"] | ["low quality", "noisy", "crushed", "distorted", "live performance", "choir", "sustained strings", "inaudible"] | 4 | GMtb7U-8IYM | 1712 | |
Joys of Laughter! | The low quality recording features a kid and a male laughing back and forth. There are some plastic impacts throughout it. The recording ends with a wide synth pad layered with sustained strings over which there is a low male vocal singing. It sounds joyful, happy and heartful. | 2012-11-27T20:14:46Z | Nandhiji | This is my little boy Anukash. Sharing his sacred laughter! www.nandhi.com Gratitude! Pranaams! Love! Book: Mastery of Consciousness- Awaken the Inner Prophet - Siddhar yogic mystic wisdom of Liberation. Break the limits of body, mind and circumstances. Sensitive Planet: Handsigned by Nandhi + Gift SivaSivaa Teachings Download: http://goo.gl/RDXehM Amazon: http://goo.gl/E6nDZd India: http://goo.gl/jLUEhf | ["Music", "Giggle", "Chuckle, chortle", "Baby laughter"] | ["low quality", "noisy", "kids laughing", "male laughing", "plastic impacts", "wide synth pad", "sustained strings", "low male vocal", "joyful", "happy", "heartful"] | 4 | RF3rog2YjYw | 2682 | |
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;