Outstanding Direct Debt as a Percent of Market Value of Taxable Properties

data.kcmo.org | Last Updated 5 Aug 2020

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

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

This dataset has the following 109 columns:

Column NameAPI Column NameData TypeDescriptionSample Values
Fiscal Yearcalendar_yearnumber
Time Stamptime_stampcalendar_dateThis column is for graphing
Fiscal Year Text Labelfiscal_year_text_labeltextThis label exist to use as an axis label.
Population (used for per capita calculations)population_used_for_per_capita_calculationsnumber
Price Index (For Inflation Calculation)price_index_for_inflation_calculationnumber
Commercial Properties Taxable Real Property Market Value Per Capita- Real Dollarscommercial_properties_taxable_real_property_market_value_per_capita_real_dollarsnumber
Residential Properties Taxable Real Property Market Value Per Capita- Real Dollarsresidential_properties_taxable_real_property_market_value_per_capita_real_dollarsnumber
Commercial Building Permit Valuation - Real Dollarscommercial_building_permit_valuation_real_dollarsnumber
Residential Building Permit Valuation - Real Dollarsresidential_building_permit_valuation_real_dollarsnumber
Revenue - Structural Balance - General, Special Revenue, and Capital Funds - Nominal Dollarsstructural_balance_revenue_general_special_revenue_and_capital_funds_real_dollarsnumber
Expenditures - Structural Balance - General, Special Revenue, and Capital Funds - Nominal Dollarsstructural_balance_expenditures_general_special_revenue_and_capital_funds_real_dollarsnumber
General Fund Unreserved Fund Balancegeneral_fund_unreserved_fund_balancenumber
General Fund Unreserved Fund Balance - Council Policygeneral_fund_unreserved_fund_balance_council_policynumber
Special Revenue and Capital Fund - Unreserved Fund Balancespecial_revenue_and_capital_fund_unreserved_fund_balancenumber
Operating Surplus/Deficitoperating_surplus_deficitnumber
Liquidity Ratioliquidity_rationumber
Gross Operating Revenuesgross_operating_revenuesnumber
Gross Operating Revenue After (net) Redirectionsgross_operating_revenue_after_net_redirectionsnumber
Real Operating Revenue Per Capita - Real Dollarsreal_operating_revenue_per_capita_real_dollarsnumber
Real Operating Revenue After (net) Redirections Per Capita - Real Dollarsreal_operating_revenue_after_net_redirections_per_capita_real_dollarsnumber
General Fund Revenue - Nominal Dollarsgeneral_fund_revenue_nominal_dollarsnumber
Special Revenue and Capital Improvement Revenuespecial_revenue_and_capital_improvement_revenuenumber
Dedicated Revenue as a Percent of Total Revenuesdedicated_revenue_as_a_percent_of_total_revenuesnumber
Percent of Total Revenue with a Renewal Requirementpercent_of_total_revenue_with_a_renewal_requirementnumber
Earning and Profits Tax Revenue -Nominal Dollarsearning_and_profits_tax_revenue_nominal_dollarsnumber
Earning and Profits Tax Revenue Redirections -Nominal Dollarsearning_and_profits_tax_revenue_redirections_nominal_dollarsnumber
Earning and Profits Tax After (net) Redirections -Nominal Dollarsearning_and_profits_tax_after_net_redirections_nominal_dollarsnumber
Earning and Profits Tax Revenue Per Capita, Before Redirections - In Real Dollarsearning_and_profits_tax_revenue_per_capita_before_redirections_in_real_dollarsnumber
Earning and Profits Tax Revenue Per Capita, After (net) Redirections - In Real Dollarsearning_and_profits_tax_revenue_per_capita_after_net_redirections_in_real_dollarsnumber
Sales and Use Tax Revenue -Nominal Dollarssales_and_use_tax_revenue_nominal_dollarsnumber
Sales and Use Tax Revenue Redirections -Nominal Dollarssales_and_use_tax_revenue_redirections_nominal_dollarsnumber
Sales and Use Tax After (net) Redirections -Nominal Dollarssales_and_use_tax_after_net_redirections_nominal_dollarsnumber
Sales and Use Tax Revenue Per Capita, Before Redirections - In Real Dollarssales_and_use_tax_revenue_per_capita_before_redirections_in_real_dollarsnumber
Sales and Use Tax Revenue Per Capita, After (net) Redirections - In Real Dollarssales_and_use_tax_revenue_per_capita_after_net_redirections_in_real_dollarsnumber
Property Tax Revenue -Nominal Dollarsproperty_tax_revenue_nominal_dollarsnumber
Property Tax Revenue Redirections -Nominal Dollarsproperty_tax_revenue_redirections_nominal_dollarsnumber
Property Tax After (net) Redirections -Nominal Dollarsproperty_tax_after_net_redirections_nominal_dollarsnumber
Property Tax Revenue Per Capita, After Redirections - In Real Dollarsproperty_tax_revenue_per_capita_after_redirections_in_real_dollarsnumber
Property Tax Revenue Per Capita, Before Redirections - In Real Dollarsproperty_tax_revenue_per_capita_before_redirections_in_real_dollarsnumber
Utility Franchise Fee Revenue -Nominal Dollarsutility_franchise_fee_revenue_nominal_dollarsnumber
Utility Franchise Fee Revenue Redirections -Nominal Dollarsutility_franchise_fee_revenue_redirections_nominal_dollarsnumber
Utility Franchise Fee After (net) Redirections -Nominal Dollarsutility_franchise_fee_after_net_redirections_nominal_dollarsnumber
Utility Franchise Fee Revenue Per Capita, Before Redirections - In Real Dollarsutility_franchise_fee_revenue_per_capita_before_redirections_in_real_dollarsnumber
Utility Franchise Fee Revenue Per Capita, After (net) Redirections - In Real Dollarsutility_franchise_fee_revenue_per_capita_after_net_redirections_in_real_dollarsnumber
Tourism & Leisure Tax and Fee Revenue -Nominal Dollarstourism_leisure_tax_and_fee_revenue_nominal_dollarsnumber
Tourism & Leisure Tax and Fee Revenue Redirections -Nominal Dollarstourism_leisure_tax_and_fee_revenue_redirections_nominal_dollarsnumber
Tourism & Leisure Tax and Fee After (net) Redirections -Nominal Dollarstourism_leisure_tax_and_fee_after_net_redirections_nominal_dollarsnumber
Tourism & Leisure Tax and Fee Revenue Per Capita, Before Redirections - In Real Dollarstourism_leisure_tax_and_fee_revenue_per_capita_before_redirections_in_real_dollarsnumber
Tourism & Leisure Tax and Fee Revenue Per Capita, After (net) Redirections - In Real Dollarstourism_leisure_tax_and_fee_revenue_per_capita_after_net_redirections_in_real_dollarsnumber
Business License Tax and Fee Revenue - Nominal Dollarsbusiness_license_tax_and_fee_revenue_nominal_dollarsnumber
Business License Tax and Fee Revenue Per Capita - In Real Dollarsbusiness_license_tax_and_fee_revenue_per_capita_in_real_dollarsnumber
Service Charges Revenue - Nominal Dollarsservice_charges_revenue_nominal_dollarsnumber
Service Charges as a Percent of Total Revenueservice_charges_as_a_percent_of_total_revenuenumber
Intergovernmental Revenue - Nominal Dollarsintergovernmental_revenue_nominal_dollarsnumber
Intergovernmental Revenue as a Percent of Total Revenueintergovernmental_revenue_as_a_percent_of_total_revenuenumber
Operating Expendituresoperating_expendituresnumber
Expenditures Per Capita -Real Dollarsexpenditures_per_capita_real_dollarsnumber
Expenditures on Public Safety - Nominal Dollarsexpenditures_on_public_safety_nominal_dollarsnumber
Expenditures on Public Infrastructure - Nominal Dollarsexpenditures_on_public_infrastructure_nominal_dollarsnumber
Expenditures on Neighborhood Livability - Nominal Dollarsexpenditures_on_neighborhood_livability_nominal_dollarsnumber
Expenditures on Healthy Community - Nominal Dollarsexpenditures_on_healthy_community_nominal_dollarsnumber
Expenditures on Governance - Nominal Dollarsexpenditures_on_governance_nominal_dollarsnumber
Expenditures on Economic Growth - Nominal Dollarsexpenditures_on_economic_growth_nominal_dollarsnumber
Expenditures on Public Safety Per Capita - In Real Dollarsexpenditures_on_public_safety_per_capita_in_real_dollarsnumber
Expenditures on Public Infrastructure Per Capita - Real Dollarsexpenditures_on_public_infrastructure_per_capita_real_dollarsnumber
Expenditures on Neighborhood Livability Per Capita - Real Dollarsexpenditures_on_neighborhood_livability_per_capita_real_dollarsnumber
Expenditures on Healthy Community Per Capita - Real Dollarsexpenditures_on_healthy_community_per_capita_real_dollarsnumber
Expenditures on Governance Per Capita - Real Dollarsexpenditures_on_governance_per_capita_real_dollarsnumber
Expenditures on Economic Growth Per Capita - Real Dollarsexpenditures_on_economic_growth_per_capita_real_dollarsnumber
Non Public Safety Expenditures Per Capita - In Real Dollarsnon_public_safety_expenditures_per_capita_in_real_dollarsnumber
Salaries and Benefits Expenditure - Nominal Dollarssalaries_and_benefits_expenditure_nominal_dollarsnumber
Operating Expenditures - Nominal Dollarsoperating_expenditures_nominal_dollarsnumber
Salaries and Benefits as a Percent of Operating Expenditursesalaries_and_benefits_as_a_percent_of_operating_expenditursenumber
Pension Expenditurespension_expendituresnumber
Pension Benefits as a Percent of Personnel Costspension_benefits_as_a_percent_of_personnel_costsnumber
Health and Life Insurance Benefits Expenditures - Nominal Dollarshealth_and_life_insurance_benefits_expenditures_nominal_dollarsnumber
Health and Life Insurance Benefits as a Percent of Personnel Costshealth_and_life_insurance_benefits_as_a_percent_of_personnel_costsnumber
Total Fringe Benefits Expenditures - Nominal Dollarstotal_fringe_benefits_expenditures_nominal_dollarsnumber
Total Fringe Benefits as a Percent of Operating Expenditurestotal_fringe_benefits_as_a_percent_of_operating_expendituresnumber
Salares (no benefits) Expenditures - Nominal Dollarssalares_no_benefits_expenditures_nominal_dollarsnumber
Capital Expenditures - Nominal Dollarscapital_expenditures_nominal_dollarsnumber
Total General Government Expenditures - Nominal Dollarstotal_general_government_expenditures_nominal_dollarsnumber
Capital as a Percent of General Government Expenditurescapital_as_a_percent_of_general_government_expendituresnumber
Outstanding Direct Debt as a Percent of Market Value of Taxable Propertyoutstanding_direct_debt_as_a_percent_of_market_value_of_taxable_propertynumber
Credit Industry Thresholdcredit_industry_thresholdnumber
Total Debt - Nominal Dollarstotal_debt_nominal_dollarsnumber
Estimated Actual Market Value of Taxable Property - Nominal Dollarsestimated_actual_market_value_of_taxable_property_nominal_dollarsnumber
Annual Debt Service Payments as a Percent of Total Expendituresannual_debt_service_payments_as_a_percent_of_total_expendituresnumber
Employee Retirement System Funding Ratioemployee_retirement_system_funding_rationumber
Civilian Police Retirement System Funding Ratiocivilian_police_retirement_system_funding_rationumber
Firefighters Retirement System Funding Ratiofirefighters_retirement_system_funding_rationumber
Police Retirement System Funding Ratiopolice_retirement_system_funding_rationumber
Annual Retirement System Payment - Unfunded Annual Required Contributionannual_retirement_system_payment_unfunded_annual_required_contributionnumber
Annual Retirement System Payment Contributionannual_retirement_system_payment_contributionnumber
City's Pension Contributions as a % of Net Operating Expenditurescity_s_pension_contributions_as_a_of_net_operating_expendituresnumber
City's Pension Contributions as a % of Net Operating Expenditures - Actuarial Required Contributioncity_s_pension_contributions_as_a_of_net_operating_expenditures_actuarial_required_contributionnumber
Other Post Employment Benefits OPEB Liabilityother_post_employement_benefits_opebnumber
Other Post Employment Benefits (OPEB) and Compensated Absences Liabilities as a percent of net operating expendituresother_post_employement_benefits_opeb_as_a_percent_of_net_operating_expendituresnumber
Compensated Absences Liabilitycompensated_absences_liabilitynumber
Number of Non-Uniform Employees Per 1000 Populationnumber_of_non_uniform_employees_per_1000_populationnumber
Number of Non-Uniform Employeesnumber_of_non_uniform_employeesnumber
Number of Uniform Policenumber_of_uniform_policenumber
Number of Uniform Police per 1000 Populationnumber_of_uniform_police_per_1000_populationtext
FBI Survey of Uniform Police per 1000 Population High Rangefbi_survey_of_uniform_police_per_1000_population_high_rangetext
FBI Survey of Uniform Police per 1000 Population Low Rangefbi_survey_of_uniform_police_per_1000_population_low_rangetext
Number of Firefightersnumber_of_firefightersnumber
Number of Firefighters per 1000 Populationnumber_of_firefighters_per_1000_populationnumber
NFPA Survey of Firefighters per 1000 Population High Rangenfpa_survey_of_firefighters_per_1000_population_high_rangenumber
NFPA Survey of Firefighters per 1000 Population Low Rangenfpa_survey_of_firefighters_per_1000_population_low_rangenumber