musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "keyboard harmony", musiccaps_aspects contains "romantic" and musiccaps_aspects contains "slow tempo"
This data as json, CSV (advanced)
musiccaps_aspects (array) 36 ✖
- keyboard harmony · 2 ✖
- romantic · 2 ✖
- slow tempo · 2 ✖
- acoustic guitar 1
- ambient 1
- dj 1
- dreamy 1
- electro pop 1
- emotional 1
- fingers snapping 1
- fog horn 1
- groovy bass 1
- groovy bass line 1
- instrumental 1
- male singer 1
- male voice speaking 1
- man talking 1
- mellow 1
- pleasant 1
- r&b 1
- reggae 1
- scratching 1
- sentimental 1
- slick drumming 1
- soft 1
- soft melodious 1
- soothing 1
- soul 1
- sound of horn 1
- super imposed male voice 1
- synthesiser arrangement 1
- synthesiser articulation 1
- turn table 1
- two tracks 1
- unrelated tracks 1
- vinyl record scratching 1
musiccaps_names (array) 4 ✖
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 | |
Missing from YouTube | A male vocalist sings this soft melody. The tempo is medium with smooth guitar, keyboard harmony, steady bass slide and synthesiser arrangements. The song is mellow, romantic, emotional, soothing; ambient. There is a hooting sound like a fog horn with a male voice talking over the song. This song is a R&B/Soul song. | ["Music", "Reggae", "Song"] | ["male singer", "slow tempo", "sound of horn", "fog horn", "super imposed male voice", "romantic", "emotional", "soothing", "pleasant", "r&b", "soul", "acoustic guitar", "keyboard harmony", "synthesiser articulation", "fingers snapping", "groovy bass line", "male voice speaking", "reggae", "soft melodious"] | 7 | 4427 |
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;