musiccaps_details (view)
1 row where musiccaps_names contains "Electronic music", musiccaps_names contains "Sampler" and "youtube_published" is on date 2013-06-11
This data as json, CSV (advanced)
Suggested facets: youtube_published (date)
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
E-MU Ultra Sampler - Demo #6 | The low quality recording features an ambient song that consists of a wide filter modulate synth pad melody going, wide mellow synth pad and short growly synth bass. At the end of the loop, there is a reverberant riser, subtly bringing the energy up. It sounds calming and relaxing. | 2013-06-11T21:30:25Z | St0neOfficialChannel | #EMU #Ultra #Sampler All presets I made on E-MU E4XT Ultra (EOS 4.70). E4XT sequenced from DAW (midi edition and midi automation). After the recording was used lightweight compression and nothing else. Please use 360p or higher for better sound quality. Instagram: https://www.instagram.com/stonestd/ Facebook: https://www.facebook.com/st0nemusic | ["Sampler", "Electronic music", "Music"] | ["low quality", "wide filter modulated synth pad melody", "wide mellow synth pad", "short growly synth bass", "reverberant riser", "ambient", "calming", "relaxing"] | 4 | p2fXNAPYD20 | 4681 |
Advanced export
JSON shape: default, array, newline-delimited
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;