Budget Management - Daily Appropriations Report
Cook County of Illinois
@usgov.cook_county_of_illinois_budget_management_daily_approp_6027c47e
Cook County of Illinois
@usgov.cook_county_of_illinois_budget_management_daily_approp_6027c47e
Data from September 19, 2011. A daily report on the budgets of Cook County Government agencies and departments.
Organization: Cook County of Illinois
Last updated: 2020-11-10T16:57:48.489665
Tags: budget-management, daily-appropriations-report, inactive
CREATE TABLE table_1 (
"date" VARCHAR,
"report_grouping" VARCHAR,
"gl_period" BIGINT,
"fund" VARCHAR,
"fund_description" VARCHAR,
"bureau_chief" VARCHAR,
"department_number" DOUBLE,
"department_description" VARCHAR,
"business_unit_number" BIGINT,
"business_unit_description" VARCHAR,
"activity_code" DOUBLE,
"activity_description" VARCHAR,
"account_number" VARCHAR,
"account_description" VARCHAR,
"old_account_number" DOUBLE,
"approved_adopted_budget" BIGINT -- Approved & Adopted Budget,
"adjusted_budget" BIGINT,
"expenditures" BIGINT,
"encumbrances" BIGINT,
"total_expenditures_and_encumbrances" BIGINT,
"percent_of_adjusted_budget" BIGINT,
"budget_remaining" BIGINT,
"pre_encumbrances" BIGINT,
"total_expenditures_encumbrances_and_pre_encumbrances" BIGINT -- Total Expenditures, Encumbrances And Pre Encumbrances,
"percent_of_adjusted_budget_4310a2" BIGINT -- Percent (%) Of Adjusted Budget,
"n__budget_remaining" BIGINT -- Budget Remaining
);Anyone who has the link will be able to view this.