schools

Data source: Big Local News · About: Big Local

Custom SQL query returning 101 rows (hide)

Query parameters

rowidstatecountycounty_state_idadmin_leveldistrict_nces_iddistrict_state_iddistrict_state_typedistrictschool_nces_idschool_state_idschoolschool_state_typeccd_school_typeccd_charter_schoolccd_school_lvlccd_school_low_gradeccd_school_high_gradeyeartermgradewhiteblackhispanicnative_americannative_american_alaskan_nativeasiannative_hawaiianasian_pacific_islandernative_hawaiian_pacific_islanderpacific_islandermultiracialunknown_racemalefemalenon_binaryunknown_genderellell_percenthomelesshomeless_percentlow_incomefree_and_reducedfree_and_reduced_percentdisabilitysection_504totalwhite_intblack_inthispanic_intnative_american_intnative_american_alaskan_native_intasian_intnative_hawaiian_intasian_pacific_islander_intnative_hawaiian_pacific_islander_intpacific_islander_intmultiracial_intunknown_race_intmale_intfemale_intnon_binary_intunknown_gender_intell_inthomeless_intlow_income_intfree_and_reduced_intdisability_intsection_504_inttotal_int
1730408 AK     school 200050 3   Alaska Gateway Schools 20005000027 30040 Walter Northway School   Regular School No Other PK 12.0 2020   grade_2                     0.0                             2                     0                       2
1730409 AK     school 200050 3   Alaska Gateway Schools 20005000027 30040 Walter Northway School   Regular School No Other PK 12.0 2020   grade_3                     0.0                             5                     0                       5
1730410 AK     school 200050 3   Alaska Gateway Schools 20005000027 30040 Walter Northway School   Regular School No Other PK 12.0 2020   grade_4                     0.0                             4                     0                       4
1730411 AK     school 200050 3   Alaska Gateway Schools 20005000027 30040 Walter Northway School   Regular School No Other PK 12.0 2020   grade_5                     1.0                             4                     1                       4
1730412 AK     school 200050 3   Alaska Gateway Schools 20005000027 30040 Walter Northway School   Regular School No Other PK 12.0 2020   grade_6                     0.0                             7                     0                       7
1730413 AK     school 200050 3   Alaska Gateway Schools 20005000027 30040 Walter Northway School   Regular School No Other PK 12.0 2020   grade_7                     0.0                             5                     0                       5
1730414 AK     school 200050 3   Alaska Gateway Schools 20005000027 30040 Walter Northway School   Regular School No Other PK 12.0 2020   grade_8                     0.0                             3                     0                       3
1730415 AK     school 200050 3   Alaska Gateway Schools 20005000027 30040 Walter Northway School   Regular School No Other PK 12.0 2020   grade_9                     1.0                             6                     1                       6
1730416 AK     school 200050 3   Alaska Gateway Schools 20005000027 30040 Walter Northway School   Regular School No Other PK 12.0 2020   k_12_total                     2.0                             49                     2                       49
1730417 AK     school 200050 3   Alaska Gateway Schools 20005000027 30040 Walter Northway School   Regular School No Other PK 12.0 2020   kindergarten                     0.0                             3                     0                       3
1730418 AK     school 200050 3   Alaska Gateway Schools 20005000027 30040 Walter Northway School   Regular School No Other PK 12.0 2020   pk_12_total                     2.0                             49                     2                       49
1730419 AK     school 200050 3   Alaska Gateway Schools 20005000027 30040 Walter Northway School   Regular School No Other PK 12.0 2020   pre_kindergarten                     0.0                             0                     0                       0
1730420 AK     school 200050 3   Alaska Gateway Schools 20005000424 30050 Tanacross School   Regular School No Elementary PK 8.0 2020   grade_1   0.0                 0.0                             0   0                 0                       0
1730421 AK     school 200050 3   Alaska Gateway Schools 20005000424 30050 Tanacross School   Regular School No Elementary PK 8.0 2020   grade_10   0.0                 0.0                             0   0                 0                       0
1730422 AK     school 200050 3   Alaska Gateway Schools 20005000424 30050 Tanacross School   Regular School No Elementary PK 8.0 2020   grade_11   0.0                 0.0                             0   0                 0                       0
1730423 AK     school 200050 3   Alaska Gateway Schools 20005000424 30050 Tanacross School   Regular School No Elementary PK 8.0 2020   grade_12   0.0                 0.0                             0   0                 0                       0
1730424 AK     school 200050 3   Alaska Gateway Schools 20005000424 30050 Tanacross School   Regular School No Elementary PK 8.0 2020   grade_2   0.0                 0.0                             2   0                 0                       2
1730425 AK     school 200050 3   Alaska Gateway Schools 20005000424 30050 Tanacross School   Regular School No Elementary PK 8.0 2020   grade_3   1.0                 0.0                             2   1                 0                       2
1730426 AK     school 200050 3   Alaska Gateway Schools 20005000424 30050 Tanacross School   Regular School No Elementary PK 8.0 2020   grade_4   0.0                 0.0                             1   0                 0                       1
1730427 AK     school 200050 3   Alaska Gateway Schools 20005000424 30050 Tanacross School   Regular School No Elementary PK 8.0 2020   grade_5   0.0                 0.0                             1   0                 0                       1
1730428 AK     school 200050 3   Alaska Gateway Schools 20005000424 30050 Tanacross School   Regular School No Elementary PK 8.0 2020   grade_6   0.0                 1.0                             3   0                 1                       3
1730429 AK     school 200050 3   Alaska Gateway Schools 20005000424 30050 Tanacross School   Regular School No Elementary PK 8.0 2020   grade_7   0.0                 0.0                             0   0                 0                       0
1730430 AK     school 200050 3   Alaska Gateway Schools 20005000424 30050 Tanacross School   Regular School No Elementary PK 8.0 2020   grade_8   0.0                 0.0                             0   0                 0                       0
1730431 AK     school 200050 3   Alaska Gateway Schools 20005000424 30050 Tanacross School   Regular School No Elementary PK 8.0 2020   grade_9   0.0                 0.0                             0   0                 0                       0
1730432 AK     school 200050 3   Alaska Gateway Schools 20005000424 30050 Tanacross School   Regular School No Elementary PK 8.0 2020   k_12_total   1.0                 1.0                             10   1                 1                       10
1730433 AK     school 200050 3   Alaska Gateway Schools 20005000424 30050 Tanacross School   Regular School No Elementary PK 8.0 2020   kindergarten   0.0                 0.0                             1   0                 0                       1
1730434 AK     school 200050 3   Alaska Gateway Schools 20005000424 30050 Tanacross School   Regular School No Elementary PK 8.0 2020   pk_12_total   1.0                 1.0                             12   1                 1                       12
1730435 AK     school 200050 3   Alaska Gateway Schools 20005000424 30050 Tanacross School   Regular School No Elementary PK 8.0 2020   pre_kindergarten   0.0                 0.0                             2   0                 0                       2
1730452 AK     school 200050 3   Alaska Gateway Schools 20005000528 30070 Tetlin School   Regular School No Other PK 12.0 2020   grade_1 0.0                                                 4 0                                           4
1730453 AK     school 200050 3   Alaska Gateway Schools 20005000528 30070 Tetlin School   Regular School No Other PK 12.0 2020   grade_10 0.0                                                 4 0                                           4
1730454 AK     school 200050 3   Alaska Gateway Schools 20005000528 30070 Tetlin School   Regular School No Other PK 12.0 2020   grade_11 0.0                                                 2 0                                           2
1730455 AK     school 200050 3   Alaska Gateway Schools 20005000528 30070 Tetlin School   Regular School No Other PK 12.0 2020   grade_12 0.0                                                 1 0                                           1
1730456 AK     school 200050 3   Alaska Gateway Schools 20005000528 30070 Tetlin School   Regular School No Other PK 12.0 2020   grade_2 0.0                                                 2 0                                           2
1730457 AK     school 200050 3   Alaska Gateway Schools 20005000528 30070 Tetlin School   Regular School No Other PK 12.0 2020   grade_3 0.0                                                 3 0                                           3
1730458 AK     school 200050 3   Alaska Gateway Schools 20005000528 30070 Tetlin School   Regular School No Other PK 12.0 2020   grade_4 0.0                                                 4 0                                           4
1730459 AK     school 200050 3   Alaska Gateway Schools 20005000528 30070 Tetlin School   Regular School No Other PK 12.0 2020   grade_5 0.0                                                 3 0                                           3
1730460 AK     school 200050 3   Alaska Gateway Schools 20005000528 30070 Tetlin School   Regular School No Other PK 12.0 2020   grade_6 0.0                                                 4 0                                           4
1730461 AK     school 200050 3   Alaska Gateway Schools 20005000528 30070 Tetlin School   Regular School No Other PK 12.0 2020   grade_7 0.0                                                 2 0                                           2
1730462 AK     school 200050 3   Alaska Gateway Schools 20005000528 30070 Tetlin School   Regular School No Other PK 12.0 2020   grade_8 0.0                                                 3 0                                           3
1730463 AK     school 200050 3   Alaska Gateway Schools 20005000528 30070 Tetlin School   Regular School No Other PK 12.0 2020   grade_9 1.0                                                 2 1                                           2
1730464 AK     school 200050 3   Alaska Gateway Schools 20005000528 30070 Tetlin School   Regular School No Other PK 12.0 2020   k_12_total 1.0                                                 38 1                                           38
1730465 AK     school 200050 3   Alaska Gateway Schools 20005000528 30070 Tetlin School   Regular School No Other PK 12.0 2020   kindergarten 0.0                                                 4 0                                           4
1730466 AK     school 200050 3   Alaska Gateway Schools 20005000528 30070 Tetlin School   Regular School No Other PK 12.0 2020   pk_12_total 1.0                                                 38 1                                           38
1730467 AK     school 200050 3   Alaska Gateway Schools 20005000528 30070 Tetlin School   Regular School No Other PK 12.0 2020   pre_kindergarten 0.0                                                 0 0                                           0
1730484 AK     school 200010 4   Aleutian Region Schools 20001000005 40020 Yakov E. Netsvetov School   Regular School No Other KG 12.0 2020   grade_1                                                   0                                             0
1730485 AK     school 200010 4   Aleutian Region Schools 20001000005 40020 Yakov E. Netsvetov School   Regular School No Other KG 12.0 2020   grade_10                                                   0                                             0
1730486 AK     school 200010 4   Aleutian Region Schools 20001000005 40020 Yakov E. Netsvetov School   Regular School No Other KG 12.0 2020   grade_11                                                   1                                             1
1730487 AK     school 200010 4   Aleutian Region Schools 20001000005 40020 Yakov E. Netsvetov School   Regular School No Other KG 12.0 2020   grade_12                                                   1                                             1
1730488 AK     school 200010 4   Aleutian Region Schools 20001000005 40020 Yakov E. Netsvetov School   Regular School No Other KG 12.0 2020   grade_2                                                   1                                             1
1730489 AK     school 200010 4   Aleutian Region Schools 20001000005 40020 Yakov E. Netsvetov School   Regular School No Other KG 12.0 2020   grade_3                                                   1                                             1
1730490 AK     school 200010 4   Aleutian Region Schools 20001000005 40020 Yakov E. Netsvetov School   Regular School No Other KG 12.0 2020   grade_4                                                   0                                             0
1730491 AK     school 200010 4   Aleutian Region Schools 20001000005 40020 Yakov E. Netsvetov School   Regular School No Other KG 12.0 2020   grade_5                                                   2                                             2
1730492 AK     school 200010 4   Aleutian Region Schools 20001000005 40020 Yakov E. Netsvetov School   Regular School No Other KG 12.0 2020   grade_6                                                   0                                             0
1730493 AK     school 200010 4   Aleutian Region Schools 20001000005 40020 Yakov E. Netsvetov School   Regular School No Other KG 12.0 2020   grade_7                                                   2                                             2
1730494 AK     school 200010 4   Aleutian Region Schools 20001000005 40020 Yakov E. Netsvetov School   Regular School No Other KG 12.0 2020   grade_8                                                   0                                             0
1730495 AK     school 200010 4   Aleutian Region Schools 20001000005 40020 Yakov E. Netsvetov School   Regular School No Other KG 12.0 2020   grade_9                                                   1                                             1
1730496 AK     school 200010 4   Aleutian Region Schools 20001000005 40020 Yakov E. Netsvetov School   Regular School No Other KG 12.0 2020   k_12_total                                                   10                                             10
1730497 AK     school 200010 4   Aleutian Region Schools 20001000005 40020 Yakov E. Netsvetov School   Regular School No Other KG 12.0 2020   kindergarten                                                   1                                             1
1730498 AK     school 200010 4   Aleutian Region Schools 20001000005 40020 Yakov E. Netsvetov School   Regular School No Other KG 12.0 2020   pk_12_total                                                   10                                             10
1730499 AK     school 200010 4   Aleutian Region Schools 20001000005 40020 Yakov E. Netsvetov School   Regular School No Other KG 12.0 2020   pre_kindergarten                                                   0                                             0
1731988 AK     school 200180 5   Anchorage Schools 20018000460 59080 Eagle Academy Charter School   Regular School Yes Elementary KG 6.0 2020   grade_1 18.0 2.0 0.0 1.0             4.0                             25 18 2 0 1             4                       25
1731989 AK     school 200180 5   Anchorage Schools 20018000460 59080 Eagle Academy Charter School   Regular School Yes Elementary KG 6.0 2020   grade_10 0.0 0.0 0.0 0.0             0.0                             0 0 0 0 0             0                       0
1731990 AK     school 200180 5   Anchorage Schools 20018000460 59080 Eagle Academy Charter School   Regular School Yes Elementary KG 6.0 2020   grade_11 0.0 0.0 0.0 0.0             0.0                             0 0 0 0 0             0                       0
1731991 AK     school 200180 5   Anchorage Schools 20018000460 59080 Eagle Academy Charter School   Regular School Yes Elementary KG 6.0 2020   grade_12 0.0 0.0 0.0 0.0             0.0                             0 0 0 0 0             0                       0
1731992 AK     school 200180 5   Anchorage Schools 20018000460 59080 Eagle Academy Charter School   Regular School Yes Elementary KG 6.0 2020   grade_2 21.0 1.0 2.0 0.0             2.0                             26 21 1 2 0             2                       26
1731993 AK     school 200180 5   Anchorage Schools 20018000460 59080 Eagle Academy Charter School   Regular School Yes Elementary KG 6.0 2020   grade_3 19.0 0.0 3.0 1.0             2.0                             26 19 0 3 1             2                       26
1731994 AK     school 200180 5   Anchorage Schools 20018000460 59080 Eagle Academy Charter School   Regular School Yes Elementary KG 6.0 2020   grade_4 20.0 0.0 0.0 0.0             5.0                             26 20 0 0 0             5                       26
1731995 AK     school 200180 5   Anchorage Schools 20018000460 59080 Eagle Academy Charter School   Regular School Yes Elementary KG 6.0 2020   grade_5 21.0 2.0 0.0 0.0             3.0                             26 21 2 0 0             3                       26
1731996 AK     school 200180 5   Anchorage Schools 20018000460 59080 Eagle Academy Charter School   Regular School Yes Elementary KG 6.0 2020   grade_6 15.0 0.0 4.0 0.0             2.0                             22 15 0 4 0             2                       22
1731997 AK     school 200180 5   Anchorage Schools 20018000460 59080 Eagle Academy Charter School   Regular School Yes Elementary KG 6.0 2020   grade_7 0.0 0.0 0.0 0.0             0.0                             0 0 0 0 0             0                       0
1731998 AK     school 200180 5   Anchorage Schools 20018000460 59080 Eagle Academy Charter School   Regular School Yes Elementary KG 6.0 2020   grade_8 0.0 0.0 0.0 0.0             0.0                             0 0 0 0 0             0                       0
1731999 AK     school 200180 5   Anchorage Schools 20018000460 59080 Eagle Academy Charter School   Regular School Yes Elementary KG 6.0 2020   grade_9 0.0 0.0 0.0 0.0             0.0                             0 0 0 0 0             0                       0
1732000 AK     school 200180 5   Anchorage Schools 20018000460 59080 Eagle Academy Charter School   Regular School Yes Elementary KG 6.0 2020   k_12_total 133.0 7.0 10.0 3.0             20.0                             176 133 7 10 3             20                       176
1732001 AK     school 200180 5   Anchorage Schools 20018000460 59080 Eagle Academy Charter School   Regular School Yes Elementary KG 6.0 2020   kindergarten 19.0 2.0 1.0 1.0             2.0                             25 19 2 1 1             2                       25
1732002 AK     school 200180 5   Anchorage Schools 20018000460 59080 Eagle Academy Charter School   Regular School Yes Elementary KG 6.0 2020   pk_12_total 133.0 7.0 10.0 3.0             20.0                             176 133 7 10 3             20                       176
1732003 AK     school 200180 5   Anchorage Schools 20018000460 59080 Eagle Academy Charter School   Regular School Yes Elementary KG 6.0 2020   pre_kindergarten 0.0 0.0 0.0 0.0             0.0                             0 0 0 0 0             0                       0
1732068 AK     school 200525 6   Annette Island Schools 20052500111 60020 Charles R. Leask Sr. Middle School   Regular School No Middle 06 8.0 2020   grade_1 0.0     0.0             0.0                             0 0     0             0                       0
1732069 AK     school 200525 6   Annette Island Schools 20052500111 60020 Charles R. Leask Sr. Middle School   Regular School No Middle 06 8.0 2020   grade_10 0.0     0.0             0.0                             0 0     0             0                       0
1732070 AK     school 200525 6   Annette Island Schools 20052500111 60020 Charles R. Leask Sr. Middle School   Regular School No Middle 06 8.0 2020   grade_11 0.0     0.0             0.0                             0 0     0             0                       0
1732071 AK     school 200525 6   Annette Island Schools 20052500111 60020 Charles R. Leask Sr. Middle School   Regular School No Middle 06 8.0 2020   grade_12 0.0     0.0             0.0                             0 0     0             0                       0
1732072 AK     school 200525 6   Annette Island Schools 20052500111 60020 Charles R. Leask Sr. Middle School   Regular School No Middle 06 8.0 2020   grade_2 0.0     0.0             0.0                             0 0     0             0                       0
1732073 AK     school 200525 6   Annette Island Schools 20052500111 60020 Charles R. Leask Sr. Middle School   Regular School No Middle 06 8.0 2020   grade_3 0.0     0.0             0.0                             0 0     0             0                       0
1732074 AK     school 200525 6   Annette Island Schools 20052500111 60020 Charles R. Leask Sr. Middle School   Regular School No Middle 06 8.0 2020   grade_4 0.0     0.0             0.0                             0 0     0             0                       0
1732075 AK     school 200525 6   Annette Island Schools 20052500111 60020 Charles R. Leask Sr. Middle School   Regular School No Middle 06 8.0 2020   grade_5 0.0     0.0             0.0                             0 0     0             0                       0
1732076 AK     school 200525 6   Annette Island Schools 20052500111 60020 Charles R. Leask Sr. Middle School   Regular School No Middle 06 8.0 2020   grade_6 2.0     0.0             0.0                             33 2     0             0                       33
1732077 AK     school 200525 6   Annette Island Schools 20052500111 60020 Charles R. Leask Sr. Middle School   Regular School No Middle 06 8.0 2020   grade_7 2.0     1.0             2.0                             28 2     1             2                       28
1732078 AK     school 200525 6   Annette Island Schools 20052500111 60020 Charles R. Leask Sr. Middle School   Regular School No Middle 06 8.0 2020   grade_8 1.0     0.0             3.0                             21 1     0             3                       21
1732079 AK     school 200525 6   Annette Island Schools 20052500111 60020 Charles R. Leask Sr. Middle School   Regular School No Middle 06 8.0 2020   grade_9 0.0     0.0             0.0                             0 0     0             0                       0
1732080 AK     school 200525 6   Annette Island Schools 20052500111 60020 Charles R. Leask Sr. Middle School   Regular School No Middle 06 8.0 2020   k_12_total 5.0     1.0             5.0                             82 5     1             5                       82
1732081 AK     school 200525 6   Annette Island Schools 20052500111 60020 Charles R. Leask Sr. Middle School   Regular School No Middle 06 8.0 2020   kindergarten 0.0     0.0             0.0                             0 0     0             0                       0
1732082 AK     school 200525 6   Annette Island Schools 20052500111 60020 Charles R. Leask Sr. Middle School   Regular School No Middle 06 8.0 2020   pk_12_total 5.0     1.0             5.0                             82 5     1             5                       82
1732083 AK     school 200525 6   Annette Island Schools 20052500111 60020 Charles R. Leask Sr. Middle School   Regular School No Middle 06 8.0 2020   pre_kindergarten 0.0     0.0             0.0                             0 0     0             0                       0
1732084 AK     school 200525 6   Annette Island Schools 20052500250 60030 Richard Johnson Elementary   Regular School No Elementary PK 5.0 2020   grade_1 0.0                                                 17 0                                           17
1732085 AK     school 200525 6   Annette Island Schools 20052500250 60030 Richard Johnson Elementary   Regular School No Elementary PK 5.0 2020   grade_10 0.0                                                 0 0                                           0
1732086 AK     school 200525 6   Annette Island Schools 20052500250 60030 Richard Johnson Elementary   Regular School No Elementary PK 5.0 2020   grade_11 0.0                                                 0 0                                           0
1732087 AK     school 200525 6   Annette Island Schools 20052500250 60030 Richard Johnson Elementary   Regular School No Elementary PK 5.0 2020   grade_12 0.0                                                 0 0                                           0
1732088 AK     school 200525 6   Annette Island Schools 20052500250 60030 Richard Johnson Elementary   Regular School No Elementary PK 5.0 2020   grade_2 2.0                                                 28 2                                           28
1732089 AK     school 200525 6   Annette Island Schools 20052500250 60030 Richard Johnson Elementary   Regular School No Elementary PK 5.0 2020   grade_3 0.0                                                 28 0                                           28
1732090 AK     school 200525 6   Annette Island Schools 20052500250 60030 Richard Johnson Elementary   Regular School No Elementary PK 5.0 2020   grade_4 1.0                                                 25 1                                           25
1732091 AK     school 200525 6   Annette Island Schools 20052500250 60030 Richard Johnson Elementary   Regular School No Elementary PK 5.0 2020   grade_5 1.0                                                 24 1                                           24
1732092 AK     school 200525 6   Annette Island Schools 20052500250 60030 Richard Johnson Elementary   Regular School No Elementary PK 5.0 2020   grade_6 0.0                                                 0 0                                           0