Data source: Big Local News · About: Big Local

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

View and edit SQL

grade

year

  • 2017 · 15,758
Link rowid state county county_state_id admin_level district_nces_id district_state_id district_state_type district school_nces_id school_state_id school ▲ school_state_type ccd_school_type ccd_charter_school ccd_school_lvl ccd_school_low_grade ccd_school_high_grade year term grade white black hispanic native_american native_american_alaskan_native asian native_hawaiian asian_pacific_islander native_hawaiian_pacific_islander pacific_islander multiracial unknown_race male female non_binary unknown_gender ell ell_percent homeless homeless_percent low_income free_and_reduced free_and_reduced_percent disability section_504 total white_int black_int hispanic_int native_american_int native_american_alaskan_native_int asian_int native_hawaiian_int asian_pacific_islander_int native_hawaiian_pacific_islander_int pacific_islander_int multiracial_int unknown_race_int male_int female_int non_binary_int unknown_gender_int ell_int homeless_int low_income_int free_and_reduced_int disability_int section_504_int total_int
621058 WA Clark   school 5302700 6114   Evergreen School District (Clark) 530270002710 1801 iQ Academy Washington (Closed after 2016-2017 school year)   Alternative School No High 07 12 2017   grade_10 24 0 3   0 0     0   1   8 20 0   1   0   11       0.0 28 24 0 3   0 0     0   1   8 20 0   1 0 11     0 28
621059 WA Clark   school 5302700 6114   Evergreen School District (Clark) 530270002710 1801 iQ Academy Washington (Closed after 2016-2017 school year)   Alternative School No High 07 12 2017   grade_11 18 1 3   0 0     0   0   9 13 0   0   0   7       0.0 22 18 1 3   0 0     0   0   9 13 0   0 0 7     0 22
621060 WA Clark   school 5302700 6114   Evergreen School District (Clark) 530270002710 1801 iQ Academy Washington (Closed after 2016-2017 school year)   Alternative School No High 07 12 2017   grade_12 21 0 4   1 1     0   2   12 17 0   0   0   14       2.0 29 21 0 4   1 1     0   2   12 17 0   0 0 14     2 29
621061 WA Clark   school 5302700 6114   Evergreen School District (Clark) 530270002710 1801 iQ Academy Washington (Closed after 2016-2017 school year)   Alternative School No High 07 12 2017   grade_9 7 0 0   0 0     0   0   5 2 0   1   0   4       0.0 7 7 0 0   0 0     0   0   5 2 0   1 0 4     0 7
621062 WA Clark   school 5302700 6114   Evergreen School District (Clark) 530270002710 1801 iQ Academy Washington (Closed after 2016-2017 school year)   Alternative School No High 07 12 2017   pk_12_total 70 1 10   1 1     0   3   34 52 0   2   0   36       2.0 86 70 1 10   1 1     0   3   34 52 0   2 0 36     2 86
625968 WA Island   school 5305940 15201   Oak Harbor School District 530594003474 5343 iGrad Academy   Alternative School No High 09 12 2017   grade_11 2 0 1   0 0     0   0   2 1 0   0   0   1       1.0 3 2 0 1   0 0     0   0   2 1 0   0 0 1     1 3
625969 WA Island   school 5305940 15201   Oak Harbor School District 530594003474 5343 iGrad Academy   Alternative School No High 09 12 2017   grade_12 4 0 1   0 0     0   0   2 3 0   1   0   4       0.0 5 4 0 1   0 0     0   0   2 3 0   1 0 4     0 5
625970 WA Island   school 5305940 15201   Oak Harbor School District 530594003474 5343 iGrad Academy   Alternative School No High 09 12 2017   pk_12_total 6 0 2   0 0     0   0   4 4 0   1   0   5       1.0 8 6 0 2   0 0     0   0   4 4 0   1 0 5     1 8
632795 WA Yakima   school 5310170 39205   Zillah School District 531017002502 4481 Zillah Middle School   Regular School No Middle 07 08 2017   grade_6 0 0 1   0 0     0   0   0 1 0   1   0   1       0.0 1 0 0 1   0 0     0   0   0 1 0   1 0 1     0 1
632796 WA Yakima   school 5310170 39205   Zillah School District 531017002502 4481 Zillah Middle School   Regular School No Middle 07 08 2017   grade_7 45 0 56   7 0     0   5   69 44 0   14   2   71       2.0 113 45 0 56   7 0     0   5   69 44 0   14 2 71     2 113
632797 WA Yakima   school 5310170 39205   Zillah School District 531017002502 4481 Zillah Middle School   Regular School No Middle 07 08 2017   grade_8 50 0 64   7 1     0   3   71 54 0   11   3   74       2.0 125 50 0 64   7 1     0   3   71 54 0   11 3 74     2 125
632798 WA Yakima   school 5310170 39205   Zillah School District 531017002502 4481 Zillah Middle School   Regular School No Middle 07 08 2017   pk_12_total 95 0 121   14 1     0   8   140 99 0   26   5   146       4.0 239 95 0 121   14 1     0   8   140 99 0   26 5 146     4 239
632791 WA Yakima   school 5310170 39205   Zillah School District 531017001896 4221 Zillah Intermediate School   Regular School No Elementary 04 06 2017   grade_4 32 0 52   5 1     0   4   50 44 0   11   1   62       0.0 94 32 0 52   5 1     0   4   50 44 0   11 1 62     0 94
632792 WA Yakima   school 5310170 39205   Zillah School District 531017001896 4221 Zillah Intermediate School   Regular School No Elementary 04 06 2017   grade_5 41 1 58   5 0     0   5   65 45 0   12   1   70       1.0 110 41 1 58   5 0     0   5   65 45 0   12 1 70     1 110
632793 WA Yakima   school 5310170 39205   Zillah School District 531017001896 4221 Zillah Intermediate School   Regular School No Elementary 04 06 2017   grade_6 36 0 49   3 0     0   2   53 37 0   13   0   57       1.0 90 36 0 49   3 0     0   2   53 37 0   13 0 57     1 90
632794 WA Yakima   school 5310170 39205   Zillah School District 531017001896 4221 Zillah Intermediate School   Regular School No Elementary 04 06 2017   pk_12_total 109 1 159   13 1     0   11   168 126 0   36   2   189       2.0 294 109 1 159   13 1     0   11   168 126 0   36 2 189     2 294
632786 WA Yakima   school 5310170 39205   Zillah School District 531017001719 2240 Zillah High School   Regular School No High 09 12 2017   grade_10 60 0 46   4 0     0   4   64 50 0   7   2   62       5.0 114 60 0 46   4 0     0   4   64 50 0   7 2 62     5 114
632787 WA Yakima   school 5310170 39205   Zillah School District 531017001719 2240 Zillah High School   Regular School No High 09 12 2017   grade_11 51 0 47   3 0     0   0   46 55 0   4   2   52       0.0 101 51 0 47   3 0     0   0   46 55 0   4 2 52     0 101
632788 WA Yakima   school 5310170 39205   Zillah School District 531017001719 2240 Zillah High School   Regular School No High 09 12 2017   grade_12 56 1 48   5 1     1   2   55 59 0   10   3   49       1.0 114 56 1 48   5 1     1   2   55 59 0   10 3 49     1 114
632789 WA Yakima   school 5310170 39205   Zillah School District 531017001719 2240 Zillah High School   Regular School No High 09 12 2017   grade_9 41 0 57   4 0     0   4   66 40 0   4   3   64       5.0 106 41 0 57   4 0     0   4   66 40 0   4 3 64     5 106
632790 WA Yakima   school 5310170 39205   Zillah School District 531017001719 2240 Zillah High School   Regular School No High 09 12 2017   pk_12_total 208 1 198   16 1     1   10   231 204 0   25   10   227       11.0 435 208 1 198   16 1     1   10   231 204 0   25 10 227     11 435
624626 WA Snohomish   school 5305130 31103   Monroe School District 530513003468 1883 Youth Re-Engagement   Alternative School No High 09 12 2017   grade_11 77 4 11   1 0     0   0   48 45 0   0   0   8       0.0 93 77 4 11   1 0     0   0   48 45 0   0 0 8     0 93
624627 WA Snohomish   school 5305130 31103   Monroe School District 530513003468 1883 Youth Re-Engagement   Alternative School No High 09 12 2017   grade_12 113 7 16   3 0     1   0   74 66 0   0   0   2       0.0 140 113 7 16   3 0     1   0   74 66 0   0 0 2     0 140
624628 WA Snohomish   school 5305130 31103   Monroe School District 530513003468 1883 Youth Re-Engagement   Alternative School No High 09 12 2017   pk_12_total 190 11 27   4 0     1   0   122 111 0   0   0   10       0.0 233 190 11 27   4 0     1   0   122 111 0   0 0 10     0 233
621158 WA Clark   school 5302700 6114   Evergreen School District (Clark) 530270003159 4579 York Elementary School   Regular School No Elementary PK 05 2017   grade_1 62 0 13   1 6     0   7   39 50 0   17   2   38       1.0 89 62 0 13   1 6     0   7   39 50 0   17 2 38     1 89
621159 WA Clark   school 5302700 6114   Evergreen School District (Clark) 530270003159 4579 York Elementary School   Regular School No Elementary PK 05 2017   grade_2 58 2 16   0 1     1   8   41 45 0   9   2   33       2.0 86 58 2 16   0 1     1   8   41 45 0   9 2 33     2 86
621160 WA Clark   school 5302700 6114   Evergreen School District (Clark) 530270003159 4579 York Elementary School   Regular School No Elementary PK 05 2017   grade_3 67 2 14   0 4     0   9   46 50 0   15   5   35       1.0 96 67 2 14   0 4     0   9   46 50 0   15 5 35     1 96
621161 WA Clark   school 5302700 6114   Evergreen School District (Clark) 530270003159 4579 York Elementary School   Regular School No Elementary PK 05 2017   grade_4 60 0 19   0 5     0   4   50 38 0   14   4   40       0.0 88 60 0 19   0 5     0   4   50 38 0   14 4 40     0 88
621162 WA Clark   school 5302700 6114   Evergreen School District (Clark) 530270003159 4579 York Elementary School   Regular School No Elementary PK 05 2017   grade_5 66 3 15   1 3     0   6   51 43 0   11   2   41       3.0 94 66 3 15   1 3     0   6   51 43 0   11 2 41     3 94
621163 WA Clark   school 5302700 6114   Evergreen School District (Clark) 530270003159 4579 York Elementary School   Regular School No Elementary PK 05 2017   pk_12_total 368 7 93   2 22     2   44   273 265 0   84   20   231       8.0 538 368 7 93   2 22     2   44   273 265 0   84 20 231     8 538
621164 WA Clark   school 5302700 6114   Evergreen School District (Clark) 530270003159 4579 York Elementary School   Regular School No Elementary PK 05 2017   kindergarten 54 0 16   0 3     1   10   46 38 0   18   5   44       1.0 84 54 0 16   0 3     1   10   46 38 0   18 5 44     1 84
621165 WA Clark   school 5302700 6114   Evergreen School District (Clark) 530270003159 4579 York Elementary School   Regular School No Elementary PK 05 2017   pre_kindergarten 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
632770 WA Thurston   school 5310140 34002   Yelm School District 531014001916 4224 Yelm Prairie Elementary   Regular School No Elementary PK 06 2017   grade_1 51 1 11   1 0     0   7   33 38 0   3   0   33       0.0 71 51 1 11   1 0     0   7   33 38 0   3 0 33     0 71
632771 WA Thurston   school 5310140 34002   Yelm School District 531014001916 4224 Yelm Prairie Elementary   Regular School No Elementary PK 06 2017   grade_2 47 1 16   1 0     0   6   38 33 0   5   0   34       1.0 71 47 1 16   1 0     0   6   38 33 0   5 0 34     1 71
632772 WA Thurston   school 5310140 34002   Yelm School District 531014001916 4224 Yelm Prairie Elementary   Regular School No Elementary PK 06 2017   grade_3 56 0 10   2 1     0   7   47 29 0   8   1   34       0.0 76 56 0 10   2 1     0   7   47 29 0   8 1 34     0 76
632773 WA Thurston   school 5310140 34002   Yelm School District 531014001916 4224 Yelm Prairie Elementary   Regular School No Elementary PK 06 2017   grade_4 61 1 16   2 0     0   5   55 30 0   7   0   41       2.0 85 61 1 16   2 0     0   5   55 30 0   7 0 41     2 85
632774 WA Thurston   school 5310140 34002   Yelm School District 531014001916 4224 Yelm Prairie Elementary   Regular School No Elementary PK 06 2017   grade_5 57 0 10   2 2     0   8   36 43 0   3   2   28       4.0 79 57 0 10   2 2     0   8   36 43 0   3 2 28     4 79
632775 WA Thurston   school 5310140 34002   Yelm School District 531014001916 4224 Yelm Prairie Elementary   Regular School No Elementary PK 06 2017   grade_6 55 0 13   2 0     0   10   42 38 0   2   0   33       5.0 80 55 0 13   2 0     0   10   42 38 0   2 0 33     5 80
632776 WA Thurston   school 5310140 34002   Yelm School District 531014001916 4224 Yelm Prairie Elementary   Regular School No Elementary PK 06 2017   pk_12_total 399 4 98   11 4     0   53   319 250 0   38   4   244       13.0 569 399 4 98   11 4     0   53   319 250 0   38 4 244     13 569
632777 WA Thurston   school 5310140 34002   Yelm School District 531014001916 4224 Yelm Prairie Elementary   Regular School No Elementary PK 06 2017   kindergarten 38 0 15   1 0     0   4   34 24 0   10   0   26       1.0 58 38 0 15   1 0     0   4   34 24 0   10 0 26     1 58
632778 WA Thurston   school 5310140 34002   Yelm School District 531014001916 4224 Yelm Prairie Elementary   Regular School No Elementary PK 06 2017   pre_kindergarten 34 1 7   0 1     0   6   34 15 0   0   1   15       0.0 49 34 1 7   0 1     0   6   34 15 0   0 1 15     0 49
632766 WA Thurston   school 5310140 34002   Yelm School District 531014001717 2481 Yelm Middle School   Regular School No Other 07 09 2017   grade_7 152 1 32   2 1     3   24   114 101 0   4   4   110       13.0 215 152 1 32   2 1     3   24   114 101 0   4 4 110     13 215
632767 WA Thurston   school 5310140 34002   Yelm School District 531014001717 2481 Yelm Middle School   Regular School No Other 07 09 2017   grade_8 154 7 34   5 5     1   25   112 119 0   5   5   121       17.0 231 154 7 34   5 5     1   25   112 119 0   5 5 121     17 231
632768 WA Thurston   school 5310140 34002   Yelm School District 531014001717 2481 Yelm Middle School   Regular School No Other 07 09 2017   grade_9 169 8 38   2 3     4   25   106 143 0   1   7   122       18.0 249 169 8 38   2 3     4   25   106 143 0   1 7 122     18 249
632769 WA Thurston   school 5310140 34002   Yelm School District 531014001717 2481 Yelm Middle School   Regular School No Other 07 09 2017   pk_12_total 475 16 104   9 9     8   74   332 363 0   10   16   353       48.0 695 475 16 104   9 9     8   74   332 363 0   10 16 353     48 695
632762 WA Thurston   school 5310140 34002   Yelm School District 531014001716 2633 Yelm High School 12   Regular School No High 10 12 2017   grade_10 311 3 45   6 5     5   51   205 221 0   3   2   175       23.0 426 311 3 45   6 5     5   51   205 221 0   3 2 175     23 426
632763 WA Thurston   school 5310140 34002   Yelm School District 531014001716 2633 Yelm High School 12   Regular School No High 10 12 2017   grade_11 270 16 48   1 8     6   35   195 189 0   4   1   156       20.0 384 270 16 48   1 8     6   35   195 189 0   4 1 156     20 384
632764 WA Thurston   school 5310140 34002   Yelm School District 531014001716 2633 Yelm High School 12   Regular School No High 10 12 2017   grade_12 312 4 62   4 8     5   31   224 202 0   3   9   155       11.0 426 312 4 62   4 8     5   31   224 202 0   3 9 155     11 426
632765 WA Thurston   school 5310140 34002   Yelm School District 531014001716 2633 Yelm High School 12   Regular School No High 10 12 2017   pk_12_total 893 23 155   11 21     16   117   624 612 0   10   12   486       54.0 1236 893 23 155   11 21     16   117   624 612 0   10 12 486     54 1236
632756 WA Thurston   school 5310140 34002   Yelm School District 531014000134 1627 Yelm Extension School   Alternative School No High 09 12 2017   grade_10 6 0 4   0 0     0   1   4 7 0   0   0   6       1.0 11 6 0 4   0 0     0   1   4 7 0   0 0 6     1 11
632757 WA Thurston   school 5310140 34002   Yelm School District 531014000134 1627 Yelm Extension School   Alternative School No High 09 12 2017   grade_11 21 1 2   1 0     0   0   12 13 0   0   0   11       0.0 25 21 1 2   1 0     0   0   12 13 0   0 0 11     0 25
632758 WA Thurston   school 5310140 34002   Yelm School District 531014000134 1627 Yelm Extension School   Alternative School No High 09 12 2017   grade_12 76 1 6   1 0     0   10   44 50 0   0   0   56       1.0 94 76 1 6   1 0     0   10   44 50 0   0 0 56     1 94
632759 WA Thurston   school 5310140 34002   Yelm School District 531014000134 1627 Yelm Extension School   Alternative School No High 09 12 2017   grade_8 0 0 0   0 0     0   1   1 0 0   0   0   0       0.0 1 0 0 0   0 0     0   1   1 0 0   0 0 0     0 1
632760 WA Thurston   school 5310140 34002   Yelm School District 531014000134 1627 Yelm Extension School   Alternative School No High 09 12 2017   grade_9 2 0 0   0 0     0   0   0 2 0   0   0   1       0.0 2 2 0 0   0 0     0   0   0 2 0   0 0 1     0 2
632761 WA Thurston   school 5310140 34002   Yelm School District 531014000134 1627 Yelm Extension School   Alternative School No High 09 12 2017   pk_12_total 105 2 12   2 0     0   12   61 72 0   0   0   74       2.0 133 105 2 12   2 0     0   12   61 72 0   0 0 74     2 133
632526 WA Cowlitz   school 5310050 8404   Woodland School District 531005001684 3513 Yale Elementary   Regular School No Elementary KG 05 2017   grade_1 8 0 0   0 0     0   0   5 3 0   0   0   3       0.0 8 8 0 0   0 0     0   0   5 3 0   0 0 3     0 8
632527 WA Cowlitz   school 5310050 8404   Woodland School District 531005001684 3513 Yale Elementary   Regular School No Elementary KG 05 2017   grade_2 8 0 1   0 0     0   0   6 3 0   0   0   2       0.0 9 8 0 1   0 0     0   0   6 3 0   0 0 2     0 9
632528 WA Cowlitz   school 5310050 8404   Woodland School District 531005001684 3513 Yale Elementary   Regular School No Elementary KG 05 2017   grade_3 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
632529 WA Cowlitz   school 5310050 8404   Woodland School District 531005001684 3513 Yale Elementary   Regular School No Elementary KG 05 2017   grade_4 5 0 0   0 0     0   0   5 0 0   0   0   2       1.0 5 5 0 0   0 0     0   0   5 0 0   0 0 2     1 5
632530 WA Cowlitz   school 5310050 8404   Woodland School District 531005001684 3513 Yale Elementary   Regular School No Elementary KG 05 2017   grade_5 1 0 0   0 0     0   0   0 1 0   0   0   1       0.0 1 1 0 0   0 0     0   0   0 1 0   0 0 1     0 1
632531 WA Cowlitz   school 5310050 8404   Woodland School District 531005001684 3513 Yale Elementary   Regular School No Elementary KG 05 2017   pk_12_total 31 0 2   1 0     0   1   21 14 0   0   0   10       1.0 35 31 0 2   1 0     0   1   21 14 0   0 0 10     1 35
632532 WA Cowlitz   school 5310050 8404   Woodland School District 531005001684 3513 Yale Elementary   Regular School No Elementary KG 05 2017   kindergarten 8 0 0   1 0     0   1   4 6 0   0   0   1       0.0 10 8 0 0   1 0     0   1   4 6 0   0 0 1     0 10
632296 WA Yakima   school 5309720 39208   West Valley School District (Yakima) 530972003173 5096 Yakima Valley Memorial Hospital dba Children's Village   Special Education School No Elementary PK PK 2017   pk_12_total 17 0 6   1 0     0   0   18 6 0   0   0   0       0.0 24 17 0 6   1 0     0   0   18 6 0   0 0 0     0 24
632297 WA Yakima   school 5309720 39208   West Valley School District (Yakima) 530972003173 5096 Yakima Valley Memorial Hospital dba Children's Village   Special Education School No Elementary PK PK 2017   pre_kindergarten 17 0 6   1 0     0   0   18 6 0   0   0   0       0.0 24 17 0 6   1 0     0   0   18 6 0   0 0 0     0 24
632701 WA Yakima   school 5310110 39007   Yakima School District 531011003324 5224 Yakima Satellite Alternative Programs   Alternative School No High 08 12 2017   grade_10 1 0 3   0 0     0   0   1 3 0   1   0   3       0.0 4 1 0 3   0 0     0   0   1 3 0   1 0 3     0 4
632702 WA Yakima   school 5310110 39007   Yakima School District 531011003324 5224 Yakima Satellite Alternative Programs   Alternative School No High 08 12 2017   grade_11 4 1 3   0 0     0   0   3 5 0   1   0   6       4.0 8 4 1 3   0 0     0   0   3 5 0   1 0 6     4 8
632703 WA Yakima   school 5310110 39007   Yakima School District 531011003324 5224 Yakima Satellite Alternative Programs   Alternative School No High 08 12 2017   grade_12 11 0 13   0 1     0   0   12 13 0   6   0   14       2.0 25 11 0 13   0 1     0   0   12 13 0   6 0 14     2 25
632704 WA Yakima   school 5310110 39007   Yakima School District 531011003324 5224 Yakima Satellite Alternative Programs   Alternative School No High 08 12 2017   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
632705 WA Yakima   school 5310110 39007   Yakima School District 531011003324 5224 Yakima Satellite Alternative Programs   Alternative School No High 08 12 2017   pk_12_total 18 1 20   0 1     0   0   18 22 0   8   0   25       6.0 40 18 1 20   0 1     0   0   18 22 0   8 0 25     6 40
632697 WA Yakima   school 5310110 39007   Yakima School District 531011003487 5355 Yakima Open Doors   Alternative School No High 09 12 2017   grade_10 1 0 2   0 0     0   0   2 1 0   1   1   3       0.0 3 1 0 2   0 0     0   0   2 1 0   1 1 3     0 3
632698 WA Yakima   school 5310110 39007   Yakima School District 531011003487 5355 Yakima Open Doors   Alternative School No High 09 12 2017   grade_11 2 0 7   0 0     0   1   5 5 0   3   0   8       1.0 10 2 0 7   0 0     0   1   5 5 0   3 0 8     1 10
632699 WA Yakima   school 5310110 39007   Yakima School District 531011003487 5355 Yakima Open Doors   Alternative School No High 09 12 2017   grade_12 18 1 73   2 0     1   2   43 54 0   28   1   71       2.0 97 18 1 73   2 0     1   2   43 54 0   28 1 71     2 97
632700 WA Yakima   school 5310110 39007   Yakima School District 531011003487 5355 Yakima Open Doors   Alternative School No High 09 12 2017   pk_12_total 21 1 82   2 0     1   3   50 60 0   32   2   82       3.0 110 21 1 82   2 0     1   3   50 60 0   32 2 82     3 110
632690 WA Yakima   school 5310110 39007   Yakima School District 531011003263 5153 Yakima Online   Alternative School No Other 06 12 2017   grade_10 3 0 5   0 0     0   1   5 4 0   0   1   5       0.0 9 3 0 5   0 0     0   1   5 4 0   0 1 5     0 9
632691 WA Yakima   school 5310110 39007   Yakima School District 531011003263 5153 Yakima Online   Alternative School No Other 06 12 2017   grade_11 10 1 17   1 0     0   1   10 20 0   2   0   17       1.0 30 10 1 17   1 0     0   1   10 20 0   2 0 17     1 30
632692 WA Yakima   school 5310110 39007   Yakima School District 531011003263 5153 Yakima Online   Alternative School No Other 06 12 2017   grade_12 20 0 15   0 0     0   1   16 20 0   1   1   24       4.0 36 20 0 15   0 0     0   1   16 20 0   1 1 24     4 36
632693 WA Yakima   school 5310110 39007   Yakima School District 531011003263 5153 Yakima Online   Alternative School No Other 06 12 2017   grade_7 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
632694 WA Yakima   school 5310110 39007   Yakima School District 531011003263 5153 Yakima Online   Alternative School No Other 06 12 2017   grade_8 1 0 2   0 0     0   1   1 3 0   0   0   3       1.0 4 1 0 2   0 0     0   1   1 3 0   0 0 3     1 4
632695 WA Yakima   school 5310110 39007   Yakima School District 531011003263 5153 Yakima Online   Alternative School No Other 06 12 2017   grade_9 6 0 2   0 0     0   0   4 4 0   0   1   7       1.0 8 6 0 2   0 0     0   0   4 4 0   0 1 7     1 8
632696 WA Yakima   school 5310110 39007   Yakima School District 531011003263 5153 Yakima Online   Alternative School No Other 06 12 2017   pk_12_total 41 1 42   1 0     0   4   37 52 0   3   3   57       7.0 89 41 1 42   1 0     0   4   37 52 0   3 3 57     7 89
617626 WA Clark   school 5300380 6119   Battle Ground School District 530038000056 2910 Yacolt Primary   Regular School No Elementary PK 04 2017   grade_1 159 0 3   1 1     0   5   95 74 0   1   1   74       0.0 169 159 0 3   1 1     0   5   95 74 0   1 1 74     0 169
617627 WA Clark   school 5300380 6119   Battle Ground School District 530038000056 2910 Yacolt Primary   Regular School No Elementary PK 04 2017   grade_2 142 0 2   0 0     0   2   78 68 0   1   4   69       3.0 146 142 0 2   0 0     0   2   78 68 0   1 4 69     3 146
617628 WA Clark   school 5300380 6119   Battle Ground School District 530038000056 2910 Yacolt Primary   Regular School No Elementary PK 04 2017   grade_3 168 0 4   0 0     0   5   97 80 0   2   3   86       2.0 177 168 0 4   0 0     0   5   97 80 0   2 3 86     2 177
617629 WA Clark   school 5300380 6119   Battle Ground School District 530038000056 2910 Yacolt Primary   Regular School No Elementary PK 04 2017   grade_4 148 0 6   0 0     0   1   83 72 0   0   2   59       0.0 155 148 0 6   0 0     0   1   83 72 0   0 2 59     0 155
617630 WA Clark   school 5300380 6119   Battle Ground School District 530038000056 2910 Yacolt Primary   Regular School No Elementary PK 04 2017   pk_12_total 809 0 20   2 2     0   21   453 401 0   5   14   364       6.0 854 809 0 20   2 2     0   21   453 401 0   5 14 364     6 854
617631 WA Clark   school 5300380 6119   Battle Ground School District 530038000056 2910 Yacolt Primary   Regular School No Elementary PK 04 2017   kindergarten 146 0 4   1 1     0   6   73 85 0   1   3   61       1.0 158 146 0 4   1 1     0   6   73 85 0   1 3 61     1 158
617632 WA Clark   school 5300380 6119   Battle Ground School District 530038000056 2910 Yacolt Primary   Regular School No Elementary PK 04 2017   pre_kindergarten 46 0 1   0 0     0   2   27 22 0   0   1   15       0.0 49 46 0 1   0 0     0   2   27 22 0   0 1 15     0 49
621154 WA Clark   school 5302700 6114   Evergreen School District (Clark) 530270000428 4051 Wyeast Middle School   Regular School No Middle 06 08 2017   grade_6 137 10 93   1 8     4   35   161 127 0   50   14   183       6.0 288 137 10 93   1 8     4   35   161 127 0   50 14 183     6 288
621155 WA Clark   school 5302700 6114   Evergreen School District (Clark) 530270000428 4051 Wyeast Middle School   Regular School No Middle 06 08 2017   grade_7 143 6 106   3 7     7   14   140 146 0   44   10   180       5.0 286 143 6 106   3 7     7   14   140 146 0   44 10 180     5 286
621156 WA Clark   school 5302700 6114   Evergreen School District (Clark) 530270000428 4051 Wyeast Middle School   Regular School No Middle 06 08 2017   grade_8 156 10 83   6 8     5   23   164 127 0   20   10   168       7.0 291 156 10 83   6 8     5   23   164 127 0   20 10 168     7 291
621157 WA Clark   school 5302700 6114   Evergreen School District (Clark) 530270000428 4051 Wyeast Middle School   Regular School No Middle 06 08 2017   pk_12_total 436 26 282   10 23     16   72   465 400 0   114   34   531       18.0 865 436 26 282   10 23     16   72   465 400 0   114 34 531     18 865
617495 WA Kitsap   school 5300330 18303   Bainbridge Island School District 530033002452 4505 Woodward Middle School   Regular School No Middle 07 08 2017   grade_6 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
617496 WA Kitsap   school 5300330 18303   Bainbridge Island School District 530033002452 4505 Woodward Middle School   Regular School No Middle 07 08 2017   grade_7 243 3 26   2 8     1   20   139 164 0   4   3   33       21.0 303 243 3 26   2 8     1   20   139 164 0   4 3 33     21 303
617497 WA Kitsap   school 5300330 18303   Bainbridge Island School District 530033002452 4505 Woodward Middle School   Regular School No Middle 07 08 2017   grade_8 228 0 32   1 13     0   26   163 137 0   3   2   26       45.0 300 228 0 32   1 13     0   26   163 137 0   3 2 26     45 300
617498 WA Kitsap   school 5300330 18303   Bainbridge Island School District 530033002452 4505 Woodward Middle School   Regular School No Middle 07 08 2017   pk_12_total 472 3 58   3 21     1   46   302 302 0   7   5   59       66.0 604 472 3 58   3 21     1   46   302 302 0   7 5 59     66 604
620901 WA Snohomish   school 5302670 31002   Everett School District 530267001792 4125 Woodside Elementary   Regular School No Elementary PK 05 2017   grade_1 58 2 27   0 14     1   13   57 58 0   40   1   33       0.0 115 58 2 27   0 14     1   13   57 58 0   40 1 33     0 115
620902 WA Snohomish   school 5302670 31002   Everett School District 530267001792 4125 Woodside Elementary   Regular School No Elementary PK 05 2017   grade_2 45 4 30   0 11     2   9   58 43 0   32   2   41       1.0 101 45 4 30   0 11     2   9   58 43 0   32 2 41     1 101
620903 WA Snohomish   school 5302670 31002   Everett School District 530267001792 4125 Woodside Elementary   Regular School No Elementary PK 05 2017   grade_3 54 0 29   0 15     0   22   59 61 0   21   2   42       1.0 120 54 0 29   0 15     0   22   59 61 0   21 2 42     1 120
620904 WA Snohomish   school 5302670 31002   Everett School District 530267001792 4125 Woodside Elementary   Regular School No Elementary PK 05 2017   grade_4 57 2 35   0 10     0   10   61 53 0   22   4   47       0.0 114 57 2 35   0 10     0   10   61 53 0   22 4 47     0 114
620905 WA Snohomish   school 5302670 31002   Everett School District 530267001792 4125 Woodside Elementary   Regular School No Elementary PK 05 2017   grade_5 44 3 37   0 15     1   6   51 55 0   11   1   44       2.0 106 44 3 37   0 15     1   6   51 55 0   11 1 44     2 106

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