Data source: Big Local News · About: Big Local

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

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
620429 WA Snohomish   school 5302400 31015   Edmonds School District 530240002290 1558 Unassigned School   Special Education School No Other PK 09 2017   kindergarten 1 0 1   0 0     0   0   0 2 0   0   0   0       0.0 2 1 0 1   0 0     0   0   0 2 0   0 0 0     0 2
620430 WA Snohomish   school 5302400 31015   Edmonds School District 530240002290 1558 Unassigned School   Special Education School No Other PK 09 2017   pre_kindergarten 49 5 20   1 8     0   13   67 29 0   0   1   12       1.0 96 49 5 20   1 8     0   13   67 29 0   0 1 12     1 96
619035 WA Lewis   school 5301170 21302   Chehalis School District 530117002883 1559 Lewis County Juvenile Detention   Regular School No Other 05 12 2017   grade_10 1 0 1   0 0     0   0   2 0 0   0   0   2       0.0 2 1 0 1   0 0     0   0   2 0 0   0 0 2     0 2
619036 WA Lewis   school 5301170 21302   Chehalis School District 530117002883 1559 Lewis County Juvenile Detention   Regular School No Other 05 12 2017   grade_11 2 0 1   0 1     0   0   4 0 0   0   0   3       0.0 4 2 0 1   0 1     0   0   4 0 0   0 0 3     0 4
619037 WA Lewis   school 5301170 21302   Chehalis School District 530117002883 1559 Lewis County Juvenile Detention   Regular School No Other 05 12 2017   grade_12 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
619038 WA Lewis   school 5301170 21302   Chehalis School District 530117002883 1559 Lewis County Juvenile Detention   Regular School No Other 05 12 2017   grade_8 1 0 1   0 0     0   0   1 1 0   0   0   0       0.0 2 1 0 1   0 0     0   0   1 1 0   0 0 0     0 2
619039 WA Lewis   school 5301170 21302   Chehalis School District 530117002883 1559 Lewis County Juvenile Detention   Regular School No Other 05 12 2017   pk_12_total 4 1 3   0 1     0   0   8 1 0   0   0   5       0.0 9 4 1 3   0 1     0   0   8 1 0   0 0 5     0 9
618215 WA Pierce   school 5300480 27403   Bethel School District 530048003091 1560 Thompson Preschool   Regular School No Elementary PK PK 2017   pk_12_total 332 35 106   0 11     16   80   346 235 0   0   8   384       0.0 581 332 35 106   0 11     16   80   346 235 0   0 8 384     0 581
618216 WA Pierce   school 5300480 27403   Bethel School District 530048003091 1560 Thompson Preschool   Regular School No Elementary PK PK 2017   kindergarten_half_day 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
618217 WA Pierce   school 5300480 27403   Bethel School District 530048003091 1560 Thompson Preschool   Regular School No Elementary PK PK 2017   pre_kindergarten 331 35 106   0 11     16   80   346 234 0   0   8   384       0.0 580 331 35 106   0 11     16   80   346 234 0   0 8 384     0 580
629749 WA Spokane   school 5308250 32081   Spokane School District 530825002362 1566 Alternative Northeast Community Center Preschool   Regular School No Elementary PK PK 2017   pk_12_total 10 0 1   0 0     0   0   7 4 0   0   1   5       0.0 11 10 0 1   0 0     0   0   7 4 0   0 1 5     0 11
629750 WA Spokane   school 5308250 32081   Spokane School District 530825002362 1566 Alternative Northeast Community Center Preschool   Regular School No Elementary PK PK 2017   pre_kindergarten 10 0 1   0 0     0   0   7 4 0   0   1   5       0.0 11 10 0 1   0 0     0   0   7 4 0   0 1 5     0 11
630027 WA Spokane   school 5308250 32081   Spokane School District 530825002364 1567 Pratt Academy   Alternative School No Other 03 12 2017   grade_10 8 1 3   1 0     1   4   14 4 0   1   1   16       6.0 18 8 1 3   1 0     1   4   14 4 0   1 1 16     6 18
630028 WA Spokane   school 5308250 32081   Spokane School District 530825002364 1567 Pratt Academy   Alternative School No Other 03 12 2017   grade_11 8 0 2   0 0     0   2   10 2 0   1   0   9       0.0 12 8 0 2   0 0     0   2   10 2 0   1 0 9     0 12
630029 WA Spokane   school 5308250 32081   Spokane School District 530825002364 1567 Pratt Academy   Alternative School No Other 03 12 2017   grade_12 6 1 2   2 0     0   2   9 4 0   0   1   11       3.0 13 6 1 2   2 0     0   2   9 4 0   0 1 11     3 13
630030 WA Spokane   school 5308250 32081   Spokane School District 530825002364 1567 Pratt Academy   Alternative School No Other 03 12 2017   grade_5 1 0 0   1 0     0   0   2 0 0   0   1   2       2.0 2 1 0 0   1 0     0   0   2 0 0   0 1 2     2 2
630031 WA Spokane   school 5308250 32081   Spokane School District 530825002364 1567 Pratt Academy   Alternative School No Other 03 12 2017   grade_6 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
630032 WA Spokane   school 5308250 32081   Spokane School District 530825002364 1567 Pratt Academy   Alternative School No Other 03 12 2017   grade_7 3 0 0   0 0     0   3   6 0 0   0   0   6       2.0 6 3 0 0   0 0     0   3   6 0 0   0 0 6     2 6
630033 WA Spokane   school 5308250 32081   Spokane School District 530825002364 1567 Pratt Academy   Alternative School No Other 03 12 2017   grade_8 8 1 3   0 0     0   11   18 5 0   0   2   21       8.0 23 8 1 3   0 0     0   11   18 5 0   0 2 21     8 23
630034 WA Spokane   school 5308250 32081   Spokane School District 530825002364 1567 Pratt Academy   Alternative School No Other 03 12 2017   grade_9 2 0 0   0 0     0   2   4 0 0   0   0   4       1.0 4 2 0 0   0 0     0   2   4 0 0   0 0 4     1 4
630035 WA Spokane   school 5308250 32081   Spokane School District 530825002364 1567 Pratt Academy   Alternative School No Other 03 12 2017   pk_12_total 37 3 10   4 0     1   25   65 15 0   2   5   71       22.0 80 37 3 10   4 0     1   25   65 15 0   2 5 71     22 80
624587 WA Snohomish   school 5305130 31103   Monroe School District 530513002757 1570 Monroe Special Ed Preschool   Special Education School No Elementary PK PK 2017   pk_12_total 33 2 15   0 3     0   3   42 14 0   0   0   9       0.0 56 33 2 15   0 3     0   3   42 14 0   0 0 9     0 56
624588 WA Snohomish   school 5305130 31103   Monroe School District 530513002757 1570 Monroe Special Ed Preschool   Special Education School No Elementary PK PK 2017   pre_kindergarten 33 2 15   0 3     0   3   42 14 0   0   0   9       0.0 56 33 2 15   0 3     0   3   42 14 0   0 0 9     0 56
631482 WA Clark   school 5309270 6037   Vancouver School District 530927002408 1574 Fir Grove Childrens Center   Special Education School No Other KG 12 2017   grade_10 3 0 1   0 0     0   0   4 0 0   0   0   3       0.0 4 3 0 1   0 0     0   0   4 0 0   0 0 3     0 4
631483 WA Clark   school 5309270 6037   Vancouver School District 530927002408 1574 Fir Grove Childrens Center   Special Education School No Other KG 12 2017   grade_11 5 0 1   0 0     0   0   4 2 0   1   0   5       0.0 6 5 0 1   0 0     0   0   4 2 0   1 0 5     0 6
631484 WA Clark   school 5309270 6037   Vancouver School District 530927002408 1574 Fir Grove Childrens Center   Special Education School No Other KG 12 2017   grade_12 3 0 0   0 0     0   1   4 0 0   0   0   1       0.0 4 3 0 0   0 0     0   1   4 0 0   0 0 1     0 4
631485 WA Clark   school 5309270 6037   Vancouver School District 530927002408 1574 Fir Grove Childrens Center   Special Education School No Other KG 12 2017   grade_2 3 0 0   0 0     0   0   2 1 0   0   0   3       0.0 3 3 0 0   0 0     0   0   2 1 0   0 0 3     0 3
631486 WA Clark   school 5309270 6037   Vancouver School District 530927002408 1574 Fir Grove Childrens Center   Special Education School No Other KG 12 2017   grade_3 3 0 2   0 0     0   0   5 0 0   0   0   3       0.0 5 3 0 2   0 0     0   0   5 0 0   0 0 3     0 5
631487 WA Clark   school 5309270 6037   Vancouver School District 530927002408 1574 Fir Grove Childrens Center   Special Education School No Other KG 12 2017   grade_4 5 1 0   1 0     0   0   6 1 0   0   0   5       0.0 7 5 1 0   1 0     0   0   6 1 0   0 0 5     0 7
631488 WA Clark   school 5309270 6037   Vancouver School District 530927002408 1574 Fir Grove Childrens Center   Special Education School No Other KG 12 2017   grade_5 4 0 1   0 0     0   0   3 2 0   0   0   5       0.0 5 4 0 1   0 0     0   0   3 2 0   0 0 5     0 5
631489 WA Clark   school 5309270 6037   Vancouver School District 530927002408 1574 Fir Grove Childrens Center   Special Education School No Other KG 12 2017   grade_6 0 0 4   1 0     0   1   6 0 0   0   0   3       0.0 6 0 0 4   1 0     0   1   6 0 0   0 0 3     0 6
631490 WA Clark   school 5309270 6037   Vancouver School District 530927002408 1574 Fir Grove Childrens Center   Special Education School No Other KG 12 2017   grade_7 2 0 2   0 0     0   0   3 1 0   0   0   2       0.0 4 2 0 2   0 0     0   0   3 1 0   0 0 2     0 4
631491 WA Clark   school 5309270 6037   Vancouver School District 530927002408 1574 Fir Grove Childrens Center   Special Education School No Other KG 12 2017   grade_8 6 1 1   0 0     0   1   9 0 0   0   0   8       0.0 9 6 1 1   0 0     0   1   9 0 0   0 0 8     0 9
631492 WA Clark   school 5309270 6037   Vancouver School District 530927002408 1574 Fir Grove Childrens Center   Special Education School No Other KG 12 2017   grade_9 2 0 0   1 0     0   0   3 0 0   0   0   2       0.0 3 2 0 0   1 0     0   0   3 0 0   0 0 2     0 3
631493 WA Clark   school 5309270 6037   Vancouver School District 530927002408 1574 Fir Grove Childrens Center   Special Education School No Other KG 12 2017   pk_12_total 36 2 12   3 0     0   3   49 7 0   1   0   40       0.0 56 36 2 12   3 0     0   3   49 7 0   1 0 40     0 56
628814 WA King   school 5307710 17001   Seattle School District No. 1 530771001307 1579 Tops K-8 School   Alternative School No Elementary PK 08 2017   grade_1 16 4 4   0 10     0   13   21 26 0   8   1   12       0.0 47 16 4 4   0 10     0   13   21 26 0   8 1 12     0 47
628815 WA King   school 5307710 17001   Seattle School District No. 1 530771001307 1579 Tops K-8 School   Alternative School No Elementary PK 08 2017   grade_2 28 3 2   0 5     0   9   24 23 0   1   1   6       2.0 47 28 3 2   0 5     0   9   24 23 0   1 1 6     2 47
628816 WA King   school 5307710 17001   Seattle School District No. 1 530771001307 1579 Tops K-8 School   Alternative School No Elementary PK 08 2017   grade_3 29 2 2   0 10     0   6   17 32 0   4   1   14       3.0 49 29 2 2   0 10     0   6   17 32 0   4 1 14     3 49
628817 WA King   school 5307710 17001   Seattle School District No. 1 530771001307 1579 Tops K-8 School   Alternative School No Elementary PK 08 2017   grade_4 23 10 3   0 15     0   5   31 25 0   3   0   20       3.0 56 23 10 3   0 15     0   5   31 25 0   3 0 20     3 56
628818 WA King   school 5307710 17001   Seattle School District No. 1 530771001307 1579 Tops K-8 School   Alternative School No Elementary PK 08 2017   grade_5 26 8 3   1 11     0   7   30 26 0   2   2   14       2.0 56 26 8 3   1 11     0   7   30 26 0   2 2 14     2 56
628819 WA King   school 5307710 17001   Seattle School District No. 1 530771001307 1579 Tops K-8 School   Alternative School No Elementary PK 08 2017   grade_6 30 11 2   0 12     0   3   25 33 0   1   1   21       4.0 58 30 11 2   0 12     0   3   25 33 0   1 1 21     4 58
628820 WA King   school 5307710 17001   Seattle School District No. 1 530771001307 1579 Tops K-8 School   Alternative School No Elementary PK 08 2017   grade_7 29 8 2   1 10     0   3   26 27 0   2   1   14       5.0 53 29 8 2   1 10     0   3   26 27 0   2 1 14     5 53
628821 WA King   school 5307710 17001   Seattle School District No. 1 530771001307 1579 Tops K-8 School   Alternative School No Elementary PK 08 2017   grade_8 31 8 3   0 13     0   5   23 37 0   5   1   18       8.0 60 31 8 3   0 13     0   5   23 37 0   5 1 18     8 60
628822 WA King   school 5307710 17001   Seattle School District No. 1 530771001307 1579 Tops K-8 School   Alternative School No Elementary PK 08 2017   pk_12_total 232 56 23   2 95     0   63   217 254 0   34   8   125       28.0 471 232 56 23   2 95     0   63   217 254 0   34 8 125     28 471
628823 WA King   school 5307710 17001   Seattle School District No. 1 530771001307 1579 Tops K-8 School   Alternative School No Elementary PK 08 2017   kindergarten 20 2 2   0 9     0   12   20 25 0   8   0   6       1.0 45 20 2 2   0 9     0   12   20 25 0   8 0 6     1 45
630624 WA Pierce   school 5308700 27010   Tacoma School District 530870002413 1585 Comm Based Trans Program   Special Education School No High 11 12 2017   grade_12 32 11 5   1 7     1   4   35 26 0   0   1   45       0.0 61 32 11 5   1 7     1   4   35 26 0   0 1 45     0 61
630625 WA Pierce   school 5308700 27010   Tacoma School District 530870002413 1585 Comm Based Trans Program   Special Education School No High 11 12 2017   pk_12_total 32 11 5   1 7     1   4   35 26 0   0   1   45       0.0 61 32 11 5   1 7     1   4   35 26 0   0 1 45     0 61
619600 WA Stevens   school 5301630 33115   Colville School District 530163003305 1594 Panorama School   Alternative School No Other PK 12 2017   grade_10 9 0 0   1 0     0   1   2 9 0   0   1   9       0.0 11 9 0 0   1 0     0   1   2 9 0   0 1 9     0 11
619601 WA Stevens   school 5301630 33115   Colville School District 530163003305 1594 Panorama School   Alternative School No Other PK 12 2017   grade_11 12 0 0   0 0     0   0   5 7 0   0   1   10       0.0 12 12 0 0   0 0     0   0   5 7 0   0 1 10     0 12
619602 WA Stevens   school 5301630 33115   Colville School District 530163003305 1594 Panorama School   Alternative School No Other PK 12 2017   grade_12 12 0 1   0 0     0   0   7 6 0   0   0   4       1.0 13 12 0 1   0 0     0   0   7 6 0   0 0 4     1 13
619603 WA Stevens   school 5301630 33115   Colville School District 530163003305 1594 Panorama School   Alternative School No Other PK 12 2017   grade_1 1 0 0   0 0     0   0   0 1 0   0   0   0       0.0 1 1 0 0   0 0     0   0   0 1 0   0 0 0     0 1
619604 WA Stevens   school 5301630 33115   Colville School District 530163003305 1594 Panorama School   Alternative School No Other PK 12 2017   grade_2 3 0 0   0 0     0   0   1 2 0   0   0   2       0.0 3 3 0 0   0 0     0   0   1 2 0   0 0 2     0 3
619605 WA Stevens   school 5301630 33115   Colville School District 530163003305 1594 Panorama School   Alternative School No Other PK 12 2017   grade_3 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
619606 WA Stevens   school 5301630 33115   Colville School District 530163003305 1594 Panorama School   Alternative School No Other PK 12 2017   grade_4 2 0 1   0 0     0   0   1 2 0   0   0   1       0.0 3 2 0 1   0 0     0   0   1 2 0   0 0 1     0 3
619607 WA Stevens   school 5301630 33115   Colville School District 530163003305 1594 Panorama School   Alternative School No Other PK 12 2017   grade_5 3 0 0   0 0     0   0   1 2 0   0   0   3       0.0 3 3 0 0   0 0     0   0   1 2 0   0 0 3     0 3
619608 WA Stevens   school 5301630 33115   Colville School District 530163003305 1594 Panorama School   Alternative School No Other PK 12 2017   grade_6 2 0 0   0 0     0   0   2 0 0   0   0   1       0.0 2 2 0 0   0 0     0   0   2 0 0   0 0 1     0 2
619609 WA Stevens   school 5301630 33115   Colville School District 530163003305 1594 Panorama School   Alternative School No Other PK 12 2017   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
619610 WA Stevens   school 5301630 33115   Colville School District 530163003305 1594 Panorama School   Alternative School No Other PK 12 2017   grade_8 4 0 0   0 0     0   0   1 3 0   0   0   3       0.0 4 4 0 0   0 0     0   0   1 3 0   0 0 3     0 4
619611 WA Stevens   school 5301630 33115   Colville School District 530163003305 1594 Panorama School   Alternative School No Other PK 12 2017   grade_9 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
619612 WA Stevens   school 5301630 33115   Colville School District 530163003305 1594 Panorama School   Alternative School No Other PK 12 2017   pk_12_total 96 0 5   1 0     0   1   51 52 0   0   3   66       1.0 103 96 0 5   1 0     0   1   51 52 0   0 3 66     1 103
619613 WA Stevens   school 5301630 33115   Colville School District 530163003305 1594 Panorama School   Alternative School No Other PK 12 2017   kindergarten_half_day 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
619614 WA Stevens   school 5301630 33115   Colville School District 530163003305 1594 Panorama School   Alternative School No Other PK 12 2017   kindergarten 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
619615 WA Stevens   school 5301630 33115   Colville School District 530163003305 1594 Panorama School   Alternative School No Other PK 12 2017   pre_kindergarten 43 0 3   0 0     0   0   30 16 0   0   1   33       0.0 46 43 0 3   0 0     0   0   30 16 0   0 1 33     0 46
628767 WA King   school 5307710 17001   Seattle School District No. 1 530771001311 1596 Seattle World School   Alternative School No Other 06 12 2017   grade_10 3 19 20   0 19     0   0   38 23 0   58   17   58       1.0 61 3 19 20   0 19     0   0   38 23 0   58 17 58     1 61
628768 WA King   school 5307710 17001   Seattle School District No. 1 530771001311 1596 Seattle World School   Alternative School No Other 06 12 2017   grade_11 2 9 24   0 24     0   1   41 19 0   59   18   59       1.0 60 2 9 24   0 24     0   1   41 19 0   59 18 59     1 60
628769 WA King   school 5307710 17001   Seattle School District No. 1 530771001311 1596 Seattle World School   Alternative School No Other 06 12 2017   grade_12 1 25 25   0 20     0   1   36 36 0   62   32   70       0.0 72 1 25 25   0 20     0   1   36 36 0   62 32 70     0 72
628770 WA King   school 5307710 17001   Seattle School District No. 1 530771001311 1596 Seattle World School   Alternative School No Other 06 12 2017   grade_6 1 4 6   0 6     0   1   8 10 0   17   4   16       0.0 18 1 4 6   0 6     0   1   8 10 0   17 4 16     0 18
628771 WA King   school 5307710 17001   Seattle School District No. 1 530771001311 1596 Seattle World School   Alternative School No Other 06 12 2017   grade_7 0 6 2   0 6     0   0   9 5 0   6   4   14       0.0 14 0 6 2   0 6     0   0   9 5 0   6 4 14     0 14
628772 WA King   school 5307710 17001   Seattle School District No. 1 530771001311 1596 Seattle World School   Alternative School No Other 06 12 2017   grade_8 2 4 5   0 4     0   0   9 6 0   12   3   15       0.0 15 2 4 5   0 4     0   0   9 6 0   12 3 15     0 15
628773 WA King   school 5307710 17001   Seattle School District No. 1 530771001311 1596 Seattle World School   Alternative School No Other 06 12 2017   grade_9 0 7 22   0 11     0   0   21 19 0   37   10   39       0.0 40 0 7 22   0 11     0   0   21 19 0   37 10 39     0 40
628774 WA King   school 5307710 17001   Seattle School District No. 1 530771001311 1596 Seattle World School   Alternative School No Other 06 12 2017   pk_12_total 9 74 104   0 90     0   3   162 118 0   251   88   271       2.0 280 9 74 104   0 90     0   3   162 118 0   251 88 271     2 280
629830 WA Spokane   school 5308250 32081   Spokane School District 530825002162 1603 Daybreak Alternative School   Alternative School No High 08 12 2017   grade_10 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
629831 WA Spokane   school 5308250 32081   Spokane School District 530825002162 1603 Daybreak Alternative School   Alternative School No High 08 12 2017   grade_11 0 0 1   0 0     0   1   0 2 0   0   0   1       0.0 2 0 0 1   0 0     0   1   0 2 0   0 0 1     0 2
629832 WA Spokane   school 5308250 32081   Spokane School District 530825002162 1603 Daybreak Alternative School   Alternative School No High 08 12 2017   grade_9 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
629833 WA Spokane   school 5308250 32081   Spokane School District 530825002162 1603 Daybreak Alternative School   Alternative School No High 08 12 2017   pk_12_total 2 0 1   0 0     0   1   0 4 0   0   0   3       0.0 4 2 0 1   0 0     0   1   0 4 0   0 0 3     0 4
629751 WA Spokane   school 5308250 32081   Spokane School District 530825000074 1604 Alternative Tamarack School   Regular School No High 07 12 2017   grade_10 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
629752 WA Spokane   school 5308250 32081   Spokane School District 530825000074 1604 Alternative Tamarack School   Regular School No High 07 12 2017   grade_11 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
629753 WA Spokane   school 5308250 32081   Spokane School District 530825000074 1604 Alternative Tamarack School   Regular School No High 07 12 2017   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
629754 WA Spokane   school 5308250 32081   Spokane School District 530825000074 1604 Alternative Tamarack School   Regular School No High 07 12 2017   grade_9 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
629755 WA Spokane   school 5308250 32081   Spokane School District 530825000074 1604 Alternative Tamarack School   Regular School No High 07 12 2017   pk_12_total 3 0 0   0 0     0   1   1 3 0   0   0   0       0.0 4 3 0 0   0 0     0   1   1 3 0   0 0 0     0 4
619634 WA Skagit   school 5301660 29011   Concrete School District 530166000084 1605 Twin Cedars High School   Alternative School No High 07 12 2017   grade_10 2 0 0   0 0     0   0   0 2 0   0   0   2       0.0 2 2 0 0   0 0     0   0   0 2 0   0 0 2     0 2
619635 WA Skagit   school 5301660 29011   Concrete School District 530166000084 1605 Twin Cedars High School   Alternative School No High 07 12 2017   grade_11 3 0 0   0 0     0   0   2 1 0   0   0   2       0.0 3 3 0 0   0 0     0   0   2 1 0   0 0 2     0 3
619636 WA Skagit   school 5301660 29011   Concrete School District 530166000084 1605 Twin Cedars High School   Alternative School No High 07 12 2017   grade_12 3 0 0   0 0     0   0   1 2 0   0   0   3       0.0 3 3 0 0   0 0     0   0   1 2 0   0 0 3     0 3
619637 WA Skagit   school 5301660 29011   Concrete School District 530166000084 1605 Twin Cedars High School   Alternative School No High 07 12 2017   grade_8 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
619638 WA Skagit   school 5301660 29011   Concrete School District 530166000084 1605 Twin Cedars High School   Alternative School No High 07 12 2017   grade_9 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
619639 WA Skagit   school 5301660 29011   Concrete School District 530166000084 1605 Twin Cedars High School   Alternative School No High 07 12 2017   pk_12_total 10 0 0   0 0     0   0   4 6 0   0   0   9       0.0 10 10 0 0   0 0     0   0   4 6 0   0 0 9     0 10
632124 WA Chelan   school 5309660 4246   Wenatchee School District 530966000097 1612 Skill Source   Alternative School No High 09 12 2017   grade_10 1 0 1   0 0     0   0   1 1 0   0   1   1       0.0 2 1 0 1   0 0     0   0   1 1 0   0 1 1     0 2
632125 WA Chelan   school 5309660 4246   Wenatchee School District 530966000097 1612 Skill Source   Alternative School No High 09 12 2017   pk_12_total 1 0 1   0 0     0   0   1 1 0   0   1   1       0.0 2 1 0 1   0 0     0   0   1 1 0   0 1 1     0 2
632167 WA Chelan   school 5309660 4246   Wenatchee School District 530966002193 1613 Westside High School   Alternative School No High 09 12 2017   grade_10 19 0 22   1 0     0   1   22 21 0   4   2   27       1.0 43 19 0 22   1 0     0   1   22 21 0   4 2 27     1 43
632168 WA Chelan   school 5309660 4246   Wenatchee School District 530966002193 1613 Westside High School   Alternative School No High 09 12 2017   grade_11 29 1 23   2 0     0   2   24 33 0   6   5   30       5.0 57 29 1 23   2 0     0   2   24 33 0   6 5 30     5 57
632169 WA Chelan   school 5309660 4246   Wenatchee School District 530966002193 1613 Westside High School   Alternative School No High 09 12 2017   grade_12 76 1 73   0 0     1   3   85 69 0   9   9   79       8.0 154 76 1 73   0 0     1   3   85 69 0   9 9 79     8 154
632170 WA Chelan   school 5309660 4246   Wenatchee School District 530966002193 1613 Westside High School   Alternative School No High 09 12 2017   grade_9 10 0 5   0 0     0   1   8 8 0   1   1   9       4.0 16 10 0 5   0 0     0   1   8 8 0   1 1 9     4 16
632171 WA Chelan   school 5309660 4246   Wenatchee School District 530966002193 1613 Westside High School   Alternative School No High 09 12 2017   pk_12_total 134 2 123   3 0     1   7   139 131 0   20   17   145       18.0 270 134 2 123   3 0     1   7   139 131 0   20 17 145     18 270
619199 WA Asotin   school 5301320 2250   Clarkston School District 530132000990 1617 Educational Opportunity Center   Alternative School No High 07 12 2017   grade_10 3 0 0   0 0     0   0   1 2 0   0   0   2       0.0 3 3 0 0   0 0     0   0   1 2 0   0 0 2     0 3
619200 WA Asotin   school 5301320 2250   Clarkston School District 530132000990 1617 Educational Opportunity Center   Alternative School No High 07 12 2017   grade_11 11 1 1   0 0     0   0   7 6 0   0   1   9       0.0 13 11 1 1   0 0     0   0   7 6 0   0 1 9     0 13
619201 WA Asotin   school 5301320 2250   Clarkston School District 530132000990 1617 Educational Opportunity Center   Alternative School No High 07 12 2017   grade_12 52 0 4   1 0     0   5   29 33 0   0   3   29       0.0 62 52 0 4   1 0     0   5   29 33 0   0 3 29     0 62
619202 WA Asotin   school 5301320 2250   Clarkston School District 530132000990 1617 Educational Opportunity Center   Alternative School No High 07 12 2017   grade_9 1 0 0   0 0     0   0   0 1 0   0   0   1       1.0 1 1 0 0   0 0     0   0   0 1 0   0 0 1     1 1
619203 WA Asotin   school 5301320 2250   Clarkston School District 530132000990 1617 Educational Opportunity Center   Alternative School No High 07 12 2017   pk_12_total 67 1 5   1 0     0   5   37 42 0   0   4   41       1.0 79 67 1 5   1 0     0   5   37 42 0   0 4 41     1 79
628660 WA King   school 5307710 17001   Seattle School District No. 1 530771001102 1620 Pathfinder K-8 School   Alternative School No Elementary KG 08 2017   grade_1 42 0 1   0 0     0   10   24 29 0   0   0   7       0.0 53 42 0 1   0 0     0   10   24 29 0   0 0 7     0 53
628661 WA King   school 5307710 17001   Seattle School District No. 1 530771001102 1620 Pathfinder K-8 School   Alternative School No Elementary KG 08 2017   grade_2 34 1 5   0 2     0   12   26 28 0   0   1   5       1.0 54 34 1 5   0 2     0   12   26 28 0   0 1 5     1 54

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