musiccaps_details (view)
1 row where musiccaps_aspects contains "tireless", musiccaps_aspects contains "vigorous" and musiccaps_aspects contains "vocal turn table"
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 |
---|---|---|---|---|---|---|---|---|---|---|
Inertia VS Slykku | Daily Beatbox Battle ( 2015-07-27 ) | This audio clip is of a male vocalist beat boxing. The tempo is fast with the vocalist mimicking vigorous drumming, drum machine rhythms, turn table and other percussions.the rhythm is vigorous, energetic and tireless. | 2015-07-28T20:49:10Z | BeatboxRapCom | Inertia VS Slykku | Daily Beatbox Battle ( 2015-07-27 ) Want to join us ? Read More! ························································································································ For infos how you can Join, try: http://www.beatbox-rap.com Download Teamspeak: http://www.teamspeak.com/?page=downloads http://join.beatbox-rap.com Server Adress: ts.beatbox-rap.com Facebook: https://www.facebook.com/BeatboxRapCom We bring every Musician a Place, where People can make Music together. ························································································································ http://www.BeatboxRap.Com is a Music Community Project for: - Beatboxer - Vocalists - Instrumental - DJ's - Rap http://www.beatbox-rap.com ** WANTED *** We want your Talent. Make Music with Friends. Get in touch with your Skills. Start great Music Projects. Youtube video Creation - Youtube free music - Beatbox Battle Online - | ["Beatboxing", "Music"] | ["beat boxing", "vocal percussion", "mimicking drum machines", "vocal percussion simulation", "vocal sound effects", "rap", "hip hop", "vocalisation", "rapid", "vigorous drumming sound", "digital drum sounds", "vocal percussion", "vocal turn table", "vigorous", "tireless", "energetic", "vocal drum machine"] | 7 | -i9uQMysy_A | 77 |
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;