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.728712
Tags: california-department-of-transportation, california-state-transportation-agency, caltrans, caopendata, coronavirus, covid, covid-19, covid19

Tables

COVID-19 Caltrans Leave Tracking Data Dictionary

@usgov.ca_gov_caltrans_covid_19_leave_tracking.covid_19_caltrans_leave_tracking_data_dictionary

23.22 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 NAME (Column Name),
  "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.71 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
);