musiccaps_details (view)
3 rows where musiccaps_aspects contains "addictive", musiccaps_aspects contains "groovy", musiccaps_aspects contains "low quality" and musiccaps_aspects contains "punchy kick"
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 |
---|---|---|---|---|---|---|---|---|---|---|
ill Scarlett - Babylon Song @ Sound of Music | The low quality recording features a live performance of an Alternative/Indie song and it consists flat male vocal singing over electric guitar chord progression, thin, but groovy bass guitar, punchy kick and snare hits, soft rimshots, soft crash cymbal, shimmering hi hats and a drum break. It sounds energetic, groovy and addictive, due to the cadence. | 2008-06-25T11:52:33Z | KyleCherops | ill Scarlett - "Babylon Song" live at Sound of Music Festival 2008 Burlington, ON | June 14, 2008 video 04 of 10 shot by Kyle Cheropita www.ishotyourset.net www.cherops.com | ["Music", "Rock and roll", "Exciting music"] | ["low quality", "live performance", "alternative/indie", "flat male vocal", "audio distortion", "electric guitar chord progression", "punchy kick", "shimmering hi hats", "punchy snare", "soft rimshots", "groovy thin bass guitar", "soft crash cymbal", "drum break", "addictive", "groovy", "energetic"] | 4 | 8akqVDDGsNQ | 931 | |
Devil in Disguise | The low quality features a rock song that consists of a muffled passionate male vocal singing over wide acoustic rhythm guitars chords, shimmering cymbals, punchy kick and groovy bass. It sounds addictive, passionate and groovy - like something you would hear in pubs and bars during the 50s. | 2009-07-27T16:11:01Z | autopeerke | ["Music", "Rhythm and blues", "Ska"] | ["low quality", "rock", "muffled passionate male vocal", "wide acoustic rhythm guitars", "shimmering cymbals", "punchy kick", "groovy bass", "passionate", "addictive", "groovy"] | 4 | 9UOPRQhNzQ8 | 1014 | ||
Jonny Pow Khaen Lao | The low quality recording features a hip hop instrumental that consists of punchy kick, claps, repetitive synth chords, addictive plucked strings melody and tinny wooden percussive elements. It sounds groovy and very addictive, due to that string melody. | 2011-02-02T03:34:15Z | Jonny Olsen | This is Jonny's theme song. Jonny raps in English and Nyot sings along with a catchy chorus "Jonny Pow Khaen Lao." ຈອນນີ ເປ່ົາແຄນລາວ The second part where Nyot sings is the Sueng Bung Fai melody. Jonny loves to entertain you all and had a fun time teaming up with Nyot Sengathid- Morlum Hip Hop Savannakhet. We can learn about other people's culture. We can share ideas, have fun, and make the world a better place. Lets all get along and love each other. End the hate. Thank you. Album-"Mawlum Hip Hop Lao-America 2010." Jonny is the first Farang or foreigner to ever make and release an album in Laos. He is also the first foreigner to win a khaen competition in Khon Kaen, Thailand 2005. Thank you 🙏❤ | ["Music", "Steelpan"] | ["hip hop", "punchy kick", "claps", "repetitive synth chords", "addictive plucked strings melody", "low quality", "tinny wooden percussive elements", "addictive", "groovy"] | 4 | navn7jCBp_o | 4559 |
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;