enrollments

Data source: Big Local News · About: Big Local

650 rows where grade = "grade_7", state = "WA" and year = 2019 sorted by school_nces_id

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2019 · 650 ✖

grade ✖

  • grade_7 · 650 ✖
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
2416471 2416471 WA King   school 5300001 17216   Enumclaw School District 530000102054 4210 Enumclaw Middle School   Regular School No Middle 06 08 2019   grade_7 109 0 26   3 1     1   6   70 76 0   10   6   62       7.0 146 109 0 26   3 1     1   6   70 76 0   10 6 62     7 146
2416504 2416504 WA King   school 5300001 17216   Enumclaw School District 530000102795 4550 Thunder Mountain Middle School   Regular School No Middle 06 08 2019   grade_7 110 2 37   4 3     0   5   88 73 0   9   3   36       4.0 161 110 2 37   4 3     0   5   88 73 0   9 3 36     4 161
2418129 2418129 WA Ferry   school 5300002 10070   Inchelium School District 530000202870 4214 Inchelium Middle School   Regular School No Middle 06 08 2019   grade_7 0 0 0   15 0     0   5   9 11 0   11   0   17       0.0 20 0 0 0   15 0     0   5   9 11 0   11 0 17     0 20
2418389 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
2418393 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
2416584 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
2416578 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
2416613 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
2427642 2427642 WA Thurston   school 5300015 34975   Washington Center for Deaf and Hard of Hearing Youth 530001501016 4246 Washington State School for the Deaf   Regular School No Other PK 12 2019   grade_7 4 3 5   1 2     1   0   6 10 0   0   1   11       0.0 16 4 3 5   1 2     1   0   6 10 0   0 1 11     0 16
2412998 2412998 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000001 2834 A J West Elementary   Regular School No Elementary PK 06 2019   grade_7 0 0 1   0 0     0   0   1 0 0   1   0   1       0.0 1 0 0 1   0 0     0   0   1 0 0   1 0 1     0 1
2413043 2413043 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000009 2305 Miller Junior High   Regular School No Middle 07 08 2019   grade_7 132 5 79   13 6     0   24   122 137 0   25   10   176       8.0 259 132 5 79   13 6     0   24   122 137 0   25 10 176     8 259
2413013 2413013 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003003633 5514 Grays Harbor Academy   Alternative School No Other 03 12 2019   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
2413078 2413078 WA Lewis   school 5300060 21226   Adna School District 530006000013 2441 Adna Middle/High School   Regular School No High 06 12 2019   grade_7 47 0 4   0 1     0   1   25 28 0   0   0   16       2.0 53 47 0 4   0 1     0   1   25 28 0   0 0 16     2 53
2413088 2413088 WA Lincoln   school 5300090 22017   Almira School District 530009000179 2860 Almira Elementary School   Regular School No Elementary PK 08 2019   grade_7 17 0 2   0 0     0   4   7 16 0   0   0   10       0.0 23 17 0 2   0 0     0   4   7 16 0   0 0 10     0 23
2413099 2413099 WA Skagit   school 5300150 29103   Anacortes School District 530015000015 2707 Anacortes Middle School   Regular School No Middle 06 08 2019   grade_7 158 2 26   1 11     0   9   115 92 0   3   2   57       15.0 207 158 2 26   1 11     0   9   115 92 0   3 2 57     15 207
2413175 2413175 WA Snohomish   school 5300240 31016   Arlington School District 530024000024 3124 Post Middle School   Regular School No Middle 06 08 2019   grade_7 140 1 29   1 1     2   16   110 80 0   14   4   76       9.0 190 140 1 29   1 1     2   16   110 80 0   14 4 76     9 190
2413192 2413192 WA Snohomish   school 5300240 31016   Arlington School District 530024002589 1714 Stillaguamish Valley Learning Center   Alternative School No Elementary KG 08 2019   grade_7 14 0 1   0 0     0   1   8 8 0   0   0   3       2.0 16 14 0 1   0 0     0   1   8 8 0   0 0 3     2 16
2413155 2413155 WA Snohomish   school 5300240 31016   Arlington School District 530024003008 5010 Haller Middle School   Regular School No Middle 06 08 2019   grade_7 150 4 40   4 1     0   15   109 105 0   10   1   73       11.0 214 150 4 40   4 1     0   15   109 105 0   10 1 73     11 214
2413213 2413213 WA Asotin   school 5300280 2420   Asotin-Anatone School District 530028000028 2434 Asotin Jr Sr High   Regular School No High 06 12 2019   grade_7 42 1 1   0 0     0   3   22 25 0   0   0   14       3.0 47 42 1 1   0 0     0   3   22 25 0   0 0 14     3 47
2413253 2413253 WA King   school 5300300 17408   Auburn School District 530030000033 2394 Cascade Middle School   Regular School No Middle 06 08 2019   grade_7 109 32 82   1 24     13   27   148 140 0   43   9   189       8.0 288 109 32 82   1 24     13   27   148 140 0   43 9 189     8 288
2413331 2413331 WA King   school 5300300 17408   Auburn School District 530030000038 3169 Olympic Middle School   Regular School No Middle 06 08 2019   grade_7 69 17 108   9 27     23   41   166 128 0   51   4   219       4.0 294 69 17 108   9 27     23   41   166 128 0   51 4 219     4 294
2413327 2413327 WA King   school 5300300 17408   Auburn School District 530030001443 4462 Mt Baker Middle School   Regular School No Middle 06 08 2019   grade_7 104 12 108   0 33     21   40   162 156 0   50   5   159       7.0 318 104 12 108   0 33     21   40   162 156 0   50 5 159     7 318
2413343 2413343 WA King   school 5300300 17408   Auburn School District 530030002434 4385 Rainier Middle School   Regular School No Middle 06 08 2019   grade_7 140 36 87   1 33     10   24   162 169 0   51   2   180       15.0 331 140 36 87   1 33     10   24   162 169 0   51 2 180     15 331
2413352 2413352 WA King   school 5300300 17408   Auburn School District 530030002904 1915 Special Ed School   Special Education School No Other PK 12 2019   grade_7 3 1 0   0 0     0   0   3 1 0   0   0   2       0.0 4 3 1 0   0 0     0   0   3 1 0   0 0 2     0 4
2421868 2421868 WA Thurston   school 5300318 34974   Office of the Governor (Sch for Blind) 530031802385 3799 Washington State School for the Blind   Regular School No High 06 12 2019   grade_7 4 0 2   2 0     0   0   5 3 0   1   0   7       0.0 8 4 0 2   2 0     0   0   5 3 0   1 0 7     0 8
2426254 2426254 WA Kitsap   school 5300328 18902   Suquamish Tribal Education Department 530032803493 5319 Chief Kitsap Academy   Regular School No Other KG 12 2019   grade_7 1 0 0   3 0     0   0   3 1 0   0   0   3       0.0 4 1 0 0   3 0     0   0   3 1 0   0 0 3     0 4
2413442 2413442 WA Kitsap   school 5300330 18303   Bainbridge Island School District 530033002452 4505 Woodward Middle School   Regular School No Middle 07 08 2019   grade_7 208 4 19   1 6     1   21   136 124 0   2   0   23       46.0 260 208 4 19   1 6     1   21   136 124 0   2 0 23     46 260
2413427 2413427 WA Kitsap   school 5300330 18303   Bainbridge Island School District 530033002523 1699 Odyssey Multiage Program   Regular School No Elementary KG 08 2019   grade_7 9 0 0   0 1     0   0   6 4 0   0   0   1       4.0 10 9 0 0   0 1     0   0   6 4 0   0 0 1     4 10
2413417 2413417 WA Kitsap   school 5300330 18303   Bainbridge Island School District 530033002802 1841 Mosaic Home Education Partnership   Alternative School No Elementary KG 08 2019   grade_7 6 0 0   0 0     0   0   4 2 0   0   0   1       1.0 6 6 0 0   0 0     0   0   4 2 0   0 0 1     1 6
2413388 2413388 WA Kitsap   school 5300330 18303   Bainbridge Island School District 530033003113 1939 Bainbridge Special Education Services   Special Education School No Other PK 12 2019   grade_7 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
2417081 2417081 WA King   school 5300332 17906   Excel Public Charter School 530033203536 5377 Excel Public Charter School (Closed after 2018-2019 school year)   Regular School Yes Secondary 07 10 2019   grade_7 7 19 4   0 3     1   4   23 15 0   3   2   29       0.0 38 7 19 4   0 3     1   4   23 15 0   3 2 29     0 38
2423214 2423214 WA King   school 5300335 17908   Rainier Prep Charter School District 530033503533 5380 Rainier Prep   Regular School Yes Middle 05 08 2019   grade_7 4 30 39   0 3     0   5   40 41 0   29   1   67       2.0 81 4 30 39   0 3     0   5   40 41 0   29 1 67     2 81
2425413 2425413 WA Spokane   school 5300337 32901   Spokane International Academy 530033703539 5381 Spokane International Academy   Regular School Yes Elementary KG 08 2019   grade_7 57 1 12   1 2     0   9   32 50 0   2   0   30       9.0 82 57 1 12   1 2     0   9   32 50 0   2 0 30     9 82
2417773 2417773 WA Pierce   school 5300338 27904   Green Dot Destiny 530033803553 5378 Destiny Charter Middle School (Closed after 2018-2019 school year)   Regular School Yes Middle 06 08 2019   grade_7 17 16 5   0 0     4   7   24 25 0   6   9   45       2.0 49 17 16 5   0 0     4   7   24 25 0   6 9 45     2 49
2422761 2422761 WA Spokane   school 5300339 32907   PRIDE Prep Charter School District 530033903495 5339 PRIDE Prep School   Regular School Yes High 06 12 2019   grade_7 77 12 0   8 5     1   0   58 45 0   0   1   55       10.0 103 77 12 0   8 5     1   0   58 45 0   0 1 55     10 103
2423235 2423235 WA King   school 5300342 17910   Rainier Valley Leadership Academy 530034203602 5468 Rainier Valley Leadership Academy   Regular School Yes Middle 06 09 2019   grade_7 11 83 10   0 5     0   4   52 61 0   22   4   85       1.0 113 11 83 10   0 5     0   4   52 61 0   22 4 85     1 113
2426076 2426076 WA King   school 5300343 17905   Summit Public School: Atlas 530034303611 5469 Summit Public School: Atlas   Regular School Yes High 06 12 2019   grade_7 52 33 19   1 4     0   11   68 52 0   8   0   47       4.0 120 52 33 19   1 4     0   11   68 52 0   8 0 47     4 120
2418143 2418143 WA Walla Walla   school 5300344 36901   Innovation Schools 530034403636 5470 Innovation Schools   Regular School Yes Middle 06 08 2019   grade_7 24 0 16   0 1     0   2   19 24 0   5   0   25       0.0 43 24 0 16   0 1     0   2   19 24 0   5 0 25     0 43
2413451 2413451 WA Clark   school 5300380 6119   Battle Ground School District 530038000048 2671 Amboy Middle School   Regular School No Middle 05 08 2019   grade_7 121 0 0   1 0     0   3   60 65 0   0   2   40       7.0 125 121 0 0   1 0     0   3   60 65 0   0 2 40     7 125
2413522 2413522 WA Clark   school 5300380 6119   Battle Ground School District 530038000052 3545 Laurin Middle School   Regular School No Middle 05 08 2019   grade_7 145 3 19   0 5     1   6   94 85 0   16   2   60       8.0 179 145 3 19   0 5     1   6   94 85 0   16 2 60     8 179
2413540 2413540 WA Clark   school 5300380 6119   Battle Ground School District 530038000054 3997 Pleasant Valley Middle   Regular School No Middle 05 08 2019   grade_7 79 3 23   1 9     4   13   66 66 0   9   4   53       10.0 132 79 3 23   1 9     4   13   66 66 0   9 4 53     10 132
2413466 2413466 WA Clark   school 5300380 6119   Battle Ground School District 530038002782 1836 CAM Academy   Alternative School No Other 03 12 2019   grade_7 47 0 4   0 3     0   4   25 33 0   0   0   11       1.0 58 47 0 4   0 3     0   4   25 33 0   0 0 11     1 58
2413515 2413515 WA Clark   school 5300380 6119   Battle Ground School District 530038002857 1875 Homelink River   Alternative School No Other KG 12 2019   grade_7 68 1 3   0 0     0   6   35 43 0   0   0   21       4.0 78 68 1 3   0 0     0   6   35 43 0   0 0 21     4 78
2413484 2413484 WA Clark   school 5300380 6119   Battle Ground School District 530038003176 5089 Daybreak Middle   Regular School No Middle 05 08 2019   grade_7 88 2 14   1 4     0   6   58 57 0   8   2   49       6.0 115 88 2 14   1 4     0   6   58 57 0   8 2 49     6 115
2413563 2413563 WA Clark   school 5300380 6119   Battle Ground School District 530038003214 5131 Tukes Valley Middle School   Regular School No Middle 05 08 2019   grade_7 92 0 15   0 0     0   8   61 54 0   2   0   31       4.0 115 92 0 15   0 0     0   8   61 54 0   2 0 31     4 115
2413479 2413479 WA Clark   school 5300380 6119   Battle Ground School District 530038003262 5133 Chief Umtuch Middle   Regular School No Middle 05 08 2019   grade_7 120 2 14   0 0     0   10   86 60 0   7   5   53       9.0 146 120 2 14   0 0     0   10   86 60 0   7 5 53     9 146
2413531 2413531 WA Clark   school 5300380 6119   Battle Ground School District 530038003409 5291 Maple Grove K-8 (Closed after 2018-2019 school year)   Regular School No Elementary PK 08 2019   grade_7 39 0 11   2 0     0   2   30 24 0   5   2   25       3.0 54 39 0 11   2 0     0   2   30 24 0   5 2 25     3 54
2413634 2413634 WA King   school 5300390 17405   Bellevue School District 530039000064 3338 Chinook Middle School   Regular School No Middle 06 08 2019   grade_7 147 11 24   0 96     0   35   149 164 0   23   1   37       26.0 313 147 11 24   0 96     0   35   149 164 0   23 1 37     26 313
2413662 2413662 WA King   school 5300390 17405   Bellevue School District 530039000068 3166 Highland Middle School   Regular School No Middle 06 08 2019   grade_7 42 14 45   0 27     2   10   77 63 0   33   7   73       11.0 140 42 14 45   0 27     2   10   77 63 0   33 7 73     11 140
2413716 2413716 WA King   school 5300390 17405   Bellevue School District 530039000079 3631 Odle Middle School   Regular School No Middle 06 08 2019   grade_7 80 6 44   0 203     1   31   190 175 0   28   2   70       16.0 365 80 6 44   0 203     1   31   190 175 0   28 2 70     16 365
2413772 2413772 WA King   school 5300390 17405   Bellevue School District 530039000093 3435 Tillicum Middle School   Regular School No Middle 06 08 2019   grade_7 124 4 40   1 62     2   28   134 127 0   15   3   33       22.0 261 124 4 40   1 62     2   28   134 127 0   15 3 33     22 261
2413776 2413776 WA King   school 5300390 17405   Bellevue School District 530039000094 3283 Tyee Middle School   Regular School No Middle 06 08 2019   grade_7 91 3 20   0 185     1   32   180 152 0   17   3   33       23.0 332 91 3 20   0 185     1   32   180 152 0   17 3 33     23 332
2413674 2413674 WA King   school 5300390 17405   Bellevue School District 530039003149 3522 International School   Alternative School No High 06 12 2019   grade_7 32 1 5   0 43     0   10   45 46 0   2   0   7       8.0 91 32 1 5   0 43     0   10   45 46 0   2 0 7     8 91
2413592 2413592 WA King   school 5300390 17405   Bellevue School District 530039003354 5240 Bellevue Big Picture School   Alternative School No High 06 12 2019   grade_7 31 4 10   1 20     0   13   43 36 0   5   2   19       11.0 79 31 4 10   1 20     0   13   43 36 0   5 2 19     11 79
2413620 2413620 WA King   school 5300390 17405   Bellevue School District 530039003434 5281 Central Educational Services   Regular School No Other PK 12 2019   grade_7 3 0 1   0 0     0   0   2 2 0   1   0   1       0.0 4 3 0 1   0 0     0   0   2 2 0   1 0 1     0 4
2413856 2413856 WA Whatcom   school 5300420 37501   Bellingham School District 530042000104 2066 Fairhaven Middle School   Regular School No Middle 06 08 2019   grade_7 161 3 20   3 10     0   13   110 100 0   2   3   47       11.0 210 161 3 20   3 10     0   13   110 100 0   2 3 47     11 210
2413921 2413921 WA Whatcom   school 5300420 37501   Bellingham School District 530042000114 3201 Shuksan Middle School   Regular School No Middle 06 08 2019   grade_7 104 4 81   2 25     1   18   111 124 0   39   12   146       16.0 235 104 4 81   2 25     1   18   111 124 0   39 12 146     16 235
2413959 2413959 WA Whatcom   school 5300420 37501   Bellingham School District 530042000117 2075 Whatcom Middle School   Regular School No Middle 06 08 2019   grade_7 180 5 26   3 8     0   21   136 106 1   3   4   57       22.0 243 180 5 26   3 8     0   21   136 106 1   3 4 57     22 243
2413876 2413876 WA Whatcom   school 5300420 37501   Bellingham School District 530042001739 4442 Kulshan Middle School   Regular School No Middle 06 08 2019   grade_7 147 1 35   2 5     2   14   110 95 1   7   8   82       22.0 206 147 1 35   2 5     2   14   110 95 1   7 8 82     22 206
2413809 2413809 WA Whatcom   school 5300420 37501   Bellingham School District 530042003476 5366 Bellingham Family Partnership Program   Alternative School No Other KG 12 2019   grade_7 11 1 0   0 0     0   2   8 6 0   0   0   1       2.0 14 11 1 0   0 0     0   2   8 6 0   0 0 1     2 14
2413987 2413987 WA Pierce   school 5300480 27403   Bethel School District 530048000120 3250 Bethel Middle School   Regular School No Middle 06 08 2019   grade_7 116 16 57   1 15     13   41   136 123 0   14   10   154       5.0 259 116 16 57   1 15     13   41   136 123 0   14 10 154     5 259
2414039 2414039 WA Pierce   school 5300480 27403   Bethel School District 530048000123 2877 Elk Plain School of Choice   Regular School No Elementary KG 08 2019   grade_7 49 7 13   0 1     2   8   37 43 0   1   0   26       5.0 80 49 7 13   0 1     2   8   37 43 0   1 0 26     5 80
2414152 2414152 WA Pierce   school 5300480 27403   Bethel School District 530048000128 3751 Spanaway Middle School   Regular School No Middle 06 08 2019   grade_7 106 25 56   0 12     10   45   131 124 0   22   7   168       7.0 255 106 25 56   0 12     10   45   131 124 0   22 7 168     7 255
2414058 2414058 WA Pierce   school 5300480 27403   Bethel School District 530048000595 4407 Frontier Middle School   Regular School No Middle 06 08 2019   grade_7 162 8 29   1 5     6   34   143 102 0   3   7   110       11.0 245 162 8 29   1 5     6   34   143 102 0   3 7 110     11 245
2414000 2414000 WA Pierce   school 5300480 27403   Bethel School District 530048001819 4186 Cedarcrest Middle School   Regular School No Middle 06 08 2019   grade_7 81 29 39   4 18     7   48   124 102 0   10   2   137       7.0 226 81 29 39   4 18     7   48   124 102 0   10 2 137     7 226
2414030 2414030 WA Pierce   school 5300480 27403   Bethel School District 530048003158 4578 Cougar Mountain Middle School   Regular School No Middle 06 08 2019   grade_7 130 5 33   3 2     3   19   99 96 0   4   7   100       10.0 195 130 5 33   3 2     3   19   99 96 0   4 7 100     10 195
2414081 2414081 WA Pierce   school 5300480 27403   Bethel School District 530048003343 5206 Liberty Middle School   Regular School No Middle 06 08 2019   grade_7 108 17 59   2 11     12   43   124 131 0   13   5   129       12.0 255 108 17 59   2 11     12   43   124 131 0   13 5 129     12 255
2414166 2414166 WA Klickitat   school 5300510 20203   Bickleton School District 530051000129 3392 Bickleton Elementary & High Schl   Regular School No Other KG 12 2019   grade_7 7 0 4   0 0     0   0   5 6 0   0   0   7       0.0 11 7 0 4   0 0     0   0   5 6 0   0 0 7     0 11
2414193 2414193 WA Whatcom   school 5300570 37503   Blaine School District 530057000131 3796 Blaine Middle School   Regular School No Middle 06 08 2019   grade_7 120 2 25   1 4     0   16   92 76 0   2   3   90       15.0 168 120 2 25   1 4     0   16   92 76 0   2 3 90     15 168
2414187 2414187 WA Whatcom   school 5300570 37503   Blaine School District 530057003020 5021 Blaine Home Connections   Alternative School No Other KG 11 2019   grade_7 8 0 0   0 0     0   1   6 3 0   0   0   2       0.0 9 8 0 0   0 0     0   1   6 3 0   0 0 2     0 9
2414214 2414214 WA Lewis   school 5300630 21234   Boistfort School District 530063000133 2516 Boistfort Elem   Regular School No Elementary PK 08 2019   grade_7 5 0 1   0 0     0   1   4 3 0   1   0   4       1.0 7 5 0 1   0 0     0   1   4 3 0   1 0 4     1 7
2414293 2414293 WA Kitsap   school 5300660 18100   Bremerton School District 530066000144 2613 West Hills S.T.E.M. Academy   Regular School No Elementary PK 08 2019   grade_7 22 4 10   0 3     5   5   28 21 0   2   2   42       6.0 49 22 4 10   0 3     5   5   28 21 0   2 2 42     6 49
2414262 2414262 WA Kitsap   school 5300660 18100   Bremerton School District 530066001144 4441 Mountain View Middle School   Regular School No Middle 06 08 2019   grade_7 153 14 61   5 14     6   52   157 148 0   16   3   206       17.0 305 153 14 61   5 14     6   52   157 148 0   16 3 206     17 305
2414237 2414237 WA Kitsap   school 5300660 18100   Bremerton School District 530066002652 1749 Bremerton Homelink Program   Alternative School No Elementary KG 08 2019   grade_7 1 0 1   0 0     0   0   1 1 0   0   0   1       0.0 2 1 0 1   0 0     0   0   1 1 0   0 0 1     0 2
2414317 2414317 WA Okanogan   school 5300690 24111   Brewster School District 530069002284 4223 Brewster Middle School   Regular School No Middle 06 08 2019   grade_7 8 0 72   0 1     0   1   38 44 0   26   0   78       3.0 82 8 0 72   0 1     0   1   38 44 0   26 0 78     3 82
2414337 2414337 WA Douglas   school 5300720 9075   Bridgeport School District 530072001271 4213 Bridgeport Middle School   Regular School No Middle 05 08 2019   grade_7 4 0 62   0 0     0   0   33 33 0   35   2   65       2.0 66 4 0 62   0 0     0   0   33 33 0   35 2 65     2 66
2414346 2414346 WA Jefferson   school 5300750 16046   Brinnon School District 530075000153 2836 Brinnon Elementary   Regular School No Elementary PK 08 2019   grade_7 7 0 0   0 0     1   0   7 1 0   0   0   6       0.0 8 7 0 0   0 0     1   0   7 1 0   0 0 6     0 8
2414357 2414357 WA Skagit   school 5300780 29100   Burlington-Edison School District 530078000154 3603 Allen Elementary   Regular School No Elementary KG 08 2019   grade_7 8 0 32   0 1     1   4   28 18 0   19   11   36       2.0 46 8 0 32   0 1     1   4   28 18 0   19 11 36     2 46
2414388 2414388 WA Skagit   school 5300780 29100   Burlington-Edison School District 530078000156 2379 Edison Elementary   Regular School No Elementary KG 08 2019   grade_7 53 0 7   0 0     0   2   37 25 0   3   1   14       1.0 62 53 0 7   0 0     0   2   37 25 0   3 1 14     1 62
2414398 2414398 WA Skagit   school 5300780 29100   Burlington-Edison School District 530078000157 3251 Lucille Umbarger Elementary   Regular School No Elementary 01 08 2019   grade_7 35 0 64   0 2     0   3   56 48 0   35   9   76       4.0 104 35 0 64   0 2     0   3   56 48 0   35 9 76     4 104
2414367 2414367 WA Skagit   school 5300780 29100   Burlington-Edison School District 530078000689 4412 Bay View Elementary   Regular School No Elementary KG 08 2019   grade_7 49 0 16   0 6     0   5   42 34 0   1   3   24       6.0 76 49 0 16   0 6     0   5   42 34 0   1 3 24     6 76
2414467 2414467 WA Clark   school 5300810 6117   Camas School District 530081002512 4508 Skyridge Middle School   Regular School No Middle 06 08 2019   grade_7 187 3 32   1 36     0   30   141 148 0   5   0   37       20.0 289 187 3 32   1 36     0   30   141 148 0   5 0 37     20 289
2414450 2414450 WA Clark   school 5300810 6117   Camas School District 530081003066 5054 Liberty Middle School   Regular School No Middle 06 08 2019   grade_7 208 2 32   1 7     0   21   149 122 0   2   10   62       18.0 271 208 2 32   1 7     0   21   149 122 0   2 10 62     18 271
2414454 2414454 WA Clark   school 5300810 6117   Camas School District 530081003652 5534 Odyssey Middle School   Regular School No Middle 06 08 2019   grade_7 63 0 8   1 5     0   2   47 32 0   0   0   9       4.0 79 63 0 8   1 5     0   2   47 32 0   0 0 9     4 79
2414490 2414490 WA Clallam   school 5300840 5401   Cape Flattery School District 530084000164 3422 Clallam Bay High & Elementary   Regular School No Other KG 12 2019   grade_7 4 0 3   3 0     0   2   5 7 0   0   0   6       0.0 12 4 0 3   3 0     0   2   5 7 0   0 0 6     0 12
2414506 2414506 WA Clallam   school 5300840 5401   Cape Flattery School District 530084000165 3145 Neah Bay Junior/ Senior High School   Regular School No High 06 12 2019   grade_7 0 0 5   10 0     0   6   6 15 0   0   0   16       1.0 21 0 0 5   10 0     0   6   6 15 0   0 0 16     1 21
2414516 2414516 WA Pierce   school 5300870 27019   Carbonado School District 530087000166 2466 Carbonado Historical School 19   Regular School No Elementary PK 08 2019   grade_7 15 0 0   0 0     0   1   8 8 0   0   0   5       0.0 16 15 0 0   0 0     0   1   8 8 0   0 0 5     0 16
2414548 2414548 WA Chelan   school 5300950 4228   Cascade School District 530095000553 4403 Icicle River Middle School   Regular School No Middle 06 08 2019   grade_7 62 0 33   1 0     1   4   59 42 0   10   6   49       2.0 101 62 0 33   1 0     1   4   59 42 0   10 6 49     2 101
2414543 2414543 WA Chelan   school 5300950 4228   Cascade School District 530095003528 5418 Cascade Home-Link   Regular School No Elementary KG 08 2019   grade_7 5 0 0   0 0     0   0   0 5 0   0   0   1       0.0 5 5 0 0   0 0     0   0   0 5 0   0 0 1     0 5
2414563 2414563 WA Chelan   school 5300960 4222   CASHMERE SCHOOL DISTRICT 530096000169 2315 CASHMERE MIDDLE SCHOOL   Regular School No Middle 05 08 2019   grade_7 69 0 58   0 0     0   4   62 69 0   3   0   63       9.0 131 69 0 58   0 0     0   4   62 69 0   3 0 63     9 131
2414588 2414588 WA Cowlitz   school 5300990 8401   Castle Rock School District 530099000173 3969 Castle Rock Middle School   Regular School No Middle 06 08 2019   grade_7 97 0 11   1 1     1   2   49 64 0   3   0   65       6.0 113 97 0 11   1 1     1   2   49 64 0   3 0 65     6 113
2414597 2414597 WA Klickitat   school 5301050 20215   Centerville School District 530105000175 2251 Centerville Elementary   Regular School No Elementary KG 08 2019   grade_7 12 0 0   0 0     1   0   7 6 0   0   0   3       1.0 13 12 0 0   0 0     1   0   7 6 0   0 0 3     1 13
2414630 2414630 WA Kitsap   school 5301080 18401   Central Kitsap School District 530108000178 3237 Central Kitsap Middle School   Regular School No Middle 06 08 2019   grade_7 152 8 38   0 11     0   36   115 130 0   6   1   82       13.0 245 152 8 38   0 11     0   36   115 130 0   6 1 82     13 245
2414675 2414675 WA Kitsap   school 5301080 18401   Central Kitsap School District 530108000183 3791 Fairview Middle School   Regular School No Middle 06 08 2019   grade_7 118 13 32   0 11     2   40   115 101 0   9   4   109       14.0 216 118 13 32   0 11     2   40   115 101 0   9 4 109     14 216
2414716 2414716 WA Kitsap   school 5301080 18401   Central Kitsap School District 530108002056 4249 Ridgetop Middle School   Regular School No Middle 06 08 2019   grade_7 116 10 38   1 10     4   51   119 111 0   3   1   89       14.0 230 116 10 38   1 10     4   51   119 111 0   3 1 89     14 230
2414698 2414698 WA Kitsap   school 5301080 18401   Central Kitsap School District 530108002524 4509 Klahowya Secondary   Regular School No High 06 12 2019   grade_7 122 2 15   0 0     0   20   75 84 0   4   2   55       13.0 159 122 2 15   0 0     0   20   75 84 0   4 2 55     13 159
2414610 2414610 WA Kitsap   school 5301080 18401   Central Kitsap School District 530108003622 5472 Barker Creek Community School   Alternative School No Other KG 12 2019   grade_7 11 1 1   0 0     0   2   6 9 0   0   0   2       0.0 15 11 1 1   0 0     0   2   6 9 0   0 0 2     0 15
2414893 2414893 WA Spokane   school 5301110 32356   Central Valley School District 530111000188 3465 Summit School   Regular School No Elementary KG 08 2019   grade_7 39 1 0   0 2     0   3   26 19 0   0   0   13       0.0 45 39 1 0   0 2     0   3   26 19 0   0 0 13     0 45
2414752 2414752 WA Spokane   school 5301110 32356   Central Valley School District 530111000189 3260 Bowdish Middle School   Regular School No Middle 06 08 2019   grade_7 147 3 2   1 1     2   10   84 82 0   1   5   91       3.0 166 147 3 2   1 1     2   10   84 82 0   1 5 91     3 166
2414768 2414768 WA Spokane   school 5301110 32356   Central Valley School District 530111000191 3065 Central Valley High School   Regular School No High 09 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

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