musiccaps_details (view)
1 row where musiccaps_aspects contains "fantasy music", musiccaps_aspects contains "pop song" and musiccaps_aspects contains "slow tempo"
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 |
---|---|---|---|---|---|---|---|---|---|---|
The Space We Live In - FULL HD Video | This song has a relaxing feel. It starts off with a synth playing a chord sequence. This is followed by synth strings playing a high pitched melody. The notes fade into each other. Another synth plays the bass notes in the background. There is no percussion in this song. The mood of this song is dreamy. This song can be played in a dream sequence in a movie. | 2012-04-05T09:20:06Z | MatthiasM.de | my Video Shop: https://matthiasm.de/shop Like on Facebook: https://www.facebook.com/MatthiasM.de +1: http://goo.gl/ZUHpb Tools: 3ds max - Krakatoa + Frost - particle flow + box#3 - FumeFX - BerconMaps, FREE plugin: (http://ylilammi.com/BerconMaps.shtml) - BetterWind, FREE plugin: (http://rpmanager.com/plugins/BetterWind.htm) a little insight, some flows, setups and procedural maps of the last scene: http://matthiasm.de/images/last_scene_tswli.jpg Music: Rameses B - Memoirs (Cinematic Version) http://youtube.com/RamesesB | ["New-age music", "Music"] | ["pop song", "relaxing song", "synth sounds", "no percussion", "meditation music", "no voices", "instrumental", "dreamy music", "fantasy music", "slow tempo"] | 0 | a-11dtG7aK4 | 3509 |
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;