enrollments

Data source: Big Local News · About: Big Local

60,956 rows where state = "CT" sorted by school

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

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
2433279 2433279 CT     school 901800 600011   Guilford School District 90180000328 600711 A. Baldwin Middle School Public Schools Regular School No Middle 05 06 2019   kindergarten                                                   0                                             0
2434728 2434728 CT     school 901800 600011   Guilford School District 90180000328 600711 A. Baldwin Middle School Public Schools Regular School No Middle 05 06 2019   grade_1                                                   0                                             0
2436177 2436177 CT     school 901800 600011   Guilford School District 90180000328 600711 A. Baldwin Middle School Public Schools Regular School No Middle 05 06 2019   grade_2                                                   0                                             0
2437626 2437626 CT     school 901800 600011   Guilford School District 90180000328 600711 A. Baldwin Middle School Public Schools Regular School No Middle 05 06 2019   grade_3                                                   0                                             0
2439075 2439075 CT     school 901800 600011   Guilford School District 90180000328 600711 A. Baldwin Middle School Public Schools Regular School No Middle 05 06 2019   grade_4                                                   0                                             0
2440524 2440524 CT     school 901800 600011   Guilford School District 90180000328 600711 A. Baldwin Middle School Public Schools Regular School No Middle 05 06 2019   grade_5                                                   223                                             223
2441973 2441973 CT     school 901800 600011   Guilford School District 90180000328 600711 A. Baldwin Middle School Public Schools Regular School No Middle 05 06 2019   grade_6                                                   279                                             279
2443422 2443422 CT     school 901800 600011   Guilford School District 90180000328 600711 A. Baldwin Middle School Public Schools Regular School No Middle 05 06 2019   grade_7                                                   0                                             0
2444871 2444871 CT     school 901800 600011   Guilford School District 90180000328 600711 A. Baldwin Middle School Public Schools Regular School No Middle 05 06 2019   grade_8                                                   0                                             0
2446320 2446320 CT     school 901800 600011   Guilford School District 90180000328 600711 A. Baldwin Middle School Public Schools Regular School No Middle 05 06 2019   grade_9                                                   0                                             0
2447769 2447769 CT     school 901800 600011   Guilford School District 90180000328 600711 A. Baldwin Middle School Public Schools Regular School No Middle 05 06 2019   grade_10                                                   0                                             0
2449218 2449218 CT     school 901800 600011   Guilford School District 90180000328 600711 A. Baldwin Middle School Public Schools Regular School No Middle 05 06 2019   grade_11                                                   0                                             0
2450667 2450667 CT     school 901800 600011   Guilford School District 90180000328 600711 A. Baldwin Middle School Public Schools Regular School No Middle 05 06 2019   grade_12                                                   0                                             0
2452116 2452116 CT     school 901800 600011   Guilford School District 90180000328 600711 A. Baldwin Middle School Public Schools Regular School No Middle 05 06 2019   pk_12_total 413 8 40   0 22     0   19   270 232     11             67   502 413 8 40   0 22     0   19   270 232     11       67   502
2759153 2759153 CT     school 901800 600011   Guilford School District 90180000328 600711 A. Baldwin Middle School Public Schools Regular School No Middle 05 06 2020   kindergarten                                                   0                                             0
2760614 2760614 CT     school 901800 600011   Guilford School District 90180000328 600711 A. Baldwin Middle School Public Schools Regular School No Middle 05 06 2020   grade_1                                                   0                                             0
2762075 2762075 CT     school 901800 600011   Guilford School District 90180000328 600711 A. Baldwin Middle School Public Schools Regular School No Middle 05 06 2020   grade_2                                                   0                                             0
2763536 2763536 CT     school 901800 600011   Guilford School District 90180000328 600711 A. Baldwin Middle School Public Schools Regular School No Middle 05 06 2020   grade_3                                                   0                                             0
2764997 2764997 CT     school 901800 600011   Guilford School District 90180000328 600711 A. Baldwin Middle School Public Schools Regular School No Middle 05 06 2020   grade_4                                                   0                                             0
2766458 2766458 CT     school 901800 600011   Guilford School District 90180000328 600711 A. Baldwin Middle School Public Schools Regular School No Middle 05 06 2020   grade_5                                                   246                                             246
2767919 2767919 CT     school 901800 600011   Guilford School District 90180000328 600711 A. Baldwin Middle School Public Schools Regular School No Middle 05 06 2020   grade_6                                                   226                                             226
2769380 2769380 CT     school 901800 600011   Guilford School District 90180000328 600711 A. Baldwin Middle School Public Schools Regular School No Middle 05 06 2020   grade_7                                                   0                                             0
2770841 2770841 CT     school 901800 600011   Guilford School District 90180000328 600711 A. Baldwin Middle School Public Schools Regular School No Middle 05 06 2020   grade_8                                                   0                                             0
2772302 2772302 CT     school 901800 600011   Guilford School District 90180000328 600711 A. Baldwin Middle School Public Schools Regular School No Middle 05 06 2020   grade_9                                                   0                                             0
2773763 2773763 CT     school 901800 600011   Guilford School District 90180000328 600711 A. Baldwin Middle School Public Schools Regular School No Middle 05 06 2020   grade_10                                                   0                                             0
2775224 2775224 CT     school 901800 600011   Guilford School District 90180000328 600711 A. Baldwin Middle School Public Schools Regular School No Middle 05 06 2020   grade_11                                                   0                                             0
2776685 2776685 CT     school 901800 600011   Guilford School District 90180000328 600711 A. Baldwin Middle School Public Schools Regular School No Middle 05 06 2020   grade_12                                                   0                                             0
2778146 2778146 CT     school 901800 600011   Guilford School District 90180000328 600711 A. Baldwin Middle School Public Schools Regular School No Middle 05 06 2020   pk_12_total 389 * 31   0 21     *   25   251 221     11             54   472 389   31   0 21         25   251 221     11       54   472
2738931 2738931 CT     school 901800 600011   Guilford School District 90180000328 600711 A. Baldwin Middle School Public Schools Regular School No Middle 05 06 2021   kindergarten                                                   0                                             0
2740375 2740375 CT     school 901800 600011   Guilford School District 90180000328 600711 A. Baldwin Middle School Public Schools Regular School No Middle 05 06 2021   grade_1                                                   0                                             0
2741819 2741819 CT     school 901800 600011   Guilford School District 90180000328 600711 A. Baldwin Middle School Public Schools Regular School No Middle 05 06 2021   grade_2                                                   0                                             0
2743263 2743263 CT     school 901800 600011   Guilford School District 90180000328 600711 A. Baldwin Middle School Public Schools Regular School No Middle 05 06 2021   grade_3                                                   0                                             0
2744707 2744707 CT     school 901800 600011   Guilford School District 90180000328 600711 A. Baldwin Middle School Public Schools Regular School No Middle 05 06 2021   grade_4                                                   0                                             0
2746151 2746151 CT     school 901800 600011   Guilford School District 90180000328 600711 A. Baldwin Middle School Public Schools Regular School No Middle 05 06 2021   grade_5                                                   227                                             227
2747595 2747595 CT     school 901800 600011   Guilford School District 90180000328 600711 A. Baldwin Middle School Public Schools Regular School No Middle 05 06 2021   grade_6                                                   241                                             241
2749039 2749039 CT     school 901800 600011   Guilford School District 90180000328 600711 A. Baldwin Middle School Public Schools Regular School No Middle 05 06 2021   grade_7                                                   0                                             0
2750483 2750483 CT     school 901800 600011   Guilford School District 90180000328 600711 A. Baldwin Middle School Public Schools Regular School No Middle 05 06 2021   grade_8                                                   0                                             0
2751927 2751927 CT     school 901800 600011   Guilford School District 90180000328 600711 A. Baldwin Middle School Public Schools Regular School No Middle 05 06 2021   grade_9                                                   0                                             0
2753371 2753371 CT     school 901800 600011   Guilford School District 90180000328 600711 A. Baldwin Middle School Public Schools Regular School No Middle 05 06 2021   grade_10                                                   0                                             0
2754815 2754815 CT     school 901800 600011   Guilford School District 90180000328 600711 A. Baldwin Middle School Public Schools Regular School No Middle 05 06 2021   grade_11                                                   0                                             0
2756259 2756259 CT     school 901800 600011   Guilford School District 90180000328 600711 A. Baldwin Middle School Public Schools Regular School No Middle 05 06 2021   grade_12                                                   0                                             0
2757703 2757703 CT     school 901800 600011   Guilford School District 90180000328 600711 A. Baldwin Middle School Public Schools Regular School No Middle 05 06 2021   pk_12_total 385 * 30   0 21     *   26   244 224     10             66   468 385   30   0 21         26   244 224     10       66   468
2434281 2434281 CT     school 900002 9000016   Connecticut Technical Education and Career System 90000201136 9001516 A. I. Prince Technical High School CT Technical Education and Career Schools Career and Technical School No High 09 12 2019   kindergarten                                                   0                                             0
2435730 2435730 CT     school 900002 9000016   Connecticut Technical Education and Career System 90000201136 9001516 A. I. Prince Technical High School CT Technical Education and Career Schools Career and Technical School No High 09 12 2019   grade_1                                                   0                                             0
2437179 2437179 CT     school 900002 9000016   Connecticut Technical Education and Career System 90000201136 9001516 A. I. Prince Technical High School CT Technical Education and Career Schools Career and Technical School No High 09 12 2019   grade_2                                                   0                                             0
2438628 2438628 CT     school 900002 9000016   Connecticut Technical Education and Career System 90000201136 9001516 A. I. Prince Technical High School CT Technical Education and Career Schools Career and Technical School No High 09 12 2019   grade_3                                                   0                                             0
2440077 2440077 CT     school 900002 9000016   Connecticut Technical Education and Career System 90000201136 9001516 A. I. Prince Technical High School CT Technical Education and Career Schools Career and Technical School No High 09 12 2019   grade_4                                                   0                                             0
2441526 2441526 CT     school 900002 9000016   Connecticut Technical Education and Career System 90000201136 9001516 A. I. Prince Technical High School CT Technical Education and Career Schools Career and Technical School No High 09 12 2019   grade_5                                                   0                                             0
2442975 2442975 CT     school 900002 9000016   Connecticut Technical Education and Career System 90000201136 9001516 A. I. Prince Technical High School CT Technical Education and Career Schools Career and Technical School No High 09 12 2019   grade_6                                                   0                                             0
2444424 2444424 CT     school 900002 9000016   Connecticut Technical Education and Career System 90000201136 9001516 A. I. Prince Technical High School CT Technical Education and Career Schools Career and Technical School No High 09 12 2019   grade_7                                                   0                                             0
2445873 2445873 CT     school 900002 9000016   Connecticut Technical Education and Career System 90000201136 9001516 A. I. Prince Technical High School CT Technical Education and Career Schools Career and Technical School No High 09 12 2019   grade_8                                                   0                                             0
2447322 2447322 CT     school 900002 9000016   Connecticut Technical Education and Career System 90000201136 9001516 A. I. Prince Technical High School CT Technical Education and Career Schools Career and Technical School No High 09 12 2019   grade_9                                                   183                                             183
2448771 2448771 CT     school 900002 9000016   Connecticut Technical Education and Career System 90000201136 9001516 A. I. Prince Technical High School CT Technical Education and Career Schools Career and Technical School No High 09 12 2019   grade_10                                                   195                                             195
2450220 2450220 CT     school 900002 9000016   Connecticut Technical Education and Career System 90000201136 9001516 A. I. Prince Technical High School CT Technical Education and Career Schools Career and Technical School No High 09 12 2019   grade_11                                                   150                                             150
2451669 2451669 CT     school 900002 9000016   Connecticut Technical Education and Career System 90000201136 9001516 A. I. Prince Technical High School CT Technical Education and Career Schools Career and Technical School No High 09 12 2019   grade_12                                                   149                                             149
2453118 2453118 CT     school 900002 9000016   Connecticut Technical Education and Career System 90000201136 9001516 A. I. Prince Technical High School CT Technical Education and Career Schools Career and Technical School No High 09 12 2019   pk_12_total 32 177 444   * 13     *   *   339 338     71             64   677 32 177 444     13             339 338     71       64   677
2760163 2760163 CT     school 900002 9000016   Connecticut Technical Education and Career System 90000201136 9001516 A. I. Prince Technical High School CT Technical Education and Career Schools Career and Technical School No High 09 12 2020   kindergarten                                                   0                                             0
2761624 2761624 CT     school 900002 9000016   Connecticut Technical Education and Career System 90000201136 9001516 A. I. Prince Technical High School CT Technical Education and Career Schools Career and Technical School No High 09 12 2020   grade_1                                                   0                                             0
2763085 2763085 CT     school 900002 9000016   Connecticut Technical Education and Career System 90000201136 9001516 A. I. Prince Technical High School CT Technical Education and Career Schools Career and Technical School No High 09 12 2020   grade_2                                                   0                                             0
2764546 2764546 CT     school 900002 9000016   Connecticut Technical Education and Career System 90000201136 9001516 A. I. Prince Technical High School CT Technical Education and Career Schools Career and Technical School No High 09 12 2020   grade_3                                                   0                                             0
2766007 2766007 CT     school 900002 9000016   Connecticut Technical Education and Career System 90000201136 9001516 A. I. Prince Technical High School CT Technical Education and Career Schools Career and Technical School No High 09 12 2020   grade_4                                                   0                                             0
2767468 2767468 CT     school 900002 9000016   Connecticut Technical Education and Career System 90000201136 9001516 A. I. Prince Technical High School CT Technical Education and Career Schools Career and Technical School No High 09 12 2020   grade_5                                                   0                                             0
2768929 2768929 CT     school 900002 9000016   Connecticut Technical Education and Career System 90000201136 9001516 A. I. Prince Technical High School CT Technical Education and Career Schools Career and Technical School No High 09 12 2020   grade_6                                                   0                                             0
2770390 2770390 CT     school 900002 9000016   Connecticut Technical Education and Career System 90000201136 9001516 A. I. Prince Technical High School CT Technical Education and Career Schools Career and Technical School No High 09 12 2020   grade_7                                                   0                                             0
2771851 2771851 CT     school 900002 9000016   Connecticut Technical Education and Career System 90000201136 9001516 A. I. Prince Technical High School CT Technical Education and Career Schools Career and Technical School No High 09 12 2020   grade_8                                                   0                                             0
2773312 2773312 CT     school 900002 9000016   Connecticut Technical Education and Career System 90000201136 9001516 A. I. Prince Technical High School CT Technical Education and Career Schools Career and Technical School No High 09 12 2020   grade_9                                                   215                                             215
2774773 2774773 CT     school 900002 9000016   Connecticut Technical Education and Career System 90000201136 9001516 A. I. Prince Technical High School CT Technical Education and Career Schools Career and Technical School No High 09 12 2020   grade_10                                                   181                                             181
2776234 2776234 CT     school 900002 9000016   Connecticut Technical Education and Career System 90000201136 9001516 A. I. Prince Technical High School CT Technical Education and Career Schools Career and Technical School No High 09 12 2020   grade_11                                                   177                                             177
2777695 2777695 CT     school 900002 9000016   Connecticut Technical Education and Career System 90000201136 9001516 A. I. Prince Technical High School CT Technical Education and Career Schools Career and Technical School No High 09 12 2020   grade_12                                                   143                                             143
2779156 2779156 CT     school 900002 9000016   Connecticut Technical Education and Career System 90000201136 9001516 A. I. Prince Technical High School CT Technical Education and Career Schools Career and Technical School No High 09 12 2020   pk_12_total 39 177 471   * 14     *   12   369 347     83             92   716 39 177 471     14         12   369 347     83       92   716
2739933 2739933 CT     school 900002 9000016   Connecticut Technical Education and Career System 90000201136 9001516 A. I. Prince Technical High School CT Technical Education and Career Schools Career and Technical School No High 09 12 2021   kindergarten                                                   0                                             0
2741377 2741377 CT     school 900002 9000016   Connecticut Technical Education and Career System 90000201136 9001516 A. I. Prince Technical High School CT Technical Education and Career Schools Career and Technical School No High 09 12 2021   grade_1                                                   0                                             0
2742821 2742821 CT     school 900002 9000016   Connecticut Technical Education and Career System 90000201136 9001516 A. I. Prince Technical High School CT Technical Education and Career Schools Career and Technical School No High 09 12 2021   grade_2                                                   0                                             0
2744265 2744265 CT     school 900002 9000016   Connecticut Technical Education and Career System 90000201136 9001516 A. I. Prince Technical High School CT Technical Education and Career Schools Career and Technical School No High 09 12 2021   grade_3                                                   0                                             0
2745709 2745709 CT     school 900002 9000016   Connecticut Technical Education and Career System 90000201136 9001516 A. I. Prince Technical High School CT Technical Education and Career Schools Career and Technical School No High 09 12 2021   grade_4                                                   0                                             0
2747153 2747153 CT     school 900002 9000016   Connecticut Technical Education and Career System 90000201136 9001516 A. I. Prince Technical High School CT Technical Education and Career Schools Career and Technical School No High 09 12 2021   grade_5                                                   0                                             0
2748597 2748597 CT     school 900002 9000016   Connecticut Technical Education and Career System 90000201136 9001516 A. I. Prince Technical High School CT Technical Education and Career Schools Career and Technical School No High 09 12 2021   grade_6                                                   0                                             0
2750041 2750041 CT     school 900002 9000016   Connecticut Technical Education and Career System 90000201136 9001516 A. I. Prince Technical High School CT Technical Education and Career Schools Career and Technical School No High 09 12 2021   grade_7                                                   0                                             0
2751485 2751485 CT     school 900002 9000016   Connecticut Technical Education and Career System 90000201136 9001516 A. I. Prince Technical High School CT Technical Education and Career Schools Career and Technical School No High 09 12 2021   grade_8                                                   0                                             0
2752929 2752929 CT     school 900002 9000016   Connecticut Technical Education and Career System 90000201136 9001516 A. I. Prince Technical High School CT Technical Education and Career Schools Career and Technical School No High 09 12 2021   grade_9                                                   227                                             227
2754373 2754373 CT     school 900002 9000016   Connecticut Technical Education and Career System 90000201136 9001516 A. I. Prince Technical High School CT Technical Education and Career Schools Career and Technical School No High 09 12 2021   grade_10                                                   205                                             205
2755817 2755817 CT     school 900002 9000016   Connecticut Technical Education and Career System 90000201136 9001516 A. I. Prince Technical High School CT Technical Education and Career Schools Career and Technical School No High 09 12 2021   grade_11                                                   175                                             175
2757261 2757261 CT     school 900002 9000016   Connecticut Technical Education and Career System 90000201136 9001516 A. I. Prince Technical High School CT Technical Education and Career Schools Career and Technical School No High 09 12 2021   grade_12                                                   174                                             174
2758705 2758705 CT     school 900002 9000016   Connecticut Technical Education and Career System 90000201136 9001516 A. I. Prince Technical High School CT Technical Education and Career Schools Career and Technical School No High 09 12 2021   pk_12_total 42 204 500   * 13     *   18   406 375     91             124   781 42 204 500     13         18   406 375     91       124   781
2433276 2433276 CT     school 901800 600011   Guilford School District 90180000329 600611 A. W. Cox School Public Schools Regular School No Elementary KG 04 2019   kindergarten                                                   52                                             52
2434725 2434725 CT     school 901800 600011   Guilford School District 90180000329 600611 A. W. Cox School Public Schools Regular School No Elementary KG 04 2019   grade_1                                                   40                                             40
2436174 2436174 CT     school 901800 600011   Guilford School District 90180000329 600611 A. W. Cox School Public Schools Regular School No Elementary KG 04 2019   grade_2                                                   58                                             58
2437623 2437623 CT     school 901800 600011   Guilford School District 90180000329 600611 A. W. Cox School Public Schools Regular School No Elementary KG 04 2019   grade_3                                                   47                                             47
2439072 2439072 CT     school 901800 600011   Guilford School District 90180000329 600611 A. W. Cox School Public Schools Regular School No Elementary KG 04 2019   grade_4                                                   69                                             69
2440521 2440521 CT     school 901800 600011   Guilford School District 90180000329 600611 A. W. Cox School Public Schools Regular School No Elementary KG 04 2019   grade_5                                                   0                                             0
2441970 2441970 CT     school 901800 600011   Guilford School District 90180000329 600611 A. W. Cox School Public Schools Regular School No Elementary KG 04 2019   grade_6                                                   0                                             0
2443419 2443419 CT     school 901800 600011   Guilford School District 90180000329 600611 A. W. Cox School Public Schools Regular School No Elementary KG 04 2019   grade_7                                                   0                                             0
2444868 2444868 CT     school 901800 600011   Guilford School District 90180000329 600611 A. W. Cox School Public Schools Regular School No Elementary KG 04 2019   grade_8                                                   0                                             0
2446317 2446317 CT     school 901800 600011   Guilford School District 90180000329 600611 A. W. Cox School Public Schools Regular School No Elementary KG 04 2019   grade_9                                                   0                                             0
2447766 2447766 CT     school 901800 600011   Guilford School District 90180000329 600611 A. W. Cox School Public Schools Regular School No Elementary KG 04 2019   grade_10                                                   0                                             0
2449215 2449215 CT     school 901800 600011   Guilford School District 90180000329 600611 A. W. Cox School Public Schools Regular School No Elementary KG 04 2019   grade_11                                                   0                                             0
2450664 2450664 CT     school 901800 600011   Guilford School District 90180000329 600611 A. W. Cox School Public Schools Regular School No Elementary KG 04 2019   grade_12                                                   0                                             0
2452113 2452113 CT     school 901800 600011   Guilford School District 90180000329 600611 A. W. Cox School Public Schools Regular School No Elementary KG 04 2019   pk_12_total 225 * 18   0 *     0   12   138 128     11             18   266 225   18   0       0   12   138 128     11       18   266
2759150 2759150 CT     school 901800 600011   Guilford School District 90180000329 600611 A. W. Cox School Public Schools Regular School No Elementary KG 04 2020   kindergarten                                                   46                                             46
2760611 2760611 CT     school 901800 600011   Guilford School District 90180000329 600611 A. W. Cox School Public Schools Regular School No Elementary KG 04 2020   grade_1                                                   54                                             54

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