Data source: Big Local News · About: Big Local

4,566 rows where grade = "grade_7" and state = "WA" sorted by school_nces_id

View and edit SQL

year

grade

  • grade_7 · 4,566
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
463190 WA King   school 5300001 17216   Enumclaw School District 530000102054 4210 Enumclaw Middle School   Regular School No 2.0 06 08 2015   grade_7 120 3 9   6 0     0   5   76 67 0   2   3   56       2.0 143 120 3 9   6 0     0   5   76 67 0   2 3 56     2 143
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
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
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
2460975 WA King   school 5300001 17216   Enumclaw School District 530000102054 4210 Enumclaw Middle School   Regular School No Middle 06 08 2018   grade_7 139 1 21   0 2     1   6   88 82 0   7   5   68       7.0 170 139 1 21   0 2     1   6   88 82 0   7 5 68     7 170
2573802 WA King   school 5300001 17216   Enumclaw School District 530000102054 4210 Enumclaw Middle School   Regular School No Middle 06 08 2020   grade_7 119 1 27   1 0     1   12   81 80 0   7   10   68       3.0 161 119 1 27   1 0     1   12   81 80 0   7 10 68     3 161
2934683 WA King   school 5300001 17216   Enumclaw School District 530000102054 4210 Enumclaw Middle School   Regular School No Middle 06 08 2021   grade_7 125 1 21   0 1     1   11   72 88 0   2   3   46       3.0 160 125 1 21   0 1     1   11   72 88 0   2 3 46     3 160
463221 WA King   school 5300001 17216   Enumclaw School District 530000102795 4550 Thunder Mountain Middle School   Regular School No 2.0 06 08 2015   grade_7 124 1 14   4 0     1   4   87 61 0   4   1   43       3.0 148 124 1 14   4 0     1   4   87 61 0   4 1 43     3 148
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
620581 WA King   school 5300001 17216   Enumclaw School District 530000102795 4550 Thunder Mountain Middle School   Regular School No Middle 06 08 2017   grade_7 118 2 35   1 0     0   8   83 81 0   5   4   54       5.0 164 118 2 35   1 0     0   8   83 81 0   5 4 54     5 164
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
2461009 WA King   school 5300001 17216   Enumclaw School District 530000102795 4550 Thunder Mountain Middle School   Regular School No Middle 06 08 2018   grade_7 100 1 22   1 2     1   12   76 63 0   11   4   44       4.0 139 100 1 22   1 2     1   12   76 63 0   11 4 44     4 139
2573836 WA King   school 5300001 17216   Enumclaw School District 530000102795 4550 Thunder Mountain Middle School   Regular School No Middle 06 08 2020   grade_7 112 0 24   1 2     0   4   75 68 0   8   1   37       7.0 143 112 0 24   1 2     0   4   75 68 0   8 1 37     7 143
2934716 WA King   school 5300001 17216   Enumclaw School District 530000102795 4550 Thunder Mountain Middle School   Regular School No Middle 06 08 2021   grade_7 128 1 35   4 3     0   15   93 93 0   7   5   55       6.0 186 128 1 35   4 3     0   15   93 93 0   7 5 55     6 186
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
2460997 WA King   school 5300001 17216   Enumclaw School District 530000103038 1523 Special Ed School   Special Education School No Other PK 12 2018   grade_7 0 0 0   0 0     0   1   1 0 0   0   0   0       0.0 1 0 0 0   0 0     0   1   1 0 0   0 0 0     0 1
2573825 WA King   school 5300001 17216   Enumclaw School District 530000103038 1523 Special Ed School   Special Education School No Other PK 12 2020   grade_7 1 0 1   0 0     0   0   2 0 0   0   0   2       0.0 2 1 0 1   0 0     0   0   2 0 0   0 0 2     0 2
2934704 WA King   school 5300001 17216   Enumclaw School District 530000103038 1523 Special Ed School   Special Education School No Other PK 12 2021   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
464914 WA Ferry   school 5300002 10070   Inchelium School District 530000202870 4214 Inchelium Middle School   Regular School No 2.0 06 08 2015   grade_7 0 0 0   12 0     0   3   7 8 0   0   0   13       0.0 15 0 0 0   12 0     0   3   7 8 0   0 0 13     0 15
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
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
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
2462625 WA Ferry   school 5300002 10070   Inchelium School District 530000202870 4214 Inchelium Middle School   Regular School No Middle 06 08 2018   grade_7 0 0 0   14 0     0   1   9 6 0   8   1   11       1.0 15 0 0 0   14 0     0   1   9 6 0   8 1 11     1 15
2575470 WA Ferry   school 5300002 10070   Inchelium School District 530000202870 4214 Inchelium Middle School   Regular School No Middle 06 08 2020   grade_7 0 0 0   18 0     0   3   9 12 0   11   0   17       0.0 21 0 0 0   18 0     0   3   9 12 0   11 0 17     0 21
2936347 WA Ferry   school 5300002 10070   Inchelium School District 530000202870 4214 Inchelium Middle School   Regular School No Middle 06 08 2021   grade_7 2 0 0   7 0     1   5   5 10 0   5   0   12       0.0 15 2 0 0   7 0     1   5   5 10 0   5 0 12     0 15
465185 WA Cowlitz   school 5300003 8458   Kelso School District 530000300591 3322 Coweeman Middle School   Regular School No 2.0 06 08 2015   grade_7 127 2 27   10 2     1   17   82 104 0   10   7   95       7.0 186 127 2 27   10 2     1   17   82 104 0   10 7 95     7 186
525145 WA Cowlitz   school 5300003 8458   Kelso School District 530000300591 3322 Coweeman Middle School   Regular School No 2 06 08 2016   grade_7 146 1 25   5 3     2   9   91 100 0   8   10   99       6.0 191 146 1 25   5 3     2   9   91 100 0   8 10 99     6 191
622514 WA Cowlitz   school 5300003 8458   Kelso School District 530000300591 3322 Coweeman Middle School   Regular School No Middle 06 08 2017   grade_7 141 0 32   4 3     0   9   84 105 0   12   1   101       8.0 189 141 0 32   4 3     0   9   84 105 0   12 1 101     8 189
2418389 WA Cowlitz   school 5300003 8458   Kelso School District 530000300591 3322 Coweeman Middle School   Regular School No Middle 06 08 2019   grade_7 129 1 37   4 2     1   9   100 83 0   10   5   116       7.0 183 129 1 37   4 2     1   9   100 83 0   10 5 116     7 183
2462879 WA Cowlitz   school 5300003 8458   Kelso School District 530000300591 3322 Coweeman Middle School   Regular School No Middle 06 08 2018   grade_7 142 1 43   3 2     2   10   113 90 0   13   5   128       6.0 203 142 1 43   3 2     2   10   113 90 0   13 5 128     6 203
2575737 WA Cowlitz   school 5300003 8458   Kelso School District 530000300591 3322 Coweeman Middle School   Regular School No Middle 06 08 2020   grade_7 133 1 25   2 1     3   7   92 80 0   9   0   106       8.0 172 133 1 25   2 1     3   7   92 80 0   9 0 106     8 172
2936606 WA Cowlitz   school 5300003 8458   Kelso School District 530000300591 3322 Coweeman Middle School   Regular School No Middle 06 08 2021   grade_7 104 0 31   1 2     3   9   71 79 0   14   3   89       5.0 150 104 0 31   1 2     3   9   71 79 0   14 3 89     5 150
465189 WA Cowlitz   school 5300003 8458   Kelso School District 530000300592 2916 Huntington Middle School   Regular School No 2.0 06 08 2015   grade_7 138 0 29   3 1     2   12   85 100 0   4   12   108       9.0 185 138 0 29   3 1     2   12   85 100 0   4 12 108     9 185
525149 WA Cowlitz   school 5300003 8458   Kelso School District 530000300592 2916 Huntington Middle School   Regular School No 2 06 08 2016   grade_7 139 1 31   3 2     2   18   93 103 0   8   4   115       7.0 196 139 1 31   3 2     2   18   93 103 0   8 4 115     7 196
622518 WA Cowlitz   school 5300003 8458   Kelso School District 530000300592 2916 Huntington Middle School   Regular School No Middle 06 08 2017   grade_7 109 0 36   0 2     0   7   81 73 0   6   5   102       5.0 154 109 0 36   0 2     0   7   81 73 0   6 5 102     5 154
2418393 WA Cowlitz   school 5300003 8458   Kelso School District 530000300592 2916 Huntington Middle School   Regular School No Middle 06 08 2019   grade_7 125 1 44   1 1     2   18   94 98 0   6   6   129       13.0 192 125 1 44   1 1     2   18   94 98 0   6 6 129     13 192
2462883 WA Cowlitz   school 5300003 8458   Kelso School District 530000300592 2916 Huntington Middle School   Regular School No Middle 06 08 2018   grade_7 144 0 44   0 0     4   14   102 104 0   17   2   133       7.0 206 144 0 44   0 0     4   14   102 104 0   17 2 133     7 206
2575741 WA Cowlitz   school 5300003 8458   Kelso School District 530000300592 2916 Huntington Middle School   Regular School No Middle 06 08 2020   grade_7 130 0 35   2 0     1   14   102 80 0   10   2   120       11.0 182 130 0 35   2 0     1   14   102 80 0   10 2 120     11 182
2936610 WA Cowlitz   school 5300003 8458   Kelso School District 530000300592 2916 Huntington Middle School   Regular School No Middle 06 08 2021   grade_7 108 0 30   2 3     2   12   82 75 0   10   3   103       7.0 157 108 0 30   2 3     2   12   82 75 0   10 3 103     7 157
622547 WA Cowlitz   school 5300003 8458   Kelso School District 530000303076 5076 Special Education   Special Education School No Other PK 12 2017   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
2936631 WA Cowlitz   school 5300003 8458   Kelso School District 530000303314 5194 Kelso Virtual Academy   Regular School No Other KG 12 2021   grade_7 46 0 7   0 0     0   4   23 34 0   0   0   14       2.0 57 46 0 7   0 0     0   4   23 34 0   0 0 14     2 57
523283 WA Clark   school 5300005 6801   ESD 112 acting as a school district 530000502917 3294 Cowlitz County Youth Services Center   Regular School No 4 06 12 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
2416584 WA Clark   school 5300005 6801   ESD 112 acting as a school district 530000502917 3294 Cowlitz County Youth Services Center   Regular School No High 06 12 2019   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
523275 WA Clark   school 5300005 6801   ESD 112 acting as a school district 530000503407 5290 Clark County Juvenile Detention School   Regular School No 4 03 12 2016   grade_7 2 0 0   0 0     0   0   2 0 0   0   0   0       0.0 2 2 0 0   0 0     0   0   2 0 0   0 0 0     0 2
2416578 WA Clark   school 5300005 6801   ESD 112 acting as a school district 530000503407 5290 Clark County Juvenile Detention School   Regular School No Other 03 12 2019   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
2573915 WA Clark   school 5300005 6801   ESD 112 acting as a school district 530000503407 5290 Clark County Juvenile Detention School   Regular School No Other 03 12 2020   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
2573936 WA Kitsap   school 5300007 18801   ESD 114 acting as a school district 530000702914 3143 Clallam Co Juvenile Detention   Regular School No High 08 12 2020   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
2934803 WA Kitsap   school 5300007 18801   ESD 114 acting as a school district 530000702914 3143 Clallam Co Juvenile Detention   Regular School No High 07 12 2021   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
463324 WA Kitsap   school 5300007 18801   ESD 114 acting as a school district 530000702927 3481 Kitsap Co Detention Ctr   Alternative Education School No 3.0 08 12 2015   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
523303 WA Kitsap   school 5300007 18801   ESD 114 acting as a school district 530000702927 3481 Kitsap Co Detention Ctr   Regular School No 4 06 12 2016   grade_7 0 0 1   0 0     0   0   1 0 0   0   0   1       0.0 1 0 0 1   0 0     0   0   1 0 0   0 0 1     0 1
620685 WA Kitsap   school 5300007 18801   ESD 114 acting as a school district 530000702927 3481 Kitsap Co Detention Ctr   Regular School No High 08 12 2017   grade_7 0 0 0   0 0     1   0   1 0 0   0   0   1       0.0 1 0 0 0   0 0     1   0   1 0 0   0 0 1     0 1
523314 WA Skagit   school 5300008 29801   ESD 189 acting as a school district 530000802923 3420 Whatcom Co Detention Center   Regular School No 3 07 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
2416613 WA Skagit   school 5300008 29801   ESD 189 acting as a school district 530000802923 3420 Whatcom Co Detention Center   Regular School No High 07 12 2019   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
463285 WA Spokane   school 5300010 32801   ESD 101 acting as a school district 530001002919 3352 Martin Hall Detention Ctr   Alternative Education School No 3.0 08 12 2015   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
463292 WA Spokane   school 5300010 32801   ESD 101 acting as a school district 530001002930 3526 Spokane Juvenile Detention School   Alternative Education School No 4.0 06 12 2015   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
523263 WA Spokane   school 5300010 32801   ESD 101 acting as a school district 530001002930 3526 Spokane Juvenile Detention School   Regular School No 4 06 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
2573900 WA Spokane   school 5300010 32801   ESD 101 acting as a school district 530001002930 3526 Spokane Juvenile Detention School   Regular School No High 06 12 2020   grade_7 0 0 0   1 0     0   0   1 0 0   0   0   0       0.0 1 0 0 0   1 0     0   0   1 0 0   0 0 0     0 1
474664 WA Thurston   school 5300015 34975   Washington Center for Deaf and Hard of Hearing Youth 530001501016 4246 Washington State School for the Deaf   Alternative Education School No 4.0 PK 12 2015   grade_7 1 1 3   0 2     0   0   2 5 0   0   0   5       1.0 7 1 1 3   0 2     0   0   2 5 0   0 0 5     1 7
534622 WA Thurston   school 5300015 34975   Washington Center for Deaf and Hard of Hearing Youth 530001501016 4246 Washington State School for the Deaf   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
631955 WA Thurston   school 5300015 34975   Washington Center for Deaf and Hard of Hearing Youth 530001501016 4246 Washington State School for the Deaf   Regular School No Other PK 12 2017   grade_7 3 0 4   0 0     0   1   4 4 0   0   0   5       0.0 8 3 0 4   0 0     0   1   4 4 0   0 0 5     0 8
2427642 WA Thurston   school 5300015 34975   Washington Center for Deaf and Hard of Hearing Youth 530001501016 4246 Washington State School for the Deaf   Regular School No Other PK 12 2019   grade_7 4 3 5   1 2     1   0   6 10 0   0   1   11       0.0 16 4 3 5   1 2     1   0   6 10 0   0 1 11     0 16
2472156 WA Thurston   school 5300015 34975   Washington Center for Deaf and Hard of Hearing Youth 530001501016 4246 Washington State School for the Deaf   Regular School No Other PK 12 2018   grade_7 2 0 1   0 1     0   0   2 2 0   0   0   2       0.0 4 2 0 1   0 1     0   0   2 2 0   0 0 2     0 4
2585071 WA Thurston   school 5300015 34975   Washington Center for Deaf and Hard of Hearing Youth 530001501016 4246 Washington State School for the Deaf   Regular School No Other PK 12 2020   grade_7 3 0 6   1 0     0   0   4 6 0   0   0   6       0.0 10 3 0 6   1 0     0   0   4 6 0   0 0 6     0 10
2946101 WA Thurston   school 5300015 34975   Washington Center for Deaf and Hard of Hearing Youth 530001501016 4246 Washington State School for the Deaf   Regular School No Other PK 12 2021   grade_7 3 0 6   1 0     0   0   6 4 0   0   0   5       0.0 10 3 0 6   1 0     0   0   6 4 0   0 0 5     0 10
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
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
2457563 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000001 2834 A J West Elementary   Regular School No Elementary PK 06 2018   grade_7 0 0 0   1 0     0   0   1 0 0   0   1   1       1.0 1 0 0 0   1 0     0   0   1 0 0   0 1 1     1 1
2570308 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000001 2834 A J West Elementary   Regular School No Elementary PK 05 2020   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
459745 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000007 3476 J M Weatherwax High School   Regular School No 3.0 09 12 2015   grade_7 2 0 0   0 0     0   1   1 2 0   0   0   0       0.0 3 2 0 0   0 0     0   1   1 2 0   0 0 0     0 3
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
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
459757 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000009 2305 Miller Junior High   Regular School No 2.0 07 08 2015   grade_7 141 3 46   10 5     2   7   101 113 0   10   15   159       8.0 214 141 3 46   10 5     2   7   101 113 0   10 15 159     8 214
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
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
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
2457604 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000009 2305 Miller Junior High   Regular School No Middle 07 08 2018   grade_7 127 0 80   9 3     0   16   120 115 0   28   13   176       9.0 235 127 0 80   9 3     0   16   120 115 0   28 13 176     9 235
2570357 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000009 2305 Miller Junior High   Regular School No Middle 06 08 2020   grade_7 150 2 92   3 6     0   17   132 138 0   20   12   205       20.0 270 150 2 92   3 6     0   17   132 138 0   20 12 205     20 270
2931247 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000009 2305 Miller Junior High   Regular School No Middle 06 08 2021   grade_7 157 2 91   6 5     0   30   150 141 0   30   2   225       14.0 291 157 2 91   6 5     0   30   150 141 0   30 2 225     14 291
459731 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003002055 4267 Grays Harbor Juvenile Detention   Alternative Education School No 4.0 06 12 2015   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
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
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
2931223 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003002055 4267 Grays Harbor Juvenile Detention   Regular School No High 06 12 2021   grade_7 1 0 0   0 0     0   0   1 0 0   0   0   0       0.0 1 1 0 0   0 0     0   0   1 0 0   0 0 0     0 1
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
2570324 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003003633 5514 Grays Harbor Academy   Alternative School No Other 03 12 2020   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
2931216 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003003633 5514 Grays Harbor Academy   Alternative School No Other 03 12 2021   grade_7 1 0 0   0 0     0   0   1 0 0   0   0   1       0.0 1 1 0 0   0 0     0   0   1 0 0   0 0 1     0 1
459790 WA Lewis   school 5300060 21226   Adna School District 530006000013 2441 Adna Middle/High School   Regular School No 4.0 06 12 2015   grade_7 43 0 3   0 0     0   1   21 26 0   0   0   22       3.0 47 43 0 3   0 0     0   1   21 26 0   0 0 22     3 47
519762 WA Lewis   school 5300060 21226   Adna School District 530006000013 2441 Adna Middle/High School   Regular School No 4 06 12 2016   grade_7 45 0 3   0 0     0   1   24 25 0   0   3   17       2.0 49 45 0 3   0 0     0   1   24 25 0   0 3 17     2 49
617125 WA Lewis   school 5300060 21226   Adna School District 530006000013 2441 Adna Middle/High School   Regular School No Other 06 12 2017   grade_7 40 0 2   0 1     0   0   20 23 0   0   0   13       0.0 43 40 0 2   0 1     0   0   20 23 0   0 0 13     0 43
2413078 WA Lewis   school 5300060 21226   Adna School District 530006000013 2441 Adna Middle/High School   Regular School No High 06 12 2019   grade_7 47 0 4   0 1     0   1   25 28 0   0   0   16       2.0 53 47 0 4   0 1     0   1   25 28 0   0 0 16     2 53
2457641 WA Lewis   school 5300060 21226   Adna School District 530006000013 2441 Adna Middle/High School   Regular School No High 06 12 2018   grade_7 32 0 1   0 1     0   1   20 15 0   0   1   12       0.0 35 32 0 1   0 1     0   1   20 15 0   0 1 12     0 35
2570390 WA Lewis   school 5300060 21226   Adna School District 530006000013 2441 Adna Middle/High School   Regular School No High 06 12 2020   grade_7 55 0 4   1 0     0   0   34 26 0   0   2   20       1.0 60 55 0 4   1 0     0   0   34 26 0   0 2 20     1 60
2931279 WA Lewis   school 5300060 21226   Adna School District 530006000013 2441 Adna Middle/High School   Regular School No High 06 12 2021   grade_7 41 0 7   1 0     0   0   26 23 0   0   2   14       0.0 49 41 0 7   1 0     0   0   26 23 0   0 2 14     0 49
459800 WA Lincoln   school 5300090 22017   Almira School District 530009000179 2860 Almira Elementary School   Regular School No 1.0 KG 08 2015   grade_7 16 0 3   0 0     0   0   13 6 0   0   0   7       0.0 19 16 0 3   0 0     0   0   13 6 0   0 0 7     0 19
519772 WA Lincoln   school 5300090 22017   Almira School District 530009000179 2860 Almira Elementary School   Regular School No 1 PK 08 2016   grade_7 26 0 0   0 0     0   0   10 16 0   0   0   7       0.0 26 26 0 0   0 0     0   0   10 16 0   0 0 7     0 26
617135 WA Lincoln   school 5300090 22017   Almira School District 530009000179 2860 Almira Elementary School   Regular School No Elementary KG 08 2017   grade_7 22 0 0   0 0     0   1   11 12 0   0   0   10       1.0 23 22 0 0   0 0     0   1   11 12 0   0 0 10     1 23
2413088 WA Lincoln   school 5300090 22017   Almira School District 530009000179 2860 Almira Elementary School   Regular School No Elementary PK 08 2019   grade_7 17 0 2   0 0     0   4   7 16 0   0   0   10       0.0 23 17 0 2   0 0     0   4   7 16 0   0 0 10     0 23
2457651 WA Lincoln   school 5300090 22017   Almira School District 530009000179 2860 Almira Elementary School   Regular School No Elementary KG 08 2018   grade_7 17 0 0   0 0     0   1   6 12 0   0   0   10       0.0 18 17 0 0   0 0     0   1   6 12 0   0 0 10     0 18
2570400 WA Lincoln   school 5300090 22017   Almira School District 530009000179 2860 Almira Elementary School   Regular School No Elementary PK 08 2020   grade_7 20 0 2   0 0     0   2   17 7 0   0   0   12       0.0 24 20 0 2   0 0     0   2   17 7 0   0 0 12     0 24
2931289 WA Lincoln   school 5300090 22017   Almira School District 530009000179 2860 Almira Elementary School   Regular School No Elementary KG 08 2021   grade_7 21 0 1   0 0     0   1   11 12 0   0   1   11       0.0 23 21 0 1   0 0     0   1   11 12 0   0 1 11     0 23
459811 WA Skagit   school 5300150 29103   Anacortes School District 530015000015 2707 Anacortes Middle School   Regular School No 2.0 07 08 2015   grade_7 181 6 13   3 15     2   2   120 102 0   2   5   72       13.0 222 181 6 13   3 15     2   2   120 102 0   2 5 72     13 222

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