musiccaps_details (view)
1 row where musiccaps_aspects contains "electro", musiccaps_aspects contains "reverberant snappy rimshot", musiccaps_names contains "Electronica" 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 |
---|---|---|---|---|---|---|---|---|---|---|
Haunting My Dreams | Five Nights at Freddy's 4 Song | Groundbreaking | The Electro song features a punchy "4 on the floor" kick pattern, shimmering open hats, tinny wide minimal percussions, low groovy bass, simple electric guitar melody and reverberant snappy rimshots. It sounds dark, energetic, suspenseful and exciting. | 2015-08-09T19:52:18Z | Groundbreaking | Groundbreaking presents his new original song dedicated to Five Night's at Freddy's 4. ► More FNAF Songs | http://bit.ly/21kZAqb ★ Now on Spotify: https://open.spotify.com/album/7jdPFgXuKTjnI3zSzNS7Wg?si=5nc0EqmaTSKweblgfwJNIw ★ 100K Special: ➝ Part I: https://www.youtube.com/watch?v=pDYTKC4Qe-8 ➝ Part II: https://www.youtube.com/watch?v=YM6CjjQIid4 ★ Support the complete FNAF album 'Nightmares': https://groundbreaking.bandcamp.com/album/nightmares ♫ Get this track: https://groundbreaking.bandcamp.com/track/haunting-my-dreams-groundbreaking ☁ Stream this track on Soundcloud: https://soundcloud.com/groundbreakingofficial/haunting-my-dreams-groundbreaking?in=igroundbreaking/sets/groundbreaking-nightmares ♬ Instrumental: https://www.youtube.com/watch?v=lE7_8aCDua0&list=PLijLwT0bG0BZVWUeGEKlKS6kM252hFla6&index=8 ★ Custom Nightmare Bonnie Artwork: http://theredcat13.deviantart.com Follow Groundbreaking: http://instagram.com/groundbreakingofficial http://facebook.com/groundbreakingofficial http://twitter.com/igroundbreaking https://discord.gg/qCTD9vu Thank you for being a part of this awesome day. I will see you all soon with the first single from my new album "We Are Monsters" :D #fnaf #fivenightsatfreddys #hauntingmydreams #music | ["Electronic music", "Music", "Electronica"] | ["electro", "punchy \"4 on the floor\" kick pattern", "shimmering open hats", "tinny wide minimal percussions", "low groovy bass", "simple electric guitar melody", "reverberant snappy rimshot", "dark", "energetic", "suspenseful", "exciting"] | 4 | hCIB1E60Nbw | 4085 |
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;