Data source: Big Local News · About: Big Local

1,459 rows where grade = "k_12_total", state = "OR" and year = 2020 sorted by school_nces_id

View and edit SQL

year

  • 2020 · 1,459

grade

  • k_12_total · 1,459
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
917040 OR     school 4100003 2193   Falls City SD 57 410000301061 1005 Falls City Elementary School   Regular School No Elementary KG 08 2020   k_12_total 100 0 4   2 0     0   9                               100 0 4   2 0     0   9                        
917041 OR     school 4100003 2193   Falls City SD 57 410000301062 1006 Falls City High School   Regular School No High 09 12 2020   k_12_total 65 0 2   2 0     1   5                               65 0 2   2 0     1   5                        
917561 OR     school 4100009 2336   Oregon Department of Education 410000900062 1832 Oregon School for the Deaf   Special Education School No Other KG 12 2020   k_12_total 50 5 42   4 6     4   10                               50 5 42   4 6     4   10                        
917560 OR     school 4100009 2336   Oregon Department of Education 410000901592 4040 Four Rivers Community School   Regular School Yes Other KG 12 2020   k_12_total 60 0 275   0 2     0   7                               60 0 275   0 2     0   7                        
917562 OR     school 4100009 2336   Oregon Department of Education 410000901734 4604 The Cottonwood School of Civics and Science   Regular School Yes Elementary KG 08 2020   k_12_total 160 4 19   0 7     0   17                               160 4 19   0 7     0   17                        
917563 OR     school 4100009 2336   Oregon Department of Education 410000901784 4720 The Ivy School   Regular School Yes Elementary KG 08 2020   k_12_total 221 13 32   3 5     1   21                               221 13 32   3 5     1   21                        
917559 OR     school 4100009 2336   Oregon Department of Education 410000901808 4850 Eagle Charter School   Regular School Yes Elementary KG 05 2020   k_12_total 98 3 27   0 2     0   14                               98 3 27   0 2     0   14                        
918036 OR     school 4100014 2116   Vale SD 84 410001400748 701 Vale Elementary School   Regular School No Elementary KG 06 2020   k_12_total 283 0 111   4 2     0   11                               283 0 111   4 2     0   11                        
918040 OR     school 4100014 2116   Vale SD 84 410001400754 706 Willowcreek Elementary School   Regular School No Elementary 01 08 2020   k_12_total 92 0 1   0 2     0   0                               92 0 1   0 2     0   0                        
918037 OR     school 4100014 2116   Vale SD 84 410001400761 713 Vale High School   Regular School No High 09 12 2020   k_12_total 206 0 54   0 3     2   3                               206 0 54   0 3     2   3                        
918038 OR     school 4100014 2116   Vale SD 84 410001401026 1357 Vale Middle School   Regular School No Middle 07 08 2020   k_12_total 87 0 29   1 2     1   0                               87 0 29   1 2     1   0                        
917070 OR     school 4100015 2137   Gervais SD 1 410001500821 776 Gervais Elementary School   Regular School No Elementary KG 05 2020   k_12_total 102 1 298   1 1     0   9                               102 1 298   1 1     0   9                        
917072 OR     school 4100015 2137   Gervais SD 1 410001500831 786 Gervais Middle School   Regular School No Middle 06 08 2020   k_12_total 74 0 168   0 1     0   2                               74 0 168   0 1     0   2                        
917071 OR     school 4100015 2137   Gervais SD 1 410001500853 808 Gervais High School   Regular School No High 09 12 2020   k_12_total 90 1 213   5 6     0   8                               90 1 213   5 6     0   8                        
917073 OR     school 4100015 2137   Gervais SD 1 410001501588 4024 Samuel Brown Academy   Alternative School No High 06 12 2020   k_12_total 6 0 15   0 0     0   0                               6 0 15   0 0     0   0                        
917069 OR     school 4100015 2137   Gervais SD 1 410001501859 5392 Frontier Charter Academy   Regular School Yes Other KG 11 2020   k_12_total 285 9 46   2 3     0   30                               285 9 46   2 3     0   30                        
918091 OR     school 4100016 2251   Yamhill Carlton SD 1 410001601266 1213 Yamhill Carlton Elementary School   Regular School No Elementary KG 04 2020   k_12_total 302 3 35   0 0     0   20                               302 3 35   0 0     0   20                        
918092 OR     school 4100016 2251   Yamhill Carlton SD 1 410001601288 1238 Yamhill Carlton High School   Regular School No High 09 12 2020   k_12_total 245 1 32   0 0     1   16                               245 1 32   0 0     1   16                        
918093 OR     school 4100016 2251   Yamhill Carlton SD 1 410001601730 4564 Yamhill Carlton Intermediate School   Regular School No Middle 05 08 2020   k_12_total 261 3 26   0 4     0   9                               261 3 26   0 4     0   9                        
917151 OR     school 4100019 2099   Harrisburg SD 7J 410001900698 659 Harrisburg Elementary School   Regular School No Elementary KG 06 2020   k_12_total 346 1 53   4 1     2   21                               346 1 53   4 1     2   21                        
917152 OR     school 4100019 2099   Harrisburg SD 7J 410001900731 689 Harrisburg High School   Regular School No High 07 12 2020   k_12_total 311 0 49   5 3     2   15                               311 0 49   5 3     2   15                        
917153 OR     school 4100019 2099   Harrisburg SD 7J 410001901422 2723 Harrisburg Middle School   Regular School No Not reported M M 2020   k_12_total - - -   - -     -   -                                                                            
917490 OR     school 4100020 2143   North Santiam SD 29J 410002000693 656 Mari-Linn Elementary School   Regular School No Elementary KG 08 2020   k_12_total 196 0 6   1 0     2   8                               196 0 6   1 0     2   8                        
917494 OR     school 4100020 2143   North Santiam SD 29J 410002000765 717 Sublimity Elementary School   Regular School No Elementary KG 08 2020   k_12_total 301 4 31   3 7     2   34                               301 4 31   3 7     2   34                        
917491 OR     school 4100020 2143   North Santiam SD 29J 410002000833 788 Stayton Elementary School   Regular School No Elementary KG 03 2020   k_12_total 267 3 82   0 1     1   23                               267 3 82   0 1     1   23                        
917493 OR     school 4100020 2143   North Santiam SD 29J 410002000834 789 Stayton Middle School   Regular School No Middle 04 08 2020   k_12_total 380 9 138   1 0     3   27                               380 9 138   1 0     3   27                        
917492 OR     school 4100020 2143   North Santiam SD 29J 410002000854 809 Stayton High School   Regular School No High 09 12 2020   k_12_total 561 12 138   7 5     1   29                               561 12 138   7 5     1   29                        
917926 OR     school 4100021 2225   South Wasco County SD 1 410002101166 1108 Maupin Elementary School   Regular School No Elementary KG 06 2020   k_12_total 94 0 10   5 0     0   11                               94 0 10   5 0     0   11                        
917927 OR     school 4100021 2225   South Wasco County SD 1 410002101167 1109 South Wasco County High School   Regular School No High 07 12 2020   k_12_total 79 1 10   8 0     2   6                               79 1 10   8 0     2   6                        
917196 OR     school 4100023 2239   Hillsboro SD 1J 410002300209 1302 Tobias Elementary School   Regular School No Elementary KG 06 2020   k_12_total 217 30 107   3 62     5   44                               217 30 107   3 62     5   44                        
917199 OR     school 4100023 2239   Hillsboro SD 1J 410002301168 1111 West Union Elementary School   Regular School No Elementary KG 06 2020   k_12_total 185 17 102   3 20     2   47                               185 17 102   3 20     2   47                        
917165 OR     school 4100023 2239   Hillsboro SD 1J 410002301169 1112 Brookwood Elementary School   Regular School No Elementary KG 06 2020   k_12_total 170 5 133   2 14     1   18                               170 5 133   2 14     1   18                        
917169 OR     school 4100023 2239   Hillsboro SD 1J 410002301171 1115 Eastwood Elementary School   Regular School No Elementary KG 06 2020   k_12_total 121 4 287   0 2     3   18                               121 4 287   0 2     3   18                        
917198 OR     school 4100023 2239   Hillsboro SD 1J 410002301172 1114 W Verne McKinney Elementary School   Regular School No Elementary KG 06 2020   k_12_total 163 13 240   0 7     1   21                               163 13 240   0 7     1   21                        
917187 OR     school 4100023 2239   Hillsboro SD 1J 410002301173 1117 Mooberry Elementary School   Regular School No Elementary KG 06 2020   k_12_total 114 4 276   3 2     1   25                               114 4 276   3 2     1   25                        
917197 OR     school 4100023 2239   Hillsboro SD 1J 410002301175 1119 W L Henry Elementary School   Regular School No Elementary KG 06 2020   k_12_total 51 0 301   1 2     0   10                               51 0 301   1 2     0   10                        
917166 OR     school 4100023 2239   Hillsboro SD 1J 410002301199 1147 Butternut Creek Elementary School   Regular School No Elementary KG 06 2020   k_12_total 185 3 124   1 24     8   33                               185 3 124   1 24     8   33                        
917193 OR     school 4100023 2239   Hillsboro SD 1J 410002301200 1149 Reedville Elementary School   Regular School No Elementary KG 06 2020   k_12_total 46 4 182   1 7     0   9                               46 4 182   1 7     0   9                        
917182 OR     school 4100023 2239   Hillsboro SD 1J 410002301201 1150 Ladd Acres Elementary School   Regular School No Elementary KG 06 2020   k_12_total 240 9 115   3 67     7   42                               240 9 115   3 67     7   42                        
917200 OR     school 4100023 2239   Hillsboro SD 1J 410002301202 1151 Witch Hazel Elementary School   Regular School No Elementary KG 06 2020   k_12_total 96 20 361   0 20     1   24                               96 20 361   0 20     1   24                        
917174 OR     school 4100023 2239   Hillsboro SD 1J 410002301203 1152 Groner K-8   Regular School No Elementary KG 08 2020   k_12_total 129 2 61   4 3     0   5                               129 2 61   4 3     0   5                        
917171 OR     school 4100023 2239   Hillsboro SD 1J 410002301242 1189 Farmington View Elementary School   Regular School No Elementary KG 06 2020   k_12_total 201 4 79   1 6     0   19                               201 4 79   1 6     0   19                        
917188 OR     school 4100023 2239   Hillsboro SD 1J 410002301243 1190 North Plains Elementary School   Regular School No Elementary KG 06 2020   k_12_total 293 7 59   4 15     0   33                               293 7 59   4 15     0   33                        
917167 OR     school 4100023 2239   Hillsboro SD 1J 410002301248 1368 Century High School   Regular School No High 09 12 2020   k_12_total 705 46 470   9 215     19   117                               705 46 470   9 215     19   117                        
917192 OR     school 4100023 2239   Hillsboro SD 1J 410002301250 1196 R A Brown Middle School   Regular School No Middle 07 08 2020   k_12_total 337 19 214   3 89     10   65                               337 19 214   3 89     10   65                        
917180 OR     school 4100023 2239   Hillsboro SD 1J 410002301251 1199 J W Poynter Middle School   Regular School No Middle 07 08 2020   k_12_total 332 25 271   12 41     8   51                               332 25 271   12 41     8   51                        
917175 OR     school 4100023 2239   Hillsboro SD 1J 410002301252 1201 Hillsboro High School   Regular School No High 09 12 2020   k_12_total 458 23 621   9 55     8   65                               458 23 621   9 55     8   65                        
917195 OR     school 4100023 2239   Hillsboro SD 1J 410002301253 1198 South Meadows Middle School   Regular School No Middle 07 08 2020   k_12_total 212 19 411   7 36     2   48                               212 19 411   7 36     2   48                        
917179 OR     school 4100023 2239   Hillsboro SD 1J 410002301295 1148 Indian Hills Elementary School   Regular School No Elementary KG 06 2020   k_12_total 204 12 102   4 77     8   56                               204 12 102   4 77     8   56                        
917183 OR     school 4100023 2239   Hillsboro SD 1J 410002301300 1110 Lenox Elementary School   Regular School No Elementary KG 06 2020   k_12_total 243 20 123   5 66     2   44                               243 20 123   5 66     2   44                        
917186 OR     school 4100023 2239   Hillsboro SD 1J 410002301305 1116 Minter Bridge Elementary School   Regular School No Elementary KG 06 2020   k_12_total 161 14 203   4 15     1   35                               161 14 203   4 15     1   35                        
917173 OR     school 4100023 2239   Hillsboro SD 1J 410002301306 1200 Glencoe High School   Regular School No High 09 12 2020   k_12_total 764 28 555   9 62     5   66                               764 28 555   9 62     5   66                        
917170 OR     school 4100023 2239   Hillsboro SD 1J 410002301322 1197 Evergreen Jr High School   Regular School No Middle 07 08 2020   k_12_total 371 22 321   3 22     4   39                               371 22 321   3 22     4   39                        
917181 OR     school 4100023 2239   Hillsboro SD 1J 410002301373 1285 Jackson Elementary School   Regular School No Elementary KG 06 2020   k_12_total 350 12 98   4 32     1   40                               350 12 98   4 32     1   40                        
917189 OR     school 4100023 2239   Hillsboro SD 1J 410002301499 3160 Orenco Elementary School   Regular School No Elementary KG 06 2020   k_12_total 275 20 141   7 79     5   73                               275 20 141   7 79     5   73                        
917190 OR     school 4100023 2239   Hillsboro SD 1J 410002301500 3159 Paul L Patterson Elementary School   Regular School No Elementary KG 06 2020   k_12_total 290 10 87   3 18     1   46                               290 10 87   3 18     1   46                        
917168 OR     school 4100023 2239   Hillsboro SD 1J 410002301535 4206 City View Charter School   Regular School Yes Elementary KG 08 2020   k_12_total 183 3 21   1 9     0   11                               183 3 21   1 9     0   11                        
917184 OR     school 4100023 2239   Hillsboro SD 1J 410002301585 4018 Liberty High School   Regular School No High 09 12 2020   k_12_total 721 32 529   16 98     19   96                               721 32 529   16 98     19   96                        
917185 OR     school 4100023 2239   Hillsboro SD 1J 410002301749 4642 Lincoln Street Elementary School   Regular School No Elementary KG 06 2020   k_12_total 97 7 352   0 3     2   10                               97 7 352   0 3     2   10                        
917194 OR     school 4100023 2239   Hillsboro SD 1J 410002301750 4703 Rosedale Elementary School   Regular School No Elementary KG 06 2020   k_12_total 159 17 154   3 38     2   37                               159 17 154   3 38     2   37                        
917191 OR     school 4100023 2239   Hillsboro SD 1J 410002301759 4643 Quatama Elementary School   Regular School No Elementary KG 06 2020   k_12_total 233 17 142   3 66     4   59                               233 17 142   3 66     4   59                        
917172 OR     school 4100023 2239   Hillsboro SD 1J 410002301764 4641 Free Orchards Elementary School   Regular School No Elementary KG 06 2020   k_12_total 118 10 215   1 9     3   9                               118 10 215   1 9     3   9                        
917176 OR     school 4100023 2239   Hillsboro SD 1J 410002301824 4973 Hillsboro Online Academy   Regular School No Other KG 12 2020   k_12_total 109 1 20   3 1     2   19                               109 1 20   3 1     2   19                        
917178 OR     school 4100023 2239   Hillsboro SD 1J 410002304174 3536 Imlay Elementary School   Regular School No Elementary KG 06 2020   k_12_total 305 13 123   1 60     6   44                               305 13 123   1 60     6   44                        
917278 OR     school 4100040 2262   Knappa SD 4 410004000176 166 Hilda Lahti Elementary School   Regular School No Elementary KG 08 2020   k_12_total 308 2 35   4 2     0   9                               308 2 35   4 2     0   9                        
917279 OR     school 4100040 2262   Knappa SD 4 410004000179 169 Knappa High School   Regular School No High 09 12 2020   k_12_total 115 0 17   2 1     2   5                               115 0 17   2 1     2   5                        
917535 OR     school 4100043 3477   ODE YCEP District 410004300494 1828 William P Lord High School   Regular School No High 06 12 2020   k_12_total 62 28 38   8 1     3   11                               62 28 38   8 1     3   11                        
917528 OR     school 4100043 3477   ODE YCEP District 410004301404 2258 Monroe School   Regular School No High 06 12 2020   k_12_total 5 3 5   3 1     1   0                               5 3 5   3 1     1   0                        
917529 OR     school 4100043 3477   ODE YCEP District 410004301406 2260 New Bridge High School   Regular School No High 06 12 2020   k_12_total 31 6 7   3 0     2   3                               31 6 7   3 0     2   3                        
917530 OR     school 4100043 3477   ODE YCEP District 410004301412 2387 Ocean Dunes High School   Regular School No High 09 12 2020   k_12_total 3 0 1   0 0     0   0                               3 0 1   0 0     0   0                        
917532 OR     school 4100043 3477   ODE YCEP District 410004301413 2388 Riverside High School   Regular School No High 10 12 2020   k_12_total 4 0 0   0 0     0   1                               4 0 0   0 0     0   1                        
917531 OR     school 4100043 3477   ODE YCEP District 410004301477 2386 RiverBend High School   Regular School No High 09 12 2020   k_12_total 5 2 5   0 0     0   0                               5 2 5   0 0     0   0                        
917534 OR     school 4100043 3477   ODE YCEP District 410004301740 4588 Trask River High School   Regular School No High 06 12 2020   k_12_total 15 0 4   0 1     2   2                               15 0 4   0 1     2   2                        
917533 OR     school 4100043 3477   ODE YCEP District 410004301744 4609 Three Lakes High School   Regular School No High 06 12 2020   k_12_total 18 1 9   3 0     1   4                               18 1 9   3 0     1   4                        
917214 OR     school 4100047 3997   Ione SD R2 410004700862 3363 Ione Community Charter School   Regular School Yes Other KG 12 2020   k_12_total 128 0 48   3 0     0   3                               128 0 48   3 0     0   3                        
917495 OR     school 4100048 4131   North Wasco County SD 21 410004801151 1093 Chenowith Elementary School   Regular School No Elementary KG 05 2020   k_12_total 174 1 218   10 4     10   12                               174 1 218   10 4     10   12                        
917499 OR     school 4100048 4131   North Wasco County SD 21 410004801153 1095 Mosier Community School   Regular School Yes Elementary KG 08 2020   k_12_total 114 2 66   2 0     0   12                               114 2 66   2 0     0   12                        
917496 OR     school 4100048 4131   North Wasco County SD 21 410004801155 1097 Colonel Wright Elementary School   Regular School No Elementary KG 05 2020   k_12_total 160 3 140   4 1     4   12                               160 3 140   4 1     4   12                        
917498 OR     school 4100048 4131   North Wasco County SD 21 410004801156 1098 Dry Hollow Elementary School   Regular School No Elementary KG 05 2020   k_12_total 256 1 144   8 1     7   30                               256 1 144   8 1     7   30                        
917502 OR     school 4100048 4131   North Wasco County SD 21 410004801158 1100 The Dalles Middle School   Regular School No Middle 06 08 2020   k_12_total 346 1 261   10 8     17   32                               346 1 261   10 8     17   32                        
917501 OR     school 4100048 4131   North Wasco County SD 21 410004801159 1101 The Dalles High School   Regular School No High 09 12 2020   k_12_total 456 4 313   11 9     11   31                               456 4 313   11 9     11   31                        
917503 OR     school 4100048 4131   North Wasco County SD 21 410004801833 5250 Wahtonka Community School   Regular School Yes High 09 12 2020   k_12_total 28 0 4   2 0     1   3                               28 0 4   2 0     1   3                        
917425 OR     school 4100640 1968   Myrtle Point SD 41 410064000233 214 Myrtle Crest School   Regular School No Elementary KG 06 2020   k_12_total 234 0 15   8 0     1   41                               234 0 15   8 0     1   41                        
917426 OR     school 4100640 1968   Myrtle Point SD 41 410064000234 215 Myrtle Point High School   Regular School No High 07 12 2020   k_12_total 150 3 23   12 0     0   37                               150 3 23   12 0     0   37                        
916638 OR     school 4100990 2063   Adel SD 21 410099000524 498 Adel Elementary School   Regular School No Middle 04 08 2020   k_12_total 5 0 0   2 0     0   0                               5 0 0   2 0     0   0                        
916639 OR     school 4101020 2113   Adrian SD 61 410102000755 707 Adrian Elementary School   Regular School No Elementary KG 08 2020   k_12_total 157 0 45   0 0     0   1                               157 0 45   0 0     0   1                        
916640 OR     school 4101020 2113   Adrian SD 61 410102000756 708 Adrian High School   Regular School No High 09 12 2020   k_12_total 70 0 15   1 1     0   2                               70 0 15   1 1     0   2                        
917108 OR     school 4101120 2100   Greater Albany Public SD 8J 410112000017 639 Oak Grove Elementary School   Regular School No Elementary KG 05 2020   k_12_total 312 1 17   1 4     1   24                               312 1 17   1 4     1   24                        
917105 OR     school 4101120 2100   Greater Albany Public SD 8J 410112000029 637 North Albany Elementary School   Regular School No Elementary KG 05 2020   k_12_total 255 1 31   0 2     0   25                               255 1 31   0 2     0   25                        
917100 OR     school 4101120 2100   Greater Albany Public SD 8J 410112000031 635 Fir Grove Primary School   Regular School No Not reported M M 2020   k_12_total - - -   - -     -   -                                                                            
917098 OR     school 4101120 2100   Greater Albany Public SD 8J 410112000669 631 Central Elementary School   Regular School No Elementary 03 05 2020   k_12_total 113 0 15   1 0     0   10                               113 0 15   1 0     0   10                        
917102 OR     school 4101120 2100   Greater Albany Public SD 8J 410112000670 640 Lafayette Elementary School   Regular School No Elementary KG 05 2020   k_12_total 200 0 83   7 0     3   22                               200 0 83   7 0     3   22                        
917103 OR     school 4101120 2100   Greater Albany Public SD 8J 410112000671 641 Liberty Elementary School   Regular School No Elementary KG 05 2020   k_12_total 256 2 25   2 10     0   30                               256 2 25   2 10     0   30                        
917107 OR     school 4101120 2100   Greater Albany Public SD 8J 410112000672 643 Oak Elementary School   Regular School No Elementary KG 05 2020   k_12_total 243 1 37   1 0     0   27                               243 1 37   1 0     0   27                        
917112 OR     school 4101120 2100   Greater Albany Public SD 8J 410112000673 644 Sunrise Elementary School   Regular School No Elementary KG 05 2020   k_12_total 176 1 127   4 0     2   19                               176 1 127   4 0     2   19                        
917111 OR     school 4101120 2100   Greater Albany Public SD 8J 410112000674 645 South Shore Elementary School   Regular School No Elementary KG 05 2020   k_12_total 121 2 252   10 0     0   22                               121 2 252   10 0     0   22                        
917113 OR     school 4101120 2100   Greater Albany Public SD 8J 410112000675 647 Takena Elementary School   Regular School No Elementary KG 02 2020   k_12_total 113 1 13   2 2     0   10                               113 1 13   2 2     0   10                        
917116 OR     school 4101120 2100   Greater Albany Public SD 8J 410112000676 648 Waverly Elementary School   Regular School No Elementary KG 05 2020   k_12_total 176 1 76   5 7     0   19                               176 1 76   5 7     0   19                        
917109 OR     school 4101120 2100   Greater Albany Public SD 8J 410112000680 636 Periwinkle Elementary School   Regular School No Elementary KG 05 2020   k_12_total 284 0 111   3 5     0   31                               284 0 111   3 5     0   31                        
917114 OR     school 4101120 2100   Greater Albany Public SD 8J 410112000692 646 Tangent Elementary School   Regular School No Elementary KG 05 2020   k_12_total 106 1 17   2 2     0   8                               106 1 17   2 2     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]);