musiccaps_details (view)
4 rows where musiccaps_aspects contains "rock/pop" and musiccaps_aspects contains "uptempo"
This data as json, CSV (advanced)
musiccaps_aspects (array) 16 ✖
- acoustic drums 4
- rock/pop · 4 ✖
- uptempo · 4 ✖
- e-bass 3
- e-guitars 2
- backing vocals 1
- bells 1
- cheerful 1
- distorted e-bass 1
- e-guitar 1
- e-piano 1
- female sounding voice singing 1
- female voice singing 1
- good vibes 1
- higher register 1
- male voices singing 1
musiccaps_names (array) 6 ✖
- Music 3
- Christian music 1
- Happy music 1
- Independent music 1
- Jazz 1
- Progressive rock 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
My Drive Thru (OFFICIAL MUSIC VIDEO) - Santogold, Casablancas, & N.E.R.D. | This song contains a simple acoustic drum groove with a cowbell sound. Two e-guitars and an e-bass are all playing the same melody spread across the speakers. Another e-guitar is strumming dissonant chords in the background panned to the left side of the speakers. Male voices are singing in a higher key. This song may be playing while cooking with joy. | 2008-07-10T00:03:11Z | ilovezestrokes | Higher Quality: http://www.youtube.com/watch?v=0_XItMAYkwc&fmt=18 The official music video for the song "My Drive Thru" by Santogold, Julian Casablancas, and N.E.R.D. Produced by Pharrell Williams. Made for the Converse Century campaign. | ["Jazz", "Music"] | ["rock/pop", "e-guitars", "e-bass", "acoustic drums", "male voices singing", "higher register", "uptempo"] | 6 | 0_XItMAYkwc | 183 | |
NICE SURF MUSIC | An acoustic drum is played together with an e-bass. They both repeat the same pattern. The ride is panned to the right side of the speakers. Three e-guitars are playing. One is strumming the same chords as the bassline while another one is being strummed with a mute technique playing a reggae rhythm. The third guitar is playing a solo melody on top and is panned to the right side of the speakers. This song may be playing at a bar. | 2007-08-03T21:44:52Z | Nico Afshari | VERY VERY AWESOME SURF MUSIC | ["Music", "Happy music"] | ["rock/pop", "e-guitars", "e-bass", "acoustic drums", "good vibes", "uptempo"] | 6 | IWbe-NSK6Ic | 1914 | |
Alaska Thunderfuck - Everyday Is Christmas [Official] from Christmas Queens | An acoustic drum is playing a constant groove along with an e-bass playing the footnote of an e-piano playing a major chord progression. A e-guitar is ending the phrases of the melody in a lower key. In the background you can hear bells playing. A female sounding voice is singing responding to a small choir taking turns singing a melody. This song may be playing during a cheerful event such as Christmas. | 2015-11-17T20:40:55Z | Alaska Thunderfuck | Buy Christmas Queens the full album on iTunes now! https://itunes.apple.com/album/christmas-queens/id1052800436?ls=1&app=itunes Executive Producer - David Charpentier Directed by Paul Alley Producer - Lydia Cartwright Associate Producer - Jessie Lee Pauli Assistant Director - Kushagar Budhwar Director of Photography - Karim Arab Assistant Camera - Nekisa Ghasemi Editor - Paul Alley Gaffer - Anwar Madrimov Grip - Almotaz Aljefri Makeup - Edwin Monzon Production Design by Dusti Cunningham Production Design Help - Andres Mejia Production Assistants - Danielle Rodriguez, Mary Ann Pianka, Tianzo Zhang, Haipeng Jia, Austin Guadayo Son 1: Jake Thompson Son 2: Jeremy Mikush Special Thanks to Nick Somers and Harmony "Spencer" Robertson Label/Management: Producer Entertainment Group david@producerentertainment.com | ["Christian music"] | ["rock/pop", "acoustic drums", "bells", "e-bass", "e-guitar", "female sounding voice singing", "e-piano", "backing vocals", "uptempo", "cheerful"] | 6 | Ny4wnDN4K1U | 2383 | |
Ruido Rosa - S.O.S (Audio) | The acoustic drums sound thick and played with deep tom hits. The electric bass is running through some effect, maybe an overdrive light distortion.The female voice is singing with some delay on her voice. This song may be playing in a bar downtown. | 2014-10-29T07:00:05Z | DancingQueensVEVO | Music video by Ruido Rosa performing S.O.S. (C) 2014 Universal Music Mexico S.A. de C.V. | ["Music", "Independent music", "Progressive rock"] | ["rock/pop", "distorted e-bass", "acoustic drums", "female voice singing", "uptempo"] | 6 | iuNpXisjsLY | 4223 |
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;