Data source: Big Local News · About: Big Local

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

View and edit SQL

grade

year

  • 2019 · 15,374
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
2419345 WA King   school 5304230 17414   Lake Washington School District 530423002519 1687 Explorer Community School   Alternative School No Elementary 01 05 2019   grade_2 12 0 0   0 3     0   0   3 12 0   1   0   0       0.0 15 12 0 0   0 3     0   0   3 12 0   1 0 0     0 15
2419346 WA King   school 5304230 17414   Lake Washington School District 530423002519 1687 Explorer Community School   Alternative School No Elementary 01 05 2019   grade_3 5 0 0   0 10     0   2   7 10 0   1   0   0       0.0 17 5 0 0   0 10     0   2   7 10 0   1 0 0     0 17
2419347 WA King   school 5304230 17414   Lake Washington School District 530423002519 1687 Explorer Community School   Alternative School No Elementary 01 05 2019   grade_4 9 0 1   0 4     0   0   7 7 0   0   0   0       0.0 14 9 0 1   0 4     0   0   7 7 0   0 0 0     0 14
2419348 WA King   school 5304230 17414   Lake Washington School District 530423002519 1687 Explorer Community School   Alternative School No Elementary 01 05 2019   grade_5 6 0 0   0 5     0   0   5 6 0   0   0   0       0.0 11 6 0 0   0 5     0   0   5 6 0   0 0 0     0 11
2419349 WA King   school 5304230 17414   Lake Washington School District 530423002519 1687 Explorer Community School   Alternative School No Elementary 01 05 2019   pk_12_total 40 0 2   0 24     0   3   25 44 0   2   0   0       1.0 69 40 0 2   0 24     0   3   25 44 0   2 0 0     1 69
2422163 WA San Juan   school 5306300 28137   Orcas Island School District 530630000946 3808 Waldron Island School   Regular School No Elementary 01 08 2019   grade_1 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
2422164 WA San Juan   school 5306300 28137   Orcas Island School District 530630000946 3808 Waldron Island School   Regular School No Elementary 01 08 2019   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
2422165 WA San Juan   school 5306300 28137   Orcas Island School District 530630000946 3808 Waldron Island School   Regular School No Elementary 01 08 2019   grade_3 3 0 0   0 0     0   1   3 1 0   0   0   0       0.0 4 3 0 0   0 0     0   1   3 1 0   0 0 0     0 4
2422166 WA San Juan   school 5306300 28137   Orcas Island School District 530630000946 3808 Waldron Island School   Regular School No Elementary 01 08 2019   grade_4 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
2422167 WA San Juan   school 5306300 28137   Orcas Island School District 530630000946 3808 Waldron Island School   Regular School No Elementary 01 08 2019   grade_6 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
2422168 WA San Juan   school 5306300 28137   Orcas Island School District 530630000946 3808 Waldron Island School   Regular School No Elementary 01 08 2019   pk_12_total 8 0 0   0 0     0   1   6 3 0   0   0   1       0.0 9 8 0 0   0 0     0   1   6 3 0   0 0 1     0 9
2427862 WA Spokane   school 5309690 32363   West Valley School District (Spokane) 530969001641 3196 Ness Elementary   Regular School No Elementary 01 05 2019   grade_1 33 2 6   0 0     0   4   23 22 0   7   0   32       0.0 45 33 2 6   0 0     0   4   23 22 0   7 0 32     0 45
2427863 WA Spokane   school 5309690 32363   West Valley School District (Spokane) 530969001641 3196 Ness Elementary   Regular School No Elementary 01 05 2019   grade_2 47 2 4   0 0     0   4   34 23 0   3   1   37       0.0 57 47 2 4   0 0     0   4   34 23 0   3 1 37     0 57
2427864 WA Spokane   school 5309690 32363   West Valley School District (Spokane) 530969001641 3196 Ness Elementary   Regular School No Elementary 01 05 2019   grade_3 40 3 9   2 0     0   4   27 31 0   5   2   45       4.0 58 40 3 9   2 0     0   4   27 31 0   5 2 45     4 58
2427865 WA Spokane   school 5309690 32363   West Valley School District (Spokane) 530969001641 3196 Ness Elementary   Regular School No Elementary 01 05 2019   grade_4 48 0 3   0 0     0   0   32 19 0   0   1   31       0.0 51 48 0 3   0 0     0   0   32 19 0   0 1 31     0 51
2427866 WA Spokane   school 5309690 32363   West Valley School District (Spokane) 530969001641 3196 Ness Elementary   Regular School No Elementary 01 05 2019   grade_5 53 1 7   0 0     0   7   39 29 0   4   3   49       6.0 68 53 1 7   0 0     0   7   39 29 0   4 3 49     6 68
2427867 WA Spokane   school 5309690 32363   West Valley School District (Spokane) 530969001641 3196 Ness Elementary   Regular School No Elementary 01 05 2019   pk_12_total 223 8 29   2 0     0   19   157 124 0   19   7   196       10.0 281 223 8 29   2 0     0   19   157 124 0   19 7 196     10 281
2427868 WA Spokane   school 5309690 32363   West Valley School District (Spokane) 530969001641 3196 Ness Elementary   Regular School No Elementary 01 05 2019   kindergarten 2 0 0   0 0     0   0   2 0 0   0   0   2       0.0 2 2 0 0   0 0     0   0   2 0 0   0 0 2     0 2
2427869 WA Spokane   school 5309690 32363   West Valley School District (Spokane) 530969001644 3129 Orchard Center Elementary   Regular School No Elementary 01 05 2019   grade_1 54 0 4   0 0     0   5   32 31 0   3   2   38       0.0 63 54 0 4   0 0     0   5   32 31 0   3 2 38     0 63
2427870 WA Spokane   school 5309690 32363   West Valley School District (Spokane) 530969001644 3129 Orchard Center Elementary   Regular School No Elementary 01 05 2019   grade_2 29 2 4   1 0     0   3   25 14 0   0   4   26       0.0 39 29 2 4   1 0     0   3   25 14 0   0 4 26     0 39
2427871 WA Spokane   school 5309690 32363   West Valley School District (Spokane) 530969001644 3129 Orchard Center Elementary   Regular School No Elementary 01 05 2019   grade_3 38 0 2   2 0     0   4   21 25 0   1   3   26       0.0 46 38 0 2   2 0     0   4   21 25 0   1 3 26     0 46
2427872 WA Spokane   school 5309690 32363   West Valley School District (Spokane) 530969001644 3129 Orchard Center Elementary   Regular School No Elementary 01 05 2019   grade_4 41 1 7   3 0     0   3   29 26 0   1   1   31       1.0 55 41 1 7   3 0     0   3   29 26 0   1 1 31     1 55
2427873 WA Spokane   school 5309690 32363   West Valley School District (Spokane) 530969001644 3129 Orchard Center Elementary   Regular School No Elementary 01 05 2019   grade_5 31 2 4   2 0     0   6   19 26 0   2   5   32       2.0 45 31 2 4   2 0     0   6   19 26 0   2 5 32     2 45
2427874 WA Spokane   school 5309690 32363   West Valley School District (Spokane) 530969001644 3129 Orchard Center Elementary   Regular School No Elementary 01 05 2019   pk_12_total 195 5 21   9 0     0   21   129 122 0   7   15   156       3.0 251 195 5 21   9 0     0   21   129 122 0   7 15 156     3 251
2427875 WA Spokane   school 5309690 32363   West Valley School District (Spokane) 530969001644 3129 Orchard Center Elementary   Regular School No Elementary 01 05 2019   kindergarten 2 0 0   1 0     0   0   3 0 0   0   0   3       0.0 3 2 0 0   1 0     0   0   3 0 0   0 0 3     0 3
2427876 WA Spokane   school 5309690 32363   West Valley School District (Spokane) 530969001646 3194 Pasadena Park Elementary   Regular School No Elementary 01 05 2019   grade_1 63 0 1   0 4     0   9   54 23 0   4   0   33       1.0 77 63 0 1   0 4     0   9   54 23 0   4 0 33     1 77
2427877 WA Spokane   school 5309690 32363   West Valley School District (Spokane) 530969001646 3194 Pasadena Park Elementary   Regular School No Elementary 01 05 2019   grade_2 62 0 8   0 1     0   4   43 32 0   2   0   21       0.0 75 62 0 8   0 1     0   4   43 32 0   2 0 21     0 75
2427878 WA Spokane   school 5309690 32363   West Valley School District (Spokane) 530969001646 3194 Pasadena Park Elementary   Regular School No Elementary 01 05 2019   grade_3 51 2 2   0 3     1   10   37 32 0   1   0   21       0.0 69 51 2 2   0 3     1   10   37 32 0   1 0 21     0 69
2427879 WA Spokane   school 5309690 32363   West Valley School District (Spokane) 530969001646 3194 Pasadena Park Elementary   Regular School No Elementary 01 05 2019   grade_4 56 0 5   0 3     1   5   32 38 0   3   0   30       1.0 70 56 0 5   0 3     1   5   32 38 0   3 0 30     1 70
2427880 WA Spokane   school 5309690 32363   West Valley School District (Spokane) 530969001646 3194 Pasadena Park Elementary   Regular School No Elementary 01 05 2019   grade_5 60 0 7   0 2     1   7   44 33 0   3   0   41       4.0 77 60 0 7   0 2     1   7   44 33 0   3 0 41     4 77
2427881 WA Spokane   school 5309690 32363   West Valley School District (Spokane) 530969001646 3194 Pasadena Park Elementary   Regular School No Elementary 01 05 2019   grade_6 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
2427882 WA Spokane   school 5309690 32363   West Valley School District (Spokane) 530969001646 3194 Pasadena Park Elementary   Regular School No Elementary 01 05 2019   pk_12_total 293 2 23   0 13     3   35   210 159 0   13   0   146       6.0 369 293 2 23   0 13     3   35   210 159 0   13 0 146     6 369
2428237 WA Yakima   school 5310110 39007   Yakima School District 531011002609 3023 Discovery Lab School   Regular School No Elementary 01 08 2019   grade_1 8 0 13   0 0     0   0   11 10 0   5   0   12       0.0 21 8 0 13   0 0     0   0   11 10 0   5 0 12     0 21
2428238 WA Yakima   school 5310110 39007   Yakima School District 531011002609 3023 Discovery Lab School   Regular School No Elementary 01 08 2019   grade_2 7 0 12   0 0     0   2   15 6 0   4   0   14       2.0 21 7 0 12   0 0     0   2   15 6 0   4 0 14     2 21
2428239 WA Yakima   school 5310110 39007   Yakima School District 531011002609 3023 Discovery Lab School   Regular School No Elementary 01 08 2019   grade_3 10 0 15   0 0     0   1   14 12 0   6   0   14       2.0 26 10 0 15   0 0     0   1   14 12 0   6 0 14     2 26
2428240 WA Yakima   school 5310110 39007   Yakima School District 531011002609 3023 Discovery Lab School   Regular School No Elementary 01 08 2019   grade_4 13 0 16   0 0     0   2   13 18 0   3   1   18       2.0 31 13 0 16   0 0     0   2   13 18 0   3 1 18     2 31
2428241 WA Yakima   school 5310110 39007   Yakima School District 531011002609 3023 Discovery Lab School   Regular School No Elementary 01 08 2019   grade_5 11 0 18   0 0     0   1   9 21 0   3   0   15       0.0 30 11 0 18   0 0     0   1   9 21 0   3 0 15     0 30
2428242 WA Yakima   school 5310110 39007   Yakima School District 531011002609 3023 Discovery Lab School   Regular School No Elementary 01 08 2019   grade_6 8 0 17   1 0     0   1   10 17 0   5   0   20       4.0 27 8 0 17   1 0     0   1   10 17 0   5 0 20     4 27
2428243 WA Yakima   school 5310110 39007   Yakima School District 531011002609 3023 Discovery Lab School   Regular School No Elementary 01 08 2019   grade_7 9 0 16   0 0     0   3   18 10 0   4   0   18       3.0 28 9 0 16   0 0     0   3   18 10 0   4 0 18     3 28
2428244 WA Yakima   school 5310110 39007   Yakima School District 531011002609 3023 Discovery Lab School   Regular School No Elementary 01 08 2019   grade_8 16 0 12   0 0     0   1   10 19 0   4   0   9       1.0 29 16 0 12   0 0     0   1   10 19 0   4 0 9     1 29
2428245 WA Yakima   school 5310110 39007   Yakima School District 531011002609 3023 Discovery Lab School   Regular School No Elementary 01 08 2019   pk_12_total 82 0 119   1 0     0   11   100 113 0   34   1   120       14.0 213 82 0 119   1 0     0   11   100 113 0   34 1 120     14 213
2417461 WA Pierce   school 5302880 27417   Fife School District 530288000466 2809 Endeavour Intermediate   Regular School No Elementary 02 05 2019   grade_2 56 13 41   1 10     11   26   75 82 1   36   4   79       2.0 158 56 13 41   1 10     11   26   75 82 1   36 4 79     2 158
2417462 WA Pierce   school 5302880 27417   Fife School District 530288000466 2809 Endeavour Intermediate   Regular School No Elementary 02 05 2019   grade_3 51 10 26   1 10     19   32   78 71 0   19   3   92       1.0 149 51 10 26   1 10     19   32   78 71 0   19 3 92     1 149
2417463 WA Pierce   school 5302880 27417   Fife School District 530288000466 2809 Endeavour Intermediate   Regular School No Elementary 02 05 2019   grade_4 51 8 48   1 10     12   21   84 67 0   25   3   82       3.0 151 51 8 48   1 10     12   21   84 67 0   25 3 82     3 151
2417464 WA Pierce   school 5302880 27417   Fife School District 530288000466 2809 Endeavour Intermediate   Regular School No Elementary 02 05 2019   grade_5 51 14 31   1 15     9   19   64 76 0   17   2   92       4.0 140 51 14 31   1 15     9   19   64 76 0   17 2 92     4 140
2417465 WA Pierce   school 5302880 27417   Fife School District 530288000466 2809 Endeavour Intermediate   Regular School No Elementary 02 05 2019   pk_12_total 209 45 146   4 45     51   98   301 296 1   97   12   345       10.0 598 209 45 146   4 45     51   98   301 296 1   97 12 345     10 598
2417470 WA Pierce   school 5302880 27417   Fife School District 530288002875 4557 Hedden Elementary School   Regular School No Elementary 02 05 2019   grade_2 62 6 21   1 10     6   29   76 59 0   23   7   70       1.0 135 62 6 21   1 10     6   29   76 59 0   23 7 70     1 135
2417471 WA Pierce   school 5302880 27417   Fife School District 530288002875 4557 Hedden Elementary School   Regular School No Elementary 02 05 2019   grade_3 63 7 26   0 4     5   18   63 60 0   14   3   61       5.0 123 63 7 26   0 4     5   18   63 60 0   14 3 61     5 123
2417472 WA Pierce   school 5302880 27417   Fife School District 530288002875 4557 Hedden Elementary School   Regular School No Elementary 02 05 2019   grade_4 79 5 20   2 13     6   21   72 74 0   19   4   54       7.0 146 79 5 20   2 13     6   21   72 74 0   19 4 54     7 146
2417473 WA Pierce   school 5302880 27417   Fife School District 530288002875 4557 Hedden Elementary School   Regular School No Elementary 02 05 2019   grade_5 70 8 33   0 13     3   18   79 66 0   19   3   57       1.0 145 70 8 33   0 13     3   18   79 66 0   19 3 57     1 145
2417474 WA Pierce   school 5302880 27417   Fife School District 530288002875 4557 Hedden Elementary School   Regular School No Elementary 02 05 2019   pk_12_total 274 26 100   3 40     20   86   290 259 0   75   17   242       14.0 549 274 26 100   3 40     20   86   290 259 0   75 17 242     14 549
2428193 WA Cowlitz   school 5310050 8404   Woodland School District 531005003517 5408 Woodland Intermediate School (Closed after 2018-2019 school year)   Regular School No Elementary 02 04 2019   grade_1 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
2428194 WA Cowlitz   school 5310050 8404   Woodland School District 531005003517 5408 Woodland Intermediate School (Closed after 2018-2019 school year)   Regular School No Elementary 02 04 2019   grade_2 120 0 44   0 0     0   8   93 79 0   24   10   89       2.0 172 120 0 44   0 0     0   8   93 79 0   24 10 89     2 172
2428195 WA Cowlitz   school 5310050 8404   Woodland School District 531005003517 5408 Woodland Intermediate School (Closed after 2018-2019 school year)   Regular School No Elementary 02 04 2019   grade_3 138 1 41   0 0     1   5   99 87 0   25   6   94       0.0 186 138 1 41   0 0     1   5   99 87 0   25 6 94     0 186
2428196 WA Cowlitz   school 5310050 8404   Woodland School District 531005003517 5408 Woodland Intermediate School (Closed after 2018-2019 school year)   Regular School No Elementary 02 04 2019   grade_4 101 2 41   1 5     0   3   86 67 0   18   9   90       11.0 153 101 2 41   1 5     0   3   86 67 0   18 9 90     11 153
2428197 WA Cowlitz   school 5310050 8404   Woodland School District 531005003517 5408 Woodland Intermediate School (Closed after 2018-2019 school year)   Regular School No Elementary 02 04 2019   pk_12_total 360 3 126   1 5     1   16   278 234 0   67   25   273       13.0 512 360 3 126   1 5     1   16   278 234 0   67 25 273     13 512
2413010 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003003633 5514 Grays Harbor Academy   Alternative School No Other 03 12 2019   grade_10 0 0 0   4 0     0   0   1 3 0   0   0   1       0.0 4 0 0 0   4 0     0   0   1 3 0   0 0 1     0 4
2413011 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003003633 5514 Grays Harbor Academy   Alternative School No Other 03 12 2019   grade_11 1 0 0   1 0     0   0   0 2 0   0   0   1       0.0 2 1 0 0   1 0     0   0   0 2 0   0 0 1     0 2
2413012 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003003633 5514 Grays Harbor Academy   Alternative School No Other 03 12 2019   grade_12 1 0 1   0 0     0   0   1 1 0   0   0   0       0.0 2 1 0 1   0 0     0   0   1 1 0   0 0 0     0 2
2413013 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003003633 5514 Grays Harbor Academy   Alternative School No Other 03 12 2019   grade_7 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
2413014 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003003633 5514 Grays Harbor Academy   Alternative School No Other 03 12 2019   grade_8 3 0 0   0 0     0   0   2 1 0   0   0   0       0.0 3 3 0 0   0 0     0   0   2 1 0   0 0 0     0 3
2413015 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003003633 5514 Grays Harbor Academy   Alternative School No Other 03 12 2019   grade_9 0 0 0   1 0     0   0   1 0 0   0   1   0       0.0 1 0 0 0   1 0     0   0   1 0 0   0 1 0     0 1
2413016 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003003633 5514 Grays Harbor Academy   Alternative School No Other 03 12 2019   pk_12_total 6 0 1   6 0     0   0   6 7 0   0   1   3       0.0 13 6 0 1   6 0     0   0   6 7 0   0 1 3     0 13
2413459 WA Clark   school 5300380 6119   Battle Ground School District 530038002782 1836 CAM Academy   Alternative School No Other 03 12 2019   grade_10 42 0 3   0 3     0   2   24 26 0   1   0   10       3.0 50 42 0 3   0 3     0   2   24 26 0   1 0 10     3 50
2413460 WA Clark   school 5300380 6119   Battle Ground School District 530038002782 1836 CAM Academy   Alternative School No Other 03 12 2019   grade_11 42 0 3   0 0     0   2   20 27 0   0   0   13       1.0 47 42 0 3   0 0     0   2   20 27 0   0 0 13     1 47
2413461 WA Clark   school 5300380 6119   Battle Ground School District 530038002782 1836 CAM Academy   Alternative School No Other 03 12 2019   grade_12 49 0 1   0 1     0   0   21 30 0   2   2   11       1.0 51 49 0 1   0 1     0   0   21 30 0   2 2 11     1 51
2413462 WA Clark   school 5300380 6119   Battle Ground School District 530038002782 1836 CAM Academy   Alternative School No Other 03 12 2019   grade_3 42 0 4   0 0     0   1   21 26 0   5   0   9       0.0 47 42 0 4   0 0     0   1   21 26 0   5 0 9     0 47
2413463 WA Clark   school 5300380 6119   Battle Ground School District 530038002782 1836 CAM Academy   Alternative School No Other 03 12 2019   grade_4 43 0 3   0 4     0   2   22 30 0   4   0   8       3.0 52 43 0 3   0 4     0   2   22 30 0   4 0 8     3 52
2413464 WA Clark   school 5300380 6119   Battle Ground School District 530038002782 1836 CAM Academy   Alternative School No Other 03 12 2019   grade_5 45 0 2   0 4     0   4   32 23 0   2   0   8       2.0 55 45 0 2   0 4     0   4   32 23 0   2 0 8     2 55
2413465 WA Clark   school 5300380 6119   Battle Ground School District 530038002782 1836 CAM Academy   Alternative School No Other 03 12 2019   grade_6 53 0 1   0 3     0   2   26 33 0   3   0   11       0.0 59 53 0 1   0 3     0   2   26 33 0   3 0 11     0 59
2413466 WA Clark   school 5300380 6119   Battle Ground School District 530038002782 1836 CAM Academy   Alternative School No Other 03 12 2019   grade_7 47 0 4   0 3     0   4   25 33 0   0   0   11       1.0 58 47 0 4   0 3     0   4   25 33 0   0 0 11     1 58
2413467 WA Clark   school 5300380 6119   Battle Ground School District 530038002782 1836 CAM Academy   Alternative School No Other 03 12 2019   grade_8 54 0 2   0 0     0   3   25 34 0   0   0   8       1.0 59 54 0 2   0 0     0   3   25 34 0   0 0 8     1 59
2413468 WA Clark   school 5300380 6119   Battle Ground School District 530038002782 1836 CAM Academy   Alternative School No Other 03 12 2019   grade_9 48 0 0   0 3     0   3   30 24 0   3   0   10       1.0 54 48 0 0   0 3     0   3   30 24 0   3 0 10     1 54
2413469 WA Clark   school 5300380 6119   Battle Ground School District 530038002782 1836 CAM Academy   Alternative School No Other 03 12 2019   pk_12_total 465 0 23   0 21     0   23   246 286 0   20   2   99       13.0 532 465 0 23   0 21     0   23   246 286 0   20 2 99     13 532
2414171 WA Whatcom   school 5300570 37503   Blaine School District 530057000130 2713 Blaine Elementary School   Regular School No Elementary 03 05 2019   grade_3 132 2 19   1 4     0   16   85 89 0   11   6   99       7.0 174 132 2 19   1 4     0   16   85 89 0   11 6 99     7 174
2414172 WA Whatcom   school 5300570 37503   Blaine School District 530057000130 2713 Blaine Elementary School   Regular School No Elementary 03 05 2019   grade_4 124 5 19   1 8     0   6   89 74 0   8   7   96       5.0 163 124 5 19   1 8     0   6   89 74 0   8 7 96     5 163
2414173 WA Whatcom   school 5300570 37503   Blaine School District 530057000130 2713 Blaine Elementary School   Regular School No Elementary 03 05 2019   grade_5 123 2 12   2 12     1   8   77 83 0   8   4   82       10.0 160 123 2 12   2 12     1   8   77 83 0   8 4 82     10 160
2414174 WA Whatcom   school 5300570 37503   Blaine School District 530057000130 2713 Blaine Elementary School   Regular School No Elementary 03 05 2019   pk_12_total 379 9 50   4 24     1   30   251 246 0   27   17   277       22.0 497 379 9 50   4 24     1   30   251 246 0   27 17 277     22 497
2414521 WA Chelan   school 5300950 4228   Cascade School District 530095001934 2827 Alpine Lakes Elementary   Regular School No Elementary 03 05 2019   grade_3 60 0 25   0 0     0   4   47 42 0   15   3   44       2.0 89 60 0 25   0 0     0   4   47 42 0   15 3 44     2 89
2414522 WA Chelan   school 5300950 4228   Cascade School District 530095001934 2827 Alpine Lakes Elementary   Regular School No Elementary 03 05 2019   grade_4 63 0 29   1 0     0   3   42 54 0   14   4   54       2.0 96 63 0 29   1 0     0   3   42 54 0   14 4 54     2 96
2414523 WA Chelan   school 5300950 4228   Cascade School District 530095001934 2827 Alpine Lakes Elementary   Regular School No Elementary 03 05 2019   grade_5 74 1 28   0 0     0   3   50 55 1   13   7   56       5.0 106 74 1 28   0 0     0   3   50 55 1   13 7 56     5 106
2414524 WA Chelan   school 5300950 4228   Cascade School District 530095001934 2827 Alpine Lakes Elementary   Regular School No Elementary 03 05 2019   pk_12_total 197 1 82   1 0     0   10   139 151 1   42   14   154       9.0 291 197 1 82   1 0     0   10   139 151 1   42 14 154     9 291
2414809 WA Spokane   school 5301110 32356   Central Valley School District 530111002681 4529 Liberty Lake Elementary   Regular School No Elementary 03 05 2019   grade_3 152 4 0   1 3     0   8   86 82 0   2   1   46       0.0 168 152 4 0   1 3     0   8   86 82 0   2 1 46     0 168
2414810 WA Spokane   school 5301110 32356   Central Valley School District 530111002681 4529 Liberty Lake Elementary   Regular School No Elementary 03 05 2019   grade_4 157 2 2   0 4     1   7   91 82 0   3   0   40       0.0 173 157 2 2   0 4     1   7   91 82 0   3 0 40     0 173
2414811 WA Spokane   school 5301110 32356   Central Valley School District 530111002681 4529 Liberty Lake Elementary   Regular School No Elementary 03 05 2019   grade_5 168 2 3   2 2     3   8   100 88 0   2   0   49       0.0 188 168 2 3   2 2     3   8   100 88 0   2 0 49     0 188
2414812 WA Spokane   school 5301110 32356   Central Valley School District 530111002681 4529 Liberty Lake Elementary   Regular School No Elementary 03 05 2019   pk_12_total 477 8 5   3 9     4   23   277 252 0   7   1   135       0.0 529 477 8 5   3 9     4   23   277 252 0   7 1 135     0 529
2414987 WA Lewis   school 5301170 21302   Chehalis School District 530117003655 5510 Orin C Smith Elementary School   Regular School No Elementary 03 05 2019   grade_3 163 1 45   0 4     1   12   118 108 0   11   10   131       3.0 226 163 1 45   0 4     1   12   118 108 0   11 10 131     3 226
2414988 WA Lewis   school 5301170 21302   Chehalis School District 530117003655 5510 Orin C Smith Elementary School   Regular School No Elementary 03 05 2019   grade_4 151 0 48   0 0     0   10   110 99 0   11   13   129       2.0 209 151 0 48   0 0     0   10   110 99 0   11 13 129     2 209
2414989 WA Lewis   school 5301170 21302   Chehalis School District 530117003655 5510 Orin C Smith Elementary School   Regular School No Elementary 03 05 2019   grade_5 156 0 46   2 1     1   18   114 110 0   11   12   110       1.0 224 156 0 46   2 1     1   18   114 110 0   11 12 110     1 224
2414990 WA Lewis   school 5301170 21302   Chehalis School District 530117003655 5510 Orin C Smith Elementary School   Regular School No Elementary 03 05 2019   pk_12_total 470 1 139   2 5     2   40   342 317 0   33   35   370       6.0 659 470 1 139   2 5     2   40   342 317 0   33 35 370     6 659
2415125 WA Jefferson   school 5301290 16049   Chimacum School District 530129000232 2697 Chimacum Elementary School   Regular School No Elementary 03 05 2019   grade_3 44 0 3   1 0     0   5   24 29 0   0   0   24       0.0 53 44 0 3   1 0     0   5   24 29 0   0 0 24     0 53
2415126 WA Jefferson   school 5301290 16049   Chimacum School District 530129000232 2697 Chimacum Elementary School   Regular School No Elementary 03 05 2019   grade_4 56 0 6   0 0     0   1   37 26 0   0   3   39       0.0 63 56 0 6   0 0     0   1   37 26 0   0 3 39     0 63
2415127 WA Jefferson   school 5301290 16049   Chimacum School District 530129000232 2697 Chimacum Elementary School   Regular School No Elementary 03 05 2019   grade_5 49 0 3   1 5     0   9   39 28 0   3   2   46       2.0 67 49 0 3   1 5     0   9   39 28 0   3 2 46     2 67
2415128 WA Jefferson   school 5301290 16049   Chimacum School District 530129000232 2697 Chimacum Elementary School   Regular School No Elementary 03 05 2019   pk_12_total 149 0 12   2 5     0   15   100 83 0   3   5   109       2.0 183 149 0 12   2 5     0   15   100 83 0   3 5 109     2 183
2415543 WA Stevens   school 5301630 33115   Colville School District 530163001898 4180 Fort Colville Elementary   Regular School No Elementary 03 05 2019   grade_3 109 0 5   2 0     0   2   62 56 0   4   2   65       0.0 118 109 0 5   2 0     0   2   62 56 0   4 2 65     0 118
2415544 WA Stevens   school 5301630 33115   Colville School District 530163001898 4180 Fort Colville Elementary   Regular School No Elementary 03 05 2019   grade_4 107 2 13   3 0     0   3   72 56 0   2   5   73       1.0 128 107 2 13   3 0     0   3   72 56 0   2 5 73     1 128
2415545 WA Stevens   school 5301630 33115   Colville School District 530163001898 4180 Fort Colville Elementary   Regular School No Elementary 03 05 2019   grade_5 135 2 12   1 0     0   7   73 84 0   0   7   95       0.0 157 135 2 12   1 0     0   7   73 84 0   0 7 95     0 157
2415546 WA Stevens   school 5301630 33115   Colville School District 530163001898 4180 Fort Colville Elementary   Regular School No Elementary 03 05 2019   pk_12_total 351 4 30   6 0     0   12   207 196 0   6   14   233       1.0 403 351 4 30   6 0     0   12   207 196 0   6 14 233     1 403
2415783 WA Spokane   school 5302070 32414   Deer Park School District 530207000306 2173 Arcadia Elementary   Regular School No Elementary 03 05 2019   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
2415784 WA Spokane   school 5302070 32414   Deer Park School District 530207000306 2173 Arcadia Elementary   Regular School No Elementary 03 05 2019   grade_3 123 2 4   2 0     0   0   67 64 0   1   3   78       8.0 131 123 2 4   2 0     0   0   67 64 0   1 3 78     8 131

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