musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "passionate male vocal", musiccaps_aspects contains "shimmering hi hats" and musiccaps_aspects contains "wooden percussions"
This data as json, CSV (advanced)
musiccaps_aspects (array) 19 ✖
- happy 2
- joyful 2
- passionate male vocal · 2 ✖
- shimmering hi hats · 2 ✖
- wooden percussions · 2 ✖
- chill 1
- easygoing 1
- fun 1
- funky electric guitar melodies 1
- groovy bass 1
- low quality 1
- mellow kick hits 1
- mellow rimshots 1
- passionate female vocals 1
- pop 1
- reggae 1
- syncopated snare 1
- synth keys melody 1
- wide electric guitar melody 1
musiccaps_names (array) 3 ✖
- Music 2
- Blues 1
- Folk music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Sayang Kinabalu Music Video by Nikki and Jimmy Palikat | The low quality recording features a pop song that consists of a passionate male vocal singing over mellow kick hits, shimmering hi hats, wide electric guitar melody, syncopated snare and wooden percussion. The first half of the loop does not consist of the vocal, snare and hi hats. It sounds happy, fun and joyful. | 2014-07-23T10:21:33Z | Hotlink | Kepada saudara-saudari dari Sabah, terima kasih atas sokongan anda. Kami harap anda seronok mendengar lagu SAYANG KINABALU dinyanyikan oleh Jimmy & Nikki Palikat. Dapatkan muat turun lagu penuh PERCUMA dengan hantar GET SYGKINABALUFS ke 29000 atau dapatkan Caller Ringtone PERCUMA dengan hantar GET SYGKINABALUCRT ke 29000. Untuk maklumat lanjut #Hotlink, sila dapatkan di www.hotlink.com.my/sabah | ["Blues", "Music"] | ["low quality", "pop", "passionate male vocal", "happy", "fun", "joyful", "mellow kick hits", "shimmering hi hats", "wide electric guitar melody", "wooden percussions", "syncopated snare"] | 4 | -rAhS48FkYw | 92 | |
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 |
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;