Data source: Big Local News · About: Big Local

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

View and edit SQL

year

  • 2021 · 1,344

grade

  • grade_10 · 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
2752995 CT     school 900330 110011   Bloomfield School District 90033000034 115211 Carmen Arace Middle School Public Schools Regular School No Middle 07 08 2021   grade_10                                                   0                                             0
2752997 CT     school 900360 120011   Bolton School District 90036000036 120111 Bolton Center School Public Schools Regular School No Elementary PK 08 2021   grade_10                                                   0                                             0
2752999 CT     school   120011   Bolton School District   120211 Bolton Transition Program Program           2021   grade_10                                                   0                                             0
2753000 CT     school 900390 130011   Bozrah School District 90039000038 130111 Fields Memorial School Public Schools Regular School No Elementary PK 08 2021   grade_10                                                   0                                             0
2753001 CT     school   140011   Branford School District 90042000177 148011 Indian Neck School Program           2021   grade_10                                                   0                                             0
2753002 CT     school 900420 140011   Branford School District 90042001119 141611 John B. Sliney School Public Schools Regular School No Elementary KG 04 2021   grade_10                                                   0                                             0
2753003 CT     school 900420 140011   Branford School District 90042000043 141511 Mary R. Tisko School Public Schools Regular School No Elementary KG 04 2021   grade_10                                                   0                                             0
2753004 CT     school 900420 140011   Branford School District 90042000042 141411 Mary T. Murphy School Public Schools Regular School No Elementary KG 04 2021   grade_10                                                   0                                             0
2753005 CT     school 900420 140011   Branford School District 90042000041 145111 Francis Walsh Intermediate School Public Schools Regular School No Middle 05 08 2021   grade_10                                                   0                                             0
2753008 CT     school   140011   Branford School District   140311 Access Transition Program Program           2021   grade_10                                                   0                                             0
2753009 CT     school 900215 2900013   Brass City Charter School District 90021501644 2900113 Brass City Charter School Public Charter Schools Regular School Yes Elementary PK 08 2021   grade_10                                                   0                                             0
2753010 CT     school 900450 150011   Bridgeport School District 90045000085 154411 A.B. Skane Center Public Schools Regular School No Prekindergarten PK PK 2021   grade_10                                                   0                                             0
2753011 CT     school 900450 150011   Bridgeport School District 90045000049 150111 Barnum School Public Schools Regular School No Elementary PK 08 2021   grade_10                                                   0                                             0
2753012 CT     school 900450 150011   Bridgeport School District 90045000051 150211 Beardsley School Public Schools Regular School No Elementary PK 06 2021   grade_10                                                   0                                             0
2753013 CT     school 900450 150011   Bridgeport School District 90045000052 150311 Black Rock School Public Schools Regular School No Elementary PK 08 2021   grade_10                                                   0                                             0
2753014 CT     school 900450 150011   Bridgeport School District 90045000053 154011 Blackham School Public Schools Regular School No Elementary PK 08 2021   grade_10                                                   0                                             0
2753015 CT     school 900450 150011   Bridgeport School District 90045000054 150411 Bryant School Public Schools Regular School No Elementary PK 06 2021   grade_10                                                   0                                             0
2753016 CT     school 900450 150011   Bridgeport School District 90045000070 151411 Cesar Batalla School Public Schools Regular School No Elementary PK 08 2021   grade_10                                                   0                                             0
2753017 CT     school 900450 150011   Bridgeport School District 90045000075 152111 Classical Studies Academy Public Schools Regular School No Elementary PK 08 2021   grade_10                                                   0                                             0
2753018 CT     school 900450 150011   Bridgeport School District 90045000058 150511 Columbus School Public Schools Regular School No Elementary PK 08 2021   grade_10                                                   0                                             0
2753019 CT     school 900450 150011   Bridgeport School District 90045001918 153111 Geraldine Claytor Magnet Academy Public Schools Regular School No Elementary PK 08 2021   grade_10                                                   0                                             0
2753020 CT     school 900450 150011   Bridgeport School District 90045000087 153211 Geraldine Johnson School Public Schools Regular School No Elementary PK 08 2021   grade_10                                                   0                                             0
2753021 CT     school 900450 150011   Bridgeport School District 90045000066 151211 Hallen School Public Schools Regular School No Elementary PK 06 2021   grade_10                                                   0                                             0
2753022 CT     school 900450 150011   Bridgeport School District 90045001163 154511 High Horizons Magnet School Public Schools Regular School No Elementary PK 08 2021   grade_10                                                   0                                             0
2753023 CT     school 900450 150011   Bridgeport School District 90045001590 153711 Interdistrict Discovery Magnet School Public Schools Regular School No Elementary PK 08 2021   grade_10                                                   0                                             0
2753024 CT     school 900450 150011   Bridgeport School District 90045000076 152211 Jettie S. Tisdale School Public Schools Regular School No Elementary PK 08 2021   grade_10                                                   0                                             0
2753025 CT     school 900450 150011   Bridgeport School District 90045000090 153611 John Winthrop School Public Schools Regular School No Elementary PK 08 2021   grade_10                                                   0                                             0
2753026 CT     school 900450 150011   Bridgeport School District 90045000001 151011 Luis Munoz Marin School Public Schools Regular School No Elementary PK 08 2021   grade_10                                                   0                                             0
2753027 CT     school 900450 150011   Bridgeport School District 90045000071 151711 Park City Magnet School Public Schools Regular School No Elementary PK 08 2021   grade_10                                                   0                                             0
2753028 CT     school 900450 150011   Bridgeport School District 90045001161 154111 Paul Laurence Dunbar School Public Schools Regular School No Elementary PK 08 2021   grade_10                                                   0                                             0
2753029 CT     school 900450 150011   Bridgeport School District 90045000080 152511 Read School Public Schools Regular School No Elementary PK 08 2021   grade_10                                                   0                                             0
2753030 CT     school 900450 150011   Bridgeport School District 90045000081 152611 Roosevelt School Public Schools Regular School No Elementary PK 08 2021   grade_10                                                   0                                             0
2753031 CT     school 900450 150011   Bridgeport School District 90045000086 153011 Waltersville School Public Schools Regular School No Elementary PK 08 2021   grade_10                                                   0                                             0
2753032 CT     school 900450 150011   Bridgeport School District 90045000069 151311 Thomas Hooker School Public Schools Regular School No Elementary KG 08 2021   grade_10                                                   0                                             0
2753033 CT     school 900450 150011   Bridgeport School District 90045000060 150711 Edison School Public Schools Regular School No Elementary KG 06 2021   grade_10                                                   0                                             0
2753034 CT     school 900450 150011   Bridgeport School District 90045000065 151111 Hall School Public Schools Regular School No Elementary KG 06 2021   grade_10                                                   0                                             0
2753035 CT     school 900450 150011   Bridgeport School District 90045001162 154211 James J. Curiale School Public Schools Regular School No Elementary KG 08 2021   grade_10                                                   0                                             0
2753036 CT     school 900450 150011   Bridgeport School District 90045000074 152011 Madison School Public Schools Regular School No Elementary KG 06 2021   grade_10                                                   0                                             0
2753037 CT     school 900450 150011   Bridgeport School District 90045001127 154611 Multicultural Magnet School Public Schools Regular School No Elementary KG 08 2021   grade_10                                                   0                                             0
2753038 CT     school 900450 150011   Bridgeport School District 90045000059 153911 Wilbur Cross School Public Schools Regular School No Elementary KG 08 2021   grade_10                                                   0                                             0
2753047 CT     school   150011   Bridgeport School District   152811 The Transition Academy Program           2021   grade_10                                                   0                                             0
2753048 CT     school   170011   Bristol School District 90051001728 172911 BECC Autism Program           2021   grade_10                                                   0                                             0
2753049 CT     school 900510 170011   Bristol School District 90051001774 170411 Bristol Early Childhood Center-BECC Public Schools Special Education School No Prekindergarten PK PK 2021   grade_10                                                   0                                             0
2753050 CT     school 900510 170011   Bristol School District 90051000097 171411 Ellen P. Hubbell School Public Schools Regular School No Elementary PK 05 2021   grade_10                                                   0                                             0
2753051 CT     school 900510 170011   Bristol School District 90051000098 170511 Greene-Hills School Public Schools Regular School No Elementary PK 08 2021   grade_10                                                   0                                             0
2753052 CT     school 900510 170011   Bristol School District 90051000099 171911 Ivy Drive School Public Schools Regular School No Elementary PK 05 2021   grade_10                                                   0                                             0
2753053 CT     school 900510 170011   Bristol School District 90051000103 171711 Mountain View School Public Schools Regular School No Elementary PK 05 2021   grade_10                                                   0                                             0
2753054 CT     school 900510 170011   Bristol School District 90051000105 171111 South Side School Public Schools Regular School No Elementary PK 05 2021   grade_10                                                   0                                             0
2753055 CT     school 900510 170011   Bristol School District 90051000096 170311 Edgewood School Public Schools Regular School No Elementary KG 05 2021   grade_10                                                   0                                             0
2753056 CT     school   170011   Bristol School District 90051001646 172111 Hubbell/Extended Resource Program           2021   grade_10                                                   0                                             0
2753057 CT     school   170011   Bristol School District 90051001692 172311 Ivy Drive Medically Fragile Program           2021   grade_10                                                   0                                             0
2753058 CT     school   170011   Bristol School District 90051001755 173011 South Side Extended Resource Program           2021   grade_10                                                   0                                             0
2753059 CT     school   170011   Bristol School District 90051001707 173211 Stafford Autism Program           2021   grade_10                                                   0                                             0
2753060 CT     school 900510 170011   Bristol School District 90051000106 171211 Stafford School Public Schools Regular School No Elementary KG 05 2021   grade_10                                                   0                                             0
2753061 CT     school 900510 170011   Bristol School District 90051001624 172011 West Bristol School Public Schools Regular School No Elementary KG 08 2021   grade_10                                                   0                                             0
2753062 CT     school   170011   Bristol School District   173811 Greene Hills Extended Resource Program           2021   grade_10                                                   0                                             0
2753063 CT     school   170011   Bristol School District 90051001726 172511 Mt. View GOAL Program           2021   grade_10                                                   0                                             0
2753064 CT     school   170011   Bristol School District   173711 Hubbell Autism Program Program           2021   grade_10                                                   0                                             0
2753065 CT     school   170011   Bristol School District   172211 Ivy Drive Extended Resource Program           2021   grade_10                                                   0                                             0
2753066 CT     school   170011   Bristol School District 90051001688 172611 Ivy Drive GOAL Program           2021   grade_10                                                   0                                             0
2753068 CT     school   170011   Bristol School District   172411 Mt. View Extended Resource Program           2021   grade_10                                                   0                                             0
2753069 CT     school   170011   Bristol School District 90051001711 173111 South Side GOAL Program           2021   grade_10                                                   0                                             0
2753070 CT     school 900510 170011   Bristol School District 90051000089 175111 Chippens Hill Middle School Public Schools Regular School No Middle 06 08 2021   grade_10                                                   0                                             0
2753071 CT     school   170011   Bristol School District 90051001748 171011 Chippens Hill Middle School Functional Program Program           2021   grade_10                                                   0                                             0
2753072 CT     school   170011   Bristol School District   171611 Chippens Hill Middle School Medically Fragile Program           2021   grade_10                                                   0                                             0
2753073 CT     school   170011   Bristol School District   170811 Chippens Hilll Middle School Extended Resource Program           2021   grade_10                                                   0                                             0
2753074 CT     school   170011   Bristol School District 90051001753 173411 Chms Goal Program           2021   grade_10                                                   0                                             0
2753075 CT     school   170011   Bristol School District 90051001651 172711 Northeast MS/Extended Resource Program           2021   grade_10                                                   0                                             0
2753076 CT     school   170011   Bristol School District 90051001796 172811 Northeast MS/GOAL Program           2021   grade_10                                                   0                                             0
2753077 CT     school 900510 170011   Bristol School District 90051000104 175211 Northeast Middle School Public Schools Regular School No Middle 06 08 2021   grade_10                                                   0                                             0
2753078 CT     school   170011   Bristol School District 90051001661 170911 Greene-Hills GOAL Program           2021   grade_10                                                   0                                             0
2753083 CT     school   170011   Bristol School District 90051001515 179211 Community/Vocational Program Program           2021   grade_10                                                   0                                             0
2753084 CT     school 900540 180011   Brookfield School District 90054000110 180311 Center Elementary School Public Schools Regular School No Elementary PK 01 2021   grade_10                                                   0                                             0
2753085 CT     school 900540 180011   Brookfield School District 90054001186 180411 Huckleberry Hill Elementary School Public Schools Regular School No Elementary 02 04 2021   grade_10                                                   0                                             0
2753086 CT     school 900540 180011   Brookfield School District 90054000112 185311 Whisconier Middle School Public Schools Regular School No Middle 05 08 2021   grade_10                                                   0                                             0
2753088 CT     school 900570 190011   Brooklyn School District 90057000113 190111 Brooklyn Elementary School Public Schools Regular School No Elementary PK 04 2021   grade_10                                                   0                                             0
2753089 CT     school 900570 190011   Brooklyn School District 90057000114 195111 Brooklyn Middle School Public Schools Regular School No Middle 05 08 2021   grade_10                                                   0                                             0
2753090 CT     school 900660 220011   Canterbury School District 90066001188 220211 Canterbury Elementary School Public Schools Regular School No Elementary PK 04 2021   grade_10                                                   0                                             0
2753091 CT     school 900660 220011   Canterbury School District 90066001187 225111 Dr. Helen Baldwin Middle School Public Schools Regular School No Middle 05 08 2021   grade_10                                                   0                                             0
2753092 CT     school 900690 230011   Canton School District 90069000120 230211 Cherry Brook Primary School Public Schools Regular School No Elementary PK 03 2021   grade_10                                                   0                                             0
2753093 CT     school 900690 230011   Canton School District 90069000119 230311 Canton Intermediate School Public Schools Regular School No Elementary 04 06 2021   grade_10                                                   0                                             0
2753094 CT     school 900690 230011   Canton School District 90069001376 235111 Canton Middle School Public Schools Regular School No Middle 07 08 2021   grade_10                                                   0                                             0
2753096 CT     school 900700 2410014   Capitol Region Education Council 90070001629 2410714 Academy of Aerospace and Engineering Elementary Regional Education Service Center Schools Regular School No Elementary PK 05 2021   grade_10                                                   0                                             0
2753097 CT     school 900700 2410014   Capitol Region Education Council 90070001623 2410614 Ana Grace Academy of the Arts Elementary School Regional Education Service Center Schools Regular School No Elementary PK 05 2021   grade_10                                                   0                                             0
2753098 CT     school 900700 2410014   Capitol Region Education Council 90070001597 2418114 Discovery Academy Regional Education Service Center Schools Regular School No Elementary PK 05 2021   grade_10                                                   0                                             0
2753099 CT     school 900700 2410014   Capitol Region Education Council 90070000072 2410114 Glastonbury/East Hartford Magnet School Regional Education Service Center Schools Regular School No Elementary PK 05 2021   grade_10                                                   0                                             0
2753100 CT     school 900700 2410014   Capitol Region Education Council 90070001511 2410414 International Magnet School for Global Citizenship Regional Education Service Center Schools Regular School No Elementary PK 05 2021   grade_10                                                   0                                             0
2753101 CT     school 900700 2410014   Capitol Region Education Council 90070000210 2413114 Montessori Magnet School Regional Education Service Center Schools Regular School No Elementary PK 06 2021   grade_10                                                   0                                             0
2753102 CT     school 900700 2410014   Capitol Region Education Council 90070001601 2410514 Museum Academy Regional Education Service Center Schools Regular School No Elementary PK 05 2021   grade_10                                                   0                                             0
2753103 CT     school 900700 2410014   Capitol Region Education Council 90070001516 2410314 Reggio Magnet School of the Arts Regional Education Service Center Schools Regular School No Elementary PK 05 2021   grade_10                                                   0                                             0
2753105 CT     school   2410014   Capitol Region Education Council   2411414 River Street School Early Learning Center Program           2021   grade_10                                                   0                                             0
2753106 CT     school   2410014   Capitol Region Education Council 90070001492 2419114 Soundbridge Program           2021   grade_10                                                   0                                             0
2753107 CT     school 900700 2410014   Capitol Region Education Council 90070001357 2410214 University of Hartford Magnet School Regional Education Service Center Schools Regular School No Elementary PK 05 2021   grade_10                                                   0                                             0
2753112 CT     school 900700 2410014   Capitol Region Education Council 90070001625 2415314 Greater Hartford Academy of the Arts Magnet Middle Regional Education Service Center Schools Regular School No Middle 06 08 2021   grade_10                                                   0                                             0
2753114 CT     school 900700 2410014   Capitol Region Education Council 90070001364 2415014 Two Rivers Magnet Middle School Regional Education Service Center Schools Regular School No Middle 06 08 2021   grade_10                                                   0                                             0
2753119 CT     school   2410014   Capitol Region Education Council 90070001802 2419714 Strive (Southern Transition Real-World and Independent Vocational Education Program Program           2021   grade_10                                                   0                                             0
2753120 CT     school 900720 240011   Chaplin School District 90072000121 240211 Chaplin Elementary School Public Schools Regular School No Elementary PK 06 2021   grade_10                                                   0                                             0
2753121 CT     school 900750 250011   Cheshire School District 90075011188 250211 Darcey School Public Schools Regular School No Elementary PK KG 2021   grade_10                                                   0                                             0
2753122 CT     school 900750 250011   Cheshire School District 90075000127 250411 Highland School Public Schools Regular School No Elementary KG 06 2021   grade_10                                                   0                                             0
2753123 CT     school 900750 250011   Cheshire School District 90075000122 250111 Chapman School Public Schools Regular School No Elementary KG 06 2021   grade_10                                                   0                                             0

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