About this Dataset

ETP COVID-19 Contracts

ETP contracts affected by COVID-19 who fall in one of the Governor declared essential industries. The dataset includes data in 3 different ETP COVID-19 programs: (1) ETP COVID-19 Response (2) ETP COVID-19 Pilot and (3) ETP RESPOND COVID
Organization: State of California
Last updated: 2021-07-31T07:41:03.916588
Tags: covid, covid-19, employment-training-panel, etp

Tables

ETP COVID-19 Response Contracts

@usgov.ca_gov_etp_covid_19_contracts_a2c46.etp_covid_19_response_contracts

23.05 kB
574 rows
7 columns

CREATE TABLE etp_covid_19_response_contracts (
  "contract" VARCHAR  -- CONTRACT #,
  "company_name" VARCHAR,
  "status" VARCHAR,
  "contract_type" VARCHAR,
  "approved_amount" VARCHAR,
  "estimated_trainees" DOUBLE,
  "covid_response" VARCHAR
);

ETP RESPOND COVID Contracts

@usgov.ca_gov_etp_covid_19_contracts_a2c46.etp_respond_covid_contracts

5.63 kB
574 rows
7 columns

CREATE TABLE etp_respond_covid_contracts (
  "contract" VARCHAR  -- CONTRACT #,
  "company_name" VARCHAR,
  "status" VARCHAR,
  "contract_type" VARCHAR,
  "approved_amount" VARCHAR,
  "estimated_trainees" DOUBLE,
  "covid_respond" VARCHAR
);