musiccaps_details (view)
3 rows where search matches "guitar", musiccaps_aspects contains "e-guitars" and musiccaps_aspects contains "rock/pop" sorted by youtube_description
This data as json, CSV (advanced)
musiccaps_aspects (array) 11 ✖
- e-guitars · 3 ✖
- rock/pop · 3 ✖
- acoustic drums 2
- e-bass 2
- uptempo 2
- good vibes 1
- higher register 1
- male voices singing 1
- medium tempo 1
- soft 1
- xylophone 1
musiccaps_names (array) 7 ✖
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 | |
Coolest Guitars Ever! Funny and Crazy Guitar Designs - Custom Guitar Art | A e-guitar with a chorus effect is playing a simple, repeating chord progression while another guitar is playing a bassline over it that sounds more like a countermelody. On top of that, slightly panned to the right side of the speakers, a xylophone is playing single notes with a lot of reverb. This song sounds repetitive and relaxing and soft. This song may be playing with earphones waiting for the bus. | 2012-08-24T17:20:21Z | Mykola MrHardGuitar - Guitar Reviews And Lessons | http://hard-guitar.com/ Coolest Guitars Ever! Here is my collection of nearly 50 crazy and funny guitars photos. Some guitars look very cool spider guitar or a sword guitar. But most of them look crasy and odd - such as body theme guitars. But the most odd is The Wangcaster guitar... Just check it out in video... lol | ["Guitar", "Music", "Musical instrument", "Chorus effect", "Plucked string instrument"] | ["rock/pop", "xylophone", "e-guitars", "soft", "medium tempo"] | 6 | IUjzBX2Qm4k | 1913 |
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;