musiccaps_details (view)
1 row where musiccaps_aspects contains "electro pop", musiccaps_aspects contains "mellow", musiccaps_aspects contains "sentimental" and musiccaps_author = 7
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 |
---|---|---|---|---|---|---|---|---|---|---|
Classic Game Room - Wii WHEEL review | This music is two separate tracks. The first track is electronic music with turn table scratching. The second track is a soft, romantic, mellow, harmonious melody with keyboard harmony, electric guitar, groovy bass and steady drumming with a man talking at the end. The two tracks are unrelated. | 2009-02-13T17:05:55Z | CGR Publishing | ULTRA MASSIVE VIDEO GAME CONSOLE GUIDE VOLUME 1: https://www.amazon.com/Ultra-Massive-Video-Console-Guide/dp/1521937176 How To Make A Video Game Review Show That Doesn't Suck! https://www.amazon.com/dp/1520951884 HEYZOOS #2!! https://www.amazon.com/Heyzoos-Coked-Up-Chicken-2-Special/dp/1521438714 Lord Karnage 1.5: https://www.amazon.com/Lord-Karnage-Special-Mark-Bussler/dp/152131750X Retromegatrex Volume 1: https://www.amazon.com/Retromegatrex-Lost-Mark-Bussler-1995-2017/dp/1521316368 Follow Mark on Amazon at http://www.amazon.com/author/MarkBussler Back CGR on Patreon at http://www.Patreon.com/ClassicGameRoom CGR shirts, mugs & gear at http://www.ClassicGameRoom.com Follow CGR at: http://www.twitter.com/ClassicGameRoom http://www.facebook.com/ClassicGameRoom http://www.instagram.com/ClassicGameRoom Watch in High Definition. Classic Game Room HD reviews the Nintendo Wii WHEEL for games like Mario Kart! Insert the Wiimote or Wii Controller (as it's called) into the Wii Wheel and steer just like a real steering wheel, except without it being attached to anything. The wii wheel comes with versions of the MarioKart game and does not require any additional batteries or accessories, all you do is simple place the Wii Controller into it, get it?? GET IT!??? How much more simple can you get? You could steer with the Wii controller but you won't because I said so. Use the Wii Wheel instead because it's Wii-tastic! Classic Game Room HD reviews Nintendo Wiii, SNES, N64 and NES hardware, controllers and accessories. To find a list of games compatible with Wii Wheel search online, but we've used it for Mario Kart Wii and NASCAR Kart Racing with great success. What games work with Wii wheel? What games work is a subjective question, what works for some may cause extreme discomfort and itching for others. Do not use Wii Wheel while taking other medication. Serious liver damage may occur. We made that up, ignore that. Your liver will probably be just fine. | ["Scratching (performance technique)"] | ["instrumental", "slow tempo", "two tracks", "soft", "mellow", "romantic", "sentimental", "ambient", "dreamy", "romantic", "electro pop", "dj", "vinyl record scratching", "unrelated tracks", "turn table", "scratching", "keyboard harmony", "groovy bass", "synthesiser arrangement", "slick drumming", "man talking"] | 7 | 1GCOnj53QYM | 252 |
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;