musiccaps_details (view)
1 row where musiccaps_aspects contains "sound effects", musiccaps_names contains "Music" and "youtube_published" is on date 2016-03-26
This data as json, CSV (advanced)
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
[Old] (kOBT): Nyuha's PvE Fencer Demonstration [Pelta C1 / Barb C3 / Fencer C1] - Tree of Savior | The music excerpt features a sparse melody being played by an electronic sound that has a vibrating reverb effect on. A synth bass accompanies the melody by playing two notes per beat, one being low and the other an octave higher. In the background one can hear sound effects. | 2016-03-26T01:35:13Z | Woeden | The goal of this video is just to show how Fencer C1 and Barbarian C3 interacts. Also demonstrating the basic skills. Some skills may be changed since the Korean Open Beta. This footage is from the Korean Open Beta (March 2016), so, things may be changed a bit for Fencers. Take a good look at the updated builds;. http://www.tosbase.com/tools/skill-simulator/builds/?name=&class=Fencer&order=Rating&search=search In resume: Fencer with Rodelero = PvP Fencer with anything else = PvE (Most can work on PvP too, for sure. But you'll suffer a bit more without the class). (ノ◕ω◕)ノ | ["Music", "Breaking"] | ["electronic sounds", "sound effects", "synth bass"] | 2 | 9VE1-3q27Qg | 1015 |
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;