musiccaps_details (view)
4 rows where musiccaps_aspects contains "rock" and musiccaps_names contains "Rhythm and blues"
This data as json, CSV (advanced)
musiccaps_aspects (array) 39 ✖
- rock · 4 ✖
- addictive 2
- groovy bass 2
- punchy kick 2
- shimmering cymbals 2
- acoustic drums 1
- alternative rock 1
- catchy rhythm 1
- clapper 1
- clapping 1
- country pop 1
- e-bass 1
- e-guitars 1
- energetic 1
- fast tempo 1
- female voice singing 1
- groovy 1
- harmonizing male vocals 1
- indie pop 1
- indie rock 1
- keyboard harmony 1
- keys 1
- lively 1
- lively acoustic guitar 1
- low quality 1
- male backing voice 1
- male vocalist 1
- muffled passionate male vocal 1
- passionate 1
- passionate male vocal 1
- pop 1
- punchy drumming 1
- punchy snare 1
- spirited 1
- steady bass line 1
- string instruments 1
- uptempo 1
- wide acoustic rhythm guitars 1
- wide electric guitar melody 1
musiccaps_names (array) 5 ✖
- Music 4
- Rhythm and blues · 4 ✖
- Exciting music 2
- Happy music 1
- Ska 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
The Tra La La Song Music Video - Full Version | An acoustic drum is playing a simple rock groove with some drum fills on the toms and snare along with a distorted e-bass and e-guitar playing the same line. Panned to the right side of the speaker you can hear a piano sound playing a little melody. A female voice is singing a happy sounding melody while male backing voices are supporting her. This song may be playing sitting in your room enjoying being at home alone. | 2010-02-11T03:47:04Z | Derek Bartholomaus | This is the full version of "The Tra La La Song (One Banana, Two Banana)" aka The Banana Splits Theme as performed by Liz Phair and Material Issue for the Saturday Morning Cartoons' Greatest Hits music and video project. This version was not released on home video and was only aired on MTV. This material is © 1995 by MCA Records. | ["Music", "Rhythm and blues", "Happy music", "Exciting music"] | ["rock", "e-guitars", "e-bass", "acoustic drums", "keys", "female voice singing", "male backing voice", "uptempo"] | 6 | -JvB5AL59fM | 36 | |
Billy Talent - Fallen Leaves Music Video (HQ) | The Rock song features a passionate male vocal, alongside harmonizing male vocals, singing over wide electric guitar melody, groovy bass guitar, punchy kick and snare hits and some shimmering cymbals. It sounds energetic and kind of addictive thanks to those harmonizing vocals - like something you would hear on a radio during the 00s. | 2010-04-27T14:20:24Z | Jimmy Karlsson | The official music video of the song with the same name enjoy... Update 2012-12-01 Thanks for 100 000 views | ["Music", "Rhythm and blues", "Exciting music"] | ["rock", "passionate male vocal", "harmonizing male vocals", "wide electric guitar melody", "groovy bass", "punchy kick", "punchy snare", "shimmering cymbals", "energetic", "addictive"] | 4 | 0LE6Ll1rVlg | 150 | |
Devil in Disguise | The low quality features a rock song that consists of a muffled passionate male vocal singing over wide acoustic rhythm guitars chords, shimmering cymbals, punchy kick and groovy bass. It sounds addictive, passionate and groovy - like something you would hear in pubs and bars during the 50s. | 2009-07-27T16:11:01Z | autopeerke | ["Music", "Rhythm and blues", "Ska"] | ["low quality", "rock", "muffled passionate male vocal", "wide acoustic rhythm guitars", "shimmering cymbals", "punchy kick", "groovy bass", "passionate", "addictive", "groovy"] | 4 | 9UOPRQhNzQ8 | 1014 | ||
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;