musiccaps_details (view)
1 row where musiccaps_aspects contains "happy", musiccaps_aspects contains "passionate female vocals", musiccaps_aspects contains "reggae" and musiccaps_names contains "Music"
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 |
---|---|---|---|---|---|---|---|---|---|---|
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;