musiccaps_details (view)
1 row where musiccaps_aspects contains "low and high frequencies", musiccaps_author = 6 and musiccaps_names contains "Music"
This data as json, CSV (advanced)
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Edmar Castaneda: NPR Music Tiny Desk Concert | Someone is playing a harp making use of the full register. A bassline, a melody is the mid range and high repetitive note. The whole composition sounds oriental due to a lot of half notes. This song may be playing at a live concert. | 2010-03-12T22:44:18Z | NPR Music | Edmar Castaneda is the sort of musician who isn't afraid to challenge the established order. He's carving out a place for himself in Latin jazz on an instrument you don't often hear in his chosen genre: the Colombian harp. He's adapted intricate traditional fingerpicking techniques to play jazz melodies along with the Afro-Cuban tumbao (bass line). As you can see and hear for yourself in this Tiny Desk Concert, he can switch between rural Colombian dance music and jazz with a twist of his wrist. Literally. His musical vision is so invigorating that he's gaining fans like NEA Jazz Master Paquito D'Rivera, with whom Castaneda has performed. His Web site shows him constantly on the road as a guest artist with other forward thinkers, or with his latest touring trio, which consists of Castaneda, a drummer and a trombonist. Castaneda recently parked himself behind Bob Boilen's desk and crafted a transporting mix of tradition and improvisation. Chances are, you've never heard anything like it. | ["Traditional music", "Music"] | ["oriental", "harp", "low and high frequencies", "medium tempo"] | 6 | 0SNhAKyXtC8 | 170 |
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;