DAAF-Contribution-Community/daaf / .claude/skills/education-data-source-pseo
education-data-source-pseo
VerifiedPSEO — Census data linking graduates to employment via LEHD wage records. Earnings percentiles at 1/5/10 years post-graduation by institution, degree, and CIP. Use for graduate earnings analysis. Coverage changes by release; Census V4.14.1 (2026Q2, posted 2026-08-25) lists 1,117 institution rows and partners in 37 states plus D.C. (plus online-only WGU).
| File | Kind | Size |
|---|---|---|
| SKILL.md | skill md | 22.3 KB |
| references/earnings-data.md | markdown | 10.4 KB |
| references/geographic-flows.md | markdown | 10.5 KB |
| references/industry-flows.md | markdown | 12.6 KB |
| references/lehd-methodology.md | markdown | 9.7 KB |
| references/state-coverage.md | markdown | 8.3 KB |
| references/variable-definitions.md | markdown | 15.7 KB |
references/state-coverage.md
View on GitHub# State Coverage
Participating states, coverage rates, data partners, and experimental data status.
## Contents
- [Coverage Overview](#coverage-overview)
- [Participating States and Partners](#participating-states-and-partners)
- [Coverage Rates](#coverage-rates)
- [Experimental Data Status](#experimental-data-status)
- [Coverage Implications](#coverage-implications)
- [Joining PSEO](#joining-pseo)
## Coverage Overview
PSEO coverage is **partner-based and release-specific**. Census release **V4.14.1 (2026Q2, posted 2026-08-25)** contains:
- **1,117 institution rows** (1,116 eight-digit OPEIDs plus `0033290W`, Penn State World Campus)
- Partners in **37 states plus the District of Columbia** (Maryland, New Jersey, New Mexico, Tennessee and Vermont added since V4.13.0)
- Western Governors University as an online-only participating institution
These counts were verified from Census latest-release files on 2026-10-19. The prior release, V4.13.0 (2025Q4), listed 952 institutions and partners in 32 states plus D.C. They do **not** establish a national percentage of all U.S. graduates, so this reference does not quote one.
Coverage varies because institutions and systems enter the product through separate data partnerships. Partner composition, institution counts, cohorts, and available outcomes can change between releases.
## Participating States and Partners
Do not treat a copied state or institution roster as permanently current. Use the Census release files as the authoritative participation inventory:
| Evidence | Stable Latest-Release URL | Use |
|----------|---------------------------|-----|
| Version | `https://lehd.ces.census.gov/data/pseo/latest_release/all/version_pseo.txt` | Record the exact release identifier and quarter |
| Institutions | `https://lehd.ces.census.gov/data/pseo/latest_release/all/pseo_all_institutions.csv` | Verify institution membership and count |
| Partners | `https://lehd.ces.census.gov/data/pseo/latest_release/all/pseo_all_partners.txt` | Verify participating states, D.C., systems, and institutions |
For reproducible reporting, save the release identifier alongside the analysis and state whether coverage refers to the current Census release or to the fixed Education Data Portal snapshot.
## Coverage Rates
The latest-release partner and institution files establish participation, but they do not by themselves provide a single current national graduate-coverage percentage. If a project needs a state or national coverage rate:
1. Select a clearly defined denominator, such as IPEDS completions for a specified year and credential scope.
2. Match only institutions present in the exact PSEO release being analyzed.
3. Report the PSEO release, denominator source/year, matching rules, and unmatched institutions.
4. Treat the result as an analyst-derived estimate, not as a Census-published national coverage statistic.
Historical state percentages based on 2015 IPEDS completions are not carried forward here because partner composition has changed. Recompute rates for the release and denominator relevant to the study.
## Experimental Data Status
### What "Experimental" Means
PSEO is designated as an **experimental data product** by the Census Bureau:
| Characteristic | Implication |
|----------------|-------------|
| **Not official statistics** | May not meet all federal statistical standards |
| **Methodology may change** | Future releases may use different methods |
| **Partial coverage** | Not representative of all U.S. graduates |
| **Quality varies** | Some cells have higher noise/uncertainty |
| **User feedback incorporated** | Product evolves based on user input |
### Experimental vs. Official Products
| Feature | Experimental (PSEO) | Official (e.g., QWI) |
|---------|---------------------|----------------------|
| Federal standards | Developing | Fully compliant |
| Coverage | Partial (participating institutions) | Comprehensive |
| Methodology | May evolve | Stable |
| Use guidance | Research/exploration | Official statistics |
| OMB clearance | Limited | Full |
### Appropriate Uses
**Appropriate:**
- Research and analysis
- Program evaluation
- Student information tools
- Policy exploration
- Institutional planning
**Caution required:**
- Comparisons across institutions with different coverage
- Time series with changing partner composition
- Small-cell estimates (high noise)
**Not appropriate:**
- Definitive rankings without caveats
- High-stakes decisions without supplementary data
## Coverage Implications
### Selection Bias Concerns
Participating states/institutions may differ from non-participants:
| Potential Bias | Direction |
|----------------|-----------|
| State policy environment | Progressive states may be more likely to participate |
| Institutional resources | Large systems more likely to have data infrastructure |
| Student outcomes | Unknown if participating institutions differ systematically |
### Interpreting Results
When analyzing PSEO data:
1. **Check coverage**: Identify the exact release, partners, institutions, cohorts, and rows represented
2. **Consider selection**: Participating institutions may not be representative
3. **Note changes**: Partner composition changes over time
4. **Report limitations**: Always disclose experimental status and avoid unsupported national percentages
### Comparison Guidelines
| Comparison | Validity | Notes |
|------------|----------|-------|
| Same institution over time | High | If institution continuously participates |
| Programs within same institution | High | Same data source/methodology |
| Same program across institutions (same state) | Medium | Same state partner, but institutional differences |
| Same program across states | Lower | Different data sources, selection |
| State-level aggregates | Medium | Coverage rates vary |
## Joining PSEO
### PSEO Coalition
The **PSEO Coalition** is "a collection of state and institutional representatives" (from 27 states in its January 2024 toolkit) who are, or plan to be, partners of the Census Bureau's LEHD program. In voluntary monthly meetings members discuss sharing data with and getting data from Census, agree on a list of priorities and requests for LEHD, and share data-literacy practices; once a quarter they meet Census staff (PSEO Coalition Toolkit, Chapter 1, Troutman, January 2024). Data-sharing agreements are made with the Census Bureau (PSEO Technical Documentation).
### Partnership Process
Higher education systems and individual colleges and universities join through a data-sharing agreement with the Census Bureau and transmit graduation (transcript) records (PSEO Technical Documentation). Joining steps beyond that are not published in the sources checked; contact the Census PSEO team or the PSEO Coalition.
### Data Requirements
Partners submit, for every graduate (PSEO Coalition methodology page, Wayback 2026-06-09): date of birth, graduation year, Social Security number, degree or credential earned, and major (with CIP codes, per ECS 2025). Census's technical documentation adds degree field, graduation date, institution and student demographics. Census tabulates institutions by 6-digit OPEID; how partners identify the institution in their files is not documented here.
### Contact Information
- **Census Bureau PSEO Team**: CES.PSEO.Feedback@census.gov
- **PSEO Coalition**: https://pseocoalition.org/contact/
### Benefits of Participation
| Benefit | Description |
|---------|-------------|
| National earnings data | Track graduates across state lines |
| Comparative benchmarking | Compare to similar institutions |
| Program evaluation | Assess employment outcomes by major |
| Consumer information | Inform prospective students |
| No additional surveys | Uses existing administrative data |
| Privacy protection | Differential privacy protects individuals |
## Timeline of Coverage Expansion
| Release / Year | Milestone |
|----------------|-----------|
| 2018 | First PSEO data released |
| R2022Q4 | Partners in 24 states (Census pseo_all_partners.txt for that release) |
| V4.13.0 (2025Q4) | 952 institutions; partners in 32 states plus D.C. |
| V4.14.1 (2026Q2) | 1,117 institution rows; partners in 37 states plus D.C. |
The last two rows are release-specific, verified on 2026-10-19 from the Census institution, partner, and version files for each release (V4.13.0 was first counted on 2026-07-21). Recheck those files before reusing the count.
Related skills
| Skill | Stars | Updated | Works with | Status | Install |
|---|---|---|---|---|---|
| finishing-a-development-branchobra/superpowersUse when implementation is complete, all tests pass, and you need to decide how to integrate the work | Stars: 322k | Updated | Claude CodeCodex | Verified | Install |
| systematic-debuggingobra/superpowersUse when encountering any bug, test failure, or unexpected behavior, before proposing fixes | Stars: 322k | Updated | Claude CodeCodex | Verified | Install |
| test-driven-developmentobra/superpowersUse when implementing any feature or bugfix, before writing implementation code | Stars: 322k | Updated | Claude CodeCodex | Verified | Install |
| skill-creatoranthropics/skillsCreate new skills, modify and improve existing skills, and measure skill performance. Use when users want to create a skill from scratch, edit, or optimize an existing skill, run evals to test a skill, benchmark skill performance with variance analysis, or optimize a skill's description for better triggering accuracy. | Stars: 197k | Updated | Claude CodeCodex | Verified | Install |