Data source: Big Local News · About: Big Local

1,461 rows where grade = "grade_12", state = "CT" and year = 2020 sorted by grade

View and edit SQL

year

  • 2020 · 1,261

grade

  • grade_12 · 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
2776464 CT     school   2430014   Cooperative Educational Services 90091001561 2439114 Preschool-Primary Learning Center (PLC) Program           2020   grade_12                                                   0                                             0
2776465 CT     school   2430014   Cooperative Educational Services 90091001520 2438014 School Readiness Program           2020   grade_12                                                   0                                             0
2776466 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_12                                                   0                                             0
2776467 CT     school   2430014   Cooperative Educational Services   2430314 Eastern Fairfield County Diagnostic Center Program           2020   grade_12                                                   0                                             0
2776468 CT     school   2430014   Cooperative Educational Services 90091001573 2439414 Therapeutic Day Program Program           2020   grade_12                                                   17                                             17
2776469 CT     school   2430014   Cooperative Educational Services 90091001554 2439214 Developmental Learning Center (DLC) Program           2020   grade_12                                                   *                                              
2776470 CT     school   2430014   Cooperative Educational Services 90091001555 2439314 RISE Transitional Program Program           2020   grade_12                                                   12                                             12
2776471 CT     school   2430014   Cooperative Educational Services   2430214 Transition Learning Center Program           2020   grade_12                                                   33                                             33
2776472 CT     school   320011   Coventry School District   320311 Hale Early Education Center Program           2020   grade_12                                                   0                                             0
2776473 CT     school 900960 320011   Coventry School District 90096000142 320211 Coventry Grammar School Public Schools Regular School No Elementary KG 02 2020   grade_12                                                   0                                             0
2776474 CT     school 900960 320011   Coventry School District 90096000144 320411 George Hersey Robertson School Public Schools Regular School No Elementary 03 05 2020   grade_12                                                   0                                             0
2776475 CT     school 900960 320011   Coventry School District 90096000141 325111 Capt. Nathan Hale School Public Schools Regular School No Middle 06 08 2020   grade_12                                                   0                                             0
2776476 CT     school   320011   Coventry School District 90096001787 320111 Coventry Academy Public Schools           2020   grade_12                                                   8                                             8
2776477 CT     school 900960 320011   Coventry School District 90096000143 326111 Coventry High School Public Schools Regular School No High 09 12 2020   grade_12                                                   124                                             124
2776478 CT     school 900990 330011   Cromwell School District 90099000146 330211 Edna C. Stevens School Public Schools Regular School No Elementary PK 02 2020   grade_12                                                   0                                             0
2776479 CT     school 900990 330011   Cromwell School District 90099001432 330311 Woodside Intermediate School Public Schools Regular School No Elementary 03 05 2020   grade_12                                                   0                                             0
2776480 CT     school 900990 330011   Cromwell School District 90099000147 335111 Cromwell Middle School Public Schools Regular School No Middle 06 08 2020   grade_12                                                   0                                             0
2776481 CT     school 900990 330011   Cromwell School District 90099000145 336111 Cromwell High School Public Schools Regular School No High 09 12 2020   grade_12                                                   123                                             123
2776482 CT     school 901020 340011   Danbury School District 90102001634 340111 DPS Early Childhood Center Public Schools Regular School No Prekindergarten PK PK 2020   grade_12                                                   0                                             0
2776483 CT     school 901020 340011   Danbury School District 90102000151 341111 Great Plain School Public Schools Regular School No Elementary PK 05 2020   grade_12                                                   0                                             0
2776484 CT     school 901020 340011   Danbury School District 90102000152 340211 Hayestown Avenue School Public Schools Regular School No Elementary PK 05 2020   grade_12                                                   0                                             0
2776485 CT     school 901020 340011   Danbury School District 90102000159 341411 Ellsworth Avenue School Public Schools Regular School No Elementary KG 05 2020   grade_12                                                   0                                             0
2776486 CT     school 901020 340011   Danbury School District 90102000153 341311 King Street Primary School Public Schools Regular School No Elementary KG 03 2020   grade_12                                                   0                                             0
2776487 CT     school 901020 340011   Danbury School District 90102000154 340511 Mill Ridge Primary School Public Schools Regular School No Elementary KG 03 2020   grade_12                                                   0                                             0
2776488 CT     school 901020 340011   Danbury School District 90102000156 340611 Morris Street School Public Schools Regular School No Elementary KG 05 2020   grade_12                                                   0                                             0
2776489 CT     school 901020 340011   Danbury School District 90102000157 340811 Park Avenue School Public Schools Regular School No Elementary KG 05 2020   grade_12                                                   0                                             0
2776490 CT     school 901020 340011   Danbury School District 90102000158 341511 Pembroke School Public Schools Regular School No Elementary KG 05 2020   grade_12                                                   0                                             0
2776491 CT     school 901020 340011   Danbury School District 90102000161 341211 Shelter Rock School Public Schools Regular School No Elementary KG 05 2020   grade_12                                                   0                                             0
2776492 CT     school 901020 340011   Danbury School District 90102000162 341011 South Street School Public Schools Regular School No Elementary KG 05 2020   grade_12                                                   0                                             0
2776493 CT     school 901020 340011   Danbury School District 90102000163 341611 Stadley Rough School Public Schools Regular School No Elementary KG 05 2020   grade_12                                                   0                                             0
2776494 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_12                                                   0                                             0
2776495 CT     school 901020 340011   Danbury School District 90102001166 341711 King Street Intermediate School Public Schools Regular School No Elementary 04 05 2020   grade_12                                                   0                                             0
2776496 CT     school 901020 340011   Danbury School District 90102000149 345111 Broadview Middle School Public Schools Regular School No Middle 06 08 2020   grade_12                                                   0                                             0
2776497 CT     school 901020 340011   Danbury School District 90102000160 345211 Rogers Park Middle School Public Schools Regular School No Middle 06 08 2020   grade_12                                                   0                                             0
2776498 CT     school 901020 340011   Danbury School District 90102001691 340311 Westside Middle School Academy Public Schools Regular School No Middle 06 08 2020   grade_12                                                   0                                             0
2776499 CT     school   340011   Danbury School District 90102001129 346211 Alternative Center For Excellence Program           2020   grade_12                                                   24                                             24
2776500 CT     school 901020 340011   Danbury School District 90102000150 346111 Danbury High School Public Schools Regular School No High 09 12 2020   grade_12                                                   745                                             745
2776501 CT     school   340011   Danbury School District   340711 Western Connection Program           2020   grade_12                                                   11                                             11
2776502 CT     school 901050 350011   Darien School District 90105000165 350211 Hindley Elementary School Public Schools Regular School No Elementary PK 05 2020   grade_12                                                   0                                             0
2776503 CT     school 901050 350011   Darien School District 90105000498 350711 Holmes Elementary School Public Schools Regular School No Elementary PK 05 2020   grade_12                                                   0                                             0
2776504 CT     school 901050 350011   Darien School District 90105000170 351311 Ox Ridge Elementary School Public Schools Regular School No Elementary PK 05 2020   grade_12                                                   0                                             0
2776505 CT     school 901050 350011   Darien School District 90105000171 350511 Royle Elementary School Public Schools Regular School No Elementary PK 05 2020   grade_12                                                   0                                             0
2776506 CT     school 901050 350011   Darien School District 90105000172 350611 Tokeneke Elementary School Public Schools Regular School No Elementary PK 05 2020   grade_12                                                   0                                             0
2776507 CT     school 901050 350011   Darien School District 90105000169 355111 Middlesex Middle School Public Schools Regular School No Middle 06 08 2020   grade_12                                                   0                                             0
2776508 CT     school 901050 350011   Darien School District 90105000164 356111 Darien High School Public Schools Regular School No High 09 12 2020   grade_12                                                   359                                             359
2776509 CT     school 901110 370011   Derby School District 90111001806 370111 Little Raiders University Public Schools Regular School No Prekindergarten PK PK 2020   grade_12                                                   0                                             0
2776510 CT     school 901110 370011   Derby School District 90111000174 370611 Bradley School Public Schools Regular School No Elementary KG 05 2020   grade_12                                                   0                                             0
2776511 CT     school 901110 370011   Derby School District 90111000178 370411 Irving School Public Schools Regular School No Elementary KG 05 2020   grade_12                                                   0                                             0
2776512 CT     school 901110 370011   Derby School District 90111001578 375011 Derby Middle School Public Schools Regular School No Middle 06 08 2020   grade_12                                                   0                                             0
2776513 CT     school   370011   Derby School District   370511 RAISE Academy Program           2020   grade_12                                                   *                                              
2776514 CT     school   370011   Derby School District   370211 Alternative Education Program Program           2020   grade_12                                                   0                                             0
2776515 CT     school 901110 370011   Derby School District 90111000175 376111 Derby High School Public Schools Regular School No High 09 12 2020   grade_12                                                   71                                             71
2776516 CT     school 901170 400011   East Granby School District 90117000180 400111 Allgrove School Public Schools Regular School No Elementary PK 02 2020   grade_12                                                   0                                             0
2776517 CT     school 901170 400011   East Granby School District 90117000183 400211 R. Dudley Seymour School Public Schools Regular School No Elementary 03 05 2020   grade_12                                                   0                                             0
2776518 CT     school 901170 400011   East Granby School District 90117000182 405111 East Granby Middle School Public Schools Regular School No Middle 06 08 2020   grade_12                                                   0                                             0
2776519 CT     school 901170 400011   East Granby School District 90117000181 406111 East Granby High School Public Schools Regular School No High 09 12 2020   grade_12                                                   54                                             54
2776520 CT     school 901200 410011   East Haddam School District 90120000184 410111 East Haddam Elementary School Public Schools Regular School No Elementary PK 03 2020   grade_12                                                   0                                             0
2776521 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_12                                                   0                                             0
2776522 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_12                                                   76                                             76
2776523 CT     school 901230 420011   East Hampton School District 90123000189 420111 Memorial School Public Schools Regular School No Elementary PK 03 2020   grade_12                                                   0                                             0
2776524 CT     school 901230 420011   East Hampton School District 90123000186 420311 Center School Public Schools Regular School No Elementary 04 05 2020   grade_12                                                   0                                             0
2776525 CT     school 901230 420011   East Hampton School District 90123000188 425111 East Hampton Middle School Public Schools Regular School No Middle 06 08 2020   grade_12                                                   0                                             0
2776526 CT     school 901230 420011   East Hampton School District 90123000187 426111 East Hampton High School Public Schools Regular School No High 09 12 2020   grade_12                                                   116                                             116
2776527 CT     school   420011   East Hampton School District 90123001514 429011 The Learning Center at East Hampton Program           2020   grade_12                                                   *                                              
2776528 CT     school   430011   East Hartford School District   430211 Early Childhood Learning Center at Hockanum School Program           2020   grade_12                                                   0                                             0
2776529 CT     school 901260 430011   East Hartford School District 90126000191 430911 Anna E. Norris School Public Schools Regular School No Elementary KG 05 2020   grade_12                                                   0                                             0
2776530 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_12                                                   0                                             0
2776531 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_12                                                   0                                             0
2776532 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_12                                                   0                                             0
2776533 CT     school 901260 430011   East Hartford School District 90126000201 432011 Governor William Pitkin School Public Schools Regular School No Elementary KG 05 2020   grade_12                                                   0                                             0
2776534 CT     school 901260 430011   East Hartford School District 90126000204 430411 Joseph O. Goodwin School Public Schools Regular School No Elementary KG 05 2020   grade_12                                                   0                                             0
2776535 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_12                                                   0                                             0
2776536 CT     school 901260 430011   East Hartford School District 90126000208 431211 Silver Lane School Public Schools Regular School No Elementary KG 05 2020   grade_12                                                   0                                             0
2776537 CT     school   430011   East Hartford School District 90126000205 439011 Woodland School Program           2020   grade_12                                                   33                                             33
2776538 CT     school 901260 430011   East Hartford School District 90126000197 435111 East Hartford Middle School Public Schools Regular School No Middle 06 08 2020   grade_12                                                   0                                             0
2776539 CT     school 901260 430011   East Hartford School District 90126001275 432411 Sunset Ridge Middle School Public Schools Regular School No Middle 06 08 2020   grade_12                                                   0                                             0
2776540 CT     school 901260 430011   East Hartford School District 90126001477 436311 Connecticut IB Academy Public Schools Regular School No High 09 12 2020   grade_12                                                   43                                             43
2776541 CT     school 901260 430011   East Hartford School District 90126000200 436211 East Hartford High School Public Schools Regular School No High 09 12 2020   grade_12                                                   416                                             416
2776542 CT     school   430011   East Hartford School District 90126001377 436411 Synergy Alternative Program Program           2020   grade_12                                                   70                                             70
2776543 CT     school 901290 440011   East Haven School District 90129000214 440111 Deer Run School Public Schools Regular School No Elementary PK 02 2020   grade_12                                                   0                                             0
2776544 CT     school 901290 440011   East Haven School District 90129001350 441811 Overbrook Early Learning Center Public Schools Regular School No Elementary PK KG 2020   grade_12                                                   0                                             0
2776545 CT     school 901290 440011   East Haven School District 90129000218 441011 Grove J. Tuttle School Public Schools Regular School No Elementary KG 05 2020   grade_12                                                   0                                             0
2776546 CT     school 901290 440011   East Haven School District 90129000219 440711 Momauguin School Public Schools Regular School No Elementary KG 05 2020   grade_12                                                   0                                             0
2776547 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_12                                                   0                                             0
2776548 CT     school 901290 440011   East Haven School District 90129000215 441311 Dominick H. Ferrara School Public Schools Regular School No Elementary 03 05 2020   grade_12                                                   0                                             0
2776549 CT     school 901290 440011   East Haven School District 90129000217 445111 Joseph Melillo Middle School Public Schools Regular School No Middle 06 08 2020   grade_12                                                   0                                             0
2776550 CT     school 901290 440011   East Haven School District 90129000216 446111 East Haven High School Public Schools Regular School No High 09 12 2020   grade_12                                                   229                                             229
2776551 CT     school   450011   East Lyme School District 90132001450 458011 Integrated Preschool Program           2020   grade_12                                                   0                                             0
2776552 CT     school 901320 450011   East Lyme School District 90132000225 450111 Flanders School Public Schools Regular School No Elementary KG 04 2020   grade_12                                                   0                                             0
2776553 CT     school 901320 450011   East Lyme School District 90132000226 450411 Lillie B. Haynes School Public Schools Regular School No Elementary KG 04 2020   grade_12                                                   0                                             0
2776554 CT     school 901320 450011   East Lyme School District 90132000227 450211 Niantic Center School Public Schools Regular School No Elementary KG 04 2020   grade_12                                                   0                                             0
2776555 CT     school 901320 450011   East Lyme School District 90132000224 455111 East Lyme Middle School Public Schools Regular School No Middle 05 08 2020   grade_12                                                   0                                             0
2776556 CT     school   450011   East Lyme School District 90132001760 450611 Coastal Connections Program           2020   grade_12                                                   6                                             6
2776557 CT     school 901320 450011   East Lyme School District 90132000223 456111 East Lyme High School Public Schools Regular School No High 09 12 2020   grade_12                                                   236                                             236
2776558 CT     school   450011   East Lyme School District 90132001730 450511 Abilities in Motion (AIM) Program Program           2020   grade_12                                                   10                                             10
2776559 CT     school 901350 470011   East Windsor School District 90135000228 470111 Broad Brook Elementary School Public Schools Regular School No Elementary PK 04 2020   grade_12                                                   0                                             0
2776560 CT     school 901350 470011   East Windsor School District 90135000230 475411 East Windsor Middle School Public Schools Regular School No Middle 05 08 2020   grade_12                                                   0                                             0
2776561 CT     school 901350 470011   East Windsor School District 90135000229 476111 East Windsor High School Public Schools Regular School No High 09 12 2020   grade_12                                                   66                                             66
2776562 CT     school   470011   East Windsor School District   470411 East Windsor Transition Program Program           2020   grade_12                                                   8                                             8
2776563 CT     school 901380 390011   Eastford School District 90138000232 390111 Eastford Elementary School Public Schools Regular School No Elementary PK 08 2020   grade_12                                                   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]);