Celebrating Cities Public Data API Service
So you want to win that hackathon or build the next hot open data app? Follow this guide to get yourself started. Make sure you check out the more detailed resources in Socrata's Dev Portal when it’s time to get in deep
We are using Socrata's REST API, SODA API . This service accepts several queries, including geospatially-enabled queries, which should allow you to make very specific requests.
Getting Started
All datasets are currently hosted on Socrata's Open Data portal which provides the REST SODA API.
Every Socrata open dataset has a built-in SODA API. But how you find the API endpoint can vary a bit.
If you’re viewing a DataLens, there will be a prominent “API” button in the upper left of the page. Click that, and you’ll get details on the API endpoint and a link to API documentation.
If you’re on a Socrata dataset, identifiable by the colorful buttons at the upper right, don’t fret. Every Socrata dataset has a built-in open data API, so you’ll be just fine. Click on
Export
and then
API
and you’ll find the API endpoint under
API Access Endpoint.
Read the detailed documentation on
API Endpoints
for more info.
For this example, we’ll use this listing of DC Crime Incidents 2015.
https://celebratingcities.data.socrata.com/resource/j6b8-wjwi.json
That url, found on the dataset page, will be your API endpoint. Now let's move on to doing some sample queries.
Example Queries
Simple Filters
Filtering data is very straightforward. SODA APIs are self-describing — the schema and contents of the dataset itself determines how you can query it. Any field within the data can be used as a filter, simply by appending it to the API endpoint as a GET parameter. For example, to query for only
BURGLARY
offences, simply append
?offense=BURGLARY
to the url:
https://celebratingcities.data.socrata.com/resource/j6b8-wjwi.json?offense=BURGLARY
Additional filters can be added, and the filters will be
ANDed
Read the detailed documentation on
Filtering Datasets
for more info.
SoQL Queries
The “Socrata Query Language” (SoQL) is a simple, SQL-like query language specifically designed for making it easy to work with data on the web. The language is both powerful and easy to learn, and everything works via GET parameters. For example, to search for crimes in in Dupont Circle:
https://celebratingcities.data.socrata.com/resource/j6b8-wjwi.json?$where=within_box(the_geom, 38.9056366947, -77.0466792583, 38.911497437, -77.0384395123)
Many different functions are available via SoQL. Read the detailed documentation on
SoQL Queries
for more info.
Key Data Dictionaries
Location Affordability Index
Dataset
| Field | Definition |
|---|---|
| STATE | State |
| block_group | Block Group |
| households | Count of Households in the Block Group |
| area_median_income | Area Median Income |
| blkgrp_median_income_owners | Median Income for Owners in the Block Group |
| blkgrp_median_income_renters | Median Income for Renters in the Block Group |
| avg_hh_size_owners | Average Household Size for Owner Occupied Housing Units |
| avg_hh_size_renters | Average Household Size for Renter Occupied Housing Units |
| commuters_per_hh_owners | Average Commuters per Household for Owner Occupied Housing Units |
| commuters_per_hh_renters | Average Commuters per Household for Renter Occupied Housing Units |
| pct_renters | Percent of Households in Renter Occupied Housing Units |
| gross_hh_density | Gross Household Density (Households per Acre) |
| median_rooms_per_owner_unit | Median Number or Rooms per Owner Occupied Housing Units |
| median_rooms_per_renter_unit | Median Number or Rooms per Renter Occupied Housing Units |
| pct_detatched_single_fam_unit | Percent of Housing Units that are Detached Single Family |
| median_commute_distance | Median Commute Distance |
| block_denstiy | Block Density (Blocks per Acre) |
| employment_access_index | Employment Access Index |
| local_job_density | Local Job Density |
| local_retail_job_density | Local Retail Job Density |
| retail_access_index | Retail Access Index |
| HH1_Income | The income for the geography as defined for Median-Income Family. |
| HH1_size | The household size for geography as defined for Median-Income Family. |
| HH1_workers | The number of commuters for the geography as defined for Median-Income Family. |
| HH1_ht | The modeled housing and transportation costs as a percent of income for Median-Income Family. |
| HH1_h | The modeled housing costs as a percent of income for Median-Income Family. |
| HH1_t | The modeled transportation costs as a percent of income for Median-Income Family. |
| HH1_autos | The modeled autos per household for Median-Income Family. |
| HH1_vmt | The modeled household annual vehicle miles traveled (VMT) for Median-Income Family. |
| HH1_transit_trips | The modeled household annual transit trips for Median-Income Family. |
| HH1_ht_own | The modeled housing and transportation costs as a percent of income for owners for Median-Income Family. |
| HH1_h_own | The modeled housing costs as a percent of income for owners for Median-Income Family. |
| HH1_t_own | The modeled transportation costs as a percent of income for owners for Median-Income Family. |
| HH1_autos_own | The modeled autos per household for owners for Median-Income Family. |
| HH1_vmt_own | The modeled household annual vehicle miles traveled (VMT) for owners for Median-Income Family. |
| HH1_transit_trips_own | The modeled household annual transit trips for owners for Median-Income Family. |
| HH1_ht_rent | The modeled housing and transportation costs as a percent of income for renters for Median-Income Family. |
| HH1_h_rent | The modeled housing costs as a percent of income for renters for Median-Income Family. |
| HH1_t_rent | The modeled transportation costs as a percent of income for renters for Median-Income Family. |
| HH1_autos_rent | The modeled autos per household for renters for Median-Income Family. |
| HH1_vmt_rent | The modeled household annual vehicle miles traveled (VMT) for renters for Median-Income Family. |
| HH1_transit_trips_rent | The modeled household annual transit trips for renters for Median-Income Family. |
| HH2_Income | The income for the geography as defined for Very Low-Income Individual. |
| HH2_size | The household size for geography as defined for Very Low-Income Individual. |
| HH2_workers | The number of commuters for the geography as defined for Very Low-Income Individual. |
| HH2_ht | The modeled housing and transportation costs as a percent of income for Very Low-Income Individual. |
| HH2_h | The modeled housing costs as a percent of income for Very Low-Income Individual. |
| HH2_t | The modeled transportation costs as a percent of income for Very Low-Income Individual. |
| HH2_autos | The modeled autos per household for Very Low-Income Individual. |
| HH2_vmt | The modeled household annual vehicle miles traveled (VMT) for Very Low-Income Individual. |
| HH2_transit_trips | The modeled household annual transit trips for Very Low-Income Individual. |
| HH2_ht_own | The modeled housing and transportation costs as a percent of income for owners for Very Low-Income Individual. |
| HH2_h_own | The modeled housing costs as a percent of income for owners for Very Low-Income Individual. |
| HH2_t_own | The modeled transportation costs as a percent of income for owners for Very Low-Income Individual. |
| HH2_autos_own | The modeled autos per household for owners for Very Low-Income Individual. |
| HH2_vmt_own | The modeled household annual vehicle miles traveled (VMT) for owners for Very Low-Income Individual. |
| HH2_transit_trips_own | The modeled household annual transit trips for owners for Very Low-Income Individual. |
| HH2_ht_rent | The modeled housing and transportation costs as a percent of income for renters for Very Low-Income Individual. |
| HH2_h_rent | The modeled housing costs as a percent of income for renters for Very Low-Income Individual. |
| HH2_t_rent | The modeled transportation costs as a percent of income for renters for Very Low-Income Individual. |
| HH2_autos_rent | The modeled autos per household for renters for Very Low-Income Individual. |
| HH2_vmt_rent | The modeled household annual vehicle miles traveled (VMT) for renters for Very Low-Income Individual. |
| HH2_transit_trips_rent | The modeled household annual transit trips for renters for Very Low-Income Individual. |
| HH3_Income | The income for the geography as defined for Working Individual. |
| HH3_size | The household size for geography as defined for Working Individual. |
| HH3_workers | The number of commuters for the geography as defined for Working Individual. |
| HH3_ht | The modeled housing and transportation costs as a percent of income for Working Individual. |
| HH3_h | The modeled housing costs as a percent of income for Working Individual. |
| HH3_t | The modeled transportation costs as a percent of income for Working Individual. |
| HH3_autos | The modeled autos per household for Working Individual. |
| HH3_vmt | The modeled household annual vehicle miles traveled (VMT) for Working Individual. |
| HH3_transit_trips | The modeled household annual transit trips for Working Individual. |
| HH3_ht_own | The modeled housing and transportation costs as a percent of income for owners for Working Individual. |
| HH3_h_own | The modeled housing costs as a percent of income for owners for Working Individual. |
| HH3_t_own | The modeled transportation costs as a percent of income for owners for Working Individual. |
| HH3_autos_own | The modeled autos per household for owners for Working Individual. |
| HH3_vmt_own | The modeled household annual vehicle miles traveled (VMT) for owners for Working Individual. |
| HH3_transit_trips_own | The modeled household annual transit trips for owners for Working Individual. |
| HH3_ht_rent | The modeled housing and transportation costs as a percent of income for renters for Working Individual. |
| HH3_h_rent | The modeled housing costs as a percent of income for renters for Working Individual. |
| HH3_t_rent | The modeled transportation costs as a percent of income for renters for Working Individual. |
| HH3_autos_rent | The modeled autos per household for renters for Working Individual. |
| HH3_vmt_rent | The modeled household annual vehicle miles traveled (VMT) for renters for Working Individual. |
| HH3_transit_trips_rent | The modeled household annual transit trips for renters for Working Individual. |
| HH4_Income | The income for the geography as defined for Single Professional. |
| HH4_size | The household size for geography as defined for Single Professional. |
| HH4_workers | The number of commuters for the geography as defined for Single Professional. |
| HH4_ht | The modeled housing and transportation costs as a percent of income for Single Professional. |
| HH4_h | The modeled housing costs as a percent of income for Single Professional. |
| HH4_t | The modeled transportation costs as a percent of income for Single Professional. |
| HH4_autos | The modeled autos per household for Single Professional. |
| HH4_vmt | The modeled household annual vehicle miles traveled (VMT) for Single Professional. |
| HH4_transit_trips | The modeled household annual transit trips for Single Professional. |
| HH4_ht_own | The modeled housing and transportation costs as a percent of income for owners for Single Professional. |
| HH4_h_own | The modeled housing costs as a percent of income for owners for Single Professional. |
| HH4_t_own | The modeled transportation costs as a percent of income for owners for Single Professional. |
| HH4_autos_own | The modeled autos per household for owners for Single Professional. |
| HH4_vmt_own | The modeled household annual vehicle miles traveled (VMT) for owners for Single Professional. |
| HH4_transit_trips_own | The modeled household annual transit trips for owners for Single Professional. |
| HH4_ht_rent | The modeled housing and transportation costs as a percent of income for renters for Single Professional. |
| HH4_h_rent | The modeled housing costs as a percent of income for renters for Single Professional. |
| HH4_t_rent | The modeled transportation costs as a percent of income for renters for Single Professional. |
| HH4_autos_rent | The modeled autos per household for renters for Single Professional. |
| HH4_vmt_rent | The modeled household annual vehicle miles traveled (VMT) for renters for Single Professional. |
| HH4_transit_trips_rent | The modeled household annual transit trips for renters for Single Professional. |
| HH5_Income | The income for the geography as defined for Retired Couple. |
| HH5_size | The household size for geography as defined for Retired Couple. |
| HH5_workers | The number of commuters for the geography as defined for Retired Couple. |
| HH5_ht | The modeled housing and transportation costs as a percent of income for Retired Couple. |
| HH5_h | The modeled housing costs as a percent of income for Retired Couple. |
| HH5_t | The modeled transportation costs as a percent of income for Retired Couple. |
| HH5_autos | The modeled autos per household for Retired Couple. |
| HH5_vmt | The modeled household annual vehicle miles traveled (VMT) for Retired Couple. |
| HH5_transit_trips | The modeled household annual transit trips for Retired Couple. |
| HH5_ht_own | The modeled housing and transportation costs as a percent of income for owners for Retired Couple. |
| HH5_h_own | The modeled housing costs as a percent of income for owners for Retired Couple. |
| HH5_t_own | The modeled transportation costs as a percent of income for owners for Retired Couple. |
| HH5_autos_own | The modeled autos per household for owners for Retired Couple. |
| HH5_vmt_own | The modeled household annual vehicle miles traveled (VMT) for owners for Retired Couple. |
| HH5_transit_trips_own | The modeled household annual transit trips for owners for Retired Couple. |
| HH5_ht_rent | The modeled housing and transportation costs as a percent of income for renters for Retired Couple. |
| HH5_h_rent | The modeled housing costs as a percent of income for renters for Retired Couple. |
| HH5_t_rent | The modeled transportation costs as a percent of income for renters for Retired Couple. |
| HH5_autos_rent | The modeled autos per household for renters for Retired Couple. |
| HH5_vmt_rent | The modeled household annual vehicle miles traveled (VMT) for renters for Retired Couple. |
| HH5_transit_trips_rent | The modeled household annual transit trips for renters for Retired Couple. |
| HH6_Income | The income for the geography as defined for Single-Parent Family. |
| HH6_size | The household size for geography as defined for Single-Parent Family. |
| HH6_workers | The number of commuters for the geography as defined for Single-Parent Family. |
| HH6_ht | The modeled housing and transportation costs as a percent of income for Single-Parent Family. |
| HH6_h | The modeled housing costs as a percent of income for Single-Parent Family. |
| HH6_t | The modeled transportation costs as a percent of income for Single-Parent Family. |
| HH6_autos | The modeled autos per household for Single-Parent Family. |
| HH6_vmt | The modeled household annual vehicle miles traveled (VMT) for Single-Parent Family. |
| HH6_transit_trips | The modeled household annual transit trips for Single-Parent Family. |
| HH6_ht_own | The modeled housing and transportation costs as a percent of income for owners for Single-Parent Family. |
| HH6_h_own | The modeled housing costs as a percent of income for owners for Single-Parent Family. |
| HH6_t_own | The modeled transportation costs as a percent of income for owners for Single-Parent Family. |
| HH6_autos_own | The modeled autos per household for owners for Single-Parent Family. |
| HH6_vmt_own | The modeled household annual vehicle miles traveled (VMT) for owners for Single-Parent Family. |
| HH6_transit_trips_own | The modeled household annual transit trips for owners for Single-Parent Family. |
| HH6_ht_rent | The modeled housing and transportation costs as a percent of income for renters for Single-Parent Family. |
| HH6_h_rent | The modeled housing costs as a percent of income for renters for Single-Parent Family. |
| HH6_t_rent | The modeled transportation costs as a percent of income for renters for Single-Parent Family. |
| HH6_autos_rent | The modeled autos per household for renters for Single-Parent Family. |
| HH6_vmt_rent | The modeled household annual vehicle miles traveled (VMT) for renters for Single-Parent Family. |
| HH6_transit_trips_rent | The modeled household annual transit trips for renters for Single-Parent Family. |
| HH7_Income | The income for the geography as defined for Moderate-Income Family. |
| HH7_size | The household size for geography as defined for Moderate-Income Family. |
| HH7_workers | The number of commuters for the geography as defined for Moderate-Income Family. |
| HH7_ht | The modeled housing and transportation costs as a percent of income for Moderate-Income Family. |
| HH7_h | The modeled housing costs as a percent of income for Moderate-Income Family. |
| HH7_t | The modeled transportation costs as a percent of income for Moderate-Income Family. |
| HH7_autos | The modeled autos per household for Moderate-Income Family. |
| HH7_vmt | The modeled household annual vehicle miles traveled (VMT) for Moderate-Income Family. |
| HH7_transit_trips | The modeled household annual transit trips for Moderate-Income Family. |
| HH7_ht_own | The modeled housing and transportation costs as a percent of income for owners for Moderate-Income Family. |
| HH7_h_own | The modeled housing costs as a percent of income for owners for Moderate-Income Family. |
| HH7_t_own | The modeled transportation costs as a percent of income for owners for Moderate-Income Family. |
| HH7_autos_own | The modeled autos per household for owners for Moderate-Income Family. |
| HH7_vmt_own | The modeled household annual vehicle miles traveled (VMT) for owners for Moderate-Income Family. |
| HH7_transit_trips_own | The modeled household annual transit trips for owners for Moderate-Income Family. |
| HH7_ht_rent | The modeled housing and transportation costs as a percent of income for renters for Moderate-Income Family. |
| HH7_h_rent | The modeled housing costs as a percent of income for renters for Moderate-Income Family. |
| HH7_t_rent | The modeled transportation costs as a percent of income for renters for Moderate-Income Family. |
| HH7_autos_rent | The modeled autos per household for renters for Moderate-Income Family. |
| HH7_vmt_rent | The modeled household annual vehicle miles traveled (VMT) for renters for Moderate-Income Family. |
| HH7_transit_trips_rent | The modeled household annual transit trips for renters for Moderate-Income Family. |
| HH8_Income | The income for the geography as defined for Dual-Professional Family. |
| HH8_size | The household size for geography as defined for Dual-Professional Family. |
| HH8_workers | The number of commuters for the geography as defined for Dual-Professional Family. |
| HH8_ht | The modeled housing and transportation costs as a percent of income for Dual-Professional Family. |
| HH8_h | The modeled housing costs as a percent of income for Dual-Professional Family. |
| HH8_t | The modeled transportation costs as a percent of income for Dual-Professional Family. |
| HH8_autos | The modeled autos per household for Dual-Professional Family. |
| HH8_vmt | The modeled household annual vehicle miles traveled (VMT) for Dual-Professional Family. |
| HH8_transit_trips | The modeled household annual transit trips for Dual-Professional Family. |
| HH8_ht_own | The modeled housing and transportation costs as a percent of income for owners for Dual-Professional Family. |
| HH8_h_own | The modeled housing costs as a percent of income for owners for Dual-Professional Family. |
| HH8_t_own | The modeled transportation costs as a percent of income for owners for Dual-Professional Family. |
| HH8_autos_own | The modeled autos per household for owners for Dual-Professional Family. |
| HH8_vmt_own | The modeled household annual vehicle miles traveled (VMT) for owners for Dual-Professional Family. |
| HH8_transit_trips_own | The modeled household annual transit trips for owners for Dual-Professional Family. |
| HH8_ht_rent | The modeled housing and transportation costs as a percent of income for renters for Dual-Professional Family. |
| HH8_h_rent | The modeled housing costs as a percent of income for renters for Dual-Professional Family. |
| HH8_t_rent | The modeled transportation costs as a percent of income for renters for Dual-Professional Family. |
| HH8_autos_rent | The modeled autos per household for renters for Dual-Professional Family. |
| HH8_vmt_rent | The modeled household annual vehicle miles traveled (VMT) for renters for Dual-Professional Family. |
| HH8_transit_trips_rent | The modeled household annual transit trips for renters for Dual-Professional Family. |
LEHD LODES 7 Origin-Destination Matrix 2013
Dataset
| Pos | Variable | Type | Explanation |
|---|---|---|---|
| 1 | w_geocode | Char15 | Workplace Census Block Code |
| 2 | h_geocode | Char15 | Residence Census Block Code |
| 3 | S000 | Num | Total number of jobs |
| 4 | SA01 | Num | Number of jobs of workers age 29 or younger11 |
| 5 | SA02 | Num | Number of jobs for workers age 30 to 5411 |
| 6 | SA03 | Num | Number of jobs for workers age 55 or older11 |
| 7 | SE01 | Num | Number of jobs with earnings $1250/month or less |
| 8 | SE02 | Num | Number of jobs with earnings $1251/month to $3333/month |
| 9 | SE03 | Num | Number of jobs with earnings greater than $3333/month |
| 10 | SI01 | Num | Number of jobs in Goods Producing industry sectors |
| 11 | SI02 | Num | Number of jobs in Trade, Transportation, and Utilities industry sectors |
| 12 | SI03 | Num | Number of jobs in All Other Services industry sectors |
| 13 | createdate | Char | Date on which data was created, formatted as YYYYMMDD |
LEHD LODES 7 Residence Area Characteristics 2013
Dataset
| Pos | Variable | Type | Explanation |
|---|---|---|---|
| 1 | h_geocode | Char15 | Residence Census Block Code |
| 2 | C000 | Num | Total number of jobs |
| 3 | CA01 | Num | Number of jobs for workers age 29 or younger11 |
| 4 | CA02 | Num | Number of jobs for workers age 30 to 5411 |
| 5 | CA03 | Num | Number of jobs for workers age 55 or older11 |
| 6 | CE01 | Num | Number of jobs with earnings $1250/month or less |
| 7 | CE02 | Num | Number of jobs with earnings $1251/month to $3333/month |
| 8 | CE03 | Num | Number of jobs with earnings greater than $3333/month |
| 9 | CNS01 | Num | Number of jobs in NAICS sector 11 (Agriculture, Forestry, Fishing and Hunting) |
| 10 | CNS02 | Num | Number of jobs in NAICS sector 21 (Mining, Quarrying, and Oil and Gas Extraction) |
| 11 | CNS03 | Num | Number of jobs in NAICS sector 22 (Utilities) |
| 12 | CNS04 | Num | Number of jobs in NAICS sector 23 (Construction) |
| 13 | CNS05 | Num | Number of jobs in NAICS sector 31-33 (Manufacturing) |
| 14 | CNS06 | Num | Number of jobs in NAICS sector 42 (Wholesale Trade) |
| 15 | CNS07 | Num | Number of jobs in NAICS sector 44-45 (Retail Trade) |
| 16 | CNS08 | Num | Number of jobs in NAICS sector 48-49 (Transportation and Warehousing) |
| 17 | CNS09 | Num | Number of jobs in NAICS sector 51 (Information) |
| 18 | CNS10 | Num | Number of jobs in NAICS sector 52 (Finance and Insurance) |
| 19 | CNS11 | Num | Number of jobs in NAICS sector 53 (Real Estate and Rental and Leasing) |
| 20 | CNS12 | Num | Number of jobs in NAICS sector 54 (Professional, Scientific, and Technical Services) |
| 21 | CNS13 | Num | Number of jobs in NAICS sector 55 (Management of Companies and Enterprises) |
| 22 | CNS14 | Num | Number of jobs in NAICS sector 56 (Administrative and Support and Waste Management and Remediation Services) |
| 23 | CNS15 | Num | Number of jobs in NAICS sector 61 (Educational Services) |
| 24 | CNS16 | Num | Number of jobs in NAICS sector 62 (Health Care and Social Assistance) |
| 25 | CNS17 | Num | Number of jobs in NAICS sector 71 (Arts, Entertainment, and Recreation) |
| 26 | CNS18 | Num | Number of jobs in NAICS sector 72 (Accommodation and Food Services) |
| 27 | CNS19 | Num | Number of jobs in NAICS sector 81 (Other Services [except Public Administration]) |
| 28 | CNS20 | Num | Number of jobs in NAICS sector 92 (Public Administration) |
| 29 | CR01 | Num | Number of jobs for workers with Race: White, Alone |
| 30 | CR02 | Num | Number of jobs for workers with Race: Black or African American Alone |
| 31 | CR03 | Num | Number of jobs for workers with Race: American Indian or Alaska Native Alone |
| 32 | CR04 | Num | Number of jobs for workers with Race: Asian Alone |
| 33 | CR05 | Num | Number of jobs for workers with Race: Native Hawaiian or Other Pacific Islander Alone |
| 34 | CR07 | Num | Number of jobs for workers with Race: Two or More Race Groups |
| 35 | CT01 | Num | Number of jobs for workers with Ethnicity: Not Hispanic or Latino |
| 36 | CT02 | Num | Number of jobs for workers with Ethnicity: Hispanic or Latino |
| 37 | CD01 | Num | Number of jobs for workers with Educational Attainment: Less than high school |
| 38 | CD02 | Num | Number of jobs for workers with Educational Attainment: High school or equivalent, no college |
| 39 | CD03 | Num | Number of jobs for workers with Educational Attainment: Some college or Associate degree |
| 40 | CD04 | Num | Number of jobs for workers with Educational Attainment: Bachelor's degree or advanced degree |
| 41 | CS01 | Num | Number of jobs for workers with Sex: Male |
| 42 | CS02 | Num | Number of jobs for workers with Sex: Female |
| 43 | createdate | Char | Date on which data was created, formatted as YYYYMMDD |
LEHD LODES 7 Workplace Area Characteristics 2013
Dataset
| Pos | Variable | Type | Explanation |
|---|---|---|---|
| 1 | w_geocode | Char15 | Workplace Census Block Code |
| 2 | C000 | Num | Total number of jobs |
| 3 | CA01 | Num | Number of jobs for workers age 29 or younger |
| 4 | CA02 | Num | Number of jobs for workers age 30 to 54 |
| 5 | CA03 | Num | Number of jobs for workers age 55 or older |
| 6 | CE01 | Num | Number of jobs with earnings $1250/month or less |
| 7 | CE02 | Num | Number of jobs with earnings $1251/month to $3333/month |
| 8 | CE03 | Num | Number of jobs with earnings greater than $3333/month |
| 9 | CNS01 | Num | Number of jobs in NAICS sector 11 (Agriculture, Forestry, Fishing and Hunting) |
| 10 | CNS02 | Num | Number of jobs in NAICS sector 21 (Mining, Quarrying, and Oil and Gas Extraction) |
| 11 | CNS03 | Num | Number of jobs in NAICS sector 22 (Utilities) |
| 12 | CNS04 | Num | Number of jobs in NAICS sector 23 (Construction) |
| 13 | CNS05 | Num | Number of jobs in NAICS sector 31-33 (Manufacturing) |
| 14 | CNS06 | Num | Number of jobs in NAICS sector 42 (Wholesale Trade) |
| 15 | CNS07 | Num | Number of jobs in NAICS sector 44-45 (Retail Trade) |
| 16 | CNS08 | Num | Number of jobs in NAICS sector 48-49 (Transportation and Warehousing) |
| 17 | CNS09 | Num | Number of jobs in NAICS sector 51 (Information) |
| 18 | CNS10 | Num | Number of jobs in NAICS sector 52 (Finance and Insurance) |
| 19 | CNS11 | Num | Number of jobs in NAICS sector 53 (Real Estate and Rental and Leasing) |
| 20 | CNS12 | Num | Number of jobs in NAICS sector 54 (Professional, Scientific, and Technical Services) |
| 21 | CNS13 | Num | Number of jobs in NAICS sector 55 (Management of Companies and Enterprises) |
| 22 | CNS14 | Num | Number of jobs in NAICS sector 56 (Administrative and Support and Waste Management and Remediation Services) |
| 23 | CNS15 | Num | Number of jobs in NAICS sector 61 (Educational Services) |
| 24 | CNS16 | Num | Number of jobs in NAICS sector 62 (Health Care and Social Assistance) |
| 25 | CNS17 | Num | Number of jobs in NAICS sector 71 (Arts, Entertainment, and Recreation) |
| 26 | CNS18 | Num | Number of jobs in NAICS sector 72 (Accommodation and Food Services) |
| 27 | CNS19 | Num | Number of jobs in NAICS sector 81 (Other Services [except Public Administration]) |
| 28 | CNS20 | Num | Number of jobs in NAICS sector 92 (Public Administration) |
| 29 | CR01 | Num | Number of jobs for workers with Race: White, Alone |
| 30 | CR02 | Num | Number of jobs for workers with Race: Black or African American Alone |
| 31 | CR03 | Num | Number of jobs for workers with Race: American Indian or Alaska Native Alone |
| 32 | CR04 | Num | Number of jobs for workers with Race: Asian Alone |
| 33 | CR05 | Num | Number of jobs for workers with Race: Native Hawaiian or Other Pacific Islander Alone |
| 34 | CR07 | Num | Number of jobs for workers with Race: Two or More Race Groups |
| 35 | CT01 | Num | Number of jobs for workers with Ethnicity: Not Hispanic or Latino |
| 36 | CT02 | Num | Number of jobs for workers with Ethnicity: Hispanic or Latino |
| 37 | CD01 | Num | Number of jobs for workers with Educational Attainment: Less than high school |
| 38 | CD02 | Num | Number of jobs for workers with Educational Attainment: High school or equivalent, no college |
| 39 | CD03 | Num | Number of jobs for workers with Educational Attainment: Some college or Associate degree |
| 40 | CD04 | Num | Number of jobs for workers with Educational Attainment: Bachelor's degree or advanced degree |
| 41 | CS01 | Num | Number of jobs for workers with Sex: Male |
| 42 | CS02 | Num | Number of jobs for workers with Sex: Female |
| 43 | CFA01 | Num | Number of jobs for workers at firms with Firm Age: 0-1 Years |
| 44 | CFA02 | Num | Number of jobs for workers at firms with Firm Age: 2-3 Years |
| 45 | CFA03 | Num | Number of jobs for workers at firms with Firm Age: 4-5 Years |
| 46 | CFA04 | Num | Number of jobs for workers at firms with Firm Age: 6-10 Years |
| 47 | CFA05 | Num | Number of jobs for workers at firms with Firm Age: 11+ Years |
| 48 | CFS01 | Num | Number of jobs for workers at firms with Firm Size: 0-19 Employees |
| 49 | CFS02 | Num | Number of jobs for workers at firms with Firm Size: 20-49 Employees |
| 50 | CFS03 | Num | Number of jobs for workers at firms with Firm Size: 50-249 Employees |
| 51 | CFS04 | Num | Number of jobs for workers at firms with Firm Size: 250-499 Employees |
| 52 | CFS05 | Num | Number of jobs for workers at firms with Firm Size: 500+ Employees |
| 53 | createdate | Char | Date on which data was created, formatted as YYYYMMDD |
Environmental Justice Indices
Dataset
| Field | Description |
|---|---|
| STATE_NAME | State |
| BlkGrp | Block Group |
| pctpre1960 | % pre-1960 housing (lead paint indicator) |
| dpm | Diesel particulate matter level in air |
| cancer | Air toxics cancer risk |
| resp | Air toxics respiratory hazard index |
| neuro | Air toxics neurological hazard index |
| traffic_sc | Traffic proximity and volume |
| proximity_ | Proximity to major direct dischargers to water |
| proximity1 | Proximity to National Priorities List (NPL) sites |
| proximit_1 | Proximity to Risk Management Plan (RMP) facilities |
| proximit_2 | Proximity to Treatment Storage and Disposal (TSDF) facilities |
| o3 | Ozone level in air |
| pm | PM2.5 level in air |
| statename | Two-letter abbreviation for State |
| ST | State |
| EJ_DISPARI | EJ Index for % pre-1960 housing (lead paint indicator) |
| EJ_DISPA_1 | EJ Index for Diesel particulate matter level in air |
| EJ_DISPA_2 | EJ Index for Air toxics cancer risk |
| EJ_DISPA_3 | EJ Index for Air toxics respiratory hazard index |
| EJ_DISPA_4 | EJ Index for Air toxics neurological hazard index |
| EJ_DISPA_5 | EJ Index for Traffic proximity and volume |
| EJ_DISPA_6 | EJ Index for Proximity to major direct dischargers to water |
| EJ_DISPA_7 | EJ Index for Proximity to National Priorities List (NPL) sites |
| EJ_DISPA_8 | EJ Index for Proximity to Risk Management Plan (RMP) facilities |
| EJ_DISPA_9 | EJ Index for Proximity to Treatment Storage and Disposal (TSDF) facilities |
| EJ_DISP_10 | EJ Index for Ozone level in air |
| EJ_DISP_11 | EJ Index for PM2.5 level in air |
| pctile_pct | Percentile for % pre-1960 housing (lead paint indicator) |
| pctile_dpm | Percentile for Diesel particulate matter level in air |
| pctile_can | Percentile for Air toxics cancer risk |
| pctile_res | Percentile for Air toxics respiratory hazard index |
| pctile_neu | Percentile for Air toxics neurological hazard index |
| pctile_tra | Percentile for Traffic proximity and volume |
| pctile_pro | Percentile for Proximity to major direct dischargers to water |
| pctile_p_1 | Percentile for Proximity to National Priorities List (NPL) sites |
| pctile_p_2 | Percentile for Proximity to Risk Management Plan (RMP) facilities |
| pctile_p_3 | Percentile for Proximity to Treatment Storage and Disposal (TSDF) facilities |
| pctile_o3 | Percentile for Ozone level in air |
| pctile_pm | Percentile for PM2.5 level in air |
| pctile_EJ_ | Percentile for EJ Index for % pre-1960 housing (lead paint indicator) |
| pctile_EJ1 | Percentile for EJ Index for Diesel particulate matter level in air |
| pctile_E_1 | Percentile for EJ Index for Air toxics cancer risk |
| pctile_E_2 | Percentile for EJ Index for Air toxics respiratory hazard index |
| pctile_E_3 | Percentile for EJ Index for Air toxics neurological hazard index |
| pctile_E_4 | Percentile for EJ Index for Traffic proximity and volume |
| pctile_E_5 | Percentile for EJ Index for Proximity to major direct dischargers to water |
| pctile_E_6 | Percentile for EJ Index for Proximity to National Priorities List (NPL) sites |
| pctile_E_7 | Percentile for EJ Index for Proximity to Risk Management Plan (RMP) facilities |
| pctile_E_8 | Percentile for EJ Index for Proximity to Treatment Storage and Disposal (TSDF) facilities |
| pctile_E_9 | Percentile for EJ Index for Ozone level in air |
| pctile__10 | Percentile for EJ Index for PM2.5 level in air |
ACS 5 Year CHAS Data by Summary Level 080 as of 2012
Dataset
| Field | Definition |
|---|---|
| GEOID | Geographic Identifier |
| STUSAB | Census 2-digit FIPS State Code |
| COUNTY | State US Postal Abbreviation |
| COUNTYNAME | Census 5-digit FIPS County Code |
| TRACT | County Name |
| COUSUB | Census 6-digit Census Tract Code (leading zeros preserved, no decimal places) |
| COUSUBNAME | Census 10-digit FIPS County Subdivision Code |
| PLACE | County Subdivision Name |
| PLACENAME | Census 7-digit FIPS Place Code |
| CDBGUOGID | Name of Place |
| CDBGNAME | CDBG Grantee ID |
| CDBGTY | CDBG Grantee Name |
| HOMEUOGID | CDBG Grantee Type |
| HOMENAME | HOME Grantee ID |
| HOMETY | HOME Grantee Name |
| HOPWAUOGID | HOME Grantee Type |
| HOPWANAME | UOGID = State FIPS code plus Grantee HUD locality code |
| HOPWATY | HOPWA Grantee Name |
| EACODE | Bureau of Economic Analysis (BEA) Economic Area Code |
| EANAME | Bureau of Economic Analysis (BEA) Economic Area Name |
| ESGUOGID | ESG Grantee ID |
| ESGNAME | ESG Grantee Name |
| ESGTY | ESG Grantee Type |
| UGLGKEY | Units of General Local Government (UGLG) ID |
| UGLGNAME | Name of UGLG |
| UGLGSUMLEV | Census Summary Level |
| COCNUM | Continuum of Care |
| COCNAME | Continuum of Care Name |
| T2_EST1 | Total: Occupied housing units |
| T8_EST69 | Renter occupied AND household income is less than or equal to 30% of HAMFI |
| T8_EST82 | Renter occupied AND household income is greater than 30% but less than or equal to 50% of HAMFI |
| T8_EST95 | Renter occupied AND household income is greater than 50% but less than or equal to 80% of HAMFI |
| T8_EST108 | Renter occupied AND household income is greater than 80% but less than or equal to 100% of HAMFI |
| T8_EST68 | Renter occupied |
| T8_EST3 | Owner occupied AND household income is less than or equal to 30% of HAMFI |
| T8_EST16 | Owner occupied AND household income is greater than 30% but less than or equal to 50% of HAMFI |
| T8_EST29 | Owner occupied AND household income is greater than 50% but less than or equal to 80% of HAMFI |
| T8_EST42 | Owner occupied AND household income is greater than 80% but less than or equal to 100% of HAMFI |
| T8_EST2 | Owner occupied |
| T3_EST47 | Renter occupied AND lacking complete plumbing or kitchen facilities AND household income is less than or equal to 30% of HAMFI |
| T3_EST48 | Renter occupied AND lacking complete plumbing or kitchen facilities AND household income is greater than 30% but less than or equal to 50% of HAMFI |
| T3_EST49 | Renter occupied AND lacking complete plumbing or kitchen facilities AND household income is greater than 50% but less than or equal to 80% of HAMFI |
| T3_EST50 | Renter occupied AND lacking complete plumbing or kitchen facilities AND household income is greater than 80% but less than or equal to 100% of HAMFI |
| T3_EST46 | Renter occupied AND lacking complete plumbing or kitchen facilities |
| T3_EST4 | Owner occupied AND lacking complete plumbing or kitchen facilities AND household income is less than or equal to 30% of HAMFI |
| T3_EST5 | Owner occupied AND lacking complete plumbing or kitchen facilities AND household income is greater than 30% but less than or equal to 50% of HAMFI |
| T3_EST6 | Owner occupied AND lacking complete plumbing or kitchen facilities AND household income is greater than 50% but less than or equal to 80% of HAMFI |
| T3_EST7 | Owner occupied AND lacking complete plumbing or kitchen facilities AND household income is greater than 80% but less than or equal to 100% of HAMFI |
| T3_EST3 | Owner occupied AND lacking complete plumbing or kitchen facilities |
| T3_EST53 | Renter occupied AND with more than 1.5 persons per room, None of the needs above AND household income is less than or equal to 30% of HAMFI |
| T3_EST54 | Renter occupied AND with more than 1.5 persons per room, None of the needs above AND household income is greater than 30% but less than or equal to 50% of HAMFI |
| T3_EST55 | Renter occupied AND with more than 1.5 persons per room, None of the needs above AND household income is greater than 50% but less than or equal to 80% of HAMFI |
| T3_EST56 | Renter occupied AND with more than 1.5 persons per room, None of the needs above AND household income is greater than 80% but less than or equal to 100% of HAMFI |
| T3_EST52 | Renter occupied AND with more than 1.5 persons per room, None of the needs above |
| T3_EST10 | Owner occupied AND with more than 1.5 persons per room, None of the needs above AND household income is less than or equal to 30% of HAMFI |
| T3_EST11 | Owner occupied AND with more than 1.5 persons per room, None of the needs above AND household income is greater than 30% but less than or equal to 50% of HAMFI |
| T3_EST12 | Owner occupied AND with more than 1.5 persons per room, None of the needs above AND household income is greater than 50% but less than or equal to 80% of HAMFI |
| T3_EST13 | Owner occupied AND with more than 1.5 persons per room, None of the needs above AND household income is greater than 80% but less than or equal to 100% of HAMFI |
| T3_EST9 | Owner occupied AND with more than 1.5 persons per room, None of the needs above |
| T3_EST59 | Renter occupied AND with more than 1 but less than or equal to 1.5 persons per room, None of the needs above AND household income is less than or equal to 30% of HAMFI |
| T3_EST60 | Renter occupied AND with more than 1 but less than or equal to 1.5 persons per room, None of the needs above AND household income is greater than 30% but less than or equal to 50% of HAMFI |
| T3_EST61 | Renter occupied AND with more than 1 but less than or equal to 1.5 persons per room, None of the needs above AND household income is greater than 50% but less than or equal to 80% of HAMFI |
| T3_EST62 | Renter occupied AND with more than 1 but less than or equal to 1.5 persons per room, None of the needs above AND household income is greater than 80% but less than or equal to 100% of HAMFI |
| T3_EST58 | Renter occupied AND with more than 1 but less than or equal to 1.5 persons per room, None of the needs above |
| T3_EST16 | Owner occupied AND with more than 1 but less than or equal to 1.5 persons per room, None of the needs above AND household income is less than or equal to 30% of HAMFI |
| T3_EST17 | Owner occupied AND with more than 1 but less than or equal to 1.5 persons per room, None of the needs above AND household income is greater than 30% but less than or equal to 50% of HAMFI |
| T3_EST18 | Owner occupied AND with more than 1 but less than or equal to 1.5 persons per room, None of the needs above AND household income is greater than 50% but less than or equal to 80% of HAMFI |
| T3_EST19 | Owner occupied AND with more than 1 but less than or equal to 1.5 persons per room, None of the needs above AND household income is greater than 80% but less than or equal to 100% of HAMFI |
| T3_EST15 | Owner occupied AND with more than 1 but less than or equal to 1.5 persons per room, None of the needs above |
| T3_EST65 | Renter occupied AND with housing cost burden greater than 50%, None of the needs above AND household income is less than or equal to 30% of HAMFI |
| T3_EST66 | Renter occupied AND with housing cost burden greater than 50%, None of the needs above AND household income is greater than 30% but less than or equal to 50% of HAMFI |
| T3_EST67 | Renter occupied AND with housing cost burden greater than 50%, None of the needs above AND household income is greater than 50% but less than or equal to 80% of HAMFI |
| T3_EST68 | Renter occupied AND with housing cost burden greater than 50%, None of the needs above AND household income is greater than 80% but less than or equal to 100% of HAMFI |
| T3_EST64 | Renter occupied AND with housing cost burden greater than 50%, None of the needs above |
| T3_EST22 | Owner occupied AND with housing cost burden greater than 50%, None of the needs above AND household income is less than or equal to 30% of HAMFI |
| T3_EST23 | Owner occupied AND with housing cost burden greater than 50%, None of the needs above AND household income is greater than 30% but less than or equal to 50% of HAMFI |
| T3_EST24 | Owner occupied AND with housing cost burden greater than 50%, None of the needs above AND household income is greater than 50% but less than or equal to 80% of HAMFI |
| T3_EST25 | Owner occupied AND with housing cost burden greater than 50%, None of the needs above AND household income is greater than 80% but less than or equal to 100% of HAMFI |
| T3_EST21 | Owner occupied AND with housing cost burden greater than 50%, None of the needs above |
| T3_EST71 | Renter occupied AND with housing cost burden greater than 30% but less than or equal to 50%, None of the needs above AND household income is less than or equal to 30% of HAMFI |
| T3_EST72 | Renter occupied AND with housing cost burden greater than 30% but less than or equal to 50%, None of the needs above AND household income is greater than 30% but less than or equal to 50% of HAMFI |
| T3_EST73 | Renter occupied AND with housing cost burden greater than 30% but less than or equal to 50%, None of the needs above AND household income is greater than 50% but less than or equal to 80% of HAMFI |
| T3_EST74 | Renter occupied AND with housing cost burden greater than 30% but less than or equal to 50%, None of the needs above AND household income is greater than 80% but less than or equal to 100% of HAMFI |
| T3_EST70 | Renter occupied AND with housing cost burden greater than 30% but less than or equal to 50%, None of the needs above |
| T3_EST28 | Owner occupied AND with housing cost burden greater than 30% but less than or equal to 50%, None of the needs above AND household income is less than or equal to 30% of HAMFI |
| T3_EST29 | Owner occupied AND with housing cost burden greater than 30% but less than or equal to 50%, None of the needs above AND household income is greater than 30% but less than or equal to 50% of HAMFI |
| T3_EST30 | Owner occupied AND with housing cost burden greater than 30% but less than or equal to 50%, None of the needs above AND household income is greater than 50% but less than or equal to 80% of HAMFI |
| T3_EST31 | Owner occupied AND with housing cost burden greater than 30% but less than or equal to 50%, None of the needs above AND household income is greater than 80% but less than or equal to 100% of HAMFI |
| T3_EST27 | Owner occupied AND with housing cost burden greater than 30% but less than or equal to 50%, None of the needs above |
| T3_EST77 | Renter occupied AND housing cost burden not computed, None of the needs above AND household income is less than or equal to 30% of HAMFI |
| T3_EST78 | Renter occupied AND housing cost burden not computed, None of the needs above AND household income is greater than 30% but less than or equal to 50% of HAMFI |
| T3_EST79 | Renter occupied AND housing cost burden not computed, None of the needs above AND household income is greater than 50% but less than or equal to 80% of HAMFI |
| T3_EST80 | Renter occupied AND housing cost burden not computed, None of the needs above AND household income is greater than 80% but less than or equal to 100% of HAMFI |
| T3_EST76 | Renter occupied AND housing cost burden not computed, None of the needs above |
| T3_EST34 | Owner occupied AND housing cost burden not computed, None of the needs above AND household income is less than or equal to 30% of HAMFI |
| T3_EST35 | Owner occupied AND housing cost burden not computed, None of the needs above AND household income is greater than 30% but less than or equal to 50% of HAMFI |
| T3_EST36 | Owner occupied AND housing cost burden not computed, None of the needs above AND household income is greater than 50% but less than or equal to 80% of HAMFI |
| T3_EST37 | Owner occupied AND housing cost burden not computed, None of the needs above AND household income is greater than 80% but less than or equal to 100% of HAMFI |
| T3_EST33 | Owner occupied AND housing cost burden not computed, None of the needs above |
| T2_EST128 | Renter occupied AND has 1 or more of the 4 severe housing unit problems AND household income is less than or equal to 30% of HAMFI |
| T2_EST136 | Renter occupied AND has 1 or more of the 4 severe housing unit problems AND household income is greater than 30% but less than or equal to 50% of HAMFI |
| T2_EST144 | Renter occupied AND has 1 or more of the 4 severe housing unit problems AND household income is greater than 50% but less than or equal to 80% of HAMFI |
| T2_EST152 | Renter occupied AND has 1 or more of the 4 severe housing unit problems AND household income is greater than 80% but less than or equal to 100% of HAMFI |
| T2_EST127 | Renter occupied AND has 1 or more of the 4 severe housing unit problems |
| T2_EST4 | Owner occupied AND has 1 or more of the 4 severe housing unit problems AND household income is less than or equal to 30% of HAMFI |
| T2_EST12 | Owner occupied AND has 1 or more of the 4 severe housing unit problems AND household income is greater than 30% but less than or equal to 50% of HAMFI |
| T2_EST20 | Owner occupied AND has 1 or more of the 4 severe housing unit problems AND household income is greater than 50% but less than or equal to 80% of HAMFI |
| T2_EST28 | Owner occupied AND has 1 or more of the 4 severe housing unit problems AND household income is greater than 80% but less than or equal to 100% of HAMFI |
| T2_EST3 | Owner occupied AND has 1 or more of the 4 severe housing unit problems |
| T2_EST169 | Renter occupied AND has None of the 4 severe housing unit problems AND household income is less than or equal to 30% of HAMFI |
| T2_EST177 | Renter occupied AND has None of the 4 severe housing unit problems AND household income is greater than 30% but less than or equal to 50% of HAMFI |
| T2_EST185 | Renter occupied AND has None of the 4 severe housing unit problems AND household income is greater than 50% but less than or equal to 80% of HAMFI |
| T2_EST193 | Renter occupied AND has None of the 4 severe housing unit problems AND household income is greater than 80% but less than or equal to 100% of HAMFI |
| T2_EST168 | Renter occupied AND has None of the 4 severe housing unit problems |
| T2_EST45 | Owner occupied AND has None of the 4 severe housing unit problems AND household income is less than or equal to 30% of HAMFI |
| T2_EST53 | Owner occupied AND has None of the 4 severe housing unit problems AND household income is greater than 30% but less than or equal to 50% of HAMFI |
| T2_EST61 | Owner occupied AND has None of the 4 severe housing unit problems AND household income is greater than 50% but less than or equal to 80% of HAMFI |
| T2_EST69 | Owner occupied AND has None of the 4 severe housing unit problems AND household income is greater than 80% but less than or equal to 100% of HAMFI |
| T2_EST44 | Owner occupied AND has None of the 4 severe housing unit problems |
| T2_EST210 | Renter occupied AND cost burden not computed, household has None of the other severe housing problems AND household income is less than or equal to 30% of HAMFI |
| T2_EST218 | Renter occupied AND cost burden not computed, household has None of the other severe housing problems AND household income is greater than 30% but less than or equal to 50% of HAMFI |
| T2_EST226 | Renter occupied AND cost burden not computed, household has None of the other severe housing problems AND household income is greater than 50% but less than or equal to 80% of HAMFI |
| T2_EST234 | Renter occupied AND cost burden not computed, household has None of the other severe housing problems AND household income is greater than 80% but less than or equal to 100% of HAMFI |
| T2_EST209 | Renter occupied AND cost burden not computed, household has None of the other severe housing problems |
| T2_EST86 | Owner occupied AND cost burden not computed, household has None of the other severe housing problems AND household income is less than or equal to 30% of HAMFI |
| T2_EST94 | Owner occupied AND cost burden not computed, household has None of the other severe housing problems AND household income is greater than 30% but less than or equal to 50% of HAMFI |
| T2_EST102 | Owner occupied AND cost burden not computed, household has None of the other severe housing problems AND household income is greater than 50% but less than or equal to 80% of HAMFI |
| T2_EST110 | Owner occupied AND cost burden not computed, household has None of the other severe housing problems AND household income is greater than 80% but less than or equal to 100% of HAMFI |
| T2_EST85 | Owner occupied AND cost burden not computed, household has None of the other severe housing problems |
| T7_LE30_SF | Renter occupied AND household income is less than or equal to 30% of HAMFI AND household type is small family (2 persons, neither person 62 years or over, or 3 or 4 persons) AND housing cost burden is greater than 30% |
| T7_GT30_LE | Renter occupied AND household income is greater than 30% but less than or equal to 50% of HAMFI AND household type is small family (2 persons, neither person 62 years or over, or 3 or 4 persons) AND housing cost burden is greater than 30% |
| T7_GT50_LE | Renter occupied AND household income is greater than 50% but less than or equal to 80% of HAMFI AND household type is small family (2 persons, neither person 62 years or over, or 3 or 4 persons) AND housing cost burden is greater than 30% |
| T7_SF_CB_R | Renter occupied AND household type is small family (2 persons, neither person 62 years or over, or 3 or 4 persons) AND housing cost burden is greater than 30% |
| T7_LE30__1 | Owner occupied AND household income is less than or equal to 30% of HAMFI AND household type is small family (2 persons, neither person 62 years or over, or 3 or 4 persons) AND housing cost burden is greater than 30% |
| T7_GT30__1 | Owner occupied AND household income is greater than 30% but less than or equal to 50% of HAMFI AND household type is small family (2 persons, neither person 62 years or over, or 3 or 4 persons) AND housing cost burden is greater than 30% |
| T7_GT50__1 | Owner occupied AND household income is greater than 50% but less than or equal to 80% of HAMFI AND household type is small family (2 persons, neither person 62 years or over, or 3 or 4 persons) AND housing cost burden is greater than 30% |
| T7_SF_CB_O | Owner occupied AND household type is small family (2 persons, neither person 62 years or over, or 3 or 4 persons) AND housing cost burden is greater than 30% |
| T7_LE30_LF | Renter occupied AND household income is less than or equal to 30% of HAMFI AND household type is large family (5 or more persons) AND housing cost burden is greater than 30% |
| T7_GT30__2 | Renter occupied AND household income is greater than 30% but less than or equal to 50% of HAMFI AND household type is large family (5 or more persons) AND housing cost burden is greater than 30% |
| T7_GT50__2 | Renter occupied AND household income is greater than 50% but less than or equal to 80% of HAMFI AND household type is large family (5 or more persons) AND housing cost burden is greater than 30% |
| T7_LF_CB_R | Renter occupied AND household type is large family (5 or more persons) AND housing cost burden is greater than 30% |
| T7_LE30__2 | Owner occupied AND household type is large family (5 or more persons) AND housing cost burden is greater than 30% |
| T7_GT30__3 | Owner occupied AND household income is greater than 30% but less than or equal to 50% of HAMFI AND household type is large family (5 or more persons) AND housing cost burden is greater than 30% |
| T7_GT50__3 | Owner occupied AND household income is greater than 50% but less than or equal to 80% of HAMFI AND household type is large family (5 or more persons) AND housing cost burden is greater than 30% |
| T7_LF_CB_O | Owner occupied AND household type is large family (5 or more persons) AND housing cost burden is greater than 30% |
| T7_LE30_EL | Renter occupied AND household income is less than or equal to 30% of HAMFI AND household type is elderly (elderly non-family household or family household with 2 people, at least one of which is elderly) AND housing cost burden is greater than 30% |
| T7_GT30__4 | Renter occupied AND household income is greater than 30% but less than or equal to 50% of HAMFI AND household type is elderly (elderly non-family household or family household with 2 people, at least one of which is elderly) AND housing cost burden is greater than 30% |
| T7_GT50__4 | Renter occupied AND household income is greater than 50% but less than or equal to 80% of HAMFI AND household type is elderly (elderly non-family household or family household with 2 people, at least one of which is elderly) AND housing cost burden is greater than 30% |
| T7_ELD_CB_ | Renter occupied AND household type is elderly (elderly non-family household or family household with 2 people, at least one of which is elderly) AND housing cost burden is greater than 30% |
| T7_LE30__3 | Owner occupied AND household income is less than or equal to 30% of HAMFI AND household type is elderly (elderly non-family household or family household with 2 people, at least one of which is elderly) AND housing cost burden is greater than 30% |
| T7_GT30__5 | Owner occupied AND household income is greater than 30% but less than or equal to 50% of HAMFI AND household type is elderly (elderly non-family household or family household with 2 people, at least one of which is elderly) AND housing cost burden is greater than 30% |
| T7_GT50__5 | Owner occupied AND household income is greater than 50% but less than or equal to 80% of HAMFI AND household type is elderly (elderly non-family household or family household with 2 people, at least one of which is elderly) AND housing cost burden is greater than 30% |
| T7_ELD_C_1 | Owner occupied AND household type is elderly (elderly non-family household or family household with 2 people, at least one of which is elderly) AND housing cost burden is greater than 30% |
| T7_LE30_OT | Renter occupied AND household income is less than or equal to 30% of HAMFI AND other household type (non-elderly non-family) AND housing cost burden is greater than 30% |
| T7_GT30__6 | Renter occupied AND household income is greater than 30% but less than or equal to 50% of HAMFI AND other household type (non-elderly non-family) AND housing cost burden is greater than 30% |
| T7_GT50__6 | Renter occupied AND household income is greater than 50% but less than or equal to 80% of HAMFI AND other household type (non-elderly non-family) AND housing cost burden is greater than 30% |
| T7_OTHER_C | Renter occupied AND other household type (non-elderly non-family) AND housing cost burden is greater than 30% |
| T7_LE30__4 | Owner occupied AND household income is less than or equal to 30% of HAMFI AND other household type (non-elderly non-family) AND housing cost burden is greater than 30% |
| T7_GT30__7 | Owner occupied AND household income is greater than 30% but less than or equal to 50% of HAMFI AND other household type (non-elderly non-family) AND housing cost burden is greater than 30% |
| T7_GT50__7 | Owner occupied AND household income is greater than 50% but less than or equal to 80% of HAMFI AND other household type (non-elderly non-family) AND housing cost burden is greater than 30% |
| T7_OTHER_1 | Owner occupied AND other household type (non-elderly non-family) AND housing cost burden is greater than 30% |
| T7_EST117 | Renter occupied AND household income is less than or equal to 30% of HAMFI AND household type is small family (2 persons, neither person 62 years or over, or 3 or 4 persons) AND housing cost burden is greater than 50% |
| T7_EST143 | Renter occupied AND household income is greater than 30% but less than or equal to 50% of HAMFI AND household type is small family (2 persons, neither person 62 years or over, or 3 or 4 persons) AND housing cost burden is greater than 50% |
| T7_EST169 | Renter occupied AND household income is greater than 50% but less than or equal to 80% of HAMFI AND household type is small family (2 persons, neither person 62 years or over, or 3 or 4 persons) AND housing cost burden is greater than 50% |
| T7_SF_CB50 | Renter occupied AND household type is small family (2 persons, neither person 62 years or over, or 3 or 4 persons) AND housing cost burden is greater than 50% |
| T7_EST12 | Owner occupied AND household income is less than or equal to 30% of HAMFI AND household type is small family (2 persons, neither person 62 years or over, or 3 or 4 persons) AND housing cost burden is greater than 50% |
| T7_EST38 | Owner occupied AND household income is greater than 30% but less than or equal to 50% of HAMFI AND household type is small family (2 persons, neither person 62 years or over, or 3 or 4 persons) AND housing cost burden is greater than 50% |
| T7_EST64 | Owner occupied AND household income is greater than 50% but less than or equal to 80% of HAMFI AND household type is small family (2 persons, neither person 62 years or over, or 3 or 4 persons) AND housing cost burden is greater than 50% |
| T7_SF_CB_1 | Owner occupied AND household type is small family (2 persons, neither person 62 years or over, or 3 or 4 persons) AND housing cost burden is greater than 50% |
| T7_EST122 | Renter occupied AND household income is less than or equal to 30% of HAMFI AND household type is large family (5 or more persons) AND housing cost burden is greater than 50% |
| T7_EST148 | Renter occupied AND household income is greater than 30% but less than or equal to 50% of HAMFI AND household type is large family (5 or more persons) AND housing cost burden is greater than 50% |
| T7_EST174 | Renter occupied AND household income is greater than 50% but less than or equal to 80% of HAMFI AND household type is large family (5 or more persons) AND housing cost burden is greater than 50% |
| T7_LF_CB50 | Renter occupied AND household type is large family (5 or more persons) AND housing cost burden is greater than 50% |
| T7_EST17 | Owner occupied AND household income is less than or equal to 30% of HAMFI AND household type is large family (5 or more persons) AND housing cost burden is greater than 50% |
| T7_EST43 | Owner occupied AND household income is greater than 30% but less than or equal to 50% of HAMFI AND household type is large family (5 or more persons) AND housing cost burden is greater than 50% |
| T7_EST69 | Owner occupied AND household income is greater than 50% but less than or equal to 80% of HAMFI AND household type is large family (5 or more persons) AND housing cost burden is greater than 50% |
| T7_LF_CB_1 | Owner occupied AND household type is large family (5 or more persons) AND housing cost burden is greater than 50% |
| T7_LE30__5 | Renter occupied AND household income is less than or equal to 30% of HAMFI AND household type is elderly (elderly non-family household or family household with 2 people, at least one of which is elderly) AND housing cost burden is greater than 50% |
| T7_GT30__8 | Renter occupied AND household income is greater than 30% but less than or equal to 50% of HAMFI AND household type is elderly (elderly non-family household or family household with 2 people, at least one of which is elderly) AND housing cost burden is greater than 50% |
| T7_GT50__8 | Renter occupied AND household income is greater than 50% but less than or equal to 80% of HAMFI AND household type is elderly (elderly non-family household or family household with 2 people, at least one of which is elderly) AND housing cost burden is greater than 50% |
| T7_ELD_CB5 | Renter occupied AND household type is elderly (elderly non-family household or family household with 2 people, at least one of which is elderly) AND housing cost burden is greater than 50% |
| T7_LE30__6 | Owner occupied AND household income is less than or equal to 30% of HAMFI AND household type is elderly (elderly non-family household or family household with 2 people, at least one of which is elderly) AND housing cost burden is greater than 50% |
| T7_GT30__9 | Owner occupied AND household income is greater than 30% but less than or equal to 50% of HAMFI AND household type is elderly (elderly non-family household or family household with 2 people, at least one of which is elderly) AND housing cost burden is greater than 50% |
| T7_GT50__9 | Owner occupied AND household income is greater than 50% but less than or equal to 80% of HAMFI AND household type is elderly (elderly non-family household or family household with 2 people, at least one of which is elderly) AND housing cost burden is greater than 50% |
| T7_ELD_C_2 | Owner occupied AND household type is elderly (elderly non-family household or family household with 2 people, at least one of which is elderly) AND housing cost burden is greater than 50% |
| T7_EST132 | Renter occupied AND household income is less than or equal to 30% of HAMFI AND other household type (non-elderly non-family) AND housing cost burden is greater than 50% |
| T7_EST158 | Renter occupied AND household income is greater than 30% but less than or equal to 50% of HAMFI AND other household type (non-elderly non-family) AND housing cost burden is greater than 50% |
| T7_EST184 | Renter occupied AND household income is greater than 50% but less than or equal to 80% of HAMFI AND other household type (non-elderly non-family) AND housing cost burden is greater than 50% |
| T7_OTHER_2 | Renter occupied AND other household type (non-elderly non-family) AND housing cost burden is greater than 50% |
| T7_EST27 | Owner occupied AND household income is less than or equal to 30% of HAMFI AND other household type (non-elderly non-family) AND housing cost burden is greater than 50% |
| T7_EST53 | Owner occupied AND household income is greater than 30% but less than or equal to 50% of HAMFI AND other household type (non-elderly non-family) AND housing cost burden is greater than 50% |
| T7_EST79 | Owner occupied AND household income is greater than 50% but less than or equal to 80% of HAMFI AND other household type (non-elderly non-family) AND housing cost burden is greater than 50% |
| T7_OTHER_3 | Owner occupied AND other household type (non-elderly non-family) AND housing cost burden is greater than 50% |
| T10_OC_LE3 | Renter occupied AND persons per room is greater than 1 AND household income is less than or equal to 30% of HAMFI AND household type is one family with no subfamilies |
| T10_OC_GT3 | Renter occupied AND persons per room is greater than 1 AND household income is greater than 30% but less than or equal to 50% of HAMFI AND household type is one family with no subfamilies |
| T10_OC_GT5 | Renter occupied AND persons per room is greater than 1 AND household income is greater than 50% but less than or equal to 80% of HAMFI AND household type is one family with no subfamilies |
| T10_OC_GT8 | Renter occupied AND persons per room is greater than 1 AND household income is greater than 80% but less than or equal to 100% of HAMFI AND household type is one family with no subfamilies |
| T10_OC_HHT | Renter occupied AND persons per room is greater than 1 AND household type is one family with no subfamilies |
| T10_OC_L_1 | Owner occupied AND persons per room is greater than 1 AND household income is less than or equal to 30% of HAMFI AND household type is one family with no subfamilies |
| T10_OC_G_1 | Owner occupied AND persons per room is greater than 1 AND household income is greater than 30% but less than or equal to 50% of HAMFI AND household type is one family with no subfamilies |
| T10_OC_G_2 | Owner occupied AND persons per room is greater than 1 AND household income is greater than 50% but less than or equal to 80% of HAMFI AND household type is one family with no subfamilies |
| T10_OC_G_3 | Owner occupied AND persons per room is greater than 1 AND household income is greater than 80% but less than or equal to 100% of HAMFI AND household type is one family with no subfamilies |
| T10_OC_H_1 | Owner occupied AND persons per room is greater than 1 AND household type is one family with no subfamilies |
| T10_OC_L_2 | Renter occupied AND persons per room is greater than 1 AND household income is less than or equal to 30% of HAMFI AND household type is one family with at least one subfamily or more than one family |
| T10_OC_G_4 | Renter occupied AND persons per room is greater than 1 AND household income is greater than 30% but less than or equal to 50% of HAMFI AND household type is one family with at least one subfamily or more than one family |
| T10_OC_G_5 | Renter occupied AND persons per room is greater than 1 AND household income is greater than 50% but less than or equal to 80% of HAMFI AND household type is one family with at least one subfamily or more than one family |
| T10_OC_G_6 | Renter occupied AND persons per room is greater than 1 AND household income is greater than 80% but less than or equal to 100% of HAMFI AND household type is one family with at least one subfamily or more than one family |
| T10_OC_H_2 | Renter occupied AND persons per room is greater than 1 AND household type is one family with at least one subfamily or more than one family |
| T10_OC_L_3 | Owner occupied AND persons per room is greater than 1 AND household income is less than or equal to 30% of HAMFI AND household type is one family with at least one subfamily or more than one family |
| T10_OC_G_7 | Owner occupied AND persons per room is greater than 1 AND household income is greater than 30% but less than or equal to 50% of HAMFI AND household type is one family with at least one subfamily or more than one family |
| T10_OC_G_8 | Owner occupied AND persons per room is greater than 1 AND household income is greater than 50% but less than or equal to 80% of HAMFI AND household type is one family with at least one subfamily or more than one family |
| T10_OC_G_9 | Owner occupied AND persons per room is greater than 1 AND household income is greater than 80% but less than or equal to 100% of HAMFI AND household type is one family with at least one subfamily or more than one family |
| T10_OC_H_3 | Owner occupied AND persons per room is greater than 1 AND household type is one family with at least one subfamily or more than one family |
| T10_OC_L_4 | Renter occupied AND persons per room is greater than 1 AND household income is less than or equal to 30% of HAMFI AND household type is non-family |
| T10_OC_G10 | Renter occupied AND persons per room is greater than 1 AND household income is greater than 30% but less than or equal to 50% of HAMFI AND household type is non-family |
| T10_OC_G11 | Renter occupied AND persons per room is greater than 1 AND household income is greater than 50% but less than or equal to 80% of HAMFI AND household type is non-family |
| T10_OC_G12 | Renter occupied AND persons per room is greater than 1 AND household income is greater than 80% but less than or equal to 100% of HAMFI AND household type is non-family |
| T10_OC_H_4 | Renter occupied AND persons per room is greater than 1 AND household type is non-family |
| T10_OC_L_5 | Owner occupied AND persons per room is greater than 1 AND household income is less than or equal to 30% of HAMFI AND household type is non-family |
| T10_OC_G13 | Owner occupied AND persons per room is greater than 1 AND household income is greater than 30% but less than or equal to 50% of HAMFI AND household type is non-family |
| T10_OC_G14 | Owner occupied AND persons per room is greater than 1 AND household income is greater than 50% but less than or equal to 80% of HAMFI AND household type is non-family |
| T10_OC_G15 | Owner occupied AND persons per room is greater than 1 AND household income is greater than 80% but less than or equal to 100% of HAMFI AND household type is non-family |
| T10_OC_H_5 | Owner occupied AND persons per room is greater than 1 AND household type is non-family |
| T8_LE30 | Household income is less than or equal to 30% of HAMFI |
| T1_LE30_HP | Household income is less than or equal to 30% of HAMFI AND has 1 or more of the 4 housing unit problems |
| T2_LE30_HP | Household income is less than or equal to 30% of HAMFI AND has 1 or more of the 4 severe housing unit problems |
| T3_LE30_SU | Household income is less than or equal to 30% of HAMFI AND lacking complete plumbing or kitchen facilities |
| T10_LE30_O | Household income is less than or equal to 30% of HAMFI AND persons per room is greater than 1 |
| T8_LE30_CB | Household income is less than or equal to 30% of HAMFI AND housing cost burden is greater than 30% |
| T8_LE30__1 | Household income is less than or equal to 30% of HAMFI AND housing cost burden is greater than 50% |
| T8_LE50 | Household income is less than or equal to 50% of HAMFI |
| T1_LE50_HP | Household income is less than or equal to 50% of HAMFI AND has 1 or more of the 4 housing unit problems |
| T2_LE50_HP | Household income is less than or equal to 50% of HAMFI AND has 1 or more of the 4 severe housing unit problems |
| T3_LE50_SU | Household income is less than or equal to 50% of HAMFI AND lacking complete plumbing or kitchen facilities |
| T10_LE50_O | Household income is less than or equal to 50% of HAMFI AND persons per room is greater than 1 |
| T8_LE50_CB | Household income is less than or equal to 50% of HAMFI AND housing cost burden is greater than 30% |
| T8_LE50__1 | Household income is less than or equal to 50% of HAMFI AND housing cost burden is greater than 50% |
| T8_LE80 | Household income is less than or equal to 80% of HAMFI |
| T1_LE80_HP | Household income is less than or equal to 80% of HAMFI AND has 1 or more of the 4 housing unit problems |
| T2_LE80_HP | Household income is less than or equal to 80% of HAMFI AND has 1 or more of the 4 severe housing unit problems |
| T3_LE80_SU | Household income is less than or equal to 80% of HAMFI AND lacking complete plumbing or kitchen facilities |
| T10_LE80_O | Household income is less than or equal to 80% of HAMFI AND persons per room is greater than 1 |
| T8_LE80_CB | Household income is less than or equal to 80% of HAMFI AND housing cost burden is greater than 30% |
| T8_LE80__1 | Household income is less than or equal to 80% of HAMFI AND housing cost burden is greater than 50% |
| T1_LE30__1 | Percent of extremely low income households (household income less than or equal to 30% HAMFI) with any of the 4 housing problems |
| T2_LE30__1 | Percent of extremely low income households (household income less than or equal to 30% HAMFI) with any of the 4 severe housing problems |
| T3_LE30__1 | Percent of extremely low income households (household income less than or equal to 30% HAMFI) without complete kitchen and plumbing |
| T10_LE30_1 | Percent of extremely low income households (household income less than or equal to 30% HAMFI) with more than one person per room |
| T8_LE30__2 | Percent of extremely low income households (household income less than or equal to 30% HAMFI) with cost burden over 30% |
| T8_LE30__3 | Percent of extremely low income households (household income less than or equal to 30% HAMFI) with cost burden over 50% |
| T1_LE50__1 | Percent of low income households (household income less than or equal to 50% HAMFI) with any of the 4 housing problems |
| T2_LE50__1 | Percent of low income households (household income less than or equal to 50% HAMFI) with any of the 4 severe housing problems |
| T3_LE50__1 | Percent of low income households (household income less than or equal to 50% HAMFI) without complete kitchen and plumbing |
| T10_LE50_1 | Percent of low income households (household income less than or equal to 50% HAMFI) with more than one person per room |
| T8_LE50__2 | Percent of low income households (household income less than or equal to 50% HAMFI) with cost burden over 30% |
| T8_LE50__3 | Percent of low income households (household income less than or equal to 50% HAMFI) with cost burden over 50% |
| T1_LE80__1 | Percent of low and moderate income households (household income less than or equal to 80% HAMFI) with any of the 4 housing problems |
| T2_LE80__1 | Percent of low and moderate income households (household income less than or equal to 80% HAMFI) with any of the 4 severe housing problems |
| T3_LE80__1 | Percent of low and moderate income households (household income less than or equal to 80% HAMFI) without complete kitchen and plumbing |
| T10_LE80_1 | Percent of low and moderate income households (household income less than or equal to 80% HAMFI) with more than one person per room |
| T8_LE80__2 | Percent of low and moderate income households (household income less than or equal to 80% HAMFI) with cost burden over 30% |
| T8_LE80__3 | Percent of low and moderate income households (household income less than or equal to 80% HAMFI) with cost burden over 50% |
| T7_SF_LE30 | Household income is less than or equal to 30% of HAMFI AND household type is small family (2 persons, neither person 62 years or over, or 3 or 4 persons) |
| T7_LF_LE30 | Household income is less than or equal to 30% of HAMFI AND household type is large family (5 or more persons) |
| T7_SF_GT30 | Household income is greater than 30% but less than or equal to 50% of HAMFI AND household type is small family (2 persons, neither person 62 years or over, or 3 or 4 persons) |
| T7_LF_GT30 | Household income is greater than 30% but less than or equal to 50% of HAMFI AND household type is large family (5 or more persons) |
| T7_SF_GT50 | Household income is greater than 50% but less than or equal to 80% of HAMFI AND household type is small family (2 persons, neither person 62 years or over, or 3 or 4 persons) |
| T7_LF_GT50 | Household income is greater than 50% but less than or equal to 80% of HAMFI AND household type is large family (5 or more persons) |
| T7_SF_GT80 | Household income is greater than 80% but less than or equal to 100% of HAMFI AND household type is small family (2 persons, neither person 62 years or over, or 3 or 4 persons) |
| T7_LF_GT80 | Household income is greater than 80% but less than or equal to 100% of HAMFI AND household type is large family (5 or more persons) |
| T7_SF_GT10 | Household income is greater than 100% of HAMFI AND household type is small family (2 persons, neither person 62 years or over, or 3 or 4 persons) |
| T7_LF_GT10 | Household income is greater than 100% of HAMFI AND household type is large family (5 or more persons) |
| T13_LE30_C | Household income is less than or equal to 30% of HAMFI AND household contains 1 or more children age 6 or younger |
| T13_GT30_L | Household income is greater than 30% but less than or equal to 50% of HAMFI AND household contains 1 or more children age 6 or younger |
| T13_GT50_L | Household income is greater than 50% but less than or equal to 80% of HAMFI AND household contains 1 or more children age 6 or younger |
| T13_GT80_L | Household income is greater than 80% but less than or equal to 100% of HAMFI AND household contains 1 or more children age 6 or younger |
| T13_GT100_ | Household income is greater than 100% of HAMFI AND household contains 1 or more children age 6 or younger |
| T5_LE30_EL | Household income is less than or equal to 30% of HAMFI AND household contains at least 1 person age 62-74 but no one age 75+ |
| T5_GT30_LE | Household income is greater than 30% but less than or equal to 50% of HAMFI AND household contains at least 1 person age 62-74 but no one age 75+ |
| T5_GT50_LE | Household income is greater than 50% but less than or equal to 80% of HAMFI AND household contains at least 1 person age 62-74 but no one age 75+ |
| T5_GT80_LE | Household income is greater than 80% but less than or equal to 100% of HAMFI AND household contains at least 1 person age 62-74 but no one age 75+ |
| T5_GT100_E | Household income is greater than 100% of HAMFI AND household contains at least 1 person age 62-74 but no one age 75+ |
| T5_LE30_XE | Household income is less than or equal to 30% of HAMFI AND household contains at least 1 person age 75+ |
| T5_GT30__1 | Household income is greater than 30% but less than or equal to 50% of HAMFI AND household contains at least 1 person age 75+ |
| T5_GT50__1 | Household income is greater than 50% but less than or equal to 80% of HAMFI AND household contains at least 1 person age 75+ |
| T5_GT80__1 | Household income is greater than 80% but less than or equal to 100% of HAMFI AND household contains at least 1 person age 75+ |
| T5_GT100_X | Household income is greater than 100% of HAMFI AND household contains at least 1 person age 75+ |
| T1_HP | Has one of the 4 housing unit problems |
| T2_HP2 | Has one of the 4 severe housing unit problems |
| T3_SUBST | Lacks complete plumbing or kitchen facilities |
| T8_CB50 | Housing cost burden greater than 50% |
| T8_CB | Housing cost burden greater than 30% |
| T8_EST23 | Owner occupied AND household income is greater than 30% but less than or equal to 50% of HAMFI AND housing cost burden is greater than 50% |
| T8_EST89 | Renter occupied AND household income is greater than 30% but less than or equal to 50% of HAMFI AND housing cost burden is greater than 50% |
| T8_GT30_LE | Household income is greater than 30% but less than or equal to 50% of HAMFI AND housing cost burden is greater than 50% |
| T8_EST36 | Owner occupied AND household income is greater than 50% but less than or equal to 80% of HAMFI AND housing cost burden is greater than 50% |
| T8_EST102 | Renter occupied AND household income is greater than 50% but less than or equal to 80% of HAMFI AND housing cost burden is greater than 50% |
| T8_GT50_LE | Household income is greater than 50% but less than or equal to 80% of HAMFI AND housing cost burden is greater than 50% |
| T8_EST49 | Owner occupied AND household income is greater than 80% but less than or equal to 100% of HAMFI AND housing cost burden is greater than 50% |
| T8_EST115 | Renter occupied AND household income is greater than 80% but less than or equal to 100% of HAMFI AND housing cost burden is greater than 50% |
| T8_GT80_LE | Household income is greater than 80% but less than or equal to 100% of HAMFI AND housing cost burden is greater than 50% |
| T8_GT30__1 | Owner occupied AND household income is greater than 30% but less than or equal to 50% of HAMFI AND housing cost burden is greater than 30% |
| T8_GT30__2 | Renter occupied AND household income is greater than 30% but less than or equal to 50% of HAMFI AND housing cost burden is greater than 30% |
| T8_GT30__3 | Household income is greater than 30% but less than or equal to 50% of HAMFI AND housing cost burden is greater than 30% |
| T8_GT50__1 | Owner occupied AND household income is greater than 50% but less than or equal to 80% of HAMFI AND housing cost burden is greater than 30% |
| T8_GT50__2 | Renter occupied AND household income is greater than 50% but less than or equal to 80% of HAMFI AND housing cost burden is greater than 30% |
| T8_GT50__3 | Household income is greater than 50% but less than or equal to 80% of HAMFI AND housing cost burden is greater than 30% |
| T8_GT80__1 | Owner occupied AND household income is greater than 80% but less than or equal to 100% of HAMFI AND housing cost burden is greater than 30% |
| T8_GT80__2 | Renter occupied AND household income is greater than 80% but less than or equal to 100% of HAMFI AND housing cost burden is greater than 30% |
| T8_GT80__3 | Household income is greater than 80% but less than or equal to 100% of HAMFI AND housing cost burden is greater than 30% |
| T10_GT30_L | Owner occupied AND persons per room is greater than 1 AND household income is greater than 30% but less than or equal to 50% of HAMFI |
| T10_GT30_1 | Renter occupied AND persons per room is greater than 1 AND household income is greater than 30% but less than or equal to 50% of HAMFI |
| T10_GT30_2 | Persons per room is greater than 1 AND household income is greater than 30% but less than or equal to 50% of HAMFI |
| T10_GT50_L | Owner occupied AND persons per room is greater than 1 AND household income is greater than 50% but less than or equal to 80% of HAMFI |
| T10_GT50_1 | Renter occupied AND persons per room is greater than 1 AND household income is greater than 50% but less than or equal to 80% of HAMFI |
| T10_GT50_2 | Persons per room is greater than 1 AND household income is greater than 50% but less than or equal to 80% of HAMFI |
| T10_GT80_L | Owner occupied AND persons per room is greater than 1 AND household income is greater than 80% but less than or equal to 100% of HAMFI |
| T10_GT80_1 | Renter occupied AND persons per room is greater than 1 AND household income is greater than 80% but less than or equal to 100% of HAMFI |
| T10_GT80_2 | Persons per room is greater than 1 AND household income is greater than 80% but less than or equal to 100% of HAMFI |
| T8_GT30__4 | Household income is greater than 30% but less than or equal to 50% of HAMFI |
| T8_GT50__4 | Household income is greater than 50% but less than or equal to 80% of HAMFI |
| T8_GT80__4 | Household income is greater than 80% but less than or equal to 100% of HAMFI |
| T8_GT100 | Household income is greater than 100% of HAMFI |
| T8_LE100 | Household income is less than or equal to 100% of HAMFI |
| T13_LBP1 | Structure built in 1979 or earlier AND household contains 1 or more children age 6 or younger |
| T13_LBP2 | Owner occupiedStructure built in 1979 or earlier AND household contains 1 or more children age 6 or younger |
| T13_LBP3 | Renter occupiedStructure built in 1979 or earlier AND household contains 1 or more children age 6 or younger |
| T10_HOMELE | Renter occupied AND persons per room is greater than 1 AND household income is less than or equal to 50% of HAMFI AND household type at risk of homelessness (non-family household or family household with at least one subfamily) |
| T8_LE30_PC | Percent of all households with household income less than or equal to 30% of HAMFI (extremely low income) |
| T8_LE50_PC | Percent of all households with household income less than or equal to 50% of HAMFI (low income) |
| T8_LE80_PC | Percent of all households with household income less than or equal to 80% of HAMFI (moderate income) |
| T8_LE100_P | Percent of all households with household income less than or equal to 100% of HAMFI |
| T3_SUBST_P | Percent of all households without complete kitchen and plumbing |
| T1_HP_PCT | Percent of all households with any of the 4 housing problems |
| T2_HP2_PCT | Percent of all households with any of the 4 severe housing problems |
| T8_CB50_PC | Percent of all households with cost burden over 50% |
| T8_CB_PCT | Percent of all households with cost burden over 30% |
| AFF_AVAIL_ | Renter occupied OR vacant for rent AND gross rent would be affordable to a household with income equal to 30% of HAMFI AND unit is vacant (available) or occupied by a household with income less than or equal to 30% of HAMFI. |
| AFF_AVAI_1 | Renter occupied OR vacant for rent AND gross rent would be affordable to a household with income equal to 50% of HAMFI AND unit is vacant (available) or occupied by a household with income less than or equal to 50% of HAMFI. |
| AFF_AVAI_2 | Renter occupied OR vacant for rent AND gross rent would be affordable to a household with income equal to 80% of HAMFI AND unit is vacant (available) or occupied by a household with income less than or equal to 80% of HAMFI. |
| AFF_AVAI_3 | Owner occupied OR vacant for sale AND home value would be affordable to a household with income equal to 50% of HAMFI AND unit is vacant (available) or occupied by a household with income less than or equal to 50% of HAMFI. |
| AFF_AVAI_4 | Owner occupied OR vacant for sale AND home value would be affordable to a household with income equal to 80% of HAMFI AND unit is vacant (available) or occupied by a household with income less than or equal to 80% of HAMFI. |
| AFF_AVAI_5 | Owner occupied OR vacant for sale AND home value would be affordable to a household with income equal to 100% of HAMFI AND unit is vacant (available) or occupied by a household with income less than or equal to 100% of HAMFI. |
| RENT_DENOM | Renter occupied OR vacant for rent |
| OWN_DENOM | Owner occupied OR vacant for sale |
| AFF_AVAI_6 | AFF_AVAIL_30_R as a percentage of all renter occupied or vacant-for-rent units |
| AFF_AVAI_7 | AFF_AVAIL_50_R as a percentage of all renter occupied or vacant-for-rent units |
| AFF_AVAI_8 | AFF_AVAIL_80_R as a percentage of all renter occupied or vacant-for-rent units |
| AFF_AVAI_9 | AFF_AVAIL_50_O as a percentage of all owner occupied or vacant-for-sale units |
| AFF_AVAI10 | AFF_AVAIL_80_O as a percentage of all owner occupied or vacant-for-sale units |
| AFF_AVAI11 | AFF_AVAIL_100_O as a percentage of all owner occupied or vacant-for-sale units |
| T7_GT80_LE | Renter occupied AND household income is greater than 80% but less than or equal to 100% of HAMFI AND household type is small family (2 persons, neither person 62 years or over, or 3 or 4 persons) AND housing cost burden is greater than 30% |
| T7_GT100_S | Renter occupied AND household income is greater than 100% of HAMFI AND household type is small family (2 persons, neither person 62 years or over, or 3 or 4 persons) AND housing cost burden is greater than 30% |
| T7_GT80__1 | Owner occupied AND household income is greater than 80% but less than or equal to 100% of HAMFI AND household type is small family (2 persons, neither person 62 years or over, or 3 or 4 persons) AND housing cost burden is greater than 30% |
| T7_GT100_1 | Owner occupied AND household income is greater than 100% of HAMFI AND household type is small family (2 persons, neither person 62 years or over, or 3 or 4 persons) AND housing cost burden is greater than 30% |
| T7_GT80__2 | Renter occupied AND household income is greater than 80% but less than or equal to 100% of HAMFI AND household type is large family (5 or more persons) AND housing cost burden is greater than 30% |
| T7_GT100_L | Renter occupied AND household income is greater than 100% of HAMFI AND household type is large family (5 or more persons) AND housing cost burden is greater than 30% |
| T7_GT80__3 | Owner occupied AND household income is greater than 80% but less than or equal to 100% of HAMFI AND household type is large family (5 or more persons) AND housing cost burden is greater than 30% |
| T7_GT100_2 | Owner occupied AND household income is greater than 100% of HAMFI AND household type is large family (5 or more persons) AND housing cost burden is greater than 30% |
| T7_GT80__4 | Renter occupied AND household income is greater than 80% but less than or equal to 100% of HAMFI AND household type is elderly (elderly non-family household or family household with 2 people, at least one of which is elderly) AND housing cost burden is greater than 30% |
| T7_GT100_E | Renter occupied AND household income is greater than 100% of HAMFI AND household type is elderly (elderly non-family household or family household with 2 people, at least one of which is elderly) AND housing cost burden is greater than 30% |
| T7_GT80__5 | Owner occupied AND household income is greater than 80% but less than or equal to 100% of HAMFI AND household type is elderly (elderly non-family household or family household with 2 people, at least one of which is elderly) AND housing cost burden is greater than 30% |
| T7_GT100_3 | Owner occupied AND household income is greater than 100% of HAMFI AND household type is elderly (elderly non-family household or family household with 2 people, at least one of which is elderly) AND housing cost burden is greater than 30% |
| T7_GT80__6 | Renter occupied AND household income is greater than 80% but less than or equal to 100% of HAMFI AND other household type (non-elderly non-family) AND housing cost burden is greater than 30% |
| T7_GT100_O | Renter occupied AND household income is greater than 100% of HAMFI AND other household type (non-elderly non-family) AND housing cost burden is greater than 30% |
| T7_GT80__7 | Owner occupied AND household income is greater than 80% but less than or equal to 100% of HAMFI AND other household type (non-elderly non-family) AND housing cost burden is greater than 30% |
| T7_GT100_4 | Owner occupied AND household income is greater than 100% of HAMFI AND other household type (non-elderly non-family) AND housing cost burden is greater than 30% |
| T7_GT80__8 | Renter occupied AND household income is greater than 80% but less than or equal to 100% of HAMFI AND household type is elderly (elderly non-family household or family household with 2 people, at least one of which is elderly) AND housing cost burden is greater than 50% |
| T7_GT100_5 | Renter occupied AND household income is greater than 100% of HAMFI AND household type is elderly (elderly non-family household or family household with 2 people, at least one of which is elderly) AND housing cost burden is greater than 50% |
| T7_GT80__9 | Owner occupied AND household income is greater than 80% but less than or equal to 100% of HAMFI AND household type is elderly (elderly non-family household or family household with 2 people, at least one of which is elderly) AND housing cost burden is greater than 50% |
| T7_GT100_6 | Owner occupied AND household income is greater than 100% of HAMFI AND household type is elderly (elderly non-family household or family household with 2 people, at least one of which is elderly) AND housing cost burden is greater than 50% |
| T7_EST221 | Renter occupied AND household income is greater than 80% but less than or equal to 100% of HAMFI AND household type is small family (2 persons, neither person 62 years or over, or 3 or 4 persons) AND housing cost burden is greater than 50% |
| T7_EST247 | Renter occupied AND household income is greater than 100% of HAMFI AND household type is small family (2 persons, neither person 62 years or over, or 3 or 4 persons) AND housing cost burden is greater than 50% |
| T7_EST90 | Owner occupied AND household income is greater than 80% but less than or equal to 100% of HAMFI AND household type is small family (2 persons, neither person 62 years or over, or 3 or 4 persons) AND housing cost burden is greater than 50% |
| T7_EST116 | Owner occupied AND household income is greater than 100% of HAMFI AND household type is small family (2 persons, neither person 62 years or over, or 3 or 4 persons) AND housing cost burden is greater than 50% |
| T7_EST226 | Renter occupied AND household income is greater than 80% but less than or equal to 100% of HAMFI AND household type is large family (5 or more persons) AND housing cost burden is greater than 50% |
| T7_EST252 | Renter occupied AND household income is greater than 100% of HAMFI AND household type is large family (5 or more persons) AND housing cost burden is greater than 50% |
| T7_EST95 | Owner occupied AND household income is greater than 80% but less than or equal to 100% of HAMFI AND household type is large family (5 or more persons) AND housing cost burden is greater than 50% |
| T7_EST121 | Owner occupied AND household income is greater than 100% of HAMFI AND household type is large family (5 or more persons) AND housing cost burden is greater than 50% |
| T7_EST236 | Renter occupied AND household income is greater than 80% but less than or equal to 100% of HAMFI AND other household type (non-elderly non-family) AND housing cost burden is greater than 50% |
| T7_EST262 | Renter occupied AND household income is greater than 100% of HAMFI AND other household type (non-elderly non-family) AND housing cost burden is greater than 50% |
| T7_EST105 | Owner occupied AND household income is greater than 80% but less than or equal to 100% of HAMFI AND other household type (non-elderly non-family) AND housing cost burden is greater than 50% |
| T7_EST131 | Owner occupied AND household income is greater than 100% of HAMFI AND other household type (non-elderly non-family) AND housing cost burden is greater than 50% |
| T8_LE30__4 | Owner occupied AND household income is less than or equal to 30% of HAMFI AND housing cost burden is greater than 30% |
| T8_LE30__5 | Renter occupied AND household income is less than or equal to 30% of HAMFI AND housing cost burden is greater than 30% |
| T13_LE30_1 | Renter occupiedHousehold income is less than or equal to 30% of HAMFI AND household contains 1 or more children age 6 or younger |
| T13_GT30_1 | Renter occupiedHousehold income is greater than 30% but less than or equal to 50% of HAMFI AND household contains 1 or more children age 6 or younger |
| T13_GT50_1 | Renter occupiedHousehold income is greater than 50% but less than or equal to 80% of HAMFI AND household contains 1 or more children age 6 or younger |
| T13_GT80_1 | Renter occupiedHousehold income is greater than 80% but less than or equal to 100% of HAMFI AND household contains 1 or more children age 6 or younger |
| T13_GT10_1 | Renter occupiedHousehold income is greater than 100% of HAMFI AND household contains 1 or more children age 6 or younger |
| T13_CHL_R | Renter occupied AND household contains 1 or more children age 6 or younger |
| T13_LE30_2 | Owner occupiedHousehold income is less than or equal to 30% of HAMFI AND household contains 1 or more children age 6 or younger |
| T13_GT30_2 | Owner occupiedHousehold income is greater than 30% but less than or equal to 50% of HAMFI AND household contains 1 or more children age 6 or younger |
| T13_GT50_2 | Owner occupiedHousehold income is greater than 50% but less than or equal to 80% of HAMFI AND household contains 1 or more children age 6 or younger |
| T13_GT80_2 | Owner occupiedHousehold income is greater than 80% but less than or equal to 100% of HAMFI AND household contains 1 or more children age 6 or younger |
| T13_GT10_2 | Owner occupiedHousehold income is greater than 100% of HAMFI AND household contains 1 or more children age 6 or younger |
| T13_CHL_O | Owner occupied AND household contains 1 or more children age 6 or younger |
| T5_LE30__1 | Renter occupied AND household income is less than or equal to 30% of HAMFI AND household contains at least 1 person age 62-74 but no one age 75+ |
| T5_GT30__2 | Renter occupied AND household income is greater than 30% but less than or equal to 50% of HAMFI AND household contains at least 1 person age 62-74 but no one age 75+ |
| T5_GT50__2 | Renter occupied AND household income is greater than 50% but less than or equal to 80% of HAMFI AND household contains at least 1 person age 62-74 but no one age 75+ |
| T5_GT80__2 | Renter occupied AND household income is greater than 80% but less than or equal to 100% of HAMFI AND household contains at least 1 person age 62-74 but no one age 75+ |
| T5_GT100_1 | Renter occupied AND household income is greater than 100% of HAMFI AND household contains at least 1 person age 62-74 but no one age 75+ |
| T5_LE30__2 | Renter occupied AND household income is less than or equal to 30% of HAMFI AND household contains at least 1 person age 75+ |
| T5_GT30__3 | Renter occupied AND household income is greater than 30% but less than or equal to 50% of HAMFI AND household contains at least 1 person age 75+ |
| T5_GT50__3 | Renter occupied AND household income is greater than 50% but less than or equal to 80% of HAMFI AND household contains at least 1 person age 75+ |
| T5_GT80__3 | Renter occupied AND household income is greater than 80% but less than or equal to 100% of HAMFI AND household contains at least 1 person age 75+ |
| T5_GT100_2 | Renter occupied AND household income is greater than 100% of HAMFI AND household contains at least 1 person age 75+ |
| T5_LE30__3 | Owner occupied AND household income is less than or equal to 30% of HAMFI AND household contains at least 1 person age 62-74 but no one age 75+ |
| T5_GT30__4 | Owner occupied AND household income is greater than 30% but less than or equal to 50% of HAMFI AND household contains at least 1 person age 62-74 but no one age 75+ |
| T5_GT50__4 | Owner occupied AND household income is greater than 50% but less than or equal to 80% of HAMFI AND household contains at least 1 person age 62-74 but no one age 75+ |
| T5_GT80__4 | Owner occupied AND household income is greater than 80% but less than or equal to 100% of HAMFI AND household contains at least 1 person age 62-74 but no one age 75+ |
| T5_GT100_3 | Owner occupied AND household income is greater than 100% of HAMFI AND household contains at least 1 person age 62-74 but no one age 75+ |
| T5_LE30__4 | Owner occupied AND household income is less than or equal to 30% of HAMFI AND household contains at least 1 person age 75+ |
| T5_GT30__5 | Owner occupied AND household income is greater than 30% but less than or equal to 50% of HAMFI AND household contains at least 1 person age 75+ |
| T5_GT50__5 | Owner occupied AND household income is greater than 50% but less than or equal to 80% of HAMFI AND household contains at least 1 person age 75+ |
| T5_GT80__5 | Owner occupied AND household income is greater than 80% but less than or equal to 100% of HAMFI AND household contains at least 1 person age 75+ |
| T5_GT100_4 | Owner occupied AND household income is greater than 100% of HAMFI AND household contains at least 1 person age 75+ |
| SF_ELI_CB5 | Renter occupied AND household income is less than or equal to 30% of HAMFI AND household type is small family (2 persons, neither person 62 years or over, or 3 or 4 persons) AND housing cost burden is greater than 50% |
| SF_LI_CB50 | Renter occupied AND household income is greater than 30% but less than or equal to 50% of HAMFI AND household type is small family (2 persons, neither person 62 years or over, or 3 or 4 persons) AND housing cost burden is greater than 50% |
| SF_MI_CB50 | Renter occupied AND household income is greater than 50% but less than or equal to 80% of HAMFI AND household type is small family (2 persons, neither person 62 years or over, or 3 or 4 persons) AND housing cost burden is greater than 50% |
| LF_ELI_CB5 | Renter occupied AND household income is less than or equal to 30% of HAMFI AND household type is large family (5 or more persons) AND housing cost burden is greater than 50% |
| LF_LI_CB50 | Renter occupied AND household income is greater than 30% but less than or equal to 50% of HAMFI AND household type is large family (5 or more persons) AND housing cost burden is greater than 50% |
| LF_MI_CB50 | Renter occupied AND household income is greater than 50% but less than or equal to 80% of HAMFI AND household type is large family (5 or more persons) AND housing cost burden is greater than 50% |
| SF_ELI_C_1 | Owner occupied AND household income is less than or equal to 30% of HAMFI AND household type is large family (5 or more persons) AND housing cost burden is greater than 50% |
| SF_LI_CB_1 | Owner occupied AND household income is greater than 30% but less than or equal to 50% of HAMFI AND household type is large family (5 or more persons) AND housing cost burden is greater than 50% |
| SF_MI_CB_1 | Owner occupied AND household income is greater than 50% but less than or equal to 80% of HAMFI AND household type is large family (5 or more persons) AND housing cost burden is greater than 50% |
| LF_ELI_C_1 | Renter occupied AND household income is less than or equal to 30% of HAMFI AND other household type (non-elderly non-family) AND housing cost burden is greater than 50% |
| LF_LI_CB_1 | Renter occupied AND household income is greater than 30% but less than or equal to 50% of HAMFI AND other household type (non-elderly non-family) AND housing cost burden is greater than 50% |
| LF_MI_CB_1 | Renter occupied AND household income is greater than 50% but less than or equal to 80% of HAMFI AND other household type (non-elderly non-family) AND housing cost burden is greater than 50% |