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,773
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
657472 OR     school 4107500 2097   Lincoln County SD 410750000660 625 Sam Case Elementary   Regular School No Elementary 03 05 2021   k_12_total 205 1 149   8 5     1   32                               205 1 149   8 5     1   32                        
657473 OR     school 4107500 2097   Lincoln County SD 410750001590 4038 Siletz Valley Schools   Regular School Yes Other KG 12 2021   k_12_total 71 1 19   64 0     1   33                               71 1 19   64 0     1   33                        
657474 OR     school 4107500 2097   Lincoln County SD 410750000655 620 Taft Elementary School   Regular School No Elementary 03 06 2021   k_12_total 300 4 115   10 6     1   47                               300 4 115   10 6     1   47                        
657475 OR     school 4107500 2097   Lincoln County SD 410750000665 628 Taft High School   Regular School No High 09 12 2021   k_12_total 268 1 134   11 6     1   39                               268 1 134   11 6     1   39                        
657476 OR     school 4107500 2097   Lincoln County SD 410750000984 621 Taft Middle School   Regular School No Middle 07 08 2021   k_12_total 155 0 67   7 5     1   17                               155 0 67   7 5     1   17                        
657482 OR     school 4107500 2097   Lincoln County SD 410750000653 618 Yaquina View Elementary   Regular School No Elementary KG 02 2021   k_12_total 186 3 133   2 3     1   31                               186 3 133   2 3     1   31                        
657501 OR     school 4108010 2256   McMinnville SD 40 410801001433 2784 Grandhaven Elementary School   Regular School No Elementary KG 05 2021   k_12_total 220 3 178   6 6     1   8                               220 3 178   6 6     1   8                        
657508 OR     school 4108040 2048   Medford SD 549C 410804000963 1350 Abraham Lincoln Elementary   Regular School No Elementary KG 06 2021   k_12_total 329 2 73   3 3     1   20                               329 2 73   3 3     1   20                        
657510 OR     school 4108040 2048   Medford SD 549C 410804000428 408 Griffin Creek Elementary School   Regular School No Elementary KG 06 2021   k_12_total 334 1 104   3 0     1   20                               334 1 104   3 0     1   20                        
657524 OR     school 4108040 2048   Medford SD 549C   2048 Medford SD 549C             2021   k_12_total 193 6 67   4 2     1   16                               193 6 67   4 2     1   16                        
657528 OR     school 4108040 2048   Medford SD 549C 410804000438 418 Ruch Outdoor Community School   Regular School No Elementary KG 08 2021   k_12_total 140 0 20   2 0     1   14                               140 0 20   2 0     1   14                        
657530 OR     school 4108040 2048   Medford SD 549C 410804001843 5304 The Valley School of Southern Oregon   Regular School Yes Middle 06 08 2021   k_12_total 99 1 13   0 2     1   4                               99 1 13   0 2     1   4                        
657534 OR     school 4108160 2205   Milton-Freewater Unified SD 7 410816001842 5296 Ferndale Elementary School   Regular School No Elementary 04 05 2021   k_12_total 93 3 161   0 2     1   2                               93 3 161   0 2     1   2                        
657536 OR     school 4108160 2205   Milton-Freewater Unified SD 7 410816001123 1064 McLoughlin High School   Regular School No High 09 12 2021   k_12_total 168 1 308   1 2     1   6                               168 1 308   1 2     1   6                        
657548 OR     school 4108310 1925   Molalla River SD 35 410831000129 121 Mulino Elementary School   Regular School No Elementary KG 05 2021   k_12_total 197 0 25   1 3     1   11                               197 0 25   1 3     1   11                        
657549 OR     school 4108310 1925   Molalla River SD 35 410831001800 4818 Renaissance Public Academy   Regular School Yes Other 03 12 2021   k_12_total 67 1 12   0 0     1   3                               67 1 12   0 0     1   3                        
657550 OR     school 4108310 1925   Molalla River SD 35 410831000136 128 Rural Dell Elementary School   Regular School No Elementary KG 05 2021   k_12_total 157 0 37   7 0     1   7                               157 0 37   7 0     1   7                        
657557 OR     school 4108520 2147   Morrow SD 1 410852001598 4048 Irrigon Elementary School   Regular School No Middle 04 06 2021   k_12_total 67 0 104   1 0     1   9                               67 0 104   1 0     1   9                        
657561 OR     school 4108520 2147   Morrow SD 1 410852000863 820 Riverside Junior/Senior High School   Regular School No High 07 12 2021   k_12_total 80 1 369   1 1     1   4                               80 1 369   1 1     1   4                        
657562 OR     school 4108520 2147   Morrow SD 1 410852001311 814 Sam Boardman Elementary School   Regular School No Elementary KG 03 2021   k_12_total 67 1 249   0 1     1   3                               67 1 249   0 1     1   3                        
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                        
657580 OR     school 4108650 2198   Neah-Kah-Nie SD 56 410865001656 4481 Neah-Kah-Nie Middle School   Regular School No Middle 06 08 2021   k_12_total 141 2 27   3 1     1   13                               141 2 27   3 1     1   13                        
657581 OR     school 4108650 2198   Neah-Kah-Nie SD 56 410865001080 1021 Nehalem Elementary School   Regular School No Elementary KG 05 2021   k_12_total 116 1 21   0 0     1   10                               116 1 21   0 0     1   10                        
657591 OR     school 4108720 2254   Newberg SD 29J 410872001273 1221 Mountain View Middle School   Regular School No Middle 06 08 2021   k_12_total 275 6 138   2 9     1   14                               275 6 138   2 9     1   14                        
657593 OR     school 4108720 2254   Newberg SD 29J 410872001274 1222 Newberg Senior High School   Regular School No High 09 12 2021   k_12_total 1019 16 317   11 28     1   61                               1019 16 317   11 28     1   61                        
657594 OR     school 4108820 1966   North Bend SD 13 410882000219 204 Hillcrest Elementary School   Regular School No Elementary KG 05 2021   k_12_total 340 4 63   6 15     1   36                               340 4 63   6 15     1   36                        
657596 OR     school 4108820 1966   North Bend SD 13 410882000221 205 North Bay Elementary School   Regular School No Elementary KG 05 2021   k_12_total 348 1 35   8 3     1   36                               348 1 35   8 3     1   36                        
657602 OR     school 4108830 1924   North Clackamas SD 12 410883000070 4762 Ardenwald Elementary School   Regular School No Elementary KG 05 2021   k_12_total 271 12 61   2 6     1   37                               271 12 61   2 6     1   37                        
657604 OR     school 4108830 1924   North Clackamas SD 12 410883000072 65 Bilquist Elementary School   Regular School No Elementary KG 05 2021   k_12_total 248 12 58   1 15     1   37                               248 12 58   1 15     1   37                        
657609 OR     school 4108830 1924   North Clackamas SD 12 410883000076 4763 Happy Valley Elementary School   Regular School No Elementary KG 05 2021   k_12_total 256 7 29   0 76     1   41                               256 7 29   0 76     1   41                        
657613 OR     school 4108830 1924   North Clackamas SD 12 410883001686 4369 Milwaukie Academy of the Arts   Regular School Yes High 09 12 2021   k_12_total 213 5 42   0 2     1   27                               213 5 42   0 2     1   27                        
657623 OR     school 4108830 1924   North Clackamas SD 12 410883000084 76 Riverside Elementary School   Regular School No Elementary KG 05 2021   k_12_total 207 1 109   2 3     1   15                               207 1 109   2 3     1   15                        
657624 OR     school 4108830 1924   North Clackamas SD 12 410883001379 4767 Rock Creek Middle School   Regular School No Middle 06 08 2021   k_12_total 495 16 156   2 108     1   64                               495 16 156   2 108     1   64                        
657626 OR     school 4108830 1924   North Clackamas SD 12 410883001775 4713 Scouters Mountain Elementary   Regular School No Elementary KG 05 2021   k_12_total 175 10 37   3 75     1   34                               175 10 37   3 75     1   34                        
657628 OR     school 4108830 1924   North Clackamas SD 12 410883001483 3198 Spring Mountain Elementary School   Regular School No Elementary KG 05 2021   k_12_total 244 7 35   2 73     1   56                               244 7 35   2 73     1   56                        
657635 OR     school 4111400 2061   North Lake SD 14 411140001381 1289 North Lake School   Regular School No Other KG 12 2021   k_12_total 192 0 19   2 1     1   18                               192 0 19   2 1     1   18                        
657636 OR     school 4108880 2141   North Marion SD 15 410888000772 726 North Marion High School   Regular School No High 09 12 2021   k_12_total 275 1 318   1 4     1   23                               275 1 318   1 4     1   23                        
657637 OR     school 4108880 2141   North Marion SD 15 410888000771 724 North Marion Intermediate School   Regular School No Elementary 03 05 2021   k_12_total 153 1 210   0 3     1   15                               153 1 210   0 3     1   15                        
657638 OR     school 4108880 2141   North Marion SD 15 410888001326 725 North Marion Middle School   Regular School No Middle 06 08 2021   k_12_total 162 0 230   1 2     1   12                               162 0 230   1 2     1   12                        
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                        
657665 OR     school 4109120 1990   Oakland SD 1 410912000287 268 Oakland High School   Regular School No High 09 12 2021   k_12_total 176 0 20   5 0     1   2                               176 0 20   5 0     1   2                        
657667 OR     school 4109150 2093   Oakridge SD 76 410915000637 602 Oakridge High School   Regular School No High 09 12 2021   k_12_total 132 4 13   6 2     1   0                               132 4 13   6 2     1   0                        
657668 OR     school 4109150 2093   Oakridge SD 76 410915000636 601 Oakridge Junior High School   Regular School No Middle 07 08 2021   k_12_total 70 5 5   2 0     1   4                               70 5 5   2 0     1   4                        
657671 OR     school   3476   ODE JDEP District   2848 Donald E Long School             2021   k_12_total 10 12 6   1 0     1   3                               10 12 6   1 0     1   3                        
657675 OR     school   3476   ODE JDEP District   2841 Lane County Dept of Youth             2021   k_12_total 3 0 0   0 0     1   0                               3 0 0   0 0     1   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                        
657710 OR     school 4109330 1928   Oregon City SD 62 410933000147 139 Redland Elementary School   Regular School No Elementary KG 05 2021   k_12_total 321 5 38   2 3     1   33                               321 5 38   2 3     1   33                        
657718 OR     school 4110890 1926   Oregon Trail SD 46 411089000108 102 Cedar Ridge Middle School   Regular School No Middle 06 08 2021   k_12_total 324 2 60   0 6     1   26                               324 2 60   0 6     1   26                        
657719 OR     school 4110890 1926   Oregon Trail SD 46 411089000107 101 Firwood Elementary School   Regular School No Elementary KG 05 2021   k_12_total 317 2 74   4 4     1   34                               317 2 74   4 4     1   34                        
657720 OR     school 4110890 1926   Oregon Trail SD 46 411089001297 99 Kelso Elementary School   Regular School No Elementary KG 05 2021   k_12_total 276 3 20   1 4     1   21                               276 3 20   1 4     1   21                        
657727 OR     school 4110890 1926   Oregon Trail SD 46 411089001453 2392 Welches Middle School   Regular School No Middle 06 08 2021   k_12_total 82 0 12   1 0     1   4                               82 0 12   1 0     1   4                        
657747 OR     school 4109600 1900   Philomath SD 17J 410960001481 3162 Clemens Primary School   Regular School No Elementary KG 01 2021   k_12_total 113 0 19   1 0     1   3                               113 0 19   1 0     1   3                        
657755 OR     school 4109630 2039   Phoenix-Talent SD 4 410963000391 371 Phoenix Elementary School   Regular School No Elementary KG 05 2021   k_12_total 132 2 174   2 0     1   19                               132 2 174   2 0     1   19                        
657758 OR     school 4109630 2039   Phoenix-Talent SD 4 410963000392 372 Talent Elementary School   Regular School No Elementary KG 05 2021   k_12_total 225 0 154   0 3     1   18                               225 0 154   0 3     1   18                        
657763 OR     school 4109720 1897   Pine Eagle SD 61 410972000016 15 Pine Eagle Charter School   Regular School Yes Other KG 12 2021   k_12_total 166 0 15   1 0     1   9                               166 0 15   1 0     1   9                        
657774 OR     school 4110040 2180   Portland SD 1J 411004000865 822 Abernethy Elementary School   Regular School No Elementary KG 05 2021   k_12_total 367 4 28   0 11     1   39                               367 4 28   0 11     1   39                        
657780 OR     school 4110040 2180   Portland SD 1J 411004000871 828 Atkinson Elementary School   Regular School No Elementary KG 05 2021   k_12_total 248 8 102   1 7     1   25                               248 8 102   1 7     1   25                        
657784 OR     school 4110040 2180   Portland SD 1J 411004000901 857 Beverly Cleary School   Regular School No Elementary KG 08 2021   k_12_total 546 9 51   3 15     1   66                               546 9 51   3 15     1   66                        
657790 OR     school 4110040 2180   Portland SD 1J 411004000881 838 Capitol Hill Elementary School   Regular School No Elementary KG 05 2021   k_12_total 265 9 33   2 10     1   26                               265 9 33   2 10     1   26                        
657797 OR     school 4110040 2180   Portland SD 1J 411004001079 1363 da Vinci Middle School   Regular School No Middle 06 08 2021   k_12_total 287 31 41   1 8     1   74                               287 31 41   1 8     1   74                        
657814 OR     school 4110040 2180   Portland SD 1J 411004000905 861 Irvington Elementary School   Regular School No Elementary KG 05 2021   k_12_total 194 39 32   0 4     1   50                               194 39 32   0 4     1   50                        
657822 OR     school 4110040 2180   Portland SD 1J 411004000913 868 Laurelhurst Elementary School   Regular School No Elementary KG 08 2021   k_12_total 540 13 48   1 15     1   69                               540 13 48   1 15     1   69                        
657824 OR     school 4110040 2180   Portland SD 1J 411004000914 869 Lee Elementary School   Regular School No Elementary KG 05 2021   k_12_total 103 39 49   2 38     1   31                               103 39 49   2 38     1   31                        
657826 OR     school 4110040 2180   Portland SD 1J 411004000916 871 Lewis Elementary School   Regular School No Elementary KG 05 2021   k_12_total 283 3 34   0 11     1   36                               283 3 34   0 11     1   36                        
657828 OR     school 4110040 2180   Portland SD 1J 411004000917 872 Llewellyn Elementary School   Regular School No Elementary KG 05 2021   k_12_total 354 2 49   0 6     1   49                               354 2 49   0 6     1   49                        
657834 OR     school 4110040 2180   Portland SD 1J   1648 Morrison Center Counterpoint Program             2021   k_12_total 3 0 2   0 0     1   1                               3 0 2   0 0     1   1                        
657864 OR     school 4110040 2180   Portland SD 1J 411004000936 888 Sellwood Middle School   Regular School No Middle 06 08 2021   k_12_total 425 7 37   1 8     1   71                               425 7 37   1 8     1   71                        
657867 OR     school 4110040 2180   Portland SD 1J 411004000938 890 Skyline Elementary School   Regular School No Elementary KG 08 2021   k_12_total 137 0 17   0 7     1   19                               137 0 17   0 7     1   19                        
657869 OR     school 4110040 2180   Portland SD 1J 411004000941 893 Sunnyside Environmental School   Regular School No Elementary KG 08 2021   k_12_total 380 9 59   1 7     1   68                               380 9 59   1 7     1   68                        
657873 OR     school 4110040 2180   Portland SD 1J 411004000947 898 West Sylvan Middle School   Regular School No Middle 06 08 2021   k_12_total 537 27 71   3 71     1   90                               537 27 71   3 71     1   90                        
657880 OR     school 4110040 2180   Portland SD 1J 411004000954 904 Woodstock Elementary School   Regular School No Elementary KG 05 2021   k_12_total 268 1 31   0 133     1   94                               268 1 31   0 133     1   94                        
657884 OR     school 4110110 2009   Prairie City SD 4 411011000352 3349 Prairie City School   Regular School No Other KG 12 2021   k_12_total 153 0 10   4 0     1   7                               153 0 10   4 0     1   7                        
657890 OR     school 4110350 1977   Redmond SD 2J 411035000647 1326 Elton Gregory Middle School   Regular School No Middle 06 08 2021   k_12_total 559 4 132   4 8     1   30                               559 4 132   4 8     1   30                        
657893 OR     school 4110350 1977   Redmond SD 2J 411035000278 259 M A Lynch Elementary School   Regular School No Elementary KG 05 2021   k_12_total 189 3 80   1 1     1   14                               189 3 80   1 1     1   14                        
657894 OR     school 4110350 1977   Redmond SD 2J 411035000281 262 Obsidian Middle School   Regular School No Middle 06 08 2021   k_12_total 454 2 156   1 3     1   20                               454 2 156   1 3     1   20                        
657899 OR     school 4110350 1977   Redmond SD 2J   1977 Redmond SD 2J             2021   k_12_total 331 2 71   3 3     1   18                               331 2 71   3 3     1   18                        
657902 OR     school 4110350 1977   Redmond SD 2J 411035000279 260 Terrebonne Community School   Regular School No Elementary KG 05 2021   k_12_total 205 1 19   3 0     1   14                               205 1 19   3 0     1   14                        
657904 OR     school 4110350 1977   Redmond SD 2J 411035000280 261 Tumalo Community School   Regular School No Elementary KG 05 2021   k_12_total 178 0 21   1 0     1   12                               178 0 21   1 0     1   12                        
657927 OR     school 4110520 2182   Reynolds SD 7 411052001209 1365 Woodland Elementary   Regular School No Elementary KG 05 2021   k_12_total 123 10 203   4 19     1   17                               123 10 203   4 19     1   17                        
657930 OR     school 4110560 2188   Riverdale SD 51J 411056001039 985 Riverdale Grade School   Regular School No Elementary KG 08 2021   k_12_total 294 1 25   0 20     1   36                               294 1 25   0 20     1   36                        
657933 OR     school 4110680 2044   Rogue River SD 35 411068001811 4856 Rivers Edge Academy Charter School   Regular School Yes Other KG 12 2021   k_12_total 174 0 16   3 0     1   15                               174 0 16   3 0     1   15                        
657945 OR     school 4110820 2142   Salem-Keizer SD 24J 411082000780 734 Clear Lake Elementary School   Regular School No Elementary KG 05 2021   k_12_total 221 11 84   1 12     1   28                               221 11 84   1 12     1   28                        
657954 OR     school 4110820 2142   Salem-Keizer SD 24J 411082000791 745 Gubser Elementary School   Regular School No Elementary KG 05 2021   k_12_total 264 9 147   2 9     1   40                               264 9 147   2 9     1   40                        
657962 OR     school 4110820 2142   Salem-Keizer SD 24J 411082001048 1358 Howard Street Charter   Regular School Yes Middle 06 08 2021   k_12_total 145 4 24   0 8     1   6                               145 4 24   0 8     1   6                        
657986 OR     school 4110820 2142   Salem-Keizer SD 24J   2142 Salem-Keizer SD 24J             2021   k_12_total 111 4 55   4 1     1   8                               111 4 55   4 1     1   8                        
657987 OR     school 4110820 2142   Salem-Keizer SD 24J 411082000806 760 Schirle Elementary School   Regular School No Elementary KG 05 2021   k_12_total 253 3 42   4 12     1   20                               253 3 42   4 12     1   20                        
657995 OR     school 4110820 2142   Salem-Keizer SD 24J 411082001683 4390 Valley Inquiry Charter School   Regular School Yes Elementary KG 05 2021   k_12_total 103 0 39   0 1     1   23                               103 0 39   0 1     1   23                        
658007 OR     school 4110980 1944   Scappoose SD 1J 411098000168 158 Grant Watts Elementary School   Regular School No Elementary KG 03 2021   k_12_total 227 1 35   0 1     1   40                               227 1 35   0 1     1   40                        
658014 OR     school 4110980 1944   Scappoose SD 1J 411098001542 4221 South Columbia Family School   Regular School Yes Elementary KG 08 2021   k_12_total 65 0 8   0 0     1   3                               65 0 8   0 0     1   3                        
658016 OR     school 4111040 2103   Scio SD 95 411104000716 676 Centennial Elementary School   Regular School No Elementary KG 05 2021   k_12_total 230 1 28   4 0     1   11                               230 1 28   4 0     1   11                        
658028 OR     school 4111220 2257   Sheridan SD 48J 411122001285 1235 Faulconer-Chapman School   Regular School No Elementary KG 08 2021   k_12_total 310 0 69   32 1     1   42                               310 0 69   32 1     1   42                        
658037 OR     school 4111290 2244   Sherwood SD 88J 411129001772 4730 Ridges Elementary School   Regular School No Elementary KG 05 2021   k_12_total 444 5 78   1 42     1   48                               444 5 78   1 42     1   48                        
658043 OR     school 4111450 2138   Silver Falls SD 4J 411145000127 119 Butte Creek Elementary School   Regular School No Elementary KG 08 2021   k_12_total 194 0 50   0 0     1   7                               194 0 50   0 0     1   7                        
658046 OR     school 4111450 2138   Silver Falls SD 4J 411145000762 714 Mark Twain Elementary   Regular School No Elementary KG 02 2021   k_12_total 210 1 65   4 1     1   7                               210 1 65   4 1     1   7                        
658058 OR     school 4105100 2096   Siuslaw SD 97J 410510000644 609 Siuslaw Elementary School   Regular School No Elementary KG 05 2021   k_12_total 417 2 29   7 7     1   39                               417 2 29   7 7     1   39                        
658059 OR     school 4105100 2096   Siuslaw SD 97J 410510000645 610 Siuslaw High School   Regular School No High 09 12 2021   k_12_total 282 1 42   8 6     1   53                               282 1 42   8 6     1   53                        
658072 OR     school 4111580 2087   South Lane SD 45J3 411158000613 578 London School   Regular School No Elementary KG 08 2021   k_12_total 79 0 2   2 0     1   6                               79 0 2   2 0     1   6                        
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                        
658088 OR     school 4111670 2083   Springfield SD 19 411167001641 4440 Academy of Arts and Academics   Regular School No High 09 12 2021   k_12_total 159 0 21   1 1     1   18                               159 0 21   1 1     1   18                        
658089 OR     school 4111670 2083   Springfield SD 19 411167000977 1353 Agnes Stewart Middle School   Regular School No Middle 06 08 2021   k_12_total 324 5 177   4 1     1   37                               324 5 177   4 1     1   37                        

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