musiccaps_details (view)

1 row where musiccaps_aspects contains "taiko drums", musiccaps_names contains "Background music", musiccaps_names contains "Music" and musiccaps_names contains "Theme music"

✎ View and edit SQL

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
Xenoblade Chronicles X BGM - Oblivia [亡KEI却KOKU心] (Day/Night Extended) The epic music excerpt starts off full force with an orchestral ensemble playing loud blocks of sound. The taiko drums play with the same rhythm the orchestra does. After a few seconds the volume is dialed down and one can hear a melody being created from electronic sounds and possibly a bass guitar. In the background a metallic percussive instrument is being played with bare hands. 2015-12-08T21:20:06Z ZXApocrypha Oblivia's theme from Xenoblade Chronicles X, extended. The track from the OST is titled 亡KEI却KOKU心 (Boukyaku Keikoku), and contains both the day and night themes which play during the game. Likely my favorite daytime field theme in this game. Game: Xenoblade Chronicles X Developers: Monolith Soft, Nintendo SPD Publisher: Nintendo Composer: Hiroyuki Sawano ["Sampler", "Background music", "Theme music", "Music", "Drum machine"] ["taiko drums", "electronic sounds", "orchestra", "epic music"] 2 Bd0PbyrG6H4 1266

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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;