The data structure of the Census API is a little inconvenient, particularly for use with Tableau. This will convert it to a more standard structure. Output should be saved as a text file with extension .json and connected to as a File data source in Tableau. Variable names are available from the Census Bureau.

Please input a Year:

Please input 1 for 1-year estimates or 5 for 5-year estimates:

Please input a Table code:

Please input a level of geography (us, state, or county):

Please input a State FIPS code, separated by commas:

All States: 01,02,04,05,06,08,09,10,11,12,13,66,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,72,44,45,46,47,48,78,49,50,51,53,54,55,56

Please input an API Key: