Data source: Big Local News · About: Big Local

11,992 rows where state = "IN" and year = 2019

View and edit SQL

grade

year

  • 2019 · 11,892
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
1751646 IN     school 1800030 125   M S D Southwest Allen County Schls 180003002329 71 Deer Ridge Elementary   Regular School No Elementary KG 05 2019   kindergarten                         44.0 31.0                       75.0                         44 31                 75
1751647 IN     school 1800030 125   M S D Southwest Allen County Schls 180003002329 71 Deer Ridge Elementary   Regular School No Elementary KG 05 2019   pk_12_total 336.0 15.0 22.0     29.0         24.0   219.0 207.0     4.0         49.0   30.0   426.0 336 15 22     29         24   219 207     4     49 30   426
1751648 IN     school 1800030 125   M S D Southwest Allen County Schls 180003001810 72 Covington Elementary School   Regular School No Elementary KG 05 2019   grade_1                         94.0 61.0                       155.0                         94 61                 155
1751649 IN     school 1800030 125   M S D Southwest Allen County Schls 180003001810 72 Covington Elementary School   Regular School No Elementary KG 05 2019   grade_2                         60.0 70.0                       130.0                         60 70                 130
1751650 IN     school 1800030 125   M S D Southwest Allen County Schls 180003001810 72 Covington Elementary School   Regular School No Elementary KG 05 2019   grade_3                         69.0 61.0                       130.0                         69 61                 130
1751651 IN     school 1800030 125   M S D Southwest Allen County Schls 180003001810 72 Covington Elementary School   Regular School No Elementary KG 05 2019   grade_4                         74.0 72.0                       146.0                         74 72                 146
1751652 IN     school 1800030 125   M S D Southwest Allen County Schls 180003001810 72 Covington Elementary School   Regular School No Elementary KG 05 2019   grade_5                         65.0 75.0                       140.0                         65 75                 140
1751653 IN     school 1800030 125   M S D Southwest Allen County Schls 180003001810 72 Covington Elementary School   Regular School No Elementary KG 05 2019   kindergarten                         91.0 62.0                       153.0                         91 62                 153
1751654 IN     school 1800030 125   M S D Southwest Allen County Schls 180003001810 72 Covington Elementary School   Regular School No Elementary KG 05 2019   pk_12_total 636.0 101.0 46.0 1.0   24.0     1.0   45.0   453.0 401.0     9.0         189.0   83.0   854.0 636 101 46 1   24     1   45   453 401     9     189 83   854
1751655 IN     school 1808250 225   Northwest Allen County Schools 180825001413 69 Arcola School   Regular School No Elementary KG 05 2019   grade_1                         11.0 14.0                       25.0                         11 14                 25
1751656 IN     school 1808250 225   Northwest Allen County Schools 180825001413 69 Arcola School   Regular School No Elementary KG 05 2019   grade_2                         15.0 17.0                       32.0                         15 17                 32
1751657 IN     school 1808250 225   Northwest Allen County Schools 180825001413 69 Arcola School   Regular School No Elementary KG 05 2019   grade_3                         19.0 19.0                       38.0                         19 19                 38
1751658 IN     school 1808250 225   Northwest Allen County Schools 180825001413 69 Arcola School   Regular School No Elementary KG 05 2019   grade_4                         15.0 15.0                       30.0                         15 15                 30
1751659 IN     school 1808250 225   Northwest Allen County Schools 180825001413 69 Arcola School   Regular School No Elementary KG 05 2019   grade_5                         12.0 15.0                       27.0                         12 15                 27
1751660 IN     school 1808250 225   Northwest Allen County Schools 180825001413 69 Arcola School   Regular School No Elementary KG 05 2019   kindergarten                         17.0 21.0                       38.0                         17 21                 38
1751661 IN     school 1808250 225   Northwest Allen County Schools 180825001413 69 Arcola School   Regular School No Elementary KG 05 2019   pk_12_total 166.0   14.0 2.0             8.0   89.0 101.0     3.0         63.0   24.0   190.0 166   14 2             8   89 101     3     63 24   190
1751662 IN     school 1808250 225   Northwest Allen County Schools 180825001380 79 Maple Creek Middle School   Regular School No Middle 06 08 2019   grade_6                         166.0 144.0                       310.0                         166 144                 310
1751663 IN     school 1808250 225   Northwest Allen County Schools 180825001380 79 Maple Creek Middle School   Regular School No Middle 06 08 2019   grade_7                         160.0 127.0                       287.0                         160 127                 287
1751664 IN     school 1808250 225   Northwest Allen County Schools 180825001380 79 Maple Creek Middle School   Regular School No Middle 06 08 2019   grade_8                         163.0 141.0                       304.0                         163 141                 304
1751665 IN     school 1808250 225   Northwest Allen County Schools 180825001380 79 Maple Creek Middle School   Regular School No Middle 06 08 2019   pk_12_total 764.0 18.0 51.0     36.0         32.0   489.0 412.0     8.0         142.0   103.0   901.0 764 18 51     36         32   489 412     8     142 103   901
1751666 IN     school 1808250 225   Northwest Allen County Schools 180825000937 87 Hickory Center Elementary School   Regular School No Elementary PK 05 2019   grade_1                         30.0 40.0                       70.0                         30 40                 70
1751667 IN     school 1808250 225   Northwest Allen County Schools 180825000937 87 Hickory Center Elementary School   Regular School No Elementary PK 05 2019   grade_2                         34.0 33.0                       67.0                         34 33                 67
1751668 IN     school 1808250 225   Northwest Allen County Schools 180825000937 87 Hickory Center Elementary School   Regular School No Elementary PK 05 2019   grade_3                         44.0 38.0                       82.0                         44 38                 82
1751669 IN     school 1808250 225   Northwest Allen County Schools 180825000937 87 Hickory Center Elementary School   Regular School No Elementary PK 05 2019   grade_4                         32.0 40.0                       72.0                         32 40                 72
1751670 IN     school 1808250 225   Northwest Allen County Schools 180825000937 87 Hickory Center Elementary School   Regular School No Elementary PK 05 2019   grade_5                         32.0 44.0                       76.0                         32 44                 76
1751671 IN     school 1808250 225   Northwest Allen County Schools 180825000937 87 Hickory Center Elementary School   Regular School No Elementary PK 05 2019   kindergarten                         33.0 21.0                       54.0                         33 21                 54
1751672 IN     school 1808250 225   Northwest Allen County Schools 180825000937 87 Hickory Center Elementary School   Regular School No Elementary PK 05 2019   pk_12_total 361.0 5.0 9.0 2.0   18.0         34.0   211.0 218.0     16.0         85.0   73.0   429.0 361 5 9 2   18         34   211 218     16     85 73   429
1751673 IN     school 1808250 225   Northwest Allen County Schools 180825000937 87 Hickory Center Elementary School   Regular School No Elementary PK 05 2019   pre_kindergarten                         6.0 2.0                       8.0                         6 2                 8
1751674 IN     school 1808250 225   Northwest Allen County Schools 180825001415 89 Huntertown Elementary School   Regular School No Elementary KG 05 2019   grade_1                         66.0 47.0                       113.0                         66 47                 113
1751675 IN     school 1808250 225   Northwest Allen County Schools 180825001415 89 Huntertown Elementary School   Regular School No Elementary KG 05 2019   grade_2                         57.0 67.0                       124.0                         57 67                 124
1751676 IN     school 1808250 225   Northwest Allen County Schools 180825001415 89 Huntertown Elementary School   Regular School No Elementary KG 05 2019   grade_3                         55.0 43.0                       98.0                         55 43                 98
1751677 IN     school 1808250 225   Northwest Allen County Schools 180825001415 89 Huntertown Elementary School   Regular School No Elementary KG 05 2019   grade_4                         56.0 58.0                       114.0                         56 58                 114
1751678 IN     school 1808250 225   Northwest Allen County Schools 180825001415 89 Huntertown Elementary School   Regular School No Elementary KG 05 2019   grade_5                         59.0 59.0                       118.0                         59 59                 118
1751679 IN     school 1808250 225   Northwest Allen County Schools 180825001415 89 Huntertown Elementary School   Regular School No Elementary KG 05 2019   kindergarten                         55.0 36.0                       91.0                         55 36                 91
1751680 IN     school 1808250 225   Northwest Allen County Schools 180825001415 89 Huntertown Elementary School   Regular School No Elementary KG 05 2019   pk_12_total 544.0 9.0 39.0     29.0         37.0   348.0 310.0     26.0         218.0   116.0   658.0 544 9 39     29         37   348 310     26     218 116   658
1751681 IN     school 1808250 225   Northwest Allen County Schools 180825002294 90 Carroll Middle School   Regular School No Middle 06 08 2019   grade_6                         159.0 153.0                       312.0                         159 153                 312
1751682 IN     school 1808250 225   Northwest Allen County Schools 180825002294 90 Carroll Middle School   Regular School No Middle 06 08 2019   grade_7                         153.0 154.0                       307.0                         153 154                 307
1751683 IN     school 1808250 225   Northwest Allen County Schools 180825002294 90 Carroll Middle School   Regular School No Middle 06 08 2019   grade_8                         143.0 154.0                       297.0                         143 154                 297
1751684 IN     school 1808250 225   Northwest Allen County Schools 180825002294 90 Carroll Middle School   Regular School No Middle 06 08 2019   pk_12_total 770.0 27.0 44.0 1.0   24.0         50.0   455.0 461.0     7.0         221.0   136.0   916.0 770 27 44 1   24         50   455 461     7     221 136   916
1751685 IN     school 1808250 225   Northwest Allen County Schools 180825001414 91 Carroll High School   Regular School No High 09 12 2019   grade_10                         332.0 320.0                       652.0                         332 320                 652
1751686 IN     school 1808250 225   Northwest Allen County Schools 180825001414 91 Carroll High School   Regular School No High 09 12 2019   grade_11                         276.0 322.0                       598.0                         276 322                 598
1751687 IN     school 1808250 225   Northwest Allen County Schools 180825001414 91 Carroll High School   Regular School No High 09 12 2019   grade_12                         255.0 310.0                       565.0                         255 310                 565
1751688 IN     school 1808250 225   Northwest Allen County Schools 180825001414 91 Carroll High School   Regular School No High 09 12 2019   grade_9                         320.0 277.0                       597.0                         320 277                 597
1751689 IN     school 1808250 225   Northwest Allen County Schools 180825001414 91 Carroll High School   Regular School No High 09 12 2019   pk_12_total 2059.0 59.0 97.0 7.0   98.0         92.0   1183.0 1229.0     19.0         433.0   260.0   2412.0 2059 59 97 7   98         92   1183 1229     19     433 260   2412
1751690 IN     school 1808250 225   Northwest Allen County Schools 180825001416 92 Perry Hill Elementary School   Regular School No Elementary KG 05 2019   grade_1                         51.0 50.0                       101.0                         51 50                 101
1751691 IN     school 1808250 225   Northwest Allen County Schools 180825001416 92 Perry Hill Elementary School   Regular School No Elementary KG 05 2019   grade_2                         50.0 35.0                       85.0                         50 35                 85
1751692 IN     school 1808250 225   Northwest Allen County Schools 180825001416 92 Perry Hill Elementary School   Regular School No Elementary KG 05 2019   grade_3                         54.0 43.0                       97.0                         54 43                 97
1751693 IN     school 1808250 225   Northwest Allen County Schools 180825001416 92 Perry Hill Elementary School   Regular School No Elementary KG 05 2019   grade_4                         48.0 49.0                       97.0                         48 49                 97
1751694 IN     school 1808250 225   Northwest Allen County Schools 180825001416 92 Perry Hill Elementary School   Regular School No Elementary KG 05 2019   grade_5                         35.0 49.0                       84.0                         35 49                 84
1751695 IN     school 1808250 225   Northwest Allen County Schools 180825001416 92 Perry Hill Elementary School   Regular School No Elementary KG 05 2019   kindergarten                         45.0 54.0                       99.0                         45 54                 99
1751696 IN     school 1808250 225   Northwest Allen County Schools 180825001416 92 Perry Hill Elementary School   Regular School No Elementary KG 05 2019   pk_12_total 469.0 18.0 25.0     19.0         32.0   283.0 280.0     8.0         98.0   62.0   563.0 469 18 25     19         32   283 280     8     98 62   563
1751697 IN     school 1808250 225   Northwest Allen County Schools 180825000016 94 Oak View Elementary School   Regular School No Elementary KG 05 2019   grade_1                         48.0 45.0                       93.0                         48 45                 93
1751698 IN     school 1808250 225   Northwest Allen County Schools 180825000016 94 Oak View Elementary School   Regular School No Elementary KG 05 2019   grade_2                         52.0 50.0                       102.0                         52 50                 102
1751699 IN     school 1808250 225   Northwest Allen County Schools 180825000016 94 Oak View Elementary School   Regular School No Elementary KG 05 2019   grade_3                         43.0 34.0                       77.0                         43 34                 77
1751700 IN     school 1808250 225   Northwest Allen County Schools 180825000016 94 Oak View Elementary School   Regular School No Elementary KG 05 2019   grade_4                         41.0 39.0                       80.0                         41 39                 80
1751701 IN     school 1808250 225   Northwest Allen County Schools 180825000016 94 Oak View Elementary School   Regular School No Elementary KG 05 2019   grade_5                         40.0 33.0                       73.0                         40 33                 73
1751702 IN     school 1808250 225   Northwest Allen County Schools 180825000016 94 Oak View Elementary School   Regular School No Elementary KG 05 2019   kindergarten                         38.0 39.0                       77.0                         38 39                 77
1751703 IN     school 1808250 225   Northwest Allen County Schools 180825000016 94 Oak View Elementary School   Regular School No Elementary KG 05 2019   pk_12_total 424.0 9.0 16.0     17.0         36.0   262.0 240.0     14.0         42.0   42.0   502.0 424 9 16     17         36   262 240     14     42 42   502
1751704 IN     school 1808250 225   Northwest Allen County Schools 180825002166 95 Cedar Canyon Elementary School   Regular School No Elementary PK 05 2019   grade_1                         40.0 47.0                       87.0                         40 47                 87
1751705 IN     school 1808250 225   Northwest Allen County Schools 180825002166 95 Cedar Canyon Elementary School   Regular School No Elementary PK 05 2019   grade_2                         41.0 51.0                       92.0                         41 51                 92
1751706 IN     school 1808250 225   Northwest Allen County Schools 180825002166 95 Cedar Canyon Elementary School   Regular School No Elementary PK 05 2019   grade_3                         45.0 38.0                       83.0                         45 38                 83
1751707 IN     school 1808250 225   Northwest Allen County Schools 180825002166 95 Cedar Canyon Elementary School   Regular School No Elementary PK 05 2019   grade_4                         49.0 45.0                       94.0                         49 45                 94
1751708 IN     school 1808250 225   Northwest Allen County Schools 180825002166 95 Cedar Canyon Elementary School   Regular School No Elementary PK 05 2019   grade_5                         56.0 53.0                       109.0                         56 53                 109
1751709 IN     school 1808250 225   Northwest Allen County Schools 180825002166 95 Cedar Canyon Elementary School   Regular School No Elementary PK 05 2019   kindergarten                         56.0 29.0                       85.0                         56 29                 85
1751710 IN     school 1808250 225   Northwest Allen County Schools 180825002166 95 Cedar Canyon Elementary School   Regular School No Elementary PK 05 2019   pk_12_total 469.0 22.0 26.0 1.0   33.0         22.0   302.0 271.0     14.0         53.0   81.0   573.0 469 22 26 1   33         22   302 271     14     53 81   573
1751711 IN     school 1808250 225   Northwest Allen County Schools 180825002166 95 Cedar Canyon Elementary School   Regular School No Elementary PK 05 2019   pre_kindergarten                         15.0 8.0                       23.0                         15 8                 23
1751712 IN     school 1808250 225   Northwest Allen County Schools 180825002457 96 Eel River Elementary School   Regular School No Elementary KG 05 2019   grade_1                         58.0 41.0                       99.0                         58 41                 99
1751713 IN     school 1808250 225   Northwest Allen County Schools 180825002457 96 Eel River Elementary School   Regular School No Elementary KG 05 2019   grade_2                         50.0 55.0                       105.0                         50 55                 105
1751714 IN     school 1808250 225   Northwest Allen County Schools 180825002457 96 Eel River Elementary School   Regular School No Elementary KG 05 2019   grade_3                         38.0 40.0                       78.0                         38 40                 78
1751715 IN     school 1808250 225   Northwest Allen County Schools 180825002457 96 Eel River Elementary School   Regular School No Elementary KG 05 2019   grade_4                         47.0 32.0                       79.0                         47 32                 79
1751716 IN     school 1808250 225   Northwest Allen County Schools 180825002457 96 Eel River Elementary School   Regular School No Elementary KG 05 2019   grade_5                         52.0 51.0                       103.0                         52 51                 103
1751717 IN     school 1808250 225   Northwest Allen County Schools 180825002457 96 Eel River Elementary School   Regular School No Elementary KG 05 2019   kindergarten                         50.0 64.0                       114.0                         50 64                 114
1751718 IN     school 1808250 225   Northwest Allen County Schools 180825002457 96 Eel River Elementary School   Regular School No Elementary KG 05 2019   pk_12_total 469.0 11.0 29.0     18.0         51.0   295.0 283.0     31.0         117.0   79.0   578.0 469 11 29     18         51   295 283     31     117 79   578
1751719 IN     school 1803630 235   Fort Wayne Community Schools 180363002174 100 Allen Co Juvenile Center   Regular School No High 08 12 2019   grade_10                         2.0 0.0                       2.0                         2 0                 2
1751720 IN     school 1803630 235   Fort Wayne Community Schools 180363002174 100 Allen Co Juvenile Center   Regular School No High 08 12 2019   grade_11                         1.0 0.0                       1.0                         1 0                 1
1751721 IN     school 1803630 235   Fort Wayne Community Schools 180363002174 100 Allen Co Juvenile Center   Regular School No High 08 12 2019   grade_12                         1.0 0.0                       1.0                         1 0                 1
1751722 IN     school 1803630 235   Fort Wayne Community Schools 180363002174 100 Allen Co Juvenile Center   Regular School No High 08 12 2019   grade_8                         1.0 0.0                       1.0                         1 0                 1
1751723 IN     school 1803630 235   Fort Wayne Community Schools 180363002174 100 Allen Co Juvenile Center   Regular School No High 08 12 2019   grade_9                         1.0 0.0                       1.0                         1 0                 1
1751724 IN     school 1803630 235   Fort Wayne Community Schools 180363002174 100 Allen Co Juvenile Center   Regular School No High 08 12 2019   pk_12_total 1.0 3.0 1.0               1.0   6.0 0.0     0.0             3.0   6.0 1 3 1               1   6 0     0       3   6
1751725 IN     school 1803630 235   Fort Wayne Community Schools 180363000550 101 North Side High School   Regular School No High 09 12 2019   grade_10                         204.0 176.0                       380.0                         204 176                 380
1751726 IN     school 1803630 235   Fort Wayne Community Schools 180363000550 101 North Side High School   Regular School No High 09 12 2019   grade_11                         194.0 181.0                       375.0                         194 181                 375
1751727 IN     school 1803630 235   Fort Wayne Community Schools 180363000550 101 North Side High School   Regular School No High 09 12 2019   grade_12                         209.0 196.0                       405.0                         209 196                 405
1751728 IN     school 1803630 235   Fort Wayne Community Schools 180363000550 101 North Side High School   Regular School No High 09 12 2019   grade_9                         191.0 199.0                       390.0                         191 199                 390
1751729 IN     school 1803630 235   Fort Wayne Community Schools 180363000550 101 North Side High School   Regular School No High 09 12 2019   pk_12_total 673.0 346.0 258.0 3.0   97.0     1.0   172.0   798.0 752.0     100.0         970.0   308.0   1550.0 673 346 258 3   97     1   172   798 752     100     970 308   1550
1751730 IN     school 1803630 235   Fort Wayne Community Schools 180363000556 102 R Nelson Snider High School   Regular School No High 09 12 2019   grade_10                         235.0 239.0                       474.0                         235 239                 474
1751731 IN     school 1803630 235   Fort Wayne Community Schools 180363000556 102 R Nelson Snider High School   Regular School No High 09 12 2019   grade_11                         218.0 234.0                       452.0                         218 234                 452
1751732 IN     school 1803630 235   Fort Wayne Community Schools 180363000556 102 R Nelson Snider High School   Regular School No High 09 12 2019   grade_12                         234.0 226.0                       460.0                         234 226                 460
1751733 IN     school 1803630 235   Fort Wayne Community Schools 180363000556 102 R Nelson Snider High School   Regular School No High 09 12 2019   grade_9                         235.0 239.0                       474.0                         235 239                 474
1751734 IN     school 1803630 235   Fort Wayne Community Schools 180363000556 102 R Nelson Snider High School   Regular School No High 09 12 2019   pk_12_total 980.0 436.0 200.0 13.0   89.0         142.0   922.0 938.0     71.0         780.0   235.0   1860.0 980 436 200 13   89         142   922 938     71     780 235   1860
1751735 IN     school 1803630 235   Fort Wayne Community Schools 180363000562 105 South Side High School   Regular School No High 09 12 2019   grade_10                         165.0 159.0                       324.0                         165 159                 324
1751736 IN     school 1803630 235   Fort Wayne Community Schools 180363000562 105 South Side High School   Regular School No High 09 12 2019   grade_11                         182.0 192.0                       374.0                         182 192                 374
1751737 IN     school 1803630 235   Fort Wayne Community Schools 180363000562 105 South Side High School   Regular School No High 09 12 2019   grade_12                         165.0 163.0                       328.0                         165 163                 328
1751738 IN     school 1803630 235   Fort Wayne Community Schools 180363000562 105 South Side High School   Regular School No High 09 12 2019   grade_9                         149.0 183.0                       332.0                         149 183                 332
1751739 IN     school 1803630 235   Fort Wayne Community Schools 180363000562 105 South Side High School   Regular School No High 09 12 2019   pk_12_total 264.0 435.0 424.0     109.0     2.0   124.0   661.0 697.0     170.0         939.0   239.0   1358.0 264 435 424     109     2   124   661 697     170     939 239   1358
1751740 IN     school 1803630 235   Fort Wayne Community Schools 180363000516 107 Blackhawk Middle School   Regular School No Middle 06 08 2019   grade_6                         135.0 134.0                       269.0                         135 134                 269
1751741 IN     school 1803630 235   Fort Wayne Community Schools 180363000516 107 Blackhawk Middle School   Regular School No Middle 06 08 2019   grade_7                         152.0 134.0                       286.0                         152 134                 286
1751742 IN     school 1803630 235   Fort Wayne Community Schools 180363000516 107 Blackhawk Middle School   Regular School No Middle 06 08 2019   grade_8                         127.0 132.0                       259.0                         127 132                 259
1751743 IN     school 1803630 235   Fort Wayne Community Schools 180363000516 107 Blackhawk Middle School   Regular School No Middle 06 08 2019   pk_12_total 456.0 175.0 66.0 2.0   46.0     1.0   68.0   414.0 400.0     21.0         351.0   111.0   814.0 456 175 66 2   46     1   68   414 400     21     351 111   814
1751744 IN     school 1803630 235   Fort Wayne Community Schools 180363002175 118 Jeff H Towles Intermediate School   Regular School No Elementary 01 08 2019   grade_1                         40.0 31.0                       71.0                         40 31                 71
1751745 IN     school 1803630 235   Fort Wayne Community Schools 180363002175 118 Jeff H Towles Intermediate School   Regular School No Elementary 01 08 2019   grade_2                         31.0 35.0                       66.0                         31 35                 66

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