musiccaps_details (view)
3 rows where musiccaps_aspects contains "noisy" and "youtube_published" is on date 2012-10-08
This data as json, CSV (advanced)
musiccaps_aspects (array) 15 ✖
- low quality 3
- noisy · 3 ✖
- emotional 1
- flat male vocal 1
- heartfelt 1
- hollow piano melody 1
- mono 1
- passionate female vocal 1
- punchy electro kick 1
- sad 1
- simple strings melody 1
- synth hi hat 1
- thin 1
- tutorial 1
- wide 1
musiccaps_names (array) 10 ✖
- Bass drum 1
- Drum 1
- Harpsichord 1
- Keyboard (musical) 1
- Music 1
- Percussion 1
- Rimshot 1
- Sad music 1
- Snare drum 1
- Wood block 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
卡農 | The Low Quality Recording features a widely spread simple strings melody. The recording is a bit noisy. | 2012-10-08T16:16:48Z | 芒果黃金 | ["Harpsichord", "Keyboard (musical)"] | ["low quality", "simple strings melody", "noisy", "wide"] | 4 | gwBfZJ5IGOA | 4067 | ||
Y8 Smoke on the Water Drum Tutorial | The low quality recording features a tutorial where a flat male vocalist is talking in-between punchy electro kick and synth hi hat. The recording is noisy and in mono. | 2012-10-08T11:44:50Z | CranfordCCMusic | ["Wood block", "Drum", "Rimshot", "Snare drum", "Bass drum", "Percussion"] | ["low quality", "noisy", "mono", "punchy electro kick", "synth hi hat", "flat male vocal", "tutorial"] | 4 | jaJdPUAv6N0 | 4263 | ||
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;