musiccaps_details (view)

6 rows where musiccaps_aspects contains "electric bass guitar" and musiccaps_author = 3

✎ View and edit SQL

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
GHANA GOSPEL MUSIC PROJECT 2008 AKWAABA JUNIOR LTJBM BAND Ayeyie oo! This is a live performance by an African music group in a gospel style. The drum pattern is intricate and there are other percussive elements like an occasional bongo and a wooden percussion instrument. The melodic elements are the vintage sounding electric piano as well as the vibrant and fun brass melody played on the trumpets. 2008-09-09T12:42:40Z livegospelbandghana SHILOH EVANGELICAL GOSPEL MUSIC ACADEMY presente to the world Afric's No. 1 juvenile live gospel band, playing three fusions. African gospel music revolution fusion, playing high life reggea jazz etc. contact: neelante@journalist.com, tel: (+233) 244 654 400 / 277 338 172 ["Gospel music", "Music", "Middle Eastern music"] ["african music", "gospel", "trumpets", "upbeat", "vibrant", "electric bass guitar", "bongo drums", "intricate drum pattern", "wooden percussion instrument", "electric keyboard", "mellow groove", "medium tempo"] 3 C0eCERYt4bA 1317
Pink Noise : Beverley Westwood This is a quintessential indie garage rock band. The singer is calm and sings with a sort of haunting demeanor typical of this style. It's a live recording and the audio is of low quality. The singer goes off-pitch at one point. 2006-05-29T09:55:00Z Nick Clay Recorded live at the famous Adelphi in Hull. http://www.nickclay.karoo.net/pinknoise.htm ["Music", "Punk rock", "Psychedelic rock", "Rock music", "Grunge"] ["rock", "alternative rock", "indie rock", "live recording", "low quality recording", "live performance", "rock band", "electric guitar", "electric bass guitar", "calm emo male singer"] 3 ORt8LSgn-uA 2441
Diez Clan at Peppa Pig's World This is a children's song that includes a clarinet melody that follows the vocal melody. There are children laughing and a child singing the main vocal melody. There's a child exclaiming joy. There's a subtle bassline. 2012-08-11T18:26:55Z JOSE DIEZ As it says on the tin ["Music", "Oink"] ["clarinet", "children laughing", "child singing", "happy song", "slow tempo", "child cheering", "electric bass guitar", "children's song"] 3 SKt_3Nv2DHo 2759
One piece - Luffy's top 10 punches This hard rock song feels like the kind of song that would play as you are preparing to go to war. The instruments are gritty, grungy, and intense. The electric guitarist plays an intricate motif and the bass player matches the main part of the riff. The drummer plays potent and punchy rhythms which feature the crash cymbal - which adds a bright shimmery contrast to the dark and grungry guitars. 2012-01-17T02:47:50Z Phenomenon309 One piece - Luffy's top 10 punches HD Song name - Burn it to the ground by Nickelback Intro Song- Ride with me By Decyfer Down I dont own anything here, I dont own the song or any of the anime used in this amv. I give full credit to One piece and song used in this video. I do not claim any of the material to be my own. Copyright holder is UMG 'Copyright Disclaimer Under Section 107 of the Copyright Act 1976, allowance is made for 'fair use' for purposes such as criticism, comment, news reporting, teaching, scholarship, and research. Fair use is a use permitted by copyright statute that might otherwise be infringing. Non-profit, educational or personal use tips the balance in favor of fair use' ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ I DO NOT OWN ANY ARTIST COMPANY. I MAKE NO PROFIT BY MAKING THESE VIDEOS. ALL RIGHTS RESERVED Category: ["Music", "Angry music"] ["rock", "hard rock", "intense", "energetic", "powerful", "rugged", "gritty", "grungy", "gritty electric guitar solo motifs", "crash cymbal", "potent punchy drumming", "electric bass guitar", "battle ground"] 3 TiOBlG-R1Y4 2861
Transistor - The Spine (Humming) Turn() version This song consists of three main elements - there is an angelic female humming vocal, a bass guitar which intricately follows the melody of the humming, and an atmospheric synth pad. The song generally has a soothing and relaxing vibe that feels almost transcendental. 2015-02-10T05:38:46Z SaucyHambeast "Never stood a chance against the champ." The version of "The Spine (Hummed)" that plays during Turn() combat from the video game Transistor. Transistor and all materials from the game belong to Supergiant Games. ["Humming", "Music"] ["calming", "soothing", "slow tempo", "angelic female vocal humming", "electric bass guitar", "synth pad"] 3 bZuXMxR2S4U 3636
Surp Sarkis-Aram Asatryan The song is a middle eastern pop ballad with a singer who sounds emotional and reflective. The song is at a medium tempo. There is a violin embellishment, piano, and some relaxed pop drumming. This song would be heard in a middle eastern movie. 2007-08-04T05:32:54Z marish123   ["Folk music", "Music"] ["middle eastern pop music", "ballad", "romantic", "relaxed", "emotional middle eastern male singer", "simple pop style drumming", "violin", "piano", "electric bass guitar"] 3 chw8sAKOM5k 3732

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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;