Data source: Big Local News · About: Big Local

15,758 rows where state = "WA" and year = 2017 sorted by county

View and edit SQL

grade

year

  • 2017 · 15,658
Link rowid state county ▼ county_state_id admin_level district_nces_id district_state_id district_state_type district school_nces_id school_state_id school school_state_type ccd_school_type ccd_charter_school ccd_school_lvl ccd_school_low_grade ccd_school_high_grade year term grade white black hispanic native_american native_american_alaskan_native asian native_hawaiian asian_pacific_islander native_hawaiian_pacific_islander pacific_islander multiracial unknown_race male female non_binary unknown_gender ell ell_percent homeless homeless_percent low_income free_and_reduced free_and_reduced_percent disability section_504 total white_int black_int hispanic_int native_american_int native_american_alaskan_native_int asian_int native_hawaiian_int asian_pacific_islander_int native_hawaiian_pacific_islander_int pacific_islander_int multiracial_int unknown_race_int male_int female_int non_binary_int unknown_gender_int ell_int homeless_int low_income_int free_and_reduced_int disability_int section_504_int total_int
632016 WA Adams   school 5309570 1109   Washtucna School District 530957001625 3075 Washtucna Elementary/High School   Regular School No Other KG 12 2017   grade_7 8 0 1   0 0     0   0   7 2 0   0   1   6       0.0 9 8 0 1   0 0     0   0   7 2 0   0 1 6     0 9
632017 WA Adams   school 5309570 1109   Washtucna School District 530957001625 3075 Washtucna Elementary/High School   Regular School No Other KG 12 2017   grade_8 6 0 0   0 0     0   0   4 2 0   0   0   4       0.0 6 6 0 0   0 0     0   0   4 2 0   0 0 4     0 6
632018 WA Adams   school 5309570 1109   Washtucna School District 530957001625 3075 Washtucna Elementary/High School   Regular School No Other KG 12 2017   grade_9 2 0 0   0 0     0   0   0 2 0   0   0   2       0.0 2 2 0 0   0 0     0   0   0 2 0   0 0 2     0 2
632019 WA Adams   school 5309570 1109   Washtucna School District 530957001625 3075 Washtucna Elementary/High School   Regular School No Other KG 12 2017   pk_12_total 47 0 5   0 0     0   0   30 22 0   0   2   39       0.0 52 47 0 5   0 0     0   0   30 22 0   0 2 39     0 52
632020 WA Adams   school 5309570 1109   Washtucna School District 530957001625 3075 Washtucna Elementary/High School   Regular School No Other KG 12 2017   kindergarten 4 0 0   0 0     0   0   3 1 0   0   0   4       0.0 4 4 0 0   0 0     0   0   3 1 0   0 0 4     0 4
632021 WA Adams   school 5309570 1109   Washtucna School District 530957001625 3075 Washtucna Elementary/High School   Regular School No Other KG 12 2017   pre_kindergarten 4 0 0   0 0     0   0   1 3 0   0   0   3       0.0 4 4 0 0   0 0     0   0   1 3 0   0 0 3     0 4
617258 WA Asotin   school 5300280 2420   Asotin-Anatone School District 530028000027 2507 Asotin Elementary   Regular School No Elementary PK 05 2017   grade_1 35 0 3   0 1     0   1   16 24 0   0   1   17       0.0 40 35 0 3   0 1     0   1   16 24 0   0 1 17     0 40
617259 WA Asotin   school 5300280 2420   Asotin-Anatone School District 530028000027 2507 Asotin Elementary   Regular School No Elementary PK 05 2017   grade_2 38 0 1   0 1     0   1   22 19 0   0   1   13       0.0 41 38 0 1   0 1     0   1   22 19 0   0 1 13     0 41
617260 WA Asotin   school 5300280 2420   Asotin-Anatone School District 530028000027 2507 Asotin Elementary   Regular School No Elementary PK 05 2017   grade_3 54 0 2   0 0     0   1   27 30 0   0   0   18       1.0 57 54 0 2   0 0     0   1   27 30 0   0 0 18     1 57
617261 WA Asotin   school 5300280 2420   Asotin-Anatone School District 530028000027 2507 Asotin Elementary   Regular School No Elementary PK 05 2017   grade_4 37 0 3   1 1     0   3   24 21 0   0   0   23       0.0 45 37 0 3   1 1     0   3   24 21 0   0 0 23     0 45
617262 WA Asotin   school 5300280 2420   Asotin-Anatone School District 530028000027 2507 Asotin Elementary   Regular School No Elementary PK 05 2017   grade_5 42 1 1   0 0     0   4   24 24 0   0   0   19       0.0 48 42 1 1   0 0     0   4   24 24 0   0 0 19     0 48
617263 WA Asotin   school 5300280 2420   Asotin-Anatone School District 530028000027 2507 Asotin Elementary   Regular School No Elementary PK 05 2017   pk_12_total 287 1 14   1 3     0   11   160 157 0   0   2   118       1.0 317 287 1 14   1 3     0   11   160 157 0   0 2 118     1 317
617264 WA Asotin   school 5300280 2420   Asotin-Anatone School District 530028000027 2507 Asotin Elementary   Regular School No Elementary PK 05 2017   kindergarten 44 0 3   0 0     0   1   28 20 0   0   0   17       0.0 48 44 0 3   0 0     0   1   28 20 0   0 0 17     0 48
617265 WA Asotin   school 5300280 2420   Asotin-Anatone School District 530028000027 2507 Asotin Elementary   Regular School No Elementary PK 05 2017   pre_kindergarten 37 0 1   0 0     0   0   19 19 0   0   0   11       0.0 38 37 0 1   0 0     0   0   19 19 0   0 0 11     0 38
617266 WA Asotin   school 5300280 2420   Asotin-Anatone School District 530028000028 2434 Asotin Jr Sr High   Regular School No Other 06 12 2017   grade_10 52 0 7   0 1     0   3   28 35 0   0   1   20       2.0 63 52 0 7   0 1     0   3   28 35 0   0 1 20     2 63
617267 WA Asotin   school 5300280 2420   Asotin-Anatone School District 530028000028 2434 Asotin Jr Sr High   Regular School No Other 06 12 2017   grade_11 41 0 5   1 0     0   5   26 26 0   0   3   16       4.0 52 41 0 5   1 0     0   5   26 26 0   0 3 16     4 52
617268 WA Asotin   school 5300280 2420   Asotin-Anatone School District 530028000028 2434 Asotin Jr Sr High   Regular School No Other 06 12 2017   grade_12 48 0 5   1 0     0   2   29 27 0   0   4   18       1.0 56 48 0 5   1 0     0   2   29 27 0   0 4 18     1 56
617269 WA Asotin   school 5300280 2420   Asotin-Anatone School District 530028000028 2434 Asotin Jr Sr High   Regular School No Other 06 12 2017   grade_6 46 0 3   0 0     0   4   24 29 0   0   1   21       1.0 53 46 0 3   0 0     0   4   24 29 0   0 1 21     1 53
617270 WA Asotin   school 5300280 2420   Asotin-Anatone School District 530028000028 2434 Asotin Jr Sr High   Regular School No Other 06 12 2017   grade_7 51 0 2   0 1     0   7   30 31 0   0   1   19       0.0 61 51 0 2   0 1     0   7   30 31 0   0 1 19     0 61
617271 WA Asotin   school 5300280 2420   Asotin-Anatone School District 530028000028 2434 Asotin Jr Sr High   Regular School No Other 06 12 2017   grade_8 46 0 3   1 1     0   2   25 28 0   0   2   15       4.0 53 46 0 3   1 1     0   2   25 28 0   0 2 15     4 53
617272 WA Asotin   school 5300280 2420   Asotin-Anatone School District 530028000028 2434 Asotin Jr Sr High   Regular School No Other 06 12 2017   grade_9 40 0 1   0 1     0   2   24 20 0   0   0   13       0.0 44 40 0 1   0 1     0   2   24 20 0   0 0 13     0 44
617273 WA Asotin   school 5300280 2420   Asotin-Anatone School District 530028000028 2434 Asotin Jr Sr High   Regular School No Other 06 12 2017   pk_12_total 324 0 26   3 4     0   25   186 196 0   0   12   122       12.0 382 324 0 26   3 4     0   25   186 196 0   0 12 122     12 382
619194 WA Asotin   school 5301320 2250   Clarkston School District 530132000234 2299 Charles Francis Adams High School   Regular School No High 09 12 2017   grade_10 152 5 13   3 4     1   10   97 91 0   3   9   90       11.0 188 152 5 13   3 4     1   10   97 91 0   3 9 90     11 188
619195 WA Asotin   school 5301320 2250   Clarkston School District 530132000234 2299 Charles Francis Adams High School   Regular School No High 09 12 2017   grade_11 183 4 11   7 1     1   3   101 109 0   3   10   106       5.0 210 183 4 11   7 1     1   3   101 109 0   3 10 106     5 210
619196 WA Asotin   school 5301320 2250   Clarkston School District 530132000234 2299 Charles Francis Adams High School   Regular School No High 09 12 2017   grade_12 168 1 15   3 2     0   4   98 95 0   2   12   66       4.0 193 168 1 15   3 2     0   4   98 95 0   2 12 66     4 193
619197 WA Asotin   school 5301320 2250   Clarkston School District 530132000234 2299 Charles Francis Adams High School   Regular School No High 09 12 2017   grade_9 204 2 14   12 2     0   6   116 124 0   1   11   130       9.0 240 204 2 14   12 2     0   6   116 124 0   1 11 130     9 240
619198 WA Asotin   school 5301320 2250   Clarkston School District 530132000234 2299 Charles Francis Adams High School   Regular School No High 09 12 2017   pk_12_total 707 12 53   25 9     2   23   412 419 0   9   42   392       29.0 831 707 12 53   25 9     2   23   412 419 0   9 42 392     29 831
619199 WA Asotin   school 5301320 2250   Clarkston School District 530132000990 1617 Educational Opportunity Center   Alternative School No High 07 12 2017   grade_10 3 0 0   0 0     0   0   1 2 0   0   0   2       0.0 3 3 0 0   0 0     0   0   1 2 0   0 0 2     0 3
619200 WA Asotin   school 5301320 2250   Clarkston School District 530132000990 1617 Educational Opportunity Center   Alternative School No High 07 12 2017   grade_11 11 1 1   0 0     0   0   7 6 0   0   1   9       0.0 13 11 1 1   0 0     0   0   7 6 0   0 1 9     0 13
619201 WA Asotin   school 5301320 2250   Clarkston School District 530132000990 1617 Educational Opportunity Center   Alternative School No High 07 12 2017   grade_12 52 0 4   1 0     0   5   29 33 0   0   3   29       0.0 62 52 0 4   1 0     0   5   29 33 0   0 3 29     0 62
619202 WA Asotin   school 5301320 2250   Clarkston School District 530132000990 1617 Educational Opportunity Center   Alternative School No High 07 12 2017   grade_9 1 0 0   0 0     0   0   0 1 0   0   0   1       1.0 1 1 0 0   0 0     0   0   0 1 0   0 0 1     1 1
619203 WA Asotin   school 5301320 2250   Clarkston School District 530132000990 1617 Educational Opportunity Center   Alternative School No High 07 12 2017   pk_12_total 67 1 5   1 0     0   5   37 42 0   0   4   41       1.0 79 67 1 5   1 0     0   5   37 42 0   0 4 41     1 79
619204 WA Asotin   school 5301320 2250   Clarkston School District 530132003506 5413 Educational Opportunity Center Reengagement   Alternative School No High 11 13 2017   grade_11 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
619205 WA Asotin   school 5301320 2250   Clarkston School District 530132003506 5413 Educational Opportunity Center Reengagement   Alternative School No High 11 13 2017   grade_12 6 0 1   0 0     0   0   2 5 0   0   0   5       1.0 7 6 0 1   0 0     0   0   2 5 0   0 0 5     1 7
619206 WA Asotin   school 5301320 2250   Clarkston School District 530132003506 5413 Educational Opportunity Center Reengagement   Alternative School No High 11 13 2017   pk_12_total 7 0 1   0 0     0   0   3 5 0   0   0   6       1.0 8 7 0 1   0 0     0   0   3 5 0   0 0 6     1 8
619207 WA Asotin   school 5301320 2250   Clarkston School District 530132000235 2962 Grantham Elementary   Regular School No Elementary KG 06 2017   grade_1 32 0 2   0 0     0   2   17 19 0   0   2   30       0.0 36 32 0 2   0 0     0   2   17 19 0   0 2 30     0 36
619208 WA Asotin   school 5301320 2250   Clarkston School District 530132000235 2962 Grantham Elementary   Regular School No Elementary KG 06 2017   grade_2 37 0 1   0 0     0   1   18 21 0   0   5   32       1.0 39 37 0 1   0 0     0   1   18 21 0   0 5 32     1 39
619209 WA Asotin   school 5301320 2250   Clarkston School District 530132000235 2962 Grantham Elementary   Regular School No Elementary KG 06 2017   grade_3 33 1 6   0 0     0   4   27 17 0   0   6   41       0.0 44 33 1 6   0 0     0   4   27 17 0   0 6 41     0 44
619210 WA Asotin   school 5301320 2250   Clarkston School District 530132000235 2962 Grantham Elementary   Regular School No Elementary KG 06 2017   grade_4 32 0 4   2 0     0   5   21 22 0   1   5   34       2.0 43 32 0 4   2 0     0   5   21 22 0   1 5 34     2 43
619211 WA Asotin   school 5301320 2250   Clarkston School District 530132000235 2962 Grantham Elementary   Regular School No Elementary KG 06 2017   grade_5 30 1 2   1 0     0   5   25 14 0   0   7   29       2.0 39 30 1 2   1 0     0   5   25 14 0   0 7 29     2 39
619212 WA Asotin   school 5301320 2250   Clarkston School District 530132000235 2962 Grantham Elementary   Regular School No Elementary KG 06 2017   grade_6 30 1 4   1 0     0   0   25 11 0   0   7   31       2.0 36 30 1 4   1 0     0   0   25 11 0   0 7 31     2 36
619213 WA Asotin   school 5301320 2250   Clarkston School District 530132000235 2962 Grantham Elementary   Regular School No Elementary KG 06 2017   pk_12_total 230 4 22   4 0     0   21   160 121 0   1   39   235       8.0 281 230 4 22   4 0     0   21   160 121 0   1 39 235     8 281
619214 WA Asotin   school 5301320 2250   Clarkston School District 530132000235 2962 Grantham Elementary   Regular School No Elementary KG 06 2017   kindergarten_half_day 0 0 0   0 0     0   1   1 0 0   0   0   1       0.0 1 0 0 0   0 0     0   1   1 0 0   0 0 1     0 1
619215 WA Asotin   school 5301320 2250   Clarkston School District 530132000235 2962 Grantham Elementary   Regular School No Elementary KG 06 2017   kindergarten 35 1 3   0 0     0   3   26 16 0   0   6   36       1.0 42 35 1 3   0 0     0   3   26 16 0   0 6 36     1 42
619216 WA Asotin   school 5301320 2250   Clarkston School District 530132000235 2962 Grantham Elementary   Regular School No Elementary KG 06 2017   pre_kindergarten 1 0 0   0 0     0   0   0 1 0   0   1   1       0.0 1 1 0 0   0 0     0   0   0 1 0   0 1 1     0 1
619217 WA Asotin   school 5301320 2250   Clarkston School District 530132002433 4384 Heights Elementary   Regular School No Elementary KG 06 2017   grade_1 40 0 3   0 0     0   5   21 27 0   0   1   13       1.0 48 40 0 3   0 0     0   5   21 27 0   0 1 13     1 48
619218 WA Asotin   school 5301320 2250   Clarkston School District 530132002433 4384 Heights Elementary   Regular School No Elementary KG 06 2017   grade_2 39 0 5   0 1     0   3   32 16 0   0   3   22       2.0 48 39 0 5   0 1     0   3   32 16 0   0 3 22     2 48
619219 WA Asotin   school 5301320 2250   Clarkston School District 530132002433 4384 Heights Elementary   Regular School No Elementary KG 06 2017   grade_3 44 1 2   0 0     0   2   18 31 0   0   0   20       1.0 49 44 1 2   0 0     0   2   18 31 0   0 0 20     1 49
619220 WA Asotin   school 5301320 2250   Clarkston School District 530132002433 4384 Heights Elementary   Regular School No Elementary KG 06 2017   grade_4 47 1 5   0 1     0   1   24 31 0   0   2   19       2.0 55 47 1 5   0 1     0   1   24 31 0   0 2 19     2 55
619221 WA Asotin   school 5301320 2250   Clarkston School District 530132002433 4384 Heights Elementary   Regular School No Elementary KG 06 2017   grade_5 62 1 2   0 0     0   3   34 34 0   0   2   27       0.0 68 62 1 2   0 0     0   3   34 34 0   0 2 27     0 68
619222 WA Asotin   school 5301320 2250   Clarkston School District 530132002433 4384 Heights Elementary   Regular School No Elementary KG 06 2017   grade_6 49 0 4   1 0     0   3   26 31 0   0   0   20       3.0 57 49 0 4   1 0     0   3   26 31 0   0 0 20     3 57
619223 WA Asotin   school 5301320 2250   Clarkston School District 530132002433 4384 Heights Elementary   Regular School No Elementary KG 06 2017   pk_12_total 323 4 21   2 2     0   22   172 202 0   0   9   140       10.0 374 323 4 21   2 2     0   22   172 202 0   0 9 140     10 374
619224 WA Asotin   school 5301320 2250   Clarkston School District 530132002433 4384 Heights Elementary   Regular School No Elementary KG 06 2017   kindergarten 42 1 0   1 0     0   5   17 32 0   0   1   19       1.0 49 42 1 0   1 0     0   5   17 32 0   0 1 19     1 49
619225 WA Asotin   school 5301320 2250   Clarkston School District 530132000236 3266 Highland Elementary   Regular School No Elementary KG 06 2017   grade_1 28 0 6   1 0     0   1   14 22 0   4   5   30       0.0 36 28 0 6   1 0     0   1   14 22 0   4 5 30     0 36
619226 WA Asotin   school 5301320 2250   Clarkston School District 530132000236 3266 Highland Elementary   Regular School No Elementary KG 06 2017   grade_2 38 1 3   0 0     0   4   24 22 0   1   5   36       1.0 46 38 1 3   0 0     0   4   24 22 0   1 5 36     1 46
619227 WA Asotin   school 5301320 2250   Clarkston School District 530132000236 3266 Highland Elementary   Regular School No Elementary KG 06 2017   grade_3 32 0 8   0 2     0   1   23 20 0   0   0   35       1.0 43 32 0 8   0 2     0   1   23 20 0   0 0 35     1 43
619228 WA Asotin   school 5301320 2250   Clarkston School District 530132000236 3266 Highland Elementary   Regular School No Elementary KG 06 2017   grade_4 37 0 5   1 2     0   2   21 26 0   6   5   36       1.0 47 37 0 5   1 2     0   2   21 26 0   6 5 36     1 47
619229 WA Asotin   school 5301320 2250   Clarkston School District 530132000236 3266 Highland Elementary   Regular School No Elementary KG 06 2017   grade_5 35 0 11   1 0     0   3   25 25 0   1   3   36       1.0 50 35 0 11   1 0     0   3   25 25 0   1 3 36     1 50
619230 WA Asotin   school 5301320 2250   Clarkston School District 530132000236 3266 Highland Elementary   Regular School No Elementary KG 06 2017   grade_6 43 0 4   0 0     0   5   24 28 0   0   3   37       1.0 52 43 0 4   0 0     0   5   24 28 0   0 3 37     1 52
619231 WA Asotin   school 5301320 2250   Clarkston School District 530132000236 3266 Highland Elementary   Regular School No Elementary KG 06 2017   pk_12_total 245 2 45   4 4     0   20   155 165 0   13   22   243       6.0 320 245 2 45   4 4     0   20   155 165 0   13 22 243     6 320
619232 WA Asotin   school 5301320 2250   Clarkston School District 530132000236 3266 Highland Elementary   Regular School No Elementary KG 06 2017   kindergarten_half_day 2 0 2   0 0     0   0   3 1 0   0   0   1       0.0 4 2 0 2   0 0     0   0   3 1 0   0 0 1     0 4
619233 WA Asotin   school 5301320 2250   Clarkston School District 530132000236 3266 Highland Elementary   Regular School No Elementary KG 06 2017   kindergarten 30 1 6   1 0     0   4   21 21 0   1   1   32       1.0 42 30 1 6   1 0     0   4   21 21 0   1 1 32     1 42
619234 WA Asotin   school 5301320 2250   Clarkston School District 530132000237 2501 Lincoln Middle School   Regular School No Middle 07 08 2017   grade_7 165 4 15   4 2     0   8   106 92 0   0   14   126       14.0 198 165 4 15   4 2     0   8   106 92 0   0 14 126     14 198
619235 WA Asotin   school 5301320 2250   Clarkston School District 530132000237 2501 Lincoln Middle School   Regular School No Middle 07 08 2017   grade_8 184 4 15   4 4     0   4   106 109 0   1   6   127       13.0 215 184 4 15   4 4     0   4   106 109 0   1 6 127     13 215
619236 WA Asotin   school 5301320 2250   Clarkston School District 530132000237 2501 Lincoln Middle School   Regular School No Middle 07 08 2017   pk_12_total 349 8 30   8 6     0   12   212 201 0   1   20   253       27.0 413 349 8 30   8 6     0   12   212 201 0   1 20 253     27 413
619237 WA Asotin   school 5301320 2250   Clarkston School District 530132000238 2823 Parkway Elementary   Regular School No Elementary KG 06 2017   grade_1 40 1 5   3 0     0   2   27 24 0   0   6   38       1.0 51 40 1 5   3 0     0   2   27 24 0   0 6 38     1 51
619238 WA Asotin   school 5301320 2250   Clarkston School District 530132000238 2823 Parkway Elementary   Regular School No Elementary KG 06 2017   grade_2 37 1 4   2 0     0   0   24 20 0   0   1   31       2.0 44 37 1 4   2 0     0   0   24 20 0   0 1 31     2 44
619239 WA Asotin   school 5301320 2250   Clarkston School District 530132000238 2823 Parkway Elementary   Regular School No Elementary KG 06 2017   grade_3 28 3 6   1 2     0   0   14 26 0   1   2   29       1.0 40 28 3 6   1 2     0   0   14 26 0   1 2 29     1 40
619240 WA Asotin   school 5301320 2250   Clarkston School District 530132000238 2823 Parkway Elementary   Regular School No Elementary KG 06 2017   grade_4 47 1 2   0 0     0   1   28 23 0   0   1   41       2.0 51 47 1 2   0 0     0   1   28 23 0   0 1 41     2 51
619241 WA Asotin   school 5301320 2250   Clarkston School District 530132000238 2823 Parkway Elementary   Regular School No Elementary KG 06 2017   grade_5 43 1 5   0 1     0   0   31 19 0   0   2   38       1.0 50 43 1 5   0 1     0   0   31 19 0   0 2 38     1 50
619242 WA Asotin   school 5301320 2250   Clarkston School District 530132000238 2823 Parkway Elementary   Regular School No Elementary KG 06 2017   grade_6 46 2 3   2 0     0   1   27 27 0   0   0   42       2.0 54 46 2 3   2 0     0   1   27 27 0   0 0 42     2 54
619243 WA Asotin   school 5301320 2250   Clarkston School District 530132000238 2823 Parkway Elementary   Regular School No Elementary KG 06 2017   pk_12_total 289 9 29   8 3     0   9   173 174 0   1   14   257       9.0 347 289 9 29   8 3     0   9   173 174 0   1 14 257     9 347
619244 WA Asotin   school 5301320 2250   Clarkston School District 530132000238 2823 Parkway Elementary   Regular School No Elementary KG 06 2017   kindergarten 48 0 4   0 0     0   5   22 35 0   0   2   38       0.0 57 48 0 4   0 0     0   5   22 35 0   0 2 38     0 57
619245 WA Asotin   school 5301320 2250   Clarkston School District 530132002613 3616 Special Services   Special Education School No Other PK 12 2017   grade_12 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
619246 WA Asotin   school 5301320 2250   Clarkston School District 530132002613 3616 Special Services   Special Education School No Other PK 12 2017   grade_1 2 0 0   0 0     0   0   0 2 0   0   0   1       0.0 2 2 0 0   0 0     0   0   0 2 0   0 0 1     0 2
619247 WA Asotin   school 5301320 2250   Clarkston School District 530132002613 3616 Special Services   Special Education School No Other PK 12 2017   grade_2 1 0 0   0 1     0   0   2 0 0   0   0   1       0.0 2 1 0 0   0 1     0   0   2 0 0   0 0 1     0 2
619248 WA Asotin   school 5301320 2250   Clarkston School District 530132002613 3616 Special Services   Special Education School No Other PK 12 2017   grade_3 4 0 0   0 1     0   0   4 1 0   0   0   0       0.0 5 4 0 0   0 1     0   0   4 1 0   0 0 0     0 5
619249 WA Asotin   school 5301320 2250   Clarkston School District 530132002613 3616 Special Services   Special Education School No Other PK 12 2017   grade_4 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
619250 WA Asotin   school 5301320 2250   Clarkston School District 530132002613 3616 Special Services   Special Education School No Other PK 12 2017   grade_5 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
619251 WA Asotin   school 5301320 2250   Clarkston School District 530132002613 3616 Special Services   Special Education School No Other PK 12 2017   pk_12_total 60 1 1   0 2     0   2   40 26 0   0   0   30       0.0 66 60 1 1   0 2     0   2   40 26 0   0 0 30     0 66
619252 WA Asotin   school 5301320 2250   Clarkston School District 530132002613 3616 Special Services   Special Education School No Other PK 12 2017   pre_kindergarten 50 1 1   0 0     0   2   32 22 0   0   0   27       0.0 54 50 1 1   0 0     0   2   32 22 0   0 0 27     0 54
621569 WA Benton   school 5302910 3053   Finley School District 530291000468 3078 Finley Elementary   Regular School No Elementary PK 05 2017   grade_1 37 0 25   0 0     0   4   35 31 0   17   0   51       1.0 66 37 0 25   0 0     0   4   35 31 0   17 0 51     1 66
621570 WA Benton   school 5302910 3053   Finley School District 530291000468 3078 Finley Elementary   Regular School No Elementary PK 05 2017   grade_2 31 0 29   0 0     0   3   38 25 0   20   0   52       3.0 63 31 0 29   0 0     0   3   38 25 0   20 0 52     3 63
621571 WA Benton   school 5302910 3053   Finley School District 530291000468 3078 Finley Elementary   Regular School No Elementary PK 05 2017   grade_3 36 0 33   1 0     0   3   36 37 0   14   1   60       5.0 73 36 0 33   1 0     0   3   36 37 0   14 1 60     5 73
621572 WA Benton   school 5302910 3053   Finley School District 530291000468 3078 Finley Elementary   Regular School No Elementary PK 05 2017   grade_4 31 1 24   0 0     0   1   21 36 0   10   1   50       1.0 57 31 1 24   0 0     0   1   21 36 0   10 1 50     1 57
621573 WA Benton   school 5302910 3053   Finley School District 530291000468 3078 Finley Elementary   Regular School No Elementary PK 05 2017   grade_5 26 0 35   0 0     0   2   36 27 0   14   1   50       1.0 63 26 0 35   0 0     0   2   36 27 0   14 1 50     1 63
621574 WA Benton   school 5302910 3053   Finley School District 530291000468 3078 Finley Elementary   Regular School No Elementary PK 05 2017   pk_12_total 194 1 179   1 0     0   15   201 189 0   97   4   310       11.0 390 194 1 179   1 0     0   15   201 189 0   97 4 310     11 390
621575 WA Benton   school 5302910 3053   Finley School District 530291000468 3078 Finley Elementary   Regular School No Elementary PK 05 2017   kindergarten_half_day 0 0 4   0 0     0   0   3 1 0   3   0   3       0.0 4 0 0 4   0 0     0   0   3 1 0   3 0 3     0 4
621576 WA Benton   school 5302910 3053   Finley School District 530291000468 3078 Finley Elementary   Regular School No Elementary PK 05 2017   kindergarten 25 0 26   0 0     0   2   24 29 0   17   0   36       0.0 53 25 0 26   0 0     0   2   24 29 0   17 0 36     0 53
621577 WA Benton   school 5302910 3053   Finley School District 530291000468 3078 Finley Elementary   Regular School No Elementary PK 05 2017   pre_kindergarten 8 0 3   0 0     0   0   8 3 0   2   1   8       0.0 11 8 0 3   0 0     0   0   8 3 0   2 1 8     0 11
621578 WA Benton   school 5302910 3053   Finley School District 530291002100 4031 Finley Middle School   Regular School No Middle 06 08 2017   grade_6 31 1 37   0 0     0   2   43 28 0   16   0   50       0.0 71 31 1 37   0 0     0   2   43 28 0   16 0 50     0 71
621579 WA Benton   school 5302910 3053   Finley School District 530291002100 4031 Finley Middle School   Regular School No Middle 06 08 2017   grade_7 37 0 28   0 0     0   3   34 34 0   12   3   51       3.0 68 37 0 28   0 0     0   3   34 34 0   12 3 51     3 68
621580 WA Benton   school 5302910 3053   Finley School District 530291002100 4031 Finley Middle School   Regular School No Middle 06 08 2017   grade_8 32 0 38   0 0     0   2   41 31 0   7   1   56       4.0 72 32 0 38   0 0     0   2   41 31 0   7 1 56     4 72
621581 WA Benton   school 5302910 3053   Finley School District 530291002100 4031 Finley Middle School   Regular School No Middle 06 08 2017   pk_12_total 100 1 103   0 0     0   7   118 93 0   35   4   157       7.0 211 100 1 103   0 0     0   7   118 93 0   35 4 157     7 211
621582 WA Benton   school 5302910 3053   Finley School District 530291000469 2367 River View High School   Regular School No High 09 12 2017   grade_10 32 0 43   0 0     0   3   48 30 0   8   1   66       2.0 78 32 0 43   0 0     0   3   48 30 0   8 1 66     2 78
621583 WA Benton   school 5302910 3053   Finley School District 530291000469 2367 River View High School   Regular School No High 09 12 2017   grade_11 53 0 38   0 3     0   8   53 49 0   7   1   69       3.0 102 53 0 38   0 3     0   8   53 49 0   7 1 69     3 102
621584 WA Benton   school 5302910 3053   Finley School District 530291000469 2367 River View High School   Regular School No High 09 12 2017   grade_12 45 1 26   0 0     0   1   36 37 0   3   2   53       3.0 73 45 1 26   0 0     0   1   36 37 0   3 2 53     3 73
621585 WA Benton   school 5302910 3053   Finley School District 530291000469 2367 River View High School   Regular School No High 09 12 2017   grade_9 44 2 28   1 1     0   0   42 34 0   10   1   57       0.0 76 44 2 28   1 1     0   0   42 34 0   10 1 57     0 76
621586 WA Benton   school 5302910 3053   Finley School District 530291000469 2367 River View High School   Regular School No High 09 12 2017   pk_12_total 174 3 135   1 4     0   12   179 150 0   28   5   245       8.0 329 174 3 135   1 4     0   12   179 150 0   28 5 245     8 329
622558 WA Benton   school 5303930 3017   Kennewick School District 530393000701 4418 Amistad Elementary School   Regular School No Elementary PK 05 2017   grade_1 20 3 55   0 1     0   4   43 40 0   53   1   80       2.0 83 20 3 55   0 1     0   4   43 40 0   53 1 80     2 83

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