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
1738244 AK     school 200006 98   Mount Edgecumbe 20000600558 980000 Mt. Edgecumbe High School   Regular School No High 09 12.0 2020   grade_1 0.0     0.0   0.0     0.0   0.0                             0 0     0   0     0   0                       0
1738245 AK     school 200006 98   Mount Edgecumbe 20000600558 980000 Mt. Edgecumbe High School   Regular School No High 09 12.0 2020   grade_10 11.0     2.0   0.0     2.0   2.0                             113 11     2   0     2   2                       113
1738246 AK     school 200006 98   Mount Edgecumbe 20000600558 980000 Mt. Edgecumbe High School   Regular School No High 09 12.0 2020   grade_11 9.0     1.0   3.0     0.0   0.0                             100 9     1   3     0   0                       100
1738247 AK     school 200006 98   Mount Edgecumbe 20000600558 980000 Mt. Edgecumbe High School   Regular School No High 09 12.0 2020   grade_12 11.0     2.0   0.0     0.0   1.0                             98 11     2   0     0   1                       98
1738248 AK     school 200006 98   Mount Edgecumbe 20000600558 980000 Mt. Edgecumbe High School   Regular School No High 09 12.0 2020   grade_2 0.0     0.0   0.0     0.0   0.0                             0 0     0   0     0   0                       0
1738249 AK     school 200006 98   Mount Edgecumbe 20000600558 980000 Mt. Edgecumbe High School   Regular School No High 09 12.0 2020   grade_3 0.0     0.0   0.0     0.0   0.0                             0 0     0   0     0   0                       0
1738250 AK     school 200006 98   Mount Edgecumbe 20000600558 980000 Mt. Edgecumbe High School   Regular School No High 09 12.0 2020   grade_4 0.0     0.0   0.0     0.0   0.0                             0 0     0   0     0   0                       0
1738251 AK     school 200006 98   Mount Edgecumbe 20000600558 980000 Mt. Edgecumbe High School   Regular School No High 09 12.0 2020   grade_5 0.0     0.0   0.0     0.0   0.0                             0 0     0   0     0   0                       0
1738252 AK     school 200006 98   Mount Edgecumbe 20000600558 980000 Mt. Edgecumbe High School   Regular School No High 09 12.0 2020   grade_6 0.0     0.0   0.0     0.0   0.0                             0 0     0   0     0   0                       0
1738253 AK     school 200006 98   Mount Edgecumbe 20000600558 980000 Mt. Edgecumbe High School   Regular School No High 09 12.0 2020   grade_7 0.0     0.0   0.0     0.0   0.0                             0 0     0   0     0   0                       0
1738254 AK     school 200006 98   Mount Edgecumbe 20000600558 980000 Mt. Edgecumbe High School   Regular School No High 09 12.0 2020   grade_8 0.0     0.0   0.0     0.0   0.0                             0 0     0   0     0   0                       0
1738255 AK     school 200006 98   Mount Edgecumbe 20000600558 980000 Mt. Edgecumbe High School   Regular School No High 09 12.0 2020   grade_9 7.0     0.0   1.0     1.0   5.0                             120 7     0   1     1   5                       120
1738256 AK     school 200006 98   Mount Edgecumbe 20000600558 980000 Mt. Edgecumbe High School   Regular School No High 09 12.0 2020   k_12_total 38.0     5.0   4.0     3.0   8.0                             431 38     5   4     3   8                       431
1738257 AK     school 200006 98   Mount Edgecumbe 20000600558 980000 Mt. Edgecumbe High School   Regular School No High 09 12.0 2020   kindergarten 0.0     0.0   0.0     0.0   0.0                             0 0     0   0     0   0                       0
1738258 AK     school 200006 98   Mount Edgecumbe 20000600558 980000 Mt. Edgecumbe High School   Regular School No High 09 12.0 2020   pk_12_total 38.0     5.0   4.0     3.0   8.0                             431 38     5   4     3   8                       431
1738259 AK     school 200006 98   Mount Edgecumbe 20000600558 980000 Mt. Edgecumbe High School   Regular School No High 09 12.0 2020   pre_kindergarten 0.0     0.0   0.0     0.0   0.0                             0 0     0   0     0   0                       0
1820563 AK     school 200006 98   Mount Edgecumbe 20000600558 980000 Mt. Edgecumbe High School   Regular School No High 09 12 2021   grade_1 0.0   0.0 0.0   0.0     0.0   0.0                             0.0 0   0 0   0     0   0                       0
1820564 AK     school 200006 98   Mount Edgecumbe 20000600558 980000 Mt. Edgecumbe High School   Regular School No High 09 12 2021   grade_10 10.0   0.0 0.0   1.0     0.0   5.0                             108.0 10   0 0   1     0   5                       108
1820565 AK     school 200006 98   Mount Edgecumbe 20000600558 980000 Mt. Edgecumbe High School   Regular School No High 09 12 2021   grade_11 7.0   1.0 1.0   0.0     2.0   2.0                             93.0 7   1 1   0     2   2                       93
1820566 AK     school 200006 98   Mount Edgecumbe 20000600558 980000 Mt. Edgecumbe High School   Regular School No High 09 12 2021   grade_12 4.0   0.0 2.0   1.0     0.0   0.0                             78.0 4   0 2   1     0   0                       78
1820567 AK     school 200006 98   Mount Edgecumbe 20000600558 980000 Mt. Edgecumbe High School   Regular School No High 09 12 2021   grade_2 0.0   0.0 0.0   0.0     0.0   0.0                             0.0 0   0 0   0     0   0                       0
1820568 AK     school 200006 98   Mount Edgecumbe 20000600558 980000 Mt. Edgecumbe High School   Regular School No High 09 12 2021   grade_3 0.0   0.0 0.0   0.0     0.0   0.0                             0.0 0   0 0   0     0   0                       0
1820569 AK     school 200006 98   Mount Edgecumbe 20000600558 980000 Mt. Edgecumbe High School   Regular School No High 09 12 2021   grade_4 0.0   0.0 0.0   0.0     0.0   0.0                             0.0 0   0 0   0     0   0                       0
1820570 AK     school 200006 98   Mount Edgecumbe 20000600558 980000 Mt. Edgecumbe High School   Regular School No High 09 12 2021   grade_5 0.0   0.0 0.0   0.0     0.0   0.0                             0.0 0   0 0   0     0   0                       0
1820571 AK     school 200006 98   Mount Edgecumbe 20000600558 980000 Mt. Edgecumbe High School   Regular School No High 09 12 2021   grade_6 0.0   0.0 0.0   0.0     0.0   0.0                             0.0 0   0 0   0     0   0                       0
1820572 AK     school 200006 98   Mount Edgecumbe 20000600558 980000 Mt. Edgecumbe High School   Regular School No High 09 12 2021   grade_7 0.0   0.0 0.0   0.0     0.0   0.0                             0.0 0   0 0   0     0   0                       0
1820573 AK     school 200006 98   Mount Edgecumbe 20000600558 980000 Mt. Edgecumbe High School   Regular School No High 09 12 2021   grade_8 0.0   0.0 0.0   0.0     0.0   0.0                             0.0 0   0 0   0     0   0                       0
1820574 AK     school 200006 98   Mount Edgecumbe 20000600558 980000 Mt. Edgecumbe High School   Regular School No High 09 12 2021   grade_9 14.0   1.0 1.0   1.0     0.0   2.0                             95.0 14   1 1   1     0   2                       95
1820575 AK     school 200006 98   Mount Edgecumbe 20000600558 980000 Mt. Edgecumbe High School   Regular School No High 09 12 2021   k_12_total 35.0   2.0 4.0   3.0     2.0   9.0                             374.0 35   2 4   3     2   9                       374
1820576 AK     school 200006 98   Mount Edgecumbe 20000600558 980000 Mt. Edgecumbe High School   Regular School No High 09 12 2021   kindergarten 0.0   0.0 0.0   0.0     0.0   0.0                             0.0 0   0 0   0     0   0                       0
1820577 AK     school 200006 98   Mount Edgecumbe 20000600558 980000 Mt. Edgecumbe High School   Regular School No High 09 12 2021   pk_12_total 35.0   2.0 4.0   3.0     2.0   9.0                             374.0 35   2 4   3     2   9                       374
1820578 AK     school 200006 98   Mount Edgecumbe 20000600558 980000 Mt. Edgecumbe High School   Regular School No High 09 12 2021   pre_kindergarten 0.0   0.0 0.0   0.0     0.0   0.0                             0.0 0   0 0   0     0   0                       0
1732404 AK     school 200730 9   Chatham Schools 20073000342 90010 Angoon School   Regular School No Other PK 12.0 2020   grade_1 0.0                   0.0                             5 0                   0                       5
1732405 AK     school 200730 9   Chatham Schools 20073000342 90010 Angoon School   Regular School No Other PK 12.0 2020   grade_10 0.0                   0.0                             3 0                   0                       3
1732406 AK     school 200730 9   Chatham Schools 20073000342 90010 Angoon School   Regular School No Other PK 12.0 2020   grade_11 0.0                   0.0                             1 0                   0                       1
1732407 AK     school 200730 9   Chatham Schools 20073000342 90010 Angoon School   Regular School No Other PK 12.0 2020   grade_12 0.0                   0.0                             5 0                   0                       5
1732408 AK     school 200730 9   Chatham Schools 20073000342 90010 Angoon School   Regular School No Other PK 12.0 2020   grade_2 1.0                   0.0                             5 1                   0                       5
1732409 AK     school 200730 9   Chatham Schools 20073000342 90010 Angoon School   Regular School No Other PK 12.0 2020   grade_3 0.0                   1.0                             6 0                   1                       6
1732410 AK     school 200730 9   Chatham Schools 20073000342 90010 Angoon School   Regular School No Other PK 12.0 2020   grade_4 0.0                   0.0                             3 0                   0                       3
1732411 AK     school 200730 9   Chatham Schools 20073000342 90010 Angoon School   Regular School No Other PK 12.0 2020   grade_5 0.0                   1.0                             7 0                   1                       7
1732412 AK     school 200730 9   Chatham Schools 20073000342 90010 Angoon School   Regular School No Other PK 12.0 2020   grade_6 1.0                   1.0                             10 1                   1                       10
1732413 AK     school 200730 9   Chatham Schools 20073000342 90010 Angoon School   Regular School No Other PK 12.0 2020   grade_7 0.0                   0.0                             4 0                   0                       4
1732414 AK     school 200730 9   Chatham Schools 20073000342 90010 Angoon School   Regular School No Other PK 12.0 2020   grade_8 0.0                   0.0                             6 0                   0                       6
1732415 AK     school 200730 9   Chatham Schools 20073000342 90010 Angoon School   Regular School No Other PK 12.0 2020   grade_9 0.0                   0.0                             5 0                   0                       5
1732416 AK     school 200730 9   Chatham Schools 20073000342 90010 Angoon School   Regular School No Other PK 12.0 2020   k_12_total 2.0                   3.0                             64 2                   3                       64
1732417 AK     school 200730 9   Chatham Schools 20073000342 90010 Angoon School   Regular School No Other PK 12.0 2020   kindergarten 0.0                   0.0                             4 0                   0                       4
1732418 AK     school 200730 9   Chatham Schools 20073000342 90010 Angoon School   Regular School No Other PK 12.0 2020   pk_12_total 2.0                   3.0                             65 2                   3                       65
1732419 AK     school 200730 9   Chatham Schools 20073000342 90010 Angoon School   Regular School No Other PK 12.0 2020   pre_kindergarten 0.0                   0.0                             1 0                   0                       1
1732420 AK     school 200730 9   Chatham Schools 20073000344 90030 Gustavus School   Regular School No Other KG 12.0 2020   grade_1 1.0                                                 3 1                                           3
1732421 AK     school 200730 9   Chatham Schools 20073000344 90030 Gustavus School   Regular School No Other KG 12.0 2020   grade_10 5.0                                                 5 5                                           5
1732422 AK     school 200730 9   Chatham Schools 20073000344 90030 Gustavus School   Regular School No Other KG 12.0 2020   grade_11 5.0                                                 6 5                                           6
1732423 AK     school 200730 9   Chatham Schools 20073000344 90030 Gustavus School   Regular School No Other KG 12.0 2020   grade_12 5.0                                                 6 5                                           6
1732424 AK     school 200730 9   Chatham Schools 20073000344 90030 Gustavus School   Regular School No Other KG 12.0 2020   grade_2 3.0                                                 3 3                                           3
1732425 AK     school 200730 9   Chatham Schools 20073000344 90030 Gustavus School   Regular School No Other KG 12.0 2020   grade_3 7.0                                                 9 7                                           9
1732426 AK     school 200730 9   Chatham Schools 20073000344 90030 Gustavus School   Regular School No Other KG 12.0 2020   grade_4 4.0                                                 5 4                                           5
1732427 AK     school 200730 9   Chatham Schools 20073000344 90030 Gustavus School   Regular School No Other KG 12.0 2020   grade_5 4.0                                                 5 4                                           5
1732428 AK     school 200730 9   Chatham Schools 20073000344 90030 Gustavus School   Regular School No Other KG 12.0 2020   grade_6 4.0                                                 7 4                                           7
1732429 AK     school 200730 9   Chatham Schools 20073000344 90030 Gustavus School   Regular School No Other KG 12.0 2020   grade_7 4.0                                                 5 4                                           5
1732430 AK     school 200730 9   Chatham Schools 20073000344 90030 Gustavus School   Regular School No Other KG 12.0 2020   grade_8 6.0                                                 6 6                                           6
1732431 AK     school 200730 9   Chatham Schools 20073000344 90030 Gustavus School   Regular School No Other KG 12.0 2020   grade_9 2.0                                                 2 2                                           2
1732432 AK     school 200730 9   Chatham Schools 20073000344 90030 Gustavus School   Regular School No Other KG 12.0 2020   k_12_total 52.0                                                 64 52                                           64
1732433 AK     school 200730 9   Chatham Schools 20073000344 90030 Gustavus School   Regular School No Other KG 12.0 2020   kindergarten 2.0                                                 2 2                                           2
1732434 AK     school 200730 9   Chatham Schools 20073000344 90030 Gustavus School   Regular School No Other KG 12.0 2020   pk_12_total 52.0                                                 64 52                                           64
1732435 AK     school 200730 9   Chatham Schools 20073000344 90030 Gustavus School   Regular School No Other KG 12.0 2020   pre_kindergarten 0.0                                                 0 0                                           0
1732436 AK     school 200730 9   Chatham Schools 20073000490 90090 Klukwan School   Regular School No Other KG 12.0 2020   grade_1 1.0                   0.0                             1 1                   0                       1
1732437 AK     school 200730 9   Chatham Schools 20073000490 90090 Klukwan School   Regular School No Other KG 12.0 2020   grade_10 0.0                   0.0                             0 0                   0                       0
1732438 AK     school 200730 9   Chatham Schools 20073000490 90090 Klukwan School   Regular School No Other KG 12.0 2020   grade_11 0.0                   0.0                             0 0                   0                       0
1732439 AK     school 200730 9   Chatham Schools 20073000490 90090 Klukwan School   Regular School No Other KG 12.0 2020   grade_12 0.0                   0.0                             0 0                   0                       0
1732440 AK     school 200730 9   Chatham Schools 20073000490 90090 Klukwan School   Regular School No Other KG 12.0 2020   grade_2 1.0                   1.0                             5 1                   1                       5
1732441 AK     school 200730 9   Chatham Schools 20073000490 90090 Klukwan School   Regular School No Other KG 12.0 2020   grade_3 0.0                   1.0                             2 0                   1                       2
1732442 AK     school 200730 9   Chatham Schools 20073000490 90090 Klukwan School   Regular School No Other KG 12.0 2020   grade_4 0.0                   0.0                             0 0                   0                       0
1732443 AK     school 200730 9   Chatham Schools 20073000490 90090 Klukwan School   Regular School No Other KG 12.0 2020   grade_5 1.0                   1.0                             3 1                   1                       3
1732444 AK     school 200730 9   Chatham Schools 20073000490 90090 Klukwan School   Regular School No Other KG 12.0 2020   grade_6 0.0                   0.0                             1 0                   0                       1
1732445 AK     school 200730 9   Chatham Schools 20073000490 90090 Klukwan School   Regular School No Other KG 12.0 2020   grade_7 0.0                   0.0                             0 0                   0                       0
1732446 AK     school 200730 9   Chatham Schools 20073000490 90090 Klukwan School   Regular School No Other KG 12.0 2020   grade_8 0.0                   0.0                             0 0                   0                       0
1732447 AK     school 200730 9   Chatham Schools 20073000490 90090 Klukwan School   Regular School No Other KG 12.0 2020   grade_9 0.0                   0.0                             0 0                   0                       0
1732448 AK     school 200730 9   Chatham Schools 20073000490 90090 Klukwan School   Regular School No Other KG 12.0 2020   k_12_total 4.0                   3.0                             14 4                   3                       14
1732449 AK     school 200730 9   Chatham Schools 20073000490 90090 Klukwan School   Regular School No Other KG 12.0 2020   kindergarten 1.0                   0.0                             2 1                   0                       2
1732450 AK     school 200730 9   Chatham Schools 20073000490 90090 Klukwan School   Regular School No Other KG 12.0 2020   pk_12_total 4.0                   3.0                             14 4                   3                       14
1732451 AK     school 200730 9   Chatham Schools 20073000490 90090 Klukwan School   Regular School No Other KG 12.0 2020   pre_kindergarten 0.0                   0.0                             0 0                   0                       0
1732452 AK     school 200730 9   Chatham Schools 20073000477 98010 Chatham Correspondence   Regular School No Other KG 12.0 2020   grade_1 0.0 0.0                                               0 0 0                                         0
1732453 AK     school 200730 9   Chatham Schools 20073000477 98010 Chatham Correspondence   Regular School No Other KG 12.0 2020   grade_10 0.0 0.0                                               0 0 0                                         0
1732454 AK     school 200730 9   Chatham Schools 20073000477 98010 Chatham Correspondence   Regular School No Other KG 12.0 2020   grade_11 0.0 1.0                                               1 0 1                                         1
1732455 AK     school 200730 9   Chatham Schools 20073000477 98010 Chatham Correspondence   Regular School No Other KG 12.0 2020   grade_12 0.0 1.0                                               1 0 1                                         1
1732456 AK     school 200730 9   Chatham Schools 20073000477 98010 Chatham Correspondence   Regular School No Other KG 12.0 2020   grade_2 1.0 0.0                                               1 1 0                                         1
1732457 AK     school 200730 9   Chatham Schools 20073000477 98010 Chatham Correspondence   Regular School No Other KG 12.0 2020   grade_3 0.0 2.0                                               2 0 2                                         2
1732458 AK     school 200730 9   Chatham Schools 20073000477 98010 Chatham Correspondence   Regular School No Other KG 12.0 2020   grade_4 0.0 1.0                                               1 0 1                                         1
1732459 AK     school 200730 9   Chatham Schools 20073000477 98010 Chatham Correspondence   Regular School No Other KG 12.0 2020   grade_5 1.0 0.0                                               1 1 0                                         1
1732460 AK     school 200730 9   Chatham Schools 20073000477 98010 Chatham Correspondence   Regular School No Other KG 12.0 2020   grade_6 1.0 0.0                                               1 1 0                                         1
1732461 AK     school 200730 9   Chatham Schools 20073000477 98010 Chatham Correspondence   Regular School No Other KG 12.0 2020   grade_7 0.0 0.0                                               0 0 0                                         0
1732462 AK     school 200730 9   Chatham Schools 20073000477 98010 Chatham Correspondence   Regular School No Other KG 12.0 2020   grade_8 1.0 0.0                                               1 1 0                                         1
1732463 AK     school 200730 9   Chatham Schools 20073000477 98010 Chatham Correspondence   Regular School No Other KG 12.0 2020   grade_9 0.0 0.0                                               0 0 0                                         0
1732464 AK     school 200730 9   Chatham Schools 20073000477 98010 Chatham Correspondence   Regular School No Other KG 12.0 2020   k_12_total 5.0 5.0                                               10 5 5                                         10
1732465 AK     school 200730 9   Chatham Schools 20073000477 98010 Chatham Correspondence   Regular School No Other KG 12.0 2020   kindergarten 1.0 0.0                                               1 1 0                                         1
1732466 AK     school 200730 9   Chatham Schools 20073000477 98010 Chatham Correspondence   Regular School No Other KG 12.0 2020   pk_12_total 5.0 5.0                                               10 5 5                                         10
1732467 AK     school 200730 9   Chatham Schools 20073000477 98010 Chatham Correspondence   Regular School No Other KG 12.0 2020   pre_kindergarten 0.0 0.0                                               0 0 0                                         0
1814723 AK     school 200730 9   Chatham Schools 20073000342 90010 Angoon School   Regular School No Other PK 12 2021   grade_1 0.0                   0.0                             2.0 0                   0                       2
1814724 AK     school 200730 9   Chatham Schools 20073000342 90010 Angoon School   Regular School No Other PK 12 2021   grade_10 0.0                   0.0                             7.0 0                   0                       7
1814725 AK     school 200730 9   Chatham Schools 20073000342 90010 Angoon School   Regular School No Other PK 12 2021   grade_11 0.0                   0.0                             1.0 0                   0                       1
1814726 AK     school 200730 9   Chatham Schools 20073000342 90010 Angoon School   Regular School No Other PK 12 2021   grade_12 0.0                   1.0                             4.0 0                   1                       4
1814727 AK     school 200730 9   Chatham Schools 20073000342 90010 Angoon School   Regular School No Other PK 12 2021   grade_2 0.0                   0.0                             6.0 0                   0                       6