musiccaps_details (view)
2 rows where musiccaps_aspects contains "strings", musiccaps_author = 2 and musiccaps_names contains "New-age music"
This data as json, CSV (advanced)
musiccaps_aspects (array) 12 ✖
- strings · 2 ✖
- harp 1
- instrumental 1
- low pitch percussive sound 1
- no voice 1
- orchestra vibes 1
- piano 1
- quiet female voice 1
- still atmosphere 1
- synth pad 1
- taiko drums 1
- wind sound 1
musiccaps_names (array) 5 ✖
- Music 2
- New-age music · 2 ✖
- Ambient music 1
- Lullaby 1
- Theme music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Witcher 3 - 'Lullaby of Woe' | The music features a female voice quietly singing a melody. A harp is accompanying the singer. Violins can be heard fading out from the beginning of the music excerpt. In the background one can hear the wind blowing softly. Towards the ending of the music excerpt a low pitch percussive sound can be heard. | 2015-08-27T02:28:40Z | BastianRP | By Marcin Przybyłowicz. Not owned by me. Copyright CD Projekt RED. | ["New-age music", "Music", "Lullaby"] | ["quiet female voice", "harp", "strings", "wind sound", "still atmosphere", "low pitch percussive sound"] | 2 | OLy3C8YpMsY | 2429 | |
The Shatter Heists: #1 Green Harvest - Death Wish LOUD (Payday 2 Mods) midobo, b33croft & Sicarius | The music features a melody being played in unison by a piano and a group of strings. At the same time these two also fill up the music space with harmony. A type of drum that resembles the taiko drum but I think is smaller in size can be heard in the background. In the background a synth pad provides soft harmony. | 2016-03-28T15:43:43Z | M0rtifer | Payday 2 - The Green Harvest Heist is the first custom heist mod from The Shatter Heists and is presented by Last Bullet http://forums.lastbullet.net/ This time we go loud on death wish difficulty. What's different to a normal bank heist? - Sprinting dozers - Walking snipers (no laser sight) - You always have to escape - More cloakers? (not sure about that) Thanks to : midobo: https://www.youtube.com/millionendollarboy b33croft: https://www.youtube.com/b33croft Sicarius: https://www.youtube.com/channel/UCQd4KO8AFTOOJBq7RdjjfMQ for playing with me :) You can't download this mod from lastbullet anymore. Payday 2 Playlists: DW Solo loud https://www.youtube.com/playlist?list=PLZyvx5rsuR8HlP9kWCJTM25q3ve9yKBGr Stealth Murky difficulty https://www.youtube.com/playlist?list=PLZyvx5rsuR8HvNhgiYP4LK77s5i0TonGQ Death Wish loud https://www.youtube.com/playlist?list=PLZyvx5rsuR8G2pxj_Iarxize5gkvhZ2hc Achievements https://www.youtube.com/playlist?list=PLZyvx5rsuR8GMAXZYDUEkZidvxU8BckMN Payday 2 Guides https://www.youtube.com/playlist?list=PLZyvx5rsuR8HeuIEklCzWMRJ0S9rIIFSk Payday 2 Custom Heists https://www.youtube.com/playlist?list=PLZyvx5rsuR8HKYf5KswCu_7Bunb75f1KH Death Wish Solo Stealth https://www.youtube.com/playlist?list=PLZyvx5rsuR8E-NL1F7ik-PGR-AUNXhhkn DW solo stealth with 75 DR: https://www.youtube.com/playlist?list=PLZyvx5rsuR8FTyxTToPqkOmj3v2q6Am11 ░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░ Thanks for watching! My links: ● Subscribe: https://www.youtube.com/M0rtifer?sub_confirmation=1 ● Facebook: https://www.facebook.com/M0rtifer ● Twitter: https://twitter.com/_m0rtifer_ ● Steam Group: http://steamcommunity.com/groups/M0rtisHQ ● Join Curse: https://www.unionforgamers.com/apply?referral=zt4m7p3n68o1fl ░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░ Production Music courtesy of Epidemic Sound: http://www.epidemicsound.com ░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░ | ["Theme music", "New-age music", "Music", "Ambient music"] | ["taiko drums", "piano", "strings", "synth pad", "instrumental", "no voice", "orchestra vibes"] | 2 | gFxLnprPgv4 | 4020 |
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;