enrollments

Data source: Big Local News · About: Big Local

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

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2020 · 1,261 ✖

grade ✖

  • grade_7 · 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
2769159 2769159 CT     school   2430014   Cooperative Educational Services 90091001561 2439114 Preschool-Primary Learning Center (PLC) Program           2020   grade_7                                                   6                                             6
2769160 2769160 CT     school   2430014   Cooperative Educational Services 90091001520 2438014 School Readiness Program           2020   grade_7                                                   0                                             0
2769161 2769161 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_7                                                   37                                             37
2769162 2769162 CT     school   2430014   Cooperative Educational Services   2430314 Eastern Fairfield County Diagnostic Center Program           2020   grade_7                                                   0                                             0
2769163 2769163 CT     school   2430014   Cooperative Educational Services 90091001573 2439414 Therapeutic Day Program Program           2020   grade_7                                                   10                                             10
2769164 2769164 CT     school   2430014   Cooperative Educational Services 90091001554 2439214 Developmental Learning Center (DLC) Program           2020   grade_7                                                   0                                             0
2769165 2769165 CT     school   2430014   Cooperative Educational Services 90091001555 2439314 RISE Transitional Program Program           2020   grade_7                                                   0                                             0
2769166 2769166 CT     school   2430014   Cooperative Educational Services   2430214 Transition Learning Center Program           2020   grade_7                                                   0                                             0
2769167 2769167 CT     school   320011   Coventry School District   320311 Hale Early Education Center Program           2020   grade_7                                                   0                                             0
2769168 2769168 CT     school 900960 320011   Coventry School District 90096000142 320211 Coventry Grammar School Public Schools Regular School No Elementary KG 02 2020   grade_7                                                   0                                             0
2769169 2769169 CT     school 900960 320011   Coventry School District 90096000144 320411 George Hersey Robertson School Public Schools Regular School No Elementary 03 05 2020   grade_7                                                   0                                             0
2769170 2769170 CT     school 900960 320011   Coventry School District 90096000141 325111 Capt. Nathan Hale School Public Schools Regular School No Middle 06 08 2020   grade_7                                                   124                                             124
2769171 2769171 CT     school   320011   Coventry School District 90096001787 320111 Coventry Academy Public Schools           2020   grade_7                                                   0                                             0
2769172 2769172 CT     school 900960 320011   Coventry School District 90096000143 326111 Coventry High School Public Schools Regular School No High 09 12 2020   grade_7                                                   0                                             0
2769173 2769173 CT     school 900990 330011   Cromwell School District 90099000146 330211 Edna C. Stevens School Public Schools Regular School No Elementary PK 02 2020   grade_7                                                   0                                             0
2769174 2769174 CT     school 900990 330011   Cromwell School District 90099001432 330311 Woodside Intermediate School Public Schools Regular School No Elementary 03 05 2020   grade_7                                                   0                                             0
2769175 2769175 CT     school 900990 330011   Cromwell School District 90099000147 335111 Cromwell Middle School Public Schools Regular School No Middle 06 08 2020   grade_7                                                   157                                             157
2769176 2769176 CT     school 900990 330011   Cromwell School District 90099000145 336111 Cromwell High School Public Schools Regular School No High 09 12 2020   grade_7                                                   0                                             0
2769177 2769177 CT     school 901020 340011   Danbury School District 90102001634 340111 DPS Early Childhood Center Public Schools Regular School No Prekindergarten PK PK 2020   grade_7                                                   0                                             0
2769178 2769178 CT     school 901020 340011   Danbury School District 90102000151 341111 Great Plain School Public Schools Regular School No Elementary PK 05 2020   grade_7                                                   0                                             0
2769179 2769179 CT     school 901020 340011   Danbury School District 90102000152 340211 Hayestown Avenue School Public Schools Regular School No Elementary PK 05 2020   grade_7                                                   0                                             0
2769180 2769180 CT     school 901020 340011   Danbury School District 90102000159 341411 Ellsworth Avenue School Public Schools Regular School No Elementary KG 05 2020   grade_7                                                   0                                             0
2769181 2769181 CT     school 901020 340011   Danbury School District 90102000153 341311 King Street Primary School Public Schools Regular School No Elementary KG 03 2020   grade_7                                                   0                                             0
2769182 2769182 CT     school 901020 340011   Danbury School District 90102000154 340511 Mill Ridge Primary School Public Schools Regular School No Elementary KG 03 2020   grade_7                                                   0                                             0
2769183 2769183 CT     school 901020 340011   Danbury School District 90102000156 340611 Morris Street School Public Schools Regular School No Elementary KG 05 2020   grade_7                                                   0                                             0
2769184 2769184 CT     school 901020 340011   Danbury School District 90102000157 340811 Park Avenue School Public Schools Regular School No Elementary KG 05 2020   grade_7                                                   0                                             0
2769185 2769185 CT     school 901020 340011   Danbury School District 90102000158 341511 Pembroke School Public Schools Regular School No Elementary KG 05 2020   grade_7                                                   0                                             0
2769186 2769186 CT     school 901020 340011   Danbury School District 90102000161 341211 Shelter Rock School Public Schools Regular School No Elementary KG 05 2020   grade_7                                                   0                                             0
2769187 2769187 CT     school 901020 340011   Danbury School District 90102000162 341011 South Street School Public Schools Regular School No Elementary KG 05 2020   grade_7                                                   0                                             0
2769188 2769188 CT     school 901020 340011   Danbury School District 90102000163 341611 Stadley Rough School Public Schools Regular School No Elementary KG 05 2020   grade_7                                                   0                                             0
2769189 2769189 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_7                                                   0                                             0
2769190 2769190 CT     school 901020 340011   Danbury School District 90102001166 341711 King Street Intermediate School Public Schools Regular School No Elementary 04 05 2020   grade_7                                                   0                                             0
2769191 2769191 CT     school 901020 340011   Danbury School District 90102000149 345111 Broadview Middle School Public Schools Regular School No Middle 06 08 2020   grade_7                                                   326                                             326
2769192 2769192 CT     school 901020 340011   Danbury School District 90102000160 345211 Rogers Park Middle School Public Schools Regular School No Middle 06 08 2020   grade_7                                                   363                                             363
2769193 2769193 CT     school 901020 340011   Danbury School District 90102001691 340311 Westside Middle School Academy Public Schools Regular School No Middle 06 08 2020   grade_7                                                   246                                             246
2769194 2769194 CT     school   340011   Danbury School District 90102001129 346211 Alternative Center For Excellence Program           2020   grade_7                                                   0                                             0
2769195 2769195 CT     school 901020 340011   Danbury School District 90102000150 346111 Danbury High School Public Schools Regular School No High 09 12 2020   grade_7                                                   0                                             0
2769196 2769196 CT     school   340011   Danbury School District   340711 Western Connection Program           2020   grade_7                                                   0                                             0
2769197 2769197 CT     school 901050 350011   Darien School District 90105000165 350211 Hindley Elementary School Public Schools Regular School No Elementary PK 05 2020   grade_7                                                   0                                             0
2769198 2769198 CT     school 901050 350011   Darien School District 90105000498 350711 Holmes Elementary School Public Schools Regular School No Elementary PK 05 2020   grade_7                                                   0                                             0
2769199 2769199 CT     school 901050 350011   Darien School District 90105000170 351311 Ox Ridge Elementary School Public Schools Regular School No Elementary PK 05 2020   grade_7                                                   0                                             0
2769200 2769200 CT     school 901050 350011   Darien School District 90105000171 350511 Royle Elementary School Public Schools Regular School No Elementary PK 05 2020   grade_7                                                   0                                             0
2769201 2769201 CT     school 901050 350011   Darien School District 90105000172 350611 Tokeneke Elementary School Public Schools Regular School No Elementary PK 05 2020   grade_7                                                   0                                             0
2769202 2769202 CT     school 901050 350011   Darien School District 90105000169 355111 Middlesex Middle School Public Schools Regular School No Middle 06 08 2020   grade_7                                                   394                                             394
2769203 2769203 CT     school 901050 350011   Darien School District 90105000164 356111 Darien High School Public Schools Regular School No High 09 12 2020   grade_7                                                   0                                             0
2769204 2769204 CT     school 901110 370011   Derby School District 90111001806 370111 Little Raiders University Public Schools Regular School No Prekindergarten PK PK 2020   grade_7                                                   0                                             0
2769205 2769205 CT     school 901110 370011   Derby School District 90111000174 370611 Bradley School Public Schools Regular School No Elementary KG 05 2020   grade_7                                                   0                                             0
2769206 2769206 CT     school 901110 370011   Derby School District 90111000178 370411 Irving School Public Schools Regular School No Elementary KG 05 2020   grade_7                                                   0                                             0
2769207 2769207 CT     school 901110 370011   Derby School District 90111001578 375011 Derby Middle School Public Schools Regular School No Middle 06 08 2020   grade_7                                                   124                                             124
2769208 2769208 CT     school   370011   Derby School District   370511 RAISE Academy Program           2020   grade_7                                                   *                                              
2769209 2769209 CT     school   370011   Derby School District   370211 Alternative Education Program Program           2020   grade_7                                                   0                                             0
2769210 2769210 CT     school 901110 370011   Derby School District 90111000175 376111 Derby High School Public Schools Regular School No High 09 12 2020   grade_7                                                   0                                             0
2769211 2769211 CT     school 901170 400011   East Granby School District 90117000180 400111 Allgrove School Public Schools Regular School No Elementary PK 02 2020   grade_7                                                   0                                             0
2769212 2769212 CT     school 901170 400011   East Granby School District 90117000183 400211 R. Dudley Seymour School Public Schools Regular School No Elementary 03 05 2020   grade_7                                                   0                                             0
2769213 2769213 CT     school 901170 400011   East Granby School District 90117000182 405111 East Granby Middle School Public Schools Regular School No Middle 06 08 2020   grade_7                                                   67                                             67
2769214 2769214 CT     school 901170 400011   East Granby School District 90117000181 406111 East Granby High School Public Schools Regular School No High 09 12 2020   grade_7                                                   0                                             0
2769215 2769215 CT     school 901200 410011   East Haddam School District 90120000184 410111 East Haddam Elementary School Public Schools Regular School No Elementary PK 03 2020   grade_7                                                   0                                             0
2769216 2769216 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_7                                                   80                                             80
2769217 2769217 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_7                                                   0                                             0
2769218 2769218 CT     school 901230 420011   East Hampton School District 90123000189 420111 Memorial School Public Schools Regular School No Elementary PK 03 2020   grade_7                                                   0                                             0
2769219 2769219 CT     school 901230 420011   East Hampton School District 90123000186 420311 Center School Public Schools Regular School No Elementary 04 05 2020   grade_7                                                   0                                             0
2769220 2769220 CT     school 901230 420011   East Hampton School District 90123000188 425111 East Hampton Middle School Public Schools Regular School No Middle 06 08 2020   grade_7                                                   156                                             156
2769221 2769221 CT     school 901230 420011   East Hampton School District 90123000187 426111 East Hampton High School Public Schools Regular School No High 09 12 2020   grade_7                                                   0                                             0
2769222 2769222 CT     school   420011   East Hampton School District 90123001514 429011 The Learning Center at East Hampton Program           2020   grade_7                                                   0                                             0
2769223 2769223 CT     school   430011   East Hartford School District   430211 Early Childhood Learning Center at Hockanum School Program           2020   grade_7                                                   0                                             0
2769224 2769224 CT     school 901260 430011   East Hartford School District 90126000191 430911 Anna E. Norris School Public Schools Regular School No Elementary KG 05 2020   grade_7                                                   0                                             0
2769225 2769225 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_7                                                   0                                             0
2769226 2769226 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_7                                                   0                                             0
2769227 2769227 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_7                                                   0                                             0
2769228 2769228 CT     school 901260 430011   East Hartford School District 90126000201 432011 Governor William Pitkin School Public Schools Regular School No Elementary KG 05 2020   grade_7                                                   0                                             0
2769229 2769229 CT     school 901260 430011   East Hartford School District 90126000204 430411 Joseph O. Goodwin School Public Schools Regular School No Elementary KG 05 2020   grade_7                                                   0                                             0
2769230 2769230 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_7                                                   0                                             0
2769231 2769231 CT     school 901260 430011   East Hartford School District 90126000208 431211 Silver Lane School Public Schools Regular School No Elementary KG 05 2020   grade_7                                                   0                                             0
2769232 2769232 CT     school   430011   East Hartford School District 90126000205 439011 Woodland School Program           2020   grade_7                                                   22                                             22
2769233 2769233 CT     school 901260 430011   East Hartford School District 90126000197 435111 East Hartford Middle School Public Schools Regular School No Middle 06 08 2020   grade_7                                                   380                                             380
2769234 2769234 CT     school 901260 430011   East Hartford School District 90126001275 432411 Sunset Ridge Middle School Public Schools Regular School No Middle 06 08 2020   grade_7                                                   115                                             115
2769235 2769235 CT     school 901260 430011   East Hartford School District 90126001477 436311 Connecticut IB Academy Public Schools Regular School No High 09 12 2020   grade_7                                                   0                                             0
2769236 2769236 CT     school 901260 430011   East Hartford School District 90126000200 436211 East Hartford High School Public Schools Regular School No High 09 12 2020   grade_7                                                   0                                             0
2769237 2769237 CT     school   430011   East Hartford School District 90126001377 436411 Synergy Alternative Program Program           2020   grade_7                                                   0                                             0
2769238 2769238 CT     school 901290 440011   East Haven School District 90129000214 440111 Deer Run School Public Schools Regular School No Elementary PK 02 2020   grade_7                                                   0                                             0
2769239 2769239 CT     school 901290 440011   East Haven School District 90129001350 441811 Overbrook Early Learning Center Public Schools Regular School No Elementary PK KG 2020   grade_7                                                   0                                             0
2769240 2769240 CT     school 901290 440011   East Haven School District 90129000218 441011 Grove J. Tuttle School Public Schools Regular School No Elementary KG 05 2020   grade_7                                                   0                                             0
2769241 2769241 CT     school 901290 440011   East Haven School District 90129000219 440711 Momauguin School Public Schools Regular School No Elementary KG 05 2020   grade_7                                                   0                                             0
2769242 2769242 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_7                                                   36                                             36
2769243 2769243 CT     school 901290 440011   East Haven School District 90129000215 441311 Dominick H. Ferrara School Public Schools Regular School No Elementary 03 05 2020   grade_7                                                   0                                             0
2769244 2769244 CT     school 901290 440011   East Haven School District 90129000217 445111 Joseph Melillo Middle School Public Schools Regular School No Middle 06 08 2020   grade_7                                                   164                                             164
2769245 2769245 CT     school 901290 440011   East Haven School District 90129000216 446111 East Haven High School Public Schools Regular School No High 09 12 2020   grade_7                                                   0                                             0
2769246 2769246 CT     school   450011   East Lyme School District 90132001450 458011 Integrated Preschool Program           2020   grade_7                                                   0                                             0
2769247 2769247 CT     school 901320 450011   East Lyme School District 90132000225 450111 Flanders School Public Schools Regular School No Elementary KG 04 2020   grade_7                                                   0                                             0
2769248 2769248 CT     school 901320 450011   East Lyme School District 90132000226 450411 Lillie B. Haynes School Public Schools Regular School No Elementary KG 04 2020   grade_7                                                   0                                             0
2769249 2769249 CT     school 901320 450011   East Lyme School District 90132000227 450211 Niantic Center School Public Schools Regular School No Elementary KG 04 2020   grade_7                                                   0                                             0
2769250 2769250 CT     school 901320 450011   East Lyme School District 90132000224 455111 East Lyme Middle School Public Schools Regular School No Middle 05 08 2020   grade_7                                                   185                                             185
2769251 2769251 CT     school   450011   East Lyme School District 90132001760 450611 Coastal Connections Program           2020   grade_7                                                   0                                             0
2769252 2769252 CT     school 901320 450011   East Lyme School District 90132000223 456111 East Lyme High School Public Schools Regular School No High 09 12 2020   grade_7                                                   0                                             0
2769253 2769253 CT     school   450011   East Lyme School District 90132001730 450511 Abilities in Motion (AIM) Program Program           2020   grade_7                                                   0                                             0
2769254 2769254 CT     school 901350 470011   East Windsor School District 90135000228 470111 Broad Brook Elementary School Public Schools Regular School No Elementary PK 04 2020   grade_7                                                   0                                             0
2769255 2769255 CT     school 901350 470011   East Windsor School District 90135000230 475411 East Windsor Middle School Public Schools Regular School No Middle 05 08 2020   grade_7                                                   85                                             85
2769256 2769256 CT     school 901350 470011   East Windsor School District 90135000229 476111 East Windsor High School Public Schools Regular School No High 09 12 2020   grade_7                                                   0                                             0
2769257 2769257 CT     school   470011   East Windsor School District   470411 East Windsor Transition Program Program           2020   grade_7                                                   0                                             0
2769258 2769258 CT     school 901380 390011   Eastford School District 90138000232 390111 Eastford Elementary School Public Schools Regular School No Elementary PK 08 2020   grade_7                                                   16                                             16

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