musiccaps_details (view)
4 rows where musiccaps_aspects contains "energetic", musiccaps_aspects contains "keyboard harmony" and musiccaps_aspects contains "medium fast tempo"
This data as json, CSV (advanced)
musiccaps_aspects (array) 65 ✖
- energetic · 4 ✖
- keyboard harmony · 4 ✖
- medium fast tempo · 4 ✖
- electronic dance music 2
- poor audio quality 2
- trance music 2
- youthful 2
- adrenaline fix 1
- amplified instruments 1
- animated electric guitar harmony 1
- building anticipation 1
- club mix 1
- concert 1
- dance floor 1
- dance mix 1
- dance-off 1
- death metal music 1
- dj 1
- eerie 1
- electric guitar lead 1
- enthusiastic 1
- excited vocals 1
- fast drumming rhythm 1
- fast metal drumming 1
- game soundtrack 1
- gig 1
- groovy bass line 1
- groovy bass lines 1
- groovy dance hits 1
- groovy music 1
- grunge keyboard tones 1
- hard rock 1
- heavy metal 1
- home music studio 1
- infectious drumming 1
- inspiring 1
- instrumental music 1
- live performance 1
- male singer 1
- male vocalist 1
- metal 1
- passionate 1
- people dancing 1
- punchy drumming 1
- retro 1
- retro rock 1
- retro techno music 1
- rock 1
- scary 1
- sonic power 1
- spirited 1
- spring break dance party 1
- story telling 1
- strong bass hits 1
- strong bass line 1
- synthetic vocal harmony 1
- techno dance music 1
- techno drumming 1
- trance dance hits 1
- trance party 1
- trance super hits 1
- underground dance party 1
- various percussion hits 1
- video game soundtrack 1
- xtra bass 1
musiccaps_names (array) 13 ✖
- Music 4
- Angry music 1
- Burst, pop 1
- Dance music 1
- Didgeridoo 1
- Drum and bass 1
- Dubstep 1
- Electronic dance music 1
- House music 1
- Psychedelic rock 1
- Punk rock 1
- Rock music 1
- Speech 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
App Manager 3 / Apps to SD Review | The song is an instrumental. The tempo is medium fast with a strong techno drumming groove, strong bass line, keyboard harmony and various percussion hits. The song is energetic and passionate. The audio quality is poor. | 2013-12-01T06:21:53Z | RootJunky | App Manager 3 / Apps to SD review Link to Google Play App Manger 3 https://play.google.com/store/apps/details?id=com.a0soft.gphone.app2sd&hl=en Check out PhonLab E-Campus, if you want to learn tons more about Phone repairs tips and tricks to help you repair smartphones. https://phonlabtech.com/mobile-repair-tech/ How to install Android Device drivers http://youtu.be/j_KPGUMzrjU Why Root Android devices video http://youtu.be/6vqnnLnOn3g Android device hacking explained http://youtu.be/UUTwYHfmHv4 Universal UnRoot App for all Devices http://youtu.be/ySNStU8OTuk FOLLOW ME http://RootJunky.com www.facebook.com/rootjunky https://twitter.com/Tomsgt2 youtube.com/tomsgt123 google.com/+Tomsgt123 PLEASE READ Warning... do this at your own risk. I am happy to help with any problems my subscribers are having on their android devices. I am going to need lots of info from you to help. 1. What device you are on. 2. What android version you are running. 3. What custom rom or stock rom / build number you are on. 4. What you have done to the device. 5. What recovery system you are using. With this info I will be able to help much faster. | ["Didgeridoo", "Music"] | ["techno dance music", "grunge keyboard tones", "poor audio quality", "dance-off", "energetic", "trance music", "club mix", "dj", "dance floor", "people dancing", "retro techno music", "groovy music", "electronic dance music", "various percussion hits", "keyboard harmony", "home music studio", "strong bass line", "medium fast tempo", "techno drumming"] | 1 | 769EHEG4Mqc | 811 | |
ArcheAge - Archer 50 lvl pvp, DollVasta (19.04.14) | A male singer sings these whispering vocals. The song is medium fast tempo with a fast metal drumming rhythm, percussive bass line, keyboard accompaniment and various percussion hits. The song is tense and full of suspense. The song is a game soundtrack. | 2014-04-19T14:38:05Z | b1shock | DollVasta(BIOSHOCK,BIOPWNZ) | ["Music", "Speech", "Angry music"] | ["death metal music", "male singer", "game soundtrack", "building anticipation", "fast drumming rhythm", "medium fast tempo", "video game soundtrack", "passionate", "energetic", "scary", "eerie", "fast metal drumming", "groovy bass line", "story telling", "inspiring", "keyboard harmony"] | 1 | LLDHkHHKYkI | 2179 | |
Cold Metal - Iggy Pop.mp4 | A male vocalist sings this energetic Rock song. The tempo is medium fast with an animated electric guitar harmony and lead, groovy bass lines,infectious drumming and keyboard harmony. The song is electric,pulsating, youthful, energetic, enthusiastic, passionate and powerful with emphatic vocals. This song is Heavy Metal. | 2010-01-13T20:14:33Z | wotsitooyou | Iggy Pop live does Cold Metal | ["Music", "Punk rock", "Psychedelic rock", "Rock music", "Burst, pop"] | ["male vocalist", "medium fast tempo", "live performance", "gig", "concert", "retro", "retro rock", "keyboard harmony", "infectious drumming", "animated electric guitar harmony", "groovy bass lines", "punchy drumming", "electric guitar lead", "retro", "rock", "heavy metal", "hard rock", "metal", "sonic power", "amplified instruments", "excited vocals", "youthful", "spirited", "enthusiastic", "energetic"] | 7 | NxdQtpceXaI | 2381 | |
★BEST★FESTIVAL DANCE MUSIC MADNESS★2015★[EP.25]★ | The song is an instrumental. The tempo is medium fast tempo with deep bass hits, synth voice harmony, keyboard harmony, and strong drumming rhythm. The song is deep trance and very groovy. The song has poor audio quality. | 2015-05-01T02:01:31Z | Derano Faraz | •••• •••• •••• READ •••• DISCRIPTION •••• •••• •••• Iam finally back with a brand new video made with Nevel201! Check out his channel and social pages below. And make sure to share the video if you enjoyed it! Video by: Derano Faraz Audio by: Nevel201 ••••Nevel201•••• Youtube Channel:https://www.youtube.com/channel/UChkoolrQrza5tdb_nhPqGAA SoundCloud: https://soundcloud.com/nevel201 Twitter: https://twitter.com/Nevel201 Facebook: https://www.facebook.com/Nevel201 ••••LIKE MY FACEBOOKPAGE•••• https://www.facebook.com/pages/OFFICIAL-Derano-Faraz/1418808438345254?pnref=lhc ••••SOUNDCLOUD•••• https://soundcloud.com/derano-faraz •••• TRACKLIST•••• 0:00 Intro: Acer - Final Battle https://soundcloud.com/acer-official/... 1. 0:52 Dimitri Vegas & Like Mike x Diplo & Gho$t - Destruction https://soundcloud.com/dvlmunreleased... 2. 1:11 MegaTweaker - Virtuoso [Channel Exclusive - UNRELEASED] 3. 1:27 S1ngular - Supernature https://soundcloud.com/s1ngularmusic/... 4. 1:42 Vaxxe - Predator https://soundcloud.com/fr-se-records/... 5. 1:57 Spengla & Keku x V3tore - I'm In Love With Burritos [Channel Exclusive - UNRELEASED] 6. 2:12 Scorgeous - Imma Jungle [Channel Exclusive - UNRELEASED] 7. 2:27 SAG & Jayden Jaxx - Cold Blooded (MAXXD Harder Edit) https://soundcloud.com/maxxdofficial/... 8. 2:41 Envor - ID [Channel Exclusive - UNRELEASED] 9. 2:46 ID - ID [Channel Exclusive - UNRELEASED] 10. 3:03 Arsonnic - Ryujin https://soundcloud.com/arsonnic/ryuji... 11. 3:18 Tedd & Kroshwell - ID [Channel Exclusive - UNRELEASED] 12. 3:33 Deckstroyers x Kants & Lopers - Evasion https://soundcloud.com/ensisrecords/d... 13. 3:48 Scorgeous - Shakalaka [Channel Exclusive - UNRELEASED] 14. 4:04 Otero - Riffter https://soundcloud.com/oteromusic/ote... 15. 4:18 TravisTricker - In The Air [Channel Exclusive - UNRELEASED] 16. 4:34 Futuristic Brothers & CroudeN - Dark Side (Matt Out Remix) https://soundcloud.com/mattoutofficia... 17. 4:49 AudioKiller - Welcome To The Arabic Shit [Channel Exclusive - UNRELEASED] 18. 5:04 Disch… | ["Drum and bass", "House music", "Music", "Dubstep", "Electronic dance music", "Dance music"] | ["dance mix", "trance music", "medium fast tempo", "trance super hits", "spring break dance party", "poor audio quality", "underground dance party", "electronic dance music", "strong bass hits", "xtra bass", "groovy dance hits", "trance party", "trance dance hits", "youthful", "energetic", "adrenaline fix", "instrumental music", "keyboard harmony", "synthetic vocal harmony"] | 1 | k-LkhT4HAiE | 4293 |
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;