musiccaps_details (view)
4 rows where musiccaps_aspects contains "female vocalist", musiccaps_author = 7 and musiccaps_names contains "Independent music"
This data as json, CSV (advanced)
musiccaps_aspects (array) 65 ✖
- female vocalist · 4 ✖
- fast tempo 3
- buoyant 2
- enthusiastic 2
- groovy bass lines 2
- rock 2
- slick drumming 2
- vibrant 2
- youthful 2
- alternative rock 1
- cheeky 1
- christian music 1
- christian worship song 1
- classic rock 1
- dance groove 1
- devotional 1
- digital drum 1
- digital drums 1
- energetic 1
- engaging 1
- enthusiastic electric guitar 1
- foreign language 1
- fresh 1
- fun 1
- funky bass lines 1
- hammond organ 1
- hard rock 1
- indian classical 1
- indian music 1
- indian percussion 1
- inferior quality audio 1
- intense 1
- intense electric guitar feed back 1
- lively 1
- lively baritone saxophone 1
- loud singing 1
- mellow 1
- muffled audio 1
- passionate 1
- piano accompaniment 1
- playful 1
- pop rock 1
- powerful 1
- progressive rock 1
- punchy 1
- rhythmic acoustic guitar 1
- saxophone 1
- slow tempo 1
- soft melody 1
- soft rock 1
- south indian music 1
- spirited 1
- suggestive 1
- symphonic rock 1
- synth arrangements 1
- synthesiser articulation 1
- tabla 1
- tambourine 1
- tamil christian worship 1
- tamil music 1
- vibrant electric guitars 1
- vigorous drumming 1
- violin harmony 1
- vivacious 1
- wood wind 1
musiccaps_names (array) 9 ✖
- Independent music · 4 ✖
- Music 4
- Gospel music 1
- Heavy metal 1
- Pop music 1
- Progressive rock 1
- Rock music 1
- Singing 1
- Song 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
ITV Chart Show Indie Chart July 1995 | A female vocalist sings this energetic song. The tempo is fast with furiously energetic drumming, intense electric guitar, groovy bass lines, keyboard harmony, vocal backup and synthesiser arrangements. The song is passionate, spirited,youthful, buoyant, punchy, energetic and animated. The audio is muddy and incoherent. This song is Pop Rock. | 2007-09-09T16:56:00Z | David Bryant | Features: Buffalo Tom - Summer Song Menswear - Daydreamer | ["Music", "Independent music"] | ["female vocalist", "loud singing", "fast tempo", "pop rock", "hard rock", "dance groove", "buoyant", "spirited", "passionate", "vibrant", "enthusiastic", "energetic", "intense", "vigorous drumming", "intense electric guitar feed back", "groovy bass lines", "synth arrangements", "digital drums", "muffled audio", "inferior quality audio", "rock"] | 7 | J48F0e0guSQ | 1966 | |
Minecraft Song ♪ "All About My Base" Minecraft Song Parody (Minecraft Animation) | A female vocalist sings this spirited pop. The tempo is fast with infectious piano melody, slick drumming, funky bass, baritone saxophone, Hammond organ accompaniment with enthusiastic vocals. The song is fresh, youthful, buoyant; energetic, high-spirited, cheeky, suggestive, playful and groovy. This is a hit Pop Song. | 2015-06-15T01:55:28Z | Lachlan | Download the Minecraft Song "All About My Base" on Itunes: http://bit.ly/AllAboutMyBase Come play Minecraft Factions with me on Treasure Wars! IP: Treasurewars.net Subscribe for more Awesome Minecraft Content http://bit.ly/LachlanSubscribe Gaming Channel: https://www.youtube.com/LachlanPlayz Lachlan All About My Bass (The original to the Parody): https://www.youtube.com/watch?v=7PCkvCPvDXk Credits: Animation: Latez Animations https://www.youtube.com/user/Boxmen6661 https://twitter.com/Boxm3n666 Vocals + Instrumentals + Lyrics by ShadyVox http://www.shadyvox.com https://twitter.com/ShadyVox http://www.youtube.com/user/ShadyVoxYT Singers: https://www.youtube.com/EileMontyVA/ www.twitter.com/EileMonty The Pack: Vik: https://www.youtube.com/user/Vikkstar123HD Rob: https://www.youtube.com/user/MrWoofless Preston: https://www.youtube.com/user/PrestonPlayz Mitch: https://www.youtube.com/user/TheBajanCanadian Jerome: https://www.youtube.com/user/JeromeASF My Links Twitter: https://twitter.com/LachlanYT Instagram: http://instagram.com/lachlanpower | ["Music", "Independent music"] | ["female vocalist", "fast tempo", "slick drumming", "punchy", "buoyant", "fun", "fresh", "suggestive", "enthusiastic electric guitar", "funky bass lines", "piano accompaniment", "lively baritone saxophone", "hammond organ", "lively", "enthusiastic", "youthful", "cheeky", "playful", "fun"] | 7 | YVEqyQjyy1Q | 3289 | |
Tamil Christian Song - Nee illatha by Hema John- Zion Music Festival '09 | A female vocalist sings this soft melody. The tempo is slow with violin harmony, keyboard accompaniment, saxophone, digital drum, tabla and tambourine beats. The song is mellow, soft, melodic, soothing, calming , devotional and euphonious. This song is a Tamil Christian Song. | 2010-11-04T07:04:36Z | endtimezionministry | http://www.endtimezionministries.org Through Him (Jesus) all things were made; without Him nothing was made that has been made. In Him was life, and that life was the light of all mankind. John:1:3,4 | ["Gospel music", "Music", "Independent music"] | ["female vocalist", "slow tempo", "foreign language", "wood wind", "rhythmic acoustic guitar", "tabla", "indian percussion", "tambourine", "indian music", "indian classical", "south indian music", "tamil music", "violin harmony", "digital drum", "saxophone", "soft melody", "mellow", "devotional", "christian music", "christian worship song", "tamil christian worship"] | 7 | ghW2xZMvpIQ | 4046 | |
Magenta - King Of The Skies | A female vocalist sings this spirited song. The tempo is fast with enthusiastic electric guitar harmony, slick drumming, groovy bass lines and synthesiser arrangements. The song is energetic, youthful, fun, pulsating, engaging and emphatic. This song is Alternative Rock. | 2006-06-21T17:59:15Z | chrismagenta | Track from Magenta's The Gathering DVD. Amazing Welsh Progressive Rock band in the vain of Genesis, Yes and Renaissance. | ["Singing", "Heavy metal", "Music", "Independent music", "Pop music", "Rock music", "Song", "Progressive rock"] | ["female vocalist", "fast tempo", "vibrant electric guitars", "progressive rock", "symphonic rock", "alternative rock", "slick drumming", "synthesiser articulation", "vivacious", "youthful", "vibrant", "groovy bass lines", "engaging", "powerful", "rock", "classic rock", "soft rock"] | 7 | pp6eSGANq0Y | 4737 |
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;