Data source: Big Local News · About: Big Local

20,426 rows where state = "OR" and year = 2020 sorted by multiracial descending

View and edit SQL

grade

year

  • 2020 · 20,426
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
916804 OR     school 4102310 1974   Brookings-Harbor SD 17C 410231000254 236 Kalmiopsis Elementary School   Regular School No Elementary KG 05 2020   k_12_total 451 1 118   24 5     1   99                               451 1 118   24 5     1   99                        
917674 OR     school 4110040 2180   Portland SD 1J 411004000968 915 Madison High School   Regular School No High 09 12 2020   k_12_total 365 151 267   11 160     18   98                               365 151 267   11 160     18   98                        
917882 OR     school 4111290 2244   Sherwood SD 88J 411129001246 1193 Sherwood High School   Regular School No High 09 12 2020   k_12_total 1282 9 179   12 41     10   98                               1282 9 179   12 41     10   98                        
916697 OR     school 4101920 2243   Beaverton SD 48J 410192000552 1319 Conestoga Middle School   Regular School No Middle 06 08 2020   k_12_total 555 37 192   3 102     9   97                               555 37 192   3 102     9   97                        
916825 OR     school 4102800 2185   Centennial SD 28J 410280001020 967 Centennial High School   Regular School No High 09 12 2020   k_12_total 677 105 517   13 255     38   96                               677 105 517   13 255     38   96                        
917184 OR     school 4100023 2239   Hillsboro SD 1J 410002301585 4018 Liberty High School   Regular School No High 09 12 2020   k_12_total 721 32 529   16 98     19   96                               721 32 529   16 98     19   96                        
917022 OR     school 4104740 2082   Eugene SD 4J 410474000571 536 North Eugene High School   Regular School No High 09 12 2020   k_12_total 703 8 180   10 25     4   95                               703 8 180   10 25     4   95                        
916882 OR     school 4103480 1901   Corvallis SD 509J 410348000047 40 Corvallis High School   Regular School No High 09 12 2020   k_12_total 775 10 270   9 51     4   94                               775 10 270   9 51     4   94                        
916803 OR     school 4102310 1974   Brookings-Harbor SD 17C 410231000255 237 Brookings-Harbor High School   Regular School No High 09 12 2020   k_12_total 282 7 75   20 1     0   92                               282 7 75   20 1     0   92                        
917039 OR     school 4104740 2082   Eugene SD 4J 410474001348 1259 Yujin Gakuen Elementary School   Regular School No Elementary KG 05 2020   k_12_total 162 0 32   0 20     1   92                               162 0 32   0 20     1   92                        
917126 OR     school 4106000 2183   Gresham-Barlow SD 10J 410600001040 986 Gresham High School   Regular School No High 09 12 2020   k_12_total 685 67 604   11 52     16   92                               685 67 604   11 52     16   92                        
917375 OR     school 4108040 2048   Medford SD 549C 410804000445 424 North Medford High School   Regular School No High 09 12 2020   k_12_total 1109 23 411   8 34     19   91                               1109 23 411   8 34     19   91                        
917699 OR     school 4110040 2180   Portland SD 1J 411004001821 918 Roosevelt High School   Regular School No High 09 12 2020   k_12_total 392 207 424   11 33     37   91                               392 207 424   11 33     37   91                        
917628 OR     school 4110040 2180   Portland SD 1J 411004000956 906 Benson Polytechnic High School   Regular School No High 09 12 2020   k_12_total 460 131 275   4 81     11   90                               460 131 275   4 81     11   90                        
916655 OR     school 4101560 2041   Ashland SD 5 410156001654 4476 John Muir Outdoor School   Regular School No Elementary KG 08 2020   k_12_total 102 2 10   0 3     0   9                               102 2 10   0 3     0   9                        
916753 OR     school 4101980 1976   Bend-LaPine Administrative SD 1 410198001438 3219 Highland School at Kenwood Elementary School   Regular School No Elementary KG 05 2020   k_12_total 369 0 7   0 4     1   9                               369 0 7   0 4     1   9                        
916911 OR     school 4103780 2089   Crow-Applegate-Lorane SD 66 410378000627 592 Crow Middle/High School   Regular School No High 07 12 2020   k_12_total 95 1 5   7 2     1   9                               95 1 5   7 2     1   9                        
916914 OR     school 4103840 2050   Culver SD 4 410384000119 1295 Culver Middle School   Regular School No Middle 06 08 2020   k_12_total 109 0 58   2 0     0   9                               109 0 58   2 0     0   9                        
916915 OR     school 4103860 2190   Dallas SD 2 410386001835 5298 Dallas Community Charter   Regular School Yes Elementary KG 08 2020   k_12_total 184 1 4   1 0     0   9                               184 1 4   1 0     0   9                        
916919 OR     school 4103860 2190   Dallas SD 2 410386001045 3461 Luckiamute Valley Charter School   Regular School Yes Elementary KG 08 2020   k_12_total 163 1 16   4 0     1   9                               163 1 16   4 0     1   9                        
917034 OR     school 4104740 2082   Eugene SD 4J 410474000555 530 Twin Oaks Elementary School   Regular School No Elementary KG 05 2020   k_12_total 173 2 33   0 6     1   9                               173 2 33   0 6     1   9                        
917040 OR     school 4100003 2193   Falls City SD 57 410000301061 1005 Falls City Elementary School   Regular School No Elementary KG 08 2020   k_12_total 100 0 4   2 0     0   9                               100 0 4   2 0     0   9                        
917053 OR     school 4105160 2241   Forest Grove SD 15 410516001183 1129 Dilley Elementary School   Regular School No Elementary KG 04 2020   k_12_total 195 0 41   1 4     0   9                               195 0 41   1 4     0   9                        
917055 OR     school 4105160 2241   Forest Grove SD 15 410516001578 3986 Fern Hill Elementary School   Regular School No Elementary KG 04 2020   k_12_total 58 2 165   0 4     1   9                               58 2 165   0 4     1   9                        
917070 OR     school 4100015 2137   Gervais SD 1 410001500821 776 Gervais Elementary School   Regular School No Elementary KG 05 2020   k_12_total 102 1 298   1 1     0   9                               102 1 298   1 1     0   9                        
917101 OR     school 4101120 2100   Greater Albany Public SD 8J   2100 Greater Albany Public SD 8J             2020   k_12_total 56 0 4   2 0     0   9                               56 0 4   2 0     0   9                        
917172 OR     school 4100023 2239   Hillsboro SD 1J 410002301764 4641 Free Orchards Elementary School   Regular School No Elementary KG 06 2020   k_12_total 118 10 215   1 9     3   9                               118 10 215   1 9     3   9                        
917193 OR     school 4100023 2239   Hillsboro SD 1J 410002301200 1149 Reedville Elementary School   Regular School No Elementary KG 06 2020   k_12_total 46 4 182   1 7     0   9                               46 4 182   1 7     0   9                        
917212 OR     school 4106630 2215   Imbler SD 11 410663001137 1079 Imbler Charter School   Regular School Yes Other KG 12 2020   k_12_total 261 0 10   10 0     0   9                               261 0 10   10 0     0   9                        
917259 OR     school 4107020 2057   Klamath County SD   2057 Klamath County SD             2020   k_12_total 117 0 14   5 3     0   9                               117 0 14   5 3     0   9                        
917272 OR     school 4107080 2056   Klamath Falls City Schools 410708001847 5355 Klamath Learning Center   Alternative School No Other 01 12 2020   k_12_total 50 0 12   8 0     0   9                               50 0 12   8 0     0   9                        
917278 OR     school 4100040 2262   Knappa SD 4 410004000176 166 Hilda Lahti Elementary School   Regular School No Elementary KG 08 2020   k_12_total 308 2 35   4 2     0   9                               308 2 35   4 2     0   9                        
917329 OR     school 4107500 2097   Lincoln County SD 410750001334 622 Toledo Jr. High   Regular School No Middle 07 08 2020   k_12_total 84 0 6   11 0     0   9                               84 0 6   11 0     0   9                        
917346 OR     school 4107740 2094   Marcola SD 79J 410774000638 603 Marcola Elementary School   Regular School No Elementary KG 06 2020   k_12_total 132 0 17   2 2     0   9                               132 0 17   2 2     0   9                        
917350 OR     school 4108010 2256   McMinnville SD 40 410801001279 1228 Columbus Elementary School   Regular School No Elementary KG 05 2020   k_12_total 274 4 188   8 1     5   9                               274 4 188   8 1     5   9                        
917360 OR     school 4108040 2048   Medford SD 549C 410804004187 3554 Central Medford High School   Alternative School No High 09 12 2020   k_12_total 72 1 44   2 0     1   9                               72 1 44   2 0     1   9                        
917381 OR     school 4108040 2048   Medford SD 549C 410804000439 419 Washington Elementary School   Regular School No Elementary KG 06 2020   k_12_total 195 2 154   2 2     4   9                               195 2 154   2 2     4   9                        
917385 OR     school 4108160 2205   Milton-Freewater Unified SD 7 410816001861 5434 Gib Olinger Elementary School   Regular School No Elementary KG 03 2020   k_12_total 182 3 307   2 0     1   9                               182 3 307   2 0     1   9                        
917403 OR     school 4108520 2147   Morrow SD 1 410852000858 813 A C Houghton Elementary School   Regular School No Elementary KG 03 2020   k_12_total 119 0 114   2 0     0   9                               119 0 114   2 0     0   9                        
917429 OR     school 4108650 2198   Neah-Kah-Nie SD 56 410865001656 4481 Neah-Kah-Nie Middle School   Regular School No Middle 06 08 2020   k_12_total 171 2 30   3 2     0   9                               171 2 30   3 2     0   9                        
917431 OR     school 4108700 2199   Nestucca Valley SD 101J 410870001082 1023 Nestucca High School   Regular School No High 07 12 2020   k_12_total 152 3 54   3 1     0   9                               152 3 54   3 1     0   9                        
917467 OR     school 4108830 1924   North Clackamas SD 12 410883001583 4004 New Urban High School   Regular School No High 09 12 2020   k_12_total 85 1 22   3 0     0   9                               85 1 22   3 0     0   9                        
917506 OR     school   2230   Northwest Regional ESD   2230 Northwest Regional ESD             2020   k_12_total 113 8 20   2 1     0   9                               113 8 20   2 1     0   9                        
917507 OR     school 4109000 2110   Nyssa SD 26 410900000750 702 Nyssa Elementary School   Regular School No Elementary KG 05 2020   k_12_total 171 1 390   0 0     0   9                               171 1 390   0 0     0   9                        
917556 OR     school 4109330 1928   Oregon City SD 62 410933001666 2735 Oregon City Service Learning Academy   Regular School Yes High 09 12 2020   k_12_total 126 2 20   3 0     3   9                               126 2 20   3 0     3   9                        
917762 OR     school 4110520 2182   Reynolds SD 7 411052001471 1343 Reynolds Learning Academy   Alternative School No High 07 12 2020   k_12_total 50 17 89   1 0     7   9                               50 17 89   1 0     7   9                        
917808 OR     school 4110820 2142   Salem-Keizer SD 24J 411082001536 4210 Jane Goodall Environmental Middle Charter School   Regular School Yes Middle 06 08 2020   k_12_total 78 1 7   0 3     0   9                               78 1 7   0 3     0   9                        
917869 OR     school 4111100 1935   Seaside SD 10 411110000163 154 Seaside High School   Regular School No High 09 12 2020   k_12_total 331 1 110   1 7     3   9                               331 1 110   1 7     3   9                        
917886 OR     school 4111450 2138   Silver Falls SD 4J 411145000127 119 Butte Creek Elementary School   Regular School No Elementary KG 08 2020   k_12_total 230 0 53   1 0     1   9                               230 0 53   1 0     1   9                        
917889 OR     school 4111450 2138   Silver Falls SD 4J 411145000762 714 Mark Twain Elementary   Regular School No Elementary KG 02 2020   k_12_total 261 2 68   2 1     0   9                               261 2 68   2 1     0   9                        
917898 OR     school 4111490 1978   Sisters SD 6 411149000283 264 Sisters Elementary School   Regular School No Elementary KG 04 2020   k_12_total 305 2 27   3 1     3   9                               305 2 27   3 1     3   9                        
918008 OR     school 4112240 2242   Tigard-Tualatin SD 23J 411224001722 2714 Creekside Community High School   Alternative School No High 06 12 2020   k_12_total 87 3 69   0 4     7   9                               87 3 69   0 4     7   9                        
918093 OR     school 4100016 2251   Yamhill Carlton SD 1 410001601730 4564 Yamhill Carlton Intermediate School   Regular School No Middle 05 08 2020   k_12_total 261 3 26   0 4     0   9                               261 3 26   0 4     0   9                        
917297 OR     school 4107230 1923   Lake Oswego SD 7J 410723000068 61 Lake Oswego Senior High School   Regular School No High 09 12 2020   k_12_total 899 7 103   4 155     2   89                               899 7 103   4 155     2   89                        
918023 OR     school 4112240 2242   Tigard-Tualatin SD 23J 411224001197 1145 Twality Middle School   Regular School No Middle 06 08 2020   k_12_total 583 21 274   6 77     29   89                               583 21 274   6 77     29   89                        
916878 OR     school 4103420 2186   Corbett SD 39 410342001729 4592 Corbett School   Regular School Yes Other KG 12 2020   k_12_total 948 13 100   16 20     2   87                               948 13 100   16 20     2   87                        
916869 OR     school 4103660 1965   Coos Bay SD 9 410366000216 201 Marshfield Senior High School   Regular School No High 08 12 2020   k_12_total 690 1 174   42 5     6   86                               690 1 174   42 5     6   86                        
917110 OR     school 4101120 2100   Greater Albany Public SD 8J 410112000736 650 South Albany High School   Regular School No High 09 12 2020   k_12_total 918 7 392   16 13     5   86                               918 7 392   16 13     5   86                        
917647 OR     school 4110040 2180   Portland SD 1J 411004000890 847 Faubion Elementary School   Regular School No Elementary PK 08 2020   k_12_total 177 200 201   14 15     8   86                               177 200 201   14 15     8   86                        
917663 OR     school 4110040 2180   Portland SD 1J 411004000964 913 Jefferson High School   Regular School No High 09 12 2020   k_12_total 203 204 125   3 9     9   86                               203 204 125   3 9     9   86                        
917726 OR     school 4110040 2180   Portland SD 1J 411004000954 904 Woodstock Elementary School   Regular School No Elementary KG 05 2020   k_12_total 280 2 29   0 145     1   86                               280 2 29   0 145     1   86                        
918066 OR     school 4113170 1922   West Linn-Wilsonville SD 3J 411317000574 1323 Wilsonville High School   Regular School No High 09 12 2020   k_12_total 818 11 224   6 54     9   85                               818 11 224   6 54     9   85                        
916689 OR     school 4101920 2243   Beaverton SD 48J 410192001240 1187 Beaverton High School   Regular School No High 09 12 2020   k_12_total 640 50 646   5 84     12   84                               640 50 646   5 84     12   84                        
917718 OR     school 4110040 2180   Portland SD 1J 411004000947 898 West Sylvan Middle School   Regular School No Middle 06 08 2020   k_12_total 570 20 76   2 79     2   84                               570 20 76   2 79     2   84                        
916686 OR     school 4101920 2243   Beaverton SD 48J 410192000213 1304 Arts and Communication Magnet Academy   Regular School No High 06 12 2020   k_12_total 461 15 101   4 40     3   82                               461 15 101   4 40     3   82                        
917138 OR     school 4106000 2183   Gresham-Barlow SD 10J 410600001041 987 Sam Barlow High School   Regular School No High 09 12 2020   k_12_total 1085 29 370   18 56     14   82                               1085 29 370   18 56     14   82                        
917572 OR     school 4110890 1926   Oregon Trail SD 46 411089000149 141 Sandy High School   Regular School No High 09 12 2020   k_12_total 982 9 193   13 14     4   82                               982 9 193   13 14     4   82                        
917660 OR     school 4110040 2180   Portland SD 1J 411004001365 1277 Jackson Middle School   Regular School No Middle 06 08 2020   k_12_total 560 49 69   3 28     2   82                               560 49 69   3 28     2   82                        
916884 OR     school 4103480 1901   Corvallis SD 509J 410348000048 41 Crescent Valley High School   Regular School No High 09 12 2020   k_12_total 674 6 86   5 77     6   81                               674 6 86   5 77     6   81                        
917299 OR     school 4107230 1923   Lake Oswego SD 7J 410723000067 60 Lakeridge Middle School   Regular School No Middle 06 08 2020   k_12_total 623 5 65   1 52     0   81                               623 5 65   1 52     0   81                        
917379 OR     school 4108040 2048   Medford SD 549C 410804000444 423 South Medford High School   Regular School No High 09 12 2020   k_12_total 1136 19 557   10 22     8   81                               1136 19 557   10 22     8   81                        
917658 OR     school 4110040 2180   Portland SD 1J 411004000902 858 Hosford Middle School   Regular School No Middle 06 08 2020   k_12_total 404 18 64   3 78     3   81                               404 18 64   3 78     3   81                        
917823 OR     school 4110820 2142   Salem-Keizer SD 24J 411082000818 773 North Salem High School   Regular School No High 09 12 2020   k_12_total 539 35 1113   14 25     78   81                               539 35 1113   14 25     78   81                        
916694 OR     school 4101920 2243   Beaverton SD 48J 410192001233 1180 Cedar Park Middle School   Regular School No Middle 06 08 2020   k_12_total 591 24 205   2 73     5   80                               591 24 205   2 73     5   80                        
916741 OR     school 4101980 1976   Bend-LaPine Administrative SD 1 410198000258 241 Bear Creek Elementary School   Regular School No Elementary KG 05 2020   k_12_total 290 7 246   2 7     1   8                               290 7 246   2 7     1   8                        
916859 OR     school 4103270 1927   Colton SD 53 410327000109 103 Colton Elementary School   Regular School No Elementary KG 05 2020   k_12_total 231 0 14   0 0     1   8                               231 0 14   0 0     1   8                        
916928 OR     school 4103940 2187   David Douglas SD 40   2187 David Douglas SD 40             2020   k_12_total 61 16 22   0 30     1   8                               61 16 22   0 30     1   8                        
916981 OR     school 4104620 1998   Elkton SD 34 410462000322 302 Elkton Charter School   Regular School Yes Other KG 12 2020   k_12_total 209 1 15   1 2     0   8                               209 1 15   1 2     0   8                        
917043 OR     school 4104950 2084   Fern Ridge SD 28J 410495000597 563 Elmira Elementary School   Regular School No Elementary KG 05 2020   k_12_total 248 0 11   7 4     6   8                               248 0 11   7 4     6   8                        
917049 OR     school 4104950 2084   Fern Ridge SD 28J 410495000599 566 Veneta Elementary School   Regular School No Elementary KG 05 2020   k_12_total 312 1 40   1 1     2   8                               312 1 40   1 1     2   8                        
917071 OR     school 4100015 2137   Gervais SD 1 410001500853 808 Gervais High School   Regular School No High 09 12 2020   k_12_total 90 1 213   5 6     0   8                               90 1 213   5 6     0   8                        
917088 OR     school 4105910 2054   Grants Pass SD 7   2054 Grants Pass SD 7             2020   k_12_total 68 0 24   0 1     0   8                               68 0 24   0 1     0   8                        
917114 OR     school 4101120 2100   Greater Albany Public SD 8J 410112000692 646 Tangent Elementary School   Regular School No Elementary KG 05 2020   k_12_total 106 1 17   2 2     0   8                               106 1 17   2 2     0   8                        
917201 OR     school 4106510 2024   Hood River County SD 410651000389 3372 Cascade Locks School   Regular School No Elementary KG 05 2020   k_12_total 42 0 12   5 1     0   8                               42 0 12   5 1     0   8                        
917217 OR     school 4106740 2053   Jefferson County SD 509J 410674001569 429 Buff Elementary School   Regular School No Elementary KG 05 2020   k_12_total 138 2 141   16 2     1   8                               138 2 141   16 2     1   8                        
917223 OR     school 4106710 2140   Jefferson SD 14J 410671000769 721 Jefferson Elementary School   Regular School No Elementary KG 05 2020   k_12_total 241 2 98   1 2     1   8                               241 2 98   1 2     1   8                        
917355 OR     school 4108010 2256   McMinnville SD 40 410801001282 1231 Newby Elementary School   Regular School No Elementary KG 05 2020   k_12_total 268 9 193   2 4     7   8                               268 9 193   2 4     7   8                        
917358 OR     school 4108010 2256   McMinnville SD 40 410801001310 1232 Wascher Elementary School   Regular School No Elementary KG 05 2020   k_12_total 263 1 115   3 2     3   8                               263 1 115   3 2     3   8                        
917386 OR     school 4108160 2205   Milton-Freewater Unified SD 7 410816001123 1064 McLoughlin High School   Regular School No High 09 12 2020   k_12_total 178 1 299   1 1     1   8                               178 1 299   1 1     1   8                        
917391 OR     school 4108310 1925   Molalla River SD 35 410831000101 93 Clarkes Elementary School   Regular School No Elementary KG 05 2020   k_12_total 174 0 6   1 0     0   8                               174 0 6   1 0     0   8                        
917406 OR     school 4108520 2147   Morrow SD 1 410852001598 4048 Irrigon Elementary School   Regular School No Middle 04 06 2020   k_12_total 97 0 109   0 0     1   8                               97 0 109   0 0     1   8                        
917413 OR     school 4108550 2145   Mt Angel SD 91 410855000839 794 John F Kennedy High School   Regular School No High 09 12 2020   k_12_total 95 3 96   2 1     0   8                               95 3 96   2 1     0   8                        
917415 OR     school 4108550 2145   Mt Angel SD 91 410855000838 793 St Marys Public School   Regular School No Elementary KG 05 2020   k_12_total 187 1 144   0 3     0   8                               187 1 144   0 3     0   8                        
917438 OR     school 4108720 2254   Newberg SD 29J 410872001674 4342 Joan Austin Elementary School   Regular School No Elementary KG 05 2020   k_12_total 209 8 55   2 7     0   8                               209 8 55   2 7     0   8                        
917490 OR     school 4100020 2143   North Santiam SD 29J 410002000693 656 Mari-Linn Elementary School   Regular School No Elementary KG 08 2020   k_12_total 196 0 6   1 0     2   8                               196 0 6   1 0     2   8                        
917546 OR     school 4109330 1928   Oregon City SD 62 410933000113 106 Candy Lane Elementary School   Regular School No Elementary 02 05 2020   k_12_total 86 3 124   2 4     0   8                               86 3 124   2 4     0   8                        
917573 OR     school 4110890 1926   Oregon Trail SD 46 411089000096 88 Welches Elementary School   Regular School No Elementary KG 05 2020   k_12_total 162 2 34   2 0     0   8                               162 2 34   2 0     0   8                        
917586 OR     school 4109510 2207   Pendleton SD 16 410951001534 4202 Nixyaawii Community School   Regular School Yes High 09 12 2020   k_12_total 4 0 6   75 0     0   8                               4 0 6   75 0     0   8                        
917792 OR     school 4110820 2142   Salem-Keizer SD 24J 411082001717 4589 Early College High School   Alternative School No High 09 12 2020   k_12_total 72 0 89   1 8     5   8                               72 0 89   1 8     5   8                        
917797 OR     school 4110820 2142   Salem-Keizer SD 24J 411082000786 740 Grant Community School   Regular School No Elementary KG 05 2020   k_12_total 147 8 202   3 0     10   8                               147 8 202   3 0     10   8                        

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