A list of manipulations that would be interesting for provincial and national datasets. Some would require separate calculation outside of ArcView (using Excel and then reimporting to ArcView)
Sex ratio and H size by residence
a10101 Persons per inclusive H a102/101
02 Sex ratio of total P a103/104
03 Residents of urban wards: Persons per inclusive H a106/105
04 " " " : Sex ratio a107/108
05 Villagers: H size a110/109
06 " : Sex ratio a111/112
07 Other non-urban residents: Persons per inclusive H a114/113
08 " " " : Sex ratio a115/116
09 Non-ag. H: Sex ratio a118/119
a10110 Agric. H: Sex ratio a121/122
11 Other H: Sex ratio a124/125
12 Residents of all urban townships (zhen): H size a127/126
13 " " " " : Sex ratio a128/129
14 " " towns (zhen): H size a131/130
15 Rural residents of urban townships: H size a135/134
16 " " " " : Sex ratio a136/137
17 Non-ag. H, all urban townships: Sex ratio a139/140
18 Agric. H, all urban townships: Sex ratio a142/143
19 Other H, all urban townships: Sex ratio a145/146
a10120 Urban residents outside zhen: Persons per incl. H a152/151
21 " " " " : Sex ratio a153/154
22 Residents of rural townships: H size a156/155
23 " " " : Sex ratio a157/158
24 Non-ag. H outside zhen (mostly in CC): Sex ratio a160/161
25 Agric. H outside zhen (mostly in xiang): Sex ratio a163/164
26 Other H outside zhen: Sex ratio a166/167
27 Urban P 2000+: Persons per inclusive H a169/168
28 " " : Sex ratio a170/171
Urbanization
a10141 Urbanization index, inclusive of all zhen a105/102
42 Urbanization index 2000+ a169/102
43 Urbanization index, central towns and higher a907/101
44 Urbanization index, local cities and higher a908/102
Age-sex structure
a10151 Total P: Sex ratio a182/183
52 P 0-4/total P a184/181
53 M 0-4/total M a185/182
54 F 0-4/total F a186/183
55 P 0-4: Sex ratio a185/186
a10156 P 5-9/total P a187/181
57 M 5-9/total M a188/182
58 F 5-9/total F a189/183
59 P 5-9: Sex ratio a188/189
a10160 P 10-14/total P a190/181
61 M 10-14/total M a191/182
62 F 10-14/total F a192/183
63 P 10-14: Sex ratio a191/192
a10164 P 15-19: total P a193/181
65 M 15-19: total M a194/182
66 F 15-19: total F a195/183
67 P 15-19: Sex ratio a194/195
a10168 P 20-24: total P a196/182
69 M 20-24: total M a197/182
70 F 20-24: total F a198/183
71 P 20-24: Sex ratio a197/198
a10172 P 25-29: total P a199/181
73 M 25-29: total M a200/182
74 F 25-29: total F a201/183
75 P 25-29: Sex ratio a200/201
a10176 P 30-34: total P a202/181
77 M 30-34: total M a203/182
78 F 30-34: total F a204/183
79 P 30-34: Sex ratio a203/204
a10180 P 35-39: total P a205/181
81 M 35-39: total M a206/182
82 F 35-39: total F a207/183
83 P 35-39: Sex ratio a206/207
a10184 P 40-44: total P a208/181
85 M 40-44: total M a209/182
86 F 40-44: total F a210/183
87 P 40-44: Sex ratio a209/210
a10188 P 45-49: total P a211/181
89 M 45-49: total M a212/182
90 F 45-49: total F a213/183
91 P 45-49: Sex ratio a212/213
a10192 P 50-54: total P a214/181
93 M 50-54: total M a215/182
94 F 50-54: total F a216/183
95 P 50-54: Sex ratio a215/216
a10196 P 55-59: total P a217/181
97 M 55-59: total M a218/182
98 F 55-59: total F a219/183
99 P 55-59: Sex ratio a218/219
a10200 P 60-64: total P a220/181
01 M 60-64: total M a221/182
02 F 60-64: total F a222/183
03 P 60-64: Sex ratio a221/222
a10204 P 65-69: total P a223/181
05 M 65-69: total M a224/182
06 F 65-69: total F a225/183
07 P 65-69: Sex ratio a224/225
a10208 P 70-74: total P a226/181
09 M 70-74: total M a227/182
10 F 70-74: total F a228/183
11 P 70-74: Sex ratio a227/228
a10212 P 75-79: total P a229/181
13 M 75-79: total M a230/182
14 F 75-79: total F a231/183
15 P 75-79: Sex ratio a230/231
a10216 P 80-84: total P a232/181
17 M 80-84: total M a233/182
18 F 80-84: total F a234/183
19 P 80-84: Sex ratio a233/234
a10220 P 85-89: total P a235/181
21 M 85-89: total M a236/182
22 F 85-89: total F a237/183
23 P 85-89: Sex ratio a236/237
a10224 P 90-94: total P a238/181
25 M 90-94: total M a239/182
26 F 90-94: total F a240/183
27 P 90-94: Sex ratio a239/240
a10228 P 95-99: totalP a241/181
29 M 95-99: total M a242/182
30 F 95-99: total F a243/183
31 P 95-99: Sex ratio a242/243
a10232 P 100+/total P a244/181
33 M 100+/total M a245/182
34 F 100+/total F a246/183
35 P 110+: Sex ratio a245/246
a10236 P 0-9: total P a184+187/181
37 M 0-9: total M a185+188/182
38 F 0-9: total Fa 186+189/183
39 P 0-9: Sex ratio a185+188/186+189
a10240 P 0-14: total P a247/181
41 M 0-14: total M a248/182
42 F 0-14: total F a249/183
43 P 0-14: Sex ratio a248/249
a10244 P 0-19: total P a247+193/181
45 M 0-19: total M a248+194/182
46 F 0-19: total F a249+195/183
47 P 0-19: Sex ratio a248+194/249+195
a10248 P 15-45: total P a193+250/181
49 M 15-45: total M a194+251/182
50 F 15-45: total F a195+252/183
51 P 15-45: Sex ratio a194+251/195+252
a10252 P 15-55: total P a193+250+211+214/181
53 M 15-55: total M a194+251+212+215/182
54 F 15-55: total F a195+252+213+216/183
55 P 15-55: Sex ratio a194+251+212+215/195+252+213+216
a10256 P 20-60: total P a250+211+214+217/181
57 M 20-60: total M a251+212+215+218/182
58 F 20-60: total F a252+213+216+219/183
59 P 20-60: Sex ratio a251+212+215+218/252+213+216+219
a10260 P 60+: total P a220+223+226+253/181
61 M 60+: total M a221+224+227+254/182
62 F 60+: total F a222+225+228+255/183
63 P 60+: Sex ratio a221+224+227+254/222+225+228+255
a10264 P 65+: total P a223+226+253/181
65 M 65+: total M a224+227+254/182
66 F 65+: total F a225+228+255/183
67 P 65+: Sex ratio a224+227+254/225+228+255
a10268 P 70+: total P a226+253/181
69 M 70+: total M a227+254/182
70 F 70+: total F a228+255/183
71 P 70+: Sex ratio a227+254/228+255
a10272 P 75+/total P a253/181
73 M 75+/total M a254/182
74 F 75+/total F a255/183
75 P 75+: Sex ratio a254/a255
a10276 Ratio P 0-4 to P 5-9 a184/187
77 Ratio P 0-4 to P 10-14 a184/190
78 Ratio P 0-4 to P 5-14 a184/187+189
79 Ratio P 5-9 to P 10-14 a187/190
80 Ratio P 0-9 to P 10-14 a184+187/190
Educational attainment
a10281 P 6+: Sex ratio a262/263
a10282 P university educated/P 6+ a264/261
83 M " " /M 6+ a265/262
84 F " " /F 6+ a266/263
85 P " " : Sex ratio a265/266
a10286 P jr. college educated/P 6+ a267/261
87 M " " " /M 6+ a268/262
88 F " " " /F 6+ a269/263
89 P " " " : Sex ratio a268/269
a10290 P secondary technical school educated/P 6+ a270/261
91 M " " " " /M 6+ a271/262
92 F " " " " /F 6+ a272/263
93 P " " " " : Sex ratio a271/272
a10294 P senior middle school educated/P 6+ a273/261
95 M " " " " /M 6+ a274/262
96 F " " " " /F 6+ a275/263
97 P " " " " : Sex ratio a274/275
a10298 P junior middle school educated/P 6+ a276/261
99 M " " " " /M 6+ a277/262
300 F " " " " /F 6+ a278/263
01 P " " " " : Sex ratio a277/278
a10302 P primary school educated/P 6+ a279/261
03 M " " " /M 6+ a280/262
04 F " " " /F 6+ a281/263
05 P " " " : Sex ratio a280/281
a10306 P illiterate/semi-illiterate/P 6+ a282/261
07 M " " /M 6+ a283/262
08 F " " /F 6+ a284/263
09 P " " : Sex ratio a283/284
a10310 P with advanced education/P 6+ a264+267/261
11 M " " " /M 6+ a265+268/262
12 F " " " /F 6+ a266+269/263
13 P " " " : Sex ratio a265+268/266+269
a10314 P educated at least to sr-mid. school/P 6+ a264+267+270+273/261
15 M " " " " " " /M 6+ a265+268+271+274/262
16 F " " " " " " /F 6+ a266+269+272+275/263
17 P " " " " " " : Sex ratio
a265+268+271+274/266+269+272+275
a10318 P uneducated or only primary educ./P 6+ a279+282/261
19 M " " " " " /M 6+ a280+283/262
20 F " " " " " /F 6+ a281+284/263
21 P " " " " " : Sex ratio a280+283/a281+284
Illiteracy
a10331 P 15+: Sex ratio a292/293
32 P 15+: Illiteracy rate a294/291
33 M 15+: Illiteracy rate a295/292
34 F 15+: Illiteracy rate a296/293
35 P illiterates 15+: Sex ratio a295/296
Marital status
a10341 P 15+: Sex ratio a302/303
a10342 P 15+ never married/P 15+ a304/301
43 M 15+ " " /M 15+ a305/302
44 F 15+ " " /F 15+ a306/303
45 P 15+ " " : Sex ratio a305/306
a10346 P 15+ married/P 15+ a307/301
47 M 15+ " /P 15+ a308/302
48 F 15+ " /P 15+ a309/303
49 P 15+ " : Sex ratio a308/309
a10350 P 15+ widowed/P 15+ a310/301
51 M 15+ " /P 15+ a311/302
52 F 15+ " /P 15+ a312/303
53 P 15+ " : Sex ratio a311/312
a10354 P 15+ divorced/P 15+ a313/301
55 M 15+ " /P 15+ a314/302
56 F 15+ " /P 15+ a315/303
57 P 15+ " : Sex ratio a314/315
a10358 P 15+ currently married/P 15+ ever married a307/307+310+313
59 M 15+ " " /M 15+ ever married a308/308+311+314
60 F 15+ " " /F 15+ ever married a309/309+312+315
a10361 P 15+ widowed/P 15+ ever married a310/307+310+313
62 M 15+ " /M 15+ ever married a311/308+311+314
63 F 15+ " /F 15+ ever married a312/309+312+315
a10364 P 15+ divorced/P 15+ ever married a313/307+310+313
65 M 15+ " /M 15+ ever married a314/308+311+314
66 F 15+ " /F 15+ ever married a315/309+312+315
Births and fertility
a10371 Sex ratio, births: 1Jan89-30Jun90 a322/323
72 " " " : 1Jan89-30Jun89 a325/326
73 " " " : 1Jul89-31Dec89 a328/329
74 " " " : 1Jan90-30Jun90 a331/332
75 " " " : 1989 a325+328/326+329
76 " " " : 1Jul89-30Jun90 a328+331/329-332
a10377 Gen'l fertility rate: 1989-90 2/3 x a321/195+252
78 Gen'l fertility rate: 1989 a324+327/195+252
79 Gen'l fertility rate: 1Jul89-30Jun90 a327+330/195+252
a10380 Ratio 1Jan89-30Jun90 births to P 0-4 a321/184
81 " " " to P 5-9 a321/187
82 " " " to P 10-14 a321/190
83 " " " to P 0-9 a321/184+187
84 " " " to P 0-14 a321/247
Deaths and mortality
a10391 Sex ratio, deaths: 1Jan89-30Jun90 a342/343
92 " " " : 1Jan89-30Jun89 a345/346
93 " " " : 1Jul89-31Dec89 a348/349
94 " " " : 1Jan90-30Jun90 a351/352
95 " " " : 1989 a345+348/346+349
96 " " " : 1Jul89-30Jun90 a348+351/349+352
a10397 Crude death rate : 1989-90 2/3 x a341/102
98 Crude death rate : 1989 a344+347/102
99 Crude death rate : 1Jul89-30Jun90 a347+350/102
In-migration
a10401 In-migrants (IM) as pct of adult P a361/181-247
02 Same-prov. IM as pct of adult P a362/181-247
03 IM from same-prov. shi as pct of adult P a363/181-247
04 IM from same-prov. zhen as pct of adult P a364/181-247
05 IM from same-prov. xiang as pct of adult P a365/181-247
a10406 IM from other provinces as a pct of adult P a366/181-247
07 IM from diff-prov. shi as pct of adult P a367/181-247
08 IM from diff-prov. zhen as pct of adult P a368/181-247
09 IM from diff-prov. xiang as pct of adult P a369/181-247
a10410 IM from all shi as pct. of adult P a363+367/181-247
11 IM from all zhen as pct of adult P a364+368/181-247
12 IM from all xiang as pct of adult P a365+369/181-247
a10413 Same-prov. IM as pct of all known IM a362/371
14 IM from same-prov. shi as pct of all IM a363/371
15 IM from same-prov. zhen as pct of all IM a364/371
16 IM from same-prov. xiang as pct of all IM a365/371
a10417 IM from diff-prov. shi as pct of all IM a367/371
18 IM from diff-prov. zhen as pct of all IM a368/371
19 IM from diff-prov. xiang as pct. of all IM a369/371
a10420 IM from all shi as pct of all IM a363+367/371
21 IM from all zhen as pct of all IM a364+368/371
22 IM from all xiang as pct of all IM a365+369/371
Industry/Economic activity
10431 SR (sex ratio) of total LF (labor force) a382/383
32 P in agricultural sector as pct of LF a384/381
33 M in " " " M LF a385/382
34 F in " " " F LF a386/383
35 SR of " " a385/386
10436 P in industrial sector as pct of LF a387/381
37 M " " " M LF a388/382
38 F " " " F LF a389/383
39 SR of " " a388/389
10440 P in mining sector as pct of LF a390/381
41 M " " " M LF a391/382
42 F " " " F LF a392/383
43 SR of " " a391/392
10444 P in construction sector as pct of LF a393/381
45 M " " " M LF a394/382
46 F " " " F LF a395/383
47 SR of " " a394/395
10448 P in transport/communication sector as pct of LF a396/381
49 M " " " M LF a397/382
50 F " " " F LF a398/383
51 SR of " " a397/398
10452 P in commercial sector as pct of LF a399/381
53 M " " " M LF a400/382
54 F " " " F LF a401/383
55 SR of " " a400/401
10456 P in utilities/services sector as pct of LF a402/381
57 M " " " M LF a403/382
58 F " " " F LF a404/383
59 SR of " " a403/404
10460 P in health/welfare sector as pct of LF a405/381
61 M " " " M LF a406/382
62 F " " " F LF a407/383
63 SR of " " a406/407
10464 P in education/entertainment sector as pct of LF a408/381
65 M " " " M LF a409/382
66 F " " " F LF a410/383
67 SR of " " a409/410
10468 P in science/technology sector as pct of LF a411/381
69 M " " " M LF a412/382
70 F " " " F LF a413/383
71 SR of " " a412/413
10472 P in financial sector as pct of LF a414/381
73 M " " " M LF a415/382
74 F " " " F LF a416/383
75 SR of " " a415/416
10476 P in government/organizational sector as pct of LF a417/381
77 M " " " M LF a418/382
78 F " " " F LF a419/383
79 SR of " " a418/419
10480 P in miscellaneous sector as pct of LF a420/381
81 M " " " M LF a421/382
82 F " " F LF a422/383
83 SR of " " a421/422
Occupation (LF=labor force)
a10491 All professional/technical personnel as pct of LF a431/381
92 M " " " M LF a432/382
93 F " " " F LF a433/383
94 SR of " " a432/433
a10495 All officials/officers/managers as pct of LF a434/381
96 M " " M LF a435/382
97 F " " F LF a436/393
98 SR of " a435/436
a10499 All clerical personnel as pct of LF a437/381
a10500 M " " " M LF a438/382
01 F " " F LF a439/383
02 SR of " " a438/439
a10503 All commercial employees as pct of LF a440/381
04 M " " " M LF a441/382
05 F " " " F LF a442/383
06 SR of " " a441/442
a10507 All service employees as pct of LF a443/381
08 M " " " M LF a444/382
09 F " " " F LF a445/383
10 SR of " " a444/445
a10511 All agricultural workers as pct of LF a446/381
12 M " " " M LF a447/382
13 F " " " F LF a448/383
14 SR of " " a447/448
a10515 All industrial workers as pct of LF a449/381
16 M " " " M LF a450/382
17 F " " " F LF a451/383
18 SR of " " a450/451
a10519 All personnel in other/misc occupations as pct of LF a452/381
20 M " " " " M LF a453/382
21 F " " " " F LF a454/383
22 SR of " " " a453/454
Agriculture
a10601 Rural P as pct of total P [persons per ha.] a601/102
a10602 Rural P density " a601/625
a10603 Nutritional density (P/cultivated area) " a601/605
a10604 P/sown area " a601/606
a10605 Rural labor force (LF)/cultivated area " a602/605
a10606 Agricultural LF/cultivated area " a603/605
a10607 Agricultural LF/sown area " a603/606
a10608 Rural LF as pct of total LF a602/381
a10609 Agricultural LF as pct of total LF a603/381
a10610 LF in rural industry as pct of total LF a604/381
a10611 LF in rural industry as pct of total rural LF a604/602
a10612 Cultivated area as pct of total surface area a605/625
a10613 Sown area/cultivated area a606/605
a10614 Grain sown area as pct of all-crops sown area a607/606
a10615 Cotton sown area as pct of all-crops sown area a608/606
a10616 Oil crops sown area as pct of all-crops sown area a609/606
a10617 Grain yields [tons per ha.] a610/607
a10618 Cotton yields " a611/608
a10619 Oil-crop yields " a612/609
a10620 Grain output per capita [tons per 10,000 persons] a610/102
a10621 Grain output per rural capita " a610/601
a10622 Meat output per capita " a613/102
a10623 Meat output per rural capita " a613/601
a10624 Mechanization [10,000 watts per ha. of cultivated land] a614/605
a10625 Tractor-plowed as a pct of cultivated area a615/605
a10626 Irrigated area as a pct of cultivated area a616/605
a10627 Fertilizer per unit of sown area [tons per ha.] a617/606
a10628 Electricity used [10m watt-hours] per ha. of cult. land a618/605
a10629 Per-capitized electr. use [watt-hours per rural person] a618/601
a10630 Per-capitized collective units' product in ¥ (rural P) a619/601
a10631 Per-capitized GVAO in ¥ (rural P) a620/601
a10632 Per-capitized GVAO in ¥ (rural LF) a620/602
a10633 Agricultural productivity [¥ per agricultural LF] a620/603
a10634 Per-capitized adjusted GVAO in ¥ (rural P) a623/601
a10635 Per-capitized adjusted GVAO in ¥ (rural LF) a623/602
a10636 Adjusted agricultural productivity [¥/agric. LF] a623/603
a10637 Per-capitized net VAO in ¥ (rural P) a622/601
a10638 Per-capitized net VAO in ¥ (rural LF) a622/602
a10639 Net agricultural productivity [¥ per agricultural LF] a622/603
a10640 Per-capitized purchased output (rural P) a624/601
a10641 Per-capitized purchased output (rural LF) a624/602