Population Pyramids

One of the most informative sites on the web is:

US Census Bureau’s International Data Base (IDB)

For we graph junkies the dynamic population pyramids on the site are candy.

For example:

US Graphic

I’ve found several fun things at this site:

  • Median ages climb to astounding heights in most of the “advanced” nations by 2050.

    We’re talking median ages in the low 50’s. Heck, the US median age was in the high 20’s in 1975. Look at Nigeria today. 18 or 19. In 2050, Nigeria looks like the US anywhere in the last half-century.

    Keep in mind that for most of human history, the median age was well under 20.

    When you think about swords and sorcerers, middle ages times, think kids. That’s what people of the day were.

  • Certain countries’ pyramids’ 80+ female bars go mondo by 2050.

    Both Japan and Italy were striking before the web site’s pyramid graphics added age ranges up to 100+ years.

    You really notice when a bar for the age of 80+ years is dramatically longer than any of the other bars.

    The median age may be in the low 50’s, but, in a way, the most common person in the country is a woman over 80. I’m thinking that such a country will not be noted for its dynamicism.

  • The US baby boom dies out in favor of the echo generation.

    The turnover year is 2015 (kinda). That’s when the biggest 5-year birth group in the US switches from one in the 1955-1965 range to 1985-1990.

    Keep that in mind when you read opinion pieces about how the US has been on such a thoughtless spending spree and, golly, we have bad times coming to us, if there is a God in heaven.

    A slightly less negative view might be: the US has moved in to a period of child raising that’s at the highest expense level. Anyone who has gone through that period can understand how perhaps a wee bit of spending, painful as it might be for the frugal, is not unexpected.

    My take is the higher education bubble is gonna burst in the next few years.

  • Speaking of dynamicism, look where the centers of the universe go by 2050:

    
    Countries and Areas Ranked by Population: 1950
    --------------------------------------------------------
    Rank Country or Area                          Population
    --------------------------------------------------------
       1 China                                   562,579,779
       2 India                                   369,880,000
       3 United States                           152,271,000
       4 Russia                                  101,936,816
       5 Japan                                    83,805,000
       6 Indonesia                                82,978,392
       7 Germany                                  68,374,572
       8 Brazil                                   53,443,075
       9 United Kingdom                           50,127,000
      10 Italy                                    47,105,000
    --------------------------------------------------------
    Note:  Data updated 12-15-2008 (Release notes).Source: U.S. Census Bureau, International Data Base.
    
    
    Countries and Areas Ranked by Population: 2050
    --------------------------------------------------------
    Rank Country or Area                          Population
    --------------------------------------------------------
       1 India                                 1,807,878,574
       2 China                                 1,424,161,948
       3 United States                           439,010,253
       4 Indonesia                               313,020,847
       5 Pakistan                                295,224,598
       6 Ethiopia                                278,283,137
       7 Nigeria                                 264,262,405
       8 Brazil                                  260,692,493
       9 Bangladesh                              233,587,279
      10 Congo (Kinshasa)                        189,310,849
    --------------------------------------------------------
    Note:  Data updated 12-15-2008 (Release notes).Source: U.S. Census Bureau, International Data Base.
    
            

    There’s a trend to two places: The Indian sub-continent and a kinda central-to-northeast Africa area. That Africa area is bigger than it looks because so many of the countries in that area are little. They don’t make it to the top 10.

  • Down the road, which country looks best, demographically?

    Easy answer: The US.

    The US continues to be an immigrant’s dream. So the demographics stays well balanced ‘tween old and young. The other “advanced” countries end up being hyper-Japans, old folks homes. The big kahuna of the other countries, China, falls off a demographic cliff in a couple decades. China’s median age skyrockets then. Think “greying, 1-child-per-family, spoiled brats”.

Fun stuff.

Techie details:

Apparently, the whole data set is in the WinDOS self-extracting zip file,

idbzip.exe

This file contains binary data and an ancient DOS program to view the data. XP under VMware is not amused. And you won’t be either.

Textually formatted numbers for the web site’s pyramids are hidden behind HTTP POSTs containing a gob of <input type=”hidden”> values. I’ve not done an automated extraction from the site. I did try a simple tzserver send of the Firefox HTTP headers to get numbers, but had no server response. Must have done something wrong.

The numbers behind the pyramid graphs may be had from pages such as (link is to the US):

http://www.census.gov/cgi-bin/ipc/idbpyrs.pl?cty=%%%%%COUNTRY_CODE%%%%%&out=d&ymax=300&submit=Submit+Query.

Better, simpler numbers may be had from data pages such as (link is to the US):

http://www.census.gov/ipc/www/idb/country/%%%%%COUNTRY_CODE%%%%%portal.html

Here is the US table as retrieved from the population pyramid POST.

Here is the US table retrieved from the data page POST.

TellAboutWhere

Spent the last few days exposing to the net some of the odd-ball GPS logic I’ve done for my own amusement in the last year.

Specifically, TellAboutWhere fronts for the alternate route finder, sparsifying, hikifying, and bikifying logic.

More to come, probably. For instance, I’ll probably expose distance measurement, which, if I recall, simply adds up the tracks’ distance between points after the tracks have been sparsified.

Under the hood, TellAboutWhere is kinda cool. The web page CGI script doesn’t do much. It just writes out the uploaded files to a data directory and keeps track of the “file sets” in Python pickle files.

A (soon to be cron started, screened) script runs on “spring” against the uploaded GPS files on the server, “asuka”. Other instances of this background processing script could run on other machines if there were ever any significant traffic to TellAboutWhere. The processing script simply looks at input file names and insures that the various processed, output files exist for them. If a particular logical process doesn’t create any track data – say, hikify finds no hikes in a track – then the processing script creates a zero-length output file as a place-marker so that the logic isn’t done again.

“File sets” are groups of files. File sets make it easy to combine tracks together for alternate route finding.

For alternate route finding purposes, files in a file set may be checked/included or not.

TellAboutWhere keeps itself from being overloaded by only allowing 8 files in a file set. If you upload more than 8 files, TellAboutWhere whacks, first, files that are unchecked, then files at random. Since the input files are stored by (CRC32) hash, duplicate files are automatically eliminated.

Letter to senators

Please vote against the auto bailout.

Here is why I believe that you should vote against making these loans:

  1. You have no safe, viable, honest source for this money.

    Government loans must come from:

    • Taxes – From whom? Higher taxes in down times are not a good idea.
    • Borrowing – We are already too far in hock. And shouldering aside private borrowers by undercutting them is not a recipe for good times.
    • Plunder – Americans do not plunder others.
    • Inflation – Stealing from the fiscally prudent has never been a clever move.
    • Replacing de-leveraged money (that is, printing money without causing inflation) – This is dangerous skirting with real disaster – not the minor stuff we have seen so far. Available financial knowledge (relative lack of transparency) does not allow gross manipulations to be done from a central control point, as has been demonstrated by the current crisis.

  2. Buy the companies!?

    The market caps of these companies is below the loan amount. It’s cheaper to buy the companies. If that doesn’t make sense – and it certainly does not – then how can these loans make sense?
  3. Have you personally loaned money to these companies?

    If not, why not? How can you ethically loan other peoples money on terms you would not take, yourself?
  4. Loans should not be made available to only particular companies.

    Why not make cheap loans available to all of the auto companies? Or all companies? What is special about these companies that they should get a special deal? Even if there is nothing unethical about the deal, there is a clear appearance of corruption of public officials in this bailout. Appearances count.
  5. These loans set a bad example for other countries.

    America has provided leadership to the world. There is no reason we should stop doing so.

    Do transnational companies headquartered in our country deserve a special boost? What do they need to pay to government officials for such special treatment? Does such behavior sound like something we should be doing, as Americans? Can we be surprised or upset if other countries follow the same path?

    If we want to go to economic war with other countries, then we have an easy, crushing win by simply slashing corporate income taxes and opening up H1B and green cards to higher-end foreigners. Do what has worked for every single successful economic unit in post-industrial history: make it easy to start and run a profitable business.

  6. Taxpayers should not be in the auto business.

    There is no reason to expect that either the American citizen at large, taxpayers, or Congress-people have the expertise, time, inclination, or ability to be car builders. I might be highly skilled at my vocation. You might be highly skilled at yours. But that makes neither of us highly skilled at designing, building and selling cars. Let’s not fool ourselves into arrogantly thinking otherwise.

    When we make a loan we had better trust the person we loan to. And we need to verify that they are not frittering away the money. But, we have no business doing their job or calling the shots for them. If the loan requires that we do so, let’s find another place to loan the money.

If there are legal reasons – able to be reversed by congress – that make it impossible for these particular companies to get loans from people who are loaning their own money, then please fix that problem. Please do not try to fix that problem by making another problem.

Let’s address various arguments that could be made for these loans:

  1. These loans will keep a huge number of people employed.


    How? Can these people build a competitive car? If not, then why, exactly do we need to buy their product? If so, then why, exactly, do they need to be treated specially? They can, after all, support themselves by building and selling cars!

  2. These loans keep a key manufacturing capability inside the country.


    How do sweetheart loans to particular multi-national companies do this? Can Americans (or more accurately, American robots) not manufacture competitive cars? And, why is this particular industry so specially needed? We are not currently on schedule to fight WWII again. Why take money that could be spent on beefing up strategic American strengths in cyber-tech or bio-tech (for instance, if we insist on going in hock to bet on particular industries) and fritter it away on the last war’s weapons?

  3. These loans somehow say that the US refuses to fall in to a depression.


    They say the opposite. That last depression was an artificially drawn-out, final transition out of a farming based economy. Do we need another depression, war, and new generation of people to get us mentally out of a manufacturing-based economy? Our economy is no longer based on employment in manufacturing no matter what sentimental, rosy-eyed reactionaries may think.

    Thank God.

    Those “good jobs” in manufacturing were horrible jobs. Ask those who have worked “on the line.” And, please do not make the mistake of selecting a special-case time period (like the late 40’s and 50’s in the US) as a counter example. Those wonderful days of manufacturing look very, very poor compared to the wonderful days of web-programming of the late 90’s internet bubble. Special cases are easy to come by. But they are not examples of how to handle ourselves in other times.

  4. These loans will somehow give confidence to those whose lack of confidence is an impediment to better economic times.


    Who might those unconfident people be?

    • Investors?

      Investors (and I speak as one on the cusp of “retirement age”) are rightfully worried … worried because with all the normal uncertainties that must be dealt with, we must add the uncertainty of a gigantic government floundering around the financial world, taking our savings, side-tracking the fruits of the labor of those who support kids and old folks, and generally providing theater rather than clarity, honesty, and prudence.
    • Others who might make such loans?

      Others who might make loans are certainly not foolish enough to compete against someone with a multi-billion dollar weapons system budget and who, as de-facto world policeman, gets first divvy when loans go bad.

  5. These loans are a great deal.

    Others who might make these loans are charging way, way too much out of fear?

    Right. And we needn’t worry because we, the taxpayers, will find a greater fool.

    We might safely pay attention to someone with a track record of successes in such things, and who makes this argument shortly before piling their own money on to this particular bet. But this argument is notably not made by such people.

    We can safely assume that we, the taxpayers, are in great danger of conning ourselves when we believe this argument.

  6. If the loans are not made, the taxpayer will pay the automakers’ pensions.

    No they won’t. And, sure, some assert otherwise.

    Both “arguments” are simply assertions.

    The WWII generation had a lot of babies to support them in their old age. The early baby boomers did not. Caring for the old folks will be a problem soon. This is a problem that should not be solved piecemeal by handing out goodies to those who use their power to elbow their way to the front of the line.

  7. These loans are a way to inject money in to a money-starved financial system.

    If true, is targetting money toward particular, politically connected recipients the way to do this? Or should the recipients bid for money on equal terms with everyone else?

    Too, what mechanisms are in place to remove this money when the financial system returns to providing the trust they sell for a living.

  8. If we do not make these loans now, we will do something even worse when the new congress takes office.

    The Democratic “branding” of the new congress might suggest this, but such a reality cannot be counted on.

    There has been enough panic and pass-the-buck behavior as it is. Help put a stop to it. A lot of professional financial people are scrambling to shuck their losses. They are doing rather well at this as they have a supply of rubes to take the bag off their hands. Time is on the rubes’ side here. Time for more sober thought. Let that time pass. And do not do the cynical thing and make a foolish move with the idea of blaming the outgoing administration for everything when the move turns sour.

Managing our resources and money is hard enough to do without needing to write legislators in desperate attempts to escape enforced spending.

Please do your part to stop the irrationality and vote these bailouts down.