musiccaps_details (view)
3 rows where musiccaps_names contains "Bell" and musiccaps_names contains "Speech"
This data as json, CSV (advanced)
musiccaps_names (array) 4 ✖
- Bell · 3 ✖
- Speech · 3 ✖
- Inside, large room or hall 1
- Music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
New Skete Monastery Dog Trainers | The low quality recording features a flat female vocal talking over loud bells, reverberant male vocal talking, water leaking sounds and choir singing. It sounds like a compilation of sounds. The recording is noisy and in mono. | 2011-06-04T13:11:59Z | ABC News | new skete monastery, dog trainers, 40 years experience dog training, us | ["Bell", "Speech", "Inside, large room or hall"] | ["choir", "flat female vocal", "reverberant male vocal", "loud bells", "water leaking sound", "noisy", "mono", "low quality", "choir singing", "compilation"] | 4 | WZd2nT2Afds | 3105 | |
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 | |
Урок колокольного звона | This is the recording of a bell ringing lesson video. There is a set of three small church bells being played in various ways. There is a male voice speaking in an instructive manner on how to ring the bells. He is speaking in the Russian language. This recording can be sampled for use in beat-making. The bell sample could also fit well as a sound effect in a cartoon or a movie. | 2010-12-25T10:21:11Z | wwwKOLOKOLAru | Руководитель Международного Центра Колокольного Искусства звонарь Андрей Дьячков проводит обучение игре на церковных колоколах. Простой и очень доступный мастер-класс для звонарей храмов, а также всех желающих понять принцип управления колоколами. | ["Bell", "Speech"] | ["bell ringing lesson", "small church bells", "male voice", "russian", "instructive speaking"] | 9 | u0CgRmXMXNc | 5083 |
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;