musiccaps_details (view)
3 rows where musiccaps_aspects contains "passionate male vocal", musiccaps_author = 4 and musiccaps_names contains "Disco"
This data as json, CSV (advanced)
musiccaps_aspects (array) 27 ✖
- passionate 3
- passionate male vocal · 3 ✖
- punchy kick 3
- punchy snare 3
- brass melody 2
- emotional 2
- energetic 2
- addictive 1
- claps 1
- disco 1
- funky 1
- groovy bass 1
- groovy bass guitar 1
- groovy toms 1
- harmonizing background vocals 1
- loud 1
- low quality 1
- piano melody 1
- pop 1
- rock 1
- shimmering cymbals 1
- shimmering hi hats 1
- shimmering shakers 1
- sustained strings melody 1
- synth pad 1
- upbeat 1
- wide electric guitars melodies 1
musiccaps_names (array) 3 ✖
- Disco · 3 ✖
- Music 3
- Soul music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Particles Like Planets - Out Of Reach (OFFICIAL Music Video) | The Rock song features a passionate male vocalist singing over wide electric guitar melodies, groovy bass guitar, shimmering cymbals, groovy toms, punchy snare and kick hits. It sounds energetic, passionate, emotional and loud. | 2011-11-06T00:52:20Z | Particles Like Planets | Particles Like Planets- http://www.facebook.com/particleslikeplanets If you want to help support us it is available on iTunes Music Video for "Out Of Reach" Artist: Particles Like Planets Album: The Owl In The Archer Director: Jaime Martinez Jaime Martinez- http://www.ilovegrafixphotography.com Credits: Band: Cody Vanhoozen, Tyler Shippy, Eric Boudreau, Mikey Tucker Film Credits: Jaime Martinez, Todd Mckernan, Jasmine Quail Location Credits: Daryl Shippy & Hemet Ryan Airport Label: Unsigned | ["Disco", "Music"] | ["rock", "punchy kick", "punchy snare", "groovy toms", "wide electric guitars melodies", "groovy bass guitar", "shimmering cymbals", "passionate male vocal", "energetic", "passionate", "emotional", "loud"] | 4 | 1QFli7KSXAQ | 270 | |
บาสโลบจังหวะดิสโก้ | The low quality recording features a pop song that consists of a passionate male vocal singing over punchy kick and snare hits, shimmering shakers, synth pad, groovy bass and brass melody. It sounds passionate, emotional, energetic and upbeat. | 2012-10-08T01:26:28Z | Tanwarat mu | เพลงนี้ใช่ท่าจังหวะบาสโลบที่ 3 ใช้เพลงจังหวะดิสโก้เป็นจังหวะที่สนุก ฝึกความจำและสมาธิในการเต้น | ["Disco", "Music"] | ["low quality", "pop", "punchy kick", "punchy snare", "groovy bass", "synth pad", "shimmering shakers", "passionate male vocal", "brass melody", "passionate", "emotional", "energetic", "upbeat"] | 4 | _x4a974Pl-A | 3500 | |
70's Disco Fever To 20 Songs | The Disco song features a passionate male vocal, alongside harmonizing background vocals, singing over sustained strings melody, piano melody, brass melody, punchy kick and snare hits, shimmering hi hats and some claps. It sounds funky, addictive and passionate - like something you would hear in clubs during the 70s. | 2010-08-16T05:53:04Z | djcrd09 | DJ CRD-These R My Top 20 Disco/Funk Groovin Songs..Enjoy..Hop U Like..Don't Forget 2 Subscribe And Comment djcrd09@yahoo.com | ["Disco", "Music", "Soul music"] | ["disco", "harmonizing background vocals", "passionate male vocal", "sustained strings melody", "piano melody", "brass melody", "punchy kick", "punchy snare", "shimmering hi hats", "claps", "funky", "addictive", "passionate"] | 4 | yzjbAxCnt7U | 5451 |
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;