musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "uptempo" and musiccaps_names contains "Jazz" sorted by youtube_id
This data as json, CSV (advanced)
musiccaps_aspects (array) 15 ✖
- uptempo · 2 ✖
- acoustic drums 1
- acoustic rhythm guitar chords 1
- e-bass 1
- e-guitars 1
- groovy double bass 1
- higher register 1
- live performance 1
- low quality 1
- male voices singing 1
- mono 1
- noisy 1
- passionate 1
- rock/pop 1
- spanish guitar solo melody 1
musiccaps_names (array) 7 ✖
- Jazz · 2 ✖
- Music 2
- Bluegrass 1
- Guitar 1
- Musical instrument 1
- Plucked string instrument 1
- Swing music 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 | |
Swing Amor "Rose Room" | The low quality recording features a live performance that consists of a Spanish guitar solo melody, groovy double bass and acoustic rhythm guitar chords. The recording is noisy, in mono and it sounds passionate and uptempo - like something you would dance to with your friends in a latin club. | 2008-12-02T16:54:14Z | hailletmusic | About SWING AMOR A gypsy swing band formed in 2004. Currently, the band performs in cafes and such based in Kumamoto Prefecture.In April 2006, their first album GYPSY SWING JAZZ was released. It includs 12 gems, from originals to standard Jazz tunes. In July 2007, they participated in a compilation album "DJANGO FESTIVAL4" which was released by a long-established Norwegian gypsy jazz label. In January 2009 the distribution of GYPSY SWING JAZZ will begin via iTunes stores in 22 nations. The recording of their second album, three years after the first, is scheduled as well. | ["Swing music", "Guitar", "Jazz", "Music", "Musical instrument", "Plucked string instrument", "Bluegrass"] | ["low quality", "spanish guitar solo melody", "live performance", "groovy double bass", "acoustic rhythm guitar chords", "noisy", "mono", "passionate", "uptempo"] | 4 | iUHqyjf3NcQ | 4191 |
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;