enrollments
Data source: Big Local News · About: Big Local
20,454 rows where state = "CT" and year = 2020 sorted by native_american_alaskan_native_int
This data as json, CSV (advanced)
grade ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2777986 | 2777986 | CT | school | 901230 | 420011 | East Hampton School District | 90123000188 | 425111 | East Hampton Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2020 | pk_12_total | 412 | * | 29 | * | * | * | 12 | 218 | 244 | 0 | 57 | 462 | 412 | 29 | 12 | 218 | 244 | 0 | 57 | 462 | |||||||||||||||||||||||||||||||||
2777994 | 2777994 | CT | school | 901260 | 430011 | East Hartford School District | 90126000201 | 432011 | Governor William Pitkin School | Public Schools | Regular School | No | Elementary | KG | 05 | 2020 | pk_12_total | 52 | 85 | 133 | * | 33 | * | 15 | 158 | 162 | 54 | 56 | 320 | 52 | 85 | 133 | 33 | 15 | 158 | 162 | 54 | 56 | 320 | |||||||||||||||||||||||||||||||
2777995 | 2777995 | CT | school | 901260 | 430011 | East Hartford School District | 90126000204 | 430411 | Joseph O. Goodwin School | Public Schools | Regular School | No | Elementary | KG | 05 | 2020 | pk_12_total | 46 | 88 | 191 | * | * | 0 | 27 | 185 | 194 | 45 | 67 | 379 | 46 | 88 | 191 | 0 | 27 | 185 | 194 | 45 | 67 | 379 | |||||||||||||||||||||||||||||||
2777997 | 2777997 | CT | school | 901260 | 430011 | East Hartford School District | 90126000208 | 431211 | Silver Lane School | Public Schools | Regular School | No | Elementary | KG | 05 | 2020 | pk_12_total | 12 | 85 | 156 | * | * | 0 | 15 | 132 | 138 | 37 | 56 | 270 | 12 | 85 | 156 | 0 | 15 | 132 | 138 | 37 | 56 | 270 | |||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||
2777999 | 2777999 | CT | school | 901260 | 430011 | East Hartford School District | 90126000197 | 435111 | East Hartford Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2020 | pk_12_total | 106 | 358 | 564 | * | 39 | * | 60 | 612 | 521 | 162 | 242 | 1133 | 106 | 358 | 564 | 39 | 60 | 612 | 521 | 162 | 242 | 1133 | |||||||||||||||||||||||||||||||
2778001 | 2778001 | CT | school | 901260 | 430011 | East Hartford School District | 90126001477 | 436311 | Connecticut IB Academy | Public Schools | Regular School | No | High | 09 | 12 | 2020 | pk_12_total | 43 | 54 | 45 | * | 33 | 0 | * | 75 | 107 | * | * | 182 | 43 | 54 | 45 | 33 | 0 | 75 | 107 | 182 | |||||||||||||||||||||||||||||||||
2778002 | 2778002 | CT | school | 901260 | 430011 | East Hartford School District | 90126000200 | 436211 | East Hartford High School | Public Schools | Regular School | No | High | 09 | 12 | 2020 | pk_12_total | 212 | 580 | 754 | * | 84 | * | 45 | 868 | 814 | 171 | 294 | 1682 | 212 | 580 | 754 | 84 | 45 | 868 | 814 | 171 | 294 | 1682 | |||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
2778007 | 2778007 | CT | school | 901290 | 440011 | East Haven School District | 90129000219 | 440711 | Momauguin School | Public Schools | Regular School | No | Elementary | KG | 05 | 2020 | pk_12_total | 158 | 16 | 116 | * | * | 0 | 13 | 165 | 147 | 46 | 48 | 312 | 158 | 16 | 116 | 0 | 13 | 165 | 147 | 46 | 48 | 312 | |||||||||||||||||||||||||||||||
2778010 | 2778010 | CT | school | 901290 | 440011 | East Haven School District | 90129000217 | 445111 | Joseph Melillo Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2020 | pk_12_total | 272 | 40 | 184 | * | 12 | 0 | * | 257 | 263 | 51 | 82 | 520 | 272 | 40 | 184 | 12 | 0 | 257 | 263 | 51 | 82 | 520 | |||||||||||||||||||||||||||||||
2778011 | 2778011 | CT | school | 901290 | 440011 | East Haven School District | 90129000216 | 446111 | East Haven High School | Public Schools | Regular School | No | High | 09 | 12 | 2020 | pk_12_total | 552 | 42 | 238 | * | 51 | 0 | * | 466 | * | 77 | 133 | 898 | 552 | 42 | 238 | 51 | 0 | 466 | 77 | 133 | 898 | ||||||||||||||||||||||||||||||||
2778014 | 2778014 | CT | school | 901320 | 450011 | East Lyme School District | 90132000226 | 450411 | Lillie B. Haynes School | Public Schools | Regular School | No | Elementary | KG | 04 | 2020 | pk_12_total | 222 | * | 20 | * | 40 | 0 | 18 | 172 | 138 | 16 | 54 | 310 | 222 | 20 | 40 | 0 | 18 | 172 | 138 | 16 | 54 | 310 | |||||||||||||||||||||||||||||||
2778016 | 2778016 | CT | school | 901320 | 450011 | East Lyme School District | 90132000224 | 455111 | East Lyme Middle School | Public Schools | Regular School | No | Middle | 05 | 08 | 2020 | pk_12_total | 589 | * | 68 | * | 77 | 0 | 38 | 404 | 385 | 7 | 129 | 789 | 589 | 68 | 77 | 0 | 38 | 404 | 385 | 7 | 129 | 789 | |||||||||||||||||||||||||||||||
2778018 | 2778018 | CT | school | 901320 | 450011 | East Lyme School District | 90132000223 | 456111 | East Lyme High School | Public Schools | Regular School | No | High | 09 | 12 | 2020 | pk_12_total | 767 | 12 | 70 | * | 87 | * | 57 | 498 | 498 | 6 | 115 | 996 | 767 | 12 | 70 | 87 | 57 | 498 | 498 | 6 | 115 | 996 | |||||||||||||||||||||||||||||||
2778021 | 2778021 | CT | school | 901350 | 470011 | East Windsor School District | 90135000230 | 475411 | East Windsor Middle School | Public Schools | Regular School | No | Middle | 05 | 08 | 2020 | pk_12_total | 170 | 33 | 72 | * | * | 0 | 11 | 137 | 160 | 6 | 52 | 297 | 170 | 33 | 72 | 0 | 11 | 137 | 160 | 6 | 52 | 297 | |||||||||||||||||||||||||||||||
2778027 | 2778027 | CT | school | 2420014 | EdAdvance | 90351200575 | 2428014 | EdAdvance Headstart | Program | 2020 | pk_12_total | 100 | 8 | 61 | * | 8 | * | 7 | 88 | 104 | 0 | * | 192 | 100 | 8 | 61 | 8 | 7 | 88 | 104 | 0 | 192 | ||||||||||||||||||||||||||||||||||||||
2778028 | 2778028 | CT | school | 2420014 | EdAdvance | 90351201476 | 2429014 | The ACCESS School at The Danuta M. Thibodeau Education Center | Program | 2020 | pk_12_total | 14 | * | 7 | * | * | 0 | 0 | 25 | 0 | 0 | 25 | 25 | 14 | 7 | 0 | 0 | 25 | 0 | 0 | 25 | 25 | ||||||||||||||||||||||||||||||||||||||
2778029 | 2778029 | CT | school | 2420014 | EdAdvance | 2420114 | Steps | Program | 2020 | pk_12_total | 16 | * | 7 | * | 0 | 0 | 0 | * | * | * | 29 | 29 | 16 | 7 | 0 | 0 | 0 | 29 | 29 | |||||||||||||||||||||||||||||||||||||||||
2778034 | 2778034 | CT | school | 901440 | 480011 | Ellington School District | 90144000239 | 480611 | Windermere School | Public Schools | Regular School | No | Elementary | PK | 06 | 2020 | pk_12_total | 380 | 27 | 57 | * | 178 | 0 | * | 355 | 310 | 28 | 89 | 665 | 380 | 27 | 57 | 178 | 0 | 355 | 310 | 28 | 89 | 665 | |||||||||||||||||||||||||||||||
2778036 | 2778036 | CT | school | 901440 | 480011 | Ellington School District | 90144000238 | 485111 | Ellington Middle School | Public Schools | Regular School | No | Middle | 07 | 08 | 2020 | pk_12_total | 325 | 18 | 17 | * | 41 | 0 | * | 192 | 222 | * | 62 | 414 | 325 | 18 | 17 | 41 | 0 | 192 | 222 | 62 | 414 | ||||||||||||||||||||||||||||||||
2778049 | 2778049 | CT | school | 901470 | 490011 | Enfield School District | 90147000242 | 491611 | Eli Whitney School | Public Schools | Regular School | No | Elementary | 03 | 05 | 2020 | pk_12_total | 252 | 29 | 55 | * | 10 | 0 | * | 179 | 179 | 17 | 64 | 358 | 252 | 29 | 55 | 10 | 0 | 179 | 179 | 17 | 64 | 358 | |||||||||||||||||||||||||||||||
2778055 | 2778055 | CT | school | 901470 | 490011 | Enfield School District | 90147000254 | 491511 | Prudence Crandall School | Public Schools | Regular School | No | Elementary | 03 | 05 | 2020 | pk_12_total | 262 | 36 | 74 | * | 15 | * | 16 | 200 | 206 | 7 | 70 | 406 | 262 | 36 | 74 | 15 | 16 | 200 | 206 | 7 | 70 | 406 | |||||||||||||||||||||||||||||||
2778058 | 2778058 | CT | school | 901470 | 490011 | Enfield School District | 90147000249 | 495211 | John F. Kennedy Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2020 | pk_12_total | 751 | 69 | 186 | * | * | 0 | 47 | 554 | 524 | 19 | 168 | 1078 | 751 | 69 | 186 | 0 | 47 | 554 | 524 | 19 | 168 | 1078 | |||||||||||||||||||||||||||||||
2778061 | 2778061 | CT | school | 901470 | 490011 | Enfield School District | 90147000243 | 496111 | Enfield High School | Public Schools | Regular School | No | High | 09 | 12 | 2020 | pk_12_total | 1049 | 87 | 237 | * | 63 | * | 64 | 764 | 746 | 17 | 223 | 1510 | 1049 | 87 | 237 | 63 | 64 | 764 | 746 | 17 | 223 | 1510 | |||||||||||||||||||||||||||||||
2778067 | 2778067 | CT | school | 901530 | 510011 | Fairfield School District | 90153001378 | 510211 | Burr Elementary School | Public Schools | Regular School | No | Elementary | KG | 05 | 2020 | pk_12_total | 262 | * | 35 | * | 29 | 0 | 31 | 187 | 179 | 15 | 49 | 366 | 262 | 35 | 29 | 0 | 31 | 187 | 179 | 15 | 49 | 366 | |||||||||||||||||||||||||||||||
2778072 | 2778072 | CT | school | 901530 | 510011 | Fairfield School District | 90153000263 | 510711 | Mill Hill School | Public Schools | Regular School | No | Elementary | KG | 05 | 2020 | pk_12_total | 286 | * | 19 | * | 24 | 0 | 20 | 184 | 170 | * | 60 | 354 | 286 | 19 | 24 | 0 | 20 | 184 | 170 | 60 | 354 | ||||||||||||||||||||||||||||||||
2778078 | 2778078 | CT | school | 901530 | 510011 | Fairfield School District | 90153000919 | 515311 | Roger Ludlowe Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2020 | pk_12_total | 706 | * | 53 | * | 42 | 0 | 34 | 441 | 404 | * | 107 | 845 | 706 | 53 | 42 | 0 | 34 | 441 | 404 | 107 | 845 | ||||||||||||||||||||||||||||||||
2778079 | 2778079 | CT | school | 901530 | 510011 | Fairfield School District | 90153000271 | 515111 | Tomlinson Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2020 | pk_12_total | 442 | 21 | 114 | * | 50 | * | 34 | 344 | 319 | 21 | 79 | 663 | 442 | 21 | 114 | 50 | 34 | 344 | 319 | 21 | 79 | 663 | |||||||||||||||||||||||||||||||
2778080 | 2778080 | CT | school | 901530 | 510011 | Fairfield School District | 90153001379 | 516011 | Fairfield Ludlowe High School | Public Schools | Regular School | No | High | 09 | 12 | 2020 | pk_12_total | 1213 | * | 130 | * | 90 | 0 | 45 | 713 | 787 | * | 191 | 1500 | 1213 | 130 | 90 | 0 | 45 | 713 | 787 | 191 | 1500 | ||||||||||||||||||||||||||||||||
2778085 | 2778085 | CT | school | 901560 | 520011 | Farmington School District | 90156000276 | 520111 | Union School | Public Schools | Regular School | No | Elementary | KG | 04 | 2020 | pk_12_total | 189 | * | 37 | * | 48 | 0 | 31 | 171 | 148 | 14 | 39 | 319 | 189 | 37 | 48 | 0 | 31 | 171 | 148 | 14 | 39 | 319 | |||||||||||||||||||||||||||||||
2778088 | 2778088 | CT | school | 901560 | 520011 | Farmington School District | 90156000277 | 520311 | West District School | Public Schools | Regular School | No | Elementary | KG | 04 | 2020 | pk_12_total | 201 | * | 31 | * | 61 | 0 | 16 | 170 | 153 | 38 | 27 | 323 | 201 | 31 | 61 | 0 | 16 | 170 | 153 | 38 | 27 | 323 | |||||||||||||||||||||||||||||||
2778089 | 2778089 | CT | school | 901560 | 520011 | Farmington School District | 90156001368 | 520511 | West Woods Upper Elementary School | Public Schools | Regular School | No | Middle | 04 | 06 | 2020 | pk_12_total | 363 | 33 | 55 | * | 160 | 0 | * | 313 | 321 | 19 | 79 | 634 | 363 | 33 | 55 | 160 | 0 | 313 | 321 | 19 | 79 | 634 | |||||||||||||||||||||||||||||||
2778090 | 2778090 | CT | school | 901560 | 520011 | Farmington School District | 90156000274 | 525111 | Irving A. Robbins Middle School | Public Schools | Regular School | No | Middle | 07 | 08 | 2020 | pk_12_total | 388 | 35 | 65 | * | 172 | 0 | * | 346 | 337 | 8 | 78 | 683 | 388 | 35 | 65 | 172 | 0 | 346 | 337 | 8 | 78 | 683 | |||||||||||||||||||||||||||||||
2778091 | 2778091 | CT | school | 901560 | 520011 | Farmington School District | 90156000273 | 526111 | Farmington High School | Public Schools | Regular School | No | High | 09 | 12 | 2020 | pk_12_total | 846 | 48 | 74 | * | 250 | 0 | * | 607 | 637 | 13 | 154 | 1244 | 846 | 48 | 74 | 250 | 0 | 607 | 637 | 13 | 154 | 1244 | |||||||||||||||||||||||||||||||
2778093 | 2778093 | CT | school | 901590 | 530011 | Franklin School District | 90159000278 | 530111 | Franklin Elementary School | Public Schools | Regular School | No | Elementary | PK | 08 | 2020 | pk_12_total | 134 | * | 12 | * | * | 0 | 7 | 86 | * | * | 7 | 159 | 134 | 12 | 0 | 7 | 86 | 7 | 159 | ||||||||||||||||||||||||||||||||||
2778097 | 2778097 | CT | school | 901620 | 540011 | Glastonbury School District | 90162000286 | 540611 | Hopewell School | Public Schools | Regular School | No | Elementary | KG | 05 | 2020 | pk_12_total | 332 | * | 52 | * | 85 | 0 | 23 | 272 | 233 | 12 | 36 | 505 | 332 | 52 | 85 | 0 | 23 | 272 | 233 | 12 | 36 | 505 | |||||||||||||||||||||||||||||||
2778100 | 2778100 | CT | school | 540011 | Glastonbury School District | 90162001801 | 540111 | Links Academy | Program | 2020 | pk_12_total | 26 | * | 10 | * | 0 | 0 | * | 29 | 15 | 0 | 44 | 44 | 26 | 10 | 0 | 0 | 29 | 15 | 0 | 44 | 44 | ||||||||||||||||||||||||||||||||||||||
2778101 | 2778101 | CT | school | 901620 | 540011 | Glastonbury School District | 90162000279 | 540811 | Gideon Welles School | Public Schools | Regular School | No | Middle | 06 | 06 | 2020 | pk_12_total | 312 | * | 45 | * | 54 | 0 | 28 | 230 | 219 | * | 44 | 449 | 312 | 45 | 54 | 0 | 28 | 230 | 219 | 44 | 449 | ||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
2778103 | 2778103 | CT | school | 901620 | 540011 | Glastonbury School District | 90162000283 | 546111 | Glastonbury High School | Public Schools | Regular School | No | High | 09 | 12 | 2020 | pk_12_total | 1415 | 69 | 155 | * | 215 | * | 87 | 928 | 1019 | 9 | 202 | 1947 | 1415 | 69 | 155 | 215 | 87 | 928 | 1019 | 9 | 202 | 1947 | |||||||||||||||||||||||||||||||
2778105 | 2778105 | CT | school | 901680 | 560011 | Granby School District | 90168000290 | 560411 | Kelly Lane Primary School | Public Schools | Regular School | No | Elementary | PK | 02 | 2020 | pk_12_total | 334 | 29 | 19 | * | 12 | 0 | * | 207 | 198 | * | 59 | 405 | 334 | 29 | 19 | 12 | 0 | 207 | 198 | 59 | 405 | ||||||||||||||||||||||||||||||||
2778106 | 2778106 | CT | school | 901680 | 560011 | Granby School District | 90168000293 | 560311 | Wells Road Intermediate School | Public Schools | Regular School | No | Elementary | 03 | 05 | 2020 | pk_12_total | 321 | 21 | 18 | * | * | 0 | 11 | 176 | 205 | 0 | 64 | 381 | 321 | 21 | 18 | 0 | 11 | 176 | 205 | 0 | 64 | 381 | |||||||||||||||||||||||||||||||
2778107 | 2778107 | CT | school | 901680 | 560011 | Granby School District | 90168000291 | 565111 | Granby Memorial Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2020 | pk_12_total | 353 | 25 | 14 | * | * | 0 | 12 | 207 | 208 | 0 | 64 | 415 | 353 | 25 | 14 | 0 | 12 | 207 | 208 | 0 | 64 | 415 | |||||||||||||||||||||||||||||||
2778108 | 2778108 | CT | school | 901680 | 560011 | Granby School District | 90168000289 | 566111 | Granby Memorial High School | Public Schools | Regular School | No | High | 09 | 12 | 2020 | pk_12_total | 511 | 25 | 19 | * | * | * | 26 | 311 | 278 | * | 70 | 589 | 511 | 25 | 19 | 26 | 311 | 278 | 70 | 589 | |||||||||||||||||||||||||||||||||
2778109 | 2778109 | CT | school | 901710 | 570011 | Greenwich School District | 90171000301 | 570511 | Hamilton Avenue School | Public Schools | Regular School | No | Elementary | PK | 05 | 2020 | pk_12_total | 98 | 29 | 197 | * | * | 0 | 21 | 191 | 176 | 24 | 54 | 367 | 98 | 29 | 197 | 0 | 21 | 191 | 176 | 24 | 54 | 367 | |||||||||||||||||||||||||||||||
2778110 | 2778110 | CT | school | 901710 | 570011 | Greenwich School District | 90171000303 | 570611 | New Lebanon School | Public Schools | Regular School | No | Elementary | PK | 05 | 2020 | pk_12_total | 67 | * | 186 | * | 18 | 0 | 13 | 157 | 141 | 47 | 53 | 298 | 67 | 186 | 18 | 0 | 13 | 157 | 141 | 47 | 53 | 298 | |||||||||||||||||||||||||||||||
2778111 | 2778111 | CT | school | 901710 | 570011 | Greenwich School District | 90171000305 | 570811 | North Street School | Public Schools | Regular School | No | Elementary | PK | 05 | 2020 | pk_12_total | 310 | * | 40 | * | 20 | 0 | 32 | 209 | 202 | 10 | 40 | 411 | 310 | 40 | 20 | 0 | 32 | 209 | 202 | 10 | 40 | 411 | |||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
2778121 | 2778121 | CT | school | 901710 | 570011 | Greenwich School District | 90171000298 | 575211 | Eastern Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2020 | pk_12_total | 589 | * | 114 | * | 97 | 0 | 50 | 456 | 406 | 13 | 101 | 862 | 589 | 114 | 97 | 0 | 50 | 456 | 406 | 13 | 101 | 862 | |||||||||||||||||||||||||||||||
2778122 | 2778122 | CT | school | 901710 | 570011 | Greenwich School District | 90171000309 | 575311 | Western Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2020 | pk_12_total | 286 | 29 | 243 | * | 51 | 0 | * | 335 | 297 | 31 | 99 | 632 | 286 | 29 | 243 | 51 | 0 | 335 | 297 | 31 | 99 | 632 | |||||||||||||||||||||||||||||||
2778123 | 2778123 | CT | school | 901710 | 570011 | Greenwich School District | 90171000300 | 576111 | Greenwich High School | Public Schools | Regular School | No | High | 09 | 12 | 2020 | pk_12_total | 1745 | 84 | 626 | * | 194 | * | 92 | 1375 | * | 80 | 339 | 2749 | 1745 | 84 | 626 | 194 | 92 | 1375 | 80 | 339 | 2749 | ||||||||||||||||||||||||||||||||
2778126 | 2778126 | CT | school | 901740 | 580011 | Griswold School District | 90174000310 | 580311 | Griswold Elementary School | Public Schools | Regular School | No | Elementary | PK | 04 | 2020 | pk_12_total | 516 | 18 | 65 | * | 8 | * | 56 | 338 | 332 | 10 | 122 | 670 | 516 | 18 | 65 | 8 | 56 | 338 | 332 | 10 | 122 | 670 | |||||||||||||||||||||||||||||||
2778127 | 2778127 | CT | school | 901740 | 580011 | Griswold School District | 90174000019 | 585111 | Griswold Middle School | Public Schools | Regular School | No | Middle | 05 | 08 | 2020 | pk_12_total | 431 | 15 | 54 | * | * | 0 | 47 | 287 | 272 | 8 | 89 | 559 | 431 | 15 | 54 | 0 | 47 | 287 | 272 | 8 | 89 | 559 | |||||||||||||||||||||||||||||||
2778129 | 2778129 | CT | school | 901740 | 580011 | Griswold School District | 90174000311 | 586211 | Griswold High School | Public Schools | Regular School | No | High | 09 | 12 | 2020 | pk_12_total | 414 | 12 | 47 | * | 10 | * | 27 | 247 | 274 | * | 101 | 521 | 414 | 12 | 47 | 10 | 27 | 247 | 274 | 101 | 521 | ||||||||||||||||||||||||||||||||
2778130 | 2778130 | CT | school | 901770 | 590011 | Groton School District | 90177001494 | 592011 | Catherine Kolnaski Magnet School | Public Schools | Regular School | No | Elementary | PK | 05 | 2020 | pk_12_total | 161 | 34 | 128 | * | 45 | * | 66 | 209 | 228 | 35 | 61 | 437 | 161 | 34 | 128 | 45 | 66 | 209 | 228 | 35 | 61 | 437 | |||||||||||||||||||||||||||||||
2778131 | 2778131 | CT | school | 901770 | 590011 | Groton School District | 90177000314 | 590311 | Claude Chester School | Public Schools | Regular School | No | Elementary | PK | 05 | 2020 | pk_12_total | 99 | 31 | 126 | * | 22 | * | 50 | 186 | 149 | 24 | 71 | 335 | 99 | 31 | 126 | 22 | 50 | 186 | 149 | 24 | 71 | 335 | |||||||||||||||||||||||||||||||
2778132 | 2778132 | CT | school | 901770 | 590011 | Groton School District | 90177000321 | 591711 | Mary Morrisson School | Public Schools | Regular School | No | Elementary | PK | 05 | 2020 | pk_12_total | 184 | 39 | 78 | * | 38 | * | 20 | 170 | 193 | 16 | 89 | 363 | 184 | 39 | 78 | 38 | 20 | 170 | 193 | 16 | 89 | 363 | |||||||||||||||||||||||||||||||
2778133 | 2778133 | CT | school | 901770 | 590011 | Groton School District | 90177000325 | 590111 | S. B. Butler School | Public Schools | Regular School | No | Elementary | PK | 05 | 2020 | pk_12_total | 204 | 15 | 44 | * | * | 0 | 34 | 181 | 128 | 7 | 85 | 309 | 204 | 15 | 44 | 0 | 34 | 181 | 128 | 7 | 85 | 309 | |||||||||||||||||||||||||||||||
2778134 | 2778134 | CT | school | 901770 | 590011 | Groton School District | 90177000313 | 591811 | Charles Barnum School | Public Schools | Regular School | No | Elementary | KG | 05 | 2020 | pk_12_total | 217 | 30 | 72 | * | 8 | * | 34 | 193 | 175 | 6 | 55 | 368 | 217 | 30 | 72 | 8 | 34 | 193 | 175 | 6 | 55 | 368 | |||||||||||||||||||||||||||||||
2778136 | 2778136 | CT | school | 901770 | 590011 | Groton School District | 90177000312 | 595311 | Carl C. Cutler Middle School | Regular School | No | Middle | 06 | 08 | 2020 | pk_12_total | 311 | 21 | 83 | * | 30 | * | 57 | 214 | 297 | 8 | 75 | 511 | 311 | 21 | 83 | 30 | 57 | 214 | 297 | 8 | 75 | 511 | ||||||||||||||||||||||||||||||||
2778137 | 2778137 | CT | school | 901770 | 590011 | Groton School District | 90177000326 | 595211 | West Side Middle School | Regular School | No | Middle | 06 | 08 | 2020 | pk_12_total | 209 | 63 | 150 | * | 26 | * | 49 | 306 | 197 | 19 | 108 | 503 | 209 | 63 | 150 | 26 | 49 | 306 | 197 | 19 | 108 | 503 | ||||||||||||||||||||||||||||||||
2778138 | 2778138 | CT | school | 901770 | 590011 | Groton School District | 90177000318 | 596111 | Robert E. Fitch High School | Public Schools | Regular School | No | High | 09 | 12 | 2020 | pk_12_total | 532 | 89 | 200 | * | 62 | * | 83 | 509 | 472 | 28 | 150 | 981 | 532 | 89 | 200 | 62 | 83 | 509 | 472 | 28 | 150 | 981 | |||||||||||||||||||||||||||||||
2778150 | 2778150 | CT | school | 901860 | 620011 | Hamden School District | 90186000337 | 620211 | Church Street School | Public Schools | Regular School | No | Elementary | PK | 06 | 2020 | pk_12_total | 23 | 122 | 100 | * | 10 | * | 14 | 129 | 144 | 29 | 38 | 273 | 23 | 122 | 100 | 10 | 14 | 129 | 144 | 29 | 38 | 273 | |||||||||||||||||||||||||||||||
2778157 | 2778157 | CT | school | 901860 | 620011 | Hamden School District | 90186000346 | 620111 | Shepherd Glen School | Public Schools | Regular School | No | Elementary | KG | 06 | 2020 | pk_12_total | 54 | 110 | 73 | * | 61 | 0 | * | 163 | 149 | 50 | 32 | 312 | 54 | 110 | 73 | 61 | 0 | 163 | 149 | 50 | 32 | 312 | |||||||||||||||||||||||||||||||
2778159 | 2778159 | CT | school | 901860 | 620011 | Hamden School District | 90186000349 | 621411 | West Woods School | Public Schools | Regular School | No | Elementary | KG | 06 | 2020 | pk_12_total | 161 | 62 | 43 | * | 48 | 0 | * | 179 | 162 | 21 | 38 | 341 | 161 | 62 | 43 | 48 | 0 | 179 | 162 | 21 | 38 | 341 | |||||||||||||||||||||||||||||||
2778166 | 2778166 | CT | school | 901860 | 620011 | Hamden School District | 90186000342 | 625211 | Hamden Middle School | Public Schools | Regular School | No | Middle | 07 | 08 | 2020 | pk_12_total | 297 | 273 | 205 | * | 54 | * | 45 | 449 | 427 | 31 | 160 | 876 | 297 | 273 | 205 | 54 | 45 | 449 | 427 | 31 | 160 | 876 | |||||||||||||||||||||||||||||||
2778168 | 2778168 | CT | school | 901860 | 620011 | Hamden School District | 90186000339 | 626111 | Hamden High School | Public Schools | Regular School | No | High | 09 | 12 | 2020 | pk_12_total | 540 | 524 | 314 | * | 122 | * | 65 | 822 | 748 | 75 | 236 | 1570 | 540 | 524 | 314 | 122 | 65 | 822 | 748 | 75 | 236 | 1570 | |||||||||||||||||||||||||||||||
2778170 | 2778170 | CT | school | 901890 | 630011 | Hampton School District | 90189000351 | 630111 | Hampton Elementary School | Public Schools | Regular School | No | Elementary | PK | 06 | 2020 | pk_12_total | 79 | 0 | * | * | 0 | 0 | * | 52 | 38 | 0 | 15 | 90 | 79 | 0 | 0 | 0 | 52 | 38 | 0 | 15 | 90 | ||||||||||||||||||||||||||||||||
2778171 | 2778171 | CT | school | 901920 | 640011 | Hartford School District | 90192001192 | 642811 | Betances Learning Lab Magnet School | Public Schools | Regular School | No | Elementary | PK | 04 | 2020 | pk_12_total | 42 | 72 | 195 | * | 93 | * | 6 | 200 | 211 | 73 | 55 | 411 | 42 | 72 | 195 | 93 | 6 | 200 | 211 | 73 | 55 | 411 | |||||||||||||||||||||||||||||||
2778172 | 2778172 | CT | school | 901920 | 640011 | Hartford School District | 90192001534 | 643511 | Breakthrough Magnet School, North | Public Schools | Regular School | No | Elementary | PK | 05 | 2020 | pk_12_total | 17 | 150 | 72 | * | 66 | * | 17 | 162 | 163 | 14 | 32 | 325 | 17 | 150 | 72 | 66 | 17 | 162 | 163 | 14 | 32 | 325 | |||||||||||||||||||||||||||||||
2778173 | 2778173 | CT | school | 901920 | 640011 | Hartford School District | 90192001369 | 643311 | Breakthrough Magnet School, South | Public Schools | Regular School | No | Elementary | PK | 08 | 2020 | pk_12_total | 49 | 75 | 170 | * | 20 | 0 | * | 169 | 158 | 41 | 54 | 327 | 49 | 75 | 170 | 20 | 0 | 169 | 158 | 41 | 54 | 327 | |||||||||||||||||||||||||||||||
2778174 | 2778174 | CT | school | 901920 | 640011 | Hartford School District | 90192000357 | 640611 | Burns Latino Studies Academy | Public Schools | Regular School | No | Elementary | PK | 05 | 2020 | pk_12_total | 8 | 33 | 221 | * | 6 | 0 | * | 137 | 135 | 120 | 60 | 272 | 8 | 33 | 221 | 6 | 0 | 137 | 135 | 120 | 60 | 272 | |||||||||||||||||||||||||||||||
2778176 | 2778176 | CT | school | 901920 | 640011 | Hartford School District | 90192000360 | 640711 | Dwight-Bellizzi Dual Language Academy | Public Schools | Regular School | No | Elementary | PK | 08 | 2020 | pk_12_total | 27 | 77 | 425 | * | 18 | 0 | * | 288 | 267 | 221 | 74 | 555 | 27 | 77 | 425 | 18 | 0 | 288 | 267 | 221 | 74 | 555 | |||||||||||||||||||||||||||||||
2778178 | 2778178 | CT | school | 901920 | 640011 | Hartford School District | 90192000366 | 640911 | Environmental Sciences Magnet at Hooker School | Public Schools | Regular School | No | Elementary | PK | 08 | 2020 | pk_12_total | 109 | 70 | 374 | * | 34 | 0 | * | 311 | 295 | 76 | 67 | 606 | 109 | 70 | 374 | 34 | 0 | 311 | 295 | 76 | 67 | 606 | |||||||||||||||||||||||||||||||
2778179 | 2778179 | CT | school | 901920 | 640011 | Hartford School District | 90192000636 | 643211 | Expeditionary Learning Academy at Moylan School | Public Schools | Regular School | No | Elementary | PK | 05 | 2020 | pk_12_total | 20 | 57 | 422 | * | * | * | 6 | 256 | 254 | 156 | 105 | 510 | 20 | 57 | 422 | 6 | 256 | 254 | 156 | 105 | 510 | ||||||||||||||||||||||||||||||||
2778180 | 2778180 | CT | school | 901920 | 640011 | Hartford School District | 90192001643 | 641311 | Hartford PreKindergarten Magnet School | Public Schools | Regular School | No | Prekindergarten | PK | PK | 2020 | pk_12_total | 18 | 56 | 26 | * | 56 | 0 | * | 76 | 85 | 0 | 9 | 161 | 18 | 56 | 26 | 56 | 0 | 76 | 85 | 0 | 9 | 161 | |||||||||||||||||||||||||||||||
2778181 | 2778181 | CT | school | 901920 | 640011 | Hartford School District | 90192000368 | 641011 | Kennelly School | Public Schools | Regular School | No | Elementary | PK | 08 | 2020 | pk_12_total | 26 | 98 | 495 | * | 12 | * | * | 315 | 329 | 204 | 101 | 644 | 26 | 98 | 495 | 12 | 315 | 329 | 204 | 101 | 644 | ||||||||||||||||||||||||||||||||
2778182 | 2778182 | CT | school | 901920 | 640011 | Hartford School District | 90192000370 | 641111 | Kinsella Magnet School of Performing Arts | Public Schools | Regular School | No | Other | PK | 12 | 2020 | pk_12_total | 136 | 166 | 346 | * | * | 0 | 30 | 275 | 436 | 69 | 137 | 711 | 136 | 166 | 346 | 0 | 30 | 275 | 436 | 69 | 137 | 711 | |||||||||||||||||||||||||||||||
2778184 | 2778184 | CT | school | 901920 | 640011 | Hartford School District | 90192001641 | 640511 | Montessori Magnet at Batchelder School | Public Schools | Regular School | No | Elementary | PK | 06 | 2020 | pk_12_total | 88 | 50 | 205 | * | * | 0 | 11 | * | 191 | 76 | 45 | 367 | 88 | 50 | 205 | 0 | 11 | 191 | 76 | 45 | 367 | ||||||||||||||||||||||||||||||||
2778185 | 2778185 | CT | school | 901920 | 640011 | Hartford School District | 90192001531 | 643711 | Montessori Magnet at Fisher School | Public Schools | Regular School | No | Elementary | PK | 08 | 2020 | pk_12_total | 80 | 161 | 68 | * | 33 | 0 | * | 177 | 181 | 20 | 28 | 358 | 80 | 161 | 68 | 33 | 0 | 177 | 181 | 20 | 28 | 358 | |||||||||||||||||||||||||||||||
2778186 | 2778186 | CT | school | 901920 | 640011 | Hartford School District | 90192000373 | 641511 | Parkville Community School | Public Schools | Regular School | No | Elementary | PK | 05 | 2020 | pk_12_total | 35 | 29 | 357 | * | * | * | * | 232 | 200 | 204 | 70 | 432 | 35 | 29 | 357 | 232 | 200 | 204 | 70 | 432 | |||||||||||||||||||||||||||||||||
2778191 | 2778191 | CT | school | 901920 | 640011 | Hartford School District | 90192000376 | 641711 | Rawson School | Public Schools | Regular School | No | Elementary | PK | 05 | 2020 | pk_12_total | * | 234 | 80 | * | * | * | 9 | 170 | 162 | 44 | 57 | 332 | 234 | 80 | 9 | 170 | 162 | 44 | 57 | 332 | |||||||||||||||||||||||||||||||||
2778192 | 2778192 | CT | school | 901920 | 640011 | Hartford School District | 90192000377 | 640111 | SAND School | Public Schools | Regular School | No | Elementary | PK | 05 | 2020 | pk_12_total | * | 88 | 234 | * | * | 0 | * | 180 | 153 | 91 | 58 | 333 | 88 | 234 | 0 | 180 | 153 | 91 | 58 | 333 | |||||||||||||||||||||||||||||||||
2778194 | 2778194 | CT | school | 901920 | 640011 | Hartford School District | 90192000383 | 642011 | Webster Micro Society Magnet School | Public Schools | Regular School | No | Elementary | PK | 08 | 2020 | pk_12_total | 104 | 279 | 162 | * | 61 | 0 | * | 335 | 300 | 46 | 80 | 635 | 104 | 279 | 162 | 61 | 0 | 335 | 300 | 46 | 80 | 635 | |||||||||||||||||||||||||||||||
2778200 | 2778200 | CT | school | 901920 | 640011 | Hartford School District | 90192000358 | 642311 | Burr Middle School | Public Schools | Regular School | No | Elementary | KG | 08 | 2020 | pk_12_total | 15 | 97 | 455 | * | 7 | 0 | * | 321 | 258 | 239 | 97 | 579 | 15 | 97 | 455 | 7 | 0 | 321 | 258 | 239 | 97 | 579 | |||||||||||||||||||||||||||||||
2778202 | 2778202 | CT | school | 901920 | 640011 | Hartford School District | 90192000372 | 641411 | Naylor/CCSU Leadership Academy | Public Schools | Regular School | No | Elementary | KG | 08 | 2020 | pk_12_total | 56 | 48 | 298 | * | 15 | * | * | 222 | 201 | 139 | 96 | 423 | 56 | 48 | 298 | 15 | 222 | 201 | 139 | 96 | 423 | ||||||||||||||||||||||||||||||||
2778203 | 2778203 | CT | school | 901920 | 640011 | Hartford School District | 90192000362 | 642511 | STEM Magnet at Annie Fisher School | Public Schools | Regular School | No | Elementary | KG | 08 | 2020 | pk_12_total | 50 | 161 | 49 | * | 59 | * | 15 | 187 | 150 | 28 | 44 | 337 | 50 | 161 | 49 | 59 | 15 | 187 | 150 | 28 | 44 | 337 | |||||||||||||||||||||||||||||||
2778212 | 2778212 | CT | school | 901920 | 640011 | Hartford School District | 90192001582 | 644011 | Renzulli Gifted and Talented Academy | Public Schools | Regular School | No | Middle | 04 | 08 | 2020 | pk_12_total | 12 | 43 | 53 | * | 12 | 0 | * | 73 | 56 | * | * | 129 | 12 | 43 | 53 | 12 | 0 | 73 | 56 | 129 | |||||||||||||||||||||||||||||||||
2778213 | 2778213 | CT | school | 901920 | 640011 | Hartford School District | 90192001616 | 643811 | Betances STEM Magnet School | Public Schools | Regular School | No | Middle | 05 | 08 | 2020 | pk_12_total | 39 | 63 | 129 | * | 13 | 0 | * | 153 | 100 | 31 | 39 | 253 | 39 | 63 | 129 | 13 | 0 | 153 | 100 | 31 | 39 | 253 | |||||||||||||||||||||||||||||||
2778216 | 2778216 | CT | school | 901920 | 640011 | Hartford School District | 90192001295 | 645411 | Hartford Magnet Trinity College Academy | Public Schools | Regular School | No | High | 06 | 12 | 2020 | pk_12_total | 177 | 266 | 504 | * | 42 | * | 50 | 489 | 557 | 98 | 127 | 1046 | 177 | 266 | 504 | 42 | 50 | 489 | 557 | 98 | 127 | 1046 | |||||||||||||||||||||||||||||||
2778220 | 2778220 | CT | school | 901920 | 640011 | Hartford School District | 90192001370 | 646511 | Sport and Medical Sciences Academy | Public Schools | Regular School | No | High | 06 | 12 | 2020 | pk_12_total | 141 | 146 | 302 | * | 32 | 0 | * | 385 | 258 | 80 | 75 | 643 | 141 | 146 | 302 | 32 | 0 | 385 | 258 | 80 | 75 | 643 | |||||||||||||||||||||||||||||||
2778224 | 2778224 | CT | school | 901920 | 640011 | Hartford School District | 90192001572 | 647111 | Bulkeley High School | Public Schools | Regular School | No | High | 09 | 12 | 2020 | pk_12_total | 13 | 140 | 393 | * | 8 | * | * | 290 | 272 | 222 | 101 | 562 | 13 | 140 | 393 | 8 | 290 | 272 | 222 | 101 | 562 | ||||||||||||||||||||||||||||||||
2778226 | 2778226 | CT | school | 901920 | 640011 | Hartford School District | 90192001925 | 646211 | Hartford Public High School | Public Schools | Regular School | No | High | 09 | 12 | 2020 | pk_12_total | 28 | 309 | 602 | * | 28 | * | 6 | 528 | 448 | 314 | 208 | 976 | 28 | 309 | 602 | 28 | 6 | 528 | 448 | 314 | 208 | 976 | |||||||||||||||||||||||||||||||
2778230 | 2778230 | CT | school | 901920 | 640011 | Hartford School District | 90192001381 | 646711 | University High School of Science and Engineering | Public Schools | Regular School | No | High | 09 | 12 | 2020 | pk_12_total | 110 | 173 | 86 | * | 44 | * | 11 | 263 | 166 | 22 | 38 | 429 | 110 | 173 | 86 | 44 | 11 | 263 | 166 | 22 | 38 | 429 | |||||||||||||||||||||||||||||||
2778231 | 2778231 | CT | school | 640011 | Hartford School District | 90192000382 | 646311 | Weaver High School | Public Schools | 2020 | pk_12_total | * | 229 | 178 | * | * | 0 | 6 | * | 215 | 53 | 103 | 423 | 229 | 178 | 0 | 6 | 215 | 53 | 103 | 423 | |||||||||||||||||||||||||||||||||||||||
2778238 | 2778238 | CT | school | 900207 | 2860013 | Highville Charter School District | 90020700907 | 2860113 | Highville Charter School | Public Charter Schools | Regular School | Yes | Other | PK | 12 | 2020 | pk_12_total | 6 | 426 | 20 | * | 0 | * | * | 200 | 260 | * | 24 | 460 | 6 | 426 | 20 | 0 | 200 | 260 | 24 | 460 | |||||||||||||||||||||||||||||||||
2778239 | 2778239 | CT | school | 900010 | 2640013 | Integrated Day Charter School District | 90001000775 | 2640113 | Integrated Day Charter School | Public Charter Schools | Regular School | Yes | Elementary | PK | 08 | 2020 | pk_12_total | 166 | * | 63 | * | 49 | 0 | 37 | 173 | 179 | 29 | 32 | 352 | 166 | 63 | 49 | 0 | 37 | 173 | 179 | 29 | 32 | 352 | |||||||||||||||||||||||||||||||
2778240 | 2778240 | CT | school | 900007 | 2610013 | Jumoke Academy District | 90000700747 | 2610113 | Jumoke Academy | Public Charter Schools | Regular School | Yes | Other | PK | 12 | 2020 | pk_12_total | * | 650 | 39 | * | * | 0 | 8 | * | 367 | 6 | 42 | 706 | 650 | 39 | 0 | 8 | 367 | 6 | 42 | 706 | |||||||||||||||||||||||||||||||||
2778243 | 2778243 | CT | school | 902070 | 690011 | Killingly School District | 90207000391 | 690111 | Killingly Central School | Public Schools | Regular School | No | Elementary | PK | 01 | 2020 | pk_12_total | 294 | * | 41 | * | 7 | 0 | 43 | 195 | 196 | 17 | 61 | 391 | 294 | 41 | 7 | 0 | 43 | 195 | 196 | 17 | 61 | 391 |
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]);