musiccaps_details (view)
5 rows where search matches "guitar", musiccaps_aspects contains "foreign language" and musiccaps_author = 0 sorted by youtube_published
This data as json, CSV (advanced)
Suggested facets: youtube_published (date)
musiccaps_aspects (array) 32 ✖
- foreign language · 5 ✖
- male voice 4
- happy mood 2
- live recording 2
- moderate tempo 2
- no percussion 2
- simple percussion 2
- alternative rock 1
- amateur recording 1
- bass 1
- celebration song 1
- disco song 1
- fast guitar strums 1
- fast tempo 1
- female voice 1
- funk bass 1
- guitar 1
- guitar song 1
- guitar strums 1
- hand claps 1
- low quality recording 1
- minimal instruments 1
- organ 1
- romantic theme 1
- slow tempo 1
- spanish rock 1
- stringed instrument 1
- synth string backing 1
- tenor guitar 1
- trumpets 1
- upbeat 1
- vocal harmony 1
musiccaps_names (array) 10 ✖
- Music 5
- /t/dd00003 1
- Independent music 1
- Jingle (music) 1
- Mandolin 1
- Musical instrument 1
- Pop music 1
- Punk rock 1
- Rattle (instrument) 1
- Ska 1
video | youtube_link | musiccaps_caption | youtube_published ▼ | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Remigio Fuentes_Joropo y Estribillo con Mónico Márquez | This song is a low quality live recording. This features an older female voice singing the main melody. This is accompanied by a tenor guitar playing two chords in a repeated rhythm. A male voice sings a fill after a line by the female voice. There is no percussion in this song. There are no other instruments. This is a celebration song sung in a foreign language. | 2009-05-25T20:10:09Z | Escucha Joropo | Joropo Tradicional del Oriente Venezolano. Remigio Fuentes popularmente conocido como "Morocho Fuentes" es extraordinario en la ejecución de La Mandolina con un alto dominio en la interpretación del Joropo con Estribillo. Músico del estado Sucre. Posee la gran jocosidad que caracteriza al oriental. Disfruta con mucha humildad de su música y de la compañía de sus coterráneos. Celebramos su amistad | ["Music", "Mandolin", "Musical instrument", "Rattle (instrument)"] | ["live recording", "low quality recording", "foreign language", "female voice", "stringed instrument", "tenor guitar", "no percussion"] | 0 | nb_7c2xPKYA | 4562 | |
Joseph Gordon-Levitt singing "La Valse à Mille Temps" (SitC) | This amateur recording features a male voice. This is accompanied by an electric guitar. The notes of the chords are first plucked and the chord is struck once. There is no percussion and no other instruments in this song. This is a slow tempo song. The mood of this song is romantic. | 2010-08-31T06:47:59Z | winegodof | Joseph Gordon-Levitt singing Jacques Brel's "La Valse à Mille Temps" at hitRECord.org's second Summer in the City show. | ["Music", "/t/dd00003"] | ["amateur recording", "guitar song", "male voice", "no percussion", "slow tempo", "foreign language", "minimal instruments", "live recording", "romantic theme"] | 0 | 3otUlQ4wvLY | 505 | |
Moltheni - Gli anni del malto | This alternative rock song features a male voice singing in a foreign language. This is accompanied by a percussion playing a simple beat with a compound time signature of 6/8. An acoustic guitar strums chords in the background. An electric guitar plays two note licks. The bass plays the root note and fifth of the chords. The mood of this song is melancholic. This is a moderate tempo song. This song can be played in a movie scene involving a long drive on the highway at night. | 2013-10-11T18:21:49Z | Josef K. | Tratto dall'album "I Segreti del Corallo" (La Tempesta). | ["Music", "Punk rock", "Independent music"] | ["alternative rock", "male voice", "guitar", "bass", "simple percussion", "moderate tempo", "foreign language"] | 0 | t12O05LVSBA | 4997 | |
Inspector - Me Estoy Enamorando (Video Oficial) | This Spanish rock song features a male voice singing the main melody. This is accompanied by rock percussion playing a simple beat. The bass plays the root notes of the chords. A guitar strums chords with upstrokes. A trumpet, saxophone and trombone plays fills in between verses. An organ pays fills at every alternate count. The mood of this song is happy and upbeat. This song can be played in a comedy movie. | 2014-05-14T20:37:22Z | Inspector Oficial | EL PRIMER SENCILLO DEL DISCO "SKA A LA CARTA" Escucha a Inspector en todas las plataformas digitales: https://ONErpm.lnk.to/inspector Escucha la playlist Mucho Ska https://ONErpm.lnk.to/MuchoSka | ["Music", "Ska"] | ["spanish rock", "fast guitar strums", "organ", "trumpets", "simple percussion", "male voice", "fast tempo", "happy mood", "foreign language"] | 0 | oswsd_r-GI8 | 4660 | |
4545 - Duarte Nogueira | This disco song features male voices singing the main melody in harmony. This is accompanied by programmed percussion playing a simple beat. The bass plays funk style bass notes. A synth plays a string voice in the background with short bursts of chords. After the first line, a guitar strum is played. This song is uptempo and has a happy mood. This song can be played in a celebratory event. | 2014-08-21T16:25:06Z | Duarte Nogueira | Jingle da campanha do deputado federal Duarte Nogueira! | ["Jingle (music)", "Music", "Pop music"] | ["disco song", "male voice", "vocal harmony", "foreign language", "funk bass", "guitar strums", "hand claps", "happy mood", "synth string backing", "upbeat", "moderate tempo", "celebration song"] | 0 | yPzhMx3NPW4 | 5407 |
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;