Data source: Big Local News · About: Big Local

15,474 rows where state = "WA" and year = 2019 sorted by ccd_school_low_grade descending

View and edit SQL

grade

year

  • 2019 · 15,474
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
2412992 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000001 2834 A J West Elementary   Regular School No Elementary PK 06 2019   grade_1 24 1 26   0 0     0   4   29 26 0   13   4   45       2.0 55 24 1 26   0 0     0   4   29 26 0   13 4 45     2 55
2412993 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000001 2834 A J West Elementary   Regular School No Elementary PK 06 2019   grade_2 31 0 19   0 0     0   8   29 29 0   12   2   46       2.0 58 31 0 19   0 0     0   8   29 29 0   12 2 46     2 58
2412994 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000001 2834 A J West Elementary   Regular School No Elementary PK 06 2019   grade_3 25 0 23   0 0     0   3   26 25 0   13   2   37       3.0 51 25 0 23   0 0     0   3   26 25 0   13 2 37     3 51
2412995 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000001 2834 A J West Elementary   Regular School No Elementary PK 06 2019   grade_4 34 1 32   3 0     0   5   33 42 0   17   3   61       3.0 75 34 1 32   3 0     0   5   33 42 0   17 3 61     3 75
2412996 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000001 2834 A J West Elementary   Regular School No Elementary PK 06 2019   grade_5 18 0 25   3 1     0   3   28 22 0   12   1   36       2.0 50 18 0 25   3 1     0   3   28 22 0   12 1 36     2 50
2412997 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000001 2834 A J West Elementary   Regular School No Elementary PK 06 2019   grade_6 29 1 24   0 1     0   3   24 34 0   7   3   50       7.0 58 29 1 24   0 1     0   3   24 34 0   7 3 50     7 58
2412998 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000001 2834 A J West Elementary   Regular School No Elementary PK 06 2019   grade_7 0 0 1   0 0     0   0   1 0 0   1   0   1       0.0 1 0 0 1   0 0     0   0   1 0 0   1 0 1     0 1
2412999 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000001 2834 A J West Elementary   Regular School No Elementary PK 06 2019   pk_12_total 190 4 195   9 3     0   33   207 227 0   93   22   345       20.0 434 190 4 195   9 3     0   33   207 227 0   93 22 345     20 434
2413000 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000001 2834 A J West Elementary   Regular School No Elementary PK 06 2019   kindergarten 20 1 35   2 1     0   4   25 38 0   18   6   49       1.0 63 20 1 35   2 1     0   4   25 38 0   18 6 49     1 63
2413001 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000001 2834 A J West Elementary   Regular School No Elementary PK 06 2019   pre_kindergarten 9 0 10   1 0     0   3   12 11 0   0   1   20       0.0 23 9 0 10   1 0     0   3   12 11 0   0 1 20     0 23
2413027 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003002271 3154 Hopkins Elementary   Regular School No Prekindergarten PK PK 2019   pk_12_total 75 1 36   2 0     0   13   67 60 0   0   3   106       0.0 127 75 1 36   2 0     0   13   67 60 0   0 3 106     0 127
2413028 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003002271 3154 Hopkins Elementary   Regular School No Prekindergarten PK PK 2019   pre_kindergarten 75 1 36   2 0     0   13   67 60 0   0   3   106       0.0 127 75 1 36   2 0     0   13   67 60 0   0 3 106     0 127
2413046 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000010 2763 Robert Gray Elementary   Regular School No Elementary PK 06 2019   grade_1 21 0 17   0 0     0   6   23 21 0   10   2   38       0.0 44 21 0 17   0 0     0   6   23 21 0   10 2 38     0 44
2413047 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000010 2763 Robert Gray Elementary   Regular School No Elementary PK 06 2019   grade_2 25 0 18   0 0     0   1   22 22 0   8   1   34       3.0 44 25 0 18   0 0     0   1   22 22 0   8 1 34     3 44
2413048 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000010 2763 Robert Gray Elementary   Regular School No Elementary PK 06 2019   grade_3 27 0 22   0 1     0   2   24 28 0   11   2   44       4.0 52 27 0 22   0 1     0   2   24 28 0   11 2 44     4 52
2413049 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000010 2763 Robert Gray Elementary   Regular School No Elementary PK 06 2019   grade_4 19 0 20   2 0     1   5   24 23 0   13   1   31       1.0 47 19 0 20   2 0     1   5   24 23 0   13 1 31     1 47
2413050 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000010 2763 Robert Gray Elementary   Regular School No Elementary PK 06 2019   grade_5 33 0 26   1 0     0   3   30 33 0   13   5   55       4.0 63 33 0 26   1 0     0   3   30 33 0   13 5 55     4 63
2413051 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000010 2763 Robert Gray Elementary   Regular School No Elementary PK 06 2019   grade_6 23 0 23   1 1     0   3   29 22 0   7   4   40       3.0 51 23 0 23   1 1     0   3   29 22 0   7 4 40     3 51
2413052 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000010 2763 Robert Gray Elementary   Regular School No Elementary PK 06 2019   pk_12_total 175 0 140   5 2     1   22   176 169 0   71   18   281       15.0 345 175 0 140   5 2     1   22   176 169 0   71 18 281     15 345
2413053 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000010 2763 Robert Gray Elementary   Regular School No Elementary PK 06 2019   kindergarten 27 0 14   1 0     0   2   24 20 0   9   3   39       0.0 44 27 0 14   1 0     0   2   24 20 0   9 3 39     0 44
2413054 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000011 2971 Stevens Elementary School   Regular School No Elementary PK 06 2019   grade_1 26 0 19   0 1     0   14   32 28 0   13   6   48       0.0 60 26 0 19   0 1     0   14   32 28 0   13 6 48     0 60
2413055 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000011 2971 Stevens Elementary School   Regular School No Elementary PK 06 2019   grade_2 27 0 26   1 0     0   7   28 33 0   25   4   55       0.0 61 27 0 26   1 0     0   7   28 33 0   25 4 55     0 61
2413056 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000011 2971 Stevens Elementary School   Regular School No Elementary PK 06 2019   grade_3 35 0 23   0 0     0   6   31 33 0   13   1   53       0.0 64 35 0 23   0 0     0   6   31 33 0   13 1 53     0 64
2413057 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000011 2971 Stevens Elementary School   Regular School No Elementary PK 06 2019   grade_4 32 2 23   0 2     0   4   39 24 0   10   5   56       1.0 63 32 2 23   0 2     0   4   39 24 0   10 5 56     1 63
2413058 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000011 2971 Stevens Elementary School   Regular School No Elementary PK 06 2019   grade_5 50 1 26   2 5     0   14   49 49 0   12   1   77       3.0 98 50 1 26   2 5     0   14   49 49 0   12 1 77     3 98
2413059 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000011 2971 Stevens Elementary School   Regular School No Elementary PK 06 2019   grade_6 37 0 24   2 3     0   3   30 39 0   2   7   57       3.0 69 37 0 24   2 3     0   3   30 39 0   2 7 57     3 69
2413060 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000011 2971 Stevens Elementary School   Regular School No Elementary PK 06 2019   pk_12_total 255 7 179   6 12     0   54   266 247 0   87   32   425       8.0 513 255 7 179   6 12     0   54   266 247 0   87 32 425     8 513
2413061 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000011 2971 Stevens Elementary School   Regular School No Elementary PK 06 2019   kindergarten 26 2 21   1 0     0   4   27 27 0   12   4   44       1.0 54 26 2 21   1 0     0   4   27 27 0   12 4 44     1 54
2413062 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000011 2971 Stevens Elementary School   Regular School No Elementary PK 06 2019   pre_kindergarten 22 2 17   0 1     0   2   30 14 0   0   4   35       0.0 44 22 2 17   0 1     0   2   30 14 0   0 4 35     0 44
2413066 WA Lewis   school 5300060 21226   Adna School District 530006000012 2227 Adna Elementary School   Regular School No Elementary PK 05 2019   grade_1 35 1 1   0 1     0   1   15 24 0   0   2   6       0.0 39 35 1 1   0 1     0   1   15 24 0   0 2 6     0 39
2413067 WA Lewis   school 5300060 21226   Adna School District 530006000012 2227 Adna Elementary School   Regular School No Elementary PK 05 2019   grade_2 37 1 2   0 0     0   0   15 25 0   0   1   14       0.0 40 37 1 2   0 0     0   0   15 25 0   0 1 14     0 40
2413068 WA Lewis   school 5300060 21226   Adna School District 530006000012 2227 Adna Elementary School   Regular School No Elementary PK 05 2019   grade_3 29 1 1   1 0     0   0   14 18 0   0   1   7       0.0 32 29 1 1   1 0     0   0   14 18 0   0 1 7     0 32
2413069 WA Lewis   school 5300060 21226   Adna School District 530006000012 2227 Adna Elementary School   Regular School No Elementary PK 05 2019   grade_4 46 3 2   1 0     0   0   28 24 0   0   1   17       0.0 52 46 3 2   1 0     0   0   28 24 0   0 1 17     0 52
2413070 WA Lewis   school 5300060 21226   Adna School District 530006000012 2227 Adna Elementary School   Regular School No Elementary PK 05 2019   grade_5 44 0 7   1 0     0   0   24 28 0   0   2   16       0.0 52 44 0 7   1 0     0   0   24 28 0   0 2 16     0 52
2413071 WA Lewis   school 5300060 21226   Adna School District 530006000012 2227 Adna Elementary School   Regular School No Elementary PK 05 2019   pk_12_total 223 6 15   3 1     0   2   111 139 0   0   7   66       0.0 250 223 6 15   3 1     0   2   111 139 0   0 7 66     0 250
2413072 WA Lewis   school 5300060 21226   Adna School District 530006000012 2227 Adna Elementary School   Regular School No Elementary PK 05 2019   kindergarten 29 0 2   0 0     0   0   12 19 0   0   0   5       0.0 31 29 0 2   0 0     0   0   12 19 0   0 0 5     0 31
2413073 WA Lewis   school 5300060 21226   Adna School District 530006000012 2227 Adna Elementary School   Regular School No Elementary PK 05 2019   pre_kindergarten 3 0 0   0 0     0   1   3 1 0   0   0   1       0.0 4 3 0 0   0 0     0   1   3 1 0   0 0 1     0 4
2413082 WA Lincoln   school 5300090 22017   Almira School District 530009000179 2860 Almira Elementary School   Regular School No Elementary PK 08 2019   grade_1 3 0 0   0 0     0   1   2 2 0   0   0   1       1.0 4 3 0 0   0 0     0   1   2 2 0   0 0 1     1 4
2413083 WA Lincoln   school 5300090 22017   Almira School District 530009000179 2860 Almira Elementary School   Regular School No Elementary PK 08 2019   grade_2 11 0 0   0 0     0   0   6 5 0   0   0   1       1.0 11 11 0 0   0 0     0   0   6 5 0   0 0 1     1 11
2413084 WA Lincoln   school 5300090 22017   Almira School District 530009000179 2860 Almira Elementary School   Regular School No Elementary PK 08 2019   grade_3 7 0 0   0 0     0   2   2 7 0   0   0   5       0.0 9 7 0 0   0 0     0   2   2 7 0   0 0 5     0 9
2413085 WA Lincoln   school 5300090 22017   Almira School District 530009000179 2860 Almira Elementary School   Regular School No Elementary PK 08 2019   grade_4 5 0 0   0 0     0   2   3 4 0   0   0   2       0.0 7 5 0 0   0 0     0   2   3 4 0   0 0 2     0 7
2413086 WA Lincoln   school 5300090 22017   Almira School District 530009000179 2860 Almira Elementary School   Regular School No Elementary PK 08 2019   grade_5 7 0 0   0 0     0   0   5 2 0   0   0   2       0.0 7 7 0 0   0 0     0   0   5 2 0   0 0 2     0 7
2413087 WA Lincoln   school 5300090 22017   Almira School District 530009000179 2860 Almira Elementary School   Regular School No Elementary PK 08 2019   grade_6 16 0 3   0 0     0   0   13 6 0   0   0   8       2.0 19 16 0 3   0 0     0   0   13 6 0   0 0 8     2 19
2413088 WA Lincoln   school 5300090 22017   Almira School District 530009000179 2860 Almira Elementary School   Regular School No Elementary PK 08 2019   grade_7 17 0 2   0 0     0   4   7 16 0   0   0   10       0.0 23 17 0 2   0 0     0   4   7 16 0   0 0 10     0 23
2413089 WA Lincoln   school 5300090 22017   Almira School District 530009000179 2860 Almira Elementary School   Regular School No Elementary PK 08 2019   grade_8 15 0 0   0 0     0   2   5 12 0   0   0   10       0.0 17 15 0 0   0 0     0   2   5 12 0   0 0 10     0 17
2413090 WA Lincoln   school 5300090 22017   Almira School District 530009000179 2860 Almira Elementary School   Regular School No Elementary PK 08 2019   pk_12_total 99 0 6   0 0     0   11   50 66 0   0   0   43       4.0 116 99 0 6   0 0     0   11   50 66 0   0 0 43     4 116
2413091 WA Lincoln   school 5300090 22017   Almira School District 530009000179 2860 Almira Elementary School   Regular School No Elementary PK 08 2019   kindergarten 10 0 1   0 0     0   0   3 8 0   0   0   2       0.0 11 10 0 1   0 0     0   0   3 8 0   0 0 2     0 11
2413092 WA Lincoln   school 5300090 22017   Almira School District 530009000179 2860 Almira Elementary School   Regular School No Elementary PK 08 2019   pre_kindergarten 8 0 0   0 0     0   0   4 4 0   0   0   2       0.0 8 8 0 0   0 0     0   0   4 4 0   0 0 2     0 8
2413128 WA Skagit   school 5300150 29103   Anacortes School District 530015000021 3404 Whitney Early Childhood Education Center   Regular School No Elementary PK KG 2019   pk_12_total 117 1 10   5 1     1   15   88 62 0   1   0   13       2.0 150 117 1 10   5 1     1   15   88 62 0   1 0 13     2 150
2413129 WA Skagit   school 5300150 29103   Anacortes School District 530015000021 3404 Whitney Early Childhood Education Center   Regular School No Elementary PK KG 2019   kindergarten 65 0 4   4 1     0   8   42 40 0   1   0   12       1.0 82 65 0 4   4 1     0   8   42 40 0   1 0 12     1 82
2413130 WA Skagit   school 5300150 29103   Anacortes School District 530015000021 3404 Whitney Early Childhood Education Center   Regular School No Elementary PK KG 2019   pre_kindergarten 52 1 6   1 0     1   7   46 22 0   0   0   1       1.0 68 52 1 6   1 0     1   7   46 22 0   0 0 1     1 68
2413139 WA Snohomish   school 5300240 31016   Arlington School District 530024003065 2277 Arlington Special Educ School   Regular School No Other PK 12 2019   grade_12 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
2413140 WA Snohomish   school 5300240 31016   Arlington School District 530024003065 2277 Arlington Special Educ School   Regular School No Other PK 12 2019   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
2413141 WA Snohomish   school 5300240 31016   Arlington School District 530024003065 2277 Arlington Special Educ School   Regular School No Other PK 12 2019   grade_2 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
2413142 WA Snohomish   school 5300240 31016   Arlington School District 530024003065 2277 Arlington Special Educ School   Regular School No Other PK 12 2019   pk_12_total 47 0 7   3 1     3   1   40 22 0   0   1   17       0.0 62 47 0 7   3 1     3   1   40 22 0   0 1 17     0 62
2413143 WA Snohomish   school 5300240 31016   Arlington School District 530024003065 2277 Arlington Special Educ School   Regular School No Other PK 12 2019   kindergarten 2 0 0   0 0     0   0   2 0 0   0   0   0       0.0 2 2 0 0   0 0     0   0   2 0 0   0 0 0     0 2
2413144 WA Snohomish   school 5300240 31016   Arlington School District 530024003065 2277 Arlington Special Educ School   Regular School No Other PK 12 2019   pre_kindergarten 42 0 7   3 1     3   1   36 21 0   0   1   17       0.0 57 42 0 7   3 1     3   1   36 21 0   0 1 17     0 57
2413158 WA Snohomish   school 5300240 31016   Arlington School District 530024001190 4436 Kent Prairie Elementary   Regular School No Elementary PK 05 2019   grade_1 74 1 12   1 1     0   18   48 59 0   8   1   50       2.0 107 74 1 12   1 1     0   18   48 59 0   8 1 50     2 107
2413159 WA Snohomish   school 5300240 31016   Arlington School District 530024001190 4436 Kent Prairie Elementary   Regular School No Elementary PK 05 2019   grade_2 84 0 12   2 2     1   11   63 49 0   8   3   37       2.0 112 84 0 12   2 2     1   11   63 49 0   8 3 37     2 112
2413160 WA Snohomish   school 5300240 31016   Arlington School District 530024001190 4436 Kent Prairie Elementary   Regular School No Elementary PK 05 2019   grade_3 85 0 14   0 1     0   12   56 56 0   7   2   58       2.0 112 85 0 14   0 1     0   12   56 56 0   7 2 58     2 112
2413161 WA Snohomish   school 5300240 31016   Arlington School District 530024001190 4436 Kent Prairie Elementary   Regular School No Elementary PK 05 2019   grade_4 84 0 17   0 1     1   18   68 53 0   4   1   43       2.0 121 84 0 17   0 1     1   18   68 53 0   4 1 43     2 121
2413162 WA Snohomish   school 5300240 31016   Arlington School District 530024001190 4436 Kent Prairie Elementary   Regular School No Elementary PK 05 2019   grade_5 97 0 17   1 1     0   14   70 60 0   7   2   58       7.0 130 97 0 17   1 1     0   14   70 60 0   7 2 58     7 130
2413163 WA Snohomish   school 5300240 31016   Arlington School District 530024001190 4436 Kent Prairie Elementary   Regular School No Elementary PK 05 2019   pk_12_total 547 2 97   4 7     3   90   378 372 0   42   14   346       15.0 750 547 2 97   4 7     3   90   378 372 0   42 14 346     15 750
2413164 WA Snohomish   school 5300240 31016   Arlington School District 530024001190 4436 Kent Prairie Elementary   Regular School No Elementary PK 05 2019   kindergarten 76 0 11   0 1     1   8   42 55 0   8   3   34       0.0 97 76 0 11   0 1     1   8   42 55 0   8 3 34     0 97
2413165 WA Snohomish   school 5300240 31016   Arlington School District 530024001190 4436 Kent Prairie Elementary   Regular School No Elementary PK 05 2019   pre_kindergarten 47 1 14   0 0     0   9   31 40 0   0   2   66       0.0 71 47 1 14   0 0     0   9   31 40 0   0 2 66     0 71
2413178 WA Snohomish   school 5300240 31016   Arlington School District 530024001815 4154 Presidents Elementary   Regular School No Elementary PK 05 2019   grade_1 66 0 12   0 0     0   5   41 42 0   6   0   27       1.0 83 66 0 12   0 0     0   5   41 42 0   6 0 27     1 83
2413179 WA Snohomish   school 5300240 31016   Arlington School District 530024001815 4154 Presidents Elementary   Regular School No Elementary PK 05 2019   grade_2 61 0 10   1 0     0   5   39 38 0   3   2   30       1.0 77 61 0 10   1 0     0   5   39 38 0   3 2 30     1 77
2413180 WA Snohomish   school 5300240 31016   Arlington School District 530024001815 4154 Presidents Elementary   Regular School No Elementary PK 05 2019   grade_3 68 0 9   1 2     0   6   49 37 0   3   0   27       2.0 86 68 0 9   1 2     0   6   49 37 0   3 0 27     2 86
2413181 WA Snohomish   school 5300240 31016   Arlington School District 530024001815 4154 Presidents Elementary   Regular School No Elementary PK 05 2019   grade_4 69 0 8   2 0     0   12   51 40 0   0   2   38       3.0 91 69 0 8   2 0     0   12   51 40 0   0 2 38     3 91
2413182 WA Snohomish   school 5300240 31016   Arlington School District 530024001815 4154 Presidents Elementary   Regular School No Elementary PK 05 2019   grade_5 70 0 12   0 0     0   8   47 43 0   6   2   42       5.0 90 70 0 12   0 0     0   8   47 43 0   6 2 42     5 90
2413183 WA Snohomish   school 5300240 31016   Arlington School District 530024001815 4154 Presidents Elementary   Regular School No Elementary PK 05 2019   pk_12_total 422 0 64   4 2     1   49   288 254 0   20   8   217       13.0 542 422 0 64   4 2     1   49   288 254 0   20 8 217     13 542
2413184 WA Snohomish   school 5300240 31016   Arlington School District 530024001815 4154 Presidents Elementary   Regular School No Elementary PK 05 2019   kindergarten 60 0 8   0 0     1   9   35 43 0   2   1   29       1.0 78 60 0 8   0 0     1   9   35 43 0   2 1 29     1 78
2413185 WA Snohomish   school 5300240 31016   Arlington School District 530024001815 4154 Presidents Elementary   Regular School No Elementary PK 05 2019   pre_kindergarten 28 0 5   0 0     0   4   26 11 0   0   1   24       0.0 37 28 0 5   0 0     0   4   26 11 0   0 1 24     0 37
2413201 WA Asotin   school 5300280 2420   Asotin-Anatone School District 530028000027 2507 Asotin Elementary   Regular School No Elementary PK 05 2019   grade_1 34 0 0   0 1     0   3   15 23 0   0   1   20       0.0 38 34 0 0   0 1     0   3   15 23 0   0 1 20     0 38
2413202 WA Asotin   school 5300280 2420   Asotin-Anatone School District 530028000027 2507 Asotin Elementary   Regular School No Elementary PK 05 2019   grade_2 44 0 4   0 0     0   1   29 20 0   0   0   18       1.0 49 44 0 4   0 0     0   1   29 20 0   0 0 18     1 49
2413203 WA Asotin   school 5300280 2420   Asotin-Anatone School District 530028000027 2507 Asotin Elementary   Regular School No Elementary PK 05 2019   grade_3 37 0 1   0 1     0   2   19 22 0   0   1   20       0.0 41 37 0 1   0 1     0   2   19 22 0   0 1 20     0 41
2413204 WA Asotin   school 5300280 2420   Asotin-Anatone School District 530028000027 2507 Asotin Elementary   Regular School No Elementary PK 05 2019   grade_4 37 0 2   0 0     0   3   23 19 0   0   0   15       3.0 42 37 0 2   0 0     0   3   23 19 0   0 0 15     3 42
2413205 WA Asotin   school 5300280 2420   Asotin-Anatone School District 530028000027 2507 Asotin Elementary   Regular School No Elementary PK 05 2019   grade_5 52 0 2   0 0     1   2   25 32 0   0   0   20       0.0 57 52 0 2   0 0     1   2   25 32 0   0 0 20     0 57
2413206 WA Asotin   school 5300280 2420   Asotin-Anatone School District 530028000027 2507 Asotin Elementary   Regular School No Elementary PK 05 2019   pk_12_total 288 0 13   0 3     1   12   160 157 0   0   2   131       4.0 317 288 0 13   0 3     1   12   160 157 0   0 2 131     4 317
2413207 WA Asotin   school 5300280 2420   Asotin-Anatone School District 530028000027 2507 Asotin Elementary   Regular School No Elementary PK 05 2019   kindergarten 44 0 2   0 1     0   1   26 22 0   0   0   22       0.0 48 44 0 2   0 1     0   1   26 22 0   0 0 22     0 48
2413208 WA Asotin   school 5300280 2420   Asotin-Anatone School District 530028000027 2507 Asotin Elementary   Regular School No Elementary PK 05 2019   pre_kindergarten 40 0 2   0 0     0   0   23 19 0   0   0   16       0.0 42 40 0 2   0 0     0   0   23 19 0   0 0 16     0 42
2413217 WA King   school 5300300 17408   Auburn School District 530030000029 3825 Alpac Elementary School   Regular School No Elementary PK 05 2019   grade_1 39 5 42   0 8     0   11   56 49 0   36   0   66       1.0 105 39 5 42   0 8     0   11   56 49 0   36 0 66     1 105
2413218 WA King   school 5300300 17408   Auburn School District 530030000029 3825 Alpac Elementary School   Regular School No Elementary PK 05 2019   grade_2 52 4 27   0 11     1   15   59 51 0   28   1   58       2.0 110 52 4 27   0 11     1   15   59 51 0   28 1 58     2 110
2413219 WA King   school 5300300 17408   Auburn School District 530030000029 3825 Alpac Elementary School   Regular School No Elementary PK 05 2019   grade_3 38 3 30   0 13     2   11   49 48 0   28   0   61       1.0 97 38 3 30   0 13     2   11   49 48 0   28 0 61     1 97
2413220 WA King   school 5300300 17408   Auburn School District 530030000029 3825 Alpac Elementary School   Regular School No Elementary PK 05 2019   grade_4 29 5 29   0 13     1   12   39 50 0   18   0   58       1.0 89 29 5 29   0 13     1   12   39 50 0   18 0 58     1 89
2413221 WA King   school 5300300 17408   Auburn School District 530030000029 3825 Alpac Elementary School   Regular School No Elementary PK 05 2019   grade_5 39 2 27   0 18     3   13   42 60 0   12   1   61       5.0 102 39 2 27   0 18     3   13   42 60 0   12 1 61     5 102
2413222 WA King   school 5300300 17408   Auburn School District 530030000029 3825 Alpac Elementary School   Regular School No Elementary PK 05 2019   pk_12_total 253 24 201   1 90     8   74   323 328 0   171   3   380       10.0 651 253 24 201   1 90     8   74   323 328 0   171 3 380     10 651
2413223 WA King   school 5300300 17408   Auburn School District 530030000029 3825 Alpac Elementary School   Regular School No Elementary PK 05 2019   kindergarten 39 5 29   1 21     1   8   55 49 0   49   1   61       0.0 104 39 5 29   1 21     1   8   55 49 0   49 1 61     0 104
2413224 WA King   school 5300300 17408   Auburn School District 530030000029 3825 Alpac Elementary School   Regular School No Elementary PK 05 2019   pre_kindergarten 17 0 17   0 6     0   4   23 21 0   0   0   15       0.0 44 17 0 17   0 6     0   4   23 21 0   0 0 15     0 44
2413225 WA King   school 5300300 17408   Auburn School District 530030003174 5082 Arthur Jacobsen Elementary   Regular School No Elementary PK 05 2019   grade_1 36 8 24   0 14     1   6   52 37 0   37   2   51       0.0 89 36 8 24   0 14     1   6   52 37 0   37 2 51     0 89
2413226 WA King   school 5300300 17408   Auburn School District 530030003174 5082 Arthur Jacobsen Elementary   Regular School No Elementary PK 05 2019   grade_2 33 4 26   0 14     2   10   54 35 0   25   1   45       3.0 89 33 4 26   0 14     2   10   54 35 0   25 1 45     3 89
2413227 WA King   school 5300300 17408   Auburn School District 530030003174 5082 Arthur Jacobsen Elementary   Regular School No Elementary PK 05 2019   grade_3 44 6 24   0 13     1   12   52 48 0   27   0   56       0.0 100 44 6 24   0 13     1   12   52 48 0   27 0 56     0 100
2413228 WA King   school 5300300 17408   Auburn School District 530030003174 5082 Arthur Jacobsen Elementary   Regular School No Elementary PK 05 2019   grade_4 35 11 22   0 13     2   5   46 42 0   14   0   49       2.0 88 35 11 22   0 13     2   5   46 42 0   14 0 49     2 88
2413229 WA King   school 5300300 17408   Auburn School District 530030003174 5082 Arthur Jacobsen Elementary   Regular School No Elementary PK 05 2019   grade_5 56 11 24   0 12     3   9   52 63 0   15   1   60       1.0 115 56 11 24   0 12     3   9   52 63 0   15 1 60     1 115
2413230 WA King   school 5300300 17408   Auburn School District 530030003174 5082 Arthur Jacobsen Elementary   Regular School No Elementary PK 05 2019   pk_12_total 259 52 155   0 93     10   56   340 285 0   158   4   317       6.0 625 259 52 155   0 93     10   56   340 285 0   158 4 317     6 625
2413231 WA King   school 5300300 17408   Auburn School District 530030003174 5082 Arthur Jacobsen Elementary   Regular School No Elementary PK 05 2019   kindergarten 35 6 26   0 14     1   8   55 35 0   40   0   42       0.0 90 35 6 26   0 14     1   8   55 35 0   40 0 42     0 90
2413232 WA King   school 5300300 17408   Auburn School District 530030003174 5082 Arthur Jacobsen Elementary   Regular School No Elementary PK 05 2019   pre_kindergarten 20 6 9   0 13     0   6   29 25 0   0   0   14       0.0 54 20 6 9   0 13     0   6   29 25 0   0 0 14     0 54
2413256 WA King   school 5300300 17408   Auburn School District 530030000034 3439 Chinook Elementary School   Regular School No Elementary PK 05 2019   grade_1 16 7 27   12 2     10   14   39 49 0   25   1   61       2.0 88 16 7 27   12 2     10   14   39 49 0   25 1 61     2 88
2413257 WA King   school 5300300 17408   Auburn School District 530030000034 3439 Chinook Elementary School   Regular School No Elementary PK 05 2019   grade_2 15 5 26   14 4     3   13   43 37 0   27   0   56       1.0 80 15 5 26   14 4     3   13   43 37 0   27 0 56     1 80
2413258 WA King   school 5300300 17408   Auburn School District 530030000034 3439 Chinook Elementary School   Regular School No Elementary PK 05 2019   grade_3 15 4 39   9 1     8   14   51 39 0   27   2   68       1.0 90 15 4 39   9 1     8   14   51 39 0   27 2 68     1 90

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