musiccaps_details (view)
5 rows where musiccaps_aspects contains "e-bass" and musiccaps_names contains "Jazz"
This data as json, CSV (advanced)
| video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
|---|---|---|---|---|---|---|---|---|---|---|
| Melaku Nigus track 4 2013 New Ethiopian music, Rayan Music, Wollo Music, Ethiopian Music | A digital drum is playing a simple beat along with some percussive sounds. A bass is playing the same melody as the accordion-like instrument. A male voice is shouting little phrases. This song may be playing a country having a traditional dance. | 2013-08-05T08:14:54Z | At Love | Rayan music, Wollo Music, Ethiopian Music, Amharic Music, Rayan Cultural Music, Wollo Cultural Music, | ["Jazz", "Music"] | ["new ethiopian music", "digital drums", "male voice sample", "accordion-like sound", "e-bass", "medium tempo", "uplifting energy"] | 6 | 0PMFAO4TIU4 | 161 | |
| 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 | |
| Joe Satriani - "Echo" (Montreux Jazz Festival 1988) | This song contains acoustic drums with reverb and a bassline playing to the kick. Someone is playing a slow evolving melody on a distorted e-guitar. In the background you can hear voices. This song may be playing live at a concert. | 2007-12-16T17:59:19Z | satchreis | Joe Satriani live at Montreux Jazz Festival (July 15, 1988). | ["Jazz", "Music"] | ["rock", "acoustic drums", "e-bass", "e-guitar", "fast tempo", "exstatic", "amateur recording"] | 6 | 1ls3ectO1F4 | 309 | |
| Incognito - Nights Over Egypt (Live) | This song contains an acoustic drum-set holding the groove and changing his beat after a fill-in to a four on the floor with a kick on every beat. Mixed voices are singing a soulful sounding melody then an e-piano takes over playing a melody before a trumpet and a saxophone come in playing a loud melody. In the background you can hear percussion such as a cowbell being panned to the right side of the speakers. The crowd is cheering and clapping along. This song may be playing at a live concert. | 2006-06-12T01:23:49Z | Marcelo Kalef | Incognito plays "Nights Over Egypt" live in Seoul. | ["Jazz", "Music"] | ["soul/jazz", "e-piano", "acoustic drums", "mixed voices singing", "cowbell", "trumpet", "saxophone", "e-bass", "clapping", "uptempo", "cheerful vibe"] | 6 | UoxHwOl2gN0 | 2946 | |
| Undertale - Ghost Fight & Dummy (Peggy Suave Swing Remix) | The song contains a flutesound, brass-section, e-bass and some lower register keys all playing the same funky and repetitive melody. The drums are holding a straight rhythm while the hits on the ride are played in a light swing. This song may be played at a rollerblade disco. | 2016-01-26T22:54:46Z | Sim Gretina | Jazz hands https://soundcloud.com/simgretina/ghoost-fight-dummy-peggy-suave-remix https://simgretina.bandcamp.com/ | ["Electronic music", "Jazz", "Music"] | ["funk/discofunk", "dancemood", "e-bass", "flutesound", "jazz piano", "brass section", "uptempo"] | 6 | oFCzd9bJo9A | 4613 |
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;