musiccaps_details (view)
1 row where musiccaps_aspects contains "e-bass", musiccaps_names contains "Synthetic singing" and "youtube_published" is on date 2010-01-12
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 |
---|---|---|---|---|---|---|---|---|---|---|
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
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;