musiccaps_details (view)
3 rows where musiccaps_aspects contains "heartfelt", musiccaps_aspects contains "noisy" and musiccaps_aspects contains "sad"
This data as json, CSV (advanced)
musiccaps_aspects (array) 14 ✖
- emotional 3
- heartfelt · 3 ✖
- low quality 3
- noisy · 3 ✖
- sad · 3 ✖
- arpeggiated acoustic guitar melody 1
- car passing by 1
- hollow piano melody 1
- mono 1
- passionate female vocal 1
- playback 1
- sustained strings melody 1
- theremin solo melody 1
- thin 1
musiccaps_names (array) 8 ✖
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 | |
Stairway to Heaven - [Led Zeppelin] | The low quality recording features an arpeggiated acoustic guitar melody and some cars passing by sounds in the background. It sounds heartfelt, emotional and sad. The recording is noisy. | 2006-12-01T13:01:34Z | Ted Kim | I think best of Led Zeppelin | ["Guitar", "Acoustic guitar", "Music", "Musical instrument", "Ukulele", "Plucked string instrument"] | ["low quality", "car passing by", "arpeggiated acoustic guitar melody", "emotional", "sad", "heartfelt", "noisy"] | 4 | j-TVVmVmygg | 4227 | |
Before They Fade Away - Rebecca Pham (Official Music Video) | The low quality recording features a passionate female vocalist singing over a hollow piano melody. It sounds thin and noisy, and you can really hear the unprofessional recording technique, especially in vocals. | 2012-10-08T03:59:25Z | randomjlt | FREE MP3: http://wfurl.com/f97fd81 I had the honour of working with the talented Rebecca Pham on her first music video (and mine too). Follow me on Twitter: www.twitter.com/randomjlt Written and Performed by Rebecca Pham Directed/filmed/edited by Jay Turchansky With thanks to Harley Kennett and Drew Zielsdorf for their acting help, and to Alvin Yu for his cameo appearance. Mixed by Elisha Pham ===================== Lyrics Do the see the pain in her eyes? Or that she's been down this road so many times? And all she needs is somebody to believe in her But we just pass her by How can we say That we don't know about her pain? Turn your eyes right here Lend that listening ear Before she fades away Do you see the burden he bares? That for him, there is nobody there And all he needs is somebody's one good deed But we act as if we don't even care How can we say That we don't know about his pain? Turn your eyes right here Lend that listening ear Before he fades away How can we say That we don't know of all their pain? Turn your eyes right here Lend that listening ear Before they fade away Turn your eyes right here And lend that listening ear Before they fade away So that we can be their change | ["Music", "Sad music"] | ["low quality", "noisy", "hollow piano melody", "emotional", "sad", "heartfelt", "passionate female vocal", "thin"] | 4 | jjg0TCq3wbY | 4279 |
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;