Data source: Big Local News · About: Big Local

1,245 rows where grade = "grade_2", state = "WA" and year = 2017 sorted by total

View and edit SQL

year

  • 2017 · 1,245

grade

  • grade_2 · 1,245
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
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
617404 WA King   school 5300300 17408   Auburn School District 530030002904 1915 Special Ed School   Special Education School No Other PK 12 2017   grade_2 1 0 0   0 0     0   0   1 0 0   0   0   1       0.0 1 1 0 0   0 0     0   0   1 0 0   0 0 1     0 1
617667 WA King   school 5300390 17405   Bellevue School District 530039003434 5281 Central Educational Services   Regular School No Other PK 13 2017   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
618023 WA Pierce   school   27403   Bethel School District   5471 Bethel Elementary Learning Academy             2017   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
618607 WA Chelan   school 5300950 4228   Cascade School District 530095003528 5418 Cascade Home-Link   Regular School No Elementary KG 08 2017   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
620566 WA King   school 5300001 17216   Enumclaw School District 530000103038 1523 Special Ed School   Special Education School No Other PK 12 2017   grade_2 1 0 0   0 0     0   0   1 0 0   0   0   1       0.0 1 1 0 0   0 0     0   0   1 0 0   0 0 1     0 1
621261 WA King   school 5302820 17210   Federal Way School District 530282002638 1759 Internet Academy   Alternative School No Other PK 12 2017   grade_2 0 1 0   0 0     0   0   0 1 0   0   0   0       0.0 1 0 1 0   0 0     0   0   0 1 0   0 0 0     0 1
622364 WA King   school 5303750 17411   Issaquah School District 530375001490 1624 Issaquah Special Services   Special Education School No Other PK 12 2017   grade_2 0 0 0   0 1     0   0   1 0 0   0   0   0       0.0 1 0 0 0   0 1     0   0   1 0 0   0 0 0     0 1
622545 WA Cowlitz   school 5300003 8458   Kelso School District 530000303076 5076 Special Education   Special Education School No Other PK 12 2017   grade_2 1 0 0   0 0     0   0   0 1 0   0   0   1       0.0 1 1 0 0   0 0     0   0   0 1 0   0 0 1     0 1
623101 WA Benton   school 5304020 3052   Kiona-Benton City School District 530402003279 4217 Kiona-Benton Intermediate School   Regular School No Elementary 03 05 2017   grade_2 1 0 0   0 0     0   0   0 1 0   0   0   1       0.0 1 1 0 0   0 0     0   0   0 1 0   0 0 1     0 1
624202 WA Snohomish   school 5304860 31025   Marysville School District 530486002900 1910 Marysville SD Special   Special Education School No Other PK 13 2017   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
624233 WA Snohomish   school 5304860 31025   Marysville School District 530486002590 1744 School Home Partnership Program   Alternative School No Elementary KG 08 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
624932 WA Skagit   school 5305400 29320   Mount Vernon School District 530540001724 3829 Mount Vernon Special Ed   Special Education School No Other PK 12 2017   grade_2 1 0 0   0 0     0   0   1 0 0   0   0   1       0.0 1 1 0 0   0 0     0   0   1 0 0   0 0 1     0 1
625339 WA Franklin   school 5305730 11051   North Franklin School District 530573003364 5261 North Franklin Virtual Academy (Closed after 2019-2020 school year)   Alternative School No Elementary KG 06 2017   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
626483 WA Okanogan   school 5306420 24410   Oroville School District 530642000951 2706 Oroville Middle-High School   Regular School No High 07 12 2017   grade_2 1 0 0   0 0     0   0   0 1 0   0   0   1       0.0 1 1 0 0   0 0     0   0   0 1 0   0 0 1     0 1
626634 WA Franklin   school 5306570 11001   Pasco School District 530657003547 5393 Internet Pasco Academy of Learning   Alternative School No Elementary KG 08 2017   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
627437 WA Clallam   school 5307020 5402   Quillayute Valley School District 530702002507 1671 District Run Home School   Alternative School No Other KG 12 2017   grade_2 1 0 0   0 0     0   0   1 0 0   0   0   1       0.0 1 1 0 0   0 0     0   0   1 0 0   0 0 1     0 1
632493 WA Cowlitz   school 5310050 8404   Woodland School District 531005003371 5246 Lewis River Academy   Alternative School No Other KG 12 2017   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
620076 WA Kittitas   school 5302340 19028   Easton School District 530234000324 3554 Easton School   Regular School No Other KG 12 2017   grade_2 7 0 2   1 0     0   0   4 6 0   1   0   7       0.0 10 7 0 2   1 0     0   0   4 6 0   1 0 7     0 10
628099 WA Whitman   school 5307560 38320   Rosalia School District 530756002422 3204 Rosalia Elementary & Secondary School   Regular School No Other PK 12 2017   grade_2 8 0 0   0 0     0   2   3 7 0   0   0   8       0.0 10 8 0 0   0 0     0   2   3 7 0   0 0 8     0 10
621444 WA King   school 5302820 17210   Federal Way School District 530282000454 3582 Valhalla Elementary School   Regular School No Elementary PK 05 2017   grade_2 21 7 51   0 11     4   6   50 50 0   40   1   81       1.0 100 21 7 51   0 11     4   6   50 50 0   40 1 81     1 100
622427 WA King   school 5303750 17411   Issaquah School District 530375002307 3228 Sunset Elementary   Regular School No Elementary PK 05 2017   grade_2 62 4 5   0 21     0   8   49 51 0   7   1   5       3.0 100 62 4 5   0 21     0   8   49 51 0   7 1 5     3 100
622712 WA Benton   school 5303930 3017   Kennewick School District 530393001774 4136 Sunset View Elementary School   Regular School No Elementary KG 05 2017   grade_2 65 3 23   0 0     0   9   50 50 0   6   4   47       5.0 100 65 3 23   0 0     0   9   50 50 0   6 4 47     5 100
622916 WA King   school 5303960 17415   Kent School District 530396002112 4294 Martin Sortun Elementary School   Regular School No Elementary PK 06 2017   grade_2 30 17 13   0 31     1   8   45 55 0   26   0   52       5.0 100 30 17 13   0 31     1   8   45 55 0   26 0 52     5 100
622955 WA King   school 5303960 17415   Kent School District 530396002799 4581 Millennium Elementary School   Regular School No Elementary PK 06 2017   grade_2 31 11 27   1 19     2   9   58 42 0   58   1   76       5.0 100 31 11 27   1 19     2   9   58 42 0   58 1 76     5 100
622976 WA King   school 5303960 17415   Kent School District 530396000628 5178 Panther Lake Elementary School   Regular School No Elementary PK 06 2017   grade_2 18 17 30   0 19     1   15   46 54 0   31   1   78       7.0 100 18 17 30   0 19     1   15   46 54 0   31 1 78     7 100
623592 WA King   school 5304230 17414   Lake Washington School District 530423001842 4147 Norman Rockwell Elementary   Regular School No Elementary KG 05 2017   grade_2 43 1 8   0 42     0   6   49 51 0   14   1   3       3.0 100 43 1 8   0 42     0   6   49 51 0   14 1 3     3 100
625071 WA Snohomish   school 5305430 31006   Mukilteo School District 530543003162 4583 Odyssey Elementary   Regular School No Elementary KG 05 2017   grade_2 34 14 37   0 7     1   7   42 58 0   41   2   67       3.0 100 34 14 37   0 7     1   7   42 58 0   41 2 67     3 100
627184 WA Pierce   school 5306960 27003   Puyallup School District 530696001025 2496 Firgrove Elementary   Regular School No Elementary KG 06 2017   grade_2 36 2 43   0 6     1   12   56 44 0   24   1   66       0.0 100 36 2 43   0 6     1   12   56 44 0   24 1 66     0 100
627579 WA King   school 5307230 17403   Renton School District 530723001065 2439 Bryn Mawr Elementary School   Regular School No Elementary KG 05 2017   grade_2 14 28 21   2 21     1   13   49 51 0   32   5   66       6.0 100 14 28 21   2 21     1   13   49 51 0   32 5 66     6 100
632542 WA Yakima   school 5310110 39007   Yakima School District 531011001686 3138 Barge-Lincoln Elementary School   Regular School No Elementary PK 05 2017   grade_2 5 1 91   0 0     0   3   51 49 0   63   7   99       9.0 100 5 1 91   0 0     0   3   51 49 0   63 7 99     9 100
617197 WA Snohomish   school 5300240 31016   Arlington School District 530024002248 4327 Eagle Creek Elementary   Regular School No Elementary KG 05 2017   grade_2 78 0 14   3 0     0   6   59 42 0   11   5   49       4.0 101 78 0 14   3 0     0   6   59 42 0   11 5 49     4 101
617327 WA King   school 5300300 17408   Auburn School District 530030000035 3745 Evergreen Heights Elementary   Regular School No Elementary KG 05 2017   grade_2 44 12 16   0 12     2   15   53 48 0   21   1   45       3.0 101 44 12 16   0 12     2   15   53 48 0   21 1 45     3 101
620902 WA Snohomish   school 5302670 31002   Everett School District 530267001792 4125 Woodside Elementary   Regular School No Elementary PK 05 2017   grade_2 45 4 30   0 11     2   9   58 43 0   32   2   41       1.0 101 45 4 30   0 11     2   9   58 43 0   32 2 41     1 101
622046 WA King   school 5303540 17401   Highline School District 530354000532 3165 Hilltop Elementary   Regular School No Elementary PK 06 2017   grade_2 6 9 56   0 21     4   5   46 55 0   64   1   83       0.0 101 6 9 56   0 21     4   5   46 55 0   64 1 83     0 101
622116 WA King   school 5303540 17401   Highline School District 530354000544 3335 Parkside Elementary   Regular School No Elementary KG 06 2017   grade_2 29 19 27   0 13     3   10   60 41 0   31   4   72       1.0 101 29 19 27   0 13     3   10   60 41 0   31 4 72     1 101
622654 WA Benton   school 5303930 3017   Kennewick School District 530393001903 4181 Lincoln Elementary School   Regular School No Elementary KG 05 2017   grade_2 69 2 24   0 1     0   5   41 60 0   25   2   69       4.0 101 69 2 24   0 1     0   5   41 60 0   25 2 69     4 101
622866 WA King   school 5303960 17415   Kent School District 530396000619 4520 Kent Elementary School   Regular School No Elementary PK 06 2017   grade_2 13 11 47   0 4     13   13   56 45 0   47   5   85       4.0 101 13 11 47   0 4     13   13   56 45 0   47 5 85     4 101
625064 WA Snohomish   school 5305430 31006   Mukilteo School District 530543001852 4164 Mukilteo Elementary   Regular School No Elementary KG 05 2017   grade_2 67 4 8   0 15     0   7   58 43 0   17   2   20       3.0 101 67 4 8   0 15     0   7   58 43 0   17 2 20     3 101
628232 WA King   school 5307710 17001   Seattle School District No. 1 530771001146 2372 Bryant Elementary School   Regular School No Elementary KG 05 2017   grade_2 68 2 5   2 7     0   17   54 47 0   3   0   2       0.0 101 68 2 5   2 7     0   17   54 47 0   3 0 2     0 101
629027 WA Clallam   school 5307830 5323   Sequim School District 530783001288 2722 Helen Haller Elementary School   Regular School No Elementary KG 05 2017   grade_2 84 0 9   1 1     0   6   56 45 0   1   3   58       1.0 101 84 0 9   1 1     0   6   56 45 0   1 3 58     1 101
629481 WA King   school 5308040 17410   Snoqualmie Valley School District 530804003560 5457 Timber Ridge Elementary School   Regular School No Elementary KG 05 2017   grade_2 72 0 7   0 15     1   6   51 50 0   9   0   2       1.0 101 72 0 7   0 15     1   6   51 50 0   9 0 2     1 101
632324 WA Pierce   school 5309780 27416   White River School District 530978002245 4309 Foothills Elementary   Regular School No Elementary KG 05 2017   grade_2 77 3 15   0 2     0   4   45 56 0   8   1   44       3.0 101 77 3 15   0 2     0   4   45 56 0   8 1 44     3 101
632747 WA Thurston   school 5310140 34002   Yelm School District 531014001715 3848 Southworth Elementary   Regular School No Elementary KG 06 2017   grade_2 57 0 21   10 0     1   12   62 39 0   7   2   43       5.0 101 57 0 21   10 0     1   12   62 39 0   7 2 43     5 101
617592 WA Clark   school 5300380 6119   Battle Ground School District 530038000055 3996 Pleasant Valley Primary   Regular School No Elementary PK 04 2017   grade_2 78 1 10   0 4     3   6   51 51 0   21   4   43       2.0 102 78 1 10   0 4     3   6   51 51 0   21 4 43     2 102
621007 WA Clark   school 5302700 6114   Evergreen School District (Clark) 530270002429 4380 Harmony Elementary School   Regular School No Elementary KG 05 2017   grade_2 68 0 13   0 6     3   12   58 44 0   12   1   27       0.0 102 68 0 13   0 6     3   12   58 44 0   12 1 27     0 102
622055 WA King   school 5303540 17401   Highline School District 530354000533 3278 Madrona Elementary   Regular School No Elementary PK 06 2017   grade_2 8 27 50   0 5     9   3   52 50 0   51   8   94       0.0 102 8 27 50   0 5     9   3   52 50 0   51 8 94     0 102
622735 WA Benton   school 5303930 3017   Kennewick School District 530393000611 2825 Westgate Elementary School   Regular School No Elementary PK 05 2017   grade_2 60 8 19   1 11     1   2   50 52 0   46   4   98       0.0 102 60 8 19   1 11     1   2   50 52 0   46 4 98     0 102
627374 WA Pierce   school 5306960 27003   Puyallup School District 530696001044 2519 Woodland Elementary   Regular School No Elementary KG 06 2017   grade_2 63 3 15   2 3     4   12   39 63 0   3   1   49       5.0 102 63 3 15   2 3     4   12   39 63 0   3 1 49     5 102
631901 WA Yakima   school 5309480 39207   Wapato School District 530948001614 2960 Camas Elementary (Closed after 2017-2018 school year)   Regular School No Elementary KG 05 2017   grade_2 1 0 72   26 2     0   1   57 45 0   49   7   98       0.0 102 1 0 72   26 2     0   1   57 45 0   49 7 98     0 102
620489 WA Grays Harbor   school 5302490 14068   Elma School District 530249000371 3217 Elma Elementary School   Regular School No Elementary PK 05 2017   grade_2 67 1 24   1 0     0   10   60 43 0   14   3   89       1.0 103 67 1 24   1 0     0   10   60 43 0   14 3 89     1 103
621451 WA King   school 5302820 17210   Federal Way School District 530282000455 3583 Wildwood Elementary School   Regular School No Elementary PK 05 2017   grade_2 9 12 63   0 7     4   8   49 54 0   49   2   100       1.0 103 9 12 63   0 7     4   8   49 54 0   49 2 100     1 103
622063 WA King   school 5303540 17401   Highline School District 530354000535 3097 Marvista Elementary   Regular School No Elementary PK 06 2017   grade_2 53 12 28   1 3     2   4   59 44 0   22   3   40       2.0 103 53 12 28   1 3     2   4   59 44 0   22 3 40     2 103
622333 WA King   school 5303750 17411   Issaquah School District 530375002518 4493 Endeavour Elementary School   Regular School No Elementary KG 05 2017   grade_2 49 0 9   1 36     0   8   53 50 0   9   0   5       2.0 103 49 0 9   1 36     0   8   53 50 0   9 0 5     2 103
622372 WA King   school 5303750 17411   Issaquah School District 530375000575 3673 Issaquah Valley Elementary   Regular School No Elementary KG 05 2017   grade_2 61 2 16   0 14     0   10   44 59 0   12   0   18       0.0 103 61 2 16   0 14     0   10   44 59 0   12 0 18     0 103
622619 WA Benton   school 5303930 3017   Kennewick School District 530393000602 3077 Hawthorne Elementary School   Regular School No Elementary KG 05 2017   grade_2 32 1 64   0 0     1   5   50 53 0   33   0   85       0.0 103 32 1 64   0 0     1   5   50 53 0   33 0 85     0 103
624630 WA Grays Harbor   school 5305160 14066   Montesano School District 530516000779 3661 Beacon Avenue Elementary School   Regular School No Elementary KG 02 2017   grade_2 77 0 12   2 0     0   12   53 50 0   2   1   42       1.0 103 77 0 12   2 0     0   12   53 50 0   2 1 42     1 103
627635 WA King   school 5307230 17403   Renton School District 530723001072 2640 Highlands Elementary School   Regular School No Elementary KG 05 2017   grade_2 18 9 49   0 16     0   11   49 54 0   63   5   69       3.0 103 18 9 49   0 16     0   11   49 54 0   63 5 69     3 103
629645 WA Kitsap   school 5308160 18402   South Kitsap School District 530816001353 2650 Orchard Heights Elementary   Regular School No Elementary KG 06 2017   grade_2 68 3 10   1 3     1   17   51 52 0   2   2   58       1.0 103 68 3 10   1 3     1   17   51 52 0   2 2 58     1 103
631254 WA King   school 5308130 17406   Tukwila School District 530813001344 3488 Tukwila Elementary   Regular School No Elementary PK 05 2017   grade_2 15 16 25   0 21     6   20   46 57 0   43   13   71       0.0 103 15 16 25   0 21     6   20   46 57 0   43 13 71     0 103
632612 WA Yakima   school 5310110 39007   Yakima School District 531011001814 3817 Martin Luther King Jr Elementary   Regular School No Elementary KG 05 2017   grade_2 11 0 90   2 0     0   0   58 45 0   74   4   91       1.0 103 11 0 90   2 0     0   0   58 45 0   74 4 91     1 103
617809 WA King   school 5300390 17405   Bellevue School District 530039000088 3634 Spiritridge Elementary School   Regular School No Elementary KG 05 2017   grade_2 36 2 3   0 55     0   8   54 50 0   18   0   10       2.0 104 36 2 3   0 55     0   8   54 50 0   18 0 10     2 104
621782 WA Yakima   school 5303150 39200   Grandview School District 530315000501 2345 Mcclure Elementary School   Regular School No Elementary PK 05 2017   grade_2 3 0 101   0 0     0   0   50 54 0   57   3   94       2.0 104 3 0 101   0 0     0   0   50 54 0   57 3 94     2 104
623225 WA Chelan   school 5301200 4129   Lake Chelan School District 530120000220 2689 Morgen Owings Elementary School   Regular School No Elementary KG 05 2017   grade_2 44 1 57   0 2     0   0   55 49 0   52   1   75       2.0 104 44 1 57   0 2     0   0   55 49 0   52 1 75     2 104
625947 WA Island   school 5305940 15201   Oak Harbor School District 530594002264 4328 Hillcrest Elementary   Regular School No Elementary 01 05 2017   grade_2 61 2 21   0 6     1   13   50 54 0   3   2   31       3.0 104 61 2 21   0 6     1   13   50 54 0   3 2 31     3 104
627846 WA Benton   school 5307320 3400   Richland School District 530732003540 5419 Orchard Elementary   Regular School No Elementary PK 05 2017   grade_2 70 0 20   0 9     0   5   62 42 0   11   1   23       0.0 104 70 0 20   0 9     0   5   62 42 0   11 1 23     0 104
627930 WA Clark   school 5307350 6122   Ridgefield School District 530735001106 3321 South Ridge Elementary   Regular School No Elementary KG 06 2017   grade_2 77 0 17   0 4     1   5   51 53 0   7   4   30       2.0 104 77 0 17   0 4     1   5   51 53 0   7 4 30     2 104
629654 WA Kitsap   school 5308160 18402   South Kitsap School District 530816002360 4349 Sidney Glen Elementary School   Regular School No Elementary KG 05 2017   grade_2 62 1 18   1 2     2   18   55 49 0   10   2   63       4.0 104 62 1 18   1 2     2   18   55 49 0   10 2 63     4 104
620014 WA Douglas   school 5302310 9206   Eastmont School District 530231000317 3659 Cascade Elementary   Regular School No Elementary KG 04 2017   grade_2 70 0 32   0 0     0   3   57 48 0   19   0   37       2.0 105 70 0 32   0 0     0   3   57 48 0   19 0 37     2 105
620787 WA Snohomish   school 5302670 31002   Everett School District 530267000402 3533 Jefferson Elementary   Regular School No Elementary KG 05 2017   grade_2 63 7 18   0 12     0   5   50 55 0   16   3   42       2.0 105 63 7 18   0 12     0   5   50 55 0   16 3 42     2 105
622418 WA King   school 5303750 17411   Issaquah School District 530375000581 3386 Sunny Hills Elementary   Regular School No Elementary KG 05 2017   grade_2 53 2 7   0 35     0   8   50 55 0   15   0   6       1.0 105 53 2 7   0 35     0   8   50 55 0   15 0 6     1 105
627642 WA King   school 5307230 17403   Renton School District 530723003351 5229 Honey Dew Elementary   Regular School No Elementary KG 05 2017   grade_2 25 9 54   0 12     0   5   58 47 0   43   9   74       7.0 105 25 9 54   0 12     0   5   58 47 0   43 9 74     7 105
619004 WA Lewis   school 5301140 21401   Centralia School District 530114000209 3172 Jefferson Lincoln Elementary   Regular School No Elementary KG 03 2017   grade_2 58 0 44   1 0     0   3   49 57 0   26   3   94       1.0 106 58 0 44   1 0     0   3   49 57 0   26 3 94     1 106
622272 WA King   school 5303750 17411   Issaquah School District 530375000571 3440 Briarwood Elementary   Regular School No Elementary KG 05 2017   grade_2 71 1 9   0 18     1   6   58 48 0   12   1   16       1.0 106 71 1 9   0 18     1   6   58 48 0   12 1 16     1 106
622965 WA King   school 5303960 17415   Kent School District 530396002309 4356 Neely O Brien Elementary School   Regular School No Elementary KG 06 2017   grade_2 17 17 34   0 19     6   13   55 51 0   42   2   80       5.0 106 17 17 34   0 19     6   13   55 51 0   42 2 80     5 106
623254 WA Snohomish   school 5304200 31004   Lake Stevens School District 530420000520 4391 Glenwood Elementary   Regular School No Elementary KG 05 2017   grade_2 85 3 7   0 0     0   11   63 43 0   4   0   31       3.0 106 85 3 7   0 0     0   11   63 43 0   4 0 31     3 106
623262 WA Snohomish   school 5304200 31004   Lake Stevens School District 530420002756 4534 Highland Elementary   Regular School No Elementary PK 05 2017   grade_2 87 0 8   1 3     0   7   55 51 0   3   0   21       3.0 106 87 0 8   1 3     0   7   55 51 0   3 0 21     3 106
626725 WA Franklin   school 5306570 11001   Pasco School District 530657000971 4041 Ruth Livingston Elementary   Regular School No Elementary PK 06 2017   grade_2 62 0 35   2 3     0   4   55 51 0   13   0   45       1.0 106 62 0 35   2 3     0   4   55 51 0   13 0 45     1 106
630448 WA Pierce   school 5308610 27320   Sumner School District 530861001445 3399 Donald Eismann Elementary   Regular School No Elementary PK 05 2017   grade_2 78 1 11   1 2     0   13   54 52 0   3   0   11       3.0 106 78 1 11   1 2     0   13   54 52 0   3 0 11     3 106
630476 WA Pierce   school 5308610 27320   Sumner School District 530861001444 2875 Maple Lawn Elementary   Regular School No Elementary PK 05 2017   grade_2 80 1 13   1 2     2   7   59 47 0   5   1   38       2.0 106 80 1 13   1 2     2   7   59 47 0   5 1 38     2 106
618507 WA Clark   school 5300810 6117   Camas School District 530081002083 2725 Helen Baller Elem   Regular School No Elementary KG 05 2017   grade_2 87 0 9   2 5     0   4   52 55 0   4   0   14       3.0 107 87 0 9   2 5     0   4   52 55 0   4 0 14     3 107
620955 WA Clark   school 5302700 6114   Evergreen School District (Clark) 530270000416 3822 Crestline Elementary School   Regular School No Elementary PK 05 2017   grade_2 38 2 53   0 2     4   8   52 55 0   38   4   82       2.0 107 38 2 53   0 2     4   8   52 55 0   38 4 82     2 107
621301 WA King   school 5302820 17210   Federal Way School District 530282001835 3627 Mark Twain Elementary School   Regular School No Elementary PK 05 2017   grade_2 9 24 46   0 8     12   8   50 57 0   44   2   97       1.0 107 9 24 46   0 8     12   8   50 57 0   44 2 97     1 107
621392 WA King   school 5302820 17210   Federal Way School District 530282000450 3567 Sunnycrest Elementary School   Regular School No Elementary PK 05 2017   grade_2 13 14 52   0 10     7   11   58 49 0   64   1   105       0.0 107 13 14 52   0 10     7   11   58 49 0   64 1 105     0 107
622008 WA King   school 5303540 17401   Highline School District 530354000528 2844 Gregory Heights Elementary   Regular School No Elementary PK 06 2017   grade_2 48 8 37   0 10     3   1   54 53 0   27   3   60       2.0 107 48 8 37   0 10     3   1   54 53 0   27 3 60     2 107
622603 WA Benton   school 5303930 3017   Kennewick School District 530393000599 2824 Eastgate Elementary School   Regular School No Elementary PK 05 2017   grade_2 17 2 85   0 1     0   2   57 50 0   51   0   100       1.0 107 17 2 85   0 1     0   2   57 50 0   51 0 100     1 107
623650 WA King   school 5304230 17414   Lake Washington School District 530423003077 5053 Rosa Parks Elementary   Regular School No Elementary KG 05 2017   grade_2 39 2 5   0 55     0   6   55 52 0   16   0   0       2.0 107 39 2 5   0 55     0   6   55 52 0   16 0 0     2 107
625025 WA Snohomish   school 5305430 31006   Mukilteo School District 530543000816 2886 Fairmount Elementary   Regular School No Elementary KG 05 2017   grade_2 39 11 34   0 11     1   11   54 53 0   48   0   78       5.0 107 39 11 34   0 11     1   11   54 53 0   48 0 78     5 107
625562 WA Thurston   school 5305850 34003   North Thurston Public Schools 530585000867 3130 Mountain View Elementary   Regular School No Elementary PK 05 2017   grade_2 55 3 27   1 6     4   11   55 52 0   9   7   66       2.0 107 55 3 27   1 6     4   11   55 52 0   9 7 66     2 107
626868 WA Pierce   school 5306690 27401   Peninsula School District 530669000986 3685 Purdy Elementary School   Regular School No Elementary PK 05 2017   grade_2 78 1 14   1 5     0   8   51 56 0   2   1   26       1.0 107 78 1 14   1 5     0   8   51 56 0   2 1 26     1 107
627193 WA Pierce   school 5306960 27003   Puyallup School District 530696002340 4361 Frank Brouillet Elem   Regular School No Elementary KG 06 2017   grade_2 71 2 13   0 6     3   12   59 48 0   4   0   27       8.0 107 71 2 13   0 6     3   12   59 48 0   4 0 27     8 107
628807 WA King   school 5307710 17001   Seattle School District No. 1 530771002347 2141 Thurgood Marshall Elementary   Regular School No Elementary PK 05 2017   grade_2 42 25 7   0 11     0   22   64 43 0   16   4   33       3.0 107 42 25 7   0 11     0   22   64 43 0   16 4 33     3 107
628864 WA King   school 5307710 17001   Seattle School District No. 1 530771001263 2142 West Woodland Elementary School   Regular School No Elementary KG 05 2017   grade_2 77 2 5   0 7     0   16   47 60 0   3   1   9       1.0 107 77 2 5   0 7     0   16   47 60 0   3 1 9     1 107
629429 WA King   school 5308040 17410   Snoqualmie Valley School District 530804001329 2222 Fall City Elementary   Regular School No Elementary KG 05 2017   grade_2 87 0 5   0 5     0   10   53 54 0   4   0   12       2.0 107 87 0 5   0 5     0   10   53 54 0   4 0 12     2 107
617521 WA Clark   school 5300380 6119   Battle Ground School District 530038002278 4352 Captain Strong   Regular School No Elementary PK 04 2017   grade_2 90 0 8   0 2     0   8   59 49 0   8   1   41       2.0 108 90 0 8   0 2     0   8   59 49 0   8 1 41     2 108
617539 WA Clark   school 5300380 6119   Battle Ground School District 530038003194 5090 Daybreak Primary   Regular School No Elementary PK 04 2017   grade_2 95 0 8   0 1     1   3   57 51 0   14   2   45       4.0 108 95 0 8   0 1     1   3   57 51 0   14 2 45     4 108
618102 WA Pierce   school 5300480 27403   Bethel School District 530048003272 5159 Frederickson Elementary   Regular School No Elementary PK 05 2017   grade_2 51 4 33   0 3     2   14   54 54 0   16   1   57       1.0 108 51 4 33   0 3     2   14   54 54 0   16 1 57     1 108
618114 WA Pierce   school 5300480 27403   Bethel School District 530048002203 4297 Graham Elementary   Regular School No Elementary KG 05 2017   grade_2 59 6 16   0 0     3   24   55 53 0   3   5   44       4.0 108 59 6 16   0 0     3   24   55 53 0   3 5 44     4 108
620721 WA Snohomish   school 5302670 31002   Everett School District 530267000394 3184 Emerson Elementary School   Regular School No Elementary PK 05 2017   grade_2 42 10 39   0 8     1   8   41 67 0   34   4   80       0.0 108 42 10 39   0 8     1   8   41 67 0   34 4 80     0 108
621822 WA Yakima   school 5303180 39204   Granger School District 530318002780 4535 Roosevelt Elementary   Regular School No Elementary KG 04 2017   grade_2 2 1 98   4 0     0   3   57 51 0   56   3   90       0.0 108 2 1 98   4 0     0   3   57 51 0   56 3 90     0 108

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