Data source: Big Local News · About: Big Local

15,740 rows where state = "WA" and year = 2021 sorted by district_nces_id

View and edit SQL

grade

year

  • 2021 · 15,640
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
2936595 WA Cowlitz   school 5300003 8458   Kelso School District 530000300167 2913 Carrolls Elementary   Regular School No Elementary KG 05 2021   grade_5 10 0 0   0 0     0   2   3 9 0   0   0   6       0.0 12 10 0 0   0 0     0   2   3 9 0   0 0 6     0 12
2936596 WA Cowlitz   school 5300003 8458   Kelso School District 530000300167 2913 Carrolls Elementary   Regular School No Elementary KG 05 2021   pk_12_total 54 0 4   0 1     0   5   36 28 0   0   0   24       4.0 64 54 0 4   0 1     0   5   36 28 0   0 0 24     4 64
2936597 WA Cowlitz   school 5300003 8458   Kelso School District 530000300167 2913 Carrolls Elementary   Regular School No Elementary KG 05 2021   kindergarten 11 0 0   0 0     0   0   6 5 0   0   0   3       0.0 11 11 0 0   0 0     0   0   6 5 0   0 0 3     0 11
2936598 WA Cowlitz   school 5300003 8458   Kelso School District 530000300590 2691 Catlin Elementary   Regular School No Elementary KG 05 2021   grade_1 32 0 8   0 0     0   0   19 21 0   1   3   30       0.0 40 32 0 8   0 0     0   0   19 21 0   1 3 30     0 40
2936599 WA Cowlitz   school 5300003 8458   Kelso School District 530000300590 2691 Catlin Elementary   Regular School No Elementary KG 05 2021   grade_2 18 0 7   0 0     4   4   17 16 0   7   0   25       2.0 33 18 0 7   0 0     4   4   17 16 0   7 0 25     2 33
2936600 WA Cowlitz   school 5300003 8458   Kelso School District 530000300590 2691 Catlin Elementary   Regular School No Elementary KG 05 2021   grade_3 23 0 9   0 0     1   5   20 18 0   3   3   30       0.0 38 23 0 9   0 0     1   5   20 18 0   3 3 30     0 38
2936601 WA Cowlitz   school 5300003 8458   Kelso School District 530000300590 2691 Catlin Elementary   Regular School No Elementary KG 05 2021   grade_4 31 0 12   3 0     1   3   29 21 0   3   3   40       1.0 50 31 0 12   3 0     1   3   29 21 0   3 3 40     1 50
2936602 WA Cowlitz   school 5300003 8458   Kelso School District 530000300590 2691 Catlin Elementary   Regular School No Elementary KG 05 2021   grade_5 33 0 8   0 0     4   2   26 21 0   6   3   38       1.0 47 33 0 8   0 0     4   2   26 21 0   6 3 38     1 47
2936603 WA Cowlitz   school 5300003 8458   Kelso School District 530000300590 2691 Catlin Elementary   Regular School No Elementary KG 05 2021   pk_12_total 159 0 48   3 0     11   15   129 107 0   22   13   184       4.0 236 159 0 48   3 0     11   15   129 107 0   22 13 184     4 236
2936604 WA Cowlitz   school 5300003 8458   Kelso School District 530000300590 2691 Catlin Elementary   Regular School No Elementary KG 05 2021   kindergarten 22 0 4   0 0     1   1   18 10 0   2   1   21       0.0 28 22 0 4   0 0     1   1   18 10 0   2 1 21     0 28
2936605 WA Cowlitz   school 5300003 8458   Kelso School District 530000300591 3322 Coweeman Middle School   Regular School No Middle 06 08 2021   grade_6 103 1 26   2 0     4   10   72 74 0   11   1   83       7.0 146 103 1 26   2 0     4   10   72 74 0   11 1 83     7 146
2936606 WA Cowlitz   school 5300003 8458   Kelso School District 530000300591 3322 Coweeman Middle School   Regular School No Middle 06 08 2021   grade_7 104 0 31   1 2     3   9   71 79 0   14   3   89       5.0 150 104 0 31   1 2     3   9   71 79 0   14 3 89     5 150
2936607 WA Cowlitz   school 5300003 8458   Kelso School District 530000300591 3322 Coweeman Middle School   Regular School No Middle 06 08 2021   grade_8 110 0 25   2 1     0   8   80 66 0   4   1   92       7.0 146 110 0 25   2 1     0   8   80 66 0   4 1 92     7 146
2936608 WA Cowlitz   school 5300003 8458   Kelso School District 530000300591 3322 Coweeman Middle School   Regular School No Middle 06 08 2021   pk_12_total 317 1 82   5 3     7   27   223 219 0   29   5   264       19.0 442 317 1 82   5 3     7   27   223 219 0   29 5 264     19 442
2936609 WA Cowlitz   school 5300003 8458   Kelso School District 530000300592 2916 Huntington Middle School   Regular School No Middle 06 08 2021   grade_6 112 1 26   0 1     3   12   78 77 0   10   9   97       7.0 155 112 1 26   0 1     3   12   78 77 0   10 9 97     7 155
2936610 WA Cowlitz   school 5300003 8458   Kelso School District 530000300592 2916 Huntington Middle School   Regular School No Middle 06 08 2021   grade_7 108 0 30   2 3     2   12   82 75 0   10   3   103       7.0 157 108 0 30   2 3     2   12   82 75 0   10 3 103     7 157
2936611 WA Cowlitz   school 5300003 8458   Kelso School District 530000300592 2916 Huntington Middle School   Regular School No Middle 06 08 2021   grade_8 88 0 30   2 0     3   9   76 56 0   10   8   82       5.0 132 88 0 30   2 0     3   9   76 56 0   10 8 82     5 132
2936612 WA Cowlitz   school 5300003 8458   Kelso School District 530000300592 2916 Huntington Middle School   Regular School No Middle 06 08 2021   pk_12_total 308 1 86   4 4     8   33   236 208 0   30   20   282       19.0 444 308 1 86   4 4     8   33   236 208 0   30 20 282     19 444
2936613 WA Cowlitz   school 5300003 8458   Kelso School District 530000303667 5547 Kelso Goal Oriented Learning Design   Alternative School No High 09 12 2021   grade_10 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
2936614 WA Cowlitz   school 5300003 8458   Kelso School District 530000303667 5547 Kelso Goal Oriented Learning Design   Alternative School No High 09 12 2021   grade_11 2 0 0   0 0     0   0   2 0 0   0   0   1       1.0 2 2 0 0   0 0     0   0   2 0 0   0 0 1     1 2
2936615 WA Cowlitz   school 5300003 8458   Kelso School District 530000303667 5547 Kelso Goal Oriented Learning Design   Alternative School No High 09 12 2021   grade_12 2 0 2   0 0     0   3   6 1 0   0   0   6       0.0 7 2 0 2   0 0     0   3   6 1 0   0 0 6     0 7
2936616 WA Cowlitz   school 5300003 8458   Kelso School District 530000303667 5547 Kelso Goal Oriented Learning Design   Alternative School No High 09 12 2021   pk_12_total 5 0 2   0 0     0   3   9 1 0   0   0   8       1.0 10 5 0 2   0 0     0   3   9 1 0   0 0 8     1 10
2936617 WA Cowlitz   school 5300003 8458   Kelso School District 530000300593 2266 Kelso High School   Regular School No High 09 12 2021   grade_10 216 2 82   2 5     7   25   184 155 0   26   11   198       15.0 339 216 2 82   2 5     7   25   184 155 0   26 11 198     15 339
2936618 WA Cowlitz   school 5300003 8458   Kelso School District 530000300593 2266 Kelso High School   Regular School No High 09 12 2021   grade_11 222 0 72   4 3     1   15   161 155 1   16   11   177       16.0 317 222 0 72   4 3     1   15   161 155 1   16 11 177     16 317
2936619 WA Cowlitz   school 5300003 8458   Kelso School District 530000300593 2266 Kelso High School   Regular School No High 09 12 2021   grade_12 228 1 58   8 4     3   26   174 154 0   8   16   162       12.0 328 228 1 58   8 4     3   26   174 154 0   8 16 162     12 328
2936620 WA Cowlitz   school 5300003 8458   Kelso School District 530000300593 2266 Kelso High School   Regular School No High 09 12 2021   grade_9 196 1 74   5 3     3   22   156 148 0   12   5   188       13.0 304 196 1 74   5 3     3   22   156 148 0   12 5 188     13 304
2936621 WA Cowlitz   school 5300003 8458   Kelso School District 530000300593 2266 Kelso High School   Regular School No High 09 12 2021   pk_12_total 862 4 286   19 15     14   88   675 612 1   62   43   725       56.0 1288 862 4 286   19 15     14   88   675 612 1   62 43 725     56 1288
2936622 WA Cowlitz   school 5300003 8458   Kelso School District 530000303314 5194 Kelso Virtual Academy   Regular School No Other KG 12 2021   grade_10 53 0 6   1 0     0   4   35 29 0   1   1   14       1.0 64 53 0 6   1 0     0   4   35 29 0   1 1 14     1 64
2936623 WA Cowlitz   school 5300003 8458   Kelso School District 530000303314 5194 Kelso Virtual Academy   Regular School No Other KG 12 2021   grade_11 41 1 4   1 0     0   4   26 25 0   0   0   15       0.0 51 41 1 4   1 0     0   4   26 25 0   0 0 15     0 51
2936624 WA Cowlitz   school 5300003 8458   Kelso School District 530000303314 5194 Kelso Virtual Academy   Regular School No Other KG 12 2021   grade_12 39 0 6   2 0     0   2   23 26 0   0   2   16       1.0 49 39 0 6   2 0     0   2   23 26 0   0 2 16     1 49
2936625 WA Cowlitz   school 5300003 8458   Kelso School District 530000303314 5194 Kelso Virtual Academy   Regular School No Other KG 12 2021   grade_1 45 0 12   1 0     0   10   33 35 0   5   2   26       0.0 68 45 0 12   1 0     0   10   33 35 0   5 2 26     0 68
2936626 WA Cowlitz   school 5300003 8458   Kelso School District 530000303314 5194 Kelso Virtual Academy   Regular School No Other KG 12 2021   grade_2 48 0 9   0 1     0   5   31 32 0   0   2   26       0.0 63 48 0 9   0 1     0   5   31 32 0   0 2 26     0 63
2936627 WA Cowlitz   school 5300003 8458   Kelso School District 530000303314 5194 Kelso Virtual Academy   Regular School No Other KG 12 2021   grade_3 53 1 10   0 1     1   2   35 33 0   1   0   27       1.0 68 53 1 10   0 1     1   2   35 33 0   1 0 27     1 68
2936628 WA Cowlitz   school 5300003 8458   Kelso School District 530000303314 5194 Kelso Virtual Academy   Regular School No Other KG 12 2021   grade_4 77 0 7   0 1     0   3   47 41 0   0   0   34       2.0 88 77 0 7   0 1     0   3   47 41 0   0 0 34     2 88
2936629 WA Cowlitz   school 5300003 8458   Kelso School District 530000303314 5194 Kelso Virtual Academy   Regular School No Other KG 12 2021   grade_5 52 1 8   1 0     1   2   27 38 0   1   1   30       2.0 65 52 1 8   1 0     1   2   27 38 0   1 1 30     2 65
2936630 WA Cowlitz   school 5300003 8458   Kelso School District 530000303314 5194 Kelso Virtual Academy   Regular School No Other KG 12 2021   grade_6 74 0 6   0 1     0   5   37 49 0   1   0   30       2.0 86 74 0 6   0 1     0   5   37 49 0   1 0 30     2 86
2936631 WA Cowlitz   school 5300003 8458   Kelso School District 530000303314 5194 Kelso Virtual Academy   Regular School No Other KG 12 2021   grade_7 46 0 7   0 0     0   4   23 34 0   0   0   14       2.0 57 46 0 7   0 0     0   4   23 34 0   0 0 14     2 57
2936632 WA Cowlitz   school 5300003 8458   Kelso School District 530000303314 5194 Kelso Virtual Academy   Regular School No Other KG 12 2021   grade_8 69 1 7   0 0     0   3   48 32 0   0   0   22       0.0 80 69 1 7   0 0     0   3   48 32 0   0 0 22     0 80
2936633 WA Cowlitz   school 5300003 8458   Kelso School District 530000303314 5194 Kelso Virtual Academy   Regular School No Other KG 12 2021   grade_9 52 2 4   1 0     0   1   27 33 0   0   1   24       3.0 60 52 2 4   1 0     0   1   27 33 0   0 1 24     3 60
2936634 WA Cowlitz   school 5300003 8458   Kelso School District 530000303314 5194 Kelso Virtual Academy   Regular School No Other KG 12 2021   pk_12_total 696 6 90   8 6     2   46   422 432 0   10   9   296       14.0 854 696 6 90   8 6     2   46   422 432 0   10 9 296     14 854
2936635 WA Cowlitz   school 5300003 8458   Kelso School District 530000303314 5194 Kelso Virtual Academy   Regular School No Other KG 12 2021   kindergarten 47 0 4   1 2     0   1   30 25 0   1   0   18       0.0 55 47 0 4   1 2     0   1   30 25 0   1 0 18     0 55
2936636 WA Cowlitz   school 5300003 8458   Kelso School District 530000303109 1934 Loowit High School   Alternative School No High 06 12 2021   grade_10 2 0 0   0 0     0   0   1 1 0   0   0   0       0.0 2 2 0 0   0 0     0   0   1 1 0   0 0 0     0 2
2936637 WA Cowlitz   school 5300003 8458   Kelso School District 530000303109 1934 Loowit High School   Alternative School No High 06 12 2021   grade_11 5 0 0   0 0     0   0   2 3 0   0   0   3       1.0 5 5 0 0   0 0     0   0   2 3 0   0 0 3     1 5
2936638 WA Cowlitz   school 5300003 8458   Kelso School District 530000303109 1934 Loowit High School   Alternative School No High 06 12 2021   grade_12 2 0 0   0 0     0   0   1 1 0   0   0   0       0.0 2 2 0 0   0 0     0   0   1 1 0   0 0 0     0 2
2936639 WA Cowlitz   school 5300003 8458   Kelso School District 530000303109 1934 Loowit High School   Alternative School No High 06 12 2021   pk_12_total 9 0 0   0 0     0   0   4 5 0   0   0   3       1.0 9 9 0 0   0 0     0   0   4 5 0   0 0 3     1 9
2936640 WA Cowlitz   school 5300003 8458   Kelso School District 530000300594 2596 Rose Valley Elementary   Regular School No Elementary KG 05 2021   grade_1 18 0 3   1 0     0   3   11 14 0   1   0   10       0.0 25 18 0 3   1 0     0   3   11 14 0   1 0 10     0 25
2936641 WA Cowlitz   school 5300003 8458   Kelso School District 530000300594 2596 Rose Valley Elementary   Regular School No Elementary KG 05 2021   grade_2 10 0 4   1 0     0   2   13 4 0   1   0   8       1.0 17 10 0 4   1 0     0   2   13 4 0   1 0 8     1 17
2936642 WA Cowlitz   school 5300003 8458   Kelso School District 530000300594 2596 Rose Valley Elementary   Regular School No Elementary KG 05 2021   grade_3 9 0 0   0 0     0   0   6 3 0   0   2   3       0.0 9 9 0 0   0 0     0   0   6 3 0   0 2 3     0 9
2936643 WA Cowlitz   school 5300003 8458   Kelso School District 530000300594 2596 Rose Valley Elementary   Regular School No Elementary KG 05 2021   grade_4 12 0 2   0 0     0   1   9 6 0   0   0   3       1.0 15 12 0 2   0 0     0   1   9 6 0   0 0 3     1 15
2936644 WA Cowlitz   school 5300003 8458   Kelso School District 530000300594 2596 Rose Valley Elementary   Regular School No Elementary KG 05 2021   grade_5 16 0 2   0 0     0   1   7 12 0   0   0   7       0.0 19 16 0 2   0 0     0   1   7 12 0   0 0 7     0 19
2936645 WA Cowlitz   school 5300003 8458   Kelso School District 530000300594 2596 Rose Valley Elementary   Regular School No Elementary KG 05 2021   pk_12_total 81 0 12   2 0     0   7   55 47 0   2   2   36       3.0 102 81 0 12   2 0     0   7   55 47 0   2 2 36     3 102
2936646 WA Cowlitz   school 5300003 8458   Kelso School District 530000300594 2596 Rose Valley Elementary   Regular School No Elementary KG 05 2021   kindergarten 16 0 1   0 0     0   0   9 8 0   0   0   5       1.0 17 16 0 1   0 0     0   0   9 8 0   0 0 5     1 17
2936647 WA Cowlitz   school 5300003 8458   Kelso School District 530000303076 5076 Special Education   Special Education School No Other PK 12 2021   pk_12_total 26 0 8   1 0     0   5   28 12 0   0   0   22       0.0 40 26 0 8   1 0     0   5   28 12 0   0 0 22     0 40
2936648 WA Cowlitz   school 5300003 8458   Kelso School District 530000303076 5076 Special Education   Special Education School No Other PK 12 2021   pre_kindergarten 26 0 8   1 0     0   5   28 12 0   0   0   22       0.0 40 26 0 8   1 0     0   5   28 12 0   0 0 22     0 40
2936649 WA Cowlitz   school 5300003 8458   Kelso School District 530000300596 2624 Wallace Elementary   Regular School No Elementary KG 05 2021   grade_1 30 0 11   2 2     3   4   22 30 0   11   2   45       0.0 52 30 0 11   2 2     3   4   22 30 0   11 2 45     0 52
2936650 WA Cowlitz   school 5300003 8458   Kelso School District 530000300596 2624 Wallace Elementary   Regular School No Elementary KG 05 2021   grade_2 33 0 12   0 0     6   3   36 18 0   12   2   49       1.0 54 33 0 12   0 0     6   3   36 18 0   12 2 49     1 54
2936651 WA Cowlitz   school 5300003 8458   Kelso School District 530000300596 2624 Wallace Elementary   Regular School No Elementary KG 05 2021   grade_3 21 0 16   0 1     3   1   25 17 0   12   0   37       0.0 42 21 0 16   0 1     3   1   25 17 0   12 0 37     0 42
2936652 WA Cowlitz   school 5300003 8458   Kelso School District 530000300596 2624 Wallace Elementary   Regular School No Elementary KG 05 2021   grade_4 26 1 11   1 1     3   4   31 16 0   9   2   41       0.0 47 26 1 11   1 1     3   4   31 16 0   9 2 41     0 47
2936653 WA Cowlitz   school 5300003 8458   Kelso School District 530000300596 2624 Wallace Elementary   Regular School No Elementary KG 05 2021   grade_5 27 1 14   1 1     2   3   24 25 0   12   2   44       0.0 49 27 1 14   1 1     2   3   24 25 0   12 2 44     0 49
2936654 WA Cowlitz   school 5300003 8458   Kelso School District 530000300596 2624 Wallace Elementary   Regular School No Elementary KG 05 2021   pk_12_total 174 2 73   4 5     19   19   167 129 0   66   10   257       1.0 296 174 2 73   4 5     19   19   167 129 0   66 10 257     1 296
2936655 WA Cowlitz   school 5300003 8458   Kelso School District 530000300596 2624 Wallace Elementary   Regular School No Elementary KG 05 2021   kindergarten 25 0 9   0 0     2   3   19 20 0   10   0   31       0.0 39 25 0 9   0 0     2   3   19 20 0   10 0 31     0 39
2936656 WA Cowlitz   school 5300003 8458   Kelso School District 530000300596 2624 Wallace Elementary   Regular School No Elementary KG 05 2021   pre_kindergarten 12 0 0   0 0     0   1   10 3 0   0   2   10       0.0 13 12 0 0   0 0     0   1   10 3 0   0 2 10     0 13
2934787 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 2021   grade_11 2 0 0   0 0     0   0   2 0 0   0   0   0       0.0 2 2 0 0   0 0     0   0   2 0 0   0 0 0     0 2
2934788 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 2021   grade_12 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
2934789 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 2021   grade_8 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
2934790 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 2021   pk_12_total 4 0 0   0 0     0   0   3 1 0   0   0   0       0.0 4 4 0 0   0 0     0   0   3 1 0   0 0 0     0 4
2934791 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 2021   grade_10 2 0 0   0 0     0   0   1 1 0   0   0   0       0.0 2 2 0 0   0 0     0   0   1 1 0   0 0 0     0 2
2934792 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 2021   grade_11 4 0 1   0 0     0   0   5 0 0   0   0   0       0.0 5 4 0 1   0 0     0   0   5 0 0   0 0 0     0 5
2934793 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 2021   grade_12 2 0 1   0 0     0   0   2 1 0   0   0   0       0.0 3 2 0 1   0 0     0   0   2 1 0   0 0 0     0 3
2934794 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 2021   pk_12_total 8 0 2   0 0     0   0   8 2 0   0   0   0       0.0 10 8 0 2   0 0     0   0   8 2 0   0 0 0     0 10
2934795 WA Clark   school 5300005 6801   ESD 112 acting as a school district 530000503538 5398 ESD 112 Open Doors Reengagement   Alternative School No High 09 12 2021   grade_11 8 0 0   0 0     0   0   6 2 0   0   0   0       0.0 8 8 0 0   0 0     0   0   6 2 0   0 0 0     0 8
2934796 WA Clark   school 5300005 6801   ESD 112 acting as a school district 530000503538 5398 ESD 112 Open Doors Reengagement   Alternative School No High 09 12 2021   grade_12 135 4 22   1 0     4   9   94 80 2   0   0   0       0.0 176 135 4 22   1 0     4   9   94 80 2   0 0 0     0 176
2934797 WA Clark   school 5300005 6801   ESD 112 acting as a school district 530000503538 5398 ESD 112 Open Doors Reengagement   Alternative School No High 09 12 2021   pk_12_total 143 4 22   1 0     4   9   100 82 2   0   0   0       0.0 184 143 4 22   1 0     4   9   100 82 2   0 0 0     0 184
2934802 WA Kitsap   school 5300007 18801   ESD 114 acting as a school district 530000702914 3143 Clallam Co Juvenile Detention   Regular School No High 07 12 2021   grade_11 2 0 0   0 0     0   0   1 1 0   0   0   2       0.0 2 2 0 0   0 0     0   0   1 1 0   0 0 2     0 2
2934803 WA Kitsap   school 5300007 18801   ESD 114 acting as a school district 530000702914 3143 Clallam Co Juvenile Detention   Regular School No High 07 12 2021   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
2934804 WA Kitsap   school 5300007 18801   ESD 114 acting as a school district 530000702914 3143 Clallam Co Juvenile Detention   Regular School No High 07 12 2021   pk_12_total 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
2934805 WA Kitsap   school 5300007 18801   ESD 114 acting as a school district 530000702927 3481 Kitsap Co Detention Ctr   Regular School No High 08 12 2021   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
2934806 WA Kitsap   school 5300007 18801   ESD 114 acting as a school district 530000702927 3481 Kitsap Co Detention Ctr   Regular School No High 08 12 2021   grade_11 2 0 0   0 0     0   0   1 1 0   0   0   2       0.0 2 2 0 0   0 0     0   0   1 1 0   0 0 2     0 2
2934807 WA Kitsap   school 5300007 18801   ESD 114 acting as a school district 530000702927 3481 Kitsap Co Detention Ctr   Regular School No High 08 12 2021   grade_12 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
2934808 WA Kitsap   school 5300007 18801   ESD 114 acting as a school district 530000702927 3481 Kitsap Co Detention Ctr   Regular School No High 08 12 2021   pk_12_total 3 1 0   0 0     0   0   2 2 0   0   0   4       0.0 4 3 1 0   0 0     0   0   2 2 0   0 0 4     0 4
2934812 WA Skagit   school 5300008 29801   ESD 189 acting as a school district 530000803609 5501 Open Doors - Youth Reengagement Program   Alternative School No High 09 12 2021   grade_12 5 0 0   0 0     0   0   3 2 0   0   0   0       0.0 5 5 0 0   0 0     0   0   3 2 0   0 0 0     0 5
2934813 WA Skagit   school 5300008 29801   ESD 189 acting as a school district 530000803609 5501 Open Doors - Youth Reengagement Program   Alternative School No High 09 12 2021   pk_12_total 5 0 0   0 0     0   0   3 2 0   0   0   0       0.0 5 5 0 0   0 0     0   0   3 2 0   0 0 0     0 5
2934814 WA Skagit   school 5300008 29801   ESD 189 acting as a school district 530000802921 3363 Skagit County Detention Center   Regular School No High 08 12 2021   grade_10 0 0 2   0 0     0   0   1 1 0   0   0   0       0.0 2 0 0 2   0 0     0   0   1 1 0   0 0 0     0 2
2934815 WA Skagit   school 5300008 29801   ESD 189 acting as a school district 530000802921 3363 Skagit County Detention Center   Regular School No High 08 12 2021   grade_11 0 0 3   0 0     0   0   3 0 0   0   0   0       0.0 3 0 0 3   0 0     0   0   3 0 0   0 0 0     0 3
2934816 WA Skagit   school 5300008 29801   ESD 189 acting as a school district 530000802921 3363 Skagit County Detention Center   Regular School No High 08 12 2021   grade_12 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
2934817 WA Skagit   school 5300008 29801   ESD 189 acting as a school district 530000802921 3363 Skagit County Detention Center   Regular School No High 08 12 2021   pk_12_total 1 0 6   0 0     0   0   6 1 0   0   0   0       0.0 7 1 0 6   0 0     0   0   6 1 0   0 0 0     0 7
2934818 WA Skagit   school 5300008 29801   ESD 189 acting as a school district 530000802095 2601 Snohomish Detention Center   Regular School No High 06 12 2021   grade_11 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
2934819 WA Skagit   school 5300008 29801   ESD 189 acting as a school district 530000802095 2601 Snohomish Detention Center   Regular School No High 06 12 2021   pk_12_total 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
2934820 WA Skagit   school 5300008 29801   ESD 189 acting as a school district 530000802923 3420 Whatcom Co Detention Center   Regular School No High 08 12 2021   grade_11 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
2934821 WA Skagit   school 5300008 29801   ESD 189 acting as a school district 530000802923 3420 Whatcom Co Detention Center   Regular School No High 08 12 2021   grade_8 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
2934822 WA Skagit   school 5300008 29801   ESD 189 acting as a school district 530000802923 3420 Whatcom Co Detention Center   Regular School No High 08 12 2021   grade_9 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
2934823 WA Skagit   school 5300008 29801   ESD 189 acting as a school district 530000802923 3420 Whatcom Co Detention Center   Regular School No High 08 12 2021   pk_12_total 3 0 0   0 0     0   0   2 1 0   0   0   0       0.0 3 3 0 0   0 0     0   0   2 1 0   0 0 0     0 3
2934765 WA Spokane   school 5300010 32801   ESD 101 acting as a school district 530001002919 3352 Martin Hall Detention Ctr   Regular School No High 08 12 2021   grade_10 2 0 3   0 0     0   0   4 1 0   0   0   4       0.0 5 2 0 3   0 0     0   0   4 1 0   0 0 4     0 5
2934766 WA Spokane   school 5300010 32801   ESD 101 acting as a school district 530001002919 3352 Martin Hall Detention Ctr   Regular School No High 08 12 2021   grade_11 2 0 0   1 0     0   0   3 0 0   0   0   1       0.0 3 2 0 0   1 0     0   0   3 0 0   0 0 1     0 3
2934767 WA Spokane   school 5300010 32801   ESD 101 acting as a school district 530001002919 3352 Martin Hall Detention Ctr   Regular School No High 08 12 2021   grade_12 0 0 2   1 0     0   0   0 3 0   0   0   1       0.0 3 0 0 2   1 0     0   0   0 3 0   0 0 1     0 3
2934768 WA Spokane   school 5300010 32801   ESD 101 acting as a school district 530001002919 3352 Martin Hall Detention Ctr   Regular School No High 08 12 2021   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
2934769 WA Spokane   school 5300010 32801   ESD 101 acting as a school district 530001002919 3352 Martin Hall Detention Ctr   Regular School No High 08 12 2021   grade_9 1 0 2   0 0     0   0   1 2 0   0   0   3       0.0 3 1 0 2   0 0     0   0   1 2 0   0 0 3     0 3
2934770 WA Spokane   school 5300010 32801   ESD 101 acting as a school district 530001002919 3352 Martin Hall Detention Ctr   Regular School No High 08 12 2021   pk_12_total 5 0 8   2 0     0   0   9 6 0   0   0   10       0.0 15 5 0 8   2 0     0   0   9 6 0   0 0 10     0 15
2934771 WA Spokane   school 5300010 32801   ESD 101 acting as a school district 530001003583 5434 NEWESD 101 Open Doors   Alternative School No High 11 12 2021   grade_11 9 1 0   0 0     0   0   8 2 0   0   0   0       0.0 10 9 1 0   0 0     0   0   8 2 0   0 0 0     0 10
2934772 WA Spokane   school 5300010 32801   ESD 101 acting as a school district 530001003583 5434 NEWESD 101 Open Doors   Alternative School No High 11 12 2021   grade_12 44 3 4   2 0     0   0   27 25 1   0   0   2       0.0 53 44 3 4   2 0     0   0   27 25 1   0 0 2     0 53

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