City of Kansas City, Mo.

Close
Author
Eric Roche
Description
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
Category
Finance
Tags
ftms, financial trends monitoring system, financial, finance, money, expenditures, financial trends, trends, tax, taxes, revenue, revenues, expenditures by category, public safety, public safety expenditures, inflation, fee, fee revenue, tax revenue, per capita, retirement system, pension, benefits, fringe, opeb, post employment benefits, earnings tax, sales tax, property tax, business license, business, historical data, finances, governance, finance and governance, kcstat
Rating
Current value: 0 out of 5
Data Provided By
City of Kansas City, MO Annual Financial Trends Monitoring System Report
Source Link
https://kcstat.kcmo.org/Finance/2013-FTMS-7-29-14-Revised/n7p4-kkha
License
Public Domain
This view cannot be displayed
This view is currently private. You can preview it, but you will need to make it public before people will be able to see it.
Size
  • 500x425

  • 760x646

  • 950x808

Custom Size

425x425 is the minimum size

The Socrata Open Data API (SODA) provides programmatic access to this dataset including the ability to filter, query, and aggregate data. For more more information, view the API docs for this dataset or visit our developer portal

API Endpoint:

Field Names:

Fiscal Year
calendar_year
Fiscal Year Text Label
fiscal_year_text_label
Time Stamp
time_stamp
Population (used for per capita calculations)
population_used_for_per_capita_calculations
Price Index (For Inflation Calculation)
price_index_for_inflation_calculation
Commercial Properties Taxable Real Property Market Value Per Capita- Real Dollars
commercial_properties_taxable_real_property_market_value_per_capita_real_dollars
Residential Properties Taxable Real Property Market Value Per Capita- Real Dollars
residential_properties_taxable_real_property_market_value_per_capita_real_dollars
Commercial Building Permit Valuation - Real Dollars
commercial_building_permit_valuation_real_dollars
Residential Building Permit Valuation - Real Dollars
residential_building_permit_valuation_real_dollars
Revenue - Structural Balance - General, Special Revenue, and Capital Funds - Nominal Dollars
structural_balance_revenue_general_special_revenue_and_capital_funds_real_dollars
Expenditures - Structural Balance - General, Special Revenue, and Capital Funds - Nominal Dollars
structural_balance_expenditures_general_special_revenue_and_capital_funds_real_dollars
General Fund Unreserved Fund Balance
general_fund_unreserved_fund_balance
General Fund Unreserved Fund Balance - Council Policy
general_fund_unreserved_fund_balance_council_policy
Special Revenue and Capital Fund - Unreserved Fund Balance
special_revenue_and_capital_fund_unreserved_fund_balance
Operating Surplus/Deficit
operating_surplus_deficit
Liquidity Ratio
liquidity_ratio
Gross Operating Revenues
gross_operating_revenues
Gross Operating Revenue After (net) Redirections
gross_operating_revenue_after_net_redirections
Real Operating Revenue Per Capita - Real Dollars
real_operating_revenue_per_capita_real_dollars
Real Operating Revenue After (net) Redirections Per Capita - Real Dollars
real_operating_revenue_after_net_redirections_per_capita_real_dollars
General Fund Revenue - Nominal Dollars
general_fund_revenue_nominal_dollars
Special Revenue and Capital Improvement Revenue
special_revenue_and_capital_improvement_revenue
Dedicated Revenue as a Percent of Total Revenues
dedicated_revenue_as_a_percent_of_total_revenues
Percent of Total Revenue with a Renewal Requirement
percent_of_total_revenue_with_a_renewal_requirement
Earning and Profits Tax Revenue -Nominal Dollars
earning_and_profits_tax_revenue_nominal_dollars
Earning and Profits Tax Revenue Redirections -Nominal Dollars
earning_and_profits_tax_revenue_redirections_nominal_dollars
Earning and Profits Tax After (net) Redirections -Nominal Dollars
earning_and_profits_tax_after_net_redirections_nominal_dollars
Earning and Profits Tax Revenue Per Capita, Before Redirections - In Real Dollars
earning_and_profits_tax_revenue_per_capita_before_redirections_in_real_dollars
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
Sales and Use Tax Revenue -Nominal Dollars
sales_and_use_tax_revenue_nominal_dollars
Sales and Use Tax Revenue Redirections -Nominal Dollars
sales_and_use_tax_revenue_redirections_nominal_dollars
Sales and Use Tax After (net) Redirections -Nominal Dollars
sales_and_use_tax_after_net_redirections_nominal_dollars
Sales and Use Tax Revenue Per Capita, Before Redirections - In Real Dollars
sales_and_use_tax_revenue_per_capita_before_redirections_in_real_dollars
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
Property Tax Revenue -Nominal Dollars
property_tax_revenue_nominal_dollars
Property Tax Revenue Redirections -Nominal Dollars
property_tax_revenue_redirections_nominal_dollars
Property Tax After (net) Redirections -Nominal Dollars
property_tax_after_net_redirections_nominal_dollars
Property Tax Revenue Per Capita, After Redirections - In Real Dollars
property_tax_revenue_per_capita_after_redirections_in_real_dollars
Property Tax Revenue Per Capita, Before Redirections - In Real Dollars
property_tax_revenue_per_capita_before_redirections_in_real_dollars
Utility Franchise Fee Revenue -Nominal Dollars
utility_franchise_fee_revenue_nominal_dollars
Utility Franchise Fee Revenue Redirections -Nominal Dollars
utility_franchise_fee_revenue_redirections_nominal_dollars
Utility Franchise Fee After (net) Redirections -Nominal Dollars
utility_franchise_fee_after_net_redirections_nominal_dollars
Utility Franchise Fee Revenue Per Capita, Before Redirections - In Real Dollars
utility_franchise_fee_revenue_per_capita_before_redirections_in_real_dollars
Utility Franchise Fee Revenue Per Capita, After (net) Redirections - In Real Dollars
utility_franchise_fee_revenue_per_capita_after_net_redirections_in_real_dollars
Tourism & Leisure Tax and Fee Revenue -Nominal Dollars
tourism_leisure_tax_and_fee_revenue_nominal_dollars
Tourism & Leisure Tax and Fee Revenue Redirections -Nominal Dollars
tourism_leisure_tax_and_fee_revenue_redirections_nominal_dollars
Tourism & Leisure Tax and Fee After (net) Redirections -Nominal Dollars
tourism_leisure_tax_and_fee_after_net_redirections_nominal_dollars
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
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
Business License Tax and Fee Revenue - Nominal Dollars
business_license_tax_and_fee_revenue_nominal_dollars
Business License Tax and Fee Revenue Per Capita - In Real Dollars
business_license_tax_and_fee_revenue_per_capita_in_real_dollars
Service Charges Revenue - Nominal Dollars
service_charges_revenue_nominal_dollars
Service Charges as a Percent of Total Revenue
service_charges_as_a_percent_of_total_revenue
Intergovernmental Revenue - Nominal Dollars
intergovernmental_revenue_nominal_dollars
Intergovernmental Revenue as a Percent of Total Revenue
intergovernmental_revenue_as_a_percent_of_total_revenue
Operating Expenditures
operating_expenditures
Expenditures Per Capita -Real Dollars
expenditures_per_capita_real_dollars
Expenditures on Public Safety - Nominal Dollars
expenditures_on_public_safety_nominal_dollars
Expenditures on Public Infrastructure - Nominal Dollars
expenditures_on_public_infrastructure_nominal_dollars
Expenditures on Neighborhood Livability - Nominal Dollars
expenditures_on_neighborhood_livability_nominal_dollars
Expenditures on Healthy Community - Nominal Dollars
expenditures_on_healthy_community_nominal_dollars
Expenditures on Governance - Nominal Dollars
expenditures_on_governance_nominal_dollars
Expenditures on Economic Growth - Nominal Dollars
expenditures_on_economic_growth_nominal_dollars
Expenditures on Public Safety Per Capita - In Real Dollars
expenditures_on_public_safety_per_capita_in_real_dollars
Expenditures on Public Infrastructure Per Capita - Real Dollars
expenditures_on_public_infrastructure_per_capita_real_dollars
Expenditures on Neighborhood Livability Per Capita - Real Dollars
expenditures_on_neighborhood_livability_per_capita_real_dollars
Expenditures on Healthy Community Per Capita - Real Dollars
expenditures_on_healthy_community_per_capita_real_dollars
Expenditures on Governance Per Capita - Real Dollars
expenditures_on_governance_per_capita_real_dollars
Expenditures on Economic Growth Per Capita - Real Dollars
expenditures_on_economic_growth_per_capita_real_dollars
Non Public Safety Expenditures Per Capita - In Real Dollars
non_public_safety_expenditures_per_capita_in_real_dollars
Salaries and Benefits Expenditure - Nominal Dollars
salaries_and_benefits_expenditure_nominal_dollars
Operating Expenditures - Nominal Dollars
operating_expenditures_nominal_dollars
Salaries and Benefits as a Percent of Operating Expenditurse
salaries_and_benefits_as_a_percent_of_operating_expenditurse
Pension Expenditures
pension_expenditures
Pension Benefits as a Percent of Personnel Costs
pension_benefits_as_a_percent_of_personnel_costs
Health and Life Insurance Benefits Expenditures - Nominal Dollars
health_and_life_insurance_benefits_expenditures_nominal_dollars
Health and Life Insurance Benefits as a Percent of Personnel Costs
health_and_life_insurance_benefits_as_a_percent_of_personnel_costs
Total Fringe Benefits Expenditures - Nominal Dollars
total_fringe_benefits_expenditures_nominal_dollars
Total Fringe Benefits as a Percent of Operating Expenditures
total_fringe_benefits_as_a_percent_of_operating_expenditures
Salares (no benefits) Expenditures - Nominal Dollars
salares_no_benefits_expenditures_nominal_dollars
Capital Expenditures - Nominal Dollars
capital_expenditures_nominal_dollars
Total General Government Expenditures - Nominal Dollars
total_general_government_expenditures_nominal_dollars
Capital as a Percent of General Government Expenditures
capital_as_a_percent_of_general_government_expenditures
Outstanding Direct Debt as a Percent of Market Value of Taxable Property
outstanding_direct_debt_as_a_percent_of_market_value_of_taxable_property
Credit Industry Threshold
credit_industry_threshold
Total Debt - Nominal Dollars
total_debt_nominal_dollars
Estimated Actual Market Value of Taxable Property - Nominal Dollars
estimated_actual_market_value_of_taxable_property_nominal_dollars
Annual Debt Service Payments as a Percent of Total Expenditures
annual_debt_service_payments_as_a_percent_of_total_expenditures
Employee Retirement System Funding Ratio
employee_retirement_system_funding_ratio
Civilian Police Retirement System Funding Ratio
civilian_police_retirement_system_funding_ratio
Firefighters Retirement System Funding Ratio
firefighters_retirement_system_funding_ratio
Police Retirement System Funding Ratio
police_retirement_system_funding_ratio
Annual Retirement System Payment - Unfunded Annual Required Contribution
annual_retirement_system_payment_unfunded_annual_required_contribution
Annual Retirement System Payment Contribution
annual_retirement_system_payment_contribution
City's Pension Contributions as a % of Net Operating Expenditures
city_s_pension_contributions_as_a_of_net_operating_expenditures
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
Other Post Employment Benefits OPEB Liability
other_post_employement_benefits_opeb
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
Compensated Absences Liability
compensated_absences_liability
Number of Non-Uniform Employees Per 1000 Population
number_of_non_uniform_employees_per_1000_population
Number of Non-Uniform Employees
number_of_non_uniform_employees
Number of Uniform Police
number_of_uniform_police
Number of Uniform Police per 1000 Population
number_of_uniform_police_per_1000_population
FBI Survey of Uniform Police per 1000 Population High Range
fbi_survey_of_uniform_police_per_1000_population_high_range
FBI Survey of Uniform Police per 1000 Population Low Range
fbi_survey_of_uniform_police_per_1000_population_low_range
Number of Firefighters
number_of_firefighters
Number of Firefighters per 1000 Population
number_of_firefighters_per_1000_population
NFPA Survey of Firefighters per 1000 Population High Range
nfpa_survey_of_firefighters_per_1000_population_high_range
NFPA Survey of Firefighters per 1000 Population Low Range
nfpa_survey_of_firefighters_per_1000_population_low_range

Use OData to open the dataset in tools like Excel or Tableau. This provides a direct connection to the data that can be refreshed on-demand within the connected application.

Socrata OData documentation

Tableau users should select the OData v2 endpoint option.

OData V4 Endpoint:

OData V2 Endpoint:

You are viewing a mobile version of this dataset. To access the full dataset, tap here.