Data source: Big Local News · About: Big Local

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

View and edit SQL

year

  • 2021 · 1,444

grade

  • pk_12_total · 1,444
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
2758673 CT     school   3470015   Unified School District #2 90000400479 3470315 Riverview School State Agency Facilities           2021   pk_12_total 10 13 9   0 0     0   0   9 23     *             23   32 10 13 9   0 0     0   0   9 23             23   32
2758674 CT     school   3470015   Unified School District #2 90000400475 3470115 Children's Place School State Agency Facilities           2021   pk_12_total 9 * *   * 0     0   *   19 0     0             *   19 9         0     0       19 0     0           19
2758694 CT     school   3360015   Unified School District #1 90000300404 3361115 Manson Youth Institution State Agency Facilities           2021   pk_12_total * 60 33   0 0     0   *   108 0     *             88   108   60 33   0 0     0       108 0             88   108
2758695 CT     school   3360015   Unified School District #1 90000300844 3362415 Corrigan/Radgowski Correctional Institution State Agency Facilities           2021   pk_12_total * 6 *   0 0     0   0   12 0     *             12   12   6     0 0     0   0   12 0             12   12
2758696 CT     school   3360015   Unified School District #1 90000300849 3362515 York Correctional Institution State Agency Facilities           2021   pk_12_total * * *   0 0     0   0   0 *     0             *   *         0 0     0   0   0       0            
2758697 CT     school   3360015   Unified School District #1 90000300347 3360315 Cheshire Correctional Institution State Agency Facilities           2021   pk_12_total * * *   0 0     0   0   * 0     0             *   *         0 0     0   0     0     0            
2758698 CT     school   3360015   Unified School District #1 90000300454 3361915 Garner Correctional Institution State Agency Facilities           2021   pk_12_total 0 0 *   0 0     0   0   * 0     0             *   * 0 0     0 0     0   0     0     0            
2758699 CT     school   3360015   Unified School District #1 90000300469 3362215 MacDougall/Walker Correctional Institution State Agency Facilities           2021   pk_12_total 0 * *   0 0     0   0   * 0     0             *   * 0       0 0     0   0     0     0            
2758700 CT     school   3360015   Unified School District #1 90000300374 3360915 New Haven Correctional Center State Agency Facilities           2021   pk_12_total 0 * 0   0 0     0   0   * 0     0             *   * 0   0   0 0     0   0     0     0            
2758701 CT     school   3360015   Unified School District #1 90000300408 3361215 Osborn Correctional Institution State Agency Facilities           2021   pk_12_total 0 * 0   0 0     0   *   * 0     0             *   * 0   0   0 0     0         0     0            
2758702 CT     school   3360015   Unified School District #1 90000300343 3360115 Bridgeport Correctional Center State Agency Facilities           2021   pk_12_total 0 0 *   0 0     0   0   * 0     0             *   * 0 0     0 0     0   0     0     0            
2758703 CT     school   3360015   Unified School District #1 90000301349 3362615 Northern Correctional Institution State Agency Facilities           2021   pk_12_total 0 * 0   0 0     0   0   * 0     0             *   * 0   0   0 0     0   0     0     0            
2758722 CT     school   3370015   Department of Mental Health and Addiction Services 90002701922 3370915 Whiting Forensic Hospital State Agency Facilities           2021   pk_12_total 0 * 0   0 0     0   0   * 0     0             *   * 0   0   0 0     0   0     0     0            
2758723 CT     school   3370015   Department of Mental Health and Addiction Services 90002701539 3370215 Connecticut Valley Hospital State Agency Facilities           2021   pk_12_total 0 * 0   0 0     0   0   0 *     0             *   * 0   0   0 0     0   0   0       0            
2758184 CT     school 903515 2060012   Regional School District 06 90351500723 2060112 Goshen Center School Regional Schools Regular School No Elementary PK 06 2021   pk_12_total 172 * 8   0 *     0   10   97 97     7             25   194 172   8   0       0   10   97 97     7       25   194
2758185 CT     school 903515 2060012   Regional School District 06 90351500724 2060212 James Morris School Regional Schools Regular School No Elementary PK 06 2021   pk_12_total 116 * 9   0 0     0   *   65 64     *             26   129 116   9   0 0     0       65 64             26   129
2758186 CT     school 903515 2060012   Regional School District 06 90351500726 2060312 Warren Elementary School Regional Schools Regular School No Elementary PK 06 2021   pk_12_total 60 0 *   0 *     0   *   40 25     0             8   65 60 0     0       0       40 25     0       8   65
2758187 CT     school 903515 2060012   Regional School District 06 90351500725 2066112 Wamogo Regional High School Regional Schools Regular School No High 07 12 2021   pk_12_total 432 8 28   * *     *   9   * 267     *             87   484 432 8 28               9     267             87   484
2758189 CT     school 903520 2100012   Regional School District 10 90352000728 2100312 Harwinton Consolidated School Regional Schools Regular School No Elementary PK 04 2021   pk_12_total 286 * *   0 0     0   54   180 177     *             49   357 286       0 0     0   54   180 177             49   357
2758190 CT     school 903520 2100012   Regional School District 10 90352000729 2100212 Lake Garda Elementary School Regional Schools Regular School No Elementary PK 04 2021   pk_12_total 301 * 19   0 *     0   83   222 187     24             45   409 301   19   0       0   83   222 187     24       45   409
2758191 CT     school 903520 2100012   Regional School District 10 90352000727 2105112 Har-Bur Middle School Regional Schools Regular School No Middle 05 08 2021   pk_12_total 562 * 29   0 *     0   114   375 335     6             96   710 562   29   0       0   114   375 335     6       96   710
2758192 CT     school 903520 2100012   Regional School District 10 90352000730 2106112 Lewis S. Mills High School Regional Schools Regular School No High 09 12 2021   pk_12_total 524 * 34   0 *     0   133   368 335     *             69   703 524   34   0       0   133   368 335             69   703
2758193 CT     school 903530 2120012   Regional School District 12 90353000735 2120412 Washington Primary School Regional Schools Regular School No Elementary PK 05 2021   pk_12_total 96 0 *   0 0     0   *   49 66     *             14   115 96 0     0 0     0       49 66             14   115
2758194 CT     school 903530 2120012   Regional School District 12 90353000731 2120212 Booth Free School Regional Schools Regular School No Elementary KG 05 2021   pk_12_total 64 0 *   0 *     0   6   35 38     *             11   73 64 0     0       0   6   35 38             11   73
2758195 CT     school 903530 2120012   Regional School District 12 90353000734 2120112 The Burnham School Regional Schools Regular School No Elementary KG 05 2021   pk_12_total 53 0 *   0 0     0   *   31 28     0             6   59 53 0     0 0     0       31 28     0       6   59
2758196 CT     school 903530 2120012   Regional School District 12 90353001632 2120312 Shepaug Valley School Regional Schools Regular School No High 06 12 2021   pk_12_total 379 * 40   0 *     0   7   206 228     *             65   434 379   40   0       0   7   206 228             65   434
2758198 CT     school 903535 2130012   Regional School District 13 90353500740 2130112 Frederick Brewster School Regional Schools Regular School No Elementary PK 02 2021   pk_12_total 206 0 9   * *     0   *   109 112     *             41   221 206 0 9           0       109 112             41   221
2758199 CT     school 903535 2130012   Regional School District 13 90353500741 2130512 John Lyman School Regional Schools Regular School No Elementary KG 04 2021   pk_12_total 171 0 20   0 0     0   6   98 99     *             25   197 171 0 20   0 0     0   6   98 99             25   197
2758200 CT     school 903535 2130012   Regional School District 13 90353500742 2130412 Middlefield Memorial School Regional Schools Regular School No Elementary 03 05 2021   pk_12_total 194 0 12   0 *     0   *   114 102     *             52   216 194 0 12   0       0       114 102             52   216
2758201 CT     school 903535 2130012   Regional School District 13 90353500739 2135112 Frank Ward Strong School Regional Schools Regular School No Middle 06 08 2021   pk_12_total 291 * 32   0 *     0   9   160 182     *             69   342 291   32   0       0   9   160 182             69   342
2758202 CT     school 903535 2130012   Regional School District 13 90353500737 2136112 Coginchaug Regional High School Regional Schools Regular School No High 08 12 2021   pk_12_total 395 * 25   0 *     0   13   217 230     0             72   447 395   25   0       0   13   217 230     0       72   447
2758204 CT     school 903536 2140012   Regional School District 14 90353600743 2140112 Bethlehem Elementary School Regional Schools Regular School No Elementary PK 05 2021   pk_12_total 242 * 18   * *     0   11   144 136     *             57   280 242   18           0   11   144 136             57   280
2758205 CT     school 903536 2140012   Regional School District 14 90353600744 2140212 Mitchell Elementary School Regional Schools Regular School No Elementary PK 05 2021   pk_12_total 263 * 32   0 *     0   16   160 163     10             40   323 263   32   0       0   16   160 163     10       40   323
2758206 CT     school 903536 2140012   Regional School District 14 90353600746 2145112 Woodbury Middle School Regional Schools Regular School No Middle 06 08 2021   pk_12_total 259 * 28   * *     0   *   148 148     *             49   296 259   28           0       148 148             49   296
2758207 CT     school 903536 2140012   Regional School District 14 90353600745 2146112 Nonnewaug High School Regional Schools Regular School No High 09 12 2021   pk_12_total 602 * 44   * 10     0   9   296 380     *             97   676 602   44     10     0   9   296 380             97   676
2758208 CT     school 903537 2150012   Regional School District 15 90353700708 2150712 Long Meadow Elementary School Regional Schools Regular School No Elementary PK 05 2021   pk_12_total 400 14 30   0 29     0   24   265 232     7             112   497 400 14 30   0 29     0   24   265 232     7       112   497
2758209 CT     school 903537 2150012   Regional School District 15 90353701116 2150412 Gainfield Elementary School Regional Schools Regular School No Elementary KG 05 2021   pk_12_total 294 * 29   * 11     0   10   173 181     6             47   354 294   29     11     0   10   173 181     6       47   354
2758210 CT     school 903537 2150012   Regional School District 15 90353701200 2150612 Middlebury Elementary School Regional Schools Regular School No Elementary KG 05 2021   pk_12_total 264 * 20   0 20     0   *   158 151     20             48   309 264   20   0 20     0       158 151     20       48   309
2758211 CT     school 903537 2150012   Regional School District 15 90353700750 2150512 Pomperaug School Regional Schools Regular School No Elementary KG 05 2021   pk_12_total 302 7 32   0 16     0   12   219 150     7             63   369 302 7 32   0 16     0   12   219 150     7       63   369
2758212 CT     school 903537 2150012   Regional School District 15 90353700748 2155212 Memorial Middle School Regional Schools Regular School No Middle 06 08 2021   pk_12_total 365 * 20   0 28     *   10   225 208     *             76   433 365   20   0 28         10   225 208             76   433
2758213 CT     school 903537 2150012   Regional School District 15 90353700751 2155112 Rochambeau Middle School Regional Schools Regular School No Middle 06 08 2021   pk_12_total 302 * 30   * 17     0   16   191 184     *             76   375 302   30     17     0   16   191 184             76   375
2758214 CT     school 903537 2150012   Regional School District 15 90353700749 2156212 Pomperaug Regional High School Regional Schools Regular School No High 09 12 2021   pk_12_total 966 21 69   * 57     *   26   565 580     *             192   1145 966 21 69     57         26   565 580             192   1145
2758216 CT     school 903538 2160012   Regional School District 16 90353801811 2160512 Prospect Elementary School Regional Schools Regular School No Elementary PK 05 2021   pk_12_total 532 20 18   * 12     0   *   319 274     21             77   593 532 20 18     12     0       319 274     21       77   593
2758217 CT     school 903538 2160012   Regional School District 16 90353800755 2160112 Laurel Ledge School Regional Schools Regular School No Elementary KG 05 2021   pk_12_total 192 * 41   0 9     *   8   128 131     9             27   259 192   41   0 9         8   128 131     9       27   259
2758218 CT     school 903538 2160012   Regional School District 16 90353800756 2165112 Long River Middle School Regional Schools Regular School No Middle 06 08 2021   pk_12_total 415 20 40   0 *     *   12   227 265     *             62   492 415 20 40   0           12   227 265             62   492
2758219 CT     school 903538 2160012   Regional School District 16 90353801356 2166012 Woodland Regional High School Regional Schools Regular School No High 09 12 2021   pk_12_total 564 28 41   * *     0   6   325 319     *             85   644 564 28 41           0   6   325 319             85   644
2758221 CT     school 903539 2170012   Regional School District 17 90353900760 2170312 Killingworth Elementary School Regional Schools Regular School No Elementary PK 03 2021   pk_12_total 216 * 9   * 0     0   9   113 124     *             59   237 216   9     0     0   9   113 124             59   237
2758222 CT     school 903539 2170012   Regional School District 17 90353900757 2170212 Burr District Elementary School Regional Schools Regular School No Elementary KG 03 2021   pk_12_total 267 * 13   0 *     0   6   142 153     *             38   295 267   13   0       0   6   142 153             38   295
2758223 CT     school 903539 2170012   Regional School District 17 90353901921 2170512 Haddam-Killingworth Intermediate School Regional Schools Regular School No Elementary 04 05 2021   pk_12_total 221 * 16   0 *     0   7   136 115     *             43   251 221   16   0       0   7   136 115             43   251
2758224 CT     school 903539 2170012   Regional School District 17 90353901201 2175112 Haddam-Killingworth Middle School Regional Schools Regular School No Middle 06 08 2021   pk_12_total 393 * 14   0 *     0   13   240 193     *             77   433 393   14   0       0   13   240 193             77   433
2758225 CT     school 903539 2170012   Regional School District 17 90353900759 2176112 Haddam-Killingworth High School Regional Schools Regular School No High 09 12 2021   pk_12_total 559 * 22   0 *     0   16   * 308     *             82   616 559   22   0       0   16     308             82   616
2758226 CT     school 903540 2180012   Regional School District 18 90354000761 2180312 Center School Regional Schools Special Education School No Prekindergarten PK PK 2021   pk_12_total 85 * *   0 *     0   *   52 43     0             17   95 85       0       0       52 43     0       17   95
2758227 CT     school 903540 2180012   Regional School District 18 90354000762 2180112 Lyme Consolidated School Regional Schools Regular School No Elementary KG 05 2021   pk_12_total 170 * 12   0 *     0   10   105 91     6             23   196 170   12   0       0   10   105 91     6       23   196
2758228 CT     school 903540 2180012   Regional School District 18 90354000764 2180212 Mile Creek School Regional Schools Regular School No Elementary KG 05 2021   pk_12_total 234 * 15   0 *     0   12   143 127     9             33   270 234   15   0       0   12   143 127     9       33   270
2758229 CT     school 903540 2180012   Regional School District 18 90354001123 2185112 Lyme-Old Lyme Middle School Regional Schools Regular School No Middle 06 08 2021   pk_12_total 229 * 18   0 12     0   *   136 134     *             53   270 229   18   0 12     0       136 134             53   270
2758230 CT     school 903540 2180012   Regional School District 18 90354000763 2186112 Lyme-Old Lyme High School Regional Schools Regular School No High 09 12 2021   pk_12_total 402 * 25   0 12     0   *   220 230     6             44   450 402   25   0 12     0       220 230     6       44   450
2758669 CT     school 903600 2010012   Regional School District 01 90360000766 2016112 Housatonic Valley Regional High School Regional Schools Regular School No High 09 12 2021   pk_12_total 254 * 40   0 *     0   12   * 163     *             51   316 254   40   0       0   12     163             51   316
2758675 CT     school 903630 2040012   Regional School District 04 90363000767 2045112 John Winthrop Middle School Regional Schools Regular School No Middle 07 08 2021   pk_12_total 205 * 23   0 *     0   8   128 113     *             46   241 205   23   0       0   8   128 113             46   241
2758676 CT     school 903630 2040012   Regional School District 04 90363000768 2046112 Valley Regional High School Regional Schools Regular School No High 09 12 2021   pk_12_total 524 * 21   * 10     0   17   * 300     *             105   577 524   21     10     0   17     300             105   577
2758678 CT     school 903660 2050012   Regional School District 05 90366001114 2055112 Amity Middle School: Bethany Regional Schools Regular School No Middle 07 08 2021   pk_12_total 243 * 38   0 54     0   *   184 173     *             34   357 243   38   0 54     0       184 173             34   357
2758679 CT     school 903660 2050012   Regional School District 05 90366000769 2055212 Amity Middle School: Orange Regional Schools Regular School No Middle 07 08 2021   pk_12_total 251 11 27   * 53     0   *   193 157     *             41   350 251 11 27     53     0       193 157             41   350
2758680 CT     school 903660 2050012   Regional School District 05 90366000770 2056112 Amity Regional High School Regional Schools Regular School No High 09 12 2021   pk_12_total 1064 49 *   * 221     0   60   724 720     10             168   1444 1064 49       221     0   60   724 720     10       168   1444
2758683 CT     school 903720 2070012   Regional School District 07 90372001226 2075112 Northwestern Regional Middle School Regional Schools Regular School No Middle 07 08 2021   pk_12_total 267 * 6   0 *     0   *   141 139     0             46   280 267   6   0       0       141 139     0       46   280
2758686 CT     school 903720 2070012   Regional School District 07 90372000771 2076112 Northwestern Regional High School Regional Schools Regular School No High 09 12 2021   pk_12_total 584 * 19   0 6     *   12   287 337     *             73   624 584   19   0 6         12   287 337             73   624
2758689 CT     school 903750 2080012   Regional School District 08 90375001210 2085112 RHAM Middle School Regional Schools Regular School No Middle 07 08 2021   pk_12_total 336 * 36   0 *     0   10   201 *     *             55   390 336   36   0       0   10   201               55   390
2758690 CT     school 903750 2080012   Regional School District 08 90375000772 2086112 RHAM High School Regional Schools Regular School No High 09 12 2021   pk_12_total 808 8 49   * 20     *   *   456 *     *             111   889 808 8 49     20             456               111   889
2758691 CT     school 903570 2110012   Regional School District 11 90357000765 2116112 Parish Hill High School Regional Schools Regular School No High 07 12 2021   pk_12_total 176 * *   0 0     0   12   112 89     *             36   201 176       0 0     0   12   112 89             36   201
2758727 CT     school 903780 2090012   Regional School District 09 90378000773 2096112 Joel Barlow High School Regional Schools Regular School No High 09 12 2021   pk_12_total 680 9 58   0 35     0   45   414 413     *             105   827 680 9 58   0 35     0   45   414 413             105   827
2758728 CT     school 900005 2190012   Regional School District 19 90000501215 2196112 E. O. Smith High School Regional Schools Regular School No High 09 12 2021   pk_12_total 794 * 114   0 43     *   95   487 576     7             153   1063 794   114   0 43         95   487 576     7       153   1063
2757428 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 2021   pk_12_total 110 131 162   * 87     *   30   261 263     90             61   524 110 131 162     87         30   261 263     90       61   524
2757429 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 2021   pk_12_total 78 129 229   * 9     *   36   175 308     20             80   483 78 129 229     9         36   175 308     20       80   483
2757430 CT     school 900700 2410014   Capitol Region Education Council 90070001597 2418114 Discovery Academy Regional Education Service Center Schools Regular School No Elementary PK 05 2021   pk_12_total 144 78 244   * 28     0   *   260 262     54             54   522 144 78 244     28     0       260 262     54       54   522
2757431 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 2021   pk_12_total 80 116 190   * 49     0   *   237 228     53             71   465 80 116 190     49     0       237 228     53       71   465
2757432 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 2021   pk_12_total 49 166 151   * 104     0   *   247 249     34             61   496 49 166 151     104     0       247 249     34       61   496
2757433 CT     school 900700 2410014   Capitol Region Education Council 90070000210 2413114 Montessori Magnet School Regional Education Service Center Schools Regular School No Elementary PK 06 2021   pk_12_total 73 39 212   0 12     0   22   173 185     53             60   358 73 39 212   0 12     0   22   173 185     53       60   358
2757434 CT     school 900700 2410014   Capitol Region Education Council 90070001601 2410514 Museum Academy Regional Education Service Center Schools Regular School No Elementary PK 05 2021   pk_12_total 80 234 149   * *     0   38   255 266     28             49   521 80 234 149           0   38   255 266     28       49   521
2757435 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 2021   pk_12_total 137 142 187   * *     0   35   229 283     55             93   512 137 142 187           0   35   229 283     55       93   512
2757439 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 2021   pk_12_total 77 221 123   * *     0   33   232 246     20             93   478 77 221 123           0   33   232 246     20       93   478
2757442 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 2021   pk_12_total 125 253 304   * 68     0   *   479 297     38             130   776 125 253 304     68     0       479 297     38       130   776
2757443 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 2021   pk_12_total 160 186 366   * *     0   32   425 *     63             134   778 160 186 366           0   32   425       63       134   778
2757444 CT     school 900700 2410014   Capitol Region Education Council 90070001625 2415314 Greater Hartford Academy of the Arts Magnet Middle Regional Education Service Center Schools Regular School No Middle 06 08 2021   pk_12_total 66 95 170   0 0     0   18   * 251     25             81   349 66 95 170   0 0     0   18     251     25       81   349
2757445 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 2021   pk_12_total 98 350 203   * 17     *   43   * 390     22             131   714 98 350 203     17         43     390     22       131   714
2757446 CT     school 900700 2410014   Capitol Region Education Council 90070001364 2415014 Two Rivers Magnet Middle School Regional Education Service Center Schools Regular School No Middle 06 08 2021   pk_12_total 90 202 339   * *     0   27   360 316     79             138   676 90 202 339           0   27   360 316     79       138   676
2757449 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 2021   pk_12_total 66 113 204   * 7     *   16   206 204     27             80   410 66 113 204     7         16   206 204     27       80   410
2757450 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 2021   pk_12_total 95 105 217   0 *     0   *   122 317     15             85   439 95 105 217   0       0       122 317     15       85   439
2757477 CT     school 900910 2430014   Cooperative Educational Services 90091000340 2430114 Six-Six Magnet School Regional Education Service Center Schools Regular School No Elementary PK 08 2021   pk_12_total 108 107 189   * 25     0   *   229 220     31             39   449 108 107 189     25     0       229 220     31       39   449
2757576 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 2021   pk_12_total 79 6 36   0 0     0   9   * 87     *             23   130 79 6 36   0 0     0   9     87             23   130
2757577 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 09 12 2021   pk_12_total * * *   0 0     0   *   * *     *             *   8         0 0     0                           8
2757578 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 2021   pk_12_total 121 * 27   0 *     0   11   62 103     *             30   165 121   27   0       0   11   62 103             30   165
2757804 CT     school 903450 2450014   Learn 90345001627 2450314 Riverside Magnet School at Goodwin University Regional Education Service Center Schools Regular School No Elementary PK 05 2021   pk_12_total 88 124 221   * 10     *   30   239 239     84             77   478 88 124 221     10         30   239 239     84       77   478
2757805 CT     school 903450 2450014   Learn 90345001430 2450214 The Friendship School Regional Education Service Center Schools Regular School No Elementary PK KG 2021   pk_12_total 158 43 172   * *     0   57   242 209     19             48   451 158 43 172           0   57   242 209     19       48   451
2757806 CT     school 903450 2450014   Learn 90345000079 2450114 Regional Multicultural Magnet School Regional Education Service Center Schools Regular School No Elementary KG 05 2021   pk_12_total 132 70 210   * 7     *   64   234 254     59             71   488 132 70 210     7         64   234 254     59       71   488
2757809 CT     school 903450 2450014   Learn 90345001581 2456014 Connecticut River Academy at Goodwin University Regional Education Service Center Schools Regular School No High 06 12 2021   pk_12_total 72 133 290   * 19     *   17   256 277     46             90   533 72 133 290     19         17   256 277     46       90   533
2757810 CT     school 903450 2450014   Learn 90345001606 2456114 Marine Science Magnet High School Regional Education Service Center Schools Regular School No High 09 12 2021   pk_12_total 197 * 37   * 10     0   17   136 135     *             25   271 197   37     10     0   17   136 135             25   271
2757812 CT     school 903450 2450014   Learn 90345001617 2456214 Three Rivers Middle College Magnet School Regional Education Service Center Schools Regular School No High 11 12 2021   pk_12_total 41 * 18   * *     0   *   16 51     0             *   67 41   18           0       16 51     0           67
2758651 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 2021   pk_12_total 95 215 127   * *     0   30   227 264     56             74   491 95 215 127           0   30   227 264     56       74   491
2758655 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 2021   pk_12_total 133 111 405   * 32     *   34   362 358     74             97   720 133 111 405     32         34   362 358     74       97   720
2757288 CT     school 900030 10011   Andover School District 90003010001 10111 Andover Elementary School Public Schools Regular School No Elementary PK 06 2021   pk_12_total 141 * 22   0 0     0   *   86 87     *             22   173 141   22   0 0     0       86 87             22   173
2757290 CT     school 900060 20011   Ansonia School District 90006000005 20311 Mead School Public Schools Regular School No Elementary PK 06 2021   pk_12_total 140 134 310   0 *     *   33   320 303     42             113   623 140 134 310   0           33   320 303     42       113   623
2757291 CT     school 900060 20011   Ansonia School District 90006001020 20811 Prendergast School Public Schools Regular School No Elementary KG 06 2021   pk_12_total 204 98 273   0 15     0   46   334 302     44             102   636 204 98 273   0 15     0   46   334 302     44       102   636

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