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,449

grade

  • pk_12_total · 1,449
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
2451740 CT     school 900330 110011   Bloomfield School District 90033001565 110811 Wintonbury Early Childhood Magnet School Public Schools Regular School No Prekindergarten PK PK 2019   pk_12_total 115 120 37   * 25     0   *   170 149     0             44   319 115 120 37     25     0       170 149     0       44   319
2451761 CT     school 900450 150011   Bridgeport School District 90045000085 154411 A.B. Skane Center Public Schools Regular School No Prekindergarten PK PK 2019   pk_12_total 41 63 107   0 *     0   *   145 81     0             127   226 41 63 107   0       0       145 81     0       127   226
2451800 CT     school 900510 170011   Bristol School District 90051001774 170411 Bristol Early Childhood Center-BECC Public Schools Special Education School No Prekindergarten PK PK 2019   pk_12_total 66 * 29   0 *     0   8   62 45     0             65   107 66   29   0       0   8   62 45     0       65   107
2451912 CT     school 901020 340011   Danbury School District 90102001634 340111 DPS Early Childhood Center Public Schools Regular School No Prekindergarten PK PK 2019   pk_12_total 49 8 73   * 12     0   *   90 60     0             72   150 49 8 73     12     0       90 60     0       72   150
2451939 CT     school 901110 370011   Derby School District 90111001806 370111 Little Raiders University Public Schools Regular School No Prekindergarten PK PK 2019   pk_12_total 16 10 13   0 0     *   *   31 13     0             15   44 16 10 13   0 0             31 13     0       15   44
2451973 CT     school 901290 440011   East Haven School District 90129001350 441811 Overbrook Early Learning Center Public Schools Regular School No Prekindergarten PK PK 2019   pk_12_total 74 9 55   0 9     0   12   69 90     0             7   159 74 9 55   0 9     0   12   69 90     0       7   159
2452013 CT     school 901470 490011   Enfield School District 90147001915 492211 EPS Integrated Pre-Kindergarten Program Special Education School No Prekindergarten PK PK 2019   pk_12_total 62 * *   0 *     0   *   48 26     0             46   74 62       0       0       48 26     0       46   74
2452014 CT     school 901470 490011   Enfield School District 90147001810 491011 EPS PK STEAM Academy Program Regular School No Prekindergarten PK PK 2019   pk_12_total 31 17 14   0 *     0   *   39 29     0             10   68 31 17 14   0       0       39 29     0       10   68
2452149 CT     school 901920 640011   Hartford School District 90192001643 641311 Hartford PreKindergarten Magnet School Public Schools Regular School No Prekindergarten PK PK 2019   pk_12_total 12 50 23   * 57     0   *   71 80     0             6   151 12 50 23     57     0       71 80     0       6   151
2452526 CT     school 903090 1030011   Norwalk School District 90309001914 1030111 Norwalk Early Childhood Center Public Schools Regular School No Prekindergarten PK PK 2019   pk_12_total 74 14 54   0 15     0   6   100 63     0             104   163 74 14 54   0 15     0   6   100 63     0       104   163
2452544 CT     school 903120 1040011   Norwich School District 90312000663 1040111 Bishop School Early Learning Center Public Schools Regular School No Prekindergarten PK PK 2019   pk_12_total 61 33 54   * 15     0   *   90 85     0             74   175 61 33 54     15     0       90 85     0       74   175
2452651 CT     school 903540 2180012   Regional School District 18 90354000761 2180312 Center School Regional Schools Special Education School No Prekindergarten PK PK 2019   pk_12_total 40 * *   0 0     0   *   26 23     0             13   49 40       0 0     0       26 23     0       13   49
2452722 CT     school 904230 1310011   Southington School District 90423001804 1312111 Southington Public Schools Preschool Program Public Schools Regular School No Prekindergarten PK PK 2019   pk_12_total * * 0   0 0     0   0   9 10     0             11   19     0   0 0     0   0   9 10     0       11   19
2452723 CT     school 904230 1310011   Southington School District 90423001808 1312011 Southington Public Schools Preschool Program at Hatton School Public Schools Regular School No Prekindergarten PK PK 2019   pk_12_total 56 * 7   0 *     0   *   52 18     0             46   70 56   7   0       0       52 18     0       46   70
2452778 CT     school 904380 1370011   Stonington School District 90438001637 1370111 Stonington BOE Pre-School   Special Education School No Prekindergarten PK PK 2019   pk_12_total 22 0 *   0 *     0   0   15 11     0             16   26 22 0     0       0   0   15 11     0       16   26
2452779 CT     school 904380 1370011   Stonington School District 90438001635 1370211 Stonington HS PreK   Special Education School No Prekindergarten PK PK 2019   pk_12_total 22 0 *   0 0     0   *   17 9     0             17   26 22 0     0 0     0       17 9     0       17   26
2452144 CT     school 901920 640011   Hartford School District 90192001435 646911 Capital Preparatory Magnet School Public Schools Regular School No Other PK 12 2019   pk_12_total 43 323 121   0 11     0   25   263 260     29             62   523 43 323 121   0 11     0   25   263 260     29       62   523
2452151 CT     school 901920 640011   Hartford School District 90192000370 641111 Kinsella Magnet School of Performing Arts Public Schools Regular School No Other PK 12 2019   pk_12_total 177 179 403   * *     0   45   312 521     72             139   833 177 179 403           0   45   312 521     72       139   833
2452171 CT     school 901920 640011   Hartford School District 90192001535 643611 Global Communications Academy Public Schools Regular School No Other KG 12 2019   pk_12_total * 345 238   0 *     0   8   284 315     88             97   599   345 238   0       0   8   284 315     88       97   599
2452211 CT     school 900207 2860013   Highville Charter School District 90020700907 2860113 Highville Charter School Public Charter Schools Regular School Yes Other PK 12 2019   pk_12_total * 477 17   0 0     0   *   227 275     0             26   502   477 17   0 0     0       227 275     0       26   502
2452213 CT     school 900007 2610013   Jumoke Academy District 90000700747 2610113 Jumoke Academy Public Charter Schools Regular School Yes Other PK 12 2019   pk_12_total * 666 38   0 *     0   *   336 381     0             42   717   666 38   0       0       336 381     0       42   717
2452744 CT     school 904260 1330011   Sprague School District 90426000842 1330111 Sayles School Public Schools Regular School No Other PK 12 2019   pk_12_total 217 6 47   * *     *   35   178 135     *             50   313 217 6 47               35   178 135             50   313
2453070 CT     school 900208 2850013   Achievement First Bridgeport Academy District 90020801493 2850113 Achievement First Bridgeport Academy Public Charter Schools Regular School Yes Other KG 12 2019   pk_12_total 13 584 480   * 9     *   *   512 581     131             97   1093 13 584 480     9             512 581     131       97   1093
2453071 CT     school 900212 2880013   Achievement First Hartford Academy District 90021201528 2880113 Achievement First Hartford Academy Public Charter Schools Regular School Yes Other KG 12 2019   pk_12_total * 782 304   * *     *   15   519 593     52             115   1112   782 304               15   519 593     52       115   1112
2453072 CT     school 900024 2790013   Amistad Academy District 90002400981 2795113 Amistad Academy Public Charter Schools Regular School Yes Other KG 12 2019   pk_12_total 19 681 360   * *     0   21   509 574     118             71   1083 19 681 360           0   21   509 574     118       71   1083
2453075 CT     school 900221 2970013   Capital Preparatory Harbor School District 90022101803 2970113 Capital Preparatory Harbor School Public Charter Schools Regular School Yes Other KG 12 2019   pk_12_total * 463 167   * 0     0   *   323 311     *             71   634   463 167     0     0       323 311             71   634
2453080 CT     school 900214 2890013   Elm City College Preparatory School District 90021401548 2890113 Elm City College Preparatory School Public Charter Schools Regular School Yes Other KG 12 2019   pk_12_total 15 529 197   * *     0   12   371 385     41             60   756 15 529 197           0   12   371 385     41       60   756
2451929 CT     school 901020 340011   Danbury School District 90102001129 346211 Alternative Center For Excellence Program Alternative School No Not reported M M 2019   pk_12_total 30 10 44   * *     0   *   49 42     6             16   91 30 10 44           0       49 42     6       16   91
2451702 CT     school 900060 20011   Ansonia School District 90006010008 25111 Ansonia Middle School Public Schools Regular School No Middle 07 08 2019   pk_12_total 121 64 130   0 *     *   13   173 162     12             72   335 121 64 130   0           13   173 162     12       72   335
2451710 CT     school 900070 2440014   Area Cooperative Educational Services 90007001358 2445114 Thomas Edison Magnet Middle School Regional Education Service Center Schools Regular School No Middle 06 08 2019   pk_12_total 174 94 364   * 37     *   36   348 361     49             82   709 174 94 364     37         36   348 361     49       82   709
2451720 CT     school 900120 40011   Avon School District 90012001367 40511 Thompson Brook School Public Schools Regular School No Middle 05 06 2019   pk_12_total 309 28 44   * 104     0   *   243 266     9             49   509 309 28 44     104     0       243 266     9       49   509
2451721 CT     school 900120 40011   Avon School District 90012000012 45111 Avon Middle School Public Schools Regular School No Middle 07 08 2019   pk_12_total 339 21 34   0 96     0   21   251 260     6             48   511 339 21 34   0 96     0   21   251 260     6       48   511
2451729 CT     school 900210 70011   Berlin School District 90021000017 75111 Catherine M. McGee Middle School Public Schools Regular School No Middle 06 08 2019   pk_12_total 548 * 83   * 19     0   19   361 324     10             100   685 548   83     19     0   19   361 324     10       100   685
2451736 CT     school 900270 90011   Bethel School District 90027000025 95111 Bethel Middle School Public Schools Regular School No Middle 06 08 2019   pk_12_total 501 21 162   * 46     *   11   372 373     28             84   745 501 21 162     46         11   372 373     28       84   745
2451744 CT     school 900330 110011   Bloomfield School District 90033001375 110711 Carmen Arace Intermediate School Public Schools Regular School No Middle 05 06 2019   pk_12_total 8 207 23   0 *     *   6   123 123     *             45   246 8 207 23   0           6   123 123             45   246
2451746 CT     school 900330 110011   Bloomfield School District 90033000034 115211 Carmen Arace Middle School Public Schools Regular School No Middle 07 08 2019   pk_12_total 8 173 25   * *     0   13   127 96     *             45   223 8 173 25           0   13   127 96             45   223
2451757 CT     school 900420 140011   Branford School District 90042000041 145111 Francis Walsh Intermediate School Public Schools Regular School No Middle 05 08 2019   pk_12_total 640 35 102   * 65     0   *   447 424     23             103   871 640 35 102     65     0       447 424     23       103   871
2451819 CT     school 900510 170011   Bristol School District 90051000089 175111 Chippens Hill Middle School Public Schools Regular School No Middle 06 08 2019   pk_12_total 392 57 234   * 26     *   28   363 376     35             111   739 392 57 234     26         28   363 376     35       111   739
2451825 CT     school 900510 170011   Bristol School District 90051000104 175211 Northeast Middle School Public Schools Regular School No Middle 06 08 2019   pk_12_total 318 36 96   * 19     *   19   245 245     12             82   490 318 36 96     19         19   245 245     12       82   490
2451835 CT     school 900540 180011   Brookfield School District 90054000112 185311 Whisconier Middle School Public Schools Regular School No Middle 05 08 2019   pk_12_total 641 26 104   * 70     *   7   432 422     26             133   854 641 26 104     70         7   432 422     26       133   854
2451838 CT     school 900570 190011   Brooklyn School District 90057000114 195111 Brooklyn Middle School Public Schools Regular School No Middle 05 08 2019   pk_12_total 301 * 33   * 9     *   12   185 177     *             54   362 301   33     9         12   185 177             54   362
2451840 CT     school 900660 220011   Canterbury School District 90066001187 225111 Dr. Helen Baldwin Middle School Public Schools Regular School No Middle 05 08 2019   pk_12_total 167 * 8   0 0     0   *   93 86     0             22   179 167   8   0 0     0       93 86     0       22   179
2451842 CT     school 900690 230011   Canton School District 90069000119 230311 Canton Intermediate School Public Schools Regular School No Middle 04 06 2019   pk_12_total 281 31 24   0 10     *   *   176 176     *             40   352 281 31 24   0 10             176 176             40   352
2451843 CT     school 900690 230011   Canton School District 90069001376 235111 Canton Middle School Public Schools Regular School No Middle 07 08 2019   pk_12_total 204 14 25   0 *     0   *   131 124     *             34   255 204 14 25   0       0       131 124             34   255
2451864 CT     school 900700 2410014   Capitol Region Education Council 90070001625 2415314 Greater Hartford Academy of the Arts Magnet Middle Regional Education Service Center Schools Regular School No Middle 06 08 2019   pk_12_total 86 79 155   0 *     0   *   88 247     16             88   335 86 79 155   0       0       88 247     16       88   335
2451866 CT     school 900700 2410014   Capitol Region Education Council 90070001364 2415014 Two Rivers Magnet Middle School Regional Education Service Center Schools Regular School No Middle 06 08 2019   pk_12_total 142 183 272   * *     0   39   389 277     43             122   666 142 183 272           0   39   389 277     43       122   666
2451879 CT     school 900750 250011   Cheshire School District 90075000125 255111 Dodd Middle School Public Schools Regular School No Middle 07 08 2019   pk_12_total 548 21 40   0 61     0   12   326 356     *             79   682 548 21 40   0 61     0   12   326 356             79   682
2451886 CT     school 900810 270011   Clinton School District 90081000133 275111 Jared Eliot School Public Schools Regular School No Middle 05 08 2019   pk_12_total 349 * 62   * 18     0   6   223 215     16             77   438 349   62     18     0   6   223 215     16       77   438
2451890 CT     school 900840 280011   Colchester School District 90084000136 285111 William J. Johnston Middle School Public Schools Regular School No Middle 06 08 2019   pk_12_total 440 7 36   * 16     *   19   251 269     *             87   520 440 7 36     16         19   251 269             87   520
2451905 CT     school 900960 320011   Coventry School District 90096000141 325111 Capt. Nathan Hale School Public Schools Regular School No Middle 06 08 2019   pk_12_total 326 * 24   * *     0   6   170 193     0             49   363 326   24           0   6   170 193     0       49   363
2451910 CT     school 900990 330011   Cromwell School District 90099000147 335111 Cromwell Middle School Public Schools Regular School No Middle 06 08 2019   pk_12_total 339 41 43   0 43     *   *   257 220     10             41   477 339 41 43   0 43             257 220     10       41   477
2451926 CT     school 901020 340011   Danbury School District 90102000149 345111 Broadview Middle School Public Schools Regular School No Middle 06 08 2019   pk_12_total 331 72 479   * 56     0   *   480 497     130             170   977 331 72 479     56     0       480 497     130       170   977
2451927 CT     school 901020 340011   Danbury School District 90102000160 345211 Rogers Park Middle School Public Schools Regular School No Middle 06 08 2019   pk_12_total 253 68 579   0 53     *   *   499 480     267             139   979 253 68 579   0 53             499 480     267       139   979
2451928 CT     school 901020 340011   Danbury School District 90102001691 340311 Westside Middle School Academy Public Schools Regular School No Middle 06 08 2019   pk_12_total 283 40 242   * 53     0   *   329 310     42             52   639 283 40 242     53     0       329 310     42       52   639
2451937 CT     school 901050 350011   Darien School District 90105000169 355111 Middlesex Middle School Public Schools Regular School No Middle 06 08 2019   pk_12_total 947 * 61   * 57     0   27   552 549     *             152   1101 947   61     57     0   27   552 549             152   1101
2451942 CT     school 901110 370011   Derby School District 90111001578 375011 Derby Middle School Public Schools Regular School No Middle 06 08 2019   pk_12_total 147 56 109   0 *     *   18   167 174     6             69   341 147 56 109   0           18   167 174     6       69   341
2451947 CT     school 901170 400011   East Granby School District 90117000182 405111 East Granby Middle School Public Schools Regular School No Middle 06 08 2019   pk_12_total 155 16 *   0 16     0   *   107 94     0             29   201 155 16     0 16     0       107 94     0       29   201
2451950 CT     school 901200 410011   East Haddam School District 90120000198 415111 Nathan Hale-Ray Middle School Public Schools Regular School No Middle 04 08 2019   pk_12_total 327 * 16   * 6     0   *   188 172     0             51   360 327   16     6     0       188 172     0       51   360
2451954 CT     school 901230 420011   East Hampton School District 90123000188 425111 East Hampton Middle School Public Schools Regular School No Middle 06 08 2019   pk_12_total 415 * 28   0 *     *   10   233 232     *             58   465 415   28   0           10   233 232             58   465
2451967 CT     school 901260 430011   East Hartford School District 90126000197 435111 East Hartford Middle School Public Schools Regular School No Middle 06 08 2019   pk_12_total 107 321 519   * 42     *   60   537 514     120             203   1051 107 321 519     42         60   537 514     120       203   1051
2451968 CT     school 901260 430011   East Hartford School District 90126001275 432411 Sunset Ridge Middle School Public Schools Regular School No Middle 06 08 2019   pk_12_total 46 92 152   * *     0   18   152 171     9             50   323 46 92 152           0   18   152 171     9       50   323
2451978 CT     school 901290 440011   East Haven School District 90129000217 445111 Joseph Melillo Middle School Public Schools Regular School No Middle 06 08 2019   pk_12_total 285 36 166   * 18     0   *   241 270     41             81   511 285 36 166     18     0       241 270     41       81   511
2451984 CT     school 901320 450011   East Lyme School District 90132000224 455111 East Lyme Middle School Public Schools Regular School No Middle 05 08 2019   pk_12_total 617 * 62   * 75     0   38   412 391     6             110   803 617   62     75     0   38   412 391     6       110   803
2451989 CT     school 901350 470011   East Windsor School District 90135000230 475411 East Windsor Middle School Public Schools Regular School No Middle 05 08 2019   pk_12_total 180 42 77   * 11     0   *   162 157     9             63   319 180 42 77     11     0       162 157     9       63   319
2451998 CT     school 901410 460011   Easton School District 90141000233 465111 Helen Keller Middle School Public Schools Regular School No Middle 06 08 2019   pk_12_total 281 * 21   * 18     0   9   156 176     0             40   332 281   21     18     0   9   156 176     0       40   332
2452008 CT     school 901440 480011   Ellington School District 90144000238 485111 Ellington Middle School Public Schools Regular School No Middle 07 08 2019   pk_12_total 352 20 *   * 43     0   13   225 213     *             56   438 352 20       43     0   13   225 213             56   438
2452029 CT     school 901470 490011   Enfield School District 90147000249 495211 John F. Kennedy Middle School Public Schools Regular School No Middle 06 08 2019   pk_12_total 791 68 194   * 40     *   50   598 551     18             167   1149 791 68 194     40         50   598 551     18       167   1149
2452047 CT     school 901530 510011   Fairfield School District 90153000258 515211 Fairfield Woods Middle School Public Schools Regular School No Middle 06 08 2019   pk_12_total 697 24 96   0 62     0   31   457 453     10             115   910 697 24 96   0 62     0   31   457 453     10       115   910
2452048 CT     school 901530 510011   Fairfield School District 90153000919 515311 Roger Ludlowe Middle School Public Schools Regular School No Middle 06 08 2019   pk_12_total 711 7 55   0 32     0   25   442 388     *             99   830 711 7 55   0 32     0   25   442 388             99   830
2452049 CT     school 901530 510011   Fairfield School District 90153000271 515111 Tomlinson Middle School Public Schools Regular School No Middle 06 08 2019   pk_12_total 449 * 113   * 53     0   33   339 323     27             88   662 449   113     53     0   33   339 323     27       88   662
2452059 CT     school 901560 520011   Farmington School District 90156001368 520511 West Woods Upper Elementary School Public Schools Regular School No Middle 04 06 2019   pk_12_total 373 41 58   * 166     0   *   346 315     19             81   661 373 41 58     166     0       346 315     19       81   661
2452060 CT     school 901560 520011   Farmington School District 90156000274 525111 Irving A. Robbins Middle School Public Schools Regular School No Middle 06 08 2019   pk_12_total 405 27 54   0 156     0   13   333 322     8             78   655 405 27 54   0 156     0   13   333 322     8       78   655
2452071 CT     school 901620 540011   Glastonbury School District 90162000279 540811 Gideon Welles School Public Schools Regular School No Middle 06 06 2019   pk_12_total 316 13 54   0 54     0   31   223 245     6             44   468 316 13 54   0 54     0   31   223 245     6       44   468
2452072 CT     school 901620 540011   Glastonbury School District 90162000282 545211 Smith Middle School Public Schools Regular School No Middle 06 08 2019   pk_12_total 681 * 86   * 108     0   45   * 495     *             112   952 681   86     108     0   45     495             112   952
2452077 CT     school 901680 560011   Granby School District 90168000291 565111 Granby Memorial Middle School Public Schools Regular School No Middle 06 08 2019   pk_12_total 354 18 15   * *     0   15   196 211     0             66   407 354 18 15           0   15   196 211     0       66   407
2452090 CT     school 901710 570011   Greenwich School District 90171000295 575111 Central Middle School Public Schools Regular School No Middle 06 08 2019   pk_12_total 376 14 122   0 39     0   32   296 287     25             72   583 376 14 122   0 39     0   32   296 287     25       72   583
2452091 CT     school 901710 570011   Greenwich School District 90171000298 575211 Eastern Middle School Public Schools Regular School No Middle 06 08 2019   pk_12_total 613 11 103   0 86     0   32   417 428     8             110   845 613 11 103   0 86     0   32   417 428     8       110   845
2452092 CT     school 901710 570011   Greenwich School District 90171000309 575311 Western Middle School Public Schools Regular School No Middle 06 08 2019   pk_12_total 280 38 249   * 46     0   *   323 315     34             93   638 280 38 249     46     0       323 315     34       93   638
2452097 CT     school 901740 580011   Griswold School District 90174000019 585111 Griswold Middle School Public Schools Regular School No Middle 05 08 2019   pk_12_total 427 17 42   * *     0   39   279 257     *             89   536 427 17 42           0   39   279 257             89   536
2452106 CT     school 901770 590011   Groton School District 90177000312 595311 Carl C. Cutler Middle School   Regular School No Middle 06 08 2019   pk_12_total 310 22 85   * 26     *   44   * 266     6             80   494 310 22 85     26         44     266     6       80   494
2452107 CT     school 901770 590011   Groton School District 90177000326 595211 West Side Middle School   Regular School No Middle 06 08 2019   pk_12_total 211 48 139   * 22     *   52   264 212     19             94   476 211 48 139     22         52   264 212     19       94   476
2452116 CT     school 901800 600011   Guilford School District 90180000328 600711 A. Baldwin Middle School Public Schools Regular School No Middle 05 06 2019   pk_12_total 413 8 40   0 22     0   19   270 232     11             67   502 413 8 40   0 22     0   19   270 232     11       67   502
2452117 CT     school 901800 600011   Guilford School District 90180000331 605111 E. C. Adams Middle School Public Schools Regular School No Middle 07 09 2019   pk_12_total 473 * 47   * 27     *   24   303 276     *             62   579 473   47     27         24   303 276             62   579
2452135 CT     school 901860 620011   Hamden School District 90186000342 625211 Hamden Middle School Public Schools Regular School No Middle 07 08 2019   pk_12_total 323 292 181   0 54     0   50   482 418     30             167   900 323 292 181   0 54     0   50   482 418     30       167   900
2452182 CT     school 901920 640011   Hartford School District 90192001582 644011 Renzulli Gifted and Talented Academy Public Schools Regular School No Middle 04 08 2019   pk_12_total 9 53 49   * *     0   6   64 59     *             *   123 9 53 49           0   6   64 59                 123
2452183 CT     school 901920 640011   Hartford School District 90192001616 643811 Betances STEM Magnet School Public Schools Regular School No Middle 05 08 2019   pk_12_total 46 78 151   0 23     *   *   190 *     37             47   308 46 78 151   0 23             190       37       47   308
2452186 CT     school 901920 640011   Hartford School District 90192000369 641611 M. L. King, Jr. Middle School Public Schools Regular School No Middle 06 08 2019   pk_12_total * 133 43   0 *     0   *   101 81     18             45   182   133 43   0       0       101 81     18       45   182
2452187 CT     school 901920 640011   Hartford School District 90192000371 641211 McDonough Middle School Public Schools Regular School No Middle 06 08 2019   pk_12_total * 35 249   0 *     0   0   162 132     92             69   294   35 249   0       0   0   162 132     92       69   294
2452218 CT     school 902070 690011   Killingly School District 90207000393 695211 Killingly Intermediate School Public Schools Regular School No Middle 05 08 2019   pk_12_total 515 15 60   * 24     *   31   315 333     9             87   648 515 15 60     24         31   315 333     9       87   648
2452228 CT     school 903450 2450014   Learn 90345001556 2455014 Dual Language & Arts Magnet Middle School   Regular School No Middle 06 08 2019   pk_12_total 42 16 65   0 *     *   21   65 81     17             28   146 42 16 65   0           21   65 81     17       28   146
2452237 CT     school 902130 710011   Lebanon School District 90213000028 715111 Lebanon Middle School Public Schools Regular School No Middle 05 08 2019   pk_12_total 257 * 20   * 7     *   *   148 151     *             50   299 257   20     7             148 151             50   299
2452243 CT     school 902160 720011   Ledyard School District 90216000402 725111 Ledyard Middle School Public Schools Regular School No Middle 07 08 2019   pk_12_total 257 24 53   18 *     *   19   206 176     6             75   382 257 24 53   18           19   206 176     6       75   382
2452248 CT     school 902220 740011   Litchfield School District 90222000407 740311 Litchfield Intermediate School Public Schools Regular School No Middle 04 06 2019   pk_12_total 172 0 10   0 *     0   *   97 93     *             32   190 172 0 10   0       0       97 93             32   190
2452249 CT     school 902220 740011   Litchfield School District 90222001809 746011 Litchfield Middle School Public Schools Regular School No Middle 07 08 2019   pk_12_total 122 0 6   0 *     *   *   82 56     0             25   138 122 0 6   0               82 56     0       25   138
2452255 CT     school 902280 760011   Madison School District 90228001382 760611 Dr. Robert H. Brown Intermediate School Public Schools Regular School No Middle 05 06 2019   pk_12_total 321 * 17   * 15     *   22   193 187     *             54   380 321   17     15         22   193 187             54   380
2452256 CT     school 902280 760011   Madison School District 90228001480 765211 Walter C. Polson Middle School Public Schools Regular School No Middle 07 08 2019   pk_12_total 364 * 24   0 *     0   21   236 *     *             64   423 364   24   0       0   21   236               64   423
2452269 CT     school 902310 770011   Manchester School District 90231001533 771711 Elisabeth M. Bennet Academy Public Schools Regular School No Middle 05 06 2019   pk_12_total 289 233 296   * 75     *   27   467 455     58             136   922 289 233 296     75         27   467 455     58       136   922
2452271 CT     school 902310 770011   Manchester School District 90231000421 775311 Illing Middle School Public Schools Regular School No Middle 07 08 2019   pk_12_total 285 181 243   6 52     0   36   423 380     40             122   803 285 181 243   6 52     0   36   423 380     40       122   803
2452280 CT     school 902340 780011   Mansfield School District 90234000433 785111 Mansfield Middle School Public Schools Regular School No Middle 05 08 2019   pk_12_total 383 * 70   * 63     0   24   267 286     11             63   553 383   70     63     0   24   267 286     11       63   553
2452294 CT     school 902400 800011   Meriden School District 90240000447 805211 Lincoln Middle School Public Schools Regular School No Middle 06 08 2019   pk_12_total 193 93 436   * *     0   23   391 370     132             138   761 193 93 436           0   23   391 370     132       138   761

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