musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "fun", musiccaps_aspects contains "groovy" and musiccaps_aspects contains "live performance"
This data as json, CSV (advanced)
musiccaps_aspects (array) 19 ✖
- fun · 2 ✖
- groovy · 2 ✖
- live performance · 2 ✖
- acoustic guitar 1
- bass guitar 1
- chill 1
- dub 1
- electric guitar 1
- electric guitar solo melody 1
- flat male vocal 1
- groovy bass 1
- laid back 1
- low quality 1
- male vocal 1
- reggae 1
- shimmering bright cymbals 1
- simple piano chord progression 1
- snappy rimshot 1
- teen male vocal 1
musiccaps_names (array) 6 ✖
- Music 2
- Punk rock 1
- Rock music 1
- Roll 1
- Salsa music 1
- Singing 1
youtube_published (date) 2 ✖
- 2007-10-03 1
- 2016-07-09 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Si Tus Amigas Te Cuentan || La Timba Criolla || PERÚ MUSIC 2016 || SALSA KING | The low quality recording features a live performance with flat male vocals talking over electric guitar solo melody, shimmering and bright drums cymbals, snappy rimshots, groovy bass and simple piano chord progression. Sounds fun and groovy - like something you would dance to with your friends. | 2016-07-09T20:26:50Z | PERÚ MUSIC | AUDIO EXCELENTE SÍGUENOS EN FACEBOOK COMO PERÚ MUSIC https://www.facebook.com/Per%C3%BA-Music 865450980253654/?fref=ts | ["Music", "Punk rock", "Rock music", "Salsa music"] | ["low quality", "live performance", "electric guitar solo melody", "shimmering bright cymbals", "snappy rimshot", "groovy bass", "simple piano chord progression", "flat male vocal", "groovy", "fun"] | 4 | usrzF-0GbLY | 5141 | |
Musical Youth - Pass The Dutchie live in 1983 (with lyrics) | This is the live performance of a reggae piece. There is a male vocal hollering while a younger sounding male vocal is singing in a Jamaican accent. An electric guitar is strumming chords in staccato while a bass guitar is playing a groovy bass line. In the rhythmic background, there is an acoustic drum playing a reggae beat. The atmosphere is chill. This piece could be played at beach parties and in the soundtracks of summer vacation-themed movies or TV shows. | 2007-10-03T03:19:51Z | reggaeman91 | Facebook: https://www.facebook.com/BobMarleyArchive Website: http://bobmarleyarchive.com/ The song was a cover version of the song "Pass the Kouchie" by The Mighty Diamonds, which deals with the recreational use of cannabis, "kouchie" being slang for a cannabis pipe. For the cover version, the song's title was bowdlerized to "Pass the Dutchie" and all obvious drug references were removed from the lyrics; e. g., when the original croons "How does it feel when you got no herb?", the cover version refers to "food" instead. Musical Youth Pass The Dutchie on stage in 1983 LYRICS : This generation Rules the nation With version Music happen to be the food of love Sounds to really make you rub and scrub I say Pass the Dutchie on the left hand side Pass the Dutchie on the left hand side It a good burn, give me music make me jump and prance It a go done, give me the music make me rock in the dance It was a cool and lovely breezy afternoon (How does it feel when you've got no food) You could feel it 'cause it was the month of June (How does it feel when you've got no food) So I left my gate and went out for a walk (How does it feel when you've got no food) As I pass the dreadlocks' camp I heard them say (How does it feel when you've got no food) Pass the Dutchie on the left hand side Pass the Dutchie on the left hand side It a good burn, give me music make me jump and prance It a go done, give me the music make me rock in the dance So I stopped to find out what was going on (How does it feel when you've got no food) 'Cause the spirit of Jah, you know he leads you on (How does it feel when you've got no food) There was a ring of dreads and a session was there in swing (How does it feel when you've got no food) You could feel the chill as I seen and heard them say (How does it feel when you've got no food) Pass the Dutchie on the left hand side Pass the Dutchie on the left hand side It a good burn, give me music make me jump and prance It a go done, give me the music make me rock in the dance 'Cause me say listen t… | ["Singing", "Music", "Roll"] | ["reggae", "dub", "live performance", "male vocal", "teen male vocal", "electric guitar", "bass guitar", "acoustic guitar", "groovy", "laid back", "fun", "chill"] | 9 | xt6V3Ic72nE | 5359 |
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;