kcmo/financial-trends-monitoring-system-data-btez-inz8
Icon for Socrata external plugin
 
Preview
  • financial_trends_monitoring_system_data
     
 
Readme
Updated almost 2 years ago
Indexed 4 hours ago

Financial Trends Monitoring System Data

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

Columns

NameSocrata field nameColumn name in sgr mountData typeDescription
Employee Retirement System Funding Ratioemployee_retirement_system_funding_ratioemployee_retirement_system_funding_ratioNumber
City's Pension Contributions as a % of Net Operating Expenditures - Actuarial Required Contributioncity_s_pension_contributions_as_a_of_net_operating_expenditures_actuarial_required_contributioncity_s_pension_contributions_as_a_of_net_operating_expendit_000Number
Credit Industry Thresholdcredit_industry_thresholdcredit_industry_thresholdNumber
Capital as a Percent of General Government Expenditurescapital_as_a_percent_of_general_government_expenditurescapital_as_a_percent_of_general_government_expendituresNumber
Pension Benefits as a Percent of Personnel Costspension_benefits_as_a_percent_of_personnel_costspension_benefits_as_a_percent_of_personnel_costsNumber
Civilian Police Retirement System Funding Ratiocivilian_police_retirement_system_funding_ratiocivilian_police_retirement_system_funding_ratioNumber
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_expendituresother_post_employement_benefits_opeb_as_a_percent_of_net_operatNumber
Firefighters Retirement System Funding Ratiofirefighters_retirement_system_funding_ratiofirefighters_retirement_system_funding_ratioNumber
Salaries and Benefits as a Percent of Operating Expenditursesalaries_and_benefits_as_a_percent_of_operating_expenditursesalaries_and_benefits_as_a_percent_of_operating_expenditurseNumber
Police Retirement System Funding Ratiopolice_retirement_system_funding_ratiopolice_retirement_system_funding_ratioNumber
Annual Debt Service Payments as a Percent of Total Expendituresannual_debt_service_payments_as_a_percent_of_total_expendituresannual_debt_service_payments_as_a_percent_of_total_expendituresNumber
Revenue - Structural Balance - General, Special Revenue, and Capital Funds - Nominal Dollarsstructural_balance_revenue_general_special_revenue_and_capital_funds_real_dollarsstructuralbalance_revenue_general_special_revenue_and_capitalNumber
Sales and Use Tax Revenue Per Capita, After (net) Redirections - In Real Dollarssales_and_use_tax_revenue_per_capita_after_net_redirections_in_real_dollarssalesand_use_tax_revenue_per_capita_after_net_redirections_inNumber
Price Index (For Inflation Calculation)price_index_for_inflation_calculationprice_index_for_inflation_calculationNumber
Gross Operating Revenue After (net) Redirectionsgross_operating_revenue_after_net_redirectionsgross_operating_revenue_after_net_redirectionsNumber
General Fund Unreserved Fund Balancegeneral_fund_unreserved_fund_balancegeneral_fund_unreserved_fund_balanceNumber
Earning and Profits Tax Revenue Per Capita, After (net) Redirections - In Real Dollarsearning_and_profits_tax_revenue_per_capita_after_net_redirections_in_real_dollarsearning_and_profits_tax_revenue_per_capita_after_net_redirectioNumber
Tourism & Leisure Tax and Fee After (net) Redirections -Nominal Dollarstourism_leisure_tax_and_fee_after_net_redirections_nominal_dollarstourism_leisure_tax_and_fee_after_net_redirections_nominal_dollNumber
Intergovernmental Revenue - Nominal Dollarsintergovernmental_revenue_nominal_dollarsintergovernmental_revenue_nominal_dollarsNumber
Percent of Total Revenue with a Renewal Requirementpercent_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_dollarsearning_and_profits_tax_revenue_nominal_dollarsNumber
Sales and Use Tax Revenue -Nominal Dollarssales_and_use_tax_revenue_nominal_dollarssales_and_use_tax_revenue_nominal_dollarsNumber
Outstanding Direct Debt as a Percent of Market Value of Taxable Propertyoutstanding_direct_debt_as_a_percent_of_market_value_of_taxable_propertyoutstanding_direct_debt_as_a_percent_of_market_value_of_taxableNumber
Property Tax Revenue Per Capita, After Redirections - In Real Dollarsproperty_tax_revenue_per_capita_after_redirections_in_real_dollarsproperty_tax_revenue_per_capita_after_redirections_in_real_dollNumber
Service Charges as a Percent of Total Revenueservice_charges_as_a_percent_of_total_revenueservice_charges_as_a_percent_of_total_revenueNumber
Total Fringe Benefits as a Percent of Operating Expenditurestotal_fringe_benefits_as_a_percent_of_operating_expenditurestotal_fringe_benefits_as_a_percent_of_operating_expendituresNumber
Service Charges Revenue - Nominal Dollarsservice_charges_revenue_nominal_dollarsservice_charges_revenue_nominal_dollarsNumber
FBI Survey of Uniform Police per 1000 Population High Rangefbi_survey_of_uniform_police_per_1000_population_high_rangefbi_survey_of_uniform_police_per_1000_population_high_rangeText
Pension Expenditurespension_expenditurespension_expendituresNumber
Salares (no benefits) Expenditures - Nominal Dollarssalares_no_benefits_expenditures_nominal_dollarssalares_no_benefits_expenditures_nominal_dollarsNumber
Intergovernmental Revenue as a Percent of Total Revenueintergovernmental_revenue_as_a_percent_of_total_revenueintergovernmental_revenue_as_a_percent_of_total_revenueNumber
Expenditures on Healthy Community - Nominal Dollarsexpenditures_on_healthy_community_nominal_dollarsexpenditures_on_healthy_community_nominal_dollarsNumber
Annual Retirement System Payment Contributionannual_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_expenditurescity_s_pension_contributions_as_a_of_net_operating_expendit_001Number
Other Post Employment Benefits OPEB Liabilityother_post_employement_benefits_opebother_post_employement_benefits_opebNumber
Number of Non-Uniform Employees Per 1000 Populationnumber_of_non_uniform_employees_per_1000_populationnumber_of_non_uniform_employees_per_1000_populationNumber
Number of Firefightersnumber_of_firefightersnumber_of_firefightersNumber
NFPA Survey of Firefighters per 1000 Population High Rangenfpa_survey_of_firefighters_per_1000_population_high_rangenfpa_survey_of_firefighters_per_1000_population_high_rangeNumber
Earning and Profits Tax Revenue Redirections -Nominal Dollarsearning_and_profits_tax_revenue_redirections_nominal_dollarsearning_and_profits_tax_revenue_redirections_nominal_dollarsNumber
Sales and Use Tax After (net) Redirections -Nominal Dollarssales_and_use_tax_after_net_redirections_nominal_dollarssales_and_use_tax_after_net_redirections_nominal_dollarsNumber
Expenditures - Structural Balance - General, Special Revenue, and Capital Funds - Nominal Dollarsstructural_balance_expenditures_general_special_revenue_and_capital_funds_real_dollarsstructural_balance_expenditures_general_special_revenue_and_capNumber
Population (used for per capita calculations)population_used_for_per_capita_calculationspopulation_used_for_per_capita_calculationsNumber
Time Stamptime_stamptime_stampCalendar dateThis column is for graphing
General Fund Unreserved Fund Balance - Council Policygeneral_fund_unreserved_fund_balance_council_policygeneral_fund_unreserved_fund_balance_council_policyNumber
Commercial Properties Taxable Real Property Market Value Per Capita- Real Dollarscommercial_properties_taxable_real_property_market_value_per_capita_real_dollarscommercial_properties_taxable_real_property_market_value_per_caNumber
Liquidity Ratioliquidity_ratioliquidity_ratioNumber
Health and Life Insurance Benefits as a Percent of Personnel Costshealth_and_life_insurance_benefits_as_a_percent_of_personnel_costshealth_and_life_insurance_benefits_as_a_percent_of_personnel_coNumber
Dedicated Revenue as a Percent of Total Revenuesdedicated_revenue_as_a_percent_of_total_revenuesdedicated_revenue_as_a_percent_of_total_revenuesNumber
Non Public Safety Expenditures Per Capita - In Real Dollarsnon_public_safety_expenditures_per_capita_in_real_dollarsnon_public_safety_expenditures_per_capita_in_real_dollarsNumber
Utility Franchise Fee After (net) Redirections -Nominal Dollarsutility_franchise_fee_after_net_redirections_nominal_dollarsutility_franchise_fee_after_net_redirections_nominal_dollarsNumber
Property Tax Revenue Per Capita, Before Redirections - In Real Dollarsproperty_tax_revenue_per_capita_before_redirections_in_real_dollarsproperty_tax_revenue_per_capita_before_redirections_in_real_dolNumber
Total General Government Expenditures - Nominal Dollarstotal_general_government_expenditures_nominal_dollarstotal_general_government_expenditures_nominal_dollarsNumber
Number of Non-Uniform Employeesnumber_of_non_uniform_employeesnumber_of_non_uniform_employeesNumber
Number of Uniform Police per 1000 Populationnumber_of_uniform_police_per_1000_populationnumber_of_uniform_police_per_1000_populationText
Number of Uniform Policenumber_of_uniform_policenumber_of_uniform_policeNumber
Number of Firefighters per 1000 Populationnumber_of_firefighters_per_1000_populationnumber_of_firefighters_per_1000_populationNumber
Fiscal Year Text Labelfiscal_year_text_labelfiscal_year_text_labelTextThis label exist to use as an axis label.
Real Operating Revenue Per Capita - Real Dollarsreal_operating_revenue_per_capita_real_dollarsreal_operating_revenue_per_capita_real_dollarsNumber
FBI Survey of Uniform Police per 1000 Population Low Rangefbi_survey_of_uniform_police_per_1000_population_low_rangefbi_survey_of_uniform_police_per_1000_population_low_rangeText
NFPA Survey of Firefighters per 1000 Population Low Rangenfpa_survey_of_firefighters_per_1000_population_low_rangenfpa_survey_of_firefighters_per_1000_population_low_rangeNumber
Fiscal Yearcalendar_yearcalendar_yearNumber
Expenditures on Economic Growth Per Capita - Real Dollarsexpenditures_on_economic_growth_per_capita_real_dollarsexpenditures_on_economic_growth_per_capita_real_dollarsNumber
Operating Expendituresoperating_expendituresoperating_expendituresNumber
Earning and Profits Tax Revenue Per Capita, Before Redirections - In Real Dollarsearning_and_profits_tax_revenue_per_capita_before_redirections_in_real_dollarsearningand_profits_tax_revenue_per_capita_before_redirectionsNumber
Utility Franchise Fee Revenue Per Capita, Before Redirections - In Real Dollarsutility_franchise_fee_revenue_per_capita_before_redirections_in_real_dollarsutility_franchise_fee_revenue_per_capita_before_redirections_inNumber
Total Debt - Nominal Dollarstotal_debt_nominal_dollarstotal_debt_nominal_dollarsNumber
Utility Franchise Fee Revenue Redirections -Nominal Dollarsutility_franchise_fee_revenue_redirections_nominal_dollarsutility_franchise_fee_revenue_redirections_nominal_dollarsNumber
Expenditures on Public Safety - Nominal Dollarsexpenditures_on_public_safety_nominal_dollarsexpenditures_on_public_safety_nominal_dollarsNumber
Operating Surplus/Deficitoperating_surplus_deficitoperating_surplus_deficitNumber
Tourism & Leisure Tax and Fee Revenue Per Capita, Before Redirections - In Real Dollarstourism_leisure_tax_and_fee_revenue_per_capita_before_redirections_in_real_dollarstourism_leisure_tax_and_fee_revenue_per_capita_before_redirectiNumber
Tourism & Leisure Tax and Fee Revenue -Nominal Dollarstourism_leisure_tax_and_fee_revenue_nominal_dollarstourism_leisure_tax_and_fee_revenue_nominal_dollarsNumber
Expenditures on Governance - Nominal Dollarsexpenditures_on_governance_nominal_dollarsexpenditures_on_governance_nominal_dollarsNumber
Sales and Use Tax Revenue Redirections -Nominal Dollarssales_and_use_tax_revenue_redirections_nominal_dollarssales_and_use_tax_revenue_redirections_nominal_dollarsNumber
Property Tax Revenue -Nominal Dollarsproperty_tax_revenue_nominal_dollarsproperty_tax_revenue_nominal_dollarsNumber
Earning and Profits Tax After (net) Redirections -Nominal Dollarsearning_and_profits_tax_after_net_redirections_nominal_dollarsearning_and_profits_tax_after_net_redirections_nominal_dollarsNumber
Utility Franchise Fee Revenue -Nominal Dollarsutility_franchise_fee_revenue_nominal_dollarsutility_franchise_fee_revenue_nominal_dollarsNumber
Health and Life Insurance Benefits Expenditures - Nominal Dollarshealth_and_life_insurance_benefits_expenditures_nominal_dollarshealth_and_life_insurance_benefits_expenditures_nominal_dollarsNumber
Operating Expenditures - Nominal Dollarsoperating_expenditures_nominal_dollarsoperating_expenditures_nominal_dollarsNumber
Expenditures on Healthy Community Per Capita - Real Dollarsexpenditures_on_healthy_community_per_capita_real_dollarsexpenditures_on_healthy_community_per_capita_real_dollarsNumber
Expenditures on Neighborhood Livability Per Capita - Real Dollarsexpenditures_on_neighborhood_livability_per_capita_real_dollarsexpenditures_on_neighborhood_livability_per_capita_real_dollarsNumber
Capital Expenditures - Nominal Dollarscapital_expenditures_nominal_dollarscapital_expenditures_nominal_dollarsNumber
Tourism & Leisure Tax and Fee Revenue Redirections -Nominal Dollarstourism_leisure_tax_and_fee_revenue_redirections_nominal_dollarstourism_leisure_tax_and_fee_revenue_redirections_nominal_dollarNumber
Business License Tax and Fee Revenue - Nominal Dollarsbusiness_license_tax_and_fee_revenue_nominal_dollarsbusiness_license_tax_and_fee_revenue_nominal_dollarsNumber
Compensated Absences Liabilitycompensated_absences_liabilitycompensated_absences_liabilityNumber
Expenditures on Public Infrastructure - Nominal Dollarsexpenditures_on_public_infrastructure_nominal_dollarsexpenditures_on_public_infrastructure_nominal_dollarsNumber
Property Tax After (net) Redirections -Nominal Dollarsproperty_tax_after_net_redirections_nominal_dollarsproperty_tax_after_net_redirections_nominal_dollarsNumber
Gross Operating Revenuesgross_operating_revenuesgross_operating_revenuesNumber
Expenditures on Economic Growth - Nominal Dollarsexpenditures_on_economic_growth_nominal_dollarsexpenditures_on_economic_growth_nominal_dollarsNumber
Utility Franchise Fee Revenue Per Capita, After (net) Redirections - In Real Dollarsutility_franchise_fee_revenue_per_capita_after_net_redirections_in_real_dollarsutility_franchise_fee_revenue_per_capita_after_net_redirectionsNumber
Special Revenue and Capital Fund - Unreserved Fund Balancespecial_revenue_and_capital_fund_unreserved_fund_balancespecial_revenue_and_capital_fund_unreserved_fund_balanceNumber
Residential Building Permit Valuation - Real Dollarsresidential_building_permit_valuation_real_dollarsresidential_building_permit_valuation_real_dollarsNumber
Commercial Building Permit Valuation - Real Dollarscommercial_building_permit_valuation_real_dollarscommercial_building_permit_valuation_real_dollarsNumber
Expenditures on Public Infrastructure Per Capita - Real Dollarsexpenditures_on_public_infrastructure_per_capita_real_dollarsexpenditures_on_public_infrastructure_per_capita_real_dollarsNumber
Estimated Actual Market Value of Taxable Property - Nominal Dollarsestimated_actual_market_value_of_taxable_property_nominal_dollarsestimated_actual_market_value_of_taxable_property_nominal_dollaNumber
Expenditures on Neighborhood Livability - Nominal Dollarsexpenditures_on_neighborhood_livability_nominal_dollarsexpenditures_on_neighborhood_livability_nominal_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_dollarstourism_leisure_tax_and_fee_revenue_per_capita_after_net_redireNumber
Expenditures Per Capita -Real Dollarsexpenditures_per_capita_real_dollarsexpenditures_per_capita_real_dollarsNumber
Sales and Use Tax Revenue Per Capita, Before Redirections - In Real Dollarssales_and_use_tax_revenue_per_capita_before_redirections_in_real_dollarssales_and_use_tax_revenue_per_capita_before_redirections_in_reaNumber
Expenditures on Public Safety Per Capita - In Real Dollarsexpenditures_on_public_safety_per_capita_in_real_dollarsexpenditures_on_public_safety_per_capita_in_real_dollarsNumber
Real Operating Revenue After (net) Redirections Per Capita - Real Dollarsreal_operating_revenue_after_net_redirections_per_capita_real_dollarsreal_operating_revenue_after_net_redirections_per_capita_real_dNumber
General Fund Revenue - Nominal Dollarsgeneral_fund_revenue_nominal_dollarsgeneral_fund_revenue_nominal_dollarsNumber
Salaries and Benefits Expenditure - Nominal Dollarssalaries_and_benefits_expenditure_nominal_dollarssalaries_and_benefits_expenditure_nominal_dollarsNumber
Special Revenue and Capital Improvement Revenuespecial_revenue_and_capital_improvement_revenuespecial_revenue_and_capital_improvement_revenueNumber
Total Fringe Benefits Expenditures - Nominal Dollarstotal_fringe_benefits_expenditures_nominal_dollarstotal_fringe_benefits_expenditures_nominal_dollarsNumber
Expenditures on Governance Per Capita - Real Dollarsexpenditures_on_governance_per_capita_real_dollarsexpenditures_on_governance_per_capita_real_dollarsNumber
Business License Tax and Fee Revenue Per Capita - In Real Dollarsbusiness_license_tax_and_fee_revenue_per_capita_in_real_dollarsbusiness_license_tax_and_fee_revenue_per_capita_in_real_dollarsNumber
Annual Retirement System Payment - Unfunded Annual Required Contributionannual_retirement_system_payment_unfunded_annual_required_contributionannual_retirement_system_payment_unfunded_annual_required_contrNumber
Property Tax Revenue Redirections -Nominal Dollarsproperty_tax_revenue_redirections_nominal_dollarsproperty_tax_revenue_redirections_nominal_dollarsNumber
Residential Properties Taxable Real Property Market Value Per Capita- Real Dollarsresidential_properties_taxable_real_property_market_value_per_capita_real_dollarsresidential_properties_taxable_real_property_market_value_per_cNumber