Data source: Big Local News · About: Big Local

15,758 rows where state = "WA" and year = 2017 sorted by total descending

View and edit SQL

grade

year

  • 2017 · 15,758
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
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
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
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
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
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
617103 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000011 2971 Stevens Elementary School   Regular School No Elementary PK 06 2017   grade_3 47 1 28   3 5     0   15   52 47 0   20   2   76       1.0 99 47 1 28   3 5     0   15   52 47 0   20 2 76     1 99
617221 WA Snohomish   school 5300240 31016   Arlington School District 530024002940 4573 Pioneer Elementary   Regular School No Elementary KG 05 2017   grade_4 73 0 16   2 1     0   7   41 58 0   6   1   28       2.0 99 73 0 16   2 1     0   7   41 58 0   6 1 28     2 99
617318 WA King   school 5300300 17408   Auburn School District 530030000037 2932 Dick Scobee Elementary School   Regular School No Elementary PK 05 2017   grade_2 32 10 31   0 8     5   13   55 44 0   30   4   80       2.0 99 32 10 31   0 8     5   13   55 44 0   30 4 80     2 99
617355 WA King   school 5300300 17408   Auburn School District 530030000698 4417 Ilalko Elementary School   Regular School No Elementary KG 05 2017   kindergarten 30 6 30   0 13     2   18   50 49 0   32   1   53       1.0 99 30 6 30   0 13     2   18   50 49 0   32 1 53     1 99
617619 WA Clark   school 5300380 6119   Battle Ground School District 530038003228 5132 Tukes Valley Primary   Regular School No Elementary PK 04 2017   grade_2 85 0 7   0 0     0   7   51 48 0   8   0   33       2.0 99 85 0 7   0 0     0   7   51 48 0   8 0 33     2 99
617783 WA King   school 5300390 17405   Bellevue School District 530039000090 3224 Puesta del Sol Elementary School   Regular School No Elementary PK 05 2017   grade_4 50 1 33   0 9     0   6   44 55 0   4   0   7       6.0 99 50 1 33   0 9     0   6   44 55 0   4 0 7     6 99
618117 WA Pierce   school 5300480 27403   Bethel School District 530048002203 4297 Graham Elementary   Regular School No Elementary KG 05 2017   grade_5 62 7 10   1 0     3   16   56 43 0   2   1   46       3.0 99 62 7 10   1 0     3   16   56 43 0   2 1 46     3 99
618140 WA Pierce   school 5300480 27403   Bethel School District 530048001749 4102 Naches Trail Elementary   Regular School No Elementary KG 05 2017   grade_3 48 5 13   3 5     5   20   48 51 0   9   3   58       1.0 99 48 5 13   3 5     5   20   48 51 0   9 3 58     1 99
618530 WA Clark   school 5300810 6117   Camas School District 530081002880 4563 Prune Hill Elem   Regular School No Elementary KG 05 2017   grade_4 61 0 16   0 10     1   11   50 49 0   7   0   13       3.0 99 61 0 16   0 10     1   11   50 49 0   7 0 13     3 99
618618 WA Chelan   school 5300950 4228   Cascade School District 530095000553 4403 Icicle River Middle School   Regular School No Middle 06 08 2017   grade_8 73 0 24   2 0     0   0   57 42 0   12   0   48       5.0 99 73 0 24   2 0     0   0   57 42 0   12 0 48     5 99
618817 WA Spokane   school 5301110 32356   Central Valley School District 530111000187 3259 Adams Elementary   Regular School No Elementary PK 05 2017   grade_2 70 0 18   2 4     1   4   52 47 0   10   1   50       3.0 99 70 0 18   2 4     1   4   52 47 0   10 1 50     3 99
619342 WA Pierce   school 5301410 27400   Clover Park School District 530141002438 4396 Evergreen Elementary School   Regular School No Elementary PK 05 2017   pre_kindergarten 36 13 31   0 5     2   12   70 29 0   0   0   75       0.0 99 36 13 31   0 5     2   12   70 29 0   0 0 75     0 99
620016 WA Douglas   school 5302310 9206   Eastmont School District 530231000317 3659 Cascade Elementary   Regular School No Elementary KG 04 2017   grade_4 50 0 47   0 0     0   2   53 46 0   25   0   48       3.0 99 50 0 47   0 0     0   2   53 46 0   25 0 48     3 99
620039 WA Douglas   school 5302310 9206   Eastmont School District 530231000319 2966 Grant Elementary School   Regular School No Elementary KG 04 2017   grade_2 46 0 50   0 0     0   3   50 49 0   42   1   61       2.0 99 46 0 50   0 0     0   3   50 49 0   42 1 61     2 99
620041 WA Douglas   school 5302310 9206   Eastmont School District 530231000319 2966 Grant Elementary School   Regular School No Elementary KG 04 2017   grade_4 52 0 42   1 1     1   2   53 46 0   22   0   46       0.0 99 52 0 42   1 1     1   2   53 46 0   22 0 46     0 99
620150 WA Snohomish   school 5302400 31015   Edmonds School District 530240000330 3302 Beverly Elementary   Regular School No Elementary KG 06 2017   kindergarten 48 8 18   1 12     3   9   57 42 0   27   1   28       5.0 99 48 8 18   1 12     3   9   57 42 0   27 1 28     5 99
620630 WA Grant   school 5302610 13165   Ephrata School District 530261000388 3092 Grant Elementary   Regular School No Elementary KG 04 2017   kindergarten 55 0 40   0 0     0   4   56 43 0   26   1   69       0.0 99 55 0 40   0 0     0   4   56 43 0   26 1 69     0 99
620894 WA Snohomish   school 5302670 31002   Everett School District 530267000411 2752 Whittier Elementary   Regular School No Elementary PK 05 2017   grade_2 75 5 8   0 5     0   6   58 41 0   3   3   38       0.0 99 75 5 8   0 5     0   6   58 41 0   3 3 38     0 99
620943 WA Clark   school 5302700 6114   Evergreen School District (Clark) 530270002946 4587 Columbia Valley Elementary   Regular School No Elementary PK 05 2017   grade_2 55 1 22   1 12     0   8   47 52 0   20   3   50       1.0 99 55 1 22   1 12     0   8   47 52 0   20 3 50     1 99
621452 WA King   school 5302820 17210   Federal Way School District 530282000455 3583 Wildwood Elementary School   Regular School No Elementary PK 05 2017   grade_3 12 15 49   0 7     10   6   46 53 0   39   2   94       0.0 99 12 15 49   0 7     10   6   46 53 0   39 2 94     0 99
621653 WA Pierce   school 5302940 27402   Franklin Pierce School District 530294003145 2340 Midland Elementary   Regular School No Elementary KG 05 2017   grade_3 27 10 29   1 4     7   21   54 45 0   12   4   87       1.0 99 27 10 29   1 4     7   21   54 45 0   12 4 87     1 99
621976 WA King   school 5303540 17401   Highline School District 530354000523 2926 Cedarhurst Elementary   Regular School No Elementary PK 06 2017   grade_2 19 7 40   1 18     4   10   47 52 0   43   5   78       1.0 99 19 7 40   1 18     4   10   47 52 0   43 5 78     1 99
622142 WA King   school 5303540 17401   Highline School District 530354000550 2842 Shorewood Elementary   Regular School No Elementary PK 06 2017   grade_3 38 9 25   0 16     0   11   46 53 0   25   4   55       0.0 99 38 9 25   0 16     0   11   46 53 0   25 4 55     0 99
622320 WA King   school 5303750 17411   Issaquah School District 530375002426 4376 Discovery Elementary   Regular School No Elementary PK 05 2017   grade_4 28 0 15   0 50     0   6   46 53 0   6   0   2       3.0 99 28 0 15   0 50     0   6   46 53 0   6 0 2     3 99
622717 WA Benton   school 5303930 3017   Kennewick School District 530393001774 4136 Sunset View Elementary School   Regular School No Elementary KG 05 2017   kindergarten 75 3 10   0 3     0   8   46 53 0   9   0   47       3.0 99 75 3 10   0 3     0   8   46 53 0   9 0 47     3 99
622722 WA Benton   school 5303930 3017   Kennewick School District 530393000609 3369 Vista Elementary School   Regular School No Elementary KG 05 2017   grade_5 57 2 31   1 3     0   5   42 57 0   13   4   72       5.0 99 57 2 31   1 3     0   5   42 57 0   13 4 72     5 99
622941 WA King   school 5303960 17415   Kent School District 530396000625 2565 Meridian Elementary School   Regular School No Elementary PK 06 2017   grade_3 46 9 21   0 15     1   7   54 45 0   24   3   46       0.0 99 46 9 21   0 15     1   7   54 45 0   24 3 46     0 99
622975 WA King   school 5303960 17415   Kent School District 530396000628 5178 Panther Lake Elementary School   Regular School No Elementary PK 06 2017   grade_1 24 15 28   0 18     1   13   58 41 0   41   0   67       7.0 99 24 15 28   0 18     1   13   58 41 0   41 0 67     7 99
623096 WA Benton   school 5304020 3052   Kiona-Benton City School District 530402000641 2759 Kiona-Benton City Primary School   Regular School No Elementary PK 02 2017   grade_1 66 0 32   0 1     0   0   53 46 0   42   14   73       0.0 99 66 0 32   0 1     0   0   53 46 0   42 14 73     0 99
623257 WA Snohomish   school 5304200 31004   Lake Stevens School District 530420000520 4391 Glenwood Elementary   Regular School No Elementary KG 05 2017   grade_5 74 3 13   0 0     0   9   46 53 0   2   1   21       8.0 99 74 3 13   0 0     0   9   46 53 0   2 1 21     8 99
623510 WA King   school 5304230 17414   Lake Washington School District 530423000657 3548 John J. Audubon Elementary   Regular School No Elementary KG 05 2017   kindergarten 27 1 11   0 56     0   4   45 54 0   47   0   4       1.0 99 27 1 11   0 56     0   4   45 54 0   47 0 4     1 99
623554 WA King   school 5304230 17414   Lake Washington School District 530423000675 3041 Lakeview Elementary   Regular School No Elementary KG 05 2017   kindergarten 46 0 17   1 21     0   14   55 44 0   27   0   12       1.0 99 46 0 17   1 21     0   14   55 44 0   27 0 12     1 99
623573 WA King   school 5304230 17414   Lake Washington School District 530423001785 4096 Margaret Mead Elementary   Regular School No Elementary KG 05 2017   grade_2 50 1 11   1 30     0   6   44 55 0   10   0   6       1.0 99 50 1 11   1 30     0   6   44 55 0   10 0 6     1 99
623580 WA King   school 5304230 17414   Lake Washington School District 530423000676 3441 Mark Twain Elementary   Regular School No Elementary KG 05 2017   grade_2 47 1 18   2 17     0   14   39 60 0   17   3   23       3.0 99 47 1 18   2 17     0   14   39 60 0   17 3 23     3 99
623652 WA King   school 5304230 17414   Lake Washington School District 530423003077 5053 Rosa Parks Elementary   Regular School No Elementary KG 05 2017   grade_4 41 2 10   1 38     0   7   51 48 0   6   0   2       4.0 99 41 2 10   1 38     0   7   51 48 0   6 0 2     4 99
623936 WA Whatcom   school 5304620 37504   Lynden School District 530462002260 4324 Isom Elementary School   Regular School No Elementary KG 05 2017   grade_2 64 2 26   0 3     0   4   50 49 0   14   0   36       1.0 99 64 2 26   0 3     0   4   50 49 0   14 0 36     1 99
624244 WA Snohomish   school 5304860 31025   Marysville School District 530486000739 3187 Shoultes Elementary   Regular School No Elementary KG 05 2017   grade_3 51 2 28   0 2     1   15   50 49 0   7   3   56       1.0 99 51 2 28   0 2     1   15   50 49 0   7 3 56     1 99
624463 WA King   school 5304980 17400   Mercer Island School District 530498000765 3433 West Mercer Elementary   Regular School No Elementary KG 05 2017   grade_5 56 0 3   0 28     0   12   51 48 0   2   0   6       10.0 99 56 0 3   0 28     0   12   51 48 0   2 0 6     10 99
624468 WA Whatcom   school 5305010 37505   Meridian School District 530501000766 2584 Irene Reither Elementary School   Regular School No Elementary PK 05 2017   grade_2 68 0 22   1 4     0   4   52 47 0   14   1   53       2.0 99 68 0 22   1 4     0   4   52 47 0   14 1 53     2 99
624629 WA Grays Harbor   school 5305160 14066   Montesano School District 530516000779 3661 Beacon Avenue Elementary School   Regular School No Elementary KG 02 2017   grade_1 83 0 7   2 0     0   7   50 49 0   3   0   37       0.0 99 83 0 7   2 0     0   7   50 49 0   3 0 37     0 99
625030 WA Snohomish   school 5305430 31006   Mukilteo School District 530543000816 2886 Fairmount Elementary   Regular School No Elementary KG 05 2017   kindergarten_half_day 33 7 37   0 18     0   4   47 52 0   45   2   64       1.0 99 33 7 37   0 18     0   4   47 52 0   45 2 64     1 99
625515 WA Thurston   school 5305850 34003   North Thurston Public Schools 530585000863 4058 Evergreen Forest Elementary   Regular School No Elementary KG 05 2017   grade_4 55 6 16   4 5     1   12   42 57 0   1   5   38       3.0 99 55 6 16   4 5     1   12   42 57 0   1 5 38     3 99
625554 WA Thurston   school 5305850 34003   North Thurston Public Schools 530585002064 4255 Meadows Elementary   Regular School No Elementary PK 05 2017   grade_2 48 5 16   0 6     3   21   50 49 0   7   6   37       4.0 99 48 5 16   0 6     3   21   50 49 0   7 6 37     4 99
625724 WA King   school 5305910 17417   Northshore School District 530591000881 3105 Crystal Springs Elementary   Regular School No Elementary PK 06 2017   grade_5 54 3 18   0 16     0   8   61 38 0   13   0   27       5.0 99 54 3 18   0 16     0   8   61 38 0   13 0 27     5 99
626518 WA Adams   school 5306480 1147   Othello School District 530648000954 2961 Hiawatha Elementary School   Regular School No Elementary KG 05 2017   grade_1 9 0 90   0 0     0   0   47 52 0   76   4   94       1.0 99 9 0 90   0 0     0   0   47 52 0   76 4 94     1 99
626598 WA Franklin   school 5306570 11001   Pasco School District 530657003552 5392 Captain Gray STEM Elementary   Regular School No Elementary PK 06 2017   grade_2 4 2 92   0 0     0   1   48 51 0   69   1   95       0.0 99 4 2 92   0 0     0   1   48 51 0   69 1 95     0 99
626699 WA Franklin   school 5306570 11001   Pasco School District 530657000970 3515 Robert Frost Elementary   Regular School No Elementary PK 06 2017   grade_3 20 0 77   0 0     0   2   44 55 0   59   3   94       0.0 99 20 0 77   0 0     0   2   44 55 0   59 3 94     0 99
626710 WA Franklin   school 5306570 11001   Pasco School District 530657003499 5345 Rosalind Franklin STEM Elementary   Regular School No Elementary PK 06 2017   grade_5 43 0 50   0 4     0   2   49 50 0   17   3   57       1.0 99 43 0 50   0 4     0   2   49 50 0   17 3 57     1 99
627177 WA Pierce   school 5306960 27003   Puyallup School District 530696003192 5088 Emma L Carson Elementary   Regular School No Elementary PK 06 2017   kindergarten 54 3 11   0 10     3   18   58 41 0   10   2   32       2.0 99 54 3 11   0 10     3   18   58 41 0   10 2 32     2 99
627301 WA Pierce   school 5306960 27003   Puyallup School District 530696003442 5321 Puyallup Open Doors/POD   Alternative School No High 09 12 2017   pk_12_total 70 3 13   0 4     0   9   57 42 0   4   2   0       4.0 99 70 3 13   0 4     0   9   57 42 0   4 2 0     4 99
627357 WA Pierce   school 5306960 27003   Puyallup School District 530696002341 4360 Warren Hunt Elem   Regular School No Elementary KG 06 2017   grade_3 56 5 25   1 4     1   7   56 43 0   4   2   50       2.0 99 56 5 25   1 4     1   7   56 43 0   4 2 50     2 99
627373 WA Pierce   school 5306960 27003   Puyallup School District 530696001044 2519 Woodland Elementary   Regular School No Elementary KG 06 2017   grade_1 56 1 17   0 2     3   20   47 52 0   7   1   48       3.0 99 56 1 17   0 2     3   20   47 52 0   7 1 48     3 99
627572 WA King   school 5307230 17403   Renton School District 530723001064 3587 Benson Hill Elementary School   Regular School No Elementary KG 05 2017   grade_2 20 16 18   0 32     0   13   50 49 0   31   5   48       8.0 99 20 16 18   0 32     0   13   50 49 0   31 5 48     8 99
627654 WA King   school 5307230 17403   Renton School District 530723001075 2597 Kennydale Elementary School   Regular School No Elementary KG 05 2017   kindergarten 32 5 23   1 26     0   12   49 50 0   35   1   35       3.0 99 32 5 23   1 26     0   12   49 50 0   35 1 35     3 99
627725 WA King   school 5307230 17403   Renton School District 530723001084 3668 Sierra Heights Elementary School   Regular School No Elementary KG 05 2017   grade_1 33 7 20   1 23     0   15   52 47 0   30   2   36       7.0 99 33 7 20   1 23     0   15   52 47 0   30 2 36     7 99
627786 WA Benton   school 5307320 3400   Richland School District 530732001090 4060 Badger Mountain Elementary   Regular School No Elementary KG 05 2017   grade_2 62 2 20   0 9     0   6   52 47 0   16   7   35       0.0 99 62 2 20   0 9     0   6   52 47 0   16 7 35     0 99
628237 WA King   school 5307710 17001   Seattle School District No. 1 530771001146 2372 Bryant Elementary School   Regular School No Elementary KG 05 2017   kindergarten 69 1 7   0 8     0   14   50 49 0   9   0   4       0.0 99 69 1 7   0 8     0   14   50 49 0   9 0 4     0 99
628866 WA King   school 5307710 17001   Seattle School District No. 1 530771001263 2142 West Woodland Elementary School   Regular School No Elementary KG 05 2017   grade_4 67 2 8   0 7     0   15   49 50 0   1   0   6       1.0 99 67 2 8   0 7     0   15   49 50 0   1 0 6     1 99
629020 WA Clallam   school 5307830 5323   Sequim School District 530783002427 4378 Greywolf Elementary School   Regular School No Elementary KG 05 2017   grade_4 76 0 13   0 0     1   9   51 48 0   4   2   46       3.0 99 76 0 13   0 0     1   9   51 48 0   4 2 46     3 99
629083 WA Mason   school 5307900 23309   Shelton School District 530790001293 2745 Evergreen Elementary School   Regular School No Elementary PK 05 2017   grade_1 19 1 76   1 0     0   2   46 53 0   56   9   89       0.0 99 19 1 76   1 0     0   2   46 53 0   56 9 89     0 99
629093 WA Mason   school 5307900 23309   Shelton School District 530790001294 3292 Mountain View Elementary   Regular School No Elementary PK 05 2017   grade_3 64 0 19   4 1     0   11   48 51 0   5   5   68       0.0 99 64 0 19   4 1     0   11   48 51 0   5 5 68     0 99
629307 WA Snohomish   school 5308020 31201   Snohomish School District 530802002029 4241 Dutch Hill Elementary   Regular School No Elementary KG 06 2017   grade_4 79 0 10   1 0     1   8   60 39 0   1   3   23       8.0 99 79 0 10   1 0     1   8   60 39 0   1 3 23     8 99
629457 WA King   school 5308040 17410   Snoqualmie Valley School District 530804001332 2288 Snoqualmie Elementary   Regular School No Elementary PK 05 2017   grade_2 65 0 8   0 19     0   7   54 45 0   5   0   13       9.0 99 65 0 8   0 19     0   7   54 45 0   5 0 13     9 99
629710 WA Island   school 5308190 15206   South Whidbey School District 530819001878 4149 South Whidbey High School   Regular School No High 09 12 2017   grade_11 89 1 4   0 3     0   2   47 52 0   0   2   19       5.0 99 89 1 4   0 3     0   2   47 52 0   0 2 19     5 99
630387 WA Snohomish   school 5308550 31311   Sultan School District 530855001438 2229 Sultan Elementary School   Regular School No Elementary KG 05 2017   grade_4 67 0 20   0 2     0   10   50 49 0   7   1   60       5.0 99 67 0 20   0 2     0   10   50 49 0   7 1 60     5 99
630630 WA Pierce   school 5308700 27010   Tacoma School District 530870002742 4537 Crescent Heights   Regular School No Elementary KG 05 2017   grade_5 54 15 12   2 8     4   4   46 53 0   7   1   41       4.0 99 54 15 12   2 8     4   4   46 53 0   7 1 41     4 99
630717 WA Pierce   school 5308700 27010   Tacoma School District 530870003064 5066 Helen B. Stafford Elementary   Regular School No Elementary PK 05 2017   grade_4 19 15 20   1 24     7   13   51 48 0   22   2   78       2.0 99 19 15 20   1 24     7   13   51 48 0   22 2 78     2 99
630775 WA Pierce   school 5308700 27010   Tacoma School District 530870001481 2252 Manitou Park   Regular School No Elementary PK 05 2017   grade_1 20 15 38   2 7     3   14   40 59 0   26   6   87       0.0 99 20 15 38   2 7     3   14   40 59 0   26 6 87     0 99
631059 WA Thurston   school 5308820 34402   Tenino School District 530882001522 3509 Tenino High School   Regular School No High 09 12 2017   grade_12 86 0 7   1 1     0   4   57 42 0   1   4   42       3.0 99 86 0 7   1 1     0   4   57 42 0   1 4 42     3 99
631321 WA Thurston   school 5309100 34033   Tumwater School District 530910001543 3199 Peter G Schmidt Elementary   Regular School No Elementary KG 06 2017   grade_6 73 0 14   0 4     0   8   49 50 0   2   2   31       3.0 99 73 0 14   0 4     0   8   49 50 0   2 2 31     3 99
631532 WA Clark   school 5309270 6037   Vancouver School District 530927001565 3735 Harry S Truman Elementary School   Regular School No Elementary KG 05 2017   grade_5 55 3 26   0 6     2   7   51 48 0   12   5   59       2.0 99 55 3 26   0 6     2   7   51 48 0   12 5 59     2 99
631592 WA Clark   school 5309270 6037   Vancouver School District 530927001578 2723 Minnehaha Elementary School   Regular School No Elementary KG 05 2017   grade_3 67 3 21   0 1     3   4   59 40 0   17   2   65       1.0 99 67 3 21   0 1     3   4   59 40 0   17 2 65     1 99
631603 WA Clark   school 5309270 6037   Vancouver School District 530927001580 2644 Peter S Ogden Elementary   Regular School No Elementary KG 05 2017   grade_4 27 5 48   1 2     5   11   61 38 0   35   6   81       0.0 99 27 5 48   1 2     5   11   61 38 0   35 6 81     0 99
631607 WA Clark   school 5309270 6037   Vancouver School District 530927000638 4410 Roosevelt Elementary School   Regular School No Elementary KG 05 2017   grade_1 32 1 49   1 1     9   6   57 42 0   52   7   88       0.0 99 32 1 49   1 1     9   6   57 42 0   52 7 88     0 99
631678 WA Clark   school 5309270 6037   Vancouver School District 530927002508 1689 Vancouver School of Arts and Academics   Regular School No Other 06 12 2017   grade_8 74 1 11   2 4     1   6   32 67 0   0   0   21       8.0 99 74 1 11   2 4     1   6   32 67 0   0 0 21     8 99
631707 WA King   school 5309300 17402   Vashon Island School District 530930001394 4468 Chautauqua Elementary   Regular School No Elementary PK 05 2017   grade_4 74 1 14   0 2     0   8   49 50 0   4   0   33       7.0 99 74 1 14   0 2     0   8   49 50 0   4 0 33     7 99
632385 WA Klickitat   school 5309810 20405   White Salmon Valley School District 530981001666 3394 Wayne M Henkle Middle School   Regular School No Middle 07 08 2017   grade_7 63 0 35   0 0     0   1   57 42 0   15   2   47       4.0 99 63 0 35   0 0     0   1   57 42 0   15 2 47     4 99
632585 WA Yakima   school 5310110 39007   Yakima School District 531011001693 2818 Gilbert Elementary School   Regular School No Elementary KG 05 2017   grade_2 21 2 70   2 1     0   3   48 51 0   36   2   84       5.0 99 21 2 70   2 1     0   3   48 51 0   36 2 84     5 99
621103 WA Clark   school 5302700 6114   Evergreen School District (Clark) 530270001901 4209 Pacific Middle School   Regular School No Middle 06 08 2017   pk_12_total 625 21 170   6 60     14   88   518 466 0   67   21   417       32.0 984 625 21 170   6 60     14   88   518 466 0   67 21 417     32 984
632004 WA Clark   school 5309540 6112   Washougal School District 530954001624 3147 Washougal High School   Regular School No High 09 12 2017   pk_12_total 789 9 96   4 27     1   56   519 463 0   18   20   329       71.0 982 789 9 96   4 27     1   56   519 463 0   18 20 329     71 982
628314 WA King   school 5307710 17001   Seattle School District No. 1 530771001162 2729 Eckstein Middle School   Regular School No Middle 06 08 2017   pk_12_total 681 50 64   3 92     1   89   489 491 0   16   26   131       66.0 980 681 50 64   3 92     1   89   489 491 0   16 26 131     66 980
617233 WA Snohomish   school 5300240 31016   Arlington School District 530024001815 4154 Presidents Elementary   Regular School No Elementary PK 05 2017   grade_4 80 0 7   1 0     0   10   46 52 0   6   2   35       1.0 98 80 0 7   1 0     0   10   46 52 0   6 2 35     1 98
617276 WA King   school 5300300 17408   Auburn School District 530030000029 3825 Alpac Elementary School   Regular School No Elementary PK 05 2017   grade_3 39 3 28   0 9     3   16   44 54 0   18   2   64       3.0 98 39 3 28   0 9     3   16   44 54 0   18 2 64     3 98
617781 WA King   school 5300390 17405   Bellevue School District 530039000090 3224 Puesta del Sol Elementary School   Regular School No Elementary PK 05 2017   grade_2 46 2 23   0 13     0   14   48 50 0   8   0   8       2.0 98 46 2 23   0 13     0   14   48 50 0   8 0 8     2 98
618494 WA Clark   school 5300810 6117   Camas School District 530081003312 5158 Grass Valley Elementary   Regular School No Elementary KG 05 2017   grade_2 71 3 9   1 8     1   5   50 48 0   6   0   11       3.0 98 71 3 9   1 8     1   5   50 48 0   6 0 11     3 98
618509 WA Clark   school 5300810 6117   Camas School District 530081002083 2725 Helen Baller Elem   Regular School No Elementary KG 05 2017   grade_4 73 0 10   1 4     0   10   45 53 0   2   0   19       6.0 98 73 0 10   1 4     0   10   45 53 0   2 0 19     6 98
618655 WA Cowlitz   school 5300990 8401   Castle Rock School District 530099000172 2281 Castle Rock High School   Regular School No High 09 12 2017   grade_9 75 0 11   4 0     0   8   51 47 0   1   0   50       9.0 98 75 0 11   4 0     0   8   51 47 0   1 0 50     9 98
619449 WA Pierce   school 5301410 27400   Clover Park School District 530141003472 5365 Rainier Elementary School   Regular School No Elementary PK 05 2017   grade_4 33 14 31   1 3     1   15   49 49 0   1   0   57       0.0 98 33 14 31   1 3     1   15   49 49 0   1 0 57     0 98
620623 WA Grant   school 5302610 13165   Ephrata School District 530261000388 3092 Grant Elementary   Regular School No Elementary KG 04 2017   grade_4 70 1 24   0 1     0   2   50 48 0   8   0   54       6.0 98 70 1 24   0 1     0   2   50 48 0   8 0 54     6 98
620790 WA Snohomish   school 5302670 31002   Everett School District 530267000402 3533 Jefferson Elementary   Regular School No Elementary KG 05 2017   grade_5 53 5 18   0 16     1   5   44 54 0   10   4   40       5.0 98 53 5 18   0 16     1   5   44 54 0   10 4 40     5 98
621303 WA King   school 5302820 17210   Federal Way School District 530282001835 3627 Mark Twain Elementary School   Regular School No Elementary PK 05 2017   grade_4 9 22 38   0 11     7   11   43 55 0   28   3   93       2.0 98 9 22 38   0 11     7   11   43 55 0   28 3 93     2 98
621809 WA Yakima   school 5303150 39200   Grandview School District 530315000500 2756 Thompson Elementary School   Regular School No Elementary PK 05 2017   kindergarten 11 0 87   0 0     0   0   49 49 0   45   3   82       0.0 98 11 0 87   0 0     0   0   49 49 0   45 3 82     0 98
621917 WA Yakima   school 5303510 39203   Highland School District 530351002876 4559 Highland High School   Regular School No High 09 12 2017   grade_10 25 0 69   2 0     0   2   52 46 0   9   3   78       3.0 98 25 0 69   2 0     0   2   52 46 0   9 3 78     3 98
622129 WA King   school 5303540 17401   Highline School District 530354002974 3553 Raisbeck Aviation High School   Alternative School No High 09 12 2017   grade_12 52 7 11   0 20     1   7   64 34 0   0   1   14       8.0 98 52 7 11   0 20     1   7   64 34 0   0 1 14     8 98

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