Data source: Big Local News · About: Big Local

20,426 rows where state = "OR" and year = 2020 sorted by asian_int

View and edit SQL

grade

year

  • 2020 · 19,983
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
916640 OR     school 4101020 2113   Adrian SD 61 410102000756 708 Adrian High School   Regular School No High 09 12 2020   k_12_total 70 0 15   1 1     0   2                               70 0 15   1 1     0   2                        
916654 OR     school 4101560 2041   Ashland SD 5 410156000397 377 Helman Elementary School   Regular School No Elementary KG 05 2020   k_12_total 260 2 36   1 1     1   40                               260 2 36   1 1     1   40                        
916660 OR     school 4101620 1933   Astoria SD 1   1933 Astoria SD 1             2020   k_12_total 4 0 0   0 1     0   0                               4 0 0   0 1     0   0                        
916742 OR     school 4101980 1976   Bend-LaPine Administrative SD 1   2916 Bend COIC Dropout Re-engagement Program             2020   k_12_total 70 1 14   2 1     0   1                               70 1 14   2 1     0   1                        
916752 OR     school 4101980 1976   Bend-LaPine Administrative SD 1 410198001487 3218 High Lakes Elementary School   Regular School No Elementary KG 05 2020   k_12_total 470 4 21   0 1     0   28                               470 4 21   0 1     0   28                        
916758 OR     school 4101980 1976   Bend-LaPine Administrative SD 1 410198000262 245 LaPine Elementary School   Regular School No Elementary KG 05 2020   k_12_total 335 1 26   3 1     0   11                               335 1 26   3 1     0   11                        
916762 OR     school 4101980 1976   Bend-LaPine Administrative SD 1 410198000688 1338 Marshall High School   Alternative School No High 09 12 2020   k_12_total 94 2 18   4 1     0   5                               94 2 18   4 1     0   5                        
916781 OR     school 4102040 2088   Bethel SD 52   2088 Bethel SD 52             2020   k_12_total 12 0 9   0 1     0   1                               12 0 9   0 1     0   1                        
916787 OR     school 4102040 2088   Bethel SD 52 410204000619 585 Irving Elementary School   Regular School No Elementary KG 05 2020   k_12_total 252 5 29   4 1     0   35                               252 5 29   4 1     0   35                        
916792 OR     school 4102040 2088   Bethel SD 52 410204000620 586 Malabon Elementary School   Regular School No Elementary KG 05 2020   k_12_total 255 3 113   3 1     2   44                               255 3 113   3 1     2   44                        
916803 OR     school 4102310 1974   Brookings-Harbor SD 17C 410231000255 237 Brookings-Harbor High School   Regular School No High 09 12 2020   k_12_total 282 7 75   20 1     0   92                               282 7 75   20 1     0   92                        
916806 OR     school 4102580 2046   Butte Falls SD 91 410258000426 406 Butte Falls Charter School   Regular School Yes Other KG 12 2020   k_12_total 195 1 23   1 1     0   7                               195 1 23   1 1     0   7                        
916831 OR     school 4102800 2185   Centennial SD 28J   5268 Open School East             2020   k_12_total 57 26 31   1 1     1   17                               57 26 31   1 1     1   17                        
916840 OR     school 4102940 2042   Central Point SD 6 410294000402 382 Central Point Elementary School   Regular School No Elementary KG 05 2020   k_12_total 412 2 84   7 1     2   44                               412 2 84   7 1     2   44                        
916861 OR     school 4103270 1927   Colton SD 53 410327001343 1248 Colton Middle School   Regular School No Middle 06 08 2020   k_12_total 125 0 10   0 1     0   7                               125 0 10   0 1     0   7                        
916877 OR     school 4103390 1964   Coquille SD 8 410339001804 4857 Winter Lakes School   Alternative School No Other 03 12 2020   k_12_total 279 0 30   16 1     1   34                               279 0 30   16 1     1   34                        
916890 OR     school 4103480 1901   Corvallis SD 509J 410348000043 36 Lincoln Elementary School   Regular School No Elementary KG 05 2020   k_12_total 231 4 109   5 1     1   25                               231 4 109   5 1     1   25                        
916903 OR     school 4103720 1970   Crook County SD 410372000243 224 Crook County Middle School   Regular School No Middle 06 08 2020   k_12_total 524 1 121   2 1     0   25                               524 1 121   2 1     0   25                        
916910 OR     school 4103780 2089   Crow-Applegate-Lorane SD 66 410378000624 589 Applegate Elementary School   Regular School No Elementary KG 06 2020   k_12_total 125 0 1   0 1     0   12                               125 0 1   0 1     0   12                        
916918 OR     school 4103860 2190   Dallas SD 2 410386001049 994 LaCreole Middle School   Regular School No Middle 06 08 2020   k_12_total 543 5 86   25 1     2   38                               543 5 86   25 1     2   38                        
916922 OR     school 4103860 2190   Dallas SD 2   1260 Polk ADTC             2020   k_12_total 13 0 2   0 1     0   0                               13 0 2   0 1     0   0                        
916923 OR     school 4103860 2190   Dallas SD 2 410386001047 993 Whitworth Elementary School   Regular School No Elementary 04 05 2020   k_12_total 332 1 57   7 1     1   25                               332 1 57   7 1     1   25                        
916950 OR     school 4110710 1991   Douglas County SD 4 411071000288 269 Eastwood Elementary School   Regular School No Elementary KG 05 2020   k_12_total 330 0 45   2 1     0   25                               330 0 45   2 1     0   25                        
916957 OR     school 4110710 1991   Douglas County SD 4 411071000293 274 Melrose Elementary School   Regular School No Elementary KG 05 2020   k_12_total 288 0 32   4 1     0   19                               288 0 32   4 1     0   19                        
916966 OR     school 4104410 2229   Dufur SD 29 410441001162 3402 Dufur School   Regular School No Other KG 12 2020   k_12_total 264 0 26   24 1     0   27                               264 0 26   24 1     0   27                        
916967 OR     school 4104500 2043   Eagle Point SD 9 410450001831 5251 Crater Lake Charter Academy   Regular School Yes Other KG 12 2020   k_12_total 267 0 40   2 1     3   6                               267 0 40   2 1     3   6                        
916973 OR     school 4104500 2043   Eagle Point SD 9 410450001416 3147 Lake Creek Learning Center   Regular School No Elementary KG 05 2020   k_12_total 55 0 7   0 1     0   5                               55 0 7   0 1     0   5                        
916974 OR     school 4104500 2043   Eagle Point SD 9 410450000413 393 Shady Cove School   Regular School No Elementary KG 08 2020   k_12_total 202 0 22   3 1     0   10                               202 0 22   3 1     0   10                        
917006 OR     school 4104740 2082   Eugene SD 4J 410474000567 537 Eugene Education Options   Alternative School No High 09 12 2020   k_12_total 55 3 26   2 1     0   12                               55 3 26   2 1     0   12                        
917007 OR     school 4104740 2082   Eugene SD 4J   2082 Eugene SD 4J             2020   k_12_total 108 3 18   4 1     0   16                               108 3 18   4 1     0   16                        
917020 OR     school 4104740 2082   Eugene SD 4J 410474001593 4041 Network Charter School   Regular School Yes High 07 12 2020   k_12_total 74 1 11   2 1     0   13                               74 1 11   2 1     0   13                        
917035 OR     school 4104740 2082   Eugene SD 4J 410474001848 1861 Twin Rivers Charter School   Regular School Yes High 08 12 2020   k_12_total 35 1 2   1 1     0   3                               35 1 2   1 1     0   3                        
917036 OR     school 4104740 2082   Eugene SD 4J 410474001492 3229 Village School   Regular School Yes Elementary KG 08 2020   k_12_total 166 1 25   4 1     0   23                               166 1 25   4 1     0   23                        
917049 OR     school 4104950 2084   Fern Ridge SD 28J 410495000599 566 Veneta Elementary School   Regular School No Elementary KG 05 2020   k_12_total 312 1 40   1 1     2   8                               312 1 40   1 1     2   8                        
917052 OR     school 4105160 2241   Forest Grove SD 15 410516001182 1128 Cornelius Elementary School   Regular School No Elementary PK 04 2020   k_12_total 37 0 326   0 1     0   3                               37 0 326   0 1     0   3                        
917070 OR     school 4100015 2137   Gervais SD 1 410001500821 776 Gervais Elementary School   Regular School No Elementary KG 05 2020   k_12_total 102 1 298   1 1     0   9                               102 1 298   1 1     0   9                        
917072 OR     school 4100015 2137   Gervais SD 1 410001500831 786 Gervais Middle School   Regular School No Middle 06 08 2020   k_12_total 74 0 168   0 1     0   2                               74 0 168   0 1     0   2                        
917075 OR     school 4105610 1931   Gladstone SD 115 410561001774 4719 Gladstone Center for Children and Families   Regular School No Elementary PK KG 2020   k_12_total 100 3 20   1 1     1   23                               100 3 20   1 1     1   23                        
917084 OR     school 4105670 1992   Glide SD 12 410567000305 285 Glide High School   Regular School No High 09 12 2020   k_12_total 180 0 15   3 1     1   12                               180 0 15   3 1     1   12                        
917085 OR     school 4105670 1992   Glide SD 12 410567000303 284 Glide Middle School   Regular School No Middle 07 08 2020   k_12_total 106 0 7   3 1     0   7                               106 0 7   3 1     0   7                        
917088 OR     school 4105910 2054   Grants Pass SD 7   2054 Grants Pass SD 7             2020   k_12_total 68 0 24   0 1     0   8                               68 0 24   0 1     0   8                        
917094 OR     school 4105910 2054   Grants Pass SD 7 410591000462 440 Riverside Elementary School   Regular School No Elementary KG 05 2020   k_12_total 307 1 66   6 1     0   45                               307 1 66   6 1     0   45                        
917097 OR     school 4101120 2100   Greater Albany Public SD 8J 410112000732 632 Calapooia Middle School   Regular School No Middle 06 08 2020   k_12_total 436 5 205   13 1     1   41                               436 5 205   13 1     1   41                        
917127 OR     school 4106000 2183   Gresham-Barlow SD 10J   2183 Gresham-Barlow SD 10J             2020   k_12_total 32 3 8   3 1     0   5                               32 3 8   3 1     0   5                        
917150 OR     school 4106120 2114   Harper SD 66 410612000758 3362 Harper Charter School   Regular School Yes Other KG 12 2020   k_12_total 91 0 17   0 1     0   6                               91 0 17   0 1     0   6                        
917151 OR     school 4100019 2099   Harrisburg SD 7J 410001900698 659 Harrisburg Elementary School   Regular School No Elementary KG 06 2020   k_12_total 346 1 53   4 1     2   21                               346 1 53   4 1     2   21                        
917176 OR     school 4100023 2239   Hillsboro SD 1J 410002301824 4973 Hillsboro Online Academy   Regular School No Other KG 12 2020   k_12_total 109 1 20   3 1     2   19                               109 1 20   3 1     2   19                        
917201 OR     school 4106510 2024   Hood River County SD 410651000389 3372 Cascade Locks School   Regular School No Elementary KG 05 2020   k_12_total 42 0 12   5 1     0   8                               42 0 12   5 1     0   8                        
917221 OR     school 4106740 2053   Jefferson County SD 509J 410674000452 431 Metolius Elementary School   Regular School No Elementary KG 05 2020   k_12_total 117 1 129   30 1     0   10                               117 1 129   30 1     0   10                        
917224 OR     school 4106710 2140   Jefferson SD 14J 410671000770 723 Jefferson High School   Regular School No High 09 12 2020   k_12_total 183 0 64   0 1     1   12                               183 0 64   0 1     1   12                        
917227 OR     school 4106780 2008   John Day SD 3 410678000350 331 Grant Union Junior/Senior High School   Regular School No High 07 12 2020   k_12_total 256 1 7   3 1     1   3                               256 1 7   3 1     1   3                        
917228 OR     school 4106780 2008   John Day SD 3 410678000347 327 Humbolt Elementary School   Regular School No Elementary KG 06 2020   k_12_total 263 2 17   0 1     0   18                               263 2 17   0 1     0   18                        
917249 OR     school 4107020 2057   Klamath County SD 410702000508 483 Chiloquin High School   Regular School No High 07 12 2020   k_12_total 49 0 5   50 1     0   16                               49 0 5   50 1     0   16                        
917255 OR     school 4107020 2057   Klamath County SD 410702000498 473 Henley Elementary School   Regular School No Elementary KG 06 2020   k_12_total 421 2 77   14 1     0   41                               421 2 77   14 1     0   41                        
917258 OR     school 4107020 2057   Klamath County SD 410702000499 474 Keno Elementary School   Regular School No Elementary KG 06 2020   k_12_total 171 0 24   2 1     0   23                               171 0 24   2 1     0   23                        
917267 OR     school 4107020 2057   Klamath County SD 410702000504 479 Stearns Elementary School   Regular School No Elementary KG 06 2020   k_12_total 163 4 126   21 1     1   20                               163 4 126   21 1     1   20                        
917268 OR     school 4107080 2056   Klamath Falls City Schools 410708001687 4545 EagleRidge High School   Regular School Yes High 09 12 2020   k_12_total 126 3 24   8 1     1   20                               126 3 24   8 1     1   20                        
917279 OR     school 4100040 2262   Knappa SD 4 410004000179 169 Knappa High School   Regular School No High 09 12 2020   k_12_total 115 0 17   2 1     2   5                               115 0 17   2 1     2   5                        
917287 OR     school 4107280 2059   Lake County SD 7 410728000689 491 Daly Middle School   Regular School No Middle 07 08 2020   k_12_total 78 0 31   4 1     0   6                               78 0 31   4 1     0   6                        
917305 OR     school 4107380 2101   Lebanon Community SD 9 410738000682 652 Cascades School   Regular School No Elementary KG 06 2020   k_12_total 255 0 32   3 1     2   18                               255 0 32   3 1     2   18                        
917308 OR     school 4107380 2101   Lebanon Community SD 9 410738000710 671 Lacomb School   Regular School No Elementary KG 08 2020   k_12_total 197 1 19   6 1     1   19                               197 1 19   6 1     1   19                        
917314 OR     school 4107380 2101   Lebanon Community SD 9 410738000714 674 Seven Oak Middle School   Regular School No Middle 06 08 2020   k_12_total 525 1 63   4 1     3   49                               525 1 63   4 1     3   49                        
917315 OR     school 4107500 2097   Lincoln County SD 410750000657 623 Crestview Heights School   Regular School No Elementary KG 06 2020   k_12_total 252 1 35   2 1     1   42                               252 1 35   2 1     1   42                        
917338 OR     school 4107590 2092   Lowell SD 71 410759001846 5349 Bridge Charter Academy   Regular School Yes Other KG 12 2020   k_12_total 321 1 29   0 1     0   15                               321 1 29   0 1     0   15                        
917350 OR     school 4108010 2256   McMinnville SD 40 410801001279 1228 Columbus Elementary School   Regular School No Elementary KG 05 2020   k_12_total 274 4 188   8 1     5   9                               274 4 188   8 1     5   9                        
917357 OR     school 4108010 2256   McMinnville SD 40 410801001752 4639 Sue Buel Elementary   Regular School No Elementary KG 05 2020   k_12_total 228 1 215   2 1     7   5                               228 1 215   2 1     7   5                        
917365 OR     school 4108040 2048   Medford SD 549C 410804000431 411 Jackson Elementary School   Regular School No Elementary KG 06 2020   k_12_total 156 4 208   6 1     3   19                               156 4 208   6 1     3   19                        
917367 OR     school 4108040 2048   Medford SD 549C 410804000433 413 Jefferson Elementary School   Regular School No Elementary KG 06 2020   k_12_total 270 1 174   2 1     0   23                               270 1 174   2 1     0   23                        
917384 OR     school 4108160 2205   Milton-Freewater Unified SD 7 410816001842 5296 Ferndale Elementary School   Regular School No Elementary 04 05 2020   k_12_total 100 2 163   0 1     0   2                               100 2 163   0 1     0   2                        
917386 OR     school 4108160 2205   Milton-Freewater Unified SD 7 410816001123 1064 McLoughlin High School   Regular School No High 09 12 2020   k_12_total 178 1 299   1 1     1   8                               178 1 299   1 1     1   8                        
917388 OR     school 4108280 2249   Mitchell SD 55 410828001864 5441 Destinations Career Academy of Oregon   Regular School Yes High 09 12 2020   k_12_total 59 2 11   0 1     0   6                               59 2 11   0 1     0   6                        
917402 OR     school 4108460 2010   Monument SD 8 410846000356 3350 Monument School   Regular School No Other KG 12 2020   k_12_total 39 0 7   6 1     0   0                               39 0 7   6 1     0   0                        
917404 OR     school 4108520 2147   Morrow SD 1 410852000859 815 Heppner Elementary School   Regular School No Elementary KG 06 2020   k_12_total 152 0 21   1 1     0   3                               152 0 21   1 1     0   3                        
917411 OR     school 4108520 2147   Morrow SD 1 410852001311 814 Sam Boardman Elementary School   Regular School No Elementary KG 03 2020   k_12_total 86 1 249   2 1     1   3                               86 1 249   2 1     1   3                        
917412 OR     school 4108520 2147   Morrow SD 1 410852001597 4047 Windy River Elementary School   Regular School No Middle 04 06 2020   k_12_total 56 0 210   0 1     0   2                               56 0 210   0 1     0   2                        
917413 OR     school 4108550 2145   Mt Angel SD 91 410855000839 794 John F Kennedy High School   Regular School No High 09 12 2020   k_12_total 95 3 96   2 1     0   8                               95 3 96   2 1     0   8                        
917414 OR     school 4108550 2145   Mt Angel SD 91 410855000837 792 Mt Angel Middle School   Regular School No Middle 06 08 2020   k_12_total 101 1 74   0 1     0   3                               101 1 74   0 1     0   3                        
917418 OR     school 4180180 2148   Multnomah ESD   953 Kerr Youth Center/Wynne Watts School             2020   k_12_total 15 2 0   3 1     0   0                               15 2 0   3 1     0   0                        
917431 OR     school 4108700 2199   Nestucca Valley SD 101J 410870001082 1023 Nestucca High School   Regular School No High 07 12 2020   k_12_total 152 3 54   3 1     0   9                               152 3 54   3 1     0   9                        
917436 OR     school 4108720 2254   Newberg SD 29J 410872001270 1217 Edwards Elementary School   Regular School No Elementary KG 05 2020   k_12_total 294 6 218   6 1     1   26                               294 6 218   6 1     1   26                        
917437 OR     school 4108720 2254   Newberg SD 29J 410872001271 1218 Ewing Young Elementary School   Regular School No Elementary KG 05 2020   k_12_total 173 1 19   1 1     0   11                               173 1 19   1 1     0   11                        
917468 OR     school 4108830 1924   North Clackamas SD 12   1924 North Clackamas SD 12             2020   k_12_total 37 3 7   1 1     0   0                               37 3 7   1 1     0   0                        
917482 OR     school 4104350 1996   North Douglas SD 22 410435000316 296 North Douglas Elementary School   Regular School No Elementary KG 08 2020   k_12_total 180 0 22   2 1     0   20                               180 0 22   2 1     0   20                        
917483 OR     school 4104350 1996   North Douglas SD 22 410435000317 297 North Douglas High School   Regular School No High 09 12 2020   k_12_total 77 1 7   4 1     0   4                               77 1 7   4 1     0   4                        
917484 OR     school 4111400 2061   North Lake SD 14 411140001381 1289 North Lake School   Regular School No Other KG 12 2020   k_12_total 181 1 21   2 1     1   17                               181 1 21   2 1     1   17                        
917491 OR     school 4100020 2143   North Santiam SD 29J 410002000833 788 Stayton Elementary School   Regular School No Elementary KG 03 2020   k_12_total 267 3 82   0 1     1   23                               267 3 82   0 1     1   23                        
917496 OR     school 4100048 4131   North Wasco County SD 21 410004801155 1097 Colonel Wright Elementary School   Regular School No Elementary KG 05 2020   k_12_total 160 3 140   4 1     4   12                               160 3 140   4 1     4   12                        
917498 OR     school 4100048 4131   North Wasco County SD 21 410004801156 1098 Dry Hollow Elementary School   Regular School No Elementary KG 05 2020   k_12_total 256 1 144   8 1     7   30                               256 1 144   8 1     7   30                        
917504 OR     school   2230   Northwest Regional ESD   1167 Levi Anderson Learning Center             2020   k_12_total 43 5 6   4 1     0   4                               43 5 6   4 1     0   4                        
917506 OR     school   2230   Northwest Regional ESD   2230 Northwest Regional ESD             2020   k_12_total 113 8 20   2 1     0   9                               113 8 20   2 1     0   9                        
917512 OR     school 4109120 1990   Oakland SD 1 410912000287 268 Oakland High School   Regular School No High 09 12 2020   k_12_total 197 1 16   7 1     0   3                               197 1 16   7 1     0   3                        
917517 OR     school   3476   ODE JDEP District   2848 Donald E Long School             2020   k_12_total 19 11 14   2 1     1   2                               19 11 14   2 1     1   2                        
917528 OR     school 4100043 3477   ODE YCEP District 410004301404 2258 Monroe School   Regular School No High 06 12 2020   k_12_total 5 3 5   3 1     1   0                               5 3 5   3 1     1   0                        
917534 OR     school 4100043 3477   ODE YCEP District 410004301740 4588 Trask River High School   Regular School No High 06 12 2020   k_12_total 15 0 4   0 1     2   2                               15 0 4   0 1     2   2                        
917535 OR     school 4100043 3477   ODE YCEP District 410004300494 1828 William P Lord High School   Regular School No High 06 12 2020   k_12_total 62 28 38   8 1     3   11                               62 28 38   8 1     3   11                        
917537 OR     school 4109270 2108   Ontario SD 8C 410927000739 692 Alameda Elementary School   Regular School No Elementary KG 06 2020   k_12_total 152 2 231   1 1     0   10                               152 2 231   1 1     0   10                        
917540 OR     school 4109270 2108   Ontario SD 8C 410927000746 699 Ontario High School   Regular School No High 09 12 2020   k_12_total 207 5 426   2 1     1   10                               207 5 426   2 1     1   10                        
917543 OR     school 4109270 2108   Ontario SD 8C 410927000744 697 Pioneer Elementary School   Regular School No Elementary KG 05 2020   k_12_total 50 6 54   0 1     0   4                               50 6 54   0 1     0   4                        
917551 OR     school 4109330 1928   Oregon City SD 62 410933000117 110 Jennings Lodge Elementary School   Regular School No Elementary KG 02 2020   k_12_total 90 2 65   0 1     0   10                               90 2 65   0 1     0   10                        
917558 OR     school 4109330 1928   Oregon City SD 62 410933001642 4480 Springwater Environmental Sciences School   Regular School Yes Elementary KG 08 2020   k_12_total 166 0 16   0 1     0   15                               166 0 16   0 1     0   15                        

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