Data source: Big Local News · About: Big Local

12,002 rows where state = "IN" and year = 2021 sorted by asian_pacific_islander

View and edit SQL

grade

year

  • 2021 · 12,002
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
1918953 IN     school 1800060 15   Adams Central Community Schools 180006000008 13 Adams Central Middle School   Regular School No Middle 06 08 2021   grade_6                         53.0 45.0                       98.0                         53 45                 98
1918954 IN     school 1800060 15   Adams Central Community Schools 180006000008 13 Adams Central Middle School   Regular School No Middle 06 08 2021   grade_7                         64.0 43.0                       107.0                         64 43                 107
1918955 IN     school 1800060 15   Adams Central Community Schools 180006000008 13 Adams Central Middle School   Regular School No Middle 06 08 2021   grade_8                         54.0 53.0                       107.0                         54 53                 107
1918956 IN     school 1800060 15   Adams Central Community Schools 180006000008 13 Adams Central Middle School   Regular School No Middle 06 08 2021   pk_12_total 288.0 2.0 11.0     3.0         8.0   171.0 141.0     3.0         81.0   33.0   312.0 288 2 11     3         8   171 141     3     81 33   312
1918957 IN     school 1800060 15   Adams Central Community Schools 180006000006 20 Adams Central Elementary School   Regular School No Elementary PK 05 2021   grade_1                         48.0 47.0                       95.0                         48 47                 95
1918958 IN     school 1800060 15   Adams Central Community Schools 180006000006 20 Adams Central Elementary School   Regular School No Elementary PK 05 2021   grade_2                         56.0 43.0                       99.0                         56 43                 99
1918959 IN     school 1800060 15   Adams Central Community Schools 180006000006 20 Adams Central Elementary School   Regular School No Elementary PK 05 2021   grade_3                         53.0 65.0                       118.0                         53 65                 118
1918960 IN     school 1800060 15   Adams Central Community Schools 180006000006 20 Adams Central Elementary School   Regular School No Elementary PK 05 2021   grade_4                         58.0 41.0                       99.0                         58 41                 99
1918961 IN     school 1800060 15   Adams Central Community Schools 180006000006 20 Adams Central Elementary School   Regular School No Elementary PK 05 2021   grade_5                         58.0 48.0                       106.0                         58 48                 106
1918962 IN     school 1800060 15   Adams Central Community Schools 180006000006 20 Adams Central Elementary School   Regular School No Elementary PK 05 2021   kindergarten                         46.0 37.0                       83.0                         46 37                 83
1918963 IN     school 1800060 15   Adams Central Community Schools 180006000006 20 Adams Central Elementary School   Regular School No Elementary PK 05 2021   pk_12_total 603.0 4.0 34.0 1.0   1.0         18.0   352.0 309.0     19.0         154.0   110.0   661.0 603 4 34 1   1         18   352 309     19     154 110   661
1918964 IN     school 1800060 15   Adams Central Community Schools 180006000006 20 Adams Central Elementary School   Regular School No Elementary PK 05 2021   pre_kindergarten                         33.0 28.0                       61.0                         33 28                 61
1918965 IN     school 1800060 15   Adams Central Community Schools 180006000007 21 Adams Central High School   Regular School No High 09 12 2021   adult                         1.0 1.0                       2.0                         1 1                 2
1918966 IN     school 1800060 15   Adams Central Community Schools 180006000007 21 Adams Central High School   Regular School No High 09 12 2021   grade_10                         49.0 32.0                       81.0                         49 32                 81
1918967 IN     school 1800060 15   Adams Central Community Schools 180006000007 21 Adams Central High School   Regular School No High 09 12 2021   grade_11                         39.0 43.0                       82.0                         39 43                 82
1918968 IN     school 1800060 15   Adams Central Community Schools 180006000007 21 Adams Central High School   Regular School No High 09 12 2021   grade_12                         50.0 54.0                       104.0                         50 54                 104
1918969 IN     school 1800060 15   Adams Central Community Schools 180006000007 21 Adams Central High School   Regular School No High 09 12 2021   grade_9                         53.0 48.0                       101.0                         53 48                 101
1918970 IN     school 1800060 15   Adams Central Community Schools 180006000007 21 Adams Central High School   Regular School No High 09 12 2021   pk_12_total 351.0 2.0 13.0 1.0   1.0         2.0   192.0 178.0     4.0         79.0   23.0   370.0 351 2 13 1   1         2   192 178     4     79 23   370
1918971 IN     school 1807680 25   North Adams Community Schools 180768001314 29 Bellmont Senior High School   Regular School No High 09 12 2021   grade_10                         77.0 89.0                       166.0                         77 89                 166
1918972 IN     school 1807680 25   North Adams Community Schools 180768001314 29 Bellmont Senior High School   Regular School No High 09 12 2021   grade_11                         89.0 78.0                       167.0                         89 78                 167
1918973 IN     school 1807680 25   North Adams Community Schools 180768001314 29 Bellmont Senior High School   Regular School No High 09 12 2021   grade_12                         79.0 75.0                       154.0                         79 75                 154
1918974 IN     school 1807680 25   North Adams Community Schools 180768001314 29 Bellmont Senior High School   Regular School No High 09 12 2021   grade_9                         68.0 92.0                       160.0                         68 92                 160
1918975 IN     school 1807680 25   North Adams Community Schools 180768001314 29 Bellmont Senior High School   Regular School No High 09 12 2021   pk_12_total 537.0 8.0 76.0 1.0   4.0         21.0   313.0 334.0     4.0         219.0   64.0   647.0 537 8 76 1   4         21   313 334     4     219 64   647
1918976 IN     school 1807680 25   North Adams Community Schools 180768001313 33 Bellmont Middle School   Regular School No Middle 06 08 2021   grade_6                         60.0 63.0                       123.0                         60 63                 123
1918977 IN     school 1807680 25   North Adams Community Schools 180768001313 33 Bellmont Middle School   Regular School No Middle 06 08 2021   grade_7                         50.0 72.0                       122.0                         50 72                 122
1918978 IN     school 1807680 25   North Adams Community Schools 180768001313 33 Bellmont Middle School   Regular School No Middle 06 08 2021   grade_8                         47.0 64.0                       111.0                         47 64                 111
1918979 IN     school 1807680 25   North Adams Community Schools 180768001313 33 Bellmont Middle School   Regular School No Middle 06 08 2021   pk_12_total 302.0 9.0 33.0     4.0     2.0   6.0   157.0 199.0     3.0         196.0   53.0   356.0 302 9 33     4     2   6   157 199     3     196 53   356
1918980 IN     school 1807680 25   North Adams Community Schools 180768001316 37 Bellmont Elementary   Regular School No Elementary PK 05 2021   grade_1                         60.0 53.0                       113.0                         60 53                 113
1918981 IN     school 1807680 25   North Adams Community Schools 180768001316 37 Bellmont Elementary   Regular School No Elementary PK 05 2021   grade_2                         35.0 55.0                       90.0                         35 55                 90
1918982 IN     school 1807680 25   North Adams Community Schools 180768001316 37 Bellmont Elementary   Regular School No Elementary PK 05 2021   grade_3                         45.0 41.0                       86.0                         45 41                 86
1918983 IN     school 1807680 25   North Adams Community Schools 180768001316 37 Bellmont Elementary   Regular School No Elementary PK 05 2021   grade_4                         51.0 51.0                       102.0                         51 51                 102
1918984 IN     school 1807680 25   North Adams Community Schools 180768001316 37 Bellmont Elementary   Regular School No Elementary PK 05 2021   grade_5                         60.0 36.0                       96.0                         60 36                 96
1918985 IN     school 1807680 25   North Adams Community Schools 180768001316 37 Bellmont Elementary   Regular School No Elementary PK 05 2021   kindergarten                         52.0 49.0                       101.0                         52 49                 101
1918986 IN     school 1807680 25   North Adams Community Schools 180768001316 37 Bellmont Elementary   Regular School No Elementary PK 05 2021   pk_12_total 506.0 18.0 81.0     5.0     1.0   27.0   333.0 305.0     13.0         375.0   144.0   638.0 506 18 81     5     1   27   333 305     13     375 144   638
1918987 IN     school 1807680 25   North Adams Community Schools 180768001316 37 Bellmont Elementary   Regular School No Elementary PK 05 2021   pre_kindergarten                         30.0 20.0                       50.0                         30 20                 50
1918988 IN     school 1810260 35   South Adams Schools 181026001641 17 South Adams Middle School   Regular School No Middle 06 08 2021   grade_6                         39.0 48.0                       87.0                         39 48                 87
1918989 IN     school 1810260 35   South Adams Schools 181026001641 17 South Adams Middle School   Regular School No Middle 06 08 2021   grade_7                         41.0 45.0                       86.0                         41 45                 86
1918990 IN     school 1810260 35   South Adams Schools 181026001641 17 South Adams Middle School   Regular School No Middle 06 08 2021   grade_8                         43.0 45.0                       88.0                         43 45                 88
1918991 IN     school 1810260 35   South Adams Schools 181026001641 17 South Adams Middle School   Regular School No Middle 06 08 2021   pk_12_total 212.0 3.0 38.0     2.0         6.0   123.0 138.0     16.0         116.0   34.0   261.0 212 3 38     2         6   123 138     16     116 34   261
1918992 IN     school 1810260 35   South Adams Schools 181026001642 23 South Adams High School   Regular School No High 09 12 2021   adult                         2.0 1.0                       3.0                         2 1                 3
1918993 IN     school 1810260 35   South Adams Schools 181026001642 23 South Adams High School   Regular School No High 09 12 2021   grade_10                         38.0 40.0                       78.0                         38 40                 78
1918994 IN     school 1810260 35   South Adams Schools 181026001642 23 South Adams High School   Regular School No High 09 12 2021   grade_11                         43.0 47.0                       90.0                         43 47                 90
1918995 IN     school 1810260 35   South Adams Schools 181026001642 23 South Adams High School   Regular School No High 09 12 2021   grade_12                         52.0 37.0                       89.0                         52 37                 89
1918996 IN     school 1810260 35   South Adams Schools 181026001642 23 South Adams High School   Regular School No High 09 12 2021   grade_9                         39.0 50.0                       89.0                         39 50                 89
1918997 IN     school 1810260 35   South Adams Schools 181026001642 23 South Adams High School   Regular School No High 09 12 2021   pk_12_total 300.0 3.0 34.0     7.0         5.0   174.0 175.0     21.0         119.0   46.0   349.0 300 3 34     7         5   174 175     21     119 46   349
1918998 IN     school 1810260 35   South Adams Schools 181026001640 25 South Adams Elementary School   Regular School No Elementary PK 05 2021   grade_1                         48.0 55.0                       103.0                         48 55                 103
1918999 IN     school 1810260 35   South Adams Schools 181026001640 25 South Adams Elementary School   Regular School No Elementary PK 05 2021   grade_2                         43.0 60.0                       103.0                         43 60                 103
1919000 IN     school 1810260 35   South Adams Schools 181026001640 25 South Adams Elementary School   Regular School No Elementary PK 05 2021   grade_3                         50.0 43.0                       93.0                         50 43                 93
1919001 IN     school 1810260 35   South Adams Schools 181026001640 25 South Adams Elementary School   Regular School No Elementary PK 05 2021   grade_4                         59.0 37.0                       96.0                         59 37                 96
1919002 IN     school 1810260 35   South Adams Schools 181026001640 25 South Adams Elementary School   Regular School No Elementary PK 05 2021   grade_5                         50.0 47.0                       97.0                         50 47                 97
1919003 IN     school 1810260 35   South Adams Schools 181026001640 25 South Adams Elementary School   Regular School No Elementary PK 05 2021   kindergarten                         47.0 37.0                       84.0                         47 37                 84
1919004 IN     school 1810260 35   South Adams Schools 181026001640 25 South Adams Elementary School   Regular School No Elementary PK 05 2021   pk_12_total 537.0   68.0     5.0     1.0   17.0   324.0 304.0     89.0         295.0   156.0   628.0 537   68     5     1   17   324 304     89     295 156   628
1919005 IN     school 1810260 35   South Adams Schools 181026001640 25 South Adams Elementary School   Regular School No Elementary PK 05 2021   pre_kindergarten                         27.0 25.0                       52.0                         27 25                 52
1919006 IN     school 1800030 125   MSD Southwest Allen County Schls 180003000001 45 Aboite Elementary School   Regular School No Elementary KG 05 2021   grade_1                         24.0 31.0                       55.0                         24 31                 55
1919007 IN     school 1800030 125   MSD Southwest Allen County Schls 180003000001 45 Aboite Elementary School   Regular School No Elementary KG 05 2021   grade_2                         36.0 29.0                       65.0                         36 29                 65
1919008 IN     school 1800030 125   MSD Southwest Allen County Schls 180003000001 45 Aboite Elementary School   Regular School No Elementary KG 05 2021   grade_3                         52.0 32.0                       84.0                         52 32                 84
1919009 IN     school 1800030 125   MSD Southwest Allen County Schls 180003000001 45 Aboite Elementary School   Regular School No Elementary KG 05 2021   grade_4                         52.0 39.0                       91.0                         52 39                 91
1919010 IN     school 1800030 125   MSD Southwest Allen County Schls 180003000001 45 Aboite Elementary School   Regular School No Elementary KG 05 2021   grade_5                         57.0 43.0                       100.0                         57 43                 100
1919011 IN     school 1800030 125   MSD Southwest Allen County Schls 180003000001 45 Aboite Elementary School   Regular School No Elementary KG 05 2021   kindergarten                         22.0 20.0                       42.0                         22 20                 42
1919012 IN     school 1800030 125   MSD Southwest Allen County Schls 180003000001 45 Aboite Elementary School   Regular School No Elementary KG 05 2021   pk_12_total 359.0 10.0 20.0 4.0   20.0         24.0   243.0 194.0     3.0         81.0   26.0   437.0 359 10 20 4   20         24   243 194     3     81 26   437
1919013 IN     school 1800030 125   MSD Southwest Allen County Schls 180003000083 46 Whispering Meadow Elementary Sch   Regular School No Elementary PK 05 2021   grade_1                         55.0 38.0                       93.0                         55 38                 93
1919014 IN     school 1800030 125   MSD Southwest Allen County Schls 180003000083 46 Whispering Meadow Elementary Sch   Regular School No Elementary PK 05 2021   grade_2                         35.0 41.0                       76.0                         35 41                 76
1919015 IN     school 1800030 125   MSD Southwest Allen County Schls 180003000083 46 Whispering Meadow Elementary Sch   Regular School No Elementary PK 05 2021   grade_3                         47.0 42.0                       89.0                         47 42                 89
1919016 IN     school 1800030 125   MSD Southwest Allen County Schls 180003000083 46 Whispering Meadow Elementary Sch   Regular School No Elementary PK 05 2021   grade_4                         40.0 44.0                       84.0                         40 44                 84
1919017 IN     school 1800030 125   MSD Southwest Allen County Schls 180003000083 46 Whispering Meadow Elementary Sch   Regular School No Elementary PK 05 2021   grade_5                         50.0 42.0                       92.0                         50 42                 92
1919018 IN     school 1800030 125   MSD Southwest Allen County Schls 180003000083 46 Whispering Meadow Elementary Sch   Regular School No Elementary PK 05 2021   kindergarten                         50.0 43.0                       93.0                         50 43                 93
1919019 IN     school 1800030 125   MSD Southwest Allen County Schls 180003000083 46 Whispering Meadow Elementary Sch   Regular School No Elementary PK 05 2021   pk_12_total 366.0 77.0 35.0 2.0   39.0         38.0   300.0 257.0     22.0         155.0   68.0   557.0 366 77 35 2   39         38   300 257     22     155 68   557
1919020 IN     school 1800030 125   MSD Southwest Allen County Schls 180003000083 46 Whispering Meadow Elementary Sch   Regular School No Elementary PK 05 2021   pre_kindergarten                         23.0 7.0                       30.0                         23 7                 30
1919021 IN     school 1800030 125   MSD Southwest Allen County Schls 180003000002 47 Homestead Senior High School   Regular School No High 09 12 2021   grade_10                         326.0 309.0                       635.0                         326 309                 635
1919022 IN     school 1800030 125   MSD Southwest Allen County Schls 180003000002 47 Homestead Senior High School   Regular School No High 09 12 2021   grade_11                         334.0 324.0                       658.0                         334 324                 658
1919023 IN     school 1800030 125   MSD Southwest Allen County Schls 180003000002 47 Homestead Senior High School   Regular School No High 09 12 2021   grade_12                         302.0 275.0                       577.0                         302 275                 577
1919024 IN     school 1800030 125   MSD Southwest Allen County Schls 180003000002 47 Homestead Senior High School   Regular School No High 09 12 2021   grade_9                         304.0 329.0                       633.0                         304 329                 633
1919025 IN     school 1800030 125   MSD Southwest Allen County Schls 180003000002 47 Homestead Senior High School   Regular School No High 09 12 2021   pk_12_total 1948.0 133.0 180.0 9.0   112.0     4.0   117.0   1266.0 1237.0     18.0         386.0   199.0   2503.0 1948 133 180 9   112     4   117   1266 1237     18     386 199   2503
1919026 IN     school 1800030 125   MSD Southwest Allen County Schls 180003000116 63 Summit Middle School   Regular School No Middle 06 08 2021   grade_6                         153.0 122.0                       275.0                         153 122                 275
1919027 IN     school 1800030 125   MSD Southwest Allen County Schls 180003000116 63 Summit Middle School   Regular School No Middle 06 08 2021   grade_7                         144.0 136.0                       280.0                         144 136                 280
1919028 IN     school 1800030 125   MSD Southwest Allen County Schls 180003000116 63 Summit Middle School   Regular School No Middle 06 08 2021   grade_8                         154.0 129.0                       283.0                         154 129                 283
1919029 IN     school 1800030 125   MSD Southwest Allen County Schls 180003000116 63 Summit Middle School   Regular School No Middle 06 08 2021   pk_12_total 703.0 31.0 47.0 2.0   26.0         29.0   451.0 387.0     9.0         144.0   77.0   838.0 703 31 47 2   26         29   451 387     9     144 77   838
1919030 IN     school 1800030 125   MSD Southwest Allen County Schls 180003002044 64 Lafayette Meadow School   Regular School No Elementary KG 05 2021   grade_1                         56.0 41.0                       97.0                         56 41                 97
1919031 IN     school 1800030 125   MSD Southwest Allen County Schls 180003002044 64 Lafayette Meadow School   Regular School No Elementary KG 05 2021   grade_2                         63.0 47.0                       110.0                         63 47                 110
1919032 IN     school 1800030 125   MSD Southwest Allen County Schls 180003002044 64 Lafayette Meadow School   Regular School No Elementary KG 05 2021   grade_3                         61.0 59.0                       120.0                         61 59                 120
1919033 IN     school 1800030 125   MSD Southwest Allen County Schls 180003002044 64 Lafayette Meadow School   Regular School No Elementary KG 05 2021   grade_4                         54.0 60.0                       114.0                         54 60                 114
1919034 IN     school 1800030 125   MSD Southwest Allen County Schls 180003002044 64 Lafayette Meadow School   Regular School No Elementary KG 05 2021   grade_5                         73.0 56.0                       129.0                         73 56                 129
1919035 IN     school 1800030 125   MSD Southwest Allen County Schls 180003002044 64 Lafayette Meadow School   Regular School No Elementary KG 05 2021   kindergarten                         64.0 39.0                       103.0                         64 39                 103
1919036 IN     school 1800030 125   MSD Southwest Allen County Schls 180003002044 64 Lafayette Meadow School   Regular School No Elementary KG 05 2021   pk_12_total 577.0 24.0 33.0     11.0         28.0   371.0 302.0     0.0         113.0   62.0   673.0 577 24 33     11         28   371 302     0     113 62   673
1919037 IN     school 1800030 125   MSD Southwest Allen County Schls 180003000005 67 Woodside Middle School   Regular School No Middle 06 08 2021   grade_6                         176.0 169.0                       345.0                         176 169                 345
1919038 IN     school 1800030 125   MSD Southwest Allen County Schls 180003000005 67 Woodside Middle School   Regular School No Middle 06 08 2021   grade_7                         162.0 163.0                       325.0                         162 163                 325
1919039 IN     school 1800030 125   MSD Southwest Allen County Schls 180003000005 67 Woodside Middle School   Regular School No Middle 06 08 2021   grade_8                         173.0 180.0                       353.0                         173 180                 353
1919040 IN     school 1800030 125   MSD Southwest Allen County Schls 180003000005 67 Woodside Middle School   Regular School No Middle 06 08 2021   pk_12_total 711.0 114.0 73.0 2.0   64.0     5.0   54.0   511.0 512.0     19.0         214.0   73.0   1023.0 711 114 73 2   64     5   54   511 512     19     214 73   1023
1919041 IN     school 1800030 125   MSD Southwest Allen County Schls 180003002186 68 Haverhill Elementary School   Regular School No Elementary KG 05 2021   grade_1                         39.0 42.0                       81.0                         39 42                 81
1919042 IN     school 1800030 125   MSD Southwest Allen County Schls 180003002186 68 Haverhill Elementary School   Regular School No Elementary KG 05 2021   grade_2                         35.0 34.0                       69.0                         35 34                 69
1919043 IN     school 1800030 125   MSD Southwest Allen County Schls 180003002186 68 Haverhill Elementary School   Regular School No Elementary KG 05 2021   grade_3                         38.0 40.0                       78.0                         38 40                 78
1919044 IN     school 1800030 125   MSD Southwest Allen County Schls 180003002186 68 Haverhill Elementary School   Regular School No Elementary KG 05 2021   grade_4                         47.0 36.0                       83.0                         47 36                 83
1919045 IN     school 1800030 125   MSD Southwest Allen County Schls 180003002186 68 Haverhill Elementary School   Regular School No Elementary KG 05 2021   grade_5                         38.0 39.0                       77.0                         38 39                 77
1919046 IN     school 1800030 125   MSD Southwest Allen County Schls 180003002186 68 Haverhill Elementary School   Regular School No Elementary KG 05 2021   kindergarten                         33.0 32.0                       65.0                         33 32                 65
1919047 IN     school 1800030 125   MSD Southwest Allen County Schls 180003002186 68 Haverhill Elementary School   Regular School No Elementary KG 05 2021   pk_12_total 342.0 36.0 36.0     15.0         24.0   230.0 223.0     7.0         101.0   46.0   453.0 342 36 36     15         24   230 223     7     101 46   453
1919048 IN     school 1800030 125   MSD Southwest Allen County Schls 180003002329 71 Deer Ridge Elementary   Regular School No Elementary KG 05 2021   grade_1                         32.0 24.0                       56.0                         32 24                 56
1919049 IN     school 1800030 125   MSD Southwest Allen County Schls 180003002329 71 Deer Ridge Elementary   Regular School No Elementary KG 05 2021   grade_2                         46.0 32.0                       78.0                         46 32                 78
1919050 IN     school 1800030 125   MSD Southwest Allen County Schls 180003002329 71 Deer Ridge Elementary   Regular School No Elementary KG 05 2021   grade_3                         28.0 24.0                       52.0                         28 24                 52
1919051 IN     school 1800030 125   MSD Southwest Allen County Schls 180003002329 71 Deer Ridge Elementary   Regular School No Elementary KG 05 2021   grade_4                         41.0 35.0                       76.0                         41 35                 76
1919052 IN     school 1800030 125   MSD Southwest Allen County Schls 180003002329 71 Deer Ridge Elementary   Regular School No Elementary KG 05 2021   grade_5                         30.0 34.0                       64.0                         30 34                 64

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