Conversion of the March 2001 CPS Contents of this document: New Welfare Reform Fields Record Counts and Weighted Totals Significant Field Statistic Changes Added Field New Welfare Reform Fields The move from Oracle to MySQL has just been completed. This will enable the addition of the new welfare reform fields to TRIM’s database tables. However, at this time those fields are not yet available except via a supplementary file for the immigrant- adjusted data, (CPSI2001Supplement, on Boreas only). You may view a list of the new fields that will eventually be added to TRIM’s regular database tables by clicking here. Record Counts and Weighted Totals Consistent with past trends, average weights on the March CPS are higher than for the previous year. The following tabulation shows weighted and unweighted counts on both immigrant-adjusted and unadjusted files for both the current and previous years. Also shown are original pre-conversion record counts that include empty non-interview households and child-only families that the TRIM conversion merges with primary families or single household heads. There are 14,729 non-interview households. 386 child-only families in the immigrant-adjusted data and 306 in the unadjusted data were merged with other TRIM families. The weighted sum of households in the immigrant- adjusted data differs somewhat from the sum computed from unadjusted data due to a methodological difference between the Census algorithm that identifies household weight and the one used by the conversion code. That difference results in the use of different weights for a few households. (Read explanation.) Pre-conversion March 2001 CPS March 2000 CPS March 2001 CPS Immigrant-adjusted Files Unweighted Unweighted Weighted Unweighted Weighted Households 69,017 54,288 106,510,075 56,999 104,779,977 Families 64,765 64,379 121,039,256 68,176 119,017,102 Persons 153,097 153,097 276,540,365 165,053 274,087,022 Adults 117,236 117,236 216,007,889 125,777 213,773,186 Unadjusted Files Unweighted Unweighted Weighted Unweighted Weighted Households 64,362 49,633 106,512,318 51,016 104,781,947 Families 56,480 56,174 121,039,252 57,763 119,017,096 Persons 128,821 128,821 276,540,351 133,710 274,087,002 Adults 99,816 99,816 216,007,879 103,226 213,773,172 Significant Field Statistic Changes Increases - Farm Self-employment Field Name Statistic March 2001 March 2000 CPS CPS FarmSelfEmployment Wt Mean of Non-zero Values 12,709 8,444 LastOtherFarmSelfEmployment Wt Mean of Non-zero Values 10,017 4,229 LastPrimaryFarmSelfEmployment Wt Mean of Non-zero Values 17,751 12,774 FarmSelfEmployment Weighted Sum 33.2 billion 15.5 billion - Workers Compensation (Note: LastWorkersCompensation is a component of WorkersCompensation; see field definitions in TRIM3 Dictionary.) Field Name Statistic March 2001 March 2000 CPS CPS WorkersCompensation Wt Mean of Non-zero Values 8,541 7,213 LastWorkersCompensation Wt Mean of Non-zero Values 6,627 5,844 WorkersCompensation Weighted Sum 21.2 billion 18.1 billion LastWorkersCompensation Weighted Sum 11.4 billion 10.4 billion - Child Support Field Name Statistic March 2001 March 2000 CPS CPS ChildSupport Wt Mean of Non-zero Values 4482 4031 ChildSupport Weighted Sum 23.6 billion 20.7 billion - Survivors’ Income Field Name Statistic March 2001 March 2000 CPS CPS LastPrimarySurvivorIncome Wt Mean of Non-zero Values 10,347 9,259 LastPrimarySurvivorIncome Weighted Sum 28.2 billion 24.9 billion LastSecondarySurvivorIncome Wt Mean of Non-zero Values 16,556 10,777 LastSecondarySurvivorIncome Weighted Sum 2.15 billion 1.48 billion - OtherRegularContributions Field Name Statistic March 2001 March 2000 CPS CPS OtherRegularContributions Wt Mean of Non-zero Values 6,669 5,371 OtherRegularContributions Weighted Sum 12.79 billion 10.67 billion - LastNonWorkerWeeksLooking Field Name Statistic March 2001 March 2000 CPS CPS LastNonWorkerWeeksLooking Wt Mean of Non-zero Values 26.10 23.45 LastNonWorkerWeeksLooking Weighted Sum 38.98 million 36.46 million - LastTotalEducationalAssistance Field Name Statistic March 2001 March 2000 CPS CPS LastTotalEducationalAssistance Wt Mean of Non-zero Values 4,544 4,046 LastTotalEducationalAssistance Weighted Sum 34.42 billion 30.45 billion - EstatesOrTrusts Field Name Statistic March 2001 March 2000 CPS CPS EstatesOrTrusts Wt Mean of Non-zero Values 19,776 17,333 EstatesOrTrusts Weighted Sum 5.26 billion 4.63 billion Decreases - OtherPublicAssistance Field Name Statistic March 2001 March 2000 CPS CPS OtherPublicAssistance Wt Mean of Non-zero Values 2,331 2,641 OtherPublicAssistance Weighted Sum 1.49 billion 2.59 billion - LastSecondaryDisability Field Name Statistic March 2001 March 2000 CPS CPS LastSecondaryDisability Wt Mean of Non-zero Values 7,170 8,121 LastSecondaryDisability Weighted Sum 2.73 billion 3.80 billion - Dividends Field Name Statistic March 2001 March 2000 CPS CPS Dividends Wt Mean of Non-zero Values 2,641 3,112 Dividends Weighted Sum 103.3 billion 126.2 billion Added Field IndianHealthServiceImputation is available on this year’s file. It was inadvertently omitted from the previous year’s file. from the previous year’s file.