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
1730292 AK     school 200770 2   Denali Borough Schools 20077000354 20010 Anderson School   Regular School No Other KG 12.0 2020   grade_1 1.0 0.0 0.0 0.0                                           1 1 0 0 0                                     1
1730293 AK     school 200770 2   Denali Borough Schools 20077000354 20010 Anderson School   Regular School No Other KG 12.0 2020   grade_10 1.0 0.0 0.0 1.0                                           2 1 0 0 1                                     2
1730294 AK     school 200770 2   Denali Borough Schools 20077000354 20010 Anderson School   Regular School No Other KG 12.0 2020   grade_11 2.0 0.0 1.0 0.0                                           3 2 0 1 0                                     3
1730295 AK     school 200770 2   Denali Borough Schools 20077000354 20010 Anderson School   Regular School No Other KG 12.0 2020   grade_12 2.0 1.0 0.0 0.0                                           3 2 1 0 0                                     3
1730296 AK     school 200770 2   Denali Borough Schools 20077000354 20010 Anderson School   Regular School No Other KG 12.0 2020   grade_2 2.0 0.0 0.0 0.0                                           2 2 0 0 0                                     2
1730297 AK     school 200770 2   Denali Borough Schools 20077000354 20010 Anderson School   Regular School No Other KG 12.0 2020   grade_3 0.0 0.0 0.0 0.0                                           0 0 0 0 0                                     0
1730298 AK     school 200770 2   Denali Borough Schools 20077000354 20010 Anderson School   Regular School No Other KG 12.0 2020   grade_4 2.0 0.0 0.0 0.0                                           2 2 0 0 0                                     2
1730299 AK     school 200770 2   Denali Borough Schools 20077000354 20010 Anderson School   Regular School No Other KG 12.0 2020   grade_5 2.0 0.0 0.0 0.0                                           2 2 0 0 0                                     2
1730300 AK     school 200770 2   Denali Borough Schools 20077000354 20010 Anderson School   Regular School No Other KG 12.0 2020   grade_6 4.0 0.0 0.0 0.0                                           4 4 0 0 0                                     4
1730301 AK     school 200770 2   Denali Borough Schools 20077000354 20010 Anderson School   Regular School No Other KG 12.0 2020   grade_7 3.0 0.0 0.0 1.0                                           4 3 0 0 1                                     4
1730302 AK     school 200770 2   Denali Borough Schools 20077000354 20010 Anderson School   Regular School No Other KG 12.0 2020   grade_8 3.0 0.0 0.0 0.0                                           3 3 0 0 0                                     3
1730303 AK     school 200770 2   Denali Borough Schools 20077000354 20010 Anderson School   Regular School No Other KG 12.0 2020   grade_9 2.0 0.0 0.0 0.0                                           2 2 0 0 0                                     2
1730304 AK     school 200770 2   Denali Borough Schools 20077000354 20010 Anderson School   Regular School No Other KG 12.0 2020   k_12_total 28.0 1.0 1.0 3.0                                           33 28 1 1 3                                     33
1730305 AK     school 200770 2   Denali Borough Schools 20077000354 20010 Anderson School   Regular School No Other KG 12.0 2020   kindergarten 4.0 0.0 0.0 1.0                                           5 4 0 0 1                                     5
1730306 AK     school 200770 2   Denali Borough Schools 20077000354 20010 Anderson School   Regular School No Other KG 12.0 2020   pk_12_total 28.0 1.0 1.0 3.0                                           33 28 1 1 3                                     33
1730307 AK     school 200770 2   Denali Borough Schools 20077000354 20010 Anderson School   Regular School No Other KG 12.0 2020   pre_kindergarten 0.0 0.0 0.0 0.0                                           0 0 0 0 0                                     0
1730308 AK     school 200770 2   Denali Borough Schools 20077000356 20030 Cantwell School   Regular School No Other KG 12.0 2020   grade_1 4.0                   0.0                             4 4                   0                       4
1730309 AK     school 200770 2   Denali Borough Schools 20077000356 20030 Cantwell School   Regular School No Other KG 12.0 2020   grade_10 0.0                   1.0                             1 0                   1                       1
1730310 AK     school 200770 2   Denali Borough Schools 20077000356 20030 Cantwell School   Regular School No Other KG 12.0 2020   grade_11 0.0                   0.0                             0 0                   0                       0
1730311 AK     school 200770 2   Denali Borough Schools 20077000356 20030 Cantwell School   Regular School No Other KG 12.0 2020   grade_12 1.0                   0.0                             1 1                   0                       1
1730312 AK     school 200770 2   Denali Borough Schools 20077000356 20030 Cantwell School   Regular School No Other KG 12.0 2020   grade_2 0.0                   0.0                             0 0                   0                       0
1730313 AK     school 200770 2   Denali Borough Schools 20077000356 20030 Cantwell School   Regular School No Other KG 12.0 2020   grade_3 0.0                   0.0                             0 0                   0                       0
1730314 AK     school 200770 2   Denali Borough Schools 20077000356 20030 Cantwell School   Regular School No Other KG 12.0 2020   grade_4 2.0                   0.0                             2 2                   0                       2
1730315 AK     school 200770 2   Denali Borough Schools 20077000356 20030 Cantwell School   Regular School No Other KG 12.0 2020   grade_5 0.0                   0.0                             0 0                   0                       0
1730316 AK     school 200770 2   Denali Borough Schools 20077000356 20030 Cantwell School   Regular School No Other KG 12.0 2020   grade_6 0.0                   0.0                             1 0                   0                       1
1730317 AK     school 200770 2   Denali Borough Schools 20077000356 20030 Cantwell School   Regular School No Other KG 12.0 2020   grade_7 0.0                   0.0                             0 0                   0                       0
1730318 AK     school 200770 2   Denali Borough Schools 20077000356 20030 Cantwell School   Regular School No Other KG 12.0 2020   grade_8 0.0                   0.0                             1 0                   0                       1
1730319 AK     school 200770 2   Denali Borough Schools 20077000356 20030 Cantwell School   Regular School No Other KG 12.0 2020   grade_9 0.0                   0.0                             0 0                   0                       0
1730320 AK     school 200770 2   Denali Borough Schools 20077000356 20030 Cantwell School   Regular School No Other KG 12.0 2020   k_12_total 7.0                   1.0                             10 7                   1                       10
1730321 AK     school 200770 2   Denali Borough Schools 20077000356 20030 Cantwell School   Regular School No Other KG 12.0 2020   kindergarten 0.0                   0.0                             0 0                   0                       0
1730322 AK     school 200770 2   Denali Borough Schools 20077000356 20030 Cantwell School   Regular School No Other KG 12.0 2020   pk_12_total 7.0                   1.0                             10 7                   1                       10
1730323 AK     school 200770 2   Denali Borough Schools 20077000356 20030 Cantwell School   Regular School No Other KG 12.0 2020   pre_kindergarten 0.0                   0.0                             0 0                   0                       0
1730324 AK     school 200770 2   Denali Borough Schools 20077000357 20040 Tri-Valley School   Regular School No Other PK 12.0 2020   grade_1 19.0 0.0 0.0 0.0             1.0                             22 19 0 0 0             1                       22
1730325 AK     school 200770 2   Denali Borough Schools 20077000357 20040 Tri-Valley School   Regular School No Other PK 12.0 2020   grade_10 7.0 0.0 1.0 0.0             0.0                             8 7 0 1 0             0                       8
1730326 AK     school 200770 2   Denali Borough Schools 20077000357 20040 Tri-Valley School   Regular School No Other PK 12.0 2020   grade_11 12.0 0.0 0.0 2.0             1.0                             15 12 0 0 2             1                       15
1730327 AK     school 200770 2   Denali Borough Schools 20077000357 20040 Tri-Valley School   Regular School No Other PK 12.0 2020   grade_12 6.0 0.0 0.0 0.0             1.0                             8 6 0 0 0             1                       8
1730328 AK     school 200770 2   Denali Borough Schools 20077000357 20040 Tri-Valley School   Regular School No Other PK 12.0 2020   grade_2 11.0 0.0 0.0 0.0             2.0                             13 11 0 0 0             2                       13
1730329 AK     school 200770 2   Denali Borough Schools 20077000357 20040 Tri-Valley School   Regular School No Other PK 12.0 2020   grade_3 11.0 1.0 0.0 0.0             0.0                             12 11 1 0 0             0                       12
1730330 AK     school 200770 2   Denali Borough Schools 20077000357 20040 Tri-Valley School   Regular School No Other PK 12.0 2020   grade_4 14.0 0.0 2.0 0.0             0.0                             16 14 0 2 0             0                       16
1730331 AK     school 200770 2   Denali Borough Schools 20077000357 20040 Tri-Valley School   Regular School No Other PK 12.0 2020   grade_5 15.0 1.0 0.0 0.0             0.0                             16 15 1 0 0             0                       16
1730332 AK     school 200770 2   Denali Borough Schools 20077000357 20040 Tri-Valley School   Regular School No Other PK 12.0 2020   grade_6 9.0 0.0 1.0 0.0             0.0                             11 9 0 1 0             0                       11
1730333 AK     school 200770 2   Denali Borough Schools 20077000357 20040 Tri-Valley School   Regular School No Other PK 12.0 2020   grade_7 14.0 0.0 0.0 0.0             0.0                             14 14 0 0 0             0                       14
1730334 AK     school 200770 2   Denali Borough Schools 20077000357 20040 Tri-Valley School   Regular School No Other PK 12.0 2020   grade_8 13.0 0.0 0.0 0.0             1.0                             14 13 0 0 0             1                       14
1730335 AK     school 200770 2   Denali Borough Schools 20077000357 20040 Tri-Valley School   Regular School No Other PK 12.0 2020   grade_9 11.0 0.0 0.0 0.0             0.0                             11 11 0 0 0             0                       11
1730336 AK     school 200770 2   Denali Borough Schools 20077000357 20040 Tri-Valley School   Regular School No Other PK 12.0 2020   k_12_total 152.0 2.0 4.0 2.0             8.0                             173 152 2 4 2             8                       173
1730337 AK     school 200770 2   Denali Borough Schools 20077000357 20040 Tri-Valley School   Regular School No Other PK 12.0 2020   kindergarten 10.0 0.0 0.0 0.0             2.0                             13 10 0 0 0             2                       13
1730338 AK     school 200770 2   Denali Borough Schools 20077000357 20040 Tri-Valley School   Regular School No Other PK 12.0 2020   pk_12_total 155.0 2.0 4.0 2.0             8.0                             176 155 2 4 2             8                       176
1730339 AK     school 200770 2   Denali Borough Schools 20077000357 20040 Tri-Valley School   Regular School No Other PK 12.0 2020   pre_kindergarten 3.0 0.0 0.0 0.0             0.0                             3 3 0 0 0             0                       3
1730356 AK     school 200050 3   Alaska Gateway Schools 20005000024 30010 Dot Lake School   Regular School No Other PK 12.0 2020   grade_1 0.0                                                 0 0                                           0
1730357 AK     school 200050 3   Alaska Gateway Schools 20005000024 30010 Dot Lake School   Regular School No Other PK 12.0 2020   grade_10 0.0                                                 0 0                                           0
1730358 AK     school 200050 3   Alaska Gateway Schools 20005000024 30010 Dot Lake School   Regular School No Other PK 12.0 2020   grade_11 0.0                                                 0 0                                           0
1730359 AK     school 200050 3   Alaska Gateway Schools 20005000024 30010 Dot Lake School   Regular School No Other PK 12.0 2020   grade_12 0.0                                                 0 0                                           0
1730360 AK     school 200050 3   Alaska Gateway Schools 20005000024 30010 Dot Lake School   Regular School No Other PK 12.0 2020   grade_2 0.0                                                 4 0                                           4
1730361 AK     school 200050 3   Alaska Gateway Schools 20005000024 30010 Dot Lake School   Regular School No Other PK 12.0 2020   grade_3 0.0                                                 1 0                                           1
1730362 AK     school 200050 3   Alaska Gateway Schools 20005000024 30010 Dot Lake School   Regular School No Other PK 12.0 2020   grade_4 0.0                                                 0 0                                           0
1730363 AK     school 200050 3   Alaska Gateway Schools 20005000024 30010 Dot Lake School   Regular School No Other PK 12.0 2020   grade_5 0.0                                                 0 0                                           0
1730364 AK     school 200050 3   Alaska Gateway Schools 20005000024 30010 Dot Lake School   Regular School No Other PK 12.0 2020   grade_6 0.0                                                 2 0                                           2
1730365 AK     school 200050 3   Alaska Gateway Schools 20005000024 30010 Dot Lake School   Regular School No Other PK 12.0 2020   grade_7 0.0                                                 0 0                                           0
1730366 AK     school 200050 3   Alaska Gateway Schools 20005000024 30010 Dot Lake School   Regular School No Other PK 12.0 2020   grade_8 0.0                                                 0 0                                           0
1730367 AK     school 200050 3   Alaska Gateway Schools 20005000024 30010 Dot Lake School   Regular School No Other PK 12.0 2020   grade_9 1.0                                                 1 1                                           1
1730368 AK     school 200050 3   Alaska Gateway Schools 20005000024 30010 Dot Lake School   Regular School No Other PK 12.0 2020   k_12_total 1.0                                                 9 1                                           9
1730369 AK     school 200050 3   Alaska Gateway Schools 20005000024 30010 Dot Lake School   Regular School No Other PK 12.0 2020   kindergarten 0.0                                                 1 0                                           1
1730370 AK     school 200050 3   Alaska Gateway Schools 20005000024 30010 Dot Lake School   Regular School No Other PK 12.0 2020   pk_12_total 1.0                                                 9 1                                           9
1730371 AK     school 200050 3   Alaska Gateway Schools 20005000024 30010 Dot Lake School   Regular School No Other PK 12.0 2020   pre_kindergarten 0.0                                                 0 0                                           0
1730372 AK     school 200050 3   Alaska Gateway Schools 20005000025 30020 Eagle Community School   Regular School No Other PK 12.0 2020   grade_1 1.0                   0.0                             1 1                   0                       1
1730373 AK     school 200050 3   Alaska Gateway Schools 20005000025 30020 Eagle Community School   Regular School No Other PK 12.0 2020   grade_10 1.0                   0.0                             1 1                   0                       1
1730374 AK     school 200050 3   Alaska Gateway Schools 20005000025 30020 Eagle Community School   Regular School No Other PK 12.0 2020   grade_11 2.0                   0.0                             2 2                   0                       2
1730375 AK     school 200050 3   Alaska Gateway Schools 20005000025 30020 Eagle Community School   Regular School No Other PK 12.0 2020   grade_12 1.0                   0.0                             1 1                   0                       1
1730376 AK     school 200050 3   Alaska Gateway Schools 20005000025 30020 Eagle Community School   Regular School No Other PK 12.0 2020   grade_2 0.0                   0.0                             0 0                   0                       0
1730377 AK     school 200050 3   Alaska Gateway Schools 20005000025 30020 Eagle Community School   Regular School No Other PK 12.0 2020   grade_3 1.0                   0.0                             1 1                   0                       1
1730378 AK     school 200050 3   Alaska Gateway Schools 20005000025 30020 Eagle Community School   Regular School No Other PK 12.0 2020   grade_4 1.0                   0.0                             2 1                   0                       2
1730379 AK     school 200050 3   Alaska Gateway Schools 20005000025 30020 Eagle Community School   Regular School No Other PK 12.0 2020   grade_5 2.0                   0.0                             3 2                   0                       3
1730380 AK     school 200050 3   Alaska Gateway Schools 20005000025 30020 Eagle Community School   Regular School No Other PK 12.0 2020   grade_6 0.0                   0.0                             0 0                   0                       0
1730381 AK     school 200050 3   Alaska Gateway Schools 20005000025 30020 Eagle Community School   Regular School No Other PK 12.0 2020   grade_7 1.0                   1.0                             2 1                   1                       2
1730382 AK     school 200050 3   Alaska Gateway Schools 20005000025 30020 Eagle Community School   Regular School No Other PK 12.0 2020   grade_8 2.0                   0.0                             2 2                   0                       2
1730383 AK     school 200050 3   Alaska Gateway Schools 20005000025 30020 Eagle Community School   Regular School No Other PK 12.0 2020   grade_9 0.0                   0.0                             0 0                   0                       0
1730384 AK     school 200050 3   Alaska Gateway Schools 20005000025 30020 Eagle Community School   Regular School No Other PK 12.0 2020   k_12_total 12.0                   1.0                             15 12                   1                       15
1730385 AK     school 200050 3   Alaska Gateway Schools 20005000025 30020 Eagle Community School   Regular School No Other PK 12.0 2020   kindergarten 0.0                   0.0                             0 0                   0                       0
1730386 AK     school 200050 3   Alaska Gateway Schools 20005000025 30020 Eagle Community School   Regular School No Other PK 12.0 2020   pk_12_total 16.0                   1.0                             19 16                   1                       19
1730387 AK     school 200050 3   Alaska Gateway Schools 20005000025 30020 Eagle Community School   Regular School No Other PK 12.0 2020   pre_kindergarten 4.0                   0.0                             4 4                   0                       4
1730388 AK     school 200050 3   Alaska Gateway Schools 20005000026 30030 Mentasta Lake School   Regular School No Other PK 12.0 2020   grade_1                                                   0                                             0
1730389 AK     school 200050 3   Alaska Gateway Schools 20005000026 30030 Mentasta Lake School   Regular School No Other PK 12.0 2020   grade_10                                                   2                                             2
1730390 AK     school 200050 3   Alaska Gateway Schools 20005000026 30030 Mentasta Lake School   Regular School No Other PK 12.0 2020   grade_11                                                   2                                             2
1730391 AK     school 200050 3   Alaska Gateway Schools 20005000026 30030 Mentasta Lake School   Regular School No Other PK 12.0 2020   grade_12                                                   2                                             2
1730392 AK     school 200050 3   Alaska Gateway Schools 20005000026 30030 Mentasta Lake School   Regular School No Other PK 12.0 2020   grade_2                                                   1                                             1
1730393 AK     school 200050 3   Alaska Gateway Schools 20005000026 30030 Mentasta Lake School   Regular School No Other PK 12.0 2020   grade_3                                                   2                                             2
1730394 AK     school 200050 3   Alaska Gateway Schools 20005000026 30030 Mentasta Lake School   Regular School No Other PK 12.0 2020   grade_4                                                   3                                             3
1730395 AK     school 200050 3   Alaska Gateway Schools 20005000026 30030 Mentasta Lake School   Regular School No Other PK 12.0 2020   grade_5                                                   2                                             2
1730396 AK     school 200050 3   Alaska Gateway Schools 20005000026 30030 Mentasta Lake School   Regular School No Other PK 12.0 2020   grade_6                                                   4                                             4
1730397 AK     school 200050 3   Alaska Gateway Schools 20005000026 30030 Mentasta Lake School   Regular School No Other PK 12.0 2020   grade_7                                                   1                                             1
1730398 AK     school 200050 3   Alaska Gateway Schools 20005000026 30030 Mentasta Lake School   Regular School No Other PK 12.0 2020   grade_8                                                   3                                             3
1730399 AK     school 200050 3   Alaska Gateway Schools 20005000026 30030 Mentasta Lake School   Regular School No Other PK 12.0 2020   grade_9                                                   4                                             4
1730400 AK     school 200050 3   Alaska Gateway Schools 20005000026 30030 Mentasta Lake School   Regular School No Other PK 12.0 2020   k_12_total                                                   29                                             29
1730401 AK     school 200050 3   Alaska Gateway Schools 20005000026 30030 Mentasta Lake School   Regular School No Other PK 12.0 2020   kindergarten                                                   3                                             3
1730402 AK     school 200050 3   Alaska Gateway Schools 20005000026 30030 Mentasta Lake School   Regular School No Other PK 12.0 2020   pk_12_total                                                   32                                             32
1730403 AK     school 200050 3   Alaska Gateway Schools 20005000026 30030 Mentasta Lake School   Regular School No Other PK 12.0 2020   pre_kindergarten                                                   3                                             3
1730404 AK     school 200050 3   Alaska Gateway Schools 20005000027 30040 Walter Northway School   Regular School No Other PK 12.0 2020   grade_1                     0.0                             4                     0                       4
1730405 AK     school 200050 3   Alaska Gateway Schools 20005000027 30040 Walter Northway School   Regular School No Other PK 12.0 2020   grade_10                     0.0                             1                     0                       1
1730406 AK     school 200050 3   Alaska Gateway Schools 20005000027 30040 Walter Northway School   Regular School No Other PK 12.0 2020   grade_11                     0.0                             2                     0                       2
1730407 AK     school 200050 3   Alaska Gateway Schools 20005000027 30040 Walter Northway School   Regular School No Other PK 12.0 2020   grade_12                     0.0                             3                     0                       3
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