musiccaps_details (view)
5 rows where "youtube_published" is on date 2008-07-21 sorted by musiccaps_caption
This data as json, CSV (advanced)
musiccaps_aspects (array) 49 ✖
- male voice 2
- medium tempo 2
- compressed 1
- dance groove 1
- digital drums 1
- digital strings 1
- female vocalist 1
- female voice singing 1
- flute solo melody 1
- folk song 1
- funky bass 1
- groovy bass lines 1
- groovy percussive elements 1
- harmonica 1
- instructive 1
- instrument tutorial 1
- jam block 1
- latin music 1
- latin song 1
- live performance 1
- loud 1
- low quality 1
- mellifluous 1
- mellow 1
- moderate tempo 1
- mystic vibe 1
- noisy 1
- pandeireta rhythm 1
- piano accompaniment 1
- r&b 1
- reggae drums 1
- reggae song 1
- regional music 1
- regional pop 1
- repeated tune 1
- romantic 1
- shaker 1
- sitar guitar melody 1
- slick drumming 1
- soothing 1
- spanish guitar harmony 1
- spanish song 1
- sub bass 1
- sustained strings melody 1
- timbale 1
- triangle 1
- vocal backup 1
- vocal harmony 1
- world music 1
musiccaps_names (array) 9 ✖
video | youtube_link | musiccaps_caption ▼ | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Las Chuches - Amor, amor, amor | A female vocalist sings this romantic song in a foreign language that sounds like Spanish. The tempo is medium with a melodious guitar accompaniment, slick drumming, piano accompaniment, steady bass line and pandeireta rhythm. The song is soft, mellow, catchy, emotional and soothing. This song is a Folk Pop/Regional Pop song. | 2008-07-21T00:44:11Z | Faico90 | Las chuches como siempre derroxando arte | ["Flamenco", "Music", "Music of Latin America"] | ["female vocalist", "medium tempo", "regional pop", "regional music", "folk song", "spanish song", "latin song", "spanish guitar harmony", "groovy bass lines", "slick drumming", "latin music", "piano accompaniment", "pandeireta rhythm", "romantic", "mellifluous", "soothing", "mellow", "world music", "regional music", "dance groove", "vocal backup", "mystic vibe"] | 7 | 7_q36NyJtQY | 863 | |
Palestinian Traditional Music @ GlobalCAFE | The low quality recording features a live performance of percussive elements, sitar guitar melody, sustained strings melody, groovy percussive elements and flute solo melody. The recording is noisy and it sounds compressed and loud. | 2008-07-21T00:38:40Z | Bevin Ginder | Enjoy some Palestinian music from Bethlehem featuring the Oud, the Darbuka and a type of flute.GlobalCAFE is a travel video podcast celebrating people, places, & purpose... join the EPIC! Subscribe to GlobalCAFE for free. | ["Traditional music", "Flamenco", "Music"] | ["low quality", "live performance", "groovy percussive elements", "sitar guitar melody", "sustained strings melody", "flute solo melody", "noisy", "compressed", "loud"] | 4 | hQ5OBio4Cy0 | 4102 | |
Harmonica Lessons: Stone Fox Chase Part 1 | This is an instrument lesson recording. The same tune is being played repeatedly on a harmonica to present a technique on how to play it. The male instructor gives occasional descriptions about the technique. | 2008-07-21T14:00:53Z | Håkan Ehn | Harmonica in the key of A (music in E). Study these tabs. Learn to play the song all harp pros play, for example Adam Gussow, Mark Feltham and Charlie McCoy (Area Code 615). This video shows (see tabs below) how to play the part between 0:00-0:26 in the video STONE FOX CHASE in the tunnel: http://uk.youtube.com/watch?v=tX_OG4Q4bfQ See also Stone Fox Chase Lessons Pt 2: http://uk.youtube.com/watch?v=pxBc5ss2ceQ See also Stone Fox Chase Lessons Pt 3: http://uk.youtube.com/watch?v=n5G7vKicWeo BLOCK A (0:06-0:16) SEGMENT A.1 Draw hole 2 -- bend Draw hole 2 Draw hole 2 Blow hole 1-4 Blow hole 1-4 SEGMENT A.2 Draw hole 2 Draw hole 2 Draw hole 3 -- bend Draw hole 2 Draw hole 2 -- bend Draw hole 1 SEGMENT A.3 (same as A.1, A.5) Draw hole 2 -- bend Draw hole 2 Draw hole 2 Blow hole 1-4 Blow hole 1-4 SEGMENT A.4 Draw hole 4 Draw hole 4 -- bend Blow hole 4 Blow hole 3 Draw hole 3 -- bend SEGMENT A.5 (same as A.1, A3) Draw hole 2 -- bend Draw hole 2 Draw hole 2 Blow hole 1-4 Blow hole 1-4 SEGMENT A.6 Draw hole 2 Draw hole 2 Draw hole 3 -- bend Draw hole 2 Draw hole 2 -- bend SEGMENT A.7 Draw hole 3 -- bend Draw hole 2 Draw hole 2 -- bend Draw hole 3 -- bend Draw hole 2 Draw hole 2 -- bend SEGMENT A.8 Draw hole 3 -- bend Draw hole 2 Draw hole 2 -- bend Draw hole 2 Blow hole 1-4 Blow hole 1-4 BLOCK B (0:16-0:26) Same as Block A, D. BLOCK C (0:26-0:36) SEGMENT C.1 Draw hole 4 Draw hole 4 -- bend Blow hole 4 SEGMENT C.2 Draw hole 2 Draw hole 3 Blow hole 4 Draw hole 4 -- bend Draw hole 3 Blow hole 4 Blow hole 3 Draw hole 3 Draw hole 2 SEGMENT C.3 Draw hole 2 Draw hole 2 -- bend Draw hole 2 Draw hole 3 -- bend Blow hole 1-4 Blow hole 1-4 SEGMENT C.4 (same as C.1) Draw hole 4 Draw hole 4 -- bend Blow hole 4 SEGMENT C.5 (same as C.2) Draw hole 2 Draw hole 3 Blow hole 4 Draw hole 4 -- bend Draw hole 3 Blow hole 4 Blow hole 3 Draw hole 3 Draw hole 2 SEGMENT C.3 Draw hole 2 Draw hole 2 -- bend Draw hole 2 Draw hole 2 -- bend Blow hole… | ["Harmonica", "Wind instrument, woodwind instrument"] | ["instrument tutorial", "harmonica", "repeated tune", "male voice", "instructive"] | 9 | l3YrliBpOdM | 4372 | |
TWILIGHT CIRCUS DUB SOUND SYSTEM - BINGHI RIDDIM (VARIOUS ARTISTS) | This reggae song features a male voice singing the main melody. Another voice is singing in harmony with the main voice. This is accompanied by reggae percussion. A timbale is played on every third count. Jam blocks are also played in the background. The bass plays a funky bassline with a reggae feel. Synth sounds are played in the background. This song can be played in a bar. | 2008-07-21T12:16:12Z | Ryonik | One-riddim album on the Red-Hot 'Binghi Riddim' featuring Jamaican legends Sly Dunbar, Skully & Dean Fraser. Available now on Itunes and http://www.ebreggae.com TRACKLISTING Sugar Minott "Take It Slow" Tampanae "Musical Journey" Lutan Fyah "We Can Make It Work" Gregory Isaacs & Big Star "Touch Not" R.Mony & Johnny Builder "Only Time Will Tell" Daddy Shark "Earth Foundation" Mykal Rose "A Little Bit More" X-Facta "Welcome To The Garrison" Keke-I "Why Do You Fight" Anju Kumbz "Stand Up On Your Feet" Al Pancho & Ken Bob "Last Night" Flourgon "This World" Skully "Binghi Riddim" Check us out at: http://www.myspace.com/twilightcircus http://www.twilightcircus.com 'Wrestles with history's titans & leaves the ring commanding 'nuff respect' - SPIN Mag / Jeff Chang 'Among the best of any current reggae producers in the World' - Tape Op Mag / Larry Crane Ryan Moore has participated in nearly 100 album projects in various genres including work with The Legendary Pink Dots, Skinny Puppy, various Nettwerk Records albums, Sarah McLachlan, The Tear Garden, Keith Levine (P.I.L.), Ted Parsons (Prong), DJ Spooky, Single Gun Theory, Final Cut (Jeff Mills).. The following have worked with Twilight Circus: Sly Dunbar, Robbie Shakespeare, Dean Fraser, Michael Rose (Black Uhuru), Luciano, Mikey General, Big Youth, Skully, Vin Gordon (Bob Marley), Chinna Smith (Ziggy Marley), Eddie 'Tan Tan' Thornton (Aswad), Buttons (UB40), Ansel Collins, Style Scott (Dub Syndicate), Bobby Ellis (Studio One), Admiral Tibet, Jah Stitch, Sugar Minott, Queen Ifrica, Fred Locks, Max Romeo, Gregory Isaacs, Mafia&Fluxy, Cevin Key (Skinny Puppy), DJ Spooky, Mad Professor, Mike Pelanconi (Lily Allen), Steven Stanley, Jack Dangers | ["Drum and bass", "Music", "Reggae"] | ["reggae song", "male voice", "vocal harmony", "reggae drums", "funky bass", "moderate tempo", "shaker", "timbale", "jam block"] | 0 | s1JHUf3Q_F0 | 4911 | |
No Scrubs by TLC [Lyrics] | This song contains a digital drum with a shaker sound and a triangle. A soft sub bass is playing along. In the background you can hear one continuous high tone from a digital string sound. Other strings and a piano are playing a simple repeating melody. The female voice is singing along with backing vocals in the background. This song may be playing loud while driving a car. | 2008-07-21T13:52:45Z | heartbraeker | LYRICS HERE, SUB FOR SUB :) A scrub is a guy that can't get no love from me And is also known as a buster Always talkin' about what he wants And just sits on his broke ass So (no) I don't want your number (no) I don't want to give you mine and (no) I don't want to meet you nowhere (no) I don't want none of your time and (no) [Chorus:] I don't want no scrub A scrub is a guy that can't get no love from me Hanging out the passenger side Of his best friend's ride Trying to holler at me I don't want no scrub A scrub is a guy that can't get no love from me Hanging out the passenger side Of his best friend's ride Trying to holler at me But a scrub is checkin' me But his game is kinda weak And I know that he cannot approach me Cuz I'm lookin' like class and he's lookin' like trash Can't get wit' no deadbeat ass So (no) I don't want your number (no) I don't want to give you mine and (no) I don't want to meet you nowhere (no) I don't want none of your time (no) [Chorus] If you don't have a car and you're walking Oh yes son I'm talking to you If you live at home wit' your momma Oh yes son I'm talking to you (baby) If you have a shorty but you don't show love Oh yes son I'm talking to you Wanna get with me with no money Oh no I don't want no (oh) No scrub No scrub (no no) No scrub (no no no no no) No scrub (no no) No [Chorus] [Chorus] [Chorus] [Chorus] | ["Funk"] | ["r&b", "digital drums", "digital strings", "sub bass", "triangle", "female voice singing", "medium tempo"] | 6 | VP1cB_AVu6c | 2999 |
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;