Data source: Big Local News · About: Big Local

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

View and edit SQL

grade

year

  • 2017 · 15,658
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
621398 WA King   school 5302820 17210   Federal Way School District 530282002961 1951 Support School   Regular School No Other PK 12 2017   grade_10 0 1 0   0 0     0   0   1 0 0   0   0   1       0.0 1 0 1 0   0 0     0   0   1 0 0   0 0 1     0 1
621407 WA King   school 5302820 17210   Federal Way School District 530282002961 1951 Support School   Regular School No Other PK 12 2017   grade_7 0 0 0   0 0     0   2   1 1 0   0   0   1       0.0 2 0 0 0   0 0     0   2   1 1 0   0 0 1     0 2
621411 WA King   school 5302820 17210   Federal Way School District 530282002961 1951 Support School   Regular School No Other PK 12 2017   kindergarten 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
621506 WA Whatcom   school 5302850 37502   Ferndale School District 530285002495 4482 Eagleridge Elementary   Regular School No Elementary KG 05 2017   pre_kindergarten 0 0 0   0 0     0   1   1 0 0   0   0   0       0.0 1 0 0 0   0 0     0   1   1 0 0   0 0 0     0 1
621545 WA Pierce   school 5302880 27417   Fife School District 530288000464 2878 Discovery Primary School   Regular School No Elementary PK 01 2017   grade_3 0 0 1   0 0     1   1   0 3 0   0   0   2       0.0 3 0 0 1   0 0     1   1   0 3 0   0 0 2     0 3
621554 WA Pierce   school 5302880 27417   Fife School District 530288000466 2809 Endeavour Intermediate   Regular School No Elementary 02 05 2017   grade_7 0 1 0   0 0     0   0   1 0 0   0   1   1       0.0 1 0 1 0   0 0     0   0   1 0 0   0 1 1     0 1
621575 WA Benton   school 5302910 3053   Finley School District 530291000468 3078 Finley Elementary   Regular School No Elementary PK 05 2017   kindergarten_half_day 0 0 4   0 0     0   0   3 1 0   3   0   3       0.0 4 0 0 4   0 0     0   0   3 1 0   3 0 3     0 4
621609 WA Pierce   school 5302940 27402   Franklin Pierce School District 530294000472 3301 Christensen Elementary   Regular School No Elementary PK 05 2017   kindergarten_half_day 0 1 0   0 0     0   0   0 1 0   0   0   1       0.0 1 0 1 0   0 0     0   0   0 1 0   0 0 1     0 1
621744 WA Grant   school 5303130 13301   Grand Coulee Dam School District 530313003448 5336 Lake Roosevelt Alternative School   Alternative School No Other KG 12 2017   grade_12 0 0 0   3 0     0   0   1 2 0   0   0   2       0.0 3 0 0 0   3 0     0   0   1 2 0   0 0 2     0 3
621753 WA Grant   school 5303130 13301   Grand Coulee Dam School District 530313000494 2802 Lake Roosevelt Elementary   Regular School No Elementary PK 06 2017   kindergarten_half_day 0 0 0   1 0     0   0   0 1 0   0   0   1       0.0 1 0 0 0   1 0     0   0   0 1 0   0 0 1     0 1
621759 WA Grant   school 5303130 13301   Grand Coulee Dam School District 530313000496 2801 Lake Roosevelt Jr/Sr High School   Regular School No High 07 12 2017   grade_6 0 0 0   1 0     0   0   1 0 0   1   0   1       0.0 1 0 0 0   1 0     0   0   1 0 0   1 0 1     0 1
621787 WA Yakima   school 5303150 39200   Grandview School District 530315000501 2345 Mcclure Elementary School   Regular School No Elementary PK 05 2017   kindergarten_half_day 0 0 1   0 0     0   0   0 1 0   0   0   1       0.0 1 0 0 1   0 0     0   0   0 1 0   0 0 1     0 1
621796 WA Yakima   school 5303150 39200   Grandview School District 530315000497 3013 Smith Elementary School   Regular School No Elementary PK 05 2017   kindergarten_half_day 0 0 6   0 0     0   0   5 1 0   2   0   6       0.0 6 0 0 6   0 0     0   0   5 1 0   2 0 6     0 6
621798 WA Yakima   school 5303150 39200   Grandview School District 530315000497 3013 Smith Elementary School   Regular School No Elementary PK 05 2017   pre_kindergarten 0 0 28   0 0     0   0   10 18 0   2   3   26       0.0 28 0 0 28   0 0     0   0   10 18 0   2 3 26     0 28
621800 WA Yakima   school 5303150 39200   Grandview School District 530315003550 5399 Step to College Open Doors High School   Alternative School No High 09 12 2017   grade_11 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
621801 WA Yakima   school 5303150 39200   Grandview School District 530315003550 5399 Step to College Open Doors High School   Alternative School No High 09 12 2017   grade_12 0 0 15   0 0     0   0   5 10 0   0   0   11       0.0 15 0 0 15   0 0     0   0   5 10 0   0 0 11     0 15
621817 WA Yakima   school 5303180 39204   Granger School District 530318000504 2531 Granger Middle School   Regular School No Middle 05 08 2017   grade_6 0 0 118   4 0     0   1   65 58 0   39   1   107       1.0 123 0 0 118   4 0     0   1   65 58 0   39 1 107     1 123
621853 WA Snohomish   school 5303210 31332   Granite Falls School District 530321002303 4330 Mountain Way Elementary   Regular School No Elementary KG 02 2017   grade_5 0 0 1   0 0     0   0   1 0 0   0   0   0       0.0 1 0 0 1   0 0     0   0   1 0 0   0 0 0     0 1
621932 WA Yakima   school 5303510 39203   Highland School District 530351000517 3073 Tieton Intermediate School   Regular School No Elementary 04 06 2017   grade_3 0 0 1   0 0     0   0   0 1 0   0   0   1       0.0 1 0 0 1   0 0     0   0   0 1 0   0 0 1     0 1
621971 WA King   school 5303540 17401   Highline School District 530354000521 2982 Bow Lake Elementary   Regular School No Elementary PK 06 2017   pre_kindergarten 0 0 1   0 0     0   0   0 1 0   0   0   1       0.0 1 0 0 1   0 0     0   0   0 1 0   0 0 1     0 1
621983 WA King   school 5303540 17401   Highline School District 530354000523 2926 Cedarhurst Elementary   Regular School No Elementary PK 06 2017   pre_kindergarten 0 4 5   0 4     0   0   8 5 0   0   0   9       0.0 13 0 4 5   0 4     0   0   8 5 0   0 0 9     0 13
622100 WA King   school 5303540 17401   Highline School District 530354002967 1972 New Start   Alternative School No High 09 12 2017   grade_10 0 1 2   1 0     1   1   3 3 0   2   0   5       1.0 6 0 1 2   1 0     1   1   3 3 0   2 0 5     1 6
622229 WA Grays Harbor   school 5303660 14028   Hoquiam School District 530366000566 3621 Lincoln Elementary   Regular School No Elementary PK 03 2017   grade_1 0 0 1   0 0     0   0   1 0 0   0   0   0       0.0 1 0 0 1   0 0     0   0   1 0 0   0 0 0     0 1
622234 WA Ferry   school 5300002 10070   Inchelium School District 530000202871 4215 Inchelium Elementary School   Regular School No Elementary KG 05 2017   grade_1 0 0 0   16 0     0   1   7 10 0   10   0   13       0.0 17 0 0 0   16 0     0   1   7 10 0   10 0 13     0 17
622235 WA Ferry   school 5300002 10070   Inchelium School District 530000202871 4215 Inchelium Elementary School   Regular School No Elementary KG 05 2017   grade_2 0 0 1   15 0     0   1   9 8 0   10   2   16       0.0 17 0 0 1   15 0     0   1   9 8 0   10 2 16     0 17
622238 WA Ferry   school 5300002 10070   Inchelium School District 530000202871 4215 Inchelium Elementary School   Regular School No Elementary KG 05 2017   grade_5 0 0 0   12 0     0   5   6 11 0   8   0   15       0.0 17 0 0 0   12 0     0   5   6 11 0   8 0 15     0 17
622241 WA Ferry   school 5300002 10070   Inchelium School District 530000200568 2603 Inchelium High School   Regular School No High 09 12 2017   grade_10 0 0 0   13 1     0   2   8 8 0   6   0   13       0.0 16 0 0 0   13 1     0   2   8 8 0   6 0 13     0 16
622242 WA Ferry   school 5300002 10070   Inchelium School District 530000200568 2603 Inchelium High School   Regular School No High 09 12 2017   grade_11 0 0 0   10 1     0   0   5 6 0   3   1   10       0.0 11 0 0 0   10 1     0   0   5 6 0   3 1 10     0 11
622244 WA Ferry   school 5300002 10070   Inchelium School District 530000200568 2603 Inchelium High School   Regular School No High 09 12 2017   grade_9 0 0 0   15 0     0   3   8 10 0   6   0   14       0.0 18 0 0 0   15 0     0   3   8 10 0   6 0 14     0 18
622246 WA Ferry   school 5300002 10070   Inchelium School District 530000202870 4214 Inchelium Middle School   Regular School No Middle 06 08 2017   grade_6 0 0 0   15 0     0   2   7 10 0   6   0   13       1.0 17 0 0 0   15 0     0   2   7 10 0   6 0 13     1 17
622247 WA Ferry   school 5300002 10070   Inchelium School District 530000202870 4214 Inchelium Middle School   Regular School No Middle 06 08 2017   grade_7 0 0 0   13 0     0   3   7 9 0   7   0   12       0.0 16 0 0 0   13 0     0   3   7 9 0   7 0 12     0 16
622248 WA Ferry   school 5300002 10070   Inchelium School District 530000202870 4214 Inchelium Middle School   Regular School No Middle 06 08 2017   grade_8 0 0 1   14 0     0   2   10 7 0   3   0   13       0.0 17 0 0 1   14 0     0   2   10 7 0   3 0 13     0 17
622249 WA Ferry   school 5300002 10070   Inchelium School District 530000202870 4214 Inchelium Middle School   Regular School No Middle 06 08 2017   pk_12_total 0 0 1   42 0     0   7   24 26 0   16   0   38       1.0 50 0 0 1   42 0     0   7   24 26 0   16 0 38     1 50
622301 WA King   school 5303750 17411   Issaquah School District 530375002107 2738 Clark Elementary   Regular School No Elementary KG 05 2017   kindergarten_half_day 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
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
622382 WA King   school 5303750 17411   Issaquah School District 530375000576 3962 Liberty Sr High School   Regular School No High 09 12 2017   grade_8 0 0 0   0 2     0   0   2 0 0   0   0   0       0.0 2 0 0 0   0 2     0   0   2 0 0   0 0 0     0 2
622402 WA King   school 5303750 17411   Issaquah School District 530375002981 4592 Newcastle Elementary School   Regular School No Elementary KG 05 2017   kindergarten_half_day 0 0 0   0 0     0   1   1 0 0   0   0   0       0.0 1 0 0 0   0 0     0   1   1 0 0   0 0 0     0 1
622423 WA King   school 5303750 17411   Issaquah School District 530375000581 3386 Sunny Hills Elementary   Regular School No Elementary KG 05 2017   kindergarten_half_day 0 0 1   0 0     0   0   1 0 0   0   0   0       1.0 1 0 0 1   0 0     0   0   1 0 0   0 0 0     1 1
622466 WA Ferry   school 5303870 10003   Keller School District 530387000586 2602 Keller Elementary School   Regular School No Elementary KG 06 2017   grade_1 0 0 0   3 0     0   0   1 2 0   0   1   2       0.0 3 0 0 0   3 0     0   0   1 2 0   0 1 2     0 3
622467 WA Ferry   school 5303870 10003   Keller School District 530387000586 2602 Keller Elementary School   Regular School No Elementary KG 06 2017   grade_2 0 0 0   8 0     0   0   5 3 0   0   3   5       0.0 8 0 0 0   8 0     0   0   5 3 0   0 3 5     0 8
622468 WA Ferry   school 5303870 10003   Keller School District 530387000586 2602 Keller Elementary School   Regular School No Elementary KG 06 2017   grade_3 0 0 0   4 0     0   0   2 2 0   0   1   3       0.0 4 0 0 0   4 0     0   0   2 2 0   0 1 3     0 4
622469 WA Ferry   school 5303870 10003   Keller School District 530387000586 2602 Keller Elementary School   Regular School No Elementary KG 06 2017   grade_4 0 0 0   2 0     0   1   1 2 0   0   2   3       0.0 3 0 0 0   2 0     0   1   1 2 0   0 2 3     0 3
622470 WA Ferry   school 5303870 10003   Keller School District 530387000586 2602 Keller Elementary School   Regular School No Elementary KG 06 2017   grade_5 0 0 0   4 0     0   0   3 1 0   0   1   2       0.0 4 0 0 0   4 0     0   0   3 1 0   0 1 2     0 4
622471 WA Ferry   school 5303870 10003   Keller School District 530387000586 2602 Keller Elementary School   Regular School No Elementary KG 06 2017   grade_6 0 0 0   4 0     0   0   1 3 0   0   1   3       0.0 4 0 0 0   4 0     0   0   1 3 0   0 1 3     0 4
622472 WA Ferry   school 5303870 10003   Keller School District 530387000586 2602 Keller Elementary School   Regular School No Elementary KG 06 2017   pk_12_total 0 0 0   27 0     0   1   14 14 0   0   9   18       0.0 28 0 0 0   27 0     0   1   14 14 0   0 9 18     0 28
622473 WA Ferry   school 5303870 10003   Keller School District 530387000586 2602 Keller Elementary School   Regular School No Elementary KG 06 2017   kindergarten 0 0 0   2 0     0   0   1 1 0   0   0   0       0.0 2 0 0 0   2 0     0   0   1 1 0   0 0 0     0 2
622482 WA Cowlitz   school 5300003 8458   Kelso School District 530000300587 3323 Barnes Elementary   Regular School No Elementary KG 05 2017   pre_kindergarten 0 0 0   0 0     1   0   1 0 0   0   0   1       0.0 1 0 0 0   0 0     1   0   1 0 0   0 0 1     0 1
622567 WA Benton   school 5303930 3017   Kennewick School District 530393002546 4007 Benton/Franklin Juvenile Justice Center   Regular School No Other 06 12 2017   grade_8 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
622617 WA Benton   school 5303930 3017   Kennewick School District 530393000600 3315 Edison Elementary School   Regular School No Elementary PK 05 2017   pre_kindergarten 0 0 1   0 0     0   0   0 1 0   0   0   0       0.0 1 0 0 1   0 0     0   0   0 1 0   0 0 0     0 1
622697 WA Benton   school 5303930 3017   Kennewick School District 530393003584 5438 Sage Crest Elementary   Regular School No Elementary KG 05 2017   pre_kindergarten 0 0 1   0 0     0   0   0 1 0   0   0   0       0.0 1 0 0 1   0 0     0   0   0 1 0   0 0 0     0 1
622731 WA Benton   school 5303930 3017   Kennewick School District 530393000610 3144 Washington Elementary School   Regular School No Elementary KG 05 2017   kindergarten_half_day 0 0 1   0 0     0   0   0 1 0   0   0   1       0.0 1 0 0 1   0 0     0   0   0 1 0   0 0 1     0 1
622741 WA Benton   school 5303930 3017   Kennewick School District 530393000611 2825 Westgate Elementary School   Regular School No Elementary PK 05 2017   pre_kindergarten 0 0 2   0 0     0   0   2 0 0   0   0   1       0.0 2 0 0 2   0 0     0   0   2 0 0   0 0 1     0 2
622792 WA King   school 5303960 17415   Kent School District 530396000614 2851 East Hill Elementary School   Regular School No Elementary PK 06 2017   pre_kindergarten 0 0 1   0 0     0   0   0 1 0   0   0   0       0.0 1 0 0 1   0 0     0   0   0 1 0   0 0 0     0 1
622800 WA King   school 5303960 17415   Kent School District 530396002729 4545 Emerald Park Elementary School   Regular School No Elementary KG 06 2017   kindergarten_half_day 0 0 1   0 0     0   0   1 0 0   0   1   1       1.0 1 0 0 1   0 0     0   0   1 0 0   0 1 1     1 1
622809 WA King   school 5303960 17415   Kent School District 530396000615 3678 Fairwood Elementary School   Regular School No Elementary PK 06 2017   kindergarten_half_day 0 0 0   0 1     0   0   1 0 0   0   0   1       0.0 1 0 0 0   0 1     0   0   1 0 0   0 0 1     0 1
622893 WA King   school 5303960 17415   Kent School District 530396002570 4492 Kentlake High School   Regular School No High 07 12 2017   grade_7 0 1 0   0 0     0   0   1 0 0   1   0   0       0.0 1 0 1 0   0 0     0   0   1 0 0   1 0 0     0 1
622923 WA King   school 5303960 17415   Kent School District 530396002112 4294 Martin Sortun Elementary School   Regular School No Elementary PK 06 2017   pre_kindergarten 0 0 0   0 0     0   2   0 2 0   0   0   0       0.0 2 0 0 0   0 0     0   2   0 2 0   0 0 0     0 2
622963 WA King   school 5303960 17415   Kent School District 530396002799 4581 Millennium Elementary School   Regular School No Elementary PK 06 2017   pre_kindergarten 0 0 3   0 0     0   0   1 2 0   0   0   0       0.0 3 0 0 3   0 0     0   0   1 2 0   0 0 0     0 3
623002 WA King   school 5303960 17415   Kent School District 530396002728 1807 Regional Justice Center   Alternative School No High 09 12 2017   grade_10 0 1 0   0 0     1   0   2 0 0   0   0   2       0.0 2 0 1 0   0 0     1   0   2 0 0   0 0 2     0 2
623003 WA King   school 5303960 17415   Kent School District 530396002728 1807 Regional Justice Center   Alternative School No High 09 12 2017   grade_11 0 2 0   0 0     1   0   3 0 0   0   0   2       0.0 3 0 2 0   0 0     1   0   3 0 0   0 0 2     0 3
623005 WA King   school 5303960 17415   Kent School District 530396002728 1807 Regional Justice Center   Alternative School No High 09 12 2017   grade_9 0 1 0   0 0     0   0   1 0 0   0   0   1       0.0 1 0 1 0   0 0     0   0   1 0 0   0 0 1     0 1
623032 WA King   school 5303960 17415   Kent School District 530396000631 3389 Scenic Hill Elementary School   Regular School No Elementary PK 06 2017   kindergarten_half_day 0 1 0   0 0     0   0   0 1 0   1   0   1       0.0 1 0 1 0   0 0     0   0   0 1 0   1 0 1     0 1
623034 WA King   school 5303960 17415   Kent School District 530396000631 3389 Scenic Hill Elementary School   Regular School No Elementary PK 06 2017   pre_kindergarten 0 0 1   0 0     0   0   1 0 0   0   0   0       0.0 1 0 0 1   0 0     0   0   1 0 0   0 0 0     0 1
623172 WA Skagit   school 5304110 29311   La Conner School District 530411000645 2522 La Conner Elementary   Regular School No Elementary KG 05 2017   grade_6 0 0 0   1 0     0   0   1 0 0   0   0   1       0.0 1 0 0 0   1 0     0   0   1 0 0   0 0 1     0 1
623220 WA Chelan   school 5301200 4129   Lake Chelan School District 530120000219 3861 Holden Village Community School   Regular School No Other KG 12 2017   grade_6 0 1 0   0 0     0   0   1 0 0   0   0   0       0.0 1 0 1 0   0 0     0   0   1 0 0   0 0 0     0 1
623231 WA Chelan   school 5301200 4129   Lake Chelan School District 530120000220 2689 Morgen Owings Elementary School   Regular School No Elementary KG 05 2017   pre_kindergarten 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
623491 WA King   school 5304230 17414   Lake Washington School District 530423000667 3529 Horace Mann Elementary   Regular School No Elementary KG 05 2017   pre_kindergarten 0 0 1   0 0     0   1   2 0 0   0   0   0       0.0 2 0 0 1   0 0     0   1   2 0 0   0 0 0     0 2
623511 WA King   school 5304230 17414   Lake Washington School District 530423000657 3548 John J. Audubon Elementary   Regular School No Elementary KG 05 2017   pre_kindergarten 0 0 1   0 0     0   0   1 0 0   0   0   0       0.0 1 0 0 1   0 0     0   0   1 0 0   0 0 0     0 1
623537 WA King   school 5304230 17414   Lake Washington School District 530423000671 3922 Kamiakin Middle School   Regular School No Middle 06 08 2017   pre_kindergarten 0 0 1   0 0     0   0   1 0 0   0   0   0       0.0 1 0 0 1   0 0     0   0   1 0 0   0 0 0     0 1
623538 WA King   school 5304230 17414   Lake Washington School District 530423000672 2308 Kirkland Middle School   Regular School No Middle 06 08 2017   grade_5 0 1 0   0 0     0   0   1 0 0   0   0   0       0.0 1 0 1 0   0 0     0   0   1 0 0   0 0 0     0 1
623555 WA King   school 5304230 17414   Lake Washington School District 530423000675 3041 Lakeview Elementary   Regular School No Elementary KG 05 2017   pre_kindergarten 0 1 0   0 0     0   0   1 0 0   0   0   1       0.0 1 0 1 0   0 0     0   0   1 0 0   0 0 1     0 1
623632 WA King   school 5304230 17414   Lake Washington School District 530423000680 3232 Redmond Middle School   Regular School No Middle 06 08 2017   grade_5 0 0 0   0 1     0   0   1 0 0   1   0   0       0.0 1 0 0 0   0 1     0   0   1 0 0   1 0 0     0 1
623647 WA King   school 5304230 17414   Lake Washington School District 530423000681 3675 Robert Frost Elementary   Regular School No Elementary KG 05 2017   kindergarten_half_day 0 0 0   0 0     0   1   1 0 0   0   0   0       0.0 1 0 0 0   0 0     0   1   1 0 0   0 0 0     0 1
623790 WA Cowlitz   school 5304470 8122   Longview School District 530447000702 2319 Kessler Elementary School   Regular School No Elementary KG 05 2017   pre_kindergarten 0 0 0   1 0     0   0   1 0 0   0   0   1       0.0 1 0 0 0   1 0     0   0   1 0 0   0 0 1     0 1
623878 WA San Juan   school 5304530 28144   Lopez School District 530453001846 4178 Decatur Elementary   Regular School No Elementary KG 08 2017   kindergarten_half_day 0 0 0   0 0     0   1   1 0 0   0   0   0       0.0 1 0 0 0   0 0     0   1   1 0 0   0 0 0     0 1
623895 WA Whatcom   school   37903   Lummi Tribal Agency   5373 Lummi Nation School             2017   grade_10 0 0 0   19 0     0   1   13 7 0   0   0   14       0.0 20 0 0 0   19 0     0   1   13 7 0   0 0 14     0 20
623896 WA Whatcom   school   37903   Lummi Tribal Agency   5373 Lummi Nation School             2017   grade_11 0 0 2   16 0     0   2   10 10 0   0   0   18       0.0 20 0 0 2   16 0     0   2   10 10 0   0 0 18     0 20
623897 WA Whatcom   school   37903   Lummi Tribal Agency   5373 Lummi Nation School             2017   grade_12 0 0 1   31 0     0   2   25 9 0   0   0   25       1.0 34 0 0 1   31 0     0   2   25 9 0   0 0 25     1 34
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
623901 WA Whatcom   school   37903   Lummi Tribal Agency   5373 Lummi Nation School             2017   grade_4 0 0 1   12 0     0   1   10 4 0   0   0   14       0.0 14 0 0 1   12 0     0   1   10 4 0   0 0 14     0 14
623902 WA Whatcom   school   37903   Lummi Tribal Agency   5373 Lummi Nation School             2017   grade_5 0 0 0   22 0     0   0   10 12 0   0   0   19       0.0 22 0 0 0   22 0     0   0   10 12 0   0 0 19     0 22
623904 WA Whatcom   school   37903   Lummi Tribal Agency   5373 Lummi Nation School             2017   grade_7 0 0 1   21 0     0   2   14 10 0   0   0   21       0.0 24 0 0 1   21 0     0   2   14 10 0   0 0 21     0 24
623906 WA Whatcom   school   37903   Lummi Tribal Agency   5373 Lummi Nation School             2017   grade_9 0 0 2   20 0     0   1   15 8 0   0   0   22       0.0 23 0 0 2   20 0     0   1   15 8 0   0 0 22     0 23
623908 WA Whatcom   school   37903   Lummi Tribal Agency   5373 Lummi Nation School             2017   kindergarten 0 0 0   20 0     0   1   13 8 0   0   0   21       0.0 21 0 0 0   20 0     0   1   13 8 0   0 0 21     0 21
623941 WA Whatcom   school 5304620 37504   Lynden School District 530462002260 4324 Isom Elementary School   Regular School No Elementary KG 05 2017   kindergarten_half_day 0 0 1   0 0     0   0   0 1 0   1   0   1       0.0 1 0 0 1   0 0     0   0   0 1 0   1 0 1     0 1
623977 WA Whatcom   school 5304620 37504   Lynden School District 530462002605 4517 Vossbeck Elementary School   Regular School No Elementary KG 05 2017   pre_kindergarten 0 1 1   0 0     0   0   1 1 0   1   0   1       0.0 2 0 1 1   0 0     0   0   1 1 0   1 0 1     0 2
623983 WA Yakima   school 5304650 39120   Mabton School District 530465000723 3070 Artz Fox Elementary   Regular School No Elementary KG 06 2017   grade_6 0 0 55   0 0     0   0   29 26 0   30   2   55       1.0 55 0 0 55   0 0     0   0   29 26 0   30 2 55     1 55
623985 WA Yakima   school 5304650 39120   Mabton School District 530465000723 3070 Artz Fox Elementary   Regular School No Elementary KG 06 2017   kindergarten 0 0 57   0 0     0   0   32 25 0   39   2   56       0.0 57 0 0 57   0 0     0   0   32 25 0   39 2 56     0 57
623986 WA Yakima   school 5304650 39120   Mabton School District 530465000723 3070 Artz Fox Elementary   Regular School No Elementary KG 06 2017   pre_kindergarten 0 0 39   0 0     0   0   25 14 0   2   1   37       0.0 39 0 0 39   0 0     0   0   25 14 0   2 1 37     0 39
623989 WA Yakima   school 5304650 39120   Mabton School District 530465003406 5289 Mabton Jr. Sr. High   Regular School No High 07 12 2017   grade_12 0 0 48   0 0     0   0   26 22 0   12   6   44       0.0 48 0 0 48   0 0     0   0   26 22 0   12 6 44     0 48
624007 WA Douglas   school 5304710 9207   Mansfield School District 530471000726 2233 Mansfield Elem and High School   Regular School No Other PK 12 2017   kindergarten_half_day 0 0 1   0 0     0   0   0 1 0   0   0   1       0.0 1 0 0 1   0 0     0   0   0 1 0   0 0 1     0 1
624017 WA Chelan   school 5304740 4019   Manson School District 530474000727 2196 Manson Elementary   Regular School No Elementary KG 05 2017   kindergarten 0 0 1   0 0     0   0   1 0 0   0   1   1       0.0 1 0 0 1   0 0     0   0   1 0 0   0 1 1     0 1
624053 WA Mason   school 5304800 23311   Mary M Knight School District 530480003569 5445 Washington Connections Academy   Regular School No Elementary KG 08 2017   pre_kindergarten 0 1 1   0 0     0   0   1 1 0   0   0   2       1.0 2 0 1 1   0 0     0   0   1 1 0   0 0 2     1 2
624059 WA Stevens   school 5304830 33207   Mary Walker School District 530483003591 5446 Mary Walker Alternative Learning Experience   Alternative School No Other KG 12 2017   grade_3 0 0 1   0 0     0   1   0 2 0   0   0   2       0.0 2 0 0 1   0 0     0   1   0 2 0   0 0 2     0 2
624067 WA Stevens   school 5304830 33207   Mary Walker School District 530483003591 5446 Mary Walker Alternative Learning Experience   Alternative School No Other KG 12 2017   kindergarten_half_day 0 0 0   1 0     0   1   1 1 0   0   0   2       0.0 2 0 0 0   1 0     0   1   1 1 0   0 0 2     0 2
624139 WA Snohomish   school 5304860 31025   Marysville School District 530486002476 1657 Heritage School   Regular School No High 09 12 2017   grade_9 0 0 3   13 0     0   3   8 11 0   8   2   13       0.0 19 0 0 3   13 0     0   3   8 11 0   8 2 13     0 19
624180 WA Snohomish   school 5304860 31025   Marysville School District 530486002848 1862 Marysville Coop Program   Regular School No Elementary KG 05 2017   kindergarten_half_day 0 0 0   0 0     0   1   0 1 0   0   0   1       0.0 1 0 0 0   0 0     0   1   0 1 0   0 0 1     0 1
624199 WA Snohomish   school 5304860 31025   Marysville School District 530486002900 1910 Marysville SD Special   Special Education School No Other PK 13 2017   grade_10 0 0 0   1 0     0   0   1 0 0   0   0   1       0.0 1 0 0 0   1 0     0   0   1 0 0   0 0 1     0 1
624205 WA Snohomish   school 5304860 31025   Marysville School District 530486002900 1910 Marysville SD Special   Special Education School No Other PK 13 2017   grade_6 0 0 0   1 0     0   0   1 0 0   0   0   1       0.0 1 0 0 0   1 0     0   0   1 0 0   0 0 1     0 1
624207 WA Snohomish   school 5304860 31025   Marysville School District 530486002900 1910 Marysville SD Special   Special Education School No Other PK 13 2017   grade_8 0 0 1   0 0     0   1   2 0 0   0   1   0       0.0 2 0 0 1   0 0     0   1   2 0 0   0 1 0     0 2

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