enrollments

Data source: Big Local News · About: Big Local

15,006 rows where state = "WI" and year = 2021 sorted by rowid descending

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2021 · 14,906 ✖
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
2347831 2347831 WI Shawano   school 5517100 6692 Public school Wittenberg-Birnamwood 551710002222 140 Wittenberg-Birnamwood High   Regular School No High 09 12 2021   grade_9                                                   74                                             74
2347830 2347830 WI Shawano   school 5517100 6692 Public school Wittenberg-Birnamwood 551710002222 140 Wittenberg-Birnamwood High   Regular School No High 09 12 2021   grade_12                                                   85                                             85
2347829 2347829 WI Shawano   school 5517100 6692 Public school Wittenberg-Birnamwood 551710002222 140 Wittenberg-Birnamwood High   Regular School No High 09 12 2021   grade_11                                                   85                                             85
2347828 2347828 WI Shawano   school 5517100 6692 Public school Wittenberg-Birnamwood 551710002222 140 Wittenberg-Birnamwood High   Regular School No High 09 12 2021   grade_10                                                   72                                             72
2347827 2347827 WI Shawano   school 5517100 6692 Public school Wittenberg-Birnamwood 551710002222 140 Wittenberg-Birnamwood High   Regular School No High 09 12 2021   pk_12_total 264.0   22.0 11.0   3.0         16.0   176.0 140.0     12.0       133     42   316 264   22 11   3         16   176 140     12   133   42   316
2347826 2347826 WI Shawano   school 5517100 6692 Public school Wittenberg-Birnamwood 551710002223 120 Wittenberg Elementary   Regular School No Elementary PK 08 2021   pre_kindergarten                                                   3                                             3
2347825 2347825 WI Shawano   school 5517100 6692 Public school Wittenberg-Birnamwood 551710002223 120 Wittenberg Elementary   Regular School No Elementary PK 08 2021   kindergarten                                                   40                                             40
2347824 2347824 WI Shawano   school 5517100 6692 Public school Wittenberg-Birnamwood 551710002223 120 Wittenberg Elementary   Regular School No Elementary PK 08 2021   kindergarten_4_year_old                                                   49                                             49
2347823 2347823 WI Shawano   school 5517100 6692 Public school Wittenberg-Birnamwood 551710002223 120 Wittenberg Elementary   Regular School No Elementary PK 08 2021   grade_8                                                   43                                             43
2347822 2347822 WI Shawano   school 5517100 6692 Public school Wittenberg-Birnamwood 551710002223 120 Wittenberg Elementary   Regular School No Elementary PK 08 2021   grade_7                                                   45                                             45
2347821 2347821 WI Shawano   school 5517100 6692 Public school Wittenberg-Birnamwood 551710002223 120 Wittenberg Elementary   Regular School No Elementary PK 08 2021   grade_6                                                   43                                             43
2347820 2347820 WI Shawano   school 5517100 6692 Public school Wittenberg-Birnamwood 551710002223 120 Wittenberg Elementary   Regular School No Elementary PK 08 2021   grade_5                                                   43                                             43
2347819 2347819 WI Shawano   school 5517100 6692 Public school Wittenberg-Birnamwood 551710002223 120 Wittenberg Elementary   Regular School No Elementary PK 08 2021   grade_4                                                   44                                             44
2347818 2347818 WI Shawano   school 5517100 6692 Public school Wittenberg-Birnamwood 551710002223 120 Wittenberg Elementary   Regular School No Elementary PK 08 2021   grade_3                                                   39                                             39
2347817 2347817 WI Shawano   school 5517100 6692 Public school Wittenberg-Birnamwood 551710002223 120 Wittenberg Elementary   Regular School No Elementary PK 08 2021   grade_2                                                   45                                             45
2347816 2347816 WI Shawano   school 5517100 6692 Public school Wittenberg-Birnamwood 551710002223 120 Wittenberg Elementary   Regular School No Elementary PK 08 2021   grade_1                                                   38                                             38
2347815 2347815 WI Shawano   school 5517100 6692 Public school Wittenberg-Birnamwood 551710002223 120 Wittenberg Elementary   Regular School No Elementary PK 08 2021   pk_12_total 340.0   32.0 20.0   3.0       1.0 36.0   232.0 200.0     21.0       195     69   432 340   32 20   3       1 36   232 200     21   195   69   432
2347814 2347814 WI Shawano   school 5517100 6692 Public school Wittenberg-Birnamwood 551710002218 20 Birnamwood Elementary   Regular School No Elementary PK 08 2021   kindergarten                                                   39                                             39
2347813 2347813 WI Shawano   school 5517100 6692 Public school Wittenberg-Birnamwood 551710002218 20 Birnamwood Elementary   Regular School No Elementary PK 08 2021   kindergarten_4_year_old                                                   34                                             34
2347812 2347812 WI Shawano   school 5517100 6692 Public school Wittenberg-Birnamwood 551710002218 20 Birnamwood Elementary   Regular School No Elementary PK 08 2021   grade_8                                                   42                                             42
2347811 2347811 WI Shawano   school 5517100 6692 Public school Wittenberg-Birnamwood 551710002218 20 Birnamwood Elementary   Regular School No Elementary PK 08 2021   grade_7                                                   46                                             46
2347810 2347810 WI Shawano   school 5517100 6692 Public school Wittenberg-Birnamwood 551710002218 20 Birnamwood Elementary   Regular School No Elementary PK 08 2021   grade_6                                                   35                                             35
2347809 2347809 WI Shawano   school 5517100 6692 Public school Wittenberg-Birnamwood 551710002218 20 Birnamwood Elementary   Regular School No Elementary PK 08 2021   grade_5                                                   46                                             46
2347808 2347808 WI Shawano   school 5517100 6692 Public school Wittenberg-Birnamwood 551710002218 20 Birnamwood Elementary   Regular School No Elementary PK 08 2021   grade_4                                                   36                                             36
2347807 2347807 WI Shawano   school 5517100 6692 Public school Wittenberg-Birnamwood 551710002218 20 Birnamwood Elementary   Regular School No Elementary PK 08 2021   grade_3                                                   39                                             39
2347806 2347806 WI Shawano   school 5517100 6692 Public school Wittenberg-Birnamwood 551710002218 20 Birnamwood Elementary   Regular School No Elementary PK 08 2021   grade_2                                                   29                                             29
2347805 2347805 WI Shawano   school 5517100 6692 Public school Wittenberg-Birnamwood 551710002218 20 Birnamwood Elementary   Regular School No Elementary PK 08 2021   grade_1                                                   43                                             43
2347804 2347804 WI Shawano   school 5517100 6692 Public school Wittenberg-Birnamwood 551710002218 20 Birnamwood Elementary   Regular School No Elementary PK 08 2021   pk_12_total 342.0 2.0 23.0 11.0             11.0   196.0 193.0     11.0       178     53   389 342 2 23 11             11   196 193     11   178   53   389
2347803 2347803 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707003357 140 WRPS Four-year-old Kindergarten and PK Early Childhood   Regular School No Prekindergarten PK PK 2021   pre_kindergarten                                                   7                                             7
2347802 2347802 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707003357 140 WRPS Four-year-old Kindergarten and PK Early Childhood   Regular School No Prekindergarten PK PK 2021   kindergarten_4_year_old                                                   120                                             120
2347801 2347801 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707003357 140 WRPS Four-year-old Kindergarten and PK Early Childhood   Regular School No Prekindergarten PK PK 2021   pk_12_total 96.0 2.0 10.0 2.0   7.0       1.0 9.0   67.0 60.0             76     16   127 96 2 10 2   7       1 9   67 60         76   16   127
2347800 2347800 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002217 300 Woodside Elementary   Regular School No Elementary PK 05 2021   pre_kindergarten                                                   2                                             2
2347799 2347799 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002217 300 Woodside Elementary   Regular School No Elementary PK 05 2021   kindergarten                                                   49                                             49
2347798 2347798 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002217 300 Woodside Elementary   Regular School No Elementary PK 05 2021   kindergarten_4_year_old                                                   31                                             31
2347797 2347797 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002217 300 Woodside Elementary   Regular School No Elementary PK 05 2021   grade_5                                                   55                                             55
2347796 2347796 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002217 300 Woodside Elementary   Regular School No Elementary PK 05 2021   grade_4                                                   65                                             65
2347795 2347795 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002217 300 Woodside Elementary   Regular School No Elementary PK 05 2021   grade_3                                                   64                                             64
2347794 2347794 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002217 300 Woodside Elementary   Regular School No Elementary PK 05 2021   grade_2                                                   52                                             52
2347793 2347793 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002217 300 Woodside Elementary   Regular School No Elementary PK 05 2021   grade_1                                                   53                                             53
2347792 2347792 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002217 300 Woodside Elementary   Regular School No Elementary PK 05 2021   pk_12_total 322.0 3.0 24.0 2.0   14.0         6.0   189.0 182.0             143     75   371 322 3 24 2   14         6   189 182         143   75   371
2347791 2347791 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002216 290 Wisconsin Rapids Area Middle   Regular School No Middle 06 08 2021   grade_8                                                   306                                             306
2347790 2347790 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002216 290 Wisconsin Rapids Area Middle   Regular School No Middle 06 08 2021   grade_7                                                   290                                             290
2347789 2347789 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002216 290 Wisconsin Rapids Area Middle   Regular School No Middle 06 08 2021   grade_6                                                   296                                             296
2347788 2347788 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002216 290 Wisconsin Rapids Area Middle   Regular School No Middle 06 08 2021   pk_12_total 729.0 23.0 57.0 7.0   38.0         38.0   454.0 438.0     23.0       454     147   892 729 23 57 7   38         38   454 438     23   454   147   892
2347787 2347787 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002215 280 Washington Elementary   Regular School No Elementary PK 05 2021   kindergarten                                                   53                                             53
2347786 2347786 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002215 280 Washington Elementary   Regular School No Elementary PK 05 2021   grade_5                                                   53                                             53
2347785 2347785 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002215 280 Washington Elementary   Regular School No Elementary PK 05 2021   grade_4                                                   53                                             53
2347784 2347784 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002215 280 Washington Elementary   Regular School No Elementary PK 05 2021   grade_3                                                   45                                             45
2347783 2347783 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002215 280 Washington Elementary   Regular School No Elementary PK 05 2021   grade_2                                                   55                                             55
2347782 2347782 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002215 280 Washington Elementary   Regular School No Elementary PK 05 2021   grade_1                                                   41                                             41
2347781 2347781 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002215 280 Washington Elementary   Regular School No Elementary PK 05 2021   pk_12_total 254.0 2.0 8.0 2.0   18.0         16.0   138.0 162.0     14.0       147     45   300 254 2 8 2   18         16   138 162     14   147   45   300
2347780 2347780 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002212 220 THINK Academy-Together Helping INspire Kids   Regular School No Elementary PK 05 2021   kindergarten                                                   37                                             37
2347779 2347779 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002212 220 THINK Academy-Together Helping INspire Kids   Regular School No Elementary PK 05 2021   kindergarten_4_year_old                                                   21                                             21
2347778 2347778 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002212 220 THINK Academy-Together Helping INspire Kids   Regular School No Elementary PK 05 2021   grade_5                                                   34                                             34
2347777 2347777 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002212 220 THINK Academy-Together Helping INspire Kids   Regular School No Elementary PK 05 2021   grade_4                                                   24                                             24
2347776 2347776 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002212 220 THINK Academy-Together Helping INspire Kids   Regular School No Elementary PK 05 2021   grade_3                                                   24                                             24
2347775 2347775 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002212 220 THINK Academy-Together Helping INspire Kids   Regular School No Elementary PK 05 2021   grade_2                                                   40                                             40
2347774 2347774 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002212 220 THINK Academy-Together Helping INspire Kids   Regular School No Elementary PK 05 2021   grade_1                                                   23                                             23
2347773 2347773 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002212 220 THINK Academy-Together Helping INspire Kids   Regular School No Elementary PK 05 2021   pk_12_total 193.0   7.0               3.0   115.0 88.0             66     19   203 193   7               3   115 88         66   19   203
2347772 2347772 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707003365 430 River Cities High   Alternative School No High 09 12 2021   grade_12                                                   49                                             49
2347771 2347771 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707003365 430 River Cities High   Alternative School No High 09 12 2021   grade_11                                                   28                                             28
2347770 2347770 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707003365 430 River Cities High   Alternative School No High 09 12 2021   grade_10                                                   2                                             2
2347769 2347769 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707003365 430 River Cities High   Alternative School No High 09 12 2021   pk_12_total 54.0 3.0 12.0 4.0   1.0         5.0   45.0 34.0     1.0       65     28   79 54 3 12 4   1         5   45 34     1   65   28   79
2347768 2347768 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002781 170 Mead Elementary   Regular School No Elementary PK 05 2021   pre_kindergarten                                                   2                                             2
2347767 2347767 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002781 170 Mead Elementary   Regular School No Elementary PK 05 2021   kindergarten                                                   45                                             45
2347766 2347766 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002781 170 Mead Elementary   Regular School No Elementary PK 05 2021   kindergarten_4_year_old                                                   27                                             27
2347765 2347765 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002781 170 Mead Elementary   Regular School No Elementary PK 05 2021   grade_5                                                   55                                             55
2347764 2347764 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002781 170 Mead Elementary   Regular School No Elementary PK 05 2021   grade_4                                                   47                                             47
2347763 2347763 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002781 170 Mead Elementary   Regular School No Elementary PK 05 2021   grade_3                                                   47                                             47
2347762 2347762 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002781 170 Mead Elementary   Regular School No Elementary PK 05 2021   grade_2                                                   58                                             58
2347761 2347761 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002781 170 Mead Elementary   Regular School No Elementary PK 05 2021   grade_1                                                   52                                             52
2347760 2347760 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002781 170 Mead Elementary   Regular School No Elementary PK 05 2021   pk_12_total 233.0 5.0 32.0 2.0   24.0         37.0   177.0 156.0     23.0       253     78   333 233 5 32 2   24         37   177 156     23   253   78   333
2347759 2347759 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002209 160 Lincoln High   Regular School No High 09 12 2021   grade_9                                                   376                                             376
2347758 2347758 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002209 160 Lincoln High   Regular School No High 09 12 2021   grade_12                                                   336                                             336
2347757 2347757 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002209 160 Lincoln High   Regular School No High 09 12 2021   grade_11                                                   356                                             356
2347756 2347756 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002209 160 Lincoln High   Regular School No High 09 12 2021   grade_10                                                   344                                             344
2347755 2347755 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002209 160 Lincoln High   Regular School No High 09 12 2021   pk_12_total 1204.0 27.0 65.0 24.0   55.0         37.0   703.0 709.0     17.0       629     221   1412 1204 27 65 24   55         37   703 709     17   629   221   1412
2347754 2347754 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002207 120 Howe Elementary   Regular School No Elementary KG 05 2021   kindergarten                                                   51                                             51
2347753 2347753 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002207 120 Howe Elementary   Regular School No Elementary KG 05 2021   grade_5                                                   45                                             45
2347752 2347752 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002207 120 Howe Elementary   Regular School No Elementary KG 05 2021   grade_4                                                   59                                             59
2347751 2347751 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002207 120 Howe Elementary   Regular School No Elementary KG 05 2021   grade_3                                                   45                                             45
2347750 2347750 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002207 120 Howe Elementary   Regular School No Elementary KG 05 2021   grade_2                                                   46                                             46
2347749 2347749 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002207 120 Howe Elementary   Regular School No Elementary KG 05 2021   grade_1                                                   41                                             41
2347748 2347748 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002207 120 Howe Elementary   Regular School No Elementary KG 05 2021   pk_12_total 215.0 6.0 15.0 4.0   31.0         16.0   150.0 137.0     32.0       212     47   287 215 6 15 4   31         16   150 137     32   212   47   287
2347747 2347747 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002206 80 Grove Elementary   Regular School No Elementary PK 05 2021   kindergarten                                                   36                                             36
2347746 2347746 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002206 80 Grove Elementary   Regular School No Elementary PK 05 2021   kindergarten_4_year_old                                                   30                                             30
2347745 2347745 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002206 80 Grove Elementary   Regular School No Elementary PK 05 2021   grade_5                                                   25                                             25
2347744 2347744 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002206 80 Grove Elementary   Regular School No Elementary PK 05 2021   grade_4                                                   40                                             40
2347743 2347743 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002206 80 Grove Elementary   Regular School No Elementary PK 05 2021   grade_3                                                   31                                             31
2347742 2347742 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002206 80 Grove Elementary   Regular School No Elementary PK 05 2021   grade_2                                                   42                                             42
2347741 2347741 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002206 80 Grove Elementary   Regular School No Elementary PK 05 2021   grade_1                                                   22                                             22
2347740 2347740 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002206 80 Grove Elementary   Regular School No Elementary PK 05 2021   pk_12_total 153.0 12.0 20.0     24.0         17.0   110.0 116.0     9.0       146     44   226 153 12 20     24         17   110 116     9   146   44   226
2347739 2347739 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002205 60 Grant Elementary   Regular School No Elementary PK 05 2021   pre_kindergarten                                                   2                                             2
2347738 2347738 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002205 60 Grant Elementary   Regular School No Elementary PK 05 2021   kindergarten                                                   36                                             36
2347737 2347737 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002205 60 Grant Elementary   Regular School No Elementary PK 05 2021   kindergarten_4_year_old                                                   31                                             31
2347736 2347736 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002205 60 Grant Elementary   Regular School No Elementary PK 05 2021   grade_5                                                   31                                             31
2347735 2347735 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002205 60 Grant Elementary   Regular School No Elementary PK 05 2021   grade_4                                                   40                                             40
2347734 2347734 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002205 60 Grant Elementary   Regular School No Elementary PK 05 2021   grade_3                                                   41                                             41
2347733 2347733 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002205 60 Grant Elementary   Regular School No Elementary PK 05 2021   grade_2                                                   44                                             44
2347732 2347732 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002205 60 Grant Elementary   Regular School No Elementary PK 05 2021   grade_1                                                   43                                             43

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