Data source: Big Local News · About: Big Local

3,371,677 rows sorted by total

View and edit SQL

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
656877 OR     school 4101920 2243   Beaverton SD 48J 410192001779 4712 Springville K-8 School   Regular School No Elementary KG 08 2021   k_12_total 247 31 81   7 453     3   30                               247 31 81   7 453     3   30                        
656878 OR     school 4101920 2243   Beaverton SD 48J 410192001431 2782 Stoller Middle School   Regular School No Middle 06 08 2021   k_12_total 424 26 110   2 761     10   76                               424 26 110   2 761     10   76                        
656879 OR     school 4101920 2243   Beaverton SD 48J 410192001241 1188 Sunset High School   Regular School No High 09 12 2021   k_12_total 1066 22 208   5 540     8   177                               1066 22 208   5 540     8   177                        
656880 OR     school 4101920 2243   Beaverton SD 48J 410192001229 1176 Terra Linda Elementary School   Regular School No Elementary KG 05 2021   k_12_total 203 6 58   1 21     2   15                               203 6 58   1 21     2   15                        
656881 OR     school 4101920 2243   Beaverton SD 48J 410192001230 1177 Vose Elementary School   Regular School No Elementary PK 05 2021   k_12_total 170 14 447   0 14     6   40                               170 14 447   0 14     6   40                        
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                        
656883 OR     school 4101920 2243   Beaverton SD 48J 410192000554 1320 Westview High School   Regular School No High 09 12 2021   k_12_total 953 84 482   12 652     18   165                               953 84 482   12 652     18   165                        
656884 OR     school 4101920 2243   Beaverton SD 48J 410192001238 1185 Whitford Middle School   Regular School No Middle 06 08 2021   k_12_total 312 18 296   4 47     0   58                               312 18 296   4 47     0   58                        
656885 OR     school 4101920 2243   Beaverton SD 48J 410192001232 1179 William Walker Elementary School   Regular School No Elementary PK 05 2021   k_12_total 96 10 320   1 18     4   25                               96 10 320   1 18     4   25                        
656886 OR     school 4101980 1976   Bend-LaPine Administrative SD 1 410198000607 1324 Amity Creek Elementary School   Regular School No Elementary KG 05 2021   k_12_total 114 2 7   0 4     0   4                               114 2 7   0 4     0   4                        
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                        
656888 OR     school 4101980 1976   Bend-LaPine Administrative SD 1   2916 Bend COIC Dropout Re-engagement Program             2021   k_12_total 77 2 16   1 0     0   4                               77 2 16   1 0     0   4                        
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                        
656890 OR     school 4101980 1976   Bend-LaPine Administrative SD 1 410198000270 251 Bend Senior High School   Regular School No High 09 12 2021   k_12_total 1277 10 282   7 36     5   51                               1277 10 282   7 36     5   51                        
656891 OR     school 4101980 1976   Bend-LaPine Administrative SD 1   1976 Bend-LaPine Administrative SD 1             2021   k_12_total 1077 7 79   10 6     2   45                               1077 7 79   10 6     2   45                        
656892 OR     school 4101980 1976   Bend-LaPine Administrative SD 1 410198001290 250 Buckingham Elementary School   Regular School No Elementary KG 05 2021   k_12_total 309 1 41   0 5     0   21                               309 1 41   0 5     0   21                        
656893 OR     school 4101980 1976   Bend-LaPine Administrative SD 1 410198000259 242 Cascade Middle School   Regular School No Middle 06 08 2021   k_12_total 611 2 69   1 14     0   20                               611 2 69   1 14     0   20                        
656894 OR     school 4101980 1976   Bend-LaPine Administrative SD 1 410198001860 5384 Desert Sky Montessori   Regular School Yes Elementary KG 06 2021   k_12_total 138 0 8   0 3     0   13                               138 0 8   0 3     0   13                        
656895 OR     school 4101980 1976   Bend-LaPine Administrative SD 1 410198000245 1308 Elk Meadow Elementary School   Regular School No Elementary KG 05 2021   k_12_total 349 2 65   0 2     0   16                               349 2 65   0 2     0   16                        
656896 OR     school 4101980 1976   Bend-LaPine Administrative SD 1 410198001603 4129 Ensworth Elementary School   Regular School No Elementary KG 05 2021   k_12_total 116 1 33   2 1     0   11                               116 1 33   2 1     0   11                        
656897 OR     school 4101980 1976   Bend-LaPine Administrative SD 1 410198000263 1309 High Desert Middle School   Regular School No Middle 06 08 2021   k_12_total 504 9 223   1 5     3   18                               504 9 223   1 5     3   18                        
656898 OR     school 4101980 1976   Bend-LaPine Administrative SD 1 410198001487 3218 High Lakes Elementary School   Regular School No Elementary KG 05 2021   k_12_total 409 2 19   0 4     0   19                               409 2 19   0 4     0   19                        
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                        
656901 OR     school 4101980 1976   Bend-LaPine Administrative SD 1   1448 J Bar J Learning Centers - Sisters Academy Campus             2021   k_12_total 12 2 0   0 0     0   0                               12 2 0   0 0     0   0                        
656902 OR     school 4101980 1976   Bend-LaPine Administrative SD 1 410198000265 246 Juniper Elementary School   Regular School No Elementary KG 05 2021   k_12_total 313 1 58   2 2     2   23                               313 1 58   2 2     2   23                        
656903 OR     school 4101980 1976   Bend-LaPine Administrative SD 1   4262 La Pine COIC Dropout Re-engagement Program             2021   k_12_total 35 0 2   0 0     0   1                               35 0 2   0 0     0   1                        
656904 OR     school 4101980 1976   Bend-LaPine Administrative SD 1 410198000262 245 LaPine Elementary School   Regular School No Elementary KG 05 2021   k_12_total 242 4 16   0 1     0   9                               242 4 16   0 1     0   9                        
656905 OR     school 4101980 1976   Bend-LaPine Administrative SD 1 410198000264 1310 LaPine Middle School   Regular School No Middle 06 08 2021   k_12_total 268 0 23   5 3     0   5                               268 0 23   5 3     0   5                        
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                        
656907 OR     school 4101980 1976   Bend-LaPine Administrative SD 1 410198000546 1317 Lava Ridge Elementary School   Regular School No Elementary KG 05 2021   k_12_total 334 6 57   1 0     0   28                               334 6 57   1 0     0   28                        
656908 OR     school 4101980 1976   Bend-LaPine Administrative SD 1 410198000688 1338 Marshall High School   Alternative School No High 09 12 2021   k_12_total 78 0 18   2 1     0   3                               78 0 18   2 1     0   3                        
656909 OR     school 4101980 1976   Bend-LaPine Administrative SD 1 410198000271 252 Mountain View Senior High School   Regular School No High 09 12 2021   k_12_total 997 9 144   10 27     4   35                               997 9 144   10 27     4   35                        
656910 OR     school 4101980 1976   Bend-LaPine Administrative SD 1 410198001875 5452 North Star Elementary   Regular School No Elementary KG 05 2021   k_12_total 205 2 37   2 4     2   10                               205 2 37   2 4     2   10                        
656911 OR     school 4101980 1976   Bend-LaPine Administrative SD 1   3662 Oregon Youth Challenge             2021   k_12_total - - -   - -     -   -                                                                            
656912 OR     school 4101980 1976   Bend-LaPine Administrative SD 1 410198001839 5292 Pacific Crest Middle School   Regular School No Middle 06 08 2021   k_12_total 502 7 28   1 5     2   20                               502 7 28   1 5     2   20                        
656913 OR     school 4101980 1976   Bend-LaPine Administrative SD 1 410198000268 249 Pilot Butte Middle School   Regular School No Middle 06 08 2021   k_12_total 421 7 112   2 11     2   33                               421 7 112   2 11     2   33                        
656914 OR     school 4101980 1976   Bend-LaPine Administrative SD 1 410198001576 3947 Pine Ridge Elementary   Regular School No Elementary KG 05 2021   k_12_total 368 3 47   1 8     0   26                               368 3 47   1 8     0   26                        
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                        
656916 OR     school 4101980 1976   Bend-LaPine Administrative SD 1 410198000266 247 R E Jewell Elementary School   Regular School No Elementary KG 05 2021   k_12_total 307 3 83   4 6     0   17                               307 3 83   4 6     0   17                        
656917 OR     school 4101980 1976   Bend-LaPine Administrative SD 1 410198001871 5428 Realms High School   Regular School No High 09 12 2021   k_12_total 121 0 10   1 1     0   3                               121 0 10   1 1     0   3                        
656918 OR     school 4101980 1976   Bend-LaPine Administrative SD 1 410198001436 3448 Realms Middle School   Regular School No Middle 06 08 2021   k_12_total 130 1 7   0 0     0   9                               130 1 7   0 0     0   9                        
656919 OR     school 4101980 1976   Bend-LaPine Administrative SD 1 410198001794 4793 Rosland Elementary   Regular School No Elementary KG 05 2021   k_12_total 182 0 8   3 5     0   10                               182 0 8   3 5     0   10                        
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                        
656922 OR     school 4101980 1976   Bend-LaPine Administrative SD 1 410198001866 5429 Skyline High School   Regular School No High 09 12 2021   k_12_total 125 1 11   1 1     0   7                               125 1 11   1 1     0   7                        
656923 OR     school 4101980 1976   Bend-LaPine Administrative SD 1 410198001451 3216 Summit High School   Regular School No High 09 12 2021   k_12_total 1376 6 95   2 30     4   48                               1376 6 95   2 30     4   48                        
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                        
656926 OR     school 4101980 1976   Bend-LaPine Administrative SD 1 410198001758 4680 William E Miller Elementary   Regular School No Elementary KG 05 2021   k_12_total 432 1 9   2 4     2   18                               432 1 9   2 4     2   18                        
656927 OR     school 4102040 2088   Bethel SD 52   2088 Bethel SD 52             2021   k_12_total 1 0 0   0 0     0   0                               1 0 0   0 0     0   0                        
656928 OR     school 4102040 2088   Bethel SD 52   4717 Bridgeway House             2021   k_12_total 3 1 0   0 0     0   0                               3 1 0   0 0     0   0                        
656929 OR     school 4102040 2088   Bethel SD 52 410204000621 581 Cascade Middle School   Regular School No Middle 06 08 2021   k_12_total 206 7 105   8 4     2   33                               206 7 105   8 4     2   33                        
656930 OR     school 4102040 2088   Bethel SD 52 410204000616 582 Clear Lake Elementary School   Regular School No Elementary KG 05 2021   k_12_total 162 4 53   3 4     2   37                               162 4 53   3 4     2   37                        
656931 OR     school 4102040 2088   Bethel SD 52 410204000617 583 Danebo Elementary School   Regular School No Elementary KG 05 2021   k_12_total 142 0 84   4 8     2   29                               142 0 84   4 8     2   29                        
656932 OR     school 4102040 2088   Bethel SD 52 410204000618 584 Fairfield Elementary School   Regular School No Elementary KG 05 2021   k_12_total 211 5 105   7 5     0   30                               211 5 105   7 5     0   30                        
656933 OR     school 4102040 2088   Bethel SD 52 410204000619 585 Irving Elementary School   Regular School No Elementary KG 05 2021   k_12_total 218 5 25   5 1     0   25                               218 5 25   5 1     0   25                        
656934 OR     school 4102040 2088   Bethel SD 52   1792 Jasper Mountain Center             2021   k_12_total - - -   - -     -   -                                                                            
656935 OR     school 4102040 2088   Bethel SD 52 410204004178 3566 Kalapuya High School   Alternative School No High 09 12 2021   k_12_total 60 1 18   2 0     0   4                               60 1 18   2 0     0   4                        
656936 OR     school 4102040 2088   Bethel SD 52   3545 Looking Glass Center Point School             2021   k_12_total 2 0 1   0 0     0   0                               2 0 1   0 0     0   0                        
656937 OR     school 4102040 2088   Bethel SD 52   1532 Looking Glass Riverfront School & Career Center             2021   k_12_total 13 0 7   1 0     0   2                               13 0 7   1 0     0   2                        
656938 OR     school 4102040 2088   Bethel SD 52 410204000620 586 Malabon Elementary School   Regular School No Elementary KG 05 2021   k_12_total 202 6 96   5 0     2   37                               202 6 96   5 0     2   37                        
656939 OR     school 4102040 2088   Bethel SD 52 410204001391 2264 Meadow View School   Regular School No Elementary KG 08 2021   k_12_total 481 10 96   7 19     11   67                               481 10 96   7 19     11   67                        
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                        
656941 OR     school 4102040 2088   Bethel SD 52   1789 SAFE Center School             2021   k_12_total 4 0 0   0 0     0   0                               4 0 0   0 0     0   0                        
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                        
656943 OR     school 4102040 2088   Bethel SD 52   1545 Wellsprings Friends School             2021   k_12_total 7 0 4   0 0     0   3                               7 0 4   0 0     0   3                        
656944 OR     school 4102040 2088   Bethel SD 52 410204000623 588 Willamette High School   Regular School No High 09 12 2021   k_12_total 946 35 349   22 41     13   111                               946 35 349   22 41     13   111                        
656945 OR     school 4102160 2095   Blachly SD 90 410216000641 3401 Triangle Lake Charter School   Regular School Yes Other KG 12 2021   k_12_total 191 1 13   4 3     0   5                               191 1 13   4 3     0   5                        
656946 OR     school 4102190 2052   Black Butte SD 41 410219000449 428 Black Butte Elementary School   Regular School No Elementary KG 08 2021   k_12_total 14 0 3   3 0     0   2                               14 0 3   3 0     0   2                        
656947 OR     school 4102310 1974   Brookings-Harbor SD 17C 410231000253 235 Azalea Middle School   Regular School No Middle 06 08 2021   k_12_total 201 0 51   5 2     0   56                               201 0 51   5 2     0   56                        
656948 OR     school 4102310 1974   Brookings-Harbor SD 17C 410231000255 237 Brookings-Harbor High School   Regular School No High 09 12 2021   k_12_total 290 6 80   15 1     0   93                               290 6 80   15 1     0   93                        
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                        
656950 OR     school 4101740 1896   Burnt River SD 30J 410174000013 3347 Burnt River School   Regular School Yes Other KG 12 2021   k_12_total 27 0 2   0 0     0   1                               27 0 2   0 0     0   1                        
656951 OR     school 4102580 2046   Butte Falls SD 91 410258000426 406 Butte Falls Charter School   Regular School Yes Other KG 12 2021   k_12_total 195 2 27   1 0     0   7                               195 2 27   1 0     0   7                        
656952 OR     school 4102610 1995   Camas Valley SD 21J 410261000315 3400 Camas Valley School   Regular School Yes Other PK 12 2021   k_12_total 187 0 14   1 0     0   24                               187 0 14   1 0     0   24                        
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                        
656954 OR     school 4102640 1929   Canby SD 86 410264000148 140 Canby High School   Regular School No High 09 12 2021   k_12_total 845 4 439   6 11     2   57                               845 4 439   6 11     2   57                        
656955 OR     school 4102640 1929   Canby SD 86   1929 Canby SD 86             2021   k_12_total 1 0 0   0 0     0   1                               1 0 0   0 0     0   1                        
656956 OR     school 4102640 1929   Canby SD 86 410264000100 92 Carus School   Regular School No Elementary KG 06 2021   k_12_total 288 3 79   3 3     0   14                               288 3 79   3 3     0   14                        
656957 OR     school 4102640 1929   Canby SD 86 410264000165 1307 Cecile Trost Elementary School   Regular School No Elementary KG 06 2021   k_12_total 115 2 286   0 1     0   3                               115 2 286   0 1     0   3                        
656958 OR     school 4102640 1929   Canby SD 86 410264000132 124 Howard Eccles Elementary School   Regular School No Elementary KG 06 2021   k_12_total 293 2 82   2 5     2   16                               293 2 82   2 5     2   16                        
656959 OR     school 4102640 1929   Canby SD 86 410264000135 127 Ninety-One School   Regular School No Elementary KG 08 2021   k_12_total 315 0 69   2 0     0   15                               315 0 69   2 0     0   15                        
656960 OR     school 4102640 1929   Canby SD 86 410264001659 4435 Philander Lee Elementary School   Regular School No Elementary KG 06 2021   k_12_total 200 1 110   0 1     0   19                               200 1 110   0 1     0   19                        
656961 OR     school 4102640 1929   Canby SD 86 410264000130 122 William Knight Elementary School   Regular School No Elementary KG 06 2021   k_12_total 203 1 68   0 2     0   12                               203 1 68   0 2     0   12                        
656962 OR     school 4102780 2139   Cascade SD 5 410278000767 719 Aumsville Elementary School   Regular School No Elementary KG 05 2021   k_12_total 411 1 118   7 7     3   15                               411 1 118   7 7     3   15                        
656963 OR     school 4102780 2139   Cascade SD 5 410278000855 810 Cascade Junior High School   Regular School No Middle 06 08 2021   k_12_total 436 7 110   6 6     4   28                               436 7 110   6 6     4   28                        
656964 OR     school 4102780 2139   Cascade SD 5 410278001854 5380 Cascade Opportunity Center   Alternative School No High 09 12 2021   k_12_total 66 0 22   2 0     0   8                               66 0 22   2 0     0   8                        
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                        
656966 OR     school 4102780 2139   Cascade SD 5   2498 Chemeketa Community College             2021   k_12_total 0 0 1   0 0     0   0                               0 0 1   0 0     0   0                        
656967 OR     school 4102780 2139   Cascade SD 5 410278000851 806 Cloverdale Elementary School   Regular School No Elementary KG 05 2021   k_12_total 138 0 17   2 1     0   3                               138 0 17   2 1     0   3                        
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                        
656969 OR     school 4102800 2185   Centennial SD 28J 410280001574 3649 Butler Creek Elementary School   Regular School No Elementary KG 06 2021   k_12_total 297 29 92   3 76     9   43                               297 29 92   3 76     9   43                        
656970 OR     school 4102800 2185   Centennial SD 28J 410280001020 967 Centennial High School   Regular School No High 09 12 2021   k_12_total 646 102 538   11 248     45   100                               646 102 538   11 248     45   100                        
656971 OR     school 4102800 2185   Centennial SD 28J 410280001013 960 Centennial Middle School   Regular School No Middle 07 08 2021   k_12_total 371 63 292   6 119     22   59                               371 63 292   6 119     22   59                        
656972 OR     school 4102800 2185   Centennial SD 28J 410280001221 1367 Centennial Park School   Alternative School No Not reported M M 2021   k_12_total - - -   - -     -   -                                                                            
656973 OR     school 4102800 2185   Centennial SD 28J   2185 Centennial SD 28J             2021   k_12_total 31 8 15   0 2     2   5                               31 8 15   0 2     2   5                        
656974 OR     school 4102800 2185   Centennial SD 28J 410280001012 959 Meadows Elementary   Regular School No Elementary KG 06 2021   k_12_total 115 10 134   2 37     7   25                               115 10 134   2 37     7   25                        
656975 OR     school 4102800 2185   Centennial SD 28J 410280001015 962 Oliver Elementary School   Regular School No Elementary KG 06 2021   k_12_total 105 48 102   1 37     20   21                               105 48 102   1 37     20   21                        
656976 OR     school 4102800 2185   Centennial SD 28J   5268 Open School East             2021   k_12_total 46 18 28   0 0     0   12                               46 18 28   0 0     0   12                        

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