enrollments

Data source: Big Local News · About: Big Local

20,286 rows where state = "CT" and year = 2019 sorted by school_state_id descending

✎ View and edit SQL

This data as json, CSV (advanced)

grade ✖

year ✖

  • 2019 · 20,286 ✖
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
2434308 2434308 CT     school 905373 9030022   The Woodstock Academy District 90537311223 9036122 The Woodstock Academy Endowed and Incorporated Academies Schools Regular School No High 09 12 2019   kindergarten                                                   0                                             0
2435757 2435757 CT     school 905373 9030022   The Woodstock Academy District 90537311223 9036122 The Woodstock Academy Endowed and Incorporated Academies Schools Regular School No High 09 12 2019   grade_1                                                   0                                             0
2437206 2437206 CT     school 905373 9030022   The Woodstock Academy District 90537311223 9036122 The Woodstock Academy Endowed and Incorporated Academies Schools Regular School No High 09 12 2019   grade_2                                                   0                                             0
2438655 2438655 CT     school 905373 9030022   The Woodstock Academy District 90537311223 9036122 The Woodstock Academy Endowed and Incorporated Academies Schools Regular School No High 09 12 2019   grade_3                                                   0                                             0
2440104 2440104 CT     school 905373 9030022   The Woodstock Academy District 90537311223 9036122 The Woodstock Academy Endowed and Incorporated Academies Schools Regular School No High 09 12 2019   grade_4                                                   0                                             0
2441553 2441553 CT     school 905373 9030022   The Woodstock Academy District 90537311223 9036122 The Woodstock Academy Endowed and Incorporated Academies Schools Regular School No High 09 12 2019   grade_5                                                   0                                             0
2443002 2443002 CT     school 905373 9030022   The Woodstock Academy District 90537311223 9036122 The Woodstock Academy Endowed and Incorporated Academies Schools Regular School No High 09 12 2019   grade_6                                                   0                                             0
2444451 2444451 CT     school 905373 9030022   The Woodstock Academy District 90537311223 9036122 The Woodstock Academy Endowed and Incorporated Academies Schools Regular School No High 09 12 2019   grade_7                                                   0                                             0
2445900 2445900 CT     school 905373 9030022   The Woodstock Academy District 90537311223 9036122 The Woodstock Academy Endowed and Incorporated Academies Schools Regular School No High 09 12 2019   grade_8                                                   0                                             0
2447349 2447349 CT     school 905373 9030022   The Woodstock Academy District 90537311223 9036122 The Woodstock Academy Endowed and Incorporated Academies Schools Regular School No High 09 12 2019   grade_9                                                   238                                             238
2448798 2448798 CT     school 905373 9030022   The Woodstock Academy District 90537311223 9036122 The Woodstock Academy Endowed and Incorporated Academies Schools Regular School No High 09 12 2019   grade_10                                                   260                                             260
2450247 2450247 CT     school 905373 9030022   The Woodstock Academy District 90537311223 9036122 The Woodstock Academy Endowed and Incorporated Academies Schools Regular School No High 09 12 2019   grade_11                                                   292                                             292
2451696 2451696 CT     school 905373 9030022   The Woodstock Academy District 90537311223 9036122 The Woodstock Academy Endowed and Incorporated Academies Schools Regular School No High 09 12 2019   grade_12                                                   308                                             308
2453145 2453145 CT     school 905373 9030022   The Woodstock Academy District 90537311223 9036122 The Woodstock Academy Endowed and Incorporated Academies Schools Regular School No High 09 12 2019   pk_12_total 925 * 26   * 124     0   11   545 553     0             74   1098 925   26     124     0   11   545 553     0       74   1098
2434268 2434268 CT     school 905372 9020022   The Gilbert School District 90537201222 9026122 The Gilbert School Endowed and Incorporated Academies Schools Regular School No High 07 12 2019   kindergarten                                                   0                                             0
2435717 2435717 CT     school 905372 9020022   The Gilbert School District 90537201222 9026122 The Gilbert School Endowed and Incorporated Academies Schools Regular School No High 07 12 2019   grade_1                                                   0                                             0
2437166 2437166 CT     school 905372 9020022   The Gilbert School District 90537201222 9026122 The Gilbert School Endowed and Incorporated Academies Schools Regular School No High 07 12 2019   grade_2                                                   0                                             0
2438615 2438615 CT     school 905372 9020022   The Gilbert School District 90537201222 9026122 The Gilbert School Endowed and Incorporated Academies Schools Regular School No High 07 12 2019   grade_3                                                   0                                             0
2440064 2440064 CT     school 905372 9020022   The Gilbert School District 90537201222 9026122 The Gilbert School Endowed and Incorporated Academies Schools Regular School No High 07 12 2019   grade_4                                                   0                                             0
2441513 2441513 CT     school 905372 9020022   The Gilbert School District 90537201222 9026122 The Gilbert School Endowed and Incorporated Academies Schools Regular School No High 07 12 2019   grade_5                                                   0                                             0
2442962 2442962 CT     school 905372 9020022   The Gilbert School District 90537201222 9026122 The Gilbert School Endowed and Incorporated Academies Schools Regular School No High 07 12 2019   grade_6                                                   0                                             0
2444411 2444411 CT     school 905372 9020022   The Gilbert School District 90537201222 9026122 The Gilbert School Endowed and Incorporated Academies Schools Regular School No High 07 12 2019   grade_7                                                   67                                             67
2445860 2445860 CT     school 905372 9020022   The Gilbert School District 90537201222 9026122 The Gilbert School Endowed and Incorporated Academies Schools Regular School No High 07 12 2019   grade_8                                                   87                                             87
2447309 2447309 CT     school 905372 9020022   The Gilbert School District 90537201222 9026122 The Gilbert School Endowed and Incorporated Academies Schools Regular School No High 07 12 2019   grade_9                                                   62                                             62
2448758 2448758 CT     school 905372 9020022   The Gilbert School District 90537201222 9026122 The Gilbert School Endowed and Incorporated Academies Schools Regular School No High 07 12 2019   grade_10                                                   91                                             91
2450207 2450207 CT     school 905372 9020022   The Gilbert School District 90537201222 9026122 The Gilbert School Endowed and Incorporated Academies Schools Regular School No High 07 12 2019   grade_11                                                   89                                             89
2451656 2451656 CT     school 905372 9020022   The Gilbert School District 90537201222 9026122 The Gilbert School Endowed and Incorporated Academies Schools Regular School No High 07 12 2019   grade_12                                                   115                                             115
2453105 2453105 CT     school 905372 9020022   The Gilbert School District 90537201222 9026122 The Gilbert School Endowed and Incorporated Academies Schools Regular School No High 07 12 2019   pk_12_total 348 8 82   0 50     0   23   275 *     16             74   511 348 8 82   0 50     0   23   275       16       74   511
2434299 2434299 CT     school 905371 9010022   Norwich Free Academy District 90537101221 9016122 Norwich Free Academy Endowed and Incorporated Academies Schools Regular School No High 09 12 2019   kindergarten                                                   0                                             0
2435748 2435748 CT     school 905371 9010022   Norwich Free Academy District 90537101221 9016122 Norwich Free Academy Endowed and Incorporated Academies Schools Regular School No High 09 12 2019   grade_1                                                   0                                             0
2437197 2437197 CT     school 905371 9010022   Norwich Free Academy District 90537101221 9016122 Norwich Free Academy Endowed and Incorporated Academies Schools Regular School No High 09 12 2019   grade_2                                                   0                                             0
2438646 2438646 CT     school 905371 9010022   Norwich Free Academy District 90537101221 9016122 Norwich Free Academy Endowed and Incorporated Academies Schools Regular School No High 09 12 2019   grade_3                                                   0                                             0
2440095 2440095 CT     school 905371 9010022   Norwich Free Academy District 90537101221 9016122 Norwich Free Academy Endowed and Incorporated Academies Schools Regular School No High 09 12 2019   grade_4                                                   0                                             0
2441544 2441544 CT     school 905371 9010022   Norwich Free Academy District 90537101221 9016122 Norwich Free Academy Endowed and Incorporated Academies Schools Regular School No High 09 12 2019   grade_5                                                   0                                             0
2442993 2442993 CT     school 905371 9010022   Norwich Free Academy District 90537101221 9016122 Norwich Free Academy Endowed and Incorporated Academies Schools Regular School No High 09 12 2019   grade_6                                                   0                                             0
2444442 2444442 CT     school 905371 9010022   Norwich Free Academy District 90537101221 9016122 Norwich Free Academy Endowed and Incorporated Academies Schools Regular School No High 09 12 2019   grade_7                                                   0                                             0
2445891 2445891 CT     school 905371 9010022   Norwich Free Academy District 90537101221 9016122 Norwich Free Academy Endowed and Incorporated Academies Schools Regular School No High 09 12 2019   grade_8                                                   0                                             0
2447340 2447340 CT     school 905371 9010022   Norwich Free Academy District 90537101221 9016122 Norwich Free Academy Endowed and Incorporated Academies Schools Regular School No High 09 12 2019   grade_9                                                   521                                             521
2448789 2448789 CT     school 905371 9010022   Norwich Free Academy District 90537101221 9016122 Norwich Free Academy Endowed and Incorporated Academies Schools Regular School No High 09 12 2019   grade_10                                                   568                                             568
2450238 2450238 CT     school 905371 9010022   Norwich Free Academy District 90537101221 9016122 Norwich Free Academy Endowed and Incorporated Academies Schools Regular School No High 09 12 2019   grade_11                                                   601                                             601
2451687 2451687 CT     school 905371 9010022   Norwich Free Academy District 90537101221 9016122 Norwich Free Academy Endowed and Incorporated Academies Schools Regular School No High 09 12 2019   grade_12                                                   544                                             544
2453136 2453136 CT     school 905371 9010022   Norwich Free Academy District 90537101221 9016122 Norwich Free Academy Endowed and Incorporated Academies Schools Regular School No High 09 12 2019   pk_12_total 1123 330 366   22 174     22   197   1084 1150     187             247   2234 1123 330 366   22 174     22   197   1084 1150     187       247   2234
2434300 2434300 CT     school 905371 9010022   Norwich Free Academy District 90537101221 9010322 Alternative Pathways to Success Program Regular School No High 09 12 2019   kindergarten                                                   0                                             0
2435749 2435749 CT     school 905371 9010022   Norwich Free Academy District 90537101221 9010322 Alternative Pathways to Success Program Regular School No High 09 12 2019   grade_1                                                   0                                             0
2437198 2437198 CT     school 905371 9010022   Norwich Free Academy District 90537101221 9010322 Alternative Pathways to Success Program Regular School No High 09 12 2019   grade_2                                                   0                                             0
2438647 2438647 CT     school 905371 9010022   Norwich Free Academy District 90537101221 9010322 Alternative Pathways to Success Program Regular School No High 09 12 2019   grade_3                                                   0                                             0
2440096 2440096 CT     school 905371 9010022   Norwich Free Academy District 90537101221 9010322 Alternative Pathways to Success Program Regular School No High 09 12 2019   grade_4                                                   0                                             0
2441545 2441545 CT     school 905371 9010022   Norwich Free Academy District 90537101221 9010322 Alternative Pathways to Success Program Regular School No High 09 12 2019   grade_5                                                   0                                             0
2442994 2442994 CT     school 905371 9010022   Norwich Free Academy District 90537101221 9010322 Alternative Pathways to Success Program Regular School No High 09 12 2019   grade_6                                                   0                                             0
2444443 2444443 CT     school 905371 9010022   Norwich Free Academy District 90537101221 9010322 Alternative Pathways to Success Program Regular School No High 09 12 2019   grade_7                                                   0                                             0
2445892 2445892 CT     school 905371 9010022   Norwich Free Academy District 90537101221 9010322 Alternative Pathways to Success Program Regular School No High 09 12 2019   grade_8                                                   0                                             0
2447341 2447341 CT     school 905371 9010022   Norwich Free Academy District 90537101221 9010322 Alternative Pathways to Success Program Regular School No High 09 12 2019   grade_9                                                   0                                             0
2448790 2448790 CT     school 905371 9010022   Norwich Free Academy District 90537101221 9010322 Alternative Pathways to Success Program Regular School No High 09 12 2019   grade_10                                                   0                                             0
2450239 2450239 CT     school 905371 9010022   Norwich Free Academy District 90537101221 9010322 Alternative Pathways to Success Program Regular School No High 09 12 2019   grade_11                                                   *                                              
2451688 2451688 CT     school 905371 9010022   Norwich Free Academy District 90537101221 9010322 Alternative Pathways to Success Program Regular School No High 09 12 2019   grade_12                                                   *                                              
2453137 2453137 CT     school 905371 9010022   Norwich Free Academy District 90537101221 9010322 Alternative Pathways to Success Program Regular School No High 09 12 2019   pk_12_total 7 * *   0 0     0   0   * *     *             *   15 7       0 0     0   0                       15
2434301 2434301 CT     school 905371 9010022   Norwich Free Academy District 90537101221 9010222 Night School Program Regular School No High 09 12 2019   kindergarten                                                   0                                             0
2435750 2435750 CT     school 905371 9010022   Norwich Free Academy District 90537101221 9010222 Night School Program Regular School No High 09 12 2019   grade_1                                                   0                                             0
2437199 2437199 CT     school 905371 9010022   Norwich Free Academy District 90537101221 9010222 Night School Program Regular School No High 09 12 2019   grade_2                                                   0                                             0
2438648 2438648 CT     school 905371 9010022   Norwich Free Academy District 90537101221 9010222 Night School Program Regular School No High 09 12 2019   grade_3                                                   0                                             0
2440097 2440097 CT     school 905371 9010022   Norwich Free Academy District 90537101221 9010222 Night School Program Regular School No High 09 12 2019   grade_4                                                   0                                             0
2441546 2441546 CT     school 905371 9010022   Norwich Free Academy District 90537101221 9010222 Night School Program Regular School No High 09 12 2019   grade_5                                                   0                                             0
2442995 2442995 CT     school 905371 9010022   Norwich Free Academy District 90537101221 9010222 Night School Program Regular School No High 09 12 2019   grade_6                                                   0                                             0
2444444 2444444 CT     school 905371 9010022   Norwich Free Academy District 90537101221 9010222 Night School Program Regular School No High 09 12 2019   grade_7                                                   0                                             0
2445893 2445893 CT     school 905371 9010022   Norwich Free Academy District 90537101221 9010222 Night School Program Regular School No High 09 12 2019   grade_8                                                   0                                             0
2447342 2447342 CT     school 905371 9010022   Norwich Free Academy District 90537101221 9010222 Night School Program Regular School No High 09 12 2019   grade_9                                                   0                                             0
2448791 2448791 CT     school 905371 9010022   Norwich Free Academy District 90537101221 9010222 Night School Program Regular School No High 09 12 2019   grade_10                                                   0                                             0
2450240 2450240 CT     school 905371 9010022   Norwich Free Academy District 90537101221 9010222 Night School Program Regular School No High 09 12 2019   grade_11                                                   *                                              
2451689 2451689 CT     school 905371 9010022   Norwich Free Academy District 90537101221 9010222 Night School Program Regular School No High 09 12 2019   grade_12                                                   *                                              
2453138 2453138 CT     school 905371 9010022   Norwich Free Academy District 90537101221 9010222 Night School Program Regular School No High 09 12 2019   pk_12_total * * *   0 0     0   0   * *     0             *   7         0 0     0   0           0           7
2434285 2434285 CT     school 900002 9000016   Connecticut Technical Education and Career System 90000201139 9002716 Ella T. Grasso Technical High School CT Technical Education and Career Schools Career and Technical School No High 09 12 2019   kindergarten                                                   0                                             0
2435734 2435734 CT     school 900002 9000016   Connecticut Technical Education and Career System 90000201139 9002716 Ella T. Grasso Technical High School CT Technical Education and Career Schools Career and Technical School No High 09 12 2019   grade_1                                                   0                                             0
2437183 2437183 CT     school 900002 9000016   Connecticut Technical Education and Career System 90000201139 9002716 Ella T. Grasso Technical High School CT Technical Education and Career Schools Career and Technical School No High 09 12 2019   grade_2                                                   0                                             0
2438632 2438632 CT     school 900002 9000016   Connecticut Technical Education and Career System 90000201139 9002716 Ella T. Grasso Technical High School CT Technical Education and Career Schools Career and Technical School No High 09 12 2019   grade_3                                                   0                                             0
2440081 2440081 CT     school 900002 9000016   Connecticut Technical Education and Career System 90000201139 9002716 Ella T. Grasso Technical High School CT Technical Education and Career Schools Career and Technical School No High 09 12 2019   grade_4                                                   0                                             0
2441530 2441530 CT     school 900002 9000016   Connecticut Technical Education and Career System 90000201139 9002716 Ella T. Grasso Technical High School CT Technical Education and Career Schools Career and Technical School No High 09 12 2019   grade_5                                                   0                                             0
2442979 2442979 CT     school 900002 9000016   Connecticut Technical Education and Career System 90000201139 9002716 Ella T. Grasso Technical High School CT Technical Education and Career Schools Career and Technical School No High 09 12 2019   grade_6                                                   0                                             0
2444428 2444428 CT     school 900002 9000016   Connecticut Technical Education and Career System 90000201139 9002716 Ella T. Grasso Technical High School CT Technical Education and Career Schools Career and Technical School No High 09 12 2019   grade_7                                                   0                                             0
2445877 2445877 CT     school 900002 9000016   Connecticut Technical Education and Career System 90000201139 9002716 Ella T. Grasso Technical High School CT Technical Education and Career Schools Career and Technical School No High 09 12 2019   grade_8                                                   0                                             0
2447326 2447326 CT     school 900002 9000016   Connecticut Technical Education and Career System 90000201139 9002716 Ella T. Grasso Technical High School CT Technical Education and Career Schools Career and Technical School No High 09 12 2019   grade_9                                                   144                                             144
2448775 2448775 CT     school 900002 9000016   Connecticut Technical Education and Career System 90000201139 9002716 Ella T. Grasso Technical High School CT Technical Education and Career Schools Career and Technical School No High 09 12 2019   grade_10                                                   131                                             131
2450224 2450224 CT     school 900002 9000016   Connecticut Technical Education and Career System 90000201139 9002716 Ella T. Grasso Technical High School CT Technical Education and Career Schools Career and Technical School No High 09 12 2019   grade_11                                                   122                                             122
2451673 2451673 CT     school 900002 9000016   Connecticut Technical Education and Career System 90000201139 9002716 Ella T. Grasso Technical High School CT Technical Education and Career Schools Career and Technical School No High 09 12 2019   grade_12                                                   94                                             94
2453122 2453122 CT     school 900002 9000016   Connecticut Technical Education and Career System 90000201139 9002716 Ella T. Grasso Technical High School CT Technical Education and Career Schools Career and Technical School No High 09 12 2019   pk_12_total 246 35 162   * 7     *   34   299 192     17             82   491 246 35 162     7         34   299 192     17       82   491
2434294 2434294 CT     school 900002 9000016   Connecticut Technical Education and Career System 90000201149 9002616 Platt Technical High School CT Technical Education and Career Schools Career and Technical School No High 09 12 2019   kindergarten                                                   0                                             0
2435743 2435743 CT     school 900002 9000016   Connecticut Technical Education and Career System 90000201149 9002616 Platt Technical High School CT Technical Education and Career Schools Career and Technical School No High 09 12 2019   grade_1                                                   0                                             0
2437192 2437192 CT     school 900002 9000016   Connecticut Technical Education and Career System 90000201149 9002616 Platt Technical High School CT Technical Education and Career Schools Career and Technical School No High 09 12 2019   grade_2                                                   0                                             0
2438641 2438641 CT     school 900002 9000016   Connecticut Technical Education and Career System 90000201149 9002616 Platt Technical High School CT Technical Education and Career Schools Career and Technical School No High 09 12 2019   grade_3                                                   0                                             0
2440090 2440090 CT     school 900002 9000016   Connecticut Technical Education and Career System 90000201149 9002616 Platt Technical High School CT Technical Education and Career Schools Career and Technical School No High 09 12 2019   grade_4                                                   0                                             0
2441539 2441539 CT     school 900002 9000016   Connecticut Technical Education and Career System 90000201149 9002616 Platt Technical High School CT Technical Education and Career Schools Career and Technical School No High 09 12 2019   grade_5                                                   0                                             0
2442988 2442988 CT     school 900002 9000016   Connecticut Technical Education and Career System 90000201149 9002616 Platt Technical High School CT Technical Education and Career Schools Career and Technical School No High 09 12 2019   grade_6                                                   0                                             0
2444437 2444437 CT     school 900002 9000016   Connecticut Technical Education and Career System 90000201149 9002616 Platt Technical High School CT Technical Education and Career Schools Career and Technical School No High 09 12 2019   grade_7                                                   0                                             0
2445886 2445886 CT     school 900002 9000016   Connecticut Technical Education and Career System 90000201149 9002616 Platt Technical High School CT Technical Education and Career Schools Career and Technical School No High 09 12 2019   grade_8                                                   0                                             0
2447335 2447335 CT     school 900002 9000016   Connecticut Technical Education and Career System 90000201149 9002616 Platt Technical High School CT Technical Education and Career Schools Career and Technical School No High 09 12 2019   grade_9                                                   236                                             236
2448784 2448784 CT     school 900002 9000016   Connecticut Technical Education and Career System 90000201149 9002616 Platt Technical High School CT Technical Education and Career Schools Career and Technical School No High 09 12 2019   grade_10                                                   216                                             216
2450233 2450233 CT     school 900002 9000016   Connecticut Technical Education and Career System 90000201149 9002616 Platt Technical High School CT Technical Education and Career Schools Career and Technical School No High 09 12 2019   grade_11                                                   178                                             178
2451682 2451682 CT     school 900002 9000016   Connecticut Technical Education and Career System 90000201149 9002616 Platt Technical High School CT Technical Education and Career Schools Career and Technical School No High 09 12 2019   grade_12                                                   178                                             178
2453131 2453131 CT     school 900002 9000016   Connecticut Technical Education and Career System 90000201149 9002616 Platt Technical High School CT Technical Education and Career Schools Career and Technical School No High 09 12 2019   pk_12_total 322 111 325   * *     0   35   514 294     19             95   808 322 111 325           0   35   514 294     19       95   808
2434286 2434286 CT     school 900002 9000016   Connecticut Technical Education and Career System 90000201141 9002516 Emmett O'Brien Technical High School CT Technical Education and Career Schools Career and Technical School No High 09 12 2019   kindergarten                                                   0                                             0
2435735 2435735 CT     school 900002 9000016   Connecticut Technical Education and Career System 90000201141 9002516 Emmett O'Brien Technical High School CT Technical Education and Career Schools Career and Technical School No High 09 12 2019   grade_1                                                   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]);