musiccaps_details (view)
3 rows where musiccaps_aspects contains "live performance", musiccaps_aspects contains "male voice" and musiccaps_author = 9
This data as json, CSV (advanced)
musiccaps_aspects (array) 23 ✖
- acoustic drums 3
- bass guitar 3
- live performance · 3 ✖
- male voice · 3 ✖
- lively 2
- vibrant 2
- accordion 1
- acoustic guitar 1
- afrobeat 1
- colorful 1
- electric guitar 1
- floghera 1
- greek folk music 1
- keyboard 1
- mexican folk music 1
- orchestra 1
- oud 1
- percussion 1
- playful 1
- repeated tune 1
- rising tempo 1
- saxophone 1
- shouting 1
musiccaps_names (array) 4 ✖
- Music 2
- Accordion 1
- Blues 1
- Traditional music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Abeokuta Afrobeat na Ressaca do Bloco Uououou - Zombie | This is the live performance of an afrobeat music piece. There is a male voice singing occasionally. The melody is being played by a wide variety of instruments such as the electric guitar, the keyboard and the bass guitar. There is a saxophone playing a solo. In the rhythmic background, there is an acoustic drum beat in the style of afrobeat. It is joined by percussive elements. There is a vibrant atmosphere in this recording. This piece could be playing in the background of a West African cuisine restaurant. | 2014-03-12T03:57:41Z | Jedson Nobre | Abeokuta Afrobeat em apresentação na Ressaca do Bloco Uououou no Xinxim da Baiana, Olinda Interpretando Zombie, música de Fela Kuti. | ["Blues", "Music"] | ["afrobeat", "live performance", "male voice", "electric guitar", "bass guitar", "keyboard", "saxophone", "acoustic drums", "percussion", "vibrant", "colorful", "playful"] | 9 | Al_OdIuqoe0 | 1167 | |
EL ORIGINAL DE LA SIERRA "LA DESVELADA" | This is a Mexican folk music piece being performed live. There is male voice shouting at the end of the piece. The accordion is playing the main melody. The acoustic guitar and the bass guitar are playing in the background. The rhythmic background consists of a latin acoustic drum beat. The atmosphere is lively. This piece could be playing in the background at a Mexican restaurant. | 2009-10-14T02:38:05Z | FRONTERAVISUAL09 | MUSICAL EN BILLBOARD | ["Accordion"] | ["mexican folk music", "live performance", "male voice", "shouting", "accordion", "bass guitar", "acoustic guitar", "acoustic drums", "lively", "vibrant"] | 9 | XOsHEjo-RSg | 3181 | |
Stelios Mpikakis -Rethemniotikos siganos by QRTSIDAKIS | This is a live performance of a Greek folk music piece. There is an orchestra performing the piece. There is a floghera flute playing the main tune while the oud and the bass guitar are playing in the background. The rhythm is being played by the acoustic drums. After the shout coming from a male voice, the orchestra starts accelerating. The atmosphere is lively. This piece could be playing in the background at a seaside Greek tavern. | 2007-08-13T17:16:13Z | QRTSIDAKISN | Stelios Mpikakis -Rethemniotikos siganos Live sti Fortetzza.Mia sinaulia san panigiri. | ["Traditional music", "Music"] | ["greek folk music", "live performance", "orchestra", "oud", "floghera", "bass guitar", "male voice", "acoustic drums", "lively", "repeated tune", "rising tempo"] | 9 | mWuX--EEq2E | 4477 |
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;