Data source: Big Local News · About: Big Local

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

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
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
466640 WA Whatcom   school 5304620 37504   Lynden School District 530462002903 1914 Lynden Student Services   Special Education School No 1.0 PK PK 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
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
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
519942 WA King   school 5300300 17408   Auburn School District 530030000033 2394 Cascade Middle School   Regular School No 2 06 09 2016   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
520844 WA Pierce   school 5300480 27403   Bethel School District 530048000128 3751 Spanaway Middle School   Regular School No 2 06 09 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
521402 WA Kitsap   school 5301080 18401   Central Kitsap School District 530108002884 1653 New Frontiers Jr High (Closed after 2015-2016 school year)   Alternative Education School No 2 07 09 2016   grade_9 17 0 2   0 0     0   5   14 10 0   0   2   10       3.0 24 17 0 2   0 0     0   5   14 10 0   0 2 10     3 24
521881 WA Asotin   school 5301320 2250   Clarkston School District 530132000237 2501 Lincoln Middle School   Regular School No 2 07 09 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
524150 WA Pierce   school 5302880 27417   Fife School District 530288003161 4582 Columbia Junior High School   Regular School No 2 06 09 2016   grade_9 141 9 52   2 24     7   32   142 125 0   19   2   120       10.0 267 141 9 52   2 24     7   32   142 125 0   19 2 120     10 267
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
528293 WA King   school 5305910 17417   Northshore School District 530591000879 3493 Canyon Park Middle School   Regular School No 2 07 09 2016   grade_9 164 6 40   2 17     0   20   124 125 0   8   3   55       11.0 249 164 6 40   2 17     0   20   124 125 0   8 3 55     11 249
528368 WA King   school 5305910 17417   Northshore School District 530591000886 3345 Kenmore Middle School   Regular School No 2 07 09 2016   grade_9 129 6 23   2 31     0   14   93 112 0   6   2   52       11.0 205 129 6 23   2 31     0   14   93 112 0   6 2 52     11 205
528381 WA King   school 5305910 17417   Northshore School District 530591000887 3790 Leota Middle School   Regular School No 2 07 09 2016   grade_9 155 3 34   1 42     0   29   131 133 0   8   1   46       12.0 264 155 3 34   1 42     0   29   131 133 0   8 1 46     12 264
528415 WA King   school 5305910 17417   Northshore School District 530591000891 4021 Northshore Middle School   Regular School No 2 07 09 2016   grade_9 149 2 29   0 39     0   22   125 116 0   5   1   40       19.0 241 149 2 29   0 39     0   22   125 116 0   5 1 40     19 241
528456 WA King   school 5305910 17417   Northshore School District 530591000480 4371 Skyview Middle School   Regular School No 2 07 09 2016   grade_9 173 10 36   2 79     0   29   174 155 0   11   2   66       13.0 329 173 10 36   2 79     0   29   174 155 0   11 2 66     13 329
528470 WA King   school 5305910 17417   Northshore School District 530591002571 4516 Timbercrest Middle School   Regular School No 2 07 09 2016   grade_9 211 2 17   0 20     1   23   143 131 0   0   2   20       29.0 274 211 2 17   0 20     1   23   143 131 0   0 2 20     29 274
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
529687 WA Pierce   school 5306960 27003   Puyallup School District 530696001022 3447 Aylen Jr High   Regular School No 2 07 09 2016   grade_9 168 5 27   2 6     2   21   135 96 0   1   6   94       24.0 231 168 5 27   2 6     2   21   135 96 0   1 6 94     24 231
529692 WA Pierce   school 5306960 27003   Puyallup School District 530696001026 3750 Ballou Jr High   Regular School No 2 07 09 2016   grade_9 150 12 29   1 21     3   32   131 117 0   5   5   101       15.0 248 150 12 29   1 21     3   32   131 117 0   5 5 101     15 248
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
529720 WA Pierce   school 5306960 27003   Puyallup School District 530696001024 2575 Edgemont Jr High   Regular School No 2 07 09 2016   grade_9 99 10 18   1 9     1   20   85 73 0   2   3   60       13.0 158 99 10 18   1 9     1   20   85 73 0   2 3 60     13 158
529746 WA Pierce   school 5306960 27003   Puyallup School District 530696001865 4183 Ferrucci Jr High   Regular School No 2 07 09 2016   grade_9 158 11 28   4 5     4   27   124 113 0   8   5   91       17.0 237 158 11 28   4 5     4   27   124 113 0   8 5 91     17 237
529786 WA Pierce   school 5306960 27003   Puyallup School District 530696003260 5142 Glacier View Junior High   Regular School No 2 07 09 2016   grade_9 191 8 41   5 11     3   35   156 138 0   1   3   76       23.0 294 191 8 41   5 11     3   35   156 138 0   1 3 76     23 294
529795 WA Pierce   school 5306960 27003   Puyallup School District 530696001032 3052 Kalles Junior High   Regular School No 2 07 09 2016   grade_9 204 17 38   3 17     1   23   142 161 0   4   3   92       25.0 303 204 17 38   3 17     1   23   142 161 0   4 3 92     25 303
530075 WA Grant   school 5307080 13144   Quincy School District 530708001056 2510 Quincy Middle School   Regular School No 2 07 09 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
532057 WA Snohomish   school 5308020 31201   Snohomish School District 530802001790 4145 Valley View Middle School   Regular School No 2 07 09 2016   grade_9 1 0 0   0 0     0   0   0 1 0   0   1   1       0.0 1 1 0 0   0 0     0   0   0 1 0   0 1 1     0 1
532209 WA Kitsap   school 5308160 18402   South Kitsap School District 530816001346 3680 Cedar Heights Middle School   Regular School No 2 07 09 2016   grade_9 155 5 30   5 13     9   27   129 115 0   4   3   105       12.0 244 155 5 30   5 13     9   27   129 115 0   4 3 105     12 244
532255 WA Kitsap   school 5308160 18402   South Kitsap School District 530816001877 4142 John Sedgwick Middle School   Regular School No 2 07 09 2016   grade_9 169 2 26   0 8     0   21   108 118 0   5   0   74       9.0 226 169 2 26   0 8     0   21   108 118 0   5 0 74     9 226
532272 WA Kitsap   school 5308160 18402   South Kitsap School District 530816001351 3046 Marcus Whitman Middle School   Regular School No 2 06 09 2016   grade_9 161 4 39   1 13     6   32   136 120 0   3   5   131       8.0 256 161 4 39   1 13     6   32   136 120 0   3 5 131     8 256
532742 WA Spokane   school 5308250 32081   Spokane School District 530825001408 3257 Shaw Middle School   Regular School No 2 07 09 2016   grade_9 0 0 0   0 0     1   0   1 0 0   0   0   0       0.0 1 0 0 0   0 0     1   0   1 0 0   0 0 0     0 1
533687 WA King   school 5308760 17409   Tahoma School District 530876002874 4556 Tahoma Jr High (Closed after 2016-2017 school year)   Regular School No 2 06 09 2016   grade_9 465 19 66   3 31     2   42   302 326 0   1   4   94       43.0 628 465 19 66   3 31     2   42   302 326 0   1 4 94     43 628
534034 WA Pierce   school 5309180 27083   University Place School District 530918001548 3179 Curtis Junior High   Regular School No 2 06 09 2016   grade_9 256 49 64   4 59     6   90   270 258 0   13   7   204       23.0 528 256 49 64   4 59     6   90   270 258 0   13 7 204     23 528
535397 WA Thurston   school 5310140 34002   Yelm School District 531014003068 5052 Ridgeline Middle School   Regular School No 2 07 09 2016   grade_9 153 0 24   0 2     2   24   91 114 0   0   0   72       8.0 205 153 0 24   0 2     2   24   91 114 0   0 0 72     8 205
535421 WA Thurston   school 5310140 34002   Yelm School District 531014001717 2481 Yelm Middle School   Regular School No 2 07 09 2016   grade_9 164 4 22   3 4     2   23   107 115 0   2   3   121       16.0 222 164 4 22   3 4     2   23   107 115 0   2 3 121     16 222
461415 WA Kitsap   school 5301080 18401   Central Kitsap School District 530108002884 1653 New Frontiers Jr High (Closed after 2015-2016 school year)   Alternative Education School No 2.0 07 09 2015   grade_9 15 0 1   0 0     1   2   9 10 0   0   1   10       2.0 19 15 0 1   0 0     1   2   9 10 0   0 1 10     2 19
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
466942 WA Snohomish   school 5304860 31025   Marysville School District 530486000735 2813 Totem Middle School   Regular School No 2.0 06 09 2015   grade_9 0 0 0   0 0     0   1   0 1 0   0   1   1       0.0 1 0 0 0   0 0     0   1   0 1 0   0 1 1     0 1
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
468400 WA King   school 5305910 17417   Northshore School District 530591000879 3493 Canyon Park Middle School   Regular School No 2.0 07 09 2015   grade_9 188 15 36   2 27     1   12   152 129 0   9   5   72       11.0 281 188 15 36   2 27     1   12   152 129 0   9 5 72     11 281
468475 WA King   school 5305910 17417   Northshore School District 530591000886 3345 Kenmore Middle School   Regular School No 2.0 07 09 2015   grade_9 152 4 34   0 28     1   18   121 116 0   10   0   53       18.0 237 152 4 34   0 28     1   18   121 116 0   10 0 53     18 237
468489 WA King   school 5305910 17417   Northshore School District 530591000887 3790 Leota Middle School   Regular School No 2.0 07 09 2015   grade_9 113 4 30   1 37     1   16   125 77 0   9   2   39       12.0 202 113 4 30   1 37     1   16   125 77 0   9 2 39     12 202
468523 WA King   school 5305910 17417   Northshore School District 530591000891 4021 Northshore Middle School   Regular School No 2.0 07 09 2015   grade_9 125 4 30   0 40     1   15   113 102 0   8   0   47       10.0 215 125 4 30   0 40     1   15   113 102 0   8 0 47     10 215
468568 WA King   school 5305910 17417   Northshore School District 530591000480 4371 Skyview Middle School   Regular School No 2.0 07 09 2015   grade_9 155 9 44   4 64     0   21   166 131 0   11   3   77       22.0 297 155 9 44   4 64     0   21   166 131 0   11 3 77     22 297
468581 WA King   school 5305910 17417   Northshore School District 530591002571 4516 Timbercrest Middle School   Regular School No 2.0 07 09 2015   grade_9 217 2 17   0 14     1   22   141 132 0   3   0   22       29.0 273 217 2 17   0 14     1   22   141 132 0   3 0 22     29 273
469756 WA Pierce   school 5306960 27003   Puyallup School District 530696001022 3447 Aylen Jr High   Regular School No 2.0 07 09 2015   grade_9 152 3 42   3 5     0   19   134 90 0   8   5   88       12.0 224 152 3 42   3 5     0   19   134 90 0   8 5 88     12 224
469760 WA Pierce   school 5306960 27003   Puyallup School District 530696001026 3750 Ballou Jr High   Regular School No 2.0 07 09 2015   grade_9 156 12 27   2 11     4   34   123 123 0   5   1   110       12.0 246 156 12 27   2 11     4   34   123 123 0   5 1 110     12 246
469778 WA Pierce   school 5306960 27003   Puyallup School District 530696001178 4443 Doris Stahl Junior High   Regular School No 2.0 07 09 2015   grade_9 153 17 51   1 13     12   40   149 138 0   11   1   98       20.0 287 153 17 51   1 13     12   40   149 138 0   11 1 98     20 287
469787 WA Pierce   school 5306960 27003   Puyallup School District 530696001024 2575 Edgemont Jr High   Regular School No 2.0 07 09 2015   grade_9 71 6 9   0 10     1   14   54 57 0   0   2   37       8.0 111 71 6 9   0 10     1   14   54 57 0   0 2 37     8 111
469813 WA Pierce   school 5306960 27003   Puyallup School District 530696001865 4183 Ferrucci Jr High   Regular School No 2.0 07 09 2015   grade_9 150 6 29   1 8     2   25   112 109 0   4   4   84       17.0 221 150 6 29   1 8     2   25   112 109 0   4 4 84     17 221
469852 WA Pierce   school 5306960 27003   Puyallup School District 530696003260 5142 Glacier View Junior High   Regular School No 2.0 07 09 2015   grade_9 196 17 40   4 16     3   44   172 148 0   7   2   98       26.0 320 196 17 40   4 16     3   44   172 148 0   7 2 98     26 320
469862 WA Pierce   school 5306960 27003   Puyallup School District 530696001032 3052 Kalles Junior High   Regular School No 2.0 07 09 2015   grade_9 205 7 31   2 17     3   28   138 155 0   8   3   94       25.0 293 205 7 31   2 17     3   28   138 155 0   8 3 94     25 293
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
472202 WA Kitsap   school 5308160 18402   South Kitsap School District 530816001346 3680 Cedar Heights Middle School   Regular School No 2.0 07 09 2015   grade_9 151 2 15   2 10     4   19   104 99 0   4   3   90       7.0 203 151 2 15   2 10     4   19   104 99 0   4 3 90     7 203
472248 WA Kitsap   school 5308160 18402   South Kitsap School District 530816001877 4142 John Sedgwick Middle School   Regular School No 2.0 07 09 2015   grade_9 171 1 19   1 4     2   21   119 100 0   2   0   66       6.0 219 171 1 19   1 4     2   21   119 100 0   2 0 66     6 219
472264 WA Kitsap   school 5308160 18402   South Kitsap School District 530816001351 3046 Marcus Whitman Middle School   Regular School No 2.0 07 09 2015   grade_9 167 5 33   1 13     4   31   129 125 0   1   4   124       13.0 254 167 5 33   1 13     4   31   129 125 0   1 4 124     13 254
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

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