Data source: Big Local News · About: Big Local

15,920 rows where state = "AK" sorted by ccd_school_type descending

View and edit SQL

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
1731796 AK     school 200180 5   Anchorage Schools 20018000341 57010 Alaska State School for Deaf and Hard of Hearing   Special Education School No Other PK 12.0 2020   grade_1 0.0 0.0 0.0     0.0         1.0                             1 0 0 0     0         1                       1
1731797 AK     school 200180 5   Anchorage Schools 20018000341 57010 Alaska State School for Deaf and Hard of Hearing   Special Education School No Other PK 12.0 2020   grade_10 0.0 0.0 0.0     1.0         0.0                             2 0 0 0     1         0                       2
1731798 AK     school 200180 5   Anchorage Schools 20018000341 57010 Alaska State School for Deaf and Hard of Hearing   Special Education School No Other PK 12.0 2020   grade_11 0.0 0.0 0.0     0.0         0.0                             1 0 0 0     0         0                       1
1731799 AK     school 200180 5   Anchorage Schools 20018000341 57010 Alaska State School for Deaf and Hard of Hearing   Special Education School No Other PK 12.0 2020   grade_12 0.0 0.0 0.0     1.0         0.0                             2 0 0 0     1         0                       2
1731800 AK     school 200180 5   Anchorage Schools 20018000341 57010 Alaska State School for Deaf and Hard of Hearing   Special Education School No Other PK 12.0 2020   grade_2 1.0 0.0 0.0     0.0         0.0                             2 1 0 0     0         0                       2
1731801 AK     school 200180 5   Anchorage Schools 20018000341 57010 Alaska State School for Deaf and Hard of Hearing   Special Education School No Other PK 12.0 2020   grade_3 3.0 0.0 0.0     0.0         0.0                             4 3 0 0     0         0                       4
1731802 AK     school 200180 5   Anchorage Schools 20018000341 57010 Alaska State School for Deaf and Hard of Hearing   Special Education School No Other PK 12.0 2020   grade_4 1.0 0.0 0.0     0.0         0.0                             2 1 0 0     0         0                       2
1731803 AK     school 200180 5   Anchorage Schools 20018000341 57010 Alaska State School for Deaf and Hard of Hearing   Special Education School No Other PK 12.0 2020   grade_5 2.0 0.0 0.0     0.0         0.0                             3 2 0 0     0         0                       3
1731804 AK     school 200180 5   Anchorage Schools 20018000341 57010 Alaska State School for Deaf and Hard of Hearing   Special Education School No Other PK 12.0 2020   grade_6 3.0 1.0 0.0     0.0         0.0                             4 3 1 0     0         0                       4
1731805 AK     school 200180 5   Anchorage Schools 20018000341 57010 Alaska State School for Deaf and Hard of Hearing   Special Education School No Other PK 12.0 2020   grade_7 1.0 0.0 1.0     0.0         0.0                             2 1 0 1     0         0                       2
1731806 AK     school 200180 5   Anchorage Schools 20018000341 57010 Alaska State School for Deaf and Hard of Hearing   Special Education School No Other PK 12.0 2020   grade_8 0.0 0.0 0.0     0.0         1.0                             1 0 0 0     0         1                       1
1731807 AK     school 200180 5   Anchorage Schools 20018000341 57010 Alaska State School for Deaf and Hard of Hearing   Special Education School No Other PK 12.0 2020   grade_9 0.0 0.0 0.0     0.0         0.0                             1 0 0 0     0         0                       1
1731808 AK     school 200180 5   Anchorage Schools 20018000341 57010 Alaska State School for Deaf and Hard of Hearing   Special Education School No Other PK 12.0 2020   k_12_total 14.0 2.0 1.0     2.0         2.0                             29 14 2 1     2         2                       29
1731809 AK     school 200180 5   Anchorage Schools 20018000341 57010 Alaska State School for Deaf and Hard of Hearing   Special Education School No Other PK 12.0 2020   kindergarten 3.0 1.0 0.0     0.0         0.0                             4 3 1 0     0         0                       4
1731810 AK     school 200180 5   Anchorage Schools 20018000341 57010 Alaska State School for Deaf and Hard of Hearing   Special Education School No Other PK 12.0 2020   pk_12_total 15.0 2.0 1.0     2.0         2.0                             30 15 2 1     2         2                       30
1731811 AK     school 200180 5   Anchorage Schools 20018000341 57010 Alaska State School for Deaf and Hard of Hearing   Special Education School No Other PK 12.0 2020   pre_kindergarten 1.0 0.0 0.0     0.0         0.0                             1 1 0 0     0         0                       1
1731876 AK     school 200180 5   Anchorage Schools 20018000121 57140 Whaley School   Special Education School No Other PK 12.0 2020   grade_1 2.0 1.0 0.0 0.0   0.0     0.0   0.0                             3 2 1 0 0   0     0   0                       3
1731877 AK     school 200180 5   Anchorage Schools 20018000121 57140 Whaley School   Special Education School No Other PK 12.0 2020   grade_10 9.0 3.0 2.0 1.0   2.0     2.0   7.0                             39 9 3 2 1   2     2   7                       39
1731878 AK     school 200180 5   Anchorage Schools 20018000121 57140 Whaley School   Special Education School No Other PK 12.0 2020   grade_11 15.0 3.0 2.0 0.0   0.0     2.0   6.0                             35 15 3 2 0   0     2   6                       35
1731879 AK     school 200180 5   Anchorage Schools 20018000121 57140 Whaley School   Special Education School No Other PK 12.0 2020   grade_12 74.0 13.0 23.0 0.0   16.0     9.0   41.0                             208 74 13 23 0   16     9   41                       208
1731880 AK     school 200180 5   Anchorage Schools 20018000121 57140 Whaley School   Special Education School No Other PK 12.0 2020   grade_2 2.0 0.0 0.0 0.0   0.0     0.0   0.0                             2 2 0 0 0   0     0   0                       2
1731881 AK     school 200180 5   Anchorage Schools 20018000121 57140 Whaley School   Special Education School No Other PK 12.0 2020   grade_3 1.0 0.0 0.0 0.0   0.0     0.0   2.0                             4 1 0 0 0   0     0   2                       4
1731882 AK     school 200180 5   Anchorage Schools 20018000121 57140 Whaley School   Special Education School No Other PK 12.0 2020   grade_4 2.0 0.0 0.0 0.0   0.0     0.0   1.0                             4 2 0 0 0   0     0   1                       4
1731883 AK     school 200180 5   Anchorage Schools 20018000121 57140 Whaley School   Special Education School No Other PK 12.0 2020   grade_5 4.0 0.0 1.0 0.0   0.0     0.0   1.0                             6 4 0 1 0   0     0   1                       6
1731884 AK     school 200180 5   Anchorage Schools 20018000121 57140 Whaley School   Special Education School No Other PK 12.0 2020   grade_6 2.0 3.0 0.0 0.0   1.0     0.0   6.0                             15 2 3 0 0   1     0   6                       15
1731885 AK     school 200180 5   Anchorage Schools 20018000121 57140 Whaley School   Special Education School No Other PK 12.0 2020   grade_7 11.0 2.0 1.0 0.0   0.0     1.0   1.0                             17 11 2 1 0   0     1   1                       17
1731886 AK     school 200180 5   Anchorage Schools 20018000121 57140 Whaley School   Special Education School No Other PK 12.0 2020   grade_8 13.0 1.0 1.0 0.0   1.0     0.0   4.0                             27 13 1 1 0   1     0   4                       27
1731887 AK     school 200180 5   Anchorage Schools 20018000121 57140 Whaley School   Special Education School No Other PK 12.0 2020   grade_9 11.0 6.0 4.0 0.0   0.0     3.0   3.0                             37 11 6 4 0   0     3   3                       37
1731888 AK     school 200180 5   Anchorage Schools 20018000121 57140 Whaley School   Special Education School No Other PK 12.0 2020   k_12_total 146.0 32.0 34.0 1.0   20.0     17.0   72.0                             397 146 32 34 1   20     17   72                       397
1731889 AK     school 200180 5   Anchorage Schools 20018000121 57140 Whaley School   Special Education School No Other PK 12.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
1731890 AK     school 200180 5   Anchorage Schools 20018000121 57140 Whaley School   Special Education School No Other PK 12.0 2020   pk_12_total 146.0 32.0 36.0 1.0   20.0     17.0   76.0                             411 146 32 36 1   20     17   76                       411
1731891 AK     school 200180 5   Anchorage Schools 20018000121 57140 Whaley School   Special Education School No Other PK 12.0 2020   pre_kindergarten 0.0 0.0 2.0 0.0   0.0     0.0   4.0                             14 0 0 2 0   0     0   4                       14
1733412 AK     school 200600 16   Fairbanks North Star Borough Schools 20060000766 169070 Discovery Peak Charter School   Special Education School Yes Elementary KG 8.0 2020   grade_1 14.0 1.0 2.0 0.0             3.0                             21 14 1 2 0             3                       21
1733413 AK     school 200600 16   Fairbanks North Star Borough Schools 20060000766 169070 Discovery Peak Charter School   Special Education School Yes Elementary KG 8.0 2020   grade_10 0.0 0.0 0.0 0.0             0.0                             0 0 0 0 0             0                       0
1733414 AK     school 200600 16   Fairbanks North Star Borough Schools 20060000766 169070 Discovery Peak Charter School   Special Education School Yes Elementary KG 8.0 2020   grade_11 0.0 0.0 0.0 0.0             0.0                             0 0 0 0 0             0                       0
1733415 AK     school 200600 16   Fairbanks North Star Borough Schools 20060000766 169070 Discovery Peak Charter School   Special Education School Yes Elementary KG 8.0 2020   grade_12 0.0 0.0 0.0 0.0             0.0                             0 0 0 0 0             0                       0
1733416 AK     school 200600 16   Fairbanks North Star Borough Schools 20060000766 169070 Discovery Peak Charter School   Special Education School Yes Elementary KG 8.0 2020   grade_2 17.0 0.0 1.0 0.0             3.0                             22 17 0 1 0             3                       22
1733417 AK     school 200600 16   Fairbanks North Star Borough Schools 20060000766 169070 Discovery Peak Charter School   Special Education School Yes Elementary KG 8.0 2020   grade_3 17.0 0.0 2.0 0.0             3.0                             23 17 0 2 0             3                       23
1733418 AK     school 200600 16   Fairbanks North Star Borough Schools 20060000766 169070 Discovery Peak Charter School   Special Education School Yes Elementary KG 8.0 2020   grade_4 18.0 1.0 2.0 0.0             1.0                             22 18 1 2 0             1                       22
1733419 AK     school 200600 16   Fairbanks North Star Borough Schools 20060000766 169070 Discovery Peak Charter School   Special Education School Yes Elementary KG 8.0 2020   grade_5 15.0 1.0 2.0 0.0             4.0                             22 15 1 2 0             4                       22
1733420 AK     school 200600 16   Fairbanks North Star Borough Schools 20060000766 169070 Discovery Peak Charter School   Special Education School Yes Elementary KG 8.0 2020   grade_6 19.0 0.0 1.0 0.0             2.0                             22 19 0 1 0             2                       22
1733421 AK     school 200600 16   Fairbanks North Star Borough Schools 20060000766 169070 Discovery Peak Charter School   Special Education School Yes Elementary KG 8.0 2020   grade_7 18.0 1.0 1.0 2.0             0.0                             22 18 1 1 2             0                       22
1733422 AK     school 200600 16   Fairbanks North Star Borough Schools 20060000766 169070 Discovery Peak Charter School   Special Education School Yes Elementary KG 8.0 2020   grade_8 11.0 0.0 0.0 0.0             2.0                             13 11 0 0 0             2                       13
1733423 AK     school 200600 16   Fairbanks North Star Borough Schools 20060000766 169070 Discovery Peak Charter School   Special Education School Yes Elementary KG 8.0 2020   grade_9 0.0 0.0 0.0 0.0             0.0                             0 0 0 0 0             0                       0
1733424 AK     school 200600 16   Fairbanks North Star Borough Schools 20060000766 169070 Discovery Peak Charter School   Special Education School Yes Elementary KG 8.0 2020   k_12_total 146.0 4.0 13.0 2.0             20.0                             189 146 4 13 2             20                       189
1733425 AK     school 200600 16   Fairbanks North Star Borough Schools 20060000766 169070 Discovery Peak Charter School   Special Education School Yes Elementary KG 8.0 2020   kindergarten 17.0 0.0 2.0 0.0             2.0                             22 17 0 2 0             2                       22
1733426 AK     school 200600 16   Fairbanks North Star Borough Schools 20060000766 169070 Discovery Peak Charter School   Special Education School Yes Elementary KG 8.0 2020   pk_12_total 146.0 4.0 13.0 2.0             20.0                             189 146 4 13 2             20                       189
1733427 AK     school 200600 16   Fairbanks North Star Borough Schools 20060000766 169070 Discovery Peak Charter School   Special Education School Yes Elementary KG 8.0 2020   pre_kindergarten 0.0 0.0 0.0 0.0             0.0                             0 0 0 0 0             0                       0
1736580 AK     school 200510 33   Mat-Su Borough Schools 20051000734 337060 Mat-Su Day School   Special Education School No Other KG 12.0 2020   grade_1 0.0   0.0 0.0   0.0         0.0                             0 0   0 0   0         0                       0
1736581 AK     school 200510 33   Mat-Su Borough Schools 20051000734 337060 Mat-Su Day School   Special Education School No Other KG 12.0 2020   grade_10 6.0   0.0 1.0   1.0         0.0                             8 6   0 1   1         0                       8
1736582 AK     school 200510 33   Mat-Su Borough Schools 20051000734 337060 Mat-Su Day School   Special Education School No Other KG 12.0 2020   grade_11 1.0   1.0 0.0   0.0         0.0                             3 1   1 0   0         0                       3
1736583 AK     school 200510 33   Mat-Su Borough Schools 20051000734 337060 Mat-Su Day School   Special Education School No Other KG 12.0 2020   grade_12 20.0   5.0 0.0   0.0         1.0                             28 20   5 0   0         1                       28
1736584 AK     school 200510 33   Mat-Su Borough Schools 20051000734 337060 Mat-Su Day School   Special Education School No Other KG 12.0 2020   grade_2 0.0   0.0 0.0   0.0         0.0                             0 0   0 0   0         0                       0
1736585 AK     school 200510 33   Mat-Su Borough Schools 20051000734 337060 Mat-Su Day School   Special Education School No Other KG 12.0 2020   grade_3 3.0   0.0 0.0   0.0         0.0                             3 3   0 0   0         0                       3
1736586 AK     school 200510 33   Mat-Su Borough Schools 20051000734 337060 Mat-Su Day School   Special Education School No Other KG 12.0 2020   grade_4 1.0   1.0 0.0   0.0         0.0                             4 1   1 0   0         0                       4
1736587 AK     school 200510 33   Mat-Su Borough Schools 20051000734 337060 Mat-Su Day School   Special Education School No Other KG 12.0 2020   grade_5 0.0   0.0 0.0   0.0         0.0                             0 0   0 0   0         0                       0
1736588 AK     school 200510 33   Mat-Su Borough Schools 20051000734 337060 Mat-Su Day School   Special Education School No Other KG 12.0 2020   grade_6 2.0   0.0 0.0   0.0         1.0                             3 2   0 0   0         1                       3
1736589 AK     school 200510 33   Mat-Su Borough Schools 20051000734 337060 Mat-Su Day School   Special Education School No Other KG 12.0 2020   grade_7 3.0   1.0 0.0   0.0         0.0                             5 3   1 0   0         0                       5
1736590 AK     school 200510 33   Mat-Su Borough Schools 20051000734 337060 Mat-Su Day School   Special Education School No Other KG 12.0 2020   grade_8 6.0   1.0 1.0   0.0         0.0                             9 6   1 1   0         0                       9
1736591 AK     school 200510 33   Mat-Su Borough Schools 20051000734 337060 Mat-Su Day School   Special Education School No Other KG 12.0 2020   grade_9 5.0   1.0 0.0   0.0         1.0                             8 5   1 0   0         1                       8
1736592 AK     school 200510 33   Mat-Su Borough Schools 20051000734 337060 Mat-Su Day School   Special Education School No Other KG 12.0 2020   k_12_total 47.0   10.0 2.0   1.0         3.0                             71 47   10 2   1         3                       71
1736593 AK     school 200510 33   Mat-Su Borough Schools 20051000734 337060 Mat-Su Day School   Special Education School No Other KG 12.0 2020   kindergarten 0.0   0.0 0.0   0.0         0.0                             0 0   0 0   0         0                       0
1736594 AK     school 200510 33   Mat-Su Borough Schools 20051000734 337060 Mat-Su Day School   Special Education School No Other KG 12.0 2020   pk_12_total 47.0   10.0 2.0   1.0         3.0                             71 47   10 2   1         3                       71
1736595 AK     school 200510 33   Mat-Su Borough Schools 20051000734 337060 Mat-Su Day School   Special Education School No Other KG 12.0 2020   pre_kindergarten 0.0   0.0 0.0   0.0         0.0                             0 0   0 0   0         0                       0
1814115 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   grade_1 2.0 1.0 0.0     0.0         0.0                             3.0 2 1 0     0         0                       3
1814116 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   grade_10 0.0 0.0 0.0     0.0         0.0                             0.0 0 0 0     0         0                       0
1814117 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   grade_11 0.0 0.0 1.0     1.0         0.0                             3.0 0 0 1     1         0                       3
1814118 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   grade_12 0.0 0.0 0.0     0.0         0.0                             1.0 0 0 0     0         0                       1
1814119 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   grade_2 0.0 0.0 0.0     0.0         1.0                             1.0 0 0 0     0         1                       1
1814120 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   grade_3 0.0 0.0 0.0     0.0         0.0                             0.0 0 0 0     0         0                       0
1814121 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   grade_4 2.0 1.0 0.0     0.0         0.0                             4.0 2 1 0     0         0                       4
1814122 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   grade_5 2.0 0.0 1.0     0.0         0.0                             3.0 2 0 1     0         0                       3
1814123 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   grade_6 1.0 0.0 0.0     0.0         0.0                             2.0 1 0 0     0         0                       2
1814124 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   grade_7 1.0 1.0 0.0     0.0         0.0                             2.0 1 1 0     0         0                       2
1814125 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   grade_8 1.0 0.0 1.0     0.0         0.0                             2.0 1 0 1     0         0                       2
1814126 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   grade_9 0.0 0.0 0.0     0.0         1.0                             1.0 0 0 0     0         1                       1
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
1814128 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   kindergarten 0.0 0.0 0.0     0.0         0.0                             0.0 0 0 0     0         0                       0
1814129 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   pk_12_total 9.0 3.0 3.0     1.0         2.0                             22.0 9 3 3     1         2                       22
1814130 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   pre_kindergarten 0.0 0.0 0.0     0.0         0.0                             0.0 0 0 0     0         0                       0
1814195 AK     school 200180 5   Anchorage Schools 20018000121 57140 Whaley School   Special Education School No Other PK 12 2021   grade_1 0.0 0.0 0.0     0.0     0.0   0.0                             0.0 0 0 0     0     0   0                       0
1814196 AK     school 200180 5   Anchorage Schools 20018000121 57140 Whaley School   Special Education School No Other PK 12 2021   grade_10 9.0 2.0 7.0     0.0     2.0   6.0                             40.0 9 2 7     0     2   6                       40
1814197 AK     school 200180 5   Anchorage Schools 20018000121 57140 Whaley School   Special Education School No Other PK 12 2021   grade_11 13.0 0.0 2.0     0.0     4.0   7.0                             31.0 13 0 2     0     4   7                       31
1814198 AK     school 200180 5   Anchorage Schools 20018000121 57140 Whaley School   Special Education School No Other PK 12 2021   grade_12 69.0 17.0 21.0     19.0     8.0   40.0                             200.0 69 17 21     19     8   40                       200
1814199 AK     school 200180 5   Anchorage Schools 20018000121 57140 Whaley School   Special Education School No Other PK 12 2021   grade_2 0.0 0.0 0.0     0.0     0.0   0.0                             0.0 0 0 0     0     0   0                       0
1814200 AK     school 200180 5   Anchorage Schools 20018000121 57140 Whaley School   Special Education School No Other PK 12 2021   grade_3 1.0 0.0 0.0     0.0     0.0   1.0                             2.0 1 0 0     0     0   1                       2
1814201 AK     school 200180 5   Anchorage Schools 20018000121 57140 Whaley School   Special Education School No Other PK 12 2021   grade_4 0.0 0.0 0.0     0.0     0.0   2.0                             3.0 0 0 0     0     0   2                       3
1814202 AK     school 200180 5   Anchorage Schools 20018000121 57140 Whaley School   Special Education School No Other PK 12 2021   grade_5 1.0 0.0 0.0     0.0     0.0   1.0                             5.0 1 0 0     0     0   1                       5
1814203 AK     school 200180 5   Anchorage Schools 20018000121 57140 Whaley School   Special Education School No Other PK 12 2021   grade_6 4.0 0.0 1.0     0.0     0.0   2.0                             10.0 4 0 1     0     0   2                       10
1814204 AK     school 200180 5   Anchorage Schools 20018000121 57140 Whaley School   Special Education School No Other PK 12 2021   grade_7 3.0 2.0 1.0     1.0     1.0   8.0                             21.0 3 2 1     1     1   8                       21
1814205 AK     school 200180 5   Anchorage Schools 20018000121 57140 Whaley School   Special Education School No Other PK 12 2021   grade_8 14.0 2.0 0.0     1.0     3.0   4.0                             28.0 14 2 0     1     3   4                       28
1814206 AK     school 200180 5   Anchorage Schools 20018000121 57140 Whaley School   Special Education School No Other PK 12 2021   grade_9 9.0 2.0 4.0     1.0     0.0   6.0                             31.0 9 2 4     1     0   6                       31
1814207 AK     school 200180 5   Anchorage Schools 20018000121 57140 Whaley School   Special Education School No Other PK 12 2021   k_12_total 123.0 25.0 36.0     22.0     18.0   77.0                             371.0 123 25 36     22     18   77                       371
1814208 AK     school 200180 5   Anchorage Schools 20018000121 57140 Whaley School   Special Education School No Other PK 12 2021   kindergarten 0.0 0.0 0.0     0.0     0.0   0.0                             0.0 0 0 0     0     0   0                       0
1814209 AK     school 200180 5   Anchorage Schools 20018000121 57140 Whaley School   Special Education School No Other PK 12 2021   pk_12_total 125.0 26.0 38.0     24.0     21.0   79.0                             390.0 125 26 38     24     21   79                       390
1814210 AK     school 200180 5   Anchorage Schools 20018000121 57140 Whaley School   Special Education School No Other PK 12 2021   pre_kindergarten 2.0 1.0 2.0     2.0     3.0   2.0                             19.0 2 1 2     2     3   2                       19
1815683 AK     school 200600 16   Fairbanks North Star Borough Schools 20060000761 169060 Boreal Sun Charter School   Special Education School Yes Elementary KG 8 2021   grade_1 19.0   1.0     1.0         2.0                             24.0 19   1     1         2                       24
1815684 AK     school 200600 16   Fairbanks North Star Borough Schools 20060000761 169060 Boreal Sun Charter School   Special Education School Yes Elementary KG 8 2021   grade_10 0.0   0.0     0.0         0.0                             0.0 0   0     0         0                       0
1815685 AK     school 200600 16   Fairbanks North Star Borough Schools 20060000761 169060 Boreal Sun Charter School   Special Education School Yes Elementary KG 8 2021   grade_11 0.0   0.0     0.0         0.0                             0.0 0   0     0         0                       0
1815686 AK     school 200600 16   Fairbanks North Star Borough Schools 20060000761 169060 Boreal Sun Charter School   Special Education School Yes Elementary KG 8 2021   grade_12 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]);