musiccaps_details (view)

1 row where musiccaps_aspects contains "jazz/hiphop", musiccaps_author = 6 and musiccaps_names contains "Speech"

✎ 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
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

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;