musiccaps_details (view)
2 rows where musiccaps_aspects contains "acoustic guitar" and musiccaps_names contains "Roll" sorted by youtube_description
This data as json, CSV (advanced)
musiccaps_aspects (array) 36 ✖
- acoustic guitar · 2 ✖
- banjo 1
- bass guitar 1
- beseeching 1
- chill 1
- country music 1
- country pop 1
- country song 1
- country songs 1
- dub 1
- electric guitar 1
- emotional 1
- fiddle 1
- fun 1
- groovy 1
- keyboard accompaniment 1
- laid back 1
- live performance 1
- male singer 1
- male vocal 1
- mandolin 1
- medium fast tempo 1
- melodic 1
- pleading 1
- prayer 1
- reggae 1
- regional music 1
- request 1
- resonator 1
- rhythmic drumming 1
- sentimental 1
- soft 1
- spirited string arrangement 1
- steady bass 1
- teen male vocal 1
- violin 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description ▼ | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Avenged Sevenfold-Dear God Lyrics | A male vocalist sings this melodious country song. The tempo is medium with rhythmic acoustic guitar, fiddle, resonator, banjo, dobro and mandolin accompaniment, keyboard harmony, steady drumming and straight bass lines. The song is mellow, emotional, prayerful, pleading, sentimental, passionate and melodious. This song is Country Pop. | 2009-12-31T14:57:13Z | ComedyGHN | Avenged Sevenfold - Dear God Lyrics! AMAZING TUNE! SUBSCRIBE ;D | ["Music", "Roll"] | ["male singer", "medium fast tempo", "country song", "pleading", "request", "country pop", "spirited string arrangement", "acoustic guitar", "fiddle", "resonator", "banjo", "mandolin", "violin", "rhythmic drumming", "steady bass", "keyboard accompaniment", "country music", "country songs", "regional music", "soft", "melodic", "prayer", "beseeching", "emotional", "sentimental"] | 7 | OI7S7vaBT4I | 2424 | |
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;