Data source: Big Local News · About: Big Local

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

View and edit SQL

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
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
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
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
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
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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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
2741844 CT     school 901890 630011   Hampton School District 90189000351 630111 Hampton Elementary School Public Schools Regular School No Elementary PK 06 2021   grade_2                                                   9                                             9
2742608 CT     school   1510011   Waterbury School District 90483000958 1519011 State Street School Program           2021   grade_2                                                   9                                             9
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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 CT     school 901620 540011   Glastonbury School District 90162000286 540611 Hopewell School Public Schools Regular School No Elementary KG 05 2021   grade_2                                                   84                                             84
2741922 CT     school 903450 2450014   Learn 90345000079 2450114 Regional Multicultural Magnet School Regional Education Service Center Schools Regular School No Elementary KG 05 2021   grade_2                                                   84                                             84
2742226 CT     school 903090 1030011   Norwalk School District 90309000659 1032311 Silvermine Dual Language Magnet School Public Schools Regular School No Elementary KG 05 2021   grade_2                                                   84                                             84
2741407 CT     school 900060 20011   Ansonia School District 90006001020 20811 Prendergast School Public Schools Regular School No Elementary KG 06 2021   grade_2                                                   83                                             83
2741468 CT     school 900450 150011   Bridgeport School District 90045000087 153211 Geraldine Johnson School Public Schools Regular School No Elementary PK 08 2021   grade_2                                                   83                                             83
2741509 CT     school 900510 170011   Bristol School District 90051001624 172011 West Bristol School Public Schools Regular School No Elementary KG 08 2021   grade_2                                                   83                                             83
2741698 CT     school 901410 460011   Easton School District 90141000234 460111 Samuel Staples Elementary School Public Schools Regular School No Elementary PK 05 2021   grade_2                                                   83                                             83
2741793 CT     school 901710 570011   Greenwich School District 90171000308 571011 Riverside School Public Schools Regular School No Elementary KG 05 2021   grade_2                                                   83                                             83
2741974 CT     school 902400 800011   Meriden School District 90240000445 800511 John Barry School Public Schools Regular School No Elementary PK 05 2021   grade_2                                                   83                                             83
2741769 CT     school 901620 540011   Glastonbury School District 90162000280 540211 Buttonball Lane School Public Schools Regular School No Elementary KG 05 2021   grade_2                                                   82                                             82
2741975 CT     school 902400 800011   Meriden School District 90240000448 800711 Nathan Hale School Public Schools Regular School No Elementary PK 05 2021   grade_2                                                   82                                             82
2742074 CT     school 902670 890011   New Britain School District 90267000510 891111 DiLoreto Elementary & Middle School Public Schools Regular School No Elementary KG 08 2021   grade_2                                                   82                                             82
2742082 CT     school 902670 890011   New Britain School District 90267000527 891511 Vance Elementary School Public Schools Regular School No Elementary KG 05 2021   grade_2                                                   82                                             82
2742375 CT     school 903990 1240011   Seymour School District 90399001642 1240211 Chatfield-LoPresti School Public Schools Regular School No Elementary PK 05 2021   grade_2                                                   82                                             82
2742554 CT     school 904740 1480011   Wallingford School District 90474000950 1481011 Cook Hill School Public Schools Regular School No Elementary PK 02 2021   grade_2                                                   82                                             82
2741933 CT     school 902160 720011   Ledyard School District 90216000398 720411 Gallup Hill School Public Schools Regular School No Elementary PK 05 2021   grade_2                                                   81                                             81
2741958 CT     school 902310 770011   Manchester School District 90231000430 771311 Waddell School Public Schools Regular School No Elementary KG 04 2021   grade_2                                                   81                                             81
2742170 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_2                                                   81                                             81
2742324 CT     school 903537 2150012   Regional School District 15 90353700708 2150712 Long Meadow Elementary School Regional Schools Regular School No Elementary PK 05 2021   grade_2                                                   81                                             81
2742396 CT     school 904110 1280011   Simsbury School District 90411000814 1280711 Squadron Line School Public Schools Regular School No Elementary PK 06 2021   grade_2                                                   81                                             81
2742533 CT     school 904620 1440011   Trumbull School District 90462000931 1440411 Jane Ryan School Public Schools Regular School No Elementary KG 05 2021   grade_2                                                   81                                             81
2742655 CT     school 904920 1550011   West Hartford School District 90492001014 1550611 Duffy School Public Schools Regular School No Elementary KG 05 2021   grade_2                                                   81                                             81
2742672 CT     school 904950 1560011   West Haven School District 90495001040 1561211 Washington School Public Schools Regular School No Elementary PK 04 2021   grade_2                                                   81                                             81
2741474 CT     school 900450 150011   Bridgeport School District 90045000001 151011 Luis Munoz Marin School Public Schools Regular School No Elementary PK 08 2021   grade_2                                                   80                                             80
2741633 CT     school 901050 350011   Darien School District 90105000165 350211 Hindley Elementary School Public Schools Regular School No Elementary KG 05 2021   grade_2                                                   80                                             80
2741718 CT     school 901470 490011   Enfield School District 90147000244 490211 Enfield Street School Public Schools Regular School No Elementary KG 02 2021   grade_2                                                   80                                             80
2742070 CT     school 902670 890011   New Britain School District 90267000514 890711 Jefferson Elementary School Public Schools Regular School No Elementary KG 05 2021   grade_2                                                   80                                             80
2742298 CT     school 903510 1170011   Redding School District 90351000722 1170111 Redding Elementary School Public Schools Regular School No Elementary PK 04 2021   grade_2                                                   80                                             80
2742535 CT     school 904620 1440011   Trumbull School District 90462000936 1440911 Tashua School Public Schools Regular School No Elementary KG 05 2021   grade_2                                                   80                                             80
2741826 CT     school   620011   Hamden School District   620711 Alice Peck IIC Program           2021   grade_2                                                   8                                             8
2741836 CT     school   620011   Hamden School District   621811 West Woods IIC Program           2021   grade_2                                                   8                                             8
2741879 CT     school   640011   Hartford School District 90192001732 645711 iGOAL 1 - M.D. Fox School Program           2021   grade_2                                                   8                                             8
2742311 CT     school 903530 2120012   Regional School District 12 90353000734 2120112 The Burnham School Regional Schools Regular School No Elementary KG 05 2021   grade_2                                                   8                                             8
2742553 CT     school 904710 1470011   Voluntown School District 90471000949 1470111 Voluntown Elementary School Public Schools Regular School No Elementary PK 08 2021   grade_2                                                   8                                             8
2742600 CT     school   1510011   Waterbury School District   1513511 Generali Autism Program           2021   grade_2                                                   8                                             8
2741406 CT     school 900060 20011   Ansonia School District 90006000005 20311 Mead School Public Schools Regular School No Elementary PK 06 2021   grade_2                                                   79                                             79
2741424 CT     school 900210 70011   Berlin School District 90021000020 70511 Mary E. Griswold School Public Schools Regular School No Elementary KG 05 2021   grade_2                                                   79                                             79
2741573 CT     school 900750 250011   Cheshire School District 90075000129 250511 Norton School Public Schools Regular School No Elementary KG 06 2021   grade_2                                                   79                                             79
2741619 CT     school 901020 340011   Danbury School District 90102000161 341211 Shelter Rock School Public Schools Regular School No Elementary KG 05 2021   grade_2                                                   79                                             79
2742094 CT     school 902700 900011   New Canaan School District 90270000534 900311 West School Public Schools Regular School No Elementary PK 04 2021   grade_2                                                   79                                             79
2742171 CT     school 902820 950011   New London School District 90282000597 950811 Winthrop STEM Elementary Magnet School Public Schools Regular School No Elementary KG 05 2021   grade_2                                                   79                                             79
2742578 CT     school 904830 1510011   Waterbury School District 90483000972 1510911 Driggs School Public Schools Regular School No Elementary PK 05 2021   grade_2                                                   79                                             79
2742675 CT     school 904950 1560011   West Haven School District 90495001035 1560311 Forest School Public Schools Regular School No Elementary PK 04 2021   grade_2                                                   79                                             79
2741687 CT     school 901350 470011   East Windsor School District 90135000228 470111 Broad Brook Elementary School Public Schools Regular School No Elementary PK 04 2021   grade_2                                                   78                                             78
2741760 CT     school 901560 520011   Farmington School District 90156001206 520411 East Farms School Public Schools Regular School No Elementary KG 04 2021   grade_2                                                   78                                             78
2742327 CT     school 903537 2150012   Regional School District 15 90353700750 2150512 Pomperaug School Regional Schools Regular School No Elementary KG 05 2021   grade_2                                                   78                                             78
2742649 CT     school 904920 1550011   West Hartford School District 90492001012 1550511 Charter Oak International Academy Public Schools Regular School No Elementary PK 05 2021   grade_2                                                   78                                             78
2742673 CT     school 904950 1560011   West Haven School District 90495001027 1560811 Alma E. Pagels School Public Schools Regular School No Elementary PK 04 2021   grade_2                                                   78                                             78

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