musiccaps_details (view)
3 rows where search matches "guitar", musiccaps_aspects contains "hollow" and musiccaps_author = 4
This data as json, CSV (advanced)
Suggested facets: youtube_published (date)
musiccaps_aspects (array) 26 ✖
- hollow · 3 ✖
- energetic 2
- low quality 2
- thin 2
- 4 on the floor kick pattern 1
- aggressive 1
- aggressive strumming 1
- clapping 1
- disco 1
- doubled flat male vocals 1
- energetic cymbals 1
- funky bass guitar 1
- funky electric guitar chords 1
- groovy bass guitar 1
- happy 1
- harsh 1
- heartbeat kick pattern 1
- loud 1
- mellow synth keys chords 1
- passionate echoing female vocal 1
- punchy snare 1
- rock 1
- shimmering hi hats 1
- uptempo acoustic rhythm guitar chord progression 1
- wide electric guitar chords 1
- wide harmonizing female vocals 1
musiccaps_names (array) 15 ✖
- Music 3
- Dance music 1
- Disco 1
- Grunge 1
- Guitar 1
- Heavy metal 1
- Independent music 1
- Musical instrument 1
- Plucked string instrument 1
- Pop music 1
- Progressive rock 1
- Psychedelic rock 1
- Punk rock 1
- Rock music 1
- Ukulele 1
youtube_description 3 ✖
- He'eia is an traditional Hawaiian song about the Kings favorite surfing spot. It was originally a chant that has been adapted to ukulele. Carl Ray VillaVerde plays both rhythm and lead in this version. He and wife Joannie form a duet called "Mango" and have produced a number of entertaining recordings. There is a site where downloads and CD's are available at http://cdbaby.com/cd/mangolilikoi 1
- This was a fun jingle that we did for the Hoover Empower Vacuum cleaner back in 2005. Kelly Derrick - vocals, Jim Simonian - Drums, Vocals, Ron Gregorcic - Guitars. 1
- otro videx! de la pump px! y uno muy weno! :D see! 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Pump It Up - Caution | The low quality recording features a disco song that consists of passionate female vocals and wide harmonizing female vocals singing over funky bass guitar, mellow synth keys chords, funky electric guitar chords, shimmering hi hats, clapping and "4 on the floor" kick pattern. It sounds funky and energetic, but also thin and hollow, due to the bad mixing. | 2006-04-14T17:42:36Z | Agustín Romero | otro videx! de la pump px! y uno muy weno! :D see! | ["Disco", "Music", "Pop music", "Dance music"] | ["low quality", "funky bass guitar", "disco", "passionate echoing female vocal", "wide harmonizing female vocals", "funky electric guitar chords", "mellow synth keys chords", "energetic", "shimmering hi hats", "clapping", "thin", "hollow", "4 on the floor kick pattern"] | 4 | 1a_nvi4sW64 | 290 | |
He'eia (Ukulele, Traditional Hawaiian Song) | The low quality recording features an acoustic rhythm guitar being aggressively strummed, while producing some happy sounding melodies. The guitar sounds a bit hollow, almost as if it is recorded with a phone. | 2007-02-20T21:09:49Z | Chris Brown | He'eia is an traditional Hawaiian song about the Kings favorite surfing spot. It was originally a chant that has been adapted to ukulele. Carl Ray VillaVerde plays both rhythm and lead in this version. He and wife Joannie form a duet called "Mango" and have produced a number of entertaining recordings. There is a site where downloads and CD's are available at http://cdbaby.com/cd/mangolilikoi | ["Guitar", "Music", "Musical instrument", "Ukulele", "Plucked string instrument"] | ["low quality", "uptempo acoustic rhythm guitar chord progression", "hollow", "loud", "aggressive strumming", "happy"] | 4 | mW5_chAgg8c | 4475 | |
Hoover EmPower Vacuum Jingle | The Rock song features a doubled flat male vocals singing over wide electric guitar chords, groovy bass guitar, energetic cymbals, punchy snare hits and heartbeat kick pattern. It lacks low frequencies, therefore it sounds thin, hollow and harsh, but regardless, also energetic and aggressive. | 2011-03-07T07:54:13Z | Jim Simonian | This was a fun jingle that we did for the Hoover Empower Vacuum cleaner back in 2005. Kelly Derrick - vocals, Jim Simonian - Drums, Vocals, Ron Gregorcic - Guitars. | ["Heavy metal", "Music", "Punk rock", "Independent music", "Psychedelic rock", "Rock music", "Progressive rock", "Grunge"] | ["rock", "wide electric guitar chords", "groovy bass guitar", "doubled flat male vocals", "energetic cymbals", "punchy snare", "heartbeat kick pattern", "harsh", "thin", "hollow", "aggressive", "energetic"] | 4 | qDiTICmdUQg | 4765 |
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;