Data source: Big Local News · About: Big Local

15,758 rows where state = "WA" and year = 2017 sorted by school_state_id 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
625628 WA Thurston   school   34003   North Thurston Public Schools   8407 Wa He Lut Indian School(Closed)             2017   grade_1 0 0 1   9 0     0   0   7 3 0   0   0   7       0.0 10 0 0 1   9 0     0   0   7 3 0   0 0 7     0 10
625629 WA Thurston   school   34003   North Thurston Public Schools   8407 Wa He Lut Indian School(Closed)             2017   grade_2 0 0 0   13 0     0   0   7 6 0   0   0   8       0.0 13 0 0 0   13 0     0   0   7 6 0   0 0 8     0 13
625630 WA Thurston   school   34003   North Thurston Public Schools   8407 Wa He Lut Indian School(Closed)             2017   grade_3 0 0 0   10 0     0   1   8 3 0   0   0   4       0.0 11 0 0 0   10 0     0   1   8 3 0   0 0 4     0 11
625631 WA Thurston   school   34003   North Thurston Public Schools   8407 Wa He Lut Indian School(Closed)             2017   grade_4 0 0 0   7 0     0   1   3 5 0   0   0   3       0.0 8 0 0 0   7 0     0   1   3 5 0   0 0 3     0 8
625632 WA Thurston   school   34003   North Thurston Public Schools   8407 Wa He Lut Indian School(Closed)             2017   grade_5 0 0 1   10 0     0   0   5 6 0   0   0   4       0.0 11 0 0 1   10 0     0   0   5 6 0   0 0 4     0 11
625633 WA Thurston   school   34003   North Thurston Public Schools   8407 Wa He Lut Indian School(Closed)             2017   grade_6 0 0 0   4 0     0   2   3 3 0   0   0   4       0.0 6 0 0 0   4 0     0   2   3 3 0   0 0 4     0 6
625634 WA Thurston   school   34003   North Thurston Public Schools   8407 Wa He Lut Indian School(Closed)             2017   grade_7 0 0 1   14 0     0   0   8 7 0   0   0   12       0.0 15 0 0 1   14 0     0   0   8 7 0   0 0 12     0 15
625635 WA Thurston   school   34003   North Thurston Public Schools   8407 Wa He Lut Indian School(Closed)             2017   grade_8 0 0 0   9 0     0   0   6 3 0   0   0   4       0.0 9 0 0 0   9 0     0   0   6 3 0   0 0 4     0 9
625636 WA Thurston   school   34003   North Thurston Public Schools   8407 Wa He Lut Indian School(Closed)             2017   pk_12_total 0 0 3   86 0     0   4   52 41 0   0   0   50       0.0 93 0 0 3   86 0     0   4   52 41 0   0 0 50     0 93
625637 WA Thurston   school   34003   North Thurston Public Schools   8407 Wa He Lut Indian School(Closed)             2017   kindergarten_half_day 0 0 0   10 0     0   0   5 5 0   0   0   4       0.0 10 0 0 0   10 0     0   0   5 5 0   0 0 4     0 10
618162 WA Pierce   school 5300480 27403   Bethel School District 530048003284 5961 Pierce County Skills Center   Career and Technical School No High 07 12 2017   grade_11 18 1 6   0 0     1   3   19 10 0   0   0   4       0.0 29 18 1 6   0 0     1   3   19 10 0   0 0 4     0 29
618163 WA Pierce   school 5300480 27403   Bethel School District 530048003284 5961 Pierce County Skills Center   Career and Technical School No High 07 12 2017   grade_12 102 2 18   1 1     0   8   85 47 0   0   0   16       0.0 132 102 2 18   1 1     0   8   85 47 0   0 0 16     0 132
618164 WA Pierce   school 5300480 27403   Bethel School District 530048003284 5961 Pierce County Skills Center   Career and Technical School No High 07 12 2017   pk_12_total 120 3 24   1 1     1   11   104 57 0   0   0   20       0.0 161 120 3 24   1 1     1   11   104 57 0   0 0 20     0 161
624941 WA Skagit   school 5305400 29320   Mount Vernon School District 530540003297 5960 Northwest Career & Technical Academy/A WA Skills Center   Career and Technical School No High 09 12 2017   grade_10 8 0 2   1 0     0   0   4 7 0   0   0   0       0.0 11 8 0 2   1 0     0   0   4 7 0   0 0 0     0 11
624942 WA Skagit   school 5305400 29320   Mount Vernon School District 530540003297 5960 Northwest Career & Technical Academy/A WA Skills Center   Career and Technical School No High 09 12 2017   grade_11 35 1 9   3 1     1   0   29 21 0   0   0   10       0.0 50 35 1 9   3 1     1   0   29 21 0   0 0 10     0 50
624943 WA Skagit   school 5305400 29320   Mount Vernon School District 530540003297 5960 Northwest Career & Technical Academy/A WA Skills Center   Career and Technical School No High 09 12 2017   grade_12 142 1 36   5 2     0   1   103 84 0   0   0   53       0.0 187 142 1 36   5 2     0   1   103 84 0   0 0 53     0 187
624944 WA Skagit   school 5305400 29320   Mount Vernon School District 530540003297 5960 Northwest Career & Technical Academy/A WA Skills Center   Career and Technical School No High 09 12 2017   grade_8 43 1 5   0 0     0   1   33 17 0   0   0   11       0.0 50 43 1 5   0 0     0   1   33 17 0   0 0 11     0 50
624945 WA Skagit   school 5305400 29320   Mount Vernon School District 530540003297 5960 Northwest Career & Technical Academy/A WA Skills Center   Career and Technical School No High 09 12 2017   pk_12_total 228 3 52   9 3     1   2   169 129 0   0   0   74       0.0 298 228 3 52   9 3     1   2   169 129 0   0 0 74     0 298
623681 WA King   school 5304230 17414   Lake Washington School District 530423003289 5958 Washington Network for Innovative Careers Skill Center   Career and Technical School No High 09 12 2017   grade_10 6 1 0   0 18     0   2   22 5 0   0   0   0       0.0 27 6 1 0   0 18     0   2   22 5 0   0 0 0     0 27
623682 WA King   school 5304230 17414   Lake Washington School District 530423003289 5958 Washington Network for Innovative Careers Skill Center   Career and Technical School No High 09 12 2017   grade_11 54 0 4   0 36     0   7   71 30 0   2   0   1       0.0 101 54 0 4   0 36     0   7   71 30 0   2 0 1     0 101
623683 WA King   school 5304230 17414   Lake Washington School District 530423003289 5958 Washington Network for Innovative Careers Skill Center   Career and Technical School No High 09 12 2017   grade_12 148 2 21   0 50     0   14   129 106 0   7   0   8       0.0 235 148 2 21   0 50     0   14   129 106 0   7 0 8     0 235
623684 WA King   school 5304230 17414   Lake Washington School District 530423003289 5958 Washington Network for Innovative Careers Skill Center   Career and Technical School No High 09 12 2017   pk_12_total 208 3 25   0 104     0   23   222 141 0   9   0   9       0.0 363 208 3 25   0 104     0   23   222 141 0   9 0 9     0 363
623326 WA King   school 5300313 17937   Lake Washington Institute of Technology 530031303265 5953 Lake Washington Technical Academy   Regular School No High 11 12 2017   grade_11 24 1 6   0 2     0   4   18 20 0   0   0   0       0.0 38 24 1 6   0 2     0   4   18 20 0   0 0 0     0 38
623327 WA King   school 5300313 17937   Lake Washington Institute of Technology 530031303265 5953 Lake Washington Technical Academy   Regular School No High 11 12 2017   grade_12 214 9 41   1 15     1   18   183 118 0   0   1   0       0.0 301 214 9 41   1 15     1   18   183 118 0   0 1 0     0 301
623328 WA King   school 5300313 17937   Lake Washington Institute of Technology 530031303265 5953 Lake Washington Technical Academy   Regular School No High 11 12 2017   pk_12_total 238 10 47   1 17     1   22   201 138 0   0   1   0       0.0 339 238 10 47   1 17     1   22   201 138 0   0 1 0     0 339
619495 WA Pierce   school 5300017 27932   Clover Park Technical College 530001703209 5951 Northwest Career and Technical High School   Career and Technical School No High 09 12 2017   grade_11 21 2 11   0 1     2   3   17 23 0   0   0   0       0.0 40 21 2 11   0 1     2   3   17 23 0   0 0 0     0 40
619496 WA Pierce   school 5300017 27932   Clover Park Technical College 530001703209 5951 Northwest Career and Technical High School   Career and Technical School No High 09 12 2017   grade_12 80 25 38   1 3     6   26   85 94 0   0   0   0       0.0 179 80 25 38   1 3     6   26   85 94 0   0 0 0     0 179
619497 WA Pierce   school 5300017 27932   Clover Park Technical College 530001703209 5951 Northwest Career and Technical High School   Career and Technical School No High 09 12 2017   pk_12_total 101 27 49   1 4     8   29   102 117 0   0   0   0       0.0 219 101 27 49   1 4     8   29   102 117 0   0 0 0     0 219
618022 WA Pierce   school   27403   Bethel School District   5471 Bethel Elementary Learning Academy             2017   grade_1 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
618023 WA Pierce   school   27403   Bethel School District   5471 Bethel Elementary Learning Academy             2017   grade_2 1 0 0   0 0     0   0   0 1 0   0   0   0       0.0 1 1 0 0   0 0     0   0   0 1 0   0 0 0     0 1
618024 WA Pierce   school   27403   Bethel School District   5471 Bethel Elementary Learning Academy             2017   grade_3 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
618025 WA Pierce   school   27403   Bethel School District   5471 Bethel Elementary Learning Academy             2017   grade_4 3 1 1   0 0     0   1   1 5 0   0   0   1       0.0 6 3 1 1   0 0     0   1   1 5 0   0 0 1     0 6
618026 WA Pierce   school   27403   Bethel School District   5471 Bethel Elementary Learning Academy             2017   grade_5 2 0 0   0 0     0   1   2 1 0   0   0   0       0.0 3 2 0 0   0 0     0   1   2 1 0   0 0 0     0 3
618027 WA Pierce   school   27403   Bethel School District   5471 Bethel Elementary Learning Academy             2017   pk_12_total 10 1 2   0 0     0   2   7 8 0   0   0   2       0.0 15 10 1 2   0 0     0   2   7 8 0   0 0 2     0 15
618028 WA Pierce   school   27403   Bethel School District   5471 Bethel Elementary Learning Academy             2017   kindergarten 2 0 0   0 0     0   0   2 0 0   0   0   0       0.0 2 2 0 0   0 0     0   0   2 0 0   0 0 0     0 2
621512 WA Whatcom   school 5302850 37502   Ferndale School District 530285003576 5464 FERNDALE RE-ENGAGEMENT   Alternative School No High 09 12 2017   grade_10 3 0 0   0 0     0   0   1 2 0   0   0   2       0.0 3 3 0 0   0 0     0   0   1 2 0   0 0 2     0 3
621513 WA Whatcom   school 5302850 37502   Ferndale School District 530285003576 5464 FERNDALE RE-ENGAGEMENT   Alternative School No High 09 12 2017   grade_11 5 0 2   3 1     0   0   4 7 0   0   0   6       1.0 11 5 0 2   3 1     0   0   4 7 0   0 0 6     1 11
621514 WA Whatcom   school 5302850 37502   Ferndale School District 530285003576 5464 FERNDALE RE-ENGAGEMENT   Alternative School No High 09 12 2017   grade_12 17 0 4   7 1     0   1   18 12 0   0   1   10       0.0 30 17 0 4   7 1     0   1   18 12 0   0 1 10     0 30
621515 WA Whatcom   school 5302850 37502   Ferndale School District 530285003576 5464 FERNDALE RE-ENGAGEMENT   Alternative School No High 09 12 2017   pk_12_total 25 0 6   10 2     0   1   23 21 0   0   1   18       1.0 44 25 0 6   10 2     0   1   23 21 0   0 1 18     1 44
618986 WA Lewis   school 5301140 21401   Centralia School District 530114003580 5463 Centralia School District SpEd Pre-school   Regular School No Elementary PK PK 2017   pk_12_total 53 0 20   2 2     0   0   52 26 0   0   1   44       0.0 78 53 0 20   2 2     0   0   52 26 0   0 1 44     0 78
618987 WA Lewis   school 5301140 21401   Centralia School District 530114003580 5463 Centralia School District SpEd Pre-school   Regular School No Elementary PK PK 2017   kindergarten_half_day 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
618988 WA Lewis   school 5301140 21401   Centralia School District 530114003580 5463 Centralia School District SpEd Pre-school   Regular School No Elementary PK PK 2017   pre_kindergarten 52 0 20   2 2     0   0   51 26 0   0   1   44       0.0 77 52 0 20   2 2     0   0   51 26 0   0 1 44     0 77
632225 WA Spokane   school 5309690 32363   West Valley School District (Spokane) 530969003570 5462 West Valley Early Learning Center   Regular School No Elementary PK PK 2017   pk_12_total 102 1 14   2 0     0   16   76 59 0   0   0   91       1.0 135 102 1 14   2 0     0   16   76 59 0   0 0 91     1 135
632226 WA Spokane   school 5309690 32363   West Valley School District (Spokane) 530969003570 5462 West Valley Early Learning Center   Regular School No Elementary PK PK 2017   pre_kindergarten 102 1 14   2 0     0   16   76 59 0   0   0   91       1.0 135 102 1 14   2 0     0   16   76 59 0   0 0 91     1 135
631889 WA Walla Walla   school 5309450 36140   Walla Walla Public Schools 530945003590 5460 Walla Walla Open Doors   Alternative School No High 11 12 2017   grade_11 9 0 16   1 1     0   0   16 11 0   2   0   21       0.0 27 9 0 16   1 1     0   0   16 11 0   2 0 21     0 27
631890 WA Walla Walla   school 5309450 36140   Walla Walla Public Schools 530945003590 5460 Walla Walla Open Doors   Alternative School No High 11 12 2017   grade_12 16 0 21   1 0     0   1   16 23 0   0   1   19       0.0 39 16 0 21   1 0     0   1   16 23 0   0 1 19     0 39
631891 WA Walla Walla   school 5309450 36140   Walla Walla Public Schools 530945003590 5460 Walla Walla Open Doors   Alternative School No High 11 12 2017   pk_12_total 25 0 37   2 1     0   1   32 34 0   2   1   40       0.0 66 25 0 37   2 1     0   1   32 34 0   2 1 40     0 66
630722 WA Pierce   school 5308700 27010   Tacoma School District 530870003575 5458 Industrial Design Engineering and Art   Regular School No Other 09 09 2017   grade_9 71 19 15   1 14     2   2   92 32 0   4   1   53       8.0 124 71 19 15   1 14     2   2   92 32 0   4 1 53     8 124
630723 WA Pierce   school 5308700 27010   Tacoma School District 530870003575 5458 Industrial Design Engineering and Art   Regular School No Other 09 09 2017   pk_12_total 71 19 15   1 14     2   2   92 32 0   4   1   53       8.0 124 71 19 15   1 14     2   2   92 32 0   4 1 53     8 124
629480 WA King   school 5308040 17410   Snoqualmie Valley School District 530804003560 5457 Timber Ridge Elementary School   Regular School No Elementary KG 05 2017   grade_1 86 1 8   0 15     0   14   63 61 0   7   0   4       3.0 124 86 1 8   0 15     0   14   63 61 0   7 0 4     3 124
629481 WA King   school 5308040 17410   Snoqualmie Valley School District 530804003560 5457 Timber Ridge Elementary School   Regular School No Elementary KG 05 2017   grade_2 72 0 7   0 15     1   6   51 50 0   9   0   2       1.0 101 72 0 7   0 15     1   6   51 50 0   9 0 2     1 101
629482 WA King   school 5308040 17410   Snoqualmie Valley School District 530804003560 5457 Timber Ridge Elementary School   Regular School No Elementary KG 05 2017   grade_3 64 0 7   0 9     0   9   40 49 0   2   0   1       3.0 89 64 0 7   0 9     0   9   40 49 0   2 0 1     3 89
629483 WA King   school 5308040 17410   Snoqualmie Valley School District 530804003560 5457 Timber Ridge Elementary School   Regular School No Elementary KG 05 2017   grade_4 69 0 4   0 20     0   8   57 44 0   3   0   2       5.0 101 69 0 4   0 20     0   8   57 44 0   3 0 2     5 101
629484 WA King   school 5308040 17410   Snoqualmie Valley School District 530804003560 5457 Timber Ridge Elementary School   Regular School No Elementary KG 05 2017   grade_5 51 0 5   0 6     0   4   29 37 0   1   0   0       5.0 66 51 0 5   0 6     0   4   29 37 0   1 0 0     5 66
629485 WA King   school 5308040 17410   Snoqualmie Valley School District 530804003560 5457 Timber Ridge Elementary School   Regular School No Elementary KG 05 2017   pk_12_total 420 1 40   0 80     1   56   300 298 0   31   0   11       18.0 598 420 1 40   0 80     1   56   300 298 0   31 0 11     18 598
629486 WA King   school 5308040 17410   Snoqualmie Valley School District 530804003560 5457 Timber Ridge Elementary School   Regular School No Elementary KG 05 2017   kindergarten 78 0 9   0 15     0   15   60 57 0   9   0   2       1.0 117 78 0 9   0 15     0   15   60 57 0   9 0 2     1 117
626056 WA Pacific   school 5306060 25101   Ocean Beach School District 530606003565 5454 Ocean Beach Alternative School (Closed after 2019-2020 school year)   Alternative School No Other 06 12 2017   grade_10 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
626057 WA Pacific   school 5306060 25101   Ocean Beach School District 530606003565 5454 Ocean Beach Alternative School (Closed after 2019-2020 school year)   Alternative School No Other 06 12 2017   grade_11 4 0 0   1 0     0   0   0 5 0   0   2   4       1.0 5 4 0 0   1 0     0   0   0 5 0   0 2 4     1 5
626058 WA Pacific   school 5306060 25101   Ocean Beach School District 530606003565 5454 Ocean Beach Alternative School (Closed after 2019-2020 school year)   Alternative School No Other 06 12 2017   grade_12 3 0 0   0 0     0   0   2 1 0   0   2   3       0.0 3 3 0 0   0 0     0   0   2 1 0   0 2 3     0 3
626059 WA Pacific   school 5306060 25101   Ocean Beach School District 530606003565 5454 Ocean Beach Alternative School (Closed after 2019-2020 school year)   Alternative School No Other 06 12 2017   grade_8 1 0 0   0 0     0   0   1 0 0   0   0   1       1.0 1 1 0 0   0 0     0   0   1 0 0   0 0 1     1 1
626060 WA Pacific   school 5306060 25101   Ocean Beach School District 530606003565 5454 Ocean Beach Alternative School (Closed after 2019-2020 school year)   Alternative School No Other 06 12 2017   grade_9 1 0 0   0 0     0   0   0 1 0   0   0   1       0.0 1 1 0 0   0 0     0   0   0 1 0   0 0 1     0 1
626061 WA Pacific   school 5306060 25101   Ocean Beach School District 530606003565 5454 Ocean Beach Alternative School (Closed after 2019-2020 school year)   Alternative School No Other 06 12 2017   pk_12_total 10 0 0   1 0     0   0   4 7 0   0   4   9       2.0 11 10 0 0   1 0     0   0   4 7 0   0 4 9     2 11
625846 WA King   school 5305910 17417   Northshore School District 530591003573 5453 Northshore Primary Center (Closed after 2016-2017 school year)   Regular School No Elementary KG KG 2017   pk_12_total 71 1 10   0 46     0   6   68 66 0   31   1   0       4.0 134 71 1 10   0 46     0   6   68 66 0   31 1 0     4 134
625847 WA King   school 5305910 17417   Northshore School District 530591003573 5453 Northshore Primary Center (Closed after 2016-2017 school year)   Regular School No Elementary KG KG 2017   kindergarten_half_day 69 1 10   0 46     0   6   66 66 0   31   1   0       4.0 132 69 1 10   0 46     0   6   66 66 0   31 1 0     4 132
625848 WA King   school 5305910 17417   Northshore School District 530591003573 5453 Northshore Primary Center (Closed after 2016-2017 school year)   Regular School No Elementary KG KG 2017   kindergarten 2 0 0   0 0     0   0   2 0 0   0   0   0       0.0 2 2 0 0   0 0     0   0   2 0 0   0 0 0     0 2
625597 WA Thurston   school 5305850 34003   North Thurston Public Schools 530585003587 5452 Salish Middle School   Regular School No Middle 06 08 2017   grade_6 114 5 62   6 22     3   32   125 119 0   9   11   106       12.0 244 114 5 62   6 22     3   32   125 119 0   9 11 106     12 244
625598 WA Thurston   school 5305850 34003   North Thurston Public Schools 530585003587 5452 Salish Middle School   Regular School No Middle 06 08 2017   grade_7 115 14 31   5 17     5   38   122 103 0   5   14   111       20.0 225 115 14 31   5 17     5   38   122 103 0   5 14 111     20 225
625599 WA Thurston   school 5305850 34003   North Thurston Public Schools 530585003587 5452 Salish Middle School   Regular School No Middle 06 08 2017   grade_8 97 12 38   5 12     3   41   121 87 0   4   9   96       12.0 208 97 12 38   5 12     3   41   121 87 0   4 9 96     12 208
625600 WA Thurston   school 5305850 34003   North Thurston Public Schools 530585003587 5452 Salish Middle School   Regular School No Middle 06 08 2017   pk_12_total 326 31 131   16 51     11   111   368 309 0   18   34   313       44.0 677 326 31 131   16 51     11   111   368 309 0   18 34 313     44 677
625123 WA Yakima   school 5305460 39003   Naches Valley School District 530546003559 5451 Naches Valley Elementary School   Regular School No Elementary KG 04 2017   grade_1 44 0 22   0 0     0   1   29 38 0   8   4   43       0.0 67 44 0 22   0 0     0   1   29 38 0   8 4 43     0 67
625124 WA Yakima   school 5305460 39003   Naches Valley School District 530546003559 5451 Naches Valley Elementary School   Regular School No Elementary KG 04 2017   grade_2 32 2 10   0 0     0   2   26 20 0   4   2   20       0.0 46 32 2 10   0 0     0   2   26 20 0   4 2 20     0 46
625125 WA Yakima   school 5305460 39003   Naches Valley School District 530546003559 5451 Naches Valley Elementary School   Regular School No Elementary KG 04 2017   grade_3 61 1 24   0 0     0   2   47 41 0   12   4   53       1.0 88 61 1 24   0 0     0   2   47 41 0   12 4 53     1 88
625126 WA Yakima   school 5305460 39003   Naches Valley School District 530546003559 5451 Naches Valley Elementary School   Regular School No Elementary KG 04 2017   grade_4 71 1 19   0 0     0   4   52 43 0   6   3   50       2.0 95 71 1 19   0 0     0   4   52 43 0   6 3 50     2 95
625127 WA Yakima   school 5305460 39003   Naches Valley School District 530546003559 5451 Naches Valley Elementary School   Regular School No Elementary KG 04 2017   pk_12_total 279 5 94   2 0     0   10   211 179 0   35   18   215       4.0 390 279 5 94   2 0     0   10   211 179 0   35 18 215     4 390
625128 WA Yakima   school 5305460 39003   Naches Valley School District 530546003559 5451 Naches Valley Elementary School   Regular School No Elementary KG 04 2017   kindergarten 60 1 15   1 0     0   1   44 34 0   4   3   37       1.0 78 60 1 15   1 0     0   1   44 34 0   4 3 37     1 78
625129 WA Yakima   school 5305460 39003   Naches Valley School District 530546003559 5451 Naches Valley Elementary School   Regular School No Elementary KG 04 2017   pre_kindergarten 11 0 4   1 0     0   0   13 3 0   1   2   12       0.0 16 11 0 4   1 0     0   0   13 3 0   1 2 12     0 16
625049 WA Snohomish   school 5305430 31006   Mukilteo School District 530543003577 5450 Lake Stickney Elementary School   Regular School No Elementary KG 05 2017   grade_1 46 12 21   0 20     0   9   43 65 0   48   1   51       1.0 108 46 12 21   0 20     0   9   43 65 0   48 1 51     1 108
625050 WA Snohomish   school 5305430 31006   Mukilteo School District 530543003577 5450 Lake Stickney Elementary School   Regular School No Elementary KG 05 2017   grade_2 44 16 25   0 32     1   13   77 54 0   48   1   66       7.0 131 44 16 25   0 32     1   13   77 54 0   48 1 66     7 131
625051 WA Snohomish   school 5305430 31006   Mukilteo School District 530543003577 5450 Lake Stickney Elementary School   Regular School No Elementary KG 05 2017   grade_3 36 11 27   0 19     0   17   60 50 0   27   2   65       4.0 110 36 11 27   0 19     0   17   60 50 0   27 2 65     4 110
625052 WA Snohomish   school 5305430 31006   Mukilteo School District 530543003577 5450 Lake Stickney Elementary School   Regular School No Elementary KG 05 2017   grade_4 36 18 32   0 25     0   6   63 54 0   29   1   73       4.0 117 36 18 32   0 25     0   6   63 54 0   29 1 73     4 117
625053 WA Snohomish   school 5305430 31006   Mukilteo School District 530543003577 5450 Lake Stickney Elementary School   Regular School No Elementary KG 05 2017   grade_5 29 6 22   0 18     0   11   46 40 0   17   0   48       4.0 86 29 6 22   0 18     0   11   46 40 0   17 0 48     4 86
625054 WA Snohomish   school 5305430 31006   Mukilteo School District 530543003577 5450 Lake Stickney Elementary School   Regular School No Elementary KG 05 2017   pk_12_total 235 79 153   1 132     1   66   355 312 0   212   8   362       21.0 667 235 79 153   1 132     1   66   355 312 0   212 8 362     21 667
625055 WA Snohomish   school 5305430 31006   Mukilteo School District 530543003577 5450 Lake Stickney Elementary School   Regular School No Elementary KG 05 2017   kindergarten_half_day 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
625056 WA Snohomish   school 5305430 31006   Mukilteo School District 530543003577 5450 Lake Stickney Elementary School   Regular School No Elementary KG 05 2017   kindergarten 44 16 26   1 17     0   9   64 49 0   42   3   59       1.0 113 44 16 26   1 17     0   9   64 49 0   42 3 59     1 113
625057 WA Snohomish   school 5305430 31006   Mukilteo School District 530543003577 5450 Lake Stickney Elementary School   Regular School No Elementary KG 05 2017   pre_kindergarten 0 0 0   0 1     0   0   1 0 0   1   0   0       0.0 1 0 0 0   0 1     0   0   1 0 0   1 0 0     0 1
624926 WA Skagit   school 5305400 29320   Mount Vernon School District 530540003579 5449 Mount Vernon Open Doors   Alternative School No High 10 12 2017   grade_11 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
624927 WA Skagit   school 5305400 29320   Mount Vernon School District 530540003579 5449 Mount Vernon Open Doors   Alternative School No High 10 12 2017   grade_12 2 0 14   2 0     1   3   8 14 0   0   0   18       0.0 22 2 0 14   2 0     1   3   8 14 0   0 0 18     0 22
624928 WA Skagit   school 5305400 29320   Mount Vernon School District 530540003579 5449 Mount Vernon Open Doors   Alternative School No High 10 12 2017   pk_12_total 3 0 14   2 0     1   3   9 14 0   0   0   19       0.0 23 3 0 14   2 0     1   3   9 14 0   0 0 19     0 23
624481 WA Whatcom   school 5305010 37505   Meridian School District 530501003563 5448 Meridian Impact Re-Engagement   Alternative School No High 09 12 2017   grade_11 3 0 1   0 0     0   1   1 4 0   0   0   2       0.0 5 3 0 1   0 0     0   1   1 4 0   0 0 2     0 5
624482 WA Whatcom   school 5305010 37505   Meridian School District 530501003563 5448 Meridian Impact Re-Engagement   Alternative School No High 09 12 2017   grade_12 4 0 2   0 0     0   1   3 4 0   0   0   2       0.0 7 4 0 2   0 0     0   1   3 4 0   0 0 2     0 7
624483 WA Whatcom   school 5305010 37505   Meridian School District 530501003563 5448 Meridian Impact Re-Engagement   Alternative School No High 09 12 2017   pk_12_total 7 0 3   0 0     0   2   4 8 0   0   0   4       0.0 12 7 0 3   0 0     0   2   4 8 0   0 0 4     0 12
624450 WA King   school 5304980 17400   Mercer Island School District 530498003566 5447 Northwood Elementary School   Regular School No Elementary KG 05 2017   grade_1 32 1 3   0 14     0   3   32 21 0   9   0   3       4.0 53 32 1 3   0 14     0   3   32 21 0   9 0 3     4 53
624451 WA King   school 5304980 17400   Mercer Island School District 530498003566 5447 Northwood Elementary School   Regular School No Elementary KG 05 2017   grade_2 50 1 5   0 16     0   14   46 40 0   7   4   6       14.0 86 50 1 5   0 16     0   14   46 40 0   7 4 6     14 86
624452 WA King   school 5304980 17400   Mercer Island School District 530498003566 5447 Northwood Elementary School   Regular School No Elementary KG 05 2017   grade_3 48 2 2   0 20     0   6   39 39 0   7   0   3       8.0 78 48 2 2   0 20     0   6   39 39 0   7 0 3     8 78
624453 WA King   school 5304980 17400   Mercer Island School District 530498003566 5447 Northwood Elementary School   Regular School No Elementary KG 05 2017   grade_4 48 0 6   0 17     0   8   40 39 0   7   2   6       9.0 79 48 0 6   0 17     0   8   40 39 0   7 2 6     9 79
624454 WA King   school 5304980 17400   Mercer Island School District 530498003566 5447 Northwood Elementary School   Regular School No Elementary KG 05 2017   grade_5 46 1 3   0 17     0   8   40 35 0   4   0   7       9.0 75 46 1 3   0 17     0   8   40 35 0   4 0 7     9 75
624455 WA King   school 5304980 17400   Mercer Island School District 530498003566 5447 Northwood Elementary School   Regular School No Elementary KG 05 2017   pk_12_total 290 6 27   0 114     0   50   258 229 0   47   7   29       49.0 487 290 6 27   0 114     0   50   258 229 0   47 7 29     49 487
624456 WA King   school 5304980 17400   Mercer Island School District 530498003566 5447 Northwood Elementary School   Regular School No Elementary KG 05 2017   kindergarten_half_day 7 0 1   0 0     0   3   6 5 0   2   0   0       1.0 11 7 0 1   0 0     0   3   6 5 0   2 0 0     1 11
624457 WA King   school 5304980 17400   Mercer Island School District 530498003566 5447 Northwood Elementary School   Regular School No Elementary KG 05 2017   kindergarten 30 0 6   0 20     0   5   33 28 0   11   1   1       4.0 61 30 0 6   0 20     0   5   33 28 0   11 1 1     4 61
624458 WA King   school 5304980 17400   Mercer Island School District 530498003566 5447 Northwood Elementary School   Regular School No Elementary KG 05 2017   pre_kindergarten 29 1 1   0 10     0   3   22 22 0   0   0   3       0.0 44 29 1 1   0 10     0   3   22 22 0   0 0 3     0 44

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