Baselight

Department Of Water Resources COVID-19 Data

State of California

@usgov.ca_gov_department_of_water_resources_covid_19_data_56cec

Loading...
Loading...

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 Positive Cases

@usgov.ca_gov_department_of_water_resources_covid_19_data_56cec.department_of_water_resources_covid_19_positive_cases
  • 5.09 KB
  • 16 rows
  • 7 columns
Loading...

CREATE TABLE department_of_water_resources_covid_19_positive_cases (
  "dwr_covid_19_positive_test_information" VARCHAR,
  "unnamed_1" VARCHAR,
  "unnamed_2" VARCHAR,
  "unnamed_3" VARCHAR,
  "unnamed_4" VARCHAR,
  "unnamed_5" VARCHAR,
  "unnamed_6" VARCHAR
);

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.26 KB
  • 21 rows
  • 9 columns
Loading...

CREATE TABLE department_of_water_resources_covid_19_absenteeism_report (
  "date" VARCHAR,
  "amount_of_telework_1tel_hours" DOUBLE,
  "number_of_employees_using_1tel" BIGINT,
  "amount_of_hours_for_pay_1hp1" DOUBLE,
  "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.07 KB
  • 16 rows
  • 7 columns
Loading...

CREATE TABLE department_of_water_resources_covid_19_impacts_divisio_172858e2 (
  "n__transparency_info_for_covid_19_impacts_to_dwr_iwm_operations" VARCHAR,
  "unnamed_1" VARCHAR,
  "unnamed_2" VARCHAR,
  "unnamed_3" VARCHAR,
  "unnamed_4" VARCHAR,
  "unnamed_5" VARCHAR,
  "unnamed_6" VARCHAR
);

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
  • 9.78 KB
  • 23 rows
  • 10 columns
Loading...

CREATE TABLE department_of_water_resources_covid_19_absenteeism_rep_f7a7d7e5 (
  "date" VARCHAR,
  "amount_of_telework_1tel_hours" DOUBLE,
  "number_of_employees_using_1tel" DOUBLE,
  "amount_of_hours_for_pay_1hp1" DOUBLE,
  "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
);

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.28 KB
  • 23 rows
  • 10 columns
Loading...

CREATE TABLE department_of_water_resources_covid_19_absenteeism_rep_4c061c75 (
  "date" VARCHAR,
  "amount_of_telework_1tel_hours" VARCHAR,
  "number_of_employees_using_1tel" VARCHAR,
  "amount_of_hours_for_pay_1hp1" VARCHAR,
  "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
);

Share link

Anyone who has the link will be able to view this.