About this Dataset

Department Of Water Resources COVID-19 Data

Data regarding the impacts of COVID-19 at the Department of Water Resources. Data includes information on the number employees who have tested positive for COVID-19, statistics on employees work status (telecommuting, in office, time off), and the impacts to the Division of Integrated Watershed Management' programs.
Organization: State of California
Last updated: 2023-08-12T11:38:39.883270
Tags: california-department-of-water-resources, covid-19, dwr

Tables

Department Of Water Resources COVID-19 Absenteeism Report (September 2020)

@usgov.ca_gov_department_of_water_resources_covid_19_data_56cec.department_of_water_resources_covid_19_absenteeism_rep_4c061c75

9.51 kB
23 rows
10 columns

CREATE TABLE department_of_water_resources_covid_19_absenteeism_rep_4c061c75 (
  "date" VARCHAR,
  "amount_of_telework_1tel_hours" VARCHAR  -- Amount Of Telework (1TEL) Hours,
  "number_of_employees_using_1tel" VARCHAR,
  "amount_of_hours_for_pay_1hp1" VARCHAR  -- Amount Of Hours For Pay (1HP1),
  "number_of_employees_using_1hp1" VARCHAR,
  "amount_of_sick_leave_hours" VARCHAR,
  "number_of_employees_using_sick_leave" VARCHAR,
  "amount_of_ato_hours" VARCHAR,
  "number_of_employees_using_ato" VARCHAR,
  "unnamed_9" VARCHAR  -- Unnamed: 9
);

Department Of Water Resources COVID-19 Absenteeism Report (October 2020)

@usgov.ca_gov_department_of_water_resources_covid_19_data_56cec.department_of_water_resources_covid_19_absenteeism_rep_f7a7d7e5

10.01 kB
23 rows
10 columns

CREATE TABLE department_of_water_resources_covid_19_absenteeism_rep_f7a7d7e5 (
  "date" VARCHAR,
  "amount_of_telework_1tel_hours" DOUBLE  -- Amount Of Telework (1TEL) Hours,
  "number_of_employees_using_1tel" DOUBLE,
  "amount_of_hours_for_pay_1hp1" DOUBLE  -- Amount Of Hours For Pay (1HP1),
  "number_of_employees_using_1hp1" DOUBLE,
  "amount_of_sick_leave_hours" DOUBLE,
  "number_of_employees_using_sick_leave" DOUBLE,
  "amount_of_ato_hours" DOUBLE,
  "number_of_employees_using_ato" DOUBLE,
  "unnamed_9" VARCHAR  -- Unnamed: 9
);

Department Of Water Resources COVID-19 Absenteeism Report

@usgov.ca_gov_department_of_water_resources_covid_19_data_56cec.department_of_water_resources_covid_19_absenteeism_report

9.48 kB
21 rows
9 columns

CREATE TABLE department_of_water_resources_covid_19_absenteeism_report (
  "date" VARCHAR,
  "amount_of_telework_1tel_hours" DOUBLE  -- Amount Of Telework (1TEL) Hours,
  "number_of_employees_using_1tel" BIGINT,
  "amount_of_hours_for_pay_1hp1" DOUBLE  -- Amount Of Hours For Pay (1HP1),
  "number_of_employees_using_1hp1" BIGINT,
  "amount_of_sick_leave_hours" DOUBLE,
  "number_of_employees_using_sick_leave" BIGINT,
  "amount_of_ato_hours" DOUBLE,
  "number_of_employees_using_ato" BIGINT
);

Department Of Water Resources COVID-19 Impacts - Division Of Integrated Watershed Managment

@usgov.ca_gov_department_of_water_resources_covid_19_data_56cec.department_of_water_resources_covid_19_impacts_divisio_172858e2

9.29 kB
16 rows
7 columns

CREATE TABLE department_of_water_resources_covid_19_impacts_divisio_172858e2 (
  "n__transparency_info_for_covid_19_impacts_to_dwr_iwm_operations" VARCHAR  -- Data Transparency Info For COVID-19 Impacts To DWR:IWM Operations,
  "unnamed_1" VARCHAR  -- Unnamed: 1,
  "unnamed_2" VARCHAR  -- Unnamed: 2,
  "unnamed_3" VARCHAR  -- Unnamed: 3,
  "unnamed_4" VARCHAR  -- Unnamed: 4,
  "unnamed_5" VARCHAR  -- Unnamed: 5,
  "unnamed_6" VARCHAR  -- Unnamed: 6
);

Department Of Water Resources COVID-19 Positive Cases

@usgov.ca_gov_department_of_water_resources_covid_19_data_56cec.department_of_water_resources_covid_19_positive_cases

5.21 kB
16 rows
7 columns

CREATE TABLE department_of_water_resources_covid_19_positive_cases (
  "dwr_covid_19_positive_test_information" VARCHAR,
  "unnamed_1" VARCHAR  -- Unnamed: 1,
  "unnamed_2" VARCHAR  -- Unnamed: 2,
  "unnamed_3" VARCHAR  -- Unnamed: 3,
  "unnamed_4" VARCHAR  -- Unnamed: 4,
  "unnamed_5" VARCHAR  -- Unnamed: 5,
  "unnamed_6" VARCHAR  -- Unnamed: 6
);