USA K-12 Schools Intelligence Report (123,620 Records) | Power BI Dashboard

vw_schools_master

1. Schools Master Sample Preview

Direct real-time view showing enriched GreatSchools academic ratings, parent sentiment tiers, and institutional contacts.

Export Sample CSV

School & District	Location	Type & Level	Academic Tier	Parent Sentiment	Students & Ratio	Contact & Profiles
Lyons Twp High Sch Lyons Twp Hsd 204 ID: 172388002601	100 S Brainard Ave La Grange, IL 60525	Public High	10/10 Standard	3.90 / 5 16 reviews	3706 Ratio: 13.89:1	(708) 579-6300 GS Profile
Lockport Township High Sch East Lockport Twp Hsd 205 ID: 172335002571	1333 E 7Th St Lockport, IL 60441	Public High	10/10 Standard	3.60 / 5 13 reviews	3678 Ratio: 16.42:1	(815) 588-8300 GS Profile
Oak Park & River Forest High Sch Oak Park - River Forest Sd 200 ID: 172928003070	201 N Scoville Ave Oak Park, IL 60302	Public High	10/10 Standard	3.70 / 5 18 reviews	3307 Ratio: 13.67:1	(708) 383-0700 GS Profile
Neuqua Valley High School Indian Prairie Cusd 204 ID: 174169002092	2360 95Th St Naperville, IL 60564	Public High	10/10 Standard	3.60 / 5 19 reviews	3018 Ratio: 14.70:1	(630) 428-6000 GS Profile
Minooka Community High School Minooka Chsd 111 ID: 172634002800	26655 W Eames St Channahon, IL 60410	Public High	10/10 Standard	2.80 / 5 15 reviews	2918 Ratio: 17.79:1	(815) 467-2140 GS Profile
Carl Sandburg High School Cons Hsd 230 ID: 170840000459	13300 S La Grange Rd Orland Park, IL 60462	Public High	10/10 Standard	4.00 / 5 9 reviews	2840 Ratio: 15.62:1	(708) 671-3100 GS Profile
Wm Fremd High School Township Hsd 211 ID: 173045003168	1000 S Quentin Rd Palatine, IL 60067	Public High	10/10 Standard	3.90 / 5 22 reviews	2689 Ratio: 16.56:1	(847) 755-2610 GS Profile
J B Conant High School Township Hsd 211 ID: 173045003165	700 E Cougar Trl Hoffman Estates, IL 60169	Public High	10/10 Standard	3.60 / 5 7 reviews	2633 Ratio: 16.37:1	(847) 755-3610 GS Profile
York Comm High School Elmhurst Sd 205 ID: 171397001755	355 W Saint Charles Rd Elmhurst, IL 60126	Public High	10/10 Standard	3.50 / 5 14 reviews	2590 Ratio: 14.25:1	(630) 617-2400 GS Profile
Maine South High School Maine Township Hsd 207 ID: 172409005031	1111 S Dee Rd Park Ridge, IL 60068	Public High	10/10 Standard	2.70 / 5 20 reviews	2494 Ratio: 16.56:1	(847) 825-7711 GS Profile
Victor J Andrew High School Cons Hsd 230 ID: 170840000460	9001 171St St Orland Hills, IL 60487	Public High	10/10 Standard	3.70 / 5 18 reviews	2213 Ratio: 15.49:1	(708) 342-5800 GS Profile
Glenbrook North High School Glenbrook Hsd 225 ID: 172901003042	2300 Shermer Rd Northbrook, IL 60062	Public High	10/10 Standard	3.00 / 5 9 reviews	2111 Ratio: 13.08:1	(847) 272-6400 GS Profile
Lincoln Way West Lincoln Way Chsd 210 ID: 172307006062	21701 S Gougar Rd New Lenox, IL 60451	Public High	10/10 Standard	4.70 / 5 3 reviews	2047 Ratio: 18.07:1	(815) 717-3501 GS Profile
John Hersey High School Township Hsd 214 ID: 170417000113	1900 E Thomas St Arlington Heights, IL 60004	Public High	10/10 Standard	3.50 / 5 10 reviews	2040 Ratio: 16.50:1	(847) 718-4800 GS Profile
Maine East High School Maine Township Hsd 207 ID: 172409005030	2601 Dempster St Park Ridge, IL 60068	Public High	10/10 Standard	4.00 / 5 16 reviews	1921 Ratio: 14.14:1	(847) 825-4484 GS Profile
Von Steuben Metro Science Hs Chicago Public Schools Dist 299 ID: 170993001180	5039 N Kimball Ave Chicago, IL 60625	Public High	10/10 Standard	4.10 / 5 16 reviews	1698 Ratio: 16.02:1	(773) 534-5100 GS Profile
Riverside Brookfield Twp Hs Riverside-Brookfield Twp Sd 208 ID: 173402003496	160 Ridgewood Rd Riverside, IL 60546	Public High	10/10 Standard	4.80 / 5 6 reviews	1663 Ratio: 16.26:1	(708) 442-7500 GS Profile
Cary-Grove Community High School Chsd 155 ID: 171137001366	2208 3 Oaks Rd Cary, IL 60013	Public High	10/10 Standard	3.60 / 5 8 reviews	1348 Ratio: 17.66:1	(847) 639-3825 GS Profile
Lemont Twp High School Lemont Twp Hsd 210 ID: 172250002508	800 Porter St Lemont, IL 60439	Public High	10/10 Standard	3.80 / 5 4 reviews	1284 Ratio: 15.04:1	(630) 257-5838 GS Profile
Hadley Junior High School Glen Ellyn Sd 41 ID: 171680001987	240 Hawthorne Blvd Glen Ellyn, IL 60137	Public Middle	10/10 Standard	2.30 / 5 7 reviews	1143 Ratio: 14.57:1	(630) 790-6450 GS Profile
Northside College Preparatory Hs Chicago Public Schools Dist 299 ID: 170993003481	5501 N Kedzie Ave Chicago, IL 60625	Public High	10/10 Standard	4.10 / 5 11 reviews	1061 Ratio: 14.94:1	(773) 534-3954 GS Profile
Hancock College Preparatory Hs Chicago Public Schools Dist 299 ID: 170993001980	5437 W 64Th Pl Chicago, IL 60638	Public High	10/10 Standard	5.00 / 5 2 reviews	1050 Ratio: 17.50:1	(773) 535-2410 GS Profile
H H Conrady Jr High School North Palos Sd 117 ID: 172889003029	7950 W 97Th St Hickory Hills, IL 60457	Public Middle	10/10 Standard	2.60 / 5 17 reviews	1047 Ratio: 14.75:1	(708) 233-4500 GS Profile
Hickory Creek Middle School Frankfort Ccsd 157C ID: 171570001881	22150 S Owens Rd Frankfort, IL 60423	Public Middle	10/10 Standard	3.20 / 5 9 reviews	943 Ratio: 14.88:1	(815) 469-4474 GS Profile
Woodstock North High School Woodstock Cusd 200 ID: 174333006032	3000 Raffel Rd Woodstock, IL 60098	Public High	10/10 Standard	4.50 / 5 6 reviews	915 Ratio: 14.88:1	(815) 334-2100 GS Profile

Displaying live sample of 25 schools out of 123,620 verified records.

Download Sample CSV Unlock Complete 123,620 Records ($349)

vw_state_summary

2. State-Wise Distribution & Quality Analytics

Complete aggregated metrics across all 56 US states & territories: public vs private, student headcounts, and rating benchmarks.

State	Schools Distribution	Public	Private	Charter	Enrolled Students	Avg GS Rating	Avg Parent Stars	Top Rated (8-10)	Interactive Filter
CA California	12686 100% of max	9048	2335	1289	5789830	5.74 / 10	3.82	1949	Filter
TX Texas	10954 86% of max	8501	1330	1098	5544776	5.76 / 10	3.61	1725	Filter
FL Florida	6223 49% of max	3685	2004	751	2856431	5.67 / 10	3.66	724	Filter
NY New York	6063 47% of max	4600	1231	350	2503589	5.74 / 10	3.77	770	Filter
IL Illinois	5370 42% of max	3847	971	131	1842637	5.81 / 10	3.80	690	Filter
OH Ohio	4551 35% of max	3458	1006	340	1661201	5.80 / 10	3.70	493	Filter
PA Pennsylvania	4506 35% of max	2842	1567	177	1666685	5.88 / 10	3.71	481	Filter
MI Michigan	4037 31% of max	2901	563	368	1369947	5.86 / 10	3.78	494	Filter
NJ New Jersey	3342 26% of max	2378	784	86	1355535	5.81 / 10	3.85	432	Filter
NC North Carolina	3330 26% of max	2620	594	226	1551279	5.66 / 10	3.63	509	Filter
MN Minnesota	3187 25% of max	1937	406	316	876025	5.68 / 10	3.90	280	Filter
WA Washington	3070 24% of max	2108	517	17	1096561	5.73 / 10	3.81	354	Filter
MO Missouri	2965 23% of max	2294	501	82	885199	5.76 / 10	3.78	317	Filter
GA Georgia	2949 23% of max	2290	620	96	1744167	5.70 / 10	3.67	383	Filter
AZ Arizona	2935 23% of max	2105	307	620	1111112	5.42 / 10	3.72	306	Filter
WI Wisconsin	2923 23% of max	2079	730	225	806858	5.61 / 10	3.88	297	Filter
VA Virginia	2790 21% of max	1883	651	7	1256757	5.62 / 10	3.79	388	Filter
IN Indiana	2509 19% of max	1875	590	134	1037586	5.88 / 10	3.73	321	Filter
MA Massachusetts	2328 18% of max	1744	504	73	915925	5.76 / 10	3.85	267	Filter
TN Tennessee	2304 18% of max	1857	391	114	1002363	5.77 / 10	3.67	248	Filter
CO Colorado	2172 17% of max	1776	272	260	865049	5.49 / 10	3.71	282	Filter
MD Maryland	1952 15% of max	1312	543	50	891570	5.69 / 10	3.72	233	Filter
OK Oklahoma	1924 15% of max	1773	140	73	698182	5.64 / 10	3.60	281	Filter
KY Kentucky	1820 14% of max	1221	270	0	655979	5.73 / 10	3.84	190	Filter
AL Alabama	1801 14% of max	1370	266	26	750814	6.11 / 10	3.72	398	Filter
LA Louisiana	1595 12% of max	1257	282	146	666942	5.92 / 10	3.60	261	Filter
OR Oregon	1583 12% of max	1254	290	128	539626	5.63 / 10	3.75	224	Filter
SC South Carolina	1571 12% of max	1207	293	105	796778	5.76 / 10	3.74	230	Filter
IA Iowa	1509 11% of max	1309	186	7	497368	5.62 / 10	3.94	179	Filter
KS Kansas	1507 11% of max	1337	165	7	477068	5.45 / 10	3.90	186	Filter
NE Nebraska	1272 10% of max	1021	174	0	330473	5.53 / 10	3.92	106	Filter
UT Utah	1250 9% of max	1013	140	146	684715	5.76 / 10	3.83	168	Filter
CT Connecticut	1242 9% of max	979	232	22	490963	5.88 / 10	3.80	198	Filter
AR Arkansas	1226 9% of max	1069	120	110	491259	5.76 / 10	3.76	131	Filter
MS Mississippi	1206 9% of max	869	174	10	433096	5.43 / 10	3.67	144	Filter
NM New Mexico	1044 8% of max	866	124	99	310860	5.38 / 10	3.61	108	Filter
MT Montana	960 7% of max	847	109	0	147525	5.39 / 10	3.89	49	Filter
ID Idaho	925 7% of max	691	119	85	315406	5.59 / 10	3.82	124	Filter
PR Puerto Rico	862 6% of max	825	0	16	235803	-	-	0	Filter
NV Nevada	839 6% of max	684	95	106	474698	5.53 / 10	3.48	106	Filter
SD South Dakota	796 6% of max	680	69	0	146867	5.24 / 10	3.63	50	Filter
WV West Virginia	783 6% of max	636	100	7	242092	5.78 / 10	3.74	93	Filter
ME Maine	697 5% of max	566	104	11	166345	5.69 / 10	3.73	84	Filter
NH New Hampshire	640 5% of max	506	134	46	163146	5.80 / 10	3.73	68	Filter
ND North Dakota	581 4% of max	533	48	0	122995	5.34 / 10	3.88	34	Filter
AK Alaska	517 4% of max	471	25	31	127864	5.83 / 10	3.85	70	Filter
RI Rhode Island	401 4% of max	300	87	42	133862	5.85 / 10	3.81	51	Filter
HI Hawaii	398 4% of max	296	100	40	167067	5.77 / 10	3.73	57	Filter
VT Vermont	396 4% of max	287	93	0	77547	5.83 / 10	3.82	27	Filter
WY Wyoming	393 4% of max	320	29	8	90102	5.66 / 10	4.06	31	Filter
DE Delaware	312 4% of max	206	74	24	142144	5.56 / 10	3.90	34	Filter
DC District of Columbia	295 4% of max	236	51	125	93993	5.66 / 10	3.90	41	Filter
GU Guam	45 4% of max	45	0	4	25646	-	-	0	Filter
MP Northern Mariana Islands	35 4% of max	35	0	0	878	-	-	0	Filter
AS American Samoa	28 4% of max	27	0	0	-28	-	-	0	Filter
VI Virgin Islands	21 4% of max	20	0	0	10408	-	-	0	Filter

vw_top_rated_schools

3. Elite & Top-Rated Schools Showcase

Top-tier schools achieving GreatSchools Test Ratings of 8, 9, or 10, and verified Community Parent Ratings >= 4.0 Stars.

⭐ 43,670 Total Elite Schools in Master Feed

Top School Name	Location	Type & Level	GreatSchools Rating	Parent Stars & Reviews	Total Students	Profile & Phone
Hancock College Preparatory Hs Chicago Public Schools Dist 299 ID: 170993001980	Chicago, IL 60638	Regular School High	10/10 Elite Tier	5.00 / 5 2 reviews	1050	(773) 535-2410 GreatSchools Profile
Eugene Field Elem School Park Ridge Ccsd 64 ID: 173084003212	Park Ridge, IL 60068	Regular School Elementary	10/10 Elite Tier	5.00 / 5 5 reviews	626	(847) 318-4385 GreatSchools Profile
Arnett C Lines Elem School Barrington Cusd 220 ID: 170505000195	Barrington, IL 60010	Regular School Elementary	10/10 Elite Tier	5.00 / 5 2 reviews	501	(847) 381-7850 GreatSchools Profile
Norton Creek Elementary School St Charles Cusd 303 ID: 173717005708	West Chicago, IL 60185	Regular School Elementary	10/10 Elite Tier	5.00 / 5 2 reviews	479	(331) 228-2700 GreatSchools Profile
Parkview Elementary School Columbia Cusd 4 ID: 171074005587	Columbia, IL 62236	Regular School Elementary	10/10 Elite Tier	5.00 / 5 1 reviews	427	(618) 281-4997 GreatSchools Profile
Thurgood Marshall Elementary Rockford Sd 205 ID: 173451003605	Rockford, IL 61103	Regular School Elementary	10/10 Elite Tier	5.00 / 5 9 reviews	374	(815) 966-3370 GreatSchools Profile
Madison Elem School Hinsdale Ccsd 181 ID: 171929002216	Hinsdale, IL 60521	Regular School Elementary	10/10 Elite Tier	5.00 / 5 2 reviews	367	(630) 861-4100 GreatSchools Profile
Meadowview School Grayslake Ccsd 46 ID: 171752001752	Grayslake, IL 60030	Regular School Elementary	10/10 Elite Tier	5.00 / 5 8 reviews	351	(847) 223-3656 GreatSchools Profile
Willard Elem School River Forest Sd 90 ID: 173381003475	River Forest, IL 60305	Regular School Elementary	10/10 Elite Tier	5.00 / 5 3 reviews	327	(708) 366-6740 GreatSchools Profile
Prospect Elem School Hinsdale Ccsd 181 ID: 171929002219	Clarendon Hills, IL 60514	Regular School Elementary	10/10 Elite Tier	5.00 / 5 4 reviews	302	(630) 861-4400 GreatSchools Profile
Middlefork Primary School Sunset Ridge Sd 29 ID: 173840003917	Northfield, IL 60093	Regular School Elementary	10/10 Elite Tier	5.00 / 5 4 reviews	241	(847) 881-9505 GreatSchools Profile
Fabyan Elementary School Geneva Cusd 304 ID: 171638006050	Geneva, IL 60134	Regular School Elementary	10/10 Elite Tier	5.00 / 5 1 reviews	217	(630) 444-8600 GreatSchools Profile
Seventh Ave Elem School La Grange Sd 105 South ID: 172163002427	La Grange, IL 60525	Regular School Elementary	10/10 Elite Tier	5.00 / 5 20 reviews	194	(708) 482-2730 GreatSchools Profile
Iroquois West Elem School/Gilman Iroquois West Cusd 10 ID: 172018004923	Gilman, IL 60938	Regular School Elementary	10/10 Elite Tier	5.00 / 5 1 reviews	159	(815) 265-7631 GreatSchools Profile
Steward Elementary School Steward Esd 220 ID: 173780003885	Steward, IL 60553	Regular School Elementary	10/10 Elite Tier	5.00 / 5 1 reviews	57	(815) 396-2413 GreatSchools Profile

COMMERCIAL DATASET PACKAGES

Purchase & Download Verified USA Schools Data

Instant, unrestricted commercial access to the master database. Cleanly deduplicated, formatted for instant CRM/SQL import, and delivered in CSV, Excel, and SQLite.

Single State Pack

State Specific

$99 one-time

Ideal for localized EdTech sales teams, state agencies, and regional market entry.

All schools for any 1 selected US state
Complete NCES IDs, street addresses & phones
GreatSchools ratings & parent reviews
Instant CSV and Excel download
Complete verified snapshot directory

Order Single State ($99 • Cards & PayPal)

Complete USA Master File

BEST VALUE

$349 one-time

Full nationwide coverage across all 50 states, DC, and territories. Master dataset.

123,620 Verified K-12 Schools (Public + Private)
GreatSchools Test Ratings (64,201) & Reviews (107,774)
Exact NCES EDGE Latitude & Longitude coordinates
Student & Teacher headcounts, Student-Teacher ratio
Master CSV (40MB), Excel, & SQLite DB included
Full commercial license for unlimited users

Buy Master Dataset ($349 • Cards & PayPal)

Enterprise API / Sync

Enterprise

$699 / month

Continuous automated monthly refresh, direct MySQL/Snowflake replication, and custom enrichments.

Direct MySQL, PostgreSQL, Snowflake, or BigQuery sync
Monthly automated scraping & fresh rating delta feeds
Custom fields (e.g. principal names, district emails)
99.9% uptime SLA & dedicated data engineer

Start Cloud Sync ($699/mo • Cards & PayPal)

Dataset Schema & Data Dictionary

Complete column definitions and sample values in the master file.

Field Name	Data Type	Source	Description	Sample Value
SchoolID	VARCHAR(50)	NCES EDGE	Unique National Center for Education Statistics School ID	060000100001
SchoolName	VARCHAR(255)	NCES / Master	Official registered school institution name	Lowell High School
SchoolType	VARCHAR(100)	NCES EDGE	Institution type: Regular School, Private School, Charter School	Regular School
SchoolLevel	VARCHAR(100)	NCES EDGE	Educational grade span: Elementary, Middle, High, Other	High
DistrictName	VARCHAR(255)	NCES EDGE	Supervising School District or Local Educational Agency	San Francisco Unified School District
StreetAddress, City, State, Zip	VARCHAR / TEXT	NCES EDGE	Physical building address and 5-digit US Postal code	1101 Eucalyptus Dr, San Francisco, CA 94132
Phone	VARCHAR(50)	NCES / GS	Primary public administrative telephone number	(415) 759-2730
TotalStudents, TotalTeachers	INT / DECIMAL	NCES Enrolment	Headcount of active student body and Full-Time Equivalent (FTE) teachers	2714 students, 132.5 teachers
StudentTeacherRatio	DECIMAL(8,2)	NCES Derived	Calculated ratio of students per teacher	20.48
GreatSchoolsRating	INT (1-10)	GreatSchools.org	Standardized composite academic performance rating on 1-10 scale	10
RatingTier	VARCHAR(30)	Derived View	Elite (9-10), Above Average (7-8), Average (4-6), Below Average (1-3)	Elite (9-10)
ParentRating, ReviewCount	DECIMAL, INT	GreatSchools Community	Parent review score from 1.0 to 5.0 stars with total review count	4.80 stars (42 reviews)
Latitude, Longitude	DECIMAL(10,7)	NCES Geocoding	GPS coordinates for geospatial GIS analysis and map rendering	37.7289560, -122.4862410
GreatSchoolsUrl	VARCHAR(500)	Direct URL	Deep URL to official GreatSchools profile for verification	https://www.greatschools.org/california/...