Data source: Big Local News · About: Big Local

15,601 rows where state = "WA" and year = 2020 sorted by white_int

View and edit SQL

grade

year

  • 2020 · 15,601
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
2570344 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000007 3476 J M Weatherwax High School   Regular School No High 09 12 2020   grade_8 0 0 2   0 0     0   0   2 0 0   2   0   1       0.0 2 0 0 2   0 0     0   0   2 0 0   2 0 1     0 2
2570352 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000008 2449 McDermoth Elementary   Regular School No Elementary KG 05 2020   grade_8 0 0 2   0 0     0   0   1 1 0   2   0   2       0.0 2 0 0 2   0 0     0   0   1 1 0   2 0 2     0 2
2570515 WA King   school 5300346 17915   Ashe Preparatory Academy 530034603713 5602 Ashe Preparatory Academy (Closed after 2019-2020 school year)   Regular School Yes Elementary KG 08 2020   grade_1 0 12 2   0 0     0   1   6 9 0   0   0   0       0.0 15 0 12 2   0 0     0   1   6 9 0   0 0 0     0 15
2570516 WA King   school 5300346 17915   Ashe Preparatory Academy 530034603713 5602 Ashe Preparatory Academy (Closed after 2019-2020 school year)   Regular School Yes Elementary KG 08 2020   grade_2 0 11 1   0 0     0   2   5 9 0   0   0   0       0.0 14 0 11 1   0 0     0   2   5 9 0   0 0 0     0 14
2570517 WA King   school 5300346 17915   Ashe Preparatory Academy 530034603713 5602 Ashe Preparatory Academy (Closed after 2019-2020 school year)   Regular School Yes Elementary KG 08 2020   grade_6 0 16 3   1 0     0   3   15 8 0   0   0   0       0.0 23 0 16 3   1 0     0   3   15 8 0   0 0 0     0 23
2570518 WA King   school 5300346 17915   Ashe Preparatory Academy 530034603713 5602 Ashe Preparatory Academy (Closed after 2019-2020 school year)   Regular School Yes Elementary KG 08 2020   pk_12_total 0 71 7   1 0     0   10   44 45 0   0   0   0       0.0 89 0 71 7   1 0     0   10   44 45 0   0 0 0     0 89
2570519 WA King   school 5300346 17915   Ashe Preparatory Academy 530034603713 5602 Ashe Preparatory Academy (Closed after 2019-2020 school year)   Regular School Yes Elementary KG 08 2020   kindergarten 0 32 1   0 0     0   4   18 19 0   0   0   0       0.0 37 0 32 1   0 0     0   4   18 19 0   0 0 0     0 37
2570664 WA King   school 5300300 17408   Auburn School District 530030002904 1915 Special Ed School   Special Education School No Other PK 12 2020   grade_12 0 1 0   0 0     0   0   1 0 0   0   0   1       0.0 1 0 1 0   0 0     0   0   1 0 0   0 0 1     0 1
2570665 WA King   school 5300300 17408   Auburn School District 530030002904 1915 Special Ed School   Special Education School No Other PK 12 2020   grade_4 0 1 0   0 0     0   0   1 0 0   0   0   0       0.0 1 0 1 0   0 0     0   0   1 0 0   0 0 0     0 1
2570668 WA King   school 5300300 17408   Auburn School District 530030002904 1915 Special Ed School   Special Education School No Other PK 12 2020   grade_9 0 0 0   0 1     0   0   0 1 0   0   0   0       0.0 1 0 0 0   0 1     0   0   0 1 0   0 0 0     0 1
2570697 WA Kitsap   school 5300330 18303   Bainbridge Island School District 530033003113 1939 Bainbridge Special Education Services   Special Education School No Other PK 12 2020   grade_10 0 0 0   0 0     0   1   1 0 0   0   0   0       0.0 1 0 0 0   0 0     0   1   1 0 0   0 0 0     0 1
2570701 WA Kitsap   school 5300330 18303   Bainbridge Island School District 530033003113 1939 Bainbridge Special Education Services   Special Education School No Other PK 12 2020   grade_4 0 0 0   0 1     0   0   0 1 0   0   0   0       0.0 1 0 0 0   0 1     0   0   0 1 0   0 0 0     0 1
2570847 WA Clark   school 5300380 6119   Battle Ground School District 530038003681 4144 Maple Grove Primary   Regular School No Elementary KG 04 2020   grade_7 0 0 0   0 1     0   0   1 0 0   0   0   0       0.0 1 0 0 0   0 1     0   0   1 0 0   0 0 0     0 1
2570926 WA King   school 5300390 17405   Bellevue School District 530039003462 5325 Career Education Options Reengagement Program   Alternative School No High 10 12 2020   grade_11 0 0 4   0 0     0   3   0 7 0   2   0   2       1.0 7 0 0 4   0 0     0   3   0 7 0   2 0 2     1 7
2570934 WA King   school 5300390 17405   Bellevue School District 530039003434 5281 Central Educational Services   Regular School No Other PK 12 2020   grade_4 0 0 0   0 1     0   0   1 0 0   1   0   0       0.0 1 0 0 0   0 1     0   0   1 0 0   1 0 0     0 1
2570937 WA King   school 5300390 17405   Bellevue School District 530039003434 5281 Central Educational Services   Regular School No Other PK 12 2020   grade_7 0 0 3   0 0     0   1   2 2 0   0   0   0       0.0 4 0 0 3   0 0     0   1   2 2 0   0 0 0     0 4
2571104 WA King   school 5300390 17405   Bellevue School District 530039003638 5508 Wilburton Elementary School   Regular School No Elementary PK 05 2020   kindergarten_half_day 0 0 0   0 2     0   0   2 0 0   0   0   0       0.0 2 0 0 0   0 2     0   0   2 0 0   0 0 0     0 2
2571280 WA Whatcom   school 5300420 37501   Bellingham School District 530042003225 5125 Wade King Elementary School   Regular School No Elementary PK 05 2020   pre_kindergarten 0 0 1   0 0     0   0   1 0 0   0   0   1       0.0 1 0 0 1   0 0     0   0   1 0 0   0 0 1     0 1
2571347 WA Pierce   school 5300480 27403   Bethel School District 530048000122 2576 Clover Creek Elementary   Regular School No Elementary KG 05 2020   pre_kindergarten 0 0 0   0 0     0   1   1 0 0   0   0   0       0.0 1 0 0 0   0 0     0   1   1 0 0   0 0 0     0 1
2571479 WA Klickitat   school 5300510 20203   Bickleton School District 530051000129 3392 Bickleton Elementary & High Schl   Regular School No Other KG 12 2020   grade_1 0 0 6   0 0     0   0   4 2 0   0   0   2       0.0 6 0 0 6   0 0     0   0   4 2 0   0 0 2     0 6
2571623 WA Okanogan   school 5300690 24111   Brewster School District 530069003381 5272 Brewster Alternative School   Alternative School No High 09 12 2020   grade_11 0 0 4   0 0     0   0   4 0 0   0   0   4       0.0 4 0 0 4   0 0     0   0   4 0 0   0 0 4     0 4
2571624 WA Okanogan   school 5300690 24111   Brewster School District 530069003381 5272 Brewster Alternative School   Alternative School No High 09 12 2020   grade_12 0 0 4   0 0     0   0   1 3 0   0   0   3       0.0 4 0 0 4   0 0     0   0   1 3 0   0 0 3     0 4
2571625 WA Okanogan   school 5300690 24111   Brewster School District 530069003381 5272 Brewster Alternative School   Alternative School No High 09 12 2020   pk_12_total 0 0 8   0 0     0   0   5 3 0   0   0   7       0.0 8 0 0 8   0 0     0   0   5 3 0   0 0 7     0 8
2571637 WA Okanogan   school 5300690 24111   Brewster School District 530069000149 2800 Brewster High School   Regular School No High 09 12 2020   grade_8 0 0 3   0 0     0   0   0 3 0   0   0   3       0.0 3 0 0 3   0 0     0   0   0 3 0   0 0 3     0 3
2571642 WA Okanogan   school 5300690 24111   Brewster School District 530069002284 4223 Brewster Middle School   Regular School No Middle 06 08 2020   grade_8 0 0 2   0 0     0   0   1 1 0   2   0   2       0.0 2 0 0 2   0 0     0   0   1 1 0   2 0 2     0 2
2571644 WA Douglas   school 5300720 9075   Bridgeport School District 530072002890 1900 Bridgeport Aurora High School   Alternative School No High 09 12 2020   grade_10 0 0 1   0 0     0   0   1 0 0   1   0   1       0.0 1 0 0 1   0 0     0   0   1 0 0   1 0 1     0 1
2571645 WA Douglas   school 5300720 9075   Bridgeport School District 530072002890 1900 Bridgeport Aurora High School   Alternative School No High 09 12 2020   grade_11 0 0 5   0 0     0   0   4 1 0   3   0   5       0.0 5 0 0 5   0 0     0   0   4 1 0   3 0 5     0 5
2571646 WA Douglas   school 5300720 9075   Bridgeport School District 530072002890 1900 Bridgeport Aurora High School   Alternative School No High 09 12 2020   grade_12 0 0 4   0 0     0   0   3 1 0   2   1   4       0.0 4 0 0 4   0 0     0   0   3 1 0   2 1 4     0 4
2571653 WA Douglas   school 5300720 9075   Bridgeport School District 530072000150 2562 Bridgeport Elementary   Regular School No Elementary PK 05 2020   grade_5 0 0 61   0 0     0   0   36 25 0   29   3   60       0.0 61 0 0 61   0 0     0   0   36 25 0   29 3 60     0 61
2571654 WA Douglas   school 5300720 9075   Bridgeport School District 530072000150 2562 Bridgeport Elementary   Regular School No Elementary PK 05 2020   grade_6 0 0 1   0 0     0   0   0 1 0   1   0   1       0.0 1 0 0 1   0 0     0   0   0 1 0   1 0 1     0 1
2571656 WA Douglas   school 5300720 9075   Bridgeport School District 530072000150 2562 Bridgeport Elementary   Regular School No Elementary PK 05 2020   kindergarten 0 0 48   1 1     0   0   32 18 0   44   5   49       0.0 50 0 0 48   1 1     0   0   32 18 0   44 5 49     0 50
2571659 WA Douglas   school 5300720 9075   Bridgeport School District 530072000151 2788 Bridgeport High School   Regular School No High 09 12 2020   grade_11 0 0 59   0 0     0   0   29 30 0   21   5   57       2.0 59 0 0 59   0 0     0   0   29 30 0   21 5 57     2 59
2571661 WA Douglas   school 5300720 9075   Bridgeport School District 530072000151 2788 Bridgeport High School   Regular School No High 09 12 2020   grade_8 0 0 1   0 0     0   0   1 0 0   1   0   1       0.0 1 0 0 1   0 0     0   0   1 0 0   1 0 1     0 1
2571730 WA Skagit   school 5300780 29100   Burlington-Edison School District 530078003639 5525 Open Doors   Alternative School No High 10 12 2020   grade_11 0 0 1   0 0     0   0   0 1 0   1   0   1       0.0 1 0 0 1   0 0     0   0   0 1 0   1 0 1     0 1
2571815 WA Clallam   school 5300840 5401   Cape Flattery School District 530084003030 1787 Cape Flattery Preschool   Regular School No Prekindergarten PK PK 2020   pk_12_total 0 0 3   4 0     0   4   5 6 0   0   0   1       0.0 11 0 0 3   4 0     0   4   5 6 0   0 0 1     0 11
2571816 WA Clallam   school 5300840 5401   Cape Flattery School District 530084003030 1787 Cape Flattery Preschool   Regular School No Prekindergarten PK PK 2020   pre_kindergarten 0 0 3   4 0     0   4   5 6 0   0   0   1       0.0 11 0 0 3   4 0     0   4   5 6 0   0 0 1     0 11
2571821 WA Clallam   school 5300840 5401   Cape Flattery School District 530084000164 3422 Clallam Bay High & Elementary   Regular School No Other KG 12 2020   grade_2 0 0 5   2 0     0   1   3 5 0   0   0   8       0.0 8 0 0 5   2 0     0   1   3 5 0   0 0 8     0 8
2571832 WA Clallam   school 5300840 5401   Cape Flattery School District 530084003042 2594 Neah Bay Elementary School   Regular School No Elementary KG 05 2020   grade_2 0 0 5   21 0     0   8   25 9 0   0   0   31       0.0 34 0 0 5   21 0     0   8   25 9 0   0 0 31     0 34
2571834 WA Clallam   school 5300840 5401   Cape Flattery School District 530084003042 2594 Neah Bay Elementary School   Regular School No Elementary KG 05 2020   grade_4 0 0 7   24 0     0   2   11 22 0   0   1   32       1.0 33 0 0 7   24 0     0   2   11 22 0   0 1 32     1 33
2571837 WA Clallam   school 5300840 5401   Cape Flattery School District 530084003042 2594 Neah Bay Elementary School   Regular School No Elementary KG 05 2020   kindergarten_half_day 0 0 1   4 0     0   0   3 2 0   0   0   4       0.0 5 0 0 1   4 0     0   0   3 2 0   0 0 4     0 5
2571843 WA Clallam   school 5300840 5401   Cape Flattery School District 530084000165 3145 Neah Bay Junior/ Senior High School   Regular School No High 06 12 2020   grade_7 0 0 5   22 0     0   5   17 15 0   0   1   31       3.0 32 0 0 5   22 0     0   5   17 15 0   0 1 31     3 32
2571844 WA Clallam   school 5300840 5401   Cape Flattery School District 530084000165 3145 Neah Bay Junior/ Senior High School   Regular School No High 06 12 2020   grade_8 0 0 4   8 0     0   5   5 12 0   0   1   14       1.0 17 0 0 4   8 0     0   5   5 12 0   0 1 14     1 17
2571952 WA Kitsap   school 5301080 18401   Central Kitsap School District 530108003622 5472 Barker Creek Community School   Alternative School No Other KG 12 2020   kindergarten 0 0 0   0 0     0   1   1 0 0   0   0   0       0.0 1 0 0 0   0 0     0   1   1 0 0   0 0 0     0 1
2572009 WA Kitsap   school 5301080 18401   Central Kitsap School District 530108000182 4015 Esquire Hills Elementary   Regular School No Elementary PK 05 2020   pre_kindergarten 0 0 2   0 0     0   0   1 1 0   0   0   0       0.0 2 0 0 2   0 0     0   0   1 1 0   0 0 0     0 2
2572070 WA Kitsap   school 5301080 18401   Central Kitsap School District 530108001754 4101 Silverdale Elementary   Regular School No Elementary PK 05 2020   pre_kindergarten 0 0 0   0 0     0   1   1 0 0   0   0   0       0.0 1 0 0 0   0 0     0   1   1 0 0   0 0 0     0 1
2572188 WA Spokane   school 5301110 32356   Central Valley School District 530111000200 2953 Progress Elementary School   Regular School No Elementary PK 05 2020   kindergarten_half_day 0 0 1   0 0     0   0   0 1 0   0   0   1       0.0 1 0 0 1   0 0     0   0   0 1 0   0 0 1     0 1
2572210 WA Spokane   school 5301110 32356   Central Valley School District 530111000201 3307 South Pines Elementary   Regular School No Elementary PK 05 2020   kindergarten_half_day 0 0 1   0 0     0   0   1 0 0   1   0   0       0.0 1 0 0 1   0 0     0   0   1 0 0   1 0 0     0 1
2572334 WA Lewis   school 5301170 21302   Chehalis School District 530117003486 5369 Lewis County Alternative School   Alternative School No High 06 12 2020   grade_9 0 0 1   0 0     0   0   0 1 0   0   0   1       0.0 1 0 0 1   0 0     0   0   0 1 0   0 0 1     0 1
2572336 WA Lewis   school 5301170 21302   Chehalis School District 530117003464 5317 Lewis County Jail   Regular School No High 09 12 2020   grade_11 0 0 2   0 0     0   0   2 0 0   0   0   2       0.0 2 0 0 2   0 0     0   0   2 0 0   0 0 2     0 2
2572337 WA Lewis   school 5301170 21302   Chehalis School District 530117003464 5317 Lewis County Jail   Regular School No High 09 12 2020   pk_12_total 0 0 2   0 0     0   0   2 0 0   0   0   2       0.0 2 0 0 2   0 0     0   0   2 0 0   0 0 2     0 2
2572461 WA Pierce   school   27901   Chief Leschi Schools   5549 Chief Leschi Schools             2020   grade_10 0 0 3   37 0     0   1   23 18 0   0   0   28       0.0 41 0 0 3   37 0     0   1   23 18 0   0 0 28     0 41
2572462 WA Pierce   school   27901   Chief Leschi Schools   5549 Chief Leschi Schools             2020   grade_11 0 0 2   32 0     0   3   18 19 0   0   0   23       0.0 37 0 0 2   32 0     0   3   18 19 0   0 0 23     0 37
2572463 WA Pierce   school   27901   Chief Leschi Schools   5549 Chief Leschi Schools             2020   grade_12 0 0 5   35 0     0   1   21 20 0   0   1   25       0.0 41 0 0 5   35 0     0   1   21 20 0   0 1 25     0 41
2572464 WA Pierce   school   27901   Chief Leschi Schools   5549 Chief Leschi Schools             2020   grade_1 0 0 15   20 0     0   5   22 18 0   0   0   22       0.0 40 0 0 15   20 0     0   5   22 18 0   0 0 22     0 40
2572465 WA Pierce   school   27901   Chief Leschi Schools   5549 Chief Leschi Schools             2020   grade_2 0 0 10   32 0     0   2   21 23 0   0   0   27       0.0 44 0 0 10   32 0     0   2   21 23 0   0 0 27     0 44
2572466 WA Pierce   school   27901   Chief Leschi Schools   5549 Chief Leschi Schools             2020   grade_3 0 0 5   36 0     0   1   24 18 0   0   0   20       1.0 42 0 0 5   36 0     0   1   24 18 0   0 0 20     1 42
2572467 WA Pierce   school   27901   Chief Leschi Schools   5549 Chief Leschi Schools             2020   grade_4 0 0 4   32 0     0   3   14 25 0   0   0   22       0.0 39 0 0 4   32 0     0   3   14 25 0   0 0 22     0 39
2572468 WA Pierce   school   27901   Chief Leschi Schools   5549 Chief Leschi Schools             2020   grade_5 0 0 6   41 0     0   0   25 22 0   0   0   29       1.0 47 0 0 6   41 0     0   0   25 22 0   0 0 29     1 47
2572469 WA Pierce   school   27901   Chief Leschi Schools   5549 Chief Leschi Schools             2020   grade_6 0 1 5   38 0     0   1   21 24 0   0   0   22       2.0 45 0 1 5   38 0     0   1   21 24 0   0 0 22     2 45
2572470 WA Pierce   school   27901   Chief Leschi Schools   5549 Chief Leschi Schools             2020   grade_7 0 0 11   28 0     0   4   23 20 0   0   0   21       1.0 43 0 0 11   28 0     0   4   23 20 0   0 0 21     1 43
2572471 WA Pierce   school   27901   Chief Leschi Schools   5549 Chief Leschi Schools             2020   grade_8 0 0 5   37 0     0   3   25 20 0   0   0   30       0.0 45 0 0 5   37 0     0   3   25 20 0   0 0 30     0 45
2572472 WA Pierce   school   27901   Chief Leschi Schools   5549 Chief Leschi Schools             2020   grade_9 0 0 4   30 0     0   1   19 16 0   0   0   18       0.0 35 0 0 4   30 0     0   1   19 16 0   0 0 18     0 35
2572473 WA Pierce   school   27901   Chief Leschi Schools   5549 Chief Leschi Schools             2020   pk_12_total 0 1 88   418 0     0   39   279 267 0   0   3   306       5.0 546 0 1 88   418 0     0   39   279 267 0   0 3 306     5 546
2572474 WA Pierce   school   27901   Chief Leschi Schools   5549 Chief Leschi Schools             2020   kindergarten 0 0 13   20 0     0   14   23 24 0   0   2   19       0.0 47 0 0 13   20 0     0   14   23 24 0   0 2 19     0 47
2572545 WA Asotin   school 5301320 2250   Clarkston School District 530132000236 3266 Highland Elementary   Regular School No Elementary KG 06 2020   pre_kindergarten 0 0 1   0 0     0   0   1 0 0   0   0   1       0.0 1 0 0 1   0 0     0   0   1 0 0   0 0 1     0 1
2572623 WA Pierce   school 5301410 27400   Clover Park School District 530141003535 5411 CPSD Open Doors Program   Alternative School No High 09 12 2020   grade_10 0 0 0   0 0     0   1   1 0 0   0   0   0       0.0 1 0 0 0   0 0     0   1   1 0 0   0 0 0     0 1
2572662 WA Pierce   school 5301410 27400   Clover Park School District 530141003516 5387 Four Heroes Elementary   Regular School No Elementary PK 05 2020   grade_6 0 0 0   0 0     1   0   0 1 0   1   0   1       0.0 1 0 0 0   0 0     1   0   0 1 0   1 0 1     0 1
2572665 WA Pierce   school 5301410 27400   Clover Park School District 530141003516 5387 Four Heroes Elementary   Regular School No Elementary PK 05 2020   pre_kindergarten 0 0 2   0 0     0   0   1 1 0   2   0   1       0.0 2 0 0 2   0 0     0   0   1 1 0   2 0 1     0 2
2572706 WA Pierce   school 5301410 27400   Clover Park School District 530141000262 2652 Lakeview Hope Academy   Regular School No Elementary PK 05 2020   pre_kindergarten 0 1 0   0 0     0   1   1 1 0   0   1   2       0.0 2 0 1 0   0 0     0   1   1 1 0   0 1 2     0 2
2572724 WA Pierce   school 5301410 27400   Clover Park School District 530141001897 3910 Oak Grove   Regular School No Elementary KG 06 2020   grade_4 0 1 0   0 0     0   1   1 1 0   0   0   0       0.0 2 0 1 0   0 0     0   1   1 1 0   0 0 0     0 2
2572737 WA Pierce   school 5301410 27400   Clover Park School District 530141003402 5298 Oakridge Group Home   Regular School No High 09 12 2020   grade_12 0 0 1   0 0     0   0   1 0 0   0   0   1       0.0 1 0 0 1   0 0     0   0   1 0 0   0 0 1     0 1
2572755 WA Pierce   school 5301410 27400   Clover Park School District 530141002860 1880 Re-Entry High School   Alternative School No High 09 12 2020   grade_10 0 0 0   0 0     0   1   1 0 0   0   0   1       0.0 1 0 0 0   0 0     0   1   1 0 0   0 0 1     0 1
2572756 WA Pierce   school 5301410 27400   Clover Park School District 530141002860 1880 Re-Entry High School   Alternative School No High 09 12 2020   pk_12_total 0 0 0   0 0     0   1   1 0 0   0   0   1       0.0 1 0 0 0   0 0     0   1   1 0 0   0 0 1     0 1
2572758 WA Pierce   school 5301410 27400   Clover Park School District 530141002862 1882 Special Education Services/relife   Special Education School No Other PK 12 2020   grade_3 0 1 0   0 0     0   0   1 0 0   0   0   1       0.0 1 0 1 0   0 0     0   0   1 0 0   0 0 1     0 1
2572761 WA Pierce   school 5301410 27400   Clover Park School District 530141002862 1882 Special Education Services/relife   Special Education School No Other PK 12 2020   grade_9 0 1 0   0 0     0   0   1 0 0   0   0   1       0.0 1 0 1 0   0 0     0   0   1 0 0   0 0 1     0 1
2572778 WA Pierce   school 5301410 27400   Clover Park School District 530141003396 5297 Transition Day Students   Regular School No Other 04 12 2020   grade_6 0 0 0   0 0     0   2   2 0 0   0   0   1       0.0 2 0 0 0   0 0     0   2   2 0 0   0 0 1     0 2
2572779 WA Pierce   school 5301410 27400   Clover Park School District 530141003396 5297 Transition Day Students   Regular School No Other 04 12 2020   grade_7 0 0 0   0 0     0   1   1 0 0   0   0   1       0.0 1 0 0 0   0 0     0   1   1 0 0   0 0 1     0 1
2572811 WA Walla Walla   school 5301470 36250   College Place School District 530147003684 5575 College Place Open Doors Program   Alternative School No High 09 12 2020   grade_10 0 0 2   0 0     0   0   1 1 0   1   0   2       0.0 2 0 0 2   0 0     0   0   1 1 0   1 0 2     0 2
2572913 WA Skagit   school 5301660 29011   Concrete School District 530166000285 2577 Concrete Elementary   Regular School No Elementary KG 06 2020   pre_kindergarten 0 0 0   0 0     0   1   1 0 0   0   1   1       0.0 1 0 0 0   0 0     0   1   1 0 0   0 1 1     0 1
2572924 WA Skagit   school 5301660 29011   Concrete School District 530166000084 1605 Twin Cedars High School   Alternative School No High 07 12 2020   grade_11 0 0 0   0 0     0   1   1 0 0   0   0   0       0.0 1 0 0 0   0 0     0   1   1 0 0   0 0 0     0 1
2573042 WA Pend Oreille   school 5301920 26059   Cusick School District 530192000296 2770 Bess Herian Elementary   Regular School No Elementary KG 05 2020   pre_kindergarten 0 2 0   1 0     0   0   1 2 0   0   0   0       0.0 3 0 2 0   1 0     0   0   1 2 0   0 0 0     0 3
2573125 WA Spokane   school 5302070 32414   Deer Park School District 530207000307 2430 Deer Park Elementary   Regular School No Elementary KG 02 2020   pre_kindergarten 0 0 0   1 0     0   0   1 0 0   0   0   1       0.0 1 0 0 0   1 0     0   0   1 0 0   0 0 1     0 1
2573170 WA Walla Walla   school 5302160 36101   Dixie School District 530216000311 2278 Dixie Elementary School   Regular School No Elementary PK 05 2020   grade_7 0 0 1   0 0     0   0   0 1 0   0   0   1       0.0 1 0 0 1   0 0     0   0   0 1 0   0 0 1     0 1
2573279 WA Yakima   school 5305370 39090   East Valley School District (Yakima) 530537000807 2530 Moxee Elementary   Regular School No Elementary KG 05 2020   pre_kindergarten 0 0 1   0 0     0   0   1 0 0   1   0   1       0.0 1 0 0 1   0 0     0   0   1 0 0   1 0 1     0 1
2573431 WA Snohomish   school 5302400 31015   Edmonds School District 530240000331 3536 Brier Elementary   Regular School No Elementary KG 06 2020   grade_7 0 0 0   0 1     0   0   1 0 0   0   0   0       0.0 1 0 0 0   0 1     0   0   1 0 0   0 0 0     0 1
2573478 WA Snohomish   school 5302400 31015   Edmonds School District 530240000336 3691 College Place Elementary   Regular School No Elementary KG 06 2020   pre_kindergarten 0 1 0   0 0     0   0   0 1 0   0   0   1       0.0 1 0 1 0   0 0     0   0   0 1 0   0 0 1     0 1
2573485 WA Snohomish   school 5302400 31015   Edmonds School District 530240002821 1830 Contracted Schools   Special Education School No Other PK 12 2020   grade_1 0 1 0   0 0     0   0   1 0 0   0   0   0       0.0 1 0 1 0   0 0     0   0   1 0 0   0 0 0     0 1
2573486 WA Snohomish   school 5302400 31015   Edmonds School District 530240002821 1830 Contracted Schools   Special Education School No Other PK 12 2020   grade_3 0 0 1   0 0     0   0   1 0 0   1   0   0       0.0 1 0 0 1   0 0     0   0   1 0 0   1 0 0     0 1
2573487 WA Snohomish   school 5302400 31015   Edmonds School District 530240002821 1830 Contracted Schools   Special Education School No Other PK 12 2020   grade_6 0 0 0   0 0     0   1   0 1 0   0   0   0       0.0 1 0 0 0   0 0     0   1   0 1 0   0 0 0     0 1
2573488 WA Snohomish   school 5302400 31015   Edmonds School District 530240002821 1830 Contracted Schools   Special Education School No Other PK 12 2020   grade_7 0 0 1   0 0     0   0   1 0 0   0   0   1       0.0 1 0 0 1   0 0     0   0   1 0 0   0 0 1     0 1
2573489 WA Snohomish   school 5302400 31015   Edmonds School District 530240002821 1830 Contracted Schools   Special Education School No Other PK 12 2020   grade_8 0 0 0   0 0     0   1   1 0 0   0   0   0       0.0 1 0 0 0   0 0     0   1   1 0 0   0 0 0     0 1
2573492 WA Snohomish   school 5302400 31015   Edmonds School District 530240002821 1830 Contracted Schools   Special Education School No Other PK 12 2020   kindergarten 0 0 1   0 0     0   0   0 1 0   0   0   0       0.0 1 0 0 1   0 0     0   0   0 1 0   0 0 0     0 1
2573566 WA Snohomish   school 5302400 31015   Edmonds School District 530240000344 3503 Lynnwood Elementary   Regular School No Elementary KG 06 2020   pre_kindergarten 0 0 0   0 1     0   0   0 1 0   0   0   0       0.0 1 0 0 0   0 1     0   0   0 1 0   0 0 0     0 1
2573671 WA Snohomish   school 5302400 31015   Edmonds School District 530240000362 3410 Spruce Elementary   Regular School No Elementary KG 06 2020   pre_kindergarten 0 0 0   0 0     0   1   0 1 0   0   0   0       0.0 1 0 0 0   0 0     0   1   0 1 0   0 0 0     0 1
2573682 WA Snohomish   school 5302400 31015   Edmonds School District 530240002290 1558 Unassigned School   Special Education School No Other PK 09 2020   grade_12 0 0 0   0 1     0   0   0 1 0   0   0   0       0.0 1 0 0 0   0 1     0   0   0 1 0   0 0 0     0 1
2573820 WA King   school 5300001 17216   Enumclaw School District 530000103038 1523 Special Ed School   Special Education School No Other PK 12 2020   grade_12 0 0 1   0 0     0   0   0 1 0   0   0   0       0.0 1 0 0 1   0 0     0   0   0 1 0   0 0 0     0 1
2573823 WA King   school 5300001 17216   Enumclaw School District 530000103038 1523 Special Ed School   Special Education School No Other PK 12 2020   grade_4 0 0 1   0 0     0   0   1 0 0   0   0   0       0.0 1 0 0 1   0 0     0   0   1 0 0   0 0 0     0 1
2573848 WA Grant   school 5302610 13165   Ephrata School District 530261002934 4229 Beezley Springs Elementary   Special Education School No Elementary PK 01 2020   grade_3 0 0 1   0 0     0   0   1 0 0   0   0   0       0.0 1 0 0 1   0 0     0   0   1 0 0   0 0 0     0 1
2573860 WA Grant   school 5302610 13165   Ephrata School District 530261000384 2793 Columbia Ridge Elementary   Regular School No Elementary KG 04 2020   pre_kindergarten 0 0 1   0 0     0   0   1 0 0   0   0   1       0.0 1 0 0 1   0 0     0   0   1 0 0   0 0 1     0 1
2573864 WA Grant   school 5302610 13165   Ephrata School District 530261000386 2920 Ephrata High School   Regular School No High 09 12 2020   grade_7 0 0 0   0 0     0   1   1 0 0   0   0   0       0.0 1 0 0 0   0 0     0   1   1 0 0   0 0 0     0 1

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