Data source: Big Local News · About: Big Local

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

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
1735448 AK     school 200001 31   Lower Kuskokwim Schools 20000100392 310090 Eek School   Regular School No Other PK 12.0 2020   grade_2                                                   13                                             13
1735449 AK     school 200001 31   Lower Kuskokwim Schools 20000100392 310090 Eek School   Regular School No Other PK 12.0 2020   grade_3                                                   9                                             9
1735450 AK     school 200001 31   Lower Kuskokwim Schools 20000100392 310090 Eek School   Regular School No Other PK 12.0 2020   grade_4                                                   8                                             8
1735451 AK     school 200001 31   Lower Kuskokwim Schools 20000100392 310090 Eek School   Regular School No Other PK 12.0 2020   grade_5                                                   10                                             10
1735452 AK     school 200001 31   Lower Kuskokwim Schools 20000100392 310090 Eek School   Regular School No Other PK 12.0 2020   grade_6                                                   9                                             9
1735453 AK     school 200001 31   Lower Kuskokwim Schools 20000100392 310090 Eek School   Regular School No Other PK 12.0 2020   grade_7                                                   6                                             6
1735454 AK     school 200001 31   Lower Kuskokwim Schools 20000100392 310090 Eek School   Regular School No Other PK 12.0 2020   grade_8                                                   8                                             8
1735455 AK     school 200001 31   Lower Kuskokwim Schools 20000100392 310090 Eek School   Regular School No Other PK 12.0 2020   grade_9                                                   14                                             14
1735456 AK     school 200001 31   Lower Kuskokwim Schools 20000100392 310090 Eek School   Regular School No Other PK 12.0 2020   k_12_total                                                   113                                             113
1735457 AK     school 200001 31   Lower Kuskokwim Schools 20000100392 310090 Eek School   Regular School No Other PK 12.0 2020   kindergarten                                                   7                                             7
1735458 AK     school 200001 31   Lower Kuskokwim Schools 20000100392 310090 Eek School   Regular School No Other PK 12.0 2020   pk_12_total                                                   124                                             124
1735459 AK     school 200001 31   Lower Kuskokwim Schools 20000100392 310090 Eek School   Regular School No Other PK 12.0 2020   pre_kindergarten                                                   11                                             11
1735460 AK     school 200001 31   Lower Kuskokwim Schools 20000100476 310100 Rocky Mountain School   Regular School No Other PK 12.0 2020   grade_1                                                   7                                             7
1735461 AK     school 200001 31   Lower Kuskokwim Schools 20000100476 310100 Rocky Mountain School   Regular School No Other PK 12.0 2020   grade_10                                                   2                                             2
1735462 AK     school 200001 31   Lower Kuskokwim Schools 20000100476 310100 Rocky Mountain School   Regular School No Other PK 12.0 2020   grade_11                                                   1                                             1
1735463 AK     school 200001 31   Lower Kuskokwim Schools 20000100476 310100 Rocky Mountain School   Regular School No Other PK 12.0 2020   grade_12                                                   2                                             2
1735464 AK     school 200001 31   Lower Kuskokwim Schools 20000100476 310100 Rocky Mountain School   Regular School No Other PK 12.0 2020   grade_2                                                   6                                             6
1735465 AK     school 200001 31   Lower Kuskokwim Schools 20000100476 310100 Rocky Mountain School   Regular School No Other PK 12.0 2020   grade_3                                                   8                                             8
1735466 AK     school 200001 31   Lower Kuskokwim Schools 20000100476 310100 Rocky Mountain School   Regular School No Other PK 12.0 2020   grade_4                                                   5                                             5
1735467 AK     school 200001 31   Lower Kuskokwim Schools 20000100476 310100 Rocky Mountain School   Regular School No Other PK 12.0 2020   grade_5                                                   6                                             6
1735468 AK     school 200001 31   Lower Kuskokwim Schools 20000100476 310100 Rocky Mountain School   Regular School No Other PK 12.0 2020   grade_6                                                   6                                             6
1735469 AK     school 200001 31   Lower Kuskokwim Schools 20000100476 310100 Rocky Mountain School   Regular School No Other PK 12.0 2020   grade_7                                                   8                                             8
1735470 AK     school 200001 31   Lower Kuskokwim Schools 20000100476 310100 Rocky Mountain School   Regular School No Other PK 12.0 2020   grade_8                                                   1                                             1
1735471 AK     school 200001 31   Lower Kuskokwim Schools 20000100476 310100 Rocky Mountain School   Regular School No Other PK 12.0 2020   grade_9                                                   7                                             7
1735472 AK     school 200001 31   Lower Kuskokwim Schools 20000100476 310100 Rocky Mountain School   Regular School No Other PK 12.0 2020   k_12_total                                                   72                                             72
1735473 AK     school 200001 31   Lower Kuskokwim Schools 20000100476 310100 Rocky Mountain School   Regular School No Other PK 12.0 2020   kindergarten                                                   13                                             13
1735474 AK     school 200001 31   Lower Kuskokwim Schools 20000100476 310100 Rocky Mountain School   Regular School No Other PK 12.0 2020   pk_12_total                                                   73                                             73
1735475 AK     school 200001 31   Lower Kuskokwim Schools 20000100476 310100 Rocky Mountain School   Regular School No Other PK 12.0 2020   pre_kindergarten                                                   1                                             1
1735476 AK     school 200001 31   Lower Kuskokwim Schools 20000100391 310110 Akula Elitnaurvik School   Regular School No Other PK 12.0 2020   grade_1 0.0                                                 8 0                                           8
1735477 AK     school 200001 31   Lower Kuskokwim Schools 20000100391 310110 Akula Elitnaurvik School   Regular School No Other PK 12.0 2020   grade_10 0.0                                                 9 0                                           9
1735478 AK     school 200001 31   Lower Kuskokwim Schools 20000100391 310110 Akula Elitnaurvik School   Regular School No Other PK 12.0 2020   grade_11 0.0                                                 7 0                                           7
1735479 AK     school 200001 31   Lower Kuskokwim Schools 20000100391 310110 Akula Elitnaurvik School   Regular School No Other PK 12.0 2020   grade_12 0.0                                                 8 0                                           8
1735480 AK     school 200001 31   Lower Kuskokwim Schools 20000100391 310110 Akula Elitnaurvik School   Regular School No Other PK 12.0 2020   grade_2 0.0                                                 11 0                                           11
1735481 AK     school 200001 31   Lower Kuskokwim Schools 20000100391 310110 Akula Elitnaurvik School   Regular School No Other PK 12.0 2020   grade_3 0.0                                                 8 0                                           8
1735482 AK     school 200001 31   Lower Kuskokwim Schools 20000100391 310110 Akula Elitnaurvik School   Regular School No Other PK 12.0 2020   grade_4 0.0                                                 4 0                                           4
1735483 AK     school 200001 31   Lower Kuskokwim Schools 20000100391 310110 Akula Elitnaurvik School   Regular School No Other PK 12.0 2020   grade_5 0.0                                                 8 0                                           8
1735484 AK     school 200001 31   Lower Kuskokwim Schools 20000100391 310110 Akula Elitnaurvik School   Regular School No Other PK 12.0 2020   grade_6 0.0                                                 8 0                                           8
1735485 AK     school 200001 31   Lower Kuskokwim Schools 20000100391 310110 Akula Elitnaurvik School   Regular School No Other PK 12.0 2020   grade_7 0.0                                                 9 0                                           9
1735486 AK     school 200001 31   Lower Kuskokwim Schools 20000100391 310110 Akula Elitnaurvik School   Regular School No Other PK 12.0 2020   grade_8 1.0                                                 7 1                                           7
1735487 AK     school 200001 31   Lower Kuskokwim Schools 20000100391 310110 Akula Elitnaurvik School   Regular School No Other PK 12.0 2020   grade_9 0.0                                                 7 0                                           7
1735488 AK     school 200001 31   Lower Kuskokwim Schools 20000100391 310110 Akula Elitnaurvik School   Regular School No Other PK 12.0 2020   k_12_total 1.0                                                 103 1                                           103
1735489 AK     school 200001 31   Lower Kuskokwim Schools 20000100391 310110 Akula Elitnaurvik School   Regular School No Other PK 12.0 2020   kindergarten 0.0                                                 9 0                                           9
1735490 AK     school 200001 31   Lower Kuskokwim Schools 20000100391 310110 Akula Elitnaurvik School   Regular School No Other PK 12.0 2020   pk_12_total 1.0                                                 111 1                                           111
1735491 AK     school 200001 31   Lower Kuskokwim Schools 20000100391 310110 Akula Elitnaurvik School   Regular School No Other PK 12.0 2020   pre_kindergarten 0.0                                                 8 0                                           8
1735492 AK     school 200001 31   Lower Kuskokwim Schools 20000100210 310120 Chief Paul Memorial School   Regular School No Other PK 12.0 2020   grade_1                                                   14                                             14
1735493 AK     school 200001 31   Lower Kuskokwim Schools 20000100210 310120 Chief Paul Memorial School   Regular School No Other PK 12.0 2020   grade_10                                                   11                                             11
1735494 AK     school 200001 31   Lower Kuskokwim Schools 20000100210 310120 Chief Paul Memorial School   Regular School No Other PK 12.0 2020   grade_11                                                   16                                             16
1735495 AK     school 200001 31   Lower Kuskokwim Schools 20000100210 310120 Chief Paul Memorial School   Regular School No Other PK 12.0 2020   grade_12                                                   17                                             17
1735496 AK     school 200001 31   Lower Kuskokwim Schools 20000100210 310120 Chief Paul Memorial School   Regular School No Other PK 12.0 2020   grade_2                                                   15                                             15
1735497 AK     school 200001 31   Lower Kuskokwim Schools 20000100210 310120 Chief Paul Memorial School   Regular School No Other PK 12.0 2020   grade_3                                                   15                                             15
1735498 AK     school 200001 31   Lower Kuskokwim Schools 20000100210 310120 Chief Paul Memorial School   Regular School No Other PK 12.0 2020   grade_4                                                   9                                             9
1735499 AK     school 200001 31   Lower Kuskokwim Schools 20000100210 310120 Chief Paul Memorial School   Regular School No Other PK 12.0 2020   grade_5                                                   24                                             24
1735500 AK     school 200001 31   Lower Kuskokwim Schools 20000100210 310120 Chief Paul Memorial School   Regular School No Other PK 12.0 2020   grade_6                                                   11                                             11
1735501 AK     school 200001 31   Lower Kuskokwim Schools 20000100210 310120 Chief Paul Memorial School   Regular School No Other PK 12.0 2020   grade_7                                                   16                                             16
1735502 AK     school 200001 31   Lower Kuskokwim Schools 20000100210 310120 Chief Paul Memorial School   Regular School No Other PK 12.0 2020   grade_8                                                   21                                             21
1735503 AK     school 200001 31   Lower Kuskokwim Schools 20000100210 310120 Chief Paul Memorial School   Regular School No Other PK 12.0 2020   grade_9                                                   16                                             16
1735504 AK     school 200001 31   Lower Kuskokwim Schools 20000100210 310120 Chief Paul Memorial School   Regular School No Other PK 12.0 2020   k_12_total                                                   205                                             205
1735505 AK     school 200001 31   Lower Kuskokwim Schools 20000100210 310120 Chief Paul Memorial School   Regular School No Other PK 12.0 2020   kindergarten                                                   20                                             20
1735506 AK     school 200001 31   Lower Kuskokwim Schools 20000100210 310120 Chief Paul Memorial School   Regular School No Other PK 12.0 2020   pk_12_total                                                   205                                             205
1735507 AK     school 200001 31   Lower Kuskokwim Schools 20000100210 310120 Chief Paul Memorial School   Regular School No Other PK 12.0 2020   pre_kindergarten                                                   0                                             0
1735508 AK     school 200001 31   Lower Kuskokwim Schools 20000100211 310130 Ayagina'ar Elitnaurvik   Regular School No Other PK 12.0 2020   grade_1                                                   8                                             8
1735509 AK     school 200001 31   Lower Kuskokwim Schools 20000100211 310130 Ayagina'ar Elitnaurvik   Regular School No Other PK 12.0 2020   grade_10                                                   21                                             21
1735510 AK     school 200001 31   Lower Kuskokwim Schools 20000100211 310130 Ayagina'ar Elitnaurvik   Regular School No Other PK 12.0 2020   grade_11                                                   12                                             12
1735511 AK     school 200001 31   Lower Kuskokwim Schools 20000100211 310130 Ayagina'ar Elitnaurvik   Regular School No Other PK 12.0 2020   grade_12                                                   6                                             6
1735512 AK     school 200001 31   Lower Kuskokwim Schools 20000100211 310130 Ayagina'ar Elitnaurvik   Regular School No Other PK 12.0 2020   grade_2                                                   10                                             10
1735513 AK     school 200001 31   Lower Kuskokwim Schools 20000100211 310130 Ayagina'ar Elitnaurvik   Regular School No Other PK 12.0 2020   grade_3                                                   11                                             11
1735514 AK     school 200001 31   Lower Kuskokwim Schools 20000100211 310130 Ayagina'ar Elitnaurvik   Regular School No Other PK 12.0 2020   grade_4                                                   11                                             11
1735515 AK     school 200001 31   Lower Kuskokwim Schools 20000100211 310130 Ayagina'ar Elitnaurvik   Regular School No Other PK 12.0 2020   grade_5                                                   16                                             16
1735516 AK     school 200001 31   Lower Kuskokwim Schools 20000100211 310130 Ayagina'ar Elitnaurvik   Regular School No Other PK 12.0 2020   grade_6                                                   13                                             13
1735517 AK     school 200001 31   Lower Kuskokwim Schools 20000100211 310130 Ayagina'ar Elitnaurvik   Regular School No Other PK 12.0 2020   grade_7                                                   10                                             10
1735518 AK     school 200001 31   Lower Kuskokwim Schools 20000100211 310130 Ayagina'ar Elitnaurvik   Regular School No Other PK 12.0 2020   grade_8                                                   14                                             14
1735519 AK     school 200001 31   Lower Kuskokwim Schools 20000100211 310130 Ayagina'ar Elitnaurvik   Regular School No Other PK 12.0 2020   grade_9                                                   12                                             12
1735520 AK     school 200001 31   Lower Kuskokwim Schools 20000100211 310130 Ayagina'ar Elitnaurvik   Regular School No Other PK 12.0 2020   k_12_total                                                   152                                             152
1735521 AK     school 200001 31   Lower Kuskokwim Schools 20000100211 310130 Ayagina'ar Elitnaurvik   Regular School No Other PK 12.0 2020   kindergarten                                                   8                                             8
1735522 AK     school 200001 31   Lower Kuskokwim Schools 20000100211 310130 Ayagina'ar Elitnaurvik   Regular School No Other PK 12.0 2020   pk_12_total                                                   163                                             163
1735523 AK     school 200001 31   Lower Kuskokwim Schools 20000100211 310130 Ayagina'ar Elitnaurvik   Regular School No Other PK 12.0 2020   pre_kindergarten                                                   11                                             11
1735524 AK     school 200001 31   Lower Kuskokwim Schools 20000100438 310140 Ket'acik/Aapalluk Memorial School   Regular School No Other PK 12.0 2020   grade_1                                                   22                                             22
1735525 AK     school 200001 31   Lower Kuskokwim Schools 20000100438 310140 Ket'acik/Aapalluk Memorial School   Regular School No Other PK 12.0 2020   grade_10                                                   17                                             17
1735526 AK     school 200001 31   Lower Kuskokwim Schools 20000100438 310140 Ket'acik/Aapalluk Memorial School   Regular School No Other PK 12.0 2020   grade_11                                                   12                                             12
1735527 AK     school 200001 31   Lower Kuskokwim Schools 20000100438 310140 Ket'acik/Aapalluk Memorial School   Regular School No Other PK 12.0 2020   grade_12                                                   5                                             5
1735528 AK     school 200001 31   Lower Kuskokwim Schools 20000100438 310140 Ket'acik/Aapalluk Memorial School   Regular School No Other PK 12.0 2020   grade_2                                                   16                                             16
1735529 AK     school 200001 31   Lower Kuskokwim Schools 20000100438 310140 Ket'acik/Aapalluk Memorial School   Regular School No Other PK 12.0 2020   grade_3                                                   24                                             24
1735530 AK     school 200001 31   Lower Kuskokwim Schools 20000100438 310140 Ket'acik/Aapalluk Memorial School   Regular School No Other PK 12.0 2020   grade_4                                                   16                                             16
1735531 AK     school 200001 31   Lower Kuskokwim Schools 20000100438 310140 Ket'acik/Aapalluk Memorial School   Regular School No Other PK 12.0 2020   grade_5                                                   14                                             14
1735532 AK     school 200001 31   Lower Kuskokwim Schools 20000100438 310140 Ket'acik/Aapalluk Memorial School   Regular School No Other PK 12.0 2020   grade_6                                                   15                                             15
1735533 AK     school 200001 31   Lower Kuskokwim Schools 20000100438 310140 Ket'acik/Aapalluk Memorial School   Regular School No Other PK 12.0 2020   grade_7                                                   20                                             20
1735534 AK     school 200001 31   Lower Kuskokwim Schools 20000100438 310140 Ket'acik/Aapalluk Memorial School   Regular School No Other PK 12.0 2020   grade_8                                                   23                                             23
1735535 AK     school 200001 31   Lower Kuskokwim Schools 20000100438 310140 Ket'acik/Aapalluk Memorial School   Regular School No Other PK 12.0 2020   grade_9                                                   28                                             28
1735536 AK     school 200001 31   Lower Kuskokwim Schools 20000100438 310140 Ket'acik/Aapalluk Memorial School   Regular School No Other PK 12.0 2020   k_12_total                                                   237                                             237
1735537 AK     school 200001 31   Lower Kuskokwim Schools 20000100438 310140 Ket'acik/Aapalluk Memorial School   Regular School No Other PK 12.0 2020   kindergarten                                                   25                                             25
1735538 AK     school 200001 31   Lower Kuskokwim Schools 20000100438 310140 Ket'acik/Aapalluk Memorial School   Regular School No Other PK 12.0 2020   pk_12_total                                                   254                                             254
1735539 AK     school 200001 31   Lower Kuskokwim Schools 20000100438 310140 Ket'acik/Aapalluk Memorial School   Regular School No Other PK 12.0 2020   pre_kindergarten                                                   17                                             17
1735540 AK     school 200001 31   Lower Kuskokwim Schools 20000100212 310150 Kwigillingok School   Regular School No Other PK 12.0 2020   grade_1                     0.0                             11                     0                       11
1735541 AK     school 200001 31   Lower Kuskokwim Schools 20000100212 310150 Kwigillingok School   Regular School No Other PK 12.0 2020   grade_10                     0.0                             7                     0                       7
1735542 AK     school 200001 31   Lower Kuskokwim Schools 20000100212 310150 Kwigillingok School   Regular School No Other PK 12.0 2020   grade_11                     0.0                             9                     0                       9
1735543 AK     school 200001 31   Lower Kuskokwim Schools 20000100212 310150 Kwigillingok School   Regular School No Other PK 12.0 2020   grade_12                     0.0                             9                     0                       9
1735544 AK     school 200001 31   Lower Kuskokwim Schools 20000100212 310150 Kwigillingok School   Regular School No Other PK 12.0 2020   grade_2                     0.0                             9                     0                       9
1735545 AK     school 200001 31   Lower Kuskokwim Schools 20000100212 310150 Kwigillingok School   Regular School No Other PK 12.0 2020   grade_3                     0.0                             7                     0                       7
1735546 AK     school 200001 31   Lower Kuskokwim Schools 20000100212 310150 Kwigillingok School   Regular School No Other PK 12.0 2020   grade_4                     0.0                             9                     0                       9
1735547 AK     school 200001 31   Lower Kuskokwim Schools 20000100212 310150 Kwigillingok School   Regular School No Other PK 12.0 2020   grade_5                     0.0                             8                     0                       8

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