Data source: Big Local News · About: Big Local

644 rows where grade = "grade_7", state = "WA" and year = 2016 sorted by district_state_id

View and edit SQL

year

  • 2016 · 644

grade

  • grade_7 · 644
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
522382 WA Ferry   school 5301890 10050   Curlew School District 530189000295 2006 Curlew Elem & High School   Regular School No 4 PK 12 2016   grade_7 19 0 2   2 0     0   2   12 13 0   0   1   17       0.0 25 19 0 2   2 0     0   2   12 13 0   0 1 17     0 25
529029 WA Ferry   school 5306360 10065   Orient School District 530636000948 2136 Orient Elementary School   Regular School No 1 KG 08 2016   grade_7 2 0 0   0 0     0   0   1 1 0   0   0   1       0.0 2 2 0 0   0 0     0   0   1 1 0   0 0 1     0 2
524869 WA Ferry   school 5300002 10070   Inchelium School District 530000202870 4214 Inchelium Middle School   Regular School No 2 06 08 2016   grade_7 0 0 1   13 0     0   2   10 6 0   0   0   11       0.0 16 0 0 1   13 0     0   2   10 6 0   0 0 11     0 16
530334 WA Ferry   school 5307260 10309   Republic School District 530726002949 3559 Republic Junior High   Regular School No 2 07 08 2016   grade_7 10 1 2   0 0     0   3   9 7 0   0   0   11       2.0 16 10 1 2   0 0     0   3   9 7 0   0 0 11     2 16
530346 WA Ferry   school 5307260 10309   Republic School District 530726002888 1898 Republic Parent Partner   Alternative Education School No 4 KG 12 2016   grade_7 2 0 0   0 0     0   0   2 0 0   0   0   1       1.0 2 2 0 0   0 0     0   0   2 0 0   0 0 1     1 2
529177 WA Franklin   school 5306570 11001   Pasco School District 530657003292 5164 Chiawana Senior High School   Regular School No 3 07 12 2016   grade_7 1 0 1   0 1     0   0   1 2 0   0   0   3       0.0 3 1 0 1   0 1     0   0   1 2 0   0 0 3     0 3
529191 WA Franklin   school 5306570 11001   Pasco School District 530657002936 4564 Ellen Ochoa Middle School   Regular School No 2 06 08 2016   grade_7 13 4 341   0 1     0   1   197 163 0   152   2   348       3.0 360 13 4 341   0 1     0   1   197 163 0   152 2 348     3 360
529248 WA Franklin   school 5306570 11001   Pasco School District 530657000967 2267 Mcloughlin Middle School   Regular School No 2 07 08 2016   grade_7 241 10 318   2 17     1   33   313 309 0   77   9   342       10.0 622 241 10 318   2 17     1   33   313 309 0   77 9 342     10 622
529301 WA Franklin   school 5306570 11001   Pasco School District 530657000973 3324 Stevens Middle School   Regular School No 2 07 08 2016   grade_7 18 4 310   0 1     0   3   169 167 0   129   8   322       8.0 336 18 4 310   0 1     0   3   169 167 0   129 8 322     8 336
527926 WA Franklin   school 5305730 11051   North Franklin School District 530573000850 2198 Robert L Olds Junior High School   Regular School No 2 07 08 2016   grade_7 50 1 104   0 2     0   0   83 74 0   26   1   116       6.0 157 50 1 104   0 2     0   0   83 74 0   26 1 116     6 157
525077 WA Franklin   school 5303780 11056   Kahlotus School District 530378000583 3214 Kahlotus Elem & High   Regular School No 4 PK 12 2016   grade_7 2 0 0   0 0     0   0   1 1 0   0   0   1       0.0 2 2 0 0   0 0     0   0   1 1 0   0 0 1     0 2
534681 WA Adams   school 5309570 1109   Washtucna School District 530957001625 3075 Washtucna Elementary/High School   Regular School No 4 PK 12 2016   grade_7 7 0 0   0 0     0   0   5 2 0   0   0   5       0.0 7 7 0 0   0 0     0   0   5 2 0   0 0 5     0 7
529104 WA Adams   school 5306480 1147   Othello School District 530648000956 3471 McFarland Middle School   Regular School No 2 06 08 2016   grade_7 36 1 268   0 3     0   0   181 127 0   82   4   250       8.0 308 36 1 268   0 3     0   0   181 127 0   82 4 250     8 308
526377 WA Adams   school 5304410 1158   Lind School District 530441003416 5293 Lind-Ritzville Middle School   Regular School No 2 06 08 2016   grade_7 11 0 4   0 1     0   0   7 9 0   1   1   11       0.0 16 11 0 4   0 1     0   0   7 9 0   1 1 11     0 16
530519 WA Adams   school 5307380 1160   Ritzville School District 530738003418 5303 Lind Ritzville Middle School   Regular School No 2 06 08 2016   grade_7 19 0 1   1 0     0   0   12 9 0   0   0   8       1.0 21 19 0 1   1 0     0   0   12 9 0   0 0 8     1 21
529478 WA Garfield   school 5306780 12110   Pomeroy School District 530678000994 2241 Pomeroy Jr Sr High School   Regular School No 3 07 12 2016   grade_7 19 0 0   0 1     0   1   11 10 0   0   0   10       0.0 21 19 0 0   0 1     0   1   11 10 0   0 0 10     0 21
534460 WA Grant   school 5309360 13073   Wahluke School District 530936003264 5144 Wahluke Junior High   Regular School No 2 06 08 2016   grade_7 8 0 163   0 0     0   0   87 84 0   74   7   157       1.0 171 8 0 163   0 0     0   0   87 84 0   74 7 157     1 171
530073 WA Grant   school 5307080 13144   Quincy School District 530708001056 2510 Quincy Middle School   Regular School No 2 07 09 2016   grade_7 24 1 165   0 0     0   0   96 94 0   34   2   161       10.0 190 24 1 165   0 0     0   0   96 94 0   34 2 161     10 190
534610 WA Grant   school 5309510 13146   Warden School District 530951001620 3909 Warden Middle School   Regular School No 2 06 08 2016   grade_7 15 0 46   0 0     0   0   34 27 0   8   8   43       6.0 61 15 0 46   0 0     0   0   34 27 0   8 8 43     6 61
532162 WA Grant   school 5308070 13156   Soap Lake School District 530807001335 3089 Soap Lake Middle & High School   Regular School No 4 06 12 2016   grade_7 21 0 13   1 0     0   0   23 12 0   5   7   31       0.0 35 21 0 13   1 0     0   0   23 12 0   5 7 31     0 35
530699 WA Grant   school 5307620 13160   Royal School District 530762001124 3620 Royal Middle School   Regular School No 2 07 08 2016   grade_7 22 0 103   0 0     0   0   63 62 0   43   13   89       9.0 125 22 0 103   0 0     0   0   63 62 0   43 13 89     9 125
527267 WA Grant   school 5305220 13161   Moses Lake School District 530522000785 3022 Chief Moses Middle School   Regular School No 2 06 08 2016   grade_7 158 1 151   0 2     0   7   162 157 0   22   6   207       8.0 319 158 1 151   0 2     0   7   162 157 0   22 6 207     8 319
527273 WA Grant   school 5305220 13161   Moses Lake School District 530522003482 5354 Endeavor Middle School   Regular School No 2 06 08 2016   grade_7 27 2 55   0 0     0   3   43 44 0   19   2   80       0.0 87 27 2 55   0 0     0   3   43 44 0   19 2 80     0 87
527277 WA Grant   school 5305220 13161   Moses Lake School District 530522002625 2673 Frontier Middle School   Regular School No 2 06 08 2016   grade_7 111 5 88   1 4     0   6   115 100 0   14   3   132       7.0 215 111 5 88   1 4     0   6   115 100 0   14 3 132     7 215
523209 WA Grant   school 5302610 13165   Ephrata School District 530261002934 4229 Beezley Springs Elementary   Special Education School No 1 PK 07 2016   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
523226 WA Grant   school 5302610 13165   Ephrata School District 530261000387 3373 Ephrata Middle School   Regular School No 2 06 08 2016   grade_7 141 0 44   0 2     0   3   92 98 0   7   10   104       10.0 190 141 0 44   0 2     0   3   92 98 0   7 10 104     10 190
523240 WA Grant   school 5302610 13165   Ephrata School District 530261000388 3092 Grant Elementary   Regular School No 1 PK 07 2016   grade_7 2 0 2   0 0     0   0   3 1 0   0   0   4       0.0 4 2 0 2   0 0     0   0   3 1 0   0 0 4     0 4
535086 WA Grant   school 5309900 13167   Wilson Creek School District 530990001675 2473 Wilson Creek High   Regular School No 3 07 12 2016   grade_7 12 0 4   1 0     0   0   8 9 0   2   0   12       0.0 17 12 0 4   1 0     0   0   8 9 0   2 0 12     0 17
524382 WA Grant   school 5303130 13301   Grand Coulee Dam School District 530313000496 2801 Lake Roosevelt Jr/Sr High School   Regular School No 3 07 12 2016   grade_7 13 0 4   21 0     1   14   29 24 0   0   0   40       1.0 53 13 0 4   21 0     1   14   29 24 0   0 0 40     1 53
519700 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003002055 4267 Grays Harbor Juvenile Detention   Regular School No 4 06 12 2016   grade_7 0 1 0   0 0     0   0   0 1 0   0   0   1       0.0 1 0 1 0   0 0     0   0   0 1 0   0 0 1     0 1
519723 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000008 2449 McDermoth Elementary   Regular School No 1 KG 08 2016   grade_7 0 0 1   0 0     0   0   1 0 0   0   0   0       0.0 1 0 0 1   0 0     0   0   1 0 0   0 0 0     0 1
519727 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000009 2305 Miller Junior High   Regular School No 2 07 08 2016   grade_7 125 3 71   22 8     0   12   114 127 0   8   11   174       6.0 241 125 3 71   22 8     0   12   114 127 0   8 11 174     6 241
524843 WA Grays Harbor   school 5303660 14028   Hoquiam School District 530366003290 5191 Hoquiam Homelink School   Regular School No 4 KG 12 2016   grade_7 4 0 1   0 0     0   0   4 1 0   0   0   4       0.0 5 4 0 1   0 0     0   0   4 1 0   0 0 4     0 5
524848 WA Grays Harbor   school 5303660 14028   Hoquiam School District 530366000565 2391 Hoquiam Middle School   Regular School No 2 06 08 2016   grade_7 84 1 20   3 1     0   3   60 52 0   4   6   78       3.0 112 84 1 20   3 1     0   3   60 52 0   4 6 78     3 112
527852 WA Grays Harbor   school 5305700 14064   North Beach School District No. 64 530570002039 3788 North Beach Junior High School   Regular School No 2 07 08 2016   grade_7 25 1 5   9 0     0   2   24 18 0   0   6   34       0.0 42 25 1 5   9 0     0   2   24 18 0   0 6 34     0 42
526888 WA Grays Harbor   school 5304890 14065   McCleary School District 530489000742 2835 Mccleary Elem   Regular School No 1 PK 08 2016   grade_7 24 1 1   1 0     0   1   16 12 0   0   1   16       0.0 28 24 1 1   1 0     0   1   16 12 0   0 1 16     0 28
527238 WA Grays Harbor   school 5305160 14066   Montesano School District 530516000780 2180 Montesano Jr-Sr High   Regular School No 3 07 12 2016   grade_7 99 0 15   3 0     0   4   68 53 0   0   0   51       9.0 121 99 0 15   3 0     0   4   68 53 0   0 0 51     9 121
523115 WA Grays Harbor   school 5302490 14068   Elma School District 530249002060 4245 Elma Middle School   Regular School No 2 06 08 2016   grade_7 82 0 22   0 1     0   9   67 50 0   5   1   72       2.0 117 82 0 22   0 1     0   9   67 50 0   5 1 72     2 117
533632 WA Grays Harbor   school 5308730 14077   Taholah School District 530873002956 5032 Taholah Elementary & Middle School   Regular School No 1 PK 08 2016   grade_7 0 0 4   11 0     0   1   10 6 0   0   4   12       0.0 16 0 0 4   11 0     0   1   10 6 0   0 4 12     0 16
525849 WA Grays Harbor   school 5307050 14097   Lake Quinault School District 530705001051 2973 Lake Quinault High School (Closed after 2017-2018 school year)   Regular School No 4 06 12 2016   grade_7 1 0 6   2 0     0   1   7 3 0   1   1   10       0.0 10 1 0 6   2 0     0   1   7 3 0   1 1 10     0 10
535122 WA Grays Harbor   school 5309990 14117   Wishkah Valley School District 530999001679 3375 Wishkah Valley Elementary/High School   Regular School No 4 KG 12 2016   grade_7 21 0 1   0 0     0   0   12 10 0   0   0   11       0.0 22 21 0 1   0 0     0   0   12 10 0   0 0 11     0 22
528662 WA Grays Harbor   school 5306090 14172   Ocosta School District 530609000914 3024 Ocosta Junior - Senior High   Regular School No 3 07 12 2016   grade_7 40 0 9   2 0     0   4   26 29 0   3   5   41       1.0 55 40 0 9   2 0     0   4   26 29 0   3 5 41     1 55
528619 WA Grays Harbor   school 5306000 14400   Oakville School District 530600000909 2283 Oakville High School   Regular School No 3 07 12 2016   grade_7 10 0 3   1 1     0   0   8 7 0   1   2   13       0.0 15 10 0 3   1 1     0   0   8 7 0   1 2 13     0 15
528551 WA Island   school 5305940 15201   Oak Harbor School District 530594002628 1758 Homeconnection   Alternative Education School No 4 KG 12 2016   grade_7 18 0 1   0 0     0   2   12 9 0   0   0   6       0.0 21 18 0 1   0 0     0   2   12 9 0   0 0 6     0 21
528560 WA Island   school 5305940 15201   Oak Harbor School District 530594000901 3939 North Whidbey Middle School   Regular School No 2 06 08 2016   grade_7 99 7 32   2 12     2   22   98 78 0   11   8   98       11.0 176 99 7 32   2 12     2   22   98 78 0   11 8 98     11 176
528577 WA Island   school 5305940 15201   Oak Harbor School District 530594000904 3274 Oak Harbor Intermediate School   Regular School No 2 06 08 2016   grade_7 117 8 17   1 17     1   16   87 90 0   2   5   80       13.0 177 117 8 17   1 17     1   16   87 90 0   2 5 80     13 177
522327 WA Island   school 5301800 15204   Coupeville School District 530180002049 4004 Coupeville Middle School   Regular School No 2 06 08 2016   grade_7 54 0 7   0 3     0   5   29 40 0   3   1   23       7.0 69 54 0 7   0 3     0   5   29 40 0   3 1 23     7 69
532351 WA Island   school 5308190 15206   South Whidbey School District 530819002050 1682 South Whidbey Academy   Alternative Education School No 4 KG 12 2016   grade_7 8 0 1   0 0     0   0   4 5 0   0   0   3       0.0 9 8 0 1   0 0     0   0   4 5 0   0 0 3     0 9
532371 WA Island   school 5308190 15206   South Whidbey School District 530819001358 2511 South Whidbey Middle   Regular School No 2 06 08 2016   grade_7 73 0 5   2 3     0   5   44 44 0   1   8   24       3.0 88 73 0 5   2 3     0   5   44 44 0   1 8 24     3 88
529952 WA Jefferson   school 5301380 16020   Queets-Clearwater School District 530138000243 2491 Queets-Clearwater Elementary   Regular School No 1 KG 08 2016   grade_7 0 0 0   1 0     0   0   0 1 0   0   1   1       0.0 1 0 0 0   1 0     0   0   0 1 0   0 1 1     0 1
521043 WA Jefferson   school 5300750 16046   Brinnon School District 530075000153 2836 Brinnon Elementary   Regular School No 1 KG 08 2016   grade_7 3 0 0   0 0     0   1   3 1 0   0   0   4       0.0 4 3 0 0   0 0     0   1   3 1 0   0 0 4     0 4
529966 WA Jefferson   school 5306990 16048   Quilcene School District 530699003353 5236 Partnership for Excellence in Alternative Remote Learning   Alternative Education School No 1 KG 08 2016   grade_7 9 0 1   0 0     0   0   7 3 0   0   0   0       0.0 10 9 0 1   0 0     0   0   7 3 0   0 0 0     0 10
529979 WA Jefferson   school 5306990 16048   Quilcene School District 530699001045 2474 Quilcene High And Elementary   Regular School No 4 PK 12 2016   grade_7 14 0 1   0 0     0   0   7 8 0   0   1   11       2.0 15 14 0 1   0 0     0   0   7 8 0   0 1 11     2 15
521821 WA Jefferson   school 5301290 16049   Chimacum School District 530129002059 4261 Chimacum Middle School (Closed after 2018-2019 school year)   Regular School No 2 06 08 2016   grade_7 59 2 11   1 0     0   6   28 51 0   0   2   45       5.0 79 59 2 11   1 0     0   6   28 51 0   0 2 45     5 79
521836 WA Jefferson   school 5301290 16049   Chimacum School District 530129002630 1724 PI Program   Alternative Education School No 4 KG 12 2016   grade_7 5 0 1   0 0     0   1   3 4 0   0   0   4       2.0 7 5 0 1   0 0     0   1   3 4 0   0 0 4     2 7
529559 WA Jefferson   school 5306840 16050   Port Townsend School District 530684001305 4475 Blue Heron Middle School   Regular School No 2 04 08 2016   grade_7 57 1 6   0 0     0   2   31 35 0   0   2   44       1.0 66 57 1 6   0 0     0   2   31 35 0   0 2 44     1 66
529571 WA Jefferson   school 5306840 16050   Port Townsend School District 530684002791 1798 OCEAN   Alternative Education School No 4 KG 12 2016   grade_7 5 0 0   0 0     0   0   2 3 0   0   0   2       0.0 5 5 0 0   0 0     0   0   2 3 0   0 0 2     0 5
530741 WA King   school 5307710 17001   Seattle School District No. 1 530771001249 3774 Aki Kurose Middle School   Regular School No 2 06 08 2016   grade_7 12 76 31   1 107     1   16   122 122 0   58   22   206       2.0 244 12 76 31   1 107     1   16   122 122 0   58 22 206     2 244
530805 WA King   school 5307710 17001   Seattle School District No. 1 530771001145 2209 Broadview-Thomson K-8 School   Regular School No 1 PK 08 2016   grade_7 26 13 23   0 9     1   11   33 50 0   12   5   49       6.0 83 26 13 23   0 9     1   11   33 50 0   12 5 49     6 83
530827 WA King   school 5307710 17001   Seattle School District No. 1 530771002635 1751 Cascade Parent Partnership Program (Closed after 2019-2020 school year)   Alternative Education School No 4 KG 12 2016   grade_7 5 1 1   0 0     0   1   5 3 0   1   0   2       0.0 8 5 1 1   0 0     0   1   5 3 0   1 0 2     0 8
530844 WA King   school 5307710 17001   Seattle School District No. 1 530771002017 2838 Catharine Blaine K-8 School   Regular School No 1 KG 08 2016   grade_7 55 1 5   0 1     0   10   31 41 0   0   0   6       2.0 72 55 1 5   0 1     0   10   31 41 0   0 0 6     2 72
530877 WA King   school 5307710 17001   Seattle School District No. 1 530771001913 2839 David T. Denny International Middle School   Regular School No 2 06 08 2016   grade_7 70 70 84   7 43     4   13   159 132 0   26   25   211       4.0 291 70 70 84   7 43     4   13   159 132 0   26 25 211     4 291
530898 WA King   school 5307710 17001   Seattle School District No. 1 530771001162 2729 Eckstein Middle School   Regular School No 2 06 08 2016   grade_7 223 16 14   1 30     1   27   140 172 0   3   3   41       17.0 312 223 16 14   1 30     1   27   140 172 0   3 3 41     17 312
530988 WA King   school 5307710 17001   Seattle School District No. 1 530771001180 2371 Hamilton International Middle School   Regular School No 2 06 08 2016   grade_7 264 10 19   1 33     0   30   200 157 0   5   3   29       18.0 357 264 10 19   1 33     0   30   200 157 0   5 3 29     18 357
531005 WA King   school 5307710 17001   Seattle School District No. 1 530771003271 5175 Hazel Wolf K-8   Regular School No 1 KG 08 2016   grade_7 66 6 6   1 2     0   3   44 40 0   1   5   21       4.0 84 66 6 6   1 2     0   3   44 40 0   1 5 21     4 84
531037 WA King   school 5307710 17001   Seattle School District No. 1 530771002928 3496 Interagency Detention School   Regular School No 4 06 12 2016   grade_7 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
531052 WA King   school 5307710 17001   Seattle School District No. 1 530771003467 5351 Jane Addams Middle School   Regular School No 2 06 08 2016   grade_7 157 34 33   6 49     1   30   154 156 0   18   7   84       6.0 310 157 34 33   6 49     1   30   154 156 0   18 7 84     6 310
531134 WA King   school 5307710 17001   Seattle School District No. 1 530771001132 3874 Licton Springs K-8   Alternative Education School No 1 PK 08 2016   grade_7 6 3 0   0 1     0   1   5 6 0   0   1   6       1.0 11 6 3 0   0 1     0   1   5 6 0   0 1 6     1 11
531165 WA King   school 5307710 17001   Seattle School District No. 1 530771001207 2435 Madison Middle School   Regular School No 2 06 08 2016   grade_7 176 22 26   0 39     1   26   147 143 0   6   9   86       21.0 290 176 22 26   0 39     1   26   147 143 0   6 9 86     21 290
531174 WA King   school 5307710 17001   Seattle School District No. 1 530771001216 2069 Madrona K-5 School   Regular School No 1 PK 08 2016   grade_7 5 11 2   0 1     0   4   9 14 0   1   4   14       0.0 23 5 11 2   0 1     0   4   9 14 0   1 4 14     0 23
531197 WA King   school 5307710 17001   Seattle School District No. 1 530771001212 3517 McClure Middle School   Regular School No 2 06 08 2016   grade_7 128 11 16   1 13     1   9   97 82 0   8   8   31       12.0 179 128 11 16   1 13     1   9   97 82 0   8 8 31     12 179
531217 WA King   school 5307710 17001   Seattle School District No. 1 530771001136 3095 Mercer International Middle School   Regular School No 2 06 08 2016   grade_7 40 98 72   1 164     1   20   196 200 0   65   17   281       8.0 396 40 98 72   1 164     1   20   196 200 0   65 17 281     8 396
531284 WA King   school 5307710 17001   Seattle School District No. 1 530771002231 4065 Orca K-8 School   Alternative Education School No 1 KG 08 2016   grade_7 12 14 4   0 3     0   6   29 10 0   2   1   21       2.0 39 12 14 4   0 3     0   6   29 10 0   2 1 21     2 39
531294 WA King   school 5307710 17001   Seattle School District No. 1 530771001102 1620 Pathfinder K-8 School   Alternative Education School No 1 KG 08 2016   grade_7 35 8 5   0 5     0   6   30 29 0   2   3   12       4.0 59 35 8 5   0 5     0   6   30 29 0   2 3 12     4 59
531308 WA King   school 5307710 17001   Seattle School District No. 1 530771003046 5046 Private School Services   Special Education School No 4 PK 12 2016   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
531340 WA King   school 5307710 17001   Seattle School District No. 1 530771002873 4263 Residential Consortium   Special Education School No 4 PK 12 2016   grade_7 2 0 0   1 0     0   0   2 1 0   0   0   0       0.0 3 2 0 0   1 0     0   0   2 1 0   0 0 0     0 3
531381 WA King   school 5307710 17001   Seattle School District No. 1 530771002716 1796 Salmon Bay K-8 School   Alternative Education School No 1 KG 08 2016   grade_7 80 3 12   2 8     0   11   66 50 0   2   1   19       12.0 116 80 3 12   2 8     0   11   66 50 0   2 1 19     12 116
531407 WA King   school 5307710 17001   Seattle School District No. 1 530771001311 1596 Seattle World School   Alternative Education School No 4 06 12 2016   grade_7 0 4 7   0 4     0   0   10 5 0   15   1   15       0.0 15 0 4 7   0 4     0   0   10 5 0   15 1 15     0 15
531417 WA King   school 5307710 17001   Seattle School District No. 1 530771002933 4218 South Shore PK-8 School   Regular School No 1 PK 08 2016   grade_7 4 48 6   0 18     0   6   49 33 0   13   6   58       1.0 82 4 48 6   0 18     0   6   49 33 0   13 6 58     1 82
531459 WA King   school 5307710 17001   Seattle School District No. 1 530771001307 1579 Tops K-8 School   Alternative Education School No 1 PK 08 2016   grade_7 30 8 3   1 13     0   5   23 37 0   4   1   19       6.0 60 30 8 3   1 13     0   5   23 37 0   4 1 19     6 60
531482 WA King   school 5307710 17001   Seattle School District No. 1 530771001259 4064 Washington Middle School   Regular School No 2 06 08 2016   grade_7 115 106 41   1 69     1   33   188 178 0   34   39   181       10.0 366 115 106 41   1 69     1   33   188 178 0   34 39 181     10 366
531516 WA King   school 5307710 17001   Seattle School District No. 1 530771001264 3277 Whitman Middle School   Regular School No 2 06 08 2016   grade_7 162 29 39   4 28     0   23   149 136 0   24   17   89       10.0 285 162 29 39   4 28     0   23   149 136 0   24 17 89     10 285
523850 WA King   school 5302820 17210   Federal Way School District 530282002719 1789 Federal Way Public Academy   Regular School No 4 06 10 2016   grade_7 22 4 11   0 16     1   9   34 29 0   2   0   21       3.0 63 22 4 11   0 16     1   9   34 29 0   2 0 21     3 63
523870 WA King   school 5302820 17210   Federal Way School District 530282000437 3898 Illahee Middle School   Regular School No 2 05 08 2016   grade_7 70 21 52   1 52     17   39   141 111 0   25   0   134       6.0 252 70 21 52   1 52     17   39   141 111 0   25 0 134     6 252
523882 WA King   school 5302820 17210   Federal Way School District 530282002638 1759 Internet Academy   Alternative Education School No 4 PK 12 2016   grade_7 9 4 1   0 3     0   3   6 14 0   0   0   3       1.0 20 9 4 1   0 3     0   3   6 14 0   0 0 3     1 20
523888 WA King   school 5302820 17210   Federal Way School District 530282000438 3701 Kilo Middle School   Regular School No 2 06 08 2016   grade_7 64 12 67   1 10     8   30   89 103 0   22   3   131       5.0 192 64 12 67   1 10     8   30   89 103 0   22 3 131     5 192
523914 WA King   school 5302820 17210   Federal Way School District 530282000442 3381 Lakota Middle School   Regular School No 2 06 08 2016   grade_7 83 33 62   0 27     17   29   126 125 0   25   4   158       7.0 251 83 33 62   0 27     17   29   126 125 0   25 4 158     7 251
523945 WA King   school 5302820 17210   Federal Way School District 530282000444 3625 Nautilus K-8 School   Regular School No 1 KG 08 2016   grade_7 6 0 4   1 0     1   5   10 7 0   1   1   14       0.0 17 6 0 4   1 0     1   5   10 7 0   1 1 14     0 17
523976 WA King   school 5302820 17210   Federal Way School District 530282000448 3626 Sacajawea Middle School   Regular School No 2 06 08 2016   grade_7 51 29 88   1 33     13   31   124 122 0   31   5   165       3.0 246 51 29 88   1 33     13   31   124 122 0   31 5 165     3 246
523980 WA King   school 5302820 17210   Federal Way School District 530282001376 4456 Saghalie Middle School (Closed after 2016-2017 school year)   Regular School No 2 06 08 2016   grade_7 39 24 64   0 12     9   25   100 73 0   17   5   133       14.0 173 39 24 64   0 12     9   25   100 73 0   17 5 133     14 173
523984 WA King   school 5302820 17210   Federal Way School District 530282002964 5029 Sequoyah Middle School   Regular School No 2 06 08 2016   grade_7 73 30 42   1 26     7   33   98 114 0   15   7   130       8.0 212 73 30 42   1 26     7   33   98 114 0   15 7 130     8 212
524023 WA King   school 5302820 17210   Federal Way School District 530282002961 1951 Support School   Regular School No 4 PK 12 2016   grade_7 0 1 0   0 0     0   2   2 1 0   0   0   2       0.0 3 0 1 0   0 0     0   2   2 1 0   0 0 2     0 3
524031 WA King   school 5302820 17210   Federal Way School District 530282003245 5138 Technology Access Foundation Academy (Closed after 2016-2017 school year)   Regular School No 4 06 12 2016   grade_7 10 8 15   2 8     0   7   28 22 0   3   0   31       4.0 50 10 8 15   2 8     0   7   28 22 0   3 0 31     4 50
524046 WA King   school 5302820 17210   Federal Way School District 530282000452 3431 Totem Middle School   Regular School No 2 06 08 2016   grade_7 30 29 85   4 35     16   25   117 107 0   52   6   175       3.0 224 30 29 85   4 35     16   25   117 107 0   52 6 175     3 224
524078 WA King   school 5302820 17210   Federal Way School District 530282000456 3328 Woodmont K-8 School   Regular School No 1 KG 08 2016   grade_7 8 1 10   0 4     1   2   12 14 0   1   0   16       0.0 26 8 1 10   0 4     1   2   12 14 0   1 0 16     0 26
523162 WA King   school 5300001 17216   Enumclaw School District 530000102054 4210 Enumclaw Middle School   Regular School No 2 06 08 2016   grade_7 111 1 17   2 1     1   3   67 69 0   7   2   55       3.0 136 111 1 17   2 1     1   3   67 69 0   7 2 55     3 136
523182 WA King   school 5300001 17216   Enumclaw School District 530000103038 1523 Special Ed School   Special Education School No 4 PK 12 2016   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
523195 WA King   school 5300001 17216   Enumclaw School District 530000102795 4550 Thunder Mountain Middle School   Regular School No 2 06 08 2016   grade_7 125 0 23   4 1     0   3   81 75 0   12   3   47       4.0 156 125 0 23   4 1     0   3   81 75 0   12 3 47     4 156
527046 WA King   school 5304980 17400   Mercer Island School District 530498000764 3219 Islander Middle School   Regular School No 2 06 08 2016   grade_7 270 4 7   0 65     1   23   206 164 0   4   0   9       54.0 370 270 4 7   0 65     1   23   206 164 0   4 0 9     54 370
524580 WA King   school 5303540 17401   Highline School District 530354002976 5028 Big Picture School   Alternative Education School No 3 07 12 2016   grade_7 17 1 9   1 1     0   6   17 18 0   2   0   19       1.0 35 17 1 9   1 1     0   6   17 18 0   2 0 19     1 35

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