musiccaps_details (view)
1 row where musiccaps_aspects contains "noisy", musiccaps_aspects contains "sad" and musiccaps_aspects contains "sustained strings melody"
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 |
---|---|---|---|---|---|---|---|---|---|---|
Halo 3 Title theme played on Theremin - Unforgotten aka Never Forget | The low quality recording features a theremin solo melody played over playback that has a sustained strings melody playing. It sounds emotional, sad, heartfelt and the recording is noisy and in mono. | 2008-12-22T11:58:34Z | Theremin Hero | Another one of my favourite game soundtracks. This is the track that plays in the title screen called "Unforgotten" or "Never forget" - depending who you ask. No custom backing track this time.. I just played along. Played on Moog Etherwave, with slight reverb added. More game music coming soon.. If you like this, Subscribe! Check out my other videos too. In case you were wondering why the projector is flickering, its because its a DLP projector. It only appears to flicker through the camera. | ["Music", "Theremin"] | ["low quality", "noisy", "mono", "theremin solo melody", "sustained strings melody", "playback", "sad", "emotional", "heartfelt"] | 4 | P5AgEqouchI | 2504 |
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;