musiccaps_details (view)
9 rows where musiccaps_aspects contains "lively", musiccaps_aspects contains "male vocal" and musiccaps_author = 9
This data as json, CSV (advanced)
musiccaps_aspects (array) 59 ✖
- lively · 9 ✖
- male vocal · 9 ✖
- bass guitar 4
- electric guitar 4
- vibrant 4
- acoustic drums 2
- energetic 2
- keyboard 2
- melodic singing 2
- percussion 2
- upbeat 2
- accordeon 1
- acoustic drum 1
- acoustic guitar 1
- acoustic latin drums 1
- afro cuban 1
- algerian folk music 1
- amateur recording 1
- banjo 1
- chant-like singing 1
- cheerful 1
- chill 1
- choir 1
- conga 1
- country music 1
- croatian pop 1
- dance 1
- danceable 1
- dancehall 1
- dub 1
- easygoing 1
- electronic drums 1
- flute 1
- hard-hitting 1
- jamaican 1
- joyful 1
- joyful singing 1
- latin dance music 1
- latin folk 1
- live performance 1
- live recording 1
- loud singing 1
- maracas 1
- medium-to-high pitch singing 1
- off-key singing 1
- pop rock 1
- preach-like singing 1
- rai 1
- raspy voice 1
- reggae 1
- rumba 1
- shekere 1
- ska punk 1
- spanish language 1
- studio performance 1
- ukulele 1
- upright bass 1
- venezuelan 1
- violin 1
musiccaps_names (array) 16 ✖
- Music 9
- Ska 4
- Musical instrument 3
- Rattle (instrument) 3
- Song 2
- Accordion 1
- Drum 1
- Drum kit 1
- Electronic music 1
- Music of Africa 1
- Music of Latin America 1
- Percussion 1
- Reggae 1
- Rock and roll 1
- Roll 1
- Soul music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Baile Compadre. Los maestros del baile!! Tecktonik ,jumpstyle y shuffle en uNO!!! | This is an amateur recording of a latin dance music piece. The audio quality is not that great. There is a male vocalist singing loudly. A bass guitar is playing a groovy bass line while an electric guitar is strumming chords in a syncopated manner. The rhythmic background is provided by a barely heard latin acoustic drum beat. The atmosphere is cheerful. This piece could be sampled for use in the making of a latin influenced hip-hop beat. | 2009-10-17T01:50:54Z | jonixhc | electro/duranguense duran/style jump | ["Electronic music", "Music", "Music of Latin America"] | ["amateur recording", "latin dance music", "male vocal", "loud singing", "bass guitar", "electric guitar", "acoustic latin drums", "cheerful", "lively"] | 9 | 2z1elo4ucis | 425 | |
Cheikha Rimitti - Ya Nafrah | This is an Algerian folk music, also known as Rai. There is a male vocalist singing in a chant-like manner. There is a flute playing the main melody while the rhythm is being provided by several percussive elements. There is a lively feel to it. This piece could be used in the opening shots of a movie taking place in North Africa. It could also be in the soundtrack of a desert-themed video game. | 2013-02-10T18:35:15Z | toukadime | Cheikha Rimitti - Ya Nafrah الشيخة Rimitti - يا النفرة La Voix Du Globe | ["Music", "Rattle (instrument)"] | ["algerian folk music", "rai", "male vocal", "chant-like singing", "flute", "percussion", "vibrant", "lively", "energetic"] | 9 | FteW_2gNtD4 | 1672 | |
Lucrecio García_Golpe de Arpa con Estribillo | This is a latin folk piece performed at a home setting. There is a male vocalist singing off-key in a shout-like manner. An accordion and a ukulele are providing the melodic background for the piece. A pair of maracas is being played for the rhythmic background. The piece has a joyful atmosphere. The instrumentals can be used for sampling to put them in a beat. | 2009-05-14T23:55:12Z | Escucha Joropo | Forma de Joropo Tradicional del oriente venezolano la cual tiene similitud con la del Joropo Corrío Llanero. Su ciclo armónico es Tónica-Subdominante-Dominante-Tónica (I-IV-V7-I). Tiene salida a Estribillo como es común en el Joropo Oriental. Se caracteriza por ser muy vivaz lo que emociona a cantadores y bailadores. En esta ocasión Lucrecio nos demuestra su dominio en este tipo de acompañamiento logrando la inspiración en el Canto tanto de Mónico Márquez como de Luis Raposo. | ["Music", "Musical instrument", "Rattle (instrument)", "Accordion"] | ["latin folk", "live recording", "male vocal", "off-key singing", "accordeon", "ukulele", "maracas", "lively", "joyful", "vibrant", "venezuelan"] | 9 | ZahBai58_Ec | 3395 | |
Oliver Dragojevic - Serenada (mix) | This is a Croatian pop music piece. There is a male vocalist singing melodically in the lead. The acoustic guitar is playing a simple tune with the bass guitar playing in the background. The rhythm is played by a basic electronic drum beat with an acoustic sound. There is a lively atmosphere to this piece. This piece could fit well in the soundtrack of a romantic comedy movie that takes place in Croatia. | 2012-03-18T23:49:52Z | Life is Good | ["Music", "Soul music"] | ["croatian pop", "male vocal", "melodic singing", "acoustic guitar", "bass guitar", "electronic drums", "lively", "easygoing"] | 9 | Zy_YSROQmlE | 3431 | ||
Strawfoot - churchyard cough live | This is a country music piece. There is a male vocalist singing in a preaching manner. The melody is being played by a violin, a banjo and an electric guitar while an upright bass is playing in the background. The rhythmic background consists of an accentuated acoustic drum beat. The atmosphere is lively and hard-hitting. This piece could be used in the soundtrack of a historical crime movie taking place in the US. | 2009-06-01T06:07:26Z | Word Smith | Dirge-Country pioneers, Strawfoot, bring a dark sound of candy-coated salvation and eternal hellfire and damnation to the public with haunting cautionary tales of outlaw scarecrows, wayward preachers, falling pianos, and the devil. Strawfoot creates an original sound steeped in the rich, dark history of America and beyond. Fronted by a crazed and angry preacher, Strawfoot is a seven-piece band consisting of violin, banjo, harmonica, upright bass, guitar, percussion and the occasional mandolin and accordian. Strawfoot has quickly become a fan favorite wherever they take the stage, gaining fans across America and abroad. | ["Music", "Ska", "Song", "Rock and roll"] | ["country music", "male vocal", "preach-like singing", "violin", "banjo", "electric guitar", "upright bass", "acoustic drums", "lively", "hard-hitting"] | 9 | adYFXYPqo2M | 3562 | |
My SunShine ROCK'A'TRENCH cover HD 【THE FUCKIN' EVOLBAND】 | This is a pop rock music piece being performed in the studio. There is a male vocalist singing melodically in the lead. The electric guitar is playing a simple tune with the bass guitar in the background. The acoustic drums are playing an upbeat rhythm with off-beat hi-hat strokes. The atmosphere is energetic. This piece could be used as the opening theme of a Korean teenage drama TV series. | 2009-11-06T14:31:39Z | PROJECTJEI | in STUDIO YOU Oct. 30, 2009 | ["Drum kit", "Music", "Musical instrument", "Ska", "Roll"] | ["pop rock", "studio performance", "male vocal", "melodic singing", "electric guitar", "bass guitar", "acoustic drum", "upbeat", "energetic", "lively"] | 9 | eJFZuX0WHgk | 3856 | |
Maskatesta - Castillos de Juguete [This Is Ska] | This is a ska punk music piece. There is a male vocalist with a raspy voice singing in the Spanish language. The keyboard and the electric guitar are playing the melody while there is a bass guitar playing in the background. The rhythm consists of fast tempo acoustic drum beats. The atmosphere is lively. This piece can be played at sports venues. | 2010-08-11T05:34:43Z | REBORracho7 | Esta es una de las rolas del nuevo disco de la maskatesta... This Is Ska!!! | ["Music", "Ska"] | ["ska punk", "male vocal", "raspy voice", "spanish language", "electric guitar", "keyboard", "bass guitar", "acoustic drums", "lively", "danceable", "upbeat"] | 9 | nyLpME6YH20 | 4597 | |
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 | |
Capleton, Turbulence, Chuck Fender, Chrisinti, Bascom X, Major Chris, Anthony Cruz Passi new songs dancehall ska roots | This is a dancehall music piece. There is a male vocalist singing at a medium-to-high pitch with a Jamaican accent. In the background, there is a keyboard playing the main melody. The atmosphere of the piece is vibrant. This piece could be used at beach parties and summer/vacation themed movies or TV shows. | 2010-11-04T07:12:42Z | reggaedownload | ["Music of Africa", "Music", "Reggae", "Ska", "Song"] | ["dancehall", "reggae", "dub", "jamaican", "male vocal", "medium-to-high pitch singing", "keyboard", "chill", "vibrant", "lively"] | 9 | zfkPKRn8ah8 | 5502 |
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;