musiccaps_details (view)
2 rows where musiccaps_aspects contains "groovy synth keys chords", musiccaps_aspects contains "shimmering shakers" and musiccaps_author = 4
This data as json, CSV (advanced)
musiccaps_aspects (array) 20 ✖
- groovy synth keys chords · 2 ✖
- shimmering shakers · 2 ✖
- build up 1
- claps 1
- echoing wide pig oink sound effects 1
- electro 1
- energetic 1
- exciting 1
- exciting synth riser 1
- fun 1
- gliding synth lead melody 1
- groovy bass 1
- happy 1
- happy tinny bells melody 1
- low quality 1
- muffled claps 1
- punchy kick 1
- punchy snare 1
- simple piano 1
- soft kick 1
musiccaps_names (array) 5 ✖
- Music 2
- Electronic music 1
- Electronica 1
- Oink 1
- Sampler 1
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 | |
PEPPA PIG - En la busqueda del tesoro! | This kids song features groovy synth keys, chords, simple piano melody, echoing and wide pig oink sound effects, shimmering shakers, muffled claps, soft kick hits and groovy bass. It sounds fun and happy - like something that children would listen to in their favorite tv shows. | 2015-08-24T16:32:53Z | eximent | Show en Vivo de Peppa Pig Mayor informacion del evento visite www.eximent.com //Live event under Rights EONE for © for Exim Entertainment (EXIMENT) LIVE SHOWS: | ["Music", "Oink"] | ["simple piano", "groovy synth keys chords", "echoing wide pig oink sound effects", "happy tinny bells melody", "shimmering shakers", "muffled claps", "groovy bass", "soft kick", "fun", "happy"] | 4 | tmabzx6yxqs | 5063 |
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;