musiccaps_details (view)

1 row where musiccaps_aspects contains "cartoon noises", musiccaps_aspects contains "dance music" and musiccaps_aspects contains "synth"

✎ 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 best extended Pinhead remix EVER you will find on youtube This low quality recording features an electropop song. At the beginning, there is a shooting sound. This is followed by cartoon voices. A fast paced vocal chop sequence is used for the main voice. Toward the end, another quirky voice joins in with another vocal chop sequence. This is accompanied by programmed percussion playing an electropop beat. A synth plays a repetitive lick. The bass follows the root notes of the chords. This song can be played at a club. 2009-11-19T01:50:38Z blahblahblehblehbleh MP3: http://download451.mediafire.com/ixvwy4wywung/2vzlmmmndmu/SuperPinheadRemix.mp3 ALL RIGHT PINHEAD! I FINISHED YOUR REMIX! I do not own Spongebob. FUN FACTS: This took 18 hours to make The rendering took an hour and a half I got very hungry while making this somehow I made an MP3 if you didn't know Reg. Pattern: 11_11_111_1_1_11222_2_222_222_2 EPIC PATTERN: 1*__1*_332*_1_1_11__1_1*_113_3_22221*_3_1*_332*1_1_111_11311111111111 4_4 4_4444_44 ["Music", "Cacophony"] ["low quality recording", "cartoon noises", "synth", "vocal chop sequences", "electropop song", "quirky sounds", "moderate tempo", "dance music", "shooting sounds"] 0 n7yLkcSfiuM 4520

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;