Median Earnings of Creative Sector Occupations, CLL.B.1

Median earnings of creative sector occupations tells us how much Austin's artists, musicians, and related creative sector workers are earning per hour. It shows us whether our city's artists and creative sector workers can afford to live and work in Austin.

This data reflects metric CLL.B1 within the City of Austin's Strategic Direction 2023. This metric is meant to inform City efforts in pursuing the Culture and Lifelong Learning Strategic Outcome. The complete metric title is "Median earnings of metro-area creative sector occupations (as defined by specific Bureau of Labor Statistics Standard Occupational Classifications System SOC codes)"

Data was gathered directly from the Creative Vitality Suite (cvsuite.org), a subscription-based online research-based, economic development tool that provides creative economy data and reporting. Data extracted from CVSuite software's data analysis from the following sources: Economic Modeling Specialists International (EMSI), National Assembly of State Arts Agencies, National Center for Charitable Statistics.

Querying over HTTP

Splitgraph serves as an HTTP API that lets you run SQL queries directly on this data to power Web applications. For example:

curl https://data.splitgraph.com/sql/query/ddn \
    -H "Content-Type: application/json" \
    -d@-<<EOF
{"sql": "
    SELECT *
    FROM \"datahub-austintexas-gov/median-earnings-of-creative-sector-occupations-2qxc-8cme\".\"median_earnings_of_creative_sector_occupations\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.