Data source: Big Local News · About: Big Local

3,371,677 rows sorted by ell descending

View and edit SQL

Link rowid state county county_state_id admin_level district_nces_id district_state_id district_state_type district school_nces_id school_state_id school school_state_type ccd_school_type ccd_charter_school ccd_school_lvl ccd_school_low_grade ccd_school_high_grade year term grade white black hispanic native_american native_american_alaskan_native asian native_hawaiian asian_pacific_islander native_hawaiian_pacific_islander pacific_islander multiracial unknown_race male female non_binary unknown_gender ell ▲ ell_percent homeless homeless_percent low_income free_and_reduced free_and_reduced_percent disability section_504 total white_int black_int hispanic_int native_american_int native_american_alaskan_native_int asian_int native_hawaiian_int asian_pacific_islander_int native_hawaiian_pacific_islander_int pacific_islander_int multiracial_int unknown_race_int male_int female_int non_binary_int unknown_gender_int ell_int homeless_int low_income_int free_and_reduced_int disability_int section_504_int total_int
689692 MN Ramsey 62 school 2733840 625 Independent Districts and Schools ST. PAUL PUBLIC SCHOOL DISTRICT 273384004429 252 WASHINGTON TECH SECONDARY MAGNET Secondary School (Grades 7-12) Regular School No Other 06 12 2017   pk_12_total 93.0 504.0 248.0   13.0 1208.0     1.0   47.0   1127.0 987.0     992.0   16.0     1894.0   308.0   2114.0 93 504 248   13 1208     1   47   1127 987     992 16   1894 308   2114
692168 MN Hennepin 27 school 2705790 271 Independent Districts and Schools BLOOMINGTON PUBLIC SCHOOL DISTRICT 270579000223 448 OAK GROVE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2017   pk_12_total 175.0 81.0 86.0   0.0 59.0     0.0   46.0   251.0 196.0     99.0   1.0     235.0   66.0   447.0 175 81 86   0 59     0   46   251 196     99 1   235 66   447
694118 MN Ramsey 62 school 2733840 625 Independent Districts and Schools ST. PAUL PUBLIC SCHOOL DISTRICT 273384001619 541 PHALEN LAKE HMONG STUDIES MAGNET Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   grade_1 0.0 5.0 10.0   0.0 102.0     0.0   3.0   63.0 57.0     99.0   1.0     102.0   12.0   120.0 0 5 10   0 102     0   3   63 57     99 1   102 12   120
699012 MN Lyon 42 school 2718940 413 Independent Districts and Schools MARSHALL PUBLIC SCHOOL DISTRICT 271894000892 1 MARSHALL HIGH SCHOOL Senior High School (Grades 9-12) Regular School No High 09 12 2017   pk_12_total 553.0 71.0 110.0   0.0 62.0     1.0   17.0   429.0 385.0     99.0   *     277.0   86.0   814.0 553 71 110   0 62     1   17   429 385     99     277 86   814
699169 MN Ramsey 62 school 2733840 625 Independent Districts and Schools ST. PAUL PUBLIC SCHOOL DISTRICT 273384001592 220 HIGHLAND PARK SENIOR HIGH Senior High School (Grades 9-12) Regular School No High 09 12 2017   grade_9 101.0 78.0 93.0   2.0 48.0     0.0   6.0   171.0 157.0     99.0   3.0     176.0   25.0   328.0 101 78 93   2 48     0   6   171 157     99 3   176 25   328
699526 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124001026 360 ROOSEVELT SENIOR HIGH Senior High School (Grades 9-12) Regular School No High 09 12 2017   grade_9 68.0 99.0 83.0   14.0 10.0     0.0   2.0   150.0 126.0     99.0   19.0     193.0   55.0   276.0 68 99 83   14 10     0   2   150 126     99 19   193 55   276
855903 MN Dakota 19 school 2707290 191 Independent Districts and Schools BURNSVILLE PUBLIC SCHOOL DISTRICT 270729000303 486 VISTA VIEW ELEMENTARY Elementary School (Grades PK-6) Regular School No 1 KG 06 2016   pk_12_total 147 81 111   7 29     0   26   202 199     99.0   2.0     230.0   67.0   401 147 81 111   7 29     0   26   202 199     99 2   230 67   401
861502 MN Ramsey 62 school 2700304 4181 Charter Schools COMMUNITY SCHOOL OF EXCELLENCE 270030403728 10 COMMUNITY SCHOOL OF EXCELLENCE Elementary School (Grades PK-6) Regular School Yes 1 KG 08 2016   grade_5 0 0 0   0 124     0   0   73 51     99.0   0.0     111.0   14.0   124 0 0 0   0 124     0   0   73 51     99 0   111 14   124
1153458 MN Hennepin 27 school 2721240 1 Special Districts and Schools MINNEAPOLIS PUBLIC SCHOOL DIST. 272124000932 190 ANDERSEN COMMUNITY Elementary School (Grades PK-6) Regular School No 1 PK 08 2015   grade_1 0.0 42.0 85.0   6.0 1.0     0.0   1.0   64.0 71.0     99.0   22.0         18.0   135.0 0 42 85   6 1     0   1   64 71     99 22     18   135
1154348 MN Hennepin 27 school 2700378 4208 Charter Schools NASHA SHKOLA CHARTER SCHOOL 270037804635 10 NASHA SHKOLA CHARTER SCHOOL Elementary School (Grades PK-6) Regular School Yes 1 KG 08 2015   pk_12_total 126.0 0.0 0.0   0.0 0.0     0.0   2.0   64.0 64.0     99.0   0.0     89.0   5.0   128.0 126 0 0   0 0     0   2   64 64     99 0   89 5   128
1154824 MN Hennepin 27 school 2731750 280 Independent Districts and Schools RICHFIELD PUBLIC SCHOOL DISTRICT 273175001317 37 RICHFIELD MIDDLE Middle School (Grades 5-8) Regular School No 2 06 08 2015   grade_6 114.0 49.0 104.0   3.0 16.0     0.0   19.0   152.0 153.0     99.0   2.0     192.0   51.0   305.0 114 49 104   3 16     0   19   152 153     99 2   192 51   305
1155854 MN Mower 50 school 2703450 492 Independent Districts and Schools AUSTIN PUBLIC SCHOOL DISTRICT 270345000148 200 AUSTIN SENIOR HIGH Senior High School (Grades 9-12) Regular School No 3 09 12 2015   pk_12_total 866.0 72.0 258.0   1.0 58.0     6.0   29.0   653.0 637.0     99.0   3.0     591.0   163.0   1290.0 866 72 258   1 58     6   29   653 637     99 3   591 163   1290
1156324 MN Hennepin 27 school 2721240 1 Special Districts and Schools MINNEAPOLIS PUBLIC SCHOOL DIST. 272124001035 362 SOUTH SENIOR HIGH Senior High School (Grades 9-12) Regular School No 3 09 12 2015   grade_9 157.0 177.0 84.0   41.0 28.0     0.0   2.0   244.0 245.0     99.0   17.0     318.0   77.0   489.0 157 177 84   41 28     0   2   244 245     99 17   318 77   489
1285591 IN     school 1812420 4415   Warsaw Community Schools 181242001993 3613 Leesburg Elementary School   Regular School No 1.0 PK 06 2016   pk_12_total 298.0 3.0 159.0               12.0   246.0 226.0     99.0             90.0   472.0 298 3 159               12   246 226     99       90   472
1286307 IN     school 1804320 4710   School City of Hammond 180432002236 4449 Thomas A Edison Elementary School   Regular School No 1.0 PK 05 2016   pk_12_total 122.0 188.0 353.0     3.0     1.0   45.0   354.0 358.0     99.0             114.0   712.0 122 188 353     3     1   45   354 358     99       114   712
1287168 IN     school 1805670 5330   M S D Lawrence Township 180567000139 5291 Fall Creek Valley Middle School   Regular School No 2.0 07 08 2016   pk_12_total 328.0 527.0 232.0 1.0   11.0     1.0   78.0   574.0 604.0     99.0             152.0   1178.0 328 527 232 1   11     1   78   574 604     99       152   1178
1298317 IN     school 1804320 4710   School City of Hammond 180432000746 4417 Morton Senior High School   Regular School No High 09 12 2017   pk_12_total 260.0 505.0 533.0 2.0   2.0         46.0   678.0 670.0     99.0             187.0   1348.0 260 505 533 2   2         46   678 670     99       187   1348
1350514 UT     school 4900360 12 District Granite District 490036000248 716 Olympus High   Regular School No High 09 12 2021   k_12_total 1813.0 59.0 179.0 15.0   73.0       12.0 17.0   1090.0 1078.0     99.0   9.0   404.0     115.0   2168 1813 59 179 15   73       12 17   1090 1078     99 9 404   115   2168
1351070 UT     school 4900041 3C Charter Entheos Academy 490004101136 100 Entheos Academy   Regular School Yes Other KG 09 2021   k_12_total 280.0 16.0 209.0 2.0   14.0       22.0 26.0   279.0 290.0     99.0   0.0   224.0     75.0   569 280 16 209 2   14       22 26   279 290     99 0 224   75   569
1714538 MN Dakota 19 school 2715030 199 Independent Districts and Schools Inver Grove Heights Schools 271503000547 577 Pine Bend Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 05 2021   pk_12_total 293 47 144   3 30     0   37   272 282     99.0   2.0     194.0   73.0   554 293 47 144   3 30     0   37   272 282     99 2   194 73   554
1717659 MN Steele 74 school 2728050 761 Independent Districts and Schools Owatonna Public School District 272805001226 902 McKinley Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 05 2021   pk_12_total 333 89 92   0 2     0   10   267 259     99.0   4.0     243.0   77.0   526 333 89 92   0 2     0   10   267 259     99 4   243 77   526
1721987 MN Hennepin 27 school 2731780 281 Independent Districts and Schools Robbinsdale Public School District 273178001318 53 Robbinsdale Armstrong Senior High Senior High School (Grades 9-12) Regular School No High 09 12 2021   pk_12_total 997 441 210   13 97     0   168   977 949     99.0   7.0     662.0   198.0   1926 997 441 210   13 97     0   168   977 949     99 7   662 198   1926
1754449 IN     school 1810650 3005   Hamilton Southeastern Schools 181065002368 2468 New Britton Elementary School   Regular School No Elementary KG 04 2019   pk_12_total 496.0 32.0 61.0 3.0   102.0     1.0   31.0   364.0 362.0     99.0         138.0   65.0   726.0 496 32 61 3   102     1   31   364 362     99     138 65   726
1754638 IN     school 1801200 3060   Carmel Clay Schools 180120000193 2505 Carmel High School   Regular School No High 09 12 2019   pk_12_total 3877.0 192.0 194.0 5.0   681.0     19.0   318.0   2654.0 2632.0     99.0         494.0   463.0   5286.0 3877 192 194 5   681     19   318   2654 2632     99     494 463   5286
1761031 IN     school 1810140 7365   Shelbyville Central Schools 181014001627 7725 Coulston Elementary School   Regular School No Elementary PK 05 2019   pk_12_total 383.0 3.0 140.0 1.0   21.0         13.0   303.0 258.0     99.0         336.0   76.0   561.0 383 3 140 1   21         13   303 258     99     336 76   561
1784868 LA     school 2200540 017   East Baton Rouge Parish 220054000445 17100 Wildwood Elementary School   Regular School No Elementary PK 05 2021 spring pk_12_total 74.0 224.0 136.0 2.0   51.0     6.0   8.0   259.0 242.0     99.0       369.0         501 74 224 136 2   51     6   8   259 242     99   369       501
1784989 LA     school 2200840 026   Jefferson Parish 220084000609 26035 Gretna Middle School   Regular School No Middle 06 08 2021 spring pk_12_total 66.0 264.0 177.0 1.0   15.0     0.0   17.0   278.0 262.0     99.0       529.0         540 66 264 177 1   15     0   17   278 262     99   529       540
1790430 IN     school 1801200 3060   Carmel Clay Schools 180120002267 2513 Orchard Park Elementary School   Regular School No Elementary PK 05 2018   pk_12_total 432.0 50.0 57.0 2.0   111.0         56.0   356.0 352.0     99.0         240.0   105.0   708.0 432 50 57 2   111         56   356 352     99     240 105   708
1836070 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124001035 362 South Senior High Senior High School (Grades 9-12) Regular School No High 09 12 2020   grade_11 161.0 152.0 57.0   33.0 15.0     0.0   2.0   207.0 213.0     99.0   8.0     217.0   44.0   420.0 161 152 57   33 15     0   2   207 213     99 8   217 44   420
1882994 MN Hennepin 27 school 2705790 271 Independent Districts and Schools Bloomington Public School District 270579000218 446 Indian Mounds Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 05 2018   pk_12_total 83.0 90.0 97.0   3.0 32.0     1.0   35.0   150.0 191.0     99.0   12.0     229.0   53.0   341.0 83 90 97   3 32     1   35   150 191     99 12   229 53   341
1884115 MN Mower 50 school 2703450 492 Independent Districts and Schools Austin Public School District 270345004638 280 I.J. Holton Intermediate School Elementary School (Grades PK-6) Regular School No Middle 05 06 2018   pk_12_total 392.0 63.0 241.0   0.0 43.0     5.0   31.0   385.0 390.0     99.0   9.0     454.0   136.0   775.0 392 63 241   0 43     5   31   385 390     99 9   454 136   775
1884797 MN Ramsey 62 school 2733840 625 Independent Districts and Schools St. Paul Public School District 273384001565 425 Chelsea Heights Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 05 2018   pk_12_total 216.0 113.0 35.0   5.0 59.0     0.0   53.0   259.0 222.0     99.0   2.0     230.0   50.0   481.0 216 113 35   5 59     0   53   259 222     99 2   230 50   481
1890064 MN Olmsted 55 school 2731800 535 Independent Districts and Schools Rochester Public School District 273180002660 305 Century Senior High Senior High School (Grades 9-12) Regular School No High 08 12 2018   pk_12_total 1095.0 165.0 69.0   6.0 158.0     1.0   33.0   737.0 790.0     99.0   11.0     353.0   150.0   1527.0 1095 165 69   6 158     1   33   737 790     99 11   353 150   1527
1890074 MN Olmsted 55 school 2731800 535 Independent Districts and Schools Rochester Public School District 273180001016 315 Mayo Senior High Senior High School (Grades 9-12) Regular School No High 08 12 2018   pk_12_total 1110.0 207.0 182.0   6.0 135.0     0.0   49.0   854.0 835.0     99.0   17.0     516.0   222.0   1689.0 1110 207 182   6 135     0   49   854 835     99 17   516 222   1689
1907377 IN     school 1803630 235   Fort Wayne Community Schools 180363000551 217 Northcrest Elementary School   Regular School No Elementary PK 05 2020   pk_12_total 95.0 145.0 109.0 1.0   68.0         45.0   237.0 226.0     99.0         340.0   55.0   463.0 95 145 109 1   68         45   237 226     99     340 55   463
1909213 IN     school 1803270 2305   Elkhart Community Schools 180327000436 1773 Mary Daly Elementary School   Regular School No Elementary KG 06 2020   pk_12_total 165.0 93.0 184.0 1.0   1.0         50.0   237.0 257.0     99.0         410.0   80.0   494.0 165 93 184 1   1         50   237 257     99     410 80   494
1912295 IN     school 1804320 4710   School City of Hammond 180432000746 4417 Morton Senior High School   Regular School No High 09 12 2020   pk_12_total 191.0 480.0 515.0 1.0   3.0         50.0   630.0 610.0     99.0         660.0   182.0   1240.0 191 480 515 1   3         50   630 610     99     660 182   1240
1923782 IN     school 1813110 4525   Westview School Corporation 181311002365 3702 Westview Elementary School   Regular School No Middle 05 06 2021   pk_12_total 360.0   7.0               3.0   197.0 173.0     99.0         98.0   55.0   370.0 360   7               3   197 173     99     98 55   370
1925669 IN     school 1804770 5385   Indianapolis Public Schools 180477002528 5516 Northwest Community Middle School   Regular School No Middle 07 08 2021   pk_12_total 11.0 223.0 135.0               15.0   195.0 189.0     99.0         276.0   101.0   384.0 11 223 135               15   195 189     99     276 101   384
1929018 IN     school 1803450 7995   Evansville Vanderburgh School Corp 180345002649 8271 Harwood Career Prep High School   Regular School No Other KG 12 2021   pk_12_total 1927.0 799.0 181.0 12.0   44.0     40.0   412.0   1677.0 1738.0     99.0         2212.0   612.0   3415.0 1927 799 181 12   44     40   412   1677 1738     99     2212 612   3415
1948031 MN Hennepin 27 school 2733780 283 Independent Districts and Schools ST. LOUIS PARK PUBLIC SCHOOL DIST. 273378001525 745 AQUILA ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2019   pk_12_total 251.0 144.0 66.0   1.0 26.0     0.0   62.0   298.0 252.0     99.0   5.0     243.0   70.0   550.0 251 144 66   1 26     0   62   298 252     99 5   243 70   550
1952339 MN Hennepin 27 school 2700184 4068 Charter Schools EXCELL ACADEMY CHARTER 270018403137 10 EXCELL ACADEMY CHARTER Elementary School (Grades PK-6) Regular School Yes Elementary PK 08 2019   pk_12_total 1.0 392.0 27.0   0.0 2.0     0.0   4.0   198.0 228.0     99.0   12.0         52.0   426.0 1 392 27   0 2     0   4   198 228     99 12     52   426
1955107 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124001026 360 ROOSEVELT SENIOR HIGH Senior High School (Grades 9-12) Regular School No High 09 12 2019   grade_9 55.0 96.0 80.0   10.0 13.0     0.0   7.0   128.0 133.0     99.0   6.0     161.0   45.0   261.0 55 96 80   10 13     0   7   128 133     99 6   161 45   261
1955113 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124001035 362 SOUTH SENIOR HIGH Senior High School (Grades 9-12) Regular School No High 09 12 2019   grade_10 159.0 160.0 56.0   38.0 15.0     0.0   2.0   220.0 210.0     99.0   11.0     233.0   48.0   430.0 159 160 56   38 15     0   2   220 210     99 11   233 48   430
2008851 LA     school 2200870 028   Lafayette Parish 220087000678 28019 Lafayette High School   Regular School No High 09 12 2021 fall pk_12_total 838.0 681.0 175.0 7.0   97.0     0.0   24.0   878.0 944.0     99.0       1263.0         1822 838 681 175 7   97     0   24   878 944     99   1263       1822
2304044 LA     school 2200870 028   Lafayette Parish 220087000678 28019 Lafayette High School   Regular School No High 09 12 2019 spring pk_12_total 998.0 651.0 164.0 7.0   101.0     2.0   25.0   902.0 1046.0     99.0       1013.0         1948 998 651 164 7   101     2   25   902 1046     99   1013       1948
2341272 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001231 301 Parkview Elementary   Regular School No Elementary PK 05 2021   pk_12_total 9.0 185.0 16.0     158.0         13.0   199.0 182.0     99.0       326     58   381 9 185 16     158         13   199 182     99   326   58   381
2346843 WI Marathon   school 5515900 6223 Public school Wausau 551590002062 340 Thomas Jefferson Elementary   Regular School No Elementary PK 05 2021   pk_12_total 138.0 9.0 42.0 3.0   133.0         26.0   184.0 167.0     99.0       215     48   351 138 9 42 3   133         26   184 167     99   215   48   351
2538371 LA     school 2200840 026   Jefferson Parish 220084000620 26045 L.W. Higgins High School   Regular School No High 09 12 2019 fall pk_12_total 183.0 744.0 186.0 6.0   50.0     1.0   31.0   603.0000000000001 598.0     99.0       1063.0         1201 183 744 186 6   50     1   31     598     99   1063       1201
2539273 LA     school   CHA   Type 2 Charters   WBR001 Athlos Academy of Jefferson Parish             2019 fall pk_12_total 227.0 526.0 121.0 3.0   37.0     3.0   54.0   472.0 499.0     99.0       847.0         971 227 526 121 3   37     3   54   472 499     99   847       971
2587487 CA KERN 6029 school 620850 1563560 Elementary School District Lamont Elementary 62085002501 6009674 Alicante Avenue Elementary Elementary Schools (Public) Regular School No Elementary KG 06 2020 October combined_K 2.0 0.0 166.0   0.0 1.0     0.0   0.0 0.0 85.0 84.0   0.0 99.0                 169.0 2 0 166   0 1     0   0 0 85 84   0 99           169
2594716 CA SANTA CLARA 6085 school 638460 4369690 Elementary School District Sunnyvale 63846006460 6049191 Ellis Elementary Elementary Schools (Public) Regular School No Elementary KG 05 2020 October combined_K 31.0 1.0 55.0   1.0 89.0     0.0   9.0 3.0 102.0 87.0   0.0 99.0                 189.0 31 1 55   1 89     0   9 3 102 87   0 99           189
2604135 CA SAN DIEGO 6073 school 634880 3773791 Unified School District San Marcos Unified 63488005892 6039085 San Marcos Elementary Elementary Schools (Public) Regular School No Elementary KG 05 2020 October grade_1 0.0 0.0 131.0   0.0 2.0     0.0   2.0 0.0 66.0 69.0   0.0 99.0                 135.0 0 0 131   0 2     0   2 0 66 69   0 99           135
2622177 CA MONTEREY 6053 school 633930 2766142 Elementary School District Salinas City Elementary 63393005329 6026611 Sherwood Elementary Elementary Schools (Public) Regular School No Elementary KG 06 2020 October grade_3 2.0 0.0 138.0   1.0 0.0     0.0   0.0 0.0 77.0 64.0   0.0 99.0                 141.0 2 0 138   1 0     0   0 0 77 64   0 99           141
2627053 CA STANISLAUS 6099 school 625130 5071167 Elementary School District Modesto City Elementary 62513003727 6052633 Bret Harte Elementary Elementary Schools (Public) Regular School No Elementary KG 06 2020 October grade_3 3.0 0.0 100.0   0.0 2.0     0.0   0.0 11.0 61.0 55.0   0.0 99.0                 116.0 3 0 100   0 2     0   0 11 61 55   0 99           116
2643505 CA ORANGE 6059 school 602610 3066423 Elementary School District Anaheim Elementary 60261012518 121053 Ponderosa Elementary Elementary Schools (Public) Regular School No Elementary KG 06 2020 October grade_5 2.0 0.0 153.0   0.0 3.0     0.0   0.0 0.0 94.0 64.0   0.0 99.0                 158.0 2 0 153   0 3     0   0 0 94 64   0 99           158
2650094 CA CONTRA COSTA 6013 school 626370 761754 Unified School District Mt. Diablo Unified 62637003969 6004261 Riverview Middle Intermediate/Middle Schools (Public) Regular School No Middle 06 08 2020 October grade_6 6.0 30.0 176.0   0.0 17.0     3.0   6.0 5.0 121.0 122.0   0.0 99.0                 243.0 6 30 176   0 17     3   6 5 121 122   0 99           243
2651015 CA KERN 6029 school 620850 1563560 Elementary School District Lamont Elementary 62085002501 6009674 Alicante Avenue Elementary Elementary Schools (Public) Regular School No Elementary KG 06 2020 October grade_6 1.0 0.0 164.0   0.0 1.0     0.0   0.0 0.0 78.0 88.0   0.0 99.0                 166.0 1 0 164   0 1     0   0 0 78 88   0 99           166
2654593 CA ORANGE 6059 school 635310 3066670 Unified School District Santa Ana Unified 63531006013 6061758 Willard Intermediate Intermediate/Middle Schools (Public) Regular School No Middle 06 08 2020 October grade_6 1.0 0.0 193.0   1.0 1.0     0.0   0.0 0.0 119.0 77.0   0.0 99.0                 196.0 1 0 193   1 1     0   0 0 119 77   0 99           196
2664557 CA MONTEREY 6053 school 635790 2766191 Elementary School District Santa Rita Union Elementary 63579007870 6102925 Gavilan View Middle Intermediate/Middle Schools (Public) Regular School No Middle 06 08 2020 October grade_7 10.0 4.0 196.0   1.0 10.0     1.0   0.0 3.0 98.0 127.0   0.0 99.0                 225.0 10 4 196   1 10     1   0 3 98 127   0 99           225
2668593 CA SANTA CLARA 6085 school 613140 4369435 Elementary School District Evergreen Elementary 61314001493 6085690 George V. LeyVa Intermediate Intermediate/Middle Schools (Public) Regular School No Middle 07 08 2020 October grade_7 8.0 5.0 169.0   4.0 117.0     2.0   17.0 2.0 172.0 152.0   0.0 99.0                 324.0 8 5 169   4 117     2   17 2 172 152   0 99           324
2670948 CA ALAMEDA 6001 school 634680 161291 Unified School District San Leandro Unified 63468005831 6057111 Bancroft Middle Intermediate/Middle Schools (Public) Regular School No Middle 06 08 2020 October grade_8 28.0 61.0 196.0   3.0 34.0     5.0   17.0 4.0 176.0 172.0   0.0 99.0                 348.0 28 61 196   3 34     5   17 4 176 172   0 99           348
2671982 CA IMPERIAL 6025 school 612030 1363123 Elementary School District El Centro Elementary 61203001336 6008445 Kennedy Middle Intermediate/Middle Schools (Public) Regular School No Middle 07 08 2020 October grade_8 1.0 1.0 216.0   0.0 1.0     0.0   0.0 0.0 111.0 108.0   0.0 99.0                 219.0 1 1 216   0 1     0   0 0 111 108   0 99           219
2672068 CA KERN 6029 school 603630 1563321 Elementary School District Bakersfield City 60363000294 6009021 Compton Junior High Intermediate/Middle Schools (Public) Regular School No Middle 07 08 2020 October grade_8 24.0 20.0 322.0   3.0 1.0     1.0   4.0 0.0 201.0 174.0   0.0 99.0                 375.0 24 20 322   3 1     1   4 0 201 174   0 99           375
2674939 CA MERCED 6047 school 622740 2465755 Unified School District Los Banos Unified 62274013964 133413 Creekside Junior High Junior High Schools (Public) Regular School No Middle 07 08 2020 October grade_8 59.0 8.0 366.0   1.0 8.0     1.0   5.0 0.0 205.0 243.0   0.0 99.0                 448.0 59 8 366   1 8     1   5 0 205 243   0 99           448
2676257 CA RIVERSIDE 6065 school 609850 3367033 Unified School District Corona-Norco Unified 60985001046 6059026 Auburndale Intermediate Intermediate/Middle Schools (Public) Regular School No Middle 07 08 2020 October grade_8 30.0 18.0 247.0   1.0 12.0     2.0   2.0 1.0 160.0 153.0   0.0 99.0                 313.0 30 18 247   1 12     2   2 1 160 153   0 99           313
2676259 CA RIVERSIDE 6065 school 609850 3367033 Unified School District Corona-Norco Unified 60985001063 6059042 Letha Raney Intermediate Intermediate/Middle Schools (Public) Regular School No Middle 06 08 2020 October grade_8 34.0 19.0 273.0   1.0 27.0     3.0   3.0 1.0 194.0 167.0   0.0 99.0                 361.0 34 19 273   1 27     3   3 1 194 167   0 99           361
2683125 CA LOS ANGELES 6037 school 604440 1964303 Unified School District Bellflower Unified 60444000396 1930775 Bellflower High High Schools (Public) Regular School No High 07 12 2020 October grade_9 13.0 34.0 301.0   2.0 16.0     2.0   8.0 3.0 200.0 179.0   0.0 99.0                 379.0 13 34 301   2 16     2   8 3 200 179   0 99           379
2686150 CA ORANGE 6059 school 618060 3066548 High School District Huntington Beach Union High 61806002233 3030145 Ocean View High High Schools (Public) Regular School No High 09 12 2020 October grade_9 76.0 2.0 250.0   1.0 28.0     3.0   10.0 0.0 208.0 162.0   0.0 99.0                 370.0 76 2 250   1 28     3   10 0 208 162   0 99           370
2687100 CA RIVERSIDE 6065 school 634440 3367249 Unified School District San Jacinto Unified 63444005694 3337656 San Jacinto High High Schools (Public) Regular School No High 09 12 2020 October grade_9 88.0 56.0 590.0   9.0 12.0     8.0   20.0 0.0 405.0 378.0   0.0 99.0                 783.0 88 56 590   9 12     8   20 0 405 378   0 99           783
2694124 CA LOS ANGELES 6037 school 622500 1964725 Unified School District Long Beach Unified 62250005870 1995935 Cabrillo High High Schools (Public) Regular School No High 09 12 2020 October grade_10 10.0 48.0 359.0   1.0 60.0     8.0   5.0 1.0 254.0 238.0   0.0 99.0                 492.0 10 48 359   1 60     8   5 1 254 238   0 99           492
2695835 CA LOS ANGELES 6037 school 600153 1975713 Unified School District Alhambra Unified 60015310929 1930163 Alhambra High High Schools (Public) Regular School No High 09 12 2020 October grade_10 13.0 4.0 298.0   1.0 261.0     1.0   9.0 0.0 311.0 276.0   0.0 99.0                 587.0 13 4 298   1 261     1   9 0 311 276   0 99           587
2695897 CA MADERA 6039 school 623340 2065243 Unified School District Madera Unified 62334003548 2035707 Madera High High Schools (Public) Regular School No High 09 12 2020 October grade_10 42.0 12.0 475.0   2.0 11.0     0.0   4.0 3.0 283.0 266.0   0.0 99.0                 549.0 42 12 475   2 11     0   4 3 283 266   0 99           549
2697643 CA RIVERSIDE 6065 school 633150 3367215 Unified School District Riverside Unified 63315005154 3334406 John W. North High High Schools (Public) Regular School No High 09 12 2020 October grade_10 50.0 47.0 420.0   5.0 32.0     6.0   12.0 4.0 289.0 287.0   0.0 99.0                 576.0 50 47 420   5 32     6   12 4 289 287   0 99           576
2701641 CA VENTURA 6111 school 629270 5672546 High School District Oxnard Union High 62927004521 5634761 Rio Mesa High High Schools (Public) Regular School No High 09 12 2020 October grade_10 27.0 14.0 513.0   0.0 24.0     3.0   11.0 0.0 305.0 287.0   0.0 99.0                 592.0 27 14 513   0 24     3   11 0 305 287   0 99           592
2704705 CA LOS ANGELES 6037 school 622500 1964725 Unified School District Long Beach Unified 62250002751 1936947 Polytechnic High High Schools (Public) Regular School No High 09 12 2020 October grade_11 61.0 179.0 457.0   1.0 215.0     18.0   18.0 16.0 485.0 480.0   0.0 99.0                 965.0 61 179 457   1 215     18   18 16 485 480   0 99           965
2707860 CA RIVERSIDE 6065 school 602430 3366977 Unified School District Alvord Unified 60243000134 3330008 La Sierra High High Schools (Public) Regular School No High 09 12 2020 October grade_11 45.0 14.0 336.0   1.0 27.0     3.0   10.0 0.0 238.0 198.0   0.0 99.0                 436.0 45 14 336   1 27     3   10 0 238 198   0 99           436
2709462 CA SAN DIEGO 6073 school 612910 3768106 High School District Escondido Union High 61291001465 3732062 Escondido High High Schools (Public) Regular School No High 09 12 2020 October grade_11 68.0 18.0 435.0   3.0 27.0     1.0   2.0 1.0 295.0 260.0   0.0 99.0                 555.0 68 18 435   3 27     1   2 1 295 260   0 99           555
2710361 CA SAN JOAQUIN 6077 school 638010 3968676 Unified School District Stockton Unified 63801006403 3932100 Edison High High Schools (Public) Regular School No High 09 12 2020 October grade_11 6.0 60.0 393.0   7.0 77.0     6.0   10.0 0.0 286.0 273.0   0.0 99.0                 559.0 6 60 393   7 77     6   10 0 286 273   0 99           559
2716622 CA LOS ANGELES 6037 school 631320 1964907 Unified School District Pomona Unified 63132004842 1933324 Garey High High Schools (Public) Regular School No High 09 12 2020 October grade_12 2.0 7.0 350.0   0.0 13.0     0.0   2.0 0.0 203.0 171.0   0.0 99.0                 374.0 2 7 350   0 13     0   2 0 203 171   0 99           374
2717830 CA ORANGE 6059 school 614880 3066522 Unified School District Garden Grove Unified 61488001874 3035706 Rancho Alamitos High High Schools (Public) Regular School No High 09 12 2020 October grade_12 19.0 1.0 233.0   1.0 151.0     2.0   2.0 6.0 230.0 185.0   0.0 99.0                 415.0 19 1 233   1 151     2   2 6 230 185   0 99           415
2722140 CA SAN DIEGO 6073 school 634320 3768338 Unified School District San Diego Unified 63432011235 3731056 TRACE Special Education Schools (Public) Special Education School No High 09 12 2020 October grade_12 71.0 44.0 275.0   3.0 69.0     5.0   21.0 3.0 334.0 157.0   0.0 99.0                 491.0 71 44 275   3 69     5   21 3 334 157   0 99           491
2723858 CA ALAMEDA 6001 school 628050 161259 Unified School District Oakland Unified 62805004297 6072235 Martin Luther King, Jr. Elementary Elementary Schools (Public) Regular School No Elementary KG 05 2020 October k_12_total 41.0 233.0 40.0   1.0 32.0     7.0   17.0 15.0 201.0 185.0   0.0 99.0         354.0       386.0 41 233 40   1 32     7   17 15 201 185   0 99     354     386
2724606 CA FRESNO 6019 school 614550 1062166 Unified School District Fresno Unified 61455001781 6006589 Wishon Elementary Elementary Schools (Public) Regular School No Elementary KG 06 2020 October k_12_total 31.0 36.0 420.0   1.0 61.0     0.0   11.0 0.0 285.0 275.0   0.0 99.0         525.0       560.0 31 36 420   1 61     0   11 0 285 275   0 99     525     560
2725421 CA LOS ANGELES 6037 school 602970 1964261 Unified School District Arcadia Unified 60297000230 6011167 Highland Oaks Elementary Elementary Schools (Public) Regular School No Elementary KG 05 2020 October k_12_total 108.0 10.0 74.0   1.0 438.0     0.0   38.0 9.0 353.0 325.0   0.0 99.0         94.0       678.0 108 10 74   1 438     0   38 9 353 325   0 99     94     678
2725496 CA LOS ANGELES 6037 school 604830 1964311 Unified School District Beverly Hills Unified 60483000475 6011779 Horace Mann Elementary Elementary Schools (Public) Regular School No Elementary KG 05 2020 October k_12_total 437.0 13.0 68.0   0.0 99.0     2.0   58.0 14.0 361.0 330.0   0.0 99.0         127.0       691.0 437 13 68   0 99     2   58 14 361 330   0 99     127     691
2725799 CA LOS ANGELES 6037 school 620880 1964667 Elementary School District Lancaster Elementary 62088002507 6014690 Joshua Elementary Elementary Schools (Public) Regular School No Elementary KG 05 2020 October k_12_total 31.0 236.0 301.0   4.0 6.0     2.0   19.0 1.0 311.0 289.0   0.0 99.0         572.0       600.0 31 236 301   4 6     2   19 1 311 289   0 99     572     600
2725985 CA LOS ANGELES 6037 school 622710 1964733 Unified School District Los Angeles Unified 60243510836 102434 Animo South Los Angeles Charter High Schools (Public) Regular School Yes High 09 12 2020 October k_12_total 0.0 131.0 470.0   3.0 0.0     0.0   3.0 0.0 333.0 274.0   0.0 99.0         545.0       607.0 0 131 470   3 0     0   3 0 333 274   0 99     545     607
2726322 CA LOS ANGELES 6037 school 622710 1964733 Unified School District Los Angeles Unified 60211912567 121285 Alliance Cindy and Bill Simon Technology Academy H High Schools (Public) Regular School Yes High 09 12 2020 October k_12_total 3.0 52.0 445.0   0.0 0.0     0.0   0.0 0.0 263.0 237.0   0.0 99.0         423.0       500.0 3 52 445   0 0     0   0 0 263 237   0 99     423     500
2726435 CA LOS ANGELES 6037 school 622710 1964733 Unified School District Los Angeles Unified 60154213487 128041 Alliance Kory Hunter Middle Intermediate/Middle Schools (Public) Regular School Yes Middle 06 08 2020 October k_12_total 1.0 5.0 458.0   1.0 0.0     0.0   0.0 0.0 210.0 255.0   0.0 99.0         455.0       465.0 1 5 458   1 0     0   0 0 210 255   0 99     455     465
2726452 CA LOS ANGELES 6037 school 622710 1964733 Unified School District Los Angeles Unified 62271002882 6016224 Cabrillo Avenue Elementary Elementary Schools (Public) Regular School No Elementary KG 05 2020 October k_12_total 14.0 35.0 311.0   0.0 3.0     0.0   8.0 5.0 190.0 186.0   0.0 99.0         354.0       376.0 14 35 311   0 3     0   8 5 190 186   0 99     354     376
2727024 CA LOS ANGELES 6037 school 625470 1964808 Unified School District Montebello Unified 62547003802 6020614 Montebello Gardens Elementary Elementary Schools (Public) Regular School No Elementary KG 05 2020 October k_12_total 2.0 0.0 277.0   1.0 4.0     0.0   0.0 1.0 158.0 127.0   0.0 99.0         235.0       285.0 2 0 277   1 4     0   0 1 158 127   0 99     235     285
2728046 CA MONTEREY 6053 school 633930 2766142 Elementary School District Salinas City Elementary 63393005319 132407 Boronda Elementary Elementary Schools (Public) Regular School No Elementary KG 06 2020 October k_12_total 22.0 1.0 202.0   0.0 4.0     0.0   4.0 0.0 122.0 111.0   0.0 99.0         144.0       233.0 22 1 202   0 4     0   4 0 122 111   0 99     144     233
2728255 CA ORANGE 6059 school 602630 3066431 High School District Anaheim Union High 60263000175 6066815 Hope Special Education Schools (Public) Special Education School No High 07 12 2020 October k_12_total 44.0 8.0 130.0   0.0 42.0     4.0   3.0 1.0 148.0 84.0   0.0 99.0         145.0       232.0 44 8 130   0 42     4   3 1 148 84   0 99     145     232
2729585 CA SACRAMENTO 6067 school 612330 3467314 Unified School District Elk Grove Unified 61233011064 108720 Arnold Adreani Elementary Elementary Schools (Public) Regular School No Elementary KG 06 2020 October k_12_total 184.0 48.0 139.0   3.0 367.0     13.0   98.0 0.0 433.0 419.0   0.0 99.0         240.0       852.0 184 48 139   3 367     13   98 0 433 419   0 99     240     852
2729756 CA SACRAMENTO 6067 school 633840 3467439 Unified School District Sacramento City Unified 63384005273 6034201 Parkway Elementary Elementary Schools (Public) Regular School No Elementary KG 06 2020 October k_12_total 23.0 188.0 151.0   6.0 108.0     20.0   31.0 1.0 285.0 243.0   0.0 99.0         503.0       528.0 23 188 151   6 108     20   31 1 285 243   0 99     503     528
2729809 CA SACRAMENTO 6067 school 634620 3467447 Unified School District San Juan Unified 63462005812 3436714 Rio Americano High High Schools (Public) Regular School No High 09 12 2020 October k_12_total 1251.0 78.0 370.0   14.0 131.0     8.0   97.0 4.0 964.0 988.0   1.0 99.0         458.0       1953.0 1251 78 370   14 131     8   97 4 964 988   1 99     458     1953
2730027 CA SAN BERNARDINO 6071 school 608460 3667678 Unified School District Chino Valley Unified 60846011309 100578 Edwin Rhodes Elementary Elementary Schools (Public) Regular School No Elementary KG 06 2020 October k_12_total 134.0 64.0 407.0   1.0 282.0     1.0   17.0 11.0 468.0 449.0   0.0 99.0         396.0       917.0 134 64 407   1 282     1   17 11 468 449   0 99     396     917
2730425 CA SAN BERNARDINO 6071 school 600014 3675044 Unified School District Hesperia Unified 60168612333 118059 LaVerne Elementary Preparatory Academy Elementary Schools (Public) Regular School Yes Elementary KG 08 2020 October k_12_total 76.0 10.0 350.0   0.0 9.0     1.0   9.0 2.0 215.0 242.0   0.0 99.0         282.0       457.0 76 10 350   0 9     1   9 2 215 242   0 99     282     457
2730466 CA SAN BERNARDINO 6071 school 600017 3675077 Unified School District Apple Valley Unified 60001711122 108423 Vanguard Preparatory Elementary Schools (Public) Regular School No Elementary KG 08 2020 October k_12_total 553.0 44.0 568.0   4.0 15.0     1.0   11.0 0.0 624.0 572.0   0.0 99.0         768.0       1196.0 553 44 568   4 15     1   11 0 624 572   0 99     768     1196

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "enrollments" (
   [state] TEXT,
   [county] TEXT,
   [county_state_id] INTEGER,
   [admin_level] TEXT,
   [district_nces_id] INTEGER,
   [district_state_id] TEXT,
   [district_state_type] TEXT,
   [district] TEXT,
   [school_nces_id] INTEGER,
   [school_state_id] INTEGER,
   [school] TEXT,
   [school_state_type] TEXT,
   [ccd_school_type] TEXT,
   [ccd_charter_school] TEXT,
   [ccd_school_lvl] TEXT,
   [ccd_school_low_grade] TEXT,
   [ccd_school_high_grade] TEXT,
   [year] INTEGER,
   [term] TEXT,
   [grade] TEXT,
   [white] TEXT,
   [black] TEXT,
   [hispanic] TEXT,
   [native_american] TEXT,
   [native_american_alaskan_native] TEXT,
   [asian] TEXT,
   [native_hawaiian] TEXT,
   [asian_pacific_islander] TEXT,
   [native_hawaiian_pacific_islander] TEXT,
   [pacific_islander] TEXT,
   [multiracial] TEXT,
   [unknown_race] TEXT,
   [male] TEXT,
   [female] TEXT,
   [non_binary] TEXT,
   [unknown_gender] TEXT,
   [ell] TEXT,
   [ell_percent] TEXT,
   [homeless] TEXT,
   [homeless_percent] TEXT,
   [low_income] TEXT,
   [free_and_reduced] TEXT,
   [free_and_reduced_percent] TEXT,
   [disability] TEXT,
   [section_504] TEXT,
   [total] TEXT
, [white_int] INTEGER, [black_int] INTEGER, [hispanic_int] INTEGER, [native_american_int] INTEGER, [native_american_alaskan_native_int] INTEGER, [asian_int] INTEGER, [native_hawaiian_int] INTEGER, [asian_pacific_islander_int] INTEGER, [native_hawaiian_pacific_islander_int] INTEGER, [pacific_islander_int] INTEGER, [multiracial_int] INTEGER, [unknown_race_int] INTEGER, [male_int] INTEGER, [female_int] INTEGER, [non_binary_int] INTEGER, [unknown_gender_int] INTEGER, [ell_int] INTEGER, [homeless_int] INTEGER, [low_income_int] INTEGER, [free_and_reduced_int] INTEGER, [disability_int] INTEGER, [section_504_int] INTEGER, [total_int] INTEGER);
CREATE INDEX [idx_enrollments_state_grade]
    ON [enrollments] ([state], [grade]);
CREATE INDEX [idx_enrollments_grade]
    ON [enrollments] ([grade]);
CREATE INDEX [idx_enrollments_year]
    ON [enrollments] ([year]);
CREATE INDEX [idx_enrollments_state_year]
    ON [enrollments] ([state], [year]);
CREATE INDEX [idx_enrollments_school_nces_id]
    ON [enrollments] ([school_nces_id]);
CREATE INDEX [idx_enrollments_district_nces_id]
    ON [enrollments] ([district_nces_id]);