Data · Prepared August 25, 2026

Download the data.

Get everything in one file, or pick only the tables you need. Every download shows its version and where the data comes from.

Fixed after releaseChecksum for every fileSign in required for downloads

Current release

All the data, in one file

Every public table in a single DuckDB database file, ready to open and query.

Format: DuckDB
Size: 9.8 GB
Tables: 202

Checking sign-in…

Sources and connections

What is included, and how it connects

This download includes tables from 21 source families. This version was prepared on August 25, 2026. The archive contains additional editions and source material.

Browse Analyst questions

Source families

Inventory version

American Community Survey Public Use Microdata Sample2024 1-year national person file
Anthropic Economic Index2026_06_26
Baccalaureate and Beyond Longitudinal Studypublication 2022241, B&B:16/20 first-look tables A-1 and A-3 through A-7
BLS Employment Projections (National Employment Matrix)2024-34
BLS Occupational Employment and Wage Statistics (OEWS), all areasmay-2025
CareerOneStop Occupational License Downloadbulk archive dated 2024-10-14; retrieved and validated 2026-08-19
Carnegie Classifications 20252025
Census Post-Secondary Employment Outcomes (PSEO)V4.13.0 / 2025Q4, graduation cohorts through 2021 by participating state
College Scorecard2026-06
DAPIP - Database of Accredited Postsecondary Institutions and Programs2026-08-01
IPEDS — Integrated Postsecondary Education Data Systemmanifest-v2 baseline: 2014-15 through 2023-24, plus explicitly separate newer provisional releases
Microsoft Working with AIRepository version · December 22, 2025
National Survey of College Graduates2023
NC TOWER2026-08-15 snapshot of NCCCS and UNC public files
NCES/BLS CIP 2020 - SOC 2018 Crosswalk2020
O*NET Occupational Information Network database31.0
Occupational Requirements Survey2018 and 2023 final; 2025 preliminary
Projections Central long-term state occupational projectionssnapshot-date
Quarterly Census of Employment and Wages2025
Quarterly Workforce IndicatorsR2026Q2 / V4.14.0 / qwipu_nc_20260512_1027
Stanford AI Index Report (underlying chart data)2026

How the datasets connect

These links show which records you can connect without changing each publisher’s level of detail. A link does not prove an outcome or cause.

InstitutionreportsProgram Award Cell
Publication SnapshotselectsSource Release
ObservationusesMeasure Definition
Program Award Cellis classified asCIPField
CIPFieldmay prepare forOccupation
Detailed OccupationincludesTask
Occupationmay requireSkill

Dataset catalog

Ready-to-use datasets

Start with the curated datasets. Supporting records, reference data, and relationship tables remain available when you need the technical detail.

Checking sign-in…

/

54 tables640,996,866 rows in this release

martsmarts.acs_degree_occupation_context

Acs degree occupation context

Weighted population degree-field/occupation context. ACS 2024 one-year PUMS weighted descriptive context linking publisher degree-field codes to 2018 SOC occupation, state, age group, and sex. Cells under 30 public-use records have measures suppressed by an EduInsights minimum-cell policy (not a Census flag), and replicate-weight variance is not yet calculated. This is never evidence about a named institution or program.

Source and edition: acs_pums · 2024-1year-snapshot-2026-08-25-0c10af847d
What one row represents: (source_version, state_fips, first_field_of_degree_code, soc6, age_group, sex_code)
Rows: 429,899
File: 8.8 MB · Parquet

Checking

Show 22 columns

Schema and table: marts.acs_degree_occupation_context
Ontology entity: Publisher Classification
Source fields: source_version, source, source_file, source_member, source_row_number, source_row_key, source_sha256, ingested_at
Ontology relationships: PublisherClassification → CIPField; PublisherClassification → Occupation; ProfessionalAssociationEntry → PublisherClassification; PublisherClassification → DetailedOccupation; PublisherClassification → Industry
Caveats: No separate caveat is documented. Review the dataset description and source notes.

Column	Type	Description
`source_version`	`VARCHAR`	Version of the source dataset
`state_fips`	`VARCHAR`	State FIPS code
`first_field_of_degree_code`	`VARCHAR`	Census code for the first field of degree the person reported, recoded by the publisher. It is a Census field-of-degree code, not a field-of-study code.
`soc6`	`VARCHAR`	Detailed occupation code
`soc_version`	`VARCHAR`	Which year's occupation list this code comes from
`age_group`	`VARCHAR`	Age band EduInsights groups the person records into: under 25, 25 to 34, 35 to 44, 45 to 54, 55 to 64, or 65 and over
`sex_code`	`VARCHAR`	Sex as published
`sample_count`	`BIGINT`	Unweighted number of public-use person records behind this cell, and the count the minimum-cell rule is applied to
`weighted_persons`	`DOUBLE`	Sum of the Census person weights in this cell, an estimated population count. Blank where fewer than 30 records fall in the cell, which is never zero.
`weighted_mean_wage_income_2024_dollars`	`DOUBLE`	Person-weighted mean of wage and salary income for the past 12 months, adjusted to 2024 dollars with the Census adjustment factor. Blank where fewer than 30 records fall in the cell, which is never zero.
`weighted_mean_person_income_2024_dollars`	`DOUBLE`	Person-weighted mean of total personal income, adjusted to 2024 dollars with the Census adjustment factor. Blank where fewer than 30 records fall in the cell, which is never zero.
`coverage_state`	`VARCHAR`	Whether the value is published, withheld, not collected, or does not apply
`applicability`	`VARCHAR`	Whether this number was measured here, borrowed from a broader field, or assumed from a mapping
`caveat`	`VARCHAR`	Interpretation limit carried with every ACS public-use aggregate row
`source`	`VARCHAR`	Name of the dataset that supplied this row
`source_file`	`VARCHAR`	Source file this row was read from
`source_member`	`VARCHAR`	Sheet or archive part inside that file
`source_row_number`	`BIGINT`	Row number in the source file
`source_row_count`	`BIGINT`	How many source person records were combined into this row
`source_row_key`	`VARCHAR`	Stable key for this source row
`source_sha256`	`VARCHAR`	Checksum of the source file
`ingested_at`	`TIMESTAMP`	When EduInsights loaded the source file

martsmarts.aei_conversation_cluster_history

AEI conversation cluster history

ConversationCluster AI-use observation. March 2025 Anthropic Economic Index privacy-bucketed conversation clusters at native cluster grain, with the publisher's hierarchy descriptions, prevalence values, collaboration/Thinking ratios, and explicit O*NET task mapping cardinality. A cluster-to-task edge can fan out across occupations. Bucketed prevalence is observed Claude.ai context, not an individual-use estimate or population-wide AI exposure.

Source and edition: Source details not yet documented
What one row represents: (cluster_observation_id, task_id, onet_soc_code)
Rows: 788
File: 191 KB · Parquet

Checking

Show 34 columns

Schema and table: marts.aei_conversation_cluster_history
Ontology entity: Conversation Cluster
Source fields: source_release_id, release, source_file, source_row_number, source_sha256, ingested_at
Ontology relationships: ConversationCluster → Task
Caveats: No separate caveat is documented. Review the dataset description and source notes.

Column	Type	Description
`cluster_observation_id`	`VARCHAR`	Conversation-cluster observation ID
`source_release_id`	`VARCHAR`	Which published release this row came from
`release`	`VARCHAR`	Anthropic release
`aei_source`	`VARCHAR`	Whether this is Claude.ai or first-party API use
`cluster_id`	`VARCHAR`	Conversation cluster
`cluster_name_0`	`VARCHAR`	Top-level cluster name
`cluster_description_0`	`VARCHAR`	Top-level cluster description
`cluster_name_1`	`VARCHAR`	Mid-level cluster name
`cluster_description_1`	`VARCHAR`	Mid-level cluster description
`cluster_name_2`	`VARCHAR`	Detailed cluster name
`cluster_description_2`	`VARCHAR`	Detailed cluster description
`percent_records`	`DOUBLE`	Share of published conversation records in this cluster
`percent_users`	`DOUBLE`	Share of published users in this cluster
`publisher_onet_task`	`VARCHAR`	O*NET task text as Anthropic published it
`directive_ratio`	`DOUBLE`	Share of the cluster in the directive pattern
`feedback_loop_ratio`	`DOUBLE`	Share of the cluster in the feedback-loop pattern
`learning_ratio`	`DOUBLE`	Share of the cluster in the learning pattern
`no_collaboration_ratio`	`DOUBLE`	Share of the cluster with no collaboration pattern
`task_iteration_ratio`	`DOUBLE`	Share of the cluster in the task-iteration pattern
`validation_ratio`	`DOUBLE`	Share of the cluster in the validation pattern
`has_thinking_ratio`	`DOUBLE`	Share of the cluster using extended thinking
`applicability`	`VARCHAR`	Whether this number was measured here, borrowed from a broader field, or assumed from a mapping
`coverage`	`VARCHAR`	Whether this Anthropic value is published or not collected
`source_name`	`VARCHAR`	Name of the source dataset
`source_file`	`VARCHAR`	Source file this row was read from
`source_row_number`	`BIGINT`	Row number in the source file
`source_sha256`	`VARCHAR`	Checksum of the source file
`ingested_at`	`TIMESTAMP`	When EduInsights loaded the source file
`task_id`	`BIGINT`	Task identifier
`onet_soc_code`	`VARCHAR`	More specific occupation code used by O*NET
`soc6`	`VARCHAR`	Detailed occupation code
`match_method`	`VARCHAR`	How this row was matched to an O*NET task
`mapping_cardinality`	`BIGINT`	How many O*NET tasks this source row maps to
`onet_db_version`	`VARCHAR`	O*NET database used for the match

martsmarts.aei_detailed_occupation_history

AEI detailed occupation history

DetailedOccupation AI-use observation history. Complete published Anthropic Economic Index global detailed-occupation history. Claude.ai and first-party API are separate key dimensions, as are release and month; the API channel excludes Claude Code. Values are observed Claude-use empirical_calibration, not universal AI exposure, automation capability, productivity, displacement risk, or a forecast. O*NET specialization suffixes are native and must not be collapsed to SOC-6 without an explicit weighting method.

Source and edition: Source details not yet documented
What one row represents: (source_release_id, aei_source, onet_soc_code, period_start)
Rows: 2,758
File: 180 KB · Parquet

Checking

Show 35 columns

Schema and table: marts.aei_detailed_occupation_history
Ontology entity: Detailed Occupation
Source fields: source_release_id, release
Ontology relationships: DetailedOccupation → Occupation; DetailedOccupation → Task; OccupationalLicense → DetailedOccupation; PublisherClassification → DetailedOccupation
Caveats: No separate caveat is documented. Review the dataset description and source notes.

Column	Type	Description
`source_release_id`	`VARCHAR`	Which published release this row came from
`release`	`VARCHAR`	Anthropic release
`aei_source`	`VARCHAR`	Whether this is Claude.ai or first-party API use
`onet_soc_code`	`VARCHAR`	More specific occupation code used by O*NET
`soc6`	`VARCHAR`	Detailed occupation code
`occupation_title`	`VARCHAR`	Occupation name
`period_start`	`DATE`	Start of the observation period
`period_end`	`DATE`	End of the observation period
`usage_pct`	`DOUBLE`	Share of published Anthropic conversations for this occupationThis is Claude use in the published Anthropic data, not how exposed every worker is to AI.
`automation_pct`	`DOUBLE`	Share of those conversations labeled automationThis labels observed Claude conversations, not a forecast of job loss.
`augmentation_pct`	`DOUBLE`	Share of those conversations labeled augmentationThis labels observed Claude conversations, not a forecast of productivity.
`directive_pct`	`DOUBLE`	Share of conversations in the directive collaboration pattern
`feedback_loop_pct`	`DOUBLE`	Share of conversations in the feedback-loop pattern
`task_iteration_pct`	`DOUBLE`	Share of conversations in the task-iteration pattern
`learning_pct`	`DOUBLE`	Share of conversations in the learning pattern
`validation_pct`	`DOUBLE`	Share of conversations in the validation pattern
`ai_autonomy_mean`	`DOUBLE`	Average published AI-autonomy score
`human_only_ability_pct`	`DOUBLE`	Share described as human-only ability
`human_education_years_mean`	`DOUBLE`	Average human education years in the published data
`ai_education_years_mean`	`DOUBLE`	Average AI education years in the published data
`human_only_time_hours_mean`	`DOUBLE`	Average human-only time in hours
`human_with_ai_time_minutes_mean`	`DOUBLE`	Average time with AI in minutes
`work_use_pct`	`DOUBLE`	Share of conversations described as work use
`artifact_analysis_pct`	`DOUBLE`	Share involving analysis or summary artifacts
`artifact_code_debug_pct`	`DOUBLE`	Share involving code-fix artifacts
`artifact_data_pct`	`DOUBLE`	Share involving data or spreadsheet artifacts
`artifact_report_pct`	`DOUBLE`	Share involving report artifacts
`artifact_ml_ai_pct`	`DOUBLE`	Share involving machine-learning artifacts
`artifact_plan_pct`	`DOUBLE`	Share involving plan artifacts
`artifact_sql_pct`	`DOUBLE`	Share involving SQL artifacts
`n_published_metrics`	`BIGINT`	How many Anthropic metrics were published on this row
`applicability`	`VARCHAR`	Whether this number was measured here, borrowed from a broader field, or assumed from a mapping
`coverage`	`VARCHAR`	Whether this Anthropic value is published or not collected
`source_files`	`VARCHAR[]`	Every distinct source file behind the measures gathered onto this row.
`source_sha256s`	`VARCHAR[]`	Checksum of every distinct source file behind the measures gathered onto this row.

martsmarts.aei_task_history

AEI task history

Task AI-use observation history. Complete Anthropic task-facet history retaining release, Claude.ai versus first-party API channel, period, geography, publisher category/metric, coverage, and source-row provenance. Older releases identify tasks by text and can map one source observation to multiple occupation-specific O*NET task rows; inspect match_method and mapping_cardinality. Missing publisher rows are not zero. This is empirical_calibration of observed Claude use, not universal AI exposure, task capability, or an automation forecast.

Source and edition: Source details not yet documented
What one row represents: (observation_id, task_id, onet_soc_code)
Rows: 1,700,596
File: 41 MB · Parquet

Checking

Show 27 columns

Schema and table: marts.aei_task_history
Ontology entity: Task
Source fields: source_release_id, release, source_file, source_member, source_row_number, source_sha256, ingested_at
Ontology relationships: DetailedOccupation → Task; Observation → Institution, ProgramAwardCell, ProgramFieldGroup, Occupation, Task, Industry, Geography, OccupationalLicenseSnapshot, ProfessionalAssociationEntry; ConversationCluster → Task
Caveats: No separate caveat is documented. Review the dataset description and source notes.

Column	Type	Description
`source_release_id`	`VARCHAR`	Which published release this row came from
`release`	`VARCHAR`	Anthropic release
`aei_source`	`VARCHAR`	Whether this is Claude.ai or first-party API use
`period_start`	`DATE`	Start of the observation period
`period_end`	`DATE`	End of the observation period
`geo_id`	`VARCHAR`	Place identifier in the Anthropic file
`geo_level`	`VARCHAR`	Geographic level in the Anthropic file
`category_name`	`VARCHAR`	Publisher category
`metric_id`	`VARCHAR`	Publisher metric
`task_id`	`BIGINT`	Task identifier
`onet_soc_code`	`VARCHAR`	More specific occupation code used by O*NET
`soc6`	`VARCHAR`	Detailed occupation code
`publisher_task_text`	`VARCHAR`	Task text as Anthropic published it
`publisher_task_key`	`VARCHAR`	Task key as Anthropic published it
`value`	`DOUBLE`	Published value
`applicability`	`VARCHAR`	Whether this number was measured here, borrowed from a broader field, or assumed from a mapping
`coverage`	`VARCHAR`	Whether this Anthropic value is published or not collected
`match_method`	`VARCHAR`	How this row was matched to an O*NET task
`mapping_cardinality`	`BIGINT`	How many O*NET tasks this source row maps to
`onet_db_version`	`VARCHAR`	O*NET database used for the match
`observation_id`	`VARCHAR`	Source observation ID
`source_name`	`VARCHAR`	Name of the source dataset
`source_file`	`VARCHAR`	Source file this row was read from
`source_member`	`VARCHAR`	Sheet or archive part inside that file
`source_row_number`	`BIGINT`	Row number in the source file
`source_sha256`	`VARCHAR`	Checksum of the source file
`ingested_at`	`TIMESTAMP`	When EduInsights loaded the source file

martsmarts.detailed_occupation_ai_use

Detailed occupation AI use

DetailedOccupation AI-use observation. Latest Anthropic Economic Index occupation facet at O*NET-SOC specialization grain, kept separately for Claude.ai and first-party API usage. Automation/augmentation and collaboration values describe observed Claude interactions in the published population; they are empirical_calibration, not universal AI capability, displacement risk, or a forecast. Do not collapse specializations to SOC-6 without an explicit weighting method.

Source and edition: Source details not yet documented
What one row represents: (aei_source, onet_soc_code, period_start)
Rows: 1,408
File: 107 KB · Parquet

Checking

Show 35 columns

Schema and table: marts.detailed_occupation_ai_use
Ontology entity: Detailed Occupation
Source fields: source_release_id, release
Ontology relationships: DetailedOccupation → Occupation; DetailedOccupation → Task; OccupationalLicense → DetailedOccupation; PublisherClassification → DetailedOccupation
Caveats: No separate caveat is documented. Review the dataset description and source notes.

Column	Type	Description
`source_release_id`	`VARCHAR`	Which published release this row came from
`release`	`VARCHAR`	Anthropic release
`aei_source`	`VARCHAR`	Whether this is Claude.ai or first-party API use
`onet_soc_code`	`VARCHAR`	More specific occupation code used by O*NET
`soc6`	`VARCHAR`	Detailed occupation code
`occupation_title`	`VARCHAR`	Occupation name
`period_start`	`DATE`	Start of the observation period
`period_end`	`DATE`	End of the observation period
`usage_pct`	`DOUBLE`	Share of published Anthropic conversations for this occupationThis is Claude use in the published Anthropic data, not how exposed every worker in the occupation is to AI.
`automation_pct`	`DOUBLE`	Share of those conversations labeled automationThis labels observed Claude conversations, not a forecast that the occupation will be automated.
`augmentation_pct`	`DOUBLE`	Share of those conversations labeled augmentationThis labels observed Claude conversations, not a forecast of productivity or job change.
`directive_pct`	`DOUBLE`	Share of conversations in the directive collaboration pattern
`feedback_loop_pct`	`DOUBLE`	Share of conversations in the feedback-loop pattern
`task_iteration_pct`	`DOUBLE`	Share of conversations in the task-iteration pattern
`learning_pct`	`DOUBLE`	Share of conversations in the learning pattern
`validation_pct`	`DOUBLE`	Share of conversations in the validation pattern
`ai_autonomy_mean`	`DOUBLE`	Average published AI-autonomy score
`human_only_ability_pct`	`DOUBLE`	Share described as human-only ability
`human_education_years_mean`	`DOUBLE`	Average human education years in the published data
`ai_education_years_mean`	`DOUBLE`	Average AI education years in the published data
`human_only_time_hours_mean`	`DOUBLE`	Average human-only time in hours
`human_with_ai_time_minutes_mean`	`DOUBLE`	Average time with AI in minutes
`work_use_pct`	`DOUBLE`	Share of conversations described as work use
`artifact_analysis_pct`	`DOUBLE`	Share involving analysis or summary artifacts
`artifact_code_debug_pct`	`DOUBLE`	Share involving code-fix artifacts
`artifact_data_pct`	`DOUBLE`	Share involving data or spreadsheet artifacts
`artifact_report_pct`	`DOUBLE`	Share involving report artifacts
`artifact_ml_ai_pct`	`DOUBLE`	Share involving machine-learning artifacts
`artifact_plan_pct`	`DOUBLE`	Share involving plan artifacts
`artifact_sql_pct`	`DOUBLE`	Share involving SQL artifacts
`n_published_metrics`	`BIGINT`	How many Anthropic metrics were published on this row
`applicability`	`VARCHAR`	Whether this number was measured here, borrowed from a broader field, or assumed from a mapping
`coverage`	`VARCHAR`	Whether this Anthropic value is published or not collected
`source_files`	`VARCHAR[]`	Every distinct source file behind the measures gathered onto this row.
`source_sha256s`	`VARCHAR[]`	Checksum of every distinct source file behind the measures gathered onto this row.

martsmarts.field

Field

One row per CIP-6 field of study: taxonomy identity, latest canonical IPEDS completions by award level, institutions offering it, and a career outlook rolled up over the field's mapped occupations (edge-weighted wage / growth / AI exposure, with aggregate_soc bridging for BLS combined codes). Career columns are structural_prior — curricular preparation, NOT observed destinations; career_wage_coverage says how much edge weight has wage data.

Source and edition: Source details not yet documented
What one row represents: (cip6)
Rows: 2,143
File: 108 KB · Parquet

Checking

Show 21 columns

Schema and table: marts.field
Ontology entity: CIPField
Source fields: Source fields not listed separately
Ontology relationships: ProgramAwardCell → CIPField; CIPField → Occupation; PublisherClassification → CIPField
Caveats: No separate caveat is documented. Review the dataset description and source notes.

Column	Type	Description
`cip6`	`VARCHAR`	Most specific field-of-study code on this row
`cip_title`	`VARCHAR`	Name of the field of study
`cip4`	`VARCHAR`	Broader field-of-study family this specific field belongs to
`cip4_title`	`VARCHAR`	Name of the broader field of study
`cip2`	`VARCHAR`	Broadest field-of-study group this specific field belongs to
`occupation_mapping`	`VARCHAR`	How this field was linked to occupations
`has_completions`	`BOOLEAN`	Whether any awards were reported in this field
`completions_total`	`HUGEINT`	Total awards in this field
`completions_associate`	`HUGEINT`	Associate awards in this field
`completions_bachelors`	`HUGEINT`	Bachelor's awards in this field
`completions_masters`	`HUGEINT`	Master's awards in this field
`completions_doctoral`	`HUGEINT`	Doctoral awards in this field
`n_institutions`	`BIGINT`	Number of institutions
`n_occupations`	`BIGINT`	Number of linked occupations
`career_wage_coverage`	`DOUBLE`	Share of the occupation map that has wage data
`career_wage_annual_median_wtd`	`DOUBLE`	Average median wage across linked occupations, weighted by the preparation sharesBuilt from a field-to-occupation map, not from where graduates of this field actually work.
`career_projected_growth_pct_wtd`	`DOUBLE`	Average projected growth across linked occupations, weighted by the preparation sharesBuilt from a field-to-occupation map, not from where graduates of this field actually work.
`career_ai_exposure_score_wtd`	`DOUBLE`	Average observed Claude-use score across linked occupations, weighted by the preparation sharesBuilt from a field-to-occupation map and observed Claude use, not from this field's graduates.
`top_occupations`	`VARCHAR[]`	Largest linked occupationsThese occupations are linked by a curriculum map, not by observed graduate jobs.
`career_mapping_method`	`VARCHAR`	Whether the occupation links came from the official map or a fallback
`career_applicability`	`VARCHAR`	These career numbers come from a field-to-occupation map, not from watching graduates

martsmarts.field_award_benchmark

Field award benchmark

CIPField x credential level benchmark. National earnings/debt benchmarks per CIP-6 x Scorecard credential level, aggregated across institutions from program_outcomes_cip6. Medians are weighted by each institution's earnings/debt cohort size (weighted lower median); the underlying values are CIP-4 grain (earnings_grain='cip4'). Use this INSTEAD of aggregating program_award_cell yourself — never SUM or average program medians without cohort weights.

Source and edition: Source details not yet documented
What one row represents: (cip6, credlev)
Rows: 7,216
File: 120 KB · Parquet

Checking

Show 16 columns

Schema and table: marts.field_award_benchmark
Ontology entity: CIPField
Source fields: Source fields not listed separately
Ontology relationships: ProgramAwardCell → CIPField; CIPField → Occupation; PublisherClassification → CIPField
Caveats: No separate caveat is documented. Review the dataset description and source notes.

Column	Type	Description
`cip6`	`VARCHAR`	Most specific field-of-study code on this row
`credlev`	`VARCHAR`	Credential level in College Scorecard
`creddesc`	`VARCHAR`	Credential level name
`award_level`	`VARCHAR`	Name of the award level
`in_v1_scope`	`BOOLEAN`	Whether this award level is in the current scoring set
`n_institutions`	`BIGINT`	Number of institutions
`completions`	`HUGEINT`	Awards used in this benchmark
`n_reporting_1yr`	`BIGINT`	Number of institutions with a 1-year earnings figure
`earnings_cohort_1yr`	`HUGEINT`	Total graduates in the 1-year earnings groups
`earnings_1yr_median_wtd`	`DOUBLE`	Cohort-weighted median of 1-year earningsThe underlying earnings are for the broader field. Do not average unweighted program medians instead of this.
`earnings_1yr_median_unwtd`	`DOUBLE`	Unweighted median of 1-year earnings
`earnings_1yr_p25`	`DOUBLE`	25th percentile of 1-year earnings
`earnings_1yr_p75`	`DOUBLE`	75th percentile of 1-year earnings
`earnings_4yr_median_wtd`	`DOUBLE`	Cohort-weighted median of 4-year earningsThe underlying earnings are for the broader field. Do not average unweighted program medians instead of this.
`debt_median_wtd`	`DOUBLE`	Cohort-weighted median debtThe underlying debt is for the broader field. Do not average unweighted program medians instead of this.
`earnings_grain`	`VARCHAR`	Whether the underlying earnings were published for the specific field or a broader field

martsmarts.field_occupation_edge

Field occupation edge

Structural prior linking fields of study to occupations (CIP2020xSOC2018 crosswalk + EduInsights fallback for high-volume unmapped CIPs). PROHIBITED INTERPRETATION per the ontology: this is curricular preparation, NOT observed graduate destinations or employment probabilities. Weights are equal-split structural shares.

Source and edition: Source details not yet documented
What one row represents: (cip6, soc6)
Rows: 5,767
File: 61 KB · Parquet

Checking

Show 9 columns

Schema and table: marts.field_occupation_edge
Ontology entity: Cip prepares for occupation
Source fields: Source fields not listed separately
Ontology relationships: CIPField → Occupation
Caveats: No separate caveat is documented. Review the dataset description and source notes.

Column	Type	Description
`cip6`	`VARCHAR`	Most specific field-of-study code on this row
`cip_title`	`VARCHAR`	Name of the field of study
`soc6`	`VARCHAR`	Detailed occupation code
`soc_title`	`VARCHAR`	Occupation name
`weight`	`DOUBLE`	Equal share of occupations linked to this specific field of studyThe government publishes which fields prepare for which occupations, not these shares. This is a curriculum map, not where graduates actually work.
`applicability`	`VARCHAR`	Whether this number was measured here, borrowed from a broader field, or assumed from a mappingThis link is a preparation map, not an observed job destination.
`method`	`VARCHAR`	How the measure or mapping was constructed
`confidence`	`VARCHAR`	How confident the source or mapping is
`rationale`	`VARCHAR`	Why a fallback occupation link was added

martsmarts.institution

Institution

One row per IPEDS institution: identity, Carnegie 2025, campus family (OPEID6 rollup policy: attribute, never sum, OPEID6-grain values across member campuses), admissions/cost/outcomes context, and institutional accreditation summary. IPEDS release stage and Source Release identify whether the current canonical roster is provisional.

Source and edition: Source details not yet documented
What one row represents: (unitid)
Rows: 5,985
File: 627 KB · Parquet

Checking

Show 46 columns

Schema and table: marts.institution
Ontology entity: Institution
Source fields: collection_cycle, source_release_id, release_stage, publication_date, publication_snapshot_id
Ontology relationships: ScoringCohort → Institution; Institution → ProgramAwardCell; Institution → InstitutionSnapshot; Observation → Institution, ProgramAwardCell, ProgramFieldGroup, Occupation, Task, Industry, Geography, OccupationalLicenseSnapshot, ProfessionalAssociationEntry; Institution → Accreditor
Caveats: No separate caveat is documented. Review the dataset description and source notes.

Column	Type	Description
`unitid`	`VARCHAR`	Unique identification number of the institution
`name`	`VARCHAR`	Name of the institution
`alias`	`VARCHAR`	Other published name for the institution
`city`	`VARCHAR`	City
`state`	`VARCHAR`	State or jurisdiction
`zip`	`VARCHAR`	ZIP code
`sector`	`VARCHAR`	Sector of the institution
`control`	`VARCHAR`	Public, private nonprofit, or for-profit control
`level`	`VARCHAR`	Highest level of award offered
`url`	`VARCHAR`	Institution website
`address`	`VARCHAR`	Street address
`locale_code`	`VARCHAR`	Urban, suburban, town, or rural setting
`is_hbcu`	`BOOLEAN`	Historically Black college or university
`is_tribal`	`BOOLEAN`	Tribal college or university
`latitude`	`DOUBLE`	Latitude of the campus
`longitude`	`DOUBLE`	Longitude of the campus
`collection_cycle`	`VARCHAR`	Reporting year for this observation
`source_release_id`	`VARCHAR`	Which published release this row came from
`release_stage`	`VARCHAR`	Whether the selected release is provisional, final, or later revised
`publication_date`	`DATE`	When the source published this release
`coverage_state`	`VARCHAR`	Whether the value is published, withheld, not collected, or does not apply
`publication_snapshot_id`	`VARCHAR`	Which EduInsights snapshot selected this release
`carnegie_2025`	`VARCHAR`	2025 Carnegie classification
`opeid6`	`VARCHAR`	Six-character federal aid family used to group campuses
`is_main_campus`	`BOOLEAN`	Whether this campus is the main campus in its aid family
`n_campuses_in_family`	`INTEGER`	Number of colleges in the same federal-aid administrative family; this does not mean they share governance or operate as one institution
`family_name`	`VARCHAR`	Name of the selected main college in the federal-aid administrative family; this is not a system or governance name
`administrative_family_key`	`VARCHAR`	Stable key for colleges that share a six-character federal-aid identifier, with one-college fallback keys when that identifier is unavailable
`administrative_family_basis`	`VARCHAR`	Whether the administrative family uses a six-character federal-aid identifier or a one-college fallback key
`administrative_family_scope`	`VARCHAR`	The relationship represented by this grouping: federal-aid administration, not common governance or collective operation
`administrative_family_main_unitid`	`VARCHAR`	Institution ID of the selected main college in this federal-aid administrative family
`administrative_family_name`	`VARCHAR`	Name of the selected main college in this federal-aid administrative family
`administrative_family_member_count`	`INTEGER`	Number of same-cycle IPEDS colleges in this federal-aid administrative family
`adm_rate`	`DOUBLE`	Admission rate
`sat_avg`	`DOUBLE`	Average SAT score of admitted students
`undergrad_enrollment`	`BIGINT`	Undergraduate enrollment
`tuitionfee_in`	`DOUBLE`	In-state tuition and fees
`tuitionfee_out`	`DOUBLE`	Out-of-state tuition and fees
`net_price_avg`	`DOUBLE`	Average net price
`completion_rate_150pct`	`DOUBLE`	Share of students completing within 150 percent of normal time
`median_earnings_10yr`	`DOUBLE`	Median earnings 10 years after entry
`earnings_coverage`	`VARCHAR`	Whether earnings are published, withheld, or not collected
`institutional_accreditors`	`VARCHAR`	Institutional accreditors
`is_currently_accredited`	`BOOLEAN`	Whether a current grant is in accredited status
`accreditation_coverage`	`VARCHAR`	Whether an accreditation match was found
`total_completions`	`HUGEINT`	Total awards reported by the institution

martsmarts.institution_enrollment

Institution enrollment

Institution enrollment facet. IPEDS fall enrollment by facet (all students / undergraduate / graduate / degree-seeking slices) with gender and race/ethnicity breakdowns. Facets overlap — filter to one facet_code before summing across institutions; facet_code '1' is the all-students total. Release stage remains visible because canonical data may use a provisional-only newest cycle.

Source and edition: Source details not yet documented
What one row represents: (unitid, reporting_year, facet_code)
Rows: 113,833
File: 2.2 MB · Parquet

Checking

Show 24 columns

Schema and table: marts.institution_enrollment
Ontology entity: Institution
Source fields: collection_cycle, source_release_id, release_stage, publication_date, publication_snapshot_id
Ontology relationships: ScoringCohort → Institution; Institution → ProgramAwardCell; Institution → InstitutionSnapshot; Observation → Institution, ProgramAwardCell, ProgramFieldGroup, Occupation, Task, Industry, Geography, OccupationalLicenseSnapshot, ProfessionalAssociationEntry; Institution → Accreditor
Caveats: No separate caveat is documented. Review the dataset description and source notes.

Column	Type	Description
`unitid`	`VARCHAR`	Unique identification number of the institution
`institution_name`	`VARCHAR`	Name of the institution
`state`	`VARCHAR`	State or jurisdiction
`reporting_year`	`INTEGER`	Reporting year
`collection_cycle`	`VARCHAR`	Reporting year for this observation
`source_release_id`	`VARCHAR`	Which published release this row came from
`release_stage`	`VARCHAR`	Whether the selected release is provisional, final, or later revised
`publication_date`	`DATE`	When the source published this release
`coverage_state`	`VARCHAR`	Whether the value is published, withheld, not collected, or does not apply
`publication_snapshot_id`	`VARCHAR`	Which EduInsights snapshot selected this release
`facet_code`	`VARCHAR`	Which student group this enrollment or demographic row describes
`facet`	`VARCHAR`	Name of the student group
`total`	`BIGINT`	Total students or awards in this group
`men`	`BIGINT`	Men
`women`	`BIGINT`	Women
`american_indian_alaska_native`	`BIGINT`	American Indian or Alaska Native
`asian`	`BIGINT`	Asian
`black_african_american`	`BIGINT`	Black or African American
`hispanic_latino`	`BIGINT`	Hispanic or Latino
`native_hawaiian_pacific_islander`	`BIGINT`	Native Hawaiian or other Pacific Islander
`white`	`BIGINT`	White
`two_or_more_races`	`BIGINT`	Two or more races
`race_unknown`	`BIGINT`	Race or ethnicity unknown
`us_nonresident`	`BIGINT`	U.S. nonresident

martsmarts.institution_enrollment_latest_final

Institution enrollment latest final

Institution enrollment latest-final convenience view. Explicit point-in-time convenience table for the newest accepted final or revised enrollment observation.

Source and edition: Source details not yet documented
What one row represents: (unitid, facet_code)
Rows: 159,716
File: 3.7 MB · Parquet

Checking

Show 33 columns

Schema and table: marts.institution_enrollment_latest_final
Ontology entity: Institution
Source fields: collection_cycle, reference_period_start, reference_period_end, reference_period_label, source_release_id, release_stage, publication_date, publication_snapshot_id, source_file, source_member, source_row_number, source_sha256, ingested_at
Ontology relationships: ScoringCohort → Institution; Institution → ProgramAwardCell; Institution → InstitutionSnapshot; Observation → Institution, ProgramAwardCell, ProgramFieldGroup, Occupation, Task, Industry, Geography, OccupationalLicenseSnapshot, ProfessionalAssociationEntry; Institution → Accreditor
Caveats: No separate caveat is documented. Review the dataset description and source notes.

Column	Type	Description
`unitid`	`VARCHAR`	Unique identification number of the institution
`institution_name`	`VARCHAR`	Name of the institution
`state`	`VARCHAR`	State or jurisdiction
`institution_snapshot_collection_cycle`	`VARCHAR`	Collection year of the campus identity used on this row
`institution_snapshot_source_release_id`	`VARCHAR`	Source release of the campus identity used on this row
`collection_cycle`	`VARCHAR`	Reporting year for this observation
`reference_period_start`	`DATE`	Start of the period this number describes
`reference_period_end`	`DATE`	End of the period this number describes
`reference_period_label`	`VARCHAR`	Label for the period this number describes
`facet_code`	`VARCHAR`	Which student group this enrollment or demographic row describes
`total`	`BIGINT`	Total students or awards in this group
`men`	`BIGINT`	Men
`women`	`BIGINT`	Women
`american_indian_alaska_native`	`BIGINT`	American Indian or Alaska Native
`asian`	`BIGINT`	Asian
`black_african_american`	`BIGINT`	Black or African American
`hispanic_latino`	`BIGINT`	Hispanic or Latino
`native_hawaiian_pacific_islander`	`BIGINT`	Native Hawaiian or other Pacific Islander
`white`	`BIGINT`	White
`two_or_more_races`	`BIGINT`	Two or more races
`race_unknown`	`BIGINT`	Race or ethnicity unknown
`us_nonresident`	`BIGINT`	U.S. nonresident
`coverage_state`	`VARCHAR`	Whether the value is published, withheld, not collected, or does not apply
`imputation_flag`	`VARCHAR`	Source flag for imputed or estimated values
`source_release_id`	`VARCHAR`	Which published release this row came from
`release_stage`	`VARCHAR`	Whether the selected release is provisional, final, or later revised
`publication_date`	`DATE`	When the source published this release
`publication_snapshot_id`	`VARCHAR`	Which EduInsights snapshot selected this release
`source_file`	`VARCHAR`	Source file this row was read from
`source_member`	`VARCHAR`	Sheet or archive part inside that file
`source_row_number`	`BIGINT`	Row number in the source file
`source_sha256`	`VARCHAR`	Checksum of the source file
`ingested_at`	`TIMESTAMP`	When EduInsights loaded the source file

martsmarts.institution_enrollment_longitudinal

Institution enrollment longitudinal

Institution enrollment Observation. Canonical fall-enrollment history selected by the active Publication Snapshot with final-family preference and provisional-only fallback, joined to the contemporaneous Institution Snapshot and retaining Reference Period, Source Release, coverage, and row provenance.

Source and edition: Source details not yet documented
What one row represents: (unitid, collection_cycle, facet_code)
Rows: 1,355,204
File: 31 MB · Parquet

Checking

Show 33 columns

Schema and table: marts.institution_enrollment_longitudinal
Ontology entity: Institution
Source fields: collection_cycle, reference_period_start, reference_period_end, reference_period_label, source_release_id, release_stage, publication_date, publication_snapshot_id, source_file, source_member, source_row_number, source_sha256, ingested_at
Ontology relationships: ScoringCohort → Institution; Institution → ProgramAwardCell; Institution → InstitutionSnapshot; Observation → Institution, ProgramAwardCell, ProgramFieldGroup, Occupation, Task, Industry, Geography, OccupationalLicenseSnapshot, ProfessionalAssociationEntry; Institution → Accreditor
Caveats: No separate caveat is documented. Review the dataset description and source notes.

Column	Type	Description
`unitid`	`VARCHAR`	Unique identification number of the institution
`institution_name`	`VARCHAR`	Name of the institution
`state`	`VARCHAR`	State or jurisdiction
`institution_snapshot_collection_cycle`	`VARCHAR`	Collection year of the campus identity used on this row
`institution_snapshot_source_release_id`	`VARCHAR`	Source release of the campus identity used on this row
`collection_cycle`	`VARCHAR`	Reporting year for this observation
`reference_period_start`	`DATE`	Start of the period this number describes
`reference_period_end`	`DATE`	End of the period this number describes
`reference_period_label`	`VARCHAR`	Label for the period this number describes
`facet_code`	`VARCHAR`	Which student group this enrollment or demographic row describes
`total`	`BIGINT`	Total students or awards in this group
`men`	`BIGINT`	Men
`women`	`BIGINT`	Women
`american_indian_alaska_native`	`BIGINT`	American Indian or Alaska Native
`asian`	`BIGINT`	Asian
`black_african_american`	`BIGINT`	Black or African American
`hispanic_latino`	`BIGINT`	Hispanic or Latino
`native_hawaiian_pacific_islander`	`BIGINT`	Native Hawaiian or other Pacific Islander
`white`	`BIGINT`	White
`two_or_more_races`	`BIGINT`	Two or more races
`race_unknown`	`BIGINT`	Race or ethnicity unknown
`us_nonresident`	`BIGINT`	U.S. nonresident
`coverage_state`	`VARCHAR`	Whether the value is published, withheld, not collected, or does not apply
`imputation_flag`	`VARCHAR`	Source flag for imputed or estimated values
`source_release_id`	`VARCHAR`	Which published release this row came from
`release_stage`	`VARCHAR`	Whether the selected release is provisional, final, or later revised
`publication_date`	`DATE`	When the source published this release
`publication_snapshot_id`	`VARCHAR`	Which EduInsights snapshot selected this release
`source_file`	`VARCHAR`	Source file this row was read from
`source_member`	`VARCHAR`	Sheet or archive part inside that file
`source_row_number`	`BIGINT`	Row number in the source file
`source_sha256`	`VARCHAR`	Checksum of the source file
`ingested_at`	`TIMESTAMP`	When EduInsights loaded the source file

martsmarts.institution_enrollment_provisional_context

Institution enrollment provisional context

Institution enrollment provisional context. Newer accepted provisional enrollment is kept separate from canonical final history as an explicit audit surface even when those same rows serve as the canonical fallback.

Source and edition: Source details not yet documented
What one row represents: (unitid, collection_cycle, facet_code)
Rows: 113,833
File: 2.0 MB · Parquet

Checking

Show 30 columns

Schema and table: marts.institution_enrollment_provisional_context
Ontology entity: Institution
Source fields: collection_cycle, reference_period_start, reference_period_end, reference_period_label, source_release_id, release_stage, publication_date, source_file, source_member, source_row_number, source_sha256, ingested_at, publication_snapshot_id
Ontology relationships: ScoringCohort → Institution; Institution → ProgramAwardCell; Institution → InstitutionSnapshot; Observation → Institution, ProgramAwardCell, ProgramFieldGroup, Occupation, Task, Industry, Geography, OccupationalLicenseSnapshot, ProfessionalAssociationEntry; Institution → Accreditor
Caveats: No separate caveat is documented. Review the dataset description and source notes.

Column	Type	Description
`unitid`	`VARCHAR`	Unique identification number of the institution
`facet_code`	`VARCHAR`	Which student group this enrollment or demographic row describes
`total`	`BIGINT`	Total students or awards in this group
`men`	`BIGINT`	Men
`women`	`BIGINT`	Women
`american_indian_alaska_native`	`BIGINT`	American Indian or Alaska Native
`asian`	`BIGINT`	Asian
`black_african_american`	`BIGINT`	Black or African American
`hispanic_latino`	`BIGINT`	Hispanic or Latino
`native_hawaiian_pacific_islander`	`BIGINT`	Native Hawaiian or other Pacific Islander
`white`	`BIGINT`	White
`two_or_more_races`	`BIGINT`	Two or more races
`race_unknown`	`BIGINT`	Race or ethnicity unknown
`us_nonresident`	`BIGINT`	U.S. nonresident
`collection_cycle`	`VARCHAR`	Reporting year for this observation
`reference_period_start`	`DATE`	Start of the period this number describes
`reference_period_end`	`DATE`	End of the period this number describes
`reference_period_label`	`VARCHAR`	Label for the period this number describes
`source_release_id`	`VARCHAR`	Which published release this row came from
`release_stage`	`VARCHAR`	Whether the selected release is provisional, final, or later revised
`publication_date`	`DATE`	When the source published this release
`coverage_state`	`VARCHAR`	Whether the value is published, withheld, not collected, or does not apply
`source_file`	`VARCHAR`	Source file this row was read from
`source_member`	`VARCHAR`	Sheet or archive part inside that file
`source_row_number`	`BIGINT`	Row number in the source file
`source_sha256`	`VARCHAR`	Checksum of the source file
`ingested_at`	`TIMESTAMP`	When EduInsights loaded the source file
`imputation_flag`	`VARCHAR`	Source flag for imputed or estimated values
`publication_snapshot_id`	`VARCHAR`	Which EduInsights snapshot selected this release
`provisional_context_reason`	`VARCHAR`	Why this newer provisional enrollment row is kept separate from final history

martsmarts.ipeds_canonical_source_release

IPEDS canonical source release

Canonical IPEDS Source Release selection. One accepted Source Release per component-cycle. Selection precedence is late-revised, revised, final, then provisional; is_provisional_fallback explicitly marks the last case.

Source and edition: Source details not yet documented
What one row represents: (component, collection_cycle)
Rows: 134
File: 10 KB · Parquet

Checking

Show 14 columns

Schema and table: marts.ipeds_canonical_source_release
Ontology entity: Source Release
Source fields: source_release_id, collection_cycle, reference_period_kind, reference_period_start, reference_period_end, reference_period_label, release_stage, publication_date, publication_snapshot_id
Ontology relationships: PublicationSnapshot → SourceRelease
Caveats: No separate caveat is documented. Review the dataset description and source notes.

Column	Type	Description
`source_release_id`	`VARCHAR`	Which published release this row came from
`publisher`	`VARCHAR`	Publishing agency
`component`	`VARCHAR`	Which IPEDS survey this release belongs to
`collection_cycle`	`VARCHAR`	Reporting year for this observation
`reference_period_kind`	`VARCHAR`	What kind of period this is, such as a fall snapshot or academic year
`reference_period_start`	`DATE`	Start of the period this number describes
`reference_period_end`	`DATE`	End of the period this number describes
`reference_period_label`	`VARCHAR`	Label for the period this number describes
`release_stage`	`VARCHAR`	Whether the selected release is provisional, final, or later revised
`publication_date`	`DATE`	When the source published this release
`accepted`	`BOOLEAN`	Whether EduInsights accepted this release
`archive_id`	`VARCHAR`	Archive identifier for the source files
`publication_snapshot_id`	`VARCHAR`	Which EduInsights snapshot selected this release
`is_provisional_fallback`	`BOOLEAN`	Whether a provisional release was used because no final release exists

martsmarts.ipeds_completion_demographic_latest_final

IPEDS completion demographic latest final

Completion demographic latest-final observation. Newest final/revised IPEDS completion-demographic cell at its institution-total or award-level scope. It is point-in-time demographic context without a CIP/program key; do not reinterpret it as program-specific evidence.

Source and edition: Source details not yet documented
What one row represents: (unitid, completion_scope, award_level_code, facet_code)
Rows: 741,598
File: 3.6 MB · Parquet

Checking

Show 28 columns

Schema and table: marts.ipeds_completion_demographic_latest_final
Ontology entity: Institution
Source fields: collection_cycle, reference_period_start, reference_period_end, reference_period_label, source_release_id, release_stage, publication_date, source_file, source_member, source_row_number, source_sha256, ingested_at, publication_snapshot_id
Ontology relationships: ScoringCohort → Institution; Institution → ProgramAwardCell; Institution → InstitutionSnapshot; Observation → Institution, ProgramAwardCell, ProgramFieldGroup, Occupation, Task, Industry, Geography, OccupationalLicenseSnapshot, ProfessionalAssociationEntry; Institution → Accreditor
Caveats: No separate caveat is documented. Review the dataset description and source notes.

Column	Type	Description
`unitid`	`VARCHAR`	Unique identification number of the institution
`completion_scope`	`VARCHAR`	Whether this demographic count is for the whole institution or an award level
`award_level_code`	`VARCHAR`	IPEDS demographic-completions award level code (AWLEVELC) kept as an unpadded string — '3' is an associate's degree, '5' a bachelor's, '7' a master's, '9' a doctorate, and the remaining codes certificates. Labels are in ref.ipeds_dictionary_value under varname AWLEVELC. Blank on institution-total rows where no single award level applies.
`facet_code`	`VARCHAR`	Which student group this enrollment or demographic row describes
`demographic_dimension`	`VARCHAR`	Which demographic breakdown this is
`demographic_group_code`	`VARCHAR`	Which demographic group this count is for
`sex_code`	`VARCHAR`	Sex as published
`student_level_code`	`VARCHAR`	Student level, such as undergraduate or graduate
`source_value`	`VARCHAR`	Value as published in the source file
`completer_count`	`BIGINT`	Number of completers
`collection_cycle`	`VARCHAR`	Reporting year for this observation
`reference_period_start`	`DATE`	Start of the period this number describes
`reference_period_end`	`DATE`	End of the period this number describes
`reference_period_label`	`VARCHAR`	Label for the period this number describes
`source_release_id`	`VARCHAR`	Which published release this row came from
`release_stage`	`VARCHAR`	Whether the selected release is provisional, final, or later revised
`publication_date`	`DATE`	When the source published this release
`applicability`	`VARCHAR`	Whether this number was measured here, borrowed from a broader field, or assumed from a mapping
`coverage_state`	`VARCHAR`	Whether the value is published, withheld, not collected, or does not apply
`source_file`	`VARCHAR`	Source file this row was read from
`source_member`	`VARCHAR`	Sheet or archive part inside that file
`source_row_number`	`BIGINT`	Row number in the source file
`source_sha256`	`VARCHAR`	Checksum of the source file
`ingested_at`	`TIMESTAMP`	When EduInsights loaded the source file
`imputation_flag`	`VARCHAR`	Source flag for imputed or estimated values
`facet_label`	`VARCHAR`	Name of the student group
`award_level_label`	`VARCHAR`	Name of the award level
`publication_snapshot_id`	`VARCHAR`	Which EduInsights snapshot selected this release

martsmarts.ipeds_completion_demographic_longitudinal

IPEDS completion demographic longitudinal

Completion demographic observation. Snapshot-selected IPEDS completion demographics. C-B rows are institution totals with no CIP or award key; C-C rows add award-level scope but still have no CIP key. Never attribute these counts to a named program or CIP. Sex, race/ethnicity, gender-identity, and age facets can overlap; retain facet definition, coverage, release, and provenance.

Source and edition: Source details not yet documented
What one row represents: (unitid, completion_scope, award_level_code, facet_code, collection_cycle)
Rows: 5,828,885
File: 28 MB · Parquet

Checking

Show 28 columns

Schema and table: marts.ipeds_completion_demographic_longitudinal
Ontology entity: Institution
Source fields: collection_cycle, reference_period_start, reference_period_end, reference_period_label, source_release_id, release_stage, publication_date, source_file, source_member, source_row_number, source_sha256, ingested_at, publication_snapshot_id
Ontology relationships: ScoringCohort → Institution; Institution → ProgramAwardCell; Institution → InstitutionSnapshot; Observation → Institution, ProgramAwardCell, ProgramFieldGroup, Occupation, Task, Industry, Geography, OccupationalLicenseSnapshot, ProfessionalAssociationEntry; Institution → Accreditor
Caveats: No separate caveat is documented. Review the dataset description and source notes.

Column	Type	Description
`unitid`	`VARCHAR`	Unique identification number of the institution
`completion_scope`	`VARCHAR`	Whether this demographic count is for the whole institution or an award level
`award_level_code`	`VARCHAR`	IPEDS demographic-completions award level code (AWLEVELC) kept as an unpadded string — '3' is an associate's degree, '5' a bachelor's, '7' a master's, '9' a doctorate, and the remaining codes certificates. Labels are in ref.ipeds_dictionary_value under varname AWLEVELC. Blank on institution-total rows where no single award level applies.
`facet_code`	`VARCHAR`	Which student group this enrollment or demographic row describes
`demographic_dimension`	`VARCHAR`	Which demographic breakdown this is
`demographic_group_code`	`VARCHAR`	Which demographic group this count is for
`sex_code`	`VARCHAR`	Sex as published
`student_level_code`	`VARCHAR`	Student level, such as undergraduate or graduate
`source_value`	`VARCHAR`	Value as published in the source file
`completer_count`	`BIGINT`	Number of completersThese counts have no specific field of study. Do not treat them as program totals.
`collection_cycle`	`VARCHAR`	Reporting year for this observation
`reference_period_start`	`DATE`	Start of the period this number describes
`reference_period_end`	`DATE`	End of the period this number describes
`reference_period_label`	`VARCHAR`	Label for the period this number describes
`source_release_id`	`VARCHAR`	Which published release this row came from
`release_stage`	`VARCHAR`	Whether the selected release is provisional, final, or later revised
`publication_date`	`DATE`	When the source published this release
`applicability`	`VARCHAR`	Whether this number was measured here, borrowed from a broader field, or assumed from a mapping
`coverage_state`	`VARCHAR`	Whether the value is published, withheld, not collected, or does not apply
`source_file`	`VARCHAR`	Source file this row was read from
`source_member`	`VARCHAR`	Sheet or archive part inside that file
`source_row_number`	`BIGINT`	Row number in the source file
`source_sha256`	`VARCHAR`	Checksum of the source file
`ingested_at`	`TIMESTAMP`	When EduInsights loaded the source file
`imputation_flag`	`VARCHAR`	Source flag for imputed or estimated values
`facet_label`	`VARCHAR`	Name of the student group
`award_level_label`	`VARCHAR`	Name of the award level
`publication_snapshot_id`	`VARCHAR`	Which EduInsights snapshot selected this release

martsmarts.ipeds_component_coverage

IPEDS component coverage

IPEDS Component Coverage. Every expected component-cycle is accounted for by an accepted Source Release or an explicit non-observed Coverage State.

Source and edition: Source details not yet documented
What one row represents: (component, collection_cycle)
Rows: 144
File: 2.5 KB · Parquet

Checking

Show 6 columns

Schema and table: marts.ipeds_component_coverage
Ontology entity: Coverage Assessment
Source fields: collection_cycle, source_release_id
Ontology relationships: No direct connection documented for this table
Caveats: No separate caveat is documented. Review the dataset description and source notes.

Column	Type	Description
`component`	`VARCHAR`	Which IPEDS survey this release belongs to
`collection_cycle`	`VARCHAR`	Reporting year for this observation
`coverage_state`	`VARCHAR`	Whether the value is published, withheld, not collected, or does not apply
`source_release_id`	`VARCHAR`	Which published release this row came from
`detail`	`VARCHAR`	Extra coverage note
`is_accounted_for`	`BOOLEAN`	Whether this expected survey-year is covered or explicitly missing

martsmarts.ipeds_constant_dollar_series

IPEDS constant dollar series

IPEDS Constant-Dollar Series. Derived monetary series that keeps source-native nominal values alongside constant values, named price index, index release, and base Collection Cycle.

Source and edition: Source details not yet documented
What one row represents: (unitid, measure_id, collection_cycle)
Rows: 136,234
File: 1.8 MB · Parquet

Checking

Show 19 columns

Schema and table: marts.ipeds_constant_dollar_series
Ontology entity: Observation
Source fields: collection_cycle, reference_period_start, reference_period_end, reference_period_label, source_release_id, release_stage, publication_date, publication_snapshot_id
Ontology relationships: Observation → MeasureDefinition; Observation → Institution, ProgramAwardCell, ProgramFieldGroup, Occupation, Task, Industry, Geography, OccupationalLicenseSnapshot, ProfessionalAssociationEntry; EvidenceClaim → Observation
Caveats: No separate caveat is documented. Review the dataset description and source notes.

Column	Type	Description
`unitid`	`VARCHAR`	Unique identification number of the institution
`measure_id`	`VARCHAR`	Measure identifier
`collection_cycle`	`VARCHAR`	Reporting year for this observation
`reference_period_start`	`DATE`	Start of the period this number describes
`reference_period_end`	`DATE`	End of the period this number describes
`reference_period_label`	`VARCHAR`	Label for the period this number describes
`nominal_value`	`DOUBLE`	Value in the dollars of that year
`constant_value`	`DOUBLE`	Value after adjusting for price change
`nominal_unit`	`VARCHAR`	Unit of the unadjusted value
`constant_unit`	`VARCHAR`	Unit of the inflation-adjusted value
`price_index_id`	`VARCHAR`	Price index used for the adjustment
`price_index_release`	`VARCHAR`	Release of that price index
`base_collection_cycle`	`VARCHAR`	Year the constant dollars are expressed in
`price_index_coverage`	`VARCHAR`	Whether a price index value was available for this year
`coverage_state`	`VARCHAR`	Whether the value is published, withheld, not collected, or does not apply
`source_release_id`	`VARCHAR`	Which published release this row came from
`release_stage`	`VARCHAR`	Whether the selected release is provisional, final, or later revised
`publication_date`	`DATE`	When the source published this release
`publication_snapshot_id`	`VARCHAR`	Which EduInsights snapshot selected this release

martsmarts.ipeds_distance_enrollment_composition_latest

IPEDS distance enrollment composition latest

Latest canonical institution distance-enrollment composition. It selects the newest accepted Collection Cycle, including a provisional fallback, rather than ranking publisher status dates or Reference Period labels. Use the longitudinal composition surface for change over time.

Source and edition: Source details not yet documented
What one row represents: (unitid, survey_period, student_level_code)
Rows: 21,810
File: 860 KB · Parquet

Checking

Show 43 columns

Schema and table: marts.ipeds_distance_enrollment_composition_latest
Ontology entity: Institution
Source fields: collection_cycle, reference_period_start, reference_period_end, reference_period_label, source_release_id, release_stage, publication_date, publication_snapshot_id
Ontology relationships: ScoringCohort → Institution; Institution → ProgramAwardCell; Institution → InstitutionSnapshot; Observation → Institution, ProgramAwardCell, ProgramFieldGroup, Occupation, Task, Industry, Geography, OccupationalLicenseSnapshot, ProfessionalAssociationEntry; Institution → Accreditor
Caveats: No separate caveat is documented. Review the dataset description and source notes.

Column	Type	Description
`unitid`	`VARCHAR`	Unique identification number of the institution
`institution_name`	`VARCHAR`	Name of the institution
`state`	`VARCHAR`	State or jurisdiction
`sector_code`	`VARCHAR`	IPEDS sector code from the same collection year as the enrollment figures
`sector`	`VARCHAR`	Sector of the institution
`control_code`	`VARCHAR`	IPEDS control code from the same collection year as the enrollment figures
`control`	`VARCHAR`	Public, private nonprofit, or for-profit control
`level_code`	`VARCHAR`	IPEDS award-level code from the same collection year as the enrollment figures
`level`	`VARCHAR`	Highest level of award offered
`opeid`	`VARCHAR`	Eight-character federal student-aid identifier, including leading zeros
`opeid6`	`VARCHAR`	Six-character federal-aid identifier used for aid administration; sharing it does not establish common governance or collective operation
`administrative_family_key`	`VARCHAR`	Stable key for colleges that share a six-character federal-aid identifier, with one-college fallback keys when that identifier is unavailable
`administrative_family_basis`	`VARCHAR`	Whether the administrative family uses a six-character federal-aid identifier or a one-college fallback key
`administrative_family_scope`	`VARCHAR`	The relationship represented by this grouping: federal-aid administration, not common governance or collective operation
`administrative_family_name`	`VARCHAR`	Name of the selected main college in this federal-aid administrative family
`administrative_family_main_unitid`	`VARCHAR`	Institution ID of the selected main college in this federal-aid administrative family
`administrative_family_member_count`	`BIGINT`	Number of same-cycle IPEDS colleges in this federal-aid administrative family
`survey_period`	`VARCHAR`	Fall or 12-month enrollment period
`student_level_code`	`VARCHAR`	Student level, such as undergraduate or graduate
`student_level_label`	`VARCHAR`	Student level name
`collection_cycle`	`VARCHAR`	Reporting year for this observation
`reference_period_start`	`DATE`	Start of the period this number describes
`reference_period_end`	`DATE`	End of the period this number describes
`reference_period_label`	`VARCHAR`	Label for the period this number describes
`students_total`	`BIGINT`	Published student total for this survey period, retained even when a distance category is unavailable
`students_total_coverage_state`	`VARCHAR`	Whether the published total is available, withheld, not collected, or does not apply
`distance_exclusive_students`	`BIGINT`	Published count of students enrolled only in distance education
`distance_exclusive_coverage_state`	`VARCHAR`	Whether the only-distance count is available, withheld, not collected, or does not apply
`distance_some_students`	`BIGINT`	Published count of students enrolled in some, but not all, distance education
`distance_some_coverage_state`	`VARCHAR`	Whether the some-distance count is available, withheld, not collected, or does not apply
`distance_none_students`	`BIGINT`	Published count of students not enrolled in distance education
`distance_none_coverage_state`	`VARCHAR`	Whether the no-distance count is available, withheld, not collected, or does not apply
`observed_category_sum`	`HUGEINT`	Sum of the published numeric distance-category counts; unavailable categories are omitted, never changed to zero
`category_coverage_complete`	`BOOLEAN`	Whether all three distance-category counts are published numeric values
`reconciliation_gap`	`HUGEINT`	Category sum minus the published total, calculated only when the total and all three categories are published
`has_required_distance_metrics`	`BOOLEAN`	Whether the source contains the total and all three expected category fields, regardless of whether every field has a numeric value
`in_standard_distance_universe`	`BOOLEAN`	Whether this is an all-student 12-month reporter in the 50 states or District of Columbia with a same-cycle sector code from 1 through 6
`cohort_definition_id`	`VARCHAR`	Versioned identifier for the standard U.S. distance-enrollment comparison population
`cohort_definition`	`VARCHAR`	Plain-language rule for the standard U.S. distance-enrollment comparison population
`source_release_id`	`VARCHAR`	Which published release this row came from
`release_stage`	`VARCHAR`	Whether the selected release is provisional, final, or later revised
`publication_date`	`DATE`	When the source published this release
`publication_snapshot_id`	`VARCHAR`	Which EduInsights snapshot selected this release

martsmarts.ipeds_distance_enrollment_composition_longitudinal

IPEDS distance enrollment composition longitudinal

Institution distance-enrollment composition by collection cycle. One row keeps the published total and each distance-enrollment category with its own coverage state. The total remains available when a category was not collected; unavailable cells are never converted to zero. Same-cycle institution attributes define the governed comparison population. OPEID-6 groups are federal-aid administrative families, not evidence that member colleges share governance or operate as one institution.

Source and edition: Source details not yet documented
What one row represents: (unitid, survey_period, student_level_code, collection_cycle)
Rows: 383,810
File: 10 MB · Parquet

Checking

Show 43 columns

Schema and table: marts.ipeds_distance_enrollment_composition_longitudinal
Ontology entity: Institution
Source fields: collection_cycle, reference_period_start, reference_period_end, reference_period_label, source_release_id, release_stage, publication_date, publication_snapshot_id
Ontology relationships: ScoringCohort → Institution; Institution → ProgramAwardCell; Institution → InstitutionSnapshot; Observation → Institution, ProgramAwardCell, ProgramFieldGroup, Occupation, Task, Industry, Geography, OccupationalLicenseSnapshot, ProfessionalAssociationEntry; Institution → Accreditor
Caveats: No separate caveat is documented. Review the dataset description and source notes.

Column	Type	Description
`unitid`	`VARCHAR`	Unique identification number of the institution
`institution_name`	`VARCHAR`	Name of the institution
`state`	`VARCHAR`	State or jurisdiction
`sector_code`	`VARCHAR`	IPEDS sector code from the same collection year as the enrollment figures
`sector`	`VARCHAR`	Sector of the institution
`control_code`	`VARCHAR`	IPEDS control code from the same collection year as the enrollment figures
`control`	`VARCHAR`	Public, private nonprofit, or for-profit control
`level_code`	`VARCHAR`	IPEDS award-level code from the same collection year as the enrollment figures
`level`	`VARCHAR`	Highest level of award offered
`opeid`	`VARCHAR`	Eight-character federal student-aid identifier, including leading zeros
`opeid6`	`VARCHAR`	Six-character federal-aid identifier used for aid administration; sharing it does not establish common governance or collective operation
`administrative_family_key`	`VARCHAR`	Stable key for colleges that share a six-character federal-aid identifier, with one-college fallback keys when that identifier is unavailable
`administrative_family_basis`	`VARCHAR`	Whether the administrative family uses a six-character federal-aid identifier or a one-college fallback key
`administrative_family_scope`	`VARCHAR`	The relationship represented by this grouping: federal-aid administration, not common governance or collective operation
`administrative_family_name`	`VARCHAR`	Name of the selected main college in this federal-aid administrative family
`administrative_family_main_unitid`	`VARCHAR`	Institution ID of the selected main college in this federal-aid administrative family
`administrative_family_member_count`	`BIGINT`	Number of same-cycle IPEDS colleges in this federal-aid administrative family
`survey_period`	`VARCHAR`	Fall or 12-month enrollment period
`student_level_code`	`VARCHAR`	Student level, such as undergraduate or graduate
`student_level_label`	`VARCHAR`	Student level name
`collection_cycle`	`VARCHAR`	Reporting year for this observation
`reference_period_start`	`DATE`	Start of the period this number describes
`reference_period_end`	`DATE`	End of the period this number describes
`reference_period_label`	`VARCHAR`	Label for the period this number describes
`students_total`	`BIGINT`	Published student total for this survey period, retained even when a distance category is unavailable
`students_total_coverage_state`	`VARCHAR`	Whether the published total is available, withheld, not collected, or does not apply
`distance_exclusive_students`	`BIGINT`	Published count of students enrolled only in distance education
`distance_exclusive_coverage_state`	`VARCHAR`	Whether the only-distance count is available, withheld, not collected, or does not apply
`distance_some_students`	`BIGINT`	Published count of students enrolled in some, but not all, distance education
`distance_some_coverage_state`	`VARCHAR`	Whether the some-distance count is available, withheld, not collected, or does not apply
`distance_none_students`	`BIGINT`	Published count of students not enrolled in distance education
`distance_none_coverage_state`	`VARCHAR`	Whether the no-distance count is available, withheld, not collected, or does not apply
`observed_category_sum`	`HUGEINT`	Sum of the published numeric distance-category counts; unavailable categories are omitted, never changed to zero
`category_coverage_complete`	`BOOLEAN`	Whether all three distance-category counts are published numeric values
`reconciliation_gap`	`HUGEINT`	Category sum minus the published total, calculated only when the total and all three categories are published
`has_required_distance_metrics`	`BOOLEAN`	Whether the source contains the total and all three expected category fields, regardless of whether every field has a numeric value
`in_standard_distance_universe`	`BOOLEAN`	Whether this is an all-student 12-month reporter in the 50 states or District of Columbia with a same-cycle sector code from 1 through 6
`cohort_definition_id`	`VARCHAR`	Versioned identifier for the standard U.S. distance-enrollment comparison population
`cohort_definition`	`VARCHAR`	Plain-language rule for the standard U.S. distance-enrollment comparison population
`source_release_id`	`VARCHAR`	Which published release this row came from
`release_stage`	`VARCHAR`	Whether the selected release is provisional, final, or later revised
`publication_date`	`DATE`	When the source published this release
`publication_snapshot_id`	`VARCHAR`	Which EduInsights snapshot selected this release

martsmarts.ipeds_distance_enrollment_latest_final

IPEDS distance enrollment latest final

Institution distance-enrollment latest-final observation. Newest final/revised IPEDS distance-enrollment observation for each native institution, survey-period, student-level, and metric cell. This is an explicit point-in-time convenience surface; use the longitudinal mart for change and retain its source release and coverage state.

Source and edition: Source details not yet documented
What one row represents: (unitid, survey_period, student_level_code, metric_code)
Rows: 359,976
File: 2.1 MB · Parquet

Checking

Show 25 columns

Schema and table: marts.ipeds_distance_enrollment_latest_final
Ontology entity: Institution
Source fields: collection_cycle, reference_period_start, reference_period_end, reference_period_label, source_release_id, release_stage, publication_date, source_file, source_member, source_row_number, source_sha256, ingested_at, publication_snapshot_id
Ontology relationships: ScoringCohort → Institution; Institution → ProgramAwardCell; Institution → InstitutionSnapshot; Observation → Institution, ProgramAwardCell, ProgramFieldGroup, Occupation, Task, Industry, Geography, OccupationalLicenseSnapshot, ProfessionalAssociationEntry; Institution → Accreditor
Caveats: No separate caveat is documented. Review the dataset description and source notes.

Column	Type	Description
`unitid`	`VARCHAR`	Unique identification number of the institution
`survey_period`	`VARCHAR`	Fall or 12-month enrollment period
`student_level_code`	`VARCHAR`	Student level, such as undergraduate or graduate
`metric_code`	`VARCHAR`	Which distance or program metric this row is
`source_variable`	`VARCHAR`	Source questionnaire or file variable
`source_value`	`VARCHAR`	Value as published in the source file
`student_count`	`BIGINT`	Number of students
`collection_cycle`	`VARCHAR`	Reporting year for this observation
`reference_period_start`	`DATE`	Start of the period this number describes
`reference_period_end`	`DATE`	End of the period this number describes
`reference_period_label`	`VARCHAR`	Label for the period this number describes
`source_release_id`	`VARCHAR`	Which published release this row came from
`release_stage`	`VARCHAR`	Whether the selected release is provisional, final, or later revised
`publication_date`	`DATE`	When the source published this release
`applicability`	`VARCHAR`	Whether this number was measured here, borrowed from a broader field, or assumed from a mapping
`coverage_state`	`VARCHAR`	Whether the value is published, withheld, not collected, or does not apply
`source_file`	`VARCHAR`	Source file this row was read from
`source_member`	`VARCHAR`	Sheet or archive part inside that file
`source_row_number`	`BIGINT`	Row number in the source file
`source_sha256`	`VARCHAR`	Checksum of the source file
`ingested_at`	`TIMESTAMP`	When EduInsights loaded the source file
`imputation_flag`	`VARCHAR`	Source flag for imputed or estimated values
`student_level_label`	`VARCHAR`	Student level name
`metric_label`	`VARCHAR`	Name of the metric
`publication_snapshot_id`	`VARCHAR`	Which EduInsights snapshot selected this release

martsmarts.ipeds_distance_enrollment_longitudinal

IPEDS distance enrollment longitudinal

Institution distance-enrollment observation. Snapshot-selected IPEDS fall or 12-month distance-enrollment evidence at the publisher's student-level and metric grain. Exclusive-distance, some-distance, no-distance, and location counts are distinct source metrics; do not sum overlapping categories without their questionnaire definition. Zero is observed, while not_collected, not_applicable, and suppressed remain distinct with release and row provenance.

Source and edition: Source details not yet documented
What one row represents: (unitid, survey_period, student_level_code, metric_code, collection_cycle)
Rows: 2,783,710
File: 16 MB · Parquet

Checking

Show 25 columns

Schema and table: marts.ipeds_distance_enrollment_longitudinal
Ontology entity: Institution
Source fields: collection_cycle, reference_period_start, reference_period_end, reference_period_label, source_release_id, release_stage, publication_date, source_file, source_member, source_row_number, source_sha256, ingested_at, publication_snapshot_id
Ontology relationships: ScoringCohort → Institution; Institution → ProgramAwardCell; Institution → InstitutionSnapshot; Observation → Institution, ProgramAwardCell, ProgramFieldGroup, Occupation, Task, Industry, Geography, OccupationalLicenseSnapshot, ProfessionalAssociationEntry; Institution → Accreditor
Caveats: No separate caveat is documented. Review the dataset description and source notes.

Column	Type	Description
`unitid`	`VARCHAR`	Unique identification number of the institution
`survey_period`	`VARCHAR`	Fall or 12-month enrollment period
`student_level_code`	`VARCHAR`	Student level, such as undergraduate or graduate
`metric_code`	`VARCHAR`	Which distance or program metric this row is
`source_variable`	`VARCHAR`	Source questionnaire or file variable
`source_value`	`VARCHAR`	Value as published in the source file
`student_count`	`BIGINT`	Number of students
`collection_cycle`	`VARCHAR`	Reporting year for this observation
`reference_period_start`	`DATE`	Start of the period this number describes
`reference_period_end`	`DATE`	End of the period this number describes
`reference_period_label`	`VARCHAR`	Label for the period this number describes
`source_release_id`	`VARCHAR`	Which published release this row came from
`release_stage`	`VARCHAR`	Whether the selected release is provisional, final, or later revised
`publication_date`	`DATE`	When the source published this release
`applicability`	`VARCHAR`	Whether this number was measured here, borrowed from a broader field, or assumed from a mapping
`coverage_state`	`VARCHAR`	Whether the value is published, withheld, not collected, or does not apply
`source_file`	`VARCHAR`	Source file this row was read from
`source_member`	`VARCHAR`	Sheet or archive part inside that file
`source_row_number`	`BIGINT`	Row number in the source file
`source_sha256`	`VARCHAR`	Checksum of the source file
`ingested_at`	`TIMESTAMP`	When EduInsights loaded the source file
`imputation_flag`	`VARCHAR`	Source flag for imputed or estimated values
`student_level_label`	`VARCHAR`	Student level name
`metric_label`	`VARCHAR`	Name of the metric
`publication_snapshot_id`	`VARCHAR`	Which EduInsights snapshot selected this release

martsmarts.ipeds_distance_offering_latest_final

IPEDS distance offering latest final

Institution distance-offering latest-final observation. Newest final/revised IPEDS distance-offering flag for each native institution, education-level, offering-kind, and questionnaire-variable cell. It is point-in-time institutional context, not evidence of current named-program modality.

Source and edition: Source details not yet documented
What one row represents: (unitid, education_level, offering_kind, source_variable)
Rows: 92,846
File: 273 KB · Parquet

Checking

Show 24 columns

Schema and table: marts.ipeds_distance_offering_latest_final
Ontology entity: Institution
Source fields: collection_cycle, reference_period_start, reference_period_end, reference_period_label, source_release_id, release_stage, publication_date, source_file, source_member, source_row_number, source_sha256, ingested_at, publication_snapshot_id
Ontology relationships: ScoringCohort → Institution; Institution → ProgramAwardCell; Institution → InstitutionSnapshot; Observation → Institution, ProgramAwardCell, ProgramFieldGroup, Occupation, Task, Industry, Geography, OccupationalLicenseSnapshot, ProfessionalAssociationEntry; Institution → Accreditor
Caveats: No separate caveat is documented. Review the dataset description and source notes.

Column	Type	Description
`unitid`	`VARCHAR`	Unique identification number of the institution
`education_level`	`VARCHAR`	Education level of the offering
`offering_kind`	`VARCHAR`	Whether this is a course or program offering
`source_variable`	`VARCHAR`	Source questionnaire or file variable
`value_code`	`VARCHAR`	Coded source answer
`indicator_value`	`BOOLEAN`	Yes or no value of the offering flag
`collection_cycle`	`VARCHAR`	Reporting year for this observation
`reference_period_start`	`DATE`	Start of the period this number describes
`reference_period_end`	`DATE`	End of the period this number describes
`reference_period_label`	`VARCHAR`	Label for the period this number describes
`source_release_id`	`VARCHAR`	Which published release this row came from
`release_stage`	`VARCHAR`	Whether the selected release is provisional, final, or later revised
`publication_date`	`DATE`	When the source published this release
`applicability`	`VARCHAR`	Whether this number was measured here, borrowed from a broader field, or assumed from a mapping
`coverage_state`	`VARCHAR`	Whether the value is published, withheld, not collected, or does not apply
`source_file`	`VARCHAR`	Source file this row was read from
`source_member`	`VARCHAR`	Sheet or archive part inside that file
`source_row_number`	`BIGINT`	Row number in the source file
`source_sha256`	`VARCHAR`	Checksum of the source file
`ingested_at`	`TIMESTAMP`	When EduInsights loaded the source file
`imputation_flag`	`VARCHAR`	Source flag for imputed or estimated values
`value_label`	`VARCHAR`	Name of the coded answer
`offering_label`	`VARCHAR`	Name of the offering question
`publication_snapshot_id`	`VARCHAR`	Which EduInsights snapshot selected this release

martsmarts.ipeds_distance_offering_longitudinal

IPEDS distance offering longitudinal

Institution distance-offering observation. Snapshot-selected IPEDS institutional distance course/program offering flags at the questionnaire's education-level and source-variable grain. Flags describe institutional offering context, not student participation and not a named CatalogProgram. Preserve value labels, applicability, coverage, release, and row provenance.

Source and edition: Source details not yet documented
What one row represents: (unitid, education_level, offering_kind, source_variable, collection_cycle)
Rows: 771,951
File: 1.8 MB · Parquet

Checking

Show 24 columns

Schema and table: marts.ipeds_distance_offering_longitudinal
Ontology entity: Institution
Source fields: collection_cycle, reference_period_start, reference_period_end, reference_period_label, source_release_id, release_stage, publication_date, source_file, source_member, source_row_number, source_sha256, ingested_at, publication_snapshot_id
Ontology relationships: ScoringCohort → Institution; Institution → ProgramAwardCell; Institution → InstitutionSnapshot; Observation → Institution, ProgramAwardCell, ProgramFieldGroup, Occupation, Task, Industry, Geography, OccupationalLicenseSnapshot, ProfessionalAssociationEntry; Institution → Accreditor
Caveats: No separate caveat is documented. Review the dataset description and source notes.

Column	Type	Description
`unitid`	`VARCHAR`	Unique identification number of the institution
`education_level`	`VARCHAR`	Education level of the offering
`offering_kind`	`VARCHAR`	Whether this is a course or program offering
`source_variable`	`VARCHAR`	Source questionnaire or file variable
`value_code`	`VARCHAR`	Coded source answer
`indicator_value`	`BOOLEAN`	Yes or no value of the offering flag
`collection_cycle`	`VARCHAR`	Reporting year for this observation
`reference_period_start`	`DATE`	Start of the period this number describes
`reference_period_end`	`DATE`	End of the period this number describes
`reference_period_label`	`VARCHAR`	Label for the period this number describes
`source_release_id`	`VARCHAR`	Which published release this row came from
`release_stage`	`VARCHAR`	Whether the selected release is provisional, final, or later revised
`publication_date`	`DATE`	When the source published this release
`applicability`	`VARCHAR`	Whether this number was measured here, borrowed from a broader field, or assumed from a mapping
`coverage_state`	`VARCHAR`	Whether the value is published, withheld, not collected, or does not apply
`source_file`	`VARCHAR`	Source file this row was read from
`source_member`	`VARCHAR`	Sheet or archive part inside that file
`source_row_number`	`BIGINT`	Row number in the source file
`source_sha256`	`VARCHAR`	Checksum of the source file
`ingested_at`	`TIMESTAMP`	When EduInsights loaded the source file
`imputation_flag`	`VARCHAR`	Source flag for imputed or estimated values
`value_label`	`VARCHAR`	Name of the coded answer
`offering_label`	`VARCHAR`	Name of the offering question
`publication_snapshot_id`	`VARCHAR`	Which EduInsights snapshot selected this release

martsmarts.ipeds_distance_program_latest_final

IPEDS distance program latest final

ProgramFieldGroup distance-availability latest-final observation. Newest final/revised IPEDS C-DEP field/award distance-availability cell. This point-in-time convenience surface remains broader than a named catalog program and must retain native CIP vintage and publisher program level.

Source and edition: Source details not yet documented
What one row represents: (unitid, cip_code, cip_version, program_level_code, metric_code)
Rows: 16,754,020
File: 44 MB · Parquet

Checking

Show 28 columns

Schema and table: marts.ipeds_distance_program_latest_final
Ontology entity: Program Field Group
Source fields: collection_cycle, reference_period_start, reference_period_end, reference_period_label, source_release_id, release_stage, publication_date, source_file, source_member, source_row_number, source_sha256, ingested_at, publication_snapshot_id
Ontology relationships: ProgramFieldGroup → ProgramAwardCell; ProgramFieldGroup → Industry; Observation → Institution, ProgramAwardCell, ProgramFieldGroup, Occupation, Task, Industry, Geography, OccupationalLicenseSnapshot, ProfessionalAssociationEntry; ProgramFieldGroup → Accreditor
Caveats: No separate caveat is documented. Review the dataset description and source notes.

Column	Type	Description
`unitid`	`VARCHAR`	Unique identification number of the institution
`cip_code`	`VARCHAR`	Field-of-study code at the level published on this row
`cip_level`	`VARCHAR`	Whether the field code is broad, mid-level, or most specific
`cip_version`	`VARCHAR`	Which year's field-of-study list this code comes from
`program_level_code`	`VARCHAR`	Program or award level in the source file
`award_level_code`	`VARCHAR`	IPEDS award level code (AWLEVEL) kept as an unpadded string — '3' is an associate's degree, '5' a bachelor's, '7' a master's, '17'-'19' doctorates, and the remaining codes certificates. Labels are in ref.ipeds_dictionary_value under varname AWLEVEL.
`metric_code`	`VARCHAR`	Which distance or program metric this row is
`source_variable`	`VARCHAR`	Source questionnaire or file variable
`source_value`	`VARCHAR`	Value as published in the source file
`program_count`	`BIGINT`	Number of programs
`program_entity_type`	`VARCHAR`	What kind of program entity the source is counting
`collection_cycle`	`VARCHAR`	Reporting year for this observation
`reference_period_start`	`DATE`	Start of the period this number describes
`reference_period_end`	`DATE`	End of the period this number describes
`reference_period_label`	`VARCHAR`	Label for the period this number describes
`source_release_id`	`VARCHAR`	Which published release this row came from
`release_stage`	`VARCHAR`	Whether the selected release is provisional, final, or later revised
`publication_date`	`DATE`	When the source published this release
`applicability`	`VARCHAR`	Whether this number was measured here, borrowed from a broader field, or assumed from a mapping
`coverage_state`	`VARCHAR`	Whether the value is published, withheld, not collected, or does not apply
`source_file`	`VARCHAR`	Source file this row was read from
`source_member`	`VARCHAR`	Sheet or archive part inside that file
`source_row_number`	`BIGINT`	Row number in the source file
`source_sha256`	`VARCHAR`	Checksum of the source file
`ingested_at`	`TIMESTAMP`	When EduInsights loaded the source file
`imputation_flag`	`VARCHAR`	Source flag for imputed or estimated values
`metric_label`	`VARCHAR`	Name of the metric
`publication_snapshot_id`	`VARCHAR`	Which EduInsights snapshot selected this release

martsmarts.ipeds_distance_program_longitudinal

IPEDS distance program longitudinal

ProgramFieldGroup distance-availability observation. Snapshot-selected IPEDS C-DEP distance-program availability at UnitID × native CIP/vintage × publisher program/award level × metric × cycle. It is direct evidence for the published field/award availability cell, not proof of a particular named CatalogProgram. Preserve CIP level, applicability, coverage, release, and row provenance.

Source and edition: Source details not yet documented
What one row represents: (unitid, cip_code, cip_version, program_level_code, metric_code, collection_cycle)
Rows: 88,751,892
File: 213 MB · Parquet

Checking

Show 28 columns

Schema and table: marts.ipeds_distance_program_longitudinal
Ontology entity: Program Field Group
Source fields: collection_cycle, reference_period_start, reference_period_end, reference_period_label, source_release_id, release_stage, publication_date, source_file, source_member, source_row_number, source_sha256, ingested_at, publication_snapshot_id
Ontology relationships: ProgramFieldGroup → ProgramAwardCell; ProgramFieldGroup → Industry; Observation → Institution, ProgramAwardCell, ProgramFieldGroup, Occupation, Task, Industry, Geography, OccupationalLicenseSnapshot, ProfessionalAssociationEntry; ProgramFieldGroup → Accreditor
Caveats: No separate caveat is documented. Review the dataset description and source notes.

Column	Type	Description
`unitid`	`VARCHAR`	Unique identification number of the institution
`cip_code`	`VARCHAR`	Field-of-study code at the level published on this row
`cip_level`	`VARCHAR`	Whether the field code is broad, mid-level, or most specific
`cip_version`	`VARCHAR`	Which year's field-of-study list this code comes from
`program_level_code`	`VARCHAR`	Program or award level in the source file
`award_level_code`	`VARCHAR`	IPEDS award level code (AWLEVEL) kept as an unpadded string — '3' is an associate's degree, '5' a bachelor's, '7' a master's, '17'-'19' doctorates, and the remaining codes certificates. Labels are in ref.ipeds_dictionary_value under varname AWLEVEL.
`metric_code`	`VARCHAR`	Which distance or program metric this row is
`source_variable`	`VARCHAR`	Source questionnaire or file variable
`source_value`	`VARCHAR`	Value as published in the source file
`program_count`	`BIGINT`	Number of programsThis is published availability of a field and award, not proof of a named catalog program.
`program_entity_type`	`VARCHAR`	What kind of program entity the source is counting
`collection_cycle`	`VARCHAR`	Reporting year for this observation
`reference_period_start`	`DATE`	Start of the period this number describes
`reference_period_end`	`DATE`	End of the period this number describes
`reference_period_label`	`VARCHAR`	Label for the period this number describes
`source_release_id`	`VARCHAR`	Which published release this row came from
`release_stage`	`VARCHAR`	Whether the selected release is provisional, final, or later revised
`publication_date`	`DATE`	When the source published this release
`applicability`	`VARCHAR`	Whether this number was measured here, borrowed from a broader field, or assumed from a mapping
`coverage_state`	`VARCHAR`	Whether the value is published, withheld, not collected, or does not apply
`source_file`	`VARCHAR`	Source file this row was read from
`source_member`	`VARCHAR`	Sheet or archive part inside that file
`source_row_number`	`BIGINT`	Row number in the source file
`source_sha256`	`VARCHAR`	Checksum of the source file
`ingested_at`	`TIMESTAMP`	When EduInsights loaded the source file
`imputation_flag`	`VARCHAR`	Source flag for imputed or estimated values
`metric_label`	`VARCHAR`	Name of the metric
`publication_snapshot_id`	`VARCHAR`	Which EduInsights snapshot selected this release

martsmarts.ipeds_measure_comparability

IPEDS measure comparability

IPEDS measure Comparability State. Direct, mapped, or break state between releases. Mapped comparisons expose their transformation; Trend arithmetic is prohibited across a break.

Source and edition: Source details not yet documented
What one row represents: (measure_id, from_source_release_id, to_source_release_id)
Rows: 110
File: 3.8 KB · Parquet

Checking

Show 8 columns

Schema and table: marts.ipeds_measure_comparability
Ontology entity: Comparability Assessment
Source fields: publication_snapshot_id
Ontology relationships: No direct connection documented for this table
Caveats: No separate caveat is documented. Review the dataset description and source notes.

Column	Type	Description
`measure_id`	`VARCHAR`	Measure identifier
`from_source_release_id`	`VARCHAR`	Earlier release in a comparison
`to_source_release_id`	`VARCHAR`	Later release in a comparison
`comparability_state`	`VARCHAR`	Whether the two releases can be compared directly, only after a mapping, or not at all
`transformation`	`VARCHAR`	How a mapped comparison was constructed
`measure_name`	`VARCHAR`	Measure name
`unit`	`VARCHAR`	Unit of the number
`publication_snapshot_id`	`VARCHAR`	Which EduInsights snapshot selected this release

martsmarts.ipeds_measure_longitudinal

IPEDS measure longitudinal

IPEDS curated measure Observation. Curated, definition-backed IPEDS measures with native units, Reference Periods, Source Releases, coverage states, and Publication Snapshot identity.

Source and edition: Source details not yet documented
What one row represents: (unitid, measure_id, collection_cycle)
Rows: 556,964
File: 8.5 MB · Parquet

Checking

Show 24 columns

Schema and table: marts.ipeds_measure_longitudinal
Ontology entity: Observation
Source fields: collection_cycle, reference_period_start, reference_period_end, reference_period_label, source_release_id, release_stage, publication_date, source_file, source_member, source_row_number, source_sha256, ingested_at, publication_snapshot_id
Ontology relationships: Observation → MeasureDefinition; Observation → Institution, ProgramAwardCell, ProgramFieldGroup, Occupation, Task, Industry, Geography, OccupationalLicenseSnapshot, ProfessionalAssociationEntry; EvidenceClaim → Observation
Caveats: No separate caveat is documented. Review the dataset description and source notes.

Column	Type	Description
`unitid`	`VARCHAR`	Unique identification number of the institution
`measure_id`	`VARCHAR`	Measure identifier
`value_numeric`	`DOUBLE`	Numeric value
`coverage_state`	`VARCHAR`	Whether the value is published, withheld, not collected, or does not apply
`collection_cycle`	`VARCHAR`	Reporting year for this observation
`reference_period_start`	`DATE`	Start of the period this number describes
`reference_period_end`	`DATE`	End of the period this number describes
`reference_period_label`	`VARCHAR`	Label for the period this number describes
`source_release_id`	`VARCHAR`	Which published release this row came from
`release_stage`	`VARCHAR`	Whether the selected release is provisional, final, or later revised
`publication_date`	`DATE`	When the source published this release
`source_file`	`VARCHAR`	Source file this row was read from
`source_member`	`VARCHAR`	Sheet or archive part inside that file
`source_row_number`	`BIGINT`	Row number in the source file
`source_sha256`	`VARCHAR`	Checksum of the source file
`ingested_at`	`TIMESTAMP`	When EduInsights loaded the source file
`imputation_flag`	`VARCHAR`	Source flag for imputed or estimated values
`definition_version`	`VARCHAR`	Version of the measure definition
`measure_name`	`VARCHAR`	Measure name
`unit`	`VARCHAR`	Unit of the number
`population`	`VARCHAR`	Who is included in the measure
`method`	`VARCHAR`	How the measure or mapping was constructed
`definition`	`VARCHAR`	Full measure definition
`publication_snapshot_id`	`VARCHAR`	Which EduInsights snapshot selected this release

martsmarts.ipeds_publication_snapshot

IPEDS publication snapshot

IPEDS Publication Snapshot. Versioned release-selection manifests. is_active identifies the snapshot used to materialize the current serving artifact; older identifiers remain pin-able.

Source and edition: Source details not yet documented
What one row represents: (publication_snapshot_id)
Rows: 1
File: 978 B · Parquet

Checking

Show 5 columns

Schema and table: marts.ipeds_publication_snapshot
Ontology entity: Publication Snapshot
Source fields: publication_snapshot_id
Ontology relationships: PublicationSnapshot → SourceRelease
Caveats: No separate caveat is documented. Review the dataset description and source notes.

Column	Type	Description
`publication_snapshot_id`	`VARCHAR`	Which EduInsights snapshot selected this release
`created_at`	`TIMESTAMP`	When this snapshot was created
`is_default`	`BOOLEAN`	Whether this is the default snapshot
`is_active`	`BOOLEAN`	Whether this snapshot was used to build the current download
`source_release_count`	`BIGINT`	How many source releases this snapshot selected

martsmarts.ipeds_source_release

IPEDS source release

IPEDS Source Release. Accepted append-only IPEDS publications with independent Collection Cycle, Reference Period, release stage, publication date, and archive identity.

Source and edition: Source details not yet documented
What one row represents: (source_release_id)
Rows: 134
File: 9.2 KB · Parquet

Checking

Show 12 columns

Schema and table: marts.ipeds_source_release
Ontology entity: Source Release
Source fields: source_release_id, collection_cycle, reference_period_kind, reference_period_start, reference_period_end, reference_period_label, release_stage, publication_date
Ontology relationships: PublicationSnapshot → SourceRelease
Caveats: No separate caveat is documented. Review the dataset description and source notes.

Column	Type	Description
`source_release_id`	`VARCHAR`	Which published release this row came from
`publisher`	`VARCHAR`	Publishing agency
`component`	`VARCHAR`	Which IPEDS survey this release belongs to
`collection_cycle`	`VARCHAR`	Reporting year for this observation
`reference_period_kind`	`VARCHAR`	What kind of period this is, such as a fall snapshot or academic year
`reference_period_start`	`DATE`	Start of the period this number describes
`reference_period_end`	`DATE`	End of the period this number describes
`reference_period_label`	`VARCHAR`	Label for the period this number describes
`release_stage`	`VARCHAR`	Whether the selected release is provisional, final, or later revised
`publication_date`	`DATE`	When the source published this release
`accepted`	`BOOLEAN`	Whether EduInsights accepted this release
`archive_id`	`VARCHAR`	Archive identifier for the source files

martsmarts.macro_ai_signal

Macro AI signal

macro AI context. Macro AI context for narrative framing: Stanford AI Index 2026 indicators (economy, education, policy, public opinion) plus the Anthropic Economic Index augmentation-vs-automation split of Claude usage. Not education-entity data — no unitid/cip6/soc6 keys; join nothing to it, cite it.

Source and edition: Source details not yet documented
What one row represents: (year, indicator, series)
Rows: 850
File: 9.8 KB · Parquet

Checking

Show 9 columns

Schema and table: marts.macro_ai_signal
Ontology entity: Observation
Source fields: edition
Ontology relationships: Observation → MeasureDefinition; Observation → Institution, ProgramAwardCell, ProgramFieldGroup, Occupation, Task, Industry, Geography, OccupationalLicenseSnapshot, ProfessionalAssociationEntry; EvidenceClaim → Observation
Caveats: No separate caveat is documented. Review the dataset description and source notes.

Column	Type	Description
`year`	`VARCHAR`	Year
`indicator`	`VARCHAR`	Named indicator
`series`	`VARCHAR`	Series within the indicator
`value`	`VARCHAR`	Published valueCite this as national context. Do not join it to a campus, field, or occupation.
`unit`	`VARCHAR`	Unit of the number
`chapter`	`VARCHAR`	Source chapter or theme
`figure`	`VARCHAR`	Source figure
`source_org`	`VARCHAR`	Organization that published the indicator
`edition`	`VARCHAR`	Edition of the source

martsmarts.microsoft_occupation_ai_use

Microsoft occupation AI use

Occupation AI-assisted-work observation. Microsoft Working with AI v1.1 metrics for U.S. Bing Copilot conversations from 2024-01-01 through 2024-09-30, at detailed 2018 SOC grain. This is product-specific empirical_calibration of observed assistance and must not be described as universal AI exposure, automation, replacement risk, or a forecast.

Source and edition: microsoft_working_with_ai · 2025-12-22-c94a07c52fb1
What one row represents: (soc_version, soc6)
Rows: 785
File: 85 KB · Parquet

Checking

Show 30 columns

Schema and table: marts.microsoft_occupation_ai_use
Ontology entity: Occupation
Source fields: source, source_version, source_file, source_member, source_row_number, source_row_key, source_sha256, ingested_at
Ontology relationships: CIPField → Occupation; DetailedOccupation → Occupation; Occupation → Skill; Observation → Institution, ProgramAwardCell, ProgramFieldGroup, Occupation, Task, Industry, Geography, OccupationalLicenseSnapshot, ProfessionalAssociationEntry; PublisherClassification → Occupation
Caveats: No separate caveat is documented. Review the dataset description and source notes.

Column	Type	Description
`soc6`	`VARCHAR`	Detailed occupation code
`soc_version`	`VARCHAR`	Which year's occupation list this code comes from
`occupation_title`	`VARCHAR`	Occupation name
`ai_applicability_score`	`DOUBLE`	Working with AI applicability value published for this occupation, carried through unchanged. It describes observed Bing Copilot assistance, not job replacement.
`coverage_user`	`DOUBLE`	Working with AI coverage value for this occupation, taken from the study's user column and carried through unchanged.
`coverage_ai`	`DOUBLE`	Working with AI coverage value for this occupation, taken from the study's AI column and carried through unchanged.
`completion_user`	`DOUBLE`	Working with AI completion value for this occupation, taken from the study's user column and carried through unchanged.
`completion_ai`	`DOUBLE`	Working with AI completion value for this occupation, taken from the study's AI column and carried through unchanged.
`feedback_positive_fraction_user`	`DOUBLE`	Working with AI positive feedback fraction value for this occupation, taken from the study's user column and carried through unchanged.
`feedback_positive_fraction_ai`	`DOUBLE`	Working with AI positive feedback fraction value for this occupation, taken from the study's AI column and carried through unchanged.
`impact_scope_user`	`DOUBLE`	Working with AI impact scope value for this occupation, taken from the study's user column and carried through unchanged.
`impact_scope_ai`	`DOUBLE`	Working with AI impact scope value for this occupation, taken from the study's AI column and carried through unchanged.
`ai_applicability_score_user`	`DOUBLE`	Working with AI applicability value for this occupation computed on the study's user column. It describes observed Bing Copilot assistance, not job replacement.
`ai_applicability_score_ai_nonphysical`	`DOUBLE`	Working with AI applicability value computed on the study's AI column over non-physical tasks only. It describes observed Bing Copilot assistance, not job replacement.
`observation_start`	`DATE`	First day of the study window these values cover.
`observation_end`	`DATE`	Last day of the study window these values cover.
`study_population`	`VARCHAR`	Population the study observed: United States Bing Copilot conversations. These values describe observed assistance in one product, not AI use everywhere and not job replacement.
`applicability`	`VARCHAR`	Whether this number was measured here, borrowed from a broader field, or assumed from a mapping
`caveat`	`VARCHAR`	Interpretation limit carried with every Working with AI occupation row
`source`	`VARCHAR`	Name of the dataset that supplied this row
`source_version`	`VARCHAR`	Version of the source dataset
`source_file`	`VARCHAR`	Source file this row was read from
`source_member`	`VARCHAR`	Sheet or archive part inside that file
`source_row_number`	`BIGINT`	Row number in the source file
`source_row_key`	`VARCHAR`	Stable key for this source row
`source_sha256`	`VARCHAR`	Checksum of the source file
`ingested_at`	`TIMESTAMP`	When EduInsights loaded the source file
`metric_source_file`	`VARCHAR`	Source file the occupation metric row was read from, kept apart from the applicability-score file named in source_file
`metric_source_row_key`	`VARCHAR`	Stable key for the occupation metric row joined onto this row
`metric_source_sha256`	`VARCHAR`	Checksum of the source file the occupation metric row was read from

martsmarts.nc_tower_program_outcome

Nc tower program outcome

NC TOWER ProgramFieldGroup outcome observation. NC TOWER direct observed cohort outcomes for participating NCCCS and UNC campuses, restricted to the publisher's All-gender/All-race rows for serving. Campus-to-UnitID and CIP-vintage resolution remain unresolved; -1 is suppression, never zero. Campus labels and publisher program rows must not be silently joined to the institution/program spine.

Source and edition: nc_tower · snapshot-2026-08-25-c505cef9d5
What one row represents: (source_version, source_file, source_row_number)
Rows: 1,755,783
File: 15 MB · Parquet

Checking

Show 37 columns

Schema and table: marts.nc_tower_program_outcome
Ontology entity: Program Field Group
Source fields: source, source_version, source_file, source_member, source_row_number, source_row_key, source_sha256, ingested_at
Ontology relationships: ProgramFieldGroup → ProgramAwardCell; ProgramFieldGroup → Industry; Observation → Institution, ProgramAwardCell, ProgramFieldGroup, Occupation, Task, Industry, Geography, OccupationalLicenseSnapshot, ProfessionalAssociationEntry; ProgramFieldGroup → Accreditor
Caveats: No separate caveat is documented. Review the dataset description and source notes.

Column	Type	Description
`source_system`	`VARCHAR`	Which North Carolina system reported the row, the community college system or the university system
`agency`	`VARCHAR`	Name of the state agency that published the row
`campus_name`	`VARCHAR`	Campus label exactly as the publisher wrote it. It has not been resolved to an institution ID and must not be joined to campuses by name.
`unitid`	`VARCHAR`	Unique identification number of the institution
`institution_coverage_state`	`VARCHAR`	Whether the campus on this row has been resolved to an institution ID. It is always unresolved, so the campus label carries no institution key.
`publisher_program_code`	`VARCHAR`	Program code exactly as the publisher wrote it, which is not a field-of-study code and is not resolved to a catalog program
`program_name`	`VARCHAR`	Specialized program name from DAPIP
`credential`	`VARCHAR`	Credential the cohort earned as the publisher names it, such as Certificate, Diploma, Associate's Degree, or Bachelor's Degree
`cohort_year`	`INTEGER`	School year in which this graduating cohort finished
`followup_year`	`INTEGER`	How many years after graduation this follow-up row measures
`publisher_cip6`	`VARCHAR`	Six-digit field-of-study code exactly as the publisher wrote it, padded to six characters. The list year behind it is unresolved.
`cip_version`	`VARCHAR`	Which year's field-of-study list this code comes from
`graduates`	`BIGINT`	Number of graduates the publisher counts in this cohort row. Blank where the publisher suppressed the count, which is never zero.
`graduates_coverage_state`	`VARCHAR`	Whether the graduate count is published, suppressed, or not collected. The publisher's -1 means suppressed and is never zero.
`employed`	`BIGINT`	Number of those graduates the publisher found employed at this follow-up point. Blank where the publisher suppressed the count, which is never zero.
`employed_coverage_state`	`VARCHAR`	Whether the employed count is published, suppressed, or not collected. The publisher's -1 means suppressed and is never zero.
`mean_wage`	`BIGINT`	Mean wage the publisher reports for the employed graduates on this row, carried through unchanged. Blank where suppressed, which is never zero.
`mean_wage_coverage_state`	`VARCHAR`	Whether the mean wage is published, suppressed, or not collected. The publisher's -1 means suppressed and is never zero.
`median_wage`	`BIGINT`	Median wage the publisher reports for the employed graduates on this row, carried through unchanged. Blank where suppressed, which is never zero.
`median_wage_coverage_state`	`VARCHAR`	Whether the median wage is published, suppressed, or not collected. The publisher's -1 means suppressed and is never zero.
`wage_25th_percentile`	`BIGINT`	Twenty-fifth-percentile wage the publisher reports for the employed graduates on this row. Blank where suppressed, which is never zero.
`wage_25th_percentile_coverage_state`	`VARCHAR`	Whether the 25th-percentile wage is published, suppressed, or not collected. The publisher's -1 means suppressed and is never zero.
`wage_75th_percentile`	`BIGINT`	Seventy-fifth-percentile wage the publisher reports for the employed graduates on this row. Blank where suppressed, which is never zero.
`wage_75th_percentile_coverage_state`	`VARCHAR`	Whether the 75th-percentile wage is published, suppressed, or not collected. The publisher's -1 means suppressed and is never zero.
`enrolled`	`BIGINT`	Number of those graduates the publisher reports as enrolled at this follow-up point. Blank where suppressed, which is never zero.
`enrolled_coverage_state`	`VARCHAR`	Whether the enrolled count is published, suppressed, or not collected. The publisher's -1 means suppressed and is never zero.
`enrolled_or_employed`	`BIGINT`	Number of those graduates the publisher reports as either enrolled or employed at this follow-up point. Blank where suppressed, which is never zero.
`enrolled_or_employed_coverage_state`	`VARCHAR`	Whether the enrolled-or-employed count is published, suppressed, or not collected. The publisher's -1 means suppressed and is never zero.
`applicability`	`VARCHAR`	Whether this number was measured here, borrowed from a broader field, or assumed from a mapping
`source`	`VARCHAR`	Name of the dataset that supplied this row
`source_version`	`VARCHAR`	Version of the source dataset
`source_file`	`VARCHAR`	Source file this row was read from
`source_member`	`VARCHAR`	Sheet or archive part inside that file
`source_row_number`	`BIGINT`	Row number in the source file
`source_row_key`	`VARCHAR`	Stable key for this source row
`source_sha256`	`VARCHAR`	Checksum of the source file
`ingested_at`	`TIMESTAMP`	When EduInsights loaded the source file

martsmarts.nces_bandb_national_cohort_context

Nces bandb national cohort context

NCES B&B national cohort context. Baccalaureate and Beyond published aggregate estimates with publisher standard errors at publication-table, characteristic, and measure grain. National cohort statistics only — no institution, CIP, or SOC key; interpret_with_caution and rounds-to-zero publisher flags remain visible, and a blank estimate is never zero.

Source and edition: nces_bandb · snapshot-2026-08-25-418decaa0f
What one row represents: (table_number, characteristic_sequence, measure_id)
Rows: 1,629
File: 43 KB · Parquet

Checking

Show 38 columns

Schema and table: marts.nces_bandb_national_cohort_context
Ontology entity: Observation
Source fields: source_release_id, source, source_version, source_file, source_member, source_row_number, source_row_key, source_sha256, ingested_at
Ontology relationships: Observation → MeasureDefinition; Observation → Institution, ProgramAwardCell, ProgramFieldGroup, Occupation, Task, Industry, Geography, OccupationalLicenseSnapshot, ProfessionalAssociationEntry; EvidenceClaim → Observation
Caveats: No separate caveat is documented. Review the dataset description and source notes.

Column	Type	Description
`source_release_id`	`VARCHAR`	Which published release this row came from
`publication_id`	`VARCHAR`	NCES publication identifier for this published B&B table.
`table_number`	`VARCHAR`	Table number within the pinned B&B:16/20 first-look publication.
`table_title`	`VARCHAR`	Full title of the published B&B table.
`study_population`	`VARCHAR`	Bachelor’s-degree cohort represented by this published estimate.
`observation_year`	`INTEGER`	Year of the four-year B&B follow-up observation.
`geography_scope`	`VARCHAR`	Jurisdictions included in the published national cohort.
`characteristic_sequence`	`INTEGER`	Published row order of this cohort characteristic within the table.
`characteristic_group`	`VARCHAR`	Published group that contains this cohort characteristic.
`characteristic_label`	`VARCHAR`	Published cohort characteristic for this estimate.
`measure_id`	`VARCHAR`	Measure identifier
`measure_label`	`VARCHAR`	Plain-language label for the published table measure.
`unit`	`VARCHAR`	Unit of the number
`estimate`	`DOUBLE`	Published aggregate estimate for this cohort characteristic and measure.National B&B cohort context, not an institution or program outcome.
`estimate_display`	`VARCHAR`	Estimate text as displayed in the NCES workbook, including symbols.
`coverage_state`	`VARCHAR`	Whether the value is published, withheld, not collected, or does not apply
`publisher_flag`	`VARCHAR`	NCES annotation attached to the published estimate, when present.
`interpret_with_caution`	`BOOLEAN`	Whether NCES marks the estimate with an interpret-with-caution flag.
`rounds_to_zero`	`BOOLEAN`	Whether NCES reports that the estimate rounds to zero.
`standard_error`	`DOUBLE`	Published standard error paired to this aggregate estimate.National B&B cohort context, not an institution or program outcome.
`standard_error_display`	`VARCHAR`	Standard-error text as displayed in the NCES workbook, including symbols.
`standard_error_coverage_state`	`VARCHAR`	Whether the standard error is published, not collected, or does not apply.
`standard_error_rounds_to_zero`	`BOOLEAN`	Whether NCES reports that the standard error rounds to zero.
`applicability`	`VARCHAR`	Whether this number was measured here, borrowed from a broader field, or assumed from a mapping
`caveat`	`VARCHAR`	Interpretation limit carried with every B&B aggregate row.
`source`	`VARCHAR`	Source dataset that published this aggregate row.
`source_version`	`VARCHAR`	Version of the source dataset
`source_file`	`VARCHAR`	Source file this row was read from
`source_member`	`VARCHAR`	Sheet or archive part inside that file
`source_row_number`	`BIGINT`	Row number in the source file
`source_row_key`	`VARCHAR`	Stable key for this source row
`source_sha256`	`VARCHAR`	Checksum of the source file
`standard_error_source_file`	`VARCHAR`	Source workbook containing the paired standard error.
`standard_error_source_member`	`VARCHAR`	Worksheet containing the paired standard error.
`standard_error_source_row_number`	`BIGINT`	Row number of the paired standard error in its source worksheet.
`standard_error_source_row_key`	`VARCHAR`	Stable source-row key for the paired standard error.
`standard_error_source_sha256`	`VARCHAR`	Checksum of the workbook containing the paired standard error.
`ingested_at`	`TIMESTAMP`	When EduInsights loaded the source file

martsmarts.nscg_degree_occupation_alignment

Nscg degree occupation alignment

Weighted graduate degree-field/job alignment context. NSCG 2023 weighted degree-field, principal-job, job-relatedness, earnings, and salary context. Cells under 30 public-use respondents have measures suppressed by an EduInsights minimum-cell policy, not an NCSES publisher flag. NSCG publisher classifications are not silently recast as CIP/SOC, and this is not a named-institution outcome.

Source and edition: nscg · 2023-snapshot-2026-08-25
What one row represents: (source_version, survey_year, highest_degree_type_code, highest_degree_field_code, principal_job_occupation_code, highest_degree_job_relatedness_code, sex_code, race_ethnicity_code)
Rows: 37,667
File: 809 KB · Parquet

Checking

Show 25 columns

Schema and table: marts.nscg_degree_occupation_alignment
Ontology entity: Publisher Classification
Source fields: source_version, source, source_file, source_member, source_row_number, source_row_key, source_sha256, ingested_at
Ontology relationships: PublisherClassification → CIPField; PublisherClassification → Occupation; ProfessionalAssociationEntry → PublisherClassification; PublisherClassification → DetailedOccupation; PublisherClassification → Industry
Caveats: No separate caveat is documented. Review the dataset description and source notes.

Column	Type	Description
`source_version`	`VARCHAR`	Version of the source dataset
`survey_year`	`INTEGER`	Survey year the respondent's answers describe
`highest_degree_type_code`	`VARCHAR`	Publisher code for the type of degree the respondent earned as their highest degree
`highest_degree_field_code`	`VARCHAR`	Publisher code for the major field of study of the respondent's highest degree. It is a survey education code, not a field-of-study code.
`degree_field_taxonomy`	`VARCHAR`	Name of the publisher classification the degree-field code belongs to, kept on the row so the code is never read as a field-of-study code
`principal_job_occupation_code`	`VARCHAR`	Publisher code for the job category that best describes the respondent's principal job. It is a survey job code, not an occupation code such as 15-1252.
`occupation_taxonomy`	`VARCHAR`	Name of the publisher classification the job code belongs to, kept on the row so the code is never read as an occupation code
`highest_degree_job_relatedness_code`	`VARCHAR`	Publisher code for how closely the respondent's principal job was related to their highest degree
`sex_code`	`VARCHAR`	Sex as published
`race_ethnicity_code`	`VARCHAR`	Publisher race and ethnicity code, derived by the survey from reported information
`sample_count`	`BIGINT`	Unweighted number of public-use respondents behind this cell, and the count the minimum-cell rule is applied to
`weighted_respondents`	`DOUBLE`	Sum of the final survey weights in this cell, an estimated population count. Blank where fewer than 30 respondents fall in the cell, which is never zero.
`weighted_mean_earned_income`	`DOUBLE`	Weight-adjusted mean of total earned income before deductions in the previous year. Blank where fewer than 30 respondents fall in the cell, which is never zero.
`weighted_mean_annualized_salary`	`DOUBLE`	Weight-adjusted mean of the basic annual salary on the principal job, before deductions. Blank where fewer than 30 respondents fall in the cell, which is never zero.
`coverage_state`	`VARCHAR`	Whether the value is published, withheld, not collected, or does not apply
`applicability`	`VARCHAR`	Whether this number was measured here, borrowed from a broader field, or assumed from a mapping
`caveat`	`VARCHAR`	Interpretation limit carried with every survey aggregate row
`source`	`VARCHAR`	Name of the dataset that supplied this row
`source_file`	`VARCHAR`	Source file this row was read from
`source_member`	`VARCHAR`	Sheet or archive part inside that file
`source_row_number`	`BIGINT`	Always blank in this mart — each alignment cell aggregates many NSCG microdata rows, so no single source row applies.
`source_row_count`	`BIGINT`	How many source respondent records were combined into this row
`source_row_key`	`VARCHAR`	Stable key for this source row
`source_sha256`	`VARCHAR`	Checksum of the source file
`ingested_at`	`TIMESTAMP`	When EduInsights loaded the source file

martsmarts.occupation

Occupation

One row per detailed SOC-2018 occupation: OEWS wages (May 2025), BLS Employment Projections 2024-34, Anthropic Economic Index exposure (observed Claude usage, empirical_calibration — not universal AI exposure), O*NET job zone, task-level AI rollups (n_tasks, ai_task_coverage, ai_task_penetration_wtd — importance-weighted mean AEI penetration over rated tasks), and per-source coverage flags. When wages/outlook are missing check aggregate_soc — BLS may publish the occupation only inside a combined code.

Source and edition: Source details not yet documented
What one row represents: (soc6)
Rows: 879
File: 45 KB · Parquet

Checking

Show 26 columns

Schema and table: marts.occupation
Ontology entity: Occupation
Source fields: Source fields not listed separately
Ontology relationships: CIPField → Occupation; DetailedOccupation → Occupation; Occupation → Skill; Observation → Institution, ProgramAwardCell, ProgramFieldGroup, Occupation, Task, Industry, Geography, OccupationalLicenseSnapshot, ProfessionalAssociationEntry; PublisherClassification → Occupation
Caveats: No separate caveat is documented. Review the dataset description and source notes.

Column	Type	Description
`soc6`	`VARCHAR`	Detailed occupation code
`occupation_title`	`VARCHAR`	Occupation name
`employment_current`	`BIGINT`	Current employment
`wage_annual_median`	`DOUBLE`	Annual median wage
`wage_topcoded`	`BOOLEAN`	Whether the published wage is top-coded
`a_pct25`	`DOUBLE`	25th-percentile annual wage
`a_pct75`	`DOUBLE`	75th-percentile annual wage
`employment_2024`	`BIGINT`	Employment in the base year 2024
`employment_2034`	`BIGINT`	Projected employment in 2034
`projected_growth_pct`	`DOUBLE`	Projected percent change in employment
`annual_openings_avg`	`BIGINT`	Average annual job openings
`entry_education`	`VARCHAR`	Typical education needed for entry
`ai_exposure_score`	`DOUBLE`	Share of published Claude conversations linked to this occupationThis is Claude use in the published Anthropic data, not how exposed every worker in the occupation is to AI.
`ai_exposure_release`	`VARCHAR`	Anthropic release used for the occupation score
`job_zone`	`BIGINT`	O*NET job zone, a 1 to 5 preparation scale
`n_tasks`	`BIGINT`	Number of tasks
`ai_task_coverage`	`DOUBLE`	Share of tasks with an observed Claude-use score
`ai_task_penetration_wtd`	`DOUBLE`	Importance-weighted average of observed Claude use across tasksThis is observed Claude use across tasks, not a forecast of automation.
`in_crosswalk`	`BOOLEAN`	Whether this occupation appears in the field-to-occupation map
`publisher_unmappable`	`BOOLEAN`	Whether the source says this field has no occupation match
`has_oews`	`BOOLEAN`	Whether current wage and employment data exist
`has_ep`	`BOOLEAN`	Whether a 10-year employment projection exists
`has_aei_exposure`	`BOOLEAN`	Whether an Anthropic occupation score exists
`has_onet_tasks`	`BOOLEAN`	Whether O*NET task ratings exist
`reachable_from_completions`	`BOOLEAN`	Whether any reported field of study maps to this occupation
`aggregate_soc`	`VARCHAR`	Combined occupation code used when wages are published only for a group

martsmarts.occupation_requirement

Occupation requirement

Occupation requirement observation. BLS Occupational Requirements Survey estimates at publisher occupation, requirement, category, datatype, and series grain. The 2018 and 2023 waves are final; 2025 is preliminary. Successive ORS releases are not a time series, and 2018 O*NET-SOC 2010 codes remain distinct from 2018 SOC codes.

Source and edition: bls_ors · through-2025-snapshot-2026-08-25-a9a61381dd
What one row represents: (reference_year, series_id)
Rows: 236,468
File: 3.6 MB · Parquet

Checking

Show 37 columns

Schema and table: marts.occupation_requirement
Ontology entity: Occupation
Source fields: release_stage, source, source_version, source_file, source_member, source_row_number, source_row_key, source_sha256, ingested_at
Ontology relationships: CIPField → Occupation; DetailedOccupation → Occupation; Occupation → Skill; Observation → Institution, ProgramAwardCell, ProgramFieldGroup, Occupation, Task, Industry, Geography, OccupationalLicenseSnapshot, ProfessionalAssociationEntry; PublisherClassification → Occupation
Caveats: No separate caveat is documented. Review the dataset description and source notes.

Column	Type	Description
`reference_year`	`INTEGER`	Survey year of the workbook this estimate comes from
`release_stage`	`VARCHAR`	Whether the selected release is provisional, final, or later revised
`occupation_taxonomy`	`VARCHAR`	Which occupation list the workbook was coded to, either the standard occupation list or the O*NET list
`occupation_version`	`VARCHAR`	Which year's occupation list the workbook was coded to
`source_occupation_code`	`VARCHAR`	Occupation code exactly as the workbook published it, without separators
`soc6`	`VARCHAR`	Detailed occupation code
`onet_soc_code`	`VARCHAR`	More specific occupation code used by O*NET
`occupation_title`	`VARCHAR`	Occupation name
`series_id`	`VARCHAR`	Publisher identifier for the estimate series this row belongs to
`series_title`	`VARCHAR`	Publisher title describing the estimate series
`requirement`	`VARCHAR`	Job requirement the estimate measures, such as a physical demand or an education level
`estimate_code`	`VARCHAR`	Publisher code for the kind of estimate on this row
`estimate_text`	`VARCHAR`	Publisher wording for the kind of estimate on this row
`category_code`	`VARCHAR`	Publisher code for the requirement category the estimate falls in
`category`	`VARCHAR`	Publisher name of the requirement category the estimate falls in
`additive_code`	`VARCHAR`	Publisher code saying whether the estimate can be added to other estimates in its category
`additive`	`VARCHAR`	Publisher wording saying whether the estimate can be added to other estimates in its category
`datatype_code`	`VARCHAR`	Publisher code for the unit the estimate is expressed in
`datatype`	`VARCHAR`	Publisher wording for the unit the estimate is expressed in
`estimate_raw`	`VARCHAR`	Estimate exactly as the workbook published it, including any marker the publisher used for an unavailable value
`estimate`	`DOUBLE`	Estimate as a number; blank when the publisher did not report a value, which is never the same as zero
`standard_error_raw`	`VARCHAR`	Standard error exactly as the workbook published it
`standard_error`	`DOUBLE`	Standard error of the estimate as a number
`data_footnote`	`VARCHAR`	Publisher footnote code attached to the estimate
`standard_error_footnote`	`VARCHAR`	Publisher footnote code attached to the standard error
`series_footnote`	`VARCHAR`	Publisher footnote code attached to the estimate series
`coverage_state`	`VARCHAR`	Whether the value is published, withheld, not collected, or does not apply
`applicability`	`VARCHAR`	Whether this number was measured here, borrowed from a broader field, or assumed from a mapping
`comparability_note`	`VARCHAR`	Standing warning that successive survey releases and waves are not a time series
`source`	`VARCHAR`	Name of the dataset that supplied this row
`source_version`	`VARCHAR`	Version of the source dataset
`source_file`	`VARCHAR`	Source file this row was read from
`source_member`	`VARCHAR`	Sheet or archive part inside that file
`source_row_number`	`BIGINT`	Row number in the source file
`source_row_key`	`VARCHAR`	Stable key for this source row
`source_sha256`	`VARCHAR`	Checksum of the source file
`ingested_at`	`TIMESTAMP`	When EduInsights loaded the source file

martsmarts.occupation_task

Occupation task

One row per O*NET task within an occupation: task statement, importance/frequency/relevance ratings, and Anthropic Economic Index task penetration (observed Claude usage share matched to the task — empirical_calibration, not universal AI capability). Rows with in_onet_ratings=false are AEI-matched tasks absent from the current O*NET ratings file.

Source and edition: Source details not yet documented
What one row represents: (soc6, task_id)
Rows: 19,368
File: 877 KB · Parquet

Checking

Show 14 columns

Schema and table: marts.occupation_task
Ontology entity: Task
Source fields: Source fields not listed separately
Ontology relationships: DetailedOccupation → Task; Observation → Institution, ProgramAwardCell, ProgramFieldGroup, Occupation, Task, Industry, Geography, OccupationalLicenseSnapshot, ProfessionalAssociationEntry; ConversationCluster → Task
Caveats: No separate caveat is documented. Review the dataset description and source notes.

Column	Type	Description
`soc6`	`VARCHAR`	Detailed occupation code
`occupation_title`	`VARCHAR`	Occupation name
`task_id`	`BIGINT`	Task identifier
`task_text`	`VARCHAR`	Task statement
`task_type`	`VARCHAR`	Kind of task
`importance`	`DOUBLE`	How important the task is in the occupation
`frequency`	`DOUBLE`	How often the task is performed
`relevance`	`DOUBLE`	Whether the task is relevant to the occupation
`in_onet_ratings`	`BOOLEAN`	Whether this task appears in the current O*NET ratings file
`ai_penetration_score`	`DOUBLE`	Share of published Claude conversations linked to this taskThis is observed Claude use linked to the task, not a measure of whether the task can be automated.
`ai_match_method`	`VARCHAR`	How the Claude-use row was matched to this task
`ai_match_score`	`DOUBLE`	How close that text match was
`ai_release`	`VARCHAR`	Anthropic release used for the task score
`ai_applicability`	`VARCHAR`	Whether the Claude-use score is observed calibration, not a forecast

martsmarts.oews_all_published_observations

Oews all published observations

Occupation employment and wage publisher observation. All published May 2025 OEWS rows across national, state, metro/nonmetro, and all-area packages, including overlapping area/industry surfaces at their publisher grain. Do not sum across source packages. Retain NAICS, area type, suppression, top-coding, source member, row, and SHA-256 when selecting evidence.

Source and edition: Source details not yet documented
What one row represents: (source_release, source_package, source_file, source_row_number)
Rows: 651,048
File: 34 MB · Parquet

Checking

Show 80 columns

Schema and table: marts.oews_all_published_observations
Ontology entity: Occupation
Source fields: source_release, source_file, source_member, source_row_number, source_sha256, source_row_key, ingested_at
Ontology relationships: CIPField → Occupation; DetailedOccupation → Occupation; Occupation → Skill; Observation → Institution, ProgramAwardCell, ProgramFieldGroup, Occupation, Task, Industry, Geography, OccupationalLicenseSnapshot, ProfessionalAssociationEntry; PublisherClassification → Occupation
Caveats: No separate caveat is documented. Review the dataset description and source notes.

Column	Type	Description
`source_release`	`VARCHAR`	Which published release this row came from
`source_package`	`VARCHAR`	Which published package this row came from
`geography_code`	`VARCHAR`	Place code
`geography_name`	`VARCHAR`	Place name
`geography_type`	`VARCHAR`	Whether this is the nation, a state, a metro area, or another place type
`area_type`	`VARCHAR`	Source area type
`prim_state`	`VARCHAR`	Primary state
`naics`	`VARCHAR`	Industry code
`naics_title`	`VARCHAR`	Industry name
`i_group`	`VARCHAR`	Industry grouping
`own_code`	`VARCHAR`	Ownership code
`annual`	`VARCHAR`	Whether an annual wage is published
`hourly`	`VARCHAR`	Whether an hourly wage is published
`soc6`	`VARCHAR`	Detailed occupation code
`occupation_title`	`VARCHAR`	Occupation name
`occupation_level`	`VARCHAR`	Whether this is a detailed occupation or a broader group
`soc_version`	`VARCHAR`	Which year's occupation list this code comes from
`naics_version`	`VARCHAR`	Which year's industry list this code comes from
`tot_emp`	`DOUBLE`	Employment
`emp_prse`	`DOUBLE`	Relative standard error of employment
`jobs_1000`	`DOUBLE`	Jobs per 1,000
`loc_quotient`	`DOUBLE`	Location quotient
`pct_total`	`DOUBLE`	Percent of total employment
`h_mean`	`DOUBLE`	Mean hourly wage
`a_mean`	`DOUBLE`	Mean annual wage
`mean_prse`	`DOUBLE`	Relative standard error of the mean wage
`h_pct10`	`DOUBLE`	10th-percentile hourly wage
`h_pct25`	`DOUBLE`	25th-percentile hourly wage
`h_median`	`DOUBLE`	Median hourly wage
`h_pct75`	`DOUBLE`	75th-percentile hourly wage
`h_pct90`	`DOUBLE`	90th-percentile hourly wage
`a_pct10`	`DOUBLE`	10th-percentile annual wage
`a_pct25`	`DOUBLE`	25th-percentile annual wage
`a_median`	`DOUBLE`	Median annual wage
`a_pct75`	`DOUBLE`	75th-percentile annual wage
`a_pct90`	`DOUBLE`	90th-percentile annual wage
`tot_emp_coverage_state`	`VARCHAR`	Whether this wage or employment figure is published, withheld, or not collected
`tot_emp_topcoded`	`BOOLEAN`	Whether this wage is published as a top-coded amount
`emp_prse_coverage_state`	`VARCHAR`	Whether this wage or employment figure is published, withheld, or not collected
`emp_prse_topcoded`	`BOOLEAN`	Whether this wage is published as a top-coded amount
`jobs_1000_coverage_state`	`VARCHAR`	Whether this wage or employment figure is published, withheld, or not collected
`jobs_1000_topcoded`	`BOOLEAN`	Whether this wage is published as a top-coded amount
`loc_quotient_coverage_state`	`VARCHAR`	Whether this wage or employment figure is published, withheld, or not collected
`loc_quotient_topcoded`	`BOOLEAN`	Whether this wage is published as a top-coded amount
`pct_total_coverage_state`	`VARCHAR`	Whether this wage or employment figure is published, withheld, or not collected
`pct_total_topcoded`	`BOOLEAN`	Whether this wage is published as a top-coded amount
`h_mean_coverage_state`	`VARCHAR`	Whether this wage or employment figure is published, withheld, or not collected
`h_mean_topcoded`	`BOOLEAN`	Whether this wage is published as a top-coded amount
`a_mean_coverage_state`	`VARCHAR`	Whether this wage or employment figure is published, withheld, or not collected
`a_mean_topcoded`	`BOOLEAN`	Whether this wage is published as a top-coded amount
`mean_prse_coverage_state`	`VARCHAR`	Whether this wage or employment figure is published, withheld, or not collected
`mean_prse_topcoded`	`BOOLEAN`	Whether this wage is published as a top-coded amount
`h_pct10_coverage_state`	`VARCHAR`	Whether this wage or employment figure is published, withheld, or not collected
`h_pct10_topcoded`	`BOOLEAN`	Whether this wage is published as a top-coded amount
`h_pct25_coverage_state`	`VARCHAR`	Whether this wage or employment figure is published, withheld, or not collected
`h_pct25_topcoded`	`BOOLEAN`	Whether this wage is published as a top-coded amount
`h_median_coverage_state`	`VARCHAR`	Whether this wage or employment figure is published, withheld, or not collected
`h_median_topcoded`	`BOOLEAN`	Whether this wage is published as a top-coded amount
`h_pct75_coverage_state`	`VARCHAR`	Whether this wage or employment figure is published, withheld, or not collected
`h_pct75_topcoded`	`BOOLEAN`	Whether this wage is published as a top-coded amount
`h_pct90_coverage_state`	`VARCHAR`	Whether this wage or employment figure is published, withheld, or not collected
`h_pct90_topcoded`	`BOOLEAN`	Whether this wage is published as a top-coded amount
`a_pct10_coverage_state`	`VARCHAR`	Whether this wage or employment figure is published, withheld, or not collected
`a_pct10_topcoded`	`BOOLEAN`	Whether this wage is published as a top-coded amount
`a_pct25_coverage_state`	`VARCHAR`	Whether this wage or employment figure is published, withheld, or not collected
`a_pct25_topcoded`	`BOOLEAN`	Whether this wage is published as a top-coded amount
`a_median_coverage_state`	`VARCHAR`	Whether this wage or employment figure is published, withheld, or not collected
`a_median_topcoded`	`BOOLEAN`	Whether this wage is published as a top-coded amount
`a_pct75_coverage_state`	`VARCHAR`	Whether this wage or employment figure is published, withheld, or not collected
`a_pct75_topcoded`	`BOOLEAN`	Whether this wage is published as a top-coded amount
`a_pct90_coverage_state`	`VARCHAR`	Whether this wage or employment figure is published, withheld, or not collected
`a_pct90_topcoded`	`BOOLEAN`	Whether this wage is published as a top-coded amount
`coverage_state`	`VARCHAR`	Whether the value is published, withheld, not collected, or does not apply
`has_topcoded_value`	`BOOLEAN`	Whether any wage on this row is top-coded
`source_file`	`VARCHAR`	Source file this row was read from
`source_member`	`VARCHAR`	Sheet or archive part inside that file
`source_row_number`	`BIGINT`	Row number in the source file
`source_sha256`	`VARCHAR`	Checksum of the source file
`source_row_key`	`VARCHAR`	Stable key for this source row
`ingested_at`	`TIMESTAMP`	When EduInsights loaded the source file

martsmarts.oews_area_occupation

Oews area occupation

Occupation employment and wage observation by area. May 2025 BLS OEWS cross-industry detailed-occupation observations for the national, state, metropolitan, and nonmetropolitan packages. Geography type is part of the key. Wage/employment suppression and top-coding remain visible; a suppressed value is not zero. This mart intentionally excludes industry cuts, which remain in oews_all_published_observations.

Source and edition: Source details not yet documented
What one row represents: (source_release, geography_type, geography_code, soc6)
Rows: 223,555
File: 12 MB · Parquet

Checking

Show 79 columns

Schema and table: marts.oews_area_occupation
Ontology entity: Occupation
Source fields: source_release, source_file, source_member, source_row_number, source_sha256, source_row_key, ingested_at
Ontology relationships: CIPField → Occupation; DetailedOccupation → Occupation; Occupation → Skill; Observation → Institution, ProgramAwardCell, ProgramFieldGroup, Occupation, Task, Industry, Geography, OccupationalLicenseSnapshot, ProfessionalAssociationEntry; PublisherClassification → Occupation
Caveats: No separate caveat is documented. Review the dataset description and source notes.

Column	Type	Description
`source_release`	`VARCHAR`	Which published release this row came from
`geography_code`	`VARCHAR`	Place code
`geography_name`	`VARCHAR`	Place name
`geography_type`	`VARCHAR`	Whether this is the nation, a state, a metro area, or another place type
`area_type`	`VARCHAR`	Source area type
`prim_state`	`VARCHAR`	Primary state
`naics`	`VARCHAR`	Industry code
`naics_title`	`VARCHAR`	Industry name
`i_group`	`VARCHAR`	Industry grouping
`own_code`	`VARCHAR`	Ownership code
`annual`	`VARCHAR`	Whether an annual wage is published
`hourly`	`VARCHAR`	Whether an hourly wage is published
`soc6`	`VARCHAR`	Detailed occupation code
`occupation_title`	`VARCHAR`	Occupation name
`occupation_level`	`VARCHAR`	Whether this is a detailed occupation or a broader group
`soc_version`	`VARCHAR`	Which year's occupation list this code comes from
`naics_version`	`VARCHAR`	Which year's industry list this code comes from
`tot_emp`	`DOUBLE`	Employment
`emp_prse`	`DOUBLE`	Relative standard error of employment
`jobs_1000`	`DOUBLE`	Jobs per 1,000
`loc_quotient`	`DOUBLE`	Location quotient
`pct_total`	`DOUBLE`	Percent of total employment
`h_mean`	`DOUBLE`	Mean hourly wage
`a_mean`	`DOUBLE`	Mean annual wage
`mean_prse`	`DOUBLE`	Relative standard error of the mean wage
`h_pct10`	`DOUBLE`	10th-percentile hourly wage
`h_pct25`	`DOUBLE`	25th-percentile hourly wage
`h_median`	`DOUBLE`	Median hourly wage
`h_pct75`	`DOUBLE`	75th-percentile hourly wage
`h_pct90`	`DOUBLE`	90th-percentile hourly wage
`a_pct10`	`DOUBLE`	10th-percentile annual wage
`a_pct25`	`DOUBLE`	25th-percentile annual wage
`a_median`	`DOUBLE`	Median annual wage
`a_pct75`	`DOUBLE`	75th-percentile annual wage
`a_pct90`	`DOUBLE`	90th-percentile annual wage
`tot_emp_coverage_state`	`VARCHAR`	Whether this wage or employment figure is published, withheld, or not collected
`tot_emp_topcoded`	`BOOLEAN`	Whether this wage is published as a top-coded amount
`emp_prse_coverage_state`	`VARCHAR`	Whether this wage or employment figure is published, withheld, or not collected
`emp_prse_topcoded`	`BOOLEAN`	Whether this wage is published as a top-coded amount
`jobs_1000_coverage_state`	`VARCHAR`	Whether this wage or employment figure is published, withheld, or not collected
`jobs_1000_topcoded`	`BOOLEAN`	Whether this wage is published as a top-coded amount
`loc_quotient_coverage_state`	`VARCHAR`	Whether this wage or employment figure is published, withheld, or not collected
`loc_quotient_topcoded`	`BOOLEAN`	Whether this wage is published as a top-coded amount
`pct_total_coverage_state`	`VARCHAR`	Whether this wage or employment figure is published, withheld, or not collected
`pct_total_topcoded`	`BOOLEAN`	Whether this wage is published as a top-coded amount
`h_mean_coverage_state`	`VARCHAR`	Whether this wage or employment figure is published, withheld, or not collected
`h_mean_topcoded`	`BOOLEAN`	Whether this wage is published as a top-coded amount
`a_mean_coverage_state`	`VARCHAR`	Whether this wage or employment figure is published, withheld, or not collected
`a_mean_topcoded`	`BOOLEAN`	Whether this wage is published as a top-coded amount
`mean_prse_coverage_state`	`VARCHAR`	Whether this wage or employment figure is published, withheld, or not collected
`mean_prse_topcoded`	`BOOLEAN`	Whether this wage is published as a top-coded amount
`h_pct10_coverage_state`	`VARCHAR`	Whether this wage or employment figure is published, withheld, or not collected
`h_pct10_topcoded`	`BOOLEAN`	Whether this wage is published as a top-coded amount
`h_pct25_coverage_state`	`VARCHAR`	Whether this wage or employment figure is published, withheld, or not collected
`h_pct25_topcoded`	`BOOLEAN`	Whether this wage is published as a top-coded amount
`h_median_coverage_state`	`VARCHAR`	Whether this wage or employment figure is published, withheld, or not collected
`h_median_topcoded`	`BOOLEAN`	Whether this wage is published as a top-coded amount
`h_pct75_coverage_state`	`VARCHAR`	Whether this wage or employment figure is published, withheld, or not collected
`h_pct75_topcoded`	`BOOLEAN`	Whether this wage is published as a top-coded amount
`h_pct90_coverage_state`	`VARCHAR`	Whether this wage or employment figure is published, withheld, or not collected
`h_pct90_topcoded`	`BOOLEAN`	Whether this wage is published as a top-coded amount
`a_pct10_coverage_state`	`VARCHAR`	Whether this wage or employment figure is published, withheld, or not collected
`a_pct10_topcoded`	`BOOLEAN`	Whether this wage is published as a top-coded amount
`a_pct25_coverage_state`	`VARCHAR`	Whether this wage or employment figure is published, withheld, or not collected
`a_pct25_topcoded`	`BOOLEAN`	Whether this wage is published as a top-coded amount
`a_median_coverage_state`	`VARCHAR`	Whether this wage or employment figure is published, withheld, or not collected
`a_median_topcoded`	`BOOLEAN`	Whether this wage is published as a top-coded amount
`a_pct75_coverage_state`	`VARCHAR`	Whether this wage or employment figure is published, withheld, or not collected
`a_pct75_topcoded`	`BOOLEAN`	Whether this wage is published as a top-coded amount
`a_pct90_coverage_state`	`VARCHAR`	Whether this wage or employment figure is published, withheld, or not collected
`a_pct90_topcoded`	`BOOLEAN`	Whether this wage is published as a top-coded amount
`coverage_state`	`VARCHAR`	Whether the value is published, withheld, not collected, or does not apply
`has_topcoded_value`	`BOOLEAN`	Whether any wage on this row is top-coded
`source_file`	`VARCHAR`	Source file this row was read from
`source_member`	`VARCHAR`	Sheet or archive part inside that file
`source_row_number`	`BIGINT`	Row number in the source file
`source_sha256`	`VARCHAR`	Checksum of the source file
`source_row_key`	`VARCHAR`	Stable key for this source row
`ingested_at`	`TIMESTAMP`	When EduInsights loaded the source file

martsmarts.program_accreditation

Program accreditation

Programmatic (specialized) accreditation from DAPIP, rolled up to the current grant per institution x accreditor x program. cip_family anchors the program to a CIP-4 family with cip_map_confidence (high/medium/low) — an EduInsights mapping, not a DAPIP field. Institutional accreditation lives on marts.institution instead; records that could not be matched to an IPEDS UnitID remain in core.program_accreditation only.

Source and edition: Source details not yet documented
What one row represents: (unitid, accreditor_id, program_id)
Rows: 14,877
File: 294 KB · Parquet

Checking

Show 19 columns

Schema and table: marts.program_accreditation
Ontology entity: Program is accredited by
Source fields: Source fields not listed separately
Ontology relationships: ProgramFieldGroup → Accreditor
Caveats: No separate caveat is documented. Review the dataset description and source notes.

Column	Type	Description
`unitid`	`VARCHAR`	Unique identification number of the institution
`institution_name`	`VARCHAR`	Name of the institution
`accreditor_id`	`VARCHAR`	Accreditor identifier
`accreditor_name`	`VARCHAR`	Accreditor name
`program_id`	`VARCHAR`	Specialized program identifier from DAPIP
`program_name`	`VARCHAR`	Specialized program name from DAPIP
`cip_family`	`VARCHAR`	Broader field family this specialized program was mapped toThis broader-field mapping was added by EduInsights. It is not a DAPIP field.
`cip_map_confidence`	`VARCHAR`	How confident the broader-field mapping is
`status`	`VARCHAR`	Accreditation status
`has_active_grant`	`BOOLEAN`	Whether an open grant still exists
`is_currently_accredited`	`BOOLEAN`	Whether a current grant is in accredited status
`first_accreditation_date`	`DATE`	First accreditation date
`current_accreditation_date`	`DATE`	Current grant date
`last_accreditation_end_date`	`DATE`	Last grant end date
`next_review_date`	`DATE`	Next review date
`last_action_date`	`DATE`	Date of the last action
`last_action`	`VARCHAR`	Last published action
`n_locations`	`BIGINT`	Number of DAPIP locations
`n_records`	`BIGINT`	Number of source records rolled into this row

martsmarts.program_award_cell

Program award cell

One row per program at the product's scoring grain. Completions are direct IPEDS observations; earnings/debt are inherited_from_cip4 (College Scorecard field-of-study measures at CIP-4, shared across the institution's CIP-6 children — never SUM them across programs of one institution). IPEDS release stage and Source Release remain visible because the newest canonical cycle may be provisional fallback.

Source and edition: Source details not yet documented
What one row represents: (unitid, cip6, award_level_code, reporting_year)
Rows: 273,404
File: 3.1 MB · Parquet

Checking

Show 26 columns

Schema and table: marts.program_award_cell
Ontology entity: Program Award Cell
Source fields: collection_cycle, source_release_id, release_stage, publication_date, publication_snapshot_id
Ontology relationships: Institution → ProgramAwardCell; ProgramAwardCell → CIPField; CatalogProgram → ProgramAwardCell; ProgramFieldGroup → ProgramAwardCell; Observation → Institution, ProgramAwardCell, ProgramFieldGroup, Occupation, Task, Industry, Geography, OccupationalLicenseSnapshot, ProfessionalAssociationEntry
Caveats: No separate caveat is documented. Review the dataset description and source notes.

Column	Type	Description
`unitid`	`VARCHAR`	Unique identification number of the institution
`institution_name`	`VARCHAR`	Name of the institution
`state`	`VARCHAR`	State or jurisdiction
`sector`	`VARCHAR`	Sector of the institution
`cip6`	`VARCHAR`	Most specific field-of-study code on this row
`cip_title`	`VARCHAR`	Name of the field of study
`award_level`	`VARCHAR`	Name of the award level
`award_level_code`	`VARCHAR`	IPEDS award level code (AWLEVEL) kept as an unpadded string — '3' is an associate's degree, '5' a bachelor's, '7' a master's, '17'-'19' doctorates, and the remaining codes certificates. Labels are in ref.ipeds_dictionary_value under varname AWLEVEL.
`reporting_year`	`INTEGER`	Reporting year
`collection_cycle`	`VARCHAR`	Reporting year for this observation
`source_release_id`	`VARCHAR`	Which published release this row came from
`release_stage`	`VARCHAR`	Whether the selected release is provisional, final, or later revised
`publication_date`	`DATE`	When the source published this release
`coverage_state`	`VARCHAR`	Whether the value is published, withheld, not collected, or does not apply
`publication_snapshot_id`	`VARCHAR`	Which EduInsights snapshot selected this release
`in_v1_scope`	`BOOLEAN`	Whether this award level is in the current scoring set
`completions_first_major`	`BIGINT`	Number of awards conferred as a first majorA reported zero is a real count. Zero awards here is not proof the school currently offers a named program in this field.
`second_major_completions`	`BIGINT`	Number of awards conferred as a second majorA reported zero is a real count. Zero awards here is not proof the school currently offers a named program in this field.
`completions_applicability`	`VARCHAR`	Whether these award counts were measured on this row
`earnings_median_1yr`	`DOUBLE`	Median earnings of graduates working and not enrolled 1 year after completing (institution-state cohort)This figure is for the broader field, then copied onto each more-specific field at the same school. Do not add these rows together.
`earnings_median_4yr`	`DOUBLE`	Median earnings of graduates working and not enrolled 4 years after completingThis figure is for the broader field, then copied onto each more-specific field at the same school. Do not add these rows together.
`debt_median`	`DOUBLE`	Median federal student-loan debt of graduatesThis figure is for the broader field, then copied onto each more-specific field at the same school. Do not add these rows together.
`earnings_cohort_n_1yr`	`BIGINT`	Number of graduates in the 1-year earnings groupThis count belongs to the broader field. Do not add it across more-specific fields at the same school.
`earnings_applicability`	`VARCHAR`	Whether earnings were measured on this specific field or borrowed from the broader field
`earnings_coverage`	`VARCHAR`	Whether earnings are published, withheld, or not collected
`institution_median_earnings_6yr`	`DOUBLE`	Median earnings of the institution's graduates 6 years after entryThis is an institution-wide figure, not earnings for this specific field.

martsmarts.program_award_cell_harmonized

Program award cell harmonized

Harmonized ProgramAwardCell Series. Separately labeled CIP-harmonized completion series. Native observations remain in program_award_cell_longitudinal; mapping weights, ambiguity, and crosswalk release are always disclosed.

Source and edition: Source details not yet documented
What one row represents: (unitid, native_cip6, harmonized_cip6, award_level_code, collection_cycle)
Rows: 3,031,138
File: 20 MB · Parquet

Checking

Show 20 columns

Schema and table: marts.program_award_cell_harmonized
Ontology entity: Program Award Cell
Source fields: collection_cycle, reference_period_start, reference_period_end, reference_period_label, source_release_id, release_stage, publication_date, publication_snapshot_id
Ontology relationships: Institution → ProgramAwardCell; ProgramAwardCell → CIPField; CatalogProgram → ProgramAwardCell; ProgramFieldGroup → ProgramAwardCell; Observation → Institution, ProgramAwardCell, ProgramFieldGroup, Occupation, Task, Industry, Geography, OccupationalLicenseSnapshot, ProfessionalAssociationEntry
Caveats: No separate caveat is documented. Review the dataset description and source notes.

Column	Type	Description
`unitid`	`VARCHAR`	Unique identification number of the institution
`native_cip6`	`VARCHAR`	Field of study as the school originally reported it
`native_cip_version`	`VARCHAR`	Field-of-study list year of the original code
`harmonized_cip6`	`VARCHAR`	Same field after aligning older codes to the current list
`harmonized_cip_version`	`VARCHAR`	Field-of-study list year after alignment
`award_level_code`	`VARCHAR`	IPEDS award level code (AWLEVEL) kept as an unpadded string — '3' is an associate's degree, '5' a bachelor's, '7' a master's, '17'-'19' doctorates, and the remaining codes certificates. Labels are in ref.ipeds_dictionary_value under varname AWLEVEL.
`harmonized_completions_first_major`	`DOUBLE`	First-major awards after aligning older field codes
`harmonized_second_major_completions`	`DOUBLE`	Second-major awards after aligning older field codes
`collection_cycle`	`VARCHAR`	Reporting year for this observation
`reference_period_start`	`DATE`	Start of the period this number describes
`reference_period_end`	`DATE`	End of the period this number describes
`reference_period_label`	`VARCHAR`	Label for the period this number describes
`source_release_id`	`VARCHAR`	Which published release this row came from
`release_stage`	`VARCHAR`	Whether the selected release is provisional, final, or later revised
`publication_date`	`DATE`	When the source published this release
`coverage_state`	`VARCHAR`	Whether the value is published, withheld, not collected, or does not apply
`mapping_state`	`VARCHAR`	Whether the field code mapped directly, was converted, or could not be aligned
`mapping_ambiguity`	`VARCHAR`	Whether the alignment is one-to-one or one-to-many
`crosswalk_source_release`	`VARCHAR`	Which field-code crosswalk release was used
`publication_snapshot_id`	`VARCHAR`	Which EduInsights snapshot selected this release

martsmarts.program_award_cell_latest_final

Program award cell latest final

ProgramAwardCell latest-final convenience view. Explicit point-in-time convenience table for the newest canonical final/revised completions Collection Cycle. Use the longitudinal table for changes or Trends.

Source and edition: Source details not yet documented
What one row represents: (unitid, cip6, cip_version, award_level_code)
Rows: 601,227
File: 5.1 MB · Parquet

Checking

Show 22 columns

Schema and table: marts.program_award_cell_latest_final
Ontology entity: Program Award Cell
Source fields: collection_cycle, reference_period_start, reference_period_end, reference_period_label, source_release_id, release_stage, publication_date, source_file, source_member, source_row_number, source_sha256, ingested_at, publication_snapshot_id
Ontology relationships: Institution → ProgramAwardCell; ProgramAwardCell → CIPField; CatalogProgram → ProgramAwardCell; ProgramFieldGroup → ProgramAwardCell; Observation → Institution, ProgramAwardCell, ProgramFieldGroup, Occupation, Task, Industry, Geography, OccupationalLicenseSnapshot, ProfessionalAssociationEntry
Caveats: No separate caveat is documented. Review the dataset description and source notes.

Column	Type	Description
`unitid`	`VARCHAR`	Unique identification number of the institution
`cip6`	`VARCHAR`	Most specific field-of-study code on this row
`cip_version`	`VARCHAR`	Which year's field-of-study list this code comes from
`award_level_code`	`VARCHAR`	IPEDS award level code (AWLEVEL) kept as an unpadded string — '3' is an associate's degree, '5' a bachelor's, '7' a master's, '17'-'19' doctorates, and the remaining codes certificates. Labels are in ref.ipeds_dictionary_value under varname AWLEVEL.
`completions_first_major`	`BIGINT`	Number of awards conferred as a first major
`second_major_completions`	`BIGINT`	Number of awards conferred as a second major
`collection_cycle`	`VARCHAR`	Reporting year for this observation
`reference_period_start`	`DATE`	Start of the period this number describes
`reference_period_end`	`DATE`	End of the period this number describes
`reference_period_label`	`VARCHAR`	Label for the period this number describes
`source_release_id`	`VARCHAR`	Which published release this row came from
`release_stage`	`VARCHAR`	Whether the selected release is provisional, final, or later revised
`publication_date`	`DATE`	When the source published this release
`coverage_state`	`VARCHAR`	Whether the value is published, withheld, not collected, or does not apply
`source_file`	`VARCHAR`	Source file this row was read from
`source_member`	`VARCHAR`	Sheet or archive part inside that file
`source_row_number`	`BIGINT`	Row number in the source file
`source_sha256`	`VARCHAR`	Checksum of the source file
`ingested_at`	`TIMESTAMP`	When EduInsights loaded the source file
`imputation_flag`	`VARCHAR`	Source flag for imputed or estimated values
`establishes_program_award_cell`	`BOOLEAN`	Whether positive awards establish a reported field and award
`publication_snapshot_id`	`VARCHAR`	Which EduInsights snapshot selected this release

martsmarts.program_award_cell_longitudinal

Program award cell longitudinal

ProgramAwardCell Observation. Canonical IPEDS completion observations selected by the active Publication Snapshot: late-revised, revised, then final are preferred; provisional is used only when no final-family release exists for that component-cycle. Retains native CIP vintage, Collection Cycle, Reference Period, Source Release, coverage, and row provenance. A reported zero-zero row is an Observation but does not establish a Program Award Cell; positive first- or second-major activity does.

Source and edition: Source details not yet documented
What one row represents: (unitid, cip6, cip_version, award_level_code, collection_cycle)
Rows: 3,031,138
File: 30 MB · Parquet

Checking

Show 22 columns

Schema and table: marts.program_award_cell_longitudinal
Ontology entity: Program Award Cell
Source fields: collection_cycle, reference_period_start, reference_period_end, reference_period_label, source_release_id, release_stage, publication_date, source_file, source_member, source_row_number, source_sha256, ingested_at, publication_snapshot_id
Ontology relationships: Institution → ProgramAwardCell; ProgramAwardCell → CIPField; CatalogProgram → ProgramAwardCell; ProgramFieldGroup → ProgramAwardCell; Observation → Institution, ProgramAwardCell, ProgramFieldGroup, Occupation, Task, Industry, Geography, OccupationalLicenseSnapshot, ProfessionalAssociationEntry
Caveats: No separate caveat is documented. Review the dataset description and source notes.

Column	Type	Description
`unitid`	`VARCHAR`	Unique identification number of the institution
`cip6`	`VARCHAR`	Most specific field-of-study code on this row
`cip_version`	`VARCHAR`	Which year's field-of-study list this code comes from
`award_level_code`	`VARCHAR`	IPEDS award level code (AWLEVEL) kept as an unpadded string — '3' is an associate's degree, '5' a bachelor's, '7' a master's, '17'-'19' doctorates, and the remaining codes certificates. Labels are in ref.ipeds_dictionary_value under varname AWLEVEL.
`completions_first_major`	`BIGINT`	Number of awards conferred as a first major
`second_major_completions`	`BIGINT`	Number of awards conferred as a second major
`collection_cycle`	`VARCHAR`	Reporting year for this observation
`reference_period_start`	`DATE`	Start of the period this number describes
`reference_period_end`	`DATE`	End of the period this number describes
`reference_period_label`	`VARCHAR`	Label for the period this number describes
`source_release_id`	`VARCHAR`	Which published release this row came from
`release_stage`	`VARCHAR`	Whether the selected release is provisional, final, or later revised
`publication_date`	`DATE`	When the source published this release
`coverage_state`	`VARCHAR`	Whether the value is published, withheld, not collected, or does not apply
`source_file`	`VARCHAR`	Source file this row was read from
`source_member`	`VARCHAR`	Sheet or archive part inside that file
`source_row_number`	`BIGINT`	Row number in the source file
`source_sha256`	`VARCHAR`	Checksum of the source file
`ingested_at`	`TIMESTAMP`	When EduInsights loaded the source file
`imputation_flag`	`VARCHAR`	Source flag for imputed or estimated values
`establishes_program_award_cell`	`BOOLEAN`	Whether positive awards establish a reported field and awardA cell with no positive awards is still a published observation. It does not mean the school currently offers a named program.
`publication_snapshot_id`	`VARCHAR`	Which EduInsights snapshot selected this release

martsmarts.program_award_cell_unharmonized

Program award cell unharmonized

Unharmonized ProgramAwardCell Residual. Diagnostic residual: longitudinal completion cells whose native CIP version has no crosswalk mapping to the harmonization target. These cells are absent from program_award_cell_harmonized by construction — the build asserts longitudinal = harmonized + unharmonized, so nothing drops silently.

Source and edition: Source details not yet documented
What one row represents: (unitid, cip6, cip_version, award_level_code, collection_cycle)
Rows: 0
File: 746 B · Parquet

Checking

Show 23 columns

Schema and table: marts.program_award_cell_unharmonized
Ontology entity: Program Award Cell
Source fields: collection_cycle, reference_period_start, reference_period_end, reference_period_label, source_release_id, release_stage, publication_date, source_file, source_member, source_row_number, source_sha256, ingested_at, publication_snapshot_id
Ontology relationships: Institution → ProgramAwardCell; ProgramAwardCell → CIPField; CatalogProgram → ProgramAwardCell; ProgramFieldGroup → ProgramAwardCell; Observation → Institution, ProgramAwardCell, ProgramFieldGroup, Occupation, Task, Industry, Geography, OccupationalLicenseSnapshot, ProfessionalAssociationEntry
Caveats: No separate caveat is documented. Review the dataset description and source notes.

Column	Type	Description
`unitid`	`VARCHAR`	Unique identification number of the institution
`cip6`	`VARCHAR`	Most specific field-of-study code on this row
`cip_version`	`VARCHAR`	Which year's field-of-study list this code comes from
`award_level_code`	`VARCHAR`	IPEDS award level code (AWLEVEL) kept as an unpadded string — '3' is an associate's degree, '5' a bachelor's, '7' a master's, '17'-'19' doctorates, and the remaining codes certificates. Labels are in ref.ipeds_dictionary_value under varname AWLEVEL.
`completions_first_major`	`BIGINT`	Number of awards conferred as a first major
`second_major_completions`	`BIGINT`	Number of awards conferred as a second major
`collection_cycle`	`VARCHAR`	Reporting year for this observation
`reference_period_start`	`DATE`	Start of the period this number describes
`reference_period_end`	`DATE`	End of the period this number describes
`reference_period_label`	`VARCHAR`	Label for the period this number describes
`source_release_id`	`VARCHAR`	Which published release this row came from
`release_stage`	`VARCHAR`	Whether the selected release is provisional, final, or later revised
`publication_date`	`DATE`	When the source published this release
`coverage_state`	`VARCHAR`	Whether the value is published, withheld, not collected, or does not apply
`source_file`	`VARCHAR`	Source file this row was read from
`source_member`	`VARCHAR`	Sheet or archive part inside that file
`source_row_number`	`BIGINT`	Row number in the source file
`source_sha256`	`VARCHAR`	Checksum of the source file
`ingested_at`	`TIMESTAMP`	When EduInsights loaded the source file
`imputation_flag`	`VARCHAR`	Source flag for imputed or estimated values
`establishes_program_award_cell`	`BOOLEAN`	Whether positive awards establish a reported field and award
`publication_snapshot_id`	`VARCHAR`	Which EduInsights snapshot selected this release
`unharmonized_reason`	`VARCHAR`	Why this original field code could not be aligned to the current list

martsmarts.pseo_earnings_evidence

Pseo earnings evidence

ProgramFieldGroup earnings observation. Census PSEO V4.13.0 earnings at the publisher's institution/state or aggregate, degree, CIP level, cohort, geography, and horizon grain. CIP-4 and CIP-2 values are inherited broader-field context, not direct named-program outcomes. Preserve applicability, coverage/status flags, and OPEID-to-UnitID resolution state; suppressed, unavailable, not participating, and zero are distinct.

Source and edition: Source details not yet documented
What one row represents: (source_release, source_file, source_row_number, horizon_years)
Rows: 1,869,252
File: 16 MB · Parquet

Checking

Show 44 columns

Schema and table: marts.pseo_earnings_evidence
Ontology entity: Program Field Group
Source fields: source_version, source_release, source_file, source_member, source_row_number, source_row_key, source_sha256, ingested_at
Ontology relationships: ProgramFieldGroup → ProgramAwardCell; ProgramFieldGroup → Industry; Observation → Institution, ProgramAwardCell, ProgramFieldGroup, Occupation, Task, Industry, Geography, OccupationalLicenseSnapshot, ProfessionalAssociationEntry; ProgramFieldGroup → Accreditor
Caveats: No separate caveat is documented. Review the dataset description and source notes.

Column	Type	Description
`agg_level_pseo`	`INTEGER`	How aggregated this Census row is
`inst_level`	`VARCHAR`	Whether this Census row is a campus, a state, or another total
`institution_code`	`VARCHAR`	Campus code in the Census file. For campus rows this is the federal aid ID
`opeid`	`VARCHAR`	Eight-character federal student-aid identifier, including leading zeros
`degree_level`	`VARCHAR`	Degree level of the graduating group
`cip_level`	`VARCHAR`	Whether the field code is broad, mid-level, or most specific
`cip_code`	`VARCHAR`	Field-of-study code at the level published on this row
`cip_version`	`VARCHAR`	Which year's field-of-study list this code comes from
`graduation_cohort_code`	`VARCHAR`	Graduating-class code
`graduation_cohort_start_year`	`INTEGER`	First year of the graduating class
`graduation_cohort_years`	`INTEGER`	How many years are combined in the graduating class
`geography_level`	`VARCHAR`	How detailed the place is
`geography_code`	`VARCHAR`	Place code
`industry_level`	`VARCHAR`	How detailed the industry is
`industry_code`	`VARCHAR`	Industry
`naics_version`	`VARCHAR`	Which year's industry list this code comes from
`horizon_years`	`INTEGER`	Years after graduation
`p25_earnings`	`DOUBLE`	25th-percentile earningsBroader field codes are context for a group of fields, not earnings for one named program.
`median_earnings`	`DOUBLE`	Median earningsBroader field codes are context for a group of fields, not earnings for one named program.
`p75_earnings`	`DOUBLE`	75th-percentile earningsBroader field codes are context for a group of fields, not earnings for one named program.
`employed_graduates`	`BIGINT`	Employed graduates
`ipeds_graduate_count`	`BIGINT`	Comparison count of graduates from IPEDS
`earnings_dollar_year`	`INTEGER`	Dollar year of the earnings figures
`earnings_basis`	`VARCHAR`	Whether earnings are annual and in constant dollars
`earnings_status`	`SMALLINT`	Census disclosure status of the earnings figures
`employed_graduates_status`	`SMALLINT`	Census disclosure status of the employed-graduate count
`ipeds_graduate_count_status`	`SMALLINT`	Census disclosure status of the IPEDS comparison count
`coverage_state`	`VARCHAR`	Whether the value is published, withheld, not collected, or does not apply
`employed_graduates_coverage_state`	`VARCHAR`	Whether the employed-graduate count is published, withheld, or missing
`ipeds_graduate_count_coverage_state`	`VARCHAR`	Whether the IPEDS comparison count is published, withheld, or missing
`source_name`	`VARCHAR`	Name of the source dataset
`source_version`	`VARCHAR`	Version of the source dataset
`source_schema_version`	`VARCHAR`	Schema version of the source dataset
`source_release`	`VARCHAR`	Which published release this row came from
`source_file`	`VARCHAR`	Source file this row was read from
`source_member`	`VARCHAR`	Sheet or archive part inside that file
`source_row_number`	`BIGINT`	Row number in the source file
`source_row_key`	`VARCHAR`	Stable key for this source row
`source_sha256`	`VARCHAR`	Checksum of the source file
`ingested_at`	`TIMESTAMP`	When EduInsights loaded the source file
`resolved_unitid`	`VARCHAR`	Institution ID filled in only when this federal aid ID matches exactly one campus
`opeid_unitid_match_cardinality`	`BIGINT`	How many campuses match this federal aid ID
`identifier_resolution_state`	`VARCHAR`	Whether the federal aid ID matched one campus, several, none, or does not apply
`applicability`	`VARCHAR`	Whether this number was measured here, borrowed from a broader field, or assumed from a mapping

martsmarts.pseo_industry_flow_evidence

Pseo industry flow evidence

ProgramFieldGroup graduate-industry flow observation. Census PSEO V4.13.0 graduate employment flows at native institution/state or aggregate, degree, CIP level, cohort, geography, NAICS level, and horizon grain. This is an empirical field-to-industry relationship for participating cohorts, not a named-program fact. Preserve applicability, coverage/status flags, and identifier-resolution state; do not treat suppression or non-participation as zero.

Source and edition: Source details not yet documented
What one row represents: (source_release, source_file, source_row_number, horizon_years)
Rows: 126,488,250
File: 228 MB · Parquet

Checking

Show 40 columns

Schema and table: marts.pseo_industry_flow_evidence
Ontology entity: Graduate employment flows to industry
Source fields: source_version, source_release, source_file, source_member, source_row_number, source_row_key, source_sha256, ingested_at
Ontology relationships: ProgramFieldGroup → Industry
Caveats: No separate caveat is documented. Review the dataset description and source notes.

Column	Type	Description
`agg_level_pseo`	`INTEGER`	How aggregated this Census row is
`inst_level`	`VARCHAR`	Whether this Census row is a campus, a state, or another total
`institution_code`	`VARCHAR`	Campus code in the Census file. For campus rows this is the federal aid ID
`opeid`	`VARCHAR`	Eight-character federal student-aid identifier, including leading zeros
`degree_level`	`VARCHAR`	Degree level of the graduating group
`cip_level`	`VARCHAR`	Whether the field code is broad, mid-level, or most specific
`cip_code`	`VARCHAR`	Field-of-study code at the level published on this row
`cip_version`	`VARCHAR`	Which year's field-of-study list this code comes from
`graduation_cohort_code`	`VARCHAR`	Graduating-class code
`graduation_cohort_start_year`	`INTEGER`	First year of the graduating class
`graduation_cohort_years`	`INTEGER`	How many years are combined in the graduating class
`geography_level`	`VARCHAR`	How detailed the place is
`geography_code`	`VARCHAR`	Place code
`industry_level`	`VARCHAR`	How detailed the industry is
`industry_code`	`VARCHAR`	Industry
`naics_version`	`VARCHAR`	Which year's industry list this code comes from
`horizon_years`	`INTEGER`	Years after graduation
`employed_graduates`	`BIGINT`	Employed graduates
`employed_graduates_in_state`	`BIGINT`	Employed graduates who stayed in state
`graduates_no_observed_or_marginally_employed`	`BIGINT`	Graduates with no observed or only marginal employment
`employed_graduates_status`	`SMALLINT`	Census disclosure status of the employed-graduate count
`employed_graduates_in_state_status`	`SMALLINT`	Census disclosure status of the in-state employment count
`graduates_no_observed_or_marginally_employed_status`	`SMALLINT`	Census disclosure status of the no-or-marginal employment count
`coverage_state`	`VARCHAR`	Whether the value is published, withheld, not collected, or does not apply
`employed_graduates_in_state_coverage_state`	`VARCHAR`	Whether the in-state employment count is published, withheld, or missing
`graduates_no_observed_or_marginally_employed_coverage_state`	`VARCHAR`	Whether the no-or-marginal employment count is published, withheld, or missing
`source_name`	`VARCHAR`	Name of the source dataset
`source_version`	`VARCHAR`	Version of the source dataset
`source_schema_version`	`VARCHAR`	Schema version of the source dataset
`source_release`	`VARCHAR`	Which published release this row came from
`source_file`	`VARCHAR`	Source file this row was read from
`source_member`	`VARCHAR`	Sheet or archive part inside that file
`source_row_number`	`BIGINT`	Row number in the source file
`source_row_key`	`VARCHAR`	Stable key for this source row
`source_sha256`	`VARCHAR`	Checksum of the source file
`ingested_at`	`TIMESTAMP`	When EduInsights loaded the source file
`resolved_unitid`	`VARCHAR`	Institution ID filled in only when this federal aid ID matches exactly one campus
`opeid_unitid_match_cardinality`	`BIGINT`	How many campuses match this federal aid ID
`identifier_resolution_state`	`VARCHAR`	Whether the federal aid ID matched one campus, several, none, or does not apply
`applicability`	`VARCHAR`	Whether this number was measured here, borrowed from a broader field, or assumed from a mapping

martsmarts.pseo_institution_participation

Pseo institution participation

PSEO institution participation assessment. Release-specific Census PSEO participation derived from the institution lookup and partner/release metadata, not from the presence or absence of an earnings/flow row. OPEID is preserved as text and resolves to UnitID only at cardinality one; ambiguous participant OPEIDs remain one native row with a null UnitID. coverage_state distinguishes observed participation, not_participating, and unresolved identifiers; statewide coverage estimates retain their estimate year.

Source and edition: Source details not yet documented
What one row represents: (source_release, opeid, unitid)
Rows: 6,041
File: 44 KB · Parquet

Checking

Show 14 columns

Schema and table: marts.pseo_institution_participation
Ontology entity: Federal Aid Entity
Source fields: source_version, source_release
Ontology relationships: No direct connection documented for this table
Caveats: No separate caveat is documented. Review the dataset description and source notes.

Column	Type	Description
`unitid`	`VARCHAR`	Unique identification number of the institution
`opeid`	`VARCHAR`	Eight-character federal student-aid identifier, including leading zeros
`source_name`	`VARCHAR`	Name of the source dataset
`source_version`	`VARCHAR`	Version of the source dataset
`source_release`	`VARCHAR`	Which published release this row came from
`state_fips`	`VARCHAR`	State FIPS code
`statewide_graduate_coverage_percent`	`DOUBLE`	Estimated statewide share of graduates covered by Census
`coverage_estimate_year`	`INTEGER`	Year of that statewide coverage estimate
`effective_period_start`	`INTEGER`	Start of the effective period
`effective_period_end`	`INTEGER`	End of the effective period
`opeid_unitid_match_cardinality`	`BIGINT`	How many campuses match this federal aid ID
`identifier_resolution_state`	`VARCHAR`	Whether the federal aid ID matched one campus, several, none, or does not apply
`participation_state`	`VARCHAR`	Whether the campus participates in this Census release
`coverage_state`	`VARCHAR`	Whether the value is published, withheld, not collected, or does not apply

martsmarts.pseo_program_outcome

Pseo program outcome

ProgramFieldGroup normalized outcome observation. Normalized query view over Census PSEO earnings and industry-flow evidence without changing publisher grain. Filter outcome_family before choosing measures, and retain cohort, geography, CIP/degree level, NAICS level, applicability, coverage, and identifier-resolution fields. Broader CIP evidence is inherited context, never a direct CatalogProgram outcome.

Source and edition: Source details not yet documented
What one row represents: (outcome_family, source_release, source_file, source_row_number, horizon_years)
Rows: 128,357,502
File: 240 MB · Parquet

Checking

Show 39 columns

Schema and table: marts.pseo_program_outcome
Ontology entity: Program Field Group
Source fields: source_version, source_release, source_file, source_member, source_row_number, source_row_key, source_sha256, ingested_at
Ontology relationships: ProgramFieldGroup → ProgramAwardCell; ProgramFieldGroup → Industry; Observation → Institution, ProgramAwardCell, ProgramFieldGroup, Occupation, Task, Industry, Geography, OccupationalLicenseSnapshot, ProfessionalAssociationEntry; ProgramFieldGroup → Accreditor
Caveats: No separate caveat is documented. Review the dataset description and source notes.

Column	Type	Description
`outcome_family`	`VARCHAR`	Whether this row is earnings or a move into an industry
`source_name`	`VARCHAR`	Name of the source dataset
`source_version`	`VARCHAR`	Version of the source dataset
`source_release`	`VARCHAR`	Which published release this row came from
`source_schema_version`	`VARCHAR`	Schema version of the source dataset
`agg_level_pseo`	`INTEGER`	How aggregated this Census row is
`inst_level`	`VARCHAR`	Whether this Census row is a campus, a state, or another total
`institution_code`	`VARCHAR`	Campus code in the Census file. For campus rows this is the federal aid ID
`opeid`	`VARCHAR`	Eight-character federal student-aid identifier, including leading zeros
`resolved_unitid`	`VARCHAR`	Institution ID filled in only when this federal aid ID matches exactly one campus
`identifier_resolution_state`	`VARCHAR`	Whether the federal aid ID matched one campus, several, none, or does not apply
`degree_level`	`VARCHAR`	Degree level of the graduating group
`cip_level`	`VARCHAR`	Whether the field code is broad, mid-level, or most specific
`cip_code`	`VARCHAR`	Field-of-study code at the level published on this row
`cip_version`	`VARCHAR`	Which year's field-of-study list this code comes from
`graduation_cohort_code`	`VARCHAR`	Graduating-class code
`graduation_cohort_start_year`	`INTEGER`	First year of the graduating class
`graduation_cohort_years`	`INTEGER`	How many years are combined in the graduating class
`geography_level`	`VARCHAR`	How detailed the place is
`geography_code`	`VARCHAR`	Place code
`industry_level`	`VARCHAR`	How detailed the industry is
`industry_code`	`VARCHAR`	Industry
`naics_version`	`VARCHAR`	Which year's industry list this code comes from
`horizon_years`	`INTEGER`	Years after graduation
`p25_earnings`	`DOUBLE`	25th-percentile earnings
`median_earnings`	`DOUBLE`	Median earningsBroader field codes are context for a group of fields, not earnings for one named program.
`p75_earnings`	`DOUBLE`	75th-percentile earnings
`employed_graduates`	`BIGINT`	Employed graduates
`ipeds_graduate_count`	`BIGINT`	Comparison count of graduates from IPEDS
`employed_graduates_in_state`	`BIGINT`	Employed graduates who stayed in state
`graduates_no_observed_or_marginally_employed`	`BIGINT`	Graduates with no observed or only marginal employment
`coverage_state`	`VARCHAR`	Whether the value is published, withheld, not collected, or does not apply
`applicability`	`VARCHAR`	Whether this number was measured here, borrowed from a broader field, or assumed from a mapping
`source_file`	`VARCHAR`	Source file this row was read from
`source_member`	`VARCHAR`	Sheet or archive part inside that file
`source_row_number`	`BIGINT`	Row number in the source file
`source_row_key`	`VARCHAR`	Stable key for this source row
`source_sha256`	`VARCHAR`	Checksum of the source file
`ingested_at`	`TIMESTAMP`	When EduInsights loaded the source file

martsmarts.qcew_regional_industry_context

Qcew regional industry context

Regional industry employment context. BLS QCEW 2025 quarterly state/county total, NAICS-sector, and NAICS-4 establishment observations at all-size grain. Disclosure, location-quotient, and over-the-year coverage states remain separate; publisher zero-fill for protected employment/wage cells is normalized to NULL while disclosed establishment counts remain available. This is regional establishment/industry context, not occupation demand or graduate outcomes.

Source and edition: bls_qcew · 2025-snapshot-2026-08-25-8b833689b8
What one row represents: (geography_code, ownership_code, industry_code, aggregation_level_code, year, quarter)
Rows: 2,744,436
File: 35 MB · Parquet

Checking

Show 35 columns

Schema and table: marts.qcew_regional_industry_context
Ontology entity: Industry
Source fields: source, source_version, source_file, source_member, source_row_number, source_row_key, source_sha256, ingested_at
Ontology relationships: ProgramFieldGroup → Industry; Observation → Institution, ProgramAwardCell, ProgramFieldGroup, Occupation, Task, Industry, Geography, OccupationalLicenseSnapshot, ProfessionalAssociationEntry; PublisherClassification → Industry
Caveats: No separate caveat is documented. Review the dataset description and source notes.

Column	Type	Description
`geography_code`	`VARCHAR`	Canonical geography key — 2-digit state FIPS for state rows, 5-digit county FIPS for county rows; joins ref.geography and the other regional marts. The publisher's native QCEW area code is in publisher_geography_code.
`geography_type`	`VARCHAR`	Whether this is the nation, a state, a metro area, or another place type
`publisher_geography_code`	`VARCHAR`	BLS QCEW native area code exactly as published (states carry a '000' suffix, e.g. '37000'); retained for tracing rows back to the publisher files after geography_code was normalized to FIPS.
`state_fips`	`VARCHAR`	2-digit state FIPS derived from the publisher area code; the universal state join key shared with ref.geography and the other regional marts.
`geography_name`	`VARCHAR`	Place name
`ownership_code`	`VARCHAR`	Publisher code for the ownership sector of the employers counted on this row; ownership_title spells it out
`ownership_title`	`VARCHAR`	Publisher name of the QCEW ownership category
`industry_code`	`VARCHAR`	Industry
`industry_title`	`VARCHAR`	Publisher name of the QCEW industry
`naics_version`	`VARCHAR`	Which year's industry list this code comes from
`aggregation_level_code`	`VARCHAR`	Publisher code for how far this row is aggregated across place and industry; aggregation_level_title spells it out
`aggregation_level_title`	`VARCHAR`	Publisher name of the QCEW aggregation level
`year`	`INTEGER`	Year
`quarter`	`VARCHAR`	Calendar quarter of the year this row covers, 1 through 4
`qtrly_estabs`	`BIGINT`	Count of establishments the publisher reports for this quarter. Establishment counts stay available even where the employment and wage cells on the same row are protected.
`month1_emplvl`	`BIGINT`	Employment level the publisher reports for the first month of the quarter. Blank where the publisher protected the cell, which is never zero.
`month2_emplvl`	`BIGINT`	Employment level the publisher reports for the second month of the quarter. Blank where the publisher protected the cell, which is never zero.
`month3_emplvl`	`BIGINT`	Employment level the publisher reports for the third month of the quarter. Blank where the publisher protected the cell, which is never zero.
`total_qtrly_wages`	`BIGINT`	Total wages the publisher reports for the quarter. Blank where the publisher protected the cell, which is never zero.
`taxable_qtrly_wages`	`BIGINT`	Taxable wages the publisher reports for the quarter. Blank where the publisher protected the cell, which is never zero.
`qtrly_contributions`	`BIGINT`	Quarterly contributions the publisher reports for this row. Blank where the publisher protected the cell, which is never zero.
`avg_wkly_wage`	`BIGINT`	Average weekly wage the publisher reports for the quarter. Blank where the publisher protected the cell, which is never zero.
`coverage_state`	`VARCHAR`	Whether the value is published, withheld, not collected, or does not apply
`establishment_coverage_state`	`VARCHAR`	Whether the establishment count applies on this row. The publisher keeps establishment counts disclosed even where it protects the employment and wage cells beside them.
`lq_coverage_state`	`VARCHAR`	Whether the publisher's location-quotient cells for this row are published, withheld, or do not apply. The location-quotient values themselves are not carried in this table.
`oty_coverage_state`	`VARCHAR`	Whether the publisher's over-the-year change cells for this row are published, withheld, or do not apply. The over-the-year values themselves are not carried in this table.
`applicability`	`VARCHAR`	Whether this number was measured here, borrowed from a broader field, or assumed from a mapping
`source`	`VARCHAR`	Name of the dataset that supplied this row
`source_version`	`VARCHAR`	Version of the source dataset
`source_file`	`VARCHAR`	Source file this row was read from
`source_member`	`VARCHAR`	Sheet or archive part inside that file
`source_row_number`	`BIGINT`	Row number in the source file
`source_row_key`	`VARCHAR`	Stable key for this source row
`source_sha256`	`VARCHAR`	Checksum of the source file
`ingested_at`	`TIMESTAMP`	When EduInsights loaded the source file

martsmarts.qwi_recent_workforce_context

Qwi recent workforce context

Regional workforce-flow context. Most recent twelve quarters from the bounded North Carolina QWI slice at all-demographic/all-firm characteristic state, metro, and county NAICS-4 grain. Publisher status flags remain measure-specific. This is employer/workforce-flow context, not occupation demand or named-program outcomes.

Source and edition: census_qwi · R2026Q3-V4.14.0-qwipu_nc_20260818_0823-snapshot-2026-08-25-202b0b04f9
What one row represents: (geography_type, geography_code, industry_code, ownership_code, year, quarter)
Rows: 302,709
File: 3.5 MB · Parquet

Checking

Show 36 columns

Schema and table: marts.qwi_recent_workforce_context
Ontology entity: Industry
Source fields: source, source_version, source_file, source_member, source_row_number, source_row_key, source_sha256, ingested_at
Ontology relationships: ProgramFieldGroup → Industry; Observation → Institution, ProgramAwardCell, ProgramFieldGroup, Occupation, Task, Industry, Geography, OccupationalLicenseSnapshot, ProfessionalAssociationEntry; PublisherClassification → Industry
Caveats: No separate caveat is documented. Review the dataset description and source notes.

Column	Type	Description
`geography_type`	`VARCHAR`	Whether this is the nation, a state, a metro area, or another place type
`geography_code`	`VARCHAR`	Publisher geography code — 2-digit state FIPS for state rows, 5-digit county FIPS for county rows, state-prefixed CBSA for metro/micropolitan rows (use cbsa_code to join OEWS metro areas and state_fips for state joins).
`state_fips`	`VARCHAR`	2-digit state FIPS derived from the publisher geography code; the universal state join key shared with ref.geography and the other regional marts. NULL for geography levels where a single state is not defined.
`cbsa_code`	`VARCHAR`	5-digit Core-Based Statistical Area code stripped from the state-prefixed publisher metro code; joins OEWS metro geography_code. NULL outside metro/micropolitan rows.
`industry_code`	`VARCHAR`	Industry
`naics_version`	`VARCHAR`	Which year's industry list this code comes from
`ownership_code`	`VARCHAR`	Publisher ownership code for the employers this row covers; this bounded slice keeps private ownership only
`year`	`INTEGER`	Year
`quarter`	`INTEGER`	Calendar quarter of the year this row covers, 1 through 4
`emp`	`DOUBLE`	Estimated count of workers employed on the first day of the quarter. Blank where the publisher did not release a value, which is never zero.
`status_emp`	`SMALLINT`	Publisher status flag for the beginning-of-quarter employment estimate on this row, recording whether the publisher released the value or withheld it. A blank measure is never zero.
`earn_s`	`DOUBLE`	Estimated average monthly earnings of workers who held the same job through the full quarter. Blank where the publisher did not release a value, which is never zero.
`status_earn_s`	`SMALLINT`	Publisher status flag for the average monthly earnings estimate on this row, recording whether the publisher released the value or withheld it. A blank measure is never zero.
`hir_a`	`DOUBLE`	Estimated count of workers who started a job during the quarter. Blank where the publisher did not release a value, which is never zero.
`status_hir_a`	`SMALLINT`	Publisher status flag for the hires estimate on this row, recording whether the publisher released the value or withheld it. A blank measure is never zero.
`hir_n`	`DOUBLE`	Estimated count of workers who started a job during the quarter, not counting workers recalled to an employer they had worked for before. Blank where the publisher did not release a value, which is never zero.
`status_hir_n`	`SMALLINT`	Publisher status flag for the new-hires estimate on this row, recording whether the publisher released the value or withheld it. A blank measure is never zero.
`sep`	`DOUBLE`	Estimated count of workers whose job with an employer ended during the quarter. Blank where the publisher did not release a value, which is never zero.
`status_sep`	`SMALLINT`	Publisher status flag for the separations estimate on this row, recording whether the publisher released the value or withheld it. A blank measure is never zero.
`turn_ovr_s`	`DOUBLE`	Publisher turnover rate for jobs held through the full quarter. Blank where the publisher did not release a value, which is never zero.
`status_turn_ovr_s`	`SMALLINT`	Publisher status flag for the turnover rate on this row, recording whether the publisher released the value or withheld it. A blank measure is never zero.
`frm_jb_gn`	`DOUBLE`	Estimated count of jobs gained at employers over the quarter. Blank where the publisher did not release a value, which is never zero.
`status_frm_jb_gn`	`SMALLINT`	Publisher status flag for the firm job gains estimate on this row, recording whether the publisher released the value or withheld it. A blank measure is never zero.
`frm_jb_ls`	`DOUBLE`	Estimated count of jobs lost at employers over the quarter. Blank where the publisher did not release a value, which is never zero.
`status_frm_jb_ls`	`SMALLINT`	Publisher status flag for the firm job losses estimate on this row, recording whether the publisher released the value or withheld it. A blank measure is never zero.
`payroll`	`DOUBLE`	Estimated total payroll for all jobs during the quarter. Blank where the publisher did not release a value, which is never zero.
`status_payroll`	`SMALLINT`	Publisher status flag for the total quarterly payroll estimate on this row, recording whether the publisher released the value or withheld it. A blank measure is never zero.
`applicability`	`VARCHAR`	Whether this number was measured here, borrowed from a broader field, or assumed from a mapping
`source`	`VARCHAR`	Name of the dataset that supplied this row
`source_version`	`VARCHAR`	Version of the source dataset
`source_file`	`VARCHAR`	Source file this row was read from
`source_member`	`VARCHAR`	Sheet or archive part inside that file
`source_row_number`	`BIGINT`	Row number in the source file
`source_row_key`	`VARCHAR`	Stable key for this source row
`source_sha256`	`VARCHAR`	Checksum of the source file
`ingested_at`	`TIMESTAMP`	When EduInsights loaded the source file

martsmarts.semantic_catalog

Semantic catalog

Catalog of the served marts: one row per mart in this release, naming the entity it describes, what one of its rows represents, and how to read it. The catalog intentionally does not catalog itself, so it has no row of its own.

Source and edition: Source details not yet documented
What one row represents: served mart table name
Rows: 53
File: 10 KB · Parquet

Checking

Show 4 columns

Schema and table: marts.semantic_catalog
Ontology entity: Entity mapping not yet documented
Source fields: Source fields not listed separately
Ontology relationships: No direct connection documented for this table
Caveats: No separate caveat is documented. Review the dataset description and source notes.

Column	Type	Description
`table_name`	`VARCHAR`	Name of the ready-to-use table
`entity`	`VARCHAR`	What kind of thing one row is about
`grain`	`VARCHAR`	What one row represents
`description`	`VARCHAR`	What this table contains and how far the numbers can be pushed

martsmarts.state_occupation_projection

State occupation projection

State occupation projection observation. Projections Central long-term state occupation projections. Each state retains its own base/projected-year pair and declared source SOC vintage; taxonomy_mapping_method exposes the explicit bridge to SOC 2018. Missing estimates and unresolved codes are not zero. AvgAnnualOpenings is the publisher's combined openings measure; separate exits/transfers are not available and are not inferred.

Source and edition: Source details not yet documented
What one row represents: (source_release_id, state_fips, base_year, projected_year, source_soc6)
Rows: 35,352
File: 973 KB · Parquet

Checking

Show 26 columns

Schema and table: marts.state_occupation_projection
Ontology entity: Occupation
Source fields: source_release_id, source_release, source_file, source_member, source_row_number, source_sha256, source_row_key, ingested_at
Ontology relationships: CIPField → Occupation; DetailedOccupation → Occupation; Occupation → Skill; Observation → Institution, ProgramAwardCell, ProgramFieldGroup, Occupation, Task, Industry, Geography, OccupationalLicenseSnapshot, ProfessionalAssociationEntry; PublisherClassification → Occupation
Caveats: No separate caveat is documented. Review the dataset description and source notes.

Column	Type	Description
`source_release_id`	`VARCHAR`	Which published release this row came from
`state_fips`	`VARCHAR`	State FIPS code
`state_name`	`VARCHAR`	State name
`state_source_url`	`VARCHAR`	State source page
`base_year`	`INTEGER`	Base year of the projection
`projected_year`	`INTEGER`	Projected year
`source_soc_version`	`VARCHAR`	Occupation list year used by the state
`occupation_title`	`VARCHAR`	Occupation name
`base_employment`	`BIGINT`	Employment in the base year
`projected_employment`	`BIGINT`	Projected employment
`employment_change`	`BIGINT`	Numeric change in employment
`employment_change_pct`	`DOUBLE`	Percent change in employment
`annual_openings_avg`	`BIGINT`	Average annual job openings
`coverage_state`	`VARCHAR`	Whether the value is published, withheld, not collected, or does not apply
`source_release`	`VARCHAR`	Which published release this row came from
`source_file`	`VARCHAR`	Source file this row was read from
`source_member`	`VARCHAR`	Sheet or archive part inside that file
`source_row_number`	`BIGINT`	Row number in the source file
`source_sha256`	`VARCHAR`	Checksum of the source file
`source_row_key`	`VARCHAR`	Stable key for this source row
`ingested_at`	`TIMESTAMP`	When EduInsights loaded the source file
`source_soc6`	`VARCHAR`	Occupation code as the source published it
`soc_version`	`VARCHAR`	Which year's occupation list this code comes from
`soc6`	`VARCHAR`	Detailed occupation code
`taxonomy_mapping_method`	`VARCHAR`	How the state's occupation code was aligned to the current list
`evidence_coverage_state`	`VARCHAR`	Whether the projection values are published or unresolved

About the data

What you can count on

Checking sign-in…

01 · Sources

You can see the source

Every table shows where its data comes from. Nothing is hidden or mixed together.

02 · Tables

Each table defines one row

Each table tells you what one row means and documents its fields.

03 · Versions

Each release stays fixed.

This release will not change. New data gets a new date and version number.

04 · Checks

Check every file

The file list includes a size and checksum for every download.