enrollments

Data source: Big Local News · About: Big Local

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

✎ View and edit SQL

This data as json, CSV (advanced)

grade ✖

year ✖

  • 2021 · 20,494 ✖
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
658150 658150 OR     school 4106900 2055   Three Rivers/Josephine County SD 410690000471 449 Lorna Byrne Middle School   Regular School No Middle 05 08 2021   k_12_total 252 5 44   5 0     3   20                               252 5 44   5 0     3   20                        
658149 658149 OR     school 4106900 2055   Three Rivers/Josephine County SD 410690000470 448 Lincoln Savage Middle School   Regular School No Middle 06 08 2021   k_12_total 297 0 37   6 3     0   17                               297 0 37   6 3     0   17                        
658148 658148 OR     school 4106900 2055   Three Rivers/Josephine County SD 410690000480 456 Illinois Valley High School   Regular School No High 09 12 2021   k_12_total 209 5 30   6 1     1   16                               209 5 30   6 1     1   16                        
658147 658147 OR     school 4106900 2055   Three Rivers/Josephine County SD 410690000479 455 Hidden Valley High School   Regular School No High 09 12 2021   k_12_total 456 3 77   11 4     2   45                               456 3 77   11 4     2   45                        
658146 658146 OR     school 4106900 2055   Three Rivers/Josephine County SD 410690000468 446 Ft Vannoy Elementary School   Regular School No Elementary KG 05 2021   k_12_total 191 0 44   1 2     0   15                               191 0 44   1 2     0   15                        
658145 658145 OR     school 4106900 2055   Three Rivers/Josephine County SD 410690000467 445 Fruitdale Elementary School   Regular School No Elementary KG 05 2021   k_12_total 228 1 41   0 1     1   28                               228 1 41   0 1     1   28                        
658144 658144 OR     school 4106900 2055   Three Rivers/Josephine County SD 410690000466 444 Fleming Middle School   Regular School No Middle 06 08 2021   k_12_total 271 3 50   2 0     0   39                               271 3 50   2 0     0   39                        
658143 658143 OR     school 4106900 2055   Three Rivers/Josephine County SD 410690000465 443 Evergreen Elementary School   Regular School No Elementary KG 04 2021   k_12_total 255 3 40   3 0     0   28                               255 3 40   3 0     0   28                        
658142 658142 OR     school 4106900 2055   Three Rivers/Josephine County SD 410690000422 402 Applegate Elementary School   Regular School No Elementary KG 08 2021   k_12_total 74 0 16   3 0     0   4                               74 0 16   3 0     0   4                        
658141 658141 OR     school 4111970 2102   Sweet Home SD 55 411197000707 668 Sweet Home Junior High School   Regular School No Middle 07 08 2021   k_12_total 278 1 22   7 3     0   30                               278 1 22   7 3     0   30                        
658140 658140 OR     school 4111970 2102   Sweet Home SD 55 411197000708 669 Sweet Home High School   Regular School No High 09 12 2021   k_12_total 572 1 49   12 4     1   36                               572 1 49   12 4     1   36                        
658139 658139 OR     school 4111970 2102   Sweet Home SD 55 411197001643 4484 Sweet Home Charter School   Regular School Yes Elementary KG 06 2021   k_12_total 123 0 5   1 0     0   3                               123 0 5   1 0     0   3                        
658138 658138 OR     school 4111970 2102   Sweet Home SD 55 411197000706 666 Oak Heights Elementary School   Regular School No Elementary KG 06 2021   k_12_total 190 0 19   4 1     0   20                               190 0 19   4 1     0   20                        
658137 658137 OR     school 4111970 2102   Sweet Home SD 55 411197000703 664 Holley Elementary School   Regular School No Elementary KG 06 2021   k_12_total 120 0 13   0 0     0   2                               120 0 13   0 0     0   2                        
658136 658136 OR     school 4111970 2102   Sweet Home SD 55 411197000702 663 Hawthorne Elementary School   Regular School No Elementary KG 06 2021   k_12_total 253 0 21   5 4     0   19                               253 0 21   5 4     0   19                        
658135 658135 OR     school 4111970 2102   Sweet Home SD 55 411197000701 662 Foster Elementary School   Regular School No Elementary KG 06 2021   k_12_total 249 1 27   4 1     1   30                               249 1 27   4 1     1   30                        
658134 658134 OR     school 4111940 2003   Sutherlin SD 130 411194000340 320 West Sutherlin Intermediate   Regular School No Elementary 03 05 2021   k_12_total 229 1 35   4 1     0   18                               229 1 35   4 1     0   18                        
658133 658133 OR     school 4111940 2003   Sutherlin SD 130 411194001849 5357 Sutherlin Valley Online Academy   Regular School No Other 03 12 2021   k_12_total 39 0 9   1 0     0   4                               39 0 9   1 0     0   4                        
658132 658132 OR     school 4111940 2003   Sutherlin SD 130 411194000339 319 Sutherlin Middle School   Regular School No Middle 06 08 2021   k_12_total 268 1 36   2 2     1   11                               268 1 36   2 2     1   11                        
658131 658131 OR     school 4111940 2003   Sutherlin SD 130 411194000341 321 Sutherlin High School   Regular School No High 09 12 2021   k_12_total 277 0 47   10 2     1   21                               277 0 47   10 2     1   21                        
658130 658130 OR     school 4111940 2003   Sutherlin SD 130 411194000338 318 East Sutherlin Primary School   Regular School No Elementary PK 02 2021   k_12_total 255 0 51   1 2     0   8                               255 0 51   1 2     0   8                        
658129 658129 OR     school 4111910 2018   Suntex SD 10 411191000368 349 Suntex Elementary School   Regular School No Elementary KG 08 2021   k_12_total 2 0 0   0 0     0   0                               2 0 0   0 0     0   0                        
658128 658128 OR     school 4111790 2209   Stanfield SD 61 411179001120 1061 Stanfield Secondary School   Regular School No High 06 12 2021   k_12_total 143 3 130   5 2     2   8                               143 3 130   5 2     2   8                        
658127 658127 OR     school 4111790 2209   Stanfield SD 61 411179001119 1060 Stanfield Elementary School   Regular School No Elementary KG 05 2021   k_12_total 95 0 108   0 0     0   4                               95 0 108   0 0     0   4                        
658126 658126 OR     school 4111760 2144   St Paul SD 45 411176000824 779 St Paul High School   Regular School No High 07 12 2021   k_12_total 99 1 50   0 0     0   2                               99 1 50   0 0     0   2                        
658125 658125 OR     school 4111760 2144   St Paul SD 45 411176000823 778 St Paul Elementary School   Regular School No Elementary PK 06 2021   k_12_total 79 0 56   0 0     0   2                               79 0 56   0 0     0   2                        
658124 658124 OR     school 4111720 1948   St Helens SD 502   1948 St Helens SD 502             2021   k_12_total 54 1 9   3 0     0   2                               54 1 9   3 0     0   2                        
658123 658123 OR     school 4111720 1948   St Helens SD 502 411172000195 184 St Helens Middle School   Regular School No Middle 06 08 2021   k_12_total 481 5 62   11 6     3   45                               481 5 62   11 6     3   45                        
658122 658122 OR     school 4111720 1948   St Helens SD 502 411172000196 185 St Helens High School   Regular School No High 09 12 2021   k_12_total 651 4 84   5 8     2   44                               651 4 84   5 8     2   44                        
658121 658121 OR     school 4111720 1948   St Helens SD 502 411172001732 4602 St Helens Arthur Academy   Regular School Yes Elementary KG 06 2021   k_12_total 175 0 19   3 0     1   3                               175 0 19   3 0     1   3                        
658120 658120 OR     school 4111720 1948   St Helens SD 502 411172001599 2716 Plymouth High School   Alternative School No High 09 12 2021   k_12_total 46 0 9   0 0     0   9                               46 0 9   0 0     0   9                        
658119 658119 OR     school 4111720 1948   St Helens SD 502 411172000193 182 McBride Elementary School   Regular School No Elementary KG 05 2021   k_12_total 340 4 36   5 3     0   17                               340 4 36   5 3     0   17                        
658118 658118 OR     school 4111720 1948   St Helens SD 502 411172004195 3569 Lewis & Clark Elementary School   Regular School No Elementary KG 05 2021   k_12_total 254 1 55   2 0     0   36                               254 1 55   2 0     0   36                        
658117 658117 OR     school 4111720 1948   St Helens SD 502 411172000189 179 Columbia City School   Regular School No Elementary KG 05 2021   k_12_total 122 3 23   2 1     0   6                               122 3 23   2 1     0   6                        
658116 658116 OR     school 4111670 2083   Springfield SD 19 411167000589 559 Yolanda Elementary School   Regular School No Elementary KG 05 2021   k_12_total 220 1 47   0 2     0   12                               220 1 47   0 2     0   12                        
658115 658115 OR     school 4111670 2083   Springfield SD 19 411167001525 4058 Willamette Leadership Academy   Regular School Yes High 06 12 2021   k_12_total 179 4 24   5 4     0   16                               179 4 24   5 4     0   16                        
658114 658114 OR     school 4111670 2083   Springfield SD 19   1545 Wellsprings Friends School             2021   k_12_total - - -   - -     -   -                                                                            
658113 658113 OR     school 4111670 2083   Springfield SD 19 411167000588 558 Walterville Elementary School   Regular School No Elementary KG 05 2021   k_12_total 91 0 5   3 0     0   13                               91 0 5   3 0     0   13                        
658112 658112 OR     school 4111670 2083   Springfield SD 19 411167001815 5059 Two Rivers Dos Rios Elementary   Regular School No Elementary KG 05 2021   k_12_total 217 3 110   2 1     0   19                               217 3 110   2 1     0   19                        
658111 658111 OR     school 4111670 2083   Springfield SD 19 411167000593 557 Thurston Middle School   Regular School No Middle 06 08 2021   k_12_total 395 5 55   7 4     3   36                               395 5 55   7 4     3   36                        
658110 658110 OR     school 4111670 2083   Springfield SD 19 411167000595 561 Thurston High School   Regular School No High 09 12 2021   k_12_total 921 16 174   11 6     8   108                               921 16 174   11 6     8   108                        
658109 658109 OR     school 4111670 2083   Springfield SD 19 411167000587 556 Thurston Elementary School   Regular School No Elementary KG 05 2021   k_12_total 241 1 29   0 0     1   46                               241 1 29   0 0     1   46                        
658108 658108 OR     school 4111670 2083   Springfield SD 19   1252 The Child Center             2021   k_12_total 33 0 2   0 0     0   1                               33 0 2   0 0     0   1                        
658107 658107 OR     school 4111670 2083   Springfield SD 19   2083 Springfield SD 19             2021   k_12_total 995 3 205   8 6     3   81                               995 3 205   8 6     3   81                        
658106 658106 OR     school 4111670 2083   Springfield SD 19 411167000594 560 Springfield High School   Regular School No High 09 12 2021   k_12_total 744 21 427   18 13     11   109                               744 21 427   18 13     11   109                        
658105 658105 OR     school 4111670 2083   Springfield SD 19   1789 SAFE Center School             2021   k_12_total 10 2 1   0 0     0   2                               10 2 1   0 0     0   2                        
658104 658104 OR     school 4111670 2083   Springfield SD 19 411167000973 1352 Riverbend Elementary School   Regular School No Elementary KG 05 2021   k_12_total 213 1 64   6 1     6   22                               213 1 64   6 1     6   22                        
658103 658103 OR     school 4111670 2083   Springfield SD 19 411167001330 553 Ridgeview Elementary School   Regular School No Elementary KG 05 2021   k_12_total 208 4 36   0 1     0   15                               208 4 36   0 1     0   15                        
658102 658102 OR     school 4111670 2083   Springfield SD 19 411167000586 554 Mt Vernon Elementary School   Regular School No Elementary KG 05 2021   k_12_total 180 5 136   5 8     1   18                               180 5 136   5 8     1   18                        
658101 658101 OR     school 4111670 2083   Springfield SD 19 411167000583 550 Maple Elementary School   Regular School No Elementary KG 05 2021   k_12_total 169 0 38   2 0     3   6                               169 0 38   2 0     3   6                        
658100 658100 OR     school 4111670 2083   Springfield SD 19   1532 Looking Glass Riverfront School & Career Center             2021   k_12_total 1 0 0   0 0     0   0                               1 0 0   0 0     0   0                        
658099 658099 OR     school 4111670 2083   Springfield SD 19   3545 Looking Glass Center Point School             2021   k_12_total 2 0 1   0 0     0   0                               2 0 1   0 0     0   0                        
658098 658098 OR     school 4111670 2083   Springfield SD 19   1792 Jasper Mountain Center             2021   k_12_total 16 0 2   1 0     1   1                               16 0 2   1 0     1   1                        
658097 658097 OR     school 4111670 2083   Springfield SD 19 411167000591 549 Hamlin Middle School   Regular School No Middle 06 08 2021   k_12_total 337 8 216   9 6     3   45                               337 8 216   9 6     3   45                        
658096 658096 OR     school 4111670 2083   Springfield SD 19 411167000582 548 Guy Lee Elementary School   Regular School No Elementary KG 05 2021   k_12_total 126 9 107   3 1     10   16                               126 9 107   3 1     10   16                        
658095 658095 OR     school 4111670 2083   Springfield SD 19 411167000978 1354 Gateways High School   Regular School No High 09 12 2021   k_12_total 31 3 19   5 0     0   4                               31 3 19   5 0     0   4                        
658094 658094 OR     school 4111670 2083   Springfield SD 19 411167000580 546 Elizabeth Page Elementary School   Regular School No Elementary KG 05 2021   k_12_total 178 4 59   0 3     0   19                               178 4 59   0 3     0   19                        
658093 658093 OR     school 4111670 2083   Springfield SD 19 411167000579 545 Douglas Gardens Elementary School   Regular School No Elementary KG 05 2021   k_12_total 160 0 69   2 1     1   7                               160 0 69   2 1     1   7                        
658092 658092 OR     school 4111670 2083   Springfield SD 19 411167000578 544 Centennial Elementary School   Regular School No Elementary KG 05 2021   k_12_total 146 3 76   1 1     0   9                               146 3 76   1 1     0   9                        
658091 658091 OR     school 4111670 2083   Springfield SD 19 411167000590 542 Briggs Middle School   Regular School No Middle 06 08 2021   k_12_total 295 2 108   2 8     2   33                               295 2 108   2 8     2   33                        
658090 658090 OR     school 4111670 2083   Springfield SD 19   4717 Bridgeway House             2021   k_12_total 15 0 0   0 0     0   2                               15 0 0   0 0     0   2                        
658089 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                        
658088 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                        
658087 658087 OR     school 4111640 2247   Spray SD 1 411164001255 3403 Spray School   Regular School No Other KG 12 2021   k_12_total 43 1 0   3 0     2   0                               43 1 0   3 0     2   0                        
658086 658086 OR     school   2025   Southern Oregon ESD   2025 Southern Oregon ESD             2021   k_12_total 26 0 8   0 0     0   0                               26 0 8   0 0     0   0                        
658085 658085 OR     school   2025   Southern Oregon ESD   1782 Kairos New Beginnings West             2021   k_12_total 3 0 1   0 0     0   0                               3 0 1   0 0     0   0                        
658084 658084 OR     school   2025   Southern Oregon ESD   3150 Kairos New Beginnings East             2021   k_12_total 1 0 1   1 0     0   1                               1 0 1   1 0     0   1                        
658083 658083 OR     school   2025   Southern Oregon ESD   3653 Family Solutions - Medford             2021   k_12_total 5 1 3   0 0     0   0                               5 1 3   0 0     0   0                        
658082 658082 OR     school   2025   Southern Oregon ESD   1275 Family Solutions - Grants Pass             2021   k_12_total 12 0 1   0 1     0   2                               12 0 1   0 1     0   2                        
658081 658081 OR     school   2025   Southern Oregon ESD   2434 Family Solutions - Ashland             2021   k_12_total 8 1 2   0 0     0   0                               8 1 2   0 0     0   0                        
658080 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                        
658079 658079 OR     school 4100021 2225   South Wasco County SD 1 410002101166 1108 Maupin Elementary School   Regular School No Elementary KG 06 2021   k_12_total 98 0 9   4 0     0   8                               98 0 9   4 0     0   8                        
658078 658078 OR     school 4111610 1994   South Umpqua SD 19   5200 Washington School for the Blind             2021   k_12_total 1 0 0   0 0     0   0                               1 0 0   0 0     0   0                        
658077 658077 OR     school 4111610 1994   South Umpqua SD 19 411161000312 292 Tri City Elementary School   Regular School No Elementary PK 05 2021   k_12_total 213 1 25   4 0     0   30                               213 1 25   4 0     0   30                        
658076 658076 OR     school 4111610 1994   South Umpqua SD 19 411161000313 293 South Umpqua High School   Regular School No High 09 12 2021   k_12_total 298 0 43   5 4     0   40                               298 0 43   5 4     0   40                        
658075 658075 OR     school 4111610 1994   South Umpqua SD 19 411161000310 290 Myrtle Creek Elementary School   Regular School No Elementary PK 05 2021   k_12_total 197 0 33   2 0     0   27                               197 0 33   2 0     0   27                        
658074 658074 OR     school 4111610 1994   South Umpqua SD 19 411161000311 291 Coffenberry Middle School   Regular School No Middle 06 08 2021   k_12_total 228 0 27   4 0     0   49                               228 0 27   4 0     0   49                        
658073 658073 OR     school 4111610 1994   South Umpqua SD 19 411161000309 289 Canyonville School   Regular School No Elementary KG 08 2021   k_12_total 112 0 22   3 0     0   15                               112 0 22   3 0     0   15                        
658072 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                        
658071 658071 OR     school 4111580 2087   South Lane SD 45J3 411158000614 579 Lincoln Middle School   Regular School No Middle 06 08 2021   k_12_total 408 2 55   11 5     0   14                               408 2 55   11 5     0   14                        
658070 658070 OR     school 4111580 2087   South Lane SD 45J3 411158000611 576 Harrison Elementary School   Regular School No Elementary KG 05 2021   k_12_total 381 0 31   7 1     2   13                               381 0 31   7 1     2   13                        
658069 658069 OR     school 4111580 2087   South Lane SD 45J3 411158000609 574 Dorena School   Regular School No Elementary KG 08 2021   k_12_total 56 0 4   1 2     0   2                               56 0 4   1 2     0   2                        
658068 658068 OR     school 4111580 2087   South Lane SD 45J3 411158000615 580 Cottage Grove High School   Regular School No High 09 12 2021   k_12_total 630 4 85   17 8     0   12                               630 4 85   17 8     0   12                        
658067 658067 OR     school 4111580 2087   South Lane SD 45J3 411158001677 4395 Childs Way Charter School   Regular School Yes High 05 12 2021   k_12_total 45 1 1   0 0     0   0                               45 1 1   0 0     0   0                        
658066 658066 OR     school 4111580 2087   South Lane SD 45J3   2418 Childs Way Alternative School             2021   k_12_total 5 0 0   0 0     0   1                               5 0 0   0 0     0   1                        
658065 658065 OR     school 4111580 2087   South Lane SD 45J3   4717 Bridgeway House             2021   k_12_total - - -   - -     -   -                                                                            
658064 658064 OR     school 4111580 2087   South Lane SD 45J3 411158000608 573 Bohemia Elementary School   Regular School No Elementary KG 05 2021   k_12_total 306 0 103   13 2     2   10                               306 0 103   13 2     2   10                        
658063 658063 OR     school 4111580 2087   South Lane SD 45J3 411158001390 1791 Al Kennedy High School   Alternative School No High 09 12 2021   k_12_total 49 1 10   3 0     0   1                               49 1 10   3 0     0   1                        
658062 658062 OR     school 4111580 2087   South Lane SD 45J3 411158001727 4555 Academy for Character Education   Regular School Yes Other KG 12 2021   k_12_total 238 4 31   1 1     0   17                               238 4 31   1 1     0   17                        
658061 658061 OR     school 4105020 2022   South Harney SD 33 410502001383 357 Fields Elementary School   Regular School No Elementary KG 08 2021   k_12_total 15 0 1   0 0     0   0                               15 0 1   0 0     0   0                        
658060 658060 OR     school 4105100 2096   Siuslaw SD 97J 410510000643 608 Siuslaw Middle School   Regular School No Middle 06 08 2021   k_12_total 250 2 27   7 4     2   35                               250 2 27   7 4     2   35                        
658059 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                        
658058 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                        
658057 658057 OR     school 4111490 1978   Sisters SD 6 411149000943 1293 Sisters Middle School   Regular School No Middle 05 08 2021   k_12_total 302 4 37   2 3     3   8                               302 4 37   2 3     3   8                        
658056 658056 OR     school 4111490 1978   Sisters SD 6 411149000073 1294 Sisters High School   Regular School No High 09 12 2021   k_12_total 327 0 39   6 6     5   11                               327 0 39   6 6     5   11                        
658055 658055 OR     school 4111490 1978   Sisters SD 6 411149000283 264 Sisters Elementary School   Regular School No Elementary KG 04 2021   k_12_total 280 3 24   4 1     2   9                               280 3 24   4 1     2   9                        
658054 658054 OR     school 4111450 2138   Silver Falls SD 4J 411145000822 777 Victor Point Elementary School   Regular School No Elementary KG 08 2021   k_12_total 152 2 12   0 2     0   8                               152 2 12   0 2     0   8                        
658053 658053 OR     school 4111450 2138   Silver Falls SD 4J 411145001769 4746 The Community Roots School   Regular School Yes Elementary KG 08 2021   k_12_total 108 0 11   1 0     0   4                               108 0 11   1 0     0   4                        
658052 658052 OR     school 4111450 2138   Silver Falls SD 4J 411145000763 715 Silverton Middle School   Regular School No Middle 06 08 2021   k_12_total 366 3 90   3 0     0   23                               366 3 90   3 0     0   23                        
658051 658051 OR     school 4111450 2138   Silver Falls SD 4J 411145000857 812 Silverton High School   Regular School No High 09 12 2021   k_12_total 998 11 195   15 13     4   30                               998 11 195   15 13     4   30                        

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