musiccaps_details (view)
3 rows where musiccaps_aspects contains "joyful", musiccaps_author = 4 and musiccaps_names contains "Folk music"
This data as json, CSV (advanced)
musiccaps_aspects (array) 29 ✖
- joyful · 3 ✖
- groovy bass 2
- happy 2
- low quality 2
- traditional 2
- wooden percussions 2
- acoustic guitar melody 1
- addictive 1
- chill 1
- clapping 1
- easygoing 1
- energetic 1
- exciting background male vocals 1
- flat male vocal 1
- fun 1
- funky electric guitar melodies 1
- mellow rimshots 1
- mellow synth pad chords 1
- passionate female vocals 1
- passionate male vocal 1
- pop 1
- reggae 1
- shimmering hi hats 1
- shimmering tambourine 1
- synth keys melody 1
- wide 1
- wide plucked echoing strings 1
- wobbly percussion 1
- wooden percussive elements 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Japp Japp Naam - Bhai Gurpreet Singh Shimla Wale - Amritt Saagar - Shabad Kirtan Gurbani | The low quality recording features a traditional song that consists of mellow synth pad chords, wide plucked echoing strings, wobbly percussion, wooden percussion and shimmering tambourine. It sounds happy and joyful - like something you would hear at some traditional festivals. | 2011-12-10T07:40:09Z | Gurbani Shabad Kirtan - Amritt Saagar | Album - Guru Guru Japp Ragi - Bhai Gurpreet Singh Shimla Wale Producer - Balbir Singh Bhatia Company - Amritt Saagar | ["Folk music", "Music"] | ["low quality", "traditional", "mellow synth pad chords", "wide plucked echoing strings", "wobbly percussion", "wooden percussions", "shimmering tambourine", "happy", "joyful"] | 4 | eSIxvnEQ6R0 | 3862 | |
Bob Marley - Positive Vibration | The low quality recording features a passionate male vocal, alongside passionate female vocal in the left channel of the stereo image, singing over shimmering hi hats, which are also in the left channel, widely spread funky electric guitar chords, synth keys melody in the right channel, groovy bass, wooden percussions and mellow rimshots. It sounds happy, joyful, easygoing and chill. | 2009-05-20T09:26:13Z | Reggae Man | Live if you want to live (Rastaman vibration, yeah! Positive!) That's what we got to give! (I'n'I vibration yeah! Positive) Got to have a good vibe! (Iyaman Iration, yeah! Irie ites!) Wo-wo-ooh! (Positive vibration, yeah! Positive!) If you get down and you quarrel everyday, You're saying prayers to the devils, I say. Wo-oh-ooh! Why not help one another on the way? Make it much easier. (Just a little bit easier) Say you just can't live that negative way, If you know what I mean; Make way for the positive day, 'Cause it's news (new day) - news and days - New time (new time), and if it's a new feelin' (new feelin'), yeah! - Said it's a new sign (new sign): Oh, what a new day! Pickin' up? Are you pickin' up now? Jah love - Jah love (protect us); Jah love - Jah love (protect us); Jah love - Jah love (protect us). Rastaman vibration, yeah! (Positive!) I'n'I vibration, yeah! (Positive!) Uh-huh-huh, a yeah! Iyaman Iration, yeah! (Irie ites!) Wo-oo-oh! *Positive vibration, yeah! (Positive!) Pickin' up? Are you pickin' up now? Pickin' up? Are you pickin' up now? Pickin' up? (Jah love, Jah love -) Are you pickin' (protect us!) up now? Pickin' up? (Jah love, Jah love -) Are you pickin' (protect us!) up now? Pickin' up? (Jah love, Jah love -) Are you pickin' (protect us!) up now? Pickin' up? Are you pickin' up now? | ["Folk music", "Music"] | ["reggae", "passionate male vocal", "passionate female vocals", "funky electric guitar melodies", "synth keys melody", "wooden percussions", "groovy bass", "mellow rimshots", "shimmering hi hats", "happy", "joyful", "easygoing", "chill"] | 4 | jPOWgfA0zAo | 4251 | |
Farhad Shams Qarsak-e Panjsher and Sheen Khaale | The low quality recording features a traditional pop song that consists of a flat male vocal, alongside exciting background vocals, singing over claps, wooden percussive elements, groovy bass and acoustic guitar melody. It sounds energetic, addictive, fun and joyful - like something you would hear at more traditional parties. | 2013-03-18T17:13:05Z | StylezhooDB3o9 | Farhad Shams Qarsak-e Panjsher and Sheen Khaale Farhad Shams Qarsak-e Panjsher and Sheen Khaale | ["Singing", "Folk music", "Music"] | ["low quality", "pop", "traditional", "acoustic guitar melody", "wooden percussive elements", "clapping", "groovy bass", "flat male vocal", "exciting background male vocals", "wide", "energetic", "addictive", "fun", "joyful"] | 4 | qM8F6ECriRc | 4779 |
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;