musiccaps_details (view)
2 rows where musiccaps_aspects contains "bad audio quality" and musiccaps_aspects contains "folk music"
This data as json, CSV (advanced)
musiccaps_aspects (array) 38 ✖
- bad audio quality · 2 ✖
- folk music · 2 ✖
- medium tempo 2
- accordion accompaniment 1
- amateur singers 1
- calming 1
- cheerful 1
- comfort 1
- devotional 1
- emotional 1
- european instruments 1
- family singing 1
- festivities 1
- flute melody 1
- folk musicians 1
- folk singers 1
- forgotten traditional 1
- good old days 1
- guitar rhythm 1
- gypsy music 1
- high gain 1
- instrumental music 1
- latin percussion instruments 1
- male and female singers 1
- memdium tempo 1
- nostalgic 1
- olden days 1
- passionate 1
- poor audio quality 1
- soothing 1
- south american folk music 1
- traditional instruments 1
- traditional latin instruments 1
- traditional music 1
- traditional string bass instrument 1
- violin countermelody 1
- vocal harmony 1
- vocal unison 1
musiccaps_names (array) 6 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Tam w Gorlyciach - Lemko ( Лемко) ( Carpatho-Rusyn NOT Ukrainian!) | The song is an instrumental. The song is medium tempo with an accordion accompaniment, violin solo and a flute melody. The song is beautiful and nostalgic. The audio quality is poor. The song has an old gypsy soul to it. | 2009-12-12T22:29:21Z | kayetanowicz | Lemko soldier's song A lot of Lemko (Carpatho-Rusyn) people form an independent nation and we are officially recognized as one of the national minorities in some countries where we live ( Poland, Slovakia, Serbia). | ["Wind instrument, woodwind instrument", "Flute"] | ["instrumental music", "gypsy music", "medium tempo", "poor audio quality", "accordion accompaniment", "flute melody", "guitar rhythm", "european instruments", "memdium tempo", "bad audio quality", "folk music", "folk musicians", "nostalgic", "olden days", "forgotten traditional", "traditional instruments", "calming", "soothing", "good old days", "comfort"] | 1 | 0Wdh45yt7tY | 178 | |
😭♫ 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;