5.12. Race and Ethnicity

Population breakdowns by race and ethnicity.

5.12.1. Total Population

../_images/us.census.acs.B01003001.png

The total number of all people living in a given geographic area. This is a very useful catch-all denominator when calculating rates.

Measure “Total Population” density per sq. kilometer for one point:

UPDATE {table_name}
  SET {new_numeric_column} =
    OBS_GetMeasure(
      CDB_LatLng(40.7, -73.9),
      'us.census.acs.B01003001'
    );

Measure “Total Population” within an area:

UPDATE {table_name}
  SET {new_numeric_column} =
    OBS_GetMeasure(
      ST_Buffer(CDB_LatLng(40.7, -73.9), 0.01),
      'us.census.acs.B01003001'
    );

5.12.1.1. American Indian and Alaska Native Population

../_images/us.census.acs.B03002005.png

The number of people identifying as American Indian or Alaska native in each geography.

Measure “American Indian and Alaska Native Population” density per sq. kilometer for one point:

UPDATE {table_name}
  SET {new_numeric_column} =
    OBS_GetMeasure(
      CDB_LatLng(40.7, -73.9),
      'us.census.acs.B03002005'
    );

Measure “American Indian and Alaska Native Population” within an area:

UPDATE {table_name}
  SET {new_numeric_column} =
    OBS_GetMeasure(
      ST_Buffer(CDB_LatLng(40.7, -73.9), 0.01),
      'us.census.acs.B03002005'
    );

Measure “American Indian and Alaska Native Population” percent of “Total Population” at one point:

UPDATE {table_name}
  SET {new_numeric_column} =
    OBS_GetMeasure(
      CDB_LatLng(40.7, -73.9),
      'us.census.acs.B03002005',
      'denominator'
    );

Measure “American Indian and Alaska Native Population” percent of “Total Population” within an area:

UPDATE {table_name}
  SET {new_numeric_column} =
    OBS_GetMeasure(
      ST_Buffer(CDB_LatLng(40.7, -73.9), 0.01),
      'us.census.acs.B03002005',
      'denominator'
    );
denominator:Total Population

5.12.1.2. Asian Population

../_images/us.census.acs.B03002006.png

The number of people identifying as Asian, non-Hispanic in each geography.

Measure “Asian Population” density per sq. kilometer for one point:

UPDATE {table_name}
  SET {new_numeric_column} =
    OBS_GetMeasure(
      CDB_LatLng(40.7, -73.9),
      'us.census.acs.B03002006'
    );

Measure “Asian Population” within an area:

UPDATE {table_name}
  SET {new_numeric_column} =
    OBS_GetMeasure(
      ST_Buffer(CDB_LatLng(40.7, -73.9), 0.01),
      'us.census.acs.B03002006'
    );

Measure “Asian Population” percent of “Total Population” at one point:

UPDATE {table_name}
  SET {new_numeric_column} =
    OBS_GetMeasure(
      CDB_LatLng(40.7, -73.9),
      'us.census.acs.B03002006',
      'denominator'
    );

Measure “Asian Population” percent of “Total Population” within an area:

UPDATE {table_name}
  SET {new_numeric_column} =
    OBS_GetMeasure(
      ST_Buffer(CDB_LatLng(40.7, -73.9), 0.01),
      'us.census.acs.B03002006',
      'denominator'
    );
denominator:Total Population

5.12.1.3. Black or African American Population

../_images/us.census.acs.B03002004.png

The number of people identifying as black or African American, non-Hispanic in each geography.

Measure “Black or African American Population” density per sq. kilometer for one point:

UPDATE {table_name}
  SET {new_numeric_column} =
    OBS_GetMeasure(
      CDB_LatLng(40.7, -73.9),
      'us.census.acs.B03002004'
    );

Measure “Black or African American Population” within an area:

UPDATE {table_name}
  SET {new_numeric_column} =
    OBS_GetMeasure(
      ST_Buffer(CDB_LatLng(40.7, -73.9), 0.01),
      'us.census.acs.B03002004'
    );

Measure “Black or African American Population” percent of “Total Population” at one point:

UPDATE {table_name}
  SET {new_numeric_column} =
    OBS_GetMeasure(
      CDB_LatLng(40.7, -73.9),
      'us.census.acs.B03002004',
      'denominator'
    );

Measure “Black or African American Population” percent of “Total Population” within an area:

UPDATE {table_name}
  SET {new_numeric_column} =
    OBS_GetMeasure(
      ST_Buffer(CDB_LatLng(40.7, -73.9), 0.01),
      'us.census.acs.B03002004',
      'denominator'
    );
denominator:Total Population

5.12.1.4. Hispanic Population

../_images/us.census.acs.B03002012.png

The number of people identifying as Hispanic or Latino in each geography.

Measure “Hispanic Population” density per sq. kilometer for one point:

UPDATE {table_name}
  SET {new_numeric_column} =
    OBS_GetMeasure(
      CDB_LatLng(40.7, -73.9),
      'us.census.acs.B03002012'
    );

Measure “Hispanic Population” within an area:

UPDATE {table_name}
  SET {new_numeric_column} =
    OBS_GetMeasure(
      ST_Buffer(CDB_LatLng(40.7, -73.9), 0.01),
      'us.census.acs.B03002012'
    );

Measure “Hispanic Population” percent of “Total Population” at one point:

UPDATE {table_name}
  SET {new_numeric_column} =
    OBS_GetMeasure(
      CDB_LatLng(40.7, -73.9),
      'us.census.acs.B03002012',
      'denominator'
    );

Measure “Hispanic Population” percent of “Total Population” within an area:

UPDATE {table_name}
  SET {new_numeric_column} =
    OBS_GetMeasure(
      ST_Buffer(CDB_LatLng(40.7, -73.9), 0.01),
      'us.census.acs.B03002012',
      'denominator'
    );
denominator:Total Population

5.12.1.5. Other Race population

../_images/us.census.acs.B03002008.png

The number of people identifying as another race in each geography

Measure “Other Race population” density per sq. kilometer for one point:

UPDATE {table_name}
  SET {new_numeric_column} =
    OBS_GetMeasure(
      CDB_LatLng(40.7, -73.9),
      'us.census.acs.B03002008'
    );

Measure “Other Race population” within an area:

UPDATE {table_name}
  SET {new_numeric_column} =
    OBS_GetMeasure(
      ST_Buffer(CDB_LatLng(40.7, -73.9), 0.01),
      'us.census.acs.B03002008'
    );

Measure “Other Race population” percent of “Total Population” at one point:

UPDATE {table_name}
  SET {new_numeric_column} =
    OBS_GetMeasure(
      CDB_LatLng(40.7, -73.9),
      'us.census.acs.B03002008',
      'denominator'
    );

Measure “Other Race population” percent of “Total Population” within an area:

UPDATE {table_name}
  SET {new_numeric_column} =
    OBS_GetMeasure(
      ST_Buffer(CDB_LatLng(40.7, -73.9), 0.01),
      'us.census.acs.B03002008',
      'denominator'
    );
denominator:Total Population

5.12.1.6. Population not Hispanic

../_images/us.census.acs.B03002002.png

The number of people not identifying as Hispanic or Latino in each geography.

Measure “Population not Hispanic” density per sq. kilometer for one point:

UPDATE {table_name}
  SET {new_numeric_column} =
    OBS_GetMeasure(
      CDB_LatLng(40.7, -73.9),
      'us.census.acs.B03002002'
    );

Measure “Population not Hispanic” within an area:

UPDATE {table_name}
  SET {new_numeric_column} =
    OBS_GetMeasure(
      ST_Buffer(CDB_LatLng(40.7, -73.9), 0.01),
      'us.census.acs.B03002002'
    );

Measure “Population not Hispanic” percent of “Total Population” at one point:

UPDATE {table_name}
  SET {new_numeric_column} =
    OBS_GetMeasure(
      CDB_LatLng(40.7, -73.9),
      'us.census.acs.B03002002',
      'denominator'
    );

Measure “Population not Hispanic” percent of “Total Population” within an area:

UPDATE {table_name}
  SET {new_numeric_column} =
    OBS_GetMeasure(
      ST_Buffer(CDB_LatLng(40.7, -73.9), 0.01),
      'us.census.acs.B03002002',
      'denominator'
    );
denominator:Total Population

5.12.1.7. Two or more races population

../_images/us.census.acs.B03002009.png

The number of people identifying as two or more races in each geography

Measure “Two or more races population” density per sq. kilometer for one point:

UPDATE {table_name}
  SET {new_numeric_column} =
    OBS_GetMeasure(
      CDB_LatLng(40.7, -73.9),
      'us.census.acs.B03002009'
    );

Measure “Two or more races population” within an area:

UPDATE {table_name}
  SET {new_numeric_column} =
    OBS_GetMeasure(
      ST_Buffer(CDB_LatLng(40.7, -73.9), 0.01),
      'us.census.acs.B03002009'
    );

Measure “Two or more races population” percent of “Total Population” at one point:

UPDATE {table_name}
  SET {new_numeric_column} =
    OBS_GetMeasure(
      CDB_LatLng(40.7, -73.9),
      'us.census.acs.B03002009',
      'denominator'
    );

Measure “Two or more races population” percent of “Total Population” within an area:

UPDATE {table_name}
  SET {new_numeric_column} =
    OBS_GetMeasure(
      ST_Buffer(CDB_LatLng(40.7, -73.9), 0.01),
      'us.census.acs.B03002009',
      'denominator'
    );
denominator:Total Population

5.12.1.8. White Population

../_images/us.census.acs.B03002003.png

The number of people identifying as white, non-Hispanic in each geography.

Measure “White Population” density per sq. kilometer for one point:

UPDATE {table_name}
  SET {new_numeric_column} =
    OBS_GetMeasure(
      CDB_LatLng(40.7, -73.9),
      'us.census.acs.B03002003'
    );

Measure “White Population” within an area:

UPDATE {table_name}
  SET {new_numeric_column} =
    OBS_GetMeasure(
      ST_Buffer(CDB_LatLng(40.7, -73.9), 0.01),
      'us.census.acs.B03002003'
    );

Measure “White Population” percent of “Total Population” at one point:

UPDATE {table_name}
  SET {new_numeric_column} =
    OBS_GetMeasure(
      CDB_LatLng(40.7, -73.9),
      'us.census.acs.B03002003',
      'denominator'
    );

Measure “White Population” percent of “Total Population” within an area:

UPDATE {table_name}
  SET {new_numeric_column} =
    OBS_GetMeasure(
      ST_Buffer(CDB_LatLng(40.7, -73.9), 0.01),
      'us.census.acs.B03002003',
      'denominator'
    );
denominator:Total Population