Data source: Big Local News · About: Big Local

1,471 rows where grade = "k_12_total", state = "OR" and year = 2021 sorted by district_state_id

View and edit SQL

year

  • 2021 · 1,471

grade

  • k_12_total · 1,471
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
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                        
656812 OR     school 4101710 1894   Baker SD 5J   1894 Baker SD 5J             2021   k_12_total - - -   - -     -   -                                                                            
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                        
656816 OR     school 4101710 1894   Baker SD 5J 410171001516 3493 EAGLE CAP Innovative HS   Alternative School No High 07 12 2021   k_12_total 120 0 5   3 1     0   9                               120 0 5   3 1     0   9                        
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                        
657360 OR     school 4106600 1895   Huntington SD 16J 410660000011 3351 Huntington School   Regular School Yes Other KG 12 2021   k_12_total 17 0 1   0 3     0   0                               17 0 1   0 3     0   0                        
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                        
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                        
657551 OR     school 4108430 1898   Monroe SD 1J 410843000027 1321 Monroe Grade School   Regular School No Elementary KG 08 2021   k_12_total 147 0 64   2 2     0   7                               147 0 64   2 2     0   7                        
657552 OR     school 4108430 1898   Monroe SD 1J 410843000050 43 Monroe High School   Regular School No High 09 12 2021   k_12_total 90 0 29   0 1     0   3                               90 0 29   0 1     0   3                        
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                        
657746 OR     school 4109600 1900   Philomath SD 17J 410960000020 18 Blodgett Elementary School   Regular School No Elementary KG 04 2021   k_12_total 16 2 0   1 0     0   1                               16 2 0   1 0     0   1                        
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                        
657748 OR     school 4109600 1900   Philomath SD 17J 410960000021 3440 Kings Valley Charter School   Regular School Yes Other KG 12 2021   k_12_total 181 1 16   0 2     0   8                               181 1 16   0 2     0   8                        
657749 OR     school 4109600 1900   Philomath SD 17J 410960001880 5492 Philomath Academy   Alternative School No Other KG 12 2021   k_12_total 163 0 12   2 4     0   13                               163 0 12   2 4     0   13                        
657750 OR     school 4109600 1900   Philomath SD 17J 410960000022 20 Philomath Elementary School   Regular School No Elementary 02 05 2021   k_12_total 241 2 33   1 0     0   21                               241 2 33   1 0     0   21                        
657751 OR     school 4109600 1900   Philomath SD 17J 410960000024 22 Philomath High School   Regular School No High 09 12 2021   k_12_total 328 1 36   2 6     0   23                               328 1 36   2 6     0   23                        
657752 OR     school 4109600 1900   Philomath SD 17J 410960000023 21 Philomath Middle School   Regular School No Middle 06 08 2021   k_12_total 229 3 36   0 0     0   22                               229 3 36   0 0     0   22                        
657029 OR     school 4103480 1901   Corvallis SD 509J 410348000032 27 Adams Elementary School   Regular School No Elementary KG 05 2021   k_12_total 249 4 34   3 27     0   36                               249 4 34   3 27     0   36                        
657030 OR     school 4103480 1901   Corvallis SD 509J 410348000033 28 Cheldelin Middle School   Regular School No Middle 06 08 2021   k_12_total 321 7 42   1 27     3   38                               321 7 42   1 27     3   38                        
657031 OR     school 4103480 1901   Corvallis SD 509J 410348000047 40 Corvallis High School   Regular School No High 09 12 2021   k_12_total 660 9 254   13 46     3   74                               660 9 254   13 46     3   74                        
657032 OR     school 4103480 1901   Corvallis SD 509J   1901 Corvallis SD 509J             2021   k_12_total 589 6 95   9 62     6   72                               589 6 95   9 62     6   72                        
657033 OR     school 4103480 1901   Corvallis SD 509J 410348000048 41 Crescent Valley High School   Regular School No High 09 12 2021   k_12_total 602 8 76   3 61     3   76                               602 8 76   3 61     3   76                        
657034 OR     school 4103480 1901   Corvallis SD 509J 410348000570 1322 Franklin School   Regular School No Elementary KG 08 2021   k_12_total 200 3 29   0 32     1   24                               200 3 29   0 32     1   24                        
657035 OR     school 4103480 1901   Corvallis SD 509J 410348000037 30 Garfield Elementary School   Regular School No Elementary KG 05 2021   k_12_total 147 6 198   8 4     0   27                               147 6 198   8 4     0   27                        
657036 OR     school 4103480 1901   Corvallis SD 509J 410348000040 33 Husky Elementary School   Regular School No Elementary KG 05 2021   k_12_total 173 2 24   0 45     2   27                               173 2 24   0 45     2   27                        
657037 OR     school 4103480 1901   Corvallis SD 509J 410348001743 4637 Inavale Community Partners dba Muddy Creek Charter School   Regular School Yes Elementary KG 05 2021   k_12_total 98 0 14   0 0     0   7                               98 0 14   0 0     0   7                        
657038 OR     school 4103480 1901   Corvallis SD 509J 410348000042 35 Jaguar Elementary School   Regular School No Elementary KG 05 2021   k_12_total 233 4 22   3 10     0   23                               233 4 22   3 10     0   23                        
657039 OR     school 4103480 1901   Corvallis SD 509J 410348000043 36 Lincoln Elementary School   Regular School No Elementary KG 05 2021   k_12_total 197 5 94   1 1     4   16                               197 5 94   1 1     4   16                        
657040 OR     school 4103480 1901   Corvallis SD 509J 410348000045 38 Linus Pauling Middle School   Regular School No Middle 06 08 2021   k_12_total 429 15 194   5 18     1   55                               429 15 194   5 18     1   55                        
657041 OR     school 4103480 1901   Corvallis SD 509J 410348000044 37 Mt View Elementary School   Regular School No Elementary KG 05 2021   k_12_total 182 2 11   0 1     2   17                               182 2 11   0 1     2   17                        
657042 OR     school 4103480 1901   Corvallis SD 509J 410348000046 39 Wildcat Elementary School   Regular School No Elementary KG 05 2021   k_12_total 207 9 42   2 22     7   28                               207 9 42   2 22     7   28                        
657043 OR     school 4103480 1901   Corvallis SD 509J   1874 YES House Alternative School             2021   k_12_total 4 0 1   0 0     0   4                               4 0 1   0 0     0   4                        
657002 OR     school   1902   Clackamas ESD   1902 Clackamas ESD             2021   k_12_total 149 7 27   2 3     0   6                               149 7 27   2 3     0   6                        
658203 OR     school 4113170 1922   West Linn-Wilsonville SD 3J 411317001786 4773 Arts and Technology High School   Alternative School No High 09 12 2021   k_12_total 53 0 19   0 3     1   9                               53 0 19   0 3     1   9                        
658204 OR     school 4113170 1922   West Linn-Wilsonville SD 3J 411317000056 1287 Athey Creek Middle School   Regular School No Middle 06 08 2021   k_12_total 534 4 42   2 22     0   61                               534 4 42   2 22     0   61                        
658205 OR     school 4113170 1922   West Linn-Wilsonville SD 3J 411317001356 1272 Boeckman Creek Primary School   Regular School No Elementary PK 05 2021   k_12_total 300 3 92   0 14     5   47                               300 3 92   0 14     5   47                        
658206 OR     school 4113170 1922   West Linn-Wilsonville SD 3J 411317001447 3455 Bolton Primary School   Regular School No Elementary PK 05 2021   k_12_total 239 0 19   0 10     0   26                               239 0 19   0 10     0   26                        
658207 OR     school 4113170 1922   West Linn-Wilsonville SD 3J 411317001575 3913 Boones Ferry Primary School   Regular School No Elementary PK 05 2021   k_12_total 325 4 121   0 15     7   48                               325 4 121   0 15     7   48                        
658208 OR     school 4113170 1922   West Linn-Wilsonville SD 3J 411317000053 45 Cedaroak Park Primary School   Regular School No Elementary PK 05 2021   k_12_total 215 1 18   0 4     2   28                               215 1 18   0 4     2   28                        
658209 OR     school 4113170 1922   West Linn-Wilsonville SD 3J 411317001318 46 Inza R Wood Middle School   Regular School No Middle 06 08 2021   k_12_total 319 3 139   4 18     6   37                               319 3 139   4 18     6   37                        
658210 OR     school 4113170 1922   West Linn-Wilsonville SD 3J 411317001822 5056 Lowrie Primary School   Regular School No Elementary PK 05 2021   k_12_total 282 4 129   0 25     0   48                               282 4 129   0 25     0   48                        
658211 OR     school 4113170 1922   West Linn-Wilsonville SD 3J 411317001851 5377 Meridian Creek Middle School   Regular School No Middle 06 08 2021   k_12_total 277 7 57   2 25     3   28                               277 7 57   2 25     3   28                        
658212 OR     school 4113170 1922   West Linn-Wilsonville SD 3J 411317001414 2787 Rosemont Ridge Middle School   Regular School No Middle 06 08 2021   k_12_total 538 5 52   3 34     0   77                               538 5 52   3 34     0   77                        
658213 OR     school 4113170 1922   West Linn-Wilsonville SD 3J 411317000054 47 Stafford Primary School   Regular School No Elementary PK 05 2021   k_12_total 302 0 9   0 13     0   26                               302 0 9   0 13     0   26                        
658214 OR     school 4113170 1922   West Linn-Wilsonville SD 3J 411317000055 48 Sunset Primary School   Regular School No Elementary PK 05 2021   k_12_total 248 3 32   0 13     2   53                               248 3 32   0 13     2   53                        
658215 OR     school 4113170 1922   West Linn-Wilsonville SD 3J 411317001437 3452 Three Rivers Charter School   Regular School Yes Middle 04 08 2021   k_12_total 67 0 7   0 23     0   14                               67 0 7   0 23     0   14                        
658216 OR     school 4113170 1922   West Linn-Wilsonville SD 3J 411317001825 5057 Trillium Creek Primary School   Regular School No Elementary PK 05 2021   k_12_total 367 4 29   1 27     3   70                               367 4 29   1 27     3   70                        
658217 OR     school 4113170 1922   West Linn-Wilsonville SD 3J 411317000058 51 West Linn High School   Regular School No High 09 12 2021   k_12_total 1496 17 131   6 103     6   128                               1496 17 131   6 103     6   128                        
658218 OR     school 4113170 1922   West Linn-Wilsonville SD 3J   1922 West Linn-Wilsonville SD 3J             2021   k_12_total - - -   - -     -   -                                                                            
658219 OR     school 4113170 1922   West Linn-Wilsonville SD 3J 411317001377 1286 Willamette Primary School   Regular School No Elementary PK 05 2021   k_12_total 369 3 37   1 12     2   44                               369 3 37   1 12     2   44                        
658220 OR     school 4113170 1922   West Linn-Wilsonville SD 3J 411317000574 1323 Wilsonville High School   Regular School No High 09 12 2021   k_12_total 807 12 227   5 53     9   99                               807 12 227   5 53     9   99                        
657441 OR     school 4107230 1923   Lake Oswego SD 7J 410723000060 53 Forest Hills Elementary School   Regular School No Elementary KG 05 2021   k_12_total 323 0 17   2 26     0   45                               323 0 17   2 26     0   45                        
657442 OR     school 4107230 1923   Lake Oswego SD 7J 410723001308 54 Hallinan Elementary School   Regular School No Elementary KG 05 2021   k_12_total 294 0 32   0 26     1   42                               294 0 32   0 26     1   42                        
657443 OR     school 4107230 1923   Lake Oswego SD 7J 410723001873 5455 Harmony Academy   Regular School Yes High 09 12 2021   k_12_total 19 1 1   0 0     0   5                               19 1 1   0 0     0   5                        
657444 OR     school 4107230 1923   Lake Oswego SD 7J 410723000061 55 Lake Grove Elementary School   Regular School No Elementary KG 05 2021   k_12_total 235 3 20   0 45     2   41                               235 3 20   0 45     2   41                        
657445 OR     school 4107230 1923   Lake Oswego SD 7J 410723000066 59 Lake Oswego Middle School   Regular School No Middle 06 08 2021   k_12_total 550 7 65   3 131     2   101                               550 7 65   3 131     2   101                        
657446 OR     school 4107230 1923   Lake Oswego SD 7J   1923 Lake Oswego SD 7J             2021   k_12_total 30 0 5   0 1     0   3                               30 0 5   0 1     0   3                        
657447 OR     school 4107230 1923   Lake Oswego SD 7J 410723000068 61 Lake Oswego Senior High School   Regular School No High 09 12 2021   k_12_total 874 12 106   2 161     1   95                               874 12 106   2 161     1   95                        
657448 OR     school 4107230 1923   Lake Oswego SD 7J 410723000069 62 Lakeridge High School   Regular School No High 09 12 2021   k_12_total 935 13 97   2 75     3   129                               935 13 97   2 75     3   129                        
657449 OR     school 4107230 1923   Lake Oswego SD 7J 410723000067 60 Lakeridge Middle School   Regular School No Middle 06 08 2021   k_12_total 577 6 77   0 59     0   70                               577 6 77   0 59     0   70                        
657450 OR     school 4107230 1923   Lake Oswego SD 7J 410723001378 1288 Oak Creek Elementary School   Regular School No Elementary KG 05 2021   k_12_total 285 2 40   1 129     3   65                               285 2 40   1 129     3   65                        
657451 OR     school 4107230 1923   Lake Oswego SD 7J 410723000064 56 River Grove Elementary School   Regular School No Elementary KG 05 2021   k_12_total 338 5 49   0 69     4   61                               338 5 49   0 69     4   61                        
657452 OR     school 4107230 1923   Lake Oswego SD 7J 410723001307 58 Westridge Elementary School   Regular School No Elementary KG 05 2021   k_12_total 346 0 15   0 24     0   37                               346 0 15   0 24     0   37                        
657601 OR     school 4108830 1924   North Clackamas SD 12 410883004189 3530 Alder Creek Middle School   Regular School No Middle 06 08 2021   k_12_total 520 15 240   5 20     2   70                               520 15 240   5 20     2   70                        
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                        
657603 OR     school 4108830 1924   North Clackamas SD 12 410883001874 5451 Beatrice Morrow Cannady Elementary   Regular School No Elementary KG 05 2021   k_12_total 220 7 39   0 107     0   39                               220 7 39   0 107     0   39                        
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                        
657605 OR     school 4108830 1924   North Clackamas SD 12 410883001658 4475 Cascade Heights Public Charter School   Regular School Yes Elementary KG 08 2021   k_12_total 173 0 16   0 25     0   15                               173 0 16   0 25     0   15                        
657606 OR     school 4108830 1924   North Clackamas SD 12 410883000093 85 Clackamas High School   Regular School No High 09 12 2021   k_12_total 1378 46 318   6 443     9   195                               1378 46 318   6 443     9   195                        
657607 OR     school 4108830 1924   North Clackamas SD 12 410883001544 4226 Clackamas Middle College   Regular School Yes High 09 12 2021   k_12_total 203 3 36   0 13     0   21                               203 3 36   0 13     0   21                        
657608 OR     school 4108830 1924   North Clackamas SD 12 410883001543 4223 Clackamas Web Academy   Regular School Yes Other KG 12 2021   k_12_total 428 6 67   2 18     6   39                               428 6 67   2 18     6   39                        
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                        
657610 OR     school 4108830 1924   North Clackamas SD 12 410883001782 4715 Happy Valley Middle School   Regular School No Middle 06 08 2021   k_12_total 589 15 96   5 245     5   97                               589 15 96   5 245     5   97                        
657611 OR     school 4108830 1924   North Clackamas SD 12 410883000085 4764 Lewelling Elementary School   Regular School No Elementary KG 05 2021   k_12_total 148 4 78   1 8     3   30                               148 4 78   1 8     3   30                        
657612 OR     school 4108830 1924   North Clackamas SD 12 410883000079 4765 Linwood Elementary School   Regular School No Elementary KG 05 2021   k_12_total 136 13 55   0 13     14   17                               136 13 55   0 13     14   17                        
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                        
657614 OR     school 4108830 1924   North Clackamas SD 12 410883001584 4005 Milwaukie El Puente Elementary School   Regular School No Elementary KG 05 2021   k_12_total 164 3 195   1 9     0   26                               164 3 195   1 9     0   26                        
657615 OR     school 4108830 1924   North Clackamas SD 12 410883000081 73 Milwaukie Elementary School   Regular School No Not reported M M 2021   k_12_total - - -   - -     -   -                                                                            
657616 OR     school 4108830 1924   North Clackamas SD 12 410883000094 86 Milwaukie High School   Regular School No High 09 12 2021   k_12_total 409 31 274   6 14     13   70                               409 31 274   6 14     13   70                        
657617 OR     school 4108830 1924   North Clackamas SD 12 410883001354 1264 Mount Scott Elementary School   Regular School No Elementary KG 05 2021   k_12_total 176 12 48   1 76     7   40                               176 12 48   1 76     7   40                        
657618 OR     school 4108830 1924   North Clackamas SD 12 410883001583 4004 New Urban High School   Regular School No High 09 12 2021   k_12_total 76 2 14   1 2     0   6                               76 2 14   1 2     0   6                        
657619 OR     school 4108830 1924   North Clackamas SD 12   1924 North Clackamas SD 12             2021   k_12_total 293 12 134   3 79     3   42                               293 12 134   3 79     3   42                        
657620 OR     school 4108830 1924   North Clackamas SD 12 410883001484 3342 Oak Grove Elementary   Regular School No Elementary KG 05 2021   k_12_total 178 6 57   3 3     0   33                               178 6 57   3 3     0   33                        
657621 OR     school 4108830 1924   North Clackamas SD 12 410883000008 4766 Oregon Trail Elementary School   Regular School No Elementary KG 05 2021   k_12_total 245 10 61   3 82     3   52                               245 10 61   3 82     3   52                        
657622 OR     school 4108830 1924   North Clackamas SD 12 410883000095 87 Putnam High School   Regular School No High 09 12 2021   k_12_total 685 18 289   6 29     6   93                               685 18 289   6 29     6   93                        
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                        
657625 OR     school 4108830 1924   North Clackamas SD 12 410883000092 84 Rowe Middle School   Regular School No Middle 06 08 2021   k_12_total 432 26 244   7 16     14   68                               432 26 244   7 16     14   68                        
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                        
657627 OR     school 4108830 1924   North Clackamas SD 12 410883001317 2733 Sojourner School   Regular School No Elementary KG 05 2021   k_12_total 124 0 9   0 3     0   11                               124 0 9   0 3     0   11                        
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                        
657629 OR     school 4108830 1924   North Clackamas SD 12 410883000086 78 Sunnyside Elementary School   Regular School No Elementary KG 05 2021   k_12_total 243 16 86   0 63     5   51                               243 16 86   0 63     5   51                        

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