Data source: Big Local News · About: Big Local

658 rows where grade = "grade_7", state = "WA" and year = 2020

View and edit SQL

year

  • 2020 · 558

grade

  • grade_7 · 558
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
2572653 WA Pierce   school 5301410 27400   Clover Park School District 530141000271 2041 Firwood   Regular School No Other 04 12 2020   grade_7 3 1 2   0 0     0   2   7 1 0   0   0   1       0.0 8 3 1 2   0 0     0   2   7 1 0   0 0 1     0 8
2572675 WA Pierce   school 5301410 27400   Clover Park School District 530141000257 3248 Hudtloff Middle School   Regular School No Middle 06 08 2020   grade_7 64 40 105   1 10     11   36   133 134 0   38   16   198       9.0 267 64 40 105   1 10     11   36   133 134 0   38 16 198     9 267
2572708 WA Pierce   school 5301410 27400   Clover Park School District 530141000263 3602 Lochburn Middle School   Regular School No Middle 06 08 2020   grade_7 23 34 82   0 8     25   33   105 100 0   40   13   191       8.0 205 23 34 82   0 8     25   33   105 100 0   40 13 191     8 205
2572712 WA Pierce   school 5301410 27400   Clover Park School District 530141000264 3297 Mann Middle School (Closed after 2019-2020 school year)   Regular School No Middle 06 08 2020   grade_7 55 21 36   1 8     7   35   77 86 0   11   3   89       12.0 163 55 21 36   1 8     7   35   77 86 0   11 3 89     12 163
2572764 WA Pierce   school 5301410 27400   Clover Park School District 530141000272 3500 Thomas Middle School   Regular School No Middle 06 08 2020   grade_7 68 26 55   0 8     7   16   96 84 0   16   12   143       8.0 180 68 26 55   0 8     7   16   96 84 0   16 12 143     8 180
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
2572793 WA Whitman   school 5301440 38300   Colfax School District 530144000273 3366 Colfax High School   Regular School No High 07 12 2020   grade_7 35 0 0   0 1     0   2   18 19 1   0   1   13       0.0 38 35 0 0   0 1     0   2   18 19 1   0 1 13     0 38
2572824 WA Walla Walla   school 5301470 36250   College Place School District 530147000276 3541 John Sager Middle School   Regular School No Middle 06 08 2020   grade_7 63 1 48   1 2     1   4   58 62 0   21   3   71       3.0 120 63 1 48   1 2     1   4   58 62 0   21 3 71     3 120
2572836 WA Whitman   school 5301500 38306   Colton School District 530150000277 2588 Colton School   Regular School No Other PK 12 2020   grade_7 8 0 0   0 0     0   0   3 5 0   0   1   4       0.0 8 8 0 0   0 0     0   0   3 5 0   0 1 4     0 8
2572851 WA Stevens   school 5301560 33206   Columbia (Stevens) School District 530156000278 3508 Columbia High And Elementary   Regular School No Other PK 12 2020   grade_7 6 0 0   2 0     0   1   7 2 0   0   0   6       0.0 9 6 0 0   2 0     0   1   7 2 0   0 0 6     0 9
2572871 WA Walla Walla   school 5301590 36400   Columbia (Walla Walla) School District 530159000280 3012 Columbia Middle School   Regular School No Middle 06 08 2020   grade_7 32 0 27   1 0     0   2   34 28 0   14   2   35       0.0 62 32 0 27   1 0     0   2   34 28 0   14 2 35     0 62
2572875 WA Stevens   school 5301630 33115   Colville School District 530163000283 3831 Colville Junior High School   Regular School No Middle 06 08 2020   grade_7 116 1 8   3 1     0   12   64 77 0   1   0   73       1.0 141 116 1 8   3 1     0   12   64 77 0   1 0 73     1 141
2572899 WA Stevens   school 5301630 33115   Colville School District 530163003305 1594 Panorama School   Alternative School No Other PK 12 2020   grade_7 2 0 1   0 0     0   0   1 2 0   0   0   2       0.0 3 2 0 1   0 0     0   0   1 2 0   0 0 2     0 3
2572917 WA Skagit   school 5301660 29011   Concrete School District 530166000286 2810 Concrete High School   Regular School No High 07 12 2020   grade_7 33 0 4   1 0     0   2   22 18 0   0   0   38       0.0 40 33 0 4   1 0     0   2   22 18 0   0 0 38     0 40
2572933 WA Skagit   school 5301680 29317   Conway School District 530168000287 2578 Conway School District 317   Regular School No Elementary PK 08 2020   grade_7 48 2 6   0 0     0   0   26 30 0   1   1   8       4.0 56 48 2 6   0 0     0   0   26 30 0   1 1 8     4 56
2572974 WA Island   school 5301800 15204   Coupeville School District 530180002049 4004 Coupeville Middle School   Regular School No Middle 06 08 2020   grade_7 52 1 17   0 0     0   9   37 41 1   3   8   30       4.0 79 52 1 17   0 0     0   9   37 41 1   3 8 30     4 79
2572989 WA Clallam   school 5301830 5313   Crescent School District 530183000292 3473 Crescent School   Regular School No Other KG 12 2020   grade_7 20 0 1   3 0     1   4   12 17 0   0   0   15       0.0 29 20 0 1   3 0     1   4   12 17 0   0 0 15     0 29
2573001 WA Clallam   school 5301830 5313   Crescent School District 530183002942 5030 Olympic Peninsula HomeConnection   Alternative School No Other KG 12 2020   grade_7 12 0 0   0 0     0   0   8 4 0   0   0   6       0.0 12 12 0 0   0 0     0   0   8 4 0   0 0 6     0 12
2573016 WA Lincoln   school 5301860 22073   Creston School District 530186000294 2863 Creston Jr-Sr High School   Regular School No High 07 12 2020   grade_7 6 0 0   0 0     0   1   4 3 0   0   2   5       0.0 7 6 0 0   0 0     0   1   4 3 0   0 2 5     0 7
2573029 WA Ferry   school 5301890 10050   Curlew School District 530189000295 2006 Curlew Elem & High School   Regular School No Other PK 12 2020   grade_7 12 0 3   0 0     0   5   12 8 0   0   1   15       1.0 20 12 0 3   0 0     0   5   12 8 0   0 1 15     1 20
2573047 WA Pend Oreille   school 5301920 26059   Cusick School District 530192000297 2423 Cusick Jr Sr High School   Regular School No High 06 12 2020   grade_7 8 0 3   5 0     0   4   10 10 0   0   7   17       2.0 20 8 0 3   5 0     0   4   10 10 0   0 7 17     2 20
2573055 WA Pend Oreille   school 5301920 26059   Cusick School District 530192003642 5538 Home Pride   Regular School No Other KG 12 2020   grade_7 1 0 0   0 0     0   1   1 1 0   0   0   1       0.0 2 1 0 0   0 0     0   1   1 1 0   0 0 1     0 2
2573072 WA Snohomish   school 5301980 31330   Darrington School District 530198000300 3609 Darrington Elementary School   Regular School No Elementary PK 08 2020   grade_7 26 0 3   0 0     0   3   17 15 0   1   1   21       1.0 32 26 0 3   0 0     0   3   17 15 0   1 1 21     1 32
2573094 WA Lincoln   school 5302010 22207   Davenport School District 530201000303 3173 Davenport Senior High School   Regular School No High 06 12 2020   grade_7 38 1 1   1 0     0   1   21 21 0   0   0   24       0.0 42 38 1 1   1 0     0   1   21 21 0   0 0 24     0 42
2573112 WA Columbia   school 5302040 7002   Dayton School District 530204002513 4011 Dayton Middle School   Regular School No Middle 06 08 2020   grade_7 25 0 8   0 1     0   1   13 22 0   0   1   18       1.0 35 25 0 8   0 1     0   1   13 22 0   0 1 18     1 35
2573140 WA Spokane   school 5302070 32414   Deer Park School District 530207002827 1852 Deer Park Home Link Program   Alternative School No Other KG 12 2020   grade_7 45 0 3   0 0     1   0   20 29 0   0   0   12       5.0 49 45 0 3   0 0     1   0   20 29 0   0 0 12     5 49
2573149 WA Spokane   school 5302070 32414   Deer Park School District 530207000308 3261 Deer Park Middle School   Regular School No Middle 06 08 2020   grade_7 162 2 18   4 0     1   2   109 80 0   2   7   109       15.0 189 162 2 18   4 0     1   2   109 80 0   2 7 109     15 189
2573162 WA Pierce   school 5302130 27343   Dieringer School District 530213000694 4416 North Tapps Middle School   Regular School No Middle 06 08 2020   grade_7 115 0 15   0 12     2   25   91 78 0   4   1   28       19.0 169 115 0 15   0 12     2   25   91 78 0   4 1 28     19 169
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
2573182 WA Spokane   school 5302280 32361   East Valley School District (Spokane) 530228002600 1712 Continuous Curriculum School   Regular School No Elementary KG 08 2020   grade_7 35 0 2   0 0     0   6   16 27 0   0   0   17       4.0 43 35 0 2   0 0     0   6   16 27 0   0 0 17     4 43
2573203 WA Spokane   school 5302280 32361   East Valley School District (Spokane) 530228003494 5346 East Valley Middle School   Regular School No Middle 07 08 2020   grade_7 187 3 24   4 2     4   18   133 109 0   2   15   155       10.0 242 187 3 24   4 2     4   18   133 109 0   2 15 155     10 242
2573209 WA Spokane   school 5302280 32361   East Valley School District (Spokane) 530228003581 5432 EV Online   Alternative School No High 07 12 2020   grade_7 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
2573222 WA Spokane   school 5302280 32361   East Valley School District (Spokane) 530228003582 5433 EV Parent Partnership   Alternative School No Other KG 12 2020   grade_7 17 0 4   0 0     0   1   13 9 0   2   0   10       0.0 22 17 0 4   0 0     0   1   13 9 0   2 0 10     0 22
2573255 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_7 126 1 135   2 0     0   8   151 121 0   18   8   163       11.0 272 126 1 135   2 0     0   8   151 121 0   18 8 163     11 272
2573298 WA Douglas   school 5302310 9206   Eastmont School District 530231002948 4590 Clovis Point Intermediate School   Regular School No Middle 05 07 2020   grade_7 98 0 110   3 0     0   2   108 105 0   32   2   133       9.0 213 98 0 110   3 0     0   2   108 105 0   32 2 133     9 213
2573341 WA Douglas   school 5302310 9206   Eastmont School District 530231001762 4095 Sterling School   Regular School No Elementary KG 07 2020   grade_7 119 0 139   1 1     0   4   131 133 0   30   6   170       18.0 264 119 0 139   1 1     0   4   131 133 0   30 6 170     18 264
2573352 WA Kittitas   school 5302340 19028   Easton School District 530234000324 3554 Easton School   Regular School No Other PK 12 2020   grade_7 6 0 5   0 0     0   0   8 3 0   1   0   8       0.0 11 6 0 5   0 0     0   0   8 3 0   1 0 8     0 11
2573364 WA Pierce   school 5302370 27404   Eatonville School District 530237000325 2808 Columbia Crest A-STEM Academy   Regular School No Elementary PK 08 2020   grade_7 22 0 0   0 0     0   1   10 13 0   0   0   12       2.0 23 22 0 0   0 0     0   1   10 13 0   0 0 12     2 23
2573385 WA Pierce   school 5302370 27404   Eatonville School District 530237001899 4230 Eatonville Middle School   Regular School No Middle 06 08 2020   grade_7 116 1 11   2 0     1   9   67 71 2   3   4   68       9.0 140 116 1 11   2 0     1   9   67 71 2   3 4 68     9 140
2573388 WA Pierce   school 5302370 27404   Eatonville School District 530237003645 5531 Eatonville Online Academy   Alternative School No Middle 06 10 2020   grade_7 2 0 0   0 0     0   0   1 1 0   0   0   0       0.0 2 2 0 0   0 0     0   0   1 1 0   0 0 0     0 2
2573402 WA Pierce   school 5302370 27404   Eatonville School District 530237003389 5300 Mt. Rainier Parent Partnership   Alternative School No Elementary KG 08 2020   grade_7 4 0 0   0 0     0   0   1 3 0   0   0   1       0.0 4 4 0 0   0 0     0   0   1 3 0   0 0 1     0 4
2573414 WA Snohomish   school 5302400 31015   Edmonds School District 530240000329 3560 Alderwood Middle School   Regular School No Middle 07 08 2020   grade_7 135 23 116   2 80     2   33   197 194 0   50   8   197       14.0 391 135 23 116   2 80     2   33   197 194 0   50 8 197     14 391
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
2573434 WA Snohomish   school 5302400 31015   Edmonds School District 530240000332 3650 Brier Terrace Middle School   Regular School No Middle 07 08 2020   grade_7 158 23 50   1 57     4   39   172 160 0   25   8   108       22.0 332 158 23 50   1 57     4   39   172 160 0   25 8 108     22 332
2573479 WA Snohomish   school 5302400 31015   Edmonds School District 530240000337 3754 College Place Middle School   Regular School No Middle 07 08 2020   grade_7 102 22 83   1 25     2   25   143 117 0   42   13   132       16.0 260 102 22 83   1 25     2   25   143 117 0   42 13 132     16 260
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
2573502 WA Snohomish   school 5302400 31015   Edmonds School District 530240002205 1519 Edmonds eLearning Academy   Alternative School No High 09 12 2020   grade_7 4 0 0   0 0     0   0   3 1 0   1   0   3       0.0 4 4 0 0   0 0     0   0   3 1 0   1 0 3     0 4
2573523 WA Snohomish   school 5302400 31015   Edmonds School District 530240003139 1966 Edmonds Heights K-12   Alternative School No Other KG 12 2020   grade_7 41 1 4   0 7     0   10   30 33 0   0   1   17       4.0 63 41 1 4   0 7     0   10   30 33 0   0 1 17     4 63
2573578 WA Snohomish   school 5302400 31015   Edmonds School District 530240000348 3463 Madrona K-8 School   Alternative School No Elementary PK 08 2020   grade_7 47 3 10   0 5     0   10   38 37 0   2   0   7       8.0 75 47 3 10   0 5     0   10   38 37 0   2 0 7     8 75
2573589 WA Snohomish   school 5302400 31015   Edmonds School District 530240002474 1685 Maplewood Parent Coop   Alternative School No Elementary KG 08 2020   grade_7 43 2 3   0 3     0   7   32 26 0   1   0   6       10.0 58 43 2 3   0 3     0   7   32 26 0   1 0 6     10 58
2573615 WA Snohomish   school 5302400 31015   Edmonds School District 530240000351 3353 Meadowdale Middle School   Regular School No Middle 07 08 2020   grade_7 179 41 88   2 29     5   36   184 195 1   45   8   171       15.0 380 179 41 88   2 29     5   36   184 195 1   45 8 171     15 380
2573716 WA Kittitas   school 5302460 19401   Ellensburg School District 530246000367 2453 Morgan Middle School   Regular School No Middle 06 08 2020   grade_7 207 2 46   1 5     0   8   136 133 0   13   4   116       7.0 269 207 2 46   1 5     0   8   136 133 0   13 4 116     7 269
2573755 WA Grays Harbor   school 5302490 14068   Elma School District 530249002060 4245 Elma Middle School   Regular School No Middle 06 08 2020   grade_7 82 0 32   4 2     0   7   61 66 0   6   1   94       11.0 127 82 0 32   4 2     0   7   61 66 0   6 1 94     11 127
2573764 WA Whitman   school 5302520 38308   Endicott School District 530252000373 2207 Endicott/St John Elem and Middle   Regular School No Elementary PK 08 2020   grade_7 15 0 2   0 0     0   1   10 8 0   0   0   13       0.0 18 15 0 2   0 0     0   1   10 8 0   0 0 13     0 18
2573773 WA Chelan   school 5302550 4127   Entiat School District 530255000374 3317 Entiat Middle and High School   Regular School No High 06 12 2020   grade_7 15 0 8   0 0     0   0   14 9 0   1   0   15       0.0 23 15 0 8   0 0     0   0   14 9 0   1 0 15     0 23
2573802 WA King   school 5300001 17216   Enumclaw School District 530000102054 4210 Enumclaw Middle School   Regular School No Middle 06 08 2020   grade_7 119 1 27   1 0     1   12   81 80 0   7   10   68       3.0 161 119 1 27   1 0     1   12   81 80 0   7 10 68     3 161
2573825 WA King   school 5300001 17216   Enumclaw School District 530000103038 1523 Special Ed School   Special Education School No Other PK 12 2020   grade_7 1 0 1   0 0     0   0   2 0 0   0   0   2       0.0 2 1 0 1   0 0     0   0   2 0 0   0 0 2     0 2
2573836 WA King   school 5300001 17216   Enumclaw School District 530000102795 4550 Thunder Mountain Middle School   Regular School No Middle 06 08 2020   grade_7 112 0 24   1 2     0   4   75 68 0   8   1   37       7.0 143 112 0 24   1 2     0   4   75 68 0   8 1 37     7 143
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
2573869 WA Grant   school 5302610 13165   Ephrata School District 530261000387 3373 Ephrata Middle School   Regular School No Middle 07 08 2020   grade_7 150 1 75   0 2     0   3   119 112 0   15   2   134       24.0 231 150 1 75   0 2     0   3   119 112 0   15 2 134     24 231
2573900 WA Spokane   school 5300010 32801   ESD 101 acting as a school district 530001002930 3526 Spokane Juvenile Detention School   Regular School No High 06 12 2020   grade_7 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
2573915 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_7 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
2573936 WA Kitsap   school 5300007 18801   ESD 114 acting as a school district 530000702914 3143 Clallam Co Juvenile Detention   Regular School No High 08 12 2020   grade_7 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
2573980 WA Snohomish   school 5302670 31002   Everett School District 530267000393 3752 Eisenhower Middle School   Regular School No Middle 06 08 2020   grade_7 157 15 58   2 42     4   20   164 134 0   31   6   137       20.0 298 157 15 58   2 42     4   20   164 134 0   31 6 137     20 298
2574001 WA Snohomish   school 5302670 31002   Everett School District 530267000397 3253 Evergreen Middle School   Regular School No Middle 06 08 2020   grade_7 155 23 108   0 40     4   27   196 161 0   47   18   222       12.0 357 155 23 108   0 40     4   27   196 161 0   47 18 222     12 357
2574021 WA Snohomish   school 5302670 31002   Everett School District 530267001725 4437 Gateway Middle School   Regular School No Middle 06 08 2020   grade_7 169 13 33   2 89     2   23   168 162 1   11   2   49       20.0 331 169 13 33   2 89     2   23   168 162 1   11 2 49     20 331
2574033 WA Snohomish   school 5302670 31002   Everett School District 530267002253 4334 Heatherwood Middle School   Regular School No Middle 06 08 2020   grade_7 153 15 65   4 61     1   25   176 148 0   28   6   90       11.0 324 153 15 65   4 61     1   25   176 148 0   28 6 90     11 324
2574090 WA Snohomish   school 5302670 31002   Everett School District 530267000399 2364 North Middle School   Regular School No Middle 06 08 2020   grade_7 125 5 66   2 14     13   18   118 125 0   22   19   155       18.0 243 125 5 66   2 14     13   18   118 125 0   22 19 155     18 243
2574112 WA Snohomish   school 5302670 31002   Everett School District 530267002897 1907 Port Gardner   Alternative School No Other KG 12 2020   grade_7 6 1 2   0 0     0   1   8 2 0   2   0   2       1.0 10 6 1 2   0 0     0   1   8 2 0   2 0 2     1 10
2574186 WA Clark   school 5302700 6114   Evergreen School District (Clark) 530270001270 1646 49th Street Academy   Special Education School No Other KG 12 2020   grade_7 2 0 1   0 0     0   1   3 1 0   0   0   3       0.0 4 2 0 1   0 0     0   1   3 1 0   0 0 3     0 4
2574206 WA Clark   school 5302700 6114   Evergreen School District (Clark) 530270000414 3785 Cascade Middle School   Regular School No Middle 06 08 2020   grade_7 166 9 98   1 10     9   35   177 150 1   27   12   199       10.0 328 166 9 98   1 10     9   35   177 150 1   27 12 199     10 328
2574221 WA Clark   school 5302700 6114   Evergreen School District (Clark) 530270000415 3320 Covington Middle School   Regular School No Middle 06 08 2020   grade_7 184 16 118   2 10     11   35   203 172 1   54   24   273       8.0 376 184 16 118   2 10     11   35   203 172 1   54 24 273     8 376
2574272 WA Clark   school 5302700 6114   Evergreen School District (Clark) 530270002510 4498 Frontier Middle School   Regular School No Middle 06 08 2020   grade_7 157 5 69   2 17     5   25   166 114 0   32   6   147       14.0 280 157 5 69   2 17     5   25   166 114 0   32 6 147     14 280
2574307 WA Clark   school 5302700 6114   Evergreen School District (Clark) 530270003101 1926 Home Choice Academy   Alternative School No Other KG 12 2020   grade_7 18 1 3   0 2     0   2   15 10 1   1   1   9       2.0 26 18 1 3   0 2     0   2   15 10 1   1 1 9     2 26
2574366 WA Clark   school 5302700 6114   Evergreen School District (Clark) 530270001901 4209 Pacific Middle School   Regular School No Middle 06 08 2020   grade_7 210 11 66   0 19     9   47   191 171 0   25   12   171       16.0 362 210 11 66   0 19     9   47   191 171 0   25 12 171     16 362
2574386 WA Clark   school 5302700 6114   Evergreen School District (Clark) 530270002878 4561 Shahala Middle School   Regular School No Middle 06 08 2020   grade_7 176 10 70   2 46     3   27   191 141 2   25   5   113       13.0 334 176 10 70   2 46     3   27   191 141 2   25 5 113     13 334
2574419 WA Clark   school 5302700 6114   Evergreen School District (Clark) 530270000428 4051 Wyeast Middle School   Regular School No Middle 06 08 2020   grade_7 123 11 113   3 9     13   30   160 142 0   56   7   188       9.0 302 123 11 113   3 9     13   30   160 142 0   56 7 188     9 302
2574493 WA King   school 5302820 17210   Federal Way School District 530282002719 1789 Federal Way Public Academy   Regular School No Middle 06 10 2020   grade_7 22 4 19   1 11     1   6   36 28 0   1   0   28       0.0 64 22 4 19   1 11     1   6   36 28 0   1 0 28     0 64
2574510 WA King   school 5302820 17210   Federal Way School District 530282000437 3898 Illahee Middle School   Regular School No Middle 05 08 2020   grade_7 58 52 63   2 39     24   41   148 130 1   43   5   183       9.0 279 58 52 63   2 39     24   41   148 130 1   43 5 183     9 279
2574522 WA King   school 5302820 17210   Federal Way School District 530282002638 1759 Internet Academy   Alternative School No Other PK 12 2020   grade_7 12 2 2   0 3     0   5   14 10 0   1   0   7       2.0 24 12 2 2   0 3     0   5   14 10 0   1 0 7     2 24
2574528 WA King   school 5302820 17210   Federal Way School District 530282000438 3701 Kilo Middle School   Regular School No Middle 06 08 2020   grade_7 63 25 70   1 21     7   18   121 84 0   37   10   145       8.0 205 63 25 70   1 21     7   18   121 84 0   37 10 145     8 205
2574553 WA King   school 5302820 17210   Federal Way School District 530282000442 3381 Lakota Middle School   Regular School No Middle 06 08 2020   grade_7 68 37 89   2 22     22   27   142 124 1   35   11   171       14.0 267 68 37 89   2 22     22   27   142 124 1   35 11 171     14 267
2574584 WA King   school 5302820 17210   Federal Way School District 530282000444 3625 Nautilus K-8 School   Regular School No Elementary KG 08 2020   grade_7 14 2 5   0 3     1   3   19 9 0   4   0   16       2.0 28 14 2 5   0 3     1   3   19 9 0   4 0 16     2 28
2574614 WA King   school 5302820 17210   Federal Way School District 530282000448 3626 Sacajawea Middle School   Regular School No Middle 06 08 2020   grade_7 45 39 116   1 25     16   23   151 113 1   53   9   208       5.0 265 45 39 116   1 25     16   23   151 113 1   53 9 208     5 265
2574618 WA King   school 5302820 17210   Federal Way School District 530282002964 5029 Sequoyah Middle School   Regular School No Middle 06 08 2020   grade_7 60 42 56   1 26     8   20   103 110 0   33   5   158       5.0 213 60 42 56   1 26     8   20   103 110 0   33 5 158     5 213
2574659 WA King   school 5302820 17210   Federal Way School District 530282002961 1951 Support School   Regular School No Other PK 12 2020   grade_7 1 0 1   0 0     0   0   1 1 0   0   0   0       0.0 2 1 0 1   0 0     0   0   1 1 0   0 0 0     0 2
2574669 WA King   school 5302820 17210   Federal Way School District 530282003610 5473 Technology Access Foundation Academy at Saghalie   Regular School No High 06 12 2020   grade_7 32 21 54   1 11     10   23   84 68 0   27   3   108       6.0 152 32 21 54   1 11     10   23   84 68 0   27 3 108     6 152
2574684 WA King   school 5302820 17210   Federal Way School District 530282000452 3431 Totem Middle School   Regular School No Middle 06 08 2020   grade_7 26 49 82   0 33     9   22   124 97 0   65   3   169       3.0 221 26 49 82   0 33     9   22   124 97 0   65 3 169     3 221
2574715 WA King   school 5302820 17210   Federal Way School District 530282000456 3328 Woodmont K-8 School   Regular School No Elementary KG 08 2020   grade_7 4 3 6   0 3     0   1   10 7 0   5   0   10       0.0 17 4 3 6   0 3     0   1   10 7 0   5 0 10     0 17
2574768 WA Whatcom   school 5302850 37502   Ferndale School District 530285003625 5474 Ferndale Parent Partnership (Closed after 2019-2020 school year)   Alternative School No Other KG 10 2020   grade_7 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
2574777 WA Whatcom   school 5302850 37502   Ferndale School District 530285002832 4554 Horizon Middle School   Regular School No Middle 06 08 2020   grade_7 99 2 31   18 8     0   18   68 107 1   8   1   90       4.0 176 99 2 31   18 8     0   18   68 107 1   8 1 90     4 176
2574788 WA Whatcom   school 5302850 37502   Ferndale School District 530285000463 3762 Vista Middle School   Regular School No Middle 06 08 2020   grade_7 103 2 50   18 9     2   15   111 87 1   18   6   107       13.0 199 103 2 50   18 9     2   15   111 87 1   18 6 107     13 199
2574820 WA Pierce   school 5302880 27417   Fife School District 530288000467 3798 Surprise Lake Middle School   Regular School No Middle 06 07 2020   grade_7 123 18 64   3 28     16   37   154 135 0   24   5   144       18.0 289 123 18 64   3 28     16   37   154 135 0   24 5 144     18 289
2574831 WA Benton   school 5302910 3053   Finley School District 530291002100 4031 Finley Middle School   Regular School No Middle 06 08 2020   grade_7 32 0 27   1 0     0   1   24 37 0   7   2   50       2.0 61 32 0 27   1 0     0   1   24 37 0   7 2 50     2 61
2574907 WA Pierce   school 5302940 27402   Franklin Pierce School District 530294000479 3300 Morris Ford Middle School   Regular School No Middle 06 08 2020   grade_7 98 22 136   4 30     15   54   198 161 0   38   21   285       13.0 359 98 22 136   4 30     15   54   198 161 0   38 21 285     13 359
2574911 WA Pierce   school 5302940 27402   Franklin Pierce School District 530294000481 3401 Perry G Keithley Middle School   Regular School No Middle 06 08 2020   grade_7 86 31 87   2 13     31   44   153 141 0   22   12   249       10.0 294 86 31 87   2 13     31   44   153 141 0   22 12 249     10 294
2574933 WA Spokane   school 5302970 32358   Freeman School District 530297003013 4593 Freeman Middle School   Regular School No Middle 06 08 2020   grade_7 76 0 5   0 0     0   0   39 42 0   0   0   19       9.0 81 76 0 5   0 0     0   0   39 42 0   0 0 19     9 81
2574950 WA Whitman   school 5303000 38302   Garfield School District 530300000487 2896 Garfield Middle School   Regular School No Middle 06 08 2020   grade_7 10 0 0   0 0     0   0   4 6 0   0   0   9       0.0 10 10 0 0   0 0     0   0   4 6 0   0 0 9     0 10
2574964 WA Klickitat   school 5303030 20401   Glenwood School District 530303000489 3048 Glenwood Secondary   Regular School No High 06 12 2020   grade_7 4 0 2   2 0     0   2   6 4 0   0   1   4       0.0 10 4 0 2   2 0     0   2   6 4 0   0 1 4     0 10
2574975 WA Klickitat   school 5303090 20404   Goldendale School District 530309000491 3393 Goldendale Middle School   Regular School No Middle 05 08 2020   grade_7 52 0 7   5 1     0   6   36 35 0   4   6   45       3.0 71 52 0 7   5 1     0   6   36 35 0   4 6 45     3 71

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