enrollments

Data source: Big Local News · About: Big Local

1,461 rows where grade = "grade_11", state = "CT" and year = 2020

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2020 · 1,261 ✖

grade ✖

  • grade_11 · 1,261 ✖
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
2775003 2775003 CT     school   2430014   Cooperative Educational Services 90091001561 2439114 Preschool-Primary Learning Center (PLC) Program           2020   grade_11                                                   0                                             0
2775004 2775004 CT     school   2430014   Cooperative Educational Services 90091001520 2438014 School Readiness Program           2020   grade_11                                                   0                                             0
2775005 2775005 CT     school 900910 2430014   Cooperative Educational Services 90091000340 2430114 Six-Six Magnet School Regional Education Service Center Schools Regular School No Elementary PK 08 2020   grade_11                                                   0                                             0
2775006 2775006 CT     school   2430014   Cooperative Educational Services   2430314 Eastern Fairfield County Diagnostic Center Program           2020   grade_11                                                   0                                             0
2775007 2775007 CT     school   2430014   Cooperative Educational Services 90091001573 2439414 Therapeutic Day Program Program           2020   grade_11                                                   16                                             16
2775008 2775008 CT     school   2430014   Cooperative Educational Services 90091001554 2439214 Developmental Learning Center (DLC) Program           2020   grade_11                                                   13                                             13
2775009 2775009 CT     school   2430014   Cooperative Educational Services 90091001555 2439314 RISE Transitional Program Program           2020   grade_11                                                   0                                             0
2775010 2775010 CT     school   2430014   Cooperative Educational Services   2430214 Transition Learning Center Program           2020   grade_11                                                   0                                             0
2775011 2775011 CT     school   320011   Coventry School District   320311 Hale Early Education Center Program           2020   grade_11                                                   0                                             0
2775012 2775012 CT     school 900960 320011   Coventry School District 90096000142 320211 Coventry Grammar School Public Schools Regular School No Elementary KG 02 2020   grade_11                                                   0                                             0
2775013 2775013 CT     school 900960 320011   Coventry School District 90096000144 320411 George Hersey Robertson School Public Schools Regular School No Elementary 03 05 2020   grade_11                                                   0                                             0
2775014 2775014 CT     school 900960 320011   Coventry School District 90096000141 325111 Capt. Nathan Hale School Public Schools Regular School No Middle 06 08 2020   grade_11                                                   0                                             0
2775015 2775015 CT     school   320011   Coventry School District 90096001787 320111 Coventry Academy Public Schools           2020   grade_11                                                   *                                              
2775016 2775016 CT     school 900960 320011   Coventry School District 90096000143 326111 Coventry High School Public Schools Regular School No High 09 12 2020   grade_11                                                   115                                             115
2775017 2775017 CT     school 900990 330011   Cromwell School District 90099000146 330211 Edna C. Stevens School Public Schools Regular School No Elementary PK 02 2020   grade_11                                                   0                                             0
2775018 2775018 CT     school 900990 330011   Cromwell School District 90099001432 330311 Woodside Intermediate School Public Schools Regular School No Elementary 03 05 2020   grade_11                                                   0                                             0
2775019 2775019 CT     school 900990 330011   Cromwell School District 90099000147 335111 Cromwell Middle School Public Schools Regular School No Middle 06 08 2020   grade_11                                                   0                                             0
2775020 2775020 CT     school 900990 330011   Cromwell School District 90099000145 336111 Cromwell High School Public Schools Regular School No High 09 12 2020   grade_11                                                   144                                             144
2775021 2775021 CT     school 901020 340011   Danbury School District 90102001634 340111 DPS Early Childhood Center Public Schools Regular School No Prekindergarten PK PK 2020   grade_11                                                   0                                             0
2775022 2775022 CT     school 901020 340011   Danbury School District 90102000151 341111 Great Plain School Public Schools Regular School No Elementary PK 05 2020   grade_11                                                   0                                             0
2775023 2775023 CT     school 901020 340011   Danbury School District 90102000152 340211 Hayestown Avenue School Public Schools Regular School No Elementary PK 05 2020   grade_11                                                   0                                             0
2775024 2775024 CT     school 901020 340011   Danbury School District 90102000159 341411 Ellsworth Avenue School Public Schools Regular School No Elementary KG 05 2020   grade_11                                                   0                                             0
2775025 2775025 CT     school 901020 340011   Danbury School District 90102000153 341311 King Street Primary School Public Schools Regular School No Elementary KG 03 2020   grade_11                                                   0                                             0
2775026 2775026 CT     school 901020 340011   Danbury School District 90102000154 340511 Mill Ridge Primary School Public Schools Regular School No Elementary KG 03 2020   grade_11                                                   0                                             0
2775027 2775027 CT     school 901020 340011   Danbury School District 90102000156 340611 Morris Street School Public Schools Regular School No Elementary KG 05 2020   grade_11                                                   0                                             0
2775028 2775028 CT     school 901020 340011   Danbury School District 90102000157 340811 Park Avenue School Public Schools Regular School No Elementary KG 05 2020   grade_11                                                   0                                             0
2775029 2775029 CT     school 901020 340011   Danbury School District 90102000158 341511 Pembroke School Public Schools Regular School No Elementary KG 05 2020   grade_11                                                   0                                             0
2775030 2775030 CT     school 901020 340011   Danbury School District 90102000161 341211 Shelter Rock School Public Schools Regular School No Elementary KG 05 2020   grade_11                                                   0                                             0
2775031 2775031 CT     school 901020 340011   Danbury School District 90102000162 341011 South Street School Public Schools Regular School No Elementary KG 05 2020   grade_11                                                   0                                             0
2775032 2775032 CT     school 901020 340011   Danbury School District 90102000163 341611 Stadley Rough School Public Schools Regular School No Elementary KG 05 2020   grade_11                                                   0                                             0
2775033 2775033 CT     school 901020 340011   Danbury School District 90102001438 341911 Western CT Academy of International Studies Elementary Magnet School Public Schools Regular School No Elementary KG 05 2020   grade_11                                                   0                                             0
2775034 2775034 CT     school 901020 340011   Danbury School District 90102001166 341711 King Street Intermediate School Public Schools Regular School No Elementary 04 05 2020   grade_11                                                   0                                             0
2775035 2775035 CT     school 901020 340011   Danbury School District 90102000149 345111 Broadview Middle School Public Schools Regular School No Middle 06 08 2020   grade_11                                                   0                                             0
2775036 2775036 CT     school 901020 340011   Danbury School District 90102000160 345211 Rogers Park Middle School Public Schools Regular School No Middle 06 08 2020   grade_11                                                   0                                             0
2775037 2775037 CT     school 901020 340011   Danbury School District 90102001691 340311 Westside Middle School Academy Public Schools Regular School No Middle 06 08 2020   grade_11                                                   0                                             0
2775038 2775038 CT     school   340011   Danbury School District 90102001129 346211 Alternative Center For Excellence Program           2020   grade_11                                                   17                                             17
2775039 2775039 CT     school 901020 340011   Danbury School District 90102000150 346111 Danbury High School Public Schools Regular School No High 09 12 2020   grade_11                                                   827                                             827
2775040 2775040 CT     school   340011   Danbury School District   340711 Western Connection Program           2020   grade_11                                                   0                                             0
2775041 2775041 CT     school 901050 350011   Darien School District 90105000165 350211 Hindley Elementary School Public Schools Regular School No Elementary PK 05 2020   grade_11                                                   0                                             0
2775042 2775042 CT     school 901050 350011   Darien School District 90105000498 350711 Holmes Elementary School Public Schools Regular School No Elementary PK 05 2020   grade_11                                                   0                                             0
2775043 2775043 CT     school 901050 350011   Darien School District 90105000170 351311 Ox Ridge Elementary School Public Schools Regular School No Elementary PK 05 2020   grade_11                                                   0                                             0
2775044 2775044 CT     school 901050 350011   Darien School District 90105000171 350511 Royle Elementary School Public Schools Regular School No Elementary PK 05 2020   grade_11                                                   0                                             0
2775045 2775045 CT     school 901050 350011   Darien School District 90105000172 350611 Tokeneke Elementary School Public Schools Regular School No Elementary PK 05 2020   grade_11                                                   0                                             0
2775046 2775046 CT     school 901050 350011   Darien School District 90105000169 355111 Middlesex Middle School Public Schools Regular School No Middle 06 08 2020   grade_11                                                   0                                             0
2775047 2775047 CT     school 901050 350011   Darien School District 90105000164 356111 Darien High School Public Schools Regular School No High 09 12 2020   grade_11                                                   321                                             321
2775048 2775048 CT     school 901110 370011   Derby School District 90111001806 370111 Little Raiders University Public Schools Regular School No Prekindergarten PK PK 2020   grade_11                                                   0                                             0
2775049 2775049 CT     school 901110 370011   Derby School District 90111000174 370611 Bradley School Public Schools Regular School No Elementary KG 05 2020   grade_11                                                   0                                             0
2775050 2775050 CT     school 901110 370011   Derby School District 90111000178 370411 Irving School Public Schools Regular School No Elementary KG 05 2020   grade_11                                                   0                                             0
2775051 2775051 CT     school 901110 370011   Derby School District 90111001578 375011 Derby Middle School Public Schools Regular School No Middle 06 08 2020   grade_11                                                   0                                             0
2775052 2775052 CT     school   370011   Derby School District   370511 RAISE Academy Program           2020   grade_11                                                   *                                              
2775053 2775053 CT     school   370011   Derby School District   370211 Alternative Education Program Program           2020   grade_11                                                   *                                              
2775054 2775054 CT     school 901110 370011   Derby School District 90111000175 376111 Derby High School Public Schools Regular School No High 09 12 2020   grade_11                                                   92                                             92
2775055 2775055 CT     school 901170 400011   East Granby School District 90117000180 400111 Allgrove School Public Schools Regular School No Elementary PK 02 2020   grade_11                                                   0                                             0
2775056 2775056 CT     school 901170 400011   East Granby School District 90117000183 400211 R. Dudley Seymour School Public Schools Regular School No Elementary 03 05 2020   grade_11                                                   0                                             0
2775057 2775057 CT     school 901170 400011   East Granby School District 90117000182 405111 East Granby Middle School Public Schools Regular School No Middle 06 08 2020   grade_11                                                   0                                             0
2775058 2775058 CT     school 901170 400011   East Granby School District 90117000181 406111 East Granby High School Public Schools Regular School No High 09 12 2020   grade_11                                                   67                                             67
2775059 2775059 CT     school 901200 410011   East Haddam School District 90120000184 410111 East Haddam Elementary School Public Schools Regular School No Elementary PK 03 2020   grade_11                                                   0                                             0
2775060 2775060 CT     school 901200 410011   East Haddam School District 90120000198 415111 Nathan Hale-Ray Middle School Public Schools Regular School No Middle 04 08 2020   grade_11                                                   0                                             0
2775061 2775061 CT     school 901200 410011   East Haddam School District 90120000185 416111 Nathan Hale-Ray High School Public Schools Regular School No High 09 12 2020   grade_11                                                   90                                             90
2775062 2775062 CT     school 901230 420011   East Hampton School District 90123000189 420111 Memorial School Public Schools Regular School No Elementary PK 03 2020   grade_11                                                   0                                             0
2775063 2775063 CT     school 901230 420011   East Hampton School District 90123000186 420311 Center School Public Schools Regular School No Elementary 04 05 2020   grade_11                                                   0                                             0
2775064 2775064 CT     school 901230 420011   East Hampton School District 90123000188 425111 East Hampton Middle School Public Schools Regular School No Middle 06 08 2020   grade_11                                                   0                                             0
2775065 2775065 CT     school 901230 420011   East Hampton School District 90123000187 426111 East Hampton High School Public Schools Regular School No High 09 12 2020   grade_11                                                   127                                             127
2775066 2775066 CT     school   420011   East Hampton School District 90123001514 429011 The Learning Center at East Hampton Program           2020   grade_11                                                   *                                              
2775067 2775067 CT     school   430011   East Hartford School District   430211 Early Childhood Learning Center at Hockanum School Program           2020   grade_11                                                   0                                             0
2775068 2775068 CT     school 901260 430011   East Hartford School District 90126000191 430911 Anna E. Norris School Public Schools Regular School No Elementary KG 05 2020   grade_11                                                   0                                             0
2775069 2775069 CT     school 901260 430011   East Hartford School District 90126000194 430611 Dr. Franklin H. Mayberry School Public Schools Regular School No Elementary KG 05 2020   grade_11                                                   0                                             0
2775070 2775070 CT     school 901260 430011   East Hartford School District 90126000195 432211 Dr. John A. Langford School Public Schools Regular School No Elementary KG 05 2020   grade_11                                                   0                                             0
2775071 2775071 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_11                                                   0                                             0
2775072 2775072 CT     school 901260 430011   East Hartford School District 90126000201 432011 Governor William Pitkin School Public Schools Regular School No Elementary KG 05 2020   grade_11                                                   0                                             0
2775073 2775073 CT     school 901260 430011   East Hartford School District 90126000204 430411 Joseph O. Goodwin School Public Schools Regular School No Elementary KG 05 2020   grade_11                                                   0                                             0
2775074 2775074 CT     school 901260 430011   East Hartford School District 90126000206 431811 Robert J. O'Brien School Public Schools Regular School No Elementary KG 05 2020   grade_11                                                   0                                             0
2775075 2775075 CT     school 901260 430011   East Hartford School District 90126000208 431211 Silver Lane School Public Schools Regular School No Elementary KG 05 2020   grade_11                                                   0                                             0
2775076 2775076 CT     school   430011   East Hartford School District 90126000205 439011 Woodland School Program           2020   grade_11                                                   29                                             29
2775077 2775077 CT     school 901260 430011   East Hartford School District 90126000197 435111 East Hartford Middle School Public Schools Regular School No Middle 06 08 2020   grade_11                                                   0                                             0
2775078 2775078 CT     school 901260 430011   East Hartford School District 90126001275 432411 Sunset Ridge Middle School Public Schools Regular School No Middle 06 08 2020   grade_11                                                   0                                             0
2775079 2775079 CT     school 901260 430011   East Hartford School District 90126001477 436311 Connecticut IB Academy Public Schools Regular School No High 09 12 2020   grade_11                                                   42                                             42
2775080 2775080 CT     school 901260 430011   East Hartford School District 90126000200 436211 East Hartford High School Public Schools Regular School No High 09 12 2020   grade_11                                                   455                                             455
2775081 2775081 CT     school   430011   East Hartford School District 90126001377 436411 Synergy Alternative Program Program           2020   grade_11                                                   31                                             31
2775082 2775082 CT     school 901290 440011   East Haven School District 90129000214 440111 Deer Run School Public Schools Regular School No Elementary PK 02 2020   grade_11                                                   0                                             0
2775083 2775083 CT     school 901290 440011   East Haven School District 90129001350 441811 Overbrook Early Learning Center Public Schools Regular School No Elementary PK KG 2020   grade_11                                                   0                                             0
2775084 2775084 CT     school 901290 440011   East Haven School District 90129000218 441011 Grove J. Tuttle School Public Schools Regular School No Elementary KG 05 2020   grade_11                                                   0                                             0
2775085 2775085 CT     school 901290 440011   East Haven School District 90129000219 440711 Momauguin School Public Schools Regular School No Elementary KG 05 2020   grade_11                                                   0                                             0
2775086 2775086 CT     school 901290 440011   East Haven School District 90129000605 441711 Carbone School/East Haven Academy Public Schools Regular School No Elementary 01 08 2020   grade_11                                                   0                                             0
2775087 2775087 CT     school 901290 440011   East Haven School District 90129000215 441311 Dominick H. Ferrara School Public Schools Regular School No Elementary 03 05 2020   grade_11                                                   0                                             0
2775088 2775088 CT     school 901290 440011   East Haven School District 90129000217 445111 Joseph Melillo Middle School Public Schools Regular School No Middle 06 08 2020   grade_11                                                   0                                             0
2775089 2775089 CT     school 901290 440011   East Haven School District 90129000216 446111 East Haven High School Public Schools Regular School No High 09 12 2020   grade_11                                                   226                                             226
2775090 2775090 CT     school   450011   East Lyme School District 90132001450 458011 Integrated Preschool Program           2020   grade_11                                                   0                                             0
2775091 2775091 CT     school 901320 450011   East Lyme School District 90132000225 450111 Flanders School Public Schools Regular School No Elementary KG 04 2020   grade_11                                                   0                                             0
2775092 2775092 CT     school 901320 450011   East Lyme School District 90132000226 450411 Lillie B. Haynes School Public Schools Regular School No Elementary KG 04 2020   grade_11                                                   0                                             0
2775093 2775093 CT     school 901320 450011   East Lyme School District 90132000227 450211 Niantic Center School Public Schools Regular School No Elementary KG 04 2020   grade_11                                                   0                                             0
2775094 2775094 CT     school 901320 450011   East Lyme School District 90132000224 455111 East Lyme Middle School Public Schools Regular School No Middle 05 08 2020   grade_11                                                   0                                             0
2775095 2775095 CT     school   450011   East Lyme School District 90132001760 450611 Coastal Connections Program           2020   grade_11                                                   6                                             6
2775096 2775096 CT     school 901320 450011   East Lyme School District 90132000223 456111 East Lyme High School Public Schools Regular School No High 09 12 2020   grade_11                                                   261                                             261
2775097 2775097 CT     school   450011   East Lyme School District 90132001730 450511 Abilities in Motion (AIM) Program Program           2020   grade_11                                                   0                                             0
2775098 2775098 CT     school 901350 470011   East Windsor School District 90135000228 470111 Broad Brook Elementary School Public Schools Regular School No Elementary PK 04 2020   grade_11                                                   0                                             0
2775099 2775099 CT     school 901350 470011   East Windsor School District 90135000230 475411 East Windsor Middle School Public Schools Regular School No Middle 05 08 2020   grade_11                                                   0                                             0
2775100 2775100 CT     school 901350 470011   East Windsor School District 90135000229 476111 East Windsor High School Public Schools Regular School No High 09 12 2020   grade_11                                                   57                                             57
2775101 2775101 CT     school   470011   East Windsor School District   470411 East Windsor Transition Program Program           2020   grade_11                                                   0                                             0
2775102 2775102 CT     school 901380 390011   Eastford School District 90138000232 390111 Eastford Elementary School Public Schools Regular School No Elementary PK 08 2020   grade_11                                                   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]);