musiccaps_details (view)
2 rows where "youtube_published" is on date 2014-08-01
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 |
---|---|---|---|---|---|---|---|---|---|---|
Purple Reign singing "Purple Rain" in Las Vegas | The Low Quality recording features r&b/soul songs sung by passionate male vocalists over fat bass guitar, punchy kick and snare hits and arpeggiated electric guitar melody. There are also some chattering voices in the background, it sounds like it is a live performance. | 2014-08-01T07:40:21Z | andyvancephoto | Purple Reign singing Prince's song "Purple Rain" at The D Hotel Las Vegas, NV. Now, they're performing at the Westgate Hotel which was formerly called The Hilton Hotel. | ["Music", "/t/dd00003"] | ["low quality", "r&b/soul", "passionate echoing male vocal", "punchy kick", "punchy snare", "electric guitar arpeggiated melody", "fat bass guitar", "people chattering", "reverberant", "live performance"] | 4 | 0Olm321vgk8 | 160 | |
메이플스토리 BGM - 시간의신전(Temple of time) | This song contains a cymbal holding the rhythm while different piano and keyboards are playing melodies. A xylophone is playing a melody in a higher pitch on top of that. A female voice choir sample comes in every year and then being part of the rhythmic composition. This song may be playing in a adventure video-game with beautiful landscapes. | 2014-08-01T03:44:09Z | yeon H | 원하신 브금을 댓글창에 적어주시면 업로드 해드립니다. | ["Background music", "Music", "Tender music"] | ["ballad", "piano", "keyboard", "cymbal", "female voice sample", "xylophone", "medium tempo", "dreamy", "peaceful"] | 6 | BdhaR2QUGqY | 1269 |
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;