musiccaps_details (view)
1 row where musiccaps_aspects contains "amateur recording", musiccaps_author = 6 and "youtube_published" is on date 2012-10-05
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 |
---|---|---|---|---|---|---|---|---|---|---|
Bleep ' by Tone Bytes | This song contains a bit-rate lofi melody in a poor audio-quality. This song may be playing in an old 2d video-game. | 2012-10-05T14:54:38Z | UPROAR 24 | Bleep ' by Tone Bytes Bleep' — is a free VSTi synthesizer plug-in for Windows which inspired by the sound of MOS Technology SID. At the same time Bleep' is not emulator of this chipset but only partially similar to its architecture. for more information visit. http://tonebytes.com http://tonebytes.com/bleep/ http://tonebytes.com/freebies/ http://tonebytes.com/contact/ , https://archive.org/web/web.php if websites and downloads are not working try adding the weblink to this website https://archive.org/web/web.php The internet archive, Way back machine. Explore more than 704 billion web pages saved over time https://archive.org/web/web.php | ["Beep, bleep", "Music"] | ["digital lofi-melody", "amateur recording"] | 6 | TX9PGFdqRak | 2843 |
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;