musiccaps_details (view)

3 rows where musiccaps_aspects contains "medium to uptempo" and musiccaps_names contains "Music for children"

✎ 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
Новый год.mpg This audio contains acoustic drums playing a kick on every beat along with a simple e-bass line. In the background you can hear the sound of wind and a wolf's howling. A tambourine like instrument reminds of christmas and a flute like instrument is playing an uplifting melody along with a piano sound hitting short chords in the mid to higher register. This song may be playing in a funny video around christmas time. 2011-04-27T19:47:49Z Nick Новогодний мульт с Вашим карапузом В ГЛАВНОЙ РОЛИ!!!!!! ["Christmas music", "Music", "Music for children"] ["jingle", "e-bass", "acoustic drums", "wolf howling", "tambourine like instrument", "keys", "wind sounds", "flute like instrument", "medium to uptempo", "playful", "comedic atmosphere"] 6 78BtX0oNXHQ 814
The Pink Panther - Rats Song This song contains an acoustic drum playing a simple groove along with an upright bass. A piano is playing short chords along with the snare of the drums. Trumpets are playing a melody along with the male voices singing together in unison and other harmonies. In the background you can hear a synth string chord and plucks playing a little melody. This song may be playing in a theater while watching a musical. 2010-09-18T18:11:59Z LilMsKiss From the pc game The Pink Panther: Hocus Pocus Pink lyrics: Rats! Well, we're survivors It's hard to drown us 'cause we're excellent sea divers We can chew through pipes, survive a nuclear blast! Scale walls and fall and not get hurt at all - We've done it in the past Rats! Yes, we're resilient Despite attempts to wipe us out we grow by millions - And although we only live one sure year long A productive rat and wife could host a family - Fifteen thousand strong! Oh, rats! Oh, shucks! Us furry vermin's here to stay Oh, phooey! Rats, yes, rats! Ya know you're gonna need us anyway! Just think of all the break-throughs science made - At our expense! You can't deny no matter how hard you try - Our contribution's been immense! Rats! We're highly adaptable, so, what if we've got a few diseases that are contractible? And as for crops, we devastate - We've gotta eat! Tell me, what would you choose for an entree? - Poison pellets or rice, fruits, nuts and treats? Did you know that one year in Hawaii some of our brothers ate about 11 million dollars worth of sugar cane? Talk about a sweet tooth! You've heard of rats, nocturnal creatures, that means we're up all night inspecting kitchen features Wherever man goes, a rat too surely can There must be some way we could live to enjoy the same long life span Oh, rats! Oh, shucks! Us furry vermin's here to stay Oh, phooey! Rats, yes, rats! Ya know you're gonna need us anyway! Rats! Oh, rats! Us freaky vermin wanna play Rats, you bet your sweet patootie, rats Ya know you're gonna need us anyway! Rats! ["Music", "Music for children", "Speech"] ["jazz/hiphop", "upright bass", "synth strings", "trumpets", "piano", "acoustic drums", "male voices singing", "mid-range", "medium to uptempo"] 6 TcoRmHHHNgI 2853
Tuto du chien en ballon - Twist dog balloon This song contains an acoustic drum playing and comes to an end. Then a violin is playing the main melody together with a bass horn and other brass instruments in a higher register. A xylophone is also playing the melody in a higher octave. This song may be playing during a funny magic show. 2012-03-02T13:39:14Z Nikolas Tessier Nikolas le magicien vous propose le tuto du petit chien ! Facilement réalisable avec un ballon de taille 260. ["Music", "Music for children", "Violin, fiddle"] ["folkmusic", "violin", "horn", "brass", "xylophone", "drums", "uplifting energy", "medium to uptempo"] 6 _pU2KbHMN4Q 3494

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;