Consumer Price Index
Statistical measures of change in prices of consumer goods
@kaggle.bls_consumer_price_index
Statistical measures of change in prices of consumer goods
@kaggle.bls_consumer_price_index
CREATE TABLE cu_area (
"area_code" VARCHAR,
"area_name" VARCHAR,
"display_level" DOUBLE,
"selectable" VARCHAR,
"sort_sequence" DOUBLE
);
CREATE TABLE cu_base (
"base_code" VARCHAR,
"base_name" VARCHAR
);
CREATE TABLE cu_data_0_current (
"series_id" VARCHAR,
"year" BIGINT,
"period" VARCHAR,
"value" DOUBLE,
"footnote_codes" VARCHAR
);
CREATE TABLE cu_data_1_allitems (
"series_id" VARCHAR,
"year" BIGINT,
"period" VARCHAR,
"value" DOUBLE,
"footnote_codes" VARCHAR
);
CREATE TABLE cu_data_10_otherwest (
"series_id" VARCHAR,
"year" BIGINT,
"period" VARCHAR,
"value" DOUBLE,
"footnote_codes" VARCHAR
);
CREATE TABLE cu_data_11_usfoodbeverage (
"series_id" VARCHAR,
"year" BIGINT,
"period" VARCHAR,
"value" DOUBLE,
"footnote_codes" VARCHAR
);
CREATE TABLE cu_data_12_ushousing (
"series_id" VARCHAR,
"year" BIGINT,
"period" VARCHAR,
"value" DOUBLE,
"footnote_codes" VARCHAR
);
CREATE TABLE cu_data_13_usapparel (
"series_id" VARCHAR,
"year" BIGINT,
"period" VARCHAR,
"value" DOUBLE,
"footnote_codes" VARCHAR
);
CREATE TABLE cu_data_14_ustransportation (
"series_id" VARCHAR,
"year" BIGINT,
"period" VARCHAR,
"value" DOUBLE,
"footnote_codes" VARCHAR
);
CREATE TABLE cu_data_15_usmedical (
"series_id" VARCHAR,
"year" BIGINT,
"period" VARCHAR,
"value" DOUBLE,
"footnote_codes" VARCHAR
);
CREATE TABLE cu_data_16_usrecreation (
"series_id" VARCHAR,
"year" BIGINT,
"period" VARCHAR,
"value" DOUBLE,
"footnote_codes" VARCHAR
);
CREATE TABLE cu_data_17_useducationandcommunication (
"series_id" VARCHAR,
"year" BIGINT,
"period" VARCHAR,
"value" DOUBLE,
"footnote_codes" VARCHAR
);
CREATE TABLE cu_data_18_usothergoodsandservices (
"series_id" VARCHAR,
"year" BIGINT,
"period" VARCHAR,
"value" DOUBLE,
"footnote_codes" VARCHAR
);
CREATE TABLE cu_data_19_populationsize (
"series_id" VARCHAR,
"year" BIGINT,
"period" VARCHAR,
"value" DOUBLE,
"footnote_codes" VARCHAR
);
CREATE TABLE cu_data_2_summaries (
"series_id" VARCHAR,
"year" BIGINT,
"period" VARCHAR,
"value" DOUBLE,
"footnote_codes" VARCHAR
);
CREATE TABLE cu_data_20_uscommoditiesservicesspecial (
"series_id" VARCHAR,
"year" BIGINT,
"period" VARCHAR,
"value" DOUBLE,
"footnote_codes" VARCHAR
);
CREATE TABLE cu_data_3_asizenortheast (
"series_id" VARCHAR,
"year" BIGINT,
"period" VARCHAR,
"value" DOUBLE,
"footnote_codes" VARCHAR
);
CREATE TABLE cu_data_4_asizenorthcentral (
"series_id" VARCHAR,
"year" BIGINT,
"period" VARCHAR,
"value" DOUBLE,
"footnote_codes" VARCHAR
);
CREATE TABLE cu_data_5_asizesouth (
"series_id" VARCHAR,
"year" BIGINT,
"period" VARCHAR,
"value" DOUBLE,
"footnote_codes" VARCHAR
);
CREATE TABLE cu_data_6_asizewest (
"series_id" VARCHAR,
"year" BIGINT,
"period" VARCHAR,
"value" DOUBLE,
"footnote_codes" VARCHAR
);
CREATE TABLE cu_data_7_othernortheast (
"series_id" VARCHAR,
"year" BIGINT,
"period" VARCHAR,
"value" DOUBLE,
"footnote_codes" VARCHAR
);
CREATE TABLE cu_data_8_othernorthcentral (
"series_id" VARCHAR,
"year" BIGINT,
"period" VARCHAR,
"value" DOUBLE,
"footnote_codes" VARCHAR
);
CREATE TABLE cu_data_9_othersouth (
"series_id" VARCHAR,
"year" BIGINT,
"period" VARCHAR,
"value" DOUBLE,
"footnote_codes" VARCHAR
);
CREATE TABLE cu_item (
"item_code" VARCHAR,
"item_name" VARCHAR,
"display_level" DOUBLE,
"selectable" VARCHAR,
"sort_sequence" DOUBLE
);
CREATE TABLE cu_period (
"period" VARCHAR,
"period_abbr" VARCHAR,
"period_name" VARCHAR
);
CREATE TABLE cu_periodicity (
"periodicity_code" VARCHAR,
"periodicity_name" VARCHAR
);
CREATE TABLE cu_series (
"series_id" VARCHAR,
"area_code" VARCHAR,
"item_code" VARCHAR,
"seasonal" VARCHAR,
"periodicity_code" VARCHAR,
"base_code" VARCHAR,
"base_period" VARCHAR,
"series_title" VARCHAR,
"footnote_codes" VARCHAR,
"begin_year" VARCHAR,
"begin_period" VARCHAR,
"end_year" VARCHAR,
"end_period" VARCHAR
);
Anyone who has the link will be able to view this.