Data source: Big Local News · About: Big Local

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

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
618467 WA Skagit   school 5300780 29100   Burlington-Edison School District 530078000157 3251 Lucille Umbarger Elementary   Regular School No Elementary 01 08 2017   grade_6 38 1 35   1 0     0   2   40 37 0   20   1   52       1.0 77 38 1 35   1 0     0   2   40 37 0   20 1 52     1 77
618468 WA Skagit   school 5300780 29100   Burlington-Edison School District 530078000157 3251 Lucille Umbarger Elementary   Regular School No Elementary 01 08 2017   grade_7 39 0 79   2 2     0   4   59 67 0   30   3   91       2.0 126 39 0 79   2 2     0   4   59 67 0   30 3 91     2 126
618469 WA Skagit   school 5300780 29100   Burlington-Edison School District 530078000157 3251 Lucille Umbarger Elementary   Regular School No Elementary 01 08 2017   grade_8 50 0 62   0 1     0   4   61 56 0   23   2   80       3.0 117 50 0 62   0 1     0   4   61 56 0   23 2 80     3 117
618470 WA Skagit   school 5300780 29100   Burlington-Edison School District 530078000157 3251 Lucille Umbarger Elementary   Regular School No Elementary 01 08 2017   pk_12_total 278 5 366   7 11     0   27   366 330 0   194   25   486       10.0 696 278 5 366   7 11     0   27   366 330 0   194 25 486     10 696
618857 WA Spokane   school 5301110 32356   Central Valley School District 530111000194 2157 Greenacres Elementary   Regular School No Elementary 01 05 2017   grade_1 107 0 10   0 1     2   2   60 62 0   13   1   45       2.0 122 107 0 10   0 1     2   2   60 62 0   13 1 45     2 122
618858 WA Spokane   school 5301110 32356   Central Valley School District 530111000194 2157 Greenacres Elementary   Regular School No Elementary 01 05 2017   grade_2 108 1 6   1 2     1   3   64 58 0   5   0   38       5.0 122 108 1 6   1 2     1   3   64 58 0   5 0 38     5 122
618859 WA Spokane   school 5301110 32356   Central Valley School District 530111000194 2157 Greenacres Elementary   Regular School No Elementary 01 05 2017   grade_3 109 0 4   2 0     1   7   61 62 0   6   2   53       5.0 123 109 0 4   2 0     1   7   61 62 0   6 2 53     5 123
618860 WA Spokane   school 5301110 32356   Central Valley School District 530111000194 2157 Greenacres Elementary   Regular School No Elementary 01 05 2017   grade_4 111 0 11   3 2     0   2   62 67 0   8   2   44       3.0 129 111 0 11   3 2     0   2   62 67 0   8 2 44     3 129
618861 WA Spokane   school 5301110 32356   Central Valley School District 530111000194 2157 Greenacres Elementary   Regular School No Elementary 01 05 2017   grade_5 123 0 7   1 0     0   8   81 58 0   2   1   49       9.0 139 123 0 7   1 0     0   8   81 58 0   2 1 49     9 139
618862 WA Spokane   school 5301110 32356   Central Valley School District 530111000194 2157 Greenacres Elementary   Regular School No Elementary 01 05 2017   pk_12_total 558 1 38   7 5     4   22   328 307 0   34   6   229       24.0 635 558 1 38   7 5     4   22   328 307 0   34 6 229     24 635
618880 WA Spokane   school 5301110 32356   Central Valley School District 530111002681 4529 Liberty Lake Elementary   Regular School No Elementary 01 05 2017   grade_1 105 1 7   0 3     0   5   61 60 0   6   0   29       2.0 121 105 1 7   0 3     0   5   61 60 0   6 0 29     2 121
618881 WA Spokane   school 5301110 32356   Central Valley School District 530111002681 4529 Liberty Lake Elementary   Regular School No Elementary 01 05 2017   grade_2 105 1 13   1 1     0   3   61 63 0   0   0   20       9.0 124 105 1 13   1 1     0   3   61 63 0   0 0 20     9 124
618882 WA Spokane   school 5301110 32356   Central Valley School District 530111002681 4529 Liberty Lake Elementary   Regular School No Elementary 01 05 2017   grade_3 121 2 7   1 6     1   8   77 69 0   2   0   30       5.0 146 121 2 7   1 6     1   8   77 69 0   2 0 30     5 146
618883 WA Spokane   school 5301110 32356   Central Valley School District 530111002681 4529 Liberty Lake Elementary   Regular School No Elementary 01 05 2017   grade_4 135 1 8   1 2     1   2   69 81 0   4   2   38       7.0 150 135 1 8   1 2     1   2   69 81 0   4 2 38     7 150
618884 WA Spokane   school 5301110 32356   Central Valley School District 530111002681 4529 Liberty Lake Elementary   Regular School No Elementary 01 05 2017   grade_5 118 2 8   0 4     2   1   69 66 0   1   1   26       7.0 135 118 2 8   0 4     2   1   69 66 0   1 1 26     7 135
618885 WA Spokane   school 5301110 32356   Central Valley School District 530111002681 4529 Liberty Lake Elementary   Regular School No Elementary 01 05 2017   pk_12_total 584 7 43   3 16     4   19   337 339 0   13   3   143       30.0 676 584 7 43   3 16     4   19   337 339 0   13 3 143     30 676
619865 WA Pierce   school 5302130 27343   Dieringer School District 530213000310 3683 Lake Tapps Elementary   Regular School No Elementary 01 03 2017   grade_1 101 2 11   0 4     1   16   67 68 0   8   1   20       2.0 135 101 2 11   0 4     1   16   67 68 0   8 1 20     2 135
619866 WA Pierce   school 5302130 27343   Dieringer School District 530213000310 3683 Lake Tapps Elementary   Regular School No Elementary 01 03 2017   grade_2 96 2 15   1 13     0   17   75 69 0   7   0   15       4.0 144 96 2 15   1 13     0   17   75 69 0   7 0 15     4 144
619867 WA Pierce   school 5302130 27343   Dieringer School District 530213000310 3683 Lake Tapps Elementary   Regular School No Elementary 01 03 2017   grade_3 115 3 17   1 8     3   12   95 64 0   5   1   26       6.0 159 115 3 17   1 8     3   12   95 64 0   5 1 26     6 159
619868 WA Pierce   school 5302130 27343   Dieringer School District 530213000310 3683 Lake Tapps Elementary   Regular School No Elementary 01 03 2017   pk_12_total 312 7 43   2 25     4   45   237 201 0   20   2   61       12.0 438 312 7 43   2 25     4   45   237 201 0   20 2 61     12 438
623382 WA King   school 5304230 17414   Lake Washington School District 530423000673 3856 Community School   Alternative School No Elementary 01 05 2017   grade_1 9 0 1   0 3     0   1   8 6 0   3   0   1       0.0 14 9 0 1   0 3     0   1   8 6 0   3 0 1     0 14
623383 WA King   school 5304230 17414   Lake Washington School District 530423000673 3856 Community School   Alternative School No Elementary 01 05 2017   grade_2 11 1 1   0 1     0   4   11 7 0   0   0   2       0.0 18 11 1 1   0 1     0   4   11 7 0   0 0 2     0 18
623384 WA King   school 5304230 17414   Lake Washington School District 530423000673 3856 Community School   Alternative School No Elementary 01 05 2017   grade_3 10 0 0   0 3     0   0   6 7 0   0   0   1       1.0 13 10 0 0   0 3     0   0   6 7 0   0 0 1     1 13
623385 WA King   school 5304230 17414   Lake Washington School District 530423000673 3856 Community School   Alternative School No Elementary 01 05 2017   grade_4 12 0 1   0 1     0   1   5 10 0   1   0   1       1.0 15 12 0 1   0 1     0   1   5 10 0   1 0 1     1 15
623386 WA King   school 5304230 17414   Lake Washington School District 530423000673 3856 Community School   Alternative School No Elementary 01 05 2017   grade_5 7 0 0   0 3     0   1   5 6 0   1   0   0       1.0 11 7 0 0   0 3     0   1   5 6 0   1 0 0     1 11
623387 WA King   school 5304230 17414   Lake Washington School District 530423000673 3856 Community School   Alternative School No Elementary 01 05 2017   pk_12_total 49 1 3   0 11     0   7   35 36 0   5   0   5       3.0 71 49 1 3   0 11     0   7   35 36 0   5 0 5     3 71
623455 WA King   school 5304230 17414   Lake Washington School District 530423002519 1687 Explorer Community School   Alternative School No Elementary 01 05 2017   grade_1 2 0 0   0 10     0   2   4 10 0   2   0   0       0.0 14 2 0 0   0 10     0   2   4 10 0   2 0 0     0 14
623456 WA King   school 5304230 17414   Lake Washington School District 530423002519 1687 Explorer Community School   Alternative School No Elementary 01 05 2017   grade_2 11 0 1   0 4     0   0   9 7 0   0   0   0       0.0 16 11 0 1   0 4     0   0   9 7 0   0 0 0     0 16
623457 WA King   school 5304230 17414   Lake Washington School District 530423002519 1687 Explorer Community School   Alternative School No Elementary 01 05 2017   grade_3 9 0 0   0 5     0   0   5 9 0   0   0   0       0.0 14 9 0 0   0 5     0   0   5 9 0   0 0 0     0 14
623458 WA King   school 5304230 17414   Lake Washington School District 530423002519 1687 Explorer Community School   Alternative School No Elementary 01 05 2017   grade_4 7 0 0   0 6     0   0   5 8 0   0   0   0       1.0 13 7 0 0   0 6     0   0   5 8 0   0 0 0     1 13
623459 WA King   school 5304230 17414   Lake Washington School District 530423002519 1687 Explorer Community School   Alternative School No Elementary 01 05 2017   grade_5 6 0 2   0 7     0   1   8 8 0   0   0   0       0.0 16 6 0 2   0 7     0   1   8 8 0   0 0 0     0 16
623460 WA King   school 5304230 17414   Lake Washington School District 530423002519 1687 Explorer Community School   Alternative School No Elementary 01 05 2017   pk_12_total 35 0 3   0 32     0   3   31 42 0   2   0   0       1.0 73 35 0 3   0 32     0   3   31 42 0   2 0 0     1 73
625946 WA Island   school 5305940 15201   Oak Harbor School District 530594002264 4328 Hillcrest Elementary   Regular School No Elementary 01 05 2017   grade_1 73 2 12   0 5     0   14   52 54 0   6   1   28       1.0 106 73 2 12   0 5     0   14   52 54 0   6 1 28     1 106
625947 WA Island   school 5305940 15201   Oak Harbor School District 530594002264 4328 Hillcrest Elementary   Regular School No Elementary 01 05 2017   grade_2 61 2 21   0 6     1   13   50 54 0   3   2   31       3.0 104 61 2 21   0 6     1   13   50 54 0   3 2 31     3 104
625948 WA Island   school 5305940 15201   Oak Harbor School District 530594002264 4328 Hillcrest Elementary   Regular School No Elementary 01 05 2017   grade_3 72 2 19   0 2     1   12   63 45 0   0   3   34       2.0 108 72 2 19   0 2     1   12   63 45 0   0 3 34     2 108
625949 WA Island   school 5305940 15201   Oak Harbor School District 530594002264 4328 Hillcrest Elementary   Regular School No Elementary 01 05 2017   grade_4 87 5 19   1 5     1   18   72 64 0   4   6   47       9.0 136 87 5 19   1 5     1   18   72 64 0   4 6 47     9 136
625950 WA Island   school 5305940 15201   Oak Harbor School District 530594002264 4328 Hillcrest Elementary   Regular School No Elementary 01 05 2017   grade_5 73 4 10   0 6     2   17   54 58 0   3   8   40       4.0 112 73 4 10   0 6     2   17   54 58 0   3 8 40     4 112
625951 WA Island   school 5305940 15201   Oak Harbor School District 530594002264 4328 Hillcrest Elementary   Regular School No Elementary 01 05 2017   pk_12_total 366 15 81   1 24     5   74   291 275 0   16   20   180       19.0 566 366 15 81   1 24     5   74   291 275 0   16 20 180     19 566
632556 WA Yakima   school 5310110 39007   Yakima School District 531011002609 3023 Discovery Lab School   Regular School No Elementary 01 08 2017   grade_1 9 0 8   0 0     0   1   9 9 0   3   0   9       1.0 18 9 0 8   0 0     0   1   9 9 0   3 0 9     1 18
632557 WA Yakima   school 5310110 39007   Yakima School District 531011002609 3023 Discovery Lab School   Regular School No Elementary 01 08 2017   grade_2 11 0 15   0 0     0   2   14 14 0   5   0   12       1.0 28 11 0 15   0 0     0   2   14 14 0   5 0 12     1 28
632558 WA Yakima   school 5310110 39007   Yakima School District 531011002609 3023 Discovery Lab School   Regular School No Elementary 01 08 2017   grade_3 10 0 14   0 0     0   2   8 18 0   7   0   14       0.0 26 10 0 14   0 0     0   2   8 18 0   7 0 14     0 26
632559 WA Yakima   school 5310110 39007   Yakima School District 531011002609 3023 Discovery Lab School   Regular School No Elementary 01 08 2017   grade_4 9 1 16   1 0     0   1   13 15 0   10   1   17       1.0 28 9 1 16   1 0     0   1   13 15 0   10 1 17     1 28
632560 WA Yakima   school 5310110 39007   Yakima School District 531011002609 3023 Discovery Lab School   Regular School No Elementary 01 08 2017   grade_5 11 1 13   0 0     0   3   19 9 0   3   0   12       2.0 28 11 1 13   0 0     0   3   19 9 0   3 0 12     2 28
632561 WA Yakima   school 5310110 39007   Yakima School District 531011002609 3023 Discovery Lab School   Regular School No Elementary 01 08 2017   grade_6 17 0 12   0 0     0   2   13 18 0   4   0   13       0.0 31 17 0 12   0 0     0   2   13 18 0   4 0 13     0 31
632562 WA Yakima   school 5310110 39007   Yakima School District 531011002609 3023 Discovery Lab School   Regular School No Elementary 01 08 2017   grade_7 11 0 16   0 0     0   0   10 17 0   4   0   14       1.0 27 11 0 16   0 0     0   0   10 17 0   4 0 14     1 27
632563 WA Yakima   school 5310110 39007   Yakima School District 531011002609 3023 Discovery Lab School   Regular School No Elementary 01 08 2017   grade_8 7 0 16   1 0     0   1   14 11 0   4   0   14       2.0 25 7 0 16   1 0     0   1   14 11 0   4 0 14     2 25
632564 WA Yakima   school 5310110 39007   Yakima School District 531011002609 3023 Discovery Lab School   Regular School No Elementary 01 08 2017   pk_12_total 85 2 110   2 0     0   12   100 111 0   40   1   105       8.0 211 85 2 110   2 0     0   12   100 111 0   40 1 105     8 211
619043 WA Lewis   school 5301170 21302   Chehalis School District 530117000215 2442 R E Bennett Elementary (Closed after 2017-2018 school year)   Regular School No Elementary 02 03 2017   grade_2 144 1 37   0 0     0   11   106 87 0   16   12   124       1.0 193 144 1 37   0 0     0   11   106 87 0   16 12 124     1 193
619044 WA Lewis   school 5301170 21302   Chehalis School District 530117000215 2442 R E Bennett Elementary (Closed after 2017-2018 school year)   Regular School No Elementary 02 03 2017   grade_3 150 0 44   2 1     1   15   107 106 0   12   11   115       0.0 213 150 0 44   2 1     1   15   107 106 0   12 11 115     0 213
619045 WA Lewis   school 5301170 21302   Chehalis School District 530117000215 2442 R E Bennett Elementary (Closed after 2017-2018 school year)   Regular School No Elementary 02 03 2017   pk_12_total 294 1 81   2 1     1   26   213 193 0   28   23   239       1.0 406 294 1 81   2 1     1   26   213 193 0   28 23 239     1 406
621550 WA Pierce   school 5302880 27417   Fife School District 530288000466 2809 Endeavour Intermediate   Regular School No Elementary 02 05 2017   grade_2 60 4 43   1 9     12   24   79 74 0   32   3   87       1.0 153 60 4 43   1 9     12   24   79 74 0   32 3 87     1 153
621551 WA Pierce   school 5302880 27417   Fife School District 530288000466 2809 Endeavour Intermediate   Regular School No Elementary 02 05 2017   grade_3 69 9 28   1 11     5   15   58 80 0   23   4   81       1.0 138 69 9 28   1 11     5   15   58 80 0   23 4 81     1 138
621552 WA Pierce   school 5302880 27417   Fife School District 530288000466 2809 Endeavour Intermediate   Regular School No Elementary 02 05 2017   grade_4 54 9 31   2 14     11   21   72 70 0   20   3   79       3.0 142 54 9 31   2 14     11   21   72 70 0   20 3 79     3 142
621553 WA Pierce   school 5302880 27417   Fife School District 530288000466 2809 Endeavour Intermediate   Regular School No Elementary 02 05 2017   grade_5 67 5 33   1 9     5   26   75 71 0   13   4   80       0.0 146 67 5 33   1 9     5   26   75 71 0   13 4 80     0 146
621554 WA Pierce   school 5302880 27417   Fife School District 530288000466 2809 Endeavour Intermediate   Regular School No Elementary 02 05 2017   grade_7 0 1 0   0 0     0   0   1 0 0   0   1   1       0.0 1 0 1 0   0 0     0   0   1 0 0   0 1 1     0 1
621555 WA Pierce   school 5302880 27417   Fife School District 530288000466 2809 Endeavour Intermediate   Regular School No Elementary 02 05 2017   pk_12_total 250 28 135   5 43     33   86   285 295 0   88   15   328       5.0 580 250 28 135   5 43     33   86   285 295 0   88 15 328     5 580
621560 WA Pierce   school 5302880 27417   Fife School District 530288002875 4557 Hedden Elementary School   Regular School No Elementary 02 05 2017   grade_2 72 2 23   2 10     4   23   66 70 0   20   1   56       2.0 136 72 2 23   2 10     4   23   66 70 0   20 1 56     2 136
621561 WA Pierce   school 5302880 27417   Fife School District 530288002875 4557 Hedden Elementary School   Regular School No Elementary 02 05 2017   grade_3 67 6 27   0 9     4   23   75 61 0   23   1   57       1.0 136 67 6 27   0 9     4   23   75 61 0   23 1 57     1 136
621562 WA Pierce   school 5302880 27417   Fife School District 530288002875 4557 Hedden Elementary School   Regular School No Elementary 02 05 2017   grade_4 85 6 23   1 10     2   18   72 73 0   11   2   63       5.0 145 85 6 23   1 10     2   18   72 73 0   11 2 63     5 145
621563 WA Pierce   school 5302880 27417   Fife School District 530288002875 4557 Hedden Elementary School   Regular School No Elementary 02 05 2017   grade_5 76 9 26   0 9     3   20   67 76 0   7   2   50       1.0 143 76 9 26   0 9     3   20   67 76 0   7 2 50     1 143
621564 WA Pierce   school 5302880 27417   Fife School District 530288002875 4557 Hedden Elementary School   Regular School No Elementary 02 05 2017   grade_6 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
621565 WA Pierce   school 5302880 27417   Fife School District 530288002875 4557 Hedden Elementary School   Regular School No Elementary 02 05 2017   pk_12_total 301 23 99   3 38     13   84   281 280 0   61   6   227       9.0 561 301 23 99   3 38     13   84   281 280 0   61 6 227     9 561
632513 WA Cowlitz   school 5310050 8404   Woodland School District 531005003517 5408 Woodland Intermediate School (Closed after 2018-2019 school year)   Regular School No Elementary 02 04 2017   grade_2 87 2 36   0 5     0   3   74 59 0   26   2   66       0.0 133 87 2 36   0 5     0   3   74 59 0   26 2 66     0 133
632514 WA Cowlitz   school 5310050 8404   Woodland School District 531005003517 5408 Woodland Intermediate School (Closed after 2018-2019 school year)   Regular School No Elementary 02 04 2017   grade_3 115 1 44   2 0     0   1   80 83 0   22   4   78       0.0 163 115 1 44   2 0     0   1   80 83 0   22 4 78     0 163
632515 WA Cowlitz   school 5310050 8404   Woodland School District 531005003517 5408 Woodland Intermediate School (Closed after 2018-2019 school year)   Regular School No Elementary 02 04 2017   grade_4 133 0 48   3 2     0   4   98 92 0   22   11   104       3.0 190 133 0 48   3 2     0   4   98 92 0   22 11 104     3 190
632516 WA Cowlitz   school 5310050 8404   Woodland School District 531005003517 5408 Woodland Intermediate School (Closed after 2018-2019 school year)   Regular School No Elementary 02 04 2017   pk_12_total 335 3 128   5 7     0   8   252 234 0   70   17   248       3.0 486 335 3 128   5 7     0   8   252 234 0   70 17 248     3 486
617509 WA Clark   school 5300380 6119   Battle Ground School District 530038002782 1836 CAM Academy   Alternative School No Other 03 12 2017   grade_10 60 0 2   0 1     0   0   28 35 0   0   0   9       2.0 63 60 0 2   0 1     0   0   28 35 0   0 0 9     2 63
617510 WA Clark   school 5300380 6119   Battle Ground School District 530038002782 1836 CAM Academy   Alternative School No Other 03 12 2017   grade_11 39 0 5   0 3     0   4   23 28 0   1   0   7       3.0 51 39 0 5   0 3     0   4   23 28 0   1 0 7     3 51
617511 WA Clark   school 5300380 6119   Battle Ground School District 530038002782 1836 CAM Academy   Alternative School No Other 03 12 2017   grade_12 56 0 2   0 0     0   0   32 26 0   0   0   8       0.0 58 56 0 2   0 0     0   0   32 26 0   0 0 8     0 58
617512 WA Clark   school 5300380 6119   Battle Ground School District 530038002782 1836 CAM Academy   Alternative School No Other 03 12 2017   grade_3 37 0 3   0 3     0   5   22 26 0   3   0   8       2.0 48 37 0 3   0 3     0   5   22 26 0   3 0 8     2 48
617513 WA Clark   school 5300380 6119   Battle Ground School District 530038002782 1836 CAM Academy   Alternative School No Other 03 12 2017   grade_4 39 0 1   0 2     0   1   17 26 0   2   0   7       1.0 43 39 0 1   0 2     0   1   17 26 0   2 0 7     1 43
617514 WA Clark   school 5300380 6119   Battle Ground School District 530038002782 1836 CAM Academy   Alternative School No Other 03 12 2017   grade_5 46 0 3   0 3     0   4   28 28 0   1   0   7       1.0 56 46 0 3   0 3     0   4   28 28 0   1 0 7     1 56
617515 WA Clark   school 5300380 6119   Battle Ground School District 530038002782 1836 CAM Academy   Alternative School No Other 03 12 2017   grade_6 53 0 2   0 0     0   3   26 32 0   0   0   8       3.0 58 53 0 2   0 0     0   3   26 32 0   0 0 8     3 58
617516 WA Clark   school 5300380 6119   Battle Ground School District 530038002782 1836 CAM Academy   Alternative School No Other 03 12 2017   grade_7 53 0 0   0 1     0   4   28 30 0   0   0   9       1.0 58 53 0 0   0 1     0   4   28 30 0   0 0 9     1 58
617517 WA Clark   school 5300380 6119   Battle Ground School District 530038002782 1836 CAM Academy   Alternative School No Other 03 12 2017   grade_8 52 0 3   0 1     0   2   27 31 0   0   0   11       0.0 58 52 0 3   0 1     0   2   27 31 0   0 0 11     0 58
617518 WA Clark   school 5300380 6119   Battle Ground School District 530038002782 1836 CAM Academy   Alternative School No Other 03 12 2017   grade_9 47 0 5   0 0     0   3   28 27 0   0   0   13       1.0 55 47 0 5   0 0     0   3   28 27 0   0 0 13     1 55
617519 WA Clark   school 5300380 6119   Battle Ground School District 530038002782 1836 CAM Academy   Alternative School No Other 03 12 2017   pk_12_total 482 0 26   0 14     0   26   259 289 0   7   0   87       14.0 548 482 0 26   0 14     0   26   259 289 0   7 0 87     14 548
618232 WA Whatcom   school 5300570 37503   Blaine School District 530057000130 2713 Blaine Elementary School   Regular School No Elementary 03 05 2017   grade_3 115 2 11   1 10     1   12   75 77 0   6   4   71       4.0 152 115 2 11   1 10     1   12   75 77 0   6 4 71     4 152
618233 WA Whatcom   school 5300570 37503   Blaine School District 530057000130 2713 Blaine Elementary School   Regular School No Elementary 03 05 2017   grade_4 126 5 20   1 9     1   14   78 98 0   7   1   84       15.0 176 126 5 20   1 9     1   14   78 98 0   7 1 84     15 176
618234 WA Whatcom   school 5300570 37503   Blaine School District 530057000130 2713 Blaine Elementary School   Regular School No Elementary 03 05 2017   grade_5 124 3 22   1 4     0   9   93 70 0   1   6   79       10.0 163 124 3 22   1 4     0   9   93 70 0   1 6 79     10 163
618235 WA Whatcom   school 5300570 37503   Blaine School District 530057000130 2713 Blaine Elementary School   Regular School No Elementary 03 05 2017   pk_12_total 365 10 53   3 23     2   35   246 245 0   14   11   234       29.0 491 365 10 53   3 23     2   35   246 245 0   14 11 234     29 491
618589 WA Chelan   school 5300950 4228   Cascade School District 530095001934 2827 Alpine Lakes Elementary   Regular School No Elementary 03 05 2017   grade_3 74 0 31   0 0     0   2   50 57 0   26   2   58       9.0 107 74 0 31   0 0     0   2   50 57 0   26 2 58     9 107
618590 WA Chelan   school 5300950 4228   Cascade School District 530095001934 2827 Alpine Lakes Elementary   Regular School No Elementary 03 05 2017   grade_4 61 2 29   0 0     0   4   58 38 0   18   3   48       1.0 96 61 2 29   0 0     0   4   58 38 0   18 3 48     1 96
618591 WA Chelan   school 5300950 4228   Cascade School District 530095001934 2827 Alpine Lakes Elementary   Regular School No Elementary 03 05 2017   grade_5 54 1 31   1 0     0   2   47 42 0   18   2   47       3.0 89 54 1 31   1 0     0   2   47 42 0   18 2 47     3 89
618592 WA Chelan   school 5300950 4228   Cascade School District 530095001934 2827 Alpine Lakes Elementary   Regular School No Elementary 03 05 2017   pk_12_total 189 3 91   1 0     0   8   155 137 0   62   7   153       13.0 292 189 3 91   1 0     0   8   155 137 0   62 7 153     13 292
619165 WA Jefferson   school 5301290 16049   Chimacum School District 530129000232 2697 Chimacum Elementary School   Regular School No Elementary 03 05 2017   grade_3 56 0 2   1 1     0   10   41 29 0   0   2   45       2.0 70 56 0 2   1 1     0   10   41 29 0   0 2 45     2 70
619166 WA Jefferson   school 5301290 16049   Chimacum School District 530129000232 2697 Chimacum Elementary School   Regular School No Elementary 03 05 2017   grade_4 52 1 1   0 0     0   9   36 27 0   1   3   39       0.0 63 52 1 1   0 0     0   9   36 27 0   1 3 39     0 63
619167 WA Jefferson   school 5301290 16049   Chimacum School District 530129000232 2697 Chimacum Elementary School   Regular School No Elementary 03 05 2017   grade_5 55 0 7   0 0     0   6   40 28 0   0   4   41       1.0 68 55 0 7   0 0     0   6   40 28 0   0 4 41     1 68
619168 WA Jefferson   school 5301290 16049   Chimacum School District 530129000232 2697 Chimacum Elementary School   Regular School No Elementary 03 05 2017   pk_12_total 163 1 10   1 1     0   25   117 84 0   1   9   125       3.0 201 163 1 10   1 1     0   25   117 84 0   1 9 125     3 201
619592 WA Stevens   school 5301630 33115   Colville School District 530163001898 4180 Fort Colville Elementary   Regular School No Elementary 03 05 2017   grade_3 133 1 11   3 0     0   6   75 79 0   3   12   91       0.0 154 133 1 11   3 0     0   6   75 79 0   3 12 91     0 154
619593 WA Stevens   school 5301630 33115   Colville School District 530163001898 4180 Fort Colville Elementary   Regular School No Elementary 03 05 2017   grade_4 112 0 8   4 1     0   3   63 65 0   1   4   64       1.0 128 112 0 8   4 1     0   3   63 65 0   1 4 64     1 128
619594 WA Stevens   school 5301630 33115   Colville School District 530163001898 4180 Fort Colville Elementary   Regular School No Elementary 03 05 2017   grade_5 104 1 6   0 2     0   1   54 60 0   2   5   63       1.0 114 104 1 6   0 2     0   1   54 60 0   2 5 63     1 114
619595 WA Stevens   school 5301630 33115   Colville School District 530163001898 4180 Fort Colville Elementary   Regular School No Elementary 03 05 2017   pk_12_total 349 2 25   7 3     0   10   192 204 0   6   21   218       2.0 396 349 2 25   7 3     0   10   192 204 0   6 21 218     2 396
619826 WA Spokane   school 5302070 32414   Deer Park School District 530207000306 2173 Arcadia Elementary   Regular School No Elementary 03 05 2017   grade_3 138 2 7   11 0     0   0   74 84 0   0   10   98       7.0 158 138 2 7   11 0     0   0   74 84 0   0 10 98     7 158
619827 WA Spokane   school 5302070 32414   Deer Park School District 530207000306 2173 Arcadia Elementary   Regular School No Elementary 03 05 2017   grade_4 138 3 11   6 0     0   2   98 62 0   2   8   95       13.0 160 138 3 11   6 0     0   2   98 62 0   2 8 95     13 160
619828 WA Spokane   school 5302070 32414   Deer Park School District 530207000306 2173 Arcadia Elementary   Regular School No Elementary 03 05 2017   grade_5 124 0 10   1 0     0   0   75 60 0   1   3   84       10.0 135 124 0 10   1 0     0   0   75 60 0   1 3 84     10 135
619829 WA Spokane   school 5302070 32414   Deer Park School District 530207000306 2173 Arcadia Elementary   Regular School No Elementary 03 05 2017   pk_12_total 400 5 28   18 0     0   2   247 206 0   3   21   277       30.0 453 400 5 28   18 0     0   2   247 206 0   3 21 277     30 453
620658 WA Clark   school 5300005 6801   ESD 112 acting as a school district 530000503407 5290 Clark County Juvenile Detention School   Regular School No Other 03 12 2017   grade_10 4 2 0   0 0     0   0   6 0 0   0   0   0       0.0 6 4 2 0   0 0     0   0   6 0 0   0 0 0     0 6
620659 WA Clark   school 5300005 6801   ESD 112 acting as a school district 530000503407 5290 Clark County Juvenile Detention School   Regular School No Other 03 12 2017   grade_11 4 1 0   0 0     0   1   5 1 0   0   0   0       0.0 6 4 1 0   0 0     0   1   5 1 0   0 0 0     0 6
620660 WA Clark   school 5300005 6801   ESD 112 acting as a school district 530000503407 5290 Clark County Juvenile Detention School   Regular School No Other 03 12 2017   grade_12 5 1 1   0 0     0   0   5 2 0   0   0   0       0.0 7 5 1 1   0 0     0   0   5 2 0   0 0 0     0 7

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