Data source: Big Local News · About: Big Local

1,265 rows where grade = "grade_2", state = "WA" and year = 2020 sorted by ccd_school_high_grade

View and edit SQL

year

  • 2020 · 1,265

grade

  • grade_2 · 1,265
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
2572465 WA Pierce   school   27901   Chief Leschi Schools   5549 Chief Leschi Schools             2020   grade_2 0 0 10   32 0     0   2   21 23 0   0   0   27       0.0 44 0 0 10   32 0     0   2   21 23 0   0 0 27     0 44
2577129 WA Whatcom   school   37903   Lummi Tribal Agency   5373 Lummi Nation School             2020   grade_2 0 0 1   24 0     0   1   17 9 0   0   0   21       0.0 26 0 0 1   24 0     0   1   17 9 0   0 0 21     0 26
2578126 WA King   school   17903   Muckleshoot Indian Tribe   1986 Muckleshoot Tribal School             2020   grade_2 1 0 2   43 0     0   5   20 31 0   0   0   36       0.0 51 1 0 2   43 0     0   5   20 31 0   0 0 36     0 51
2579420 WA Okanogan   school   24019   Omak School District   4278 Paschal Sherman             2020   grade_2 0 0 1   11 0     0   0   4 8 0   0   0   12       0.0 12 0 0 1   11 0     0   0   4 8 0   0 0 12     0 12
2580493 WA Clallam   school   5903   Quileute Tribal School District   5430 Quileute Tribal School             2020   grade_2 2 0 3   2 0     0   0   6 1 0   0   0   6       0.0 7 2 0 3   2 0     0   0   6 1 0   0 0 6     0 7
2584863 WA Thurston   school   34901   WA HE LUT Indian School Agency   5496 Wa He Lut Indian School             2020   grade_2 0 1 2   8 0     0   3   9 5 0   0   3   11       0.0 14 0 1 2   8 0     0   3   9 5 0   0 3 11     0 14
2573847 WA Grant   school 5302610 13165   Ephrata School District 530261002934 4229 Beezley Springs Elementary   Special Education School No Elementary PK 01 2020   grade_2 1 0 1   0 0     0   0   1 1 0   0   0   0       0.0 2 1 0 1   0 0     0   0   1 1 0   0 0 0     0 2
2574798 WA Pierce   school 5302880 27417   Fife School District 530288000464 2878 Discovery Primary School   Regular School No Elementary PK 01 2020   grade_2 1 0 2   0 0     0   0   3 0 0   0   0   2       0.0 3 1 0 2   0 0     0   0   3 0 0   0 0 2     0 3
2571516 WA Whatcom   school 5300570 37503   Blaine School District 530057001741 4476 Blaine Primary School   Regular School No Elementary PK 02 2020   grade_2 111 3 23   1 5     1   12   86 70 0   14   3   86       8.0 156 111 3 23   1 5     1   12   86 70 0   14 3 86     8 156
2571890 WA Chelan   school 5300950 4228   Cascade School District 530095001933 2760 Peshastin Dryden Elementary   Regular School No Elementary PK 02 2020   grade_2 54 0 40   0 0     0   1   45 50 0   28   1   51       1.0 95 54 0 40   0 0     0   1   45 50 0   28 1 51     1 95
2572327 WA Lewis   school 5301170 21302   Chehalis School District 530117003654 5509 James W Lintott Elementary School   Regular School No Elementary PK 02 2020   grade_2 167 3 42   2 1     0   10   112 113 0   8   4   121       0.0 225 167 3 42   2 1     0   10   112 113 0   8 4 121     0 225
2572476 WA Jefferson   school 5301290 16049   Chimacum School District 530129002790 4552 Chimacum Creek Primary School   Regular School No Elementary PK 02 2020   grade_2 50 0 5   0 1     0   1   32 25 0   2   0   33       0.0 57 50 0 5   0 1     0   1   32 25 0   2 0 33     0 57
2572888 WA Stevens   school 5301630 33115   Colville School District 530163000284 2957 Hofstetter Elementary   Regular School No Elementary KG 02 2020   grade_2 115 0 7   0 1     0   6   66 63 0   1   4   81       0.0 129 115 0 7   0 1     0   6   66 63 0   1 4 81     0 129
2573122 WA Spokane   school 5302070 32414   Deer Park School District 530207000307 2430 Deer Park Elementary   Regular School No Elementary KG 02 2020   grade_2 130 2 12   8 0     0   0   64 88 0   5   5   83       2.0 152 130 2 12   8 0     0   0   64 88 0   5 5 83     2 152
2575091 WA Snohomish   school 5303210 31332   Granite Falls School District 530321002303 4330 Mountain Way Elementary   Regular School No Elementary PK 02 2020   grade_2 99 0 9   2 0     1   5   65 51 0   2   7   50       4.0 116 99 0 9   2 0     1   5   65 51 0   2 7 50     4 116
2576326 WA Benton   school 5304020 3052   Kiona-Benton City School District 530402000641 2759 Kiona-Benton City Primary School   Regular School No Elementary PK 02 2020   grade_2 57 0 59   0 0     0   2   65 53 0   43   0   0       0.0 118 57 0 59   0 0     0   2   65 53 0   43 0 0     0 118
2577798 WA Grays Harbor   school 5305160 14066   Montesano School District 530516000779 3661 Beacon Avenue Elementary School   Regular School No Elementary PK 02 2020   grade_2 81 0 10   1 3     1   7   55 48 0   5   1   36       2.0 103 81 0 10   1 3     1   7   55 48 0   5 1 36     2 103
2579159 WA Pacific   school 5306060 25101   Ocean Beach School District 530606000912 3531 Long Beach Elementary School   Regular School No Elementary KG 02 2020   grade_2 51 0 17   0 1     0   2   43 28 0   3   14   59       0.0 71 51 0 17   0 1     0   2   43 28 0   3 14 59     0 71
2579405 WA Okanogan   school 5306220 24019   Omak School District 530622000939 2999 N Omak Elementary   Regular School No Elementary PK 02 2020   grade_2 62 1 44   26 0     0   10   77 66 0   18   2   117       0.0 143 62 1 44   26 0     0   10   77 66 0   18 2 117     0 143
2579834 WA Franklin   school 5306570 11001   Pasco School District 530657002621 4526 Whittier Elementary   Regular School No Elementary KG 02 2020   grade_2 9 2 176   0 4     0   1   104 88 0   153   2   178       1.0 192 9 2 176   0 4     0   1   104 88 0   153 2 178     1 192
2580124 WA Benton   school 5306900 3116   Prosser School District 530690001014 2195 Keene-Riverview Elementary   Regular School No Elementary PK 02 2020   grade_2 40 0 94   2 3     0   2   71 70 0   51   8   108       2.0 141 40 0 94   2 3     0   2   71 70 0   51 8 108     2 141
2581166 WA Thurston   school 5307470 34401   Rochester School District 530747001117 2527 Rochester Primary School   Regular School No Elementary PK 02 2020   grade_2 111 0 37   4 0     0   16   94 74 0   26   5   97       15.0 168 111 0 37   4 0     0   16   94 74 0   26 5 97     15 168
2582082 WA Yakima   school 5307770 39119   Selah School District 530777003513 5383 John Campbell Primary School   Regular School No Elementary KG 02 2020   grade_2 178 1 86   1 0     0   7   156 117 0   42   4   152       4.0 273 178 1 86   1 0     0   7   156 117 0   42 4 152     4 273
2582401 WA Snohomish   school 5308020 31201   Snohomish School District 530802001323 2446 Central Elementary   Regular School No Elementary PK 02 2020   grade_2 35 1 18   0 0     0   4   26 32 0   10   0   25       4.0 58 35 1 18   0 0     0   4   26 32 0   10 0 25     4 58
2583447 WA Skamania   school 5308520 30303   Stevenson-Carson School District 530852001435 2682 Stevenson Elementary   Regular School No Elementary KG 02 2020   grade_2 51 0 6   4 0     1   6   36 32 0   4   4   33       3.0 68 51 0 6   4 0     1   6   36 32 0   4 4 33     3 68
2584166 WA Thurston   school 5308820 34402   Tenino School District 530882001524 2457 Parkside Elementary   Regular School No Elementary PK 02 2020   grade_2 64 1 12   1 1     0   7   40 46 0   0   1   48       0.0 86 64 1 12   1 1     0   7   40 46 0   0 1 48     0 86
2585018 WA Yakima   school 5309480 39207   Wapato School District 530948003637 5544 Camas Elementary   Regular School No Elementary PK 02 2020   grade_2 3 0 95   30 3     0   1   70 62 0   96   20   123       0.0 132 3 0 95   30 3     0   1   70 62 0   96 20 123     0 132
2585033 WA Yakima   school 5309480 39207   Wapato School District 530948003641 5543 Simcoe Elementary School   Regular School No Elementary KG 02 2020   grade_2 1 0 77   20 0     0   4   54 48 0   65   13   98       1.0 102 1 0 77   20 0     0   4   54 48 0   65 13 98     1 102
2571525 WA Whatcom   school 5300570 37503   Blaine School District 530057001740 4459 Point Roberts Primary   Regular School No Elementary KG 03 2020   grade_2 1 0 1   0 0     0   0   2 0 0   0   0   0       0.0 2 1 0 1   0 0     0   0   2 0 0   0 0 0     0 2
2571588 WA Kitsap   school 5300660 18100   Bremerton School District 530066000143 3171 Naval Avenue Elementary School   Regular School No Elementary PK 03 2020   grade_2 28 4 33   0 0     3   12   33 47 0   24   0   55       3.0 80 28 4 33   0 0     3   12   33 47 0   24 0 55     3 80
2572140 WA Spokane   school 5301110 32356   Central Valley School District 530111003596 5507 Liberty Creek Elementary School   Regular School No Elementary KG 03 2020   grade_2 162 3 2   2 0     0   5   80 94 0   5   1   36       1.0 174 162 3 2   2 0     0   5   80 94 0   5 1 36     1 174
2573158 WA Pierce   school 5302130 27343   Dieringer School District 530213000310 3683 Lake Tapps Elementary   Regular School No Elementary 01 03 2020   grade_2 104 4 17   0 12     0   18   82 73 0   19   4   31       3.0 155 104 4 17   0 12     0   18   82 73 0   19 4 31     3 155
2575162 WA Yakima   school 5303510 39203   Highland School District 530351000518 3072 Marcus Whitman-Cowiche Elementary   Regular School No Elementary PK 03 2020   grade_2 17 0 63   0 0     0   0   47 33 0   43   2   64       3.0 80 17 0 63   0 0     0   0   47 33 0   43 2 64     3 80
2575448 WA Grays Harbor   school 5303660 14028   Hoquiam School District 530366000566 3621 Lincoln Elementary   Regular School No Elementary PK 03 2020   grade_2 67 2 23   4 0     0   15   69 42 0   13   4   85       3.0 111 67 2 23   4 0     0   15   69 42 0   13 4 85     3 111
2579505 WA San Juan   school 5306300 28137   Orcas Island School District 530630003696 5555 Orcas Island Montessori Public   Regular School No Elementary 01 03 2020   grade_2 5 0 1   0 1     0   0   5 2 0   2   0   3       0.0 7 5 0 1   0 1     0   0   5 2 0   2 0 3     0 7
2579572 WA Pierce   school 5306450 27344   Orting School District 530645000952 2360 Orting Primary School   Regular School No Elementary PK 03 2020   grade_2 95 1 17   0 1     0   13   68 59 0   7   2   41       5.0 127 95 1 17   0 1     0   13   68 59 0   7 2 41     5 127
2580517 WA Clallam   school 5307020 5402   Quillayute Valley School District 530702001048 3737 Forks Elementary School   Regular School No Elementary PK 03 2020   grade_2 36 0 32   3 0     0   6   35 42 0   24   2   58       2.0 77 36 0 32   3 0     0   6   35 42 0   24 2 58     2 77
2581194 WA Grant   school 5307620 13160   Royal School District 530762001122 3090 Red Rock Elementary   Regular School No Elementary PK 03 2020   grade_2 21 0 112   0 0     0   0   60 73 0   95   8   102       1.0 133 21 0 112   0 0     0   0   60 73 0   95 8 102     1 133
2583390 WA Pierce   school 5308460 27001   Steilacoom Hist. School District 530846001430 2040 Anderson Island Elementary   Regular School No Elementary PK 03 2020   grade_2 2 0 0   0 0     0   1   1 2 0   0   0   2       0.0 3 2 0 0   0 0     0   1   1 2 0   0 0 2     0 3
2583398 WA Pierce   school 5308460 27001   Steilacoom Hist. School District 530846001429 3446 Cherrydale Elementary   Regular School No Elementary KG 03 2020   grade_2 46 8 18   1 3     1   21   49 49 0   2   1   42       2.0 98 46 8 18   1 3     1   21   49 49 0   2 1 42     2 98
2583403 WA Pierce   school 5308460 27001   Steilacoom Hist. School District 530846002879 4562 Chloe Clark Elementary   Regular School No Elementary KG 03 2020   grade_2 61 11 38   1 15     2   28   83 73 0   9   0   34       1.0 156 61 11 38   1 15     2   28   83 73 0   9 0 34     1 156
2585490 WA Klickitat   school 5309810 20405   White Salmon Valley School District 530981001665 2997 Hulan L Whitson Elem   Regular School No Elementary KG 03 2020   grade_2 68 0 29   0 0     0   2   50 49 0   19   1   43       0.0 99 68 0 29   0 0     0   2   50 49 0   19 1 43     0 99
2585887 WA Yakima   school 5310170 39205   Zillah School District 531017001718 2783 Hilton Elementary School   Regular School No Elementary PK 03 2020   grade_2 30 0 53   4 0     0   4   39 52 0   22   6   62       2.0 91 30 0 53   4 0     0   4   39 52 0   22 6 62     2 91
2570709 WA Kitsap   school 5300330 18303   Bainbridge Island School District 530033000045 3552 Capt Johnston Blakely Elem Sch   Regular School No Elementary PK 04 2020   grade_2 57 0 2   0 1     0   6   37 29 0   2   0   4       9.0 66 57 0 2   0 1     0   6   37 29 0   2 0 4     9 66
2570716 WA Kitsap   school 5300330 18303   Bainbridge Island School District 530033000044 3043 Capt. Charles Wilkes Elem School   Regular School No Elementary PK 04 2020   grade_2 54 0 3   1 0     0   2   29 31 0   0   0   3       4.0 60 54 0 3   1 0     0   2   29 31 0   0 0 3     4 60
2570748 WA Kitsap   school 5300330 18303   Bainbridge Island School District 530033000047 4062 Ordway Elementary   Regular School No Elementary KG 04 2020   grade_2 54 0 10   0 1     0   16   34 47 0   5   0   5       11.0 81 54 0 10   0 1     0   16   34 47 0   5 0 5     11 81
2570786 WA Clark   school 5300380 6119   Battle Ground School District 530038002278 4352 Captain Strong   Regular School No Elementary PK 04 2020   grade_2 88 0 13   1 2     0   10   46 68 0   10   1   40       1.0 114 88 0 13   1 2     0   10   46 68 0   10 1 40     1 114
2570804 WA Clark   school 5300380 6119   Battle Ground School District 530038003194 5090 Daybreak Primary   Regular School No Elementary PK 04 2020   grade_2 82 2 14   0 1     1   7   56 51 0   13   3   47       0.0 107 82 2 14   0 1     1   7   56 51 0   13 3 47     0 107
2570816 WA Clark   school 5300380 6119   Battle Ground School District 530038000051 3018 Glenwood Heights Primary   Regular School No Elementary PK 04 2020   grade_2 74 2 18   2 5     0   10   52 59 0   28   3   52       2.0 111 74 2 18   2 5     0   10   52 59 0   28 3 52     2 111
2570842 WA Clark   school 5300380 6119   Battle Ground School District 530038003681 4144 Maple Grove Primary   Regular School No Elementary KG 04 2020   grade_2 79 2 12   1 8     0   6   50 58 0   16   2   42       1.0 108 79 2 12   1 8     0   6   50 58 0   16 2 42     1 108
2570860 WA Clark   school 5300380 6119   Battle Ground School District 530038000055 3996 Pleasant Valley Primary   Regular School No Elementary PK 04 2020   grade_2 77 3 9   2 2     0   6   52 47 0   21   1   34       4.0 99 77 3 9   2 2     0   6   52 47 0   21 1 34     4 99
2570884 WA Clark   school 5300380 6119   Battle Ground School District 530038003228 5132 Tukes Valley Primary   Regular School No Elementary PK 04 2020   grade_2 95 0 9   0 0     0   5   58 51 0   3   0   31       2.0 109 95 0 9   0 0     0   5   58 51 0   3 0 31     2 109
2570891 WA Clark   school 5300380 6119   Battle Ground School District 530038000056 2910 Yacolt Primary   Regular School No Elementary PK 04 2020   grade_2 138 1 8   0 0     0   4   70 81 0   4   1   48       3.0 151 138 1 8   0 0     0   4   70 81 0   4 1 48     3 151
2571864 WA Chelan   school 5300950 4228   Cascade School District 530095002937 4566 Beaver Valley School   Regular School No Elementary KG 04 2020   grade_2 3 0 1   0 0     0   0   1 3 0   0   0   1       0.0 4 3 0 1   0 0     0   0   1 3 0   0 0 1     0 4
2571905 WA Chelan   school 5300960 4222   CASHMERE SCHOOL DISTRICT 530096000170 2787 VALE ELEMENTARY SCHOOL   Regular School No Elementary PK 04 2020   grade_2 65 0 51   0 1     0   2   68 51 0   37   4   60       3.0 119 65 0 51   0 1     0   2   68 51 0   37 4 60     3 119
2573291 WA Douglas   school 5302310 9206   Eastmont School District 530231000317 3659 Cascade Elementary   Regular School No Elementary KG 04 2020   grade_2 58 0 35   0 1     0   5   44 55 0   21   1   43       2.0 99 58 0 35   0 1     0   5   44 55 0   21 1 43     2 99
2573313 WA Douglas   school 5302310 9206   Eastmont School District 530231000319 2966 Grant Elementary School   Regular School No Elementary KG 04 2020   grade_2 44 0 42   0 1     0   4   44 47 0   25   0   45       1.0 91 44 0 42   0 1     0   4   44 47 0   25 0 45     1 91
2573319 WA Douglas   school 5302310 9206   Eastmont School District 530231000320 3212 Kenroy Elementary   Regular School No Elementary KG 04 2020   grade_2 39 0 36   0 0     0   4   38 41 0   25   2   49       0.0 79 39 0 36   0 0     0   4   38 41 0   25 2 49     0 79
2573325 WA Douglas   school 5302310 9206   Eastmont School District 530231000321 3083 Lee Elementary   Regular School No Elementary KG 04 2020   grade_2 40 0 48   0 0     0   4   45 47 0   32   0   74       7.0 92 40 0 48   0 0     0   4   45 47 0   32 0 74     7 92
2573331 WA Douglas   school 5302310 9206   Eastmont School District 530231000322 2563 Rock Island Elementary   Regular School No Elementary KG 04 2020   grade_2 14 0 29   0 0     0   0   20 23 0   21   0   31       0.0 43 14 0 29   0 0     0   0   20 23 0   21 0 31     0 43
2573855 WA Grant   school 5302610 13165   Ephrata School District 530261000384 2793 Columbia Ridge Elementary   Regular School No Elementary KG 04 2020   grade_2 52 1 24   0 0     0   0   41 36 0   11   0   46       2.0 77 52 1 24   0 0     0   0   41 36 0   11 0 46     2 77
2573873 WA Grant   school 5302610 13165   Ephrata School District 530261000388 3092 Grant Elementary   Regular School No Elementary PK 04 2020   grade_2 55 0 32   0 0     0   3   49 41 0   15   1   59       0.0 90 55 0 32   0 0     0   3   49 41 0   15 1 59     0 90
2574980 WA Klickitat   school 5303090 20404   Goldendale School District 530309000492 2677 Goldendale Primary School   Regular School No Elementary KG 04 2020   grade_2 62 0 10   1 0     0   4   40 37 0   2   0   48       2.0 77 62 0 10   1 0     0   4   40 37 0   2 0 48     2 77
2575060 WA Yakima   school 5303180 39204   Granger School District 530318002780 4535 Roosevelt Elementary   Regular School No Elementary PK 04 2020   grade_2 1 1 8   0 0     0   0   5 5 0   6   0   9       0.0 10 1 1 8   0 0     0   0   5 5 0   6 0 9     0 10
2576300 WA Stevens   school 5303990 33212   Kettle Falls School District 530399000637 2385 Kettle Falls Elementary School   Regular School No Elementary KG 04 2020   grade_2 42 0 0   0 0     0   8   23 27 0   1   1   33       2.0 50 42 0 0   0 0     0   8   23 27 0   1 1 33     2 50
2578274 WA Yakima   school 5305460 39003   Naches Valley School District 530546003559 5451 Naches Valley Elementary School   Regular School No Elementary KG 04 2020   grade_2 62 1 19   0 0     0   5   45 42 0   13   0   50       3.0 87 62 1 19   0 0     0   5   45 42 0   13 0 50     3 87
2578355 WA Pend Oreille   school 5305610 26056   Newport School District 530561002462 4478 Stratton Elementary   Regular School No Elementary PK 04 2020   grade_2 64 0 3   0 0     0   5   35 37 0   0   5   54       3.0 72 64 0 3   0 0     0   5   35 37 0   0 5 54     3 72
2579047 WA Island   school 5305940 15201   Oak Harbor School District 530594000898 3477 Broadview Elementary   Regular School No Elementary KG 04 2020   grade_2 51 3 13   0 5     2   10   37 47 0   5   3   35       4.0 84 51 3 13   0 5     2   10   37 47 0   5 3 35     4 84
2579053 WA Island   school 5305940 15201   Oak Harbor School District 530594000900 3377 Crescent Harbor Elem   Regular School No Elementary KG 04 2020   grade_2 52 5 16   4 1     0   17   52 43 0   5   5   62       1.0 95 52 5 16   4 1     0   17   52 43 0   5 5 62     1 95
2579060 WA Island   school 5305940 15201   Oak Harbor School District 530594002264 4328 Hillcrest Elementary   Regular School No Elementary KG 04 2020   grade_2 69 3 17   1 6     0   23   59 60 0   5   3   36       2.0 119 69 3 17   1 6     0   23   59 60 0   5 3 36     2 119
2579086 WA Island   school 5305940 15201   Oak Harbor School District 530594000902 2696 Oak Harbor Elementary   Regular School No Elementary PK 04 2020   grade_2 44 3 14   0 3     1   9   34 40 0   9   2   31       0.0 74 44 3 14   0 3     1   9   34 40 0   9 2 31     0 74
2579100 WA Island   school 5305940 15201   Oak Harbor School District 530594000905 3566 Olympic View Elem   Regular School No Elementary KG 04 2020   grade_2 46 3 23   0 3     1   12   50 38 0   8   0   43       2.0 88 46 3 23   0 3     1   12   50 38 0   8 0 43     2 88
2581015 WA Clark   school 5307350 6122   Ridgefield School District 530735001106 3321 South Ridge Elementary   Regular School No Elementary KG 04 2020   grade_2 96 1 19   1 1     0   6   58 66 0   8   4   22       0.0 124 96 1 19   1 1     0   6   58 66 0   8 4 22     0 124
2581025 WA Clark   school 5307350 6122   Ridgefield School District 530735001107 3786 Union Ridge Elementary   Regular School No Elementary KG 04 2020   grade_2 123 0 21   0 3     0   13   86 74 0   8   0   31       6.0 160 123 0 21   0 3     0   13   86 74 0   8 0 31     6 160
2581052 WA Spokane   school 5307440 32416   Riverside School District 530744001112 2525 Chattaroy Elementary   Regular School No Elementary PK 04 2020   grade_2 34 0 3   1 0     0   1   19 20 0   1   2   23       1.0 39 34 0 3   1 0     0   1   19 20 0   1 2 23     1 39
2582185 WA Mason   school 5307900 23309   Shelton School District 530790001292 3291 Bordeaux Elementary School   Regular School No Elementary KG 04 2020   grade_2 60 0 24   2 0     0   7   43 50 0   11   5   77       4.0 93 60 0 24   2 0     0   7   43 50 0   11 5 77     4 93
2582198 WA Mason   school 5307900 23309   Shelton School District 530790001293 2745 Evergreen Elementary School   Regular School No Elementary PK 04 2020   grade_2 23 0 67   0 0     0   3   53 40 0   53   11   81       4.0 93 23 0 67   0 0     0   3   53 40 0   53 11 81     4 93
2582206 WA Mason   school 5307900 23309   Shelton School District 530790001294 3292 Mountain View Elementary   Regular School No Elementary PK 04 2020   grade_2 63 0 28   1 1     1   8   43 59 0   18   6   68       4.0 102 63 0 28   1 1     1   8   43 59 0   18 6 68     4 102
2583266 WA Lincoln   school 5308280 22008   Sprague School District 530828001418 3050 Sprague Elementary   Regular School No Elementary PK 04 2020   grade_2 7 0 0   0 0     0   0   5 2 0   0   0   4       0.0 7 7 0 0   0 0     0   0   5 2 0   0 0 4     0 7
2584346 WA Klickitat   school 5309060 20400   Trout Lake School District 530906002657 3062 Trout Lake Elementary   Regular School No Elementary KG 04 2020   grade_2 13 0 0   0 0     0   0   10 3 0   0   0   0       0.0 13 13 0 0   0 0     0   0   10 3 0   0 0 0     0 13
2584496 WA Pierce   school 5309180 27083   University Place School District 530918001552 3792 Chambers Elementary   Regular School No Elementary KG 04 2020   grade_2 41 15 20   0 6     3   13   53 45 0   6   4   51       2.0 98 41 15 20   0 6     3   13   53 45 0   6 4 51     2 98
2584515 WA Pierce   school 5309180 27083   University Place School District 530918001179 4447 Evergreen Primary   Regular School No Elementary PK 04 2020   grade_2 53 8 19   0 11     3   21   63 52 0   14   5   49       4.0 115 53 8 19   0 11     3   21   63 52 0   14 5 49     4 115
2584526 WA Pierce   school 5309180 27083   University Place School District 530918001551 3601 Sunset Primary   Regular School No Elementary PK 04 2020   grade_2 56 8 12   0 5     1   18   54 46 0   4   0   33       3.0 100 56 8 12   0 5     1   18   54 46 0   4 0 33     3 100
2584533 WA Pierce   school 5309180 27083   University Place School District 530918001553 2223 University Place Primary   Regular School No Elementary PK 04 2020   grade_2 52 9 23   1 9     2   8   57 47 0   11   0   45       2.0 104 52 9 23   1 9     2   8   57 47 0   11 0 45     2 104
2585348 WA Yakima   school 5309720 39208   West Valley School District (Yakima) 530972001649 2822 Ahtanum Valley Elementary   Regular School No Elementary KG 04 2020   grade_2 30 0 20   2 0     0   1   20 33 0   11   0   36       1.0 53 30 0 20   2 0     0   1   20 33 0   11 0 36     1 53
2585354 WA Yakima   school 5309720 39208   West Valley School District (Yakima) 530972001650 3699 Apple Valley Elementary   Regular School No Elementary KG 04 2020   grade_2 43 0 20   0 2     1   3   32 37 0   4   0   25       2.0 69 43 0 20   0 2     1   3   32 37 0   4 0 25     2 69
2585361 WA Yakima   school 5309720 39208   West Valley School District (Yakima) 530972001238 4448 Cottonwood Elementary School   Regular School No Elementary KG 04 2020   grade_2 59 2 32   0 6     0   1   52 48 0   10   2   33       6.0 100 59 2 32   0 6     0   1   52 48 0   10 2 33     6 100
2585368 WA Yakima   school 5309720 39208   West Valley School District (Yakima) 530972001651 2758 Mountainview Elementary   Regular School No Elementary KG 04 2020   grade_2 25 0 12   0 0     0   0   18 19 0   5   0   20       0.0 37 25 0 12   0 0     0   0   18 19 0   5 0 20     0 37
2585375 WA Yakima   school 5309720 39208   West Valley School District (Yakima) 530972001652 3207 Summitview Elementary   Regular School No Elementary KG 04 2020   grade_2 42 1 25   0 0     0   4   31 41 0   7   1   34       0.0 72 42 1 25   0 0     0   4   31 41 0   7 1 34     0 72
2585411 WA Yakima   school 5309720 39208   West Valley School District (Yakima) 530972001655 2505 Wide Hollow Elementary   Regular School No Elementary KG 04 2020   grade_2 35 1 24   1 0     0   2   34 29 0   13   4   47       0.0 63 35 1 24   1 0     0   2   34 29 0   13 4 47     0 63
2585606 WA Cowlitz   school 5310050 8404   Woodland School District 531005003711 5599 Columbia Elementary School   Regular School No Elementary PK 04 2020   grade_2 40 0 29   0 0     0   0   38 31 0   18   4   44       2.0 69 40 0 29   0 0     0   0   38 31 0   18 4 44     2 69
2585623 WA Cowlitz   school 5310050 8404   Woodland School District 531005003715 5600 North Fork Elementary School   Regular School No Elementary KG 04 2020   grade_2 80 0 14   0 0     0   7   56 45 0   7   4   41       3.0 101 80 0 14   0 0     0   7   56 45 0   7 4 41     3 101
2585645 WA Cowlitz   school 5310050 8404   Woodland School District 531005001684 3513 Yale Elementary   Regular School No Elementary KG 04 2020   grade_2 7 0 0   0 0     0   1   2 6 0   0   0   4       0.0 8 7 0 0   0 0     0   1   2 6 0   0 0 4     0 8
2570304 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000001 2834 A J West Elementary   Regular School No Elementary PK 05 2020   grade_2 21 1 26   0 0     0   3   27 24 0   9   7   41       2.0 51 21 1 26   0 0     0   3   27 24 0   9 7 41     2 51
2570313 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000005 3216 Central Park Elementary   Regular School No Elementary KG 05 2020   grade_2 15 0 3   0 2     0   7   17 10 0   0   0   15       1.0 27 15 0 3   0 2     0   7   17 10 0   0 0 15     1 27
2570348 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000008 2449 McDermoth Elementary   Regular School No Elementary KG 05 2020   grade_2 31 0 15   0 1     0   7   21 33 0   9   3   43       2.0 54 31 0 15   0 1     0   7   21 33 0   9 3 43     2 54
2570361 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000010 2763 Robert Gray Elementary   Regular School No Elementary PK 05 2020   grade_2 18 0 15   0 0     0   5   21 17 0   9   1   32       0.0 38 18 0 15   0 0     0   5   21 17 0   9 1 32     0 38
2570368 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000011 2971 Stevens Elementary School   Regular School No Elementary PK 05 2020   grade_2 24 2 14   0 1     0   16   30 27 0   12   5   53       1.0 57 24 2 14   0 1     0   16   30 27 0   12 5 53     1 57
2570379 WA Lewis   school 5300060 21226   Adna School District 530006000012 2227 Adna Elementary School   Regular School No Elementary PK 05 2020   grade_2 36 1 2   1 0     0   1   19 21 1   0   1   8       0.0 41 36 1 2   1 0     0   1   19 21 1   0 1 8     0 41
2570420 WA Skagit   school 5300150 29103   Anacortes School District 530015000017 3182 Fidalgo Elementary   Regular School No Elementary KG 05 2020   grade_2 36 1 4   0 0     0   3   26 18 0   0   2   11       1.0 44 36 1 4   0 0     0   3   26 18 0   0 2 11     1 44

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