musiccaps_details (view)

3 rows where musiccaps_aspects contains "kids voice singing", musiccaps_author = 6 and musiccaps_names contains "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
swamy ayappan This audio contains a lot of percussion such as tablas playing a rhythm along with shakers and more. Male voices are singing something like a mantra repeating the same melody. Kids' voices are also singing the same melody in a higher octave. A bansuri flute adds little melody lines. This song may be playing during a ceremony. 2007-11-26T15:05:19Z maheshmanohar4u ayappa music video, director maheshmanohar, ["Singing", "Folk music", "Music"] ["hindi", "bansuri flute", "male voices singing", "kids voice singing", "tablas", "string instrument", "slower to medium tempo", "energetic meditative"] 6 HyXMWRU9Owc 1854
On The Good Ship Lollipop/ Sophia Lucia (4 years old) A very young sounding kid's voice is singing along to a backing track containing acoustic drums, e-bass and a quirky sounding flute sound playing a melody to which the kid is singing along. This is an amateur recording and of poor sound-quality. This song may be playing for a talent show. 2013-01-10T18:44:50Z Star*Magic Productions Sophia Lucia at four years old singing and tap dancing to a cover of Shirley Temple's "On The Good Ship Lollipop." Disclaimer; This video was uploaded with permission. No copyright infringement intended. ["Music", "Child singing"] ["amateur recording", "backing track", "kids voice singing", "acoustic drums", "flute-like instrument", "e-bass", "uptempo"] 6 Wh_g-Eiw9Kc 3128
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;