Data source: Big Local News · About: Big Local

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

View and edit SQL

year

  • 2019 · 1,349

grade

  • pk_12_total · 1,349
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
2452298 CT     school 902400 800011   Meriden School District 90240001194 805411 Washington Middle School Public Schools Regular School No Middle 06 08 2019   pk_12_total 259 82 371   * *     0   27   393 362     66             139   755 259 82 371           0   27   393 362     66       139   755
2452325 CT     school 902490 830011   Middletown School District 90249000456 831511 Keigwin Middle School Public Schools Regular School No Middle 06 06 2019   pk_12_total 139 75 69   * *     0   24   166 157     13             47   323 139 75 69           0   24   166 157     13       47   323
2452326 CT     school 902490 830011   Middletown School District 90249000459 835411 Woodrow Wilson Middle School Public Schools Regular School No Middle 07 08 2019   pk_12_total 285 134 127   0 *     *   45   289 321     13             81   610 285 134 127   0           45   289 321     13       81   610
2452342 CT     school 902520 840011   Milford School District 90252000484 845111 East Shore Middle School Public Schools Regular School No Middle 06 08 2019   pk_12_total 310 * 30   0 27     0   *   179 216     *             57   395 310   30   0 27     0       179 216             57   395
2452343 CT     school 902520 840011   Milford School District 90252000468 845211 Harborside Middle School Public Schools Regular School No Middle 06 08 2019   pk_12_total 332 10 59   * 53     0   *   256 204     9             66   460 332 10 59     53     0       256 204     9       66   460
2452344 CT     school 902520 840011   Milford School District 90252000474 845311 West Shore Middle School Public Schools Regular School No Middle 06 08 2019   pk_12_total 314 33 65   * 44     *   *   237 225     9             61   462 314 33 65     44             237 225     9       61   462
2452353 CT     school 902550 850011   Monroe School District 90255000920 855211 Jockey Hollow School Public Schools Regular School No Middle 06 08 2019   pk_12_total 627 * 58   * 39     0   18   361 395     *             101   756 627   58     39     0   18   361 395             101   756
2452360 CT     school 902580 860011   Montville School District 90258000035 865111 Leonard J. Tyl Middle School Public Schools Regular School No Middle 06 08 2019   pk_12_total 333 * 52   9 34     *   64   244 256     8             84   500 333   52   9 34         64   244 256     8       84   500
2452371 CT     school 902640 880011   Naugatuck School District 90264000502 880211 Cross Street Intermediate School Public Schools Regular School No Middle 05 06 2019   pk_12_total 204 26 62   * *     0   12   159 157     13             51   316 204 26 62           0   12   159 157     13       51   316
2452372 CT     school 902640 880011   Naugatuck School District 90264000504 880411 Hillside Intermediate School Public Schools Regular School No Middle 05 06 2019   pk_12_total 171 22 112   * 6     *   15   176 155     25             66   331 171 22 112     6         15   176 155     25       66   331
2452373 CT     school 902640 880011   Naugatuck School District 90264000501 885111 City Hill Middle School Public Schools Regular School No Middle 07 08 2019   pk_12_total 385 55 174   * *     0   30   350 318     30             110   668 385 55 174           0   30   350 318     30       110   668
2452394 CT     school 902670 890011   New Britain School District 90267001445 895411 House of Arts Letters and Science (HALS) Academy Public Schools Regular School No Middle 06 08 2019   pk_12_total 61 15 58   0 *     0   *   68 80     0             *   148 61 15 58   0       0       68 80     0           148
2452395 CT     school 902670 890011   New Britain School District 90267000518 895311 Pulaski Middle School Public Schools Regular School No Middle 06 08 2019   pk_12_total 166 94 573   * 22     0   *   463 412     174             184   875 166 94 573     22     0       463 412     174       184   875
2452397 CT     school 902670 890011   New Britain School District 90267000522 895211 Slade Middle School Public Schools Regular School No Middle 06 08 2019   pk_12_total 128 118 584   * *     0   24   482 384     124             180   866 128 118 584           0   24   482 384     124       180   866
2452405 CT     school 902700 900011   New Canaan School District 90270000532 905111 Saxe Middle School Public Schools Regular School No Middle 05 08 2019   pk_12_total 1102 8 72   * 105     *   42   686 648     9             162   1334 1102 8 72     105         42   686 648     9       162   1334
2452410 CT     school 902730 910011   New Fairfield School District 90273001224 915211 New Fairfield Middle School Public Schools Regular School No Middle 06 08 2019   pk_12_total 423 11 57   * *     0   11   270 242     6             60   512 423 11 57           0   11   270 242     6       60   512
2452461 CT     school 902790 930011   New Haven School District 90279000545 935511 Betsy Ross Arts Magnet School Public Schools Regular School No Middle 05 08 2019   pk_12_total 90 187 157   * 7     0   *   147 301     30             45   448 90 187 157     7     0       147 301     30       45   448
2452481 CT     school 902820 950011   New London School District 90282000596 955111 Bennie Dover Jackson Middle School Public Schools Regular School No Middle 06 08 2019   pk_12_total 19 45 192   * *     0   17   155 122     104             57   277 19 45 192           0   17   155 122     104       57   277
2452482 CT     school 902820 950011   New London School District 90282001919 951411 New London Visual and Performing Arts Magnet School Public Schools Regular School No Middle 06 09 2019   pk_12_total 55 38 87   * *     0   21   92 112     25             46   204 55 38 87           0   21   92 112     25       46   204
2452488 CT     school 902850 960011   New Milford School District 90285000603 965211 Schaghticoke Middle School Public Schools Regular School No Middle 06 08 2019   pk_12_total 729 * 153   * 40     0   44   537 *     29             150   991 729   153     40     0   44   537       29       150   991
2452495 CT     school 902880 940011   Newington School District 90288001120 945311 John Wallace Middle School Public Schools Regular School No Middle 05 08 2019   pk_12_total 415 41 128   0 52     0   35   334 337     21             82   671 415 41 128   0 52     0   35   334 337     21       82   671
2452496 CT     school 902880 940011   Newington School District 90288000608 945111 Martin Kellogg Middle School Public Schools Regular School No Middle 05 08 2019   pk_12_total 360 39 152   * 63     0   *   319 327     26             88   646 360 39 152     63     0       319 327     26       88   646
2452503 CT     school 902910 970011   Newtown School District 90291001487 970511 Reed Intermediate School Public Schools Regular School No Middle 05 06 2019   pk_12_total 527 11 44   0 26     0   16   299 325     *             95   624 527 11 44   0 26     0   16   299 325             95   624
2452504 CT     school 902910 970011   Newtown School District 90291000616 975111 Newtown Middle School Public Schools Regular School No Middle 07 08 2019   pk_12_total 579 16 49   0 22     0   15   337 344     0             88   681 579 16 49   0 22     0   15   337 344     0       88   681
2452510 CT     school 902970 990011   North Branford School District 90297000622 995111 North Branford Intermediate School Public Schools Regular School No Middle 06 08 2019   pk_12_total 355 15 31   0 14     0   0   226 189     *             58   415 355 15 31   0 14     0   0   226 189             58   415
2452518 CT     school 903030 1010011   North Haven School District 90303000632 1015211 North Haven Middle School Public Schools Regular School No Middle 06 08 2019   pk_12_total 570 25 61   * 55     0   *   380 351     10             94   731 570 25 61     55     0       380 351     10       94   731
2452536 CT     school 903090 1030011   Norwalk School District 90309000653 1035211 Nathan Hale Middle School Public Schools Regular School No Middle 06 08 2019   pk_12_total 216 103 286   0 28     0   15   331 317     58             107   648 216 103 286   0 28     0   15   331 317     58       107   648
2452537 CT     school 903090 1030011   Norwalk School District 90309000656 1035311 Ponus Ridge Middle School Public Schools Regular School No Middle 06 08 2019   pk_12_total 103 107 421   * 34     0   *   330 352     121             94   682 103 107 421     34     0       330 352     121       94   682
2452538 CT     school 903090 1030011   Norwalk School District 90309000657 1035511 Roton Middle School Public Schools Regular School No Middle 06 08 2019   pk_12_total 186 74 261   0 17     0   11   296 253     66             76   549 186 74 261   0 17     0   11   296 253     66       76   549
2452539 CT     school 903090 1030011   Norwalk School District 90309000661 1035411 West Rocks Middle School Public Schools Regular School No Middle 06 08 2019   pk_12_total 166 135 338   * 26     0   *   349 326     93             110   675 166 135 338     26     0       349 326     93       110   675
2452557 CT     school 903120 1040011   Norwich School District 90312000670 1045111 Kelly STEAM Magnet Middle School Public Schools Regular School No Middle 06 08 2019   pk_12_total 182 109 226   0 *     *   70   316 315     84             78   631 182 109 226   0           70   316 315     84       78   631
2452559 CT     school 903120 1040011   Norwich School District 90312000674 1045211 Teachers' Memorial Global Studies Magnet Middle School Public Schools Regular School No Middle 06 08 2019   pk_12_total 102 77 137   * 26     *   40   191 194     54             99   385 102 77 137     26         40   191 194     54       99   385
2452563 CT     school 903180 1060011   Old Saybrook School District 90318000007 1065211 Old Saybrook Middle School Public Schools Regular School No Middle 04 08 2019   pk_12_total 383 0 48   0 15     *   *   226 232     22             65   458 383 0 48   0 15             226 232     22       65   458
2452571 CT     school 903240 1080011   Oxford School District 90324000690 1085111 Oxford Middle School Public Schools Regular School No Middle 06 08 2019   pk_12_total 428 * 33   * 11     0   *   233 250     *             58   483 428   33     11     0       233 250             58   483
2452578 CT     school 903270 1090011   Plainfield School District 90327000693 1095111 Plainfield Central School Public Schools Regular School No Middle 06 08 2019   pk_12_total 442 32 21   7 *     *   *   249 262     6             79   511 442 32 21   7               249 262     6       79   511
2452583 CT     school 903300 1100011   Plainville School District 90330000048 1105211 Middle School of Plainville Public Schools Regular School No Middle 06 08 2019   pk_12_total 358 * 103   * 19     0   23   269 254     21             71   523 358   103     19     0   23   269 254     21       71   523
2452588 CT     school 903330 1110011   Plymouth School District 90333000705 1115111 Eli Terry Jr. Middle School Public Schools Regular School No Middle 06 08 2019   pk_12_total 308 * 24   * 10     0   6   199 155     7             64   354 308   24     10     0   6   199 155     7       64   354
2452593 CT     school 903390 1130011   Portland School District 90339001393 1130511 Brownstone Intermediate School Public Schools Regular School No Middle 05 06 2019   pk_12_total 162 * 27   0 *     0   14   107 107     *             24   214 162   27   0       0   14   107 107             24   214
2452594 CT     school 903390 1130011   Portland School District 90339000713 1135111 Portland Middle School Public Schools Regular School No Middle 07 08 2019   pk_12_total 157 * 27   0 *     0   12   105 100     *             23   205 157   27   0       0   12   105 100             23   205
2452597 CT     school 903420 1140011   Preston School District 90342000717 1145111 Preston Plains School Public Schools Regular School No Middle 06 08 2019   pk_12_total 113 * 11   * *     0   8   66 79     *             24   145 113   11           0   8   66 79             24   145
2452599 CT     school 903480 1160011   Putnam School District 90348000720 1165111 Putnam Middle School Public Schools Regular School No Middle 06 08 2019   pk_12_total 232 * 28   0 *     *   9   150 128     7             53   278 232   28   0           9   150 128     7       53   278
2452603 CT     school 903510 1170011   Redding School District 90351000721 1175111 John Read Middle School Public Schools Regular School No Middle 05 08 2019   pk_12_total 328 * 24   0 *     0   19   201 188     *             60   389 328   24   0       0   19   201 188             60   389
2452614 CT     school 903520 2100012   Regional School District 10 90352000727 2105112 Har-Bur Middle School Regional Schools Regular School No Middle 05 08 2019   pk_12_total 693 * 15   * 17     *   *   387 347     *             88   734 693   15     17             387 347             88   734
2452623 CT     school 903535 2130012   Regional School District 13 90353500742 2130412 Middlefield Memorial School Regional Schools Regular School No Middle 04 06 2019   pk_12_total 265 * 30   0 *     0   11   153 159     *             51   312 265   30   0       0   11   153 159             51   312
2452624 CT     school 903535 2130012   Regional School District 13 90353500739 2135112 Frank Ward Strong School Regional Schools Regular School No Middle 07 08 2019   pk_12_total 234 0 15   0 *     0   *   126 139     0             50   265 234 0 15   0       0       126 139     0       50   265
2452629 CT     school 903536 2140012   Regional School District 14 90353600746 2145112 Woodbury Middle School Regional Schools Regular School No Middle 06 08 2019   pk_12_total 304 * 20   * 8     0   *   160 177     *             63   337 304   20     8     0       160 177             63   337
2452636 CT     school 903537 2150012   Regional School District 15 90353700748 2155212 Memorial Middle School Regional Schools Regular School No Middle 06 08 2019   pk_12_total 382 * 16   0 20     *   9   212 226     0             76   438 382   16   0 20         9   212 226     0       76   438
2452637 CT     school 903537 2150012   Regional School District 15 90353700751 2155112 Rochambeau Middle School Regional Schools Regular School No Middle 06 08 2019   pk_12_total 368 * 21   * 19     0   10   222 207     *             76   429 368   21     19     0   10   222 207             76   429
2452642 CT     school 903538 2160012   Regional School District 16 90353800756 2165112 Long River Middle School Regional Schools Regular School No Middle 06 08 2019   pk_12_total 474 18 37   * 6     0   *   250 288     7             79   538 474 18 37     6     0       250 288     7       79   538
2452648 CT     school 903539 2170012   Regional School District 17 90353901201 2175112 Haddam-Killingworth Middle School Regional Schools Regular School No Middle 05 08 2019   pk_12_total 615 * 18   0 *     0   22   358 313     *             127   671 615   18   0       0   22   358 313             127   671
2452654 CT     school 903540 2180012   Regional School District 18 90354001123 2185112 Lyme-Old Lyme Middle School Regional Schools Regular School No Middle 06 08 2019   pk_12_total 244 * 15   0 10     0   *   131 147     *             39   278 244   15   0 10     0       131 147             39   278
2452667 CT     school 903810 1180011   Ridgefield School District 90381000776 1185111 East Ridge Middle School Public Schools Regular School No Middle 06 08 2019   pk_12_total 535 0 41   0 38     0   27   329 312     *             71   641 535 0 41   0 38     0   27   329 312             71   641
2452668 CT     school 903810 1180011   Ridgefield School District 90381001361 1185211 Scotts Ridge Middle School Public Schools Regular School No Middle 06 08 2019   pk_12_total 441 7 38   0 46     0   20   285 267     0             87   552 441 7 38   0 46     0   20   285 267     0       87   552
2452675 CT     school 903840 1190011   Rocky Hill School District 90384000782 1195111 Albert D. Griswold Middle School Public Schools Regular School No Middle 05 08 2019   pk_12_total 359 21 76   * 147     0   *   312 310     21             72   622 359 21 76     147     0       312 310     21       72   622
2452683 CT     school 903990 1240011   Seymour School District 90399000794 1245111 Seymour Middle School Public Schools Regular School No Middle 06 08 2019   pk_12_total 373 25 99   * 19     0   *   264 260     7             77   524 373 25 99     19     0       264 260     7       77   524
2452695 CT     school 904050 1260011   Shelton School District 90405001584 1261111 Perry Hill Elementary School Public Schools Regular School No Middle 05 06 2019   pk_12_total 496 44 112   0 49     *   *   392 337     31             108   729 496 44 112   0 49             392 337     31       108   729
2452696 CT     school 904050 1260011   Shelton School District 90405000801 1265111 Intermediate School Public Schools Regular School No Middle 07 08 2019   pk_12_total 546 45 105   * 40     *   32   394 376     22             127   770 546 45 105     40         32   394 376     22       127   770
2452706 CT     school 904110 1280011   Simsbury School District 90411000811 1285111 Henry James Memorial School Public Schools Regular School No Middle 07 08 2019   pk_12_total 452 34 54   0 50     0   16   313 293     *             82   606 452 34 54   0 50     0   16   313 293             82   606
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

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