musiccaps_details (view)
3 rows where musiccaps_aspects contains "energetic", musiccaps_aspects contains "male singer", musiccaps_aspects contains "vocal backup" and musiccaps_author = 7
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 |
---|---|---|---|---|---|---|---|---|---|---|
Shira Choir Rocking it away with Pinky Weber Music by Pinny Ostreicher | A male vocalist sings this spirited song. The tempo is fast with trumpets, keyboard harmony, steady drumming and simple bass lines along with vocal backup. The song is happy, energetic, enthusiastic, popular, peppy, vivacious and celebratory. There are sounds in the background of people talking, hooting, cheering and scuttling and rustling. This is a popular Folk/Regional song. | 2015-09-04T19:04:46Z | Go Jewish Music | At a Siyem in Upstate! | ["Singing", "Music", "Ska", "Music of Latin America"] | ["male singer", "fast tempo", "vocal backup", "popular songs", "hooting", "rustling", "home video", "amateur recording", "party songs", "foreign language", "lively trumpets", "keyboard harmony", "steady drumming", "straight bass lines", "vocal backup", "people talking", "cheering", "energetic", "happy", "enthusiastic", "home video", "inferior audio quality", "folk song", "regional music", "happy", "peppy", "chirpy"] | 7 | 1hABzqBHh7w | 297 | |
Groom performs surprise Flash Mob Dance for his Bride | A male vocalist sings this upbeat pop song. The tempo is medium fast with thumping drum beats, percussion instruments, ukulele melody, keyboard accompaniment and rhythmic guitar. The audio is muddled making it difficult to hear the finer elements of the song. The song is energetic, enthusiastic, happy, fresh, peppy, perky , groovy. There is background chatter, clapping, cheering and rustling. The song is a Pop Rock/Alternative Indie. | 2014-09-02T16:09:17Z | Blue Kite Cinema | http://facebook.com/BlueKiteCinema Michael put together a flash mob dance with 80 friends and family members and surprised his new wife, Jessica, with it on their wedding day! This is a little teaser video including that dance and a few snippets from their day. | ["Music", "Tap"] | ["male singer", "fast tempo", "happy song", "groovy", "ukele melody", "acoustic guitar", "keyboard accompaniment", "emphatic vocals", "vocal backup", "energetic", "peppy", "buoyant", "dance grove", "party song", "club music", "muffled sounds", "boomy drumming", "strong drum beats", "clapping", "cheering", "happy", "peppy", "cheerful", "muddled audio", "synthesiser", "percussion grooves", "african percussion", "thumping music", "indie pop", "ukele"] | 7 | 3fqWosszpnE | 492 | |
Street King Energy Track #8 by 50 Cent | 50 Cent Music | A male vocalist sings this spirited rap. The tempo is fast with an animated piano accompaniment, groovy bass lines, intense drumming, cymbal rides and vocal backup. The song is youthful, vibrant, vivacious, animated, compelling ,enthusiastic and passionate . This song is contemporary Hip-Hop/Rap. | 2011-10-01T22:36:47Z | 50 Cent | SUBSCRIBE: http://bit.ly/YeOjEy New track by 50 Cent: Track #8 (Freestyle) Street King Energy Track #8 Order Street King at http://orders.streetking.com/ Previously: * 50 Cent - Street King Energy Track #7: http://www.youtube.com/watch?v=smqxZG2MLy0 * 50 Cent - Love, Hate, Love (Street King Energy Track #6): http://www.youtube.com/watch?v=NYjMKEYgAvI Permalink: http://www.thisis50.com/profiles/blogs/50-cent-street-king-energy-track-8 50 Cent - Street King Energy Track #8 About 50 Cent: Curtis James Jackson III, better known by his stage name 50 Cent, is an American rapper, entrepreneur, investor, and actor. This is his official YouTube Music Channel. Connect with 50 Cent Online: Visit 50 Cent Website: http://bit.ly/WM9S21 Like 50 Cent on Facebook: http://on.fb.me/XxuVyR Follow 50 Cent on Twitter: http://bit.ly/Y4XxPY Follow 50 Cent on Instagram: http://bit.ly/VLeAeX Buy 50 Cent Music Online: iTunes: http://bit.ly/1663kwB Amazon: http://amzn.to/14p4Gic Street King Energy Track #8 by 50 Cent | 50 Cent Music http://www.youtube.com/user/50centmusic | ["Jazz", "Music"] | ["male singer", "fast tempo", "rap", "rapper", "dance groove", "club music", "party music", "funk", "dance pop", "dance rap", "disco rap", "hip-hop", "hip-hop hits", "energetic", "enthusiastic", "rhythmic patter", "passionate emotional", "animated piano harmony", "vigorous drumming", "cymbals", "digital drumming", "punchy bass lines", "vocal backup", "street vernacular", "punk rap", "funk rap", "dance groove", "youthful", "compelling", "persuasive"] | 7 | Brc_nOquNbY | 1297 |
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;