Spaces:
Running
Running
File size: 3,447 Bytes
46a7205 3a21c42 46a7205 | 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 | ---
sdk: docker
app_port: 7860
title: ISA 401 OEWS Jobs Explorer
emoji: 📊
colorFrom: yellow
colorTo: yellow
pinned: false
license: mit
short_description: Explore U.S. occupational employment and wage data
---
# ISA 401 OEWS Jobs Explorer
**Your AI-Powered Assistant for Exploring Occupational Employment and Wage Statistics**
[](https://huggingface.co/spaces/fmegahed/querychat_demo)
Explore the U.S. Bureau of Labor Statistics' Occupational Employment and Wage Statistics (OEWS) dataset using natural language queries.
---
## What is this app?
This Shiny application uses AI-powered natural language processing to help you explore the OEWS dataset. Instead of writing SQL queries, simply ask questions in plain English and get instant results.
**Example queries:**
- "What are the top 10 highest paying occupations in Ohio?"
- "Show me employment by industry for software developers"
- "What is the median wage for nurses nationally?"
- "Compare wages between California and Texas for data scientists"
---
## Dataset Information
**Dataset:** Occupational Employment and Wage Statistics (OEWS) Survey (May 2024 Estimates)
**Publisher:** U.S. Bureau of Labor Statistics (BLS), Department of Labor
**Website:** https://www.bls.gov/oes/
The OEWS program produces employment and wage estimates annually for over 800 occupations. These estimates are available for the nation as a whole, for individual states, and for metropolitan and nonmetropolitan areas.
### Key Fields
| Field | Description |
|-------|-------------|
| `occ_title` | Occupation title |
| `area_title` | Geographic area name |
| `tot_emp` | Total employment |
| `a_mean` | Mean annual wage |
| `a_median` | Median annual wage |
| `h_mean` | Mean hourly wage |
---
## Features
- **Natural Language Queries**: Ask questions in plain English
- **SQL Transparency**: See the generated SQL for each query
- **Interactive Data Table**: Sort, filter, and export results
- **Miami University Theming**: Branded for ISA 401 course use
---
## Running Locally
**With R:**
```r
# Install dependencies
renv::restore()
# Run the app
shiny::runApp('.', host = '0.0.0.0', port = 7860)
```
**With Docker:**
```bash
# Build the image
docker build -t oews-explorer .
# Run with OpenAI API key
docker run --rm -p 7860:7860 -e OPENAI_API_KEY=$OPENAI_API_KEY oews-explorer
```
---
## Required Environment Variable
This app requires an OpenAI API key to function:
```bash
export OPENAI_API_KEY="your-api-key-here"
```
On Hugging Face Spaces, set this as a secret in your Space settings.
---
## Technology Stack
- **[Shiny](https://shiny.posit.co/)** - Web application framework for R
- **[querychat](https://github.com/posit-dev/querychat)** - Natural language data querying
- **[bslib](https://rstudio.github.io/bslib/)** - Bootstrap theming for Shiny
- **[DT](https://rstudio.github.io/DT/)** - Interactive data tables
---
## Course Information
This application was developed for **ISA 401** at **Miami University** to help students explore and understand labor market data using modern AI-powered tools.
---
## Data Source
Bureau of Labor Statistics, U.S. Department of Labor. *Occupational Employment and Wage Statistics (OEWS), May 2024 Estimates.*
https://www.bls.gov/oes/
|