musiccaps_details (view)
1 row where musiccaps_aspects contains "oriental", musiccaps_aspects contains "uptempo" and "youtube_published" is on date 2010-09-14
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 |
---|---|---|---|---|---|---|---|---|---|---|
Carnatic Music - Instrument - Master sathyanarayana keyboard 1 - On 13th Sep 2010 | This music sounds oriental full of semitones and quarter-notes that are used in oriental music. A violin is playing a melody along with the keyboard player also playing a stringsound. Another string instrument is playing along while fast paced, pitched percussion is playing a rhythm with a lot of fill-ins. This song may be played at a live concert or an cultural event representing a country or area of this country. | 2010-09-14T01:33:09Z | kvnvasu | Most gifted child artist playing keybord right from the age of six. Now only studying tenth standard. All music lovers should encourage and help him stay on this music world. when people debate whether it is possible to play carnatic music in keyboard he is playing with so much of ease and that too for more than 10years. He should get the world class awards. just spend few minutes. he already gave more than 700 concerts | ["Carnatic music", "Music"] | ["oriental", "string instrument/violin", "keyboard stringsound", "tabla", "percussion", "uptempo", "very poor recording quality"] | 6 | 9jeEfi6nDak | 1037 |
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;