Data source: Big Local News · About: Big Local

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

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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
617348 WA King   school 5300300 17408   Auburn School District 530030002277 4347 Hazelwood Elementary School   Regular School No Elementary KG 05 2017   pre_kindergarten 1 0 1   0 0     0   0   2 0 0   0   0   2       0.0 2 1 0 1   0 0     0   0   2 0 0   0 0 2     0 2
617350 WA King   school 5300300 17408   Auburn School District 530030000698 4417 Ilalko Elementary School   Regular School No Elementary KG 05 2017   grade_2 41 3 30   0 8     2   11   46 49 0   34   1   51       1.0 95 41 3 30   0 8     2   11   46 49 0   34 1 51     1 95
617351 WA King   school 5300300 17408   Auburn School District 530030000698 4417 Ilalko Elementary School   Regular School No Elementary KG 05 2017   grade_3 36 4 36   0 9     2   15   46 56 0   28   0   61       3.0 102 36 4 36   0 9     2   15   46 56 0   28 0 61     3 102
617355 WA King   school 5300300 17408   Auburn School District 530030000698 4417 Ilalko Elementary School   Regular School No Elementary KG 05 2017   kindergarten 30 6 30   0 13     2   18   50 49 0   32   1   53       1.0 99 30 6 30   0 13     2   18   50 49 0   32 1 53     1 99
617356 WA King   school 5300300 17408   Auburn School District 530030000698 4417 Ilalko Elementary School   Regular School No Elementary KG 05 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
617358 WA King   school 5300300 17408   Auburn School District 530030001744 4120 Lake View Elementary School   Regular School No Elementary PK 05 2017   grade_2 45 1 15   0 1     1   5   36 32 0   9   2   32       1.0 68 45 1 15   0 1     1   5   36 32 0   9 2 32     1 68
617359 WA King   school 5300300 17408   Auburn School District 530030001744 4120 Lake View Elementary School   Regular School No Elementary PK 05 2017   grade_3 43 1 7   0 4     0   8   37 26 0   6   0   32       2.0 63 43 1 7   0 4     0   8   37 26 0   6 0 32     2 63
617360 WA King   school 5300300 17408   Auburn School District 530030001744 4120 Lake View Elementary School   Regular School No Elementary PK 05 2017   grade_4 59 1 14   0 3     0   3   42 38 0   4   0   30       4.0 80 59 1 14   0 3     0   3   42 38 0   4 0 30     4 80
617363 WA King   school 5300300 17408   Auburn School District 530030001744 4120 Lake View Elementary School   Regular School No Elementary PK 05 2017   kindergarten 40 0 10   0 0     0   7   27 30 0   8   0   24       0.0 57 40 0 10   0 0     0   7   27 30 0   8 0 24     0 57
617364 WA King   school 5300300 17408   Auburn School District 530030001744 4120 Lake View Elementary School   Regular School No Elementary PK 05 2017   pre_kindergarten 20 0 6   0 0     0   4   21 9 0   0   0   11       0.0 30 20 0 6   0 0     0   4   21 9 0   0 0 11     0 30
617369 WA King   school 5300300 17408   Auburn School District 530030003063 5051 Lakeland Hills Elementary   Regular School No Elementary KG 05 2017   grade_5 60 7 21   0 8     2   21   61 58 0   4   0   27       5.0 119 60 7 21   0 8     2   21   61 58 0   4 0 27     5 119
617372 WA King   school 5300300 17408   Auburn School District 530030000036 3525 Lea Hill Elementary School   Regular School No Elementary PK 05 2017   grade_1 17 15 10   0 10     1   13   33 33 0   19   1   43       1.0 66 17 15 10   0 10     1   13   33 33 0   19 1 43     1 66
617373 WA King   school 5300300 17408   Auburn School District 530030000036 3525 Lea Hill Elementary School   Regular School No Elementary PK 05 2017   grade_2 37 17 9   0 5     4   13   44 41 0   20   3   54       0.0 85 37 17 9   0 5     4   13   44 41 0   20 3 54     0 85
617375 WA King   school 5300300 17408   Auburn School District 530030000036 3525 Lea Hill Elementary School   Regular School No Elementary PK 05 2017   grade_4 17 12 13   0 5     1   5   32 21 0   7   2   35       0.0 53 17 12 13   0 5     1   5   32 21 0   7 2 35     0 53
617378 WA King   school 5300300 17408   Auburn School District 530030000036 3525 Lea Hill Elementary School   Regular School No Elementary PK 05 2017   kindergarten 36 11 9   0 9     2   10   30 47 0   20   1   44       0.0 77 36 11 9   0 9     2   10   30 47 0   20 1 44     0 77
617379 WA King   school 5300300 17408   Auburn School District 530030000036 3525 Lea Hill Elementary School   Regular School No Elementary PK 05 2017   pre_kindergarten 33 13 24   0 12     0   20   59 43 0   0   0   50       0.0 102 33 13 24   0 12     0   20   59 43 0   0 0 50     0 102
617388 WA King   school 5300300 17408   Auburn School District 530030000039 3227 Pioneer Elementary School   Regular School No Elementary PK 05 2017   grade_1 15 3 52   0 5     8   5   57 31 0   56   1   75       0.0 88 15 3 52   0 5     8   5   57 31 0   56 1 75     0 88
617389 WA King   school 5300300 17408   Auburn School District 530030000039 3227 Pioneer Elementary School   Regular School No Elementary PK 05 2017   grade_2 11 5 60   0 0     4   7   45 42 0   57   0   77       0.0 87 11 5 60   0 0     4   7   45 42 0   57 0 77     0 87
617390 WA King   school 5300300 17408   Auburn School District 530030000039 3227 Pioneer Elementary School   Regular School No Elementary PK 05 2017   grade_3 11 0 60   0 6     15   1   44 49 0   58   1   86       1.0 93 11 0 60   0 6     15   1   44 49 0   58 1 86     1 93
617391 WA King   school 5300300 17408   Auburn School District 530030000039 3227 Pioneer Elementary School   Regular School No Elementary PK 05 2017   grade_4 11 2 47   0 1     2   12   37 38 0   32   2   67       1.0 75 11 2 47   0 1     2   12   37 38 0   32 2 67     1 75
617392 WA King   school 5300300 17408   Auburn School District 530030000039 3227 Pioneer Elementary School   Regular School No Elementary PK 05 2017   grade_5 13 3 40   0 1     11   4   36 36 0   32   2   63       1.0 72 13 3 40   0 1     11   4   36 36 0   32 2 63     1 72
617393 WA King   school 5300300 17408   Auburn School District 530030000039 3227 Pioneer Elementary School   Regular School No Elementary PK 05 2017   pk_12_total 87 24 355   0 17     50   36   306 263 0   295   7   507       4.0 569 87 24 355   0 17     50   36   306 263 0   295 7 507     4 569
617394 WA King   school 5300300 17408   Auburn School District 530030000039 3227 Pioneer Elementary School   Regular School No Elementary PK 05 2017   kindergarten_half_day 1 0 1   0 0     0   1   1 2 0   2   0   3       0.0 3 1 0 1   0 0     0   1   1 2 0   2 0 3     0 3
617395 WA King   school 5300300 17408   Auburn School District 530030000039 3227 Pioneer Elementary School   Regular School No Elementary PK 05 2017   kindergarten 16 1 49   0 2     4   2   43 31 0   53   1   62       1.0 74 16 1 49   0 2     4   2   43 31 0   53 1 62     1 74
617396 WA King   school 5300300 17408   Auburn School District 530030000039 3227 Pioneer Elementary School   Regular School No Elementary PK 05 2017   pre_kindergarten 9 10 46   0 2     6   4   43 34 0   5   0   74       0.0 77 9 10 46   0 2     6   4   43 34 0   5 0 74     0 77
617398 WA King   school 5300300 17408   Auburn School District 530030002434 4385 Rainier Middle School   Regular School No Middle 06 08 2017   grade_7 154 21 64   0 33     5   24   153 148 0   19   4   147       10.0 301 154 21 64   0 33     5   24   153 148 0   19 4 147     10 301
617401 WA King   school 5300300 17408   Auburn School District 530030002904 1915 Special Ed School   Special Education School No Other PK 12 2017   grade_10 1 0 0   0 0     0   0   1 0 0   0   0   0       0.0 1 1 0 0   0 0     0   0   1 0 0   0 0 0     0 1
617402 WA King   school 5300300 17408   Auburn School District 530030002904 1915 Special Ed School   Special Education School No Other PK 12 2017   grade_11 0 0 0   0 0     1   0   1 0 0   0   0   1       0.0 1 0 0 0   0 0     1   0   1 0 0   0 0 1     0 1
617403 WA King   school 5300300 17408   Auburn School District 530030002904 1915 Special Ed School   Special Education School No Other PK 12 2017   grade_1 1 1 0   0 0     0   0   1 1 0   0   0   0       0.0 2 1 1 0   0 0     0   0   1 1 0   0 0 0     0 2
617404 WA King   school 5300300 17408   Auburn School District 530030002904 1915 Special Ed School   Special Education School No Other PK 12 2017   grade_2 1 0 0   0 0     0   0   1 0 0   0   0   1       0.0 1 1 0 0   0 0     0   0   1 0 0   0 0 1     0 1
617405 WA King   school 5300300 17408   Auburn School District 530030002904 1915 Special Ed School   Special Education School No Other PK 12 2017   grade_3 1 0 0   0 0     0   0   1 0 0   0   0   0       0.0 1 1 0 0   0 0     0   0   1 0 0   0 0 0     0 1
617406 WA King   school 5300300 17408   Auburn School District 530030002904 1915 Special Ed School   Special Education School No Other PK 12 2017   grade_4 1 0 0   0 0     0   0   1 0 0   0   0   0       0.0 1 1 0 0   0 0     0   0   1 0 0   0 0 0     0 1
617407 WA King   school 5300300 17408   Auburn School District 530030002904 1915 Special Ed School   Special Education School No Other PK 12 2017   grade_5 0 1 0   0 0     0   0   0 1 0   0   0   1       0.0 1 0 1 0   0 0     0   0   0 1 0   0 0 1     0 1
617408 WA King   school 5300300 17408   Auburn School District 530030002904 1915 Special Ed School   Special Education School No Other PK 12 2017   grade_6 1 0 0   0 1     0   0   1 1 0   0   0   0       0.0 2 1 0 0   0 1     0   0   1 1 0   0 0 0     0 2
617409 WA King   school 5300300 17408   Auburn School District 530030002904 1915 Special Ed School   Special Education School No Other PK 12 2017   grade_8 3 0 0   0 0     0   0   1 2 0   0   0   0       1.0 3 3 0 0   0 0     0   0   1 2 0   0 0 0     1 3
617411 WA King   school 5300300 17408   Auburn School District 530030002904 1915 Special Ed School   Special Education School No Other PK 12 2017   kindergarten_half_day 2 0 0   0 1     0   0   3 0 0   0   0   0       0.0 3 2 0 0   0 1     0   0   3 0 0   0 0 0     0 3
617413 WA King   school 5300300 17408   Auburn School District 530030000041 2659 Terminal Park Elementary School   Regular School No Elementary KG 05 2017   grade_1 34 7 16   0 0     7   12   41 35 0   22   1   58       0.0 76 34 7 16   0 0     7   12   41 35 0   22 1 58     0 76
617414 WA King   school 5300300 17408   Auburn School District 530030000041 2659 Terminal Park Elementary School   Regular School No Elementary KG 05 2017   grade_2 19 9 16   0 1     11   11   29 38 0   26   1   53       0.0 67 19 9 16   0 1     11   11   29 38 0   26 1 53     0 67
617415 WA King   school 5300300 17408   Auburn School District 530030000041 2659 Terminal Park Elementary School   Regular School No Elementary KG 05 2017   grade_3 24 10 27   0 3     11   8   29 54 0   25   3   69       1.0 83 24 10 27   0 3     11   8   29 54 0   25 3 69     1 83
617416 WA King   school 5300300 17408   Auburn School District 530030000041 2659 Terminal Park Elementary School   Regular School No Elementary KG 05 2017   grade_4 28 10 19   0 7     7   11   43 39 0   18   0   57       4.0 82 28 10 19   0 7     7   11   43 39 0   18 0 57     4 82
617417 WA King   school 5300300 17408   Auburn School District 530030000041 2659 Terminal Park Elementary School   Regular School No Elementary KG 05 2017   grade_5 32 8 12   0 15     5   12   45 39 0   13   2   47       2.0 84 32 8 12   0 15     5   12   45 39 0   13 2 47     2 84
617420 WA King   school 5300300 17408   Auburn School District 530030000041 2659 Terminal Park Elementary School   Regular School No Elementary KG 05 2017   pre_kindergarten 9 4 20   0 0     0   3   20 16 0   0   0   36       0.0 36 9 4 20   0 0     0   3   20 16 0   0 0 36     0 36
617421 WA King   school 5300300 17408   Auburn School District 530030000042 2326 Washington Elementary School   Regular School No Elementary KG 05 2017   grade_1 31 5 39   0 4     2   15   48 48 0   24   3   73       4.0 96 31 5 39   0 4     2   15   48 48 0   24 3 73     4 96
617422 WA King   school 5300300 17408   Auburn School District 530030000042 2326 Washington Elementary School   Regular School No Elementary KG 05 2017   grade_2 19 7 33   0 4     6   13   35 47 0   26   3   63       3.0 82 19 7 33   0 4     6   13   35 47 0   26 3 63     3 82
617424 WA King   school 5300300 17408   Auburn School District 530030000042 2326 Washington Elementary School   Regular School No Elementary KG 05 2017   grade_4 20 3 27   0 3     10   9   44 28 0   18   1   61       3.0 72 20 3 27   0 3     10   9   44 28 0   18 1 61     3 72
617425 WA King   school 5300300 17408   Auburn School District 530030000042 2326 Washington Elementary School   Regular School No Elementary KG 05 2017   grade_5 22 12 31   0 2     2   17   43 43 0   18   3   67       2.0 86 22 12 31   0 2     2   17   43 43 0   18 3 67     2 86
617427 WA King   school 5300300 17408   Auburn School District 530030000042 2326 Washington Elementary School   Regular School No Elementary KG 05 2017   kindergarten 28 5 30   0 2     9   7   45 36 0   22   0   58       0.0 81 28 5 30   0 2     9   7   45 36 0   22 0 58     0 81
617428 WA King   school 5300300 17408   Auburn School District 530030000042 2326 Washington Elementary School   Regular School No Elementary KG 05 2017   pre_kindergarten 1 0 0   0 0     0   0   1 0 0   0   0   1       0.0 1 1 0 0   0 0     0   0   1 0 0   0 0 1     0 1

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