enrollments

Data source: Big Local News · About: Big Local

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

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • grade_7 · 4,466 ✖
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
2931419 2931419 WA Asotin   school 5300280 2420   Asotin-Anatone School District 530028000028 2434 Asotin Jr Sr High   Regular School No High 06 12 2021   grade_7 53 0 2   0 0     0   2   23 34 0   0   0   12       0.0 57 53 0 2   0 0     0   2   23 34 0   0 0 12     0 57
468173 468173 WA Thurston   school 5305850 34003   North Thurston Public Schools 530585003280 5168 Aspire Middle School   Regular School No 2.0 06 08 2015   grade_7 63 1 13   1 7     0   17   39 63 0   0   3   32       4.0 102 63 1 13   1 7     0   17   39 63 0   0 3 32     4 102
528076 528076 WA Thurston   school 5305850 34003   North Thurston Public Schools 530585003280 5168 Aspire Middle School   Regular School No 2 06 08 2016   grade_7 71 4 8   0 7     0   14   38 66 0   0   3   34       9.0 104 71 4 8   0 7     0   14   38 66 0   0 3 34     9 104
625498 625498 WA Thurston   school 5305850 34003   North Thurston Public Schools 530585003280 5168 Aspire Middle School   Regular School No Middle 06 08 2017   grade_7 60 2 10   0 9     0   23   46 58 0   0   2   27       5.0 104 60 2 10   0 9     0   23   46 58 0   0 2 27     5 104
2421301 2421301 WA Thurston   school 5305850 34003   North Thurston Public Schools 530585003280 5168 Aspire Middle School   Regular School No Middle 06 08 2019   grade_7 61 1 19   0 5     0   7   31 62 0   1   3   28       9.0 93 61 1 19   0 5     0   7   31 62 0   1 3 28     9 93
2465763 2465763 WA Thurston   school 5305850 34003   North Thurston Public Schools 530585003280 5168 Aspire Middle School   Regular School No Middle 06 08 2018   grade_7 65 3 17   0 3     3   14   37 68 0   0   1   30       13.0 105 65 3 17   0 3     3   14   37 68 0   0 1 30     13 105
2578639 2578639 WA Thurston   school 5305850 34003   North Thurston Public Schools 530585003280 5168 Aspire Middle School   Regular School No Middle 06 08 2020   grade_7 59 1 15   0 6     1   22   42 62 0   0   2   33       18.0 104 59 1 15   0 6     1   22   42 62 0   0 2 33     18 104
2939563 2939563 WA Thurston   school 5305850 34003   North Thurston Public Schools 530585003280 5168 Aspire Middle School   Regular School No Middle 06 08 2021   grade_7 56 4 20   1 9     1   14   26 79 0   1   3   26       11.0 105 56 4 20   1 9     1   14   26 79 0   1 3 26     11 105
469754 469754 WA Pierce   school 5306960 27003   Puyallup School District 530696001022 3447 Aylen Jr High   Regular School No 2.0 07 09 2015   grade_7 129 9 39   5 6     0   12   97 103 0   11   2   87       6.0 200 129 9 39   5 6     0   12   97 103 0   11 2 87     6 200
529685 529685 WA Pierce   school 5306960 27003   Puyallup School District 530696001022 3447 Aylen Jr High   Regular School No 2 07 09 2016   grade_7 130 1 43   4 8     1   15   108 94 0   9   3   83       11.0 202 130 1 43   4 8     1   15   108 94 0   9 3 83     11 202
627119 627119 WA Pierce   school 5306960 27003   Puyallup School District 530696001022 3447 Aylen Jr High   Regular School No Other 07 09 2017   grade_7 155 7 48   2 9     4   29   131 123 0   9   4   90       23.0 254 155 7 48   2 9     4   29   131 123 0   9 4 90     23 254
2422825 2422825 WA Pierce   school 5306960 27003   Puyallup School District 530696001022 3447 Aylen Jr High   Regular School No Middle 06 09 2019   grade_7 133 4 45   5 11     1   33   121 111 0   13   2   83       16.0 232 133 4 45   5 11     1   33   121 111 0   13 2 83     16 232
2467313 2467313 WA Pierce   school 5306960 27003   Puyallup School District 530696001022 3447 Aylen Jr High   Regular School No Middle 07 09 2018   grade_7 136 5 37   1 13     2   22   117 99 0   17   3   77       9.0 216 136 5 37   1 13     2   22   117 99 0   17 3 77     9 216
2580186 2580186 WA Pierce   school 5306960 27003   Puyallup School District 530696001022 3447 Aylen Jr High   Regular School No Middle 07 09 2020   grade_7 152 8 50   9 11     1   35   156 110 0   18   7   106       24.0 266 152 8 50   9 11     1   35   156 110 0   18 7 106     24 266
2941167 2941167 WA Pierce   school 5306960 27003   Puyallup School District 530696001022 3447 Aylen Jr High   Regular School No Middle 07 09 2021   grade_7 138 6 50   4 12     0   26   125 111 0   9   6   83       19.0 236 138 6 50   4 12     0   26   125 111 0   9 6 83     19 236
460102 460102 WA Kitsap   school 5300330 18303   Bainbridge Island School District 530033003113 1939 Bainbridge Special Education Services   Special Education School No 4.0 PK 12 2015   grade_7 3 0 0   0 0     0   0   3 0 0   0   0   0       0.0 3 3 0 0   0 0     0   0   3 0 0   0 0 0     0 3
617443 617443 WA Kitsap   school 5300330 18303   Bainbridge Island School District 530033003113 1939 Bainbridge Special Education Services   Special Education School No Other PK 12 2017   grade_7 3 0 0   0 0     0   0   2 1 0   0   0   0       0.0 3 3 0 0   0 0     0   0   2 1 0   0 0 0     0 3
2413388 2413388 WA Kitsap   school 5300330 18303   Bainbridge Island School District 530033003113 1939 Bainbridge Special Education Services   Special Education School No Other PK 12 2019   grade_7 1 0 1   0 0     0   0   2 0 0   0   0   0       0.0 2 1 0 1   0 0     0   0   2 0 0   0 0 0     0 2
2457942 2457942 WA Kitsap   school 5300330 18303   Bainbridge Island School District 530033003113 1939 Bainbridge Special Education Services   Special Education School No Other PK 12 2018   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
2570703 2570703 WA Kitsap   school 5300330 18303   Bainbridge Island School District 530033003113 1939 Bainbridge Special Education Services   Special Education School No Other PK 12 2020   grade_7 3 0 2   0 0     0   1   5 1 0   0   0   1       0.0 6 3 0 2   0 0     0   1   5 1 0   0 0 1     0 6
473228 473228 WA Pierce   school 5308700 27010   Tacoma School District 530870001454 3054 Baker   Regular School No 2.0 06 08 2015   grade_7 69 37 64   5 47     14   11   118 129 0   28   9   190       14.0 247 69 37 64   5 47     14   11   118 129 0   28 9 190     14 247
533239 533239 WA Pierce   school 5308700 27010   Tacoma School District 530870001454 3054 Baker   Regular School No 2 06 08 2016   grade_7 41 48 69   3 45     16   12   124 110 0   24   15   153       9.0 234 41 48 69   3 45     16   12   124 110 0   24 15 153     9 234
630579 630579 WA Pierce   school 5308700 27010   Tacoma School District 530870001454 3054 Baker   Regular School No Middle 06 08 2017   grade_7 61 41 60   0 50     8   21   117 124 0   28   11   186       12.0 241 61 41 60   0 50     8   21   117 124 0   28 11 186     12 241
2426271 2426271 WA Pierce   school 5308700 27010   Tacoma School District 530870001454 3054 Baker   Regular School No Middle 06 08 2019   grade_7 64 39 81   0 32     13   22   130 121 0   31   19   211       11.0 251 64 39 81   0 32     13   22   130 121 0   31 19 211     11 251
2470780 2470780 WA Pierce   school 5308700 27010   Tacoma School District 530870001454 3054 Baker   Regular School No Middle 06 08 2018   grade_7 57 50 66   2 33     12   25   125 120 0   26   22   194       10.0 245 57 50 66   2 33     12   25   125 120 0   26 22 194     10 245
2583686 2583686 WA Pierce   school 5308700 27010   Tacoma School District 530870001454 3054 Baker   Regular School No Middle 06 08 2020   grade_7 69 28 71   1 40     14   47   140 130 0   30   17   202       18.0 270 69 28 71   1 40     14   47   140 130 0   30 17 202     18 270
2944690 2944690 WA Pierce   school 5308700 27010   Tacoma School District 530870001454 3054 Baker   Regular School No Middle 06 08 2021   grade_7 56 41 68   2 43     12   40   138 124 0   30   6   202       14.0 262 56 41 68   2 43     12   40   138 124 0   30 6 202     14 262
469758 469758 WA Pierce   school 5306960 27003   Puyallup School District 530696001026 3750 Ballou Jr High   Regular School No 2.0 07 09 2015   grade_7 150 14 43   1 12     4   28   124 128 0   10   4   100       10.0 252 150 14 43   1 12     4   28   124 128 0   10 4 100     10 252
529690 529690 WA Pierce   school 5306960 27003   Puyallup School District 530696001026 3750 Ballou Jr High   Regular School No 2 07 09 2016   grade_7 130 10 35   4 21     0   30   114 116 0   9   3   96       17.0 230 130 10 35   4 21     0   30   114 116 0   9 3 96     17 230
627124 627124 WA Pierce   school 5306960 27003   Puyallup School District 530696001026 3750 Ballou Jr High   Regular School No Other 06 09 2017   grade_7 159 10 42   1 21     2   32   132 135 0   10   1   103       16.0 267 159 10 42   1 21     2   32   132 135 0   10 1 103     16 267
2422830 2422830 WA Pierce   school 5306960 27003   Puyallup School District 530696001026 3750 Ballou Jr High   Regular School No Middle 06 09 2019   grade_7 156 19 56   2 10     5   36   147 137 0   12   7   123       30.0 284 156 19 56   2 10     5   36   147 137 0   12 7 123     30 284
2467318 2467318 WA Pierce   school 5306960 27003   Puyallup School District 530696001026 3750 Ballou Jr High   Regular School No Middle 06 09 2018   grade_7 130 20 42   2 18     3   26   138 103 0   10   3   119       18.0 241 130 20 42   2 18     3   26   138 103 0   10 3 119     18 241
2580191 2580191 WA Pierce   school 5306960 27003   Puyallup School District 530696001026 3750 Ballou Jr High   Regular School No Middle 07 09 2020   grade_7 157 15 57   0 22     9   47   150 157 0   22   5   111       26.0 307 157 15 57   0 22     9   47   150 157 0   22 5 111     26 307
2941172 2941172 WA Pierce   school 5306960 27003   Puyallup School District 530696001026 3750 Ballou Jr High   Regular School No Middle 07 09 2021   grade_7 136 24 74   1 15     10   45   156 149 0   14   6   121       33.0 305 136 24 74   1 15     10   45   156 149 0   14 6 121     33 305
2414610 2414610 WA Kitsap   school 5301080 18401   Central Kitsap School District 530108003622 5472 Barker Creek Community School   Alternative School No Other KG 12 2019   grade_7 11 1 1   0 0     0   2   6 9 0   0   0   2       0.0 15 11 1 1   0 0     0   2   6 9 0   0 0 2     0 15
2459151 2459151 WA Kitsap   school 5301080 18401   Central Kitsap School District 530108003622 5472 Barker Creek Community School   Alternative School No Other KG 12 2018   grade_7 18 1 3   0 0     0   1   10 13 0   0   0   7       0.0 23 18 1 3   0 0     0   1   10 13 0   0 0 7     0 23
2571947 2571947 WA Kitsap   school 5301080 18401   Central Kitsap School District 530108003622 5472 Barker Creek Community School   Alternative School No Other KG 12 2020   grade_7 9 0 1   0 0     0   3   6 7 0   0   0   2       2.0 13 9 0 1   0 0     0   3   6 7 0   0 0 2     2 13
2932850 2932850 WA Kitsap   school 5301080 18401   Central Kitsap School District 530108003622 5472 Barker Creek Community School   Alternative School No Other KG 12 2021   grade_7 49 6 13   1 8     1   25   66 37 0   3   3   37       4.0 103 49 6 13   1 8     1   25   66 37 0   3 3 37     4 103
461089 461089 WA Skagit   school 5300780 29100   Burlington-Edison School District 530078000689 4412 Bay View Elementary   Regular School No 1.0 KG 08 2015   grade_7 52 0 7   0 1     0   1   37 24 0   3   0   12       0.0 61 52 0 7   0 1     0   1   37 24 0   3 0 12     0 61
521065 521065 WA Skagit   school 5300780 29100   Burlington-Edison School District 530078000689 4412 Bay View Elementary   Regular School No 1 KG 08 2016   grade_7 38 1 9   2 3     0   1   28 26 0   4   1   11       0.0 54 38 1 9   2 3     0   1   28 26 0   4 1 11     0 54
618435 618435 WA Skagit   school 5300780 29100   Burlington-Edison School District 530078000689 4412 Bay View Elementary   Regular School No Elementary KG 08 2017   grade_7 42 0 15   0 2     1   0   33 27 0   10   2   22       0.0 60 42 0 15   0 2     1   0   33 27 0   10 2 22     0 60
2414367 2414367 WA Skagit   school 5300780 29100   Burlington-Edison School District 530078000689 4412 Bay View Elementary   Regular School No Elementary KG 08 2019   grade_7 49 0 16   0 6     0   5   42 34 0   1   3   24       6.0 76 49 0 16   0 6     0   5   42 34 0   1 3 24     6 76
2458918 2458918 WA Skagit   school 5300780 29100   Burlington-Edison School District 530078000689 4412 Bay View Elementary   Regular School No Elementary KG 08 2018   grade_7 48 0 13   0 0     0   1   37 25 0   6   0   16       3.0 62 48 0 13   0 0     0   1   37 25 0   6 0 16     3 62
2571695 2571695 WA Skagit   school 5300780 29100   Burlington-Edison School District 530078000689 4412 Bay View Elementary   Regular School No Elementary KG 08 2020   grade_7 29 0 20   0 0     0   3   26 26 0   10   0   15       1.0 52 29 0 20   0 0     0   3   26 26 0   10 0 15     1 52
2932591 2932591 WA Skagit   school 5300780 29100   Burlington-Edison School District 530078000689 4412 Bay View Elementary   Regular School No Elementary KG 08 2021   grade_7 52 1 22   0 1     0   2   52 26 0   7   1   34       2.0 78 52 1 22   0 1     0   2   52 26 0   7 1 34     2 78
464937 464937 WA King   school 5303750 17411   Issaquah School District 530375001495 4460 Beaver Lake Middle School   Regular School No 2.0 06 08 2015   grade_7 177 2 17   0 88     3   9   141 155 0   7   1   19       14.0 296 177 2 17   0 88     3   9   141 155 0   7 1 19     14 296
524892 524892 WA King   school 5303750 17411   Issaquah School District 530375001495 4460 Beaver Lake Middle School   Regular School No 2 06 08 2016   grade_7 162 1 15   0 92     0   18   166 122 0   4   0   19       12.0 288 162 1 15   0 92     0   18   166 122 0   4 0 19     12 288
622268 622268 WA King   school 5303750 17411   Issaquah School District 530375001495 4460 Beaver Lake Middle School   Regular School No Middle 06 08 2017   grade_7 134 1 18   0 94     1   21   136 133 0   7   0   10       20.0 269 134 1 18   0 94     1   21   136 133 0   7 0 10     20 269
2418154 2418154 WA King   school 5303750 17411   Issaquah School District 530375001495 4460 Beaver Lake Middle School   Regular School No Middle 06 08 2019   grade_7 141 5 26   0 78     0   27   136 141 0   10   2   22       22.0 277 141 5 26   0 78     0   27   136 141 0   10 2 22     22 277
2462646 2462646 WA King   school 5303750 17411   Issaquah School District 530375001495 4460 Beaver Lake Middle School   Regular School No Middle 06 08 2018   grade_7 161 0 22   0 94     2   15   142 152 0   10   2   18       18.0 294 161 0 22   0 94     2   15   142 152 0   10 2 18     18 294
2575496 2575496 WA King   school 5303750 17411   Issaquah School District 530375001495 4460 Beaver Lake Middle School   Regular School No Middle 06 08 2020   grade_7 159 1 23   1 96     1   21   150 152 0   2   1   13       36.0 302 159 1 23   1 96     1   21   150 152 0   2 1 13     36 302
2936371 2936371 WA King   school 5303750 17411   Issaquah School District 530375001495 4460 Beaver Lake Middle School   Regular School No Middle 06 08 2021   grade_7 109 2 11   1 110     0   25   140 118 0   11   0   18       23.0 258 109 2 11   1 110     0   25   140 118 0   11 0 18     23 258
463235 463235 WA Grant   school 5302610 13165   Ephrata School District 530261002934 4229 Beezley Springs Elementary   Special Education School No 1.0 PK 03 2015   grade_7 0 0 1   0 0     0   0   0 1 0   0   0   0       0.0 1 0 0 1   0 0     0   0   0 1 0   0 0 0     0 1
523209 523209 WA Grant   school 5302610 13165   Ephrata School District 530261002934 4229 Beezley Springs Elementary   Special Education School No 1 PK 07 2016   grade_7 1 0 0   0 0     0   0   1 0 0   0   0   0       0.0 1 1 0 0   0 0     0   0   1 0 0   0 0 0     0 1
620593 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
2934729 2934729 WA Grant   school 5302610 13165   Ephrata School District 530261002934 4229 Beezley Springs Elementary   Special Education School No Elementary PK 06 2021   grade_7 1 0 0   0 0     0   0   0 1 0   0   0   0       0.0 1 1 0 0   0 0     0   0   0 1 0   0 0 0     0 1
460310 460310 WA King   school 5300390 17405   Bellevue School District 530039003354 5240 Bellevue Big Picture School   Alternative Education School No 4.0 06 12 2015   grade_7 50 4 6   0 12     0   5   35 42 0   1   1   16       10.0 77 50 4 6   0 12     0   5   35 42 0   1 1 16     10 77
520290 520290 WA King   school 5300390 17405   Bellevue School District 530039003354 5240 Bellevue Big Picture School   Alternative Education School No 4 06 12 2016   grade_7 47 2 3   0 19     0   9   47 33 0   1   0   11       12.0 80 47 2 3   0 19     0   9   47 33 0   1 0 11     12 80
617645 617645 WA King   school 5300390 17405   Bellevue School District 530039003354 5240 Bellevue Big Picture School   Alternative School No Other 06 12 2017   grade_7 44 4 5   0 16     0   7   41 35 0   0   0   15       8.0 76 44 4 5   0 16     0   7   41 35 0   0 0 15     8 76
2413592 2413592 WA King   school 5300390 17405   Bellevue School District 530039003354 5240 Bellevue Big Picture School   Alternative School No High 06 12 2019   grade_7 31 4 10   1 20     0   13   43 36 0   5   2   19       11.0 79 31 4 10   1 20     0   13   43 36 0   5 2 19     11 79
2458147 2458147 WA King   school 5300390 17405   Bellevue School District 530039003354 5240 Bellevue Big Picture School   Alternative School No High 06 12 2018   grade_7 48 0 5   0 15     1   7   42 34 0   0   1   8       8.0 76 48 0 5   0 15     1   7   42 34 0   0 1 8     8 76
2570909 2570909 WA King   school 5300390 17405   Bellevue School District 530039003354 5240 Bellevue Big Picture School   Alternative School No High 06 12 2020   grade_7 31 0 4   0 30     0   11   40 36 0   5   0   9       9.0 76 31 0 4   0 30     0   11   40 36 0   5 0 9     9 76
2931804 2931804 WA King   school 5300390 17405   Bellevue School District 530039003354 5240 Bellevue Big Picture School   Alternative School No High 06 12 2021   grade_7 40 2 1   0 25     1   8   37 40 0   5   0   8       11.0 77 40 2 1   0 25     1   8   37 40 0   5 0 8     11 77
520492 520492 WA Whatcom   school 5300420 37501   Bellingham School District 530042003476 5366 Bellingham Family Partnership Program   Alternative Education School No 4 KG 12 2016   grade_7 8 0 0   0 0     0   2   5 5 0   0   0   2       2.0 10 8 0 0   0 0     0   2   5 5 0   0 0 2     2 10
617852 617852 WA Whatcom   school 5300420 37501   Bellingham School District 530042003476 5366 Bellingham Family Partnership Program   Alternative School No Other KG 12 2017   grade_7 6 0 1   0 0     0   1   5 3 0   0   0   1       1.0 8 6 0 1   0 0     0   1   5 3 0   0 0 1     1 8
2413809 2413809 WA Whatcom   school 5300420 37501   Bellingham School District 530042003476 5366 Bellingham Family Partnership Program   Alternative School No Other KG 12 2019   grade_7 11 1 0   0 0     0   2   8 6 0   0   0   1       2.0 14 11 1 0   0 0     0   2   8 6 0   0 0 1     2 14
2458356 2458356 WA Whatcom   school 5300420 37501   Bellingham School District 530042003476 5366 Bellingham Family Partnership Program   Alternative School No Other KG 12 2018   grade_7 16 0 1   0 0     0   0   10 7 0   1   0   3       0.0 17 16 0 1   0 0     0   0   10 7 0   1 0 3     0 17
2571129 2571129 WA Whatcom   school 5300420 37501   Bellingham School District 530042003476 5366 Bellingham Family Partnership Program   Alternative School No Other KG 12 2020   grade_7 15 0 1   0 1     0   1   7 11 0   0   1   2       1.0 18 15 0 1   0 1     0   1   7 11 0   0 1 2     1 18
2932018 2932018 WA Whatcom   school 5300420 37501   Bellingham School District 530042003476 5366 Bellingham Family Partnership Program   Alternative School No Other KG 12 2021   grade_7 19 1 0   0 0     0   2   10 11 1   0   0   2       4.0 22 19 1 0   0 0     0   2   10 11 1   0 0 2     4 22
460680 460680 WA Pierce   school 5300480 27403   Bethel School District 530048000120 3250 Bethel Middle School   Regular School No 2.0 06 09 2015   grade_7 112 36 38   3 11     8   15   112 111 0   1   5   129       9.0 223 112 36 38   3 11     8   15   112 111 0   1 5 129     9 223
520662 520662 WA Pierce   school 5300480 27403   Bethel School District 530048000120 3250 Bethel Middle School   Regular School No 2 06 08 2016   grade_7 125 15 32   3 14     8   21   115 103 0   6   8   125       5.0 218 125 15 32   3 14     8   21   115 103 0   6 8 125     5 218
618035 618035 WA Pierce   school 5300480 27403   Bethel School District 530048000120 3250 Bethel Middle School   Regular School No Middle 06 08 2017   grade_7 110 20 30   2 9     13   23   105 104 0   7   4   128       7.0 209 110 20 30   2 9     13   23   105 104 0   7 4 128     7 209
2413987 2413987 WA Pierce   school 5300480 27403   Bethel School District 530048000120 3250 Bethel Middle School   Regular School No Middle 06 08 2019   grade_7 116 16 57   1 15     13   41   136 123 0   14   10   154       5.0 259 116 16 57   1 15     13   41   136 123 0   14 10 154     5 259
2458534 2458534 WA Pierce   school 5300480 27403   Bethel School District 530048000120 3250 Bethel Middle School   Regular School No Middle 06 08 2018   grade_7 91 17 57   2 6     14   28   118 97 0   13   8   141       5.0 215 91 17 57   2 6     14   28   118 97 0   13 8 141     5 215
2571307 2571307 WA Pierce   school 5300480 27403   Bethel School District 530048000120 3250 Bethel Middle School   Regular School No Middle 06 08 2020   grade_7 99 14 64   3 6     15   40   128 113 0   13   9   150       5.0 241 99 14 64   3 6     15   40   128 113 0   13 9 150     5 241
2932193 2932193 WA Pierce   school 5300480 27403   Bethel School District 530048000120 3250 Bethel Middle School   Regular School No Middle 06 08 2021   grade_7 100 20 52   1 6     19   39   134 103 0   7   6   153       8.0 237 100 20 52   1 6     19   39   134 103 0   7 6 153     8 237
2932205 2932205 WA Pierce   school 5300480 27403   Bethel School District 530048003762 5633 Bethel Virtual Academy   Regular School No Other KG 12 2021   grade_7 61 13 25   0 3     11   15   63 65 0   3   0   75       4.0 128 61 13 25   0 3     11   15   63 65 0   3 0 75     4 128
460885 460885 WA Klickitat   school 5300510 20203   Bickleton School District 530051000129 3392 Bickleton Elementary & High Schl   Regular School No 4.0 KG 12 2015   grade_7 3 0 3   0 0     0   0   3 3 0   0   0   0       0.0 6 3 0 3   0 0     0   0   3 3 0   0 0 0     0 6
520857 520857 WA Klickitat   school 5300510 20203   Bickleton School District 530051000129 3392 Bickleton Elementary & High Schl   Regular School No 4 KG 12 2016   grade_7 5 0 1   0 0     0   0   5 1 0   0   0   3       0.0 6 5 0 1   0 0     0   0   5 1 0   0 0 3     0 6
618227 618227 WA Klickitat   school 5300510 20203   Bickleton School District 530051000129 3392 Bickleton Elementary & High Schl   Regular School No Other KG 12 2017   grade_7 1 0 3   0 0     0   0   2 2 0   0   0   0       0.0 4 1 0 3   0 0     0   0   2 2 0   0 0 0     0 4
2414166 2414166 WA Klickitat   school 5300510 20203   Bickleton School District 530051000129 3392 Bickleton Elementary & High Schl   Regular School No Other KG 12 2019   grade_7 7 0 4   0 0     0   0   5 6 0   0   0   7       0.0 11 7 0 4   0 0     0   0   5 6 0   0 0 7     0 11
2458715 2458715 WA Klickitat   school 5300510 20203   Bickleton School District 530051000129 3392 Bickleton Elementary & High Schl   Regular School No Other KG 12 2018   grade_7 8 0 6   0 0     0   0   6 8 0   0   0   3       1.0 14 8 0 6   0 0     0   0   6 8 0   0 0 3     1 14
2571485 2571485 WA Klickitat   school 5300510 20203   Bickleton School District 530051000129 3392 Bickleton Elementary & High Schl   Regular School No Other KG 12 2020   grade_7 10 0 2   0 0     0   0   5 7 0   0   0   5       0.0 12 10 0 2   0 0     0   0   5 7 0   0 0 5     0 12
2932385 2932385 WA Klickitat   school 5300510 20203   Bickleton School District 530051000129 3392 Bickleton Elementary & High Schl   Regular School No Other KG 12 2021   grade_7 2 0 0   0 0     0   0   2 0 0   0   0   1       0.0 2 2 0 0   0 0     0   0   2 0 0   0 0 1     0 2
464628 464628 WA King   school 5303540 17401   Highline School District 530354002976 5028 Big Picture School   Alternative Education School No 3.0 07 12 2015   grade_7 13 2 10   0 1     1   2   9 20 0   2   3   18       3.0 29 13 2 10   0 1     1   2   9 20 0   2 3 18     3 29
524580 524580 WA King   school 5303540 17401   Highline School District 530354002976 5028 Big Picture School   Alternative Education School No 3 07 12 2016   grade_7 17 1 9   1 1     0   6   17 18 0   2   0   19       1.0 35 17 1 9   1 1     0   6   17 18 0   2 0 19     1 35
621959 621959 WA King   school 5303540 17401   Highline School District 530354002976 5028 Big Picture School   Alternative School No High 07 12 2017   grade_7 13 4 5   0 3     0   7   13 19 0   3   0   19       2.0 32 13 4 5   0 3     0   7   13 19 0   3 0 19     2 32
2417843 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
2462341 2462341 WA King   school 5303540 17401   Highline School District 530354002976 5028 Big Picture School   Alternative School No High 07 12 2018   grade_7 14 2 8   1 2     1   3   19 12 0   1   1   16       2.0 31 14 2 8   1 2     1   3   19 12 0   1 1 16     2 31
2575183 2575183 WA King   school 5303540 17401   Highline School District 530354002976 5028 Big Picture School   Alternative School No High 06 12 2020   grade_7 12 2 15   0 1     0   4   18 16 0   4   0   20       0.0 34 12 2 15   0 1     0   4   18 16 0   4 0 20     0 34
2936062 2936062 WA King   school 5303540 17401   Highline School District 530354002976 5028 Big Picture School   Alternative School No High 06 12 2021   grade_7 16 1 8   0 5     0   5   23 11 1   4   1   15       0.0 35 16 1 8   0 5     0   5   23 11 1   4 1 15     0 35
460908 460908 WA Whatcom   school 5300570 37503   Blaine School District 530057003020 5021 Blaine Home Connections   Alternative Education School No 4.0 KG 11 2015   grade_7 4 0 0   0 0     0   0   2 2 0   0   0   0       0.0 4 4 0 0   0 0     0   0   2 2 0   0 0 0     0 4
520879 520879 WA Whatcom   school 5300570 37503   Blaine School District 530057003020 5021 Blaine Home Connections   Alternative Education School No 4 KG 11 2016   grade_7 7 0 1   0 0     0   0   1 7 0   0   0   1       0.0 8 7 0 1   0 0     0   0   1 7 0   0 0 1     0 8
618248 618248 WA Whatcom   school 5300570 37503   Blaine School District 530057003020 5021 Blaine Home Connections   Alternative School No Other KG 11 2017   grade_7 4 0 0   0 0     0   1   1 4 0   0   0   0       0.0 5 4 0 0   0 0     0   1   1 4 0   0 0 0     0 5
2414187 2414187 WA Whatcom   school 5300570 37503   Blaine School District 530057003020 5021 Blaine Home Connections   Alternative School No Other KG 11 2019   grade_7 8 0 0   0 0     0   1   6 3 0   0   0   2       0.0 9 8 0 0   0 0     0   1   6 3 0   0 0 2     0 9
2458736 2458736 WA Whatcom   school 5300570 37503   Blaine School District 530057003020 5021 Blaine Home Connections   Alternative School No Other KG 11 2018   grade_7 9 0 0   0 0     0   0   3 6 0   0   0   1       0.0 9 9 0 0   0 0     0   0   3 6 0   0 0 1     0 9
2571506 2571506 WA Whatcom   school 5300570 37503   Blaine School District 530057003020 5021 Blaine Home Connections   Alternative School No Other KG 11 2020   grade_7 5 0 0   0 0     0   0   3 2 0   0   0   1       0.0 5 5 0 0   0 0     0   0   3 2 0   0 0 1     0 5
2932407 2932407 WA Whatcom   school 5300570 37503   Blaine School District 530057003020 5021 Blaine Home Connections   Alternative School No Other KG 11 2021   grade_7 10 0 1   1 0     0   1   5 8 0   0   0   1       1.0 13 10 0 1   1 0     0   1   5 8 0   0 0 1     1 13
460914 460914 WA Whatcom   school 5300570 37503   Blaine School District 530057000131 3796 Blaine Middle School   Regular School No 2.0 06 08 2015   grade_7 134 1 25   2 4     6   10   84 98 0   2   3   97       9.0 182 134 1 25   2 4     6   10   84 98 0   2 3 97     9 182
520886 520886 WA Whatcom   school 5300570 37503   Blaine School District 530057000131 3796 Blaine Middle School   Regular School No 2 06 08 2016   grade_7 112 5 20   0 3     0   5   80 65 0   6   0   87       14.0 145 112 5 20   0 3     0   5   80 65 0   6 0 87     14 145

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