musiccaps_details (view)
3 rows where "youtube_published" is on date 2007-10-03 sorted by video
This data as json, CSV (advanced)
musiccaps_aspects (array) 32 ✖
- 4 on the floor kick 1
- acoustic drums 1
- acoustic guitar 1
- bass guitar 1
- chill 1
- dj scratching sound effect 1
- dub 1
- e-bass 1
- e-guitar 1
- electric guitar 1
- electro 1
- energetic 1
- energetic crash 1
- flat male vocal 1
- fun 1
- groovy 1
- groovy bass 1
- laid back 1
- live performance 1
- low quality 1
- male and female singer 1
- male vocal 1
- medium to uptempo 1
- messy 1
- muddy 1
- punchy snare 1
- reggae 1
- rock/pop 1
- shimmering hi hats 1
- synth keys melody 1
- tambourine 1
- teen male vocal 1
musiccaps_names (array) 6 ✖
video ▼ | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Bad Boy Bill - BTD - Scratching | The low quality recording features a DJ scratching his vinyl record of an electro song that consists of flat male vocals talking over "4 on the floor" kick, synth keys melody, groovy bass, shimmering hi hats, energetic crash cymbals and punchy snare hits. It sounds muddy and messy, since the frequencies are clashing and since it is probably recorded with a phone. | 2007-10-03T01:01:58Z | djoslo | Bad Boy Bill - BTD - Scratching | ["Scratching (performance technique)", "Music"] | ["low quality", "dj scratching sound effect", "electro", "flat male vocal", "groovy bass", "synth keys melody", "4 on the floor kick", "energetic", "punchy snare", "shimmering hi hats", "energetic crash", "muddy", "messy"] | 4 | 9NJEKpPeWpE | 1000 | |
The Raveonettes -- "That Great Love Sound" | This song contains an acoustic drum playing a kick and snare together on every beat along with a tambourine shaker. An e-bass is playing a distorted bassline. Two e-guitars are playing a modified melody on top of that. A female and male voice are singing together creating harmony. This song may be playing in a live concert. | 2007-10-03T20:40:43Z | DJ Andy Anderson | The Raveonettes performing "That Great Love Sound" live at CBGB in NYC. Produced by Andy Anderson. Directed by Sorrel Ahlfeld. | ["Music", "Independent music", "Scrape"] | ["rock/pop", "e-bass", "e-guitar", "acoustic drums", "tambourine", "male and female singer", "medium to uptempo"] | 6 | JDrnf3vldLw | 1982 | |
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;