Data source: Big Local News · About: Big Local

1,470 rows where grade = "k_12_total", state = "OR" and year = 2017 sorted by white

View and edit SQL

year

  • 2017 · 1,470

grade

  • k_12_total · 1,470
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
1705440 OR     school 4102040 2088   Bethel SD 52   1861 Northwest Youth Corps             2017   k_12_total 0.0 0.0 0.0     0.0     0.0   0.0                               0 0 0     0     0   0                        
1705477 OR     school 4102800 2185   Centennial SD 28J   2504 Mt Hood Community College             2017   k_12_total 0.0 0.0 1.0     0.0     0.0   0.0                               0 0 1     0     0   0                        
1705505 OR     school   1902   Clackamas ESD   4689 Clackamas River School             2017   k_12_total 0.0 0.0 0.0     0.0     0.0   0.0                               0 0 0     0     0   0                        
1705506 OR     school   1902   Clackamas ESD   1246 Merrick School             2017   k_12_total 0.0 0.0 0.0     0.0     0.0   0.0                               0 0 0     0     0   0                        
1705509 OR     school 4103260 1945   Clatskanie SD 6J   1945 Clatskanie SD 6J             2017   k_12_total 0.0 0.0 0.0     0.0     0.0   0.0                               0 0 0     0     0   0                        
1705552 OR     school 4103690 2086   Creswell SD 40   1789 SAFE Center School             2017   k_12_total 0.0 0.0 0.0     0.0     0.0   0.0                               0 0 0     0     0   0                        
1705589 OR     school 4103940 2187   David Douglas SD 40   4512 Oregon Outreach Inc. Rosi Hinton High School             2017   k_12_total 0.0 0.0 0.0     0.0     0.0   0.0                               0 0 0     0     0   0                        
1705593 OR     school 4103940 2187   David Douglas SD 40   1871 SERP Enterprises Inc             2017   k_12_total 0.0 0.0 0.0     0.0     0.0   0.0                               0 0 0     0     0   0                        
1705635 OR     school 4104620 1998   Elkton SD 34   4633 Insight School of Oregon - Online Alternative High School             2017   k_12_total 0.0 0.0 0.0     0.0     0.0   0.0                               0 0 0     0     0   0                        
1705700 OR     school 4104950 2084   Fern Ridge SD 28J   1861 Northwest Youth Corps             2017   k_12_total 0.0 0.0 0.0     0.0     0.0   0.0                               0 0 0     0     0   0                        
1705721 OR     school 4105430 2245   Gaston SD 511J   5061 Oregon Virtual Education - West             2017   k_12_total 0.0 0.0 0.0     0.0     0.0   0.0                               0 0 0     0     0   0                        
1705747 OR     school 4105910 2054   Grants Pass SD 7   2507 Rogue Community College             2017   k_12_total 0.0 0.0 0.0     0.0     0.0   0.0                               0 0 0     0     0   0                        
1705774 OR     school 4106000 2183   Gresham-Barlow SD 10J 410600000099 91 Deep Creek Elementary School   Regular School No Not reported M M 2017   k_12_total 0.0 0.0 0.0     0.0     0.0   0.0                               0 0 0     0     0   0                        
1705813 OR     school 4106300 2206   Hermiston SD 8 410630001770 4743 Innovative Learning Center   Alternative School No Not reported M M 2017   k_12_total 0.0 0.0 0.0     0.0     0.0   0.0                               0 0 0     0     0   0                        
1705818 OR     school   1975   High Desert ESD   240 High Desert Children's Program             2017   k_12_total 0.0 0.0 0.0     0.0     0.0   0.0                               0 0 0     0     0   0                        
1705907 OR     school 4107020 2057   Klamath County SD   1506 Hosanna Christian School             2017   k_12_total 0.0 0.0 0.0     0.0     0.0   0.0                               0 0 0     0     0   0                        
1705918 OR     school 4107020 2057   Klamath County SD   1511 The Triad School             2017   k_12_total 0.0 0.0 0.0     0.0     0.0   0.0                               0 0 0     0     0   0                        
1705940 OR     school 4107280 2059   Lake County SD 7   2059 Lake County SD 7             2017   k_12_total 0.0 0.0 0.0     0.0     0.0   0.0                               0 0 0     0     0   0                        
1705995 OR     school   2106   Malheur ESD Region 14   2106 Malheur ESD Region 14             2017   k_12_total 0.0 0.0 0.0     0.0     0.0   0.0                               0 0 0     0     0   0                        
1706006 OR     school 4108010 2256   McMinnville SD 40   2256 McMinnville SD 40             2017   k_12_total 0.0 0.0 0.0     0.0     0.0   0.0                               0 0 0     0     0   0                        
1706068 OR     school 4180180 2148   Multnomah ESD   4203 Doernbecher Childrens Hospital (educational program)             2017   k_12_total 0.0 0.0 1.0     0.0     0.0   0.0                               0 0 1     0     0   0                        
1706074 OR     school 4180180 2148   Multnomah ESD   1806 Shriners Hospital (educational program)             2017   k_12_total 0.0 0.0 0.0     0.0     0.0   0.0                               0 0 0     0     0   0                        
1706093 OR     school 4108720 2254   Newberg SD 29J   3369 Sitka Academy             2017   k_12_total 0.0 0.0 0.0     0.0     0.0   0.0                               0 0 0     0     0   0                        
1706096 OR     school 4108820 1966   North Bend SD 13   3615 Lighthouse Charter School             2017   k_12_total 0.0 0.0 0.0     0.0     0.0   0.0                               0 0 0     0     0   0                        
1706101 OR     school 4108820 1966   North Bend SD 13 410882001580 3990 Oregon Coast Technology School   Regular School No Not reported M M 2017   k_12_total 0.0 0.0 0.0     0.0     0.0   0.0                               0 0 0     0     0   0                        
1706152 OR     school 4100048 4131   North Wasco County SD 21 410004801806 4849 Mosier Middle School   Regular School No Not reported M M 2017   k_12_total 0.0 0.0 0.0     0.0     0.0   0.0                               0 0 0     0     0   0                        
1706175 OR     school   3476   ODE JDEP District   2842 Lincoln County Juvenile             2017   k_12_total 0.0 0.0 1.0     0.0     0.0   0.0                               0 0 1     0     0   0                        
1706181 OR     school   5334   ODE ORR   5334 ODE ORR             2017   k_12_total 0.0 0.0 0.0     0.0     0.0   0.0                               0 0 0     0     0   0                        
1706217 OR     school 4109330 1928   Oregon City SD 62   1684 Tucker-Maxon Oral School             2017   k_12_total 0.0 0.0 1.0     0.0     0.0   0.0                               0 0 1     0     0   0                        
1706244 OR     school 4109510 2207   Pendleton SD 16 410951001104 1046 Lincoln Primary School   Regular School No Not reported M M 2017   k_12_total 0.0 0.0 0.0     0.0     0.0   0.0                               0 0 0     0     0   0                        
1706252 OR     school 4109510 2207   Pendleton SD 16 410951001108 1050 West Hills Intermediate   Regular School No Not reported M M 2017   k_12_total 0.0 0.0 0.0     0.0     0.0   0.0                               0 0 0     0     0   0                        
1706272 OR     school 4109870 2081   Pleasant Hill SD 1   1792 Jasper Mountain Center             2017   k_12_total 0.0 0.0 0.0     0.0     0.0   0.0                               0 0 0     0     0   0                        
1706275 OR     school 4109870 2081   Pleasant Hill SD 1   2081 Pleasant Hill SD 1             2017   k_12_total 0.0 0.0 0.0     0.0     0.0   0.0                               0 0 0     0     0   0                        
1706343 OR     school 4110040 2180   Portland SD 1J   3012 New Avenues for Youth             2017   k_12_total 0.0 0.0 0.0     0.0     0.0   0.0                               0 0 0     0     0   0                        
1706348 OR     school 4110040 2180   Portland SD 1J   4508 Outside In-Urban Ed             2017   k_12_total 0.0 0.0 0.0     0.0     0.0   0.0                               0 0 0     0     0   0                        
1706378 OR     school 4110040 2180   Portland SD 1J   921 White Shield Home             2017   k_12_total 0.0 0.0 0.0     0.0     0.0   0.0                               0 0 0     0     0   0                        
1706529 OR     school 4111220 2257   Sheridan SD 48J 411122001449 2732 Sheridan Spartan Academy   Alternative School No Not reported M M 2017   k_12_total 0.0 0.0 0.0     0.0     0.0   0.0                               0 0 0     0     0   0                        
1706531 OR     school 4111250 2195   Sherman County SD 411125001067 1009 Sherman Elementary School   Regular School No Not reported M M 2017   k_12_total 0.0 0.0 0.0     0.0     0.0   0.0                               0 0 0     0     0   0                        
1706565 OR     school 4111580 2087   South Lane SD 45J3   2418 Childs Way Alternative School             2017   k_12_total 0.0 0.0 0.0     0.0     0.0   0.0                               0 0 0     0     0   0                        
1706575 OR     school 4111580 2087   South Lane SD 45J3   1861 Northwest Youth Corps             2017   k_12_total 0.0 0.0 0.0     0.0     0.0   0.0                               0 0 0     0     0   0                        
1706584 OR     school   2025   Southern Oregon ESD   1481 Community Works/Lithia Springs School             2017   k_12_total 0.0 0.0 0.0     0.0     0.0   0.0                               0 0 0     0     0   0                        
1706586 OR     school   2025   Southern Oregon ESD   3652 Family Solutions - Central Point             2017   k_12_total 0.0 0.0 0.0     0.0     0.0   0.0                               0 0 0     0     0   0                        
1706636 OR     school 4111940 2003   Sutherlin SD 130   2003 Sutherlin SD 130             2017   k_12_total 0.0 0.0 0.0     0.0     0.0   0.0                               0 0 0     0     0   0                        
1706726 OR     school   2117   Willamette ESD   3029 Metsker Heights at Rainbow Family Services             2017   k_12_total 0.0 0.0 0.0     0.0     0.0   0.0                               0 0 0     0     0   0                        
1706757 OR     school 4113650 1997   Yoncalla SD 32   1997 Yoncalla SD 32             2017   k_12_total 0.0 0.0 0.0     0.0     0.0   0.0                               0 0 0     0     0   0                        
1705435 OR     school 4102040 2088   Bethel SD 52   3545 Looking Glass Center Point School             2017   k_12_total 1.0 0.0 0.0     0.0     0.0   0.0                               1 0 0     0     0   0                        
1705446 OR     school 4102160 2095   Blachly SD 90   2095 Blachly SD 90             2017   k_12_total 1.0 0.0 0.0     0.0     0.0   0.0                               1 0 0     0     0   0                        
1705482 OR     school 4102800 2185   Centennial SD 28J   1885 Portland Youth Builders             2017   k_12_total 1.0 0.0 1.0     0.0     0.0   0.0                               1 0 1     0     0   0                        
1705514 OR     school 4103270 1927   Colton SD 53   1671 Serendipity             2017   k_12_total 1.0 0.0 0.0     0.0     0.0   0.0                               1 0 0     0     0   0                        
1705527 OR     school 4103390 1964   Coquille SD 8   1964 Coquille SD 8             2017   k_12_total 1.0 0.0 0.0     0.0     0.0   0.0                               1 0 0     0     0   0                        
1705643 OR     school 4104700 1930   Estacada SD 108   1671 Serendipity             2017   k_12_total 1.0 0.0 0.0     0.0     0.0   0.0                               1 0 0     0     0   0                        
1705666 OR     school 4104740 2082   Eugene SD 4J   1792 Jasper Mountain Center             2017   k_12_total 1.0 1.0 0.0     0.0     0.0   0.0                               1 1 0     0     0   0                        
1705681 OR     school 4104740 2082   Eugene SD 4J   1789 SAFE Center School             2017   k_12_total 1.0 0.0 1.0     0.0     0.0   0.0                               1 0 1     0     0   0                        
1705798 OR     school 4102490 2014   Harney County SD 3   2014 Harney County SD 3             2017   k_12_total 1.0 0.0 0.0     0.0     0.0   0.0                               1 0 0     0     0   0                        
1705887 OR     school 4106870 2219   Joseph SD 6 410687001142 1084 Imnaha Elementary School   Regular School No Elementary KG 08 2017   k_12_total 1.0 0.0 2.0     0.0     0.0   0.0                               1 0 2     0     0   0                        
1705989 OR     school 4107590 2092   Lowell SD 71   1792 Jasper Mountain Center             2017   k_12_total 1.0 0.0 0.0     0.0     0.0   0.0                               1 0 0     0     0   0                        
1706083 OR     school 4108700 2199   Nestucca Valley SD 101J   2199 Nestucca Valley SD 101J             2017   k_12_total 1.0 0.0 0.0     0.0     0.0   0.0                               1 0 0     0     0   0                        
1706099 OR     school 4108820 1966   North Bend SD 13   1966 North Bend SD 13             2017   k_12_total 1.0 0.0 0.0     0.0     0.0   0.0                               1 0 0     0     0   0                        
1706368 OR     school 4110040 2180   Portland SD 1J 411004001537 4212 Self Enhancement, Inc/SEI Academy   Regular School Yes Middle 07 08 2017   k_12_total 1.0 54.0 2.0     0.0     0.0   8.0                               1 54 2     0     0   8                        
1706570 OR     school 4111580 2087   South Lane SD 45J3   1792 Jasper Mountain Center             2017   k_12_total 1.0 0.0 0.0     0.0     0.0   1.0                               1 0 0     0     0   1                        
1706574 OR     school 4111580 2087   South Lane SD 45J3   1532 Looking Glass Riverfront School & Career Center             2017   k_12_total 1.0 0.0 0.0     0.0     0.0   0.0                               1 0 0     0     0   0                        
1706576 OR     school 4111580 2087   South Lane SD 45J3   2087 South Lane SD 45J3             2017   k_12_total 1.0 0.0 0.0     0.0     0.0   0.0                               1 0 0     0     0   0                        
1706630 OR     school 4111790 2209   Stanfield SD 61   2209 Stanfield SD 61             2017   k_12_total 1.0 0.0 0.0     0.0     0.0   0.0                               1 0 0     0     0   0                        
1705298 OR     school 4101350 2111   Annex SD 29   2111 Annex SD 29             2017   k_12_total 10.0 0.0 4.0     0.0     0.0   1.0                               10 0 4     0     0   1                        
1705686 OR     school 4104740 2082   Eugene SD 4J   2316 Stepping Stone Lodge             2017   k_12_total 10.0 1.0 3.0     0.0     0.0   0.0                               10 1 3     0     0   0                        
1706587 OR     school   2025   Southern Oregon ESD   1275 Family Solutions - Grants Pass             2017   k_12_total 10.0 0.0 1.0     1.0     0.0   0.0                               10 0 1     1     0   0                        
1706593 OR     school 4111670 2083   Springfield SD 19   4717 Bridgeway House             2017   k_12_total 10.0 0.0 0.0     0.0     0.0   3.0                               10 0 0     0     0   3                        
1706632 OR     school 4111910 2018   Suntex SD 10 411191000368 349 Suntex Elementary School   Regular School No Elementary KG 08 2017   k_12_total 10.0 0.0 0.0     0.0     0.0   0.0                               10 0 0     0     0   0                        
1706661 OR     school 4106900 2055   Three Rivers/Josephine County SD   1877 The Inn Between Educational Program, DBA Inn Sight             2017   k_12_total 10.0 0.0 3.0     0.0     0.0   4.0                               10 0 3     0     0   4                        
1706613 OR     school 4111670 2083   Springfield SD 19 411167000595 561 Thurston High School   Regular School No High 09 12 2017   k_12_total 1002.0 7.0 205.0     9.0     8.0   111.0                               1002 7 205     9     8   111                        
1705693 OR     school 4100003 2193   Falls City SD 57 410000301061 1005 Falls City Elementary School   Regular School No Elementary KG 08 2017   k_12_total 101.0 0.0 10.0     0.0     0.0   4.0                               101 0 10     0     0   4                        
1706037 OR     school 4108160 2205   Milton-Freewater Unified SD 7 410816001836 5297 Ferndale Elementary School   Regular School No Elementary 02 03 2017   k_12_total 101.0 0.0 155.0     1.0     0.0   3.0                               101 0 155     1     0   3                        
1706053 OR     school 4108430 1898   Monroe SD 1J 410843000050 43 Monroe High School   Regular School No High 09 12 2017   k_12_total 101.0 0.0 27.0     1.0     0.0   4.0                               101 0 27     1     0   4                        
1706058 OR     school 4108520 2147   Morrow SD 1 410852001598 4048 Irrigon Elementary School   Regular School No Elementary 04 06 2017   k_12_total 101.0 0.0 102.0     0.0     0.0   3.0                               101 0 102     0     0   3                        
1706418 OR     school 4110520 2182   Reynolds SD 7 411052001001 948 Margaret Scott Elementary School   Regular School No Elementary KG 05 2017   k_12_total 101.0 99.0 121.0     72.0     28.0   47.0                               101 99 121     72     28   47                        
1705662 OR     school 4104740 2082   Eugene SD 4J 410474000690 1339 Family School   Alternative School No Elementary KG 05 2017   k_12_total 102.0 2.0 13.0     2.0     1.0   13.0                               102 2 13     2     1   13                        
1705839 OR     school 4100023 2239   Hillsboro SD 1J 410002301749 4642 Lincoln Street Elementary School   Regular School No Elementary KG 06 2017   k_12_total 102.0 7.0 391.0     3.0     3.0   7.0                               102 7 391     3     3   7                        
1705960 OR     school 4107380 2101   Lebanon Community SD 9 410738000730 688 Lebanon High School   Regular School No High 09 12 2017   k_12_total 1025.0 10.0 128.0     24.0     5.0   62.0                               1025 10 128     24     5   62                        
1705563 OR     school 4103780 2089   Crow-Applegate-Lorane SD 66 410378000624 589 Applegate Elementary School   Regular School No Elementary KG 06 2017   k_12_total 103.0 0.0 8.0     2.0     0.0   5.0                               103 0 8     2     0   5                        
1706159 OR     school   2230   Northwest Regional ESD   2230 Northwest Regional ESD             2017   k_12_total 103.0 6.0 17.0     0.0     2.0   7.0                               103 6 17     0     2   7                        
1706704 OR     school 4112930 1947   Vernonia SD 47J 411293001673 4396 Vernonia Middle School   Regular School No Middle 06 08 2017   k_12_total 103.0 0.0 8.0     1.0     0.0   4.0                               103 0 8     1     0   4                        
1706741 OR     school 4113530 2146   Woodburn SD 103 411353000843 1267 Lincoln Elementary School   Regular School No Elementary KG 05 2017   k_12_total 103.0 5.0 676.0     2.0     3.0   6.0                               103 5 676     2     3   6                        
1706550 OR     school 4111450 2138   Silver Falls SD 4J 411145000857 812 Silverton High School   Regular School No High 09 12 2017   k_12_total 1035.0 7.0 205.0     8.0     2.0   22.0                               1035 7 205     8     2   22                        
1705531 OR     school 4103420 2186   Corbett SD 39 410342001729 4592 Corbett School   Regular School No Other KG 12 2017   k_12_total 1037.0 13.0 74.0     32.0     8.0   61.0                               1037 13 74     32     8   61                        
1705992 OR     school 4107590 2092   Lowell SD 71 410759000633 598 Lundy Elementary School   Regular School No Elementary KG 06 2017   k_12_total 105.0 3.0 17.0     0.0     0.0   20.0                               105 3 17     0     0   20                        
1706352 OR     school 4110040 2180   Portland SD 1J 411004001667 4400 Portland Arthur Academy Charter School   Regular School Yes Elementary KG 05 2017   k_12_total 105.0 6.0 12.0     16.0     0.0   25.0                               105 6 12     16     0   25                        
1706429 OR     school 4110520 2182   Reynolds SD 7 411052001006 952 Wilkes Elementary School   Regular School No Elementary KG 05 2017   k_12_total 105.0 56.0 194.0     47.0     22.0   28.0                               105 56 194     47     22   28                        
1706381 OR     school 4110040 2180   Portland SD 1J 411004000975 922 Wilson High School   Regular School No High 09 12 2017   k_12_total 1052.0 80.0 112.0     47.0     9.0   103.0                               1052 80 112     47     9   103                        
1706119 OR     school 4108830 1924   North Clackamas SD 12 410883001583 4004 New Urban High School   Regular School No High 09 12 2017   k_12_total 106.0 4.0 21.0     0.0     0.0   7.0                               106 4 21     0     0   7                        
1705682 OR     school 4104740 2082   Eugene SD 4J 410474000572 538 Sheldon High School   Regular School No High 09 12 2017   k_12_total 1065.0 22.0 184.0     60.0     7.0   129.0                               1065 22 184     60     7   129                        
1705683 OR     school 4104740 2082   Eugene SD 4J 410474000573 539 South Eugene High School   Regular School No High 09 12 2017   k_12_total 1068.0 34.0 131.0     83.0     0.0   151.0                               1068 34 131     83     0   151                        
1705564 OR     school 4103780 2089   Crow-Applegate-Lorane SD 66 410378000627 592 Crow Middle/High School   Regular School No High 07 12 2017   k_12_total 107.0 1.0 4.0     1.0     0.0   7.0                               107 1 4     1     0   7                        
1705892 OR     school 4106930 2091   Junction City SD 69 410693000203 1297 Territorial Elementary School   Regular School No Elementary KG 05 2017   k_12_total 107.0 1.0 11.0     0.0     0.0   7.0                               107 1 11     0     0   7                        
1706218 OR     school 4100009 2336   Oregon Department of Education 410000901808 4850 Eagle Charter School   Regular School Yes Elementary KG 05 2017   k_12_total 107.0 2.0 15.0     0.0     0.0   15.0                               107 2 15     0     0   15                        
1706415 OR     school 4110520 2182   Reynolds SD 7 411052001000 947 Hartley Elementary School   Regular School No Elementary KG 05 2017   k_12_total 107.0 43.0 270.0     14.0     17.0   26.0                               107 43 270     14     17   26                        
1705770 OR     school 4101120 2100   Greater Albany Public SD 8J 410112000735 649 West Albany High School   Regular School No High 09 12 2017   k_12_total 1077.0 11.0 174.0     18.0     0.0   75.0                               1077 11 174     18     0   75                        
1705376 OR     school 4101920 2243   Beaverton SD 48J 410192000536 1314 School of Science & Technology   Regular School No High 09 12 2017   k_12_total 108.0 4.0 24.0     31.0     0.0   9.0                               108 4 24     31     0   9                        
1705753 OR     school 4101120 2100   Greater Albany Public SD 8J 410112000031 635 Fir Grove Primary School   Regular School No Elementary KG 01 2017   k_12_total 108.0 0.0 8.0     2.0     2.0   7.0                               108 0 8     2     2   7                        
1706231 OR     school 4110890 1926   Oregon Trail SD 46 411089000149 141 Sandy High School   Regular School No High 09 12 2017   k_12_total 1087.0 5.0 203.0     15.0     5.0   81.0                               1087 5 203     15     5   81                        
1705737 OR     school 4105670 1992   Glide SD 12 410567000303 284 Glide Middle School   Regular School No Middle 07 08 2017   k_12_total 109.0 0.0 9.0     0.0     0.0   5.0                               109 0 9     0     0   5                        

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