Data source: Big Local News · About: Big Local

8,808 rows where grade = "grade_2" and state = "WA" sorted by white_int descending

View and edit SQL

year

grade

  • grade_2 · 8,808
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
2940375 WA Okanogan   school 5306220 24019   Omak School District 530622003282 5195 Washington Virtual Academy Omak Elementary   Regular School No Elementary KG 05 2021   grade_2 391 20 22   2 9     4   9   229 227 1   13   1   176       3.0 457 391 20 22   2 9     4   9   229 227 1   13 1 176     3 457
2424687 WA Yakima   school 5307770 39119   Selah School District 530777003513 5383 John Campbell Primary School   Regular School No Elementary KG 02 2019   grade_2 212 2 81   1 0     0   12   165 143 0   38   2   169       2.0 308 212 2 81   1 0     0   12   165 143 0   38 2 169     2 308
2469202 WA Yakima   school 5307770 39119   Selah School District 530777003513 5383 John Campbell Primary School   Regular School No Elementary KG 02 2018   grade_2 194 1 78   1 0     1   7   150 132 0   47   0   165       0.0 282 194 1 78   1 0     1   7   150 132 0   47 0 165     0 282
531617 WA Yakima   school 5307770 39119   Selah School District 530777003513 5383 John Campbell Primary School   Regular School No 1 KG 02 2016   grade_2 186 0 80   3 1     0   3   137 136 0   38   2   169       1.0 273 186 0 80   3 1     0   3   137 136 0   38 2 169     1 273
2582082 WA Yakima   school 5307770 39119   Selah School District 530777003513 5383 John Campbell Primary School   Regular School No Elementary KG 02 2020   grade_2 178 1 86   1 0     0   7   156 117 0   42   4   152       4.0 273 178 1 86   1 0     0   7   156 117 0   42 4 152     4 273
628965 WA Yakima   school 5307770 39119   Selah School District 530777003513 5383 John Campbell Primary School   Regular School No Elementary KG 02 2017   grade_2 171 2 82   2 1     0   14   131 141 0   37   0   158       0.0 272 171 2 82   2 1     0   14   131 141 0   37 0 158     0 272
2572327 WA Lewis   school 5301170 21302   Chehalis School District 530117003654 5509 James W Lintott Elementary School   Regular School No Elementary PK 02 2020   grade_2 167 3 42   2 1     0   10   112 113 0   8   4   121       0.0 225 167 3 42   2 1     0   10   112 113 0   8 4 121     0 225
460292 WA Clark   school 5300380 6119   Battle Ground School District 530038000056 2910 Yacolt Primary   Regular School No 1.0 KG 04 2015   grade_2 165 0 6   0 0     0   5   95 81 0   1   6   85       1.0 176 165 0 6   0 0     0   5   95 81 0   1 6 85     1 176
469025 WA Okanogan   school 5306220 24019   Omak School District 530622003282 5195 Washington Virtual Academy Omak Elementary   Regular School No 1.0 KG 05 2015   grade_2 165 8 14   5 15     4   10   97 124 0   4   0   68       4.0 221 165 8 14   5 15     4   10   97 124 0   4 0 68     4 221
2459351 WA Spokane   school 5301110 32356   Central Valley School District 530111003596 5507 Liberty Creek Elementary School   Regular School No Elementary KG 03 2018   grade_2 163 2 16   1 3     0   7   93 99 0   7   0   55       4.0 192 163 2 16   1 3     0   7   93 99 0   7 0 55     4 192
520272 WA Clark   school 5300380 6119   Battle Ground School District 530038000056 2910 Yacolt Primary   Regular School No 1 PK 04 2016   grade_2 162 0 3   0 0     0   6   91 80 0   1   3   85       2.0 171 162 0 3   0 0     0   6   91 80 0   1 3 85     2 171
2572140 WA Spokane   school 5301110 32356   Central Valley School District 530111003596 5507 Liberty Creek Elementary School   Regular School No Elementary KG 03 2020   grade_2 162 3 2   2 0     0   5   80 94 0   5   1   36       1.0 174 162 3 2   2 0     0   5   80 94 0   5 1 36     1 174
528915 WA Okanogan   school 5306220 24019   Omak School District 530622003282 5195 Washington Virtual Academy Omak Elementary   Regular School No 1 KG 05 2016   grade_2 161 25 13   4 13     6   1   108 115 0   4   0   95       5.0 223 161 25 13   4 13     6   1   108 115 0   4 0 95     5 223
2414805 WA Spokane   school 5301110 32356   Central Valley School District 530111003596 5507 Liberty Creek Elementary School   Regular School No Elementary KG 03 2019   grade_2 159 0 2   5 2     3   8   101 78 0   5   1   42       0.0 179 159 0 2   5 2     3   8   101 78 0   5 1 42     0 179
2459522 WA Lewis   school 5301170 21302   Chehalis School District 530117000215 2442 R E Bennett Elementary (Closed after 2017-2018 school year)   Regular School No Elementary 02 03 2018   grade_2 158 1 49   0 4     1   11   117 107 0   15   6   130       0.0 224 158 1 49   0 4     1   11   117 107 0   15 6 130     0 224
2414968 WA Lewis   school 5301170 21302   Chehalis School District 530117003654 5509 James W Lintott Elementary School   Regular School No Elementary PK 02 2019   grade_2 154 2 40   0 0     0   23   111 108 0   9   12   125       0.0 219 154 2 40   0 0     0   23   111 108 0   9 12 125     0 219
2458129 WA Clark   school 5300380 6119   Battle Ground School District 530038000056 2910 Yacolt Primary   Regular School No Elementary PK 04 2018   grade_2 154 0 3   0 1     0   4   94 68 0   2   1   65       1.0 162 154 0 3   0 1     0   4   94 68 0   2 1 65     1 162
2943071 WA Yakima   school 5307770 39119   Selah School District 530777003513 5383 John Campbell Primary School   Regular School No Elementary 01 02 2021   grade_2 152 2 96   0 1     0   5   128 127 1   47   1   138       2.0 256 152 2 96   0 1     0   5   128 127 1   47 1 138     2 256
2933041 WA Spokane   school 5301110 32356   Central Valley School District 530111003596 5507 Liberty Creek Elementary School   Regular School No Elementary KG 03 2021   grade_2 150 6 5   2 4     0   5   91 81 0   7   3   29       0.0 172 150 6 5   2 4     0   5   91 81 0   7 3 29     0 172
533652 WA King   school 5308760 17409   Tahoma School District 530876001516 3286 Lake Wilderness Elementary   Regular School No 1 PK 05 2016   grade_2 148 2 14   0 13     0   15   93 99 0   10   2   28       6.0 192 148 2 14   0 13     0   15   93 99 0   10 2 28     6 192
521690 WA Lewis   school 5301170 21302   Chehalis School District 530117000215 2442 R E Bennett Elementary (Closed after 2017-2018 school year)   Regular School No 1 02 03 2016   grade_2 146 0 38   2 1     1   11   102 97 0   14   6   121       0.0 199 146 0 38   2 1     1   11   102 97 0   14 6 121     0 199
2415791 WA Spokane   school 5302070 32414   Deer Park School District 530207000307 2430 Deer Park Elementary   Regular School No Elementary KG 02 2019   grade_2 146 2 5   6 1     0   0   80 80 0   5   11   92       5.0 160 146 2 5   6 1     0   0   80 80 0   5 11 92     5 160
619043 WA Lewis   school 5301170 21302   Chehalis School District 530117000215 2442 R E Bennett Elementary (Closed after 2017-2018 school year)   Regular School No Elementary 02 03 2017   grade_2 144 1 37   0 0     0   11   106 87 0   16   12   124       1.0 193 144 1 37   0 0     0   11   106 87 0   16 12 124     1 193
626342 WA Okanogan   school 5306220 24019   Omak School District 530622003282 5195 Washington Virtual Academy Omak Elementary   Regular School No Elementary KG 05 2017   grade_2 144 22 20   6 14     1   1   93 115 0   5   0   103       5.0 208 144 22 20   6 14     1   1   93 115 0   5 0 103     5 208
617627 WA Clark   school 5300380 6119   Battle Ground School District 530038000056 2910 Yacolt Primary   Regular School No Elementary PK 04 2017   grade_2 142 0 2   0 0     0   2   78 68 0   1   4   69       3.0 146 142 0 2   0 0     0   2   78 68 0   1 4 69     3 146
2933228 WA Lewis   school 5301170 21302   Chehalis School District 530117003654 5509 James W Lintott Elementary School   Regular School No Elementary PK 02 2021   grade_2 141 2 55   0 1     0   14   99 114 0   11   3   113       3.0 213 141 2 55   0 1     0   14   99 114 0   11 3 113     3 213
462481 WA Spokane   school 5302070 32414   Deer Park School District 530207000307 2430 Deer Park Elementary   Regular School No 1.0 KG 02 2015   grade_2 140 1 11   3 0     0   1   92 64 0   2   6   94       3.0 156 140 1 11   3 0     0   1   92 64 0   2 6 94     3 156
461708 WA Lewis   school 5301170 21302   Chehalis School District 530117000215 2442 R E Bennett Elementary (Closed after 2017-2018 school year)   Regular School No 1.0 02 03 2015   grade_2 139 0 36   0 2     0   10   104 83 0   20   11   120       0.0 187 139 0 36   0 2     0   10   104 83 0   20 11 120     0 187
473657 WA King   school 5308760 17409   Tahoma School District 530876001516 3286 Lake Wilderness Elementary   Regular School No 1.0 PK 06 2015   grade_2 139 4 13   1 12     2   21   102 90 0   6   1   42       7.0 192 139 4 13   1 12     2   21   102 90 0   6 1 42     7 192
2570891 WA Clark   school 5300380 6119   Battle Ground School District 530038000056 2910 Yacolt Primary   Regular School No Elementary PK 04 2020   grade_2 138 1 8   0 0     0   4   70 81 0   4   1   48       3.0 151 138 1 8   0 0     0   4   70 81 0   4 1 48     3 151
2413574 WA Clark   school 5300380 6119   Battle Ground School District 530038000056 2910 Yacolt Primary   Regular School No Elementary PK 04 2019   grade_2 136 0 4   1 1     1   5   75 73 0   1   1   54       5.0 148 136 0 4   1 1     1   5   75 73 0   1 1 54     5 148
473669 WA King   school 5308760 17409   Tahoma School District 530876000692 4415 Rock Creek Elementary   Regular School No 1.0 PK 06 2015   grade_2 132 4 15   1 4     1   13   85 85 0   5   1   31       8.0 170 132 4 15   1 4     1   13   85 85 0   5 1 31     8 170
522468 WA Spokane   school 5302070 32414   Deer Park School District 530207000307 2430 Deer Park Elementary   Regular School No 1 KG 02 2016   grade_2 132 2 7   8 0     0   0   73 76 0   0   7   100       6.0 149 132 2 7   8 0     0   0   73 76 0   0 7 100     6 149
2423645 WA Clark   school 5307350 6122   Ridgefield School District 530735001107 3786 Union Ridge Elementary   Regular School No Elementary KG 04 2019   grade_2 130 0 19   0 2     0   12   78 85 0   7   4   44       1.0 163 130 0 19   0 2     0   12   78 85 0   7 4 44     1 163
2458746 WA Whatcom   school 5300570 37503   Blaine School District 530057001741 4476 Blaine Primary School   Regular School No Elementary KG 02 2018   grade_2 130 3 15   0 4     0   16   82 86 0   10   8   96       3.0 168 130 3 15   0 4     0   16   82 86 0   10 8 96     3 168
2472716 WA Cowlitz   school 5310050 8404   Woodland School District 531005003517 5408 Woodland Intermediate School (Closed after 2018-2019 school year)   Regular School No Elementary 02 04 2018   grade_2 130 1 44   0 0     1   3   97 82 0   31   6   93       1.0 179 130 1 44   0 0     1   3   97 82 0   31 6 93     1 179
2573122 WA Spokane   school 5302070 32414   Deer Park School District 530207000307 2430 Deer Park Elementary   Regular School No Elementary KG 02 2020   grade_2 130 2 12   8 0     0   0   64 88 0   5   5   83       2.0 152 130 2 12   8 0     0   0   64 88 0   5 5 83     2 152
631000 WA King   school 5308760 17409   Tahoma School District 530876000692 4415 Rock Creek Elementary   Regular School No Elementary PK 05 2017   grade_2 129 4 19   1 6     0   11   95 75 0   5   0   21       4.0 170 129 4 19   1 6     0   11   95 75 0   5 0 21     4 170
2423787 WA Thurston   school 5307470 34401   Rochester School District 530747001117 2527 Rochester Primary School   Regular School No Elementary PK 02 2019   grade_2 129 1 40   9 0     1   17   115 82 0   34   9   115       21.0 197 129 1 40   9 0     1   17   115 82 0   34 9 115     21 197
2458053 WA Clark   school 5300380 6119   Battle Ground School District 530038000051 3018 Glenwood Heights Primary   Regular School No Elementary PK 04 2018   grade_2 128 5 21   0 12     1   7   93 81 0   41   8   75       2.0 174 128 5 21   0 12     1   7   93 81 0   41 8 75     2 174
2935971 WA Snohomish   school 5303210 31332   Granite Falls School District 530321002303 4330 Mountain Way Elementary   Regular School No Elementary PK 02 2021   grade_2 128 0 26   2 1     0   10   80 87 0   7   8   75       1.0 167 128 0 26   2 1     0   10   80 87 0   7 8 75     1 167
520164 WA Clark   school 5300380 6119   Battle Ground School District 530038002278 4352 Captain Strong   Regular School No 1 PK 04 2016   grade_2 127 1 23   0 2     0   7   77 83 0   18   0   75       3.0 160 127 1 23   0 2     0   7   77 83 0   18 0 75     3 160
520263 WA Clark   school 5300380 6119   Battle Ground School District 530038003228 5132 Tukes Valley Primary   Regular School No 1 PK 04 2016   grade_2 127 1 9   0 0     0   7   68 76 0   10   3   56       2.0 144 127 1 9   0 0     0   7   68 76 0   10 3 56     2 144
618258 WA Whatcom   school 5300570 37503   Blaine School District 530057001741 4476 Blaine Primary School   Regular School No Elementary KG 02 2017   grade_2 127 2 13   2 5     0   5   85 69 0   10   3   83       5.0 154 127 2 13   2 5     0   5   85 69 0   10 3 83     5 154
2938146 WA Mason   school 5304800 23311   Mary M Knight School District 530480003569 5445 Washington Connections Academy   Regular School No Elementary KG 08 2021   grade_2 127 9 26   1 6     2   26   95 102 0   6   0   35       11.0 197 127 9 26   1 6     2   26   95 102 0   6 0 35     11 197
470708 WA Thurston   school 5307470 34401   Rochester School District 530747001117 2527 Rochester Primary School   Regular School No 1.0 PK 02 2015   grade_2 126 0 38   4 0     0   16   97 87 0   16   20   99       0.0 184 126 0 38   4 0     0   16   97 87 0   16 20 99     0 184
522235 WA Stevens   school 5301630 33115   Colville School District 530163000284 2957 Hofstetter Elementary   Regular School No 1 KG 02 2016   grade_2 126 1 8   2 0     0   5   67 75 0   4   1   93       0.0 142 126 1 8   2 0     0   5   67 75 0   4 1 93     0 142
533664 WA King   school 5308760 17409   Tahoma School District 530876000692 4415 Rock Creek Elementary   Regular School No 1 PK 05 2016   grade_2 125 1 11   1 4     0   14   79 77 0   3   0   18       2.0 156 125 1 11   1 4     0   14   79 77 0   3 0 18     2 156
630988 WA King   school 5308760 17409   Tahoma School District 530876001516 3286 Lake Wilderness Elementary   Regular School No Elementary PK 05 2017   grade_2 125 1 22   0 6     1   24   100 79 0   6   2   30       7.0 179 125 1 22   0 6     1   24   100 79 0   6 2 30     7 179
2418053 WA Clark   school 5303570 6098   Hockinson School District 530357003440 5311 Hockinson Heights Elementary School   Regular School No Elementary KG 05 2019   grade_2 125 1 11   0 3     0   13   74 79 0   6   1   37       6.0 153 125 1 11   0 3     0   13   74 79 0   6 1 37     6 153
619833 WA Spokane   school 5302070 32414   Deer Park School District 530207000307 2430 Deer Park Elementary   Regular School No Elementary KG 02 2017   grade_2 123 1 12   0 0     1   0   69 68 0   0   9   84       1.0 137 123 1 12   0 0     1   0   69 68 0   0 9 84     1 137
2581025 WA Clark   school 5307350 6122   Ridgefield School District 530735001107 3786 Union Ridge Elementary   Regular School No Elementary KG 04 2020   grade_2 123 0 21   0 3     0   13   86 74 0   8   0   31       6.0 160 123 0 21   0 3     0   13   86 74 0   8 0 31     6 160
475235 WA Cowlitz   school   8404   Woodland School District   5407 Woodland Primary School (Closed after 2018-2019 school year)             2015   grade_2 122 1 42   3 1     0   3   91 81 0   31   7   94       2.0 172 122 1 42   3 1     0   3   91 81 0   31 7 94     2 172
2415548 WA Stevens   school 5301630 33115   Colville School District 530163000284 2957 Hofstetter Elementary   Regular School No Elementary KG 02 2019   grade_2 121 2 8   0 2     0   9   61 81 0   5   3   90       0.0 142 121 2 8   0 2     0   9   61 81 0   5 3 90     0 142
2422085 WA Okanogan   school 5306220 24019   Omak School District 530622003282 5195 Washington Virtual Academy Omak Elementary   Regular School No Elementary KG 05 2019   grade_2 121 14 24   3 6     2   13   108 75 0   6   0   68       0.0 183 121 14 24   3 6     2   13   108 75 0   6 0 68     0 183
470526 WA Benton   school 5307320 3400   Richland School District 530732003171 5092 White Bluffs Elementary School   Regular School No 1.0 PK 05 2015   grade_2 120 0 8   1 9     1   9   74 74 0   5   0   26       0.0 148 120 0 8   1 9     1   9   74 74 0   5 0 26     0 148
473648 WA King   school 5308760 17409   Tahoma School District 530876001463 4453 Glacier Park Elementary   Regular School No 1.0 PK 06 2015   grade_2 120 2 10   0 7     0   22   88 73 0   7   0   12       5.0 161 120 2 10   0 7     0   22   88 73 0   7 0 12     5 161
2428194 WA Cowlitz   school 5310050 8404   Woodland School District 531005003517 5408 Woodland Intermediate School (Closed after 2018-2019 school year)   Regular School No Elementary 02 04 2019   grade_2 120 0 44   0 0     0   8   93 79 0   24   10   89       2.0 172 120 0 44   0 0     0   8   93 79 0   24 10 89     2 172
2934021 WA Spokane   school 5302070 32414   Deer Park School District 530207000307 2430 Deer Park Elementary   Regular School No Elementary KG 02 2021   grade_2 120 2 8   5 1     0   0   65 71 0   2   7   78       2.0 136 120 2 8   5 1     0   0   65 71 0   2 7 78     2 136
462517 WA Pierce   school 5302130 27343   Dieringer School District 530213000310 3683 Lake Tapps Elementary   Regular School No 1.0 01 03 2015   grade_2 119 0 14   0 10     0   26   95 74 0   7   0   29       8.0 169 119 0 14   0 10     0   26   95 74 0   7 0 29     8 169
521524 WA Spokane   school 5301110 32356   Central Valley School District 530111002681 4529 Liberty Lake Elementary   Regular School No 1 01 05 2016   grade_2 119 1 5   1 3     0   8   76 61 0   1   3   29       2.0 137 119 1 5   1 3     0   8   76 61 0   1 3 29     2 137
2458023 WA Clark   school 5300380 6119   Battle Ground School District 530038002278 4352 Captain Strong   Regular School No Elementary PK 04 2018   grade_2 119 2 10   0 0     0   7   79 59 0   14   3   49       2.0 138 119 2 10   0 0     0   7   79 59 0   14 3 49     2 138
2460290 WA Spokane   school 5302070 32414   Deer Park School District 530207000307 2430 Deer Park Elementary   Regular School No Elementary KG 02 2018   grade_2 119 2 5   3 0     0   0   67 62 0   2   10   77       4.0 129 119 2 5   3 0     0   0   67 62 0   2 10 77     4 129
2460322 WA Pierce   school 5302130 27343   Dieringer School District 530213000310 3683 Lake Tapps Elementary   Regular School No Elementary 01 03 2018   grade_2 118 3 19   0 8     1   20   84 85 0   13   1   28       6.0 169 118 3 19   0 8     1   20   84 85 0   13 1 28     6 169
2466549 WA Okanogan   school 5306220 24019   Omak School District 530622003282 5195 Washington Virtual Academy Omak Elementary   Regular School No Elementary KG 05 2018   grade_2 118 14 24   3 7     5   8   98 81 0   7   0   94       2.0 179 118 14 24   3 7     5   8   98 81 0   7 0 94     2 179
465255 WA Benton   school 5303930 3017   Kennewick School District 530393003330 5220 Cottonwood Elementary   Regular School No 1.0 KG 05 2015   grade_2 117 0 5   1 1     0   2   70 56 0   6   0   23       0.0 126 117 0 5   1 1     0   2   70 56 0   6 0 23     0 126
622176 WA Clark   school 5303570 6098   Hockinson School District 530357003440 5311 Hockinson Heights Elementary School   Regular School No Elementary KG 05 2017   grade_2 117 2 7   1 4     0   5   70 66 0   9   1   31       2.0 136 117 2 7   1 4     0   5   70 66 0   9 1 31     2 136
460918 WA Whatcom   school 5300570 37503   Blaine School District 530057001741 4476 Blaine Primary School   Regular School No 1.0 KG 02 2015   grade_2 115 3 20   1 6     2   16   73 90 0   13   0   75       8.0 163 115 3 20   1 6     2   16   73 90 0   13 0 75     8 163
533644 WA King   school 5308760 17409   Tahoma School District 530876001463 4453 Glacier Park Elementary   Regular School No 1 PK 05 2016   grade_2 115 6 14   0 7     0   20   84 78 0   5   0   13       2.0 162 115 6 14   0 7     0   20   84 78 0   5 0 13     2 162
2415826 WA Pierce   school 5302130 27343   Dieringer School District 530213000310 3683 Lake Tapps Elementary   Regular School No Elementary 01 03 2019   grade_2 115 6 11   0 12     0   11   75 80 0   11   2   25       8.0 155 115 6 11   0 12     0   11   75 80 0   11 2 25     8 155
2572888 WA Stevens   school 5301630 33115   Colville School District 530163000284 2957 Hofstetter Elementary   Regular School No Elementary KG 02 2020   grade_2 115 0 7   0 1     0   6   66 63 0   1   4   81       0.0 129 115 0 7   0 1     0   6   66 63 0   1 4 81     0 129
2942159 WA Thurston   school 5307470 34401   Rochester School District 530747001117 2527 Rochester Primary School   Regular School No Elementary PK 02 2021   grade_2 115 1 47   9 0     0   13   94 91 0   40   10   105       4.0 185 115 1 47   9 0     0   13   94 91 0   40 10 105     4 185
461542 WA Spokane   school 5301110 32356   Central Valley School District 530111002681 4529 Liberty Lake Elementary   Regular School No 1.0 PK 05 2015   grade_2 114 1 4   1 3     0   0   58 65 0   2   1   30       6.0 123 114 1 4   1 3     0   0   58 65 0   2 1 30     6 123
462253 WA Stevens   school 5301630 33115   Colville School District 530163000284 2957 Hofstetter Elementary   Regular School No 1.0 KG 04 2015   grade_2 114 1 8   1 1     1   2   61 67 0   3   1   77       0.0 128 114 1 8   1 1     1   2   61 67 0   3 1 77     0 128
630980 WA King   school 5308760 17409   Tahoma School District 530876001463 4453 Glacier Park Elementary   Regular School No Elementary PK 05 2017   grade_2 114 3 25   0 10     4   15   96 75 0   7   0   18       4.0 171 114 3 25   0 10     4   15   96 75 0   7 0 18     4 171
2419029 WA Clark   school 5304170 6101   La Center School District 530417000650 2558 La Center Elementary   Regular School No Elementary PK 05 2019   grade_2 114 0 12   0 2     1   3   70 61 1   6   6   41       6.0 132 114 0 12   0 2     1   3   70 61 1   6 6 41     6 132
460203 WA Clark   school 5300380 6119   Battle Ground School District 530038003194 5090 Daybreak Primary   Regular School No 1.0 PK 04 2015   grade_2 113 0 16   0 1     0   8   74 64 0   21   4   77       0.0 138 113 0 16   0 1     0   8   74 64 0   21 4 77     0 138
520890 WA Whatcom   school 5300570 37503   Blaine School District 530057001741 4476 Blaine Primary School   Regular School No 1 KG 02 2016   grade_2 113 1 16   2 11     1   8   72 80 0   11   5   75       4.0 152 113 1 16   2 11     1   8   72 80 0   11 5 75     4 152
525760 WA Clark   school 5304170 6101   La Center School District 530417000650 2558 La Center Elementary   Regular School No 1 PK 05 2016   grade_2 113 1 8   0 0     0   2   59 65 0   8   4   37       1.0 124 113 1 8   0 0     0   2   59 65 0   8 4 37     1 124
2414898 WA Spokane   school 5301110 32356   Central Valley School District 530111001827 4160 Sunrise Elementary   Regular School No Elementary PK 05 2019   grade_2 113 0 0   2 4     0   2   57 64 0   3   0   16       0.0 121 113 0 0   2 4     0   2   57 64 0   3 0 16     0 121
2458122 WA Clark   school 5300380 6119   Battle Ground School District 530038003228 5132 Tukes Valley Primary   Regular School No Elementary PK 04 2018   grade_2 113 1 12   1 0     0   7   74 60 0   10   1   47       1.0 134 113 1 12   1 0     0   7   74 60 0   10 1 47     1 134
524797 WA Clark   school 5303570 6098   Hockinson School District 530357003440 5311 Hockinson Heights Elementary School   Regular School No 1 PK 05 2016   grade_2 111 2 7   0 3     0   9   71 61 0   5   3   41       5.0 132 111 2 7   0 3     0   9   71 61 0   5 3 41     5 132
535164 WA Cowlitz   school 5310050 8404   Woodland School District 531005003517 5408 Woodland Intermediate School (Closed after 2018-2019 school year)   Regular School No 1 02 04 2016   grade_2 111 1 41   1 0     0   1   76 79 0   27   3   72       0.0 155 111 1 41   1 0     0   1   76 79 0   27 3 72     0 155
619597 WA Stevens   school 5301630 33115   Colville School District 530163000284 2957 Hofstetter Elementary   Regular School No Elementary KG 02 2017   grade_2 111 0 12   2 0     0   3   68 60 0   5   3   78       0.0 128 111 0 12   2 0     0   3   68 60 0   5 3 78     0 128
622591 WA Benton   school 5303930 3017   Kennewick School District 530393003330 5220 Cottonwood Elementary   Regular School No Elementary KG 05 2017   grade_2 111 2 10   0 1     0   3   73 54 0   1   0   24       6.0 127 111 2 10   0 1     0   3   73 54 0   1 0 24     6 127
626498 WA Pierce   school 5306450 27344   Orting School District 530645000952 2360 Orting Primary School   Regular School No Elementary PK 03 2017   grade_2 111 3 16   2 1     0   18   68 83 0   3   1   59       6.0 151 111 3 16   2 1     0   18   68 83 0   3 1 59     6 151
2422227 WA Pierce   school 5306450 27344   Orting School District 530645000952 2360 Orting Primary School   Regular School No Elementary PK 03 2019   grade_2 111 1 19   1 0     0   13   78 67 0   4   1   53       8.0 145 111 1 19   1 0     0   13   78 67 0   4 1 53     8 145
2462248 WA Snohomish   school 5303210 31332   Granite Falls School District 530321002303 4330 Mountain Way Elementary   Regular School No Elementary KG 02 2018   grade_2 111 1 17   3 0     0   4   62 74 0   8   9   72       0.0 136 111 1 17   3 0     0   4   62 74 0   8 9 72     0 136
2571516 WA Whatcom   school 5300570 37503   Blaine School District 530057001741 4476 Blaine Primary School   Regular School No Elementary PK 02 2020   grade_2 111 3 23   1 5     1   12   86 70 0   14   3   86       8.0 156 111 3 23   1 5     1   12   86 70 0   14 3 86     8 156
2581166 WA Thurston   school 5307470 34401   Rochester School District 530747001117 2527 Rochester Primary School   Regular School No Elementary PK 02 2020   grade_2 111 0 37   4 0     0   16   94 74 0   26   5   97       15.0 168 111 0 37   4 0     0   16   94 74 0   26 5 97     15 168
2938376 WA Spokane   school 5304920 32354   Mead School District 530492000746 3759 Farwell Elementary School   Regular School No Elementary KG 05 2021   grade_2 110 1 11   1 3     1   9   60 76 0   3   6   35       1.0 136 110 1 11   1 3     1   9   60 76 0   3 6 35     1 136
521502 WA Spokane   school 5301110 32356   Central Valley School District 530111000194 2157 Greenacres Elementary   Regular School No 1 01 05 2016   grade_2 109 0 4   1 2     0   8   61 63 0   11   2   48       6.0 124 109 0 4   1 2     0   8   61 63 0   11 2 48     6 124
628083 WA Thurston   school 5307470 34401   Rochester School District 530747001117 2527 Rochester Primary School   Regular School No Elementary PK 02 2017   grade_2 109 0 44   6 0     1   10   89 81 0   28   3   101       7.0 170 109 0 44   6 0     1   10   89 81 0   28 3 101     7 170
2460050 WA Stevens   school 5301630 33115   Colville School District 530163000284 2957 Hofstetter Elementary   Regular School No Elementary KG 02 2018   grade_2 109 0 4   1 0     0   2   63 53 0   2   0   71       0.0 116 109 0 4   1 0     0   2   63 53 0   2 0 71     0 116
618858 WA Spokane   school 5301110 32356   Central Valley School District 530111000194 2157 Greenacres Elementary   Regular School No Elementary 01 05 2017   grade_2 108 1 6   1 2     1   3   64 58 0   5   0   38       5.0 122 108 1 6   1 2     1   3   64 58 0   5 0 38     5 122
627939 WA Clark   school 5307350 6122   Ridgefield School District 530735001107 3786 Union Ridge Elementary   Regular School No Elementary KG 06 2017   grade_2 108 0 3   0 0     0   4   55 60 0   4   2   31       0.0 115 108 0 3   0 0     0   4   55 60 0   4 2 31     0 115
2934053 WA Pierce   school 5302130 27343   Dieringer School District 530213000310 3683 Lake Tapps Elementary   Regular School No Elementary 01 03 2021   grade_2 108 2 14   2 11     0   13   75 75 0   10   3   21       3.0 150 108 2 14   2 11     0   13   75 75 0   10 3 21     3 150
2936270 WA Clark   school 5303570 6098   Hockinson School District 530357003440 5311 Hockinson Heights Elementary School   Regular School No Elementary KG 05 2021   grade_2 108 2 10   0 1     1   6   61 67 0   9   2   29       4.0 128 108 2 10   0 1     1   6   61 67 0   9 2 29     4 128
460284 WA Clark   school 5300380 6119   Battle Ground School District 530038003228 5132 Tukes Valley Primary   Regular School No 1.0 PK 04 2015   grade_2 107 0 7   0 1     0   6   72 49 0   7   1   44       0.0 121 107 0 7   0 1     0   6   72 49 0   7 1 44     0 121
525215 WA Benton   school 5303930 3017   Kennewick School District 530393003330 5220 Cottonwood Elementary   Regular School No 1 KG 05 2016   grade_2 107 0 10   0 2     0   3   64 58 0   5   0   25       3.0 122 107 0 10   0 2     0   3   64 58 0   5 0 25     3 122

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