musiccaps_details (view)

1 row where musiccaps_aspects contains "low quality" and "youtube_published" is on date 2012-03-31

✎ 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
DISCO SOUNDS BY LINDA IMPERIAL "FIRE" Please find my other channel under rayochapin for more music The low quality recording features a synth wave disco instrumental that consists of punchy "4 on the floor" kick patter, reverberant snare hits, shimmering hi hats, widely spread high pitched synth lead, groovy synth bass and repetitive percussive element. It is noisy, but also energetic and groovy- like something you would hear in a disco club. 2012-03-31T06:31:51Z Rayo Chapin Hola mis amigos, primeramente gracias a las personas que se an subscribido la verdad se los agradesco muchisimo, me quiero disculpar por ausentarme mucho pero espero comprendan un poco. Y bueno aqui les dejo una rolita que a mi la verdad me fascina, aqui le quize acomodar un poco el audio pero creo que me quedo un poco recio, les recomiendo bajar un poco el volumen. Thank you very much for listening I want you to please forgive my absence as I tend to not log on for a very long time. I hope you all understand, and well here I leave a super tune which I really love I tried to fix the sound a little and I guess I did not adjust the volume properly please be advise to turn the volume down if you are one of those people with sensitive ears. Thanks again. ["Disco", "Music"] ["low quality", "synth wave disco", "muffled snare", "punchy \"4 on the floor\" kick pattern", "wide high pitched synth", "groovy synth bass", "repetitive percussive element", "shimmering hi hats", "energetic", "groovy", "noisy"] 4 laVgKAcv8XA 4410

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;