musiccaps_details (view)
4 rows where musiccaps_aspects contains "exciting", musiccaps_aspects contains "punchy kick" 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 |
---|---|---|---|---|---|---|---|---|---|---|
Pirates of the Caribbean Theme Song Techno Remix | The low quality recording features an electro song that consists of a punchy kick, shimmering hi hats, echoing stuttering vocal, punchy snare and synth down sweep. It sounds energetic and exciting. | 2011-07-31T09:13:46Z | iRuckaz | Hit The Subs Button Please ... | ["Electronic music", "Music", "Techno", "Trance music"] | ["low quality", "punchy kick", "shimmering hi hats", "echoing stuttering vocal", "synth down sweep", "punchy snare", "energetic", "exciting", "electro"] | 4 | BUDb8YieUgU | 1244 | |
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 | |
Phantom of The Opera (OSODOPEO Electro-house / Dubstep Remix) | The Electro House song features sustained organ keys, chords, filtered drums, punchy kick hits layered with energetic crash and addictive synth lead melody. Right before the drop, there is a short snare roll. It sounds energetic, intense and exciting, as the song is preparing to drop. | 2012-04-30T01:06:08Z | OSODOPEO (Official) | Check out my originals and other remixes! www.soundcloud.com/osodopeo | ["House music", "Music", "Techno", "Trance music", "Dubstep", "Electronic dance music", "Dance music", "Soundtrack music"] | ["electro house", "sustained organ synth keys chords", "snare roll", "filtered drums", "punchy kick", "addictive synth lead melody", "energetic", "exciting", "intense", "energetic crash cymbal"] | 4 | JZWJlUdYpCU | 2018 | |
BEST TECHNO SONG 2013! | The Electro song features a filter modulated synth melody, groovy synth bass, shimmering hi hats, punchy kick and snare hits, followed by short snare roll, haunting synth lead, low pitched male vocal introducing the section and high pitched riser that builds the energy up. It sounds energetic, upbeat and exciting - like something you would hear in clubs. | 2008-12-19T15:07:54Z | Kitingnoobs | Try worlds largest FREE game: League of Legends, its for both Europe and America sign up here for double exp! http://signup.leagueoflegends.com/?ref=4d1223da0a0c3734874312 | ["Electronic music", "Music", "Techno"] | ["electro", "filter modulated synth melody", "groovy synth bass", "shimmering hi hats", "low pitched male vocal", "punchy snare", "punchy kick", "high pitched riser", "short snare roll", "energetic", "haunting synth lead", "upbeat", "exciting"] | 4 | P1Vxm_ICSG0 | 2493 |
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;