musiccaps_details (view)

1 row where musiccaps_aspects contains "digital drums", musiccaps_aspects contains "medium to uptempo", musiccaps_aspects contains "piano" and musiccaps_names contains "Jazz"

✎ 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
Slow Down - 5 Alarm Music New Release This song contains a piano playing a minor chord progression. In the background you can hear a synth lead pad playing kind of an easy arpeggio melody. Panned to the right side of the speakers you can hear strings playing a melody in the midrange. A male voice is singing in the midrange breaking his voice into headvoice. This song may be playing on loud speakers when alone at home. 2015-02-24T23:21:10Z 5alarmmusic Check out our new 5 Alarm Music Release "Slow Down" Off the album entitled Off The Charts - Singles. Check out the rest of our music here: www.5alarmmusicsearch.com About 5 Alarm Music 5 Alarm Music is the largest independent production music library for film, television, radio, and commercials offering UNPARALLELED MUSIC EXPERTISE. We believe in the UNIQUE POWER OF MUSIC and its significant impact on the quality and engagement of any production. WE CHAMPION THE ELEVATION OF PRODUCTION STANDARDS and access to world class music by providing exceptional customer service and superior quality music to the broadcast industry. Contact: 800.322.7879 info@5alarmmusic.com www.5alarmmusic.com www.5alarmmusicsearch.com ["Jazz", "Music"] ["pop", "piano", "synth lead sound", "digita strings", "digital drums", "male voice singing", "mid-higher register", "clapping sound", "medium to uptempo"] 6 ikEuQPSBY-0 4216

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;