Data source: Big Local News · About: Big Local

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

View and edit SQL

year

  • 2019 · 650

grade

  • grade_7 · 650
Link rowid state county county_state_id admin_level district_nces_id district_state_id ▼ district_state_type district school_nces_id school_state_id school school_state_type ccd_school_type ccd_charter_school ccd_school_lvl ccd_school_low_grade ccd_school_high_grade year term grade white black hispanic native_american native_american_alaskan_native asian native_hawaiian asian_pacific_islander native_hawaiian_pacific_islander pacific_islander multiracial unknown_race male female non_binary unknown_gender ell ell_percent homeless homeless_percent low_income free_and_reduced free_and_reduced_percent disability section_504 total white_int black_int hispanic_int native_american_int native_american_alaskan_native_int asian_int native_hawaiian_int asian_pacific_islander_int native_hawaiian_pacific_islander_int pacific_islander_int multiracial_int unknown_race_int male_int female_int non_binary_int unknown_gender_int ell_int homeless_int low_income_int free_and_reduced_int disability_int section_504_int total_int
2415691 WA Ferry   school 5301890 10050   Curlew School District 530189000295 2006 Curlew Elem & High School   Regular School No Other PK 12 2019   grade_7 11 0 2   1 0     0   0   7 7 0   0   1   14       0.0 14 11 0 2   1 0     0   0   7 7 0   0 1 14     0 14
2422185 WA Ferry   school 5306360 10065   Orient School District 530636000948 2136 Orient Elementary School   Regular School No Elementary KG 08 2019   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
2418129 WA Ferry   school 5300002 10070   Inchelium School District 530000202870 4214 Inchelium Middle School   Regular School No Middle 06 08 2019   grade_7 0 0 0   15 0     0   5   9 11 0   11   0   17       0.0 20 0 0 0   15 0     0   5   9 11 0   11 0 17     0 20
2423467 WA Ferry   school 5307260 10309   Republic School District 530726002949 3559 Republic Junior High   Regular School No Middle 06 08 2019   grade_7 14 0 1   1 0     0   1   7 10 0   0   0   12       0.0 17 14 0 1   1 0     0   1   7 10 0   0 0 12     0 17
2423479 WA Ferry   school 5307260 10309   Republic School District 530726002888 1898 Republic Parent Partner   Alternative School No Other KG 12 2019   grade_7 4 0 0   0 0     0   0   3 1 0   0   0   0       0.0 4 4 0 0   0 0     0   0   3 1 0   0 0 0     0 4
2422340 WA Franklin   school 5306570 11001   Pasco School District 530657003292 5164 Chiawana Senior High School   Regular School No High 08 12 2019   grade_7 0 0 2   0 0     0   0   2 0 0   1   0   2       0.0 2 0 0 2   0 0     0   0   2 0 0   1 0 2     0 2
2422352 WA Franklin   school 5306570 11001   Pasco School District 530657002936 4564 Ellen Ochoa Middle School   Regular School No Middle 07 08 2019   grade_7 26 4 340   0 3     0   5   185 193 0   211   10   359       2.0 378 26 4 340   0 3     0   5   185 193 0   211 10 359     2 378
2422366 WA Franklin   school 5306570 11001   Pasco School District 530657003547 5393 Internet Pasco Academy of Learning   Alternative School No Elementary KG 08 2019   grade_7 1 0 0   0 0     0   0   0 1 0   0   0   1       0.0 1 1 0 0   0 0     0   0   0 1 0   0 0 1     0 1
2422409 WA Franklin   school 5306570 11001   Pasco School District 530657000967 2267 Mcloughlin Middle School   Regular School No Middle 07 08 2019   grade_7 311 5 313   2 11     2   34   338 340 0   73   6   365       23.0 678 311 5 313   2 11     2   34   338 340 0   73 6 365     23 678
2422462 WA Franklin   school 5306570 11001   Pasco School District 530657000973 3324 Stevens Middle School   Regular School No Middle 07 08 2019   grade_7 46 4 314   0 3     0   3   211 159 0   192   23   344       3.0 370 46 4 314   0 3     0   3   211 159 0   192 23 344     3 370
2421155 WA Franklin   school 5305730 11051   North Franklin School District 530573000850 2198 Robert L Olds Junior High School   Regular School No Middle 07 08 2019   grade_7 41 0 118   0 2     0   1   88 74 0   56   1   126       4.0 162 41 0 118   0 2     0   1   88 74 0   56 1 126     4 162
2418321 WA Franklin   school 5303780 11056   Kahlotus School District 530378000583 3214 Kahlotus Elem & High   Regular School No Other PK 12 2019   grade_7 5 0 1   0 0     0   0   1 5 0   0   0   4       1.0 6 5 0 1   0 0     0   0   1 5 0   0 0 4     1 6
2427705 WA Adams   school 5309570 1109   Washtucna School District 530957001625 3075 Washtucna Elementary/High School   Regular School No Other PK 12 2019   grade_7 3 0 0   0 0     0   0   2 1 0   0   0   3       0.0 3 3 0 0   0 0     0   0   2 1 0   0 0 3     0 3
2422268 WA Adams   school 5306480 1147   Othello School District 530648000956 3471 McFarland Middle School   Regular School No Middle 06 08 2019   grade_7 25 0 317   0 2     0   2   178 169 0   120   6   303       13.0 347 25 0 317   0 2     0   2   178 169 0   120 6 303     13 347
2419633 WA Adams   school 5304410 1158   Lind School District 530441003416 5293 Lind-Ritzville Middle School   Regular School No Middle 06 08 2019   grade_7 10 0 5   0 0     0   0   6 9 0   2   2   11       1.0 15 10 0 5   0 0     0   0   6 9 0   2 2 11     1 15
2423654 WA Adams   school 5307380 1160   Ritzville School District 530738003418 5303 Lind Ritzville Middle School   Regular School No Middle 06 08 2019   grade_7 21 0 5   1 1     0   1   16 13 0   0   3   13       1.0 29 21 0 5   1 1     0   1   16 13 0   0 3 13     1 29
2422640 WA Garfield   school 5306780 12110   Pomeroy School District 530678000994 2241 Pomeroy Jr Sr High School   Regular School No High 07 12 2019   grade_7 21 1 1   0 3     0   2   12 16 0   0   0   19       1.0 28 21 1 1   0 3     0   2   12 16 0   0 0 19     1 28
2427494 WA Grant   school 5309360 13073   Wahluke School District 530936003264 5144 Wahluke Junior High   Regular School No Middle 06 08 2019   grade_7 2 0 202   2 0     0   0   103 103 0   86   20   190       4.0 206 2 0 202   2 0     0   0   103 103 0   86 20 190     4 206
2423184 WA Grant   school 5307080 13144   Quincy School District 530708002714 4536 Monument Elementary   Regular School No Middle 04 06 2019   grade_7 0 0 2   0 0     0   0   1 1 0   2   0   2       0.0 2 0 0 2   0 0     0   0   1 1 0   2 0 2     0 2
2423208 WA Grant   school 5307080 13144   Quincy School District 530708001056 2510 Quincy Middle School   Regular School No Middle 07 08 2019   grade_7 20 0 224   0 0     0   0   135 109 0   109   4   213       9.0 244 20 0 224   0 0     0   0   135 109 0   109 4 213     9 244
2427631 WA Grant   school 5309510 13146   Warden School District 530951001620 3909 Warden Middle School   Regular School No Middle 06 08 2019   grade_7 15 0 70   0 0     0   0   41 44 0   27   7   84       1.0 85 15 0 70   0 0     0   0   41 44 0   27 7 84     1 85
2425213 WA Grant   school 5308070 13156   Soap Lake School District 530807001335 3089 Soap Lake Middle & High School   Regular School No High 06 12 2019   grade_7 32 0 13   1 2     0   2   23 27 0   7   4   48       1.0 50 32 0 13   1 2     0   2   23 27 0   7 4 48     1 50
2423828 WA Grant   school 5307620 13160   Royal School District 530762001124 3620 Royal Middle School   Regular School No Middle 07 08 2019   grade_7 22 0 110   0 0     0   0   61 71 0   54   13   113       8.0 132 22 0 110   0 0     0   0   61 71 0   54 13 113     8 132
2420503 WA Grant   school 5305220 13161   Moses Lake School District 530522000785 3022 Chief Moses Middle School   Regular School No Middle 06 08 2019   grade_7 149 3 147   0 5     1   7   173 139 0   47   3   196       12.0 312 149 3 147   0 5     1   7   173 139 0   47 3 196     12 312
2420512 WA Grant   school 5305220 13161   Moses Lake School District 530522003482 5354 Endeavor Middle School   Regular School No Middle 06 08 2019   grade_7 16 3 68   0 0     0   5   43 49 0   29   2   85       5.0 92 16 3 68   0 0     0   5   43 49 0   29 2 85     5 92
2420516 WA Grant   school 5305220 13161   Moses Lake School District 530522002625 2673 Frontier Middle School   Regular School No Middle 06 08 2019   grade_7 102 6 115   1 3     0   5   115 117 0   31   5   149       7.0 232 102 6 115   1 3     0   5   115 117 0   31 5 149     7 232
2416537 WA Grant   school 5302610 13165   Ephrata School District 530261000387 3373 Ephrata Middle School   Regular School No Middle 07 08 2019   grade_7 140 0 77   1 0     0   5   121 102 0   21   7   121       19.0 223 140 0 77   1 0     0   5   121 102 0   21 7 121     19 223
2428119 WA Grant   school 5309900 13167   Wilson Creek School District 530990001675 2473 Wilson Creek High   Regular School No High 07 12 2019   grade_7 9 1 1   0 0     0   0   4 7 0   0   1   8       0.0 11 9 1 1   0 0     0   0   4 7 0   0 1 8     0 11
2417664 WA Grant   school 5303130 13301   Grand Coulee Dam School District 530313000496 2801 Lake Roosevelt Jr/Sr High School   Regular School No High 07 12 2019   grade_7 18 0 8   18 0     0   12   25 31 0   6   2   37       0.0 56 18 0 8   18 0     0   12   25 31 0   6 2 37     0 56
2412998 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000001 2834 A J West Elementary   Regular School No Elementary PK 06 2019   grade_7 0 0 1   0 0     0   0   1 0 0   1   0   1       0.0 1 0 0 1   0 0     0   0   1 0 0   1 0 1     0 1
2413013 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003003633 5514 Grays Harbor Academy   Alternative School No Other 03 12 2019   grade_7 1 0 0   0 0     0   0   1 0 0   0   0   1       0.0 1 1 0 0   0 0     0   0   1 0 0   0 0 1     0 1
2413043 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000009 2305 Miller Junior High   Regular School No Middle 07 08 2019   grade_7 132 5 79   13 6     0   24   122 137 0   25   10   176       8.0 259 132 5 79   13 6     0   24   122 137 0   25 10 176     8 259
2418100 WA Grays Harbor   school 5303660 14028   Hoquiam School District 530366003290 5191 Hoquiam Homelink School   Regular School No Other KG 12 2019   grade_7 5 0 0   0 0     0   0   2 3 0   0   0   4       1.0 5 5 0 0   0 0     0   0   2 3 0   0 0 4     1 5
2418105 WA Grays Harbor   school 5303660 14028   Hoquiam School District 530366000565 2391 Hoquiam Middle School   Regular School No Middle 06 08 2019   grade_7 87 0 30   5 0     0   8   69 61 0   6   5   94       2.0 130 87 0 30   5 0     0   8   69 61 0   6 5 94     2 130
2421079 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 2019   grade_7 30 1 2   5 1     0   7   28 18 0   1   5   32       0.0 46 30 1 2   5 1     0   7   28 18 0   1 5 32     0 46
2421093 WA Grays Harbor   school 5305700 14064   North Beach School District No. 64 530570000844 3787 Ocean Shores Elementary   Regular School No Elementary PK 06 2019   grade_7 0 0 0   1 0     0   0   1 0 0   0   0   1       0.0 1 0 0 0   1 0     0   0   1 0 0   0 0 1     0 1
2420113 WA Grays Harbor   school 5304890 14065   McCleary School District 530489000742 2835 Mccleary Elem   Regular School No Elementary PK 08 2019   grade_7 16 0 1   2 1     0   1   12 9 0   0   1   11       5.0 21 16 0 1   2 1     0   1   12 9 0   0 1 11     5 21
2420472 WA Grays Harbor   school 5305160 14066   Montesano School District 530516000780 2180 Montesano Jr-Sr High   Regular School No High 07 12 2019   grade_7 73 0 13   1 1     0   6   49 45 0   2   1   34       4.0 94 73 0 13   1 1     0   6   49 45 0   2 1 34     4 94
2416423 WA Grays Harbor   school 5302490 14068   Elma School District 530249002060 4245 Elma Middle School   Regular School No Middle 06 08 2019   grade_7 84 1 26   3 1     0   6   65 56 0   8   0   91       8.0 121 84 1 26   3 1     0   6   65 56 0   8 0 91     8 121
2426670 WA Grays Harbor   school 5308730 14077   Taholah School District 530873002956 5032 Taholah Elementary & Middle School   Regular School No Elementary KG 08 2019   grade_7 0 0 2   15 0     0   1   13 5 0   0   2   12       0.0 18 0 0 2   15 0     0   1   13 5 0   0 2 12     0 18
2419120 WA Grays Harbor   school 5307050 14097   Lake Quinault School District 530705001050 2921 Lake Quinault School   Regular School No Other PK 12 2019   grade_7 3 0 4   3 0     0   0   7 3 0   2   3   10       0.0 10 3 0 4   3 0     0   0   7 3 0   2 3 10     0 10
2428154 WA Grays Harbor   school 5309990 14117   Wishkah Valley School District 530999001679 3375 Wishkah Valley Elementary/High School   Regular School No Other KG 12 2019   grade_7 9 0 0   0 0     0   0   1 8 0   0   0   2       2.0 9 9 0 0   0 0     0   0   1 8 0   0 0 2     2 9
2421843 WA Grays Harbor   school 5306090 14172   Ocosta School District 530609000914 3024 Ocosta Junior - Senior High   Regular School No High 07 12 2019   grade_7 22 0 15   0 0     0   6   23 20 0   5   15   38       2.0 43 22 0 15   0 0     0   6   23 20 0   5 15 38     2 43
2421793 WA Grays Harbor   school 5306000 14400   Oakville School District 530600000909 2283 Oakville High School   Regular School No High 06 12 2019   grade_7 12 0 1   1 1     0   2   9 8 0   6   3   11       2.0 17 12 0 1   1 1     0   2   9 8 0   6 3 11     2 17
2421729 WA Island   school 5305940 15201   Oak Harbor School District 530594002628 1758 Homeconnection   Alternative School No Other KG 12 2019   grade_7 21 0 3   0 1     0   2   14 13 0   0   0   3       0.0 27 21 0 3   0 1     0   2   14 13 0   0 0 3     0 27
2421737 WA Island   school 5305940 15201   Oak Harbor School District 530594000901 3939 North Whidbey Middle School   Regular School No Middle 07 08 2019   grade_7 237 20 65   3 24     3   56   208 200 0   20   6   179       24.0 408 237 20 65   3 24     3   56   208 200 0   20 6 179     24 408
2415635 WA Island   school 5301800 15204   Coupeville School District 530180002049 4004 Coupeville Middle School   Regular School No Middle 06 08 2019   grade_7 45 1 11   0 2     0   12   35 36 0   3   3   22       4.0 71 45 1 11   0 2     0   12   35 36 0   3 3 22     4 71
2425392 WA Island   school 5308190 15206   South Whidbey School District 530819001358 2511 South Whidbey Middle   Regular School No Middle 07 08 2019   grade_7 92 0 8   0 1     1   8   60 50 0   0   8   41       6.0 110 92 0 8   0 1     1   8   60 50 0   0 8 41     6 110
2414346 WA Jefferson   school 5300750 16046   Brinnon School District 530075000153 2836 Brinnon Elementary   Regular School No Elementary PK 08 2019   grade_7 7 0 0   0 0     1   0   7 1 0   0   0   6       0.0 8 7 0 0   0 0     1   0   7 1 0   0 0 6     0 8
2423099 WA Jefferson   school 5306990 16048   Quilcene School District 530699003353 5236 Partnership for Excellence in Alternative Remote Learning   Alternative School No Elementary KG 08 2019   grade_7 27 1 1   0 0     0   2   13 18 0   0   0   6       0.0 31 27 1 1   0 0     0   2   13 18 0   0 0 6     0 31
2423114 WA Jefferson   school 5306990 16048   Quilcene School District 530699001045 2474 Quilcene High And Elementary   Regular School No Other PK 12 2019   grade_7 12 0 0   1 0     0   1   8 6 0   0   0   6       2.0 14 12 0 0   1 0     0   1   8 6 0   0 0 6     2 14
2415136 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 2019   grade_7 48 0 5   0 0     1   7   37 24 0   0   3   38       6.0 61 48 0 5   0 0     1   7   37 24 0   0 3 38     6 61
2415150 WA Jefferson   school 5301290 16049   Chimacum School District 530129002630 1724 PI Program   Alternative School No Other KG 12 2019   grade_7 1 0 1   0 0     0   0   0 2 0   0   0   1       0.0 2 1 0 1   0 0     0   0   0 2 0   0 0 1     0 2
2422713 WA Jefferson   school 5306840 16050   Port Townsend School District 530684001305 4475 Blue Heron Middle School   Regular School No Middle 06 08 2019   grade_7 74 1 11   1 1     0   7   49 46 0   3   2   47       6.0 95 74 1 11   1 1     0   7   49 46 0   3 2 47     6 95
2422724 WA Jefferson   school 5306840 16050   Port Townsend School District 530684002791 1798 OCEAN   Alternative School No Other KG 12 2019   grade_7 3 0 0   0 0     0   0   2 1 0   0   0   2       0.0 3 3 0 0   0 0     0   0   2 1 0   0 0 2     0 3
2423871 WA King   school 5307710 17001   Seattle School District No. 1 530771001249 3774 Aki Kurose Middle School   Regular School No Middle 06 08 2019   grade_7 7 64 37   2 65     5   21   106 95 0   37   13   149       9.0 201 7 64 37   2 65     5   21   106 95 0   37 13 149     9 201
2423928 WA King   school 5307710 17001   Seattle School District No. 1 530771003555 5406 Bridges Transition   Special Education School No Other PK 12 2019   grade_7 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
2423937 WA King   school 5307710 17001   Seattle School District No. 1 530771001145 2209 Broadview-Thomson K-8 School   Regular School No Elementary PK 08 2019   grade_7 8 8 7   0 4     0   2   8 21 0   5   2   22       1.0 29 8 8 7   0 4     0   2   8 21 0   5 2 22     1 29
2423956 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 2019   grade_7 8 2 1   0 1     0   1   9 4 0   1   1   3       1.0 13 8 2 1   0 1     0   1   9 4 0   1 1 3     1 13
2423972 WA King   school 5307710 17001   Seattle School District No. 1 530771002017 2838 Catharine Blaine K-8 School   Regular School No Elementary KG 08 2019   grade_7 64 2 2   0 3     0   8   32 47 0   0   0   4       4.0 79 64 2 2   0 3     0   8   32 47 0   0 0 4     4 79
2424010 WA King   school 5307710 17001   Seattle School District No. 1 530771001913 2839 David T. Denny International Middle School   Regular School No Middle 06 08 2019   grade_7 60 51 93   4 50     2   30   165 125 0   56   27   208       7.0 290 60 51 93   4 50     2   30   165 125 0   56 27 208     7 290
2424030 WA King   school 5307710 17001   Seattle School District No. 1 530771001162 2729 Eckstein Middle School   Regular School No Middle 06 08 2019   grade_7 225 13 24   2 32     0   35   152 179 0   14   2   47       25.0 331 225 13 24   2 32     0   35   152 179 0   14 2 47     25 331
2424034 WA King   school 5307710 17001   Seattle School District No. 1 530771003612 5485 Edmonds S. Meany Middle School   Regular School No Middle 06 08 2019   grade_7 63 54 17   1 20     0   17   96 76 0   16   16   87       11.0 172 63 54 17   1 20     0   17   96 76 0   16 16 87     11 172
2424109 WA King   school 5307710 17001   Seattle School District No. 1 530771001180 2371 Hamilton International Middle School   Regular School No Middle 06 08 2019   grade_7 230 12 24   3 26     0   42   175 162 0   6   4   36       18.0 337 230 12 24   3 26     0   42   175 162 0   6 4 36     18 337
2424125 WA King   school 5307710 17001   Seattle School District No. 1 530771003271 5175 Hazel Wolf K-8   Regular School No Elementary KG 08 2019   grade_7 55 6 10   0 8     0   7   34 52 0   4   0   21       12.0 86 55 6 10   0 8     0   7   34 52 0   4 0 21     12 86
2424158 WA King   school 5307710 17001   Seattle School District No. 1 530771003467 5351 Jane Addams Middle School   Regular School No Middle 06 08 2019   grade_7 159 25 41   0 48     0   35   169 139 0   24   9   83       18.0 308 159 25 41   0 48     0   35   169 139 0   24 9 83     18 308
2424231 WA King   school 5307710 17001   Seattle School District No. 1 530771001132 3874 Licton Springs K-8   Alternative School No Elementary PK 08 2019   grade_7 6 2 4   2 2     0   2   11 7 0   1   0   9       0.0 18 6 2 4   2 2     0   2   11 7 0   1 0 9     0 18
2424241 WA King   school 5307710 17001   Seattle School District No. 1 530771003426 5276 Louisa Boren STEM K-8   Regular School No Elementary PK 08 2019   grade_7 34 8 3   0 5     0   6   31 25 0   3   0   10       1.0 56 34 8 3   0 5     0   6   31 25 0   3 0 10     1 56
2424262 WA King   school 5307710 17001   Seattle School District No. 1 530771001207 2435 Madison Middle School   Regular School No Middle 06 08 2019   grade_7 203 21 21   1 16     1   36   159 140 0   8   6   50       22.0 299 203 21 21   1 16     1   36   159 140 0   8 6 50     22 299
2424289 WA King   school 5307710 17001   Seattle School District No. 1 530771001212 3517 McClure Middle School   Regular School No Middle 06 08 2019   grade_7 110 10 18   0 14     0   25   89 88 0   5   4   27       6.0 177 110 10 18   0 14     0   25   89 88 0   5 4 27     6 177
2424307 WA King   school 5307710 17001   Seattle School District No. 1 530771001136 3095 Mercer International Middle School   Regular School No Middle 06 08 2019   grade_7 42 74 61   1 143     0   36   183 174 0   70   23   224       6.0 357 42 74 61   1 143     0   36   183 174 0   70 23 224     6 357
2424368 WA King   school 5307710 17001   Seattle School District No. 1 530771002231 4065 Orca K-8 School   Alternative School No Elementary KG 08 2019   grade_7 11 13 4   0 1     0   1   15 15 0   4   0   13       1.0 30 11 13 4   0 1     0   1   15 15 0   4 0 13     1 30
2424378 WA King   school 5307710 17001   Seattle School District No. 1 530771001102 1620 Pathfinder K-8 School   Alternative School No Elementary KG 08 2019   grade_7 42 4 6   0 2     0   6   28 32 0   0   0   15       3.0 60 42 4 6   0 2     0   6   28 32 0   0 0 15     3 60
2424391 WA King   school 5307710 17001   Seattle School District No. 1 530771003046 5046 Private School Services   Special Education School No Other PK 12 2019   grade_7 5 0 0   0 1     0   0   4 2 0   0   0   2       0.0 6 5 0 0   0 1     0   0   4 2 0   0 0 2     0 6
2424422 WA King   school 5307710 17001   Seattle School District No. 1 530771002873 4263 Residential Consortium   Special Education School No Other PK 12 2019   grade_7 3 2 1   0 0     0   0   3 3 0   0   1   2       0.0 6 3 2 1   0 0     0   0   3 3 0   0 1 2     0 6
2424435 WA King   school 5307710 17001   Seattle School District No. 1 530771003620 5486 Robert Eagle Staff Middle School   Regular School No Middle 06 08 2019   grade_7 158 22 44   2 13     1   27   131 136 0   19   5   69       10.0 267 158 22 44   2 13     1   27   131 136 0   19 5 69     10 267
2424465 WA King   school 5307710 17001   Seattle School District No. 1 530771002716 1796 Salmon Bay K-8 School   Alternative School No Elementary KG 08 2019   grade_7 90 2 13   0 3     1   10   55 64 0   1   0   8       10.0 119 90 2 13   0 3     1   10   55 64 0   1 0 8     10 119
2424488 WA King   school 5307710 17001   Seattle School District No. 1 530771001311 1596 Seattle World School   Alternative School No High 06 12 2019   grade_7 1 2 5   0 7     0   0   8 7 0   9   4   14       0.0 15 1 2 5   0 7     0   0   8 7 0   9 4 14     0 15
2424498 WA King   school 5307710 17001   Seattle School District No. 1 530771002933 4218 South Shore PK-8 School   Regular School No Elementary PK 08 2019   grade_7 8 20 5   1 13     0   9   34 22 0   12   3   34       0.0 56 8 20 5   1 13     0   9   34 22 0   12 3 34     0 56
2424543 WA King   school 5307710 17001   Seattle School District No. 1 530771001307 1579 Tops K-8 School   Alternative School No Elementary PK 08 2019   grade_7 33 4 4   0 8     0   4   24 29 0   2   0   16       3.0 53 33 4 4   0 8     0   4   24 29 0   2 0 16     3 53
2424563 WA King   school 5307710 17001   Seattle School District No. 1 530771001259 4064 Washington Middle School   Regular School No Middle 06 08 2019   grade_7 77 49 23   0 37     3   32   117 104 0   16   9   83       7.0 221 77 49 23   0 37     3   32   117 104 0   16 9 83     7 221
2424594 WA King   school 5307710 17001   Seattle School District No. 1 530771001264 3277 Whitman Middle School   Regular School No Middle 06 08 2019   grade_7 141 8 16   1 11     0   23   102 98 0   12   5   35       20.0 200 141 8 16   1 11     0   23   102 98 0   12 5 35     20 200
2417140 WA King   school 5302820 17210   Federal Way School District 530282002719 1789 Federal Way Public Academy   Regular School No Middle 06 10 2019   grade_7 24 5 15   0 9     0   11   32 32 0   4   0   25       1.0 64 24 5 15   0 9     0   11   32 32 0   4 0 25     1 64
2417163 WA King   school 5302820 17210   Federal Way School District 530282000437 3898 Illahee Middle School   Regular School No Middle 05 08 2019   grade_7 51 45 72   3 42     22   33   127 141 0   37   11   175       10.0 268 51 45 72   3 42     22   33   127 141 0   37 11 175     10 268
2417175 WA King   school 5302820 17210   Federal Way School District 530282002638 1759 Internet Academy   Alternative School No Other PK 12 2019   grade_7 2 1 2   0 1     0   2   3 5 0   0   0   1       1.0 8 2 1 2   0 1     0   2   3 5 0   0 0 1     1 8
2417181 WA King   school 5302820 17210   Federal Way School District 530282000438 3701 Kilo Middle School   Regular School No Middle 06 08 2019   grade_7 64 22 89   0 27     1   16   100 118 1   39   7   142       7.0 219 64 22 89   0 27     1   16   100 118 1   39 7 142     7 219
2417206 WA King   school 5302820 17210   Federal Way School District 530282000442 3381 Lakota Middle School   Regular School No Middle 06 08 2019   grade_7 87 38 80   1 15     19   39   151 127 1   40   10   166       9.0 279 87 38 80   1 15     19   39   151 127 1   40 10 166     9 279
2417237 WA King   school 5302820 17210   Federal Way School District 530282000444 3625 Nautilus K-8 School   Regular School No Elementary KG 08 2019   grade_7 9 3 9   0 1     4   2   10 18 0   5   0   18       2.0 28 9 3 9   0 1     4   2   10 18 0   5 0 18     2 28
2417267 WA King   school 5302820 17210   Federal Way School District 530282000448 3626 Sacajawea Middle School   Regular School No Middle 06 08 2019   grade_7 56 41 104   1 23     14   14   120 132 1   52   6   183       4.0 253 56 41 104   1 23     14   14   120 132 1   52 6 183     4 253
2417271 WA King   school 5302820 17210   Federal Way School District 530282002964 5029 Sequoyah Middle School   Regular School No Middle 06 08 2019   grade_7 48 34 50   0 25     11   24   88 104 0   31   11   146       6.0 192 48 34 50   0 25     11   24   88 104 0   31 11 146     6 192
2417312 WA King   school 5302820 17210   Federal Way School District 530282002961 1951 Support School   Regular School No Other PK 12 2019   grade_7 0 1 1   0 0     0   1   1 2 0   0   0   2       0.0 3 0 1 1   0 0     0   1   1 2 0   0 0 2     0 3
2417322 WA King   school 5302820 17210   Federal Way School District 530282003610 5473 Technology Access Foundation Academy at Saghalie   Regular School No High 06 12 2019   grade_7 36 21 52   0 16     11   17   79 74 0   34   6   115       5.0 153 36 21 52   0 16     11   17   79 74 0   34 6 115     5 153
2417337 WA King   school 5302820 17210   Federal Way School District 530282000452 3431 Totem Middle School   Regular School No Middle 06 08 2019   grade_7 44 44 91   2 28     14   19   122 120 0   71   5   180       4.0 242 44 44 91   2 28     14   19   122 120 0   71 5 180     4 242
2417369 WA King   school 5302820 17210   Federal Way School District 530282000456 3328 Woodmont K-8 School   Regular School No Elementary KG 08 2019   grade_7 7 3 12   1 1     0   3   12 15 0   2   0   16       1.0 27 7 3 12   1 1     0   3   12 15 0   2 0 16     1 27
2416471 WA King   school 5300001 17216   Enumclaw School District 530000102054 4210 Enumclaw Middle School   Regular School No Middle 06 08 2019   grade_7 109 0 26   3 1     1   6   70 76 0   10   6   62       7.0 146 109 0 26   3 1     1   6   70 76 0   10 6 62     7 146
2416504 WA King   school 5300001 17216   Enumclaw School District 530000102795 4550 Thunder Mountain Middle School   Regular School No Middle 06 08 2019   grade_7 110 2 37   4 3     0   5   88 73 0   9   3   36       4.0 161 110 2 37   4 3     0   5   88 73 0   9 3 36     4 161
2420273 WA King   school 5304980 17400   Mercer Island School District 530498000764 3219 Islander Middle School   Regular School No Middle 06 08 2019   grade_7 228 1 17   1 86     0   38   206 165 0   9   0   19       68.0 371 228 1 17   1 86     0   38   206 165 0   9 0 19     68 371
2417843 WA King   school 5303540 17401   Highline School District 530354002976 5028 Big Picture School   Alternative School No High 07 12 2019   grade_7 16 6 14   0 0     0   0   23 13 0   3   1   23       1.0 36 16 6 14   0 0     0   0   23 13 0   3 1 23     1 36
2417855 WA King   school 5303540 17401   Highline School District 530354000522 3163 Cascade Middle School   Regular School No Middle 07 08 2019   grade_7 34 20 135   1 54     7   11   140 122 0   78   13   221       5.0 262 34 20 135   1 54     7   11   140 122 0   78 13 221     5 262
2417867 WA King   school 5303540 17401   Highline School District 530354000524 3098 Chinook Middle School   Regular School No Middle 07 08 2019   grade_7 49 65 120   0 60     28   9   183 148 0   89   20   281       6.0 331 49 65 120   0 60     28   9   183 148 0   89 20 281     6 331

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