Data source: Big Local News · About: Big Local

497 rows where grade = "k_12_total", state = "AK" and year = 2021 sorted by school

View and edit SQL

year

  • 2021 · 497

grade

  • k_12_total · 497
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
1817279 AK     school 200480 28   Kodiak Island Borough Schools 20048000435 288010 AKTEACH   Regular School No Other KG 12 2021   k_12_total 177.0   10.0     4.0         9.0                             230.0 177   10     4         9                       230
1812863 AK     school 200180 5   Anchorage Schools 20018000053 50010 Abbott Loop Elementary   Regular School No Elementary PK 6 2021   k_12_total 35.0 13.0 14.0     53.0     32.0   48.0                             222.0 35 13 14     53     32   48                       222
1818959 AK     school 200510 33   Mat-Su Borough Schools 20051000311 339010 Academy Charter School   Regular School Yes Elementary KG 8 2021   k_12_total 195.0   16.0     5.0     1.0   31.0                             253.0 195   16     5     1   31                       253
1812847 AK     school 200010 4   Aleutian Region Schools 20001000080 40080 Adak School   Regular School No Other KG 12 2021   k_12_total 1.0   5.0     1.0     4.0                                 15.0 1   5     1     4                           15
1812879 AK     school 200180 5   Anchorage Schools 20018000054 50020 Airport Heights Elementary   Regular School No Elementary PK 6 2021   k_12_total 22.0 6.0 41.0     64.0     31.0   48.0                             242.0 22 6 41     64     31   48                       242
1817103 AK     school 200480 28   Kodiak Island Borough Schools 20048000180 280010 Akhiok School   Regular School No Other KG 12 2021   k_12_total   1.0                 1.0                             11.0   1                 1                       11
1820479 AK     school 200004 54   Yupiit Schools 20000400769 548010 Akiachak School   Regular School No High 07 12 2021   k_12_total                     2.0                             214.0                     2                       214
1820447 AK     school 200004 54   Yupiit Schools 20000400624 540030 Akiak School   Regular School No Other KG 12 2021   k_12_total 4.0                                                 148.0 4                                           148
1817983 AK     school 200001 31   Lower Kuskokwim Schools 20000100619 310240 Akiuk Memorial School   Regular School No Other PK 12 2021   k_12_total                                                   94.0                                             94
1817775 AK     school 200001 31   Lower Kuskokwim Schools 20000100391 310110 Akula Elitnaurvik School   Regular School No Other PK 12 2021   k_12_total 5.0                                                 104.0 5                                           104
1820543 AK     school 200007 56   Aleutians East Borough Schools 20000700004 560030 Akutan School   Regular School No Other PK 12 2021   k_12_total 1.0                   3.0                             17.0 1                   3                       17
1819263 AK     school 200610 36   North Slope Borough Schools 20061000291 360100 Alak School   Regular School No Other PK 12 2021   k_12_total   1.0                 4.0                             158.0   1                 4                       158
1818111 AK     school 200003 32   Lower Yukon Schools 20000300216 320010 Alakanuk School   Regular School No Other PK 12 2021   k_12_total 2.0                   2.0                             231.0 2                   2                       231
1815103 AK     school 200100 14   Delta/Greely Schools 20010000599 148010 Alaska Homeschool   Regular School No Other PK 12 2021   k_12_total 204.0 2.0 17.0 1.0             14.0                             242.0 204 2 17 1             14                       242
1814239 AK     school 200180 5   Anchorage Schools 20018000763 57230 Alaska Middle College School   Regular School No High 11 12 2021   k_12_total 178.0 13.0 26.0 1.0   24.0     5.0   33.0                             293.0 178 13 26 1   24     5   33                       293
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
1812815 AK     school 200050 3   Alaska Gateway Schools 20005000023 38010 Alaska REACH Academy   Regular School No Other PK 12 2021   k_12_total 51.0   1.0     5.0         2.0                             65.0 51   1     5         2                       65
1814127 AK     school 200180 5   Anchorage Schools 20018000341 57010 Alaska State School for Deaf and Hard of Hearing   Special Education School No Other PK 12 2021   k_12_total 9.0 3.0 3.0     1.0         2.0                             22.0 9 3 3     1         2                       22
1819855 AK     school 200710 45   Southwest Region Schools 20071000330 450020 Aleknagik School   Regular School No Other PK 12 2021   k_12_total 1.0                   6.0                             28.0 1                   6                       28
1820271 AK     school 200862 52   Yukon-Koyukuk Schools 20086200377 520010 Allakaket School   Regular School No Other PK 12 2021   k_12_total           1.0                                       19.0           1                                 19
1813935 AK     school 200180 5   Anchorage Schools 20018000104 51000 Alpenglow Elementary   Regular School No Elementary PK 6 2021   k_12_total 191.0 10.0 39.0 6.0   4.0         38.0                             297.0 191 10 39 6   4         38                       297
1815567 AK     school 200600 16   Fairbanks North Star Borough Schools 20060000325 167010 Alternative Learning Systems   Alternative School No Other PK 12 2021   k_12_total 109.0 10.0 17.0 3.0   1.0     1.0   35.0                             229.0 109 10 17 3   1     1   35                       229
1819327 AK     school 200625 37   Northwest Arctic Borough Schools 20062500292 370010 Ambler School   Regular School No Other PK 12 2021   k_12_total                     2.0                             67.0                     2                       67
1818895 AK     school 200510 33   Mat-Su Borough Schools 20051000452 337050 American Charter Academy   Regular School Yes Other KG 12 2021   k_12_total 140.0 2.0 9.0 1.0   1.0     2.0   13.0                             172.0 140 2 9 1   1     2   13                       172
1814383 AK     school 200180 5   Anchorage Schools 20018000760 59120 Anchorage STrEaM Academy   Regular School Yes Middle 06 8 2021   k_12_total 87.0 5.0 12.0 1.0   4.0     3.0   29.0                             155.0 87 5 12 1   4     3   29                       155
1815231 AK     school 200600 16   Fairbanks North Star Borough Schools 20060000256 160080 Anderson Elementary   Regular School No Elementary PK 2 2021   k_12_total 142.0 12.0 27.0 1.0   3.0     1.0   19.0                             205.0 142 12 27 1   3     1   19                       205
1812639 AK     school 200770 2   Denali Borough Schools 20077000354 20010 Anderson School   Regular School No Other PK 12 2021   k_12_total 22.0   1.0 2.0   1.0         1.0                             27.0 22   1 2   1         1                       27
1820367 AK     school 200862 52   Yukon-Koyukuk Schools 20086200385 520090 Andrew K. Demoski School   Regular School No Other PK 12 2021   k_12_total           1.0                                       42.0           1                                 42
1814735 AK     school 200730 9   Chatham Schools 20073000342 90010 Angoon School   Regular School No Other PK 12 2021   k_12_total 1.0                   3.0                             67.0 1                   3                       67
1817311 AK     school 200760 29   Kuspuk Schools 20076000663 290011 Aniak Jr/Sr High School   Regular School No High 06 12 2021   k_12_total 5.0                                                 61.0 5                                           61
1814463 AK     school 200020 7   Bering Strait Schools 20002000421 70040 Aniguiin School   Regular School No Other PK 12 2021   k_12_total 2.0 2.0                                               115.0 2 2                                         115
1817935 AK     school 200001 31   Lower Kuskokwim Schools 20000100214 310210 Anna Tobeluk Memorial School   Regular School No Other PK 12 2021   k_12_total                                                   191.0                                             191
1815535 AK     school 200600 16   Fairbanks North Star Borough Schools 20060000114 160380 Anne Wien Elementary   Regular School No Elementary PK 6 2021   k_12_total 78.0 16.0 30.0     5.0         75.0                             261.0 78 16 30     5         75                       261
1814527 AK     school 200020 7   Bering Strait Schools 20002000467 70080 Anthony A. Andrews School   Regular School No Other PK 12 2021   k_12_total 2.0 2.0 1.0                                             143.0 2 2 1                                       143
1819119 AK     school 200570 35   Nome Public Schools 20057000323 359010 Anvil City Science Academy   Regular School Yes Middle 05 8 2021   k_12_total 6.0                   22.0                             58.0 6                   22                       58
1819455 AK     school 200625 37   Northwest Arctic Borough Schools 20062500302 370100 Aqqaluk High/Noorvik Elementary   Regular School No Other PK 12 2021   k_12_total 1.0 1.0   3.0             10.0                             195.0 1 1   3             10                       195
1814255 AK     school 200180 5   Anchorage Schools 20018000172 59010 Aquarian Charter School   Regular School Yes Elementary KG 6 2021   k_12_total 274.0 2.0 33.0     12.0     1.0   54.0                             384.0 274 2 33     12     1   54                       384
1815519 AK     school 200600 16   Fairbanks North Star Borough Schools 20060000055 160360 Arctic Light Elementary   Regular School No Elementary PK 8 2021   k_12_total 156.0 43.0 90.0 3.0   5.0     21.0   32.0                             356.0 156 43 90 3   5     21   32                       356
1820175 AK     school 200775 51   Yukon Flats Schools 20077500358 510010 Arctic Village School   Regular School No Other PK 12 2021   k_12_total                                                   36.0                                             36
1817967 AK     school 200001 31   Lower Kuskokwim Schools 20000100215 310230 Arviq School   Regular School No Other KG 12 2021   k_12_total                                                   11.0                                             11
1816015 AK     school 200210 22   Juneau Borough Schools 20021000127 220010 Auke Bay Elementary   Regular School No Elementary PK 5 2021   k_12_total 128.0 1.0 18.0 4.0   5.0     1.0   52.0                             220.0 128 1 18 4   5     1   52                       220
1817295 AK     school 200760 29   Kuspuk Schools 20076000346 290010 Auntie Mary Nicoli Elementary   Regular School No Elementary PK 5 2021   k_12_total 3.0         1.0                                       52.0 3         1                                 52
1816879 AK     school 200390 24   Kenai Peninsula Borough Schools 20039000274 249010 Aurora Borealis Charter School   Regular School Yes Elementary KG 8 2021   k_12_total 138.0   2.0 4.0   5.0         20.0                             174.0 138   2 4   5         20                       174
1813167 AK     school 200180 5   Anchorage Schools 20018000056 50240 Aurora Elementary   Regular School No Elementary PK 6 2021   k_12_total 135.0 32.0 33.0 1.0   6.0     3.0   38.0                             252.0 135 32 33 1   6     3   38                       252
1817807 AK     school 200001 31   Lower Kuskokwim Schools 20000100211 310130 Ayagina'ar Elitnaurvik   Regular School No Other PK 12 2021   k_12_total                                                   156.0                                             156
1818095 AK     school 200001 31   Lower Kuskokwim Schools 20000100329 319010 Ayaprun Elitnaurvik   Regular School Yes Elementary PK 6 2021   k_12_total 6.0                                                 157.0 6                                           157
1817903 AK     school 200001 31   Lower Kuskokwim Schools 20000100440 310190 Ayaprun School   Regular School No Other PK 12 2021   k_12_total                                                   73.0                                             73
1819631 AK     school 200240 42   Sitka Borough Schools 20024000135 420010 Baranof Elementary   Regular School No Elementary PK 1 2021   k_12_total 70.0   9.0 1.0   7.0     1.0   18.0                             127.0 70   9 1   7     1   18                       127
1815167 AK     school 200600 16   Fairbanks North Star Borough Schools 20060000259 160020 Barnette Magnet School   Regular School No Elementary PK 8 2021   k_12_total 219.0 9.0 34.0 1.0   8.0     1.0   68.0                             349.0 219 9 34 1   8     1   68                       349
1819167 AK     school 200610 36   North Slope Borough Schools 20061000286 360030 Barrow High School   Regular School No High 09 12 2021   k_12_total 6.0 4.0   3.0   48.0     18.0   33.0                             287.0 6 4   3   48     18   33                       287
1819759 AK     school 200700 44   Southeast Island Schools 20070000319 440090 Barry Craig Stewart Kasaan School   Regular School No Other PK 12 2021   k_12_total 12.0                   2.0                             17.0 12                   2                       17
1812911 AK     school 200180 5   Anchorage Schools 20018000057 50050 Bartlett High School   Regular School No High 09 12 2021   k_12_total 248.0 118.0 173.0 9.0   243.0     179.0   215.0                             1334.0 248 118 173 9   243     179   215                       1334
1812927 AK     school 200180 5   Anchorage Schools 20018000058 50060 Baxter Elementary   Regular School No Elementary PK 6 2021   k_12_total 47.0 18.0 35.0     21.0     15.0   49.0                             207.0 47 18 35     21     15   49                       207
1813791 AK     school 200180 5   Anchorage Schools 20018000059 50800 Bayshore Elementary   Regular School No Elementary PK 6 2021   k_12_total 148.0 9.0 37.0     50.0     13.0   74.0                             358.0 148 9 37     50     13   74                       358
1813823 AK     school 200180 5   Anchorage Schools 20018000533 50820 Bear Valley Elementary   Regular School No Elementary PK 6 2021   k_12_total 197.0   13.0 1.0   13.0     2.0   33.0                             263.0 197   13 1   13     2   33                       263
1815247 AK     school 200600 16   Fairbanks North Star Borough Schools 20060000260 160090 Ben Eielson Jr/Sr High School   Regular School No High 07 12 2021   k_12_total 196.0 16.0 44.0 2.0   5.0     3.0   34.0                             303.0 196 16 44 2   5     3   34                       303
1814159 AK     school 200180 5   Anchorage Schools 20018000110 57100 Benson Secondary/S.E.A.R.C.H.   Alternative School No High 07 12 2021   k_12_total 55.0 17.0 25.0     12.0     37.0   56.0                             269.0 55 17 25     12     37   56                       269
1818623 AK     school 200510 33   Mat-Su Borough Schools 20051000726 330370 Beryozova School   Regular School No Other KG 12 2021   k_12_total 9.0     6.0                                           16.0 9     6                                     16
1817711 AK     school 200001 31   Lower Kuskokwim Schools 20000100208 310070 Bethel Regional High School   Regular School No High 07 12 2021   k_12_total 43.0 4.0 5.0 5.0   8.0         2.0                             490.0 43 4 5 5   8         2                       490
1818079 AK     school 200001 31   Lower Kuskokwim Schools 20000100620 317020 Bethel Youth Facility   Alternative School No High 05 12 2021   k_12_total       1.0                                           11.0       1                                     11
1818639 AK     school 200510 33   Mat-Su Borough Schools 20051000727 330380 Big Lake Elementary   Regular School No Elementary PK 5 2021   k_12_total 180.0 1.0 11.0 2.0   3.0     9.0   42.0                             288.0 180 1 11 2   3     9   42                       288
1819023 AK     school 200510 33   Mat-Su Borough Schools 20051000744 339050 Birchtree Charter School   Regular School Yes Elementary KG 8 2021   k_12_total 254.0 1.0 15.0 2.0   2.0         51.0                             352.0 254 1 15 2   2         51                       352
1812943 AK     school 200180 5   Anchorage Schools 20018000060 50070 Birchwood ABC Elementary   Regular School No Elementary PK 6 2021   k_12_total 146.0 3.0 26.0 3.0   6.0     3.0   32.0                             241.0 146 3 26 3   6     3   32                       241
1815887 AK     school 200520 21   Iditarod Area Schools 20052000240 210010 Blackwell School   Regular School No Other PK 12 2021   k_12_total       1.0                                           20.0       1                                     20
1819647 AK     school 200240 42   Sitka Borough Schools 20024000136 420020 Blatchley Middle School   Regular School No Middle 06 8 2021   k_12_total 142.0 5.0 8.0 3.0   21.0     3.0   17.0                             282.0 142 5 8 3   21     3   17                       282
1815695 AK     school 200600 16   Fairbanks North Star Borough Schools 20060000761 169060 Boreal Sun Charter School   Special Education School Yes Elementary KG 8 2021   k_12_total 143.0   16.0     3.0         23.0                             191.0 143   16     3         23                       191
1813903 AK     school 200180 5   Anchorage Schools 20018000713 50970 Bowman Elementary   Regular School No Elementary PK 6 2021   k_12_total 222.0 19.0 59.0 4.0   40.0     15.0   75.0                             467.0 222 19 59 4   40     15   75                       467
1814447 AK     school 200020 7   Bering Strait Schools 20002000423 70010 Brevig Mission School   Regular School No Other PK 12 2021   k_12_total 0.0                                                 141.0 0                                           141
1814719 AK     school 200030 8   Bristol Bay Borough Schools 20003000751 88010 Bristol Bay Correspondence   Regular School No Other KG 12 2021   k_12_total 6.0                                                 18.0 6                                           18
1814687 AK     school 200030 8   Bristol Bay Borough Schools 20003000020 80010 Bristol Bay Middle/High School   Regular School No High 07 12 2021   k_12_total 11.0         1.0     1.0   2.0                             45.0 11         1     1   2                       45
1819343 AK     school 200625 37   Northwest Arctic Borough Schools 20062500293 370020 Buckland School   Regular School No Other PK 12 2021   k_12_total                                                   171.0                                             171
1818847 AK     school 200510 33   Mat-Su Borough Schools 20051000720 337010 Burchell High School   Alternative School No High 09 12 2021   k_12_total 125.0 3.0 11.0 2.0         2.0   33.0                             197.0 125 3 11 2         2   33                       197
1818591 AK     school 200510 33   Mat-Su Borough Schools 20051000724 330350 Butte Elementary   Regular School No Elementary PK 5 2021   k_12_total 166.0   14.0 3.0   1.0         26.0                             224.0 166   14 3   1         26                       224
1812959 AK     school 200180 5   Anchorage Schools 20018000062 50080 Campbell STEM Elementary   Regular School No Elementary PK 6 2021   k_12_total 87.0 8.0 63.0 2.0   47.0     36.0   74.0                             354.0 87 8 63 2   47     36   74                       354
1812655 AK     school 200770 2   Denali Borough Schools 20077000356 20030 Cantwell School   Regular School No Other PK 12 2021   k_12_total 4.0                   3.0                             11.0 4                   3                       11
1812975 AK     school 200180 5   Anchorage Schools 20018000063 50100 Central Middle School of Science   Regular School No Middle 07 8 2021   k_12_total 88.0 37.0 52.0 6.0   40.0     39.0   51.0                             357.0 88 37 52 6   40     39   51                       357
1816287 AK     school 200390 24   Kenai Peninsula Borough Schools 20039000152 240020 Chapman School   Regular School No Elementary PK 8 2021   k_12_total 89.0   2.0 1.0   2.0         19.0                             120.0 89   2 1   2         19                       120
1817727 AK     school 200001 31   Lower Kuskokwim Schools 20000100209 310080 Chaputnguak School   Regular School No Other PK 12 2021   k_12_total                                                   147.0                                             147
1814399 AK     school 200525 6   Annette Island Schools 20052500111 60020 Charles R. Leask Sr. Middle School   Regular School No Middle 06 8 2021   k_12_total 2.0                   2.0                             88.0 2                   2                       88
1814815 AK     school 200800 10   Chugach Schools 20080000553 100030 Chenega School   Regular School No Other PK 12 2021   k_12_total 5.0                   6.0                             13.0 5                   6                       13
1812991 AK     school 200180 5   Anchorage Schools 20018000065 50110 Chester Valley Elementary   Regular School No Elementary PK 6 2021   k_12_total 38.0 18.0 17.0     20.0     58.0   53.0                             225.0 38 18 17     20     58   53                       225
1820495 AK     school 200005 55   Kashunamiut Schools 20000500582 550010 Chevak School   Regular School No Other PK 12 2021   k_12_total 1.0                                                 317.0 1                                           317
1819935 AK     school 200710 45   Southwest Region Schools 20071000336 450080 Chief Ivan Blunka School   Regular School No Other PK 12 2021   k_12_total                     6.0                             139.0                     6                       139
1817791 AK     school 200001 31   Lower Kuskokwim Schools 20000100210 310120 Chief Paul Memorial School   Regular School No Other PK 12 2021   k_12_total                                                   214.0                                             214
1817439 AK     school 200485 30   Lake and Peninsula Borough Schools 20048500193 300010 Chignik Bay School   Regular School No Other PK 12 2021   k_12_total 2.0     2.0             0.0                             12.0 2     2             0                       12
1817455 AK     school 200485 30   Lake and Peninsula Borough Schools 20048500194 300020 Chignik Lagoon School   Regular School No Other PK 12 2021   k_12_total                     4.0                             13.0                     4                       13
1817471 AK     school 200485 30   Lake and Peninsula Borough Schools 20048500195 300030 Chignik Lake School   Regular School No Other PK 12 2021   k_12_total                                                   14.0                                             14
1817119 AK     school 200480 28   Kodiak Island Borough Schools 20048000181 280020 Chiniak School   Regular School No Other KG 12 2021   k_12_total 10.0   1.0                                             19.0 10   1                                       19
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
1815631 AK     school 200600 16   Fairbanks North Star Borough Schools 20060000162 169010 Chinook Montessori Charter School   Regular School Yes Elementary KG 8 2021   k_12_total 107.0 5.0 8.0               22.0                             149.0 107 5 8               22                       149
1813023 AK     school 200180 5   Anchorage Schools 20018000067 50130 Chugach Optional Elementary   Regular School No Elementary PK 6 2021   k_12_total 171.0 6.0 16.0 1.0   8.0         35.0                             241.0 171 6 16 1   8         35                       241
1813055 AK     school 200180 5   Anchorage Schools 20018000068 50150 Chugiak Elementary   Regular School No Elementary PK 6 2021   k_12_total 223.0 1.0 37.0 2.0   10.0     4.0   40.0                             334.0 223 1 37 2   10     4   40                       334
1813071 AK     school 200180 5   Anchorage Schools 20018000069 50160 Chugiak High School   Regular School No High 09 12 2021   k_12_total 525.0 8.0 56.0 6.0   17.0     5.0   107.0                             760.0 525 8 56 6   17     5   107                       760
1820207 AK     school 200775 51   Yukon Flats Schools 20077500361 510050 Circle School   Regular School No Other PK 12 2021   k_12_total 1.0                                                 18.0 1                                           18
1813487 AK     school 200180 5   Anchorage Schools 20018000064 50560 Clark Middle School   Regular School No Middle 06 8 2021   k_12_total 51.0 100.0 117.0 3.0   177.0     153.0   114.0                             810.0 51 100 117 3   177     153   114                       810
1819871 AK     school 200710 45   Southwest Region Schools 20071000331 450030 Clarks Point School   Regular School No Other KG 12 2021   k_12_total                                                   15.0                                             15
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
1818495 AK     school 200510 33   Mat-Su Borough Schools 20051000711 330270 Colony High School   Regular School No High 09 12 2021   k_12_total 669.0 10.0 98.0 14.0   17.0     4.0   139.0                             1015.0 669 10 98 14   17     4   139                       1015
1818479 AK     school 200510 33   Mat-Su Borough Schools 20051000719 330260 Colony Middle School   Regular School No Middle 06 8 2021   k_12_total 375.0 7.0 68.0 6.0   12.0     2.0   80.0                             594.0 375 7 68 6   12     2   80                       594
1816799 AK     school 200390 24   Kenai Peninsula Borough Schools 20039000397 247010 Connections   Regular School No Other KG 12 2021   k_12_total 1426.0 7.0 52.0 12.0   6.0     1.0   207.0                             1784.0 1426 7 52 12   6     1   207                       1784

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