Data source: Big Local News · About: Big Local

109,573 rows where state = "WA" sorted by native_hawaiian_pacific_islander_int

View and edit SQL

grade

year

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
461634 WA Spokane   school 5301110 32356   Central Valley School District 530111000203 3064 University Elementary School   Regular School No 1.0 PK 05 2015   grade_4 39 0 2   0 0     0   4   24 21 0   2   2   31       1.0 45 39 0 2   0 0     0   4   24 21 0   2 2 31     1 45
461635 WA Spokane   school 5301110 32356   Central Valley School District 530111000203 3064 University Elementary School   Regular School No 1.0 PK 05 2015   grade_5 45 0 3   0 0     0   2   37 13 0   2   2   29       4.0 50 45 0 3   0 0     0   2   37 13 0   2 2 29     4 50
461636 WA Spokane   school 5301110 32356   Central Valley School District 530111000203 3064 University Elementary School   Regular School No 1.0 PK 05 2015   pk_12_total 242 7 18   1 2     0   11   166 115 0   10   8   166       9.0 281 242 7 18   1 2     0   11   166 115 0   10 8 166     9 281
461637 WA Spokane   school 5301110 32356   Central Valley School District 530111000203 3064 University Elementary School   Regular School No 1.0 PK 05 2015   kindergarten_half_day 1 0 0   0 0     0   0   1 0 0   0   0   1       0.0 1 1 0 0   0 0     0   0   1 0 0   0 0 1     0 1
461638 WA Spokane   school 5301110 32356   Central Valley School District 530111000203 3064 University Elementary School   Regular School No 1.0 PK 05 2015   kindergarten 34 1 5   0 0     0   3   19 24 0   1   0   23       0.0 43 34 1 5   0 0     0   3   19 24 0   1 0 23     0 43
461639 WA Spokane   school 5301110 32356   Central Valley School District 530111000204 3415 University High School   Regular School No 3.0 09 12 2015   grade_10 372 9 31   2 4     0   31   248 201 0   1   10   213       23.0 449 372 9 31   2 4     0   31   248 201 0   1 10 213     23 449
461646 WA Lewis   school 5301140 21401   Centralia School District 530114000206 2166 Centralia High School   Regular School No 3.0 09 12 2015   grade_12 166 4 55   3 3     0   10   120 121 0   7   7   137       6.0 241 166 4 55   3 3     0   10   120 121 0   7 7 137     6 241
461649 WA Lewis   school 5301140 21401   Centralia School District 530114000205 3240 Centralia Middle School   Regular School No 4.0 05 12 2015   grade_6 1 0 0   0 0     0   0   1 0 0   0   0   0       0.0 1 1 0 0   0 0     0   0   1 0 0   0 0 0     0 1
461651 WA Lewis   school 5301140 21401   Centralia School District 530114000205 3240 Centralia Middle School   Regular School No 4.0 05 12 2015   grade_8 165 3 85   3 0     0   9   139 126 0   13   8   193       2.0 265 165 3 85   3 0     0   9   139 126 0   13 8 193     2 265
461653 WA Lewis   school 5301140 21401   Centralia School District 530114000207 2244 Edison Elementary   Regular School No 1.0 KG 03 2015   grade_1 48 1 23   0 1     0   3   40 36 0   16   5   62       0.0 76 48 1 23   0 1     0   3   40 36 0   16 5 62     0 76
461654 WA Lewis   school 5301140 21401   Centralia School District 530114000207 2244 Edison Elementary   Regular School No 1.0 KG 03 2015   grade_2 45 0 38   0 0     0   7   40 50 0   21   8   74       0.0 90 45 0 38   0 0     0   7   40 50 0   21 8 74     0 90
461657 WA Lewis   school 5301140 21401   Centralia School District 530114000207 2244 Edison Elementary   Regular School No 1.0 KG 03 2015   kindergarten 48 0 32   0 3     0   7   45 45 0   12   7   74       0.0 90 48 0 32   0 3     0   7   45 45 0   12 7 74     0 90
461658 WA Lewis   school 5301140 21401   Centralia School District 530114000208 2704 Fords Prairie Elementary   Regular School No 1.0 KG 03 2015   grade_1 56 2 32   0 0     0   7   49 48 0   9   2   77       0.0 97 56 2 32   0 0     0   7   49 48 0   9 2 77     0 97
461659 WA Lewis   school 5301140 21401   Centralia School District 530114000208 2704 Fords Prairie Elementary   Regular School No 1.0 KG 03 2015   grade_2 52 0 27   1 0     0   4   35 49 0   15   2   71       0.0 84 52 0 27   1 0     0   4   35 49 0   15 2 71     0 84
461660 WA Lewis   school 5301140 21401   Centralia School District 530114000208 2704 Fords Prairie Elementary   Regular School No 1.0 KG 03 2015   grade_3 53 0 30   1 0     0   4   47 41 0   8   3   71       2.0 88 53 0 30   1 0     0   4   47 41 0   8 3 71     2 88
461661 WA Lewis   school 5301140 21401   Centralia School District 530114000208 2704 Fords Prairie Elementary   Regular School No 1.0 KG 03 2015   pk_12_total 224 2 131   3 1     0   18   195 184 0   48   10   307       2.0 379 224 2 131   3 1     0   18   195 184 0   48 10 307     2 379
461662 WA Lewis   school 5301140 21401   Centralia School District 530114000208 2704 Fords Prairie Elementary   Regular School No 1.0 KG 03 2015   kindergarten_half_day 2 0 4   0 0     0   0   5 1 0   0   0   5       0.0 6 2 0 4   0 0     0   0   5 1 0   0 0 5     0 6
461663 WA Lewis   school 5301140 21401   Centralia School District 530114000208 2704 Fords Prairie Elementary   Regular School No 1.0 KG 03 2015   kindergarten 61 0 38   1 1     0   3   59 45 0   16   3   83       0.0 104 61 0 38   1 1     0   3   59 45 0   16 3 83     0 104
461664 WA Lewis   school 5301140 21401   Centralia School District 530114003492 5359 Futurus High School   Alternative Education School No 3.0 09 12 2015   grade_10 5 0 2   0 0     0   0   2 5 0   0   0   6       0.0 7 5 0 2   0 0     0   0   2 5 0   0 0 6     0 7
461665 WA Lewis   school 5301140 21401   Centralia School District 530114003492 5359 Futurus High School   Alternative Education School No 3.0 09 12 2015   grade_11 21 1 3   0 0     0   1   15 11 0   0   4   20       1.0 26 21 1 3   0 0     0   1   15 11 0   0 4 20     1 26
461668 WA Lewis   school 5301140 21401   Centralia School District 530114000209 3172 Jefferson Lincoln Elementary   Regular School No 1.0 PK 03 2015   grade_1 56 1 40   0 0     0   4   46 55 0   18   1   96       0.0 101 56 1 40   0 0     0   4   46 55 0   18 1 96     0 101
461669 WA Lewis   school 5301140 21401   Centralia School District 530114000209 3172 Jefferson Lincoln Elementary   Regular School No 1.0 PK 03 2015   grade_2 54 0 38   0 1     0   5   45 53 0   19   5   89       0.0 98 54 0 38   0 1     0   5   45 53 0   19 5 89     0 98
461670 WA Lewis   school 5301140 21401   Centralia School District 530114000209 3172 Jefferson Lincoln Elementary   Regular School No 1.0 PK 03 2015   grade_3 65 0 39   0 0     0   3   53 54 0   16   2   93       1.0 107 65 0 39   0 0     0   3   53 54 0   16 2 93     1 107
461673 WA Lewis   school 5301140 21401   Centralia School District 530114000209 3172 Jefferson Lincoln Elementary   Regular School No 1.0 PK 03 2015   kindergarten 15 0 4   0 0     0   0   11 8 0   0   1   15       0.0 19 15 0 4   0 0     0   0   11 8 0   0 1 15     0 19
461674 WA Lewis   school 5301140 21401   Centralia School District 530114000209 3172 Jefferson Lincoln Elementary   Regular School No 1.0 PK 03 2015   pre_kindergarten 74 1 18   1 0     0   0   64 30 0   0   0   64       0.0 94 74 1 18   1 0     0   0   64 30 0   0 0 64     0 94
461675 WA Lewis   school 5301140 21401   Centralia School District 530114000210 2291 Oakview Elementary School   Regular School No 2.0 04 06 2015   grade_4 74 2 47   0 0     0   4   66 61 0   19   8   98       0.0 127 74 2 47   0 0     0   4   66 61 0   19 8 98     0 127
461677 WA Lewis   school 5301140 21401   Centralia School District 530114000210 2291 Oakview Elementary School   Regular School No 2.0 04 06 2015   grade_6 78 3 37   2 0     0   4   67 57 0   7   5   99       0.0 124 78 3 37   2 0     0   4   67 57 0   7 5 99     0 124
461679 WA Lewis   school 5301140 21401   Centralia School District 530114000211 2768 Washington Elementary School   Regular School No 1.0 KG 06 2015   grade_1 1 0 0   0 0     0   0   1 0 0   0   0   1       0.0 1 1 0 0   0 0     0   0   1 0 0   0 0 1     0 1
461680 WA Lewis   school 5301140 21401   Centralia School District 530114000211 2768 Washington Elementary School   Regular School No 1.0 KG 06 2015   grade_2 0 0 1   0 0     0   0   1 0 0   0   0   1       0.0 1 0 0 1   0 0     0   0   1 0 0   0 0 1     0 1
461681 WA Lewis   school 5301140 21401   Centralia School District 530114000211 2768 Washington Elementary School   Regular School No 1.0 KG 06 2015   grade_3 2 1 0   0 0     0   0   2 1 0   0   0   3       0.0 3 2 1 0   0 0     0   0   2 1 0   0 0 3     0 3
461683 WA Lewis   school 5301140 21401   Centralia School District 530114000211 2768 Washington Elementary School   Regular School No 1.0 KG 06 2015   grade_5 63 1 39   0 0     0   1   48 56 0   4   0   89       0.0 104 63 1 39   0 0     0   1   48 56 0   4 0 89     0 104
461688 WA Lewis   school 5301170 21302   Chehalis School District 530117000212 2274 Cascade Elementary School (Closed after 2017-2018 school year)   Regular School No 1.0 PK 01 2015   kindergarten_half_day 1 0 1   0 0     0   0   2 0 0   0   0   1       0.0 2 1 0 1   0 0     0   0   2 0 0   0 0 1     0 2
461689 WA Lewis   school 5301170 21302   Chehalis School District 530117000212 2274 Cascade Elementary School (Closed after 2017-2018 school year)   Regular School No 1.0 PK 01 2015   kindergarten 143 1 34   0 1     0   6   94 91 0   0   17   114       0.0 185 143 1 34   0 1     0   6   94 91 0   0 17 114     0 185
461690 WA Lewis   school 5301170 21302   Chehalis School District 530117000212 2274 Cascade Elementary School (Closed after 2017-2018 school year)   Regular School No 1.0 PK 01 2015   pre_kindergarten 12 0 3   0 0     0   1   12 4 0   0   1   12       0.0 16 12 0 3   0 0     0   1   12 4 0   0 1 12     0 16
461691 WA Lewis   school 5301170 21302   Chehalis School District 530117002252 4311 Chehalis Middle School   Regular School No 2.0 06 08 2015   grade_6 152 2 37   2 0     0   10   99 104 0   6   17   99       1.0 203 152 2 37   2 0     0   10   99 104 0   6 17 99     1 203
461692 WA Lewis   school 5301170 21302   Chehalis School District 530117002252 4311 Chehalis Middle School   Regular School No 2.0 06 08 2015   grade_7 176 2 28   0 7     0   11   102 122 0   9   11   124       0.0 224 176 2 28   0 7     0   11   102 122 0   9 11 124     0 224
461693 WA Lewis   school 5301170 21302   Chehalis School District 530117002252 4311 Chehalis Middle School   Regular School No 2.0 06 08 2015   grade_8 166 3 28   1 4     0   11   109 104 0   4   9   107       0.0 213 166 3 28   1 4     0   11   109 104 0   4 9 107     0 213
461694 WA Lewis   school 5301170 21302   Chehalis School District 530117002252 4311 Chehalis Middle School   Regular School No 2.0 06 08 2015   pk_12_total 494 7 93   3 11     0   32   310 330 0   19   37   330       1.0 640 494 7 93   3 11     0   32   310 330 0   19 37 330     1 640
461695 WA Lewis   school 5301170 21302   Chehalis School District 530117000213 2027 Green Hill Academic School   Alternative Education School No 3.0 09 12 2015   grade_10 3 0 3   0 0     0   3   9 0 0   1   0   5       0.0 9 3 0 3   0 0     0   3   9 0 0   1 0 5     0 9
461696 WA Lewis   school 5301170 21302   Chehalis School District 530117000213 2027 Green Hill Academic School   Alternative Education School No 3.0 09 12 2015   grade_11 26 10 24   3 0     0   13   76 0 0   6   0   21       0.0 76 26 10 24   3 0     0   13   76 0 0   6 0 21     0 76
461697 WA Lewis   school 5301170 21302   Chehalis School District 530117000213 2027 Green Hill Academic School   Alternative Education School No 3.0 09 12 2015   grade_12 21 25 30   4 3     0   21   104 0 0   6   0   23       0.0 104 21 25 30   4 3     0   21   104 0 0   6 0 23     0 104
461698 WA Lewis   school 5301170 21302   Chehalis School District 530117000213 2027 Green Hill Academic School   Alternative Education School No 3.0 09 12 2015   pk_12_total 50 35 57   7 3     0   37   189 0 0   13   0   49       0.0 189 50 35 57   7 3     0   37   189 0 0   13 0 49     0 189
461699 WA Lewis   school 5301170 21302   Chehalis School District 530117002883 1559 Lewis County Juvenile Detention   Alternative Education School No 4.0 05 12 2015   grade_10 2 0 0   0 0     0   0   1 1 0   0   0   2       0.0 2 2 0 0   0 0     0   0   1 1 0   0 0 2     0 2
461700 WA Lewis   school 5301170 21302   Chehalis School District 530117002883 1559 Lewis County Juvenile Detention   Alternative Education School No 4.0 05 12 2015   grade_11 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
461701 WA Lewis   school 5301170 21302   Chehalis School District 530117002883 1559 Lewis County Juvenile Detention   Alternative Education School No 4.0 05 12 2015   grade_12 2 1 1   0 0     0   0   4 0 0   0   0   2       0.0 4 2 1 1   0 0     0   0   4 0 0   0 0 2     0 4
461702 WA Lewis   school 5301170 21302   Chehalis School District 530117002883 1559 Lewis County Juvenile Detention   Alternative Education School No 4.0 05 12 2015   grade_7 0 0 1   0 0     0   0   0 1 0   0   0   0       0.0 1 0 0 1   0 0     0   0   0 1 0   0 0 0     0 1
461703 WA Lewis   school 5301170 21302   Chehalis School District 530117002883 1559 Lewis County Juvenile Detention   Alternative Education School No 4.0 05 12 2015   grade_8 2 0 1   0 0     0   0   3 0 0   0   0   1       0.0 3 2 0 1   0 0     0   0   3 0 0   0 0 1     0 3
461704 WA Lewis   school 5301170 21302   Chehalis School District 530117002883 1559 Lewis County Juvenile Detention   Alternative Education School No 4.0 05 12 2015   pk_12_total 6 1 4   0 0     0   0   9 2 0   0   0   5       0.0 11 6 1 4   0 0     0   0   9 2 0   0 0 5     0 11
461705 WA Lewis   school 5301170 21302   Chehalis School District 530117000214 3346 Olympic Elementary (Closed after 2017-2018 school year)   Regular School No 2.0 04 05 2015   grade_4 145 1 37   1 2     0   15   108 93 0   14   21   128       0.0 201 145 1 37   1 2     0   15   108 93 0   14 21 128     0 201
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
461709 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_3 138 0 36   0 0     0   9   103 80 0   12   17   112       0.0 183 138 0 36   0 0     0   9   103 80 0   12 17 112     0 183
461710 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   pk_12_total 277 0 72   0 2     0   19   207 163 0   32   28   232       0.0 370 277 0 72   0 2     0   19   207 163 0   32 28 232     0 370
461711 WA Lewis   school 5301170 21302   Chehalis School District 530117000217 2799 W F West High School   Regular School No 3.0 09 12 2015   grade_10 183 0 39   3 4     0   12   114 127 0   0   11   109       5.0 241 183 0 39   3 4     0   12   114 127 0   0 11 109     5 241
461712 WA Lewis   school 5301170 21302   Chehalis School District 530117000217 2799 W F West High School   Regular School No 3.0 09 12 2015   grade_11 212 4 29   4 6     0   8   134 129 0   1   10   111       7.0 263 212 4 29   4 6     0   8   134 129 0   1 10 111     7 263
461713 WA Lewis   school 5301170 21302   Chehalis School District 530117000217 2799 W F West High School   Regular School No 3.0 09 12 2015   grade_12 176 3 37   0 4     0   17   118 119 0   0   15   102       5.0 237 176 3 37   0 4     0   17   118 119 0   0 15 102     5 237
461714 WA Lewis   school 5301170 21302   Chehalis School District 530117000217 2799 W F West High School   Regular School No 3.0 09 12 2015   grade_9 181 0 32   1 3     0   14   111 120 0   5   3   105       2.0 231 181 0 32   1 3     0   14   111 120 0   5 3 105     2 231
461715 WA Lewis   school 5301170 21302   Chehalis School District 530117000217 2799 W F West High School   Regular School No 3.0 09 12 2015   pk_12_total 752 7 137   8 17     0   51   477 495 0   6   39   427       19.0 972 752 7 137   8 17     0   51   477 495 0   6 39 427     19 972
461716 WA Spokane   school 5301230 32360   Cheney School District 530123000221 2954 Betz Elementary   Regular School No 1.0 KG 05 2015   grade_1 47 2 22   0 1     0   2   44 30 0   6   1   48       0.0 74 47 2 22   0 1     0   2   44 30 0   6 1 48     0 74
461718 WA Spokane   school 5301230 32360   Cheney School District 530123000221 2954 Betz Elementary   Regular School No 1.0 KG 05 2015   grade_3 48 3 8   0 2     0   2   25 38 0   5   1   34       3.0 63 48 3 8   0 2     0   2   25 38 0   5 1 34     3 63
461719 WA Spokane   school 5301230 32360   Cheney School District 530123000221 2954 Betz Elementary   Regular School No 1.0 KG 05 2015   grade_4 59 1 6   0 0     0   3   38 31 0   2   2   38       4.0 69 59 1 6   0 0     0   3   38 31 0   2 2 38     4 69
461720 WA Spokane   school 5301230 32360   Cheney School District 530123000221 2954 Betz Elementary   Regular School No 1.0 KG 05 2015   grade_5 46 0 10   0 2     0   5   33 30 0   3   0   29       5.0 63 46 0 10   0 2     0   5   33 30 0   3 0 29     5 63
461722 WA Spokane   school 5301230 32360   Cheney School District 530123000221 2954 Betz Elementary   Regular School No 1.0 KG 05 2015   kindergarten_half_day 20 0 3   0 1     0   0   10 14 0   1   0   7       0.0 24 20 0 3   0 1     0   0   10 14 0   1 0 7     0 24
461723 WA Spokane   school 5301230 32360   Cheney School District 530123000221 2954 Betz Elementary   Regular School No 1.0 KG 05 2015   kindergarten 32 1 4   2 2     0   1   27 15 0   3   1   33       0.0 42 32 1 4   2 2     0   1   27 15 0   3 1 33     0 42
461724 WA Spokane   school 5301230 32360   Cheney School District 530123000221 2954 Betz Elementary   Regular School No 1.0 KG 05 2015   pre_kindergarten 17 1 6   0 0     0   2   15 11 0   0   1   19       0.0 26 17 1 6   0 0     0   2   15 11 0   0 1 19     0 26
461725 WA Spokane   school 5301230 32360   Cheney School District 530123003218 5126 Birth To Three   Special Education School No 1.0 PK PK 2015   pk_12_total 31 1 2   2 1     0   2   24 15 0   0   0   12       0.0 39 31 1 2   2 1     0   2   24 15 0   0 0 12     0 39
461726 WA Spokane   school 5301230 32360   Cheney School District 530123003218 5126 Birth To Three   Special Education School No 1.0 PK PK 2015   pre_kindergarten 31 1 2   2 1     0   2   24 15 0   0   0   12       0.0 39 31 1 2   2 1     0   2   24 15 0   0 0 12     0 39
461727 WA Spokane   school 5301230 32360   Cheney School District 530123000223 3610 Cheney High School   Regular School No 3.0 09 12 2015   grade_10 234 6 28   5 9     0   19   154 147 0   2   6   135       10.0 301 234 6 28   5 9     0   19   154 147 0   2 6 135     10 301
461732 WA Spokane   school 5301230 32360   Cheney School District 530123000224 2447 Cheney Middle School   Regular School No 2.0 06 08 2015   grade_6 107 1 20   6 3     0   12   81 68 0   3   3   80       7.0 149 107 1 20   6 3     0   12   81 68 0   3 3 80     7 149
461733 WA Spokane   school 5301230 32360   Cheney School District 530123000224 2447 Cheney Middle School   Regular School No 2.0 06 08 2015   grade_7 132 0 14   3 2     0   18   84 85 0   1   5   90       4.0 169 132 0 14   3 2     0   18   84 85 0   1 5 90     4 169
461736 WA Spokane   school 5301230 32360   Cheney School District 530123003014 5035 HomeWorks   Alternative Education School No 4.0 KG 12 2015   grade_1 12 0 0   0 0     0   0   10 2 0   2   0   1       0.0 12 12 0 0   0 0     0   0   10 2 0   2 0 1     0 12
461737 WA Spokane   school 5301230 32360   Cheney School District 530123003014 5035 HomeWorks   Alternative Education School No 4.0 KG 12 2015   grade_2 13 0 1   0 0     0   0   6 8 0   0   0   5       0.0 14 13 0 1   0 0     0   0   6 8 0   0 0 5     0 14
461738 WA Spokane   school 5301230 32360   Cheney School District 530123003014 5035 HomeWorks   Alternative Education School No 4.0 KG 12 2015   grade_3 4 0 1   0 0     0   0   3 2 0   0   0   0       0.0 5 4 0 1   0 0     0   0   3 2 0   0 0 0     0 5
461739 WA Spokane   school 5301230 32360   Cheney School District 530123003014 5035 HomeWorks   Alternative Education School No 4.0 KG 12 2015   grade_4 13 0 0   0 0     0   0   3 10 0   0   0   3       0.0 13 13 0 0   0 0     0   0   3 10 0   0 0 3     0 13
461740 WA Spokane   school 5301230 32360   Cheney School District 530123003014 5035 HomeWorks   Alternative Education School No 4.0 KG 12 2015   grade_5 11 0 0   0 0     0   0   6 5 0   0   0   3       0.0 11 11 0 0   0 0     0   0   6 5 0   0 0 3     0 11
461741 WA Spokane   school 5301230 32360   Cheney School District 530123003014 5035 HomeWorks   Alternative Education School No 4.0 KG 12 2015   grade_6 4 0 1   0 0     0   0   2 3 0   0   0   0       0.0 5 4 0 1   0 0     0   0   2 3 0   0 0 0     0 5
461742 WA Spokane   school 5301230 32360   Cheney School District 530123003014 5035 HomeWorks   Alternative Education School No 4.0 KG 12 2015   grade_7 3 0 0   0 0     0   0   1 2 0   0   0   0       0.0 3 3 0 0   0 0     0   0   1 2 0   0 0 0     0 3
461743 WA Spokane   school 5301230 32360   Cheney School District 530123003014 5035 HomeWorks   Alternative Education School No 4.0 KG 12 2015   grade_8 1 0 1   0 0     0   0   1 1 0   0   0   1       0.0 2 1 0 1   0 0     0   0   1 1 0   0 0 1     0 2
461744 WA Spokane   school 5301230 32360   Cheney School District 530123003014 5035 HomeWorks   Alternative Education School No 4.0 KG 12 2015   pk_12_total 71 1 4   0 0     0   0   37 39 0   3   0   15       0.0 76 71 1 4   0 0     0   0   37 39 0   3 0 15     0 76
461745 WA Spokane   school 5301230 32360   Cheney School District 530123003014 5035 HomeWorks   Alternative Education School No 4.0 KG 12 2015   kindergarten_half_day 10 1 0   0 0     0   0   5 6 0   1   0   2       0.0 11 10 1 0   0 0     0   0   5 6 0   1 0 2     0 11
461746 WA Spokane   school 5301230 32360   Cheney School District 530123003413 5294 Phil Snowdon Elementary   Regular School No 1.0 PK 05 2015   grade_1 55 3 2   1 0     0   8   40 29 0   0   5   36       1.0 69 55 3 2   1 0     0   8   40 29 0   0 5 36     1 69
461749 WA Spokane   school 5301230 32360   Cheney School District 530123003413 5294 Phil Snowdon Elementary   Regular School No 1.0 PK 05 2015   grade_4 54 4 5   1 1     0   6   32 39 0   1   0   37       7.0 71 54 4 5   1 1     0   6   32 39 0   1 0 37     7 71
461754 WA Spokane   school 5301230 32360   Cheney School District 530123003413 5294 Phil Snowdon Elementary   Regular School No 1.0 PK 05 2015   pre_kindergarten 31 0 2   0 1     0   1   25 10 0   0   0   13       0.0 35 31 0 2   0 1     0   1   25 10 0   0 0 13     0 35
461755 WA Spokane   school 5301230 32360   Cheney School District 530123000226 3761 Salnave Elementary   Regular School No 1.0 KG 05 2015   grade_1 56 1 8   0 0     0   2   31 36 0   0   5   46       2.0 67 56 1 8   0 0     0   2   31 36 0   0 5 46     2 67
461756 WA Spokane   school 5301230 32360   Cheney School District 530123000226 3761 Salnave Elementary   Regular School No 1.0 KG 05 2015   grade_2 57 0 6   0 2     0   3   39 29 0   6   5   41       1.0 68 57 0 6   0 2     0   3   39 29 0   6 5 41     1 68
461757 WA Spokane   school 5301230 32360   Cheney School District 530123000226 3761 Salnave Elementary   Regular School No 1.0 KG 05 2015   grade_3 56 2 6   1 0     0   6   32 39 0   3   5   46       3.0 71 56 2 6   1 0     0   6   32 39 0   3 5 46     3 71
461758 WA Spokane   school 5301230 32360   Cheney School District 530123000226 3761 Salnave Elementary   Regular School No 1.0 KG 05 2015   grade_4 49 0 7   1 2     0   3   42 20 0   3   2   35       3.0 62 49 0 7   1 2     0   3   42 20 0   3 2 35     3 62
461759 WA Spokane   school 5301230 32360   Cheney School District 530123000226 3761 Salnave Elementary   Regular School No 1.0 KG 05 2015   grade_5 45 1 3   1 0     0   3   33 20 0   2   3   30       1.0 53 45 1 3   1 0     0   3   33 20 0   2 3 30     1 53
461767 WA Spokane   school 5301230 32360   Cheney School District 530123000227 2814 Sunset Elementary   Regular School No 1.0 PK 05 2015   grade_5 34 2 10   2 2     0   4   27 27 0   2   0   38       0.0 54 34 2 10   2 2     0   4   27 27 0   2 0 38     0 54
461769 WA Spokane   school 5301230 32360   Cheney School District 530123000227 2814 Sunset Elementary   Regular School No 1.0 PK 05 2015   kindergarten_half_day 3 0 0   0 0     0   0   2 1 0   0   0   2       0.0 3 3 0 0   0 0     0   0   2 1 0   0 0 2     0 3
461771 WA Spokane   school 5301230 32360   Cheney School District 530123000227 2814 Sunset Elementary   Regular School No 1.0 PK 05 2015   pre_kindergarten 16 1 4   1 2     0   3   16 11 0   0   2   19       0.0 27 16 1 4   1 2     0   3   16 11 0   0 2 19     0 27
461772 WA Spokane   school 5301230 32360   Cheney School District 530123002684 1769 Three Springs High School   Alternative Education School No 3.0 09 12 2015   grade_10 7 0 0   1 0     0   0   6 2 0   0   1   6       1.0 8 7 0 0   1 0     0   0   6 2 0   0 1 6     1 8
461773 WA Spokane   school 5301230 32360   Cheney School District 530123002684 1769 Three Springs High School   Alternative Education School No 3.0 09 12 2015   grade_11 22 1 2   0 0     0   3   12 16 0   0   0   22       1.0 28 22 1 2   0 0     0   3   12 16 0   0 0 22     1 28
461774 WA Spokane   school 5301230 32360   Cheney School District 530123002684 1769 Three Springs High School   Alternative Education School No 3.0 09 12 2015   grade_12 8 0 3   0 0     0   1   5 7 0   0   1   10       0.0 12 8 0 3   0 0     0   1   5 7 0   0 1 10     0 12
461775 WA Spokane   school 5301230 32360   Cheney School District 530123002684 1769 Three Springs High School   Alternative Education School No 3.0 09 12 2015   grade_9 2 0 1   0 0     0   0   2 1 0   0   0   2       0.0 3 2 0 1   0 0     0   0   2 1 0   0 0 2     0 3
461776 WA Spokane   school 5301230 32360   Cheney School District 530123002684 1769 Three Springs High School   Alternative Education School No 3.0 09 12 2015   pk_12_total 39 1 6   1 0     0   4   25 26 0   0   2   40       2.0 51 39 1 6   1 0     0   4   25 26 0   0 2 40     2 51
461777 WA Spokane   school 5301230 32360   Cheney School District 530123003428 5269 Westwood Middle School   Regular School No 2.0 06 08 2015   grade_6 132 6 9   3 2     0   12   86 78 0   4   9   90       3.0 164 132 6 9   3 2     0   12   86 78 0   4 9 90     3 164
461779 WA Spokane   school 5301230 32360   Cheney School District 530123003428 5269 Westwood Middle School   Regular School No 2.0 06 08 2015   grade_8 125 0 12   2 6     0   9   79 75 0   1   4   84       8.0 154 125 0 12   2 6     0   9   79 75 0   1 4 84     8 154
461781 WA Spokane   school 5301230 32360   Cheney School District 530123000228 3309 Windsor Elementary   Regular School No 1.0 PK 05 2015   grade_1 57 2 7   0 1     0   7   39 35 0   5   1   37       0.0 74 57 2 7   0 1     0   7   39 35 0   5 1 37     0 74
461782 WA Spokane   school 5301230 32360   Cheney School District 530123000228 3309 Windsor Elementary   Regular School No 1.0 PK 05 2015   grade_2 64 0 3   2 0     0   6   41 34 0   4   2   39       1.0 75 64 0 3   2 0     0   6   41 34 0   4 2 39     1 75
461783 WA Spokane   school 5301230 32360   Cheney School District 530123000228 3309 Windsor Elementary   Regular School No 1.0 PK 05 2015   grade_3 57 2 7   1 3     0   2   43 29 0   9   3   31       0.0 72 57 2 7   1 3     0   2   43 29 0   9 3 31     0 72

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