musiccaps_details (view)
3 rows where search matches "guitar", musiccaps_aspects contains "accordion melody", musiccaps_aspects contains "shimmering shakers" and musiccaps_author = 4
This data as json, CSV (advanced)
musiccaps_aspects (array) 28 ✖
- accordion melody · 3 ✖
- groovy bass 3
- shimmering shakers · 3 ✖
- 4 on the floor kick 2
- passionate male vocal 2
- 4 on the floor cowbell pattern 1
- acoustic rhythm guitar 1
- addictive 1
- boomy 1
- country 1
- emotional 1
- energetic open hats 1
- flat echoing male vocal 1
- folk 1
- fun 1
- happy 1
- low quality 1
- offbeat electric guitar chords 1
- passionate 1
- percussive elements 1
- poor mix 1
- regional mexican 1
- repetitive acoustic guitar chord 1
- soft crash cymbal 1
- soulful 1
- syncopated snare 1
- uplifting 1
- wide piano chords 1
musiccaps_names (array) 7 ✖
- Music 3
- Salsa music 2
- Afrobeat 1
- Country 1
- Music of Africa 1
- Reggae 1
- Singing 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
villa maipu en bus | The Folk song features a flat, echoing male vocal talking over addictive accordion melody, wide piano chords, groovy bass, "4 on the floor" kick pattern, tinny percussive elements, energetic open hats, shimmering shakers and offbeat electric guitar chords. It sounds uplifting and low quality. | 2009-12-20T01:34:44Z | 14Juampa | ["Afrobeat", "Music of Africa", "Music", "Reggae", "Salsa music"] | ["folk", "flat echoing male vocal", "accordion melody", "wide piano chords", "groovy bass", "4 on the floor kick", "percussive elements", "shimmering shakers", "energetic open hats", "offbeat electric guitar chords", "uplifting", "addictive", "low quality"] | 4 | b4FomUpNaJE | 3600 | ||
Javier Molina & Eldorado - Cowboy Cumbia (Official Music Video) | The Country song features a passionate male vocalist singing over accordion melody, groovy bass, layered "4 on the floor" kick and cowbell pattern, soft crash cymbal, shimmering shakers and acoustic rhythm guitar. It sounds fun and happy, even though the song is poorly mixed, as it sounds a bit boomy. | 2011-08-01T16:05:34Z | TejanoSA | Javier Molina & Eldorado performing Cowboy Cumbia (Official Music Video) © 1998 Javier Molina | ["Singing", "Music", "Salsa music"] | ["country", "passionate male vocal", "accordion melody", "groovy bass", "4 on the floor cowbell pattern", "acoustic rhythm guitar", "fun", "happy", "4 on the floor kick", "syncopated snare", "soft crash cymbal", "shimmering shakers", "poor mix", "boomy"] | 4 | bLjOJRg2P_Q | 3618 | |
El Rey - George Strait - Twang (George Sings SPANISH) | The Regional Mexican song features a passionate male vocal singing over repetitive acoustic guitar chord and groovy bass, after which there are shimmering shakers and accordion melody playing. It sounds passionate, emotional and soulful. | 2009-07-28T20:20:14Z | Frank Drebbin | That's right, first copy of the song.. and its GRAIT | ["Country", "Music"] | ["regional mexican", "repetitive acoustic guitar chord", "groovy bass", "passionate male vocal", "shimmering shakers", "accordion melody", "passionate", "emotional", "soulful"] | 4 | wt-f7K_suBc | 5291 |
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;