Data source: Big Local News · About: Big Local

15,474 rows where state = "WA" and year = 2019 sorted by school_nces_id

View and edit SQL

grade

year

  • 2019 · 15,374
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
2418366 WA Cowlitz   school 5300003 8458   Kelso School District 530000300589 3082 Butler Acres Elementary   Regular School No Elementary KG 05 2019   grade_1 64 0 4   1 1     0   6   37 39 0   2   4   43       1.0 76 64 0 4   1 1     0   6   37 39 0   2 4 43     1 76
2418367 WA Cowlitz   school 5300003 8458   Kelso School District 530000300589 3082 Butler Acres Elementary   Regular School No Elementary KG 05 2019   grade_2 61 0 6   2 1     0   1   41 30 0   3   3   45       4.0 71 61 0 6   2 1     0   1   41 30 0   3 3 45     4 71
2418368 WA Cowlitz   school 5300003 8458   Kelso School District 530000300589 3082 Butler Acres Elementary   Regular School No Elementary KG 05 2019   grade_3 54 0 13   2 2     0   1   37 35 0   5   0   32       4.0 72 54 0 13   2 2     0   1   37 35 0   5 0 32     4 72
2418369 WA Cowlitz   school 5300003 8458   Kelso School District 530000300589 3082 Butler Acres Elementary   Regular School No Elementary KG 05 2019   grade_4 58 1 9   0 1     1   5   31 44 0   4   2   34       4.0 75 58 1 9   0 1     1   5   31 44 0   4 2 34     4 75
2418370 WA Cowlitz   school 5300003 8458   Kelso School District 530000300589 3082 Butler Acres Elementary   Regular School No Elementary KG 05 2019   grade_5 53 0 8   0 2     0   5   31 37 0   4   1   40       4.0 68 53 0 8   0 2     0   5   31 37 0   4 1 40     4 68
2418371 WA Cowlitz   school 5300003 8458   Kelso School District 530000300589 3082 Butler Acres Elementary   Regular School No Elementary KG 05 2019   pk_12_total 323 1 47   7 7     1   24   200 210 0   19   13   215       17.0 410 323 1 47   7 7     1   24   200 210 0   19 13 215     17 410
2418372 WA Cowlitz   school 5300003 8458   Kelso School District 530000300589 3082 Butler Acres Elementary   Regular School No Elementary KG 05 2019   kindergarten 33 0 7   2 0     0   6   23 25 0   1   3   21       0.0 48 33 0 7   2 0     0   6   23 25 0   1 3 21     0 48
2418380 WA Cowlitz   school 5300003 8458   Kelso School District 530000300590 2691 Catlin Elementary   Regular School No Elementary KG 05 2019   grade_1 37 0 10   0 0     2   4   30 23 0   8   3   42       0.0 53 37 0 10   0 0     2   4   30 23 0   8 3 42     0 53
2418381 WA Cowlitz   school 5300003 8458   Kelso School District 530000300590 2691 Catlin Elementary   Regular School No Elementary KG 05 2019   grade_2 54 0 10   2 0     3   4   42 31 0   5   8   57       0.0 73 54 0 10   2 0     3   4   42 31 0   5 8 57     0 73
2418382 WA Cowlitz   school 5300003 8458   Kelso School District 530000300590 2691 Catlin Elementary   Regular School No Elementary KG 05 2019   grade_3 35 1 9   0 0     6   5   30 26 0   10   2   42       1.0 56 35 1 9   0 0     6   5   30 26 0   10 2 42     1 56
2418383 WA Cowlitz   school 5300003 8458   Kelso School District 530000300590 2691 Catlin Elementary   Regular School No Elementary KG 05 2019   grade_4 47 1 13   0 0     0   5   36 30 0   5   5   44       1.0 66 47 1 13   0 0     0   5   36 30 0   5 5 44     1 66
2418384 WA Cowlitz   school 5300003 8458   Kelso School District 530000300590 2691 Catlin Elementary   Regular School No Elementary KG 05 2019   grade_5 42 1 8   0 1     3   4   29 30 0   5   2   45       1.0 59 42 1 8   0 1     3   4   29 30 0   5 2 45     1 59
2418385 WA Cowlitz   school 5300003 8458   Kelso School District 530000300590 2691 Catlin Elementary   Regular School No Elementary KG 05 2019   pk_12_total 248 3 63   2 1     17   30   195 169 0   39   21   274       3.0 364 248 3 63   2 1     17   30   195 169 0   39 21 274     3 364
2418386 WA Cowlitz   school 5300003 8458   Kelso School District 530000300590 2691 Catlin Elementary   Regular School No Elementary KG 05 2019   kindergarten 27 0 10   0 0     3   7   21 26 0   6   1   38       0.0 47 27 0 10   0 0     3   7   21 26 0   6 1 38     0 47
2418387 WA Cowlitz   school 5300003 8458   Kelso School District 530000300590 2691 Catlin Elementary   Regular School No Elementary KG 05 2019   pre_kindergarten 6 0 3   0 0     0   1   7 3 0   0   0   6       0.0 10 6 0 3   0 0     0   1   7 3 0   0 0 6     0 10
2418388 WA Cowlitz   school 5300003 8458   Kelso School District 530000300591 3322 Coweeman Middle School   Regular School No Middle 06 08 2019   grade_6 144 0 29   2 1     2   9   94 93 0   9   4   111       8.0 187 144 0 29   2 1     2   9   94 93 0   9 4 111     8 187
2418389 WA Cowlitz   school 5300003 8458   Kelso School District 530000300591 3322 Coweeman Middle School   Regular School No Middle 06 08 2019   grade_7 129 1 37   4 2     1   9   100 83 0   10   5   116       7.0 183 129 1 37   4 2     1   9   100 83 0   10 5 116     7 183
2418390 WA Cowlitz   school 5300003 8458   Kelso School District 530000300591 3322 Coweeman Middle School   Regular School No Middle 06 08 2019   grade_8 148 1 45   3 3     2   13   122 93 0   14   4   132       11.0 215 148 1 45   3 3     2   13   122 93 0   14 4 132     11 215
2418391 WA Cowlitz   school 5300003 8458   Kelso School District 530000300591 3322 Coweeman Middle School   Regular School No Middle 06 08 2019   pk_12_total 421 2 111   9 6     5   31   316 269 0   33   13   359       26.0 585 421 2 111   9 6     5   31   316 269 0   33 13 359     26 585
2418392 WA Cowlitz   school 5300003 8458   Kelso School District 530000300592 2916 Huntington Middle School   Regular School No Middle 06 08 2019   grade_6 137 0 36   2 0     2   17   111 83 0   14   7   135       11.0 194 137 0 36   2 0     2   17   111 83 0   14 7 135     11 194
2418393 WA Cowlitz   school 5300003 8458   Kelso School District 530000300592 2916 Huntington Middle School   Regular School No Middle 06 08 2019   grade_7 125 1 44   1 1     2   18   94 98 0   6   6   129       13.0 192 125 1 44   1 1     2   18   94 98 0   6 6 129     13 192
2418394 WA Cowlitz   school 5300003 8458   Kelso School District 530000300592 2916 Huntington Middle School   Regular School No Middle 06 08 2019   grade_8 137 0 42   0 1     4   16   98 102 0   13   4   120       9.0 200 137 0 42   0 1     4   16   98 102 0   13 4 120     9 200
2418395 WA Cowlitz   school 5300003 8458   Kelso School District 530000300592 2916 Huntington Middle School   Regular School No Middle 06 08 2019   pk_12_total 399 1 122   3 2     8   51   303 283 0   33   17   384       33.0 586 399 1 122   3 2     8   51   303 283 0   33 17 384     33 586
2418399 WA Cowlitz   school 5300003 8458   Kelso School District 530000300593 2266 Kelso High School   Regular School No High 09 12 2019   grade_10 270 2 65   9 4     7   24   195 186 0   15   12   197       14.0 381 270 2 65   9 4     7   24   195 186 0   15 12 197     14 381
2418400 WA Cowlitz   school 5300003 8458   Kelso School District 530000300593 2266 Kelso High School   Regular School No High 09 12 2019   grade_11 263 2 60   8 2     6   26   189 178 0   19   6   161       18.0 367 263 2 60   8 2     6   26   189 178 0   19 6 161     18 367
2418401 WA Cowlitz   school 5300003 8458   Kelso School District 530000300593 2266 Kelso High School   Regular School No High 09 12 2019   grade_12 322 1 66   10 6     1   37   237 206 0   15   21   228       18.0 443 322 1 66   10 6     1   37   237 206 0   15 21 228     18 443
2418402 WA Cowlitz   school 5300003 8458   Kelso School District 530000300593 2266 Kelso High School   Regular School No High 09 12 2019   grade_8 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
2418403 WA Cowlitz   school 5300003 8458   Kelso School District 530000300593 2266 Kelso High School   Regular School No High 09 12 2019   grade_9 259 0 76   4 4     2   22   188 179 0   18   11   210       17.0 367 259 0 76   4 4     2   22   188 179 0   18 11 210     17 367
2418404 WA Cowlitz   school 5300003 8458   Kelso School District 530000300593 2266 Kelso High School   Regular School No High 09 12 2019   pk_12_total 1116 5 267   31 16     16   109   811 749 0   67   50   796       67.0 1560 1116 5 267   31 16     16   109   811 749 0   67 50 796     67 1560
2418415 WA Cowlitz   school 5300003 8458   Kelso School District 530000300594 2596 Rose Valley Elementary   Regular School No Elementary KG 05 2019   grade_1 19 0 0   0 0     1   0   11 9 0   0   0   5       0.0 20 19 0 0   0 0     1   0   11 9 0   0 0 5     0 20
2418416 WA Cowlitz   school 5300003 8458   Kelso School District 530000300594 2596 Rose Valley Elementary   Regular School No Elementary KG 05 2019   grade_2 24 0 2   0 0     0   0   16 10 0   1   0   8       2.0 26 24 0 2   0 0     0   0   16 10 0   1 0 8     2 26
2418417 WA Cowlitz   school 5300003 8458   Kelso School District 530000300594 2596 Rose Valley Elementary   Regular School No Elementary KG 05 2019   grade_3 23 0 2   0 0     1   0   8 18 0   0   0   7       2.0 26 23 0 2   0 0     1   0   8 18 0   0 0 7     2 26
2418418 WA Cowlitz   school 5300003 8458   Kelso School District 530000300594 2596 Rose Valley Elementary   Regular School No Elementary KG 05 2019   grade_4 27 0 1   0 0     0   1   17 12 0   1   0   9       3.0 29 27 0 1   0 0     0   1   17 12 0   1 0 9     3 29
2418419 WA Cowlitz   school 5300003 8458   Kelso School District 530000300594 2596 Rose Valley Elementary   Regular School No Elementary KG 05 2019   grade_5 19 0 3   1 0     0   1   10 14 0   1   0   5       1.0 24 19 0 3   1 0     0   1   10 14 0   1 0 5     1 24
2418420 WA Cowlitz   school 5300003 8458   Kelso School District 530000300594 2596 Rose Valley Elementary   Regular School No Elementary KG 05 2019   pk_12_total 131 0 12   1 1     2   2   80 69 0   3   0   42       9.0 149 131 0 12   1 1     2   2   80 69 0   3 0 42     9 149
2418421 WA Cowlitz   school 5300003 8458   Kelso School District 530000300594 2596 Rose Valley Elementary   Regular School No Elementary KG 05 2019   kindergarten 19 0 4   0 1     0   0   18 6 0   0   0   8       1.0 24 19 0 4   0 1     0   0   18 6 0   0 0 8     1 24
2418424 WA Cowlitz   school 5300003 8458   Kelso School District 530000300596 2624 Wallace Elementary   Regular School No Elementary KG 05 2019   grade_1 32 0 18   0 1     4   2   31 26 0   13   2   50       0.0 57 32 0 18   0 1     4   2   31 26 0   13 2 50     0 57
2418425 WA Cowlitz   school 5300003 8458   Kelso School District 530000300596 2624 Wallace Elementary   Regular School No Elementary KG 05 2019   grade_2 33 1 17   1 1     3   3   37 22 0   12   2   49       0.0 59 33 1 17   1 1     3   3   37 22 0   12 2 49     0 59
2418426 WA Cowlitz   school 5300003 8458   Kelso School District 530000300596 2624 Wallace Elementary   Regular School No Elementary KG 05 2019   grade_3 40 1 13   0 1     4   4   29 34 0   14   2   57       0.0 63 40 1 13   0 1     4   4   29 34 0   14 2 57     0 63
2418427 WA Cowlitz   school 5300003 8458   Kelso School District 530000300596 2624 Wallace Elementary   Regular School No Elementary KG 05 2019   grade_4 38 0 17   1 0     2   3   30 31 0   9   1   53       1.0 61 38 0 17   1 0     2   3   30 31 0   9 1 53     1 61
2418428 WA Cowlitz   school 5300003 8458   Kelso School District 530000300596 2624 Wallace Elementary   Regular School No Elementary KG 05 2019   grade_5 32 0 23   0 0     3   3   33 28 0   10   4   56       1.0 61 32 0 23   0 0     3   3   33 28 0   10 4 56     1 61
2418429 WA Cowlitz   school 5300003 8458   Kelso School District 530000300596 2624 Wallace Elementary   Regular School No Elementary KG 05 2019   pk_12_total 211 2 102   2 3     17   20   198 159 0   66   16   313       2.0 357 211 2 102   2 3     17   20   198 159 0   66 16 313     2 357
2418430 WA Cowlitz   school 5300003 8458   Kelso School District 530000300596 2624 Wallace Elementary   Regular School No Elementary KG 05 2019   kindergarten 30 0 13   0 0     1   4   32 16 0   8   5   43       0.0 48 30 0 13   0 0     1   4   32 16 0   8 5 43     0 48
2418431 WA Cowlitz   school 5300003 8458   Kelso School District 530000300596 2624 Wallace Elementary   Regular School No Elementary KG 05 2019   pre_kindergarten 6 0 1   0 0     0   1   6 2 0   0   0   5       0.0 8 6 0 1   0 0     0   1   6 2 0   0 0 5     0 8
2418422 WA Cowlitz   school 5300003 8458   Kelso School District 530000303076 5076 Special Education   Special Education School No Other PK 12 2019   pk_12_total 46 0 19   1 1     1   9   50 27 0   0   1   47       0.0 77 46 0 19   1 1     1   9   50 27 0   0 1 47     0 77
2418423 WA Cowlitz   school 5300003 8458   Kelso School District 530000303076 5076 Special Education   Special Education School No Other PK 12 2019   pre_kindergarten 46 0 19   1 1     1   9   50 27 0   0   1   47       0.0 77 46 0 19   1 1     1   9   50 27 0   0 1 47     0 77
2418410 WA Cowlitz   school 5300003 8458   Kelso School District 530000303109 1934 Loowit High School   Alternative School No High 09 12 2019   grade_10 3 0 2   0 0     0   0   3 2 0   0   1   5       0.0 5 3 0 2   0 0     0   0   3 2 0   0 1 5     0 5
2418411 WA Cowlitz   school 5300003 8458   Kelso School District 530000303109 1934 Loowit High School   Alternative School No High 09 12 2019   grade_11 2 0 2   0 0     0   1   0 5 0   0   1   4       0.0 5 2 0 2   0 0     0   1   0 5 0   0 1 4     0 5
2418412 WA Cowlitz   school 5300003 8458   Kelso School District 530000303109 1934 Loowit High School   Alternative School No High 09 12 2019   grade_12 12 0 1   0 0     0   0   6 7 0   2   3   9       2.0 13 12 0 1   0 0     0   0   6 7 0   2 3 9     2 13
2418413 WA Cowlitz   school 5300003 8458   Kelso School District 530000303109 1934 Loowit High School   Alternative School No High 09 12 2019   grade_9 3 0 0   0 0     0   0   1 2 0   0   0   1       1.0 3 3 0 0   0 0     0   0   1 2 0   0 0 1     1 3
2418414 WA Cowlitz   school 5300003 8458   Kelso School District 530000303109 1934 Loowit High School   Alternative School No High 09 12 2019   pk_12_total 20 0 5   0 0     0   1   10 16 0   2   5   19       3.0 26 20 0 5   0 0     0   1   10 16 0   2 5 19     3 26
2418405 WA Cowlitz   school 5300003 8458   Kelso School District 530000303314 5194 Kelso Virtual Academy   Regular School No High 08 12 2019   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
2418406 WA Cowlitz   school 5300003 8458   Kelso School District 530000303314 5194 Kelso Virtual Academy   Regular School No High 08 12 2019   grade_11 5 0 2   0 0     0   0   5 2 0   0   0   2       2.0 7 5 0 2   0 0     0   0   5 2 0   0 0 2     2 7
2418407 WA Cowlitz   school 5300003 8458   Kelso School District 530000303314 5194 Kelso Virtual Academy   Regular School No High 08 12 2019   grade_12 4 0 1   0 0     1   0   2 4 0   0   0   5       1.0 6 4 0 1   0 0     1   0   2 4 0   0 0 5     1 6
2418408 WA Cowlitz   school 5300003 8458   Kelso School District 530000303314 5194 Kelso Virtual Academy   Regular School No High 08 12 2019   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
2418409 WA Cowlitz   school 5300003 8458   Kelso School District 530000303314 5194 Kelso Virtual Academy   Regular School No High 08 12 2019   pk_12_total 11 0 3   0 0     1   0   8 7 0   0   0   9       3.0 15 11 0 3   0 0     1   0   8 7 0   0 0 9     3 15
2418396 WA Cowlitz   school 5300003 8458   Kelso School District 530000303667 5547 Kelso Goal Oriented Learning Design   Alternative School No High 09 12 2019   grade_11 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
2418397 WA Cowlitz   school 5300003 8458   Kelso School District 530000303667 5547 Kelso Goal Oriented Learning Design   Alternative School No High 09 12 2019   grade_12 4 0 1   0 0     0   0   2 3 0   0   0   2       0.0 5 4 0 1   0 0     0   0   2 3 0   0 0 2     0 5
2418398 WA Cowlitz   school 5300003 8458   Kelso School District 530000303667 5547 Kelso Goal Oriented Learning Design   Alternative School No High 09 12 2019   pk_12_total 8 0 2   0 0     0   0   5 5 0   0   0   7       0.0 10 8 0 2   0 0     0   0   5 5 0   0 0 7     0 10
2416581 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_10 6 0 1   1 0     0   0   4 4 0   0   0   0       0.0 8 6 0 1   1 0     0   0   4 4 0   0 0 0     0 8
2416582 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_11 9 0 1   0 0     0   0   8 2 0   0   0   0       0.0 10 9 0 1   0 0     0   0   8 2 0   0 0 0     0 10
2416583 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_12 7 0 1   0 0     0   0   5 3 0   0   0   0       0.0 8 7 0 1   0 0     0   0   5 3 0   0 0 0     0 8
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
2416585 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_8 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
2416586 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_9 2 0 2   0 0     0   0   4 0 0   0   0   0       0.0 4 2 0 2   0 0     0   0   4 0 0   0 0 0     0 4
2416587 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   pk_12_total 28 0 5   1 0     0   0   24 10 0   0   0   0       0.0 34 28 0 5   1 0     0   0   24 10 0   0 0 0     0 34
2416575 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_10 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
2416576 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_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
2416577 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_12 4 0 1   0 0     0   1   6 0 0   0   0   0       0.0 6 4 0 1   0 0     0   1   6 0 0   0 0 0     0 6
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
2416579 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_9 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
2416580 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   pk_12_total 11 0 1   0 0     0   1   13 0 0   0   0   0       0.0 13 11 0 1   0 0     0   1   13 0 0   0 0 0     0 13
2416588 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 2019   grade_11 17 0 4   0 0     0   1   12 10 0   0   0   0       0.0 22 17 0 4   0 0     0   1   12 10 0   0 0 0     0 22
2416589 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 2019   grade_12 81 3 22   1 1     3   12   71 51 1   0   0   0       0.0 123 81 3 22   1 1     3   12   71 51 1   0 0 0     0 123
2416590 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 2019   pk_12_total 98 3 26   1 1     3   13   83 61 1   0   0   0       0.0 145 98 3 26   1 1     3   13   83 61 1   0 0 0     0 145
2416595 WA Kitsap   school 5300007 18801   ESD 114 acting as a school district 530000702914 3143 Clallam Co Juvenile Detention   Regular School No High 08 12 2019   grade_11 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
2416596 WA Kitsap   school 5300007 18801   ESD 114 acting as a school district 530000702914 3143 Clallam Co Juvenile Detention   Regular School No High 08 12 2019   grade_12 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
2416597 WA Kitsap   school 5300007 18801   ESD 114 acting as a school district 530000702914 3143 Clallam Co Juvenile Detention   Regular School No High 08 12 2019   pk_12_total 5 0 0   0 0     0   1   5 1 0   0   0   6       0.0 6 5 0 0   0 0     0   1   5 1 0   0 0 6     0 6
2416598 WA Kitsap   school 5300007 18801   ESD 114 acting as a school district 530000702927 3481 Kitsap Co Detention Ctr   Regular School No High 08 12 2019   grade_10 5 0 0   0 0     0   0   5 0 0   0   0   5       0.0 5 5 0 0   0 0     0   0   5 0 0   0 0 5     0 5
2416599 WA Kitsap   school 5300007 18801   ESD 114 acting as a school district 530000702927 3481 Kitsap Co Detention Ctr   Regular School No High 08 12 2019   grade_11 2 0 1   0 0     0   0   1 2 0   0   0   3       0.0 3 2 0 1   0 0     0   0   1 2 0   0 0 3     0 3
2416600 WA Kitsap   school 5300007 18801   ESD 114 acting as a school district 530000702927 3481 Kitsap Co Detention Ctr   Regular School No High 08 12 2019   grade_12 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
2416601 WA Kitsap   school 5300007 18801   ESD 114 acting as a school district 530000702927 3481 Kitsap Co Detention Ctr   Regular School No High 08 12 2019   grade_9 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
2416602 WA Kitsap   school 5300007 18801   ESD 114 acting as a school district 530000702927 3481 Kitsap Co Detention Ctr   Regular School No High 08 12 2019   pk_12_total 10 0 1   0 0     0   1   9 3 0   0   0   12       0.0 12 10 0 1   0 0     0   1   9 3 0   0 0 12     0 12
2416606 WA Skagit   school 5300008 29801   ESD 189 acting as a school district 530000802921 3363 Skagit County Detention Center   Regular School No High 08 12 2019   grade_10 3 0 1   0 0     0   0   3 1 0   0   0   0       0.0 4 3 0 1   0 0     0   0   3 1 0   0 0 0     0 4
2416607 WA Skagit   school 5300008 29801   ESD 189 acting as a school district 530000802921 3363 Skagit County Detention Center   Regular School No High 08 12 2019   grade_11 0 0 2   0 0     0   0   2 0 0   0   0   0       0.0 2 0 0 2   0 0     0   0   2 0 0   0 0 0     0 2
2416608 WA Skagit   school 5300008 29801   ESD 189 acting as a school district 530000802921 3363 Skagit County Detention Center   Regular School No High 08 12 2019   grade_12 4 0 1   0 0     0   0   3 2 0   0   0   0       0.0 5 4 0 1   0 0     0   0   3 2 0   0 0 0     0 5
2416609 WA Skagit   school 5300008 29801   ESD 189 acting as a school district 530000802921 3363 Skagit County Detention Center   Regular School No High 08 12 2019   pk_12_total 7 0 4   0 0     0   0   8 3 0   0   0   0       0.0 11 7 0 4   0 0     0   0   8 3 0   0 0 0     0 11
2416610 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_10 2 0 0   1 0     0   0   2 1 0   0   0   0       0.0 3 2 0 0   1 0     0   0   2 1 0   0 0 0     0 3
2416611 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_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
2416612 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_12 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
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
2416614 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_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
2416615 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   pk_12_total 6 1 1   1 0     0   0   7 2 0   0   0   0       0.0 9 6 1 1   1 0     0   0   7 2 0   0 0 0     0 9
2416603 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 2019   grade_11 8 0 1   1 0     0   1   7 3 1   0   0   0       0.0 11 8 0 1   1 0     0   1   7 3 1   0 0 0     0 11
2416604 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 2019   grade_12 15 0 3   0 0     0   0   12 6 0   0   0   0       0.0 18 15 0 3   0 0     0   0   12 6 0   0 0 0     0 18
2416605 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 2019   pk_12_total 23 0 4   1 0     0   1   19 9 1   0   0   0       0.0 29 23 0 4   1 0     0   1   19 9 1   0 0 0     0 29
2416556 WA Spokane   school 5300010 32801   ESD 101 acting as a school district 530001002919 3352 Martin Hall Detention Ctr   Regular School No High 08 12 2019   grade_10 1 0 4   0 0     0   0   5 0 0   0   0   4       0.0 5 1 0 4   0 0     0   0   5 0 0   0 0 4     0 5
2416557 WA Spokane   school 5300010 32801   ESD 101 acting as a school district 530001002919 3352 Martin Hall Detention Ctr   Regular School No High 08 12 2019   grade_11 4 0 1   0 0     0   0   5 0 0   0   0   3       0.0 5 4 0 1   0 0     0   0   5 0 0   0 0 3     0 5
2416558 WA Spokane   school 5300010 32801   ESD 101 acting as a school district 530001002919 3352 Martin Hall Detention Ctr   Regular School No High 08 12 2019   grade_12 0 0 2   1 0     0   0   2 1 0   0   0   0       0.0 3 0 0 2   1 0     0   0   2 1 0   0 0 0     0 3
2416559 WA Spokane   school 5300010 32801   ESD 101 acting as a school district 530001002919 3352 Martin Hall Detention Ctr   Regular School No High 08 12 2019   grade_9 2 0 3   0 0     0   0   3 2 0   0   0   5       0.0 5 2 0 3   0 0     0   0   3 2 0   0 0 5     0 5

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