Data source: Big Local News · About: Big Local

8,787 rows where grade = "grade_1" and state = "WA" sorted by district_nces_id descending

View and edit SQL

year

grade

  • grade_1 · 8,787
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
466563 WA Whatcom   school   37903   Lummi Tribal Agency   5373 Lummi Nation School             2015   grade_1 1 0 2   27 0     0   2   20 12 0   0   0   31       0.0 32 1 0 2   27 0     0   2   20 12 0   0 0 31     0 32
467637 WA King   school   17903   Muckleshoot Indian Tribe   1986 Muckleshoot Tribal School             2015   grade_1 0 0 0   36 0     0   0   12 24 0   0   0   24       1.0 36 0 0 0   36 0     0   0   12 24 0   0 0 24     1 36
468316 WA Thurston   school   34003   North Thurston Public Schools   8407 Wa He Lut Indian School(Closed)             2015   grade_1 0 0 1   14 0     0   1   10 6 0   0   0   10       0.0 16 0 0 1   14 0     0   1   10 6 0   0 0 10     0 16
469011 WA Okanogan   school   24019   Omak School District   4278 Paschal Sherman             2015   grade_1 1 0 1   11 0     0   2   8 7 0   0   0   12       0.0 15 1 0 1   11 0     0   2   8 7 0   0 0 12     0 15
469765 WA Pierce   school   27003   Puyallup School District   4110 Chief Leschi Schools(Closed)             2015   grade_1 1 0 4   66 0     0   6   35 42 0   0   3   41       1.0 77 1 0 4   66 0     0   6   35 42 0   0 3 41     1 77
470093 WA Clallam   school   5402   Quillayute Valley School District   4174 Quileute Tribal School(Closed)             2015   grade_1 0 0 2   3 0     0   0   2 3 0   0   0   0       0.0 5 0 0 2   3 0     0   0   2 3 0   0 0 0     0 5
475234 WA Cowlitz   school   8404   Woodland School District   5407 Woodland Primary School (Closed after 2018-2019 school year)             2015   grade_1 107 1 34   2 0     0   1   70 75 0   28   5   69       0.0 145 107 1 34   2 0     0   1   70 75 0   28 5 69     0 145
526526 WA Whatcom   school   37903   Lummi Tribal Agency   5373 Lummi Nation School             2016   grade_1 2 0 1   29 0     0   0   19 13 0   0   0   2       0.0 32 2 0 1   29 0     0   0   19 13 0   0 0 2     0 32
527555 WA King   school   17903   Muckleshoot Indian Tribe   1986 Muckleshoot Tribal School             2016   grade_1 0 0 0   34 0     0   0   16 18 0   0   0   27       0.0 34 0 0 0   34 0     0   0   16 18 0   0 0 27     0 34
528211 WA Thurston   school   34003   North Thurston Public Schools   8407 Wa He Lut Indian School(Closed)             2016   grade_1 0 0 1   15 0     0   0   11 5 0   0   0   11       0.0 16 0 0 1   15 0     0   0   11 5 0   0 0 11     0 16
528902 WA Okanogan   school   24019   Omak School District   4278 Paschal Sherman             2016   grade_1 3 0 0   13 0     0   1   7 10 0   0   0   17       0.0 17 3 0 0   13 0     0   1   7 10 0   0 0 17     0 17
529697 WA Pierce   school   27003   Puyallup School District   4110 Chief Leschi Schools(Closed)             2016   grade_1 0 0 9   62 1     0   5   38 39 0   0   3   34       0.0 77 0 0 9   62 1     0   5   38 39 0   0 3 34     0 77
530026 WA Clallam   school   5402   Quillayute Valley School District   4174 Quileute Tribal School(Closed)             2016   grade_1 0 0 1   4 0     0   0   3 2 0   0   0   1       0.0 5 0 0 1   4 0     0   0   3 2 0   0 0 1     0 5
618022 WA Pierce   school   27403   Bethel School District   5471 Bethel Elementary Learning Academy             2017   grade_1 0 0 1   0 0     0   0   1 0 0   0   0   1       0.0 1 0 0 1   0 0     0   0   1 0 0   0 0 1     0 1
623898 WA Whatcom   school   37903   Lummi Tribal Agency   5373 Lummi Nation School             2017   grade_1 0 0 0   18 0     1   2   12 9 0   0   0   19       0.0 21 0 0 0   18 0     1   2   12 9 0   0 0 19     0 21
624971 WA King   school   17903   Muckleshoot Indian Tribe   1986 Muckleshoot Tribal School             2017   grade_1 1 0 0   37 0     0   1   19 20 0   0   0   38       0.0 39 1 0 0   37 0     0   1   19 20 0   0 0 38     0 39
625628 WA Thurston   school   34003   North Thurston Public Schools   8407 Wa He Lut Indian School(Closed)             2017   grade_1 0 0 1   9 0     0   0   7 3 0   0   0   7       0.0 10 0 0 1   9 0     0   0   7 3 0   0 0 7     0 10
626328 WA Okanogan   school   24019   Omak School District   4278 Paschal Sherman             2017   grade_1 1 0 0   16 0     0   1   9 9 0   0   0   18       0.0 18 1 0 0   16 0     0   1   9 9 0   0 0 18     0 18
627131 WA Pierce   school   27003   Puyallup School District   4110 Chief Leschi Schools(Closed)             2017   grade_1 0 0 0   44 0     0   7   25 26 0   0   1   10       0.0 51 0 0 0   44 0     0   7   25 26 0   0 1 10     0 51
627422 WA Clallam   school   5903   Quileute Tribal School District   5430 Quileute Tribal School             2017   grade_1 1 0 0   5 0     0   0   3 3 0   0   1   6       0.0 6 1 0 0   5 0     0   0   3 3 0   0 1 6     0 6
2415109 WA Pierce   school   27901   Chief Leschi Schools   5549 Chief Leschi Schools             2019   grade_1 0 0 14   34 0     0   2   23 27 0   0   2   1       0.0 50 0 0 14   34 0     0   2   23 27 0   0 2 1     0 50
2419780 WA Whatcom   school   37903   Lummi Tribal Agency   5373 Lummi Nation School             2019   grade_1 0 0 0   25 0     0   1   15 11 0   0   2   26       0.0 26 0 0 0   25 0     0   1   15 11 0   0 2 26     0 26
2420785 WA King   school   17903   Muckleshoot Indian Tribe   1986 Muckleshoot Tribal School             2019   grade_1 0 0 2   47 0     0   5   24 30 0   0   0   32       0.0 54 0 0 2   47 0     0   5   24 30 0   0 0 32     0 54
2422072 WA Okanogan   school   24019   Omak School District   4278 Paschal Sherman             2019   grade_1 0 0 1   15 0     0   0   7 9 0   0   3   16       0.0 16 0 0 1   15 0     0   0   7 9 0   0 3 16     0 16
2423123 WA Clallam   school   5903   Quileute Tribal School District   5430 Quileute Tribal School             2019   grade_1 1 0 3   1 0     0   0   4 1 0   0   0   5       0.0 5 1 0 3   1 0     0   0   4 1 0   0 0 5     0 5
2427434 WA Thurston   school   34901   WA HE LUT Indian School Agency   5496 Wa He Lut Indian School             2019   grade_1 0 1 2   11 0     0   3   11 6 0   0   3   15       0.0 17 0 1 2   11 0     0   3   11 6 0   0 3 15     0 17
2464238 WA Whatcom   school   37903   Lummi Tribal Agency   5373 Lummi Nation School             2018   grade_1 0 0 0   18 0     0   1   12 7 0   0   0   19       0.0 19 0 0 0   18 0     0   1   12 7 0   0 0 19     0 19
2465250 WA King   school   17903   Muckleshoot Indian Tribe   1986 Muckleshoot Tribal School             2018   grade_1 0 0 5   41 0     0   5   17 34 0   0   0   39       0.0 51 0 0 5   41 0     0   5   17 34 0   0 0 39     0 51
2466536 WA Okanogan   school   24019   Omak School District   4278 Paschal Sherman             2018   grade_1 0 0 0   12 0     0   0   9 3 0   0   2   12       1.0 12 0 0 0   12 0     0   0   9 3 0   0 2 12     1 12
2467325 WA Pierce   school   27003   Puyallup School District   4110 Chief Leschi Schools(Closed)             2018   grade_1 1 0 2   45 0     0   2   31 19 0   0   0   0       0.0 50 1 0 2   45 0     0   2   31 19 0   0 0 0     0 50
2467618 WA Clallam   school   5903   Quileute Tribal School District   5430 Quileute Tribal School             2018   grade_1 1 0 1   2 0     1   0   4 1 0   0   0   3       0.0 5 1 0 1   2 0     1   0   4 1 0   0 0 3     0 5
2471933 WA Thurston   school   34901   WA HE LUT Indian School Agency   5496 Wa He Lut Indian School             2018   grade_1 0 0 0   14 0     0   0   9 5 0   0   0   14       0.0 14 0 0 0   14 0     0   0   9 5 0   0 0 14     0 14
2472101 WA Yakima   school   39207   Wapato School District   5544 Camas Elementary             2018   grade_1 3 0 73   22 1     0   3   54 48 0   84   29   96       0.0 102 3 0 73   22 1     0   3   54 48 0   84 29 96     0 102
2572464 WA Pierce   school   27901   Chief Leschi Schools   5549 Chief Leschi Schools             2020   grade_1 0 0 15   20 0     0   5   22 18 0   0   0   22       0.0 40 0 0 15   20 0     0   5   22 18 0   0 0 22     0 40
2577128 WA Whatcom   school   37903   Lummi Tribal Agency   5373 Lummi Nation School             2020   grade_1 1 0 2   26 0     0   0   17 12 0   0   0   26       0.0 29 1 0 2   26 0     0   0   17 12 0   0 0 26     0 29
2578125 WA King   school   17903   Muckleshoot Indian Tribe   1986 Muckleshoot Tribal School             2020   grade_1 0 0 3   43 0     0   1   25 22 0   0   0   37       0.0 47 0 0 3   43 0     0   1   25 22 0   0 0 37     0 47
2579419 WA Okanogan   school   24019   Omak School District   4278 Paschal Sherman             2020   grade_1 0 0 0   14 0     0   0   6 8 0   0   0   14       0.0 14 0 0 0   14 0     0   0   6 8 0   0 0 14     0 14
2580492 WA Clallam   school   5903   Quileute Tribal School District   5430 Quileute Tribal School             2020   grade_1 0 0 2   7 1     0   0   3 7 0   0   0   8       0.0 10 0 0 2   7 1     0   0   3 7 0   0 0 8     0 10
2584862 WA Thurston   school   34901   WA HE LUT Indian School Agency   5496 Wa He Lut Indian School             2020   grade_1 0 0 1   8 0     0   5   7 7 0   0   2   9       0.0 14 0 0 1   8 0     0   5   7 7 0   0 2 9     0 14
2933365 WA Pierce   school   27901   Chief Leschi Schools   5549 Chief Leschi Schools             2021   grade_1 0 0 7   34 0     0   1   22 20 0   0   0   22       0.0 42 0 0 7   34 0     0   1   22 20 0   0 0 22     0 42
2938009 WA Whatcom   school   37903   Lummi Tribal Agency   5373 Lummi Nation School             2021   grade_1 0 0 0   36 0     0   5   19 22 0   0   0   32       0.0 41 0 0 0   36 0     0   5   19 22 0   0 0 32     0 41
2939006 WA King   school   17903   Muckleshoot Indian Tribe   1986 Muckleshoot Tribal School             2021   grade_1 0 0 4   33 0     0   1   23 15 0   0   0   32       0.0 38 0 0 4   33 0     0   1   23 15 0   0 0 32     0 38
2940364 WA Okanogan   school   24019   Omak School District   4278 Paschal Sherman             2021   grade_1 1 1 2   11 0     0   0   10 5 0   0   0   14       0.0 15 1 1 2   11 0     0   0   10 5 0   0 0 14     0 15
2941474 WA Clallam   school   5903   Quileute Tribal School District   5430 Quileute Tribal School             2021   grade_1 2 0 1   9 0     0   2   10 4 0   0   0   12       0.0 14 2 0 1   9 0     0   2   10 4 0   0 0 12     0 14
2945887 WA Thurston   school   34901   WA HE LUT Indian School Agency   5496 Wa He Lut Indian School             2021   grade_1 0 1 4   8 0     0   2   6 9 0   0   0   15       0.0 15 0 1 4   8 0     0   2   6 9 0   0 0 15     0 15
475488 WA Yakima   school 5310170 39205   Zillah School District 531017001718 2783 Hilton Elementary School   Regular School No 1.0 PK 03 2015   grade_1 35 0 54   1 1     0   4   52 43 0   16   2   69       0.0 95 35 0 54   1 1     0   4   52 43 0   16 2 69     0 95
535432 WA Yakima   school 5310170 39205   Zillah School District 531017001718 2783 Hilton Elementary School   Regular School No 1 PK 03 2016   grade_1 38 0 54   3 0     0   7   53 49 0   23   2   65       0.0 102 38 0 54   3 0     0   7   53 49 0   23 2 65     0 102
632779 WA Yakima   school 5310170 39205   Zillah School District 531017001718 2783 Hilton Elementary School   Regular School No Elementary PK 03 2017   grade_1 40 0 47   2 0     0   5   39 55 0   21   1   61       1.0 94 40 0 47   2 0     0   5   39 55 0   21 1 61     1 94
2428448 WA Yakima   school 5310170 39205   Zillah School District 531017001718 2783 Hilton Elementary School   Regular School No Elementary PK 03 2019   grade_1 28 0 59   2 1     0   5   50 45 0   29   4   66       1.0 95 28 0 59   2 1     0   5   50 45 0   29 4 66     1 95
2472970 WA Yakima   school 5310170 39205   Zillah School District 531017001718 2783 Hilton Elementary School   Regular School No Elementary PK 03 2018   grade_1 24 0 56   3 0     0   3   45 41 0   29   3   53       0.0 86 24 0 56   3 0     0   3   45 41 0   29 3 53     0 86
2585886 WA Yakima   school 5310170 39205   Zillah School District 531017001718 2783 Hilton Elementary School   Regular School No Elementary PK 03 2020   grade_1 28 0 53   4 0     0   1   50 36 0   28   5   55       1.0 86 28 0 53   4 0     0   1   50 36 0   28 5 55     1 86
2946918 WA Yakima   school 5310170 39205   Zillah School District 531017001718 2783 Hilton Elementary School   Regular School No Elementary PK 03 2021   grade_1 24 0 44   4 0     0   5   36 41 0   22   0   41       0.0 77 24 0 44   4 0     0   5   36 41 0   22 0 41     0 77
475414 WA Thurston   school 5310140 34002   Yelm School District 531014002393 4346 Fort Stevens Elementary   Regular School No 1.0 PK 06 2015   grade_1 53 1 11   0 3     0   19   45 42 0   3   1   49       1.0 87 53 1 11   0 3     0   19   45 42 0   3 1 49     1 87
475423 WA Thurston   school 5310140 34002   Yelm School District 531014003016 5018 Lackamas Elementary   Regular School No 1.0 KG 06 2015   grade_1 37 0 5   0 1     0   5   27 21 0   0   0   22       3.0 48 37 0 5   0 1     0   5   27 21 0   0 0 22     3 48
475432 WA Thurston   school 5310140 34002   Yelm School District 531014001714 2260 McKenna Elementary   Regular School No 1.0 KG 06 2015   grade_1 54 0 7   0 1     0   8   43 27 0   5   0   38       3.0 70 54 0 7   0 1     0   8   43 27 0   5 0 38     3 70
475441 WA Thurston   school 5310140 34002   Yelm School District 531014001204 4451 Mill Pond Elementary School   Regular School No 1.0 PK 06 2015   grade_1 50 1 17   0 2     0   7   40 37 0   6   2   40       3.0 77 50 1 17   0 2     0   7   40 37 0   6 2 40     3 77
475456 WA Thurston   school 5310140 34002   Yelm School District 531014001715 3848 Southworth Elementary   Regular School No 1.0 KG 06 2015   grade_1 48 3 14   2 1     2   14   45 39 0   1   0   38       0.0 84 48 3 14   2 1     2   14   45 39 0   1 0 38     0 84
475479 WA Thurston   school 5310140 34002   Yelm School District 531014001916 4224 Yelm Prairie Elementary   Regular School No 1.0 PK 06 2015   grade_1 50 0 8   0 1     0   10   34 35 0   7   1   31       2.0 69 50 0 8   0 1     0   10   34 35 0   7 1 31     2 69
535355 WA Thurston   school 5310140 34002   Yelm School District 531014002393 4346 Fort Stevens Elementary   Regular School No 1 PK 06 2016   grade_1 57 1 13   0 2     2   13   43 45 0   3   0   48       1.0 88 57 1 13   0 2     2   13   43 45 0   3 0 48     1 88
535365 WA Thurston   school 5310140 34002   Yelm School District 531014003016 5018 Lackamas Elementary   Regular School No 1 PK 06 2016   grade_1 31 1 9   1 0     0   7   32 17 0   2   1   30       2.0 49 31 1 9   1 0     0   7   32 17 0   2 1 30     2 49
535375 WA Thurston   school 5310140 34002   Yelm School District 531014001714 2260 McKenna Elementary   Regular School No 1 PK 06 2016   grade_1 49 0 13   0 0     0   10   32 40 0   4   1   36       3.0 72 49 0 13   0 0     0   10   32 40 0   4 1 36     3 72
535385 WA Thurston   school 5310140 34002   Yelm School District 531014001204 4451 Mill Pond Elementary School   Regular School No 1 PK 06 2016   grade_1 63 3 6   0 2     2   6   49 33 0   1   0   31       2.0 82 63 3 6   0 2     2   6   49 33 0   1 0 31     2 82
535399 WA Thurston   school 5310140 34002   Yelm School District 531014001715 3848 Southworth Elementary   Regular School No 1 PK 06 2016   grade_1 51 0 22   8 0     1   10   59 33 0   7   0   44       2.0 92 51 0 22   8 0     1   10   59 33 0   7 0 44     2 92
535423 WA Thurston   school 5310140 34002   Yelm School District 531014001916 4224 Yelm Prairie Elementary   Regular School No 1 PK 06 2016   grade_1 38 1 14   1 0     1   8   31 32 0   6   0   32       0.0 63 38 1 14   1 0     1   8   31 32 0   6 0 32     0 63
632706 WA Thurston   school 5310140 34002   Yelm School District 531014002393 4346 Fort Stevens Elementary   Regular School No Elementary PK 06 2017   grade_1 59 2 11   2 2     2   13   42 49 0   3   1   45       1.0 91 59 2 11   2 2     2   13   42 49 0   3 1 45     1 91
632715 WA Thurston   school 5310140 34002   Yelm School District 531014003016 5018 Lackamas Elementary   Regular School No Elementary KG 06 2017   grade_1 30 1 6   0 0     0   1   22 16 0   0   0   14       0.0 38 30 1 6   0 0     0   1   22 16 0   0 0 14     0 38
632724 WA Thurston   school 5310140 34002   Yelm School District 531014001714 2260 McKenna Elementary   Regular School No Elementary KG 06 2017   grade_1 49 0 9   1 0     0   8   31 36 0   2   0   29       0.0 67 49 0 9   1 0     0   8   31 36 0   2 0 29     0 67
632733 WA Thurston   school 5310140 34002   Yelm School District 531014001204 4451 Mill Pond Elementary School   Regular School No Elementary PK 06 2017   grade_1 45 2 13   0 1     0   6   33 34 0   5   0   33       3.0 67 45 2 13   0 1     0   6   33 34 0   5 0 33     3 67
632746 WA Thurston   school 5310140 34002   Yelm School District 531014001715 3848 Southworth Elementary   Regular School No Elementary KG 06 2017   grade_1 53 1 17   4 2     2   8   43 44 0   7   1   46       1.0 87 53 1 17   4 2     2   8   43 44 0   7 1 46     1 87
632770 WA Thurston   school 5310140 34002   Yelm School District 531014001916 4224 Yelm Prairie Elementary   Regular School No Elementary PK 06 2017   grade_1 51 1 11   1 0     0   7   33 38 0   3   0   33       0.0 71 51 1 11   1 0     0   7   33 38 0   3 0 33     0 71
2428382 WA Thurston   school 5310140 34002   Yelm School District 531014002393 4346 Fort Stevens Elementary   Regular School No Elementary PK 05 2019   grade_1 60 1 14   2 2     2   8   43 46 0   5   1   50       1.0 89 60 1 14   2 2     2   8   43 46 0   5 1 50     1 89
2428390 WA Thurston   school 5310140 34002   Yelm School District 531014003016 5018 Lackamas Elementary   Regular School No Elementary PK 05 2019   grade_1 37 0 3   1 0     1   4   24 22 0   1   0   16       2.0 46 37 0 3   1 0     1   4   24 22 0   1 0 16     2 46
2428398 WA Thurston   school 5310140 34002   Yelm School District 531014001714 2260 McKenna Elementary   Regular School No Elementary PK 05 2019   grade_1 41 0 11   0 0     1   10   29 34 0   2   0   37       1.0 63 41 0 11   0 0     1   10   29 34 0   2 0 37     1 63
2428406 WA Thurston   school 5310140 34002   Yelm School District 531014001204 4451 Mill Pond Elementary School   Regular School No Elementary PK 05 2019   grade_1 51 0 14   0 1     1   11   39 39 0   4   3   38       3.0 78 51 0 14   0 1     1   11   39 39 0   4 3 38     3 78
2428418 WA Thurston   school 5310140 34002   Yelm School District 531014001715 3848 Southworth Elementary   Regular School No Elementary PK 05 2019   grade_1 61 4 15   3 5     0   15   46 57 0   8   2   43       2.0 103 61 4 15   3 5     0   15   46 57 0   8 2 43     2 103
2428440 WA Thurston   school 5310140 34002   Yelm School District 531014001916 4224 Yelm Prairie Elementary   Regular School No Elementary PK 05 2019   grade_1 55 1 15   1 0     0   6   37 41 0   2   0   29       1.0 78 55 1 15   1 0     0   6   37 41 0   2 0 29     1 78
2472905 WA Thurston   school 5310140 34002   Yelm School District 531014002393 4346 Fort Stevens Elementary   Regular School No Elementary PK 06 2018   grade_1 55 0 13   4 2     1   9   37 47 0   3   0   53       4.0 84 55 0 13   4 2     1   9   37 47 0   3 0 53     4 84
2472913 WA Thurston   school 5310140 34002   Yelm School District 531014003016 5018 Lackamas Elementary   Regular School No Elementary PK 06 2018   grade_1 37 3 8   0 0     0   6   29 25 0   0   2   25       3.0 54 37 3 8   0 0     0   6   29 25 0   0 2 25     3 54
2472921 WA Thurston   school 5310140 34002   Yelm School District 531014001714 2260 McKenna Elementary   Regular School No Elementary KG 06 2018   grade_1 55 0 13   1 0     0   8   44 33 0   5   1   44       1.0 77 55 0 13   1 0     0   8   44 33 0   5 1 44     1 77
2472929 WA Thurston   school 5310140 34002   Yelm School District 531014001204 4451 Mill Pond Elementary School   Regular School No Elementary PK 06 2018   grade_1 53 2 12   0 0     2   11   39 41 0   4   2   39       4.0 80 53 2 12   0 0     2   11   39 41 0   4 2 39     4 80
2472941 WA Thurston   school 5310140 34002   Yelm School District 531014001715 3848 Southworth Elementary   Regular School No Elementary KG 06 2018   grade_1 53 2 17   3 0     1   8   47 37 0   3   2   40       5.0 84 53 2 17   3 0     1   8   47 37 0   3 2 40     5 84
2472962 WA Thurston   school 5310140 34002   Yelm School District 531014001916 4224 Yelm Prairie Elementary   Regular School No Elementary PK 06 2018   grade_1 45 0 15   1 0     0   4   35 30 0   7   2   35       3.0 65 45 0 15   1 0     0   4   35 30 0   7 2 35     3 65
2585821 WA Thurston   school 5310140 34002   Yelm School District 531014002393 4346 Fort Stevens Elementary   Regular School No Elementary PK 05 2020   grade_1 62 1 12   0 1     1   9   41 45 0   6   0   63       1.0 86 62 1 12   0 1     1   9   41 45 0   6 0 63     1 86
2585829 WA Thurston   school 5310140 34002   Yelm School District 531014003016 5018 Lackamas Elementary   Regular School No Elementary PK 05 2020   grade_1 47 1 7   0 0     0   5   25 35 0   2   3   39       2.0 60 47 1 7   0 0     0   5   25 35 0   2 3 39     2 60
2585837 WA Thurston   school 5310140 34002   Yelm School District 531014001714 2260 McKenna Elementary   Regular School No Elementary PK 05 2020   grade_1 44 0 5   0 1     2   5   26 31 0   1   1   30       1.0 57 44 0 5   0 1     2   5   26 31 0   1 1 30     1 57
2585845 WA Thurston   school 5310140 34002   Yelm School District 531014001204 4451 Mill Pond Elementary School   Regular School No Elementary PK 05 2020   grade_1 30 1 6   1 0     1   10   27 22 0   1   1   28       2.0 49 30 1 6   1 0     1   10   27 22 0   1 1 28     2 49
2585857 WA Thurston   school 5310140 34002   Yelm School District 531014001715 3848 Southworth Elementary   Regular School No Elementary PK 05 2020   grade_1 61 0 21   2 3     4   9   60 40 0   5   1   50       2.0 100 61 0 21   2 3     4   9   60 40 0   5 1 50     2 100
2585878 WA Thurston   school 5310140 34002   Yelm School District 531014001916 4224 Yelm Prairie Elementary   Regular School No Elementary PK 05 2020   grade_1 53 1 10   2 1     0   7   44 30 0   6   5   43       2.0 74 53 1 10   2 1     0   7   44 30 0   6 5 43     2 74
2946854 WA Thurston   school 5310140 34002   Yelm School District 531014002393 4346 Fort Stevens Elementary   Regular School No Elementary PK 05 2021   grade_1 49 4 14   0 1     3   9   43 37 0   5   3   47       0.0 80 49 4 14   0 1     3   9   43 37 0   5 3 47     0 80
2946862 WA Thurston   school 5310140 34002   Yelm School District 531014003016 5018 Lackamas Elementary   Regular School No Elementary PK 05 2021   grade_1 41 0 3   2 0     0   11   30 27 0   0   2   28       2.0 57 41 0 3   2 0     0   11   30 27 0   0 2 28     2 57
2946869 WA Thurston   school 5310140 34002   Yelm School District 531014001714 2260 McKenna Elementary   Regular School No Elementary PK 05 2021   grade_1 39 0 9   1 1     1   6   26 31 0   2   1   30       2.0 57 39 0 9   1 1     1   6   26 31 0   2 1 30     2 57
2946877 WA Thurston   school 5310140 34002   Yelm School District 531014001204 4451 Mill Pond Elementary School   Regular School No Elementary PK 05 2021   grade_1 38 0 14   0 0     1   3   25 31 0   2   2   20       0.0 56 38 0 14   0 0     1   3   25 31 0   2 2 20     0 56
2946889 WA Thurston   school 5310140 34002   Yelm School District 531014001715 3848 Southworth Elementary   Regular School No Elementary PK 05 2021   grade_1 47 1 12   3 5     4   11   39 44 0   4   2   39       0.0 83 47 1 12   3 5     4   11   39 44 0   4 2 39     0 83
2946910 WA Thurston   school 5310140 34002   Yelm School District 531014001916 4224 Yelm Prairie Elementary   Regular School No Elementary PK 05 2021   grade_1 44 0 16   2 1     0   4   32 35 0   6   0   30       0.0 67 44 0 16   2 1     0   4   32 35 0   6 0 30     0 67
475249 WA Yakima   school 5310110 39007   Yakima School District 531011001685 2592 Adams Elementary School   Regular School No 1.0 PK 05 2015   grade_1 2 0 96   2 0     0   0   53 47 0   84   1   98       0.0 100 2 0 96   2 0     0   0   53 47 0   84 1 98     0 100
475257 WA Yakima   school 5310110 39007   Yakima School District 531011001686 3138 Barge-Lincoln Elementary School   Regular School No 1.0 PK 05 2015   grade_1 4 1 102   3 0     0   5   61 54 0   91   3   113       4.0 115 4 1 102   3 0     0   5   61 54 0   91 3 113     4 115
475271 WA Yakima   school 5310110 39007   Yakima School District 531011002609 3023 Discovery Lab School   Regular School No 1.0 KG 08 2015   grade_1 10 0 9   0 0     0   1   8 12 0   3   0   10       0.0 20 10 0 9   0 0     0   1   8 12 0   3 0 10     0 20
475291 WA Yakima   school 5310110 39007   Yakima School District 531011001692 2176 Garfield Elementary School   Regular School No 1.0 KG 05 2015   grade_1 6 0 75   0 0     0   1   47 35 0   68   2   82       1.0 82 6 0 75   0 0     0   1   47 35 0   68 2 82     1 82
475298 WA Yakima   school 5310110 39007   Yakima School District 531011001693 2818 Gilbert Elementary School   Regular School No 1.0 KG 05 2015   grade_1 39 0 62   5 1     0   4   42 69 0   38   6   88       1.0 111 39 0 62   5 1     0   4   42 69 0   38 6 88     1 111
475305 WA Yakima   school 5310110 39007   Yakima School District 531011001694 2715 Hoover Elementary School   Regular School No 1.0 PK 05 2015   grade_1 14 1 101   0 0     0   4   51 69 0   81   2   117       2.0 120 14 1 101   0 0     0   4   51 69 0   81 2 117     2 120

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