Data source: Big Local News · About: Big Local

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

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
1733064 AK     school 200600 16   Fairbanks North Star Borough Schools 20060000651 160240 North Pole Elementary   Regular School No Elementary PK 5.0 2020   grade_2 31.0 0.0 8.0 0.0   0.0     0.0   12.0                             53 31 0 8 0   0     0   12                       53
1733065 AK     school 200600 16   Fairbanks North Star Borough Schools 20060000651 160240 North Pole Elementary   Regular School No Elementary PK 5.0 2020   grade_3 35.0 3.0 2.0 0.0   0.0     0.0   10.0                             53 35 3 2 0   0     0   10                       53
1733067 AK     school 200600 16   Fairbanks North Star Borough Schools 20060000651 160240 North Pole Elementary   Regular School No Elementary PK 5.0 2020   grade_5 46.0 2.0 5.0 0.0   0.0     0.0   13.0                             67 46 2 5 0   0     0   13                       67
1733068 AK     school 200600 16   Fairbanks North Star Borough Schools 20060000651 160240 North Pole Elementary   Regular School No Elementary PK 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
1733069 AK     school 200600 16   Fairbanks North Star Borough Schools 20060000651 160240 North Pole Elementary   Regular School No Elementary PK 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
1733070 AK     school 200600 16   Fairbanks North Star Borough Schools 20060000651 160240 North Pole Elementary   Regular School No Elementary PK 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
1733071 AK     school 200600 16   Fairbanks North Star Borough Schools 20060000651 160240 North Pole Elementary   Regular School No Elementary PK 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
1733075 AK     school 200600 16   Fairbanks North Star Borough Schools 20060000651 160240 North Pole Elementary   Regular School No Elementary PK 5.0 2020   pre_kindergarten 14.0 1.0 2.0 0.0   0.0     0.0   3.0                             22 14 1 2 0   0     0   3                       22
1733076 AK     school 200600 16   Fairbanks North Star Borough Schools 20060000652 160250 North Pole Middle School   Regular School No Middle 06 8.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
1733077 AK     school 200600 16   Fairbanks North Star Borough Schools 20060000652 160250 North Pole Middle School   Regular School No Middle 06 8.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
1733078 AK     school 200600 16   Fairbanks North Star Borough Schools 20060000652 160250 North Pole Middle School   Regular School No Middle 06 8.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
1733079 AK     school 200600 16   Fairbanks North Star Borough Schools 20060000652 160250 North Pole Middle School   Regular School No Middle 06 8.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
1733080 AK     school 200600 16   Fairbanks North Star Borough Schools 20060000652 160250 North Pole Middle School   Regular School No Middle 06 8.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
1733081 AK     school 200600 16   Fairbanks North Star Borough Schools 20060000652 160250 North Pole Middle School   Regular School No Middle 06 8.0 2020   grade_3 0.0 0.0 0.0 0.0   0.0     0.0   0.0                             0 0 0 0 0   0     0   0                       0
1733082 AK     school 200600 16   Fairbanks North Star Borough Schools 20060000652 160250 North Pole Middle School   Regular School No Middle 06 8.0 2020   grade_4 0.0 0.0 0.0 0.0   0.0     0.0   0.0                             0 0 0 0 0   0     0   0                       0
1733083 AK     school 200600 16   Fairbanks North Star Borough Schools 20060000652 160250 North Pole Middle School   Regular School No Middle 06 8.0 2020   grade_5 0.0 0.0 0.0 0.0   0.0     0.0   0.0                             0 0 0 0 0   0     0   0                       0
1733087 AK     school 200600 16   Fairbanks North Star Borough Schools 20060000652 160250 North Pole Middle School   Regular School No Middle 06 8.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
1733089 AK     school 200600 16   Fairbanks North Star Borough Schools 20060000652 160250 North Pole Middle School   Regular School No Middle 06 8.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
1733091 AK     school 200600 16   Fairbanks North Star Borough Schools 20060000652 160250 North Pole Middle School   Regular School No Middle 06 8.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
1733092 AK     school 200600 16   Fairbanks North Star Borough Schools 20060000275 160260 Ryan Middle School   Regular School No Middle 07 8.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
1733093 AK     school 200600 16   Fairbanks North Star Borough Schools 20060000275 160260 Ryan Middle School   Regular School No Middle 07 8.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
1733094 AK     school 200600 16   Fairbanks North Star Borough Schools 20060000275 160260 Ryan Middle School   Regular School No Middle 07 8.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
1733095 AK     school 200600 16   Fairbanks North Star Borough Schools 20060000275 160260 Ryan Middle School   Regular School No Middle 07 8.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
1733096 AK     school 200600 16   Fairbanks North Star Borough Schools 20060000275 160260 Ryan Middle School   Regular School No Middle 07 8.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
1733097 AK     school 200600 16   Fairbanks North Star Borough Schools 20060000275 160260 Ryan Middle School   Regular School No Middle 07 8.0 2020   grade_3 0.0 0.0 0.0 0.0   0.0     0.0   0.0                             0 0 0 0 0   0     0   0                       0
1733098 AK     school 200600 16   Fairbanks North Star Borough Schools 20060000275 160260 Ryan Middle School   Regular School No Middle 07 8.0 2020   grade_4 0.0 0.0 0.0 0.0   0.0     0.0   0.0                             0 0 0 0 0   0     0   0                       0
1733099 AK     school 200600 16   Fairbanks North Star Borough Schools 20060000275 160260 Ryan Middle School   Regular School No Middle 07 8.0 2020   grade_5 0.0 0.0 0.0 0.0   0.0     0.0   0.0                             0 0 0 0 0   0     0   0                       0
1733100 AK     school 200600 16   Fairbanks North Star Borough Schools 20060000275 160260 Ryan Middle School   Regular School No Middle 07 8.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
1733103 AK     school 200600 16   Fairbanks North Star Borough Schools 20060000275 160260 Ryan Middle School   Regular School No Middle 07 8.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
1733105 AK     school 200600 16   Fairbanks North Star Borough Schools 20060000275 160260 Ryan Middle School   Regular School No Middle 07 8.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
1733107 AK     school 200600 16   Fairbanks North Star Borough Schools 20060000275 160260 Ryan Middle School   Regular School No Middle 07 8.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
1733124 AK     school 200600 16   Fairbanks North Star Borough Schools 20060000279 160280 Two Rivers School   Regular School No Elementary PK 8.0 2020   grade_1 8.0   1.0     0.0         1.0                             10 8   1     0         1                       10
1733125 AK     school 200600 16   Fairbanks North Star Borough Schools 20060000279 160280 Two Rivers School   Regular School No Elementary PK 8.0 2020   grade_10 0.0   0.0     0.0         0.0                             0 0   0     0         0                       0
1733126 AK     school 200600 16   Fairbanks North Star Borough Schools 20060000279 160280 Two Rivers School   Regular School No Elementary PK 8.0 2020   grade_11 0.0   0.0     0.0         0.0                             0 0   0     0         0                       0
1733127 AK     school 200600 16   Fairbanks North Star Borough Schools 20060000279 160280 Two Rivers School   Regular School No Elementary PK 8.0 2020   grade_12 0.0   0.0     0.0         0.0                             0 0   0     0         0                       0
1733128 AK     school 200600 16   Fairbanks North Star Borough Schools 20060000279 160280 Two Rivers School   Regular School No Elementary PK 8.0 2020   grade_2 3.0   0.0     0.0         2.0                             5 3   0     0         2                       5
1733129 AK     school 200600 16   Fairbanks North Star Borough Schools 20060000279 160280 Two Rivers School   Regular School No Elementary PK 8.0 2020   grade_3 3.0   1.0     0.0         1.0                             5 3   1     0         1                       5
1733130 AK     school 200600 16   Fairbanks North Star Borough Schools 20060000279 160280 Two Rivers School   Regular School No Elementary PK 8.0 2020   grade_4 13.0   0.0     0.0         2.0                             15 13   0     0         2                       15
1733131 AK     school 200600 16   Fairbanks North Star Borough Schools 20060000279 160280 Two Rivers School   Regular School No Elementary PK 8.0 2020   grade_5 4.0   0.0     0.0         2.0                             7 4   0     0         2                       7
1733132 AK     school 200600 16   Fairbanks North Star Borough Schools 20060000279 160280 Two Rivers School   Regular School No Elementary PK 8.0 2020   grade_6 9.0   0.0     0.0         2.0                             11 9   0     0         2                       11
1733133 AK     school 200600 16   Fairbanks North Star Borough Schools 20060000279 160280 Two Rivers School   Regular School No Elementary PK 8.0 2020   grade_7 3.0   1.0     0.0         3.0                             7 3   1     0         3                       7
1733135 AK     school 200600 16   Fairbanks North Star Borough Schools 20060000279 160280 Two Rivers School   Regular School No Elementary PK 8.0 2020   grade_9 0.0   0.0     0.0         0.0                             0 0   0     0         0                       0
1733137 AK     school 200600 16   Fairbanks North Star Borough Schools 20060000279 160280 Two Rivers School   Regular School No Elementary PK 8.0 2020   kindergarten 8.0   0.0     0.0         0.0                             8 8   0     0         0                       8
1733139 AK     school 200600 16   Fairbanks North Star Borough Schools 20060000279 160280 Two Rivers School   Regular School No Elementary PK 8.0 2020   pre_kindergarten 1.0   0.0     0.0         0.0                             1 1   0     0         0                       1
1733141 AK     school 200600 16   Fairbanks North Star Borough Schools 20060000045 160290 University Park Elementary   Regular School No Elementary PK 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
1733142 AK     school 200600 16   Fairbanks North Star Borough Schools 20060000045 160290 University Park Elementary   Regular School No Elementary PK 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
1733143 AK     school 200600 16   Fairbanks North Star Borough Schools 20060000045 160290 University Park Elementary   Regular School No Elementary PK 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
1733144 AK     school 200600 16   Fairbanks North Star Borough Schools 20060000045 160290 University Park Elementary   Regular School No Elementary PK 6.0 2020   grade_2 21.0 1.0 4.0 0.0   0.0         25.0                             54 21 1 4 0   0         25                       54
1733145 AK     school 200600 16   Fairbanks North Star Borough Schools 20060000045 160290 University Park Elementary   Regular School No Elementary PK 6.0 2020   grade_3 34.0 0.0 8.0 0.0   0.0         17.0                             62 34 0 8 0   0         17                       62
1733148 AK     school 200600 16   Fairbanks North Star Borough Schools 20060000045 160290 University Park Elementary   Regular School No Elementary PK 6.0 2020   grade_6 43.0 2.0 4.0 1.0   0.0         17.0                             76 43 2 4 1   0         17                       76
1733149 AK     school 200600 16   Fairbanks North Star Borough Schools 20060000045 160290 University Park Elementary   Regular School No Elementary PK 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
1733150 AK     school 200600 16   Fairbanks North Star Borough Schools 20060000045 160290 University Park Elementary   Regular School No Elementary PK 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
1733151 AK     school 200600 16   Fairbanks North Star Borough Schools 20060000045 160290 University Park Elementary   Regular School No Elementary PK 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
1733155 AK     school 200600 16   Fairbanks North Star Borough Schools 20060000045 160290 University Park Elementary   Regular School No Elementary PK 6.0 2020   pre_kindergarten 7.0 2.0 1.0 0.0   0.0         1.0                             15 7 2 1 0   0         1                       15
1733157 AK     school 200600 16   Fairbanks North Star Borough Schools 20060000280 160300 Woodriver Elementary   Regular School No Elementary PK 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
1733158 AK     school 200600 16   Fairbanks North Star Borough Schools 20060000280 160300 Woodriver Elementary   Regular School No Elementary PK 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
1733159 AK     school 200600 16   Fairbanks North Star Borough Schools 20060000280 160300 Woodriver Elementary   Regular School No Elementary PK 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
1733165 AK     school 200600 16   Fairbanks North Star Borough Schools 20060000280 160300 Woodriver Elementary   Regular School No Elementary PK 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
1733166 AK     school 200600 16   Fairbanks North Star Borough Schools 20060000280 160300 Woodriver Elementary   Regular School No Elementary PK 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
1733167 AK     school 200600 16   Fairbanks North Star Borough Schools 20060000280 160300 Woodriver Elementary   Regular School No Elementary PK 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
1733169 AK     school 200600 16   Fairbanks North Star Borough Schools 20060000280 160300 Woodriver Elementary   Regular School No Elementary PK 6.0 2020   kindergarten 41.0 2.0 3.0 1.0   0.0     0.0   9.0                             64 41 2 3 1   0     0   9                       64
1733171 AK     school 200600 16   Fairbanks North Star Borough Schools 20060000280 160300 Woodriver Elementary   Regular School No Elementary PK 6.0 2020   pre_kindergarten 3.0 0.0 0.0 0.0   0.0     0.0   1.0                             5 3 0 0 0   0     0   1                       5
1733172 AK     school 200600 16   Fairbanks North Star Borough Schools 20060000600 160340 Ticasuk Brown Elementary   Regular School No Elementary PK 5.0 2020   grade_1 29.0 3.0 5.0 1.0   0.0     1.0   13.0                             54 29 3 5 1   0     1   13                       54
1733173 AK     school 200600 16   Fairbanks North Star Borough Schools 20060000600 160340 Ticasuk Brown Elementary   Regular School No Elementary PK 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
1733174 AK     school 200600 16   Fairbanks North Star Borough Schools 20060000600 160340 Ticasuk Brown Elementary   Regular School No Elementary PK 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
1733175 AK     school 200600 16   Fairbanks North Star Borough Schools 20060000600 160340 Ticasuk Brown Elementary   Regular School No Elementary PK 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
1733176 AK     school 200600 16   Fairbanks North Star Borough Schools 20060000600 160340 Ticasuk Brown Elementary   Regular School No Elementary PK 5.0 2020   grade_2 44.0 0.0 8.0 0.0   0.0     0.0   12.0                             65 44 0 8 0   0     0   12                       65
1733178 AK     school 200600 16   Fairbanks North Star Borough Schools 20060000600 160340 Ticasuk Brown Elementary   Regular School No Elementary PK 5.0 2020   grade_4 40.0 1.0 2.0 2.0   0.0     1.0   12.0                             67 40 1 2 2   0     1   12                       67
1733180 AK     school 200600 16   Fairbanks North Star Borough Schools 20060000600 160340 Ticasuk Brown Elementary   Regular School No Elementary PK 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
1733181 AK     school 200600 16   Fairbanks North Star Borough Schools 20060000600 160340 Ticasuk Brown Elementary   Regular School No Elementary PK 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
1733182 AK     school 200600 16   Fairbanks North Star Borough Schools 20060000600 160340 Ticasuk Brown Elementary   Regular School No Elementary PK 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
1733183 AK     school 200600 16   Fairbanks North Star Borough Schools 20060000600 160340 Ticasuk Brown Elementary   Regular School No Elementary PK 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
1733185 AK     school 200600 16   Fairbanks North Star Borough Schools 20060000600 160340 Ticasuk Brown Elementary   Regular School No Elementary PK 5.0 2020   kindergarten 41.0 2.0 5.0 0.0   0.0     0.0   18.0                             74 41 2 5 0   0     0   18                       74
1733187 AK     school 200600 16   Fairbanks North Star Borough Schools 20060000600 160340 Ticasuk Brown Elementary   Regular School No Elementary PK 5.0 2020   pre_kindergarten 12.0 0.0 1.0 0.0   0.0     0.0   5.0                             19 12 0 1 0   0     0   5                       19
1733189 AK     school 200600 16   Fairbanks North Star Borough Schools 20060000002 160350 Ladd Elementary   Regular School No Elementary PK 8.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
1733190 AK     school 200600 16   Fairbanks North Star Borough Schools 20060000002 160350 Ladd Elementary   Regular School No Elementary PK 8.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
1733191 AK     school 200600 16   Fairbanks North Star Borough Schools 20060000002 160350 Ladd Elementary   Regular School No Elementary PK 8.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
1733197 AK     school 200600 16   Fairbanks North Star Borough Schools 20060000002 160350 Ladd Elementary   Regular School No Elementary PK 8.0 2020   grade_7 6.0 1.0 0.0 0.0   0.0     0.0   1.0                             9 6 1 0 0   0     0   1                       9
1733198 AK     school 200600 16   Fairbanks North Star Borough Schools 20060000002 160350 Ladd Elementary   Regular School No Elementary PK 8.0 2020   grade_8 1.0 0.0 2.0 1.0   0.0     1.0   0.0                             5 1 0 2 1   0     1   0                       5
1733199 AK     school 200600 16   Fairbanks North Star Borough Schools 20060000002 160350 Ladd Elementary   Regular School No Elementary PK 8.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
1733203 AK     school 200600 16   Fairbanks North Star Borough Schools 20060000002 160350 Ladd Elementary   Regular School No Elementary PK 8.0 2020   pre_kindergarten 8.0 1.0 1.0 0.0   0.0     0.0   1.0                             11 8 1 1 0   0     0   1                       11
1733205 AK     school 200600 16   Fairbanks North Star Borough Schools 20060000055 160360 Arctic Light Elementary   Regular School No Elementary PK 8.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
1733206 AK     school 200600 16   Fairbanks North Star Borough Schools 20060000055 160360 Arctic Light Elementary   Regular School No Elementary PK 8.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
1733207 AK     school 200600 16   Fairbanks North Star Borough Schools 20060000055 160360 Arctic Light Elementary   Regular School No Elementary PK 8.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
1733208 AK     school 200600 16   Fairbanks North Star Borough Schools 20060000055 160360 Arctic Light Elementary   Regular School No Elementary PK 8.0 2020   grade_2 32.0 7.0 12.0 0.0   0.0     1.0   6.0                             58 32 7 12 0   0     1   6                       58
1733210 AK     school 200600 16   Fairbanks North Star Borough Schools 20060000055 160360 Arctic Light Elementary   Regular School No Elementary PK 8.0 2020   grade_4 19.0 8.0 14.0 0.0   0.0     1.0   5.0                             47 19 8 14 0   0     1   5                       47
1733212 AK     school 200600 16   Fairbanks North Star Borough Schools 20060000055 160360 Arctic Light Elementary   Regular School No Elementary PK 8.0 2020   grade_6 12.0 8.0 6.0 1.0   0.0     1.0   5.0                             33 12 8 6 1   0     1   5                       33
1733213 AK     school 200600 16   Fairbanks North Star Borough Schools 20060000055 160360 Arctic Light Elementary   Regular School No Elementary PK 8.0 2020   grade_7 8.0 4.0 3.0 0.0   0.0     1.0   3.0                             19 8 4 3 0   0     1   3                       19
1733214 AK     school 200600 16   Fairbanks North Star Borough Schools 20060000055 160360 Arctic Light Elementary   Regular School No Elementary PK 8.0 2020   grade_8 2.0 1.0 2.0 0.0   0.0     0.0   2.0                             8 2 1 2 0   0     0   2                       8
1733215 AK     school 200600 16   Fairbanks North Star Borough Schools 20060000055 160360 Arctic Light Elementary   Regular School No Elementary PK 8.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
1733217 AK     school 200600 16   Fairbanks North Star Borough Schools 20060000055 160360 Arctic Light Elementary   Regular School No Elementary PK 8.0 2020   kindergarten 30.0 8.0 21.0 0.0   0.0     0.0   7.0                             68 30 8 21 0   0     0   7                       68
1733219 AK     school 200600 16   Fairbanks North Star Borough Schools 20060000055 160360 Arctic Light Elementary   Regular School No Elementary PK 8.0 2020   pre_kindergarten 6.0 2.0 5.0 0.0   0.0     0.0   3.0                             16 6 2 5 0   0     0   3                       16
1733220 AK     school 200600 16   Fairbanks North Star Borough Schools 20060000114 160380 Anne Wien Elementary   Regular School No Elementary PK 6.0 2020   grade_1 29.0 3.0 8.0 0.0   0.0         10.0                             66 29 3 8 0   0         10                       66
1733221 AK     school 200600 16   Fairbanks North Star Borough Schools 20060000114 160380 Anne Wien Elementary   Regular School No Elementary PK 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
1733222 AK     school 200600 16   Fairbanks North Star Borough Schools 20060000114 160380 Anne Wien Elementary   Regular School No Elementary PK 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
1733223 AK     school 200600 16   Fairbanks North Star Borough Schools 20060000114 160380 Anne Wien Elementary   Regular School No Elementary PK 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
1733224 AK     school 200600 16   Fairbanks North Star Borough Schools 20060000114 160380 Anne Wien Elementary   Regular School No Elementary PK 6.0 2020   grade_2 24.0 3.0 3.0 0.0   0.0         6.0                             42 24 3 3 0   0         6                       42
1733227 AK     school 200600 16   Fairbanks North Star Borough Schools 20060000114 160380 Anne Wien Elementary   Regular School No Elementary PK 6.0 2020   grade_5 13.0 4.0 12.0 1.0   0.0         18.0                             59 13 4 12 1   0         18                       59
1733229 AK     school 200600 16   Fairbanks North Star Borough Schools 20060000114 160380 Anne Wien Elementary   Regular School No Elementary PK 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
1733230 AK     school 200600 16   Fairbanks North Star Borough Schools 20060000114 160380 Anne Wien Elementary   Regular School No Elementary PK 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

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