Data source: Big Local News · About: Big Local

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

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
1930154 IN     school 1800202 9085   pilotED Schools 180020202661 1006 pilotED Schools Bethel Park   Regular School Yes Elementary KG 04 2021   grade_1                         23.0 26.0                       49.0                         23 26                 49
1930155 IN     school 1800202 9085   pilotED Schools 180020202661 1006 pilotED Schools Bethel Park   Regular School Yes Elementary KG 04 2021   grade_2                         19.0 26.0                       45.0                         19 26                 45
1930156 IN     school 1800202 9085   pilotED Schools 180020202661 1006 pilotED Schools Bethel Park   Regular School Yes Elementary KG 04 2021   grade_3                         16.0 5.0                       21.0                         16 5                 21
1930157 IN     school 1800202 9085   pilotED Schools 180020202661 1006 pilotED Schools Bethel Park   Regular School Yes Elementary KG 04 2021   grade_4                         6.0 13.0                       19.0                         6 13                 19
1930158 IN     school 1800202 9085   pilotED Schools 180020202661 1006 pilotED Schools Bethel Park   Regular School Yes Elementary KG 04 2021   kindergarten                         26.0 25.0                       51.0                         26 25                 51
1930159 IN     school 1800202 9085   pilotED Schools 180020202661 1006 pilotED Schools Bethel Park   Regular School Yes Elementary KG 04 2021   pk_12_total 28.0 87.0 34.0 3.0             33.0   90.0 95.0     17.0         153.0   11.0   185.0 28 87 34 3             33   90 95     17     153 11   185
1919735 IN     school 1802830 630   Zionsville Community Schools 180283002046 510 Zionsville West Middle School   Regular School No Middle 05 08 2021   grade_5                         139.0 136.0                       275.0                         139 136                 275
1919736 IN     school 1802830 630   Zionsville Community Schools 180283002046 510 Zionsville West Middle School   Regular School No Middle 05 08 2021   grade_6                         142.0 142.0                       284.0                         142 142                 284
1919737 IN     school 1802830 630   Zionsville Community Schools 180283002046 510 Zionsville West Middle School   Regular School No Middle 05 08 2021   grade_7                         139.0 133.0                       272.0                         139 133                 272
1919738 IN     school 1802830 630   Zionsville Community Schools 180283002046 510 Zionsville West Middle School   Regular School No Middle 05 08 2021   grade_8                         140.0 145.0                       285.0                         140 145                 285
1919739 IN     school 1802830 630   Zionsville Community Schools 180283002046 510 Zionsville West Middle School   Regular School No Middle 05 08 2021   pk_12_total 855.0 37.0 83.0 2.0   94.0         82.0   580.0 573.0     17.0         84.0   151.0   1153.0 855 37 83 2   94         82   580 573     17     84 151   1153
1919740 IN     school 1802830 630   Zionsville Community Schools 180283002046 510 Zionsville West Middle School   Regular School No Middle 05 08 2021   pre_kindergarten                         20.0 17.0                       37.0                         20 17                 37
1919759 IN     school 1802830 630   Zionsville Community Schools 180283001551 517 Zionsville Pleasant View Elem Sch   Regular School No Elementary PK 04 2021   grade_1                         76.0 73.0                       149.0                         76 73                 149
1919760 IN     school 1802830 630   Zionsville Community Schools 180283001551 517 Zionsville Pleasant View Elem Sch   Regular School No Elementary PK 04 2021   grade_2                         80.0 62.0                       142.0                         80 62                 142
1919761 IN     school 1802830 630   Zionsville Community Schools 180283001551 517 Zionsville Pleasant View Elem Sch   Regular School No Elementary PK 04 2021   grade_3                         81.0 70.0                       151.0                         81 70                 151
1919762 IN     school 1802830 630   Zionsville Community Schools 180283001551 517 Zionsville Pleasant View Elem Sch   Regular School No Elementary PK 04 2021   grade_4                         92.0 74.0                       166.0                         92 74                 166
1919763 IN     school 1802830 630   Zionsville Community Schools 180283001551 517 Zionsville Pleasant View Elem Sch   Regular School No Elementary PK 04 2021   kindergarten                         67.0 63.0                       130.0                         67 63                 130
1919764 IN     school 1802830 630   Zionsville Community Schools 180283001551 517 Zionsville Pleasant View Elem Sch   Regular School No Elementary PK 04 2021   pk_12_total 709.0 5.0 32.0 1.0   31.0     2.0   38.0   440.0 378.0     2.0         25.0   117.0   818.0 709 5 32 1   31     2   38   440 378     2     25 117   818
1919765 IN     school 1802830 630   Zionsville Community Schools 180283001551 517 Zionsville Pleasant View Elem Sch   Regular School No Elementary PK 04 2021   pre_kindergarten                         44.0 36.0                       80.0                         44 36                 80
1919741 IN     school 1802830 630   Zionsville Community Schools 180283000342 511 Zionsville Middle School   Regular School No Middle 05 08 2021   grade_5                         147.0 138.0                       285.0                         147 138                 285
1919742 IN     school 1802830 630   Zionsville Community Schools 180283000342 511 Zionsville Middle School   Regular School No Middle 05 08 2021   grade_6                         160.0 138.0                       298.0                         160 138                 298
1919743 IN     school 1802830 630   Zionsville Community Schools 180283000342 511 Zionsville Middle School   Regular School No Middle 05 08 2021   grade_7                         150.0 146.0                       296.0                         150 146                 296
1919744 IN     school 1802830 630   Zionsville Community Schools 180283000342 511 Zionsville Middle School   Regular School No Middle 05 08 2021   grade_8                         165.0 146.0                       311.0                         165 146                 311
1919745 IN     school 1802830 630   Zionsville Community Schools 180283000342 511 Zionsville Middle School   Regular School No Middle 05 08 2021   pk_12_total 1039.0 16.0 50.0     38.0         47.0   622.0 568.0     3.0         47.0   115.0   1190.0 1039 16 50     38         47   622 568     3     47 115   1190
1919746 IN     school 1802830 630   Zionsville Community Schools 180283000341 512 Zionsville Community High School   Regular School No High 09 12 2021   adult                         8.0 2.0                       10.0                         8 2                 10
1919747 IN     school 1802830 630   Zionsville Community Schools 180283000341 512 Zionsville Community High School   Regular School No High 09 12 2021   grade_10                         270.0 275.0                       545.0                         270 275                 545
1919748 IN     school 1802830 630   Zionsville Community Schools 180283000341 512 Zionsville Community High School   Regular School No High 09 12 2021   grade_11                         283.0 267.0                       550.0                         283 267                 550
1919749 IN     school 1802830 630   Zionsville Community Schools 180283000341 512 Zionsville Community High School   Regular School No High 09 12 2021   grade_12                         264.0 234.0                       498.0                         264 234                 498
1919750 IN     school 1802830 630   Zionsville Community Schools 180283000341 512 Zionsville Community High School   Regular School No High 09 12 2021   grade_9                         291.0 267.0                       558.0                         291 267                 558
1919751 IN     school 1802830 630   Zionsville Community Schools 180283000341 512 Zionsville Community High School   Regular School No High 09 12 2021   pk_12_total 1789.0 45.0 98.0 5.0   118.0         106.0   1116.0 1045.0     17.0         121.0   254.0   2161.0 1789 45 98 5   118         106   1116 1045     17     121 254   2161
1920819 IN     school 1807320 1970   Muncie Community Schools 180732001232 1524 Youth Opportunity Center   Alternative School No High 05 12 2021   grade_10                         10.0 3.0                       13.0                         10 3                 13
1920820 IN     school 1807320 1970   Muncie Community Schools 180732001232 1524 Youth Opportunity Center   Alternative School No High 05 12 2021   grade_11                         8.0 3.0                       11.0                         8 3                 11
1920821 IN     school 1807320 1970   Muncie Community Schools 180732001232 1524 Youth Opportunity Center   Alternative School No High 05 12 2021   grade_12                         6.0 1.0                       7.0                         6 1                 7
1920822 IN     school 1807320 1970   Muncie Community Schools 180732001232 1524 Youth Opportunity Center   Alternative School No High 05 12 2021   grade_5                         2.0 0.0                       2.0                         2 0                 2
1920823 IN     school 1807320 1970   Muncie Community Schools 180732001232 1524 Youth Opportunity Center   Alternative School No High 05 12 2021   grade_6                         1.0 1.0                       2.0                         1 1                 2
1920824 IN     school 1807320 1970   Muncie Community Schools 180732001232 1524 Youth Opportunity Center   Alternative School No High 05 12 2021   grade_7                         6.0 2.0                       8.0                         6 2                 8
1920825 IN     school 1807320 1970   Muncie Community Schools 180732001232 1524 Youth Opportunity Center   Alternative School No High 05 12 2021   grade_8                         8.0 4.0                       12.0                         8 4                 12
1920826 IN     school 1807320 1970   Muncie Community Schools 180732001232 1524 Youth Opportunity Center   Alternative School No High 05 12 2021   grade_9                         10.0 6.0                       16.0                         10 6                 16
1920827 IN     school 1807320 1970   Muncie Community Schools 180732001232 1524 Youth Opportunity Center   Alternative School No High 05 12 2021   pk_12_total 45.0 9.0 6.0 1.0             10.0   51.0 20.0     3.0         3.0   34.0   71.0 45 9 6 1             10   51 20     3     3 34   71
1920725 IN     school 1807230 1910   Yorktown Community Schools 180723001218 1387 Yorktown Middle School   Regular School No Middle 06 08 2021   grade_6                         95.0 96.0                       191.0                         95 96                 191
1920726 IN     school 1807230 1910   Yorktown Community Schools 180723001218 1387 Yorktown Middle School   Regular School No Middle 06 08 2021   grade_7                         122.0 98.0                       220.0                         122 98                 220
1920727 IN     school 1807230 1910   Yorktown Community Schools 180723001218 1387 Yorktown Middle School   Regular School No Middle 06 08 2021   grade_8                         101.0 118.0                       219.0                         101 118                 219
1920728 IN     school 1807230 1910   Yorktown Community Schools 180723001218 1387 Yorktown Middle School   Regular School No Middle 06 08 2021   pk_12_total 520.0 37.0 17.0 1.0   19.0     2.0   34.0   318.0 312.0     8.0         228.0   64.0   630.0 520 37 17 1   19     2   34   318 312     8     228 64   630
1920729 IN     school 1807230 1910   Yorktown Community Schools 180723001217 1389 Yorktown High School   Regular School No High 09 12 2021   adult                         2.0 2.0                       4.0                         2 2                 4
1920730 IN     school 1807230 1910   Yorktown Community Schools 180723001217 1389 Yorktown High School   Regular School No High 09 12 2021   grade_10                         99.0 101.0                       200.0                         99 101                 200
1920731 IN     school 1807230 1910   Yorktown Community Schools 180723001217 1389 Yorktown High School   Regular School No High 09 12 2021   grade_11                         92.0 100.0                       192.0                         92 100                 192
1920732 IN     school 1807230 1910   Yorktown Community Schools 180723001217 1389 Yorktown High School   Regular School No High 09 12 2021   grade_12                         86.0 108.0                       194.0                         86 108                 194
1920733 IN     school 1807230 1910   Yorktown Community Schools 180723001217 1389 Yorktown High School   Regular School No High 09 12 2021   grade_9                         91.0 105.0                       196.0                         91 105                 196
1920734 IN     school 1807230 1910   Yorktown Community Schools 180723001217 1389 Yorktown High School   Regular School No High 09 12 2021   pk_12_total 646.0 39.0 33.0     22.0         46.0   370.0 416.0     3.0         234.0   86.0   786.0 646 39 33     22         46   370 416     3     234 86   786
1920735 IN     school 1807230 1910   Yorktown Community Schools 180723001216 1393 Yorktown Elementary School   Regular School No Elementary 03 05 2021   grade_3                         110.0 101.0                       211.0                         110 101                 211
1920736 IN     school 1807230 1910   Yorktown Community Schools 180723001216 1393 Yorktown Elementary School   Regular School No Elementary 03 05 2021   grade_4                         106.0 89.0                       195.0                         106 89                 195
1920737 IN     school 1807230 1910   Yorktown Community Schools 180723001216 1393 Yorktown Elementary School   Regular School No Elementary 03 05 2021   grade_5                         112.0 124.0                       236.0                         112 124                 236
1920738 IN     school 1807230 1910   Yorktown Community Schools 180723001216 1393 Yorktown Elementary School   Regular School No Elementary 03 05 2021   pk_12_total 544.0 18.0 12.0 3.0   23.0     1.0   41.0   328.0 314.0     11.0         218.0   92.0   642.0 544 18 12 3   23     1   41   328 314     11     218 92   642
1921024 IN     school 1806600 2275   Middlebury Community Schools 180660001166 1697 York Elementary School   Regular School No Elementary KG 03 2021   grade_1                         37.0 37.0                       74.0                         37 37                 74
1921025 IN     school 1806600 2275   Middlebury Community Schools 180660001166 1697 York Elementary School   Regular School No Elementary KG 03 2021   grade_2                         42.0 35.0                       77.0                         42 35                 77
1921026 IN     school 1806600 2275   Middlebury Community Schools 180660001166 1697 York Elementary School   Regular School No Elementary KG 03 2021   grade_3                         30.0 28.0                       58.0                         30 28                 58
1921027 IN     school 1806600 2275   Middlebury Community Schools 180660001166 1697 York Elementary School   Regular School No Elementary KG 03 2021   kindergarten                         37.0 24.0                       61.0                         37 24                 61
1921028 IN     school 1806600 2275   Middlebury Community Schools 180660001166 1697 York Elementary School   Regular School No Elementary KG 03 2021   pk_12_total 249.0 2.0 6.0     1.0         12.0   146.0 124.0     9.0         102.0   35.0   270.0 249 2 6     1         12   146 124     9     102 35   270
1929527 IN     school 1812390 8130   Warrick County School Corp 181239001988 8761 Yankeetown Elementary School   Regular School No Elementary KG 05 2021   grade_1                         17.0 30.0                       47.0                         17 30                 47
1929528 IN     school 1812390 8130   Warrick County School Corp 181239001988 8761 Yankeetown Elementary School   Regular School No Elementary KG 05 2021   grade_2                         20.0 25.0                       45.0                         20 25                 45
1929529 IN     school 1812390 8130   Warrick County School Corp 181239001988 8761 Yankeetown Elementary School   Regular School No Elementary KG 05 2021   grade_3                         25.0 21.0                       46.0                         25 21                 46
1929530 IN     school 1812390 8130   Warrick County School Corp 181239001988 8761 Yankeetown Elementary School   Regular School No Elementary KG 05 2021   grade_4                         15.0 22.0                       37.0                         15 22                 37
1929531 IN     school 1812390 8130   Warrick County School Corp 181239001988 8761 Yankeetown Elementary School   Regular School No Elementary KG 05 2021   grade_5                         24.0 34.0                       58.0                         24 34                 58
1929532 IN     school 1812390 8130   Warrick County School Corp 181239001988 8761 Yankeetown Elementary School   Regular School No Elementary KG 05 2021   kindergarten                         25.0 23.0                       48.0                         25 23                 48
1929533 IN     school 1812390 8130   Warrick County School Corp 181239001988 8761 Yankeetown Elementary School   Regular School No Elementary KG 05 2021   pk_12_total 256.0   13.0               12.0   126.0 155.0     7.0         100.0   48.0   281.0 256   13               12   126 155     7     100 48   281
1928734 IN     school 1811340 7865   Tippecanoe School Corp 181134002501 8006 Wyandotte Elementary   Regular School No Elementary KG 05 2021   grade_1                         39.0 39.0                       78.0                         39 39                 78
1928735 IN     school 1811340 7865   Tippecanoe School Corp 181134002501 8006 Wyandotte Elementary   Regular School No Elementary KG 05 2021   grade_2                         43.0 48.0                       91.0                         43 48                 91
1928736 IN     school 1811340 7865   Tippecanoe School Corp 181134002501 8006 Wyandotte Elementary   Regular School No Elementary KG 05 2021   grade_3                         44.0 42.0                       86.0                         44 42                 86
1928737 IN     school 1811340 7865   Tippecanoe School Corp 181134002501 8006 Wyandotte Elementary   Regular School No Elementary KG 05 2021   grade_4                         43.0 42.0                       85.0                         43 42                 85
1928738 IN     school 1811340 7865   Tippecanoe School Corp 181134002501 8006 Wyandotte Elementary   Regular School No Elementary KG 05 2021   grade_5                         34.0 48.0                       82.0                         34 48                 82
1928739 IN     school 1811340 7865   Tippecanoe School Corp 181134002501 8006 Wyandotte Elementary   Regular School No Elementary KG 05 2021   kindergarten                         43.0 46.0                       89.0                         43 46                 89
1928740 IN     school 1811340 7865   Tippecanoe School Corp 181134002501 8006 Wyandotte Elementary   Regular School No Elementary KG 05 2021   pk_12_total 357.0 21.0 82.0     25.0     1.0   25.0   246.0 265.0     44.0         133.0   86.0   511.0 357 21 82     25     1   25   246 265     44     133 86   511
1921084 IN     school 1812240 2285   Wa-Nee Community Schools 181224000034 1747 Woodview Elementary School   Regular School No Elementary KG 05 2021   grade_1                         35.0 29.0                       64.0                         35 29                 64
1921085 IN     school 1812240 2285   Wa-Nee Community Schools 181224000034 1747 Woodview Elementary School   Regular School No Elementary KG 05 2021   grade_2                         39.0 37.0                       76.0                         39 37                 76
1921086 IN     school 1812240 2285   Wa-Nee Community Schools 181224000034 1747 Woodview Elementary School   Regular School No Elementary KG 05 2021   grade_3                         38.0 31.0                       69.0                         38 31                 69
1921087 IN     school 1812240 2285   Wa-Nee Community Schools 181224000034 1747 Woodview Elementary School   Regular School No Elementary KG 05 2021   grade_4                         47.0 23.0                       70.0                         47 23                 70
1921088 IN     school 1812240 2285   Wa-Nee Community Schools 181224000034 1747 Woodview Elementary School   Regular School No Elementary KG 05 2021   grade_5                         33.0 35.0                       68.0                         33 35                 68
1921089 IN     school 1812240 2285   Wa-Nee Community Schools 181224000034 1747 Woodview Elementary School   Regular School No Elementary KG 05 2021   kindergarten                         28.0 46.0                       74.0                         28 46                 74
1921090 IN     school 1812240 2285   Wa-Nee Community Schools 181224000034 1747 Woodview Elementary School   Regular School No Elementary KG 05 2021   pk_12_total 353.0 3.0 47.0     5.0         13.0   220.0 201.0     33.0         152.0   49.0   421.0 353 3 47     5         13   220 201     33     152 49   421
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
1929267 IN     school 1812090 8030   Vigo County School Corp 181209001925 8485 Woodrow Wilson Middle School   Regular School No Middle 06 08 2021   grade_6                         133.0 125.0                       258.0                         133 125                 258
1929268 IN     school 1812090 8030   Vigo County School Corp 181209001925 8485 Woodrow Wilson Middle School   Regular School No Middle 06 08 2021   grade_7                         122.0 147.0                       269.0                         122 147                 269
1929269 IN     school 1812090 8030   Vigo County School Corp 181209001925 8485 Woodrow Wilson Middle School   Regular School No Middle 06 08 2021   grade_8                         140.0 138.0                       278.0                         140 138                 278
1929270 IN     school 1812090 8030   Vigo County School Corp 181209001925 8485 Woodrow Wilson Middle School   Regular School No Middle 06 08 2021   pk_12_total 609.0 56.0 52.0 1.0   1.0     1.0   85.0   395.0 410.0     13.0         470.0   177.0   805.0 609 56 52 1   1     1   85   395 410     13     470 177   805
1921227 IN     school 1803270 2305   Elkhart Community Schools 180327000447 1817 Woodland Elementary School   Regular School No Elementary PK 06 2021   grade_1                         34.0 28.0                       62.0                         34 28                 62
1921228 IN     school 1803270 2305   Elkhart Community Schools 180327000447 1817 Woodland Elementary School   Regular School No Elementary PK 06 2021   grade_2                         32.0 25.0                       57.0                         32 25                 57
1921229 IN     school 1803270 2305   Elkhart Community Schools 180327000447 1817 Woodland Elementary School   Regular School No Elementary PK 06 2021   grade_3                         29.0 30.0                       59.0                         29 30                 59
1921230 IN     school 1803270 2305   Elkhart Community Schools 180327000447 1817 Woodland Elementary School   Regular School No Elementary PK 06 2021   grade_4                         29.0 36.0                       65.0                         29 36                 65
1921231 IN     school 1803270 2305   Elkhart Community Schools 180327000447 1817 Woodland Elementary School   Regular School No Elementary PK 06 2021   grade_5                         34.0 22.0                       56.0                         34 22                 56
1921232 IN     school 1803270 2305   Elkhart Community Schools 180327000447 1817 Woodland Elementary School   Regular School No Elementary PK 06 2021   grade_6                         30.0 33.0                       63.0                         30 33                 63
1921233 IN     school 1803270 2305   Elkhart Community Schools 180327000447 1817 Woodland Elementary School   Regular School No Elementary PK 06 2021   kindergarten                         32.0 29.0                       61.0                         32 29                 61
1921234 IN     school 1803270 2305   Elkhart Community Schools 180327000447 1817 Woodland Elementary School   Regular School No Elementary PK 06 2021   pk_12_total 239.0 75.0 165.0 1.0   7.0     1.0   59.0   296.0 251.0     71.0         334.0   180.0   547.0 239 75 165 1   7     1   59   296 251     71     334 180   547
1921235 IN     school 1803270 2305   Elkhart Community Schools 180327000447 1817 Woodland Elementary School   Regular School No Elementary PK 06 2021   pre_kindergarten                         76.0 48.0                       124.0                         76 48                 124
1928826 IN     school 1811340 7865   Tippecanoe School Corp 181134002441 8111 Woodland Elementary School   Regular School No Elementary KG 05 2021   grade_1                         49.0 51.0                       100.0                         49 51                 100
1928827 IN     school 1811340 7865   Tippecanoe School Corp 181134002441 8111 Woodland Elementary School   Regular School No Elementary KG 05 2021   grade_2                         56.0 48.0                       104.0                         56 48                 104
1928828 IN     school 1811340 7865   Tippecanoe School Corp 181134002441 8111 Woodland Elementary School   Regular School No Elementary KG 05 2021   grade_3                         57.0 57.0                       114.0                         57 57                 114
1928829 IN     school 1811340 7865   Tippecanoe School Corp 181134002441 8111 Woodland Elementary School   Regular School No Elementary KG 05 2021   grade_4                         55.0 50.0                       105.0                         55 50                 105

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