musiccaps_details (view)
4 rows where musiccaps_names contains "Water"
This data as json, CSV (advanced)
| video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
|---|---|---|---|---|---|---|---|---|---|---|
| Gatos bebiendo agua del grifo, aunque no saben... | In the forefront you can hear water running while a jazz piece is playing in the background. This is an amateur recording. | 2009-10-07T00:31:20Z | sardaes | http://www.sarda.es Un gato que no sabía beber agua del grifo, pero lo intentaba. Mascotas divertidas y gatos simpaticos y graciosos bebiendo. | ["Music", "Water", "Gush"] | ["jazzmusic", "background music", "water running sound", "amateur recording"] | 6 | 2WxUIkF2zEw | 374 | |
| 15 Types of NSmen | The song is an instrumental piece with various tracks. The song is medium tempo with a piano accompaniment, groovy bass line , steady drumming track, a male sighing in pleasure and water filling a bottle tone. The song is a mix bag of music tracks for various scenes. The song is an instrumental track for a funny YouTube video. | 2013-06-13T09:30:44Z | Wah!Banana | We're on Facebook! http://www.facebook.com/wahbananasg And Twitter @wahbananasg In collaboration with Night Owl Cinematics Facebook: https://www.facebook.com/Nightowlcine... Youtube: http://www.youtube.com/alozerk Guest Starring Clifford: http://www.facebook.com/clifford.yow.7 James: http://www.youtube.com/james060688 Franster: http://www.facebook.com/franster.wong Sikeen: https://www.facebook.com/SikeenNOC Subscribe to Wah!Banana! We bring you the best locally flavoured comedy in Singapore and Malaysia! Tune in every Thursday for brand spanking new content featuring our cast and crew. | ["Music", "Trickle, dribble", "Water", "Outside, rural or natural"] | ["piano accompaniment", "different music tracks", "youtube", "idea music track", "audio transitions", "forest ambient sounds", "male singer", "water filling sounds", "medium tempo", "steady drumming", "insect noises", "ambient tones", "comical", "funny video music track", "male sighing tones", "poor audio quality", "marching style drumming"] | 1 | PAX2PMha2dU | 2514 | |
| 360° of Zooming Down a Water Slide at Splash Harbour Water Park | This music is instrumental. The tempo is fast with lively synthesiser arrangements and electronic beats. There are whooshing sounds in the background, with a male voice screaming in excitement and someone sipping liquid out of an almost empty glass. This music is superimposed over a home video. | 2016-07-19T15:39:07Z | Visit St. Pete Clearwater | Hop on your tube and ready, set, go! Water splashing in your face as you twist, turn and spin - you're on the 42-foot water slide called Smuggler's Run at Splash Harbour Water Park on Indian Rocks Beach, FL. | ["Music", "Slosh", "Water"] | ["instrumental", "electronic music", "fast tempo", "home video", "excited voice", "happy", "cheerful", "fun", "sunny", "exciting", "sound of sipping liquid", "synthesiser arrangements", "whooshing sound", "sound of"] | 7 | Rwt8j_USbWI | 2730 | |
| Alkali metals | Loud sound effects such as smoldering sounds, water splashing, and an explosion. Quick scene transition sound as well a short male laugh. Background score is mellow orchestral featuring a string pad with an oboe taking the lead melody. | 2006-06-22T01:41:22Z | ioosef | what happens when alkali metals enter in contact with water (i'll give you a hint, it goes BOOM!) | ["Explosion", "Music", "Boom", "Water"] | ["sound fx", "explosion", "smoldering sounds", "water splashing", "scene transition sound", "background orchestral score", "string pad", "oboe melody", "man laughing"] | 8 | cqeVEFFzz7E | 3747 |
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;