musiccaps_details (view)
1 row where musiccaps_aspects contains "vocal percussionist", musiccaps_aspects contains "youthful", musiccaps_author = 7 and musiccaps_names contains "Beatboxing"
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 |
---|---|---|---|---|---|---|---|---|---|---|
Amazing beatboxing, you won't believe it! (original, full) | This music clip is of a male vocalist doing a beat box. The tempo is medium fast with the vocalist imitating the digital drums, turntable and Dj mixer to a perfection. This vocal percussion is lively, rhythmic, youthful and engaging. | 2010-02-07T14:15:29Z | Karesz Fromvald | This is the uncut, original and full version of the beatboxing, no camera-changing. This guy is beatboxing like you never heard! MUST SEE! He is Joseph Poolpo, he is from France - thanks for the comment. This is a show, called Nouvelle Star, it's like America's Got Talent, the france version of the talent show. What's the best part? Can you do better? Write in the comments section below. I can't believe it's true! Amazing! Really Cool beatboxing! America's got talent THANKS FOR MORE THAN A MILLION VIEWS!!! #48 - Most Viewed - Music - Israel #37 - Most Viewed - Music - France #52 - Most Viewed - Music - Italy #33 - Most Viewed - Music - Czech Republic #30 - Most Viewed - Music - Czech Republic #18 - Most Viewed - Music - Israel #89 - Most Viewed - Israel #58 - Most Viewed - Music - France Thank you. -REUPLOADED | ["Beatboxing", "Music"] | ["vocalisation", "medium fast tempo", "male vocalist", "punchy", "boomy", "buoyant", "rap", "dance groove", "vocal percussionist", "youthful", "rhythmic", "skilled", "engaging", "beat boxing", "turn table imitation", "vigorous", "youthful", "vocal percussion", "vocal turntablism", "mouth and throat coordinated sounds", "dj", "hip-hop-rap", "digital drum imitation"] | 7 | 0abzD7hBTRk | 187 |
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;