enrollments
Data source: Big Local News · About: Big Local
3,371,677 rows sorted by ell_percent descending
This data as json, CSV (advanced)
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3012092 | 3012092 | SD | school | 4646380 | 15002 | McLaughlin 15-2 | 464638000922 | 3 | McLaughlin Middle School | Regular School | No | Middle | 06 | 08 | 2017 | k_12_total | 3.0 | 2.0 | 104.0 | 56.0 | 53.0 | 9.2 | 109.0 | 3 | 2 | 104 | 56 | 53 | 109 | |||||||||||||||||||||||||||||||||||||||||
| 3349956 | 3349956 | SD | school | 4646380 | 15002 | McLaughlin 15-2 | 464638000922 | 3 | McLaughlin Middle School | Regular School | No | 2 | 06 | 08 | 2016 | k_12_total | 2.0 | 96.0 | 1.0 | 52.0 | 47.0 | 9.2 | 99.0 | 2 | 96 | 1 | 52 | 47 | 99 | |||||||||||||||||||||||||||||||||||||||||
| 258329 | 258329 | SD | school | 4666270 | 49005 | Sioux Falls 49-5 | 466627001238 | 26 | Discovery Elementary | Regular School | No | Elementary | PK | 05 | 2018 | k_12_total | 685.0 | 67.0 | 65.0 | 8.0 | 16.0 | 1.0 | 48.0 | 438.0 | 452.0 | 9.1 | 890.0 | 685 | 67 | 65 | 8 | 16 | 1 | 48 | 438 | 452 | 890 | |||||||||||||||||||||||||||||||||
| 451843 | 451843 | SD | school | 4622410 | 28002 | Estelline 28-2 | 462241000192 | 1 | Estelline High School | Regular School | Not applicable | High | 09 | 12 | 2021 | k_12_total | 68.0 | 9.0 | 41.0 | 36.0 | 9.1 | 77.0 | 68 | 9 | 41 | 36 | 77 | |||||||||||||||||||||||||||||||||||||||||||
| 458271 | 458271 | SD | school | 4672090 | 66001 | Todd County 66-1 | 467209000503 | 8 | Klein Elementary | Regular School | Not applicable | Elementary | KG | 08 | 2021 | k_12_total | 3.0 | 6.0 | 1.0 | 1.0 | 8.0 | 3.0 | 9.1 | 11.0 | 3 | 6 | 1 | 1 | 8 | 3 | 11 | |||||||||||||||||||||||||||||||||||||||
| 2368798 | 2368798 | NJ | Essex | 13 | school | 3415330 | 4900 | South Orange-Maplewood School District | 341533002428 | 60 | Clinton Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | pk_12_total | 337.0 | 119.0 | 64.0 | 0.0 | 30.0 | 0.0 | 31.0 | 9.1 | 0.2 | 16.7 | 581.0 | 337 | 119 | 64 | 0 | 30 | 0 | 31 | 581 | |||||||||||||||||||||||||||||||||
| 2368984 | 2368984 | NJ | Hudson | 17 | school | 3407890 | 2410 | Kearny | 340789002870 | 80 | Garfield Elementary School | Regular School | No | Elementary | PK | 06 | 2021 | pk_12_total | 138.0 | 7.0 | 294.0 | 0.0 | 17.0 | 0.0 | 7.0 | 9.1 | 0.0 | 61.4 | 463.0 | 138 | 7 | 294 | 0 | 17 | 0 | 7 | 463 | |||||||||||||||||||||||||||||||||
| 2369019 | 2369019 | NJ | Hudson | 17 | school | 3417580 | 5670 | West New York School District | 341758000547 | 110 | West New York Middle School | Regular School | No | Middle | 07 | 08 | 2021 | pk_12_total | 28.0 | 14.0 | 1061.0 | 0.0 | 11.0 | 0.0 | 1.0 | 9.1 | 0.0 | 86.69999999999999 | 1115.0 | 28 | 14 | 1061 | 0 | 11 | 0 | 1 | 1115 | |||||||||||||||||||||||||||||||||
| 2369396 | 2369396 | NJ | Monmouth | 25 | school | 3405640 | 1660 | Freehold Township School District | 340564006120 | 70 | Early Childhood Learning Center | Regular School | No | Prekindergarten | PK | PK | 2021 | pk_12_total | 49.0 | 3.0 | 22.0 | 0.0 | 1.0 | 0.0 | 2.0 | 9.1 | 1.3 | 31.200000000000003 | 77.0 | 49 | 3 | 22 | 0 | 1 | 0 | 2 | 77 | |||||||||||||||||||||||||||||||||
| 2473122 | 2473122 | NJ | Bergen | 3 | school | 3404770 | 1380 | Englewood Cliffs Boro | 340477000402 | 40 | North Cliff School | Regular School | No | Elementary | PK | 02 | 2020 | pk_12_total | 50.0 | 4.0 | 15.0 | 0.0 | 91.0 | 0.0 | 5.0 | 9.1 | 0.0 | 0.0 | 165.0 | 50 | 4 | 15 | 0 | 91 | 0 | 5 | 165 | |||||||||||||||||||||||||||||||||
| 2473579 | 2473579 | NJ | Camden | 7 | school | 3412870 | 4060 | Pennsauken Twp | 341287001610 | 50 | Pennsauken High School | Regular School | No | High | 09 | 12 | 2020 | pk_12_total | 137.0 | 380.0 | 638.0 | 0.0 | 175.0 | 6.0 | 15.0 | 9.1 | 0.7 | 61.400000000000006 | 1351.0 | 137 | 380 | 638 | 0 | 175 | 6 | 15 | 1351 | |||||||||||||||||||||||||||||||||
| 2474589 | 2474589 | NJ | Monmouth | 25 | school | 3412060 | 3810 | Ocean Twp | 341206004064 | 60 | Ocean Township Elementary School | Regular School | No | Elementary | PK | 04 | 2020 | pk_12_total | 182.0 | 77.0 | 71.0 | 1.0 | 28.0 | 0.0 | 13.0 | 9.1 | 1.1 | 37.9 | 372.0 | 182 | 77 | 71 | 1 | 28 | 0 | 13 | 372 | |||||||||||||||||||||||||||||||||
| 2474727 | 2474727 | NJ | Morris | 27 | school | 3412480 | 3950 | Parsippany-Troy Hills Twp | 341248004438 | 62 | Eastlake Elementary School | Regular School | No | Elementary | PK | 05 | 2020 | pk_12_total | 74.0 | 6.0 | 44.0 | 0.0 | 228.0 | 0.0 | 10.0 | 9.1 | 0.0 | 9.7 | 362.0 | 74 | 6 | 44 | 0 | 228 | 0 | 10 | 362 | |||||||||||||||||||||||||||||||||
| 2474955 | 2474955 | NJ | Passaic | 31 | school | 3412690 | 4010 | Paterson City | 341269006099 | 50 | School 1 | Regular School | No | Elementary | KG | 05 | 2020 | pk_12_total | 1.0 | 82.0 | 103.0 | 0.0 | 1.0 | 0.0 | 0.0 | 9.1 | 0.5 | 81.3 | 187.0 | 1 | 82 | 103 | 0 | 1 | 0 | 0 | 187 | |||||||||||||||||||||||||||||||||
| 365592 | 365592 | SD | school | 4666270 | 49005 | Sioux Falls 49-5 | 466627001238 | 26 | Discovery Elementary | Regular School | No | Elementary | PK | 05 | 2019 | k_12_total | 681.0 | 71.0 | 64.0 | 5.0 | 18.0 | 2.0 | 44.0 | 433.0 | 452.0 | 9.0 | 885.0 | 681 | 71 | 64 | 5 | 18 | 2 | 44 | 433 | 452 | 885 | |||||||||||||||||||||||||||||||||
| 490225 | 490225 | SD | school | 4621390 | 5003 | Elkton 05-3 | 462139000187 | 2 | Elkton Elementary School | Regular School | Not applicable | Elementary | PK | 06 | 2020 | k_12_total | 141.0 | 28.0 | 1.0 | 0.0 | 8.0 | 90.0 | 88.0 | 9.0 | 178.0 | 141 | 28 | 1 | 0 | 8 | 90 | 88 | 178 | |||||||||||||||||||||||||||||||||||||
| 2369078 | 2369078 | NJ | Mercer | 21 | school | 3404320 | 1245 | East Windsor Regional School District | 340432003060 | 70 | Melvin H. Kreps Middle School | Regular School | No | Middle | 06 | 08 | 2021 | pk_12_total | 348.0 | 120.0 | 544.0 | 0.0 | 193.0 | 3.0 | 30.0 | 9.0 | 0.3 | 40.7 | 1238.0 | 348 | 120 | 544 | 0 | 193 | 3 | 30 | 1238 | |||||||||||||||||||||||||||||||||
| 2369899 | 2369899 | NJ | Passaic | 31 | school | 3412690 | 4010 | Paterson Public School District | 341269006099 | 50 | School 1 | Regular School | No | Elementary | KG | 05 | 2021 | pk_12_total | 2.0 | 94.0 | 135.0 | 0.0 | 3.0 | 0.0 | 0.0 | 9.0 | 0.4 | 55.1 | 234.0 | 2 | 94 | 135 | 0 | 3 | 0 | 0 | 234 | |||||||||||||||||||||||||||||||||
| 2370309 | 2370309 | NJ | Warren | 41 | school | 3412960 | 4100 | Phillipsburg School District | 341296005860 | 105 | Phillipsburg Elementary School | Regular School | No | Elementary | 03 | 05 | 2021 | pk_12_total | 270.0 | 126.0 | 152.0 | 1.0 | 8.0 | 0.0 | 52.0 | 9.0 | 0.7 | 70.4 | 609.0 | 270 | 126 | 152 | 1 | 8 | 0 | 52 | 609 | |||||||||||||||||||||||||||||||||
| 2472990 | 2472990 | NJ | Atlantic | 1 | school | 3400960 | 110 | Atlantic City | 340096000010 | 10 | Atlantic City High School | Regular School | No | High | 09 | 12 | 2020 | pk_12_total | 217.0 | 472.0 | 637.0 | 0.0 | 358.0 | 21.0 | 12.0 | 9 | 1.6 | 83.3 | 1717.0 | 217 | 472 | 637 | 0 | 358 | 21 | 12 | 1717 | |||||||||||||||||||||||||||||||||
| 2473243 | 2473243 | NJ | Bergen | 3 | school | 3412420 | 3930 | Paramus Boro | 341242000400 | 90 | Midland Elementary School | Regular School | No | Elementary | KG | 04 | 2020 | pk_12_total | 68.0 | 5.0 | 29.0 | 2.0 | 68.0 | 1.0 | 4.0 | 9 | 0.0 | 6.199999999999999 | 177.0 | 68 | 5 | 29 | 2 | 68 | 1 | 4 | 177 | |||||||||||||||||||||||||||||||||
| 2473511 | 2473511 | NJ | Camden | 7 | school | 3403000 | 800 | Cherry Hill Twp | 340300001430 | 69 | Clara Barton Elementary School | Regular School | No | Elementary | KG | 05 | 2020 | pk_12_total | 230.0 | 38.0 | 119.0 | 3.0 | 63.0 | 1.0 | 25.0 | 9 | 0.6 | 31.1 | 479.0 | 230 | 38 | 119 | 3 | 63 | 1 | 25 | 479 | |||||||||||||||||||||||||||||||||
| 2473523 | 2473523 | NJ | Camden | 7 | school | 3403240 | 880 | Clementon Boro | 340324005899 | 10 | Clementon Elementary School | Regular School | No | Elementary | PK | 08 | 2020 | pk_12_total | 174.0 | 120.0 | 172.0 | 0.0 | 6.0 | 0.0 | 19.0 | 9 | 2.4 | 60.5 | 491.0 | 174 | 120 | 172 | 0 | 6 | 0 | 19 | 491 | |||||||||||||||||||||||||||||||||
| 2474805 | 2474805 | NJ | Ocean | 29 | school | 3407740 | 2360 | Jackson Twp | 340774000463 | 30 | Crawford-Rodriguez Elementary School | Regular School | No | Elementary | PK | 05 | 2020 | pk_12_total | 417.0 | 48.0 | 146.0 | 0.0 | 16.0 | 0.0 | 18.0 | 9 | 0.3 | 33.5 | 645.0 | 417 | 48 | 146 | 0 | 16 | 0 | 18 | 645 | |||||||||||||||||||||||||||||||||
| 2475246 | 2475246 | NJ | Union | 39 | school | 3404590 | 1320 | Elizabeth City | 340459003043 | 405 | Alexander Hamilton Preparatory Academy | Regular School | No | High | 09 | 12 | 2020 | pk_12_total | 74.0 | 97.0 | 829.0 | 0.0 | 12.0 | 0.0 | 0.0 | 9 | 0.3 | 78.39999999999999 | 1012.0 | 74 | 97 | 829 | 0 | 12 | 0 | 0 | 1012 | |||||||||||||||||||||||||||||||||
| 450746 | 450746 | SD | school | 4612940 | 12002 | Clark 12-2 | 461294001082 | 5 | Hillcrest Colony Elementary | Regular School | Not applicable | Elementary | KG | 08 | 2021 | k_12_total | 29.0 | 16.0 | 13.0 | 89.7 | 29.0 | 29 | 16 | 13 | 29 | |||||||||||||||||||||||||||||||||||||||||||||
| 3014070 | 3014070 | SD | school | 4664140 | 39004 | Rutland 39-4 | 466414001348 | 4 | Camridge Colony School | Regular School | No | Elementary | KG | 08 | 2017 | k_12_total | 19.0 | 9.0 | 10.0 | 89.5 | 19.0 | 19 | 9 | 10 | 19 | |||||||||||||||||||||||||||||||||||||||||||||
| 3351934 | 3351934 | SD | school | 4664140 | 39004 | Rutland 39-4 | 466414001348 | 4 | Camridge Colony School | Regular School | No | 1 | KG | 08 | 2016 | k_12_total | 14.0 | 6.0 | 8.0 | 89.5 | 14.0 | 14 | 6 | 8 | 14 | |||||||||||||||||||||||||||||||||||||||||||||
| 495128 | 495128 | SD | school | 4663360 | 54004 | Rosholt 54-4 | 466336000558 | 3 | White Rock Colony Elem | Regular School | Not applicable | Elementary | KG | 08 | 2020 | k_12_total | 18.0 | 11.0 | 7.0 | 88.9 | 18.0 | 18 | 11 | 7 | 18 | |||||||||||||||||||||||||||||||||||||||||||||
| 452349 | 452349 | SD | school | 4625500 | 33001 | Freeman 33-1 | 462550000221 | 3 | Tschetter Colony Elementary | Regular School | Not applicable | Elementary | KG | 08 | 2021 | k_12_total | 35.0 | 23.0 | 12.0 | 88.6 | 35.0 | 35 | 23 | 12 | 35 | |||||||||||||||||||||||||||||||||||||||||||||
| 459414 | 459414 | SD | school | 4679350 | 12003 | Willow Lake 12-3 | 467935001297 | 6 | Collins Colony Elem | Regular School | Not applicable | Elementary | KG | 08 | 2021 | k_12_total | 16.0 | 8.0 | 8.0 | 87.5 | 16.0 | 16 | 8 | 8 | 16 | |||||||||||||||||||||||||||||||||||||||||||||
| 488560 | 488560 | SD | school | 4600041 | 45004 | Britton-Hecla 45-4 | 460004101143 | 4 | Sunset Colony Elementary | Regular School | Not applicable | Elementary | KG | 08 | 2020 | k_12_total | 24.0 | 16.0 | 8.0 | 87.5 | 24.0 | 24 | 16 | 8 | 24 | |||||||||||||||||||||||||||||||||||||||||||||
| 489785 | 489785 | SD | school | 4619170 | 56002 | Doland 56-2 | 461917001299 | 6 | Camrose Colony Elementary | Regular School | Not applicable | Elementary | KG | 08 | 2020 | k_12_total | 8.0 | 5.0 | 3.0 | 87.5 | 8.0 | 8 | 5 | 3 | 8 | |||||||||||||||||||||||||||||||||||||||||||||
| 456766 | 456766 | SD | school | 4664140 | 39004 | Rutland 39-4 | 466414001348 | 4 | Camridge Colony School | Regular School | Not applicable | Elementary | KG | 08 | 2021 | k_12_total | 23.0 | 13.0 | 10.0 | 87.0 | 23.0 | 23 | 13 | 10 | 23 | |||||||||||||||||||||||||||||||||||||||||||||
| 254486 | 254486 | SD | school | 4635480 | 2002 | Huron 02-2 | 463548000318 | 15 | Riverside Colony Elementary | Regular School | No | Elementary | KG | 08 | 2018 | k_12_total | 15.0 | 10.0 | 5.0 | 86.7 | 15.0 | 15 | 10 | 5 | 15 | |||||||||||||||||||||||||||||||||||||||||||||
| 361713 | 361713 | SD | school | 4635480 | 2002 | Huron 02-2 | 463548000318 | 15 | Riverside Colony Elementary | Regular School | No | Elementary | KG | 08 | 2019 | k_12_total | 15.0 | 8.0 | 7.0 | 86.7 | 15.0 | 15 | 8 | 7 | 15 | |||||||||||||||||||||||||||||||||||||||||||||
| 456705 | 456705 | SD | school | 4663360 | 54004 | Rosholt 54-4 | 466336000558 | 3 | White Rock Colony Elem | Regular School | Not applicable | Elementary | KG | 08 | 2021 | k_12_total | 22.0 | 14.0 | 8.0 | 86.4 | 22.0 | 22 | 14 | 8 | 22 | |||||||||||||||||||||||||||||||||||||||||||||
| 489169 | 489169 | SD | school | 4612940 | 12002 | Clark 12-2 | 461294001082 | 5 | Hillcrest Colony Elementary | Regular School | Not applicable | Elementary | KG | 08 | 2020 | k_12_total | 29.0 | 18.0 | 11.0 | 86.2 | 29.0 | 29 | 18 | 11 | 29 | |||||||||||||||||||||||||||||||||||||||||||||
| 455054 | 455054 | SD | school | 4600002 | 25004 | Milbank 25-4 | 460000201390 | 4 | Blue Sky Colony | Regular School | Not applicable | Elementary | KG | 08 | 2021 | k_12_total | 7.0 | 1.0 | 6.0 | 85.7 | 7.0 | 7 | 1 | 6 | 7 | |||||||||||||||||||||||||||||||||||||||||||||
| 497807 | 497807 | SD | school | 4679350 | 12003 | Willow Lake 12-3 | 467935001137 | 5 | Shamrock Colony | Regular School | Not applicable | Elementary | KG | 08 | 2020 | k_12_total | 14.0 | 6.0 | 8.0 | 85.7 | 14.0 | 14 | 6 | 8 | 14 | |||||||||||||||||||||||||||||||||||||||||||||
| 489168 | 489168 | SD | school | 4612940 | 12002 | Clark 12-2 | 461294001081 | 4 | Fordham Colony Elementary | Regular School | Not applicable | Elementary | KG | 08 | 2020 | k_12_total | 34.0 | 11.0 | 23.0 | 85.3 | 34.0 | 34 | 11 | 23 | 34 | |||||||||||||||||||||||||||||||||||||||||||||
| 2475286 | 2475286 | NJ | Union | 39 | school | 3413140 | 4160 | Plainfield City | 341314005626 | 170 | Charles H. Stillman Elementary School | Regular School | No | Elementary | KG | 05 | 2020 | pk_12_total | 0.0 | 8.0 | 358.0 | 0.0 | 0.0 | 0.0 | 1.0 | 85.3 | 0.0 | 93.2 | 367.0 | 0 | 8 | 358 | 0 | 0 | 0 | 1 | 367 | |||||||||||||||||||||||||||||||||
| 358900 | 358900 | SD | school | 4612940 | 12002 | Clark 12-2 | 461294001082 | 5 | Hillcrest Colony Elementary | Regular School | No | Elementary | KG | 08 | 2019 | k_12_total | 27.0 | 17.0 | 10.0 | 85.2 | 27.0 | 27 | 17 | 10 | 27 | |||||||||||||||||||||||||||||||||||||||||||||
| 489170 | 489170 | SD | school | 4612940 | 12002 | Clark 12-2 | 461294001319 | 7 | Silver Creek Colony | Regular School | Not applicable | Elementary | KG | 08 | 2020 | k_12_total | 38.0 | 20.0 | 18.0 | 84.2 | 38.0 | 38 | 20 | 18 | 38 | |||||||||||||||||||||||||||||||||||||||||||||
| 459415 | 459415 | SD | school | 4679350 | 12003 | Willow Lake 12-3 | 467935001067 | 4 | Mayfield Colony Elem | Regular School | Not applicable | Elementary | KG | 08 | 2021 | k_12_total | 25.0 | 12.0 | 13.0 | 84.0 | 25.0 | 25 | 12 | 13 | 25 | |||||||||||||||||||||||||||||||||||||||||||||
| 367506 | 367506 | SD | school | 4679350 | 12003 | Willow Lake 12-3 | 467935001137 | 5 | Shamrock Colony | Regular School | No | Elementary | KG | 08 | 2019 | k_12_total | 12.0 | 6.0 | 6.0 | 83.3 | 12.0 | 12 | 6 | 6 | 12 | |||||||||||||||||||||||||||||||||||||||||||||
| 458426 | 458426 | SD | school | 4672450 | 33005 | Tripp-Delmont 33-5 | 467245001091 | 7 | Clearfield Colony Elementary | Regular School | Not applicable | Elementary | KG | 08 | 2021 | k_12_total | 12.0 | 4.0 | 8.0 | 83.3 | 12.0 | 12 | 4 | 8 | 12 | |||||||||||||||||||||||||||||||||||||||||||||
| 251541 | 251541 | SD | school | 4612300 | 39001 | Chester Area 39-1 | 461230001377 | 7 | Gracevale Colony | Regular School | No | Elementary | KG | 08 | 2018 | k_12_total | 16.0 | 9.0 | 7.0 | 81.3 | 16.0 | 16 | 9 | 7 | 16 | |||||||||||||||||||||||||||||||||||||||||||||
| 455223 | 455223 | SD | school | 4648390 | 17002 | Mitchell 17-2 | 464839000444 | 10 | Rockport Colony Elem | Regular School | Not applicable | Elementary | KG | 08 | 2021 | k_12_total | 16.0 | 8.0 | 8.0 | 81.3 | 16.0 | 16 | 8 | 8 | 16 | |||||||||||||||||||||||||||||||||||||||||||||
| 489069 | 489069 | SD | school | 4612300 | 39001 | Chester Area 39-1 | 461230001377 | 7 | Gracevale Colony | Regular School | Not applicable | Elementary | KG | 08 | 2020 | k_12_total | 16.0 | 9.0 | 7.0 | 81.3 | 16.0 | 16 | 9 | 7 | 16 | |||||||||||||||||||||||||||||||||||||||||||||
| 491982 | 491982 | SD | school | 4635480 | 2002 | Huron 02-2 | 463548000318 | 15 | Riverside Colony Elementary | Regular School | Not applicable | Elementary | KG | 08 | 2020 | k_12_total | 16.0 | 8.0 | 8.0 | 81.3 | 16.0 | 16 | 8 | 8 | 16 | |||||||||||||||||||||||||||||||||||||||||||||
| 364904 | 364904 | SD | school | 4664140 | 39004 | Rutland 39-4 | 466414001348 | 4 | Camridge Colony School | Regular School | No | Elementary | KG | 08 | 2019 | k_12_total | 21.0 | 13.0 | 8.0 | 81.0 | 21.0 | 21 | 13 | 8 | 21 | |||||||||||||||||||||||||||||||||||||||||||||
| 455361 | 455361 | SD | school | 4648780 | 43002 | Montrose 43-2 | 464878001095 | 4 | Orland Colony | Regular School | Not applicable | Elementary | KG | 08 | 2021 | k_12_total | 31.0 | 20.0 | 11.0 | 80.7 | 31.0 | 31 | 20 | 11 | 31 | |||||||||||||||||||||||||||||||||||||||||||||
| 490525 | 490525 | SD | school | 4624030 | 24004 | Faulkton Area | 462403001158 | 6 | Blumengard Colony Elem | Regular School | Not applicable | Elementary | KG | 08 | 2020 | k_12_total | 31.0 | 18.0 | 13.0 | 80.7 | 31.0 | 31 | 18 | 13 | 31 | |||||||||||||||||||||||||||||||||||||||||||||
| 358901 | 358901 | SD | school | 4612940 | 12002 | Clark 12-2 | 461294001319 | 7 | Silver Creek Colony | Regular School | No | Elementary | KG | 08 | 2019 | k_12_total | 41.0 | 22.0 | 19.0 | 80.5 | 41.0 | 41 | 22 | 19 | 41 | |||||||||||||||||||||||||||||||||||||||||||||
| 451362 | 451362 | SD | school | 4619170 | 56002 | Doland 56-2 | 461917001299 | 6 | Camrose Colony Elementary | Regular School | Not applicable | Elementary | KG | 08 | 2021 | k_12_total | 10.0 | 7.0 | 3.0 | 80.0 | 10.0 | 10 | 7 | 3 | 10 | |||||||||||||||||||||||||||||||||||||||||||||
| 453654 | 453654 | SD | school | 4636060 | 22006 | Ipswich Public 22-6 | 463606001085 | 5 | Deerfield Colony Elem | Regular School | Not applicable | Elementary | PK | 08 | 2021 | k_12_total | 20.0 | 12.0 | 8.0 | 80.0 | 20.0 | 20 | 12 | 8 | 20 | |||||||||||||||||||||||||||||||||||||||||||||
| 458427 | 458427 | SD | school | 4672450 | 33005 | Tripp-Delmont 33-5 | 467245000067 | 5 | Greenwood Colony Elementary | Regular School | Not applicable | Elementary | KG | 08 | 2021 | k_12_total | 5.0 | 1.0 | 4.0 | 80.0 | 5.0 | 5 | 1 | 4 | 5 | |||||||||||||||||||||||||||||||||||||||||||||
| 490772 | 490772 | SD | school | 4625500 | 33001 | Freeman 33-1 | 462550000221 | 3 | Tschetter Colony Elementary | Regular School | Not applicable | Elementary | KG | 08 | 2020 | k_12_total | 30.0 | 19.0 | 11.0 | 80.0 | 30.0 | 30 | 19 | 11 | 30 | |||||||||||||||||||||||||||||||||||||||||||||
| 497805 | 497805 | SD | school | 4679350 | 12003 | Willow Lake 12-3 | 467935001297 | 6 | Collins Colony Elem | Regular School | Not applicable | Elementary | KG | 08 | 2020 | k_12_total | 15.0 | 8.0 | 7.0 | 80.0 | 15.0 | 15 | 8 | 7 | 15 | |||||||||||||||||||||||||||||||||||||||||||||
| 3012322 | 3012322 | SD | school | 4647100 | 33002 | Menno 33-2 | 464710000417 | 3 | Jamesville Colony Elementary | Regular School | No | Elementary | KG | 08 | 2017 | k_12_total | 15.0 | 9.0 | 6.0 | 80.0 | 15.0 | 15 | 9 | 6 | 15 | |||||||||||||||||||||||||||||||||||||||||||||
| 3350186 | 3350186 | SD | school | 4647100 | 33002 | Menno 33-2 | 464710000417 | 3 | Jamesville Colony Elementary | Regular School | No | 1 | PK | 08 | 2016 | k_12_total | 16.0 | 8.0 | 8.0 | 80.0 | 16.0 | 16 | 8 | 8 | 16 | |||||||||||||||||||||||||||||||||||||||||||||
| 451787 | 451787 | SD | school | 4621390 | 5003 | Elkton 05-3 | 462139000188 | 1 | Elkton High School | Regular School | Not applicable | High | 09 | 12 | 2021 | k_12_total | 96.0 | 13.0 | 1.0 | 3.0 | 62.0 | 51.0 | 8.9 | 113.0 | 96 | 13 | 1 | 3 | 62 | 51 | 113 | |||||||||||||||||||||||||||||||||||||||
| 487457 | 487457 | SD | school | 4602070 | 6001 | Aberdeen 06-1 | 460207000008 | 9 | May Overby Elementary | Regular School | Not applicable | Elementary | KG | 05 | 2020 | k_12_total | 250.0 | 14.0 | 45.0 | 22.0 | 17.0 | 1.0 | 22.0 | 182.0 | 189.0 | 8.9 | 371.0 | 250 | 14 | 45 | 22 | 17 | 1 | 22 | 182 | 189 | 371 | |||||||||||||||||||||||||||||||||
| 489787 | 489787 | SD | school | 4619170 | 56002 | Doland 56-2 | 461917000170 | 3 | Doland Elementary | Regular School | Not applicable | Elementary | PK | 06 | 2020 | k_12_total | 51.0 | 5.0 | 33.0 | 23.0 | 8.9 | 56.0 | 51 | 5 | 33 | 23 | 56 | |||||||||||||||||||||||||||||||||||||||||||
| 493478 | 493478 | SD | school | 4600002 | 25004 | Milbank 25-4 | 460000200423 | 3 | Koch Elementary | Regular School | Not applicable | Elementary | PK | 05 | 2020 | k_12_total | 337.0 | 4.0 | 54.0 | 3.0 | 1.0 | 0.0 | 18.0 | 221.0 | 196.0 | 8.9 | 417.0 | 337 | 4 | 54 | 3 | 1 | 0 | 18 | 221 | 196 | 417 | |||||||||||||||||||||||||||||||||
| 2367964 | 2367964 | NJ | Atlantic | 1 | school | 3413200 | 4180 | Pleasantville Public School District | 341320000219 | 55 | Pleasantville Middle School | Regular School | No | Middle | 06 | 08 | 2021 | pk_12_total | 8.0 | 245.0 | 541.0 | 0.0 | 13.0 | 0.0 | 4.0 | 8.9 | 0.7 | 81.30000000000001 | 811.0 | 8 | 245 | 541 | 0 | 13 | 0 | 4 | 811 | |||||||||||||||||||||||||||||||||
| 2367997 | 2367997 | NJ | Bergen | 3 | school | 3402790 | 740 | Carlstadt Publicschool District | 340279000813 | 50 | Carlstadt Public School | Regular School | No | Elementary | PK | 08 | 2021 | pk_12_total | 269.0 | 21.0 | 175.0 | 0.0 | 41.0 | 2.0 | 8.0 | 8.9 | 0.0 | 26.9 | 516.0 | 269 | 21 | 175 | 0 | 41 | 2 | 8 | 516 | |||||||||||||||||||||||||||||||||
| 2368022 | 2368022 | NJ | Bergen | 3 | school | 3404660 | 1345 | Elmwood Park School District | 340466000374 | 80 | Gilbert Avenue School | Regular School | No | Elementary | PK | 05 | 2021 | pk_12_total | 171.0 | 43.0 | 145.0 | 1.0 | 29.0 | 0.0 | 3.0 | 8.9 | 1.5 | 40.6 | 392.0 | 171 | 43 | 145 | 1 | 29 | 0 | 3 | 392 | |||||||||||||||||||||||||||||||||
| 2369084 | 2369084 | NJ | Mercer | 21 | school | 3404920 | 1430 | Ewing Township School District | 340492003082 | 130 | Parkway Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | pk_12_total | 51.0 | 195.0 | 71.0 | 0.0 | 12.0 | 0.0 | 29.0 | 8.9 | 0.6 | 58.7 | 358.0 | 51 | 195 | 71 | 0 | 12 | 0 | 29 | 358 | |||||||||||||||||||||||||||||||||
| 2369645 | 2369645 | NJ | Morris | 27 | school | 3412480 | 3950 | Parsippany-Troy Hills Township School District | 341248004452 | 103 | Northvail Elementary School | Regular School | No | Elementary | KG | 05 | 2021 | pk_12_total | 57.0 | 16.0 | 16.0 | 1.0 | 279.0 | 0.0 | 12.0 | 8.9 | 0.0 | 7.0 | 381.0 | 57 | 16 | 16 | 1 | 279 | 0 | 12 | 381 | |||||||||||||||||||||||||||||||||
| 2370246 | 2370246 | NJ | Union | 39 | school | 3415900 | 5090 | Summit Public School District | 341590005712 | 70 | Brayton Elementary School | Regular School | No | Elementary | 01 | 05 | 2021 | pk_12_total | 214.0 | 10.0 | 49.0 | 0.0 | 29.0 | 0.0 | 14.0 | 8.9 | 0.0 | 13.2 | 316.0 | 214 | 10 | 49 | 0 | 29 | 0 | 14 | 316 | |||||||||||||||||||||||||||||||||
| 2370358 | 2370358 | NJ | Charters | 80 | school | 3400787 | 6105 | Hudson Arts And Science Charter School | 340078703387 | 996 | Hudson Arts And Science Charter School | Regular School | Yes | Elementary | KG | 08 | 2021 | pk_12_total | 145.0 | 59.0 | 526.0 | 17.0 | 24.0 | 1.0 | 1.0 | 8.9 | 0.1 | 46.3 | 773.0 | 145 | 59 | 526 | 17 | 24 | 1 | 1 | 773 | |||||||||||||||||||||||||||||||||
| 2473312 | 2473312 | NJ | Bergen | 3 | school | 3416110 | 5160 | Tenafly Boro | 341611000874 | 100 | Walter Stillman School | Regular School | No | Elementary | PK | 05 | 2020 | pk_12_total | 198.0 | 3.0 | 33.0 | 0.0 | 125.0 | 0.0 | 13.0 | 8.9 | 0.0 | 0.3 | 372.0 | 198 | 3 | 33 | 0 | 125 | 0 | 13 | 372 | |||||||||||||||||||||||||||||||||
| 2473372 | 2473372 | NJ | Burlington | 5 | school | 3404470 | 1280 | Edgewater Park Twp | 340447001064 | 70 | Samuel M Ridgway Middle School | Regular School | No | Middle | 05 | 08 | 2020 | pk_12_total | 152.0 | 120.0 | 107.0 | 0.0 | 8.0 | 0.0 | 19.0 | 8.9 | 3.9 | 58.6 | 406.0 | 152 | 120 | 107 | 0 | 8 | 0 | 19 | 406 | |||||||||||||||||||||||||||||||||
| 2474047 | 2474047 | NJ | Hudson | 17 | school | 3407830 | 2390 | Jersey City | 340783002812 | 240 | Alfred Zampella School | Regular School | No | Elementary | PK | 08 | 2020 | pk_12_total | 71.0 | 48.0 | 571.0 | 1.0 | 198.0 | 4.0 | 8.0 | 8.9 | 0.3 | 67.7 | 901.0 | 71 | 48 | 571 | 1 | 198 | 4 | 8 | 901 | |||||||||||||||||||||||||||||||||
| 2474280 | 2474280 | NJ | Middlesex | 23 | school | 3404500 | 1290 | Edison Twp | 340450003348 | 95 | John Marshall Elementary School | Regular School | No | Elementary | KG | 05 | 2020 | pk_12_total | 41.0 | 50.0 | 67.0 | 14.0 | 629.0 | 2.0 | 10.0 | 8.9 | 2.6 | 14.1 | 813.0 | 41 | 50 | 67 | 14 | 629 | 2 | 10 | 813 | |||||||||||||||||||||||||||||||||
| 2475310 | 2475310 | NJ | Union | 39 | school | 3414670 | 4670 | Scotch Plains-Fanwood Reg | 341467005682 | 70 | School One Elementary | Regular School | No | Elementary | PK | 04 | 2020 | pk_12_total | 228.0 | 21.0 | 77.0 | 0.0 | 46.0 | 0.0 | 11.0 | 8.9 | 0.0 | 9.7 | 383.0 | 228 | 21 | 77 | 0 | 46 | 0 | 11 | 383 | |||||||||||||||||||||||||||||||||
| 365591 | 365591 | SD | school | 4666270 | 49005 | Sioux Falls 49-5 | 466627001122 | 41 | Community Campus | Special Education School | No | High | 12 | 12 | 2019 | k_12_total | 24.0 | 5.0 | 3.0 | 2.0 | 23.0 | 11.0 | 8.8 | 34.0 | 24 | 5 | 3 | 2 | 23 | 11 | 34 | |||||||||||||||||||||||||||||||||||||||
| 491426 | 491426 | SD | school | 4631350 | 41002 | Harrisburg 41-2 | 463135001169 | 4 | Explorer Elementary | Regular School | Not applicable | Elementary | PK | 05 | 2020 | k_12_total | 425.0 | 32.0 | 32.0 | 9.0 | 11.0 | 26.0 | 269.0 | 266.0 | 8.8 | 535.0 | 425 | 32 | 32 | 9 | 11 | 26 | 269 | 266 | 535 | |||||||||||||||||||||||||||||||||||
| 2367914 | 2367914 | NJ | Atlantic | 1 | school | 3400960 | 110 | Atlantic City School District | 340096000022 | 80 | Uptown School Complex | Regular School | No | Elementary | PK | 08 | 2021 | pk_12_total | 4.0 | 297.0 | 217.0 | 0.0 | 8.0 | 0.0 | 10.0 | 8.8 | 1.5 | 87.89999999999999 | 536.0 | 4 | 297 | 217 | 0 | 8 | 0 | 10 | 536 | |||||||||||||||||||||||||||||||||
| 2368826 | 2368826 | NJ | Essex | 13 | school | 3417610 | 5680 | West Orange Public Schools | 341761002494 | 180 | Washington Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | pk_12_total | 10.0 | 116.0 | 242.0 | 1.0 | 11.0 | 2.0 | 18.0 | 8.8 | 0.0 | 70.1 | 400.0 | 10 | 116 | 242 | 1 | 11 | 2 | 18 | 400 | |||||||||||||||||||||||||||||||||
| 2368959 | 2368959 | NJ | Hudson | 17 | school | 3407830 | 2390 | Jersey City Public Schools | 340783002784 | 100 | Frank R Conwell School | Regular School | No | Elementary | PK | 05 | 2021 | pk_12_total | 121.0 | 104.0 | 270.0 | 1.0 | 78.0 | 5.0 | 22.0 | 8.8 | 0.7 | 50.1 | 601.0 | 121 | 104 | 270 | 1 | 78 | 5 | 22 | 601 | |||||||||||||||||||||||||||||||||
| 2369083 | 2369083 | NJ | Mercer | 21 | school | 3404920 | 1430 | Ewing Township School District | 340492003086 | 140 | William L Antheil Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | pk_12_total | 175.0 | 249.0 | 133.0 | 0.0 | 44.0 | 1.0 | 21.0 | 8.8 | 0.2 | 45.5 | 623.0 | 175 | 249 | 133 | 0 | 44 | 1 | 21 | 623 | |||||||||||||||||||||||||||||||||
| 2369213 | 2369213 | NJ | Middlesex | 23 | school | 3407770 | 2370 | Jamesburg Public School District | 340777003386 | 75 | Grace M. Breckwedel Middle School | Regular School | No | Middle | 06 | 08 | 2021 | pk_12_total | 62.0 | 16.0 | 111.0 | 0.0 | 1.0 | 1.0 | 2.0 | 8.8 | 0.0 | 58.6 | 193.0 | 62 | 16 | 111 | 0 | 1 | 1 | 2 | 193 | |||||||||||||||||||||||||||||||||
| 2369546 | 2369546 | NJ | Morris | 27 | school | 3402520 | 630 | Butler Public School District | 340252004168 | 25 | Aaron Decker School | Regular School | No | Elementary | PK | 04 | 2021 | pk_12_total | 250.0 | 6.0 | 100.0 | 1.0 | 11.0 | 1.0 | 5.0 | 8.8 | 0.0 | 22.4 | 374.0 | 250 | 6 | 100 | 1 | 11 | 1 | 5 | 374 | |||||||||||||||||||||||||||||||||
| 2369890 | 2369890 | NJ | Passaic | 31 | school | 3412690 | 4010 | Paterson Public School District | 341269003109 | 5 | School Of Earth And Space Science | Regular School | No | High | 09 | 12 | 2021 | pk_12_total | 1.0 | 68.0 | 139.0 | 0.0 | 7.0 | 0.0 | 0.0 | 8.8 | 0.5 | 51.6 | 215.0 | 1 | 68 | 139 | 0 | 7 | 0 | 0 | 215 | |||||||||||||||||||||||||||||||||
| 2370026 | 2370026 | NJ | Somerset | 35 | school | 3407230 | 2170 | Hillsborough Township Public School District | 340723005232 | 80 | Woodfern Elementary School | Regular School | No | Elementary | KG | 04 | 2021 | pk_12_total | 189.0 | 12.0 | 60.0 | 2.0 | 83.0 | 0.0 | 8.0 | 8.8 | 0.0 | 11.3 | 354.0 | 189 | 12 | 60 | 2 | 83 | 0 | 8 | 354 | |||||||||||||||||||||||||||||||||
| 2473164 | 2473164 | NJ | Bergen | 3 | school | 3406270 | 1860 | Hackensack City | 340627000496 | 50 | Hackensack High School | Regular School | No | High | 09 | 12 | 2020 | pk_12_total | 272.5 | 391.5 | 1120.5 | 4.0 | 105.0 | 4.0 | 9.0 | 8.8 | 1.3 | 52.400000000000006 | 1906.5 | 272 | 391 | 1120 | 4 | 105 | 4 | 9 | 1906 | |||||||||||||||||||||||||||||||||
| 2473801 | 2473801 | NJ | Essex | 13 | school | 3411340 | 3570 | Newark City | 341134002192 | 30 | Central High School | Regular School | No | High | 09 | 12 | 2020 | pk_12_total | 2.0 | 658.0 | 111.0 | 0.0 | 3.0 | 0.0 | 0.0 | 8.8 | 1.3 | 82.80000000000001 | 774.0 | 2 | 658 | 111 | 0 | 3 | 0 | 0 | 774 | |||||||||||||||||||||||||||||||||
| 2473843 | 2473843 | NJ | Essex | 13 | school | 3411340 | 3570 | Newark City | 341134002318 | 520 | Mckinley Elementary School | Regular School | No | Elementary | PK | 08 | 2020 | pk_12_total | 14.0 | 310.0 | 523.0 | 0.0 | 2.0 | 0.0 | 0.0 | 8.8 | 3.2 | 88.10000000000001 | 849.0 | 14 | 310 | 523 | 0 | 2 | 0 | 0 | 849 | |||||||||||||||||||||||||||||||||
| 2473948 | 2473948 | NJ | Gloucester | 15 | school | 3410470 | 3280 | Monroe Twp | 341047002596 | 75 | Holly Glen Elementary School | Regular School | No | Elementary | PK | 04 | 2020 | pk_12_total | 248.0 | 68.0 | 74.0 | 2.0 | 10.0 | 3.0 | 40.0 | 8.8 | 1.6 | 51.199999999999996 | 445.0 | 248 | 68 | 74 | 2 | 10 | 3 | 40 | 445 | |||||||||||||||||||||||||||||||||
| 2474060 | 2474060 | NJ | Hudson | 17 | school | 3407830 | 2390 | Jersey City | 340783002842 | 350 | James F. Murray School | Regular School | No | Elementary | PK | 08 | 2020 | pk_12_total | 82.0 | 311.0 | 216.0 | 2.0 | 155.0 | 15.0 | 14.0 | 8.8 | 0.9 | 68.60000000000001 | 795.0 | 82 | 311 | 216 | 2 | 155 | 15 | 14 | 795 | |||||||||||||||||||||||||||||||||
| 2474071 | 2474071 | NJ | Hudson | 17 | school | 3411460 | 3610 | North Bergen Twp | 341146002884 | 60 | Franklin Elementary School | Regular School | No | Elementary | 01 | 08 | 2020 | pk_12_total | 24.0 | 3.0 | 578.0 | 0.0 | 18.0 | 0.0 | 0.0 | 8.8 | 0.0 | 64.5 | 623.0 | 24 | 3 | 578 | 0 | 18 | 0 | 0 | 623 | |||||||||||||||||||||||||||||||||
| 2474753 | 2474753 | NJ | Morris | 27 | school | 3414100 | 4480 | Rockaway Boro | 341410004504 | 60 | Lincoln Elementary School | Regular School | No | Elementary | PK | 03 | 2020 | pk_12_total | 124.0 | 11.0 | 80.0 | 0.0 | 31.0 | 0.0 | 3.0 | 8.8 | 0.0 | 25.7 | 249.0 | 124 | 11 | 80 | 0 | 31 | 0 | 3 | 249 | |||||||||||||||||||||||||||||||||
| 2474891 | 2474891 | NJ | Passaic | 31 | school | 3403300 | 900 | Clifton City | 340330004764 | 35 | Christopher Columbus Middle School | Regular School | No | Middle | 06 | 08 | 2020 | pk_12_total | 261.0 | 39.0 | 836.0 | 3.0 | 59.0 | 0.0 | 2.0 | 8.8 | 1.3 | 66.5 | 1200.0 | 261 | 39 | 836 | 3 | 59 | 0 | 2 | 1200 | |||||||||||||||||||||||||||||||||
| 2475125 | 2475125 | NJ | Somerset | 35 | school | 3411640 | 3670 | North Plainfield Boro | 341164005262 | 80 | Somerset School | Regular School | No | Middle | 05 | 06 | 2020 | pk_12_total | 64.0 | 87.0 | 324.0 | 2.0 | 11.0 | 0.0 | 1.0 | 8.8 | 0.4 | 68.7 | 489.0 | 64 | 87 | 324 | 2 | 11 | 0 | 1 | 489 | |||||||||||||||||||||||||||||||||
| 2475304 | 2475304 | NJ | Union | 39 | school | 3414310 | 4550 | Roselle Park Boro | 341431005668 | 80 | Robert Gordon Elementary School | Regular School | No | Elementary | PK | 05 | 2020 | pk_12_total | 98.0 | 31.0 | 144.0 | 0.0 | 11.0 | 0.0 | 0.0 | 8.8 | 0.0 | 37.0 | 284.0 | 98 | 31 | 144 | 0 | 11 | 0 | 0 | 284 | |||||||||||||||||||||||||||||||||
| 2475404 | 2475404 | NJ | Charters | 80 | school | 3400717 | 6017 | Foundation Academy Cs | 340071702925 | 932 | Foundation Academy Charter School | Regular School | Yes | Other | KG | 12 | 2020 | pk_12_total | 5.0 | 568.0 | 496.0 | 0.0 | 4.0 | 0.0 | 13.0 | 8.8 | 0.1 | 85.0 | 1086.0 | 5 | 568 | 496 | 0 | 4 | 0 | 13 | 1086 | |||||||||||||||||||||||||||||||||
| 2368411 | 2368411 | NJ | Camden | 7 | school | 3402640 | 680 | Camden City School District | 340264001368 | 180 | Dr. Henry H. Davis Elementary School | Regular School | No | Elementary | PK | 08 | 2021 | pk_12_total | 4.0 | 94.0 | 196.0 | 0.0 | 23.0 | 2.0 | 2.0 | 8.7 | 1.6 | 67.6 | 321.0 | 4 | 94 | 196 | 0 | 23 | 2 | 2 | 321 |
Advanced export
JSON shape: default, array, newline-delimited
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]);