Current Employment Statistics (CES)
State of California
@usgov.ca_gov_current_employment_statistics_ces_5540b
State of California
@usgov.ca_gov_current_employment_statistics_ces_5540b
CREATE TABLE ces_1990_2001_monthly (
"area_type" VARCHAR,
"area_name" VARCHAR,
"year" BIGINT,
"month" VARCHAR,
"date" TIMESTAMP,
"series_code" BIGINT,
"industry_title" VARCHAR,
"seasonally_adjusted_y_n" VARCHAR,
"current_employment" BIGINT,
"benchmark" BIGINT
);
CREATE TABLE ces_2002_2013_monthly (
"area_type" VARCHAR,
"area_name" VARCHAR,
"year" BIGINT,
"month" VARCHAR,
"date" TIMESTAMP,
"series_code" BIGINT,
"industry_title" VARCHAR,
"seasonally_adjusted_y_n" VARCHAR,
"current_employment" BIGINT,
"benchmark" BIGINT
);
CREATE TABLE data_dictionary_ces_1990_2001_monthly (
"column" VARCHAR,
"type" VARCHAR,
"label" VARCHAR,
"description" VARCHAR
);
CREATE TABLE data_dictionary_ces_2002_2013_monthly (
"column" VARCHAR,
"type" VARCHAR,
"label" VARCHAR,
"description" VARCHAR
);
CREATE TABLE data_dictionary_ces_2014_2025_monthly (
"column" VARCHAR,
"type" VARCHAR,
"label" VARCHAR,
"description" VARCHAR
);
Anyone who has the link will be able to view this.