musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "latin" and musiccaps_author = 8 sorted by youtube_id
This data as json, CSV (advanced)
musiccaps_aspects (array) 26 ✖
- latin · 2 ✖
- acoustic guitar solo 1
- autotuned background vocal harmonies 1
- clap 1
- club track 16th note hi-hat 1
- complex chords 1
- distorted electric guitar lead 1
- electric guitar 1
- fast beat 1
- fast strumming acoustic guitar 1
- female harmonized vocals 1
- flamenco influence 1
- funk feel 1
- guiro 1
- hand claps 1
- hand percussion 1
- lively 1
- low tuned bass drum 1
- modern electric bass 1
- passionate female singer 1
- quick tempo 1
- simple kick/snare pattern 1
- synth string stabs 1
- tambourine 1
- thumping bass 1
- wah 1
musiccaps_names (array) 4 ✖
- Music 2
- Flamenco 1
- Music of Latin America 1
- Zing 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id ▼ | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
( 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 | |
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 |
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;