enrollments

Data source: Big Local News · About: Big Local

1,444 rows where grade = "grade_2", state = "CT" and year = 2021 sorted by total_int descending

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2021 · 1,444 ✖

grade ✖

  • grade_2 · 1,444 ✖
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 ▲
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
2741416 2741416 CT     school 900120 40011   Avon School District 90012000013 40311 Roaring Brook School Public Schools Regular School No Elementary KG 04 2021   grade_2                                                   109                                             109
2741464 2741464 CT     school 900450 150011   Bridgeport School District 90045000070 151411 Cesar Batalla School Public Schools Regular School No Elementary PK 08 2021   grade_2                                                   109                                             109
2741856 2741856 CT     school 901920 640011   Hartford School District 90192000364 640811 M. D. Fox School Public Schools Regular School No Elementary PK 05 2021   grade_2                                                   108                                             108
2742409 2742409 CT     school 904170 1320011   South Windsor School District 90417000825 1320211 Pleasant Valley School Public Schools Regular School No Elementary PK 05 2021   grade_2                                                   108                                             108
2742763 2742763 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_2                                                   107                                             107
2741438 2741438 CT     school 900330 110011   Bloomfield School District 90033000032 110611 Laurel School Public Schools Regular School No Elementary KG 02 2021   grade_2                                                   106                                             106
2741615 2741615 CT     school 901020 340011   Danbury School District 90102000154 340511 Mill Ridge Primary School Public Schools Regular School No Elementary KG 03 2021   grade_2                                                   106                                             106
2742095 2742095 CT     school 902700 900011   New Canaan School District 90270000530 900411 East School Public Schools Regular School No Elementary KG 04 2021   grade_2                                                   106                                             106
2741540 2741540 CT     school 900690 230011   Canton School District 90069000120 230211 Cherry Brook Primary School Public Schools Regular School No Elementary PK 03 2021   grade_2                                                   105                                             105
2742040 2742040 CT     school 902550 850011   Monroe School District 90255000488 850511 Fawn Hollow Elementary School Public Schools Regular School No Elementary KG 05 2021   grade_2                                                   105                                             105
2742201 2742201 CT     school 902970 990011   North Branford School District 90297000620 990411 Jerome Harrison School Public Schools Regular School No Elementary PK 02 2021   grade_2                                                   105                                             105
2742447 2742447 CT     school 904320 1350011   Stamford School District 90432000852 1352011 Davenport Ridge School Public Schools Regular School No Elementary KG 05 2021   grade_2                                                   105                                             105
2742458 2742458 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   grade_2                                                   105                                             105
2741719 2741719 CT     school 901470 490011   Enfield School District 90147000247 490411 Hazardville Memorial School Public Schools Regular School No Elementary KG 02 2021   grade_2                                                   104                                             104
2742078 2742078 CT     school 902670 890011   New Britain School District 90267000523 891211 Smalley Elementary School Public Schools Regular School No Elementary KG 05 2021   grade_2                                                   104                                             104
2742264 2742264 CT     school 903240 1080011   Oxford School District 90324000002 1080311 Quaker Farms School Public Schools Regular School No Elementary PK 02 2021   grade_2                                                   104                                             104
2742759 2742759 CT     school 905310 1670011   Woodbridge School District 90531001611 1670311 Beecher Road School Public Schools Regular School No Elementary PK 06 2021   grade_2                                                   104                                             104
2742294 2742294 CT     school 903480 1160011   Putnam School District 90348000718 1160311 Putnam Elementary School Public Schools Regular School No Elementary PK 05 2021   grade_2                                                   103                                             103
2742419 2742419 CT     school 904230 1310011   Southington School District 90423000829 1311511 Derynoski Elementary School Public Schools Regular School No Elementary KG 05 2021   grade_2                                                   103                                             103
2742449 2742449 CT     school 904320 1350011   Stamford School District 90432000858 1351211 Julia A. Stark School Public Schools Regular School No Elementary KG 05 2021   grade_2                                                   102                                             102
2741570 2741570 CT     school 900750 250011   Cheshire School District 90075000127 250411 Highland School Public Schools Regular School No Elementary KG 06 2021   grade_2                                                   100                                             100
2741787 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 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 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 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
2741581 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 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 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 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
2741462 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 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 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
2742075 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 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 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
2742448 2742448 CT     school 904320 1350011   Stamford School District 90432000167 1352211 Hart School Public Schools Regular School No Elementary KG 05 2021   grade_2                                                   95                                             95
2742764 2742764 CT     school 900024 2790013   Amistad Academy District 90002400981 2795113 Amistad Academy Public Charter Schools Regular School Yes Other KG 12 2021   grade_2                                                   95                                             95
2741957 2741957 CT     school 902310 770011   Manchester School District 90231000429 771211 Verplanck School Public Schools Regular School No Elementary KG 04 2021   grade_2                                                   94                                             94
2742057 2742057 CT     school 902640 880011   Naugatuck School District 90264001223 880311 Maple Hill School Public Schools Regular School No Elementary KG 04 2021   grade_2                                                   94                                             94
2742442 2742442 CT     school 904290 1340011   Stafford School District 90429001503 1340611 Stafford Elementary School Public Schools Regular School No Elementary 02 05 2021   grade_2                                                   94                                             94
2742452 2742452 CT     school 904320 1350011   Stamford School District 90432000861 1351811 Northeast School Public Schools Regular School No Elementary KG 05 2021   grade_2                                                   94                                             94
2742762 2742762 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_2                                                   94                                             94
2741499 2741499 CT     school 900510 170011   Bristol School District 90051000098 170511 Greene-Hills School Public Schools Regular School No Elementary PK 08 2021   grade_2                                                   93                                             93
2742366 2742366 CT     school 903840 1190011   Rocky Hill School District 90384000784 1190411 Myrtle H. Stevens School Public Schools Regular School No Elementary PK 03 2021   grade_2                                                   93                                             93
2742453 2742453 CT     school 904320 1350011   Stamford School District 90432000864 1350811 Rogers International School Public Schools Regular School No Elementary KG 08 2021   grade_2                                                   93                                             93
2742531 2742531 CT     school 904620 1440011   Trumbull School District 90462000929 1440811 Daniels Farm School Public Schools Regular School No Elementary KG 05 2021   grade_2                                                   93                                             93
2741614 2741614 CT     school 901020 340011   Danbury School District 90102000153 341311 King Street Primary School Public Schools Regular School No Elementary KG 03 2021   grade_2                                                   92                                             92
2741978 2741978 CT     school 902400 800011   Meriden School District 90240000440 801111 Casimir Pulaski School Public Schools Regular School No Elementary KG 05 2021   grade_2                                                   91                                             91
2742455 2742455 CT     school 904320 1350011   Stamford School District 90432000866 1351111 Springdale School Public Schools Regular School No Elementary KG 05 2021   grade_2                                                   91                                             91
2742555 2742555 CT     school 904740 1480011   Wallingford School District 90474000952 1480911 Evarts C. Stevens School Public Schools Regular School No Elementary PK 02 2021   grade_2                                                   91                                             91
2741430 2741430 CT     school 900270 90011   Bethel School District 90027000027 90111 Frank A. Berry School Public Schools Regular School No Elementary PK 02 2021   grade_2                                                   90                                             90
2741431 2741431 CT     school 900270 90011   Bethel School District 90027000023 90411 Anna H. Rockwell School Public Schools Regular School No Elementary KG 02 2021   grade_2                                                   90                                             90
2741945 2741945 CT     school 902280 760011   Madison School District 90228000410 760111 J. Milton Jeffrey Elementary School Public Schools Regular School No Elementary KG 03 2021   grade_2                                                   90                                             90
2742096 2742096 CT     school 902700 900011   New Canaan School District 90270000533 900211 South School Public Schools Regular School No Elementary KG 04 2021   grade_2                                                   90                                             90
2742451 2742451 CT     school 904320 1350011   Stamford School District 90432000860 1350611 Newfield School Public Schools Regular School No Elementary KG 05 2021   grade_2                                                   89                                             89
2741536 2741536 CT     school 900570 190011   Brooklyn School District 90057000113 190111 Brooklyn Elementary School Public Schools Regular School No Elementary PK 04 2021   grade_2                                                   88                                             88
2742404 2742404 CT     school 904140 1290011   Somers School District 90414000526 1290411 Somers Elementary School Public Schools Regular School No Elementary PK 05 2021   grade_2                                                   88                                             88
2742582 2742582 CT     school 904830 1510011   Waterbury School District 90483000541 1513111 Maloney Interdistrict Magnet School Public Schools Regular School No Elementary PK 05 2021   grade_2                                                   88                                             88
2742585 2742585 CT     school 904830 1510011   Waterbury School District 90483001131 1513311 Rotella Interdistrict Magnet School Public Schools Regular School No Elementary PK 05 2021   grade_2                                                   88                                             88
2741934 2741934 CT     school 902160 720011   Ledyard School District 90216000397 720211 Gales Ferry School Public Schools Regular School No Elementary KG 02 2021   grade_2                                                   87                                             87
2742122 2742122 CT     school 902790 930011   New Haven School District 90279000554 931611 Fair Haven School Public Schools Regular School No Elementary PK 08 2021   grade_2                                                   87                                             87
2742227 2742227 CT     school 903090 1030011   Norwalk School District 90309000660 1031411 Tracey Magnet School Public Schools Regular School No Elementary KG 05 2021   grade_2                                                   87                                             87
2742575 2742575 CT     school 904830 1510011   Waterbury School District 90483000966 1512111 B. W. Tinker School Public Schools Regular School No Elementary PK 05 2021   grade_2                                                   87                                             87
2741621 2741621 CT     school 901020 340011   Danbury School District 90102000163 341611 Stadley Rough School Public Schools Regular School No Elementary KG 05 2021   grade_2                                                   86                                             86
2741773 2741773 CT     school 901620 540011   Glastonbury School District 90162001447 540911 Nayaug Elementary School Public Schools Regular School No Elementary KG 05 2021   grade_2                                                   86                                             86
2742184 2742184 CT     school 902880 940011   Newington School District 90288000606 940811 John Paterson School Public Schools Regular School No Elementary PK 04 2021   grade_2                                                   86                                             86
2742454 2742454 CT     school 904320 1350011   Stamford School District 90432000865 1350911 Roxbury School Public Schools Regular School No Elementary KG 05 2021   grade_2                                                   86                                             86
2742556 2742556 CT     school 904740 1480011   Wallingford School District 90474000953 1480211 Highland School Public Schools Regular School No Elementary PK 02 2021   grade_2                                                   86                                             86
2742071 2742071 CT     school 902670 890011   New Britain School District 90267000513 890611 Holmes Elementary School Public Schools Regular School No Elementary KG 05 2021   grade_2                                                   85                                             85
2742676 2742676 CT     school 904950 1560011   West Haven School District 90495001038 1561411 Savin Rock Community School Public Schools Regular School No Elementary PK 04 2021   grade_2                                                   85                                             85
2742698 2742698 CT     school 905040 1580011   Westport School District 90504001056 1580711 Long Lots School Public Schools Regular School No Elementary KG 05 2021   grade_2                                                   85                                             85
2741771 2741771 CT     school 901620 540011   Glastonbury School District 90162000286 540611 Hopewell School Public Schools Regular School No Elementary KG 05 2021   grade_2                                                   84                                             84

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