musiccaps_details (view)
1 row where musiccaps_aspects contains "synthesizer sounds", musiccaps_names contains "Electronic dance music" and musiccaps_names contains "Techno"
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 |
---|---|---|---|---|---|---|---|---|---|---|
Tumba Ping Pong Song (Dunderpatrullen vs. Tumba Ping Pong Show) | This song contains a fast drum&bass drum that gets supported by a bass and a synthlead sound on top of it. Both play the same melody. Some different samples get drowned in. They sound like dog-barks that have been processed with effects and a lower bitrate. In the background different sound-effects are rising up in pitch. This song sounds hectic and energetic. This song may be playing in a dance club. | 2014-03-16T17:39:41Z | Tumba Ping Pong Show | The official TUMBA PING PONG SONG made by our friends in Dunderpatrullen (http://bit.ly/dptube). WEBSITE ► www.waine.se INSTAGRAM ► @wainefilms (https://www.instagram.com/wainefilms/) ► @maxmarklund (http://www.instagram.com/maxmarklund) ► @hempak (https://www.instagram.com/hempak/) CONTACT US ► team@waine.se SUBSCRIBE FOR MORE https://www.youtube.com/user/tumbapingpongshow?sub_confirmation=1 Search Words (Ignore): #tumba ping pong show, #waine, #vfx, tumba ping pong show, ping pong, pingis, ping pong tricks, cgi, vfx, visual effects, digital effects, tricks, trickshot, trickshots, trick shots, waine, when awesome is not enough, short films, show, drama, comedy, epic, weird, ping pong ball, knives, pineapple, fruit, miss ping, tumba ping pong song, geometry dash, fake, real, max marklund, anders jacobsson, henrik koelman, dj coolman, slightly mad max, mad max, dr ders, table tennis, cucumber in mouth, miss ping, miss pong, epic win, behind the blue fur, behind the blue fur, tumba ping pong show, tumba ping pong show patiently, roy andersson, a pigeon sat on a branch reflecting on existence, phuket, tumba ping pong song | ["Music", "Techno", "Trance music", "Ping", "Dubstep", "Electronic dance music"] | ["drum&bass", "electronic drums", "digital bass", "dog barking sample", "synthesizer sounds", "fast tempo", "energetic"] | 6 | lymmNwQA0WA | 4433 |
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;