Data source: Big Local News · About: Big Local

20,216 rows where state = "CT" and year = 2021 sorted by ell_int

View and edit SQL

grade

year

  • 2021 · 20,016
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
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
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
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
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
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
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
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
2758238 CT     school 903810 1180011   Ridgefield School District 90381000777 1180411 Farmingville Elementary School Public Schools Regular School No Elementary KG 05 2021   pk_12_total 239 0 21   0 12     0   16   149 139     *             28   288 239 0 21   0 12     0   16   149 139             28   288
2758242 CT     school 903810 1180011   Ridgefield School District 90381000776 1185111 East Ridge Middle School Public Schools Regular School No Middle 06 08 2021   pk_12_total 424 * 45   0 38     *   29   285 253     *             77   538 424   45   0 38         29   285 253             77   538
2758243 CT     school 903810 1180011   Ridgefield School District 90381001361 1185211 Scotts Ridge Middle School Public Schools Regular School No Middle 06 08 2021   pk_12_total 429 * 46   * 43     0   15   280 259     *             74   539 429   46     43     0   15   280 259             74   539
2758247 CT     school 903810 1180011   Ridgefield School District 90381000779 1186111 Ridgefield High School Public Schools Regular School No High 09 12 2021   pk_12_total 1272 13 121   * 106     *   43   779 *     *             184   1559 1272 13 121     106         43   779               184   1559
2758256 CT     school 903900 1210011   Salem School District 90390000787 1210111 Salem Elementary School Public Schools Regular School No Elementary PK 08 2021   pk_12_total 314 * 34   6 *     0   21   190 194     *             53   384 314   34   6       0   21   190 194             53   384
2758269 CT     school   1260011   Shelton School District   1261311 Alternative Learning Center 2 Program           2021   pk_12_total 7 * *   0 *     0   0   * *     *             12   12 7       0       0   0                   12   12
2758278 CT     school 904080 1270011   Sherman School District 90408000808 1270111 Sherman School Public Schools Regular School No Elementary PK 08 2021   pk_12_total 214 * 20   * *     0   6   116 134     *             42   250 214   20           0   6   116 134             42   250
2758284 CT     school 904110 1280011   Simsbury School District 90411000816 1280411 Tootin' Hills School Public Schools Regular School No Elementary KG 06 2021   pk_12_total 258 21 42   0 14     0   23   162 196     *             56   358 258 21 42   0 14     0   23   162 196             56   358
2758285 CT     school 904110 1280011   Simsbury School District 90411000811 1285111 Henry James Memorial School Public Schools Regular School No Middle 07 08 2021   pk_12_total 432 44 60   0 48     *   *   299 324     *             84   623 432 44 60   0 48             299 324             84   623
2758287 CT     school   1280011   Simsbury School District   1280211 Farmington Valley Transition Academy Program           2021   pk_12_total 23 * *   0 *     0   0   24 9     *             33   33 23       0       0   0   24 9             33   33
2758288 CT     school 904140 1290011   Somers School District 90414000526 1290411 Somers Elementary School Public Schools Regular School No Elementary PK 05 2021   pk_12_total 513 15 23   * *     0   7   288 275     *             92   563 513 15 23           0   7   288 275             92   563
2758305 CT     school 904230 1310011   Southington School District 90423000831 1310211 Hatton Elementary School Public Schools Regular School No Elementary KG 05 2021   pk_12_total 238 * 33   0 *     0   18   151 156     *             33   307 238   33   0       0   18   151 156             33   307
2758306 CT     school   1310011   Southington School District   1312311 Language Based Classroom II Program           2021   pk_12_total * 0 *   0 *     0   *   * *     *             9   9   0     0       0                       9   9
2758315 CT     school   1310011   Southington School District 90423001668 1310511 EASE Program           2021   pk_12_total 6 * *   0 0     0   0   * *     *             12   12 6       0 0     0   0                   12   12
2758325 CT     school 904290 1340011   Stafford School District 90429000848 1340411 West Stafford School Public Schools Regular School No Elementary PK 01 2021   pk_12_total 102 0 12   0 *     0   *   57 63     *             15   120 102 0 12   0       0       57 63             15   120
2758326 CT     school 904290 1340011   Stafford School District 90429001503 1340611 Stafford Elementary School Public Schools Regular School No Elementary 02 05 2021   pk_12_total 320 * 28   * *     0   14   196 172     *             56   368 320   28           0   14   196 172             56   368
2758327 CT     school 904290 1340011   Stafford School District 90429000061 1345211 Stafford Middle School Public Schools Regular School No Middle 06 08 2021   pk_12_total 298 * 28   0 0     0   *   177 168     *             57   345 298   28   0 0     0       177 168             57   345
2758354 CT     school   1350011   Stamford School District 90432001749 1350211 Individuals Achieving Independence Program           2021   pk_12_total 10 * *   0 0     0   0   13 8     *             21   21 10       0 0     0   0   13 8             21   21
2758357 CT     school 904380 1370011   Stonington School District 90438000876 1370511 Deans Mill School Public Schools Regular School No Elementary PK 05 2021   pk_12_total 391 * 28   * 7     0   23   222 231     *             53   453 391   28     7     0   23   222 231             53   453
2758358 CT     school 904380 1370011   Stonington School District 90438000883 1370611 West Vine Street School Public Schools Regular School No Elementary PK 05 2021   pk_12_total 281 * 25   * 6     0   36   172 183     *             59   355 281   25     6     0   36   172 183             59   355
2758359 CT     school 904380 1370011   Stonington School District 90438000877 1375211 Stonington Middle School Public Schools Regular School No Middle 06 08 2021   pk_12_total 384 * 26   * 6     *   25   224 224     *             60   448 384   26     6         25   224 224             60   448
2758360 CT     school 904380 1370011   Stonington School District 90438000881 1376111 Stonington High School Public Schools Regular School No High 09 12 2021   pk_12_total 525 7 44   * 18     *   19   314 302     *             96   616 525 7 44     18         19   314 302             96   616
2758373 CT     school   1380011   Stratford School District   1382811 STEPS K-6 Program           2021   pk_12_total * 8 7   0 0     0   *   * *     *             21   21   8 7   0 0     0                       21   21
2758380 CT     school   1380011   Stratford School District 90444001701 1380511 ALPHA Program           2021   pk_12_total * 13 11   0 0     0   *   15 17     *             10   32   13 11   0 0     0       15 17             10   32
2758381 CT     school   1380011   Stratford School District   1380111 BRIDGES 9-12 Program           2021   pk_12_total * * 9   0 0     0   0   * *     *             13   13     9   0 0     0   0                   13   13
2758383 CT     school   1380011   Stratford School District 90444001671 1380711 High School Sails Program           2021   pk_12_total * 8 9   * 0     0   *   16 8     *             24   24   8 9     0     0       16 8             24   24
2758386 CT     school   1380011   Stratford School District 90444001437 1389011 Strive-Stratford Program           2021   pk_12_total * 6 *   0 0     0   0   8 9     *             17   17   6     0 0     0   0   8 9             17   17
2758389 CT     school 904470 1390011   Suffield School District 90447000902 1395111 Suffield Middle School Public Schools Regular School No Middle 06 08 2021   pk_12_total 352 23 34   * 22     *   *   219 217     *             59   436 352 23 34     22             219 217             59   436
2758391 CT     school 904500 1400011   Thomaston School District 90450000906 1400111 Black Rock School Public Schools Regular School No Elementary PK 03 2021   pk_12_total 226 * 23   * 8     0   *   132 134     *             43   266 226   23     8     0       132 134             43   266
2758395 CT     school 904530 1410011   Thompson School District 90453000909 1410111 Mary R. Fisher Elementary School Public Schools Regular School No Elementary PK 04 2021   pk_12_total 366 * 23   0 *     0   12   208 198     *             81   406 366   23   0       0   12   208 198             81   406
2758400 CT     school 904560 1420011   Tolland School District 90456000915 1425111 Tolland Middle School Public Schools Regular School No Middle 06 08 2021   pk_12_total 495 19 39   0 19     *   *   302 279     *             93   581 495 19 39   0 19             302 279             93   581
2758401 CT     school 904560 1420011   Tolland School District 90456000914 1426111 Tolland High School Public Schools Regular School No High 09 12 2021   pk_12_total 657 16 50   * 36     0   *   372 394     *             81   766 657 16 50     36     0       372 394             81   766
2758428 CT     school 904680 1460011   Vernon School District 90468000941 1460211 Maple Street School Public Schools Regular School No Elementary PK 05 2021   pk_12_total 85 39 84   0 *     *   38   122 142     *             52   264 85 39 84   0           38   122 142             52   264
2758430 CT     school 904680 1460011   Vernon School District 90468000942 1460311 Northeast School Public Schools Regular School No Elementary KG 05 2021   pk_12_total 98 16 32   0 16     0   12   88 86     *             25   174 98 16 32   0 16     0   12   88 86             25   174
2758432 CT     school 904680 1460011   Vernon School District 90468000940 1460111 Lake Street School Public Schools Regular School No Elementary KG 05 2021   pk_12_total 139 7 28   0 8     0   16   103 95     *             26   198 139 7 28   0 8     0   16   103 95             26   198
2758442 CT     school   1480011   Wallingford School District   1480711 STARS Primary Program Program           2021   pk_12_total 7 0 *   0 *     0   0   * *     *             13   13 7 0     0       0   0                   13   13
2758444 CT     school   1480011   Wallingford School District   1480611 Benhaven ABC Intermediate Program Program           2021   pk_12_total * 0 *   0 *     0   0   * *     *             *   *   0     0       0   0                        
2758449 CT     school   1480011   Wallingford School District   1481111 STARS Intermediate Program Program           2021   pk_12_total * 0 *   0 0     0   *   * *     *             7   7   0     0 0     0                       7   7
2758451 CT     school   1480011   Wallingford School District   1481511 Ben Haven ABC Middle School Program Program           2021   pk_12_total * 0 *   0 *     0   0   * *     *             7   7   0     0       0   0                   7   7
2758453 CT     school   1480011   Wallingford School District   1481311 Inspire Middle School Program           2021   pk_12_total * * 6   0 *     0   *   * *     *             14   14     6   0       0                       14   14
2758455 CT     school   1480011   Wallingford School District   1481711 Inspire High School Program           2021   pk_12_total 16 0 *   0 *     0   0   12 9     *             21   21 16 0     0       0   0   12 9             21   21
2758458 CT     school   1480011   Wallingford School District 90474001594 1489111 Wallingford Transition Academy Program           2021   pk_12_total 9 0 *   0 *     0   0   * *     *             13   13 9 0     0       0   0                   13   13
2758478 CT     school   1510011   Waterbury School District   1514311 Bucks Hill Bilingual Program           2021   pk_12_total 0 0 221   0 0     0   0   133 88     *             22   221 0 0 221   0 0     0   0   133 88             22   221
2758480 CT     school   1510011   Waterbury School District   1510111 Bunker Hill BDLC Program           2021   pk_12_total * * 10   0 0     0   0   * *     *             20   20     10   0 0     0   0                   20   20
2758481 CT     school   1510011   Waterbury School District   1511911 Carrington ESC Program           2021   pk_12_total * * 7   0 *     0   0   9 8     *             17   17     7   0       0   0   9 8             17   17
2758490 CT     school   1510011   Waterbury School District   1512411 Reed ESC Program           2021   pk_12_total * * 16   0 *     0   *   * *     *             25   25     16   0       0                       25   25
2758493 CT     school   1510011   Waterbury School District   1511211 Woodrow Wilson BDLC Program           2021   pk_12_total * * 10   0 0     0   *   * *     *             18   18     10   0 0     0                       18   18
2758495 CT     school   1510011   Waterbury School District   1512911 North End Autism Program           2021   pk_12_total * 7 8   0 *     0   *   * *     *             18   18   7 8   0       0                       18   18
2758496 CT     school   1510011   Waterbury School District   1513711 North End BDLC Program           2021   pk_12_total * * 18   0 0     0   0   * *     *             27   27     18   0 0     0   0                   27   27
2758499 CT     school   1510011   Waterbury School District   1514811 North End SCOPE Program           2021   pk_12_total * * 7   0 0     0   *   * *     *             11   11     7   0 0     0                       11   11
2758502 CT     school   1510011   Waterbury School District   1514911 Wallace SCOPE Program           2021   pk_12_total 0 * *   0 0     0   0   * *     *             10   10 0       0 0     0   0                   10   10
2758504 CT     school   1510011   Waterbury School District   1514711 West Side BDLC Program           2021   pk_12_total * * 10   0 0     0   *   * *     *             18   18     10   0 0     0                       18   18
2758505 CT     school   1510011   Waterbury School District   1515611 West Side Bilingual Program           2021   pk_12_total 0 0 65   0 0     0   0   36 29     *             12   65 0 0 65   0 0     0   0   36 29             12   65
2758507 CT     school   1510011   Waterbury School District   1515511 West Side SCOPE Program           2021   pk_12_total * * 6   0 0     0   0   * *     *             10   10     6   0 0     0   0                   10   10
2758513 CT     school   1510011   Waterbury School District   1514511 Wilby Autism Program           2021   pk_12_total * * 10   0 0     0   0   * *     *             19   19     10   0 0     0   0                   19   19
2758514 CT     school   1510011   Waterbury School District   1511711 Wilby ESC Program           2021   pk_12_total * * 11   0 0     0   0   12 9     *             21   21     11   0 0     0   0   12 9             21   21
2758516 CT     school   1510011   Waterbury School District   1517111 School to Work Transition Academy Program           2021   pk_12_total * * 10   0 *     0   0   13 7     *             20   20     10   0       0   0   13 7             20   20
2758541 CT     school   1550011   West Hartford School District 90492001681 1559411 Norfeldt Learning Center Program           2021   pk_12_total * * 0   0 *     0   0   * *     *             10   10     0   0       0   0                   10   10
2758543 CT     school   1550011   West Hartford School District 90492001780 1559511 Whiting Lane Learning Center Program           2021   pk_12_total 10 * 8   0 *     0   *   14 8     *             22   22 10   8   0       0       14 8             22   22
2758544 CT     school   1550011   West Hartford School District 90492001790 1559611 Wolcott Learning Center Program           2021   pk_12_total 6 * *   0 *     0   0   8 6     *             14   14 6       0       0   0   8 6             14   14
2758546 CT     school   1550011   West Hartford School District 90492001705 1559311 Braeburn Learning Center Program           2021   pk_12_total 0 0 *   0 0     0   0   * *     *             *   * 0 0     0 0     0   0                        
2758555 CT     school   1550011   West Hartford School District 90492001526 1559011 Post Secondary Program Program           2021   pk_12_total 17 7 11   0 *     0   *   24 16     *             40   40 17 7 11   0       0       24 16             40   40
2758562 CT     school   1560011   West Haven School District 90495001799 1560111 Life Skills Program           2021   pk_12_total * * *   0 *     0   0   * *     *             12   12         0       0   0                   12   12
2758565 CT     school   1560011   West Haven School District   1560711 Blended Program           2021   pk_12_total 27 * 13   0 0     0   *   34 16     *             11   50 27   13   0 0     0       34 16             11   50
2758567 CT     school   1560011   West Haven School District 90495001775 1560211 PACE Program           2021   pk_12_total 13 * 20   0 0     0   *   32 16     *             23   48 13   20   0 0     0       32 16             23   48
2758573 CT     school 905010 1570011   Weston School District 90501001428 1570211 Weston Intermediate School Public Schools Regular School No Elementary 03 05 2021   pk_12_total 374 8 48   0 30     0   32   249 243     *             65   492 374 8 48   0 30     0   32   249 243             65   492
2758574 CT     school 905010 1570011   Weston School District 90501001047 1575111 Weston Middle School Public Schools Regular School No Middle 06 08 2021   pk_12_total 436 11 38   0 35     0   38   300 258     *             65   558 436 11 38   0 35     0   38   300 258             65   558
2758579 CT     school 905040 1580011   Westport School District 90504000960 1580411 Green's Farms School Public Schools Regular School No Elementary KG 05 2021   pk_12_total 315 * 33   * 22     0   26   208 202     *             45   410 315   33     22     0   26   208 202             45   410
2758598 CT     school 905100 1600011   Willington School District 90510001070 1605111 Hall Memorial School Public Schools Regular School No Middle 05 08 2021   pk_12_total 170 * 16   0 *     0   0   98 97     *             37   195 170   16   0       0   0   98 97             37   195
2758600 CT     school 905130 1610011   Wilton School District 90513001073 1615211 Middlebrook School Public Schools Regular School No Middle 06 08 2021   pk_12_total 697 * 65   0 100     0   *   453 467     *             143   920 697   65   0 100     0       453 467             143   920
2758603 CT     school 905130 1610011   Wilton School District 90513001076 1616111 Wilton High School Public Schools Regular School No High 09 12 2021   pk_12_total 975 * 76   * 130     0   68   621 651     *             200   1272 975   76     130     0   68   621 651             200   1272
2758612 CT     school   1630011   Windham School District   1631111 Sweeney ASD Program Program           2021   pk_12_total * 0 15   0 0     0   *   * *     *             17   17   0 15   0 0     0                       17   17
2758615 CT     school   1630011   Windham School District   1630711 Natchaug Emotional Disturbance Program Program           2021   pk_12_total * * 6   0 0     0   0   8 0     *             8   8     6   0 0     0   0   8 0             8   8
2758619 CT     school   1630011   Windham School District   1631211 Assisted Work Program Program           2021   pk_12_total * 0 *   0 0     0   0   * *     *             13   13   0     0 0     0   0                   13   13
2758620 CT     school   1630011   Windham School District   1631411 Assisted Work Program at WHS Program           2021   pk_12_total * 0 *   0 0     0   0   * *     *             6   6   0     0 0     0   0                   6   6
2758635 CT     school   1640011   Windsor School District   1640211 Community Based Transition Academy Program           2021   pk_12_total * 13 *   0 0     0   *   14 8     *             22   22   13     0 0     0       14 8             22   22
2758641 CT     school   1660011   Wolcott School District 90528001772 1660411 Phoenix Program Program           2021   pk_12_total * * *   0 0     0   0   * *     *             6   6         0 0     0   0                   6   6
2758644 CT     school 905370 1690011   Woodstock School District 90537001110 1690211 Woodstock Elementary School Public Schools Regular School No Elementary PK 04 2021   pk_12_total 373 * 16   * *     0   25   194 230     *             48   424 373   16           0   25   194 230             48   424
2758645 CT     school 905370 1690011   Woodstock School District 90537000573 1695111 Woodstock Middle School Public Schools Regular School No Middle 05 08 2021   pk_12_total 332 * 14   0 *     0   12   183 182     *             36   365 332   14   0       0   12   183 182             36   365

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