musiccaps_details (view)
3 rows where musiccaps_aspects contains "energetic" and musiccaps_aspects contains "grunge keyboard tones"
This data as json, CSV (advanced)
musiccaps_aspects (array) 44 ✖
- energetic · 3 ✖
- grunge keyboard tones · 3 ✖
- people dancing 3
- dance floor 2
- dj 2
- electronic dance music 2
- poor audio quality 2
- adrenaline rush 1
- average audio quality 1
- beeping tones 1
- club mix 1
- dance club 1
- dance groove 1
- dance rhythm 1
- dance-off 1
- excitement 1
- fast tempo 1
- fats tempo 1
- groovy bass line 1
- groovy music 1
- groovy rhythm 1
- home music studio 1
- instrumental music 1
- keyboard harmony 1
- male rapper 1
- medium fast tempo 1
- medium tempo 1
- passionate 1
- percussive bass line 1
- rap hits 1
- retro rap hits 1
- retro techno music 1
- spirited 1
- story telling 1
- strong bass line 1
- strong drumming rhythm 1
- synth trumpet lead 1
- tambourine percussions 1
- techno dance music 1
- techno dance rhythm 1
- techno drumming 1
- trance music 1
- various percussion hits 1
- youthful 1
musiccaps_names (array) 7 ✖
- Music 3
- Cacophony 1
- Didgeridoo 1
- Dubstep 1
- Electronic dance music 1
- Rapping 1
- Techno 1
youtube_published (date) 3 ✖
- 2008-03-06 1
- 2010-09-04 1
- 2013-12-01 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Azzido Da Bass - Music For Bagpipes (TRASHLINE Remix) [HD] | The song is an instrumental. The song is medium tempo with a groovy bass line, grunge keyboard tones, synth trumpet lead and techno drumming rhythm. The song is entertaining and energetic. The song is an electronic dance song with average quality recording. | 2010-09-04T16:45:36Z | PapayaOficiallRP | Azzido Da Bass - Music For Bagpipes (TRASHLINE Remix) Watch in HD! Suscribe! ;) MSN: PAPAiiA-JEtAiiME@hotmail.fr By: PapayaOficiallRP | ["Music", "Techno", "Dubstep", "Cacophony", "Electronic dance music"] | ["average audio quality", "groovy rhythm", "electronic dance music", "instrumental music", "groovy bass line", "medium tempo", "synth trumpet lead", "people dancing", "dj", "techno dance rhythm", "dance club", "dance floor", "spirited", "energetic", "youthful", "grunge keyboard tones"] | 1 | 4Mm5mBgktG0 | 562 | |
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 | |
Kai - Grind Low | A male rapper sings this exciting melody. The tempo is fast with a groovy bass line, grunge keyboard tones, strong drumming rhythm, various percussion hits and beeping tones. The song is pulsating and energetic. The audio quality is very poor. | 2008-03-06T13:46:34Z | kilickai | ["Music", "Rapping"] | ["male rapper", "poor audio quality", "beeping tones", "fast tempo", "people dancing", "retro rap hits", "tambourine percussions", "strong drumming rhythm", "percussive bass line", "story telling", "adrenaline rush", "passionate", "energetic", "excitement", "dance rhythm", "dance groove", "fats tempo", "poor audio quality", "rap hits", "grunge keyboard tones"] | 1 | 9STauy5DsC8 | 1009 |
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;