Data source: Big Local News · About: Big Local

4,354 rows where grade = "pk_12_total" and state = "CT" sorted by ccd_school_lvl descending

View and edit SQL

year

grade

  • pk_12_total · 4,354
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
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
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
2451740 CT     school 900330 110011   Bloomfield School District 90033001565 110811 Wintonbury Early Childhood Magnet School Public Schools Regular School No Prekindergarten PK PK 2019   pk_12_total 115 120 37   * 25     0   *   170 149     0             44   319 115 120 37     25     0       170 149     0       44   319
2451761 CT     school 900450 150011   Bridgeport School District 90045000085 154411 A.B. Skane Center Public Schools Regular School No Prekindergarten PK PK 2019   pk_12_total 41 63 107   0 *     0   *   145 81     0             127   226 41 63 107   0       0       145 81     0       127   226
2451800 CT     school 900510 170011   Bristol School District 90051001774 170411 Bristol Early Childhood Center-BECC Public Schools Special Education School No Prekindergarten PK PK 2019   pk_12_total 66 * 29   0 *     0   8   62 45     0             65   107 66   29   0       0   8   62 45     0       65   107
2451912 CT     school 901020 340011   Danbury School District 90102001634 340111 DPS Early Childhood Center Public Schools Regular School No Prekindergarten PK PK 2019   pk_12_total 49 8 73   * 12     0   *   90 60     0             72   150 49 8 73     12     0       90 60     0       72   150
2451939 CT     school 901110 370011   Derby School District 90111001806 370111 Little Raiders University Public Schools Regular School No Prekindergarten PK PK 2019   pk_12_total 16 10 13   0 0     *   *   31 13     0             15   44 16 10 13   0 0             31 13     0       15   44
2451973 CT     school 901290 440011   East Haven School District 90129001350 441811 Overbrook Early Learning Center Public Schools Regular School No Prekindergarten PK PK 2019   pk_12_total 74 9 55   0 9     0   12   69 90     0             7   159 74 9 55   0 9     0   12   69 90     0       7   159
2452013 CT     school 901470 490011   Enfield School District 90147001915 492211 EPS Integrated Pre-Kindergarten Program Special Education School No Prekindergarten PK PK 2019   pk_12_total 62 * *   0 *     0   *   48 26     0             46   74 62       0       0       48 26     0       46   74
2452014 CT     school 901470 490011   Enfield School District 90147001810 491011 EPS PK STEAM Academy Program Regular School No Prekindergarten PK PK 2019   pk_12_total 31 17 14   0 *     0   *   39 29     0             10   68 31 17 14   0       0       39 29     0       10   68
2452149 CT     school 901920 640011   Hartford School District 90192001643 641311 Hartford PreKindergarten Magnet School Public Schools Regular School No Prekindergarten PK PK 2019   pk_12_total 12 50 23   * 57     0   *   71 80     0             6   151 12 50 23     57     0       71 80     0       6   151
2452526 CT     school 903090 1030011   Norwalk School District 90309001914 1030111 Norwalk Early Childhood Center Public Schools Regular School No Prekindergarten PK PK 2019   pk_12_total 74 14 54   0 15     0   6   100 63     0             104   163 74 14 54   0 15     0   6   100 63     0       104   163
2452544 CT     school 903120 1040011   Norwich School District 90312000663 1040111 Bishop School Early Learning Center Public Schools Regular School No Prekindergarten PK PK 2019   pk_12_total 61 33 54   * 15     0   *   90 85     0             74   175 61 33 54     15     0       90 85     0       74   175
2452651 CT     school 903540 2180012   Regional School District 18 90354000761 2180312 Center School Regional Schools Special Education School No Prekindergarten PK PK 2019   pk_12_total 40 * *   0 0     0   *   26 23     0             13   49 40       0 0     0       26 23     0       13   49
2452722 CT     school 904230 1310011   Southington School District 90423001804 1312111 Southington Public Schools Preschool Program Public Schools Regular School No Prekindergarten PK PK 2019   pk_12_total * * 0   0 0     0   0   9 10     0             11   19     0   0 0     0   0   9 10     0       11   19
2452723 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 2019   pk_12_total 56 * 7   0 *     0   *   52 18     0             46   70 56   7   0       0       52 18     0       46   70
2452778 CT     school 904380 1370011   Stonington School District 90438001637 1370111 Stonington BOE Pre-School   Special Education School No Prekindergarten PK PK 2019   pk_12_total 22 0 *   0 *     0   0   15 11     0             16   26 22 0     0       0   0   15 11     0       16   26
2452779 CT     school 904380 1370011   Stonington School District 90438001635 1370211 Stonington HS PreK   Special Education School No Prekindergarten PK PK 2019   pk_12_total 22 0 *   0 0     0   *   17 9     0             17   26 22 0     0 0     0       17 9     0       17   26
2757321 CT     school 900330 110011   Bloomfield School District 90033001565 110811 Wintonbury Early Childhood Magnet School Public Schools Regular School No Prekindergarten PK PK 2021   pk_12_total 106 113 37   0 35     0   18   139 170     0             37   309 106 113 37   0 35     0   18   139 170     0       37   309
2757342 CT     school 900450 150011   Bridgeport School District 90045000085 154411 A.B. Skane Center Public Schools Regular School No Prekindergarten PK PK 2021   pk_12_total 20 58 117   * 6     0   *   125 80     0             126   205 20 58 117     6     0       125 80     0       126   205
2757381 CT     school 900510 170011   Bristol School District 90051001774 170411 Bristol Early Childhood Center-BECC Public Schools Special Education School No Prekindergarten PK PK 2021   pk_12_total 46 * 38   0 *     0   10   63 33     0             71   96 46   38   0       0   10   63 33     0       71   96
2757494 CT     school 901020 340011   Danbury School District 90102001634 340111 DPS Early Childhood Center Public Schools Regular School No Prekindergarten PK PK 2021   pk_12_total 31 12 80   0 *     0   *   80 54     0             97   134 31 12 80   0       0       80 54     0       97   134
2757521 CT     school 901110 370011   Derby School District 90111001806 370111 Little Raiders University Public Schools Regular School No Prekindergarten PK PK 2021   pk_12_total 18 * 16   0 *     0   *   25 18     0             18   43 18   16   0       0       25 18     0       18   43
2757556 CT     school 901290 440011   East Haven School District 90129001350 441811 Overbrook Early Learning Center Public Schools Regular School No Prekindergarten PK PK 2021   pk_12_total 55 * 36   0 7     0   *   56 51     0             *   107 55   36   0 7     0       56 51     0           107
2757737 CT     school 901920 640011   Hartford School District 90192001643 641311 Hartford PreKindergarten Magnet School Public Schools Regular School No Prekindergarten PK PK 2021   pk_12_total 12 64 37   * 55     0   *   82 98     0             10   180 12 64 37     55     0       82 98     0       10   180
2758105 CT     school 903090 1030011   Norwalk School District 90309001914 1030111 Norwalk Early Childhood Center Public Schools Regular School No Prekindergarten PK PK 2021   pk_12_total 38 16 59   0 *     0   *   78 47     0             82   125 38 16 59   0       0       78 47     0       82   125
2758124 CT     school 903120 1040011   Norwich School District 90312000663 1040111 Bishop School Early Learning Center Public Schools Regular School No Prekindergarten PK PK 2021   pk_12_total 34 25 36   * *     0   12   73 40     0             64   113 34 25 36           0   12   73 40     0       64   113
2758226 CT     school 903540 2180012   Regional School District 18 90354000761 2180312 Center School Regional Schools Special Education School No Prekindergarten PK PK 2021   pk_12_total 85 * *   0 *     0   *   52 43     0             17   95 85       0       0       52 43     0       17   95
2758301 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 2021   pk_12_total 30 0 *   0 *     0   *   23 15     0             25   38 30 0     0       0       23 15     0       25   38
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
2452144 CT     school 901920 640011   Hartford School District 90192001435 646911 Capital Preparatory Magnet School Public Schools Regular School No Other PK 12 2019   pk_12_total 43 323 121   0 11     0   25   263 260     29             62   523 43 323 121   0 11     0   25   263 260     29       62   523
2452151 CT     school 901920 640011   Hartford School District 90192000370 641111 Kinsella Magnet School of Performing Arts Public Schools Regular School No Other PK 12 2019   pk_12_total 177 179 403   * *     0   45   312 521     72             139   833 177 179 403           0   45   312 521     72       139   833
2452171 CT     school 901920 640011   Hartford School District 90192001535 643611 Global Communications Academy Public Schools Regular School No Other KG 12 2019   pk_12_total * 345 238   0 *     0   8   284 315     88             97   599   345 238   0       0   8   284 315     88       97   599
2452211 CT     school 900207 2860013   Highville Charter School District 90020700907 2860113 Highville Charter School Public Charter Schools Regular School Yes Other PK 12 2019   pk_12_total * 477 17   0 0     0   *   227 275     0             26   502   477 17   0 0     0       227 275     0       26   502
2452213 CT     school 900007 2610013   Jumoke Academy District 90000700747 2610113 Jumoke Academy Public Charter Schools Regular School Yes Other PK 12 2019   pk_12_total * 666 38   0 *     0   *   336 381     0             42   717   666 38   0       0       336 381     0       42   717
2452744 CT     school 904260 1330011   Sprague School District 90426000842 1330111 Sayles School Public Schools Regular School No Other PK 12 2019   pk_12_total 217 6 47   * *     *   35   178 135     *             50   313 217 6 47               35   178 135             50   313
2453070 CT     school 900208 2850013   Achievement First Bridgeport Academy District 90020801493 2850113 Achievement First Bridgeport Academy Public Charter Schools Regular School Yes Other KG 12 2019   pk_12_total 13 584 480   * 9     *   *   512 581     131             97   1093 13 584 480     9             512 581     131       97   1093
2453071 CT     school 900212 2880013   Achievement First Hartford Academy District 90021201528 2880113 Achievement First Hartford Academy Public Charter Schools Regular School Yes Other KG 12 2019   pk_12_total * 782 304   * *     *   15   519 593     52             115   1112   782 304               15   519 593     52       115   1112
2453072 CT     school 900024 2790013   Amistad Academy District 90002400981 2795113 Amistad Academy Public Charter Schools Regular School Yes Other KG 12 2019   pk_12_total 19 681 360   * *     0   21   509 574     118             71   1083 19 681 360           0   21   509 574     118       71   1083
2453075 CT     school 900221 2970013   Capital Preparatory Harbor School District 90022101803 2970113 Capital Preparatory Harbor School Public Charter Schools Regular School Yes Other KG 12 2019   pk_12_total * 463 167   * 0     0   *   323 311     *             71   634   463 167     0     0       323 311             71   634
2453080 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 2019   pk_12_total 15 529 197   * *     0   12   371 385     41             60   756 15 529 197           0   12   371 385     41       60   756
2757732 CT     school 901920 640011   Hartford School District 90192001435 646911 Capital Preparatory Magnet School Public Schools Regular School No Other PK 12 2021   pk_12_total 30 426 165   0 11     0   28   337 323     27             94   660 30 426 165   0 11     0   28   337 323     27       94   660
2757739 CT     school 901920 640011   Hartford School District 90192000370 641111 Kinsella Magnet School of Performing Arts Public Schools Regular School No Other PK 12 2021   pk_12_total 104 171 372   * 32     0   *   260 452     76             138   712 104 171 372     32     0       260 452     76       138   712
2757794 CT     school 900207 2860013   Highville Charter School District 90020700907 2860113 Highville Charter School Public Charter Schools Regular School Yes Other PK 12 2021   pk_12_total 6 405 29   * 0     *   *   190 257     *             23   447 6 405 29     0             190 257             23   447
2757796 CT     school 900007 2610013   Jumoke Academy District 90000700747 2610113 Jumoke Academy Public Charter Schools Regular School Yes Other PK 12 2021   pk_12_total * 639 34   * *     0   6   * 358     *             51   686   639 34           0   6     358             51   686
2758646 CT     school 900208 2850013   Achievement First Bridgeport Academy District 90020801493 2850113 Achievement First Bridgeport Academy Public Charter Schools Regular School Yes Other KG 12 2021   pk_12_total 12 597 502   * 9     *   *   527 600     130             106   1127 12 597 502     9             527 600     130       106   1127
2758647 CT     school 900212 2880013   Achievement First Hartford Academy District 90021201528 2880113 Achievement First Hartford Academy Public Charter Schools Regular School Yes Other KG 12 2021   pk_12_total * 840 294   10 *     *   14   * 607     70             115   1164   840 294   10           14     607     70       115   1164
2758648 CT     school 900024 2790013   Amistad Academy District 90002400981 2795113 Amistad Academy Public Charter Schools Regular School Yes Other KG 12 2021   pk_12_total 11 701 396   * *     0   20   506 628     104             101   1134 11 701 396           0   20   506 628     104       101   1134
2758661 CT     school 900221 2970013   Capital Preparatory Harbor School District 90022101803 2970113 Capital Preparatory Harbor School Public Charter Schools Regular School Yes Other KG 12 2021   pk_12_total 8 539 231   * *     0   *   404 381     46             72   785 8 539 231           0       404 381     46       72   785
2758665 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 2021   pk_12_total 23 507 232   * *     0   9   374 400     49             72   774 23 507 232           0   9   374 400     49       72   774
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
2451929 CT     school 901020 340011   Danbury School District 90102001129 346211 Alternative Center For Excellence Program Alternative School No Not reported M M 2019   pk_12_total 30 10 44   * *     0   *   49 42     6             16   91 30 10 44           0       49 42     6       16   91
2451702 CT     school 900060 20011   Ansonia School District 90006010008 25111 Ansonia Middle School Public Schools Regular School No Middle 07 08 2019   pk_12_total 121 64 130   0 *     *   13   173 162     12             72   335 121 64 130   0           13   173 162     12       72   335
2451710 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 2019   pk_12_total 174 94 364   * 37     *   36   348 361     49             82   709 174 94 364     37         36   348 361     49       82   709
2451720 CT     school 900120 40011   Avon School District 90012001367 40511 Thompson Brook School Public Schools Regular School No Middle 05 06 2019   pk_12_total 309 28 44   * 104     0   *   243 266     9             49   509 309 28 44     104     0       243 266     9       49   509
2451721 CT     school 900120 40011   Avon School District 90012000012 45111 Avon Middle School Public Schools Regular School No Middle 07 08 2019   pk_12_total 339 21 34   0 96     0   21   251 260     6             48   511 339 21 34   0 96     0   21   251 260     6       48   511
2451729 CT     school 900210 70011   Berlin School District 90021000017 75111 Catherine M. McGee Middle School Public Schools Regular School No Middle 06 08 2019   pk_12_total 548 * 83   * 19     0   19   361 324     10             100   685 548   83     19     0   19   361 324     10       100   685
2451736 CT     school 900270 90011   Bethel School District 90027000025 95111 Bethel Middle School Public Schools Regular School No Middle 06 08 2019   pk_12_total 501 21 162   * 46     *   11   372 373     28             84   745 501 21 162     46         11   372 373     28       84   745
2451744 CT     school 900330 110011   Bloomfield School District 90033001375 110711 Carmen Arace Intermediate School Public Schools Regular School No Middle 05 06 2019   pk_12_total 8 207 23   0 *     *   6   123 123     *             45   246 8 207 23   0           6   123 123             45   246
2451746 CT     school 900330 110011   Bloomfield School District 90033000034 115211 Carmen Arace Middle School Public Schools Regular School No Middle 07 08 2019   pk_12_total 8 173 25   * *     0   13   127 96     *             45   223 8 173 25           0   13   127 96             45   223
2451757 CT     school 900420 140011   Branford School District 90042000041 145111 Francis Walsh Intermediate School Public Schools Regular School No Middle 05 08 2019   pk_12_total 640 35 102   * 65     0   *   447 424     23             103   871 640 35 102     65     0       447 424     23       103   871
2451819 CT     school 900510 170011   Bristol School District 90051000089 175111 Chippens Hill Middle School Public Schools Regular School No Middle 06 08 2019   pk_12_total 392 57 234   * 26     *   28   363 376     35             111   739 392 57 234     26         28   363 376     35       111   739
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
2451835 CT     school 900540 180011   Brookfield School District 90054000112 185311 Whisconier Middle School Public Schools Regular School No Middle 05 08 2019   pk_12_total 641 26 104   * 70     *   7   432 422     26             133   854 641 26 104     70         7   432 422     26       133   854
2451838 CT     school 900570 190011   Brooklyn School District 90057000114 195111 Brooklyn Middle School Public Schools Regular School No Middle 05 08 2019   pk_12_total 301 * 33   * 9     *   12   185 177     *             54   362 301   33     9         12   185 177             54   362
2451840 CT     school 900660 220011   Canterbury School District 90066001187 225111 Dr. Helen Baldwin Middle School Public Schools Regular School No Middle 05 08 2019   pk_12_total 167 * 8   0 0     0   *   93 86     0             22   179 167   8   0 0     0       93 86     0       22   179
2451842 CT     school 900690 230011   Canton School District 90069000119 230311 Canton Intermediate School Public Schools Regular School No Middle 04 06 2019   pk_12_total 281 31 24   0 10     *   *   176 176     *             40   352 281 31 24   0 10             176 176             40   352
2451843 CT     school 900690 230011   Canton School District 90069001376 235111 Canton Middle School Public Schools Regular School No Middle 07 08 2019   pk_12_total 204 14 25   0 *     0   *   131 124     *             34   255 204 14 25   0       0       131 124             34   255
2451864 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 2019   pk_12_total 86 79 155   0 *     0   *   88 247     16             88   335 86 79 155   0       0       88 247     16       88   335
2451866 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 2019   pk_12_total 142 183 272   * *     0   39   389 277     43             122   666 142 183 272           0   39   389 277     43       122   666
2451879 CT     school 900750 250011   Cheshire School District 90075000125 255111 Dodd Middle School Public Schools Regular School No Middle 07 08 2019   pk_12_total 548 21 40   0 61     0   12   326 356     *             79   682 548 21 40   0 61     0   12   326 356             79   682
2451886 CT     school 900810 270011   Clinton School District 90081000133 275111 Jared Eliot School Public Schools Regular School No Middle 05 08 2019   pk_12_total 349 * 62   * 18     0   6   223 215     16             77   438 349   62     18     0   6   223 215     16       77   438
2451890 CT     school 900840 280011   Colchester School District 90084000136 285111 William J. Johnston Middle School Public Schools Regular School No Middle 06 08 2019   pk_12_total 440 7 36   * 16     *   19   251 269     *             87   520 440 7 36     16         19   251 269             87   520
2451905 CT     school 900960 320011   Coventry School District 90096000141 325111 Capt. Nathan Hale School Public Schools Regular School No Middle 06 08 2019   pk_12_total 326 * 24   * *     0   6   170 193     0             49   363 326   24           0   6   170 193     0       49   363
2451910 CT     school 900990 330011   Cromwell School District 90099000147 335111 Cromwell Middle School Public Schools Regular School No Middle 06 08 2019   pk_12_total 339 41 43   0 43     *   *   257 220     10             41   477 339 41 43   0 43             257 220     10       41   477
2451926 CT     school 901020 340011   Danbury School District 90102000149 345111 Broadview Middle School Public Schools Regular School No Middle 06 08 2019   pk_12_total 331 72 479   * 56     0   *   480 497     130             170   977 331 72 479     56     0       480 497     130       170   977
2451927 CT     school 901020 340011   Danbury School District 90102000160 345211 Rogers Park Middle School Public Schools Regular School No Middle 06 08 2019   pk_12_total 253 68 579   0 53     *   *   499 480     267             139   979 253 68 579   0 53             499 480     267       139   979
2451928 CT     school 901020 340011   Danbury School District 90102001691 340311 Westside Middle School Academy Public Schools Regular School No Middle 06 08 2019   pk_12_total 283 40 242   * 53     0   *   329 310     42             52   639 283 40 242     53     0       329 310     42       52   639
2451937 CT     school 901050 350011   Darien School District 90105000169 355111 Middlesex Middle School Public Schools Regular School No Middle 06 08 2019   pk_12_total 947 * 61   * 57     0   27   552 549     *             152   1101 947   61     57     0   27   552 549             152   1101
2451942 CT     school 901110 370011   Derby School District 90111001578 375011 Derby Middle School Public Schools Regular School No Middle 06 08 2019   pk_12_total 147 56 109   0 *     *   18   167 174     6             69   341 147 56 109   0           18   167 174     6       69   341
2451947 CT     school 901170 400011   East Granby School District 90117000182 405111 East Granby Middle School Public Schools Regular School No Middle 06 08 2019   pk_12_total 155 16 *   0 16     0   *   107 94     0             29   201 155 16     0 16     0       107 94     0       29   201
2451950 CT     school 901200 410011   East Haddam School District 90120000198 415111 Nathan Hale-Ray Middle School Public Schools Regular School No Middle 04 08 2019   pk_12_total 327 * 16   * 6     0   *   188 172     0             51   360 327   16     6     0       188 172     0       51   360

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]);