musiccaps_details (view)
5 rows where "youtube_published" is on date 2008-08-29
This data as json, CSV (advanced)
Suggested facets: musiccaps_author
| video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
|---|---|---|---|---|---|---|---|---|---|---|
| Deep forest - The sound of Africa | The music features a girlish female voice singing a sparse melody. The bass guitar and drums drive the pulse of the music but the drums play a more active role in that regard. Towards the middle of the music excerpt a crescendo leading into an orchestra hit can be heard. After this, a calming synth pad sound can be heard providing harmonic context. | 2008-08-29T21:34:21Z | xalphakirx | Deep forest - The sound of Africa | ["Music", "Television"] | ["drums", "bass guitar", "girlish female voice", "calming synth pad sound", "orchestra hit"] | 2 | 6jZ8VNANHwM | 780 | |
| Ivan Georgiev - Piping Live! 2008 | This music is a Bagpiper Instrumental. The tempo is slow with a droning , chanting melody. The melody of the music has middle eastern influences. The droning sound is incessant and hypnotic. It is charming ,sharp, and captivating. | 2008-08-29T10:50:17Z | Piping Centre | http://www.pipingfestival.co.uk Ivan Georgiev performing at the International Piping Concert during Piping Live! 2008 | ["Bagpipes", "Wind instrument, woodwind instrument"] | ["instrumental", "slow tempo", "deliberate", "loud", "piper", "scottish instrument", "comforting", "sharp", "bagpiper", "double reed instrument", "bellows", "drone pipes", "wind instrument", "irish", "classical", "aerophone", "chanter", "droning", "sharp sounds", "complex harmony", "live performance", "live audience"] | 7 | 7Ht_Vu1D8nc | 823 | |
| DJ Scratching Techniques: Tears, Flares & Orbits : DJ Scratching Techniques: Orbit Scratch With Music | This music is instrumental . The tempo is medium fast with a catchy drumming rhythm and turntable effect with a vocal riff. The music is youthful, engaging, groovy and buoyant. This is a tutorial on DJ scratching techniques. | 2008-08-29T22:56:31Z | ExpertVillage Leaf Group | Practice the orbit scratch while wearing headphones. Learn how to do an orbit scratch with music in this free dj scratching video lesson from a experienced disk jockey and music teacher. | ["Scratching (performance technique)", "Scratch"] | ["instrumental", "medium fast", "scratching", "turn table", "dj", "dj mixer", "vocal riff", "dj scratching techniques", "dj mixer tutorial", "catchy beat", "energetic", "enthusiastic", "youthful"] | 7 | 7LlnLjZOqVI | 835 | |
| R Nikpai In Ghazi Stadium Kabul | This is a traditional south asian song featuring the use of a pair of tablas for percussion, violins and a sitar. On the sitar, a rapid ascending melody is played in eighth notes. The song is played at a medium tempo and suitable for some energetic dancing. | 2008-08-29T12:22:40Z | Aziz Afghan | Watch Rohullah Nikpai in Ghazi Stadium Kabul among his people | ["Tabla", "Drum", "Percussion"] | ["tabla", "rhythmic percussion", "violins", "sitar", "south asian music", "indian music", "traditional south asian music"] | 3 | BTMWpYzpu5g | 1243 | |
| ALBERTO THE MUSIC BOX - BTV MUSIC VIDEO AWARDS 2008 (BalconyTV) | A male beatboxer creates a cool groove with animated sounds like grunting and mouth percussion. The song is medium tempo with no other instrumentation. The song is energetic and passionate. The song has bad audio quality. | 2008-08-29T01:09:19Z | BALCONY | Alberto the Human Beatbox returns for the BalconyTV Music Video Awards 2008. Subscribe to us right now at - http://bit.ly/subscribetoBalconyTV 'Like' us on Facebook - http://Facebook.com/balconytv Follow us on Twitter - http://Twitter.com/balconytv PART 9 BALCONYTV MUSIC VIDEO AWARDS 2008 JUNE 20th 2008 LIVE FROM THE SUGAR CLUB DUBLIN In association with Budvar, The Goethe Institute Dublin, The Sunday World, Captive Advertising, Clarion Hotels. | ["Beatboxing", "Vocal music"] | ["male singer", "beatboxing", "medium tempo", "energetic", "passionate", "live performance", "ambient noises", "beatboxer", "spirited", "animated sounds", "grunting noises", "soloist", "entertainer", "performer", "groovy rhythm", "animated interactions", "bad audio quality"] | 1 | kZPz8ExTzBk | 4329 |
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;