NCES
Public schools
Every public school every year since 2014 — enrollment, teachers, grades, Title I, free and reduced-price lunch, locale — with school locations and county roll-ups.
Published by NCES
Finest detail facility
Tables 4
School locations
Sample of 25 rows out of about 193,724
· 12 columns
| id | school_year | ncessch | name | state_abbr | state_fips | county_fips | fips | zip | lat | lon | locale |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 2023-2024 | 010000500870 | Albertville Middle School | AL | 01 | 095 | 01095 | No data | 34.2602 | -86.2062 | 32 |
| 2 | 2023-2024 | 010000500871 | Albertville High School | AL | 01 | 095 | 01095 | No data | 34.2622 | -86.2049 | 32 |
| 3 | 2023-2024 | 010000500879 | Albertville Intermediate School | AL | 01 | 095 | 01095 | No data | 34.2733 | -86.2201 | 32 |
| 4 | 2023-2024 | 010000500889 | Albertville Elementary School | AL | 01 | 095 | 01095 | No data | 34.2527 | -86.221806 | 32 |
| 5 | 2023-2024 | 010000501616 | Albertville Kindergarten and PreK | AL | 01 | 095 | 01095 | No data | 34.2898 | -86.1933 | 32 |
| 6 | 2023-2024 | 010000502150 | Albertville Primary School | AL | 01 | 095 | 01095 | No data | 34.2533 | -86.2218 | 32 |
| 7 | 2023-2024 | 010000600193 | Kate Duncan Smith DAR Middle | AL | 01 | 095 | 01095 | No data | 34.53375 | -86.254153 | 42 |
| 8 | 2023-2024 | 010000600872 | Asbury High School | AL | 01 | 095 | 01095 | No data | 34.3625 | -86.142 | 42 |
| 9 | 2023-2024 | 010000600876 | Claysville School | AL | 01 | 095 | 01095 | No data | 34.4069 | -86.2704 | 32 |
| 10 | 2023-2024 | 010000600877 | Douglas Elementary School | AL | 01 | 095 | 01095 | No data | 34.176234 | -86.321259 | 42 |
| 11 | 2023-2024 | 010000600878 | Douglas High School | AL | 01 | 095 | 01095 | No data | 34.178658 | -86.319462 | 42 |
| 12 | 2023-2024 | 010000600880 | Brindlee Mountain Elementary School | AL | 01 | 095 | 01095 | No data | 34.3445 | -86.4421 | 41 |
| 13 | 2023-2024 | 010000600883 | Kate D Smith DAR High School | AL | 01 | 095 | 01095 | No data | 34.53375 | -86.254153 | 42 |
| 14 | 2023-2024 | 010000600887 | Brindlee Mountain Primary School | AL | 01 | 095 | 01095 | No data | 34.377151 | -86.422446 | 42 |
| 15 | 2023-2024 | 010000600986 | Marshall Alternative School | AL | 01 | 095 | 01095 | No data | 34.4069 | -86.2704 | 32 |
| 16 | 2023-2024 | 010000600987 | Marshall Technical School | AL | 01 | 095 | 01095 | No data | 34.3054 | -86.2859 | 41 |
| 17 | 2023-2024 | 010000601413 | Robert D Sloman Primary | AL | 01 | 095 | 01095 | No data | 34.176774 | -86.322507 | 42 |
| 18 | 2023-2024 | 010000601585 | Brindlee Mountain High School | AL | 01 | 095 | 01095 | No data | 34.3764 | -86.4219 | 42 |
| 19 | 2023-2024 | 010000601685 | Kate D Smith DAR Elementary School | AL | 01 | 095 | 01095 | No data | 34.53375 | -86.254153 | 42 |
| 20 | 2023-2024 | 010000601812 | Douglas Middle School | AL | 01 | 095 | 01095 | No data | 34.177536 | -86.320895 | 42 |
| 21 | 2023-2024 | 010000602209 | Asbury Elementary School | AL | 01 | 095 | 01095 | No data | 34.362734 | -86.141422 | 42 |
| 22 | 2023-2024 | 010000700091 | Trace Crossings Elementary School | AL | 01 | 073 | 01073 | No data | 33.3409 | -86.8447 | 21 |
| 23 | 2023-2024 | 010000700248 | Greystone Elementary School | AL | 01 | 117 | 01117 | No data | 33.413 | -86.6585 | 21 |
| 24 | 2023-2024 | 010000700251 | Hoover High School | AL | 01 | 073 | 01073 | No data | 33.3444 | -86.8377 | 21 |
| 25 | 2023-2024 | 010000700337 | Berry Middle School | AL | 01 | 117 | 01117 | No data | 33.3956 | -86.7322 | 21 |
Need the whole thing? Spreadsheet links, downloads, and AI access come with Level 3.
See pricing