musiccaps_details (view)

1 row where musiccaps_names contains "Reversing beeps"

✎ 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
In Asia - Episode 1 - MALAYSIA A male singer sings this emotional song. The song is medium tempo with guitar accompaniment, strong bass line, steady drumming rhythm, violins playing emotional and tambourine percussion. The song is overlapped with sounds of a vehicle engine and Tarmac sounds. 2011-10-04T07:30:49Z ISENSEVEN This is the first out of four Episodes about a trip to SouthEast Asia in Fall 2010. Stefan, Clemens and Vincent were travelling in a Landrover through Malaysia, Thailand, Laos and Cambodia for 2 months. Of course, they brought our little DSLRs to capture every great moment of this memorable journey. Connect with us: ▶SUBSCRIBE: http://www.goo.gl/Wuj2mu ▶OFFICIAL SITE: http://www.isenseven.tv/ ▶FACEBOOK: http://www.facebook.com/isen7 ▶TWITTER: @isen7official ▶INSTAGRAM: http://statigr.am/isensevencrew ▶TRAILER: http://www.youtube.com/watch?v=fKGT_WQ7iM8 ▶EPISODE 2 - THAILAND: http://www.youtube.com/watch?v=aPl2TICNWA8 ▶EPISODE 3 - LAOS: http://www.youtube.com/watch?v=evCd1dLg4I0 ▶EPISODE 4 - CAMBODIA: https://www.youtube.com/watch?v=4I4USTI-Ap8 Filmed by Vincent Urban & Clemens Krüger Shot with Canon 7D Edited by Vincent Urban Uzi & Ari - "Mountain / Molehill" The Travelling Band - "Sundial" ["Reversing beeps", "Music"] ["male singer", "melancholic music", "song fade", "travel show sound track", "wanderlust", "adventurous", "exciting", "vehicle driving sounds", "jeep stopping", "travel show background music", "ambient noises", "guitar accompaniment", "tambourine percussions", "engine whirring noises", "tarmac sounds", "noise ambient sounds", "violins playing sadly"] 1 AFwmMFq_xlc 1093

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;