Data source: Big Local News · About: Big Local

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

View and edit SQL

year

  • 2020 · 1,361

grade

  • pk_12_total · 1,361
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
2778474 CT     school   930011   New Haven School District   930310 Lincoln Bassett Self Contained Program           2020   pk_12_total 0 * *   0 0     0   0   * *     0             10   10 0       0 0     0   0           0       10   10
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
2778567 CT     school   1030011   Norwalk School District   1030611 Norwalk 18-21 Project SEARCH Program           2020   pk_12_total * 0 *   0 0     0   0   * *     *             10   10   0     0 0     0   0                   10   10
2778718 CT     school   1260011   Shelton School District   1261311 Alternative Learning Center 2 Program           2020   pk_12_total * 0 0   0 *     0   0   * *     *             10   10   0 0   0       0   0                   10   10
2778828 CT     school   1380011   Stratford School District   1380111 BRIDGES 9-12 Program           2020   pk_12_total * 0 *   0 0     0   0   * *     *             10   10   0     0 0     0   0                   10   10
2778831 CT     school   1380011   Stratford School District 90444001710 1382011 STEPS 9-12 Program           2020   pk_12_total * * *   0 0     0   0   * *     0             10   10         0 0     0   0           0       10   10
2778951 CT     school   1510011   Waterbury School District   1511811 North End ESC Program           2020   pk_12_total * 0 *   0 0     0   0   * *     0             10   10   0     0 0     0   0           0       10   10
2779014 CT     school   1560011   West Haven School District 90495001799 1560111 Life Skills Program           2020   pk_12_total * * *   0 0     0   0   * *     *             10   10         0 0     0   0                   10   10
2779055 CT     school   1610011   Wilton School District   1610211 Genesis Program           2020   pk_12_total * 0 *   0 0     0   0   * *     0             *   10   0     0 0     0   0           0           10
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
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
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
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
2778003 CT     school   430011   East Hartford School District 90126001377 436411 Synergy Alternative Program Program           2020   pk_12_total * 27 63   0 0     0   *   68 33     12             30   101   27 63   0 0     0       68 33     12       30   101
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
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
2777738 CT     school   2440014   Area Cooperative Educational Services 90007001505 2449414 Mill Academy Program           2020   pk_12_total 15 46 34   0 0     0   7   85 17     0             95   102 15 46 34   0 0     0   7   85 17     0       95   102
2778043 CT     school   490011   Enfield School District 90147000207 498011 Head Start Program Program           2020   pk_12_total 59 * 29   0 *     0   9   55 47     0             10   102 59   29   0       0   9   55 47     0       10   102
2778065 CT     school   510011   Fairfield School District 90153000989 518011 Early Childhood Center(0518011) Program           2020   pk_12_total 67 0 20   0 9     0   6   63 39     0             65   102 67 0 20   0 9     0   6   63 39     0       65   102
2778436 CT     school 902760 920011   New Hartford School District 90276000539 920111 Bakerville Consolidated School Public Schools Regular School No Elementary KG 02 2020   pk_12_total 98 0 *   0 0     0   *   52 50     *             8   102 98 0     0 0     0       52 50             8   102
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
2778710 CT     school 904020 1250011   Sharon School District 90402000795 1250111 Sharon Center School Public Schools Regular School No Elementary PK 08 2020   pk_12_total 88 0 10   0 *     0   *   56 47     *             28   103 88 0 10   0       0       56 47             28   103
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
2778792 CT     school   1350011   Stamford School District 90432001744 1350411 Anchor Program           2020   pk_12_total * 32 49   0 0     0   *   58 46     13             61   104   32 49   0 0     0       58 46     13       61   104
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
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
2778705 CT     school 903960 1230011   Scotland School District 90396000789 1230111 Scotland Elementary School Public Schools Regular School No Elementary PK 06 2020   pk_12_total * 0 *   0 0     0   0   48 58     0             21   106   0     0 0     0   0   48 58     0       21   106
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
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
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
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
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
2778401 CT     school   890011   New Britain School District   891611 Gaffney KEY Elementary Program           2020   pk_12_total 14 16 63   0 8     0   7   81 27     0             92   108 14 16 63   0 8     0   7   81 27     0       92   108
2777770 CT     school   110011   Bloomfield School District   110111 Steps to Success Program           2020   pk_12_total * 9 *   0 0     0   0   11 0     0             11   11   9     0 0     0   0   11 0     0       11   11
2777839 CT     school   170011   Bristol School District 90051001755 173011 South Side Extended Resource Program           2020   pk_12_total * * 6   0 0     0   *   * *     *             11   11     6   0 0     0                       11   11
2777851 CT     school   170011   Bristol School District 90051001748 171011 Chippens Hill Middle School Functional Program Program           2020   pk_12_total * * 6   0 0     0   0   * *     *             11   11     6   0 0     0   0                   11   11
2777896 CT     school   2410014   Capitol Region Education Council 90070001489 2419214 Farmington Valley Regional Diagnostic Center Program           2020   pk_12_total 8 * 0   0 0     0   *   * *     0             *   11 8   0   0 0     0               0           11
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
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
2778331 CT     school   800011   Meriden School District 90240001800 800211 Community Classroom Collaborative Program           2020   pk_12_total * * 6   0 0     0   0   * *     *             11   11     6   0 0     0   0                   11   11
2778396 CT     school   880011   Naugatuck School District   880911 Genesis Academy Program           2020   pk_12_total * * *   0 0     0   0   * *     *             0   11         0 0     0   0                   0   11
2778471 CT     school   930011   New Haven School District   937811 Clinton Self Contained ID Program           2020   pk_12_total * * 9   0 0     0   0   * *     *             11   11     9   0 0     0   0                   11   11
2778579 CT     school   1040011   Norwich School District   1040411 Strive Autism Program @ Huntington Program           2020   pk_12_total * * *   0 *     0   0   * *     *             11   11         0       0   0                   11   11
2778597 CT     school   1080011   Oxford School District   1080411 Connections Alternative Learning Center Program           2020   pk_12_total * 0 *   0 0     0   0   * *     0             *   11   0     0 0     0   0           0           11
2778768 CT     school   1310011   Southington School District   1312211 STELLAR Program           2020   pk_12_total * 0 0   0 0     0   *   * *     0             11   11   0 0   0 0     0               0       11   11
2778872 CT     school   1440011   Trumbull School District   1440611 Educating Learners in Transitional Environments (ELITE) Program           2020   pk_12_total * 0 *   0 0     0   0   * *     0             11   11   0     0 0     0   0           0       11   11
2778880 CT     school   1460011   Vernon School District   1460811 Renaissance Program Program           2020   pk_12_total * * *   0 0     0   *   * *     0             11   11         0 0     0               0       11   11
2778941 CT     school   1510011   Waterbury School District   1510411 B.W. Tinker BDLC             2020   pk_12_total 0 * 6   0 0     0   *   * *     0             11   11 0   6   0 0     0               0       11   11
2778954 CT     school   1510011   Waterbury School District   1514411 Wallace BDLC Program           2020   pk_12_total * * 8   0 0     0   0   * *     *             11   11     8   0 0     0   0                   11   11
2778956 CT     school   1510011   Waterbury School District   1514911 Wallace SCOPE Program           2020   pk_12_total * * 6   0 0     0   0   * *     *             11   11     6   0 0     0   0                   11   11
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
2778988 CT     school   1550011   West Hartford School District 90492001705 1559311 Braeburn Learning Center Program           2020   pk_12_total * * *   0 0     0   *   * *     *             11   11         0 0     0                       11   11
2779018 CT     school   1560011   West Haven School District   1560711 Blended Program           2020   pk_12_total 6 * *   0 0     0   0   * *     0             *   11 6       0 0     0   0           0           11
2779032 CT     school   1580011   Westport School District   1580211 GFS Intensive Resource Program           2020   pk_12_total 7 0 *   0 *     0   0   * *     0             11   11 7 0     0       0   0           0       11   11
2779113 CT     school 901360 2530014   Eastern Connecticut Regional Educational Service Center (EASTCONN) 90136001937 2530314 LEAP Alternative High School Regional Education Service Center Schools Alternative School No High 10 12 2020   pk_12_total * 0 8   0 0     0   *   * *     *             *   11   0 8   0 0     0                           11
2779114 CT     school   2530014   Eastern Connecticut Regional Educational Service Center (EASTCONN)   2530114 Regional Transitional Services Program           2020   pk_12_total * * 0   0 0     0   0   * *     0             11   11     0   0 0     0   0           0       11   11
2779175 CT     school 905371 9010022   Norwich Free Academy District 90537101221 9010322 Alternative Pathways to Success Program Regular School No High 09 12 2020   pk_12_total * * 0   0 0     0   0   * *     0             *   11     0   0 0     0   0           0           11
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
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
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
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
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
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
2777829 CT     school 900510 170011   Bristol School District 90051001774 170411 Bristol Early Childhood Center-BECC Public Schools Special Education School No Prekindergarten PK PK 2020   pk_12_total 68 0 31   0 *     0   *   75 38     0             70   113 68 0 31   0       0       75 38     0       70   113
2778940 CT     school   1510011   Waterbury School District 90483000958 1519011 State Street School Program           2020   pk_12_total 9 30 68   0 *     0   *   82 31     21             113   113 9 30 68   0       0       82 31     21       113   113
2779143 CT     school   3360015   Unified School District #1 90000300404 3361115 Manson Youth Institution State Agency Facilities           2020   pk_12_total 13 54 40   0 0     0   6   113 0     *             93   113 13 54 40   0 0     0   6   113 0             93   113
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
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
2779109 CT     school   2530014   Eastern Connecticut Regional Educational Service Center (EASTCONN) 90136001156 2539014 EastConn Special Education Program           2020   pk_12_total 78 * 22   * 0     0   8   93 21     *             114   114 78   22     0     0   8   93 21             114   114
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
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
2778084 CT     school   520011   Farmington School District 90156001441 528011 Farmington Collaborative PK Program           2020   pk_12_total 69 8 15   0 16     0   7   60 55     0             35   115 69 8 15   0 16     0   7   60 55     0       35   115
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
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
2777889 CT     school   2410014   Capitol Region Education Council 90070001495 2419314 River Street School Program           2020   pk_12_total 57 28 24   0 *     0   *   96 20     0             116   116 57 28 24   0       0       96 20     0       116   116
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
2778242 CT     school   690011   Killingly School District 90207000083 698011 Goodyear Early Childhood Center Program           2020   pk_12_total 93 0 11   0 *     0   *   68 49     0             36   117 93 0 11   0       0       68 49     0       36   117
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
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
2777766 CT     school   90011   Bethel School District   90311 TASK Program           2020   pk_12_total 6 0 *   0 *     0   *   * *     *             *   12 6 0     0       0                           12
2777931 CT     school   2430014   Cooperative Educational Services 90091001555 2439314 RISE Transitional Program Program           2020   pk_12_total 8 0 *   0 0     0   *   * *     0             12   12 8 0     0 0     0               0       12   12
2778057 CT     school   490011   Enfield School District   490911 John F. Kennedy - Adaptive Learning Program (ALP) Program           2020   pk_12_total * * *   0 *     0   0   * *     *             12   12         0       0   0                   12   12
2778104 CT     school   540011   Glastonbury School District 90162001752 541411 Glastonbury Transition Academy Program           2020   pk_12_total 7 * *   0 *     0   0   * *     0             12   12 7       0       0   0           0       12   12
2778316 CT     school   800011   Meriden School District   802311 SOAR - LMS             2020   pk_12_total * * 9   0 0     0   0   * *     6             12   12     9   0 0     0   0           6       12   12
2778468 CT     school   930011   New Haven School District   937911 Bishop Woods Self Contained Autism Program           2020   pk_12_total * * 8   0 0     0   0   * *     *             12   12     8   0 0     0   0                   12   12
2778473 CT     school   930011   New Haven School District   938711 Fair Haven Self Contained ID Program           2020   pk_12_total * 6 *   0 0     0   *   12 0     0             12   12   6     0 0     0       12 0     0       12   12
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
2778761 CT     school   1310011   Southington School District 90423001668 1310511 EASE Program           2020   pk_12_total 8 * *   0 0     0   0   6 6     0             12   12 8       0 0     0   0   6 6     0       12   12
2778953 CT     school   1510011   Waterbury School District   1514811 North End SCOPE Program           2020   pk_12_total * * 6   0 0     0   *   6 6     *             12   12     6   0 0     0       6 6             12   12
2779072 CT     school   1630011   Windham School District   1631211 Assisted Work Program Program           2020   pk_12_total * 0 *   0 0     0   0   * *     6             12   12   0     0 0     0   0           6       12   12
2779086 CT     school   1640011   Windsor School District   1640311 Spark Program           2020   pk_12_total * 7 *   0 0     0   *   * *     0             12   12   7     0 0     0               0       12   12
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
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
2778149 CT     school   620011   Hamden School District 90186001433 628011 Alice Peck Learning Center Program           2020   pk_12_total 36 36 25   0 16     0   9   66 56     0             58   122 36 36 25   0 16     0   9   66 56     0       58   122
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
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
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

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