Cost, Completion, Wages, and Rent
How do net price, completion, field earnings, and local rent relate for a program at an institution?
Conceptual Join Only
Target Grain: institution x CIP x county x year
Keys and Cardinality
- UNITID
- CIP version
- county FIPS
- ACS vintage
- award year
- cohort
- One row per institution and CIP per year
- Verify one rent row per county/vintage before a many-to-one attachment; do not sum repeated county statistics across institutions or programs
- Earnings population documented separately from completion cohort
- Verify source revisions and licensing compatibility
- Preserve unmatched and suppressed cells
- Validate many-to-many bridge weights and pre/post-join totals
- Bound dry-run bytes and execution cost before any query
Populations differ by measure; no causal or personalized claim.
Firms, Energy, and Jobs
How do establishment counts, electricity prices, and industry employment move together by county?
Conceptual Join Only
Target Grain: county x NAICS x year
Keys and Cardinality
- county FIPS
- NAICS version
- state
- year or month
- Energy prices are state level and fan out to counties
- Monthly energy aggregated to year before join
- Suppressed QCEW cells preserved as unknown
- Verify source revisions and licensing compatibility
- Preserve unmatched and suppressed cells
- Validate many-to-many bridge weights and pre/post-join totals
- Bound dry-run bytes and execution cost before any query
- State energy prices are contextual, non-additive across counties; resolve industry classification and temporal versions
State prices cannot explain county employment.
Grants and Need
Where do federal grant obligations land relative to indicators of need?
Conceptual Join Only
Target Grain: county x program x fiscal year
Keys and Cardinality
- county FIPS
- program number
- fiscal year
- ACS vintage
- Place of performance used, not recipient address
- Fiscal year mapped to ACS period explicitly
- Subaward incompleteness flagged
- Verify source revisions and licensing compatibility
- Preserve unmatched and suppressed cells
- Validate many-to-many bridge weights and pre/post-join totals
- Bound dry-run bytes and execution cost before any query
Obligations are not delivered services.
Transport and Access
Which campuses and health facilities have transit stops nearby, with what service coverage?
Conceptual Join Only
Target Grain: site x stop
Keys and Cardinality
- stop ID
- feed version
- UNITID
- facility ID
- geography vintage
- Spatial join bounded by radius, not Cartesian
- Feed version date recorded
- Duplicate stops collapsed by stop ID
- Verify source revisions and licensing compatibility
- Preserve unmatched and suppressed cells
- Validate many-to-many bridge weights and pre/post-join totals
- Bound dry-run bytes and execution cost before any query
Spatial proximity is not accessibility. Check pedestrian barriers, route calendars, frequency and time of day before claiming travel access.
Healthcare and Workforce
How do shortage area designations compare with health occupation employment and program completions?
Conceptual Join Only
Target Grain: county x discipline x year
Keys and Cardinality
- area ID
- county FIPS
- SOC version
- CIP version
- year
- CIP to SOC fanout audited
- Designation areas mapped to counties with overlap share
- Employment counts jobs, not persons
- Verify source revisions and licensing compatibility
- Preserve unmatched and suppressed cells
- Validate many-to-many bridge weights and pre/post-join totals
- Bound dry-run bytes and execution cost before any query
Designation is administrative; completions are not local hires.
Research and Industry
How do research expenditure, industry co-authorship, and regional industry employment relate by field?
Conceptual Join Only
Target Grain: institution x field x metro x year
Keys and Cardinality
- institution ID
- field code
- CBSA code
- NAICS version
- year
- Field to NAICS mapping documented as many-to-many
- Affiliation matching coverage reported
- Observation date fixed for citations
- Verify source revisions and licensing compatibility
- Preserve unmatched and suppressed cells
- Validate many-to-many bridge weights and pre/post-join totals
- Bound dry-run bytes and execution cost before any query
- A validated research-field-to-industry crosswalk is a prerequisite; no mapping or executable join is supplied
Co-occurrence is not technology transfer.
Housing and Income
How do permits, rent burden, and income distribution relate by county over time?
Conceptual Join Only
Target Grain: county x income band x year
Keys and Cardinality
- county FIPS
- ACS vintage
- income band
- year
- ACS one-year versus five-year not mixed
- Margins of error carried through
- Permit counts aligned to calendar year
- Verify source revisions and licensing compatibility
- Preserve unmatched and suppressed cells
- Validate many-to-many bridge weights and pre/post-join totals
- Bound dry-run bytes and execution cost before any query
Permits are not completions; no housing advice.
Sports and Schedule
How do schedule density, travel distance, and postponements vary by team and week?
Conceptual Join Only
Target Grain: team x week
Keys and Cardinality
- league
- season
- team ID
- venue ID
- game date
- schedule version
- Unique league, season, game ID, team ID and schedule revision before team-week aggregation
- Venue coordinates joined one-to-one
- Postponed games retained with status
- Verify source revisions and licensing compatibility
- Preserve unmatched and suppressed cells
- Validate many-to-many bridge weights and pre/post-join totals
- Bound dry-run bytes and execution cost before any query
Venue-to-venue distances are proxies, not verified travel itineraries. No roster or betting actions.