search

hwchen / acs-explorer

cli for investigating US census ACS variables and data
4 stars 2 forks source link

bug in etl label division #11

Open hwchen opened 5 years ago

hwchen commented 5 years ago 
aca:~ > acs d B24031 --etl --all

name: "TABLENAME"
tag: "acs"
min_year: 2012
max_year: 2015
acs_table:
    id: "B24031"
    value_label: "population"
    dimension_labels: [
        "DIMENSION",
    ]
    columns:
        001: "Total:"
        002: "Agriculture,Forestry,FishingAndHunting,AndMining:"
        003: "Agriculture,Forestry,FishingAndHunting,AndMining_Agriculture,Forestry,FishingAndHunting"
        004: "Agriculture,Forestry,FishingAndHunting,AndMining_Mining,Quarrying,AndOilAndGasExtraction"
        005: "Construction"
        006: "Manufacturing"
        007: "WholesaleTrade"
        008: "RetailTrade"
        009: "TransportationAndWarehousing,AndUtilities:"
        010: "TransportationAndWarehousing,AndUtilities_TransportationAndWarehousing"
        011: "TransportationAndWarehousing,AndUtilities_Utilities"
        012: "Information"
        013: "FinanceAndInsurance,AndRealEstateAndRentalAndLeasing:"
        014: "FinanceAndInsurance,AndRealEstateAndRentalAndLeasing_FinanceAndInsurance"
        015: "FinanceAndInsurance,AndRealEstateAndRentalAndLeasing_RealEstateAndRentalAndLeasing"
        016: "Professional,Scientific,AndManagement,AndAdministrativeAndWasteManagementServices:"
        017: "Professional,Scientific,AndManagement,AndAdministrativeAndWasteManagementServices_Professional,Scientific,AndTechnicalServices"
        018: "Professional,Scientific,AndManagement,AndAdministrativeAndWasteManagementServices_ManagementOfCompaniesAndEnterprises"
        019: "Professional,Scientific,AndManagement,AndAdministrativeAndWasteManagementServices_AdministrativeAndSupportAndWasteManagementServices"
        020: "EducationalServices,AndHealthCareAndSocialAssistance:"
        021: "EducationalServices,AndHealthCareAndSocialAssistance_EducationalServices"
        022: "EducationalServices,AndHealthCareAndSocialAssistance_HealthCareAndSocialAssistance"
        023: "Arts,Entertainment,AndRecreation,AndAccommodationsAndFoodServices"
        024: "Arts,Entertainment,AndRecreation,AndAccommodationsAndFoodServices!!Arts,Entertainment,AndRecreation"
        025: "Arts,Entertainment,AndRecreation,AndAccommodationsAndFoodServices!!AccommodationAndFoodServices"
        026: "OtherServicesExceptPublicAdministration"
        027: "PublicAdministration"
hwchen commented 5 years ago

See row 24 and 25