musiccaps_details (view)
1 row where musiccaps_aspects contains "glockenspiel", musiccaps_aspects contains "slow rock", musiccaps_aspects contains "two acoustic guitars strumming" and musiccaps_aspects contains "wide panned"
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 |
---|---|---|---|---|---|---|---|---|---|---|
Top 25 prettiest natural places on Earth | Melancholic Instrumental music with wide panned acoustic guitars strumming, glockenspiel or bells following the chord progression, and a syncopated electric bass guitar over a slow rock beat that fades into simple steady solo piano. | 2012-05-04T21:30:04Z | WaynesVDOs | ***before you write comment to complain or to correct, read below first*** Edit Aug 11, 2013: Frequently Asked Questions: Q) DId you know Colombia was mispelled, gringo tonto?!! A) I realised that, pardon. Q) If you were to redo you list, are there any places you would have added or ranked higher? A) Palawan in Phillipines, The Faroe Islands, New Zealand Geothermal region (near Rotorua), Lofoten Island, Zhangye Danxia in China (google this). Q) You realize you left out Machu Picchu? A) Over-rated! Over-rated! just kidding, it's not made by Mother Nature. Q) Why isnt Greece/Nepal in your video. Me and my countrymen will harass you untill you add our beloved countries. A) I noticed there are a lot of people from these two countries patrolling youtube and flaming any videos that left out their country. Greece and Nepal are beautiful countries with rich history. Places like Meteora/Santorini or Taktsang/Bhaktapur are breathtaking. However, these places are man made and do not belong in my video! However, I generously have Greek Coast at #37 and Southern Himalayas at #48. I have respect for your countries, so please don't harass me. Q). You seemed to be biased toward China! *points fingers at me* A). On one hand, if I were to redo the list, I probably would have moved down Huangshan. On the other hand, despite what's in the video, I have left out more worthwhile places in China than any other country. Just google "China Danxia" (6 unique areas of scenery throughout China group together as one unesco heritage site), "yunnan Province Scenery/stone forest", Guizhou Province, "longhu mountain", etc etc,. Q) What is song #12 and #15 A) Run by Snow Patrol and Resistance by Muse Q) Can we have a list of all the songs? A) No I'm too lazy. But 10 of the 25 songs are by the Cure, greatest band in History. Q) Where is Angel Falls, Bora Bora, Grand Canyon, Milford Sound, Halong Bay? A) They are covered in the video under other names, look again... Q) Where is Serengeti, Galapagos, Redwoods, Sequoia, Socotra?!? A) This… | ["Music", "Happy music"] | ["slow rock", "melancholy", "two acoustic guitars strumming", "wide panned", "simple steady solo piano", "fade out", "glockenspiel", "bells", "syncopated electric bass guitar", "instrumental"] | 8 | KpRHRh9PaRU | 2122 |
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;