musiccaps_details (view)
1 row where musiccaps_aspects contains "high pitched female whistle tones", musiccaps_aspects contains "male low pitch tones" and "youtube_published" is on date 2010-05-03
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 |
---|---|---|---|---|---|---|---|---|---|---|
Turkish March A Capella | This is a recording of an acapella piece by multiple vocalists. The women sing in a high pitched, whistle-like tone while the men sing in lower tones and harmonise with the women. The melody is rapid and progressive. | 2010-05-03T04:40:02Z | eponce09 | The famous Rondo Alla Turca by Wolfgang Amadeus Mozart in the hands of a couple of bored utep music majors who were happily enjoying their break from practicing..... Enjoy! Check out my other videos by going to my channel! If you like what you see please subscribe! | ["Theremin"] | ["acapella", "harmonies", "high pitched melody", "high pitched female whistle tones", "male low pitch tones"] | 3 | 0L3vcdzQPPU | 149 |
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;