Data source: Big Local News · About: Big Local

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

View and edit SQL

grade

year

  • 2021 · 19,873
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
656824 OR     school 4101830 2240   Banks SD 13 410183001180 1124 Banks High School   Regular School No High 09 12 2021   k_12_total 306 0 32   1 4     1   21                               306 0 32   1 4     1   21                        
656829 OR     school 4101920 2243   Beaverton SD 48J 410192001791 4805 Arco Iris Spanish Immersion School   Regular School Yes Elementary KG 08 2021   k_12_total 183 2 196   4 5     1   47                               183 2 196   4 5     1   47                        
656837 OR     school 4101920 2243   Beaverton SD 48J 410192001753 4671 Bonny Slope Elementary School   Regular School No Elementary PK 05 2021   k_12_total 311 7 54   1 146     1   53                               311 7 54   1 146     1   53                        
656838 OR     school 4101920 2243   Beaverton SD 48J 410192001210 1158 Cedar Mill Elementary School   Regular School No Elementary KG 05 2021   k_12_total 212 6 42   1 72     1   33                               212 6 42   1 72     1   33                        
656844 OR     school 4101920 2243   Beaverton SD 48J 410192001321 1162 Elmonica Elementary School   Regular School No Elementary KG 05 2021   k_12_total 91 15 128   5 193     1   32                               91 15 128   5 193     1   32                        
656845 OR     school 4101920 2243   Beaverton SD 48J 410192001301 1161 Errol Hassell Elementary School   Regular School No Elementary KG 05 2021   k_12_total 175 10 85   0 33     1   35                               175 10 85   0 33     1   35                        
656857 OR     school 4101920 2243   Beaverton SD 48J 410192001217 1166 Kinnaman Elementary School   Regular School No Elementary KG 05 2021   k_12_total 195 28 254   2 36     1   33                               195 28 254   2 36     1   33                        
656861 OR     school 4101920 2243   Beaverton SD 48J 410192001222 1170 Montclair Elementary School   Regular School No Elementary KG 05 2021   k_12_total 177 1 27   0 8     1   39                               177 1 27   0 8     1   39                        
656869 OR     school 4101920 2243   Beaverton SD 48J 410192001226 1174 Ridgewood Elementary School   Regular School No Elementary KG 05 2021   k_12_total 249 11 42   0 21     1   27                               249 11 42   0 21     1   27                        
656870 OR     school 4101920 2243   Beaverton SD 48J 410192001227 1175 Rock Creek Elementary School   Regular School No Elementary KG 05 2021   k_12_total 227 1 63   3 84     1   39                               227 1 63   3 84     1   39                        
656882 OR     school 4101920 2243   Beaverton SD 48J 410192001231 1178 West Tualatin View Elementary School   Regular School No Elementary KG 05 2021   k_12_total 196 2 25   2 27     1   23                               196 2 25   2 27     1   23                        
656887 OR     school 4101980 1976   Bend-LaPine Administrative SD 1 410198000258 241 Bear Creek Elementary School   Regular School No Elementary KG 05 2021   k_12_total 293 3 229   2 3     1   12                               293 3 229   2 3     1   12                        
656889 OR     school 4101980 1976   Bend-LaPine Administrative SD 1 410198001845 5309 Bend International School   Regular School Yes Elementary KG 08 2021   k_12_total 156 0 33   2 3     1   20                               156 0 33   2 3     1   20                        
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                        
656900 OR     school 4101980 1976   Bend-LaPine Administrative SD 1   4290 J Bar J Learning Centers - Boys Ranch Campus             2021   k_12_total 18 2 12   1 0     1   4                               18 2 12   1 0     1   4                        
656906 OR     school 4101980 1976   Bend-LaPine Administrative SD 1 410198000272 253 LaPine Senior High School   Regular School No High 09 12 2021   k_12_total 360 3 30   2 4     1   14                               360 3 30   2 4     1   14                        
656915 OR     school 4101980 1976   Bend-LaPine Administrative SD 1 410198001747 4646 Ponderosa Elementary   Regular School No Elementary KG 05 2021   k_12_total 341 3 23   3 6     1   19                               341 3 23   3 6     1   19                        
656920 OR     school 4101980 1976   Bend-LaPine Administrative SD 1 410198001844 5293 Silver Rail Elementary School   Regular School No Elementary KG 05 2021   k_12_total 314 6 68   3 6     1   17                               314 6 68   3 6     1   17                        
656921 OR     school 4101980 1976   Bend-LaPine Administrative SD 1 410198001488 3217 Sky View Middle School   Regular School No Middle 06 08 2021   k_12_total 478 2 83   2 13     1   16                               478 2 83   2 13     1   16                        
656924 OR     school 4101980 1976   Bend-LaPine Administrative SD 1 410198001350 1266 Three Rivers Elementary School   Regular School No Elementary KG 08 2021   k_12_total 342 2 13   3 0     1   34                               342 2 13   3 0     1   34                        
656925 OR     school 4101980 1976   Bend-LaPine Administrative SD 1 410198001454 3221 Westside Village Magnet School at Kingston Elementary School   Regular School No Elementary KG 08 2021   k_12_total 209 3 13   1 4     1   14                               209 3 13   1 4     1   14                        
656940 OR     school 4102040 2088   Bethel SD 52 410204004179 3567 Prairie Mountain School   Regular School No Elementary KG 08 2021   k_12_total 335 8 238   2 16     1   40                               335 8 238   2 16     1   40                        
656942 OR     school 4102040 2088   Bethel SD 52 410204000622 587 Shasta Middle School   Regular School No Middle 06 08 2021   k_12_total 269 14 82   3 6     1   45                               269 14 82   3 6     1   45                        
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                        
656953 OR     school 4102640 1929   Canby SD 86 410264001651 4434 Baker Prairie Middle School   Regular School No Middle 07 08 2021   k_12_total 349 2 216   4 9     1   26                               349 2 216   4 9     1   26                        
656965 OR     school 4102780 2139   Cascade SD 5 410278000856 811 Cascade Senior High School   Regular School No High 09 12 2021   k_12_total 512 0 122   9 8     1   22                               512 0 122   9 8     1   22                        
656968 OR     school 4102780 2139   Cascade SD 5 410278000835 790 Turner Elementary School   Regular School No Elementary KG 05 2021   k_12_total 278 4 50   0 10     1   17                               278 4 50   0 10     1   17                        
656984 OR     school 4102910 2105   Central Linn SD 552 410291000729 687 Central Linn High School   Regular School No High 07 12 2021   k_12_total 248 1 48   1 0     1   12                               248 1 48   1 0     1   12                        
656990 OR     school 4102940 2042   Central Point SD 6 410294001728 4559 Crater School of Business Innovation and Science   Regular School No High 09 12 2021   k_12_total 341 1 62   3 2     1   32                               341 1 62   3 2     1   32                        
656992 OR     school 4102940 2042   Central Point SD 6 410294000403 383 Jewett Elementary School   Regular School No Elementary KG 05 2021   k_12_total 374 3 191   7 5     1   38                               374 3 191   7 5     1   38                        
657007 OR     school 4103270 1927   Colton SD 53 410327000110 104 Colton High School   Regular School No High 09 12 2021   k_12_total 163 0 17   1 0     1   13                               163 0 17   1 0     1   13                        
657013 OR     school 4103660 1965   Coos Bay SD 9 410366000204 192 Eastside School   Regular School No Elementary KG 02 2021   k_12_total 280 3 35   6 1     1   24                               280 3 35   6 1     1   24                        
657020 OR     school 4103660 1965   Coos Bay SD 9 410366000215 199 Sunset School   Regular School No Elementary 03 06 2021   k_12_total 243 1 72   18 2     1   23                               243 1 72   18 2     1   23                        
657021 OR     school 4103390 1964   Coquille SD 8 410339000202 191 Coquille Junior Senior High   Regular School No High 07 12 2021   k_12_total 278 1 48   5 0     1   36                               278 1 48   5 0     1   36                        
657034 OR     school 4103480 1901   Corvallis SD 509J 410348000570 1322 Franklin School   Regular School No Elementary KG 08 2021   k_12_total 200 3 29   0 32     1   24                               200 3 29   0 32     1   24                        
657040 OR     school 4103480 1901   Corvallis SD 509J 410348000045 38 Linus Pauling Middle School   Regular School No Middle 06 08 2021   k_12_total 429 15 194   5 18     1   55                               429 15 194   5 18     1   55                        
657071 OR     school 4103860 2190   Dallas SD 2 410386001044 990 Oakdale Heights Elementary School   Regular School No Elementary KG 03 2021   k_12_total 274 1 44   3 2     1   23                               274 1 44   3 2     1   23                        
657073 OR     school 4103860 2190   Dallas SD 2 410386001047 993 Whitworth Elementary School   Regular School No Elementary 04 05 2021   k_12_total 286 0 56   9 2     1   27                               286 0 56   9 2     1   27                        
657078 OR     school 4103940 2187   David Douglas SD 40   2187 David Douglas SD 40             2021   k_12_total 42 12 16   0 22     1   4                               42 12 16   0 22     1   4                        
657097 OR     school 4103960 1993   Douglas County SD 15 410396000308 3348 Days Creek Charter School   Regular School Yes Other KG 12 2021   k_12_total 160 0 14   10 0     1   21                               160 0 14   10 0     1   21                        
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                        
657116 OR     school 4104500 2043   Eagle Point SD 9 410450001831 5251 Crater Lake Academy   Regular School Yes Other KG 12 2021   k_12_total 279 0 37   1 1     1   12                               279 0 37   1 1     1   12                        
657118 OR     school 4104500 2043   Eagle Point SD 9 410450000416 396 Eagle Point Middle School   Regular School No Middle 06 08 2021   k_12_total 303 1 61   5 2     1   32                               303 1 61   5 2     1   32                        
657127 OR     school 4104500 2043   Eagle Point SD 9 410450001587 4021 White Mountain Middle School   Regular School No Middle 06 08 2021   k_12_total 136 1 200   2 1     1   11                               136 1 200   2 1     1   11                        
657130 OR     school 4104590 2217   Elgin SD 23 410459001140 1082 Stella Mayfield Elementary School   Regular School No Elementary PK 06 2021   k_12_total 207 0 9   2 0     1   5                               207 0 9   2 0     1   5                        
657146 OR     school 4104740 2082   Eugene SD 4J 410474000561 506 Cal Young Middle School   Regular School No Middle 06 08 2021   k_12_total 350 7 49   2 24     1   49                               350 7 49   2 24     1   49                        
657149 OR     school 4104740 2082   Eugene SD 4J 410474001344 1240 Charlemagne French Immersion Elementary School   Regular School No Elementary KG 05 2021   k_12_total 233 7 25   2 20     1   59                               233 7 25   2 20     1   59                        
657152 OR     school 4104740 2082   Eugene SD 4J 410474000533 507 Coburg Community Charter School   Regular School Yes Elementary KG 08 2021   k_12_total 190 1 6   0 5     1   17                               190 1 6   0 5     1   17                        
657159 OR     school 4104740 2082   Eugene SD 4J 410474000542 513 Gilham Elementary School   Regular School No Elementary KG 05 2021   k_12_total 366 11 56   2 20     1   55                               366 11 56   2 20     1   55                        
657167 OR     school 4104740 2082   Eugene SD 4J 410474000565 520 Madison Middle School   Regular School No Middle 06 08 2021   k_12_total 300 2 64   3 2     1   37                               300 2 64   3 2     1   37                        
657177 OR     school 4104740 2082   Eugene SD 4J 410474000568 526 Roosevelt Middle School   Regular School No Middle 06 08 2021   k_12_total 412 7 47   4 36     1   63                               412 7 47   4 36     1   63                        
657186 OR     school 4104740 2082   Eugene SD 4J 410474001492 3229 Village School   Regular School Yes Elementary KG 08 2021   k_12_total 174 0 24   4 2     1   21                               174 0 24   4 2     1   21                        
657188 OR     school 4104740 2082   Eugene SD 4J 410474000559 534 Willagillespie Elementary School   Regular School No Elementary KG 05 2021   k_12_total 330 7 58   7 14     1   52                               330 7 58   7 14     1   52                        
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                        
657195 OR     school 4104950 2084   Fern Ridge SD 28J 410495000600 564 Fern Ridge Middle School   Regular School No Middle 06 08 2021   k_12_total 288 2 34   2 0     1   11                               288 2 34   2 0     1   11                        
657205 OR     school 4105160 2241   Forest Grove SD 15 410516001578 3986 Fern Hill Elementary School   Regular School No Elementary PK 04 2021   k_12_total 55 1 151   1 6     1   11                               55 1 151   1 6     1   11                        
657209 OR     school 4105160 2241   Forest Grove SD 15 410516001186 1132 Harvey Clarke Elementary School   Regular School No Elementary KG 04 2021   k_12_total 277 3 121   1 9     1   21                               277 3 121   1 9     1   21                        
657211 OR     school 4105160 2241   Forest Grove SD 15 410516001188 1126 Neil Armstrong Middle School   Regular School No Middle 07 08 2021   k_12_total 300 7 518   5 3     1   25                               300 7 518   5 3     1   25                        
657214 OR     school 4105250 2248   Fossil SD 21J 410525001375 1205 Fossil Charter School   Regular School Yes Other KG 12 2021   k_12_total 1209 15 38   4 13     1   37                               1209 15 38   4 13     1   37                        
657215 OR     school 4105310 2020   Frenchglen SD 16 410531000370 351 Frenchglen Elementary School   Regular School No Elementary KG 08 2021   k_12_total 8 0 0   0 0     1   0                               8 0 0   0 0     1   0                        
657225 OR     school 4105610 1931   Gladstone SD 115 410561001774 4719 Gladstone Center for Children and Families   Regular School No Elementary PK KG 2021   k_12_total 86 0 18   2 2     1   13                               86 0 18   2 2     1   13                        
657232 OR     school 4105640 2000   Glendale SD 77 410564000326 306 Glendale Elementary School   Regular School No Elementary KG 08 2021   k_12_total 162 2 18   4 2     1   1                               162 2 18   4 2     1   1                        
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                        
657243 OR     school 4105910 2054   Grants Pass SD 7 410591000461 439 Redwood Elementary School   Regular School No Elementary KG 05 2021   k_12_total 256 1 66   2 1     1   33                               256 1 66   2 1     1   33                        
657245 OR     school 4105910 2054   Grants Pass SD 7 410591000463 441 South Middle School   Regular School No Middle 06 08 2021   k_12_total 507 4 73   9 1     1   43                               507 4 73   9 1     1   43                        
657249 OR     school 4101120 2100   Greater Albany Public SD 8J   2100 Greater Albany Public SD 8J             2021   k_12_total 523 4 73   6 5     1   51                               523 4 73   6 5     1   51                        
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                        
657258 OR     school 4101120 2100   Greater Albany Public SD 8J 410112000680 636 Periwinkle Elementary School   Regular School No Elementary KG 05 2021   k_12_total 237 1 83   4 5     1   29                               237 1 83   4 5     1   29                        
657272 OR     school 4106000 2183   Gresham-Barlow SD 10J 410600000995 941 East Orient Elementary School   Regular School No Elementary KG 05 2021   k_12_total 287 5 43   4 9     1   34                               287 5 43   4 9     1   34                        
657286 OR     school 4106000 2183   Gresham-Barlow SD 10J   5152 Rosemary Anderson High School - East (Gresham)             2021   k_12_total 31 18 57   1 4     1   7                               31 18 57   1 4     1   7                        
657290 OR     school 4106000 2183   Gresham-Barlow SD 10J 410600000996 942 West Orient Middle School   Regular School No Middle 06 08 2021   k_12_total 258 5 84   3 15     1   28                               258 5 84   3 15     1   28                        
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                        
657303 OR     school 4106270 2201   Helix SD 1 410627001084 3364 Helix School   Regular School No Other KG 12 2021   k_12_total 135 0 9   0 4     1   13                               135 0 9   0 4     1   13                        
657310 OR     school 4106300 2206   Hermiston SD 8 410630000677 1333 Sandstone Middle School   Regular School No Middle 06 08 2021   k_12_total 234 4 304   3 7     1   11                               234 4 304   3 7     1   11                        
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                        
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                        
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                        
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                        
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                        
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                        
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                        
657361 OR     school 4106630 2215   Imbler SD 11 410663001137 1079 Imbler Charter School   Regular School Yes Other KG 12 2021   k_12_total 239 0 17   9 0     1   13                               239 0 17   9 0     1   13                        
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                        
657372 OR     school 4106740 2053   Jefferson County SD 509J 410674000454 432 Warm Springs K-8 Academy   Regular School No Elementary KG 08 2021   k_12_total 6 0 37   519 0     1   22                               6 0 37   519 0     1   22                        
657373 OR     school 4106710 2140   Jefferson SD 14J 410671000769 721 Jefferson Elementary School   Regular School No Elementary KG 05 2021   k_12_total 207 3 102   2 2     1   13                               207 3 102   2 2     1   13                        
657387 OR     school 4106930 2091   Junction City SD 69 410693000632 597 Junction City High School   Regular School No High 09 12 2021   k_12_total 421 6 64   10 4     1   28                               421 6 64   10 4     1   28                        
657388 OR     school 4106930 2091   Junction City SD 69 410693000630 595 Laurel Elementary School   Regular School No Elementary KG 04 2021   k_12_total 358 4 63   7 6     1   20                               358 4 63   7 6     1   20                        
657391 OR     school 4106930 2091   Junction City SD 69 410693000203 1297 Territorial Elementary School   Regular School No Elementary KG 05 2021   k_12_total 88 0 8   0 0     1   5                               88 0 8   0 0     1   5                        
657400 OR     school 4107020 2057   Klamath County SD 410702000495 470 Ferguson Elementary School   Regular School No Elementary KG 06 2021   k_12_total 319 8 87   23 3     1   47                               319 8 87   23 3     1   47                        
657409 OR     school 4107020 2057   Klamath County SD 410702000511 486 Lost River High School   Regular School No High 07 12 2021   k_12_total 94 0 127   1 0     1   2                               94 0 127   1 0     1   2                        
657412 OR     school 4107020 2057   Klamath County SD 410702000501 476 Merrill Elementary School   Regular School No Elementary KG 06 2021   k_12_total 73 0 66   0 0     1   0                               73 0 66   0 0     1   0                        
657424 OR     school 4107080 2056   Klamath Falls City Schools 410708000486 462 Pelican Elementary School   Regular School No Elementary KG 05 2021   k_12_total 162 2 47   11 1     1   20                               162 2 47   11 1     1   20                        
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                        
657442 OR     school 4107230 1923   Lake Oswego SD 7J 410723001308 54 Hallinan Elementary School   Regular School No Elementary KG 05 2021   k_12_total 294 0 32   0 26     1   42                               294 0 32   0 26     1   42                        
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                        
657457 OR     school 4107380 2101   Lebanon Community SD 9 410738000696 658 Hamilton Creek School   Regular School No Elementary KG 08 2021   k_12_total 219 0 27   1 0     1   13                               219 0 27   1 0     1   13                        
657458 OR     school 4107380 2101   Lebanon Community SD 9 410738000710 671 Lacomb School   Regular School No Elementary KG 08 2021   k_12_total 185 0 14   5 0     1   17                               185 0 14   5 0     1   17                        
657470 OR     school 4107500 2097   Lincoln County SD 410750000651 617 Oceanlake Elementary School   Regular School No Elementary KG 02 2021   k_12_total 171 4 82   11 3     1   27                               171 4 82   11 3     1   27                        
657471 OR     school 4107500 2097   Lincoln County SD   614 Olalla Center for Children & Families             2021   k_12_total 2 1 0   0 0     1   1                               2 1 0   0 0     1   1                        

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