musiccaps_details (view)
3 rows where musiccaps_aspects contains "intense", musiccaps_aspects contains "violin", musiccaps_author = 7 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 |
---|---|---|---|---|---|---|---|---|---|---|
Minecraft - Donut the Dog Adventures - CAR CRASH......IS DONNY DEAD????? | This music is an electronic instrumental. The tempo is fast with atmospheric synthesiser, intense drumming and ambient sounds of a helicopter, ambulance siren and wind. The music sounds sinister, grim, dangerous, urgent, panicky, catastrophic , exigent , acute, compelling and emergent. This is electronic music. | 2015-12-17T21:00:00Z | Donut | Minecraft - Donut the Dog Adventures - CAR CRASH......IS DONNY DEAD????? ♥Little Donny: https://www.youtube.com/channel/UChYXRnvA0kVm34-Y6uwLOHg ♥ Donut the dog Instagram: https://instagram.com/donutthedogyt/ | ["Music", "Helicopter"] | ["instrumental", "fast tempo", "intense", "emergency", "pressing", "dire", "video game music", "animated", "crisis", "exigency", "danger", "panic situation", "sinister", "helicopter sound", "violin", "intesnse drumming", "digital drumming", "synthesiser arrangement", "surround sound", "urgency"] | 7 | SGFYFPs3Fic | 2754 | |
Two Steps From Hell - Mountains From Water (Archangel) | This music is an intense instrumental.The tempo is fast with vigorous violin harmony that slows down to the accompaniment of a grim Piano harmony. The music is a Ritardando and has a grim, dark, intense,serious,bleak, dreary, and dangerous vibe to it. | 2011-10-08T10:51:01Z | Two Steps From Hell | Buy this album on iTunes: http://tiny.cc/TSFH-Archangel Amazon: http://tiny.cc/TSFH-Archangel1 Spotify: https://open.spotify.com/album/1TVpHhBK3pSTqizgLLh16s Follow Two Steps From Hell on Facebook: http://fbl.me/TSFH Follow Nick Phoenix on Facebook: http://fbl.me/NickPhoenix Composed by Nick Phoenix. You can buy more of our music here: iTunes: http://tiny.cc/TSFH Amazon: http://tiny.cc/TSFH1 CDBaby: http://tinyurl.com/n2b6jrz TSFH Official Websites: www.twostepsfromhell.com www.thomasbergersen.com | ["Music", "Scary music"] | ["instrumental", "fast tempo", "intense", "grim", "dark", "viola", "cello", "violin", "bow string instrument", "dark", "dismal", "bleak", "gloomy", "intense", "dreary", "dangerous", "ritardando", "violin harmony", "piano accompaniment", "sythesiser arrangements"] | 7 | Z_0Ta-m_-hU | 3392 | |
Take Google Maps inside IKEA | This song is a spirited instrumental. The tempo is fast with enthusiastic brass harmony , with trumpet flourish, trombone and violins, cello and viola playing an upbeat melody along with vigorous drumming, piano accompaniment and cheerful, animated choral backup. The song is animated, vibrant, energetic and full of life. The sound of the hooves of horses and whistling indicates that this is Country music. | 2011-11-28T22:34:37Z | More info: http://maps.google.com/starthere Find your way around IKEA using Google Maps on your Android phone. The Google Maps indoor display details the store's layout, from one floor to the next. Figure out how to get from home furnishings to Swedish meatballs, right from the palm of your hand. To learn more, Start here. http://maps.google.com/starthere | ["Swing music", "Music"] | ["instrumental", "fast tempo", "brass band", "trombone", "brass band", "symphony", "country movie", "trumpet flourish", "choral harmonybright trumpet harmony", "orchestral music", "orchestra", "enthusiastic drumming", "sound of galloping horse", "cowboy", "violin symphony", "piano accompaniment", "whistling", "cello", "viola", "vibrant", "intense", "triumphant music", "violin", "engaging", "captivating", "spirited"] | 7 | kT0KMsfD4d8 | 4319 |
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;