musiccaps_details (view)
2 rows where musiccaps_aspects contains "folk music" and musiccaps_names contains "Pizzicato"
This data as json, CSV (advanced)
musiccaps_aspects (array) 39 ✖
- emotional 2
- folk music · 2 ✖
- acoustic guitar 1
- amateur singers 1
- ambient street noises 1
- bad audio quality 1
- cheerful 1
- devotional 1
- exciting 1
- family singing 1
- fast harp passages 1
- fast tempo 1
- fats harp playing 1
- festivities 1
- folk singers 1
- groovy rhythm 1
- harpist 1
- high gain 1
- high gain recording 1
- instrumental duet 1
- latin dance music 1
- latin folk music 1
- latin percussion instruments 1
- male and female singers 1
- male singer 1
- medium tempo 1
- passionate 1
- poor audio quality 1
- rhythm guitar 1
- romantic 1
- south american folk music 1
- talented duo 1
- traditional latin instruments 1
- traditional music 1
- traditional string bass instrument 1
- violin countermelody 1
- vocal harmony 1
- vocal unison 1
- youthful 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
El karma - abraham gonzalez | A male singer sings this Latin dance melody. The tempo is fast with a harpist playing fast passages with an acoustic guitar strumming rhythm. The song is emotional and energetic. The audio quality is bad with ambient Street noises and high gain. | 2014-10-31T22:33:27Z | Abraham Gonzalez | Abraham gonzalez y flavio vega esperemos le guste amigos dios los vendiga siempre...!! | ["Harp", "Pizzicato"] | ["harpist", "acoustic guitar", "fast harp passages", "talented duo", "instrumental duet", "rhythm guitar", "fast tempo", "folk music", "latin folk music", "fats harp playing", "exciting", "romantic", "poor audio quality", "high gain recording", "youthful", "latin folk music", "latin dance music", "groovy rhythm", "emotional", "ambient street noises", "male singer"] | 1 | A2pgKzeDRqg | 1062 | |
😭♫ DESPACHO en CUMPLEAÑOS 🍸 con ARPA y VIOLIN 🎻🎼 | Male and female singers sing together in vocal unison. The song is medium tempo with a violin playing countermelody, along with a traditional string bass rhythm and percussion instruments. The song is South American folk music with a lot of passion. The song audio quality is bad with high gains all over. | 2015-03-27T20:37:09Z | edgar gutierrez | Cantando despacho en cumpleaños despidiendo a los compadres hasta el proximo año. Gracias por tu visita, si te gustó presiona👍 y recuerda Suscribirte✍ a nuestro Canal para estar al tanto de cada Video Nuevo.✅ ◦◦◦◦◦◦◦◦◦◦◦◦◦◦◦◦◦◦◦◦◦◦◦◦◦◦◦◦◦◦◦◦◦◦◦◦◅❖▻◦◦◦◦◦◦◦◦◦◦◦◦◦◦◦◦◦◦◦◦◦◦◦◦◦◦◦◦◦◦◦◦◦◦◦◦ ❀ Despedida 🎻🎶 "100 % de Cumpleaños. ► Cumpleaños feliz con arpa y Violin ✔ ► Arpa: Adito de Puquio ✔ ► Violin: Misti de Chipao ✔ #Suscribete♥ #Descargagratis✔ #Comparte ◦◦◦◦◦◦◦◦◦◦◦◦◦◦◦◦◦◦◦◦◦◦◦◦◦◦◦◦◦◦◦◦◦◦◦◦◅❖▻◦◦◦◦◦◦◦◦◦◦◦◦◦◦◦◦◦◦◦◦◦◦◦◦◦◦◦◦◦◦◦◦◦◦◦◦ Servicio de Filmación y Fotografía en Lima y provincias. Con tu amigo Edgar Gutierrez. ☎ 997716824 Facebook: ➣ https://www.facebook.com/edgar.gutierrez.71653 ➣ https://www.facebook.com/produccionesasuncion/ Wasapp: ➤ 997716824 ✔ ══════════════════✽═══════════════════ ➤ Asunción Producciones Ⓡ ™➥ "Pasión por Nuestras Costumbres" ✔✔✔ 💬Dejenos sus comentarios y sugerencias estaremos gustosos de responder... 👍 ══════════════════✽═══════════════════ | ["Harp", "Violin, fiddle", "Pizzicato", "Bowed string instrument"] | ["male and female singers", "traditional latin instruments", "high gain", "violin countermelody", "folk music", "folk singers", "bad audio quality", "south american folk music", "cheerful", "emotional", "festivities", "passionate", "devotional", "family singing", "medium tempo", "vocal harmony", "vocal unison", "traditional music", "traditional string bass instrument", "amateur singers", "latin percussion instruments"] | 1 | I11AcD1sGes | 1864 |
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;