musiccaps_details (view)
1 row where musiccaps_aspects contains "digital bass" and musiccaps_names contains "Shatter" sorted by youtube_id
This data as json, CSV (advanced)
musiccaps_aspects (array) 8 ✖
- digital bass · 1 ✖
- digital drums 1
- energetic 1
- progressive house 1
- riser 1
- synth lead sound 1
- tension building 1
- uptempo 1
musiccaps_names (array) 4 ✖
- Electronic music 1
- House music 1
- Music 1
- Shatter · 1 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id ▼ | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Shocking Progressive House [Sylenth1] | This audio contains a very present kick on every beat. A synth bass is playing an arpeggio melody along with a synth lead sound playing in a higher pitch rising up in pitch. Then a riser sound also rises in pitch. Then the music stops and you can hear glass breaking. This song may be playing in a techno club. | 2014-05-28T11:30:41Z | VandalismSamples | 'Shocking Progressive House' is an amazing Sylenth1 soundset. This insane collection provides you the best and the freshest sounds inspired by the most popular Progressive House producers. This soundbank contains everything you need to make high professional tracks that could be released by the biggest record labels! BUY HERE: http://vandalism-sounds.com/shocking-progressive-house.html | ["Electronic music", "House music", "Music", "Shatter"] | ["progressive house", "digital drums", "synth lead sound", "digital bass", "riser", "uptempo", "energetic", "tension building"] | 6 | MVBQrBAXgw4 | 2273 |
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;