Data source: Big Local News · About: Big Local

20,454 rows where state = "CT" and year = 2020 sorted by female descending

View and edit SQL

grade

year

  • 2020 · 20,454
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
2777979 CT     school 901170 400011   East Granby School District 90117000182 405111 East Granby Middle School Public Schools Regular School No Middle 06 08 2020   pk_12_total 144 20 *   0 20     0   *   100 99     *             26   199 144 20     0 20     0       100 99             26   199
2778284 CT     school   770011   Manchester School District 90231000519 778011 Manchester Preschool Center Program           2020   pk_12_total 37 54 81   0 17     0   7   97 99     0             49   196 37 54 81   0 17     0   7   97 99     0       49   196
2778629 CT     school 903515 2060012   Regional School District 06 90351500723 2060112 Goshen Center School Regional Schools Regular School No Elementary PK 06 2020   pk_12_total 172 * 6   0 *     0   11   94 98     6             28   192 172   6   0       0   11   94 98     6       28   192
2777725 CT     school 900030 10011   Andover School District 90003010001 10111 Andover Elementary School Public Schools Regular School No Elementary PK 06 2020   pk_12_total 158 * 24   0 0     0   *   99 96     *             21   195 158   24   0 0     0       99 96             21   195
2778839 CT     school 904500 1400011   Thomaston School District 90450001117 1400211 Thomaston Center School Public Schools Regular School No Middle 04 06 2020   pk_12_total 176 * 10   * *     *   *   100 96     *             27   196 176   10                   100 96             27   196
2778005 CT     school 901290 440011   East Haven School District 90129001350 441811 Overbrook Early Learning Center Public Schools Regular School No Elementary PK KG 2020   pk_12_total 99 * 56   0 9     0   *   80 95     0             *   175 99   56   0 9     0       80 95     0           175
2778338 CT     school 902490 830011   Middletown School District 90249000460 831211 Moody School Public Schools Regular School No Elementary KG 05 2020   pk_12_total 107 30 27   0 17     0   29   116 94     8             27   210 107 30 27   0 17     0   29   116 94     8       27   210
2779051 CT     school 905100 1600011   Willington School District 90510001070 1605111 Hall Memorial School Public Schools Regular School No Middle 05 08 2020   pk_12_total 174 6 18   0 *     0   *   107 94     0             36   201 174 6 18   0       0       107 94     0       36   201
2777871 CT     school 900660 220011   Canterbury School District 90066001187 225111 Dr. Helen Baldwin Middle School Public Schools Regular School No Middle 05 08 2020   pk_12_total 165 0 9   * *     0   0   84 93     0             19   177 165 0 9           0   0   84 93     0       19   177
2778299 CT     school 902340 780011   Mansfield School District 90234000434 780211 Dorothy C. Goodwin School Public Schools Regular School No Elementary PK 04 2020   pk_12_total 119 * 16   0 38     0   *   99 93     11             18   192 119   16   0 38     0       99 93     11       18   192
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
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
2778798 CT     school 904320 1350011   Stamford School District 90432000867 1356111 Stamford High School Public Schools Regular School No High 09 12 2020   pk_12_total 537 342 788   0 103     *   *   901 912     314             223   1813 537 342 788   0 103             901 912     314       223   1813
2777977 CT     school 901170 400011   East Granby School District 90117000180 400111 Allgrove School Public Schools Regular School No Elementary PK 02 2020   pk_12_total 145 16 *   * 12     0   13   107 90     10             28   197 145 16       12     0   13   107 90     10       28   197
2778416 CT     school 902670 890011   New Britain School District 90267001445 895411 House of Arts Letters and Science (HALS) Academy Public Schools Regular School No Middle 06 08 2020   pk_12_total 54 14 63   0 13     0   9   63 90     0             *   153 54 14 63   0 13     0   9   63 90     0           153
2777787 CT     school   140011   Branford School District 90042001742 140211 Branford High School Atlas Program Program           2020   pk_12_total 20 * *   0 0     0   0   18 9     0             *   27 20       0 0     0   0   18 9     0           27
2777819 CT     school   150011   Bridgeport School District 90045001472 159011 Bridgeport Learning Center Program           2020   pk_12_total 0 44 *   0 *     0   0   67 9     7             *   76 0 44     0       0   0   67 9     7           76
2777890 CT     school   2410014   Capitol Region Education Council 90070001510 2419514 River Street School Birken Campus Program           2020   pk_12_total 25 9 10   0 *     0   *   40 9     *             49   49 25 9 10   0       0       40 9             49   49
2777897 CT     school   2410014   Capitol Region Education Council   2411914 CREC Impact Academy Program           2020   pk_12_total * 14 21   0 0     0   *   29 9     *             *   38   14 21   0 0     0       29 9                 38
2777925 CT     school   2430014   Cooperative Educational Services 90091001561 2439114 Preschool-Primary Learning Center (PLC) Program           2020   pk_12_total 16 12 16   0 *     *   *   42 9     0             51   51 16 12 16   0               42 9     0       51   51
2778297 CT     school   770011   Manchester School District 90231001599 779111 Manchester Transition Center Program           2020   pk_12_total 11 7 8   0 0     0   0   17 9     *             26   26 11 7 8   0 0     0   0   17 9             26   26
2778326 CT     school   800011   Meriden School District   801911 TLC - PHS Program           2020   pk_12_total * * 10   0 *     0   *   11 9     *             20   20     10   0       0       11 9             20   20
2778385 CT     school   880011   Naugatuck School District 90264001591 888211 Central Avenue Preschool Program           2020   pk_12_total 18 * *   0 0     0   0   18 9     0             27   27 18       0 0     0   0   18 9     0       27   27
2778585 CT     school   1040011   Norwich School District   1041011 Transition Academy Program           2020   pk_12_total 11 * *   0 *     0   *   14 9     *             23   23 11       0       0       14 9             23   23
2778724 CT     school   1260011   Shelton School District   1260711 Transition Program Program           2020   pk_12_total * * 0   0 0     0   0   10 9     0             19   19     0   0 0     0   0   10 9     0       19   19
2778830 CT     school   1380011   Stratford School District 90444001671 1380711 High School Sails Program           2020   pk_12_total * * 6   0 0     0   *   8 9     *             17   17     6   0 0     0       8 9             17   17
2779005 CT     school   1550011   West Hartford School District 90492001600 1559211 Strive-West Hartford Program           2020   pk_12_total 8 * 15   0 *     0   *   25 9     *             34   34 8   15   0       0       25 9             34   34
2779137 CT     school   2070012   Regional School District 07   2070112 Highlander Transition Academy Program           2020   pk_12_total * 0 *   0 0     0   0   6 9     0             15   15   0     0 0     0   0   6 9     0       15   15
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
2779039 CT     school 905040 1580011   Westport School District 90504001058 1586111 Staples High School Public Schools Regular School No High 09 12 2020   pk_12_total 1513 36 106   0 118     0   55   945 883     9             222   1828 1513 36 106   0 118     0   55   945 883     9       222   1828
2778272 CT     school 902220 740011   Litchfield School District 90222000407 740311 Litchfield Intermediate School Public Schools Regular School No Middle 04 06 2020   pk_12_total 174 * 8   0 *     0   *   102 88     0             29   190 174   8   0       0       102 88     0       29   190
2779140 CT     school 903570 2110012   Regional School District 11 90357000765 2116112 Parish Hill High School Regional Schools Regular School No High 07 12 2020   pk_12_total 176 * 14   0 0     0   *   115 88     *             37   203 176   14   0 0     0       115 88             37   203
2777978 CT     school 901170 400011   East Granby School District 90117000183 400211 R. Dudley Seymour School Public Schools Regular School No Elementary 03 05 2020   pk_12_total 134 9 17   * 12     *   7   94 87     *             30   181 134 9 17     12         7   94 87             30   181
2777813 CT     school 900450 150011   Bridgeport School District 90045000060 150711 Edison School Public Schools Regular School No Elementary KG 06 2020   pk_12_total 20 81 71   * 7     *   *   100 86     11             40   186 20 81 71     7             100 86     11       40   186
2779105 CT     school 900780 260011   Chester School District 90078000130 260111 Chester Elementary School Public Schools Regular School No Elementary KG 06 2020   pk_12_total 163 * 15   0 *     0   6   100 86     *             24   186 163   15   0       0   6   100 86             24   186
2778180 CT     school 901920 640011   Hartford School District 90192001643 641311 Hartford PreKindergarten Magnet School Public Schools Regular School No Prekindergarten PK PK 2020   pk_12_total 18 56 26   * 56     0   *   76 85     0             9   161 18 56 26     56     0       76 85     0       9   161
2778674 CT     school 903540 2180012   Regional School District 18 90354000762 2180112 Lyme Consolidated School Regional Schools Regular School No Elementary KG 05 2020   pk_12_total 173 0 13   0 *     *   11   117 85     8             27   202 173 0 13   0           11   117 85     8       27   202
2778861 CT     school   1440011   Trumbull School District 90462000683 1448011 Trumbull Early Childhood Education Center Program           2020   pk_12_total 135 11 50   0 27     *   *   141 85     0             71   226 135 11 50   0 27             141 85     0       71   226
2777780 CT     school 900390 130011   Bozrah School District 90039000038 130111 Fields Memorial School Public Schools Regular School No Elementary PK 08 2020   pk_12_total 146 * 20   0 0     0   *   101 84     *             28   185 146   20   0 0     0       101 84             28   185
2778253 CT     school 903450 2450014   Learn 90345001556 2455014 Dual Language & Arts Magnet Middle School   Regular School No Middle 06 08 2020   pk_12_total 37 17 76   0 0     0   18   64 84     34             37   148 37 17 76   0 0     0   18   64 84     34       37   148
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
2777824 CT     school 900450 150011   Bridgeport School District 90045000056 156211 Central High School Public Schools Regular School No High 09 12 2020   pk_12_total 223 594 683   15 47     *   *   742 835     246             242   1577 223 594 683   15 47             742 835     246       242   1577
2778009 CT     school 901290 440011   East Haven School District 90129000215 441311 Dominick H. Ferrara School Public Schools Regular School No Elementary 03 05 2020   pk_12_total 92 * 46   0 12     0   *   81 83     16             26   164 92   46   0 12     0       81 83     16       26   164
2778300 CT     school 902340 780011   Mansfield School District 90234000435 780511 Southeast Elementary School Public Schools Regular School No Elementary PK 04 2020   pk_12_total 111 6 24   * 17     0   *   78 83     8             25   161 111 6 24     17     0       78 83     8       25   161
2778638 CT     school 903530 2120012   Regional School District 12 90353000735 2120412 Washington Primary School Regional Schools Regular School No Elementary PK 05 2020   pk_12_total 119 0 *   0 0     0   *   55 83     *             11   138 119 0     0 0     0       55 83             11   138
2778002 CT     school 901260 430011   East Hartford School District 90126000200 436211 East Hartford High School Public Schools Regular School No High 09 12 2020   pk_12_total 212 580 754   * 84     *   45   868 814     171             294   1682 212 580 754     84         45   868 814     171       294   1682
2778568 CT     school 903120 1040011   Norwich School District 90312000663 1040111 Bishop School Early Learning Center Public Schools Regular School No Prekindergarten PK PK 2020   pk_12_total 54 34 66   * 10     *   12   97 81     0             61   178 54 34 66     10         12   97 81     0       61   178
2778693 CT     school 903810 1180011   Ridgefield School District 90381000779 1186111 Ridgefield High School Public Schools Regular School No High 09 12 2020   pk_12_total 1306 14 115   * 114     *   43   * 801     *             162   1596 1306 14 115     114         43     801             162   1596
2778921 CT     school   1510011   Waterbury School District 90483000548 1518011 Special Education Preschool Program           2020   pk_12_total 26 37 140   0 11     0   6   140 80     *             130   220 26 37 140   0 11     0   6   140 80             130   220
2777861 CT     school   170011   Bristol School District 90051001746 173311 Bristol Preparatory Academy Program           2020   pk_12_total 26 * 11   0 0     0   *   32 8     0             0   40 26   11   0 0     0       32 8     0       0   40
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
2778189 CT     school   640011   Hartford School District   640410 Pre-K Integrated - Parkville School Program           2020   pk_12_total * * 15   0 0     0   0   9 8     0             7   17     15   0 0     0   0   9 8     0       7   17
2778190 CT     school   640011   Hartford School District   640610 Pre-K Integrated - West Middle School Program           2020   pk_12_total * 7 7   0 *     0   0   10 8     0             10   18   7 7   0       0   0   10 8     0       10   18
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
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
2778250 CT     school   2450014   Learn 90345001680 2451114 Learn Intensive Program Program           2020   pk_12_total 12 7 9   0 *     0   *   27 8     *             35   35 12 7 9   0       0       27 8             35   35
2778350 CT     school   830011   Middletown School District 90249001765 831711 Virtual Learning Academy - MHS Program           2020   pk_12_total 7 * *   0 0     0   0   8 8     0             *   16 7       0 0     0   0   8 8     0           16
2778475 CT     school   930011   New Haven School District   937711 Nathan Hale Self Contained ID Program           2020   pk_12_total * * 9   0 0     0   0   9 8     *             17   17     9   0 0     0   0   9 8             17   17
2778833 CT     school   1380011   Stratford School District 90444001437 1389011 Strive-Stratford Program           2020   pk_12_total 6 * *   0 0     0   0   7 8     *             15   15 6       0 0     0   0   7 8             15   15
2778869 CT     school   1440011   Trumbull School District 90462001762 1440511 REACH Program           2020   pk_12_total 14 * *   0 0     0   *   10 8     0             18   18 14       0 0     0       10 8     0       18   18
2778905 CT     school   1480011   Wallingford School District   1481711 Inspire High School Program           2020   pk_12_total 14 0 *   0 *     0   0   14 8     *             22   22 14 0     0       0   0   14 8             22   22
2778934 CT     school   1510011   Waterbury School District   1516911 Gilmartin Scope Program           2020   pk_12_total * * 13   0 0     0   0   10 8     7             *   18     13   0 0     0   0   10 8     7           18
2778938 CT     school   1510011   Waterbury School District   1512411 Reed ESC Program           2020   pk_12_total * 6 17   0 0     0   *   18 8     *             26   26   6 17   0 0     0       18 8             26   26
2779040 CT     school   1590011   Wethersfield School District   1590411 ABA Program           2020   pk_12_total * * 10   0 *     0   *   8 8     *             16   16     10   0       0       8 8             16   16
2779079 CT     school   1650011   Windsor Locks School District 90525001777 1650211 RISE Transition Academy Program           2020   pk_12_total 10 * *   0 0     0   *   7 8     0             15   15 10       0 0     0       7 8     0       15   15
2779131 CT     school   2070012   Regional School District 07 90372001401 2079212 Links Program           2020   pk_12_total * 0 0   0 0     0   *   16 8     0             24   24   0 0   0 0     0       16 8     0       24   24
2779179 CT     school   2190012   Regional School District 19 90000501729 2190112 E.O. Smith High School at the Depot Campus Program           2020   pk_12_total 19 0 *   0 0     0   *   14 8     0             7   22 19 0     0 0     0       14 8     0       7   22
2778294 CT     school 902310 770011   Manchester School District 90231000424 776111 Manchester High School Public Schools Regular School No High 09 12 2020   pk_12_total 546 403 443   * 127     *   66   800 797     96             200   1597 546 403 443     127         66   800 797     96       200   1597
2778561 CT     school 903090 1030011   Norwalk School District 90309000638 1036211 Brien McMahon High School Public Schools Regular School No High 09 12 2020   pk_12_total 357 272 897   0 56     0   29   820 791     268             209   1611 357 272 897   0 56     0   29   820 791     268       209   1611
2778080 CT     school 901530 510011   Fairfield School District 90153001379 516011 Fairfield Ludlowe High School Public Schools Regular School No High 09 12 2020   pk_12_total 1213 * 130   * 90     0   45   713 787     *             191   1500 1213   130     90     0   45   713 787             191   1500
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
2778935 CT     school   1510011   Waterbury School District   1514211 Hopeville Bilingual Program           2020   pk_12_total 0 0 151   0 0     0   0   74 77     151             18   151 0 0 151   0 0     0   0   74 77     151       18   151
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
2778622 CT     school 903420 1140011   Preston School District 90342000717 1145111 Preston Plains School Public Schools Regular School No Middle 06 08 2020   pk_12_total 122 * 7   * *     0   9   72 75     *             29   147 122   7           0   9   72 75             29   147
2778168 CT     school 901860 620011   Hamden School District 90186000339 626111 Hamden High School Public Schools Regular School No High 09 12 2020   pk_12_total 540 524 314   * 122     *   65   822 748     75             236   1570 540 524 314     122         65   822 748     75       236   1570
2778061 CT     school 901470 490011   Enfield School District 90147000243 496111 Enfield High School Public Schools Regular School No High 09 12 2020   pk_12_total 1049 87 237   * 63     *   64   764 746     17             223   1510 1049 87 237     63         64   764 746     17       223   1510
2779004 CT     school 904920 1550011   West Hartford School District 90492001015 1556211 Hall High School Public Schools Regular School No High 09 12 2020   pk_12_total 916 126 226   * 168     *   75   773 741     47             163   1514 916 126 226     168         75   773 741     47       163   1514
2779129 CT     school 903660 2050012   Regional School District 05 90366000770 2056112 Amity Regional High School Regional Schools Regular School No High 09 12 2020   pk_12_total 1087 54 28   * 219     *   61   723 732     10             176   1455 1087 54 28     219         61   723 732     10       176   1455
2778024 CT     school 901380 390011   Eastford School District 90138000232 390111 Eastford Elementary School Public Schools Regular School No Elementary PK 08 2020   pk_12_total 128 0 10   0 0     0   12   78 72     0             32   150 128 0 10   0 0     0   12   78 72     0       32   150
2778217 CT     school 901920 640011   Hartford School District 90192000369 641611 M. L. King, Jr. Middle School Public Schools Regular School No Middle 06 08 2020   pk_12_total * 121 42   0 *     0   *   97 72     17             45   169   121 42   0       0       97 72     17       45   169
2777911 CT     school 900750 250011   Cheshire School District 90075000123 256111 Cheshire High School Public Schools Regular School No High 09 12 2020   pk_12_total 1113 37 76   * 161     0   *   688 717     9             168   1405 1113 37 76     161     0       688 717     9       168   1405
2777903 CT     school 900750 250011   Cheshire School District 90075011188 250211 Darcey School Public Schools Regular School No Elementary PK KG 2020   pk_12_total 138 * *   0 14     0   16   114 71     *             50   185 138       0 14     0   16   114 71             50   185
2778549 CT     school 903090 1030011   Norwalk School District 90309001914 1030111 Norwalk Early Childhood Center Public Schools Regular School No Prekindergarten PK PK 2020   pk_12_total 53 15 67   * 12     0   *   84 71     0             92   155 53 15 67     12     0       84 71     0       92   155
2779003 CT     school 904920 1550011   West Hartford School District 90492001013 1556111 Conard High School Public Schools Regular School No High 09 12 2020   pk_12_total 762 131 287   * 195     0   *   733 704     48             163   1437 762 131 287     195     0       733 704     48       163   1437
2777752 CT     school   50011   Barkhamsted School District 90015001373 58011 Shared Services Integrated Preschool Program           2020   pk_12_total 17 0 0   0 0     0   0   10 7     0             6   17 17 0 0   0 0     0   0   10 7     0       6   17
2777853 CT     school   170011   Bristol School District   170811 Chippens Hilll Middle School Extended Resource Program           2020   pk_12_total * 0 8   0 *     0   0   7 7     *             14   14   0 8   0       0   0   7 7             14   14
2777937 CT     school   320011   Coventry School District 90096001787 320111 Coventry Academy Public Schools           2020   pk_12_total 14 0 *   0 0     0   *   12 7     0             8   19 14 0     0 0     0       12 7     0       8   19
2778062 CT     school   490011   Enfield School District 90147001523 499011 Enfield Transitional Learning Academy Program           2020   pk_12_total 12 * 0   0 *     0   *   10 7     0             17   17 12   0   0       0       10 7     0       17   17
2778082 CT     school   510011   Fairfield School District   510311 Walter Fitzgerald Campus Program           2020   pk_12_total 19 * *   0 0     0   0   20 7     *             *   27 19       0 0     0   0   20 7                 27
2778083 CT     school   510011   Fairfield School District   510511 Fairfield School/Community Partnership Program           2020   pk_12_total 16 * *   0 *     0   0   13 7     0             20   20 16       0       0   0   13 7     0       20   20
2778153 CT     school   620011   Hamden School District   620711 Alice Peck IIC Program           2020   pk_12_total * 12 8   0 *     0   *   24 7     0             31   31   12 8   0       0       24 7     0       31   31
2778314 CT     school   800011   Meriden School District   800911 STEP - ES Program           2020   pk_12_total 9 * 23   0 0     0   *   36 7     *             43   43 9   23   0 0     0       36 7             43   43
2778351 CT     school   830011   Middletown School District 90249001657 831611 Evening Program - MHS Program           2020   pk_12_total * 6 *   0 0     0   *   8 7     0             0   15   6     0 0     0       8 7     0       0   15
2778354 CT     school   830011   Middletown School District 90249001598 839111 Middletown Transition Center Program           2020   pk_12_total 10 * *   * 0     0   *   11 7     0             18   18 10         0     0       11 7     0       18   18
2778397 CT     school   880011   Naugatuck School District   881011 Naugatuck Community Program Program           2020   pk_12_total 10 * *   0 *     0   *   10 7     0             17   17 10       0       0       10 7     0       17   17
2778410 CT     school   890011   New Britain School District   891911 Smith Pathways Program           2020   pk_12_total 0 * 13   0 *     0   *   9 7     *             16   16 0   13   0       0       9 7             16   16
2778801 CT     school   1350011   Stamford School District 90432001749 1350211 Individuals Achieving Independence Program           2020   pk_12_total * 7 *   0 0     0   0   10 7     *             17   17   7     0 0     0   0   10 7             17   17
2778813 CT     school   1380011   Stratford School District 90444001734 1380611 ABA - K-6 Program           2020   pk_12_total 9 * 7   0 *     0   *   18 7     0             25   25 9   7   0       0       18 7     0       25   25
2778852 CT     school   1430011   Torrington School District   1430611 TPS Preschool Lab Program           2020   pk_12_total 15 0 *   0 *     0   0   11 7     0             *   18 15 0     0       0   0   11 7     0           18
2778883 CT     school   1460011   Vernon School District 90468001525 1469011 Next Step Program Program           2020   pk_12_total 9 * *   0 0     0   0   7 7     0             14   14 9       0 0     0   0   7 7     0       14   14

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