musiccaps_details (view)
4 rows where search matches "guitar", musiccaps_aspects contains "easygoing" and musiccaps_names contains "Funk" sorted by youtube_id
This data as json, CSV (advanced)
musiccaps_aspects (array) >30 ✖
- easygoing · 4 ✖
- acoustic drums 2
- bass guitar 2
- chill 2
- electric guitar 2
- groovy 2
- groovy bass 2
- low quality 2
- male vocal 2
- rock 2
- shimmering hi hats 2
- american 1
- blues 1
- brass melody 1
- danceable 1
- female vocal 1
- funky electric guitar chords 1
- keyboard 1
- male back vocals 1
- melodic singing 1
- noisy 1
- passionate male vocals 1
- pop 1
- punchy kick 1
- punchy snare 1
- reggae 1
- repeated theme 1
- reverberant male vocal 1
- rock and roll 1
- short electric guitar chords 1
- …
musiccaps_names (array) 8 ✖
- Funk · 4 ✖
- Music 4
- Progressive rock 1
- Punk rock 1
- Reggae 1
- Rock music 1
- Song 1
- Soul music 1
youtube_published (date) 4 ✖
- 2007-08-17 1
- 2009-01-22 1
- 2011-04-23 1
- 2011-09-25 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id ▼ | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Afraid of Mice - Trans-parents | The low quality recording features a rock song that consists of reverberant male vocal singing over groovy bass, short electric guitar chords, punchy snare, soft kick hits, shimmering hi hats and soft crash cymbals. The reverb of the vocal is located in the right channel of the stereo image, which makes it sound interesting. It is easygoing and groovy. | 2011-09-25T11:40:58Z | exadaktylos | ["Funk", "Music", "Punk rock", "Rock music", "Progressive rock"] | ["low quality", "noisy", "rock", "reverberant male vocal", "groovy bass", "shimmering hi hats", "soft crash cymbal", "punchy snare", "soft kick hits", "short electric guitar chords", "easygoing", "groovy"] | 4 | 4refolVb_uQ | 610 | ||
MITCH RIDER & the DETROIT WHEELS - BREAKOUT | This is a rock and roll music piece. There is a male vocal singer singing as the lead while other back vocals sing rhythmic back vocals at a higher pitch than the lead. An electric guitar is playing a simple and repeated tune while there is a bass guitar in the background. The acoustic drums are playing a basic 4/4 rock beat with claps simultaneous with the snare hits. There is an easygoing atmosphere in this piece. It could be playing in the background of a rock bar. This piece could also work well in sports venues. | 2011-04-23T15:20:22Z | PaulGTSE | MITCH RIDER & the DETROIT WHEELS with BREAKOUT on the UK PYE DISCO DEMAND LABEL 100mph NORTHERN SOUL | ["Funk", "Music", "Soul music"] | ["rock and roll", "blues", "male vocal", "male back vocals", "electric guitar", "bass guitar", "acoustic drums", "american", "repeated theme", "simple tune", "easygoing", "groovy"] | 9 | GQbUpJFArKI | 1720 | |
Roots Reggae Mix | The low quality recording features a reggae song that consists of passionate male vocals singing over shimmering hi hats, snappy snare, punchy kick, groovy bass, brass melody and funky electric guitar chords. It sounds chill and easygoing. | 2009-01-22T20:42:39Z | lessofslack | A roots reggae mix with horace andy, meditations, congos max romeo, hugh mundell, king tubby! Enjoy Reggae Roots! THE PLAYLIST IS HERE!!!! 1.The Meditations - Rasta Shall Conquer(Greatest Hits 197X)--- 2. Dr Alimantado - Born For a Purpose 3.Dennis Brown - Black Liberation(Words Of Wisdom1979)--- 4.Max Romeo & The Upsetters - My Jamaican Collie(The Coming Of Jah 1967-76)--- 5.Horace Andy - If I(In The Light/In The Light Dub 1977)--- 6.Hugh Mundell - Jah Will Provide(Africa Must Be Free 1983)--- 7.i forgot - update in a few weeks--- 8.The Terrors - Assemble Not Thyself(The Chantells & Friends-Children Of Jah 1977-79)--- 9.Horace Andy - Do You Love My Music(In The Light/In The Light Dub 1977)--- Thanks to all supporters of good old Reggae Tunes! -peace- | ["Funk", "Music", "Reggae", "Song"] | ["low quality", "reggae", "passionate male vocals", "shimmering hi hats", "snappy snare", "groovy bass", "brass melody", "funky electric guitar chords", "punchy kick", "easygoing", "chill"] | 4 | L0-l1LIa22g | 2141 | |
Junior Senior - "Can I Get Get Get" Crunchy Frog/Rykodisc | This is a pop music piece with an early 2000s feel. There is one male and one female vocalist singing melodically. The melody is being played by the electric guitar and the keyboard guitar with the bass guitar in the background. The rhythm is provided by the acoustic drums with occasional clap sounds. The atmosphere is easygoing and danceable. This piece could be used in the soundtrack of a sit-com movie or a TV show. | 2007-08-17T04:41:59Z | BlankTV | Like this video? Come see thousands more at the Net's biggest, uncensored, completely d.i.y. punk, hardcore, indie and alternative music video site, BlankTV.com! We've got News, Games, Contests and the stuff that we can't show on YouTube! Free! Uncensored! Triggered! BlankTV.com! Director: Jeppe Laursen & Humberto Flores http://www.itunes.com/juniorsenior | ["Funk", "Music"] | ["pop", "rock", "male vocal", "female vocal", "melodic singing", "electric guitar", "keyboard", "bass guitar", "acoustic drums", "chill", "easygoing", "danceable"] | 9 | YB_PzRgHOeo | 3263 |
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;