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
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