Wolfram Computation Meets Knowledge

Wolfram Knowledge about US Congressional Districts in Microsoft Excel

US Congressional District entities each represent one congressional district, including non-voting members and historical, eliminated districts.

A few example entities...

Alabama 4th Congressional District
Florida 22nd Congressional District
Massachusetts 10th Congressional District
Missouri 3rd Congressional District
Missouri 5th Congressional District
New York 15th Congressional District
Ohio 14th Congressional District
Pennsylvania 4th Congressional District
Pennsylvania 9th Congressional District
Vermont At‐Large Congressional District

You can access the following properties for each entity...

  • name
  • US state
  • latitude
  • longitude
  • area
  • land area
  • water area
  • FIPS code
  • median household income
  • per capita income
  • population fraction below poverty line
  • aggregate household income
  • Gini index
  • households
  • households with income $0 to $25,000
  • households with income $25,000 to $50,000
  • households with income $50,000 to $100,000
  • households with income $100,000 to $200,000
  • population by educational attainment, high school diploma
  • population by educational attainment, some college
  • population by educational attainment, associate degree
  • population by educational attainment, bachelor's degree
  • population by educational attainment, master's degree
  • population by educational attainment, doctorate degree
  • population by educational attainment, professional school degree
  • population by marital status, never married
  • population by marital status, now married
  • population by marital status, widowed
  • population by marital status, divorced
  • population
  • population age 0 to 4
  • population age 5 to 17
  • population age 18 to 64
  • population age 65 and above
  • male population
  • female population
  • median age
  • population by race, white alone
  • population by race, black or African American alone
  • population by race, American Indian and Alaska native alone
  • population by race, Asian alone
  • population by race, native Hawaiian and other Pacific Islander alone
  • population by race, some other race alone
  • population by race, two or more races
  • households with income $200,000 and above
  • population fraction with high school diploma
  • population fraction with associate degree and above
  • population fraction without high school diploma
  • + more
  • - less

Note: Wolfram entities represent physical entities as well as mathematical and other scientific concepts. Each entity type has a unique set of properties. Wolfram entity types and properties correspond to "data types" and "fields" in Excel.

How to Use Wolfram Data in Excel

Note: This is now available with a Microsoft 365 Family or Personal subscription.

1

Highlight data and click the Automatic button

Select cells or columns in a table with the text to convert, then select the Automatic button in the Data Types gallery of the Data tab. Wolfram's natural language understanding will recognize the entities and convert them.

2

Browse associated data

Select the Insert Data button that appears to browse a list of all available properties. Select one to insert data into your workbook. When you have data in a table, Excel will automatically fill the table for you. Wolfram has hundreds of expertly curated entities in Excel, encompassing the sciences, arts, culture, and more.

3

Automatically get data

Once converted to an entity, you can use key Excel features to work with data pulled from Wolfram. Sort and Filter data, or create formulas that reference an entity's properties and values.

4

Browse more information

Selecting the icon of a converted cell opens a card where you can find detailed data from Wolfram. This means you don't need to leave Excel to accomplish your goals.

Compute with US Congressional District data in the Wolfram Language