enrollments

Data source: Big Local News · About: Big Local

15,920 rows where state = "AK" sorted by ccd_school_low_grade

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

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
1738148 1738148 AK     school   54   Yupiit Schools   548010 Akiachak School             2020   grade_1 0.0                   0.0                             15 0                   0                       15
1738149 1738149 AK     school   54   Yupiit Schools   548010 Akiachak School             2020   grade_10 0.0                   0.0                             14 0                   0                       14
1738150 1738150 AK     school   54   Yupiit Schools   548010 Akiachak School             2020   grade_11 0.0                   0.0                             10 0                   0                       10
1738151 1738151 AK     school   54   Yupiit Schools   548010 Akiachak School             2020   grade_12 1.0                   0.0                             15 1                   0                       15
1738152 1738152 AK     school   54   Yupiit Schools   548010 Akiachak School             2020   grade_2 0.0                   0.0                             24 0                   0                       24
1738153 1738153 AK     school   54   Yupiit Schools   548010 Akiachak School             2020   grade_3 0.0                   0.0                             12 0                   0                       12
1738154 1738154 AK     school   54   Yupiit Schools   548010 Akiachak School             2020   grade_4 0.0                   1.0                             22 0                   1                       22
1738155 1738155 AK     school   54   Yupiit Schools   548010 Akiachak School             2020   grade_5 0.0                   0.0                             24 0                   0                       24
1738156 1738156 AK     school   54   Yupiit Schools   548010 Akiachak School             2020   grade_6 0.0                   0.0                             10 0                   0                       10
1738157 1738157 AK     school   54   Yupiit Schools   548010 Akiachak School             2020   grade_7 0.0                   0.0                             15 0                   0                       15
1738158 1738158 AK     school   54   Yupiit Schools   548010 Akiachak School             2020   grade_8 0.0                   0.0                             9 0                   0                       9
1738159 1738159 AK     school   54   Yupiit Schools   548010 Akiachak School             2020   grade_9 0.0                   0.0                             16 0                   0                       16
1738160 1738160 AK     school   54   Yupiit Schools   548010 Akiachak School             2020   k_12_total 1.0                   2.0                             213 1                   2                       213
1738161 1738161 AK     school   54   Yupiit Schools   548010 Akiachak School             2020   kindergarten 0.0                   1.0                             27 0                   1                       27
1738162 1738162 AK     school   54   Yupiit Schools   548010 Akiachak School             2020   pk_12_total 1.0                   2.0                             213 1                   2                       213
1738163 1738163 AK     school   54   Yupiit Schools   548010 Akiachak School             2020   pre_kindergarten 0.0                   0.0                             0 0                   0                       0
1737332 1737332 AK     school 200240 42   Sitka Borough Schools 20024000638 420170 Keet Gooshi Heen Elementary   Regular School No Elementary 02 5.0 2020   grade_1 0.0 0.0 0.0 0.0   0.0     0.0   0.0                             0 0 0 0 0   0     0   0                       0
1737333 1737333 AK     school 200240 42   Sitka Borough Schools 20024000638 420170 Keet Gooshi Heen Elementary   Regular School No Elementary 02 5.0 2020   grade_10 0.0 0.0 0.0 0.0   0.0     0.0   0.0                             0 0 0 0 0   0     0   0                       0
1737334 1737334 AK     school 200240 42   Sitka Borough Schools 20024000638 420170 Keet Gooshi Heen Elementary   Regular School No Elementary 02 5.0 2020   grade_11 0.0 0.0 0.0 0.0   0.0     0.0   0.0                             0 0 0 0 0   0     0   0                       0
1737335 1737335 AK     school 200240 42   Sitka Borough Schools 20024000638 420170 Keet Gooshi Heen Elementary   Regular School No Elementary 02 5.0 2020   grade_12 0.0 0.0 0.0 0.0   0.0     0.0   0.0                             0 0 0 0 0   0     0   0                       0
1737336 1737336 AK     school 200240 42   Sitka Borough Schools 20024000638 420170 Keet Gooshi Heen Elementary   Regular School No Elementary 02 5.0 2020   grade_2 45.0 0.0 4.0 3.0   4.0     0.0   10.0                             84 45 0 4 3   4     0   10                       84
1737337 1737337 AK     school 200240 42   Sitka Borough Schools 20024000638 420170 Keet Gooshi Heen Elementary   Regular School No Elementary 02 5.0 2020   grade_3 45.0 1.0 6.0 4.0   7.0     1.0   10.0                             93 45 1 6 4   7     1   10                       93
1737338 1737338 AK     school 200240 42   Sitka Borough Schools 20024000638 420170 Keet Gooshi Heen Elementary   Regular School No Elementary 02 5.0 2020   grade_4 45.0 1.0 4.0 1.0   7.0     0.0   1.0                             85 45 1 4 1   7     0   1                       85
1737339 1737339 AK     school 200240 42   Sitka Borough Schools 20024000638 420170 Keet Gooshi Heen Elementary   Regular School No Elementary 02 5.0 2020   grade_5 54.0 3.0 3.0 2.0   5.0     0.0   2.0                             104 54 3 3 2   5     0   2                       104
1737340 1737340 AK     school 200240 42   Sitka Borough Schools 20024000638 420170 Keet Gooshi Heen Elementary   Regular School No Elementary 02 5.0 2020   grade_6 0.0 0.0 0.0 0.0   0.0     0.0   0.0                             0 0 0 0 0   0     0   0                       0
1737341 1737341 AK     school 200240 42   Sitka Borough Schools 20024000638 420170 Keet Gooshi Heen Elementary   Regular School No Elementary 02 5.0 2020   grade_7 0.0 0.0 0.0 0.0   0.0     0.0   0.0                             0 0 0 0 0   0     0   0                       0
1737342 1737342 AK     school 200240 42   Sitka Borough Schools 20024000638 420170 Keet Gooshi Heen Elementary   Regular School No Elementary 02 5.0 2020   grade_8 0.0 0.0 0.0 0.0   0.0     0.0   0.0                             0 0 0 0 0   0     0   0                       0
1737343 1737343 AK     school 200240 42   Sitka Borough Schools 20024000638 420170 Keet Gooshi Heen Elementary   Regular School No Elementary 02 5.0 2020   grade_9 0.0 0.0 0.0 0.0   0.0     0.0   0.0                             0 0 0 0 0   0     0   0                       0
1737344 1737344 AK     school 200240 42   Sitka Borough Schools 20024000638 420170 Keet Gooshi Heen Elementary   Regular School No Elementary 02 5.0 2020   k_12_total 189.0 5.0 17.0 10.0   23.0     1.0   23.0                             366 189 5 17 10   23     1   23                       366
1737345 1737345 AK     school 200240 42   Sitka Borough Schools 20024000638 420170 Keet Gooshi Heen Elementary   Regular School No Elementary 02 5.0 2020   kindergarten 0.0 0.0 0.0 0.0   0.0     0.0   0.0                             0 0 0 0 0   0     0   0                       0
1737346 1737346 AK     school 200240 42   Sitka Borough Schools 20024000638 420170 Keet Gooshi Heen Elementary   Regular School No Elementary 02 5.0 2020   pk_12_total 189.0 5.0 17.0 10.0   23.0     1.0   23.0                             366 189 5 17 10   23     1   23                       366
1737347 1737347 AK     school 200240 42   Sitka Borough Schools 20024000638 420170 Keet Gooshi Heen Elementary   Regular School No Elementary 02 5.0 2020   pre_kindergarten 0.0 0.0 0.0 0.0   0.0     0.0   0.0                             0 0 0 0 0   0     0   0                       0
1819667 1819667 AK     school 200240 42   Sitka Borough Schools 20024000638 420170 Keet Gooshi Heen Elementary   Regular School No Elementary 02 5 2021   grade_1 0.0 0.0 0.0 0.0   0.0     0.0   0.0                             0.0 0 0 0 0   0     0   0                       0
1819668 1819668 AK     school 200240 42   Sitka Borough Schools 20024000638 420170 Keet Gooshi Heen Elementary   Regular School No Elementary 02 5 2021   grade_10 0.0 0.0 0.0 0.0   0.0     0.0   0.0                             0.0 0 0 0 0   0     0   0                       0
1819669 1819669 AK     school 200240 42   Sitka Borough Schools 20024000638 420170 Keet Gooshi Heen Elementary   Regular School No Elementary 02 5 2021   grade_11 0.0 0.0 0.0 0.0   0.0     0.0   0.0                             0.0 0 0 0 0   0     0   0                       0
1819670 1819670 AK     school 200240 42   Sitka Borough Schools 20024000638 420170 Keet Gooshi Heen Elementary   Regular School No Elementary 02 5 2021   grade_12 0.0 0.0 0.0 0.0   0.0     0.0   0.0                             0.0 0 0 0 0   0     0   0                       0
1819671 1819671 AK     school 200240 42   Sitka Borough Schools 20024000638 420170 Keet Gooshi Heen Elementary   Regular School No Elementary 02 5 2021   grade_2 37.0 0.0 6.0 3.0   6.0     2.0   8.0                             78.0 37 0 6 3   6     2   8                       78
1819672 1819672 AK     school 200240 42   Sitka Borough Schools 20024000638 420170 Keet Gooshi Heen Elementary   Regular School No Elementary 02 5 2021   grade_3 37.0 0.0 4.0 3.0   4.0     0.0   8.0                             70.0 37 0 4 3   4     0   8                       70
1819673 1819673 AK     school 200240 42   Sitka Borough Schools 20024000638 420170 Keet Gooshi Heen Elementary   Regular School No Elementary 02 5 2021   grade_4 42.0 1.0 5.0 3.0   8.0     1.0   9.0                             85.0 42 1 5 3   8     1   9                       85
1819674 1819674 AK     school 200240 42   Sitka Borough Schools 20024000638 420170 Keet Gooshi Heen Elementary   Regular School No Elementary 02 5 2021   grade_5 36.0 1.0 4.0 1.0   7.0     0.0   1.0                             73.0 36 1 4 1   7     0   1                       73
1819675 1819675 AK     school 200240 42   Sitka Borough Schools 20024000638 420170 Keet Gooshi Heen Elementary   Regular School No Elementary 02 5 2021   grade_6 0.0 0.0 0.0 0.0   0.0     0.0   0.0                             0.0 0 0 0 0   0     0   0                       0
1819676 1819676 AK     school 200240 42   Sitka Borough Schools 20024000638 420170 Keet Gooshi Heen Elementary   Regular School No Elementary 02 5 2021   grade_7 0.0 0.0 0.0 0.0   0.0     0.0   0.0                             0.0 0 0 0 0   0     0   0                       0
1819677 1819677 AK     school 200240 42   Sitka Borough Schools 20024000638 420170 Keet Gooshi Heen Elementary   Regular School No Elementary 02 5 2021   grade_8 0.0 0.0 0.0 0.0   0.0     0.0   0.0                             0.0 0 0 0 0   0     0   0                       0
1819678 1819678 AK     school 200240 42   Sitka Borough Schools 20024000638 420170 Keet Gooshi Heen Elementary   Regular School No Elementary 02 5 2021   grade_9 0.0 0.0 0.0 0.0   0.0     0.0   0.0                             0.0 0 0 0 0   0     0   0                       0
1819679 1819679 AK     school 200240 42   Sitka Borough Schools 20024000638 420170 Keet Gooshi Heen Elementary   Regular School No Elementary 02 5 2021   k_12_total 152.0 2.0 19.0 10.0   25.0     3.0   26.0                             306.0 152 2 19 10   25     3   26                       306
1819680 1819680 AK     school 200240 42   Sitka Borough Schools 20024000638 420170 Keet Gooshi Heen Elementary   Regular School No Elementary 02 5 2021   kindergarten 0.0 0.0 0.0 0.0   0.0     0.0   0.0                             0.0 0 0 0 0   0     0   0                       0
1819681 1819681 AK     school 200240 42   Sitka Borough Schools 20024000638 420170 Keet Gooshi Heen Elementary   Regular School No Elementary 02 5 2021   pk_12_total 152.0 2.0 19.0 10.0   25.0     3.0   26.0                             306.0 152 2 19 10   25     3   26                       306
1819682 1819682 AK     school 200240 42   Sitka Borough Schools 20024000638 420170 Keet Gooshi Heen Elementary   Regular School No Elementary 02 5 2021   pre_kindergarten 0.0 0.0 0.0 0.0   0.0     0.0   0.0                             0.0 0 0 0 0   0     0   0                       0
1733236 1733236 AK     school 200600 16   Fairbanks North Star Borough Schools 20060000238 160400 Crawford Elementary   Regular School No Elementary 03 6.0 2020   grade_1 0.0 0.0 0.0 0.0   0.0     0.0   0.0                             0 0 0 0 0   0     0   0                       0
1733237 1733237 AK     school 200600 16   Fairbanks North Star Borough Schools 20060000238 160400 Crawford Elementary   Regular School No Elementary 03 6.0 2020   grade_10 0.0 0.0 0.0 0.0   0.0     0.0   0.0                             0 0 0 0 0   0     0   0                       0
1733238 1733238 AK     school 200600 16   Fairbanks North Star Borough Schools 20060000238 160400 Crawford Elementary   Regular School No Elementary 03 6.0 2020   grade_11 0.0 0.0 0.0 0.0   0.0     0.0   0.0                             0 0 0 0 0   0     0   0                       0
1733239 1733239 AK     school 200600 16   Fairbanks North Star Borough Schools 20060000238 160400 Crawford Elementary   Regular School No Elementary 03 6.0 2020   grade_12 0.0 0.0 0.0 0.0   0.0     0.0   0.0                             0 0 0 0 0   0     0   0                       0
1733240 1733240 AK     school 200600 16   Fairbanks North Star Borough Schools 20060000238 160400 Crawford Elementary   Regular School No Elementary 03 6.0 2020   grade_2 0.0 0.0 0.0 0.0   0.0     0.0   0.0                             0 0 0 0 0   0     0   0                       0
1733241 1733241 AK     school 200600 16   Fairbanks North Star Borough Schools 20060000238 160400 Crawford Elementary   Regular School No Elementary 03 6.0 2020   grade_3 47.0 2.0 8.0 0.0   1.0     1.0   6.0                             65 47 2 8 0   1     1   6                       65
1733242 1733242 AK     school 200600 16   Fairbanks North Star Borough Schools 20060000238 160400 Crawford Elementary   Regular School No Elementary 03 6.0 2020   grade_4 45.0 0.0 14.0 1.0   2.0     1.0   8.0                             71 45 0 14 1   2     1   8                       71
1733243 1733243 AK     school 200600 16   Fairbanks North Star Borough Schools 20060000238 160400 Crawford Elementary   Regular School No Elementary 03 6.0 2020   grade_5 43.0 3.0 15.0 0.0   2.0     0.0   6.0                             69 43 3 15 0   2     0   6                       69
1733244 1733244 AK     school 200600 16   Fairbanks North Star Borough Schools 20060000238 160400 Crawford Elementary   Regular School No Elementary 03 6.0 2020   grade_6 44.0 5.0 12.0 1.0   0.0     1.0   11.0                             75 44 5 12 1   0     1   11                       75
1733245 1733245 AK     school 200600 16   Fairbanks North Star Borough Schools 20060000238 160400 Crawford Elementary   Regular School No Elementary 03 6.0 2020   grade_7 0.0 0.0 0.0 0.0   0.0     0.0   0.0                             0 0 0 0 0   0     0   0                       0
1733246 1733246 AK     school 200600 16   Fairbanks North Star Borough Schools 20060000238 160400 Crawford Elementary   Regular School No Elementary 03 6.0 2020   grade_8 0.0 0.0 0.0 0.0   0.0     0.0   0.0                             0 0 0 0 0   0     0   0                       0
1733247 1733247 AK     school 200600 16   Fairbanks North Star Borough Schools 20060000238 160400 Crawford Elementary   Regular School No Elementary 03 6.0 2020   grade_9 0.0 0.0 0.0 0.0   0.0     0.0   0.0                             0 0 0 0 0   0     0   0                       0
1733248 1733248 AK     school 200600 16   Fairbanks North Star Borough Schools 20060000238 160400 Crawford Elementary   Regular School No Elementary 03 6.0 2020   k_12_total 179.0 10.0 49.0 2.0   5.0     3.0   31.0                             280 179 10 49 2   5     3   31                       280
1733249 1733249 AK     school 200600 16   Fairbanks North Star Borough Schools 20060000238 160400 Crawford Elementary   Regular School No Elementary 03 6.0 2020   kindergarten 0.0 0.0 0.0 0.0   0.0     0.0   0.0                             0 0 0 0 0   0     0   0                       0
1733250 1733250 AK     school 200600 16   Fairbanks North Star Borough Schools 20060000238 160400 Crawford Elementary   Regular School No Elementary 03 6.0 2020   pk_12_total 179.0 10.0 49.0 2.0   5.0     3.0   31.0                             280 179 10 49 2   5     3   31                       280
1733251 1733251 AK     school 200600 16   Fairbanks North Star Borough Schools 20060000238 160400 Crawford Elementary   Regular School No Elementary 03 6.0 2020   pre_kindergarten 0.0 0.0 0.0 0.0   0.0     0.0   0.0                             0 0 0 0 0   0     0   0                       0
1734468 1734468 AK     school 200390 24   Kenai Peninsula Borough Schools 20039000299 240490 West Homer Elementary   Regular School No Elementary 03 6.0 2020   grade_1 0.0   0.0 0.0   0.0         0.0                             0 0   0 0   0         0                       0
1734469 1734469 AK     school 200390 24   Kenai Peninsula Borough Schools 20039000299 240490 West Homer Elementary   Regular School No Elementary 03 6.0 2020   grade_10 0.0   0.0 0.0   0.0         0.0                             0 0   0 0   0         0                       0
1734470 1734470 AK     school 200390 24   Kenai Peninsula Borough Schools 20039000299 240490 West Homer Elementary   Regular School No Elementary 03 6.0 2020   grade_11 0.0   0.0 0.0   0.0         0.0                             0 0   0 0   0         0                       0
1734471 1734471 AK     school 200390 24   Kenai Peninsula Borough Schools 20039000299 240490 West Homer Elementary   Regular School No Elementary 03 6.0 2020   grade_12 0.0   0.0 0.0   0.0         0.0                             0 0   0 0   0         0                       0
1734472 1734472 AK     school 200390 24   Kenai Peninsula Borough Schools 20039000299 240490 West Homer Elementary   Regular School No Elementary 03 6.0 2020   grade_2 0.0   0.0 0.0   0.0         0.0                             0 0   0 0   0         0                       0
1734473 1734473 AK     school 200390 24   Kenai Peninsula Borough Schools 20039000299 240490 West Homer Elementary   Regular School No Elementary 03 6.0 2020   grade_3 55.0   0.0 0.0   1.0         9.0                             68 55   0 0   1         9                       68
1734474 1734474 AK     school 200390 24   Kenai Peninsula Borough Schools 20039000299 240490 West Homer Elementary   Regular School No Elementary 03 6.0 2020   grade_4 41.0   1.0 0.0   0.0         8.0                             51 41   1 0   0         8                       51
1734475 1734475 AK     school 200390 24   Kenai Peninsula Borough Schools 20039000299 240490 West Homer Elementary   Regular School No Elementary 03 6.0 2020   grade_5 50.0   3.0 0.0   1.0         5.0                             62 50   3 0   1         5                       62
1734476 1734476 AK     school 200390 24   Kenai Peninsula Borough Schools 20039000299 240490 West Homer Elementary   Regular School No Elementary 03 6.0 2020   grade_6 53.0   1.0 1.0   1.0         2.0                             61 53   1 1   1         2                       61
1734477 1734477 AK     school 200390 24   Kenai Peninsula Borough Schools 20039000299 240490 West Homer Elementary   Regular School No Elementary 03 6.0 2020   grade_7 0.0   0.0 0.0   0.0         0.0                             0 0   0 0   0         0                       0
1734478 1734478 AK     school 200390 24   Kenai Peninsula Borough Schools 20039000299 240490 West Homer Elementary   Regular School No Elementary 03 6.0 2020   grade_8 0.0   0.0 0.0   0.0         0.0                             0 0   0 0   0         0                       0
1734479 1734479 AK     school 200390 24   Kenai Peninsula Borough Schools 20039000299 240490 West Homer Elementary   Regular School No Elementary 03 6.0 2020   grade_9 0.0   0.0 0.0   0.0         0.0                             0 0   0 0   0         0                       0
1734480 1734480 AK     school 200390 24   Kenai Peninsula Borough Schools 20039000299 240490 West Homer Elementary   Regular School No Elementary 03 6.0 2020   k_12_total 199.0   5.0 1.0   3.0         24.0                             242 199   5 1   3         24                       242
1734481 1734481 AK     school 200390 24   Kenai Peninsula Borough Schools 20039000299 240490 West Homer Elementary   Regular School No Elementary 03 6.0 2020   kindergarten 0.0   0.0 0.0   0.0         0.0                             0 0   0 0   0         0                       0
1734482 1734482 AK     school 200390 24   Kenai Peninsula Borough Schools 20039000299 240490 West Homer Elementary   Regular School No Elementary 03 6.0 2020   pk_12_total 199.0   5.0 1.0   3.0         24.0                             242 199   5 1   3         24                       242
1734483 1734483 AK     school 200390 24   Kenai Peninsula Borough Schools 20039000299 240490 West Homer Elementary   Regular School No Elementary 03 6.0 2020   pre_kindergarten 0.0   0.0 0.0   0.0         0.0                             0 0   0 0   0         0                       0
1735076 1735076 AK     school 200760 29   Kuspuk Schools 20076000350 290050 Zackar Levi Elementary   Regular School No Elementary 03 5.0 2020   grade_1                     0.0                             0                     0                       0
1735077 1735077 AK     school 200760 29   Kuspuk Schools 20076000350 290050 Zackar Levi Elementary   Regular School No Elementary 03 5.0 2020   grade_10                     0.0                             0                     0                       0
1735078 1735078 AK     school 200760 29   Kuspuk Schools 20076000350 290050 Zackar Levi Elementary   Regular School No Elementary 03 5.0 2020   grade_11                     0.0                             0                     0                       0
1735079 1735079 AK     school 200760 29   Kuspuk Schools 20076000350 290050 Zackar Levi Elementary   Regular School No Elementary 03 5.0 2020   grade_12                     0.0                             0                     0                       0
1735080 1735080 AK     school 200760 29   Kuspuk Schools 20076000350 290050 Zackar Levi Elementary   Regular School No Elementary 03 5.0 2020   grade_2                     0.0                             0                     0                       0
1735081 1735081 AK     school 200760 29   Kuspuk Schools 20076000350 290050 Zackar Levi Elementary   Regular School No Elementary 03 5.0 2020   grade_3                     1.0                             15                     1                       15
1735082 1735082 AK     school 200760 29   Kuspuk Schools 20076000350 290050 Zackar Levi Elementary   Regular School No Elementary 03 5.0 2020   grade_4                     0.0                             11                     0                       11
1735083 1735083 AK     school 200760 29   Kuspuk Schools 20076000350 290050 Zackar Levi Elementary   Regular School No Elementary 03 5.0 2020   grade_5                     0.0                             17                     0                       17
1735084 1735084 AK     school 200760 29   Kuspuk Schools 20076000350 290050 Zackar Levi Elementary   Regular School No Elementary 03 5.0 2020   grade_6                     0.0                             0                     0                       0
1735085 1735085 AK     school 200760 29   Kuspuk Schools 20076000350 290050 Zackar Levi Elementary   Regular School No Elementary 03 5.0 2020   grade_7                     0.0                             0                     0                       0
1735086 1735086 AK     school 200760 29   Kuspuk Schools 20076000350 290050 Zackar Levi Elementary   Regular School No Elementary 03 5.0 2020   grade_8                     0.0                             0                     0                       0
1735087 1735087 AK     school 200760 29   Kuspuk Schools 20076000350 290050 Zackar Levi Elementary   Regular School No Elementary 03 5.0 2020   grade_9                     0.0                             0                     0                       0
1735088 1735088 AK     school 200760 29   Kuspuk Schools 20076000350 290050 Zackar Levi Elementary   Regular School No Elementary 03 5.0 2020   k_12_total                     1.0                             43                     1                       43
1735089 1735089 AK     school 200760 29   Kuspuk Schools 20076000350 290050 Zackar Levi Elementary   Regular School No Elementary 03 5.0 2020   kindergarten                     0.0                             0                     0                       0
1735090 1735090 AK     school 200760 29   Kuspuk Schools 20076000350 290050 Zackar Levi Elementary   Regular School No Elementary 03 5.0 2020   pk_12_total                     1.0                             43                     1                       43
1735091 1735091 AK     school 200760 29   Kuspuk Schools 20076000350 290050 Zackar Levi Elementary   Regular School No Elementary 03 5.0 2020   pre_kindergarten                     0.0                             0                     0                       0
1735396 1735396 AK     school 200001 31   Lower Kuskokwim Schools 20000100207 310060 Gladys Jung Elementary   Regular School No Elementary 03 6.0 2020   grade_1 0.0 0.0 0.0 0.0   0.0         0.0                             0 0 0 0 0   0         0                       0
1735397 1735397 AK     school 200001 31   Lower Kuskokwim Schools 20000100207 310060 Gladys Jung Elementary   Regular School No Elementary 03 6.0 2020   grade_10 0.0 0.0 0.0 0.0   0.0         0.0                             0 0 0 0 0   0         0                       0
1735398 1735398 AK     school 200001 31   Lower Kuskokwim Schools 20000100207 310060 Gladys Jung Elementary   Regular School No Elementary 03 6.0 2020   grade_11 0.0 0.0 0.0 0.0   0.0         0.0                             0 0 0 0 0   0         0                       0
1735399 1735399 AK     school 200001 31   Lower Kuskokwim Schools 20000100207 310060 Gladys Jung Elementary   Regular School No Elementary 03 6.0 2020   grade_12 0.0 0.0 0.0 0.0   0.0         0.0                             0 0 0 0 0   0         0                       0

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