musiccaps_details (view)
3 rows where musiccaps_aspects contains "dance rhythm", musiccaps_aspects contains "groovy rhythm" and musiccaps_aspects contains "vocal harmony"
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 |
---|---|---|---|---|---|---|---|---|---|---|
Singing Rats | Animated vocalists singing a choral harmony. The song is medium tempo with no instrumentation, but just voices singing in various harmonic ranges. The song is cheerful and cartoonish. The song is a parody of a modern pop song with western classical music influences. | 2006-12-27T18:04:00Z | Persephone22 | Die singenden Weihnachtselche haben mich zu diesem Clip inspiriert*gg* Hier nun also die singenden Ratties. *vorhang auf schieb* | ["Music", "Synthetic singing"] | ["animated vocals", "chipmunk noises", "medium tempo", "cheerful", "high pitched vocals", "choral section", "dance rhythm", "groovy rhythm", "cartoony sounds", "vocal acapella", "no instrumentation", "vocal harmony", "choral harmony", "auto tuned vocals", "exciting", "parody"] | 1 | PSYURntIjuc | 2538 | |
[2NE1 'I AM THE BEST' DANCE COVER] 2NE11 from LOS ANGELES | Female singers sing this vocal harmony with backup singers. The song is medium tempo with a groovy bass line, violin countermelody, and keyboard harmony. The song is entertaining and groovy. The song has a poor audio quality. | 2011-07-28T00:01:02Z | thebeatgoesboomcat | ***Thank you everyone who voted for us! We're happy we got to share our love for dance, music, and most importantly 2NE1 with so many of you guys :)*** WE LOVE 2NE1!!!!!!!! We are "2NE11" from Los Angeles! We're called "2NE11" because that's the year we made the video. Also, we almost have 11 dancers. We're just a bunch of college and post-grad-in-denial students dancing it away on the streets of LA until morning traffic hits :) We had a lot of fun making this video, and I hope you guys enjoyed watching it too! It was a lot of fun choreographing and dancing to 2NE1 again (we did it to Can't Nobody before... WOOHOO!!!!) Our project team consists of Korean, Japanese, Chinese, Taiwanese, Indonesian, and Vietnamese dancers :] HI 2NE1!!! If you happen to be reading this, we'd love to meet you guys in person :) Thank you for giving us an opportunity to pay tribute to our favorite group with our closest friends who share the same passions - dance, joking around, and 2NE1! :] ********************************************************* Thanks for voting for us at: http://www.youtube.com/ygevent They have other cool submission videos so check them out! ********************************************************* Now, here are the lovely dancers: Bart Wiharto Christie Tang Derick Ngan HoSeong Hwang Jennie Kim Justine Yoon Lucas Yu Naoya Nick Ogura Stephanie YoonJi Song Tiffany Hung Choreographers: Stephanie YoonJi Song Christie Tang Derick Ngan Naoya Nick Ogura ... with the help and input from all of our dancers :] | ["Music", "Zing"] | ["female singers", "poor audio quality", "asian pop", "vocal harmony", "techno dance pop", "trance music vibes", "groovy rhythm", "strong bas slide", "high gain limits", "steady drumming rhythm", "violin harmony", "dance rhythm", "passionate", "spirited"] | 7 | TworrkXAPuI | 2877 | |
*NEW UPLOAD* Itz Tiffany ft Fuse ODG - Spanner (Official Video) | A male singer sings this hip hop dance song. The tempo is medium tempo with a groovy bass line, keyboard harmony and reggae inspired drumming rhythm. The song is story telling and romantic in nature. | 2014-07-16T20:50:50Z | OffDaGroundTV | Pre-Order "New Africa Nation" the Album now here: https://fuseodg.tmstor.es Shop for New Africa Nation Clothing online here : https://newafricanation.bigcartel.com/ / Fuse ODG's Album 'T.I.N.A' on iTunes: http://smarturl.it/FuseODGTINA *NEW UPLOAD* Itz Tiffany ft Fuse ODG - Spanner (Official Video) | ["Music", "Reggae"] | ["male singer", "hip hop music", "exciting", "people dancing", "modern love", "reggae hip hops music", "medium tempo", "dance rhythm", "male backup singers", "vocal harmony", "story telling", "groovy bass line", "guitar rhythm", "string harmony", "romantic", "groovy rhythm", "dance rhythm", "hip hop dance music", "emotional"] | 1 | jQYSfy4DzIc | 4253 |
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;