musiccaps_details (view)
3 rows where musiccaps_names contains "Music" and "youtube_published" is on date 2008-07-21
This data as json, CSV (advanced)
musiccaps_aspects (array) 39 ✖
- compressed 1
- dance groove 1
- female vocalist 1
- flute solo melody 1
- folk song 1
- funky bass 1
- groovy bass lines 1
- groovy percussive elements 1
- jam block 1
- latin music 1
- latin song 1
- live performance 1
- loud 1
- low quality 1
- male voice 1
- medium tempo 1
- mellifluous 1
- mellow 1
- moderate tempo 1
- mystic vibe 1
- noisy 1
- pandeireta rhythm 1
- piano accompaniment 1
- reggae drums 1
- reggae song 1
- regional music 1
- regional pop 1
- romantic 1
- shaker 1
- sitar guitar melody 1
- slick drumming 1
- soothing 1
- spanish guitar harmony 1
- spanish song 1
- sustained strings melody 1
- timbale 1
- vocal backup 1
- vocal harmony 1
- world music 1
musiccaps_names (array) 6 ✖
- Music · 3 ✖
- Flamenco 2
- Drum and bass 1
- Music of Latin America 1
- Reggae 1
- Traditional music 1
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 | |
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 |
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;