Data source: Big Local News · About: Big Local

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

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
628152 WA King   school 5307710 17001   Seattle School District No. 1 530771001127 2138 Adams Elementary School   Regular School No Elementary KG 05 2017   grade_1 82 2 10   0 3     0   11   56 52 0   5   4   20       3.0 108 82 2 10   0 3     0   11   56 52 0   5 4 20     3 108
628153 WA King   school 5307710 17001   Seattle School District No. 1 530771001127 2138 Adams Elementary School   Regular School No Elementary KG 05 2017   grade_2 65 5 7   1 1     0   12   50 41 0   7   5   17       1.0 91 65 5 7   1 1     0   12   50 41 0   7 5 17     1 91
628154 WA King   school 5307710 17001   Seattle School District No. 1 530771001127 2138 Adams Elementary School   Regular School No Elementary KG 05 2017   grade_3 61 4 15   0 2     0   10   47 45 0   9   2   15       3.0 92 61 4 15   0 2     0   10   47 45 0   9 2 15     3 92
628155 WA King   school 5307710 17001   Seattle School District No. 1 530771001127 2138 Adams Elementary School   Regular School No Elementary KG 05 2017   grade_4 68 5 5   0 4     1   8   54 37 0   7   2   14       6.0 91 68 5 5   0 4     1   8   54 37 0   7 2 14     6 91
628156 WA King   school 5307710 17001   Seattle School District No. 1 530771001127 2138 Adams Elementary School   Regular School No Elementary KG 05 2017   grade_5 63 6 13   1 1     0   11   44 51 0   7   1   18       5.0 95 63 6 13   1 1     0   11   44 51 0   7 1 18     5 95
628157 WA King   school 5307710 17001   Seattle School District No. 1 530771001127 2138 Adams Elementary School   Regular School No Elementary KG 05 2017   pk_12_total 409 25 59   3 11     1   64   301 271 0   40   14   91       18.0 572 409 25 59   3 11     1   64   301 271 0   40 14 91     18 572
628158 WA King   school 5307710 17001   Seattle School District No. 1 530771001127 2138 Adams Elementary School   Regular School No Elementary KG 05 2017   kindergarten 70 3 9   1 0     0   12   50 45 0   5   0   7       0.0 95 70 3 9   1 0     0   12   50 45 0   5 0 7     0 95
632533 WA Yakima   school 5310110 39007   Yakima School District 531011001685 2592 Adams Elementary School   Regular School No Elementary PK 05 2017   grade_1 3 0 106   0 1     0   0   55 55 0   88   4   106       1.0 110 3 0 106   0 1     0   0   55 55 0   88 4 106     1 110
632534 WA Yakima   school 5310110 39007   Yakima School District 531011001685 2592 Adams Elementary School   Regular School No Elementary PK 05 2017   grade_2 5 0 108   1 0     0   0   59 55 0   86   6   110       1.0 114 5 0 108   1 0     0   0   59 55 0   86 6 110     1 114
632535 WA Yakima   school 5310110 39007   Yakima School District 531011001685 2592 Adams Elementary School   Regular School No Elementary PK 05 2017   grade_3 2 0 111   2 0     0   0   50 65 0   76   5   111       3.0 115 2 0 111   2 0     0   0   50 65 0   76 5 111     3 115
632536 WA Yakima   school 5310110 39007   Yakima School District 531011001685 2592 Adams Elementary School   Regular School No Elementary PK 05 2017   grade_4 6 1 142   0 0     0   0   75 74 0   90   6   144       3.0 149 6 1 142   0 0     0   0   75 74 0   90 6 144     3 149
632537 WA Yakima   school 5310110 39007   Yakima School District 531011001685 2592 Adams Elementary School   Regular School No Elementary PK 05 2017   grade_5 4 0 117   1 0     0   0   62 60 0   68   3   118       2.0 122 4 0 117   1 0     0   0   62 60 0   68 3 118     2 122
632538 WA Yakima   school 5310110 39007   Yakima School District 531011001685 2592 Adams Elementary School   Regular School No Elementary PK 05 2017   pk_12_total 24 1 746   4 1     0   0   390 386 0   492   33   747       12.0 776 24 1 746   4 1     0   0   390 386 0   492 33 747     12 776
632539 WA Yakima   school 5310110 39007   Yakima School District 531011001685 2592 Adams Elementary School   Regular School No Elementary PK 05 2017   kindergarten 3 0 111   0 0     0   0   67 47 0   84   7   108       2.0 114 3 0 111   0 0     0   0   67 47 0   84 7 108     2 114
632540 WA Yakima   school 5310110 39007   Yakima School District 531011001685 2592 Adams Elementary School   Regular School No Elementary PK 05 2017   pre_kindergarten 1 0 51   0 0     0   0   22 30 0   0   2   50       0.0 52 1 0 51   0 0     0   0   22 30 0   0 2 50     0 52
621178 WA King   school 5302820 17210   Federal Way School District 530282000430 3519 Adelaide Elementary School   Regular School No Elementary PK 05 2017   grade_1 15 6 21   0 5     3   10   24 36 0   18   1   38       1.0 60 15 6 21   0 5     3   10   24 36 0   18 1 38     1 60
621179 WA King   school 5302820 17210   Federal Way School District 530282000430 3519 Adelaide Elementary School   Regular School No Elementary PK 05 2017   grade_2 23 7 19   1 2     6   13   42 29 0   13   2   53       0.0 71 23 7 19   1 2     6   13   42 29 0   13 2 53     0 71
621180 WA King   school 5302820 17210   Federal Way School District 530282000430 3519 Adelaide Elementary School   Regular School No Elementary PK 05 2017   grade_3 18 2 27   0 7     6   9   39 30 0   14   2   45       1.0 69 18 2 27   0 7     6   9   39 30 0   14 2 45     1 69
621181 WA King   school 5302820 17210   Federal Way School District 530282000430 3519 Adelaide Elementary School   Regular School No Elementary PK 05 2017   grade_4 16 2 23   1 4     7   11   39 25 0   19   1   46       1.0 64 16 2 23   1 4     7   11   39 25 0   19 1 46     1 64
621182 WA King   school 5302820 17210   Federal Way School District 530282000430 3519 Adelaide Elementary School   Regular School No Elementary PK 05 2017   grade_5 20 12 18   0 4     6   10   39 31 0   13   4   50       1.0 70 20 12 18   0 4     6   10   39 31 0   13 4 50     1 70
621183 WA King   school 5302820 17210   Federal Way School District 530282000430 3519 Adelaide Elementary School   Regular School No Elementary PK 05 2017   pk_12_total 104 36 131   2 27     35   63   215 183 0   99   13   280       4.0 398 104 36 131   2 27     35   63   215 183 0   99 13 280     4 398
621184 WA King   school 5302820 17210   Federal Way School District 530282000430 3519 Adelaide Elementary School   Regular School No Elementary PK 05 2017   kindergarten 12 7 23   0 5     7   10   32 32 0   22   3   48       0.0 64 12 7 23   0 5     7   10   32 32 0   22 3 48     0 64
617113 WA Lewis   school 5300060 21226   Adna School District 530006000012 2227 Adna Elementary School   Regular School No Elementary PK 05 2017   grade_1 34 0 2   1 0     0   0   18 19 0   1   0   9       0.0 37 34 0 2   1 0     0   0   18 19 0   1 0 9     0 37
617114 WA Lewis   school 5300060 21226   Adna School District 530006000012 2227 Adna Elementary School   Regular School No Elementary PK 05 2017   grade_2 47 2 3   1 0     0   0   29 24 0   0   1   19       0.0 53 47 2 3   1 0     0   0   29 24 0   0 1 19     0 53
617115 WA Lewis   school 5300060 21226   Adna School District 530006000012 2227 Adna Elementary School   Regular School No Elementary PK 05 2017   grade_3 45 0 6   2 0     0   0   27 26 0   0   3   17       0.0 53 45 0 6   2 0     0   0   27 26 0   0 3 17     0 53
617116 WA Lewis   school 5300060 21226   Adna School District 530006000012 2227 Adna Elementary School   Regular School No Elementary PK 05 2017   grade_4 39 0 3   1 0     0   0   24 19 0   1   2   14       0.0 43 39 0 3   1 0     0   0   24 19 0   1 2 14     0 43
617117 WA Lewis   school 5300060 21226   Adna School District 530006000012 2227 Adna Elementary School   Regular School No Elementary PK 05 2017   grade_5 41 0 5   0 1     0   0   26 21 0   0   0   16       0.0 47 41 0 5   0 1     0   0   26 21 0   0 0 16     0 47
617118 WA Lewis   school 5300060 21226   Adna School District 530006000012 2227 Adna Elementary School   Regular School No Elementary PK 05 2017   pk_12_total 241 3 20   5 1     0   1   142 129 0   2   6   84       0.0 271 241 3 20   5 1     0   1   142 129 0   2 6 84     0 271
617119 WA Lewis   school 5300060 21226   Adna School District 530006000012 2227 Adna Elementary School   Regular School No Elementary PK 05 2017   kindergarten 31 1 1   0 0     0   0   17 16 0   0   0   7       0.0 33 31 1 1   0 0     0   0   17 16 0   0 0 7     0 33
617120 WA Lewis   school 5300060 21226   Adna School District 530006000012 2227 Adna Elementary School   Regular School No Elementary PK 05 2017   pre_kindergarten 4 0 0   0 0     0   1   1 4 0   0   0   2       0.0 5 4 0 0   0 0     0   1   1 4 0   0 0 2     0 5
617121 WA Lewis   school 5300060 21226   Adna School District 530006000013 2441 Adna Middle/High School   Regular School No Other 06 12 2017   grade_10 53 0 5   1 0     0   0   37 22 0   0   1   14       4.0 59 53 0 5   1 0     0   0   37 22 0   0 1 14     4 59
617122 WA Lewis   school 5300060 21226   Adna School District 530006000013 2441 Adna Middle/High School   Regular School No Other 06 12 2017   grade_11 49 0 4   0 1     0   6   30 30 0   0   2   18       3.0 60 49 0 4   0 1     0   6   30 30 0   0 2 18     3 60
617123 WA Lewis   school 5300060 21226   Adna School District 530006000013 2441 Adna Middle/High School   Regular School No Other 06 12 2017   grade_12 59 0 2   0 0     0   2   39 24 0   0   0   8       2.0 63 59 0 2   0 0     0   2   39 24 0   0 0 8     2 63
617124 WA Lewis   school 5300060 21226   Adna School District 530006000013 2441 Adna Middle/High School   Regular School No Other 06 12 2017   grade_6 32 0 2   0 1     0   1   22 14 0   1   2   13       0.0 36 32 0 2   0 1     0   1   22 14 0   1 2 13     0 36
617125 WA Lewis   school 5300060 21226   Adna School District 530006000013 2441 Adna Middle/High School   Regular School No Other 06 12 2017   grade_7 40 0 2   0 1     0   0   20 23 0   0   0   13       0.0 43 40 0 2   0 1     0   0   20 23 0   0 0 13     0 43
617126 WA Lewis   school 5300060 21226   Adna School District 530006000013 2441 Adna Middle/High School   Regular School No Other 06 12 2017   grade_8 51 0 6   0 0     0   1   25 33 0   0   1   20       2.0 58 51 0 6   0 0     0   1   25 33 0   0 1 20     2 58
617127 WA Lewis   school 5300060 21226   Adna School District 530006000013 2441 Adna Middle/High School   Regular School No Other 06 12 2017   grade_9 46 0 3   0 0     0   3   24 28 0   0   1   24       3.0 52 46 0 3   0 0     0   3   24 28 0   0 1 24     3 52
617128 WA Lewis   school 5300060 21226   Adna School District 530006000013 2441 Adna Middle/High School   Regular School No Other 06 12 2017   pk_12_total 330 0 24   1 3     0   13   197 174 0   1   7   110       14.0 371 330 0 24   1 3     0   13   197 174 0   1 7 110     14 371
632232 WA Yakima   school 5309720 39208   West Valley School District (Yakima) 530972001649 2822 Ahtanum Valley Elementary   Regular School No Elementary KG 04 2017   grade_1 34 0 20   1 0     0   4   28 31 0   10   0   38       0.0 59 34 0 20   1 0     0   4   28 31 0   10 0 38     0 59
632233 WA Yakima   school 5309720 39208   West Valley School District (Yakima) 530972001649 2822 Ahtanum Valley Elementary   Regular School No Elementary KG 04 2017   grade_2 27 1 17   1 0     0   4   22 28 0   5   0   30       0.0 50 27 1 17   1 0     0   4   22 28 0   5 0 30     0 50
632234 WA Yakima   school 5309720 39208   West Valley School District (Yakima) 530972001649 2822 Ahtanum Valley Elementary   Regular School No Elementary KG 04 2017   grade_3 37 1 17   1 0     0   0   26 30 0   5   0   32       1.0 56 37 1 17   1 0     0   0   26 30 0   5 0 32     1 56
632235 WA Yakima   school 5309720 39208   West Valley School District (Yakima) 530972001649 2822 Ahtanum Valley Elementary   Regular School No Elementary KG 04 2017   grade_4 30 0 16   1 0     0   2   29 20 0   5   0   11       0.0 49 30 0 16   1 0     0   2   29 20 0   5 0 11     0 49
632236 WA Yakima   school 5309720 39208   West Valley School District (Yakima) 530972001649 2822 Ahtanum Valley Elementary   Regular School No Elementary KG 04 2017   pk_12_total 155 3 88   7 0     0   14   131 136 0   38   0   144       1.0 267 155 3 88   7 0     0   14   131 136 0   38 0 144     1 267
632237 WA Yakima   school 5309720 39208   West Valley School District (Yakima) 530972001649 2822 Ahtanum Valley Elementary   Regular School No Elementary KG 04 2017   kindergarten_half_day 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
632238 WA Yakima   school 5309720 39208   West Valley School District (Yakima) 530972001649 2822 Ahtanum Valley Elementary   Regular School No Elementary KG 04 2017   kindergarten 27 1 16   3 0     0   4   25 26 0   12   0   31       0.0 51 27 1 16   3 0     0   4   25 26 0   12 0 31     0 51
632239 WA Yakima   school 5309720 39208   West Valley School District (Yakima) 530972001649 2822 Ahtanum Valley Elementary   Regular School No Elementary KG 04 2017   pre_kindergarten 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
628159 WA King   school 5307710 17001   Seattle School District No. 1 530771001249 3774 Aki Kurose Middle School   Regular School No Middle 06 08 2017   grade_6 11 92 31   0 78     0   12   120 104 0   59   26   187       3.0 224 11 92 31   0 78     0   12   120 104 0   59 26 187     3 224
628160 WA King   school 5307710 17001   Seattle School District No. 1 530771001249 3774 Aki Kurose Middle School   Regular School No Middle 06 08 2017   grade_7 3 107 51   2 84     3   15   145 120 0   55   34   220       5.0 265 3 107 51   2 84     3   15   145 120 0   55 34 220     5 265
628161 WA King   school 5307710 17001   Seattle School District No. 1 530771001249 3774 Aki Kurose Middle School   Regular School No Middle 06 08 2017   grade_8 10 77 36   1 109     0   15   127 121 0   61   24   201       3.0 248 10 77 36   1 109     0   15   127 121 0   61 24 201     3 248
628162 WA King   school 5307710 17001   Seattle School District No. 1 530771001249 3774 Aki Kurose Middle School   Regular School No Middle 06 08 2017   pk_12_total 24 276 118   3 271     3   42   392 345 0   175   84   608       11.0 737 24 276 118   3 271     3   42   392 345 0   175 84 608     11 737
628163 WA King   school 5307710 17001   Seattle School District No. 1 530771001234 3778 Alan T. Sugiyama High School   Alternative School No High 09 12 2017   grade_10 0 3 2   0 1     1   0   0 7 0   1   1   5       0.0 7 0 3 2   0 1     1   0   0 7 0   1 1 5     0 7
628164 WA King   school 5307710 17001   Seattle School District No. 1 530771001234 3778 Alan T. Sugiyama High School   Alternative School No High 09 12 2017   grade_11 0 10 2   1 1     0   3   9 8 0   1   6   16       0.0 17 0 10 2   1 1     0   3   9 8 0   1 6 16     0 17
628165 WA King   school 5307710 17001   Seattle School District No. 1 530771001234 3778 Alan T. Sugiyama High School   Alternative School No High 09 12 2017   grade_12 2 20 11   0 5     0   4   18 24 0   3   15   39       1.0 42 2 20 11   0 5     0   4   18 24 0   3 15 39     1 42
628166 WA King   school 5307710 17001   Seattle School District No. 1 530771001234 3778 Alan T. Sugiyama High School   Alternative School No High 09 12 2017   grade_9 0 1 0   0 1     0   0   0 2 0   0   1   1       0.0 2 0 1 0   0 1     0   0   0 2 0   0 1 1     0 2
628167 WA King   school 5307710 17001   Seattle School District No. 1 530771001234 3778 Alan T. Sugiyama High School   Alternative School No High 09 12 2017   pk_12_total 2 34 15   1 8     1   7   27 41 0   5   23   61       1.0 68 2 34 15   1 8     1   7   27 41 0   5 23 61     1 68
623332 WA King   school 5304230 17414   Lake Washington School District 530423002648 4424 Albert Einstein Elementary   Regular School No Elementary KG 05 2017   grade_1 35 4 16   0 21     0   8   47 37 0   24   5   22       1.0 84 35 4 16   0 21     0   8   47 37 0   24 5 22     1 84
623333 WA King   school 5304230 17414   Lake Washington School District 530423002648 4424 Albert Einstein Elementary   Regular School No Elementary KG 05 2017   grade_2 20 5 19   0 20     0   9   40 33 0   13   6   27       1.0 73 20 5 19   0 20     0   9   40 33 0   13 6 27     1 73
623334 WA King   school 5304230 17414   Lake Washington School District 530423002648 4424 Albert Einstein Elementary   Regular School No Elementary KG 05 2017   grade_3 23 3 17   0 19     0   5   34 33 0   10   5   26       1.0 67 23 3 17   0 19     0   5   34 33 0   10 5 26     1 67
623335 WA King   school 5304230 17414   Lake Washington School District 530423002648 4424 Albert Einstein Elementary   Regular School No Elementary KG 05 2017   grade_4 28 2 23   0 9     0   8   33 37 0   17   4   27       0.0 70 28 2 23   0 9     0   8   33 37 0   17 4 27     0 70
623336 WA King   school 5304230 17414   Lake Washington School District 530423002648 4424 Albert Einstein Elementary   Regular School No Elementary KG 05 2017   grade_5 21 5 21   0 21     0   6   40 34 0   14   11   36       2.0 74 21 5 21   0 21     0   6   40 34 0   14 11 36     2 74
623337 WA King   school 5304230 17414   Lake Washington School District 530423002648 4424 Albert Einstein Elementary   Regular School No Elementary KG 05 2017   pk_12_total 154 25 104   0 112     0   37   223 209 0   99   36   151       5.0 432 154 25 104   0 112     0   37   223 209 0   99 36 151     5 432
623338 WA King   school 5304230 17414   Lake Washington School District 530423002648 4424 Albert Einstein Elementary   Regular School No Elementary KG 05 2017   kindergarten 23 6 7   0 22     0   1   25 34 0   21   5   13       0.0 59 23 6 7   0 22     0   1   25 34 0   21 5 13     0 59
623339 WA King   school 5304230 17414   Lake Washington School District 530423002648 4424 Albert Einstein Elementary   Regular School No Elementary KG 05 2017   pre_kindergarten 4 0 1   0 0     0   0   4 1 0   0   0   0       0.0 5 4 0 1   0 0     0   0   4 1 0   0 0 0     0 5
629111 WA King   school 5307920 17412   Shoreline School District 530792001297 3674 Albert Einstein Middle School   Regular School No Middle 07 08 2017   grade_7 206 23 39   1 66     4   38   199 178 0   22   5   96       33.0 377 206 23 39   1 66     4   38   199 178 0   22 5 96     33 377
629112 WA King   school 5307920 17412   Shoreline School District 530792001297 3674 Albert Einstein Middle School   Regular School No Middle 07 08 2017   grade_8 170 26 47   6 56     3   40   175 173 0   16   18   109       34.0 348 170 26 47   6 56     3   40   175 173 0   16 18 109     34 348
629113 WA King   school 5307920 17412   Shoreline School District 530792001297 3674 Albert Einstein Middle School   Regular School No Middle 07 08 2017   pk_12_total 376 49 86   7 122     7   78   374 351 0   38   23   205       67.0 725 376 49 86   7 122     7   78   374 351 0   38 23 205     67 725
617838 WA Whatcom   school 5300420 37501   Bellingham School District 530042000098 3200 Alderwood Elementary School   Regular School No Elementary PK 05 2017   grade_1 17 0 19   0 3     0   1   18 22 0   13   1   32       2.0 40 17 0 19   0 3     0   1   18 22 0   13 1 32     2 40
617839 WA Whatcom   school 5300420 37501   Bellingham School District 530042000098 3200 Alderwood Elementary School   Regular School No Elementary PK 05 2017   grade_2 13 1 20   0 3     0   2   25 14 0   19   2   36       3.0 39 13 1 20   0 3     0   2   25 14 0   19 2 36     3 39
617840 WA Whatcom   school 5300420 37501   Bellingham School District 530042000098 3200 Alderwood Elementary School   Regular School No Elementary PK 05 2017   grade_3 18 1 10   2 6     0   2   22 17 0   13   3   31       5.0 39 18 1 10   2 6     0   2   22 17 0   13 3 31     5 39
617841 WA Whatcom   school 5300420 37501   Bellingham School District 530042000098 3200 Alderwood Elementary School   Regular School No Elementary PK 05 2017   grade_4 13 1 20   0 2     0   0   21 15 0   13   1   34       0.0 36 13 1 20   0 2     0   0   21 15 0   13 1 34     0 36
617842 WA Whatcom   school 5300420 37501   Bellingham School District 530042000098 3200 Alderwood Elementary School   Regular School No Elementary PK 05 2017   grade_5 17 0 19   0 3     0   1   19 21 0   19   2   34       3.0 40 17 0 19   0 3     0   1   19 21 0   19 2 34     3 40
617843 WA Whatcom   school 5300420 37501   Bellingham School District 530042000098 3200 Alderwood Elementary School   Regular School No Elementary PK 05 2017   pk_12_total 104 3 102   2 20     0   10   125 116 0   87   9   203       13.0 241 104 3 102   2 20     0   10   125 116 0   87 9 203     13 241
617844 WA Whatcom   school 5300420 37501   Bellingham School District 530042000098 3200 Alderwood Elementary School   Regular School No Elementary PK 05 2017   kindergarten 18 0 12   0 2     0   2   14 20 0   10   0   26       0.0 34 18 0 12   0 2     0   2   14 20 0   10 0 26     0 34
617845 WA Whatcom   school 5300420 37501   Bellingham School District 530042000098 3200 Alderwood Elementary School   Regular School No Elementary PK 05 2017   pre_kindergarten 8 0 2   0 1     0   2   6 7 0   0   0   10       0.0 13 8 0 2   0 1     0   2   6 7 0   0 0 10     0 13
620140 WA Snohomish   school 5302400 31015   Edmonds School District 530240000329 3560 Alderwood Middle School   Regular School No Middle 07 08 2017   grade_7 155 24 95   2 82     6   32   205 191 0   36   7   185       27.0 396 155 24 95   2 82     6   32   205 191 0   36 7 185     27 396
620141 WA Snohomish   school 5302400 31015   Edmonds School District 530240000329 3560 Alderwood Middle School   Regular School No Middle 07 08 2017   grade_8 141 26 87   1 72     3   34   193 171 0   34   13   183       21.0 364 141 26 87   1 72     3   34   193 171 0   34 13 183     21 364
620142 WA Snohomish   school 5302400 31015   Edmonds School District 530240000329 3560 Alderwood Middle School   Regular School No Middle 07 08 2017   pk_12_total 296 50 182   3 154     9   66   398 362 0   70   20   368       48.0 760 296 50 182   3 154     9   66   398 362 0   70 20 368     48 760
623340 WA King   school 5304230 17414   Lake Washington School District 530423000656 3592 Alexander Graham Bell Elementary   Regular School No Elementary PK 05 2017   grade_1 44 4 11   0 12     0   3   34 40 0   23   3   21       2.0 74 44 4 11   0 12     0   3   34 40 0   23 3 21     2 74
623341 WA King   school 5304230 17414   Lake Washington School District 530423000656 3592 Alexander Graham Bell Elementary   Regular School No Elementary PK 05 2017   grade_2 36 2 16   0 5     0   3   36 26 0   19   3   15       0.0 62 36 2 16   0 5     0   3   36 26 0   19 3 15     0 62
623342 WA King   school 5304230 17414   Lake Washington School District 530423000656 3592 Alexander Graham Bell Elementary   Regular School No Elementary PK 05 2017   grade_3 41 2 13   0 8     0   5   30 39 0   10   1   21       1.0 69 41 2 13   0 8     0   5   30 39 0   10 1 21     1 69
623343 WA King   school 5304230 17414   Lake Washington School District 530423000656 3592 Alexander Graham Bell Elementary   Regular School No Elementary PK 05 2017   grade_4 52 1 7   0 9     0   5   40 34 0   5   0   17       3.0 74 52 1 7   0 9     0   5   40 34 0   5 0 17     3 74
623344 WA King   school 5304230 17414   Lake Washington School District 530423000656 3592 Alexander Graham Bell Elementary   Regular School No Elementary PK 05 2017   grade_5 24 5 5   0 5     0   9   22 26 0   5   1   12       6.0 48 24 5 5   0 5     0   9   22 26 0   5 1 12     6 48
623345 WA King   school 5304230 17414   Lake Washington School District 530423000656 3592 Alexander Graham Bell Elementary   Regular School No Elementary PK 05 2017   pk_12_total 257 20 87   1 49     0   36   232 218 0   80   14   103       12.0 450 257 20 87   1 49     0   36   232 218 0   80 14 103     12 450
623346 WA King   school 5304230 17414   Lake Washington School District 530423000656 3592 Alexander Graham Bell Elementary   Regular School No Elementary PK 05 2017   kindergarten 34 0 5   0 6     0   5   29 21 0   17   2   17       0.0 50 34 0 5   0 6     0   5   29 21 0   17 2 17     0 50
623347 WA King   school 5304230 17414   Lake Washington School District 530423000656 3592 Alexander Graham Bell Elementary   Regular School No Elementary PK 05 2017   pre_kindergarten 26 6 30   1 4     0   6   41 32 0   1   4   0       0.0 73 26 6 30   1 4     0   6   41 32 0   1 4 0     0 73
619283 WA Pierce   school 5301410 27400   Clover Park School District 530141002839 1825 Alfaretta House   Special Education School No High 11 12 2017   grade_11 6 1 2   0 0     1   2   9 3 0   0   0   8       0.0 12 6 1 2   0 0     1   2   9 3 0   0 0 8     0 12
619284 WA Pierce   school 5301410 27400   Clover Park School District 530141002839 1825 Alfaretta House   Special Education School No High 11 12 2017   grade_12 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
619285 WA Pierce   school 5301410 27400   Clover Park School District 530141002839 1825 Alfaretta House   Special Education School No High 11 12 2017   pk_12_total 58 18 56   0 2     4   27   96 69 0   0   0   72       0.0 165 58 18 56   0 2     4   27   96 69 0   0 0 72     0 165
619286 WA Pierce   school 5301410 27400   Clover Park School District 530141002839 1825 Alfaretta House   Special Education School No High 11 12 2017   pre_kindergarten 49 17 54   0 2     3   25   85 65 0   0   0   63       0.0 150 49 17 54   0 2     3   25   85 65 0   0 0 63     0 150
628168 WA King   school 5307710 17001   Seattle School District No. 1 530771001129 2181 Alki Elementary School   Regular School No Elementary PK 05 2017   grade_1 32 3 3   0 3     0   8   23 26 0   4   0   6       0.0 49 32 3 3   0 3     0   8   23 26 0   4 0 6     0 49
628169 WA King   school 5307710 17001   Seattle School District No. 1 530771001129 2181 Alki Elementary School   Regular School No Elementary PK 05 2017   grade_2 60 3 7   0 2     0   11   46 37 0   5   2   19       0.0 83 60 3 7   0 2     0   11   46 37 0   5 2 19     0 83
628170 WA King   school 5307710 17001   Seattle School District No. 1 530771001129 2181 Alki Elementary School   Regular School No Elementary PK 05 2017   grade_3 37 8 7   2 3     0   7   33 31 0   1   1   14       0.0 64 37 8 7   2 3     0   7   33 31 0   1 1 14     0 64
628171 WA King   school 5307710 17001   Seattle School District No. 1 530771001129 2181 Alki Elementary School   Regular School No Elementary PK 05 2017   grade_4 51 3 5   0 3     0   6   35 33 0   2   1   10       2.0 68 51 3 5   0 3     0   6   35 33 0   2 1 10     2 68
628172 WA King   school 5307710 17001   Seattle School District No. 1 530771001129 2181 Alki Elementary School   Regular School No Elementary PK 05 2017   grade_5 51 3 5   0 0     0   5   36 28 0   0   0   4       3.0 64 51 3 5   0 0     0   5   36 28 0   0 0 4     3 64
628173 WA King   school 5307710 17001   Seattle School District No. 1 530771001129 2181 Alki Elementary School   Regular School No Elementary PK 05 2017   pk_12_total 270 20 32   2 11     0   45   199 181 0   14   4   58       5.0 380 270 20 32   2 11     0   45   199 181 0   14 4 58     5 380
628174 WA King   school 5307710 17001   Seattle School District No. 1 530771001129 2181 Alki Elementary School   Regular School No Elementary PK 05 2017   kindergarten 39 0 5   0 0     0   8   26 26 0   2   0   5       0.0 52 39 0 5   0 0     0   8   26 26 0   2 0 5     0 52
631439 WA Clark   school 5309270 6037   Vancouver School District 530927000578 4406 Alki Middle School   Regular School No Middle 06 08 2017   grade_6 175 5 16   1 7     0   14   110 108 0   8   0   54       7.0 218 175 5 16   1 7     0   14   110 108 0   8 0 54     7 218
631440 WA Clark   school 5309270 6037   Vancouver School District 530927000578 4406 Alki Middle School   Regular School No Middle 06 08 2017   grade_7 170 3 18   1 11     2   14   114 105 0   5   2   68       12.0 219 170 3 18   1 11     2   14   114 105 0   5 2 68     12 219
631441 WA Clark   school 5309270 6037   Vancouver School District 530927000578 4406 Alki Middle School   Regular School No Middle 06 08 2017   grade_8 190 1 25   0 8     1   22   132 115 0   6   2   68       3.0 247 190 1 25   0 8     1   22   132 115 0   6 2 68     3 247
631442 WA Clark   school 5309270 6037   Vancouver School District 530927000578 4406 Alki Middle School   Regular School No Middle 06 08 2017   pk_12_total 535 9 59   2 26     3   50   356 328 0   19   4   190       22.0 684 535 9 59   2 26     3   50   356 328 0   19 4 190     22 684

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