musiccaps_details (view)
2 rows where musiccaps_aspects contains "riser" and musiccaps_author = 3
This data as json, CSV (advanced)
musiccaps_aspects (array) 11 ✖
- riser · 2 ✖
- build-up 1
- clock tempo 1
- electronic dance music 1
- fuzzy synth 1
- high pitched synth 1
- motif 1
- reverb 1
- synth melody 1
- water droplet 1
- wood percussion 1
musiccaps_names (array) 3 ✖
- Electronic music 2
- Music 2
- Pulse 1
youtube_published (date) 2 ✖
- 2013-08-07 1
- 2015-07-25 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Novexus - Zombie Apocalypse (Black Ops 2) | Dubstep | Music for free use | The clip just contains a high pitched synth melody. The motif keeps going higher in pitch, and then eventually a riser comes in. The combination of these two factors creates a sense of build-up to a climactic moment. | 2013-08-07T06:04:12Z | UnCopyrightRecords | Read all the description first!... / Lee toda la descripción primero!... ~~ DOWNLOAD the song: http://www.youtube-mp3.org ~ http://www.vidtomp3.com/ (Also you can use programs like JDownloader) -------------------------------------------------------------------------------------------- - This song is completely free, legal and without copyright. / Esta canción es completamente gratis, legal y sin derechos de autor. ► NOTE: If you gonna use this track in your video you must give credit for the authors, or you could get a strike. ► NOTA: Si usted va a usar esta pista en algun vídeo debes de darle crédito a los autores, de lo contrario podrías recibir un strike. ↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓ Novexus - Zombie Apocalypse (Black Ops 2) You can contact the artist here: / Usted puede contactar al artista aquí: http://www.youtube.com/user/NovexusDubstep http://soundcloud.com/novexusofficial https://twitter.com/NovexusDubstep http://www.facebook.com/NovexusDubstep Song here (UCRds) http://www.youtu.be/-tKZOl4q1Kw ↑↑↑↑↑↑↑↑↑↑↑↑↑↑↑↑↑↑↑↑↑↑↑↑↑↑↑↑ Twitter: https://twitter.com/UnCopRecords UnCopyrightRecords@gmail.com SUBSCRIBE!! | SUSCRIBETE!! | ["Electronic music", "Music"] | ["high pitched synth", "riser", "fuzzy synth", "motif", "synth melody"] | 3 | -tKZOl4q1Kw | 95 | |
Obigies festival 2015 Pulse On Tour | Here we have an electronic dance song that is building up to a crescendo moment. We hear a synth sound that is almost like a combination between a wood percussion instrument and the sound of water droplets. The sound has reverb applied to it, and speeds up towards the end as the song builds up. We hear a riser sound effect as well. | 2015-07-25T21:37:04Z | Pulse café official | Le Pulse sera cette année encore au Festival d'Obigies 2015. RDV le vendredi 14 Août pour retrouver le Pulse On Tour ainsi que pour la première fois, La Bush Réunion en plein air Voir les 2 evenements sur facebook Pulse On Tour https://www.facebook.com/events/859577010800540/ La Bush Reunion https://www.facebook.com/events/777414552375798/ | ["Electronic music", "Music", "Pulse"] | ["electronic dance music", "reverb", "clock tempo", "build-up", "riser", "wood percussion", "water droplet"] | 3 | UCBocxMCdck | 2892 |
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;