Dataset: City Budget And Actual Expenditures

About this Dataset

City Budget And Actual Expenditures

The budget and actual expenditures self-reported by each city via their yearly budget forms filed with the Department of Management. Actual expenditure data lags budget expenditures by a couple of fiscal years.
Organization: State of Iowa
Last updated: 2023-01-20T00:03:06.065073
Tags: actual, budget, city

Tables

Table 1

@usgov.state_of_iowa_city_budget_and_actual_expenditures.table_1

4.36 MB
179310 rows
11 columns


CREATE TABLE table_1 (
  "record_key" VARCHAR,
  "fiscal_year" BIGINT,
  "county_code" BIGINT,
  "county" VARCHAR,
  "gnis_feature_id" BIGINT,
  "city_code" VARCHAR,
  "city_name" VARCHAR,
  "expenditure_program" VARCHAR,
  "budget" BIGINT,
  "actual" DOUBLE,
  "primary_city_coordinates" VARCHAR
);