search

NYCPlanning / db-factfinder

data ETL for population fact finder (decennial + acs)
https://nycplanning.github.io/db-factfinder/factfinder/
MIT License
2 stars 3 forks source link

2010 metadata #116

Closed SPTKL closed 3 years ago

SPTKL commented 3 years ago

The file is generated based on the metadata lookups based on this commit. note that this commit is the last commit that generated the 2006-2010 output https://github.com/NYCPlanning/db-acs/tree/23cf808a5811884bda00984b9ecd52e6534cee61/data

Discontinued variables (in 2010 not in 2018): 

['mv80t89', 'mvbf79']

New variables (in 2018 not in 2010):

['lgoenlep1',
 'lgbase',
 'ownerocc',
 'occbaseunits',
 'owneroccbase',
 'mortg',
 'costburden',
 'renteroccbase',
 'rentburden',
 'p65plbwpv_pct',
 'pu18bwpv_pct',
 'pbwpv_pct',
 'mvbf89']

Variables with census variable change:

2010 {'pff_variable': 'cvnid_hrg', 'census_variable': ['S1810_C01_019']}
2018 {'pff_variable': 'cvnid_hrg', 'census_variable': ['S1810_C02_019']}

2010 {'pff_variable': 'c65pldvsn', 'census_variable': ['S1810_C01_036']}
2018 {'pff_variable': 'c65pldvsn', 'census_variable': ['S1810_C02_036']}

2010 {'pff_variable': 'cvnid_cog', 'census_variable': ['S1810_C01_039']}
2018 {'pff_variable': 'cvnid_cog', 'census_variable': ['S1810_C02_039']}

2010 {'pff_variable': 'cu18dvsn', 'census_variable': ['S1810_C01_030']}
2018 {'pff_variable': 'cu18dvsn', 'census_variable': ['S1810_C02_030']}

2010 {'pff_variable': 'c1864damb', 'census_variable': ['S1810_C01_049']}
2018 {'pff_variable': 'c1864damb', 'census_variable': ['S1810_C02_049']}

2010 {'pff_variable': 'c65pldhrg', 'census_variable': ['S1810_C01_026']}
2018 {'pff_variable': 'c65pldhrg', 'census_variable': ['S1810_C02_026']}

2010 {'pff_variable': 'cu18dcog', 'census_variable': ['S1810_C01_040']}
2018 {'pff_variable': 'cu18dcog', 'census_variable': ['S1810_C02_040']}

2010 {'pff_variable': 'cu18dscr', 'census_variable': ['S1810_C01_056']}
2018 {'pff_variable': 'cu18dscr', 'census_variable': ['S1810_C02_056']}

2010 {'pff_variable': 'c1864dvsn', 'census_variable': ['S1810_C01_033']}
2018 {'pff_variable': 'c1864dvsn', 'census_variable': ['S1810_C02_033']}

2010 {'pff_variable': 'c1864dscr', 'census_variable': ['S1810_C01_057']}
2018 {'pff_variable': 'c1864dscr', 'census_variable': ['S1810_C02_057']}

2010 {'pff_variable': 'cvnid_vsn', 'census_variable': ['S1810_C01_029']}
2018 {'pff_variable': 'cvnid_vsn', 'census_variable': ['S1810_C02_029']}

2010 {'pff_variable': 'c1864dhrg', 'census_variable': ['S1810_C01_023']}
2018 {'pff_variable': 'c1864dhrg', 'census_variable': ['S1810_C02_023']}

2010 {'pff_variable': 'ea_bchdh', 'census_variable': ['DP02_0065', 'DP02_0064', 'DP02_0067']}
2018 {'pff_variable': 'ea_bchdh', 'census_variable': ['DP02_0067']}

2010 {'pff_variable': 'c65pldild', 'census_variable': ['S1810_C01_067']}
2018 {'pff_variable': 'c65pldild', 'census_variable': ['S1810_C02_067']}

2010 {'pff_variable': 'cvnid_amb', 'census_variable': ['S1810_C01_047']}
2018 {'pff_variable': 'cvnid_amb', 'census_variable': ['S1810_C02_047']}

2010 {'pff_variable': 'c1864dild', 'census_variable': ['S1810_C01_064']}
2018 {'pff_variable': 'c1864dild', 'census_variable': ['S1810_C02_064']}

2010 {'pff_variable': 'cu18damb', 'census_variable': ['S1810_C01_048']}
2018 {'pff_variable': 'cu18damb', 'census_variable': ['S1810_C02_048']}

2010 {'pff_variable': 'cvnid_scr', 'census_variable': ['S1810_C01_055']}
2018 {'pff_variable': 'cvnid_scr', 'census_variable': ['S1810_C02_055']}

2010 {'pff_variable': 'c65pldamb', 'census_variable': ['S1810_C01_052']}
2018 {'pff_variable': 'c65pldamb', 'census_variable': ['S1810_C02_052']}

2010 {'pff_variable': 'c65pldscr', 'census_variable': ['S1810_C01_060']}
2018 {'pff_variable': 'c65pldscr', 'census_variable': ['S1810_C02_060']}

2010 {'pff_variable': 'c65pldcog', 'census_variable': ['S1810_C01_044']}
2018 {'pff_variable': 'c65pldcog', 'census_variable': ['S1810_C02_044']}

2010 {'pff_variable': 'c1864dcog', 'census_variable': ['S1810_C01_041']}
2018 {'pff_variable': 'c1864dcog', 'census_variable': ['S1810_C02_041']}

2010 {'pff_variable': 'cu18dhrg', 'census_variable': ['S1810_C01_020']}
2018 {'pff_variable': 'cu18dhrg', 'census_variable': ['S1810_C02_020']}

2010 {'pff_variable': 'cvnid_ild', 'census_variable': ['S1810_C01_063']}
2018 {'pff_variable': 'cvnid_ild', 'census_variable': ['S1810_C02_063']}
SPTKL commented 3 years ago

merging for now, awaiting comments / sign off from Erica, any further changes will be reflected in new PR