Data source: Big Local News · About: Big Local

1,461 rows where grade = "pk_12_total", state = "CT" and year = 2020 sorted by school_state_type descending

View and edit SQL

year

  • 2020 · 1,461

grade

  • pk_12_total · 1,461
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
2779122 CT     school   3470015   Unified School District #2 90000400475 3470115 Children's Place School State Agency Facilities           2020   pk_12_total * * 11   0 0     0   0   22 0     *             *   22     11   0 0     0   0   22 0                 22
2779123 CT     school   3470015   Unified School District #2 90000400479 3470315 Riverview School State Agency Facilities           2020   pk_12_total 23 12 *   0 0     0   *   12 34     *             39   46 23 12     0 0     0       12 34             39   46
2779143 CT     school   3360015   Unified School District #1 90000300404 3361115 Manson Youth Institution State Agency Facilities           2020   pk_12_total 13 54 40   0 0     0   6   113 0     *             93   113 13 54 40   0 0     0   6   113 0             93   113
2779144 CT     school   3360015   Unified School District #1 90000300844 3362415 Corrigan/Radgowski Correctional Institution State Agency Facilities           2020   pk_12_total * * *   0 0     0   0   7 0     *             7   7         0 0     0   0   7 0             7   7
2779145 CT     school   3360015   Unified School District #1 90000300849 3362515 York Correctional Institution State Agency Facilities           2020   pk_12_total * 6 *   0 0     0   0   0 9     0             9   9   6     0 0     0   0   0 9     0       9   9
2779146 CT     school   3360015   Unified School District #1 90000300343 3360115 Bridgeport Correctional Center State Agency Facilities           2020   pk_12_total 0 0 *   0 0     0   0   * 0     0             *   * 0 0     0 0     0   0     0     0            
2779147 CT     school   3360015   Unified School District #1 90000300347 3360315 Cheshire Correctional Institution State Agency Facilities           2020   pk_12_total 0 * *   0 0     0   0   6 0     0             6   6 0       0 0     0   0   6 0     0       6   6
2779148 CT     school   3360015   Unified School District #1 90000300469 3362215 MacDougall/Walker Correctional Institution State Agency Facilities           2020   pk_12_total 0 * *   0 0     0   0   9 0     0             9   9 0       0 0     0   0   9 0     0       9   9
2779149 CT     school   3360015   Unified School District #1 90000301349 3362615 Northern Correctional Institution State Agency Facilities           2020   pk_12_total 0 * 0   0 0     0   0   * 0     0             *   * 0   0   0 0     0   0     0     0            
2779150 CT     school   3360015   Unified School District #1 90000300454 3361915 Garner Correctional Institution State Agency Facilities           2020   pk_12_total 0 * 0   0 0     0   0   * 0     0             *   * 0   0   0 0     0   0     0     0            
2779151 CT     school   3360015   Unified School District #1 90000300361 3360615 Hartford Correctional Center State Agency Facilities           2020   pk_12_total 0 0 *   0 0     0   0   * 0     0             *   * 0 0     0 0     0   0     0     0            
2779152 CT     school   3360015   Unified School District #1 90000300408 3361215 Osborn Correctional Institution State Agency Facilities           2020   pk_12_total 0 * *   0 0     0   0   * 0     0             *   * 0       0 0     0   0     0     0            
2779153 CT     school   3360015   Unified School District #1 90000300436 3361515 Willard/Cybulski Correctional Institution State Agency Facilities           2020   pk_12_total 0 * 0   0 0     0   0   * 0     0             *   * 0   0   0 0     0   0     0     0            
2779154 CT     school   3360015   Unified School District #1 90000300419 3361315 Robinson Correctional Institution State Agency Facilities           2020   pk_12_total 0 * 0   0 0     0   0   * 0     0             *   * 0   0   0 0     0   0     0     0            
2779183 CT     school   3370015   Department of Mental Health and Addiction Services 90002701539 3370215 Connecticut Valley Hospital State Agency Facilities           2020   pk_12_total * * *   0 0     0   0   * *     0             *   *         0 0     0   0           0            
2779184 CT     school   3370015   Department of Mental Health and Addiction Services 90002701537 3370515 Greater Bridgeport Community Mental Health Center State Agency Facilities           2020   pk_12_total 0 0 *   0 0     0   0   * 0     0             *   * 0 0     0 0     0   0     0     0            
2779185 CT     school   3370015   Department of Mental Health and Addiction Services 90002701922 3370915 Whiting Forensic Hospital State Agency Facilities           2020   pk_12_total 0 0 *   0 0     0   0   0 *     0             *   * 0 0     0 0     0   0   0       0            
2778629 CT     school 903515 2060012   Regional School District 06 90351500723 2060112 Goshen Center School Regional Schools Regular School No Elementary PK 06 2020   pk_12_total 172 * 6   0 *     0   11   94 98     6             28   192 172   6   0       0   11   94 98     6       28   192
2778630 CT     school 903515 2060012   Regional School District 06 90351500724 2060212 James Morris School Regional Schools Regular School No Elementary PK 06 2020   pk_12_total 111 * 9   0 0     0   *   63 *     *             29   126 111   9   0 0     0       63               29   126
2778631 CT     school 903515 2060012   Regional School District 06 90351500726 2060312 Warren Elementary School Regional Schools Regular School No Elementary PK 06 2020   pk_12_total 78 0 *   0 *     0   *   50 34     0             7   84 78 0     0       0       50 34     0       7   84
2778632 CT     school 903515 2060012   Regional School District 06 90351500725 2066112 Wamogo Regional High School Regional Schools Regular School No High 07 12 2020   pk_12_total 461 7 20   * *     *   9   215 293     *             86   508 461 7 20               9   215 293             86   508
2778634 CT     school 903520 2100012   Regional School District 10 90352000728 2100312 Harwinton Consolidated School Regional Schools Regular School No Elementary PK 04 2020   pk_12_total 308 * *   0 0     0   30   180 177     *             50   357 308       0 0     0   30   180 177             50   357
2778635 CT     school 903520 2100012   Regional School District 10 90352000729 2100212 Lake Garda Elementary School Regional Schools Regular School No Elementary PK 04 2020   pk_12_total 356 * 19   0 *     0   49   232 202     24             55   434 356   19   0       0   49   232 202     24       55   434
2778636 CT     school 903520 2100012   Regional School District 10 90352000727 2105112 Har-Bur Middle School Regional Schools Regular School No Middle 05 08 2020   pk_12_total 628 * 27   * 8     0   47   391 325     *             102   716 628   27     8     0   47   391 325             102   716
2778637 CT     school 903520 2100012   Regional School District 10 90352000730 2106112 Lewis S. Mills High School Regional Schools Regular School No High 09 12 2020   pk_12_total 598 7 38   0 10     0   65   358 360     *             74   718 598 7 38   0 10     0   65   358 360             74   718
2778638 CT     school 903530 2120012   Regional School District 12 90353000735 2120412 Washington Primary School Regional Schools Regular School No Elementary PK 05 2020   pk_12_total 119 0 *   0 0     0   *   55 83     *             11   138 119 0     0 0     0       55 83             11   138
2778639 CT     school 903530 2120012   Regional School District 12 90353000731 2120212 Booth Free School Regional Schools Regular School No Elementary KG 05 2020   pk_12_total 65 * *   0 *     0   *   32 39     *             10   71 65       0       0       32 39             10   71
2778640 CT     school 903530 2120012   Regional School District 12 90353000734 2120112 The Burnham School Regional Schools Regular School No Elementary KG 05 2020   pk_12_total 54 0 *   0 *     0   *   31 29     0             6   60 54 0     0       0       31 29     0       6   60
2778641 CT     school 903530 2120012   Regional School District 12 90353001632 2120312 Shepaug Valley School Regional Schools Regular School No High 06 12 2020   pk_12_total 381 * 34   0 *     0   6   213 219     *             68   432 381   34   0       0   6   213 219             68   432
2778643 CT     school 903535 2130012   Regional School District 13 90353500740 2130112 Frederick Brewster School Regional Schools Regular School No Elementary PK 03 2020   pk_12_total 261 0 13   * *     0   6   140 143     *             52   283 261 0 13           0   6   140 143             52   283
2778644 CT     school 903535 2130012   Regional School District 13 90353500741 2130512 John Lyman School Regional Schools Regular School No Elementary KG 04 2020   pk_12_total 187 0 16   0 *     0   *   108 106     *             39   214 187 0 16   0       0       108 106             39   214
2778645 CT     school 903535 2130012   Regional School District 13 90353500742 2130412 Middlefield Memorial School Regional Schools Regular School No Middle 04 06 2020   pk_12_total 222 * 22   0 *     0   8   119 140     *             49   259 222   22   0       0   8   119 140             49   259
2778646 CT     school 903535 2130012   Regional School District 13 90353500739 2135112 Frank Ward Strong School Regional Schools Regular School No Middle 05 08 2020   pk_12_total 216 * 21   0 *     0   12   121 134     *             50   255 216   21   0       0   12   121 134             50   255
2778647 CT     school 903535 2130012   Regional School District 13 90353500737 2136112 Coginchaug Regional High School Regional Schools Regular School No High 09 12 2020   pk_12_total 433 * 27   0 12     0   *   245 *     0             71   484 433   27   0 12     0       245       0       71   484
2778649 CT     school 903536 2140012   Regional School District 14 90353600743 2140112 Bethlehem Elementary School Regional Schools Regular School No Elementary PK 05 2020   pk_12_total 249 * 10   * *     0   6   141 131     *             44   272 249   10           0   6   141 131             44   272
2778650 CT     school 903536 2140012   Regional School District 14 90353600744 2140212 Mitchell Elementary School Regional Schools Regular School No Elementary PK 05 2020   pk_12_total 280 * 30   0 *     0   13   169 166     10             48   335 280   30   0       0   13   169 166     10       48   335
2778651 CT     school 903536 2140012   Regional School District 14 90353600746 2145112 Woodbury Middle School Regional Schools Regular School No Middle 06 08 2020   pk_12_total 279 * 21   * 7     0   *   151 162     *             56   313 279   21     7     0       151 162             56   313
2778652 CT     school 903536 2140012   Regional School District 14 90353600745 2146112 Nonnewaug High School Regional Schools Regular School No High 09 12 2020   pk_12_total 603 7 34   * 11     0   *   284 379     *             96   663 603 7 34     11     0       284 379             96   663
2778654 CT     school 903537 2150012   Regional School District 15 90353700708 2150712 Long Meadow Elementary School Regional Schools Regular School No Elementary PK 05 2020   pk_12_total 442 14 28   0 28     0   20   280 252     *             109   532 442 14 28   0 28     0   20   280 252             109   532
2778655 CT     school 903537 2150012   Regional School District 15 90353701116 2150412 Gainfield Elementary School Regional Schools Regular School No Elementary KG 05 2020   pk_12_total 297 * 24   * 19     0   9   169 187     8             41   356 297   24     19     0   9   169 187     8       41   356
2778656 CT     school 903537 2150012   Regional School District 15 90353701200 2150612 Middlebury Elementary School Regional Schools Regular School No Elementary KG 05 2020   pk_12_total 285 * 20   0 20     0   *   174 157     18             48   331 285   20   0 20     0       174 157     18       48   331
2778657 CT     school 903537 2150012   Regional School District 15 90353700750 2150512 Pomperaug School Regional Schools Regular School No Elementary KG 05 2020   pk_12_total 305 8 33   0 14     0   11   218 153     *             63   371 305 8 33   0 14     0   11   218 153             63   371
2778658 CT     school 903537 2150012   Regional School District 15 90353700748 2155212 Memorial Middle School Regional Schools Regular School No Middle 06 08 2020   pk_12_total 380 * 20   0 24     *   13   226 221     *             76   447 380   20   0 24         13   226 221             76   447
2778659 CT     school 903537 2150012   Regional School District 15 90353700751 2155112 Rochambeau Middle School Regional Schools Regular School No Middle 06 08 2020   pk_12_total 331 * 22   * 20     0   12   201 196     *             80   397 331   22     20     0   12   201 196             80   397
2778660 CT     school 903537 2150012   Regional School District 15 90353700749 2156212 Pomperaug Regional High School Regional Schools Regular School No High 09 12 2020   pk_12_total 1028 15 71   * 65     *   21   607 601     6             197   1208 1028 15 71     65         21   607 601     6       197   1208
2778662 CT     school 903538 2160012   Regional School District 16 90353801811 2160512 Prospect Elementary School Regional Schools Regular School No Elementary PK 05 2020   pk_12_total 537 18 *   0 *     0   21   306 289     9             69   595 537 18     0       0   21   306 289     9       69   595
2778663 CT     school 903538 2160012   Regional School District 16 90353800755 2160112 Laurel Ledge School Regional Schools Regular School No Elementary KG 05 2020   pk_12_total 220 8 35   0 6     0   10   139 140     10             33   279 220 8 35   0 6     0   10   139 140     10       33   279
2778664 CT     school 903538 2160012   Regional School District 16 90353800756 2165112 Long River Middle School Regional Schools Regular School No Middle 06 08 2020   pk_12_total 447 16 40   0 *     0   *   256 257     *             70   513 447 16 40   0       0       256 257             70   513
2778666 CT     school 903538 2160012   Regional School District 16 90353801356 2166012 Woodland Regional High School Regional Schools Regular School No High 09 12 2020   pk_12_total 590 28 48   * 10     0   *   350 331     *             86   681 590 28 48     10     0       350 331             86   681
2778667 CT     school 903539 2170012   Regional School District 17 90353900757 2170212 Burr District Elementary School Regional Schools Regular School No Elementary PK 03 2020   pk_12_total 327 * 12   0 *     0   11   185 177     *             71   362 327   12   0       0   11   185 177             71   362
2778668 CT     school 903539 2170012   Regional School District 17 90353900760 2170312 Killingworth Elementary School Regional Schools Regular School No Elementary KG 03 2020   pk_12_total 191 0 6   0 0     0   7   89 115     *             34   204 191 0 6   0 0     0   7   89 115             34   204
2778669 CT     school 903539 2170012   Regional School District 17 90353901921 2170512 Haddam-Killingworth Intermediate School Regional Schools Regular School No Elementary 04 05 2020   pk_12_total 235 * 16   0 *     0   *   142 119     *             45   261 235   16   0       0       142 119             45   261
2778670 CT     school 903539 2170012   Regional School District 17 90353901201 2175112 Haddam-Killingworth Middle School Regional Schools Regular School No Middle 06 08 2020   pk_12_total 430 * 14   0 *     0   17   255 221     *             82   476 430   14   0       0   17   255 221             82   476
2778671 CT     school 903539 2170012   Regional School District 17 90353900759 2176112 Haddam-Killingworth High School Regional Schools Regular School No High 09 12 2020   pk_12_total 590 7 15   0 11     0   14   326 311     *             92   637 590 7 15   0 11     0   14   326 311             92   637
2778673 CT     school 903540 2180012   Regional School District 18 90354000761 2180312 Center School Regional Schools Special Education School No Prekindergarten PK PK 2020   pk_12_total * 0 *   0 0     0   0   37 34     0             12   71   0     0 0     0   0   37 34     0       12   71
2778674 CT     school 903540 2180012   Regional School District 18 90354000762 2180112 Lyme Consolidated School Regional Schools Regular School No Elementary KG 05 2020   pk_12_total 173 0 13   0 *     *   11   117 85     8             27   202 173 0 13   0           11   117 85     8       27   202
2778675 CT     school 903540 2180012   Regional School District 18 90354000764 2180212 Mile Creek School Regional Schools Regular School No Elementary KG 05 2020   pk_12_total 219 * 15   0 *     0   12   132 125     9             38   257 219   15   0       0   12   132 125     9       38   257
2778676 CT     school 903540 2180012   Regional School District 18 90354001123 2185112 Lyme-Old Lyme Middle School Regional Schools Regular School No Middle 06 08 2020   pk_12_total 240 * 16   0 9     0   *   128 150     6             52   278 240   16   0 9     0       128 150     6       52   278
2778677 CT     school 903540 2180012   Regional School District 18 90354000763 2186112 Lyme-Old Lyme High School Regional Schools Regular School No High 09 12 2020   pk_12_total 428 * 29   0 12     0   *   245 234     7             44   479 428   29   0 12     0       245 234     7       44   479
2779118 CT     school 903600 2010012   Regional School District 01 90360000766 2016112 Housatonic Valley Regional High School Regional Schools Regular School No High 09 12 2020   pk_12_total 279 * 53   0 *     0   15   181 175     6             56   356 279   53   0       0   15   181 175     6       56   356
2779124 CT     school 903630 2040012   Regional School District 04 90363000767 2045112 John Winthrop Middle School Regional Schools Regular School No Middle 07 08 2020   pk_12_total 220 * 24   0 *     0   9   133 124     *             52   257 220   24   0       0   9   133 124             52   257
2779125 CT     school 903630 2040012   Regional School District 04 90363000768 2046112 Valley Regional High School Regional Schools Regular School No High 09 12 2020   pk_12_total 528 * 19   * 15     0   15   281 302     6             86   583 528   19     15     0   15   281 302     6       86   583
2779127 CT     school 903660 2050012   Regional School District 05 90366001114 2055112 Amity Middle School: Bethany Regional Schools Regular School No Middle 07 08 2020   pk_12_total 240 12 19   0 54     0   15   174 166     *             47   340 240 12 19   0 54     0   15   174 166             47   340
2779128 CT     school 903660 2050012   Regional School District 05 90366000769 2055212 Amity Middle School: Orange Regional Schools Regular School No Middle 07 08 2020   pk_12_total 278 6 17   0 51     0   13   195 170     *             39   365 278 6 17   0 51     0   13   195 170             39   365
2779129 CT     school 903660 2050012   Regional School District 05 90366000770 2056112 Amity Regional High School Regional Schools Regular School No High 09 12 2020   pk_12_total 1087 54 28   * 219     *   61   723 732     10             176   1455 1087 54 28     219         61   723 732     10       176   1455
2779132 CT     school 903720 2070012   Regional School District 07 90372001226 2075112 Northwestern Regional Middle School Regional Schools Regular School No Middle 07 08 2020   pk_12_total 281 0 7   0 *     0   *   152 146     0             47   298 281 0 7   0       0       152 146     0       47   298
2779135 CT     school 903720 2070012   Regional School District 07 90372000771 2076112 Northwestern Regional High School Regional Schools Regular School No High 09 12 2020   pk_12_total 609 6 14   0 *     *   10   296 351     *             73   647 609 6 14   0           10   296 351             73   647
2779138 CT     school 903750 2080012   Regional School District 08 90375001210 2085112 RHAM Middle School Regional Schools Regular School No Middle 07 08 2020   pk_12_total 402 * 33   0 8     0   *   236 214     *             65   450 402   33   0 8     0       236 214             65   450
2779139 CT     school 903750 2080012   Regional School District 08 90375000772 2086112 RHAM High School Regional Schools Regular School No High 09 12 2020   pk_12_total 864 12 37   * 20     *   6   477 464     *             119   941 864 12 37     20         6   477 464             119   941
2779140 CT     school 903570 2110012   Regional School District 11 90357000765 2116112 Parish Hill High School Regional Schools Regular School No High 07 12 2020   pk_12_total 176 * 14   0 0     0   *   115 88     *             37   203 176   14   0 0     0       115 88             37   203
2779177 CT     school 903780 2090012   Regional School District 09 90378000773 2096112 Joel Barlow High School Regional Schools Regular School No High 09 12 2020   pk_12_total 712 7 59   0 33     0   44   430 425     *             105   855 712 7 59   0 33     0   44   430 425             105   855
2779178 CT     school 900005 2190012   Regional School District 19 90000501215 2196112 E. O. Smith High School Regional Schools Regular School No High 09 12 2020   pk_12_total 784 11 104   * 47     *   112   501 561     7             144   1062 784 11 104     47         112   501 561     7       144   1062
2777736 CT     school 900070 2440014   Area Cooperative Educational Services 90007000884 2440314 Wintergreen Interdistrict Magnet School Regional Education Service Center Schools Regular School No Elementary KG 08 2020   pk_12_total 113 237 124   * 19     *   20   242 273     50             71   515 113 237 124     19         20   242 273     50       71   515
2777739 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 2020   pk_12_total 144 100 381   * 36     0   *   342 356     67             79   698 144 100 381     36     0       342 356     67       79   698
2777877 CT     school 900700 2410014   Capitol Region Education Council 90070001629 2410714 Academy of Aerospace and Engineering Elementary Regional Education Service Center Schools Regular School No Elementary PK 05 2020   pk_12_total 105 123 149   * 84     *   16   250 230     90             67   480 105 123 149     84         16   250 230     90       67   480
2777878 CT     school 900700 2410014   Capitol Region Education Council 90070001623 2410614 Ana Grace Academy of the Arts Elementary School Regional Education Service Center Schools Regular School No Elementary PK 05 2020   pk_12_total 106 123 215   * 9     *   23   174 304     27             86   478 106 123 215     9         23   174 304     27       86   478
2777879 CT     school 900700 2410014   Capitol Region Education Council 90070001597 2418114 Discovery Academy Regional Education Service Center Schools Regular School No Elementary PK 05 2020   pk_12_total 164 76 223   * 31     0   *   268 252     49             61   520 164 76 223     31     0       268 252     49       61   520
2777880 CT     school 900700 2410014   Capitol Region Education Council 90070000072 2410114 Glastonbury/East Hartford Magnet School Regional Education Service Center Schools Regular School No Elementary PK 05 2020   pk_12_total 105 107 176   * 50     0   *   228 231     53             68   459 105 107 176     50     0       228 231     53       68   459
2777881 CT     school 900700 2410014   Capitol Region Education Council 90070001511 2410414 International Magnet School for Global Citizenship Regional Education Service Center Schools Regular School No Elementary PK 05 2020   pk_12_total 70 158 155   0 94     0   22   242 257     31             62   499 70 158 155   0 94     0   22   242 257     31       62   499
2777882 CT     school 900700 2410014   Capitol Region Education Council 90070000210 2413114 Montessori Magnet School Regional Education Service Center Schools Regular School No Elementary PK 06 2020   pk_12_total 81 31 210   0 *     *   21   177 177     50             63   354 81 31 210   0           21   177 177     50       63   354
2777883 CT     school 900700 2410014   Capitol Region Education Council 90070001601 2410514 Museum Academy Regional Education Service Center Schools Regular School No Elementary PK 05 2020   pk_12_total 105 222 137   * 28     0   *   261 261     29             48   522 105 222 137     28     0       261 261     29       48   522
2777884 CT     school 900700 2410014   Capitol Region Education Council 90070001516 2410314 Reggio Magnet School of the Arts Regional Education Service Center Schools Regular School No Elementary PK 05 2020   pk_12_total 161 145 179   0 13     0   18   241 275     51             86   516 161 145 179   0 13     0   18   241 275     51       86   516
2777887 CT     school 900700 2410014   Capitol Region Education Council 90070001357 2410214 University of Hartford Magnet School Regional Education Service Center Schools Regular School No Elementary PK 05 2020   pk_12_total 98 217 115   * 22     *   23   229 248     22             90   477 98 217 115     22         23   229 248     22       90   477
2777891 CT     school 900700 2410014   Capitol Region Education Council 90070001513 2415114 Academy of Aerospace and Engineering Regional Education Service Center Schools Regular School No High 06 12 2020   pk_12_total 147 241 287   * 68     0   *   509 261     43             116   770 147 241 287     68     0       509 261     43       116   770
2777892 CT     school 900700 2410014   Capitol Region Education Council 90070001592 2416514 Academy of Science and Innovation Regional Education Service Center Schools Regular School No High 06 12 2020   pk_12_total 162 199 334   * 32     0   *   378 377     52             124   755 162 199 334     32     0       378 377     52       124   755
2777893 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 2020   pk_12_total 63 80 172   0 *     *   17   81 253     21             78   334 63 80 172   0           17   81 253     21       78   334
2777894 CT     school 900700 2410014   Capitol Region Education Council 90070000880 2416114 Metropolitan Learning Center for Global and International Studies Regional Education Service Center Schools Regular School No High 06 12 2020   pk_12_total 116 348 168   * 24     *   37   309 388     19             121   697 116 348 168     24         37   309 388     19       121   697
2777895 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 2020   pk_12_total 120 202 302   * *     0   23   375 291     60             136   666 120 202 302           0   23   375 291     60       136   666
2777898 CT     school 900700 2410014   Capitol Region Education Council 90070001532 2415214 Civic Leadership High School Regional Education Service Center Schools Regular School No High 09 12 2020   pk_12_total 64 76 184   * *     *   15   184 164     24             76   348 64 76 184               15   184 164     24       76   348
2777899 CT     school 900700 2410014   Capitol Region Education Council 90070001497 2416414 Greater Hartford Academy of the Arts High School - Full Day Regional Education Service Center Schools Regular School No High 09 12 2020   pk_12_total 113 126 192   0 *     0   *   128 324     15             69   452 113 126 192   0       0       128 324     15       69   452
2777927 CT     school 900910 2430014   Cooperative Educational Services 90091000340 2430114 Six-Six Magnet School Regional Education Service Center Schools Regular School No Elementary PK 08 2020   pk_12_total 109 112 190   * 27     0   *   238 221     36             41   459 109 112 190     27     0       238 221     36       41   459
2778248 CT     school 903450 2450014   Learn 90345001627 2450314 Riverside Magnet School at Goodwin University Regional Education Service Center Schools Regular School No Elementary PK 05 2020   pk_12_total 105 133 194   * 11     *   30   236 240     84             65   476 105 133 194     11         30   236 240     84       65   476
2778249 CT     school 903450 2450014   Learn 90345001430 2450214 The Friendship School Regional Education Service Center Schools Regular School No Elementary PK KG 2020   pk_12_total 184 54 192   0 *     *   55   263 240     23             51   503 184 54 192   0           55   263 240     23       51   503
2778251 CT     school 903450 2450014   Learn 90345000079 2450114 Regional Multicultural Magnet School Regional Education Service Center Schools Regular School No Elementary KG 05 2020   pk_12_total 136 70 210   * 7     *   78   243 262     60             75   505 136 70 210     7         78   243 262     60       75   505
2778256 CT     school 903450 2450014   Learn 90345001581 2456014 Connecticut River Academy at Goodwin University Regional Education Service Center Schools Regular School No High 09 12 2020   pk_12_total 78 99 270   * 17     *   15   226 255     39             81   481 78 99 270     17         15   226 255     39       81   481
2778257 CT     school 903450 2450014   Learn 90345001606 2456114 Marine Science Magnet High School Regional Education Service Center Schools Regular School No High 09 12 2020   pk_12_total 200 * 35   * 11     0   17   135 137     *             26   272 200   35     11     0   17   135 137             26   272
2778258 CT     school 903450 2450014   Learn 90345001617 2456214 Three Rivers Middle College Magnet School Regional Education Service Center Schools Regular School No High 11 12 2020   pk_12_total 45 * 14   * *     0   *   18 49     *             *   67 45   14           0       18 49                 67
2779110 CT     school 901360 2530014   Eastern Connecticut Regional Educational Service Center (EASTCONN) 90136001507 2536014 Arts at the Capitol Theater Magnet School (ACT) Regional Education Service Center Schools Regular School No High 09 12 2020   pk_12_total 90 9 40   0 0     0   11   * 102     *             27   150 90 9 40   0 0     0   11     102             27   150
2779111 CT     school 901360 2530014   Eastern Connecticut Regional Educational Service Center (EASTCONN) 90136001530 2536114 Quinebaug Middle College Regional Education Service Center Schools Regular School No High 09 12 2020   pk_12_total 132 6 30   * *     0   6   66 110     *             29   176 132 6 30           0   6   66 110             29   176
2779113 CT     school 901360 2530014   Eastern Connecticut Regional Educational Service Center (EASTCONN) 90136001937 2530314 LEAP Alternative High School Regional Education Service Center Schools Alternative School No High 10 12 2020   pk_12_total * 0 8   0 0     0   *   * *     *             *   11   0 8   0 0     0                           11

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