About this Dataset

Strategic Measure Median Earnings Of Metro-area Creative Sector Occupations, CLL.B.1

This dataset supports measure CLL.B.1 of SD23 and identifies the median earnings of metro-area Creative Sector occupations by Bureau of Labor Statistics Standard Occupational Classifications System [SOC] codes.

Data Source: 3rd party - Creative Vitality Suite
Calculation: the middle of the earnings, among all SOC codes
Measure Time Period: Annually (Calendar Year)

Last update: April 2021

View more details and insights related to this data set on the story page: data.austintexas.gov/stories/s/jaia-eaet
Organization: City of Austin
Last updated: 2020-11-12T13:34:30.721432
Tags: sd23

Tables

Table 1

@usgov.city_of_austin_strategic_measure_median_earnings_of_me_23b6d916.table_1

38.16 kB
250 rows
24 columns

CREATE TABLE table_1 (
  "soc_code" VARCHAR,
  "occupation" VARCHAR,
  "n__jobs" BIGINT  -- Jobs,
  "change" BIGINT,
  "n__change" DOUBLE  -- % Change,
  "median_hourly_earnings" DOUBLE,
  "average_hourly_earnings" DOUBLE,
  "national_lq_2018" 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,
  "date_reported" BIGINT
);