Data source: Big Local News · About: Big Local

12,058 rows where state = "IN" and year = 2017 sorted by school_nces_id descending

View and edit SQL

grade

year

  • 2017 · 12,058
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
1293484 IN     school   255   East Allen County Schools   318 Park Hill Learning Center             2017   pk_12_total 47.0 7.0 6.0     1.0         1.0   37.0 25.0     0.0             47.0   62.0 47 7 6     1         1   37 25     0       47   62
1293485 IN     school   255   East Allen County Schools   318 Park Hill Learning Center             2017   pre_kindergarten                         37.0 25.0                       62.0                         37 25                 62
1299669 IN     school   5375   M S D Wayne Township   5271 Sanders School             2017   grade_1                         3.0 0.0                       3.0                         3 0                 3
1299670 IN     school   5375   M S D Wayne Township   5271 Sanders School             2017   grade_10                         8.0 0.0                       8.0                         8 0                 8
1299671 IN     school   5375   M S D Wayne Township   5271 Sanders School             2017   grade_11                         5.0 0.0                       5.0                         5 0                 5
1299672 IN     school   5375   M S D Wayne Township   5271 Sanders School             2017   grade_12                         6.0 1.0                       7.0                         6 1                 7
1299673 IN     school   5375   M S D Wayne Township   5271 Sanders School             2017   grade_2                         6.0 0.0                       6.0                         6 0                 6
1299674 IN     school   5375   M S D Wayne Township   5271 Sanders School             2017   grade_3                         6.0 1.0                       7.0                         6 1                 7
1299675 IN     school   5375   M S D Wayne Township   5271 Sanders School             2017   grade_4                         5.0 1.0                       6.0                         5 1                 6
1299676 IN     school   5375   M S D Wayne Township   5271 Sanders School             2017   grade_5                         7.0 1.0                       8.0                         7 1                 8
1299677 IN     school   5375   M S D Wayne Township   5271 Sanders School             2017   grade_6                         4.0 1.0                       5.0                         4 1                 5
1299678 IN     school   5375   M S D Wayne Township   5271 Sanders School             2017   grade_7                         10.0 2.0                       12.0                         10 2                 12
1299679 IN     school   5375   M S D Wayne Township   5271 Sanders School             2017   grade_8                         6.0 1.0                       7.0                         6 1                 7
1299680 IN     school   5375   M S D Wayne Township   5271 Sanders School             2017   grade_9                         19.0 1.0                       20.0                         19 1                 20
1299681 IN     school   5375   M S D Wayne Township   5271 Sanders School             2017   kindergarten                         1.0 2.0                       3.0                         1 2                 3
1299682 IN     school   5375   M S D Wayne Township   5271 Sanders School             2017   pk_12_total 48.0 35.0 6.0               8.0   86.0 11.0     5.0             89.0   97.0 48 35 6               8   86 11     5       89   97
1302344 IN     school   7205   South Bend Community School Corp   7605 South Bend SNAP             2017   pk_12_total 95.0 28.0 26.0               8.0   102.0 55.0     0.0             113.0   157.0 95 28 26               8   102 55     0       113   157
1302345 IN     school   7205   South Bend Community School Corp   7605 South Bend SNAP             2017   pre_kindergarten                         102.0 55.0                       157.0                         102 55                 157
1297722 IN     school 1813230 4455   Whitko Community School Corp 181323002089 9191 Whitko High School   Regular School No High 09 12 2017   grade_10                         78.0 58.0                       136.0                         78 58                 136
1297723 IN     school 1813230 4455   Whitko Community School Corp 181323002089 9191 Whitko High School   Regular School No High 09 12 2017   grade_11                         67.0 47.0                       114.0                         67 47                 114
1297724 IN     school 1813230 4455   Whitko Community School Corp 181323002089 9191 Whitko High School   Regular School No High 09 12 2017   grade_12                         65.0 61.0                       126.0                         65 61                 126
1297725 IN     school 1813230 4455   Whitko Community School Corp 181323002089 9191 Whitko High School   Regular School No High 09 12 2017   grade_9                         57.0 53.0                       110.0                         57 53                 110
1297726 IN     school 1813230 4455   Whitko Community School Corp 181323002089 9191 Whitko High School   Regular School No High 09 12 2017   pk_12_total 445.0 8.0 24.0 1.0   3.0         5.0   267.0 219.0     6.0             103.0   486.0 445 8 24 1   3         5   267 219     6       103   486
1297714 IN     school 1813230 4455   Whitko Community School Corp 181323002087 9173 South Whitley Elementary School   Regular School No Elementary PK 05 2017   grade_1                         20.0 18.0                       38.0                         20 18                 38
1297715 IN     school 1813230 4455   Whitko Community School Corp 181323002087 9173 South Whitley Elementary School   Regular School No Elementary PK 05 2017   grade_2                         19.0 21.0                       40.0                         19 21                 40
1297716 IN     school 1813230 4455   Whitko Community School Corp 181323002087 9173 South Whitley Elementary School   Regular School No Elementary PK 05 2017   grade_3                         27.0 35.0                       62.0                         27 35                 62
1297717 IN     school 1813230 4455   Whitko Community School Corp 181323002087 9173 South Whitley Elementary School   Regular School No Elementary PK 05 2017   grade_4                         21.0 30.0                       51.0                         21 30                 51
1297718 IN     school 1813230 4455   Whitko Community School Corp 181323002087 9173 South Whitley Elementary School   Regular School No Elementary PK 05 2017   grade_5                         27.0 22.0                       49.0                         27 22                 49
1297719 IN     school 1813230 4455   Whitko Community School Corp 181323002087 9173 South Whitley Elementary School   Regular School No Elementary PK 05 2017   kindergarten                         15.0 26.0                       41.0                         15 26                 41
1297720 IN     school 1813230 4455   Whitko Community School Corp 181323002087 9173 South Whitley Elementary School   Regular School No Elementary PK 05 2017   pk_12_total 272.0 4.0 3.0     2.0         3.0   131.0 153.0     6.0             46.0   284.0 272 4 3     2         3   131 153     6       46   284
1297721 IN     school 1813230 4455   Whitko Community School Corp 181323002087 9173 South Whitley Elementary School   Regular School No Elementary PK 05 2017   pre_kindergarten                         2.0 1.0                       3.0                         2 1                 3
1297702 IN     school 1813230 4455   Whitko Community School Corp 181323002084 3642 Pierceton Elementary School   Regular School No Elementary PK 05 2017   grade_1                         33.0 21.0                       54.0                         33 21                 54
1297703 IN     school 1813230 4455   Whitko Community School Corp 181323002084 3642 Pierceton Elementary School   Regular School No Elementary PK 05 2017   grade_2                         15.0 31.0                       46.0                         15 31                 46
1297704 IN     school 1813230 4455   Whitko Community School Corp 181323002084 3642 Pierceton Elementary School   Regular School No Elementary PK 05 2017   grade_3                         30.0 20.0                       50.0                         30 20                 50
1297705 IN     school 1813230 4455   Whitko Community School Corp 181323002084 3642 Pierceton Elementary School   Regular School No Elementary PK 05 2017   grade_4                         32.0 33.0                       65.0                         32 33                 65
1297706 IN     school 1813230 4455   Whitko Community School Corp 181323002084 3642 Pierceton Elementary School   Regular School No Elementary PK 05 2017   grade_5                         33.0 25.0                       58.0                         33 25                 58
1297707 IN     school 1813230 4455   Whitko Community School Corp 181323002084 3642 Pierceton Elementary School   Regular School No Elementary PK 05 2017   kindergarten                         21.0 25.0                       46.0                         21 25                 46
1297708 IN     school 1813230 4455   Whitko Community School Corp 181323002084 3642 Pierceton Elementary School   Regular School No Elementary PK 05 2017   pk_12_total 307.0 3.0 16.0     3.0         5.0   174.0 160.0     4.0             75.0   334.0 307 3 16     3         5   174 160     4       75   334
1297709 IN     school 1813230 4455   Whitko Community School Corp 181323002084 3642 Pierceton Elementary School   Regular School No Elementary PK 05 2017   pre_kindergarten                         10.0 5.0                       15.0                         10 5                 15
1297710 IN     school 1813230 4455   Whitko Community School Corp 181323000068 3644 Whitko Middle School   Regular School No Middle 06 08 2017   grade_6                         52.0 58.0                       110.0                         52 58                 110
1297711 IN     school 1813230 4455   Whitko Community School Corp 181323000068 3644 Whitko Middle School   Regular School No Middle 06 08 2017   grade_7                         79.0 56.0                       135.0                         79 56                 135
1297712 IN     school 1813230 4455   Whitko Community School Corp 181323000068 3644 Whitko Middle School   Regular School No Middle 06 08 2017   grade_8                         65.0 41.0                       106.0                         65 41                 106
1297713 IN     school 1813230 4455   Whitko Community School Corp 181323000068 3644 Whitko Middle School   Regular School No Middle 06 08 2017   pk_12_total 326.0 3.0 14.0     3.0         5.0   196.0 155.0     2.0             64.0   351.0 326 3 14     3         5   196 155     2       64   351
1298536 IN     school 1813200 4760   School City of Whiting 181320002082 4353 Whiting High School   Regular School No High 09 12 2017   grade_10                         72.0 49.0                       121.0                         72 49                 121
1298537 IN     school 1813200 4760   School City of Whiting 181320002082 4353 Whiting High School   Regular School No High 09 12 2017   grade_11                         49.0 46.0                       95.0                         49 46                 95
1298538 IN     school 1813200 4760   School City of Whiting 181320002082 4353 Whiting High School   Regular School No High 09 12 2017   grade_12                         57.0 39.0                       96.0                         57 39                 96
1298539 IN     school 1813200 4760   School City of Whiting 181320002082 4353 Whiting High School   Regular School No High 09 12 2017   grade_9                         61.0 61.0                       122.0                         61 61                 122
1298540 IN     school 1813200 4760   School City of Whiting 181320002082 4353 Whiting High School   Regular School No High 09 12 2017   pk_12_total 137.0 7.0 276.0               14.0   239.0 195.0     19.0             39.0   434.0 137 7 276               14   239 195     19       39   434
1298545 IN     school 1813200 4760   School City of Whiting 181320002081 4361 Nathan Hale Elementary School   Regular School No Elementary PK 05 2017   grade_1                         42.0 34.0                       76.0                         42 34                 76
1298546 IN     school 1813200 4760   School City of Whiting 181320002081 4361 Nathan Hale Elementary School   Regular School No Elementary PK 05 2017   grade_2                         24.0 45.0                       69.0                         24 45                 69
1298547 IN     school 1813200 4760   School City of Whiting 181320002081 4361 Nathan Hale Elementary School   Regular School No Elementary PK 05 2017   grade_3                         27.0 48.0                       75.0                         27 48                 75
1298548 IN     school 1813200 4760   School City of Whiting 181320002081 4361 Nathan Hale Elementary School   Regular School No Elementary PK 05 2017   grade_4                         27.0 48.0                       75.0                         27 48                 75
1298549 IN     school 1813200 4760   School City of Whiting 181320002081 4361 Nathan Hale Elementary School   Regular School No Elementary PK 05 2017   grade_5                         46.0 37.0                       83.0                         46 37                 83
1298550 IN     school 1813200 4760   School City of Whiting 181320002081 4361 Nathan Hale Elementary School   Regular School No Elementary PK 05 2017   kindergarten                         36.0 23.0                       59.0                         36 23                 59
1298551 IN     school 1813200 4760   School City of Whiting 181320002081 4361 Nathan Hale Elementary School   Regular School No Elementary PK 05 2017   pk_12_total 104.0 23.0 357.0     1.0         8.0   237.0 256.0     62.0             86.0   493.0 104 23 357     1         8   237 256     62       86   493
1298552 IN     school 1813200 4760   School City of Whiting 181320002081 4361 Nathan Hale Elementary School   Regular School No Elementary PK 05 2017   pre_kindergarten                         35.0 21.0                       56.0                         35 21                 56
1298541 IN     school 1813200 4760   School City of Whiting 181320000398 4356 Whiting Middle School   Regular School No Middle 06 08 2017   grade_6                         36.0 53.0                       89.0                         36 53                 89
1298542 IN     school 1813200 4760   School City of Whiting 181320000398 4356 Whiting Middle School   Regular School No Middle 06 08 2017   grade_7                         51.0 39.0                       90.0                         51 39                 90
1298543 IN     school 1813200 4760   School City of Whiting 181320000398 4356 Whiting Middle School   Regular School No Middle 06 08 2017   grade_8                         48.0 39.0                       87.0                         48 39                 87
1298544 IN     school 1813200 4760   School City of Whiting 181320000398 4356 Whiting Middle School   Regular School No Middle 06 08 2017   pk_12_total 67.0 9.0 173.0     2.0         15.0   135.0 131.0     13.0             32.0   266.0 67 9 173     2         15   135 131     13       32   266
1297758 IN     school 1813110 4525   Westview School Corporation 181311002365 3702 Westview Elementary School   Regular School No Middle 05 06 2017   grade_5                         103.0 98.0                       201.0                         103 98                 201
1297759 IN     school 1813110 4525   Westview School Corporation 181311002365 3702 Westview Elementary School   Regular School No Middle 05 06 2017   grade_6                         106.0 90.0                       196.0                         106 90                 196
1297760 IN     school 1813110 4525   Westview School Corporation 181311002365 3702 Westview Elementary School   Regular School No Middle 05 06 2017   pk_12_total 382.0 2.0 6.0     3.0         4.0   209.0 188.0     19.0             67.0   397.0 382 2 6     3         4   209 188     19       67   397
1297743 IN     school 1813110 4525   Westview School Corporation 181311002079 3697 Westview Jr-Sr High School   Regular School No Other 06 12 2017   adult                         3.0 1.0                       4.0                         3 1                 4
1297744 IN     school 1813110 4525   Westview School Corporation 181311002079 3697 Westview Jr-Sr High School   Regular School No Other 06 12 2017   grade_10                         66.0 50.0                       116.0                         66 50                 116
1297745 IN     school 1813110 4525   Westview School Corporation 181311002079 3697 Westview Jr-Sr High School   Regular School No Other 06 12 2017   grade_11                         53.0 59.0                       112.0                         53 59                 112
1297746 IN     school 1813110 4525   Westview School Corporation 181311002079 3697 Westview Jr-Sr High School   Regular School No Other 06 12 2017   grade_12                         44.0 44.0                       88.0                         44 44                 88
1297747 IN     school 1813110 4525   Westview School Corporation 181311002079 3697 Westview Jr-Sr High School   Regular School No Other 06 12 2017   grade_6                         2.0 0.0                       2.0                         2 0                 2
1297748 IN     school 1813110 4525   Westview School Corporation 181311002079 3697 Westview Jr-Sr High School   Regular School No Other 06 12 2017   grade_7                         104.0 89.0                       193.0                         104 89                 193
1297749 IN     school 1813110 4525   Westview School Corporation 181311002079 3697 Westview Jr-Sr High School   Regular School No Other 06 12 2017   grade_8                         81.0 99.0                       180.0                         81 99                 180
1297750 IN     school 1813110 4525   Westview School Corporation 181311002079 3697 Westview Jr-Sr High School   Regular School No Other 06 12 2017   grade_9                         55.0 45.0                       100.0                         55 45                 100
1297751 IN     school 1813110 4525   Westview School Corporation 181311002079 3697 Westview Jr-Sr High School   Regular School No Other 06 12 2017   pk_12_total 739.0 9.0 28.0 2.0   5.0         12.0   408.0 387.0     50.0             123.0   795.0 739 9 28 2   5         12   408 387     50       123   795
1297752 IN     school 1813110 4525   Westview School Corporation 181311002078 3698 Topeka Elementary School   Regular School No Elementary KG 04 2017   grade_1                         33.0 29.0                       62.0                         33 29                 62
1297753 IN     school 1813110 4525   Westview School Corporation 181311002078 3698 Topeka Elementary School   Regular School No Elementary KG 04 2017   grade_2                         26.0 35.0                       61.0                         26 35                 61
1297754 IN     school 1813110 4525   Westview School Corporation 181311002078 3698 Topeka Elementary School   Regular School No Elementary KG 04 2017   grade_3                         29.0 29.0                       58.0                         29 29                 58
1297755 IN     school 1813110 4525   Westview School Corporation 181311002078 3698 Topeka Elementary School   Regular School No Elementary KG 04 2017   grade_4                         25.0 27.0                       52.0                         25 27                 52
1297756 IN     school 1813110 4525   Westview School Corporation 181311002078 3698 Topeka Elementary School   Regular School No Elementary KG 04 2017   kindergarten                         46.0 43.0                       89.0                         46 43                 89
1297757 IN     school 1813110 4525   Westview School Corporation 181311002078 3698 Topeka Elementary School   Regular School No Elementary KG 04 2017   pk_12_total 312.0   5.0     3.0         2.0   159.0 163.0     132.0             37.0   322.0 312   5     3         2   159 163     132       37   322
1297769 IN     school 1813110 4525   Westview School Corporation 181311002077 3714 Shipshewana-Scott Elementary Sch   Regular School No Elementary KG 04 2017   grade_1                         32.0 34.0                       66.0                         32 34                 66
1297770 IN     school 1813110 4525   Westview School Corporation 181311002077 3714 Shipshewana-Scott Elementary Sch   Regular School No Elementary KG 04 2017   grade_2                         28.0 37.0                       65.0                         28 37                 65
1297771 IN     school 1813110 4525   Westview School Corporation 181311002077 3714 Shipshewana-Scott Elementary Sch   Regular School No Elementary KG 04 2017   grade_3                         32.0 31.0                       63.0                         32 31                 63
1297772 IN     school 1813110 4525   Westview School Corporation 181311002077 3714 Shipshewana-Scott Elementary Sch   Regular School No Elementary KG 04 2017   grade_4                         41.0 32.0                       73.0                         41 32                 73
1297773 IN     school 1813110 4525   Westview School Corporation 181311002077 3714 Shipshewana-Scott Elementary Sch   Regular School No Elementary KG 04 2017   kindergarten                         34.0 36.0                       70.0                         34 36                 70
1297774 IN     school 1813110 4525   Westview School Corporation 181311002077 3714 Shipshewana-Scott Elementary Sch   Regular School No Elementary KG 04 2017   pk_12_total 320.0 2.0 9.0     1.0         5.0   167.0 170.0     109.0             37.0   337.0 320 2 9     1         5   167 170     109       37   337
1297761 IN     school 1813110 4525   Westview School Corporation 181311001587 3704 Meadowview Elementary School   Regular School No Elementary PK 05 2017   grade_1                         42.0 22.0                       64.0                         42 22                 64
1297762 IN     school 1813110 4525   Westview School Corporation 181311001587 3704 Meadowview Elementary School   Regular School No Elementary PK 05 2017   grade_2                         57.0 45.0                       102.0                         57 45                 102
1297763 IN     school 1813110 4525   Westview School Corporation 181311001587 3704 Meadowview Elementary School   Regular School No Elementary PK 05 2017   grade_3                         34.0 35.0                       69.0                         34 35                 69
1297764 IN     school 1813110 4525   Westview School Corporation 181311001587 3704 Meadowview Elementary School   Regular School No Elementary PK 05 2017   grade_4                         37.0 29.0                       66.0                         37 29                 66
1297765 IN     school 1813110 4525   Westview School Corporation 181311001587 3704 Meadowview Elementary School   Regular School No Elementary PK 05 2017   grade_5                         2.0 0.0                       2.0                         2 0                 2
1297766 IN     school 1813110 4525   Westview School Corporation 181311001587 3704 Meadowview Elementary School   Regular School No Elementary PK 05 2017   kindergarten                         52.0 42.0                       94.0                         52 42                 94
1297767 IN     school 1813110 4525   Westview School Corporation 181311001587 3704 Meadowview Elementary School   Regular School No Elementary PK 05 2017   pk_12_total 394.0 4.0 3.0     1.0     2.0   4.0   233.0 175.0     179.0             79.0   408.0 394 4 3     1     2   4   233 175     179       79   408
1297768 IN     school 1813110 4525   Westview School Corporation 181311001587 3704 Meadowview Elementary School   Regular School No Elementary PK 05 2017   pre_kindergarten                         9.0 2.0                       11.0                         9 2                 11
1295990 IN     school 1813080 3030   Westfield-Washington Schools 181308002449 2498 Monon Trail Elementary School   Regular School No Elementary KG 04 2017   grade_1                         69.0 35.0                       104.0                         69 35                 104
1295991 IN     school 1813080 3030   Westfield-Washington Schools 181308002449 2498 Monon Trail Elementary School   Regular School No Elementary KG 04 2017   grade_2                         48.0 43.0                       91.0                         48 43                 91
1295992 IN     school 1813080 3030   Westfield-Washington Schools 181308002449 2498 Monon Trail Elementary School   Regular School No Elementary KG 04 2017   grade_3                         49.0 36.0                       85.0                         49 36                 85
1295993 IN     school 1813080 3030   Westfield-Washington Schools 181308002449 2498 Monon Trail Elementary School   Regular School No Elementary KG 04 2017   grade_4                         36.0 27.0                       63.0                         36 27                 63
1295994 IN     school 1813080 3030   Westfield-Washington Schools 181308002449 2498 Monon Trail Elementary School   Regular School No Elementary KG 04 2017   kindergarten                         45.0 38.0                       83.0                         45 38                 83
1295995 IN     school 1813080 3030   Westfield-Washington Schools 181308002449 2498 Monon Trail Elementary School   Regular School No Elementary KG 04 2017   pk_12_total 289.0 38.0 61.0 1.0   10.0         27.0   247.0 179.0     34.0             93.0   426.0 289 38 61 1   10         27   247 179     34       93   426
1295999 IN     school 1813080 3030   Westfield-Washington Schools 181308002184 2504 Maple Glen Elementary   Regular School No Elementary PK 04 2017   grade_1                         71.0 41.0                       112.0                         71 41                 112
1296000 IN     school 1813080 3030   Westfield-Washington Schools 181308002184 2504 Maple Glen Elementary   Regular School No Elementary PK 04 2017   grade_2                         61.0 55.0                       116.0                         61 55                 116

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