Data source: Big Local News · About: Big Local

4,126 rows where grade = "grade_9" and state = "WA" sorted by ccd_school_high_grade

View and edit SQL

year

grade

  • grade_9 · 4,126
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
463311 WA Clark   school   6801   ESD 112 acting as a school district   3294 Cowlitz County Youth Services Center             2015   grade_9 2 0 2   0 0     0   0   3 1 0   0   0   3       0.0 4 2 0 2   0 0     0   0   3 1 0   0 0 3     0 4
466571 WA Whatcom   school   37903   Lummi Tribal Agency   5373 Lummi Nation School             2015   grade_9 0 0 2   15 0     0   0   6 11 0   0   0   17       0.0 17 0 0 2   15 0     0   0   6 11 0   0 0 17     0 17
467645 WA King   school   17903   Muckleshoot Indian Tribe   1986 Muckleshoot Tribal School             2015   grade_9 0 0 0   30 0     0   0   15 15 0   0   0   14       2.0 30 0 0 0   30 0     0   0   15 15 0   0 0 14     2 30
469019 WA Okanogan   school   24019   Omak School District   4278 Paschal Sherman             2015   grade_9 0 0 0   7 0     0   0   5 2 0   0   0   7       0.0 7 0 0 0   7 0     0   0   5 2 0   0 0 7     0 7
469773 WA Pierce   school   27003   Puyallup School District   4110 Chief Leschi Schools(Closed)             2015   grade_9 1 2 4   50 0     0   2   36 23 0   0   5   34       2.0 59 1 2 4   50 0     0   2   36 23 0   0 5 34     2 59
470101 WA Clallam   school   5402   Quillayute Valley School District   4174 Quileute Tribal School(Closed)             2015   grade_9 0 0 0   3 0     0   0   2 1 0   0   0   1       0.0 3 0 0 0   3 0     0   0   2 1 0   0 0 1     0 3
474776 WA Stevens   school   33049   Wellpinit School District #49   5957 WSD - Yakama Nation(Closed)             2015   grade_9 0 0 1   23 0     0   0   12 12 0   10   0   11       0.0 24 0 0 1   23 0     0   0   12 12 0   10 0 11     0 24
526534 WA Whatcom   school   37903   Lummi Tribal Agency   5373 Lummi Nation School             2016   grade_9 0 0 1   14 0     0   0   10 5 0   0   0   10       0.0 15 0 0 1   14 0     0   0   10 5 0   0 0 10     0 15
527563 WA King   school   17903   Muckleshoot Indian Tribe   1986 Muckleshoot Tribal School             2016   grade_9 0 0 0   25 0     0   0   15 10 0   0   0   21       0.0 25 0 0 0   25 0     0   0   15 10 0   0 0 21     0 25
528910 WA Okanogan   school   24019   Omak School District   4278 Paschal Sherman             2016   grade_9 0 0 0   7 0     0   0   2 5 0   0   0   7       0.0 7 0 0 0   7 0     0   0   2 5 0   0 0 7     0 7
529705 WA Pierce   school   27003   Puyallup School District   4110 Chief Leschi Schools(Closed)             2016   grade_9 1 1 1   53 0     0   3   32 27 0   0   0   23       2.0 59 1 1 1   53 0     0   3   32 27 0   0 0 23     2 59
530034 WA Clallam   school   5402   Quillayute Valley School District   4174 Quileute Tribal School(Closed)             2016   grade_9 0 0 0   2 0     0   1   1 2 0   0   0   1       0.0 3 0 0 0   2 0     0   1   1 2 0   0 0 1     0 3
623906 WA Whatcom   school   37903   Lummi Tribal Agency   5373 Lummi Nation School             2017   grade_9 0 0 2   20 0     0   1   15 8 0   0   0   22       0.0 23 0 0 2   20 0     0   1   15 8 0   0 0 22     0 23
624979 WA King   school   17903   Muckleshoot Indian Tribe   1986 Muckleshoot Tribal School             2017   grade_9 0 0 0   29 0     0   2   17 14 0   0   0   27       0.0 31 0 0 0   29 0     0   2   17 14 0   0 0 27     0 31
626336 WA Okanogan   school   24019   Omak School District   4278 Paschal Sherman             2017   grade_9 0 0 0   7 0     0   0   2 5 0   0   0   7       0.0 7 0 0 0   7 0     0   0   2 5 0   0 0 7     0 7
627139 WA Pierce   school   27003   Puyallup School District   4110 Chief Leschi Schools(Closed)             2017   grade_9 0 0 3   47 0     0   1   26 25 0   0   3   21       0.0 51 0 0 3   47 0     0   1   26 25 0   0 3 21     0 51
627430 WA Clallam   school   5903   Quileute Tribal School District   5430 Quileute Tribal School             2017   grade_9 1 0 0   5 0     0   0   4 2 0   0   0   5       0.0 6 1 0 0   5 0     0   0   4 2 0   0 0 5     0 6
2415117 WA Pierce   school   27901   Chief Leschi Schools   5549 Chief Leschi Schools             2019   grade_9 0 0 5   42 0     0   1   28 20 0   0   2   1       0.0 48 0 0 5   42 0     0   1   28 20 0   0 2 1     0 48
2419788 WA Whatcom   school   37903   Lummi Tribal Agency   5373 Lummi Nation School             2019   grade_9 1 0 1   23 0     0   4   20 9 0   0   2   26       0.0 29 1 0 1   23 0     0   4   20 9 0   0 2 26     0 29
2420793 WA King   school   17903   Muckleshoot Indian Tribe   1986 Muckleshoot Tribal School             2019   grade_9 0 0 4   26 0     0   0   11 19 0   0   0   20       1.0 30 0 0 4   26 0     0   0   11 19 0   0 0 20     1 30
2422080 WA Okanogan   school   24019   Omak School District   4278 Paschal Sherman             2019   grade_9 1 0 0   4 0     0   0   3 2 0   0   1   5       0.0 5 1 0 0   4 0     0   0   3 2 0   0 1 5     0 5
2423131 WA Clallam   school   5903   Quileute Tribal School District   5430 Quileute Tribal School             2019   grade_9 1 0 1   7 0     0   0   5 4 0   0   3   8       1.0 9 1 0 1   7 0     0   0   5 4 0   0 3 8     1 9
2460224 WA Pend Oreille   school   26059   Cusick School District   5538 Home Pride             2018   grade_9 6 0 0   0 0     0   0   0 6 0   0   0   0       0.0 6 6 0 0   0 0     0   0   0 6 0   0 0 0     0 6
2462833 WA Cowlitz   school   8402   Kalama School District   5545 Kalama High School             2018   grade_9 63 0 5   0 0     0   0   47 21 0   0   1   13       7.0 68 63 0 5   0 0     0   0   47 21 0   0 1 13     7 68
2464246 WA Whatcom   school   37903   Lummi Tribal Agency   5373 Lummi Nation School             2018   grade_9 1 0 0   20 0     0   4   10 15 0   0   0   23       0.0 25 1 0 0   20 0     0   4   10 15 0   0 0 23     0 25
2465258 WA King   school   17903   Muckleshoot Indian Tribe   1986 Muckleshoot Tribal School             2018   grade_9 1 0 1   30 0     0   0   20 12 0   0   0   20       2.0 32 1 0 1   30 0     0   0   20 12 0   0 0 20     2 32
2466544 WA Okanogan   school   24019   Omak School District   4278 Paschal Sherman             2018   grade_9 1 0 0   2 0     0   0   2 1 0   0   2   3       0.0 3 1 0 0   2 0     0   0   2 1 0   0 2 3     0 3
2467333 WA Pierce   school   27003   Puyallup School District   4110 Chief Leschi Schools(Closed)             2018   grade_9 0 0 2   34 0     0   1   17 20 0   0   2   0       0.0 37 0 0 2   34 0     0   1   17 20 0   0 2 0     0 37
2467626 WA Clallam   school   5903   Quileute Tribal School District   5430 Quileute Tribal School             2018   grade_9 1 0 0   2 0     0   1   3 1 0   0   0   3       0.0 4 1 0 0   2 0     0   1   3 1 0   0 0 3     0 4
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
2577136 WA Whatcom   school   37903   Lummi Tribal Agency   5373 Lummi Nation School             2020   grade_9 2 0 4   23 0     0   2   10 21 0   0   0   28       0.0 31 2 0 4   23 0     0   2   10 21 0   0 0 28     0 31
2578133 WA King   school   17903   Muckleshoot Indian Tribe   1986 Muckleshoot Tribal School             2020   grade_9 0 0 2   32 0     0   2   23 13 0   0   0   25       0.0 36 0 0 2   32 0     0   2   23 13 0   0 0 25     0 36
2580500 WA Clallam   school   5903   Quileute Tribal School District   5430 Quileute Tribal School             2020   grade_9 1 0 2   6 0     0   1   4 6 0   0   0   9       1.0 10 1 0 2   6 0     0   1   4 6 0   0 0 9     1 10
2933373 WA Pierce   school   27901   Chief Leschi Schools   5549 Chief Leschi Schools             2021   grade_9 0 0 4   45 0     0   4   30 23 0   0   0   27       1.0 53 0 0 4   45 0     0   4   30 23 0   0 0 27     1 53
2938017 WA Whatcom   school   37903   Lummi Tribal Agency   5373 Lummi Nation School             2021   grade_9 0 0 0   30 0     0   0   16 14 0   0   0   24       0.0 30 0 0 0   30 0     0   0   16 14 0   0 0 24     0 30
2939014 WA King   school   17903   Muckleshoot Indian Tribe   1986 Muckleshoot Tribal School             2021   grade_9 0 0 6   30 0     0   1   24 13 0   0   0   27       0.0 37 0 0 6   30 0     0   1   24 13 0   0 0 27     0 37
2941482 WA Clallam   school   5903   Quileute Tribal School District   5430 Quileute Tribal School             2021   grade_9 0 0 2   7 0     0   0   4 5 0   0   0   8       0.0 9 0 0 2   7 0     0   0   4 5 0   0 0 8     0 9
2584831 WA King   school 5309300 17402   Vashon Island School District 530930001394 4468 Chautauqua Elementary   Regular School No Elementary PK 05 2020   grade_9 1 0 0   0 0     0   0   0 1 0   0   0   1       0.0 1 1 0 0   0 0     0   0   0 1 0   0 0 1     0 1
2942211 WA San Juan   school 5307650 28149   San Juan Island School District 530765001798 2520 Friday Harbor Elementary School   Regular School No Elementary PK 05 2021   grade_9 1 0 0   0 0     0   0   1 0 0   0   0   0       0.0 1 1 0 0   0 0     0   0   1 0 0   0 0 0     0 1
472217 WA Kitsap   school 5308160 18402   South Kitsap School District 530816001347 2641 East Port Orchard Elementary   Regular School No 1.0 KG 06 2015   grade_9 1 0 0   0 0     0   0   1 0 0   0   0   0       0.0 1 1 0 0   0 0     0   0   1 0 0   0 0 0     0 1
620022 WA Douglas   school 5302310 9206   Eastmont School District 530231002948 4590 Clovis Point Intermediate School   Regular School No Middle 05 07 2017   grade_9 1 0 0   0 0     0   0   1 0 0   0   0   0       0.0 1 1 0 0   0 0     0   0   1 0 0   0 0 0     0 1
2460514 WA Douglas   school 5302310 9206   Eastmont School District 530231001762 4095 Sterling School   Regular School No Elementary KG 07 2018   grade_9 1 0 0   0 0     0   0   1 0 0   0   0   1       0.0 1 1 0 0   0 0     0   0   1 0 0   0 0 1     0 1
462431 WA Snohomish   school 5301980 31330   Darrington School District 530198000300 3609 Darrington Elementary School   Regular School No 1.0 PK 08 2015   grade_9 1 0 0   0 0     0   0   1 0 0   0   0   1       0.0 1 1 0 0   0 0     0   0   1 0 0   0 0 1     0 1
463480 WA Snohomish   school 5302670 31002   Everett School District 530267000399 2364 North Middle School   Regular School No 2.0 06 08 2015   grade_9 0 0 0   0 0     1   0   1 0 0   1   0   1       0.0 1 0 0 0   0 0     1   0   1 0 0   1 0 1     0 1
464024 WA King   school 5302820 17210   Federal Way School District 530282001376 4456 Saghalie Middle School (Closed after 2016-2017 school year)   Regular School No 2.0 06 08 2015   grade_9 0 0 0   0 0     1   0   1 0 0   0   0   1       0.0 1 0 0 0   0 0     1   0   1 0 0   0 0 1     0 1
464188 WA Whatcom   school 5302850 37502   Ferndale School District 530285000463 3762 Vista Middle School   Regular School No 2.0 06 08 2015   grade_9 1 0 0   0 0     0   0   1 0 0   0   0   1       0.0 1 1 0 0   0 0     0   0   1 0 0   0 0 1     0 1
464487 WA Yakima   school 5303180 39204   Granger School District 530318000504 2531 Granger Middle School   Regular School No 2.0 05 08 2015   grade_9 0 0 7   0 0     0   0   5 2 0   2   0   7       0.0 7 0 0 7   0 0     0   0   5 2 0   2 0 7     0 7
467035 WA Spokane   school 5304920 32354   Mead School District 530492000747 3191 Mountainside Middle School   Regular School No 2.0 07 08 2015   grade_9 1 0 0   0 0     0   0   0 1 0   0   0   0       0.0 1 1 0 0   0 0     0   0   0 1 0   0 0 0     0 1
467109 WA King   school 5304980 17400   Mercer Island School District 530498000764 3219 Islander Middle School   Regular School No 2.0 06 08 2015   grade_9 1 0 0   0 0     0   0   1 0 0   0   0   0       0.0 1 1 0 0   0 0     0   0   1 0 0   0 0 0     0 1
467344 WA Grant   school 5305220 13161   Moses Lake School District 530522000785 3022 Chief Moses Middle School   Regular School No 2.0 06 08 2015   grade_9 1 0 0   0 0     0   0   0 1 0   0   0   1       0.0 1 1 0 0   0 0     0   0   0 1 0   0 0 1     0 1
468131 WA Mason   school 5305790 23403   North Mason School District 530579000860 3174 Hawkins Middle School   Regular School No 2.0 06 08 2015   grade_9 1 0 0   0 0     0   0   0 1 0   0   0   0       0.0 1 1 0 0   0 0     0   0   0 1 0   0 0 0     0 1
470623 WA Spokane   school 5307440 32416   Riverside School District 530744001114 3466 Riverside Middle School   Regular School No 2.0 06 08 2015   grade_9 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
473368 WA Pierce   school 5308700 27010   Tacoma School District 530870001471 2377 Gray   Regular School No 2.0 06 08 2015   grade_9 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
473852 WA Yakima   school 5308970 39202   Toppenish School District 530897001535 2264 Toppenish Middle School   Regular School No 2.0 06 08 2015   grade_9 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
474126 WA Stevens   school 5309240 33070   Valley School District 530924001555 2405 Valley School   Regular School No 1.0 KG 08 2015   grade_9 2 0 0   0 0     0   0   1 1 0   0   0   2       0.0 2 2 0 0   0 0     0   0   1 1 0   0 0 2     0 2
474493 WA Grant   school 5309360 13073   Wahluke School District 530936003264 5144 Wahluke Junior High   Regular School No 2.0 06 08 2015   grade_9 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
524778 WA King   school 5303540 17401   Highline School District 530354000554 2927 Sylvester Middle School   Regular School No 2 07 08 2016   grade_9 1 0 0   0 0     0   0   0 1 0   0   0   1       1.0 1 1 0 0   0 0     0   0   0 1 0   0 0 1     1 1
619911 WA Spokane   school 5302280 32361   East Valley School District (Spokane) 530228003494 5346 East Valley Middle School   Regular School No Middle 07 08 2017   grade_9 1 0 0   0 0     0   0   0 1 0   0   0   1       0.0 1 1 0 0   0 0     0   0   0 1 0   0 0 1     0 1
619975 WA Yakima   school 5305370 39090   East Valley School District (Yakima) 530537000806 4055 East Valley Central Middle School   Regular School No Middle 06 08 2017   grade_9 1 0 0   0 0     0   0   0 1 0   0   0   0       0.0 1 1 0 0   0 0     0   0   0 1 0   0 0 0     0 1
620551 WA King   school 5300001 17216   Enumclaw School District 530000102054 4210 Enumclaw Middle School   Regular School No Middle 06 08 2017   grade_9 1 0 2   0 0     0   1   1 3 0   0   0   3       0.0 4 1 0 2   0 0     0   1   1 3 0   0 0 3     0 4
620940 WA Clark   school 5302700 6114   Evergreen School District (Clark) 530270000414 3785 Cascade Middle School   Regular School No Middle 06 08 2017   grade_9 1 0 0   0 0     0   0   1 0 0   0   0   1       0.0 1 1 0 0   0 0     0   0   1 0 0   0 0 1     0 1
624435 WA King   school 5304980 17400   Mercer Island School District 530498000764 3219 Islander Middle School   Regular School No Middle 06 08 2017   grade_9 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
626326 WA Okanogan   school 5306220 24019   Omak School District 530622001912 4237 Omak Middle School   Regular School No Middle 06 08 2017   grade_9 0 0 0   1 0     0   0   1 0 0   0   0   0       0.0 1 0 0 0   1 0     0   0   1 0 0   0 0 0     0 1
626990 WA Clallam   school 5306820 5121   Port Angeles School District 530682001004 3318 Stevens Middle School   Regular School No Middle 07 08 2017   grade_9 1 0 0   0 0     0   0   0 1 0   0   0   0       0.0 1 1 0 0   0 0     0   0   0 1 0   0 0 0     0 1
627504 WA Grant   school 5307080 13144   Quincy School District 530708001056 2510 Quincy Middle School   Regular School No Middle 07 08 2017   grade_9 2 0 0   0 0     0   0   1 1 0   0   0   1       0.0 2 2 0 0   0 0     0   0   1 1 0   0 0 1     0 2
628873 WA King   school 5307710 17001   Seattle School District No. 1 530771001264 3277 Whitman Middle School   Regular School No Middle 06 08 2017   grade_9 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
630727 WA Pierce   school 5308700 27010   Tacoma School District 530870001473 2338 Jason Lee   Regular School No Middle 06 08 2017   grade_9 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
2416083 WA Snohomish   school 5302400 31015   Edmonds School District 530240000329 3560 Alderwood Middle School   Regular School No Middle 07 08 2019   grade_9 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
2416473 WA King   school 5300001 17216   Enumclaw School District 530000102054 4210 Enumclaw Middle School   Regular School No Middle 06 08 2019   grade_9 1 0 0   0 0     0   0   0 1 0   0   0   0       0.0 1 1 0 0   0 0     0   0   0 1 0   0 0 0     0 1
2416539 WA Grant   school 5302610 13165   Ephrata School District 530261000387 3373 Ephrata Middle School   Regular School No Middle 07 08 2019   grade_9 1 0 0   0 0     0   0   0 1 0   0   0   1       0.0 1 1 0 0   0 0     0   0   0 1 0   0 0 1     0 1
2418034 WA King   school 5303540 17401   Highline School District 530354000554 2927 Sylvester Middle School   Regular School No Middle 07 08 2019   grade_9 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
2420044 WA Snohomish   school 5304860 31025   Marysville School District 530486000736 3355 Marysville Middle School   Regular School No Middle 06 08 2019   grade_9 1 0 0   0 0     0   0   0 1 0   0   0   1       0.0 1 1 0 0   0 0     0   0   0 1 0   0 0 1     0 1
2420846 WA Snohomish   school 5305430 31006   Mukilteo School District 530543001185 4430 Harbour Pointe Middle School   Regular School No Middle 06 08 2019   grade_9 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
2423210 WA Grant   school 5307080 13144   Quincy School District 530708001056 2510 Quincy Middle School   Regular School No Middle 07 08 2019   grade_9 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
2423376 WA King   school 5307230 17403   Renton School District 530723001079 3035 McKnight Middle School   Regular School No Middle 06 08 2019   grade_9 1 0 0   0 0     0   0   0 1 0   0   0   1       0.0 1 1 0 0   0 0     0   0   0 1 0   0 0 1     0 1
2426608 WA Pierce   school 5308700 27010   Tacoma School District 530870001504 2359 Stewart   Regular School No Middle 06 08 2019   grade_9 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
2426705 WA King   school 5308760 17409   Tahoma School District 530876001515 3937 Maple View Middle School   Regular School No Middle 06 08 2019   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
2426774 WA Thurston   school 5308820 34402   Tenino School District 530882001523 3795 Tenino Middle School   Regular School No Middle 06 08 2019   grade_9 1 0 0   0 0     0   0   1 0 0   0   0   1       0.0 1 1 0 0   0 0     0   0   1 0 0   0 0 1     0 1
2427119 WA Stevens   school 5309240 33070   Valley School District 530924003107 1932 Columbia Virtual Academy   Alternative School No Elementary KG 08 2019   grade_9 2 0 0   0 0     0   0   2 0 0   0   0   0       0.0 2 2 0 0   0 0     0   0   2 0 0   0 0 0     0 2
2458701 WA Pierce   school 5300480 27403   Bethel School District 530048000128 3751 Spanaway Middle School   Regular School No Middle 06 08 2018   grade_9 1 0 0   0 0     0   0   0 1 0   0   0   1       0.0 1 1 0 0   0 0     0   0   0 1 0   0 0 1     0 1
2460038 WA Stevens   school 5301630 33115   Colville School District 530163000283 3831 Colville Junior High School   Regular School No Middle 06 08 2018   grade_9 1 0 0   0 0     0   0   1 0 0   0   0   1       0.0 1 1 0 0   0 0     0   0   1 0 0   0 0 1     0 1
2460539 WA Pierce   school 5302370 27404   Eatonville School District 530237000325 2808 Columbia Crest A-STEM Academy   Regular School No Elementary KG 08 2018   grade_9 1 0 0   0 0     0   0   1 0 0   0   0   0       0.0 1 1 0 0   0 0     0   0   1 0 0   0 0 0     0 1
2460888 WA Kittitas   school 5302460 19401   Ellensburg School District 530246000367 2453 Morgan Middle School   Regular School No Middle 06 08 2018   grade_9 1 0 0   0 0     0   0   1 0 0   0   0   1       0.0 1 1 0 0   0 0     0   0   1 0 0   0 0 1     0 1
2460977 WA King   school 5300001 17216   Enumclaw School District 530000102054 4210 Enumclaw Middle School   Regular School No Middle 06 08 2018   grade_9 1 0 0   0 0     0   0   1 0 0   0   0   0       0.0 1 1 0 0   0 0     0   0   1 0 0   0 0 0     0 1
2461011 WA King   school 5300001 17216   Enumclaw School District 530000102795 4550 Thunder Mountain Middle School   Regular School No Middle 06 08 2018   grade_9 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
2465173 WA Skagit   school 5305400 29320   Mount Vernon School District 530540000810 3821 La Venture Middle School   Regular School No Middle 06 08 2018   grade_9 1 0 0   0 0     0   0   1 0 0   0   0   0       0.0 1 1 0 0   0 0     0   0   1 0 0   0 0 0     0 1
2465484 WA Pend Oreille   school 5305610 26056   Newport School District 530561001911 3968 Sadie Halstead Middle School   Regular School No Middle 05 08 2018   grade_9 1 0 0   0 0     0   0   0 1 0   0   0   0       0.0 1 1 0 0   0 0     0   0   0 1 0   0 0 0     0 1
2465555 WA Grays Harbor   school 5305700 14064   North Beach School District No. 64 530570002039 3788 North Beach Junior High School   Regular School No Middle 07 08 2018   grade_9 1 0 0   0 0     0   0   0 1 0   0   0   0       0.0 1 1 0 0   0 0     0   0   0 1 0   0 0 0     0 1
2466629 WA San Juan   school 5306300 28137   Orcas Island School District 530630002815 4558 Orcas Island Middle School   Regular School No Middle 06 08 2018   grade_9 1 0 0   0 0     0   0   0 1 0   0   0   0       0.0 1 1 0 0   0 0     0   0   0 1 0   0 0 0     0 1
2570796 WA Clark   school 5300380 6119   Battle Ground School District 530038003262 5133 Chief Umtuch Middle   Regular School No Middle 05 08 2020   grade_9 1 0 0   0 0     0   0   1 0 0   0   0   0       0.0 1 1 0 0   0 0     0   0   1 0 0   0 0 0     0 1
2573257 WA Yakima   school 5305370 39090   East Valley School District (Yakima) 530537000806 4055 East Valley Central Middle School   Regular School No Middle 06 08 2020   grade_9 1 0 0   0 0     0   0   1 0 0   1   0   1       0.0 1 1 0 0   0 0     0   0   1 0 0   1 0 1     0 1
2573838 WA King   school 5300001 17216   Enumclaw School District 530000102795 4550 Thunder Mountain Middle School   Regular School No Middle 06 08 2020   grade_9 1 0 0   0 0     0   0   1 0 0   0   0   0       0.0 1 1 0 0   0 0     0   0   1 0 0   0 0 0     0 1
2574977 WA Klickitat   school 5303090 20404   Goldendale School District 530309000491 3393 Goldendale Middle School   Regular School No Middle 05 08 2020   grade_9 1 0 0   0 0     0   0   0 1 0   0   0   1       0.0 1 1 0 0   0 0     0   0   0 1 0   0 0 1     0 1
2577331 WA Snohomish   school 5304860 31025   Marysville School District 530486002425 4357 Cedarcrest School   Regular School No Middle 06 08 2020   grade_9 0 0 0   0 1     0   0   0 1 0   0   0   1       0.0 1 0 0 0   0 1     0   0   0 1 0   0 0 1     0 1
2579532 WA Ferry   school 5306360 10065   Orient School District 530636000948 2136 Orient Elementary School   Regular School No Elementary KG 08 2020   grade_9 1 0 0   0 0     0   0   1 0 0   0   0   1       0.0 1 1 0 0   0 0     0   0   1 0 0   0 0 1     0 1
2579613 WA Adams   school 5306480 1147   Othello School District 530648000956 3471 McFarland Middle School   Regular School No Middle 06 08 2020   grade_9 0 0 3   0 0     0   0   3 0 0   0   0   3       0.0 3 0 0 3   0 0     0   0   3 0 0   0 0 3     0 3
2580594 WA Grant   school 5307080 13144   Quincy School District 530708001056 2510 Quincy Middle School   Regular School No Middle 06 08 2020   grade_9 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
2583308 WA Snohomish   school 5308340 31401   Stanwood-Camano School District 530834003223 5108 Lincoln Academy   Alternative School No Middle 06 08 2020   grade_9 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
2933169 WA Lewis   school 5301140 21401   Centralia School District 530114000205 3240 Centralia Middle School   Regular School No Middle 07 08 2021   grade_9 0 0 1   0 0     0   0   1 0 0   1   1   0       0.0 1 0 0 1   0 0     0   0   1 0 0   1 1 0     0 1
2938072 WA Whatcom   school 5304620 37504   Lynden School District 530462000721 2219 Lynden Middle School   Regular School No Middle 06 08 2021   grade_9 1 0 0   0 0     0   0   0 1 0   0   0   0       0.0 1 1 0 0   0 0     0   0   0 1 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]);