Data source: Big Local News · About: Big Local

658 rows where grade = "grade_7", state = "WA" and year = 2017 sorted by district_state_id

View and edit SQL

year

  • 2017 · 658

grade

  • grade_7 · 658
Link rowid state county county_state_id admin_level district_nces_id district_state_id ▼ district_state_type district school_nces_id school_state_id school school_state_type ccd_school_type ccd_charter_school ccd_school_lvl ccd_school_low_grade ccd_school_high_grade year term grade white black hispanic native_american native_american_alaskan_native asian native_hawaiian asian_pacific_islander native_hawaiian_pacific_islander pacific_islander multiracial unknown_race male female non_binary unknown_gender ell ell_percent homeless homeless_percent low_income free_and_reduced free_and_reduced_percent disability section_504 total white_int black_int hispanic_int native_american_int native_american_alaskan_native_int asian_int native_hawaiian_int asian_pacific_islander_int native_hawaiian_pacific_islander_int pacific_islander_int multiracial_int unknown_race_int male_int female_int non_binary_int unknown_gender_int ell_int homeless_int low_income_int free_and_reduced_int disability_int section_504_int total_int
619748 WA Ferry   school 5301890 10050   Curlew School District 530189000295 2006 Curlew Elem & High School   Regular School No Other KG 12 2017   grade_7 10 0 1   0 0     0   1   4 8 0   0   0   11       1.0 12 10 0 1   0 0     0   1   4 8 0   0 0 11     1 12
626452 WA Ferry   school 5306360 10065   Orient School District 530636000948 2136 Orient Elementary School   Regular School No Elementary KG 08 2017   grade_7 4 0 0   0 0     0   0   2 2 0   0   0   2       0.0 4 4 0 0   0 0     0   0   2 2 0   0 0 2     0 4
622247 WA Ferry   school 5300002 10070   Inchelium School District 530000202870 4214 Inchelium Middle School   Regular School No Middle 06 08 2017   grade_7 0 0 0   13 0     0   3   7 9 0   7   0   12       0.0 16 0 0 0   13 0     0   3   7 9 0   7 0 12     0 16
627763 WA Ferry   school 5307260 10309   Republic School District 530726002949 3559 Republic Junior High   Regular School No Middle 07 08 2017   grade_7 14 1 0   3 1     0   4   17 6 0   0   0   15       2.0 23 14 1 0   3 1     0   4   17 6 0   0 0 15     2 23
627774 WA Ferry   school 5307260 10309   Republic School District 530726002888 1898 Republic Parent Partner   Alternative School No Other KG 12 2017   grade_7 7 0 0   0 0     0   0   6 1 0   0   0   1       0.0 7 7 0 0   0 0     0   0   6 1 0   0 0 1     0 7
626622 WA Franklin   school 5306570 11001   Pasco School District 530657002936 4564 Ellen Ochoa Middle School   Regular School No Middle 07 08 2017   grade_7 6 2 318   0 1     0   5   153 179 0   6   6   325       3.0 332 6 2 318   0 1     0   5   153 179 0   6 6 325     3 332
626681 WA Franklin   school 5306570 11001   Pasco School District 530657000967 2267 Mcloughlin Middle School   Regular School No Middle 07 08 2017   grade_7 257 12 287   1 13     4   35   291 318 0   5   4   311       13.0 609 257 12 287   1 13     4   35   291 318 0   5 4 311     13 609
626733 WA Franklin   school 5306570 11001   Pasco School District 530657000973 3324 Stevens Middle School   Regular School No Middle 07 08 2017   grade_7 32 3 311   0 1     0   2   166 183 0   15   12   335       3.0 349 32 3 311   0 1     0   2   166 183 0   15 12 335     3 349
625351 WA Franklin   school 5305730 11051   North Franklin School District 530573000850 2198 Robert L Olds Junior High School   Regular School No Middle 07 08 2017   grade_7 44 0 132   0 1     0   0   94 83 0   54   0   132       3.0 177 44 0 132   0 1     0   0   94 83 0   54 0 132     3 177
622443 WA Franklin   school 5303780 11056   Kahlotus School District 530378000583 3214 Kahlotus Elem & High   Regular School No Other PK 12 2017   grade_7 1 0 1   0 0     0   0   1 1 0   0   0   1       0.0 2 1 0 1   0 0     0   0   1 1 0   0 0 1     0 2
632016 WA Adams   school 5309570 1109   Washtucna School District 530957001625 3075 Washtucna Elementary/High School   Regular School No Other KG 12 2017   grade_7 8 0 1   0 0     0   0   7 2 0   0   1   6       0.0 9 8 0 1   0 0     0   0   7 2 0   0 1 6     0 9
626535 WA Adams   school 5306480 1147   Othello School District 530648000956 3471 McFarland Middle School   Regular School No Middle 06 08 2017   grade_7 32 0 270   0 0     0   0   167 135 0   100   6   260       8.0 302 32 0 270   0 0     0   0   167 135 0   100 6 260     8 302
623745 WA Adams   school 5304410 1158   Lind School District 530441003416 5293 Lind-Ritzville Middle School   Regular School No Middle 06 08 2017   grade_7 9 0 5   0 0     0   0   3 11 0   4   2   8       0.0 14 9 0 5   0 0     0   0   3 11 0   4 2 8     0 14
627950 WA Adams   school 5307380 1160   Ritzville School District 530738003418 5303 Lind Ritzville Middle School   Regular School No Middle 06 08 2017   grade_7 13 0 2   1 0     0   0   6 10 0   0   0   11       2.0 16 13 0 2   1 0     0   0   6 10 0   0 0 11     2 16
626915 WA Garfield   school 5306780 12110   Pomeroy School District 530678000994 2241 Pomeroy Jr Sr High School   Regular School No High 07 12 2017   grade_7 19 0 1   0 0     0   2   14 8 0   0   0   14       0.0 22 19 0 1   0 0     0   2   14 8 0   0 0 14     0 22
631793 WA Grant   school 5309360 13073   Wahluke School District 530936003264 5144 Wahluke Junior High   Regular School No Middle 06 08 2017   grade_7 7 0 168   1 0     0   0   94 82 0   82   2   173       3.0 176 7 0 168   1 0     0   0   94 82 0   82 2 173     3 176
627478 WA Grant   school 5307080 13144   Quincy School District 530708002714 4536 Monument Elementary   Regular School No Elementary 04 06 2017   grade_7 0 0 1   0 0     0   0   0 1 0   0   0   1       0.0 1 0 0 1   0 0     0   0   0 1 0   0 0 1     0 1
627502 WA Grant   school 5307080 13144   Quincy School District 530708001056 2510 Quincy Middle School   Regular School No Middle 07 08 2017   grade_7 23 0 199   0 0     0   1   113 111 0   78   4   200       7.0 224 23 0 199   0 0     0   1   113 111 0   78 4 200     7 224
631943 WA Grant   school 5309510 13146   Warden School District 530951001620 3909 Warden Middle School   Regular School No Middle 06 08 2017   grade_7 15 1 57   0 0     0   0   30 43 0   21   10   65       0.0 73 15 1 57   0 0     0   0   30 43 0   21 10 65     0 73
629516 WA Grant   school 5308070 13156   Soap Lake School District 530807001335 3089 Soap Lake Middle & High School   Regular School No Other 06 12 2017   grade_7 24 1 17   0 0     0   0   23 19 0   6   1   35       0.0 42 24 1 17   0 0     0   0   23 19 0   6 1 35     0 42
628125 WA Grant   school 5307620 13160   Royal School District 530762001124 3620 Royal Middle School   Regular School No Middle 07 08 2017   grade_7 32 0 112   0 1     0   0   78 67 0   51   11   109       16.0 145 32 0 112   0 1     0   0   78 67 0   51 11 109     16 145
624668 WA Grant   school 5305220 13161   Moses Lake School District 530522000785 3022 Chief Moses Middle School   Regular School No Middle 06 08 2017   grade_7 150 2 141   0 3     0   5   137 164 0   37   4   189       13.0 301 150 2 141   0 3     0   5   137 164 0   37 4 189     13 301
624676 WA Grant   school 5305220 13161   Moses Lake School District 530522003482 5354 Endeavor Middle School   Regular School No Middle 06 08 2017   grade_7 21 2 44   2 0     0   6   35 40 0   16   2   70       3.0 75 21 2 44   2 0     0   6   35 40 0   16 2 70     3 75
624681 WA Grant   school 5305220 13161   Moses Lake School District 530522002625 2673 Frontier Middle School   Regular School No Middle 06 08 2017   grade_7 119 8 111   1 3     0   4   114 132 0   26   5   159       13.0 246 119 8 111   1 3     0   4   114 132 0   26 5 159     13 246
620593 WA Grant   school 5302610 13165   Ephrata School District 530261002934 4229 Beezley Springs Elementary   Special Education School No Elementary PK 01 2017   grade_7 0 0 1   0 0     0   0   0 1 0   0   0   1       0.0 1 0 0 1   0 0     0   0   0 1 0   0 0 1     0 1
620611 WA Grant   school 5302610 13165   Ephrata School District 530261000387 3373 Ephrata Middle School   Regular School No Middle 07 08 2017   grade_7 117 0 44   1 4     0   2   81 87 0   12   5   91       14.0 168 117 0 44   1 4     0   2   81 87 0   12 5 91     14 168
620626 WA Grant   school 5302610 13165   Ephrata School District 530261000388 3092 Grant Elementary   Regular School No Elementary KG 04 2017   grade_7 2 0 3   0 0     0   0   2 3 0   2   0   3       0.0 5 2 0 3   0 0     0   0   2 3 0   2 0 3     0 5
632435 WA Grant   school 5309900 13167   Wilson Creek School District 530990001675 2473 Wilson Creek High   Regular School No High 07 12 2017   grade_7 10 0 2   0 0     0   0   7 5 0   0   0   7       0.0 12 10 0 2   0 0     0   0   7 5 0   0 0 7     0 12
621760 WA Grant   school 5303130 13301   Grand Coulee Dam School District 530313000496 2801 Lake Roosevelt Jr/Sr High School   Regular School No High 07 12 2017   grade_7 20 0 6   17 0     0   13   28 28 0   8   0   31       5.0 56 20 0 6   17 0     0   13   28 28 0   8 0 31     5 56
617047 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000001 2834 A J West Elementary   Regular School No Elementary PK 06 2017   grade_7 0 0 1   0 0     0   0   0 1 0   1   0   1       0.0 1 0 0 1   0 0     0   0   0 1 0   1 0 1     0 1
617062 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003002055 4267 Grays Harbor Juvenile Detention   Regular School No Other 06 12 2017   grade_7 1 0 0   0 0     0   0   1 0 0   0   1   1       0.0 1 1 0 0   0 0     0   0   1 0 0   0 1 1     0 1
617085 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000008 2449 McDermoth Elementary   Regular School No Elementary KG 06 2017   grade_7 0 0 2   0 0     0   0   1 1 0   2   0   1       0.0 2 0 0 2   0 0     0   0   1 1 0   2 0 1     0 2
617089 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000009 2305 Miller Junior High   Regular School No Middle 07 08 2017   grade_7 148 5 58   10 5     0   12   110 128 0   20   14   170       6.0 238 148 5 58   10 5     0   12   110 128 0   20 14 170     6 238
622221 WA Grays Harbor   school 5303660 14028   Hoquiam School District 530366003290 5191 Hoquiam Homelink School   Regular School No Other KG 12 2017   grade_7 3 0 1   0 0     0   0   1 3 0   0   0   4       0.0 4 3 0 1   0 0     0   0   1 3 0   0 0 4     0 4
622226 WA Grays Harbor   school 5303660 14028   Hoquiam School District 530366000565 2391 Hoquiam Middle School   Regular School No Middle 06 08 2017   grade_7 77 1 15   13 0     0   10   58 58 0   3   2   84       0.0 116 77 1 15   13 0     0   10   58 58 0   3 2 84     0 116
625280 WA Grays Harbor   school 5305700 14064   North Beach School District No. 64 530570002039 3788 North Beach Junior High School   Regular School No Middle 07 08 2017   grade_7 39 0 3   10 1     0   2   29 26 0   1   11   45       7.0 55 39 0 3   10 1     0   2   29 26 0   1 11 45     7 55
624268 WA Grays Harbor   school 5304890 14065   McCleary School District 530489000742 2835 Mccleary Elem   Regular School No Elementary PK 08 2017   grade_7 25 0 0   0 0     0   1   9 17 0   0   0   19       1.0 26 25 0 0   0 0     0   1   9 17 0   0 0 19     1 26
624637 WA Grays Harbor   school 5305160 14066   Montesano School District 530516000780 2180 Montesano Jr-Sr High   Regular School No High 07 12 2017   grade_7 81 0 17   3 1     0   6   44 64 0   2   2   51       9.0 108 81 0 17   3 1     0   6   44 64 0   2 2 51     9 108
620502 WA Grays Harbor   school 5302490 14068   Elma School District 530249002060 4245 Elma Middle School   Regular School No Middle 06 08 2017   grade_7 60 0 21   0 2     0   6   42 47 0   8   3   71       3.0 89 60 0 21   0 2     0   6   42 47 0   8 3 71     3 89
630969 WA Grays Harbor   school 5308730 14077   Taholah School District 530873002956 5032 Taholah Elementary & Middle School   Regular School No Elementary KG 08 2017   grade_7 0 0 3   10 0     0   3   6 10 0   0   3   12       0.0 16 0 0 3   10 0     0   3   6 10 0   0 3 12     0 16
623236 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 Other 06 12 2017   grade_7 5 0 7   1 0     0   0   6 7 0   5   1   13       0.0 13 5 0 7   1 0     0   0   6 7 0   5 1 13     0 13
632469 WA Grays Harbor   school 5309990 14117   Wishkah Valley School District 530999001679 3375 Wishkah Valley Elementary/High School   Regular School No Other KG 12 2017   grade_7 16 0 0   0 0     0   0   10 6 0   0   0   10       0.0 16 16 0 0   0 0     0   0   10 6 0   0 0 10     0 16
626082 WA Grays Harbor   school 5306090 14172   Ocosta School District 530609000914 3024 Ocosta Junior - Senior High   Regular School No High 07 12 2017   grade_7 22 1 9   3 1     0   6   22 20 0   3   10   35       2.0 42 22 1 9   3 1     0   6   22 20 0   3 10 35     2 42
626036 WA Grays Harbor   school 5306000 14400   Oakville School District 530600000909 2283 Oakville High School   Regular School No Other 06 12 2017   grade_7 13 0 0   1 0     0   0   5 9 0   0   2   10       0.0 14 13 0 0   1 0     0   0   5 9 0   0 2 10     0 14
625961 WA Island   school 5305940 15201   Oak Harbor School District 530594002628 1758 Homeconnection   Alternative School No Other KG 12 2017   grade_7 14 0 1   0 0     0   0   10 5 0   0   0   3       0.0 15 14 0 1   0 0     0   0   10 5 0   0 0 3     0 15
625973 WA Island   school 5305940 15201   Oak Harbor School District 530594000901 3939 North Whidbey Middle School   Regular School No Middle 06 08 2017   grade_7 114 11 30   0 7     0   14   103 73 0   6   8   94       7.0 176 114 11 30   0 7     0   14   103 73 0   6 8 94     7 176
625991 WA Island   school 5305940 15201   Oak Harbor School District 530594000904 3274 Oak Harbor Intermediate School   Regular School No Middle 06 08 2017   grade_7 124 11 23   2 19     5   19   113 90 0   5   4   70       14.0 203 124 11 23   2 19     5   19   113 90 0   5 4 70     14 203
619688 WA Island   school 5301800 15204   Coupeville School District 530180002049 4004 Coupeville Middle School   Regular School No Middle 06 08 2017   grade_7 53 1 15   0 2     0   7   32 46 0   2   5   32       7.0 78 53 1 15   0 2     0   7   32 46 0   2 5 32     7 78
629695 WA Island   school 5308190 15206   South Whidbey School District 530819002050 1682 South Whidbey Academy   Alternative School No Other KG 12 2017   grade_7 3 0 0   0 0     0   0   2 1 0   0   0   1       0.0 3 3 0 0   0 0     0   0   2 1 0   0 0 1     0 3
629715 WA Island   school 5308190 15206   South Whidbey School District 530819001358 2511 South Whidbey Middle   Regular School No Middle 06 08 2017   grade_7 89 0 8   0 6     1   3   53 54 0   0   3   37       6.0 107 89 0 8   0 6     1   3   53 54 0   0 3 37     6 107
627386 WA Jefferson   school 5301380 16020   Queets-Clearwater School District 530138000243 2491 Queets-Clearwater Elementary   Regular School No Elementary KG 08 2017   grade_7 0 0 0   1 0     0   0   0 1 0   0   0   1       0.0 1 0 0 0   1 0     0   0   0 1 0   0 0 1     0 1
618413 WA Jefferson   school 5300750 16046   Brinnon School District 530075000153 2836 Brinnon Elementary   Regular School No Elementary KG 08 2017   grade_7 5 0 1   0 0     0   1   6 1 0   0   0   7       0.0 7 5 0 1   0 0     0   1   6 1 0   0 0 7     0 7
627400 WA Jefferson   school 5306990 16048   Quilcene School District 530699003353 5236 Partnership for Excellence in Alternative Remote Learning   Alternative School No Elementary KG 08 2017   grade_7 15 0 2   0 0     0   0   6 11 0   0   0   0       0.0 17 15 0 2   0 0     0   0   6 11 0   0 0 0     0 17
627413 WA Jefferson   school 5306990 16048   Quilcene School District 530699001045 2474 Quilcene High And Elementary   Regular School No Other PK 12 2017   grade_7 11 0 2   0 0     0   2   5 10 0   0   0   5       0.0 15 11 0 2   0 0     0   2   5 10 0   0 0 5     0 15
619175 WA Jefferson   school 5301290 16049   Chimacum School District 530129002059 4261 Chimacum Middle School (Closed after 2018-2019 school year)   Regular School No Middle 06 08 2017   grade_7 55 0 7   0 1     0   3   42 24 0   3   3   39       4.0 66 55 0 7   0 1     0   3   42 24 0   3 3 39     4 66
619190 WA Jefferson   school 5301290 16049   Chimacum School District 530129002630 1724 PI Program   Alternative School No Other KG 12 2017   grade_7 8 0 0   1 0     0   0   3 6 0   0   0   2       0.0 9 8 0 0   1 0     0   0   3 6 0   0 0 2     0 9
626995 WA Jefferson   school 5306840 16050   Port Townsend School District 530684001305 4475 Blue Heron Middle School   Regular School No Elementary 04 08 2017   grade_7 67 2 5   1 0     0   4   34 45 0   0   2   41       3.0 79 67 2 5   1 0     0   4   34 45 0   0 2 41     3 79
627007 WA Jefferson   school 5306840 16050   Port Townsend School District 530684002791 1798 OCEAN   Alternative School No Other KG 12 2017   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
628160 WA King   school 5307710 17001   Seattle School District No. 1 530771001249 3774 Aki Kurose Middle School   Regular School No Middle 06 08 2017   grade_7 3 107 51   2 84     3   15   145 120 0   55   34   220       5.0 265 3 107 51   2 84     3   15   145 120 0   55 34 220     5 265
628217 WA King   school 5307710 17001   Seattle School District No. 1 530771003555 5406 Bridges Transition   Special Education School No Other PK 12 2017   grade_7 3 1 0   0 0     0   0   4 0 0   0   1   2       0.0 4 3 1 0   0 0     0   0   4 0 0   0 1 2     0 4
628226 WA King   school 5307710 17001   Seattle School District No. 1 530771001145 2209 Broadview-Thomson K-8 School   Regular School No Elementary PK 08 2017   grade_7 12 10 16   1 8     1   3   24 27 0   11   5   37       3.0 51 12 10 16   1 8     1   3   24 27 0   11 5 37     3 51
628246 WA King   school 5307710 17001   Seattle School District No. 1 530771002635 1751 Cascade Parent Partnership Program (Closed after 2019-2020 school year)   Alternative School No Other KG 12 2017   grade_7 9 1 0   1 0     0   4   13 2 0   0   0   4       1.0 15 9 1 0   1 0     0   4   13 2 0   0 0 4     1 15
628262 WA King   school 5307710 17001   Seattle School District No. 1 530771002017 2838 Catharine Blaine K-8 School   Regular School No Elementary KG 08 2017   grade_7 49 2 4   1 8     0   10   34 40 0   1   1   6       3.0 74 49 2 4   1 8     0   10   34 40 0   1 1 6     3 74
628292 WA King   school 5307710 17001   Seattle School District No. 1 530771001913 2839 David T. Denny International Middle School   Regular School No Middle 06 08 2017   grade_7 52 64 71   9 37     2   20   131 124 0   50   28   187       4.0 255 52 64 71   9 37     2   20   131 124 0   50 28 187     4 255
628312 WA King   school 5307710 17001   Seattle School District No. 1 530771001162 2729 Eckstein Middle School   Regular School No Middle 06 08 2017   grade_7 221 18 27   1 24     0   22   162 151 0   8   12   45       22.0 313 221 18 27   1 24     0   22   162 151 0   8 12 45     22 313
628387 WA King   school 5307710 17001   Seattle School District No. 1 530771001180 2371 Hamilton International Middle School   Regular School No Middle 06 08 2017   grade_7 319 9 19   0 27     1   31   225 181 0   2   4   28       19.0 406 319 9 19   0 27     1   31   225 181 0   2 4 28     19 406
628403 WA King   school 5307710 17001   Seattle School District No. 1 530771003271 5175 Hazel Wolf K-8   Regular School No Elementary KG 08 2017   grade_7 55 8 12   1 5     1   4   45 41 0   1   3   24       9.0 86 55 8 12   1 5     1   4   45 41 0   1 3 24     9 86
628428 WA King   school 5307710 17001   Seattle School District No. 1 530771002928 3496 Interagency Detention School   Regular School No Other 06 12 2017   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
628439 WA King   school 5307710 17001   Seattle School District No. 1 530771001365 1635 Interagency Programs   Alternative School No Other 06 12 2017   grade_7 0 0 1   0 0     0   0   0 1 0   0   1   1       0.0 1 0 0 1   0 0     0   0   0 1 0   0 1 1     0 1
628443 WA King   school 5307710 17001   Seattle School District No. 1 530771003467 5351 Jane Addams Middle School   Regular School No Middle 06 08 2017   grade_7 181 16 34   3 49     0   21   161 143 0   18   13   79       23.0 304 181 16 34   3 49     0   21   161 143 0   18 13 79     23 304
628516 WA King   school 5307710 17001   Seattle School District No. 1 530771001132 3874 Licton Springs K-8   Alternative School No Elementary PK 08 2017   grade_7 6 0 6   1 0     0   3   9 7 0   1   2   10       0.0 16 6 0 6   1 0     0   3   9 7 0   1 2 10     0 16
628526 WA King   school 5307710 17001   Seattle School District No. 1 530771003426 5276 Louisa Boren STEM K-8   Regular School No Elementary PK 08 2017   grade_7 29 9 5   0 10     0   6   26 33 0   2   1   17       2.0 59 29 9 5   0 10     0   6   26 33 0   2 1 17     2 59
628546 WA King   school 5307710 17001   Seattle School District No. 1 530771001207 2435 Madison Middle School   Regular School No Middle 06 08 2017   grade_7 152 29 23   3 20     1   23   122 129 0   11   10   70       14.0 251 152 29 23   3 20     1   23   122 129 0   11 10 70     14 251
628555 WA King   school 5307710 17001   Seattle School District No. 1 530771001216 2069 Madrona K-5 School   Regular School No Elementary PK 08 2017   grade_7 6 14 4   0 0     0   1   11 14 0   2   4   15       1.0 25 6 14 4   0 0     0   1   11 14 0   2 4 15     1 25
628576 WA King   school 5307710 17001   Seattle School District No. 1 530771001212 3517 McClure Middle School   Regular School No Middle 06 08 2017   grade_7 106 9 22   1 19     2   13   77 95 0   6   9   31       14.0 172 106 9 22   1 19     2   13   77 95 0   6 9 31     14 172
628594 WA King   school 5307710 17001   Seattle School District No. 1 530771001136 3095 Mercer International Middle School   Regular School No Middle 06 08 2017   grade_7 37 76 67   1 153     1   19   183 171 0   42   27   250       6.0 354 37 76 67   1 153     1   19   183 171 0   42 27 250     6 354
628656 WA King   school 5307710 17001   Seattle School District No. 1 530771002231 4065 Orca K-8 School   Alternative School No Elementary KG 08 2017   grade_7 3 16 2   0 3     0   1   15 10 0   3   0   20       0.0 25 3 16 2   0 3     0   1   15 10 0   3 0 20     0 25
628666 WA King   school 5307710 17001   Seattle School District No. 1 530771001102 1620 Pathfinder K-8 School   Alternative School No Elementary KG 08 2017   grade_7 28 2 11   0 5     0   8   32 22 0   1   0   12       2.0 54 28 2 11   0 5     0   8   32 22 0   1 0 12     2 54
628679 WA King   school 5307710 17001   Seattle School District No. 1 530771003046 5046 Private School Services   Special Education School No Other PK 12 2017   grade_7 1 2 0   0 0     0   0   2 1 0   0   0   2       0.0 3 1 2 0   0 0     0   0   2 1 0   0 0 2     0 3
628710 WA King   school 5307710 17001   Seattle School District No. 1 530771002873 4263 Residential Consortium   Special Education School No Other PK 12 2017   grade_7 2 1 0   0 1     0   0   2 2 0   1   1   0       0.0 4 2 1 0   0 1     0   0   2 2 0   1 1 0     0 4
628748 WA King   school 5307710 17001   Seattle School District No. 1 530771002716 1796 Salmon Bay K-8 School   Alternative School No Elementary KG 08 2017   grade_7 100 5 9   0 4     0   3   59 62 0   1   2   15       4.0 121 100 5 9   0 4     0   3   59 62 0   1 2 15     4 121
628771 WA King   school 5307710 17001   Seattle School District No. 1 530771001311 1596 Seattle World School   Alternative School No Other 06 12 2017   grade_7 0 6 2   0 6     0   0   9 5 0   6   4   14       0.0 14 0 6 2   0 6     0   0   9 5 0   6 4 14     0 14
628781 WA King   school 5307710 17001   Seattle School District No. 1 530771002933 4218 South Shore PK-8 School   Regular School No Elementary PK 08 2017   grade_7 5 35 10   3 23     0   8   45 39 0   17   4   53       1.0 84 5 35 10   3 23     0   8   45 39 0   17 4 53     1 84
628820 WA King   school 5307710 17001   Seattle School District No. 1 530771001307 1579 Tops K-8 School   Alternative School No Elementary PK 08 2017   grade_7 29 8 2   1 10     0   3   26 27 0   2   1   14       5.0 53 29 8 2   1 10     0   3   26 27 0   2 1 14     5 53
628840 WA King   school 5307710 17001   Seattle School District No. 1 530771001259 4064 Washington Middle School   Regular School No Middle 06 08 2017   grade_7 146 104 19   4 63     2   32   194 176 0   34   38   169       12.0 370 146 104 19   4 63     2   32   194 176 0   34 38 169     12 370
628871 WA King   school 5307710 17001   Seattle School District No. 1 530771001264 3277 Whitman Middle School   Regular School No Middle 06 08 2017   grade_7 180 29 32   4 21     1   23   166 124 0   15   14   90       17.0 290 180 29 32   4 21     1   23   166 124 0   15 14 90     17 290
621232 WA King   school 5302820 17210   Federal Way School District 530282002719 1789 Federal Way Public Academy   Regular School No Other 06 10 2017   grade_7 25 2 11   0 15     1   10   39 25 0   1   0   22       0.0 64 25 2 11   0 15     1   10   39 25 0   1 0 22     0 64
621254 WA King   school 5302820 17210   Federal Way School District 530282000437 3898 Illahee Middle School   Regular School No Middle 05 08 2017   grade_7 72 34 50   1 35     8   30   121 109 0   15   3   133       6.0 230 72 34 50   1 35     8   30   121 109 0   15 3 133     6 230
621266 WA King   school 5302820 17210   Federal Way School District 530282002638 1759 Internet Academy   Alternative School No Other PK 12 2017   grade_7 9 0 4   0 1     0   3   6 11 0   0   0   5       0.0 17 9 0 4   0 1     0   3   6 11 0   0 0 5     0 17
621272 WA King   school 5302820 17210   Federal Way School District 530282000438 3701 Kilo Middle School   Regular School No Middle 06 08 2017   grade_7 60 10 78   1 20     5   19   98 95 0   21   3   139       6.0 193 60 10 78   1 20     5   19   98 95 0   21 3 139     6 193
621297 WA King   school 5302820 17210   Federal Way School District 530282000442 3381 Lakota Middle School   Regular School No Middle 06 08 2017   grade_7 83 30 63   2 25     13   32   137 111 0   25   3   133       11.0 248 83 30 63   2 25     13   32   137 111 0   25 3 133     11 248
621328 WA King   school 5302820 17210   Federal Way School District 530282000444 3625 Nautilus K-8 School   Regular School No Elementary KG 08 2017   grade_7 6 3 7   0 1     0   4   11 10 0   1   0   14       1.0 21 6 3 7   0 1     0   4   11 10 0   1 0 14     1 21
621358 WA King   school 5302820 17210   Federal Way School District 530282000448 3626 Sacajawea Middle School   Regular School No Middle 06 08 2017   grade_7 66 16 82   1 30     20   37   135 117 0   33   3   159       5.0 252 66 16 82   1 30     20   37   135 117 0   33 3 159     5 252
621362 WA King   school 5302820 17210   Federal Way School District 530282001376 4456 Saghalie Middle School (Closed after 2016-2017 school year)   Regular School No Middle 06 08 2017   grade_7 37 29 51   3 13     13   19   98 67 0   27   4   123       4.0 165 37 29 51   3 13     13   19   98 67 0   27 4 123     4 165
621366 WA King   school 5302820 17210   Federal Way School District 530282002964 5029 Sequoyah Middle School   Regular School No Middle 06 08 2017   grade_7 55 35 59   1 26     6   23   105 100 0   26   8   144       4.0 205 55 35 59   1 26     6   23   105 100 0   26 8 144     4 205
621407 WA King   school 5302820 17210   Federal Way School District 530282002961 1951 Support School   Regular School No Other PK 12 2017   grade_7 0 0 0   0 0     0   2   1 1 0   0   0   1       0.0 2 0 0 0   0 0     0   2   1 1 0   0 0 1     0 2
621417 WA King   school 5302820 17210   Federal Way School District 530282003245 5138 Technology Access Foundation Academy (Closed after 2016-2017 school year)   Regular School No Other 06 12 2017   grade_7 16 6 14   0 9     0   7   31 21 0   3   0   27       4.0 52 16 6 14   0 9     0   7   31 21 0   3 0 27     4 52
621432 WA King   school 5302820 17210   Federal Way School District 530282000452 3431 Totem Middle School   Regular School No Middle 06 08 2017   grade_7 36 37 94   2 23     16   31   116 123 0   61   4   180       4.0 239 36 37 94   2 23     16   31   116 123 0   61 4 180     4 239
621464 WA King   school 5302820 17210   Federal Way School District 530282000456 3328 Woodmont K-8 School   Regular School No Elementary KG 08 2017   grade_7 12 3 6   0 2     1   3   14 13 0   0   0   15       0.0 27 12 3 6   0 2     1   3   14 13 0   0 0 15     0 27
620549 WA King   school 5300001 17216   Enumclaw School District 530000102054 4210 Enumclaw Middle School   Regular School No Middle 06 08 2017   grade_7 116 1 18   1 0     1   4   73 68 0   6   6   46       3.0 141 116 1 18   1 0     1   4   73 68 0   6 6 46     3 141

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