Data source: Big Local News · About: Big Local

15,431 rows where state = "WA" and year = 2018 sorted by school_nces_id

View and edit SQL

grade

year

  • 2018 · 15,331
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
2462854 WA Cowlitz   school 5300003 8458   Kelso School District 530000300588 3578 Beacon Hill Elementary   Regular School No Elementary KG 05 2018   pk_12_total 378 0 83   0 7     1   41   249 261 0   48   19   291       22.0 510 378 0 83   0 7     1   41   249 261 0   48 19 291     22 510
2462855 WA Cowlitz   school 5300003 8458   Kelso School District 530000300588 3578 Beacon Hill Elementary   Regular School No Elementary KG 05 2018   kindergarten 66 0 18   0 4     0   5   49 44 0   10   6   51       3.0 93 66 0 18   0 4     0   5   49 44 0   10 6 51     3 93
2462856 WA Cowlitz   school 5300003 8458   Kelso School District 530000300589 3082 Butler Acres Elementary   Regular School No Elementary KG 05 2018   grade_1 52 0 4   2 2     0   1   34 27 0   3   2   37       2.0 61 52 0 4   2 2     0   1   34 27 0   3 2 37     2 61
2462857 WA Cowlitz   school 5300003 8458   Kelso School District 530000300589 3082 Butler Acres Elementary   Regular School No Elementary KG 05 2018   grade_2 51 0 12   1 1     0   1   34 32 0   7   1   32       2.0 66 51 0 12   1 1     0   1   34 32 0   7 1 32     2 66
2462858 WA Cowlitz   school 5300003 8458   Kelso School District 530000300589 3082 Butler Acres Elementary   Regular School No Elementary KG 05 2018   grade_3 57 0 8   0 0     1   4   33 37 0   3   2   38       3.0 70 57 0 8   0 0     1   4   33 37 0   3 2 38     3 70
2462859 WA Cowlitz   school 5300003 8458   Kelso School District 530000300589 3082 Butler Acres Elementary   Regular School No Elementary KG 05 2018   grade_4 54 0 7   0 2     0   3   31 35 0   3   2   40       3.0 66 54 0 7   0 2     0   3   31 35 0   3 2 40     3 66
2462860 WA Cowlitz   school 5300003 8458   Kelso School District 530000300589 3082 Butler Acres Elementary   Regular School No Elementary KG 05 2018   grade_5 71 0 8   1 1     0   2   41 42 0   2   0   40       5.0 83 71 0 8   1 1     0   2   41 42 0   2 0 40     5 83
2462861 WA Cowlitz   school 5300003 8458   Kelso School District 530000300589 3082 Butler Acres Elementary   Regular School No Elementary KG 05 2018   pk_12_total 340 0 44   5 7     1   12   199 210 0   20   9   217       15.0 409 340 0 44   5 7     1   12   199 210 0   20 9 217     15 409
2462862 WA Cowlitz   school 5300003 8458   Kelso School District 530000300589 3082 Butler Acres Elementary   Regular School No Elementary KG 05 2018   kindergarten 55 0 5   1 1     0   1   26 37 0   2   2   30       0.0 63 55 0 5   1 1     0   1   26 37 0   2 2 30     0 63
2462870 WA Cowlitz   school 5300003 8458   Kelso School District 530000300590 2691 Catlin Elementary   Regular School No Elementary KG 05 2018   grade_1 47 0 12   1 0     1   3   33 31 0   5   4   49       0.0 64 47 0 12   1 0     1   3   33 31 0   5 4 49     0 64
2462871 WA Cowlitz   school 5300003 8458   Kelso School District 530000300590 2691 Catlin Elementary   Regular School No Elementary KG 05 2018   grade_2 39 1 9   0 0     4   6   35 24 0   7   1   45       2.0 59 39 1 9   0 0     4   6   35 24 0   7 1 45     2 59
2462872 WA Cowlitz   school 5300003 8458   Kelso School District 530000300590 2691 Catlin Elementary   Regular School No Elementary KG 05 2018   grade_3 50 1 8   0 0     0   5   34 30 0   4   1   47       1.0 64 50 1 8   0 0     0   5   34 30 0   4 1 47     1 64
2462873 WA Cowlitz   school 5300003 8458   Kelso School District 530000300590 2691 Catlin Elementary   Regular School No Elementary KG 05 2018   grade_4 42 1 8   0 0     0   3   30 24 0   1   4   42       1.0 54 42 1 8   0 0     0   3   30 24 0   1 4 42     1 54
2462874 WA Cowlitz   school 5300003 8458   Kelso School District 530000300590 2691 Catlin Elementary   Regular School No Elementary KG 05 2018   grade_5 40 0 10   1 0     2   3   32 24 0   2   4   47       1.0 56 40 0 10   1 0     2   3   32 24 0   2 4 47     1 56
2462875 WA Cowlitz   school 5300003 8458   Kelso School District 530000300590 2691 Catlin Elementary   Regular School No Elementary KG 05 2018   pk_12_total 273 3 60   2 1     8   26   206 167 0   25   18   291       5.0 373 273 3 60   2 1     8   26   206 167 0   25 18 291     5 373
2462876 WA Cowlitz   school 5300003 8458   Kelso School District 530000300590 2691 Catlin Elementary   Regular School No Elementary KG 05 2018   kindergarten 44 0 8   0 0     1   4   28 29 0   6   4   46       0.0 57 44 0 8   0 0     1   4   28 29 0   6 4 46     0 57
2462877 WA Cowlitz   school 5300003 8458   Kelso School District 530000300590 2691 Catlin Elementary   Regular School No Elementary KG 05 2018   pre_kindergarten 11 0 5   0 1     0   2   14 5 0   0   0   15       0.0 19 11 0 5   0 1     0   2   14 5 0   0 0 15     0 19
2462878 WA Cowlitz   school 5300003 8458   Kelso School District 530000300591 3322 Coweeman Middle School   Regular School No Middle 06 08 2018   grade_6 132 1 35   3 0     3   9   104 79 0   10   6   117       8.0 183 132 1 35   3 0     3   9   104 79 0   10 6 117     8 183
2462879 WA Cowlitz   school 5300003 8458   Kelso School District 530000300591 3322 Coweeman Middle School   Regular School No Middle 06 08 2018   grade_7 142 1 43   3 2     2   10   113 90 0   13   5   128       6.0 203 142 1 43   3 2     2   10   113 90 0   13 5 128     6 203
2462880 WA Cowlitz   school 5300003 8458   Kelso School District 530000300591 3322 Coweeman Middle School   Regular School No Middle 06 08 2018   grade_8 147 1 33   4 2     0   9   91 105 0   8   4   101       6.0 196 147 1 33   4 2     0   9   91 105 0   8 4 101     6 196
2462881 WA Cowlitz   school 5300003 8458   Kelso School District 530000300591 3322 Coweeman Middle School   Regular School No Middle 06 08 2018   pk_12_total 421 3 111   10 4     5   28   308 274 0   31   15   346       20.0 582 421 3 111   10 4     5   28   308 274 0   31 15 346     20 582
2462882 WA Cowlitz   school 5300003 8458   Kelso School District 530000300592 2916 Huntington Middle School   Regular School No Middle 06 08 2018   grade_6 122 1 42   1 0     2   15   86 97 0   10   5   126       9.0 183 122 1 42   1 0     2   15   86 97 0   10 5 126     9 183
2462883 WA Cowlitz   school 5300003 8458   Kelso School District 530000300592 2916 Huntington Middle School   Regular School No Middle 06 08 2018   grade_7 144 0 44   0 0     4   14   102 104 0   17   2   133       7.0 206 144 0 44   0 0     4   14   102 104 0   17 2 133     7 206
2462884 WA Cowlitz   school 5300003 8458   Kelso School District 530000300592 2916 Huntington Middle School   Regular School No Middle 06 08 2018   grade_8 113 0 35   0 2     1   5   82 74 0   7   0   104       8.0 156 113 0 35   0 2     1   5   82 74 0   7 0 104     8 156
2462885 WA Cowlitz   school 5300003 8458   Kelso School District 530000300592 2916 Huntington Middle School   Regular School No Middle 06 08 2018   pk_12_total 379 1 121   1 2     7   34   270 275 0   34   7   363       24.0 545 379 1 121   1 2     7   34   270 275 0   34 7 363     24 545
2462886 WA Cowlitz   school 5300003 8458   Kelso School District 530000300593 2266 Kelso High School   Regular School No High 09 12 2018   grade_10 279 1 56   10 2     6   24   183 195 0   20   10   201       15.0 378 279 1 56   10 2     6   24   183 195 0   20 10 201     15 378
2462887 WA Cowlitz   school 5300003 8458   Kelso School District 530000300593 2266 Kelso High School   Regular School No High 09 12 2018   grade_11 280 1 58   8 5     2   30   208 176 0   14   6   204       20.0 384 280 1 58   8 5     2   30   208 176 0   14 6 204     20 384
2462888 WA Cowlitz   school 5300003 8458   Kelso School District 530000300593 2266 Kelso High School   Regular School No High 09 12 2018   grade_12 368 5 79   7 5     2   32   259 239 0   16   19   267       20.0 498 368 5 79   7 5     2   32   259 239 0   16 19 267     20 498
2462889 WA Cowlitz   school 5300003 8458   Kelso School District 530000300593 2266 Kelso High School   Regular School No High 09 12 2018   grade_9 291 1 62   8 4     6   23   203 192 0   18   7   217       15.0 395 291 1 62   8 4     6   23   203 192 0   18 7 217     15 395
2462890 WA Cowlitz   school 5300003 8458   Kelso School District 530000300593 2266 Kelso High School   Regular School No High 09 12 2018   pk_12_total 1218 8 255   33 16     16   109   853 802 0   68   42   889       70.0 1655 1218 8 255   33 16     16   109   853 802 0   68 42 889     70 1655
2462900 WA Cowlitz   school 5300003 8458   Kelso School District 530000300594 2596 Rose Valley Elementary   Regular School No Elementary KG 05 2018   grade_1 29 0 3   0 0     0   0   21 11 0   1   2   10       1.0 32 29 0 3   0 0     0   0   21 11 0   1 2 10     1 32
2462901 WA Cowlitz   school 5300003 8458   Kelso School District 530000300594 2596 Rose Valley Elementary   Regular School No Elementary KG 05 2018   grade_2 20 0 2   0 0     1   0   9 14 0   0   0   7       1.0 23 20 0 2   0 0     1   0   9 14 0   0 0 7     1 23
2462902 WA Cowlitz   school 5300003 8458   Kelso School District 530000300594 2596 Rose Valley Elementary   Regular School No Elementary KG 05 2018   grade_3 24 1 1   0 0     0   1   16 11 0   1   0   10       0.0 27 24 1 1   0 0     0   1   16 11 0   1 0 10     0 27
2462903 WA Cowlitz   school 5300003 8458   Kelso School District 530000300594 2596 Rose Valley Elementary   Regular School No Elementary KG 05 2018   grade_4 19 2 3   1 0     0   0   9 16 0   1   0   9       2.0 25 19 2 3   1 0     0   0   9 16 0   1 0 9     2 25
2462904 WA Cowlitz   school 5300003 8458   Kelso School District 530000300594 2596 Rose Valley Elementary   Regular School No Elementary KG 05 2018   grade_5 18 0 2   0 0     0   0   8 12 0   0   0   6       2.0 20 18 0 2   0 0     0   0   8 12 0   0 0 6     2 20
2462905 WA Cowlitz   school 5300003 8458   Kelso School District 530000300594 2596 Rose Valley Elementary   Regular School No Elementary KG 05 2018   pk_12_total 127 3 11   1 0     2   1   72 73 0   3   2   45       6.0 145 127 3 11   1 0     2   1   72 73 0   3 2 45     6 145
2462906 WA Cowlitz   school 5300003 8458   Kelso School District 530000300594 2596 Rose Valley Elementary   Regular School No Elementary KG 05 2018   kindergarten 17 0 0   0 0     1   0   9 9 0   0   0   3       0.0 18 17 0 0   0 0     1   0   9 9 0   0 0 3     0 18
2462910 WA Cowlitz   school 5300003 8458   Kelso School District 530000300596 2624 Wallace Elementary   Regular School No Elementary KG 05 2018   grade_1 34 1 15   1 1     3   1   34 22 0   12   4   53       1.0 56 34 1 15   1 1     3   1   34 22 0   12 4 53     1 56
2462911 WA Cowlitz   school 5300003 8458   Kelso School District 530000300596 2624 Wallace Elementary   Regular School No Elementary KG 05 2018   grade_2 37 1 11   0 1     1   3   22 32 0   13   4   46       0.0 54 37 1 11   0 1     1   3   22 32 0   13 4 46     0 54
2462912 WA Cowlitz   school 5300003 8458   Kelso School District 530000300596 2624 Wallace Elementary   Regular School No Elementary KG 05 2018   grade_3 33 0 19   0 0     3   1   30 26 0   12   2   49       2.0 56 33 0 19   0 0     3   1   30 26 0   12 2 49     2 56
2462913 WA Cowlitz   school 5300003 8458   Kelso School District 530000300596 2624 Wallace Elementary   Regular School No Elementary KG 05 2018   grade_4 30 0 23   0 0     3   4   32 28 0   14   1   55       0.0 60 30 0 23   0 0     3   4   32 28 0   14 1 55     0 60
2462914 WA Cowlitz   school 5300003 8458   Kelso School District 530000300596 2624 Wallace Elementary   Regular School No Elementary KG 05 2018   grade_5 41 0 21   0 0     3   1   36 30 0   9   5   60       3.0 66 41 0 21   0 0     3   1   36 30 0   9 5 60     3 66
2462915 WA Cowlitz   school 5300003 8458   Kelso School District 530000300596 2624 Wallace Elementary   Regular School No Elementary KG 05 2018   pk_12_total 209 2 110   1 3     16   11   185 167 0   73   20   316       6.0 352 209 2 110   1 3     16   11   185 167 0   73 20 316     6 352
2462916 WA Cowlitz   school 5300003 8458   Kelso School District 530000300596 2624 Wallace Elementary   Regular School No Elementary KG 05 2018   kindergarten 34 0 21   0 1     3   1   31 29 0   13   4   53       0.0 60 34 0 21   0 1     3   1   31 29 0   13 4 53     0 60
2462907 WA Cowlitz   school 5300003 8458   Kelso School District 530000303076 5076 Special Education   Special Education School No Other PK 12 2018   grade_12 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
2462908 WA Cowlitz   school 5300003 8458   Kelso School District 530000303076 5076 Special Education   Special Education School No Other PK 12 2018   pk_12_total 37 0 10   0 0     1   6   31 23 0   0   0   29       0.0 54 37 0 10   0 0     1   6   31 23 0   0 0 29     0 54
2462909 WA Cowlitz   school 5300003 8458   Kelso School District 530000303076 5076 Special Education   Special Education School No Other PK 12 2018   pre_kindergarten 36 0 10   0 0     1   6   30 23 0   0   0   28       0.0 53 36 0 10   0 0     1   6   30 23 0   0 0 28     0 53
2462897 WA Cowlitz   school 5300003 8458   Kelso School District 530000303109 1934 Loowit High School   Alternative School No High 09 12 2018   grade_11 3 0 2   0 0     0   0   3 2 0   0   0   3       1.0 5 3 0 2   0 0     0   0   3 2 0   0 0 3     1 5
2462898 WA Cowlitz   school 5300003 8458   Kelso School District 530000303109 1934 Loowit High School   Alternative School No High 09 12 2018   grade_12 12 0 1   0 0     0   0   2 11 0   0   4   8       2.0 13 12 0 1   0 0     0   0   2 11 0   0 4 8     2 13
2462899 WA Cowlitz   school 5300003 8458   Kelso School District 530000303109 1934 Loowit High School   Alternative School No High 09 12 2018   pk_12_total 15 0 3   0 0     0   0   5 13 0   0   4   11       3.0 18 15 0 3   0 0     0   0   5 13 0   0 4 11     3 18
2462891 WA Cowlitz   school 5300003 8458   Kelso School District 530000303314 5194 Kelso Virtual Academy   Regular School No High 08 12 2018   grade_10 6 0 1   0 0     0   0   4 3 0   0   0   1       1.0 7 6 0 1   0 0     0   0   4 3 0   0 0 1     1 7
2462892 WA Cowlitz   school 5300003 8458   Kelso School District 530000303314 5194 Kelso Virtual Academy   Regular School No High 08 12 2018   grade_11 3 0 5   0 0     1   0   2 7 0   1   0   6       0.0 9 3 0 5   0 0     1   0   2 7 0   1 0 6     0 9
2462893 WA Cowlitz   school 5300003 8458   Kelso School District 530000303314 5194 Kelso Virtual Academy   Regular School No High 08 12 2018   grade_12 13 0 1   0 0     0   1   3 12 0   0   0   9       0.0 15 13 0 1   0 0     0   1   3 12 0   0 0 9     0 15
2462894 WA Cowlitz   school 5300003 8458   Kelso School District 530000303314 5194 Kelso Virtual Academy   Regular School No High 08 12 2018   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
2462895 WA Cowlitz   school 5300003 8458   Kelso School District 530000303314 5194 Kelso Virtual Academy   Regular School No High 08 12 2018   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
2462896 WA Cowlitz   school 5300003 8458   Kelso School District 530000303314 5194 Kelso Virtual Academy   Regular School No High 08 12 2018   pk_12_total 24 0 7   0 0     1   1   10 23 0   1   0   16       1.0 33 24 0 7   0 0     1   1   10 23 0   1 0 16     1 33
2461088 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 2018   grade_10 5 0 1   0 0     0   0   3 3 0   0   0   0       0.0 6 5 0 1   0 0     0   0   3 3 0   0 0 0     0 6
2461089 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 2018   grade_11 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
2461090 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 2018   grade_12 3 0 1   0 0     0   2   3 3 0   0   0   0       0.0 6 3 0 1   0 0     0   2   3 3 0   0 0 0     0 6
2461091 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 2018   grade_8 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
2461092 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 2018   grade_9 3 0 2   1 0     0   0   3 3 0   0   0   0       0.0 6 3 0 2   1 0     0   0   3 3 0   0 0 0     0 6
2461093 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 2018   pk_12_total 19 0 6   1 0     0   2   16 12 0   0   0   0       0.0 28 19 0 6   1 0     0   2   16 12 0   0 0 0     0 28
2461082 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 2018   grade_10 3 0 0   0 0     0   2   4 1 0   0   0   0       0.0 5 3 0 0   0 0     0   2   4 1 0   0 0 0     0 5
2461083 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 2018   grade_11 3 0 0   0 0     0   0   1 2 0   0   0   0       0.0 3 3 0 0   0 0     0   0   1 2 0   0 0 0     0 3
2461084 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 2018   grade_12 1 1 1   0 0     0   0   2 1 0   0   0   0       0.0 3 1 1 1   0 0     0   0   2 1 0   0 0 0     0 3
2461085 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 2018   grade_8 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
2461086 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 2018   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
2461087 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 2018   pk_12_total 8 1 2   0 0     0   2   9 4 0   0   0   0       0.0 13 8 1 2   0 0     0   2   9 4 0   0 0 0     0 13
2461094 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 2018   grade_11 10 0 1   0 1     0   2   10 4 0   0   0   0       0.0 14 10 0 1   0 1     0   2   10 4 0   0 0 0     0 14
2461095 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 2018   grade_12 71 2 15   1 0     1   8   57 41 0   0   0   0       0.0 98 71 2 15   1 0     1   8   57 41 0   0 0 0     0 98
2461096 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 2018   pk_12_total 81 2 16   1 1     1   10   67 45 0   0   0   0       0.0 112 81 2 16   1 1     1   10   67 45 0   0 0 0     0 112
2461102 WA Kitsap   school 5300007 18801   ESD 114 acting as a school district 530000702914 3143 Clallam Co Juvenile Detention   Regular School No High 08 12 2018   grade_10 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
2461103 WA Kitsap   school 5300007 18801   ESD 114 acting as a school district 530000702914 3143 Clallam Co Juvenile Detention   Regular School No High 08 12 2018   grade_11 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
2461104 WA Kitsap   school 5300007 18801   ESD 114 acting as a school district 530000702914 3143 Clallam Co Juvenile Detention   Regular School No High 08 12 2018   grade_12 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
2461105 WA Kitsap   school 5300007 18801   ESD 114 acting as a school district 530000702914 3143 Clallam Co Juvenile Detention   Regular School No High 08 12 2018   grade_8 0 0 0   0 0     0   1   1 0 0   0   0   1       0.0 1 0 0 0   0 0     0   1   1 0 0   0 0 1     0 1
2461106 WA Kitsap   school 5300007 18801   ESD 114 acting as a school district 530000702914 3143 Clallam Co Juvenile Detention   Regular School No High 08 12 2018   grade_9 2 0 0   0 0     0   0   2 0 0   0   0   1       0.0 2 2 0 0   0 0     0   0   2 0 0   0 0 1     0 2
2461107 WA Kitsap   school 5300007 18801   ESD 114 acting as a school district 530000702914 3143 Clallam Co Juvenile Detention   Regular School No High 08 12 2018   pk_12_total 6 0 0   1 0     0   1   7 1 0   0   0   7       0.0 8 6 0 0   1 0     0   1   7 1 0   0 0 7     0 8
2461108 WA Kitsap   school 5300007 18801   ESD 114 acting as a school district 530000702927 3481 Kitsap Co Detention Ctr   Regular School No High 08 12 2018   grade_10 3 1 1   0 0     0   0   3 2 0   0   0   4       0.0 5 3 1 1   0 0     0   0   3 2 0   0 0 4     0 5
2461109 WA Kitsap   school 5300007 18801   ESD 114 acting as a school district 530000702927 3481 Kitsap Co Detention Ctr   Regular School No High 08 12 2018   grade_11 3 0 0   0 0     1   0   3 1 0   0   0   1       0.0 4 3 0 0   0 0     1   0   3 1 0   0 0 1     0 4
2461110 WA Kitsap   school 5300007 18801   ESD 114 acting as a school district 530000702927 3481 Kitsap Co Detention Ctr   Regular School No High 08 12 2018   grade_12 3 1 1   0 0     0   1   6 0 0   0   0   5       0.0 6 3 1 1   0 0     0   1   6 0 0   0 0 5     0 6
2461111 WA Kitsap   school 5300007 18801   ESD 114 acting as a school district 530000702927 3481 Kitsap Co Detention Ctr   Regular School No High 08 12 2018   grade_9 4 0 0   0 0     0   0   3 1 0   0   0   3       0.0 4 4 0 0   0 0     0   0   3 1 0   0 0 3     0 4
2461112 WA Kitsap   school 5300007 18801   ESD 114 acting as a school district 530000702927 3481 Kitsap Co Detention Ctr   Regular School No High 08 12 2018   pk_12_total 13 2 2   0 0     1   1   15 4 0   0   0   13       0.0 19 13 2 2   0 0     1   1   15 4 0   0 0 13     0 19
2461119 WA Skagit   school 5300008 29801   ESD 189 acting as a school district 530000802921 3363 Skagit County Detention Center   Regular School No High 08 12 2018   grade_10 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
2461120 WA Skagit   school 5300008 29801   ESD 189 acting as a school district 530000802921 3363 Skagit County Detention Center   Regular School No High 08 12 2018   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
2461121 WA Skagit   school 5300008 29801   ESD 189 acting as a school district 530000802921 3363 Skagit County Detention Center   Regular School No High 08 12 2018   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
2461122 WA Skagit   school 5300008 29801   ESD 189 acting as a school district 530000802921 3363 Skagit County Detention Center   Regular School No High 08 12 2018   grade_9 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
2461123 WA Skagit   school 5300008 29801   ESD 189 acting as a school district 530000802921 3363 Skagit County Detention Center   Regular School No High 08 12 2018   pk_12_total 4 0 3   0 0     0   0   5 2 0   0   0   0       0.0 7 4 0 3   0 0     0   0   5 2 0   0 0 0     0 7
2461124 WA Skagit   school 5300008 29801   ESD 189 acting as a school district 530000802923 3420 Whatcom Co Detention Center   Regular School No High 08 12 2018   grade_10 1 0 0   0 0     0   0   0 1 0   0   0   0       0.0 1 1 0 0   0 0     0   0   0 1 0   0 0 0     0 1
2461125 WA Skagit   school 5300008 29801   ESD 189 acting as a school district 530000802923 3420 Whatcom Co Detention Center   Regular School No High 08 12 2018   grade_11 0 1 0   0 0     0   0   1 0 0   0   0   0       0.0 1 0 1 0   0 0     0   0   1 0 0   0 0 0     0 1
2461126 WA Skagit   school 5300008 29801   ESD 189 acting as a school district 530000802923 3420 Whatcom Co Detention Center   Regular School No High 08 12 2018   grade_12 1 1 0   1 0     0   0   3 0 0   0   0   0       0.0 3 1 1 0   1 0     0   0   3 0 0   0 0 0     0 3
2461127 WA Skagit   school 5300008 29801   ESD 189 acting as a school district 530000802923 3420 Whatcom Co Detention Center   Regular School No High 08 12 2018   grade_8 0 0 1   0 0     0   0   0 1 0   0   0   0       0.0 1 0 0 1   0 0     0   0   0 1 0   0 0 0     0 1
2461128 WA Skagit   school 5300008 29801   ESD 189 acting as a school district 530000802923 3420 Whatcom Co Detention Center   Regular School No High 08 12 2018   pk_12_total 2 2 1   1 0     0   0   4 2 0   0   0   0       0.0 6 2 2 1   1 0     0   0   4 2 0   0 0 0     0 6
2461116 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 2018   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
2461117 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 2018   grade_12 0 0 0   0 0     0   0   0 1 0   0   0   0       0.0 1 0 0 0   0 0     0   0   0 1 0   0 0 0     0 1
2461118 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 2018   pk_12_total 1 0 0   0 0     0   0   1 1 0   0   0   0       0.0 2 1 0 0   0 0     0   0   1 1 0   0 0 0     0 2
2461065 WA Spokane   school 5300010 32801   ESD 101 acting as a school district 530001002919 3352 Martin Hall Detention Ctr   Regular School No High 08 12 2018   grade_11 6 0 1   2 0     0   0   7 2 0   0   0   5       0.0 9 6 0 1   2 0     0   0   7 2 0   0 0 5     0 9
2461066 WA Spokane   school 5300010 32801   ESD 101 acting as a school district 530001002919 3352 Martin Hall Detention Ctr   Regular School No High 08 12 2018   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
2461067 WA Spokane   school 5300010 32801   ESD 101 acting as a school district 530001002919 3352 Martin Hall Detention Ctr   Regular School No High 08 12 2018   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
2461068 WA Spokane   school 5300010 32801   ESD 101 acting as a school district 530001002919 3352 Martin Hall Detention Ctr   Regular School No High 08 12 2018   grade_9 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
2461069 WA Spokane   school 5300010 32801   ESD 101 acting as a school district 530001002919 3352 Martin Hall Detention Ctr   Regular School No High 08 12 2018   pk_12_total 9 0 2   2 0     0   0   11 2 0   0   0   8       0.0 13 9 0 2   2 0     0   0   11 2 0   0 0 8     0 13

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