Data source: Big Local News · About: Big Local

7,952 rows where state = "AK" and year = 2021 sorted by multiracial descending

View and edit SQL

year

  • 2021 · 7,952
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
1819151 AK     school 200610 36   North Slope Borough Schools 20061000285 360020 Fred Ipalook Elementary   Regular School No Elementary PK 5 2021   k_12_total 10.0 2.0 0.0 2.0   31.0     27.0   97.0                             478.0 10 2 0 2   31     27   97                       478
1813839 AK     school 200180 5   Anchorage Schools 20018000534 50870 Hanshew Middle School   Regular School No Middle 07 8 2021   k_12_total 219.0 30.0 80.0 2.0   85.0     41.0   96.0                             632.0 219 30 80 2   85     41   96                       632
1813841 AK     school 200180 5   Anchorage Schools 20018000534 50870 Hanshew Middle School   Regular School No Middle 07 8 2021   pk_12_total 219.0 30.0 80.0 2.0   85.0     41.0   96.0                             632.0 219 30 80 2   85     41   96                       632
1814271 AK     school 200180 5   Anchorage Schools 20018000530 59050 Frontier Charter School   Regular School Yes Other KG 12 2021   k_12_total 431.0 30.0 60.0 5.0   29.0     8.0   96.0                             705.0 431 30 60 5   29     8   96                       705
1814273 AK     school 200180 5   Anchorage Schools 20018000530 59050 Frontier Charter School   Regular School Yes Other KG 12 2021   pk_12_total 431.0 30.0 60.0 5.0   29.0     8.0   96.0                             705.0 431 30 60 5   29     8   96                       705
1813007 AK     school 200180 5   Anchorage Schools 20018000066 50120 Chinook Elementary   Regular School No Elementary PK 6 2021   k_12_total 85.0 12.0 58.0 2.0   45.0     42.0   95.0                             393.0 85 12 58 2   45     42   95                       393
1813009 AK     school 200180 5   Anchorage Schools 20018000066 50120 Chinook Elementary   Regular School No Elementary PK 6 2021   pk_12_total 86.0 12.0 58.0 2.0   45.0     42.0   95.0                             394.0 86 12 58 2   45     42   95                       394
1813407 AK     school 200180 5   Anchorage Schools 20018000094 50510 Northern Lights ABC K-8 School   Regular School No Elementary PK 8 2021   k_12_total 191.0 28.0 67.0 5.0   158.0     5.0   95.0                             566.0 191 28 67 5   158     5   95                       566
1813409 AK     school 200180 5   Anchorage Schools 20018000094 50510 Northern Lights ABC K-8 School   Regular School No Elementary PK 8 2021   pk_12_total 191.0 28.0 67.0 5.0   158.0     5.0   95.0                             566.0 191 28 67 5   158     5   95                       566
1814353 AK     school 200180 5   Anchorage Schools 20018000736 59100 Alaska Native Cultural Charter School   Regular School Yes Elementary PK 8 2021   pk_12_total 7.0 2.0 28.0 2.0   2.0     2.0   95.0                             303.0 7 2 28 2   2     2   95                       303
1815455 AK     school 200600 16   Fairbanks North Star Borough Schools 20060000045 160290 University Park Elementary   Regular School No Elementary PK 6 2021   k_12_total 149.0 11.0 30.0 2.0   5.0         95.0                             319.0 149 11 30 2   5         95                       319
1815457 AK     school 200600 16   Fairbanks North Star Borough Schools 20060000045 160290 University Park Elementary   Regular School No Elementary PK 6 2021   pk_12_total 158.0 11.0 31.0 3.0   6.0         95.0                             331.0 158 11 31 3   6         95                       331
1815760 AK     school 200130 17   Galena City Schools 20013000253 178010 Interior Distance Education of Alaska (IDEA)   Regular School No Other PK 12 2021   kindergarten 586.0 11.0 49.0 9.0   10.0     4.0   95.0                             829.0 586 11 49 9   10     4   95                       829
1813089 AK     school 200180 5   Anchorage Schools 20018000070 50170 College Gate Elementary   Regular School No Elementary PK 6 2021   pk_12_total 62.0 12.0 27.0 5.0   35.0     35.0   93.0                             362.0 62 12 27 5   35     35   93                       362
1813087 AK     school 200180 5   Anchorage Schools 20018000070 50170 College Gate Elementary   Regular School No Elementary PK 6 2021   k_12_total 59.0 12.0 25.0 5.0   30.0     33.0   91.0                             348.0 59 12 25 5   30     33   91                       348
1813599 AK     school 200180 5   Anchorage Schools 20018000112 50650 Scenic Park Elementary   Regular School No Elementary PK 6 2021   k_12_total 120.0 34.0 35.0 1.0   39.0     24.0   91.0                             371.0 120 34 35 1   39     24   91                       371
1813601 AK     school 200180 5   Anchorage Schools 20018000112 50650 Scenic Park Elementary   Regular School No Elementary PK 6 2021   pk_12_total 120.0 34.0 35.0 1.0   39.0     24.0   91.0                             371.0 120 34 35 1   39     24   91                       371
1813711 AK     school 200180 5   Anchorage Schools 20018000119 50720 Wendler Middle School   Regular School No Middle 07 8 2021   k_12_total 85.0 25.0 61.0 2.0   68.0     45.0   91.0                             435.0 85 25 61 2   68     45   91                       435
1813713 AK     school 200180 5   Anchorage Schools 20018000119 50720 Wendler Middle School   Regular School No Middle 07 8 2021   pk_12_total 85.0 25.0 61.0 2.0   68.0     45.0   91.0                             435.0 85 25 61 2   68     45   91                       435
1814351 AK     school 200180 5   Anchorage Schools 20018000736 59100 Alaska Native Cultural Charter School   Regular School Yes Elementary PK 8 2021   k_12_total 6.0 1.0 26.0 2.0   1.0     0.0   91.0                             286.0 6 1 26 2   1     0   91                       286
1818705 AK     school 200510 33   Mat-Su Borough Schools 20051000444 330440 Teeland Middle School   Regular School No Middle 06 8 2021   pk_12_total 490.0 7.0 46.0 5.0   12.0     3.0   91.0                             720.0 490 7 46 5   12     3   91                       720
1815391 AK     school 200600 16   Fairbanks North Star Borough Schools 20060000652 160250 North Pole Middle School   Regular School No Middle 06 8 2021   k_12_total 275.0 9.0 37.0 1.0   5.0     4.0   90.0                             453.0 275 9 37 1   5     4   90                       453
1815393 AK     school 200600 16   Fairbanks North Star Borough Schools 20060000652 160250 North Pole Middle School   Regular School No Middle 06 8 2021   pk_12_total 275.0 9.0 37.0 1.0   5.0     4.0   90.0                             453.0 275 9 37 1   5     4   90                       453
1812675 AK     school 200770 2   Denali Borough Schools 20077000447 28010 Denali PEAK   Regular School No Other PK 12 2021   grade_1 44.0 4.0 12.0 0.0   1.0     2.0   9.0                             77.0 44 4 12 0   1     2   9                       77
1812690 AK     school 200770 2   Denali Borough Schools 20077000447 28010 Denali PEAK   Regular School No Other PK 12 2021   pre_kindergarten 26.0 4.0 8.0 1.0   1.0     2.0   9.0                             53.0 26 4 8 1   1     2   9                       53
1812866 AK     school 200180 5   Anchorage Schools 20018000053 50010 Abbott Loop Elementary   Regular School No Elementary PK 6 2021   pre_kindergarten 6.0 1.0 6.0     1.0     0.0   9.0                             26.0 6 1 6     1     0   9                       26
1812875 AK     school 200180 5   Anchorage Schools 20018000054 50020 Airport Heights Elementary   Regular School No Elementary PK 6 2021   grade_6 3.0 0.0 9.0     10.0     4.0   9.0                             41.0 3 0 9     10     4   9                       41
1813016 AK     school 200180 5   Anchorage Schools 20018000067 50130 Chugach Optional Elementary   Regular School No Elementary PK 6 2021   grade_3 26.0 0.0 1.0 0.0   1.0         9.0                             38.0 26 0 1 0   1         9                       38
1813080 AK     school 200180 5   Anchorage Schools 20018000070 50170 College Gate Elementary   Regular School No Elementary PK 6 2021   grade_3 7.0 1.0 3.0 1.0   6.0     7.0   9.0                             41.0 7 1 3 1   6     7   9                       41
1813107 AK     school 200180 5   Anchorage Schools 20018000072 50190 Denali Montessori Elementary   Regular School No Elementary PK 6 2021   grade_1 26.0 2.0 4.0 0.0   3.0     4.0   9.0                             53.0 26 2 4 0   3     4   9                       53
1813161 AK     school 200180 5   Anchorage Schools 20018000056 50240 Aurora Elementary   Regular School No Elementary PK 6 2021   grade_4 17.0 3.0 4.0 0.0   0.0     0.0   9.0                             34.0 17 3 4 0   0     0   9                       34
1813163 AK     school 200180 5   Anchorage Schools 20018000056 50240 Aurora Elementary   Regular School No Elementary PK 6 2021   grade_6 15.0 7.0 3.0 0.0   1.0     1.0   9.0                             36.0 15 7 3 0   1     1   9                       36
1813257 AK     school 200180 5   Anchorage Schools 20018000078 50370 Gladys Wood Elementary   Regular School No Elementary PK 6 2021   grade_4 10.0 1.0 3.0 0.0   3.0     8.0   9.0                             41.0 10 1 3 0   3     8   9                       41
1813271 AK     school 200180 5   Anchorage Schools 20018000504 50380 Government Hill Elementary   Regular School No Elementary PK 6 2021   grade_2 14.0 1.0 42.0     3.0     1.0   9.0                             75.0 14 1 42     3     1   9                       75
1813336 AK     school 200180 5   Anchorage Schools 20018000086 50450 Lake Otis Elementary   Regular School No Elementary PK 6 2021   grade_3 10.0 0.0 10.0 0.0   10.0     5.0   9.0                             47.0 10 0 10 0   10     5   9                       47
1813403 AK     school 200180 5   Anchorage Schools 20018000094 50510 Northern Lights ABC K-8 School   Regular School No Elementary PK 8 2021   grade_6 30.0 2.0 7.0 1.0   20.0     0.0   9.0                             72.0 30 2 7 1   20     0   9                       72
1813416 AK     school 200180 5   Anchorage Schools 20018000095 50520 Northwood ABC   Regular School No Elementary PK 6 2021   grade_3 4.0 1.0 4.0     2.0     6.0   9.0                             35.0 4 1 4     2     6   9                       35
1813456 AK     school 200180 5   Anchorage Schools 20018000097 50540 O'Malley Elementary   Regular School No Elementary PK 6 2021   kindergarten 35.0 4.0 3.0     1.0         9.0                             54.0 35 4 3     1         9                       54
1813491 AK     school 200180 5   Anchorage Schools 20018000102 50580 Ptarmigan Elementary   Regular School No Elementary PK 6 2021   grade_1 6.0 7.0 6.0 0.0   13.0     9.0   9.0                             56.0 6 7 6 0   13     9   9                       56
1813536 AK     school 200180 5   Anchorage Schools 20018000105 50600 Rogers Park Elementary   Regular School No Elementary PK 6 2021   kindergarten 11.0 1.0 4.0 1.0   4.0     3.0   9.0                             35.0 11 1 4 1   4     3   9                       35
1813560 AK     school 200180 5   Anchorage Schools 20018000107 50620 Russian Jack Elementary   Regular School No Elementary PK 6 2021   grade_3 4.0 1.0 9.0 1.0   8.0     6.0   9.0                             43.0 4 1 9 1   8     6   9                       43
1813561 AK     school 200180 5   Anchorage Schools 20018000107 50620 Russian Jack Elementary   Regular School No Elementary PK 6 2021   grade_4 1.0 4.0 9.0 0.0   13.0     6.0   9.0                             47.0 1 4 9 0   13     6   9                       47
1813568 AK     school 200180 5   Anchorage Schools 20018000107 50620 Russian Jack Elementary   Regular School No Elementary PK 6 2021   kindergarten 3.0 2.0 9.0 0.0   13.0     1.0   9.0                             40.0 3 2 9 0   13     1   9                       40
1813629 AK     school 200180 5   Anchorage Schools 20018000115 50670 Steller Secondary School   Regular School No High 07 12 2021   grade_8 38.0 0.0 5.0 0.0   2.0     0.0   9.0                             54.0 38 0 5 0   2     0   9                       54
1813630 AK     school 200180 5   Anchorage Schools 20018000115 50670 Steller Secondary School   Regular School No High 07 12 2021   grade_9 29.0 1.0 7.0 0.0   0.0     0.0   9.0                             48.0 29 1 7 0   0     0   9                       48
1813640 AK     school 200180 5   Anchorage Schools 20018000116 50680 Susitna Elementary   Regular School No Elementary PK 6 2021   grade_3 26.0 3.0 3.0 1.0   10.0     2.0   9.0                             61.0 26 3 3 1   10     2   9                       61
1813657 AK     school 200180 5   Anchorage Schools 20018000117 50690 Taku Elementary   Regular School No Elementary PK 6 2021   grade_4 2.0 1.0 6.0 0.0   5.0     11.0   9.0                             41.0 2 1 6 0   5     11   9                       41
1813659 AK     school 200180 5   Anchorage Schools 20018000117 50690 Taku Elementary   Regular School No Elementary PK 6 2021   grade_6 9.0 4.0 12.0 0.0   7.0     4.0   9.0                             49.0 9 4 12 0   7     4   9                       49
1813672 AK     school 200180 5   Anchorage Schools 20018000087 50700 Tudor Elementary   Regular School No Elementary PK 6 2021   grade_3 16.0 1.0 4.0     4.0     4.0   9.0                             47.0 16 1 4     4     4   9                       47
1813690 AK     school 200180 5   Anchorage Schools 20018000088 50710 Turnagain Elementary   Regular School No Elementary PK 6 2021   grade_5 16.0 1.0 2.0 0.0   3.0     6.0   9.0                             42.0 16 1 2 0   3     6   9                       42
1813786 AK     school 200180 5   Anchorage Schools 20018000059 50800 Bayshore Elementary   Regular School No Elementary PK 6 2021   grade_5 29.0 1.0 9.0     7.0     1.0   9.0                             60.0 29 1 9     7     1   9                       60
1813850 AK     school 200180 5   Anchorage Schools 20018000598 50880 Fire Lake Elementary   Regular School No Elementary PK 6 2021   grade_5 33.0 1.0 2.0 0.0   5.0     1.0   9.0                             54.0 33 1 2 0   5     1   9                       54
1813939 AK     school 200180 5   Anchorage Schools 20018000147 51010 Kasuun Elementary   Regular School No Elementary PK 6 2021   grade_1 9.0 1.0 2.0 0.0   3.0     1.0   9.0                             35.0 9 1 2 0   3     1   9                       35
1813961 AK     school 200180 5   Anchorage Schools 20018000149 51020 Kincaid Elementary   Regular School No Elementary PK 6 2021   grade_4 43.0 1.0 10.0 1.0   3.0     4.0   9.0                             78.0 43 1 10 1   3     4   9                       78
1813977 AK     school 200180 5   Anchorage Schools 20018000151 51030 Lake Hood Elementary   Regular School No Elementary PK 6 2021   grade_4 9.0 2.0 4.0 0.0   11.0     2.0   9.0                             43.0 9 2 4 0   11     2   9                       43
1813979 AK     school 200180 5   Anchorage Schools 20018000151 51030 Lake Hood Elementary   Regular School No Elementary PK 6 2021   grade_6 10.0 1.0 4.0 0.0   8.0     9.0   9.0                             45.0 10 1 4 0   8     9   9                       45
1813991 AK     school 200180 5   Anchorage Schools 20018000154 51040 William Tyson Elementary   Regular School No Elementary PK 6 2021   grade_2 4.0 2.0 8.0 0.0   8.0     7.0   9.0                             44.0 4 2 8 0   8     7   9                       44
1814000 AK     school 200180 5   Anchorage Schools 20018000154 51040 William Tyson Elementary   Regular School No Elementary PK 6 2021   kindergarten 2.0 3.0 5.0 0.0   11.0     9.0   9.0                             42.0 2 3 5 0   11     9   9                       42
1814043 AK     school 200180 5   Anchorage Schools 20018000390 51110 Trailside Elementary   Regular School No Elementary PK 6 2021   grade_6 22.0 0.0 4.0     5.0     1.0   9.0                             47.0 22 0 4     5     1   9                       47
1814070 AK     school 200180 5   Anchorage Schools 20018000458 51130 Eagle River High School   Regular School No High 09 12 2021   grade_12 127.0 12.0 18.0 3.0   7.0     1.0   9.0                             179.0 127 12 18 3   7     1   9                       179
1814109 AK     school 200180 5   Anchorage Schools 20018000178 56010 Family Partnership Charter School   Regular School Yes Other KG 12 2021   grade_8 106.0 4.0 11.0 0.0   1.0     5.0   9.0                             139.0 106 4 11 0   1     5   9                       139
1814112 AK     school 200180 5   Anchorage Schools 20018000178 56010 Family Partnership Charter School   Regular School Yes Other KG 12 2021   kindergarten 104.0 4.0 10.0 0.0   6.0     0.0   9.0                             135.0 104 4 10 0   6     0   9                       135
1814250 AK     school 200180 5   Anchorage Schools 20018000172 59010 Aquarian Charter School   Regular School Yes Elementary KG 6 2021   grade_5 32.0 0.0 2.0     3.0     1.0   9.0                             49.0 32 0 2     3     1   9                       49
1814251 AK     school 200180 5   Anchorage Schools 20018000172 59010 Aquarian Charter School   Regular School Yes Elementary KG 6 2021   grade_6 31.0 0.0 6.0     0.0     0.0   9.0                             46.0 31 0 6     0     0   9                       46
1814263 AK     school 200180 5   Anchorage Schools 20018000530 59050 Frontier Charter School   Regular School Yes Other KG 12 2021   grade_2 26.0 2.0 7.0 0.0   3.0     1.0   9.0                             52.0 26 2 7 0   3     1   9                       52
1814345 AK     school 200180 5   Anchorage Schools 20018000736 59100 Alaska Native Cultural Charter School   Regular School Yes Elementary PK 8 2021   grade_4 0.0 0.0 3.0 0.0   0.0     0.0   9.0                             37.0 0 0 3 0   0     0   9                       37
1814380 AK     school 200180 5   Anchorage Schools 20018000760 59120 Anchorage STrEaM Academy   Regular School Yes Middle 06 8 2021   grade_7 34.0 1.0 4.0 1.0   1.0     0.0   9.0                             57.0 34 1 4 1   1     0   9                       57
1814381 AK     school 200180 5   Anchorage Schools 20018000760 59120 Anchorage STrEaM Academy   Regular School Yes Middle 06 8 2021   grade_8 19.0 2.0 3.0 0.0   1.0     2.0   9.0                             39.0 19 2 3 0   1     2   9                       39
1814879 AK     school 200070 11   Copper River Schools 20007000036 110100 Kenny Lake School   Regular School No Other PK 12 2021   k_12_total 26.0 1.0                 9.0                             51.0 26 1                 9                       51
1814881 AK     school 200070 11   Copper River Schools 20007000036 110100 Kenny Lake School   Regular School No Other PK 12 2021   pk_12_total 26.0 1.0                 9.0                             51.0 26 1                 9                       51
1815125 AK     school 200120 15   Dillingham City Schools 20012000634 150020 Dillingham Middle/High School   Regular School No High 06 12 2021   grade_11 7.0   1.0               9.0                             26.0 7   1               9                       26
1815131 AK     school 200120 15   Dillingham City Schools 20012000634 150020 Dillingham Middle/High School   Regular School No High 06 12 2021   grade_6 7.0   1.0               9.0                             37.0 7   1               9                       37
1815155 AK     school 200600 16   Fairbanks North Star Borough Schools 20060000259 160020 Barnette Magnet School   Regular School No Elementary PK 8 2021   grade_1 21.0 0.0 5.0 0.0   1.0     0.0   9.0                             39.0 21 0 5 0   1     0   9                       39
1815159 AK     school 200600 16   Fairbanks North Star Borough Schools 20060000259 160020 Barnette Magnet School   Regular School No Elementary PK 8 2021   grade_2 22.0 1.0 3.0 0.0   2.0     0.0   9.0                             39.0 22 1 3 0   2     0   9                       39
1815171 AK     school 200600 16   Fairbanks North Star Borough Schools 20060000262 160050 Denali Elementary   Regular School No Elementary PK 6 2021   grade_1 8.0 0.0 4.0     1.0     1.0   9.0                             30.0 8 0 4     1     1   9                       30
1815175 AK     school 200600 16   Fairbanks North Star Borough Schools 20060000262 160050 Denali Elementary   Regular School No Elementary PK 6 2021   grade_2 11.0 5.0 6.0     1.0     0.0   9.0                             36.0 11 5 6     1     0   9                       36
1815177 AK     school 200600 16   Fairbanks North Star Borough Schools 20060000262 160050 Denali Elementary   Regular School No Elementary PK 6 2021   grade_4 13.0 2.0 8.0     2.0     0.0   9.0                             37.0 13 2 8     2     0   9                       37
1815203 AK     school 200600 16   Fairbanks North Star Borough Schools 20060000519 160070 Weller Elementary   Regular School No Elementary PK 6 2021   grade_1 30.0 1.0 5.0 1.0   0.0         9.0                             49.0 30 1 5 1   0         9                       49
1815273 AK     school 200600 16   Fairbanks North Star Borough Schools 20060000258 160170 Midnight Sun Elementary School   Regular School No Elementary PK 5 2021   grade_4 33.0 0.0 4.0 1.0   0.0         9.0                             47.0 33 0 4 1   0         9                       47
1815296 AK     school 200600 16   Fairbanks North Star Borough Schools 20060000267 160180 Hunter Elementary   Regular School No Elementary PK 6 2021   kindergarten 7.0 3.0 2.0 0.0   3.0     2.0   9.0                             35.0 7 3 2 0   3     2   9                       35
1815299 AK     school 200600 16   Fairbanks North Star Borough Schools 20060000269 160200 Joy Elementary   Regular School No Elementary PK 8 2021   grade_1 12.0 4.0 4.0 0.0   0.0     1.0   9.0                             34.0 12 4 4 0   0     1   9                       34
1815447 AK     school 200600 16   Fairbanks North Star Borough Schools 20060000045 160290 University Park Elementary   Regular School No Elementary PK 6 2021   grade_2 21.0 5.0 3.0 0.0   1.0         9.0                             42.0 21 5 3 0   1         9                       42
1815466 AK     school 200600 16   Fairbanks North Star Borough Schools 20060000280 160300 Woodriver Elementary   Regular School No Elementary PK 6 2021   grade_5 23.0 1.0 8.0 0.0   2.0     0.0   9.0                             48.0 23 1 8 0   2     0   9                       48
1815480 AK     school 200600 16   Fairbanks North Star Borough Schools 20060000600 160340 Ticasuk Brown Elementary   Regular School No Elementary PK 5 2021   grade_3 24.0 0.0 6.0 0.0   1.0     0.0   9.0                             41.0 24 0 6 0   1     0   9                       41
1815488 AK     school 200600 16   Fairbanks North Star Borough Schools 20060000600 160340 Ticasuk Brown Elementary   Regular School No Elementary PK 5 2021   kindergarten 18.0 1.0 3.0 0.0   0.0     0.0   9.0                             34.0 18 1 3 0   0     0   9                       34
1815611 AK     school 200600 16   Fairbanks North Star Borough Schools 20060000587 168010 Fairbanks B.E.S.T.   Regular School No Other PK 12 2021   grade_6 59.0 1.0 1.0 0.0   0.0         9.0                             71.0 59 1 1 0   0         9                       71
1816122 AK     school 200210 22   Juneau Borough Schools 20021000265 220100 Riverbend Elementary   Regular School No Elementary PK 5 2021   grade_5 8.0 0.0 4.0 0.0   4.0     1.0   9.0                             35.0 8 0 4 0   4     1   9                       35
1816217 AK     school 200210 22   Juneau Borough Schools 20021000125 228010 HomeBRIDGE   Regular School No Other PK 12 2021   grade_4 18.0 0.0 0.0 0.0   0.0     0.0   9.0                             27.0 18 0 0 0   0     0   9                       27
1816221 AK     school 200210 22   Juneau Borough Schools 20021000125 228010 HomeBRIDGE   Regular School No Other PK 12 2021   grade_8 24.0 1.0 1.0 0.0   1.0     0.0   9.0                             38.0 24 1 1 0   1     0   9                       38
1816224 AK     school 200210 22   Juneau Borough Schools 20021000125 228010 HomeBRIDGE   Regular School No Other PK 12 2021   kindergarten 23.0 0.0 2.0 0.0   0.0     0.0   9.0                             37.0 23 0 2 0   0     0   9                       37
1816495 AK     school 200390 24   Kenai Peninsula Borough Schools 20039000168 240180 Port Graham School   Regular School No Other PK 12 2021   k_12_total     1.0               9.0                             31.0     1               9                       31
1816497 AK     school 200390 24   Kenai Peninsula Borough Schools 20039000168 240180 Port Graham School   Regular School No Other PK 12 2021   pk_12_total     1.0               9.0                             31.0     1               9                       31
1816506 AK     school 200390 24   Kenai Peninsula Borough Schools 20039000169 240190 William H. Seward Elementary School   Regular School No Elementary PK 5 2021   grade_5 23.0 0.0 4.0 1.0   1.0     0.0   9.0                             40.0 23 0 4 1   1     0   9                       40
1816780 AK     school 200390 24   Kenai Peninsula Borough Schools 20039000437 240500 Seward Middle School   Regular School No Middle 06 8 2021   grade_7 22.0   3.0 0.0   0.0     0.0   9.0                             36.0 22   3 0   0     0   9                       36
1816833 AK     school 200390 24   Kenai Peninsula Borough Schools 20039000079 247030 Kenai Alternative High School   Alternative School No High 09 12 2021   pk_12_total 22.0   3.0               9.0                             39.0 22   3               9                       39
1816895 AK     school 200390 24   Kenai Peninsula Borough Schools 20039000296 249030 Fireweed Academy   Regular School Yes Elementary KG 6 2021   k_12_total 68.0   2.0 2.0             9.0                             85.0 68   2 2             9                       85
1816897 AK     school 200390 24   Kenai Peninsula Borough Schools 20039000296 249030 Fireweed Academy   Regular School Yes Elementary KG 6 2021   pk_12_total 68.0   2.0 2.0             9.0                             85.0 68   2 2             9                       85
1816928 AK     school 200390 24   Kenai Peninsula Borough Schools 20039000463 249050 Kaleidoscope School of Arts & Science   Regular School Yes Elementary KG 5 2021   kindergarten 27.0 0.0 4.0 0.0   0.0     0.0   9.0                             43.0 27 0 4 0   0     0   9                       43
1816972 AK     school 200150 25   Ketchikan Gateway Borough Schools 20015000050 250040 Schoenbar Middle School   Regular School No Middle 07 8 2021   grade_7 56.0 0.0 2.0 4.0   14.0     2.0   9.0                             123.0 56 0 2 4   14     2   9                       123
1817007 AK     school 200150 25   Ketchikan Gateway Borough Schools 20015000584 250100 Point Higgins School   Regular School No Elementary PK 6 2021   k_12_total 151.0   1.0 1.0   11.0     1.0   9.0                             213.0 151   1 1   11     1   9                       213

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