musiccaps_details (view)

1 row where musiccaps_aspects contains "bass guitar" and musiccaps_author = 8

✎ 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
MCI NHTSA Bus Crash Test. Heavily effected, instrumental psychedelic rock music featuring phaser effects, strummed acoustic guitars, and bass guitar played in a compound meter. The feeling is airy. 2010-05-07T11:16:38Z doggsho On December 14, 2007 Transportation Research Center Inc. conducted a frontal Motor Coach crash test for the National Highway Traffic Safety Administrations (NHTSA) Vehicle Research and Test Center (VRTC) in order to obtain the crash pulse from a severe frontal crash event, obtain dummy injury data for various conditions, and to study passenger seat and seat attachment strength. The 2000 MCI 102EL3 Renaissance Series, made by Motor Coach Industries (MCI) was, a 54 seat bus, weighing 42,720 pounds (test weight). The Motor Coach crashed into the barrier at 30.36 mph, with 22 instrumented crash dummies (belted and unbelted). Several on and off board high-speed cameras documented the crash test event. Over 400 data channels were recorded at 12,500 Hz. VRTC is a federal research facility located onsite at TRC (the Center). The staff conducts research and vehicle testing in support of NHTSAs mission to save lives, prevent injuries, and reduce traffic-related health care, and other economic costs. The research and development activities are performed to produce safer vehicles through improved vehicle performance, improved occupant protection systems, improved structural integrity of vehicles, increased understanding of driver behavior, and the use of intelligent systems to enhance drivers ability to avoid crashes and travel safely. ["Country", "Bluegrass"] ["strummed acoustic guitar", "phaser effect", "bass guitar", "airy", "compound meter", "instrumental", "psychedelic rock", "heavily effected"] 8 EFlGHxV5WsY 1540

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;