musiccaps_details (view)
3 rows where musiccaps_aspects contains "electronic music", musiccaps_aspects contains "vinyl record" and musiccaps_author = 7
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 |
---|---|---|---|---|---|---|---|---|---|---|
HTC 10 VS iPhone 6S Plus Camera Test | This music is instrumental. The tempo is medium with synthesiser articulation. The music is minimalist with the sound of wind, beep, and vinyl record scratch sound followed by silence. | 2016-04-21T15:04:38Z | TechBuzz | HTC 10 Vs iPhone 6S Plus HTC 10 Camera Test HTC 10 vs iPhone 6S Plus Camera test HTC 10 vs iPhone 6S Camera Test HTC 10 vs iPhone 6S Plus Low Light Camera Test HTC 10 vs iPhone 6S Plus Indoor Camera Test HTC 10 vs iPhone 6S Plus Outdoor Camera Test iPhone 6S Plus Vs HTC 10 Camera Test HTC 10 vs iPhone 6S Outdoor Camera Test HTC 10 vs iPhone 6S Indoor Camera Test HTC 10 vs iPhone 6S low light Camera Test HTC 10 vs iPhone 6S iPhone 6S Vs HTC 10 Camera Test HTC 10 vs iPhone 6S Plus OIS Test HTC 10 OIS test HTC 10 Opitcal Image Stabilization Test HTC 10 vs iPhone 6S Plus Opitcal Image Stabilization Test Comparison Between The Flagship Camera Phones From HTC And Apple.. Low Light Test, Indoor Test and Normal Conditions All In One Video.. Watch the Video To find out Which is better for Mobile Photography Addicts.. If You want Comparison Between HTC 10 And Any Other Phone Feel Free To Comment. | ["Music", "Sonar"] | ["instrumental", "medium tempo", "electronic music", "electronic gadgets", "electronic wave sounds", "vinyl record", "futuristic", "grim", "white noise", "wind", "modern", "static", "beep", "electrical waves", "turntable", "buzzing"] | 7 | B_ohqOgK6T8 | 1261 | |
Le Skateboard | This is electronic dance music. The tempo is fast with a turntable output, synthesiser arrangement ,digital drum beats and loud sounds of clanging, crashing and tapping superimposed on the music. The music is youthful, punchy, buoyant and enthusiastic with a dance groove. This music is EDM. | 2007-05-11T21:45:10Z | Mad Operator | A 3D animation with a skateboard, a skatepark and all that kind of stuff! | ["Scratching (performance technique)", "Music", "Skateboard"] | ["instrumental", "fast tempo", "turn table", "dj", "dj mixer", "tutn table motor", "vinyl record", "synthesiser arrangements", "digital drumming", "phonograph record", "clanging whirring", "tapping sound", "electronic music", "punchy", "groovy", "buoyant", "dance groove"] | 7 | VZfrDZhI7BU | 3009 | |
DJ Craze - DJ Routine [inthemix] | This music is an Electronic instrumental. The tempo is fast with vigorous electronic and heavily synthesised music using DL mixer, turn table and drum machines.The Ustica is youthful, futuristic, contemporary, vigorous, groovy, psychedelic, trance, hypnotic ,boomy and pulsating. This music is an Electronica/Tech House. | 2015-08-03T21:31:47Z | zebgagang | https://vk.com/trap_edm | ["Scratching (performance technique)", "Electronic music", "Music"] | ["instrumental", "fast tempo", "drum machine", "turn table", "edm", "synthesised sounds", "dance music", "ambient techno", "hypnotic", "psychedelic", "tech house", "dj mixer", "dj", "edmdance music", "electronic music", "trance music", "trap", "techno music", "scratching sound", "vinyl record", "boomy bass", "skillful", "vigorous", "pro", "dj routine", "club music", "youthful", "high-spirited", "techno trance"] | 7 | ue1sgGEvkwE | 5130 |
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;