About this Dataset

NCDC Hourly Global Surface Variables-Selected Subset

Holds hourly surface temperature data from weather stations across the globe, and an important source of temperature data for temperature-health studies.
Organization: State of California
Last updated: 2021-09-08T16:15:46.383515
Tags: californa, climate, government-agency, temperature

Tables

Sacramento Airport Surface Temperatures

@usgov.ca_gov_ncdc_hourly_global_surface_variables_selected_subset.sacramento_airport_surface_temperatures

124 kB
10,618 rows
10 columns

CREATE TABLE sacramento_airport_surface_temperatures (
  "station" BIGINT,
  "date" TIMESTAMP,
  "source" BIGINT,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "elevation" DOUBLE,
  "tmp" BIGINT,
  "tmp_qccode" VARCHAR,
  "dew" BIGINT,
  "dew_qccode" VARCHAR
);