musiccaps_details (view)

1 row where musiccaps_aspects contains "bizarre", musiccaps_aspects contains "chipmunk vocal", musiccaps_aspects contains "jingle" and musiccaps_names contains "Child singing"

✎ 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
Cute baby singing Happy Birthday to You This is a heavily edited version of a birthday song. The track has been transposed to make the original vocal sound like a little girl which resulted in a chipmunk vocal effect. The piano playing the melody and the electronic drum beat is at an irritatingly higher pitch than normal. This creates a bizarre atmosphere. It could be used in nightmare sequences in video games or TV shows. 2009-07-01T02:07:57Z x0xbundleoflovex0x Thank you for visiting my channel =D If you want a picture of your baby to sing or you want to make a special greeting card please: 1. Subscribe to my channel 2. Send me a picture of your baby with the song that you want him/her to sing. 3. And I will send you the link as soon as possible. P.S. I do put the videos that I make in my channel, so please if you dont want the video to be posted dont send me an email. Thanks ["Music", "/t/dd00004", "Child singing"] ["jingle", "chipmunk vocal", "transposed instruments", "piano", "electronic drums", "high pitch", "irritating", "poor quality", "bizarre"] 9 -IZbvEO9wzU 34

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;