Data source: Big Local News · About: Big Local

844 rows where grade = "grade_6", state = "WA" and year = 2017 sorted by county

View and edit SQL

year

  • 2017 · 844

grade

  • grade_6 · 844
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
618015 WA Adams   school 5300450 1122   Benge School District 530045000118 3142 Benge Elementary   Regular School No Elementary KG 06 2017   grade_6 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
623744 WA Adams   school 5304410 1158   Lind School District 530441003416 5293 Lind-Ritzville Middle School   Regular School No Middle 06 08 2017   grade_6 12 0 4   0 0     0   0   9 7 0   1   2   10       0.0 16 12 0 4   0 0     0   0   9 7 0   1 2 10     0 16
626534 WA Adams   school 5306480 1147   Othello School District 530648000956 3471 McFarland Middle School   Regular School No Middle 06 08 2017   grade_6 28 0 311   0 0     0   2   170 171 0   130   4   292       5.0 341 28 0 311   0 0     0   2   170 171 0   130 4 292     5 341
627949 WA Adams   school 5307380 1160   Ritzville School District 530738003418 5303 Lind Ritzville Middle School   Regular School No Middle 06 08 2017   grade_6 14 0 1   0 0     0   0   9 6 0   1   0   6       0.0 15 14 0 1   0 0     0   0   9 6 0   1 0 6     0 15
632015 WA Adams   school 5309570 1109   Washtucna School District 530957001625 3075 Washtucna Elementary/High School   Regular School No Other KG 12 2017   grade_6 4 0 1   0 0     0   0   3 2 0   0   0   3       0.0 5 4 0 1   0 0     0   0   3 2 0   0 0 3     0 5
617269 WA Asotin   school 5300280 2420   Asotin-Anatone School District 530028000028 2434 Asotin Jr Sr High   Regular School No Other 06 12 2017   grade_6 46 0 3   0 0     0   4   24 29 0   0   1   21       1.0 53 46 0 3   0 0     0   4   24 29 0   0 1 21     1 53
619212 WA Asotin   school 5301320 2250   Clarkston School District 530132000235 2962 Grantham Elementary   Regular School No Elementary KG 06 2017   grade_6 30 1 4   1 0     0   0   25 11 0   0   7   31       2.0 36 30 1 4   1 0     0   0   25 11 0   0 7 31     2 36
619222 WA Asotin   school 5301320 2250   Clarkston School District 530132002433 4384 Heights Elementary   Regular School No Elementary KG 06 2017   grade_6 49 0 4   1 0     0   3   26 31 0   0   0   20       3.0 57 49 0 4   1 0     0   3   26 31 0   0 0 20     3 57
619230 WA Asotin   school 5301320 2250   Clarkston School District 530132000236 3266 Highland Elementary   Regular School No Elementary KG 06 2017   grade_6 43 0 4   0 0     0   5   24 28 0   0   3   37       1.0 52 43 0 4   0 0     0   5   24 28 0   0 3 37     1 52
619242 WA Asotin   school 5301320 2250   Clarkston School District 530132000238 2823 Parkway Elementary   Regular School No Elementary KG 06 2017   grade_6 46 2 3   2 0     0   1   27 27 0   0   0   42       2.0 54 46 2 3   2 0     0   1   27 27 0   0 0 42     2 54
621578 WA Benton   school 5302910 3053   Finley School District 530291002100 4031 Finley Middle School   Regular School No Middle 06 08 2017   grade_6 31 1 37   0 0     0   2   43 28 0   16   0   50       0.0 71 31 1 37   0 0     0   2   43 28 0   16 0 50     0 71
622586 WA Benton   school 5303930 3017   Kennewick School District 530393003586 5439 Chinook Middle School   Regular School No Middle 06 08 2017   grade_6 177 5 87   1 7     2   12   147 144 0   21   1   139       15.0 291 177 5 87   1 7     2   12   147 144 0   21 1 139     15 291
622598 WA Benton   school 5303930 3017   Kennewick School District 530393000598 4028 Desert Hills Middle School   Regular School No Middle 06 08 2017   grade_6 221 7 44   1 6     0   11   136 154 0   5   3   81       10.0 290 221 7 44   1 6     0   11   136 154 0   5 3 81     10 290
622625 WA Benton   school 5303930 3017   Kennewick School District 530393000603 3267 Highlands Middle School   Regular School No Middle 06 08 2017   grade_6 99 8 155   2 1     0   10   131 144 0   62   10   229       7.0 275 99 8 155   2 1     0   10   131 144 0   62 10 229     7 275
622629 WA Benton   school 5303930 3017   Kennewick School District 530393000750 4429 Horse Heaven Hills Middle School   Regular School No Middle 06 08 2017   grade_6 144 2 89   0 4     0   18   130 127 0   24   5   144       9.0 257 144 2 89   0 4     0   18   130 127 0   24 5 144     9 257
622668 WA Benton   school 5303930 3017   Kennewick School District 530393003115 1941 Mid-Columbia Parent Partnership   Alternative School No Other KG 12 2017   grade_6 28 0 4   0 0     0   0   21 11 0   0   0   10       2.0 32 28 0 4   0 0     0   0   21 11 0   0 0 10     2 32
622674 WA Benton   school 5303930 3017   Kennewick School District 530393000607 3472 Park Middle School   Regular School No Middle 06 08 2017   grade_6 44 11 144   0 7     1   7   108 106 0   80   10   196       9.0 214 44 11 144   0 7     1   7   108 106 0   80 10 196     9 214
623092 WA Benton   school 5304020 3052   Kiona-Benton City School District 530402000640 3961 Kiona-Benton City Middle School   Regular School No Middle 06 08 2017   grade_6 49 0 37   0 0     0   4   54 36 0   15   5   66       2.0 90 49 0 37   0 0     0   4   54 36 0   15 5 66     2 90
626771 WA Benton   school 5306630 3050   Paterson School District 530663000976 2133 Paterson Elementary School   Regular School No Elementary KG 08 2017   grade_6 5 0 9   0 0     0   0   9 5 0   4   0   14       0.0 14 5 0 9   0 0     0   0   9 5 0   4 0 14     0 14
627049 WA Benton   school 5306900 3116   Prosser School District 530690001013 2906 Housel Middle School   Regular School No Middle 06 08 2017   grade_6 73 1 124   1 0     0   6   100 105 0   41   6   148       5.0 205 73 1 124   1 0     0   6   100 105 0   41 6 148     5 205
627790 WA Benton   school 5307320 3400   Richland School District 530732001090 4060 Badger Mountain Elementary   Regular School No Elementary KG 05 2017   grade_6 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
627794 WA Benton   school 5307320 3400   Richland School District 530732001091 2721 Carmichael Middle School   Regular School No Middle 06 08 2017   grade_6 203 4 63   1 13     0   17   141 160 0   8   6   126       0.0 301 203 4 63   1 13     0   17   141 160 0   8 6 126     0 301
627798 WA Benton   school 5307320 3400   Richland School District 530732001250 2785 Chief Joseph Middle School   Regular School No Middle 06 08 2017   grade_6 148 6 41   1 8     2   8   102 112 0   18   6   123       0.0 214 148 6 41   1 8     2   8   102 112 0   18 6 123     0 214
627802 WA Benton   school 5307320 3400   Richland School District 530732002504 3926 Enterprise Middle School   Regular School No Middle 06 08 2017   grade_6 277 5 59   4 21     0   13   197 182 0   18   5   123       2.0 379 277 5 59   4 21     0   13   197 182 0   18 5 123     2 379
627877 WA Benton   school 5307320 3400   Richland School District 530732002941 2001 Special Programs   Special Education School No Other PK 12 2017   grade_6 0 0 1   0 0     0   0   0 1 0   0   0   0       0.0 1 0 0 1   0 0     0   0   0 1 0   0 0 0     0 1
627900 WA Benton   school 5307320 3400   Richland School District 530732003273 5165 Three Rivers Home Link   Alternative School No Other KG 12 2017   grade_6 44 0 1   0 1     0   0   28 18 0   0   0   8       0.0 46 44 0 1   0 1     0   0   28 18 0   0 0 8     0 46
618611 WA Chelan   school 5300950 4228   Cascade School District 530095003528 5418 Cascade Home-Link   Regular School No Elementary KG 08 2017   grade_6 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
618616 WA Chelan   school 5300950 4228   Cascade School District 530095000553 4403 Icicle River Middle School   Regular School No Middle 06 08 2017   grade_6 59 0 26   1 0     0   1   45 43 0   11   3   43       3.0 88 59 0 26   1 0     0   1   45 43 0   11 3 43     3 88
618632 WA Chelan   school 5300960 4222   CASHMERE SCHOOL DISTRICT 530096000169 2315 CASHMERE MIDDLE SCHOOL   Regular School No Middle 05 08 2017   grade_6 68 1 37   0 1     0   5   57 55 0   15   3   42       5.0 112 68 1 37   0 1     0   5   57 55 0   15 3 42     5 112
620519 WA Chelan   school 5302550 4127   Entiat School District 530255000374 3317 Entiat Middle and High School   Regular School No Other 06 12 2017   grade_6 17 0 11   0 0     0   0   10 18 0   5   2   20       1.0 28 17 0 11   0 0     0   0   10 18 0   5 2 20     1 28
623207 WA Chelan   school 5301200 4129   Lake Chelan School District 530120000218 2317 Chelan Middle School   Regular School No Middle 06 08 2017   grade_6 44 0 49   0 0     0   1   51 43 0   31   1   69       2.0 94 44 0 49   0 0     0   1   51 43 0   31 1 69     2 94
623220 WA Chelan   school 5301200 4129   Lake Chelan School District 530120000219 3861 Holden Village Community School   Regular School No Other KG 12 2017   grade_6 0 1 0   0 0     0   0   1 0 0   0   0   0       0.0 1 0 1 0   0 0     0   0   1 0 0   0 0 0     0 1
624024 WA Chelan   school 5304740 4019   Manson School District 530474003427 5286 Manson Middle School   Regular School No Middle 06 08 2017   grade_6 18 1 30   1 1     0   0   28 23 0   1   2   43       1.0 51 18 1 30   1 1     0   0   28 23 0   1 2 43     1 51
632086 WA Chelan   school 5309660 4246   Wenatchee School District 530966001006 4432 Foothills Middle School   Regular School No Middle 06 08 2017   grade_6 85 0 85   0 6     0   7   85 98 0   28   6   96       6.0 183 85 0 85   0 6     0   7   85 98 0   28 6 96     6 183
632116 WA Chelan   school 5309660 4246   Wenatchee School District 530966001634 3370 Orchard Middle School   Regular School No Middle 06 08 2017   grade_6 45 1 107   0 0     0   1   83 71 0   55   7   124       10.0 154 45 1 107   0 0     0   1   83 71 0   55 7 124     10 154
632120 WA Chelan   school 5309660 4246   Wenatchee School District 530966001635 3210 Pioneer Middle School   Regular School No Middle 06 08 2017   grade_6 87 2 108   4 1     0   5   111 96 0   61   13   128       12.0 207 87 2 108   4 1     0   5   111 96 0   61 13 128     12 207
632143 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 2017   grade_6 19 1 1   0 0     0   0   11 10 0   0   0   3       1.0 21 19 1 1   0 0     0   0   11 10 0   0 0 3     1 21
632155 WA Chelan   school 5309660 4246   Wenatchee School District 530966001638 2907 Washington Elementary School   Regular School No Elementary KG 05 2017   grade_6 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
618557 WA Clallam   school 5300840 5401   Cape Flattery School District 530084000164 3422 Clallam Bay High & Elementary   Regular School No Other KG 12 2017   grade_6 4 0 0   2 0     0   2   6 2 0   0   0   6       0.0 8 4 0 0   2 0     0   2   6 2 0   0 0 6     0 8
618573 WA Clallam   school 5300840 5401   Cape Flattery School District 530084000165 3145 Neah Bay Junior/ Senior High School   Regular School No Other 06 12 2017   grade_6 2 0 4   12 0     0   4   14 8 0   0   0   17       4.0 22 2 0 4   12 0     0   4   14 8 0   0 0 17     4 22
619704 WA Clallam   school 5301830 5313   Crescent School District 530183000292 3473 Crescent School   Regular School No Other KG 12 2017   grade_6 15 0 0   0 0     0   2   8 9 0   0   0   10       0.0 17 15 0 0   0 0     0   2   8 9 0   0 0 10     0 17
619717 WA Clallam   school 5301830 5313   Crescent School District 530183002942 5030 Olympic Peninsula HomeConnection   Alternative School No Other KG 12 2017   grade_6 6 0 0   0 0     0   1   3 4 0   0   0   4       0.0 7 6 0 0   0 0     0   1   3 4 0   0 0 4     0 7
626924 WA Clallam   school 5306820 5121   Port Angeles School District 530682002505 4494 Dry Creek Elementary   Regular School No Elementary KG 06 2017   grade_6 31 0 6   8 0     0   7   25 27 0   0   1   38       1.0 52 31 0 6   8 0     0   7   25 27 0   0 1 38     1 52
626933 WA Clallam   school 5306820 5121   Port Angeles School District 530682000998 2909 Franklin Elementary   Regular School No Elementary KG 06 2017   grade_6 47 1 7   0 2     0   3   22 38 0   0   0   39       4.0 60 47 1 7   0 2     0   3   22 38 0   0 0 39     4 60
626943 WA Clallam   school 5306820 5121   Port Angeles School District 530682000999 3079 Hamilton Elementary   Regular School No Elementary PK 06 2017   grade_6 34 0 3   4 1     0   9   24 27 0   1   1   32       6.0 51 34 0 3   4 1     0   9   24 27 0   1 1 32     6 51
626952 WA Clallam   school 5306820 5121   Port Angeles School District 530682001000 2368 Jefferson Elementary   Regular School No Elementary PK 06 2017   grade_6 30 0 9   0 0     0   8   23 24 0   1   5   33       4.0 47 30 0 9   0 0     0   8   23 24 0   1 5 33     4 47
626978 WA Clallam   school 5306820 5121   Port Angeles School District 530682003230 5115 Roosevelt Elementary School   Regular School No Elementary KG 06 2017   grade_6 45 0 2   2 2     0   5   31 25 0   0   3   27       1.0 56 45 0 2   2 2     0   5   31 25 0   0 3 27     1 56
626987 WA Clallam   school 5306820 5121   Port Angeles School District 530682001004 3318 Stevens Middle School   Regular School No Middle 07 08 2017   grade_6 2 0 0   0 0     0   0   1 1 0   0   0   2       0.0 2 2 0 0   0 0     0   0   1 1 0   0 0 2     0 2
627427 WA Clallam   school   5903   Quileute Tribal School District   5430 Quileute Tribal School             2017   grade_6 0 1 0   3 0     0   0   2 3 0   0   0   4       0.0 5 0 1 0   3 0     0   0   2 3 0   0 0 4     0 5
627439 WA Clallam   school 5307020 5402   Quillayute Valley School District 530702002507 1671 District Run Home School   Alternative School No Other KG 12 2017   grade_6 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
627462 WA Clallam   school 5307020 5402   Quillayute Valley School District 530702003483 5363 Forks Intermediate School (Closed after 2019-2020 school year)   Regular School No Elementary 04 06 2017   grade_6 50 0 29   2 0     0   6   48 39 0   8   2   50       1.0 87 50 0 29   2 0     0   6   48 39 0   8 2 50     1 87
629041 WA Clallam   school 5307830 5323   Sequim School District 530783002552 1708 Olympic Peninsula Academy   Alternative School No Other PK 12 2017   grade_6 14 0 2   1 0     0   0   10 7 0   0   0   4       0.0 17 14 0 2   1 0     0   0   10 7 0   0 0 4     0 17
629048 WA Clallam   school 5307830 5323   Sequim School District 530783002617 4519 Sequim Middle School   Regular School No Middle 06 08 2017   grade_6 134 1 28   1 1     1   14   88 92 0   2   5   85       3.0 180 134 1 28   1 1     1   14   88 92 0   2 5 85     3 180
617500 WA Clark   school 5300380 6119   Battle Ground School District 530038000048 2671 Amboy Middle School   Regular School No Middle 05 08 2017   grade_6 137 1 2   0 0     0   4   69 75 0   1   1   57       8.0 144 137 1 2   0 0     0   4   69 75 0   1 1 57     8 144
617515 WA Clark   school 5300380 6119   Battle Ground School District 530038002782 1836 CAM Academy   Alternative School No Other 03 12 2017   grade_6 53 0 2   0 0     0   3   26 32 0   0   0   8       3.0 58 53 0 2   0 0     0   3   26 32 0   0 0 8     3 58
617529 WA Clark   school 5300380 6119   Battle Ground School District 530038003262 5133 Chief Umtuch Middle   Regular School No Middle 05 08 2017   grade_6 97 0 20   0 0     0   8   69 57 0   8   2   52       6.0 126 97 0 20   0 0     0   8   69 57 0   8 2 52     6 126
617534 WA Clark   school 5300380 6119   Battle Ground School District 530038003176 5089 Daybreak Middle   Regular School No Middle 05 08 2017   grade_6 101 1 11   1 0     1   6   58 63 0   5   1   49       4.0 121 101 1 11   1 0     1   6   58 63 0   5 1 49     4 121
617561 WA Clark   school 5300380 6119   Battle Ground School District 530038002857 1875 Homelink River   Alternative School No Other KG 12 2017   grade_6 66 1 3   0 0     0   12   37 45 0   2   2   28       1.0 82 66 1 3   0 0     0   12   37 45 0   2 2 28     1 82
617568 WA Clark   school 5300380 6119   Battle Ground School District 530038000052 3545 Laurin Middle School   Regular School No Middle 05 08 2017   grade_6 123 1 13   1 3     1   9   83 69 0   17   4   66       4.0 152 123 1 13   1 3     1   9   83 69 0   17 4 66     4 152
617577 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 2017   grade_6 36 0 8   0 0     0   2   18 28 0   1   2   31       1.0 46 36 0 8   0 0     0   2   18 28 0   1 2 31     1 46
617587 WA Clark   school 5300380 6119   Battle Ground School District 530038000054 3997 Pleasant Valley Middle   Regular School No Middle 05 08 2017   grade_6 90 2 19   2 14     2   5   69 65 0   9   4   46       3.0 134 90 2 19   2 14     2   5   69 65 0   9 4 46     3 134
617614 WA Clark   school 5300380 6119   Battle Ground School District 530038003214 5131 Tukes Valley Middle School   Regular School No Middle 05 08 2017   grade_6 98 0 13   0 0     0   8   49 70 0   4   1   44       3.0 119 98 0 13   0 0     0   8   49 70 0   4 1 44     3 119
618521 WA Clark   school 5300810 6117   Camas School District 530081003066 5054 Liberty Middle School   Regular School No Middle 06 08 2017   grade_6 162 1 28   1 7     1   22   106 116 0   4   3   43       12.0 222 162 1 28   1 7     1   22   106 116 0   4 3 43     12 222
618536 WA Clark   school 5300810 6117   Camas School District 530081002512 4508 Skyridge Middle School   Regular School No Middle 06 08 2017   grade_6 232 2 17   0 32     1   26   157 153 0   10   0   42       25.0 310 232 2 17   0 32     1   26   157 153 0   10 0 42     25 310
620937 WA Clark   school 5302700 6114   Evergreen School District (Clark) 530270000414 3785 Cascade Middle School   Regular School No Middle 06 08 2017   grade_6 191 10 67   2 12     6   31   161 158 0   43   13   199       6.0 319 191 10 67   2 12     6   31   161 158 0   43 13 199     6 319
620950 WA Clark   school 5302700 6114   Evergreen School District (Clark) 530270000415 3320 Covington Middle School   Regular School No Middle 06 08 2017   grade_6 188 7 118   3 7     14   36   195 178 0   90   22   262       7.0 373 188 7 118   3 7     14   36   195 178 0   90 22 262     7 373
621002 WA Clark   school 5302700 6114   Evergreen School District (Clark) 530270002510 4498 Frontier Middle School   Regular School No Middle 06 08 2017   grade_6 184 7 48   2 18     5   24   140 148 0   37   9   145       15.0 288 184 7 48   2 18     5   24   140 148 0   37 9 145     15 288
621038 WA Clark   school 5302700 6114   Evergreen School District (Clark) 530270003101 1926 Home Choice Academy   Alternative School No Other KG 12 2017   grade_6 7 0 1   0 1     0   3   4 8 0   0   0   4       1.0 12 7 0 1   0 1     0   3   4 8 0   0 0 4     1 12
621100 WA Clark   school 5302700 6114   Evergreen School District (Clark) 530270001901 4209 Pacific Middle School   Regular School No Middle 06 08 2017   grade_6 173 5 54   0 24     5   31   164 128 0   23   7   131       9.0 292 173 5 54   0 24     5   31   164 128 0   23 7 131     9 292
621121 WA Clark   school 5302700 6114   Evergreen School District (Clark) 530270002878 4561 Shahala Middle School   Regular School No Middle 06 08 2017   grade_6 208 12 60   0 61     2   35   190 188 0   29   6   120       23.0 378 208 12 60   0 61     2   35   190 188 0   29 6 120     23 378
621154 WA Clark   school 5302700 6114   Evergreen School District (Clark) 530270000428 4051 Wyeast Middle School   Regular School No Middle 06 08 2017   grade_6 137 10 93   1 8     4   35   161 127 0   50   14   183       6.0 288 137 10 93   1 8     4   35   161 127 0   50 14 183     6 288
621884 WA Clark   school 5303300 6103   Green Mountain School District 530330000509 2484 Green Mountain School   Regular School No Elementary KG 08 2017   grade_6 17 0 2   0 0     0   1   13 7 0   1   0   9       0.0 20 17 0 2   0 0     0   1   13 7 0   1 0 9     0 20
622189 WA Clark   school 5303570 6098   Hockinson School District 530357000559 3319 Hockinson Middle School   Regular School No Middle 06 08 2017   grade_6 124 1 5   2 4     1   4   75 66 0   3   0   27       11.0 141 124 1 5   2 4     1   4   75 66 0   3 0 27     11 141
623159 WA Clark   school 5304170 6101   La Center School District 530417003451 5326 La Center Home School Academy   Alternative School No Other KG 12 2017   grade_6 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
623163 WA Clark   school 5304170 6101   La Center School District 530417000649 3371 La Center Middle School   Regular School No Middle 06 08 2017   grade_6 103 2 9   2 1     0   6   70 53 0   3   2   30       8.0 123 103 2 9   2 1     0   6   70 53 0   3 2 30     8 123
627934 WA Clark   school 5307350 6122   Ridgefield School District 530735001106 3321 South Ridge Elementary   Regular School No Elementary KG 06 2017   grade_6 60 1 12   0 5     0   6   45 39 0   6   7   30       2.0 84 60 1 12   0 5     0   6   45 39 0   6 7 30     2 84
627943 WA Clark   school 5307350 6122   Ridgefield School District 530735001107 3786 Union Ridge Elementary   Regular School No Elementary KG 06 2017   grade_6 102 0 14   1 1     0   7   56 69 0   3   4   40       6.0 125 102 0 14   1 1     0   7   56 69 0   3 4 40     6 125
631439 WA Clark   school 5309270 6037   Vancouver School District 530927000578 4406 Alki Middle School   Regular School No Middle 06 08 2017   grade_6 175 5 16   1 7     0   14   110 108 0   8   0   54       7.0 218 175 5 16   1 7     0   14   110 108 0   8 0 54     7 218
631462 WA Clark   school 5309270 6037   Vancouver School District 530927002018 4503 Discovery Middle School   Regular School No Middle 06 08 2017   grade_6 110 10 102   1 8     1   17   124 125 0   37   18   196       8.0 249 110 10 102   1 8     1   17   124 125 0   37 18 196     8 249
631489 WA Clark   school 5309270 6037   Vancouver School District 530927002408 1574 Fir Grove Childrens Center   Special Education School No Other KG 12 2017   grade_6 0 0 4   1 0     0   1   6 0 0   0   0   3       0.0 6 0 0 4   1 0     0   1   6 0 0   0 0 3     0 6
631506 WA Clark   school 5309270 6037   Vancouver School District 530927001562 3902 Gaiser Middle School   Regular School No Middle 06 08 2017   grade_6 146 9 80   3 14     5   19   142 134 0   36   11   175       9.0 276 146 9 80   3 14     5   19   142 134 0   36 11 175     9 276
631555 WA Clark   school 5309270 6037   Vancouver School District 530927001570 3543 Jason Lee Middle School   Regular School No Middle 06 08 2017   grade_6 151 4 52   0 15     3   20   135 110 0   27   3   107       8.0 245 151 4 52   0 15     3   20   135 110 0   27 3 107     8 245
631586 WA Clark   school 5309270 6037   Vancouver School District 530927001577 3146 Mcloughlin Middle School   Regular School No Middle 06 08 2017   grade_6 109 14 156   1 12     14   23   152 177 0   91   24   275       8.0 329 109 14 156   1 12     14   23   152 177 0   91 24 275     8 329
631640 WA Clark   school 5309270 6037   Vancouver School District 530927002944 4591 Thomas Jefferson Middle School   Regular School No Middle 06 08 2017   grade_6 207 3 27   4 4     2   24   129 142 0   8   3   74       6.0 271 207 3 27   4 4     2   24   129 142 0   8 3 74     6 271
631658 WA Clark   school 5309270 6037   Vancouver School District 530927002943 3556 Vancouver Home Connection   Alternative School No Other KG 12 2017   grade_6 12 0 3   0 0     0   1   6 10 0   0   0   9       1.0 16 12 0 3   0 0     0   1   6 10 0   0 0 9     1 16
631668 WA Clark   school 5309270 6037   Vancouver School District 530927003415 5271 Vancouver iTech Preparatory   Regular School No Other 06 12 2017   grade_6 33 1 14   0 2     0   8   39 19 0   0   0   24       7.0 58 33 1 14   0 2     0   8   39 19 0   0 0 24     7 58
631676 WA Clark   school 5309270 6037   Vancouver School District 530927002508 1689 Vancouver School of Arts and Academics   Regular School No Other 06 12 2017   grade_6 72 2 11   1 4     1   3   30 64 0   0   0   15       2.0 94 72 2 11   1 4     1   3   30 64 0   0 0 15     2 94
631684 WA Clark   school 5309270 6037   Vancouver School District 530927003246 5149 Vancouver Virtual Learning Academy   Alternative School No Other 06 12 2017   grade_6 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
631966 WA Clark   school 5309540 6112   Washougal School District 530954002709 4549 Canyon Creek Middle School   Regular School No Middle 06 08 2017   grade_6 69 0 4   1 0     0   5   42 37 0   1   3   24       6.0 79 69 0 4   1 0     0   5   42 37 0   1 3 24     6 79
631996 WA Clark   school 5309540 6112   Washougal School District 530954001892 4207 Jemtegaard Middle School   Regular School No Middle 06 08 2017   grade_6 154 0 24   0 0     1   14   94 99 0   9   7   84       9.0 193 154 0 24   0 0     1   14   94 99 0   9 7 84     9 193
619822 WA Columbia   school 5302040 7002   Dayton School District 530204002513 4011 Dayton Middle School   Regular School No Middle 06 08 2017   grade_6 23 0 5   1 1     0   0   17 13 0   0   2   17       2.0 30 23 0 5   1 1     0   0   17 13 0   0 2 17     2 30
618657 WA Cowlitz   school 5300990 8401   Castle Rock School District 530099000173 3969 Castle Rock Middle School   Regular School No Middle 06 08 2017   grade_6 71 0 11   2 0     0   5   48 41 0   3   1   46       9.0 89 71 0 11   2 0     0   5   48 41 0   3 1 46     9 89
622461 WA Cowlitz   school 5303810 8402   Kalama School District 530381000585 2561 Kalama Middle School   Regular School No Other 06 12 2017   grade_6 59 1 8   1 1     0   1   36 35 0   0   4   31       5.0 71 59 1 8   1 1     0   1   36 35 0   0 4 31     5 71
622513 WA Cowlitz   school 5300003 8458   Kelso School District 530000300591 3322 Coweeman Middle School   Regular School No Middle 06 08 2017   grade_6 134 1 42   3 2     2   12   103 93 0   16   4   123       9.0 196 134 1 42   3 2     2   12   103 93 0   16 4 123     9 196
622517 WA Cowlitz   school 5300003 8458   Kelso School District 530000300592 2916 Huntington Middle School   Regular School No Middle 06 08 2017   grade_6 161 0 43   0 1     6   8   112 107 0   19   7   145       8.0 219 161 0 43   0 1     6   8   112 107 0   19 7 145     8 219
623758 WA Cowlitz   school 5304470 8122   Longview School District 530447000699 3475 Cascade Middle School   Regular School No Middle 06 08 2017   grade_6 100 2 44   4 3     0   17   89 81 0   15   11   111       6.0 170 100 2 44   4 3     0   17   89 81 0   15 11 111     6 170
623806 WA Cowlitz   school 5304470 8122   Longview School District 530447000705 2831 Monticello Middle School   Regular School No Middle 06 08 2017   grade_6 101 5 38   2 0     3   13   75 87 0   11   11   125       8.0 162 101 5 38   2 0     3   13   75 87 0   11 11 125     8 162
623810 WA Cowlitz   school 5304470 8122   Longview School District 530447002947 4574 Mt. Solo Middle School   Regular School No Middle 06 08 2017   grade_6 100 0 19   1 2     0   11   68 65 0   8   7   73       13.0 133 100 0 19   1 2     0   11   68 65 0   8 7 73     13 133
631199 WA Cowlitz   school 5309030 8130   Toutle Lake School District 530903002069 4264 Toutle Lake Elementary   Regular School No Elementary KG 06 2017   grade_6 40 0 5   2 0     0   1   24 24 0   0   1   24       2.0 48 40 0 5   2 0     0   1   24 24 0   0 1 24     2 48
632497 WA Cowlitz   school 5310050 8404   Woodland School District 531005003371 5246 Lewis River Academy   Alternative School No Other KG 12 2017   grade_6 6 0 3   0 0     0   0   5 4 0   0   0   4       0.0 9 6 0 3   0 0     0   0   5 4 0   0 0 4     0 9

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