Data source: Big Local News · About: Big Local

20,594 rows where state = "OR" and year = 2021 sorted by asian_int

View and edit SQL

grade

year

  • 2021 · 20,120
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
656782 OR     school 4101020 2113   Adrian SD 61 410102000756 708 Adrian High School   Regular School No High 09 12 2021   k_12_total 62 0 19   0 1     0   1                               62 0 19   0 1     0   1                        
656797 OR     school 4101560 2041   Ashland SD 5 410156001654 4476 John Muir Outdoor School   Regular School No Elementary KG 08 2021   k_12_total 91 1 7   0 1     0   7                               91 1 7   0 1     0   7                        
656801 OR     school 4101620 1933   Astoria SD 1 410162000153 144 Astoria Middle School   Regular School No Middle 06 08 2021   k_12_total 309 3 99   1 1     6   16                               309 3 99   1 1     6   16                        
656804 OR     school 4101620 1933   Astoria SD 1 410162000156 147 Lewis & Clark Elementary School   Regular School No Elementary 03 05 2021   k_12_total 311 1 84   5 1     4   18                               311 1 84   5 1     4   18                        
656807 OR     school 4101660 2208   Athena-Weston SD 29RJ 410166001115 1056 Weston-McEwen High School   Regular School No High 09 12 2021   k_12_total 157 1 16   15 1     0   18                               157 1 16   15 1     0   18                        
656816 OR     school 4101710 1894   Baker SD 5J 410171001516 3493 EAGLE CAP Innovative HS   Alternative School No High 07 12 2021   k_12_total 120 0 5   3 1     0   9                               120 0 5   3 1     0   9                        
656817 OR     school 4101710 1894   Baker SD 5J 410171000030 4 Haines Elementary School   Regular School No Elementary KG 06 2021   k_12_total 101 0 2   1 1     0   8                               101 0 2   1 1     0   8                        
656819 OR     school 4101710 1894   Baker SD 5J 410171000007 7 South Baker Intermediate School   Regular School No Middle 04 06 2021   k_12_total 238 2 13   6 1     0   15                               238 2 13   6 1     0   15                        
656820 OR     school 4101800 1969   Bandon SD 54 410180000237 218 Bandon Senior High School   Regular School No High 09 12 2021   k_12_total 153 1 26   4 1     0   18                               153 1 26   4 1     0   18                        
656821 OR     school 4101800 1969   Bandon SD 54 410180000235 216 Harbor Lights Middle School   Regular School No Middle 05 08 2021   k_12_total 164 0 32   0 1     0   23                               164 0 32   0 1     0   23                        
656825 OR     school 4101830 2240   Banks SD 13 410183001179 1123 Banks Middle School   Regular School No Middle 06 08 2021   k_12_total 216 1 25   0 1     0   22                               216 1 25   0 1     0   22                        
656896 OR     school 4101980 1976   Bend-LaPine Administrative SD 1 410198001603 4129 Ensworth Elementary School   Regular School No Elementary KG 05 2021   k_12_total 116 1 33   2 1     0   11                               116 1 33   2 1     0   11                        
656904 OR     school 4101980 1976   Bend-LaPine Administrative SD 1 410198000262 245 LaPine Elementary School   Regular School No Elementary KG 05 2021   k_12_total 242 4 16   0 1     0   9                               242 4 16   0 1     0   9                        
656908 OR     school 4101980 1976   Bend-LaPine Administrative SD 1 410198000688 1338 Marshall High School   Alternative School No High 09 12 2021   k_12_total 78 0 18   2 1     0   3                               78 0 18   2 1     0   3                        
656917 OR     school 4101980 1976   Bend-LaPine Administrative SD 1 410198001871 5428 Realms High School   Regular School No High 09 12 2021   k_12_total 121 0 10   1 1     0   3                               121 0 10   1 1     0   3                        
656922 OR     school 4101980 1976   Bend-LaPine Administrative SD 1 410198001866 5429 Skyline High School   Regular School No High 09 12 2021   k_12_total 125 1 11   1 1     0   7                               125 1 11   1 1     0   7                        
656933 OR     school 4102040 2088   Bethel SD 52 410204000619 585 Irving Elementary School   Regular School No Elementary KG 05 2021   k_12_total 218 5 25   5 1     0   25                               218 5 25   5 1     0   25                        
656948 OR     school 4102310 1974   Brookings-Harbor SD 17C 410231000255 237 Brookings-Harbor High School   Regular School No High 09 12 2021   k_12_total 290 6 80   15 1     0   93                               290 6 80   15 1     0   93                        
656957 OR     school 4102640 1929   Canby SD 86 410264000165 1307 Cecile Trost Elementary School   Regular School No Elementary KG 06 2021   k_12_total 115 2 286   0 1     0   3                               115 2 286   0 1     0   3                        
656960 OR     school 4102640 1929   Canby SD 86 410264001659 4435 Philander Lee Elementary School   Regular School No Elementary KG 06 2021   k_12_total 200 1 110   0 1     0   19                               200 1 110   0 1     0   19                        
656967 OR     school 4102780 2139   Cascade SD 5 410278000851 806 Cloverdale Elementary School   Regular School No Elementary KG 05 2021   k_12_total 138 0 17   2 1     0   3                               138 0 17   2 1     0   3                        
656981 OR     school 4105760 1972   Central Curry SD 1 410576000257 239 Gold Beach High School   Regular School No High 09 12 2021   k_12_total 104 0 15   2 1     0   16                               104 0 15   2 1     0   16                        
656982 OR     school 4105760 1972   Central Curry SD 1 410576000249 231 Riley Creek Elementary School   Regular School No Elementary KG 08 2021   k_12_total 221 2 39   2 1     0   31                               221 2 39   2 1     0   31                        
656983 OR     school 4102910 2105   Central Linn SD 552 410291000475 1311 Central Linn Elementary School   Regular School No Elementary KG 06 2021   k_12_total 154 0 26   3 1     0   8                               154 0 26   3 1     0   8                        
656986 OR     school 4102940 2042   Central Point SD 6 410294000402 382 Central Point Elementary School   Regular School No Elementary KG 05 2021   k_12_total 392 5 88   4 1     6   40                               392 5 88   4 1     6   40                        
656997 OR     school 4102840 2191   Central SD 13J 410284001461 3464 Ash Creek Elementary School   Regular School No Elementary KG 05 2021   k_12_total 196 1 254   3 1     0   29                               196 1 254   3 1     0   29                        
657004 OR     school 4103260 1945   Clatskanie SD 6J 410326000178 168 Clatskanie Middle/High School   Regular School No High 07 12 2021   k_12_total 218 1 31   7 1     0   26                               218 1 31   7 1     0   26                        
657008 OR     school 4103270 1927   Colton SD 53 410327001343 1248 Colton Middle School   Regular School No Middle 06 08 2021   k_12_total 115 1 11   0 1     0   8                               115 1 11   0 1     0   8                        
657011 OR     school 4103660 1965   Coos Bay SD 9   1965 Coos Bay SD 9             2021   k_12_total 33 0 5   1 1     0   4                               33 0 5   1 1     0   4                        
657013 OR     school 4103660 1965   Coos Bay SD 9 410366000204 192 Eastside School   Regular School No Elementary KG 02 2021   k_12_total 280 3 35   6 1     1   24                               280 3 35   6 1     1   24                        
657014 OR     school 4103660 1965   Coos Bay SD 9 410366004188 3615 Lighthouse Charter School   Regular School Yes Elementary KG 08 2021   k_12_total 170 0 13   4 1     0   27                               170 0 13   4 1     0   27                        
657039 OR     school 4103480 1901   Corvallis SD 509J 410348000043 36 Lincoln Elementary School   Regular School No Elementary KG 05 2021   k_12_total 197 5 94   1 1     4   16                               197 5 94   1 1     4   16                        
657041 OR     school 4103480 1901   Corvallis SD 509J 410348000044 37 Mt View Elementary School   Regular School No Elementary KG 05 2021   k_12_total 182 2 11   0 1     2   17                               182 2 11   0 1     2   17                        
657044 OR     school 4103540 2216   Cove SD 15 410354001139 3434 Cove Charter School   Regular School Yes Other KG 12 2021   k_12_total 224 3 14   0 1     0   10                               224 3 14   0 1     0   10                        
657047 OR     school 4103690 2086   Creswell SD 40 410369000605 571 Creswell Middle School   Regular School No Middle 06 08 2021   k_12_total 206 2 48   5 1     0   22                               206 2 48   5 1     0   22                        
657052 OR     school 4103720 1970   Crook County SD 410372000243 224 Crook County Middle School   Regular School No Middle 06 08 2021   k_12_total 452 3 99   2 1     0   30                               452 3 99   2 1     0   30                        
657053 OR     school 4103720 1970   Crook County SD   1970 Crook County SD             2021   k_12_total 353 6 68   11 1     0   32                               353 6 68   11 1     0   32                        
657060 OR     school 4103780 2089   Crow-Applegate-Lorane SD 66 410378000624 589 Applegate Elementary School   Regular School No Elementary KG 06 2021   k_12_total 118 0 1   0 1     0   11                               118 0 1   0 1     0   11                        
657061 OR     school 4103780 2089   Crow-Applegate-Lorane SD 66 410378000627 592 Crow Middle/High School   Regular School No High 07 12 2021   k_12_total 97 0 7   2 1     0   10                               97 0 7   2 1     0   10                        
657068 OR     school 4103860 2190   Dallas SD 2 410386001049 994 LaCreole Middle School   Regular School No Middle 06 08 2021   k_12_total 486 4 80   25 1     3   34                               486 4 80   25 1     3   34                        
657069 OR     school 4103860 2190   Dallas SD 2 410386001045 3461 Luckiamute Valley Charter School   Regular School Yes Elementary KG 08 2021   k_12_total 163 1 15   4 1     2   7                               163 1 15   4 1     2   7                        
657093 OR     school 4103990 2253   Dayton SD 8 410399000228 1291 Dayton Jr High School   Regular School No Middle 06 08 2021   k_12_total 131 0 99   4 1     0   8                               131 0 99   4 1     0   8                        
657099 OR     school 4110710 1991   Douglas County SD 4 411071000288 269 Eastwood Elementary School   Regular School No Elementary PK 05 2021   k_12_total 289 0 52   3 1     0   25                               289 0 52   3 1     0   25                        
657102 OR     school 4110710 1991   Douglas County SD 4 411071000291 272 Green Elementary School   Regular School No Elementary PK 05 2021   k_12_total 223 3 31   0 1     0   17                               223 3 31   0 1     0   17                        
657116 OR     school 4104500 2043   Eagle Point SD 9 410450001831 5251 Crater Lake Academy   Regular School Yes Other KG 12 2021   k_12_total 279 0 37   1 1     1   12                               279 0 37   1 1     1   12                        
657120 OR     school 4104500 2043   Eagle Point SD 9 410450001586 4020 Eagle Rock Elementary School   Regular School No Elementary KG 05 2021   k_12_total 198 1 36   1 1     0   12                               198 1 36   1 1     0   12                        
657123 OR     school 4104500 2043   Eagle Point SD 9 410450001416 3147 Lake Creek Learning Center   Regular School No Elementary KG 05 2021   k_12_total 36 0 5   0 1     0   3                               36 0 5   0 1     0   3                        
657124 OR     school 4104500 2043   Eagle Point SD 9 410450000413 393 Shady Cove School   Regular School No Elementary KG 08 2021   k_12_total 203 0 21   2 1     0   10                               203 0 21   2 1     0   10                        
657127 OR     school 4104500 2043   Eagle Point SD 9 410450001587 4021 White Mountain Middle School   Regular School No Middle 06 08 2021   k_12_total 136 1 200   2 1     1   11                               136 1 200   2 1     1   11                        
657128 OR     school 4104530 2203   Echo SD 5 410453001089 3433 Echo School   Regular School No Other PK 12 2021   k_12_total 234 2 40   2 1     0   11                               234 2 40   2 1     0   11                        
657129 OR     school 4104590 2217   Elgin SD 23 410459001141 1083 Elgin High School   Regular School No High 07 12 2021   k_12_total 169 0 9   0 1     0   5                               169 0 9   0 1     0   5                        
657132 OR     school 4105080 2221   Enterprise SD 21 410508001148 1090 Enterprise Elementary School   Regular School No Elementary KG 06 2021   k_12_total 164 0 7   0 1     0   7                               164 0 7   0 1     0   7                        
657157 OR     school 4104740 2082   Eugene SD 4J   2082 Eugene SD 4J             2021   k_12_total 128 2 21   2 1     0   27                               128 2 21   2 1     0   27                        
657168 OR     school 4104740 2082   Eugene SD 4J 410474000548 522 McCornack Elementary School   Regular School No Elementary KG 05 2021   k_12_total 175 7 69   8 1     2   40                               175 7 69   8 1     2   40                        
657170 OR     school 4104740 2082   Eugene SD 4J 410474001593 4041 Network Charter School   Regular School Yes High 07 12 2021   k_12_total 88 0 10   1 1     0   15                               88 0 10   1 1     0   15                        
657174 OR     school 4104740 2082   Eugene SD 4J 410474001491 3233 Ridgeline Montessori   Regular School Yes Elementary KG 08 2021   k_12_total 199 1 9   2 1     2   27                               199 1 9   2 1     2   27                        
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                        
657202 OR     school 4105160 2241   Forest Grove SD 15   1884 CREATE             2021   k_12_total 2 0 10   0 1     0   0                               2 0 10   0 1     0   0                        
657206 OR     school 4105160 2241   Forest Grove SD 15 410516001724 4595 Forest Grove Community School   Regular School Yes Elementary 01 08 2021   k_12_total 138 1 27   1 1     2   33                               138 1 27   1 1     2   33                        
657210 OR     school 4105160 2241   Forest Grove SD 15 410516001187 1133 Joseph Gale Elementary School   Regular School No Elementary KG 04 2021   k_12_total 187 5 199   5 1     2   12                               187 5 199   5 1     2   12                        
657223 OR     school 4100015 2137   Gervais SD 1 410001500831 786 Gervais Middle School   Regular School No Middle 06 08 2021   k_12_total 52 0 156   1 1     0   2                               52 0 156   1 1     0   2                        
657236 OR     school 4105910 2054   Grants Pass SD 7 410591000457 435 Allen Dale Elementary School   Regular School No Elementary KG 05 2021   k_12_total 267 0 29   1 1     0   23                               267 0 29   1 1     0   23                        
657243 OR     school 4105910 2054   Grants Pass SD 7 410591000461 439 Redwood Elementary School   Regular School No Elementary KG 05 2021   k_12_total 256 1 66   2 1     1   33                               256 1 66   2 1     1   33                        
657244 OR     school 4105910 2054   Grants Pass SD 7 410591000462 440 Riverside Elementary School   Regular School No Elementary KG 05 2021   k_12_total 228 1 47   5 1     0   31                               228 1 47   5 1     0   31                        
657245 OR     school 4105910 2054   Grants Pass SD 7 410591000463 441 South Middle School   Regular School No Middle 06 08 2021   k_12_total 507 4 73   9 1     1   43                               507 4 73   9 1     1   43                        
657276 OR     school 4106000 2183   Gresham-Barlow SD 10J   2183 Gresham-Barlow SD 10J             2021   k_12_total 23 0 9   1 1     0   3                               23 0 9   1 1     0   3                        
657300 OR     school 4100019 2099   Harrisburg SD 7J 410001900698 659 Harrisburg Elementary School   Regular School No Elementary KG 04 2021   k_12_total 194 1 39   2 1     0   12                               194 1 39   2 1     0   12                        
657302 OR     school 4100019 2099   Harrisburg SD 7J 410001901422 2723 Harrisburg Middle School   Regular School No Middle 05 08 2021   k_12_total 179 0 27   1 1     2   12                               179 0 27   1 1     2   12                        
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                        
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                        
657369 OR     school 4106740 2053   Jefferson County SD 509J 410674000451 430 Madras Elementary School   Regular School No Elementary KG 05 2021   k_12_total 137 1 151   33 1     0   12                               137 1 151   33 1     0   12                        
657371 OR     school 4106740 2053   Jefferson County SD 509J 410674000452 431 Metolius Elementary School   Regular School No Elementary KG 05 2021   k_12_total 100 2 128   24 1     0   7                               100 2 128   24 1     0   7                        
657374 OR     school 4106710 2140   Jefferson SD 14J 410671000770 723 Jefferson High School   Regular School No High 09 12 2021   k_12_total 172 0 69   1 1     2   10                               172 0 69   1 1     2   10                        
657377 OR     school 4106780 2008   John Day SD 3 410678000350 331 Grant Union Junior/Senior High School   Regular School No High 07 12 2021   k_12_total 228 2 9   2 1     0   2                               228 2 9   2 1     0   2                        
657378 OR     school 4106780 2008   John Day SD 3 410678000347 327 Humbolt Elementary School   Regular School No Elementary KG 06 2021   k_12_total 250 1 15   0 1     0   9                               250 1 15   0 1     0   9                        
657384 OR     school 4106870 2219   Joseph SD 6 410687001145 1087 Joseph Charter School   Regular School Yes Other KG 12 2021   k_12_total 229 1 12   0 1     0   20                               229 1 12   0 1     0   20                        
657396 OR     school 4107020 2057   Klamath County SD 410702000505 480 Brixner Junior High School   Regular School No Middle 07 08 2021   k_12_total 251 1 102   16 1     3   32                               251 1 102   16 1     3   32                        
657398 OR     school 4107020 2057   Klamath County SD 410702000508 483 Chiloquin High School   Regular School No High 07 12 2021   k_12_total 63 0 8   57 1     0   14                               63 0 8   57 1     0   14                        
657404 OR     school 4107020 2057   Klamath County SD 410702000498 473 Henley Elementary School   Regular School No Elementary KG 06 2021   k_12_total 351 3 78   14 1     2   40                               351 3 78   14 1     2   40                        
657407 OR     school 4107020 2057   Klamath County SD 410702000499 474 Keno Elementary School   Regular School No Elementary KG 06 2021   k_12_total 140 0 17   3 1     0   11                               140 0 17   3 1     0   11                        
657421 OR     school 4107080 2056   Klamath Falls City Schools 410708001847 5355 Klamath Learning Center   Alternative School No Other KG 12 2021   k_12_total 205 5 68   17 1     0   24                               205 5 68   17 1     0   24                        
657423 OR     school 4107080 2056   Klamath Falls City Schools 410708000485 461 Mills Elementary School   Regular School No Elementary KG 05 2021   k_12_total 136 6 128   23 1     0   28                               136 6 128   23 1     0   28                        
657424 OR     school 4107080 2056   Klamath Falls City Schools 410708000486 462 Pelican Elementary School   Regular School No Elementary KG 05 2021   k_12_total 162 2 47   11 1     1   20                               162 2 47   11 1     1   20                        
657427 OR     school 4100040 2262   Knappa SD 4 410004000176 166 Hilda Lahti Elementary School   Regular School No Elementary KG 08 2021   k_12_total 304 1 23   4 1     0   15                               304 1 23   4 1     0   15                        
657431 OR     school 4107200 2212   La Grande SD 1 410720001128 1069 Island City Elementary School   Regular School No Elementary KG 05 2021   k_12_total 205 1 18   0 1     3   14                               205 1 18   0 1     3   14                        
657439 OR     school 4107280 2059   Lake County SD 7 410728000519 492 Lakeview Senior High School   Regular School No High 09 12 2021   k_12_total 142 0 40   10 1     0   8                               142 0 40   10 1     0   8                        
657446 OR     school 4107230 1923   Lake Oswego SD 7J   1923 Lake Oswego SD 7J             2021   k_12_total 30 0 5   0 1     0   3                               30 0 5   0 1     0   3                        
657465 OR     school 4107500 2097   Lincoln County SD 410750000657 623 Crestview Heights School   Regular School No Elementary KG 06 2021   k_12_total 177 1 23   3 1     0   33                               177 1 23   3 1     0   33                        
657485 OR     school   2098   Linn Benton Lincoln ESD   5160 Wake Robin School             2021   k_12_total 8 1 2   1 1     0   2                               8 1 2   1 1     0   2                        
657493 OR     school 4107710 2085   Mapleton SD 32 410771000602 568 Mapleton Elementary School   Regular School No Elementary KG 06 2021   k_12_total 52 0 9   1 1     2   6                               52 0 9   1 1     2   6                        
657495 OR     school 4107740 2094   Marcola SD 79J 410774000638 603 Marcola Elementary School   Regular School No Elementary KG 06 2021   k_12_total 101 0 21   1 1     0   9                               101 0 21   1 1     0   9                        
657496 OR     school 4107740 2094   Marcola SD 79J 410774000639 604 Mohawk High School   Regular School No High 07 12 2021   k_12_total 130 0 11   2 1     0   1                               130 0 11   2 1     0   1                        
657499 OR     school 4108010 2256   McMinnville SD 40 410801001279 1228 Columbus Elementary School   Regular School No Elementary KG 05 2021   k_12_total 248 5 171   5 1     3   8                               248 5 171   5 1     3   8                        
657506 OR     school 4108010 2256   McMinnville SD 40 410801001752 4639 Sue Buel Elementary   Regular School No Elementary KG 05 2021   k_12_total 179 1 201   1 1     6   9                               179 1 201   1 1     6   9                        
657509 OR     school 4108040 2048   Medford SD 549C 410804004187 3554 Central Medford High School   Alternative School No High 09 12 2021   k_12_total 221 2 94   5 1     4   21                               221 2 94   5 1     4   21                        
657521 OR     school 4108040 2048   Medford SD 549C 410804001736 4593 Madrone Trail Public Charter School   Regular School Yes Elementary KG 08 2021   k_12_total 193 0 19   1 1     0   16                               193 0 19   1 1     0   16                        
657540 OR     school 4108280 2249   Mitchell SD 55 410828001813 5150 Insight School of Oregon Painted Hills   Regular School Yes High 07 12 2021   k_12_total 251 11 90   6 1     2   38                               251 11 90   6 1     2   38                        
657546 OR     school 4108310 1925   Molalla River SD 35 410831000102 95 Molalla River Middle School   Regular School No Middle 06 08 2021   k_12_total 381 0 116   4 1     3   21                               381 0 116   4 1     3   21                        
657552 OR     school 4108430 1898   Monroe SD 1J 410843000050 43 Monroe High School   Regular School No High 09 12 2021   k_12_total 90 0 29   0 1     0   3                               90 0 29   0 1     0   3                        
657553 OR     school 4108460 2010   Monument SD 8 410846000356 3350 Monument School   Regular School No Other KG 12 2021   k_12_total 39 0 5   6 1     0   0                               39 0 5   6 1     0   0                        

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