musiccaps_details (view)
6 rows where musiccaps_aspects contains "live performance" and musiccaps_aspects contains "people cheering"
This data as json, CSV (advanced)
musiccaps_aspects (array) 108 ✖
- live performance · 6 ✖
- people cheering · 6 ✖
- exciting 3
- groovy bass line 3
- instrumental music 3
- dance rhythm 2
- energetic 2
- female vocals 2
- keyboard harmony 2
- live audience 2
- medium fast tempo 2
- spirited 2
- youthful 2
- adrenaline junkies 1
- adrenaline rush 1
- adventurous 1
- amateur recording 1
- ambient crowd noises 1
- ambient room noises 1
- ambient sounds 1
- bad audio quality 1
- beach party 1
- body movement noises 1
- choreography sounds 1
- dance club 1
- dance hit 1
- dance mix 1
- dance rehearsal 1
- dance studio 1
- devotional song 1
- diva 1
- dj 1
- electric rhythm guitar playing 1
- emotional 1
- encouraging vocals 1
- energetic dancing sounds 1
- energetic drumming rhythm 1
- entertaining 1
- enthusiastic 1
- excitement 1
- fast tempo 1
- female backup singers 1
- female guitarist 1
- female singers 1
- female sounds 1
- footsteps 1
- groove to the music 1
- groovy 1
- groovy music 1
- guitar playing rhythm 1
- guitar solo 1
- hard rock 1
- high energy 1
- high notes 1
- high pitch 1
- hindi movie song 1
- hindi song 1
- hindu devotion music 1
- hip hop dance song 1
- home video 1
- indian classical 1
- indian devotion music 1
- indian music 1
- inferior audio quality 1
- j-pop 1
- k-pop 1
- keyboard 1
- live concert video 1
- live recording 1
- male singer 1
- medium fats tempo 1
- noisy crowds 1
- party all night 1
- party song 1
- passionate 1
- people dancing 1
- people screaming 1
- percussive bass line 1
- percussive tap dancing 1
- poor audio quality 1
- poor audio recording 1
- pop dance hits 1
- pop divas 1
- pop hits 1
- pop love hits 1
- positive 1
- reggae band 1
- reggae music 1
- rock band 1
- rock drumming 1
- rock guitar solo 1
- shakers 1
- slow tempo 1
- snares riding fast 1
- song introduction 1
- steady drumming 1
- steady drumming rhythm 1
- studio recording 1
- tambourine 1
- tanpura 1
- tap dancers 1
- tap dancing 1
- testosterone driven 1
- trumpets play percussively 1
- various percussion hits 1
- violin harmony 1
- vocal harmony 1
- whistling tones 1
musiccaps_names (array) 10 ✖
- Music 6
- Music of Asia 2
- Tap 2
- Afrobeat 1
- Guitar 1
- Inside, large room or hall 1
- Pop music 1
- Synthetic singing 1
- Whoop 1
- Yell 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
2NE1_0721_SBS Inkigayo_FALLING IN LOVE_No.1 of the Week | A female singer sings this cool pop melody with backup singers in vocal harmony. The song is medium tempo with a groovy bass line, steady drumming rhythm, and keyboard accompaniment . The song is exciting and youthful. The audio quality with a lot of ambient crowd noises. | 2013-07-21T08:52:26Z | 2NE1 | Copyrightⓒ2013 SBS Contents Hub Co.,Ltd. & YG Entertainment Inc. All rights reserved. 2NE1 NEW SINGLE [FALLING IN LOVE] ▶ iTunes: http://smarturl.it/2NE1FallingInLove ▶ eBay: http://stores.ebay.com/YG-Entertainment ▶ YG-eshop: http://www.ygeshop.com ▶ YG-eshop (China): http://cn.ygeshop.com "Double Park TV" : http://smarturl.it/DoubleParkTV For More Information @ http://www.facebook.com/2ne1 http://twitter.com/ygent_official http://twitter.com/globalblackjack http://me2day.net/ygonair http://www.yg-2ne1.com App Store: http://goo.gl/l9TU6 Google Play: http://goo.gl/UiEn1 | ["Music of Asia", "Music"] | ["k-pop", "j-pop", "female singers", "female backup singers", "pop love hits", "pop dance hits", "whistling tones", "live performance", "vocal harmony", "groovy bass line", "steady drumming rhythm", "keyboard harmony", "emotional", "exciting", "enthusiastic", "passionate", "party song", "dance hit", "pop hits", "pop divas", "party all night", "people cheering", "groovy"] | 1 | 1xhwyUVSRQk | 318 | |
Orianthi - Guitar Solo [singfest 3/8/10] | The song is an instrumental. The tempo is medium fast with a strong guitar lead, rock drumming rhythm, percussive bass line and an electric guitar strumming rhythm. The song is high on adrenaline and exciting. The audio quality is very bad with ambient crowd screaming noises. | 2010-08-05T15:37:54Z | Zahara Sulaiman | Orianthi performance during singfest in Singapore. | ["Guitar", "Music", "Pop music", "Whoop", "Yell", "Inside, large room or hall"] | ["live performance", "ambient crowd noises", "medium fast tempo", "live concert video", "home video", "poor audio recording", "testosterone driven", "female guitarist", "exciting", "youthful", "diva", "rock guitar solo", "adventurous", "people screaming", "guitar solo", "rock band", "instrumental music", "people cheering", "bad audio quality", "hard rock", "rock band", "medium fats tempo", "rock drumming", "percussive bass line", "electric rhythm guitar playing"] | 1 | G8iTuTi8ywU | 1694 | |
nitin chakrdhari katra ( jk ) satyam shivam | A female vocalist sings this Hindi Devotion song. The tempo is slow with keyboard harmony,tambourine beats, violin melody and rhythmic tanpura accompaniment. This clip is the song introduction with slow chants like singing. The song is a Hindu Devotion song to the God Shiva. It is emotional, sentimental, devotional, prayerful praise and worship. There are ambient sounds of people talking and cheering, indicating that this is a live performance. | 2012-03-20T04:43:45Z | NCRC STUDIO | nitin chakrdhari enterainmant perfomer | ["Music of Asia", "Music", "Synthetic singing"] | ["female vocals", "slow tempo", "high pitch", "high notes", "tambourine", "indian classical", "indian devotion music", "hindu devotion music", "indian music", "keyboard harmony", "hindi song", "hindi movie song", "devotional song", "song introduction", "amateur recording", "inferior audio quality", "live performance", "people cheering", "violin harmony", "keyboard", "shakers", "tanpura", "ambient sounds"] | 7 | HdRPdh-cSTw | 1821 | |
robzn - Kill the sound boy feat. Karen Firlej | A male singer sings this reggae melody with a live audience. The song is medium tempo with a groovy drum rhythm, trumpet playing rhythmically, guitar playing accompaniment and a groovy bass line. The song is exciting and cheerful. The song is a modern reggae tune and played in both a live audience situation and studio recording quality. | 2015-03-08T15:21:56Z | Das Octagon | Luiggis Finest Kill the sound boy feat. Karen Firlej Karen: https://www.facebook.com/pages/Karen-Firlej/179074595612477 robzn: https://www.facebook.com/robznoffiziellergehtnicht http://robznoffiziell.de/ vrob: https://www.facebook.com/vroboffiziellergehtnicht Luiggis Finest: https://soundcloud.com/luiggisfinest/luiggis-finest-hip-hop-reggaeneration | ["Afrobeat", "Music"] | ["reggae music", "live recording", "reggae band", "exciting", "energetic", "dance rhythm", "spirited", "beach party", "dance club", "dance mix", "excitement", "groove to the music", "people dancing", "studio recording", "dj", "noisy crowds", "people cheering", "guitar playing rhythm", "trumpets play percussively", "steady drumming", "live audience", "live performance", "male singer", "people cheering", "dance rhythm", "groovy bass line"] | 1 | fWypK9RHJJI | 3955 | |
Shake it up | A hip hop dance song with female vocals plays as a dance track for three dancers. The song is fast tempo with faint audio signal with a lot of ambient room noises like footsteps sounds,body movements sounds and ambient room noise. The audio quality is very poor. | 2012-01-11T00:31:05Z | THESPACETV | shake it up | ["Music", "Tap"] | ["live performance", "dance studio", "tap dancing", "groovy music", "live performance", "high energy", "adrenaline rush", "choreography sounds", "encouraging vocals", "footsteps", "people cheering", "female sounds", "ambient room noises", "body movement noises", "hip hop dance song", "female vocals", "poor audio quality", "dance rehearsal", "instrumental music", "fast tempo", "energetic dancing sounds"] | 1 | jy0gitU1BFA | 4289 | |
Tap Dogs I Beams | The song is an instrumental. The song is medium fast tempo with a groovy bass line, energetic drumming, and tap dancers in a percussive groove. The song is entertaining and energetic. | 2009-07-26T17:06:46Z | Tap Dogs Official | ["Music", "Tap"] | ["tap dancers", "percussive tap dancing", "adrenaline junkies", "live audience", "live performance", "instrumental music", "groovy bass line", "people cheering", "energetic drumming rhythm", "medium fast tempo", "various percussion hits", "snares riding fast", "entertaining", "energetic", "positive", "spirited", "youthful", "dance rhythm"] | 1 | oRUdvu3Qo-E | 4628 |
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;