Data source: Big Local News · About: Big Local

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

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
632698 WA Yakima   school 5310110 39007   Yakima School District 531011003487 5355 Yakima Open Doors   Alternative School No High 09 12 2017   grade_11 2 0 7   0 0     0   1   5 5 0   3   0   8       1.0 10 2 0 7   0 0     0   1   5 5 0   3 0 8     1 10
632697 WA Yakima   school 5310110 39007   Yakima School District 531011003487 5355 Yakima Open Doors   Alternative School No High 09 12 2017   grade_10 1 0 2   0 0     0   0   2 1 0   1   1   3       0.0 3 1 0 2   0 0     0   0   2 1 0   1 1 3     0 3
632696 WA Yakima   school 5310110 39007   Yakima School District 531011003263 5153 Yakima Online   Alternative School No Other 06 12 2017   pk_12_total 41 1 42   1 0     0   4   37 52 0   3   3   57       7.0 89 41 1 42   1 0     0   4   37 52 0   3 3 57     7 89
632695 WA Yakima   school 5310110 39007   Yakima School District 531011003263 5153 Yakima Online   Alternative School No Other 06 12 2017   grade_9 6 0 2   0 0     0   0   4 4 0   0   1   7       1.0 8 6 0 2   0 0     0   0   4 4 0   0 1 7     1 8
632694 WA Yakima   school 5310110 39007   Yakima School District 531011003263 5153 Yakima Online   Alternative School No Other 06 12 2017   grade_8 1 0 2   0 0     0   1   1 3 0   0   0   3       1.0 4 1 0 2   0 0     0   1   1 3 0   0 0 3     1 4
632693 WA Yakima   school 5310110 39007   Yakima School District 531011003263 5153 Yakima Online   Alternative School No Other 06 12 2017   grade_7 1 0 1   0 0     0   0   1 1 0   0   0   1       0.0 2 1 0 1   0 0     0   0   1 1 0   0 0 1     0 2
632692 WA Yakima   school 5310110 39007   Yakima School District 531011003263 5153 Yakima Online   Alternative School No Other 06 12 2017   grade_12 20 0 15   0 0     0   1   16 20 0   1   1   24       4.0 36 20 0 15   0 0     0   1   16 20 0   1 1 24     4 36
632691 WA Yakima   school 5310110 39007   Yakima School District 531011003263 5153 Yakima Online   Alternative School No Other 06 12 2017   grade_11 10 1 17   1 0     0   1   10 20 0   2   0   17       1.0 30 10 1 17   1 0     0   1   10 20 0   2 0 17     1 30
632690 WA Yakima   school 5310110 39007   Yakima School District 531011003263 5153 Yakima Online   Alternative School No Other 06 12 2017   grade_10 3 0 5   0 0     0   1   5 4 0   0   1   5       0.0 9 3 0 5   0 0     0   1   5 4 0   0 1 5     0 9
632689 WA Yakima   school 5310110 39007   Yakima School District 531011001710 3368 Wilson Middle School   Regular School No Middle 06 08 2017   pk_12_total 219 7 581   12 7     0   26   417 435 0   157   22   616       26.0 852 219 7 581   12 7     0   26   417 435 0   157 22 616     26 852
632688 WA Yakima   school 5310110 39007   Yakima School District 531011001710 3368 Wilson Middle School   Regular School No Middle 06 08 2017   grade_8 67 5 204   1 4     0   7   143 145 0   43   9   205       6.0 288 67 5 204   1 4     0   7   143 145 0   43 9 205     6 288
632687 WA Yakima   school 5310110 39007   Yakima School District 531011001710 3368 Wilson Middle School   Regular School No Middle 06 08 2017   grade_7 70 2 204   6 2     0   13   144 153 0   56   3   213       8.0 297 70 2 204   6 2     0   13   144 153 0   56 3 213     8 297
632686 WA Yakima   school 5310110 39007   Yakima School District 531011001710 3368 Wilson Middle School   Regular School No Middle 06 08 2017   grade_6 82 0 173   5 1     0   6   130 137 0   58   10   198       12.0 267 82 0 173   5 1     0   6   130 137 0   58 10 198     12 267
632685 WA Yakima   school 5310110 39007   Yakima School District 531011001709 3312 Whitney Elementary   Regular School No Elementary PK 05 2017   pre_kindergarten 1 0 2   0 0     0   0   2 1 0   0   1   3       0.0 3 1 0 2   0 0     0   0   2 1 0   0 1 3     0 3
632684 WA Yakima   school 5310110 39007   Yakima School District 531011001709 3312 Whitney Elementary   Regular School No Elementary PK 05 2017   kindergarten 19 0 52   0 1     0   6   48 30 0   17   0   45       1.0 78 19 0 52   0 1     0   6   48 30 0   17 0 45     1 78
632683 WA Yakima   school 5310110 39007   Yakima School District 531011001709 3312 Whitney Elementary   Regular School No Elementary PK 05 2017   pk_12_total 152 8 362   0 6     2   19   276 273 0   130   12   388       4.0 549 152 8 362   0 6     2   19   276 273 0   130 12 388     4 549
632682 WA Yakima   school 5310110 39007   Yakima School District 531011001709 3312 Whitney Elementary   Regular School No Elementary PK 05 2017   grade_5 22 3 57   0 0     0   3   45 40 0   12   1   62       1.0 85 22 3 57   0 0     0   3   45 40 0   12 1 62     1 85
632681 WA Yakima   school 5310110 39007   Yakima School District 531011001709 3312 Whitney Elementary   Regular School No Elementary PK 05 2017   grade_4 25 2 74   0 2     1   1   57 48 0   28   4   77       0.0 105 25 2 74   0 2     1   1   57 48 0   28 4 77     0 105
632680 WA Yakima   school 5310110 39007   Yakima School District 531011001709 3312 Whitney Elementary   Regular School No Elementary PK 05 2017   grade_3 32 2 64   0 2     0   4   50 54 0   26   3   74       1.0 104 32 2 64   0 2     0   4   50 54 0   26 3 74     1 104
632679 WA Yakima   school 5310110 39007   Yakima School District 531011001709 3312 Whitney Elementary   Regular School No Elementary PK 05 2017   grade_2 29 1 61   0 1     1   2   34 61 0   28   2   73       0.0 95 29 1 61   0 1     1   2   34 61 0   28 2 73     0 95
632678 WA Yakima   school 5310110 39007   Yakima School District 531011001709 3312 Whitney Elementary   Regular School No Elementary PK 05 2017   grade_1 24 0 52   0 0     0   3   40 39 0   19   1   54       1.0 79 24 0 52   0 0     0   3   40 39 0   19 1 54     1 79
632677 WA Yakima   school 5310110 39007   Yakima School District 531011001708 2314 Washington Middle School   Regular School No Middle 06 08 2017   pk_12_total 33 6 722   6 1     0   3   391 380 0   369   36   708       23.0 771 33 6 722   6 1     0   3   391 380 0   369 36 708     23 771
632676 WA Yakima   school 5310110 39007   Yakima School District 531011001708 2314 Washington Middle School   Regular School No Middle 06 08 2017   grade_8 14 1 237   0 1     0   1   136 118 0   110   8   229       6.0 254 14 1 237   0 1     0   1   136 118 0   110 8 229     6 254
632675 WA Yakima   school 5310110 39007   Yakima School District 531011001708 2314 Washington Middle School   Regular School No Middle 06 08 2017   grade_7 7 2 229   4 0     0   1   120 123 0   123   8   219       8.0 243 7 2 229   4 0     0   1   120 123 0   123 8 219     8 243
632674 WA Yakima   school 5310110 39007   Yakima School District 531011001708 2314 Washington Middle School   Regular School No Middle 06 08 2017   grade_6 12 3 256   2 0     0   1   135 139 0   136   20   260       9.0 274 12 3 256   2 0     0   1   135 139 0   136 20 260     9 274
632673 WA Yakima   school 5310110 39007   Yakima School District 531011001713 4093 Stanton Academy   Alternative School No High 09 12 2017   pre_kindergarten 3 0 15   0 0     0   0   11 7 0   0   0   14       0.0 18 3 0 15   0 0     0   0   11 7 0   0 0 14     0 18
632672 WA Yakima   school 5310110 39007   Yakima School District 531011001713 4093 Stanton Academy   Alternative School No High 09 12 2017   pk_12_total 63 6 247   8 0     1   10   191 144 0   75   36   302       19.0 335 63 6 247   8 0     1   10   191 144 0   75 36 302     19 335
632671 WA Yakima   school 5310110 39007   Yakima School District 531011001713 4093 Stanton Academy   Alternative School No High 09 12 2017   grade_9 9 0 39   0 0     0   2   39 11 0   10   5   45       5.0 50 9 0 39   0 0     0   2   39 11 0   10 5 45     5 50
632670 WA Yakima   school 5310110 39007   Yakima School District 531011001713 4093 Stanton Academy   Alternative School No High 09 12 2017   grade_12 25 4 100   4 0     0   3   69 67 0   29   18   126       5.0 136 25 4 100   4 0     0   3   69 67 0   29 18 126     5 136
632669 WA Yakima   school 5310110 39007   Yakima School District 531011001713 4093 Stanton Academy   Alternative School No High 09 12 2017   grade_11 11 2 51   2 0     1   1   38 30 0   17   9   61       4.0 68 11 2 51   2 0     1   1   38 30 0   17 9 61     4 68
632668 WA Yakima   school 5310110 39007   Yakima School District 531011001713 4093 Stanton Academy   Alternative School No High 09 12 2017   grade_10 15 0 42   2 0     0   4   34 29 0   19   4   56       5.0 63 15 0 42   2 0     0   4   34 29 0   19 4 56     5 63
632667 WA Yakima   school 5310110 39007   Yakima School District 531011001704 2529 Roosevelt Elementary School   Regular School No Elementary KG 05 2017   kindergarten 12 4 72   0 1     0   3   53 39 0   46   2   75       1.0 92 12 4 72   0 1     0   3   53 39 0   46 2 75     1 92
632666 WA Yakima   school 5310110 39007   Yakima School District 531011001704 2529 Roosevelt Elementary School   Regular School No Elementary KG 05 2017   pk_12_total 91 11 421   4 5     0   18   281 269 0   220   20   474       9.0 550 91 11 421   4 5     0   18   281 269 0   220 20 474     9 550
632665 WA Yakima   school 5310110 39007   Yakima School District 531011001704 2529 Roosevelt Elementary School   Regular School No Elementary KG 05 2017   grade_5 20 2 67   2 2     0   0   48 45 0   29   2   83       1.0 93 20 2 67   2 2     0   0   48 45 0   29 2 83     1 93
632664 WA Yakima   school 5310110 39007   Yakima School District 531011001704 2529 Roosevelt Elementary School   Regular School No Elementary KG 05 2017   grade_4 12 1 71   1 1     0   6   47 45 0   30   3   77       3.0 92 12 1 71   1 1     0   6   47 45 0   30 3 77     3 92
632663 WA Yakima   school 5310110 39007   Yakima School District 531011001704 2529 Roosevelt Elementary School   Regular School No Elementary KG 05 2017   grade_3 14 3 71   0 0     0   1   46 43 0   36   5   77       2.0 89 14 3 71   0 0     0   1   46 43 0   36 5 77     2 89
632662 WA Yakima   school 5310110 39007   Yakima School District 531011001704 2529 Roosevelt Elementary School   Regular School No Elementary KG 05 2017   grade_2 15 0 64   1 1     0   5   46 40 0   35   3   72       1.0 86 15 0 64   1 1     0   5   46 40 0   35 3 72     1 86
632661 WA Yakima   school 5310110 39007   Yakima School District 531011001704 2529 Roosevelt Elementary School   Regular School No Elementary KG 05 2017   grade_1 18 1 76   0 0     0   3   41 57 0   44   5   90       1.0 98 18 1 76   0 0     0   3   41 57 0   44 5 90     1 98
632660 WA Yakima   school 5310110 39007   Yakima School District 531011001703 3264 Robertson Elementary   Regular School No Elementary KG 05 2017   kindergarten 24 1 60   1 1     0   5   49 43 0   34   14   74       1.0 92 24 1 60   1 1     0   5   49 43 0   34 14 74     1 92
632659 WA Yakima   school 5310110 39007   Yakima School District 531011001703 3264 Robertson Elementary   Regular School No Elementary KG 05 2017   kindergarten_half_day 0 0 1   0 0     0   0   1 0 0   1   0   1       0.0 1 0 0 1   0 0     0   0   1 0 0   1 0 1     0 1
632658 WA Yakima   school 5310110 39007   Yakima School District 531011001703 3264 Robertson Elementary   Regular School No Elementary KG 05 2017   pk_12_total 120 3 368   10 1     0   12   247 267 0   172   55   440       21.0 514 120 3 368   10 1     0   12   247 267 0   172 55 440     21 514
632657 WA Yakima   school 5310110 39007   Yakima School District 531011001703 3264 Robertson Elementary   Regular School No Elementary KG 05 2017   grade_5 26 0 61   2 0     0   4   52 41 0   26   11   86       9.0 93 26 0 61   2 0     0   4   52 41 0   26 11 86     9 93
632656 WA Yakima   school 5310110 39007   Yakima School District 531011001703 3264 Robertson Elementary   Regular School No Elementary KG 05 2017   grade_4 16 0 63   1 0     0   1   35 46 0   29   8   73       2.0 81 16 0 63   1 0     0   1   35 46 0   29 8 73     2 81
632655 WA Yakima   school 5310110 39007   Yakima School District 531011001703 3264 Robertson Elementary   Regular School No Elementary KG 05 2017   grade_3 24 1 53   4 0     0   0   39 43 0   20   10   66       3.0 82 24 1 53   4 0     0   0   39 43 0   20 10 66     3 82
632654 WA Yakima   school 5310110 39007   Yakima School District 531011001703 3264 Robertson Elementary   Regular School No Elementary KG 05 2017   grade_2 16 1 66   1 0     0   1   36 49 0   32   6   69       4.0 85 16 1 66   1 0     0   1   36 49 0   32 6 69     4 85
632653 WA Yakima   school 5310110 39007   Yakima School District 531011001703 3264 Robertson Elementary   Regular School No Elementary KG 05 2017   grade_1 14 0 64   1 0     0   1   35 45 0   30   6   71       2.0 80 14 0 64   1 0     0   1   35 45 0   30 6 71     2 80
632652 WA Yakima   school 5310110 39007   Yakima School District 531011003420 5264 Ridgeview Group Home   Regular School No High 07 12 2017   pk_12_total 2 0 3   0 0     1   0   0 6 0   0   0   6       0.0 6 2 0 3   0 0     1   0   0 6 0   0 0 6     0 6
632651 WA Yakima   school 5310110 39007   Yakima School District 531011003420 5264 Ridgeview Group Home   Regular School No High 07 12 2017   grade_9 1 0 1   0 0     0   0   0 2 0   0   0   2       0.0 2 1 0 1   0 0     0   0   0 2 0   0 0 2     0 2
632650 WA Yakima   school 5310110 39007   Yakima School District 531011003420 5264 Ridgeview Group Home   Regular School No High 07 12 2017   grade_12 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
632649 WA Yakima   school 5310110 39007   Yakima School District 531011003420 5264 Ridgeview Group Home   Regular School No High 07 12 2017   grade_11 0 0 2   0 0     1   0   0 3 0   0   0   3       0.0 3 0 0 2   0 0     1   0   0 3 0   0 0 3     0 3
632648 WA Yakima   school 5310110 39007   Yakima School District 531011001687 2433 Ridgeview Elementary   Regular School No Elementary KG 05 2017   kindergarten 11 1 95   0 0     0   3   60 50 0   65   1   87       2.0 110 11 1 95   0 0     0   3   60 50 0   65 1 87     2 110
632647 WA Yakima   school 5310110 39007   Yakima School District 531011001687 2433 Ridgeview Elementary   Regular School No Elementary KG 05 2017   kindergarten_half_day 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
632646 WA Yakima   school 5310110 39007   Yakima School District 531011001687 2433 Ridgeview Elementary   Regular School No Elementary KG 05 2017   pk_12_total 97 6 525   3 1     0   11   323 320 0   318   26   560       10.0 643 97 6 525   3 1     0   11   323 320 0   318 26 560     10 643
632645 WA Yakima   school 5310110 39007   Yakima School District 531011001687 2433 Ridgeview Elementary   Regular School No Elementary KG 05 2017   grade_5 8 1 82   0 0     0   1   46 46 0   32   5   79       3.0 92 8 1 82   0 0     0   1   46 46 0   32 5 79     3 92
632644 WA Yakima   school 5310110 39007   Yakima School District 531011001687 2433 Ridgeview Elementary   Regular School No Elementary KG 05 2017   grade_4 22 0 76   0 0     0   2   55 45 0   43   3   88       3.0 100 22 0 76   0 0     0   2   55 45 0   43 3 88     3 100
632643 WA Yakima   school 5310110 39007   Yakima School District 531011001687 2433 Ridgeview Elementary   Regular School No Elementary KG 05 2017   grade_3 18 0 89   1 0     0   2   50 60 0   61   3   100       0.0 110 18 0 89   1 0     0   2   50 60 0   61 3 100     0 110
632642 WA Yakima   school 5310110 39007   Yakima School District 531011001687 2433 Ridgeview Elementary   Regular School No Elementary KG 05 2017   grade_2 22 3 87   2 0     0   0   53 61 0   52   9   99       1.0 114 22 3 87   2 0     0   0   53 61 0   52 9 99     1 114
632641 WA Yakima   school 5310110 39007   Yakima School District 531011001687 2433 Ridgeview Elementary   Regular School No Elementary KG 05 2017   grade_1 15 1 96   0 1     0   3   58 58 0   65   5   106       1.0 116 15 1 96   0 1     0   3   58 58 0   65 5 106     1 116
632640 WA Yakima   school 5310110 39007   Yakima School District 531011001701 2819 Nob Hill Elementary School   Regular School No Elementary KG 05 2017   kindergarten 38 1 51   0 0     0   0   42 48 0   14   8   56       3.0 90 38 1 51   0 0     0   0   42 48 0   14 8 56     3 90
632639 WA Yakima   school 5310110 39007   Yakima School District 531011001701 2819 Nob Hill Elementary School   Regular School No Elementary KG 05 2017   pk_12_total 208 2 267   3 0     0   16   258 238 0   92   28   298       25.0 496 208 2 267   3 0     0   16   258 238 0   92 28 298     25 496
632638 WA Yakima   school 5310110 39007   Yakima School District 531011001701 2819 Nob Hill Elementary School   Regular School No Elementary KG 05 2017   grade_5 31 0 49   0 0     0   3   41 42 0   15   1   43       5.0 83 31 0 49   0 0     0   3   41 42 0   15 1 43     5 83
632637 WA Yakima   school 5310110 39007   Yakima School District 531011001701 2819 Nob Hill Elementary School   Regular School No Elementary KG 05 2017   grade_4 40 0 38   0 0     0   2   44 36 0   13   6   49       5.0 80 40 0 38   0 0     0   2   44 36 0   13 6 49     5 80
632636 WA Yakima   school 5310110 39007   Yakima School District 531011001701 2819 Nob Hill Elementary School   Regular School No Elementary KG 05 2017   grade_3 26 1 43   1 0     0   7   48 30 0   16   4   49       7.0 78 26 1 43   1 0     0   7   48 30 0   16 4 49     7 78
632635 WA Yakima   school 5310110 39007   Yakima School District 531011001701 2819 Nob Hill Elementary School   Regular School No Elementary KG 05 2017   grade_2 36 0 41   1 0     0   3   36 45 0   15   3   47       2.0 81 36 0 41   1 0     0   3   36 45 0   15 3 47     2 81
632634 WA Yakima   school 5310110 39007   Yakima School District 531011001701 2819 Nob Hill Elementary School   Regular School No Elementary KG 05 2017   grade_1 37 0 45   1 0     0   1   47 37 0   19   6   54       3.0 84 37 0 45   1 0     0   1   47 37 0   19 6 54     3 84
632633 WA Yakima   school 5310110 39007   Yakima School District 531011001700 2177 Mckinley Elementary School   Regular School No Elementary KG 05 2017   kindergarten 13 1 50   0 0     0   1   35 30 0   33   0   54       2.0 65 13 1 50   0 0     0   1   35 30 0   33 0 54     2 65
632632 WA Yakima   school 5310110 39007   Yakima School District 531011001700 2177 Mckinley Elementary School   Regular School No Elementary KG 05 2017   pk_12_total 70 3 360   3 0     0   14   223 227 0   216   19   410       18.0 450 70 3 360   3 0     0   14   223 227 0   216 19 410     18 450
632631 WA Yakima   school 5310110 39007   Yakima School District 531011001700 2177 Mckinley Elementary School   Regular School No Elementary KG 05 2017   grade_5 11 0 65   2 0     0   1   32 47 0   29   2   71       5.0 79 11 0 65   2 0     0   1   32 47 0   29 2 71     5 79
632630 WA Yakima   school 5310110 39007   Yakima School District 531011001700 2177 Mckinley Elementary School   Regular School No Elementary KG 05 2017   grade_4 14 1 61   1 0     0   4   42 39 0   38   3   77       2.0 81 14 1 61   1 0     0   4   42 39 0   38 3 77     2 81
632629 WA Yakima   school 5310110 39007   Yakima School District 531011001700 2177 Mckinley Elementary School   Regular School No Elementary KG 05 2017   grade_3 8 0 68   0 0     0   2   45 33 0   48   8   71       4.0 78 8 0 68   0 0     0   2   45 33 0   48 8 71     4 78
632628 WA Yakima   school 5310110 39007   Yakima School District 531011001700 2177 Mckinley Elementary School   Regular School No Elementary KG 05 2017   grade_2 15 1 59   0 0     0   5   36 44 0   35   3   74       4.0 80 15 1 59   0 0     0   5   36 44 0   35 3 74     4 80
632627 WA Yakima   school 5310110 39007   Yakima School District 531011001700 2177 Mckinley Elementary School   Regular School No Elementary KG 05 2017   grade_1 9 0 57   0 0     0   1   33 34 0   33   3   63       1.0 67 9 0 57   0 0     0   1   33 34 0   33 3 63     1 67
632626 WA Yakima   school 5310110 39007   Yakima School District 531011001699 2899 Mcclure Elementary School   Regular School No Elementary PK 05 2017   pre_kindergarten 14 1 17   0 0     0   0   21 11 0   0   1   25       0.0 32 14 1 17   0 0     0   0   21 11 0   0 1 25     0 32
632625 WA Yakima   school 5310110 39007   Yakima School District 531011001699 2899 Mcclure Elementary School   Regular School No Elementary PK 05 2017   kindergarten 14 1 76   0 2     0   4   45 52 0   36   3   62       2.0 97 14 1 76   0 2     0   4   45 52 0   36 3 62     2 97
632624 WA Yakima   school 5310110 39007   Yakima School District 531011001699 2899 Mcclure Elementary School   Regular School No Elementary PK 05 2017   pk_12_total 135 6 446   2 2     0   18   318 291 0   220   20   470       25.0 609 135 6 446   2 2     0   18   318 291 0   220 20 470     25 609
632623 WA Yakima   school 5310110 39007   Yakima School District 531011001699 2899 Mcclure Elementary School   Regular School No Elementary PK 05 2017   grade_5 21 1 66   0 0     0   3   56 35 0   31   3   64       3.0 91 21 1 66   0 0     0   3   56 35 0   31 3 64     3 91
632622 WA Yakima   school 5310110 39007   Yakima School District 531011001699 2899 Mcclure Elementary School   Regular School No Elementary PK 05 2017   grade_4 25 1 64   0 0     0   2   51 41 0   25   3   76       7.0 92 25 1 64   0 0     0   2   51 41 0   25 3 76     7 92
632621 WA Yakima   school 5310110 39007   Yakima School District 531011001699 2899 Mcclure Elementary School   Regular School No Elementary PK 05 2017   grade_3 15 1 79   1 0     0   5   45 56 0   44   5   81       6.0 101 15 1 79   1 0     0   5   45 56 0   44 5 81     6 101
632620 WA Yakima   school 5310110 39007   Yakima School District 531011001699 2899 Mcclure Elementary School   Regular School No Elementary PK 05 2017   grade_2 25 0 66   0 0     0   1   45 47 0   37   2   74       1.0 92 25 0 66   0 0     0   1   45 47 0   37 2 74     1 92
632619 WA Yakima   school 5310110 39007   Yakima School District 531011001699 2899 Mcclure Elementary School   Regular School No Elementary PK 05 2017   grade_1 21 1 78   1 0     0   3   55 49 0   47   3   88       6.0 104 21 1 78   1 0     0   3   55 49 0   47 3 88     6 104
632618 WA Yakima   school 5310110 39007   Yakima School District 531011001814 3817 Martin Luther King Jr Elementary   Regular School No Elementary KG 05 2017   kindergarten 8 0 84   1 0     0   1   52 42 0   61   9   82       1.0 94 8 0 84   1 0     0   1   52 42 0   61 9 82     1 94
632617 WA Yakima   school 5310110 39007   Yakima School District 531011001814 3817 Martin Luther King Jr Elementary   Regular School No Elementary KG 05 2017   pk_12_total 39 3 559   4 0     0   6   322 289 0   381   30   555       7.0 611 39 3 559   4 0     0   6   322 289 0   381 30 555     7 611
632616 WA Yakima   school 5310110 39007   Yakima School District 531011001814 3817 Martin Luther King Jr Elementary   Regular School No Elementary KG 05 2017   grade_6 2 0 2   0 0     0   0   3 1 0   0   0   3       0.0 4 2 0 2   0 0     0   0   3 1 0   0 0 3     0 4
632615 WA Yakima   school 5310110 39007   Yakima School District 531011001814 3817 Martin Luther King Jr Elementary   Regular School No Elementary KG 05 2017   grade_5 6 0 83   0 0     0   3   43 49 0   52   4   82       3.0 92 6 0 83   0 0     0   3   43 49 0   52 4 82     3 92
632614 WA Yakima   school 5310110 39007   Yakima School District 531011001814 3817 Martin Luther King Jr Elementary   Regular School No Elementary KG 05 2017   grade_4 2 0 111   0 0     0   1   57 57 0   62   4   106       0.0 114 2 0 111   0 0     0   1   57 57 0   62 4 106     0 114
632613 WA Yakima   school 5310110 39007   Yakima School District 531011001814 3817 Martin Luther King Jr Elementary   Regular School No Elementary KG 05 2017   grade_3 3 2 96   1 0     0   0   50 52 0   61   4   95       1.0 102 3 2 96   1 0     0   0   50 52 0   61 4 95     1 102
632612 WA Yakima   school 5310110 39007   Yakima School District 531011001814 3817 Martin Luther King Jr Elementary   Regular School No Elementary KG 05 2017   grade_2 11 0 90   2 0     0   0   58 45 0   74   4   91       1.0 103 11 0 90   2 0     0   0   58 45 0   74 4 91     1 103
632611 WA Yakima   school 5310110 39007   Yakima School District 531011001814 3817 Martin Luther King Jr Elementary   Regular School No Elementary KG 05 2017   grade_1 7 1 93   0 0     0   1   59 43 0   71   5   96       1.0 102 7 1 93   0 0     0   1   59 43 0   71 5 96     1 102
632610 WA Yakima   school 5310110 39007   Yakima School District 531011001698 3615 Lewis & Clark Middle School   Regular School No Middle 06 08 2017   pk_12_total 91 5 707   8 3     2   15   401 430 0   285   16   718       24.0 831 91 5 707   8 3     2   15   401 430 0   285 16 718     24 831
632609 WA Yakima   school 5310110 39007   Yakima School District 531011001698 3615 Lewis & Clark Middle School   Regular School No Middle 06 08 2017   grade_8 24 4 222   3 2     0   8   129 134 0   88   4   212       12.0 263 24 4 222   3 2     0   8   129 134 0   88 4 212     12 263
632608 WA Yakima   school 5310110 39007   Yakima School District 531011001698 3615 Lewis & Clark Middle School   Regular School No Middle 06 08 2017   grade_7 39 1 242   2 0     2   4   141 149 0   99   6   250       5.0 290 39 1 242   2 0     2   4   141 149 0   99 6 250     5 290
632607 WA Yakima   school 5310110 39007   Yakima School District 531011001698 3615 Lewis & Clark Middle School   Regular School No Middle 06 08 2017   grade_6 28 0 243   3 1     0   3   131 147 0   98   6   256       7.0 278 28 0 243   3 1     0   3   131 147 0   98 6 256     7 278
632606 WA Yakima   school 5310110 39007   Yakima School District 531011002932 4092 Juvenile Detention Center   Regular School No Other 05 12 2017   pk_12_total 5 0 20   0 0     0   0   21 4 0   7   1   25       1.0 25 5 0 20   0 0     0   0   21 4 0   7 1 25     1 25
632605 WA Yakima   school 5310110 39007   Yakima School District 531011002932 4092 Juvenile Detention Center   Regular School No Other 05 12 2017   grade_9 2 0 0   0 0     0   0   2 0 0   0   0   2       0.0 2 2 0 0   0 0     0   0   2 0 0   0 0 2     0 2
632604 WA Yakima   school 5310110 39007   Yakima School District 531011002932 4092 Juvenile Detention Center   Regular School No Other 05 12 2017   grade_8 1 0 1   0 0     0   0   1 1 0   1   0   2       0.0 2 1 0 1   0 0     0   0   1 1 0   1 0 2     0 2
632603 WA Yakima   school 5310110 39007   Yakima School District 531011002932 4092 Juvenile Detention Center   Regular School No Other 05 12 2017   grade_7 0 0 1   0 0     0   0   1 0 0   1   0   1       0.0 1 0 0 1   0 0     0   0   1 0 0   1 0 1     0 1
632602 WA Yakima   school 5310110 39007   Yakima School District 531011002932 4092 Juvenile Detention Center   Regular School No Other 05 12 2017   grade_12 1 0 9   0 0     0   0   8 2 0   3   0   10       0.0 10 1 0 9   0 0     0   0   8 2 0   3 0 10     0 10
632601 WA Yakima   school 5310110 39007   Yakima School District 531011002932 4092 Juvenile Detention Center   Regular School No Other 05 12 2017   grade_11 1 0 5   0 0     0   0   5 1 0   1   1   6       0.0 6 1 0 5   0 0     0   0   5 1 0   1 1 6     0 6
632600 WA Yakima   school 5310110 39007   Yakima School District 531011002932 4092 Juvenile Detention Center   Regular School No Other 05 12 2017   grade_10 0 0 4   0 0     0   0   4 0 0   1   0   4       1.0 4 0 0 4   0 0     0   0   4 0 0   1 0 4     1 4
632599 WA Yakima   school 5310110 39007   Yakima School District 531011001694 2715 Hoover Elementary School   Regular School No Elementary PK 05 2017   pre_kindergarten 23 1 117   1 0     0   1   98 45 0   0   8   125       0.0 143 23 1 117   1 0     0   1   98 45 0   0 8 125     0 143

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