Data source: Big Local News · About: Big Local

20,426 rows where state = "OR" and year = 2020 sorted by native_hawaiian_pacific_islander_int

View and edit SQL

grade

year

  • 2020 · 19,753
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
916650 OR     school 4101560 2041   Ashland SD 5 410156000401 381 Ashland High School   Regular School No High 09 12 2020   k_12_total 745 8 99   1 10     1   129                               745 8 99   1 10     1   129                        
916654 OR     school 4101560 2041   Ashland SD 5 410156000397 377 Helman Elementary School   Regular School No Elementary KG 05 2020   k_12_total 260 2 36   1 1     1   40                               260 2 36   1 1     1   40                        
916658 OR     school 4101620 1933   Astoria SD 1 410162000152 143 Astor Elementary School   Regular School No Elementary KG 02 2020   k_12_total 336 4 79   2 0     1   16                               336 4 79   2 0     1   16                        
916662 OR     school 4101620 1933   Astoria SD 1 410162000156 147 Lewis & Clark Elementary School   Regular School No Elementary 03 05 2020   k_12_total 315 2 85   2 2     1   13                               315 2 85   2 2     1   13                        
916665 OR     school 4101660 2208   Athena-Weston SD 29RJ 410166001115 1056 Weston-McEwen High School   Regular School No High 09 12 2020   k_12_total 150 1 13   13 0     1   15                               150 1 13   13 0     1   15                        
916667 OR     school 4101710 1894   Baker SD 5J 410171000009 8 Baker High School   Regular School No High 09 12 2020   k_12_total 357 1 54   3 5     1   19                               357 1 54   3 5     1   19                        
916675 OR     school 4101710 1894   Baker SD 5J 410171000007 7 South Baker Intermediate School   Regular School No Middle 04 06 2020   k_12_total 309 1 37   5 0     1   15                               309 1 37   5 0     1   15                        
916676 OR     school 4101800 1969   Bandon SD 54 410180000237 218 Bandon Senior High School   Regular School No High 09 12 2020   k_12_total 143 1 30   4 3     1   15                               143 1 30   4 3     1   15                        
916680 OR     school 4101830 2240   Banks SD 13 410183001180 1124 Banks High School   Regular School No High 09 12 2020   k_12_total 332 0 27   1 5     1   19                               332 0 27   1 5     1   19                        
916693 OR     school 4101920 2243   Beaverton SD 48J 410192001210 1158 Cedar Mill Elementary School   Regular School No Elementary KG 05 2020   k_12_total 249 10 48   0 78     1   41                               249 10 48   0 78     1   41                        
916696 OR     school 4101920 2243   Beaverton SD 48J 410192000220 1305 Community School   Alternative School No High 09 12 2020   k_12_total 62 5 49   1 4     1   5                               62 5 49   1 4     1   5                        
916701 OR     school 4101920 2243   Beaverton SD 48J 410192001262 1370 Findley Elementary   Regular School No Elementary KG 05 2020   k_12_total 183 7 31   2 375     1   41                               183 7 31   2 375     1   41                        
916706 OR     school 4101920 2243   Beaverton SD 48J 410192001745 4638 Health & Science School   Regular School No High 06 12 2020   k_12_total 333 17 207   6 88     1   53                               333 17 207   6 88     1   53                        
916711 OR     school 4101920 2243   Beaverton SD 48J 410192001445 3437 Jacob Wismer Elementary School   Regular School No Elementary KG 05 2020   k_12_total 202 4 29   3 449     1   37                               202 4 29   3 449     1   37                        
916716 OR     school 4101920 2243   Beaverton SD 48J 410192001222 1170 Montclair Elementary School   Regular School No Elementary KG 05 2020   k_12_total 229 4 28   0 13     1   47                               229 4 28   0 13     1   47                        
916723 OR     school 4101920 2243   Beaverton SD 48J 410192001226 1174 Ridgewood Elementary School   Regular School No Elementary KG 05 2020   k_12_total 296 13 62   1 19     1   40                               296 13 62   1 19     1   40                        
916727 OR     school 4101920 2243   Beaverton SD 48J 410192000536 1314 School of Science & Technology   Regular School No High 09 12 2020   k_12_total 92 5 17   1 40     1   19                               92 5 17   1 40     1   19                        
916734 OR     school 4101920 2243   Beaverton SD 48J 410192001229 1176 Terra Linda Elementary School   Regular School No Elementary KG 05 2020   k_12_total 250 8 66   1 27     1   18                               250 8 66   1 27     1   18                        
916741 OR     school 4101980 1976   Bend-LaPine Administrative SD 1 410198000258 241 Bear Creek Elementary School   Regular School No Elementary KG 05 2020   k_12_total 290 7 246   2 7     1   8                               290 7 246   2 7     1   8                        
916743 OR     school 4101980 1976   Bend-LaPine Administrative SD 1 410198001845 5309 Bend International School   Regular School Yes Elementary KG 08 2020   k_12_total 142 0 36   2 3     1   15                               142 0 36   2 3     1   15                        
916747 OR     school 4101980 1976   Bend-LaPine Administrative SD 1 410198000259 242 Cascade Middle School   Regular School No Middle 06 08 2020   k_12_total 685 1 77   1 16     1   15                               685 1 77   1 16     1   15                        
916748 OR     school 4101980 1976   Bend-LaPine Administrative SD 1 410198001860 5384 Desert Sky Montessori   Regular School Yes Elementary KG 05 2020   k_12_total 127 0 9   0 2     1   13                               127 0 9   0 2     1   13                        
916749 OR     school 4101980 1976   Bend-LaPine Administrative SD 1 410198000245 1308 Elk Meadow Elementary School   Regular School No Elementary KG 05 2020   k_12_total 432 4 71   0 2     1   21                               432 4 71   0 2     1   21                        
916753 OR     school 4101980 1976   Bend-LaPine Administrative SD 1 410198001438 3219 Highland School at Kenwood Elementary School   Regular School No Elementary KG 05 2020   k_12_total 369 0 7   0 4     1   9                               369 0 7   0 4     1   9                        
916756 OR     school 4101980 1976   Bend-LaPine Administrative SD 1 410198000265 246 Juniper Elementary School   Regular School No Elementary KG 05 2020   k_12_total 360 1 73   3 3     1   16                               360 1 73   3 3     1   16                        
916759 OR     school 4101980 1976   Bend-LaPine Administrative SD 1 410198000264 1310 LaPine Middle School   Regular School No Middle 06 08 2020   k_12_total 313 2 22   7 6     1   4                               313 2 22   7 6     1   4                        
916768 OR     school 4101980 1976   Bend-LaPine Administrative SD 1 410198001576 3947 Pine Ridge Elementary   Regular School No Elementary KG 05 2020   k_12_total 420 3 48   2 12     1   27                               420 3 48   2 12     1   27                        
916769 OR     school 4101980 1976   Bend-LaPine Administrative SD 1 410198001747 4646 Ponderosa Elementary   Regular School No Elementary KG 05 2020   k_12_total 457 4 26   7 7     1   23                               457 4 26   7 7     1   23                        
916770 OR     school 4101980 1976   Bend-LaPine Administrative SD 1 410198000266 247 R E Jewell Elementary School   Regular School No Elementary KG 05 2020   k_12_total 379 4 92   4 7     1   18                               379 4 92   4 7     1   18                        
916774 OR     school 4101980 1976   Bend-LaPine Administrative SD 1 410198001844 5293 Silver Rail Elementary School   Regular School No Elementary KG 05 2020   k_12_total 417 5 72   4 6     1   14                               417 5 72   4 6     1   14                        
916779 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 2020   k_12_total 228 5 12   3 8     1   13                               228 5 12   3 8     1   13                        
916780 OR     school 4101980 1976   Bend-LaPine Administrative SD 1 410198001758 4680 William E Miller Elementary   Regular School No Elementary KG 05 2020   k_12_total 524 1 12   2 3     1   16                               524 1 12   2 3     1   16                        
916804 OR     school 4102310 1974   Brookings-Harbor SD 17C 410231000254 236 Kalmiopsis Elementary School   Regular School No Elementary KG 05 2020   k_12_total 451 1 118   24 5     1   99                               451 1 118   24 5     1   99                        
916808 OR     school 4102640 1929   Canby SD 86 410264001651 4434 Baker Prairie Middle School   Regular School No Middle 07 08 2020   k_12_total 379 1 203   1 8     1   18                               379 1 203   1 8     1   18                        
916809 OR     school 4102640 1929   Canby SD 86 410264000148 140 Canby High School   Regular School No High 09 12 2020   k_12_total 895 3 442   5 11     1   61                               895 3 442   5 11     1   61                        
916811 OR     school 4102640 1929   Canby SD 86 410264000100 92 Carus School   Regular School No Elementary KG 06 2020   k_12_total 356 2 88   3 2     1   23                               356 2 88   3 2     1   23                        
916816 OR     school 4102640 1929   Canby SD 86 410264000130 122 William Knight Elementary School   Regular School No Elementary KG 06 2020   k_12_total 244 0 82   0 3     1   14                               244 0 82   0 3     1   14                        
916827 OR     school 4102800 2185   Centennial SD 28J 410280001221 1367 Centennial Park School   Alternative School No High 07 12 2020   k_12_total 33 4 39   1 5     1   7                               33 4 39   1 5     1   7                        
916831 OR     school 4102800 2185   Centennial SD 28J   5268 Open School East             2020   k_12_total 57 26 31   1 1     1   17                               57 26 31   1 1     1   17                        
916843 OR     school 4102940 2042   Central Point SD 6 410294001739 4561 Crater Renaissance Academy   Regular School No High 09 12 2020   k_12_total 284 2 75   8 5     1   34                               284 2 75   8 5     1   34                        
916844 OR     school 4102940 2042   Central Point SD 6 410294001728 4559 Crater School of Business Innovation and Science   Regular School No High 09 12 2020   k_12_total 335 2 50   0 2     1   36                               335 2 50   0 2     1   36                        
916845 OR     school 4102940 2042   Central Point SD 6 410294000407 387 Hanby Middle School   Regular School No Middle 06 08 2020   k_12_total 253 2 42   3 2     1   27                               253 2 42   3 2     1   27                        
916846 OR     school 4102940 2042   Central Point SD 6 410294000403 383 Jewett Elementary School   Regular School No Elementary KG 05 2020   k_12_total 406 5 186   8 4     1   38                               406 5 186   8 4     1   38                        
916850 OR     school 4102940 2042   Central Point SD 6 410294000408 388 Scenic Middle School   Regular School No Middle 06 08 2020   k_12_total 639 5 154   7 4     1   43                               639 5 154   7 4     1   43                        
916858 OR     school 4103260 1945   Clatskanie SD 6J 410326000178 168 Clatskanie Middle/High School   Regular School No High 07 12 2020   k_12_total 239 1 36   6 4     1   28                               239 1 36   6 4     1   28                        
916859 OR     school 4103270 1927   Colton SD 53 410327000109 103 Colton Elementary School   Regular School No Elementary KG 05 2020   k_12_total 231 0 14   0 0     1   8                               231 0 14   0 0     1   8                        
916867 OR     school 4103660 1965   Coos Bay SD 9 410366004188 3615 Lighthouse Charter School   Regular School Yes Elementary KG 08 2020   k_12_total 181 0 12   5 3     1   19                               181 0 12   5 3     1   19                        
916868 OR     school 4103660 1965   Coos Bay SD 9 410366000211 196 Madison Elementary School   Regular School No Elementary KG 03 2020   k_12_total 267 2 76   13 3     1   21                               267 2 76   13 3     1   21                        
916873 OR     school 4103390 1964   Coquille SD 8 410339000202 191 Coquille Junior Senior High   Regular School No High 07 12 2020   k_12_total 281 1 40   6 0     1   46                               281 1 40   6 0     1   46                        
916877 OR     school 4103390 1964   Coquille SD 8 410339001804 4857 Winter Lakes School   Alternative School No Other 03 12 2020   k_12_total 279 0 30   16 1     1   34                               279 0 30   16 1     1   34                        
916890 OR     school 4103480 1901   Corvallis SD 509J 410348000043 36 Lincoln Elementary School   Regular School No Elementary KG 05 2020   k_12_total 231 4 109   5 1     1   25                               231 4 109   5 1     1   25                        
916897 OR     school 4103690 2086   Creswell SD 40 410369000606 572 Creswell High School   Regular School No High 09 12 2020   k_12_total 272 2 42   9 4     1   18                               272 2 42   9 4     1   18                        
916898 OR     school 4103690 2086   Creswell SD 40 410369000605 571 Creswell Middle School   Regular School No Middle 06 08 2020   k_12_total 240 3 45   4 2     1   18                               240 3 45   4 2     1   18                        
916904 OR     school 4103720 1970   Crook County SD   1970 Crook County SD             2020   k_12_total 19 0 4   0 0     1   2                               19 0 4   0 0     1   2                        
916911 OR     school 4103780 2089   Crow-Applegate-Lorane SD 66 410378000627 592 Crow Middle/High School   Regular School No High 07 12 2020   k_12_total 95 1 5   7 2     1   9                               95 1 5   7 2     1   9                        
916919 OR     school 4103860 2190   Dallas SD 2 410386001045 3461 Luckiamute Valley Charter School   Regular School Yes Elementary KG 08 2020   k_12_total 163 1 16   4 0     1   9                               163 1 16   4 0     1   9                        
916920 OR     school 4103860 2190   Dallas SD 2 410386001043 989 Lyle Elementary School   Regular School No Elementary KG 03 2020   k_12_total 310 5 50   6 0     1   26                               310 5 50   6 0     1   26                        
916923 OR     school 4103860 2190   Dallas SD 2 410386001047 993 Whitworth Elementary School   Regular School No Elementary 04 05 2020   k_12_total 332 1 57   7 1     1   25                               332 1 57   7 1     1   25                        
916928 OR     school 4103940 2187   David Douglas SD 40   2187 David Douglas SD 40             2020   k_12_total 61 16 22   0 30     1   8                               61 16 22   0 30     1   8                        
916942 OR     school 4103990 2253   Dayton SD 8 410399001264 1211 Dayton Grade School   Regular School No Elementary KG 05 2020   k_12_total 257 3 164   5 0     1   17                               257 3 164   5 0     1   17                        
916948 OR     school 4103960 1993   Douglas County SD 15 410396000308 3348 Days Creek Charter School   Regular School Yes Other KG 12 2020   k_12_total 163 0 12   7 0     1   18                               163 0 12   7 0     1   18                        
916952 OR     school 4110710 1991   Douglas County SD 4 411071000290 271 Fullerton IV Elementary School   Regular School No Elementary KG 05 2020   k_12_total 292 2 37   3 3     1   10                               292 2 37   3 3     1   10                        
916969 OR     school 4104500 2043   Eagle Point SD 9 410450000416 396 Eagle Point Middle School   Regular School No Middle 06 08 2020   k_12_total 333 2 75   7 2     1   28                               333 2 75   7 2     1   28                        
916970 OR     school 4104500 2043   Eagle Point SD 9   2043 Eagle Point SD 9             2020   k_12_total 52 0 17   0 0     1   7                               52 0 17   0 0     1   7                        
916999 OR     school 4104740 2082   Eugene SD 4J 410474001344 1240 Charlemagne French Immersion Elementary School   Regular School No Elementary KG 05 2020   k_12_total 241 7 28   1 22     1   53                               241 7 28   1 22     1   53                        
917002 OR     school 4104740 2082   Eugene SD 4J 410474000533 507 Coburg Community Charter School   Regular School Yes Elementary KG 08 2020   k_12_total 196 1 5   0 3     1   17                               196 1 5   0 3     1   17                        
917004 OR     school 4104740 2082   Eugene SD 4J 410474000537 1774 Edgewood Community Elementary School   Regular School No Elementary KG 05 2020   k_12_total 311 5 28   1 13     1   20                               311 5 28   1 13     1   20                        
917009 OR     school 4104740 2082   Eugene SD 4J 410474000542 513 Gilham Elementary School   Regular School No Elementary KG 05 2020   k_12_total 417 17 54   2 17     1   51                               417 17 54   2 17     1   51                        
917011 OR     school 4104740 2082   Eugene SD 4J 410474000544 515 Howard Elementary School   Regular School No Elementary KG 05 2020   k_12_total 328 13 94   17 5     1   50                               328 13 94   17 5     1   50                        
917017 OR     school 4104740 2082   Eugene SD 4J 410474000565 520 Madison Middle School   Regular School No Middle 06 08 2020   k_12_total 316 4 64   5 3     1   39                               316 4 64   5 3     1   39                        
917023 OR     school 4104740 2082   Eugene SD 4J   3760 Pathways and PRD Program             2020   k_12_total 6 1 4   1 0     1   0                               6 1 4   1 0     1   0                        
917034 OR     school 4104740 2082   Eugene SD 4J 410474000555 530 Twin Oaks Elementary School   Regular School No Elementary KG 05 2020   k_12_total 173 2 33   0 6     1   9                               173 2 33   0 6     1   9                        
917039 OR     school 4104740 2082   Eugene SD 4J 410474001348 1259 Yujin Gakuen Elementary School   Regular School No Elementary KG 05 2020   k_12_total 162 0 32   0 20     1   92                               162 0 32   0 20     1   92                        
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                        
917045 OR     school 4104950 2084   Fern Ridge SD 28J 410495000600 564 Fern Ridge Middle School   Regular School No Middle 06 08 2020   k_12_total 328 5 23   6 0     1   12                               328 5 23   6 0     1   12                        
917055 OR     school 4105160 2241   Forest Grove SD 15 410516001578 3986 Fern Hill Elementary School   Regular School No Elementary KG 04 2020   k_12_total 58 2 165   0 4     1   9                               58 2 165   0 4     1   9                        
917063 OR     school 4105160 2241   Forest Grove SD 15 410516001339 1127 Tom McCall Upper Elementary   Regular School No Middle 05 06 2020   k_12_total 326 2 414   4 8     1   27                               326 2 414   4 8     1   27                        
917065 OR     school 4105310 2020   Frenchglen SD 16 410531000370 351 Frenchglen Elementary School   Regular School No Elementary KG 08 2020   k_12_total 2 0 0   0 0     1   0                               2 0 0   0 0     1   0                        
917075 OR     school 4105610 1931   Gladstone SD 115 410561001774 4719 Gladstone Center for Children and Families   Regular School No Elementary PK KG 2020   k_12_total 100 3 20   1 1     1   23                               100 3 20   1 1     1   23                        
917081 OR     school 4105640 2000   Glendale SD 77 410564000327 307 Glendale Community Charter School   Regular School Yes High 09 12 2020   k_12_total 84 1 10   4 0     1   4                               84 1 10   4 0     1   4                        
917082 OR     school 4105640 2000   Glendale SD 77 410564000326 306 Glendale Elementary School   Regular School No Elementary KG 08 2020   k_12_total 164 2 20   4 2     1   2                               164 2 20   4 2     1   2                        
917083 OR     school 4105670 1992   Glide SD 12 410567000302 282 Glide Elementary School   Regular School No Elementary KG 06 2020   k_12_total 374 0 30   2 0     1   24                               374 0 30   2 0     1   24                        
917084 OR     school 4105670 1992   Glide SD 12 410567000305 285 Glide High School   Regular School No High 09 12 2020   k_12_total 180 0 15   3 1     1   12                               180 0 15   3 1     1   12                        
917086 OR     school 4105910 2054   Grants Pass SD 7 410591000457 435 Allen Dale Elementary School   Regular School No Elementary KG 05 2020   k_12_total 354 0 39   2 2     1   35                               354 0 39   2 2     1   35                        
917087 OR     school 4105910 2054   Grants Pass SD 7 410591000464 442 Grants Pass High School   Regular School No High 09 12 2020   k_12_total 1446 8 307   16 21     1   138                               1446 8 307   16 21     1   138                        
917089 OR     school 4105910 2054   Grants Pass SD 7 410591000458 436 Highland Elementary School   Regular School No Elementary KG 05 2020   k_12_total 365 4 43   5 2     1   27                               365 4 43   5 2     1   27                        
917095 OR     school 4105910 2054   Grants Pass SD 7 410591000463 441 South Middle School   Regular School No Middle 06 08 2020   k_12_total 565 5 90   7 5     1   48                               565 5 90   7 5     1   48                        
917097 OR     school 4101120 2100   Greater Albany Public SD 8J 410112000732 632 Calapooia Middle School   Regular School No Middle 06 08 2020   k_12_total 436 5 205   13 1     1   41                               436 5 205   13 1     1   41                        
917106 OR     school 4101120 2100   Greater Albany Public SD 8J 410112000734 638 North Albany Middle School   Regular School No Middle 06 08 2020   k_12_total 396 1 116   4 7     1   37                               396 1 116   4 7     1   37                        
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                        
917121 OR     school 4106000 2183   Gresham-Barlow SD 10J 410600000988 932 Dexter McCarty Middle School   Regular School No Middle 06 08 2020   k_12_total 277 13 193   4 14     1   29                               277 13 193   4 14     1   29                        
917137 OR     school 4106000 2183   Gresham-Barlow SD 10J   5152 Rosemary Anderson High School - East (Gresham)             2020   k_12_total 30 23 63   2 4     1   14                               30 23 63   2 4     1   14                        
917141 OR     school 4106000 2183   Gresham-Barlow SD 10J 410600000996 942 West Orient Middle School   Regular School No Middle 06 08 2020   k_12_total 322 6 89   5 16     1   26                               322 6 89   5 16     1   26                        
917147 OR     school 4103600 2015   Harney County SD 4 410360001870 5446 Oregon Family School   Regular School Yes Other KG 12 2020   k_12_total 396 12 26   0 5     1   38                               396 12 26   0 5     1   38                        
917154 OR     school 4106270 2201   Helix SD 1 410627001084 3364 Helix School   Regular School No Other KG 12 2020   k_12_total 156 0 8   1 4     1   13                               156 0 8   1 4     1   13                        
917155 OR     school 4106300 2206   Hermiston SD 8 410630001096 1039 Armand Larive Middle School   Regular School No Middle 06 08 2020   k_12_total 339 4 441   3 5     1   19                               339 4 441   3 5     1   19                        
917161 OR     school 4106300 2206   Hermiston SD 8 410630000677 1333 Sandstone Middle School   Regular School No Middle 06 08 2020   k_12_total 229 5 305   2 10     1   14                               229 5 305   2 10     1   14                        
917163 OR     school 4106300 2206   Hermiston SD 8 410630001095 1038 West Park Elementary School   Regular School No Elementary KG 05 2020   k_12_total 162 3 381   1 0     1   10                               162 3 381   1 0     1   10                        
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                        
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                        

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