Data source: Big Local News · About: Big Local

20,216 rows where state = "CT" and year = 2021 sorted by total descending

View and edit SQL

grade

year

  • 2021 · 20,216
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
2739871 CT     school 905310 1670011   Woodbridge School District 90531001611 1670311 Beecher Road School Public Schools Regular School No Elementary PK 06 2021   kindergarten                                                   99                                             99
2741088 CT     school 904620 1440011   Trumbull School District 90462001469 1441011 Frenchtown Elementary School Public Schools Regular School No Elementary KG 05 2021   grade_1                                                   99                                             99
2741787 CT     school 901710 570011   Greenwich School District 90171000304 570711 North Mianus School Public Schools Regular School No Elementary PK 05 2021   grade_2                                                   99                                             99
2741973 CT     school 902400 800011   Meriden School District 90240000442 800311 Hanover School Public Schools Regular School No Elementary PK 05 2021   grade_2                                                   99                                             99
2742332 CT     school 903538 2160012   Regional School District 16 90353801811 2160512 Prospect Elementary School Regional Schools Regular School No Elementary PK 05 2021   grade_2                                                   99                                             99
2742557 CT     school 904740 1480011   Wallingford School District 90474000957 1480111 Moses Y. Beach School Public Schools Regular School No Elementary PK 02 2021   grade_2                                                   99                                             99
2743422 CT     school 902400 800011   Meriden School District 90240000440 801111 Casimir Pulaski School Public Schools Regular School No Elementary KG 05 2021   grade_3                                                   99                                             99
2743539 CT     school 902700 900011   New Canaan School District 90270000530 900411 East School Public Schools Regular School No Elementary KG 04 2021   grade_3                                                   99                                             99
2743904 CT     school 904320 1350011   Stamford School District 90432000872 1351411 Westover School Public Schools Regular School No Elementary KG 05 2021   grade_3                                                   99                                             99
2743978 CT     school 904620 1440011   Trumbull School District 90462000934 1440311 Middlebrook School Public Schools Regular School No Elementary KG 05 2021   grade_3                                                   99                                             99
2746105 CT     school 901620 540011   Glastonbury School District 90162001447 540911 Nayaug Elementary School Public Schools Regular School No Elementary KG 05 2021   grade_5                                                   99                                             99
2747250 CT     school 900450 150011   Bridgeport School District 90045000001 151011 Luis Munoz Marin School Public Schools Regular School No Elementary PK 08 2021   grade_6                                                   99                                             99
2747275 CT     school 900510 170011   Bristol School District 90051000098 170511 Greene-Hills School Public Schools Regular School No Elementary PK 08 2021   grade_6                                                   99                                             99
2749111 CT     school 901920 640011   Hartford School District 90192000381 641911 Milner Middle School Public Schools Regular School No Middle 06 08 2021   grade_7                                                   99                                             99
2749984 CT     school 900024 2790013   Amistad Academy District 90002400981 2795113 Amistad Academy Public Charter Schools Regular School Yes Other KG 12 2021   grade_7                                                   99                                             99
2758410 CT     school 904590 1430011   Torrington School District 90459000925 1435111 Torrington Middle School Public Schools Regular School No Middle 06 08 2021   pk_12_total 550 40 318   * 44     *   34   516 *     77             170   988 550 40 318     44         34   516       77       170   988
2757697 CT     school 901770 590011   Groton School District 90177000318 596111 Robert E. Fitch High School Public Schools Regular School No High 09 12 2021   pk_12_total 515 92 205   * 62     *   94   509 473     29             149   982 515 92 205     62         94   509 473     29       149   982
2738693 CT     school 900810 270011   Clinton School District 90081000132 270311 Lewin G. Joel Jr. School Public Schools Regular School No Elementary PK 04 2021   kindergarten                                                   98                                             98
2739687 CT     school 904830 1510011   Waterbury School District 90483000966 1512111 B. W. Tinker School Public Schools Regular School No Elementary PK 05 2021   kindergarten                                                   98                                             98
2740018 CT     school 900450 150011   Bridgeport School District 90045000053 154011 Blackham School Public Schools Regular School No Elementary PK 08 2021   grade_1                                                   98                                             98
2740020 CT     school 900450 150011   Bridgeport School District 90045000070 151411 Cesar Batalla School Public Schools Regular School No Elementary PK 08 2021   grade_1                                                   98                                             98
2740065 CT     school 900510 170011   Bristol School District 90051001624 172011 West Bristol School Public Schools Regular School No Elementary KG 08 2021   grade_1                                                   98                                             98
2740173 CT     school 901020 340011   Danbury School District 90102000157 340811 Park Avenue School Public Schools Regular School No Elementary KG 05 2021   grade_1                                                   98                                             98
2741004 CT     school 904320 1350011   Stamford School District 90432000167 1352211 Hart School Public Schools Regular School No Elementary KG 05 2021   grade_1                                                   98                                             98
2741581 CT     school 900810 270011   Clinton School District 90081000132 270311 Lewin G. Joel Jr. School Public Schools Regular School No Elementary PK 04 2021   grade_2                                                   98                                             98
2741660 CT     school 901260 430011   East Hartford School District 90126000196 431011 Dr. Thomas S. O'Connell School Public Schools Regular School No Elementary KG 05 2021   grade_2                                                   98                                             98
2742456 CT     school 904320 1350011   Stamford School District 90432000868 1352111 Stillmeadow School Public Schools Regular School No Elementary KG 05 2021   grade_2                                                   98                                             98
2742605 CT     school 904830 1510011   Waterbury School District 90483000974 1511111 Margaret M. Generali Elementary School Public Schools Regular School No Elementary KG 05 2021   grade_2                                                   98                                             98
2742984 CT     school 900690 230011   Canton School District 90069000120 230211 Cherry Brook Primary School Public Schools Regular School No Elementary PK 03 2021   grade_3                                                   98                                             98
2743061 CT     school 901020 340011   Danbury School District 90102000157 340811 Park Avenue School Public Schools Regular School No Elementary KG 05 2021   grade_3                                                   98                                             98
2743204 CT     school 901560 520011   Farmington School District 90156001206 520411 East Farms School Public Schools Regular School No Elementary KG 04 2021   grade_3                                                   98                                             98
2743419 CT     school 902400 800011   Meriden School District 90240000448 800711 Nathan Hale School Public Schools Regular School No Elementary PK 05 2021   grade_3                                                   98                                             98
2743732 CT     school 903390 1130011   Portland School District 90339000711 1130411 Gildersleeve School Public Schools Regular School No Elementary 02 04 2021   grade_3                                                   98                                             98
2744648 CT     school 901560 520011   Farmington School District 90156001206 520411 East Farms School Public Schools Regular School No Elementary KG 04 2021   grade_4                                                   98                                             98
2745176 CT     school 903390 1130011   Portland School District 90339000711 1130411 Gildersleeve School Public Schools Regular School No Elementary 02 04 2021   grade_4                                                   98                                             98
2746791 CT     school 904320 1350011   Stamford School District 90432000008 1351911 Toquam Magnet School Public Schools Regular School No Elementary KG 05 2021   grade_5                                                   98                                             98
2746976 CT     school 904890 1530011   Watertown School District 90489001005 1530411 Polk School Public Schools Regular School No Elementary 03 05 2021   grade_5                                                   98                                             98
2747094 CT     school 900208 2850013   Achievement First Bridgeport Academy District 90020801493 2850113 Achievement First Bridgeport Academy Public Charter Schools Regular School Yes Other KG 12 2021   grade_5                                                   98                                             98
2750163 CT     school 900510 170011   Bristol School District 90051000098 170511 Greene-Hills School Public Schools Regular School No Elementary PK 08 2021   grade_8                                                   98                                             98
2750738 CT     school 902670 890011   New Britain School District 90267000510 891111 DiLoreto Elementary & Middle School Public Schools Regular School No Elementary KG 08 2021   grade_8                                                   98                                             98
2751599 CT     school 900450 150011   Bridgeport School District 90045001631 151611 Bridgeport Military Academy Public Schools Regular School No High 09 12 2021   grade_9                                                   98                                             98
2753113 CT     school 900700 2410014   Capitol Region Education Council 90070000880 2416114 Metropolitan Learning Center for Global and International Studies Regional Education Service Center Schools Regular School No High 06 12 2021   grade_10                                                   98                                             98
2753712 CT     school 902790 930011   New Haven School District 90279001485 936011 Metropolitan Business Academy Public Schools Regular School No High 09 12 2021   grade_10                                                   98                                             98
2753996 CT     school 904290 1340011   Stafford School District 90429000845 1346111 Stafford High School Public Schools Regular School No High 09 12 2021   grade_10                                                   98                                             98
2755255 CT     school 903180 1060011   Old Saybrook School District 90318000684 1066111 Old Saybrook Senior High School Public Schools Regular School No High 09 12 2021   grade_11                                                   98                                             98
2756600 CT     school 902790 930011   New Haven School District 90279001485 936011 Metropolitan Business Academy Public Schools Regular School No High 09 12 2021   grade_12                                                   98                                             98
2757694 CT     school 901770 590011   Groton School District 90177001938 591111 Groton Middle School Public Schools Regular School No Middle 06 08 2021   pk_12_total 492 72 222   * 62     *   108   491 479     29             163   970 492 72 222     62         108   491 479     29       163   970
2738682 CT     school 900750 250011   Cheshire School District 90075000127 250411 Highland School Public Schools Regular School No Elementary KG 06 2021   kindergarten                                                   97                                             97
2739570 CT     school 904320 1350011   Stamford School District 90432001916 1350711 Strawberry Hill an ext. of Rogers International Public Schools Regular School No Elementary KG 05 2021   kindergarten                                                   97                                             97
2741462 CT     school 900450 150011   Bridgeport School District 90045000053 154011 Blackham School Public Schools Regular School No Elementary PK 08 2021   grade_2                                                   97                                             97
2741601 CT     school 900960 320011   Coventry School District 90096000142 320211 Coventry Grammar School Public Schools Regular School No Elementary KG 02 2021   grade_2                                                   97                                             97
2742225 CT     school 903090 1030011   Norwalk School District 90309000658 1031311 Rowayton School Public Schools Regular School No Elementary KG 05 2021   grade_2                                                   97                                             97
2743171 CT     school 901470 490011   Enfield School District 90147000241 491311 Edgar H. Parkman School Public Schools Regular School No Elementary 03 05 2021   grade_3                                                   97                                             97
2744008 CT     school 904740 1480011   Wallingford School District 90474000961 1480411 Rock Hill School Public Schools Regular School No Elementary 03 05 2021   grade_3                                                   97                                             97
2744208 CT     school 900024 2790013   Amistad Academy District 90002400981 2795113 Amistad Academy Public Charter Schools Regular School Yes Other KG 12 2021   grade_3                                                   97                                             97
2745220 CT     school 903538 2160012   Regional School District 16 90353801811 2160512 Prospect Elementary School Regional Schools Regular School No Elementary PK 05 2021   grade_4                                                   97                                             97
2745626 CT     school 905250 1650011   Windsor Locks School District 90525001098 1650411 South Elementary School Public Schools Regular School No Elementary 03 05 2021   grade_4                                                   97                                             97
2746307 CT     school 902400 800011   Meriden School District 90240000448 800711 Nathan Hale School Public Schools Regular School No Elementary PK 05 2021   grade_5                                                   97                                             97
2746664 CT     school 903538 2160012   Regional School District 16 90353801811 2160512 Prospect Elementary School Regional Schools Regular School No Elementary PK 05 2021   grade_5                                                   97                                             97
2746741 CT     school 904170 1320011   South Windsor School District 90417000825 1320211 Pleasant Valley School Public Schools Regular School No Elementary PK 05 2021   grade_5                                                   97                                             97
2746784 CT     school 904320 1350011   Stamford School District 90432000861 1351811 Northeast School Public Schools Regular School No Elementary KG 05 2021   grade_5                                                   97                                             97
2747095 CT     school 900212 2880013   Achievement First Hartford Academy District 90021201528 2880113 Achievement First Hartford Academy Public Charter Schools Regular School Yes Other KG 12 2021   grade_5                                                   97                                             97
2752001 CT     school 901920 640011   Hartford School District 90192001370 646511 Sport and Medical Sciences Academy Public Schools Regular School No High 06 12 2021   grade_9                                                   97                                             97
2757623 CT     school   510011   Fairfield School District 90153000989 518011 Early Childhood Center(0518011) Program           2021   pk_12_total 68 0 11   0 11     0   7   62 35     0             66   97 68 0 11   0 11     0   7   62 35     0       66   97
2757642 CT     school   520011   Farmington School District 90156001441 528011 Farmington Collaborative PK Program           2021   pk_12_total 63 7 9   0 12     0   6   57 40     0             40   97 63 7 9   0 12     0   6   57 40     0       40   97
2757990 CT     school 902760 920011   New Hartford School District 90276000539 920111 Bakerville Consolidated School Public Schools Regular School No Elementary KG 02 2021   pk_12_total 93 0 *   0 0     0   *   50 47     *             9   97 93 0     0 0     0       50 47             9   97
2751736 CT     school 901020 340011   Danbury School District 90102000150 346111 Danbury High School Public Schools Regular School No High 09 12 2021   grade_9                                                   965                                             965
2739478 CT     school 903840 1190011   Rocky Hill School District 90384000784 1190411 Myrtle H. Stevens School Public Schools Regular School No Elementary PK 03 2021   kindergarten                                                   96                                             96
2739636 CT     school 904590 1430011   Torrington School District 90459001211 1431311 Vogel-Wetmore School Public Schools Regular School No Elementary KG 03 2021   kindergarten                                                   96                                             96
2739874 CT     school 900208 2850013   Achievement First Bridgeport Academy District 90020801493 2850113 Achievement First Bridgeport Academy Public Charter Schools Regular School Yes Other KG 12 2021   kindergarten                                                   96                                             96
2740952 CT     school 904110 1280011   Simsbury School District 90411000814 1280711 Squadron Line School Public Schools Regular School No Elementary PK 06 2021   grade_1                                                   96                                             96
2740965 CT     school 904170 1320011   South Windsor School District 90417000825 1320211 Pleasant Valley School Public Schools Regular School No Elementary PK 05 2021   grade_1                                                   96                                             96
2742075 CT     school 902670 890011   New Britain School District 90267000515 890811 Lincoln Elementary School Public Schools Regular School No Elementary KG 05 2021   grade_2                                                   96                                             96
2742288 CT     school 903390 1130011   Portland School District 90339000711 1130411 Gildersleeve School Public Schools Regular School No Elementary 02 04 2021   grade_2                                                   96                                             96
2742460 CT     school 904320 1350011   Stamford School District 90432000872 1351411 Westover School Public Schools Regular School No Elementary KG 05 2021   grade_2                                                   96                                             96
2742850 CT     school 900060 20011   Ansonia School District 90006000005 20311 Mead School Public Schools Regular School No Elementary PK 06 2021   grade_3                                                   96                                             96
2743025 CT     school 900810 270011   Clinton School District 90081000132 270311 Lewin G. Joel Jr. School Public Schools Regular School No Elementary PK 04 2021   grade_3                                                   96                                             96
2743900 CT     school 904320 1350011   Stamford School District 90432000868 1352111 Stillmeadow School Public Schools Regular School No Elementary KG 05 2021   grade_3                                                   96                                             96
2744005 CT     school 904740 1480011   Wallingford School District 90474000536 1480811 Mary G. Fritz Elementary School of Yalesville Public Schools Regular School No Elementary 03 05 2021   grade_3                                                   96                                             96
2744207 CT     school 900212 2880013   Achievement First Hartford Academy District 90021201528 2880113 Achievement First Hartford Academy Public Charter Schools Regular School Yes Other KG 12 2021   grade_3                                                   96                                             96
2744928 CT     school 902550 850011   Monroe School District 90255000488 850511 Fawn Hollow Elementary School Public Schools Regular School No Elementary KG 05 2021   grade_4                                                   96                                             96
2745335 CT     school 904320 1350011   Stamford School District 90432000852 1352011 Davenport Ridge School Public Schools Regular School No Elementary KG 05 2021   grade_4                                                   96                                             96
2745342 CT     school 904320 1350011   Stamford School District 90432000865 1350911 Roxbury School Public Schools Regular School No Elementary KG 05 2021   grade_4                                                   96                                             96
2745473 CT     school 904830 1510011   Waterbury School District 90483001131 1513311 Rotella Interdistrict Magnet School Public Schools Regular School No Elementary PK 05 2021   grade_4                                                   96                                             96
2745841 CT     school 900510 170011   Bristol School District 90051001624 172011 West Bristol School Public Schools Regular School No Elementary KG 08 2021   grade_5                                                   96                                             96
2746410 CT     school 902670 890011   New Britain School District 90267000523 891211 Smalley Elementary School Public Schools Regular School No Elementary KG 05 2021   grade_5                                                   96                                             96
2746502 CT     school 902820 950011   New London School District 90282000594 950911 Nathan Hale Arts Magnet School Public Schools Regular School No Elementary KG 05 2021   grade_5                                                   96                                             96
2746551 CT     school 903090 1030011   Norwalk School District 90309000649 1030811 Kendall Elementary School Public Schools Regular School No Elementary PK 05 2021   grade_5                                                   96                                             96
2746917 CT     school 904830 1510011   Waterbury School District 90483001131 1513311 Rotella Interdistrict Magnet School Public Schools Regular School No Elementary PK 05 2021   grade_5                                                   96                                             96
2747118 CT     school 900033 2830013   Park City Prep Charter School District 90003301449 2835113 Park City Prep Charter School Public Charter Schools Regular School Yes Middle 05 08 2021   grade_5                                                   96                                             96
2748540 CT     school 900024 2790013   Amistad Academy District 90002400981 2795113 Amistad Academy Public Charter Schools Regular School Yes Other KG 12 2021   grade_6                                                   96                                             96
2749537 CT     school 903535 2130012   Regional School District 13 90353500739 2135112 Frank Ward Strong School Regional Schools Regular School No Middle 06 08 2021   grade_7                                                   96                                             96
2749982 CT     school 900208 2850013   Achievement First Bridgeport Academy District 90020801493 2850113 Achievement First Bridgeport Academy Public Charter Schools Regular School Yes Other KG 12 2021   grade_7                                                   96                                             96
2751009 CT     school 903540 2180012   Regional School District 18 90354001123 2185112 Lyme-Old Lyme Middle School Regional Schools Regular School No Middle 06 08 2021   grade_8                                                   96                                             96
2752261 CT     school 902790 930011   New Haven School District 90279001519 931711 Engineering - Science University Magnet School Public Schools Regular School No High 06 12 2021   grade_9                                                   96                                             96
2752871 CT     school 900212 2880013   Achievement First Hartford Academy District 90021201528 2880113 Achievement First Hartford Academy Public Charter Schools Regular School Yes Other KG 12 2021   grade_9                                                   96                                             96
2754557 CT     school 900700 2410014   Capitol Region Education Council 90070000880 2416114 Metropolitan Learning Center for Global and International Studies Regional Education Service Center Schools Regular School No High 06 12 2021   grade_11                                                   96                                             96
2754898 CT     school 901920 640011   Hartford School District 90192001381 646711 University High School of Science and Engineering Public Schools Regular School No High 09 12 2021   grade_11                                                   96                                             96
2755299 CT     school 903515 2060012   Regional School District 06 90351500725 2066112 Wamogo Regional High School Regional Schools Regular School No High 07 12 2021   grade_11                                                   96                                             96
2755831 CT     school 900002 9000016   Connecticut Technical Education and Career System 90000201150 9001816 Vinal Technical High School CT Technical Education and Career Schools Career and Technical School No High 09 12 2021   grade_11                                                   96                                             96

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