musiccaps_details (view)

1 row where musiccaps_author = 6, musiccaps_names contains "Synthetic singing" and youtube_channel = "Matthew Austin"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: youtube_published (date), musiccaps_aspects (array)

video youtube_link musiccaps_caption youtube_published youtube_channel youtube_description musiccaps_names musiccaps_aspects musiccaps_author youtube_id musiccaps_rowid
Big Comfy Couch - Original Opening A kids voice is singing along to a funky bassline and little trumpet slides along with sound effects that could belong to a tv show. This audio is an amateur recording and of poor audio-quality. 2010-01-12T00:55:39Z Matthew Austin This is the original opening from "The Big Comfy Couch". As you all might know, the theme song is in French because it's not in France, it's in Quebec, Canada because this show was taking place in Canada. Why? Because, half of the people in Quebec can speak English and the people on the other half can speak French. The French title of the show was "Le Monde de Loonette". In English, the title was "The World of Loonette". This opening was used in the Season 1 episodes and the Season 2 episodes. This opening doesn't include Auntie Macasser and Snicklefritz, just Loonette, Molly, Granny Garbanzo, Major Bedhead, the Dustbunnies and the Foley Family. During the opening, Molly is wearing her yellow dress, the one she wore from the episodes "Upsey Downsey Day", "Something's Fishy Around Here", "Ping Pong Polka" and "Snug as a Bug". Also, as Loonette was holding the storybook with Molly, she didn't wear her glasses. Enjoy it! ["Music", "Synthetic singing", "Inside, small room"] ["kidsongs", "e-bass", "trumpet sound", "kids voice singing", "amateur recording"] 6 muwIU0BHXE0 4500

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;