coderthrow

I am impressed by this, however.. is this not a case of a Human training to act like a computer, and then doing it really well? There is something off about that part.

example output, US Persons by Age-Sex 50+ by Census Tract, nationwide.. exec. time 1230 ms. local, no clouds

  -[ RECORD 221408 ]----+
  mtable_2_pkey         | 18744349
  geoid                 | 08000US361198400084000000900
  geo_name              | Census Tract 9, Yonkers city, 
  Yonkers city, Westchester County, New York
   Total_Population      | 2307
    Male                 | 1085
     male over 50 est.   | 285
    Female               | 1222
     female over 50 est. | 272
  -[ RECORD 221409 ]----+
  mtable_2_pkey         | 18754394
  geoid                 | 08000US421338704887048000900
  geo_name              | Census Tract 9, York city, York city, York County, Pennsylvania
   Total_Population      | 7100
    Male                 | 3934
     male over 50 est.   | 1453
    Female               | 3166
     female over 50 est. | 1347
   -[ RECORD 221410 ]----+
   mtable_2_pkey         | 18776479
   geoid                 | 14000US42133000900
   geo_name              | Census Tract 9, York County, 
   Pennsylvania
   Total_Population      | 1169
    Male                 | 667
     male over 50 est.   | 226
    Female               | 502
     female over 50 est. | 240

I am modelling with American Community Survey complete raw data, physically in Berkeley, California.. using PostGIS, python and an SEIR model; Urban Planning background.. suggestions welcome