musiccaps_details (view)
4 rows where musiccaps_aspects contains "dj", musiccaps_aspects contains "people dancing" and musiccaps_aspects contains "poor audio quality"
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 |
---|---|---|---|---|---|---|---|---|---|---|
Freestyle scratch | The song is an instrumental. The song is medium tempo with a groovy drum rhythm, vinyl disc scratching tones and a percussive bass line. The song is energetic and groovy. The audio quality is very poor with a lot of hissing noise. | 2007-10-28T20:37:08Z | DjSplen | Freestyle sur instru /le Jad breakbeat... | ["Scratching (performance technique)", "Music", "Scratch", "Drum machine"] | ["dj", "practice session", "vinyl disc", "youtube music video", "disc scratching tones", "home music video", "freestyle disc scratching", "groovy", "dance rhythm", "poor audio quality", "ambient room noises", "instrumental music", "people dancing", "techno dance rhythm", "hissing tones", "medium tempo"] | 1 | 2uvHgwAljPA | 414 | |
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 | |
RDV TOUS LES VENDREDI @ LOVE BOAT / TOULOUSE (hiphop & dancehall) | A male singer introduces the DJ lineup with an enthusiastic song. The tempo is medium with a groovy bass line, steady drumming rhythm, keyboard harmony and other percussion hits. The song is enthusiastic and energetic. The audio quality is very poor. | 2009-11-17T02:45:12Z | bengbengprod | RDV TOUS LES VENDREDI @ LOVE BOAT!!! dj skyone & dj akel au mix! ( hiphop hits, dancehall tunes, remixes, rn'b dancefloor, brand new dirty, house rmx ) c'est gratuit pour les miss avant o1h!!! 1o€ + conso! attention get ur swagg on! tenue fashion, glamour de rigueur!!! (contacts & infoline: bengbengprod@live.fr / 06 28 96 64 84 ) | ["Music", "Rhythm and blues", "Hip hop music"] | ["dj", "male vocals", "dj introduction", "party all night", "dance party", "people dancing", "wave your hands", "party music", "party time", "youthful music", "slow dancing", "electronic dance music", "poor audio quality", "male singer", "backup singers", "dj introduction video", "keyboard harmony", "groovy bass line"] | 1 | LvpImXJMryI | 2228 | |
Groovy Live Musik : "We no speak americano" by 4 to the bar : jazzy swing and lounge music | A male singer sings this groovy bop tune. The song is medium tempo with a groovy double bass playing, piano accompaniment, trumpet playing percussively and brush drumming rhythm. The song is entertaining and exciting. The song is a jazz dance tune with an electronica twist. | 2011-02-01T14:48:22Z | loungemusicband | http://4tothebar.de : More groovy lounge music, swing sounds and jazzy live music for club, event and party. Lounge Music: Die Live Band 4 to the bar spielt Swing, Samba und Jazz mit Drums, Kontrabass, Piano und Sängerin und Deejay | ["Swing music", "Funk", "Music", "Reggae", "Ska", "Rock and roll"] | ["groovy music", "love performance", "dj", "dance music", "brush drumming rhythm", "groovy bass line", "steady drum rhythm", "piano accompaniment", "trumpet playing percussively", "male singer", "female backup singer", "vocal harmony", "bop tune", "double bass harmony", "jazz music", "jazz dance music", "poor audio quality", "people dancing", "dance rhythm"] | 1 | RtgHU1UMo5o | 2729 |
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;