Annual Personal Consumption Expenditures For State Of Iowa

State of Iowa

@usgov.state_of_iowa_annual_personal_consumption_expenditures_68297187

Table List

1 table(26.5 KB)

Table 1

@usgov.state_of_iowa_annual_personal_consumption_expenditures_68297187.table_1

26.5 KB
1296 rows
9 columns

row_id Row ID	variable_code Variable Code	variable Variable	consumption_category Consumption Category	value Value	variable_unit Variable Unit	date Date	reported_year Reported Year	prior_year Prior Year
19000_2020_SAPCE1-1_annual	SAPCE1-1	Total personal consumption expenditures	All	121083.2	Millions of current dollars	Thu Dec 31 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	2020	2019
19000_2021_SAPCE1-2_annual	SAPCE1-2	Total personal consumption expenditures: Goods	Goods	51070.1	Millions of current dollars	Fri Dec 31 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	2021	2020
19000_2003_SAPCE1-1_annual	SAPCE1-1	Total personal consumption expenditures	All	70550.3	Millions of current dollars	Wed Dec 31 2003 00:00:00 GMT+0000 (Coordinated Universal Time)	2003	2002
19000_2022_SAPCE1-2_annual	SAPCE1-2	Total personal consumption expenditures: Goods	Goods	54509.6	Millions of current dollars	Sat Dec 31 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	2022	2021
19000_1997_SAPCE1-3_annual	SAPCE1-3	Total personal consumption expenditures: Durable goods	Durable goods	7419.9	Millions of current dollars	Wed Dec 31 1997 00:00:00 GMT+0000 (Coordinated Universal Time)	1997	1996
19000_2004_SAPCE1-1_annual	SAPCE1-1	Total personal consumption expenditures	All	74931.1	Millions of current dollars	Fri Dec 31 2004 00:00:00 GMT+0000 (Coordinated Universal Time)	2004	2003
19000_2021_SAPCE1-1_annual	SAPCE1-1	Total personal consumption expenditures	All	135535.4	Millions of current dollars	Fri Dec 31 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	2021	2020
19000_2003_SAPCE1-2_annual	SAPCE1-2	Total personal consumption expenditures: Goods	Goods	26504.4	Millions of current dollars	Wed Dec 31 2003 00:00:00 GMT+0000 (Coordinated Universal Time)	2003	2002
19000_1998_SAPCE1-3_annual	SAPCE1-3	Total personal consumption expenditures: Durable goods	Durable goods	8048.9	Millions of current dollars	Thu Dec 31 1998 00:00:00 GMT+0000 (Coordinated Universal Time)	1998	1997
19000_2016_SAPCE1-2_annual	SAPCE1-2	Total personal consumption expenditures: Goods	Goods	39606.9	Millions of current dollars	Sat Dec 31 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	2016	2015


CREATE TABLE table_1 (
  "row_id" VARCHAR,
  "variable_code" VARCHAR,
  "variable" VARCHAR,
  "consumption_category" VARCHAR,
  "value" DOUBLE,
  "variable_unit" VARCHAR,
  "date" TIMESTAMP,
  "reported_year" BIGINT,
  "prior_year" BIGINT
);