musiccaps_details (view)
3 rows where musiccaps_aspects contains "addictive" and musiccaps_aspects contains "reverberant"
This data as json, CSV (advanced)
musiccaps_aspects (array) 27 ✖
- addictive · 3 ✖
- reverberant · 3 ✖
- low quality 2
- aggressive strumming 1
- boomy steel guitar melody 1
- electric rhythm guitar chords 1
- energetic 1
- energetic crash 1
- groovy bass 1
- groovy synth bass 1
- harmonizing background male vocal 1
- muddy 1
- noisy 1
- passionate 1
- passionate male vocal 1
- playback instrumental 1
- punchy "4 on the floor" kick 1
- punchy kick hits 1
- rock 1
- shimmering hi hats 1
- sizzling synths 1
- steel drum solo 1
- syncopated snare 1
- thin snare 1
- upbeat 1
- urban latin 1
- wide brass melody 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Machel Montano - She Ready (Steelpan Version) | The low quality recording features a steel drum solo melody over playback instrumental of urban latin song that consists of groovy synth bass, wide brass melody, sizzling synths, syncopated snare and punchy "4 on the floor" kick pattern. It sounds addictive, passionate and upbeat. The steel drum is reverberant due to the fact that it was recorded in a medium size room. | 2012-11-13T22:17:20Z | Keishaun Julien | Keishaun Julien playing She Say She Ready by Machel Montano on the steel pan (soca 2013) http://www.facebook.com/Keishaun.Julien http://www.twitter.com/keishaunjulien http://www.keishaunjulienmusic.com http://www.instagram.com/KeishaunJulien Special thanks to Precision Productions for making this video possible. http://www.facebook.com/PrecisionProductions Notes http://bit.ly/2ttruTd | ["Drum", "Music", "Musical instrument", "Percussion", "Steelpan"] | ["low quality", "playback instrumental", "urban latin", "groovy synth bass", "punchy \"4 on the floor\" kick", "wide brass melody", "sizzling synths", "syncopated snare", "steel drum solo", "passionate", "addictive", "reverberant", "upbeat"] | 4 | 7WR-hMV2RKs | 852 | |
Anatole, true maestro of the balalaika! | The low quality recording a boomy steel guitar being aggressively strummed. The recording is noisy, reverberant and it sounds muddy, but regardless, the melody is addictive. | 2006-12-01T23:55:55Z | HuwTube | A demonstration of some classic tunes on the Russian instrument, by a man who really knows what he's doing. | ["Guitar", "Music", "Musical instrument", "Ukulele", "Plucked string instrument"] | ["low quality", "boomy steel guitar melody", "aggressive strumming", "reverberant", "noisy", "muddy", "addictive"] | 4 | HU7oqkJeItQ | 1806 | |
The Connells - Scotty's Lament | The Rock song features a passionate male vocal, layered with harmonizing background male vocals, singing over electric rhythm guitar chords spread widely in the stereo image, thin snare, energetic crash, groovy bass, shimmering hi hats and punchy kick hits. The drums are very reverberant, which is probably the reason why they sound softer. It sounds addictive, thanks to those harmonizing vocals, and energetic overall. | 2007-11-12T22:30:12Z | streetsintherain | The video for "Scotty's Lament", made in 1987. | ["Music", "Roll", "Rock and roll"] | ["rock", "passionate male vocal", "harmonizing background male vocal", "electric rhythm guitar chords", "groovy bass", "thin snare", "energetic crash", "shimmering hi hats", "punchy kick hits", "reverberant", "addictive", "energetic"] | 4 | hKSg3zFB2dE | 4095 |
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;