Data source: Big Local News · About: Big Local

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

View and edit SQL

grade

year

  • 2017 · 15,658
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
621547 WA Pierce   school 5302880 27417   Fife School District 530288000464 2878 Discovery Primary School   Regular School No Elementary PK 01 2017   kindergarten_half_day 1 0 0   0 0     0   0   1 0 0   0   0   0       1.0 1 1 0 0   0 0     0   0   1 0 0   0 0 0     1 1
621548 WA Pierce   school 5302880 27417   Fife School District 530288000464 2878 Discovery Primary School   Regular School No Elementary PK 01 2017   kindergarten 119 14 52   2 15     13   62   151 126 0   64   7   132       2.0 277 119 14 52   2 15     13   62   151 126 0   64 7 132     2 277
621549 WA Pierce   school 5302880 27417   Fife School District 530288000464 2878 Discovery Primary School   Regular School No Elementary PK 01 2017   pre_kindergarten 26 3 12   0 2     2   8   33 20 0   0   0   25       0.0 53 26 3 12   0 2     2   8   33 20 0   0 0 25     0 53
622208 WA Grays Harbor   school 5303660 14028   Hoquiam School District 530366002105 2268 Emerson Elementary   Regular School No Elementary KG 01 2017   grade_1 83 6 20   8 2     0   8   66 61 0   8   5   96       1.0 127 83 6 20   8 2     0   8   66 61 0   8 5 96     1 127
622209 WA Grays Harbor   school 5303660 14028   Hoquiam School District 530366002105 2268 Emerson Elementary   Regular School No Elementary KG 01 2017   pk_12_total 135 9 41   12 2     0   10   100 109 0   14   8   161       2.0 209 135 9 41   12 2     0   10   100 109 0   14 8 161     2 209
622210 WA Grays Harbor   school 5303660 14028   Hoquiam School District 530366002105 2268 Emerson Elementary   Regular School No Elementary KG 01 2017   kindergarten 52 3 21   4 0     0   2   34 48 0   6   3   65       1.0 82 52 3 21   4 0     0   2   34 48 0   6 3 65     1 82
629718 WA Island   school 5308190 15206   South Whidbey School District 530819002051 1683 South Whidbey Special Services   Special Education School No Elementary PK 01 2017   pk_12_total 9 0 0   0 0     0   0   6 3 0   0   0   2       0.0 9 9 0 0   0 0     0   0   6 3 0   0 0 2     0 9
629719 WA Island   school 5308190 15206   South Whidbey School District 530819002051 1683 South Whidbey Special Services   Special Education School No Elementary PK 01 2017   pre_kindergarten 9 0 0   0 0     0   0   6 3 0   0   0   2       0.0 9 9 0 0   0 0     0   0   6 3 0   0 0 2     0 9
632522 WA Cowlitz   school 5310050 8404   Woodland School District 531005003557 5407 Woodland Primary School (Closed after 2018-2019 school year)   Regular School No Elementary PK 01 2017   grade_1 123 1 41   0 0     0   5   90 80 0   32   3   90       0.0 170 123 1 41   0 0     0   5   90 80 0   32 3 90     0 170
632523 WA Cowlitz   school 5310050 8404   Woodland School District 531005003557 5407 Woodland Primary School (Closed after 2018-2019 school year)   Regular School No Elementary PK 01 2017   pk_12_total 263 1 86   0 0     0   13   191 172 0   57   10   193       0.0 363 263 1 86   0 0     0   13   191 172 0   57 10 193     0 363
632524 WA Cowlitz   school 5310050 8404   Woodland School District 531005003557 5407 Woodland Primary School (Closed after 2018-2019 school year)   Regular School No Elementary PK 01 2017   kindergarten 115 0 36   0 0     0   6   77 80 0   25   6   80       0.0 157 115 0 36   0 0     0   6   77 80 0   25 6 80     0 157
632525 WA Cowlitz   school 5310050 8404   Woodland School District 531005003557 5407 Woodland Primary School (Closed after 2018-2019 school year)   Regular School No Elementary PK 01 2017   pre_kindergarten 25 0 9   0 0     0   2   24 12 0   0   1   23       0.0 36 25 0 9   0 0     0   2   24 12 0   0 1 23     0 36
618257 WA Whatcom   school 5300570 37503   Blaine School District 530057001741 4476 Blaine Primary School   Regular School No Elementary KG 02 2017   grade_1 120 3 15   0 6     0   11   75 80 0   16   2   86       4.0 155 120 3 15   0 6     0   11   75 80 0   16 2 86     4 155
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
618259 WA Whatcom   school 5300570 37503   Blaine School District 530057001741 4476 Blaine Primary School   Regular School No Elementary KG 02 2017   pk_12_total 385 8 63   3 20     1   31   274 237 0   42   8   275       13.0 511 385 8 63   3 20     1   31   274 237 0   42 8 275     13 511
618260 WA Whatcom   school 5300570 37503   Blaine School District 530057001741 4476 Blaine Primary School   Regular School No Elementary KG 02 2017   kindergarten 96 2 29   1 4     0   11   78 65 0   16   3   78       2.0 143 96 2 29   1 4     0   11   78 65 0   16 3 78     2 143
618261 WA Whatcom   school 5300570 37503   Blaine School District 530057001741 4476 Blaine Primary School   Regular School No Elementary KG 02 2017   pre_kindergarten 42 1 6   0 5     1   4   36 23 0   0   0   28       2.0 59 42 1 6   0 5     1   4   36 23 0   0 0 28     2 59
618620 WA Chelan   school 5300950 4228   Cascade School District 530095001933 2760 Peshastin Dryden Elementary   Regular School No Elementary PK 02 2017   grade_1 57 1 22   0 0     0   2   42 40 0   18   0   34       0.0 82 57 1 22   0 0     0   2   42 40 0   18 0 34     0 82
618621 WA Chelan   school 5300950 4228   Cascade School District 530095001933 2760 Peshastin Dryden Elementary   Regular School No Elementary PK 02 2017   grade_2 50 0 31   1 0     0   3   37 51 0   26   1   55       1.0 88 50 0 31   1 0     0   3   37 51 0   26 1 55     1 88
618622 WA Chelan   school 5300950 4228   Cascade School District 530095001933 2760 Peshastin Dryden Elementary   Regular School No Elementary PK 02 2017   pk_12_total 187 1 97   1 0     0   8   138 160 0   65   2   153       1.0 298 187 1 97   1 0     0   8   138 160 0   65 2 153     1 298
618623 WA Chelan   school 5300950 4228   Cascade School District 530095001933 2760 Peshastin Dryden Elementary   Regular School No Elementary PK 02 2017   kindergarten_half_day 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
618624 WA Chelan   school 5300950 4228   Cascade School District 530095001933 2760 Peshastin Dryden Elementary   Regular School No Elementary PK 02 2017   kindergarten 38 0 23   0 0     0   3   30 35 0   20   0   31       0.0 65 38 0 23   0 0     0   3   30 35 0   20 0 31     0 65
618625 WA Chelan   school 5300950 4228   Cascade School District 530095001933 2760 Peshastin Dryden Elementary   Regular School No Elementary PK 02 2017   pre_kindergarten 40 0 21   0 0     0   0   28 33 0   1   1   33       0.0 61 40 0 21   0 0     0   0   28 33 0   1 1 33     0 61
619160 WA Jefferson   school 5301290 16049   Chimacum School District 530129002790 4552 Chimacum Creek Primary School   Regular School No Elementary KG 02 2017   grade_1 56 0 3   1 0     0   5   30 35 0   2   2   33       0.0 65 56 0 3   1 0     0   5   30 35 0   2 2 33     0 65
619161 WA Jefferson   school 5301290 16049   Chimacum School District 530129002790 4552 Chimacum Creek Primary School   Regular School No Elementary KG 02 2017   grade_2 64 0 9   0 0     0   3   43 33 0   1   2   45       0.0 76 64 0 9   0 0     0   3   43 33 0   1 2 45     0 76
619162 WA Jefferson   school 5301290 16049   Chimacum School District 530129002790 4552 Chimacum Creek Primary School   Regular School No Elementary KG 02 2017   pk_12_total 201 0 22   1 1     0   18   131 112 0   5   14   131       0.0 243 201 0 22   1 1     0   18   131 112 0   5 14 131     0 243
619163 WA Jefferson   school 5301290 16049   Chimacum School District 530129002790 4552 Chimacum Creek Primary School   Regular School No Elementary KG 02 2017   kindergarten 62 0 8   0 0     0   8   41 37 0   2   8   41       0.0 78 62 0 8   0 0     0   8   41 37 0   2 8 41     0 78
619164 WA Jefferson   school 5301290 16049   Chimacum School District 530129002790 4552 Chimacum Creek Primary School   Regular School No Elementary KG 02 2017   pre_kindergarten 19 0 2   0 1     0   2   17 7 0   0   2   12       0.0 24 19 0 2   0 1     0   2   17 7 0   0 2 12     0 24
619596 WA Stevens   school 5301630 33115   Colville School District 530163000284 2957 Hofstetter Elementary   Regular School No Elementary KG 02 2017   grade_1 70 0 4   1 0     0   4   42 37 0   3   0   51       0.0 79 70 0 4   1 0     0   4   42 37 0   3 0 51     0 79
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
619598 WA Stevens   school 5301630 33115   Colville School District 530163000284 2957 Hofstetter Elementary   Regular School No Elementary KG 02 2017   pk_12_total 251 0 17   3 0     0   11   143 139 0   12   6   181       0.0 282 251 0 17   3 0     0   11   143 139 0   12 6 181     0 282
619599 WA Stevens   school 5301630 33115   Colville School District 530163000284 2957 Hofstetter Elementary   Regular School No Elementary KG 02 2017   kindergarten 70 0 1   0 0     0   4   33 42 0   4   3   52       0.0 75 70 0 1   0 0     0   4   33 42 0   4 3 52     0 75
619832 WA Spokane   school 5302070 32414   Deer Park School District 530207000307 2430 Deer Park Elementary   Regular School No Elementary KG 02 2017   grade_1 116 2 6   3 0     0   0   67 60 0   2   11   75       2.0 127 116 2 6   3 0     0   0   67 60 0   2 11 75     2 127
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
619834 WA Spokane   school 5302070 32414   Deer Park School District 530207000307 2430 Deer Park Elementary   Regular School No Elementary KG 02 2017   pk_12_total 374 5 23   7 0     1   1   214 197 0   6   31   248       4.0 411 374 5 23   7 0     1   1   214 197 0   6 31 248     4 411
619835 WA Spokane   school 5302070 32414   Deer Park School District 530207000307 2430 Deer Park Elementary   Regular School No Elementary KG 02 2017   kindergarten 135 2 5   4 0     0   1   78 69 0   4   11   89       1.0 147 135 2 5   4 0     0   1   78 69 0   4 11 89     1 147
621850 WA Snohomish   school 5303210 31332   Granite Falls School District 530321002303 4330 Mountain Way Elementary   Regular School No Elementary KG 02 2017   grade_1 117 1 16   3 0     0   2   71 68 0   8   8   73       0.0 139 117 1 16   3 0     0   2   71 68 0   8 8 73     0 139
621851 WA Snohomish   school 5303210 31332   Granite Falls School District 530321002303 4330 Mountain Way Elementary   Regular School No Elementary KG 02 2017   grade_2 105 2 16   3 1     0   9   74 62 0   6   7   69       1.0 136 105 2 16   3 1     0   9   74 62 0   6 7 69     1 136
621852 WA Snohomish   school 5303210 31332   Granite Falls School District 530321002303 4330 Mountain Way Elementary   Regular School No Elementary KG 02 2017   grade_4 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
621853 WA Snohomish   school 5303210 31332   Granite Falls School District 530321002303 4330 Mountain Way Elementary   Regular School No Elementary KG 02 2017   grade_5 0 0 1   0 0     0   0   1 0 0   0   0   0       0.0 1 0 0 1   0 0     0   0   1 0 0   0 0 0     0 1
621854 WA Snohomish   school 5303210 31332   Granite Falls School District 530321002303 4330 Mountain Way Elementary   Regular School No Elementary KG 02 2017   pk_12_total 299 5 49   7 1     0   15   205 171 0   15   29   211       1.0 376 299 5 49   7 1     0   15   205 171 0   15 29 211     1 376
621855 WA Snohomish   school 5303210 31332   Granite Falls School District 530321002303 4330 Mountain Way Elementary   Regular School No Elementary KG 02 2017   kindergarten 24 2 5   0 0     0   1   19 13 0   1   8   19       0.0 32 24 2 5   0 0     0   1   19 13 0   1 8 19     0 32
621856 WA Snohomish   school 5303210 31332   Granite Falls School District 530321002303 4330 Mountain Way Elementary   Regular School No Elementary KG 02 2017   pre_kindergarten 52 0 11   1 0     0   3   40 27 0   0   6   50       0.0 67 52 0 11   1 0     0   3   40 27 0   0 6 50     0 67
623096 WA Benton   school 5304020 3052   Kiona-Benton City School District 530402000641 2759 Kiona-Benton City Primary School   Regular School No Elementary PK 02 2017   grade_1 66 0 32   0 1     0   0   53 46 0   42   14   73       0.0 99 66 0 32   0 1     0   0   53 46 0   42 14 73     0 99
623097 WA Benton   school 5304020 3052   Kiona-Benton City School District 530402000641 2759 Kiona-Benton City Primary School   Regular School No Elementary PK 02 2017   grade_2 58 0 54   0 0     0   5   63 54 0   40   7   86       0.0 117 58 0 54   0 0     0   5   63 54 0   40 7 86     0 117
623098 WA Benton   school 5304020 3052   Kiona-Benton City School District 530402000641 2759 Kiona-Benton City Primary School   Regular School No Elementary PK 02 2017   pk_12_total 180 1 145   0 1     0   8   173 162 0   118   33   239       0.0 335 180 1 145   0 1     0   8   173 162 0   118 33 239     0 335
623099 WA Benton   school 5304020 3052   Kiona-Benton City School District 530402000641 2759 Kiona-Benton City Primary School   Regular School No Elementary PK 02 2017   kindergarten 49 1 46   0 0     0   2   45 53 0   36   11   67       0.0 98 49 1 46   0 0     0   2   45 53 0   36 11 67     0 98
623100 WA Benton   school 5304020 3052   Kiona-Benton City School District 530402000641 2759 Kiona-Benton City Primary School   Regular School No Elementary PK 02 2017   pre_kindergarten 7 0 13   0 0     0   1   12 9 0   0   1   13       0.0 21 7 0 13   0 0     0   1   12 9 0   0 1 13     0 21
624629 WA Grays Harbor   school 5305160 14066   Montesano School District 530516000779 3661 Beacon Avenue Elementary School   Regular School No Elementary KG 02 2017   grade_1 83 0 7   2 0     0   7   50 49 0   3   0   37       0.0 99 83 0 7   2 0     0   7   50 49 0   3 0 37     0 99
624630 WA Grays Harbor   school 5305160 14066   Montesano School District 530516000779 3661 Beacon Avenue Elementary School   Regular School No Elementary KG 02 2017   grade_2 77 0 12   2 0     0   12   53 50 0   2   1   42       1.0 103 77 0 12   2 0     0   12   53 50 0   2 1 42     1 103
624631 WA Grays Harbor   school 5305160 14066   Montesano School District 530516000779 3661 Beacon Avenue Elementary School   Regular School No Elementary KG 02 2017   pk_12_total 295 0 28   7 1     0   30   194 167 0   7   1   143       1.0 361 295 0 28   7 1     0   30   194 167 0   7 1 143     1 361
624632 WA Grays Harbor   school 5305160 14066   Montesano School District 530516000779 3661 Beacon Avenue Elementary School   Regular School No Elementary KG 02 2017   kindergarten 93 0 5   1 0     0   6   61 44 0   2   0   47       0.0 105 93 0 5   1 0     0   6   61 44 0   2 0 47     0 105
624633 WA Grays Harbor   school 5305160 14066   Montesano School District 530516000779 3661 Beacon Avenue Elementary School   Regular School No Elementary KG 02 2017   pre_kindergarten 42 0 4   2 1     0   5   30 24 0   0   0   17       0.0 54 42 0 4   2 1     0   5   30 24 0   0 0 17     0 54
626312 WA Okanogan   school 5306220 24019   Omak School District 530622000939 2999 N Omak Elementary   Regular School No Elementary PK 02 2017   grade_1 65 2 30   24 1     0   6   70 58 0   16   4   79       0.0 128 65 2 30   24 1     0   6   70 58 0   16 4 79     0 128
626313 WA Okanogan   school 5306220 24019   Omak School District 530622000939 2999 N Omak Elementary   Regular School No Elementary PK 02 2017   grade_2 44 0 37   27 2     0   12   57 65 0   17   4   89       1.0 122 44 0 37   27 2     0   12   57 65 0   17 4 89     1 122
626314 WA Okanogan   school 5306220 24019   Omak School District 530622000939 2999 N Omak Elementary   Regular School No Elementary PK 02 2017   pk_12_total 260 6 147   114 4     0   40   301 270 0   44   12   381       3.0 571 260 6 147   114 4     0   40   301 270 0   44 12 381     3 571
626315 WA Okanogan   school 5306220 24019   Omak School District 530622000939 2999 N Omak Elementary   Regular School No Elementary PK 02 2017   kindergarten_half_day 52 1 35   23 1     0   8   62 58 0   8   1   85       0.0 120 52 1 35   23 1     0   8   62 58 0   8 1 85     0 120
626316 WA Okanogan   school 5306220 24019   Omak School District 530622000939 2999 N Omak Elementary   Regular School No Elementary PK 02 2017   kindergarten 7 1 1   2 0     0   1   7 5 0   0   3   10       0.0 12 7 1 1   2 0     0   1   7 5 0   0 3 10     0 12
626317 WA Okanogan   school 5306220 24019   Omak School District 530622000939 2999 N Omak Elementary   Regular School No Elementary PK 02 2017   pre_kindergarten 92 2 44   38 0     0   13   105 84 0   3   0   118       2.0 189 92 2 44   38 0     0   13   105 84 0   3 0 118     2 189
626745 WA Franklin   school 5306570 11001   Pasco School District 530657002621 4526 Whittier Elementary   Regular School No Elementary KG 02 2017   grade_1 9 1 177   0 2     0   0   90 99 0   136   0   182       1.0 189 9 1 177   0 2     0   0   90 99 0   136 0 182     1 189
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
626747 WA Franklin   school 5306570 11001   Pasco School District 530657002621 4526 Whittier Elementary   Regular School No Elementary KG 02 2017   pk_12_total 25 2 571   0 3     0   6   294 313 0   462   1   574       3.0 607 25 2 571   0 3     0   6   294 313 0   462 1 574     3 607
626748 WA Franklin   school 5306570 11001   Pasco School District 530657002621 4526 Whittier Elementary   Regular School No Elementary KG 02 2017   kindergarten 10 1 188   0 0     0   5   112 92 0   168   0   185       1.0 204 10 1 188   0 0     0   5   112 92 0   168 0 185     1 204
626749 WA Franklin   school 5306570 11001   Pasco School District 530657002621 4526 Whittier Elementary   Regular School No Elementary KG 02 2017   pre_kindergarten 0 0 6   0 0     0   0   4 2 0   0   1   3       0.0 6 0 0 6   0 0     0   0   4 2 0   0 1 3     0 6
627053 WA Benton   school 5306900 3116   Prosser School District 530690001014 2195 Keene-Riverview Elementary   Regular School No Elementary PK 02 2017   grade_1 50 0 103   2 4     0   4   87 76 0   54   11   111       0.0 163 50 0 103   2 4     0   4   87 76 0   54 11 111     0 163
627054 WA Benton   school 5306900 3116   Prosser School District 530690001014 2195 Keene-Riverview Elementary   Regular School No Elementary PK 02 2017   grade_2 43 2 91   1 1     0   5   76 67 0   50   9   112       1.0 143 43 2 91   1 1     0   5   76 67 0   50 9 112     1 143
627055 WA Benton   school 5306900 3116   Prosser School District 530690001014 2195 Keene-Riverview Elementary   Regular School No Elementary PK 02 2017   pk_12_total 158 5 311   3 7     0   16   281 219 0   158   37   364       2.0 500 158 5 311   3 7     0   16   281 219 0   158 37 364     2 500
627056 WA Benton   school 5306900 3116   Prosser School District 530690001014 2195 Keene-Riverview Elementary   Regular School No Elementary PK 02 2017   kindergarten_half_day 0 0 2   0 0     0   0   2 0 0   1   0   2       0.0 2 0 0 2   0 0     0   0   2 0 0   1 0 2     0 2
627057 WA Benton   school 5306900 3116   Prosser School District 530690001014 2195 Keene-Riverview Elementary   Regular School No Elementary PK 02 2017   kindergarten 51 3 91   0 1     0   4   87 63 0   51   12   111       1.0 150 51 3 91   0 1     0   4   87 63 0   51 12 111     1 150
627058 WA Benton   school 5306900 3116   Prosser School District 530690001014 2195 Keene-Riverview Elementary   Regular School No Elementary PK 02 2017   pre_kindergarten 14 0 24   0 1     0   3   29 13 0   2   5   28       0.0 42 14 0 24   0 1     0   3   29 13 0   2 5 28     0 42
628082 WA Thurston   school 5307470 34401   Rochester School District 530747001117 2527 Rochester Primary School   Regular School No Elementary PK 02 2017   grade_1 81 0 34   3 0     1   9   67 61 0   23   8   77       1.0 128 81 0 34   3 0     1   9   67 61 0   23 8 77     1 128
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
628084 WA Thurston   school 5307470 34401   Rochester School District 530747001117 2527 Rochester Primary School   Regular School No Elementary PK 02 2017   pk_12_total 339 0 123   20 0     2   35   284 235 0   94   16   305       14.0 519 339 0 123   20 0     2   35   284 235 0   94 16 305     14 519
628085 WA Thurston   school 5307470 34401   Rochester School District 530747001117 2527 Rochester Primary School   Regular School No Elementary PK 02 2017   kindergarten_half_day 1 0 1   0 0     0   0   2 0 0   1   0   1       0.0 2 1 0 1   0 0     0   0   2 0 0   1 0 1     0 2
628086 WA Thurston   school 5307470 34401   Rochester School District 530747001117 2527 Rochester Primary School   Regular School No Elementary PK 02 2017   kindergarten 124 0 39   11 0     0   15   112 77 0   42   5   112       6.0 189 124 0 39   11 0     0   15   112 77 0   42 5 112     6 189
628087 WA Thurston   school 5307470 34401   Rochester School District 530747001117 2527 Rochester Primary School   Regular School No Elementary PK 02 2017   pre_kindergarten 24 0 5   0 0     0   1   14 16 0   0   0   14       0.0 30 24 0 5   0 0     0   1   14 16 0   0 0 14     0 30
628964 WA Yakima   school 5307770 39119   Selah School District 530777003513 5383 John Campbell Primary School   Regular School No Elementary KG 02 2017   grade_1 189 1 75   3 0     1   6   145 130 0   47   3   168       0.0 275 189 1 75   3 0     1   6   145 130 0   47 3 168     0 275
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
628966 WA Yakima   school 5307770 39119   Selah School District 530777003513 5383 John Campbell Primary School   Regular School No Elementary KG 02 2017   pk_12_total 561 5 229   6 1     1   27   434 396 0   115   4   469       1.0 830 561 5 229   6 1     1   27   434 396 0   115 4 469     1 830
628967 WA Yakima   school 5307770 39119   Selah School District 530777003513 5383 John Campbell Primary School   Regular School No Elementary KG 02 2017   kindergarten_half_day 0 0 1   0 0     0   0   1 0 0   0   0   0       0.0 1 0 0 1   0 0     0   0   1 0 0   0 0 0     0 1
628968 WA Yakima   school 5307770 39119   Selah School District 530777003513 5383 John Campbell Primary School   Regular School No Elementary KG 02 2017   kindergarten 201 2 71   1 0     0   7   157 125 0   31   1   143       1.0 282 201 2 71   1 0     0   7   157 125 0   31 1 143     1 282
629299 WA Snohomish   school 5308020 31201   Snohomish School District 530802001323 2446 Central Elementary   Regular School No Elementary PK 02 2017   grade_1 33 0 12   0 0     0   5   24 26 0   7   0   25       0.0 50 33 0 12   0 0     0   5   24 26 0   7 0 25     0 50
629300 WA Snohomish   school 5308020 31201   Snohomish School District 530802001323 2446 Central Elementary   Regular School No Elementary PK 02 2017   grade_2 44 0 18   0 0     1   5   35 33 0   9   3   33       3.0 68 44 0 18   0 0     1   5   35 33 0   9 3 33     3 68
629301 WA Snohomish   school 5308020 31201   Snohomish School District 530802001323 2446 Central Elementary   Regular School No Elementary PK 02 2017   pk_12_total 211 4 71   0 3     3   22   164 150 0   25   5   158       6.0 314 211 4 71   0 3     3   22   164 150 0   25 5 158     6 314
629302 WA Snohomish   school 5308020 31201   Snohomish School District 530802001323 2446 Central Elementary   Regular School No Elementary PK 02 2017   kindergarten 48 0 12   0 0     2   2   26 38 0   9   2   32       3.0 64 48 0 12   0 0     2   2   26 38 0   9 2 32     3 64
629303 WA Snohomish   school 5308020 31201   Snohomish School District 530802001323 2446 Central Elementary   Regular School No Elementary PK 02 2017   pre_kindergarten 86 4 29   0 3     0   10   79 53 0   0   0   68       0.0 132 86 4 29   0 3     0   10   79 53 0   0 0 68     0 132
630349 WA Skamania   school 5308520 30303   Stevenson-Carson School District 530852001435 2682 Stevenson Elementary   Regular School No Elementary KG 02 2017   grade_1 57 0 7   1 0     0   4   33 36 0   2   6   34       2.0 69 57 0 7   1 0     0   4   33 36 0   2 6 34     2 69
630350 WA Skamania   school 5308520 30303   Stevenson-Carson School District 530852001435 2682 Stevenson Elementary   Regular School No Elementary KG 02 2017   grade_2 54 1 10   0 0     0   6   37 34 0   1   5   39       3.0 71 54 1 10   0 0     0   6   37 34 0   1 5 39     3 71
630351 WA Skamania   school 5308520 30303   Stevenson-Carson School District 530852001435 2682 Stevenson Elementary   Regular School No Elementary KG 02 2017   pk_12_total 171 3 25   1 0     0   13   105 108 0   5   15   110       5.0 213 171 3 25   1 0     0   13   105 108 0   5 15 110     5 213
630352 WA Skamania   school 5308520 30303   Stevenson-Carson School District 530852001435 2682 Stevenson Elementary   Regular School No Elementary KG 02 2017   kindergarten 60 2 8   0 0     0   3   35 38 0   2   4   37       0.0 73 60 2 8   0 0     0   3   35 38 0   2 4 37     0 73
631048 WA Thurston   school 5308820 34402   Tenino School District 530882001524 2457 Parkside Elementary   Regular School No Elementary KG 02 2017   grade_1 72 1 12   1 0     0   6   61 31 0   3   5   52       0.0 92 72 1 12   1 0     0   6   61 31 0   3 5 52     0 92
631049 WA Thurston   school 5308820 34402   Tenino School District 530882001524 2457 Parkside Elementary   Regular School No Elementary KG 02 2017   grade_2 80 0 11   1 0     0   5   57 40 0   0   5   52       0.0 97 80 0 11   1 0     0   5   57 40 0   0 5 52     0 97
631050 WA Thurston   school 5308820 34402   Tenino School District 530882001524 2457 Parkside Elementary   Regular School No Elementary KG 02 2017   pk_12_total 280 1 34   4 1     0   19   200 139 0   4   15   182       0.0 339 280 1 34   4 1     0   19   200 139 0   4 15 182     0 339
631051 WA Thurston   school 5308820 34402   Tenino School District 530882001524 2457 Parkside Elementary   Regular School No Elementary KG 02 2017   kindergarten 99 0 8   2 1     0   8   63 55 0   1   5   63       0.0 118 99 0 8   2 1     0   8   63 55 0   1 5 63     0 118
631052 WA Thurston   school 5308820 34402   Tenino School District 530882001524 2457 Parkside Elementary   Regular School No Elementary KG 02 2017   pre_kindergarten 29 0 3   0 0     0   0   19 13 0   0   0   15       0.0 32 29 0 3   0 0     0   0   19 13 0   0 0 15     0 32
618262 WA Whatcom   school 5300570 37503   Blaine School District 530057001740 4459 Point Roberts Primary   Regular School No Elementary KG 03 2017   grade_1 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
618263 WA Whatcom   school 5300570 37503   Blaine School District 530057001740 4459 Point Roberts Primary   Regular School No Elementary KG 03 2017   grade_2 3 0 1   0 0     0   1   0 5 0   0   0   3       0.0 5 3 0 1   0 0     0   1   0 5 0   0 0 3     0 5
618264 WA Whatcom   school 5300570 37503   Blaine School District 530057001740 4459 Point Roberts Primary   Regular School No Elementary KG 03 2017   grade_3 4 0 0   0 0     0   0   1 3 0   0   0   0       1.0 4 4 0 0   0 0     0   0   1 3 0   0 0 0     1 4
618265 WA Whatcom   school 5300570 37503   Blaine School District 530057001740 4459 Point Roberts Primary   Regular School No Elementary KG 03 2017   pk_12_total 12 0 1   0 0     0   1   5 9 0   0   0   4       1.0 14 12 0 1   0 0     0   1   5 9 0   0 0 4     1 14
618266 WA Whatcom   school 5300570 37503   Blaine School District 530057001740 4459 Point Roberts Primary   Regular School No Elementary KG 03 2017   kindergarten 3 0 0   0 0     0   0   2 1 0   0   0   1       0.0 3 3 0 0   0 0     0   0   2 1 0   0 0 1     0 3

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