Data source: Big Local News · About: Big Local

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

View and edit SQL

grade

year

  • 2021 · 20,594
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
658220 OR     school 4113170 1922   West Linn-Wilsonville SD 3J 411317000574 1323 Wilsonville High School   Regular School No High 09 12 2021   k_12_total 807 12 227   5 53     9   99                               807 12 227   5 53     9   99                        
657172 OR     school 4104740 2082   Eugene SD 4J 410474000571 536 North Eugene High School   Regular School No High 09 12 2021   k_12_total 691 6 180   7 20     3   98                               691 6 180   7 20     3   98                        
657783 OR     school 4110040 2180   Portland SD 1J 411004000956 906 Benson Polytechnic High School   Regular School No High 09 12 2021   k_12_total 440 117 271   6 66     7   98                               440 117 271   6 66     7   98                        
657610 OR     school 4108830 1924   North Clackamas SD 12 410883001782 4715 Happy Valley Middle School   Regular School No Middle 06 08 2021   k_12_total 589 15 96   5 245     5   97                               589 15 96   5 245     5   97                        
657189 OR     school 4104740 2082   Eugene SD 4J 410474001348 1259 Yujin Gakuen Elementary School   Regular School No Elementary KG 05 2021   k_12_total 149 0 30   0 16     1   95                               149 0 30   0 16     1   95                        
657447 OR     school 4107230 1923   Lake Oswego SD 7J 410723000068 61 Lake Oswego Senior High School   Regular School No High 09 12 2021   k_12_total 874 12 106   2 161     1   95                               874 12 106   2 161     1   95                        
657880 OR     school 4110040 2180   Portland SD 1J 411004000954 904 Woodstock Elementary School   Regular School No Elementary KG 05 2021   k_12_total 268 1 31   0 133     1   94                               268 1 31   0 133     1   94                        
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                        
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                        
657622 OR     school 4108830 1924   North Clackamas SD 12 410883000095 87 Putnam High School   Regular School No High 09 12 2021   k_12_total 685 18 289   6 29     6   93                               685 18 289   6 29     6   93                        
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                        
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                        
658039 OR     school 4111290 2244   Sherwood SD 88J 411129001246 1193 Sherwood High School   Regular School No High 09 12 2021   k_12_total 1296 8 166   9 38     11   91                               1296 8 166   9 38     11   91                        
657873 OR     school 4110040 2180   Portland SD 1J 411004000947 898 West Sylvan Middle School   Regular School No Middle 06 08 2021   k_12_total 537 27 71   3 71     1   90                               537 27 71   3 71     1   90                        
656813 OR     school 4101710 1894   Baker SD 5J 410171001879 5604 Baker Virtual Academy   Regular School No Elementary KG 06 2021   k_12_total 74 0 0   0 0     0   9                               74 0 0   0 0     0   9                        
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                        
656899 OR     school 4101980 1976   Bend-LaPine Administrative SD 1 410198001438 3219 Highland School at Kenwood Elementary School   Regular School No Elementary KG 05 2021   k_12_total 335 0 5   0 4     1   9                               335 0 5   0 4     1   9                        
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                        
656918 OR     school 4101980 1976   Bend-LaPine Administrative SD 1 410198001436 3448 Realms Middle School   Regular School No Middle 06 08 2021   k_12_total 130 1 7   0 0     0   9                               130 1 7   0 0     0   9                        
657057 OR     school 4103720 1970   Crook County SD 410372000242 223 Powell Butte Community Charter School   Regular School Yes Elementary KG 08 2021   k_12_total 188 2 8   3 0     0   9                               188 2 8   3 0     0   9                        
657101 OR     school 4110710 1991   Douglas County SD 4 411071000290 271 Fullerton IV Elementary School   Regular School No Elementary KG 05 2021   k_12_total 234 1 37   1 4     1   9                               234 1 37   1 4     1   9                        
657262 OR     school 4101120 2100   Greater Albany Public SD 8J 410112000675 647 Takena Elementary School   Regular School No Elementary KG 02 2021   k_12_total 92 0 10   0 0     0   9                               92 0 10   0 0     0   9                        
657301 OR     school 4100019 2099   Harrisburg SD 7J 410001900731 689 Harrisburg High School   Regular School No High 09 12 2021   k_12_total 197 0 32   1 2     0   9                               197 0 32   1 2     0   9                        
657321 OR     school 4100023 2239   Hillsboro SD 1J 410002301764 4641 Free Orchards Elementary School   Regular School No Elementary KG 06 2021   k_12_total 82 4 214   0 6     4   9                               82 4 214   0 6     4   9                        
657350 OR     school 4106510 2024   Hood River County SD 410651000389 3372 Cascade Locks School   Regular School No Elementary KG 05 2021   k_12_total 36 0 11   4 0     0   9                               36 0 11   4 0     0   9                        
657367 OR     school 4106740 2053   Jefferson County SD 509J 410674001569 429 Buff Elementary School   Regular School No Elementary KG 05 2021   k_12_total 105 1 150   20 0     1   9                               105 1 150   20 0     1   9                        
657375 OR     school 4106710 2140   Jefferson SD 14J 410671001294 722 Jefferson Middle School   Regular School No Middle 06 08 2021   k_12_total 132 0 52   3 0     0   9                               132 0 52   3 0     0   9                        
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                        
657494 OR     school 4107710 2085   Mapleton SD 32 410771000603 569 Mapleton Jr/Sr High School   Regular School No High 07 12 2021   k_12_total 54 0 6   2 0     0   9                               54 0 6   2 0     0   9                        
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                        
657500 OR     school 4108010 2256   McMinnville SD 40 410801000540 1315 Duniway Middle School   Regular School No Middle 06 08 2021   k_12_total 490 18 293   16 8     6   9                               490 18 293   16 8     6   9                        
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                        
657531 OR     school 4108040 2048   Medford SD 549C 410804000439 419 Washington Elementary School   Regular School No Elementary KG 06 2021   k_12_total 158 5 145   2 0     4   9                               158 5 145   2 0     4   9                        
657557 OR     school 4108520 2147   Morrow SD 1 410852001598 4048 Irrigon Elementary School   Regular School No Middle 04 06 2021   k_12_total 67 0 104   1 0     1   9                               67 0 104   1 0     1   9                        
657566 OR     school 4108550 2145   Mt Angel SD 91 410855000838 793 St Marys Public School   Regular School No Elementary KG 05 2021   k_12_total 152 2 132   2 3     0   9                               152 2 132   2 3     0   9                        
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                        
657661 OR     school 4109000 2110   Nyssa SD 26 410900000752 704 Nyssa High School   Regular School No High 09 12 2021   k_12_total 120 0 216   0 2     0   9                               120 0 216   0 2     0   9                        
657726 OR     school 4110890 1926   Oregon Trail SD 46 411089000096 88 Welches Elementary School   Regular School No Elementary KG 05 2021   k_12_total 133 2 33   2 0     0   9                               133 2 33   2 0     0   9                        
657763 OR     school 4109720 1897   Pine Eagle SD 61 410972000016 15 Pine Eagle Charter School   Regular School Yes Other KG 12 2021   k_12_total 166 0 15   1 0     1   9                               166 0 15   1 0     1   9                        
657918 OR     school 4110520 2182   Reynolds SD 7 411052001471 1343 Reynolds Learning Academy   Alternative School No High 07 12 2021   k_12_total 50 25 118   3 0     2   9                               50 25 118   3 0     2   9                        
657948 OR     school 4110820 2142   Salem-Keizer SD 24J 411082001717 4589 Early College High School   Alternative School No High 09 12 2021   k_12_total 80 2 100   0 8     3   9                               80 2 100   0 8     3   9                        
657968 OR     school 4110820 2142   Salem-Keizer SD 24J 411082000792 746 Kennedy Elementary School   Regular School No Elementary KG 05 2021   k_12_total 105 6 234   3 0     7   9                               105 6 234   3 0     7   9                        
658055 OR     school 4111490 1978   Sisters SD 6 411149000283 264 Sisters Elementary School   Regular School No Elementary KG 04 2021   k_12_total 280 3 24   4 1     2   9                               280 3 24   4 1     2   9                        
658092 OR     school 4111670 2083   Springfield SD 19 411167000578 544 Centennial Elementary School   Regular School No Elementary KG 05 2021   k_12_total 146 3 76   1 1     0   9                               146 3 76   1 1     0   9                        
658120 OR     school 4111720 1948   St Helens SD 502 411172001599 2716 Plymouth High School   Alternative School No High 09 12 2021   k_12_total 46 0 9   0 0     0   9                               46 0 9   0 0     0   9                        
658155 OR     school 4106900 2055   Three Rivers/Josephine County SD 410690001797 4823 Sunny Wolf Charter School   Regular School Yes Elementary PK 06 2021   k_12_total 99 0 8   1 0     0   9                               99 0 8   1 0     0   9                        
658190 OR     school 4100014 2116   Vale SD 84 410001400748 701 Vale Elementary School   Regular School No Elementary KG 06 2021   k_12_total 239 0 105   1 1     0   9                               239 0 105   1 1     0   9                        
658203 OR     school 4113170 1922   West Linn-Wilsonville SD 3J 411317001786 4773 Arts and Technology High School   Alternative School No High 09 12 2021   k_12_total 53 0 19   0 3     1   9                               53 0 19   0 3     1   9                        
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                        
656830 OR     school 4101920 2243   Beaverton SD 48J 410192000213 1304 Arts and Communication Magnet Academy   Regular School No High 06 12 2021   k_12_total 464 14 102   3 35     2   87                               464 14 102   3 35     2   87                        
657298 OR     school 4103630 2023   Harney County Union High SD 1J 410363001756 4702 Silvies River Charter School   Regular School Yes Other KG 12 2021   k_12_total 872 3 41   8 18     1   85                               872 3 41   8 18     1   85                        
657725 OR     school 4110890 1926   Oregon Trail SD 46 411089000149 141 Sandy High School   Regular School No High 09 12 2021   k_12_total 1026 8 193   6 13     6   85                               1026 8 193   6 13     6   85                        
657813 OR     school 4110040 2180   Portland SD 1J 411004000902 858 Hosford Middle School   Regular School No Middle 06 08 2021   k_12_total 405 27 68   1 86     3   85                               405 27 68   1 86     3   85                        
658177 OR     school 4112240 2242   Tigard-Tualatin SD 23J 411224001197 1145 Twality Middle School   Regular School No Middle 06 08 2021   k_12_total 558 24 259   6 63     22   85                               558 24 259   6 63     22   85                        
656842 OR     school 4101920 2243   Beaverton SD 48J 410192000552 1319 Conestoga Middle School   Regular School No Middle 06 08 2021   k_12_total 479 35 183   2 97     17   84                               479 35 183   2 97     17   84                        
657017 OR     school 4103660 1965   Coos Bay SD 9 410366000216 201 Marshfield Senior High School   Regular School No High 08 12 2021   k_12_total 692 4 161   34 5     6   84                               692 4 161   34 5     6   84                        
657802 OR     school 4110040 2180   Portland SD 1J 411004000890 847 Faubion Elementary School   Regular School No Elementary PK 08 2021   k_12_total 177 198 206   13 13     10   84                               177 198 206   13 13     10   84                        
658040 OR     school 4111290 2244   Sherwood SD 88J 411129001245 1192 Sherwood Middle School   Regular School No Middle 06 08 2021   k_12_total 935 9 127   4 43     7   84                               935 9 127   4 43     7   84                        
657848 OR     school 4110040 2180   Portland SD 1J   2180 Portland SD 1J             2021   k_12_total 356 55 71   1 52     2   83                               356 55 71   1 52     2   83                        
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                        
657818 OR     school 4110040 2180   Portland SD 1J 411004000964 913 Jefferson High School   Regular School No High 09 12 2021   k_12_total 182 204 135   2 9     6   82                               182 204 135   2 9     6   82                        
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                        
656949 OR     school 4102310 1974   Brookings-Harbor SD 17C 410231000254 236 Kalmiopsis Elementary School   Regular School No Elementary KG 05 2021   k_12_total 369 0 122   22 10     1   81                               369 0 122   22 10     1   81                        
657815 OR     school 4110040 2180   Portland SD 1J 411004001365 1277 Jackson Middle School   Regular School No Middle 06 08 2021   k_12_total 551 57 75   3 30     6   81                               551 57 75   3 30     6   81                        
658107 OR     school 4111670 2083   Springfield SD 19   2083 Springfield SD 19             2021   k_12_total 995 3 205   8 6     3   81                               995 3 205   8 6     3   81                        
656786 OR     school 4101230 2252   Amity SD 4J 410123001320 1209 Amity Middle School   Regular School No Middle 06 08 2021   k_12_total 154 0 27   1 2     0   8                               154 0 27   1 2     0   8                        
656800 OR     school 4101620 1933   Astoria SD 1 410162000152 143 Astor Elementary School   Regular School No Elementary KG 02 2021   k_12_total 274 3 72   0 2     3   8                               274 3 72   0 2     3   8                        
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                        
656964 OR     school 4102780 2139   Cascade SD 5 410278001854 5380 Cascade Opportunity Center   Alternative School No High 09 12 2021   k_12_total 66 0 22   2 0     0   8                               66 0 22   2 0     0   8                        
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                        
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                        
657056 OR     school 4103720 1970   Crook County SD 410372001682 4392 Pioneer Secondary Alternative High School   Alternative School No High 09 12 2021   k_12_total 69 0 14   1 0     0   8                               69 0 14   1 0     0   8                        
657059 OR     school 4103720 1970   Crook County SD 410372001883 5489 Steins Pillar Elementary   Regular School No Elementary KG 04 2021   k_12_total 160 0 15   5 0     0   8                               160 0 15   5 0     0   8                        
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                        
657133 OR     school 4105080 2221   Enterprise SD 21 410508001149 1091 Enterprise High School   Regular School No High 07 12 2021   k_12_total 181 0 5   0 0     0   8                               181 0 5   0 0     0   8                        
657198 OR     school 4104950 2084   Fern Ridge SD 28J 410495000599 566 Veneta Elementary School   Regular School No Elementary KG 05 2021   k_12_total 287 2 39   3 2     2   8                               287 2 39   3 2     2   8                        
657234 OR     school 4105670 1992   Glide SD 12 410567000305 285 Glide High School   Regular School No High 09 12 2021   k_12_total 172 0 20   5 0     1   8                               172 0 20   5 0     1   8                        
657246 OR     school 4101120 2100   Greater Albany Public SD 8J 410112001577 3950 Albany Options School   Alternative School No High 09 12 2021   k_12_total 97 0 27   3 0     2   8                               97 0 27   3 0     2   8                        
657342 OR     school 4100023 2239   Hillsboro SD 1J 410002301200 1149 Reedville Elementary School   Regular School No Elementary PK 06 2021   k_12_total 32 5 171   1 9     0   8                               32 5 171   1 9     0   8                        
657346 OR     school 4100023 2239   Hillsboro SD 1J 410002301175 1119 W L Henry Elementary School   Regular School No Elementary KG 06 2021   k_12_total 39 0 278   1 4     0   8                               39 0 278   1 4     0   8                        
657376 OR     school 4106750 1934   Jewell SD 8 410675000158 3352 Jewell School   Regular School No Other PK 12 2021   k_12_total 89 0 15   0 0     0   8                               89 0 15   0 0     0   8                        
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                        
657481 OR     school 4107500 2097   Lincoln County SD 410750000658 624 Waldport Middle School   Regular School No Middle 07 08 2021   k_12_total 84 0 14   1 0     0   8                               84 0 14   1 0     0   8                        
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                        
657501 OR     school 4108010 2256   McMinnville SD 40 410801001433 2784 Grandhaven Elementary School   Regular School No Elementary KG 05 2021   k_12_total 220 3 178   6 6     1   8                               220 3 178   6 6     1   8                        
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                        
657533 OR     school 4108160 2205   Milton-Freewater Unified SD 7 410816001116 1057 Central Middle School   Regular School No Middle 06 08 2021   k_12_total 140 0 229   2 6     0   8                               140 0 229   2 6     0   8                        
657564 OR     school 4108550 2145   Mt Angel SD 91 410855000839 794 John F Kennedy High School   Regular School No High 09 12 2021   k_12_total 101 0 87   1 0     0   8                               101 0 87   1 0     0   8                        
657572 OR     school 4180180 2148   Multnomah ESD   2148 Multnomah ESD             2021   k_12_total 29 17 19   1 9     3   8                               29 17 19   1 9     3   8                        
657642 OR     school 4100020 2143   North Santiam SD 29J 410002001891 5620 North Santiam Options Academy   Alternative School No Other KG 12 2021   k_12_total 103 0 9   0 0     0   8                               103 0 9   0 0     0   8                        
657659 OR     school   2230   Northwest Regional ESD   2230 Northwest Regional ESD             2021   k_12_total 111 3 20   2 1     0   8                               111 3 20   2 1     0   8                        
657662 OR     school 4109000 2110   Nyssa SD 26 410900000751 703 Nyssa Middle School   Regular School No Middle 06 08 2021   k_12_total 87 0 190   0 0     0   8                               87 0 190   0 0     0   8                        
657714 OR     school 4100009 2336   Oregon Department of Education 410000900062 1832 Oregon School for the Deaf   Special Education School No Other KG 12 2021   k_12_total 38 4 34   4 3     4   8                               38 4 34   4 3     4   8                        
657748 OR     school 4109600 1900   Philomath SD 17J 410960000021 3440 Kings Valley Charter School   Regular School Yes Other KG 12 2021   k_12_total 181 1 16   0 2     0   8                               181 1 16   0 2     0   8                        
657986 OR     school 4110820 2142   Salem-Keizer SD 24J   2142 Salem-Keizer SD 24J             2021   k_12_total 111 4 55   4 1     1   8                               111 4 55   4 1     1   8                        
658031 OR     school 4111220 2257   Sheridan SD 48J 411122001450 2728 Sheridan Japanese School   Regular School Yes Other 04 12 2021   k_12_total 52 0 5   5 1     0   8                               52 0 5   5 1     0   8                        
658032 OR     school 4111250 2195   Sherman County SD 411125001068 1010 Sherman County School   Regular School No Other KG 12 2021   k_12_total 195 0 24   3 0     0   8                               195 0 24   3 0     0   8                        
658054 OR     school 4111450 2138   Silver Falls SD 4J 411145000822 777 Victor Point Elementary School   Regular School No Elementary KG 08 2021   k_12_total 152 2 12   0 2     0   8                               152 2 12   0 2     0   8                        
658057 OR     school 4111490 1978   Sisters SD 6 411149000943 1293 Sisters Middle School   Regular School No Middle 05 08 2021   k_12_total 302 4 37   2 3     3   8                               302 4 37   2 3     3   8                        
658079 OR     school 4100021 2225   South Wasco County SD 1 410002101166 1108 Maupin Elementary School   Regular School No Elementary KG 06 2021   k_12_total 98 0 9   4 0     0   8                               98 0 9   4 0     0   8                        

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