Data source: Big Local News · About: Big Local

8,808 rows where grade = "grade_2" and state = "WA" sorted by total_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
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
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
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
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
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
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
2422474 WA Franklin   school 5306570 11001   Pasco School District 530657002621 4526 Whittier Elementary   Regular School No Elementary KG 02 2019   grade_2 7 2 197   0 1     0   6   113 100 0   166   7   202       1.0 213 7 2 197   0 1     0   6   113 100 0   166 7 202     1 213
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
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
626746 WA Franklin   school 5306570 11001   Pasco School District 530657002621 4526 Whittier Elementary   Regular School No Elementary KG 02 2017   grade_2 6 0 200   0 1     0   1   88 120 0   158   0   204       1.0 208 6 0 200   0 1     0   1   88 120 0   158 0 204     1 208
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
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
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
2466961 WA Franklin   school 5306570 11001   Pasco School District 530657002621 4526 Whittier Elementary   Regular School No Elementary KG 02 2018   grade_2 9 1 180   0 3     0   2   87 108 0   150   3   188       2.0 195 9 1 180   0 3     0   2   87 108 0   150 3 188     2 195
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
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
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
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
2579834 WA Franklin   school 5306570 11001   Pasco School District 530657002621 4526 Whittier Elementary   Regular School No Elementary KG 02 2020   grade_2 9 2 176   0 4     0   1   104 88 0   153   2   178       1.0 192 9 2 176   0 4     0   1   104 88 0   153 2 178     1 192
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
2578863 WA King   school 5305910 17417   Northshore School District 530591002222 4306 Fernwood Elementary   Regular School No Elementary PK 05 2020   grade_2 57 3 6   1 113     0   7   98 89 0   24   0   4       9.0 187 57 3 6   1 113     0   7   98 89 0   24 0 4     9 187
529313 WA Franklin   school 5306570 11001   Pasco School District 530657002621 4526 Whittier Elementary   Regular School No 1 KG 03 2016   grade_2 7 0 179   0 0     0   0   92 94 0   137   5   180       0.0 186 7 0 179   0 0     0   0   92 94 0   137 5 180     0 186
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
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
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
622345 WA King   school 5303750 17411   Issaquah School District 530375003067 5056 Grand Ridge Elementary   Regular School No Elementary KG 05 2017   grade_2 94 4 6   0 63     0   13   94 86 0   18   0   11       3.0 180 94 4 6   0 63     0   13   94 86 0   18 0 11     3 180
532966 WA Pierce   school 5308460 27001   Steilacoom Hist. School District 530846002879 4562 Chloe Clark Elementary   Regular School No 1 KG 03 2016   grade_2 83 17 24   1 19     4   31   98 81 0   13   1   25       4.0 179 83 17 24   1 19     4   31   98 81 0   13 1 25     4 179
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
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
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
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
2939742 WA King   school 5305910 17417   Northshore School District 530591000878 4017 Canyon Creek Elementary   Regular School No Elementary PK 05 2021   grade_2 69 1 12   0 81     0   16   85 94 0   23   1   10       4.0 179 69 1 12   0 81     0   16   85 94 0   23 1 10     4 179
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
469695 WA Benton   school 5306900 3116   Prosser School District 530690001014 2195 Keene-Riverview Elementary   Regular School No 1.0 PK 02 2015   grade_2 60 0 114   0 1     0   1   78 98 0   57   12   129       2.0 176 60 0 114   0 1     0   1   78 98 0   57 12 129     2 176
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
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
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
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
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
465018 WA King   school 5303750 17411   Issaquah School District 530375003067 5056 Grand Ridge Elementary   Regular School No 1.0 KG 05 2015   grade_2 91 0 5   0 57     0   18   90 81 0   13   0   7       1.0 171 91 0 5   0 57     0   18   90 81 0   13 0 7     1 171
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
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
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
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
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
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
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
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
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
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
2579430 WA Okanogan   school 5306220 24019   Omak School District 530622003282 5195 Washington Virtual Academy Omak Elementary   Regular School No Elementary KG 05 2020   grade_2 100 17 25   2 8     2   12   88 77 1   15   1   126       5.0 166 100 17 25   2 8     2   12   88 77 1   15 1 126     5 166
530657 WA Thurston   school 5307470 34401   Rochester School District 530747001117 2527 Rochester Primary School   Regular School No 1 PK 02 2016   grade_2 107 0 37   8 3     0   10   73 92 0   17   12   103       2.0 165 107 0 37   8 3     0   10   73 92 0   17 12 103     2 165
2574802 WA Pierce   school 5302880 27417   Fife School District 530288000466 2809 Endeavour Intermediate   Regular School No Elementary 02 05 2020   grade_2 53 5 43   2 13     12   37   97 68 0   38   3   95       2.0 165 53 5 43   2 13     12   37   97 68 0   38 3 95     2 165
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
530685 WA Grant   school 5307620 13160   Royal School District 530762001122 3090 Red Rock Elementary   Regular School No 1 PK 03 2016   grade_2 21 0 142   0 0     0   0   76 87 0   126   20   131       12.0 163 21 0 142   0 0     0   0   76 87 0   126 20 131     12 163
625738 WA King   school 5305910 17417   Northshore School District 530591002222 4306 Fernwood Elementary   Regular School No Elementary PK 06 2017   grade_2 59 5 14   0 75     0   10   75 88 0   25   2   17       9.0 163 59 5 14   0 75     0   10   75 88 0   25 2 17     9 163
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
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
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
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
469350 WA Franklin   school 5306570 11001   Pasco School District 530657003499 5345 Rosalind Franklin STEM Elementary   Regular School No 1.0 KG 05 2015   grade_2 88 3 65   0 1     0   3   84 76 0   31   1   74       1.0 160 88 3 65   0 1     0   3   84 76 0   31 1 74     1 160
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
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
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
2414197 WA Whatcom   school 5300570 37503   Blaine School District 530057001741 4476 Blaine Primary School   Regular School No Elementary PK 02 2019   grade_2 101 3 29   5 7     2   12   88 71 0   17   4   89       5.0 159 101 3 29   5 7     2   12   88 71 0   17 4 89     5 159
2468292 WA Thurston   school 5307470 34401   Rochester School District 530747001117 2527 Rochester Primary School   Regular School No Elementary PK 02 2018   grade_2 100 1 39   3 0     2   14   78 81 0   27   12   95       7.0 159 100 1 39   3 0     2   14   78 81 0   27 12 95     7 159
467704 WA Snohomish   school 5305430 31006   Mukilteo School District 530543002320 4344 Horizon Elementary   Regular School No 1.0 KG 05 2015   grade_2 38 5 88   1 6     4   16   79 79 0   73   4   141       3.0 158 38 5 88   1 6     4   16   79 79 0   73 4 141     3 158
2417461 WA Pierce   school 5302880 27417   Fife School District 530288000466 2809 Endeavour Intermediate   Regular School No Elementary 02 05 2019   grade_2 56 13 41   1 10     11   26   75 82 1   36   4   79       2.0 158 56 13 41   1 10     11   26   75 82 1   36 4 79     2 158
2422770 WA Benton   school 5306900 3116   Prosser School District 530690001014 2195 Keene-Riverview Elementary   Regular School No Elementary PK 02 2019   grade_2 49 2 99   0 2     0   6   91 67 0   52   14   119       3.0 158 49 2 99   0 2     0   6   91 67 0   52 14 119     3 158
529624 WA Benton   school 5306900 3116   Prosser School District 530690001014 2195 Keene-Riverview Elementary   Regular School No 1 PK 02 2016   grade_2 41 1 106   1 8     0   0   76 81 0   63   6   120       3.0 157 41 1 106   1 8     0   0   76 81 0   63 6 120     3 157
2421522 WA King   school 5305910 17417   Northshore School District 530591002222 4306 Fernwood Elementary   Regular School No Elementary PK 05 2019   grade_2 44 0 10   0 97     0   6   86 71 0   23   1   9       11.0 157 44 0 10   0 97     0   6   86 71 0   23 1 9     11 157
2467257 WA Benton   school 5306900 3116   Prosser School District 530690001014 2195 Keene-Riverview Elementary   Regular School No Elementary PK 02 2018   grade_2 50 0 99   2 3     0   3   83 74 0   49   7   107       4.0 157 50 0 99   2 3     0   3   83 74 0   49 7 107     4 157
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
473159 WA Yakima   school 5308670 39201   Sunnyside School District 530867001450 4000 Chief Kamiakin Elementary School   Regular School No 1.0 PK 06 2015   grade_2 13 0 139   0 0     0   4   84 72 0   60   11   139       0.0 156 13 0 139   0 0     0   4   84 72 0   60 11 139     0 156
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
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
2583403 WA Pierce   school 5308460 27001   Steilacoom Hist. School District 530846002879 4562 Chloe Clark Elementary   Regular School No Elementary KG 03 2020   grade_2 61 11 38   1 15     2   28   83 73 0   9   0   34       1.0 156 61 11 38   1 15     2   28   83 73 0   9 0 34     1 156
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
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
2573158 WA Pierce   school 5302130 27343   Dieringer School District 530213000310 3683 Lake Tapps Elementary   Regular School No Elementary 01 03 2020   grade_2 104 4 17   0 12     0   18   82 73 0   19   4   31       3.0 155 104 4 17   0 12     0   18   82 73 0   19 4 31     3 155
464204 WA Pierce   school 5302880 27417   Fife School District 530288000466 2809 Endeavour Intermediate   Regular School No 1.0 02 05 2015   grade_2 66 5 38   1 13     5   26   70 84 0   30   3   88       0.0 154 66 5 38   1 13     5   26   70 84 0   30 3 88     0 154
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
2465986 WA King   school 5305910 17417   Northshore School District 530591002222 4306 Fernwood Elementary   Regular School No Elementary PK 05 2018   grade_2 55 1 8   0 73     1   16   70 84 0   22   1   6       11.0 154 55 1 8   0 73     1   16   70 84 0   22 1 6     11 154
621550 WA Pierce   school 5302880 27417   Fife School District 530288000466 2809 Endeavour Intermediate   Regular School No Elementary 02 05 2017   grade_2 60 4 43   1 9     12   24   79 74 0   32   3   87       1.0 153 60 4 43   1 9     12   24   79 74 0   32 3 87     1 153
628111 WA Grant   school 5307620 13160   Royal School District 530762001122 3090 Red Rock Elementary   Regular School No Elementary KG 03 2017   grade_2 26 0 127   0 0     0   0   67 86 0   107   18   118       11.0 153 26 0 127   0 0     0   0   67 86 0   107 18 118     11 153
630509 WA Yakima   school 5308670 39201   Sunnyside School District 530867001450 4000 Chief Kamiakin Elementary School   Regular School No Elementary PK 05 2017   grade_2 13 1 138   0 0     0   1   77 76 0   53   3   138       0.0 153 13 1 138   0 0     0   1   77 76 0   53 3 138     0 153
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
2418227 WA King   school 5303750 17411   Issaquah School District 530375003067 5056 Grand Ridge Elementary   Regular School No Elementary KG 05 2019   grade_2 60 1 7   0 72     0   13   80 73 0   16   0   8       4.0 153 60 1 7   0 72     0   13   80 73 0   16 0 8     4 153
2463960 WA King   school 5304230 17414   Lake Washington School District 530423000678 2289 Redmond Elementary   Regular School No Elementary KG 05 2018   grade_2 38 6 11   0 86     0   12   80 73 0   28   2   20       2.0 153 38 6 11   0 86     0   12   80 73 0   28 2 20     2 153
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
524972 WA King   school 5303750 17411   Issaquah School District 530375003067 5056 Grand Ridge Elementary   Regular School No 1 KG 05 2016   grade_2 71 6 11   0 45     0   19   75 77 0   15   0   9       2.0 152 71 6 11   0 45     0   19   75 77 0   15 0 9     2 152
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
2575570 WA King   school 5303750 17411   Issaquah School District 530375003067 5056 Grand Ridge Elementary   Regular School No Elementary KG 05 2020   grade_2 59 1 9   0 66     0   17   80 72 0   13   0   8       3.0 152 59 1 9   0 66     0   17   80 72 0   13 0 8     3 152
473171 WA Yakima   school 5308670 39201   Sunnyside School District 530867001448 2469 Outlook Elementary School   Regular School No 1.0 KG 05 2015   grade_2 6 1 143   0 0     0   1   72 79 0   78   13   134       0.0 151 6 1 143   0 0     0   1   72 79 0   78 13 134     0 151

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