Name: CARES Act Data
Creator: US Government
License: http://www.opendefinition.org/licenses/cc-by

About this Dataset

CARES Act Data

Cares data
Organization: State of Oklahoma
Last updated: 2022-03-30T23:11:23.322033

Tables

Cares Act

@usgov.state_of_oklahoma_cares_act_data.cares_act

28 KB
1312 rows
8 columns


CREATE TABLE cares_act (
  "as_of_date" TIMESTAMP,
  "agency" VARCHAR,
  "program_code" VARCHAR,
  "account" BIGINT,
  "department_id" VARCHAR,
  "account_descr" VARCHAR,
  "fiscal_year" BIGINT,
  "n__posted_amount" VARCHAR
);

04.04.2022 - Class 490 CARES Expenses

@usgov.state_of_oklahoma_cares_act_data.n_04_04_2022_class_490_cares_expenses

34.11 KB
1358 rows
19 columns


CREATE TABLE n_04_04_2022_class_490_cares_expenses (
  "as_of_date" TIMESTAMP,
  "agency" VARCHAR,
  "program_code" VARCHAR,
  "account" DOUBLE,
  "department_id" VARCHAR,
  "account_descr" VARCHAR,
  "fiscal_year" DOUBLE,
  "n__posted_amount" VARCHAR,
  "unnamed_8" VARCHAR,
  "unnamed_9" VARCHAR,
  "unnamed_10" VARCHAR,
  "unnamed_11" VARCHAR,
  "unnamed_12" VARCHAR,
  "unnamed_13" VARCHAR,
  "unnamed_14" VARCHAR,
  "unnamed_15" VARCHAR,
  "unnamed_16" VARCHAR,
  "unnamed_17" VARCHAR,
  "unnamed_18" VARCHAR
);

04.20.2022 - Class 490 CARES Expenses

@usgov.state_of_oklahoma_cares_act_data.n_04_20_2022_class_490_cares_expenses

34.45 KB
1377 rows
19 columns


CREATE TABLE n_04_20_2022_class_490_cares_expenses (
  "as_of_date" TIMESTAMP,
  "agency" VARCHAR,
  "program_code" VARCHAR,
  "account" DOUBLE,
  "department_id" VARCHAR,
  "account_descr" VARCHAR,
  "fiscal_year" DOUBLE,
  "n__posted_amount" VARCHAR,
  "unnamed_8" VARCHAR,
  "unnamed_9" VARCHAR,
  "unnamed_10" VARCHAR,
  "unnamed_11" VARCHAR,
  "unnamed_12" VARCHAR,
  "unnamed_13" VARCHAR,
  "unnamed_14" VARCHAR,
  "unnamed_15" VARCHAR,
  "unnamed_16" VARCHAR,
  "unnamed_17" VARCHAR,
  "unnamed_18" VARCHAR
);