musiccaps_details (view)

1 row where musiccaps_aspects contains "digital bell", musiccaps_aspects contains "low quality" and musiccaps_names contains "Doorbell"

✎ 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
Meritline Wireless Door Bell, with 1 Remote 1 Chime 38 Sounds, V003A (item# 600-860) The low quality recording features a sound of a digital bell, followed by crowd noises in the background. The recording is noisy and in mono. 2010-09-23T06:25:40Z Ivy Gu Wireless Door Bell, with 1 Remote 1 Chime 38 Sounds, V003A Features: DIY designing, you don't need to seek help from professionals or set line or excavate a hole on the wall. You can install it anywhere you like in your apartment. 38 sound types to choose from 'Up' & 'Down'switch, including many popular songs. 3 levels volume control. Working distance: approx. 50 meters or 164 feet . Powered by: Remote 1 12V 23A battery (MN21/MS21 V23GAL L1028), Chime 110V . Attention: Please use the good quality alkaline battery for doorbells. Don't use the bad quality battery Don't install this product in the sunny or rainy place. http://www.meritline.com/wireless-door-bell-with-1-remote-1-chime-38-sounds-v003a---p-55406.aspx?source=youtube ["Bell", "Doorbell"] ["low quality", "noisy", "mono", "crowd noise", "digital bell"] 4 Vbx6TFxSPYY 3012

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;