Data source: Big Local News · About: Big Local

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

View and edit SQL

grade

year

  • 2017 · 15,758
Link rowid state county county_state_id admin_level district_nces_id district_state_id district_state_type district school_nces_id school_state_id school school_state_type ccd_school_type ccd_charter_school ccd_school_lvl ccd_school_low_grade ▲ ccd_school_high_grade year term grade white black hispanic native_american native_american_alaskan_native asian native_hawaiian asian_pacific_islander native_hawaiian_pacific_islander pacific_islander multiracial unknown_race male female non_binary unknown_gender ell ell_percent homeless homeless_percent low_income free_and_reduced free_and_reduced_percent disability section_504 total white_int black_int hispanic_int native_american_int native_american_alaskan_native_int asian_int native_hawaiian_int asian_pacific_islander_int native_hawaiian_pacific_islander_int pacific_islander_int multiracial_int unknown_race_int male_int female_int non_binary_int unknown_gender_int ell_int homeless_int low_income_int free_and_reduced_int disability_int section_504_int total_int
617041 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000001 2834 A J West Elementary   Regular School No Elementary PK 06 2017   grade_1 26 1 22   1 0     0   5   25 30 0   14   4   49       1.0 55 26 1 22   1 0     0   5   25 30 0   14 4 49     1 55
617042 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000001 2834 A J West Elementary   Regular School No Elementary PK 06 2017   grade_2 38 0 38   3 0     0   5   42 42 0   24   4   71       0.0 84 38 0 38   3 0     0   5   42 42 0   24 4 71     0 84
617043 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000001 2834 A J West Elementary   Regular School No Elementary PK 06 2017   grade_3 19 0 19   3 1     0   3   24 21 0   10   3   37       2.0 45 19 0 19   3 1     0   3   24 21 0   10 3 37     2 45
617044 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000001 2834 A J West Elementary   Regular School No Elementary PK 06 2017   grade_4 38 0 22   0 2     0   2   29 35 0   9   4   51       4.0 64 38 0 22   0 2     0   2   29 35 0   9 4 51     4 64
617045 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000001 2834 A J West Elementary   Regular School No Elementary PK 06 2017   grade_5 24 1 21   2 0     0   4   28 24 0   11   2   39       1.0 52 24 1 21   2 0     0   4   28 24 0   11 2 39     1 52
617046 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000001 2834 A J West Elementary   Regular School No Elementary PK 06 2017   grade_6 16 0 19   1 1     0   3   24 16 0   6   1   33       0.0 40 16 0 19   1 1     0   3   24 16 0   6 1 33     0 40
617047 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000001 2834 A J West Elementary   Regular School No Elementary PK 06 2017   grade_7 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
617048 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000001 2834 A J West Elementary   Regular School No Elementary PK 06 2017   pk_12_total 203 3 174   11 4     0   31   219 207 0   91   23   348       8.0 426 203 3 174   11 4     0   31   219 207 0   91 23 348     8 426
617049 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000001 2834 A J West Elementary   Regular School No Elementary PK 06 2017   kindergarten 30 0 23   1 0     0   7   32 29 0   16   5   47       0.0 61 30 0 23   1 0     0   7   32 29 0   16 5 47     0 61
617050 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000001 2834 A J West Elementary   Regular School No Elementary PK 06 2017   pre_kindergarten 12 1 9   0 0     0   2   15 9 0   0   0   20       0.0 24 12 1 9   0 0     0   2   15 9 0   0 0 20     0 24
617071 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003002271 3154 Hopkins Elementary   Regular School No Elementary PK PK 2017   pk_12_total 53 0 34   2 0     1   10   54 46 0   0   6   84       0.0 100 53 0 34   2 0     1   10   54 46 0   0 6 84     0 100
617072 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003002271 3154 Hopkins Elementary   Regular School No Elementary PK PK 2017   pre_kindergarten 53 0 34   2 0     1   10   54 46 0   0   6   84       0.0 100 53 0 34   2 0     1   10   54 46 0   0 6 84     0 100
617092 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000010 2763 Robert Gray Elementary   Regular School No Elementary PK 06 2017   grade_1 26 0 23   1 1     0   4   29 26 0   17   4   47       1.0 55 26 0 23   1 1     0   4   29 26 0   17 4 47     1 55
617093 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000010 2763 Robert Gray Elementary   Regular School No Elementary PK 06 2017   grade_2 22 0 19   1 0     1   4   26 21 0   14   1   36       1.0 47 22 0 19   1 0     1   4   26 21 0   14 1 36     1 47
617094 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000010 2763 Robert Gray Elementary   Regular School No Elementary PK 06 2017   grade_3 31 0 25   1 0     0   2   28 31 0   14   4   52       2.0 59 31 0 25   1 0     0   2   28 31 0   14 4 52     2 59
617095 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000010 2763 Robert Gray Elementary   Regular School No Elementary PK 06 2017   grade_4 19 1 21   1 1     0   4   23 24 0   8   2   36       2.0 47 19 1 21   1 1     0   4   23 24 0   8 2 36     2 47
617096 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000010 2763 Robert Gray Elementary   Regular School No Elementary PK 06 2017   grade_5 29 0 15   2 0     0   7   25 28 0   7   2   42       2.0 53 29 0 15   2 0     0   7   25 28 0   7 2 42     2 53
617097 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000010 2763 Robert Gray Elementary   Regular School No Elementary PK 06 2017   grade_6 19 0 18   1 0     0   3   15 26 0   8   2   27       3.0 41 19 0 18   1 0     0   3   15 26 0   8 2 27     3 41
617098 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000010 2763 Robert Gray Elementary   Regular School No Elementary PK 06 2017   pk_12_total 172 1 149   9 2     1   28   175 187 0   78   21   288       11.0 362 172 1 149   9 2     1   28   175 187 0   78 21 288     11 362
617099 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000010 2763 Robert Gray Elementary   Regular School No Elementary PK 06 2017   kindergarten 18 0 21   1 0     0   2   19 23 0   10   4   33       0.0 42 18 0 21   1 0     0   2   19 23 0   10 4 33     0 42
617100 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000010 2763 Robert Gray Elementary   Regular School No Elementary PK 06 2017   pre_kindergarten 8 0 7   1 0     0   2   10 8 0   0   2   15       0.0 18 8 0 7   1 0     0   2   10 8 0   0 2 15     0 18
617101 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000011 2971 Stevens Elementary School   Regular School No Elementary PK 06 2017   grade_1 36 1 19   0 0     0   6   24 38 0   12   3   47       0.0 62 36 1 19   0 0     0   6   24 38 0   12 3 47     0 62
617102 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000011 2971 Stevens Elementary School   Regular School No Elementary PK 06 2017   grade_2 34 2 22   0 2     0   4   36 28 0   16   5   55       1.0 64 34 2 22   0 2     0   4   36 28 0   16 5 55     1 64
617103 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000011 2971 Stevens Elementary School   Regular School No Elementary PK 06 2017   grade_3 47 1 28   3 5     0   15   52 47 0   20   2   76       1.0 99 47 1 28   3 5     0   15   52 47 0   20 2 76     1 99
617104 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000011 2971 Stevens Elementary School   Regular School No Elementary PK 06 2017   grade_4 33 0 24   1 3     0   3   30 34 0   14   4   50       1.0 64 33 0 24   1 3     0   3   30 34 0   14 4 50     1 64
617105 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000011 2971 Stevens Elementary School   Regular School No Elementary PK 06 2017   grade_5 31 2 25   6 4     0   5   41 32 0   14   5   53       0.0 73 31 2 25   6 4     0   5   41 32 0   14 5 53     0 73
617106 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000011 2971 Stevens Elementary School   Regular School No Elementary PK 06 2017   grade_6 30 0 28   6 1     0   3   44 24 0   15   2   50       0.0 68 30 0 28   6 1     0   3   44 24 0   15 2 50     0 68
617107 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000011 2971 Stevens Elementary School   Regular School No Elementary PK 06 2017   pk_12_total 255 6 189   17 17     0   54   288 250 0   112   32   420       3.0 538 255 6 189   17 17     0   54   288 250 0   112 32 420     3 538
617108 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000011 2971 Stevens Elementary School   Regular School No Elementary PK 06 2017   kindergarten 29 0 26   1 0     0   6   32 30 0   21   4   50       0.0 62 29 0 26   1 0     0   6   32 30 0   21 4 50     0 62
617109 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000011 2971 Stevens Elementary School   Regular School No Elementary PK 06 2017   pre_kindergarten 15 0 17   0 2     0   12   29 17 0   0   7   39       0.0 46 15 0 17   0 2     0   12   29 17 0   0 7 39     0 46
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
617181 WA Skagit   school 5300150 29103   Anacortes School District 530015000021 3404 Whitney Early Childhood Education Center   Regular School No Elementary PK KG 2017   pk_12_total 133 1 21   2 3     0   0   101 59 0   7   0   31       1.0 160 133 1 21   2 3     0   0   101 59 0   7 0 31     1 160
617182 WA Skagit   school 5300150 29103   Anacortes School District 530015000021 3404 Whitney Early Childhood Education Center   Regular School No Elementary PK KG 2017   kindergarten_half_day 1 0 0   0 0     0   0   0 1 0   0   0   0       0.0 1 1 0 0   0 0     0   0   0 1 0   0 0 0     0 1
617183 WA Skagit   school 5300150 29103   Anacortes School District 530015000021 3404 Whitney Early Childhood Education Center   Regular School No Elementary PK KG 2017   kindergarten 71 1 14   1 1     0   0   50 38 0   7   0   29       1.0 88 71 1 14   1 1     0   0   50 38 0   7 0 29     1 88
617184 WA Skagit   school 5300150 29103   Anacortes School District 530015000021 3404 Whitney Early Childhood Education Center   Regular School No Elementary PK KG 2017   pre_kindergarten 61 0 7   1 2     0   0   51 20 0   0   0   2       0.0 71 61 0 7   1 2     0   0   51 20 0   0 0 2     0 71
617190 WA Snohomish   school 5300240 31016   Arlington School District 530024003065 2277 Arlington Special Educ School   Regular School No Other PK 12 2017   grade_1 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
617191 WA Snohomish   school 5300240 31016   Arlington School District 530024003065 2277 Arlington Special Educ School   Regular School No Other PK 12 2017   grade_2 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
617192 WA Snohomish   school 5300240 31016   Arlington School District 530024003065 2277 Arlington Special Educ School   Regular 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
617193 WA Snohomish   school 5300240 31016   Arlington School District 530024003065 2277 Arlington Special Educ School   Regular 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
617194 WA Snohomish   school 5300240 31016   Arlington School District 530024003065 2277 Arlington Special Educ School   Regular School No Other PK 12 2017   pk_12_total 52 0 9   2 0     0   0   44 19 0   0   1   19       0.0 63 52 0 9   2 0     0   0   44 19 0   0 1 19     0 63
617195 WA Snohomish   school 5300240 31016   Arlington School District 530024003065 2277 Arlington Special Educ School   Regular School No Other PK 12 2017   pre_kindergarten 48 0 9   2 0     0   0   40 19 0   0   1   19       0.0 59 48 0 9   2 0     0   0   40 19 0   0 1 19     0 59
617230 WA Snohomish   school 5300240 31016   Arlington School District 530024001815 4154 Presidents Elementary   Regular School No Elementary PK 05 2017   grade_1 71 0 11   0 2     0   5   53 36 0   5   5   38       0.0 89 71 0 11   0 2     0   5   53 36 0   5 5 38     0 89
617231 WA Snohomish   school 5300240 31016   Arlington School District 530024001815 4154 Presidents Elementary   Regular School No Elementary PK 05 2017   grade_2 58 0 10   1 0     0   9   44 34 0   2   3   31       1.0 78 58 0 10   1 0     0   9   44 34 0   2 3 31     1 78
617232 WA Snohomish   school 5300240 31016   Arlington School District 530024001815 4154 Presidents Elementary   Regular School No Elementary PK 05 2017   grade_3 64 0 11   0 0     0   7   44 38 0   4   6   37       1.0 82 64 0 11   0 0     0   7   44 38 0   4 6 37     1 82
617233 WA Snohomish   school 5300240 31016   Arlington School District 530024001815 4154 Presidents Elementary   Regular School No Elementary PK 05 2017   grade_4 80 0 7   1 0     0   10   46 52 0   6   2   35       1.0 98 80 0 7   1 0     0   10   46 52 0   6 2 35     1 98
617234 WA Snohomish   school 5300240 31016   Arlington School District 530024001815 4154 Presidents Elementary   Regular School No Elementary PK 05 2017   grade_5 63 0 19   2 0     0   5   53 36 0   8   0   39       0.0 89 63 0 19   2 0     0   5   53 36 0   8 0 39     0 89
617235 WA Snohomish   school 5300240 31016   Arlington School District 530024001815 4154 Presidents Elementary   Regular School No Elementary PK 05 2017   pk_12_total 407 2 75   4 3     0   42   294 239 0   28   17   209       3.0 533 407 2 75   4 3     0   42   294 239 0   28 17 209     3 533
617236 WA Snohomish   school 5300240 31016   Arlington School District 530024001815 4154 Presidents Elementary   Regular School No Elementary PK 05 2017   kindergarten_half_day 4 0 1   0 0     0   0   1 4 0   1   0   0       0.0 5 4 0 1   0 0     0   0   1 4 0   1 0 0     0 5
617237 WA Snohomish   school 5300240 31016   Arlington School District 530024001815 4154 Presidents Elementary   Regular School No Elementary PK 05 2017   kindergarten 48 0 10   0 0     0   4   30 32 0   2   1   20       0.0 62 48 0 10   0 0     0   4   30 32 0   2 1 20     0 62
617238 WA Snohomish   school 5300240 31016   Arlington School District 530024001815 4154 Presidents Elementary   Regular School No Elementary PK 05 2017   pre_kindergarten 19 2 6   0 1     0   2   23 7 0   0   0   9       0.0 30 19 2 6   0 1     0   2   23 7 0   0 0 9     0 30
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
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
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
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
617357 WA King   school 5300300 17408   Auburn School District 530030001744 4120 Lake View Elementary School   Regular School No Elementary PK 05 2017   grade_1 53 2 6   1 1     0   8   34 37 0   2   1   28       0.0 71 53 2 6   1 1     0   8   34 37 0   2 1 28     0 71

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