musiccaps_details (view)
4 rows where musiccaps_aspects contains "bad audio quality", musiccaps_aspects contains "energetic" and musiccaps_aspects contains "live performance"
This data as json, CSV (advanced)
musiccaps_aspects (array) 48 ✖
- bad audio quality · 4 ✖
- energetic · 4 ✖
- exciting 4
- live performance · 4 ✖
- instrumental music 3
- live audience 3
- passionate 3
- ambient crowd noise 2
- groovy rhythm 2
- medium fast tempo 2
- medium tempo 2
- amateur recording 1
- bagpipes playing 1
- carnatic music 1
- carnatic vocals 1
- celtic music 1
- clap box rhythm 1
- crowds cheering 1
- crowds clapping 1
- dance rhythm 1
- drum demonstration 1
- drum playing percussively 1
- drum solo 1
- drums maestro 1
- echoes 1
- enthusiastic 1
- exciting solo 1
- exemplary stick work 1
- female bagpiper 1
- gripping experience 1
- groovy bass 1
- impressive playing 1
- indian classical music 1
- male vocalist 1
- mridangam percussion 1
- people talking 1
- percussion demonstration 1
- percussionist 1
- performer 1
- pulsating experience 1
- retro drum hits 1
- rhythm section 1
- spirited 1
- syncopated rhythms 1
- tabla 1
- victory march 1
- war cry 1
- youtube music video 1
musiccaps_names (array) 15 ✖
- Percussion 3
- Bagpipes 1
- Bass drum 1
- Carnatic music 1
- Classical music 1
- Cowbell 1
- Drum 1
- Drum kit 1
- Music 1
- Musical instrument 1
- Rimshot 1
- Singing 1
- Snare drum 1
- Wind instrument, woodwind instrument 1
- Wood block 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Julie Fowlis playing Bagpipe - Live | The song is an instrumental. The song is fast in tempo, with a bagpiper playing a Solo melody accompanied by a drum rhythm and people cheering and clapping wildly. The song is rousing in spirit and fervour. The song has a bad audio quality. | 2009-09-05T09:48:05Z | smartotrams | Live at Lüdenscheid, Germany 4th Sept 2009 | ["Bagpipes", "Wind instrument, woodwind instrument"] | ["female bagpiper", "bagpipes playing", "live performance", "live audience", "crowds clapping", "crowds cheering", "drum playing percussively", "exciting solo", "passionate", "celtic music", "war cry", "victory march", "bad audio quality", "ambient crowd noise", "performer", "instrumental music", "exciting", "energetic", "enthusiastic", "groovy bass", "rhythm section", "medium fast tempo"] | 1 | 0NTzOtVmoiU | 154 | |
DR.M.BALAMURALIKRISHNA - THILLANA | A male vocalist sings this traditional Carnatic vocals. The song is medium tempo with a violin accompaniment, tabla and mridangam playing percussion. The song is energetic and passionate and highlights the traditional Carnatic music art form. The audio quality is bad. | 2007-04-17T07:21:47Z | Musique4ever | Dr.M.Balamuralikrishna sings a thillana in Ahir Bhairav. | ["Singing", "Carnatic music", "Music", "Musical instrument", "Classical music", "Percussion"] | ["carnatic music", "male vocalist", "medium tempo", "tabla", "energetic", "passionate", "indian classical music", "bad audio quality", "live performance", "live audience", "passionate", "spirited", "exciting", "mridangam percussion", "carnatic vocals"] | 1 | Emc18GpAeRY | 1588 | |
Anjo caldas tocando havaneiro | The song is an instrumental. The song is medium fast tempo with percussionists playing a groovy rhythm on three clap boxes. The sound quality is poor with a lot of ambient crowd noise. | 2007-04-08T02:27:14Z | nochaoss | percussionista da elba ramalho tocando o trio de haveneiros fabricados pela virgo percussao(www.virgopercussao.com.br) | ["Wood block", "Percussion"] | ["clap box rhythm", "percussionist", "medium fast tempo", "live performance", "exciting", "energetic", "passionate", "drum demonstration", "youtube music video", "instrumental music", "ambient crowd noise", "groovy rhythm", "people talking", "bad audio quality", "percussion demonstration"] | 1 | NcsYdCbKgcc | 2351 | |
Drums Steve Gadd Cowbell.wmv | The song is an instrumental. The tempo is medium with a maestro percussionist performing a solo drum solo in front of a live audience. The song is exciting and gripping. The audio quality is poor. | 2008-12-16T11:27:34Z | bestdrumvideos | Drums Steve Gadd | ["Cowbell", "Drum", "Drum kit", "Rimshot", "Snare drum", "Bass drum", "Percussion"] | ["drum solo", "live performance", "live audience", "gripping experience", "instrumental music", "echoes", "syncopated rhythms", "drums maestro", "impressive playing", "energetic", "medium tempo", "groovy rhythm", "bad audio quality", "amateur recording", "exciting", "pulsating experience", "exemplary stick work", "retro drum hits", "dance rhythm"] | 1 | nrj2zTr7U0o | 4584 |
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;