musiccaps_details (view)
4 rows where search matches "guitar" and musiccaps_aspects contains "latin" sorted by youtube_published
This data as json, CSV (advanced)
musiccaps_aspects (array) 42 ✖
- latin · 4 ✖
- latin dance 2
- acoustic guitar 1
- acoustic guitar solo 1
- autotuned background vocal harmonies 1
- bass guitar 1
- choir 1
- clap 1
- club track 16th note hi-hat 1
- complex chords 1
- cumbia 1
- dance 1
- distorted electric guitar lead 1
- electric guitar 1
- fast beat 1
- fast strumming acoustic guitar 1
- female harmonized vocals 1
- female vocal 1
- flamenco influence 1
- funk feel 1
- guiro 1
- hand claps 1
- hand percussion 1
- instrumental 1
- latin percussion 1
- lively 1
- low tuned bass drum 1
- male vocals 1
- modern electric bass 1
- passionate female singer 1
- piano 1
- playful 1
- quick tempo 1
- seductive singing 1
- simple kick/snare pattern 1
- synth string stabs 1
- tambourine 1
- tango 1
- thumping bass 1
- trumpets 1
- vigorous 1
- wah 1
musiccaps_names (array) 6 ✖
- Music 4
- Flamenco 1
- Music of Latin America 1
- Swing music 1
- Ukulele 1
- Zing 1
youtube_published (date) 4 ✖
- 2007-10-21 1
- 2010-03-05 1
- 2011-05-27 1
- 2011-07-15 1
video | youtube_link | musiccaps_caption | youtube_published ▼ | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Tango "Nostalgias" - (1/2) Argentine original - Charlo ! | This is an instrumental latin music piece. There is a rapidly-played acoustic guitar intro acting as a dance accompaniment. It has a lively atmosphere. This piece could be helpful in a latin dance course setting. | 2007-10-21T20:01:54Z | jurek46pink | "Nostalgias" - great composition of Argentine musician Juan Carlos Cobian to the poem by Enrique Cadicamo, from the moment of creation (mid 30s) has been an unique expression of a tango - usually sung or played far behind the standard rhythm. It seams that this refined music as well as lyrics did not need any beat base. Here -- one of the earliest recordings made by Charlo; Argentine singer of the period. | ["Music", "Ukulele"] | ["instrumental", "acoustic guitar", "latin", "tango", "latin dance", "vigorous"] | 9 | SU9ZP2pbqyU | 2769 | |
Pink-white sponge manicure - Nail Art Tutorial | A Latin club track with a thumping bass and a funky feel. The kick snare pattern is simple and the hi-hat is busy playing steady 16th notes. Distorted electric guitar plays a lead melody along with the autotuned harmonized male background vocals. The lead vocals feature a male and female duo singing in harmony, while synth strings fill in the beat with short chords. | 2010-03-05T11:50:33Z | camysh | This is a very easy to do design. Enjoy! *NO COPYRIGHT INTENDED PLEASE DO NOT REMOVE**I do not own this song: Inna feat. Play & Win - Nobody* http://www.camynails.blogspot.com/ | ["Music", "Zing"] | ["female harmonized vocals", "simple kick/snare pattern", "thumping bass", "clap", "autotuned background vocal harmonies", "distorted electric guitar lead", "latin", "club track 16th note hi-hat", "funk feel", "synth string stabs"] | 8 | eZE0RmJESFU | 3880 | |
( Rumba ) Parrita & Canelita " Remix " Dj Barajero | Latin music featuring a quick tempo, hand percussion, tambourine, lively hand claps, guiro, a low tuned bass drum, an acoustic guitar solo with a wah effect, flamenco inspired fast acoustic guitar strumming, complex chords and a modern electric bass sound supporting a passionate female singer. | 2011-05-27T11:41:49Z | DJ Barajero | Parrita Canelita Remix Dj Barajero Flamenco Rumba Salsa Reggueton Verano Nuevo 2011 2012 2013 | ["Flamenco", "Music", "Music of Latin America"] | ["latin", "low tuned bass drum", "lively", "electric guitar", "wah", "acoustic guitar solo", "hand percussion", "fast strumming acoustic guitar", "flamenco influence", "tambourine", "guiro", "passionate female singer", "complex chords", "fast beat", "modern electric bass", "hand claps", "quick tempo"] | 8 | YzpzKyzyL0Y | 3331 | |
ven a mi casa mama ( original ) HQ | This is a cumbia piece. There is a female vocal singing seductively joined by male back vocals singing in the chorus. The trumpet is playing the main melody joined by the piano and the bass guitar in the background. Latin percussion playing a cumbia beat provides the rhythmic background. The atmosphere of the piece is very playful. The ideal setting for this piece can be a latin dance course. | 2011-07-15T21:44:16Z | tecoloves | sonideros | ["Swing music", "Music"] | ["cumbia", "latin", "latin dance", "female vocal", "seductive singing", "male vocals", "choir", "latin percussion", "trumpets", "piano", "bass guitar", "playful", "dance"] | 9 | 7NnvEryyYdo | 840 |
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;