musiccaps_details (view)

5 rows where musiccaps_aspects contains "happy" and musiccaps_names contains "Song"

✎ 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
3 ohin jingle bell The recording features a live performance of a pop song that consists of passionate female vocal singing over groovy piano melody, sustained strings melody, smooth bass, widely spread shimmering shaker, snaps and snappy rimshots. It sounds euphoric, as it brings a Christmassy vibe, and is also happy and nostalgic. 2012-12-19T10:33:32Z Ganaa Jigee ["Music of Asia", "Music", "Song"] ["live performance", "pop", "passionate female vocal", "sustained strings melody", "groovy piano melody", "smooth bass", "wide shimmering shakers", "snaps", "snappy rimshots", "euphoric", "happy", "nostalgic"] 4 20Vh6z6Ie0E 325
He Taught Me How To Yodel(Alessandra) 7yrs Old The low quality recording features a cover of a kids song that consists of sweet girl vocal singing over breathy flute melody, groovy bass and acoustic rhythm guitar. It sounds mellow, happy and fun. 2013-02-02T02:10:57Z Alessandra Riehl Recorded and edited by Germaine Mashall David (gmdavidstudios.com) ["Singing", "Yodeling", "Music", "Song"] ["sweet girl vocal", "cover", "kids song", "breathy flute melody", "groovy bass", "acoustic rhythm guitar", "happy", "fun", "mellow", "low quality"] 4 8hSmQpOPXJE 936
Animal Sounds Song | English nursery rhyme | Baby Song for children The low quality recording features a children's song that features a flat male vocal, alongside wide harmonizing children vocals, singing over acoustic rhythm guitar, steel guitar melody, happy bells melody, soft kick hits, mellow snare hits, shimmering hi hats and groovy bass. It sounds joyful, happy and exciting. 2015-05-01T09:58:23Z Kids Baby Club - children songs and nursery rhymes Fun video of animals and how they soundWe have a nursery rhyme, song, video or game for every occasion here at Kids Baby Club. With home to many cartoon 2D and 3D characters, we are a preschooler's best friend. A school away from school we make our videos not just to please the toddler but also to educate him/her with new concepts, skills, and ideas. We take kindergarten a step further with an in-depth understanding of a preschoolers comprehension, cognitive development, motor skills, language acquisition, executive functions, self-concept, identity development and moral values. 🌈 Hello toddlers, Bob The Train is here to make your learning time easy and fun with these playful toys. Click on the link to explore the toys now! - https://amzn.to/2PCeSDS We hope you liked our videos SUBSCRIBE to our channel to get a notification whenever we upload a new one. Home to ‘Ben the train’ and ‘the Crayons Club’ Kids Baby Club welcomes all toddlers to the land of fun learning! Like & Follow us on: Facebook: https://www.facebook.com/pages/Kids-Baby-Club/996037217074197 G+: https://plus.google.com/u/0/+KidsBabyClub Twitter: https://twitter.com/kidsbabyclub Visit us on our official website: https://www.uspstudios.co/creation/channel/kids-baby-club/9/ ============================================ Music and Lyrics: Copyright USP Studios™ Video: Copyright USP Studios™ ============================================ ["Singing", "Music", "Music for children", "Song"] ["low quality", "children song", "flat male vocal", "wide harmonizing children vocals", "groovy bass", "acoustic rhythm guitar", "steel guitar melody", "shimmering hi hats", "happy bells melody", "soft kick hits", "mellow snare hits", "joyful", "happy", "exciting"] 4 BfUoopDpmmY 1273
Ticking of the Clock The rock music features a nasal male voice. The voice follows a strummed electric guitar with a clean sound. The bass is backing the guitar strumms. The beat is made first with ticking sounds but then it's played by a drum kit. 2011-12-07T15:49:23Z Amygdalaindiemusic Song about time pressures ["Music", "Independent music", "Song", "Tick-tock"] ["rock&roll", "nasal male vocals", "clean electric guitar strumms", "upbeat drum kit", "bouncy melody", "danceable", "happy", "positive"] 5 fsTVRca31nI 3983
cutie girl singing (11 years old) A young female vocalist sings this upbeat country song. The tempo is fast with keyboard harmony,enthusiastic drumming , rhythmic accompaniment of acoustic guitar, mandolin, fiddle, resonator, auto harp and dobro and tambourine beats. The song is fresh, youthful, energetic, vivacious, catchy, upbeat, simple and peppy. This song is Country Pop. 2006-07-16T08:08:14Z Trofimo El origen de la Humanidad (la infancia) puede descubrirnos el origen de la música... ["Yodeling", "Music", "Song"] ["female singer", "fast tempo", "girl singing", "young vocalist", "peppy", "enthusiastic", "auto harp", "folk music", "regional music", "country side", "cowboys", "catchy", "country music", "country pop", "march like beat", "powerfully voice", "people clapping", "enthusiastic drumming", "fiddle", "mandolin", "resonator", "banjo", "tambourine beats", "youthful", "happy", "sentimental", "story telling", "powerful vocals", "vocal emphasis", "keyboard harmony", "spirited", "vibrant"] 7 hdlnugbWjKA 4122

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;