musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "easygoing" and musiccaps_names contains "Folk music" sorted by musiccaps_caption
This data as json, CSV (advanced)
musiccaps_aspects (array) 23 ✖
- easygoing · 2 ✖
- joyful 2
- acoustic guitar 1
- banjo 1
- bluegrass 1
- chill 1
- funky electric guitar melodies 1
- groovy bass 1
- happy 1
- instrumental 1
- mandolin 1
- mellow rimshots 1
- no singer 1
- passionate female vocals 1
- passionate male vocal 1
- pastoral 1
- playful 1
- reggae 1
- rural 1
- shimmering hi hats 1
- synth keys melody 1
- uplifting 1
- wooden percussions 1
musiccaps_names (array) 7 ✖
- Folk music · 2 ✖
- Music 2
- Bluegrass 1
- Flamenco 1
- Gospel music 1
- Music of Bollywood 1
- Music of Latin America 1
video | youtube_link | musiccaps_caption ▼ | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
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 | |
ROZBĚH BLUEGRASS MUSIC | This is a bluegrass music piece. There is a mandolin playing the main tune as the lead while a banjo and an acoustic guitar are supporting it in the melodic background. There is a joyful feeling to this piece. It could be used in the soundtrack of a movie or a TV show with a rural setting. It could also be used in the background of pastoral social media content. | 2011-08-25T14:41:30Z | honzabaseman | 00. Úvod 01. MATTERHORN 02. PLEASE SEARCH A HEART 03. FOX ON THE RUN 04. HROU ZÍSKÁŠ HROW 05. SALT CREEK 06. ZÁTOKA 07. NOČNÍ VLAK 08. ZLATÁ RYBKA 09. BLACK DIAMOND 10. PÁDÍ MISSISSIPPI 11. FOGGY MOUNTAIN BREAKDAUN 12. KAROLÍNA 13. SVÍCEN ZMIZEL V TMÁCH 14. ARKANSAS TRAVELLER 15. PÝCHA PŘEDCHÁZÍ PÁD 16. PŘÍSAHEJ 17. SAIL TO AUSTRALIA | ["Gospel music", "Folk music", "Flamenco", "Music", "Music of Bollywood", "Music of Latin America", "Bluegrass"] | ["bluegrass", "no singer", "instrumental", "banjo", "mandolin", "acoustic guitar", "playful", "joyful", "uplifting", "easygoing", "rural", "pastoral"] | 9 | 0-7PyzhzuYQ | 108 |
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;