musiccaps_details (view)
3 rows where musiccaps_aspects contains "live performance", musiccaps_aspects contains "world music" and musiccaps_author = 7
This data as json, CSV (advanced)
musiccaps_aspects (array) 64 ✖
- live performance · 3 ✖
- world music · 3 ✖
- concert 2
- happy 2
- medium tempo 2
- acoustic 1
- african music 1
- amateur recording 1
- ambient outdoor sounds 1
- ambient sounds 1
- brass band 1
- carrie an music 1
- catchy 1
- celebratory 1
- clapping 1
- clapping cheering 1
- country rock 1
- country song 1
- distorted music 1
- dixie chicks concert 1
- energetic 1
- entertaining 1
- enthusiastic 1
- fans cheering 1
- fast tempo 1
- female vocalists 1
- festive 1
- folk 1
- girl band 1
- groovy 1
- groovy bass lines 1
- guiro 1
- guiro accompaniment 1
- hysteria 1
- incoherent sound 1
- inferior audio quality 1
- instrumental 1
- joyful 1
- keyboard accompaniment 1
- latin dance music 1
- latin music 1
- latin regional music 1
- live audience 1
- live music 1
- lively acordion 1
- male singer 1
- pleasant 1
- punchy 1
- r&b 1
- reggae 1
- reggae tones 1
- rhythmic acousitc guitar 1
- scraper instrument 1
- shakers 1
- simple 1
- spirited 1
- spirited congas 1
- stage performance 1
- static 1
- steady drumming 1
- the lord’s prayer 1
- trumpets 1
- vocal backup 1
- youthful 1
musiccaps_names (array) 9 ✖
- Music 3
- Accordion 1
- Bang 1
- Electronic music 1
- Maraca 1
- Musical instrument 1
- Reggae 1
- Singing 1
- Ska 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Dixie Chicks Taking the Long Way Live | A girl band sings this lively song. The tempo is medium with vibrant music. The audio quality is inferior so the music and vocals are incoherent. This is a live performance with ambient sounds of fans cheering, clapping and singing along. This song is a hit Country Rock. | 2006-08-02T22:04:41Z | Susanne Goldstone Rosenhouse | Live from Madison Square Garden. Natalie's introduction to New York fans then Taking the Long Way Live. Oh, and a little bit of me singing along and cheering. Didn't know my camera would pick that up. :) Hope y'all enjoy! | ["Singing", "Electronic music", "Music", "Bang"] | ["female vocalists", "medium tempo", "live performance", "country rock", "folk", "world music", "acoustic", "country song", "youthful", "enthusiastic", "energetic", "entertaining", "folk", "concert", "incoherent sound", "amateur recording", "live audience", "girl band", "dixie chicks concert", "ambient sounds", "fans cheering", "clapping", "hysteria"] | 7 | aGMdcxeF6Ak | 3524 | |
Israel Vibration African Unification | A male vocalist sings the Lord’s Prayer. The tempo is medium with Keyboard harmony, steady drumming, groovy basslines, rhythmic guitar,beat of shakers, vocal backup and a trumpet flourish. The music is simple, rhythmic, pleasant, catchy, soulful and punchy Reggae. There are sounds of people clapping and cheering in the background indicating that this is a live performance. | 2007-02-25T01:52:21Z | David Ruiz | Israel Vibration African Unification | ["Music", "Reggae", "Ska"] | ["male singer", "medium tempo", "reggae", "live performance", "stage performance", "concert", "rhythmic acousitc guitar", "clapping cheering", "vocal backup", "shakers", "pleasant", "punchy", "groovy", "happy", "simple", "pleasant", "reggae tones", "groovy bass lines", "trumpets", "brass band", "shakers", "steady drumming", "keyboard accompaniment", "the lord’s prayer", "carrie an music", "african music", "r&b", "world music", "catchy"] | 7 | blsYgo-B1k8 | 3650 | |
LUIS E.MARTINEZ EL CANTOR DE FONSECA | This music is a spirited Latin music instrumental. The tempo is fast with a lively accordion harmony, spirited congas beat and guiro accompaniment. The music is happy, vivacious, upbeat, vigorous, cheerful , celebratory and cheerful with ambient outdoor sounds like wind, people talking, clapping and a lot of static indicating that this is a live performance. The audio quality is inferior and this looks like an amateur home recording. | 2008-06-20T18:46:59Z | ALVARO VILLA FONTALVO | INTERPRETA EL CANTOR DE FONSECA EN COMPAÑIA DE SU AUTOR CARLOS HUERTAS EL CANTOR DE FONSECA- LUIS ENRIQUE INTERPRETA MAGISTRALMENTE SU ACORDEON, ENTRE LOS ASISTENTES ESTABA GABO, FUE EN EL AÑO 1993 EN B/QUILLA | ["Music", "Musical instrument", "Accordion", "Maraca"] | ["instrumental", "fast tempo", "distorted music", "static", "guiro accompaniment", "scraper instrument", "world music", "latin regional music", "latin dance music", "lively acordion", "spirited congas", "guiro", "latin music", "latin dance music", "happy", "spirited", "live performance", "live music", "ambient outdoor sounds", "inferior audio quality", "celebratory", "festive", "joyful"] | 7 | kpsYSXR1wao | 4360 |
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;