Data source: Big Local News · About: Big Local

20,454 rows where state = "CT" and year = 2020 sorted by total_int 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 ▲
2777961 CT     school 901020 340011   Danbury School District 90102000150 346111 Danbury High School Public Schools Regular School No High 09 12 2020   pk_12_total 1102 275 1613   * 228     *   68   1713 1579     551             443   3292 1102 275 1613     228         68   1713 1579     551       443   3292
2778123 CT     school 901710 570011   Greenwich School District 90171000300 576111 Greenwich High School Public Schools Regular School No High 09 12 2020   pk_12_total 1745 84 626   * 194     *   92   1375 *     80             339   2749 1745 84 626     194         92   1375       80       339   2749
2779174 CT     school 905371 9010022   Norwich Free Academy District 90537101221 9016122 Norwich Free Academy Endowed and Incorporated Academies Schools Regular School No High 09 12 2020   pk_12_total 1173 330 390   26 180     10   132   1078 1163     212             248   2241 1173 330 390   26 180     10   132   1078 1163     212       248   2241
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
2778421 CT     school 902670 890011   New Britain School District 90267000521 896111 New Britain High School Public Schools Regular School No High 09 12 2020   pk_12_total 407 317 1375   * 68     *   48   1170 1051     421             513   2221 407 317 1375     68         48   1170 1051     421       513   2221
2778870 CT     school 904620 1440011   Trumbull School District 90462000937 1446111 Trumbull High School Public Schools Regular School No High 09 12 2020   pk_12_total 1514 115 259   * 160     *   28   1001 1081     17             220   2082 1514 115 259     160         28   1001 1081     17       220   2082
2778766 CT     school 904230 1310011   Southington School District 90423000838 1316211 Southington High School Public Schools Regular School No High 09 12 2020   pk_12_total 1660 45 167   * 82     *   72   978 1052     15             260   2030 1660 45 167     82         72   978 1052     15       260   2030
2778103 CT     school 901620 540011   Glastonbury School District 90162000283 546111 Glastonbury High School Public Schools Regular School No High 09 12 2020   pk_12_total 1415 69 155   * 215     *   87   928 1019     9             202   1947 1415 69 155     215         87   928 1019     9       202   1947
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
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
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
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
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
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
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
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
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
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
2778526 CT     school 902910 970011   Newtown School District 90291000615 976111 Newtown High School Public Schools Regular School No High 09 12 2020   pk_12_total 1306 24 103   0 65     0   18   770 *     *             151   1516 1306 24 103   0 65     0   18   770               151   1516
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
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
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
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
2778564 CT     school 903090 1030011   Norwalk School District 90309000655 1036111 Norwalk High School Public Schools Regular School No High 09 12 2020   pk_12_total 435 244 699   * 45     0   *   765 *     245             232   1445 435 244 699     45     0       765       245       232   1445
2778081 CT     school 901530 510011   Fairfield School District 90153000256 516211 Fairfield Warde High School Public Schools Regular School No High 09 12 2020   pk_12_total 1022 * 225   0 85     *   55   740 698     42             198   1438 1022   225   0 85         55   740 698     42       198   1438
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
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
2777969 CT     school 901050 350011   Darien School District 90105000164 356111 Darien High School Public Schools Regular School No High 09 12 2020   pk_12_total 1218 20 79   * 72     0   *   718 686     *             262   1404 1218 20 79     72     0       718 686             262   1404
2778723 CT     school 904050 1260011   Shelton School District 90405000806 1266111 Shelton High School Public Schools Regular School No High 09 12 2020   pk_12_total 946 86 188   * 84     0   *   696 *     22             167   1357 946 86 188     84     0       696       22       167   1357
2778510 CT     school 902850 960011   New Milford School District 90285000602 966111 New Milford High School Public Schools Regular School No High 09 12 2020   pk_12_total 1024 32 186   0 52     0   36   706 *     44             161   1330 1024 32 186   0 52     0   36   706       44       161   1330
2778733 CT     school 904110 1280011   Simsbury School District 90411000813 1286111 Simsbury High School Public Schools Regular School No High 09 12 2020   pk_12_total 1027 69 115   0 89     *   *   689 641     9             169   1330 1027 69 115   0 89             689 641     9       169   1330
2778427 CT     school 902700 900011   New Canaan School District 90270000532 905111 Saxe Middle School Public Schools Regular School No Middle 05 08 2020   pk_12_total 1079 18 68   * 110     *   43   682 642     8             159   1324 1079 18 68     110         43   682 642     8       159   1324
2778428 CT     school 902700 900011   New Canaan School District 90270000531 906111 New Canaan High School Public Schools Regular School No High 09 12 2020   pk_12_total 1120 * 62   * 79     0   38   678 646     *             170   1324 1120   62     79     0   38   678 646             170   1324
2778518 CT     school 902880 940011   Newington School District 90288000610 946111 Newington High School Public Schools Regular School No High 09 12 2020   pk_12_total 786 80 255   * 114     *   64   694 607     19             150   1301 786 80 255     114         64   694 607     19       150   1301
2778745 CT     school 904170 1320011   South Windsor School District 90417000826 1326211 South Windsor High School Public Schools Regular School No High 09 12 2020   pk_12_total 785 95 110   0 241     *   *   663 630     14             192   1293 785 95 110   0 241             663 630     14       192   1293
2778349 CT     school 902490 830011   Middletown School District 90249000465 836211 Middletown High School Public Schools Regular School No High 09 12 2020   pk_12_total 652 277 211   * 64     *   75   616 667     27             148   1283 652 277 211     64         75   616 667     27       148   1283
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
2779038 CT     school 905040 1580011   Westport School District 90504001048 1585111 Bedford Middle School Public Schools Regular School No Middle 06 08 2020   pk_12_total 985 23 94   0 76     0   81   637 622     12             185   1259 985 23 94   0 76     0   81   637 622     12       185   1259
2778091 CT     school 901560 520011   Farmington School District 90156000273 526111 Farmington High School Public Schools Regular School No High 09 12 2020   pk_12_total 846 48 74   * 250     0   *   607 637     13             154   1244 846 48 74     250     0       607 637     13       154   1244
2778395 CT     school 902640 880011   Naugatuck School District 90264000505 886111 Naugatuck High School Public Schools Regular School No High 09 12 2020   pk_12_total 665 117 349   0 51     0   58   661 579     64             223   1240 665 117 349   0 51     0   58   661 579     64       223   1240
2778660 CT     school 903537 2150012   Regional School District 15 90353700749 2156212 Pomperaug Regional High School Regional Schools Regular School No High 09 12 2020   pk_12_total 1028 15 71   * 65     *   21   607 601     6             197   1208 1028 15 71     65         21   607 601     6       197   1208
2778322 CT     school 902400 800011   Meriden School District 90240000441 806111 Francis T. Maloney High School Public Schools Regular School No High 09 12 2020   pk_12_total 369 127 605   0 53     0   43   604 593     174             186   1197 369 127 605   0 53     0   43   604 593     174       186   1197
2777859 CT     school 900510 170011   Bristol School District 90051000092 176111 Bristol Central High School Public Schools Regular School No High 09 12 2020   pk_12_total 669 81 352   * *     0   48   606 *     42             225   1187 669 81 352           0   48   606       42       225   1187
2778962 CT     school 904830 1510011   Waterbury School District 90483000979 1516411 John F. Kennedy High School Public Schools Regular School No High 09 12 2020   pk_12_total 206 247 670   10 18     0   18   628 541     204             245   1169 206 247 670   10 18     0   18   628 541     204       245   1169
2779100 CT     school 900212 2880013   Achievement First Hartford Academy District 90021201528 2880113 Achievement First Hartford Academy Public Charter Schools Regular School Yes Other KG 12 2020   pk_12_total * 842 299   6 *     *   15   553 616     70             117   1169   842 299   6           15   553 616     70       117   1169
2777968 CT     school 901050 350011   Darien School District 90105000169 355111 Middlesex Middle School Public Schools Regular School No Middle 06 08 2020   pk_12_total 979 * 65   * 66     0   33   584 572     6             169   1156 979   65     66     0   33   584 572     6       169   1156
2777826 CT     school 900450 150011   Bridgeport School District 90045000067 156311 Warren Harding High School Public Schools Regular School No High 09 12 2020   pk_12_total 81 385 668   * *     *   9   622 531     363             277   1153 81 385 668               9   622 531     363       277   1153
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
2777796 CT     school 900450 150011   Bridgeport School District 90045000070 151411 Cesar Batalla School Public Schools Regular School No Elementary PK 08 2020   pk_12_total 98 225 782   * 15     *   11   613 528     555             180   1141 98 225 782     15         11   613 528     555       180   1141
2778961 CT     school 904830 1510011   Waterbury School District 90483000971 1516211 Crosby High School Public Schools Regular School No High 09 12 2020   pk_12_total 150 293 654   8 19     0   14   607 531     188             309   1138 150 293 654   8 19     0   14   607 531     188       309   1138
2777999 CT     school 901260 430011   East Hartford School District 90126000197 435111 East Hartford Middle School Public Schools Regular School No Middle 06 08 2020   pk_12_total 106 358 564   * 39     *   60   612 521     162             242   1133 106 358 564     39         60   612 521     162       242   1133
2778945 CT     school 904830 1510011   Waterbury School District 90483000983 1515111 Michael F. Wallace Middle School Public Schools Regular School No Middle 04 08 2020   pk_12_total 139 266 645   12 25     0   38   561 564     133             194   1125 139 266 645   12 25     0   38   561 564     133       194   1125
2778148 CT     school 901800 600011   Guilford School District 90180000332 606111 Guilford High School Public Schools Regular School No High 08 12 2020   pk_12_total 936 * 77   0 45     *   39   548 566     *             125   1114 936   77   0 45         39   548 566             125   1114
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
2779099 CT     school 900208 2850013   Achievement First Bridgeport Academy District 90020801493 2850113 Achievement First Bridgeport Academy Public Charter Schools Regular School Yes Other KG 12 2020   pk_12_total 13 596 487   * 6     *   *   524 586     148             112   1110 13 596 487     6             524 586     148       112   1110
2779182 CT     school 905373 9030022   The Woodstock Academy District 90537311223 9036122 The Woodstock Academy Endowed and Incorporated Academies Schools Regular School No High 09 12 2020   pk_12_total 928 * 49   * 107     0   11   552 555     0             69   1107 928   49     107     0   11   552 555     0       69   1107
2779101 CT     school 900024 2790013   Amistad Academy District 90002400981 2795113 Amistad Academy Public Charter Schools Regular School Yes Other KG 12 2020   pk_12_total * 684 381   * 0     0   20   498 605     111             80   1103   684 381     0     0   20   498 605     111       80   1103
2777860 CT     school 900510 170011   Bristol School District 90051000093 176211 Bristol Eastern High School Public Schools Regular School No High 09 12 2020   pk_12_total 677 67 260   * 36     *   35   * 545     30             216   1079 677 67 260     36         35     545     30       216   1079
2778058 CT     school 901470 490011   Enfield School District 90147000249 495211 John F. Kennedy Middle School Public Schools Regular School No Middle 06 08 2020   pk_12_total 751 69 186   * *     0   47   554 524     19             168   1078 751 69 186           0   47   554 524     19       168   1078
2778487 CT     school 902790 930011   New Haven School District 90279000563 936211 James Hillhouse High School Public Schools Regular School No High 09 12 2020   pk_12_total 47 604 394   * 12     *   14   568 506     190             224   1074 47 604 394     12         14   568 506     190       224   1074
2777794 CT     school 900450 150011   Bridgeport School District 90045000053 154011 Blackham School Public Schools Regular School No Elementary PK 08 2020   pk_12_total 182 276 551   10 38     *   *   589 481     282             141   1070 182 276 551   10 38             589 481     282       141   1070
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
2779178 CT     school 900005 2190012   Regional School District 19 90000501215 2196112 E. O. Smith High School Regional Schools Regular School No High 09 12 2020   pk_12_total 784 11 104   * 47     *   112   501 561     7             144   1062 784 11 104     47         112   501 561     7       144   1062
2777958 CT     school 901020 340011   Danbury School District 90102000160 345211 Rogers Park Middle School Public Schools Regular School No Middle 06 08 2020   pk_12_total 297 72 611   0 47     *   *   533 516     366             135   1049 297 72 611   0 47             533 516     366       135   1049
2778743 CT     school 904170 1320011   South Windsor School District 90417000827 1325111 Timothy Edwards School Public Schools Regular School No Middle 06 08 2020   pk_12_total 578 72 84   * 258     *   55   530 *     25             125   1049 578 72 84     258         55   530       25       125   1049
2778216 CT     school 901920 640011   Hartford School District 90192001295 645411 Hartford Magnet Trinity College Academy Public Schools Regular School No High 06 12 2020   pk_12_total 177 266 504   * 42     *   50   489 557     98             127   1046 177 266 504     42         50   489 557     98       127   1046
2778906 CT     school 904740 1480011   Wallingford School District 90474000955 1486111 Lyman Hall High School Public Schools Regular School No High 09 12 2020   pk_12_total 761 31 191   * 42     0   *   476 561     25             155   1037 761 31 191     42     0       476 561     25       155   1037
2778832 CT     school 904440 1380011   Stratford School District 90444000897 1386111 Stratford High School Public Schools Regular School No High 09 12 2020   pk_12_total 345 248 371   * 31     0   *   509 514     68             108   1023 345 248 371     31     0       509 514     68       108   1023
2778280 CT     school 902280 760011   Madison School District 90228000411 766111 Daniel Hand High School Public Schools Regular School No High 09 12 2020   pk_12_total 885 * 45   * 41     0   34   542 *     *             118   1014 885   45     41     0   34   542               118   1014
2778829 CT     school 904440 1380011   Stratford School District 90444000885 1386211 Bunnell High School Public Schools Regular School No High 09 12 2020   pk_12_total 413 248 299   * 33     0   *   500 512     17             103   1012 413 248 299     33     0       500 512     17       103   1012
2778857 CT     school 904590 1430011   Torrington School District 90459000925 1435111 Torrington Middle School Public Schools Regular School No Middle 06 08 2020   pk_12_total 570 46 299   * 44     *   40   512 490     80             188   1002 570 46 299     44         40   512 490     80       188   1002
2778540 CT     school 903030 1010011   North Haven School District 90303000631 1016111 North Haven High School Public Schools Regular School No High 09 12 2020   pk_12_total 778 43 85   * 63     0   *   502 498     12             108   1000 778 43 85     63     0       502 498     12       108   1000
2778375 CT     school 902550 850011   Monroe School District 90255000489 856111 Masuk High School Public Schools Regular School No High 09 12 2020   pk_12_total 798 * 102   * 48     0   29   492 505     9             116   997 798   102     48     0   29   492 505     9       116   997
2778018 CT     school 901320 450011   East Lyme School District 90132000223 456111 East Lyme High School Public Schools Regular School No High 09 12 2020   pk_12_total 767 12 70   * 87     *   57   498 498     6             115   996 767 12 70     87         57   498 498     6       115   996
2777957 CT     school 901020 340011   Danbury School District 90102000149 345111 Broadview Middle School Public Schools Regular School No Middle 06 08 2020   pk_12_total 335 88 484   * 45     0   *   506 483     154             170   989 335 88 484     45     0       506 483     154       170   989
2778138 CT     school 901770 590011   Groton School District 90177000318 596111 Robert E. Fitch High School Public Schools Regular School No High 09 12 2020   pk_12_total 532 89 200   * 62     *   83   509 472     28             150   981 532 89 200     62         83   509 472     28       150   981
2778323 CT     school 902400 800011   Meriden School District 90240000449 806211 Orville H. Platt High School Public Schools Regular School No High 09 12 2020   pk_12_total 227 122 578   * *     0   28   488 492     124             165   980 227 122 578           0   28   488 492     124       165   980
2778226 CT     school 901920 640011   Hartford School District 90192001925 646211 Hartford Public High School Public Schools Regular School No High 09 12 2020   pk_12_total 28 309 602   * 28     *   6   528 448     314             208   976 28 309 602     28         6   528 448     314       208   976
2777750 CT     school 900120 40011   Avon School District 90012000011 46111 Avon High School Public Schools Regular School No High 09 12 2020   pk_12_total 658 48 60   * 153     0   *   510 447     6             101   957 658 48 60     153     0       510 447     6       101   957
2779053 CT     school 905130 1610011   Wilton School District 90513001073 1615211 Middlebrook School Public Schools Regular School No Middle 06 08 2020   pk_12_total 713 * 66   * 97     0   55   447 498     *             132   945 713   66     97     0   55   447 498             132   945
2778102 CT     school 901620 540011   Glastonbury School District 90162000282 545211 Smith Middle School Public Schools Regular School No Middle 06 08 2020   pk_12_total 640 * 97   * 120     0   54   * 494     13             110   944 640   97     120     0   54     494     13       110   944
2772117 CT     school 901020 340011   Danbury School District 90102000150 346111 Danbury High School Public Schools Regular School No High 09 12 2020   grade_9                                                   941                                             941
2779139 CT     school 903750 2080012   Regional School District 08 90375000772 2086112 RHAM High School Regional Schools Regular School No High 09 12 2020   pk_12_total 864 12 37   * 20     *   6   477 464     *             119   941 864 12 37     20         6   477 464             119   941
2778509 CT     school 902850 960011   New Milford School District 90285000603 965211 Schaghticoke Middle School Public Schools Regular School No Middle 06 08 2020   pk_12_total 668 * 164   * 30     0   52   490 449     35             154   939 668   164     30     0   52   490 449     35       154   939
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
2779017 CT     school 904950 1560011   West Haven School District 90495001036 1565111 Harry M. Bailey Middle School Public Schools Regular School No Middle 07 08 2020   pk_12_total 295 222 353   * 32     *   29   491 443     64             147   934 295 222 353     32         29   491 443     64       147   934
2779001 CT     school 904920 1550011   West Hartford School District 90492001021 1555211 Sedgwick Middle School Public Schools Regular School No Middle 06 08 2020   pk_12_total 496 85 207   * 95     *   33   445 475     49             114   920 496 85 207     95         33   445 475     49       114   920
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
2777758 CT     school 900210 70011   Berlin School District 90021000016 76111 Berlin High School Public Schools Regular School No High 09 12 2020   pk_12_total 741 * 87   * 39     0   30   486 425     6             113   911 741   87     39     0   30   486 425     6       113   911
2777831 CT     school 900510 170011   Bristol School District 90051000098 170511 Greene-Hills School Public Schools Regular School No Elementary PK 08 2020   pk_12_total 449 76 307   * 44     *   31   469 440     72             123   909 449 76 307     44         31   469 440     72       123   909
2778290 CT     school 902310 770011   Manchester School District 90231001533 771711 Elisabeth M. Bennet Academy Public Schools Regular School No Middle 05 06 2020   pk_12_total 290 231 302   * 64     *   15   465 442     71             157   907 290 231 302     64         15   465 442     71       157   907
2777765 CT     school 900270 90011   Bethel School District 90027000024 96111 Bethel High School Public Schools Regular School No High 09 12 2020   pk_12_total 607 31 174   * 76     *   13   482 423     34             123   905 607 31 174     76         13   482 423     34       123   905
2778077 CT     school 901530 510011   Fairfield School District 90153000258 515211 Fairfield Woods Middle School Public Schools Regular School No Middle 06 08 2020   pk_12_total 669 20 105   0 67     0   42   473 430     15             127   903 669 20 105   0 67     0   42   473 430     15       127   903
2778417 CT     school 902670 890011   New Britain School District 90267000518 895311 Pulaski Middle School Public Schools Regular School No Middle 06 08 2020   pk_12_total 158 83 613   * 23     0   *   500 401     184             194   901 158 83 613     23     0       500 401     184       194   901
2778952 CT     school 904830 1510011   Waterbury School District 90483001115 1515311 North End Middle School Public Schools Regular School No Middle 06 08 2020   pk_12_total 81 208 560   7 6     0   38   449 451     89             167   900 81 208 560   7 6     0   38   449 451     89       167   900
2778011 CT     school 901290 440011   East Haven School District 90129000216 446111 East Haven High School Public Schools Regular School No High 09 12 2020   pk_12_total 552 42 238   * 51     0   *   466 *     77             133   898 552 42 238     51     0       466       77       133   898
2779000 CT     school 904920 1550011   West Hartford School District 90492001017 1555111 King Philip Middle School Public Schools Regular School No Middle 06 08 2020   pk_12_total 517 81 152   0 93     *   *   459 436     41             121   895 517 81 152   0 93             459 436     41       121   895
2778166 CT     school 901860 620011   Hamden School District 90186000342 625211 Hamden Middle School Public Schools Regular School No Middle 07 08 2020   pk_12_total 297 273 205   * 54     *   45   449 427     31             160   876 297 273 205     54         45   449 427     31       160   876
2778858 CT     school 904590 1430011   Torrington School District 90459000924 1436111 Torrington High School Public Schools Regular School No High 09 12 2020   pk_12_total 486 44 262   * 51     *   25   460 *     68             149   875 486 44 262     51         25   460       68       149   875
2778367 CT     school 902520 840011   Milford School District 90252000473 846311 Joseph A. Foran High School Public Schools Regular School No High 09 12 2020   pk_12_total 687 50 71   0 59     *   *   428 444     *             121   872 687 50 71   0 59             428 444             121   872

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