enrollments

Data source: Big Local News · About: Big Local

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

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2021 · 1,344 ✖

grade ✖

  • grade_2 · 1,344 ✖
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
2742107 2742107 CT     school 902760 920011   New Hartford School District 90276000538 920311 Ann Antolini School Public Schools Regular School No Elementary 03 06 2021   grade_2                                                   0                                             0
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
2742101 2742101 CT     school 902730 910011   New Fairfield School District 90273001195 910211 Meeting House Hill School Public Schools Regular School No Elementary 03 05 2021   grade_2                                                   0                                             0
2742102 2742102 CT     school 902730 910011   New Fairfield School District 90273001224 915211 New Fairfield Middle School Public Schools Regular School No Middle 06 08 2021   grade_2                                                   0                                             0
2742103 2742103 CT     school 902730 910011   New Fairfield School District 90273000537 916111 New Fairfield High School Public Schools Regular School No High 09 12 2021   grade_2                                                   0                                             0
2742104 2742104 CT     school   910011   New Fairfield School District 90273001687 910311 Alternative Learning Center Program           2021   grade_2                                                   0                                             0
2742847 2742847 CT     school 905373 9030022   The Woodstock Academy District 90537311223 9036122 The Woodstock Academy Endowed and Incorporated Academies Schools Regular School No High 09 12 2021   grade_2                                                   0                                             0
2742809 2742809 CT     school 905372 9020022   The Gilbert School District 90537201222 9026122 The Gilbert School Endowed and Incorporated Academies Schools Regular School No High 07 12 2021   grade_2                                                   0                                             0
2742841 2742841 CT     school 905371 9010022   Norwich Free Academy District 90537101221 9016122 Norwich Free Academy Endowed and Incorporated Academies Schools Regular School No High 09 12 2021   grade_2                                                   0                                             0
2742842 2742842 CT     school 905371 9010022   Norwich Free Academy District 90537101221 9010222 Night School Program Regular School No High 09 12 2021   grade_2                                                   0                                             0
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
2741432 2741432 CT     school 900270 90011   Bethel School District 90027001118 90511 Ralph M. T. Johnson School Public Schools Regular School No Elementary 03 05 2021   grade_2                                                   0                                             0
2741433 2741433 CT     school 900270 90011   Bethel School District 90027000025 95111 Bethel Middle School Public Schools Regular School No Middle 06 08 2021   grade_2                                                   0                                             0
2741434 2741434 CT     school 900270 90011   Bethel School District 90027000024 96111 Bethel High School Public Schools Regular School No High 09 12 2021   grade_2                                                   0                                             0
2741435 2741435 CT     school   90011   Bethel School District   90311 TASK Program           2021   grade_2                                                   0                                             0
2741436 2741436 CT     school   90011   Bethel School District   90211 Community Partnership Program Program           2021   grade_2                                                   0                                             0
2742094 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
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
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
2742097 2742097 CT     school 902700 900011   New Canaan School District 90270000532 905111 Saxe Middle School Public Schools Regular School No Middle 05 08 2021   grade_2                                                   0                                             0
2742098 2742098 CT     school 902700 900011   New Canaan School District 90270000531 906111 New Canaan High School Public Schools Regular School No High 09 12 2021   grade_2                                                   0                                             0
2742099 2742099 CT     school   900011   New Canaan School District   900111 Launch Program           2021   grade_2                                                   0                                             0
2742821 2742821 CT     school 900002 9000016   Connecticut Technical Education and Career System 90000201136 9001516 A. I. Prince Technical High School CT Technical Education and Career Schools Career and Technical School No High 09 12 2021   grade_2                                                   0                                             0
2742822 2742822 CT     school 900002 9000016   Connecticut Technical Education and Career System 90000201137 9001116 Bullard-Havens Technical High School CT Technical Education and Career Schools Career and Technical School No High 09 12 2021   grade_2                                                   0                                             0
2742823 2742823 CT     school 900002 9000016   Connecticut Technical Education and Career System 90000201138 9001916 E. C. Goodwin Technical High School CT Technical Education and Career Schools Career and Technical School No High 09 12 2021   grade_2                                                   0                                             0
2742824 2742824 CT     school 900002 9000016   Connecticut Technical Education and Career System 90000201140 9001416 Eli Whitney Technical High School CT Technical Education and Career Schools Career and Technical School No High 09 12 2021   grade_2                                                   0                                             0
2742825 2742825 CT     school 900002 9000016   Connecticut Technical Education and Career System 90000201139 9002716 Ella T. Grasso Technical High School CT Technical Education and Career Schools Career and Technical School No High 09 12 2021   grade_2                                                   0                                             0
2742826 2742826 CT     school 900002 9000016   Connecticut Technical Education and Career System 90000201141 9002516 Emmett O'Brien Technical High School CT Technical Education and Career Schools Career and Technical School No High 09 12 2021   grade_2                                                   0                                             0
2742827 2742827 CT     school 900002 9000016   Connecticut Technical Education and Career System 90000201142 9001716 H. C. Wilcox Technical High School CT Technical Education and Career Schools Career and Technical School No High 09 12 2021   grade_2                                                   0                                             0
2742828 2742828 CT     school 900002 9000016   Connecticut Technical Education and Career System 90000201143 9001316 H. H. Ellis Technical High School CT Technical Education and Career Schools Career and Technical School No High 09 12 2021   grade_2                                                   0                                             0
2742829 2742829 CT     school 900002 9000016   Connecticut Technical Education and Career System 90000201144 9001216 Henry Abbott Technical High School CT Technical Education and Career Schools Career and Technical School No High 09 12 2021   grade_2                                                   0                                             0
2742830 2742830 CT     school 900002 9000016   Connecticut Technical Education and Career System 90000201145 9001616 Howell Cheney Technical High School CT Technical Education and Career Schools Career and Technical School No High 09 12 2021   grade_2                                                   0                                             0
2742831 2742831 CT     school 900002 9000016   Connecticut Technical Education and Career System 90000201672 9002116 J. M. Wright Technical High School CT Technical Education and Career Schools Career and Technical School No High 09 12 2021   grade_2                                                   0                                             0
2742832 2742832 CT     school 900002 9000016   Connecticut Technical Education and Career System 90000201147 9002016 Norwich Technical High School CT Technical Education and Career Schools Career and Technical School No High 09 12 2021   grade_2                                                   0                                             0
2742833 2742833 CT     school 900002 9000016   Connecticut Technical Education and Career System 90000201148 9002216 Oliver Wolcott Technical High School CT Technical Education and Career Schools Career and Technical School No High 09 12 2021   grade_2                                                   0                                             0
2742834 2742834 CT     school 900002 9000016   Connecticut Technical Education and Career System 90000201149 9002616 Platt Technical High School CT Technical Education and Career Schools Career and Technical School No High 09 12 2021   grade_2                                                   0                                             0
2742835 2742835 CT     school 900002 9000016   Connecticut Technical Education and Career System 90000201150 9001816 Vinal Technical High School CT Technical Education and Career Schools Career and Technical School No High 09 12 2021   grade_2                                                   0                                             0
2742836 2742836 CT     school 900002 9000016   Connecticut Technical Education and Career System 90000201151 9002316 W. F. Kaynor Technical High School CT Technical Education and Career Schools Career and Technical School No High 09 12 2021   grade_2                                                   0                                             0
2742837 2742837 CT     school 900002 9000016   Connecticut Technical Education and Career System 90000201152 9002416 Windham Technical High School CT Technical Education and Career Schools Career and Technical School No High 09 12 2021   grade_2                                                   0                                             0
2742067 2742067 CT     school 902670 890011   New Britain School District 90267000512 890511 Gaffney Elementary School Public Schools Regular School No Elementary PK 05 2021   grade_2                                                   76                                             76
2742068 2742068 CT     school   890011   New Britain School District   891611 Gaffney KEY Elementary Program           2021   grade_2                                                   11                                             11
2742069 2742069 CT     school   890011   New Britain School District   890111 Roosevelt Early Learning Center Program           2021   grade_2                                                   0                                             0
2742070 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
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
2742072 2742072 CT     school 902670 890011   New Britain School District 90267000509 890311 Chamberlain Elementary School Public Schools Regular School No Elementary KG 05 2021   grade_2                                                   69                                             69
2742073 2742073 CT     school   890011   New Britain School District   890211 Chamberlain Bridges Program           2021   grade_2                                                   7                                             7
2742074 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
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
2742076 2742076 CT     school   890011   New Britain School District   892011 Lincoln KEY Elementary Program           2021   grade_2                                                   *                                              
2742077 2742077 CT     school 902670 890011   New Britain School District 90267000517 890911 Northend Elementary School Public Schools Regular School No Elementary KG 05 2021   grade_2                                                   42                                             42
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
2742079 2742079 CT     school 902670 890011   New Britain School District 90267000524 891311 Smith Elementary School Public Schools Regular School No Elementary KG 05 2021   grade_2                                                   74                                             74
2742080 2742080 CT     school   890011   New Britain School District   892111 Smith KEY Elementary Program           2021   grade_2                                                   *                                              
2742081 2742081 CT     school   890011   New Britain School District   891911 Smith Pathways Program           2021   grade_2                                                   0                                             0
2742082 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
2742083 2742083 CT     school   890011   New Britain School District 90267001566 899011 New Britain Transition Center Program           2021   grade_2                                                   *                                              
2742084 2742084 CT     school   890011   New Britain School District   890411 Holmes Bridges Program           2021   grade_2                                                   *                                              
2742085 2742085 CT     school   890011   New Britain School District   891011 Lincoln SCS Program           2021   grade_2                                                   *                                              
2742086 2742086 CT     school 902670 890011   New Britain School District 90267001445 895411 House of Arts Letters and Science (HALS) Academy Public Schools Regular School No Middle 06 08 2021   grade_2                                                   0                                             0
2742087 2742087 CT     school 902670 890011   New Britain School District 90267000518 895311 Pulaski Middle School Public Schools Regular School No Middle 06 08 2021   grade_2                                                   0                                             0
2742088 2742088 CT     school   890011   New Britain School District   891711 Slade KEY Middle Program           2021   grade_2                                                   0                                             0
2742089 2742089 CT     school 902670 890011   New Britain School District 90267000522 895211 Slade Middle School Public Schools Regular School No Middle 06 08 2021   grade_2                                                   0                                             0
2742090 2742090 CT     school   890011   New Britain School District 90267001557 899111 Brookside School Program           2021   grade_2                                                   0                                             0
2742091 2742091 CT     school 902670 890011   New Britain School District 90267000521 896111 New Britain High School Public Schools Regular School No High 09 12 2021   grade_2                                                   0                                             0
2742092 2742092 CT     school   890011   New Britain School District   899511 New Britain High School Satellite Careers Academy Program           2021   grade_2                                                   0                                             0
2742093 2742093 CT     school   890011   New Britain School District 90267001609 899411 CLIMB Program           2021   grade_2                                                   0                                             0
2742053 2742053 CT     school   880011   Naugatuck School District 90264001591 888211 Central Avenue Preschool Program           2021   grade_2                                                   0                                             0
2742054 2742054 CT     school   880011   Naugatuck School District 90264001384 888111 Head Start Program           2021   grade_2                                                   0                                             0
2742055 2742055 CT     school 902640 880011   Naugatuck School District 90264000499 880811 Andrew Avenue School Public Schools Regular School No Elementary KG 04 2021   grade_2                                                   40                                             40
2742056 2742056 CT     school 902640 880011   Naugatuck School District 90264000506 880511 Hop Brook Elementary School Public Schools Regular School No Elementary KG 04 2021   grade_2                                                   69                                             69
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
2742058 2742058 CT     school 902640 880011   Naugatuck School District 90264000507 880611 Salem School Public Schools Regular School No Elementary KG 04 2021   grade_2                                                   50                                             50
2742059 2742059 CT     school 902640 880011   Naugatuck School District 90264000508 880711 Western School Public Schools Regular School No Elementary KG 04 2021   grade_2                                                   45                                             45
2742060 2742060 CT     school 902640 880011   Naugatuck School District 90264000502 880211 Cross Street Intermediate School Public Schools Regular School No Middle 05 06 2021   grade_2                                                   0                                             0
2742061 2742061 CT     school 902640 880011   Naugatuck School District 90264000504 880411 Hillside Intermediate School Public Schools Regular School No Middle 05 06 2021   grade_2                                                   0                                             0
2742062 2742062 CT     school 902640 880011   Naugatuck School District 90264000501 885111 City Hill Middle School Public Schools Regular School No Middle 07 08 2021   grade_2                                                   0                                             0
2742063 2742063 CT     school 902640 880011   Naugatuck School District 90264000505 886111 Naugatuck High School Public Schools Regular School No High 09 12 2021   grade_2                                                   0                                             0
2742064 2742064 CT     school   880011   Naugatuck School District   880911 Genesis Academy Program           2021   grade_2                                                   0                                             0
2742065 2742065 CT     school   880011   Naugatuck School District   881011 Naugatuck Community Program Program           2021   grade_2                                                   0                                             0
2742045 2742045 CT     school 902580 860011   Montville School District 90258000494 860111 Mohegan School Public Schools Regular School No Elementary PK 05 2021   grade_2                                                   51                                             51
2742046 2742046 CT     school   860011   Montville School District 90258001663 860311 Pre School Program Program           2021   grade_2                                                   0                                             0
2742047 2742047 CT     school 902580 860011   Montville School District 90258000492 860711 Dr. Charles E. Murphy School Public Schools Regular School No Elementary KG 05 2021   grade_2                                                   42                                             42
2742048 2742048 CT     school 902580 860011   Montville School District 90258000496 860511 Oakdale School Public Schools Regular School No Elementary KG 05 2021   grade_2                                                   47                                             47
2742049 2742049 CT     school 902580 860011   Montville School District 90258000035 865111 Leonard J. Tyl Middle School Public Schools Regular School No Middle 06 08 2021   grade_2                                                   0                                             0
2742050 2742050 CT     school 902580 860011   Montville School District 90258000495 866111 Montville High School Public Schools Regular School No High 09 12 2021   grade_2                                                   0                                             0
2742051 2742051 CT     school   860011   Montville School District 90258001481 869011 Palmer Academy Program           2021   grade_2                                                   0                                             0
2742052 2742052 CT     school   860011   Montville School District   860611 Montville Transition and Vocational Training Academy Program           2021   grade_2                                                   0                                             0
2742039 2742039 CT     school 902550 850011   Monroe School District 90255000490 850111 Monroe Elementary School Public Schools Regular School No Elementary PK 05 2021   grade_2                                                   55                                             55
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
2742041 2742041 CT     school 902550 850011   Monroe School District 90255000491 850311 Stepney Elementary School Public Schools Regular School No Elementary KG 05 2021   grade_2                                                   70                                             70
2742042 2742042 CT     school 902550 850011   Monroe School District 90255000920 855211 Jockey Hollow School Public Schools Regular School No Middle 06 08 2021   grade_2                                                   0                                             0
2742043 2742043 CT     school 902550 850011   Monroe School District 90255000489 856111 Masuk High School Public Schools Regular School No High 09 12 2021   grade_2                                                   0                                             0
2742044 2742044 CT     school   850011   Monroe School District 90255001670 850211 Masuk Alternative Program Program           2021   grade_2                                                   0                                             0
2742023 2742023 CT     school 902520 840011   Milford School District 90252000471 841911 J. F. Kennedy School Public Schools Regular School No Elementary PK 05 2021   grade_2                                                   49                                             49
2742024 2742024 CT     school 902520 840011   Milford School District 90252000476 841611 Live Oaks School Public Schools Regular School No Elementary PK 05 2021   grade_2                                                   33                                             33
2742025 2742025 CT     school 902520 840011   Milford School District 90252000480 840811 Orange Avenue School Public Schools Regular School No Elementary PK 05 2021   grade_2                                                   56                                             56
2742026 2742026 CT     school 902520 840011   Milford School District 90252000481 841811 Orchard Hills School Public Schools Regular School No Elementary PK 05 2021   grade_2                                                   41                                             41
2742027 2742027 CT     school 902520 840011   Milford School District 90252000483 841011 Pumpkin Delight School Public Schools Regular School No Elementary PK 05 2021   grade_2                                                   34                                             34
2742028 2742028 CT     school 902520 840011   Milford School District 90252000467 840111 Calf Pen Meadow School Public Schools Regular School No Elementary KG 05 2021   grade_2                                                   30                                             30

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