Data source: Big Local News · About: Big Local

15,740 rows where state = "WA" and year = 2021 sorted by county

View and edit SQL

grade

year

  • 2021 · 15,640
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
2946181 WA Adams   school 5309570 1109   Washtucna School District 530957001625 3075 Washtucna Elementary/High School   Regular School No Other PK 12 2021   kindergarten 3 0 0   0 0     0   0   2 1 0   0   0   1       0.0 3 3 0 0   0 0     0   0   2 1 0   0 0 1     0 3
2946182 WA Adams   school 5309570 1109   Washtucna School District 530957001625 3075 Washtucna Elementary/High School   Regular School No Other PK 12 2021   pre_kindergarten 4 0 1   0 0     0   0   3 2 0   0   0   5       0.0 5 4 0 1   0 0     0   0   3 2 0   0 0 5     0 5
2931407 WA Asotin   school 5300280 2420   Asotin-Anatone School District 530028000027 2507 Asotin Elementary   Regular School No Elementary PK 05 2021   grade_1 29 0 2   0 0     0   0   16 15 0   0   0   7       0.0 31 29 0 2   0 0     0   0   16 15 0   0 0 7     0 31
2931408 WA Asotin   school 5300280 2420   Asotin-Anatone School District 530028000027 2507 Asotin Elementary   Regular School No Elementary PK 05 2021   grade_2 47 0 3   0 1     2   3   34 22 0   0   0   25       0.0 56 47 0 3   0 1     2   3   34 22 0   0 0 25     0 56
2931409 WA Asotin   school 5300280 2420   Asotin-Anatone School District 530028000027 2507 Asotin Elementary   Regular School No Elementary PK 05 2021   grade_3 37 0 0   0 1     0   2   18 22 0   0   0   17       0.0 40 37 0 0   0 1     0   2   18 22 0   0 0 17     0 40
2931410 WA Asotin   school 5300280 2420   Asotin-Anatone School District 530028000027 2507 Asotin Elementary   Regular School No Elementary PK 05 2021   grade_4 40 0 4   0 0     0   1   28 17 0   0   0   16       1.0 45 40 0 4   0 0     0   1   28 17 0   0 0 16     1 45
2931411 WA Asotin   school 5300280 2420   Asotin-Anatone School District 530028000027 2507 Asotin Elementary   Regular School No Elementary PK 05 2021   grade_5 34 0 1   0 1     0   2   16 22 0   0   0   16       0.0 38 34 0 1   0 1     0   2   16 22 0   0 0 16     0 38
2931412 WA Asotin   school 5300280 2420   Asotin-Anatone School District 530028000027 2507 Asotin Elementary   Regular School No Elementary PK 05 2021   pk_12_total 264 0 12   0 3     2   11   159 133 0   0   0   105       1.0 292 264 0 12   0 3     2   11   159 133 0   0 0 105     1 292
2931413 WA Asotin   school 5300280 2420   Asotin-Anatone School District 530028000027 2507 Asotin Elementary   Regular School No Elementary PK 05 2021   kindergarten 70 0 2   0 0     0   3   43 32 0   0   0   21       0.0 75 70 0 2   0 0     0   3   43 32 0   0 0 21     0 75
2931414 WA Asotin   school 5300280 2420   Asotin-Anatone School District 530028000027 2507 Asotin Elementary   Regular School No Elementary PK 05 2021   pre_kindergarten 7 0 0   0 0     0   0   4 3 0   0   0   3       0.0 7 7 0 0   0 0     0   0   4 3 0   0 0 3     0 7
2931415 WA Asotin   school 5300280 2420   Asotin-Anatone School District 530028000028 2434 Asotin Jr Sr High   Regular School No High 06 12 2021   grade_10 41 0 5   0 0     1   2   21 28 0   0   0   18       1.0 49 41 0 5   0 0     1   2   21 28 0   0 0 18     1 49
2931416 WA Asotin   school 5300280 2420   Asotin-Anatone School District 530028000028 2434 Asotin Jr Sr High   Regular School No High 06 12 2021   grade_11 43 0 2   0 1     0   6   26 26 0   0   0   10       2.0 52 43 0 2   0 1     0   6   26 26 0   0 0 10     2 52
2931417 WA Asotin   school 5300280 2420   Asotin-Anatone School District 530028000028 2434 Asotin Jr Sr High   Regular School No High 06 12 2021   grade_12 42 0 3   1 1     0   3   25 25 0   0   1   15       2.0 50 42 0 3   1 1     0   3   25 25 0   0 1 15     2 50
2931418 WA Asotin   school 5300280 2420   Asotin-Anatone School District 530028000028 2434 Asotin Jr Sr High   Regular School No High 06 12 2021   grade_6 38 0 2   0 0     0   4   24 20 0   0   0   17       1.0 44 38 0 2   0 0     0   4   24 20 0   0 0 17     1 44
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
2931420 WA Asotin   school 5300280 2420   Asotin-Anatone School District 530028000028 2434 Asotin Jr Sr High   Regular School No High 06 12 2021   grade_8 30 0 3   1 1     0   3   20 18 0   0   0   14       0.0 38 30 0 3   1 1     0   3   20 18 0   0 0 14     0 38
2931421 WA Asotin   school 5300280 2420   Asotin-Anatone School District 530028000028 2434 Asotin Jr Sr High   Regular School No High 06 12 2021   grade_9 32 1 1   0 0     0   3   20 17 0   0   0   10       1.0 37 32 1 1   0 0     0   3   20 17 0   0 0 10     1 37
2931422 WA Asotin   school 5300280 2420   Asotin-Anatone School District 530028000028 2434 Asotin Jr Sr High   Regular School No High 06 12 2021   pk_12_total 279 1 18   2 3     1   23   159 168 0   0   1   96       7.0 327 279 1 18   2 3     1   23   159 168 0   0 1 96     7 327
2933406 WA Asotin   school 5301320 2250   Clarkston School District 530132000234 2299 Charles Francis Adams High School   Regular School No High 09 12 2021   grade_10 171 3 16   3 3     0   10   101 105 0   0   9   106       9.0 206 171 3 16   3 3     0   10   101 105 0   0 9 106     9 206
2933407 WA Asotin   school 5301320 2250   Clarkston School District 530132000234 2299 Charles Francis Adams High School   Regular School No High 09 12 2021   grade_11 160 3 14   5 2     0   11   104 91 0   0   8   97       14.0 195 160 3 14   5 2     0   11   104 91 0   0 8 97     14 195
2933408 WA Asotin   school 5301320 2250   Clarkston School District 530132000234 2299 Charles Francis Adams High School   Regular School No High 09 12 2021   grade_12 165 2 11   3 4     0   5   93 97 0   1   12   90       8.0 190 165 2 11   3 4     0   5   93 97 0   1 12 90     8 190
2933409 WA Asotin   school 5301320 2250   Clarkston School District 530132000234 2299 Charles Francis Adams High School   Regular School No High 09 12 2021   grade_9 185 3 21   2 4     0   13   121 107 0   2   11   127       6.0 228 185 3 21   2 4     0   13   121 107 0   2 11 127     6 228
2933410 WA Asotin   school 5301320 2250   Clarkston School District 530132000234 2299 Charles Francis Adams High School   Regular School No High 09 12 2021   pk_12_total 681 11 62   13 13     0   39   419 400 0   3   40   420       37.0 819 681 11 62   13 13     0   39   419 400 0   3 40 420     37 819
2933411 WA Asotin   school 5301320 2250   Clarkston School District 530132003725 5644 Clarkston Home Alliance   Alternative School No Other KG 12 2021   grade_1 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
2933412 WA Asotin   school 5301320 2250   Clarkston School District 530132003725 5644 Clarkston Home Alliance   Alternative School No Other KG 12 2021   grade_2 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
2933413 WA Asotin   school 5301320 2250   Clarkston School District 530132003725 5644 Clarkston Home Alliance   Alternative School No Other KG 12 2021   grade_3 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
2933414 WA Asotin   school 5301320 2250   Clarkston School District 530132003725 5644 Clarkston Home Alliance   Alternative School No Other KG 12 2021   grade_4 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
2933415 WA Asotin   school 5301320 2250   Clarkston School District 530132003725 5644 Clarkston Home Alliance   Alternative School No Other KG 12 2021   grade_8 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
2933416 WA Asotin   school 5301320 2250   Clarkston School District 530132003725 5644 Clarkston Home Alliance   Alternative School No Other KG 12 2021   grade_9 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
2933417 WA Asotin   school 5301320 2250   Clarkston School District 530132003725 5644 Clarkston Home Alliance   Alternative School No Other KG 12 2021   pk_12_total 10 0 0   0 0     0   0   3 7 0   0   0   2       0.0 10 10 0 0   0 0     0   0   3 7 0   0 0 2     0 10
2933418 WA Asotin   school 5301320 2250   Clarkston School District 530132003725 5644 Clarkston Home Alliance   Alternative School No Other KG 12 2021   kindergarten_half_day 2 0 0   0 0     0   0   0 2 0   0   0   0       0.0 2 2 0 0   0 0     0   0   0 2 0   0 0 0     0 2
2933419 WA Asotin   school 5301320 2250   Clarkston School District 530132003725 5644 Clarkston Home Alliance   Alternative School No Other KG 12 2021   kindergarten 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
2933420 WA Asotin   school 5301320 2250   Clarkston School District 530132000990 1617 Educational Opportunity Center   Alternative School No High 07 12 2021   grade_10 8 0 0   0 0     0   0   3 5 0   0   0   8       1.0 8 8 0 0   0 0     0   0   3 5 0   0 0 8     1 8
2933421 WA Asotin   school 5301320 2250   Clarkston School District 530132000990 1617 Educational Opportunity Center   Alternative School No High 07 12 2021   grade_11 17 0 0   1 0     0   0   12 6 0   0   2   14       2.0 18 17 0 0   1 0     0   0   12 6 0   0 2 14     2 18
2933422 WA Asotin   school 5301320 2250   Clarkston School District 530132000990 1617 Educational Opportunity Center   Alternative School No High 07 12 2021   grade_12 30 1 3   0 0     0   0   16 18 0   0   5   23       1.0 34 30 1 3   0 0     0   0   16 18 0   0 5 23     1 34
2933423 WA Asotin   school 5301320 2250   Clarkston School District 530132000990 1617 Educational Opportunity Center   Alternative School No High 07 12 2021   grade_9 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
2933424 WA Asotin   school 5301320 2250   Clarkston School District 530132000990 1617 Educational Opportunity Center   Alternative School No High 07 12 2021   pk_12_total 56 1 3   1 0     0   0   32 29 0   0   7   45       4.0 61 56 1 3   1 0     0   0   32 29 0   0 7 45     4 61
2933425 WA Asotin   school 5301320 2250   Clarkston School District 530132003506 5413 Educational Opportunity Center Reengagement   Alternative School No High 11 12 2021   grade_12 13 1 1   0 0     0   0   5 10 0   0   1   8       0.0 15 13 1 1   0 0     0   0   5 10 0   0 1 8     0 15
2933426 WA Asotin   school 5301320 2250   Clarkston School District 530132003506 5413 Educational Opportunity Center Reengagement   Alternative School No High 11 12 2021   pk_12_total 13 1 1   0 0     0   0   5 10 0   0   1   8       0.0 15 13 1 1   0 0     0   0   5 10 0   0 1 8     0 15
2933427 WA Asotin   school 5301320 2250   Clarkston School District 530132000235 2962 Grantham Elementary   Regular School No Elementary KG 06 2021   grade_1 32 0 5   0 0     0   4   27 14 0   0   0   35       1.0 41 32 0 5   0 0     0   4   27 14 0   0 0 35     1 41
2933428 WA Asotin   school 5301320 2250   Clarkston School District 530132000235 2962 Grantham Elementary   Regular School No Elementary KG 06 2021   grade_2 20 0 7   0 0     0   1   17 11 0   0   3   24       1.0 28 20 0 7   0 0     0   1   17 11 0   0 3 24     1 28
2933429 WA Asotin   school 5301320 2250   Clarkston School District 530132000235 2962 Grantham Elementary   Regular School No Elementary KG 06 2021   grade_3 27 0 6   2 0     0   1   15 21 0   0   3   30       1.0 36 27 0 6   2 0     0   1   15 21 0   0 3 30     1 36
2933430 WA Asotin   school 5301320 2250   Clarkston School District 530132000235 2962 Grantham Elementary   Regular School No Elementary KG 06 2021   grade_4 23 1 4   0 0     0   5   16 17 0   0   1   26       0.0 33 23 1 4   0 0     0   5   16 17 0   0 1 26     0 33
2933431 WA Asotin   school 5301320 2250   Clarkston School District 530132000235 2962 Grantham Elementary   Regular School No Elementary KG 06 2021   grade_5 42 0 5   1 0     0   2   26 24 0   0   4   35       3.0 50 42 0 5   1 0     0   2   26 24 0   0 4 35     3 50
2933432 WA Asotin   school 5301320 2250   Clarkston School District 530132000235 2962 Grantham Elementary   Regular School No Elementary KG 06 2021   grade_6 24 0 0   0 0     0   1   13 12 0   0   1   20       2.0 25 24 0 0   0 0     0   1   13 12 0   0 1 20     2 25
2933433 WA Asotin   school 5301320 2250   Clarkston School District 530132000235 2962 Grantham Elementary   Regular School No Elementary KG 06 2021   pk_12_total 222 1 34   5 0     0   16   155 123 0   0   14   218       8.0 278 222 1 34   5 0     0   16   155 123 0   0 14 218     8 278
2933434 WA Asotin   school 5301320 2250   Clarkston School District 530132000235 2962 Grantham Elementary   Regular School No Elementary KG 06 2021   kindergarten_half_day 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
2933435 WA Asotin   school 5301320 2250   Clarkston School District 530132000235 2962 Grantham Elementary   Regular School No Elementary KG 06 2021   kindergarten 53 0 7   2 0     0   2   40 24 0   0   2   48       0.0 64 53 0 7   2 0     0   2   40 24 0   0 2 48     0 64
2933436 WA Asotin   school 5301320 2250   Clarkston School District 530132002433 4384 Heights Elementary   Regular School No Elementary KG 06 2021   grade_1 35 0 3   0 0     0   3   21 20 0   0   0   14       1.0 41 35 0 3   0 0     0   3   21 20 0   0 0 14     1 41
2933437 WA Asotin   school 5301320 2250   Clarkston School District 530132002433 4384 Heights Elementary   Regular School No Elementary KG 06 2021   grade_2 50 1 3   0 1     0   0   27 28 0   1   0   12       1.0 55 50 1 3   0 1     0   0   27 28 0   1 0 12     1 55
2933438 WA Asotin   school 5301320 2250   Clarkston School District 530132002433 4384 Heights Elementary   Regular School No Elementary KG 06 2021   grade_3 34 0 3   1 0     0   2   18 22 0   0   1   14       1.0 40 34 0 3   1 0     0   2   18 22 0   0 1 14     1 40
2933439 WA Asotin   school 5301320 2250   Clarkston School District 530132002433 4384 Heights Elementary   Regular School No Elementary KG 06 2021   grade_4 35 1 0   1 1     0   1   21 18 0   0   0   8       1.0 39 35 1 0   1 1     0   1   21 18 0   0 0 8     1 39
2933440 WA Asotin   school 5301320 2250   Clarkston School District 530132002433 4384 Heights Elementary   Regular School No Elementary KG 06 2021   grade_5 40 0 2   0 0     0   3   20 25 0   0   0   13       1.0 45 40 0 2   0 0     0   3   20 25 0   0 0 13     1 45
2933441 WA Asotin   school 5301320 2250   Clarkston School District 530132002433 4384 Heights Elementary   Regular School No Elementary KG 06 2021   grade_6 59 0 6   1 0     0   5   35 36 0   0   1   35       4.0 71 59 0 6   1 0     0   5   35 36 0   0 1 35     4 71
2933442 WA Asotin   school 5301320 2250   Clarkston School District 530132002433 4384 Heights Elementary   Regular School No Elementary KG 06 2021   pk_12_total 293 3 21   3 2     0   16   162 176 0   1   3   112       9.0 338 293 3 21   3 2     0   16   162 176 0   1 3 112     9 338
2933443 WA Asotin   school 5301320 2250   Clarkston School District 530132002433 4384 Heights Elementary   Regular School No Elementary KG 06 2021   kindergarten 40 1 4   0 0     0   2   20 27 0   0   1   16       0.0 47 40 1 4   0 0     0   2   20 27 0   0 1 16     0 47
2933444 WA Asotin   school 5301320 2250   Clarkston School District 530132000236 3266 Highland Elementary   Regular School No Elementary KG 06 2021   grade_1 51 0 3   4 0     0   6   32 32 0   1   1   35       1.0 64 51 0 3   4 0     0   6   32 32 0   1 1 35     1 64
2933445 WA Asotin   school 5301320 2250   Clarkston School District 530132000236 3266 Highland Elementary   Regular School No Elementary KG 06 2021   grade_2 17 0 1   0 0     0   4   10 12 0   0   3   17       0.0 22 17 0 1   0 0     0   4   10 12 0   0 3 17     0 22
2933446 WA Asotin   school 5301320 2250   Clarkston School District 530132000236 3266 Highland Elementary   Regular School No Elementary KG 06 2021   grade_3 31 0 3   1 0     0   1   15 21 0   2   6   28       1.0 36 31 0 3   1 0     0   1   15 21 0   2 6 28     1 36
2933447 WA Asotin   school 5301320 2250   Clarkston School District 530132000236 3266 Highland Elementary   Regular School No Elementary KG 06 2021   grade_4 52 1 8   1 1     0   5   30 38 0   2   8   49       2.0 68 52 1 8   1 1     0   5   30 38 0   2 8 49     2 68
2933448 WA Asotin   school 5301320 2250   Clarkston School District 530132000236 3266 Highland Elementary   Regular School No Elementary KG 06 2021   grade_5 16 0 6   0 1     0   4   10 17 0   2   1   20       1.0 27 16 0 6   0 1     0   4   10 17 0   2 1 20     1 27
2933449 WA Asotin   school 5301320 2250   Clarkston School District 530132000236 3266 Highland Elementary   Regular School No Elementary KG 06 2021   grade_6 26 1 3   0 0     0   1   15 16 0   0   1   22       2.0 31 26 1 3   0 0     0   1   15 16 0   0 1 22     2 31
2933450 WA Asotin   school 5301320 2250   Clarkston School District 530132000236 3266 Highland Elementary   Regular School No Elementary KG 06 2021   pk_12_total 219 2 28   6 2     1   25   128 155 0   10   21   190       7.0 283 219 2 28   6 2     1   25   128 155 0   10 21 190     7 283
2933451 WA Asotin   school 5301320 2250   Clarkston School District 530132000236 3266 Highland Elementary   Regular School No Elementary KG 06 2021   kindergarten 26 0 4   0 0     1   4   16 19 0   3   1   19       0.0 35 26 0 4   0 0     1   4   16 19 0   3 1 19     0 35
2933452 WA Asotin   school 5301320 2250   Clarkston School District 530132000237 2501 Lincoln Middle School   Regular School No Middle 07 08 2021   grade_7 140 3 19   3 1     0   14   87 93 0   0   9   114       9.0 180 140 3 19   3 1     0   14   87 93 0   0 9 114     9 180
2933453 WA Asotin   school 5301320 2250   Clarkston School District 530132000237 2501 Lincoln Middle School   Regular School No Middle 07 08 2021   grade_8 169 2 16   8 2     0   8   106 99 0   3   4   116       16.0 205 169 2 16   8 2     0   8   106 99 0   3 4 116     16 205
2933454 WA Asotin   school 5301320 2250   Clarkston School District 530132000237 2501 Lincoln Middle School   Regular School No Middle 07 08 2021   pk_12_total 309 5 35   11 3     0   22   193 192 0   3   13   230       25.0 385 309 5 35   11 3     0   22   193 192 0   3 13 230     25 385
2933455 WA Asotin   school 5301320 2250   Clarkston School District 530132000238 2823 Parkway Elementary   Regular School No Elementary KG 06 2021   grade_1 24 0 4   0 0     0   4   16 16 0   0   0   21       1.0 32 24 0 4   0 0     0   4   16 16 0   0 0 21     1 32
2933456 WA Asotin   school 5301320 2250   Clarkston School District 530132000238 2823 Parkway Elementary   Regular School No Elementary KG 06 2021   grade_2 59 1 6   0 0     0   5   41 30 0   0   5   46       1.0 71 59 1 6   0 0     0   5   41 30 0   0 5 46     1 71
2933457 WA Asotin   school 5301320 2250   Clarkston School District 530132000238 2823 Parkway Elementary   Regular School No Elementary KG 06 2021   grade_3 48 0 7   1 1     0   7   34 29 1   0   2   39       3.0 64 48 0 7   1 1     0   7   34 29 1   0 2 39     3 64
2933458 WA Asotin   school 5301320 2250   Clarkston School District 530132000238 2823 Parkway Elementary   Regular School No Elementary KG 06 2021   grade_4 25 0 1   1 0     0   3   12 18 0   0   0   15       0.0 30 25 0 1   1 0     0   3   12 18 0   0 0 15     0 30
2933459 WA Asotin   school 5301320 2250   Clarkston School District 530132000238 2823 Parkway Elementary   Regular School No Elementary KG 06 2021   grade_5 25 0 3   2 0     0   1   11 20 0   0   1   20       0.0 31 25 0 3   2 0     0   1   11 20 0   0 1 20     0 31
2933460 WA Asotin   school 5301320 2250   Clarkston School District 530132000238 2823 Parkway Elementary   Regular School No Elementary KG 06 2021   grade_6 29 1 2   1 0     0   2   19 16 0   0   2   21       1.0 35 29 1 2   1 0     0   2   19 16 0   0 2 21     1 35
2933461 WA Asotin   school 5301320 2250   Clarkston School District 530132000238 2823 Parkway Elementary   Regular School No Elementary KG 06 2021   pk_12_total 236 2 28   5 1     0   24   152 143 1   0   11   181       6.0 296 236 2 28   5 1     0   24   152 143 1   0 11 181     6 296
2933462 WA Asotin   school 5301320 2250   Clarkston School District 530132000238 2823 Parkway Elementary   Regular School No Elementary KG 06 2021   kindergarten 26 0 5   0 0     0   2   19 14 0   0   1   19       0.0 33 26 0 5   0 0     0   2   19 14 0   0 1 19     0 33
2933463 WA Asotin   school 5301320 2250   Clarkston School District 530132002613 3616 Special Services   Special Education School No Other PK 12 2021   grade_12 1 0 1   0 0     0   0   1 1 0   0   0   2       0.0 2 1 0 1   0 0     0   0   1 1 0   0 0 2     0 2
2933464 WA Asotin   school 5301320 2250   Clarkston School District 530132002613 3616 Special Services   Special Education School No Other PK 12 2021   grade_1 3 0 0   0 0     0   1   1 3 0   0   0   1       0.0 4 3 0 0   0 0     0   1   1 3 0   0 0 1     0 4
2933465 WA Asotin   school 5301320 2250   Clarkston School District 530132002613 3616 Special Services   Special Education School No Other PK 12 2021   grade_2 3 0 0   1 0     0   0   1 3 0   0   0   1       0.0 4 3 0 0   1 0     0   0   1 3 0   0 0 1     0 4
2933466 WA Asotin   school 5301320 2250   Clarkston School District 530132002613 3616 Special Services   Special Education School No Other PK 12 2021   grade_5 2 0 0   0 0     0   1   2 1 0   0   0   1       0.0 3 2 0 0   0 0     0   1   2 1 0   0 0 1     0 3
2933467 WA Asotin   school 5301320 2250   Clarkston School District 530132002613 3616 Special Services   Special Education School No Other PK 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
2933468 WA Asotin   school 5301320 2250   Clarkston School District 530132002613 3616 Special Services   Special Education School No Other PK 12 2021   grade_9 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
2933469 WA Asotin   school 5301320 2250   Clarkston School District 530132002613 3616 Special Services   Special Education School No Other PK 12 2021   pk_12_total 49 0 2   1 0     0   6   31 27 0   0   0   27       0.0 58 49 0 2   1 0     0   6   31 27 0   0 0 27     0 58
2933470 WA Asotin   school 5301320 2250   Clarkston School District 530132002613 3616 Special Services   Special Education School No Other PK 12 2021   kindergarten 7 0 0   0 0     0   0   4 3 0   0   0   0       0.0 7 7 0 0   0 0     0   0   4 3 0   0 0 0     0 7
2933471 WA Asotin   school 5301320 2250   Clarkston School District 530132002613 3616 Special Services   Special Education School No Other PK 12 2021   pre_kindergarten 31 0 1   0 0     0   4   20 16 0   0   0   20       0.0 36 31 0 1   0 0     0   4   20 16 0   0 0 20     0 36
2935689 WA Benton   school 5302910 3053   Finley School District 530291000468 3078 Finley Elementary   Regular School No Elementary PK 05 2021   grade_1 26 0 35   0 0     0   4   31 34 0   28   0   56       1.0 65 26 0 35   0 0     0   4   31 34 0   28 0 56     1 65
2935690 WA Benton   school 5302910 3053   Finley School District 530291000468 3078 Finley Elementary   Regular School No Elementary PK 05 2021   grade_2 26 0 28   0 0     0   3   36 21 0   18   1   48       0.0 57 26 0 28   0 0     0   3   36 21 0   18 1 48     0 57
2935691 WA Benton   school 5302910 3053   Finley School District 530291000468 3078 Finley Elementary   Regular School No Elementary PK 05 2021   grade_3 30 0 27   0 0     0   5   30 32 0   13   1   50       0.0 62 30 0 27   0 0     0   5   30 32 0   13 1 50     0 62
2935692 WA Benton   school 5302910 3053   Finley School District 530291000468 3078 Finley Elementary   Regular School No Elementary PK 05 2021   grade_4 23 0 33   0 0     0   1   26 31 0   14   1   43       0.0 57 23 0 33   0 0     0   1   26 31 0   14 1 43     0 57
2935693 WA Benton   school 5302910 3053   Finley School District 530291000468 3078 Finley Elementary   Regular School No Elementary PK 05 2021   grade_5 36 0 30   0 1     0   4   37 34 0   15   0   56       1.0 71 36 0 30   0 1     0   4   37 34 0   15 0 56     1 71
2935694 WA Benton   school 5302910 3053   Finley School District 530291000468 3078 Finley Elementary   Regular School No Elementary PK 05 2021   pk_12_total 162 0 191   0 1     0   20   197 177 0   115   4   310       2.0 374 162 0 191   0 1     0   20   197 177 0   115 4 310     2 374
2935695 WA Benton   school 5302910 3053   Finley School District 530291000468 3078 Finley Elementary   Regular School No Elementary PK 05 2021   kindergarten 16 0 34   0 0     0   3   30 23 0   27   1   48       0.0 53 16 0 34   0 0     0   3   30 23 0   27 1 48     0 53
2935696 WA Benton   school 5302910 3053   Finley School District 530291000468 3078 Finley Elementary   Regular School No Elementary PK 05 2021   pre_kindergarten 5 0 4   0 0     0   0   7 2 0   0   0   9       0.0 9 5 0 4   0 0     0   0   7 2 0   0 0 9     0 9
2935697 WA Benton   school 5302910 3053   Finley School District 530291002100 4031 Finley Middle School   Regular School No Middle 06 08 2021   grade_6 31 1 34   0 0     0   0   36 30 0   12   1   55       2.0 66 31 1 34   0 0     0   0   36 30 0   12 1 55     2 66
2935698 WA Benton   school 5302910 3053   Finley School District 530291002100 4031 Finley Middle School   Regular School No Middle 06 08 2021   grade_7 34 0 43   0 0     0   3   42 38 0   8   1   74       3.0 80 34 0 43   0 0     0   3   42 38 0   8 1 74     3 80
2935699 WA Benton   school 5302910 3053   Finley School District 530291002100 4031 Finley Middle School   Regular School No Middle 06 08 2021   grade_8 32 0 25   0 0     0   2   24 35 0   7   1   48       2.0 59 32 0 25   0 0     0   2   24 35 0   7 1 48     2 59
2935700 WA Benton   school 5302910 3053   Finley School District 530291002100 4031 Finley Middle School   Regular School No Middle 06 08 2021   pk_12_total 97 1 102   0 0     0   5   102 103 0   27   3   177       7.0 205 97 1 102   0 0     0   5   102 103 0   27 3 177     7 205
2935701 WA Benton   school 5302910 3053   Finley School District 530291000469 2367 River View High School   Regular School No High 09 12 2021   grade_10 36 1 41   0 0     0   2   46 34 0   16   1   58       0.0 80 36 1 41   0 0     0   2   46 34 0   16 1 58     0 80
2935702 WA Benton   school 5302910 3053   Finley School District 530291000469 2367 River View High School   Regular School No High 09 12 2021   grade_11 35 0 28   1 0     0   1   35 30 0   11   1   52       2.0 65 35 0 28   1 0     0   1   35 30 0   11 1 52     2 65
2935703 WA Benton   school 5302910 3053   Finley School District 530291000469 2367 River View High School   Regular School No High 09 12 2021   grade_12 43 0 42   0 1     0   0   46 40 0   11   2   62       5.0 86 43 0 42   0 1     0   0   46 40 0   11 2 62     5 86
2935704 WA Benton   school 5302910 3053   Finley School District 530291000469 2367 River View High School   Regular School No High 09 12 2021   grade_9 32 0 38   0 0     0   1   37 34 0   9   0   56       3.0 71 32 0 38   0 0     0   1   37 34 0   9 0 56     3 71

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