musiccaps_details (view)
5 rows where musiccaps_aspects contains "bad audio quality", musiccaps_aspects contains "guitar strumming" and musiccaps_author = 1
This data as json, CSV (advanced)
musiccaps_aspects (array) 80 ✖
- bad audio quality · 5 ✖
- guitar strumming · 5 ✖
- emotional 3
- groovy rhythm 3
- medium tempo 3
- passionate 3
- backup singers 2
- country music 2
- dance rhythm 2
- instrumental music 2
- keyboard accompaniment 2
- male singer 2
- spirited 2
- accordion harmony 1
- accordion players 1
- accordion virtuosos 1
- autoharp accompaniment 1
- banjo 1
- blues 1
- brass band 1
- chaotic harmonies 1
- cheerful 1
- child performers 1
- classic county hits 1
- country bluegrass 1
- country classics 1
- country dance music 1
- country folk music 1
- country guitar band 1
- country singer 1
- country super hits 1
- crooning vocals 1
- energetic 1
- enthusiastic 1
- euro pop 1
- everlasting hits 1
- exciting 1
- fiddlers 1
- groovy music 1
- guitar leads 1
- gypsy music 1
- improvisational music 1
- latin dance band 1
- latin medium tempo 1
- latin percussions 1
- latin super hits 1
- live music 1
- live performance 1
- live studio performance 1
- loud ambient room noise 1
- love song 1
- madly in love 1
- male latin singer 1
- medium fast tempo 1
- modern country love songs 1
- never give up 1
- nostalgia 1
- old memories 1
- percussions playing rhythmically 1
- percussive bass line 1
- pleasant 1
- pop super hits 1
- positive 1
- retro hits 1
- romantic 1
- song cover 1
- spirited exciting 1
- steady drumming 1
- story telling 1
- the country life 1
- the wild west 1
- traditional music 1
- trombones 1
- trumpets blaring 1
- tubas 1
- violinists 1
- vocal harmony 1
- walking bas s line 1
- walking bass line 1
- walking bass style 1
musiccaps_names (array) 13 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Aleksander Mežek - Siva pot | A male singer sings this popular country hit with backup singers in vocal harmony. The song is in medium tempo with a walking bass , acoustic guitar strumming rhythmically, autoharp accompaniment and steady drumming rhythm. The song is an emotional and nostalgic country hit. The audio quality is poor. | 2006-12-19T14:33:29Z | jaki386 | Aleksander Mežek - Siva pot | ["Christian music", "Music", "Musical instrument"] | ["male singer", "backup singers", "guitar strumming", "everlasting hits", "euro pop", "medium tempo", "walking bass line", "autoharp accompaniment", "walking bas s line", "steady drumming", "story telling", "nostalgia", "pleasant", "exciting", "enthusiastic", "old memories", "classic county hits", "pop super hits", "retro hits", "groovy rhythm", "country classics", "bad audio quality", "song cover", "country music"] | 1 | 3KQy3Cajo4E | 456 | |
'Kiss a Girl Sessions' Video Keith Urban AOL Music | A male country singer sings this passionate melody with backup singers in vocal harmony. The song is medium tempo with a strong drumming rhythm, guitar accompaniment, guitar lead, percussive bass line and percussion hits. The song is passionate and romantic. The song has bad audio quality. | 2009-04-16T00:03:13Z | Nick Czapiewski | http://nickwinch.blogspot.com/ Keith Urban singing Kiss a Girl on AOL music. Make sure you pick up "Defying Gravity" in stores and online now!! ***NO INFRINGEMENT INTENDED*** just spreading the good news of Keith Urban | ["Music", "Happy music", "Exciting music"] | ["male singer", "country singer", "backup singers", "vocal harmony", "crooning vocals", "medium tempo", "guitar leads", "guitar strumming", "percussive bass line", "keyboard accompaniment", "energetic", "passionate", "love song", "romantic", "country guitar band", "modern country love songs", "country super hits", "madly in love", "bad audio quality"] | 1 | 9uToez74x_M | 1048 | |
LA REVANCHA (en vivo) - ZAPEROKO LA RESISTENCIA SALSERA DEL CALLAO | Male singer sings this cool Latin melody. The song is medium tempo with various Latin percussion instruments and a brass band playing percussively in harmony. The song is energetic and has a cool dance rhythm. The audio quality of the song is average. | 2016-03-01T12:45:56Z | Orquesta Zaperoko La Resistencia Salsera del Callao | La Revancha Letra de Hugo Almanza Durand, se inició como compositor en 1965. Ha creado boleros, valses, cumbias y huaynos ayacuchanos. Entre los cantantes nacionales que han interpretado sus temas se encuentran Lucho Barrios, Ramón Avilés, Pedrito Otiniano, Los Morunos, Gaby Zevallos, Johnny Farfán, Los Kipus, Eddy Martínez, Agua Marina y otros. Además, se ha desempeñado como locutor en Radio La Crónica, Radio Lima y Radio Nacional del Perú. Otros temas del maestro Almanza Durand que han tenido éxito internacional son: «Disimula», «Ya te olvidé», «Acepto mi destino», «El Olvido», «Huye de mí» y «Resignación». «La revancha» tiene más de 70 versiones, «Disimula» 40 y «Acepto mi destino» no menos de 20. Ahora en la version de Salsa de Zaperoko La Resistencia Salsera del Callao, en la version del Dominicano Cuco Valoy y los arreglos de nuestro cantante compositor Diego Horacio Chuquitaype, Bajo la Direccion de Jhonny Peña, esta una version para RadioMar Plus, grabado en los Estudios de Company Music Zaperoko La Resistencia Salsera del Callao Contratos al 997329972 - 981168066 LA REVANCHA (SESIÓN MULTITRACK EN VIVO) FULL HD Presentamos la "PRIMERA EDICIÓN EN VIVO" de Orq. "ZAPEROKO" Productor Musical: GIANCARLOS ARROYO B. CHRISTIAN REY SANCHEZ. Edición, Mezcla y Mazterizaciòn: COMPANY MUSIC RECORDS - Dale LIKE a nuestra pagina (https://www.facebook.com/companymusicrecords/) Edicion AudioVisual: BASSET ESTUDIO. LIMA- PERU Visita nuestras instalaciones y se participe de nuestros vídeos en FULL HD. SOUNDCLOUD: https://soundcloud.com/company-music-records | ["Music", "Musical instrument", "Music of Latin America", "Salsa music"] | ["bad audio quality", "latin dance band", "latin super hits", "keyboard accompaniment", "male latin singer", "groovy rhythm", "live studio performance", "latin medium tempo", "brass band", "latin percussions", "trumpets blaring", "trombones", "tubas", "guitar strumming", "dance rhythm", "latin dance band", "emotional", "spirited", "passionate"] | 1 | F3uf_RleI3E | 1611 | |
sleepy man banjo boys vs mountain rhythm | The song is instrumental. The tempo is medium with a prolific fiddler playing melody and a banjo and guitar accompaniment. The song is adventurous and exciting. The song is a classic country instrumental. The song has poor audio quality. | 2011-05-15T21:20:57Z | RubenProducciones | blatle of banjos. read the description: friends can go to this link and give it a like, would help me a lot to back up videos like this :) http://www.youtube.com/watch?v=g1I7seXs6O4 | ["Banjo", "Country", "Music", "Musical instrument", "Plucked string instrument", "Bowed string instrument"] | ["violinists", "country music", "fiddlers", "child performers", "instrumental music", "guitar strumming", "country folk music", "live performance", "groovy rhythm", "country dance music", "the country life", "the wild west", "dance rhythm", "passionate", "emotional", "spirited", "never give up", "cheerful", "positive", "traditional music", "bad audio quality", "country bluegrass", "banjo", "medium tempo"] | 1 | O84YjlJ_Qw4 | 2402 | |
Taraful George Ness & Costel de la Bolintin 1.mp4 | The song is an instrumental. The tempo is medium fast with three accordions playing in harmony and virtuoso style , guitar strumming and other percussion instruments. The song is highly improvisational and has a bad audio quality with ambient room noises. | 2011-11-23T21:01:09Z | Taraful George Ness | tel :0768 174 804 George Ness | ["Traditional music", "Music", "Musical instrument", "Accordion"] | ["live music", "accordion players", "accordion harmony", "percussions playing rhythmically", "blues", "guitar strumming", "chaotic harmonies", "loud ambient room noise", "bad audio quality", "medium fast tempo", "walking bass style", "groovy music", "gypsy music", "improvisational music", "emotional", "spirited exciting", "instrumental music", "accordion virtuosos"] | 1 | t6XtW3SHQNE | 5006 |
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;