musiccaps_details (view)
13 rows where musiccaps_aspects contains "groovy", musiccaps_aspects contains "groovy bass" and musiccaps_aspects contains "passionate"
This data as json, CSV (advanced)
musiccaps_aspects (array) >30 ✖
- groovy · 13 ✖
- groovy bass · 13 ✖
- passionate · 13 ✖
- low quality 11
- punchy kick 9
- shimmering hi hats 7
- funky 5
- live performance 5
- punchy snare 5
- disco 3
- flat male vocal 3
- funky electric guitar melody 3
- noisy 3
- passionate female vocal 3
- claps 2
- electric guitar melody 2
- energetic 2
- jazz 2
- passionate male vocal 2
- shimmering cymbals 2
- accordion melody 1
- addictive 1
- clapping 1
- cool 1
- country blues 1
- crowd chattering 1
- crowd cheering 1
- crowd singing 1
- dissonant brass stabs 1
- electric guitar chords 1
- …
musiccaps_names (array) 26 ✖
- Music 11
- Singing 4
- Ska 4
- Funk 3
- Music of Latin America 3
- Rhythm and blues 3
- Music of Asia 2
- Accordion 1
- Blues 1
- Country 1
- Electric piano 1
- Electronic music 1
- Electronic organ 1
- Exciting music 1
- Keyboard (musical) 1
- Musical instrument 1
- Opera 1
- Orchestra 1
- Organ 1
- Piano 1
- Pop music 1
- Salsa music 1
- Speech 1
- Swing music 1
- Techno 1
- Traditional music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
El Pali - De Agujeritos! | The low quality recording features a regional Mexican song that consists of harmonizing male vocals singing over wide, bouncy wooden percussion, wide acoustic rhythm guitar, groovy bass, punchy kick and strings melody. It sounds passionate, energetic and groovy. | 2009-02-08T22:49:27Z | frager046 | ["Music", "Ska"] | ["regional mexican", "low quality", "wide bouncy wooden percussion", "wide acoustic rhythm guitar", "harmonizing male vocals", "groovy bass", "punchy kick", "strings melody", "passionate", "energetic", "groovy"] | 4 | 3rbWoeUg9yo | 508 | ||
Devil in Disguise | The low quality features a rock song that consists of a muffled passionate male vocal singing over wide acoustic rhythm guitars chords, shimmering cymbals, punchy kick and groovy bass. It sounds addictive, passionate and groovy - like something you would hear in pubs and bars during the 50s. | 2009-07-27T16:11:01Z | autopeerke | ["Music", "Rhythm and blues", "Ska"] | ["low quality", "rock", "muffled passionate male vocal", "wide acoustic rhythm guitars", "shimmering cymbals", "punchy kick", "groovy bass", "passionate", "addictive", "groovy"] | 4 | 9UOPRQhNzQ8 | 1014 | ||
Samuel Rossi Orchestra Ringo Story Goleada polka | The low quality recording features a live performance of a folk song that consists of an accordion melody playing over groovy bass, shimmering hi hats, punchy snare and electric guitar melody. There are crowd chattering noises in the background. It sounds passionate and groovy. | 2009-07-03T12:40:13Z | Tuttofisa | Samuel Rossi Orchestra Ringo Story Goleada polka | ["Singing", "Traditional music", "Music", "Musical instrument", "Orchestra", "Speech", "Music of Latin America", "Accordion"] | ["low quality", "live performance", "crowd chattering", "folk", "groovy bass", "accordion melody", "electric guitar melody", "shimmering hi hats", "punchy snare", "passionate", "groovy"] | 4 | ChqJYrmQIN4 | 1394 | |
Brian Auger - Compared to what (Live at Baked Potato) | The low quality recording features a live performance of a jazz song and it consists of a groovy bass guitar, groovy rhodes keys, electric guitar melody, shimmering hi hats, punchy kick and punchy snare hits. It sounds groovy, funky and passionate. The recording is noisy and in mono. | 2011-11-22T14:17:10Z | Bluedreams | The Brian Auger's Oblivion express live at "Baked Potato", Hollywood 2004. The Band is: Brian Auger - Hammond Organ, Keyboards and Electric piano Savannah Grace Auger - Vocals Derek Frank - Bass Karma D. Auger - Drums | ["Organ", "Electric piano", "Electronic organ", "Keyboard (musical)", "Piano"] | ["low quality", "jazz", "live performance", "mono", "noisy", "groovy bass", "groovy rhodes keys melody", "electric guitar melody", "shimmering hi hats", "punchy kick", "punchy snare", "funky", "groovy", "passionate"] | 4 | CrkxrgTiVyk | 1410 | |
Voltio - Medley De Salsa Carcelaria (Video En Vivo Desde Oso Blanco) | The low quality recording features a live performance of an urban latin song that consists of flat male vocal singing over groovy piano melody, groovy bass guitar, wooden percussive elements, wide toms, warm brass melody and widely spread claps. There is a short, exciting background male vocal in the middle of the loop. It sounds exotic, groovy and passionate. | 2009-11-24T21:07:11Z | VoltioVEVO | Music video by Voltio performing Medley De Salsa Carcelaria. (C) 2008 SONY BMG MUSIC ENTERTAINMENT (US Latin) LLC YouTube view counts pre-VEVO: 878 | ["Singing", "Music", "Music of Latin America", "Salsa music"] | ["low quality", "live performance", "urban latin", "wooden percussive elements", "wide toms", "warm brass", "groovy piano melody", "groovy bass", "flat male vocal", "wide claps", "passionate", "exotic", "groovy", "exciting background male vocal"] | 4 | FEuXIeWoCQQ | 1628 | |
70s Disco Hits - A Video Compilation of Disco Music from the 70's | The Disco song features a passionate male vocalist singing over funky electric guitar melody, groovy bass, punchy kick and snare hits, shimmering hi hats and groovy synth keys melody. It sounds groovy, funky and passionate. | 2008-11-27T00:42:17Z | TheGreat70s | Song List w/ Full Videos : https://thegreat70s.com/Song-List-70s-Disco-Hits.html 70 Disco Music Video Station: https://thegreat70s.com/music-video-stations/ Video Description: A medley of video clips of Disco music from the 70s. For more great 70s videos visit https://www.thegreat70s.com | ["Music", "Rhythm and blues"] | ["disco", "passionate male vocal", "funky electric guitar melody", "groovy bass", "punchy kick", "punchy snare", "shimmering hi hats", "groovy synth keys melody", "passionate", "groovy", "funky"] | 4 | JlzlNpttvVM | 2031 | |
Fifth Element - Techno opera | The low quality recording features a passionate female vocalist singing over dissonant brass stabs, groovy bass, wooden snare hits, synth pad chords, punchy kicks and shimmering hi-hats. It sounds groovy and passionate. | 2010-05-17T19:22:17Z | 1kRaFt (KRAFTWIN) | Fifth Element - Techno opera. Original: Performed by Inva Mula. Composed and Produced by Eric Serra. More: http://www.imdb.com/title/tt0119116/soundtrack | ["Electronic music", "Music", "Opera", "Techno"] | ["low quality", "dissonant brass stabs", "groovy bass", "passionate female vocal", "wooden snare hits", "punchy kick", "shimmering hi hats", "groovy", "passionate", "synth pad chords"] | 4 | WE0JqjuhaQI | 3076 | |
PUFF DADDY & FAITH feat. 112 - ILL BE MISSING YOU | The low quality recording features a live performance of a pop song that consists of flat male vocal talking, passionate female vocal, alongside harmonizing wide female vocals, singing over punchy kick and snare hits, shimmering hi hats and groovy bass. There are crowd singing and cheering sounds in the background. It sounds groovy, emotional, energetic and passionate. | 2009-06-24T16:34:33Z | PaulP | I'll Be Missing You by Puff Daddy (Dedicated to Notorious B.I.G.) (Puff) Seems like yesterday we used to rock the show I lace the track you lock the flow So far from hanging on the block of dough Notorious they got to know that Life ain't always as it seem to be Words can't express what you mean to me And though you're gone We still a team Through your family I'll fulfill your dreams In the future can't wait to see If you'll open up the gates for me Remenice sometime The night they took my friend Try to black it out but it plays again When it's weird feelin' it's really hard to conceil Can't imagine all the pain I feel Give everything to hear half your breath I know you still livin' your life after death CHORUS: (Faith) Every step I take Every move I make Every single day Every time I pray I'll be missing you Thinking of the day When you went away What a life to take What a bond to break I'll be missing you (Puff) It's kind of hard wit you not around Know you in heaven smilin' down Watchin' us while we pray for you Everyday we pray for you Till the day we meet again In my heart is where I'll keep you friend Memories give me the strength I need to proceed Strength I need to believe My thoughts big I just can't define Wish I could turn back the hands of time Bust in the 6 Shop for new clothes and kicks You and me taking flicks Making hits stages they receive you on Still can't believe you're gone Give anything to hear half your breath I know you still livin' your life after death CHORUS: (Faith) Every step I take Every move I make Every single day Every time I pray I'll be missing you Thinking of the day When you went away What a life to take What a bond to break I'll be missing you some glad morning When this life is over I know I'll see your face CHORUS (112) x4 Every night I pray E… | ["Singing", "Music of Asia", "Music"] | ["pop", "low quality", "live performance", "flat male vocal", "passionate female vocal", "wide harmonizing vocals", "punchy kick", "punchy snare", "shimmering hi hats", "groovy bass", "crowd cheering", "crowd singing", "energetic", "groovy", "emotional", "passionate"] | 4 | XILyHZyyCik | 3174 | |
Blues, Country Blues, Rhythm & Blues | The low quality recording features a country blues song that consists of fruity male vocal singing over groovy electric guitar melodies, groovy bass, shimmering cymbals, mellow snare, soft kick hits and clapping. The recording is a bit noisy, as it is vintage, and it sounds passionate, groovy, uptempo and cool. | 2010-06-04T21:51:03Z | StrontiumDawg | 3 fine slices of blues music. Got my mojo workin' - Muddy Waters, Frankie - Missisipi John Hurt, Crawling up a hill - John Mayall | ["Blues", "Singing", "Swing music", "Country", "Music", "Rhythm and blues", "Music of Latin America"] | ["low quality", "country blues", "vintage", "noisy", "fruity male vocal", "groovy electric guitar melodies", "groovy bass", "shimmering cymbals", "mellow snare", "soft kick hits", "clapping", "uptempo", "groovy", "passionate", "cool"] | 4 | ZzyWbehtt0M | 3433 | |
Jon Cleary - When You Get Back (Live at Jazz Fest 2007) | The low quality recording features a live performance of a jazz song that consists of a wide passionate, harmonizing male vocals singing over punchy snare and kick hits, shimmering hi hats, groovy bass guitar, synth pad and funky electric guitar melody. It sounds funky, groovy and passionate. | 2009-04-24T23:01:22Z | Jon Cleary | Jon Cleary live at the New Orleans Jazz & Heritage Festival Follow Jon https://www.facebook.com/jonclearymusicofficial/ https://www.instagram.com/jonclearymusic/ https://twitter.com/jonclearymusic http://www.bandsintown.com/JonCleary | ["Ska"] | ["low quality", "noisy", "jazz", "live performance", "synth pad", "groovy bass", "funky electric guitar melody", "wide passionate harmonizing male vocals", "punchy kick", "punchy kick", "shimmering hi hats", "funky", "groovy", "passionate"] | 4 | _y07ENAx2_E | 3503 | |
A Love I Can Feel Riddim (26 songs) - Beres, Sanchez, Frankie Paul, Busy Signal, etc. | The low quality recording features a passionate male vocal, alongside harmonizing background vocals, singing over tinny snares, snappy rimshots, shimmering hi hats, groovy bass and electric guitar chords. It sounds groovy and passionate. | 2012-05-24T15:52:14Z | DJ Riddim | Timeless lover's rock riddim Facebook – https://www.facebook.com/DJRiddimNYC?ref=hl Instagram - http://instagram.com/djriddim_ Twitter – https://twitter.com/DJRiddim_ | ["Music of Asia", "Funk", "Music", "Pop music", "Ska"] | ["low quality", "passionate male vocal", "harmonizing background vocals", "tinny snare", "shimmering hi hats", "snappy rimshot", "groovy bass", "electric guitar chords", "groovy", "passionate"] | 4 | c-85TtcfVSI | 3672 | |
Sick Funk Jam! Hug Me Squeeze Me! | The Disco song features a passionate female vocalist singing over a funky electric guitar melody, groovy bass, punchy kick and claps. It sounds passionate, funky and groovy - like something you would hear in clubs during the 80s. | 2010-06-21T23:33:22Z | turtle101392 | Debra Hurd- Hug me Squeeze Me | ["Funk", "Music", "Exciting music"] | ["disco", "low quality", "passionate female vocal", "funky electric guitar melody", "groovy bass", "punchy kick", "claps", "passionate", "funky", "groovy"] | 4 | lXrypwLQO3U | 4406 | |
*Classy Freak* | The Disco song features a flat male vocal singing over a wide funky electric guitar melody, groovy bass, synth keys chords, funky synth lead melody, punchy kick, punchy snare layered with some claps and simple hi hats. It sounds passionate, funky and groovy. | 2008-06-22T21:32:10Z | IwYlAj | PLAIR 1984 Label: P.A.R. | ["Funk", "Music"] | ["disco", "wide funky electric guitar melody", "synth keys chords", "funky synth lead melody", "groovy bass", "punchy kick", "punchy snare", "simple hi hats", "claps", "flat male vocal", "passionate", "funky", "groovy"] | 4 | p8xxC2um9xQ | 4688 |
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;