Data source: Big Local News · About: Big Local

1,449 rows where grade = "pk_12_total", state = "CT" and year = 2019 sorted by total

View and edit SQL

year

  • 2019 · 1,349

grade

  • pk_12_total · 1,349
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
2453027 CT     school 905130 1610011   Wilton School District 90513001073 1615211 Middlebrook School Public Schools Regular School No Middle 06 08 2019   pk_12_total 770 * 66   * 104     0   54   471 532     *             138   1003 770   66     104     0   54   471 532             138   1003
2452379 CT     school   890011   New Britain School District   891611 Gaffney KEY Elementary Program           2019   pk_12_total 14 13 63   0 *     0   *   74 28     0             102   102 14 13 63   0       0       74 28     0       102   102
2452912 CT     school   1510011   Waterbury School District 90483000958 1519011 State Street School Program           2019   pk_12_total 8 24 65   0 *     0   *   77 25     24             *   102 8 24 65   0       0       77 25     24           102
2452519 CT     school 903030 1010011   North Haven School District 90303000631 1016111 North Haven High School Public Schools Regular School No High 09 12 2019   pk_12_total 827 38 73   * 64     *   29   528 506     11             117   1034 827 38 73     64         29   528 506     11       117   1034
2452110 CT     school 901770 590011   Groton School District 90177000318 596111 Robert E. Fitch High School Public Schools Regular School No High 09 12 2019   pk_12_total 574 98 185   17 72     6   84   542 494     20             148   1036 574 98 185   17 72     6   84   542 494     20       148   1036
2452015 CT     school   490011   Enfield School District 90147000207 498011 Head Start Program Program           2019   pk_12_total 59 6 34   0 *     0   *   56 48     0             14   104 59 6 34   0       0       56 48     0       14   104
2452805 CT     school 904440 1380011   Stratford School District 90444000885 1386211 Bunnell High School Public Schools Regular School No High 09 12 2019   pk_12_total 444 256 296   0 29     0   21   516 530     13             121   1046 444 256 296   0 29     0   21   516 530     13       121   1046
2452680 CT     school 903960 1230011   Scotland School District 90396000789 1230111 Scotland Elementary School Public Schools Regular School No Elementary PK 06 2019   pk_12_total 99 0 *   0 0     0   *   46 59     0             18   105 99 0     0 0     0       46 59     0       18   105
2451967 CT     school 901260 430011   East Hartford School District 90126000197 435111 East Hartford Middle School Public Schools Regular School No Middle 06 08 2019   pk_12_total 107 321 519   * 42     *   60   537 514     120             203   1051 107 321 519     42         60   537 514     120       203   1051
2452921 CT     school 904830 1510011   Waterbury School District 90483000983 1515111 Michael F. Wallace Middle School Public Schools Regular School No Middle 06 08 2019   pk_12_total 143 248 599   10 22     0   30   543 509     122             199   1052 143 248 599   10 22     0   30   543 509     122       199   1052
2452185 CT     school 901920 640011   Hartford School District 90192001295 645411 Hartford Magnet Trinity College Academy Public Schools Regular School No High 06 12 2019   pk_12_total 192 272 485   * 48     *   53   487 570     78             126   1057 192 272 485     48         53   487 570     78       126   1057
2451829 CT     school 900510 170011   Bristol School District 90051000093 176211 Bristol Eastern High School Public Schools Regular School No High 09 12 2019   pk_12_total 701 74 227   * 28     *   31   539 526     22             220   1065 701 74 227     28         31   539 526     22       220   1065
2451765 CT     school 900450 150011   Bridgeport School District 90045000053 154011 Blackham School Public Schools Regular School No Elementary PK 08 2019   pk_12_total 221 293 487   * 41     *   13   606 461     237             151   1067 221 293 487     41         13   606 461     237       151   1067
2451800 CT     school 900510 170011   Bristol School District 90051001774 170411 Bristol Early Childhood Center-BECC Public Schools Special Education School No Prekindergarten PK PK 2019   pk_12_total 66 * 29   0 *     0   8   62 45     0             65   107 66   29   0       0   8   62 45     0       65   107
2451767 CT     school 900450 150011   Bridgeport School District 90045000070 151411 Cesar Batalla School Public Schools Regular School No Elementary PK 08 2019   pk_12_total 90 210 730   8 25     *   *   585 487     478             155   1072 90 210 730   8 25             585 487     478       155   1072
2452257 CT     school 902280 760011   Madison School District 90228000411 766111 Daniel Hand High School Public Schools Regular School No High 09 12 2019   pk_12_total 937 * 49   * 45     0   33   557 *     0             114   1072 937   49     45     0   33   557       0       114   1072
2452879 CT     school 904740 1480011   Wallingford School District 90474000955 1486111 Lyman Hall High School Public Schools Regular School No High 09 12 2019   pk_12_total 795 33 198   0 39     *   *   502 572     24             164   1074 795 33 198   0 39             502 572     24       164   1074
2452036 CT     school   510011   Fairfield School District 90153000989 518011 Early Childhood Center(0518011) Program           2019   pk_12_total 80 * 15   0 *     0   *   66 42     0             83   108 80   15   0       0       66 42     0       83   108
2451797 CT     school 900450 150011   Bridgeport School District 90045000067 156311 Warren Harding High School Public Schools Regular School No High 09 12 2019   pk_12_total 67 403 597   * *     *   7   598 484     319             229   1082 67 403 597               7   598 484     319       229   1082
2453072 CT     school 900024 2790013   Amistad Academy District 90002400981 2795113 Amistad Academy Public Charter Schools Regular School Yes Other KG 12 2019   pk_12_total 19 681 360   * *     0   21   509 574     118             71   1083 19 681 360           0   21   509 574     118       71   1083
2452054 CT     school   520011   Farmington School District 90156001441 528011 Farmington Collaborative PK Program           2019   pk_12_total 69 6 13   0 14     0   7   61 48     0             30   109 69 6 13   0 14     0   7   61 48     0       30   109
2453140 CT     school 900005 2190012   Regional School District 19 90000501215 2196112 E. O. Smith High School Regional Schools Regular School No High 09 12 2019   pk_12_total 783 * 96   0 45     *   144   533 558     9             135   1091 783   96   0 45         144   533 558     9       135   1091
2453070 CT     school 900208 2850013   Achievement First Bridgeport Academy District 90020801493 2850113 Achievement First Bridgeport Academy Public Charter Schools Regular School Yes Other KG 12 2019   pk_12_total 13 584 480   * 9     *   *   512 581     131             97   1093 13 584 480     9             512 581     131       97   1093
2452118 CT     school 901800 600011   Guilford School District 90180000332 606111 Guilford High School Public Schools Regular School No High 09 12 2019   pk_12_total 921 14 82   0 47     0   31   542 553     *             125   1095 921 14 82   0 47     0   31   542 553             125   1095
2453145 CT     school 905373 9030022   The Woodstock Academy District 90537311223 9036122 The Woodstock Academy Endowed and Incorporated Academies Schools Regular School No High 09 12 2019   pk_12_total 925 * 26   * 124     0   11   545 553     0             74   1098 925   26     124     0   11   545 553     0       74   1098
2451823 CT     school   170011   Bristol School District 90051001753 173411 Chms Goal Program           2019   pk_12_total * * 7   0 0     0   0   * *     *             11   11     7   0 0     0   0                   11   11
2451995 CT     school   2530014   Eastern Connecticut Regional Educational Service Center (EASTCONN)   2530114 Regional Transitional Services Program           2019   pk_12_total * * 0   0 0     0   0   * *     0             11   11     0   0 0     0   0           0       11   11
2452206 CT     school 901920 640011   Hartford School District 90192001650 643911 Capital Community College Magnet Academy   Regular School No High 12 12 2019   pk_12_total * 7 *   0 0     0   *   * *     0             *   11   7     0 0     0               0           11
2452225 CT     school   2450014   Learn   2451614 LEARN SAILS Program Program           2019   pk_12_total 6 * *   0 0     0   *   * *     0             11   11 6       0 0     0               0       11   11
2452310 CT     school   800011   Meriden School District 90240001800 800211 Community Classroom Collaborative Program           2019   pk_12_total * * *   * 0     0   0   * *     *             11   11           0     0   0                   11   11
2452328 CT     school   830011   Middletown School District   832211 MHS- Alternative Education Program 3 Program           2019   pk_12_total 7 * *   0 0     0   0   * *     0             *   11 7       0 0     0   0           0           11
2452458 CT     school   930011   New Haven School District   938411 West Rock Self Contained Autism Program           2019   pk_12_total * 7 *   0 0     0   0   * *     0             11   11   7     0 0     0   0           0       11   11
2452670 CT     school   1180011   Ridgefield School District 90381001763 1188011 Alternative High School Program           2019   pk_12_total * 0 *   0 0     0   0   * *     0             *   11   0     0 0     0   0           0           11
2452734 CT     school   1310011   Southington School District 90423001786 1310411 Language Based Classroom at Hatton School Program           2019   pk_12_total * 0 *   0 0     0   0   * *     0             11   11   0     0 0     0   0           0       11   11
2452736 CT     school   1310011   Southington School District 90423001668 1310511 EASE Program           2019   pk_12_total 7 * *   0 0     0   0   * *     0             11   11 7       0 0     0   0           0       11   11
2452987 CT     school   1560011   West Haven School District 90495001799 1560111 Life Skills Program           2019   pk_12_total * * 6   0 0     0   0   * *     *             11   11     6   0 0     0   0                   11   11
2453023 CT     school   1590011   Wethersfield School District   1590111 Wethersfield Transition Academy Program           2019   pk_12_total 7 * *   0 0     0   0   * *     0             11   11 7       0 0     0   0           0       11   11
2451937 CT     school 901050 350011   Darien School District 90105000169 355111 Middlesex Middle School Public Schools Regular School No Middle 06 08 2019   pk_12_total 947 * 61   * 57     0   27   552 549     *             152   1101 947   61     57     0   27   552 549             152   1101
2452782 CT     school 904380 1370011   Stonington School District 90438000882 1370411 West Broad Street School   Regular School No Elementary 03 04 2019   pk_12_total 90 * 6   * *     0   10   50 61     *             20   111 90   6           0   10   50 61             20   111
2453058 CT     school 905220 1640011   Windsor School District 90522001096 1646111 Windsor High School Public Schools Regular School No High 09 12 2019   pk_12_total 273 552 190   0 *     *   54   570 540     22             209   1110 273 552 190   0           54   570 540     22       209   1110
2453071 CT     school 900212 2880013   Achievement First Hartford Academy District 90021201528 2880113 Achievement First Hartford Academy Public Charter Schools Regular School Yes Other KG 12 2019   pk_12_total * 782 304   * *     *   15   519 593     52             115   1112   782 304               15   519 593     52       115   1112
2452301 CT     school 902400 800011   Meriden School District 90240000441 806111 Francis T. Maloney High School Public Schools Regular School No High 09 12 2019   pk_12_total 355 119 575   0 43     0   42   579 555     166             177   1134 355 119 575   0 43     0   42   579 555     166       177   1134
2452119 CT     school   620011   Hamden School District 90186001433 628011 Alice Peck Learning Center Program           2019   pk_12_total 42 27 19   0 15     0   11   69 45     0             57   114 42 27 19   0 15     0   11   69 45     0       57   114
2453022 CT     school 905070 1590011   Wethersfield School District 90507001068 1596111 Wethersfield High School Public Schools Regular School No High 09 12 2019   pk_12_total 805 52 191   6 66     0   20   * 582     26             130   1140 805 52 191   6 66     0   20     582     26       130   1140
2452029 CT     school 901470 490011   Enfield School District 90147000249 495211 John F. Kennedy Middle School Public Schools Regular School No Middle 06 08 2019   pk_12_total 791 68 194   * 40     *   50   598 551     18             167   1149 791 68 194     40         50   598 551     18       167   1149
2453082 CT     school 904020 1250011   Sharon School District 90402000795 1250111 Sharon Center School Public Schools Regular School No Elementary KG 08 2019   pk_12_total 98 0 10   0 *     *   *   61 54     *             25   115 98 0 10   0               61 54             25   115
2451828 CT     school 900510 170011   Bristol School District 90051000092 176111 Bristol Central High School Public Schools Regular School No High 09 12 2019   pk_12_total 679 77 315   * *     0   42   596 557     30             219   1153 679 77 315           0   42   596 557     30       219   1153
2452935 CT     school 904830 1510011   Waterbury School District 90483000971 1516211 Crosby High School Public Schools Regular School No High 09 12 2019   pk_12_total 172 306 645   * 13     *   18   637 525     188             311   1162 172 306 645     13         18   637 525     188       311   1162
2451860 CT     school   2410014   Capitol Region Education Council 90070001495 2419314 River Street School Program           2019   pk_12_total 64 24 22   0 *     0   *   96 21     0             117   117 64 24 22   0       0       96 21     0       117   117
2452437 CT     school   930011   New Haven School District   938011 Lulac             2019   pk_12_total * 28 85   0 0     *   0   61 56     0             8   117   28 85   0 0         0   61 56     0       8   117
2452215 CT     school   690011   Killingly School District 90207000083 698011 Goodyear Early Childhood Center Program           2019   pk_12_total 94 * 7   0 *     0   12   66 52     0             34   118 94   7   0       0   12   66 52     0       34   118
2451738 CT     school   90011   Bethel School District   90311 TASK Program           2019   pk_12_total * 0 *   0 *     0   *   * *     *             *   12   0     0       0                           12
2451808 CT     school   170011   Bristol School District 90051001755 173011 South Side Extended Resource Program           2019   pk_12_total * 0 8   0 0     0   *   * *     *             12   12   0 8   0 0     0                       12   12
2451872 CT     school   2410014   Capitol Region Education Council 90070001802 2419714 Strive (Southern Transition Real-World and Independent Vocational Education Program Program           2019   pk_12_total * 0 0   0 *     0   0   * *     0             12   12   0 0   0       0   0           0       12   12
2451882 CT     school   250011   Cheshire School District 90075001766 250311 Cheshire Quinnipiac University Transition Collaborative Program           2019   pk_12_total 10 * 0   0 *     0   0   * *     0             12   12 10   0   0       0   0           0       12   12
2452032 CT     school   490011   Enfield School District 90147001523 499011 Enfield Transitional Learning Academy Program           2019   pk_12_total * * 0   0 0     0   0   6 6     0             12   12     0   0 0     0   0   6 6     0       12   12
2452126 CT     school   620011   Hamden School District   621611 Helen Street IIC Program           2019   pk_12_total * * 6   0 *     0   0   12 0     *             12   12     6   0       0   0   12 0             12   12
2452138 CT     school   620011   Hamden School District   620611 Hamden Transition Academy @ SCSU (AACPB) Program           2019   pk_12_total * 6 0   0 *     0   0   * *     0             12   12   6 0   0       0   0           0       12   12
2452303 CT     school   800011   Meriden School District   802511 SOAR - PHS Program           2019   pk_12_total * * 6   0 *     0   0   * *     *             12   12     6   0       0   0                   12   12
2452460 CT     school   930011   New Haven School District   937411 Celentano Self Contained ID Program           2019   pk_12_total * * *   0 0     0   *   * *     *             12   12         0 0     0                       12   12
2452546 CT     school   1040011   Norwich School District   1040511 Special Needs Program @ Mahan Program           2019   pk_12_total * * 6   0 *     0   *   6 6     *             12   12     6   0       0       6 6             12   12
2452719 CT     school 904170 1320011   South Windsor School District 90417000826 1320311 Alternative Education Program Program Regular School No High 09 12 2019   pk_12_total * * 0   0 0     0   0   * *     0             *   12     0   0 0     0   0           0           12
2452867 CT     school   1480011   Wallingford School District 90474001595 1489211 WISE Intermediate Program Program           2019   pk_12_total 7 * *   * 0     0   0   * *     0             12   12 7         0     0   0           0       12   12
2453045 CT     school   1630011   Windham School District   1631211 Assisted Work Program Program           2019   pk_12_total * 0 9   * 0     0   0   * *     *             12   12   0 9     0     0   0                   12   12
2453100 CT     school   2070012   Regional School District 07   2070112 Highlander Transition Academy Program           2019   pk_12_total 12 0 0   0 0     0   0   * *     0             12   12 12 0 0   0 0     0   0           0       12   12
2453110 CT     school   3360015   Unified School District #1 90000300849 3362515 York Correctional Institution State Agency Facilities           2019   pk_12_total * * *   0 0     0   0   0 12     0             *   12         0 0     0   0   0 12     0           12
2451992 CT     school   2530014   Eastern Connecticut Regional Educational Service Center (EASTCONN) 90136001156 2539014 EastConn Special Education Program           2019   pk_12_total 82 6 26   * 0     0   *   94 26     *             120   120 82 6 26     0     0       94 26             120   120
2451993 CT     school 901360 2530014   Eastern Connecticut Regional Educational Service Center (EASTCONN) 90136001507 2536014 Arts at the Capitol Theater Magnet School (ACT) Regional Education Service Center Schools Regular School No High 09 12 2019   pk_12_total 70 * 32   * 0     0   9   30 90     *             23   120 70   32     0     0   9   30 90             23   120
2452638 CT     school 903537 2150012   Regional School District 15 90353700749 2156212 Pomperaug Regional High School Regional Schools Regular School No High 09 12 2019   pk_12_total 1018 17 75   * 69     *   19   632 575     6             196   1207 1018 17 75     69         19   632 575     6       196   1207
2452182 CT     school 901920 640011   Hartford School District 90192001582 644011 Renzulli Gifted and Talented Academy Public Schools Regular School No Middle 04 08 2019   pk_12_total 9 53 49   * *     0   6   64 59     *             *   123 9 53 49           0   6   64 59                 123
2452936 CT     school 904830 1510011   Waterbury School District 90483000979 1516411 John F. Kennedy High School Public Schools Regular School No High 09 12 2019   pk_12_total 246 250 692   11 21     0   24   635 609     223             259   1244 246 250 692   11 21     0   24   635 609     223       259   1244
2452061 CT     school 901560 520011   Farmington School District 90156000273 526111 Farmington High School Public Schools Regular School No High 09 12 2019   pk_12_total 849 62 73   * 243     0   *   629 617     14             156   1246 849 62 73     243     0       629 617     14       156   1246
2452471 CT     school   930011   New Haven School District 90279001550 939111 Riverside Education Academy Program           2019   pk_12_total 6 72 47   0 0     0   0   77 48     9             69   125 6 72 47   0 0     0   0   77 48     9       69   125
2452374 CT     school 902640 880011   Naugatuck School District 90264000505 886111 Naugatuck High School Public Schools Regular School No High 09 12 2019   pk_12_total 718 117 309   * *     0   65   678 575     37             226   1253 718 117 309           0   65   678 575     37       226   1253
2453029 CT     school 905130 1610011   Wilton School District 90513001076 1616111 Wilton High School Public Schools Regular School No High 09 12 2019   pk_12_total 1004 * 73   * 106     0   58   630 633     *             174   1263 1004   73     106     0   58   630 633             174   1263
2452720 CT     school 904170 1320011   South Windsor School District 90417000826 1326211 South Windsor High School Public Schools Regular School No High 09 12 2019   pk_12_total 826 84 122   * 180     *   46   675 591     14             190   1266 826 84 122     180         46   675 591     14       190   1266
2452908 CT     school   1510011   Waterbury School District   1514211 Hopeville Bilingual Program           2019   pk_12_total 0 0 127   0 0     0   0   67 60     127             17   127 0 0 127   0 0     0   0   67 60     127       17   127
2453086 CT     school 900023 2780013   Trailblazers Academy District 90002300965 2785113 Trailblazers Academy   Regular School Yes Middle 06 08 2019   pk_12_total * 63 58   0 *     0   *   70 57     14             33   127   63 58   0       0       70 57     14       33   127
2452406 CT     school 902700 900011   New Canaan School District 90270000531 906111 New Canaan High School Public Schools Regular School No High 09 12 2019   pk_12_total 1096 23 53   * 77     *   32   647 637     *             167   1284 1096 23 53     77         32   647 637             167   1284
2451822 CT     school   170011   Bristol School District   170811 Chippens Hilll Middle School Extended Resource Program           2019   pk_12_total 6 0 *   0 *     0   0   * *     *             13   13 6 0     0       0   0                   13   13
2452167 CT     school   640011   Hartford School District 90192001764 648511 iGOAL 2 - Moylan School Program           2019   pk_12_total 0 6 7   0 0     0   0   7 6     *             13   13 0 6 7   0 0     0   0   7 6             13   13
2452304 CT     school   800011   Meriden School District   801911 TLC - PHS Program           2019   pk_12_total * * 7   0 *     0   *   7 6     *             13   13     7   0       0       7 6             13   13
2452331 CT     school   830011   Middletown School District 90249001657 831611 Evening Program - MHS Program           2019   pk_12_total 6 * *   0 0     0   *   7 6     0             0   13 6       0 0     0       7 6     0       0   13
2452435 CT     school   930011   New Haven School District   930510 Lincoln Bassett Integrated PK Program           2019   pk_12_total 0 * *   0 0     0   0   * *     0             *   13 0       0 0     0   0           0           13
2452456 CT     school   930011   New Haven School District   938711 Fair Haven Self Contained ID Program           2019   pk_12_total * 7 *   0 0     0   *   * *     0             13   13   7     0 0     0               0       13   13
2452639 CT     school   2150012   Regional School District 15   2150112 MIJ Program Program           2019   pk_12_total * * 0   0 0     0   0   * *     0             6   13     0   0 0     0   0           0       6   13
2452672 CT     school   1180011   Ridgefield School District 90381001607 1189011 Ridgefield 18-21 Transition Program Program           2019   pk_12_total 11 0 *   0 *     0   0   * *     0             13   13 11 0     0       0   0           0       13   13
2452845 CT     school   1440011   Trumbull School District 90462001762 1440511 REACH Program           2019   pk_12_total * 0 *   0 0     0   0   * *     0             13   13   0     0 0     0   0           0       13   13
2452876 CT     school   1480011   Wallingford School District   1481311 Inspire Middle School Program           2019   pk_12_total 9 0 *   0 *     0   0   6 7     *             13   13 9 0     0       0   0   6 7             13   13
2452881 CT     school   1480011   Wallingford School District 90474001594 1489111 Wallingford Transition Academy Program           2019   pk_12_total 7 * *   0 *     0   0   * *     *             13   13 7       0       0   0                   13   13
2452938 CT     school   1510011   Waterbury School District   1514511 Wilby Autism Program           2019   pk_12_total * * 6   0 0     0   0   * *     *             13   13     6   0 0     0   0                   13   13
2452939 CT     school   1510011   Waterbury School District   1511711 Wilby ESC Program           2019   pk_12_total * * *   0 0     0   0   * *     0             13   13         0 0     0   0           0       13   13
2452904 CT     school   1510011   Waterbury School District   1514111 Chase Bilingual Program           2019   pk_12_total 8 0 122   0 0     0   0   78 52     130             22   130 8 0 122   0 0     0   0   78 52     130       22   130
2453109 CT     school   3360015   Unified School District #1 90000300404 3361115 Manson Youth Institution State Agency Facilities           2019   pk_12_total * 61 55   0 0     0   *   130 0     *             111   130   61 55   0 0     0       130 0             111   130
2452365 CT     school   880011   Naugatuck School District 90264001384 888111 Head Start Program           2019   pk_12_total 78 15 21   0 *     0   *   67 64     0             13   131 78 15 21   0       0       67 64     0       13   131
2452497 CT     school 902880 940011   Newington School District 90288000610 946111 Newington High School Public Schools Regular School No High 09 12 2019   pk_12_total 827 76 221   * 114     *   68   693 617     16             147   1310 827 76 221     114         68   693 617     16       147   1310
2452329 CT     school 902490 830011   Middletown School District 90249000465 836211 Middletown High School Public Schools Regular School No High 09 12 2019   pk_12_total 681 283 221   * *     0   64   640 672     27             150   1312 681 283 221           0   64   640 672     27       150   1312
2452609 CT     school 903515 2060012   Regional School District 06 90351500724 2060212 James Morris School Regional Schools Regular School No Elementary PK 06 2019   pk_12_total 116 * 9   * 0     0   *   72 *     *             30   132 116   9     0     0       72               30   132
2452489 CT     school 902850 960011   New Milford School District 90285000602 966111 New Milford High School Public Schools Regular School No High 09 12 2019   pk_12_total 1061 * 155   * 48     0   33   699 *     34             169   1328 1061   155     48     0   33   699       34       169   1328
2452405 CT     school 902700 900011   New Canaan School District 90270000532 905111 Saxe Middle School Public Schools Regular School No Middle 05 08 2019   pk_12_total 1102 8 72   * 105     *   42   686 648     9             162   1334 1102 8 72     105         42   686 648     9       162   1334

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