musiccaps_details (view)
2 rows where musiccaps_aspects contains "emotional" and "youtube_published" is on date 2011-12-13
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 |
---|---|---|---|---|---|---|---|---|---|---|
Tom Dugan's Backyard bmx fun | The song is an instrumental. The song is medium tempo with a moog bass accompaniment, keyboard organ tone and a strong bass line. The song is emotional and poignant. The song is a new age pop soundtrack. | 2011-12-13T22:50:28Z | MrBMXBEAST666 | Uploaded by brycejrich on Aug 16, 2011 A session of the half built backyard at the 316 House, Austin, Texas. Tom Dugan, Cody Nutter, Joeseph Franz, Levi Brewer, Jared Allen Swafford, Danny Hickerson, Will, Mike McFrench Molineri, Jay, Cassie Nutter, Daria Nutter (the Puppy Dog) and friend. | ["Music", "Harmonic"] | ["moog bass", "keyboard accompaniment", "experimental", "experimental", "abstract", "art music", "documentary soundtrack", "instrumental music", "memdium tempo", "organ accompaniment", "strong bass line", "emotional", "melancholic", "poignant", "playful", "inspirational", "motivational", "new age", "song introduction"] | 1 | BWSJjF32tQA | 1249 | |
Solitude - The Elder Scrolls V: Skyrim Original Game Soundtrack | The Classical song features a wide mellow strings melody and soft plucked strings melody. It sounds mellow, soft, emotional and epic, like a background movie soundtrack. | 2011-12-13T02:13:15Z | allaboutSkyrimmusic | The Music of The Elder Scrolls V: Skyrim Composer: Jeremy Soule Disc 3 - Track #11 Buy it! (only avaliable in CD) http://www.directsong.com/mobile/productdetails.php?productid=2240 All The Elder Scrolls V: Skyrim material belongs to Bethesda. No copyright infringements are intended. | ["Theme music", "New-age music", "Music"] | ["classical", "wide mellow strings melody", "soft plucked strings melody", "mellow", "soft", "emotional", "epic", "movies"] | 4 | WmyHFkyiiF8 | 3134 |
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;