About this Dataset

Key Economic Indicators

An economic indicator is a statistic about an economic activity, and they allow analysis of economic performance and predictions of current and future economic performance. The TX Comptroller’s Key Economic Indicators includes such measures for TX & the US employment and unemployment, consumer confidence, price inflation, housing data, etc. See https://comptroller.texas.gov/about/policies/privacy.php for more information on our agency’s privacy and security policies.
Organization: City of Austin
Last updated: 2023-08-25T23:06:37.863059
Tags: case-shiller-home-price-index, cigarette-tax-stamps, consumer-confidence, cpi, crude-oil-production, home-sales, housing-permits, natural-gas-production, nonfarm-employment, nymex, rig-count, state-sales-tax-collections, unemployment-rate

Tables

Table 1

@usgov.city_of_austin_key_economic_indicators.table_1

63.72 kB
252 rows
31 columns

CREATE TABLE table_1 (
  "month" BIGINT,
  "year" BIGINT,
  "consumer_confidence_index_tx" DOUBLE,
  "consumer_confidence_west_south_central" DOUBLE,
  "consumer_confidence_index_us" DOUBLE,
  "pce_deflator" DOUBLE,
  "consumer_price_index_tx" DOUBLE,
  "consumer_price_index_u_s" DOUBLE  -- Consumer Price Index U.S.,
  "cpi_u_s_ex_food_and_energy" DOUBLE  -- CPI U.S. Ex Food And Energy,
  "nonfarm_employment_tx" DOUBLE,
  "nonfarm_employment_u_s" DOUBLE  -- Nonfarm Employment U.S.,
  "unemployment_tx" DOUBLE,
  "unemployment_u_s" DOUBLE  -- Unemployment U.S.,
  "single_family_building_permits_tx" DOUBLE,
  "multi_family_building_permits_tx" DOUBLE,
  "existing_single_family_home_sales_tx" DOUBLE,
  "existing_single_family_home_price_tx" DOUBLE,
  "non_residential_building_construction" DOUBLE,
  "total_sales_tax_collections_retail_tx" DOUBLE,
  "total_sales_tax_collections_tx" DOUBLE,
  "retail_gasoline_price_tx" DOUBLE,
  "retail_diesel_price_tx" DOUBLE,
  "nonfarm_employment_illinois" DOUBLE,
  "nonfarm_employment_florida" DOUBLE,
  "nonfarm_employment_new_york" DOUBLE,
  "nonfarm_employment_texas" DOUBLE,
  "nonfarm_employment_california" DOUBLE,
  "gross_value_crude_oil_production" DOUBLE,
  "gross_value_natural_gas_production" DOUBLE,
  "motor_fuel_taxed_gasoline" DOUBLE,
  "motor_fuel_taxed_diesel" DOUBLE
);