enrollments

Data source: Big Local News · About: Big Local

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

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2021 · 1,471 ✖

grade ✖

  • k_12_total · 1,471 ✖
Link rowid state county county_state_id admin_level district_nces_id district_state_id district_state_type district school_nces_id school_state_id school school_state_type ccd_school_type ccd_charter_school ccd_school_lvl ccd_school_low_grade ccd_school_high_grade year term grade white black hispanic native_american native_american_alaskan_native asian native_hawaiian asian_pacific_islander native_hawaiian_pacific_islander pacific_islander multiracial unknown_race male female non_binary unknown_gender ell ell_percent homeless homeless_percent low_income free_and_reduced free_and_reduced_percent disability section_504 total white_int black_int hispanic_int native_american_int native_american_alaskan_native_int asian_int native_hawaiian_int asian_pacific_islander_int native_hawaiian_pacific_islander_int pacific_islander_int multiracial_int ▲ unknown_race_int male_int female_int non_binary_int unknown_gender_int ell_int homeless_int low_income_int free_and_reduced_int disability_int section_504_int total_int
657600 657600 OR     school 4108820 1966   North Bend SD 13 410882001751 4690 Oregon Virtual Academy   Regular School Yes Other KG 12 2021   k_12_total 2266 77 514   30 51     9   268                               2266 77 514   30 51     9   268                        
657807 657807 OR     school 4110040 2180   Portland SD 1J 411004000962 912 Grant High School   Regular School No High 09 12 2021   k_12_total 1374 114 147   11 54     6   260                               1374 114 147   11 54     6   260                        
658004 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                        
657852 657852 OR     school 4110040 2180   Portland SD 1J 411004000930 883 Richmond Elementary School   Regular School No Elementary PK 05 2021   k_12_total 281 6 24   0 54     0   236                               281 6 24   0 54     0   236                        
657606 657606 OR     school 4108830 1924   North Clackamas SD 12 410883000093 85 Clackamas High School   Regular School No High 09 12 2021   k_12_total 1378 46 318   6 443     9   195                               1378 46 318   6 443     9   195                        
657077 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                        
657794 657794 OR     school 4110040 2180   Portland SD 1J 411004000958 909 Cleveland High School   Regular School No High 09 12 2021   k_12_total 1065 39 142   2 142     7   185                               1065 39 142   2 142     7   185                        
657804 657804 OR     school 4110040 2180   Portland SD 1J 411004000960 911 Franklin High School   Regular School No High 09 12 2021   k_12_total 1054 88 386   10 260     19   182                               1054 88 386   10 260     19   182                        
658021 658021 OR     school 4111040 2103   Scio SD 95 411104001876 5457 Willamette Connections Academy   Regular School Yes Other KG 12 2021   k_12_total 1639 28 257   16 28     12   179                               1639 28 257   16 28     12   179                        
656879 656879 OR     school 4101920 2243   Beaverton SD 48J 410192001241 1188 Sunset High School   Regular School No High 09 12 2021   k_12_total 1066 22 208   5 540     8   177                               1066 22 208   5 540     8   177                        
657180 657180 OR     school 4104740 2082   Eugene SD 4J 410474000573 539 South Eugene High School   Regular School No High 09 12 2021   k_12_total 1086 12 169   16 82     2   171                               1086 12 169   16 82     2   171                        
656883 656883 OR     school 4101920 2243   Beaverton SD 48J 410192000554 1320 Westview High School   Regular School No High 09 12 2021   k_12_total 953 84 482   12 652     18   165                               953 84 482   12 652     18   165                        
656863 656863 OR     school 4101920 2243   Beaverton SD 48J 410192001855 5381 Mountainside High School   Regular School No High 09 12 2021   k_12_total 1055 42 253   4 232     8   160                               1055 42 253   4 232     8   160                        
657917 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                        
657876 657876 OR     school 4110040 2180   Portland SD 1J 411004000975 922 Wilson High School   Regular School No High 09 12 2021   k_12_total 1147 64 126   5 34     8   156                               1147 64 126   5 34     8   156                        
657827 657827 OR     school 4110040 2180   Portland SD 1J 411004000966 914 Lincoln High School   Regular School No High 09 12 2021   k_12_total 988 26 160   3 148     2   155                               988 26 160   3 148     2   155                        
657989 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                        
656814 656814 OR     school 4101710 1894   Baker SD 5J 410171001767 4728 Baker Web Academy   Regular School Yes Other KG 12 2021   k_12_total 2209 24 292   22 27     9   144                               2209 24 292   22 27     9   144                        
657237 657237 OR     school 4105910 2054   Grants Pass SD 7 410591000464 442 Grants Pass High School   Regular School No High 09 12 2021   k_12_total 1337 6 294   20 21     4   141                               1337 6 294   20 21     4   141                        
658176 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                        
657708 657708 OR     school 4109330 1928   Oregon City SD 62 410933000126 118 Oregon City Senior High School   Regular School No High 09 12 2021   k_12_total 1368 14 281   7 22     5   139                               1368 14 281   7 22     5   139                        
657151 657151 OR     school 4104740 2082   Eugene SD 4J 410474000575 540 Churchill High School   Regular School No High 09 12 2021   k_12_total 685 37 208   14 28     13   131                               685 37 208   14 28     13   131                        
657179 657179 OR     school 4104740 2082   Eugene SD 4J 410474000572 538 Sheldon High School   Regular School No High 09 12 2021   k_12_total 1007 26 191   11 51     11   130                               1007 26 191   11 51     11   130                        
657448 657448 OR     school 4107230 1923   Lake Oswego SD 7J 410723000069 62 Lakeridge High School   Regular School No High 09 12 2021   k_12_total 935 13 97   2 75     3   129                               935 13 97   2 75     3   129                        
658173 658173 OR     school 4112240 2242   Tigard-Tualatin SD 23J 411224001198 1146 Tigard High School   Regular School No High 09 12 2021   k_12_total 1049 32 427   11 102     32   129                               1049 32 427   11 102     32   129                        
658217 658217 OR     school 4113170 1922   West Linn-Wilsonville SD 3J 411317000058 51 West Linn High School   Regular School No High 09 12 2021   k_12_total 1496 17 131   6 103     6   128                               1496 17 131   6 103     6   128                        
657837 657837 OR     school 4110040 2180   Portland SD 1J 411004000922 877 Mt Tabor Middle School   Regular School No Middle 06 08 2021   k_12_total 463 8 82   0 37     4   127                               463 8 82   0 37     4   127                        
658000 658000 OR     school 4110820 2142   Salem-Keizer SD 24J 411082004191 3463 West Salem High School   Regular School No High 09 12 2021   k_12_total 1147 23 363   20 43     10   126                               1147 23 363   20 43     10   126                        
657110 657110 OR     school 4110710 1991   Douglas County SD 4 411071000300 280 Roseburg High School   Regular School No High 09 12 2021   k_12_total 1182 11 194   17 28     2   124                               1182 11 194   17 28     2   124                        
657975 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                        
656849 656849 OR     school 4101920 2243   Beaverton SD 48J 410192001894 5506 FLEX Online School   Regular School No Other KG 12 2021   k_12_total 737 22 156   4 150     22   122                               737 22 156   4 150     22   122                        
657829 657829 OR     school 4110040 2180   Portland SD 1J 411004000968 915 Madison High School   Regular School No High 09 12 2021   k_12_total 405 168 294   10 149     24   119                               405 168 294   10 149     24   119                        
656876 656876 OR     school 4101920 2243   Beaverton SD 48J 410192001432 2783 Southridge High School   Regular School No High 09 12 2021   k_12_total 735 43 472   8 93     17   113                               735 43 472   8 93     17   113                        
657990 657990 OR     school 4110820 2142   Salem-Keizer SD 24J 411082000819 774 Sprague High School   Regular School No High 09 12 2021   k_12_total 1160 33 314   23 62     27   113                               1160 33 314   23 62     27   113                        
656792 656792 OR     school 4101560 2041   Ashland SD 5 410156000401 381 Ashland High School   Regular School No High 09 12 2021   k_12_total 695 6 108   2 15     0   112                               695 6 108   2 15     0   112                        
656944 656944 OR     school 4102040 2088   Bethel SD 52 410204000623 588 Willamette High School   Regular School No High 09 12 2021   k_12_total 946 35 349   22 41     13   111                               946 35 349   22 41     13   111                        
657316 657316 OR     school 4100023 2239   Hillsboro SD 1J 410002301248 1368 Century High School   Regular School No High 09 12 2021   k_12_total 653 46 482   11 192     23   110                               653 46 482   11 192     23   110                        
657325 657325 OR     school 4100023 2239   Hillsboro SD 1J 410002301824 4973 Hillsboro Online Academy   Regular School No Other KG 12 2021   k_12_total 806 29 158   7 31     5   109                               806 29 158   7 31     5   109                        
658106 658106 OR     school 4111670 2083   Springfield SD 19 411167000594 560 Springfield High School   Regular School No High 09 12 2021   k_12_total 744 21 427   18 13     11   109                               744 21 427   18 13     11   109                        
658110 658110 OR     school 4111670 2083   Springfield SD 19 411167000595 561 Thurston High School   Regular School No High 09 12 2021   k_12_total 921 16 174   11 6     8   108                               921 16 174   11 6     8   108                        
656855 656855 OR     school 4101920 2243   Beaverton SD 48J 410192001647 4474 International School of Beaverton   Regular School No High 06 12 2021   k_12_total 308 28 136   0 289     0   106                               308 28 136   0 289     0   106                        
657275 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                        
657266 657266 OR     school 4101120 2100   Greater Albany Public SD 8J 410112000735 649 West Albany High School   Regular School No High 09 12 2021   k_12_total 891 10 183   7 19     4   104                               891 10 183   7 19     4   104                        
656854 656854 OR     school 4101920 2243   Beaverton SD 48J 410192001823 4867 Hope Chinese Charter School   Regular School Yes Elementary KG 08 2021   k_12_total 75 3 22   0 132     0   102                               75 3 22   0 132     0   102                        
657287 657287 OR     school 4106000 2183   Gresham-Barlow SD 10J 410600001041 987 Sam Barlow High School   Regular School No High 09 12 2021   k_12_total 1084 36 377   12 66     11   102                               1084 36 377   12 66     11   102                        
657027 657027 OR     school 4103420 2186   Corbett SD 39 410342001729 4592 Corbett School   Regular School Yes Other KG 12 2021   k_12_total 846 11 96   11 15     2   101                               846 11 96   11 15     2   101                        
657445 657445 OR     school 4107230 1923   Lake Oswego SD 7J 410723000066 59 Lake Oswego Middle School   Regular School No Middle 06 08 2021   k_12_total 550 7 65   3 131     2   101                               550 7 65   3 131     2   101                        
657855 657855 OR     school 4110040 2180   Portland SD 1J 411004001821 918 Roosevelt High School   Regular School No High 09 12 2021   k_12_total 431 203 466   15 42     35   101                               431 203 466   15 42     35   101                        
656827 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                        
656970 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                        
658220 658220 OR     school 4113170 1922   West Linn-Wilsonville SD 3J 411317000574 1323 Wilsonville High School   Regular School No High 09 12 2021   k_12_total 807 12 227   5 53     9   99                               807 12 227   5 53     9   99                        
657172 657172 OR     school 4104740 2082   Eugene SD 4J 410474000571 536 North Eugene High School   Regular School No High 09 12 2021   k_12_total 691 6 180   7 20     3   98                               691 6 180   7 20     3   98                        
657783 657783 OR     school 4110040 2180   Portland SD 1J 411004000956 906 Benson Polytechnic High School   Regular School No High 09 12 2021   k_12_total 440 117 271   6 66     7   98                               440 117 271   6 66     7   98                        
657610 657610 OR     school 4108830 1924   North Clackamas SD 12 410883001782 4715 Happy Valley Middle School   Regular School No Middle 06 08 2021   k_12_total 589 15 96   5 245     5   97                               589 15 96   5 245     5   97                        
657189 657189 OR     school 4104740 2082   Eugene SD 4J 410474001348 1259 Yujin Gakuen Elementary School   Regular School No Elementary KG 05 2021   k_12_total 149 0 30   0 16     1   95                               149 0 30   0 16     1   95                        
657447 657447 OR     school 4107230 1923   Lake Oswego SD 7J 410723000068 61 Lake Oswego Senior High School   Regular School No High 09 12 2021   k_12_total 874 12 106   2 161     1   95                               874 12 106   2 161     1   95                        
657880 657880 OR     school 4110040 2180   Portland SD 1J 411004000954 904 Woodstock Elementary School   Regular School No Elementary KG 05 2021   k_12_total 268 1 31   0 133     1   94                               268 1 31   0 133     1   94                        
656948 656948 OR     school 4102310 1974   Brookings-Harbor SD 17C 410231000255 237 Brookings-Harbor High School   Regular School No High 09 12 2021   k_12_total 290 6 80   15 1     0   93                               290 6 80   15 1     0   93                        
657333 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                        
657622 657622 OR     school 4108830 1924   North Clackamas SD 12 410883000095 87 Putnam High School   Regular School No High 09 12 2021   k_12_total 685 18 289   6 29     6   93                               685 18 289   6 29     6   93                        
657729 657729 OR     school 4109480 2181   Parkrose SD 3 410948000987 931 Parkrose High School   Regular School No High 09 12 2021   k_12_total 261 159 298   6 157     36   93                               261 159 298   6 157     36   93                        
657525 657525 OR     school 4108040 2048   Medford SD 549C 410804000445 424 North Medford High School   Regular School No High 09 12 2021   k_12_total 1061 19 424   5 36     23   92                               1061 19 424   5 36     23   92                        
658039 658039 OR     school 4111290 2244   Sherwood SD 88J 411129001246 1193 Sherwood High School   Regular School No High 09 12 2021   k_12_total 1296 8 166   9 38     11   91                               1296 8 166   9 38     11   91                        
657873 657873 OR     school 4110040 2180   Portland SD 1J 411004000947 898 West Sylvan Middle School   Regular School No Middle 06 08 2021   k_12_total 537 27 71   3 71     1   90                               537 27 71   3 71     1   90                        
656834 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                        
656830 656830 OR     school 4101920 2243   Beaverton SD 48J 410192000213 1304 Arts and Communication Magnet Academy   Regular School No High 06 12 2021   k_12_total 464 14 102   3 35     2   87                               464 14 102   3 35     2   87                        
657298 657298 OR     school 4103630 2023   Harney County Union High SD 1J 410363001756 4702 Silvies River Charter School   Regular School Yes Other KG 12 2021   k_12_total 872 3 41   8 18     1   85                               872 3 41   8 18     1   85                        
657725 657725 OR     school 4110890 1926   Oregon Trail SD 46 411089000149 141 Sandy High School   Regular School No High 09 12 2021   k_12_total 1026 8 193   6 13     6   85                               1026 8 193   6 13     6   85                        
657813 657813 OR     school 4110040 2180   Portland SD 1J 411004000902 858 Hosford Middle School   Regular School No Middle 06 08 2021   k_12_total 405 27 68   1 86     3   85                               405 27 68   1 86     3   85                        
658177 658177 OR     school 4112240 2242   Tigard-Tualatin SD 23J 411224001197 1145 Twality Middle School   Regular School No Middle 06 08 2021   k_12_total 558 24 259   6 63     22   85                               558 24 259   6 63     22   85                        
656842 656842 OR     school 4101920 2243   Beaverton SD 48J 410192000552 1319 Conestoga Middle School   Regular School No Middle 06 08 2021   k_12_total 479 35 183   2 97     17   84                               479 35 183   2 97     17   84                        
657017 657017 OR     school 4103660 1965   Coos Bay SD 9 410366000216 201 Marshfield Senior High School   Regular School No High 08 12 2021   k_12_total 692 4 161   34 5     6   84                               692 4 161   34 5     6   84                        
657802 657802 OR     school 4110040 2180   Portland SD 1J 411004000890 847 Faubion Elementary School   Regular School No Elementary PK 08 2021   k_12_total 177 198 206   13 13     10   84                               177 198 206   13 13     10   84                        
658040 658040 OR     school 4111290 2244   Sherwood SD 88J 411129001245 1192 Sherwood Middle School   Regular School No Middle 06 08 2021   k_12_total 935 9 127   4 43     7   84                               935 9 127   4 43     7   84                        
657848 657848 OR     school 4110040 2180   Portland SD 1J   2180 Portland SD 1J             2021   k_12_total 356 55 71   1 52     2   83                               356 55 71   1 52     2   83                        
657324 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                        
657818 657818 OR     school 4110040 2180   Portland SD 1J 411004000964 913 Jefferson High School   Regular School No High 09 12 2021   k_12_total 182 204 135   2 9     6   82                               182 204 135   2 9     6   82                        
657979 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                        
656949 656949 OR     school 4102310 1974   Brookings-Harbor SD 17C 410231000254 236 Kalmiopsis Elementary School   Regular School No Elementary KG 05 2021   k_12_total 369 0 122   22 10     1   81                               369 0 122   22 10     1   81                        
657815 657815 OR     school 4110040 2180   Portland SD 1J 411004001365 1277 Jackson Middle School   Regular School No Middle 06 08 2021   k_12_total 551 57 75   3 30     6   81                               551 57 75   3 30     6   81                        
658107 658107 OR     school 4111670 2083   Springfield SD 19   2083 Springfield SD 19             2021   k_12_total 995 3 205   8 6     3   81                               995 3 205   8 6     3   81                        
657460 657460 OR     school 4107380 2101   Lebanon Community SD 9 410738000730 688 Lebanon High School   Regular School No High 09 12 2021   k_12_total 969 4 134   12 12     6   77                               969 4 134   12 12     6   77                        
658212 658212 OR     school 4113170 1922   West Linn-Wilsonville SD 3J 411317001414 2787 Rosemont Ridge Middle School   Regular School No Middle 06 08 2021   k_12_total 538 5 52   3 34     0   77                               538 5 52   3 34     0   77                        
656848 656848 OR     school 4101920 2243   Beaverton SD 48J 410192001234 1181 Five Oaks Middle School   Regular School No Middle 06 08 2021   k_12_total 367 47 406   5 70     8   76                               367 47 406   5 70     8   76                        
656878 656878 OR     school 4101920 2243   Beaverton SD 48J 410192001431 2782 Stoller Middle School   Regular School No Middle 06 08 2021   k_12_total 424 26 110   2 761     10   76                               424 26 110   2 761     10   76                        
657033 657033 OR     school 4103480 1901   Corvallis SD 509J 410348000048 41 Crescent Valley High School   Regular School No High 09 12 2021   k_12_total 602 8 76   3 61     3   76                               602 8 76   3 61     3   76                        
657259 657259 OR     school 4101120 2100   Greater Albany Public SD 8J 410112000736 650 South Albany High School   Regular School No High 09 12 2021   k_12_total 849 6 380   24 11     4   76                               849 6 380   24 11     4   76                        
657529 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                        
656839 656839 OR     school 4101920 2243   Beaverton SD 48J 410192001233 1180 Cedar Park Middle School   Regular School No Middle 06 08 2021   k_12_total 498 24 188   5 59     6   74                               498 24 188   5 59     6   74                        
657031 657031 OR     school 4103480 1901   Corvallis SD 509J 410348000047 40 Corvallis High School   Regular School No High 09 12 2021   k_12_total 660 9 254   13 46     3   74                               660 9 254   13 46     3   74                        
657797 657797 OR     school 4110040 2180   Portland SD 1J 411004001079 1363 da Vinci Middle School   Regular School No Middle 06 08 2021   k_12_total 287 31 41   1 8     1   74                               287 31 41   1 8     1   74                        
657812 657812 OR     school 4110040 2180   Portland SD 1J 411004000899 855 Hayhurst Elementary School   Regular School No Elementary KG 08 2021   k_12_total 466 20 48   1 15     0   74                               466 20 48   1 15     0   74                        
657322 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                        
657032 657032 OR     school 4103480 1901   Corvallis SD 509J   1901 Corvallis SD 509J             2021   k_12_total 589 6 95   9 62     6   72                               589 6 95   9 62     6   72                        
657599 657599 OR     school 4108820 1966   North Bend SD 13 410882000225 209 North Bend Senior High School   Regular School No High 09 12 2021   k_12_total 561 4 82   19 15     7   72                               561 4 82   19 15     7   72                        
657730 657730 OR     school 4109480 2181   Parkrose SD 3 410948000986 930 Parkrose Middle School   Regular School No Middle 06 08 2021   k_12_total 227 115 207   7 91     22   72                               227 115 207   7 91     22   72                        
658166 658166 OR     school 4112240 2242   Tigard-Tualatin SD 23J 411224000381 1300 Hazelbrook Middle School   Regular School No Middle 06 08 2021   k_12_total 476 10 318   5 21     23   72                               476 10 318   5 21     23   72                        
657538 657538 OR     school 4108280 2249   Mitchell SD 55 410828001869 5440 Cascade Virtual Academy   Regular School Yes Elementary KG 08 2021   k_12_total 424 25 131   6 9     7   71                               424 25 131   6 9     7   71                        
657776 657776 OR     school 4110040 2180   Portland SD 1J 411004000867 824 Alameda Elementary School   Regular School No Elementary KG 05 2021   k_12_total 499 5 40   0 9     0   71                               499 5 40   0 9     0   71                        
657864 657864 OR     school 4110040 2180   Portland SD 1J 411004000936 888 Sellwood Middle School   Regular School No Middle 06 08 2021   k_12_total 425 7 37   1 8     1   71                               425 7 37   1 8     1   71                        

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