vw_schools_master
1. Schools Master Sample Preview
Direct real-time view showing enriched GreatSchools academic ratings, parent sentiment tiers, and institutional contacts.
| School & District | Location | Type & Level | Academic Tier | Parent Sentiment | Students & Ratio | Contact & Profiles |
|---|---|---|---|---|---|---|
|
Arizona College Prep High School
Chandler Unified District #80 (4242)
ID: 040187002822
|
4477 S Gilbert Rd
Chandler, AZ 85249
|
Public
High
|
10/10
Standard
|
3.50 / 5
27 reviews
|
2271
Ratio: 22.40:1
|
|
|
Desert Mountain High School
Scottsdale Unified District (4240)
ID: 040757000604
|
12575 E. Via Linda
Scottsdale, AZ 85259
|
Public
High
|
10/10
Standard
|
3.10 / 5
18 reviews
|
1905
Ratio: 20.55:1
|
|
|
Cactus Shadows High School
Cave Creek Unified District (4244)
ID: 040000101204
|
5802 E. Dove Valley Rd.
Scottsdale, AZ 85266
|
Public
High
|
10/10
Standard
|
2.60 / 5
37 reviews
|
1362
Ratio: 20.89:1
|
|
|
Basis Chandler
Basis Charter Schools Inc. (90842)
ID: 040083003253
|
4825 S Arizona Ave
Chandler, AZ 85248
|
Public
High
|
10/10
Standard
|
3.20 / 5
42 reviews
|
1185
Ratio: 19.24:1
|
|
|
Basis Scottsdale
Basis Charter Schools Inc. (81078)
ID: 040060803115
|
10400 N 128Th St
Scottsdale, AZ 85259
|
Public
Other
|
10/10
Standard
|
3.50 / 5
63 reviews
|
1023
Ratio: 16.91:1
|
|
|
Basis Peoria
Basis Charter Schools Inc. (90841)
ID: 040082903278
|
9902 W Yearling Rd
Peoria, AZ 85383
|
Public
High
|
10/10
Standard
|
4.20 / 5
72 reviews
|
1021
Ratio: 20.17:1
|
|
|
Sierra Verde Steam Academy
Deer Valley Unified District (4246)
ID: 040775002127
|
7241 W Rose Garden Ln
Glendale, AZ 85308
|
Public
Elementary
|
10/10
Standard
|
4.20 / 5
25 reviews
|
932
Ratio: 18.83:1
|
|
|
Vista Del Sur Accelerated
Laveen Elementary District (4276)
ID: 040429001391
|
3908 W South Mountain Rd
Laveen, AZ 85339
|
Public
Elementary
|
10/10
Standard
|
3.80 / 5
59 reviews
|
893
Ratio: 19.88:1
|
|
|
Basis Tucson Primary
Basis Charter Schools Inc. (6361)
ID: 040013401786
|
3825 E 2Nd St
Tucson, AZ 85716
|
Public
Other
|
10/10
Standard
|
3.60 / 5
69 reviews
|
785
Ratio: 14.60:1
|
|
|
Bridges Elementary School
Higley Unified School District (4248)
ID: 040378003490
|
5205 S Soboba St
Gilbert, AZ 85298
|
Public
Elementary
|
10/10
Standard
|
3.80 / 5
5 reviews
|
770
Ratio: 17.77:1
|
|
|
Madison Traditional Academy
Madison Elementary District (4270)
ID: 040450002874
|
925 E Maryland Ave
Phoenix, AZ 85014
|
Public
Elementary
|
10/10
Standard
|
3.50 / 5
25 reviews
|
760
Ratio: 23.75:1
|
|
|
Charlotte Patterson Elementary
Chandler Unified District #80 (4242)
ID: 040187002948
|
7520 S Adora Blvd
Gilbert, AZ 85298
|
Public
Elementary
|
10/10
Standard
|
3.90 / 5
20 reviews
|
753
Ratio: 18.28:1
|
|
|
Alhambra Traditional School
Alhambra Elementary District (4280)
ID: 040060001283
|
5725 N 27Th Ave
Phoenix, AZ 85017
|
Public
Elementary
|
10/10
Standard
|
4.60 / 5
37 reviews
|
733
Ratio: 21.56:1
|
|
|
Great Hearts Academies - Chandler Prep
Chandler Preparatory Academy (88299)
ID: 040044002681
|
1951 N Alma School Rd
Chandler, AZ 85224
|
Public
High
|
10/10
Standard
|
3.30 / 5
19 reviews
|
716
Ratio: 13.61:1
|
|
|
Great Hearts Academies - Archway Lincoln
Archway Classical Academy Lincoln (92656)
ID: 040092503464
|
701 N 44Th St
Phoenix, AZ 85008
|
Public
Elementary
|
10/10
Standard
|
5.00 / 5
2 reviews
|
712
Ratio: 15.15:1
|
|
|
Senita Valley Elementary School
Vail Unified District (4413)
ID: 040885002798
|
10750 E Bilby Rd
Tucson, AZ 85747
|
Public
Elementary
|
10/10
Standard
|
3.50 / 5
17 reviews
|
709
Ratio: 18.62:1
|
|
|
Fireside Elementary School
Paradise Valley Unified District (4241)
ID: 040593003313
|
3725 E. Love Cactus Drive
Phoenix, AZ 85050
|
Public
Elementary
|
10/10
Standard
|
3.80 / 5
32 reviews
|
693
Ratio: 16.50:1
|
|
|
Basis Ahwatukee
Basis Charter Schools Inc. (91339)
ID: 040089703376
|
10210 S 50Th Pl
Phoenix, AZ 85044
|
Public
Other
|
10/10
Standard
|
3.50 / 5
31 reviews
|
661
Ratio: 12.47:1
|
|
|
Knox Gifted Academy
Chandler Unified District #80 (4242)
ID: 040187000131
|
700 W Orchid Ln
Chandler, AZ 85225
|
Public
Elementary
|
10/10
Standard
|
4.20 / 5
49 reviews
|
653
Ratio: 19.49:1
|
|
|
Sky Crossing Elementary School
Paradise Valley Unified District (4241)
ID: 040593003763
|
3300 E. Sky Crossing Way
Phoenix, AZ 85050
|
Public
Elementary
|
10/10
Standard
|
5.00 / 5
1 reviews
|
628
Ratio: 14.80:1
|
|
|
Boulder Creek Elementary School
Paradise Valley Unified District (4241)
ID: 040593000611
|
22801 N 22Nd St
Phoenix, AZ 85024
|
Public
Elementary
|
10/10
Standard
|
4.30 / 5
22 reviews
|
621
Ratio: 17.79:1
|
|
|
Candeo Peoria
Candeo Schools Inc. (89758)
ID: 040075802766
|
9965 W Calle Lejos
Peoria, AZ 85383
|
Public
Elementary
|
10/10
Standard
|
3.20 / 5
94 reviews
|
597
Ratio: 18.47:1
|
|
|
Sequoya Elementary School
Scottsdale Unified District (4240)
ID: 040757001434
|
11808 N 64Th St
Scottsdale, AZ 85254
|
Public
Elementary
|
10/10
Standard
|
4.80 / 5
33 reviews
|
575
Ratio: 16.24:1
|
|
|
Sonoran Sky Elementary School
Paradise Valley Unified District (4241)
ID: 040593000606
|
12990 N 75Th St
Scottsdale, AZ 85260
|
Public
Elementary
|
10/10
Standard
|
3.50 / 5
71 reviews
|
567
Ratio: 15.58:1
|
|
|
Coronado Elementary School
Higley Unified School District (4248)
ID: 040378001987
|
4333 S Deanza Blvd
Gilbert, AZ 85297
|
Public
Elementary
|
10/10
Standard
|
3.80 / 5
27 reviews
|
536
Ratio: 12.37:1
|
Displaying live sample of 25 schools out of 123,620 verified records.
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 |
|---|---|---|---|---|---|---|
|
Great Hearts Academies - Archway Lincoln
Archway Classical Academy Lincoln (92656)
ID: 040092503464
|
Phoenix, AZ 85008
|
Regular School
Elementary
|
10/10
Elite Tier
|
5.00 / 5
2 reviews
|
712 | |
|
Sky Crossing Elementary School
Paradise Valley Unified District (4241)
ID: 040593003763
|
Phoenix, AZ 85050
|
Regular School
Elementary
|
10/10
Elite Tier
|
5.00 / 5
1 reviews
|
628 | |
|
Wenden Elementary School
Wenden Elementary District (4512)
ID: 040912000949
|
Wenden, AZ 85357
|
Regular School
Elementary
|
10/10
Elite Tier
|
5.00 / 5
1 reviews
|
68 | |
|
Arizona Agribusiness & Equine Center - Estrella
Arizona Agribusiness & Equine Center Inc. (90779)
ID: 040082803199
|
Avondale, AZ 85007
|
Regular School
High
|
10/10
Elite Tier
|
4.90 / 5
20 reviews
|
335 | |
|
Skull Valley Elementary School
Skull Valley Elementary District (4478)
ID: 040777000390
|
Skull Valley, AZ 86338
|
Regular School
Elementary
|
10/10
Elite Tier
|
4.90 / 5
8 reviews
|
39 | |
|
Sequoya Elementary School
Scottsdale Unified District (4240)
ID: 040757001434
|
Scottsdale, AZ 85254
|
Regular School
Elementary
|
10/10
Elite Tier
|
4.80 / 5
33 reviews
|
575 | |
|
Alhambra Traditional School
Alhambra Elementary District (4280)
ID: 040060001283
|
Phoenix, AZ 85017
|
Regular School
Elementary
|
10/10
Elite Tier
|
4.60 / 5
37 reviews
|
733 | |
|
Freedom Traditional Academy
Dysart Unified District (4243)
ID: 040269003656
|
Surprise, AZ 85374
|
Regular School
Elementary
|
10/10
Elite Tier
|
4.60 / 5
37 reviews
|
529 | |
|
Carrillo Intermediate Magnet School
Tucson Unified District (4403)
ID: 040880001266
|
Tucson, AZ 85701
|
Regular School
Elementary
|
10/10
Elite Tier
|
4.60 / 5
11 reviews
|
305 | |
|
Scottsdale Country Day School
Scottsdale Country Day School (91110)
ID: 040087903400
|
Scottsdale, AZ 85253
|
Regular School
Elementary
|
10/10
Elite Tier
|
4.60 / 5
85 reviews
|
133 | |
|
Boulder Creek Elementary School
Paradise Valley Unified District (4241)
ID: 040593000611
|
Phoenix, AZ 85024
|
Regular School
Elementary
|
10/10
Elite Tier
|
4.30 / 5
22 reviews
|
621 | |
|
Arizona Agribusiness & Equine Center Inc. - Prescott Valley
Arizona Agribusiness & Equine Center Inc. (91131)
ID: 040083803243
|
Prescott Valley, AZ 86314
|
Regular School
High
|
10/10
Elite Tier
|
4.30 / 5
4 reviews
|
327 | |
|
Basis Peoria
Basis Charter Schools Inc. (90841)
ID: 040082903278
|
Peoria, AZ 85383
|
Regular School
High
|
10/10
Elite Tier
|
4.20 / 5
72 reviews
|
1021 | |
|
Sierra Verde Steam Academy
Deer Valley Unified District (4246)
ID: 040775002127
|
Glendale, AZ 85308
|
Regular School
Elementary
|
10/10
Elite Tier
|
4.20 / 5
25 reviews
|
932 | |
|
Knox Gifted Academy
Chandler Unified District #80 (4242)
ID: 040187000131
|
Chandler, AZ 85225
|
Regular School
Elementary
|
10/10
Elite Tier
|
4.20 / 5
49 reviews
|
653 |
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
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
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
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/... |