musiccaps_details (view)
4 rows where musiccaps_aspects contains "energetic crash cymbal" and musiccaps_aspects contains "passionate" sorted by youtube_published
This data as json, CSV (advanced)
musiccaps_aspects (array) 33 ✖
- energetic crash cymbal · 4 ✖
- passionate · 4 ✖
- shimmering hi hats 3
- groovy bass 2
- low quality 2
- noisy 2
- passionate male vocal 2
- piano chords 2
- punchy snare 2
- addictive 1
- buzzy synth lead melody 1
- emotional 1
- energetic 1
- energetic male vocal 1
- harmonizing background female vocals 1
- mellow bass 1
- mono 1
- playback 1
- punchy kick 1
- repetitive electric guitar melody 1
- rock 1
- romantic 1
- shimmering shakers 1
- short drums roll 1
- snappy snare 1
- soul/r&b 1
- soulful 1
- sustained strings melody 1
- thin kick hits 1
- toms roll 1
- wide acoustic rhythm guitar melody 1
- wide harmonizing vocals 1
- wide toms 1
musiccaps_names (array) 14 ✖
- Music 3
- Bass drum 1
- Drum 1
- Drum kit 1
- Drum roll 1
- Inside, large room or hall 1
- Musical instrument 1
- Percussion 1
- Rimshot 1
- Singing 1
- Ska 1
- Snare drum 1
- Soul music 1
- Yodeling 1
video | youtube_link | musiccaps_caption | youtube_published ▼ | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
x..FirstLady..x Not okay with change | The low quality recording features a wide harmonizing vocals singing over wide toms, groovy bass, punchy snare, energetic crash cymbal, thin kick hits and buzzy synth lead melody. It sounds passionate and addictive thanks to that synth lead. The recording is noisy. | 2007-04-02T12:17:54Z | Susan Harrison | FABB song :p | ["Drum", "Drum kit", "Drum roll", "Rimshot", "Snare drum", "Bass drum", "Percussion"] | ["low quality", "wide harmonizing vocals", "wide toms", "punchy snare", "groovy bass", "thin kick hits", "buzzy synth lead melody", "addictive", "passionate", "energetic crash cymbal", "noisy"] | 4 | ow12iGt8z5Q | 4667 | |
Disney On Ice 2009 Finale | The low quality recording features a live performance where the song is played on playback and it consists of sustained strings and piano melody, energetic crash cymbals, shimmering hi hats and toms roll, over which passionate male vocal and harmonizing background female vocals are singing. It sounds emotional, passionate and soulful. | 2009-06-03T19:22:38Z | Freya JW | Disney On Ice was preforming at the Target Center in Minneapolis on March 8th and I was able to go and Oh Em Gee, it was sooo purely magicaly like you don't even know. This video doesn't do it justice!! I was actually crying during this part. | ["Yodeling", "Music", "Inside, large room or hall"] | ["low quality", "mono", "noisy", "playback", "sustained strings melody", "toms roll", "shimmering hi hats", "energetic crash cymbal", "passionate male vocal", "harmonizing background female vocals", "piano chords", "emotional", "passionate", "soulful"] | 4 | bwHPVG6vbNQ | 3665 | |
Max Mutzke - Can´t Wait Until Tonight (official Video) | The Soul/R&B song features a passionate male vocal singing over shimmering hi hats, energetic crash cymbals, wide acoustic rhythm guitar melody, shimmering shakers, snappy snare, piano chords and mellow bass. It sounds passionate and romantic - like something you would sing to your partner. | 2010-01-25T11:53:51Z | Max Mutzke | Der Videoclip zu Can´t Wait Until Tonight von Max Mutzke. Mehr Max gibt es hier http://www.maxmutzke.de | ["Singing", "Music", "Musical instrument", "Soul music"] | ["soul/r&b", "passionate male vocal", "shimmering hi hats", "energetic crash cymbal", "wide acoustic rhythm guitar melody", "shimmering shakers", "snappy snare", "piano chords", "mellow bass", "passionate", "romantic"] | 4 | 5ZX9Ig7XXsw | 668 | |
Red Hot Chili Peppers - Nothing To Lose - B-Side [HD] | The Rock song features an energetic male vocal singing over repetitive electric guitar melody, groovy bass, punchy kick and snare, shimmering hi hats and energetic crash cymbal. There is a short drum roll that represents a variation in a repetitive loop. It sounds energetic and passionate. | 2011-07-31T19:54:18Z | llllphaserllll | "Nothing To Lose" is a live jam B-Side of the Red Hot Chili Peppers single "Can't Stop" from their 2002 album "By The Way". [HD VIDEOS] + RHCP Live in Koln 2011 - http://www.youtube.com/user/IIIIphaserIIII + RHCP B-Sides + Bonus Tracks - http://www.youtube.com/user/llllphaserllll + RHCP Live Off The Map - http://www.youtube.com/user/IIphaserII + RHCP Live at the BBC - http://www.youtube.com/user/Iphaserl + RHCP Live at Slane Castle - http://www.youtube.com/user/IlasterixIl + RHCP Live in Poland - http://www.youtube.com/user/lllasterixlll + RHCP Live in Red Square Moscow - http://www.youtube.com/user/llphaserll + Radiohead In Rainbows Live From The Basement - http://www.youtube.com/user/IIIphaserIII + Radiohead The King Of Limbs Live From The Basement - http://www.youtube.com/user/lllphaserlll + Radiohead TV Performances / Live At The Grammys - http://www.youtube.com/user/lIphaserlI + Radiohead HD Official Videos http://www.youtube.com/user/lphaserI Tags: Red Hot Chili Peppers Nothing To Lose Rare B-Side Bonus Track 2002 Can't Stop Single By The Way HD High Definition HQ Quality 1080p Anthony Kiedis Flea John Frusciante Chad Smith | ["Music", "Ska"] | ["rock", "energetic male vocal", "repetitive electric guitar melody", "groovy bass", "punchy snare", "punchy kick", "shimmering hi hats", "short drums roll", "energetic crash cymbal", "energetic", "passionate"] | 4 | 0EzWmAPwoTs | 137 |
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;