Data source: Big Local News · About: Big Local

995 rows where grade = "grade_7" and state = "AK" sorted by asian descending

View and edit SQL

year

grade

  • grade_7 · 995
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
1736157 AK     school 200510 33   Mat-Su Borough Schools 20051000719 330260 Colony Middle School   Regular School No Middle 06 8.0 2020   grade_7 175.0 4.0 23.0 6.0   9.0     1.0   30.0                             274 175 4 23 6   9     1   30                       274
1737309 AK     school 200240 42   Sitka Borough Schools 20024000136 420020 Blatchley Middle School   Regular School No Middle 06 8.0 2020   grade_7 49.0 1.0 4.0 2.0   9.0     3.0   6.0                             102 49 1 4 2   9     3   6                       102
1819276 AK     school 200610 36   North Slope Borough Schools 20061000139 360120 Eben Hopson Middle School   Regular School No Middle 06 8 2021   grade_7 0.0 1.0   0.0   9.0     2.0   14.0                             93.0 0 1   0   9     2   14                       93
1815404 AK     school 200600 16   Fairbanks North Star Borough Schools 20060000275 160260 Ryan Middle School   Regular School No Middle 07 8 2021   grade_7 78.0 13.0 19.0 2.0   8.0     3.0   47.0                             192.0 78 13 19 2   8     3   47                       192
1813484 AK     school 200180 5   Anchorage Schools 20018000064 50560 Clark Middle School   Regular School No Middle 06 8 2021   grade_7 17.0 37.0 42.0 1.0   77.0     50.0   39.0                             295.0 17 37 42 1   77     50   39                       295
1815548 AK     school 200600 16   Fairbanks North Star Borough Schools 20060000324 160410 Randy Smith Middle School   Regular School No Middle 07 8 2021   grade_7 65.0 8.0 8.0 0.0   7.0     0.0   28.0                             128.0 65 8 8 0   7     0   28                       128
1816044 AK     school 200210 22   Juneau Borough Schools 20021000129 220030 Floyd Dryden Middle School   Regular School No Middle 06 8 2021   grade_7 42.0   14.0 1.0   7.0     6.0   19.0                             113.0 42   14 1   7     6   19                       113
1819644 AK     school 200240 42   Sitka Borough Schools 20024000136 420020 Blatchley Middle School   Regular School No Middle 06 8 2021   grade_7 43.0 0.0 1.0 1.0   7.0     0.0   7.0                             84.0 43 0 1 1   7     0   7                       84
1731773 AK     school 200180 5   Anchorage Schools 20018000729 51150 Nicholas J. Begich Middle School   Regular School No Middle 06 8.0 2020   grade_7 56.0 33.0 31.0 3.0   66.0     40.0   67.0                             329 56 33 31 3   66     40   67                       329
1732621 AK     school 200060 12   Cordova City Schools 20006000029 120010 Cordova Jr/Sr High School   Regular School No High 07 12.0 2020   grade_7 12.0   1.0 0.0   6.0     0.0   0.0                             22 12   1 0   6     0   0                       22
1816556 AK     school 200390 24   Kenai Peninsula Borough Schools 20039000541 240220 Skyview Middle School   Regular School No Middle 07 8 2021   grade_7 106.0 2.0 9.0 0.0   6.0     0.0   14.0                             144.0 106 2 9 0   6     0   14                       144
1731149 AK     school 200180 5   Anchorage Schools 20018000064 50560 Clark Middle School   Regular School No Middle 06 8.0 2020   grade_7 21.0 42.0 31.0 0.0   59.0     49.0   43.0                             289 21 42 31 0   59     49   43                       289
1814092 AK     school 200180 5   Anchorage Schools 20018000729 51150 Nicholas J. Begich Middle School   Regular School No Middle 06 8 2021   grade_7 56.0 28.0 33.0 2.0   57.0     34.0   48.0                             293.0 56 28 33 2   57     34   48                       293
1731501 AK     school 200180 5   Anchorage Schools 20018000534 50870 Hanshew Middle School   Regular School No Middle 07 8.0 2020   grade_7 131.0 19.0 46.0     52.0     23.0   54.0                             366 131 19 46     52     23   54                       366
1733101 AK     school 200600 16   Fairbanks North Star Borough Schools 20060000275 160260 Ryan Middle School   Regular School No Middle 07 8.0 2020   grade_7 100.0 7.0 24.0 2.0   5.0     6.0   43.0                             221 100 7 24 2   5     6   43                       221
1733469 AK     school 200130 17   Galena City Schools 20013000253 178010 Interior Distance Education of Alaska (IDEA)   Regular School No Other PK 12.0 2020   grade_7 311.0 5.0 19.0 2.0   5.0     3.0   20.0                             386 311 5 19 2   5     3   20                       386
1736957 AK     school 200610 36   North Slope Borough Schools 20061000139 360120 Eben Hopson Middle School   Regular School No Middle 06 8.0 2020   grade_7 3.0 0.0   2.0   5.0     6.0   21.0                             86 3 0   2   5     6   21                       86
1813916 AK     school 200180 5   Anchorage Schools 20018000101 50990 Polaris K-12 School   Regular School No Other KG 12 2021   grade_7 28.0 1.0 2.0 0.0   5.0     2.0   7.0                             45.0 28 1 2 0   5     2   7                       45
1814924 AK     school 200060 12   Cordova City Schools 20006000029 120010 Cordova Jr/Sr High School   Regular School No High 07 12 2021   grade_7 9.0   0.0 1.0   5.0     0.0   1.0                             23.0 9   0 1   5     0   1                       23
1815756 AK     school 200130 17   Galena City Schools 20013000253 178010 Interior Distance Education of Alaska (IDEA)   Regular School No Other PK 12 2021   grade_7 521.0 7.0 34.0 6.0   5.0     7.0   56.0                             700.0 521 7 34 6   5     7   56                       700
1734893 AK     school 200480 28   Kodiak Island Borough Schools 20048000186 280070 Kodiak Middle School   Regular School No Middle 06 8.0 2020   grade_7 59.0 0.0 10.0 0.0   49.0     2.0   7.0                             153 59 0 10 0   49     2   7                       153
1813548 AK     school 200180 5   Anchorage Schools 20018000106 50610 Romig Middle School   Regular School No Middle 07 8 2021   grade_7 133.0 11.0 62.0 3.0   47.0     24.0   50.0                             366.0 133 11 62 3   47     24   50                       366
1731549 AK     school 200180 5   Anchorage Schools 20018000562 50940 Mears Middle School   Regular School No Middle 07 8.0 2020   grade_7 152.0 8.0 33.0 1.0   42.0     21.0   73.0                             368 152 8 33 1   42     21   73                       368
1813884 AK     school 200180 5   Anchorage Schools 20018000562 50940 Mears Middle School   Regular School No Middle 07 8 2021   grade_7 146.0 17.0 34.0 2.0   40.0     25.0   71.0                             358.0 146 17 34 2   40     25   71                       358
1734765 AK     school 200150 25   Ketchikan Gateway Borough Schools 20015000306 259010 Ketchikan Charter School   Regular School Yes Elementary KG 8.0 2020   grade_7 4.0 0.0 1.0 0.0   4.0     0.0   1.0                             15 4 0 1 0   4     0   1                       15
1736093 AK     school 200510 33   Mat-Su Borough Schools 20051000545 330140 Wasilla Middle School   Regular School No Middle 06 8.0 2020   grade_7 136.0 2.0 18.0 3.0   4.0     2.0   38.0                             231 136 2 18 3   4     2   38                       231
1736397 AK     school 200510 33   Mat-Su Borough Schools 20051000444 330440 Teeland Middle School   Regular School No Middle 06 8.0 2020   grade_7 188.0 3.0 17.0 5.0   4.0     0.0   23.0                             264 188 3 17 5   4     0   23                       264
1736413 AK     school 200510 33   Mat-Su Borough Schools 20051000450 330450 Houston Middle School   Regular School No Middle 06 8.0 2020   grade_7 65.0 2.0 6.0     4.0     5.0   15.0                             113 65 2 6     4     5   15                       113
1737245 AK     school 200660 39   Petersburg Borough Schools 20066000604 390030 Mitkof Middle School   Regular School No Middle 06 8.0 2020   grade_7 27.0 1.0 2.0     4.0     1.0   1.0                             44 27 1 2     4     1   1                       44
1813036 AK     school 200180 5   Anchorage Schools 20018000505 50140 Gruening Middle School   Regular School No Middle 06 8 2021   grade_7 119.0 12.0 33.0 1.0   4.0     4.0   22.0                             208.0 119 12 33 1   4     4   22                       208
1815340 AK     school 200600 16   Fairbanks North Star Borough Schools 20060000277 160220 Tanana Middle School   Regular School No Middle 07 8 2021   grade_7 64.0 16.0 17.0 0.0   4.0     3.0   31.0                             145.0 64 16 17 0   4     3   31                       145
1815612 AK     school 200600 16   Fairbanks North Star Borough Schools 20060000587 168010 Fairbanks B.E.S.T.   Regular School No Other PK 12 2021   grade_7 65.0 1.0 4.0 1.0   4.0         6.0                             82.0 65 1 4 1   4         6                       82
1818412 AK     school 200510 33   Mat-Su Borough Schools 20051000545 330140 Wasilla Middle School   Regular School No Middle 06 8 2021   grade_7 110.0 2.0 10.0 3.0   4.0     1.0   25.0                             177.0 110 2 10 3   4     1   25                       177
1731373 AK     school 200180 5   Anchorage Schools 20018000119 50720 Wendler Middle School   Regular School No Middle 07 8.0 2020   grade_7 45.0 18.0 30.0 1.0   38.0     21.0   43.0                             230 45 18 30 1   38     21   43                       230
1731213 AK     school 200180 5   Anchorage Schools 20018000106 50610 Romig Middle School   Regular School No Middle 07 8.0 2020   grade_7 141.0 10.0 64.0 1.0   35.0     27.0   41.0                             351 141 10 64 1   35     27   41                       351
1813836 AK     school 200180 5   Anchorage Schools 20018000534 50870 Hanshew Middle School   Regular School No Middle 07 8 2021   grade_7 110.0 13.0 39.0 2.0   32.0     16.0   49.0                             302.0 110 13 39 2   32     16   49                       302
1817180 AK     school 200480 28   Kodiak Island Borough Schools 20048000186 280070 Kodiak Middle School   Regular School No Middle 06 8 2021   grade_7 55.0 0.0 13.0 2.0   32.0     3.0   11.0                             150.0 55 0 13 2   32     3   11                       150
1813708 AK     school 200180 5   Anchorage Schools 20018000119 50720 Wendler Middle School   Regular School No Middle 07 8 2021   grade_7 49.0 13.0 28.0 1.0   31.0     24.0   52.0                             228.0 49 13 28 1   31     24   52                       228
1730701 AK     school 200180 5   Anchorage Schools 20018000505 50140 Gruening Middle School   Regular School No Middle 06 8.0 2020   grade_7 193.0 16.0 36.0 2.0   3.0     1.0   30.0                             293 193 16 36 2   3     1   30                       293
1737725 AK     school 200780 48   Valdez City Schools 20078000367 480040 George H. Gilson Middle School   Regular School No Middle 06 8.0 2020   grade_7 37.0 1.0 2.0 1.0   3.0     1.0   8.0                             55 37 1 2 1   3     1   8                       55
1738205 AK     school 200007 56   Aleutians East Borough Schools 20000700461 560020 Sand Point School   Regular School No Other PK 12.0 2020   grade_7 0.0   0.0     3.0     1.0   0.0                             11 0   0     3     1   0                       11
1814028 AK     school 200180 5   Anchorage Schools 20018000229 51060 Mirror Lake Middle School   Regular School No Middle 06 8 2021   grade_7 129.0 1.0 14.0 0.0   3.0     5.0   14.0                             171.0 129 1 14 0   3     5   14                       171
1815020 AK     school 200090 13   Craig City Schools 20009000160 138010 PACE Correspondence   Regular School No Other KG 12 2021   grade_7 31.0 4.0 3.0 0.0   3.0     1.0   14.0                             62.0 31 4 3 0   3     1   14                       62
1815388 AK     school 200600 16   Fairbanks North Star Borough Schools 20060000652 160250 North Pole Middle School   Regular School No Middle 06 8 2021   grade_7 82.0 2.0 8.0 0.0   3.0     1.0   31.0                             140.0 82 2 8 0   3     1   31                       140
1817052 AK     school 200150 25   Ketchikan Gateway Borough Schools 20015000306 259010 Ketchikan Charter School   Regular School Yes Elementary KG 8 2021   grade_7 7.0 0.0 1.0 3.0   3.0     0.0   2.0                             22.0 7 0 1 3   3     0   2                       22
1818476 AK     school 200510 33   Mat-Su Borough Schools 20051000719 330260 Colony Middle School   Regular School No Middle 06 8 2021   grade_7 126.0 2.0 23.0 2.0   3.0     1.0   25.0                             198.0 126 2 23 2   3     1   25                       198
1820412 AK     school 200862 52   Yukon-Koyukuk Schools 20086200453 528010 Raven School   Regular School No Other PK 12 2021   grade_7 176.0 9.0 24.0 5.0   3.0     3.0   32.0                             295.0 176 9 24 5   3     3   32                       295
1814012 AK     school 200180 5   Anchorage Schools 20018010162 51050 Goldenview Middle School   Regular School No Middle 07 8 2021   grade_7 203.0 5.0 27.0 0.0   29.0     4.0   31.0                             325.0 203 5 27 0   29     4   31                       325
1730637 AK     school 200180 5   Anchorage Schools 20018000063 50100 Central Middle School of Science   Regular School No Middle 07 8.0 2020   grade_7 65.0 14.0 29.0 3.0   23.0     34.0   29.0                             226 65 14 29 3   23     34   29                       226
1731693 AK     school 200180 5   Anchorage Schools 20018010162 51050 Goldenview Middle School   Regular School No Middle 07 8.0 2020   grade_7 227.0 5.0 33.0 1.0   20.0     3.0   52.0                             362 227 5 33 1   20     3   52                       362
1731293 AK     school 200180 5   Anchorage Schools 20018000115 50670 Steller Secondary School   Regular School No High 07 12.0 2020   grade_7 36.0 0.0 8.0 0.0   2.0     0.0   11.0                             58 36 0 8 0   2     0   11                       58
1731597 AK     school 200180 5   Anchorage Schools 20018000101 50990 Polaris K-12 School   Regular School No Other KG 12.0 2020   grade_7 36.0 1.0 1.0 1.0   2.0     0.0   4.0                             47 36 1 1 1   2     0   4                       47
1732717 AK     school 200090 13   Craig City Schools 20009000160 138010 PACE Correspondence   Regular School No Other KG 12.0 2020   grade_7 19.0 1.0 0.0 0.0   2.0     0.0   1.0                             24 19 1 0 0   2     0   1                       24
1732941 AK     school 200600 16   Fairbanks North Star Borough Schools 20060000260 160090 Ben Eielson Jr/Sr High School   Regular School No High 07 12.0 2020   grade_7 52.0 5.0 10.0 1.0   2.0     2.0   12.0                             85 52 5 10 1   2     2   12                       85
1733005 AK     school 200600 16   Fairbanks North Star Borough Schools 20060000269 160200 Joy Elementary   Regular School No Elementary PK 8.0 2020   grade_7 10.0 0.0 0.0 0.0   2.0     0.0   4.0                             18 10 0 0 0   2     0   4                       18
1733037 AK     school 200600 16   Fairbanks North Star Borough Schools 20060000277 160220 Tanana Middle School   Regular School No Middle 07 8.0 2020   grade_7 74.0 10.0 22.0 2.0   2.0     5.0   25.0                             154 74 10 22 2   2     5   25                       154
1733261 AK     school 200600 16   Fairbanks North Star Borough Schools 20060000324 160410 Randy Smith Middle School   Regular School No Middle 07 8.0 2020   grade_7 91.0 8.0 8.0 1.0   2.0     1.0   31.0                             151 91 8 8 1   2     1   31                       151
1735965 AK     school 200510 33   Mat-Su Borough Schools 20051000544 330020 Palmer Middle School   Regular School No Middle 06 8.0 2020   grade_7 134.0 1.0 20.0 3.0   2.0     2.0   18.0                             207 134 1 20 3   2     2   18                       207
1736493 AK     school 200510 33   Mat-Su Borough Schools 20051000758 330540 Joe Redington Senior Jr/Sr High School   Regular School No High 06 12.0 2020   grade_7 51.0 1.0 9.0 0.0   2.0     2.0   13.0                             92 51 1 9 0   2     2   13                       92
1738093 AK     school 200862 52   Yukon-Koyukuk Schools 20086200453 528010 Raven School   Regular School No Other PK 12.0 2020   grade_7 75.0 1.0 4.0 0.0   2.0     4.0   9.0                             106 75 1 4 0   2     4   9                       106
1813628 AK     school 200180 5   Anchorage Schools 20018000115 50670 Steller Secondary School   Regular School No High 07 12 2021   grade_7 36.0 4.0 5.0 0.0   2.0     2.0   6.0                             58.0 36 4 5 0   2     2   6                       58
1814108 AK     school 200180 5   Anchorage Schools 20018000178 56010 Family Partnership Charter School   Regular School Yes Other KG 12 2021   grade_7 81.0 1.0 6.0 4.0   2.0     0.0   17.0                             116.0 81 1 6 4   2     0   17                       116
1814268 AK     school 200180 5   Anchorage Schools 20018000530 59050 Frontier Charter School   Regular School Yes Other KG 12 2021   grade_7 38.0 1.0 10.0 0.0   2.0     0.0   7.0                             64.0 38 1 10 0   2     0   7                       64
1815164 AK     school 200600 16   Fairbanks North Star Borough Schools 20060000259 160020 Barnette Magnet School   Regular School No Elementary PK 8 2021   grade_7 23.0 0.0 5.0 0.0   2.0     1.0   6.0                             38.0 23 0 5 0   2     1   6                       38
1816204 AK     school 200210 22   Juneau Borough Schools 20021000755 227030 Montessori Borealis Public Alternative School   Regular School No Elementary PK 8 2021   grade_7 6.0 0.0 0.0     2.0         4.0                             13.0 6 0 0     2         4                       13
1817708 AK     school 200001 31   Lower Kuskokwim Schools 20000100208 310070 Bethel Regional High School   Regular School No High 07 12 2021   grade_7 11.0 1.0 2.0 0.0   2.0         0.0                             97.0 11 1 2 0   2         0                       97
1818700 AK     school 200510 33   Mat-Su Borough Schools 20051000444 330440 Teeland Middle School   Regular School No Middle 06 8 2021   grade_7 168.0 1.0 14.0 0.0   2.0     3.0   18.0                             230.0 168 1 14 0   2     3   18                       230
1818940 AK     school 200510 33   Mat-Su Borough Schools 20051000224 338010 Mat-Su Central School   Regular School No Other KG 12 2021   grade_7 190.0 4.0 12.0 0.0   2.0     0.0   26.0                             247.0 190 4 12 0   2     0   26                       247
1820524 AK     school 200007 56   Aleutians East Borough Schools 20000700461 560020 Sand Point School   Regular School No Other PK 12 2021   grade_7 0.0   0.0     2.0     1.0   0.0                             6.0 0   0     2     1   0                       6
1731069 AK     school 200180 5   Anchorage Schools 20018000094 50510 Northern Lights ABC K-8 School   Regular School No Elementary PK 8.0 2020   grade_7 17.0 2.0 6.0 0.0   19.0     1.0   14.0                             59 17 2 6 0   19     1   14                       59
1812972 AK     school 200180 5   Anchorage Schools 20018000063 50100 Central Middle School of Science   Regular School No Middle 07 8 2021   grade_7 35.0 22.0 29.0 2.0   18.0     15.0   25.0                             161.0 35 22 29 2   18     15   25                       161
1820012 AK     school 200720 47   Unalaska City Schools 20072000661 470020 Unalaska Jr/Sr High School   Regular School No High 07 12 2021   grade_7 8.0   3.0 0.0   17.0     1.0                                 32.0 8   3 0   17     1                           32
1813404 AK     school 200180 5   Anchorage Schools 20018000094 50510 Northern Lights ABC K-8 School   Regular School No Elementary PK 8 2021   grade_7 13.0 2.0 10.0 2.0   15.0     0.0   6.0                             50.0 13 2 10 2   15     0   6                       50
1816028 AK     school 200210 22   Juneau Borough Schools 20021000134 220020 Dzantik'i Heeni Middle School   Regular School No Middle 06 8 2021   grade_7 58.0 3.0 10.0 0.0   14.0     5.0   16.0                             132.0 58 3 10 0   14     5   16                       132
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
1734685 AK     school 200150 25   Ketchikan Gateway Borough Schools 20015000050 250040 Schoenbar Middle School   Regular School No Middle 07 8.0 2020   grade_7 86.0 2.0 1.0 3.0   13.0     1.0   7.0                             158 86 2 1 3   13     1   7                       158
1737693 AK     school 200720 47   Unalaska City Schools 20072000661 470020 Unalaska Jr/Sr High School   Regular School No High 07 12.0 2020   grade_7 7.0   4.0     13.0     0.0                                 28 7   4     13     0                           28
1733757 AK     school 200210 22   Juneau Borough Schools 20021000129 220030 Floyd Dryden Middle School   Regular School No Middle 06 8.0 2020   grade_7 70.0 1.0 9.0 0.0   11.0     6.0   33.0                             143 70 1 9 0   11     6   33                       143
1731709 AK     school 200180 5   Anchorage Schools 20018000229 51060 Mirror Lake Middle School   Regular School No Middle 06 8.0 2020   grade_7 153.0 2.0 15.0 2.0   10.0     3.0   32.0                             228 153 2 15 2   10     3   32                       228
1733741 AK     school 200210 22   Juneau Borough Schools 20021000134 220020 Dzantik'i Heeni Middle School   Regular School No Middle 06 8.0 2020   grade_7 72.0 4.0 13.0 0.0   10.0     2.0   29.0                             177 72 4 13 0   10     2   29                       177
1730349 AK     school 200770 2   Denali Borough Schools 20077000447 28010 Denali PEAK   Regular School No Other PK 12.0 2020   grade_7 39.0 3.0 7.0 0.0   1.0     1.0   7.0                             64 39 3 7 0   1     1   7                       64
1730445 AK     school 200050 3   Alaska Gateway Schools 20005000028 30060 Tok School   Regular School No Other PK 12.0 2020   grade_7 4.0     0.0   1.0         1.0                             13 4     0   1         1                       13
1730477 AK     school 200050 3   Alaska Gateway Schools 20005000023 38010 Alaska REACH Academy   Regular School No Other PK 12.0 2020   grade_7 1.0   0.0     1.0         0.0                             2 1   0     1         0                       2
1730909 AK     school 200180 5   Anchorage Schools 20018000077 50360 Girdwood School   Regular School No Elementary PK 8.0 2020   grade_7 10.0   0.0     1.0         3.0                             14 10   0     1         3                       14
1731789 AK     school 200180 5   Anchorage Schools 20018000178 56010 Family Partnership Charter School   Regular School Yes Other KG 12.0 2020   grade_7 33.0 1.0 5.0 0.0   1.0     5.0   5.0                             52 33 1 5 0   1     5   5                       52
1731949 AK     school 200180 5   Anchorage Schools 20018000530 59050 Frontier Charter School   Regular School Yes Other KG 12.0 2020   grade_7 11.0 1.0 2.0 0.0   1.0     0.0   0.0                             18 11 1 2 0   1     0   0                       18
1731965 AK     school 200180 5   Anchorage Schools 20018000555 59060 Highland Academy Charter   Regular School Yes High 06 12.0 2020   grade_7 8.0 0.0 4.0 1.0   1.0     0.0   11.0                             27 8 0 4 1   1     0   11                       27
1732013 AK     school 200180 5   Anchorage Schools 20018000732 59090 Rilke Schule Charter School   Regular School Yes Elementary KG 8.0 2020   grade_7 32.0 0.0 1.0 0.0   1.0         6.0                             41 32 0 1 0   1         6                       41
1732493 AK     school 200800 10   Chugach Schools 20080000372 100020 Whittier Community School   Regular School No Other PK 12.0 2020   grade_7 2.0 0.0 0.0     1.0     0.0   2.0                             5 2 0 0     1     0   2                       5
1732861 AK     school 200600 16   Fairbanks North Star Borough Schools 20060000259 160020 Barnette Magnet School   Regular School No Elementary PK 8.0 2020   grade_7 27.0 0.0 3.0 1.0   1.0     0.0   8.0                             41 27 0 3 1   1     0   8                       41
1733085 AK     school 200600 16   Fairbanks North Star Borough Schools 20060000652 160250 North Pole Middle School   Regular School No Middle 06 8.0 2020   grade_7 134.0 4.0 19.0 2.0   1.0     1.0   34.0                             210 134 4 19 2   1     1   34                       210
1733277 AK     school 200600 16   Fairbanks North Star Borough Schools 20060000325 167010 Alternative Learning Systems   Alternative School No Other PK 12.0 2020   grade_7 2.0 0.0 1.0     1.0         3.0                             10 2 0 1     1         3                       10
1733405 AK     school 200600 16   Fairbanks North Star Borough Schools 20060000761 169060 Boreal Sun Charter School   Regular School No Elementary KG 8.0 2020   grade_7 20.0   0.0     1.0         1.0                             22 20   0     1         1                       22
1733501 AK     school 200270 18   Haines Borough Schools 20027000144 180010 Haines Elementary   Regular School No Elementary PK 8.0 2020   grade_7 16.0 0.0 1.0 0.0   1.0         2.0                             24 16 0 1 0   1         2                       24
1733933 AK     school 200210 22   Juneau Borough Schools 20021000125 228010 HomeBRIDGE   Regular School No Other PK 12.0 2020   grade_7 3.0   0.0     1.0         2.0                             6 3   0     1         2                       6
1733997 AK     school 200390 24   Kenai Peninsula Borough Schools 20039000152 240020 Chapman School   Regular School No Elementary PK 8.0 2020   grade_7 8.0   0.0 0.0   1.0         5.0                             15 8   0 0   1         5                       15
1734381 AK     school 200390 24   Kenai Peninsula Borough Schools 20039000543 240320 Homer Middle School   Regular School No Middle 07 8.0 2020   grade_7 54.0   6.0 0.0   1.0     0.0   14.0                             80 54   6 0   1     0   14                       80
1734493 AK     school 200390 24   Kenai Peninsula Borough Schools 20039000437 240500 Seward Middle School   Regular School No Middle 06 8.0 2020   grade_7 41.0 0.0 4.0 1.0   1.0         6.0                             57 41 0 4 1   1         6                       57
1734989 AK     school 200480 28   Kodiak Island Borough Schools 20048000435 288010 AKTEACH   Regular School No Other KG 12.0 2020   grade_7 3.0 0.0 0.0     1.0     0.0   0.0                             6 3 0 0     1     0   0                       6
1735421 AK     school 200001 31   Lower Kuskokwim Schools 20000100208 310070 Bethel Regional High School   Regular School No High 07 12.0 2020   grade_7 9.0 0.0 1.0 1.0   1.0         0.0                             99 9 0 1 1   1         0                       99

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