Data source: Big Local News · About: Big Local

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

View and edit SQL

year

grade

  • pk_12_total · 4,254
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
2758189 CT     school 903520 2100012   Regional School District 10 90352000728 2100312 Harwinton Consolidated School Regional Schools Regular School No Elementary PK 04 2021   pk_12_total 286 * *   0 0     0   54   180 177     *             49   357 286       0 0     0   54   180 177             49   357
2758190 CT     school 903520 2100012   Regional School District 10 90352000729 2100212 Lake Garda Elementary School Regional Schools Regular School No Elementary PK 04 2021   pk_12_total 301 * 19   0 *     0   83   222 187     24             45   409 301   19   0       0   83   222 187     24       45   409
2758191 CT     school 903520 2100012   Regional School District 10 90352000727 2105112 Har-Bur Middle School Regional Schools Regular School No Middle 05 08 2021   pk_12_total 562 * 29   0 *     0   114   375 335     6             96   710 562   29   0       0   114   375 335     6       96   710
2758192 CT     school 903520 2100012   Regional School District 10 90352000730 2106112 Lewis S. Mills High School Regional Schools Regular School No High 09 12 2021   pk_12_total 524 * 34   0 *     0   133   368 335     *             69   703 524   34   0       0   133   368 335             69   703
2758193 CT     school 903530 2120012   Regional School District 12 90353000735 2120412 Washington Primary School Regional Schools Regular School No Elementary PK 05 2021   pk_12_total 96 0 *   0 0     0   *   49 66     *             14   115 96 0     0 0     0       49 66             14   115
2758194 CT     school 903530 2120012   Regional School District 12 90353000731 2120212 Booth Free School Regional Schools Regular School No Elementary KG 05 2021   pk_12_total 64 0 *   0 *     0   6   35 38     *             11   73 64 0     0       0   6   35 38             11   73
2758195 CT     school 903530 2120012   Regional School District 12 90353000734 2120112 The Burnham School Regional Schools Regular School No Elementary KG 05 2021   pk_12_total 53 0 *   0 0     0   *   31 28     0             6   59 53 0     0 0     0       31 28     0       6   59
2758196 CT     school 903530 2120012   Regional School District 12 90353001632 2120312 Shepaug Valley School Regional Schools Regular School No High 06 12 2021   pk_12_total 379 * 40   0 *     0   7   206 228     *             65   434 379   40   0       0   7   206 228             65   434
2758198 CT     school 903535 2130012   Regional School District 13 90353500740 2130112 Frederick Brewster School Regional Schools Regular School No Elementary PK 02 2021   pk_12_total 206 0 9   * *     0   *   109 112     *             41   221 206 0 9           0       109 112             41   221
2758199 CT     school 903535 2130012   Regional School District 13 90353500741 2130512 John Lyman School Regional Schools Regular School No Elementary KG 04 2021   pk_12_total 171 0 20   0 0     0   6   98 99     *             25   197 171 0 20   0 0     0   6   98 99             25   197
2758200 CT     school 903535 2130012   Regional School District 13 90353500742 2130412 Middlefield Memorial School Regional Schools Regular School No Elementary 03 05 2021   pk_12_total 194 0 12   0 *     0   *   114 102     *             52   216 194 0 12   0       0       114 102             52   216
2758201 CT     school 903535 2130012   Regional School District 13 90353500739 2135112 Frank Ward Strong School Regional Schools Regular School No Middle 06 08 2021   pk_12_total 291 * 32   0 *     0   9   160 182     *             69   342 291   32   0       0   9   160 182             69   342
2758202 CT     school 903535 2130012   Regional School District 13 90353500737 2136112 Coginchaug Regional High School Regional Schools Regular School No High 08 12 2021   pk_12_total 395 * 25   0 *     0   13   217 230     0             72   447 395   25   0       0   13   217 230     0       72   447
2758204 CT     school 903536 2140012   Regional School District 14 90353600743 2140112 Bethlehem Elementary School Regional Schools Regular School No Elementary PK 05 2021   pk_12_total 242 * 18   * *     0   11   144 136     *             57   280 242   18           0   11   144 136             57   280
2758205 CT     school 903536 2140012   Regional School District 14 90353600744 2140212 Mitchell Elementary School Regional Schools Regular School No Elementary PK 05 2021   pk_12_total 263 * 32   0 *     0   16   160 163     10             40   323 263   32   0       0   16   160 163     10       40   323
2758206 CT     school 903536 2140012   Regional School District 14 90353600746 2145112 Woodbury Middle School Regional Schools Regular School No Middle 06 08 2021   pk_12_total 259 * 28   * *     0   *   148 148     *             49   296 259   28           0       148 148             49   296
2758207 CT     school 903536 2140012   Regional School District 14 90353600745 2146112 Nonnewaug High School Regional Schools Regular School No High 09 12 2021   pk_12_total 602 * 44   * 10     0   9   296 380     *             97   676 602   44     10     0   9   296 380             97   676
2758208 CT     school 903537 2150012   Regional School District 15 90353700708 2150712 Long Meadow Elementary School Regional Schools Regular School No Elementary PK 05 2021   pk_12_total 400 14 30   0 29     0   24   265 232     7             112   497 400 14 30   0 29     0   24   265 232     7       112   497
2758209 CT     school 903537 2150012   Regional School District 15 90353701116 2150412 Gainfield Elementary School Regional Schools Regular School No Elementary KG 05 2021   pk_12_total 294 * 29   * 11     0   10   173 181     6             47   354 294   29     11     0   10   173 181     6       47   354
2758210 CT     school 903537 2150012   Regional School District 15 90353701200 2150612 Middlebury Elementary School Regional Schools Regular School No Elementary KG 05 2021   pk_12_total 264 * 20   0 20     0   *   158 151     20             48   309 264   20   0 20     0       158 151     20       48   309
2758211 CT     school 903537 2150012   Regional School District 15 90353700750 2150512 Pomperaug School Regional Schools Regular School No Elementary KG 05 2021   pk_12_total 302 7 32   0 16     0   12   219 150     7             63   369 302 7 32   0 16     0   12   219 150     7       63   369
2758212 CT     school 903537 2150012   Regional School District 15 90353700748 2155212 Memorial Middle School Regional Schools Regular School No Middle 06 08 2021   pk_12_total 365 * 20   0 28     *   10   225 208     *             76   433 365   20   0 28         10   225 208             76   433
2758213 CT     school 903537 2150012   Regional School District 15 90353700751 2155112 Rochambeau Middle School Regional Schools Regular School No Middle 06 08 2021   pk_12_total 302 * 30   * 17     0   16   191 184     *             76   375 302   30     17     0   16   191 184             76   375
2758214 CT     school 903537 2150012   Regional School District 15 90353700749 2156212 Pomperaug Regional High School Regional Schools Regular School No High 09 12 2021   pk_12_total 966 21 69   * 57     *   26   565 580     *             192   1145 966 21 69     57         26   565 580             192   1145
2758216 CT     school 903538 2160012   Regional School District 16 90353801811 2160512 Prospect Elementary School Regional Schools Regular School No Elementary PK 05 2021   pk_12_total 532 20 18   * 12     0   *   319 274     21             77   593 532 20 18     12     0       319 274     21       77   593
2758217 CT     school 903538 2160012   Regional School District 16 90353800755 2160112 Laurel Ledge School Regional Schools Regular School No Elementary KG 05 2021   pk_12_total 192 * 41   0 9     *   8   128 131     9             27   259 192   41   0 9         8   128 131     9       27   259
2758218 CT     school 903538 2160012   Regional School District 16 90353800756 2165112 Long River Middle School Regional Schools Regular School No Middle 06 08 2021   pk_12_total 415 20 40   0 *     *   12   227 265     *             62   492 415 20 40   0           12   227 265             62   492
2758219 CT     school 903538 2160012   Regional School District 16 90353801356 2166012 Woodland Regional High School Regional Schools Regular School No High 09 12 2021   pk_12_total 564 28 41   * *     0   6   325 319     *             85   644 564 28 41           0   6   325 319             85   644
2758221 CT     school 903539 2170012   Regional School District 17 90353900760 2170312 Killingworth Elementary School Regional Schools Regular School No Elementary PK 03 2021   pk_12_total 216 * 9   * 0     0   9   113 124     *             59   237 216   9     0     0   9   113 124             59   237
2758222 CT     school 903539 2170012   Regional School District 17 90353900757 2170212 Burr District Elementary School Regional Schools Regular School No Elementary KG 03 2021   pk_12_total 267 * 13   0 *     0   6   142 153     *             38   295 267   13   0       0   6   142 153             38   295
2758223 CT     school 903539 2170012   Regional School District 17 90353901921 2170512 Haddam-Killingworth Intermediate School Regional Schools Regular School No Elementary 04 05 2021   pk_12_total 221 * 16   0 *     0   7   136 115     *             43   251 221   16   0       0   7   136 115             43   251
2758224 CT     school 903539 2170012   Regional School District 17 90353901201 2175112 Haddam-Killingworth Middle School Regional Schools Regular School No Middle 06 08 2021   pk_12_total 393 * 14   0 *     0   13   240 193     *             77   433 393   14   0       0   13   240 193             77   433
2758225 CT     school 903539 2170012   Regional School District 17 90353900759 2176112 Haddam-Killingworth High School Regional Schools Regular School No High 09 12 2021   pk_12_total 559 * 22   0 *     0   16   * 308     *             82   616 559   22   0       0   16     308             82   616
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
2758227 CT     school 903540 2180012   Regional School District 18 90354000762 2180112 Lyme Consolidated School Regional Schools Regular School No Elementary KG 05 2021   pk_12_total 170 * 12   0 *     0   10   105 91     6             23   196 170   12   0       0   10   105 91     6       23   196
2758228 CT     school 903540 2180012   Regional School District 18 90354000764 2180212 Mile Creek School Regional Schools Regular School No Elementary KG 05 2021   pk_12_total 234 * 15   0 *     0   12   143 127     9             33   270 234   15   0       0   12   143 127     9       33   270
2758229 CT     school 903540 2180012   Regional School District 18 90354001123 2185112 Lyme-Old Lyme Middle School Regional Schools Regular School No Middle 06 08 2021   pk_12_total 229 * 18   0 12     0   *   136 134     *             53   270 229   18   0 12     0       136 134             53   270
2758230 CT     school 903540 2180012   Regional School District 18 90354000763 2186112 Lyme-Old Lyme High School Regional Schools Regular School No High 09 12 2021   pk_12_total 402 * 25   0 12     0   *   220 230     6             44   450 402   25   0 12     0       220 230     6       44   450
2758669 CT     school 903600 2010012   Regional School District 01 90360000766 2016112 Housatonic Valley Regional High School Regional Schools Regular School No High 09 12 2021   pk_12_total 254 * 40   0 *     0   12   * 163     *             51   316 254   40   0       0   12     163             51   316
2758675 CT     school 903630 2040012   Regional School District 04 90363000767 2045112 John Winthrop Middle School Regional Schools Regular School No Middle 07 08 2021   pk_12_total 205 * 23   0 *     0   8   128 113     *             46   241 205   23   0       0   8   128 113             46   241
2758676 CT     school 903630 2040012   Regional School District 04 90363000768 2046112 Valley Regional High School Regional Schools Regular School No High 09 12 2021   pk_12_total 524 * 21   * 10     0   17   * 300     *             105   577 524   21     10     0   17     300             105   577
2758678 CT     school 903660 2050012   Regional School District 05 90366001114 2055112 Amity Middle School: Bethany Regional Schools Regular School No Middle 07 08 2021   pk_12_total 243 * 38   0 54     0   *   184 173     *             34   357 243   38   0 54     0       184 173             34   357
2758679 CT     school 903660 2050012   Regional School District 05 90366000769 2055212 Amity Middle School: Orange Regional Schools Regular School No Middle 07 08 2021   pk_12_total 251 11 27   * 53     0   *   193 157     *             41   350 251 11 27     53     0       193 157             41   350
2758680 CT     school 903660 2050012   Regional School District 05 90366000770 2056112 Amity Regional High School Regional Schools Regular School No High 09 12 2021   pk_12_total 1064 49 *   * 221     0   60   724 720     10             168   1444 1064 49       221     0   60   724 720     10       168   1444
2758683 CT     school 903720 2070012   Regional School District 07 90372001226 2075112 Northwestern Regional Middle School Regional Schools Regular School No Middle 07 08 2021   pk_12_total 267 * 6   0 *     0   *   141 139     0             46   280 267   6   0       0       141 139     0       46   280
2758686 CT     school 903720 2070012   Regional School District 07 90372000771 2076112 Northwestern Regional High School Regional Schools Regular School No High 09 12 2021   pk_12_total 584 * 19   0 6     *   12   287 337     *             73   624 584   19   0 6         12   287 337             73   624
2758689 CT     school 903750 2080012   Regional School District 08 90375001210 2085112 RHAM Middle School Regional Schools Regular School No Middle 07 08 2021   pk_12_total 336 * 36   0 *     0   10   201 *     *             55   390 336   36   0       0   10   201               55   390
2758690 CT     school 903750 2080012   Regional School District 08 90375000772 2086112 RHAM High School Regional Schools Regular School No High 09 12 2021   pk_12_total 808 8 49   * 20     *   *   456 *     *             111   889 808 8 49     20             456               111   889
2758691 CT     school 903570 2110012   Regional School District 11 90357000765 2116112 Parish Hill High School Regional Schools Regular School No High 07 12 2021   pk_12_total 176 * *   0 0     0   12   112 89     *             36   201 176       0 0     0   12   112 89             36   201
2758727 CT     school 903780 2090012   Regional School District 09 90378000773 2096112 Joel Barlow High School Regional Schools Regular School No High 09 12 2021   pk_12_total 680 9 58   0 35     0   45   414 413     *             105   827 680 9 58   0 35     0   45   414 413             105   827
2758728 CT     school 900005 2190012   Regional School District 19 90000501215 2196112 E. O. Smith High School Regional Schools Regular School No High 09 12 2021   pk_12_total 794 * 114   0 43     *   95   487 576     7             153   1063 794   114   0 43         95   487 576     7       153   1063
2778629 CT     school 903515 2060012   Regional School District 06 90351500723 2060112 Goshen Center School Regional Schools Regular School No Elementary PK 06 2020   pk_12_total 172 * 6   0 *     0   11   94 98     6             28   192 172   6   0       0   11   94 98     6       28   192
2778630 CT     school 903515 2060012   Regional School District 06 90351500724 2060212 James Morris School Regional Schools Regular School No Elementary PK 06 2020   pk_12_total 111 * 9   0 0     0   *   63 *     *             29   126 111   9   0 0     0       63               29   126
2778631 CT     school 903515 2060012   Regional School District 06 90351500726 2060312 Warren Elementary School Regional Schools Regular School No Elementary PK 06 2020   pk_12_total 78 0 *   0 *     0   *   50 34     0             7   84 78 0     0       0       50 34     0       7   84
2778632 CT     school 903515 2060012   Regional School District 06 90351500725 2066112 Wamogo Regional High School Regional Schools Regular School No High 07 12 2020   pk_12_total 461 7 20   * *     *   9   215 293     *             86   508 461 7 20               9   215 293             86   508
2778634 CT     school 903520 2100012   Regional School District 10 90352000728 2100312 Harwinton Consolidated School Regional Schools Regular School No Elementary PK 04 2020   pk_12_total 308 * *   0 0     0   30   180 177     *             50   357 308       0 0     0   30   180 177             50   357
2778635 CT     school 903520 2100012   Regional School District 10 90352000729 2100212 Lake Garda Elementary School Regional Schools Regular School No Elementary PK 04 2020   pk_12_total 356 * 19   0 *     0   49   232 202     24             55   434 356   19   0       0   49   232 202     24       55   434
2778636 CT     school 903520 2100012   Regional School District 10 90352000727 2105112 Har-Bur Middle School Regional Schools Regular School No Middle 05 08 2020   pk_12_total 628 * 27   * 8     0   47   391 325     *             102   716 628   27     8     0   47   391 325             102   716
2778637 CT     school 903520 2100012   Regional School District 10 90352000730 2106112 Lewis S. Mills High School Regional Schools Regular School No High 09 12 2020   pk_12_total 598 7 38   0 10     0   65   358 360     *             74   718 598 7 38   0 10     0   65   358 360             74   718
2778638 CT     school 903530 2120012   Regional School District 12 90353000735 2120412 Washington Primary School Regional Schools Regular School No Elementary PK 05 2020   pk_12_total 119 0 *   0 0     0   *   55 83     *             11   138 119 0     0 0     0       55 83             11   138
2778639 CT     school 903530 2120012   Regional School District 12 90353000731 2120212 Booth Free School Regional Schools Regular School No Elementary KG 05 2020   pk_12_total 65 * *   0 *     0   *   32 39     *             10   71 65       0       0       32 39             10   71
2778640 CT     school 903530 2120012   Regional School District 12 90353000734 2120112 The Burnham School Regional Schools Regular School No Elementary KG 05 2020   pk_12_total 54 0 *   0 *     0   *   31 29     0             6   60 54 0     0       0       31 29     0       6   60
2778641 CT     school 903530 2120012   Regional School District 12 90353001632 2120312 Shepaug Valley School Regional Schools Regular School No High 06 12 2020   pk_12_total 381 * 34   0 *     0   6   213 219     *             68   432 381   34   0       0   6   213 219             68   432
2778643 CT     school 903535 2130012   Regional School District 13 90353500740 2130112 Frederick Brewster School Regional Schools Regular School No Elementary PK 03 2020   pk_12_total 261 0 13   * *     0   6   140 143     *             52   283 261 0 13           0   6   140 143             52   283
2778644 CT     school 903535 2130012   Regional School District 13 90353500741 2130512 John Lyman School Regional Schools Regular School No Elementary KG 04 2020   pk_12_total 187 0 16   0 *     0   *   108 106     *             39   214 187 0 16   0       0       108 106             39   214
2778645 CT     school 903535 2130012   Regional School District 13 90353500742 2130412 Middlefield Memorial School Regional Schools Regular School No Middle 04 06 2020   pk_12_total 222 * 22   0 *     0   8   119 140     *             49   259 222   22   0       0   8   119 140             49   259
2778646 CT     school 903535 2130012   Regional School District 13 90353500739 2135112 Frank Ward Strong School Regional Schools Regular School No Middle 05 08 2020   pk_12_total 216 * 21   0 *     0   12   121 134     *             50   255 216   21   0       0   12   121 134             50   255
2778647 CT     school 903535 2130012   Regional School District 13 90353500737 2136112 Coginchaug Regional High School Regional Schools Regular School No High 09 12 2020   pk_12_total 433 * 27   0 12     0   *   245 *     0             71   484 433   27   0 12     0       245       0       71   484
2778649 CT     school 903536 2140012   Regional School District 14 90353600743 2140112 Bethlehem Elementary School Regional Schools Regular School No Elementary PK 05 2020   pk_12_total 249 * 10   * *     0   6   141 131     *             44   272 249   10           0   6   141 131             44   272
2778650 CT     school 903536 2140012   Regional School District 14 90353600744 2140212 Mitchell Elementary School Regional Schools Regular School No Elementary PK 05 2020   pk_12_total 280 * 30   0 *     0   13   169 166     10             48   335 280   30   0       0   13   169 166     10       48   335
2778651 CT     school 903536 2140012   Regional School District 14 90353600746 2145112 Woodbury Middle School Regional Schools Regular School No Middle 06 08 2020   pk_12_total 279 * 21   * 7     0   *   151 162     *             56   313 279   21     7     0       151 162             56   313
2778652 CT     school 903536 2140012   Regional School District 14 90353600745 2146112 Nonnewaug High School Regional Schools Regular School No High 09 12 2020   pk_12_total 603 7 34   * 11     0   *   284 379     *             96   663 603 7 34     11     0       284 379             96   663
2778654 CT     school 903537 2150012   Regional School District 15 90353700708 2150712 Long Meadow Elementary School Regional Schools Regular School No Elementary PK 05 2020   pk_12_total 442 14 28   0 28     0   20   280 252     *             109   532 442 14 28   0 28     0   20   280 252             109   532
2778655 CT     school 903537 2150012   Regional School District 15 90353701116 2150412 Gainfield Elementary School Regional Schools Regular School No Elementary KG 05 2020   pk_12_total 297 * 24   * 19     0   9   169 187     8             41   356 297   24     19     0   9   169 187     8       41   356
2778656 CT     school 903537 2150012   Regional School District 15 90353701200 2150612 Middlebury Elementary School Regional Schools Regular School No Elementary KG 05 2020   pk_12_total 285 * 20   0 20     0   *   174 157     18             48   331 285   20   0 20     0       174 157     18       48   331
2778657 CT     school 903537 2150012   Regional School District 15 90353700750 2150512 Pomperaug School Regional Schools Regular School No Elementary KG 05 2020   pk_12_total 305 8 33   0 14     0   11   218 153     *             63   371 305 8 33   0 14     0   11   218 153             63   371
2778658 CT     school 903537 2150012   Regional School District 15 90353700748 2155212 Memorial Middle School Regional Schools Regular School No Middle 06 08 2020   pk_12_total 380 * 20   0 24     *   13   226 221     *             76   447 380   20   0 24         13   226 221             76   447
2778659 CT     school 903537 2150012   Regional School District 15 90353700751 2155112 Rochambeau Middle School Regional Schools Regular School No Middle 06 08 2020   pk_12_total 331 * 22   * 20     0   12   201 196     *             80   397 331   22     20     0   12   201 196             80   397
2778660 CT     school 903537 2150012   Regional School District 15 90353700749 2156212 Pomperaug Regional High School Regional Schools Regular School No High 09 12 2020   pk_12_total 1028 15 71   * 65     *   21   607 601     6             197   1208 1028 15 71     65         21   607 601     6       197   1208
2778662 CT     school 903538 2160012   Regional School District 16 90353801811 2160512 Prospect Elementary School Regional Schools Regular School No Elementary PK 05 2020   pk_12_total 537 18 *   0 *     0   21   306 289     9             69   595 537 18     0       0   21   306 289     9       69   595
2778663 CT     school 903538 2160012   Regional School District 16 90353800755 2160112 Laurel Ledge School Regional Schools Regular School No Elementary KG 05 2020   pk_12_total 220 8 35   0 6     0   10   139 140     10             33   279 220 8 35   0 6     0   10   139 140     10       33   279
2778664 CT     school 903538 2160012   Regional School District 16 90353800756 2165112 Long River Middle School Regional Schools Regular School No Middle 06 08 2020   pk_12_total 447 16 40   0 *     0   *   256 257     *             70   513 447 16 40   0       0       256 257             70   513
2778666 CT     school 903538 2160012   Regional School District 16 90353801356 2166012 Woodland Regional High School Regional Schools Regular School No High 09 12 2020   pk_12_total 590 28 48   * 10     0   *   350 331     *             86   681 590 28 48     10     0       350 331             86   681
2778667 CT     school 903539 2170012   Regional School District 17 90353900757 2170212 Burr District Elementary School Regional Schools Regular School No Elementary PK 03 2020   pk_12_total 327 * 12   0 *     0   11   185 177     *             71   362 327   12   0       0   11   185 177             71   362
2778668 CT     school 903539 2170012   Regional School District 17 90353900760 2170312 Killingworth Elementary School Regional Schools Regular School No Elementary KG 03 2020   pk_12_total 191 0 6   0 0     0   7   89 115     *             34   204 191 0 6   0 0     0   7   89 115             34   204
2778669 CT     school 903539 2170012   Regional School District 17 90353901921 2170512 Haddam-Killingworth Intermediate School Regional Schools Regular School No Elementary 04 05 2020   pk_12_total 235 * 16   0 *     0   *   142 119     *             45   261 235   16   0       0       142 119             45   261
2778670 CT     school 903539 2170012   Regional School District 17 90353901201 2175112 Haddam-Killingworth Middle School Regional Schools Regular School No Middle 06 08 2020   pk_12_total 430 * 14   0 *     0   17   255 221     *             82   476 430   14   0       0   17   255 221             82   476
2778671 CT     school 903539 2170012   Regional School District 17 90353900759 2176112 Haddam-Killingworth High School Regional Schools Regular School No High 09 12 2020   pk_12_total 590 7 15   0 11     0   14   326 311     *             92   637 590 7 15   0 11     0   14   326 311             92   637
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
2778674 CT     school 903540 2180012   Regional School District 18 90354000762 2180112 Lyme Consolidated School Regional Schools Regular School No Elementary KG 05 2020   pk_12_total 173 0 13   0 *     *   11   117 85     8             27   202 173 0 13   0           11   117 85     8       27   202
2778675 CT     school 903540 2180012   Regional School District 18 90354000764 2180212 Mile Creek School Regional Schools Regular School No Elementary KG 05 2020   pk_12_total 219 * 15   0 *     0   12   132 125     9             38   257 219   15   0       0   12   132 125     9       38   257
2778676 CT     school 903540 2180012   Regional School District 18 90354001123 2185112 Lyme-Old Lyme Middle School Regional Schools Regular School No Middle 06 08 2020   pk_12_total 240 * 16   0 9     0   *   128 150     6             52   278 240   16   0 9     0       128 150     6       52   278
2778677 CT     school 903540 2180012   Regional School District 18 90354000763 2186112 Lyme-Old Lyme High School Regional Schools Regular School No High 09 12 2020   pk_12_total 428 * 29   0 12     0   *   245 234     7             44   479 428   29   0 12     0       245 234     7       44   479
2779118 CT     school 903600 2010012   Regional School District 01 90360000766 2016112 Housatonic Valley Regional High School Regional Schools Regular School No High 09 12 2020   pk_12_total 279 * 53   0 *     0   15   181 175     6             56   356 279   53   0       0   15   181 175     6       56   356
2779124 CT     school 903630 2040012   Regional School District 04 90363000767 2045112 John Winthrop Middle School Regional Schools Regular School No Middle 07 08 2020   pk_12_total 220 * 24   0 *     0   9   133 124     *             52   257 220   24   0       0   9   133 124             52   257
2779125 CT     school 903630 2040012   Regional School District 04 90363000768 2046112 Valley Regional High School Regional Schools Regular School No High 09 12 2020   pk_12_total 528 * 19   * 15     0   15   281 302     6             86   583 528   19     15     0   15   281 302     6       86   583
2779127 CT     school 903660 2050012   Regional School District 05 90366001114 2055112 Amity Middle School: Bethany Regional Schools Regular School No Middle 07 08 2020   pk_12_total 240 12 19   0 54     0   15   174 166     *             47   340 240 12 19   0 54     0   15   174 166             47   340
2779128 CT     school 903660 2050012   Regional School District 05 90366000769 2055212 Amity Middle School: Orange Regional Schools Regular School No Middle 07 08 2020   pk_12_total 278 6 17   0 51     0   13   195 170     *             39   365 278 6 17   0 51     0   13   195 170             39   365
2779129 CT     school 903660 2050012   Regional School District 05 90366000770 2056112 Amity Regional High School Regional Schools Regular School No High 09 12 2020   pk_12_total 1087 54 28   * 219     *   61   723 732     10             176   1455 1087 54 28     219         61   723 732     10       176   1455
2779132 CT     school 903720 2070012   Regional School District 07 90372001226 2075112 Northwestern Regional Middle School Regional Schools Regular School No Middle 07 08 2020   pk_12_total 281 0 7   0 *     0   *   152 146     0             47   298 281 0 7   0       0       152 146     0       47   298

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