musiccaps_details (view)
5 rows where musiccaps_aspects contains "acoustic drums", musiccaps_aspects contains "uplifting energy" and musiccaps_aspects contains "uptempo"
This data as json, CSV (advanced)
musiccaps_aspects (array) 25 ✖
- acoustic drums · 5 ✖
- uplifting energy · 5 ✖
- uptempo · 5 ✖
- e-guitar 2
- male voice singing 2
- piano 2
- acoustic guitar 1
- acoustic guitars 1
- amateur recording 1
- brass 1
- country 1
- crowd cheering 1
- e-bass 1
- e-bass saxophones/brass 1
- e-guitars 1
- funk/jazz 1
- higher key 1
- keys 1
- male voices singing/shouting 1
- mandolin 1
- pop/singer-songwriter 1
- rock 1
- rock&roll 1
- tambourine 1
- upright bass 1
musiccaps_names (array) 17 ✖
- Music 3
- Angry music 1
- Banjo 1
- Bass drum 1
- Brass instrument 1
- Country 1
- Cymbal 1
- Drum 1
- Drum kit 1
- Hi-hat 1
- Percussion 1
- Rimshot 1
- Rock and roll 1
- Roll 1
- Singing 1
- Snare drum 1
- Trumpet 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
posdata te quiero galway girl | Two acoustic guitars being strummed can be heard while a male voice is singing in the mid range. Someone is strumming chords in a higher key alone. In the background you can hear acoustic drums and the crowd is cheering. This song may be playing live in a pub. | 2009-09-12T14:37:30Z | Adri Terroba | galway girl-posdata te quiero DISCLAIMER: NO COPYRIGHT INFRINGEMENT INTENDED. FOR ENTERTAINMENT PURPOSES ONLY | ["Singing", "Banjo", "Country", "Music"] | ["pop/singer-songwriter", "amateur recording", "acoustic guitars", "mandolin", "male voice singing", "acoustic drums", "crowd cheering", "uptempo", "uplifting energy"] | 6 | BhJa0kTUdGY | 1276 | |
6 WHITE BOOMERS 2013 | This song contains a piano playing short rhythmic chords along with an acoustic guitar and an upright bass playing the same melody. A brass melody is opening the scene. sound A male voice is singing in a higher register. This song may be playing while celebrating with the whole family on a national holiday. | 2014-11-25T23:03:53Z | Snapshot 21st Century | ["Brass instrument", "Trumpet"] | ["country", "acoustic guitar", "piano", "acoustic drums", "upright bass", "male voice singing", "higher key", "brass", "uptempo", "uplifting energy"] | 6 | Qu76GhRO9Yk | 2648 | ||
06. KISS - Do You Remember Rock and Roll Radio ( A tribute to Ramones) | This song contains male voices singing/shouting while an acoustic drum is playing an elevating pattern on the toms. You can hear hands clapping to the beat. A brass section/saxophones are playing a repeating melody creating tension. Then the song breaks into the next part with a piano playing along with the melody. This song may be playing at a live concert. | 2012-03-05T19:29:37Z | shunandro | I do not own the rights of the music | ["Music", "Roll", "Rock and roll"] | ["rock&roll", "e-guitars", "piano", "e-bass saxophones/brass", "acoustic drums", "male voices singing/shouting", "uplifting energy", "uptempo"] | 6 | U6SYfguaJtk | 2887 | |
The Bamboos - The Witch | This audio contains a complex and funky acoustic drum groove along with a repeating bassline. The clean e-guitar is playing along with the bass in the lower register. A tambourine adds flavor to the drums. This song may be playing at a breakdance battle. | 2010-07-15T14:58:01Z | bTunes720 | Bboys and Bgirls enjoy the beat. More beats coming along so please subscribe if you like my videos. Video in HD 720p Sound quality high | ["Cymbal", "Drum", "Drum kit", "Hi-hat", "Rimshot", "Snare drum", "Bass drum", "Percussion"] | ["funk/jazz", "tambourine", "acoustic drums", "e-bass", "e-guitar", "uptempo", "uplifting energy"] | 6 | iBh37YAaHMU | 4166 | |
(PSX) Captain Tsubasa J: Get in the Tomorrow - All Star Team Shoot / Twin Shoot | This audio contains a drum playing with a lot of toms. A distorted e-guitar is playing a solo melody. In the background panned to the right side of the speakers you can hear a keyboard playing minor chords in the higher mid-range. This song may be playing while sitting in your room dancing for yourself. | 2010-07-24T09:05:41Z | DerroChannel | In this video I used the All Star Team to make some shoot ;) In the next video if you want i can make a tutorial where i show you how to make the shoots and the twin shoots. If you want this write it in the comment ;) | ["Music", "Angry music"] | ["rock", "e-guitar", "acoustic drums", "keys", "uptempo", "uplifting energy"] | 6 | vDmUlgsDOP4 | 5163 |
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;