Data source: Big Local News · About: Big Local

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

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
657190 OR     school 4100003 2193   Falls City SD 57 410000301061 1005 Falls City Elementary School   Regular School No Elementary KG 08 2021   k_12_total 97 0 5   1 0     0   6                               97 0 5   1 0     0   6                        
657191 OR     school 4100003 2193   Falls City SD 57 410000301062 1006 Falls City High School   Regular School No High 09 12 2021   k_12_total 54 0 1   1 0     0   5                               54 0 1   1 0     0   5                        
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                        
657713 OR     school 4100009 2336   Oregon Department of Education 410000901592 4040 Four Rivers Community School   Regular School Yes Other KG 12 2021   k_12_total 67 0 277   0 1     0   5                               67 0 277   0 1     0   5                        
657715 OR     school 4100009 2336   Oregon Department of Education 410000901734 4604 The Cottonwood School of Civics and Science   Regular School Yes Elementary KG 08 2021   k_12_total 159 5 20   0 7     0   17                               159 5 20   0 7     0   17                        
657716 OR     school 4100009 2336   Oregon Department of Education 410000901784 4720 The Ivy School   Regular School Yes Elementary KG 08 2021   k_12_total 242 24 35   4 3     0   19                               242 24 35   4 3     0   19                        
657712 OR     school 4100009 2336   Oregon Department of Education 410000901808 4850 Eagle Charter School   Regular School Yes Elementary KG 05 2021   k_12_total 89 2 30   0 2     0   16                               89 2 30   0 2     0   16                        
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                        
658194 OR     school 4100014 2116   Vale SD 84 410001400754 706 Willowcreek Elementary School   Regular School No Elementary 01 08 2021   k_12_total 68 0 3   0 2     0   0                               68 0 3   0 2     0   0                        
658191 OR     school 4100014 2116   Vale SD 84 410001400761 713 Vale High School   Regular School No High 09 12 2021   k_12_total 195 0 46   0 4     1   1                               195 0 46   0 4     1   1                        
658192 OR     school 4100014 2116   Vale SD 84 410001401026 1357 Vale Middle School   Regular School No Middle 07 08 2021   k_12_total 74 0 33   0 2     0   2                               74 0 33   0 2     0   2                        
657221 OR     school 4100015 2137   Gervais SD 1 410001500821 776 Gervais Elementary School   Regular School No Elementary KG 05 2021   k_12_total 85 1 261   0 2     0   7                               85 1 261   0 2     0   7                        
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                        
657222 OR     school 4100015 2137   Gervais SD 1 410001500853 808 Gervais High School   Regular School No High 09 12 2021   k_12_total 97 1 219   5 2     0   7                               97 1 219   5 2     0   7                        
657224 OR     school 4100015 2137   Gervais SD 1 410001501588 4024 Samuel Brown Academy   Alternative School No High 06 12 2021   k_12_total 3 0 13   0 0     0   0                               3 0 13   0 0     0   0                        
657220 OR     school 4100015 2137   Gervais SD 1 410001501859 5392 Frontier Charter Academy   Regular School Yes Other KG 12 2021   k_12_total 456 7 77   5 8     5   31                               456 7 77   5 8     5   31                        
658245 OR     school 4100016 2251   Yamhill Carlton SD 1 410001601266 1213 Yamhill Carlton Elementary School   Regular School No Elementary KG 03 2021   k_12_total 187 0 34   0 0     0   8                               187 0 34   0 0     0   8                        
658246 OR     school 4100016 2251   Yamhill Carlton SD 1 410001601288 1238 Yamhill Carlton High School   Regular School No High 09 12 2021   k_12_total 231 2 33   0 3     2   12                               231 2 33   0 3     2   12                        
658247 OR     school 4100016 2251   Yamhill Carlton SD 1 410001601730 4564 Yamhill Carlton Intermediate School   Regular School No Middle 04 08 2021   k_12_total 238 2 25   0 1     0   12                               238 2 25   0 1     0   12                        
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                        
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                        
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                        
657641 OR     school 4100020 2143   North Santiam SD 29J 410002000693 656 Mari-Linn Elementary School   Regular School No Elementary KG 08 2021   k_12_total 151 0 1   0 0     0   11                               151 0 1   0 0     0   11                        
657647 OR     school 4100020 2143   North Santiam SD 29J 410002000765 717 Sublimity Elementary School   Regular School No Elementary KG 08 2021   k_12_total 271 3 30   4 7     2   30                               271 3 30   4 7     2   30                        
657644 OR     school 4100020 2143   North Santiam SD 29J 410002000833 788 Stayton Elementary School   Regular School No Elementary KG 03 2021   k_12_total 208 4 72   0 2     1   22                               208 4 72   0 2     1   22                        
657646 OR     school 4100020 2143   North Santiam SD 29J 410002000834 789 Stayton Middle School   Regular School No Middle 04 08 2021   k_12_total 301 8 115   2 0     6   24                               301 8 115   2 0     6   24                        
657645 OR     school 4100020 2143   North Santiam SD 29J 410002000854 809 Stayton High School   Regular School No High 09 12 2021   k_12_total 505 8 148   6 3     4   37                               505 8 148   6 3     4   37                        
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                        
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                        
658080 OR     school 4100021 2225   South Wasco County SD 1 410002101167 1109 South Wasco County High School   Regular School No High 07 12 2021   k_12_total 86 1 13   7 0     1   10                               86 1 13   7 0     1   10                        
657345 OR     school 4100023 2239   Hillsboro SD 1J 410002300209 1302 Tobias Elementary School   Regular School No Elementary KG 06 2021   k_12_total 162 25 110   4 66     5   40                               162 25 110   4 66     5   40                        
657348 OR     school 4100023 2239   Hillsboro SD 1J 410002301168 1111 West Union Elementary School   Regular School No Elementary KG 06 2021   k_12_total 130 12 117   1 18     3   46                               130 12 117   1 18     3   46                        
657314 OR     school 4100023 2239   Hillsboro SD 1J 410002301169 1112 Brookwood Elementary School   Regular School No Elementary KG 06 2021   k_12_total 156 8 146   3 13     1   14                               156 8 146   3 13     1   14                        
657318 OR     school 4100023 2239   Hillsboro SD 1J 410002301171 1115 Eastwood Elementary School   Regular School No Elementary KG 06 2021   k_12_total 93 4 294   0 3     3   12                               93 4 294   0 3     3   12                        
657347 OR     school 4100023 2239   Hillsboro SD 1J 410002301172 1114 W Verne McKinney Elementary School   Regular School No Elementary KG 06 2021   k_12_total 137 9 260   1 10     0   22                               137 9 260   1 10     0   22                        
657336 OR     school 4100023 2239   Hillsboro SD 1J 410002301173 1117 Mooberry Elementary School   Regular School No Elementary KG 06 2021   k_12_total 91 4 275   1 2     1   15                               91 4 275   1 2     1   15                        
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                        
657315 OR     school 4100023 2239   Hillsboro SD 1J 410002301199 1147 Butternut Creek Elementary School   Regular School No Elementary KG 06 2021   k_12_total 145 4 125   0 22     5   35                               145 4 125   0 22     5   35                        
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                        
657331 OR     school 4100023 2239   Hillsboro SD 1J 410002301201 1150 Ladd Acres Elementary School   Regular School No Elementary KG 06 2021   k_12_total 181 4 99   3 66     10   38                               181 4 99   3 66     10   38                        
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                        
657323 OR     school 4100023 2239   Hillsboro SD 1J 410002301203 1152 Groner K-8   Regular School No Elementary KG 08 2021   k_12_total 99 1 57   2 3     1   7                               99 1 57   2 3     1   7                        
657320 OR     school 4100023 2239   Hillsboro SD 1J 410002301242 1189 Farmington View Elementary School   Regular School No Elementary KG 06 2021   k_12_total 163 0 73   1 4     0   19                               163 0 73   1 4     0   19                        
657337 OR     school 4100023 2239   Hillsboro SD 1J 410002301243 1190 North Plains Elementary School   Regular School No Elementary KG 06 2021   k_12_total 205 5 50   3 17     1   31                               205 5 50   3 17     1   31                        
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                        
657341 OR     school 4100023 2239   Hillsboro SD 1J 410002301250 1196 R A Brown Middle School   Regular School No Middle 07 08 2021   k_12_total 264 23 231   3 97     10   65                               264 23 231   3 97     10   65                        
657329 OR     school 4100023 2239   Hillsboro SD 1J 410002301251 1199 J W Poynter Middle School   Regular School No Middle 07 08 2021   k_12_total 263 15 281   10 29     8   52                               263 15 281   10 29     8   52                        
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                        
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                        
657328 OR     school 4100023 2239   Hillsboro SD 1J 410002301295 1148 Indian Hills Elementary School   Regular School No Elementary KG 06 2021   k_12_total 162 9 90   2 74     8   55                               162 9 90   2 74     8   55                        
657332 OR     school 4100023 2239   Hillsboro SD 1J 410002301300 1110 Lenox Elementary School   Regular School No Elementary KG 06 2021   k_12_total 194 20 91   4 63     6   35                               194 20 91   4 63     6   35                        
657335 OR     school 4100023 2239   Hillsboro SD 1J 410002301305 1116 Minter Bridge Elementary School   Regular School No Elementary KG 06 2021   k_12_total 135 9 172   3 18     0   33                               135 9 172   3 18     0   33                        
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                        
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                        
657330 OR     school 4100023 2239   Hillsboro SD 1J 410002301373 1285 Jackson Elementary School   Regular School No Elementary KG 06 2021   k_12_total 263 10 80   3 32     1   38                               263 10 80   3 32     1   38                        
657338 OR     school 4100023 2239   Hillsboro SD 1J 410002301499 3160 Orenco Elementary School   Regular School No Elementary KG 06 2021   k_12_total 195 14 126   4 78     5   53                               195 14 126   4 78     5   53                        
657339 OR     school 4100023 2239   Hillsboro SD 1J 410002301500 3159 Paul L Patterson Elementary School   Regular School No Elementary KG 06 2021   k_12_total 219 9 85   1 19     1   42                               219 9 85   1 19     1   42                        
657317 OR     school 4100023 2239   Hillsboro SD 1J 410002301535 4206 City View Charter School   Regular School Yes Elementary KG 08 2021   k_12_total 180 8 22   4 15     0   20                               180 8 22   4 15     0   20                        
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                        
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                        
657343 OR     school 4100023 2239   Hillsboro SD 1J 410002301750 4703 Rosedale Elementary School   Regular School No Elementary KG 06 2021   k_12_total 120 14 141   3 43     0   27                               120 14 141   3 43     0   27                        
657340 OR     school 4100023 2239   Hillsboro SD 1J 410002301759 4643 Quatama Elementary School   Regular School No Elementary KG 06 2021   k_12_total 165 12 134   5 66     5   46                               165 12 134   5 66     5   46                        
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                        
657325 OR     school 4100023 2239   Hillsboro SD 1J 410002301824 4973 Hillsboro Online Academy   Regular School No Other KG 12 2021   k_12_total 806 29 158   7 31     5   109                               806 29 158   7 31     5   109                        
657327 OR     school 4100023 2239   Hillsboro SD 1J 410002304174 3536 Imlay Elementary School   Regular School No Elementary KG 06 2021   k_12_total 250 12 107   1 51     1   45                               250 12 107   1 51     1   45                        
657454 OR     school 4100032 2064   Lane ESD 410003201889 3302 Martin Luther King Jr. Education Center   Regular School No High 06 12 2021   k_12_total 10 0 1   0 0     0   4                               10 0 1   0 0     0   4                        
657362 OR     school 4100036 2200   InterMountain ESD 410003601892 5512 InterMountain Virtual Learning Academy   Regular School No Other KG 12 2021   k_12_total 406 8 42   7 4     6   20                               406 8 42   7 4     6   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                        
657428 OR     school 4100040 2262   Knappa SD 4 410004000179 169 Knappa High School   Regular School No High 09 12 2021   k_12_total 117 0 16   3 0     1   7                               117 0 16   3 0     1   7                        
657688 OR     school 4100043 3477   ODE YCEP District 410004300494 1828 William P Lord High School   Regular School No High 06 12 2021   k_12_total 48 20 31   7 0     4   11                               48 20 31   7 0     4   11                        
657681 OR     school 4100043 3477   ODE YCEP District 410004301404 2258 Monroe School   Regular School No High 06 12 2021   k_12_total 9 1 6   1 0     0   0                               9 1 6   1 0     0   0                        
657682 OR     school 4100043 3477   ODE YCEP District 410004301406 2260 New Bridge High School   Regular School No High 06 12 2021   k_12_total 32 3 10   4 0     2   2                               32 3 10   4 0     2   2                        
657683 OR     school 4100043 3477   ODE YCEP District 410004301412 2387 Ocean Dunes High School   Regular School No High 09 12 2021   k_12_total 1 0 1   1 0     0   0                               1 0 1   1 0     0   0                        
657685 OR     school 4100043 3477   ODE YCEP District 410004301413 2388 Riverside High School   Regular School No High 10 12 2021   k_12_total 3 0 2   0 0     0   1                               3 0 2   0 0     0   1                        
657684 OR     school 4100043 3477   ODE YCEP District 410004301477 2386 RiverBend High School   Regular School No High 09 12 2021   k_12_total 5 2 2   0 0     1   0                               5 2 2   0 0     1   0                        
657687 OR     school 4100043 3477   ODE YCEP District 410004301740 4588 Trask River High School   Regular School No High 06 12 2021   k_12_total 16 2 3   1 1     0   3                               16 2 3   1 1     0   3                        
657686 OR     school 4100043 3477   ODE YCEP District 410004301744 4609 Three Lakes High School   Regular School No High 06 12 2021   k_12_total 15 4 7   2 0     0   0                               15 4 7   2 0     0   0                        
657364 OR     school 4100047 3997   Ione SD R2 410004700862 3363 Ione Community Charter School   Regular School Yes Other KG 12 2021   k_12_total 102 0 42   2 0     0   3                               102 0 42   2 0     0   3                        
657648 OR     school 4100048 4131   North Wasco County SD 21 410004801151 1093 Chenowith Elementary School   Regular School No Elementary KG 05 2021   k_12_total 140 1 203   7 3     6   11                               140 1 203   7 3     6   11                        
657652 OR     school 4100048 4131   North Wasco County SD 21 410004801153 1095 Mosier Community School   Regular School Yes Elementary KG 08 2021   k_12_total 102 2 63   1 1     0   14                               102 2 63   1 1     0   14                        
657649 OR     school 4100048 4131   North Wasco County SD 21 410004801155 1097 Colonel Wright Elementary School   Regular School No Elementary KG 05 2021   k_12_total 112 4 120   5 2     4   6                               112 4 120   5 2     4   6                        
657651 OR     school 4100048 4131   North Wasco County SD 21 410004801156 1098 Dry Hollow Elementary School   Regular School No Elementary KG 05 2021   k_12_total 220 1 155   6 4     8   27                               220 1 155   6 4     8   27                        
657656 OR     school 4100048 4131   North Wasco County SD 21 410004801158 1100 The Dalles Middle School   Regular School No Middle 06 08 2021   k_12_total 278 0 262   8 4     11   35                               278 0 262   8 4     11   35                        
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                        
657654 OR     school 4100048 4131   North Wasco County SD 21 410004801833 5250 Riverbend Community School   Regular School Yes High 09 12 2021   k_12_total 21 1 5   0 0     0   2                               21 1 5   0 0     0   2                        
657576 OR     school 4100640 1968   Myrtle Point SD 41 410064000233 214 Myrtle Crest School   Regular School No Elementary KG 06 2021   k_12_total 213 1 20   8 0     1   32                               213 1 20   8 0     1   32                        
657577 OR     school 4100640 1968   Myrtle Point SD 41 410064000234 215 Myrtle Point High School   Regular School No High 07 12 2021   k_12_total 152 2 20   10 0     0   37                               152 2 20   10 0     0   37                        
656780 OR     school 4100990 2063   Adel SD 21 410099000524 498 Adel Elementary School   Regular School No Middle 04 08 2021   k_12_total 11 0 0   1 0     0   0                               11 0 0   1 0     0   0                        
656781 OR     school 4101020 2113   Adrian SD 61 410102000755 707 Adrian Elementary School   Regular School No Elementary KG 08 2021   k_12_total 132 0 38   0 0     0   1                               132 0 38   0 0     0   1                        
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                        
657257 OR     school 4101120 2100   Greater Albany Public SD 8J 410112000017 639 Oak Grove Elementary School   Regular School No Elementary KG 05 2021   k_12_total 251 0 15   0 4     0   26                               251 0 15   0 4     0   26                        
657254 OR     school 4101120 2100   Greater Albany Public SD 8J 410112000029 637 North Albany Elementary School   Regular School No Elementary KG 05 2021   k_12_total 222 4 26   0 2     0   17                               222 4 26   0 2     0   17                        
657248 OR     school 4101120 2100   Greater Albany Public SD 8J 410112000669 631 Central Elementary School   Regular School No Elementary 03 05 2021   k_12_total 94 1 8   1 0     0   7                               94 1 8   1 0     0   7                        
657250 OR     school 4101120 2100   Greater Albany Public SD 8J 410112000670 640 Lafayette Elementary School   Regular School No Elementary KG 05 2021   k_12_total 142 1 70   7 2     3   16                               142 1 70   7 2     3   16                        
657251 OR     school 4101120 2100   Greater Albany Public SD 8J 410112000671 641 Liberty Elementary School   Regular School No Elementary KG 05 2021   k_12_total 213 3 27   1 8     0   25                               213 3 27   1 8     0   25                        
657256 OR     school 4101120 2100   Greater Albany Public SD 8J 410112000672 643 Oak Elementary School   Regular School No Elementary KG 05 2021   k_12_total 178 1 33   4 0     1   23                               178 1 33   4 0     1   23                        
657261 OR     school 4101120 2100   Greater Albany Public SD 8J 410112000673 644 Sunrise Elementary School   Regular School No Elementary KG 05 2021   k_12_total 135 1 131   8 0     2   22                               135 1 131   8 0     2   22                        
657260 OR     school 4101120 2100   Greater Albany Public SD 8J 410112000674 645 South Shore Elementary School   Regular School No Elementary KG 05 2021   k_12_total 86 2 231   9 0     0   19                               86 2 231   9 0     0   19                        
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                        
657265 OR     school 4101120 2100   Greater Albany Public SD 8J 410112000676 648 Waverly Elementary School   Regular School No Elementary KG 05 2021   k_12_total 128 2 79   3 5     0   20                               128 2 79   3 5     0   20                        

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