Data source: Big Local News · About: Big Local

650 rows where grade = "grade_7", state = "WA" and year = 2019 sorted by white

View and edit SQL

year

  • 2019 · 650

grade

  • grade_7 · 650
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
2412998 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000001 2834 A J West Elementary   Regular School No Elementary PK 06 2019   grade_7 0 0 1   0 0     0   0   1 0 0   1   0   1       0.0 1 0 0 1   0 0     0   0   1 0 0   1 0 1     0 1
2414506 WA Clallam   school 5300840 5401   Cape Flattery School District 530084000165 3145 Neah Bay Junior/ Senior High School   Regular School No High 06 12 2019   grade_7 0 0 5   10 0     0   6   6 15 0   0   0   16       1.0 21 0 0 5   10 0     0   6   6 15 0   0 0 16     1 21
2415115 WA Pierce   school   27901   Chief Leschi Schools   5549 Chief Leschi Schools             2019   grade_7 0 0 4   39 0     0   4   26 21 0   0   1   2       0.0 47 0 0 4   39 0     0   4   26 21 0   0 1 2     0 47
2415377 WA Pierce   school 5301410 27400   Clover Park School District 530141001897 3910 Oak Grove   Regular School No Elementary KG 07 2019   grade_7 0 1 0   0 1     0   1   2 1 0   0   0   1       0.0 3 0 1 0   0 1     0   1   2 1 0   0 0 1     0 3
2415559 WA Stevens   school 5301630 33115   Colville School District 530163003305 1594 Panorama School   Alternative School No Other PK 12 2019   grade_7 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
2416155 WA Snohomish   school 5302400 31015   Edmonds School District 530240002821 1830 Contracted Schools   Special Education School No Other PK 12 2019   grade_7 0 0 0   0 0     0   2   2 0 0   0   0   0       0.0 2 0 0 0   0 0     0   2   2 0 0   0 0 0     0 2
2416613 WA Skagit   school 5300008 29801   ESD 189 acting as a school district 530000802923 3420 Whatcom Co Detention Center   Regular School No High 07 12 2019   grade_7 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
2417312 WA King   school 5302820 17210   Federal Way School District 530282002961 1951 Support School   Regular School No Other PK 12 2019   grade_7 0 1 1   0 0     0   1   1 2 0   0   0   2       0.0 3 0 1 1   0 0     0   1   1 2 0   0 0 2     0 3
2418129 WA Ferry   school 5300002 10070   Inchelium School District 530000202870 4214 Inchelium Middle School   Regular School No Middle 06 08 2019   grade_7 0 0 0   15 0     0   5   9 11 0   11   0   17       0.0 20 0 0 0   15 0     0   5   9 11 0   11 0 17     0 20
2419786 WA Whatcom   school   37903   Lummi Tribal Agency   5373 Lummi Nation School             2019   grade_7 0 0 0   28 0     0   0   13 15 0   0   2   27       0.0 28 0 0 0   28 0     0   0   13 15 0   0 2 27     0 28
2420751 WA Skagit   school 5305400 29320   Mount Vernon School District 530540001724 3829 Mount Vernon Special Ed   Special Education School No Other PK 12 2019   grade_7 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
2420791 WA King   school   17903   Muckleshoot Indian Tribe   1986 Muckleshoot Tribal School             2019   grade_7 0 0 1   27 0     0   0   16 12 0   0   0   19       0.0 28 0 0 1   27 0     0   0   16 12 0   0 0 19     0 28
2421093 WA Grays Harbor   school 5305700 14064   North Beach School District No. 64 530570000844 3787 Ocean Shores Elementary   Regular School No Elementary PK 06 2019   grade_7 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
2421459 WA Stevens   school 5305880 33211   Northport School District 530588003370 5252 Northport Homelink Program   Alternative School No Other KG 12 2019   grade_7 0 0 1   0 1     0   0   1 1 0   0   0   0       0.0 2 0 0 1   0 1     0   0   1 1 0   0 0 0     0 2
2422078 WA Okanogan   school   24019   Omak School District   4278 Paschal Sherman             2019   grade_7 0 0 1   12 0     0   0   9 4 0   0   4   13       0.0 13 0 0 1   12 0     0   0   9 4 0   0 4 13     0 13
2422340 WA Franklin   school 5306570 11001   Pasco School District 530657003292 5164 Chiawana Senior High School   Regular School No High 08 12 2019   grade_7 0 0 2   0 0     0   0   2 0 0   1   0   2       0.0 2 0 0 2   0 0     0   0   2 0 0   1 0 2     0 2
2423002 WA Pierce   school 5306960 27003   Puyallup School District 530696003449 5322 Puyallup Parent Partnership Program   Alternative School No Elementary KG 08 2019   grade_7 0 0 0   0 0     0   1   0 1 0   0   0   1       1.0 1 0 0 0   0 0     0   1   0 1 0   0 0 1     1 1
2423129 WA Clallam   school   5903   Quileute Tribal School District   5430 Quileute Tribal School             2019   grade_7 0 0 3   6 0     0   0   3 6 0   0   0   7       0.0 9 0 0 3   6 0     0   0   3 6 0   0 0 7     0 9
2423184 WA Grant   school 5307080 13144   Quincy School District 530708002714 4536 Monument Elementary   Regular School No Middle 04 06 2019   grade_7 0 0 2   0 0     0   0   1 1 0   2   0   2       0.0 2 0 0 2   0 0     0   0   1 1 0   2 0 2     0 2
2423583 WA Benton   school 5307320 3400   Richland School District 530732002941 2001 Special Programs   Special Education School No Other PK 12 2019   grade_7 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
2425361 WA Kitsap   school 5308160 18402   South Kitsap School District 530816001357 2272 South Kitsap High School   Regular School No High 09 12 2019   grade_7 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
2426670 WA Grays Harbor   school 5308730 14077   Taholah School District 530873002956 5032 Taholah Elementary & Middle School   Regular School No Elementary KG 08 2019   grade_7 0 0 2   15 0     0   1   13 5 0   0   2   12       0.0 18 0 0 2   15 0     0   1   13 5 0   0 2 12     0 18
2426802 WA Lewis   school 5308910 21237   Toledo School District 530891001526 2998 Toledo Elementary School   Regular School No Elementary PK 05 2019   grade_7 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
2427377 WA Clark   school 5309270 6037   Vancouver School District 530927003246 5149 Vancouver Virtual Learning Academy   Alternative School No High 06 12 2019   grade_7 0 0 1   0 0     1   3   2 3 0   1   1   4       0.0 5 0 0 1   0 0     1   3   2 3 0   1 1 4     0 5
2427440 WA Thurston   school   34901   WA HE LUT Indian School Agency   5496 Wa He Lut Indian School             2019   grade_7 0 1 1   16 0     0   1   9 10 0   0   3   18       0.0 19 0 1 1   16 0     0   1   9 10 0   0 3 18     0 19
2428295 WA Yakima   school 5310110 39007   Yakima School District 531011001814 3817 Martin Luther King Jr Elementary   Regular School No Elementary KG 05 2019   grade_7 0 0 2   0 0     0   0   0 2 0   0   0   2       0.0 2 0 0 2   0 0     0   0   0 2 0   0 0 2     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
2413388 WA Kitsap   school 5300330 18303   Bainbridge Island School District 530033003113 1939 Bainbridge Special Education Services   Special Education School No Other PK 12 2019   grade_7 1 0 1   0 0     0   0   2 0 0   0   0   0       0.0 2 1 0 1   0 0     0   0   2 0 0   0 0 0     0 2
2414237 WA Kitsap   school 5300660 18100   Bremerton School District 530066002652 1749 Bremerton Homelink Program   Alternative School No Elementary KG 08 2019   grade_7 1 0 1   0 0     0   0   1 1 0   0   0   1       0.0 2 1 0 1   0 0     0   0   1 1 0   0 0 1     0 2
2414768 WA Spokane   school 5301110 32356   Central Valley School District 530111000191 3065 Central Valley High School   Regular School No High 09 12 2019   grade_7 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
2414983 WA Lewis   school 5301170 21302   Chehalis School District 530117002883 1559 Lewis County Juvenile Detention   Regular School No High 05 12 2019   grade_7 1 0 2   0 0     0   0   1 2 0   0   0   2       0.0 3 1 0 2   0 0     0   0   1 2 0   0 0 2     0 3
2415150 WA Jefferson   school 5301290 16049   Chimacum School District 530129002630 1724 PI Program   Alternative School No Other KG 12 2019   grade_7 1 0 1   0 0     0   0   0 2 0   0   0   1       0.0 2 1 0 1   0 0     0   0   0 2 0   0 0 1     0 2
2415434 WA Pierce   school 5301410 27400   Clover Park School District 530141003396 5297 Transition Day Students   Regular School No High 05 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
2415570 WA Skagit   school 5301660 29011   Concrete School District 530166000285 2577 Concrete Elementary   Regular School No Elementary KG 06 2019   grade_7 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
2415875 WA Spokane   school 5302280 32361   East Valley School District (Spokane) 530228003581 5432 EV Online   Alternative School No High 07 12 2019   grade_7 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
2416348 WA Snohomish   school 5302400 31015   Edmonds School District 530240002290 1558 Unassigned School   Special Education School No Other PK 09 2019   grade_7 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
2416371 WA Kittitas   school 5302460 19401   Ellensburg School District 530246003168 5097 K-12 Ellensburg Learning Center   Alternative School No Other PK 12 2019   grade_7 1 0 0   0 0     0   0   0 1 0   1   0   1       0.0 1 1 0 0   0 0     0   0   0 1 0   1 0 1     0 1
2416578 WA Clark   school 5300005 6801   ESD 112 acting as a school district 530000503407 5290 Clark County Juvenile Detention School   Regular School No Other 03 12 2019   grade_7 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
2416584 WA Clark   school 5300005 6801   ESD 112 acting as a school district 530000502917 3294 Cowlitz County Youth Services Center   Regular School No High 06 12 2019   grade_7 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
2416834 WA Clark   school 5302700 6114   Evergreen School District (Clark) 530270001270 1646 49th Street Academy   Special Education School No Other KG 12 2019   grade_7 1 0 0   0 0     0   1   2 0 0   0   0   2       0.0 2 1 0 0   0 0     0   1   2 0 0   0 0 2     0 2
2416973 WA Clark   school 5302700 6114   Evergreen School District (Clark) 530270000412 4042 Legacy High School   Alternative School No High 06 12 2019   grade_7 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
2418137 WA Snohomish   school 5303720 31063   Index Elementary School District 63 530372000569 2948 Index Elementary School District 63   Regular School No Elementary PK 08 2019   grade_7 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
2418211 WA King   school 5303750 17411   Issaquah School District 530375001773 3569 Echo Glen School   Regular School No High 05 12 2019   grade_7 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
2418249 WA King   school 5303750 17411   Issaquah School District 530375001490 1624 Issaquah Special Services   Special Education School No Other PK 12 2019   grade_7 1 1 0   0 0     0   0   1 1 0   0   0   2       0.0 2 1 1 0   0 0     0   0   1 1 0   0 0 2     0 2
2420058 WA Snohomish   school 5304860 31025   Marysville School District 530486002900 1910 Marysville SD Special   Special Education School No Other PK 12 2019   grade_7 1 0 1   0 0     0   0   2 0 0   0   2   2       0.0 2 1 0 1   0 0     0   0   2 0 0   0 2 2     0 2
2420669 WA Whatcom   school 5305310 37507   Mount Baker School District 530531003211 5112 Mount Baker Academy   Alternative School No Other KG 12 2019   grade_7 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
2420923 WA Snohomish   school 5305430 31006   Mukilteo School District 530543002820 1848 Special Services   Special Education School No Other PK 12 2019   grade_7 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
2420991 WA Okanogan   school 5305550 24014   Nespelem School District #14 530555000832 2494 Nespelem Elementary   Regular School No Elementary PK 08 2019   grade_7 1 0 0   12 0     0   0   9 4 0   9   0   13       0.0 13 1 0 0   12 0     0   0   9 4 0   9 0 13     0 13
2421269 WA Mason   school 5305790 23403   North Mason School District 530579002847 1861 North Mason Homelink Program   Alternative School No Other KG 12 2019   grade_7 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
2421819 WA Pacific   school 5306060 25101   Ocean Beach School District 530606003565 5454 Ocean Beach Alternative School (Closed after 2019-2020 school year)   Alternative School No High 06 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
2422366 WA Franklin   school 5306570 11001   Pasco School District 530657003547 5393 Internet Pasco Academy of Learning   Alternative School No Elementary KG 08 2019   grade_7 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
2422685 WA Clallam   school 5306820 5121   Port Angeles School District 530682002551 1715 Parents As Partners (Closed after 2018-2019 school year)   Alternative School No Elementary KG 08 2019   grade_7 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
2423141 WA Clallam   school 5307020 5402   Quillayute Valley School District 530702002507 1671 District Run Home School   Alternative School No Other KG 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
2423405 WA King   school 5307230 17403   Renton School District 530723003073 5070 Renton Academy   Alternative School No Other KG 12 2019   grade_7 1 1 2   0 0     0   0   4 0 0   0   0   3       0.0 4 1 1 2   0 0     0   0   4 0 0   0 0 3     0 4
2423851 WA San Juan   school 5307650 28149   San Juan Island School District 530765003136 1963 Griffin Bay School   Alternative School No Other KG 12 2019   grade_7 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
2424488 WA King   school 5307710 17001   Seattle School District No. 1 530771001311 1596 Seattle World School   Alternative School No High 06 12 2019   grade_7 1 2 5   0 7     0   0   8 7 0   9   4   14       0.0 15 1 2 5   0 7     0   0   8 7 0   9 4 14     0 15
2424708 WA Yakima   school 5307770 39119   Selah School District 530777003348 5231 Selah HomeLink   Regular School No Elementary KG 08 2019   grade_7 1 0 2   0 0     0   0   2 1 0   0   0   0       0.0 3 1 0 2   0 0     0   0   2 1 0   0 0 0     0 3
2424779 WA San Juan   school 5307860 28010   Shaw Island School District 530786001291 3725 Shaw Island Elementary School   Regular School No Elementary KG 08 2019   grade_7 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
2424875 WA King   school 5307920 17412   Shoreline School District 530792002447 1667 Handicapped Contractual Services   Special Education School No Other PK 12 2019   grade_7 1 1 0   0 1     0   0   2 1 0   0   0   1       0.0 3 1 1 0   0 1     0   0   2 1 0   0 0 1     0 3
2425055 WA Snohomish   school 5308020 31201   Snohomish School District 530802002894 1904 Parent Partnership   Alternative School No Other KG 12 2019   grade_7 1 1 0   0 0     0   0   1 1 0   0   0   0       0.0 2 1 1 0   0 0     0   0   1 1 0   0 0 0     0 2
2425151 WA King   school 5308040 17410   Snoqualmie Valley School District 530804003309 5181 Snoqualmie Access   Special Education School No Other PK 12 2019   grade_7 1 0 0   0 0     0   0   1 0 0   0   0   0       1.0 1 1 0 0   0 0     0   0   1 0 0   0 0 0     1 1
2425240 WA Pacific   school 5308100 25118   South Bend School District 530810003365 5243 Pacific Virtual Learning   Alternative School No Other KG 12 2019   grade_7 1 0 0   0 1     0   0   0 2 0   0   1   0       0.0 2 1 0 0   0 1     0   0   0 2 0   0 1 0     0 2
2425962 WA Columbia   school 5308400 7035   Starbuck School District 530840001427 2135 Starbuck School   Regular School No Elementary PK 08 2019   grade_7 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
2426254 WA Kitsap   school 5300328 18902   Suquamish Tribal Education Department 530032803493 5319 Chief Kitsap Academy   Regular School No Other KG 12 2019   grade_7 1 0 0   3 0     0   0   3 1 0   0   0   3       0.0 4 1 0 0   3 0     0   0   3 1 0   0 0 3     0 4
2426588 WA Pierce   school 5308700 27010   Tacoma School District 530870003275 5192 Special Services   Alternative School No Other PK 12 2019   grade_7 1 3 0   0 0     0   1   4 1 0   0   1   4       0.0 5 1 3 0   0 0     0   1   4 1 0   0 1 4     0 5
2427037 WA Thurston   school 5309100 34033   Tumwater School District 530910002380 3925 Thurs Co Juv Det/Tumwater West E   Regular School No High 06 12 2019   grade_7 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
2427743 WA Stevens   school 5309630 33049   Wellpinit School District #49 530963003150 4232 Wellpinit Middle School   Regular School No Middle 06 08 2019   grade_7 1 0 2   17 0     0   4   14 10 0   6   7   22       0.0 24 1 0 2   17 0     0   4   14 10 0   6 7 22     0 24
2427806 WA Chelan   school 5309660 4246   Wenatchee School District 530966001636 3269 Special Education School   Special Education School No Other PK 09 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
2427959 WA Yakima   school 5309720 39208   West Valley School District (Yakima) 530972002545 4506 West Valley Middle School   Regular School No Middle 05 06 2019   grade_7 1 0 0   0 1     0   0   1 1 0   1   0   1       0.0 2 1 0 0   0 1     0   0   1 1 0   1 0 1     0 2
2428178 WA Cowlitz   school 5310050 8404   Woodland School District 531005003371 5246 Lewis River Academy   Alternative School No Other KG 12 2019   grade_7 1 0 2   0 0     0   0   1 2 0   0   0   1       0.0 3 1 0 2   0 0     0   0   1 2 0   0 0 1     0 3
2428232 WA Yakima   school 5310110 39007   Yakima School District 531011001689 2116 Davis High School   Regular School No High 09 12 2019   grade_7 1 0 0   0 0     0   0   0 1 0   1   0   1       0.0 1 1 0 0   0 0     0   0   0 1 0   1 0 1     0 1
2419633 WA Adams   school 5304410 1158   Lind School District 530441003416 5293 Lind-Ritzville Middle School   Regular School No Middle 06 08 2019   grade_7 10 0 5   0 0     0   0   6 9 0   2   2   11       1.0 15 10 0 5   0 0     0   0   6 9 0   2 2 11     1 15
2424761 WA Clallam   school 5307830 5323   Sequim School District 530783002552 1708 Olympic Peninsula Academy   Alternative School No Other PK 12 2019   grade_7 10 0 1   0 0     0   2   9 4 0   0   0   6       0.0 13 10 0 1   0 0     0   2   9 4 0   0 0 6     0 13
2426751 WA Whitman   school 5308790 38265   Tekoa School District 530879001521 3418 Tekoa High School   Regular School No High 07 12 2019   grade_7 10 0 4   1 0     0   1   10 6 0   0   0   9       0.0 16 10 0 4   1 0     0   1   10 6 0   0 0 9     0 16
2427164 WA Clark   school 5309270 6037   Vancouver School District 530927002018 4503 Discovery Middle School   Regular School No Middle 06 08 2019   grade_7 100 9 100   1 3     2   19   111 123 0   41   9   173       10.0 234 100 9 100   1 3     2   19   111 123 0   41 9 173     10 234
2415964 WA Douglas   school 5302310 9206   Eastmont School District 530231002948 4590 Clovis Point Intermediate School   Regular School No Middle 05 07 2019   grade_7 101 1 128   1 0     0   6   119 118 0   34   5   152       18.0 237 101 1 128   1 0     0   6   119 118 0   34 5 152     18 237
2420402 WA Snohomish   school 5305130 31103   Monroe School District 530513002761 4544 Hidden River Middle School   Regular School No Middle 06 08 2019   grade_7 101 0 29   2 3     0   5   68 72 0   10   1   48       6.0 140 101 0 29   2 3     0   5   68 72 0   10 1 48     6 140
2423455 WA King   school 5307230 17403   Renton School District 530723003603 5484 Vera Risdon Middle School   Regular School No Middle 06 08 2019   grade_7 101 25 50   1 75     0   25   148 129 0   16   5   118       30.0 277 101 25 50   1 75     0   25   148 129 0   16 5 118     30 277
2427538 WA Walla Walla   school 5309450 36140   Walla Walla Public Schools 530945001601 3510 Garrison Middle School   Regular School No Middle 06 08 2019   grade_7 101 1 77   1 4     0   5   117 72 0   27   5   95       7.0 189 101 1 77   1 4     0   5   117 72 0   27 5 95     7 189
2420516 WA Grant   school 5305220 13161   Moses Lake School District 530522002625 2673 Frontier Middle School   Regular School No Middle 06 08 2019   grade_7 102 6 115   1 3     0   5   115 117 0   31   5   149       7.0 232 102 6 115   1 3     0   5   115 117 0   31 5 149     7 232
2421256 WA Mason   school 5305790 23403   North Mason School District 530579000860 3174 Hawkins Middle School   Regular School No Middle 06 08 2019   grade_7 102 2 38   3 0     2   6   84 69 0   13   11   96       9.0 153 102 2 38   3 0     2   6   84 69 0   13 11 96     9 153
2413327 WA King   school 5300300 17408   Auburn School District 530030001443 4462 Mt Baker Middle School   Regular School No Middle 06 08 2019   grade_7 104 12 108   0 33     21   40   162 156 0   50   5   159       7.0 318 104 12 108   0 33     21   40   162 156 0   50 5 159     7 318
2413921 WA Whatcom   school 5300420 37501   Bellingham School District 530042000114 3201 Shuksan Middle School   Regular School No Middle 06 08 2019   grade_7 104 4 81   2 25     1   18   111 124 0   39   12   146       16.0 235 104 4 81   2 25     1   18   111 124 0   39 12 146     16 235
2416052 WA Pierce   school 5302370 27404   Eatonville School District 530237001899 4230 Eatonville Middle School   Regular School No Middle 06 08 2019   grade_7 105 0 10   1 1     0   9   57 69 0   1   4   46       5.0 126 105 0 10   1 1     0   9   57 69 0   1 4 46     5 126
2419051 WA Clark   school 5304170 6101   La Center School District 530417000649 3371 La Center Middle School   Regular School No Middle 06 08 2019   grade_7 105 1 12   0 0     0   5   69 54 0   3   2   40       14.0 123 105 1 12   0 0     0   5   69 54 0   3 2 40     14 123
2427286 WA Clark   school 5309270 6037   Vancouver School District 530927001577 3146 Mcloughlin Middle School   Regular School No Middle 06 08 2019   grade_7 105 11 160   2 10     23   24   172 163 0   90   15   272       8.0 335 105 11 160   2 10     23   24   172 163 0   90 15 272     8 335
2414152 WA Pierce   school 5300480 27403   Bethel School District 530048000128 3751 Spanaway Middle School   Regular School No Middle 06 08 2019   grade_7 106 25 56   0 12     10   45   131 124 0   22   7   168       7.0 255 106 25 56   0 12     10   45   131 124 0   22 7 168     7 255
2417737 WA Snohomish   school 5303210 31332   Granite Falls School District 530321001770 4113 Granite Falls Middle School   Regular School No Middle 06 08 2019   grade_7 106 4 17   3 0     0   11   81 60 0   1   5   70       3.0 141 106 4 17   3 0     0   11   81 60 0   1 5 70     3 141
2419525 WA King   school 5304230 17414   Lake Washington School District 530423000680 3232 Redmond Middle School   Regular School No Middle 06 08 2019   grade_7 106 6 48   1 127     0   33   160 161 0   19   3   55       20.0 321 106 6 48   1 127     0   33   160 161 0   19 3 55     20 321
2414081 WA Pierce   school 5300480 27403   Bethel School District 530048003343 5206 Liberty Middle School   Regular School No Middle 06 08 2019   grade_7 108 17 59   2 11     12   43   124 131 0   13   5   129       12.0 255 108 17 59   2 11     12   43   124 131 0   13 5 129     12 255
2413253 WA King   school 5300300 17408   Auburn School District 530030000033 2394 Cascade Middle School   Regular School No Middle 06 08 2019   grade_7 109 32 82   1 24     13   27   148 140 0   43   9   189       8.0 288 109 32 82   1 24     13   27   148 140 0   43 9 189     8 288
2416471 WA King   school 5300001 17216   Enumclaw School District 530000102054 4210 Enumclaw Middle School   Regular School No Middle 06 08 2019   grade_7 109 0 26   3 1     1   6   70 76 0   10   6   62       7.0 146 109 0 26   3 1     1   6   70 76 0   10 6 62     7 146
2420254 WA Spokane   school 5304950 32326   Medical Lake School District 530495000756 3965 Medical Lake Middle School   Regular School No Middle 06 08 2019   grade_7 109 3 13   1 2     2   11   70 71 0   0   0   58       13.0 141 109 3 13   1 2     2   11   70 71 0   0 0 58     13 141
2413809 WA Whatcom   school 5300420 37501   Bellingham School District 530042003476 5366 Bellingham Family Partnership Program   Alternative School No Other KG 12 2019   grade_7 11 1 0   0 0     0   2   8 6 0   0   0   1       2.0 14 11 1 0   0 0     0   2   8 6 0   0 0 1     2 14
2414610 WA Kitsap   school 5301080 18401   Central Kitsap School District 530108003622 5472 Barker Creek Community School   Alternative School No Other KG 12 2019   grade_7 11 1 1   0 0     0   2   6 9 0   0   0   2       0.0 15 11 1 1   0 0     0   2   6 9 0   0 0 2     0 15
2415678 WA Lincoln   school 5301860 22073   Creston School District 530186000294 2863 Creston Jr-Sr High School   Regular School No High 07 12 2019   grade_7 11 0 0   1 0     0   1   6 7 0   0   1   5       0.0 13 11 0 0   1 0     0   1   6 7 0   0 1 5     0 13
2415691 WA Ferry   school 5301890 10050   Curlew School District 530189000295 2006 Curlew Elem & High School   Regular School No Other PK 12 2019   grade_7 11 0 2   1 0     0   0   7 7 0   0   1   14       0.0 14 11 0 2   1 0     0   0   7 7 0   0 1 14     0 14
2422303 WA Whitman   school 5306540 38301   Palouse School District 530654003134 1961 Palouse at Garfield Middle School   Regular School No Middle 06 08 2019   grade_7 11 0 1   0 0     0   2   6 8 0   0   0   8       0.0 14 11 0 1   0 0     0   2   6 8 0   0 0 8     0 14
2423235 WA King   school 5300342 17910   Rainier Valley Leadership Academy 530034203602 5468 Rainier Valley Leadership Academy   Regular School Yes Middle 06 09 2019   grade_7 11 83 10   0 5     0   4   52 61 0   22   4   85       1.0 113 11 83 10   0 5     0   4   52 61 0   22 4 85     1 113
2424368 WA King   school 5307710 17001   Seattle School District No. 1 530771002231 4065 Orca K-8 School   Alternative School No Elementary KG 08 2019   grade_7 11 13 4   0 1     0   1   15 15 0   4   0   13       1.0 30 11 13 4   0 1     0   1   15 15 0   4 0 13     1 30

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