musiccaps_details (view)

1 row where musiccaps_aspects contains "crackles", musiccaps_aspects contains "hypnotic" and musiccaps_aspects contains "punchy kick"

✎ 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
Aphex Twin - Analogue Bubblebath (1080p HD/HQ) The low quality recording features an experimental song that consists of wide synth pad chords, wide echoing & shimmering hi hats and filtered echoing acid bass melody that slowly fade in, in the second half of the loop. There are also some subtle crackles, as the recording is a bit noisy. It sounds mystical, hypnotic and haunting. 2012-11-08T03:13:38Z YarbTheLegend **I've uploaded this entire album in high quality. Click the link below for the full playlist.** http://www.youtube.com/playlist?list=PLdgAW9D4gABZ0YBOvK5ZwwhIc9vS-xlWp&feature=view_all Classics is a compilation album first released by Richard in 1994, but most of the songs were recorded in 1990. This amazing album is basically the combination of the Xylem Tube and Digeridoo EP's with a few other songs thrown in. As always, liking and subscribing is appreciated :D Artist - Aphex Twin Song - Analogue Bubblebath 1 (Track 9) Album - Classics Year - 1994 (recorded in 1990) Copyright Disclaimer Under Section 107 of the Copyright Act 1976, allowance is made for "fair use" for purposes such as criticism, comment, news reporting, teaching, scholarship, and research. Fair use is a use permitted by copyright statute that might otherwise be infringing. Non-profit, educational or personal use tips the balance in favor of fair use. ["Music", "Theremin"] ["low quality", "experimental", "wide synth pad chords", "punchy kick", "wide echoing shimmering hi hats", "filtered echoing acid bass melody", "fade in", "crackles", "low quality", "hypnotic", "haunting", "mystical"] 4 n87PCgYm6mE 4521

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;