Data source: Big Local News · About: Big Local

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

View and edit SQL

year

  • 2020 · 1,459

grade

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
916794 OR     school 4102040 2088   Bethel SD 52   3760 Pathways and PRD Program             2020   k_12_total - - -   - -     -   -                                                                            
916936 OR     school 4103940 2187   David Douglas SD 40   1885 Portland Youth Builders             2020   k_12_total - - -   - -     -   -                                                                            
917048 OR     school 4104950 2084   Fern Ridge SD 28J   1532 Looking Glass Riverfront School & Career Center             2020   k_12_total - - -   - -     -   -                                                                            
917066 OR     school 4105310 2020   Frenchglen SD 16   4702 Silvies River Charter School             2020   k_12_total - - -   - -     -   -                                                                            
917074 OR     school 4105610 1931   Gladstone SD 115   2407 Clackamas Community College             2020   k_12_total - - -   - -     -   -                                                                            
917100 OR     school 4101120 2100   Greater Albany Public SD 8J 410112000031 635 Fir Grove Primary School   Regular School No Not reported M M 2020   k_12_total - - -   - -     -   -                                                                            
917153 OR     school 4100019 2099   Harrisburg SD 7J 410001901422 2723 Harrisburg Middle School   Regular School No Not reported M M 2020   k_12_total - - -   - -     -   -                                                                            
917240 OR     school 4106930 2091   Junction City SD 69   1532 Looking Glass Riverfront School & Career Center             2020   k_12_total - - -   - -     -   -                                                                            
917304 OR     school   2064   Lane ESD   5299 Oregon State Hospital - Junction City Campus             2020   k_12_total - - -   - -     -   -                                                                            
917323 OR     school 4107500 2097   Lincoln County SD 410750001660 4468 Siletz Valley Early College Academy   Regular School No Not reported M M 2020   k_12_total - - -   - -     -   -                                                                            
917714 OR     school 4110040 2180   Portland SD 1J 411004004190 3616 Trillium   Regular School No Not reported M M 2020   k_12_total - - -   - -     -   -                                                                            
917719 OR     school 4110040 2180   Portland SD 1J   921 White Shield Home             2020   k_12_total - - -   - -     -   -                                                                            
917914 OR     school 4111580 2087   South Lane SD 45J3   1792 Jasper Mountain Center             2020   k_12_total - - -   - -     -   -                                                                            
917915 OR     school 4111580 2087   South Lane SD 45J3 411158000612 577 Latham Elementary School   Regular School No Not reported M M 2020   k_12_total - - -   - -     -   -                                                                            
917918 OR     school 4111580 2087   South Lane SD 45J3   1532 Looking Glass Riverfront School & Career Center             2020   k_12_total - - -   - -     -   -                                                                            
917919 OR     school 4111580 2087   South Lane SD 45J3   1789 SAFE Center School             2020   k_12_total - - -   - -     -   -                                                                            
917920 OR     school 4111580 2087   South Lane SD 45J3   2087 South Lane SD 45J3             2020   k_12_total - - -   - -     -   -                                                                            
918001 OR     school 4106900 2055   Three Rivers/Josephine County SD   1877 The Inn Between Educational Program, DBA Inn Sight             2020   k_12_total - - -   - -     -   -                                                                            
916821 OR     school 4102780 2139   Cascade SD 5   2498 Chemeketa Community College             2020   k_12_total 0 0 1   0 0     0   0                               0 0 1   0 0     0   0                        
917047 OR     school 4104950 2084   Fern Ridge SD 28J   3545 Looking Glass Center Point School             2020   k_12_total 0 0 1   0 0     0   0                               0 0 1   0 0     0   0                        
917050 OR     school 4104950 2084   Fern Ridge SD 28J   1545 Wellsprings Friends School             2020   k_12_total 0 0 1   0 0     0   0                               0 0 1   0 0     0   0                        
917158 OR     school 4106300 2206   Hermiston SD 8   2206 Hermiston SD 8             2020   k_12_total 0 0 1   0 0     0   0                               0 0 1   0 0     0   0                        
917409 OR     school 4108520 2147   Morrow SD 1   2147 Morrow SD 1             2020   k_12_total 0 0 12   0 0     0   0                               0 0 12   0 0     0   0                        
917447 OR     school 4108820 1966   North Bend SD 13   1966 North Bend SD 13             2020   k_12_total 0 1 0   0 0     0   0                               0 1 0   0 0     0   0                        
916788 OR     school 4102040 2088   Bethel SD 52   1792 Jasper Mountain Center             2020   k_12_total 1 0 0   0 0     0   0                               1 0 0   0 0     0   0                        
916879 OR     school 4103420 2186   Corbett SD 39   2186 Corbett SD 39             2020   k_12_total 1 0 0   0 0     0   1                               1 0 0   0 0     0   1                        
916938 OR     school 4103940 2187   David Douglas SD 40   4477 SE Works, Inc.             2020   k_12_total 1 0 0   0 0     0   0                               1 0 0   0 0     0   0                        
917012 OR     school 4104740 2082   Eugene SD 4J   1792 Jasper Mountain Center             2020   k_12_total 1 0 0   0 0     0   0                               1 0 0   0 0     0   0                        
917046 OR     school 4104950 2084   Fern Ridge SD 28J   1792 Jasper Mountain Center             2020   k_12_total 1 0 0   0 0     0   0                               1 0 0   0 0     0   0                        
917077 OR     school 4105610 1931   Gladstone SD 115   1931 Gladstone SD 115             2020   k_12_total 1 0 1   0 0     0   0                               1 0 1   0 0     0   0                        
917118 OR     school 4106000 2183   Gresham-Barlow SD 10J 410600001571 3553 Center for Advanced Learning   Regular School Yes High 11 12 2020   k_12_total 1 0 0   0 0     0   0                               1 0 0   0 0     0   0                        
917236 OR     school 4106930 2091   Junction City SD 69   1792 Jasper Mountain Center             2020   k_12_total 1 0 1   0 0     0   0                               1 0 1   0 0     0   0                        
917239 OR     school 4106930 2091   Junction City SD 69   3545 Looking Glass Center Point School             2020   k_12_total 1 0 0   0 0     0   0                               1 0 0   0 0     0   0                        
917335 OR     school   2098   Linn Benton Lincoln ESD   1271 Old Mill Center for Children & Families             2020   k_12_total 1 0 0   0 0     0   1                               1 0 0   0 0     0   1                        
917340 OR     school 4107590 2092   Lowell SD 71   2092 Lowell SD 71             2020   k_12_total 1 0 1   0 0     0   1                               1 0 1   0 0     0   1                        
917423 OR     school 4180180 2148   Multnomah ESD   1806 Shriners Hospital (educational program)             2020   k_12_total 1 0 0   0 0     0   0                               1 0 0   0 0     0   0                        
917441 OR     school 4108720 2254   Newberg SD 29J   2254 Newberg SD 29J             2020   k_12_total 1 0 0   0 0     0   0                               1 0 0   0 0     0   0                        
917687 OR     school 4110040 2180   Portland SD 1J   4522 Park Academy             2020   k_12_total 1 0 0   0 0     0   0                               1 0 0   0 0     0   0                        
917717 OR     school 4110040 2180   Portland SD 1J   4826 Victory Academy             2020   k_12_total 1 0 0   0 0     0   0                               1 0 0   0 0     0   0                        
917776 OR     school 4110560 2188   Riverdale SD 51J   2188 Riverdale SD 51J             2020   k_12_total 1 0 0   0 0     0   0                               1 0 0   0 0     0   0                        
917946 OR     school 4111670 2083   Springfield SD 19   1532 Looking Glass Riverfront School & Career Center             2020   k_12_total 1 0 0   0 0     0   0                               1 0 0   0 0     0   0                        
917960 OR     school 4111670 2083   Springfield SD 19   1545 Wellsprings Friends School             2020   k_12_total 1 0 0   0 0     0   0                               1 0 0   0 0     0   0                        
918029 OR     school 4112360 2222   Troy SD 54 411236001150 1092 Troy Elementary School   Regular School No Elementary KG 08 2020   k_12_total 1 0 0   0 0     0   2                               1 0 0   0 0     0   2                        
918089 OR     school 4113530 2146   Woodburn SD 103   2146 Woodburn SD 103             2020   k_12_total 1 0 12   0 0     0   0                               1 0 12   0 0     0   0                        
917202 OR     school 4106510 2024   Hood River County SD   2024 Hood River County SD             2020   k_12_total 10 1 20   2 0     0   0                               10 1 20   2 0     0   0                        
916771 OR     school 4101980 1976   Bend-LaPine Administrative SD 1 410198001871 5428 Realms High School   Regular School No Secondary 09 11 2020   k_12_total 100 0 11   0 0     0   2                               100 0 11   0 0     0   2                        
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                        
917075 OR     school 4105610 1931   Gladstone SD 115 410561001774 4719 Gladstone Center for Children and Families   Regular School No Elementary PK KG 2020   k_12_total 100 3 20   1 1     1   23                               100 3 20   1 1     1   23                        
917384 OR     school 4108160 2205   Milton-Freewater Unified SD 7 410816001842 5296 Ferndale Elementary School   Regular School No Elementary 04 05 2020   k_12_total 100 2 163   0 1     0   2                               100 2 163   0 1     0   2                        
917509 OR     school 4109000 2110   Nyssa SD 26 410900000751 703 Nyssa Middle School   Regular School No Middle 06 08 2020   k_12_total 100 0 183   0 0     0   10                               100 0 183   0 0     0   10                        
917839 OR     school 4110820 2142   Salem-Keizer SD 24J 411082001683 4390 Valley Inquiry Charter School   Regular School Yes Elementary KG 05 2020   k_12_total 100 0 42   1 2     1   21                               100 0 42   1 2     1   21                        
917847 OR     school 4110820 2142   Salem-Keizer SD 24J 411082000547 764 Yoshikai Elementary School   Regular School No Elementary KG 05 2020   k_12_total 100 7 368   2 3     19   20                               100 7 368   2 3     19   20                        
917096 OR     school 4101120 2100   Greater Albany Public SD 8J 410112001577 3950 Albany Options School   Alternative School No High 09 12 2020   k_12_total 101 1 33   1 2     0   7                               101 1 33   1 2     0   7                        
917414 OR     school 4108550 2145   Mt Angel SD 91 410855000837 792 Mt Angel Middle School   Regular School No Middle 06 08 2020   k_12_total 101 1 74   0 1     0   3                               101 1 74   0 1     0   3                        
917539 OR     school 4109270 2108   Ontario SD 8C 410927000743 696 May Roberts Elementary School   Regular School No Elementary KG 06 2020   k_12_total 101 6 258   2 2     0   16                               101 6 258   2 2     0   16                        
917646 OR     school 4110040 2180   Portland SD 1J 411004001581 3991 Emerson School   Regular School Yes Elementary KG 05 2020   k_12_total 101 2 14   0 2     0   24                               101 2 14   0 2     0   24                        
917766 OR     school 4110520 2182   Reynolds SD 7 411052001579 3989 Salish Ponds Elementary School   Regular School No Elementary KG 05 2020   k_12_total 101 26 235   1 17     21   26                               101 26 235   1 17     21   26                        
917804 OR     school 4110820 2142   Salem-Keizer SD 24J 411082000790 744 Hoover Elementary School   Regular School No Elementary KG 05 2020   k_12_total 101 7 279   0 2     13   20                               101 7 279   0 2     13   20                        
917872 OR     school 4111220 2257   Sheridan SD 48J 411122001803 4833 Sheridan AllPrep Academy   Regular School Yes Other KG 12 2020   k_12_total 101 2 15   1 0     1   5                               101 2 15   1 0     1   5                        
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                        
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                        
917760 OR     school 4110520 2182   Reynolds SD 7 411052001540 4216 Reynolds Arthur Academy   Regular School Yes Elementary KG 06 2020   k_12_total 102 3 38   6 16     0   13                               102 3 38   6 16     0   13                        
917802 OR     school 4110820 2142   Salem-Keizer SD 24J 411082000801 755 Hayesville Elementary School   Regular School No Elementary KG 05 2020   k_12_total 102 3 236   6 3     11   10                               102 3 236   6 3     11   10                        
917029 OR     school 4104740 2082   Eugene SD 4J 410474000572 538 Sheldon High School   Regular School No High 09 12 2020   k_12_total 1025 20 200   7 45     8   113                               1025 20 200   7 45     8   113                        
916737 OR     school 4101920 2243   Beaverton SD 48J 410192000554 1320 Westview High School   Regular School No High 09 12 2020   k_12_total 1026 86 517   9 645     17   173                               1026 86 517   9 645     17   173                        
916663 OR     school 4101660 2208   Athena-Weston SD 29RJ 410166001112 1053 Athena Elementary School   Regular School No Elementary KG 03 2020   k_12_total 103 0 18   5 0     0   11                               103 0 18   5 0     0   11                        
917536 OR     school 4109270 2108   Ontario SD 8C 410927000741 694 Aiken Elementary School   Regular School No Elementary KG 05 2020   k_12_total 103 3 169   0 0     0   12                               103 3 169   0 0     0   12                        
917824 OR     school 4110820 2142   Salem-Keizer SD 24J 411082004193 3528 Optimum Learning Environment Charter School   Regular School Yes Elementary 01 05 2020   k_12_total 103 2 8   1 7     0   10                               103 2 8   1 7     0   10                        
917649 OR     school 4110040 2180   Portland SD 1J 411004000960 911 Franklin High School   Regular School No High 09 12 2020   k_12_total 1035 87 361   8 258     14   169                               1035 87 361   8 258     14   169                        
917894 OR     school 4111450 2138   Silver Falls SD 4J 411145000857 812 Silverton High School   Regular School No High 09 12 2020   k_12_total 1035 10 198   12 16     3   26                               1035 10 198   12 16     3   26                        
916876 OR     school 4103390 1964   Coquille SD 8 410339000200 189 Lincoln School of Early Learning   Regular School No Elementary PK 01 2020   k_12_total 105 1 11   3 0     0   17                               105 1 11   3 0     0   17                        
917669 OR     school 4110040 2180   Portland SD 1J 411004000914 869 Lee Elementary School   Regular School No Elementary KG 05 2020   k_12_total 105 36 49   4 40     4   31                               105 36 49   4 40     4   31                        
917085 OR     school 4105670 1992   Glide SD 12 410567000303 284 Glide Middle School   Regular School No Middle 07 08 2020   k_12_total 106 0 7   3 1     0   7                               106 0 7   3 1     0   7                        
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                        
917369 OR     school 4108040 2048   Medford SD 549C 410804001829 5205 Kids Unlimited Academy   Regular School Yes Elementary KG 08 2020   k_12_total 107 2 335   2 2     1   19                               107 2 335   2 2     1   19                        
918019 OR     school 4112240 2242   Tigard-Tualatin SD 23J 411224001198 1146 Tigard High School   Regular School No High 09 12 2020   k_12_total 1071 35 409   13 107     34   107                               1071 35 409   13 107     34   107                        
917639 OR     school 4110040 2180   Portland SD 1J 411004000958 909 Cleveland High School   Regular School No High 09 12 2020   k_12_total 1074 32 132   5 152     7   157                               1074 32 132   5 152     7   157                        
916699 OR     school 4101920 2243   Beaverton SD 48J 410192001321 1162 Elmonica Elementary School   Regular School No Elementary KG 05 2020   k_12_total 108 14 175   3 204     4   41                               108 14 175   3 204     4   41                        
917007 OR     school 4104740 2082   Eugene SD 4J   2082 Eugene SD 4J             2020   k_12_total 108 3 18   4 1     0   16                               108 3 18   4 1     0   16                        
917541 OR     school 4109270 2108   Ontario SD 8C 410927000745 698 Ontario Middle School   Regular School No Middle 07 08 2020   k_12_total 108 5 235   2 2     0   11                               108 5 235   2 2     0   11                        
917606 OR     school 4109660 2202   Pilot Rock SD 2 410966001085 1027 Pilot Rock Elementary School   Regular School No Elementary KG 05 2020   k_12_total 108 0 9   3 0     0   4                               108 0 9   3 0     0   4                        
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                        
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                        
917176 OR     school 4100023 2239   Hillsboro SD 1J 410002301824 4973 Hillsboro Online Academy   Regular School No Other KG 12 2020   k_12_total 109 1 20   3 1     2   19                               109 1 20   3 1     2   19                        
917579 OR     school 4109480 2181   Parkrose SD 3 410948000979 925 Prescott Elementary School   Regular School No Elementary PK 05 2020   k_12_total 109 51 100   0 22     24   25                               109 51 100   0 22     24   25                        
917724 OR     school 4110040 2180   Portland SD 1J 411004000952 902 Woodlawn Elementary School   Regular School No Elementary PK 05 2020   k_12_total 109 102 54   1 4     6   32                               109 102 54   1 4     6   32                        
917030 OR     school 4104740 2082   Eugene SD 4J 410474000573 539 South Eugene High School   Regular School No High 09 12 2020   k_12_total 1091 18 168   15 71     2   166                               1091 18 168   15 71     2   166                        
917442 OR     school 4108720 2254   Newberg SD 29J 410872001274 1222 Newberg Senior High School   Regular School No High 09 12 2020   k_12_total 1094 15 313   9 39     2   63                               1094 15 313   9 39     2   63                        
916755 OR     school 4101980 1976   Bend-LaPine Administrative SD 1   1448 J Bar J Learning Centers - Sisters Academy Campus             2020   k_12_total 11 1 2   0 0     0   0                               11 1 2   0 0     0   0                        
916810 OR     school 4102640 1929   Canby SD 86   1929 Canby SD 86             2020   k_12_total 11 0 6   0 0     0   1                               11 0 6   0 0     0   1                        
916874 OR     school 4103390 1964   Coquille SD 8   1964 Coquille SD 8             2020   k_12_total 11 0 1   0 0     0   0                               11 0 1   0 0     0   0                        
916899 OR     school 4103690 2086   Creswell SD 40   2086 Creswell SD 40             2020   k_12_total 11 0 1   0 0     0   0                               11 0 1   0 0     0   0                        
916987 OR     school 4104700 1930   Estacada SD 108   1930 Estacada SD 108             2020   k_12_total 11 1 5   0 0     0   0                               11 1 5   0 0     0   0                        
917021 OR     school 4104740 2082   Eugene SD 4J   1786 New Roads             2020   k_12_total 11 0 0   0 0     0   3                               11 0 0   0 0     0   3                        
917524 OR     school   3476   ODE JDEP District   2846 Mill Creek Academy             2020   k_12_total 11 0 8   1 0     0   0                               11 0 8   1 0     0   0                        
918095 OR     school 4113650 1997   Yoncalla SD 32 411365000319 299 Yoncalla Elementary School   Regular School No Elementary KG 08 2020   k_12_total 110 1 17   1 0     0   10                               110 1 17   1 0     0   10                        
917672 OR     school 4110040 2180   Portland SD 1J 411004000966 914 Lincoln High School   Regular School No High 09 12 2020   k_12_total 1101 19 154   4 163     4   143                               1101 19 154   4 163     4   143                        
916763 OR     school 4101980 1976   Bend-LaPine Administrative SD 1 410198000271 252 Mountain View Senior High School   Regular School No High 09 12 2020   k_12_total 1102 13 181   13 26     6   31                               1102 13 181   13 26     6   31                        
918022 OR     school 4112240 2242   Tigard-Tualatin SD 23J 411224000440 1301 Tualatin High School   Regular School No High 09 12 2020   k_12_total 1105 25 494   10 121     43   146                               1105 25 494   10 121     43   146                        
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                        

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