musiccaps_details (view)

2 rows where musiccaps_aspects contains "energetic", musiccaps_aspects contains "people dancing" and musiccaps_aspects contains "strong bass line"

✎ View and edit SQL

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
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
DJ Shortee - "Watch Out Now" Beatjuggle Routine 2003 A DJ plays a cool groove with some female vocals. The song is medium tempo with a steady drumming rhythm, scratch disc percussions, and percussive bass line. The song is exciting and groovy. The audio quality is average. 2006-08-07T01:33:25Z DJ Shortee Turntablist beat juggle routine performed by Shortee in 2003 with the Beatnuts' song "Watch Out Now". Featured on "Shortee's DJ 202" Instructional DVD available on www.how2dj.com. Learn more about shortee at www.djshortee.com! ["Scratching (performance technique)", "Music", "Speech", "Hip hop music"] ["dj", "female singer", "repeated vocal phrases", "techno dance music", "average audio quality", "groovy music", "dj turntable", "spinning discs", "scratching disc", "energetic", "groovy rhythm", "strong bass line", "steady rhythm", "medium tempo", "people dancing", "retro electronica", "electronic dance music", "dance floor"] 1 J0t4VMnXDNM 1960

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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;