musiccaps_details (view)
2 rows where musiccaps_aspects contains "instrumental", musiccaps_aspects contains "pop song", musiccaps_aspects contains "relaxing song" and musiccaps_names contains "Music"
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 |
---|---|---|---|---|---|---|---|---|---|---|
Hlub Teev Kua Muag Fan MV | This instrumental slow rock song features a guitar playing arpeggiated chords. This is accompanied by a piano playing passing chords. The percussion consists of only the ride cymbal being struck in a set of two strokes followed by a set of four strokes. This pattern continues throughout the song. The bass plays the root notes and filler notes at the start of each bar. There are no voices in this song. This song can be played in a coffee shop. | 2009-04-12T01:49:39Z | leemyis | Fan MV of Wu Chun & Aff Taksaorn... Song: Koj nyob rawv hauv siab by Nkauj Hli Vwj | ["Music", "Happy music"] | ["slow rock song", "pop song", "guitar", "piano", "ride cymbal", "bass", "no voices", "instrumental", "moderate tempo", "relaxing song"] | 0 | TFLt7mn57ZI | 2824 | |
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;