enrollments

Data source: Big Local News · About: Big Local

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

✎ View and edit SQL

This data as json, CSV (advanced)

grade ✖

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
2442069 2442069 CT     school 900010 2640013   Integrated Day Charter School District 90001000775 2640113 Integrated Day Charter School Public Charter Schools Regular School Yes Elementary PK 08 2019   grade_6                                                   38                                             38
2443518 2443518 CT     school 900010 2640013   Integrated Day Charter School District 90001000775 2640113 Integrated Day Charter School Public Charter Schools Regular School Yes Elementary PK 08 2019   grade_7                                                   35                                             35
2444967 2444967 CT     school 900010 2640013   Integrated Day Charter School District 90001000775 2640113 Integrated Day Charter School Public Charter Schools Regular School Yes Elementary PK 08 2019   grade_8                                                   31                                             31
2446416 2446416 CT     school 900010 2640013   Integrated Day Charter School District 90001000775 2640113 Integrated Day Charter School Public Charter Schools Regular School Yes Elementary PK 08 2019   grade_9                                                   0                                             0
2447865 2447865 CT     school 900010 2640013   Integrated Day Charter School District 90001000775 2640113 Integrated Day Charter School Public Charter Schools Regular School Yes Elementary PK 08 2019   grade_10                                                   0                                             0
2449314 2449314 CT     school 900010 2640013   Integrated Day Charter School District 90001000775 2640113 Integrated Day Charter School Public Charter Schools Regular School Yes Elementary PK 08 2019   grade_11                                                   0                                             0
2450763 2450763 CT     school 900010 2640013   Integrated Day Charter School District 90001000775 2640113 Integrated Day Charter School Public Charter Schools Regular School Yes Elementary PK 08 2019   grade_12                                                   0                                             0
2452212 2452212 CT     school 900010 2640013   Integrated Day Charter School District 90001000775 2640113 Integrated Day Charter School Public Charter Schools Regular School Yes Elementary PK 08 2019   pk_12_total 165 * 52   * 47     0   39   171 166     31             29   337 165   52     47     0   39   171 166     31       29   337
2739023 2739023 CT     school 900010 2640013   Integrated Day Charter School District 90001000775 2640113 Integrated Day Charter School Public Charter Schools Regular School Yes Elementary PK 08 2021   kindergarten                                                   33                                             33
2740467 2740467 CT     school 900010 2640013   Integrated Day Charter School District 90001000775 2640113 Integrated Day Charter School Public Charter Schools Regular School Yes Elementary PK 08 2021   grade_1                                                   38                                             38
2741911 2741911 CT     school 900010 2640013   Integrated Day Charter School District 90001000775 2640113 Integrated Day Charter School Public Charter Schools Regular School Yes Elementary PK 08 2021   grade_2                                                   29                                             29
2743355 2743355 CT     school 900010 2640013   Integrated Day Charter School District 90001000775 2640113 Integrated Day Charter School Public Charter Schools Regular School Yes Elementary PK 08 2021   grade_3                                                   34                                             34
2744799 2744799 CT     school 900010 2640013   Integrated Day Charter School District 90001000775 2640113 Integrated Day Charter School Public Charter Schools Regular School Yes Elementary PK 08 2021   grade_4                                                   32                                             32
2746243 2746243 CT     school 900010 2640013   Integrated Day Charter School District 90001000775 2640113 Integrated Day Charter School Public Charter Schools Regular School Yes Elementary PK 08 2021   grade_5                                                   33                                             33
2747687 2747687 CT     school 900010 2640013   Integrated Day Charter School District 90001000775 2640113 Integrated Day Charter School Public Charter Schools Regular School Yes Elementary PK 08 2021   grade_6                                                   40                                             40
2749131 2749131 CT     school 900010 2640013   Integrated Day Charter School District 90001000775 2640113 Integrated Day Charter School Public Charter Schools Regular School Yes Elementary PK 08 2021   grade_7                                                   39                                             39
2750575 2750575 CT     school 900010 2640013   Integrated Day Charter School District 90001000775 2640113 Integrated Day Charter School Public Charter Schools Regular School Yes Elementary PK 08 2021   grade_8                                                   42                                             42
2752019 2752019 CT     school 900010 2640013   Integrated Day Charter School District 90001000775 2640113 Integrated Day Charter School Public Charter Schools Regular School Yes Elementary PK 08 2021   grade_9                                                   0                                             0
2753463 2753463 CT     school 900010 2640013   Integrated Day Charter School District 90001000775 2640113 Integrated Day Charter School Public Charter Schools Regular School Yes Elementary PK 08 2021   grade_10                                                   0                                             0
2754907 2754907 CT     school 900010 2640013   Integrated Day Charter School District 90001000775 2640113 Integrated Day Charter School Public Charter Schools Regular School Yes Elementary PK 08 2021   grade_11                                                   0                                             0
2756351 2756351 CT     school 900010 2640013   Integrated Day Charter School District 90001000775 2640113 Integrated Day Charter School Public Charter Schools Regular School Yes Elementary PK 08 2021   grade_12                                                   0                                             0
2757795 2757795 CT     school 900010 2640013   Integrated Day Charter School District 90001000775 2640113 Integrated Day Charter School Public Charter Schools Regular School Yes Elementary PK 08 2021   pk_12_total 162 40 62   * 49     0   *   172 181     25             32   353 162 40 62     49     0       172 181     25       32   353
2759246 2759246 CT     school 900010 2640013   Integrated Day Charter School District 90001000775 2640113 Integrated Day Charter School Public Charter Schools Regular School Yes Elementary PK 08 2020   kindergarten                                                   38                                             38
2760707 2760707 CT     school 900010 2640013   Integrated Day Charter School District 90001000775 2640113 Integrated Day Charter School Public Charter Schools Regular School Yes Elementary PK 08 2020   grade_1                                                   31                                             31
2762168 2762168 CT     school 900010 2640013   Integrated Day Charter School District 90001000775 2640113 Integrated Day Charter School Public Charter Schools Regular School Yes Elementary PK 08 2020   grade_2                                                   33                                             33
2763629 2763629 CT     school 900010 2640013   Integrated Day Charter School District 90001000775 2640113 Integrated Day Charter School Public Charter Schools Regular School Yes Elementary PK 08 2020   grade_3                                                   33                                             33
2765090 2765090 CT     school 900010 2640013   Integrated Day Charter School District 90001000775 2640113 Integrated Day Charter School Public Charter Schools Regular School Yes Elementary PK 08 2020   grade_4                                                   35                                             35
2766551 2766551 CT     school 900010 2640013   Integrated Day Charter School District 90001000775 2640113 Integrated Day Charter School Public Charter Schools Regular School Yes Elementary PK 08 2020   grade_5                                                   34                                             34
2768012 2768012 CT     school 900010 2640013   Integrated Day Charter School District 90001000775 2640113 Integrated Day Charter School Public Charter Schools Regular School Yes Elementary PK 08 2020   grade_6                                                   40                                             40
2769473 2769473 CT     school 900010 2640013   Integrated Day Charter School District 90001000775 2640113 Integrated Day Charter School Public Charter Schools Regular School Yes Elementary PK 08 2020   grade_7                                                   40                                             40
2770934 2770934 CT     school 900010 2640013   Integrated Day Charter School District 90001000775 2640113 Integrated Day Charter School Public Charter Schools Regular School Yes Elementary PK 08 2020   grade_8                                                   34                                             34
2772395 2772395 CT     school 900010 2640013   Integrated Day Charter School District 90001000775 2640113 Integrated Day Charter School Public Charter Schools Regular School Yes Elementary PK 08 2020   grade_9                                                   0                                             0
2773856 2773856 CT     school 900010 2640013   Integrated Day Charter School District 90001000775 2640113 Integrated Day Charter School Public Charter Schools Regular School Yes Elementary PK 08 2020   grade_10                                                   0                                             0
2775317 2775317 CT     school 900010 2640013   Integrated Day Charter School District 90001000775 2640113 Integrated Day Charter School Public Charter Schools Regular School Yes Elementary PK 08 2020   grade_11                                                   0                                             0
2776778 2776778 CT     school 900010 2640013   Integrated Day Charter School District 90001000775 2640113 Integrated Day Charter School Public Charter Schools Regular School Yes Elementary PK 08 2020   grade_12                                                   0                                             0
2778239 2778239 CT     school 900010 2640013   Integrated Day Charter School District 90001000775 2640113 Integrated Day Charter School Public Charter Schools Regular School Yes Elementary PK 08 2020   pk_12_total 166 * 63   * 49     0   37   173 179     29             32   352 166   63     49     0   37   173 179     29       32   352
2434248 2434248 CT     school 900011 2650013   Interdistrict School for Arts and Comm District 90001100797 2655113 Interdistrict School For Arts And Communication Public Charter Schools Regular School Yes Middle 06 08 2019   kindergarten                                                   0                                             0
2435697 2435697 CT     school 900011 2650013   Interdistrict School for Arts and Comm District 90001100797 2655113 Interdistrict School For Arts And Communication Public Charter Schools Regular School Yes Middle 06 08 2019   grade_1                                                   0                                             0
2437146 2437146 CT     school 900011 2650013   Interdistrict School for Arts and Comm District 90001100797 2655113 Interdistrict School For Arts And Communication Public Charter Schools Regular School Yes Middle 06 08 2019   grade_2                                                   0                                             0
2438595 2438595 CT     school 900011 2650013   Interdistrict School for Arts and Comm District 90001100797 2655113 Interdistrict School For Arts And Communication Public Charter Schools Regular School Yes Middle 06 08 2019   grade_3                                                   0                                             0
2440044 2440044 CT     school 900011 2650013   Interdistrict School for Arts and Comm District 90001100797 2655113 Interdistrict School For Arts And Communication Public Charter Schools Regular School Yes Middle 06 08 2019   grade_4                                                   0                                             0
2441493 2441493 CT     school 900011 2650013   Interdistrict School for Arts and Comm District 90001100797 2655113 Interdistrict School For Arts And Communication Public Charter Schools Regular School Yes Middle 06 08 2019   grade_5                                                   0                                             0
2442942 2442942 CT     school 900011 2650013   Interdistrict School for Arts and Comm District 90001100797 2655113 Interdistrict School For Arts And Communication Public Charter Schools Regular School Yes Middle 06 08 2019   grade_6                                                   97                                             97
2444391 2444391 CT     school 900011 2650013   Interdistrict School for Arts and Comm District 90001100797 2655113 Interdistrict School For Arts And Communication Public Charter Schools Regular School Yes Middle 06 08 2019   grade_7                                                   90                                             90
2445840 2445840 CT     school 900011 2650013   Interdistrict School for Arts and Comm District 90001100797 2655113 Interdistrict School For Arts And Communication Public Charter Schools Regular School Yes Middle 06 08 2019   grade_8                                                   91                                             91
2447289 2447289 CT     school 900011 2650013   Interdistrict School for Arts and Comm District 90001100797 2655113 Interdistrict School For Arts And Communication Public Charter Schools Regular School Yes Middle 06 08 2019   grade_9                                                   0                                             0
2448738 2448738 CT     school 900011 2650013   Interdistrict School for Arts and Comm District 90001100797 2655113 Interdistrict School For Arts And Communication Public Charter Schools Regular School Yes Middle 06 08 2019   grade_10                                                   0                                             0
2450187 2450187 CT     school 900011 2650013   Interdistrict School for Arts and Comm District 90001100797 2655113 Interdistrict School For Arts And Communication Public Charter Schools Regular School Yes Middle 06 08 2019   grade_11                                                   0                                             0
2451636 2451636 CT     school 900011 2650013   Interdistrict School for Arts and Comm District 90001100797 2655113 Interdistrict School For Arts And Communication Public Charter Schools Regular School Yes Middle 06 08 2019   grade_12                                                   0                                             0
2453085 2453085 CT     school 900011 2650013   Interdistrict School for Arts and Comm District 90001100797 2655113 Interdistrict School For Arts And Communication Public Charter Schools Regular School Yes Middle 06 08 2019   pk_12_total 54 49 160   * *     *   *   133 145     29             38   278 54 49 160                   133 145     29       38   278
2739900 2739900 CT     school 900011 2650013   Interdistrict School for Arts and Comm District 90001100797 2655113 Interdistrict School For Arts And Communication Public Charter Schools Regular School Yes Middle 06 08 2021   kindergarten                                                   0                                             0
2741344 2741344 CT     school 900011 2650013   Interdistrict School for Arts and Comm District 90001100797 2655113 Interdistrict School For Arts And Communication Public Charter Schools Regular School Yes Middle 06 08 2021   grade_1                                                   0                                             0
2742788 2742788 CT     school 900011 2650013   Interdistrict School for Arts and Comm District 90001100797 2655113 Interdistrict School For Arts And Communication Public Charter Schools Regular School Yes Middle 06 08 2021   grade_2                                                   0                                             0
2744232 2744232 CT     school 900011 2650013   Interdistrict School for Arts and Comm District 90001100797 2655113 Interdistrict School For Arts And Communication Public Charter Schools Regular School Yes Middle 06 08 2021   grade_3                                                   0                                             0
2745676 2745676 CT     school 900011 2650013   Interdistrict School for Arts and Comm District 90001100797 2655113 Interdistrict School For Arts And Communication Public Charter Schools Regular School Yes Middle 06 08 2021   grade_4                                                   0                                             0
2747120 2747120 CT     school 900011 2650013   Interdistrict School for Arts and Comm District 90001100797 2655113 Interdistrict School For Arts And Communication Public Charter Schools Regular School Yes Middle 06 08 2021   grade_5                                                   0                                             0
2748564 2748564 CT     school 900011 2650013   Interdistrict School for Arts and Comm District 90001100797 2655113 Interdistrict School For Arts And Communication Public Charter Schools Regular School Yes Middle 06 08 2021   grade_6                                                   94                                             94
2750008 2750008 CT     school 900011 2650013   Interdistrict School for Arts and Comm District 90001100797 2655113 Interdistrict School For Arts And Communication Public Charter Schools Regular School Yes Middle 06 08 2021   grade_7                                                   93                                             93
2751452 2751452 CT     school 900011 2650013   Interdistrict School for Arts and Comm District 90001100797 2655113 Interdistrict School For Arts And Communication Public Charter Schools Regular School Yes Middle 06 08 2021   grade_8                                                   94                                             94
2752896 2752896 CT     school 900011 2650013   Interdistrict School for Arts and Comm District 90001100797 2655113 Interdistrict School For Arts And Communication Public Charter Schools Regular School Yes Middle 06 08 2021   grade_9                                                   0                                             0
2754340 2754340 CT     school 900011 2650013   Interdistrict School for Arts and Comm District 90001100797 2655113 Interdistrict School For Arts And Communication Public Charter Schools Regular School Yes Middle 06 08 2021   grade_10                                                   0                                             0
2755784 2755784 CT     school 900011 2650013   Interdistrict School for Arts and Comm District 90001100797 2655113 Interdistrict School For Arts And Communication Public Charter Schools Regular School Yes Middle 06 08 2021   grade_11                                                   0                                             0
2757228 2757228 CT     school 900011 2650013   Interdistrict School for Arts and Comm District 90001100797 2655113 Interdistrict School For Arts And Communication Public Charter Schools Regular School Yes Middle 06 08 2021   grade_12                                                   0                                             0
2758672 2758672 CT     school 900011 2650013   Interdistrict School for Arts and Comm District 90001100797 2655113 Interdistrict School For Arts And Communication Public Charter Schools Regular School Yes Middle 06 08 2021   pk_12_total 44 51 176   * *     *   *   143 138     54             54   281 44 51 176                   143 138     54       54   281
2760128 2760128 CT     school 900011 2650013   Interdistrict School for Arts and Comm District 90001100797 2655113 Interdistrict School For Arts And Communication Public Charter Schools Regular School Yes Middle 06 08 2020   kindergarten                                                   0                                             0
2761589 2761589 CT     school 900011 2650013   Interdistrict School for Arts and Comm District 90001100797 2655113 Interdistrict School For Arts And Communication Public Charter Schools Regular School Yes Middle 06 08 2020   grade_1                                                   0                                             0
2763050 2763050 CT     school 900011 2650013   Interdistrict School for Arts and Comm District 90001100797 2655113 Interdistrict School For Arts And Communication Public Charter Schools Regular School Yes Middle 06 08 2020   grade_2                                                   0                                             0
2764511 2764511 CT     school 900011 2650013   Interdistrict School for Arts and Comm District 90001100797 2655113 Interdistrict School For Arts And Communication Public Charter Schools Regular School Yes Middle 06 08 2020   grade_3                                                   0                                             0
2765972 2765972 CT     school 900011 2650013   Interdistrict School for Arts and Comm District 90001100797 2655113 Interdistrict School For Arts And Communication Public Charter Schools Regular School Yes Middle 06 08 2020   grade_4                                                   0                                             0
2767433 2767433 CT     school 900011 2650013   Interdistrict School for Arts and Comm District 90001100797 2655113 Interdistrict School For Arts And Communication Public Charter Schools Regular School Yes Middle 06 08 2020   grade_5                                                   0                                             0
2768894 2768894 CT     school 900011 2650013   Interdistrict School for Arts and Comm District 90001100797 2655113 Interdistrict School For Arts And Communication Public Charter Schools Regular School Yes Middle 06 08 2020   grade_6                                                   96                                             96
2770355 2770355 CT     school 900011 2650013   Interdistrict School for Arts and Comm District 90001100797 2655113 Interdistrict School For Arts And Communication Public Charter Schools Regular School Yes Middle 06 08 2020   grade_7                                                   95                                             95
2771816 2771816 CT     school 900011 2650013   Interdistrict School for Arts and Comm District 90001100797 2655113 Interdistrict School For Arts And Communication Public Charter Schools Regular School Yes Middle 06 08 2020   grade_8                                                   88                                             88
2773277 2773277 CT     school 900011 2650013   Interdistrict School for Arts and Comm District 90001100797 2655113 Interdistrict School For Arts And Communication Public Charter Schools Regular School Yes Middle 06 08 2020   grade_9                                                   0                                             0
2774738 2774738 CT     school 900011 2650013   Interdistrict School for Arts and Comm District 90001100797 2655113 Interdistrict School For Arts And Communication Public Charter Schools Regular School Yes Middle 06 08 2020   grade_10                                                   0                                             0
2776199 2776199 CT     school 900011 2650013   Interdistrict School for Arts and Comm District 90001100797 2655113 Interdistrict School For Arts And Communication Public Charter Schools Regular School Yes Middle 06 08 2020   grade_11                                                   0                                             0
2777660 2777660 CT     school 900011 2650013   Interdistrict School for Arts and Comm District 90001100797 2655113 Interdistrict School For Arts And Communication Public Charter Schools Regular School Yes Middle 06 08 2020   grade_12                                                   0                                             0
2779121 2779121 CT     school 900011 2650013   Interdistrict School for Arts and Comm District 90001100797 2655113 Interdistrict School For Arts And Communication Public Charter Schools Regular School Yes Middle 06 08 2020   pk_12_total 49 42 174   * 6     *   0   143 136     55             51   279 49 42 174     6         0   143 136     55       51   279
2434280 2434280 CT     school 900014 2680013   Common Ground High School District 90001400807 2686113 Common Ground High School Public Charter Schools Regular School Yes High 09 12 2019   kindergarten                                                   0                                             0
2435729 2435729 CT     school 900014 2680013   Common Ground High School District 90001400807 2686113 Common Ground High School Public Charter Schools Regular School Yes High 09 12 2019   grade_1                                                   0                                             0
2437178 2437178 CT     school 900014 2680013   Common Ground High School District 90001400807 2686113 Common Ground High School Public Charter Schools Regular School Yes High 09 12 2019   grade_2                                                   0                                             0
2438627 2438627 CT     school 900014 2680013   Common Ground High School District 90001400807 2686113 Common Ground High School Public Charter Schools Regular School Yes High 09 12 2019   grade_3                                                   0                                             0
2440076 2440076 CT     school 900014 2680013   Common Ground High School District 90001400807 2686113 Common Ground High School Public Charter Schools Regular School Yes High 09 12 2019   grade_4                                                   0                                             0
2441525 2441525 CT     school 900014 2680013   Common Ground High School District 90001400807 2686113 Common Ground High School Public Charter Schools Regular School Yes High 09 12 2019   grade_5                                                   0                                             0
2442974 2442974 CT     school 900014 2680013   Common Ground High School District 90001400807 2686113 Common Ground High School Public Charter Schools Regular School Yes High 09 12 2019   grade_6                                                   0                                             0
2444423 2444423 CT     school 900014 2680013   Common Ground High School District 90001400807 2686113 Common Ground High School Public Charter Schools Regular School Yes High 09 12 2019   grade_7                                                   0                                             0
2445872 2445872 CT     school 900014 2680013   Common Ground High School District 90001400807 2686113 Common Ground High School Public Charter Schools Regular School Yes High 09 12 2019   grade_8                                                   0                                             0
2447321 2447321 CT     school 900014 2680013   Common Ground High School District 90001400807 2686113 Common Ground High School Public Charter Schools Regular School Yes High 09 12 2019   grade_9                                                   70                                             70
2448770 2448770 CT     school 900014 2680013   Common Ground High School District 90001400807 2686113 Common Ground High School Public Charter Schools Regular School Yes High 09 12 2019   grade_10                                                   61                                             61
2450219 2450219 CT     school 900014 2680013   Common Ground High School District 90001400807 2686113 Common Ground High School Public Charter Schools Regular School Yes High 09 12 2019   grade_11                                                   47                                             47
2451668 2451668 CT     school 900014 2680013   Common Ground High School District 90001400807 2686113 Common Ground High School Public Charter Schools Regular School Yes High 09 12 2019   grade_12                                                   38                                             38
2453117 2453117 CT     school 900014 2680013   Common Ground High School District 90001400807 2686113 Common Ground High School Public Charter Schools Regular School Yes High 09 12 2019   pk_12_total 47 87 74   0 *     0   *   136 80     12             49   216 47 87 74   0       0       136 80     12       49   216
2739932 2739932 CT     school 900014 2680013   Common Ground High School District 90001400807 2686113 Common Ground High School Public Charter Schools Regular School Yes High 09 12 2021   kindergarten                                                   0                                             0
2741376 2741376 CT     school 900014 2680013   Common Ground High School District 90001400807 2686113 Common Ground High School Public Charter Schools Regular School Yes High 09 12 2021   grade_1                                                   0                                             0
2742820 2742820 CT     school 900014 2680013   Common Ground High School District 90001400807 2686113 Common Ground High School Public Charter Schools Regular School Yes High 09 12 2021   grade_2                                                   0                                             0
2744264 2744264 CT     school 900014 2680013   Common Ground High School District 90001400807 2686113 Common Ground High School Public Charter Schools Regular School Yes High 09 12 2021   grade_3                                                   0                                             0
2745708 2745708 CT     school 900014 2680013   Common Ground High School District 90001400807 2686113 Common Ground High School Public Charter Schools Regular School Yes High 09 12 2021   grade_4                                                   0                                             0
2747152 2747152 CT     school 900014 2680013   Common Ground High School District 90001400807 2686113 Common Ground High School Public Charter Schools Regular School Yes High 09 12 2021   grade_5                                                   0                                             0
2748596 2748596 CT     school 900014 2680013   Common Ground High School District 90001400807 2686113 Common Ground High School Public Charter Schools Regular School Yes High 09 12 2021   grade_6                                                   0                                             0
2750040 2750040 CT     school 900014 2680013   Common Ground High School District 90001400807 2686113 Common Ground High School Public Charter Schools Regular School Yes High 09 12 2021   grade_7                                                   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]);