The compiled ACFR data for fiscal year 2020. 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.
This dataset has the following 30 columns:
| Column Name | API Column Name | Data Type | Sample Values |
|---|---|---|---|
| CITY | city | text | La Pine Jefferson Cascade Locks Prairie City Troutdale view top 100 |
| Population | population | number | 160 9675 200 155 300 view top 100 |
| QCODE | qcode | number | 5 1 2 4 3 view top 100 |
| Region | region | number | 3 2 11 4 7 view top 100 |
| Property taxes | property_taxes | number | 0 660272 3 14243 1125216 view top 100 |
| Lodging taxes | lodging_taxes | number | 0 633 1249 4709 7886 view top 100 |
| SDC/CET | sdc_cet | number | 0 700 800 1381 2645 view top 100 |
| Franchise fees | franchise_fees | number | 639232 21346 74887 398043 2272728 view top 100 |
| Intergovernmental Revenues | intergovernmental_revenues | number | 0 537950 133753 3859787 107562 view top 100 |
| Grants, Gifts, Bequest | grants_gifts_bequest | number | 0 1000 1031026 55185 1624594 view top 100 |
| Property leases/rents/sales | property_leases_rents_sales | number | 0 816930 95298 487308 1150 view top 100 |
| Fines and Forfeitures | fines_and_forfeitures | number | 0 12822 17310 828444 65359 view top 100 |
| Licenses, Permits and fees | licenses_permits_and_fees | number | 0 965 6614203 8577 58279 view top 100 |
| Service Charges | service_charges | number | 0 100719 4915 353282 48048 view top 100 |
| Interest/Investment earnings | interest_investment_earnings | number | 0 118526 9350 1498447 73628 view top 100 |
| General Fund Revenue | general_fund_revenue | number | 43736 528361 66362280 63595153 4153610 view top 100 |
| Government Revenue | government_revenue | number | 82323686 48039 893323 17816043 25764 view top 100 |
| Unnamed Column | unnamed_column | text | view top 100 |
| General Gov. / Administration | general_gov_administration | number | 0 1739848 314968 112989 17316 view top 100 |
| Public safety | public_safety | number | 0 9413 772283 503755.67 799113 view top 100 |
| Highway/Street, Public Works | highway_street_public_works | number | 4726429 438400 871753 63362 57972 view top 100 |
| Culture, Parks, Recreation | culture_parks_recreation | number | 0 77212 73690 1121275 102379831 view top 100 |
| Community/Ecnomic Development | community_ecnomic_development | number | 0 6076887 1417 223571 32625 view top 100 |
| Debt (Total) | debt_total | number | 0 11340 343871 22556 59100 view top 100 |
| Debt (Principle) | debt_principle | number | 0 589282 3248557 222606 141875 view top 100 |
| Debt (Interest) | debt_interest | number | 0 95540 169980 447058 69185 view top 100 |
| Capital Outlays | capital_outlays | number | 0 772476 21482 37455 73302 view top 100 |
| General Fund Expenditures | general_fund_expenditures | number | 0 782704 7909898 1343150 33663030 view top 100 |
| Government Expeditures | government_expeditures | number | 0 775183 467525 7024786 4849722 view top 100 |
| FTE | fte | number | 71 0.7 3 3.3 4 view top 100 |