musiccaps_details (view)
2 rows where musiccaps_aspects contains "build up", musiccaps_names contains "Electronica" and musiccaps_names contains "Music"
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 |
---|---|---|---|---|---|---|---|---|---|---|
URF Kassadin - 1s Riftwalk CD | The low quality recording features an electro song that consists of a gliding synth lead melody played over groovy synth keys chords, exciting synth riser, punchy snare layered with claps, shimmering shakers and punchy kick hits. It sounds energetic and exciting, due to the fact that it is a build up section of the song. | 2016-04-11T15:06:37Z | Vandiril | Instant Gaming (PC Games -70%) - http://www.instant-gaming.com/igr/Vandiril/ Send me your replays here: vandiril88@gmail.com Follow me on Twitch, Facebook and Twitter: http://www.twitch.tv/vandiril https://www.facebook.com/Vandiril https://twitter.com/vandiril If you want to support me even more, you can donate here :) http://bit.ly/1tJNpmL Music: Dutty Moonshine - Takin' It Back https://www.youtube.com/watch?v=v4pTPigj0Gk https://soundcloud.com/duttymoonshine https://www.facebook.com/duttymoonshine | ["Sampler", "Electronic music", "Music", "Electronica"] | ["low quality", "electro", "gliding synth lead melody", "groovy synth keys chords", "exciting synth riser", "punchy snare", "claps", "shimmering shakers", "punchy kick", "energetic", "exciting", "build up"] | 4 | 7ym-LzgwSPE | 894 | |
Misanthrop - Rotor [RAM Records] | The Electro song loop features a build up section that consists of intense siren sound effect, synth bass swell, arpeggiated synth melody, punchy kick layered with synth stabs, snare rolls and some claps. It sounds suspenseful, intense and exciting. | 2015-09-30T11:59:03Z | NeurofunkGrid | I've waited so long for this tune. Out on the 16th of October via RAM Records. Pre-order: http://po.st/CollapseRAM - Misanthrop - Like ► http://www.facebook.com/Misanthrop.Neosignal Follow ► http://www.twitter.com/MisanthropNSGNL - RAM Records - Like ► https://www.facebook.com/RAMrecordsltd Follow ► https://twitter.com/RAMrecordsltd - NeurofunkGrid - Like ► http://www.facebook.com/NeurofunkGrid Follow ► http://www.twitter.com/NeurofunkGrid Watch ► http://www.youtube.com/NeurofunkGrid Listen ► http://www.soundcloud.com/NeurofunkGrid Get down ► http://www.mixcloud.com/NeurofunkGrid Party ► http://plug.dj/the-neurofunkgrid Merch Store ► http://neurofunkgrid.spreadshirt.fr/ Subscribe ► http://www.youtube.com/subscription_center?add_user=neurofunkgrid Logo by http://kay486.deviantart.com Animation by http://waysh.deviantart.com/ | ["Drum and bass", "Music", "Techno", "Dubstep", "Electronic dance music", "Electronica"] | ["low quality", "build up", "intense siren sound effect", "synth bass swell", "arpeggiated synth melody", "punchy kick", "claps", "punchy synth stabs", "snare rolls", "suspenseful", "exciting", "electro"] | 4 | JIoA1KsfioQ | 1989 |
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;