musiccaps_details (view)
2 rows where musiccaps_aspects contains "electro", musiccaps_aspects contains "energetic" and musiccaps_aspects contains "groovy synth bass"
This data as json, CSV (advanced)
musiccaps_aspects (array) 19 ✖
- electro · 2 ✖
- energetic · 2 ✖
- groovy synth bass · 2 ✖
- shimmering hi hats 2
- addictive 1
- exciting 1
- filter modulated synth melody 1
- groovy kick hits 1
- haunting synth lead 1
- high pitched riser 1
- low pitched male vocal 1
- pulsating synth lead melody 1
- punchy kick 1
- punchy snare 1
- repetitive male vocals 1
- short snare roll 1
- toms roll 1
- upbeat 1
- wide claps 1
musiccaps_names (array) 6 ✖
- Music 2
- /t/dd00032 1
- Dance music 1
- Electronic music 1
- Funk 1
- Techno 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
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 | |
Stardust - Music sounds better with you (miami horror remix) | The Electro song features a repetitive male vocal singing over shimmering hi hats, tom rolls, wide claps, groovy kick, pulsating synth lead melody and groovy synth bass, which glues everything together. Even though the vocal is repetitive, it sounds very addictive and energetic in context. | 2013-01-26T03:00:47Z | MisterWright | I love this mix of this song! and I thought this video went well with it to. :D | ["Funk", "Music", "Dance music", "/t/dd00032"] | ["electro", "pulsating synth lead melody", "toms roll", "shimmering hi hats", "wide claps", "repetitive male vocals", "groovy kick hits", "groovy synth bass", "addictive", "energetic"] | 4 | s_BKo_1LzJM | 4963 |
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;