musiccaps_details (view)
5 rows where search matches "guitar", musiccaps_aspects contains "e-bass" and musiccaps_aspects contains "upbeat" sorted by youtube_description
This data as json, CSV (advanced)
musiccaps_aspects (array) 26 ✖
- e-bass · 5 ✖
- e-guitar 5
- upbeat · 5 ✖
- acoustic drums 4
- piano 2
- accordion 1
- acoustic drums/percussion's 1
- afrodance/funk 1
- background cheering 1
- brass section 1
- cuban ska 1
- energetic 1
- female voice singing 1
- good vibrations 1
- hindi/pop 1
- hiphop/breakbeats 1
- male voice high register singing 1
- male voice singing 1
- organ 1
- percussion's 1
- positive vibe 1
- rock 1
- saxophones 1
- tambourine 1
- trumpets 1
- uplifting energy 1
musiccaps_names (array) 12 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description ▼ | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Hum Bhi Agar Bachhe Hote - Hindi Animation Song for kids @JingleToons | Drums and percussion are playing a groove that animates to dance along with a bassline. In the background you can hear a clean e-guitar strumming chords. A male voice is singing in a higher register and an accordion ends the phrase with a short and fast melody. This song may be playing at a kids party. | 2013-11-28T08:35:43Z | Jingle Toons | #HumBhiAgarBachche #SongForKids #JingleToons Hum Bhi agar bachhe hote is an animation song based on a popular Hindi song. This animated version is brought to you by Jingle Toons. | ["Jingle (music)", "Music", "Music of Bollywood"] | ["hindi/pop", "e-guitar", "e-bass", "acoustic drums/percussion's", "accordion", "male voice high register singing", "positive vibe", "upbeat"] | 6 | EKZvq0dUk50 | 1545 | |
Ska Cubano - Identity | This audio contains acoustic drums playing something like a reggae groove along with an e-bass. A e-guitar strumming chords, piano, organ saxophones and trumpets are playing a short melody on the backbeat giving this song its reggae feeling. In-between the instruments are playing a short loud melody to break into the next part. The instruments are spread across the sides of the speakers. This audio may be playing in an urban coffee shop. | 2011-05-16T22:21:47Z | Eder Eulogio | Canción del disco Mambo Ska de esta banda de nacionalidades múltiples y que ha resaltado la cultura musical de dos islas caribeñas como lo son Cuba y Jamaica..... Disfruten, Comenten y Suscríbanse!!!!!!!!!!!!!! | ["Wind instrument, woodwind instrument", "Accordion"] | ["cuban ska", "e-guitar", "trumpets", "saxophones", "organ", "piano", "acoustic drums", "e-bass", "upbeat", "energetic"] | 6 | nW6Naj6eeI4 | 4547 | |
Jekujo - Chicago Afrobeat Project (5.7.09.A5) | This song is full of fast paced rhythm being played by percussion and a drumset. An e-guitar is playing a fast repeating melody with little changes along with an e-piano playing chords and melody. The e-bass is playing a groove along with the drums that sounds inviting to dance along. In the background you can hear voices cheering. This song may be playing live. | 2009-06-19T23:35:10Z | TheFoxTheatre | Garrick Smith: Baritone Sax, Angelo Garcia: Tenor Sax, Kevin Martinez: Bass, Kevin Ford: Keys, David Glines: Guitar, Ricardo Gonzalez: Drums, Chris Paquette: Precussion, w/ guest dancers: Geogina Kolber, Tara Vellinga, Jay Sayler: Sound Lighting: Your Name Here, Thomas Lofstrom: Video thx to Colin Petterson, The Fox Theatre, Boulder | ["Swing music", "Music", "Ska", "Music of Latin America", "Salsa music"] | ["afrodance/funk", "e-guitar", "e-bass", "acoustic drums", "percussion's", "background cheering", "piano", "upbeat", "good vibrations"] | 6 | dkGXJ6BlCd4 | 3810 | |
The Prodigy - Hot ride | The acoustic drums are playing a groove with crash hits and a bass that sounds distorted while a female voice is singing. Then a male singer with an effect on his voice is almost screaming while an e-guitar is playing a melody. This song may be playing in a rock&roll bar. | 2012-05-29T15:19:17Z | Vegeta | The Prodigy: Hot ride | ["Music", "Angry music"] | ["rock", "e-guitar", "e-bass", "acoustic drums", "female voice singing", "male voice singing", "upbeat"] | 6 | hSK405L-DlQ | 4105 | |
Stereo Mcs- The Runaway | This song contains a acoustic drums running through a filter playing along with a tambourine. A e-guitar is playing a short repeating melody. A e-bass is first playing with a effect and then clean when a brass section comes in. This song may be playing with headphones while running on a sunny day. | 2009-04-15T16:41:52Z | Brescianogb | This is a track form the Stereo Mcs "Hotplate" EP, released on 01.05.2008. I think this is their greatest work for the last 9 years! If you like it, buy it from here: https://www.beatport.com/en-US/html/content/release/detail/108456/Hotplate | ["Electronic music", "Music", "Scratch"] | ["hiphop/breakbeats", "e-bass", "e-guitar", "acoustic drums", "tambourine", "brass section", "upbeat", "uplifting energy"] | 6 | Yz1DrC54UGk | 3330 |
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;