open-numbers / ddf--gapminder--systema_globalis

Gapminder's fact-base with local & global statistics
96 stars 81 forks source link

First validation issues (partial): #3

Closed valorkin closed 8 years ago

valorkin commented 8 years ago
  1. dimension time and subdim year are not defined in ddf--dimensions.csv
  2. measure id is life_exp but file name is ddf--data_for--life_expectancy--by--country but should be ddf--data_for--life_exp--by--country same applies to ddf--index.csv
  3. ddf--measures.csv defined 10 measures, but data present only for 7
  4. Missing geo id for some data points
ddf--data_for--population--by--country--year.csv: 300 
Dimension value not found for year [2100], 
row={"country":"afg","geo.name":"Afghanistan","year":2100,"value":57638127}
ddf--data_for--population--by--country--year.csv: 660 
Dimension value not found for year [2100], 
row={"country":"alb","geo.name":"Albania","year":2100,"value":1754540}
ddf--data_for--population--by--country--year.csv: 961 
Dimension value not found for year [2100], 
row={"country":"dza","geo.name":"Algeria","year":2100,"value":61059556}
ddf--data_for--population--by--country--year.csv: 1262 
Dimension value not found for year [2100], 
row={"country":"asm","geo.name":"American Samoa","year":2100,"value":40181}
ddf--data_for--population--by--country--year.csv: 1563 
Dimension value not found for year [2100], 
row={"country":"and","geo.name":"Andorra","year":2100,"value":60252}
ddf--data_for--population--by--country--year.csv: 1864 
Dimension value not found for year [2100], 
row={"country":"ago","geo.name":"Angola","year":2100,"value":138737554}
ddf--data_for--population--by--country--year.csv: 2165 
Dimension value not found for year [2100], 
row={"country":"aia","geo.name":"Anguilla","year":2100,"value":11423}
ddf--data_for--population--by--country--year.csv: 2466 
Dimension value not found for year [2100], 
row={"country":"atg","geo.name":"Antigua and Barbuda","year":2100,"value":113519}
ddf--data_for--population--by--country--year.csv: 2767 
Dimension value not found for year [2100], 
row={"country":"arg","geo.name":"Argentina","year":2100,"value":58572461}
ddf--data_for--population--by--country--year.csv: 3068 
Dimension value not found for year [2100], 
row={"country":"arm","geo.name":"Armenia","year":2100,"value":1793392}
ddf--data_for--population--by--country--year.csv: 3369 
Dimension value not found for year [2100], 
row={"country":"abw","geo.name":"Aruba","year":2100,"value":84011}
ddf--data_for--population--by--country--year.csv: 3670 
Dimension value not found for year [2100], 
row={"country":"aus","geo.name":"Australia","year":2100,"value":42389313}
ddf--data_for--population--by--country--year.csv: 3971 
Dimension value not found for year [2100], 
row={"country":"aut","geo.name":"Austria","year":2100,"value":8334601}
ddf--data_for--population--by--country--year.csv: 4272 
Dimension value not found for year [2100], 
row={"country":"aze","geo.name":"Azerbaijan","year":2100,"value":9635967}
ddf--data_for--population--by--country--year.csv: 4573 
Dimension value not found for year [2100], 
row={"country":"bhs","geo.name":"Bahamas","year":2100,"value":497754}
ddf--data_for--population--by--country--year.csv: 4874 
Dimension value not found for year [2100], 
row={"country":"bhr","geo.name":"Bahrain","year":2100,"value":1602164}
ddf--data_for--population--by--country--year.csv: 5175 
Dimension value not found for year [2100], 
row={"country":"bgd","geo.name":"Bangladesh","year":2100,"value":169540947}
ddf--data_for--population--by--country--year.csv: 5476 
Dimension value not found for year [2100], 
row={"country":"brb","geo.name":"Barbados","year":2100,"value":258887}
ddf--data_for--population--by--country--year.csv: 5777 
Dimension value not found for year [2100], 
row={"country":"blr","geo.name":"Belarus","year":2100,"value":6916140}
ddf--data_for--population--by--country--year.csv: 6078 
Dimension value not found for year [2100], 
row={"country":"bel","geo.name":"Belgium","year":2100,"value":13210190}
ddf--data_for--population--by--country--year.csv: 6379 
Dimension value not found for year [2100], 
row={"country":"blz","geo.name":"Belize","year":2100,"value":676539}
ddf--data_for--population--by--country--year.csv: 6680 
Dimension value not found for year [2100], 
row={"country":"ben","geo.name":"Benin","year":2100,"value":35544113}
ddf--data_for--population--by--country--year.csv: 6981 
Dimension value not found for year [2100], 
row={"country":"bmu","geo.name":"Bermuda","year":2100,"value":41791}
ddf--data_for--population--by--country--year.csv: 7282 
Dimension value not found for year [2100], 
row={"country":"btn","geo.name":"Bhutan","year":2100,"value":792598}
ddf--data_for--population--by--country--year.csv: 7583 
Dimension value not found for year [2100], 
row={"country":"bol","geo.name":"Bolivia","year":2100,"value":18117876}
ddf--data_for--population--by--country--year.csv: 7884 
Dimension value not found for year [2100], 
row={"country":"bih","geo.name":"Bosnia and Herzegovina","year":2100,"value":1919196}
ddf--data_for--population--by--country--year.csv: 8185 
Dimension value not found for year [2100], 
row={"country":"bwa","geo.name":"Botswana","year":2100,"value":3680506}
ddf--data_for--population--by--country--year.csv: 8486 
Dimension value not found for year [2100], 
row={"country":"bra","geo.name":"Brazil","year":2100,"value":200305426}
ddf--data_for--population--by--country--year.csv: 8787 
Dimension value not found for year [2100], 
row={"country":"vgb","geo.name":"British Virgin Islands","year":2100,"value":35943}
ddf--data_for--population--by--country--year.csv: 9088 
Dimension value not found for year [2100], 
row={"country":"brn","geo.name":"Brunei","year":2100,"value":488763}
ddf--data_for--population--by--country--year.csv: 9389 
Dimension value not found for year [2100], 
row={"country":"bgr","geo.name":"Bulgaria","year":2100,"value":3406196}
ddf--data_for--population--by--country--year.csv: 9690 
Dimension value not found for year [2100], 
row={"country":"bfa","geo.name":"Burkina Faso","year":2100,"value":80990015}
ddf--data_for--population--by--country--year.csv: 9991 
Dimension value not found for year [2100], 
row={"country":"bdi","geo.name":"Burundi","year":2100,"value":62661944}
ddf--data_for--population--by--country--year.csv: 10292 
Dimension value not found for year [2100], 
row={"country":"khm","geo.name":"Cambodia","year":2100,"value":23927575}
ddf--data_for--population--by--country--year.csv: 10593 
Dimension value not found for year [2100], 
row={"country":"cmr","geo.name":"Cameroon","year":2100,"value":82381564}
ddf--data_for--population--by--country--year.csv: 10894 
Dimension value not found for year [2100], 
row={"country":"can","geo.name":"Canada","year":2100,"value":49668203}
ddf--data_for--population--by--country--year.csv: 11195 
Dimension value not found for year [2100], 
row={"country":"cpv","geo.name":"Cape Verde","year":2100,"value":679782}
ddf--data_for--population--by--country--year.csv: 11496 
Dimension value not found for year [2100], 
row={"country":"cym","geo.name":"Cayman Islands","year":2100,"value":99441}
ddf--data_for--population--by--country--year.csv: 11797 
Dimension value not found for year [2100], 
row={"country":"caf","geo.name":"Central African Republic","year":2100,"value":12515130}
ddf--data_for--population--by--country--year.csv: 12098 
Dimension value not found for year [2100], 
row={"country":"tcd","geo.name":"Chad","year":2100,"value":68926529}
ddf--data_for--population--by--country--year.csv: 12399 
Dimension value not found for year [2100], 
row={"country":"chanisl","geo.name":"Channel Islands","year":2100,"value":182049}
ddf--data_for--population--by--country--year.csv: 12700 
Dimension value not found for year [2100], 
row={"country":"chl","geo.name":"Chile","year":2100,"value":19744336}
ddf--data_for--population--by--country--year.csv: 13001 
Dimension value not found for year [2100], 
row={"country":"chn","geo.name":"China","year":2100,"value":1004391965}
ddf--data_for--population--by--country--year.csv: 13424 
Dimension value not found for year [2100], 
row={"country":"col","geo.name":"Colombia","year":2100,"value":45320996}
ddf--data_for--population--by--country--year.csv: 13725 
Dimension value not found for year [2100], 
row={"country":"com","geo.name":"Comoros","year":2100,"value":2307116}
ddf--data_for--population--by--country--year.csv: 14026 
Dimension value not found for year [2100], 
row={"country":"cod","geo.name":"Congo, Dem. Rep.","year":2100,"value":388732857}
ddf--data_for--population--by--country--year.csv: 14327 
Dimension value not found for year [2100], 
row={"country":"cog","geo.name":"Congo, Rep.","year":2100,"value":22015104}
ddf--data_for--population--by--country--year.csv: 14628 
Dimension value not found for year [2100], 
row={"country":"cok","geo.name":"Cook Is","year":2100,"value":20521}
ddf--data_for--population--by--country--year.csv: 14929 
Dimension value not found for year [2100], 
row={"country":"cri","geo.name":"Costa Rica","year":2100,"value":4992715}
ddf--data_for--population--by--country--year.csv: 15230 
Dimension value not found for year [2100], 
row={"country":"civ","geo.name":"Cote d'Ivoire","year":2100,"value":101154138}
ddf--data_for--population--by--country--year.csv: 15531 
Dimension value not found for year [2100], 
row={"country":"hrv","geo.name":"Croatia","year":2100,"value":2615079}
ddf--data_for--population--by--country--year.csv: 15832 
Dimension value not found for year [2100], 
row={"country":"cub","geo.name":"Cuba","year":2100,"value":7102699}
ddf--data_for--population--by--country--year.csv: 16133 
Dimension value not found for year [2100], 
row={"country":"cyp","geo.name":"Cyprus","year":2100,"value":1385983}
ddf--data_for--population--by--country--year.csv: 16434 
Dimension value not found for year [2100], 
row={"country":"cze","geo.name":"Czech Republic","year":2100,"value":8774446}
ddf--data_for--population--by--country--year.csv: 16794 
Dimension value not found for year [2100], 
row={"country":"dnk","geo.name":"Denmark","year":2100,"value":6837645}
ddf--data_for--population--by--country--year.csv: 17095 
Dimension value not found for year [2100], 
row={"country":"dji","geo.name":"Djibouti","year":2100,"value":1126340}
ddf--data_for--population--by--country--year.csv: 17396 
Dimension value not found for year [2100], 
row={"country":"dma","geo.name":"Dominica","year":2100,"value":52410}
ddf--data_for--population--by--country--year.csv: 17697 
Dimension value not found for year [2100], 
row={"country":"dom","geo.name":"Dominican Republic","year":2100,"value":12026969}
ddf--data_for--population--by--country--year.csv: 18057 
Dimension value not found for year [2100], 
row={"country":"ecu","geo.name":"Ecuador","year":2100,"value":24499128}
ddf--data_for--population--by--country--year.csv: 18358 
Dimension value not found for year [2100], 
row={"country":"egy","geo.name":"Egypt","year":2100,"value":200802291}
ddf--data_for--population--by--country--year.csv: 18659 
Dimension value not found for year [2100], 
row={"country":"slv","geo.name":"El Salvador","year":2100,"value":4419633}
ddf--data_for--population--by--country--year.csv: 18960 
Dimension value not found for year [2100], 
row={"country":"gnq","geo.name":"Equatorial Guinea","year":2100,"value":2984458}
ddf--data_for--population--by--country--year.csv: 19261 
Dimension value not found for year [2100], 
row={"country":"eri","geo.name":"Eritrea","year":2100,"value":15615700}
ddf--data_for--population--by--country--year.csv: 19621 
Dimension value not found for year [2100], 
row={"country":"est","geo.name":"Estonia","year":2100,"value":903682}
ddf--data_for--population--by--country--year.csv: 19922 
Dimension value not found for year [2100], 
row={"country":"eth","geo.name":"Ethiopia","year":2100,"value":242644125}
ddf--data_for--population--by--country--year.csv: 20223 
Dimension value not found for year [2100], 
row={"country":"fro","geo.name":"Faeroe Islands","year":2100,"value":52348}
ddf--data_for--population--by--country--year.csv: 20524 
Dimension value not found for year [2100], 
row={"country":"flk","geo.name":"Falkland Is (Malvinas)","year":2100,"value":2653}
ddf--data_for--population--by--country--year.csv: 20825 
Dimension value not found for year [2100], 
row={"country":"fji","geo.name":"Fiji","year":2100,"value":695572}
ddf--data_for--population--by--country--year.csv: 21126 
Dimension value not found for year [2100], 
row={"country":"fin","geo.name":"Finland","year":2100,"value":5856914}
ddf--data_for--population--by--country--year.csv: 21427 
Dimension value not found for year [2100], 
row={"country":"fra","geo.name":"France","year":2100,"value":75998378}
ddf--data_for--population--by--country--year.csv: 21728 
Dimension value not found for year [2100], 
row={"country":"guf","geo.name":"French Guiana","year":2100,"value":891128}
ddf--data_for--population--by--country--year.csv: 22029 
Dimension value not found for year [2100], 
row={"country":"pyf","geo.name":"French Polynesia","year":2100,"value":296811}
ddf--data_for--population--by--country--year.csv: 22330 
Dimension value not found for year [2100], 
row={"country":"gab","geo.name":"Gabon","year":2100,"value":4465737}
ddf--data_for--population--by--country--year.csv: 22631 
Dimension value not found for year [2100], 
row={"country":"gmb","geo.name":"Gambia","year":2100,"value":8895595}
ddf--data_for--population--by--country--year.csv: 22932 
Dimension value not found for year [2100], 
row={"country":"geo","geo.name":"Georgia","year":2100,"value":2438210}
ddf--data_for--population--by--country--year.csv: 23233 
Dimension value not found for year [2100], 
row={"country":"deu","geo.name":"Germany","year":2100,"value":63244431}
ddf--data_for--population--by--country--year.csv: 23534 
Dimension value not found for year [2100], 
row={"country":"gha","geo.name":"Ghana","year":2100,"value":73032615}
ddf--data_for--population--by--country--year.csv: 23835 
Dimension value not found for year [2100], 
row={"country":"gib","geo.name":"Gibraltar","year":2100,"value":28248}
ddf--data_for--population--by--country--year.csv: 24136 
Dimension value not found for year [2100], 
row={"country":"grc","geo.name":"Greece","year":2100,"value":7392853}
ddf--data_for--population--by--country--year.csv: 24437 
Dimension value not found for year [2100], 
row={"country":"grl","geo.name":"Greenland","year":2100,"value":41220}
ddf--data_for--population--by--country--year.csv: 24738 
Dimension value not found for year [2100], 
row={"country":"grd","geo.name":"Grenada","year":2100,"value":72031}
ddf--data_for--population--by--country--year.csv: 25039 
Dimension value not found for year [2100], 
row={"country":"glp","geo.name":"Guadeloupe","year":2100,"value":436998}
ddf--data_for--population--by--country--year.csv: 25340 
Dimension value not found for year [2100], 
row={"country":"gum","geo.name":"Guam","year":2100,"value":241802}
ddf--data_for--population--by--country--year.csv: 25641 
Dimension value not found for year [2100], 
row={"country":"gtm","geo.name":"Guatemala","year":2100,"value":34811814}
ddf--data_for--population--by--country--year.csv: 26001 
Dimension value not found for year [2100], 
row={"country":"gin","geo.name":"Guinea","year":2100,"value":49049252}
ddf--data_for--population--by--country--year.csv: 26302 
Dimension value not found for year [2100], 
row={"country":"gnb","geo.name":"Guinea-Bissau","year":2100,"value":5489322}
ddf--data_for--population--by--country--year.csv: 26603 
Dimension value not found for year [2100], 
row={"country":"guy","geo.name":"Guyana","year":2100,"value":594940}
ddf--data_for--population--by--country--year.csv: 26904 
Dimension value not found for year [2100], 
row={"country":"hti","geo.name":"Haiti","year":2100,"value":13543750}
ddf--data_for--population--by--country--year.csv: 27205 
Dimension value not found for year [2100], 
row={"country":"hos","geo.name":"Holy See","year":2100,"value":825}
ddf--data_for--population--by--country--year.csv: 27506 
Dimension value not found for year [2100], 
row={"country":"hnd","geo.name":"Honduras","year":2100,"value":10646275}
ddf--data_for--population--by--country--year.csv: 27807 
Dimension value not found for year [2100], 
row={"country":"hkg","geo.name":"Hong Kong, China","year":2100,"value":7923581}
ddf--data_for--population--by--country--year.csv: 28108 
Dimension value not found for year [2100], 
row={"country":"hun","geo.name":"Hungary","year":2100,"value":6505919}
ddf--data_for--population--by--country--year.csv: 28409 
Dimension value not found for year [2100], 
row={"country":"isl","geo.name":"Iceland","year":2100,"value":384260}
ddf--data_for--population--by--country--year.csv: 28710 
Dimension value not found for year [2100], 
row={"country":"ind","geo.name":"India","year":2100,"value":1659785948}
ddf--data_for--population--by--country--year.csv: 29011 
Dimension value not found for year [2100], 
row={"country":"idn","geo.name":"Indonesia","year":2100,"value":313648122}
ddf--data_for--population--by--country--year.csv: 29312 
Dimension value not found for year [2100], 
row={"country":"irn","geo.name":"Iran","year":2100,"value":69636604}
ddf--data_for--population--by--country--year.csv: 29613 
Dimension value not found for year [2100], 
row={"country":"irq","geo.name":"Iraq","year":2100,"value":163904640}
ddf--data_for--population--by--country--year.csv: 29914 
Dimension value not found for year [2100], 
row={"country":"irl","geo.name":"Ireland","year":2100,"value":6371663}
ddf--data_for--population--by--country--year.csv: 30215 
Dimension value not found for year [2100], 
row={"country":"gbm","geo.name":"Isle of Man","year":2100,"value":114104}
ddf--data_for--population--by--country--year.csv: 30516 
Dimension value not found for year [2100], 
row={"country":"isr","geo.name":"Israel","year":2100,"value":17284729}
ddf--data_for--population--by--country--year.csv: 30817 
Dimension value not found for year [2100], 
row={"country":"ita","geo.name":"Italy","year":2100,"value":49647236}
ddf--data_for--population--by--country--year.csv: 31118 
Dimension value not found for year [2100], 
row={"country":"jam","geo.name":"Jamaica","year":2100,"value":1704393}
ddf--data_for--population--by--country--year.csv: 31419 
Dimension value not found for year [2100], 
row={"country":"jpn","geo.name":"Japan","year":2100,"value":83174944}
ddf--data_for--population--by--country--year.csv: 31779 
Dimension value not found for year [2100], 
row={"country":"jor","geo.name":"Jordan","year":2100,"value":14147030}
ddf--data_for--population--by--country--year.csv: 32080 
Dimension value not found for year [2100], 
row={"country":"kaz","geo.name":"Kazakhstan","year":2100,"value":24711905}
ddf--data_for--population--by--country--year.csv: 32381 
Dimension value not found for year [2100], 
row={"country":"ken","geo.name":"Kenya","year":2100,"value":156856158}
ddf--data_for--population--by--country--year.csv: 32682 
Dimension value not found for year [2100], 
row={"country":"kir","geo.name":"Kiribati","year":2100,"value":243886}
ddf--data_for--population--by--country--year.csv: 32983 
Dimension value not found for year [2100], 
row={"country":"prk","geo.name":"North Korea","year":2100,"value":24841885}
ddf--data_for--population--by--country--year.csv: 33284 
Dimension value not found for year [2100], 
row={"country":"kor","geo.name":"South Korea","year":2100,"value":38503824}
ddf--data_for--population--by--country--year.csv: 33703 
Dimension value not found for year [2100], 
row={"country":"kwt","geo.name":"Kuwait","year":2100,"value":6484228}
ddf--data_for--population--by--country--year.csv: 34004 
Dimension value not found for year [2100], 
row={"country":"kgz","geo.name":"Kyrgyz Republic","year":2100,"value":9046465}
ddf--data_for--population--by--country--year.csv: 34305 
Dimension value not found for year [2100], 
row={"country":"lao","geo.name":"Lao","year":2100,"value":10410745}
ddf--data_for--population--by--country--year.csv: 34606 
Dimension value not found for year [2100], 
row={"country":"lva","geo.name":"Latvia","year":2100,"value":1278130}
ddf--data_for--population--by--country--year.csv: 34907 
Dimension value not found for year [2100], 
row={"country":"lbn","geo.name":"Lebanon","year":2100,"value":4741160}
ddf--data_for--population--by--country--year.csv: 35208 
Dimension value not found for year [2100], 
row={"country":"lso","geo.name":"Lesotho","year":2100,"value":3547585}
ddf--data_for--population--by--country--year.csv: 35509 
Dimension value not found for year [2100], 
row={"country":"lbr","geo.name":"Liberia","year":2100,"value":15977002}
ddf--data_for--population--by--country--year.csv: 35810 
Dimension value not found for year [2100], 
row={"country":"lby","geo.name":"Libya","year":2100,"value":8143875}
ddf--data_for--population--by--country--year.csv: 36111 
Dimension value not found for year [2100], 
row={"country":"lie","geo.name":"Liechtenstein","year":2100,"value":46531}
ddf--data_for--population--by--country--year.csv: 36412 
Dimension value not found for year [2100], 
row={"country":"ltu","geo.name":"Lithuania","year":2100,"value":2012601}
ddf--data_for--population--by--country--year.csv: 36713 
Dimension value not found for year [2100], 
row={"country":"lux","geo.name":"Luxembourg","year":2100,"value":1029593}
ddf--data_for--population--by--country--year.csv: 37014 
Dimension value not found for year [2100], 
row={"country":"mac","geo.name":"Macao, China","year":2100,"value":1022999}
ddf--data_for--population--by--country--year.csv: 37315 
Dimension value not found for year [2100], 
row={"country":"mkd","geo.name":"Macedonia, FYR","year":2100,"value":1487155}
ddf--data_for--population--by--country--year.csv: 37616 
Dimension value not found for year [2100], 
row={"country":"mdg","geo.name":"Madagascar","year":2100,"value":105499410}
ddf--data_for--population--by--country--year.csv: 37917 
Dimension value not found for year [2100], 
row={"country":"mwi","geo.name":"Malawi","year":2100,"value":87055526}
ddf--data_for--population--by--country--year.csv: 38218 
Dimension value not found for year [2100], 
row={"country":"mys","geo.name":"Malaysia","year":2100,"value":40777950}
ddf--data_for--population--by--country--year.csv: 38519 
Dimension value not found for year [2100], 
row={"country":"mdv","geo.name":"Maldives","year":2100,"value":437888}
ddf--data_for--population--by--country--year.csv: 38820 
Dimension value not found for year [2100], 
row={"country":"mli","geo.name":"Mali","year":2100,"value":92980533}
ddf--data_for--population--by--country--year.csv: 39121 
Dimension value not found for year [2100], 
row={"country":"mlt","geo.name":"Malta","year":2100,"value":348345}
ddf--data_for--population--by--country--year.csv: 39422 
Dimension value not found for year [2100], 
row={"country":"mhl","geo.name":"Marshall Islands","year":2100,"value":75226}
ddf--data_for--population--by--country--year.csv: 39723 
Dimension value not found for year [2100], 
row={"country":"mtq","geo.name":"Martinique","year":2100,"value":289394}
ddf--data_for--population--by--country--year.csv: 40024 
Dimension value not found for year [2100], 
row={"country":"mrt","geo.name":"Mauritania","year":2100,"value":13058616}
ddf--data_for--population--by--country--year.csv: 40325 
Dimension value not found for year [2100], 
row={"country":"mus","geo.name":"Mauritius","year":2100,"value":951897}
ddf--data_for--population--by--country--year.csv: 40626 
Dimension value not found for year [2100], 
row={"country":"myt","geo.name":"Mayotte","year":2100,"value":751663}
ddf--data_for--population--by--country--year.csv: 40927 
Dimension value not found for year [2100], 
row={"country":"mex","geo.name":"Mexico","year":2100,"value":148404092}
ddf--data_for--population--by--country--year.csv: 41228 
Dimension value not found for year [2100], 
row={"country":"fsm","geo.name":"Micronesia, Fed. Sts.","year":2100,"value":116242}
ddf--data_for--population--by--country--year.csv: 41529 
Dimension value not found for year [2100], 
row={"country":"mda","geo.name":"Moldova","year":2100,"value":1855779}
ddf--data_for--population--by--country--year.csv: 41830 
Dimension value not found for year [2100], 
row={"country":"mco","geo.name":"Monaco","year":2100,"value":55147}
ddf--data_for--population--by--country--year.csv: 42131 
Dimension value not found for year [2100], 
row={"country":"mng","geo.name":"Mongolia","year":2100,"value":4487343}
ddf--data_for--population--by--country--year.csv: 42432 
Dimension value not found for year [2100], 
row={"country":"mne","geo.name":"Montenegro","year":2100,"value":436851}
ddf--data_for--population--by--country--year.csv: 42733 
Dimension value not found for year [2100], 
row={"country":"msr","geo.name":"Montserrat","year":2100,"value":4707}
ddf--data_for--population--by--country--year.csv: 43034 
Dimension value not found for year [2100], 
row={"country":"mar","geo.name":"Morocco","year":2100,"value":40887821}
ddf--data_for--population--by--country--year.csv: 43335 
Dimension value not found for year [2100], 
row={"country":"moz","geo.name":"Mozambique","year":2100,"value":127648245}
ddf--data_for--population--by--country--year.csv: 43636 
Dimension value not found for year [2100], 
row={"country":"mmr","geo.name":"Myanmar","year":2100,"value":56025861}
ddf--data_for--population--by--country--year.csv: 43937 
Dimension value not found for year [2100], 
row={"country":"nam","geo.name":"Namibia","year":2100,"value":5730479}
ddf--data_for--population--by--country--year.csv: 44238 
Dimension value not found for year [2100], 
row={"country":"nru","geo.name":"Nauru","year":2100,"value":8657}
ddf--data_for--population--by--country--year.csv: 44539 
Dimension value not found for year [2100], 
row={"country":"npl","geo.name":"Nepal","year":2100,"value":29677239}
ddf--data_for--population--by--country--year.csv: 44840 
Dimension value not found for year [2100], 
row={"country":"nld","geo.name":"Netherlands","year":2100,"value":17220279}
ddf--data_for--population--by--country--year.csv: 45205 
Dimension value not found for year [2100], 
row={"country":"ncl","geo.name":"New Caledonia","year":2100,"value":419125}
ddf--data_for--population--by--country--year.csv: 45506 
Dimension value not found for year [2100], 
row={"country":"nzl","geo.name":"New Zealand","year":2100,"value":6094185}
ddf--data_for--population--by--country--year.csv: 45807 
Dimension value not found for year [2100], 
row={"country":"nic","geo.name":"Nicaragua","year":2100,"value":6996143}
ddf--data_for--population--by--country--year.csv: 46108 
Dimension value not found for year [2100], 
row={"country":"ner","geo.name":"Niger","year":2100,"value":209334454}
ddf--data_for--population--by--country--year.csv: 46409 
Dimension value not found for year [2100], 
row={"country":"nga","geo.name":"Nigeria","year":2100,"value":752247359}
ddf--data_for--population--by--country--year.csv: 46710 
Dimension value not found for year [2100], 
row={"country":"niu","geo.name":"Niue","year":2100,"value":1721}
ddf--data_for--population--by--country--year.csv: 47070 
Dimension value not found for year [2100], 
row={"country":"mnp","geo.name":"Northern Mariana Islands","year":2100,"value":28889}
ddf--data_for--population--by--country--year.csv: 47371 
Dimension value not found for year [2100], 
row={"country":"nor","geo.name":"Norway","year":2100,"value":7844904}
ddf--data_for--population--by--country--year.csv: 47672 
Dimension value not found for year [2100], 
row={"country":"omn","geo.name":"Oman","year":2100,"value":5750633}
ddf--data_for--population--by--country--year.csv: 47973 
Dimension value not found for year [2100], 
row={"country":"pak","geo.name":"Pakistan","year":2100,"value":364282652}
ddf--data_for--population--by--country--year.csv: 48274 
Dimension value not found for year [2100], 
row={"country":"plw","geo.name":"Palau","year":2100,"value":29322}
ddf--data_for--population--by--country--year.csv: 48575 
Dimension value not found for year [2100], 
row={"country":"pan","geo.name":"Panama","year":2100,"value":6011897}
ddf--data_for--population--by--country--year.csv: 48876 
Dimension value not found for year [2100], 
row={"country":"png","geo.name":"Papua New Guinea","year":2100,"value":17950871}
ddf--data_for--population--by--country--year.csv: 49177 
Dimension value not found for year [2100], 
row={"country":"pry","geo.name":"Paraguay","year":2100,"value":8665206}
ddf--data_for--population--by--country--year.csv: 49478 
Dimension value not found for year [2100], 
row={"country":"per","geo.name":"Peru","year":2100,"value":41556796}
ddf--data_for--population--by--country--year.csv: 49779 
Dimension value not found for year [2100], 
row={"country":"phl","geo.name":"Philippines","year":2100,"value":168618220}
ddf--data_for--population--by--country--year.csv: 50141 
Dimension value not found for year [2100], 
row={"country":"pol","geo.name":"Poland","year":2100,"value":22288717}
ddf--data_for--population--by--country--year.csv: 50442 
Dimension value not found for year [2100], 
row={"country":"prt","geo.name":"Portugal","year":2100,"value":7406588}
ddf--data_for--population--by--country--year.csv: 50743 
Dimension value not found for year [2100], 
row={"country":"pri","geo.name":"Puerto Rico","year":2100,"value":2212136}
ddf--data_for--population--by--country--year.csv: 51044 
Dimension value not found for year [2100], 
row={"country":"qat","geo.name":"Qatar","year":2100,"value":3170216}
ddf--data_for--population--by--country--year.csv: 51345 
Dimension value not found for year [2100], 
row={"country":"reu","geo.name":"Reunion","year":2100,"value":869952}
ddf--data_for--population--by--country--year.csv: 51646 
Dimension value not found for year [2100], 
row={"country":"rou","geo.name":"Romania","year":2100,"value":10700428}
ddf--data_for--population--by--country--year.csv: 51947 
Dimension value not found for year [2100], 
row={"country":"rus","geo.name":"Russia","year":2100,"value":117444757}
ddf--data_for--population--by--country--year.csv: 52248 
Dimension value not found for year [2100], 
row={"country":"rwa","geo.name":"Rwanda","year":2100,"value":25691928}
olarosling commented 8 years ago

Number 3 is a no-issue: ddf--measures.csv defined 10 measures, but data present only for 7 A ddf-dataset should be valid with measures that are not used in datapoints. A viz-that wants to show data, should be able to ask for availability based on the ddf--index.csv, which will only mensions measures that have datapoints. So to populate a measure-dropdown on a axis for example: the query should not ask for "all measures" but for all measures with a datapoint for the current subdimension or dumension used for markers...

olarosling commented 8 years ago

Didn't mean to close it

valorkin commented 8 years ago

ok, so validator should at least give warning (notification) about empty measures

olarosling commented 8 years ago

Yes, but it's not crucial. You can skip it for some time. the ddf--gapminder--ontology is a dataset with all our measures but not a single data-point. And that's perfectly fine.

valorkin commented 8 years ago

There are some more things found: missing geo values:

Need to add missing 'country' dimension values: 'sen,srb,syc,sle,sgp,svk,svn,slb,som,zaf,esp,lka,sdn,sur,swz,swe,che,syr,twn,tjk,tza,tha,tls,tgo,ton,tto,tun,tur,tkm,tca,tuv,uga,ukr,are,gbr,usa,ury,uzb,vut,ven,pse,vnm,yem,zmb,zwe,ssd,sxm'
Need to add missing 'country' dimension values: 'tkl,esh,vir,ala'

in ddf--data_for--population--by--world_4region--year.csv there datapoints with geo gaps (witt out geo.id)

olarosling commented 8 years ago

Please observe: country is not a dimensions, but a subdimension I think all of these have been solved with my recent commit: https://github.com/open-numbers/ddf--gapminder--systema_globalis/commit/43acf5006c1f17938317a1078088247451ec0e5f

valorkin commented 8 years ago

As for now I treat country or any sub-dimension as dimension for simplicity, doesn't meant anything special just dimension with parent dimension