musiccaps_details (view)
3 rows where musiccaps_aspects contains "energetic", musiccaps_aspects contains "poor audio quality" and musiccaps_aspects contains "various percussion hits"
This data as json, CSV (advanced)
musiccaps_aspects (array) 47 ✖
- energetic · 3 ✖
- poor audio quality · 3 ✖
- various percussion hits · 3 ✖
- dj 2
- instrumental music 2
- keyboard harmony 2
- medium tempo 2
- trance music 2
- booming bass line 1
- cheerleaders 1
- club mix 1
- college band 1
- dance floor 1
- dance rhythm 1
- dance-off 1
- drum sticks 1
- drums 1
- electronic dance music 1
- enthusiastic 1
- exciting 1
- groovy dance music 1
- groovy music 1
- groovy rhythm 1
- grunge keyboard tones 1
- high on adrenaline 1
- home music studio 1
- house mix 1
- marching band 1
- medium fast tempo 1
- party all night 1
- party mix 1
- passionate 1
- people dancing 1
- ping pong shot tones 1
- retro techno music 1
- samba 1
- snares 1
- spirited 1
- steady drum rhythm 1
- strong bass line 1
- sweeping keyboard harmony 1
- techno dance music 1
- techno dance rhythm 1
- techno drumming 1
- underground music scene 1
- various percussion instruments 1
- youthful 1
musiccaps_names (array) 10 ✖
- Music 3
- Dance music 1
- Didgeridoo 1
- Disco 1
- Drum and bass 1
- Dubstep 1
- Electronic dance music 1
- House music 1
- Roll 1
- Techno 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Drumline Final Battle By Hicham (High Sound Quality) | The song is an instrumental. The song is medium tempo with various marching band drums playing in sync. The song is highly energetic and spirited. The song is bad in audio quality. The song is a college marching band playing enthusiastically. | 2009-04-12T21:32:52Z | oferighe | Drumline Soundtrack | ["Music", "Roll"] | ["poor audio quality", "medium tempo", "instrumental music", "groovy rhythm", "various percussion instruments", "steady drum rhythm", "various percussion hits", "snares", "drums", "drum sticks", "dance rhythm", "samba", "cheerleaders", "college band", "marching band", "enthusiastic", "passionate", "energetic", "high on adrenaline"] | 1 | 0pewITE1550 | 211 | |
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 | |
Polycarpus - Ping Pong | The song is an instrumental. The tempo is medium with a booming bass line, grooving drum rhythm, sweeping keyboard harmony, sonic sound effects, and pin pong ball sound effects. The song has trance vibes and is very groovy. The song has poor audio quality. | 2009-12-20T21:38:12Z | Harder_Stylezz89 | Polycarpus - Ping Pong | ["Disco", "Drum and bass", "House music", "Music", "Techno", "Dubstep", "Electronic dance music", "Dance music"] | ["techno dance rhythm", "keyboard harmony", "poor audio quality", "trance music", "dj", "house mix", "party mix", "medium tempo", "instrumental music", "ping pong shot tones", "booming bass line", "various percussion hits", "groovy dance music", "exciting", "youthful", "energetic", "spirited", "party all night", "underground music scene", "sweeping keyboard harmony"] | 1 | hgGCfJoYDUU | 4124 |
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;