Caltrans COVID-19 Leave Tracking by US Government | Healthcare

About this Dataset

Caltrans COVID-19 Leave Tracking

This dataset includes daily submissions for all districts and programs for teleworking and numbers and COVID related absences in the department. COVID absentee numbers are submitted daily while telework numbers are submitted on Monday and Wednesday.
Organization: State of California
Last updated: 2021-07-23T12:38:31.728705
Tags: california-department-of-transportation, california-state-transportation-agency, caltrans, caopendata, coronavirus, covid, covid-19, covid19

Tables

COVID-19 Caltrans Leave Tracking

@usgov.ca_gov_caltrans_covid_19_leave_tracking.covid_19_caltrans_leave_tracking

407.39 KB
14263 rows
31 columns


CREATE TABLE covid_19_caltrans_leave_tracking (
  "district_number" VARCHAR,
  "division" VARCHAR,
  "n__of_employees_working_at_office" VARCHAR,
  "n__of_field_personnel_at_normal_work_location" VARCHAR,
  "n__of_employees_teleworking" VARCHAR,
  "n__of_employees_off_for_other_reasons" VARCHAR,
  "n__of_field_employees_off_for_other_reasons" VARCHAR,
  "n__of_field_employees_teleworking" VARCHAR,
  "n__of_field_employees_on_rdo" VARCHAR,
  "n__absent_due_to_building_closure_not_teleworking" VARCHAR,
  "number_of_employees_on_rdo" VARCHAR,
  "working_as_contact_tracers" VARCHAR,
  "office_national_guard" VARCHAR,
  "field_national_guard" VARCHAR,
  "field_ee_contact_tracing" VARCHAR,
  "total_employees" DOUBLE,
  "total_employees_working" DOUBLE,
  "total_office_employees" DOUBLE,
  "total_office_employees_working" DOUBLE,
  "n__of_total_teleworking" VARCHAR,
  "n__office_workers_teleworking" VARCHAR,
  "date" TIMESTAMP,
  "submitter_name" VARCHAR,
  "submitter_email" VARCHAR,
  "created" VARCHAR,
  "illness_or_corona_related_issue" VARCHAR,
  "n__that_have_self_disclosed_coronavirus_illness" VARCHAR,
  "n__that_are_self_monitoring_and_or_quaratining" VARCHAR,
  "n__that_have_self_disclosed_absence" VARCHAR,
  "n__of_employees_using_empsl" VARCHAR,
  "n__of_employees_using_e_fmla" VARCHAR
);

COVID-19 Caltrans Leave Tracking Data Dictionary

@usgov.ca_gov_caltrans_covid_19_leave_tracking.covid_19_caltrans_leave_tracking_data_dictionary

22.68 KB
28 rows
32 columns


CREATE TABLE covid_19_caltrans_leave_tracking_data_dictionary (
  "system_name" VARCHAR,
  "table_name" VARCHAR,
  "field_name_column_name" VARCHAR,
  "field_alias" VARCHAR,
  "field_description" VARCHAR,
  "field_description_authority" VARCHAR,
  "confidential" VARCHAR,
  "sensitive" VARCHAR,
  "pii" VARCHAR,
  "pci" VARCHAR,
  "field_type" VARCHAR,
  "field_length" DOUBLE,
  "field_precision" DOUBLE,
  "data_class" VARCHAR,
  "field_units" VARCHAR,
  "domain_type" VARCHAR,
  "default_value" VARCHAR,
  "example_value" VARCHAR,
  "input_mask" VARCHAR,
  "allowable_min_value" BIGINT,
  "allowable_max_value" VARCHAR,
  "expected_min_value" VARCHAR,
  "expected_max_value" VARCHAR,
  "required" VARCHAR,
  "unique" VARCHAR,
  "indexed" VARCHAR,
  "primary_key" VARCHAR,
  "foreign_key" VARCHAR,
  "data_entry_type" VARCHAR,
  "source_system" VARCHAR,
  "usage_notes" VARCHAR,
  "business_term" VARCHAR
);

COVID-19 Caltrans Leave Tracking Metadata

@usgov.ca_gov_caltrans_covid_19_leave_tracking.covid_19_caltrans_leave_tracking_metadata

24.13 KB
1 row
32 columns


CREATE TABLE covid_19_caltrans_leave_tracking_metadata (
  "dataset_name" VARCHAR,
  "description" VARCHAR,
  "methodology" VARCHAR,
  "keywords" VARCHAR,
  "topic" VARCHAR,
  "publisher_organization" VARCHAR,
  "place" VARCHAR,
  "frequency" VARCHAR,
  "creation_date" TIMESTAMP,
  "last_update" TIMESTAMP,
  "status" VARCHAR,
  "temporal_coverage_begin" TIMESTAMP,
  "temporal_coverage_end" TIMESTAMP,
  "data_dictionary" VARCHAR,
  "data_dictionary_type" VARCHAR,
  "contact_organization" VARCHAR,
  "contact_position" VARCHAR,
  "contact_name" VARCHAR,
  "contact_email" VARCHAR,
  "public_access_level" VARCHAR,
  "access_constraints" VARCHAR,
  "use_constraints" VARCHAR,
  "data_life_span" VARCHAR,
  "caltrans_link" VARCHAR,
  "web_service_link" VARCHAR,
  "data_standard" VARCHAR,
  "notes" VARCHAR,
  "gis_theme" VARCHAR,
  "gis_horiz_accuracy" VARCHAR,
  "gis_vert_accuracy" VARCHAR,
  "gis_coordinate_system_epsg" VARCHAR,
  "gis_vert_datum_epsg" VARCHAR
);