trycrmr / covid-data-loader

A codebase for fetching, transforming, and loading covid datasets
https://coviddata.website
MIT License
0 stars 0 forks source link

Add population data for each location node #7

Open trycrmr opened 4 years ago

trycrmr commented 4 years ago

So far so good. Most locations are accommodated. The following is a list of places that do not have a population mapping to a location node. There could be several reasons why each location doesn't map. Some locations just don't have an reported covid data in the JHU data, for example. Some are purposefully excluded, like the redundant D.C. node. Some, idk. Like, there should be no issues with mapping the South Sudan population to the South Sudan location node. Each would need to be investigated individually. (Except for all the Virginia cities. The U.S. Census treats those a different blocks than the counties. A fix for all those could happen as a mapping of a Virginia city to the county it resides in and sum the two populations.)

No pop for District of Columbia, District of Columbia No pop for Alexandria city, Virginia No pop for Bristol city, Virginia No pop for Buena Vista city, Virginia No pop for Charlottesville city, Virginia No pop for Chesapeake city, Virginia No pop for Colonial Heights city, Virginia No pop for Covington city, Virginia No pop for Danville city, Virginia No pop for Emporia city, Virginia No pop for Fairfax city, Virginia No pop for Falls Church city, Virginia No pop for Franklin city, Virginia No pop for Fredericksburg city, Virginia No pop for Galax city, Virginia No pop for Hampton city, Virginia No pop for Harrisonburg city, Virginia No pop for Hopewell city, Virginia No pop for Lexington city, Virginia No pop for Lynchburg city, Virginia No pop for Manassas city, Virginia No pop for Manassas Park city, Virginia No pop for Martinsville city, Virginia No pop for Newport News city, Virginia No pop for Norfolk city, Virginia No pop for Norton city, Virginia No pop for Petersburg city, Virginia No pop for Poquoson city, Virginia No pop for Portsmouth city, Virginia No pop for Radford city, Virginia No pop for Richmond city, Virginia No pop for Roanoke city, Virginia No pop for Salem city, Virginia No pop for Staunton city, Virginia No pop for Suffolk city, Virginia No pop for Virginia Beach city, Virginia No pop for Waynesboro city, Virginia No pop for Williamsburg city, Virginia No pop for Winchester city, Virginia No pop for Comoros No pop for South Sudan No pop for Democratic Republic of the Congo No pop for Sao Tome and Principe No pop for Eswatini No pop for Lesotho No pop for Saint Helena No pop for Western Sahara No pop for Yemen No pop for Tajikistan No pop for Turkmenistan No pop for Dem. People's Republic of Korea No pop for Saint Martin No pop for Falkland Islands (Malvinas) No pop for Melanesia No pop for Solomon Islands No pop for Vanuatu No pop for Micronesia No pop for Kiribati No pop for Marshall Islands No pop for Micronesia (Fed. States of) No pop for Nauru No pop for Palau No pop for Polynesia No pop for Cook Islands No pop for Niue No pop for Samoa No pop for Tokelau No pop for Tonga No pop for Tuvalu No pop for Wallis and Futuna Islands No pop for Saint Pierre and Miquelon

trycrmr commented 4 years ago

Earth population count is coming up a bit short at 5.9 billion. There could be several factors, not the least of which being the previous comment. Will have to investigate.