Data source: Big Local News · About: Big Local

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

View and edit SQL

year

grade

  • k_12_total · 5,859
Link rowid state county county_state_id admin_level district_nces_id district_state_id district_state_type district school_nces_id school_state_id school school_state_type ccd_school_type ccd_charter_school ccd_school_lvl ccd_school_low_grade ccd_school_high_grade year term grade white black hispanic native_american native_american_alaskan_native asian native_hawaiian asian_pacific_islander native_hawaiian_pacific_islander pacific_islander multiracial unknown_race male female non_binary unknown_gender ell ell_percent homeless homeless_percent low_income free_and_reduced free_and_reduced_percent disability section_504 total white_int black_int hispanic_int ▲ native_american_int native_american_alaskan_native_int asian_int native_hawaiian_int asian_pacific_islander_int native_hawaiian_pacific_islander_int pacific_islander_int multiracial_int unknown_race_int male_int female_int non_binary_int unknown_gender_int ell_int homeless_int low_income_int free_and_reduced_int disability_int section_504_int total_int
1706474 OR     school 4110820 2142   Salem-Keizer SD 24J 411082001296 771 McKay High School   Regular School No High 09 12 2017   k_12_total 579.0 28.0 1583.0     74.0     106.0   57.0                               579 28 1583     74     106   57                        
1191649 OR     school 4110820 2142   Salem-Keizer SD 24J 411082001296 771 McKay High School   Regular School No High 09 12 2018   k_12_total 547.0 33.0 1575.0   13.0 82.0     107.0   58.0                               547 33 1575   13 82     107   58                        
657973 OR     school 4110820 2142   Salem-Keizer SD 24J 411082001296 771 McKay High School   Regular School No High 09 12 2021   k_12_total 492 31 1557   4 55     121   70                               492 31 1557   4 55     121   70                        
917817 OR     school 4110820 2142   Salem-Keizer SD 24J 411082001296 771 McKay High School   Regular School No High 09 12 2020   k_12_total 533 37 1520   5 65     103   56                               533 37 1520   5 65     103   56                        
657979 OR     school 4110820 2142   Salem-Keizer SD 24J 411082000818 773 North Salem High School   Regular School No High 09 12 2021   k_12_total 545 33 1274   15 27     73   82                               545 33 1274   15 27     73   82                        
657917 OR     school 4110520 2182   Reynolds SD 7 411052001009 957 Reynolds High School   Regular School No High 09 12 2021   k_12_total 779 210 1171   21 218     68   157                               779 210 1171   21 218     68   157                        
917761 OR     school 4110520 2182   Reynolds SD 7 411052001009 957 Reynolds High School   Regular School No High 09 12 2020   k_12_total 801 193 1153   18 219     72   136                               801 193 1153   18 219     72   136                        
1191595 OR     school 4110520 2182   Reynolds SD 7 411052001009 957 Reynolds High School   Regular School No High 09 12 2018   k_12_total 896.0 201.0 1116.0   18.0 266.0     49.0   154.0                               896 201 1116   18 266     49   154                        
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                        
1191655 OR     school 4110820 2142   Salem-Keizer SD 24J 411082000818 773 North Salem High School   Regular School No High 09 12 2018   k_12_total 533.0 25.0 1061.0   16.0 23.0     66.0   59.0                               533 25 1061   16 23     66   59                        
657207 OR     school 4105160 2241   Forest Grove SD 15 410516001189 1134 Forest Grove High School   Regular School No High 09 12 2021   k_12_total 721 12 1051   6 29     5   60                               721 12 1051   6 29     5   60                        
1706480 OR     school 4110820 2142   Salem-Keizer SD 24J 411082000818 773 North Salem High School   Regular School No High 09 12 2017   k_12_total 560.0 29.0 1046.0     30.0     62.0   69.0                               560 29 1046     30     62   69                        
917057 OR     school 4105160 2241   Forest Grove SD 15 410516001189 1134 Forest Grove High School   Regular School No High 09 12 2020   k_12_total 769 10 1040   6 30     3   57                               769 10 1040   6 30     3   57                        
1706421 OR     school 4110520 2182   Reynolds SD 7 411052001009 957 Reynolds High School   Regular School No High 09 12 2017   k_12_total 932.0 195.0 1029.0     260.0     40.0   134.0                               932 195 1029     260     40   134                        
1190892 OR     school 4105160 2241   Forest Grove SD 15 410516001189 1134 Forest Grove High School   Regular School No High 09 12 2018   k_12_total 817.0 9.0 995.0   5.0 24.0     4.0   54.0                               817 9 995   5 24     4   54                        
1705709 OR     school 4105160 2241   Forest Grove SD 15 410516001189 1134 Forest Grove High School   Regular School No High 09 12 2017   k_12_total 891.0 12.0 941.0     23.0     5.0   53.0                               891 12 941     23     5   53                        
657306 OR     school 4106300 2206   Hermiston SD 8 410630001097 1040 Hermiston High School   Regular School No High 09 12 2021   k_12_total 743 7 898   1 18     7   29                               743 7 898   1 18     7   29                        
657996 OR     school 4110820 2142   Salem-Keizer SD 24J 411082000814 768 Waldo Middle School   Regular School No Middle 06 08 2021   k_12_total 192 12 886   10 15     75   40                               192 12 886   10 15     75   40                        
917840 OR     school 4110820 2142   Salem-Keizer SD 24J 411082000814 768 Waldo Middle School   Regular School No Middle 06 08 2020   k_12_total 204 23 876   6 17     62   26                               204 23 876   6 17     62   26                        
917157 OR     school 4106300 2206   Hermiston SD 8 410630001097 1040 Hermiston High School   Regular School No High 09 12 2020   k_12_total 741 5 839   3 15     8   27                               741 5 839   3 15     8   27                        
656827 OR     school 4101920 2243   Beaverton SD 48J 410192001239 1186 Aloha High School   Regular School No High 09 12 2021   k_12_total 595 97 816   7 127     24   100                               595 97 816   7 127     24   100                        
916683 OR     school 4101920 2243   Beaverton SD 48J 410192001239 1186 Aloha High School   Regular School No High 09 12 2020   k_12_total 645 96 812   9 129     33   101                               645 96 812   9 129     33   101                        
657502 OR     school 4108010 2256   McMinnville SD 40 410801001284 1234 McMinnville High School   Regular School No High 09 12 2021   k_12_total 1209 28 799   38 23     9   8                               1209 28 799   38 23     9   8                        
1190991 OR     school 4106300 2206   Hermiston SD 8 410630001097 1040 Hermiston High School   Regular School No High 09 12 2018   k_12_total 774.0 13.0 799.0   6.0 13.0     5.0   27.0                               774 13 799   6 13     5   27                        
1190764 OR     school 4103940 2187   David Douglas SD 40 410394001037 983 David Douglas High School   Regular School No High 09 12 2018   k_12_total 1140.0 361.0 794.0   19.0 596.0     44.0   187.0                               1140 361 794   19 596     44   187                        
1705580 OR     school 4103940 2187   David Douglas SD 40 410394001037 983 David Douglas High School   Regular School No High 09 12 2017   k_12_total 1220.0 332.0 789.0     590.0     41.0   185.0                               1220 332 789     590     41   185                        
917835 OR     school 4110820 2142   Salem-Keizer SD 24J 411082000668 1331 Stephens Middle School   Regular School No Middle 06 08 2020   k_12_total 231 17 780   3 30     42   38                               231 17 780   3 30     42   38                        
657077 OR     school 4103940 2187   David Douglas SD 40 410394001037 983 David Douglas High School   Regular School No High 09 12 2021   k_12_total 909 339 779   22 504     63   191                               909 339 779   22 504     63   191                        
657991 OR     school 4110820 2142   Salem-Keizer SD 24J 411082000668 1331 Stephens Middle School   Regular School No Middle 06 08 2021   k_12_total 221 12 765   5 32     30   39                               221 12 765   5 32     30   39                        
916927 OR     school 4103940 2187   David Douglas SD 40 410394001037 983 David Douglas High School   Regular School No High 09 12 2020   k_12_total 970 346 763   20 501     62   184                               970 346 763   20 501     62   184                        
657975 OR     school 4110820 2142   Salem-Keizer SD 24J 411082000817 772 McNary High School   Regular School No High 09 12 2021   k_12_total 1089 16 761   12 27     33   123                               1089 16 761   12 27     33   123                        
917819 OR     school 4110820 2142   Salem-Keizer SD 24J 411082000817 772 McNary High School   Regular School No High 09 12 2020   k_12_total 1127 11 752   10 21     22   126                               1127 11 752   10 21     22   126                        
1705810 OR     school 4106300 2206   Hermiston SD 8 410630001097 1040 Hermiston High School   Regular School No High 09 12 2017   k_12_total 774.0 16.0 748.0     14.0     5.0   23.0                               774 16 748     14     5   23                        
1705334 OR     school 4101920 2243   Beaverton SD 48J 410192001239 1186 Aloha High School   Regular School No High 09 12 2017   k_12_total 877.0 99.0 746.0     117.0     28.0   112.0                               877 99 746     117     28   112                        
917353 OR     school 4108010 2256   McMinnville SD 40 410801001284 1234 McMinnville High School   Regular School No High 09 12 2020   k_12_total 1276 30 742   45 30     9   4                               1276 30 742   45 30     9   4                        
1190519 OR     school 4101920 2243   Beaverton SD 48J 410192001239 1186 Aloha High School   Regular School No High 09 12 2018   k_12_total 782.0 102.0 738.0   5.0 111.0     23.0   103.0                               782 102 738   5 111     23   103                        
1191184 OR     school 4108010 2256   McMinnville SD 40 410801001284 1234 McMinnville High School   Regular School No High 09 12 2018   k_12_total 1340.0 24.0 738.0   25.0 35.0     14.0   0.0                               1340 24 738   25 35     14   0                        
1706005 OR     school 4108010 2256   McMinnville SD 40 410801001284 1234 McMinnville High School   Regular School No High 09 12 2017   k_12_total 1360.0 25.0 734.0     35.0     14.0   0.0                               1360 25 734     35     14   0                        
917805 OR     school 4110820 2142   Salem-Keizer SD 24J 411082000664 1330 Houck Middle School   Regular School No Middle 06 08 2020   k_12_total 260 12 702   2 10     49   39                               260 12 702   2 10     49   39                        
657961 OR     school 4110820 2142   Salem-Keizer SD 24J 411082000664 1330 Houck Middle School   Regular School No Middle 06 08 2021   k_12_total 227 13 699   6 11     45   42                               227 13 699   6 11     45   42                        
1191667 OR     school 4110820 2142   Salem-Keizer SD 24J 411082000668 1331 Stephens Middle School   Regular School No Middle 06 08 2018   k_12_total 285.0 12.0 698.0   1.0 28.0     50.0   31.0                               285 12 698   1 28     50   31                        
656834 OR     school 4101920 2243   Beaverton SD 48J 410192001240 1187 Beaverton High School   Regular School No High 09 12 2021   k_12_total 650 45 689   5 76     13   89                               650 45 689   5 76     13   89                        
657989 OR     school 4110820 2142   Salem-Keizer SD 24J 411082000820 775 South Salem High School   Regular School No High 09 12 2021   k_12_total 1211 36 685   8 61     43   152                               1211 36 685   8 61     43   152                        
657324 OR     school 4100023 2239   Hillsboro SD 1J 410002301252 1201 Hillsboro High School   Regular School No High 09 12 2021   k_12_total 390 28 679   10 58     8   82                               390 28 679   10 58     8   82                        
1191651 OR     school 4110820 2142   Salem-Keizer SD 24J 411082000817 772 McNary High School   Regular School No High 09 12 2018   k_12_total 1142.0 15.0 677.0   21.0 27.0     24.0   110.0                               1142 15 677   21 27     24   110                        
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                        
1191916 OR     school 4113530 2146   Woodburn SD 103 411353000843 1267 Lincoln Elementary School   Regular School No Elementary KG 05 2018   k_12_total 88.0 6.0 674.0   1.0 4.0     2.0   5.0                               88 6 674   1 4     2   5                        
1706492 OR     school 4110820 2142   Salem-Keizer SD 24J 411082000668 1331 Stephens Middle School   Regular School No Middle 06 08 2017   k_12_total 309.0 13.0 662.0     31.0     47.0   37.0                               309 13 662     31     47   37                        
658004 OR     school 4108100 2104   Santiam Canyon SD 129J 410810001680 4399 Oregon Charter Academy   Regular School Yes Other KG 12 2021   k_12_total 3451 110 655   78 138     33   246                               3451 110 655   78 138     33   246                        
1706476 OR     school 4110820 2142   Salem-Keizer SD 24J 411082000817 772 McNary High School   Regular School No High 09 12 2017   k_12_total 1187.0 15.0 649.0     33.0     16.0   106.0                               1187 15 649     33     16   106                        
1191672 OR     school 4110820 2142   Salem-Keizer SD 24J 411082000814 768 Waldo Middle School   Regular School No Middle 06 08 2018   k_12_total 276.0 17.0 647.0   8.0 25.0     35.0   24.0                               276 17 647   8 25     35   24                        
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                        
1191637 OR     school 4110820 2142   Salem-Keizer SD 24J 411082000664 1330 Houck Middle School   Regular School No Middle 06 08 2018   k_12_total 311.0 9.0 639.0   5.0 18.0     43.0   36.0                               311 9 639   5 18     43   36                        
657275 OR     school 4106000 2183   Gresham-Barlow SD 10J 410600001040 986 Gresham High School   Regular School No High 09 12 2021   k_12_total 652 71 626   8 52     17   106                               652 71 626   8 52     17   106                        
918079 OR     school 4113530 2146   Woodburn SD 103 411353000844 1268 French Prairie Middle School   Regular School No Middle 06 08 2020   k_12_total 56 3 623   2 3     3   2                               56 3 623   2 3     3   2                        
917175 OR     school 4100023 2239   Hillsboro SD 1J 410002301252 1201 Hillsboro High School   Regular School No High 09 12 2020   k_12_total 458 23 621   9 55     8   65                               458 23 621   9 55     8   65                        
1706740 OR     school 4113530 2146   Woodburn SD 103 411353001051 1359 Heritage Elementary   Regular School No Elementary KG 05 2017   k_12_total 282.0 0.0 618.0     1.0     1.0   3.0                               282 0 618     1     1   3                        
1706463 OR     school 4110820 2142   Salem-Keizer SD 24J 411082000664 1330 Houck Middle School   Regular School No Middle 06 08 2017   k_12_total 291.0 14.0 615.0     20.0     34.0   30.0                               291 14 615     20     34   30                        
1705858 OR     school 4106510 2024   Hood River County SD 410651000390 369 Hood River Valley High School   Regular School No High 09 12 2017   k_12_total 687.0 10.0 607.0     21.0     2.0   31.0                               687 10 607     21     2   31                        
1191009 OR     school 4100023 2239   Hillsboro SD 1J 410002301252 1201 Hillsboro High School   Regular School No High 09 12 2018   k_12_total 509.0 24.0 606.0   13.0 62.0     10.0   64.0                               509 24 606   13 62     10   64                        
1705829 OR     school 4100023 2239   Hillsboro SD 1J 410002301252 1201 Hillsboro High School   Regular School No High 09 12 2017   k_12_total 529.0 24.0 606.0     62.0     9.0   63.0                               529 24 606     62     9   63                        
658233 OR     school 4113530 2146   Woodburn SD 103 411353000844 1268 French Prairie Middle School   Regular School No Middle 06 08 2021   k_12_total 61 4 604   2 3     1   3                               61 4 604   2 3     1   3                        
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                        
1191915 OR     school 4113530 2146   Woodburn SD 103 411353001051 1359 Heritage Elementary   Regular School No Elementary KG 05 2018   k_12_total 280.0 1.0 600.0   2.0 0.0     3.0   6.0                               280 1 600   2 0     3   6                        
657322 OR     school 4100023 2239   Hillsboro SD 1J 410002301306 1200 Glencoe High School   Regular School No High 09 12 2021   k_12_total 664 30 594   5 45     3   73                               664 30 594   5 45     3   73                        
918081 OR     school 4113530 2146   Woodburn SD 103 411353000843 1267 Lincoln Elementary School   Regular School No Elementary KG 05 2020   k_12_total 79 1 589   0 2     6   8                               79 1 589   0 2     6   8                        
1191914 OR     school 4113530 2146   Woodburn SD 103 411353000844 1268 French Prairie Middle School   Regular School No Middle 06 08 2018   k_12_total 61.0 2.0 588.0   0.0 1.0     3.0   4.0                               61 2 588   0 1     3   4                        
1190525 OR     school 4101920 2243   Beaverton SD 48J 410192001240 1187 Beaverton High School   Regular School No High 09 12 2018   k_12_total 807.0 65.0 585.0   8.0 101.0     24.0   100.0                               807 65 585   8 101     24   100                        
917833 OR     school 4110820 2142   Salem-Keizer SD 24J 411082000820 775 South Salem High School   Regular School No High 09 12 2020   k_12_total 1201 28 580   12 58     41   137                               1201 28 580   12 58     41   137                        
1191038 OR     school 4106510 2024   Hood River County SD 410651000390 369 Hood River Valley High School   Regular School No High 09 12 2018   k_12_total 670.0 14.0 580.0   4.0 21.0     2.0   25.0                               670 14 580   4 21     2   25                        
1706497 OR     school 4110820 2142   Salem-Keizer SD 24J 411082000814 768 Waldo Middle School   Regular School No Middle 06 08 2017   k_12_total 285.0 17.0 580.0     21.0     43.0   28.0                               285 17 580     21     43   28                        
1190961 OR     school 4106000 2183   Gresham-Barlow SD 10J 410600001040 986 Gresham High School   Regular School No High 09 12 2018   k_12_total 732.0 60.0 576.0   15.0 62.0     9.0   77.0                               732 60 576   15 62     9   77                        
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                        
917173 OR     school 4100023 2239   Hillsboro SD 1J 410002301306 1200 Glencoe High School   Regular School No High 09 12 2020   k_12_total 764 28 555   9 62     5   66                               764 28 555   9 62     5   66                        
918083 OR     school 4113530 2146   Woodburn SD 103 411353001052 1360 Valor Middle School   Regular School No Middle 06 08 2020   k_12_total 129 1 555   1 3     0   7                               129 1 555   1 3     0   7                        
1705340 OR     school 4101920 2243   Beaverton SD 48J 410192001240 1187 Beaverton High School   Regular School No High 09 12 2017   k_12_total 970.0 54.0 555.0     101.0     29.0   115.0                               970 54 555     101     29   115                        
658235 OR     school 4113530 2146   Woodburn SD 103 411353000843 1267 Lincoln Elementary School   Regular School No Elementary KG 05 2021   k_12_total 57 2 553   0 2     3   6                               57 2 553   0 2     3   6                        
1705335 OR     school 4101920 2243   Beaverton SD 48J 410192001204 1153 Aloha-Huber Park School   Regular School No Elementary PK 08 2017   k_12_total 252.0 63.0 553.0     55.0     2.0   47.0                               252 63 553     55     2   47                        
1705827 OR     school 4100023 2239   Hillsboro SD 1J 410002301306 1200 Glencoe High School   Regular School No High 09 12 2017   k_12_total 898.0 24.0 551.0     50.0     5.0   62.0                               898 24 551     50     5   62                        
917848 OR     school 4108100 2104   Santiam Canyon SD 129J 410810001680 4399 Oregon Connections Academy   Regular School Yes Other KG 12 2020   k_12_total 2744 81 548   51 71     13   341                               2744 81 548   51 71     13   341                        
657353 OR     school 4106510 2024   Hood River County SD 410651000390 369 Hood River Valley High School   Regular School No High 09 12 2021   k_12_total 705 8 547   10 14     0   34                               705 8 547   10 14     0   34                        
917204 OR     school 4106510 2024   Hood River County SD 410651000390 369 Hood River Valley High School   Regular School No High 09 12 2020   k_12_total 710 8 546   8 22     1   32                               710 8 546   8 22     1   32                        
1191007 OR     school 4100023 2239   Hillsboro SD 1J 410002301306 1200 Glencoe High School   Regular School No High 09 12 2018   k_12_total 837.0 18.0 546.0   9.0 54.0     7.0   70.0                               837 18 546   9 54     7   70                        
657333 OR     school 4100023 2239   Hillsboro SD 1J 410002301585 4018 Liberty High School   Regular School No High 09 12 2021   k_12_total 644 30 545   17 91     21   93                               644 30 545   17 91     21   93                        
657529 OR     school 4108040 2048   Medford SD 549C 410804000444 423 South Medford High School   Regular School No High 09 12 2021   k_12_total 1071 21 542   9 20     6   76                               1071 21 542   9 20     6   76                        
918084 OR     school 4113530 2146   Woodburn SD 103 411353000842 797 Washington Elementary School   Regular School No Elementary KG 05 2020   k_12_total 2 0 540   0 0     0   1                               2 0 540   0 0     0   1                        
657919 OR     school 4110520 2182   Reynolds SD 7 411052001010 1254 Reynolds Middle School   Regular School No Middle 06 08 2021   k_12_total 202 70 539   8 31     32   62                               202 70 539   8 31     32   62                        
918080 OR     school 4113530 2146   Woodburn SD 103 411353001051 1359 Heritage Elementary   Regular School No Elementary KG 05 2020   k_12_total 256 2 539   1 3     0   7                               256 2 539   1 3     0   7                        
656970 OR     school 4102800 2185   Centennial SD 28J 410280001020 967 Centennial High School   Regular School No High 09 12 2021   k_12_total 646 102 538   11 248     45   100                               646 102 538   11 248     45   100                        
658176 OR     school 4112240 2242   Tigard-Tualatin SD 23J 411224000440 1301 Tualatin High School   Regular School No High 09 12 2021   k_12_total 988 27 538   9 118     46   140                               988 27 538   9 118     46   140                        
917763 OR     school 4110520 2182   Reynolds SD 7 411052001010 1254 Reynolds Middle School   Regular School No Middle 06 08 2020   k_12_total 232 62 535   8 39     40   66                               232 62 535   8 39     40   66                        
1191665 OR     school 4110820 2142   Salem-Keizer SD 24J 411082000820 775 South Salem High School   Regular School No High 09 12 2018   k_12_total 1130.0 20.0 533.0   22.0 67.0     32.0   145.0                               1130 20 533   22 67     32   145                        
1706739 OR     school 4113530 2146   Woodburn SD 103 411353000844 1268 French Prairie Middle School   Regular School No Middle 06 08 2017   k_12_total 64.0 6.0 531.0     0.0     2.0   3.0                               64 6 531     0     2   3                        
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                        
916684 OR     school 4101920 2243   Beaverton SD 48J 410192001204 1153 Aloha-Huber Park School   Regular School No Elementary PK 08 2020   k_12_total 222 44 525   4 53     2   40                               222 44 525   4 53     2   40                        
1191918 OR     school 4113530 2146   Woodburn SD 103 411353001052 1360 Valor Middle School   Regular School No Middle 06 08 2018   k_12_total 135.0 1.0 525.0   1.0 3.0     1.0   5.0                               135 1 525   1 3     1   5                        
917061 OR     school 4105160 2241   Forest Grove SD 15 410516001188 1126 Neil Armstrong Middle School   Regular School No Middle 07 08 2020   k_12_total 317 5 524   5 7     3   26                               317 5 524   5 7     3   26                        
1191856 OR     school 4112240 2242   Tigard-Tualatin SD 23J 411224000440 1301 Tualatin High School   Regular School No High 09 12 2018   k_12_total 1200.0 36.0 523.0   5.0 108.0     31.0   103.0                               1200 36 523   5 108     31   103                        
658237 OR     school 4113530 2146   Woodburn SD 103 411353001052 1360 Valor Middle School   Regular School No Middle 06 08 2021   k_12_total 117 1 520   1 4     1   3                               117 1 520   1 4     1   3                        
657211 OR     school 4105160 2241   Forest Grove SD 15 410516001188 1126 Neil Armstrong Middle School   Regular School No Middle 07 08 2021   k_12_total 300 7 518   5 3     1   25                               300 7 518   5 3     1   25                        

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "enrollments" (
   [state] TEXT,
   [county] TEXT,
   [county_state_id] INTEGER,
   [admin_level] TEXT,
   [district_nces_id] INTEGER,
   [district_state_id] TEXT,
   [district_state_type] TEXT,
   [district] TEXT,
   [school_nces_id] INTEGER,
   [school_state_id] INTEGER,
   [school] TEXT,
   [school_state_type] TEXT,
   [ccd_school_type] TEXT,
   [ccd_charter_school] TEXT,
   [ccd_school_lvl] TEXT,
   [ccd_school_low_grade] TEXT,
   [ccd_school_high_grade] TEXT,
   [year] INTEGER,
   [term] TEXT,
   [grade] TEXT,
   [white] TEXT,
   [black] TEXT,
   [hispanic] TEXT,
   [native_american] TEXT,
   [native_american_alaskan_native] TEXT,
   [asian] TEXT,
   [native_hawaiian] TEXT,
   [asian_pacific_islander] TEXT,
   [native_hawaiian_pacific_islander] TEXT,
   [pacific_islander] TEXT,
   [multiracial] TEXT,
   [unknown_race] TEXT,
   [male] TEXT,
   [female] TEXT,
   [non_binary] TEXT,
   [unknown_gender] TEXT,
   [ell] TEXT,
   [ell_percent] TEXT,
   [homeless] TEXT,
   [homeless_percent] TEXT,
   [low_income] TEXT,
   [free_and_reduced] TEXT,
   [free_and_reduced_percent] TEXT,
   [disability] TEXT,
   [section_504] TEXT,
   [total] TEXT
, [white_int] INTEGER, [black_int] INTEGER, [hispanic_int] INTEGER, [native_american_int] INTEGER, [native_american_alaskan_native_int] INTEGER, [asian_int] INTEGER, [native_hawaiian_int] INTEGER, [asian_pacific_islander_int] INTEGER, [native_hawaiian_pacific_islander_int] INTEGER, [pacific_islander_int] INTEGER, [multiracial_int] INTEGER, [unknown_race_int] INTEGER, [male_int] INTEGER, [female_int] INTEGER, [non_binary_int] INTEGER, [unknown_gender_int] INTEGER, [ell_int] INTEGER, [homeless_int] INTEGER, [low_income_int] INTEGER, [free_and_reduced_int] INTEGER, [disability_int] INTEGER, [section_504_int] INTEGER, [total_int] INTEGER);
CREATE INDEX [idx_enrollments_state_grade]
    ON [enrollments] ([state], [grade]);
CREATE INDEX [idx_enrollments_grade]
    ON [enrollments] ([grade]);
CREATE INDEX [idx_enrollments_year]
    ON [enrollments] ([year]);
CREATE INDEX [idx_enrollments_state_year]
    ON [enrollments] ([state], [year]);
CREATE INDEX [idx_enrollments_school_nces_id]
    ON [enrollments] ([school_nces_id]);
CREATE INDEX [idx_enrollments_district_nces_id]
    ON [enrollments] ([district_nces_id]);