Data source: Big Local News · About: Big Local

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

View and edit SQL

grade

year

  • 2017 · 15,558
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
617241 WA Snohomish   school 5300240 31016   Arlington School District 530024002589 1714 Stillaguamish Valley Learning Center   Alternative School No Other KG 12 2017   grade_12 19 2 0   0 0     0   1   12 10 0   0   0   4       2.0 22 19 2 0   0 0     0   1   12 10 0   0 0 4     2 22
617242 WA Snohomish   school 5300240 31016   Arlington School District 530024002589 1714 Stillaguamish Valley Learning Center   Alternative School No Other KG 12 2017   grade_1 6 0 1   0 0     0   1   2 6 0   0   0   1       0.0 8 6 0 1   0 0     0   1   2 6 0   0 0 1     0 8
617243 WA Snohomish   school 5300240 31016   Arlington School District 530024002589 1714 Stillaguamish Valley Learning Center   Alternative School No Other KG 12 2017   grade_2 6 0 0   0 0     0   0   4 2 0   0   0   1       0.0 6 6 0 0   0 0     0   0   4 2 0   0 0 1     0 6
617244 WA Snohomish   school 5300240 31016   Arlington School District 530024002589 1714 Stillaguamish Valley Learning Center   Alternative School No Other KG 12 2017   grade_3 4 0 0   0 0     0   0   1 3 0   0   0   2       0.0 4 4 0 0   0 0     0   0   1 3 0   0 0 2     0 4
617245 WA Snohomish   school 5300240 31016   Arlington School District 530024002589 1714 Stillaguamish Valley Learning Center   Alternative School No Other KG 12 2017   grade_4 10 0 0   0 0     0   0   6 4 0   0   0   3       0.0 10 10 0 0   0 0     0   0   6 4 0   0 0 3     0 10
617246 WA Snohomish   school 5300240 31016   Arlington School District 530024002589 1714 Stillaguamish Valley Learning Center   Alternative School No Other KG 12 2017   grade_5 5 0 2   0 0     0   0   4 3 0   0   0   1       0.0 7 5 0 2   0 0     0   0   4 3 0   0 0 1     0 7
617247 WA Snohomish   school 5300240 31016   Arlington School District 530024002589 1714 Stillaguamish Valley Learning Center   Alternative School No Other KG 12 2017   grade_6 7 0 2   0 0     0   0   3 6 0   0   0   3       0.0 9 7 0 2   0 0     0   0   3 6 0   0 0 3     0 9
617248 WA Snohomish   school 5300240 31016   Arlington School District 530024002589 1714 Stillaguamish Valley Learning Center   Alternative School No Other KG 12 2017   grade_7 3 0 0   0 0     0   0   3 0 0   0   0   0       0.0 3 3 0 0   0 0     0   0   3 0 0   0 0 0     0 3
617249 WA Snohomish   school 5300240 31016   Arlington School District 530024002589 1714 Stillaguamish Valley Learning Center   Alternative School No Other KG 12 2017   grade_8 10 0 0   0 0     0   0   7 3 0   0   0   0       0.0 10 10 0 0   0 0     0   0   7 3 0   0 0 0     0 10
617250 WA Snohomish   school 5300240 31016   Arlington School District 530024002589 1714 Stillaguamish Valley Learning Center   Alternative School No Other KG 12 2017   grade_9 10 1 0   0 0     0   1   8 4 0   0   1   3       0.0 12 10 1 0   0 0     0   1   8 4 0   0 1 3     0 12
617251 WA Snohomish   school 5300240 31016   Arlington School District 530024002589 1714 Stillaguamish Valley Learning Center   Alternative School No Other KG 12 2017   pk_12_total 111 6 11   2 1     0   4   68 67 0   0   2   32       5.0 135 111 6 11   2 1     0   4   68 67 0   0 2 32     5 135
617252 WA Snohomish   school 5300240 31016   Arlington School District 530024002589 1714 Stillaguamish Valley Learning Center   Alternative School No Other KG 12 2017   kindergarten 3 0 2   0 0     0   0   1 4 0   0   0   1       0.0 5 3 0 2   0 0     0   0   1 4 0   0 0 1     0 5
617253 WA Snohomish   school 5300240 31016   Arlington School District 530024002074 4287 Weston High School   Alternative School No High 09 12 2017   grade_10 17 0 4   0 1     0   1   16 7 0   0   2   13       4.0 23 17 0 4   0 1     0   1   16 7 0   0 2 13     4 23
617254 WA Snohomish   school 5300240 31016   Arlington School District 530024002074 4287 Weston High School   Alternative School No High 09 12 2017   grade_11 46 0 6   0 0     0   1   26 27 0   0   5   24       2.0 53 46 0 6   0 0     0   1   26 27 0   0 5 24     2 53
617255 WA Snohomish   school 5300240 31016   Arlington School District 530024002074 4287 Weston High School   Alternative School No High 09 12 2017   grade_12 27 2 1   0 0     1   0   20 11 0   1   9   19       1.0 31 27 2 1   0 0     1   0   20 11 0   1 9 19     1 31
617256 WA Snohomish   school 5300240 31016   Arlington School District 530024002074 4287 Weston High School   Alternative School No High 09 12 2017   grade_9 7 0 1   0 0     0   0   3 5 0   0   1   7       0.0 8 7 0 1   0 0     0   0   3 5 0   0 1 7     0 8
617257 WA Snohomish   school 5300240 31016   Arlington School District 530024002074 4287 Weston High School   Alternative School No High 09 12 2017   pk_12_total 97 2 12   0 1     1   2   65 50 0   1   17   63       7.0 115 97 2 12   0 1     1   2   65 50 0   1 17 63     7 115
617258 WA Asotin   school 5300280 2420   Asotin-Anatone School District 530028000027 2507 Asotin Elementary   Regular School No Elementary PK 05 2017   grade_1 35 0 3   0 1     0   1   16 24 0   0   1   17       0.0 40 35 0 3   0 1     0   1   16 24 0   0 1 17     0 40
617259 WA Asotin   school 5300280 2420   Asotin-Anatone School District 530028000027 2507 Asotin Elementary   Regular School No Elementary PK 05 2017   grade_2 38 0 1   0 1     0   1   22 19 0   0   1   13       0.0 41 38 0 1   0 1     0   1   22 19 0   0 1 13     0 41
617260 WA Asotin   school 5300280 2420   Asotin-Anatone School District 530028000027 2507 Asotin Elementary   Regular School No Elementary PK 05 2017   grade_3 54 0 2   0 0     0   1   27 30 0   0   0   18       1.0 57 54 0 2   0 0     0   1   27 30 0   0 0 18     1 57
617261 WA Asotin   school 5300280 2420   Asotin-Anatone School District 530028000027 2507 Asotin Elementary   Regular School No Elementary PK 05 2017   grade_4 37 0 3   1 1     0   3   24 21 0   0   0   23       0.0 45 37 0 3   1 1     0   3   24 21 0   0 0 23     0 45
617262 WA Asotin   school 5300280 2420   Asotin-Anatone School District 530028000027 2507 Asotin Elementary   Regular School No Elementary PK 05 2017   grade_5 42 1 1   0 0     0   4   24 24 0   0   0   19       0.0 48 42 1 1   0 0     0   4   24 24 0   0 0 19     0 48
617263 WA Asotin   school 5300280 2420   Asotin-Anatone School District 530028000027 2507 Asotin Elementary   Regular School No Elementary PK 05 2017   pk_12_total 287 1 14   1 3     0   11   160 157 0   0   2   118       1.0 317 287 1 14   1 3     0   11   160 157 0   0 2 118     1 317
617264 WA Asotin   school 5300280 2420   Asotin-Anatone School District 530028000027 2507 Asotin Elementary   Regular School No Elementary PK 05 2017   kindergarten 44 0 3   0 0     0   1   28 20 0   0   0   17       0.0 48 44 0 3   0 0     0   1   28 20 0   0 0 17     0 48
617265 WA Asotin   school 5300280 2420   Asotin-Anatone School District 530028000027 2507 Asotin Elementary   Regular School No Elementary PK 05 2017   pre_kindergarten 37 0 1   0 0     0   0   19 19 0   0   0   11       0.0 38 37 0 1   0 0     0   0   19 19 0   0 0 11     0 38
617266 WA Asotin   school 5300280 2420   Asotin-Anatone School District 530028000028 2434 Asotin Jr Sr High   Regular School No Other 06 12 2017   grade_10 52 0 7   0 1     0   3   28 35 0   0   1   20       2.0 63 52 0 7   0 1     0   3   28 35 0   0 1 20     2 63
617267 WA Asotin   school 5300280 2420   Asotin-Anatone School District 530028000028 2434 Asotin Jr Sr High   Regular School No Other 06 12 2017   grade_11 41 0 5   1 0     0   5   26 26 0   0   3   16       4.0 52 41 0 5   1 0     0   5   26 26 0   0 3 16     4 52
617268 WA Asotin   school 5300280 2420   Asotin-Anatone School District 530028000028 2434 Asotin Jr Sr High   Regular School No Other 06 12 2017   grade_12 48 0 5   1 0     0   2   29 27 0   0   4   18       1.0 56 48 0 5   1 0     0   2   29 27 0   0 4 18     1 56
617269 WA Asotin   school 5300280 2420   Asotin-Anatone School District 530028000028 2434 Asotin Jr Sr High   Regular School No Other 06 12 2017   grade_6 46 0 3   0 0     0   4   24 29 0   0   1   21       1.0 53 46 0 3   0 0     0   4   24 29 0   0 1 21     1 53
617270 WA Asotin   school 5300280 2420   Asotin-Anatone School District 530028000028 2434 Asotin Jr Sr High   Regular School No Other 06 12 2017   grade_7 51 0 2   0 1     0   7   30 31 0   0   1   19       0.0 61 51 0 2   0 1     0   7   30 31 0   0 1 19     0 61
617271 WA Asotin   school 5300280 2420   Asotin-Anatone School District 530028000028 2434 Asotin Jr Sr High   Regular School No Other 06 12 2017   grade_8 46 0 3   1 1     0   2   25 28 0   0   2   15       4.0 53 46 0 3   1 1     0   2   25 28 0   0 2 15     4 53
617272 WA Asotin   school 5300280 2420   Asotin-Anatone School District 530028000028 2434 Asotin Jr Sr High   Regular School No Other 06 12 2017   grade_9 40 0 1   0 1     0   2   24 20 0   0   0   13       0.0 44 40 0 1   0 1     0   2   24 20 0   0 0 13     0 44
617273 WA Asotin   school 5300280 2420   Asotin-Anatone School District 530028000028 2434 Asotin Jr Sr High   Regular School No Other 06 12 2017   pk_12_total 324 0 26   3 4     0   25   186 196 0   0   12   122       12.0 382 324 0 26   3 4     0   25   186 196 0   0 12 122     12 382
617274 WA King   school 5300300 17408   Auburn School District 530030000029 3825 Alpac Elementary School   Regular School No Elementary PK 05 2017   grade_1 38 4 22   0 8     1   18   45 46 0   25   0   62       1.0 91 38 4 22   0 8     1   18   45 46 0   25 0 62     1 91
617275 WA King   school 5300300 17408   Auburn School District 530030000029 3825 Alpac Elementary School   Regular School No Elementary PK 05 2017   grade_2 38 3 26   0 9     1   13   42 48 0   27   5   52       1.0 90 38 3 26   0 9     1   13   42 48 0   27 5 52     1 90
617276 WA King   school 5300300 17408   Auburn School District 530030000029 3825 Alpac Elementary School   Regular School No Elementary PK 05 2017   grade_3 39 3 28   0 9     3   16   44 54 0   18   2   64       3.0 98 39 3 28   0 9     3   16   44 54 0   18 2 64     3 98
617277 WA King   school 5300300 17408   Auburn School District 530030000029 3825 Alpac Elementary School   Regular School No Elementary PK 05 2017   grade_4 45 2 28   1 11     3   6   48 48 0   24   0   63       1.0 96 45 2 28   1 11     3   6   48 48 0   24 0 63     1 96
617278 WA King   school 5300300 17408   Auburn School District 530030000029 3825 Alpac Elementary School   Regular School No Elementary PK 05 2017   grade_5 31 4 23   0 8     3   3   37 35 0   14   1   46       1.0 72 31 4 23   0 8     3   3   37 35 0   14 1 46     1 72
617279 WA King   school 5300300 17408   Auburn School District 530030000029 3825 Alpac Elementary School   Regular School No Elementary PK 05 2017   pk_12_total 264 20 173   1 57     12   85   309 303 0   143   9   362       9.0 612 264 20 173   1 57     12   85   309 303 0   143 9 362     9 612
617280 WA King   school 5300300 17408   Auburn School District 530030000029 3825 Alpac Elementary School   Regular School No Elementary PK 05 2017   kindergarten_half_day 0 0 0   0 0     0   1   0 1 0   0   0   1       0.0 1 0 0 0   0 0     0   1   0 1 0   0 0 1     0 1
617281 WA King   school 5300300 17408   Auburn School District 530030000029 3825 Alpac Elementary School   Regular School No Elementary PK 05 2017   kindergarten 51 3 25   0 7     1   21   59 49 0   33   1   56       2.0 108 51 3 25   0 7     1   21   59 49 0   33 1 56     2 108
617282 WA King   school 5300300 17408   Auburn School District 530030000029 3825 Alpac Elementary School   Regular School No Elementary PK 05 2017   pre_kindergarten 22 1 21   0 5     0   7   34 22 0   2   0   18       0.0 56 22 1 21   0 5     0   7   34 22 0   2 0 18     0 56
617283 WA King   school 5300300 17408   Auburn School District 530030003174 5082 Arthur Jacobsen Elementary   Regular School No Elementary KG 05 2017   grade_1 44 5 17   0 10     0   14   47 43 0   39   2   42       1.0 90 44 5 17   0 10     0   14   47 43 0   39 2 42     1 90
617284 WA King   school 5300300 17408   Auburn School District 530030003174 5082 Arthur Jacobsen Elementary   Regular School No Elementary KG 05 2017   grade_2 35 8 17   0 13     0   7   39 41 0   27   0   40       1.0 80 35 8 17   0 13     0   7   39 41 0   27 0 40     1 80
617285 WA King   school 5300300 17408   Auburn School District 530030003174 5082 Arthur Jacobsen Elementary   Regular School No Elementary KG 05 2017   grade_3 59 6 18   0 14     0   8   52 53 0   21   1   47       1.0 105 59 6 18   0 14     0   8   52 53 0   21 1 47     1 105
617286 WA King   school 5300300 17408   Auburn School District 530030003174 5082 Arthur Jacobsen Elementary   Regular School No Elementary KG 05 2017   grade_4 49 7 30   0 19     0   8   46 67 0   13   0   54       6.0 113 49 7 30   0 19     0   8   46 67 0   13 0 54     6 113
617287 WA King   school 5300300 17408   Auburn School District 530030003174 5082 Arthur Jacobsen Elementary   Regular School No Elementary KG 05 2017   grade_5 57 8 23   0 14     2   7   49 62 0   13   1   61       0.0 111 57 8 23   0 14     2   7   49 62 0   13 1 61     0 111
617288 WA King   school 5300300 17408   Auburn School District 530030003174 5082 Arthur Jacobsen Elementary   Regular School No Elementary KG 05 2017   pk_12_total 271 37 130   0 83     2   53   280 296 0   150   4   282       9.0 576 271 37 130   0 83     2   53   280 296 0   150 4 282     9 576
617289 WA King   school 5300300 17408   Auburn School District 530030003174 5082 Arthur Jacobsen Elementary   Regular School No Elementary KG 05 2017   kindergarten 27 3 25   0 13     0   9   47 30 0   37   0   38       0.0 77 27 3 25   0 13     0   9   47 30 0   37 0 38     0 77
617290 WA King   school 5300300 17408   Auburn School District 530030002978 5037 Auburn Mountainview High School   Regular School No High 09 12 2017   grade_10 181 40 63   3 45     5   33   169 201 0   29   4   156       18.0 370 181 40 63   3 45     5   33   169 201 0   29 4 156     18 370
617291 WA King   school 5300300 17408   Auburn School District 530030002978 5037 Auburn Mountainview High School   Regular School No High 09 12 2017   grade_11 230 38 63   6 41     5   25   187 221 0   26   4   167       22.0 408 230 38 63   6 41     5   25   187 221 0   26 4 167     22 408
617292 WA King   school 5300300 17408   Auburn School District 530030002978 5037 Auburn Mountainview High School   Regular School No High 09 12 2017   grade_12 196 31 55   3 38     7   24   192 162 0   17   4   124       16.0 354 196 31 55   3 38     7   24   192 162 0   17 4 124     16 354
617293 WA King   school 5300300 17408   Auburn School District 530030002978 5037 Auburn Mountainview High School   Regular School No High 09 12 2017   grade_9 195 42 67   1 40     8   29   187 195 0   28   10   184       22.0 382 195 42 67   1 40     8   29   187 195 0   28 10 184     22 382
617294 WA King   school 5300300 17408   Auburn School District 530030002978 5037 Auburn Mountainview High School   Regular School No High 09 12 2017   pk_12_total 802 151 248   13 164     25   111   735 779 0   100   22   631       78.0 1514 802 151 248   13 164     25   111   735 779 0   100 22 631     78 1514
617295 WA King   school 5300300 17408   Auburn School District 530030002445 4474 Auburn Riverside High School   Regular School No High 09 12 2017   grade_10 189 15 101   4 39     14   20   178 204 0   30   0   173       11.0 382 189 15 101   4 39     14   20   178 204 0   30 0 173     11 382
617296 WA King   school 5300300 17408   Auburn School District 530030002445 4474 Auburn Riverside High School   Regular School No High 09 12 2017   grade_11 215 31 123   0 53     11   41   237 237 0   35   4   175       20.0 474 215 31 123   0 53     11   41   237 237 0   35 4 175     20 474
617297 WA King   school 5300300 17408   Auburn School District 530030002445 4474 Auburn Riverside High School   Regular School No High 09 12 2017   grade_12 183 20 86   1 39     1   22   151 201 0   14   4   108       14.0 352 183 20 86   1 39     1   22   151 201 0   14 4 108     14 352
617298 WA King   school 5300300 17408   Auburn School District 530030002445 4474 Auburn Riverside High School   Regular School No High 09 12 2017   grade_9 206 19 114   2 43     15   32   215 216 0   33   3   192       16.0 431 206 19 114   2 43     15   32   215 216 0   33 3 192     16 431
617299 WA King   school 5300300 17408   Auburn School District 530030002445 4474 Auburn Riverside High School   Regular School No High 09 12 2017   pk_12_total 793 85 424   7 174     41   115   781 858 0   112   11   648       61.0 1639 793 85 424   7 174     41   115   781 858 0   112 11 648     61 1639
617300 WA King   school 5300300 17408   Auburn School District 530030000032 2795 Auburn Senior High School   Regular School No High 09 12 2017   grade_10 166 36 157   9 33     20   42   240 223 0   52   7   305       27.0 463 166 36 157   9 33     20   42   240 223 0   52 7 305     27 463
617301 WA King   school 5300300 17408   Auburn School District 530030000032 2795 Auburn Senior High School   Regular School No High 09 12 2017   grade_11 189 54 126   13 28     28   32   271 199 0   39   19   295       8.0 470 189 54 126   13 28     28   32   271 199 0   39 19 295     8 470
617302 WA King   school 5300300 17408   Auburn School District 530030000032 2795 Auburn Senior High School   Regular School No High 09 12 2017   grade_12 144 20 94   9 19     14   28   159 169 0   19   9   188       13.0 328 144 20 94   9 19     14   28   159 169 0   19 9 188     13 328
617303 WA King   school 5300300 17408   Auburn School District 530030000032 2795 Auburn Senior High School   Regular School No High 09 12 2017   grade_9 165 39 131   15 25     26   33   229 205 0   60   9   281       15.0 434 165 39 131   15 25     26   33   229 205 0   60 9 281     15 434
617304 WA King   school 5300300 17408   Auburn School District 530030000032 2795 Auburn Senior High School   Regular School No High 09 12 2017   pk_12_total 664 149 508   46 105     88   135   899 796 0   170   44   1069       63.0 1695 664 149 508   46 105     88   135   899 796 0   170 44 1069     63 1695
617305 WA King   school 5300300 17408   Auburn School District 530030000033 2394 Cascade Middle School   Regular School No Middle 06 08 2017   grade_6 107 25 62   0 22     11   26   117 136 0   38   4   153       3.0 253 107 25 62   0 22     11   26   117 136 0   38 4 153     3 253
617306 WA King   school 5300300 17408   Auburn School District 530030000033 2394 Cascade Middle School   Regular School No Middle 06 08 2017   grade_7 96 26 63   1 24     12   21   111 132 0   33   6   161       6.0 243 96 26 63   1 24     12   21   111 132 0   33 6 161     6 243
617307 WA King   school 5300300 17408   Auburn School District 530030000033 2394 Cascade Middle School   Regular School No Middle 06 08 2017   grade_8 107 27 57   2 20     7   10   131 99 0   27   6   129       4.0 230 107 27 57   2 20     7   10   131 99 0   27 6 129     4 230
617308 WA King   school 5300300 17408   Auburn School District 530030000033 2394 Cascade Middle School   Regular School No Middle 06 08 2017   pk_12_total 310 78 182   3 66     30   57   359 367 0   98   16   443       13.0 726 310 78 182   3 66     30   57   359 367 0   98 16 443     13 726
617309 WA King   school 5300300 17408   Auburn School District 530030000034 3439 Chinook Elementary School   Regular School No Elementary PK 05 2017   grade_1 18 3 38   10 2     6   8   45 40 0   30   1   65       0.0 85 18 3 38   10 2     6   8   45 40 0   30 1 65     0 85
617310 WA King   school 5300300 17408   Auburn School District 530030000034 3439 Chinook Elementary School   Regular School No Elementary PK 05 2017   grade_2 21 5 32   7 3     2   7   46 31 0   25   0   54       0.0 77 21 5 32   7 3     2   7   46 31 0   25 0 54     0 77
617311 WA King   school 5300300 17408   Auburn School District 530030000034 3439 Chinook Elementary School   Regular School No Elementary PK 05 2017   grade_3 17 4 29   12 4     4   6   43 33 0   22   1   53       0.0 76 17 4 29   12 4     4   6   43 33 0   22 1 53     0 76
617312 WA King   school 5300300 17408   Auburn School District 530030000034 3439 Chinook Elementary School   Regular School No Elementary PK 05 2017   grade_4 12 8 36   16 3     7   9   44 47 0   19   1   66       2.0 91 12 8 36   16 3     7   9   44 47 0   19 1 66     2 91
617313 WA King   school 5300300 17408   Auburn School District 530030000034 3439 Chinook Elementary School   Regular School No Elementary PK 05 2017   grade_5 17 6 33   7 4     3   10   46 34 0   14   0   59       0.0 80 17 6 33   7 4     3   10   46 34 0   14 0 59     0 80
617314 WA King   school 5300300 17408   Auburn School District 530030000034 3439 Chinook Elementary School   Regular School No Elementary PK 05 2017   pk_12_total 120 36 229   63 20     27   62   305 252 0   143   3   397       2.0 557 120 36 229   63 20     27   62   305 252 0   143 3 397     2 557
617315 WA King   school 5300300 17408   Auburn School District 530030000034 3439 Chinook Elementary School   Regular School No Elementary PK 05 2017   kindergarten 16 7 27   9 1     5   13   41 37 0   33   0   52       0.0 78 16 7 27   9 1     5   13   41 37 0   33 0 52     0 78
617316 WA King   school 5300300 17408   Auburn School District 530030000034 3439 Chinook Elementary School   Regular School No Elementary PK 05 2017   pre_kindergarten 19 3 34   2 3     0   9   40 30 0   0   0   48       0.0 70 19 3 34   2 3     0   9   40 30 0   0 0 48     0 70
617317 WA King   school 5300300 17408   Auburn School District 530030000037 2932 Dick Scobee Elementary School   Regular School No Elementary PK 05 2017   grade_1 33 5 24   0 3     2   7   35 39 0   15   1   47       0.0 74 33 5 24   0 3     2   7   35 39 0   15 1 47     0 74
617318 WA King   school 5300300 17408   Auburn School District 530030000037 2932 Dick Scobee Elementary School   Regular School No Elementary PK 05 2017   grade_2 32 10 31   0 8     5   13   55 44 0   30   4   80       2.0 99 32 10 31   0 8     5   13   55 44 0   30 4 80     2 99
617319 WA King   school 5300300 17408   Auburn School District 530030000037 2932 Dick Scobee Elementary School   Regular School No Elementary PK 05 2017   grade_3 32 11 18   0 8     2   18   43 46 0   22   3   73       2.0 89 32 11 18   0 8     2   18   43 46 0   22 3 73     2 89
617320 WA King   school 5300300 17408   Auburn School District 530030000037 2932 Dick Scobee Elementary School   Regular School No Elementary PK 05 2017   grade_4 23 9 27   0 1     5   11   38 38 0   22   4   59       2.0 76 23 9 27   0 1     5   11   38 38 0   22 4 59     2 76
617321 WA King   school 5300300 17408   Auburn School District 530030000037 2932 Dick Scobee Elementary School   Regular School No Elementary PK 05 2017   grade_5 25 9 25   0 3     4   6   32 40 0   16   3   60       2.0 72 25 9 25   0 3     4   6   32 40 0   16 3 60     2 72
617322 WA King   school 5300300 17408   Auburn School District 530030000037 2932 Dick Scobee Elementary School   Regular School No Elementary PK 05 2017   pk_12_total 204 52 164   1 33     26   75   279 276 0   142   19   411       13.0 555 204 52 164   1 33     26   75   279 276 0   142 19 411     13 555
617323 WA King   school 5300300 17408   Auburn School District 530030000037 2932 Dick Scobee Elementary School   Regular School No Elementary PK 05 2017   kindergarten_half_day 1 0 0   0 0     0   0   0 1 0   1   0   1       0.0 1 1 0 0   0 0     0   0   0 1 0   1 0 1     0 1
617324 WA King   school 5300300 17408   Auburn School District 530030000037 2932 Dick Scobee Elementary School   Regular School No Elementary PK 05 2017   kindergarten 42 7 29   1 5     7   14   52 53 0   35   4   78       4.0 105 42 7 29   1 5     7   14   52 53 0   35 4 78     4 105
617325 WA King   school 5300300 17408   Auburn School District 530030000037 2932 Dick Scobee Elementary School   Regular School No Elementary PK 05 2017   pre_kindergarten 16 1 10   0 5     1   6   24 15 0   1   0   13       1.0 39 16 1 10   0 5     1   6   24 15 0   1 0 13     1 39
617326 WA King   school 5300300 17408   Auburn School District 530030000035 3745 Evergreen Heights Elementary   Regular School No Elementary KG 05 2017   grade_1 25 8 9   0 13     2   10   33 34 0   21   0   35       1.0 67 25 8 9   0 13     2   10   33 34 0   21 0 35     1 67
617327 WA King   school 5300300 17408   Auburn School District 530030000035 3745 Evergreen Heights Elementary   Regular School No Elementary KG 05 2017   grade_2 44 12 16   0 12     2   15   53 48 0   21   1   45       3.0 101 44 12 16   0 12     2   15   53 48 0   21 1 45     3 101
617328 WA King   school 5300300 17408   Auburn School District 530030000035 3745 Evergreen Heights Elementary   Regular School No Elementary KG 05 2017   grade_3 33 3 18   0 18     3   16   45 46 0   18   0   44       1.0 91 33 3 18   0 18     3   16   45 46 0   18 0 44     1 91
617329 WA King   school 5300300 17408   Auburn School District 530030000035 3745 Evergreen Heights Elementary   Regular School No Elementary KG 05 2017   grade_4 28 6 18   0 8     2   4   32 34 0   15   1   34       1.0 66 28 6 18   0 8     2   4   32 34 0   15 1 34     1 66
617330 WA King   school 5300300 17408   Auburn School District 530030000035 3745 Evergreen Heights Elementary   Regular School No Elementary KG 05 2017   grade_5 28 8 13   0 12     2   15   40 38 0   11   0   43       2.0 78 28 8 13   0 12     2   15   40 38 0   11 0 43     2 78
617331 WA King   school 5300300 17408   Auburn School District 530030000035 3745 Evergreen Heights Elementary   Regular School No Elementary KG 05 2017   pk_12_total 189 45 98   0 83     14   76   254 251 0   117   2   251       11.0 505 189 45 98   0 83     14   76   254 251 0   117 2 251     11 505
617332 WA King   school 5300300 17408   Auburn School District 530030000035 3745 Evergreen Heights Elementary   Regular School No Elementary KG 05 2017   kindergarten 31 8 24   0 20     3   16   51 51 0   31   0   50       3.0 102 31 8 24   0 20     3   16   51 51 0   31 0 50     3 102
617333 WA King   school 5300300 17408   Auburn School District 530030000040 3669 Gildo Rey Elementary School   Regular School No Elementary PK 05 2017   grade_1 18 4 38   0 3     8   10   37 44 0   40   4   61       1.0 81 18 4 38   0 3     8   10   37 44 0   40 4 61     1 81
617334 WA King   school 5300300 17408   Auburn School District 530030000040 3669 Gildo Rey Elementary School   Regular School No Elementary PK 05 2017   grade_2 30 10 67   1 4     6   8   65 61 0   62   1   105       0.0 126 30 10 67   1 4     6   8   65 61 0   62 1 105     0 126
617335 WA King   school 5300300 17408   Auburn School District 530030000040 3669 Gildo Rey Elementary School   Regular School No Elementary PK 05 2017   grade_3 19 2 54   0 3     5   13   41 55 0   29   1   77       0.0 96 19 2 54   0 3     5   13   41 55 0   29 1 77     0 96
617336 WA King   school 5300300 17408   Auburn School District 530030000040 3669 Gildo Rey Elementary School   Regular School No Elementary PK 05 2017   grade_4 10 1 65   0 5     7   9   51 46 0   34   2   86       1.0 97 10 1 65   0 5     7   9   51 46 0   34 2 86     1 97
617337 WA King   school 5300300 17408   Auburn School District 530030000040 3669 Gildo Rey Elementary School   Regular School No Elementary PK 05 2017   grade_5 18 1 52   1 10     9   4   58 37 0   29   3   81       1.0 95 18 1 52   1 10     9   4   58 37 0   29 3 81     1 95
617338 WA King   school 5300300 17408   Auburn School District 530030000040 3669 Gildo Rey Elementary School   Regular School No Elementary PK 05 2017   pk_12_total 131 21 354   2 28     38   53   320 307 0   251   14   490       3.0 627 131 21 354   2 28     38   53   320 307 0   251 14 490     3 627
617339 WA King   school 5300300 17408   Auburn School District 530030000040 3669 Gildo Rey Elementary School   Regular School No Elementary PK 05 2017   kindergarten 25 3 64   0 3     2   7   52 52 0   57   2   72       0.0 104 25 3 64   0 3     2   7   52 52 0   57 2 72     0 104
617340 WA King   school 5300300 17408   Auburn School District 530030000040 3669 Gildo Rey Elementary School   Regular School No Elementary PK 05 2017   pre_kindergarten 11 0 14   0 0     1   2   16 12 0   0   1   8       0.0 28 11 0 14   0 0     1   2   16 12 0   0 1 8     0 28

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