enrollments
Data source: Big Local News · About: Big Local
1,461 rows where grade = "grade_9", state = "CT" and year = 2020 sorted by school_state_type
This data as json, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2772078 | 2772078 | CT | school | 280011 | Colchester School District | 280511 | Bacon Academy Alternative Education | Program | 2020 | grade_9 | * | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2772079 | 2772079 | CT | school | 280011 | Colchester School District | 280711 | Community Transition Academy of Colchester | Program | 2020 | grade_9 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2772081 | 2772081 | CT | school | 2430014 | Cooperative Educational Services | 90091001561 | 2439114 | Preschool-Primary Learning Center (PLC) | Program | 2020 | grade_9 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2772082 | 2772082 | CT | school | 2430014 | Cooperative Educational Services | 90091001520 | 2438014 | School Readiness | Program | 2020 | grade_9 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2772084 | 2772084 | CT | school | 2430014 | Cooperative Educational Services | 2430314 | Eastern Fairfield County Diagnostic Center | Program | 2020 | grade_9 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2772085 | 2772085 | CT | school | 2430014 | Cooperative Educational Services | 90091001573 | 2439414 | Therapeutic Day Program | Program | 2020 | grade_9 | 14 | 14 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2772086 | 2772086 | CT | school | 2430014 | Cooperative Educational Services | 90091001554 | 2439214 | Developmental Learning Center (DLC) | Program | 2020 | grade_9 | 17 | 17 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2772087 | 2772087 | CT | school | 2430014 | Cooperative Educational Services | 90091001555 | 2439314 | RISE Transitional Program | Program | 2020 | grade_9 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2772088 | 2772088 | CT | school | 2430014 | Cooperative Educational Services | 2430214 | Transition Learning Center | Program | 2020 | grade_9 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2772089 | 2772089 | CT | school | 320011 | Coventry School District | 320311 | Hale Early Education Center | Program | 2020 | grade_9 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2772116 | 2772116 | CT | school | 340011 | Danbury School District | 90102001129 | 346211 | Alternative Center For Excellence | Program | 2020 | grade_9 | 23 | 23 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2772118 | 2772118 | CT | school | 340011 | Danbury School District | 340711 | Western Connection | Program | 2020 | grade_9 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2772130 | 2772130 | CT | school | 370011 | Derby School District | 370511 | RAISE Academy | Program | 2020 | grade_9 | * | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2772131 | 2772131 | CT | school | 370011 | Derby School District | 370211 | Alternative Education Program | Program | 2020 | grade_9 | * | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2772144 | 2772144 | CT | school | 420011 | East Hampton School District | 90123001514 | 429011 | The Learning Center at East Hampton | Program | 2020 | grade_9 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2772145 | 2772145 | CT | school | 430011 | East Hartford School District | 430211 | Early Childhood Learning Center at Hockanum School | Program | 2020 | grade_9 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2772154 | 2772154 | CT | school | 430011 | East Hartford School District | 90126000205 | 439011 | Woodland School | Program | 2020 | grade_9 | 19 | 19 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2772159 | 2772159 | CT | school | 430011 | East Hartford School District | 90126001377 | 436411 | Synergy Alternative Program | Program | 2020 | grade_9 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2772168 | 2772168 | CT | school | 450011 | East Lyme School District | 90132001450 | 458011 | Integrated Preschool | Program | 2020 | grade_9 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2772173 | 2772173 | CT | school | 450011 | East Lyme School District | 90132001760 | 450611 | Coastal Connections | Program | 2020 | grade_9 | * | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2772175 | 2772175 | CT | school | 450011 | East Lyme School District | 90132001730 | 450511 | Abilities in Motion (AIM) Program | Program | 2020 | grade_9 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2772179 | 2772179 | CT | school | 470011 | East Windsor School District | 470411 | East Windsor Transition Program | Program | 2020 | grade_9 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2772183 | 2772183 | CT | school | 2420014 | EdAdvance | 90351200575 | 2428014 | EdAdvance Headstart | Program | 2020 | grade_9 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2772184 | 2772184 | CT | school | 2420014 | EdAdvance | 90351201476 | 2429014 | The ACCESS School at The Danuta M. Thibodeau Education Center | Program | 2020 | grade_9 | * | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2772185 | 2772185 | CT | school | 2420014 | EdAdvance | 2420114 | Steps | Program | 2020 | grade_9 | 9 | 9 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2772186 | 2772186 | CT | school | 2420014 | EdAdvance | 2420314 | Steps-North Expelled Student | Program | 2020 | grade_9 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2772187 | 2772187 | CT | school | 2420014 | EdAdvance | 2420414 | ACCESS-South Expelled Student | Program | 2020 | grade_9 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2772188 | 2772188 | CT | school | 2420014 | EdAdvance | 2420514 | University Pathways Program | Program | 2020 | grade_9 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2772194 | 2772194 | CT | school | 480011 | Ellington School District | 480511 | The Ellington Public Schools Expulsion Program (TEPSEP) | Program | 2020 | grade_9 | * | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2772195 | 2772195 | CT | school | 480011 | Ellington School District | 480411 | Ellington Continuing Life Independence Post-Secondary Education (ECLIPSE) | Program | 2020 | grade_9 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2772197 | 2772197 | CT | school | 490011 | Enfield School District | 90147001915 | 492211 | EPS Integrated Pre-Kindergarten | Program | 2020 | grade_9 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2772198 | 2772198 | CT | school | 490011 | Enfield School District | 90147001810 | 491011 | EPS PK STEAM Academy | Program | 2020 | grade_9 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2772199 | 2772199 | CT | school | 490011 | Enfield School District | 90147000207 | 498011 | Head Start Program | Program | 2020 | grade_9 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2772202 | 2772202 | CT | school | 490011 | Enfield School District | 90147001792 | 490311 | Henry Barnard - Autism Spectrum Disorder (ASD) | Program | 2020 | grade_9 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2772203 | 2772203 | CT | school | 490011 | Enfield School District | 90147001743 | 490811 | Henry Barnard - Primary Adaptive Learning (PAL) | Program | 2020 | grade_9 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2772206 | 2772206 | CT | school | 490011 | Enfield School District | 90147001696 | 490611 | Henry Barnard - Educational Counseling Program (ECP) | Program | 2020 | grade_9 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2772207 | 2772207 | CT | school | 490011 | Enfield School District | 492411 | Eagle Academy | Program | 2020 | grade_9 | * | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2772208 | 2772208 | CT | school | 490011 | Enfield School District | 90147001676 | 490511 | Edgar H. Parkman - Autism Spectrum Disorder (ASD) | Program | 2020 | grade_9 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2772210 | 2772210 | CT | school | 490011 | Enfield School District | 491411 | Eli Whitney - Intermediate Adaptive Learning (IAL) | Program | 2020 | grade_9 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2772212 | 2772212 | CT | school | 490011 | Enfield School District | 90147001702 | 490711 | Prudence Crandall - Educational Counseling Program (ECP) | Program | 2020 | grade_9 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2772213 | 2772213 | CT | school | 490011 | Enfield School District | 490911 | John F. Kennedy - Adaptive Learning Program (ALP) | Program | 2020 | grade_9 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2772215 | 2772215 | CT | school | 490011 | Enfield School District | 492311 | Enfield Alternative Education Program | Program | 2020 | grade_9 | * | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2772216 | 2772216 | CT | school | 490011 | Enfield School District | 490111 | Enfield High - Adaptive Learning Program (ALP) | Program | 2020 | grade_9 | * | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2772218 | 2772218 | CT | school | 490011 | Enfield School District | 90147001523 | 499011 | Enfield Transitional Learning Academy | Program | 2020 | grade_9 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2772220 | 2772220 | CT | school | 510011 | Fairfield School District | 510811 | Early Childhood Center(0510811) | Program | 2020 | grade_9 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2772221 | 2772221 | CT | school | 510011 | Fairfield School District | 90153000989 | 518011 | Early Childhood Center(0518011) | Program | 2020 | grade_9 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2772238 | 2772238 | CT | school | 510011 | Fairfield School District | 510311 | Walter Fitzgerald Campus | Program | 2020 | grade_9 | * | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2772239 | 2772239 | CT | school | 510011 | Fairfield School District | 510511 | Fairfield School/Community Partnership | Program | 2020 | grade_9 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2772240 | 2772240 | CT | school | 520011 | Farmington School District | 90156001441 | 528011 | Farmington Collaborative PK | Program | 2020 | grade_9 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2772248 | 2772248 | CT | school | 520011 | Farmington School District | 90156001713 | 520611 | Farmington Alternative High School | Program | 2020 | grade_9 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2772250 | 2772250 | CT | school | 540011 | Glastonbury School District | 90162001724 | 540511 | PreK-Eastbury | Program | 2020 | grade_9 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2772256 | 2772256 | CT | school | 540011 | Glastonbury School District | 90162001801 | 540111 | Links Academy | Program | 2020 | grade_9 | 7 | 7 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2772260 | 2772260 | CT | school | 540011 | Glastonbury School District | 90162001752 | 541411 | Glastonbury Transition Academy | Program | 2020 | grade_9 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2772280 | 2772280 | CT | school | 570011 | Greenwich School District | 571511 | Windrose | Program | 2020 | grade_9 | * | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2772281 | 2772281 | CT | school | 570011 | Greenwich School District | 90171001664 | 571211 | Community Connections | Program | 2020 | grade_9 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2772295 | 2772295 | CT | school | 590011 | Groton School District | 590611 | Apex Academy | Program | 2020 | grade_9 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2772296 | 2772296 | CT | school | 590011 | Groton School District | 590211 | New Beginnings Alternative Program | Program | 2020 | grade_9 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2772297 | 2772297 | CT | school | 590011 | Groton School District | 591011 | Transition Academy | Program | 2020 | grade_9 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2772305 | 2772305 | CT | school | 620011 | Hamden School District | 90186001433 | 628011 | Alice Peck Learning Center | Program | 2020 | grade_9 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2772309 | 2772309 | CT | school | 620011 | Hamden School District | 620711 | Alice Peck IIC | Program | 2020 | grade_9 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2772311 | 2772311 | CT | school | 620011 | Hamden School District | 621711 | Ridge Hill IIC | Program | 2020 | grade_9 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2772316 | 2772316 | CT | school | 620011 | Hamden School District | 621611 | Helen Street IIC | Program | 2020 | grade_9 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2772317 | 2772317 | CT | school | 620011 | Hamden School District | 621911 | Intensive Support Classroom | Program | 2020 | grade_9 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2772318 | 2772318 | CT | school | 620011 | Hamden School District | 621811 | West Woods IIC | Program | 2020 | grade_9 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2772319 | 2772319 | CT | school | 620011 | Hamden School District | 621311 | Church Street IIC | Program | 2020 | grade_9 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2772320 | 2772320 | CT | school | 620011 | Hamden School District | 621511 | Dunbar Hill IIC | Program | 2020 | grade_9 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2772321 | 2772321 | CT | school | 620011 | Hamden School District | 620911 | Bear Path IIC | Program | 2020 | grade_9 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2772323 | 2772323 | CT | school | 620011 | Hamden School District | 90186001741 | 620511 | Hamden Collaborative Learning Center | Program | 2020 | grade_9 | * | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2772325 | 2772325 | CT | school | 620011 | Hamden School District | 620611 | Hamden Transition Academy @ SCSU (AACPB) | Program | 2020 | grade_9 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2772333 | 2772333 | CT | school | 640011 | Hartford School District | 90192001723 | 644111 | Early Childhood Development Center (ECDC) | Program | 2020 | grade_9 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2772344 | 2772344 | CT | school | 640011 | Hartford School District | 640510 | Pre-K Integrated - Naylor School | Program | 2020 | grade_9 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2772345 | 2772345 | CT | school | 640011 | Hartford School District | 640410 | Pre-K Integrated - Parkville School | Program | 2020 | grade_9 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2772346 | 2772346 | CT | school | 640011 | Hartford School District | 640610 | Pre-K Integrated - West Middle School | Program | 2020 | grade_9 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2772353 | 2772353 | CT | school | 640011 | Hartford School District | 90192001764 | 648511 | iGOAL 2 - Moylan School | Program | 2020 | grade_9 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2772354 | 2772354 | CT | school | 640011 | Hartford School District | 640710 | iGOAL Pre-K - Naylor School | Program | 2020 | grade_9 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2772355 | 2772355 | CT | school | 640011 | Hartford School District | 640810 | iGOAL Pre-K - Rawson School | Program | 2020 | grade_9 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2772360 | 2772360 | CT | school | 640011 | Hartford School District | 649511 | iGOAL 1 - Breakthrough Magnet School, North | Program | 2020 | grade_9 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2772361 | 2772361 | CT | school | 640011 | Hartford School District | 644711 | iGOAL 1 - Burns School | Program | 2020 | grade_9 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2772362 | 2772362 | CT | school | 640011 | Hartford School District | 90192001732 | 645711 | iGOAL 1 - M.D. Fox School | Program | 2020 | grade_9 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2772363 | 2772363 | CT | school | 640011 | Hartford School District | 648711 | iGOAL 1 - Parkville School | Program | 2020 | grade_9 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2772364 | 2772364 | CT | school | 640011 | Hartford School District | 90192001673 | 644411 | iGOAL 1 - Rawson School | Program | 2020 | grade_9 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2772365 | 2772365 | CT | school | 640011 | Hartford School District | 644611 | RISE - West Middle School | Program | 2020 | grade_9 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2772370 | 2772370 | CT | school | 640011 | Hartford School District | 640210 | iGOAL 2 - Kennelly School | Program | 2020 | grade_9 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2772378 | 2772378 | CT | school | 640011 | Hartford School District | 640110 | iGOAL 1 - Milner School | Program | 2020 | grade_9 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2772379 | 2772379 | CT | school | 640011 | Hartford School District | 640910 | New Visions | Program | 2020 | grade_9 | 11 | 11 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2772384 | 2772384 | CT | school | 640011 | Hartford School District | 90192001770 | 648311 | RISE - Bulkeley High School | Program | 2020 | grade_9 | 7 | 7 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2772385 | 2772385 | CT | school | 640011 | Hartford School District | 90192001677 | 648211 | RISE - Hartford Public High School | Program | 2020 | grade_9 | 10 | 10 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2772388 | 2772388 | CT | school | 640011 | Hartford School District | 90192001660 | 644911 | iGOAL 1 - HPHS | Program | 2020 | grade_9 | 11 | 11 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2772390 | 2772390 | CT | school | 640011 | Hartford School District | 90192001727 | 648411 | STEP at Hartford Public High School | Program | 2020 | grade_9 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2772398 | 2772398 | CT | school | 690011 | Killingly School District | 90207000083 | 698011 | Goodyear Early Childhood Center | Program | 2020 | grade_9 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2772403 | 2772403 | CT | school | 2450014 | Learn | 2451514 | LEARN Integrated Program at TFS | Program | 2020 | grade_9 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2772406 | 2772406 | CT | school | 2450014 | Learn | 90345001680 | 2451114 | Learn Intensive Program | Program | 2020 | grade_9 | * | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2772408 | 2772408 | CT | school | 2450014 | Learn | 2451614 | LEARN SAILS Program | Program | 2020 | grade_9 | * | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2772410 | 2772410 | CT | school | 2450014 | Learn | 2451414 | LEARN Diagnostic and Wellness Center | Program | 2020 | grade_9 | * | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2772415 | 2772415 | CT | school | 2450014 | Learn | 90345001757 | 2450414 | LEARN Transition Academy | Program | 2020 | grade_9 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2772416 | 2772416 | CT | school | 2450014 | Learn | 90345001795 | 2450614 | Learn High School | Program | 2020 | grade_9 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2772425 | 2772425 | CT | school | 720011 | Ledyard School District | 720511 | Ledyard Transition Academy | Program | 2020 | grade_9 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2772431 | 2772431 | CT | school | 760011 | Madison School District | 90228001549 | 769011 | Town Campus Learning Center | Program | 2020 | grade_9 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2772439 | 2772439 | CT | school | 770011 | Manchester School District | 770811 | Manchester Preschool - Site 2 | Program | 2020 | grade_9 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2772440 | 2772440 | CT | school | 770011 | Manchester School District | 90231000519 | 778011 | Manchester Preschool Center | Program | 2020 | grade_9 | 0 | 0 |
Advanced export
JSON shape: default, array, newline-delimited
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]);