U.S. K-12 School Directory & Performance Metrics - Free Sample (Colorado)

**Overview**
This is a free Colorado-only sample of SchoolDigger's comprehensive K-12 education dataset. Use it to explore the full schema, evaluate data quality, and build proof-of-concept queries before purchasing the complete 50-state dataset.

The sample includes ~1,800 schools and ~180 districts in Colorado (FIPS_STATE = '08'), with the same 20 relational tables and column structure as the full paid products.

**What's included**
- School and district directory with addresses, geocoded lat/lon, phone, website, grade levels, and charter/magnet/virtual flags
- Standardized test scores by school, grade, and subject
- SchoolDigger proprietary 0–5 star ratings and numerical statewide rankings for schools, districts, and cities
- Student demographics: enrollment by race/ethnicity, free/reduced lunch, pupil-teacher ratios
- Graduation rates, dropout rates, and chronic absenteeism
- Per-pupil spending at the school building level (federal and state/local)
- User-submitted school reviews
- All reference/lookup tables (unfiltered)

**Sample queries**
```sql
-- Top-ranked elementary schools in Colorado
SELECT SchoolName, City, SchoolDiggerStarRating, SchoolDiggerRankOfSchool
FROM SchoolLookup s
JOIN SchoolRank r ON s.FIPS_SCHOOLID = r.FIPS_SCHOOLID
WHERE s.LevelID = 1
ORDER BY r.SchoolDiggerRankOfSchool
LIMIT 20;

-- Average test proficiency by district
SELECT d.LEAName, AVG(t.PercentProficient) as avg_proficient
FROM TestScores t
JOIN LEALookup d ON t.FIPS_LEAID = d.FIPS_LEAID
GROUP BY d.LEAName
ORDER BY avg_proficient DESC
LIMIT 20;
```

**Full dataset products**
Like what you see? The complete SchoolDigger dataset covers 136,000+ schools across all 50 states and D.C.:
- **One Year** — current-year snapshot, updated monthly
- **Five Years** — 5-year historical trends
- **Ten Years** — full decade of historical data

Search "SchoolDigger" on Databricks Marketplace to find our paid listings, or contact [e-mail].

**Data sources**
SchoolDigger, National Center for Education Statistics (NCES), 50 State Departments of Education, Common Core of Data (CCD), Private School Survey (PSS), U.S. Census Bureau