musiccaps_details (view)
2 rows where musiccaps_author = 2 and "youtube_published" is on date 2014-10-10
This data as json, CSV (advanced)
musiccaps_aspects (array) 10 ✖
musiccaps_names (array) 3 ✖
- Music 2
- Chink, clink 1
- Shatter 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Punch-Out!! Wii - Contender Rush (All Opponents, No Damage) | The excerpt features a melody played in the background on what sounds to be an accordion. In the foreground one can notice various sounds from punching to glass being broken. The crowd is cheering. All this leads me to believe this isn't a song but instead someone playing a fighting game. | 2014-10-10T21:59:15Z | Nintendo Unity | A compilation of all 13 fights in the Contender Mode of Punch-Out!! Wii. Mastered without taking damage! Music (Intro & Outro) Nuclear Flash by OverClocked ReMix remixers Sixto Sounds & zircon http://www.youtube.com/watch?v=d9dXLJeqUIA | ["Music", "Shatter"] | ["male sounds", "punching sounds", "crowd cheering", "glass smashing sound", "accordion"] | 2 | P9fh7rOIKcM | 2513 | |
#GAVX Ball Collab (hosted by Exortine) | The excerpt starts off with a brief silence after which a sound effect and two metallic sounds can be heard. After this section comes another brief silence and then a kind of light club/electronic music starts to play for a few seconds. Adding all of this up it sounds as if this isn't an actual song but rather background music and sound effects for a presentation of some sorts. | 2014-10-10T02:30:08Z | Hyun's Dojo Community | Stickfigures play some serious ball Made by #GAVX. Hosted by Exortine Hyun's Dojo ----- http://www.hyunsdojo.com Dojo FB ---------- https://www.facebook.com/hyunsdojo Dojo Twitter ----- https://twitter.com/hyunsdojo Like what we do? Donate to support the Dojo! - http://www.patreon.com/hyunsdojo http://bit.ly/SupportDojo | ["Music", "Chink, clink"] | ["metal sound", "background electronic music", "sound effects", "silence", "instrumental"] | 2 | e4R2O7XpIXU | 3840 |
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;