enrollments

Data source: Big Local News · About: Big Local

4,354 rows where grade = "grade_2" and state = "CT" sorted by total_int descending

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • grade_2 · 4,354 ✖
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 ▲
2437087 2437087 CT     school 905130 1610011   Wilton School District 90513001075 1610511 Miller-Driscoll School Public Schools Regular School No Elementary PK 02 2019   grade_2                                                   257                                             257
2742715 2742715 CT     school 905130 1610011   Wilton School District 90513001075 1610511 Miller-Driscoll School Public Schools Regular School No Elementary PK 02 2021   grade_2                                                   239                                             239
2762981 2762981 CT     school 905130 1610011   Wilton School District 90513001075 1610511 Miller-Driscoll School Public Schools Regular School No Elementary PK 02 2020   grade_2                                                   235                                             235
2437011 2437011 CT     school 904890 1530011   Watertown School District 90489001135 1530211 John Trumbull Primary School Public Schools Regular School No Elementary PK 03 2019   grade_2                                                   197                                             197
2762906 2762906 CT     school 904890 1530011   Watertown School District 90489001135 1530211 John Trumbull Primary School Public Schools Regular School No Elementary PK 02 2020   grade_2                                                   196                                             196
2742642 2742642 CT     school 904890 1530011   Watertown School District 90489001135 1530211 John Trumbull Primary School Public Schools Regular School No Elementary PK 02 2021   grade_2                                                   190                                             190
2762173 2762173 CT     school 902070 690011   Killingly School District 90207000394 690311 Killingly Memorial School Public Schools Regular School No Elementary 02 04 2020   grade_2                                                   183                                             183
2435895 2435895 CT     school 900540 180011   Brookfield School District 90054001186 180411 Huckleberry Hill Elementary School Public Schools Regular School No Elementary 02 04 2019   grade_2                                                   178                                             178
2741916 2741916 CT     school 902070 690011   Killingly School District 90207000394 690311 Killingly Memorial School Public Schools Regular School No Elementary 02 04 2021   grade_2                                                   176                                             176
2762782 2762782 CT     school 904590 1430011   Torrington School District 90459000923 1430911 Torringford School Public Schools Regular School No Elementary PK 03 2020   grade_2                                                   171                                             171
2761847 2761847 CT     school 900840 280011   Colchester School District 90084001444 280411 Colchester Elementary School Public Schools Regular School No Elementary PK 02 2020   grade_2                                                   165                                             165
2741533 2741533 CT     school 900540 180011   Brookfield School District 90054001186 180411 Huckleberry Hill Elementary School Public Schools Regular School No Elementary 02 04 2021   grade_2                                                   163                                             163
2436278 2436278 CT     school 902070 690011   Killingly School District 90207000394 690311 Killingly Memorial School Public Schools Regular School No Elementary 02 04 2019   grade_2                                                   162                                             162
2436890 2436890 CT     school 904590 1430011   Torrington School District 90459000923 1430911 Torringford School Public Schools Regular School No Elementary KG 03 2019   grade_2                                                   159                                             159
2436891 2436891 CT     school 904590 1430011   Torrington School District 90459001211 1431311 Vogel-Wetmore School Public Schools Regular School No Elementary KG 03 2019   grade_2                                                   158                                             158
2761794 2761794 CT     school 900540 180011   Brookfield School District 90054001186 180411 Huckleberry Hill Elementary School Public Schools Regular School No Elementary 02 04 2020   grade_2                                                   158                                             158
2437059 2437059 CT     school 905010 1570011   Weston School District 90501001045 1570111 Hurlbutt Elementary School Public Schools Regular School No Elementary PK 02 2019   grade_2                                                   154                                             154
2762359 2762359 CT     school 902730 910011   New Fairfield School District 90273000535 910111 Consolidated School Public Schools Regular School No Elementary PK 02 2020   grade_2                                                   152                                             152
2762783 2762783 CT     school 904590 1430011   Torrington School District 90459001211 1431311 Vogel-Wetmore School Public Schools Regular School No Elementary KG 03 2020   grade_2                                                   151                                             151
2435949 2435949 CT     school 900840 280011   Colchester School District 90084001444 280411 Colchester Elementary School Public Schools Regular School No Elementary PK 02 2019   grade_2                                                   149                                             149
2742523 2742523 CT     school 904590 1430011   Torrington School District 90459000923 1430911 Torringford School Public Schools Regular School No Elementary PK 03 2021   grade_2                                                   148                                             148
2436013 2436013 CT     school 901230 420011   East Hampton School District 90123000189 420111 Memorial School Public Schools Regular School No Elementary PK 03 2019   grade_2                                                   147                                             147
2436882 2436882 CT     school 904560 1420011   Tolland School District 90456000948 1420111 Birch Grove Primary School Public Schools Regular School No Elementary PK 02 2019   grade_2                                                   147                                             147
2761868 2761868 CT     school 900990 330011   Cromwell School District 90099000146 330211 Edna C. Stevens School Public Schools Regular School No Elementary PK 02 2020   grade_2                                                   146                                             146
2741606 2741606 CT     school 900990 330011   Cromwell School District 90099000146 330211 Edna C. Stevens School Public Schools Regular School No Elementary PK 02 2021   grade_2                                                   143                                             143
2761913 2761913 CT     school 901230 420011   East Hampton School District 90123000189 420111 Memorial School Public Schools Regular School No Elementary PK 03 2020   grade_2                                                   143                                             143
2762774 2762774 CT     school 904560 1420011   Tolland School District 90456000948 1420111 Birch Grove Primary School Public Schools Regular School No Elementary PK 02 2020   grade_2                                                   143                                             143
2742503 2742503 CT     school 904470 1390011   Suffield School District 90447000903 1390411 A. Ward Spaulding School Public Schools Regular School No Elementary PK 02 2021   grade_2                                                   141                                             141
2435969 2435969 CT     school 900990 330011   Cromwell School District 90099000146 330211 Edna C. Stevens School Public Schools Regular School No Elementary PK 02 2019   grade_2                                                   140                                             140
2436547 2436547 CT     school 902850 960011   New Milford School District 90285001168 960811 Northville Elementary School Public Schools Regular School No Elementary PK 02 2019   grade_2                                                   140                                             140
2436469 2436469 CT     school 902730 910011   New Fairfield School District 90273000535 910111 Consolidated School Public Schools Regular School No Elementary PK 02 2019   grade_2                                                   138                                             138
2742524 2742524 CT     school 904590 1430011   Torrington School District 90459001211 1431311 Vogel-Wetmore School Public Schools Regular School No Elementary KG 03 2021   grade_2                                                   138                                             138
2742177 2742177 CT     school 902850 960011   New Milford School District 90285001168 960811 Northville Elementary School Public Schools Regular School No Elementary PK 02 2021   grade_2                                                   137                                             137
2436077 2436077 CT     school 901470 490011   Enfield School District 90147000244 490211 Enfield Street School Public Schools Regular School No Elementary KG 02 2019   grade_2                                                   135                                             135
2762954 2762954 CT     school 905010 1570011   Weston School District 90501001045 1570111 Hurlbutt Elementary School Public Schools Regular School No Elementary PK 02 2020   grade_2                                                   135                                             135
2742514 2742514 CT     school 904560 1420011   Tolland School District 90456000948 1420111 Birch Grove Primary School Public Schools Regular School No Elementary PK 02 2021   grade_2                                                   134                                             134
2761977 2761977 CT     school 901470 490011   Enfield School District 90147000248 491811 Henry Barnard School Public Schools Regular School No Elementary KG 02 2020   grade_2                                                   134                                             134
2436871 2436871 CT     school 904470 1390011   Suffield School District 90447000903 1390411 A. Ward Spaulding School Public Schools Regular School No Elementary PK 02 2019   grade_2                                                   133                                             133
2741800 2741800 CT     school 901740 580011   Griswold School District 90174000310 580311 Griswold Elementary School Public Schools Regular School No Elementary PK 04 2021   grade_2                                                   132                                             132
2741584 2741584 CT     school 900840 280011   Colchester School District 90084001444 280411 Colchester Elementary School Public Schools Regular School No Elementary PK 02 2021   grade_2                                                   131                                             131
2742688 2742688 CT     school 905010 1570011   Weston School District 90501001045 1570111 Hurlbutt Elementary School Public Schools Regular School No Elementary PK 02 2021   grade_2                                                   131                                             131
2436546 2436546 CT     school 902850 960011   New Milford School District 90285000599 960511 Hill And Plain School Public Schools Regular School No Elementary PK 02 2019   grade_2                                                   130                                             130
2761863 2761863 CT     school 900960 320011   Coventry School District 90096000142 320211 Coventry Grammar School Public Schools Regular School No Elementary KG 02 2020   grade_2                                                   130                                             130
2762436 2762436 CT     school 902850 960011   New Milford School District 90285001168 960811 Northville Elementary School Public Schools Regular School No Elementary PK 02 2020   grade_2                                                   130                                             130
2762763 2762763 CT     school 904470 1390011   Suffield School District 90447000903 1390411 A. Ward Spaulding School Public Schools Regular School No Elementary PK 02 2020   grade_2                                                   130                                             130
2435802 2435802 CT     school 900330 110011   Bloomfield School District 90033000032 110611 Laurel School Public Schools Regular School No Elementary KG 02 2019   grade_2                                                   128                                             128
2436630 2436630 CT     school 903240 1080011   Oxford School District 90324000002 1080311 Quaker Farms School Public Schools Regular School No Elementary PK 02 2019   grade_2                                                   127                                             127
2762034 2762034 CT     school 901680 560011   Granby School District 90168000290 560411 Kelly Lane Primary School Public Schools Regular School No Elementary PK 02 2020   grade_2                                                   127                                             127
2741617 2741617 CT     school 901020 340011   Danbury School District 90102000157 340811 Park Avenue School Public Schools Regular School No Elementary KG 05 2021   grade_2                                                   126                                             126
2435964 2435964 CT     school 900960 320011   Coventry School District 90096000142 320211 Coventry Grammar School Public Schools Regular School No Elementary KG 02 2019   grade_2                                                   125                                             125
2742737 2742737 CT     school 905250 1650011   Windsor Locks School District 90525001097 1650111 North Street School Public Schools Regular School No Elementary PK 02 2021   grade_2                                                   125                                             125
2436569 2436569 CT     school 902970 990011   North Branford School District 90297000620 990411 Jerome Harrison School Public Schools Regular School No Elementary PK 02 2019   grade_2                                                   123                                             123
2761876 2761876 CT     school 901020 340011   Danbury School District 90102000153 341311 King Street Primary School Public Schools Regular School No Elementary KG 03 2020   grade_2                                                   123                                             123
2763025 2763025 CT     school 905310 1670011   Woodbridge School District 90531001611 1670311 Beecher Road School Public Schools Regular School No Elementary PK 06 2020   grade_2                                                   123                                             123
2435779 2435779 CT     school 900120 40011   Avon School District 90012010010 40411 Pine Grove School Public Schools Regular School No Elementary KG 04 2019   grade_2                                                   122                                             122
2436078 2436078 CT     school 901470 490011   Enfield School District 90147000247 490411 Hazardville Memorial School Public Schools Regular School No Elementary KG 02 2019   grade_2                                                   122                                             122
2742367 2742367 CT     school 903840 1190011   Rocky Hill School District 90384000786 1190511 West Hill School Public Schools Regular School No Elementary PK 03 2021   grade_2                                                   122                                             122
2436464 2436464 CT     school 902700 900011   New Canaan School District 90270000530 900411 East School Public Schools Regular School No Elementary KG 04 2019   grade_2                                                   121                                             121
2742581 2742581 CT     school 904830 1510011   Waterbury School District 90483000977 1510711 H. S. Chase School Public Schools Regular School No Elementary PK 05 2021   grade_2                                                   121                                             121
2436925 2436925 CT     school 904740 1480011   Wallingford School District 90474000953 1480211 Highland School Public Schools Regular School No Elementary PK 02 2019   grade_2                                                   120                                             120
2761725 2761725 CT     school 900450 150011   Bridgeport School District 90045000070 151411 Cesar Batalla School Public Schools Regular School No Elementary PK 08 2020   grade_2                                                   120                                             120
2742743 2742743 CT     school 905220 1640011   Windsor School District 90522001092 1640911 Oliver Ellsworth School Public Schools Regular School No Elementary PK 02 2021   grade_2                                                   119                                             119
2761698 2761698 CT     school 900330 110011   Bloomfield School District 90033000032 110611 Laurel School Public Schools Regular School No Elementary KG 02 2020   grade_2                                                   119                                             119
2741651 2741651 CT     school 901230 420011   East Hampton School District 90123000189 420111 Memorial School Public Schools Regular School No Elementary PK 03 2021   grade_2                                                   118                                             118
2742411 2742411 CT     school 904170 1320011   South Windsor School District 90417000824 1320611 Orchard Hill School Public Schools Regular School No Elementary KG 05 2021   grade_2                                                   118                                             118
2742459 2742459 CT     school 904320 1350011   Stamford School District 90432000008 1351911 Toquam Magnet School Public Schools Regular School No Elementary KG 05 2021   grade_2                                                   118                                             118
2436450 2436450 CT     school 902670 890011   New Britain School District 90267000523 891211 Smalley Elementary School Public Schools Regular School No Elementary KG 05 2019   grade_2                                                   117                                             117
2742744 2742744 CT     school 905220 1640011   Windsor School District 90522001093 1640511 Poquonock Elementary School Public Schools Regular School No Elementary PK 02 2021   grade_2                                                   117                                             117
2761675 2761675 CT     school 900120 40011   Avon School District 90012010010 40411 Pine Grove School Public Schools Regular School No Elementary KG 04 2020   grade_2                                                   117                                             117
2436735 2436735 CT     school 903840 1190011   Rocky Hill School District 90384000786 1190511 West Hill School Public Schools Regular School No Elementary PK 05 2019   grade_2                                                   116                                             116
2436827 2436827 CT     school 904320 1350011   Stamford School District 90432000872 1351411 Westover School Public Schools Regular School No Elementary KG 05 2019   grade_2                                                   116                                             116
2742100 2742100 CT     school 902730 910011   New Fairfield School District 90273000535 910111 Consolidated School Public Schools Regular School No Elementary PK 02 2021   grade_2                                                   116                                             116
2763009 2763009 CT     school 905220 1640011   Windsor School District 90522001092 1640911 Oliver Ellsworth School Public Schools Regular School No Elementary PK 02 2020   grade_2                                                   116                                             116
2436080 2436080 CT     school 901470 490011   Enfield School District 90147000248 491811 Henry Barnard School Public Schools Regular School No Elementary KG 02 2019   grade_2                                                   115                                             115
2742490 2742490 CT     school 904440 1380011   Stratford School District 90444000892 1381511 Stratford Academy - Johnson House Public Schools Regular School No Elementary 02 06 2021   grade_2                                                   115                                             115
2762355 2762355 CT     school 902700 900011   New Canaan School District 90270000533 900211 South School Public Schools Regular School No Elementary KG 04 2020   grade_2                                                   115                                             115
2762522 2762522 CT     school 903240 1080011   Oxford School District 90324000002 1080311 Quaker Farms School Public Schools Regular School No Elementary PK 02 2020   grade_2                                                   115                                             115
2435780 2435780 CT     school 900120 40011   Avon School District 90012000013 40311 Roaring Brook School Public Schools Regular School No Elementary KG 04 2019   grade_2                                                   114                                             114
2435795 2435795 CT     school 900270 90011   Bethel School District 90027000023 90411 Anna H. Rockwell School Public Schools Regular School No Elementary KG 03 2019   grade_2                                                   114                                             114
2437113 2437113 CT     school 905220 1640011   Windsor School District 90522001092 1640911 Oliver Ellsworth School Public Schools Regular School No Elementary PK 02 2019   grade_2                                                   114                                             114
2437128 2437128 CT     school 905310 1670011   Woodbridge School District 90531001611 1670311 Beecher Road School Public Schools Regular School No Elementary PK 06 2019   grade_2                                                   114                                             114
2762055 2762055 CT     school 901740 580011   Griswold School District 90174000310 580311 Griswold Elementary School Public Schools Regular School No Elementary PK 04 2020   grade_2                                                   114                                             114
2762458 2762458 CT     school 902970 990011   North Branford School District 90297000620 990411 Jerome Harrison School Public Schools Regular School No Elementary PK 02 2020   grade_2                                                   114                                             114
2435794 2435794 CT     school 900270 90011   Bethel School District 90027000027 90111 Frank A. Berry School Public Schools Regular School No Elementary PK 03 2019   grade_2                                                   113                                             113
2435826 2435826 CT     school 900450 150011   Bridgeport School District 90045000053 154011 Blackham School Public Schools Regular School No Elementary PK 08 2019   grade_2                                                   113                                             113
2435863 2435863 CT     school 900510 170011   Bristol School District 90051000098 170511 Greene-Hills School Public Schools Regular School No Elementary PK 08 2019   grade_2                                                   113                                             113
2761974 2761974 CT     school 901470 490011   Enfield School District 90147000247 490411 Hazardville Memorial School Public Schools Regular School No Elementary KG 02 2020   grade_2                                                   113                                             113
2762719 2762719 CT     school 904320 1350011   Stamford School District 90432000008 1351911 Toquam Magnet School Public Schools Regular School No Elementary KG 05 2020   grade_2                                                   113                                             113
2742176 2742176 CT     school 902850 960011   New Milford School District 90285000599 960511 Hill And Plain School Public Schools Regular School No Elementary PK 02 2021   grade_2                                                   112                                             112
2761963 2761963 CT     school 901440 480011   Ellington School District 90144000239 480611 Windermere School Public Schools Regular School No Elementary PK 06 2020   grade_2                                                   112                                             112
2762845 2762845 CT     school 904830 1510011   Waterbury School District 90483000977 1510711 H. S. Chase School Public Schools Regular School No Elementary PK 05 2020   grade_2                                                   111                                             111
2763003 2763003 CT     school 905250 1650011   Windsor Locks School District 90525001097 1650111 North Street School Public Schools Regular School No Elementary PK 02 2020   grade_2                                                   111                                             111
2436465 2436465 CT     school 902700 900011   New Canaan School District 90270000533 900211 South School Public Schools Regular School No Elementary KG 04 2019   grade_2                                                   110                                             110
2436808 2436808 CT     school 904290 1340011   Stafford School District 90429001503 1340611 Stafford Elementary School Public Schools Regular School No Elementary 02 05 2019   grade_2                                                   110                                             110
2741722 2741722 CT     school 901470 490011   Enfield School District 90147000248 491811 Henry Barnard School Public Schools Regular School No Elementary KG 02 2021   grade_2                                                   110                                             110
2741779 2741779 CT     school 901680 560011   Granby School District 90168000290 560411 Kelly Lane Primary School Public Schools Regular School No Elementary PK 02 2021   grade_2                                                   110                                             110
2762670 2762670 CT     school 904170 1320011   South Windsor School District 90417000824 1320611 Orchard Hill School Public Schools Regular School No Elementary KG 05 2020   grade_2                                                   110                                             110
2435977 2435977 CT     school 901020 340011   Danbury School District 90102000157 340811 Park Avenue School Public Schools Regular School No Elementary PK 05 2019   grade_2                                                   109                                             109
2436157 2436157 CT     school 901740 580011   Griswold School District 90174000310 580311 Griswold Elementary School Public Schools Regular School No Elementary PK 04 2019   grade_2                                                   109                                             109
2741415 2741415 CT     school 900120 40011   Avon School District 90012010010 40411 Pine Grove School Public Schools Regular School No Elementary KG 04 2021   grade_2                                                   109                                             109

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