This data is pulled from the annual Financial Trends Monitoring System (FTMS). The KCSTAT dashboards for Finance and Governance provide visualizations of this data, along with narrative to explain what these indicators mean. The FTMS report itself goes also provides a great deal of narrative, and can be viewed by visiting: https://kcstat.kcmo.org/Finance/2013-FTMS-7-29-14-Revised/n7p4-kkha
This dataset has the following 109 columns:
Column Name | API Column Name | Data Type | Description | Sample Values |
---|---|---|---|---|
Fiscal Year | calendar_year | number | 2012 2011 2016 2003 2010 view top 100 | |
Fiscal Year Text Label | fiscal_year_text_label | text | This label exist to use as an axis label. | FY2017 FY2016 FY2011 FY2005 FY2012 view top 100 |
Time Stamp | time_stamp | calendar_date | This column is for graphing | 2006-04-30T00:00:00.000 2008-04-30T00:00:00.000 2009-04-30T00:00:00.000 2014-04-30T00:00:00.000 2012-04-30T00:00:00.000 view top 100 |
Population (used for per capita calculations) | population_used_for_per_capita_calculations | number | 459787 456139 448842 470800 462035 view top 100 | |
Price Index (For Inflation Calculation) | price_index_for_inflation_calculation | number | 85.3783414774 90.2553715148 100 79.4948260995 95.8878269618 view top 100 | |
Commercial Properties Taxable Real Property Market Value Per Capita- Real Dollars | commercial_properties_taxable_real_property_market_value_per_capita_real_dollars | number | 7864.95 9530.65 11323.16 9154.41 11062.56 view top 100 | |
Residential Properties Taxable Real Property Market Value Per Capita- Real Dollars | residential_properties_taxable_real_property_market_value_per_capita_real_dollars | number | 37802.95 25003.97 25941.85 38961.48 30985.66 view top 100 | |
Commercial Building Permit Valuation - Real Dollars | commercial_building_permit_valuation_real_dollars | number | 234633697.06 306924937.18 628801954.76 232996625.31 269489507.45 view top 100 | |
Residential Building Permit Valuation - Real Dollars | residential_building_permit_valuation_real_dollars | number | 195073222.27 181685129.38 354520842.81 231817159.59 98689394.71 view top 100 | |
Revenue - Structural Balance - General, Special Revenue, and Capital Funds - Nominal Dollars | structural_balance_revenue_general_special_revenue_and_capital_funds_real_dollars | number | 956803000 962048000 821860000 923235000 941191000 view top 100 | |
Expenditures - Structural Balance - General, Special Revenue, and Capital Funds - Nominal Dollars | structural_balance_expenditures_general_special_revenue_and_capital_funds_real_dollars | number | 1016850000 945070000 971869000 755532000 986771000 view top 100 | |
General Fund Unreserved Fund Balance | general_fund_unreserved_fund_balance | number | 4.67 12.29 8.57 8.29 5.95 view top 100 | |
General Fund Unreserved Fund Balance - Council Policy | general_fund_unreserved_fund_balance_council_policy | number | 16.67 view top 100 | |
Special Revenue and Capital Fund - Unreserved Fund Balance | special_revenue_and_capital_fund_unreserved_fund_balance | number | 74799000 196671000 163118000 93495000 114882000 view top 100 | |
Operating Surplus/Deficit | operating_surplus_deficit | number | 35812000 -30678000 -16022000 -21835000 10115000 view top 100 | |
Liquidity Ratio | liquidity_ratio | number | 1.92 1.88 3.7983 2.46 5.3047 view top 100 | |
Gross Operating Revenues | gross_operating_revenues | number | 949251702 919293000 950131077.21 932915077.21 983218921 view top 100 | |
Gross Operating Revenue After (net) Redirections | gross_operating_revenue_after_net_redirections | number | 908302000 926153179.42 783996037 933872000 893172000 view top 100 | |
Real Operating Revenue Per Capita - Real Dollars | real_operating_revenue_per_capita_real_dollars | number | 2307.37 2040.57 2069.99 2051.58 2142.60 view top 100 | |
Real Operating Revenue After (net) Redirections Per Capita - Real Dollars | real_operating_revenue_after_net_redirections_per_capita_real_dollars | number | 2081.91 1959.54 2000.86 2157.77 2047.89 view top 100 | |
General Fund Revenue - Nominal Dollars | general_fund_revenue_nominal_dollars | number | 472421000 428109000 496545000 376757000 490844000 view top 100 | |
Special Revenue and Capital Improvement Revenue | special_revenue_and_capital_improvement_revenue | number | 384375000 443688000 435881000 428453000 370379000 view top 100 | |
Dedicated Revenue as a Percent of Total Revenues | dedicated_revenue_as_a_percent_of_total_revenues | number | 45.53 50.87 47.46 48.03 46.02 view top 100 | |
Percent of Total Revenue with a Renewal Requirement | percent_of_total_revenue_with_a_renewal_requirement | number | 51.62 24.94 27.84 51.89 24.60 view top 100 | |
Earning and Profits Tax Revenue -Nominal Dollars | earning_and_profits_tax_revenue_nominal_dollars | number | 168378969.29 195730388 198023748.94 201252331.78 217447886 view top 100 | |
Earning and Profits Tax Revenue Redirections -Nominal Dollars | earning_and_profits_tax_revenue_redirections_nominal_dollars | number | 21526568 15549176 12448213 9963853 5646670 view top 100 | |
Earning and Profits Tax After (net) Redirections -Nominal Dollars | earning_and_profits_tax_after_net_redirections_nominal_dollars | number | 192285435.85 192672385.94 186044102.47 185805712 191737392.78 view top 100 | |
Earning and Profits Tax Revenue Per Capita, Before Redirections - In Real Dollars | earning_and_profits_tax_revenue_per_capita_before_redirections_in_real_dollars | number | 478.31 465.52 478.55 448.84 478.06 view top 100 | |
Earning and Profits Tax Revenue Per Capita, After (net) Redirections - In Real Dollars | earning_and_profits_tax_revenue_per_capita_after_net_redirections_in_real_dollars | number | 445.58 433.01 452.84 417.19 464.76 view top 100 | |
Sales and Use Tax Revenue -Nominal Dollars | sales_and_use_tax_revenue_nominal_dollars | number | 192696710.9 146508398.79 174692717 184423647.18 189205445 view top 100 | |
Sales and Use Tax Revenue Redirections -Nominal Dollars | sales_and_use_tax_revenue_redirections_nominal_dollars | number | 10861926 22946884.44 15890762 21516810 11381864 view top 100 | |
Sales and Use Tax After (net) Redirections -Nominal Dollars | sales_and_use_tax_after_net_redirections_nominal_dollars | number | 168587418.53 151079798.58 170114752.08 210842301 129280796.75 view top 100 | |
Sales and Use Tax Revenue Per Capita, Before Redirections - In Real Dollars | sales_and_use_tax_revenue_per_capita_before_redirections_in_real_dollars | number | 475.45 413.87 449.58 410.61 389.20 view top 100 | |
Sales and Use Tax Revenue Per Capita, After (net) Redirections - In Real Dollars | sales_and_use_tax_revenue_per_capita_after_net_redirections_in_real_dollars | number | 442.50 439.24 447.68 376.45 384.74 view top 100 | |
Property Tax Revenue -Nominal Dollars | property_tax_revenue_nominal_dollars | number | 121126195.59 125765103.42 95831490.53 130689280.55 128367444.57 view top 100 | |
Property Tax Revenue Redirections -Nominal Dollars | property_tax_revenue_redirections_nominal_dollars | number | 9013126.80 9883609.63 4827803.76 5412192.59 3579488.53 view top 100 | |
Property Tax After (net) Redirections -Nominal Dollars | property_tax_after_net_redirections_nominal_dollars | number | 122585654 110419407 85362205 120790011 121791533 view top 100 | |
Property Tax Revenue Per Capita, After Redirections - In Real Dollars | property_tax_revenue_per_capita_after_redirections_in_real_dollars | number | 277.30 293.48 249.66 244.35 293.22 view top 100 | |
Property Tax Revenue Per Capita, Before Redirections - In Real Dollars | property_tax_revenue_per_capita_before_redirections_in_real_dollars | number | 306.65 266.01 297.42 315.68 325.88 view top 100 | |
Utility Franchise Fee Revenue -Nominal Dollars | utility_franchise_fee_revenue_nominal_dollars | number | 93133638 65986397.78 97225166 68866844.22 66595770.81 view top 100 | |
Utility Franchise Fee Revenue Redirections -Nominal Dollars | utility_franchise_fee_revenue_redirections_nominal_dollars | number | 2212752 991340 1899160 992803 2165114 view top 100 | |
Utility Franchise Fee After (net) Redirections -Nominal Dollars | utility_franchise_fee_after_net_redirections_nominal_dollars | number | 87963979.25 65146199.78 65602967.81 64215812.99 85721222.64 view top 100 | |
Utility Franchise Fee Revenue Per Capita, Before Redirections - In Real Dollars | utility_franchise_fee_revenue_per_capita_before_redirections_in_real_dollars | number | 211.78 177.54 203.11 222.80 228.96 view top 100 | |
Utility Franchise Fee Revenue Per Capita, After (net) Redirections - In Real Dollars | utility_franchise_fee_revenue_per_capita_after_net_redirections_in_real_dollars | number | 225.25 174.21 202.70 202.76 206.56 view top 100 | |
Tourism & Leisure Tax and Fee Revenue -Nominal Dollars | tourism_leisure_tax_and_fee_revenue_nominal_dollars | number | 71808187.98 70161416 68951125 66174808.25 66872120.12 view top 100 | |
Tourism & Leisure Tax and Fee Revenue Redirections -Nominal Dollars | tourism_leisure_tax_and_fee_revenue_redirections_nominal_dollars | number | 1808990 3403381 1740676 1681975 3391005.09 view top 100 | |
Tourism & Leisure Tax and Fee After (net) Redirections -Nominal Dollars | tourism_leisure_tax_and_fee_after_net_redirections_nominal_dollars | number | 60858869.99 64062748.25 64170842.65 65724685 64841999 view top 100 | |
Tourism & Leisure Tax and Fee Revenue Per Capita, Before Redirections - In Real Dollars | tourism_leisure_tax_and_fee_revenue_per_capita_before_redirections_in_real_dollars | number | 133.30 145.78 159.73 180.23 175.72 view top 100 | |
Tourism & Leisure Tax and Fee Revenue Per Capita, After (net) Redirections - In Real Dollars | tourism_leisure_tax_and_fee_revenue_per_capita_after_net_redirections_in_real_dollars | number | 128.49 167.18 131.93 142.64 145.60 view top 100 | |
Business License Tax and Fee Revenue - Nominal Dollars | business_license_tax_and_fee_revenue_nominal_dollars | number | 23227925 23048784.26 20564911.99 21585893 21746461.65 view top 100 | |
Business License Tax and Fee Revenue Per Capita - In Real Dollars | business_license_tax_and_fee_revenue_per_capita_in_real_dollars | number | 47.85 49.56 45.74 47.93 49.74 view top 100 | |
Service Charges Revenue - Nominal Dollars | service_charges_revenue_nominal_dollars | number | 49464.87 47081.22 61511 62721.51 61728.80 view top 100 | |
Service Charges as a Percent of Total Revenue | service_charges_as_a_percent_of_total_revenue | number | 6.25 6.14 6.61 6.01 6.16 view top 100 | |
Intergovernmental Revenue - Nominal Dollars | intergovernmental_revenue_nominal_dollars | number | 132043 110460 89449 104007 121181 view top 100 | |
Intergovernmental Revenue as a Percent of Total Revenue | intergovernmental_revenue_as_a_percent_of_total_revenue | number | 11.75 10.38 7.67 9.27 10.19 view top 100 | |
Operating Expenditures | operating_expenditures | number | 558153038 628321121 584332612 568672691 635872749 view top 100 | |
Expenditures Per Capita -Real Dollars | expenditures_per_capita_real_dollars | number | 1371.08 1344.99 1340.86 1344.92 1337.69 view top 100 | |
Expenditures on Public Safety - Nominal Dollars | expenditures_on_public_safety_nominal_dollars | number | 321279150 280913026 267117984 249178862 365053622 view top 100 | |
Expenditures on Public Infrastructure - Nominal Dollars | expenditures_on_public_infrastructure_nominal_dollars | number | 48947105 63251968 52887914 56745438 55150917 view top 100 | |
Expenditures on Neighborhood Livability - Nominal Dollars | expenditures_on_neighborhood_livability_nominal_dollars | number | 72782384 71646917 72533623 65003652 75379292 view top 100 | |
Expenditures on Healthy Community - Nominal Dollars | expenditures_on_healthy_community_nominal_dollars | number | 21171255 21581116 22641514 21640326 18119594 view top 100 | |
Expenditures on Governance - Nominal Dollars | expenditures_on_governance_nominal_dollars | number | 68893347 80454045 71612467 57563202 62645796 view top 100 | |
Expenditures on Economic Growth - Nominal Dollars | expenditures_on_economic_growth_nominal_dollars | number | 31657881 36064931 33730085 40929482 33610752 view top 100 | |
Expenditures on Public Safety Per Capita - In Real Dollars | expenditures_on_public_safety_per_capita_in_real_dollars | number | 774.07 771.16 776.54 814.05 770.43 view top 100 | |
Expenditures on Public Infrastructure Per Capita - Real Dollars | expenditures_on_public_infrastructure_per_capita_real_dollars | number | 136.11 134.69 134.98 140.15 136.34 view top 100 | |
Expenditures on Neighborhood Livability Per Capita - Real Dollars | expenditures_on_neighborhood_livability_per_capita_real_dollars | number | 163.80 166.16 169.25 172.65 157.11 view top 100 | |
Expenditures on Healthy Community Per Capita - Real Dollars | expenditures_on_healthy_community_per_capita_real_dollars | number | 47.06 52.11 53.13 50.05 43.04 view top 100 | |
Expenditures on Governance Per Capita - Real Dollars | expenditures_on_governance_per_capita_real_dollars | number | 175.45 142.02 157.90 142.94 150.96 view top 100 | |
Expenditures on Economic Growth Per Capita - Real Dollars | expenditures_on_economic_growth_per_capita_real_dollars | number | 77.08 71.72 105.51 70.41 77.98 view top 100 | |
Non Public Safety Expenditures Per Capita - In Real Dollars | non_public_safety_expenditures_per_capita_in_real_dollars | number | 563.61 566.78 588.23 597.96 644.55 view top 100 | |
Salaries and Benefits Expenditure - Nominal Dollars | salaries_and_benefits_expenditure_nominal_dollars | number | 323434890 450662433 394400187 375267072 342979066 view top 100 | |
Operating Expenditures - Nominal Dollars | operating_expenditures_nominal_dollars | number | 558153038 628321121 584332612 568672691 635872749 view top 100 | |
Salaries and Benefits as a Percent of Operating Expenditurse | salaries_and_benefits_as_a_percent_of_operating_expenditurse | number | 70.87 69.09 66.91 68.20 65.75 view top 100 | |
Pension Expenditures | pension_expenditures | number | 68092443 52367306 38007693 41802061 47023915 view top 100 | |
Pension Benefits as a Percent of Personnel Costs | pension_benefits_as_a_percent_of_personnel_costs | number | 11.33 11.30 11.23 15.11 11.13 view top 100 | |
Health and Life Insurance Benefits Expenditures - Nominal Dollars | health_and_life_insurance_benefits_expenditures_nominal_dollars | number | 39295151 30874088 49807190 44816075 39548730 view top 100 | |
Health and Life Insurance Benefits as a Percent of Personnel Costs | health_and_life_insurance_benefits_as_a_percent_of_personnel_costs | number | 11.30 11.24 11.53 11.71 9.55 view top 100 | |
Total Fringe Benefits Expenditures - Nominal Dollars | total_fringe_benefits_expenditures_nominal_dollars | number | 120865085 88237039 66885299 102174496 93655352 view top 100 | |
Total Fringe Benefits as a Percent of Operating Expenditures | total_fringe_benefits_as_a_percent_of_operating_expenditures | number | 21.92 22.57 20.68 20.78 26.82 view top 100 | |
Salares (no benefits) Expenditures - Nominal Dollars | salares_no_benefits_expenditures_nominal_dollars | number | 293001415 305144069 300039706 321256169 331915085 view top 100 | |
Capital Expenditures - Nominal Dollars | capital_expenditures_nominal_dollars | number | 334251000 207885000 135453000 83755000 212248000 view top 100 | |
Total General Government Expenditures - Nominal Dollars | total_general_government_expenditures_nominal_dollars | number | 1090400000 765974000 789979000 1045213000 1084799000 view top 100 | |
Capital as a Percent of General Government Expenditures | capital_as_a_percent_of_general_government_expenditures | number | 9.61 23.38 25.53 18.81 12.38 view top 100 | |
Outstanding Direct Debt as a Percent of Market Value of Taxable Property | outstanding_direct_debt_as_a_percent_of_market_value_of_taxable_property | number | 5.29 4.95 2.38 5.24 5.28 view top 100 | |
Credit Industry Threshold | credit_industry_threshold | number | 1.00 view top 100 | |
Total Debt - Nominal Dollars | total_debt_nominal_dollars | number | 1187204000 545127000 1463119000 1590777000 1537341000 view top 100 | |
Estimated Actual Market Value of Taxable Property - Nominal Dollars | estimated_actual_market_value_of_taxable_property_nominal_dollars | number | 29018324000 29093406000 27290484000 21411468000 28814637000 view top 100 | |
Annual Debt Service Payments as a Percent of Total Expenditures | annual_debt_service_payments_as_a_percent_of_total_expenditures | number | 13.56 12.51 14.75 8.72 13.50 view top 100 | |
Employee Retirement System Funding Ratio | employee_retirement_system_funding_ratio | number | 84.72 82.57 72.83 93.12 79.11 view top 100 | |
Civilian Police Retirement System Funding Ratio | civilian_police_retirement_system_funding_ratio | number | 76.13 78.54 76.69 73.02 74.00 view top 100 | |
Firefighters Retirement System Funding Ratio | firefighters_retirement_system_funding_ratio | number | 78.94 82.31 78.54 93.42 92.07 view top 100 | |
Police Retirement System Funding Ratio | police_retirement_system_funding_ratio | number | 84.70 81.60 70.54 86.40 89.50 view top 100 | |
Annual Retirement System Payment - Unfunded Annual Required Contribution | annual_retirement_system_payment_unfunded_annual_required_contribution | number | 24864999.99 3400000.00 0 20469000.00 5199999.99 view top 100 | |
Annual Retirement System Payment Contribution | annual_retirement_system_payment_contribution | number | 64146000 37900000.00 42200000 47800000 57413000 view top 100 | |
City's Pension Contributions as a % of Net Operating Expenditures | city_s_pension_contributions_as_a_of_net_operating_expenditures | number | 5.51 5.46 5.60 5.17 5.49 view top 100 | |
City's Pension Contributions as a % of Net Operating Expenditures - Actuarial Required Contribution | city_s_pension_contributions_as_a_of_net_operating_expenditures_actuarial_required_contribution | number | 7.51 9.58 9.29 6.39 9.74 view top 100 | |
Other Post Employment Benefits OPEB Liability | other_post_employement_benefits_opeb | number | 50428000 25550000 54230000 43901000 39706000 view top 100 | |
Compensated Absences Liability | compensated_absences_liability | number | view top 100 | |
Other Post Employment Benefits (OPEB) and Compensated Absences Liabilities as a percent of net operating expenditures | other_post_employement_benefits_opeb_as_a_percent_of_net_operating_expenditures | number | 0.0392870034 0.0889802557 0.1023777645 0.0941846473 0.0772574017 view top 100 | |
Number of Non-Uniform Employees Per 1000 Population | number_of_non_uniform_employees_per_1000_population | number | 6.5233153333 6.6914690229 6.9110386647 7.385906489 6.6082350151 view top 100 | |
Number of Non-Uniform Employees | number_of_non_uniform_employees | number | 3108 3014 2924 3022 2954 view top 100 | |
Number of Uniform Police | number_of_uniform_police | number | 1446 1423 1346 1426 1366 view top 100 | |
Number of Uniform Police per 1000 Population | number_of_uniform_police_per_1000_population | text | 3.1700863114 2.9988280954 3.1296330365 3.0630511172 3.1574603188 view top 100 | |
FBI Survey of Uniform Police per 1000 Population High Range | fbi_survey_of_uniform_police_per_1000_population_high_range | text | 3.1 view top 100 | |
FBI Survey of Uniform Police per 1000 Population Low Range | fbi_survey_of_uniform_police_per_1000_population_low_range | text | 2.4 view top 100 | |
Number of Firefighters | number_of_firefighters | number | 935 933 934 879 897 view top 100 | |
Number of Firefighters per 1000 Population | number_of_firefighters_per_1000_population | number | 1.9925122152 2.0108854786 2.0394660704 2.0536457164 1.9093578587 view top 100 | |
NFPA Survey of Firefighters per 1000 Population High Range | nfpa_survey_of_firefighters_per_1000_population_high_range | number | 2.4 view top 100 | |
NFPA Survey of Firefighters per 1000 Population Low Range | nfpa_survey_of_firefighters_per_1000_population_low_range | number | 1.7 view top 100 |