master_key = {
  'Indicators': ['Community', 'Diversity', 'Education', 'Housing'], # 'Economy', 'Environment', 'Healthcare', 'Transportation'
  'Community': {
    'categories': ['broadband', 'population', 'household', 'household_total'],
    'broadband' : {
        'desc': 'Broadband access by income, looking at percentage overall and comparing it with other counties',
        'fields': ['broadband'],
        'locations': ['NYC', 'LI'],
        'broadband': {
            'B28004_001E': 'Total',
            'B28004_002E': 'Less than $10,000:',
            'B28004_004E': 'Less than $10,000:!!With a broadband Internet subscription',
            'B28004_006E': '$10,000 to $19,999:',
            'B28004_008E': '$10,000 to $19,999:!!With a broadband Internet subscription',
            'B28004_010E': '$20,000 to $34,999:',
            'B28004_012E': '$20,000 to $34,999:!!With a broadband Internet subscription',
            'B28004_014E': '$35,000 to $49,999:',
            'B28004_016E': '$35,000 to $49,999:!!With a broadband Internet subscription',
            'B28004_018E': '$50,000 to $74,999:',
            'B28004_020E': '$50,000 to $74,999:!!With a broadband Internet subscription',
            'B28004_022E': '$75,000 or more:',
            'B28004_024E': '$75,000 or more:!!With a broadband Internet subscription',
        },
        'data': {
            'B28004_001E': 'Total',
            'B28004_002E': 'Less than $10,000:',
            'B28004_004E': 'Less than $10,000:!!With a broadband Internet subscription',
            'B28004_006E': '$10,000 to $19,999:',
            'B28004_008E': '$10,000 to $19,999:!!With a broadband Internet subscription',
            'B28004_010E': '$20,000 to $34,999:',
            'B28004_012E': '$20,000 to $34,999:!!With a broadband Internet subscription',
            'B28004_014E': '$35,000 to $49,999:',
            'B28004_016E': '$35,000 to $49,999:!!With a broadband Internet subscription',
            'B28004_018E': '$50,000 to $74,999:',
            'B28004_020E': '$50,000 to $74,999:!!With a broadband Internet subscription',
            'B28004_022E': '$75,000 or more:',
            'B28004_024E': '$75,000 or more:!!With a broadband Internet subscription',
        }
    },
    'population': {
        'desc': 'Population data used for population total and population change',
        'fields': ['population'],
        'locations': ['NYC', 'LI'],
        'population': {
            'B01003_001E': 'Total'
        },
        'data': {
            'B01003_001E': 'Total'
        }
    },
    'household': {
        'desc': 'Household data used for household total and household change',
        'fields': ['household'],
        'locations': ['NYC', 'LI'],
        'household': {
            'B11002_001E': 'Population in Househol!!Total',
            'B11002_002E': 'Population in Househol!!In family households',
            'B11002_012E': 'Population in Househol!!In nonfamily households'
        },
        'data': {
            'B11002_001E': 'Population in Househol!!Total',
            'B11002_002E': 'Population in Househol!!In family households',
            'B11002_012E': 'Population in Househol!!In nonfamily households'
        }
    },
    'household_total': {
        'desc': 'Household total',
        'fields': ['household_total'],
        'locations': ['NYC', 'LI'],
        'household_total': {
            'DP02_0001E': 'Total households',
        },
        'data': {
            'DP02_0001E': 'Total households',
        }
    }
  },
  'Diversity': {
    'categories': ['race_ethnic', 'age_group'],
    'race_ethnic': {
        'desc': 'Racial composition of Long Island',
        'fields': ['race'],
        'locations': ['LI'],
        'race' : {
            'B03002_001E': 'Total',
            'B03002_002E': 'Not Hispanic or Latino',
            'B03002_003E': 'Not Hispanic or Latino White alone',
            'B03002_004E': 'Not Hispanic or Latino Black or African American alone',
            'B03002_005E': 'Not Hispanic or Latino American Indian and Alaska Native alone',
            'B03002_006E': 'Not Hispanic or Latino Asian alone',
            'B03002_007E': 'Not Hispanic or Latino Native Hawaiian and Other Pacific Islander alone',
            'B03002_008E': 'Not Hispanic or Latino Some other race alone',
            'B03002_009E': 'Not Hispanic or Latino Two or more races',
            'B03002_010E': 'Not Hispanic or Latino Two or more races Two races including Some other race',
            'B03002_011E': 'Not Hispanic or Latino Two or more races Two races excluding Some other race, and three or more',
            'B03002_012E': 'Hispanic or Latino',
        },
        'data': {
            'B03002_001E': 'Total',
            'B03002_002E': 'Not Hispanic or Latino',
            'B03002_003E': 'Not Hispanic or Latino White alone',
            'B03002_004E': 'Not Hispanic or Latino Black or African American alone',
            'B03002_005E': 'Not Hispanic or Latino American Indian and Alaska Native alone',
            'B03002_006E': 'Not Hispanic or Latino Asian alone',
            'B03002_007E': 'Not Hispanic or Latino Native Hawaiian and Other Pacific Islander alone',
            'B03002_008E': 'Not Hispanic or Latino Some other race alone',
            'B03002_009E': 'Not Hispanic or Latino Two or more races',
            'B03002_010E': 'Not Hispanic or Latino Two or more races Two races including Some other race',
            'B03002_011E': 'Not Hispanic or Latino Two or more races Two races excluding Some other race, and three or more',
            'B03002_012E': 'Hispanic or Latino',
        }
    },
    'age_group': {
        'desc': 'Age group changes in population',
        'fields': ['age_group'],
        'locations': ['LI', 'NYC'],
        'age_group': {
            "B01001_001E": "Total",
            "B01001_002E": "Male",
            "B01001_003E": "Male!!Under 5 years",
            "B01001_004E": "Male!!5 to 9 years",
            "B01001_005E": "Male!!10 to 14 years",
            "B01001_006E": "Male!!15 to 17 years",
            "B01001_007E": "Male!!18 and 19 years",
            "B01001_008E": "Male!!20 years",
            "B01001_009E": "Male!!21 years",
            "B01001_010E": "Male!!22 to 24 years",
            "B01001_011E": "Male!!25 to 29 years",
            "B01001_012E": "Male!!30 to 34 years",
            "B01001_013E": "Male!!35 to 39 years",
            "B01001_014E": "Male!!40 to 44 years",
            "B01001_015E": "Male!!45 to 49 years",
            "B01001_016E": "Male!!50 to 54 years",
            "B01001_017E": "Male!!55 to 59 years",
            "B01001_018E": "Male!!60 and 61 years",
            "B01001_019E": "Male!!62 to 64 years",
            "B01001_020E": "Male!!65 and 66 years",
            "B01001_021E": "Male!!67 to 69 years",
            "B01001_022E": "Male!!70 to 74 years",
            "B01001_023E": "Male!!75 to 79 years",
            "B01001_024E": "Male!!80 to 84 years",
            "B01001_025E": "Male!!85 years and over",
            "B01001_026E": "Female",
            "B01001_027E": "Female!!Under 5 years",
            "B01001_028E": "Female!!5 to 9 years",
            "B01001_029E": "Female!!10 to 14 years",
            "B01001_030E": "Female!!15 to 17 years",
            "B01001_031E": "Female!!18 and 19 years",
            "B01001_032E": "Female!!20 years",
            "B01001_033E": "Female!!21 years",
            "B01001_034E": "Female!!22 to 24 years",
            "B01001_035E": "Female!!25 to 29 years",
            "B01001_036E": "Female!!30 to 34 years",
            "B01001_037E": "Female!!35 to 39 years",
            "B01001_038E": "Female!!40 to 44 years",
            "B01001_039E": "Female!!45 to 49 years",
            "B01001_040E": "Female!!50 to 54 years",
            "B01001_041E": "Female!!55 to 59 years",
            "B01001_042E": "Female!!60 and 61 years",
            "B01001_043E": "Female!!62 to 64 years",
            "B01001_044E": "Female!!65 and 66 years",
            "B01001_045E": "Female!!67 to 69 years",
            "B01001_046E": "Female!!70 to 74 years",
            "B01001_047E": "Female!!75 to 79 years",
            "B01001_048E": "Female!!80 to 84 years",
            "B01001_049E": "Female!!85 years and over",
        },
        'data': {
            "B01001_001E": "Total",
            "B01001_002E": "Male",
            "B01001_003E": "Male!!Under 5 years",
            "B01001_004E": "Male!!5 to 9 years",
            "B01001_005E": "Male!!10 to 14 years",
            "B01001_006E": "Male!!15 to 17 years",
            "B01001_007E": "Male!!18 and 19 years",
            "B01001_008E": "Male!!20 years",
            "B01001_009E": "Male!!21 years",
            "B01001_010E": "Male!!22 to 24 years",
            "B01001_011E": "Male!!25 to 29 years",
            "B01001_012E": "Male!!30 to 34 years",
            "B01001_013E": "Male!!35 to 39 years",
            "B01001_014E": "Male!!40 to 44 years",
            "B01001_015E": "Male!!45 to 49 years",
            "B01001_016E": "Male!!50 to 54 years",
            "B01001_017E": "Male!!55 to 59 years",
            "B01001_018E": "Male!!60 and 61 years",
            "B01001_019E": "Male!!62 to 64 years",
            "B01001_020E": "Male!!65 and 66 years",
            "B01001_021E": "Male!!67 to 69 years",
            "B01001_022E": "Male!!70 to 74 years",
            "B01001_023E": "Male!!75 to 79 years",
            "B01001_024E": "Male!!80 to 84 years",
            "B01001_025E": "Male!!85 years and over",
            "B01001_026E": "Female",
            "B01001_027E": "Female!!Under 5 years",
            "B01001_028E": "Female!!5 to 9 years",
            "B01001_029E": "Female!!10 to 14 years",
            "B01001_030E": "Female!!15 to 17 years",
            "B01001_031E": "Female!!18 and 19 years",
            "B01001_032E": "Female!!20 years",
            "B01001_033E": "Female!!21 years",
            "B01001_034E": "Female!!22 to 24 years",
            "B01001_035E": "Female!!25 to 29 years",
            "B01001_036E": "Female!!30 to 34 years",
            "B01001_037E": "Female!!35 to 39 years",
            "B01001_038E": "Female!!40 to 44 years",
            "B01001_039E": "Female!!45 to 49 years",
            "B01001_040E": "Female!!50 to 54 years",
            "B01001_041E": "Female!!55 to 59 years",
            "B01001_042E": "Female!!60 and 61 years",
            "B01001_043E": "Female!!62 to 64 years",
            "B01001_044E": "Female!!65 and 66 years",
            "B01001_045E": "Female!!67 to 69 years",
            "B01001_046E": "Female!!70 to 74 years",
            "B01001_047E": "Female!!75 to 79 years",
            "B01001_048E": "Female!!80 to 84 years",
            "B01001_049E": "Female!!85 years and over",
        }
    }
  },
  'Education': {
    'categories': ['poverty_prek',],
    'poverty_prek': {
        'desc': 'Enrollment rate for pre-school segmented by poverty status',
        'instructions': 'Look for in poverty (B17001_004E + 18E) and enrolled (B14006_004E), not poor (B17001_033E + 47E) and enrolled (B14006_014E). NOTE!!! Will have missing counties when we run this script, this is expected',
        'fields': ['poverty_prek', 'poverty_overall'],
        'locations': ['NYC', 'LI', 'ROS'],
        'poverty_prek': {
            "B14006_001E": "Total",
            "B14006_002E": "Income in the past 12 months below the poverty level",
            "B14006_003E": "Income in the past 12 months below the poverty level!!Enrolled in school",
            "B14006_004E": "Income in the past 12 months below the poverty level!!Enrolled in school!!Enrolled in nursery school, preschool",
            "B14006_012E": "Income in the past 12 months at or above the poverty level",
            "B14006_013E": "Income in the past 12 months at or above the poverty level!!Enrolled in school",
            "B14006_014E": "Income in the past 12 months at or above the poverty level!!Enrolled in school!!Enrolled in nursery school, preschool",
        },
        'poverty_overall': {
            'B17001_004E': 'Income in the past 12 months below poverty level:!!Male:!!Under 5 years',
            'B17001_018E': 'Income in the past 12 months below poverty level:!!Female:!!Under 5 years',
            'B17001_033E': 'Income in the past 12 months at or above poverty level:!!Male:!!Under 5 years',
            'B17001_047E': 'Income in the past 12 months at or above poverty level:!!Female:!!Under 5 years',
        },
        'data': {
            "B14006_001E": "Total",
            "B14006_002E": "Income in the past 12 months below the poverty level",
            "B14006_003E": "Income in the past 12 months below the poverty level!!Enrolled in school",
            "B14006_004E": "Income in the past 12 months below the poverty level!!Enrolled in school!!Enrolled in nursery school, preschool",
            "B14006_012E": "Income in the past 12 months at or above the poverty level",
            "B14006_013E": "Income in the past 12 months at or above the poverty level!!Enrolled in school",
            "B14006_014E": "Income in the past 12 months at or above the poverty level!!Enrolled in school!!Enrolled in nursery school, preschool",
            'B17001_004E': 'Income in the past 12 months below poverty level:!!Male:!!Under 5 years',
            'B17001_018E': 'Income in the past 12 months below poverty level:!!Female:!!Under 5 years',
            'B17001_033E': 'Income in the past 12 months at or above poverty level:!!Male:!!Under 5 years',
            'B17001_047E': 'Income in the past 12 months at or above poverty level:!!Female:!!Under 5 years',
        }
    }
  },
  'Housing': {
      'categories': ['burden', 'median_income_rent', 'home_value', 'renter_occupied'],
      'burden': {
        'desc': 'The burden of rent by household income, segmented by people that own (with/without mortgages) and renters',
        'fields': ['mortgage', 'rent'],
        'locations': ['LI'],
        'mortgage': {
          'B25091_001E': 'Total owners:',
          'B25091_002E': 'Housing units with a mortgage:',
          'B25091_009E': 'Housing units with a mortgage:!!35.0 to 39.9 percent',
          'B25091_010E': 'Housing units with a mortgage:!!40.0 to 49.9 percent',
          'B25091_011E': 'Housing units with a mortgage:!!50.0 percent or more',
          'B25091_012E': 'Housing units with a mortgage:!!Not computed',
          'B25091_013E': 'Housing units without a mortgage:',
          'B25091_020E': 'Housing units without a mortgage:!!35.0 to 39.9 percent',
          'B25091_021E': 'Housing units without a mortgage:!!40.0 to 49.9 percent',
          'B25091_022E': 'Housing units without a mortgage:!!50.0 percent or more',
          'B25091_023E': 'Housing units without a mortgage:!!Not computed',
        },
        'rent': {
          'B25070_001E': 'Total',
          'B25070_008E': 'Rent as % of HHI:!!35.0 to 39.9 percent',
          'B25070_009E': 'Rent as % of HHI:!!40.0 to 49.9 percent',
          'B25070_010E': 'Rent as % of HHI:!!50.0 percent or more',
          'B25070_011E': 'Not computed',
        },
        'data': {
            'B25070_001E': 'Total renters:',
            'B25070_008E': 'Rent as % of HHI:!!35.0 to 39.9 percent',
            'B25070_009E': 'Rent as % of HHI:!!40.0 to 49.9 percent',
            'B25070_010E': 'Rent as % of HHI:!!50.0 percent or more',
            'B25070_011E': 'Not computed',
            'B25091_001E': 'Total owners:',
            'B25091_002E': 'Housing units with a mortgage:',
            'B25091_009E': 'Housing units with a mortgage:!!35.0 to 39.9 percent',
            'B25091_010E': 'Housing units with a mortgage:!!40.0 to 49.9 percent',
            'B25091_011E': 'Housing units with a mortgage:!!50.0 percent or more',
            'B25091_012E': 'Housing units with a mortgage:!!Not computed',
            'B25091_013E': 'Housing units without a mortgage:',
            'B25091_020E': 'Housing units without a mortgage:!!35.0 to 39.9 percent',
            'B25091_021E': 'Housing units without a mortgage:!!40.0 to 49.9 percent',
            'B25091_022E': 'Housing units without a mortgage:!!50.0 percent or more',
            'B25091_023E': 'Housing units without a mortgage:!!Not computed',
        }
      },
      'median_income_rent': {
        'desc': 'Median household income changes, with median rent changes, on a pareto graph (multiply by B25091 and B25070)',
        'fields': ['median_income', 'median_rent', 'per_capita_income', 'income_group'],
        'locations': ['LI'],
        'median_income': {
            'B19013_001E': 'Median INC adjusted to year'
        },
        'per_capita_income': {
            'B19301_001E': 'Per capita income adjusted to year'
        },
        'median_rent': {
            'B25064_001E': 'Median gross rent'
        },
        'income_group': {
        	'B19001_001E': 'Total',
        	'B19001_002E': 'Less than $10,000',
        	'B19001_003E': '$10,000 to $14,999',
        	'B19001_004E': '$15,000 to $19,999',
        	'B19001_005E': '$20,000 to $24,999',
        	'B19001_006E': '$25,000 to $29,999',
        	'B19001_007E': '$30,000 to $34,999',
        	'B19001_008E': '$35,000 to $39,999',
        	'B19001_009E': '$40,000 to $44,999',
        	'B19001_010E': '$45,000 to $49,999',
        	'B19001_011E': '$50,000 to $59,999',
        	'B19001_012E': '$60,000 to $74,999',
        	'B19001_013E': '$75,000 to $99,999',
        	'B19001_014E': '$100,000 to $124,999',
        	'B19001_015E': '$125,000 to $149,999',
        	'B19001_016E': '$150,000 to $199,999',
        	'B19001_017E': '$200,000 or more',
        },
        'data': {
            'B25064_001E': 'Median gross rent',
            'B19013_001E': 'Median INC adjusted to year',
            'B19301_001E': 'Per capita income adjusted to year',
            'B19001_001E': 'Total',
        	'B19001_002E': 'Less than $10,000',
        	'B19001_003E': '$10,000 to $14,999',
        	'B19001_004E': '$15,000 to $19,999',
        	'B19001_005E': '$20,000 to $24,999',
        	'B19001_006E': '$25,000 to $29,999',
        	'B19001_007E': '$30,000 to $34,999',
        	'B19001_008E': '$35,000 to $39,999',
        	'B19001_009E': '$40,000 to $44,999',
        	'B19001_010E': '$45,000 to $49,999',
        	'B19001_011E': '$50,000 to $59,999',
        	'B19001_012E': '$60,000 to $74,999',
        	'B19001_013E': '$75,000 to $99,999',
        	'B19001_014E': '$100,000 to $124,999',
        	'B19001_015E': '$125,000 to $149,999',
        	'B19001_016E': '$150,000 to $199,999',
        	'B19001_017E': '$200,000 or more',
        }
      },
      'home_value': {
        'desc': 'Median home value of LI, grab total and multiply by median value',
        'fields': ['total_homes', 'median_value'],
        'locations': ['LI'],
        'total_homes': {
            'B25001_001E': 'Total homes'
        },
        'median_value': {
            'B25077_001E': 'Median value (dollars)'
        },
        'data': {
            'B25077_001E': 'Median value (dollars)',
            'B25001_001E': 'Total homes'
        }
      },
      'renter_occupied': {
        'desc': 'Percentage of renters as an overall of total units',
        'fields': ['tenure'],
        'locations': ['LI','NYC','ROS'],
        'tenure': {
            'B25003_001E': 'Total',
            'B25003_002E': 'Owner occupied',
            'B25003_003E': 'Renter occupied',
        },
        'data': {
            'B25003_001E': 'Total',
            'B25003_002E': 'Owner occupied',
            'B25003_003E': 'Renter occupied',
        }
      }
  }
}
