Data source: Big Local News · About: Big Local

60,956 rows where state = "CT" sorted by ell_int

View and edit SQL

grade

year

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
2452646 CT     school 903539 2170012   Regional School District 17 90353900758 2170112 Haddam Elementary School   Regular School No Elementary KG 04 2019   pk_12_total 156 * 9   0 *     0   8   95 81     *             25   176 156   9   0       0   8   95 81             25   176
2452647 CT     school 903539 2170012   Regional School District 17 90353900760 2170312 Killingworth Elementary School Regional Schools Regular School No Elementary KG 04 2019   pk_12_total 244 0 11   0 *     0   *   130 135     *             41   265 244 0 11   0       0       130 135             41   265
2452648 CT     school 903539 2170012   Regional School District 17 90353901201 2175112 Haddam-Killingworth Middle School Regional Schools Regular School No Middle 05 08 2019   pk_12_total 615 * 18   0 *     0   22   358 313     *             127   671 615   18   0       0   22   358 313             127   671
2452649 CT     school 903539 2170012   Regional School District 17 90353900759 2176112 Haddam-Killingworth High School Regional Schools Regular School No High 09 12 2019   pk_12_total 601 8 12   0 14     0   9   333 311     *             83   644 601 8 12   0 14     0   9   333 311             83   644
2452652 CT     school 903540 2180012   Regional School District 18 90354000762 2180112 Lyme Consolidated School Regional Schools Regular School No Elementary KG 05 2019   pk_12_total 180 0 *   0 *     0   11   120 85     *             24   205 180 0     0       0   11   120 85             24   205
2452654 CT     school 903540 2180012   Regional School District 18 90354001123 2185112 Lyme-Old Lyme Middle School Regional Schools Regular School No Middle 06 08 2019   pk_12_total 244 * 15   0 10     0   *   131 147     *             39   278 244   15   0 10     0       131 147             39   278
2452655 CT     school 903540 2180012   Regional School District 18 90354000763 2186112 Lyme-Old Lyme High School Regional Schools Regular School No High 09 12 2019   pk_12_total 427 * 24   * 9     0   7   236 235     *             36   471 427   24     9     0   7   236 235             36   471
2452663 CT     school 903810 1180011   Ridgefield School District 90381000777 1180411 Farmingville Elementary School Public Schools Regular School No Elementary KG 05 2019   pk_12_total 235 * 23   * 13     0   18   149 142     *             26   291 235   23     13     0   18   149 142             26   291
2452667 CT     school 903810 1180011   Ridgefield School District 90381000776 1185111 East Ridge Middle School Public Schools Regular School No Middle 06 08 2019   pk_12_total 535 0 41   0 38     0   27   329 312     *             71   641 535 0 41   0 38     0   27   329 312             71   641
2452671 CT     school 903810 1180011   Ridgefield School District 90381000779 1186111 Ridgefield High School Public Schools Regular School No High 09 12 2019   pk_12_total 1353 15 103   * 107     *   37   791 827     *             160   1618 1353 15 103     107         37   791 827             160   1618
2452678 CT     school 903900 1210011   Salem School District 90390000787 1210111 Salem Elementary School Public Schools Regular School No Elementary PK 08 2019   pk_12_total 350 10 24   7 7     0   15   * 216     *             59   413 350 10 24   7 7     0   15     216             59   413
2452691 CT     school   1260011   Shelton School District   1261311 Alternative Learning Center 2 Program           2019   pk_12_total * * *   0 *     0   0   * *     *             9   9         0       0   0                   9   9
2452693 CT     school   1260011   Shelton School District   1261211 Therapeutic Learning Center Program           2019   pk_12_total * * *   0 0     0   0   7 0     *             7   7         0 0     0   0   7 0             7   7
2452694 CT     school   1260011   Shelton School District   1260211 Alternative Learning Center 1 Program           2019   pk_12_total * * *   0 0     0   0   6 0     *             6   6         0 0     0   0   6 0             6   6
2452699 CT     school 904080 1270011   Sherman School District 90408000808 1270111 Sherman School Public Schools Regular School No Elementary PK 08 2019   pk_12_total 254 * 10   * *     0   *   141 138     *             36   279 254   10           0       141 138             36   279
2452705 CT     school 904110 1280011   Simsbury School District 90411000816 1280411 Tootin' Hills School Public Schools Regular School No Elementary KG 06 2019   pk_12_total 265 23 41   0 18     0   23   173 197     *             49   370 265 23 41   0 18     0   23   173 197             49   370
2452706 CT     school 904110 1280011   Simsbury School District 90411000811 1285111 Henry James Memorial School Public Schools Regular School No Middle 07 08 2019   pk_12_total 452 34 54   0 50     0   16   313 293     *             82   606 452 34 54   0 50     0   16   313 293             82   606
2452709 CT     school 904140 1290011   Somers School District 90414000526 1290411 Somers Elementary School Public Schools Regular School No Elementary PK 05 2019   pk_12_total 518 16 28   * *     0   6   304 272     *             86   576 518 16 28           0   6   304 272             86   576
2452710 CT     school 904140 1290011   Somers School District 90414000818 1295111 Mabelle B. Avery Middle School Public Schools Regular School No Middle 06 08 2019   pk_12_total 308 * 13   0 6     0   *   164 172     *             44   336 308   13   0 6     0       164 172             44   336
2452711 CT     school 904140 1290011   Somers School District 90414000819 1296111 Somers High School Public Schools Regular School No High 09 12 2019   pk_12_total 406 14 18   0 11     *   *   232 227     *             56   459 406 14 18   0 11             232 227             56   459
2452731 CT     school 904230 1310011   Southington School District 90423000837 1310711 South End Elementary School Public Schools Regular School No Elementary KG 05 2019   pk_12_total 180 * 35   0 *     0   8   118 115     *             23   233 180   35   0       0   8   118 115             23   233
2452744 CT     school 904260 1330011   Sprague School District 90426000842 1330111 Sayles School Public Schools Regular School No Other PK 12 2019   pk_12_total 217 6 47   * *     *   35   178 135     *             50   313 217 6 47               35   178 135             50   313
2452746 CT     school 904290 1340011   Stafford School District 90429000848 1340411 West Stafford School Public Schools Regular School No Elementary PK 01 2019   pk_12_total 124 * 10   0 *     0   *   78 66     *             17   144 124   10   0       0       78 66             17   144
2452747 CT     school 904290 1340011   Stafford School District 90429001503 1340611 Stafford Elementary School Public Schools Regular School No Elementary 02 05 2019   pk_12_total 412 6 32   * *     0   18   231 239     *             69   470 412 6 32           0   18   231 239             69   470
2452774 CT     school 904320 1350011   Stamford School District 90432001468 1356411 The Academy of Information, Technology & Engineering Public Schools Regular School No High 09 12 2019   pk_12_total 293 112 140   0 69     *   *   346 292     *             69   638 293 112 140   0 69             346 292             69   638
2452776 CT     school   1350011   Stamford School District 90432001749 1350211 Individuals Achieving Independence Program           2019   pk_12_total * * 10   0 0     0   0   12 9     *             21   21     10   0 0     0   0   12 9             21   21
2452780 CT     school 904380 1370011   Stonington School District 90438000876 1370511 Deans Mill School Public Schools Regular School No Elementary KG 04 2019   pk_12_total 324 * 22   * 11     *   16   190 188     *             34   378 324   22     11         16   190 188             34   378
2452781 CT     school 904380 1370011   Stonington School District 90438000883 1370611 West Vine Street School Public Schools Regular School No Elementary KG 03 2019   pk_12_total 139 7 11   0 6     0   20   94 89     *             20   183 139 7 11   0 6     0   20   94 89             20   183
2452782 CT     school 904380 1370011   Stonington School District 90438000882 1370411 West Broad Street School   Regular School No Elementary 03 04 2019   pk_12_total 90 * 6   * *     0   10   50 61     *             20   111 90   6           0   10   50 61             20   111
2452784 CT     school 904380 1370011   Stonington School District 90438000877 1375211 Stonington Middle School Public Schools Regular School No Middle 05 08 2019   pk_12_total 312 * 21   0 *     0   9   169 182     *             51   351 312   21   0       0   9   169 182             51   351
2452785 CT     school 904380 1370011   Stonington School District 90438000881 1376111 Stonington High School Public Schools Regular School No High 09 12 2019   pk_12_total 581 * 34   7 25     *   13   353 311     *             79   664 581   34   7 25         13   353 311             79   664
2452802 CT     school   1380011   Stratford School District 90444001756 1381811 Middle School Sails Program           2019   pk_12_total * * *   * 0     0   0   8 0     *             8   8           0     0   0   8 0             8   8
2452806 CT     school   1380011   Stratford School District 90444001671 1380711 High School Sails Program           2019   pk_12_total * * 6   0 0     0   *   10 7     *             17   17     6   0 0     0       10 7             17   17
2452809 CT     school   1380011   Stratford School District 90444001437 1389011 Strive-Stratford Program           2019   pk_12_total 8 * *   0 0     0   *   * *     *             15   15 8       0 0     0                       15   15
2452813 CT     school 904470 1390011   Suffield School District 90447000904 1396111 Suffield High School Public Schools Regular School No High 09 12 2019   pk_12_total 709 20 40   * 29     *   7   373 437     *             90   810 709 20 40     29         7   373 437             90   810
2452815 CT     school 904500 1400011   Thomaston School District 90450001117 1400211 Thomaston Center School Public Schools Regular School No Middle 04 06 2019   pk_12_total 178 0 6   0 0     *   *   90 99     *             29   189 178 0 6   0 0             90 99             29   189
2452816 CT     school 904500 1400011   Thomaston School District 90450000908 1406211 Thomaston High School Public Schools Regular School No High 07 12 2019   pk_12_total 325 * 15   0 *     0   11   155 206     *             41   361 325   15   0       0   11   155 206             41   361
2452818 CT     school 904530 1410011   Thompson School District 90453000909 1410111 Mary R. Fisher Elementary School Public Schools Regular School No Elementary PK 04 2019   pk_12_total 372 * 27   0 *     0   9   232 184     *             75   416 372   27   0       0   9   232 184             75   416
2452819 CT     school 904530 1410011   Thompson School District 90453000910 1415111 Thompson Middle School Public Schools Regular School No Middle 05 08 2019   pk_12_total 281 * 27   0 *     0   11   183 140     *             33   323 281   27   0       0   11   183 140             33   323
2452822 CT     school 904560 1420011   Tolland School District 90456000913 1420211 Tolland Intermediate School Public Schools Regular School No Elementary 03 05 2019   pk_12_total 454 17 23   0 11     0   7   264 248     *             81   512 454 17 23   0 11     0   7   264 248             81   512
2452823 CT     school 904560 1420011   Tolland School District 90456000915 1425111 Tolland Middle School Public Schools Regular School No Middle 06 08 2019   pk_12_total 490 17 26   * 30     *   *   297 273     *             84   570 490 17 26     30             297 273             84   570
2452824 CT     school 904560 1420011   Tolland School District 90456000914 1426111 Tolland High School Public Schools Regular School No High 09 12 2019   pk_12_total 735 12 26   * 21     *   *   394 407     *             70   801 735 12 26     21             394 407             70   801
2452843 CT     school 904620 1440011   Trumbull School District 90462000930 1445211 Hillcrest Middle School Public Schools Regular School No Middle 06 08 2019   pk_12_total 532 32 78   * 67     *   13   383 342     *             75   725 532 32 78     67         13   383 342             75   725
2452851 CT     school 904680 1460011   Vernon School District 90468000940 1460111 Lake Street School Public Schools Regular School No Elementary PK 05 2019   pk_12_total 169 * 26   0 *     0   13   114 103     *             25   217 169   26   0       0   13   114 103             25   217
2452852 CT     school 904680 1460011   Vernon School District 90468000942 1460311 Northeast School Public Schools Regular School No Elementary PK 05 2019   pk_12_total 120 18 44   * *     0   25   115 109     *             43   224 120 18 44           0   25   115 109             43   224
2452855 CT     school 904680 1460011   Vernon School District 90468000941 1460211 Maple Street School Public Schools Regular School No Elementary KG 05 2019   pk_12_total 92 45 90   0 *     *   27   135 138     *             32   273 92 45 90   0           27   135 138             32   273
2452866 CT     school   1480011   Wallingford School District   1480711 STARS Primary Program Program           2019   pk_12_total 11 0 *   0 *     0   0   * *     *             15   15 11 0     0       0   0                   15   15
2452872 CT     school   1480011   Wallingford School District   1481111 STARS Intermediate Program Program           2019   pk_12_total * 0 *   0 *     0   0   * *     *             9   9   0     0       0   0                   9   9
2452876 CT     school   1480011   Wallingford School District   1481311 Inspire Middle School Program           2019   pk_12_total 9 0 *   0 *     0   0   6 7     *             13   13 9 0     0       0   0   6 7             13   13
2452878 CT     school   1480011   Wallingford School District   1480511 Education Enhancement Program             2019   pk_12_total 14 0 6   0 0     0   0   13 7     *             *   20 14 0 6   0 0     0   0   13 7                 20
2452881 CT     school   1480011   Wallingford School District 90474001594 1489111 Wallingford Transition Academy Program           2019   pk_12_total 7 * *   0 *     0   0   * *     *             13   13 7       0       0   0                   13   13
2452893 CT     school   1510011   Waterbury School District 90483000548 1518011 Special Education Preschool Program           2019   pk_12_total 39 36 108   0 *     *   7   112 84     *             93   196 39 36 108   0           7   112 84             93   196
2452900 CT     school   1510011   Waterbury School District   1514611 Bucks Hill Autism Program           2019   pk_12_total * 6 13   0 0     0   *   19 7     *             26   26   6 13   0 0     0       19 7             26   26
2452901 CT     school   1510011   Waterbury School District   1514311 Bucks Hill Bilingual Program           2019   pk_12_total 0 0 210   0 0     0   0   108 102     *             44   210 0 0 210   0 0     0   0   108 102             44   210
2452903 CT     school   1510011   Waterbury School District   1511911 Carrington ESC Program           2019   pk_12_total * * 10   0 *     0   *   7 11     *             18   18     10   0       0       7 11             18   18
2452906 CT     school   1510011   Waterbury School District   1513511 Generali Autism Program           2019   pk_12_total * 11 16   0 *     0   *   * *     *             31   31   11 16   0       0                       31   31
2452907 CT     school   1510011   Waterbury School District   1516911 Gilmartin Scope Program           2019   pk_12_total * * *   0 0     0   0   * *     *             9   9         0 0     0   0                   9   9
2452915 CT     school   1510011   Waterbury School District   1512411 Reed ESC Program           2019   pk_12_total * * 16   0 0     0   *   16 8     *             24   24     16   0 0     0       16 8             24   24
2452917 CT     school   1510011   Waterbury School District   1510111 Bunker Hill BDLC Program           2019   pk_12_total * * 17   0 0     0   0   * *     *             25   25     17   0 0     0   0                   25   25
2452923 CT     school   1510011   Waterbury School District   1513711 North End BDLC Program           2019   pk_12_total 0 8 12   0 0     0   0   * *     *             20   20 0 8 12   0 0     0   0                   20   20
2452926 CT     school   1510011   Waterbury School District   1514811 North End SCOPE Program           2019   pk_12_total * * *   0 0     0   *   * *     *             10   10         0 0     0                       10   10
2452928 CT     school   1510011   Waterbury School District   1515811 Wallace Bilingual Program           2019   pk_12_total 0 0 54   0 0     0   0   26 28     *             13   54 0 0 54   0 0     0   0   26 28             13   54
2452929 CT     school   1510011   Waterbury School District   1514911 Wallace SCOPE Program           2019   pk_12_total * * 7   0 0     0   0   8 6     *             14   14     7   0 0     0   0   8 6             14   14
2452931 CT     school   1510011   Waterbury School District   1514711 West Side BDLC Program           2019   pk_12_total * * 13   0 0     0   *   * *     *             23   23     13   0 0     0                       23   23
2452932 CT     school   1510011   Waterbury School District   1515611 West Side Bilingual Program           2019   pk_12_total * 0 *   0 0     0   0   35 29     *             9   64   0     0 0     0   0   35 29             9   64
2452933 CT     school   1510011   Waterbury School District   1515511 West Side SCOPE Program           2019   pk_12_total * * 7   0 0     0   0   * *     *             9   9     7   0 0     0   0                   9   9
2452937 CT     school 904830 1510011   Waterbury School District 90483001396 1516011 Waterbury Arts Magnet School (High) Public Schools Regular School No High 09 12 2019   pk_12_total 188 109 141   * *     0   20   171 300     *             73   471 188 109 141           0   20   171 300             73   471
2452938 CT     school   1510011   Waterbury School District   1514511 Wilby Autism Program           2019   pk_12_total * * 6   0 0     0   0   * *     *             13   13     6   0 0     0   0                   13   13
2452969 CT     school   1550011   West Hartford School District 90492001790 1559611 Wolcott Learning Center Program           2019   pk_12_total 7 * 8   0 *     0   *   13 6     *             19   19 7   8   0       0       13 6             19   19
2452976 CT     school   1550011   West Hartford School District 90492001791 1557311 REACH Program           2019   pk_12_total 10 * 24   0 *     *   *   24 17     *             0   41 10   24   0               24 17             0   41
2452979 CT     school   1550011   West Hartford School District 90492001600 1559211 Strive-West Hartford Program           2019   pk_12_total 10 * 21   0 0     0   *   27 12     *             *   39 10   21   0 0     0       27 12                 39
2452980 CT     school   1550011   West Hartford School District 90492001526 1559011 Post Secondary Program Program           2019   pk_12_total 16 6 6   0 7     0   0   20 15     *             35   35 16 6 6   0 7     0   0   20 15             35   35
2452987 CT     school   1560011   West Haven School District 90495001799 1560111 Life Skills Program           2019   pk_12_total * * 6   0 0     0   0   * *     *             11   11     6   0 0     0   0                   11   11
2452991 CT     school   1560011   West Haven School District 90495001775 1560211 PACE Program           2019   pk_12_total * 11 19   0 0     0   *   22 18     *             14   40   11 19   0 0     0       22 18             14   40
2452992 CT     school   1560011   West Haven School District   1560711 Blended Program           2019   pk_12_total 11 * 6   0 0     0   *   10 9     *             *   19 11   6   0 0     0       10 9                 19
2452999 CT     school 905010 1570011   Weston School District 90501001428 1570211 Weston Intermediate School Public Schools Regular School No Elementary 03 05 2019   pk_12_total 410 6 30   0 30     0   31   253 254     *             53   507 410 6 30   0 30     0   31   253 254             53   507
2453000 CT     school 905010 1570011   Weston School District 90501001047 1575111 Weston Middle School Public Schools Regular School No Middle 06 08 2019   pk_12_total 486 13 27   0 26     0   29   290 291     *             63   581 486 13 27   0 26     0   29   290 291             63   581
2453001 CT     school 905010 1570011   Weston School District 90501001046 1576111 Weston High School Public Schools Regular School No High 09 12 2019   pk_12_total 691 15 33   0 38     0   24   430 371     *             66   801 691 15 33   0 38     0   24   430 371             66   801
2453006 CT     school 905040 1580011   Westport School District 90504000960 1580411 Green's Farms School Public Schools Regular School No Elementary KG 05 2019   pk_12_total 313 * 30   * 16     0   26   206 192     *             37   398 313   30     16     0   26   206 192             37   398
2453007 CT     school 905040 1580011   Westport School District 90504001055 1580511 King's Highway Elementary School Public Schools Regular School No Elementary KG 05 2019   pk_12_total 363 18 24   0 35     0   30   239 231     *             44   470 363 18 24   0 35     0   30   239 231             44   470
2453011 CT     school 905040 1580011   Westport School District 90504001048 1585111 Bedford Middle School Public Schools Regular School No Middle 06 08 2019   pk_12_total 682 13 48   0 58     0   57   446 412     *             110   858 682 13 48   0 58     0   57   446 412             110   858
2453012 CT     school 905040 1580011   Westport School District 90504001052 1585311 Coleytown Middle School Public Schools Regular School No Middle 06 08 2019   pk_12_total 370 7 28   0 27     0   24   227 229     *             58   456 370 7 28   0 27     0   24   227 229             58   456
2453019 CT     school   1590011   Wethersfield School District   1590411 ABA Program           2019   pk_12_total 0 * *   0 0     0   *   * *     *             7   7 0       0 0     0                       7   7
2453024 CT     school 905100 1600011   Willington School District 90510001069 1600111 Center School Public Schools Regular School No Elementary PK 04 2019   pk_12_total 207 * 13   0 *     0   8   125 112     *             33   237 207   13   0       0   8   125 112             33   237
2453027 CT     school 905130 1610011   Wilton School District 90513001073 1615211 Middlebrook School Public Schools Regular School No Middle 06 08 2019   pk_12_total 770 * 66   * 104     0   54   471 532     *             138   1003 770   66     104     0   54   471 532             138   1003
2453028 CT     school 905130 1610011   Wilton School District 90513001071 1610711 Cider Mill School Public Schools Regular School No Elementary 03 05 2019   pk_12_total 648 * *   0 99     0   56   449 409     *             120   858 648       0 99     0   56   449 409             120   858
2453029 CT     school 905130 1610011   Wilton School District 90513001076 1616111 Wilton High School Public Schools Regular School No High 09 12 2019   pk_12_total 1004 * 73   * 106     0   58   630 633     *             174   1263 1004   73     106     0   58   630 633             174   1263
2453038 CT     school   1630011   Windham School District   1631111 Sweeney ASD Program Program           2019   pk_12_total * 0 12   0 0     0   *   * *     *             15   15   0 12   0 0     0                       15   15
2453039 CT     school   1630011   Windham School District   1630911 Sweeney Medically Fragile Program Program           2019   pk_12_total * 0 *   0 0     0   0   * *     *             *   *   0     0 0     0   0                        
2453045 CT     school   1630011   Windham School District   1631211 Assisted Work Program Program           2019   pk_12_total * 0 9   * 0     0   0   * *     *             12   12   0 9     0     0   0                   12   12
2453054 CT     school 905220 1640011   Windsor School District 90522001087 1640111 Clover Street School Public Schools Regular School No Elementary 03 05 2019   pk_12_total 58 144 56   0 *     0   *   158 122     *             43   280 58 144 56   0       0       158 122             43   280
2453059 CT     school   1640011   Windsor School District   1640211 Community Based Transition Academy Program           2019   pk_12_total * 13 *   0 *     0   0   13 10     *             23   23   13     0       0   0   13 10             23   23
2453065 CT     school 905280 1660011   Wolcott School District 90528001107 1666111 Wolcott High School Public Schools Regular School No High 09 12 2019   pk_12_total 647 20 37   0 15     0   24   373 370     *             78   743 647 20 37   0 15     0   24   373 370             78   743
2453068 CT     school 905370 1690011   Woodstock School District 90537001110 1690211 Woodstock Elementary School Public Schools Regular School No Elementary PK 04 2019   pk_12_total 384 * 12   0 *     0   26   209 219     *             56   428 384   12   0       0   26   209 219             56   428
2453074 CT     school 900630 210011   Canaan School District 90063000115 210111 Lee H. Kellogg School Public Schools Regular School No Elementary KG 08 2019   pk_12_total * 0 *   0 0     0   0   33 30     *             8   63   0     0 0     0   0   33 30             8   63
2453075 CT     school 900221 2970013   Capital Preparatory Harbor School District 90022101803 2970113 Capital Preparatory Harbor School Public Charter Schools Regular School Yes Other KG 12 2019   pk_12_total * 463 167   * 0     0   *   323 311     *             71   634   463 167     0     0       323 311             71   634
2453076 CT     school 900780 260011   Chester School District 90078000130 260111 Chester Elementary School Public Schools Regular School No Elementary KG 06 2019   pk_12_total 168 * 14   0 *     0   8   107 87     *             28   194 168   14   0       0   8   107 87             28   194
2453078 CT     school 900930 310011   Cornwall School District 90093000140 310111 Cornwall Consolidated School Public Schools Regular School No Elementary KG 08 2019   pk_12_total 71 0 13   0 *     0   *   53 38     *             11   91 71 0 13   0       0       53 38             11   91
2453082 CT     school 904020 1250011   Sharon School District 90402000795 1250111 Sharon Center School Public Schools Regular School No Elementary KG 08 2019   pk_12_total 98 0 10   0 *     *   *   61 54     *             25   115 98 0 10   0               61 54             25   115
2453087 CT     school 903630 2040012   Regional School District 04 90363000767 2045112 John Winthrop Middle School Regional Schools Regular School No Middle 07 08 2019   pk_12_total 247 * 17   0 *     0   12   134 149     *             54   283 247   17   0       0   12   134 149             54   283

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