musiccaps_details (view)
3 rows where musiccaps_aspects contains "dance party", musiccaps_aspects contains "poor audio quality" and musiccaps_author = 1
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 |
|---|---|---|---|---|---|---|---|---|---|---|
| 1st Place DJ NIFFTY - 2010 World DMC DJ Championships - South African Final | A male singer sings this rapping vocals with a backup singer. The song is medium tempo with a groovy drum rhythm, disc scratching sounds, strong bass line and string accompaniment. The song is groovy and has a dance rhythm. The song audio quality is poor. | 2010-09-30T14:21:46Z | edptv | Produced by: www.blackbirdproductions.co.za 2010 South African DMC DJ Championships Final. MULTI-CAM of Live Set - DJ NIFFTY - Club Atmospheer - Cape Town - South Africa. RESULTS: 1st - DJ NIFFTY (2010 South African DMC DJ Champion) http://www.youtube.com/watch?v=6YXjJ6ABnZU 2nd - DJ CODAX http://www.youtube.com/watch?v=dibExyXfC3c 3rd - DJ ON Q http://www.youtube.com/watch?v=rCIoFNNOdOE FINALISTS: DJ CALCULUS http://www.youtube.com/watch?v=kvmBoL-tmtA DJ SHAMELESS http://www.youtube.com/watch?v=Uo5YJZ6RFbI DJ MARV D http://www.youtube.com/watch?v=1NqCsKCitfA DJ JUICE http://www.youtube.com/watch?v=J4xzSdnnFLM | ["Scratching (performance technique)", "Electronic music", "Music", "Speech"] | ["techno pop music", "male vocals", "rapping vocals", "dance party", "all night party", "discotheque", "dance floor", "dance rhythm", "energetic", "exciting", "medium tempo", "dj turntable", "ambient noises", "poor audio quality", "dance music", "electronic dance music", "groovy music", "dj face off", "disc scratching noises"] | 1 | 6YXjJ6ABnZU | 766 | |
| 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 | |
| Best Dancehall of the 90's part 1 | A male singer sings this melody with a backup singer singing rapping vocals. The song is medium tempo, with a steady drumming rhythm, groovy bass line and keyboard accompaniment. The song is groovy and exciting. The song is a retro reggae song but has a poor audio quality. | 2008-11-02T05:58:19Z | Jason | Best Dancehall of the 90's part 1 Add me on Facebook... Dj-Mix Vybz Catch My live broadcast every Wednesday night at www.284radio.com from 8-11 Subscribe and check out the rest of my vids | ["Electronic music", "Music", "Ska"] | ["poor audio quality", "reggae music", "groovy bass line", "sway to the music", "dance party", "steady drumming rhythm", "guitar accompaniment", "people dancing", "tropical dance party", "rapping vocals", "retro reggae", "keyboard accompaniment", "male singer backup singers"] | 1 | p28jmA01BHo | 4679 |
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;