enrollments

Data source: Big Local News · About: Big Local

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

✎ View and edit SQL

This data as json, CSV (advanced)

grade ✖

year ✖

  • 2017 · 15,758 ✖
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
618010 618010 WA Adams   school 5300450 1122   Benge School District 530045000118 3142 Benge Elementary   Regular School No Elementary KG 06 2017   grade_1 2 0 0   0 0     0   0   1 1 0   0   0   0       0.0 2 2 0 0   0 0     0   0   1 1 0   0 0 0     0 2
618011 618011 WA Adams   school 5300450 1122   Benge School District 530045000118 3142 Benge Elementary   Regular School No Elementary KG 06 2017   grade_2 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
618012 618012 WA Adams   school 5300450 1122   Benge School District 530045000118 3142 Benge Elementary   Regular School No Elementary KG 06 2017   grade_3 4 0 0   0 0     0   0   2 2 0   0   0   0       0.0 4 4 0 0   0 0     0   0   2 2 0   0 0 0     0 4
618013 618013 WA Adams   school 5300450 1122   Benge School District 530045000118 3142 Benge Elementary   Regular School No Elementary KG 06 2017   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
618014 618014 WA Adams   school 5300450 1122   Benge School District 530045000118 3142 Benge Elementary   Regular School No Elementary KG 06 2017   grade_5 2 0 0   0 0     0   0   2 0 0   0   0   0       0.0 2 2 0 0   0 0     0   0   2 0 0   0 0 0     0 2
618015 618015 WA Adams   school 5300450 1122   Benge School District 530045000118 3142 Benge Elementary   Regular School No Elementary KG 06 2017   grade_6 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
618016 618016 WA Adams   school 5300450 1122   Benge School District 530045000118 3142 Benge Elementary   Regular School No Elementary KG 06 2017   pk_12_total 13 0 0   0 0     0   0   8 5 0   0   0   0       0.0 13 13 0 0   0 0     0   0   8 5 0   0 0 0     0 13
618017 618017 WA Adams   school 5300450 1122   Benge School District 530045000118 3142 Benge Elementary   Regular School No Elementary KG 06 2017   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
623739 623739 WA Adams   school 5304410 1158   Lind School District 530441000696 2903 Lind-Ritzville High School   Regular School No High 09 12 2017   grade_10 9 0 5   0 3     0   1   7 11 0   1   2   9       1.0 18 9 0 5   0 3     0   1   7 11 0   1 2 9     1 18
623740 623740 WA Adams   school 5304410 1158   Lind School District 530441000696 2903 Lind-Ritzville High School   Regular School No High 09 12 2017   grade_11 5 0 8   0 0     0   0   6 7 0   4   2   11       0.0 13 5 0 8   0 0     0   0   6 7 0   4 2 11     0 13
623741 623741 WA Adams   school 5304410 1158   Lind School District 530441000696 2903 Lind-Ritzville High School   Regular School No High 09 12 2017   grade_12 5 0 2   0 0     0   1   5 3 0   0   2   4       0.0 8 5 0 2   0 0     0   1   5 3 0   0 2 4     0 8
623742 623742 WA Adams   school 5304410 1158   Lind School District 530441000696 2903 Lind-Ritzville High School   Regular School No High 09 12 2017   grade_9 9 0 6   0 1     0   1   7 10 0   3   3   13       1.0 17 9 0 6   0 1     0   1   7 10 0   3 3 13     1 17
623743 623743 WA Adams   school 5304410 1158   Lind School District 530441000696 2903 Lind-Ritzville High School   Regular School No High 09 12 2017   pk_12_total 28 0 21   0 4     0   3   25 31 0   8   9   37       2.0 56 28 0 21   0 4     0   3   25 31 0   8 9 37     2 56
623744 623744 WA Adams   school 5304410 1158   Lind School District 530441003416 5293 Lind-Ritzville Middle School   Regular School No Middle 06 08 2017   grade_6 12 0 4   0 0     0   0   9 7 0   1   2   10       0.0 16 12 0 4   0 0     0   0   9 7 0   1 2 10     0 16
623745 623745 WA Adams   school 5304410 1158   Lind School District 530441003416 5293 Lind-Ritzville Middle School   Regular School No Middle 06 08 2017   grade_7 9 0 5   0 0     0   0   3 11 0   4   2   8       0.0 14 9 0 5   0 0     0   0   3 11 0   4 2 8     0 14
623746 623746 WA Adams   school 5304410 1158   Lind School District 530441003416 5293 Lind-Ritzville Middle School   Regular School No Middle 06 08 2017   grade_8 11 0 7   0 1     0   0   8 11 0   2   1   13       0.0 19 11 0 7   0 1     0   0   8 11 0   2 1 13     0 19
623747 623747 WA Adams   school 5304410 1158   Lind School District 530441003416 5293 Lind-Ritzville Middle School   Regular School No Middle 06 08 2017   pk_12_total 32 0 16   0 1     0   0   20 29 0   7   5   31       0.0 49 32 0 16   0 1     0   0   20 29 0   7 5 31     0 49
623748 623748 WA Adams   school 5304410 1158   Lind School District 530441000695 3421 Lind Elementary School   Regular School No Elementary PK 05 2017   grade_1 13 0 4   0 0     0   0   7 10 0   2   3   7       0.0 17 13 0 4   0 0     0   0   7 10 0   2 3 7     0 17
623749 623749 WA Adams   school 5304410 1158   Lind School District 530441000695 3421 Lind Elementary School   Regular School No Elementary PK 05 2017   grade_2 10 0 4   0 0     0   0   8 6 0   3   3   13       0.0 14 10 0 4   0 0     0   0   8 6 0   3 3 13     0 14
623750 623750 WA Adams   school 5304410 1158   Lind School District 530441000695 3421 Lind Elementary School   Regular School No Elementary PK 05 2017   grade_3 10 0 6   0 0     0   0   11 5 0   4   3   12       0.0 16 10 0 6   0 0     0   0   11 5 0   4 3 12     0 16
623751 623751 WA Adams   school 5304410 1158   Lind School District 530441000695 3421 Lind Elementary School   Regular School No Elementary PK 05 2017   grade_4 14 0 6   0 0     0   0   11 9 0   4   2   19       0.0 20 14 0 6   0 0     0   0   11 9 0   4 2 19     0 20
623752 623752 WA Adams   school 5304410 1158   Lind School District 530441000695 3421 Lind Elementary School   Regular School No Elementary PK 05 2017   grade_5 8 0 6   0 0     0   0   8 6 0   5   4   12       0.0 14 8 0 6   0 0     0   0   8 6 0   5 4 12     0 14
623753 623753 WA Adams   school 5304410 1158   Lind School District 530441000695 3421 Lind Elementary School   Regular School No Elementary PK 05 2017   pk_12_total 90 0 39   0 0     0   0   73 56 0   22   17   96       0.0 129 90 0 39   0 0     0   0   73 56 0   22 17 96     0 129
623754 623754 WA Adams   school 5304410 1158   Lind School District 530441000695 3421 Lind Elementary School   Regular School No Elementary PK 05 2017   kindergarten 12 0 4   0 0     0   0   10 6 0   4   2   13       0.0 16 12 0 4   0 0     0   0   10 6 0   4 2 13     0 16
623755 623755 WA Adams   school 5304410 1158   Lind School District 530441000695 3421 Lind Elementary School   Regular School No Elementary PK 05 2017   pre_kindergarten 23 0 9   0 0     0   0   18 14 0   0   0   20       0.0 32 23 0 9   0 0     0   0   18 14 0   0 0 20     0 32
626514 626514 WA Adams   school 5306480 1147   Othello School District 530648003470 5367 Desert Oasis High School   Alternative School No High 09 12 2017   grade_10 1 0 17   0 0     0   0   12 6 0   7   0   17       0.0 18 1 0 17   0 0     0   0   12 6 0   7 0 17     0 18
626515 626515 WA Adams   school 5306480 1147   Othello School District 530648003470 5367 Desert Oasis High School   Alternative School No High 09 12 2017   grade_11 2 0 34   0 0     0   0   22 14 0   12   3   35       0.0 36 2 0 34   0 0     0   0   22 14 0   12 3 35     0 36
626516 626516 WA Adams   school 5306480 1147   Othello School District 530648003470 5367 Desert Oasis High School   Alternative School No High 09 12 2017   grade_12 0 0 36   0 0     0   0   20 16 0   7   0   33       1.0 36 0 0 36   0 0     0   0   20 16 0   7 0 33     1 36
626517 626517 WA Adams   school 5306480 1147   Othello School District 530648003470 5367 Desert Oasis High School   Alternative School No High 09 12 2017   pk_12_total 3 0 87   0 0     0   0   54 36 0   26   3   85       1.0 90 3 0 87   0 0     0   0   54 36 0   26 3 85     1 90
626518 626518 WA Adams   school 5306480 1147   Othello School District 530648000954 2961 Hiawatha Elementary School   Regular School No Elementary KG 05 2017   grade_1 9 0 90   0 0     0   0   47 52 0   76   4   94       1.0 99 9 0 90   0 0     0   0   47 52 0   76 4 94     1 99
626519 626519 WA Adams   school 5306480 1147   Othello School District 530648000954 2961 Hiawatha Elementary School   Regular School No Elementary KG 05 2017   grade_2 10 0 75   0 0     0   0   43 42 0   57   0   75       1.0 85 10 0 75   0 0     0   0   43 42 0   57 0 75     1 85
626520 626520 WA Adams   school 5306480 1147   Othello School District 530648000954 2961 Hiawatha Elementary School   Regular School No Elementary KG 05 2017   grade_3 12 0 85   0 0     0   0   53 44 0   56   1   87       2.0 97 12 0 85   0 0     0   0   53 44 0   56 1 87     2 97
626521 626521 WA Adams   school 5306480 1147   Othello School District 530648000954 2961 Hiawatha Elementary School   Regular School No Elementary KG 05 2017   grade_4 7 0 88   0 0     0   1   57 39 0   54   3   89       2.0 96 7 0 88   0 0     0   1   57 39 0   54 3 89     2 96
626522 626522 WA Adams   school 5306480 1147   Othello School District 530648000954 2961 Hiawatha Elementary School   Regular School No Elementary KG 05 2017   grade_5 7 0 72   0 0     0   0   37 42 0   44   0   74       6.0 79 7 0 72   0 0     0   0   37 42 0   44 0 74     6 79
626523 626523 WA Adams   school 5306480 1147   Othello School District 530648000954 2961 Hiawatha Elementary School   Regular School No Elementary KG 05 2017   pk_12_total 56 0 492   0 0     0   1   279 270 0   352   10   498       12.0 549 56 0 492   0 0     0   1   279 270 0   352 10 498     12 549
626524 626524 WA Adams   school 5306480 1147   Othello School District 530648000954 2961 Hiawatha Elementary School   Regular School No Elementary KG 05 2017   kindergarten_half_day 0 0 1   0 0     0   0   0 1 0   1   0   1       0.0 1 0 0 1   0 0     0   0   0 1 0   1 0 1     0 1
626525 626525 WA Adams   school 5306480 1147   Othello School District 530648000954 2961 Hiawatha Elementary School   Regular School No Elementary KG 05 2017   kindergarten 11 0 80   0 0     0   0   41 50 0   63   2   77       0.0 91 11 0 80   0 0     0   0   41 50 0   63 2 77     0 91
626526 626526 WA Adams   school 5306480 1147   Othello School District 530648000954 2961 Hiawatha Elementary School   Regular School No Elementary KG 05 2017   pre_kindergarten 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
626527 626527 WA Adams   school 5306480 1147   Othello School District 530648000955 2902 Lutacaga Elementary   Regular School No Elementary KG 05 2017   grade_1 3 0 95   0 0     0   0   51 47 0   68   1   83       1.0 98 3 0 95   0 0     0   0   51 47 0   68 1 83     1 98
626528 626528 WA Adams   school 5306480 1147   Othello School District 530648000955 2902 Lutacaga Elementary   Regular School No Elementary KG 05 2017   grade_2 7 0 86   0 0     0   0   46 47 0   66   0   75       1.0 93 7 0 86   0 0     0   0   46 47 0   66 0 75     1 93
626529 626529 WA Adams   school 5306480 1147   Othello School District 530648000955 2902 Lutacaga Elementary   Regular School No Elementary KG 05 2017   grade_3 7 1 92   0 1     0   1   49 53 0   62   1   80       1.0 102 7 1 92   0 1     0   1   49 53 0   62 1 80     1 102
626530 626530 WA Adams   school 5306480 1147   Othello School District 530648000955 2902 Lutacaga Elementary   Regular School No Elementary KG 05 2017   grade_4 5 0 92   0 0     0   0   48 49 0   55   2   85       3.0 97 5 0 92   0 0     0   0   48 49 0   55 2 85     3 97
626531 626531 WA Adams   school 5306480 1147   Othello School District 530648000955 2902 Lutacaga Elementary   Regular School No Elementary KG 05 2017   grade_5 2 0 103   0 0     0   0   53 52 0   58   0   90       1.0 105 2 0 103   0 0     0   0   53 52 0   58 0 90     1 105
626532 626532 WA Adams   school 5306480 1147   Othello School District 530648000955 2902 Lutacaga Elementary   Regular School No Elementary KG 05 2017   pk_12_total 28 1 557   0 2     0   2   299 291 0   376   5   494       7.0 590 28 1 557   0 2     0   2   299 291 0   376 5 494     7 590
626533 626533 WA Adams   school 5306480 1147   Othello School District 530648000955 2902 Lutacaga Elementary   Regular School No Elementary KG 05 2017   kindergarten 4 0 89   0 1     0   1   52 43 0   67   1   81       0.0 95 4 0 89   0 1     0   1   52 43 0   67 1 81     0 95
626534 626534 WA Adams   school 5306480 1147   Othello School District 530648000956 3471 McFarland Middle School   Regular School No Middle 06 08 2017   grade_6 28 0 311   0 0     0   2   170 171 0   130   4   292       5.0 341 28 0 311   0 0     0   2   170 171 0   130 4 292     5 341
626535 626535 WA Adams   school 5306480 1147   Othello School District 530648000956 3471 McFarland Middle School   Regular School No Middle 06 08 2017   grade_7 32 0 270   0 0     0   0   167 135 0   100   6   260       8.0 302 32 0 270   0 0     0   0   167 135 0   100 6 260     8 302
626536 626536 WA Adams   school 5306480 1147   Othello School District 530648000956 3471 McFarland Middle School   Regular School No Middle 06 08 2017   grade_8 37 1 265   0 3     0   1   178 129 0   84   2   247       12.0 307 37 1 265   0 3     0   1   178 129 0   84 2 247     12 307
626537 626537 WA Adams   school 5306480 1147   Othello School District 530648000956 3471 McFarland Middle School   Regular School No Middle 06 08 2017   pk_12_total 97 1 846   0 3     0   3   515 435 0   314   12   799       25.0 950 97 1 846   0 3     0   3   515 435 0   314 12 799     25 950
626538 626538 WA Adams   school 5306480 1147   Othello School District 530648000957 3015 Othello High School   Regular School No High 09 12 2017   grade_10 23 0 246   0 1     1   2   126 147 0   76   0   232       5.0 273 23 0 246   0 1     1   2   126 147 0   76 0 232     5 273
626539 626539 WA Adams   school 5306480 1147   Othello School District 530648000957 3015 Othello High School   Regular School No High 09 12 2017   grade_11 30 0 209   0 1     0   4   132 112 0   46   1   193       11.0 244 30 0 209   0 1     0   4   132 112 0   46 1 193     11 244
626540 626540 WA Adams   school 5306480 1147   Othello School District 530648000957 3015 Othello High School   Regular School No High 09 12 2017   grade_12 32 0 209   0 0     0   1   114 128 0   38   1   190       8.0 242 32 0 209   0 0     0   1   114 128 0   38 1 190     8 242
626541 626541 WA Adams   school 5306480 1147   Othello School District 530648000957 3015 Othello High School   Regular School No High 09 12 2017   grade_9 43 1 265   0 0     0   0   172 137 0   87   5   258       10.0 309 43 1 265   0 0     0   0   172 137 0   87 5 258     10 309
626542 626542 WA Adams   school 5306480 1147   Othello School District 530648000957 3015 Othello High School   Regular School No High 09 12 2017   pk_12_total 134 1 958   0 2     1   7   569 534 0   247   7   900       34.0 1103 134 1 958   0 2     1   7   569 534 0   247 7 900     34 1103
626543 626543 WA Adams   school 5306480 1147   Othello School District 530648000957 3015 Othello High School   Regular School No High 09 12 2017   kindergarten_half_day 0 0 2   0 0     0   0   2 0 0   0   0   0       0.0 2 0 0 2   0 0     0   0   2 0 0   0 0 0     0 2
626544 626544 WA Adams   school 5306480 1147   Othello School District 530648000957 3015 Othello High School   Regular School No High 09 12 2017   pre_kindergarten 6 0 27   0 0     0   0   23 10 0   0   0   27       0.0 33 6 0 27   0 0     0   0   23 10 0   0 0 27     0 33
626545 626545 WA Adams   school 5306480 1147   Othello School District 530648000958 3730 Scootney Springs Elementary   Regular School No Elementary KG 05 2017   grade_1 15 1 77   0 1     0   1   47 48 0   52   1   79       0.0 95 15 1 77   0 1     0   1   47 48 0   52 1 79     0 95
626546 626546 WA Adams   school 5306480 1147   Othello School District 530648000958 3730 Scootney Springs Elementary   Regular School No Elementary KG 05 2017   grade_2 10 0 74   0 0     0   1   47 38 0   54   0   74       0.0 85 10 0 74   0 0     0   1   47 38 0   54 0 74     0 85
626547 626547 WA Adams   school 5306480 1147   Othello School District 530648000958 3730 Scootney Springs Elementary   Regular School No Elementary KG 05 2017   grade_3 15 0 83   0 0     0   0   57 41 0   59   2   87       0.0 98 15 0 83   0 0     0   0   57 41 0   59 2 87     0 98
626548 626548 WA Adams   school 5306480 1147   Othello School District 530648000958 3730 Scootney Springs Elementary   Regular School No Elementary KG 05 2017   grade_4 8 0 81   0 0     0   0   47 42 0   46   0   77       1.0 89 8 0 81   0 0     0   0   47 42 0   46 0 77     1 89
626549 626549 WA Adams   school 5306480 1147   Othello School District 530648000958 3730 Scootney Springs Elementary   Regular School No Elementary KG 05 2017   grade_5 13 0 68   0 1     0   1   49 34 0   40   0   69       1.0 83 13 0 68   0 1     0   1   49 34 0   40 0 69     1 83
626550 626550 WA Adams   school 5306480 1147   Othello School District 530648000958 3730 Scootney Springs Elementary   Regular School No Elementary KG 05 2017   pk_12_total 74 1 508   0 2     0   3   321 267 0   308   7   489       2.0 588 74 1 508   0 2     0   3   321 267 0   308 7 489     2 588
626551 626551 WA Adams   school 5306480 1147   Othello School District 530648000958 3730 Scootney Springs Elementary   Regular School No Elementary KG 05 2017   kindergarten_half_day 0 0 1   0 0     0   0   1 0 0   0   0   1       0.0 1 0 0 1   0 0     0   0   1 0 0   0 0 1     0 1
626552 626552 WA Adams   school 5306480 1147   Othello School District 530648000958 3730 Scootney Springs Elementary   Regular School No Elementary KG 05 2017   kindergarten 12 0 77   0 0     0   0   54 35 0   51   3   65       0.0 89 12 0 77   0 0     0   0   54 35 0   51 3 65     0 89
626553 626553 WA Adams   school 5306480 1147   Othello School District 530648000958 3730 Scootney Springs Elementary   Regular School No Elementary KG 05 2017   pre_kindergarten 1 0 47   0 0     0   0   19 29 0   6   1   37       0.0 48 1 0 47   0 0     0   0   19 29 0   6 1 37     0 48
626554 626554 WA Adams   school 5306480 1147   Othello School District 530648003393 5285 Wahitis Elementary School   Regular School No Elementary KG 05 2017   grade_1 4 0 89   0 0     0   1   44 50 0   59   1   78       1.0 94 4 0 89   0 0     0   1   44 50 0   59 1 78     1 94
626555 626555 WA Adams   school 5306480 1147   Othello School District 530648003393 5285 Wahitis Elementary School   Regular School No Elementary KG 05 2017   grade_2 7 0 84   0 0     0   0   53 38 0   59   2   86       0.0 91 7 0 84   0 0     0   0   53 38 0   59 2 86     0 91
626556 626556 WA Adams   school 5306480 1147   Othello School District 530648003393 5285 Wahitis Elementary School   Regular School No Elementary KG 05 2017   grade_3 13 0 88   0 0     0   0   57 44 0   60   1   90       2.0 101 13 0 88   0 0     0   0   57 44 0   60 1 90     2 101
626557 626557 WA Adams   school 5306480 1147   Othello School District 530648003393 5285 Wahitis Elementary School   Regular School No Elementary KG 05 2017   grade_4 10 0 70   0 0     0   0   33 47 0   43   0   65       1.0 80 10 0 70   0 0     0   0   33 47 0   43 0 65     1 80
626558 626558 WA Adams   school 5306480 1147   Othello School District 530648003393 5285 Wahitis Elementary School   Regular School No Elementary KG 05 2017   grade_5 8 0 74   0 0     0   1   38 45 0   37   2   69       2.0 83 8 0 74   0 0     0   1   38 45 0   37 2 69     2 83
626559 626559 WA Adams   school 5306480 1147   Othello School District 530648003393 5285 Wahitis Elementary School   Regular School No Elementary KG 05 2017   pk_12_total 55 0 487   0 0     0   2   273 271 0   312   8   465       6.0 544 55 0 487   0 0     0   2   273 271 0   312 8 465     6 544
626560 626560 WA Adams   school 5306480 1147   Othello School District 530648003393 5285 Wahitis Elementary School   Regular School No Elementary KG 05 2017   kindergarten_half_day 0 0 2   0 0     0   0   2 0 0   1   0   1       0.0 2 0 0 2   0 0     0   0   2 0 0   1 0 1     0 2
626561 626561 WA Adams   school 5306480 1147   Othello School District 530648003393 5285 Wahitis Elementary School   Regular School No Elementary KG 05 2017   kindergarten 13 0 76   0 0     0   0   44 45 0   49   2   72       0.0 89 13 0 76   0 0     0   0   44 45 0   49 2 72     0 89
626562 626562 WA Adams   school 5306480 1147   Othello School District 530648003393 5285 Wahitis Elementary School   Regular School No Elementary KG 05 2017   pre_kindergarten 0 0 4   0 0     0   0   2 2 0   4   0   4       0.0 4 0 0 4   0 0     0   0   2 2 0   4 0 4     0 4
627949 627949 WA Adams   school 5307380 1160   Ritzville School District 530738003418 5303 Lind Ritzville Middle School   Regular School No Middle 06 08 2017   grade_6 14 0 1   0 0     0   0   9 6 0   1   0   6       0.0 15 14 0 1   0 0     0   0   9 6 0   1 0 6     0 15
627950 627950 WA Adams   school 5307380 1160   Ritzville School District 530738003418 5303 Lind Ritzville Middle School   Regular School No Middle 06 08 2017   grade_7 13 0 2   1 0     0   0   6 10 0   0   0   11       2.0 16 13 0 2   1 0     0   0   6 10 0   0 0 11     2 16
627951 627951 WA Adams   school 5307380 1160   Ritzville School District 530738003418 5303 Lind Ritzville Middle School   Regular School No Middle 06 08 2017   grade_8 21 0 1   1 0     0   0   12 11 0   0   0   11       0.0 23 21 0 1   1 0     0   0   12 11 0   0 0 11     0 23
627952 627952 WA Adams   school 5307380 1160   Ritzville School District 530738003418 5303 Lind Ritzville Middle School   Regular School No Middle 06 08 2017   pk_12_total 48 0 4   2 0     0   0   27 27 0   1   0   28       2.0 54 48 0 4   2 0     0   0   27 27 0   1 0 28     2 54
627953 627953 WA Adams   school 5307380 1160   Ritzville School District 530738001109 2719 Ritzville Grade School   Regular School No Elementary KG 05 2017   grade_1 14 0 4   0 0     0   0   16 2 0   0   0   9       0.0 18 14 0 4   0 0     0   0   16 2 0   0 0 9     0 18
627954 627954 WA Adams   school 5307380 1160   Ritzville School District 530738001109 2719 Ritzville Grade School   Regular School No Elementary KG 05 2017   grade_2 22 1 1   0 0     0   1   17 8 0   0   0   17       0.0 25 22 1 1   0 0     0   1   17 8 0   0 0 17     0 25
627955 627955 WA Adams   school 5307380 1160   Ritzville School District 530738001109 2719 Ritzville Grade School   Regular School No Elementary KG 05 2017   grade_3 26 0 5   0 1     0   0   21 11 0   0   0   18       0.0 32 26 0 5   0 1     0   0   21 11 0   0 0 18     0 32
627956 627956 WA Adams   school 5307380 1160   Ritzville School District 530738001109 2719 Ritzville Grade School   Regular School No Elementary KG 05 2017   grade_4 24 1 2   0 1     0   0   13 15 0   0   0   13       0.0 28 24 1 2   0 1     0   0   13 15 0   0 0 13     0 28
627957 627957 WA Adams   school 5307380 1160   Ritzville School District 530738001109 2719 Ritzville Grade School   Regular School No Elementary KG 05 2017   grade_5 22 0 5   1 1     0   1   18 12 0   0   0   16       0.0 30 22 0 5   1 1     0   1   18 12 0   0 0 16     0 30
627958 627958 WA Adams   school 5307380 1160   Ritzville School District 530738001109 2719 Ritzville Grade School   Regular School No Elementary KG 05 2017   pk_12_total 156 2 28   3 5     0   3   117 80 0   0   0   111       0.0 197 156 2 28   3 5     0   3   117 80 0   0 0 111     0 197
627959 627959 WA Adams   school 5307380 1160   Ritzville School District 530738001109 2719 Ritzville Grade School   Regular School No Elementary KG 05 2017   kindergarten 25 0 8   0 1     0   0   15 19 0   0   0   19       0.0 34 25 0 8   0 1     0   0   15 19 0   0 0 19     0 34
627960 627960 WA Adams   school 5307380 1160   Ritzville School District 530738001109 2719 Ritzville Grade School   Regular School No Elementary KG 05 2017   pre_kindergarten 23 0 3   2 1     0   1   17 13 0   0   0   19       0.0 30 23 0 3   2 1     0   1   17 13 0   0 0 19     0 30
627961 627961 WA Adams   school 5307380 1160   Ritzville School District 530738001111 2132 Ritzville High School   Regular School No High 09 12 2017   grade_10 22 1 1   1 1     0   0   13 14 0   0   0   9       1.0 27 22 1 1   1 1     0   0   13 14 0   0 0 9     1 27
627962 627962 WA Adams   school 5307380 1160   Ritzville School District 530738001111 2132 Ritzville High School   Regular School No High 09 12 2017   grade_11 25 0 4   2 0     0   0   15 16 0   0   2   8       3.0 31 25 0 4   2 0     0   0   15 16 0   0 2 8     3 31
627963 627963 WA Adams   school 5307380 1160   Ritzville School District 530738001111 2132 Ritzville High School   Regular School No High 09 12 2017   grade_12 25 0 2   0 1     0   0   11 17 0   0   1   7       0.0 28 25 0 2   0 1     0   0   11 17 0   0 1 7     0 28
627964 627964 WA Adams   school 5307380 1160   Ritzville School District 530738001111 2132 Ritzville High School   Regular School No High 09 12 2017   grade_9 33 0 3   0 0     0   3   15 24 0   0   0   20       2.0 39 33 0 3   0 0     0   3   15 24 0   0 0 20     2 39
627965 627965 WA Adams   school 5307380 1160   Ritzville School District 530738001111 2132 Ritzville High School   Regular School No High 09 12 2017   pk_12_total 105 1 10   3 2     0   3   54 71 0   0   3   44       6.0 125 105 1 10   3 2     0   3   54 71 0   0 3 44     6 125
632007 632007 WA Adams   school 5309570 1109   Washtucna School District 530957001625 3075 Washtucna Elementary/High School   Regular School No Other KG 12 2017   grade_10 0 0 1   0 0     0   0   0 1 0   0   0   1       0.0 1 0 0 1   0 0     0   0   0 1 0   0 0 1     0 1
632008 632008 WA Adams   school 5309570 1109   Washtucna School District 530957001625 3075 Washtucna Elementary/High School   Regular School No Other KG 12 2017   grade_11 4 0 1   0 0     0   0   3 2 0   0   1   5       0.0 5 4 0 1   0 0     0   0   3 2 0   0 1 5     0 5
632009 632009 WA Adams   school 5309570 1109   Washtucna School District 530957001625 3075 Washtucna Elementary/High School   Regular School No Other KG 12 2017   grade_12 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
632010 632010 WA Adams   school 5309570 1109   Washtucna School District 530957001625 3075 Washtucna Elementary/High School   Regular School No Other KG 12 2017   grade_1 1 0 1   0 0     0   0   2 0 0   0   0   1       0.0 2 1 0 1   0 0     0   0   2 0 0   0 0 1     0 2
632011 632011 WA Adams   school 5309570 1109   Washtucna School District 530957001625 3075 Washtucna Elementary/High School   Regular School No Other KG 12 2017   grade_2 3 0 0   0 0     0   0   1 2 0   0   0   3       0.0 3 3 0 0   0 0     0   0   1 2 0   0 0 3     0 3
632012 632012 WA Adams   school 5309570 1109   Washtucna School District 530957001625 3075 Washtucna Elementary/High School   Regular School No Other KG 12 2017   grade_3 2 0 0   0 0     0   0   1 1 0   0   0   2       0.0 2 2 0 0   0 0     0   0   1 1 0   0 0 2     0 2
632013 632013 WA Adams   school 5309570 1109   Washtucna School District 530957001625 3075 Washtucna Elementary/High School   Regular School No Other KG 12 2017   grade_4 4 0 0   0 0     0   0   2 2 0   0   0   2       0.0 4 4 0 0   0 0     0   0   2 2 0   0 0 2     0 4
632014 632014 WA Adams   school 5309570 1109   Washtucna School District 530957001625 3075 Washtucna Elementary/High School   Regular School No Other KG 12 2017   grade_5 2 0 0   0 0     0   0   1 1 0   0   0   2       0.0 2 2 0 0   0 0     0   0   1 1 0   0 0 2     0 2
632015 632015 WA Adams   school 5309570 1109   Washtucna School District 530957001625 3075 Washtucna Elementary/High School   Regular School No Other KG 12 2017   grade_6 4 0 1   0 0     0   0   3 2 0   0   0   3       0.0 5 4 0 1   0 0     0   0   3 2 0   0 0 3     0 5

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