Data source: Big Local News · About: Big Local

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

View and edit SQL

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
1159462 IN     school 1800060 15   Adams Central Community Schools 180006000008 13 Adams Central Middle School   Regular School No 2.0 06 08 2015   grade_6                         45.0 55.0                       100.0                         45 55                 100
1159463 IN     school 1800060 15   Adams Central Community Schools 180006000008 13 Adams Central Middle School   Regular School No 2.0 06 08 2015   grade_7                         42.0 48.0                       90.0                         42 48                 90
1159464 IN     school 1800060 15   Adams Central Community Schools 180006000008 13 Adams Central Middle School   Regular School No 2.0 06 08 2015   grade_8                         46.0 48.0                       94.0                         46 48                 94
1159465 IN     school 1800060 15   Adams Central Community Schools 180006000008 13 Adams Central Middle School   Regular School No 2.0 06 08 2015   pk_12_total 274.0 1.0 5.0     2.0         2.0   133.0 151.0     4.0             19.0   284.0 274 1 5     2         2   133 151     4       19   284
1159466 IN     school 1800060 15   Adams Central Community Schools 180006000006 20 Adams Central Elementary Sch   Regular School No 1.0 KG 05 2015   grade_1                         63.0 40.0                       103.0                         63 40                 103
1159467 IN     school 1800060 15   Adams Central Community Schools 180006000006 20 Adams Central Elementary Sch   Regular School No 1.0 KG 05 2015   grade_2                         50.0 50.0                       100.0                         50 50                 100
1159468 IN     school 1800060 15   Adams Central Community Schools 180006000006 20 Adams Central Elementary Sch   Regular School No 1.0 KG 05 2015   grade_3                         50.0 53.0                       103.0                         50 53                 103
1159469 IN     school 1800060 15   Adams Central Community Schools 180006000006 20 Adams Central Elementary Sch   Regular School No 1.0 KG 05 2015   grade_4                         52.0 35.0                       87.0                         52 35                 87
1159470 IN     school 1800060 15   Adams Central Community Schools 180006000006 20 Adams Central Elementary Sch   Regular School No 1.0 KG 05 2015   grade_5                         38.0 40.0                       78.0                         38 40                 78
1159471 IN     school 1800060 15   Adams Central Community Schools 180006000006 20 Adams Central Elementary Sch   Regular School No 1.0 KG 05 2015   kindergarten                         54.0 54.0                       108.0                         54 54                 108
1159472 IN     school 1800060 15   Adams Central Community Schools 180006000006 20 Adams Central Elementary Sch   Regular School No 1.0 KG 05 2015   pk_12_total 551.0 7.0 13.0     4.0         4.0   307.0 272.0     30.0             81.0   579.0 551 7 13     4         4   307 272     30       81   579
1159473 IN     school 1800060 15   Adams Central Community Schools 180006000007 21 Adams Central High School   Regular School No 3.0 09 12 2015   adult                         1.0 1.0                       2.0                         1 1                 2
1159474 IN     school 1800060 15   Adams Central Community Schools 180006000007 21 Adams Central High School   Regular School No 3.0 09 12 2015   grade_10                         45.0 51.0                       96.0                         45 51                 96
1159475 IN     school 1800060 15   Adams Central Community Schools 180006000007 21 Adams Central High School   Regular School No 3.0 09 12 2015   grade_11                         52.0 39.0                       91.0                         52 39                 91
1159476 IN     school 1800060 15   Adams Central Community Schools 180006000007 21 Adams Central High School   Regular School No 3.0 09 12 2015   grade_12                         43.0 50.0                       93.0                         43 50                 93
1159477 IN     school 1800060 15   Adams Central Community Schools 180006000007 21 Adams Central High School   Regular School No 3.0 09 12 2015   grade_9                         49.0 34.0                       83.0                         49 34                 83
1159478 IN     school 1800060 15   Adams Central Community Schools 180006000007 21 Adams Central High School   Regular School No 3.0 09 12 2015   pk_12_total 347.0   13.0 2.0   2.0     1.0       190.0 175.0     7.0             37.0   365.0 347   13 2   2     1       190 175     7       37   365
1159479 IN     school 1807680 25   North Adams Community Schools 180768001314 29 Bellmont Senior High School   Regular School No 3.0 09 12 2015   grade_10                         96.0 93.0                       189.0                         96 93                 189
1159480 IN     school 1807680 25   North Adams Community Schools 180768001314 29 Bellmont Senior High School   Regular School No 3.0 09 12 2015   grade_11                         101.0 89.0                       190.0                         101 89                 190
1159481 IN     school 1807680 25   North Adams Community Schools 180768001314 29 Bellmont Senior High School   Regular School No 3.0 09 12 2015   grade_12                         85.0 83.0                       168.0                         85 83                 168
1159482 IN     school 1807680 25   North Adams Community Schools 180768001314 29 Bellmont Senior High School   Regular School No 3.0 09 12 2015   grade_9                         73.0 84.0                       157.0                         73 84                 157
1159483 IN     school 1807680 25   North Adams Community Schools 180768001314 29 Bellmont Senior High School   Regular School No 3.0 09 12 2015   pk_12_total 594.0 6.0 86.0 7.0   3.0         8.0   355.0 349.0     6.0             80.0   704.0 594 6 86 7   3         8   355 349     6       80   704
1159484 IN     school 1807680 25   North Adams Community Schools 180768001313 33 Bellmont Middle School   Regular School No 2.0 05 08 2015   grade_5                         67.0 54.0                       121.0                         67 54                 121
1159485 IN     school 1807680 25   North Adams Community Schools 180768001313 33 Bellmont Middle School   Regular School No 2.0 05 08 2015   grade_6                         53.0 68.0                       121.0                         53 68                 121
1159486 IN     school 1807680 25   North Adams Community Schools 180768001313 33 Bellmont Middle School   Regular School No 2.0 05 08 2015   grade_7                         49.0 66.0                       115.0                         49 66                 115
1159487 IN     school 1807680 25   North Adams Community Schools 180768001313 33 Bellmont Middle School   Regular School No 2.0 05 08 2015   grade_8                         57.0 65.0                       122.0                         57 65                 122
1159488 IN     school 1807680 25   North Adams Community Schools 180768001313 33 Bellmont Middle School   Regular School No 2.0 05 08 2015   pk_12_total 390.0 4.0 66.0 2.0   5.0         12.0   226.0 253.0     6.0             64.0   479.0 390 4 66 2   5         12   226 253     6       64   479
1159489 IN     school 1807680 25   North Adams Community Schools 180768001316 37 Northwest Elementary   Regular School No 1.0 02 04 2015   grade_2                         54.0 59.0                       113.0                         54 59                 113
1159490 IN     school 1807680 25   North Adams Community Schools 180768001316 37 Northwest Elementary   Regular School No 1.0 02 04 2015   grade_3                         54.0 48.0                       102.0                         54 48                 102
1159491 IN     school 1807680 25   North Adams Community Schools 180768001316 37 Northwest Elementary   Regular School No 1.0 02 04 2015   grade_4                         42.0 62.0                       104.0                         42 62                 104
1159492 IN     school 1807680 25   North Adams Community Schools 180768001316 37 Northwest Elementary   Regular School No 1.0 02 04 2015   pk_12_total 262.0 4.0 39.0 1.0         1.0   12.0   150.0 169.0     4.0             74.0   319.0 262 4 39 1         1   12   150 169     4       74   319
1159493 IN     school 1807680 25   North Adams Community Schools 180768001317 41 Southeast Elementary School   Regular School No 1.0 PK 01 2015   grade_1                         59.0 62.0                       121.0                         59 62                 121
1159494 IN     school 1807680 25   North Adams Community Schools 180768001317 41 Southeast Elementary School   Regular School No 1.0 PK 01 2015   kindergarten                         65.0 55.0                       120.0                         65 55                 120
1159495 IN     school 1807680 25   North Adams Community Schools 180768001317 41 Southeast Elementary School   Regular School No 1.0 PK 01 2015   pk_12_total 240.0 6.0 34.0     2.0     2.0   7.0   154.0 137.0     0.0             40.0   291.0 240 6 34     2     2   7   154 137     0       40   291
1159496 IN     school 1807680 25   North Adams Community Schools 180768001317 41 Southeast Elementary School   Regular School No 1.0 PK 01 2015   pre_kindergarten                         30.0 20.0                       50.0                         30 20                 50
1159497 IN     school 1810260 35   South Adams Schools 181026001641 17 South Adams Middle School   Regular School No 2.0 06 08 2015   grade_6                         63.0 56.0                       119.0                         63 56                 119
1159498 IN     school 1810260 35   South Adams Schools 181026001641 17 South Adams Middle School   Regular School No 2.0 06 08 2015   grade_7                         49.0 47.0                       96.0                         49 47                 96
1159499 IN     school 1810260 35   South Adams Schools 181026001641 17 South Adams Middle School   Regular School No 2.0 06 08 2015   grade_8                         45.0 54.0                       99.0                         45 54                 99
1159500 IN     school 1810260 35   South Adams Schools 181026001641 17 South Adams Middle School   Regular School No 2.0 06 08 2015   pk_12_total 262.0 4.0 40.0 2.0   4.0         2.0   157.0 157.0     18.0             30.0   314.0 262 4 40 2   4         2   157 157     18       30   314
1159501 IN     school 1810260 35   South Adams Schools 181026001642 23 South Adams High School   Regular School No 3.0 09 12 2015   adult                         1.0 0.0                       1.0                         1 0                 1
1159502 IN     school 1810260 35   South Adams Schools 181026001642 23 South Adams High School   Regular School No 3.0 09 12 2015   grade_10                         58.0 54.0                       112.0                         58 54                 112
1159503 IN     school 1810260 35   South Adams Schools 181026001642 23 South Adams High School   Regular School No 3.0 09 12 2015   grade_11                         35.0 50.0                       85.0                         35 50                 85
1159504 IN     school 1810260 35   South Adams Schools 181026001642 23 South Adams High School   Regular School No 3.0 09 12 2015   grade_12                         40.0 40.0                       80.0                         40 40                 80
1159505 IN     school 1810260 35   South Adams Schools 181026001642 23 South Adams High School   Regular School No 3.0 09 12 2015   grade_9                         53.0 60.0                       113.0                         53 60                 113
1159506 IN     school 1810260 35   South Adams Schools 181026001642 23 South Adams High School   Regular School No 3.0 09 12 2015   pk_12_total 331.0 5.0 44.0 2.0   4.0         5.0   187.0 204.0     19.0             40.0   391.0 331 5 44 2   4         5   187 204     19       40   391
1159507 IN     school 1810260 35   South Adams Schools 181026001640 25 South Adams Elem School   Regular School No 1.0 PK 05 2015   grade_1                         39.0 54.0                       93.0                         39 54                 93
1159508 IN     school 1810260 35   South Adams Schools 181026001640 25 South Adams Elem School   Regular School No 1.0 PK 05 2015   grade_2                         44.0 48.0                       92.0                         44 48                 92
1159509 IN     school 1810260 35   South Adams Schools 181026001640 25 South Adams Elem School   Regular School No 1.0 PK 05 2015   grade_3                         39.0 52.0                       91.0                         39 52                 91
1159510 IN     school 1810260 35   South Adams Schools 181026001640 25 South Adams Elem School   Regular School No 1.0 PK 05 2015   grade_4                         50.0 51.0                       101.0                         50 51                 101
1159511 IN     school 1810260 35   South Adams Schools 181026001640 25 South Adams Elem School   Regular School No 1.0 PK 05 2015   grade_5                         51.0 48.0                       99.0                         51 48                 99
1159512 IN     school 1810260 35   South Adams Schools 181026001640 25 South Adams Elem School   Regular School No 1.0 PK 05 2015   kindergarten                         40.0 43.0                       83.0                         40 43                 83
1159513 IN     school 1810260 35   South Adams Schools 181026001640 25 South Adams Elem School   Regular School No 1.0 PK 05 2015   pk_12_total 511.0 2.0 73.0 2.0   6.0         12.0   294.0 312.0     61.0             104.0   606.0 511 2 73 2   6         12   294 312     61       104   606
1159514 IN     school 1810260 35   South Adams Schools 181026001640 25 South Adams Elem School   Regular School No 1.0 PK 05 2015   pre_kindergarten                         31.0 16.0                       47.0                         31 16                 47
1159515 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000001 45 Aboite Elementary School   Regular School No 1.0 KG 05 2015   grade_1                         27.0 28.0                       55.0                         27 28                 55
1159516 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000001 45 Aboite Elementary School   Regular School No 1.0 KG 05 2015   grade_2                         55.0 42.0                       97.0                         55 42                 97
1159517 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000001 45 Aboite Elementary School   Regular School No 1.0 KG 05 2015   grade_3                         57.0 47.0                       104.0                         57 47                 104
1159518 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000001 45 Aboite Elementary School   Regular School No 1.0 KG 05 2015   grade_4                         52.0 54.0                       106.0                         52 54                 106
1159519 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000001 45 Aboite Elementary School   Regular School No 1.0 KG 05 2015   grade_5                         59.0 64.0                       123.0                         59 64                 123
1159520 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000001 45 Aboite Elementary School   Regular School No 1.0 KG 05 2015   kindergarten                         30.0 21.0                       51.0                         30 21                 51
1159521 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000001 45 Aboite Elementary School   Regular School No 1.0 KG 05 2015   pk_12_total 431.0 10.0 24.0     41.0     2.0   28.0   280.0 256.0     3.0             11.0   536.0 431 10 24     41     2   28   280 256     3       11   536
1159522 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000083 46 Whispering Meadow Elem Sch   Regular School No 1.0 PK 05 2015   grade_1                         43.0 38.0                       81.0                         43 38                 81
1159523 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000083 46 Whispering Meadow Elem Sch   Regular School No 1.0 PK 05 2015   grade_2                         34.0 45.0                       79.0                         34 45                 79
1159524 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000083 46 Whispering Meadow Elem Sch   Regular School No 1.0 PK 05 2015   grade_3                         27.0 40.0                       67.0                         27 40                 67
1159525 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000083 46 Whispering Meadow Elem Sch   Regular School No 1.0 PK 05 2015   grade_4                         33.0 34.0                       67.0                         33 34                 67
1159526 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000083 46 Whispering Meadow Elem Sch   Regular School No 1.0 PK 05 2015   grade_5                         34.0 38.0                       72.0                         34 38                 72
1159527 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000083 46 Whispering Meadow Elem Sch   Regular School No 1.0 PK 05 2015   kindergarten                         38.0 36.0                       74.0                         38 36                 74
1159528 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000083 46 Whispering Meadow Elem Sch   Regular School No 1.0 PK 05 2015   pk_12_total 323.0 31.0 31.0     45.0     3.0   32.0   226.0 239.0     36.0             46.0   465.0 323 31 31     45     3   32   226 239     36       46   465
1159529 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000083 46 Whispering Meadow Elem Sch   Regular School No 1.0 PK 05 2015   pre_kindergarten                         17.0 8.0                       25.0                         17 8                 25
1159530 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000002 47 Homestead Senior High School   Regular School No 3.0 09 12 2015   grade_10                         291.0 296.0                       587.0                         291 296                 587
1159531 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000002 47 Homestead Senior High School   Regular School No 3.0 09 12 2015   grade_11                         287.0 285.0                       572.0                         287 285                 572
1159532 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000002 47 Homestead Senior High School   Regular School No 3.0 09 12 2015   grade_12                         287.0 283.0                       570.0                         287 283                 570
1159533 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000002 47 Homestead Senior High School   Regular School No 3.0 09 12 2015   grade_9                         289.0 289.0                       578.0                         289 289                 578
1159534 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000002 47 Homestead Senior High School   Regular School No 3.0 09 12 2015   pk_12_total 1888.0 121.0 132.0 3.0   85.0     1.0   77.0   1154.0 1153.0     21.0             226.0   2307.0 1888 121 132 3   85     1   77   1154 1153     21       226   2307
1159535 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000116 63 Summit Middle School   Regular School No 2.0 06 08 2015   grade_6                         116.0 104.0                       220.0                         116 104                 220
1159536 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000116 63 Summit Middle School   Regular School No 2.0 06 08 2015   grade_7                         118.0 112.0                       230.0                         118 112                 230
1159537 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000116 63 Summit Middle School   Regular School No 2.0 06 08 2015   grade_8                         134.0 109.0                       243.0                         134 109                 243
1159538 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000116 63 Summit Middle School   Regular School No 2.0 06 08 2015   pk_12_total 587.0 32.0 21.0 3.0   17.0         33.0   368.0 325.0     10.0             63.0   693.0 587 32 21 3   17         33   368 325     10       63   693
1159539 IN     school 1800030 125   M S D Southwest Allen County Schls 180003002044 64 Lafayette Meadow School   Regular School No 1.0 KG 05 2015   grade_1                         54.0 32.0                       86.0                         54 32                 86
1159540 IN     school 1800030 125   M S D Southwest Allen County Schls 180003002044 64 Lafayette Meadow School   Regular School No 1.0 KG 05 2015   grade_2                         44.0 37.0                       81.0                         44 37                 81
1159541 IN     school 1800030 125   M S D Southwest Allen County Schls 180003002044 64 Lafayette Meadow School   Regular School No 1.0 KG 05 2015   grade_3                         36.0 43.0                       79.0                         36 43                 79
1159542 IN     school 1800030 125   M S D Southwest Allen County Schls 180003002044 64 Lafayette Meadow School   Regular School No 1.0 KG 05 2015   grade_4                         38.0 35.0                       73.0                         38 35                 73
1159543 IN     school 1800030 125   M S D Southwest Allen County Schls 180003002044 64 Lafayette Meadow School   Regular School No 1.0 KG 05 2015   grade_5                         58.0 42.0                       100.0                         58 42                 100
1159544 IN     school 1800030 125   M S D Southwest Allen County Schls 180003002044 64 Lafayette Meadow School   Regular School No 1.0 KG 05 2015   kindergarten                         52.0 45.0                       97.0                         52 45                 97
1159545 IN     school 1800030 125   M S D Southwest Allen County Schls 180003002044 64 Lafayette Meadow School   Regular School No 1.0 KG 05 2015   pk_12_total 457.0 16.0 17.0 4.0   12.0         10.0   282.0 234.0     3.0             32.0   516.0 457 16 17 4   12         10   282 234     3       32   516
1159546 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000005 67 Woodside Middle School   Regular School No 2.0 06 08 2015   grade_6                         171.0 158.0                       329.0                         171 158                 329
1159547 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000005 67 Woodside Middle School   Regular School No 2.0 06 08 2015   grade_7                         159.0 160.0                       319.0                         159 160                 319
1159548 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000005 67 Woodside Middle School   Regular School No 2.0 06 08 2015   grade_8                         157.0 171.0                       328.0                         157 171                 328
1159549 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000005 67 Woodside Middle School   Regular School No 2.0 06 08 2015   pk_12_total 781.0 51.0 44.0 1.0   58.0     2.0   39.0   487.0 489.0     7.0             61.0   976.0 781 51 44 1   58     2   39   487 489     7       61   976
1159550 IN     school 1800030 125   M S D Southwest Allen County Schls 180003002186 68 Haverhill Elementary School   Regular School No 1.0 KG 05 2015   grade_1                         27.0 31.0                       58.0                         27 31                 58
1159551 IN     school 1800030 125   M S D Southwest Allen County Schls 180003002186 68 Haverhill Elementary School   Regular School No 1.0 KG 05 2015   grade_2                         26.0 28.0                       54.0                         26 28                 54
1159552 IN     school 1800030 125   M S D Southwest Allen County Schls 180003002186 68 Haverhill Elementary School   Regular School No 1.0 KG 05 2015   grade_3                         31.0 37.0                       68.0                         31 37                 68
1159553 IN     school 1800030 125   M S D Southwest Allen County Schls 180003002186 68 Haverhill Elementary School   Regular School No 1.0 KG 05 2015   grade_4                         31.0 31.0                       62.0                         31 31                 62
1159554 IN     school 1800030 125   M S D Southwest Allen County Schls 180003002186 68 Haverhill Elementary School   Regular School No 1.0 KG 05 2015   grade_5                         31.0 34.0                       65.0                         31 34                 65
1159555 IN     school 1800030 125   M S D Southwest Allen County Schls 180003002186 68 Haverhill Elementary School   Regular School No 1.0 KG 05 2015   kindergarten                         41.0 29.0                       70.0                         41 29                 70
1159556 IN     school 1800030 125   M S D Southwest Allen County Schls 180003002186 68 Haverhill Elementary School   Regular School No 1.0 KG 05 2015   pk_12_total 337.0 11.0 11.0 2.0   1.0         15.0   187.0 190.0     4.0             39.0   377.0 337 11 11 2   1         15   187 190     4       39   377
1159557 IN     school 1800030 125   M S D Southwest Allen County Schls 180003002329 71 Deer Ridge Elementary   Regular School No 1.0 KG 05 2015   grade_1                         28.0 34.0                       62.0                         28 34                 62
1159558 IN     school 1800030 125   M S D Southwest Allen County Schls 180003002329 71 Deer Ridge Elementary   Regular School No 1.0 KG 05 2015   grade_2                         39.0 41.0                       80.0                         39 41                 80
1159559 IN     school 1800030 125   M S D Southwest Allen County Schls 180003002329 71 Deer Ridge Elementary   Regular School No 1.0 KG 05 2015   grade_3                         39.0 24.0                       63.0                         39 24                 63
1159560 IN     school 1800030 125   M S D Southwest Allen County Schls 180003002329 71 Deer Ridge Elementary   Regular School No 1.0 KG 05 2015   grade_4                         35.0 36.0                       71.0                         35 36                 71
1159561 IN     school 1800030 125   M S D Southwest Allen County Schls 180003002329 71 Deer Ridge Elementary   Regular School No 1.0 KG 05 2015   grade_5                         42.0 38.0                       80.0                         42 38                 80

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