musiccaps_details (view)
4 rows where search matches "guitar", musiccaps_aspects contains "keyboard harmony" and musiccaps_names contains "Rhythm and blues" sorted by youtube_id
This data as json, CSV (advanced)
musiccaps_aspects (array) 70 ✖
- keyboard harmony · 4 ✖
- pop 3
- spirited 3
- buoyant 2
- energetic 2
- fast tempo 2
- foreign language 2
- infectious drumming 2
- male vocalist 2
- alternative rock 1
- animated 1
- bright 1
- catchy 1
- catchy rhythm 1
- cheerful 1
- clapper 1
- clapping 1
- colourful 1
- congas 1
- country pop 1
- dance groove 1
- disco rap 1
- drum stick clicks 1
- duet 1
- electric guitar 1
- ending song 1
- enthusiastic 1
- first love 1
- folk 1
- galloping rhythm 1
- groovy bass lines 1
- guitar accompaniment 1
- high-spirited 1
- hip-hop 1
- indie pop 1
- indie rock 1
- infectious 1
- lively 1
- lively acoustic guitar 1
- love song 1
- male singer 1
- medium fast tempo 1
- medium tempo 1
- mellow 1
- ost 1
- pop rap 1
- punchy 1
- punchy drumming 1
- punchy guitar rhythm 1
- punchy guitar rhythms drum stick clicks 1
- rap 1
- regional music 1
- rhythmic acoustic guitar 1
- rhythmic patter 1
- rock 1
- romantic 1
- sentimental 1
- simple melody 1
- soft rock 1
- steady bass line 1
- steady bass lines 1
- steady drumming 1
- string instruments 1
- tender 1
- ukrainian song 1
- upbeat 1
- vibrant 1
- violin harmony soft 1
- youthful 1
- you’ve got mail 1
musiccaps_names (array) 8 ✖
- Music 4
- Rhythm and blues · 4 ✖
- Jazz 2
- Afrobeat 1
- Hip hop music 1
- Music of Africa 1
- Rapping 1
- Wedding music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id ▼ | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Українська Весільна Музика 9 (Ukrainian Wedding Music 9) | This song is a lively Ukrainian duet. The tempo is fast and upbeat with a bright keyboard harmony, infectious drumming , groovy bass line and rhythmic acoustic guitar. The music is energetic, enthusiastic, lively, high-spirited , cheerful, happy, warm, buoyant and catchy with a simple melody. This song is a Ukrainian Pop song. | 2009-11-29T18:52:15Z | UAWaveofMusic | Українська Весільна Музика!!!!! ENJOY AND PLEASE SUBSCRIBE!!!!!! | ["Jazz", "Music", "Wedding music", "Rhythm and blues"] | ["duet", "fast tempo", "upbeat", "ukrainian song", "spirited", "enthusiastic", "energetic", "buoyant", "bright", "colourful", "catchy", "simple melody", "cheerful", "high-spirited", "pop", "foreign language", "infectious", "folk", "regional music", "keyboard harmony", "groovy bass lines", "infectious drumming", "galloping rhythm", "rhythmic acoustic guitar"] | 7 | 0ADP-O_V3vA | 129 | |
You've got mail ending - Music: Forever J | A male vocalist sings this romantic song. The tempo is medium fast with keyboard harmony, infectious drumming, steady bass lines and electronic guitar. The song is simple, mellow, tender, sentimental, emotional and mellow. This is a Romantic Soft Rock. | 2007-02-17T09:45:14Z | john kouk | Sweet movie, sweet actors, sweet song... | ["Jazz", "Music", "Rhythm and blues"] | ["male vocalist", "medium fast tempo", "infectious drumming", "sentimental", "mellow", "tender", "love song", "first love", "pop", "ost", "you’ve got mail", "ending song", "keyboard harmony", "steady bass lines", "violin harmony soft", "mellow", "romantic", "soft rock", "electric guitar"] | 7 | 6PWiDlWmPs0 | 751 | |
Busy Signal - How Dem A Talk [Clean Version] | A male vocalist sings this peppy rap. The tempo is medium fast with an enthusiastic and catchy guitar rhythm, drum stick clicks, congas, steady drumming and keyboard accompaniment. The song is simple, punchy; buoyant, youthful, animated, vibrant and has a catchy dance groove. This song is contemporary Hip-Hop/Rap. | 2015-08-20T01:50:47Z | BusySignalRealVEVO | Music video by Busy Signal performing "How Dem A Talk" (Official Visual). ©: Turf Music Entertainment /Stainless Music http://vevo.ly/nWNEGT | ["Afrobeat", "Music of Africa", "Music", "Rapping", "Rhythm and blues", "Hip hop music"] | ["male singer", "medium tempo", "spirited", "vibrant", "buoyant", "foreign language", "punchy guitar rhythm", "drum stick clicks", "disco rap", "punchy", "guitar accompaniment", "steady drumming", "congas", "keyboard harmony", "energetic", "rap", "hip-hop", "pop rap", "youthful", "spirited", "animated", "dance groove", "vibrant", "punchy guitar rhythms drum stick clicks", "rhythmic patter"] | 7 | NWL-P08eM-U | 2342 | |
The Cast of Degrassi the Boiling Point | A male vocalist sings this catchy pop song. The tempo is medium fast with funky drumming, spirited acoustic guitar accompaniment, rhythmic clapping, steady bass line and keyboard harmony. The song is melodic, perky, peppy, youthful, playful, enthusiastic and fun. This is Indie Pop/Indie Rock. | 2010-09-19T02:51:39Z | katilovessapphire | some r missing! i kno that but i did the best i could! not many picture of the ones i'm missing | ["Music", "Rhythm and blues"] | ["male vocalist", "fast tempo", "country pop", "keyboard harmony", "clapper", "steady bass line", "string instruments", "clapping", "punchy drumming", "lively acoustic guitar", "catchy rhythm", "lively", "spirited", "pop", "rock", "alternative rock", "indie pop", "indie rock"] | 7 | rLQ93N6RJC0 | 4868 |
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;