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,992
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
1751546 IN     school 1800060 15   Adams Central Community Schools 180006000008 13 Adams Central Middle School   Regular School No Middle 06 08 2019   grade_6                         55.0 51.0                       106.0                         55 51                 106
1751547 IN     school 1800060 15   Adams Central Community Schools 180006000008 13 Adams Central Middle School   Regular School No Middle 06 08 2019   grade_7                         50.0 51.0                       101.0                         50 51                 101
1751548 IN     school 1800060 15   Adams Central Community Schools 180006000008 13 Adams Central Middle School   Regular School No Middle 06 08 2019   grade_8                         52.0 30.0                       82.0                         52 30                 82
1751549 IN     school 1800060 15   Adams Central Community Schools 180006000008 13 Adams Central Middle School   Regular School No Middle 06 08 2019   pk_12_total 270.0 3.0 12.0     2.0         2.0   157.0 132.0     1.0         74.0   21.0   289.0 270 3 12     2         2   157 132     1     74 21   289
1751550 IN     school 1800060 15   Adams Central Community Schools 180006000006 20 Adams Central Elementary School   Regular School No Elementary PK 05 2019   grade_1                         64.0 62.0                       126.0                         64 62                 126
1751551 IN     school 1800060 15   Adams Central Community Schools 180006000006 20 Adams Central Elementary School   Regular School No Elementary PK 05 2019   grade_2                         60.0 39.0                       99.0                         60 39                 99
1751552 IN     school 1800060 15   Adams Central Community Schools 180006000006 20 Adams Central Elementary School   Regular School No Elementary PK 05 2019   grade_3                         50.0 43.0                       93.0                         50 43                 93
1751553 IN     school 1800060 15   Adams Central Community Schools 180006000006 20 Adams Central Elementary School   Regular School No Elementary PK 05 2019   grade_4                         54.0 52.0                       106.0                         54 52                 106
1751554 IN     school 1800060 15   Adams Central Community Schools 180006000006 20 Adams Central Elementary School   Regular School No Elementary PK 05 2019   grade_5                         64.0 41.0                       105.0                         64 41                 105
1751555 IN     school 1800060 15   Adams Central Community Schools 180006000006 20 Adams Central Elementary School   Regular School No Elementary PK 05 2019   kindergarten                         51.0 46.0                       97.0                         51 46                 97
1751556 IN     school 1800060 15   Adams Central Community Schools 180006000006 20 Adams Central Elementary School   Regular School No Elementary PK 05 2019   pk_12_total 574.0 6.0 31.0 1.0   2.0         17.0   347.0 284.0     24.0         171.0   95.0   631.0 574 6 31 1   2         17   347 284     24     171 95   631
1751557 IN     school 1800060 15   Adams Central Community Schools 180006000006 20 Adams Central Elementary School   Regular School No Elementary PK 05 2019   pre_kindergarten                         4.0 1.0                       5.0                         4 1                 5
1751558 IN     school 1800060 15   Adams Central Community Schools 180006000007 21 Adams Central High School   Regular School No High 09 12 2019   adult                         3.0 0.0                       3.0                         3 0                 3
1751559 IN     school 1800060 15   Adams Central Community Schools 180006000007 21 Adams Central High School   Regular School No High 09 12 2019   grade_10                         48.0 55.0                       103.0                         48 55                 103
1751560 IN     school 1800060 15   Adams Central Community Schools 180006000007 21 Adams Central High School   Regular School No High 09 12 2019   grade_11                         40.0 52.0                       92.0                         40 52                 92
1751561 IN     school 1800060 15   Adams Central Community Schools 180006000007 21 Adams Central High School   Regular School No High 09 12 2019   grade_12                         48.0 50.0                       98.0                         48 50                 98
1751562 IN     school 1800060 15   Adams Central Community Schools 180006000007 21 Adams Central High School   Regular School No High 09 12 2019   grade_9                         38.0 40.0                       78.0                         38 40                 78
1751563 IN     school 1800060 15   Adams Central Community Schools 180006000007 21 Adams Central High School   Regular School No High 09 12 2019   pk_12_total 350.0 5.0 5.0 1.0   7.0         6.0   177.0 197.0     6.0         74.0   22.0   374.0 350 5 5 1   7         6   177 197     6     74 22   374
1751564 IN     school 1807680 25   North Adams Community Schools 180768001314 29 Bellmont Senior High School   Regular School No High 09 12 2019   grade_10                         91.0 87.0                       178.0                         91 87                 178
1751565 IN     school 1807680 25   North Adams Community Schools 180768001314 29 Bellmont Senior High School   Regular School No High 09 12 2019   grade_11                         82.0 87.0                       169.0                         82 87                 169
1751566 IN     school 1807680 25   North Adams Community Schools 180768001314 29 Bellmont Senior High School   Regular School No High 09 12 2019   grade_12                         84.0 84.0                       168.0                         84 84                 168
1751567 IN     school 1807680 25   North Adams Community Schools 180768001314 29 Bellmont Senior High School   Regular School No High 09 12 2019   grade_9                         97.0 80.0                       177.0                         97 80                 177
1751568 IN     school 1807680 25   North Adams Community Schools 180768001314 29 Bellmont Senior High School   Regular School No High 09 12 2019   pk_12_total 572.0 13.0 79.0 3.0   5.0         20.0   354.0 338.0     7.0         246.0   64.0   692.0 572 13 79 3   5         20   354 338     7     246 64   692
1751569 IN     school 1807680 25   North Adams Community Schools 180768001313 33 Bellmont Middle School   Regular School No Middle 06 08 2019   grade_6                         57.0 63.0                       120.0                         57 63                 120
1751570 IN     school 1807680 25   North Adams Community Schools 180768001313 33 Bellmont Middle School   Regular School No Middle 06 08 2019   grade_7                         43.0 56.0                       99.0                         43 56                 99
1751571 IN     school 1807680 25   North Adams Community Schools 180768001313 33 Bellmont Middle School   Regular School No Middle 06 08 2019   grade_8                         52.0 64.0                       116.0                         52 64                 116
1751572 IN     school 1807680 25   North Adams Community Schools 180768001313 33 Bellmont Middle School   Regular School No Middle 06 08 2019   pk_12_total 273.0 11.0 34.0 1.0   2.0     1.0   13.0   152.0 183.0     3.0         179.0   52.0   335.0 273 11 34 1   2     1   13   152 183     3     179 52   335
1751573 IN     school 1807680 25   North Adams Community Schools 180768001316 37 Bellmont Elementary   Regular School No Elementary PK 05 2019   grade_1                         51.0 44.0                       95.0                         51 44                 95
1751574 IN     school 1807680 25   North Adams Community Schools 180768001316 37 Bellmont Elementary   Regular School No Elementary PK 05 2019   grade_2                         49.0 55.0                       104.0                         49 55                 104
1751575 IN     school 1807680 25   North Adams Community Schools 180768001316 37 Bellmont Elementary   Regular School No Elementary PK 05 2019   grade_3                         70.0 46.0                       116.0                         70 46                 116
1751576 IN     school 1807680 25   North Adams Community Schools 180768001316 37 Bellmont Elementary   Regular School No Elementary PK 05 2019   grade_4                         62.0 59.0                       121.0                         62 59                 121
1751577 IN     school 1807680 25   North Adams Community Schools 180768001316 37 Bellmont Elementary   Regular School No Elementary PK 05 2019   grade_5                         56.0 67.0                       123.0                         56 67                 123
1751578 IN     school 1807680 25   North Adams Community Schools 180768001316 37 Bellmont Elementary   Regular School No Elementary PK 05 2019   kindergarten                         59.0 63.0                       122.0                         59 63                 122
1751579 IN     school 1807680 25   North Adams Community Schools 180768001316 37 Bellmont Elementary   Regular School No Elementary PK 05 2019   pk_12_total 597.0 31.0 69.0     6.0     2.0   48.0   388.0 365.0     4.0         471.0   138.0   753.0 597 31 69     6     2   48   388 365     4     471 138   753
1751580 IN     school 1807680 25   North Adams Community Schools 180768001316 37 Bellmont Elementary   Regular School No Elementary PK 05 2019   pre_kindergarten                         41.0 31.0                       72.0                         41 31                 72
1751581 IN     school 1810260 35   South Adams Schools 181026001641 17 South Adams Middle School   Regular School No Middle 06 08 2019   grade_6                         47.0 49.0                       96.0                         47 49                 96
1751582 IN     school 1810260 35   South Adams Schools 181026001641 17 South Adams Middle School   Regular School No Middle 06 08 2019   grade_7                         46.0 56.0                       102.0                         46 56                 102
1751583 IN     school 1810260 35   South Adams Schools 181026001641 17 South Adams Middle School   Regular School No Middle 06 08 2019   grade_8                         42.0 38.0                       80.0                         42 38                 80
1751584 IN     school 1810260 35   South Adams Schools 181026001641 17 South Adams Middle School   Regular School No Middle 06 08 2019   pk_12_total 226.0 3.0 39.0     6.0         4.0   135.0 143.0     17.0         117.0   38.0   278.0 226 3 39     6         4   135 143     17     117 38   278
1751585 IN     school 1810260 35   South Adams Schools 181026001642 23 South Adams High School   Regular School No High 09 12 2019   adult                         3.0 0.0                       3.0                         3 0                 3
1751586 IN     school 1810260 35   South Adams Schools 181026001642 23 South Adams High School   Regular School No High 09 12 2019   grade_10                         55.0 39.0                       94.0                         55 39                 94
1751587 IN     school 1810260 35   South Adams Schools 181026001642 23 South Adams High School   Regular School No High 09 12 2019   grade_11                         44.0 43.0                       87.0                         44 43                 87
1751588 IN     school 1810260 35   South Adams Schools 181026001642 23 South Adams High School   Regular School No High 09 12 2019   grade_12                         32.0 34.0                       66.0                         32 34                 66
1751589 IN     school 1810260 35   South Adams Schools 181026001642 23 South Adams High School   Regular School No High 09 12 2019   grade_9                         56.0 49.0                       105.0                         56 49                 105
1751590 IN     school 1810260 35   South Adams Schools 181026001642 23 South Adams High School   Regular School No High 09 12 2019   pk_12_total 302.0 5.0 34.0 1.0   8.0         5.0   190.0 165.0     15.0         136.0   35.0   355.0 302 5 34 1   8         5   190 165     15     136 35   355
1751591 IN     school 1810260 35   South Adams Schools 181026001640 25 South Adams Elementary School   Regular School No Elementary PK 05 2019   grade_1                         45.0 40.0                       85.0                         45 40                 85
1751592 IN     school 1810260 35   South Adams Schools 181026001640 25 South Adams Elementary School   Regular School No Elementary PK 05 2019   grade_2                         57.0 43.0                       100.0                         57 43                 100
1751593 IN     school 1810260 35   South Adams Schools 181026001640 25 South Adams Elementary School   Regular School No Elementary PK 05 2019   grade_3                         46.0 51.0                       97.0                         46 51                 97
1751594 IN     school 1810260 35   South Adams Schools 181026001640 25 South Adams Elementary School   Regular School No Elementary PK 05 2019   grade_4                         39.0 44.0                       83.0                         39 44                 83
1751595 IN     school 1810260 35   South Adams Schools 181026001640 25 South Adams Elementary School   Regular School No Elementary PK 05 2019   grade_5                         42.0 46.0                       88.0                         42 46                 88
1751596 IN     school 1810260 35   South Adams Schools 181026001640 25 South Adams Elementary School   Regular School No Elementary PK 05 2019   kindergarten                         44.0 56.0                       100.0                         44 56                 100
1751597 IN     school 1810260 35   South Adams Schools 181026001640 25 South Adams Elementary School   Regular School No Elementary PK 05 2019   pk_12_total 519.0 3.0 73.0     3.0         16.0   312.0 302.0     75.0         254.0   140.0   614.0 519 3 73     3         16   312 302     75     254 140   614
1751598 IN     school 1810260 35   South Adams Schools 181026001640 25 South Adams Elementary School   Regular School No Elementary PK 05 2019   pre_kindergarten                         39.0 22.0                       61.0                         39 22                 61
1751599 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000001 45 Aboite Elementary School   Regular School No Elementary KG 05 2019   grade_1                         34.0 26.0                       60.0                         34 26                 60
1751600 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000001 45 Aboite Elementary School   Regular School No Elementary KG 05 2019   grade_2                         44.0 40.0                       84.0                         44 40                 84
1751601 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000001 45 Aboite Elementary School   Regular School No Elementary KG 05 2019   grade_3                         53.0 39.0                       92.0                         53 39                 92
1751602 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000001 45 Aboite Elementary School   Regular School No Elementary KG 05 2019   grade_4                         56.0 45.0                       101.0                         56 45                 101
1751603 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000001 45 Aboite Elementary School   Regular School No Elementary KG 05 2019   grade_5                         44.0 49.0                       93.0                         44 49                 93
1751604 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000001 45 Aboite Elementary School   Regular School No Elementary KG 05 2019   kindergarten                         30.0 19.0                       49.0                         30 19                 49
1751605 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000001 45 Aboite Elementary School   Regular School No Elementary KG 05 2019   pk_12_total 402.0 6.0 19.0 1.0   27.0         24.0   261.0 218.0     1.0         72.0   16.0   479.0 402 6 19 1   27         24   261 218     1     72 16   479
1751606 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000083 46 Whispering Meadow Elementary Sch   Regular School No Elementary PK 05 2019   grade_1                         48.0 39.0                       87.0                         48 39                 87
1751607 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000083 46 Whispering Meadow Elementary Sch   Regular School No Elementary PK 05 2019   grade_2                         43.0 45.0                       88.0                         43 45                 88
1751608 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000083 46 Whispering Meadow Elementary Sch   Regular School No Elementary PK 05 2019   grade_3                         43.0 36.0                       79.0                         43 36                 79
1751609 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000083 46 Whispering Meadow Elementary Sch   Regular School No Elementary PK 05 2019   grade_4                         41.0 37.0                       78.0                         41 37                 78
1751610 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000083 46 Whispering Meadow Elementary Sch   Regular School No Elementary PK 05 2019   grade_5                         55.0 35.0                       90.0                         55 35                 90
1751611 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000083 46 Whispering Meadow Elementary Sch   Regular School No Elementary PK 05 2019   kindergarten                         38.0 50.0                       88.0                         38 50                 88
1751612 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000083 46 Whispering Meadow Elementary Sch   Regular School No Elementary PK 05 2019   pk_12_total 370.0 69.0 34.0 3.0   35.0     2.0   33.0   296.0 250.0     29.0         125.0   70.0   546.0 370 69 34 3   35     2   33   296 250     29     125 70   546
1751613 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000083 46 Whispering Meadow Elementary Sch   Regular School No Elementary PK 05 2019   pre_kindergarten                         28.0 8.0                       36.0                         28 8                 36
1751614 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000002 47 Homestead Senior High School   Regular School No High 09 12 2019   grade_10                         299.0 281.0                       580.0                         299 281                 580
1751615 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000002 47 Homestead Senior High School   Regular School No High 09 12 2019   grade_11                         289.0 297.0                       586.0                         289 297                 586
1751616 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000002 47 Homestead Senior High School   Regular School No High 09 12 2019   grade_12                         298.0 282.0                       580.0                         298 282                 580
1751617 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000002 47 Homestead Senior High School   Regular School No High 09 12 2019   grade_9                         340.0 338.0                       678.0                         340 338                 678
1751618 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000002 47 Homestead Senior High School   Regular School No High 09 12 2019   pk_12_total 1958.0 120.0 132.0 7.0   111.0     1.0   95.0   1226.0 1198.0     11.0         350.0   195.0   2424.0 1958 120 132 7   111     1   95   1226 1198     11     350 195   2424
1751619 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000116 63 Summit Middle School   Regular School No Middle 06 08 2019   grade_6                         136.0 113.0                       249.0                         136 113                 249
1751620 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000116 63 Summit Middle School   Regular School No Middle 06 08 2019   grade_7                         110.0 125.0                       235.0                         110 125                 235
1751621 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000116 63 Summit Middle School   Regular School No Middle 06 08 2019   grade_8                         116.0 118.0                       234.0                         116 118                 234
1751622 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000116 63 Summit Middle School   Regular School No Middle 06 08 2019   pk_12_total 609.0 19.0 42.0 2.0   22.0         24.0   362.0 356.0     6.0         131.0   63.0   718.0 609 19 42 2   22         24   362 356     6     131 63   718
1751623 IN     school 1800030 125   M S D Southwest Allen County Schls 180003002044 64 Lafayette Meadow School   Regular School No Elementary KG 05 2019   grade_1                         56.0 49.0                       105.0                         56 49                 105
1751624 IN     school 1800030 125   M S D Southwest Allen County Schls 180003002044 64 Lafayette Meadow School   Regular School No Elementary KG 05 2019   grade_2                         47.0 48.0                       95.0                         47 48                 95
1751625 IN     school 1800030 125   M S D Southwest Allen County Schls 180003002044 64 Lafayette Meadow School   Regular School No Elementary KG 05 2019   grade_3                         63.0 43.0                       106.0                         63 43                 106
1751626 IN     school 1800030 125   M S D Southwest Allen County Schls 180003002044 64 Lafayette Meadow School   Regular School No Elementary KG 05 2019   grade_4                         44.0 46.0                       90.0                         44 46                 90
1751627 IN     school 1800030 125   M S D Southwest Allen County Schls 180003002044 64 Lafayette Meadow School   Regular School No Elementary KG 05 2019   grade_5                         52.0 41.0                       93.0                         52 41                 93
1751628 IN     school 1800030 125   M S D Southwest Allen County Schls 180003002044 64 Lafayette Meadow School   Regular School No Elementary KG 05 2019   kindergarten                         42.0 37.0                       79.0                         42 37                 79
1751629 IN     school 1800030 125   M S D Southwest Allen County Schls 180003002044 64 Lafayette Meadow School   Regular School No Elementary KG 05 2019   pk_12_total 497.0 19.0 21.0     8.0     1.0   22.0   304.0 264.0     0.0         84.0   39.0   568.0 497 19 21     8     1   22   304 264     0     84 39   568
1751630 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000005 67 Woodside Middle School   Regular School No Middle 06 08 2019   grade_6                         168.0 169.0                       337.0                         168 169                 337
1751631 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000005 67 Woodside Middle School   Regular School No Middle 06 08 2019   grade_7                         174.0 182.0                       356.0                         174 182                 356
1751632 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000005 67 Woodside Middle School   Regular School No Middle 06 08 2019   grade_8                         182.0 163.0                       345.0                         182 163                 345
1751633 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000005 67 Woodside Middle School   Regular School No Middle 06 08 2019   pk_12_total 783.0 77.0 59.0 2.0   54.0     2.0   61.0   524.0 514.0     6.0         192.0   79.0   1038.0 783 77 59 2   54     2   61   524 514     6     192 79   1038
1751634 IN     school 1800030 125   M S D Southwest Allen County Schls 180003002186 68 Haverhill Elementary School   Regular School No Elementary KG 05 2019   grade_1                         34.0 38.0                       72.0                         34 38                 72
1751635 IN     school 1800030 125   M S D Southwest Allen County Schls 180003002186 68 Haverhill Elementary School   Regular School No Elementary KG 05 2019   grade_2                         38.0 30.0                       68.0                         38 30                 68
1751636 IN     school 1800030 125   M S D Southwest Allen County Schls 180003002186 68 Haverhill Elementary School   Regular School No Elementary KG 05 2019   grade_3                         33.0 37.0                       70.0                         33 37                 70
1751637 IN     school 1800030 125   M S D Southwest Allen County Schls 180003002186 68 Haverhill Elementary School   Regular School No Elementary KG 05 2019   grade_4                         45.0 23.0                       68.0                         45 23                 68
1751638 IN     school 1800030 125   M S D Southwest Allen County Schls 180003002186 68 Haverhill Elementary School   Regular School No Elementary KG 05 2019   grade_5                         31.0 35.0                       66.0                         31 35                 66
1751639 IN     school 1800030 125   M S D Southwest Allen County Schls 180003002186 68 Haverhill Elementary School   Regular School No Elementary KG 05 2019   kindergarten                         34.0 40.0                       74.0                         34 40                 74
1751640 IN     school 1800030 125   M S D Southwest Allen County Schls 180003002186 68 Haverhill Elementary School   Regular School No Elementary KG 05 2019   pk_12_total 347.0 16.0 22.0 1.0   11.0         21.0   215.0 203.0     7.0         81.0   49.0   418.0 347 16 22 1   11         21   215 203     7     81 49   418
1751641 IN     school 1800030 125   M S D Southwest Allen County Schls 180003002329 71 Deer Ridge Elementary   Regular School No Elementary KG 05 2019   grade_1                         38.0 27.0                       65.0                         38 27                 65
1751642 IN     school 1800030 125   M S D Southwest Allen County Schls 180003002329 71 Deer Ridge Elementary   Regular School No Elementary KG 05 2019   grade_2                         41.0 33.0                       74.0                         41 33                 74
1751643 IN     school 1800030 125   M S D Southwest Allen County Schls 180003002329 71 Deer Ridge Elementary   Regular School No Elementary KG 05 2019   grade_3                         28.0 33.0                       61.0                         28 33                 61
1751644 IN     school 1800030 125   M S D Southwest Allen County Schls 180003002329 71 Deer Ridge Elementary   Regular School No Elementary KG 05 2019   grade_4                         38.0 44.0                       82.0                         38 44                 82
1751645 IN     school 1800030 125   M S D Southwest Allen County Schls 180003002329 71 Deer Ridge Elementary   Regular School No Elementary KG 05 2019   grade_5                         30.0 39.0                       69.0                         30 39                 69

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