Data source: Big Local News · About: Big Local

1,471 rows where grade = "k_12_total", state = "OR" and year = 2021 sorted by district_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                        
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                        
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                        
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                        
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                        
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                        
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                        
658193 OR     school 4100014 2116   Vale SD 84   2116 Vale SD 84             2021   k_12_total 25 0 4   3 0     1   0                               25 0 4   3 0     1   0                        
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                        
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                        
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                        
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                        
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                        
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                        
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                        
658248 OR     school 4100016 2251   Yamhill Carlton SD 1   2251 Yamhill Carlton SD 1             2021   k_12_total 237 2 6   1 1     0   3                               237 2 6   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                        
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                        
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                        
657643 OR     school 4100020 2143   North Santiam SD 29J   2143 North Santiam SD 29J             2021   k_12_total 1 0 0   0 0     0   0                               1 0 0   0 0     0   0                        
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                        
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                        
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                        
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                        
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                        
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                        
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                        
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                        
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                        
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                        
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                        
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                        
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                        
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                        
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                        
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                        
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                        
657326 OR     school 4100023 2239   Hillsboro SD 1J   2239 Hillsboro SD 1J             2021   k_12_total 150 9 106   0 9     0   18                               150 9 106   0 9     0   18                        
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                        
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                        
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                        
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                        
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                        
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                        
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                        
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                        
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                        
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                        
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                        
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                        
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                        
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                        
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                        
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                        
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                        
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                        
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                        
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                        
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                        
657453 OR     school 4100032 2064   Lane ESD   2064 Lane ESD             2021   k_12_total 80 3 2   0 0     0   5                               80 3 2   0 0     0   5                        
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                        
657363 OR     school 4100036 2200   InterMountain ESD   4846 Lifeways Inc             2021   k_12_total 9 0 0   0 0     0   1                               9 0 0   0 0     0   1                        
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                        
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                        
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                        
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                        
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                        
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                        
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                        
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                        
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                        
657650 OR     school 4100048 4131   North Wasco County SD 21   1262 Crossroads             2021   k_12_total 2 0 3   0 0     0   1                               2 0 3   0 0     0   1                        
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                        
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                        
657653 OR     school 4100048 4131   North Wasco County SD 21   4131 North Wasco County SD 21             2021   k_12_total 59 0 23   3 0     0   1                               59 0 23   3 0     0   1                        
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                        
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                        
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                        
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                        
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                        
657247 OR     school 4101120 2100   Greater Albany Public SD 8J 410112000732 632 Calapooia Middle School   Regular School No Middle 06 08 2021   k_12_total 372 5 211   10 2     0   47                               372 5 211   10 2     0   47                        

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