enrollments
Data source: Big Local News · About: Big Local
4,354 rows where grade = "pk_12_total" and state = "CT" sorted by hispanic 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2452683 | 2452683 | CT | school | 903990 | 1240011 | Seymour School District | 90399000794 | 1245111 | Seymour Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | pk_12_total | 373 | 25 | 99 | * | 19 | 0 | * | 264 | 260 | 7 | 77 | 524 | 373 | 25 | 99 | 19 | 0 | 264 | 260 | 7 | 77 | 524 | |||||||||||||||||||||||||||||||
2758003 | 2758003 | CT | school | 902790 | 930011 | New Haven School District | 90279000551 | 930911 | Davis Academy for Arts & Design Innovation | Public Schools | Regular School | No | Elementary | PK | 08 | 2021 | pk_12_total | 80 | 293 | 99 | * | * | 0 | 15 | 247 | 251 | 6 | 42 | 498 | 80 | 293 | 99 | 0 | 15 | 247 | 251 | 6 | 42 | 498 | |||||||||||||||||||||||||||||||
2758106 | 2758106 | CT | school | 903090 | 1030011 | Norwalk School District | 90309000642 | 1030311 | Columbus Magnet School | Public Schools | Regular School | No | Elementary | KG | 08 | 2021 | pk_12_total | 119 | 52 | 99 | * | 21 | * | 16 | 161 | 151 | 30 | 39 | 312 | 119 | 52 | 99 | 21 | 16 | 161 | 151 | 30 | 39 | 312 | |||||||||||||||||||||||||||||||
2777835 | 2777835 | CT | school | 900510 | 170011 | Bristol School District | 90051000096 | 170311 | Edgewood School | Public Schools | Regular School | No | Elementary | KG | 05 | 2020 | pk_12_total | 145 | * | 99 | * | 15 | 0 | 13 | 150 | 136 | 20 | 35 | 286 | 145 | 99 | 15 | 0 | 13 | 150 | 136 | 20 | 35 | 286 | |||||||||||||||||||||||||||||||
2779041 | 2779041 | CT | school | 905070 | 1590011 | Wethersfield School District | 90507001061 | 1590211 | Emerson-Williams School | Public Schools | Regular School | No | Elementary | PK | 06 | 2020 | pk_12_total | 280 | 14 | 99 | 0 | 12 | 0 | 18 | 216 | 207 | 65 | 48 | 423 | 280 | 14 | 99 | 0 | 12 | 0 | 18 | 216 | 207 | 65 | 48 | 423 | |||||||||||||||||||||||||||||
2451772 | 2451772 | CT | school | 900450 | 150011 | Bridgeport School District | 90045000066 | 151211 | Hallen School | Public Schools | Regular School | No | Elementary | PK | 06 | 2019 | pk_12_total | 30 | 154 | 98 | 0 | * | 0 | * | 163 | 126 | 8 | 70 | 289 | 30 | 154 | 98 | 0 | 0 | 163 | 126 | 8 | 70 | 289 | |||||||||||||||||||||||||||||||
2452948 | 2452948 | CT | school | 904860 | 1520011 | Waterford School District | 90486001001 | 1526111 | Waterford High School | Public Schools | Regular School | No | High | 09 | 12 | 2019 | pk_12_total | 643 | 19 | 98 | * | 52 | * | 20 | 432 | * | 7 | 138 | 838 | 643 | 19 | 98 | 52 | 20 | 432 | 7 | 138 | 838 | ||||||||||||||||||||||||||||||||
2452982 | 2452982 | CT | school | 904950 | 1560011 | West Haven School District | 90495001027 | 1560811 | Alma E. Pagels School | Public Schools | Regular School | No | Elementary | PK | 04 | 2019 | pk_12_total | 143 | 82 | 98 | * | 24 | 0 | * | 210 | 150 | 68 | 101 | 360 | 143 | 82 | 98 | 24 | 0 | 210 | 150 | 68 | 101 | 360 | |||||||||||||||||||||||||||||||
2757987 | 2757987 | CT | school | 902730 | 910011 | New Fairfield School District | 90273000537 | 916111 | New Fairfield High School | Public Schools | Regular School | No | High | 09 | 12 | 2021 | pk_12_total | 558 | 13 | 98 | * | * | 0 | 17 | 348 | 350 | * | 102 | 698 | 558 | 13 | 98 | 0 | 17 | 348 | 350 | 102 | 698 | ||||||||||||||||||||||||||||||||
2758704 | 2758704 | CT | school | 900014 | 2680013 | Common Ground High School District | 90001400807 | 2686113 | Common Ground High School | Public Charter Schools | Regular School | Yes | High | 09 | 12 | 2021 | pk_12_total | 52 | 78 | 98 | 0 | 0 | * | * | 136 | * | 11 | 56 | 236 | 52 | 78 | 98 | 0 | 0 | 136 | 11 | 56 | 236 | ||||||||||||||||||||||||||||||||
2777998 | 2777998 | CT | school | 430011 | East Hartford School District | 90126000205 | 439011 | Woodland School | Program | 2020 | pk_12_total | 27 | 67 | 98 | * | * | 0 | 11 | 166 | 40 | 24 | * | 206 | 27 | 67 | 98 | 0 | 11 | 166 | 40 | 24 | 206 | ||||||||||||||||||||||||||||||||||||||
2451806 | 2451806 | CT | school | 900510 | 170011 | Bristol School District | 90051000096 | 170311 | Edgewood School | Public Schools | Regular School | No | Elementary | KG | 05 | 2019 | pk_12_total | 147 | 8 | 97 | 0 | 13 | 0 | 11 | 142 | * | 14 | 32 | 276 | 147 | 8 | 97 | 0 | 13 | 0 | 11 | 142 | 14 | 32 | 276 | ||||||||||||||||||||||||||||||
2758178 | 2758178 | CT | school | 903480 | 1160011 | Putnam School District | 90348000718 | 1160311 | Putnam Elementary School | Public Schools | Regular School | No | Elementary | PK | 05 | 2021 | pk_12_total | 415 | 10 | 97 | * | 7 | * | 39 | 298 | 273 | 27 | 107 | 571 | 415 | 10 | 97 | 7 | 39 | 298 | 273 | 27 | 107 | 571 | |||||||||||||||||||||||||||||||
2758586 | 2758586 | CT | school | 905040 | 1580011 | Westport School District | 90504001058 | 1586111 | Staples High School | Public Schools | Regular School | No | High | 09 | 12 | 2021 | pk_12_total | 1483 | 37 | 97 | 0 | 119 | 0 | 68 | 912 | * | 10 | 252 | 1804 | 1483 | 37 | 97 | 0 | 119 | 0 | 68 | 912 | 10 | 252 | 1804 | ||||||||||||||||||||||||||||||
2778102 | 2778102 | CT | school | 901620 | 540011 | Glastonbury School District | 90162000282 | 545211 | Smith Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2020 | pk_12_total | 640 | * | 97 | * | 120 | 0 | 54 | * | 494 | 13 | 110 | 944 | 640 | 97 | 120 | 0 | 54 | 494 | 13 | 110 | 944 | ||||||||||||||||||||||||||||||||
2778867 | 2778867 | CT | school | 904620 | 1440011 | Trumbull School District | 90462000930 | 1445211 | Hillcrest Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2020 | pk_12_total | 532 | 49 | 97 | * | 63 | * | 14 | 392 | 366 | * | 82 | 758 | 532 | 49 | 97 | 63 | 14 | 392 | 366 | 82 | 758 | ||||||||||||||||||||||||||||||||
2778875 | 2778875 | CT | school | 904680 | 1460011 | Vernon School District | 90468000941 | 1460211 | Maple Street School | Public Schools | Regular School | No | Elementary | PK | 05 | 2020 | pk_12_total | 100 | 43 | 97 | 0 | * | * | 36 | 148 | 150 | * | 45 | 298 | 100 | 43 | 97 | 0 | 36 | 148 | 150 | 45 | 298 | ||||||||||||||||||||||||||||||||
2778800 | 2778800 | CT | school | 904320 | 1350011 | Stamford School District | 90432000871 | 1356311 | Westhill High School | Public Schools | Regular School | No | High | 09 | 12 | 2020 | pk_12_total | 753 | 327 | 967 | * | 131 | * | 52 | 1128 | 1108 | 476 | 283 | 2236 | 753 | 327 | 967 | 131 | 52 | 1128 | 1108 | 476 | 283 | 2236 | |||||||||||||||||||||||||||||||
2758117 | 2758117 | CT | school | 903090 | 1030011 | Norwalk School District | 90309000638 | 1036211 | Brien McMahon High School | Public Schools | Regular School | No | High | 09 | 12 | 2021 | pk_12_total | 401 | 258 | 960 | * | 56 | 0 | * | 860 | 850 | 263 | 211 | 1710 | 401 | 258 | 960 | 56 | 0 | 860 | 850 | 263 | 211 | 1710 | |||||||||||||||||||||||||||||||
2451825 | 2451825 | CT | school | 900510 | 170011 | Bristol School District | 90051000104 | 175211 | Northeast Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | pk_12_total | 318 | 36 | 96 | * | 19 | * | 19 | 245 | 245 | 12 | 82 | 490 | 318 | 36 | 96 | 19 | 19 | 245 | 245 | 12 | 82 | 490 | |||||||||||||||||||||||||||||||
2451974 | 2451974 | CT | school | 901290 | 440011 | East Haven School District | 90129000218 | 441011 | Grove J. Tuttle School | Public Schools | Regular School | No | Elementary | KG | 05 | 2019 | pk_12_total | 148 | 15 | 96 | * | 11 | 0 | * | 153 | 127 | 45 | 26 | 280 | 148 | 15 | 96 | 11 | 0 | 153 | 127 | 45 | 26 | 280 | |||||||||||||||||||||||||||||||
2452047 | 2452047 | CT | school | 901530 | 510011 | Fairfield School District | 90153000258 | 515211 | Fairfield Woods Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | pk_12_total | 697 | 24 | 96 | 0 | 62 | 0 | 31 | 457 | 453 | 10 | 115 | 910 | 697 | 24 | 96 | 0 | 62 | 0 | 31 | 457 | 453 | 10 | 115 | 910 | |||||||||||||||||||||||||||||
2453052 | 2453052 | CT | school | 905220 | 1640011 | Windsor School District | 90522001092 | 1640911 | Oliver Ellsworth School | Public Schools | Regular School | No | Elementary | PK | 02 | 2019 | pk_12_total | 116 | 126 | 96 | * | * | 0 | 35 | 213 | 198 | 12 | 75 | 411 | 116 | 126 | 96 | 0 | 35 | 213 | 198 | 12 | 75 | 411 | |||||||||||||||||||||||||||||||
2453140 | 2453140 | CT | school | 900005 | 2190012 | Regional School District 19 | 90000501215 | 2196112 | E. O. Smith High School | Regional Schools | Regular School | No | High | 09 | 12 | 2019 | pk_12_total | 783 | * | 96 | 0 | 45 | * | 144 | 533 | 558 | 9 | 135 | 1091 | 783 | 96 | 0 | 45 | 144 | 533 | 558 | 9 | 135 | 1091 | |||||||||||||||||||||||||||||||
2757557 | 2757557 | CT | school | 901290 | 440011 | East Haven School District | 90129000218 | 441011 | Grove J. Tuttle School | Public Schools | Regular School | No | Elementary | KG | 05 | 2021 | pk_12_total | 131 | 11 | 96 | * | 12 | * | 7 | 128 | 131 | 33 | 31 | 259 | 131 | 11 | 96 | 12 | 7 | 128 | 131 | 33 | 31 | 259 | |||||||||||||||||||||||||||||||
2757660 | 2757660 | CT | school | 901620 | 540011 | Glastonbury School District | 90162000282 | 545211 | Smith Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2021 | pk_12_total | 619 | * | 96 | * | 116 | 0 | 55 | 448 | 462 | 8 | 92 | 910 | 619 | 96 | 116 | 0 | 55 | 448 | 462 | 8 | 92 | 910 | |||||||||||||||||||||||||||||||
2778817 | 2778817 | CT | school | 904440 | 1380011 | Stratford School District | 90444000893 | 1380811 | Lordship School | Public Schools | Regular School | No | Elementary | KG | 06 | 2020 | pk_12_total | 83 | 91 | 96 | 0 | 8 | 0 | 10 | 144 | 144 | 28 | 32 | 288 | 83 | 91 | 96 | 0 | 8 | 0 | 10 | 144 | 144 | 28 | 32 | 288 | |||||||||||||||||||||||||||||
2778975 | 2778975 | CT | school | 904860 | 1520011 | Waterford School District | 90486001001 | 1526111 | Waterford High School | Public Schools | Regular School | No | High | 09 | 12 | 2020 | pk_12_total | 619 | 18 | 96 | * | 46 | * | 25 | 407 | * | 8 | 132 | 811 | 619 | 18 | 96 | 46 | 25 | 407 | 8 | 132 | 811 | ||||||||||||||||||||||||||||||||
2779010 | 2779010 | CT | school | 904950 | 1560011 | West Haven School District | 90495001033 | 1560611 | Edith E. Mackrille School | Public Schools | Regular School | No | Elementary | PK | 04 | 2020 | pk_12_total | 113 | 64 | 96 | * | 26 | 0 | * | 151 | 157 | 56 | 51 | 308 | 113 | 64 | 96 | 26 | 0 | 151 | 157 | 56 | 51 | 308 | |||||||||||||||||||||||||||||||
2452263 | 2452263 | CT | school | 902310 | 770011 | Manchester School District | 90231000417 | 770111 | Bowers School | Public Schools | Regular School | No | Elementary | KG | 04 | 2019 | pk_12_total | 154 | 71 | 95 | 0 | 15 | * | * | 181 | 159 | 19 | 62 | 340 | 154 | 71 | 95 | 0 | 15 | 181 | 159 | 19 | 62 | 340 | |||||||||||||||||||||||||||||||
2452986 | 2452986 | CT | school | 904950 | 1560011 | West Haven School District | 90495001039 | 1560411 | Seth G. Haley School | Public Schools | Regular School | No | Elementary | PK | 04 | 2019 | pk_12_total | 197 | 61 | 95 | * | 13 | 0 | * | 206 | 175 | 65 | 62 | 381 | 197 | 61 | 95 | 13 | 0 | 206 | 175 | 65 | 62 | 381 | |||||||||||||||||||||||||||||||
2757338 | 2757338 | CT | school | 900420 | 140011 | Branford School District | 90042000039 | 146111 | Branford High School | Public Schools | Regular School | No | High | 09 | 12 | 2021 | pk_12_total | 575 | 25 | 95 | * | 63 | 0 | * | 398 | * | 14 | 94 | 780 | 575 | 25 | 95 | 63 | 0 | 398 | 14 | 94 | 780 | ||||||||||||||||||||||||||||||||
2757353 | 2757353 | CT | school | 900450 | 150011 | Bridgeport School District | 90045000066 | 151211 | Hallen School | Public Schools | Regular School | No | Elementary | PK | 06 | 2021 | pk_12_total | 19 | 157 | 95 | * | * | 0 | 6 | 149 | 135 | 11 | 59 | 284 | 19 | 157 | 95 | 0 | 6 | 149 | 135 | 11 | 59 | 284 | |||||||||||||||||||||||||||||||
2757649 | 2757649 | CT | school | 901560 | 520011 | Farmington School District | 90156000273 | 526111 | Farmington High School | Public Schools | Regular School | No | High | 09 | 12 | 2021 | pk_12_total | 818 | 54 | 95 | * | 270 | 0 | * | 629 | 638 | 9 | 153 | 1267 | 818 | 54 | 95 | 270 | 0 | 629 | 638 | 9 | 153 | 1267 | |||||||||||||||||||||||||||||||
2757976 | 2757976 | CT | school | 890011 | New Britain School District | 899511 | New Britain High School Satellite Careers Academy | Program | 2021 | pk_12_total | 15 | 12 | 95 | 0 | * | 0 | * | 76 | 55 | 27 | 21 | 131 | 15 | 12 | 95 | 0 | 0 | 76 | 55 | 27 | 21 | 131 | ||||||||||||||||||||||||||||||||||||||
2758057 | 2758057 | CT | school | 902820 | 950011 | New London School District | 90282001919 | 951411 | New London Visual and Performing Arts Magnet School | Public Schools | Regular School | No | Secondary | 06 | 11 | 2021 | pk_12_total | 42 | 55 | 95 | * | * | * | 37 | 99 | 136 | 27 | 55 | 235 | 42 | 55 | 95 | 37 | 99 | 136 | 27 | 55 | 235 | ||||||||||||||||||||||||||||||||
2758371 | 2758371 | CT | school | 904440 | 1380011 | Stratford School District | 90444000899 | 1381411 | Wilcoxson School | Public Schools | Regular School | No | Elementary | KG | 06 | 2021 | pk_12_total | 166 | 64 | 95 | * | * | 0 | 18 | 169 | 183 | 18 | 46 | 352 | 166 | 64 | 95 | 0 | 18 | 169 | 183 | 18 | 46 | 352 | |||||||||||||||||||||||||||||||
2758585 | 2758585 | CT | school | 905040 | 1580011 | Westport School District | 90504001048 | 1585111 | Bedford Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2021 | pk_12_total | 924 | 24 | 95 | 0 | 76 | 0 | 88 | 593 | 614 | 8 | 151 | 1207 | 924 | 24 | 95 | 0 | 76 | 0 | 88 | 593 | 614 | 8 | 151 | 1207 | |||||||||||||||||||||||||||||
2777763 | 2777763 | CT | school | 900270 | 90011 | Bethel School District | 90027001118 | 90511 | Ralph M. T. Johnson School | Public Schools | Regular School | No | Elementary | 04 | 05 | 2020 | pk_12_total | 299 | 12 | 95 | 7 | 30 | 0 | 23 | 254 | 212 | 33 | 63 | 466 | 299 | 12 | 95 | 7 | 30 | 0 | 23 | 254 | 212 | 33 | 63 | 466 | |||||||||||||||||||||||||||||
2778006 | 2778006 | CT | school | 901290 | 440011 | East Haven School District | 90129000218 | 441011 | Grove J. Tuttle School | Public Schools | Regular School | No | Elementary | KG | 05 | 2020 | pk_12_total | 130 | 15 | 95 | * | 12 | 0 | * | 132 | 131 | 44 | 25 | 263 | 130 | 15 | 95 | 12 | 0 | 132 | 131 | 44 | 25 | 263 | |||||||||||||||||||||||||||||||
2778448 | 2778448 | CT | school | 902790 | 930011 | New Haven School District | 90279000551 | 930911 | Davis Academy for Arts & Design Innovation | Public Schools | Regular School | No | Elementary | PK | 08 | 2020 | pk_12_total | 99 | 295 | 95 | * | * | 0 | 14 | 261 | 253 | 6 | 51 | 514 | 99 | 295 | 95 | 0 | 14 | 261 | 253 | 6 | 51 | 514 | |||||||||||||||||||||||||||||||
2778573 | 2778573 | CT | school | 903120 | 1040011 | Norwich School District | 90312000672 | 1040811 | Samuel Huntington School | Public Schools | Regular School | No | Elementary | KG | 05 | 2020 | pk_12_total | 144 | 70 | 95 | 0 | * | * | 47 | 190 | * | 53 | 41 | 376 | 144 | 70 | 95 | 0 | 47 | 190 | 53 | 41 | 376 | ||||||||||||||||||||||||||||||||
2778623 | 2778623 | CT | school | 903480 | 1160011 | Putnam School District | 90348000718 | 1160311 | Putnam Elementary School | Public Schools | Regular School | No | Elementary | PK | 05 | 2020 | pk_12_total | 478 | 12 | 95 | 0 | * | * | 43 | 328 | 307 | 30 | 106 | 635 | 478 | 12 | 95 | 0 | 43 | 328 | 307 | 30 | 106 | 635 | |||||||||||||||||||||||||||||||
2452473 | 2452473 | CT | school | 902790 | 930011 | New Haven School District | 90279000585 | 936111 | Wilbur Cross High School | Public Schools | Regular School | No | High | 09 | 12 | 2019 | pk_12_total | 179 | 429 | 944 | * | 34 | 0 | * | 805 | 789 | 314 | 254 | 1594 | 179 | 429 | 944 | 34 | 0 | 805 | 789 | 314 | 254 | 1594 | |||||||||||||||||||||||||||||||
2452983 | 2452983 | CT | school | 904950 | 1560011 | West Haven School District | 90495001033 | 1560611 | Edith E. Mackrille School | Public Schools | Regular School | No | Elementary | PK | 04 | 2019 | pk_12_total | 122 | 70 | 94 | 0 | 27 | 0 | 9 | 157 | 165 | 46 | 58 | 322 | 122 | 70 | 94 | 0 | 27 | 0 | 9 | 157 | 165 | 46 | 58 | 322 | |||||||||||||||||||||||||||||
2757635 | 2757635 | CT | school | 901530 | 510011 | Fairfield School District | 90153000258 | 515211 | Fairfield Woods Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2021 | pk_12_total | 602 | 17 | 94 | 0 | 69 | 0 | 49 | 449 | 382 | 11 | 126 | 831 | 602 | 17 | 94 | 0 | 69 | 0 | 49 | 449 | 382 | 11 | 126 | 831 | |||||||||||||||||||||||||||||
2757786 | 2757786 | CT | school | 901920 | 640011 | Hartford School District | 90192001381 | 646711 | University High School of Science and Engineering | Public Schools | Regular School | No | High | 09 | 12 | 2021 | pk_12_total | 85 | 190 | 94 | * | 42 | * | 16 | 260 | 171 | 24 | 44 | 431 | 85 | 190 | 94 | 42 | 16 | 260 | 171 | 24 | 44 | 431 | |||||||||||||||||||||||||||||||
2758561 | 2758561 | CT | school | 904950 | 1560011 | West Haven School District | 90495001039 | 1560411 | Seth G. Haley School | Public Schools | Regular School | No | Elementary | PK | 04 | 2021 | pk_12_total | 182 | 70 | 94 | 0 | 23 | 0 | 13 | 204 | 178 | 69 | 71 | 382 | 182 | 70 | 94 | 0 | 23 | 0 | 13 | 204 | 178 | 69 | 71 | 382 | |||||||||||||||||||||||||||||
2758628 | 2758628 | CT | school | 905220 | 1640011 | Windsor School District | 90522001093 | 1640511 | Poquonock Elementary School | Public Schools | Regular School | No | Elementary | PK | 02 | 2021 | pk_12_total | 79 | 114 | 94 | 0 | 20 | 0 | 33 | 174 | 166 | 19 | 64 | 340 | 79 | 114 | 94 | 0 | 20 | 0 | 33 | 174 | 166 | 19 | 64 | 340 | |||||||||||||||||||||||||||||
2758717 | 2758717 | CT | school | 900002 | 9000016 | Connecticut Technical Education and Career System | 90000201148 | 9002216 | Oliver Wolcott Technical High School | CT Technical Education and Career Schools | Career and Technical School | No | High | 09 | 12 | 2021 | pk_12_total | 500 | 13 | 94 | * | * | * | 23 | 421 | 212 | * | 92 | 633 | 500 | 13 | 94 | 23 | 421 | 212 | 92 | 633 | |||||||||||||||||||||||||||||||||
2777786 | 2777786 | CT | school | 900420 | 140011 | Branford School District | 90042000039 | 146111 | Branford High School | Public Schools | Regular School | No | High | 09 | 12 | 2020 | pk_12_total | 607 | 22 | 94 | 0 | 60 | 0 | 21 | * | 404 | 15 | 104 | 804 | 607 | 22 | 94 | 0 | 60 | 0 | 21 | 404 | 15 | 104 | 804 | ||||||||||||||||||||||||||||||
2778514 | 2778514 | CT | school | 902880 | 940011 | Newington School District | 90288000606 | 940811 | John Paterson School | Public Schools | Regular School | No | Elementary | PK | 04 | 2020 | pk_12_total | 225 | 28 | 94 | 0 | 26 | 0 | 19 | 196 | 196 | 51 | 85 | 392 | 225 | 28 | 94 | 0 | 26 | 0 | 19 | 196 | 196 | 51 | 85 | 392 | |||||||||||||||||||||||||||||
2778709 | 2778709 | CT | school | 903990 | 1240011 | Seymour School District | 90399000793 | 1246111 | Seymour High School | Public Schools | Regular School | No | High | 09 | 12 | 2020 | pk_12_total | 472 | 43 | 94 | * | 27 | * | 6 | 305 | 339 | 10 | 80 | 644 | 472 | 43 | 94 | 27 | 6 | 305 | 339 | 10 | 80 | 644 | |||||||||||||||||||||||||||||||
2779038 | 2779038 | CT | school | 905040 | 1580011 | Westport School District | 90504001048 | 1585111 | Bedford Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2020 | pk_12_total | 985 | 23 | 94 | 0 | 76 | 0 | 81 | 637 | 622 | 12 | 185 | 1259 | 985 | 23 | 94 | 0 | 76 | 0 | 81 | 637 | 622 | 12 | 185 | 1259 | |||||||||||||||||||||||||||||
2778492 | 2778492 | CT | school | 902790 | 930011 | New Haven School District | 90279000585 | 936111 | Wilbur Cross High School | Public Schools | Regular School | No | High | 09 | 12 | 2020 | pk_12_total | 173 | 410 | 936 | * | 28 | 0 | * | 781 | 772 | 316 | 259 | 1553 | 173 | 410 | 936 | 28 | 0 | 781 | 772 | 316 | 259 | 1553 | |||||||||||||||||||||||||||||||
2451730 | 2451730 | CT | school | 900210 | 70011 | Berlin School District | 90021000016 | 76111 | Berlin High School | Public Schools | Regular School | No | High | 09 | 12 | 2019 | pk_12_total | 724 | 23 | 93 | 0 | 35 | 0 | 24 | 487 | 412 | 6 | 94 | 899 | 724 | 23 | 93 | 0 | 35 | 0 | 24 | 487 | 412 | 6 | 94 | 899 | |||||||||||||||||||||||||||||
2452581 | 2452581 | CT | school | 903300 | 1100011 | Plainville School District | 90330000701 | 1100211 | Linden Street School | Public Schools | Regular School | No | Elementary | PK | 05 | 2019 | pk_12_total | 261 | 21 | 93 | 0 | 12 | 0 | 16 | 195 | 208 | 57 | 49 | 403 | 261 | 21 | 93 | 0 | 12 | 0 | 16 | 195 | 208 | 57 | 49 | 403 | |||||||||||||||||||||||||||||
2453015 | 2453015 | CT | school | 905070 | 1590011 | Wethersfield School District | 90507001061 | 1590211 | Emerson-Williams School | Public Schools | Regular School | No | Elementary | PK | 06 | 2019 | pk_12_total | 285 | 15 | 93 | 0 | 16 | 0 | 23 | 218 | 214 | 60 | 57 | 432 | 285 | 15 | 93 | 0 | 16 | 0 | 23 | 218 | 214 | 60 | 57 | 432 | |||||||||||||||||||||||||||||
2757705 | 2757705 | CT | school | 901800 | 600011 | Guilford School District | 90180000332 | 606111 | Guilford High School | Public Schools | Regular School | No | High | 09 | 12 | 2021 | pk_12_total | 903 | * | 93 | 0 | 53 | * | 37 | 569 | * | * | 118 | 1104 | 903 | 93 | 0 | 53 | 37 | 569 | 118 | 1104 | |||||||||||||||||||||||||||||||||
2758161 | 2758161 | CT | school | 903300 | 1100011 | Plainville School District | 90330000701 | 1100211 | Linden Street School | Public Schools | Regular School | No | Elementary | PK | 05 | 2021 | pk_12_total | 212 | 14 | 93 | 0 | 8 | 0 | 15 | 181 | 161 | 55 | 43 | 342 | 212 | 14 | 93 | 0 | 8 | 0 | 15 | 181 | 161 | 55 | 43 | 342 | |||||||||||||||||||||||||||||
2777916 | 2777916 | CT | school | 900810 | 270011 | Clinton School District | 90081000133 | 275111 | Jared Eliot School | Public Schools | Regular School | No | Middle | 05 | 08 | 2020 | pk_12_total | 398 | * | 93 | * | 17 | 0 | 8 | 271 | 251 | 30 | 84 | 522 | 398 | 93 | 17 | 0 | 8 | 271 | 251 | 30 | 84 | 522 | |||||||||||||||||||||||||||||||
2778117 | 2778117 | CT | school | 901710 | 570011 | Greenwich School District | 90171000302 | 570311 | Julian Curtiss School | Public Schools | Regular School | No | Elementary | KG | 05 | 2020 | pk_12_total | 132 | * | 93 | * | 20 | 0 | 20 | 145 | 137 | 33 | 41 | 282 | 132 | 93 | 20 | 0 | 20 | 145 | 137 | 33 | 41 | 282 | |||||||||||||||||||||||||||||||
2778268 | 2778268 | CT | school | 902160 | 720011 | Ledyard School District | 90216000401 | 726111 | Ledyard High School | Public Schools | Regular School | No | High | 09 | 12 | 2020 | pk_12_total | 528 | 58 | 93 | * | 29 | * | 24 | * | 392 | 11 | 140 | 754 | 528 | 58 | 93 | 29 | 24 | 392 | 11 | 140 | 754 | ||||||||||||||||||||||||||||||||
2778479 | 2778479 | CT | school | 902790 | 930011 | New Haven School District | 90279000586 | 933211 | Wexler/Grant Community School | Public Schools | Regular School | No | Elementary | KG | 08 | 2020 | pk_12_total | 8 | 251 | 93 | 0 | 0 | 0 | 9 | 189 | 172 | 13 | 65 | 361 | 8 | 251 | 93 | 0 | 0 | 0 | 9 | 189 | 172 | 13 | 65 | 361 | |||||||||||||||||||||||||||||
2779081 | 2779081 | CT | school | 905220 | 1640011 | Windsor School District | 90522001093 | 1640511 | Poquonock Elementary School | Public Schools | Regular School | No | Elementary | PK | 02 | 2020 | pk_12_total | 89 | 122 | 93 | 0 | 19 | 0 | 24 | 176 | 171 | 23 | 67 | 347 | 89 | 122 | 93 | 0 | 19 | 0 | 24 | 176 | 171 | 23 | 67 | 347 | |||||||||||||||||||||||||||||
2758048 | 2758048 | CT | school | 902790 | 930011 | New Haven School District | 90279000585 | 936111 | Wilbur Cross High School | Public Schools | Regular School | No | High | 09 | 12 | 2021 | pk_12_total | 181 | 392 | 928 | * | 38 | 0 | * | 800 | 747 | 327 | 270 | 1547 | 181 | 392 | 928 | 38 | 0 | 800 | 747 | 327 | 270 | 1547 | |||||||||||||||||||||||||||||||
2452791 | 2452791 | CT | school | 904440 | 1380011 | Stratford School District | 90444000887 | 1380311 | Chapel School | Public Schools | Regular School | No | Elementary | KG | 06 | 2019 | pk_12_total | 189 | 47 | 92 | 0 | 10 | 0 | 6 | 185 | 159 | 21 | 30 | 344 | 189 | 47 | 92 | 0 | 10 | 0 | 6 | 185 | 159 | 21 | 30 | 344 | |||||||||||||||||||||||||||||
2757549 | 2757549 | CT | school | 430011 | East Hartford School District | 90126000205 | 439011 | Woodland School | Program | 2021 | pk_12_total | 24 | 64 | 92 | * | * | * | 11 | 156 | 39 | 27 | * | 195 | 24 | 64 | 92 | 11 | 156 | 39 | 27 | 195 | |||||||||||||||||||||||||||||||||||||||
2757821 | 2757821 | CT | school | 902160 | 720011 | Ledyard School District | 90216000401 | 726111 | Ledyard High School | Public Schools | Regular School | No | High | 09 | 12 | 2021 | pk_12_total | 526 | 59 | 92 | 28 | * | * | 30 | 350 | 403 | 8 | 129 | 760 | 526 | 59 | 92 | 28 | 30 | 350 | 403 | 8 | 129 | 760 | |||||||||||||||||||||||||||||||
2758254 | 2758254 | CT | school | 903840 | 1190011 | Rocky Hill School District | 90384000785 | 1196111 | Rocky Hill High School | Public Schools | Regular School | No | High | 09 | 12 | 2021 | pk_12_total | 468 | 30 | 92 | * | 126 | 0 | * | 353 | 385 | 9 | 79 | 738 | 468 | 30 | 92 | 126 | 0 | 353 | 385 | 9 | 79 | 738 | |||||||||||||||||||||||||||||||
2758261 | 2758261 | CT | school | 903990 | 1240011 | Seymour School District | 90399000794 | 1245111 | Seymour Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2021 | pk_12_total | 414 | 21 | 92 | * | 15 | 0 | * | 285 | 270 | 9 | 90 | 555 | 414 | 21 | 92 | 15 | 0 | 285 | 270 | 9 | 90 | 555 | |||||||||||||||||||||||||||||||
2758630 | 2758630 | CT | school | 905220 | 1640011 | Windsor School District | 90522001089 | 1640811 | John F. Kennedy School | Public Schools | Regular School | No | Elementary | 03 | 05 | 2021 | pk_12_total | 80 | 134 | 92 | * | * | 0 | 42 | 190 | 174 | 14 | 68 | 364 | 80 | 134 | 92 | 0 | 42 | 190 | 174 | 14 | 68 | 364 | |||||||||||||||||||||||||||||||
2777976 | 2777976 | CT | school | 901110 | 370011 | Derby School District | 90111000175 | 376111 | Derby High School | Public Schools | Regular School | No | High | 09 | 12 | 2020 | pk_12_total | 145 | 58 | 92 | 0 | * | * | 15 | 157 | 157 | * | 55 | 314 | 145 | 58 | 92 | 0 | 15 | 157 | 157 | 55 | 314 | ||||||||||||||||||||||||||||||||
2778449 | 2778449 | CT | school | 930011 | New Haven School District | 932711 | Dr. Reginald Mayo Early Learning Center | Program | 2020 | pk_12_total | 20 | 191 | 92 | * | * | 0 | 14 | 189 | 136 | 0 | 77 | 325 | 20 | 191 | 92 | 0 | 14 | 189 | 136 | 0 | 77 | 325 | ||||||||||||||||||||||||||||||||||||||
2778700 | 2778700 | CT | school | 903840 | 1190011 | Rocky Hill School District | 90384000785 | 1196111 | Rocky Hill High School | Public Schools | Regular School | No | High | 09 | 12 | 2020 | pk_12_total | 479 | 36 | 92 | * | 116 | 0 | * | 372 | 371 | 11 | 89 | 743 | 479 | 36 | 92 | 116 | 0 | 372 | 371 | 11 | 89 | 743 | |||||||||||||||||||||||||||||||
2451734 | 2451734 | CT | school | 900270 | 90011 | Bethel School District | 90027000023 | 90411 | Anna H. Rockwell School | Public Schools | Regular School | No | Elementary | KG | 03 | 2019 | pk_12_total | 279 | * | 91 | * | 22 | 0 | 17 | 225 | 204 | 50 | 34 | 429 | 279 | 91 | 22 | 0 | 17 | 225 | 204 | 50 | 34 | 429 | |||||||||||||||||||||||||||||||
2452102 | 2452102 | CT | school | 901770 | 590011 | Groton School District | 90177000321 | 591711 | Mary Morrisson School | Public Schools | Regular School | No | Elementary | PK | 05 | 2019 | pk_12_total | 202 | 21 | 91 | * | 36 | * | 31 | 188 | 197 | 18 | 88 | 385 | 202 | 21 | 91 | 36 | 31 | 188 | 197 | 18 | 88 | 385 | |||||||||||||||||||||||||||||||
2452312 | 2452312 | CT | school | 902490 | 830011 | Middletown School District | 90249000461 | 831111 | Snow School | Public Schools | Regular School | No | Elementary | PK | 05 | 2019 | pk_12_total | 172 | 60 | 91 | 0 | 18 | 0 | 39 | 211 | 169 | 19 | 72 | 380 | 172 | 60 | 91 | 0 | 18 | 0 | 39 | 211 | 169 | 19 | 72 | 380 | |||||||||||||||||||||||||||||
2452426 | 2452426 | CT | school | 902790 | 930011 | New Haven School District | 90279000551 | 930911 | Davis Academy for Arts & Design Innovation | Public Schools | Regular School | No | Elementary | PK | 08 | 2019 | pk_12_total | 99 | 309 | 91 | * | * | 0 | 10 | 251 | 266 | 8 | 59 | 517 | 99 | 309 | 91 | 0 | 10 | 251 | 266 | 8 | 59 | 517 | |||||||||||||||||||||||||||||||
2452443 | 2452443 | CT | school | 902790 | 930011 | New Haven School District | 90279000586 | 933211 | Wexler/Grant Community School | Public Schools | Regular School | No | Elementary | PK | 08 | 2019 | pk_12_total | 10 | 266 | 91 | 0 | 0 | 0 | 6 | 196 | 177 | 18 | 56 | 373 | 10 | 266 | 91 | 0 | 0 | 0 | 6 | 196 | 177 | 18 | 56 | 373 | |||||||||||||||||||||||||||||
2452793 | 2452793 | CT | school | 904440 | 1380011 | Stratford School District | 90444000893 | 1380811 | Lordship School | Public Schools | Regular School | No | Elementary | KG | 06 | 2019 | pk_12_total | 91 | 100 | 91 | * | * | 0 | 15 | 152 | 151 | 21 | 39 | 303 | 91 | 100 | 91 | 0 | 15 | 152 | 151 | 21 | 39 | 303 | |||||||||||||||||||||||||||||||
2757944 | 2757944 | CT | school | 902640 | 880011 | Naugatuck School District | 90264000502 | 880211 | Cross Street Intermediate School | Public Schools | Regular School | No | Middle | 05 | 06 | 2021 | pk_12_total | 155 | 26 | 91 | * | 15 | 0 | * | 156 | 140 | 19 | 54 | 296 | 155 | 26 | 91 | 15 | 0 | 156 | 140 | 19 | 54 | 296 | |||||||||||||||||||||||||||||||
2758409 | 2758409 | CT | school | 904590 | 1430011 | Torrington School District | 90459000922 | 1430811 | Southwest School | Public Schools | Regular School | No | Elementary | 04 | 05 | 2021 | pk_12_total | 163 | 15 | 91 | 0 | 10 | 0 | 7 | 161 | 125 | 35 | 51 | 286 | 163 | 15 | 91 | 0 | 10 | 0 | 7 | 161 | 125 | 35 | 51 | 286 | |||||||||||||||||||||||||||||
2777785 | 2777785 | CT | school | 900420 | 140011 | Branford School District | 90042000041 | 145111 | Francis Walsh Intermediate School | Public Schools | Regular School | No | Middle | 05 | 08 | 2020 | pk_12_total | 627 | 39 | 91 | * | 68 | 0 | * | 451 | 404 | 31 | 105 | 855 | 627 | 39 | 91 | 68 | 0 | 451 | 404 | 31 | 105 | 855 | |||||||||||||||||||||||||||||||
2778281 | 2778281 | CT | school | 902310 | 770011 | Manchester School District | 90231000418 | 770311 | Buckley School | Public Schools | Regular School | No | Elementary | PK | 04 | 2020 | pk_12_total | 146 | 88 | 91 | * | 45 | 0 | * | 210 | 163 | 22 | 61 | 373 | 146 | 88 | 91 | 45 | 0 | 210 | 163 | 22 | 61 | 373 | |||||||||||||||||||||||||||||||
2778775 | 2778775 | CT | school | 900220 | 2960013 | Stamford Charter School for Excellence District | 90022001807 | 2960113 | Stamford Charter School for Excellence | Public Charter Schools | Regular School | Yes | Elementary | PK | 05 | 2020 | pk_12_total | * | 179 | 91 | 0 | 112 | * | 6 | 182 | 213 | 49 | 26 | 395 | 179 | 91 | 0 | 112 | 6 | 182 | 213 | 49 | 26 | 395 | |||||||||||||||||||||||||||||||
2452491 | 2452491 | CT | school | 902880 | 940011 | Newington School District | 90288000611 | 940611 | Anna Reynolds School | Public Schools | Regular School | No | Elementary | PK | 04 | 2019 | pk_12_total | 235 | 29 | 90 | 0 | 42 | 0 | 23 | 197 | 222 | 46 | 56 | 419 | 235 | 29 | 90 | 0 | 42 | 0 | 23 | 197 | 222 | 46 | 56 | 419 | |||||||||||||||||||||||||||||
2452855 | 2452855 | CT | school | 904680 | 1460011 | Vernon School District | 90468000941 | 1460211 | Maple Street School | Public Schools | Regular School | No | Elementary | KG | 05 | 2019 | pk_12_total | 92 | 45 | 90 | 0 | * | * | 27 | 135 | 138 | * | 32 | 273 | 92 | 45 | 90 | 0 | 27 | 135 | 138 | 32 | 273 | ||||||||||||||||||||||||||||||||
2452862 | 2452862 | CT | school | 904740 | 1480011 | Wallingford School District | 90474000950 | 1481011 | Cook Hill School | Public Schools | Regular School | No | Elementary | PK | 02 | 2019 | pk_12_total | 239 | * | 90 | 0 | 17 | 0 | * | 213 | 149 | 37 | 91 | 362 | 239 | 90 | 0 | 17 | 0 | 213 | 149 | 37 | 91 | 362 | |||||||||||||||||||||||||||||||
2452920 | 2452920 | CT | school | 1510011 | Waterbury School District | 90483001418 | 1519111 | Enlightenment School | Program | 2019 | pk_12_total | 13 | 46 | 90 | 0 | 0 | 0 | 6 | 97 | 58 | 19 | 41 | 155 | 13 | 46 | 90 | 0 | 0 | 0 | 6 | 97 | 58 | 19 | 41 | 155 | |||||||||||||||||||||||||||||||||||
2757835 | 2757835 | CT | school | 902310 | 770011 | Manchester School District | 90231000422 | 770611 | Keeney School | Public Schools | Regular School | No | Elementary | PK | 04 | 2021 | pk_12_total | 133 | 51 | 90 | 0 | * | * | 0 | 159 | 144 | 25 | 57 | 303 | 133 | 51 | 90 | 0 | 0 | 159 | 144 | 25 | 57 | 303 | |||||||||||||||||||||||||||||||
2758068 | 2758068 | CT | school | 902880 | 940011 | Newington School District | 90288000606 | 940811 | John Paterson School | Public Schools | Regular School | No | Elementary | PK | 04 | 2021 | pk_12_total | 232 | 27 | 90 | 0 | 21 | 0 | 19 | 194 | 195 | 55 | 70 | 389 | 232 | 27 | 90 | 0 | 21 | 0 | 19 | 194 | 195 | 55 | 70 | 389 | |||||||||||||||||||||||||||||
2758367 | 2758367 | CT | school | 904440 | 1380011 | Stratford School District | 90444000887 | 1380311 | Chapel School | Public Schools | Regular School | No | Elementary | KG | 06 | 2021 | pk_12_total | 122 | 52 | 90 | 0 | 8 | 0 | 6 | 158 | 120 | 13 | 39 | 278 | 122 | 52 | 90 | 0 | 8 | 0 | 6 | 158 | 120 | 13 | 39 | 278 | |||||||||||||||||||||||||||||
2758369 | 2758369 | CT | school | 904440 | 1380011 | Stratford School District | 90444000893 | 1380811 | Lordship School | Public Schools | Regular School | No | Elementary | KG | 06 | 2021 | pk_12_total | 78 | 74 | 90 | 0 | 8 | 0 | 9 | 138 | 121 | 16 | 37 | 259 | 78 | 74 | 90 | 0 | 8 | 0 | 9 | 138 | 121 | 16 | 37 | 259 | |||||||||||||||||||||||||||||
2758438 | 2758438 | CT | school | 904740 | 1480011 | Wallingford School District | 90474000950 | 1481011 | Cook Hill School | Public Schools | Regular School | No | Elementary | PK | 02 | 2021 | pk_12_total | 217 | * | 90 | * | 18 | 0 | 10 | 188 | 154 | 47 | 63 | 342 | 217 | 90 | 18 | 0 | 10 | 188 | 154 | 47 | 63 | 342 | |||||||||||||||||||||||||||||||
2779155 | 2779155 | CT | school | 900014 | 2680013 | Common Ground High School District | 90001400807 | 2686113 | Common Ground High School | Public Charter Schools | Regular School | Yes | High | 09 | 12 | 2020 | pk_12_total | * | 84 | 90 | 0 | 0 | 0 | * | 131 | * | 11 | 55 | 223 | 84 | 90 | 0 | 0 | 0 | 131 | 11 | 55 | 223 | ||||||||||||||||||||||||||||||||
2451901 | 2451901 | CT | school | 2430014 | Cooperative Educational Services | 2430214 | Transition Learning Center | Program | 2019 | pk_12_total | 14 | 6 | 9 | 0 | * | 0 | * | 25 | 7 | 0 | 32 | 32 | 14 | 6 | 9 | 0 | 0 | 25 | 7 | 0 | 32 | 32 | ||||||||||||||||||||||||||||||||||||||
2451945 | 2451945 | CT | school | 901170 | 400011 | East Granby School District | 90117000180 | 400111 | Allgrove School | Public Schools | Regular School | No | Elementary | PK | 02 | 2019 | pk_12_total | 151 | 10 | 9 | * | 11 | * | 6 | 105 | 84 | * | 23 | 189 | 151 | 10 | 9 | 11 | 6 | 105 | 84 | 23 | 189 | ||||||||||||||||||||||||||||||||
2452063 | 2452063 | CT | school | 901590 | 530011 | Franklin School District | 90159000278 | 530111 | Franklin Elementary School | Public Schools | Regular School | No | Elementary | PK | 08 | 2019 | pk_12_total | 125 | 8 | 9 | 0 | * | 0 | * | 83 | 71 | 0 | 9 | 154 | 125 | 8 | 9 | 0 | 0 | 83 | 71 | 0 | 9 | 154 | |||||||||||||||||||||||||||||||
2452204 | 2452204 | CT | school | 640011 | Hartford School District | 645011 | iGOAL 2 - Weaver High School | 2019 | pk_12_total | 0 | 6 | 9 | 0 | 0 | 0 | 0 | 8 | 7 | * | 15 | 15 | 0 | 6 | 9 | 0 | 0 | 0 | 0 | 8 | 7 | 15 | 15 |
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]);