musiccaps_details (view)
2 rows where "youtube_published" is on date 2014-04-14
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 |
---|---|---|---|---|---|---|---|---|---|---|
Pulse Percussion 2014 - That Which Confines Us | This is low quality audio and all instruments are not heard clearly. The main melody is played on a marimba. This is accompanied by a timpani. Another drum set is used to play percussion with the focus on the snare and hi-hat. After the marimbas pause, one marimba plays a soft melody. This song does not feature any vocals. This song can be played in a fantasy sequence in a movie. | 2014-04-14T02:57:52Z | Jason Choo | All credit goes to Pulse Percussion and WGI. This video is for educational purposes only. This video is covered for copyright infringement under the Fair Use Act. | ["Traditional music", "Music", "Percussion"] | ["low quality audio", "marimba melody", "timpani", "percussion", "no voices", "moderate tempo", "fantasy mood"] | 0 | 2kY_ZG78V-g | 403 | |
Uncle Grandpa - Funny Face (Preview) Clip 1 | This piece of audio contains a modern pop song with drums, effects panned to left and right, a female voice singing with delay before changing into a totally different song that sounds more like a fast paced country song with a synthesizer- melody; acoustic drums and a banjo playing a fast melody along. This recording is also full of voice samples, a tiger or lion roaring, a telephone ringing. According to all these sounds and fast paced changes, it can be assumed that this recording is best played at a comedic television show for kids. | 2014-04-14T04:21:14Z | Cartoon Network Asia | When Uncle Grandpa accidentally unleashes a floating Funny Face that's so funny you laugh yourself to insanity, the guys realize that only Gus' seriousness can save them, but will he help them after they've hurt his feelings? Watch more of Uncle Grandpa on Cartoon Network! Watch more Uncle Grandpa videos: http://www.cartoonnetworkasia.com/video/uncle-grandpa Check out our Cartoon Network Facebook pages: http://www.facebook.com/asia.cartoonnetwork http://www.facebook.com/CartoonNetworkPhilippines | ["Music", "Telephone bell ringing", "Roaring cats (lions, tigers)", "Inside, large room or hall"] | ["pop/country", "changing songs", "electronic drums", "banjo", "female voice", "comedic sound effects", "background-noises", "uptempo"] | 6 | e57SBRbMXbI | 3842 |
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;