orcities/city-finances-certified-annual-financial-reports-squi-24mx
 
Readme
Updated over 2 years ago
Indexed 2 hours ago

City Finances: Certified Annual Financial Reports (CAFR) 2019

The compiled CAFR data for fiscal year 2018. Please note that due to differences in audit report styles and definitions, comparison between numbers should be done carefully. For example, public safety in one city may include fire, ambulance and police; where public safety in another city may only include police.

Columns

NameSocrata field nameColumn name in sgr mountData typeDescription
Cities:@computed_region_u39g_jjf9:@computed_region_u39g_jjf9Number
New Georeferenced Columnnew_georeferenced_columnnew_georeferenced_columnText
General Fund Expendituresgeneral_fund_expendituresgeneral_fund_expendituresNumber
Culture, Parks, Recreationculture_parks_recreationculture_parks_recreationNumber
Highway/Street, Public Workshighway_street_public_workshighway_street_public_worksNumber
Government Revenuegovernment_revenuegovernment_revenueNumber
MiscellaneousmiscellaneousmiscellaneousNumber
Licenses, Permits and feeslicenses_permits_and_feeslicenses_permits_and_feesNumber
Unnamed Columnunnamed_columnunnamed_columnText
Fines and Forfeituresfines_and_forfeituresfines_and_forfeituresNumber
Property leases/rents/salesproperty_leases_rents_salesproperty_leases_rents_salesNumber
Grants, Gifts, Bequestgrants_gifts_bequestgrants_gifts_bequestNumber
General Fund Revenuegeneral_fund_revenuegeneral_fund_revenueNumber
Franchise feesfranchise_feesfranchise_feesNumber
Property taxesproperty_taxesproperty_taxesNumber
POPULATIONpopulationpopulationNumber
Capital Outlayscapital_outlayscapital_outlaysNumber
Public safetypublic_safetypublic_safetyNumber
CitycitycityText
General Gov. / Administrationgeneral_gov_administrationgeneral_gov_administrationNumber
Lodging taxeslodging_taxeslodging_taxesNumber
REGIONregionregionNumber
New Georeferenced Column_1geocoded_column_1geocoded_column_1Point
Government Expedituresgovernment_expedituresgovernment_expedituresNumber
Debt Servicedebt_servicedebt_serviceNumber
Interest/Investment earningsinterest_investment_earningsinterest_investment_earningsNumber
Service Chargesservice_chargesservice_chargesNumber
Intergovernmental revenuesintergovernmental_revenuesintergovernmental_revenuesNumber
SDC/CETsdc_cetsdc_cetNumber
QCODEqcodeqcodeNumber
Counties:@computed_region_6i9h_2rt9:@computed_region_6i9h_2rt9Number
Community Developmentcommunity_developmentcommunity_developmentNumber