enrollments

Data source: Big Local News · About: Big Local

84,143 rows where state = "IN" sorted by white

✎ View and edit SQL

This data as json, CSV (advanced)

grade ✖

year ✖

Link rowid state county county_state_id admin_level district_nces_id district_state_id district_state_type district school_nces_id school_state_id school school_state_type ccd_school_type ccd_charter_school ccd_school_lvl ccd_school_low_grade ccd_school_high_grade year term grade white ▼ black hispanic native_american native_american_alaskan_native asian native_hawaiian asian_pacific_islander native_hawaiian_pacific_islander pacific_islander multiracial unknown_race male female non_binary unknown_gender ell ell_percent homeless homeless_percent low_income free_and_reduced free_and_reduced_percent disability section_504 total white_int black_int hispanic_int native_american_int native_american_alaskan_native_int asian_int native_hawaiian_int asian_pacific_islander_int native_hawaiian_pacific_islander_int pacific_islander_int multiracial_int unknown_race_int male_int female_int non_binary_int unknown_gender_int ell_int homeless_int low_income_int free_and_reduced_int disability_int section_504_int total_int
1159583 1159583 IN     school 1808250 225   Northwest Allen County Schools 180825000937 87 Hickory Center Elementary Sch   Regular School No 1.0 KG 05 2015   grade_2                         27.0 37.0                       64.0                         27 37                 64
1159584 1159584 IN     school 1808250 225   Northwest Allen County Schools 180825000937 87 Hickory Center Elementary Sch   Regular School No 1.0 KG 05 2015   grade_3                         39.0 38.0                       77.0                         39 38                 77
1159585 1159585 IN     school 1808250 225   Northwest Allen County Schools 180825000937 87 Hickory Center Elementary Sch   Regular School No 1.0 KG 05 2015   grade_4                         28.0 35.0                       63.0                         28 35                 63
1159586 1159586 IN     school 1808250 225   Northwest Allen County Schools 180825000937 87 Hickory Center Elementary Sch   Regular School No 1.0 KG 05 2015   grade_5                         48.0 34.0                       82.0                         48 34                 82
1159587 1159587 IN     school 1808250 225   Northwest Allen County Schools 180825000937 87 Hickory Center Elementary Sch   Regular School No 1.0 KG 05 2015   kindergarten                         32.0 41.0                       73.0                         32 41                 73
1159589 1159589 IN     school 1808250 225   Northwest Allen County Schools 180825001415 89 Huntertown Elementary School   Regular School No 1.0 KG 05 2015   grade_1                         46.0 40.0                       86.0                         46 40                 86
1159590 1159590 IN     school 1808250 225   Northwest Allen County Schools 180825001415 89 Huntertown Elementary School   Regular School No 1.0 KG 05 2015   grade_2                         58.0 42.0                       100.0                         58 42                 100
1159591 1159591 IN     school 1808250 225   Northwest Allen County Schools 180825001415 89 Huntertown Elementary School   Regular School No 1.0 KG 05 2015   grade_3                         46.0 40.0                       86.0                         46 40                 86
1159592 1159592 IN     school 1808250 225   Northwest Allen County Schools 180825001415 89 Huntertown Elementary School   Regular School No 1.0 KG 05 2015   grade_4                         55.0 34.0                       89.0                         55 34                 89
1159593 1159593 IN     school 1808250 225   Northwest Allen County Schools 180825001415 89 Huntertown Elementary School   Regular School No 1.0 KG 05 2015   grade_5                         56.0 42.0                       98.0                         56 42                 98
1159594 1159594 IN     school 1808250 225   Northwest Allen County Schools 180825001415 89 Huntertown Elementary School   Regular School No 1.0 KG 05 2015   kindergarten                         58.0 47.0                       105.0                         58 47                 105
1159596 1159596 IN     school 1808250 225   Northwest Allen County Schools 180825002294 90 Carroll Middle School   Regular School No 2.0 06 08 2015   grade_6                         169.0 165.0                       334.0                         169 165                 334
1159597 1159597 IN     school 1808250 225   Northwest Allen County Schools 180825002294 90 Carroll Middle School   Regular School No 2.0 06 08 2015   grade_7                         154.0 162.0                       316.0                         154 162                 316
1159598 1159598 IN     school 1808250 225   Northwest Allen County Schools 180825002294 90 Carroll Middle School   Regular School No 2.0 06 08 2015   grade_8                         154.0 174.0                       328.0                         154 174                 328
1159600 1159600 IN     school 1808250 225   Northwest Allen County Schools 180825001414 91 Carroll High School   Regular School No 3.0 09 12 2015   grade_10                         255.0 261.0                       516.0                         255 261                 516
1159601 1159601 IN     school 1808250 225   Northwest Allen County Schools 180825001414 91 Carroll High School   Regular School No 3.0 09 12 2015   grade_11                         249.0 277.0                       526.0                         249 277                 526
1159602 1159602 IN     school 1808250 225   Northwest Allen County Schools 180825001414 91 Carroll High School   Regular School No 3.0 09 12 2015   grade_12                         285.0 236.0                       521.0                         285 236                 521
1159603 1159603 IN     school 1808250 225   Northwest Allen County Schools 180825001414 91 Carroll High School   Regular School No 3.0 09 12 2015   grade_9                         298.0 276.0                       574.0                         298 276                 574
1159605 1159605 IN     school 1808250 225   Northwest Allen County Schools 180825001416 92 Perry Hill Elementary School   Regular School No 1.0 KG 05 2015   grade_1                         33.0 34.0                       67.0                         33 34                 67
1159606 1159606 IN     school 1808250 225   Northwest Allen County Schools 180825001416 92 Perry Hill Elementary School   Regular School No 1.0 KG 05 2015   grade_2                         37.0 36.0                       73.0                         37 36                 73
1159607 1159607 IN     school 1808250 225   Northwest Allen County Schools 180825001416 92 Perry Hill Elementary School   Regular School No 1.0 KG 05 2015   grade_3                         44.0 41.0                       85.0                         44 41                 85
1159608 1159608 IN     school 1808250 225   Northwest Allen County Schools 180825001416 92 Perry Hill Elementary School   Regular School No 1.0 KG 05 2015   grade_4                         50.0 52.0                       102.0                         50 52                 102
1159609 1159609 IN     school 1808250 225   Northwest Allen County Schools 180825001416 92 Perry Hill Elementary School   Regular School No 1.0 KG 05 2015   grade_5                         45.0 35.0                       80.0                         45 35                 80
1159610 1159610 IN     school 1808250 225   Northwest Allen County Schools 180825001416 92 Perry Hill Elementary School   Regular School No 1.0 KG 05 2015   kindergarten                         38.0 40.0                       78.0                         38 40                 78
1159612 1159612 IN     school 1808250 225   Northwest Allen County Schools 180825000016 94 Oak View Elementary Sch   Regular School No 1.0 KG 05 2015   grade_1                         32.0 35.0                       67.0                         32 35                 67
1159613 1159613 IN     school 1808250 225   Northwest Allen County Schools 180825000016 94 Oak View Elementary Sch   Regular School No 1.0 KG 05 2015   grade_2                         37.0 33.0                       70.0                         37 33                 70
1159614 1159614 IN     school 1808250 225   Northwest Allen County Schools 180825000016 94 Oak View Elementary Sch   Regular School No 1.0 KG 05 2015   grade_3                         45.0 26.0                       71.0                         45 26                 71
1159615 1159615 IN     school 1808250 225   Northwest Allen County Schools 180825000016 94 Oak View Elementary Sch   Regular School No 1.0 KG 05 2015   grade_4                         30.0 23.0                       53.0                         30 23                 53
1159616 1159616 IN     school 1808250 225   Northwest Allen County Schools 180825000016 94 Oak View Elementary Sch   Regular School No 1.0 KG 05 2015   grade_5                         42.0 45.0                       87.0                         42 45                 87
1159617 1159617 IN     school 1808250 225   Northwest Allen County Schools 180825000016 94 Oak View Elementary Sch   Regular School No 1.0 KG 05 2015   kindergarten                         38.0 38.0                       76.0                         38 38                 76
1159619 1159619 IN     school 1808250 225   Northwest Allen County Schools 180825002166 95 Cedar Canyon Elementary Sch   Regular School No 1.0 PK 05 2015   grade_1                         41.0 36.0                       77.0                         41 36                 77
1159620 1159620 IN     school 1808250 225   Northwest Allen County Schools 180825002166 95 Cedar Canyon Elementary Sch   Regular School No 1.0 PK 05 2015   grade_2                         48.0 40.0                       88.0                         48 40                 88
1159621 1159621 IN     school 1808250 225   Northwest Allen County Schools 180825002166 95 Cedar Canyon Elementary Sch   Regular School No 1.0 PK 05 2015   grade_3                         50.0 44.0                       94.0                         50 44                 94
1159622 1159622 IN     school 1808250 225   Northwest Allen County Schools 180825002166 95 Cedar Canyon Elementary Sch   Regular School No 1.0 PK 05 2015   grade_4                         44.0 42.0                       86.0                         44 42                 86
1159623 1159623 IN     school 1808250 225   Northwest Allen County Schools 180825002166 95 Cedar Canyon Elementary Sch   Regular School No 1.0 PK 05 2015   grade_5                         36.0 40.0                       76.0                         36 40                 76
1159624 1159624 IN     school 1808250 225   Northwest Allen County Schools 180825002166 95 Cedar Canyon Elementary Sch   Regular School No 1.0 PK 05 2015   kindergarten                         42.0 32.0                       74.0                         42 32                 74
1159626 1159626 IN     school 1808250 225   Northwest Allen County Schools 180825002166 95 Cedar Canyon Elementary Sch   Regular School No 1.0 PK 05 2015   pre_kindergarten                         21.0 6.0                       27.0                         21 6                 27
1159627 1159627 IN     school 1808250 225   Northwest Allen County Schools 180825002457 96 Eel River Elementary School   Regular School No 1.0 KG 05 2015   grade_1                         47.0 45.0                       92.0                         47 45                 92
1159628 1159628 IN     school 1808250 225   Northwest Allen County Schools 180825002457 96 Eel River Elementary School   Regular School No 1.0 KG 05 2015   grade_2                         48.0 41.0                       89.0                         48 41                 89
1159629 1159629 IN     school 1808250 225   Northwest Allen County Schools 180825002457 96 Eel River Elementary School   Regular School No 1.0 KG 05 2015   grade_3                         38.0 55.0                       93.0                         38 55                 93
1159630 1159630 IN     school 1808250 225   Northwest Allen County Schools 180825002457 96 Eel River Elementary School   Regular School No 1.0 KG 05 2015   grade_4                         39.0 47.0                       86.0                         39 47                 86
1159631 1159631 IN     school 1808250 225   Northwest Allen County Schools 180825002457 96 Eel River Elementary School   Regular School No 1.0 KG 05 2015   grade_5                         35.0 43.0                       78.0                         35 43                 78
1159632 1159632 IN     school 1808250 225   Northwest Allen County Schools 180825002457 96 Eel River Elementary School   Regular School No 1.0 KG 05 2015   kindergarten                         40.0 29.0                       69.0                         40 29                 69
1159634 1159634 IN     school 1808250 225   Northwest Allen County Schools 180825002160 145 Allen Co Youth Services Ctr   Alternative Education School No 4.0 04 11 2015   grade_10                         3.0 0.0                       3.0                         3 0                 3
1159635 1159635 IN     school 1808250 225   Northwest Allen County Schools 180825002160 145 Allen Co Youth Services Ctr   Alternative Education School No 4.0 04 11 2015   grade_11                         2.0 2.0                       4.0                         2 2                 4
1159636 1159636 IN     school 1808250 225   Northwest Allen County Schools 180825002160 145 Allen Co Youth Services Ctr   Alternative Education School No 4.0 04 11 2015   grade_4                         2.0 0.0                       2.0                         2 0                 2
1159637 1159637 IN     school 1808250 225   Northwest Allen County Schools 180825002160 145 Allen Co Youth Services Ctr   Alternative Education School No 4.0 04 11 2015   grade_6                         2.0 0.0                       2.0                         2 0                 2
1159638 1159638 IN     school 1808250 225   Northwest Allen County Schools 180825002160 145 Allen Co Youth Services Ctr   Alternative Education School No 4.0 04 11 2015   grade_9                         0.0 1.0                       1.0                         0 1                 1
1159640 1159640 IN     school 1803630 235   Fort Wayne Community Schools 180363002174 100 Allen Co Juvenile Center   Regular School No 3.0 07 12 2015   grade_10                         2.0 0.0                       2.0                         2 0                 2
1159641 1159641 IN     school 1803630 235   Fort Wayne Community Schools 180363002174 100 Allen Co Juvenile Center   Regular School No 3.0 07 12 2015   grade_11                         3.0 0.0                       3.0                         3 0                 3
1159642 1159642 IN     school 1803630 235   Fort Wayne Community Schools 180363002174 100 Allen Co Juvenile Center   Regular School No 3.0 07 12 2015   grade_12                         1.0 0.0                       1.0                         1 0                 1
1159643 1159643 IN     school 1803630 235   Fort Wayne Community Schools 180363002174 100 Allen Co Juvenile Center   Regular School No 3.0 07 12 2015   grade_7                         1.0 0.0                       1.0                         1 0                 1
1159644 1159644 IN     school 1803630 235   Fort Wayne Community Schools 180363002174 100 Allen Co Juvenile Center   Regular School No 3.0 07 12 2015   grade_8                         1.0 0.0                       1.0                         1 0                 1
1159645 1159645 IN     school 1803630 235   Fort Wayne Community Schools 180363002174 100 Allen Co Juvenile Center   Regular School No 3.0 07 12 2015   grade_9                         4.0 0.0                       4.0                         4 0                 4
1159647 1159647 IN     school 1803630 235   Fort Wayne Community Schools 180363000550 101 North Side High School   Regular School No 3.0 09 12 2015   grade_10                         223.0 239.0                       462.0                         223 239                 462
1159648 1159648 IN     school 1803630 235   Fort Wayne Community Schools 180363000550 101 North Side High School   Regular School No 3.0 09 12 2015   grade_11                         191.0 200.0                       391.0                         191 200                 391
1159649 1159649 IN     school 1803630 235   Fort Wayne Community Schools 180363000550 101 North Side High School   Regular School No 3.0 09 12 2015   grade_12                         244.0 205.0                       449.0                         244 205                 449
1159650 1159650 IN     school 1803630 235   Fort Wayne Community Schools 180363000550 101 North Side High School   Regular School No 3.0 09 12 2015   grade_9                         271.0 233.0                       504.0                         271 233                 504
1159652 1159652 IN     school 1803630 235   Fort Wayne Community Schools 180363000556 102 R Nelson Snider High School   Regular School No 3.0 09 12 2015   grade_10                         227.0 248.0                       475.0                         227 248                 475
1159653 1159653 IN     school 1803630 235   Fort Wayne Community Schools 180363000556 102 R Nelson Snider High School   Regular School No 3.0 09 12 2015   grade_11                         218.0 228.0                       446.0                         218 228                 446
1159654 1159654 IN     school 1803630 235   Fort Wayne Community Schools 180363000556 102 R Nelson Snider High School   Regular School No 3.0 09 12 2015   grade_12                         215.0 232.0                       447.0                         215 232                 447
1159655 1159655 IN     school 1803630 235   Fort Wayne Community Schools 180363000556 102 R Nelson Snider High School   Regular School No 3.0 09 12 2015   grade_9                         211.0 251.0                       462.0                         211 251                 462
1159657 1159657 IN     school 1803630 235   Fort Wayne Community Schools 180363000562 105 South Side High School   Regular School No 3.0 09 12 2015   grade_10                         177.0 155.0                       332.0                         177 155                 332
1159658 1159658 IN     school 1803630 235   Fort Wayne Community Schools 180363000562 105 South Side High School   Regular School No 3.0 09 12 2015   grade_11                         154.0 194.0                       348.0                         154 194                 348
1159659 1159659 IN     school 1803630 235   Fort Wayne Community Schools 180363000562 105 South Side High School   Regular School No 3.0 09 12 2015   grade_12                         159.0 153.0                       312.0                         159 153                 312
1159660 1159660 IN     school 1803630 235   Fort Wayne Community Schools 180363000562 105 South Side High School   Regular School No 3.0 09 12 2015   grade_9                         180.0 186.0                       366.0                         180 186                 366
1159662 1159662 IN     school 1803630 235   Fort Wayne Community Schools 180363000516 107 Blackhawk Middle School   Regular School No 2.0 06 08 2015   grade_6                         142.0 135.0                       277.0                         142 135                 277
1159663 1159663 IN     school 1803630 235   Fort Wayne Community Schools 180363000516 107 Blackhawk Middle School   Regular School No 2.0 06 08 2015   grade_7                         151.0 144.0                       295.0                         151 144                 295
1159664 1159664 IN     school 1803630 235   Fort Wayne Community Schools 180363000516 107 Blackhawk Middle School   Regular School No 2.0 06 08 2015   grade_8                         152.0 139.0                       291.0                         152 139                 291
1159666 1159666 IN     school 1803630 235   Fort Wayne Community Schools 180363002175 118 Jeff H Towles Intermediate School   Regular School No 1.0 01 08 2015   grade_1                         37.0 39.0                       76.0                         37 39                 76
1159667 1159667 IN     school 1803630 235   Fort Wayne Community Schools 180363002175 118 Jeff H Towles Intermediate School   Regular School No 1.0 01 08 2015   grade_2                         35.0 36.0                       71.0                         35 36                 71
1159668 1159668 IN     school 1803630 235   Fort Wayne Community Schools 180363002175 118 Jeff H Towles Intermediate School   Regular School No 1.0 01 08 2015   grade_3                         37.0 34.0                       71.0                         37 34                 71
1159669 1159669 IN     school 1803630 235   Fort Wayne Community Schools 180363002175 118 Jeff H Towles Intermediate School   Regular School No 1.0 01 08 2015   grade_4                         38.0 30.0                       68.0                         38 30                 68
1159670 1159670 IN     school 1803630 235   Fort Wayne Community Schools 180363002175 118 Jeff H Towles Intermediate School   Regular School No 1.0 01 08 2015   grade_5                         25.0 34.0                       59.0                         25 34                 59
1159671 1159671 IN     school 1803630 235   Fort Wayne Community Schools 180363002175 118 Jeff H Towles Intermediate School   Regular School No 1.0 01 08 2015   grade_6                         40.0 43.0                       83.0                         40 43                 83
1159672 1159672 IN     school 1803630 235   Fort Wayne Community Schools 180363002175 118 Jeff H Towles Intermediate School   Regular School No 1.0 01 08 2015   grade_7                         32.0 39.0                       71.0                         32 39                 71
1159673 1159673 IN     school 1803630 235   Fort Wayne Community Schools 180363002175 118 Jeff H Towles Intermediate School   Regular School No 1.0 01 08 2015   grade_8                         35.0 41.0                       76.0                         35 41                 76
1159675 1159675 IN     school 1803630 235   Fort Wayne Community Schools 180363000534 119 Jefferson Middle School   Regular School No 2.0 06 08 2015   grade_6                         120.0 112.0                       232.0                         120 112                 232
1159676 1159676 IN     school 1803630 235   Fort Wayne Community Schools 180363000534 119 Jefferson Middle School   Regular School No 2.0 06 08 2015   grade_7                         104.0 101.0                       205.0                         104 101                 205
1159677 1159677 IN     school 1803630 235   Fort Wayne Community Schools 180363000534 119 Jefferson Middle School   Regular School No 2.0 06 08 2015   grade_8                         124.0 108.0                       232.0                         124 108                 232
1159679 1159679 IN     school 1803630 235   Fort Wayne Community Schools 180363000537 121 Kekionga Middle School   Regular School No 2.0 06 08 2015   grade_6                         113.0 80.0                       193.0                         113 80                 193
1159680 1159680 IN     school 1803630 235   Fort Wayne Community Schools 180363000537 121 Kekionga Middle School   Regular School No 2.0 06 08 2015   grade_7                         99.0 77.0                       176.0                         99 77                 176
1159681 1159681 IN     school 1803630 235   Fort Wayne Community Schools 180363000537 121 Kekionga Middle School   Regular School No 2.0 06 08 2015   grade_8                         91.0 79.0                       170.0                         91 79                 170
1159683 1159683 IN     school 1803630 235   Fort Wayne Community Schools 180363000538 125 Lakeside Middle School   Regular School No 2.0 06 08 2015   grade_6                         72.0 61.0                       133.0                         72 61                 133
1159684 1159684 IN     school 1803630 235   Fort Wayne Community Schools 180363000538 125 Lakeside Middle School   Regular School No 2.0 06 08 2015   grade_7                         78.0 80.0                       158.0                         78 80                 158
1159685 1159685 IN     school 1803630 235   Fort Wayne Community Schools 180363000538 125 Lakeside Middle School   Regular School No 2.0 06 08 2015   grade_8                         87.0 83.0                       170.0                         87 83                 170
1159687 1159687 IN     school 1803630 235   Fort Wayne Community Schools 180363000539 126 Lane Middle School   Regular School No 2.0 06 08 2015   grade_6                         94.0 89.0                       183.0                         94 89                 183
1159688 1159688 IN     school 1803630 235   Fort Wayne Community Schools 180363000539 126 Lane Middle School   Regular School No 2.0 06 08 2015   grade_7                         88.0 102.0                       190.0                         88 102                 190
1159689 1159689 IN     school 1803630 235   Fort Wayne Community Schools 180363000539 126 Lane Middle School   Regular School No 2.0 06 08 2015   grade_8                         92.0 98.0                       190.0                         92 98                 190
1159691 1159691 IN     school 1803630 235   Fort Wayne Community Schools 180363000546 127 Memorial Park Middle School   Regular School No 2.0 06 08 2015   grade_6                         99.0 128.0                       227.0                         99 128                 227
1159692 1159692 IN     school 1803630 235   Fort Wayne Community Schools 180363000546 127 Memorial Park Middle School   Regular School No 2.0 06 08 2015   grade_7                         96.0 116.0                       212.0                         96 116                 212
1159693 1159693 IN     school 1803630 235   Fort Wayne Community Schools 180363000546 127 Memorial Park Middle School   Regular School No 2.0 06 08 2015   grade_8                         94.0 97.0                       191.0                         94 97                 191
1159695 1159695 IN     school 1803630 235   Fort Wayne Community Schools 180363000548 128 Miami Middle School   Regular School No 2.0 06 08 2015   grade_6                         102.0 94.0                       196.0                         102 94                 196
1159696 1159696 IN     school 1803630 235   Fort Wayne Community Schools 180363000548 128 Miami Middle School   Regular School No 2.0 06 08 2015   grade_7                         118.0 121.0                       239.0                         118 121                 239
1159697 1159697 IN     school 1803630 235   Fort Wayne Community Schools 180363000548 128 Miami Middle School   Regular School No 2.0 06 08 2015   grade_8                         151.0 117.0                       268.0                         151 117                 268
1159699 1159699 IN     school 1803630 235   Fort Wayne Community Schools 180363000553 129 Northwood Middle School   Regular School No 2.0 06 08 2015   grade_6                         114.0 108.0                       222.0                         114 108                 222
1159700 1159700 IN     school 1803630 235   Fort Wayne Community Schools 180363000553 129 Northwood Middle School   Regular School No 2.0 06 08 2015   grade_7                         119.0 117.0                       236.0                         119 117                 236
1159701 1159701 IN     school 1803630 235   Fort Wayne Community Schools 180363000553 129 Northwood Middle School   Regular School No 2.0 06 08 2015   grade_8                         113.0 126.0                       239.0                         113 126                 239
1159703 1159703 IN     school 1803630 235   Fort Wayne Community Schools 180363000555 133 Portage Middle School   Regular School No 2.0 06 08 2015   grade_6                         86.0 56.0                       142.0                         86 56                 142
1159704 1159704 IN     school 1803630 235   Fort Wayne Community Schools 180363000555 133 Portage Middle School   Regular School No 2.0 06 08 2015   grade_7                         97.0 77.0                       174.0                         97 77                 174

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