enrollments

Data source: Big Local News · About: Big Local

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

✎ 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
2419633 2419633 WA Adams   school 5304410 1158   Lind School District 530441003416 5293 Lind-Ritzville Middle School   Regular School No Middle 06 08 2019   grade_7 10 0 5   0 0     0   0   6 9 0   2   2   11       1.0 15 10 0 5   0 0     0   0   6 9 0   2 2 11     1 15
2422268 2422268 WA Adams   school 5306480 1147   Othello School District 530648000956 3471 McFarland Middle School   Regular School No Middle 06 08 2019   grade_7 25 0 317   0 2     0   2   178 169 0   120   6   303       13.0 347 25 0 317   0 2     0   2   178 169 0   120 6 303     13 347
2423654 2423654 WA Adams   school 5307380 1160   Ritzville School District 530738003418 5303 Lind Ritzville Middle School   Regular School No Middle 06 08 2019   grade_7 21 0 5   1 1     0   1   16 13 0   0   3   13       1.0 29 21 0 5   1 1     0   1   16 13 0   0 3 13     1 29
2427705 2427705 WA Adams   school 5309570 1109   Washtucna School District 530957001625 3075 Washtucna Elementary/High School   Regular School No Other PK 12 2019   grade_7 3 0 0   0 0     0   0   2 1 0   0   0   3       0.0 3 3 0 0   0 0     0   0   2 1 0   0 0 3     0 3
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
2415193 2415193 WA Asotin   school 5301320 2250   Clarkston School District 530132000237 2501 Lincoln Middle School   Regular School No Middle 07 08 2019   grade_7 184 4 20   2 4     0   10   120 104 0   3   23   138       6.0 224 184 4 20   2 4     0   10   120 104 0   3 23 138     6 224
2415211 2415211 WA Asotin   school 5301320 2250   Clarkston School District 530132002613 3616 Special Services   Special Education School No Other PK 12 2019   grade_7 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
2417487 2417487 WA Benton   school 5302910 3053   Finley School District 530291002100 4031 Finley Middle School   Regular School No Middle 06 08 2019   grade_7 31 0 37   0 0     0   2   39 31 0   10   2   58       3.0 70 31 0 37   0 0     0   2   39 31 0   10 2 58     3 70
2418470 2418470 WA Benton   school 5303930 3017   Kennewick School District 530393003586 5439 Chinook Middle School   Regular School No Middle 06 08 2019   grade_7 193 5 79   1 11     0   24   163 150 0   18   8   163       12.0 313 193 5 79   1 11     0   24   163 150 0   18 8 163     12 313
2418482 2418482 WA Benton   school 5303930 3017   Kennewick School District 530393000598 4028 Desert Hills Middle School   Regular School No Middle 06 08 2019   grade_7 245 9 39   1 2     1   7   153 151 0   3   1   65       14.0 304 245 9 39   1 2     1   7   153 151 0   3 1 65     14 304
2418515 2418515 WA Benton   school 5303930 3017   Kennewick School District 530393000603 3267 Highlands Middle School   Regular School No Middle 06 08 2019   grade_7 114 9 157   2 3     0   15   154 146 0   79   10   243       10.0 300 114 9 157   2 3     0   15   154 146 0   79 10 243     10 300
2418519 2418519 WA Benton   school 5303930 3017   Kennewick School District 530393000750 4429 Horse Heaven Hills Middle School   Regular School No Middle 06 08 2019   grade_7 173 8 82   1 2     1   16   163 120 0   23   4   152       12.0 283 173 8 82   1 2     1   16   163 120 0   23 4 152     12 283
2418538 2418538 WA Benton   school 5303930 3017   Kennewick School District 530393003258 1884 Legacy High School   Alternative School No High 06 12 2019   grade_7 2 1 3   0 0     0   1   5 2 0   0   1   6       0.0 7 2 1 3   0 0     0   1   5 2 0   0 1 6     0 7
2418558 2418558 WA Benton   school 5303930 3017   Kennewick School District 530393003115 1941 Mid-Columbia Parent Partnership   Alternative School No Other KG 12 2019   grade_7 31 1 5   0 0     0   2   17 22 0   0   0   9       2.0 39 31 1 5   0 0     0   2   17 22 0   0 0 9     2 39
2418565 2418565 WA Benton   school 5303930 3017   Kennewick School District 530393000607 3472 Park Middle School   Regular School No Middle 06 08 2019   grade_7 43 14 159   1 9     0   4   127 103 0   68   5   213       5.0 230 43 14 159   1 9     0   4   127 103 0   68 5 213     5 230
2418979 2418979 WA Benton   school 5304020 3052   Kiona-Benton City School District 530402000640 3961 Kiona-Benton City Middle School   Regular School No Middle 06 08 2019   grade_7 61 0 52   1 0     0   2   50 66 0   32   0   82       0.0 116 61 0 52   1 0     0   2   50 66 0   32 0 82     0 116
2422501 2422501 WA Benton   school 5306630 3050   Paterson School District 530663000976 2133 Paterson Elementary School   Regular School No Elementary PK 08 2019   grade_7 9 0 5   0 0     0   0   6 8 0   3   0   12       0.0 14 9 0 5   0 0     0   0   6 8 0   3 0 12     0 14
2422766 2422766 WA Benton   school 5306900 3116   Prosser School District 530690001013 2906 Housel Middle School   Regular School No Middle 06 08 2019   grade_7 63 0 142   0 3     0   8   98 118 0   42   13   160       11.0 216 63 0 142   0 3     0   8   98 118 0   42 13 160     11 216
2423499 2423499 WA Benton   school 5307320 3400   Richland School District 530732001091 2721 Carmichael Middle School   Regular School No Middle 06 08 2019   grade_7 179 3 79   0 11     1   19   151 141 0   10   2   141       7.0 292 179 3 79   0 11     1   19   151 141 0   10 2 141     7 292
2423503 2423503 WA Benton   school 5307320 3400   Richland School District 530732001250 2785 Chief Joseph Middle School   Regular School No Middle 06 08 2019   grade_7 153 8 54   1 2     1   12   121 110 0   19   6   136       1.0 231 153 8 54   1 2     1   12   121 110 0   19 6 136     1 231
2423507 2423507 WA Benton   school 5307320 3400   Richland School District 530732002504 3926 Enterprise Middle School   Regular School No Middle 06 08 2019   grade_7 181 1 56   0 6     0   11   146 109 0   13   1   84       8.0 255 181 1 56   0 6     0   11   146 109 0   13 1 84     8 255
2423531 2423531 WA Benton   school 5307320 3400   Richland School District 530732003606 5493 Leona Libby Middle School   Regular School No Middle 06 08 2019   grade_7 192 3 32   0 13     0   18   130 128 0   3   1   40       1.0 258 192 3 32   0 13     0   18   130 128 0   3 1 40     1 258
2423583 2423583 WA Benton   school 5307320 3400   Richland School District 530732002941 2001 Special Programs   Special Education School No Other PK 12 2019   grade_7 0 0 0   0 0     0   1   1 0 0   0   0   0       0.0 1 0 0 0   0 0     0   1   1 0 0   0 0 0     0 1
2423606 2423606 WA Benton   school 5307320 3400   Richland School District 530732003273 5165 Three Rivers Home Link   Alternative School No Other KG 12 2019   grade_7 38 0 4   1 1     0   0   19 25 0   0   0   8       1.0 44 38 0 4   1 1     0   0   19 25 0   0 0 8     1 44
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
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
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
2416441 2416441 WA Chelan   school 5302550 4127   Entiat School District 530255000374 3317 Entiat Middle and High School   Regular School No High 06 12 2019   grade_7 7 0 10   0 1     0   1   13 6 0   3   1   14       0.0 19 7 0 10   0 1     0   1   13 6 0   3 1 14     0 19
2419093 2419093 WA Chelan   school 5301200 4129   Lake Chelan School District 530120000218 2317 Chelan Middle School   Regular School No Middle 06 08 2019   grade_7 60 0 54   0 1     0   2   61 56 0   15   4   70       9.0 117 60 0 54   0 1     0   2   61 56 0   15 4 70     9 117
2419903 2419903 WA Chelan   school 5304740 4019   Manson School District 530474003427 5286 Manson Middle School   Regular School No Middle 06 08 2019   grade_7 21 0 33   1 0     0   0   32 23 0   15   4   41       2.0 55 21 0 33   1 0     0   0   32 23 0   15 4 41     2 55
2427765 2427765 WA Chelan   school 5309660 4246   Wenatchee School District 530966001006 4432 Foothills Middle School   Regular School No Middle 06 08 2019   grade_7 96 0 94   1 2     0   7   96 104 0   32   10   106       9.0 200 96 0 94   1 2     0   7   96 104 0   32 10 106     9 200
2427795 2427795 WA Chelan   school 5309660 4246   Wenatchee School District 530966001634 3370 Orchard Middle School   Regular School No Middle 06 08 2019   grade_7 77 1 93   0 2     0   10   89 94 0   45   6   128       11.0 183 77 1 93   0 2     0   10   89 94 0   45 6 128     11 183
2427799 2427799 WA Chelan   school 5309660 4246   Wenatchee School District 530966001635 3210 Pioneer Middle School   Regular School No Middle 06 08 2019   grade_7 79 1 120   2 1     1   5   113 96 0   40   10   153       16.0 209 79 1 120   2 1     1   5   113 96 0   40 10 153     16 209
2427806 2427806 WA Chelan   school 5309660 4246   Wenatchee School District 530966001636 3269 Special Education School   Special Education School No Other PK 09 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
2427824 2427824 WA Chelan   school 5309660 4246   Wenatchee School District 530966002550 1742 Valley Academy Of Learning (Closed after 2018-2019 school year)   Alternative School No Other KG 12 2019   grade_7 14 0 0   0 0     0   0   4 10 0   0   0   2       2.0 14 14 0 0   0 0     0   0   4 10 0   0 0 2     2 14
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
2415650 2415650 WA Clallam   school 5301830 5313   Crescent School District 530183000292 3473 Crescent School   Regular School No Other KG 12 2019   grade_7 12 0 2   0 0     0   1   10 5 0   0   1   9       0.0 15 12 0 2   0 0     0   1   10 5 0   0 1 9     0 15
2415662 2415662 WA Clallam   school 5301830 5313   Crescent School District 530183002942 5030 Olympic Peninsula HomeConnection   Alternative School No Other KG 12 2019   grade_7 3 0 0   0 0     0   0   2 1 0   0   0   0       0.0 3 3 0 0   0 0     0   0   2 1 0   0 0 0     0 3
2422685 2422685 WA Clallam   school 5306820 5121   Port Angeles School District 530682002551 1715 Parents As Partners (Closed after 2018-2019 school year)   Alternative School No Elementary KG 08 2019   grade_7 1 0 0   0 0     0   0   0 1 0   0   0   1       0.0 1 1 0 0   0 0     0   0   0 1 0   0 0 1     0 1
2422709 2422709 WA Clallam   school 5306820 5121   Port Angeles School District 530682001004 3318 Stevens Middle School   Regular School No Middle 07 08 2019   grade_7 208 3 36   12 6     0   39   166 138 0   4   8   169       16.0 304 208 3 36   12 6     0   39   166 138 0   4 8 169     16 304
2423129 2423129 WA Clallam   school   5903   Quileute Tribal School District   5430 Quileute Tribal School             2019   grade_7 0 0 3   6 0     0   0   3 6 0   0   0   7       0.0 9 0 0 3   6 0     0   0   3 6 0   0 0 7     0 9
2423141 2423141 WA Clallam   school 5307020 5402   Quillayute Valley School District 530702002507 1671 District Run Home School   Alternative School No Other KG 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
2423157 2423157 WA Clallam   school 5307020 5402   Quillayute Valley School District 530702001047 2349 Forks High School   Regular School No High 07 12 2019   grade_7 36 0 21   4 0     0   7   34 34 0   5   2   44       2.0 68 36 0 21   4 0     0   7   34 34 0   5 2 44     2 68
2424761 2424761 WA Clallam   school 5307830 5323   Sequim School District 530783002552 1708 Olympic Peninsula Academy   Alternative School No Other PK 12 2019   grade_7 10 0 1   0 0     0   2   9 4 0   0   0   6       0.0 13 10 0 1   0 0     0   2   9 4 0   0 0 6     0 13
2424767 2424767 WA Clallam   school 5307830 5323   Sequim School District 530783002617 4519 Sequim Middle School   Regular School No Middle 06 08 2019   grade_7 150 1 30   3 2     1   24   107 104 0   4   6   123       4.0 211 150 1 30   3 2     1   24   107 104 0   4 6 123     4 211
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
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
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
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
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
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
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
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
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
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
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
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
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
2416834 2416834 WA Clark   school 5302700 6114   Evergreen School District (Clark) 530270001270 1646 49th Street Academy   Special Education School No Other KG 12 2019   grade_7 1 0 0   0 0     0   1   2 0 0   0   0   2       0.0 2 1 0 0   0 0     0   1   2 0 0   0 0 2     0 2
2416853 2416853 WA Clark   school 5302700 6114   Evergreen School District (Clark) 530270000414 3785 Cascade Middle School   Regular School No Middle 06 08 2019   grade_7 180 9 97   0 13     10   27   183 153 0   42   10   223       6.0 336 180 9 97   0 13     10   27   183 153 0   42 10 223     6 336
2416864 2416864 WA Clark   school 5302700 6114   Evergreen School District (Clark) 530270000415 3320 Covington Middle School   Regular School No Middle 06 08 2019   grade_7 190 7 119   0 12     9   26   176 183 4   62   14   242       17.0 363 190 7 119   0 12     9   26   176 183 4   62 14 242     17 363
2416915 2416915 WA Clark   school 5302700 6114   Evergreen School District (Clark) 530270002510 4498 Frontier Middle School   Regular School No Middle 06 08 2019   grade_7 167 6 62   2 5     4   15   152 109 0   30   9   134       9.0 261 167 6 62   2 5     4   15   152 109 0   30 9 134     9 261
2416950 2416950 WA Clark   school 5302700 6114   Evergreen School District (Clark) 530270003101 1926 Home Choice Academy   Alternative School No Other KG 12 2019   grade_7 19 1 3   0 0     0   0   8 15 0   1   0   9       0.0 23 19 1 3   0 0     0   0   8 15 0   1 0 9     0 23
2416973 2416973 WA Clark   school 5302700 6114   Evergreen School District (Clark) 530270000412 4042 Legacy High School   Alternative School No High 06 12 2019   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
2417009 2417009 WA Clark   school 5302700 6114   Evergreen School District (Clark) 530270001901 4209 Pacific Middle School   Regular School No Middle 06 08 2019   grade_7 195 9 55   1 18     9   35   163 159 0   23   11   116       13.0 322 195 9 55   1 18     9   35   163 159 0   23 11 116     13 322
2417029 2417029 WA Clark   school 5302700 6114   Evergreen School District (Clark) 530270002878 4561 Shahala Middle School   Regular School No Middle 06 08 2019   grade_7 190 16 74   1 51     2   37   195 176 0   29   6   115       17.0 371 190 16 74   1 51     2   37   195 176 0   29 6 115     17 371
2417061 2417061 WA Clark   school 5302700 6114   Evergreen School District (Clark) 530270000428 4051 Wyeast Middle School   Regular School No Middle 06 08 2019   grade_7 131 6 94   2 10     6   26   135 140 0   34   8   166       12.0 275 131 6 94   2 10     6   26   135 140 0   34 8 166     12 275
2417782 2417782 WA Clark   school 5303300 6103   Green Mountain School District 530330000509 2484 Green Mountain School   Regular School No Elementary KG 08 2019   grade_7 13 0 2   0 0     0   1   8 8 0   0   4   11       0.0 16 13 0 2   0 0     0   1   8 8 0   0 4 11     0 16
2418066 2418066 WA Clark   school 5303570 6098   Hockinson School District 530357000559 3319 Hockinson Middle School   Regular School No Middle 06 08 2019   grade_7 142 1 14   0 4     0   6   84 83 0   5   1   40       8.0 167 142 1 14   0 4     0   6   84 83 0   5 1 40     8 167
2419046 2419046 WA Clark   school 5304170 6101   La Center School District 530417003451 5326 La Center Home School Academy   Alternative School No Other KG 12 2019   grade_7 3 0 0   0 0     0   0   2 1 0   0   0   0       0.0 3 3 0 0   0 0     0   0   2 1 0   0 0 0     0 3
2419051 2419051 WA Clark   school 5304170 6101   La Center School District 530417000649 3371 La Center Middle School   Regular School No Middle 06 08 2019   grade_7 105 1 12   0 0     0   5   69 54 0   3   2   40       14.0 123 105 1 12   0 0     0   5   69 54 0   3 2 40     14 123
2423650 2423650 WA Clark   school 5307350 6122   Ridgefield School District 530735001108 3891 View Ridge Middle School   Regular School No Middle 07 08 2019   grade_7 194 1 36   1 2     1   17   113 139 0   6   2   71       18.0 252 194 1 36   1 2     1   17   113 139 0   6 2 71     18 252
2427141 2427141 WA Clark   school 5309270 6037   Vancouver School District 530927000578 4406 Alki Middle School   Regular School No Middle 06 08 2019   grade_7 149 3 26   1 7     0   12   115 83 0   4   2   50       8.0 198 149 3 26   1 7     0   12   115 83 0   4 2 50     8 198
2427164 2427164 WA Clark   school 5309270 6037   Vancouver School District 530927002018 4503 Discovery Middle School   Regular School No Middle 06 08 2019   grade_7 100 9 100   1 3     2   19   111 123 0   41   9   173       10.0 234 100 9 100   1 3     2   19   111 123 0   41 9 173     10 234
2427191 2427191 WA Clark   school 5309270 6037   Vancouver School District 530927002408 1574 Fir Grove Childrens Center   Special Education School No Other KG 12 2019   grade_7 5 0 1   0 0     0   0   4 2 0   0   0   4       0.0 6 5 0 1   0 0     0   0   4 2 0   0 0 4     0 6
2427208 2427208 WA Clark   school 5309270 6037   Vancouver School District 530927001562 3902 Gaiser Middle School   Regular School No Middle 06 08 2019   grade_7 125 6 114   1 14     12   22   158 136 0   48   10   192       11.0 294 125 6 114   1 14     12   22   158 136 0   48 10 192     11 294
2427255 2427255 WA Clark   school 5309270 6037   Vancouver School District 530927001570 3543 Jason Lee Middle School   Regular School No Middle 06 08 2019   grade_7 137 4 51   1 9     2   20   112 112 0   14   12   116       10.0 224 137 4 51   1 9     2   20   112 112 0   14 12 116     10 224
2427286 2427286 WA Clark   school 5309270 6037   Vancouver School District 530927001577 3146 Mcloughlin Middle School   Regular School No Middle 06 08 2019   grade_7 105 11 160   2 10     23   24   172 163 0   90   15   272       8.0 335 105 11 160   2 10     23   24   172 163 0   90 15 272     8 335
2427341 2427341 WA Clark   school 5309270 6037   Vancouver School District 530927002944 4591 Thomas Jefferson Middle School   Regular School No Middle 06 08 2019   grade_7 207 2 48   0 13     2   23   159 136 0   18   4   78       20.0 295 207 2 48   0 13     2   23   159 136 0   18 4 78     20 295
2427351 2427351 WA Clark   school 5309270 6037   Vancouver School District 530927002943 3556 Vancouver Home Connection   Alternative School No Other KG 12 2019   grade_7 22 0 1   0 0     0   4   13 14 0   0   0   14       1.0 27 22 0 1   0 0     0   4   13 14 0   0 0 14     1 27
2427361 2427361 WA Clark   school 5309270 6037   Vancouver School District 530927003415 5271 Vancouver iTech Preparatory   Regular School No High 06 12 2019   grade_7 40 0 13   0 2     0   4   45 14 0   2   0   14       6.0 59 40 0 13   0 2     0   4   45 14 0   2 0 14     6 59
2427369 2427369 WA Clark   school 5309270 6037   Vancouver School District 530927002508 1689 Vancouver School of Arts and Academics   Regular School No High 06 12 2019   grade_7 63 1 13   0 4     1   9   26 65 0   0   0   28       5.0 91 63 1 13   0 4     1   9   26 65 0   0 0 28     5 91
2427377 2427377 WA Clark   school 5309270 6037   Vancouver School District 530927003246 5149 Vancouver Virtual Learning Academy   Alternative School No High 06 12 2019   grade_7 0 0 1   0 0     1   3   2 3 0   1   1   4       0.0 5 0 0 1   0 0     1   3   2 3 0   1 1 4     0 5
2427654 2427654 WA Clark   school 5309540 6112   Washougal School District 530954002709 4549 Canyon Creek Middle School   Regular School No Middle 06 08 2019   grade_7 71 1 2   0 2     0   4   41 39 0   4   1   23       2.0 80 71 1 2   0 2     0   4   41 39 0   4 1 23     2 80
2427686 2427686 WA Clark   school 5309540 6112   Washougal School District 530954001892 4207 Jemtegaard Middle School   Regular School No Middle 06 08 2019   grade_7 146 0 19   1 2     0   12   95 85 0   3   3   78       12.0 180 146 0 19   1 2     0   12   95 85 0   3 3 78     12 180
2415780 2415780 WA Columbia   school 5302040 7002   Dayton School District 530204002513 4011 Dayton Middle School   Regular School No Middle 06 08 2019   grade_7 29 0 5   0 0     0   0   19 15 0   0   1   15       1.0 34 29 0 5   0 0     0   0   19 15 0   0 1 15     1 34
2425962 2425962 WA Columbia   school 5308400 7035   Starbuck School District 530840001427 2135 Starbuck School   Regular School No Elementary PK 08 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
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
2418341 2418341 WA Cowlitz   school 5303810 8402   Kalama School District 530381000585 2561 Kalama Middle School   Regular School No Middle 06 08 2019   grade_7 67 0 10   2 0     0   2   43 38 0   2   1   30       8.0 81 67 0 10   2 0     0   2   43 38 0   2 1 30     8 81
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
2419650 2419650 WA Cowlitz   school 5304470 8122   Longview School District 530447000699 3475 Cascade Middle School   Regular School No Middle 06 08 2019   grade_7 137 0 49   4 4     0   9   97 106 0   9   14   134       5.0 203 137 0 49   4 4     0   9   97 106 0   9 14 134     5 203
2419698 2419698 WA Cowlitz   school 5304470 8122   Longview School District 530447000705 2831 Monticello Middle School   Regular School No Middle 06 08 2019   grade_7 115 1 45   3 3     4   12   78 105 0   12   11   146       7.0 183 115 1 45   3 3     4   12   78 105 0   12 11 146     7 183
2419702 2419702 WA Cowlitz   school 5304470 8122   Longview School District 530447002947 4574 Mt. Solo Middle School   Regular School No Middle 06 08 2019   grade_7 115 2 24   5 2     0   6   78 76 0   5   5   83       16.0 154 115 2 24   5 2     0   6   78 76 0   5 5 83     16 154
2426914 2426914 WA Cowlitz   school 5309030 8130   Toutle Lake School District 530903001538 2560 Toutle Lake High School   Regular School No High 07 12 2019   grade_7 57 0 5   0 3     0   4   33 36 0   0   0   27       7.0 69 57 0 5   0 3     0   4   33 36 0   0 0 27     7 69
2428178 2428178 WA Cowlitz   school 5310050 8404   Woodland School District 531005003371 5246 Lewis River Academy   Alternative School No Other KG 12 2019   grade_7 1 0 2   0 0     0   0   1 2 0   0   0   1       0.0 3 1 0 2   0 0     0   0   1 2 0   0 0 1     0 3
2428200 2428200 WA Cowlitz   school 5310050 8404   Woodland School District 531005003509 5409 Woodland Middle School   Regular School No Middle 05 08 2019   grade_7 119 3 36   0 2     0   9   82 87 0   11   11   93       4.0 169 119 3 36   0 2     0   9   82 87 0   11 11 93     4 169
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

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