musiccaps_details (view)
3 rows where musiccaps_aspects contains "dance", musiccaps_aspects contains "lively" and musiccaps_author = 9
This data as json, CSV (advanced)
musiccaps_aspects (array) 31 ✖
- dance · 3 ✖
- lively · 3 ✖
- vibrant 2
- acoustic drums 1
- acoustic guitar 1
- afro cuban 1
- afro-cuban 1
- audience clapping 1
- bass guitar 1
- catchy 1
- choir 1
- conga 1
- electric guitar 1
- energetic 1
- folk 1
- joyful singing 1
- latin dance 1
- latin percussion 1
- live performance 1
- loud 1
- male and female vocal 1
- male vocal 1
- male vocals 1
- melodic singing 1
- percussion 1
- pop music 1
- rumba 1
- shekere 1
- synth 1
- upbeat 1
- upright bass 1
musiccaps_names (array) 8 ✖
- Music 3
- Drum 1
- Flamenco 1
- Musical instrument 1
- Percussion 1
- Rattle (instrument) 1
- Rock and roll 1
- Roll 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
LEGENDARY MUSICIANS OF OLD HAVANA Pt 3 | This is an afro-cuban folk music compilation. There are male vocals singing in an energetic manner. There are acoustic guitars playing the main themes while upright bass is used for the lower range. The rhythmic background is provided by a variety of latin percussive instruments. There is a vibrant atmosphere. Parts of this recording can be used in latin dance courses as accompaniment pieces. | 2007-08-30T02:04:47Z | chak bay Grande | MORE of Alma de Cuba with Angel Abreu singing Meneame la cuna and El Manisero | ["Flamenco", "Music"] | ["afro-cuban", "folk", "latin dance", "male vocals", "acoustic guitar", "upright bass", "latin percussion", "dance", "vibrant", "energetic", "lively"] | 9 | 6AC84nr6ckM | 732 | |
Acrobatic Rock and Roll - Europe championship 2009 - Foot technique | This is the live recording of a dance performance that uses a pop music piece as accompaniment. There is a male and a female vocalist singing melodically. The tune of the piece is being played by the electric guitar, the bass guitar and the synth. There is an upbeat acoustic drum beat in the rhythmic background. The audience can be heard clapping to the beat. The atmosphere is loud and lively. It could work well as the backing track in a modern dance course. | 2009-11-16T10:03:37Z | Tomáš Tlášek | RNR - Velika Gorica - 7.11.2009 - Foot technique - Ivan KLIMOV - Katrin GAZAZYAN (RUS), Lukas FURST - Alzbeta SLAMOVA (CZE), Maurizio MANDORINO - Jade MANDORINO (SUI), Jacek TARCZYLO - Anna MIADZIELEC (POL), Julien FOULON - Ingrid FOULON (FRA), Michael TRÜB - Stephanie RÜEGG (SUI), Neven IVIC - Ivana MIHALIC (CRO) | ["Music", "Roll", "Rock and roll"] | ["pop music", "dance", "male and female vocal", "melodic singing", "electric guitar", "bass guitar", "acoustic drums", "synth", "audience clapping", "loud", "lively", "catchy", "upbeat"] | 9 | ggBivmG6yHQ | 4045 | |
Yamil Castillo - Rumba Grupo Afro Cubano Bakinikini | This is an Afro-cuban music piece in the style of rumba. It is a live performance. There is a male vocal and a choir singing in a joyful manner. The rhythmic background is composed of Afro-Cuban percussive elements such as the shekere and the conga. The atmosphere is lively and vibrant. This piece could be used as an accompaniment piece for a rumba dance course. | 2006-11-04T22:29:10Z | Yamil Castillo | Grupo Afro Cubano Bakinikini. Yamil Castillo: Conga( Quinto )y Coro. Llensy Zafra: Congas ( Tumbadora Tres dos )y Coro. Camilla Brena: Kata ( Guagua ) Eduardo Cespedez: Chequere y Coro. Yusniel "El Niño Lopez": Canto. | ["Drum", "Music", "Musical instrument", "Rattle (instrument)", "Percussion"] | ["afro cuban", "rumba", "live performance", "male vocal", "choir", "joyful singing", "percussion", "shekere", "conga", "lively", "vibrant", "dance"] | 9 | wMN-Xp9IMUw | 5260 |
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;