Data source: Big Local News · About: Big Local

109,573 rows where state = "WA" sorted by total descending

View and edit SQL

grade

year

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
528091 WA Thurston   school 5305850 34003   North Thurston Public Schools 530585000862 3361 Chinook Middle School   Regular School No 2 06 08 2016   pk_12_total 513 58 185   10 96     12   125   558 441 0   54   40   471       56.0 999 513 58 185   10 96     12   125   558 441 0   54 40 471     56 999
627684 WA King   school 5307230 17403   Renton School District 530723001070 3434 Nelsen Middle School   Regular School No Middle 06 08 2017   pk_12_total 292 176 191   2 241     16   81   550 449 0   78   35   622       48.0 999 292 176 191   2 241     16   81   550 449 0   78 35 622     48 999
2471788 WA Clark   school 5309270 6037   Vancouver School District 530927001577 3146 Mcloughlin Middle School   Regular School No Middle 06 08 2018   pk_12_total 319 30 484   3 32     59   72   482 517 0   265   42   809       30.0 999 319 30 484   3 32     59   72   482 517 0   265 42 809     30 999
468188 WA Thurston   school 5305850 34003   North Thurston Public Schools 530585000862 3361 Chinook Middle School   Regular School No 2.0 06 08 2015   pk_12_total 530 43 181   14 104     11   115   535 463 0   51   41   480       51.0 998 530 43 181   14 104     11   115   535 463 0   51 41 480     51 998
2458071 WA Clark   school 5300380 6119   Battle Ground School District 530038002857 1875 Homelink River   Alternative School No Other KG 12 2018   pk_12_total 850 6 59   8 11     0   64   473 525 0   47   20   298       41.0 998 850 6 59   8 11     0   64   473 525 0   47 20 298     41 998
2417569 WA Pierce   school 5302940 27402   Franklin Pierce School District 530294000479 3300 Morris Ford Middle School   Regular School No Middle 06 08 2019   pk_12_total 323 88 313   8 85     42   139   530 468 0   75   46   788       26.0 998 323 88 313   8 85     42   139   530 468 0   75 46 788     26 998
2580201 WA Pierce   school 5306960 27003   Puyallup School District 530696003690 5557 Dessie F Evans Elementary   Regular School No Elementary PK 06 2020   pk_12_total 495 50 250   8 71     12   112   542 456 0   122   5   398       50.0 998 495 50 250   8 71     12   112   542 456 0   122 5 398     50 998
2581543 WA King   school 5307710 17001   Seattle School District No. 1 530771003467 5351 Jane Addams Middle School   Regular School No Middle 06 08 2020   pk_12_total 497 82 146   2 132     4   135   532 466 0   94   53   300       46.0 998 497 82 146   2 132     4   135   532 466 0   94 53 300     46 998
631589 WA Clark   school 5309270 6037   Vancouver School District 530927001577 3146 Mcloughlin Middle School   Regular School No Middle 06 08 2017   pk_12_total 320 34 486   2 33     54   68   484 513 0   252   63   825       27.0 997 320 34 486   2 33     54   68   484 513 0   252 63 825     27 997
2423383 WA King   school 5307230 17403   Renton School District 530723001070 3434 Nelsen Middle School   Regular School No Middle 06 08 2019   pk_12_total 251 147 229   8 236     24   102   510 487 0   124   38   595       63.0 997 251 147 229   8 236     24   102   510 487 0   124 38 595     63 997
2934901 WA Snohomish   school 5302670 31002   Everett School District 530267002253 4334 Heatherwood Middle School   Regular School No Middle 06 08 2021   pk_12_total 464 37 186   5 207     7   91   531 463 3   68   24   292       42.0 997 464 37 186   5 207     7   91   531 463 3   68 24 292     42 997
526267 WA King   school 5304230 17414   Lake Washington School District 530423000680 3232 Redmond Middle School   Regular School No 2 06 08 2016   pk_12_total 490 25 145   2 246     2   84   519 476 0   57   11   192       34.0 995 490 25 145   2 246     2   84   519 476 0   57 11 192     34 995
2418242 WA King   school 5303750 17411   Issaquah School District 530375000573 3038 Issaquah Middle School   Regular School No Middle 06 08 2019   pk_12_total 522 21 134   2 231     2   83   514 481 0   60   4   148       74.0 995 522 21 134   2 231     2   83   514 481 0   60 4 148     74 995
2573305 WA Douglas   school 5302310 9206   Eastmont School District 530231000323 3372 Eastmont Junior High   Regular School No Secondary 08 09 2020   pk_12_total 481 3 471   4 6     1   29   508 487 0   132   29   586       65.0 995 481 3 471   4 6     1   29   508 487 0   132 29 586     65 995
531506 WA King   school 5307710 17001   Seattle School District No. 1 530771001262 2234 West Seattle High School   Regular School No 3 09 12 2016   pk_12_total 519 116 127   15 126     7   84   481 513 0   50   37   341       32.0 994 519 116 127   15 126     7   84   481 513 0   50 37 341     32 994
628016 WA King   school 5304560 17407   Riverview School District 530456000716 3524 Cedarcrest High School   Regular School No High 09 12 2017   pk_12_total 804 4 115   9 27     4   31   485 509 0   8   12   151       46.0 994 804 4 115   9 27     4   31   485 509 0   8 12 151     46 994
2570834 WA Clark   school 5300380 6119   Battle Ground School District 530038002857 1875 Homelink River   Alternative School No Other KG 12 2020   pk_12_total 839 9 67   9 11     0   59   466 528 0   66   5   309       47.0 994 839 9 67   9 11     0   59   466 528 0   66 5 309     47 994
622407 WA King   school 5303750 17411   Issaquah School District 530375003337 5200 Pacific Cascade Middle School   Regular School No Middle 06 08 2017   pk_12_total 546 15 53   0 316     4   59   508 485 0   34   5   57       65.0 993 546 15 53   0 316     4   59   508 485 0   34 5 57     65 993
623636 WA King   school 5304230 17414   Lake Washington School District 530423000680 3232 Redmond Middle School   Regular School No Middle 06 08 2017   pk_12_total 493 18 139   1 252     2   88   527 466 0   57   10   172       75.0 993 493 18 139   1 252     2   88   527 466 0   57 10 172     75 993
2460870 WA Kittitas   school 5302460 19401   Ellensburg School District 530246000365 2996 Ellensburg High School   Regular School No High 09 12 2018   pk_12_total 773 9 163   6 15     2   25   491 502 0   56   8   351       45.0 993 773 9 163   6 15     2   25   491 502 0   56 8 351     45 993
2572266 WA Lewis   school 5301140 21401   Centralia School District 530114000206 2166 Centralia High School   Regular School No High 09 12 2020   pk_12_total 587 16 322   9 16     1   42   512 481 0   66   46   739       45.0 993 587 16 322   9 16     1   42   512 481 0   66 46 739     45 993
628862 WA King   school 5307710 17001   Seattle School District No. 1 530771001262 2234 West Seattle High School   Regular School No High 09 12 2017   pk_12_total 521 115 136   9 124     7   80   494 498 0   51   39   314       30.0 992 521 115 136   9 124     7   80   494 498 0   51 39 314     30 992
2464137 WA Cowlitz   school 5304470 8122   Longview School District 530447000703 3151 Mark Morris High School   Regular School No High 09 12 2018   pk_12_total 711 7 160   14 22     2   76   474 518 0   29   41   454       25.0 992 711 7 160   14 22     2   76   474 518 0   29 41 454     25 992
2416855 WA Clark   school 5302700 6114   Evergreen School District (Clark) 530270000414 3785 Cascade Middle School   Regular School No Middle 06 08 2019   pk_12_total 527 26 284   2 31     31   91   529 463 0   113   33   642       20.0 992 527 26 284   2 31     31   91   529 463 0   113 33 642     20 992
2458193 WA King   school 5300390 17405   Bellevue School District 530039000064 3338 Chinook Middle School   Regular School No Middle 06 08 2018   pk_12_total 483 24 86   0 307     1   88   478 513 0   89   11   108       86.0 991 483 24 86   0 307     1   88   478 513 0   89 11 108     86 991
2471233 WA King   school 5308760 17409   Tahoma School District 530876002979 3341 Summit Trail Middle School   Regular School No Middle 06 08 2018   pk_12_total 762 21 81   3 48     3   73   523 468 0   10   5   116       87.0 991 762 21 81   3 48     3   73   523 468 0   10 5 116     87 991
465264 WA Benton   school 5303930 3017   Kennewick School District 530393000598 4028 Desert Hills Middle School   Regular School No 4.0 06 10 2015   pk_12_total 783 11 147   7 23     0   19   538 452 0   8   3   294       4.0 990 783 11 147   7 23     0   19   538 452 0   8 3 294     4 990
469376 WA Franklin   school 5306570 11001   Pasco School District 530657000973 3324 Stevens Middle School   Regular School No 2.0 06 08 2015   pk_12_total 81 12 876   0 4     1   16   509 481 0   394   36   929       21.0 990 81 12 876   0 4     1   16   509 481 0   394 36 929     21 990
459861 WA Snohomish   school 5300240 31016   Arlington School District 530024002248 4327 Eagle Creek Elementary   Regular School No 1.0 KG 06 2015   grade_5 79 1 15   1 0     0   3   60 39 0   10   3   45       2.0 99 79 1 15   1 0     0   3   60 39 0   10 3 45     2 99
459870 WA Snohomish   school 5300240 31016   Arlington School District 530024001190 4436 Kent Prairie Elementary   Regular School No 1.0 KG 06 2015   grade_2 77 1 10   1 1     0   9   61 38 0   3   4   52       2.0 99 77 1 10   1 1     0   9   61 38 0   3 4 52     2 99
459879 WA Snohomish   school 5300240 31016   Arlington School District 530024002940 4573 Pioneer Elementary   Regular School No 1.0 KG 06 2015   grade_2 74 2 12   1 0     0   10   46 53 0   5   0   29       0.0 99 74 2 12   1 0     0   10   46 53 0   5 0 29     0 99
459935 WA King   school 5300300 17408   Auburn School District 530030000029 3825 Alpac Elementary School   Regular School No 1.0 PK 05 2015   grade_2 49 1 26   1 10     6   6   50 49 0   33   2   78       0.0 99 49 1 26   1 10     6   6   50 49 0   33 2 78     0 99
460116 WA Kitsap   school 5300330 18303   Bainbridge Island School District 530033000044 3043 Capt. Charles Wilkes Elem School   Regular School No 1.0 PK 04 2015   grade_4 80 0 8   0 1     0   10   56 43 0   0   0   5       5.0 99 80 0 8   0 1     0   10   56 43 0   0 0 5     5 99
460374 WA King   school 5300390 17405   Bellevue School District 530039000067 2846 Enatai Elementary School   Regular School No 1.0 KG 05 2015   grade_5 58 3 11   0 20     0   7   47 52 0   13   3   22       1.0 99 58 3 11   0 20     0   7   47 52 0   13 3 22     1 99
460443 WA King   school 5300390 17405   Bellevue School District 530039000090 3224 Puesta del Sol Elementary School   Regular School No 1.0 KG 05 2015   grade_3 58 1 21   0 11     0   8   41 58 0   1   0   6       4.0 99 58 1 21   0 11     0   8   41 58 0   1 0 6     4 99
460720 WA Pierce   school 5300480 27403   Bethel School District 530048000122 2576 Clover Creek Elementary   Regular School No 1.0 PK 06 2015   grade_3 59 7 11   1 2     3   16   50 49 0   0   0   57       0.0 99 59 7 11   1 2     3   16   50 49 0   0 0 57     0 99
460981 WA Kitsap   school 5300660 18100   Bremerton School District 530066000143 3171 Naval Avenue Elementary School   Regular School No 1.0 PK 05 2015   grade_1 41 9 25   0 2     4   18   46 53 0   6   4   59       8.0 99 41 9 25   0 2     4   18   46 53 0   6 4 59     8 99
461335 WA Kitsap   school 5301080 18401   Central Kitsap School District 530108000180 4016 Clear Creek Elementary School   Regular School No 1.0 PK 06 2015   grade_1 55 6 23   0 2     1   12   49 50 0   7   1   53       0.0 99 55 6 23   0 2     1   12   49 50 0   7 1 53     0 99
461369 WA Kitsap   school 5301080 18401   Central Kitsap School District 530108000757 4444 Emerald Heights Elementary   Regular School No 1.0 PK 06 2015   grade_4 61 2 13   1 5     2   15   50 49 0   2   2   27       4.0 99 61 2 13   1 5     2   15   50 49 0   2 2 27     4 99
461672 WA Lewis   school 5301140 21401   Centralia School District 530114000209 3172 Jefferson Lincoln Elementary   Regular School No 1.0 PK 03 2015   kindergarten_half_day 52 1 41   0 0     1   4   44 55 0   29   2   89       0.0 99 52 1 41   0 0     1   4   44 55 0   29 2 89     0 99
463132 WA Grays Harbor   school 5302490 14068   Elma School District 530249000371 3217 Elma Elementary School   Regular School No 1.0 PK 05 2015   grade_3 64 1 22   3 1     0   8   47 52 0   13   4   65       1.0 99 64 1 22   3 1     0   8   47 52 0   13 4 65     1 99
463145 WA Grays Harbor   school 5302490 14068   Elma School District 530249002060 4245 Elma Middle School   Regular School No 2.0 06 08 2015   grade_8 78 0 14   0 0     0   7   48 51 0   4   8   66       14.0 99 78 0 14   0 0     0   7   48 51 0   4 8 66     14 99
463390 WA Snohomish   school 5302670 31002   Everett School District 530267003195 5091 Forest View Elementary School   Regular School No 1.0 KG 05 2015   grade_3 60 2 6   0 25     0   6   52 47 0   6   0   11       3.0 99 60 2 6   0 25     0   6   52 47 0   6 0 11     3 99
463712 WA Clark   school 5302700 6114   Evergreen School District (Clark) 530270000420 3994 Image Elementary School   Regular School No 1.0 KG 05 2015   grade_2 57 1 20   0 6     4   11   57 42 0   40   2   72       1.0 99 57 1 20   0 6     4   11   57 42 0   40 2 72     1 99
463720 WA Clark   school 5302700 6114   Evergreen School District (Clark) 530270002710 1801 iQ Academy Washington (Closed after 2016-2017 school year)   Alternative Education School No 3.0 07 12 2015   grade_10 64 13 10   3 2     1   6   40 59 0   0   0   30       0.0 99 64 13 10   3 2     1   6   40 59 0   0 0 30     0 99
463805 WA Clark   school 5302700 6114   Evergreen School District (Clark) 530270000427 3970 Sunset Elementary School   Regular School No 1.0 KG 05 2015   grade_5 65 2 18   1 8     0   5   47 52 0   22   3   51       5.0 99 65 2 18   1 8     0   5   47 52 0   22 3 51     5 99
464159 WA Whatcom   school 5302850 37502   Ferndale School District 530285002495 4482 Eagleridge Elementary   Regular School No 1.0 PK 06 2015   grade_3 45 0 20   20 5     0   9   53 46 0   5   4   68       6.0 99 45 0 20   20 5     0   9   53 46 0   5 4 68     6 99
464437 WA Yakima   school 5303150 39200   Grandview School District 530315002497 1645 Compass High School (Closed after 2016-2017 school year)   Alternative Education School No 3.0 09 12 2015   pk_12_total 4 1 93   0 0     0   1   57 42 0   24   4   77       1.0 99 4 1 93   0 0     0   1   57 42 0   24 4 77     1 99
464458 WA Yakima   school 5303150 39200   Grandview School District 530315000501 2345 Mcclure Elementary School   Regular School No 1.0 PK 05 2015   kindergarten 3 0 96   0 0     0   0   47 52 0   54   8   74       0.0 99 3 0 96   0 0     0   0   47 52 0   54 8 74     0 99
464690 WA King   school 5303540 17401   Highline School District 530354000529 2699 Hazel Valley Elementary   Regular School No 1.0 PK 06 2015   grade_2 17 11 49   1 13     2   6   49 50 0   53   6   83       1.0 99 17 11 49   1 13     2   6   49 50 0   53 6 83     1 99
464748 WA King   school 5303540 17401   Highline School District 530354000537 2984 Midway Elementary   Regular School No 1.0 PK 06 2015   grade_2 9 15 48   0 7     11   9   48 51 0   35   6   89       1.0 99 9 15 48   0 7     11   9   48 51 0   35 6 89     1 99
464932 WA King   school 5303750 17411   Issaquah School District 530375000570 3746 Apollo Elementary   Regular School No 1.0 PK 05 2015   grade_5 55 2 11   0 27     0   4   53 46 0   7   0   25       6.0 99 55 2 11   0 27     0   4   53 46 0   7 0 25     6 99
464978 WA King   school 5303750 17411   Issaquah School District 530375000482 4375 Cougar Ridge Elementary   Regular School No 1.0 KG 05 2015   grade_5 57 2 2   0 32     0   6   45 54 0   4   0   1       5.0 99 57 2 2   0 32     0   6   45 54 0   4 0 1     5 99
465008 WA King   school 5303750 17411   Issaquah School District 530375002518 4493 Endeavour Elementary School   Regular School No 1.0 KG 05 2015   grade_1 52 0 7   0 34     0   6   58 41 0   18   0   6       2.0 99 52 0 7   0 34     0   6   58 41 0   18 0 6     2 99
465015 WA King   school 5303750 17411   Issaquah School District 530375002518 4493 Endeavour Elementary School   Regular School No 1.0 KG 05 2015   kindergarten 53 0 2   1 35     0   8   57 42 0   23   0   4       0.0 99 53 0 2   1 35     0   8   57 42 0   23 0 4     0 99
465066 WA King   school 5303750 17411   Issaquah School District 530375002981 4592 Newcastle Elementary School   Regular School No 1.0 KG 05 2015   grade_1 44 0 10   0 28     0   17   45 54 0   13   0   12       2.0 99 44 0 10   0 28     0   17   45 54 0   13 0 12     2 99
465260 WA Benton   school 5303930 3017   Kennewick School District 530393003330 5220 Cottonwood Elementary   Regular School No 1.0 KG 05 2015   kindergarten_half_day 89 2 1   0 1     0   6   53 46 0   2   1   10       0.0 99 89 2 1   0 1     0   6   53 46 0   2 1 10     0 99
465286 WA Benton   school 5303930 3017   Kennewick School District 530393000602 3077 Hawthorne Elementary School   Regular School No 1.0 KG 05 2015   kindergarten 35 2 55   0 0     1   6   52 47 0   33   1   83       0.0 99 35 2 55   0 0     1   6   52 47 0   33 1 83     0 99
465349 WA Benton   school 5303930 3017   Kennewick School District 530393000762 4446 Ridge View Elementary School   Regular School No 1.0 KG 05 2015   grade_3 81 0 11   0 3     0   4   58 41 0   1   0   22       1.0 99 81 0 11   0 3     0   4   58 41 0   1 0 22     1 99
465526 WA King   school 5303960 17415   Kent School District 530396000619 4520 Kent Elementary School   Regular School No 1.0 KG 06 2015   grade_3 16 6 53   0 5     7   12   40 59 0   50   2   85       2.0 99 16 6 53   0 5     7   12   40 59 0   50 2 85     2 99
465681 WA King   school 5303960 17415   Kent School District 530396000631 3389 Scenic Hill Elementary School   Regular School No 1.0 KG 06 2015   grade_2 18 15 44   0 8     5   9   59 40 0   54   1   86       4.0 99 18 15 44   0 8     5   9   59 40 0   54 1 86     4 99
466221 WA King   school 5304230 17414   Lake Washington School District 530423002257 4336 Laura Ingalls Wilder Elementary   Regular School No 1.0 KG 06 2015   grade_5 60 1 4   1 29     0   4   55 44 0   3   0   2       6.0 99 60 1 4   1 29     0   4   55 44 0   3 0 2     6 99
466828 WA Snohomish   school 5304860 31025   Marysville School District 530486002261 4323 Kellogg Marsh Elementary School   Regular School No 1.0 PK 05 2015   grade_2 62 0 19   1 4     3   10   48 51 0   14   1   56       0.0 99 62 0 19   1 4     3   10   48 51 0   14 1 56     0 99
466893 WA Snohomish   school 5304860 31025   Marysville School District 530486000738 3651 Pinewood Elementary   Regular School No 1.0 KG 05 2015   grade_2 60 0 23   0 3     1   12   45 54 0   11   1   48       0.0 99 60 0 23   0 3     1   12   45 54 0   11 1 48     0 99
466913 WA Snohomish   school 5304860 31025   Marysville School District 530486003322 5214 School for the Entrepreneur (Closed after 2016-2017 school year)   Regular School No 3.0 09 12 2015   grade_9 58 1 18   8 4     1   9   53 46 0   4   0   45       3.0 99 58 1 18   8 4     1   9   53 46 0   4 0 45     3 99
467209 WA Snohomish   school 5305130 31103   Monroe School District 530513000773 3060 Frank Wagner Elementary   Regular School No 1.0 PK 05 2015   grade_1 32 0 60   0 1     0   6   48 51 0   52   0   77       2.0 99 32 0 60   0 1     0   6   48 51 0   52 0 77     2 99
467210 WA Snohomish   school 5305130 31103   Monroe School District 530513000773 3060 Frank Wagner Elementary   Regular School No 1.0 PK 05 2015   grade_2 27 0 61   0 3     0   8   52 47 0   49   2   76       2.0 99 27 0 61   0 3     0   8   52 47 0   49 2 76     2 99
467661 WA Snohomish   school 5305430 31006   Mukilteo School District 530543002263 4342 Columbia Elementary   Regular School No 1.0 PK 05 2015   grade_1 50 4 15   0 14     1   15   50 49 0   12   1   32       1.0 99 50 4 15   0 14     1   15   50 49 0   12 1 32     1 99
467749 WA Snohomish   school 5305430 31006   Mukilteo School District 530543001853 4165 Picnic Point Elementary   Regular School No 1.0 KG 05 2015   grade_1 46 10 21   0 10     0   12   46 53 0   34   0   46       0.0 99 46 10 21   0 10     0   12   46 53 0   34 0 46     0 99
467858 WA Pend Oreille   school 5305610 26056   Newport School District 530561000833 2518 Newport High School   Regular School No 3.0 09 12 2015   grade_10 87 0 5   0 1     0   6   51 48 0   0   7   57       5.0 99 87 0 5   0 1     0   6   51 48 0   0 7 57     5 99
468201 WA Thurston   school 5305850 34003   North Thurston Public Schools 530585000601 4408 Horizons Elementary   Regular School No 1.0 KG 06 2015   grade_5 56 3 12   0 7     4   17   47 52 0   2   3   34       5.0 99 56 3 12   0 7     4   17   47 52 0   2 3 34     5 99
468434 WA King   school 5305910 17417   Northshore School District 530591002222 4306 Fernwood Elementary   Regular School No 1.0 KG 06 2015   grade_5 54 1 8   1 28     0   7   52 47 0   8   1   12       4.0 99 54 1 8   1 28     0   7   52 47 0   8 1 12     4 99
468630 WA Island   school 5305940 15201   Oak Harbor School District 530594000898 3477 Broadview Elementary   Regular School No 1.0 KG 05 2015   grade_1 57 5 13   1 3     2   18   60 39 0   7   1   47       2.0 99 57 5 13   1 3     2   18   60 39 0   7 1 47     2 99
469304 WA Franklin   school 5306570 11001   Pasco School District 530657000965 2790 Longfellow Elementary   Regular School No 1.0 KG 05 2015   grade_4 8 0 91   0 0     0   0   45 54 0   70   3   97       3.0 99 8 0 91   0 0     0   0   45 54 0   70 3 97     3 99
469310 WA Franklin   school 5306570 11001   Pasco School District 530657000966 3085 Mark Twain Elementary   Regular School No 1.0 KG 05 2015   grade_4 32 2 63   0 1     0   1   53 46 0   34   1   74       0.0 99 32 2 63   0 1     0   1   53 46 0   34 1 74     0 99
469841 WA Pierce   school 5306960 27003   Puyallup School District 530696003191 5093 G W Edgerton Elementary   Regular School No 1.0 PK 06 2015   grade_1 72 4 8   0 3     0   12   44 55 0   3   1   28       2.0 99 72 4 8   0 3     0   12   44 55 0   3 1 28     2 99
471464 WA King   school 5307710 17001   Seattle School District No. 1 530771001256 2667 View Ridge Elementary School   Regular School No 1.0 PK 05 2015   grade_3 73 1 10   0 9     1   5   44 55 0   4   1   6       0.0 99 73 1 10   0 9     1   5   44 55 0   4 1 6     0 99
471615 WA Yakima   school 5307770 39119   Selah School District 530777001283 3265 Robert S Lince Elementary (Closed after 2014-2015 school year)   Regular School No 1.0 PK 04 2015   grade_1 54 0 43   2 0     0   0   53 46 0   20   0   74       0.0 99 54 0 43   2 0     0   0   53 46 0   20 0 74     0 99
471736 WA Mason   school 5307900 23309   Shelton School District 530790001293 2745 Evergreen Elementary School   Regular School No 1.0 PK 05 2015   grade_3 13 0 82   0 2     0   2   53 46 0   56   3   87       0.0 99 13 0 82   0 2     0   2   53 46 0   56 3 87     0 99
471752 WA Mason   school 5307900 23309   Shelton School District 530790001294 3292 Mountain View Elementary   Regular School No 1.0 PK 05 2015   grade_4 80 0 11   1 1     0   6   49 50 0   2   6   59       0.0 99 80 0 11   1 1     0   6   49 50 0   2 6 59     0 99
471892 WA King   school 5307920 17412   Shoreline School District 530792001314 2703 Ridgecrest Elementary   Regular School No 1.0 KG 06 2015   grade_6 50 6 14   1 17     0   11   53 46 0   4   5   37       6.0 99 50 6 14   1 17     0   11   53 46 0   4 5 37     6 99
472077 WA King   school 5308040 17410   Snoqualmie Valley School District 530804002239 4308 Edwin R Opstad Elementary   Regular School No 1.0 PK 05 2015   grade_5 82 0 11   1 0     0   5   41 58 0   3   3   29       4.0 99 82 0 11   1 0     0   5   41 58 0   3 3 29     4 99
472768 WA Spokane   school 5308250 32081   Spokane School District 530825003401 5301 The Community School   Regular School No 3.0 09 12 2015   pk_12_total 73 1 8   1 0     0   16   40 59 0   0   6   58       9.0 99 73 1 8   1 0     0   16   40 59 0   0 6 58     9 99
472953 WA Pierce   school 5308460 27001   Steilacoom Hist. School District 530846002879 4562 Chloe Clark Elementary   Regular School No 1.0 KG 05 2015   kindergarten_half_day 40 15 17   0 7     3   17   50 49 0   9   0   11       1.0 99 40 15 17   0 7     3   17   50 49 0   9 0 11     1 99
473226 WA Pierce   school 5308700 27010   Tacoma School District 530870001453 2940 Arlington   Regular School No 1.0 PK 05 2015   pre_kindergarten 18 20 29   0 3     3   26   52 47 0   0   0   74       0.0 99 18 20 29   0 3     3   26   52 47 0   0 0 74     0 99
473518 WA Pierce   school 5308700 27010   Tacoma School District 530870003286 5169 Science and Math Institute   Regular School No 3.0 09 12 2015   grade_9 71 5 12   2 7     0   2   61 38 0   1   2   47       3.0 99 71 5 12   2 7     0   2   61 38 0   1 2 47     3 99
473687 WA King   school 5308760 17409   Tahoma School District 530876001517 3589 Shadow Lake Elementary   Regular School No 1.0 PK 06 2015   grade_1 64 1 17   1 3     2   11   49 50 0   9   2   27       3.0 99 64 1 17   1 3     2   11   49 50 0   9 2 27     3 99
473732 WA Thurston   school 5308820 34402   Tenino School District 530882002241 4238 Tenino Elementary School   Regular School No 1.0 03 05 2015   grade_5 88 1 7   1 0     0   2   53 46 0   1   0   54       3.0 99 88 1 7   1 0     0   2   53 46 0   1 0 54     3 99
473734 WA Thurston   school 5308820 34402   Tenino School District 530882001522 3509 Tenino High School   Regular School No 3.0 09 12 2015   grade_10 85 1 10   1 0     1   1   55 44 0   4   0   43       7.0 99 85 1 10   1 0     1   1   55 44 0   4 0 43     7 99
473757 WA Kittitas   school 5308850 19400   Thorp School District 530885001525 2514 Thorp Elem & Jr Sr High   Regular School No 4.0 KG 12 2015   pk_12_total 89 1 8   0 0     0   1   51 48 0   0   6   63       0.0 99 89 1 8   0 0     0   1   51 48 0   0 6 63     0 99
474048 WA Pierce   school 5309180 27083   University Place School District 530918001552 3792 Chambers Elementary   Regular School No 1.0 KG 04 2015   grade_4 49 14 13   0 9     2   12   49 50 0   6   1   40       5.0 99 49 14 13   0 9     2   12   49 50 0   6 1 40     5 99
474068 WA Pierce   school 5309180 27083   University Place School District 530918001179 4447 Evergreen Primary   Regular School No 1.0 PK 04 2015   grade_3 57 15 8   0 4     1   14   63 36 0   6   2   43       3.0 99 57 15 8   0 4     1   14   63 36 0   6 2 43     3 99
474940 WA Spokane   school 5309690 32363   West Valley School District (Spokane) 530969002840 1842 Spokane Valley Transition School (Closed after 2019-2020 school year)   Alternative Education School No 3.0 09 12 2015   grade_12 81 2 5   2 0     0   9   49 50 0   3   5   61       2.0 99 81 2 5   2 0     0   9   49 50 0   3 5 61     2 99
475386 WA Yakima   school 5310110 39007   Yakima School District 531011001709 3312 Whitney Elementary   Regular School No 1.0 PK 05 2015   grade_1 35 1 57   0 1     0   5   49 50 0   34   6   86       0.0 99 35 1 57   0 1     0   5   49 50 0   34 6 86     0 99
475505 WA Yakima   school 5310170 39205   Zillah School District 531017002502 4481 Zillah Middle School   Regular School No 2.0 07 08 2015   grade_8 54 0 38   4 1     0   2   57 42 0   4   1   56       2.0 99 54 0 38   4 1     0   2   57 42 0   4 1 56     2 99
520333 WA King   school 5300390 17405   Bellevue School District 530039000065 2847 Clyde Hill Elementary   Regular School No 1 KG 05 2016   grade_2 37 1 5   0 44     0   12   47 52 0   14   0   4       3.0 99 37 1 5   0 44     0   12   47 52 0   14 0 4     3 99
520420 WA King   school 5300390 17405   Bellevue School District 530039000090 3224 Puesta del Sol Elementary School   Regular School No 1 KG 05 2016   grade_2 53 1 14   0 15     0   16   57 42 0   4   0   9       4.0 99 53 1 14   0 15     0   16   57 42 0   4 0 9     4 99
520694 WA Pierce   school 5300480 27403   Bethel School District 530048000121 3649 Chester H Thompson Elementary   Regular School No 1 KG 05 2016   grade_3 35 9 27   1 3     11   13   47 52 0   6   2   75       1.0 99 35 9 27   1 3     11   13   47 52 0   6 2 75     1 99
520779 WA Pierce   school 5300480 27403   Bethel School District 530048003288 5160 Nelson Elementary School   Regular School No 1 PK 05 2016   grade_3 64 1 22   2 1     1   8   49 50 0   4   1   45       1.0 99 64 1 22   2 1     1   8   49 50 0   4 1 45     1 99
520781 WA Pierce   school 5300480 27403   Bethel School District 530048003288 5160 Nelson Elementary School   Regular School No 1 PK 05 2016   grade_5 72 5 8   2 2     1   9   47 52 0   1   0   41       0.0 99 72 5 8   2 2     1   9   47 52 0   1 0 41     0 99

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