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,154
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
2452710 CT     school 904140 1290011   Somers School District 90414000818 1295111 Mabelle B. Avery Middle School Public Schools Regular School No Middle 06 08 2019   pk_12_total 308 * 13   0 6     0   *   164 172     *             44   336 308   13   0 6     0       164 172             44   336
2452718 CT     school 904170 1320011   South Windsor School District 90417000827 1325111 Timothy Edwards School Public Schools Regular School No Middle 06 08 2019   pk_12_total 563 62 80   0 220     *   *   499 482     14             124   981 563 62 80   0 220             499 482     14       124   981
2452735 CT     school 904230 1310011   Southington School District 90423000832 1315311 John F. Kennedy Middle School Public Schools Regular School No Middle 06 08 2019   pk_12_total 637 * 58   * 22     0   23   363 401     6             97   764 637   58     22     0   23   363 401     6       97   764
2452737 CT     school 904230 1310011   Southington School District 90423000833 1315111 Joseph A. Depaolo Middle School Public Schools Regular School No Middle 06 08 2019   pk_12_total 609 21 63   * 24     *   21   398 343     6             116   741 609 21 63     24         21   398 343     6       116   741
2452748 CT     school 904290 1340011   Stafford School District 90429000061 1345211 Stafford Middle School Public Schools Regular School No Middle 06 08 2019   pk_12_total 306 7 21   * *     0   11   185 164     0             48   349 306 7 21           0   11   185 164     0       48   349
2452767 CT     school 904320 1350011   Stamford School District 90432000851 1355611 Cloonan School Public Schools Regular School No Middle 06 08 2019   pk_12_total 173 129 265   * 41     *   20   352 280     81             100   632 173 129 265     41         20   352 280     81       100   632
2452768 CT     school 904320 1350011   Stamford School District 90432000853 1355311 Dolan School Public Schools Regular School No Middle 06 08 2019   pk_12_total 203 107 253   * 26     *   12   303 301     83             107   604 203 107 253     26         12   303 301     83       107   604
2452769 CT     school 904320 1350011   Stamford School District 90432001353 1355811 Rippowam Middle School Public Schools Regular School No Middle 06 08 2019   pk_12_total 222 153 317   * 37     *   19   385 366     87             116   751 222 153 317     37         19   385 366     87       116   751
2452770 CT     school 904320 1350011   Stamford School District 90432000009 1355711 Scofield Middle School Public Schools Regular School No Middle 06 08 2019   pk_12_total 224 74 251   0 89     0   8   325 321     24             41   646 224 74 251   0 89     0   8   325 321     24       41   646
2452771 CT     school 904320 1350011   Stamford School District 90432000870 1355511 Turn of River School Public Schools Regular School No Middle 06 08 2019   pk_12_total 197 100 268   0 61     0   27   339 314     122             88   653 197 100 268   0 61     0   27   339 314     122       88   653
2452783 CT     school 904380 1370011   Stonington School District 90438000879 1375111 Pawcatuck Middle School   Regular School No Middle 05 08 2019   pk_12_total 244 * 24   * *     0   8   158 124     0             55   282 244   24           0   8   158 124     0       55   282
2452784 CT     school 904380 1370011   Stonington School District 90438000877 1375211 Stonington Middle School Public Schools Regular School No Middle 05 08 2019   pk_12_total 312 * 21   0 *     0   9   169 182     *             51   351 312   21   0       0   9   169 182             51   351
2452800 CT     school 904440 1380011   Stratford School District 90444000900 1385211 David Wooster Middle School Public Schools Regular School No Middle 07 08 2019   pk_12_total 207 114 177   0 10     0   16   246 278     7             58   524 207 114 177   0 10     0   16   246 278     7       58   524
2452801 CT     school 904440 1380011   Stratford School District 90444000888 1385311 Harry B. Flood Middle School Public Schools Regular School No Middle 07 08 2019   pk_12_total 200 128 198   0 22     0   20   265 303     30             70   568 200 128 198   0 22     0   20   265 303     30       70   568
2452812 CT     school 904470 1390011   Suffield School District 90447000902 1395111 Suffield Middle School Public Schools Regular School No Middle 06 08 2019   pk_12_total 397 19 33   * 19     0   *   220 256     6             59   476 397 19 33     19     0       220 256     6       59   476
2452815 CT     school 904500 1400011   Thomaston School District 90450001117 1400211 Thomaston Center School Public Schools Regular School No Middle 04 06 2019   pk_12_total 178 0 6   0 0     *   *   90 99     *             29   189 178 0 6   0 0             90 99             29   189
2452819 CT     school 904530 1410011   Thompson School District 90453000910 1415111 Thompson Middle School Public Schools Regular School No Middle 05 08 2019   pk_12_total 281 * 27   0 *     0   11   183 140     *             33   323 281   27   0       0   11   183 140             33   323
2452823 CT     school 904560 1420011   Tolland School District 90456000915 1425111 Tolland Middle School Public Schools Regular School No Middle 06 08 2019   pk_12_total 490 17 26   * 30     *   *   297 273     *             84   570 490 17 26     30             297 273             84   570
2452833 CT     school 904590 1430011   Torrington School District 90459000925 1435111 Torrington Middle School Public Schools Regular School No Middle 06 08 2019   pk_12_total 601 42 259   * 42     *   37   516 469     64             185   985 601 42 259     42         37   516 469     64       185   985
2452843 CT     school 904620 1440011   Trumbull School District 90462000930 1445211 Hillcrest Middle School Public Schools Regular School No Middle 06 08 2019   pk_12_total 532 32 78   * 67     *   13   383 342     *             75   725 532 32 78     67         13   383 342             75   725
2452844 CT     school 904620 1440011   Trumbull School District 90462000933 1445111 Madison Middle School Public Schools Regular School No Middle 06 08 2019   pk_12_total 587 45 100   0 80     *   *   454 379     6             110   833 587 45 100   0 80             454 379     6       110   833
2452858 CT     school 904680 1460011   Vernon School District 90468000947 1465111 Vernon Center Middle School Public Schools Regular School No Middle 06 08 2019   pk_12_total 418 79 134   * *     0   38   360 345     11             132   705 418 79 134           0   38   360 345     11       132   705
2452875 CT     school 904740 1480011   Wallingford School District 90474000951 1485211 Dag Hammarskjold Middle School Public Schools Regular School No Middle 06 08 2019   pk_12_total 500 18 110   0 29     0   7   344 320     23             89   664 500 18 110   0 29     0   7   344 320     23       89   664
2452877 CT     school 904740 1480011   Wallingford School District 90474000954 1485311 James H. Moran Middle School Public Schools Regular School No Middle 06 08 2019   pk_12_total 404 14 124   * 24     *   6   295 283     15             69   578 404 14 124     24         6   295 283     15       69   578
2452918 CT     school 904830 1510011   Waterbury School District 90483000991 1515211 West Side Middle School Public Schools Regular School No Middle 06 08 2019   pk_12_total 165 220 535   10 17     0   31   497 481     109             186   978 165 220 535   10 17     0   31   497 481     109       186   978
2452921 CT     school 904830 1510011   Waterbury School District 90483000983 1515111 Michael F. Wallace Middle School Public Schools Regular School No Middle 06 08 2019   pk_12_total 143 248 599   10 22     0   30   543 509     122             199   1052 143 248 599   10 22     0   30   543 509     122       199   1052
2452925 CT     school 904830 1510011   Waterbury School District 90483001115 1515311 North End Middle School Public Schools Regular School No Middle 06 08 2019   pk_12_total 83 234 576   * *     0   24   463 465     86             182   928 83 234 576           0   24   463 465     86       182   928
2452930 CT     school 904830 1510011   Waterbury School District 90483001395 1515011 Waterbury Arts Magnet School (Middle) Public Schools Regular School No Middle 06 08 2019   pk_12_total 138 51 121   * *     0   17   137 197     9             47   334 138 51 121           0   17   137 197     9       47   334
2452946 CT     school 904860 1520011   Waterford School District 90486000994 1525111 Clark Lane Middle School Public Schools Regular School No Middle 06 08 2019   pk_12_total 449 12 57   * 33     *   25   274 307     6             100   581 449 12 57     33         25   274 307     6       100   581
2452953 CT     school 904890 1530011   Watertown School District 90489001007 1535111 Swift Middle School Public Schools Regular School No Middle 06 08 2019   pk_12_total 567 19 62   * *     0   20   364 321     16             100   685 567 19 62           0   20   364 321     16       100   685
2452973 CT     school 904920 1550011   West Hartford School District 90492001419 1555311 Bristow Middle School Public Schools Regular School No Middle 06 08 2019   pk_12_total 260 37 59   0 47     0   14   227 190     10             59   417 260 37 59   0 47     0   14   227 190     10       59   417
2452974 CT     school 904920 1550011   West Hartford School District 90492001017 1555111 King Philip Middle School Public Schools Regular School No Middle 06 08 2019   pk_12_total 533 75 153   0 87     *   *   467 436     38             121   903 533 75 153   0 87             467 436     38       121   903
2452975 CT     school 904920 1550011   West Hartford School District 90492001021 1555211 Sedgwick Middle School Public Schools Regular School No Middle 06 08 2019   pk_12_total 489 75 201   * 92     *   27   421 466     34             108   887 489 75 201     92         27   421 466     34       108   887
2452989 CT     school 904950 1560011   West Haven School District 90495001037 1565311 Carrigan 5/6 Intermediate School Public Schools Regular School No Middle 05 06 2019   pk_12_total 281 211 357   * 30     *   36   510 408     91             145   918 281 211 357     30         36   510 408     91       145   918
2452990 CT     school 904950 1560011   West Haven School District 90495001036 1565111 Harry M. Bailey Middle School Public Schools Regular School No Middle 07 08 2019   pk_12_total 315 234 352   * 26     *   29   466 494     87             144   960 315 234 352     26         29   466 494     87       144   960
2452996 CT     school 904980 1540011   Westbrook School District 90498001043 1545111 Westbrook Middle School Public Schools Regular School No Middle 05 08 2019   pk_12_total 163 0 39   0 *     0   *   114 95     21             39   209 163 0 39   0       0       114 95     21       39   209
2453000 CT     school 905010 1570011   Weston School District 90501001047 1575111 Weston Middle School Public Schools Regular School No Middle 06 08 2019   pk_12_total 486 13 27   0 26     0   29   290 291     *             63   581 486 13 27   0 26     0   29   290 291             63   581
2453011 CT     school 905040 1580011   Westport School District 90504001048 1585111 Bedford Middle School Public Schools Regular School No Middle 06 08 2019   pk_12_total 682 13 48   0 58     0   57   446 412     *             110   858 682 13 48   0 58     0   57   446 412             110   858
2453012 CT     school 905040 1580011   Westport School District 90504001052 1585311 Coleytown Middle School Public Schools Regular School No Middle 06 08 2019   pk_12_total 370 7 28   0 27     0   24   227 229     *             58   456 370 7 28   0 27     0   24   227 229             58   456
2453021 CT     school 905070 1590011   Wethersfield School District 90507001066 1595211 Silas Deane Middle School Public Schools Regular School No Middle 07 08 2019   pk_12_total 379 23 89   * 21     *   20   267 268     24             81   535 379 23 89     21         20   267 268     24       81   535
2453025 CT     school 905100 1600011   Willington School District 90510001070 1605111 Hall Memorial School Public Schools Regular School No Middle 05 08 2019   pk_12_total 166 * 14   0 *     0   7   100 90     0             34   190 166   14   0       0   7   100 90     0       34   190
2453027 CT     school 905130 1610011   Wilton School District 90513001073 1615211 Middlebrook School Public Schools Regular School No Middle 06 08 2019   pk_12_total 770 * 66   * 104     0   54   471 532     *             138   1003 770   66     104     0   54   471 532             138   1003
2453042 CT     school 905190 1630011   Windham School District 90519001081 1635111 Windham Middle School Public Schools Regular School No Middle 06 08 2019   pk_12_total 98 26 512   * *     0   13   343 311     186             138   654 98 26 512           0   13   343 311     186       138   654
2453048 CT     school 905250 1650011   Windsor Locks School District 90525001101 1655111 Windsor Locks Middle School Public Schools Regular School No Middle 06 08 2019   pk_12_total 200 37 62   0 22     *   *   162 182     10             62   344 200 37 62   0 22             162 182     10       62   344
2453056 CT     school 905220 1640011   Windsor School District 90522001095 1645311 Sage Park Middle School Public Schools Regular School No Middle 06 08 2019   pk_12_total 196 322 122   0 *     *   54   367 351     26             107   718 196 322 122   0           54   367 351     26       107   718
2453064 CT     school 905280 1660011   Wolcott School District 90528001102 1665111 Tyrrell Middle School Public Schools Regular School No Middle 06 08 2019   pk_12_total 447 26 43   * *     0   24   289 263     7             75   552 447 26 43           0   24   289 263     7       75   552
2453069 CT     school 905370 1690011   Woodstock School District 90537000573 1695111 Woodstock Middle School Public Schools Regular School No Middle 05 08 2019   pk_12_total 368 * 15   0 *     0   17   199 207     0             40   406 368   15   0       0   17   199 207     0       40   406
2453083 CT     school 900033 2830013   Park City Prep Charter School District 90003301449 2835113 Park City Prep Charter School Public Charter Schools Regular School Yes Middle 05 08 2019   pk_12_total 15 160 175   * *     *   *   193 167     36             43   360 15 160 175                   193 167     36       43   360
2453084 CT     school 900219 2940013   Great Oaks Charter School District 90021901782 2940113 Great Oaks Charter School Public Charter Schools Regular School Yes Middle 06 10 2019   pk_12_total 22 224 209   * 0     *   7   216 249     60             85   465 22 224 209     0         7   216 249     60       85   465
2453085 CT     school 900011 2650013   Interdistrict School for Arts and Comm District 90001100797 2655113 Interdistrict School For Arts And Communication Public Charter Schools Regular School Yes Middle 06 08 2019   pk_12_total 54 49 160   * *     *   *   133 145     29             38   278 54 49 160                   133 145     29       38   278
2453086 CT     school 900023 2780013   Trailblazers Academy District 90002300965 2785113 Trailblazers Academy   Regular School Yes Middle 06 08 2019   pk_12_total * 63 58   0 *     0   *   70 57     14             33   127   63 58   0       0       70 57     14       33   127
2453087 CT     school 903630 2040012   Regional School District 04 90363000767 2045112 John Winthrop Middle School Regional Schools Regular School No Middle 07 08 2019   pk_12_total 247 * 17   0 *     0   12   134 149     *             54   283 247   17   0       0   12   134 149             54   283
2453090 CT     school 903660 2050012   Regional School District 05 90366001114 2055112 Amity Middle School: Bethany Regional Schools Regular School No Middle 07 08 2019   pk_12_total 234 * *   0 54     0   15   162 153     *             42   315 234       0 54     0   15   162 153             42   315
2453091 CT     school 903660 2050012   Regional School District 05 90366000769 2055212 Amity Middle School: Orange Regional Schools Regular School No Middle 07 08 2019   pk_12_total 286 * *   0 49     0   11   178 178     0             42   356 286       0 49     0   11   178 178     0       42   356
2453096 CT     school 903720 2070012   Regional School District 07 90372001226 2075112 Northwestern Regional Middle School Regional Schools Regular School No Middle 07 08 2019   pk_12_total 264 0 7   0 *     *   8   134 149     0             47   283 264 0 7   0           8   134 149     0       47   283
2453101 CT     school 903750 2080012   Regional School District 08 90375001210 2085112 RHAM Middle School Regional Schools Regular School No Middle 07 08 2019   pk_12_total 444 * 23   0 9     *   0   261 222     *             70   483 444   23   0 9         0   261 222             70   483
2757292 CT     school 900060 20011   Ansonia School District 90006010008 25111 Ansonia Middle School Public Schools Regular School No Middle 07 08 2021   pk_12_total 109 63 164   0 7     0   22   192 173     17             63   365 109 63 164   0 7     0   22   192 173     17       63   365
2757301 CT     school 900120 40011   Avon School District 90012001367 40511 Thompson Brook School Public Schools Regular School No Middle 05 06 2021   pk_12_total 296 28 38   * 122     0   *   255 248     8             53   503 296 28 38     122     0       255 248     8       53   503
2757302 CT     school 900120 40011   Avon School District 90012000012 45111 Avon Middle School Public Schools Regular School No Middle 07 08 2021   pk_12_total 301 33 47   0 107     0   23   244 267     *             53   511 301 33 47   0 107     0   23   244 267             53   511
2757310 CT     school 900210 70011   Berlin School District 90021000017 75111 Catherine M. McGee Middle School Public Schools Regular School No Middle 06 08 2021   pk_12_total 489 18 82   0 24     0   19   315 317     10             115   632 489 18 82   0 24     0   19   315 317     10       115   632
2757317 CT     school 900270 90011   Bethel School District 90027000025 95111 Bethel Middle School Public Schools Regular School No Middle 06 08 2021   pk_12_total 496 28 178   12 53     0   28   413 382     33             94   795 496 28 178   12 53     0   28   413 382     33       94   795
2757325 CT     school 900330 110011   Bloomfield School District 90033001375 110711 Carmen Arace Intermediate School Public Schools Regular School No Middle 05 06 2021   pk_12_total 6 186 29   * *     0   9   120 114     10             41   234 6 186 29           0   9   120 114     10       41   234
2757327 CT     school 900330 110011   Bloomfield School District 90033000034 115211 Carmen Arace Middle School Public Schools Regular School No Middle 07 08 2021   pk_12_total 7 224 29   * *     0   8   133 137     7             61   270 7 224 29           0   8   133 137     7       61   270
2757337 CT     school 900420 140011   Branford School District 90042000041 145111 Francis Walsh Intermediate School Public Schools Regular School No Middle 05 08 2021   pk_12_total 588 41 105   * 62     0   *   435 *     29             103   825 588 41 105     62     0       435       29       103   825
2757402 CT     school 900510 170011   Bristol School District 90051000089 175111 Chippens Hill Middle School Public Schools Regular School No Middle 06 08 2021   pk_12_total 327 54 249   0 34     *   *   341 353     41             104   694 327 54 249   0 34             341 353     41       104   694
2757409 CT     school 900510 170011   Bristol School District 90051000104 175211 Northeast Middle School Public Schools Regular School No Middle 06 08 2021   pk_12_total 244 31 104   0 21     0   21   202 219     13             67   421 244 31 104   0 21     0   21   202 219     13       67   421
2757418 CT     school 900540 180011   Brookfield School District 90054000112 185311 Whisconier Middle School Public Schools Regular School No Middle 05 08 2021   pk_12_total 581 22 108   * 63     *   9   411 379     18             111   790 581 22 108     63         9   411 379     18       111   790
2757421 CT     school 900570 190011   Brooklyn School District 90057000114 195111 Brooklyn Middle School Public Schools Regular School No Middle 05 08 2021   pk_12_total 266 6 34   0 7     0   21   172 162     *             49   334 266 6 34   0 7     0   21   172 162             49   334
2757423 CT     school 900660 220011   Canterbury School District 90066001187 225111 Dr. Helen Baldwin Middle School Public Schools Regular School No Middle 05 08 2021   pk_12_total 169 * 10   * 0     0   *   85 97     *             19   182 169   10     0     0       85 97             19   182
2757426 CT     school 900690 230011   Canton School District 90069001376 235111 Canton Middle School Public Schools Regular School No Middle 07 08 2021   pk_12_total 193 23 16   0 *     0   *   125 118     *             38   243 193 23 16   0       0       125 118             38   243
2757444 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 2021   pk_12_total 66 95 170   0 0     0   18   * 251     25             81   349 66 95 170   0 0     0   18     251     25       81   349
2757446 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 2021   pk_12_total 90 202 339   * *     0   27   360 316     79             138   676 90 202 339           0   27   360 316     79       138   676
2757460 CT     school 900750 250011   Cheshire School District 90075000125 255111 Dodd Middle School Public Schools Regular School No Middle 07 08 2021   pk_12_total 481 21 44   * 70     0   *   308 325     6             67   633 481 21 44     70     0       308 325     6       67   633
2757466 CT     school 900810 270011   Clinton School District 90081000133 275111 Jared Eliot School Public Schools Regular School No Middle 05 08 2021   pk_12_total 344 * 103   * 16     0   *   256 217     23             75   473 344   103     16     0       256 217     23       75   473
2757470 CT     school 900840 280011   Colchester School District 90084000136 285111 William J. Johnston Middle School Public Schools Regular School No Middle 06 08 2021   pk_12_total 415 10 42   0 11     0   23   267 234     *             74   501 415 10 42   0 11     0   23   267 234             74   501
2757487 CT     school 900960 320011   Coventry School District 90096000141 325111 Capt. Nathan Hale School Public Schools Regular School No Middle 06 08 2021   pk_12_total 344 * 24   0 *     0   9   200 187     *             62   387 344   24   0       0   9   200 187             62   387
2757492 CT     school 900990 330011   Cromwell School District 90099000147 335111 Cromwell Middle School Public Schools Regular School No Middle 06 08 2021   pk_12_total 329 43 50   * 27     *   15   249 220     8             45   469 329 43 50     27         15   249 220     8       45   469
2757508 CT     school 901020 340011   Danbury School District 90102000149 345111 Broadview Middle School Public Schools Regular School No Middle 06 08 2021   pk_12_total 312 82 534   * 59     0   *   541 482     177             165   1023 312 82 534     59     0       541 482     177       165   1023
2757509 CT     school 901020 340011   Danbury School District 90102000160 345211 Rogers Park Middle School Public Schools Regular School No Middle 06 08 2021   pk_12_total 266 84 646   0 41     *   *   540 528     370             144   1068 266 84 646   0 41             540 528     370       144   1068
2757510 CT     school 901020 340011   Danbury School District 90102001691 340311 Westside Middle School Academy Public Schools Regular School No Middle 06 08 2021   pk_12_total 321 49 308   0 53     0   13   * 374     72             44   744 321 49 308   0 53     0   13     374     72       44   744
2757519 CT     school 901050 350011   Darien School District 90105000169 355111 Middlesex Middle School Public Schools Regular School No Middle 06 08 2021   pk_12_total 956 * 74   * 61     0   37   581 562     8             182   1143 956   74     61     0   37   581 562     8       182   1143
2757524 CT     school 901110 370011   Derby School District 90111001578 375011 Derby Middle School Public Schools Regular School No Middle 06 08 2021   pk_12_total 113 64 115   0 8     0   22   178 144     6             66   322 113 64 115   0 8     0   22   178 144     6       66   322
2757529 CT     school 901170 400011   East Granby School District 90117000182 405111 East Granby Middle School Public Schools Regular School No Middle 06 08 2021   pk_12_total 146 * 20   0 20     0   *   102 107     *             28   209 146   20   0 20     0       102 107             28   209
2757532 CT     school 901200 410011   East Haddam School District 90120000198 415111 Nathan Hale-Ray Middle School Public Schools Regular School No Middle 04 08 2021   pk_12_total 313 * 21   * *     0   8   176 173     *             53   349 313   21           0   8   176 173             53   349
2757537 CT     school 901230 420011   East Hampton School District 90123000188 425111 East Hampton Middle School Public Schools Regular School No Middle 06 08 2021   pk_12_total 380 * 24   * *     0   15   196 232     0             62   428 380   24           0   15   196 232     0       62   428
2757550 CT     school 901260 430011   East Hartford School District 90126000197 435111 East Hartford Middle School Public Schools Regular School No Middle 06 08 2021   pk_12_total 96 344 562   * 33     *   49   590 499     178             249   1089 96 344 562     33         49   590 499     178       249   1089
2757551 CT     school 901260 430011   East Hartford School District 90126001275 432411 Sunset Ridge Middle School Public Schools Regular School No Middle 06 08 2021   pk_12_total 48 89 177   * *     0   16   158 188     8             54   346 48 89 177           0   16   158 188     8       54   346
2757561 CT     school 901290 440011   East Haven School District 90129000217 445111 Joseph Melillo Middle School Public Schools Regular School No Middle 06 08 2021   pk_12_total 264 44 183   * 17     0   *   279 245     52             85   524 264 44 183     17     0       279 245     52       85   524
2757567 CT     school 901320 450011   East Lyme School District 90132000224 455111 East Lyme Middle School Public Schools Regular School No Middle 05 08 2021   pk_12_total 547 13 69   0 80     0   33   373 369     9             120   742 547 13 69   0 80     0   33   373 369     9       120   742
2757572 CT     school 901350 470011   East Windsor School District 90135000230 475411 East Windsor Middle School Public Schools Regular School No Middle 05 08 2021   pk_12_total 156 36 83   * *     0   11   144 153     12             65   297 156 36 83           0   11   144 153     12       65   297
2757583 CT     school 901410 460011   Easton School District 90141000233 465111 Helen Keller Middle School Public Schools Regular School No Middle 06 08 2021   pk_12_total 255 7 23   0 21     0   11   156 161     *             45   317 255 7 23   0 21     0   11   156 161             45   317
2757594 CT     school 901440 480011   Ellington School District 90144000238 485111 Ellington Middle School Public Schools Regular School No Middle 07 08 2021   pk_12_total 309 15 37   0 43     0   19   205 218     *             75   423 309 15 37   0 43     0   19   205 218             75   423
2757616 CT     school 901470 490011   Enfield School District 90147000249 495211 John F. Kennedy Middle School Public Schools Regular School No Middle 06 08 2021   pk_12_total 754 68 218   * *     0   45   573 539     22             168   1112 754 68 218           0   45   573 539     22       168   1112
2757635 CT     school 901530 510011   Fairfield School District 90153000258 515211 Fairfield Woods Middle School Public Schools Regular School No Middle 06 08 2021   pk_12_total 602 17 94   0 69     0   49   449 382     11             126   831 602 17 94   0 69     0   49   449 382     11       126   831
2757636 CT     school 901530 510011   Fairfield School District 90153000919 515311 Roger Ludlowe Middle School Public Schools Regular School No Middle 06 08 2021   pk_12_total 689 * 45   * 39     0   31   397 420     *             109   817 689   45     39     0   31   397 420             109   817
2757637 CT     school 901530 510011   Fairfield School District 90153000271 515111 Tomlinson Middle School Public Schools Regular School No Middle 06 08 2021   pk_12_total 423 * 116   0 37     *   37   327 311     17             90   638 423   116   0 37         37   327 311     17       90   638
2757647 CT     school 901560 520011   Farmington School District 90156001368 520511 West Woods Upper Elementary School Public Schools Regular School No Middle 04 06 2021   pk_12_total 335 32 67   0 151     0   39   302 322     17             66   624 335 32 67   0 151     0   39   302 322     17       66   624
2757648 CT     school 901560 520011   Farmington School District 90156000274 525111 Irving A. Robbins Middle School Public Schools Regular School No Middle 07 08 2021   pk_12_total 381 39 62   * 175     0   *   357 325     12             94   682 381 39 62     175     0       357 325     12       94   682
2757659 CT     school 901620 540011   Glastonbury School District 90162000279 540811 Gideon Welles School Public Schools Regular School No Middle 06 06 2021   pk_12_total 272 17 47   0 56     0   24   216 200     9             47   416 272 17 47   0 56     0   24   216 200     9       47   416
2757660 CT     school 901620 540011   Glastonbury School District 90162000282 545211 Smith Middle School Public Schools Regular School No Middle 06 08 2021   pk_12_total 619 * 96   * 116     0   55   448 462     8             92   910 619   96     116     0   55   448 462     8       92   910

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