Following are visualizations of data. Many are interactive and created using Tableau Public. In some cases I’ve recorded myself using the visualization to tell a story, and all you have to do is watch.
An interactive visualization of gross domestic product by metropolitan area and industry.
The Bureau of Economic Analysis, an agency of the United States Department of Commerce, gathers data about economic output, known as gross domestic product. The visualization presented here presents this data in tabular and graphic form.
A nearby example from the visualization compares Wichita metro GDP growth to that of the nation’s metropolitan areas.
Click here to access this visualization.
Kansas tax receipts by category, presented in an interactive visualization.
The Kansas Division of the Budget publishes monthly statistics regarding tax collections. I’ve gathered these and present them in an interactive visualization.
In the nearby example from the visualization, we can see the rising trend in individual income taxes, due to the tax increase passed by the Kansas Legislature.
Click here to learn more and access the visualization.
Kansas has more state government employees per resident than most states, and the trend is rising.
Each year the United States Census Bureau surveys federal, state, and local government civilian employees. 1 The amount of payroll for a single month (March) is also recorded. In this case, I’ve made the data for state government employees available in an interactive visualization.
For 2016, Kansas had 17.90 full-time equivalent state government employees per thousand residents. This ranked 15th among the states. These employees resulted in payroll cost of $979 per resident, which is 21st among the states.
Nearby is an example from the visualization showing state government employment count (full-time equivalent) per thousand residents for Kansas and some nearby states. It shows total employment, and in addition, education employment and hospital employment. (Since nearly all employees in Kansas elementary and secondary schools are employees of local government, not the state, the employees shown are working in higher education. See below for visualizations of local government employees.)
Two things are evident: The level of employment in Kansas is generally higher than the other states, and the trend in Kansas is rising when many states are level or declining. This data counters the story often told, which is that state government employment has been slashed.
If we look at data for state and local government employees, the conclusions are nearly the same.
Click here to learn more and access the visualization.
There are separate visualizations for local government employees only, and also for state and local government employees together. Click on state and local government employment or local government employment by state and function.
—
Notes
Among nearby states, Kansas collects a lot of taxes, on a per-resident basis.
The United States Census Bureau collects data from the states regarding tax collections. Some data is available for each quarter subdivided by category.
From the first quarter of 2011 to the first quarter of 2018, Kansas and its local governmental units collected an average of $681 per quarter per resident in taxes. Of nearby states and a few others, Arkansas and Iowa had higher values, and Iowa is higher by only one percent.
Some states had lower values, such as Colorado at $565 per quarter per resident (17.0 percent less than Kansas), Texas and Missouri both at $486 (28.6 percent less), and Florida at $470 (31.0 percent less).
To learn more about this visualization and create your own, click here.
Wichita spending data presented as a summary, and as a list.
As part of an ongoing transparency project, I asked the City of Wichita for check register data. I’ve made the data available in a visualization using Tableau Public. This visualization is updated with data through August 31, 2018.
To learn more about this data and use the visualization, click here.
Kansas has nearly the highest number of local government employees per resident, compared to other states.
Considering elementary and secondary education, Kansas had 30.03 such employees per thousand residents. This was higher than all states but Vermont and Wyoming. The payroll for these employees was $1,150.85 per resident, with eleven states above Kansas.
Kansas is a small state in terms of population. Might small states have higher needs for employees on a per-resident basis? A plot of employees vs. population shows nearly no relationship between the two.
These are local government employees only. State and federal government employees are not included.
Of note, Hawaii has no local employees in elementary and secondary education, as it has one school district which is run by the state. 1
The source of this data is the United States Census Bureau. I’ve gathered it and placed in in an interactive visualization. Click here to learn about the visualization and use it to make your own charts and tables.
— Notes
Kansas has a lot of government employees when compared to other states, and especially so in education.
Considering all government employees — state and local — Kansas has 68.35 full-time equivalent (FTE) employees per thousand residents. Only two states and the District of Columbia have more.
For total elementary and secondary education employment, Kansas has 30.64 such employees (full-time equivalent) per thousand residents. Only two states have more.
Looking at nearby states and some Plains states commonly thought to be big spenders (Iowa and Minnesota), Kansas has more employees and more education employees, again on a per-resident basis.
This data comes from the United States Census Bureau. I’ve gathered it and present it in an interactive visualization. Click here to learn more about the visualization and to use it yourself.
Airport traffic data presented in an interactive visualization, updated through 2017.
A few observations regarding Wichita airport traffic as compared to the nation:
To view and use the interactive visualization, click here.
Considering all government employees in proportion to population, Kansas has many compared to other states, and especially so in education.
Each year the United States Census Bureau surveys federal, state, and local government civilian employees. I’ve gathered this data and present it in an interactive visualization using several views and supplementary calculations. 1
The Census Bureau collects both counts of employees and payroll dollars. Comparisons based on the number of employees are useful, bypassing issues such as differing costs of living and salaries in general.
Considering all government employees, Kansas has 68.35 full-time equivalent (FTE) employees per thousand residents. Only two states and the District of Columbia have more.
For total elementary and secondary education employment, Kansas has 30.64 such employees (full-time equivalent) per thousand residents. Only two states have more.
Click here to learn more about the visualization and to use it yourself.
—
Notes