musiccaps_details (view)
4 rows where musiccaps_aspects contains "funky" and musiccaps_names contains "Ska"
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 |
|---|---|---|---|---|---|---|---|---|---|---|
| Splendid - You Don't Understand | This song contains acoustic drums with a fat kick drum and a funky bassline. The acoustic guitar is strumming chords in the background being panned to the left side of the speaker while a e-guitar panned to the right side of the speaker is playing the lead melody strumming chords with a wah-wah pedal. A male backing voice is singing the same melody in a loop. The male lead voice is singing over the backing vocals. This song may be playing on a road trip. | 2007-10-23T20:56:12Z | splendidmusic | The long awaited all in the family happy happy sunshine videoclip for the Splendid track "You Don't Understand", taken from the 2006 album "Rebirth". iTunes: http://itunes.apple.com/nl/album/rebirth/id320728481 http://www.splendidmusic.nl Bookings: http://www.agentsafterall.nl | ["Music", "Ska"] | ["pop", "acoustic guitar", "e-guitar", "e-bass", "acoustic drums", "male voice singing", "mid-range", "male backing vocals", "medium tempo", "funky"] | 6 | Aw2ctwyhe28 | 1185 | |
| patrice ft keziah jones - here again | The low quality recording features an indie song that consists of harmonizing vocals melody, alongside passionate vocals over acoustic rhythm guitar melody in the left channel and funky strummed electric guitar chord progression in the right channel of the stereo image. It sounds passionate, soulful, funky and emotional. | 2008-09-28T11:26:38Z | Bruno Gonzaga | LYRICS: I'm here again I'm here again singing for a brighter day Understand I understand how we ever went away (Keziah) Dreams and things yeah chains and rings yeah silver and gold from our souls The world's gotta know (x6) (Patrice) true warrior here again I feel so sorry for the ye and then and you feed your souls with it sounds like those yeah we'll be forcing I don't mean again (Keziah) everday you gotta change our ways love has it's way so don't loose your way make sure there is something left for those on the way for a brighter day those on the way, a brighter day (Chorus again) The world's gotta know (x6) And everything she says just rise my love The curve she loves you line I mean, when you say what you say when you say whay you say it happens all the time this is treat-off paradise mean the love between the girls and boys the love between me and my friends permently won't end so real I cant pretend (Keziak) everday you gotta change your ways love has it's way so don't loose your way make sure there is something left for for a brighter day those on the way, a brighter day Brighter day, brighter day.. Oh oh oh oh uh uh uh | ["Singing", "Ska"] | ["low quality", "indie", "funky strummed electric guitar chord progression", "harmonizing vocals melody", "passionate male vocal", "acoustic rhythm guitar melody", "passionate", "soulful", "funky", "emotional"] | 4 | T0uoYE12cnI | 2805 | |
| Jon Cleary - When You Get Back (Live at Jazz Fest 2007) | The low quality recording features a live performance of a jazz song that consists of a wide passionate, harmonizing male vocals singing over punchy snare and kick hits, shimmering hi hats, groovy bass guitar, synth pad and funky electric guitar melody. It sounds funky, groovy and passionate. | 2009-04-24T23:01:22Z | Jon Cleary | Jon Cleary live at the New Orleans Jazz & Heritage Festival Follow Jon https://www.facebook.com/jonclearymusicofficial/ https://www.instagram.com/jonclearymusic/ https://twitter.com/jonclearymusic http://www.bandsintown.com/JonCleary | ["Ska"] | ["low quality", "noisy", "jazz", "live performance", "synth pad", "groovy bass", "funky electric guitar melody", "wide passionate harmonizing male vocals", "punchy kick", "punchy kick", "shimmering hi hats", "funky", "groovy", "passionate"] | 4 | _y07ENAx2_E | 3503 | |
| Shake Rattle n' Roll demo video 1 | The low quality recording features a live performance of a rock song that consists of flat male vocal singing over a wide electric guitar melody, groovy keys chords, located in the right channel of the stereo image, smooth bass guitar, shimmering open hats and hi hats and punchy kick and snare hits. It sounds groovy, funky and easygoing - like something you could lightly dance to. | 2009-09-30T03:58:48Z | Bill Crane | Demo video recorded 9/28/09. | ["Country", "Music", "Ska", "Rock and roll"] | ["low quality", "rock", "live performance", "flat male vocal", "wide electric guitar melody", "groovy keys chords", "smooth bass guitar", "shimmering hi hats", "punchy snare", "punchy kick", "shimmering open hats", "groovy", "funky", "easygoing"] | 4 | rmKh9uaikTU | 4900 |
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;