musiccaps_details (view)

1 row where musiccaps_aspects contains "violent", musiccaps_author = 9 and "youtube_published" is on date 2015-08-30

✎ 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
Sodor Demolition Derby 8 | Thomas and Friends Trackmaster | Strongest Engine This is a loud rock music piece played over two toy trains crashing. There is an even louder explosion sound effect whenever the toys crash. The distorted electric guitar plays a simple tune in the minor scale while the acoustic drums keep a basic rock beat as the rhythmic background. 2015-08-30T14:00:00Z Train Ninja Thanks for all the requests everyone. Sorry if I can't get to all of them, but keep them coming. You never know if we end up picking yours! Thanks to +Danielle Webster and +thenewduckthegwr engine for the request. We gave some of the new trackmasters a speed boost to make it more exciting. Ryan, Gator, and Samson each got an upgrade. Here are today's requested competitors: Salty vs Dennis Arthur vs Ryan Gator vs Thomas Diesel 10 vs Samson Check out some of our other Demo Derby videos if you haven't already. Demo Derby 1: https://youtu.be/V48gyFh_2pM Demo Derby 2: https://youtu.be/fFVXX2k9ZDw Demo Derby 3: https://youtu.be/aMqVlhC7QaY Demo Derby 4: https://youtu.be/uD9VypbjAoI Demo Derby 5: https://youtu.be/eRYcLWhbQRY Demo Derby 6: https://youtu.be/IJGX2F6O-mc Demo Derby 7: https://youtu.be/aPFptI9hUPg Thanks for watching! Please Subscribe TrainNinja Channel: www.youtube.com/trainninja Facebook: www.facebook.com/trainninja ["Music", "Boom"] ["rock music", "sound effects", "noise", "explosion", "crash", "distorted electric guitar", "acoustic drums", "loud", "violent"] 9 BMPmavj4keA 1231

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;