Data source: Big Local News · About: Big Local

4,865 rows where state = "NV" and year = 2019 sorted by male_int descending

View and edit SQL

year

  • 2019 · 4,865
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
1874962 NV     school 3200030 1   Churchill 320003000431 1207 Numa   Regular School No Elementary 02 06 2019   grade_6 1.0                         1.0                       1 1                         1                 1
1875226 NV     school 3200060 2   Clark 320006000080 2103 Lundy   Regular School No Elementary PK 05 2019   grade_1 1.0                         1.0                       1 1                         1                 1
1875231 NV     school 3200060 2   Clark 320006000080 2103 Lundy   Regular School No Elementary PK 05 2019   kindergarten 3.0                         3.0                       3 3                         3                 3
1876944 NV     school 3200060 2   Clark 320006000078 2602 Moapa Valley   Regular School No High 09 12 2019   ungraded 1.0                         1.0                       1 1                         1                 1
1877080 NV     school 3200060 2   Clark 320006000607 2917 Miley Achvmt ES   Special Education School No Elementary PK 05 2019   grade_2   1.0                       1.0                       1   1                       1                 1
1877111 NV     school 3200060 2   Clark 320006000597 2932 Cowan Behavior   Alternative School No High 06 12 2019   grade_6   1.0                       1.0                       1   1                       1                 1
1877124 NV     school 3200060 2   Clark 320006000619 2935 Variety School ES   Special Education School No Elementary PK 05 2019   grade_2 1.0                         1.0                       1 1                         1                 1
1877131 NV     school 3200060 2   Clark 320006000767 2955 Desert Rose ALT   Alternative School No High 09 12 2019   grade_9   1.0 1.0                     2.0                       2   1 1                     2                 2
1877145 NV     school 3200090 3   Douglas 320009000121 3201 Gardnerville ES   Regular School No Elementary PK 05 2019   pre_kindergarten 1.0                         1.0                       1 1                         1                 1
1877216 NV     school 3200090 3   Douglas 320009000764 3901 Douglas ALT ALT   Alternative School No Other 04 12 2019   grade_8 2.0                         2.0                       2 2                         2                 2
1877218 NV     school 3200090 3   Douglas 320009000764 3901 Douglas ALT ALT   Alternative School No Other 04 12 2019   grade_10         1.0           1.0     2.0                       2         1           1     2                 2
1877221 NV     school 3200120 4   Elko 320012000131 4104 Independence Vly ES   Regular School No Elementary KG 08 2019   grade_2 1.0                         1.0                       1 1                         1                 1
1877222 NV     school 3200120 4   Elko 320012000131 4104 Independence Vly ES   Regular School No Elementary KG 08 2019   grade_3 1.0                         1.0                       1 1                         1                 1
1877223 NV     school 3200120 4   Elko 320012000131 4104 Independence Vly ES   Regular School No Elementary KG 08 2019   grade_4     1.0                     1.0                       1     1                     1                 1
1877225 NV     school 3200120 4   Elko 320012000131 4104 Independence Vly ES   Regular School No Elementary KG 08 2019   grade_7 1.0                         1.0                       1 1                         1                 1
1877236 NV     school 3200120 4   Elko 320012000134 4108 Mound Vly ES   Regular School No Elementary KG 08 2019   grade_5 3.0                         3.0                       3 3                         3                 3
1877237 NV     school 3200120 4   Elko 320012000134 4108 Mound Vly ES   Regular School No Elementary KG 08 2019   grade_7 1.0                         1.0                       1 1                         1                 1
1877239 NV     school 3200120 4   Elko 320012000134 4108 Mound Vly ES   Regular School No Elementary KG 08 2019   kindergarten 2.0                         2.0                       2 2                         2                 2
1877241 NV     school 3200120 4   Elko 320012000139 4111 Ruby Vly ES   Regular School No Elementary KG 08 2019   grade_2 2.0                         2.0                       2 2                         2                 2
1877305 NV     school 3200120 4   Elko 320012000350 4210 Spring Creek ES   Regular School No Elementary KG 06 2019   grade_6     1.0                     1.0                       1     1                     1                 1
1877317 NV     school 3200120 4   Elko 320012000750 4213 Flagview Int Sch   Regular School No Middle 05 08 2019   grade_8 1.0                         1.0                       1 1                         1                 1
1877338 NV     school 3200120 4   Elko 320012000568 4601 Carlin HS   Regular School No High 09 12 2019   ungraded     1.0                     1.0                       1     1                     1                 1
1877366 NV     school 3200120 4   Elko 320012000839 4610 NNVVirtual   Regular School No Other KG 12 2019   grade_1 1.0                         1.0                       1 1                         1                 1
1877368 NV     school 3200120 4   Elko 320012000839 4610 NNVVirtual   Regular School No Other KG 12 2019   grade_4 1.0                         1.0                       1 1                         1                 1
1877369 NV     school 3200120 4   Elko 320012000839 4610 NNVVirtual   Regular School No Other KG 12 2019   grade_5 3.0                         3.0                       3 3                         3                 3
1877378 NV     school 3200120 4   Elko 320012000854 4902 Elko Adult   Alternative School No Ungraded UG UG 2019   ungraded     2.0                     2.0                       2     2                     2                 2
1877393 NV     school 3200150 5   Esmeralda 320015000144 5102 Goldfield ES   Regular School No Elementary PK 08 2019   grade_4 1.0                   1.0     2.0                       2 1                   1     2                 2
1877396 NV     school 3200150 5   Esmeralda 320015000144 5102 Goldfield ES   Regular School No Elementary PK 08 2019   grade_7 1.0                         1.0                       1 1                         1                 1
1877398 NV     school 3200150 5   Esmeralda 320015000144 5102 Goldfield ES   Regular School No Elementary PK 08 2019   kindergarten 2.0                   1.0     3.0                       3 2                   1     3                 3
1877402 NV     school 3200150 5   Esmeralda 320015000145 5103 Silver Peak ES   Regular School No Elementary PK 08 2019   grade_6 1.0                         1.0                       1 1                         1                 1
1877403 NV     school 3200150 5   Esmeralda 320015000145 5103 Silver Peak ES   Regular School No Elementary PK 08 2019   grade_7 1.0                         1.0                       1 1                         1                 1
1877405 NV     school 3200150 5   Esmeralda 320015000145 5103 Silver Peak ES   Regular School No Elementary PK 08 2019   kindergarten 1.0                         1.0                       1 1                         1                 1
1877406 NV     school 3200150 5   Esmeralda 320015000145 5103 Silver Peak ES   Regular School No Elementary PK 08 2019   pre_kindergarten 1.0                         1.0                       1 1                         1                 1
1877407 NV     school 3200180 6   Eureka 320018000146 6101 Crescent Vly   Regular School No Elementary PK 06 2019   grade_1 2.0                   1.0     3.0                       3 2                   1     3                 3
1877429 NV     school 3200210 7   Humboldt 320021000150 7101 Denio ES   Regular School No Elementary PK 08 2019   grade_2 1.0                         1.0                       1 1                         1                 1
1877431 NV     school 3200210 7   Humboldt 320021000150 7101 Denio ES   Regular School No Elementary PK 08 2019   grade_4     1.0                     1.0                       1     1                     1                 1
1877434 NV     school 3200210 7   Humboldt 320021000151 7103 Kings River ES   Regular School No Elementary PK 08 2019   grade_1 1.0                         1.0                       1 1                         1                 1
1877439 NV     school 3200210 7   Humboldt 320021000151 7103 Kings River ES   Regular School No Elementary PK 08 2019   grade_8 1.0                         1.0                       1 1                         1                 1
1877446 NV     school 3200210 7   Humboldt 320021000155 7104 Orovada ES   Regular School No Elementary PK 08 2019   grade_7 1.0   1.0                     2.0                       2 1   1                     2                 2
1877453 NV     school 3200210 7   Humboldt 320021000156 7105 Paradise Vly ES   Regular School No Elementary PK 08 2019   grade_5 3.0   2.0                     5.0                       5 3   2                     5                 5
1877513 NV     school 3200240 8   Lander 320024000162 8602 Austin School   Regular School No Other PK 12 2019   grade_2 1.0                         1.0                       1 1                         1                 1
1877514 NV     school 3200240 8   Lander 320024000162 8602 Austin School   Regular School No Other PK 12 2019   grade_5     1.0                     1.0                       1     1                     1                 1
1877517 NV     school 3200240 8   Lander 320024000162 8602 Austin School   Regular School No Other PK 12 2019   grade_10 1.0                         1.0                       1 1                         1                 1
1877691 NV     school 3200330 11   Mineral 320033000184 11202 Schurz ES   Regular School No Elementary PK 06 2019   pre_kindergarten         1.0                 1.0                       1         1                 1                 1
1877702 NV     school 3200360 12   Nye 320036000188 12101 Duckwater ES   Regular School No Elementary PK 05 2019   grade_4     1.0               1.0     2.0                       2     1               1     2                 2
1877704 NV     school 3200360 12   Nye 320036000188 12101 Duckwater ES   Regular School No Elementary PK 05 2019   kindergarten                     1.0     1.0                       1                     1     1                 1
1877723 NV     school 3200360 12   Nye 320036000189 12105 Gabbs ES   Regular School No Elementary PK 05 2019   grade_4 1.0       1.0                 2.0                       2 1       1                 2                 2
1877769 NV     school 3200360 12   Nye 320036000871 12211 Warm Springs   Regular School No Elementary PK 08 2019   grade_4 1.0                         1.0                       1 1                         1                 1
1877772 NV     school 3200360 12   Nye 320036000871 12211 Warm Springs   Regular School No Elementary PK 08 2019   kindergarten 1.0                         1.0                       1 1                         1                 1
1877785 NV     school 3200360 12   Nye 320036000575 12315 Gabbs MS   Regular School No Middle 06 08 2019   grade_6 1.0                         1.0                       1 1                         1                 1
1877786 NV     school 3200360 12   Nye 320036000575 12315 Gabbs MS   Regular School No Middle 06 08 2019   grade_7 3.0                         3.0                       3 3                         3                 3
1877787 NV     school 3200360 12   Nye 320036000575 12315 Gabbs MS   Regular School No Middle 06 08 2019   grade_8         1.0                 1.0                       1         1                 1                 1
1877821 NV     school 3200360 12   Nye 320036000852 12609 Pathways Elem ALT   Alternative School No Elementary 03 05 2019   grade_4     2.0                     2.0                       2     2                     2                 2
1877910 NV     school 3200420 14   Pershing 320042000198 14601 Pershing HS   Regular School No High 09 12 2019   grade_13 1.0                         1.0                       1 1                         1                 1
1877921 NV     school 3200450 15   Storey 320045000413 15102 Hillside ES   Regular School No Elementary PK 05 2019   grade_4 6.0   1.0                     7.0                       7 6   1                     7                 7
1877946 NV     school 3200480 16   Washoe 320048000209 16202 Loder ES   Regular School No Elementary PK 06 2019   pre_kindergarten     2.0                     2.0                       2     2                     2                 2
1878066 NV     school 3200480 16   Washoe 320048000248 16219 Stead   Regular School No Elementary PK 06 2019   pre_kindergarten 1.0                         1.0                       1 1                         1                 1
1878297 NV     school 3200480 16   Washoe 320048000367 16263 Silver Lake ES   Regular School No Elementary PK 04 2019   pre_kindergarten 1.0                         1.0                       1 1                         1                 1
1878526 NV     school 3200480 16   Washoe 320048000217 16601 Gerlach K-12   Regular School No Other PK 12 2019   grade_2     1.0                     1.0                       1     1                     1                 1
1878529 NV     school 3200480 16   Washoe 320048000217 16601 Gerlach K-12   Regular School No Other PK 12 2019   grade_5     1.0                     1.0                       1     1                     1                 1
1878586 NV     school 3200480 16   Washoe 320048000233 16911 Picollo Sch   Special Education School No Other PK 12 2019   grade_1 1.0                         1.0                       1 1                         1                 1
1878606 NV     school 3200480 16   Washoe 320048000766 16917 Turning Point   Alternative School No Other 01 12 2019   grade_7 1.0                         1.0                       1 1                         1                 1
1878657 NV     school 3200510 17   White Pine 320051000267 17502 White Pine HS   Regular School No High 09 12 2019   ungraded 1.0                         1.0                       1 1                         1                 1
1877130 NV     school 3200060 2   Clark 320006000795 2941 Adult Ed   Alternative School No High 12 12 2019   adult 553.0 1035.0 3225.0   32.0 117.0       42.0 102.0   2120.0 2986.0                       5106 553 1035 3225   32 117       42 102   2120 2986                 5106
1879469 NV     school 3200060 2   Clark 320006000540 2612 Coronado   Regular School No High 09 12 2019   k_12_total 1959.0 173.0 605.0   16.0 399.0       38.0 260.0   1776.0 1674.0                       3450 1959 173 605   16 399       38 260   1776 1674                 3450
1879429 NV     school 3200060 2   Clark 320006000030 2401 Clark   Regular School No High 09 12 2019   k_12_total 349.0 369.0 1786.0   7.0 572.0       48.0 136.0   1736.0 1531.0                       3267 349 369 1786   7 572       48 136   1736 1531                 3267
1879473 NV     school 3200060 2   Clark 320006000661 2618 Arbor View   Regular School No High 09 12 2019   k_12_total 1567.0 461.0 781.0   20.0 177.0       50.0 250.0   1680.0 1626.0                       3306 1567 461 781   20 177       50 250   1680 1626                 3306
1879450 NV     school 3200060 2   Clark 320006000446 2425 Palo Verde HS   Regular School No High 09 12 2019   k_12_total 1622.0 239.0 729.0   8.0 302.0       42.0 256.0   1656.0 1542.0                       3198 1622 239 729   8 302       42 256   1656 1542                 3198
1879452 NV     school 3200060 2   Clark 320006000595 2427 Shadow Ridge HS   Regular School No High 09 12 2019   k_12_total 1339.0 493.0 867.0   12.0 145.0       73.0 258.0   1648.0 1539.0                       3187 1339 493 867   12 145       73 258   1648 1539                 3187
1879477 NV     school 3200060 2   Clark 320006000754 2623 Desert Oasis HS   Regular School No High 09 12 2019   k_12_total 970.0 370.0 857.0   3.0 585.0       101.0 283.0   1643.0 1526.0                       3169 970 370 857   3 585       101 283   1643 1526                 3169
1879465 NV     school 3200060 2   Clark 320006000493 2607 Centennial   Regular School No High 09 12 2019   k_12_total 1206.0 514.0 837.0   16.0 149.0       55.0 273.0   1605.0 1445.0                       3050 1206 514 837   16 149       55 273   1605 1445                 3050
1879442 NV     school 3200060 2   Clark 320006000407 2416 Green Valley   Regular School No High 09 12 2019   k_12_total 1236.0 261.0 1035.0   24.0 202.0       57.0 245.0   1584.0 1476.0                       3060 1236 261 1035   24 202       57 245   1584 1476                 3060
1879431 NV     school 3200060 2   Clark 320006000089 2403 Rancho   Regular School No High 09 12 2019   k_12_total 284.0 278.0 2495.0   12.0 125.0       24.0 74.0   1557.0 1735.0                       3292 284 278 2495   12 125       24 74   1557 1735                 3292
1879430 NV     school 3200060 2   Clark 320006000065 2402 Las Vegas   Regular School No High 09 12 2019   k_12_total 282.0 255.0 2031.0   12.0 127.0       25.0 83.0   1533.0 1282.0                       2815 282 255 2031   12 127       25 83   1533 1282                 2815
1879800 NV     school 3200001 85   Nevada Connections Academy 320000100731 85405 NV Connections ACAD   Regular School Yes Other KG 12 2019   k_12_total 1524.0 398.0 807.0   23.0 85.0       49.0 361.0   1533.0 1714.0                       3247 1524 398 807   23 85       49 361   1533 1714                 3247
1879433 NV     school 3200060 2   Clark 320006000114 2405 Western   Regular School No High 09 12 2019   k_12_total 159.0 459.0 2029.0   9.0 68.0       33.0 71.0   1515.0 1313.0                       2828 159 459 2029   9 68       33 71   1515 1313                 2828
1879467 NV     school 3200060 2   Clark 320006000495 2609 Desert Pines   Regular School No High 09 12 2019   k_12_total 112.0 425.0 2190.0   8.0 44.0       24.0 75.0   1509.0 1369.0                       2878 112 425 2190   8 44       24 75   1509 1369                 2878
1879453 NV     school 3200060 2   Clark 320006000604 2428 Liberty   Regular School No High 09 12 2019   k_12_total 869.0 311.0 808.0   12.0 393.0       204.0 306.0   1504.0 1399.0                       2903 869 311 808   12 393       204 306   1504 1399                 2903
1879468 NV     school 3200060 2   Clark 320006000539 2611 Sierra Vista HS   Regular School No High 09 12 2019   k_12_total 601.0 386.0 714.0   14.0 484.0       121.0 292.0   1473.0 1139.0                       2612 601 386 714   14 484       121 292   1473 1139                 2612
1879432 NV     school 3200060 2   Clark 320006000107 2404 Valley HS   Regular School No High 09 12 2019   k_12_total 217.0 400.0 1888.0   8.0 159.0       19.0 91.0   1404.0 1378.0                       2782 217 400 1888   8 159       19 91   1404 1378                 2782
1879474 NV     school 3200060 2   Clark 320006000714 2619 Legacy   Regular School No High 09 12 2019   k_12_total 419.0 945.0 1017.0   10.0 122.0       49.0 212.0   1402.0 1372.0                       2774 419 945 1017   10 122       49 212   1402 1372                 2774
1879440 NV     school 3200060 2   Clark 320006000406 2414 Cimarron Mem HS   Regular School No High 09 12 2019   k_12_total 460.0 512.0 1251.0   10.0 90.0       48.0 154.0   1399.0 1126.0                       2525 460 512 1251   10 90       48 154   1399 1126                 2525
1879454 NV     school 3200060 2   Clark 320006000567 2429 Canyon Springs   Regular School No High 09 12 2019   k_12_total 111.0 775.0 1655.0   4.0 54.0       24.0 98.0   1393.0 1328.0                       2721 111 775 1655   4 54       24 98   1393 1328                 2721
1879466 NV     school 3200060 2   Clark 320006000494 2608 Foothill HS   Regular School No High 09 12 2019   k_12_total 1570.0 158.0 645.0   21.0 105.0       29.0 192.0   1388.0 1332.0                       2720 1570 158 645   21 105       29 192   1388 1332                 2720
1879459 NV     school 3200060 2   Clark 320006000777 2434 Sunrise Mountain HS   Regular School No High 09 12 2019   k_12_total 146.0 288.0 2020.0   4.0 30.0       5.0 69.0   1346.0 1216.0                       2562 146 288 2020   4 30       5 69   1346 1216                 2562
1879434 NV     school 3200060 2   Clark 320006000007 2406 Basic   Regular School No High 09 12 2019   k_12_total 870.0 354.0 971.0   13.0 133.0       58.0 170.0   1335.0 1234.0                       2569 870 354 971   13 133       58 170   1335 1234                 2569
1879449 NV     school 3200060 2   Clark 320006000445 2424 Mojave   Regular School No High 09 12 2019   k_12_total 206.0 733.0 1268.0   10.0 70.0       39.0 120.0   1298.0 1148.0                       2446 206 733 1268   10 70       39 120   1298 1148                 2446
1879740 NV     school 3200480 16   Washoe 320048000545 16606 Spanish Spgs   Regular School No High 09 12 2019   k_12_total 1237.0 41.0 886.0   41.0 63.0       12.0 133.0   1286.0 1127.0                       2413 1237 41 886   41 63       12 133   1286 1127                 2413
1879436 NV     school 3200060 2   Clark 320006000018 2409 Chaparral   Regular School No High 09 12 2019   k_12_total 282.0 411.0 1461.0   18.0 78.0       35.0 99.0   1273.0 1111.0                       2384 282 411 1461   18 78       35 99   1273 1111                 2384
1879443 NV     school 3200060 2   Clark 320006000276 2417 Durango   Regular School No High 09 12 2019   k_12_total 470.0 373.0 981.0   7.0 334.0       60.0 165.0   1266.0 1124.0                       2390 470 373 981   7 334       60 165   1266 1124                 2390
1879456 NV     school 3200060 2   Clark 320006000616 2431 Spring Valley   Regular School No High 09 12 2019   k_12_total 628.0 360.0 916.0   8.0 400.0       40.0 188.0   1262.0 1278.0                       2540 628 360 916   8 400       40 188   1262 1278                 2540
1879455 NV     school 3200060 2   Clark 320006000571 2430 Del Sol   Regular School No High 09 12 2019   k_12_total 350.0 297.0 1480.0   11.0 91.0       31.0 119.0   1214.0 1165.0                       2379 350 297 1480   11 91       31 119   1214 1165                 2379
1879437 NV     school 3200060 2   Clark 320006000032 2410 Eldorado HS   Regular School No High 09 12 2019   k_12_total 174.0 229.0 1519.0   7.0 40.0       15.0 59.0   1200.0 843.0                       2043 174 229 1519   7 40       15 59   1200 843                 2043
1879441 NV     school 3200060 2   Clark 320006000405 2415 Cheyenne   Regular School No High 09 12 2019   k_12_total 217.0 656.0 1006.0   10.0 69.0       32.0 101.0   1189.0 902.0                       2091 217 656 1006   10 69       32 101   1189 902                 2091
1879446 NV     school 3200060 2   Clark 320006000420 2421 Silverado   Regular School No High 09 12 2019   k_12_total 775.0 274.0 757.0   9.0 228.0       64.0 192.0   1187.0 1112.0                       2299 775 274 757   9 228       64 192   1187 1112                 2299
1879634 NV     school 3200390 13   Carson 320039000280 13501 Carson HS   Regular School No High 09 12 2019   k_12_total 1097.0 11.0 982.0   42.0 52.0       4.0 83.0   1145.0 1126.0                       2271 1097 11 982   42 52       4 83   1145 1126                 2271
1879438 NV     school 3200060 2   Clark 320006000011 2411 Bonanza   Regular School No High 09 12 2019   k_12_total 424.0 290.0 1144.0   11.0 63.0       36.0 117.0   1138.0 947.0                       2085 424 290 1144   11 63       36 117   1138 947                 2085
1879730 NV     school 3200480 16   Washoe 320048000210 16505 Reed   Regular School No High 09 12 2019   k_12_total 951.0 62.0 783.0   38.0 121.0       19.0 119.0   1131.0 962.0                       2093 951 62 783   38 121       19 119   1131 962                 2093
1879741 NV     school 3200480 16   Washoe 320048000546 16607 North Valleys   Regular School No High 09 12 2019   k_12_total 875.0 51.0 900.0   30.0 57.0       28.0 129.0   1099.0 971.0                       2070 875 51 900   30 57       28 129   1099 971                 2070
1879423 NV     school 3200060 2   Clark 320006000700 2360 Tarkanian MS   Regular School No Middle 06 08 2019   k_12_total 685.0 208.0 485.0   8.0 331.0       76.0 237.0   1041.0 989.0                       2030 685 208 485   8 331       76 237   1041 989                 2030

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