Data source: Big Local News · About: Big Local

15,758 rows where state = "WA" and year = 2017 sorted by district_nces_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
622500 WA Cowlitz   school 5300003 8458   Kelso School District 530000300167 2913 Carrolls Elementary   Regular School No Elementary KG 05 2017   grade_4 12 0 1   1 1     0   4   7 12 0   0   1   6       0.0 19 12 0 1   1 1     0   4   7 12 0   0 1 6     0 19
622501 WA Cowlitz   school 5300003 8458   Kelso School District 530000300167 2913 Carrolls Elementary   Regular School No Elementary KG 05 2017   grade_5 19 0 1   1 0     0   3   9 15 0   0   0   5       2.0 24 19 0 1   1 0     0   3   9 15 0   0 0 5     2 24
622502 WA Cowlitz   school 5300003 8458   Kelso School District 530000300167 2913 Carrolls Elementary   Regular School No Elementary KG 05 2017   pk_12_total 114 0 9   3 7     0   12   70 75 0   3   2   52       7.0 145 114 0 9   3 7     0   12   70 75 0   3 2 52     7 145
622503 WA Cowlitz   school 5300003 8458   Kelso School District 530000300167 2913 Carrolls Elementary   Regular School No Elementary KG 05 2017   kindergarten_half_day 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
622504 WA Cowlitz   school 5300003 8458   Kelso School District 530000300167 2913 Carrolls Elementary   Regular School No Elementary KG 05 2017   kindergarten 20 0 1   0 0     0   0   14 7 0   0   0   6       2.0 21 20 0 1   0 0     0   0   14 7 0   0 0 6     2 21
622505 WA Cowlitz   school 5300003 8458   Kelso School District 530000300590 2691 Catlin Elementary   Regular School No Elementary KG 05 2017   grade_1 32 0 9   0 0     3   10   29 25 0   6   3   44       2.0 54 32 0 9   0 0     3   10   29 25 0   6 3 44     2 54
622506 WA Cowlitz   school 5300003 8458   Kelso School District 530000300590 2691 Catlin Elementary   Regular School No Elementary KG 05 2017   grade_2 37 0 11   0 0     0   3   29 22 0   3   3   40       1.0 51 37 0 11   0 0     0   3   29 22 0   3 3 40     1 51
622507 WA Cowlitz   school 5300003 8458   Kelso School District 530000300590 2691 Catlin Elementary   Regular School No Elementary KG 05 2017   grade_3 36 0 7   0 0     0   4   29 18 0   3   1   37       1.0 47 36 0 7   0 0     0   4   29 18 0   3 1 37     1 47
622508 WA Cowlitz   school 5300003 8458   Kelso School District 530000300590 2691 Catlin Elementary   Regular School No Elementary KG 05 2017   grade_4 27 0 8   0 1     1   2   25 14 0   2   3   33       0.0 39 27 0 8   0 1     1   2   25 14 0   2 3 33     0 39
622509 WA Cowlitz   school 5300003 8458   Kelso School District 530000300590 2691 Catlin Elementary   Regular School No Elementary KG 05 2017   grade_5 27 0 12   1 0     0   2   21 21 0   2   3   34       2.0 42 27 0 12   1 0     0   2   21 21 0   2 3 34     2 42
622510 WA Cowlitz   school 5300003 8458   Kelso School District 530000300590 2691 Catlin Elementary   Regular School No Elementary KG 05 2017   pk_12_total 210 0 62   2 4     5   27   177 133 0   22   15   246       6.0 310 210 0 62   2 4     5   27   177 133 0   22 15 246     6 310
622511 WA Cowlitz   school 5300003 8458   Kelso School District 530000300590 2691 Catlin Elementary   Regular School No Elementary KG 05 2017   kindergarten 37 0 14   1 2     1   4   32 27 0   6   2   44       0.0 59 37 0 14   1 2     1   4   32 27 0   6 2 44     0 59
622512 WA Cowlitz   school 5300003 8458   Kelso School District 530000300590 2691 Catlin Elementary   Regular School No Elementary KG 05 2017   pre_kindergarten 14 0 1   0 1     0   2   12 6 0   0   0   14       0.0 18 14 0 1   0 1     0   2   12 6 0   0 0 14     0 18
622513 WA Cowlitz   school 5300003 8458   Kelso School District 530000300591 3322 Coweeman Middle School   Regular School No Middle 06 08 2017   grade_6 134 1 42   3 2     2   12   103 93 0   16   4   123       9.0 196 134 1 42   3 2     2   12   103 93 0   16 4 123     9 196
622514 WA Cowlitz   school 5300003 8458   Kelso School District 530000300591 3322 Coweeman Middle School   Regular School No Middle 06 08 2017   grade_7 141 0 32   4 3     0   9   84 105 0   12   1   101       8.0 189 141 0 32   4 3     0   9   84 105 0   12 1 101     8 189
622515 WA Cowlitz   school 5300003 8458   Kelso School District 530000300591 3322 Coweeman Middle School   Regular School No Middle 06 08 2017   grade_8 149 1 29   5 2     4   8   99 99 0   12   3   109       5.0 198 149 1 29   5 2     4   8   99 99 0   12 3 109     5 198
622516 WA Cowlitz   school 5300003 8458   Kelso School District 530000300591 3322 Coweeman Middle School   Regular School No Middle 06 08 2017   pk_12_total 424 2 103   12 7     6   29   286 297 0   40   8   333       22.0 583 424 2 103   12 7     6   29   286 297 0   40 8 333     22 583
622517 WA Cowlitz   school 5300003 8458   Kelso School District 530000300592 2916 Huntington Middle School   Regular School No Middle 06 08 2017   grade_6 161 0 43   0 1     6   8   112 107 0   19   7   145       8.0 219 161 0 43   0 1     6   8   112 107 0   19 7 145     8 219
622518 WA Cowlitz   school 5300003 8458   Kelso School District 530000300592 2916 Huntington Middle School   Regular School No Middle 06 08 2017   grade_7 109 0 36   0 2     0   7   81 73 0   6   5   102       5.0 154 109 0 36   0 2     0   7   81 73 0   6 5 102     5 154
622519 WA Cowlitz   school 5300003 8458   Kelso School District 530000300592 2916 Huntington Middle School   Regular School No Middle 06 08 2017   grade_8 135 0 27   3 1     2   19   89 98 0   4   9   101       8.0 187 135 0 27   3 1     2   19   89 98 0   4 9 101     8 187
622520 WA Cowlitz   school 5300003 8458   Kelso School District 530000300592 2916 Huntington Middle School   Regular School No Middle 06 08 2017   pk_12_total 405 0 106   3 4     8   34   282 278 0   29   21   348       21.0 560 405 0 106   3 4     8   34   282 278 0   29 21 348     21 560
622521 WA Cowlitz   school 5300003 8458   Kelso School District 530000300593 2266 Kelso High School   Regular School No High 09 12 2017   grade_10 256 0 67   8 5     3   33   203 169 0   16   5   193       17.0 372 256 0 67   8 5     3   33   203 169 0   16 5 193     17 372
622522 WA Cowlitz   school 5300003 8458   Kelso School District 530000300593 2266 Kelso High School   Regular School No High 09 12 2017   grade_11 318 3 55   7 5     2   26   213 203 0   23   8   209       14.0 416 318 3 55   7 5     2   26   213 203 0   23 8 209     14 416
622523 WA Cowlitz   school 5300003 8458   Kelso School District 530000300593 2266 Kelso High School   Regular School No High 09 12 2017   grade_12 323 0 70   8 3     2   30   217 219 0   19   8   221       10.0 436 323 0 70   8 3     2   30   217 219 0   19 8 221     10 436
622524 WA Cowlitz   school 5300003 8458   Kelso School District 530000300593 2266 Kelso High School   Regular School No High 09 12 2017   grade_9 258 1 59   10 2     4   26   167 193 0   12   5   182       14.0 360 258 1 59   10 2     4   26   167 193 0   12 5 182     14 360
622525 WA Cowlitz   school 5300003 8458   Kelso School District 530000300593 2266 Kelso High School   Regular School No High 09 12 2017   pk_12_total 1155 4 251   33 15     11   115   800 784 0   70   26   805       55.0 1584 1155 4 251   33 15     11   115   800 784 0   70 26 805     55 1584
622526 WA Cowlitz   school 5300003 8458   Kelso School District 530000303314 5194 Kelso Virtual Academy   Regular School No High 08 12 2017   grade_10 3 0 0   0 0     0   1   1 3 0   0   0   3       0.0 4 3 0 0   0 0     0   1   1 3 0   0 0 3     0 4
622527 WA Cowlitz   school 5300003 8458   Kelso School District 530000303314 5194 Kelso Virtual Academy   Regular School No High 08 12 2017   grade_11 7 0 1   0 0     0   0   2 6 0   0   0   6       0.0 8 7 0 1   0 0     0   0   2 6 0   0 0 6     0 8
622528 WA Cowlitz   school 5300003 8458   Kelso School District 530000303314 5194 Kelso Virtual Academy   Regular School No High 08 12 2017   grade_12 17 0 3   0 0     0   4   7 17 0   0   1   11       1.0 24 17 0 3   0 0     0   4   7 17 0   0 1 11     1 24
622529 WA Cowlitz   school 5300003 8458   Kelso School District 530000303314 5194 Kelso Virtual Academy   Regular School No High 08 12 2017   grade_9 3 0 0   0 0     0   0   2 1 0   0   0   2       1.0 3 3 0 0   0 0     0   0   2 1 0   0 0 2     1 3
622530 WA Cowlitz   school 5300003 8458   Kelso School District 530000303314 5194 Kelso Virtual Academy   Regular School No High 08 12 2017   pk_12_total 30 0 4   0 0     0   5   12 27 0   0   1   22       2.0 39 30 0 4   0 0     0   5   12 27 0   0 1 22     2 39
622531 WA Cowlitz   school 5300003 8458   Kelso School District 530000303109 1934 Loowit High School   Alternative School No High 09 12 2017   grade_10 5 0 1   0 0     0   1   5 2 0   0   0   5       1.0 7 5 0 1   0 0     0   1   5 2 0   0 0 5     1 7
622532 WA Cowlitz   school 5300003 8458   Kelso School District 530000303109 1934 Loowit High School   Alternative School No High 09 12 2017   grade_11 9 0 0   1 0     0   1   3 8 0   0   3   9       2.0 11 9 0 0   1 0     0   1   3 8 0   0 3 9     2 11
622533 WA Cowlitz   school 5300003 8458   Kelso School District 530000303109 1934 Loowit High School   Alternative School No High 09 12 2017   grade_12 7 0 1   0 0     0   0   3 5 0   0   4   8       1.0 8 7 0 1   0 0     0   0   3 5 0   0 4 8     1 8
622534 WA Cowlitz   school 5300003 8458   Kelso School District 530000303109 1934 Loowit High School   Alternative School No High 09 12 2017   grade_9 2 0 0   0 0     0   0   2 0 0   0   0   1       2.0 2 2 0 0   0 0     0   0   2 0 0   0 0 1     2 2
622535 WA Cowlitz   school 5300003 8458   Kelso School District 530000303109 1934 Loowit High School   Alternative School No High 09 12 2017   pk_12_total 23 0 2   1 0     0   2   13 15 0   0   7   23       6.0 28 23 0 2   1 0     0   2   13 15 0   0 7 23     6 28
622536 WA Cowlitz   school 5300003 8458   Kelso School District 530000300594 2596 Rose Valley Elementary   Regular School No Elementary KG 05 2017   grade_1 18 0 2   0 0     1   0   8 13 0   0   1   8       0.0 21 18 0 2   0 0     1   0   8 13 0   0 1 8     0 21
622537 WA Cowlitz   school 5300003 8458   Kelso School District 530000300594 2596 Rose Valley Elementary   Regular School No Elementary KG 05 2017   grade_2 23 1 0   0 0     0   1   15 10 0   0   1   9       0.0 25 23 1 0   0 0     0   1   15 10 0   0 1 9     0 25
622538 WA Cowlitz   school 5300003 8458   Kelso School District 530000300594 2596 Rose Valley Elementary   Regular School No Elementary KG 05 2017   grade_3 18 0 3   0 0     0   0   8 13 0   1   1   5       1.0 21 18 0 3   0 0     0   0   8 13 0   1 1 5     1 21
622539 WA Cowlitz   school 5300003 8458   Kelso School District 530000300594 2596 Rose Valley Elementary   Regular School No Elementary KG 05 2017   grade_4 19 0 2   0 0     0   0   8 13 0   0   0   8       1.0 21 19 0 2   0 0     0   0   8 13 0   0 0 8     1 21
622540 WA Cowlitz   school 5300003 8458   Kelso School District 530000300594 2596 Rose Valley Elementary   Regular School No Elementary KG 05 2017   grade_5 15 0 1   1 0     0   0   8 9 0   0   0   5       0.0 17 15 0 1   1 0     0   0   8 9 0   0 0 5     0 17
622541 WA Cowlitz   school 5300003 8458   Kelso School District 530000300594 2596 Rose Valley Elementary   Regular School No Elementary KG 05 2017   pk_12_total 114 1 11   1 0     1   1   61 68 0   2   3   42       4.0 129 114 1 11   1 0     1   1   61 68 0   2 3 42     4 129
622542 WA Cowlitz   school 5300003 8458   Kelso School District 530000300594 2596 Rose Valley Elementary   Regular School No Elementary KG 05 2017   kindergarten_half_day 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
622543 WA Cowlitz   school 5300003 8458   Kelso School District 530000300594 2596 Rose Valley Elementary   Regular School No Elementary KG 05 2017   kindergarten 20 0 3   0 0     0   0   14 9 0   1   0   6       2.0 23 20 0 3   0 0     0   0   14 9 0   1 0 6     2 23
622544 WA Cowlitz   school 5300003 8458   Kelso School District 530000303076 5076 Special Education   Special Education School No Other PK 12 2017   grade_12 1 1 0   0 0     0   0   2 0 0   0   0   0       1.0 2 1 1 0   0 0     0   0   2 0 0   0 0 0     1 2
622545 WA Cowlitz   school 5300003 8458   Kelso School District 530000303076 5076 Special Education   Special Education School No Other PK 12 2017   grade_2 1 0 0   0 0     0   0   0 1 0   0   0   1       0.0 1 1 0 0   0 0     0   0   0 1 0   0 0 1     0 1
622546 WA Cowlitz   school 5300003 8458   Kelso School District 530000303076 5076 Special Education   Special Education School No Other PK 12 2017   grade_4 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
622547 WA Cowlitz   school 5300003 8458   Kelso School District 530000303076 5076 Special Education   Special Education School No Other PK 12 2017   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
622548 WA Cowlitz   school 5300003 8458   Kelso School District 530000303076 5076 Special Education   Special Education School No Other PK 12 2017   pk_12_total 13 1 1   0 0     0   1   10 6 0   0   0   8       1.0 16 13 1 1   0 0     0   1   10 6 0   0 0 8     1 16
622549 WA Cowlitz   school 5300003 8458   Kelso School District 530000303076 5076 Special Education   Special Education School No Other PK 12 2017   kindergarten_half_day 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
622550 WA Cowlitz   school 5300003 8458   Kelso School District 530000303076 5076 Special Education   Special Education School No Other PK 12 2017   pre_kindergarten 7 0 1   0 0     0   1   5 4 0   0   0   5       0.0 9 7 0 1   0 0     0   1   5 4 0   0 0 5     0 9
622551 WA Cowlitz   school 5300003 8458   Kelso School District 530000300596 2624 Wallace Elementary   Regular School No Elementary KG 05 2017   grade_1 38 1 13   0 2     0   4   30 28 0   16   5   52       0.0 58 38 1 13   0 2     0   4   30 28 0   16 5 52     0 58
622552 WA Cowlitz   school 5300003 8458   Kelso School District 530000300596 2624 Wallace Elementary   Regular School No Elementary KG 05 2017   grade_2 32 0 19   0 0     4   3   30 28 0   18   4   52       1.0 58 32 0 19   0 0     4   3   30 28 0   18 4 52     1 58
622553 WA Cowlitz   school 5300003 8458   Kelso School District 530000300596 2624 Wallace Elementary   Regular School No Elementary KG 05 2017   grade_3 27 0 23   0 0     4   5   30 29 0   16   4   57       0.0 59 27 0 23   0 0     4   5   30 29 0   16 4 57     0 59
622554 WA Cowlitz   school 5300003 8458   Kelso School District 530000300596 2624 Wallace Elementary   Regular School No Elementary KG 05 2017   grade_4 42 0 20   0 0     2   4   39 29 0   10   4   64       4.0 68 42 0 20   0 0     2   4   39 29 0   10 4 64     4 68
622555 WA Cowlitz   school 5300003 8458   Kelso School District 530000300596 2624 Wallace Elementary   Regular School No Elementary KG 05 2017   grade_5 37 3 28   1 0     2   2   47 26 0   11   2   65       3.0 73 37 3 28   1 0     2   2   47 26 0   11 2 65     3 73
622556 WA Cowlitz   school 5300003 8458   Kelso School District 530000300596 2624 Wallace Elementary   Regular School No Elementary KG 05 2017   pk_12_total 210 5 117   2 3     15   19   203 168 0   83   21   344       8.0 371 210 5 117   2 3     15   19   203 168 0   83 21 344     8 371
622557 WA Cowlitz   school 5300003 8458   Kelso School District 530000300596 2624 Wallace Elementary   Regular School No Elementary KG 05 2017   kindergarten 34 1 14   1 1     3   1   27 28 0   12   2   54       0.0 55 34 1 14   1 1     3   1   27 28 0   12 2 54     0 55
620658 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 2017   grade_10 4 2 0   0 0     0   0   6 0 0   0   0   0       0.0 6 4 2 0   0 0     0   0   6 0 0   0 0 0     0 6
620659 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 2017   grade_11 4 1 0   0 0     0   1   5 1 0   0   0   0       0.0 6 4 1 0   0 0     0   1   5 1 0   0 0 0     0 6
620660 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 2017   grade_12 5 1 1   0 0     0   0   5 2 0   0   0   0       0.0 7 5 1 1   0 0     0   0   5 2 0   0 0 0     0 7
620661 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 2017   grade_8 2 1 0   0 0     0   0   3 0 0   0   0   0       0.0 3 2 1 0   0 0     0   0   3 0 0   0 0 0     0 3
620662 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 2017   grade_9 1 0 0   1 0     0   0   2 0 0   0   0   0       0.0 2 1 0 0   1 0     0   0   2 0 0   0 0 0     0 2
620663 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 2017   pk_12_total 16 5 1   1 0     0   1   21 3 0   0   0   0       0.0 24 16 5 1   1 0     0   1   21 3 0   0 0 0     0 24
620664 WA Clark   school 5300005 6801   ESD 112 acting as a school district 530000502917 3294 Cowlitz County Youth Services Center   Regular School No Other 06 12 2017   grade_10 3 0 1   0 0     0   0   4 0 0   0   0   0       0.0 4 3 0 1   0 0     0   0   4 0 0   0 0 0     0 4
620665 WA Clark   school 5300005 6801   ESD 112 acting as a school district 530000502917 3294 Cowlitz County Youth Services Center   Regular School No Other 06 12 2017   grade_11 6 0 2   0 0     0   1   6 3 0   0   0   0       0.0 9 6 0 2   0 0     0   1   6 3 0   0 0 0     0 9
620666 WA Clark   school 5300005 6801   ESD 112 acting as a school district 530000502917 3294 Cowlitz County Youth Services Center   Regular School No Other 06 12 2017   grade_12 4 0 2   0 0     0   1   5 2 0   0   0   0       0.0 7 4 0 2   0 0     0   1   5 2 0   0 0 0     0 7
620667 WA Clark   school 5300005 6801   ESD 112 acting as a school district 530000502917 3294 Cowlitz County Youth Services Center   Regular School No Other 06 12 2017   grade_5 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
620668 WA Clark   school 5300005 6801   ESD 112 acting as a school district 530000502917 3294 Cowlitz County Youth Services Center   Regular School No Other 06 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
620669 WA Clark   school 5300005 6801   ESD 112 acting as a school district 530000502917 3294 Cowlitz County Youth Services Center   Regular School No Other 06 12 2017   grade_9 5 0 0   0 0     0   0   2 3 0   0   0   0       0.0 5 5 0 0   0 0     0   0   2 3 0   0 0 0     0 5
620670 WA Clark   school 5300005 6801   ESD 112 acting as a school district 530000502917 3294 Cowlitz County Youth Services Center   Regular School No Other 06 12 2017   pk_12_total 19 0 6   0 0     0   3   19 9 0   0   0   0       0.0 28 19 0 6   0 0     0   3   19 9 0   0 0 0     0 28
620671 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 2017   grade_11 14 0 0   0 0     1   0   11 4 0   0   1   0       0.0 15 14 0 0   0 0     1   0   11 4 0   0 1 0     0 15
620672 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 2017   grade_12 57 2 24   2 1     1   5   54 38 0   0   0   0       0.0 92 57 2 24   2 1     1   5   54 38 0   0 0 0     0 92
620673 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 2017   pk_12_total 71 2 24   2 1     2   5   65 42 0   0   1   0       0.0 107 71 2 24   2 1     2   5   65 42 0   0 1 0     0 107
620678 WA Kitsap   school 5300007 18801   ESD 114 acting as a school district 530000702914 3143 Clallam Co Juvenile Detention   Regular School No High 08 12 2017   grade_10 2 0 0   0 0     0   0   2 0 0   0   0   2       0.0 2 2 0 0   0 0     0   0   2 0 0   0 0 2     0 2
620679 WA Kitsap   school 5300007 18801   ESD 114 acting as a school district 530000702914 3143 Clallam Co Juvenile Detention   Regular School No High 08 12 2017   grade_11 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
620680 WA Kitsap   school 5300007 18801   ESD 114 acting as a school district 530000702914 3143 Clallam Co Juvenile Detention   Regular School No High 08 12 2017   grade_12 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
620681 WA Kitsap   school 5300007 18801   ESD 114 acting as a school district 530000702914 3143 Clallam Co Juvenile Detention   Regular School No High 08 12 2017   pk_12_total 4 0 0   0 0     0   0   2 2 0   0   0   4       0.0 4 4 0 0   0 0     0   0   2 2 0   0 0 4     0 4
620682 WA Kitsap   school 5300007 18801   ESD 114 acting as a school district 530000702927 3481 Kitsap Co Detention Ctr   Regular School No High 08 12 2017   grade_10 1 2 0   0 0     0   1   4 0 0   0   0   4       0.0 4 1 2 0   0 0     0   1   4 0 0   0 0 4     0 4
620683 WA Kitsap   school 5300007 18801   ESD 114 acting as a school district 530000702927 3481 Kitsap Co Detention Ctr   Regular School No High 08 12 2017   grade_11 3 0 0   0 0     0   3   4 2 0   0   0   6       0.0 6 3 0 0   0 0     0   3   4 2 0   0 0 6     0 6
620684 WA Kitsap   school 5300007 18801   ESD 114 acting as a school district 530000702927 3481 Kitsap Co Detention Ctr   Regular School No High 08 12 2017   grade_12 6 1 0   0 0     1   0   7 2 0   0   0   9       0.0 9 6 1 0   0 0     1   0   7 2 0   0 0 9     0 9
620685 WA Kitsap   school 5300007 18801   ESD 114 acting as a school district 530000702927 3481 Kitsap Co Detention Ctr   Regular School No High 08 12 2017   grade_7 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
620686 WA Kitsap   school 5300007 18801   ESD 114 acting as a school district 530000702927 3481 Kitsap Co Detention Ctr   Regular School No High 08 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
620687 WA Kitsap   school 5300007 18801   ESD 114 acting as a school district 530000702927 3481 Kitsap Co Detention Ctr   Regular School No High 08 12 2017   grade_9 4 0 0   0 0     0   0   3 1 0   0   0   4       0.0 4 4 0 0   0 0     0   0   3 1 0   0 0 4     0 4
620688 WA Kitsap   school 5300007 18801   ESD 114 acting as a school district 530000702927 3481 Kitsap Co Detention Ctr   Regular School No High 08 12 2017   pk_12_total 15 3 0   0 0     2   4   20 5 0   0   0   25       0.0 25 15 3 0   0 0     2   4   20 5 0   0 0 25     0 25
620689 WA Skagit   school 5300008 29801   ESD 189 acting as a school district 530000802921 3363 Skagit County Detention Center   Regular School No High 08 12 2017   grade_11 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
620690 WA Skagit   school 5300008 29801   ESD 189 acting as a school district 530000802921 3363 Skagit County Detention Center   Regular School No High 08 12 2017   pk_12_total 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
620691 WA Skagit   school 5300008 29801   ESD 189 acting as a school district 530000802923 3420 Whatcom Co Detention Center   Regular School No High 08 12 2017   grade_11 0 0 0   1 0     0   0   1 0 0   0   0   0       0.0 1 0 0 0   1 0     0   0   1 0 0   0 0 0     0 1
620692 WA Skagit   school 5300008 29801   ESD 189 acting as a school district 530000802923 3420 Whatcom Co Detention Center   Regular School No High 08 12 2017   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
620693 WA Skagit   school 5300008 29801   ESD 189 acting as a school district 530000802923 3420 Whatcom Co Detention Center   Regular School No High 08 12 2017   pk_12_total 2 0 1   1 0     0   0   3 1 0   0   0   0       0.0 4 2 0 1   1 0     0   0   3 1 0   0 0 0     0 4
620641 WA Spokane   school 5300010 32801   ESD 101 acting as a school district 530001002919 3352 Martin Hall Detention Ctr   Regular School No High 08 12 2017   grade_10 0 0 4   0 0     0   0   2 2 0   0   0   4       0.0 4 0 0 4   0 0     0   0   2 2 0   0 0 4     0 4
620642 WA Spokane   school 5300010 32801   ESD 101 acting as a school district 530001002919 3352 Martin Hall Detention Ctr   Regular School No High 08 12 2017   grade_11 3 1 2   0 0     1   0   7 0 0   0   0   5       0.0 7 3 1 2   0 0     1   0   7 0 0   0 0 5     0 7
620643 WA Spokane   school 5300010 32801   ESD 101 acting as a school district 530001002919 3352 Martin Hall Detention Ctr   Regular School No High 08 12 2017   grade_9 1 0 0   1 0     0   0   1 1 0   0   0   2       0.0 2 1 0 0   1 0     0   0   1 1 0   0 0 2     0 2
620644 WA Spokane   school 5300010 32801   ESD 101 acting as a school district 530001002919 3352 Martin Hall Detention Ctr   Regular School No High 08 12 2017   pk_12_total 4 1 6   1 0     1   0   10 3 0   0   0   11       0.0 13 4 1 6   1 0     1   0   10 3 0   0 0 11     0 13
620645 WA Spokane   school 5300010 32801   ESD 101 acting as a school district 530001003583 5434 NEWESD 101 Open Doors   Alternative School No High 11 12 2017   grade_11 38 6 6   4 0     0   0   34 20 0   0   0   6       0.0 54 38 6 6   4 0     0   0   34 20 0   0 0 6     0 54
620646 WA Spokane   school 5300010 32801   ESD 101 acting as a school district 530001003583 5434 NEWESD 101 Open Doors   Alternative School No High 11 12 2017   grade_12 19 4 6   2 0     0   2   21 12 0   0   0   0       0.0 33 19 4 6   2 0     0   2   21 12 0   0 0 0     0 33
620647 WA Spokane   school 5300010 32801   ESD 101 acting as a school district 530001003583 5434 NEWESD 101 Open Doors   Alternative School No High 11 12 2017   pk_12_total 57 10 12   6 0     0   2   55 32 0   0   0   6       0.0 87 57 10 12   6 0     0   2   55 32 0   0 0 6     0 87
620648 WA Spokane   school 5300010 32801   ESD 101 acting as a school district 530001002930 3526 Spokane Juvenile Detention School   Regular School No Other 06 12 2017   grade_10 3 2 0   1 0     0   0   6 0 0   0   0   4       0.0 6 3 2 0   1 0     0   0   6 0 0   0 0 4     0 6
620649 WA Spokane   school 5300010 32801   ESD 101 acting as a school district 530001002930 3526 Spokane Juvenile Detention School   Regular School No Other 06 12 2017   grade_11 15 1 0   1 0     0   0   14 3 0   0   0   9       0.0 17 15 1 0   1 0     0   0   14 3 0   0 0 9     0 17
620650 WA Spokane   school 5300010 32801   ESD 101 acting as a school district 530001002930 3526 Spokane Juvenile Detention School   Regular School No Other 06 12 2017   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

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