Data source: Big Local News · About: Big Local

658 rows where grade = "grade_7", state = "WA" and year = 2020 sorted by district_nces_id

View and edit SQL

year

  • 2020 · 658

grade

  • grade_7 · 658
Link rowid state county county_state_id admin_level district_nces_id ▼ district_state_id district_state_type district school_nces_id school_state_id school school_state_type ccd_school_type ccd_charter_school ccd_school_lvl ccd_school_low_grade ccd_school_high_grade year term grade white black hispanic native_american native_american_alaskan_native asian native_hawaiian asian_pacific_islander native_hawaiian_pacific_islander pacific_islander multiracial unknown_race male female non_binary unknown_gender ell ell_percent homeless homeless_percent low_income free_and_reduced free_and_reduced_percent disability section_504 total white_int black_int hispanic_int native_american_int native_american_alaskan_native_int asian_int native_hawaiian_int asian_pacific_islander_int native_hawaiian_pacific_islander_int pacific_islander_int multiracial_int unknown_race_int male_int female_int non_binary_int unknown_gender_int ell_int homeless_int low_income_int free_and_reduced_int disability_int section_504_int total_int
2573802 WA King   school 5300001 17216   Enumclaw School District 530000102054 4210 Enumclaw Middle School   Regular School No Middle 06 08 2020   grade_7 119 1 27   1 0     1   12   81 80 0   7   10   68       3.0 161 119 1 27   1 0     1   12   81 80 0   7 10 68     3 161
2573825 WA King   school 5300001 17216   Enumclaw School District 530000103038 1523 Special Ed School   Special Education School No Other PK 12 2020   grade_7 1 0 1   0 0     0   0   2 0 0   0   0   2       0.0 2 1 0 1   0 0     0   0   2 0 0   0 0 2     0 2
2573836 WA King   school 5300001 17216   Enumclaw School District 530000102795 4550 Thunder Mountain Middle School   Regular School No Middle 06 08 2020   grade_7 112 0 24   1 2     0   4   75 68 0   8   1   37       7.0 143 112 0 24   1 2     0   4   75 68 0   8 1 37     7 143
2575470 WA Ferry   school 5300002 10070   Inchelium School District 530000202870 4214 Inchelium Middle School   Regular School No Middle 06 08 2020   grade_7 0 0 0   18 0     0   3   9 12 0   11   0   17       0.0 21 0 0 0   18 0     0   3   9 12 0   11 0 17     0 21
2575737 WA Cowlitz   school 5300003 8458   Kelso School District 530000300591 3322 Coweeman Middle School   Regular School No Middle 06 08 2020   grade_7 133 1 25   2 1     3   7   92 80 0   9   0   106       8.0 172 133 1 25   2 1     3   7   92 80 0   9 0 106     8 172
2575741 WA Cowlitz   school 5300003 8458   Kelso School District 530000300592 2916 Huntington Middle School   Regular School No Middle 06 08 2020   grade_7 130 0 35   2 0     1   14   102 80 0   10   2   120       11.0 182 130 0 35   2 0     1   14   102 80 0   10 2 120     11 182
2573915 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 2020   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
2573936 WA Kitsap   school 5300007 18801   ESD 114 acting as a school district 530000702914 3143 Clallam Co Juvenile Detention   Regular School No High 08 12 2020   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
2573900 WA Spokane   school 5300010 32801   ESD 101 acting as a school district 530001002930 3526 Spokane Juvenile Detention School   Regular School No High 06 12 2020   grade_7 0 0 0   1 0     0   0   1 0 0   0   0   0       0.0 1 0 0 0   1 0     0   0   1 0 0   0 0 0     0 1
2585071 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 2020   grade_7 3 0 6   1 0     0   0   4 6 0   0   0   6       0.0 10 3 0 6   1 0     0   0   4 6 0   0 0 6     0 10
2570308 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000001 2834 A J West Elementary   Regular School No Elementary PK 05 2020   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
2570324 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003003633 5514 Grays Harbor Academy   Alternative School No Other 03 12 2020   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
2570357 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000009 2305 Miller Junior High   Regular School No Middle 06 08 2020   grade_7 150 2 92   3 6     0   17   132 138 0   20   12   205       20.0 270 150 2 92   3 6     0   17   132 138 0   20 12 205     20 270
2570390 WA Lewis   school 5300060 21226   Adna School District 530006000013 2441 Adna Middle/High School   Regular School No High 06 12 2020   grade_7 55 0 4   1 0     0   0   34 26 0   0   2   20       1.0 60 55 0 4   1 0     0   0   34 26 0   0 2 20     1 60
2570400 WA Lincoln   school 5300090 22017   Almira School District 530009000179 2860 Almira Elementary School   Regular School No Elementary PK 08 2020   grade_7 20 0 2   0 0     0   2   17 7 0   0   0   12       0.0 24 20 0 2   0 0     0   2   17 7 0   0 0 12     0 24
2570411 WA Skagit   school 5300150 29103   Anacortes School District 530015000015 2707 Anacortes Middle School   Regular School No Middle 06 08 2020   grade_7 171 2 31   0 4     0   15   113 110 0   4   3   65       13.0 223 171 2 31   0 4     0   15   113 110 0   4 3 65     13 223
2570469 WA Snohomish   school 5300240 31016   Arlington School District 530024003008 5010 Haller Middle School   Regular School No Middle 06 08 2020   grade_7 163 2 33   6 3     0   23   116 114 0   12   3   72       7.0 230 163 2 33   6 3     0   23   116 114 0   12 3 72     7 230
2570489 WA Snohomish   school 5300240 31016   Arlington School District 530024000024 3124 Post Middle School   Regular School No Middle 06 08 2020   grade_7 186 0 33   3 4     0   19   138 107 0   13   6   90       12.0 245 186 0 33   3 4     0   19   138 107 0   13 6 90     12 245
2570506 WA Snohomish   school 5300240 31016   Arlington School District 530024002589 1714 Stillaguamish Valley Learning Center   Alternative School No Elementary KG 08 2020   grade_7 8 0 1   0 0     0   1   5 5 0   0   0   2       0.0 10 8 0 1   0 0     0   1   5 5 0   0 0 2     0 10
2570532 WA Asotin   school 5300280 2420   Asotin-Anatone School District 530028000028 2434 Asotin Jr Sr High   Regular School No High 06 12 2020   grade_7 37 0 5   1 1     0   4   24 24 0   0   0   20       0.0 48 37 0 5   1 1     0   4   24 24 0   0 0 20     0 48
2570572 WA King   school 5300300 17408   Auburn School District 530030000033 2394 Cascade Middle School   Regular School No Middle 06 08 2020   grade_7 112 30 75   1 19     24   25   160 126 0   52   7   179       5.0 286 112 30 75   1 19     24   25   160 126 0   52 7 179     5 286
2570645 WA King   school 5300300 17408   Auburn School District 530030001443 4462 Mt Baker Middle School   Regular School No Middle 06 08 2020   grade_7 112 12 137   2 41     12   32   189 159 0   51   0   174       11.0 348 112 12 137   2 41     12   32   189 159 0   51 0 174     11 348
2570649 WA King   school 5300300 17408   Auburn School District 530030000038 3169 Olympic Middle School   Regular School No Middle 06 08 2020   grade_7 77 21 130   19 18     19   30   154 160 0   70   3   230       7.0 314 77 21 130   19 18     19   30   154 160 0   70 3 230     7 314
2570661 WA King   school 5300300 17408   Auburn School District 530030002434 4385 Rainier Middle School   Regular School No Middle 06 08 2020   grade_7 120 35 94   3 49     3   39   166 177 0   41   3   196       7.0 343 120 35 94   3 49     3   39   166 177 0   41 3 196     7 343
2579213 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 2020   grade_7 4 0 0   2 0     0   1   4 3 0   1   0   5       0.0 7 4 0 0   2 0     0   1   4 3 0   1 0 5     0 7
2583669 WA Kitsap   school 5300328 18902   Suquamish Tribal Education Department 530032803493 5319 Chief Kitsap Academy   Regular School No Other KG 12 2020   grade_7 1 0 1   4 0     0   0   4 2 0   0   0   3       1.0 6 1 0 1   4 0     0   0   4 2 0   0 0 3     1 6
2570703 WA Kitsap   school 5300330 18303   Bainbridge Island School District 530033003113 1939 Bainbridge Special Education Services   Special Education School No Other PK 12 2020   grade_7 3 0 2   0 0     0   1   5 1 0   0   0   1       0.0 6 3 0 2   0 0     0   1   5 1 0   0 0 1     0 6
2570733 WA Kitsap   school 5300330 18303   Bainbridge Island School District 530033002802 1841 Mosaic Home Education Partnership   Alternative School No Elementary KG 08 2020   grade_7 3 0 0   0 1     0   0   2 2 0   0   0   1       0.0 4 3 0 0   0 1     0   0   2 2 0   0 0 1     0 4
2570743 WA Kitsap   school 5300330 18303   Bainbridge Island School District 530033002523 1699 Odyssey Multiage Program   Regular School No Elementary KG 08 2020   grade_7 24 0 2   0 0     0   2   16 12 0   0   0   3       7.0 28 24 0 2   0 0     0   2   16 12 0   0 0 3     7 28
2570757 WA Kitsap   school 5300330 18303   Bainbridge Island School District 530033002452 4505 Woodward Middle School   Regular School No Middle 07 08 2020   grade_7 194 1 26   1 11     1   30   134 130 0   1   0   19       41.0 264 194 1 26   1 11     1   30   134 130 0   1 0 19     41 264
2580598 WA King   school 5300335 17908   Rainier Prep Charter School District 530033503533 5380 Rainier Prep   Regular School Yes Middle 05 08 2020   grade_7 5 38 32   0 8     0   6   48 40 1   17   1   68       1.0 89 5 38 32   0 8     0   6   48 40 1   17 1 68     1 89
2582819 WA Spokane   school 5300337 32901   Spokane International Academy 530033703539 5381 Spokane International Academy   Regular School Yes Elementary KG 08 2020   grade_7 49 1 7   1 1     0   10   35 33 1   0   0   31       2.0 69 49 1 7   1 1     0   10   35 33 1   0 0 31     2 69
2580115 WA Spokane   school 5300339 32907   PRIDE Prep Charter School District 530033903495 5339 PRIDE Prep School   Regular School Yes High 06 12 2020   grade_7 87 3 13   3 2     0   2   62 44 4   0   0   70       8.0 110 87 3 13   3 2     0   2   62 44 4   0 0 70     8 110
2580620 WA King   school 5300342 17910   Rainier Valley Leadership Academy 530034203602 5468 Rainier Valley Leadership Academy   Regular School Yes Middle 06 10 2020   grade_7 1 61 13   0 0     1   7   38 45 0   25   4   67       1.0 83 1 61 13   0 0     1   7   38 45 0   25 4 67     1 83
2583493 WA King   school 5300343 17905   Summit Public School: Atlas 530034303611 5469 Summit Public School: Atlas   Regular School Yes High 06 12 2020   grade_7 31 33 15   1 2     1   17   61 39 0   18   0   57       4.0 100 31 33 15   1 2     1   17   61 39 0   18 0 57     4 100
2575485 WA Walla Walla   school 5300344 36901   Innovation Schools 530034403636 5470 Innovation Schools   Regular School Yes Middle 06 08 2020   grade_7 10 0 14   0 0     0   2   10 16 0   8   0   19       2.0 26 10 0 14   0 0     0   2   10 16 0   8 0 19     2 26
2570766 WA Clark   school 5300380 6119   Battle Ground School District 530038000048 2671 Amboy Middle School   Regular School No Middle 05 08 2020   grade_7 102 0 5   0 0     0   4   57 54 0   0   2   37       2.0 111 102 0 5   0 0     0   4   57 54 0   0 2 37     2 111
2570781 WA Clark   school 5300380 6119   Battle Ground School District 530038002782 1836 CAM Academy   Alternative School No Other 03 12 2020   grade_7 54 0 1   0 2     0   2   26 33 0   1   0   10       2.0 59 54 0 1   0 2     0   2   26 33 0   1 0 10     2 59
2570794 WA Clark   school 5300380 6119   Battle Ground School District 530038003262 5133 Chief Umtuch Middle   Regular School No Middle 05 08 2020   grade_7 119 0 20   0 2     0   8   81 68 0   6   1   50       7.0 149 119 0 20   0 2     0   8   81 68 0   6 1 50     7 149
2570800 WA Clark   school 5300380 6119   Battle Ground School District 530038003176 5089 Daybreak Middle   Regular School No Middle 05 08 2020   grade_7 102 1 24   0 2     0   14   74 69 0   12   3   65       11.0 143 102 1 24   0 2     0   14   74 69 0   12 3 65     11 143
2570831 WA Clark   school 5300380 6119   Battle Ground School District 530038002857 1875 Homelink River   Alternative School No Other KG 12 2020   grade_7 54 0 2   2 1     0   5   29 35 0   3   0   20       4.0 64 54 0 2   2 1     0   5   29 35 0   3 0 20     4 64
2570838 WA Clark   school 5300380 6119   Battle Ground School District 530038000052 3545 Laurin Middle School   Regular School No Middle 05 08 2020   grade_7 124 3 25   0 16     1   10   92 87 0   15   3   61       6.0 179 124 3 25   0 16     1   10   92 87 0   15 3 61     6 179
2570847 WA Clark   school 5300380 6119   Battle Ground School District 530038003681 4144 Maple Grove Primary   Regular School No Elementary KG 04 2020   grade_7 0 0 0   0 1     0   0   1 0 0   0   0   0       0.0 1 0 0 0   0 1     0   0   1 0 0   0 0 0     0 1
2570856 WA Clark   school 5300380 6119   Battle Ground School District 530038000054 3997 Pleasant Valley Middle   Regular School No Middle 05 08 2020   grade_7 83 8 14   0 10     0   7   55 67 0   5   2   42       8.0 122 83 8 14   0 10     0   7   55 67 0   5 2 42     8 122
2570880 WA Clark   school 5300380 6119   Battle Ground School District 530038003214 5131 Tukes Valley Middle School   Regular School No Middle 05 08 2020   grade_7 117 0 9   1 2     0   8   79 58 0   6   3   48       4.0 137 117 0 9   1 2     0   8   79 58 0   6 3 48     4 137
2570909 WA King   school 5300390 17405   Bellevue School District 530039003354 5240 Bellevue Big Picture School   Alternative School No High 06 12 2020   grade_7 31 0 4   0 30     0   11   40 36 0   5   0   9       9.0 76 31 0 4   0 30     0   11   40 36 0   5 0 9     9 76
2570937 WA King   school 5300390 17405   Bellevue School District 530039003434 5281 Central Educational Services   Regular School No Other PK 12 2020   grade_7 0 0 3   0 0     0   1   2 2 0   0   0   0       0.0 4 0 0 3   0 0     0   1   2 2 0   0 0 0     0 4
2570953 WA King   school 5300390 17405   Bellevue School District 530039000064 3338 Chinook Middle School   Regular School No Middle 06 08 2020   grade_7 144 8 32   0 104     4   40   170 162 0   31   4   49       31.0 332 144 8 32   0 104     4   40   170 162 0   31 4 49     31 332
2570981 WA King   school 5300390 17405   Bellevue School District 530039000068 3166 Highland Middle School   Regular School No Middle 06 08 2020   grade_7 42 12 67   0 22     0   12   79 76 0   40   9   87       8.0 155 42 12 67   0 22     0   12   79 76 0   40 9 87     8 155
2570993 WA King   school 5300390 17405   Bellevue School District 530039003149 3522 International School   Alternative School No High 06 12 2020   grade_7 36 1 7   0 39     0   9   47 45 0   3   0   11       8.0 92 36 1 7   0 39     0   9   47 45 0   3 0 11     8 92
2571035 WA King   school 5300390 17405   Bellevue School District 530039000079 3631 Odle Middle School   Regular School No Middle 06 08 2020   grade_7 61 12 34   1 194     0   27   171 158 0   30   4   66       12.0 329 61 12 34   1 194     0   27   171 158 0   30 4 66     12 329
2571091 WA King   school 5300390 17405   Bellevue School District 530039000093 3435 Tillicum Middle School   Regular School No Middle 06 08 2020   grade_7 112 8 56   1 63     0   26   127 138 1   5   1   38       30.0 266 112 8 56   1 63     0   26   127 138 1   5 1 38     30 266
2571095 WA King   school 5300390 17405   Bellevue School District 530039000094 3283 Tyee Middle School   Regular School No Middle 06 08 2020   grade_7 86 13 17   3 225     3   21   200 168 0   19   0   43       21.0 368 86 13 17   3 225     3   21   200 168 0   19 0 43     21 368
2571129 WA Whatcom   school 5300420 37501   Bellingham School District 530042003476 5366 Bellingham Family Partnership Program   Alternative School No Other KG 12 2020   grade_7 15 0 1   0 1     0   1   7 11 0   0   1   2       1.0 18 15 0 1   0 1     0   1   7 11 0   0 1 2     1 18
2571176 WA Whatcom   school 5300420 37501   Bellingham School District 530042000104 2066 Fairhaven Middle School   Regular School No Middle 06 08 2020   grade_7 134 2 19   0 8     1   19   93 90 0   6   3   43       17.0 183 134 2 19   0 8     1   19   93 90 0   6 3 43     17 183
2571196 WA Whatcom   school 5300420 37501   Bellingham School District 530042001739 4442 Kulshan Middle School   Regular School No Middle 06 08 2020   grade_7 116 1 36   2 3     0   13   90 81 0   6   6   79       21.0 171 116 1 36   2 3     0   13   90 81 0   6 6 79     21 171
2571239 WA Whatcom   school 5300420 37501   Bellingham School District 530042000113 3576 Sehome High School   Regular School No High 09 12 2020   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
2571243 WA Whatcom   school 5300420 37501   Bellingham School District 530042000114 3201 Shuksan Middle School   Regular School No Middle 06 08 2020   grade_7 97 6 81   3 19     3   20   119 109 1   35   10   144       16.0 229 97 6 81   3 19     3   20   119 109 1   35 10 144     16 229
2571282 WA Whatcom   school 5300420 37501   Bellingham School District 530042000117 2075 Whatcom Middle School   Regular School No Middle 06 08 2020   grade_7 152 5 18   2 6     0   19   115 85 2   2   3   48       25.0 202 152 5 18   2 6     0   19   115 85 2   2 3 48     25 202
2571307 WA Pierce   school 5300480 27403   Bethel School District 530048000120 3250 Bethel Middle School   Regular School No Middle 06 08 2020   grade_7 99 14 64   3 6     15   40   128 113 0   13   9   150       5.0 241 99 14 64   3 6     15   40   128 113 0   13 9 150     5 241
2571318 WA Pierce   school 5300480 27403   Bethel School District 530048001819 4186 Cedarcrest Middle School   Regular School No Middle 06 08 2020   grade_7 92 42 58   2 24     28   43   152 137 0   13   5   186       8.0 289 92 42 58   2 24     28   43   152 137 0   13 5 186     8 289
2571349 WA Pierce   school 5300480 27403   Bethel School District 530048003158 4578 Cougar Mountain Middle School   Regular School No Middle 06 08 2020   grade_7 138 0 32   2 2     2   26   104 97 1   1   11   106       9.0 202 138 0 32   2 2     2   26   104 97 1   1 11 106     9 202
2571358 WA Pierce   school 5300480 27403   Bethel School District 530048000123 2877 Elk Plain School of Choice   Regular School No Elementary KG 08 2020   grade_7 46 7 9   0 4     0   15   39 42 0   4   1   35       9.0 81 46 7 9   0 4     0   15   39 42 0   4 1 35     9 81
2571377 WA Pierce   school 5300480 27403   Bethel School District 530048000595 4407 Frontier Middle School   Regular School No Middle 06 08 2020   grade_7 181 10 50   6 6     4   35   160 132 0   10   3   131       10.0 292 181 10 50   6 6     4   35   160 132 0   10 3 131     10 292
2571401 WA Pierce   school 5300480 27403   Bethel School District 530048003343 5206 Liberty Middle School   Regular School No Middle 06 08 2020   grade_7 111 15 66   2 9     8   38   119 130 0   10   1   135       11.0 249 111 15 66   2 9     8   38   119 130 0   10 1 135     11 249
2571471 WA Pierce   school 5300480 27403   Bethel School District 530048000128 3751 Spanaway Middle School   Regular School No Middle 06 08 2020   grade_7 87 27 73   3 12     21   52   135 140 0   16   9   194       4.0 275 87 27 73   3 12     21   52   135 140 0   16 9 194     4 275
2571485 WA Klickitat   school 5300510 20203   Bickleton School District 530051000129 3392 Bickleton Elementary & High Schl   Regular School No Other KG 12 2020   grade_7 10 0 2   0 0     0   0   5 7 0   0   0   5       0.0 12 10 0 2   0 0     0   0   5 7 0   0 0 5     0 12
2571506 WA Whatcom   school 5300570 37503   Blaine School District 530057003020 5021 Blaine Home Connections   Alternative School No Other KG 11 2020   grade_7 5 0 0   0 0     0   0   3 2 0   0   0   1       0.0 5 5 0 0   0 0     0   0   3 2 0   0 0 1     0 5
2571512 WA Whatcom   school 5300570 37503   Blaine School District 530057000131 3796 Blaine Middle School   Regular School No Middle 06 08 2020   grade_7 120 6 23   1 12     1   17   84 96 0   6   3   96       17.0 180 120 6 23   1 12     1   17   84 96 0   6 3 96     17 180
2571535 WA Lewis   school 5300630 21234   Boistfort School District 530063000133 2516 Boistfort Elem   Regular School No Elementary PK 08 2020   grade_7 6 0 1   0 0     0   2   6 3 0   0   0   5       1.0 9 6 0 1   0 0     0   2   6 3 0   0 0 5     1 9
2571560 WA Kitsap   school 5300660 18100   Bremerton School District 530066002652 1749 Bremerton Homelink Program   Alternative School No Elementary KG 08 2020   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
2571584 WA Kitsap   school 5300660 18100   Bremerton School District 530066001144 4441 Mountain View Middle School   Regular School No Middle 06 08 2020   grade_7 154 13 66   4 11     2   34   149 135 0   18   4   192       21.0 284 154 13 66   4 11     2   34   149 135 0   18 4 192     21 284
2571615 WA Kitsap   school 5300660 18100   Bremerton School District 530066000144 2613 West Hills S.T.E.M. Academy   Regular School No Elementary PK 08 2020   grade_7 25 5 14   0 1     2   6   29 24 0   6   1   44       4.0 53 25 5 14   0 1     2   6   29 24 0   6 1 44     4 53
2571641 WA Okanogan   school 5300690 24111   Brewster School District 530069002284 4223 Brewster Middle School   Regular School No Middle 06 08 2020   grade_7 7 0 69   0 0     0   2   38 40 0   25   1   73       5.0 78 7 0 69   0 0     0   2   38 40 0   25 1 73     5 78
2571665 WA Douglas   school 5300720 9075   Bridgeport School District 530072001271 4213 Bridgeport Middle School   Regular School No Middle 06 08 2020   grade_7 4 0 58   0 0     0   0   36 26 0   31   4   60       3.0 62 4 0 58   0 0     0   0   36 26 0   31 4 60     3 62
2571674 WA Jefferson   school 5300750 16046   Brinnon School District 530075000153 2836 Brinnon Elementary   Regular School No Elementary PK 08 2020   grade_7 8 0 0   1 0     0   0   5 4 0   0   0   7       0.0 9 8 0 0   1 0     0   0   5 4 0   0 0 7     0 9
2571685 WA Skagit   school 5300780 29100   Burlington-Edison School District 530078000154 3603 Allen Elementary   Regular School No Elementary KG 08 2020   grade_7 9 2 29   0 0     0   3   24 19 0   15   5   38       3.0 43 9 2 29   0 0     0   3   24 19 0   15 5 38     3 43
2571695 WA Skagit   school 5300780 29100   Burlington-Edison School District 530078000689 4412 Bay View Elementary   Regular School No Elementary KG 08 2020   grade_7 29 0 20   0 0     0   3   26 26 0   10   0   15       1.0 52 29 0 20   0 0     0   3   26 26 0   10 0 15     1 52
2571716 WA Skagit   school 5300780 29100   Burlington-Edison School District 530078000156 2379 Edison Elementary   Regular School No Elementary KG 08 2020   grade_7 34 0 10   2 0     0   3   30 19 0   4   0   18       4.0 49 34 0 10   2 0     0   3   30 19 0   4 0 18     4 49
2571726 WA Skagit   school 5300780 29100   Burlington-Edison School District 530078000157 3251 Lucille Umbarger Elementary   Regular School No Elementary 01 08 2020   grade_7 32 0 69   0 0     0   5   50 56 0   29   4   77       3.0 106 32 0 69   0 0     0   5   50 56 0   29 4 77     3 106
2571786 WA Clark   school 5300810 6117   Camas School District 530081003066 5054 Liberty Middle School   Regular School No Middle 06 08 2020   grade_7 191 0 30   1 15     3   28   124 144 0   4   7   51       13.0 268 191 0 30   1 15     3   28   124 144 0   4 7 51     13 268
2571790 WA Clark   school 5300810 6117   Camas School District 530081003652 5534 Odyssey Middle School   Regular School No Middle 06 08 2020   grade_7 55 1 12   0 2     0   8   46 32 0   0   0   9       11.0 78 55 1 12   0 2     0   8   46 32 0   0 0 9     11 78
2571803 WA Clark   school 5300810 6117   Camas School District 530081002512 4508 Skyridge Middle School   Regular School No Middle 06 08 2020   grade_7 183 3 26   0 38     0   19   134 135 0   5   3   29       25.0 269 183 3 26   0 38     0   19   134 135 0   5 3 29     25 269
2571826 WA Clallam   school 5300840 5401   Cape Flattery School District 530084000164 3422 Clallam Bay High & Elementary   Regular School No Other KG 12 2020   grade_7 2 0 2   1 0     0   2   2 5 0   0   0   4       1.0 7 2 0 2   1 0     0   2   2 5 0   0 0 4     1 7
2571843 WA Clallam   school 5300840 5401   Cape Flattery School District 530084000165 3145 Neah Bay Junior/ Senior High School   Regular School No High 06 12 2020   grade_7 0 0 5   22 0     0   5   17 15 0   0   1   31       3.0 32 0 0 5   22 0     0   5   17 15 0   0 1 31     3 32
2571853 WA Pierce   school 5300870 27019   Carbonado School District 530087000166 2466 Carbonado Historical School 19   Regular School No Elementary PK 08 2020   grade_7 21 0 0   0 0     0   2   11 12 0   0   0   7       0.0 23 21 0 0   0 0     0   2   11 12 0   0 0 7     0 23
2571881 WA Chelan   school 5300950 4228   Cascade School District 530095003528 5418 Cascade Home-Link   Regular School No Elementary KG 08 2020   grade_7 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
2571886 WA Chelan   school 5300950 4228   Cascade School District 530095000553 4403 Icicle River Middle School   Regular School No Middle 06 08 2020   grade_7 57 2 31   0 0     0   6   56 40 0   7   6   45       4.0 96 57 2 31   0 0     0   6   56 40 0   7 6 45     4 96
2571901 WA Chelan   school 5300960 4222   CASHMERE SCHOOL DISTRICT 530096000169 2315 CASHMERE MIDDLE SCHOOL   Regular School No Middle 05 08 2020   grade_7 75 0 51   0 1     0   3   67 63 0   3   3   60       12.0 130 75 0 51   0 1     0   3   67 63 0   3 3 60     12 130
2571925 WA Cowlitz   school 5300990 8401   Castle Rock School District 530099000173 3969 Castle Rock Middle School   Regular School No Middle 06 08 2020   grade_7 88 1 4   0 0     1   6   49 51 0   1   1   55       3.0 100 88 1 4   0 0     1   6   49 51 0   1 1 55     3 100
2571934 WA Klickitat   school 5301050 20215   Centerville School District 530105000175 2251 Centerville Elementary   Regular School No Elementary KG 08 2020   grade_7 11 1 0   0 0     0   0   7 5 0   0   0   4       0.0 12 11 1 0   0 0     0   0   7 5 0   0 0 4     0 12
2571947 WA Kitsap   school 5301080 18401   Central Kitsap School District 530108003622 5472 Barker Creek Community School   Alternative School No Other KG 12 2020   grade_7 9 0 1   0 0     0   3   6 7 0   0   0   2       2.0 13 9 0 1   0 0     0   3   6 7 0   0 0 2     2 13
2571967 WA Kitsap   school 5301080 18401   Central Kitsap School District 530108000178 3237 Central Kitsap Middle School   Regular School No Middle 06 08 2020   grade_7 160 9 33   0 16     2   33   124 129 0   2   2   34       14.0 253 160 9 33   0 16     2   33   124 129 0   2 2 34     14 253
2572011 WA Kitsap   school 5301080 18401   Central Kitsap School District 530108000183 3791 Fairview Middle School   Regular School No Middle 06 08 2020   grade_7 110 11 45   0 12     6   57   139 102 0   5   4   46       8.0 241 110 11 45   0 12     6   57   139 102 0   5 4 46     8 241
2572034 WA Kitsap   school 5301080 18401   Central Kitsap School District 530108002524 4509 Klahowya Secondary   Regular School No High 06 12 2020   grade_7 114 1 17   1 0     0   18   73 78 0   2   1   25       8.0 151 114 1 17   1 0     0   18   73 78 0   2 1 25     8 151
2572052 WA Kitsap   school 5301080 18401   Central Kitsap School District 530108002056 4249 Ridgetop Middle School   Regular School No Middle 06 08 2020   grade_7 142 6 46   0 16     4   49   124 139 0   10   3   46       18.0 263 142 6 46   0 16     4   49   124 139 0   10 3 46     18 263
2572088 WA Spokane   school 5301110 32356   Central Valley School District 530111000189 3260 Bowdish Middle School   Regular School No Middle 06 08 2020   grade_7 135 7 2   5 1     0   8   84 74 0   3   2   92       3.0 158 135 7 2   5 1     0   8   84 74 0   3 2 92     3 158
2572119 WA Spokane   school 5301110 32356   Central Valley School District 530111000193 3890 Evergreen Middle School   Regular School No Middle 06 08 2020   grade_7 211 8 3   5 3     1   7   123 115 0   3   6   79       5.0 238 211 8 3   5 3     1   7   123 115 0   3 6 79     5 238
2572132 WA Spokane   school 5301110 32356   Central Valley School District 530111000195 3573 Greenacres Middle School   Regular School No Middle 06 08 2020   grade_7 175 3 2   2 6     2   5   102 93 0   8   3   51       2.0 195 175 3 2   2 6     2   5   102 93 0   8 3 51     2 195
2572136 WA Spokane   school 5301110 32356   Central Valley School District 530111001826 4185 Horizon Middle School   Regular School No Middle 06 08 2020   grade_7 180 7 3   0 1     1   3   98 97 0   1   2   47       10.0 195 180 7 3   0 1     1   3   98 97 0   1 2 47     10 195

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