2002-03 to 2021-22 City Financial Transactions Report - Expenditures, for the finance application.
This dataset has the following 13 columns:
| Column Name | API Column Name | Data Type | Sample Values |
|---|---|---|---|
| Entity Name | entity_name | text | San Francisco Agoura Hills Alameda Albany Alhambra view top 100 |
| Fiscal Year | fiscal_year | number | 2017 2022 2021 2020 2019 view top 100 |
| County | county | text | Los Angeles Orange Riverside San Bernardino San Mateo view top 100 |
| Field Name | form_table | text | LOSS_DISP_CAP_ASSET INT_EXP OTHR_OP_EXP OTHR_NONOP_EXP DEPR_AMORT_EXP view top 100 |
| Type | type | text | Expenditures view top 100 |
| Category | category | text | Public Safety Health Hospital Enterprise Fund Culture and Leisure Transportation view top 100 |
| Subcategory 1 | subcategory_1 | text | Operating Expenses Public Safety Nonoperating Expenses Health Culture and Leisure view top 100 |
| Subcategory 2 | subcategory_2 | text | Public Safety Health Culture and Leisure Transportation Community Development view top 100 |
| Line Description | line_description | text | Hospitals and Sanitariums_Total Expenditures Probation_Total Expenditures Housing_Total Expenditures District Attorney - Prosecution_Total Expenditures Ports and Harbors_Total Expenditures view top 100 |
| Value | value | number | 0 5000 10000 25000 100000 view top 100 |
| City, State, Zip | city_state_zip | text | Morro Bay, CA 93442 Ross, CA 94957 Lakewood, CA 90712 San Juan Capistrano, CA 92675 La Mirada, CA 90638 view top 100 |
| Estimated Population | estimated_population | text | 427 7772 7786 2016 440 view top 100 |
| Row Number | row_number | number | 2 3 4 5 6 view top 100 |