enrollments

Data source: Big Local News · About: Big Local

20,216 rows where state = "CT" and year = 2021 sorted by male_int

✎ View and edit SQL

This data as json, CSV (advanced)

grade ✖

year ✖

  • 2021 · 20,216 ✖
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
2757296 2757296 CT     school   20011   Ansonia School District   21011 Ansonia 18-21 Transition Program Program           2021   pk_12_total * 0 *   0 0     0   0   * 0     *             *   *   0     0 0     0   0     0                  
2757306 2757306 CT     school   50011   Barkhamsted School District   50211 Bridges at Barkhamsted Elementary School Program           2021   pk_12_total * 0 0   0 0     0   *   * *     0             6   6   0 0   0 0     0               0       6   6
2757312 2757312 CT     school   70011   Berlin School District   70311 Transition Academy Program           2021   pk_12_total * 0 0   0 0     0   *   * *     0             11   11   0 0   0 0     0               0       11   11
2757320 2757320 CT     school   90011   Bethel School District   90211 Community Partnership Program Program           2021   pk_12_total * 0 *   0 0     0   0   * 0     0             *   *   0     0 0     0   0     0     0            
2757323 2757323 CT     school   110011   Bloomfield School District   110111 Steps to Success Program           2021   pk_12_total 0 * *   0 0     0   0   * *     *             15   15 0       0 0     0   0                   15   15
2757329 2757329 CT     school 900360 120011   Bolton School District 90036000036 120111 Bolton Center School Public Schools Regular School No Elementary PK 08 2021   pk_12_total 370 25 54   0 9     0   28   * 243     7             56   486 370 25 54   0 9     0   28     243     7       56   486
2757340 2757340 CT     school   140011   Branford School District   140311 Access Transition Program Program           2021   pk_12_total * 0 0   0 *     0   0   * *     *             14   14   0 0   0       0   0                   14   14
2757379 2757379 CT     school   150011   Bridgeport School District   152811 The Transition Academy Program           2021   pk_12_total * 15 12   0 *     0   0   * *     *             29   29   15 12   0       0   0                   29   29
2757380 2757380 CT     school   170011   Bristol School District 90051001728 172911 BECC Autism Program           2021   pk_12_total 6 0 *   0 *     0   0   * *     0             12   12 6 0     0       0   0           0       12   12
2757388 2757388 CT     school   170011   Bristol School District 90051001646 172111 Hubbell/Extended Resource Program           2021   pk_12_total 0 0 *   0 *     0   0   * *     0             *   * 0 0     0       0   0           0            
2757389 2757389 CT     school   170011   Bristol School District 90051001692 172311 Ivy Drive Medically Fragile Program           2021   pk_12_total * * *   0 0     0   *   * *     0             7   7         0 0     0               0       7   7
2757390 2757390 CT     school   170011   Bristol School District 90051001755 173011 South Side Extended Resource Program           2021   pk_12_total * 0 *   0 0     0   *   * *     0             10   10   0     0 0     0               0       10   10
2757391 2757391 CT     school   170011   Bristol School District 90051001707 173211 Stafford Autism Program           2021   pk_12_total * * *   * *     0   0   * *     0             13   13                 0   0           0       13   13
2757394 2757394 CT     school   170011   Bristol School District   173811 Greene Hills Extended Resource Program           2021   pk_12_total 0 0 *   0 *     0   0   * *     *             7   7 0 0     0       0   0                   7   7
2757395 2757395 CT     school   170011   Bristol School District 90051001726 172511 Mt. View GOAL Program           2021   pk_12_total * 0 0   0 0     0   *   * 0     0             *   *   0 0   0 0     0         0     0            
2757396 2757396 CT     school   170011   Bristol School District   173711 Hubbell Autism Program Program           2021   pk_12_total * * *   0 *     0   0   * *     *             9   9         0       0   0                   9   9
2757397 2757397 CT     school   170011   Bristol School District   172211 Ivy Drive Extended Resource Program           2021   pk_12_total 0 0 *   0 0     0   0   * 0     0             *   * 0 0     0 0     0   0     0     0            
2757398 2757398 CT     school   170011   Bristol School District 90051001688 172611 Ivy Drive GOAL Program           2021   pk_12_total * * *   0 0     0   *   * *     *             8   8         0 0     0                       8   8
2757400 2757400 CT     school   170011   Bristol School District   172411 Mt. View Extended Resource Program           2021   pk_12_total * 0 *   0 0     0   0   * *     0             *   *   0     0 0     0   0           0            
2757401 2757401 CT     school   170011   Bristol School District 90051001711 173111 South Side GOAL Program           2021   pk_12_total * * *   0 0     0   *   * *     0             *   *         0 0     0               0            
2757403 2757403 CT     school   170011   Bristol School District 90051001748 171011 Chippens Hill Middle School Functional Program Program           2021   pk_12_total * * *   0 0     0   *   * *     *             11   11         0 0     0                       11   11
2757404 2757404 CT     school   170011   Bristol School District   171611 Chippens Hill Middle School Medically Fragile Program           2021   pk_12_total * 0 0   0 *     0   0   * *     0             *   *   0 0   0       0   0           0            
2757406 2757406 CT     school   170011   Bristol School District 90051001753 173411 Chms Goal Program           2021   pk_12_total * * *   0 0     0   *   * *     *             10   10         0 0     0                       10   10
2757407 2757407 CT     school   170011   Bristol School District 90051001651 172711 Northeast MS/Extended Resource Program           2021   pk_12_total * 0 *   0 0     0   0   * *     *             6   6   0     0 0     0   0                   6   6
2757408 2757408 CT     school   170011   Bristol School District 90051001796 172811 Northeast MS/GOAL Program           2021   pk_12_total * * *   0 0     0   0   * *     0             9   9         0 0     0   0           0       9   9
2757410 2757410 CT     school   170011   Bristol School District 90051001661 170911 Greene-Hills GOAL Program           2021   pk_12_total 0 0 *   0 0     0   0   * 0     *             *   * 0 0     0 0     0   0     0                  
2757411 2757411 CT     school 900510 170011   Bristol School District 90051000092 176111 Bristol Central High School Public Schools Regular School No High 09 12 2021   pk_12_total 656 77 391   * *     0   47   * 616     43             235   1202 656 77 391           0   47     616     43       235   1202
2757437 2757437 CT     school   2410014   Capitol Region Education Council   2411414 River Street School Early Learning Center Program           2021   pk_12_total * * *   0 0     0   0   * *     0             0   6         0 0     0   0           0       0   6
2757444 2757444 CT     school 900700 2410014   Capitol Region Education Council 90070001625 2415314 Greater Hartford Academy of the Arts Magnet Middle Regional Education Service Center Schools Regular School No Middle 06 08 2021   pk_12_total 66 95 170   0 0     0   18   * 251     25             81   349 66 95 170   0 0     0   18     251     25       81   349
2757445 2757445 CT     school 900700 2410014   Capitol Region Education Council 90070000880 2416114 Metropolitan Learning Center for Global and International Studies Regional Education Service Center Schools Regular School No High 06 12 2021   pk_12_total 98 350 203   * 17     *   43   * 390     22             131   714 98 350 203     17         43     390     22       131   714
2757447 2757447 CT     school   2410014   Capitol Region Education Council 90070001489 2419214 Farmington Valley Regional Diagnostic Center Program           2021   pk_12_total * 0 0   0 0     0   *   * *     0             9   9   0 0   0 0     0               0       9   9
2757451 2757451 CT     school   2410014   Capitol Region Education Council 90070001802 2419714 Strive (Southern Transition Real-World and Independent Vocational Education Program Program           2021   pk_12_total 10 0 *   0 *     *   0   * *     0             14   14 10 0     0           0           0       14   14
2757456 2757456 CT     school   250011   Cheshire School District   250711 Highland School Autism Program Program           2021   pk_12_total 11 * *   0 *     0   0   * *     0             15   15 11       0       0   0           0       15   15
2757458 2757458 CT     school   250011   Cheshire School District   251111 Doolittle Bridges Program Program           2021   pk_12_total * 0 *   0 0     0   0   * 0     0             *   *   0     0 0     0   0     0     0            
2757461 2757461 CT     school 900750 250011   Cheshire School District 90075000123 256111 Cheshire High School Public Schools Regular School No High 09 12 2021   pk_12_total 1085 41 74   * 146     0   *   * 704     *             178   1368 1085 41 74     146     0         704             178   1368
2757463 2757463 CT     school   250011   Cheshire School District 90075001766 250311 Cheshire Quinnipiac University Transition Collaborative Program           2021   pk_12_total * 0 0   0 *     0   0   * *     0             *   *   0 0   0       0   0           0            
2757464 2757464 CT     school   250011   Cheshire School District   251011 QU College Life Program           2021   pk_12_total 7 0 0   0 0     0   0   * *     0             7   7 7 0 0   0 0     0   0           0       7   7
2757472 2757472 CT     school   280011   Colchester School District   280511 Bacon Academy Alternative Education Program           2021   pk_12_total * 0 0   0 0     0   0   * *     0             *   *   0 0   0 0     0   0           0            
2757473 2757473 CT     school   280011   Colchester School District   280711 Community Transition Academy of Colchester Program           2021   pk_12_total * 0 0   0 0     0   0   * *     0             *   *   0 0   0 0     0   0           0            
2757478 2757478 CT     school   2430014   Cooperative Educational Services   2430314 Eastern Fairfield County Diagnostic Center Program           2021   pk_12_total 0 * 0   * 0     0   0   * 0     0             0   * 0   0     0     0   0     0     0       0    
2757481 2757481 CT     school   2430014   Cooperative Educational Services 90091001555 2439314 RISE Transitional Program Program           2021   pk_12_total 9 0 *   0 0     *   *   * *     0             13   13 9 0     0 0                     0       13   13
2757482 2757482 CT     school   2430014   Cooperative Educational Services   2430214 Transition Learning Center Program           2021   pk_12_total 16 8 *   0 *     0   *   * *     *             32   32 16 8     0       0                       32   32
2757488 2757488 CT     school 900960 320011   Coventry School District 90096000143 326111 Coventry High School Public Schools Regular School No High 09 12 2021   pk_12_total 363 * 33   * *     0   16   * 229     0             57   419 363   33           0   16     229     0       57   419
2757491 2757491 CT     school 900990 330011   Cromwell School District 90099001432 330311 Woodside Intermediate School Public Schools Regular School No Elementary 03 05 2021   pk_12_total 329 27 56   0 26     *   *   * 247     29             48   463 329 27 56   0 26               247     29       48   463
2757510 2757510 CT     school 901020 340011   Danbury School District 90102001691 340311 Westside Middle School Academy Public Schools Regular School No Middle 06 08 2021   pk_12_total 321 49 308   0 53     0   13   * 374     72             44   744 321 49 308   0 53     0   13     374     72       44   744
2757513 2757513 CT     school   340011   Danbury School District   340711 Western Connection Program           2021   pk_12_total * 0 *   0 0     0   0   * *     0             11   11   0     0 0     0   0           0       11   11
2757525 2757525 CT     school   370011   Derby School District   370511 RAISE Academy Program           2021   pk_12_total 7 6 *   0 0     0   *   * *     0             12   22 7 6     0 0     0               0       12   22
2757534 2757534 CT     school   410011   East Haddam School District   410311 East Haddam Cooperative Transition Program Program           2021   pk_12_total * 0 0   0 0     0   0   * 0     0             *   *   0 0   0 0     0   0     0     0            
2757539 2757539 CT     school   420011   East Hampton School District 90123001514 429011 The Learning Center at East Hampton Program           2021   pk_12_total 9 0 0   0 0     0   0   * *     0             *   9 9 0 0   0 0     0   0           0           9
2757562 2757562 CT     school 901290 440011   East Haven School District 90129000216 446111 East Haven High School Public Schools Regular School No High 09 12 2021   pk_12_total 528 41 260   * 41     0   *   * 451     66             128   880 528 41 260     41     0         451     66       128   880
2757568 2757568 CT     school   450011   East Lyme School District 90132001760 450611 Coastal Connections Program           2021   pk_12_total * 0 *   0 0     0   0   * *     0             7   15   0     0 0     0   0           0       7   15
2757574 2757574 CT     school   470011   East Windsor School District   470411 East Windsor Transition Program Program           2021   pk_12_total * 0 *   0 0     0   0   * *     0             8   8   0     0 0     0   0           0       8   8
2757576 2757576 CT     school 901360 2530014   Eastern Connecticut Regional Educational Service Center (EASTCONN) 90136001507 2536014 Arts at the Capitol Theater Magnet School (ACT) Regional Education Service Center Schools Regular School No High 09 12 2021   pk_12_total 79 6 36   0 0     0   9   * 87     *             23   130 79 6 36   0 0     0   9     87             23   130
2757577 2757577 CT     school 901360 2530014   Eastern Connecticut Regional Educational Service Center (EASTCONN) 90136001937 2530314 LEAP Alternative High School Regional Education Service Center Schools Alternative School No High 09 12 2021   pk_12_total * * *   0 0     0   *   * *     *             *   8         0 0     0                           8
2757579 2757579 CT     school   2530014   Eastern Connecticut Regional Educational Service Center (EASTCONN)   2530214 Woodstock Academy Consortium Classroom Program           2021   pk_12_total 10 0 0   0 *     0   *   * *     0             14   14 10 0 0   0       0               0       14   14
2757580 2757580 CT     school   2530014   Eastern Connecticut Regional Educational Service Center (EASTCONN)   2530114 Regional Transitional Services Program           2021   pk_12_total 8 0 0   0 0     0   0   * *     0             8   8 8 0 0   0 0     0   0           0       8   8
2757585 2757585 CT     school   2420014   EdAdvance   2420614 Partnership Learning Academy Program           2021   pk_12_total * 0 *   0 0     0   0   * *     *             9   9   0     0 0     0   0                   9   9
2757586 2757586 CT     school   2420014   EdAdvance 90351201476 2429014 The ACCESS School at The Danuta M. Thibodeau Education Center Program           2021   pk_12_total 17 * *   * *     0   0   * *     0             26   26 17               0   0           0       26   26
2757588 2757588 CT     school   2420014   EdAdvance   2420314 Steps-North Expelled Student Program           2021   pk_12_total 0 * *   0 0     0   0   * *     *             *   * 0       0 0     0   0                        
2757589 2757589 CT     school   2420014   EdAdvance   2420414 ACCESS-South Expelled Student Program           2021   pk_12_total * 0 *   0 0     0   0   * 0     0             *   *   0     0 0     0   0     0     0            
2757596 2757596 CT     school   480011   Ellington School District   480511 The Ellington Public Schools Expulsion Program (TEPSEP) Program           2021   pk_12_total * 0 0   0 0     0   *   * 0     0             *   *   0 0   0 0     0         0     0            
2757597 2757597 CT     school   480011   Ellington School District   480411 Ellington Continuing Life Independence Post-Secondary Education (ECLIPSE) Program           2021   pk_12_total 0 0 0   0 *     0   *   * *     0             *   * 0 0 0   0       0               0            
2757605 2757605 CT     school   490011   Enfield School District 90147001743 490811 Henry Barnard - Primary Adaptive Learning (PAL) Program           2021   pk_12_total * * *   0 0     0   *   * *     0             8   8         0 0     0               0       8   8
2757608 2757608 CT     school   490011   Enfield School District 90147001696 490611 Henry Barnard - Educational Counseling Program (ECP) Program           2021   pk_12_total * * *   0 0     0   *   * *     *             6   6         0 0     0                       6   6
2757609 2757609 CT     school   490011   Enfield School District   492411 Eagle Academy Program           2021   pk_12_total 10 * *   0 0     0   0   * *     0             17   17 10       0 0     0   0           0       17   17
2757610 2757610 CT     school   490011   Enfield School District 90147001676 490511 Edgar H. Parkman - Autism Spectrum Disorder (ASD) Program           2021   pk_12_total * 0 0   0 0     0   0   * *     0             *   *   0 0   0 0     0   0           0            
2757612 2757612 CT     school   490011   Enfield School District   491411 Eli Whitney - Intermediate Adaptive Learning (IAL) Program           2021   pk_12_total 0 * *   0 0     0   *   * *     0             *   * 0       0 0     0               0            
2757613 2757613 CT     school   490011   Enfield School District 90147001702 490711 Prudence Crandall - Educational Counseling Program (ECP) Program           2021   pk_12_total * * 0   0 0     0   *   * 0     0             *   *     0   0 0     0         0     0            
2757617 2757617 CT     school   490011   Enfield School District   492311 Enfield Alternative Education Program Program           2021   pk_12_total 7 * *   0 0     0   0   * *     0             *   13 7       0 0     0   0           0           13
2757618 2757618 CT     school 901470 490011   Enfield School District 90147000243 496111 Enfield High School Public Schools Regular School No High 09 12 2021   pk_12_total 1034 100 242   * 62     *   74   * 761     17             222   1521 1034 100 242     62         74     761     17       222   1521
2757619 2757619 CT     school   490011   Enfield School District   490111 Enfield High - Adaptive Learning Program (ALP) Program           2021   pk_12_total * 0 0   0 *     0   0   * *     0             *   *   0 0   0       0   0           0            
2757641 2757641 CT     school   510011   Fairfield School District   510511 Fairfield School/Community Partnership Program           2021   pk_12_total * 0 *   0 0     0   0   * *     0             15   15   0     0 0     0   0           0       15   15
2757650 2757650 CT     school   520011   Farmington School District 90156001713 520611 Farmington Alternative High School Program           2021   pk_12_total * 0 *   0 *     0   0   * *     0             *   7   0     0       0   0           0           7
2757661 2757661 CT     school 901620 540011   Glastonbury School District 90162000283 546111 Glastonbury High School Public Schools Regular School No High 09 12 2021   pk_12_total 1378 66 172   * 219     *   86   * 1007     10             201   1927 1378 66 172     219         86     1007     10       201   1927
2757662 2757662 CT     school   540011   Glastonbury School District 90162001752 541411 Glastonbury Transition Academy Program           2021   pk_12_total 10 * *   0 *     0   0   * *     0             16   16 10       0       0   0           0       16   16
2757681 2757681 CT     school 901710 570011   Greenwich School District 90171000300 576111 Greenwich High School Public Schools Regular School No High 09 12 2021   pk_12_total 1703 83 645   * 204     *   108   * 1383     73             372   2750 1703 83 645     204         108     1383     73       372   2750
2757682 2757682 CT     school   570011   Greenwich School District   571511 Windrose Program           2021   pk_12_total 9 * 10   0 0     0   *   * 14     *             10   23 9   10   0 0     0         14             10   23
2757683 2757683 CT     school   570011   Greenwich School District 90171001664 571211 Community Connections Program           2021   pk_12_total 16 * *   0 *     0   0   * *     *             21   21 16       0       0   0                   21   21
2757686 2757686 CT     school 901740 580011   Griswold School District 90174001721 580111 Griswold Alternative School Public Schools Alternative School No High 08 12 2021   pk_12_total * 0 0   0 0     0   *   * *     0             16   16   0 0   0 0     0               0       16   16
2757695 2757695 CT     school   590011   Groton School District   590611 Apex Academy Program           2021   pk_12_total * * *   0 0     0   0   * *     0             *   *         0 0     0   0           0            
2757698 2757698 CT     school   590011   Groton School District   591011 Transition Academy Program           2021   pk_12_total 7 * *   0 0     0   *   * *     *             12   12 7       0 0     0                       12   12
2757710 2757710 CT     school   620011   Hamden School District   620711 Alice Peck IIC Program           2021   pk_12_total * 16 8   0 8     0   *   * *     *             *   40   16 8   0 8     0                           40
2757713 2757713 CT     school   620011   Hamden School District   621911 Intensive Support Classroom Program           2021   pk_12_total 6 * *   0 0     0   0   * *     0             13   13 6       0 0     0   0           0       13   13
2757714 2757714 CT     school   620011   Hamden School District   621711 Ridge Hill IIC Program           2021   pk_12_total * 8 *   0 *     0   *   * *     *             17   17   8     0       0                       17   17
2757721 2757721 CT     school   620011   Hamden School District   621511 Dunbar Hill IIC Program           2021   pk_12_total * * *   0 0     0   0   * 0     0             *   *         0 0     0   0     0     0            
2757722 2757722 CT     school   620011   Hamden School District   621311 Church Street IIC Program           2021   pk_12_total 0 * *   0 0     0   0   * *     *             6   6 0       0 0     0   0                   6   6
2757724 2757724 CT     school   620011   Hamden School District   622011 Intensive Support Classroom 7-8 Program           2021   pk_12_total 0 0 *   0 0     0   *   * *     0             6   6 0 0     0 0     0               0       6   6
2757727 2757727 CT     school   620011   Hamden School District   620611 Hamden Transition Academy @ SCSU (AACPB) Program           2021   pk_12_total * 6 0   0 *     0   0   * *     *             8   8   6 0   0       0   0                   8   8
2757741 2757741 CT     school 901920 640011   Hartford School District 90192001641 640511 Montessori Magnet at Batchelder School Public Schools Regular School No Elementary PK 06 2021   pk_12_total 75 46 222   * *     0   15   * 189     82             50   373 75 46 222           0   15     189     82       50   373
2757745 2757745 CT     school   640011   Hartford School District   640510 Pre-K Integrated - Naylor School Program           2021   pk_12_total * * 14   0 *     0   0   * *     0             18   18     14   0       0   0           0       18   18
2757746 2757746 CT     school   640011   Hartford School District   640410 Pre-K Integrated - Parkville School Program           2021   pk_12_total 0 0 *   0 0     0   0   * 0     0             0   * 0 0     0 0     0   0     0     0       0    
2757747 2757747 CT     school   640011   Hartford School District   641110 Pre-K Integrated - SAND School Program           2021   pk_12_total 0 0 *   0 0     0   0   * 0     0             *   * 0 0     0 0     0   0     0     0            
2757748 2757748 CT     school   640011   Hartford School District   641510 Pre-K Integrated - Sanchez School Program           2021   pk_12_total 0 * *   0 0     0   0   * *     0             10   10 0       0 0     0   0           0       10   10
2757757 2757757 CT     school   640011   Hartford School District 90192001764 648511 iGOAL 2 - Moylan School Program           2021   pk_12_total 0 * 7   0 0     0   *   * *     0             14   14 0   7   0 0     0               0       14   14
2757762 2757762 CT     school   640011   Hartford School District   644711 iGOAL 1 - Burns School Program           2021   pk_12_total * * 23   0 *     0   0   * *     12             29   29     23   0       0   0           12       29   29
2757763 2757763 CT     school   640011   Hartford School District 90192001732 645711 iGOAL 1 - M.D. Fox School Program           2021   pk_12_total 0 * *   0 0     0   0   * *     *             13   13 0       0 0     0   0                   13   13
2757764 2757764 CT     school   640011   Hartford School District 90192001673 644411 iGOAL 1 - Rawson School Program           2021   pk_12_total 0 11 *   0 0     0   *   * *     *             18   18 0 11     0 0     0                       18   18
2757765 2757765 CT     school   640011   Hartford School District   644611 RISE - West Middle School Program           2021   pk_12_total * 7 *   0 0     0   0   * *     0             12   12   7     0 0     0   0           0       12   12
2757766 2757766 CT     school   640011   Hartford School District   649511 iGOAL 1 - Breakthrough Magnet School, North Program           2021   pk_12_total 0 * *   0 0     0   0   * *     *             13   13 0       0 0     0   0                   13   13
2757769 2757769 CT     school   640011   Hartford School District   640210 iGOAL 2 - Kennelly School Program           2021   pk_12_total 0 * *   0 0     0   0   * *     *             9   9 0       0 0     0   0                   9   9

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