musiccaps_details (view)
1 row where musiccaps_aspects contains "mellow", musiccaps_aspects contains "repeated theme", musiccaps_author = 9 and "youtube_published" is on date 2013-05-29
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 |
---|---|---|---|---|---|---|---|---|---|---|
Dr. Zwig - Everybody Love (Official Music Video) | This is an alternative rock piece. There is a male vocal singing gently and melodically at the forefront in the medium range, while a male back vocal can be heard singing at a higher pitch. A clean sounding electric guitar is playing a mellow tune with a bass guitar holding the root notes in the background. The acoustic drums are playing a basic rock beat. There is an easygoing aura to it. This piece could be used in a food/beverage commercial. It could also be playing at a sports venue. | 2013-05-29T17:02:38Z | Dr. Zwig | "Everybody Love" official music video by Dr. Zwig. Subscribe to the Dr. Zwig channel for all the best and latest podcast episodes, official music videos, behind the scenes, and live performances: https://goo.gl/tisYWU Listen to "Everybody Love": Apple Music: https://music.apple.com/us/album/everybody-love-single/1628143474 Amazon Music: https://www.amazon.com/music/player/albums/B0B39R7ZYX?marketplaceId=ATVPDKIKX0DER&musicTerritory=US&ref=dm_sh_J9Wv25Q62pN994FFXBy7Xu3i3 YouTube Music: https://music.youtube.com/playlist?list=OLAK5uy_lYW8hKpjSD5xAGHKdfN7Nu5kl9ISn2SgY Spotify: https://open.spotify.com/album/4Vf4FgwPTLBdpJQftjWXIk Deezer: https://www.deezer.com/en/album/325247577 CONNECT: http://DrZwig.com http://facebook.com/DrZwig http://twitter.com/Dr_Zwig http://instagram.com/DrZwig http://consciousrecords.com Copyright Adam Zwig 2013 Combustible Music / BMI Conscious Records LLC Album: Visions Of The Shimmering Night Directed by Garrett Gibbons | ["Music", "Tender music"] | ["alternative rock", "indie", "male vocal", "melodic singing", "electric guitar", "bass guitar", "acoustic drums", "mellow", "friendly", "easygoing", "repeated theme", "medium tempo"] | 9 | _b5n-mny1lM | 3477 |
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;