Data source: Big Local News · About: Big Local

4,126 rows where grade = "grade_9" and state = "WA" sorted by ccd_school_low_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
468832 WA Okanogan   school 5306150 24105   Okanogan School District 530615003247 5151 Okanogan Outreach Alternative School   Alternative Education School No 4.0 01 12 2015   grade_9 2 0 0   1 0     0   0   2 1 0   0   0   3       0.0 3 2 0 0   1 0     0   0   2 1 0   0 0 3     0 3
2582167 WA Clallam   school 5307830 5323   Sequim School District 530783002552 1708 Olympic Peninsula Academy   Alternative School No Other 01 12 2020   grade_9 7 0 1   0 0     0   1   5 4 0   0   0   2       0.0 9 7 0 1   0 0     0   1   5 4 0   0 0 2     0 9
460182 WA Clark   school 5300380 6119   Battle Ground School District 530038002782 1836 CAM Academy   Alternative Education School No 4.0 03 12 2015   grade_9 50 0 4   0 4     0   4   30 32 0   1   0   10       2.0 62 50 0 4   0 4     0   4   30 32 0   1 0 10     2 62
463304 WA Clark   school 5300005 6801   ESD 112 acting as a school district 530000503407 5290 Clark County Juvenile Detention School   Alternative Education School No 4.0 03 12 2015   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
472684 WA Spokane   school 5308250 32081   Spokane School District 530825002364 1567 Pratt Academy   Alternative Education School No 4.0 03 12 2015   grade_9 1 0 1   0 0     0   2   2 2 0   0   0   4       2.0 4 1 0 1   0 0     0   2   2 2 0   0 0 4     2 4
520161 WA Clark   school 5300380 6119   Battle Ground School District 530038002782 1836 CAM Academy   Alternative Education School No 4 03 12 2016   grade_9 71 0 1   0 1     0   0   38 35 0   0   0   11       2.0 73 71 0 1   0 1     0   0   38 35 0   0 0 11     2 73
523277 WA Clark   school 5300005 6801   ESD 112 acting as a school district 530000503407 5290 Clark County Juvenile Detention School   Regular School No 4 03 12 2016   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
529110 WA Adams   school 5306480 1147   Othello School District 530648000957 3015 Othello High School   Regular School No 4 03 12 2016   grade_9 27 0 255   0 2     0   2   134 152 0   75   4   244       7.0 286 27 0 255   0 2     0   2   134 152 0   75 4 244     7 286
532330 WA Kitsap   school 5308160 18402   South Kitsap School District 530816001357 2272 South Kitsap High School   Regular School No 4 03 12 2016   grade_9 3 0 0   0 0     0   0   3 0 0   0   0   1       0.0 3 3 0 0   0 0     0   0   3 0 0   0 0 1     0 3
532692 WA Spokane   school 5308250 32081   Spokane School District 530825002364 1567 Pratt Academy   Alternative Education School No 4 03 12 2016   grade_9 2 0 1   0 0     0   3   6 0 0   0   3   6       2.0 6 2 0 1   0 0     0   3   6 0 0   0 3 6     2 6
534741 WA Chelan   school 5309660 4246   Wenatchee School District 530966002706 1802 Chelan County Juvenile Detention Center   Regular School No 4 03 12 2016   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
617518 WA Clark   school 5300380 6119   Battle Ground School District 530038002782 1836 CAM Academy   Alternative School No Other 03 12 2017   grade_9 47 0 5   0 0     0   3   28 27 0   0   0   13       1.0 55 47 0 5   0 0     0   3   28 27 0   0 0 13     1 55
620662 WA Clark   school 5300005 6801   ESD 112 acting as a school district 530000503407 5290 Clark County Juvenile Detention School   Regular School No Other 03 12 2017   grade_9 1 0 0   1 0     0   0   2 0 0   0   0   0       0.0 2 1 0 0   1 0     0   0   2 0 0   0 0 0     0 2
630034 WA Spokane   school 5308250 32081   Spokane School District 530825002364 1567 Pratt Academy   Alternative School No Other 03 12 2017   grade_9 2 0 0   0 0     0   2   4 0 0   0   0   4       1.0 4 2 0 0   0 0     0   2   4 0 0   0 0 4     1 4
632076 WA Chelan   school 5309660 4246   Wenatchee School District 530966002706 1802 Chelan County Juvenile Detention Center   Regular School No Other 03 12 2017   grade_9 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
2413015 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003003633 5514 Grays Harbor Academy   Alternative School No Other 03 12 2019   grade_9 0 0 0   1 0     0   0   1 0 0   0   1   0       0.0 1 0 0 0   1 0     0   0   1 0 0   0 1 0     0 1
2413468 WA Clark   school 5300380 6119   Battle Ground School District 530038002782 1836 CAM Academy   Alternative School No Other 03 12 2019   grade_9 48 0 0   0 3     0   3   30 24 0   3   0   10       1.0 54 48 0 0   0 3     0   3   30 24 0   3 0 10     1 54
2416579 WA Clark   school 5300005 6801   ESD 112 acting as a school district 530000503407 5290 Clark County Juvenile Detention School   Regular School No Other 03 12 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
2425713 WA Spokane   school 5308250 32081   Spokane School District 530825002364 1567 Pratt Academy   Alternative School No Other 03 12 2019   grade_9 6 0 0   0 0     0   1   6 1 0   0   0   6       1.0 7 6 0 0   0 0     0   1   6 1 0   0 0 6     1 7
2458020 WA Clark   school 5300380 6119   Battle Ground School District 530038002782 1836 CAM Academy   Alternative School No Other 03 12 2018   grade_9 42 0 1   0 2     0   3   23 25 0   1   0   9       4.0 48 42 0 1   0 2     0   3   23 25 0   1 0 9     4 48
2461086 WA Clark   school 5300005 6801   ESD 112 acting as a school district 530000503407 5290 Clark County Juvenile Detention School   Regular School No Other 03 12 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
2470232 WA Spokane   school 5308250 32081   Spokane School District 530825002364 1567 Pratt Academy   Alternative School No Other 03 12 2018   grade_9 5 0 0   0 0     0   2   7 0 0   0   1   6       4.0 7 5 0 0   0 0     0   2   7 0 0   0 1 6     4 7
2570326 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003003633 5514 Grays Harbor Academy   Alternative School No Other 03 12 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
2570783 WA Clark   school 5300380 6119   Battle Ground School District 530038002782 1836 CAM Academy   Alternative School No Other 03 12 2020   grade_9 58 0 1   0 1     0   3   36 27 0   1   0   14       2.0 63 58 0 1   0 1     0   3   36 27 0   1 0 14     2 63
2573917 WA Clark   school 5300005 6801   ESD 112 acting as a school district 530000503407 5290 Clark County Juvenile Detention School   Regular School No Other 03 12 2020   grade_9 4 0 0   0 0     0   0   4 0 0   0   0   0       0.0 4 4 0 0   0 0     0   0   4 0 0   0 0 0     0 4
2579147 WA Grays Harbor   school 5306000 14400   Oakville School District 530600003712 5584 Oakville Homelink Alternative School   Alternative School No Other 03 12 2020   grade_9 0 0 0   1 0     0   0   0 1 0   1   0   0       0.0 1 0 0 0   1 0     0   0   0 1 0   1 0 0     0 1
2585187 WA Chelan   school 5309660 4246   Wenatchee School District 530966002706 1802 Chelan County Juvenile Detention Center   Regular School No Other 03 12 2020   grade_9 2 0 1   0 0     0   0   2 1 0   0   0   1       0.0 3 2 0 1   0 0     0   0   2 1 0   0 0 1     0 3
2931218 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003003633 5514 Grays Harbor Academy   Alternative School No Other 03 12 2021   grade_9 2 0 2   0 0     0   0   1 3 0   0   0   3       0.0 4 2 0 2   0 0     0   0   1 3 0   0 0 3     0 4
2931681 WA Clark   school 5300380 6119   Battle Ground School District 530038002782 1836 CAM Academy   Alternative School No Other 03 12 2021   grade_9 40 0 3   0 1     0   6   26 24 0   0   0   7       0.0 50 40 0 3   0 1     0   6   26 24 0   0 0 7     0 50
2940091 WA Grays Harbor   school 5306000 14400   Oakville School District 530600003712 5584 Oakville Homelink Alternative School   Alternative School No Other 03 12 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
461999 WA Pierce   school 5301410 27400   Clover Park School District 530141000271 2041 Firwood   Alternative Education School No 4.0 04 12 2015   grade_9 1 0 0   0 0     0   0   1 0 0   0   0   0       1.0 1 1 0 0   0 0     0   0   1 0 0   0 0 0     1 1
521992 WA Pierce   school 5301410 27400   Clover Park School District 530141000271 2041 Firwood   Regular School No 4 04 12 2016   grade_9 5 1 0   1 0     0   0   5 2 0   0   0   2       0.0 7 5 1 0   1 0     0   0   5 2 0   0 0 2     0 7
522833 WA Snohomish   school 5302400 31015   Edmonds School District 530240002821 1830 Contracted Schools   Special Education School No 4 04 12 2016   grade_9 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
528628 WA Pacific   school 5306060 25101   Ocean Beach School District 530606000911 2517 Hilltop Elementary School   Regular School No 2 04 09 2016   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
619349 WA Pierce   school 5301410 27400   Clover Park School District 530141000271 2041 Firwood   Regular School No Other 04 12 2017   grade_9 4 1 0   0 0     0   0   4 1 0   0   0   2       0.0 5 4 1 0   0 0     0   0   4 1 0   0 0 2     0 5
620215 WA Snohomish   school 5302400 31015   Edmonds School District 530240002821 1830 Contracted Schools   Special Education School No Other 04 12 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
2415305 WA Pierce   school 5301410 27400   Clover Park School District 530141000271 2041 Firwood   Regular School No Other 04 12 2019   grade_9 3 2 2   0 0     0   0   5 2 0   1   0   4       0.0 7 3 2 2   0 0     0   0   5 2 0   1 0 4     0 7
2459820 WA Pierce   school 5301410 27400   Clover Park School District 530141000271 2041 Firwood   Regular School No Other 04 12 2018   grade_9 8 1 0   0 0     1   1   9 2 0   0   0   4       2.0 11 8 1 0   0 0     1   1   9 2 0   0 0 4     2 11
2460655 WA Snohomish   school 5302400 31015   Edmonds School District 530240002821 1830 Contracted Schools   Special Education School No Other 04 12 2018   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
2572655 WA Pierce   school 5301410 27400   Clover Park School District 530141000271 2041 Firwood   Regular School No Other 04 12 2020   grade_9 2 0 0   0 0     0   0   2 0 0   0   0   2       0.0 2 2 0 0   0 0     0   0   2 0 0   0 0 2     0 2
2572781 WA Pierce   school 5301410 27400   Clover Park School District 530141003396 5297 Transition Day Students   Regular School No Other 04 12 2020   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
2933560 WA Pierce   school 5301410 27400   Clover Park School District 530141000271 2041 Firwood   Regular School No Other 04 12 2021   grade_9 3 1 1   0 1     0   1   4 3 0   0   0   2       0.0 7 3 1 1   0 1     0   1   4 3 0   0 0 2     0 7
460708 WA Pierce   school 5300480 27403   Bethel School District 530048002200 1510 Challenger High School   Alternative Education School No 4.0 05 13 2015   grade_9 3 0 1   0 1     0   0   3 2 0   0   0   3       1.0 5 3 0 1   0 1     0   0   3 2 0   0 0 3     1 5
461941 WA Pierce   school 5301410 27400   Clover Park School District 530141003000 5027 General William H. Harrison Preparatory School   Regular School No 4.0 05 12 2015   grade_9 28 10 16   3 3     2   16   26 52 0   2   1   46       1.0 78 28 10 16   3 3     2   16   26 52 0   2 1 46     1 78
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
465006 WA King   school 5303750 17411   Issaquah School District 530375001773 3569 Echo Glen School   Alternative Education School No 4.0 05 12 2015   grade_9 22 7 5   0 1     0   1   34 2 0   0   0   26       0.0 36 22 7 5   0 1     0   1   34 2 0   0 0 26     0 36
471067 WA King   school 5307710 17001   Seattle School District No. 1 530771002928 3496 Interagency Detention School   Alternative Education School No 4.0 05 12 2015   grade_9 6 7 0   2 1     0   0   11 5 0   0   3   3       0.0 16 6 7 0   2 1     0   0   11 5 0   0 3 3     0 16
473504 WA Pierce   school 5308700 27010   Tacoma School District 530870002171 2039 Remann Hall Juvenile Detention Center   Alternative Education School No 4.0 05 12 2015   grade_9 3 6 0   0 0     0   1   7 3 0   0   0   6       0.0 10 3 6 0   0 0     0   1   7 3 0   0 0 6     0 10
473908 WA Klickitat   school 5309060 20400   Trout Lake School District 530906001539 2676 Trout Lake School   Regular School No 4.0 05 12 2015   grade_9 9 0 5   0 0     0   1   11 4 0   0   0   0       0.0 15 9 0 5   0 0     0   1   11 4 0   0 0 0     0 15
475146 WA Grant   school 5309900 13167   Wilson Creek School District 530990001675 2473 Wilson Creek High   Regular School No 4.0 05 12 2015   grade_9 9 0 1   0 0     0   0   3 7 0   0   0   4       0.0 10 9 0 1   0 0     0   0   3 7 0   0 0 4     0 10
475317 WA Yakima   school 5310110 39007   Yakima School District 531011002932 4092 Juvenile Detention Center   Alternative Education School No 4.0 05 12 2015   grade_9 2 0 0   1 0     0   0   2 1 0   0   0   3       0.0 3 2 0 0   1 0     0   0   2 1 0   0 0 3     0 3
521685 WA Lewis   school 5301170 21302   Chehalis School District 530117002883 1559 Lewis County Juvenile Detention   Regular School No 4 05 12 2016   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
522124 WA Pierce   school 5301410 27400   Clover Park School District 530141003396 5297 Transition Day Students   Regular School No 4 05 12 2016   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
524960 WA King   school 5303750 17411   Issaquah School District 530375001773 3569 Echo Glen School   Regular School No 4 05 12 2016   grade_9 23 10 4   2 1     1   1   39 3 0   1   0   39       0.0 42 23 10 4   2 1     1   1   39 3 0   1 0 39     0 42
529711 WA Pierce   school 5306960 27003   Puyallup School District 530696001178 4443 Doris Stahl Junior High   Regular School No 2 05 09 2016   grade_9 154 20 42   7 14     10   45   151 141 0   11   6   123       17.0 292 154 20 42   7 14     10   45   151 141 0   11 6 123     17 292
533505 WA Pierce   school 5308700 27010   Tacoma School District 530870002171 2039 Remann Hall Juvenile Detention Center   Regular School No 4 05 12 2016   grade_9 2 2 0   1 0     1   0   5 1 0   0   0   3       0.0 6 2 2 0   1 0     1   0   5 1 0   0 0 3     0 6
533891 WA Klickitat   school 5309060 20400   Trout Lake School District 530906001539 2676 Trout Lake School   Regular School No 4 05 12 2016   grade_9 8 0 1   1 0     0   2   9 3 0   0   1   0       0.0 12 8 0 1   1 0     0   2   9 3 0   0 1 0     0 12
535254 WA Yakima   school 5310110 39007   Yakima School District 531011002932 4092 Juvenile Detention Center   Regular School No 4 05 12 2016   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
619484 WA Pierce   school 5301410 27400   Clover Park School District 530141003396 5297 Transition Day Students   Regular School No Other 05 12 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
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
622330 WA King   school 5303750 17411   Issaquah School District 530375001773 3569 Echo Glen School   Regular School No Other 05 12 2017   grade_9 14 7 11   1 0     1   0   29 5 0   8   0   31       2.0 34 14 7 11   1 0     1   0   29 5 0   8 0 31     2 34
630844 WA Pierce   school 5308700 27010   Tacoma School District 530870002171 2039 Remann Hall Juvenile Detention Center   Regular School No Other 05 12 2017   grade_9 2 0 0   0 0     0   0   2 0 0   0   0   1       0.0 2 2 0 0   0 0     0   0   2 0 0   0 0 1     0 2
631225 WA Klickitat   school 5309060 20400   Trout Lake School District 530906001539 2676 Trout Lake School   Regular School No Other 05 12 2017   grade_9 14 0 3   0 0     0   0   5 12 0   0   1   0       1.0 17 14 0 3   0 0     0   0   5 12 0   0 1 0     1 17

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