Data source: Big Local News · About: Big Local

1,461 rows where grade = "pk_12_total", state = "CT" and year = 2020 sorted by ccd_school_lvl descending

View and edit SQL

year

  • 2020 · 1,461

grade

  • pk_12_total · 1,461
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
2779120 CT     school 900219 2940013   Great Oaks Charter School District 90021901782 2940113 Great Oaks Charter School Public Charter Schools Regular School Yes Secondary 06 11 2020   pk_12_total 32 266 250   * 0     *   *   262 293     66             93   555 32 266 250     0             262 293     66       93   555
2777768 CT     school 900330 110011   Bloomfield School District 90033001565 110811 Wintonbury Early Childhood Magnet School Public Schools Regular School No Prekindergarten PK PK 2020   pk_12_total 107 110 38   * 33     0   *   159 155     0             49   314 107 110 38     33     0       159 155     0       49   314
2777790 CT     school 900450 150011   Bridgeport School District 90045000085 154411 A.B. Skane Center Public Schools Regular School No Prekindergarten PK PK 2020   pk_12_total 36 46 121   0 *     0   *   141 69     0             137   210 36 46 121   0       0       141 69     0       137   210
2777829 CT     school 900510 170011   Bristol School District 90051001774 170411 Bristol Early Childhood Center-BECC Public Schools Special Education School No Prekindergarten PK PK 2020   pk_12_total 68 0 31   0 *     0   *   75 38     0             70   113 68 0 31   0       0       75 38     0       70   113
2777943 CT     school 901020 340011   Danbury School District 90102001634 340111 DPS Early Childhood Center Public Schools Regular School No Prekindergarten PK PK 2020   pk_12_total 46 * 81   0 13     0   *   101 54     0             80   155 46   81   0 13     0       101 54     0       80   155
2777970 CT     school 901110 370011   Derby School District 90111001806 370111 Little Raiders University Public Schools Regular School No Prekindergarten PK PK 2020   pk_12_total 21 6 15   0 0     0   7   24 25     0             19   49 21 6 15   0 0     0   7   24 25     0       19   49
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
2778549 CT     school 903090 1030011   Norwalk School District 90309001914 1030111 Norwalk Early Childhood Center Public Schools Regular School No Prekindergarten PK PK 2020   pk_12_total 53 15 67   * 12     0   *   84 71     0             92   155 53 15 67     12     0       84 71     0       92   155
2778568 CT     school 903120 1040011   Norwich School District 90312000663 1040111 Bishop School Early Learning Center Public Schools Regular School No Prekindergarten PK PK 2020   pk_12_total 54 34 66   * 10     *   12   97 81     0             61   178 54 34 66     10         12   97 81     0       61   178
2778673 CT     school 903540 2180012   Regional School District 18 90354000761 2180312 Center School Regional Schools Special Education School No Prekindergarten PK PK 2020   pk_12_total * 0 *   0 0     0   0   37 34     0             12   71   0     0 0     0   0   37 34     0       12   71
2778748 CT     school 904230 1310011   Southington School District 90423001808 1312011 Southington Public Schools Preschool Program at Hatton School Public Schools Regular School No Prekindergarten PK PK 2020   pk_12_total 63 0 7   0 *     0   *   50 27     0             52   77 63 0 7   0       0       50 27     0       52   77
2778175 CT     school 901920 640011   Hartford School District 90192001435 646911 Capital Preparatory Magnet School Public Schools Regular School No Other PK 12 2020   pk_12_total 40 392 162   0 10     0   27   318 313     31             95   631 40 392 162   0 10     0   27   318 313     31       95   631
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
2778201 CT     school 901920 640011   Hartford School District 90192001535 643611 Global Communications Academy Public Schools Regular School No Other KG 12 2020   pk_12_total * 326 238   0 *     0   11   275 308     87             104   583   326 238   0       0   11   275 308     87       104   583
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
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
2779099 CT     school 900208 2850013   Achievement First Bridgeport Academy District 90020801493 2850113 Achievement First Bridgeport Academy Public Charter Schools Regular School Yes Other KG 12 2020   pk_12_total 13 596 487   * 6     *   *   524 586     148             112   1110 13 596 487     6             524 586     148       112   1110
2779100 CT     school 900212 2880013   Achievement First Hartford Academy District 90021201528 2880113 Achievement First Hartford Academy Public Charter Schools Regular School Yes Other KG 12 2020   pk_12_total * 842 299   6 *     *   15   553 616     70             117   1169   842 299   6           15   553 616     70       117   1169
2779101 CT     school 900024 2790013   Amistad Academy District 90002400981 2795113 Amistad Academy Public Charter Schools Regular School Yes Other KG 12 2020   pk_12_total * 684 381   * 0     0   20   498 605     111             80   1103   684 381     0     0   20   498 605     111       80   1103
2779104 CT     school 900221 2970013   Capital Preparatory Harbor School District 90022101803 2970113 Capital Preparatory Harbor School Public Charter Schools Regular School Yes Other KG 12 2020   pk_12_total * 539 211   0 0     0   *   387 373     50             77   760   539 211   0 0     0       387 373     50       77   760
2779115 CT     school 900214 2890013   Elm City College Preparatory School District 90021401548 2890113 Elm City College Preparatory School Public Charter Schools Regular School Yes Other KG 12 2020   pk_12_total 21 522 213   * *     0   9   373 394     53             70   767 21 522 213           0   9   373 394     53       70   767
2777729 CT     school 900060 20011   Ansonia School District 90006010008 25111 Ansonia Middle School Public Schools Regular School No Middle 07 08 2020   pk_12_total 108 74 148   0 6     0   20   189 167     10             73   356 108 74 148   0 6     0   20   189 167     10       73   356
2777739 CT     school 900070 2440014   Area Cooperative Educational Services 90007001358 2445114 Thomas Edison Magnet Middle School Regional Education Service Center Schools Regular School No Middle 06 08 2020   pk_12_total 144 100 381   * 36     0   *   342 356     67             79   698 144 100 381     36     0       342 356     67       79   698
2777748 CT     school 900120 40011   Avon School District 90012001367 40511 Thompson Brook School Public Schools Regular School No Middle 05 06 2020   pk_12_total 306 31 39   * 105     0   *   237 265     8             57   502 306 31 39     105     0       237 265     8       57   502
2777749 CT     school 900120 40011   Avon School District 90012000012 45111 Avon Middle School Public Schools Regular School No Middle 07 08 2020   pk_12_total 325 26 36   0 123     0   16   248 278     7             54   526 325 26 36   0 123     0   16   248 278     7       54   526
2777757 CT     school 900210 70011   Berlin School District 90021000017 75111 Catherine M. McGee Middle School Public Schools Regular School No Middle 06 08 2020   pk_12_total 503 18 82   0 21     0   20   321 323     12             109   644 503 18 82   0 21     0   20   321 323     12       109   644
2777764 CT     school 900270 90011   Bethel School District 90027000025 95111 Bethel Middle School Public Schools Regular School No Middle 06 08 2020   pk_12_total 518 23 184   7 52     0   22   402 404     27             82   806 518 23 184   7 52     0   22   402 404     27       82   806
2777772 CT     school 900330 110011   Bloomfield School District 90033001375 110711 Carmen Arace Intermediate School Public Schools Regular School No Middle 05 06 2020   pk_12_total 9 191 30   * *     0   8   118 123     *             56   241 9 191 30           0   8   118 123             56   241
2777774 CT     school 900330 110011   Bloomfield School District 90033000034 115211 Carmen Arace Middle School Public Schools Regular School No Middle 07 08 2020   pk_12_total 7 220 28   * *     0   10   134 134     *             58   268 7 220 28           0   10   134 134             58   268
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
2777850 CT     school 900510 170011   Bristol School District 90051000089 175111 Chippens Hill Middle School Public Schools Regular School No Middle 06 08 2020   pk_12_total 350 60 249   0 34     0   27   347 373     46             119   720 350 60 249   0 34     0   27   347 373     46       119   720
2777858 CT     school 900510 170011   Bristol School District 90051000104 175211 Northeast Middle School Public Schools Regular School No Middle 06 08 2020   pk_12_total 281 37 106   0 24     0   21   237 232     15             81   469 281 37 106   0 24     0   21   237 232     15       81   469
2777866 CT     school 900540 180011   Brookfield School District 90054000112 185311 Whisconier Middle School Public Schools Regular School No Middle 05 08 2020   pk_12_total 628 17 111   * 61     *   *   416 413     25             125   829 628 17 111     61             416 413     25       125   829
2777869 CT     school 900570 190011   Brooklyn School District 90057000114 195111 Brooklyn Middle School Public Schools Regular School No Middle 05 08 2020   pk_12_total 268 * 34   0 11     *   20   184 156     *             56   340 268   34   0 11         20   184 156             56   340
2777871 CT     school 900660 220011   Canterbury School District 90066001187 225111 Dr. Helen Baldwin Middle School Public Schools Regular School No Middle 05 08 2020   pk_12_total 165 0 9   * *     0   0   84 93     0             19   177 165 0 9           0   0   84 93     0       19   177
2777873 CT     school 900690 230011   Canton School District 90069000119 230311 Canton Intermediate School Public Schools Regular School No Middle 04 06 2020   pk_12_total 288 30 23   0 12     *   *   169 192     *             44   361 288 30 23   0 12             169 192             44   361
2777874 CT     school 900690 230011   Canton School District 90069001376 235111 Canton Middle School Public Schools Regular School No Middle 07 08 2020   pk_12_total 197 20 24   0 *     0   *   * 125     *             34   250 197 20 24   0       0         125             34   250
2777893 CT     school 900700 2410014   Capitol Region Education Council 90070001625 2415314 Greater Hartford Academy of the Arts Magnet Middle Regional Education Service Center Schools Regular School No Middle 06 08 2020   pk_12_total 63 80 172   0 *     *   17   81 253     21             78   334 63 80 172   0           17   81 253     21       78   334
2777895 CT     school 900700 2410014   Capitol Region Education Council 90070001364 2415014 Two Rivers Magnet Middle School Regional Education Service Center Schools Regular School No Middle 06 08 2020   pk_12_total 120 202 302   * *     0   23   375 291     60             136   666 120 202 302           0   23   375 291     60       136   666
2777910 CT     school 900750 250011   Cheshire School District 90075000125 255111 Dodd Middle School Public Schools Regular School No Middle 07 08 2020   pk_12_total 520 20 34   * 59     0   *   319 332     *             76   651 520 20 34     59     0       319 332             76   651
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
2777920 CT     school 900840 280011   Colchester School District 90084000136 285111 William J. Johnston Middle School Public Schools Regular School No Middle 06 08 2020   pk_12_total 434 * 39   * 16     0   22   259 258     *             79   517 434   39     16     0   22   259 258             79   517
2777936 CT     school 900960 320011   Coventry School District 90096000141 325111 Capt. Nathan Hale School Public Schools Regular School No Middle 06 08 2020   pk_12_total 355 * 23   0 *     0   13   204 196     0             51   400 355   23   0       0   13   204 196     0       51   400
2777941 CT     school 900990 330011   Cromwell School District 90099000147 335111 Cromwell Middle School Public Schools Regular School No Middle 06 08 2020   pk_12_total 314 43 56   * 28     *   10   252 202     10             47   454 314 43 56     28         10   252 202     10       47   454
2777957 CT     school 901020 340011   Danbury School District 90102000149 345111 Broadview Middle School Public Schools Regular School No Middle 06 08 2020   pk_12_total 335 88 484   * 45     0   *   506 483     154             170   989 335 88 484     45     0       506 483     154       170   989
2777958 CT     school 901020 340011   Danbury School District 90102000160 345211 Rogers Park Middle School Public Schools Regular School No Middle 06 08 2020   pk_12_total 297 72 611   0 47     *   *   533 516     366             135   1049 297 72 611   0 47             533 516     366       135   1049
2777959 CT     school 901020 340011   Danbury School District 90102001691 340311 Westside Middle School Academy Public Schools Regular School No Middle 06 08 2020   pk_12_total 325 47 245   0 57     0   17   351 340     56             52   691 325 47 245   0 57     0   17   351 340     56       52   691
2777968 CT     school 901050 350011   Darien School District 90105000169 355111 Middlesex Middle School Public Schools Regular School No Middle 06 08 2020   pk_12_total 979 * 65   * 66     0   33   584 572     6             169   1156 979   65     66     0   33   584 572     6       169   1156
2777973 CT     school 901110 370011   Derby School District 90111001578 375011 Derby Middle School Public Schools Regular School No Middle 06 08 2020   pk_12_total 138 65 128   0 *     *   18   184 177     *             74   361 138 65 128   0           18   184 177             74   361
2777979 CT     school 901170 400011   East Granby School District 90117000182 405111 East Granby Middle School Public Schools Regular School No Middle 06 08 2020   pk_12_total 144 20 *   0 20     0   *   100 99     *             26   199 144 20     0 20     0       100 99             26   199
2777982 CT     school 901200 410011   East Haddam School District 90120000198 415111 Nathan Hale-Ray Middle School Public Schools Regular School No Middle 04 08 2020   pk_12_total 342 * 18   * *     0   9   192 187     *             62   379 342   18           0   9   192 187             62   379
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
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
2778000 CT     school 901260 430011   East Hartford School District 90126001275 432411 Sunset Ridge Middle School Public Schools Regular School No Middle 06 08 2020   pk_12_total 41 94 168   0 13     0   17   165 168     8             48   333 41 94 168   0 13     0   17   165 168     8       48   333
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
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
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
2778026 CT     school 901410 460011   Easton School District 90141000233 465111 Helen Keller Middle School Public Schools Regular School No Middle 06 08 2020   pk_12_total 257 6 26   0 31     0   0   156 164     *             45   320 257 6 26   0 31     0   0   156 164             45   320
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
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
2778077 CT     school 901530 510011   Fairfield School District 90153000258 515211 Fairfield Woods Middle School Public Schools Regular School No Middle 06 08 2020   pk_12_total 669 20 105   0 67     0   42   473 430     15             127   903 669 20 105   0 67     0   42   473 430     15       127   903
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 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
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 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
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 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
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
2778120 CT     school 901710 570011   Greenwich School District 90171000295 575111 Central Middle School Public Schools Regular School No Middle 06 08 2020   pk_12_total 400 11 106   0 30     0   40   304 283     23             71   587 400 11 106   0 30     0   40   304 283     23       71   587
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 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
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
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 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
2778146 CT     school 901800 600011   Guilford School District 90180000328 600711 A. Baldwin Middle School Public Schools Regular School No Middle 05 06 2020   pk_12_total 389 * 31   0 21     *   25   251 221     11             54   472 389   31   0 21         25   251 221     11       54   472
2778147 CT     school 901800 600011   Guilford School District 90180000331 605111 E. C. Adams Middle School Public Schools Regular School No Middle 07 08 2020   pk_12_total 437 * 50   0 27     0   *   294 249     *             69   543 437   50   0 27     0       294 249             69   543
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
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 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
2778217 CT     school 901920 640011   Hartford School District 90192000369 641611 M. L. King, Jr. Middle School Public Schools Regular School No Middle 06 08 2020   pk_12_total * 121 42   0 *     0   *   97 72     17             45   169   121 42   0       0       97 72     17       45   169
2778218 CT     school 901920 640011   Hartford School District 90192000371 641211 McDonough Middle School Public Schools Regular School No Middle 06 08 2020   pk_12_total 11 38 335   0 7     0   0   207 184     165             87   391 11 38 335   0 7     0   0   207 184     165       87   391
2778219 CT     school 901920 640011   Hartford School District 90192000381 641911 Milner Middle School Public Schools Regular School No Middle 06 08 2020   pk_12_total * 117 194   0 0     0   *   155 165     92             62   320   117 194   0 0     0       155 165     92       62   320
2778245 CT     school 902070 690011   Killingly School District 90207000393 695211 Killingly Intermediate School Public Schools Regular School No Middle 05 08 2020   pk_12_total 510 17 70   * 22     *   26   310 338     14             99   648 510 17 70     22         26   310 338     14       99   648
2778253 CT     school 903450 2450014   Learn 90345001556 2455014 Dual Language & Arts Magnet Middle School   Regular School No Middle 06 08 2020   pk_12_total 37 17 76   0 0     0   18   64 84     34             37   148 37 17 76   0 0     0   18   64 84     34       37   148
2778262 CT     school 902130 710011   Lebanon School District 90213000028 715111 Lebanon Middle School Public Schools Regular School No Middle 05 08 2020   pk_12_total 262 6 12   * *     *   *   159 137     *             51   296 262 6 12                   159 137             51   296
2778267 CT     school 902160 720011   Ledyard School District 90216000402 725111 Ledyard Middle School Public Schools Regular School No Middle 06 10 2020   pk_12_total 390 22 54   16 *     *   46   285 259     *             108   544 390 22 54   16           46   285 259             108   544
2778272 CT     school 902220 740011   Litchfield School District 90222000407 740311 Litchfield Intermediate School Public Schools Regular School No Middle 04 06 2020   pk_12_total 174 * 8   0 *     0   *   102 88     0             29   190 174   8   0       0       102 88     0       29   190
2778273 CT     school 902220 740011   Litchfield School District 90222001809 746011 Litchfield Middle School Public Schools Regular School No Middle 07 08 2020   pk_12_total 118 0 *   0 *     *   *   68 63     *             23   131 118 0     0               68 63             23   131
2778279 CT     school 902280 760011   Madison School District 90228001480 765211 Walter C. Polson Middle School Public Schools Regular School No Middle 06 08 2020   pk_12_total 499 * 31   * 18     *   34   318 *     *             89   588 499   31     18         34   318               89   588
2778290 CT     school 902310 770011   Manchester School District 90231001533 771711 Elisabeth M. Bennet Academy Public Schools Regular School No Middle 05 06 2020   pk_12_total 290 231 302   * 64     *   15   465 442     71             157   907 290 231 302     64         15   465 442     71       157   907
2778292 CT     school 902310 770011   Manchester School District 90231000421 775311 Illing Middle School Public Schools Regular School No Middle 06 08 2020   pk_12_total 272 203 257   * 68     *   35   426 411     60             125   837 272 203 257     68         35   426 411     60       125   837
2778301 CT     school 902340 780011   Mansfield School District 90234000433 785111 Mansfield Middle School Public Schools Regular School No Middle 05 08 2020   pk_12_total 375 * 66   * 69     0   26   267 285     11             66   552 375   66     69     0   26   267 285     11       66   552
2778315 CT     school 902400 800011   Meriden School District 90240000447 805211 Lincoln Middle School Public Schools Regular School No Middle 06 08 2020   pk_12_total 204 94 460   * *     0   25   411 388     131             136   799 204 94 460           0   25   411 388     131       136   799
2778320 CT     school 902400 800011   Meriden School District 90240001194 805411 Washington Middle School Public Schools Regular School No Middle 06 08 2020   pk_12_total 266 84 395   * 14     *   24   403 384     66             139   787 266 84 395     14         24   403 384     66       139   787
2778346 CT     school 902490 830011   Middletown School District 90249000456 831511 Keigwin Middle School Public Schools Regular School No Middle 06 06 2020   pk_12_total 159 51 62   * 14     *   28   152 164     14             38   316 159 51 62     14         28   152 164     14       38   316
2778347 CT     school 902490 830011   Middletown School District 90249000459 835411 Woodrow Wilson Middle School Public Schools Regular School No Middle 07 08 2020   pk_12_total 274 149 126   * 19     *   47   313 305     15             78   618 274 149 126     19         47   313 305     15       78   618
2778363 CT     school 902520 840011   Milford School District 90252000484 845111 East Shore Middle School Public Schools Regular School No Middle 06 08 2020   pk_12_total 319 28 29   0 24     0   7   199 208     *             64   407 319 28 29   0 24     0   7   199 208             64   407
2778364 CT     school 902520 840011   Milford School District 90252000468 845211 Harborside Middle School Public Schools Regular School No Middle 06 08 2020   pk_12_total 305 12 51   * 44     0   *   243 181     7             59   424 305 12 51     44     0       243 181     7       59   424
2778365 CT     school 902520 840011   Milford School District 90252000474 845311 West Shore Middle School Public Schools Regular School No Middle 06 08 2020   pk_12_total 295 31 77   * 60     *   *   241 230     9             74   471 295 31 77     60             241 230     9       74   471
2778374 CT     school 902550 850011   Monroe School District 90255000920 855211 Jockey Hollow School Public Schools Regular School No Middle 06 08 2020   pk_12_total 603 17 66   0 43     0   26   387 368     *             105   755 603 17 66   0 43     0   26   387 368             105   755

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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