About this Dataset

Creative Sector Industry Codes, 2016

This data was used to create the Economic Development Department's 2016 Creative Economy Snapshot Report available at http://www.austintexas.gov/page/creative-development.

Data was compiled by the CreativeVitality Suite from a variety of sources including Occupations & Demographic: Economic Modeling Specialists International, Industry Sales: Economic Modeling Specialists International, State Arts Agency Grants: National Assembly of State Arts Agencies (Final Descriptive Reports), Nonprofit Revenues: National Center for Charitable Statistics, NCCS.

This product has been produced by the Economic development Department of the City of Austin for the sole purpose of informational reference. No warranty is made by the City of Austin regarding specific accuracy or completeness.
Organization: City of Austin
Last updated: 2020-11-12T13:29:53.181900
Tags: arts-and-culture, creative-economy, creative-sector

Tables

Table 1

@usgov.city_of_austin_creative_sector_industry_codes_2016.table_1

26.55 kB
51 rows
26 columns

CREATE TABLE table_1 (
  "naics_code" VARCHAR,
  "cad_defined_sector" VARCHAR,
  "industry" VARCHAR,
  "sales_2016" BIGINT,
  "jobs_2016" BIGINT,
  "total_earnings" BIGINT,
  "earnings_by_sector" DOUBLE,
  "earnings_per_job_2015" BIGINT,
  "earnings_per_job_2016" BIGINT,
  "n__change_of_earnings_per_job" DOUBLE  -- % Change Of Earnings Per Job,
  "national_lq_2016" DOUBLE,
  "white" BIGINT,
  "black_or_african_american" BIGINT,
  "amer_indian_or_ak_native" BIGINT  -- Amer. Indian Or AK Native,
  "asian" BIGINT,
  "hawaiian_or_other_pac_island" BIGINT  -- Hawaiian Or Other Pac. Island,
  "hispanic_or_latino" BIGINT,
  "two_or_more_races" BIGINT,
  "male" BIGINT,
  "female" BIGINT,
  "n_0_24_age" BIGINT  -- 0-24 Age,
  "n_25_34_age" BIGINT  -- 25-34 Age,
  "n_35_44_age" BIGINT  -- 35-44 Age,
  "n_45_54_age" BIGINT  -- 45-54 Age,
  "n_55_64_age" BIGINT  -- 55-64 Age,
  "n_65_99_age" BIGINT  -- 65-99 Age
);