musiccaps_details (view)

1 row where musiccaps_aspects contains "female voice", musiccaps_aspects contains "techno" and musiccaps_names contains "Techno"

✎ 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
I Like Turtles TECHNO REMIX This song contains digital drums playing a groove along with an aggressive synth saw wave pad repeating the same simple melody. A male kid's voice is chopped into a sample creating a rhythmic phrase. The same goes for a female voice. So it sounds like they are singing. This is an amateur recording. This song may be playing in a funny video. 2008-08-06T15:14:12Z R H Thank you for over 1 Million views! :) Please also check out my other videos on my channel! Techno Remix of the "Zombie Kid Likes Turtles" video. Music made, as always, in Fruity Loops. Thanks for watching, and if you want, subscribing. Dont forget: I LIKE TURTLES ["Electronic music", "Music", "Techno"] ["techno", "amateur recording", "male kids voice", "female voice", "synth sound", "digital drums", "uptempo"] 6 A0XXmVts1y0 1058

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;