musiccaps_details (view)

2 rows where musiccaps_aspects contains "shimmering shakers" and musiccaps_names contains "Wedding 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
Book Now Steel Drum Band Music Beach Weddings in Florida The low quality recording features a cover with a steel drums tropical melody that plays over the playback instrumental in the background that consists of groovy bass, claps, "4 on the floor" kick pattern, shimmering shakers and tinny percussive elements. It sounds tropical, exotic and groovy, but it also has an unbalanced stereo image. 2008-02-13T22:51:02Z RythmTrail Steel Drum music http://www.rythmtrail.com RythmTrail Tel 866 495 4522 Steel Drum Band and players for beach weddings in Florida. Hire live steel drum music for weddings, parties and corporate events. Never Gonna Give You Up on Steel Drums ["Blues", "Music", "Musical instrument", "Wedding music"] ["low quality", "steel drums tropical melody", "groovy bass", "clapping", "4 on the floor kick", "shimmering shakers", "tinny percussive elements", "unbalanced stereo image", "exotic", "groovy", "tropical"] 4 hDzmNYd_eaA 4087
10 best couples wedding song 2013 The low quality recording features a ballad song sung by passionate female vocalists over groovy, mellow piano chords and shimmering shakers and tambourine. It sounds emotional and heartfelt - like something you would sing to your partner, out of love. 2013-06-12T08:20:23Z Mercedes Schmekel Beautiful wedding slideshow. Mercedes & Tim Wedding images by R.I.P Teresa Newcomb. Mercedes best friend who passed away one week after receiving her wedding pictures. A nice tribute to love! Thanks for watching!www.getdigitalmedia.com ["Music", "Wedding music"] ["ballad", "emotional", "heartfelt", "groovy mellow piano melody", "shimmering shakers", "tambourine", "passionate female vocal", "low quality"] 4 iEMTTKA7NxU 4170

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;