Data source: Big Local News · About: Big Local

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

View and edit SQL

year

  • 2020 · 1,461

grade

  • pk_12_total · 1,461
Link rowid state county county_state_id admin_level district_nces_id district_state_id district_state_type district school_nces_id school_state_id school ▲ school_state_type ccd_school_type ccd_charter_school ccd_school_lvl ccd_school_low_grade ccd_school_high_grade year term grade white black hispanic native_american native_american_alaskan_native asian native_hawaiian asian_pacific_islander native_hawaiian_pacific_islander pacific_islander multiracial unknown_race male female non_binary unknown_gender ell ell_percent homeless homeless_percent low_income free_and_reduced free_and_reduced_percent disability section_504 total white_int black_int hispanic_int native_american_int native_american_alaskan_native_int asian_int native_hawaiian_int asian_pacific_islander_int native_hawaiian_pacific_islander_int pacific_islander_int multiracial_int unknown_race_int male_int female_int non_binary_int unknown_gender_int ell_int homeless_int low_income_int free_and_reduced_int disability_int section_504_int total_int
2778199 CT     school   640011   Hartford School District   640810 iGOAL Pre-K - Rawson School Program           2020   pk_12_total * * *   0 0     0   0   * *     0             8   8         0 0     0   0           0       8   8
2778198 CT     school   640011   Hartford School District   640710 iGOAL Pre-K - Naylor School Program           2020   pk_12_total * * 6   0 0     0   *   9 0     0             9   9     6   0 0     0       9 0     0       9   9
2778233 CT     school   640011   Hartford School District   645011 iGOAL 2 - Weaver High School             2020   pk_12_total 0 6 10   0 0     0   0   * *     *             16   16 0 6 10   0 0     0   0                   16   16
2778197 CT     school   640011   Hartford School District 90192001764 648511 iGOAL 2 - Moylan School Program           2020   pk_12_total 0 * *   0 0     0   0   * *     0             6   6 0       0 0     0   0           0       6   6
2778214 CT     school   640011   Hartford School District   640210 iGOAL 2 - Kennelly School Program           2020   pk_12_total 0 * *   0 0     0   0   * *     *             9   9 0       0 0     0   0                   9   9
2778208 CT     school   640011   Hartford School District 90192001673 644411 iGOAL 1 - Rawson School Program           2020   pk_12_total 0 10 *   0 0     0   *   * *     *             *   18 0 10     0 0     0                           18
2778207 CT     school   640011   Hartford School District   648711 iGOAL 1 - Parkville School Program           2020   pk_12_total 0 * *   0 0     0   0   9 0     *             9   9 0       0 0     0   0   9 0             9   9
2778210 CT     school   640011   Hartford School District   649811 iGOAL 1 - Moylan School             2020   pk_12_total 0 * *   0 0     0   *   * *     *             8   8 0       0 0     0                       8   8
2778222 CT     school   640011   Hartford School District   640110 iGOAL 1 - Milner School Program           2020   pk_12_total 0 * *   0 0     0   0   * *     *             20   20 0       0 0     0   0                   20   20
2778221 CT     school   640011   Hartford School District   648911 iGOAL 1 - McDonough Middle School             2020   pk_12_total 0 * *   0 0     0   0   * *     *             9   9 0       0 0     0   0                   9   9
2778206 CT     school   640011   Hartford School District 90192001732 645711 iGOAL 1 - M.D. Fox School Program           2020   pk_12_total * * 26   0 0     *   0   20 14     13             19   34     26   0 0         0   20 14     13       19   34
2778232 CT     school   640011   Hartford School District 90192001660 644911 iGOAL 1 - HPHS Program           2020   pk_12_total * * 18   0 0     0   0   22 8     11             30   30     18   0 0     0   0   22 8     11       30   30
2778205 CT     school   640011   Hartford School District   644711 iGOAL 1 - Burns School Program           2020   pk_12_total 0 * 26   0 *     0   0   24 8     10             32   32 0   26   0       0   0   24 8     10       32   32
2778204 CT     school   640011   Hartford School District   649511 iGOAL 1 - Breakthrough Magnet School, North Program           2020   pk_12_total 0 * *   0 0     0   0   * *     *             11   11 0       0 0     0   0                   11   11
2779145 CT     school   3360015   Unified School District #1 90000300849 3362515 York Correctional Institution State Agency Facilities           2020   pk_12_total * 6 *   0 0     0   0   0 9     0             9   9   6     0 0     0   0   0 9     0       9   9
2778480 CT     school 902790 930011   New Haven School District 90279000588 933811 Worthington Hooker School Public Schools Regular School No Elementary KG 08 2020   pk_12_total 187 67 54   0 98     0   11   211 206     63             33   417 187 67 54   0 98     0   11   211 206     63       33   417
2779098 CT     school 905370 1690011   Woodstock School District 90537000573 1695111 Woodstock Middle School Public Schools Regular School No Middle 05 08 2020   pk_12_total 329 * 11   0 *     0   14   171 188     0             37   359 329   11   0       0   14   171 188     0       37   359
2779097 CT     school 905370 1690011   Woodstock School District 90537001110 1690211 Woodstock Elementary School Public Schools Regular School No Elementary PK 04 2020   pk_12_total 409 * 13   0 *     0   27   210 247     *             63   457 409   13   0       0   27   210 247             63   457
2779112 CT     school   2530014   Eastern Connecticut Regional Educational Service Center (EASTCONN)   2530214 Woodstock Academy Consortium Classroom Program           2020   pk_12_total 10 0 0   0 *     0   *   * *     0             12   12 10 0 0   0       0               0       12   12
2777940 CT     school 900990 330011   Cromwell School District 90099001432 330311 Woodside Intermediate School Public Schools Regular School No Elementary 03 05 2020   pk_12_total 323 33 61   0 30     *   *   234 241     32             55   475 323 33 61   0 30             234 241     32       55   475
2778927 CT     school 904830 1510011   Waterbury School District 90483000685 1513211 Woodrow Wilson School Public Schools Regular School No Elementary PK 05 2020   pk_12_total 16 117 294   0 *     0   *   242 201     69             68   443 16 117 294   0       0       242 201     69       68   443
2778347 CT     school 902490 830011   Middletown School District 90249000459 835411 Woodrow Wilson Middle School Public Schools Regular School No Middle 07 08 2020   pk_12_total 274 149 126   * 19     *   47   313 305     15             78   618 274 149 126     19         47   313 305     15       78   618
2778942 CT     school   1510011   Waterbury School District   1511211 Woodrow Wilson BDLC Program           2020   pk_12_total * * 15   0 0     0   *   * *     *             *   21     15   0 0     0                           21
2777998 CT     school   430011   East Hartford School District 90126000205 439011 Woodland School Program           2020   pk_12_total 27 67 98   * *     0   11   166 40     24             *   206 27 67 98           0   11   166 40     24           206
2778666 CT     school 903538 2160012   Regional School District 16 90353801356 2166012 Woodland Regional High School Regional Schools Regular School No High 09 12 2020   pk_12_total 590 28 48   * 10     0   *   350 331     *             86   681 590 28 48     10     0       350 331             86   681
2778651 CT     school 903536 2140012   Regional School District 14 90353600746 2145112 Woodbury Middle School Regional Schools Regular School No Middle 06 08 2020   pk_12_total 279 * 21   * 7     0   *   151 162     *             56   313 279   21     7     0       151 162             56   313
2778556 CT     school 903090 1030011   Norwalk School District 90309000662 1032411 Wolfpit School Public Schools Regular School No Elementary KG 05 2020   pk_12_total 98 45 124   * 16     0   *   160 140     54             36   300 98 45 124     16     0       160 140     54       36   300
2778997 CT     school 904920 1550011   West Hartford School District 90492001026 1551511 Wolcott School Public Schools Regular School No Elementary KG 05 2020   pk_12_total 174 31 83   * 54     0   *   181 183     54             55   364 174 31 83     54     0       181 183     54       55   364
2778998 CT     school   1550011   West Hartford School District 90492001790 1559611 Wolcott Learning Center Program           2020   pk_12_total * * *   0 0     0   0   * *     *             7   7         0 0     0   0                   7   7
2779095 CT     school 905280 1660011   Wolcott School District 90528001107 1666111 Wolcott High School Public Schools Regular School No High 09 12 2020   pk_12_total 610 23 45   * *     0   21   355 362     6             81   717 610 23 45           0   21   355 362     6       81   717
2778196 CT     school 901920 640011   Hartford School District 90192000385 642211 Wish Museum School Public Schools Regular School No Elementary PK 05 2020   pk_12_total 6 129 189   0 *     0   *   174 158     102             87   332 6 129 189   0       0       174 158     102       87   332
2777768 CT     school 900330 110011   Bloomfield School District 90033001565 110811 Wintonbury Early Childhood Magnet School Public Schools Regular School No Prekindergarten PK PK 2020   pk_12_total 107 110 38   * 33     0   *   159 155     0             49   314 107 110 38     33     0       159 155     0       49   314
2778501 CT     school 902820 950011   New London School District 90282000597 950811 Winthrop STEM Elementary Magnet School Public Schools Regular School No Elementary KG 05 2020   pk_12_total 136 87 192   * 8     *   77   275 230     59             72   505 136 87 192     8         77   275 230     59       72   505
2777736 CT     school 900070 2440014   Area Cooperative Educational Services 90007000884 2440314 Wintergreen Interdistrict Magnet School Regional Education Service Center Schools Regular School No Elementary KG 08 2020   pk_12_total 113 237 124   * 19     *   20   242 273     50             71   515 113 237 124     19         20   242 273     50       71   515
2779076 CT     school 905250 1650011   Windsor Locks School District 90525001101 1655111 Windsor Locks Middle School Public Schools Regular School No Middle 06 08 2020   pk_12_total 181 34 71   0 28     0   25   156 183     16             62   339 181 34 71   0 28     0   25   156 183     16       62   339
2779078 CT     school 905250 1650011   Windsor Locks School District 90525001100 1656111 Windsor Locks High School Public Schools Regular School No High 09 12 2020   pk_12_total 253 48 55   0 38     *   *   223 180     13             54   403 253 48 55   0 38             223 180     13       54   403
2779087 CT     school 905220 1640011   Windsor School District 90522001096 1646111 Windsor High School Public Schools Regular School No High 09 12 2020   pk_12_total 272 541 195   * *     0   66   564 549     32             215   1113 272 541 195           0   66   564 549     32       215   1113
2778124 CT     school   570011   Greenwich School District   571511 Windrose Program           2020   pk_12_total 15 * 13   0 0     0   *   15 15     0             12   30 15   13   0 0     0       15 15     0       12   30
2779172 CT     school 900002 9000016   Connecticut Technical Education and Career System 90000201152 9002416 Windham Technical High School CT Technical Education and Career Schools Career and Technical School No High 09 12 2020   pk_12_total 264 8 183   * *     0   *   298 164     22             59   462 264 8 183           0       298 164     22       59   462
2779070 CT     school 905190 1630011   Windham School District 90519001081 1635111 Windham Middle School Public Schools Regular School No Middle 06 08 2020   pk_12_total 99 20 529   0 0     0   10   336 322     174             141   658 99 20 529   0 0     0   10   336 322     174       141   658
2779071 CT     school 905190 1630011   Windham School District 90519001086 1636111 Windham High School Public Schools Regular School No High 09 12 2020   pk_12_total 106 24 470   * *     0   11   359 257     196             150   616 106 24 470           0   11   359 257     196       150   616
2779061 CT     school   1630011   Windham School District 90519001474 1638311 Windham Early Childhood Center Program           2020   pk_12_total 49 * 148   0 *     0   *   112 93     0             47   205 49   148   0       0       112 93     0       47   205
2779067 CT     school 905190 1630011   Windham School District 90519001085 1630511 Windham Center School Public Schools Regular School No Elementary KG 05 2020   pk_12_total 51 * 159   0 0     0   *   114 107     88             37   221 51   159   0 0     0       114 107     88       37   221
2778034 CT     school 901440 480011   Ellington School District 90144000239 480611 Windermere School Public Schools Regular School No Elementary PK 06 2020   pk_12_total 380 27 57   * 178     0   *   355 310     28             89   665 380 27 57     178     0       355 310     28       89   665
2779056 CT     school 905130 1610011   Wilton School District 90513001076 1616111 Wilton High School Public Schools Regular School No High 09 12 2020   pk_12_total 985 * 83   * 123     0   63   639 633     *             207   1272 985   83     123     0   63   639 633             207   1272
2777920 CT     school 900840 280011   Colchester School District 90084000136 285111 William J. Johnston Middle School Public Schools Regular School No Middle 06 08 2020   pk_12_total 434 * 39   * 16     0   22   259 258     *             79   517 434   39     16     0   22   259 258             79   517
2779153 CT     school   3360015   Unified School District #1 90000300436 3361515 Willard/Cybulski Correctional Institution State Agency Facilities           2020   pk_12_total 0 * 0   0 0     0   0   * 0     0             *   * 0   0   0 0     0   0     0     0            
2778820 CT     school 904440 1380011   Stratford School District 90444000899 1381411 Wilcoxson School Public Schools Regular School No Elementary KG 06 2020   pk_12_total 192 58 109   0 9     0   16   191 193     19             43   384 192 58 109   0 9     0   16   191 193     19       43   384
2778966 CT     school 904830 1510011   Waterbury School District 90483000992 1516311 Wilby High School Public Schools Regular School No High 09 12 2020   pk_12_total 84 286 661   * *     0   19   570 492     199             283   1062 84 286 661           0   19   570 492     199       283   1062
2778965 CT     school   1510011   Waterbury School District   1511711 Wilby ESC Program           2020   pk_12_total * * 7   0 0     0   0   * *     0             14   14     7   0 0     0   0           0       14   14
2778964 CT     school   1510011   Waterbury School District   1514511 Wilby Autism Program           2020   pk_12_total * * 7   0 0     0   0   * *     *             15   15     7   0 0     0   0                   15   15
2778496 CT     school   930011   New Haven School District   938511 Wilbur Cross Self Contained MD Program           2020   pk_12_total * * *   0 0     0   0   * *     0             6   6         0 0     0   0           0       6   6
2777818 CT     school 900450 150011   Bridgeport School District 90045000059 153911 Wilbur Cross School Public Schools Regular School No Elementary KG 08 2020   pk_12_total 33 125 127   0 *     0   *   160 129     25             56   289 33 125 127   0       0       160 129     25       56   289
2778492 CT     school 902790 930011   New Haven School District 90279000585 936111 Wilbur Cross High School Public Schools Regular School No High 09 12 2020   pk_12_total 173 410 936   * 28     0   *   781 772     316             259   1553 173 410 936     28     0       781 772     316       259   1553
2777742 CT     school   2440014   Area Cooperative Educational Services 90007001490 2449114 Whitney High School North Program           2020   pk_12_total 13 54 25   0 0     *   *   77 24     *             101   101 13 54 25   0 0             77 24             101   101
2777741 CT     school   2440014   Area Cooperative Educational Services 90007001502 2449214 Whitney Academy Program           2020   pk_12_total 43 22 30   0 *     0   *   75 25     *             100   100 43 22 30   0       0       75 25             100   100
2778987 CT     school 904920 1550011   West Hartford School District 90492001025 1551311 Whiting Lane School Public Schools Regular School No Elementary PK 05 2020   pk_12_total 180 29 69   0 40     *   *   195 140     58             100   335 180 29 69   0 40             195 140     58       100   335
2778996 CT     school   1550011   West Hartford School District 90492001780 1559511 Whiting Lane Learning Center Program           2020   pk_12_total 9 * *   0 *     0   0   * *     *             17   17 9       0       0   0                   17   17
2779185 CT     school   3370015   Department of Mental Health and Addiction Services 90002701922 3370915 Whiting Forensic Hospital State Agency Facilities           2020   pk_12_total 0 0 *   0 0     0   0   0 *     0             *   * 0 0     0 0     0   0   0       0            
2777866 CT     school 900540 180011   Brookfield School District 90054000112 185311 Whisconier Middle School Public Schools Regular School No Middle 05 08 2020   pk_12_total 628 17 111   * 61     *   *   416 413     25             125   829 628 17 111     61             416 413     25       125   829
2778543 CT     school 903060 1020011   North Stonington School District 90306000635 1026111 Wheeler High School Public Schools Regular School No High 07 12 2020   pk_12_total 269 * 12   * 6     *   18   175 139     0             27   314 269   12     6         18   175 139     0       27   314
2778479 CT     school 902790 930011   New Haven School District 90279000586 933211 Wexler/Grant Community School Public Schools Regular School No Elementary KG 08 2020   pk_12_total 8 251 93   0 0     0   9   189 172     13             65   361 8 251 93   0 0     0   9   189 172     13       65   361
2778481 CT     school   930011   New Haven School District   938611 Wexler Grant Self Contained Program           2020   pk_12_total * 7 *   0 0     0   0   * *     0             10   10   7     0 0     0   0           0       10   10
2779049 CT     school   1590011   Wethersfield School District   1590111 Wethersfield Transition Academy Program           2020   pk_12_total * 0 *   0 0     0   0   * *     0             6   6   0     0 0     0   0           0       6   6
2779048 CT     school 905070 1590011   Wethersfield School District 90507001068 1596111 Wethersfield High School Public Schools Regular School No High 09 12 2020   pk_12_total 804 46 204   * 62     *   24   574 *     38             140   1144 804 46 204     62         24   574       38       140   1144
2777959 CT     school 901020 340011   Danbury School District 90102001691 340311 Westside Middle School Academy Public Schools Regular School No Middle 06 08 2020   pk_12_total 325 47 245   0 57     0   17   351 340     56             52   691 325 47 245   0 57     0   17   351 340     56       52   691
2778791 CT     school 904320 1350011   Stamford School District 90432000872 1351411 Westover School Public Schools Regular School No Elementary KG 05 2020   pk_12_total 125 128 256   * 68     0   *   303 302     44             54   605 125 128 256     68     0       303 302     44       54   605
2779027 CT     school 905010 1570011   Weston School District 90501001047 1575111 Weston Middle School Public Schools Regular School No Middle 06 08 2020   pk_12_total 466 10 39   0 28     0   36   301 278     *             65   579 466 10 39   0 28     0   36   301 278             65   579
2779026 CT     school 905010 1570011   Weston School District 90501001428 1570211 Weston Intermediate School Public Schools Regular School No Elementary 03 05 2020   pk_12_total 381 11 45   0 32     0   28   255 242     *             58   497 381 11 45   0 32     0   28   255 242             58   497
2779028 CT     school 905010 1570011   Weston School District 90501001046 1576111 Weston High School Public Schools Regular School No High 09 12 2020   pk_12_total 685 14 29   0 35     0   29   421 371     *             78   792 685 14 29   0 35     0   29   421 371             78   792
2778800 CT     school 904320 1350011   Stamford School District 90432000871 1356311 Westhill High School Public Schools Regular School No High 09 12 2020   pk_12_total 753 327 967   * 131     *   52   1128 1108     476             283   2236 753 327 967     131         52   1128 1108     476       283   2236
2778391 CT     school 902640 880011   Naugatuck School District 90264000508 880711 Western School Public Schools Regular School No Elementary KG 04 2020   pk_12_total 125 25 81   * *     0   18   126 127     19             25   253 125 25 81           0   18   126 127     19       25   253
2778122 CT     school 901710 570011   Greenwich School District 90171000309 575311 Western Middle School Public Schools Regular School No Middle 06 08 2020   pk_12_total 286 29 243   * 51     0   *   335 297     31             99   632 286 29 243     51     0       335 297     31       99   632
2777962 CT     school   340011   Danbury School District   340711 Western Connection Program           2020   pk_12_total * * 0   0 0     0   0   * *     0             11   11     0   0 0     0   0           0       11   11
2777955 CT     school 901020 340011   Danbury School District 90102001438 341911 Western CT Academy of International Studies Elementary Magnet School Public Schools Regular School No Elementary KG 05 2020   pk_12_total 175 40 110   0 34     0   6   186 179     48             35   365 175 40 110   0 34     0   6   186 179     48       35   365
2779023 CT     school 904980 1540011   Westbrook School District 90498001043 1545111 Westbrook Middle School Public Schools Regular School No Middle 05 08 2020   pk_12_total 136 0 45   0 *     0   *   92 93     25             31   185 136 0 45   0       0       92 93     25       31   185
2779024 CT     school 904980 1540011   Westbrook School District 90498001044 1546111 Westbrook High School Public Schools Regular School No High 09 12 2020   pk_12_total 175 0 34   * *     0   7   113 111     14             38   224 175 0 34           0   7   113 111     14       38   224
2777849 CT     school   170011   Bristol School District   173611 West bristol Extended Resource Program           2020   pk_12_total 0 0 *   0 0     0   0   * 0     0             *   * 0 0     0 0     0   0     0     0            
2778089 CT     school 901560 520011   Farmington School District 90156001368 520511 West Woods Upper Elementary School Public Schools Regular School No Middle 04 06 2020   pk_12_total 363 33 55   * 160     0   *   313 321     19             79   634 363 33 55     160     0       313 321     19       79   634
2778159 CT     school 901860 620011   Hamden School District 90186000349 621411 West Woods School Public Schools Regular School No Elementary KG 06 2020   pk_12_total 161 62 43   * 48     0   *   179 162     21             38   341 161 62 43     48     0       179 162     21       38   341
2778162 CT     school   620011   Hamden School District   621811 West Woods IIC Program           2020   pk_12_total * 13 *   0 0     0   *   15 8     0             23   23   13     0 0     0       15 8     0       23   23
2778805 CT     school 904380 1370011   Stonington School District 90438000883 1370611 West Vine Street School Public Schools Regular School No Elementary PK 05 2020   pk_12_total 287 9 16   * *     0   33   176 178     *             63   354 287 9 16           0   33   176 178             63   354
2778771 CT     school 904290 1340011   Stafford School District 90429000848 1340411 West Stafford School Public Schools Regular School No Elementary PK 01 2020   pk_12_total 116 * 14   0 *     0   6   73 66     0             14   139 116   14   0       0   6   73 66     0       14   139
2778960 CT     school   1510011   Waterbury School District   1515511 West Side SCOPE Program           2020   pk_12_total * * *   0 0     0   0   * *     *             11   11         0 0     0   0                   11   11
2778137 CT     school 901770 590011   Groton School District 90177000326 595211 West Side Middle School   Regular School No Middle 06 08 2020   pk_12_total 209 63 150   * 26     *   49   306 197     19             108   503 209 63 150     26         49   306 197     19       108   503
2778946 CT     school 904830 1510011   Waterbury School District 90483000991 1515211 West Side Middle School Public Schools Regular School No Middle 06 08 2020   pk_12_total 151 217 497   12 19     0   43   456 483     97             161   939 151 217 497   12 19     0   43   456 483     97       161   939
2778959 CT     school   1510011   Waterbury School District   1515611 West Side Bilingual Program           2020   pk_12_total * 0 *   0 0     0   0   40 34     *             10   74   0     0 0     0   0   40 34             10   74
2778958 CT     school   1510011   Waterbury School District   1514711 West Side BDLC Program           2020   pk_12_total * 6 10   0 0     0   *   * *     *             19   19   6 10   0 0     0                       19   19
2778365 CT     school 902520 840011   Milford School District 90252000474 845311 West Shore Middle School Public Schools Regular School No Middle 06 08 2020   pk_12_total 295 31 77   * 60     *   *   241 230     9             74   471 295 31 77     60             241 230     9       74   471
2778424 CT     school 902700 900011   New Canaan School District 90270000534 900311 West School Public Schools Regular School No Elementary PK 04 2020   pk_12_total 398 * *   0 30     0   18   249 212     8             70   461 398       0 30     0   18   249 212     8       70   461
2778560 CT     school 903090 1030011   Norwalk School District 90309000661 1035411 West Rocks Middle School Public Schools Regular School No Middle 06 08 2020   pk_12_total 166 123 385   * 32     0   *   368 348     114             100   716 166 123 385     32     0       368 348     114       100   716
2778478 CT     school   930011   New Haven School District   938411 West Rock Self Contained Autism Program           2020   pk_12_total * 9 *   0 0     0   0   * *     0             12   12   9     0 0     0   0           0       12   12
2778463 CT     school   930011   New Haven School District   930410 West Rock Integrated PK Program           2020   pk_12_total * * *   0 0     0   0   * *     *             *   8         0 0     0   0                       8
2778462 CT     school 902790 930011   New Haven School District 90279000647 934911 West Rock Authors Academy Public Schools Regular School No Elementary PK 04 2020   pk_12_total 40 78 42   0 *     0   *   89 84     20             17   173 40 78 42   0       0       89 84     20       17   173
2778195 CT     school 901920 640011   Hartford School District 90192000384 642111 West Middle School Public Schools Regular School No Elementary PK 08 2020   pk_12_total 11 191 232   0 22     *   *   246 216     157             87   462 11 191 232   0 22             246 216     157       87   462
2778697 CT     school 903840 1190011   Rocky Hill School District 90384000786 1190511 West Hill School Public Schools Regular School No Elementary PK 03 2020   pk_12_total 141 7 23   * 312     *   10   256 241     102             52   497 141 7 23     312         10   256 241     102       52   497
2779021 CT     school 904950 1560011   West Haven School District 90495001041 1566111 West Haven High School Public Schools Regular School No High 09 12 2020   pk_12_total 452 367 592   * 69     0   *   775 760     142             198   1535 452 367 592     69     0       775 760     142       198   1535
2778088 CT     school 901560 520011   Farmington School District 90156000277 520311 West District School Public Schools Regular School No Elementary KG 04 2020   pk_12_total 201 * 31   * 61     0   16   170 153     38             27   323 201   31     61     0   16   170 153     38       27   323
2777842 CT     school 900510 170011   Bristol School District 90051001624 172011 West Bristol School Public Schools Regular School No Elementary KG 08 2020   pk_12_total 412 55 374   * *     0   58   456 463     83             168   919 412 55 374           0   58   456 463     83       168   919
2778340 CT     school 902490 830011   Middletown School District 90249000464 831411 Wesley School Public Schools Regular School No Elementary KG 05 2020   pk_12_total 123 46 36   0 9     0   22   126 110     *             37   236 123 46 36   0 9     0   22   126 110             37   236

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