Data source: Big Local News · About: Big Local

5,859 rows where grade = "k_12_total" and state = "OR" sorted by ccd_school_type descending

View and edit SQL

year

grade

  • k_12_total · 5,859
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
657714 OR     school 4100009 2336   Oregon Department of Education 410000900062 1832 Oregon School for the Deaf   Special Education School No Other KG 12 2021   k_12_total 38 4 34   4 3     4   8                               38 4 34   4 3     4   8                        
917561 OR     school 4100009 2336   Oregon Department of Education 410000900062 1832 Oregon School for the Deaf   Special Education School No Other KG 12 2020   k_12_total 50 5 42   4 6     4   10                               50 5 42   4 6     4   10                        
1191396 OR     school 4100009 2336   Oregon Department of Education 410000900062 1832 Oregon School for the Deaf   Special Education School No Other KG 12 2018   k_12_total 50.0 6.0 44.0   3.0 3.0     5.0   7.0                               50 6 44   3 3     5   7                        
1706220 OR     school 4100009 2336   Oregon Department of Education 410000900062 1832 Oregon School for the Deaf   Special Education School No Other KG 12 2017   k_12_total 49.0 8.0 48.0     4.0     5.0   5.0                               49 8 48     4     5   5                        
656780 OR     school 4100990 2063   Adel SD 21 410099000524 498 Adel Elementary School   Regular School No Middle 04 08 2021   k_12_total 11 0 0   1 0     0   0                               11 0 0   1 0     0   0                        
656781 OR     school 4101020 2113   Adrian SD 61 410102000755 707 Adrian Elementary School   Regular School No Elementary KG 08 2021   k_12_total 132 0 38   0 0     0   1                               132 0 38   0 0     0   1                        
656782 OR     school 4101020 2113   Adrian SD 61 410102000756 708 Adrian High School   Regular School No High 09 12 2021   k_12_total 62 0 19   0 1     0   1                               62 0 19   0 1     0   1                        
656783 OR     school 4101200 1899   Alsea SD 7J 410120000019 17 Alsea Charter School   Regular School Yes Other KG 12 2021   k_12_total 350 1 55   6 2     2   44                               350 1 55   6 2     2   44                        
656784 OR     school 4101230 2252   Amity SD 4J 410123001260 1208 Amity Elementary School   Regular School No Elementary KG 05 2021   k_12_total 216 1 43   6 0     0   15                               216 1 43   6 0     0   15                        
656785 OR     school 4101230 2252   Amity SD 4J 410123001263 1210 Amity High School   Regular School No High 09 12 2021   k_12_total 190 2 32   1 3     0   11                               190 2 32   1 3     0   11                        
656786 OR     school 4101230 2252   Amity SD 4J 410123001320 1209 Amity Middle School   Regular School No Middle 06 08 2021   k_12_total 154 0 27   1 2     0   8                               154 0 27   1 2     0   8                        
656787 OR     school 4101230 2252   Amity SD 4J 410123001653 4505 Eola Hills Charter School   Regular School Yes Other 01 12 2021   k_12_total 17 0 1   0 0     0   3                               17 0 1   0 0     0   3                        
656788 OR     school 4101350 2111   Annex SD 29 410135000753 705 Annex Charter School   Regular School Yes Elementary KG 08 2021   k_12_total 48 0 10   0 0     0   3                               48 0 10   0 0     0   3                        
656790 OR     school 4101470 2005   Arlington SD 3 410147000343 323 Arlington Community Charter School   Regular School Yes Other KG 12 2021   k_12_total 129 0 22   6 0     3   2                               129 0 22   6 0     3   2                        
656791 OR     school 4101500 2115   Arock SD 81 410150000759 711 W W Jones Elementary School   Regular School No Elementary KG 08 2021   k_12_total 13 0 3   0 0     0   0                               13 0 3   0 0     0   0                        
656792 OR     school 4101560 2041   Ashland SD 5 410156000401 381 Ashland High School   Regular School No High 09 12 2021   k_12_total 695 6 108   2 15     0   112                               695 6 108   2 15     0   112                        
656793 OR     school 4101560 2041   Ashland SD 5 410156000400 380 Ashland Middle School   Regular School No Middle 06 08 2021   k_12_total 363 2 71   3 7     0   57                               363 2 71   3 7     0   57                        
656795 OR     school 4101560 2041   Ashland SD 5 410156000395 375 Bellview Elementary School   Regular School No Elementary KG 05 2021   k_12_total 206 0 30   3 3     0   29                               206 0 30   3 3     0   29                        
656796 OR     school 4101560 2041   Ashland SD 5 410156000397 377 Helman Elementary School   Regular School No Elementary KG 05 2021   k_12_total 220 2 36   1 2     2   30                               220 2 36   1 2     2   30                        
656797 OR     school 4101560 2041   Ashland SD 5 410156001654 4476 John Muir Outdoor School   Regular School No Elementary KG 08 2021   k_12_total 91 1 7   0 1     0   7                               91 1 7   0 1     0   7                        
656798 OR     school 4101560 2041   Ashland SD 5 410156000399 379 Walker Elementary School   Regular School No Elementary KG 05 2021   k_12_total 185 9 43   2 7     0   28                               185 9 43   2 7     0   28                        
656799 OR     school 4101590 2051   Ashwood SD 8 410159000448 427 Ashwood Elementary School   Regular School No Elementary KG 08 2021   k_12_total 10 0 0   0 0     0   0                               10 0 0   0 0     0   0                        
656800 OR     school 4101620 1933   Astoria SD 1 410162000152 143 Astor Elementary School   Regular School No Elementary KG 02 2021   k_12_total 274 3 72   0 2     3   8                               274 3 72   0 2     3   8                        
656801 OR     school 4101620 1933   Astoria SD 1 410162000153 144 Astoria Middle School   Regular School No Middle 06 08 2021   k_12_total 309 3 99   1 1     6   16                               309 3 99   1 1     6   16                        
656803 OR     school 4101620 1933   Astoria SD 1 410162000155 146 Astoria Senior High School   Regular School No High 09 12 2021   k_12_total 441 1 89   6 6     6   30                               441 1 89   6 6     6   30                        
656804 OR     school 4101620 1933   Astoria SD 1 410162000156 147 Lewis & Clark Elementary School   Regular School No Elementary 03 05 2021   k_12_total 311 1 84   5 1     4   18                               311 1 84   5 1     4   18                        
656805 OR     school 4101660 2208   Athena-Weston SD 29RJ 410166001112 1053 Athena Elementary School   Regular School No Elementary PK 03 2021   k_12_total 91 0 14   3 0     0   11                               91 0 14   3 0     0   11                        
656806 OR     school 4101660 2208   Athena-Weston SD 29RJ 410166001114 1055 Weston Middle School   Regular School No Middle 04 08 2021   k_12_total 170 0 19   17 2     0   13                               170 0 19   17 2     0   13                        
656807 OR     school 4101660 2208   Athena-Weston SD 29RJ 410166001115 1056 Weston-McEwen High School   Regular School No High 09 12 2021   k_12_total 157 1 16   15 1     0   18                               157 1 16   15 1     0   18                        
656808 OR     school 4101710 1894   Baker SD 5J 410171001783 4759 Baker Early College   Regular School Yes High 09 12 2021   k_12_total 283 2 14   0 8     0   22                               283 2 14   0 8     0   22                        
656809 OR     school 4101710 1894   Baker SD 5J 410171001878 5509 Baker Early Learning Center   Regular School No Elementary KG KG 2021   k_12_total 53 0 11   0 0     0   3                               53 0 11   0 0     0   3                        
656810 OR     school 4101710 1894   Baker SD 5J 410171000009 8 Baker High School   Regular School No High 09 12 2021   k_12_total 351 1 11   8 4     0   18                               351 1 11   8 4     0   18                        
656811 OR     school 4101710 1894   Baker SD 5J 410171000001 1 Baker Middle School   Regular School No Middle 07 08 2021   k_12_total 234 0 2   11 0     0   15                               234 0 2   11 0     0   15                        
656813 OR     school 4101710 1894   Baker SD 5J 410171001879 5604 Baker Virtual Academy   Regular School No Elementary KG 06 2021   k_12_total 74 0 0   0 0     0   9                               74 0 0   0 0     0   9                        
656814 OR     school 4101710 1894   Baker SD 5J 410171001767 4728 Baker Web Academy   Regular School Yes Other KG 12 2021   k_12_total 2209 24 292   22 27     9   144                               2209 24 292   22 27     9   144                        
656815 OR     school 4101710 1894   Baker SD 5J 410171000002 2 Brooklyn Primary School   Regular School No Elementary 01 03 2021   k_12_total 228 0 12   0 2     0   20                               228 0 12   0 2     0   20                        
656817 OR     school 4101710 1894   Baker SD 5J 410171000030 4 Haines Elementary School   Regular School No Elementary KG 06 2021   k_12_total 101 0 2   1 1     0   8                               101 0 2   1 1     0   8                        
656818 OR     school 4101710 1894   Baker SD 5J 410171000034 5 Keating Elementary School   Regular School No Elementary KG 06 2021   k_12_total 19 0 0   0 0     0   1                               19 0 0   0 0     0   1                        
656819 OR     school 4101710 1894   Baker SD 5J 410171000007 7 South Baker Intermediate School   Regular School No Middle 04 06 2021   k_12_total 238 2 13   6 1     0   15                               238 2 13   6 1     0   15                        
656820 OR     school 4101800 1969   Bandon SD 54 410180000237 218 Bandon Senior High School   Regular School No High 09 12 2021   k_12_total 153 1 26   4 1     0   18                               153 1 26   4 1     0   18                        
656821 OR     school 4101800 1969   Bandon SD 54 410180000235 216 Harbor Lights Middle School   Regular School No Middle 05 08 2021   k_12_total 164 0 32   0 1     0   23                               164 0 32   0 1     0   23                        
656822 OR     school 4101800 1969   Bandon SD 54 410180000236 217 Ocean Crest Elementary School   Regular School No Elementary KG 04 2021   k_12_total 159 0 32   0 2     2   16                               159 0 32   0 2     2   16                        
656823 OR     school 4101830 2240   Banks SD 13 410183001176 1120 Banks Elementary School   Regular School No Elementary KG 05 2021   k_12_total 361 3 44   2 0     2   18                               361 3 44   2 0     2   18                        
656824 OR     school 4101830 2240   Banks SD 13 410183001180 1124 Banks High School   Regular School No High 09 12 2021   k_12_total 306 0 32   1 4     1   21                               306 0 32   1 4     1   21                        
656825 OR     school 4101830 2240   Banks SD 13 410183001179 1123 Banks Middle School   Regular School No Middle 06 08 2021   k_12_total 216 1 25   0 1     0   22                               216 1 25   0 1     0   22                        
656827 OR     school 4101920 2243   Beaverton SD 48J 410192001239 1186 Aloha High School   Regular School No High 09 12 2021   k_12_total 595 97 816   7 127     24   100                               595 97 816   7 127     24   100                        
656828 OR     school 4101920 2243   Beaverton SD 48J 410192001204 1153 Aloha-Huber Park School   Regular School No Elementary PK 08 2021   k_12_total 187 42 493   3 50     2   45                               187 42 493   3 50     2   45                        
656829 OR     school 4101920 2243   Beaverton SD 48J 410192001791 4805 Arco Iris Spanish Immersion School   Regular School Yes Elementary KG 08 2021   k_12_total 183 2 196   4 5     1   47                               183 2 196   4 5     1   47                        
656830 OR     school 4101920 2243   Beaverton SD 48J 410192000213 1304 Arts and Communication Magnet Academy   Regular School No High 06 12 2021   k_12_total 464 14 102   3 35     2   87                               464 14 102   3 35     2   87                        
656831 OR     school 4101920 2243   Beaverton SD 48J 410192001205 1154 Barnes Elementary School   Regular School No Elementary PK 05 2021   k_12_total 119 25 334   0 12     5   20                               119 25 334   0 12     5   20                        
656832 OR     school 4101920 2243   Beaverton SD 48J 410192001206 1155 Beaver Acres Elementary School   Regular School No Elementary KG 05 2021   k_12_total 231 36 269   7 89     9   55                               231 36 269   7 89     9   55                        
656833 OR     school 4101920 2243   Beaverton SD 48J 410192001745 4638 Beaverton Academy of Science and Engineering   Regular School No High 06 12 2021   k_12_total 381 16 213   6 151     3   70                               381 16 213   6 151     3   70                        
656834 OR     school 4101920 2243   Beaverton SD 48J 410192001240 1187 Beaverton High School   Regular School No High 09 12 2021   k_12_total 650 45 689   5 76     13   89                               650 45 689   5 76     13   89                        
656836 OR     school 4101920 2243   Beaverton SD 48J 410192001207 1156 Bethany Elementary School   Regular School No Elementary KG 05 2021   k_12_total 228 16 44   1 111     0   47                               228 16 44   1 111     0   47                        
656837 OR     school 4101920 2243   Beaverton SD 48J 410192001753 4671 Bonny Slope Elementary School   Regular School No Elementary PK 05 2021   k_12_total 311 7 54   1 146     1   53                               311 7 54   1 146     1   53                        
656838 OR     school 4101920 2243   Beaverton SD 48J 410192001210 1158 Cedar Mill Elementary School   Regular School No Elementary KG 05 2021   k_12_total 212 6 42   1 72     1   33                               212 6 42   1 72     1   33                        
656839 OR     school 4101920 2243   Beaverton SD 48J 410192001233 1180 Cedar Park Middle School   Regular School No Middle 06 08 2021   k_12_total 498 24 188   5 59     6   74                               498 24 188   5 59     6   74                        
656840 OR     school 4101920 2243   Beaverton SD 48J 410192001211 1159 Chehalem Elementary School   Regular School No Elementary KG 05 2021   k_12_total 183 8 169   3 30     4   29                               183 8 169   3 30     4   29                        
656842 OR     school 4101920 2243   Beaverton SD 48J 410192000552 1319 Conestoga Middle School   Regular School No Middle 06 08 2021   k_12_total 479 35 183   2 97     17   84                               479 35 183   2 97     17   84                        
656843 OR     school 4101920 2243   Beaverton SD 48J 410192001212 1160 Cooper Mountain Elementary School   Regular School No Elementary KG 05 2021   k_12_total 255 11 39   1 52     3   40                               255 11 39   1 52     3   40                        
656844 OR     school 4101920 2243   Beaverton SD 48J 410192001321 1162 Elmonica Elementary School   Regular School No Elementary KG 05 2021   k_12_total 91 15 128   5 193     1   32                               91 15 128   5 193     1   32                        
656845 OR     school 4101920 2243   Beaverton SD 48J 410192001301 1161 Errol Hassell Elementary School   Regular School No Elementary KG 05 2021   k_12_total 175 10 85   0 33     1   35                               175 10 85   0 33     1   35                        
656846 OR     school 4101920 2243   Beaverton SD 48J 410192001262 1370 Findley Elementary   Regular School No Elementary KG 05 2021   k_12_total 128 10 32   2 329     0   39                               128 10 32   2 329     0   39                        
656847 OR     school 4101920 2243   Beaverton SD 48J 410192001213 1163 Fir Grove Elementary School   Regular School No Elementary KG 05 2021   k_12_total 164 14 110   1 17     6   36                               164 14 110   1 17     6   36                        
656848 OR     school 4101920 2243   Beaverton SD 48J 410192001234 1181 Five Oaks Middle School   Regular School No Middle 06 08 2021   k_12_total 367 47 406   5 70     8   76                               367 47 406   5 70     8   76                        
656849 OR     school 4101920 2243   Beaverton SD 48J 410192001894 5506 FLEX Online School   Regular School No Other KG 12 2021   k_12_total 737 22 156   4 150     22   122                               737 22 156   4 150     22   122                        
656850 OR     school 4101920 2243   Beaverton SD 48J 410192001289 1157 Greenway Elementary School   Regular School No Elementary PK 05 2021   k_12_total 137 13 124   0 8     4   22                               137 13 124   0 8     4   22                        
656851 OR     school 4101920 2243   Beaverton SD 48J 410192001215 1164 Hazeldale Elementary School   Regular School No Elementary KG 05 2021   k_12_total 183 11 156   3 39     5   41                               183 11 156   3 39     5   41                        
656852 OR     school 4101920 2243   Beaverton SD 48J 410192001237 1184 Highland Park Middle School   Regular School No Middle 06 08 2021   k_12_total 404 22 160   5 56     4   50                               404 22 160   5 56     4   50                        
656853 OR     school 4101920 2243   Beaverton SD 48J 410192001216 1165 Hiteon Elementary School   Regular School No Elementary KG 05 2021   k_12_total 332 14 91   3 47     6   63                               332 14 91   3 47     6   63                        
656854 OR     school 4101920 2243   Beaverton SD 48J 410192001823 4867 Hope Chinese Charter School   Regular School Yes Elementary KG 08 2021   k_12_total 75 3 22   0 132     0   102                               75 3 22   0 132     0   102                        
656855 OR     school 4101920 2243   Beaverton SD 48J 410192001647 4474 International School of Beaverton   Regular School No High 06 12 2021   k_12_total 308 28 136   0 289     0   106                               308 28 136   0 289     0   106                        
656856 OR     school 4101920 2243   Beaverton SD 48J 410192001445 3437 Jacob Wismer Elementary School   Regular School No Elementary KG 05 2021   k_12_total 158 3 34   6 426     0   30                               158 3 34   6 426     0   30                        
656857 OR     school 4101920 2243   Beaverton SD 48J 410192001217 1166 Kinnaman Elementary School   Regular School No Elementary KG 05 2021   k_12_total 195 28 254   2 36     1   33                               195 28 254   2 36     1   33                        
656858 OR     school 4101920 2243   Beaverton SD 48J 410192001219 1168 McKay Elementary School   Regular School No Elementary PK 05 2021   k_12_total 136 10 93   0 14     6   25                               136 10 93   0 14     6   25                        
656859 OR     school 4101920 2243   Beaverton SD 48J 410192001220 1169 McKinley Elementary School   Regular School No Elementary KG 05 2021   k_12_total 204 59 228   3 64     4   43                               204 59 228   3 64     4   43                        
656860 OR     school 4101920 2243   Beaverton SD 48J 410192001235 1182 Meadow Park Middle School   Regular School No Middle 06 08 2021   k_12_total 321 20 300   3 124     6   56                               321 20 300   3 124     6   56                        
656861 OR     school 4101920 2243   Beaverton SD 48J 410192001222 1170 Montclair Elementary School   Regular School No Elementary KG 05 2021   k_12_total 177 1 27   0 8     1   39                               177 1 27   0 8     1   39                        
656862 OR     school 4101920 2243   Beaverton SD 48J 410192001236 1183 Mountain View Middle School   Regular School No Middle 06 08 2021   k_12_total 343 28 314   4 50     4   57                               343 28 314   4 50     4   57                        
656863 OR     school 4101920 2243   Beaverton SD 48J 410192001855 5381 Mountainside High School   Regular School No High 09 12 2021   k_12_total 1055 42 253   4 232     8   160                               1055 42 253   4 232     8   160                        
656864 OR     school 4101920 2243   Beaverton SD 48J 410192000210 1303 Nancy Ryles Elementary School   Regular School No Elementary KG 05 2021   k_12_total 290 18 66   2 69     10   63                               290 18 66   2 69     10   63                        
656865 OR     school 4101920 2243   Beaverton SD 48J 410192001223 1171 Oak Hills Elementary School   Regular School No Elementary KG 05 2021   k_12_total 261 14 65   3 109     2   28                               261 14 65   3 109     2   28                        
656867 OR     school 4101920 2243   Beaverton SD 48J 410192001224 1172 Raleigh Hills Elementary School   Regular School No Elementary KG 08 2021   k_12_total 242 15 130   1 15     2   42                               242 15 130   1 15     2   42                        
656868 OR     school 4101920 2243   Beaverton SD 48J 410192001225 1173 Raleigh Park Elementary School   Regular School No Elementary KG 05 2021   k_12_total 163 13 99   1 11     5   31                               163 13 99   1 11     5   31                        
656869 OR     school 4101920 2243   Beaverton SD 48J 410192001226 1174 Ridgewood Elementary School   Regular School No Elementary KG 05 2021   k_12_total 249 11 42   0 21     1   27                               249 11 42   0 21     1   27                        
656870 OR     school 4101920 2243   Beaverton SD 48J 410192001227 1175 Rock Creek Elementary School   Regular School No Elementary KG 05 2021   k_12_total 227 1 63   3 84     1   39                               227 1 63   3 84     1   39                        
656871 OR     school 4101920 2243   Beaverton SD 48J 410192001856 5382 Sato Elementary School   Regular School No Elementary KG 05 2021   k_12_total 184 25 79   6 333     5   35                               184 25 79   6 333     5   35                        
656872 OR     school 4101920 2243   Beaverton SD 48J 410192001430 2781 Scholls Heights Elementary School   Regular School No Elementary KG 05 2021   k_12_total 304 13 65   1 143     3   61                               304 13 65   1 143     3   61                        
656873 OR     school 4101920 2243   Beaverton SD 48J 410192000536 1314 School of Science & Technology   Regular School No Not reported M M 2021   k_12_total - - -   - -     -   -                                                                            
656875 OR     school 4101920 2243   Beaverton SD 48J 410192011348 1270 Sexton Mountain Elementary School   Regular School No Elementary KG 05 2021   k_12_total 286 11 43   0 69     3   60                               286 11 43   0 69     3   60                        
656876 OR     school 4101920 2243   Beaverton SD 48J 410192001432 2783 Southridge High School   Regular School No High 09 12 2021   k_12_total 735 43 472   8 93     17   113                               735 43 472   8 93     17   113                        
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                        

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