Data source: Big Local News · About: Big Local

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

View and edit SQL

year

  • 2020 · 1,461

grade

  • grade_2 · 1,461
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 ▲
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
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
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
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 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
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
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 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
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
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 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
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
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
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 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 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
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
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 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
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
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
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
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
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 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
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 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
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 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
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 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 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
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
2761690 CT     school 900270 90011   Bethel School District 90027000027 90111 Frank A. Berry School Public Schools Regular School No Elementary PK 03 2020   grade_2                                                   109                                             109
2761801 CT     school 900690 230011   Canton School District 90069000120 230211 Cherry Brook Primary School Public Schools Regular School No Elementary PK 03 2020   grade_2                                                   109                                             109
2762750 CT     school 904440 1380011   Stratford School District 90444000892 1381511 Stratford Academy - Johnson House Public Schools Regular School No Elementary 02 06 2020   grade_2                                                   109                                             109
2761691 CT     school 900270 90011   Bethel School District 90027000023 90411 Anna H. Rockwell School Public Schools Regular School No Elementary KG 03 2020   grade_2                                                   108                                             108
2762337 CT     school 902670 890011   New Britain School District 90267000523 891211 Smalley Elementary School Public Schools Regular School No Elementary KG 05 2020   grade_2                                                   108                                             108
2762713 CT     school 904320 1350011   Stamford School District 90432000861 1351811 Northeast School Public Schools Regular School No Elementary KG 05 2020   grade_2                                                   108                                             108
2762817 CT     school 904740 1480011   Wallingford School District 90474000957 1480111 Moses Y. Beach School Public Schools Regular School No Elementary PK 02 2020   grade_2                                                   106                                             106
2762233 CT     school 902400 800011   Meriden School District 90240000442 800311 Hanover School Public Schools Regular School No Elementary PK 05 2020   grade_2                                                   104                                             104
2762301 CT     school 902550 850011   Monroe School District 90255000488 850511 Fawn Hollow Elementary School Public Schools Regular School No Elementary KG 05 2020   grade_2                                                   104                                             104
2762718 CT     school 904320 1350011   Stamford School District 90432001916 1350711 Strawberry Hill an ext. of Rogers International Public Schools Regular School No Elementary KG 04 2020   grade_2                                                   104                                             104
2762964 CT     school 905040 1580011   Westport School District 90504001056 1580711 Long Lots School Public Schools Regular School No Elementary KG 05 2020   grade_2                                                   104                                             104
2761833 CT     school 900750 250011   Cheshire School District 90075000127 250411 Highland School Public Schools Regular School No Elementary KG 06 2020   grade_2                                                   103                                             103
2762218 CT     school 902310 770011   Manchester School District 90231000430 771311 Waddell School Public Schools Regular School No Elementary KG 04 2020   grade_2                                                   103                                             103
2761657 CT     school 900060 20011   Ansonia School District 90006001020 20811 Prendergast School Public Schools Regular School No Elementary KG 06 2020   grade_2                                                   102                                             102
2762701 CT     school 904290 1340011   Stafford School District 90429001503 1340611 Stafford Elementary School Public Schools Regular School No Elementary 02 05 2020   grade_2                                                   102                                             102
2761723 CT     school 900450 150011   Bridgeport School District 90045000053 154011 Blackham School Public Schools Regular School No Elementary PK 08 2020   grade_2                                                   101                                             101
2762711 CT     school 904320 1350011   Stamford School District 90432000858 1351211 Julia A. Stark School Public Schools Regular School No Elementary KG 05 2020   grade_2                                                   101                                             101
2762715 CT     school 904320 1350011   Stamford School District 90432000866 1351111 Springdale School Public Schools Regular School No Elementary KG 05 2020   grade_2                                                   101                                             101
2761879 CT     school 901020 340011   Danbury School District 90102000157 340811 Park Avenue School Public Schools Regular School No Elementary KG 05 2020   grade_2                                                   100                                             100
2762435 CT     school 902850 960011   New Milford School District 90285000599 960511 Hill And Plain School Public Schools Regular School No Elementary PK 02 2020   grade_2                                                   100                                             100
2761844 CT     school 900810 270011   Clinton School District 90081000132 270311 Lewin G. Joel Jr. School Public Schools Regular School No Elementary PK 04 2020   grade_2                                                   99                                             99
2762664 CT     school 904140 1290011   Somers School District 90414000526 1290411 Somers Elementary School Public Schools Regular School No Elementary PK 05 2020   grade_2                                                   99                                             99
2762716 CT     school 904320 1350011   Stamford School District 90432000868 1352111 Stillmeadow School Public Schools Regular School No Elementary KG 05 2020   grade_2                                                   99                                             99
2762794 CT     school 904620 1440011   Trumbull School District 90462000934 1440311 Middlebrook School Public Schools Regular School No Elementary KG 05 2020   grade_2                                                   99                                             99
2761771 CT     school 900510 170011   Bristol School District 90051001624 172011 West Bristol School Public Schools Regular School No Elementary KG 08 2020   grade_2                                                   98                                             98
2761954 CT     school 901410 460011   Easton School District 90141000234 460111 Samuel Staples Elementary School Public Schools Regular School No Elementary PK 05 2020   grade_2                                                   98                                             98
2762354 CT     school 902700 900011   New Canaan School District 90270000530 900411 East School Public Schools Regular School No Elementary KG 04 2020   grade_2                                                   98                                             98
2762546 CT     school 903390 1130011   Portland School District 90339000711 1130411 Gildersleeve School Public Schools Regular School No Elementary 02 04 2020   grade_2                                                   98                                             98
2762626 CT     school 903840 1190011   Rocky Hill School District 90384000786 1190511 West Hill School Public Schools Regular School No Elementary PK 03 2020   grade_2                                                   98                                             98
2762671 CT     school 904170 1320011   South Windsor School District 90417000825 1320211 Pleasant Valley School Public Schools Regular School No Elementary KG 05 2020   grade_2                                                   98                                             98
2762720 CT     school 904320 1350011   Stamford School District 90432000872 1351411 Westover School Public Schools Regular School No Elementary KG 05 2020   grade_2                                                   98                                             98
2761877 CT     school 901020 340011   Danbury School District 90102000154 340511 Mill Ridge Primary School Public Schools Regular School No Elementary KG 03 2020   grade_2                                                   97                                             97
2762015 CT     school 901560 520011   Farmington School District 90156001206 520411 East Farms School Public Schools Regular School No Elementary KG 04 2020   grade_2                                                   97                                             97
2762552 CT     school 903480 1160011   Putnam School District 90348000718 1160311 Putnam Elementary School Public Schools Regular School No Elementary PK 05 2020   grade_2                                                   97                                             97
2762635 CT     school 903990 1240011   Seymour School District 90399001642 1240211 Chatfield-LoPresti School Public Schools Regular School No Elementary PK 05 2020   grade_2                                                   97                                             97
2762866 CT     school 904830 1510011   Waterbury School District 90483000974 1511111 Margaret M. Generali Elementary School Public Schools Regular School No Elementary KG 05 2020   grade_2                                                   97                                             97
2762205 CT     school 902280 760011   Madison School District 90228000410 760111 J. Milton Jeffrey Elementary School Public Schools Regular School No Elementary KG 03 2020   grade_2                                                   96                                             96
2762816 CT     school 904740 1480011   Wallingford School District 90474000953 1480211 Highland School Public Schools Regular School No Elementary PK 02 2020   grade_2                                                   96                                             96
2763030 CT     school 900024 2790013   Amistad Academy District 90002400981 2795113 Amistad Academy Public Charter Schools Regular School Yes Other KG 12 2020   grade_2                                                   96                                             96
2762238 CT     school 902400 800011   Meriden School District 90240000448 800711 Nathan Hale School Public Schools Regular School No Elementary KG 05 2020   grade_2                                                   95                                             95
2762239 CT     school 902400 800011   Meriden School District 90240000440 801111 Casimir Pulaski School Public Schools Regular School No Elementary KG 05 2020   grade_2                                                   95                                             95
2762318 CT     school 902640 880011   Naugatuck School District 90264001223 880311 Maple Hill School Public Schools Regular School No Elementary KG 04 2020   grade_2                                                   95                                             95
2762941 CT     school 904950 1560011   West Haven School District 90495001038 1561411 Savin Rock Community School Public Schools Regular School No Elementary PK 04 2020   grade_2                                                   95                                             95
2763028 CT     school 900208 2850013   Achievement First Bridgeport Academy District 90020801493 2850113 Achievement First Bridgeport Academy Public Charter Schools Regular School Yes Other KG 12 2020   grade_2                                                   95                                             95
2762591 CT     school 903538 2160012   Regional School District 16 90353801811 2160512 Prospect Elementary School Regional Schools Regular School No Elementary PK 05 2020   grade_2                                                   94                                             94
2763026 CT     school 905370 1690011   Woodstock School District 90537001110 1690211 Woodstock Elementary School Public Schools Regular School No Elementary PK 04 2020   grade_2                                                   94                                             94
2761883 CT     school 901020 340011   Danbury School District 90102000163 341611 Stadley Rough School Public Schools Regular School No Elementary KG 05 2020   grade_2                                                   93                                             93
2761973 CT     school 901470 490011   Enfield School District 90147000244 490211 Enfield Street School Public Schools Regular School No Elementary KG 02 2020   grade_2                                                   93                                             93
2762625 CT     school 903840 1190011   Rocky Hill School District 90384000784 1190411 Myrtle H. Stevens School Public Schools Regular School No Elementary PK 03 2020   grade_2                                                   92                                             92
2761881 CT     school 901020 340011   Danbury School District 90102000161 341211 Shelter Rock School Public Schools Regular School No Elementary KG 05 2020   grade_2                                                   91                                             91
2761949 CT     school 901350 470011   East Windsor School District 90135000228 470111 Broad Brook Elementary School Public Schools Regular School No Elementary PK 04 2020   grade_2                                                   91                                             91
2762165 CT     school 902010 670011   Hebron School District 90201000387 670211 Gilead Hill School Public Schools Regular School No Elementary PK 02 2020   grade_2                                                   91                                             91
2762709 CT     school 904320 1350011   Stamford School District 90432000865 1350911 Roxbury School Public Schools Regular School No Elementary PK 05 2020   grade_2                                                   91                                             91
2762714 CT     school 904320 1350011   Stamford School District 90432000864 1350811 Rogers International School Public Schools Regular School No Elementary KG 08 2020   grade_2                                                   91                                             91
2762771 CT     school 904530 1410011   Thompson School District 90453000909 1410111 Mary R. Fisher Elementary School Public Schools Regular School No Elementary PK 04 2020   grade_2                                                   91                                             91
2763010 CT     school 905220 1640011   Windsor School District 90522001093 1640511 Poquonock Elementary School Public Schools Regular School No Elementary PK 02 2020   grade_2                                                   91                                             91
2761684 CT     school 900210 70011   Berlin School District 90021000020 70511 Mary E. Griswold School Public Schools Regular School No Elementary PK 05 2020   grade_2                                                   90                                             90
2761760 CT     school 900510 170011   Bristol School District 90051000098 170511 Greene-Hills School Public Schools Regular School No Elementary PK 08 2020   grade_2                                                   90                                             90
2762815 CT     school 904740 1480011   Wallingford School District 90474000952 1480911 Evarts C. Stevens School Public Schools Regular School No Elementary PK 02 2020   grade_2                                                   90                                             90
2761656 CT     school 900060 20011   Ansonia School District 90006000005 20311 Mead School Public Schools Regular School No Elementary PK 06 2020   grade_2                                                   89                                             89
2761922 CT     school 901260 430011   East Hartford School District 90126000196 431011 Dr. Thomas S. O'Connell School Public Schools Regular School No Elementary KG 05 2020   grade_2                                                   89                                             89
2762335 CT     school 902670 890011   New Britain School District 90267000515 890811 Lincoln Elementary School Public Schools Regular School No Elementary KG 05 2020   grade_2                                                   89                                             89
2762430 CT     school 902820 950011   New London School District 90282000597 950811 Winthrop STEM Elementary Magnet School Public Schools Regular School No Elementary KG 05 2020   grade_2                                                   89                                             89
2762529 CT     school 903270 1090011   Plainfield School District 90327000047 1090411 Shepard Hill Elementary School Public Schools Regular School No Elementary PK 03 2020   grade_2                                                   89                                             89
2762706 CT     school 904320 1350011   Stamford School District 90432000852 1352011 Davenport Ridge School Public Schools Regular School No Elementary PK 05 2020   grade_2                                                   89                                             89
2762710 CT     school 904320 1350011   Stamford School District 90432000167 1352211 Hart School Public Schools Regular School No Elementary KG 05 2020   grade_2                                                   89                                             89
2763029 CT     school 900212 2880013   Achievement First Hartford Academy District 90021201528 2880113 Achievement First Hartford Academy Public Charter Schools Regular School Yes Other KG 12 2020   grade_2                                                   89                                             89

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