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.
The nearby example shows data starting in 2010 for the nation (blue lines) and Wichita. The visualization holds data for all U.S. airports with scheduled flights.
Example from the visualization, showing Wichita compared to all airports, through 2018. Click for larger
A few observations regarding Wichita airport traffic as compared to the nation:
Since 2014, passenger traffic (departing passengers) at the Wichita airport is higher, but traffic for the nation as a whole is much higher.
The number of scheduled departures has been declining in Wichita, while increasing for the nation after a decline.
The number of available seats on departing flights from Wichita has been mostly level, while rising sharply for the nation.
Load factor for Wichita has been rising, while level and declining slightly for the nation.
To view and use the interactive visualization, click here.
A visualization of the population of metropolitan statistical areas, now with annual data from 1969 through 2018.
For most types of economic and demographic analysis, metropolitan statistical areas (MSA) are preferred to cities proper. The Census Bureau notes: “The general concept of a metropolitan or micropolitan statistical area is that of a core area containing a substantial population nucleus, together with adjacent communities having a high degree of economic and social integration with that core.” 1
Further, there is more economic data available at the MSA level (compared to the city level) from agencies like Bureau of Labor Statistics and Bureau of Economic Analysis. This data includes important measures like employment, labor force, unemployment rate, gross domestic product, and personal income.
This visualization has several different views of population data, from tables to charts showing relative growth. A new feature is a map. You can select a range of years, and as you point to a metropolitan area you’ll see the population change over that time.
An interactive table and charts of populations in the states and regions, from 1929 through 2018.
How have the states grown in population since 1929? Growth varies widely. This visualization has several views that illustrate changes in state populations.
An interactive table and charts of populations in the states and regions, starting in 1929.
How have the states grown in population since 1929? Growth varies greatly.
In the accompanying visualization, one chart of the growth of population uses a logarithmic scale. This better shows a wide range of values. On this scale, negative values can’t be shown. The example below highlights Kansas against the other states.
Another tab in this visualization displays a map of the states along with a slider to select a range of years. For each state, you can see the change in population over this range of time.
Kansas personal income tax collections rose by $372 per person in 2018, an increase of 46.5 percent.
Each year the United States Census Bureau collects a summary of taxes collected by each state for 5 broad tax categories and up to 25 tax subcategories. 1 I’ve collected this data and made it available in an interactive visualization. Data is through 2018.
You may recall that Kansas raised personal income tax rates in 2017 and made the new rate retroactive to January 1, 2017. But that change doesn’t seem to have affected the data for fiscal year 2017. For 2016, Kansas collected $767 per person in individual income taxes, and for 2017, $800. Not much difference.
Now data for fiscal year 2018 is available, and it shows Kansas collecting $1,172 per person in individual income taxes, an increase of $372 or 46.5 percent over 2017.
(Here’s the reason for the 2017 data being relatively unaffected. For most states, including Kansas, this data is for the fiscal year, not the calendar year. 2 New withholding tax tables were not available until June 27, 2017, just three days before the end of fiscal year 2017. 3)
Considering all taxes, Kansas collected $3,279 per person in 2018, up from $2,808 in 2017, an increase of $471 or 16.8 percent.
BEA defines GDP as “the value of the goods and services produced by the nation’s economy less the value of the goods and services used up in production.” It is the value of the final goods and services produced. These values are real, meaning adjusted for inflation. The values for year 2018 are preliminary and subject to revision.
As shown in the accompanying illustration, Kansas has not kept up with most surrounding states.
In the interactive visualization, you may select a time period, one or more states, and one or more industries.
To learn more about the data and access the visualization, click here.
An interactive visualization of the civilian labor force, employment, and unemployment, for each state. Updated through March 2019.
As seen in the nearby example, Kansas continues its undistinguished record in job growth as compared to nearby states. In the visualization, you can easily choose states to compare, select a timeframe, and look at labor force, employment, and unemployment.
Click here to learn more about the data and access the interactive visualization.
Kansas hotel guest tax collections presented in an interactive visualization.
Updated with data through January 2019.
Cities and counties in Kansas may levy a transient guest tax collection on hotel guests. It is sometimes called a bed tax or guest tax. The tax is collected as a percentage of total room revenue, not the number of rooms or the rate charged for rooms. While the Kansas Department of Revenue collects the tax, the proceeds are returned to the cities or counties, except for a two percent processing fee. In Wichita the rate is six percent.
Of note, while Wichita is the largest city in Kansas, Overland Park collects the most hotel guest tax. Of the largest markets in Kansas, Wichita is usually one of the lowest-growth cities.
Kansas hotel guest tax collections presented in an interactive visualization.
Cities and counties in Kansas may levy a transient guest tax collection on hotel guests. It is sometimes called a bed tax or guest tax. The tax is collected as a percentage of total room revenue, not the number of rooms or the rate charged for rooms. While the Kansas Department of Revenue collects the tax, the proceeds are returned to the cities or counties, except for a two percent processing fee. In Wichita the rate is six percent.
In some cases, jurisdictions may levy additional taxes that may not be paid to the Kansas Department of Revenue. This is the case with the Wichita city tourism fee, which took effect on January 1, 2015. This tax of 2.75% is paid directly to the city1, so it doesn’t appear in KDOR figures.
Also, jurisdictions may change the tax rate. The Kansas Department of Revenue maintains a list of taxes charged. 2
The visualization has three views of data. One is a table of collections, including percent change from the previous year. A line chart shows the dollar amount of collections. A second line chart shows collections indexed to a common starting point. This is useful for comparing the relative change in guest tax collections. These line charts show data as the average of the previous 12 months.
Examples of nondisclosure.This data does not represent all hotels in Kansas. Confidentiality rules prohibit disclosure when a jurisdiction has a small number of hotels. In the nearby example, the value “C” is reported for Sedgwick County, indicating such non-disclosure. Obviously, there are hotels in Sedgwick County. But considering hotels in Sedgwick County that are not located in cities like Wichita, the number is too small to report, based on confidentiality guidelines. Similarly, for small cities, data is probably not available to the public.
Now updated with data through the third quarter of 2018, quarterly state and local government tax collections. Data is from the United States Census Bureau and groups data by tax category. Click here to access.
Data regarding State of Kansas agency spending presented in an interactive visualization.
The source of this data is KanView, the Kansas transparency portal, through its download center. Data from multiple years are combined into one database. Data starts with fiscal year 2011.
This visualization is experimental. I would appreciate feedback on views of this data that would be useful.
Data regarding State of Kansas agency spending presented in an interactive visualization.
The source of this data is KanView, the Kansas transparency portal, through its download center. Data from multiple years are combined into one database. Data starts with fiscal year 2011.
Of this data, KanView advises: “Agency expenditure data is available by Agency Fund Type, Agency Primary Expenditure Accounts, and by Agency Program.” The various views of the visualization show this data arranged in these ways.
Regarding accounts, KanView offers this explanation:
State expenditures are classified at a primary, intermediate, and detail level account codes. These classifications facilitate the various levels of reporting detail required for budgetary, financial, management, or other reports.
Seven primary expenditure classifications are prescribed. Intermediate classifications are assigned within each primary classification. Within each intermediate classification is the detail classifications used to code accounting transactions.
The prescribed primary classifications are:
Salaries and Wages: Amounts paid to, or on behalf of, elected or appointed state officials and employees.
Contractual Services: Payments for communications, freight and express, printing and advertising, rentals, repairing and servicing, employee travel expense reimbursement, utilities, and professional or other services.
Commodities: Payments for consumable supplies, maintenance materials and parts, and other miscellaneous purchases.
Capital Outlay: Payments for machinery, equipment, land, vehicles, buildings and other major purchases.
Grants, Claims and Shared Revenue: Disbursements for grants, claims, shared revenue and other related disbursements where the disbursing agency does not receive a direct service or tangible asset.
Debt Service: Payments of principal, interest and service charges on borrowed money.
Non-Expense Items: Disbursements for refunds, advances, investments and other disbursements not properly classified as governmental expenditures.
Expense Transfers: Agency use of transfer account codes is generally only on interfund transactions between state agencies. Transfers move cash from one fund to another fund within the State Treasury.
Regarding functions:
The function view identifies expenditures for high-level activities and programs of the State, upon selecting a high-level function, specific programs within this function can then be displayed for a particular state agency.
Major State Functions include: General Administration, Human Resources, Education, Public Safety, Agriculture and Natural Resources, Highways and Other Transportation, Health and Environment, Economic Development, Lottery, and Universities.
For funds, KanView explains:
A “fund” is the fundamental unit of accounting designed to demonstrate legal compliance and to aid financial management by segregating transactions related to certain governmental functions or activities. Fund View initially displays the major fund types denoting the high-level purpose of the underlying funds as classified in the statewide accounting and reporting system. Upon selecting a major fund type, specific funds can then be displayed for a particular state agency. Each agency fund is further segregated by individual accounts (for budgetary or other legal requirements) which provides an additional level of classification.
Valid major fund types and descriptions are:
State General Fund: The primary operating fund of the State. It accounts for all financial resources of the State except those required to be accounted for in another fund. The state general fund is primarily supported by tax revenue.
Special Revenue Funds: Funds established for specific purposes normally specified by state statutes, or in the case of federal grants, for purposes specified by the federal government. These funds are primarily supported by user fees or grants.
Capital Projects Funds: Funds established to account for the acquisition and construction of major capital facilities other than those financed by proprietary funds and trust funds.
Debt Service Funds: Funds established to account for the accumulation of resources and the payment of long term debt principal and interest.
Enterprise Funds: Funds established to account for activities that are generally of a business nature where goods or services a sold to the general public or similar customer groups.
Internal Service Funds: Funds established to account for goods and services provided to other state agencies or internal departments on a cost-reimbursement basis.
Trust and Agency Funds: Trust funds contain monies received, held, and disbursed by the State acting as a trustee, agent, or custodian. Agency funds contain monies collected by the State as an agent and disbursed to other governments, businesses or individuals.
Component Units Funds: Funds of component unit(s). A component unit is a legally separate organization for which the primary government is financially accountable.
This visualization is experimental. I would appreciate feedback on views of this data that would be useful.
Data regarding State of Kansas payments to vendors.
The source of this data is KanView, the Kansas transparency portal, through its download center. Data from multiple years are combined into one database. Data starts with July 1, 2010.
KanView says this data shows “payments made to vendors from all state agencies and include the following key data elements: fiscal year, agency (Business Unit), account description, funding, vendor name, document number, payment date and amount.”
This visualization is experimental. I would appreciate feedback on view of this data that would be useful. The visualization may be slow to respond, as it holds 7.3 million rows of data.
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. Updated with data through October 2018.
Click here to learn more and access the visualization.
An interactive visualization of Kansas school salaries by district and category.
This visualization holds salaries of Kansas school superintendents, principals, and teachers. The visualization shows the average for each of these categories for each school district. The values are adjusted for inflation to the most current year values. Some data is presented on a per-pupil basis using full-time equivalent student counts.
The visualization includes both tables and charts. The source of the data is Kansas State Department of Education for salaries and enrollments, United States Bureau of Labor Statistics for price levels, and author’s calculations.
Kansas school salaries. Click for larger.Kansas school salaries on a per-student basis. Click for larger.Example from the visualization. Click for larger.
An interactive visualization of Kansas school salaries by district and category.
This visualization holds salaries of Kansas school superintendents, principals, and teachers. The visualization shows the average for each employee category for each school district. The visualization includes both tables and charts. Some data is presented on a per-pupil basis using full-time equivalent student counts.
The values are adjusted for inflation to the most current year values.
KSDE says this data includes contracted salaries, including fringe benefits. More information from KSDE is available for superintendents, principals, and teachers.
Wichita and national GDP. Click for larger.The GDP figures are real, meaning adjusted for inflation. They are annual numbers through 2017. The release this week also includes revisions for the prior year. In the case of Wichita, the revision was significant, with a loss in GDP being revised to a gain. See Wichita economy shrinks, and a revision for details.
A nearby example from the visualization compares Wichita metro GDP growth to that of the nation’s metropolitan areas.
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.
