Data source: Big Local News · About: Big Local

676 rows where grade = "grade_7", state = "WA" and year = 2021 sorted by county

View and edit SQL

year

  • 2021 · 676

grade

  • grade_7 · 676
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
2937852 WA Adams   school 5304410 1158   Lind School District 530441003416 5293 Lind-Ritzville Middle School   Regular School No Middle 06 08 2021   grade_7 8 0 6   0 0     0   0   8 6 0   0   0   10       0.0 14 8 0 6   0 0     0   0   8 6 0   0 0 10     0 14
2940574 WA Adams   school 5306480 1147   Othello School District 530648000956 3471 McFarland Middle School   Regular School No Middle 06 08 2021   grade_7 32 1 361   0 2     0   2   219 179 0   128   2   327       13.0 398 32 1 361   0 2     0   2   219 179 0   128 2 327     13 398
2942026 WA Adams   school 5307380 1160   Ritzville School District 530738003418 5303 Lind Ritzville Middle School   Regular School No Middle 06 08 2021   grade_7 27 0 4   0 1     0   1   18 15 0   0   0   17       0.0 33 27 0 4   0 1     0   1   18 15 0   0 0 17     0 33
2931419 WA Asotin   school 5300280 2420   Asotin-Anatone School District 530028000028 2434 Asotin Jr Sr High   Regular School No High 06 12 2021   grade_7 53 0 2   0 0     0   2   23 34 0   0   0   12       0.0 57 53 0 2   0 0     0   2   23 34 0   0 0 12     0 57
2933452 WA Asotin   school 5301320 2250   Clarkston School District 530132000237 2501 Lincoln Middle School   Regular School No Middle 07 08 2021   grade_7 140 3 19   3 1     0   14   87 93 0   0   9   114       9.0 180 140 3 19   3 1     0   14   87 93 0   0 9 114     9 180
2933467 WA Asotin   school 5301320 2250   Clarkston School District 530132002613 3616 Special Services   Special Education School No Other PK 12 2021   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
2935698 WA Benton   school 5302910 3053   Finley School District 530291002100 4031 Finley Middle School   Regular School No Middle 06 08 2021   grade_7 34 0 43   0 0     0   3   42 38 0   8   1   74       3.0 80 34 0 43   0 0     0   3   42 38 0   8 1 74     3 80
2936700 WA Benton   school 5303930 3017   Kennewick School District 530393003586 5439 Chinook Middle School   Regular School No Middle 06 08 2021   grade_7 177 8 98   3 5     0   21   167 145 0   17   2   147       13.0 312 177 8 98   3 5     0   21   167 145 0   17 2 147     13 312
2936712 WA Benton   school 5303930 3017   Kennewick School District 530393000598 4028 Desert Hills Middle School   Regular School No Middle 06 08 2021   grade_7 213 5 45   2 13     0   14   142 150 0   4   0   77       16.0 292 213 5 45   2 13     0   14   142 150 0   4 0 77     16 292
2936748 WA Benton   school 5303930 3017   Kennewick School District 530393000603 3267 Highlands Middle School   Regular School No Middle 06 08 2021   grade_7 78 9 159   1 2     2   11   139 123 0   46   5   202       13.0 262 78 9 159   1 2     2   11   139 123 0   46 5 202     13 262
2936752 WA Benton   school 5303930 3017   Kennewick School District 530393000750 4429 Horse Heaven Hills Middle School   Regular School No Middle 06 08 2021   grade_7 151 2 106   0 2     1   13   141 134 0   26   4   156       13.0 275 151 2 106   0 2     1   13   141 134 0   26 4 156     13 275
2936771 WA Benton   school 5303930 3017   Kennewick School District 530393003258 1884 Legacy High School   Alternative School No High 06 12 2021   grade_7 0 0 2   0 0     0   0   1 1 0   2   0   2       0.0 2 0 0 2   0 0     0   0   1 1 0   2 0 2     0 2
2936793 WA Benton   school 5303930 3017   Kennewick School District 530393003115 1941 Mid-Columbia Parent Partnership   Alternative School No Other KG 12 2021   grade_7 40 1 8   0 0     0   2   31 20 0   1   0   11       2.0 51 40 1 8   0 0     0   2   31 20 0   1 0 11     2 51
2936800 WA Benton   school 5303930 3017   Kennewick School District 530393000607 3472 Park Middle School   Regular School No Middle 06 08 2021   grade_7 49 3 176   0 6     0   8   133 109 0   40   6   213       3.0 242 49 3 176   0 6     0   8   133 109 0   40 6 213     3 242
2937207 WA Benton   school 5304020 3052   Kiona-Benton City School District 530402000639 2904 Kiona-Benton City High School   Regular School No High 09 12 2021   grade_7 0 0 1   0 0     0   0   1 0 0   0   0   1       0.0 1 0 0 1   0 0     0   0   1 0 0   0 0 1     0 1
2937212 WA Benton   school 5304020 3052   Kiona-Benton City School District 530402000640 3961 Kiona-Benton City Middle School   Regular School No Middle 06 08 2021   grade_7 57 0 58   1 0     0   3   59 59 1   31   0   88       5.0 119 57 0 58   1 0     0   3   59 59 1   31 0 88     5 119
2940817 WA Benton   school 5306630 3050   Paterson School District 530663000976 2133 Paterson Elementary School   Regular School No Elementary KG 08 2021   grade_7 7 0 7   0 0     0   0   8 6 0   2   0   14       0.0 14 7 0 7   0 0     0   0   8 6 0   2 0 14     0 14
2941101 WA Benton   school 5306900 3116   Prosser School District 530690001013 2906 Housel Middle School   Regular School No Middle 06 08 2021   grade_7 53 0 148   1 3     0   6   97 114 0   39   9   167       7.0 211 53 0 148   1 3     0   6   97 114 0   39 9 167     7 211
2941874 WA Benton   school 5307320 3400   Richland School District 530732001091 2721 Carmichael Middle School   Regular School No Middle 06 08 2021   grade_7 173 4 92   3 5     0   14   138 153 0   14   1   167       27.0 291 173 4 92   3 5     0   14   138 153 0   14 1 167     27 291
2941878 WA Benton   school 5307320 3400   Richland School District 530732001250 2785 Chief Joseph Middle School   Regular School No Middle 06 08 2021   grade_7 149 5 59   0 7     0   13   131 102 0   13   1   140       13.0 233 149 5 59   0 7     0   13   131 102 0   13 1 140     13 233
2941882 WA Benton   school 5307320 3400   Richland School District 530732002504 3926 Enterprise Middle School   Regular School No Middle 06 08 2021   grade_7 150 2 44   1 9     0   8   113 101 0   11   0   69       13.0 214 150 2 44   1 9     0   8   113 101 0   11 0 69     13 214
2941905 WA Benton   school 5307320 3400   Richland School District 530732003606 5493 Leona Libby Middle School   Regular School No Middle 06 08 2021   grade_7 177 5 40   0 17     0   13   133 119 0   5   0   41       9.0 252 177 5 40   0 17     0   13   133 119 0   5 0 41     9 252
2941957 WA Benton   school 5307320 3400   Richland School District 530732002941 2001 Special Programs   Special Education School No Other PK 12 2021   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
2941979 WA Benton   school 5307320 3400   Richland School District 530732003273 5165 Three Rivers Home Link   Alternative School No Other KG 12 2021   grade_7 48 1 6   0 1     0   1   32 25 0   0   0   10       10.0 57 48 1 6   0 1     0   1   32 25 0   0 0 10     10 57
2932773 WA Chelan   school 5300950 4228   Cascade School District 530095003528 5418 Cascade Home-Link   Regular School No Elementary KG 08 2021   grade_7 6 0 1   0 0     0   0   4 3 0   0   0   1       1.0 7 6 0 1   0 0     0   0   4 3 0   0 0 1     1 7
2932778 WA Chelan   school 5300950 4228   Cascade School District 530095000553 4403 Icicle River Middle School   Regular School No Middle 06 08 2021   grade_7 63 2 31   0 0     0   4   49 51 0   11   7   53       4.0 100 63 2 31   0 0     0   4   49 51 0   11 7 53     4 100
2932799 WA Chelan   school 5300960 4222   CASHMERE SCHOOL DISTRICT 530096000169 2315 CASHMERE MIDDLE SCHOOL   Regular School No Middle 05 08 2021   grade_7 73 2 52   0 1     0   2   69 61 0   14   0   58       4.0 130 73 2 52   0 1     0   2   69 61 0   14 0 58     4 130
2934655 WA Chelan   school 5302550 4127   Entiat School District 530255000374 3317 Entiat Middle and High School   Regular School No High 06 12 2021   grade_7 15 0 10   0 0     0   0   14 11 0   4   1   15       1.0 25 15 0 10   0 0     0   0   14 11 0   4 1 15     1 25
2937331 WA Chelan   school 5301200 4129   Lake Chelan School District 530120000218 2317 Chelan Middle School   Regular School No Middle 06 08 2021   grade_7 38 0 65   0 0     0   0   54 49 0   26   2   65       1.0 103 38 0 65   0 0     0   0   54 49 0   26 2 65     1 103
2938127 WA Chelan   school 5304740 4019   Manson School District 530474003427 5286 Manson Middle School   Regular School No Middle 06 08 2021   grade_7 21 0 42   0 0     0   0   29 34 0   20   2   41       4.0 63 21 0 42   0 0     0   0   29 34 0   20 2 41     4 63
2944369 WA Chelan   school 5308430 4069   Stehekin School District 530843001428 2265 Stehekin Elementary   Regular School No Elementary KG 08 2021   grade_7 1 0 0   0 1     0   0   1 1 0   0   0   0       0.0 2 1 0 0   0 1     0   0   1 1 0   0 0 0     0 2
2946237 WA Chelan   school 5309660 4246   Wenatchee School District 530966001006 4432 Foothills Middle School   Regular School No Middle 06 08 2021   grade_7 92 2 90   1 7     1   5   111 87 0   35   6   99       6.0 198 92 2 90   1 7     1   5   111 87 0   35 6 99     6 198
2946266 WA Chelan   school 5309660 4246   Wenatchee School District 530966001634 3370 Orchard Middle School   Regular School No Middle 06 08 2021   grade_7 42 2 91   0 0     0   4   63 76 0   32   6   95       1.0 139 42 2 91   0 0     0   4   63 76 0   32 6 95     1 139
2946270 WA Chelan   school 5309660 4246   Wenatchee School District 530966001635 3210 Pioneer Middle School   Regular School No Middle 06 08 2021   grade_7 85 0 116   1 1     0   2   127 78 0   40   12   111       10.0 205 85 0 116   1 1     0   2   127 78 0   40 12 111     10 205
2946278 WA Chelan   school 5309660 4246   Wenatchee School District 530966001636 3269 Special Education School   Special Education School No Other PK 09 2021   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
2946297 WA Chelan   school 5309660 4246   Wenatchee School District 530966003678 5569 Valley Academy of Learning K-8   Alternative School No Elementary KG 08 2021   grade_7 20 0 3   0 0     0   0   17 6 0   0   0   0       3.0 23 20 0 3   0 0     0   0   17 6 0   0 0 0     3 23
2946323 WA Chelan   school 5309660 4246   Wenatchee School District 530966003727 5637 Wenatchee Internet Academy   Regular School No Other KG 12 2021   grade_7 14 0 14   0 2     0   1   18 13 0   3   1   11       2.0 31 14 0 14   0 2     0   1   18 13 0   3 1 11     2 31
2932720 WA Clallam   school 5300840 5401   Cape Flattery School District 530084000164 3422 Clallam Bay High & Elementary   Regular School No Other KG 12 2021   grade_7 3 0 1   0 1     0   6   8 3 0   0   0   6       0.0 11 3 0 1   0 1     0   6   8 3 0   0 0 6     0 11
2932736 WA Clallam   school 5300840 5401   Cape Flattery School District 530084000165 3145 Neah Bay Junior/ Senior High School   Regular School No High 06 12 2021   grade_7 0 0 5   17 0     0   8   16 14 0   0   0   25       1.0 30 0 0 5   17 0     0   8   16 14 0   0 0 25     1 30
2933884 WA Clallam   school 5301830 5313   Crescent School District 530183000292 3473 Crescent School   Regular School No Other KG 12 2021   grade_7 12 0 1   3 0     0   2   11 7 0   0   0   12       0.0 18 12 0 1   3 0     0   2   11 7 0   0 0 12     0 18
2933895 WA Clallam   school 5301830 5313   Crescent School District 530183002942 5030 Olympic Peninsula HomeConnection   Alternative School No Other KG 12 2021   grade_7 6 0 1   0 0     0   0   4 3 0   0   0   3       0.0 7 6 0 1   0 0     0   0   4 3 0   0 0 3     0 7
2941030 WA Clallam   school 5306820 5121   Port Angeles School District 530682003728 5611 SEAVIEW ACADEMY   Alternative School No Other KG 12 2021   grade_7 63 0 6   3 1     0   6   43 36 0   0   3   35       6.0 79 63 0 6   3 1     0   6   43 36 0   0 3 35     6 79
2941038 WA Clallam   school 5306820 5121   Port Angeles School District 530682003096 1897 Special Education   Special Education School No Other PK 12 2021   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
2941042 WA Clallam   school 5306820 5121   Port Angeles School District 530682001004 3318 Stevens Middle School   Regular School No Middle 07 08 2021   grade_7 126 3 22   15 4     1   25   99 96 1   0   7   114       13.0 196 126 3 22   15 4     1   25   99 96 1   0 7 114     13 196
2941480 WA Clallam   school   5903   Quileute Tribal School District   5430 Quileute Tribal School             2021   grade_7 1 0 2   8 0     0   0   7 4 0   0   0   8       0.0 11 1 0 2   8 0     0   0   7 4 0   0 0 8     0 11
2941492 WA Clallam   school 5307020 5402   Quillayute Valley School District 530702002507 1671 District Run Home School   Alternative School No Other KG 12 2021   grade_7 2 0 0   0 0     0   0   2 0 0   0   0   1       0.0 2 2 0 0   0 0     0   0   2 0 0   0 0 1     0 2
2941509 WA Clallam   school 5307020 5402   Quillayute Valley School District 530702001046 2609 Forks Middle School   Regular School No Middle 05 08 2021   grade_7 25 0 29   4 0     0   5   30 33 0   8   1   42       4.0 63 25 0 29   4 0     0   5   30 33 0   8 1 42     4 63
2943139 WA Clallam   school 5307830 5323   Sequim School District 530783003729 5613 Dungeness Virtual School   Regular School No Other KG 12 2021   grade_7 9 2 1   0 0     0   0   8 4 0   0   0   3       1.0 12 9 2 1   0 0     0   0   8 4 0   0 0 3     1 12
2943167 WA Clallam   school 5307830 5323   Sequim School District 530783002552 1708 Olympic Peninsula Academy   Alternative School No Other KG 12 2021   grade_7 7 0 2   0 0     0   1   6 4 0   0   0   3       0.0 10 7 0 2   0 0     0   1   6 4 0   0 0 3     0 10
2943173 WA Clallam   school 5307830 5323   Sequim School District 530783002617 4519 Sequim Middle School   Regular School No Middle 06 08 2021   grade_7 134 1 31   2 2     1   15   95 91 0   2   2   74       7.0 186 134 1 31   2 2     1   15   95 91 0   2 2 74     7 186
2931664 WA Clark   school 5300380 6119   Battle Ground School District 530038000048 2671 Amboy Middle School   Regular School No Middle 05 08 2021   grade_7 129 1 7   0 0     1   3   67 74 0   0   2   44       4.0 141 129 1 7   0 0     1   3   67 74 0   0 2 44     4 141
2931679 WA Clark   school 5300380 6119   Battle Ground School District 530038002782 1836 CAM Academy   Alternative School No Other 03 12 2021   grade_7 50 0 2   0 2     0   5   29 30 0   1   0   12       2.0 59 50 0 2   0 2     0   5   29 30 0   1 0 12     2 59
2931692 WA Clark   school 5300380 6119   Battle Ground School District 530038003262 5133 Chief Umtuch Middle   Regular School No Middle 05 08 2021   grade_7 112 0 21   1 0     0   9   70 73 0   6   2   49       5.0 143 112 0 21   1 0     0   9   70 73 0   6 2 49     5 143
2931697 WA Clark   school 5300380 6119   Battle Ground School District 530038003176 5089 Daybreak Middle   Regular School No Middle 05 08 2021   grade_7 88 4 18   1 3     1   9   64 60 0   16   2   56       2.0 124 88 4 18   1 3     1   9   64 60 0   16 2 56     2 124
2931727 WA Clark   school 5300380 6119   Battle Ground School District 530038002857 1875 Homelink River   Alternative School No Other KG 12 2021   grade_7 109 1 7   0 3     0   7   63 64 0   2   0   23       4.0 127 109 1 7   0 3     0   7   63 64 0   2 0 23     4 127
2931734 WA Clark   school 5300380 6119   Battle Ground School District 530038000052 3545 Laurin Middle School   Regular School No Middle 05 08 2021   grade_7 116 2 34   0 11     2   6   90 81 0   14   1   72       6.0 171 116 2 34   0 11     2   6   90 81 0   14 1 72     6 171
2931743 WA Clark   school 5300380 6119   Battle Ground School District 530038003681 4144 Maple Grove Primary   Regular School No Elementary KG 04 2021   grade_7 3 0 0   0 0     0   0   1 2 0   2   0   1       0.0 3 3 0 0   0 0     0   0   1 2 0   2 0 1     0 3
2931752 WA Clark   school 5300380 6119   Battle Ground School District 530038000054 3997 Pleasant Valley Middle   Regular School No Middle 05 08 2021   grade_7 76 3 30   1 7     5   12   59 75 0   3   0   60       8.0 134 76 3 30   1 7     5   12   59 75 0   3 0 60     8 134
2931775 WA Clark   school 5300380 6119   Battle Ground School District 530038003214 5131 Tukes Valley Middle School   Regular School No Middle 05 08 2021   grade_7 108 0 6   0 0     0   8   56 66 0   2   0   32       3.0 122 108 0 6   0 0     0   8   56 66 0   2 0 32     3 122
2932680 WA Clark   school 5300810 6117   Camas School District 530081003066 5054 Liberty Middle School   Regular School No Middle 06 08 2021   grade_7 182 2 31   0 16     1   20   139 113 0   4   5   53       8.0 252 182 2 31   0 16     1   20   139 113 0   4 5 53     8 252
2932684 WA Clark   school 5300810 6117   Camas School District 530081003652 5534 Odyssey Middle School   Regular School No Middle 06 08 2021   grade_7 64 1 6   0 1     0   11   47 35 1   1   0   8       12.0 83 64 1 6   0 1     0   11   47 35 1   1 0 8     12 83
2932697 WA Clark   school 5300810 6117   Camas School District 530081002512 4508 Skyridge Middle School   Regular School No Middle 06 08 2021   grade_7 145 6 36   1 34     0   18   121 119 0   4   0   28       9.0 240 145 6 36   1 34     0   18   121 119 0   4 0 28     9 240
2935052 WA Clark   school 5302700 6114   Evergreen School District (Clark) 530270001270 1646 49th Street Academy   Special Education School No Other KG 12 2021   grade_7 1 0 1   0 0     1   0   1 2 0   0   2   2       0.0 3 1 0 1   0 0     1   0   1 2 0   0 2 2     0 3
2935072 WA Clark   school 5302700 6114   Evergreen School District (Clark) 530270000414 3785 Cascade Middle School   Regular School No Middle 06 08 2021   grade_7 159 8 92   1 13     8   33   156 157 1   42   9   202       3.0 314 159 8 92   1 13     8   33   156 157 1   42 9 202     3 314
2935087 WA Clark   school 5302700 6114   Evergreen School District (Clark) 530270000415 3320 Covington Middle School   Regular School No Middle 06 08 2021   grade_7 184 11 88   3 16     14   20   165 171 0   43   10   213       16.0 336 184 11 88   3 16     14   20   165 171 0   43 10 213     16 336
2935145 WA Clark   school 5302700 6114   Evergreen School District (Clark) 530270002510 4498 Frontier Middle School   Regular School No Middle 06 08 2021   grade_7 130 10 95   0 14     3   20   125 147 0   40   3   141       8.0 272 130 10 95   0 14     3   20   125 147 0   40 3 141     8 272
2935180 WA Clark   school 5302700 6114   Evergreen School District (Clark) 530270003101 1926 Home Choice Academy   Alternative School No Other KG 12 2021   grade_7 28 0 6   0 1     1   3   13 25 1   2   0   24       2.0 39 28 0 6   0 1     1   3   13 25 1   2 0 24     2 39
2935239 WA Clark   school 5302700 6114   Evergreen School District (Clark) 530270001901 4209 Pacific Middle School   Regular School No Middle 06 08 2021   grade_7 202 12 52   2 21     3   38   178 152 0   19   7   123       15.0 330 202 12 52   2 21     3   38   178 152 0   19 7 123     15 330
2935259 WA Clark   school 5302700 6114   Evergreen School District (Clark) 530270002878 4561 Shahala Middle School   Regular School No Middle 06 08 2021   grade_7 145 6 77   1 38     3   28   162 134 2   23   3   101       13.0 298 145 6 77   1 38     3   28   162 134 2   23 3 101     13 298
2935291 WA Clark   school 5302700 6114   Evergreen School District (Clark) 530270000428 4051 Wyeast Middle School   Regular School No Middle 06 08 2021   grade_7 122 10 101   3 7     7   31   157 122 2   34   3   180       10.0 281 122 10 101   3 7     7   31   157 122 2   34 3 180     10 281
2936000 WA Clark   school 5303300 6103   Green Mountain School District 530330000509 2484 Green Mountain School   Regular School No Elementary KG 08 2021   grade_7 11 0 2   0 1     0   1   8 7 0   1   0   3       2.0 15 11 0 2   0 1     0   1   8 7 0   1 0 3     2 15
2936282 WA Clark   school 5303570 6098   Hockinson School District 530357000559 3319 Hockinson Middle School   Regular School No Middle 06 08 2021   grade_7 126 2 11   0 7     1   10   77 79 1   5   2   32       14.0 157 126 2 11   0 7     1   10   77 79 1   5 2 32     14 157
2937284 WA Clark   school 5304170 6101   La Center School District 530417003451 5326 La Center Home School Academy   Alternative School No Other KG 12 2021   grade_7 9 0 0   0 0     0   0   3 6 0   0   0   0       1.0 9 9 0 0   0 0     0   0   3 6 0   0 0 0     1 9
2937289 WA Clark   school 5304170 6101   La Center School District 530417000649 3371 La Center Middle School   Regular School No Middle 06 08 2021   grade_7 120 1 7   1 0     0   2   67 63 1   3   1   28       6.0 131 120 1 7   1 0     0   2   67 63 1   3 1 28     6 131
2942022 WA Clark   school 5307350 6122   Ridgefield School District 530735001108 3891 View Ridge Middle School   Regular School No Middle 07 08 2021   grade_7 238 3 41   1 8     1   18   165 145 0   3   7   85       24.0 310 238 3 41   1 8     1   18   165 145 0   3 7 85     24 310
2945586 WA Clark   school 5309270 6037   Vancouver School District 530927000578 4406 Alki Middle School   Regular School No Middle 06 08 2021   grade_7 178 3 41   1 11     0   23   137 120 0   11   0   69       11.0 257 178 3 41   1 11     0   23   137 120 0   11 0 69     11 257
2945609 WA Clark   school 5309270 6037   Vancouver School District 530927002018 4503 Discovery Middle School   Regular School No Middle 06 08 2021   grade_7 86 8 82   0 6     6   17   99 106 0   29   7   134       4.0 205 86 8 82   0 6     6   17   99 106 0   29 7 134     4 205
2945636 WA Clark   school 5309270 6037   Vancouver School District 530927002408 1574 Fir Grove Childrens Center   Special Education School No Other KG 12 2021   grade_7 5 1 0   0 0     0   0   4 2 0   0   0   5       0.0 6 5 1 0   0 0     0   0   4 2 0   0 0 5     0 6
2945653 WA Clark   school 5309270 6037   Vancouver School District 530927001562 3902 Gaiser Middle School   Regular School No Middle 06 08 2021   grade_7 118 10 104   2 11     11   27   124 159 0   38   11   180       13.0 283 118 10 104   2 11     11   27   124 159 0   38 11 180     13 283
2945702 WA Clark   school 5309270 6037   Vancouver School District 530927001570 3543 Jason Lee Middle School   Regular School No Middle 06 08 2021   grade_7 124 5 49   2 9     3   18   117 93 0   11   5   110       11.0 210 124 5 49   2 9     3   18   117 93 0   11 5 110     11 210
2945734 WA Clark   school 5309270 6037   Vancouver School District 530927001577 3146 Mcloughlin Middle School   Regular School No Middle 06 08 2021   grade_7 107 7 173   3 8     23   17   169 169 0   93   9   269       8.0 338 107 7 173   3 8     23   17   169 169 0   93 9 269     8 338
2945790 WA Clark   school 5309270 6037   Vancouver School District 530927002944 4591 Thomas Jefferson Middle School   Regular School No Middle 06 08 2021   grade_7 180 1 53   2 15     1   25   133 144 0   17   0   73       15.0 277 180 1 53   2 15     1   25   133 144 0   17 0 73     15 277
2945800 WA Clark   school 5309270 6037   Vancouver School District 530927002943 3556 Vancouver Home Connection   Alternative School No Other KG 12 2021   grade_7 8 0 4   2 0     0   2   10 6 0   2   3   11       1.0 16 8 0 4   2 0     0   2   10 6 0   2 3 11     1 16
2945809 WA Clark   school 5309270 6037   Vancouver School District 530927003415 5271 Vancouver iTech Preparatory   Regular School No High 06 12 2021   grade_7 53 2 18   0 7     1   9   62 28 0   4   0   29       11.0 90 53 2 18   0 7     1   9   62 28 0   4 0 29     11 90
2945817 WA Clark   school 5309270 6037   Vancouver School District 530927002508 1689 Vancouver School of Arts and Academics   Regular School No High 06 12 2021   grade_7 59 1 14   0 5     0   14   26 67 0   1   0   23       5.0 93 59 1 14   0 5     0   14   26 67 0   1 0 23     5 93
2945830 WA Clark   school 5309270 6037   Vancouver School District 530927003246 5149 Vancouver Virtual Learning Academy   Alternative School No High 06 12 2021   grade_7 6 1 2   0 0     0   2   6 5 0   2   2   7       1.0 11 6 1 2   0 0     0   2   6 5 0   2 2 7     1 11
2946113 WA Clark   school 5309540 6112   Washougal School District 530954002709 4549 Canyon Creek Middle School   Regular School No Middle 06 08 2021   grade_7 63 0 8   0 1     0   1   39 34 0   0   0   17       2.0 73 63 0 8   0 1     0   1   39 34 0   0 0 17     2 73
2946145 WA Clark   school 5309540 6112   Washougal School District 530954001892 4207 Jemtegaard Middle School   Regular School No Middle 06 08 2021   grade_7 116 2 20   1 1     0   15   87 68 0   5   4   77       8.0 155 116 2 20   1 1     0   15   87 68 0   5 4 77     8 155
2946162 WA Clark   school 5309540 6112   Washougal School District 530954003730 5615 Washougal Learning Academy   Alternative School No Other KG 12 2021   grade_7 15 0 2   0 0     0   0   8 9 0   0   0   4       1.0 17 15 0 2   0 0     0   0   8 9 0   0 0 4     1 17
2934008 WA Columbia   school 5302040 7002   Dayton School District 530204002513 4011 Dayton Middle School   Regular School No Middle 06 08 2021   grade_7 19 0 5   0 0     0   0   13 11 0   0   0   15       0.0 24 19 0 5   0 0     0   0   13 11 0   0 0 15     0 24
2944360 WA Columbia   school 5308400 7035   Starbuck School District 530840001427 2135 Starbuck School   Regular School No Elementary KG 08 2021   grade_7 2 0 0   0 0     0   0   1 1 0   0   0   0       0.0 2 2 0 0   0 0     0   0   1 1 0   0 0 0     0 2
2932823 WA Cowlitz   school 5300990 8401   Castle Rock School District 530099000173 3969 Castle Rock Middle School   Regular School No Middle 06 08 2021   grade_7 109 0 10   1 1     0   9   73 57 0   0   3   59       8.0 130 109 0 10   1 1     0   9   73 57 0   0 3 59     8 130
2936558 WA Cowlitz   school 5303810 8402   Kalama School District 530381000585 2561 Kalama Middle School   Regular School No Middle 06 08 2021   grade_7 67 1 8   0 1     0   0   35 42 0   5   1   28       7.0 77 67 1 8   0 1     0   0   35 42 0   5 1 28     7 77
2936606 WA Cowlitz   school 5300003 8458   Kelso School District 530000300591 3322 Coweeman Middle School   Regular School No Middle 06 08 2021   grade_7 104 0 31   1 2     3   9   71 79 0   14   3   89       5.0 150 104 0 31   1 2     3   9   71 79 0   14 3 89     5 150
2936610 WA Cowlitz   school 5300003 8458   Kelso School District 530000300592 2916 Huntington Middle School   Regular School No Middle 06 08 2021   grade_7 108 0 30   2 3     2   12   82 75 0   10   3   103       7.0 157 108 0 30   2 3     2   12   82 75 0   10 3 103     7 157
2936631 WA Cowlitz   school 5300003 8458   Kelso School District 530000303314 5194 Kelso Virtual Academy   Regular School No Other KG 12 2021   grade_7 46 0 7   0 0     0   4   23 34 0   0   0   14       2.0 57 46 0 7   0 0     0   4   23 34 0   0 0 14     2 57
2937866 WA Cowlitz   school 5304470 8122   Longview School District 530447000699 3475 Cascade Middle School   Regular School No Middle 06 08 2021   grade_7 108 0 39   4 2     0   15   93 75 0   11   2   101       5.0 168 108 0 39   4 2     0   15   93 75 0   11 2 101     5 168
2937904 WA Cowlitz   school 5304470 8122   Longview School District 530447003733 5614 Longview Virtual Academy   Alternative School No High 06 12 2021   grade_7 5 0 1   0 0     0   0   4 2 0   0   0   3       1.0 6 5 0 1   0 0     0   0   4 2 0   0 0 3     1 6
2937921 WA Cowlitz   school 5304470 8122   Longview School District 530447000705 2831 Monticello Middle School   Regular School No Middle 06 08 2021   grade_7 115 4 53   3 6     2   10   92 101 0   12   4   134       14.0 193 115 4 53   3 6     2   10   92 101 0   12 4 134     14 193
2937925 WA Cowlitz   school 5304470 8122   Longview School District 530447002947 4574 Mt. Solo Middle School   Regular School No Middle 06 08 2021   grade_7 111 2 28   1 0     1   6   62 87 0   3   2   88       5.0 149 111 2 28   1 0     1   6   62 87 0   3 2 88     5 149

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