Data source: Big Local News · About: Big Local

1,471 rows where grade = "k_12_total", state = "OR" and year = 2021 sorted by hispanic_int descending

View and edit SQL

year

  • 2021 · 1,471

grade

  • k_12_total · 1,471
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
657973 OR     school 4110820 2142   Salem-Keizer SD 24J 411082001296 771 McKay High School   Regular School No High 09 12 2021   k_12_total 492 31 1557   4 55     121   70                               492 31 1557   4 55     121   70                        
657979 OR     school 4110820 2142   Salem-Keizer SD 24J 411082000818 773 North Salem High School   Regular School No High 09 12 2021   k_12_total 545 33 1274   15 27     73   82                               545 33 1274   15 27     73   82                        
657917 OR     school 4110520 2182   Reynolds SD 7 411052001009 957 Reynolds High School   Regular School No High 09 12 2021   k_12_total 779 210 1171   21 218     68   157                               779 210 1171   21 218     68   157                        
657207 OR     school 4105160 2241   Forest Grove SD 15 410516001189 1134 Forest Grove High School   Regular School No High 09 12 2021   k_12_total 721 12 1051   6 29     5   60                               721 12 1051   6 29     5   60                        
657306 OR     school 4106300 2206   Hermiston SD 8 410630001097 1040 Hermiston High School   Regular School No High 09 12 2021   k_12_total 743 7 898   1 18     7   29                               743 7 898   1 18     7   29                        
657996 OR     school 4110820 2142   Salem-Keizer SD 24J 411082000814 768 Waldo Middle School   Regular School No Middle 06 08 2021   k_12_total 192 12 886   10 15     75   40                               192 12 886   10 15     75   40                        
656827 OR     school 4101920 2243   Beaverton SD 48J 410192001239 1186 Aloha High School   Regular School No High 09 12 2021   k_12_total 595 97 816   7 127     24   100                               595 97 816   7 127     24   100                        
657502 OR     school 4108010 2256   McMinnville SD 40 410801001284 1234 McMinnville High School   Regular School No High 09 12 2021   k_12_total 1209 28 799   38 23     9   8                               1209 28 799   38 23     9   8                        
657077 OR     school 4103940 2187   David Douglas SD 40 410394001037 983 David Douglas High School   Regular School No High 09 12 2021   k_12_total 909 339 779   22 504     63   191                               909 339 779   22 504     63   191                        
657991 OR     school 4110820 2142   Salem-Keizer SD 24J 411082000668 1331 Stephens Middle School   Regular School No Middle 06 08 2021   k_12_total 221 12 765   5 32     30   39                               221 12 765   5 32     30   39                        
657975 OR     school 4110820 2142   Salem-Keizer SD 24J 411082000817 772 McNary High School   Regular School No High 09 12 2021   k_12_total 1089 16 761   12 27     33   123                               1089 16 761   12 27     33   123                        
657961 OR     school 4110820 2142   Salem-Keizer SD 24J 411082000664 1330 Houck Middle School   Regular School No Middle 06 08 2021   k_12_total 227 13 699   6 11     45   42                               227 13 699   6 11     45   42                        
656834 OR     school 4101920 2243   Beaverton SD 48J 410192001240 1187 Beaverton High School   Regular School No High 09 12 2021   k_12_total 650 45 689   5 76     13   89                               650 45 689   5 76     13   89                        
657989 OR     school 4110820 2142   Salem-Keizer SD 24J 411082000820 775 South Salem High School   Regular School No High 09 12 2021   k_12_total 1211 36 685   8 61     43   152                               1211 36 685   8 61     43   152                        
657324 OR     school 4100023 2239   Hillsboro SD 1J 410002301252 1201 Hillsboro High School   Regular School No High 09 12 2021   k_12_total 390 28 679   10 58     8   82                               390 28 679   10 58     8   82                        
658004 OR     school 4108100 2104   Santiam Canyon SD 129J 410810001680 4399 Oregon Charter Academy   Regular School Yes Other KG 12 2021   k_12_total 3451 110 655   78 138     33   246                               3451 110 655   78 138     33   246                        
657275 OR     school 4106000 2183   Gresham-Barlow SD 10J 410600001040 986 Gresham High School   Regular School No High 09 12 2021   k_12_total 652 71 626   8 52     17   106                               652 71 626   8 52     17   106                        
658233 OR     school 4113530 2146   Woodburn SD 103 411353000844 1268 French Prairie Middle School   Regular School No Middle 06 08 2021   k_12_total 61 4 604   2 3     1   3                               61 4 604   2 3     1   3                        
657322 OR     school 4100023 2239   Hillsboro SD 1J 410002301306 1200 Glencoe High School   Regular School No High 09 12 2021   k_12_total 664 30 594   5 45     3   73                               664 30 594   5 45     3   73                        
658235 OR     school 4113530 2146   Woodburn SD 103 411353000843 1267 Lincoln Elementary School   Regular School No Elementary KG 05 2021   k_12_total 57 2 553   0 2     3   6                               57 2 553   0 2     3   6                        
657353 OR     school 4106510 2024   Hood River County SD 410651000390 369 Hood River Valley High School   Regular School No High 09 12 2021   k_12_total 705 8 547   10 14     0   34                               705 8 547   10 14     0   34                        
657333 OR     school 4100023 2239   Hillsboro SD 1J 410002301585 4018 Liberty High School   Regular School No High 09 12 2021   k_12_total 644 30 545   17 91     21   93                               644 30 545   17 91     21   93                        
657529 OR     school 4108040 2048   Medford SD 549C 410804000444 423 South Medford High School   Regular School No High 09 12 2021   k_12_total 1071 21 542   9 20     6   76                               1071 21 542   9 20     6   76                        
657919 OR     school 4110520 2182   Reynolds SD 7 411052001010 1254 Reynolds Middle School   Regular School No Middle 06 08 2021   k_12_total 202 70 539   8 31     32   62                               202 70 539   8 31     32   62                        
656970 OR     school 4102800 2185   Centennial SD 28J 410280001020 967 Centennial High School   Regular School No High 09 12 2021   k_12_total 646 102 538   11 248     45   100                               646 102 538   11 248     45   100                        
658176 OR     school 4112240 2242   Tigard-Tualatin SD 23J 411224000440 1301 Tualatin High School   Regular School No High 09 12 2021   k_12_total 988 27 538   9 118     46   140                               988 27 538   9 118     46   140                        
658237 OR     school 4113530 2146   Woodburn SD 103 411353001052 1360 Valor Middle School   Regular School No Middle 06 08 2021   k_12_total 117 1 520   1 4     1   3                               117 1 520   1 4     1   3                        
657211 OR     school 4105160 2241   Forest Grove SD 15 410516001188 1126 Neil Armstrong Middle School   Regular School No Middle 07 08 2021   k_12_total 300 7 518   5 3     1   25                               300 7 518   5 3     1   25                        
657600 OR     school 4108820 1966   North Bend SD 13 410882001751 4690 Oregon Virtual Academy   Regular School Yes Other KG 12 2021   k_12_total 2266 77 514   30 51     9   268                               2266 77 514   30 51     9   268                        
658234 OR     school 4113530 2146   Woodburn SD 103 411353001051 1359 Heritage Elementary   Regular School No Elementary KG 05 2021   k_12_total 149 2 508   1 4     0   8                               149 2 508   1 4     0   8                        
656828 OR     school 4101920 2243   Beaverton SD 48J 410192001204 1153 Aloha-Huber Park School   Regular School No Elementary PK 08 2021   k_12_total 187 42 493   3 50     2   45                               187 42 493   3 50     2   45                        
658238 OR     school 4113530 2146   Woodburn SD 103 411353000842 797 Washington Elementary School   Regular School No Elementary KG 05 2021   k_12_total 1 0 490   0 0     0   1                               1 0 490   0 0     0   1                        
657944 OR     school 4110820 2142   Salem-Keizer SD 24J 411082001440 3373 Claggett Creek Middle School   Regular School No Middle 06 08 2021   k_12_total 375 5 485   7 9     14   57                               375 5 485   7 9     14   57                        
656883 OR     school 4101920 2243   Beaverton SD 48J 410192000554 1320 Westview High School   Regular School No High 09 12 2021   k_12_total 953 84 482   12 652     18   165                               953 84 482   12 652     18   165                        
657316 OR     school 4100023 2239   Hillsboro SD 1J 410002301248 1368 Century High School   Regular School No High 09 12 2021   k_12_total 653 46 482   11 192     23   110                               653 46 482   11 192     23   110                        
656876 OR     school 4101920 2243   Beaverton SD 48J 410192001432 2783 Southridge High School   Regular School No High 09 12 2021   k_12_total 735 43 472   8 93     17   113                               735 43 472   8 93     17   113                        
658186 OR     school 4112600 2204   Umatilla SD 6R 411260001091 1032 McNary Heights Elementary School   Regular School No Elementary KG 05 2021   k_12_total 170 0 472   2 0     1   6                               170 0 472   2 0     1   6                        
657855 OR     school 4110040 2180   Portland SD 1J 411004001821 918 Roosevelt High School   Regular School No High 09 12 2021   k_12_total 431 203 466   15 42     35   101                               431 203 466   15 42     35   101                        
657693 OR     school 4109270 2108   Ontario SD 8C 410927000746 699 Ontario High School   Regular School No High 09 12 2021   k_12_total 199 5 465   2 3     0   12                               199 5 465   2 3     0   12                        
656998 OR     school 4102840 2191   Central SD 13J 410284001058 1002 Central High School   Regular School No High 09 12 2021   k_12_total 494 8 464   12 10     5   50                               494 8 464   12 10     5   50                        
657304 OR     school 4106300 2206   Hermiston SD 8 410630001096 1039 Armand Larive Middle School   Regular School No Middle 06 08 2021   k_12_total 281 6 458   5 4     0   19                               281 6 458   5 4     0   19                        
656881 OR     school 4101920 2243   Beaverton SD 48J 410192001230 1177 Vose Elementary School   Regular School No Elementary PK 05 2021   k_12_total 170 14 447   0 14     6   40                               170 14 447   0 14     6   40                        
656954 OR     school 4102640 1929   Canby SD 86 410264000148 140 Canby High School   Regular School No High 09 12 2021   k_12_total 845 4 439   6 11     2   57                               845 4 439   6 11     2   57                        
658106 OR     school 4111670 2083   Springfield SD 19 411167000594 560 Springfield High School   Regular School No High 09 12 2021   k_12_total 744 21 427   18 13     11   109                               744 21 427   18 13     11   109                        
658173 OR     school 4112240 2242   Tigard-Tualatin SD 23J 411224001198 1146 Tigard High School   Regular School No High 09 12 2021   k_12_total 1049 32 427   11 102     32   129                               1049 32 427   11 102     32   129                        
657525 OR     school 4108040 2048   Medford SD 549C 410804000445 424 North Medford High School   Regular School No High 09 12 2021   k_12_total 1061 19 424   5 36     23   92                               1061 19 424   5 36     23   92                        
657950 OR     school 4110820 2142   Salem-Keizer SD 24J 411082000797 751 Eyre Elementary School   Regular School No Elementary KG 05 2021   k_12_total 120 7 417   2 8     9   10                               120 7 417   2 8     9   10                        
657311 OR     school 4106300 2206   Hermiston SD 8 410630001094 1037 Sunset Elementary School   Regular School No Elementary KG 05 2021   k_12_total 147 0 415   2 4     0   10                               147 0 415   2 4     0   10                        
657125 OR     school 4104500 2043   Eagle Point SD 9 410450000414 394 Table Rock Elementary   Regular School No Elementary KG 05 2021   k_12_total 301 1 410   1 2     0   32                               301 1 410   1 2     0   32                        
657942 OR     school 4110820 2142   Salem-Keizer SD 24J 411082001826 5064 Cesar E Chavez Elementary   Regular School No Elementary KG 05 2021   k_12_total 96 10 407   0 16     26   14                               96 10 407   0 16     26   14                        
656848 OR     school 4101920 2243   Beaverton SD 48J 410192001234 1181 Five Oaks Middle School   Regular School No Middle 06 08 2021   k_12_total 367 47 406   5 70     8   76                               367 47 406   5 70     8   76                        
657344 OR     school 4100023 2239   Hillsboro SD 1J 410002301253 1198 South Meadows Middle School   Regular School No Middle 07 08 2021   k_12_total 213 21 403   3 27     3   45                               213 21 403   3 27     3   45                        
657937 OR     school 4110820 2142   Salem-Keizer SD 24J 411082000774 728 Auburn Elementary School   Regular School No Elementary KG 05 2021   k_12_total 100 5 402   6 9     18   14                               100 5 402   6 9     18   14                        
657981 OR     school 4110820 2142   Salem-Keizer SD 24J 411082000813 767 Parrish Middle School   Regular School No Middle 06 08 2021   k_12_total 216 20 401   4 4     18   28                               216 20 401   4 4     18   28                        
657204 OR     school 4105160 2241   Forest Grove SD 15 410516001184 1130 Echo Shaw Elementary School   Regular School No Elementary PK 06 2021   k_12_total 11 0 395   3 0     0   0                               11 0 395   3 0     0   0                        
657804 OR     school 4110040 2180   Portland SD 1J 411004000960 911 Franklin High School   Regular School No High 09 12 2021   k_12_total 1054 88 386   10 260     19   182                               1054 88 386   10 260     19   182                        
658240 OR     school 4113530 2146   Woodburn SD 103 411353001713 4542 Woodburn Academy of Art, Science and Technology   Regular School No High 09 12 2021   k_12_total 63 0 382   0 4     1   5                               63 0 382   0 4     1   5                        
657259 OR     school 4101120 2100   Greater Albany Public SD 8J 410112000736 650 South Albany High School   Regular School No High 09 12 2021   k_12_total 849 6 380   24 11     4   76                               849 6 380   24 11     4   76                        
657213 OR     school 4105160 2241   Forest Grove SD 15 410516001339 1127 Tom McCall Upper Elementary   Regular School No Middle 05 06 2021   k_12_total 267 4 378   2 10     2   21                               267 4 378   2 10     2   21                        
657287 OR     school 4106000 2183   Gresham-Barlow SD 10J 410600001041 987 Sam Barlow High School   Regular School No High 09 12 2021   k_12_total 1084 36 377   12 66     11   102                               1084 36 377   12 66     11   102                        
658236 OR     school 4113530 2146   Woodburn SD 103 411353000841 796 Nellie Muir Elementary School   Regular School No Elementary KG 05 2021   k_12_total 27 3 377   0 3     0   4                               27 3 377   0 3     0   4                        
657660 OR     school 4109000 2110   Nyssa SD 26 410900000750 702 Nyssa Elementary School   Regular School No Elementary KG 05 2021   k_12_total 163 1 375   0 0     0   9                               163 1 375   0 0     0   9                        
657994 OR     school 4110820 2142   Salem-Keizer SD 24J 411082000808 762 Swegle Elementary School   Regular School No Elementary KG 05 2021   k_12_total 118 9 371   4 15     35   15                               118 9 371   4 15     35   15                        
657561 OR     school 4108520 2147   Morrow SD 1 410852000863 820 Riverside Junior/Senior High School   Regular School No High 07 12 2021   k_12_total 80 1 369   1 1     1   4                               80 1 369   1 1     1   4                        
657988 OR     school 4110820 2142   Salem-Keizer SD 24J 411082000787 741 Scott Elementary School   Regular School No Elementary KG 05 2021   k_12_total 85 6 364   1 9     54   11                               85 6 364   1 9     54   11                        
658000 OR     school 4110820 2142   Salem-Keizer SD 24J 411082004191 3463 West Salem High School   Regular School No High 09 12 2021   k_12_total 1147 23 363   20 43     10   126                               1147 23 363   20 43     10   126                        
658239 OR     school 4113530 2146   Woodburn SD 103 411353001731 4541 Wellness, Business and Sports School   Regular School No High 09 12 2021   k_12_total 73 0 363   0 0     3   3                               73 0 363   0 0     3   3                        
657117 OR     school 4104500 2043   Eagle Point SD 9 410450000417 397 Eagle Point High School   Regular School No High 09 12 2021   k_12_total 588 3 354   7 4     3   54                               588 3 354   7 4     3   54                        
657312 OR     school 4106300 2206   Hermiston SD 8 410630001095 1038 West Park Elementary School   Regular School No Elementary KG 05 2021   k_12_total 139 2 351   3 1     2   11                               139 2 351   3 1     2   11                        
657355 OR     school 4106510 2024   Hood River County SD 410651000383 363 Mid Valley Elementary School   Regular School No Elementary KG 05 2021   k_12_total 69 0 351   0 0     0   11                               69 0 351   0 0     0   11                        
656944 OR     school 4102040 2088   Bethel SD 52 410204000623 588 Willamette High School   Regular School No High 09 12 2021   k_12_total 946 35 349   22 41     13   111                               946 35 349   22 41     13   111                        
657001 OR     school 4102840 2191   Central SD 13J 410284001057 1001 Talmadge Middle School   Regular School No Middle 06 08 2021   k_12_total 344 2 349   5 6     4   34                               344 2 349   5 6     4   34                        
657518 OR     school 4108040 2048   Medford SD 549C 410804001829 5205 Kids Unlimited Academy   Regular School Yes Elementary KG 08 2021   k_12_total 104 2 349   3 3     3   16                               104 2 349   3 3     3   16                        
658003 OR     school 4110820 2142   Salem-Keizer SD 24J 411082000547 764 Yoshikai Elementary School   Regular School No Elementary KG 05 2021   k_12_total 82 7 348   2 2     14   17                               82 7 348   2 2     14   17                        
657522 OR     school 4108040 2048   Medford SD 549C 410804000443 422 McLoughlin Middle School   Regular School No Middle 06 08 2021   k_12_total 524 8 347   5 8     5   41                               524 8 347   5 8     5   41                        
657505 OR     school 4108010 2256   McMinnville SD 40 410801001283 1233 Patton Middle School   Regular School No Middle 06 08 2021   k_12_total 418 13 343   12 10     3   14                               418 13 343   12 10     3   14                        
658242 OR     school 4113530 2146   Woodburn SD 103 411353001723 4543 Woodburn Arts and Communications Academy   Regular School No High 09 12 2021   k_12_total 51 4 338   0 1     2   2                               51 4 338   0 1     2   2                        
657349 OR     school 4100023 2239   Hillsboro SD 1J 410002301202 1151 Witch Hazel Elementary School   Regular School No Elementary KG 06 2021   k_12_total 94 21 335   1 19     0   21                               94 21 335   1 19     0   21                        
656831 OR     school 4101920 2243   Beaverton SD 48J 410192001205 1154 Barnes Elementary School   Regular School No Elementary PK 05 2021   k_12_total 119 25 334   0 12     5   20                               119 25 334   0 12     5   20                        
657334 OR     school 4100023 2239   Hillsboro SD 1J 410002301749 4642 Lincoln Street Elementary School   Regular School No Elementary KG 06 2021   k_12_total 62 5 321   0 1     0   10                               62 5 321   0 1     0   10                        
656885 OR     school 4101920 2243   Beaverton SD 48J 410192001232 1179 William Walker Elementary School   Regular School No Elementary PK 05 2021   k_12_total 96 10 320   1 18     4   25                               96 10 320   1 18     4   25                        
657606 OR     school 4108830 1924   North Clackamas SD 12 410883000093 85 Clackamas High School   Regular School No High 09 12 2021   k_12_total 1378 46 318   6 443     9   195                               1378 46 318   6 443     9   195                        
657636 OR     school 4108880 2141   North Marion SD 15 410888000772 726 North Marion High School   Regular School No High 09 12 2021   k_12_total 275 1 318   1 4     1   23                               275 1 318   1 4     1   23                        
658166 OR     school 4112240 2242   Tigard-Tualatin SD 23J 411224000381 1300 Hazelbrook Middle School   Regular School No Middle 06 08 2021   k_12_total 476 10 318   5 21     23   72                               476 10 318   5 21     23   72                        
657593 OR     school 4108720 2254   Newberg SD 29J 410872001274 1222 Newberg Senior High School   Regular School No High 09 12 2021   k_12_total 1019 16 317   11 28     1   61                               1019 16 317   11 28     1   61                        
656862 OR     school 4101920 2243   Beaverton SD 48J 410192001236 1183 Mountain View Middle School   Regular School No Middle 06 08 2021   k_12_total 343 28 314   4 50     4   57                               343 28 314   4 50     4   57                        
657201 OR     school 4105160 2241   Forest Grove SD 15 410516001182 1128 Cornelius Elementary School   Regular School No Elementary PK 04 2021   k_12_total 39 1 314   1 1     0   1                               39 1 314   1 1     0   1                        
657990 OR     school 4110820 2142   Salem-Keizer SD 24J 411082000819 774 Sprague High School   Regular School No High 09 12 2021   k_12_total 1160 33 314   23 62     27   113                               1160 33 314   23 62     27   113                        
657319 OR     school 4100023 2239   Hillsboro SD 1J 410002301322 1197 Evergreen Jr High School   Regular School No Middle 07 08 2021   k_12_total 317 14 312   2 16     1   55                               317 14 312   2 16     1   55                        
657952 OR     school 4110820 2142   Salem-Keizer SD 24J 411082000784 738 Four Corners Elementary School   Regular School No Elementary KG 05 2021   k_12_total 75 9 312   1 9     17   15                               75 9 312   1 9     17   15                        
658187 OR     school 4112600 2204   Umatilla SD 6R 411260001092 1033 Umatilla High School   Regular School No High 09 12 2021   k_12_total 110 1 310   2 3     0   3                               110 1 310   2 3     0   3                        
657536 OR     school 4108160 2205   Milton-Freewater Unified SD 7 410816001123 1064 McLoughlin High School   Regular School No High 09 12 2021   k_12_total 168 1 308   1 2     1   6                               168 1 308   1 2     1   6                        
657913 OR     school 4110520 2182   Reynolds SD 7 411052001007 954 Hauton B Lee Middle School   Regular School No Middle 06 08 2021   k_12_total 144 145 307   4 106     42   46                               144 145 307   4 106     42   46                        
657956 OR     school 4110820 2142   Salem-Keizer SD 24J 411082001443 3376 Hammond Elementary School   Regular School No Elementary KG 05 2021   k_12_total 126 3 306   1 35     8   20                               126 3 306   1 35     8   20                        
657310 OR     school 4106300 2206   Hermiston SD 8 410630000677 1333 Sandstone Middle School   Regular School No Middle 06 08 2021   k_12_total 234 4 304   3 7     1   11                               234 4 304   3 7     1   11                        
657756 OR     school 4109630 2039   Phoenix-Talent SD 4 410963000394 374 Phoenix High School   Regular School No High 09 12 2021   k_12_total 299 3 304   5 4     2   64                               299 3 304   5 4     2   64                        
657655 OR     school 4100048 4131   North Wasco County SD 21 410004801159 1101 The Dalles High School   Regular School No High 09 12 2021   k_12_total 450 1 303   10 9     13   41                               450 1 303   10 9     13   41                        
656860 OR     school 4101920 2243   Beaverton SD 48J 410192001235 1182 Meadow Park Middle School   Regular School No Middle 06 08 2021   k_12_total 321 20 300   3 124     6   56                               321 20 300   3 124     6   56                        
658232 OR     school 4113530 2146   Woodburn SD 103 411353001714 4540 Academy of International Studies (at Woodburn)   Regular School No High 09 12 2021   k_12_total 15 1 300   1 0     0   5                               15 1 300   1 0     0   5                        
657729 OR     school 4109480 2181   Parkrose SD 3 410948000987 931 Parkrose High School   Regular School No High 09 12 2021   k_12_total 261 159 298   6 157     36   93                               261 159 298   6 157     36   93                        

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