Data source: Big Local News · About: Big Local

1,263 rows where grade = "grade_1", state = "WA" and year = 2020

View and edit SQL

year

  • 2020 · 1,163

grade

  • grade_1 · 1,163
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
2571524 WA Whatcom   school 5300570 37503   Blaine School District 530057001740 4459 Point Roberts Primary   Regular School No Elementary KG 03 2020   grade_1 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
2571529 WA Lewis   school 5300630 21234   Boistfort School District 530063000133 2516 Boistfort Elem   Regular School No Elementary PK 08 2020   grade_1 10 0 0   1 0     0   0   6 5 0   0   1   5       0.0 11 10 0 0   1 0     0   0   6 5 0   0 1 5     0 11
2571540 WA Kitsap   school 5300660 18100   Bremerton School District 530066000135 3641 Armin Jahr Elementary   Regular School No Elementary KG 05 2020   grade_1 26 3 32   0 3     0   7   36 35 0   23   1   65       1.0 71 26 3 32   0 3     0   7   36 35 0   23 1 65     1 71
2571554 WA Kitsap   school 5300660 18100   Bremerton School District 530066002652 1749 Bremerton Homelink Program   Alternative School No Elementary KG 08 2020   grade_1 4 0 1   0 0     0   0   1 4 0   0   0   2       0.0 5 4 0 1   0 0     0   0   1 4 0   0 0 2     0 5
2571567 WA Kitsap   school 5300660 18100   Bremerton School District 530066000137 3108 Crownhill Elementary School   Regular School No Elementary PK 05 2020   grade_1 45 3 10   0 1     1   8   34 34 0   3   5   44       4.0 68 45 3 10   0 1     1   8   34 34 0   3 5 44     4 68
2571575 WA Kitsap   school 5300660 18100   Bremerton School District 530066000708 4421 Kitsap Lake Elementary   Regular School No Elementary KG 05 2020   grade_1 28 6 12   0 0     0   14   26 34 0   1   1   26       1.0 60 28 6 12   0 0     0   14   26 34 0   1 1 26     1 60
2571587 WA Kitsap   school 5300660 18100   Bremerton School District 530066000143 3171 Naval Avenue Elementary School   Regular School No Elementary PK 03 2020   grade_1 35 6 25   0 1     2   13   37 45 0   19   2   54       2.0 82 35 6 25   0 1     2   13   37 45 0   19 2 54     2 82
2571601 WA Kitsap   school 5300660 18100   Bremerton School District 530066000146 2853 View Ridge Elementary Arts Academy   Regular School No Elementary PK 05 2020   grade_1 42 4 16   0 3     3   19   39 48 0   10   3   56       7.0 87 42 4 16   0 3     3   19   39 48 0   10 3 56     7 87
2571609 WA Kitsap   school 5300660 18100   Bremerton School District 530066000144 2613 West Hills S.T.E.M. Academy   Regular School No Elementary PK 08 2020   grade_1 24 7 15   0 1     2   9   22 36 0   6   3   45       4.0 58 24 7 15   0 1     2   9   22 36 0   6 3 45     4 58
2571626 WA Okanogan   school 5300690 24111   Brewster School District 530069000148 3293 Brewster Elementary School   Regular School No Elementary PK 05 2020   grade_1 7 0 60   0 0     0   0   45 22 0   56   5   65       0.0 67 7 0 60   0 0     0   0   45 22 0   56 5 65     0 67
2571649 WA Douglas   school 5300720 9075   Bridgeport School District 530072000150 2562 Bridgeport Elementary   Regular School No Elementary PK 05 2020   grade_1 3 0 54   1 0     0   0   31 27 0   44   4   56       0.0 58 3 0 54   1 0     0   0   31 27 0   44 4 56     0 58
2571668 WA Jefferson   school 5300750 16046   Brinnon School District 530075000153 2836 Brinnon Elementary   Regular School No Elementary PK 08 2020   grade_1 5 1 0   0 0     0   0   3 3 0   0   0   6       0.0 6 5 1 0   0 0     0   0   3 3 0   0 0 6     0 6
2571679 WA Skagit   school 5300780 29100   Burlington-Edison School District 530078000154 3603 Allen Elementary   Regular School No Elementary KG 08 2020   grade_1 12 0 36   1 0     0   4   26 27 0   18   6   41       2.0 53 12 0 36   1 0     0   4   26 27 0   18 6 41     2 53
2571689 WA Skagit   school 5300780 29100   Burlington-Edison School District 530078000689 4412 Bay View Elementary   Regular School No Elementary KG 08 2020   grade_1 25 1 9   0 1     1   1   19 19 0   6   1   14       0.0 38 25 1 9   0 1     1   1   19 19 0   6 1 14     0 38
2571710 WA Skagit   school 5300780 29100   Burlington-Edison School District 530078000156 2379 Edison Elementary   Regular School No Elementary KG 08 2020   grade_1 37 0 5   0 0     0   2   24 20 0   2   0   11       0.0 44 37 0 5   0 0     0   2   24 20 0   2 0 11     0 44
2571720 WA Skagit   school 5300780 29100   Burlington-Edison School District 530078000157 3251 Lucille Umbarger Elementary   Regular School No Elementary 01 08 2020   grade_1 30 0 29   1 1     0   4   31 34 0   19   2   56       1.0 65 30 0 29   1 1     0   4   31 34 0   19 2 56     1 65
2571733 WA Skagit   school 5300780 29100   Burlington-Edison School District 530078000159 2946 West View Elementary   Regular School No Elementary KG 06 2020   grade_1 12 0 38   0 0     0   1   25 26 0   29   1   33       1.0 51 12 0 38   0 0     0   1   25 26 0   29 1 33     1 51
2571752 WA Clark   school 5300810 6117   Camas School District 530081001823 4182 Dorothy Fox   Regular School No Elementary KG 05 2020   grade_1 63 0 10   0 5     0   5   45 38 0   10   0   11       0.0 83 63 0 10   0 5     0   5   45 38 0   10 0 11     0 83
2571759 WA Clark   school 5300810 6117   Camas School District 530081003312 5158 Grass Valley Elementary   Regular School No Elementary KG 05 2020   grade_1 47 1 10   0 7     0   11   38 38 0   9   1   5       0.0 76 47 1 10   0 7     0   11   38 38 0   9 1 5     0 76
2571771 WA Clark   school 5300810 6117   Camas School District 530081002083 2725 Helen Baller Elem   Regular School No Elementary KG 05 2020   grade_1 84 0 16   0 2     0   9   59 52 0   5   0   25       0.0 111 84 0 16   0 2     0   9   59 52 0   5 0 25     0 111
2571778 WA Clark   school 5300810 6117   Camas School District 530081000163 3474 Lacamas Lake Elementary   Regular School No Elementary KG 05 2020   grade_1 45 1 6   0 0     0   14   30 36 0   1   0   11       1.0 66 45 1 6   0 0     0   14   30 36 0   1 0 11     1 66
2571795 WA Clark   school 5300810 6117   Camas School District 530081002880 4563 Prune Hill Elem   Regular School No Elementary KG 05 2020   grade_1 51 0 10   0 10     0   6   30 47 0   8   0   10       2.0 77 51 0 10   0 10     0   6   30 47 0   8 0 10     2 77
2571808 WA Clark   school 5300810 6117   Camas School District 530081003460 5309 Woodburn Elementary   Regular School No Elementary PK 05 2020   grade_1 70 3 10   0 3     0   16   51 51 0   8   3   36       1.0 102 70 3 10   0 3     0   16   51 51 0   8 3 36     1 102
2571820 WA Clallam   school 5300840 5401   Cape Flattery School District 530084000164 3422 Clallam Bay High & Elementary   Regular School No Other KG 12 2020   grade_1 6 0 5   3 0     0   2   9 7 0   0   0   13       0.0 16 6 0 5   3 0     0   2   9 7 0   0 0 13     0 16
2571831 WA Clallam   school 5300840 5401   Cape Flattery School District 530084003042 2594 Neah Bay Elementary School   Regular School No Elementary KG 05 2020   grade_1 4 0 1   18 0     0   8   16 15 0   0   1   21       0.0 31 4 0 1   18 0     0   8   16 15 0   0 1 21     0 31
2571847 WA Pierce   school 5300870 27019   Carbonado School District 530087000166 2466 Carbonado Historical School 19   Regular School No Elementary PK 08 2020   grade_1 21 0 0   0 0     0   2   13 10 0   0   0   4       0.0 23 21 0 0   0 0     0   2   13 10 0   0 0 4     0 23
2571863 WA Chelan   school 5300950 4228   Cascade School District 530095002937 4566 Beaver Valley School   Regular School No Elementary KG 04 2020   grade_1 4 0 0   0 0     0   0   3 1 0   0   0   0       0.0 4 4 0 0   0 0     0   0   3 1 0   0 0 0     0 4
2571875 WA Chelan   school 5300950 4228   Cascade School District 530095003528 5418 Cascade Home-Link   Regular School No Elementary KG 08 2020   grade_1 4 0 0   0 0     0   0   2 2 0   0   0   1       0.0 4 4 0 0   0 0     0   0   2 2 0   0 0 1     0 4
2571889 WA Chelan   school 5300950 4228   Cascade School District 530095001933 2760 Peshastin Dryden Elementary   Regular School No Elementary PK 02 2020   grade_1 41 0 27   0 0     0   3   31 40 0   21   0   34       1.0 71 41 0 27   0 0     0   3   31 40 0   21 0 34     1 71
2571904 WA Chelan   school 5300960 4222   CASHMERE SCHOOL DISTRICT 530096000170 2787 VALE ELEMENTARY SCHOOL   Regular School No Elementary PK 04 2020   grade_1 82 0 34   0 1     1   4   60 62 0   22   2   47       3.0 122 82 0 34   0 1     1   4   60 62 0   22 2 47     3 122
2571911 WA Cowlitz   school 5300990 8401   Castle Rock School District 530099000171 2762 Castle Rock Elementary   Regular School No Elementary PK 05 2020   grade_1 90 0 7   0 0     0   14   56 55 0   1   1   57       4.0 111 90 0 7   0 0     0   14   56 55 0   1 1 57     4 111
2571928 WA Klickitat   school 5301050 20215   Centerville School District 530105000175 2251 Centerville Elementary   Regular School No Elementary KG 08 2020   grade_1 12 0 0   0 0     0   0   7 5 0   0   0   8       0.0 12 12 0 0   0 0     0   0   7 5 0   0 0 8     0 12
2571941 WA Kitsap   school 5301080 18401   Central Kitsap School District 530108003622 5472 Barker Creek Community School   Alternative School No Other KG 12 2020   grade_1 3 0 0   0 0     0   1   3 1 0   0   0   0       0.0 4 3 0 0   0 0     0   1   3 1 0   0 0 0     0 4
2571953 WA Kitsap   school 5301080 18401   Central Kitsap School District 530108000176 2994 Brownsville Elementary   Regular School No Elementary PK 05 2020   grade_1 57 0 8   0 2     1   10   34 44 0   4   1   8       1.0 78 57 0 8   0 2     1   10   34 44 0   4 1 8     1 78
2571970 WA Kitsap   school 5301080 18401   Central Kitsap School District 530108000180 4016 Clear Creek Elementary School   Regular School No Elementary PK 05 2020   grade_1 44 4 21   1 2     0   7   46 33 0   1   0   17       3.0 79 44 4 21   1 2     0   7   46 33 0   1 0 17     3 79
2571978 WA Kitsap   school 5301080 18401   Central Kitsap School District 530108000181 4014 Cottonwood Elementary School   Regular School No Elementary PK 05 2020   grade_1 35 0 14   2 1     1   12   37 28 0   5   1   11       1.0 65 35 0 14   2 1     1   12   37 28 0   5 1 11     1 65
2571986 WA Kitsap   school 5301080 18401   Central Kitsap School District 530108002251 4341 Cougar Valley Elementary   Regular School No Elementary PK 05 2020   grade_1 45 2 15   1 1     0   7   37 34 0   1   1   9       1.0 71 45 2 15   1 1     0   7   37 34 0   1 1 9     1 71
2571994 WA Kitsap   school 5301080 18401   Central Kitsap School District 530108000757 4444 Emerald Heights Elementary   Regular School No Elementary PK 05 2020   grade_1 44 1 16   0 2     0   18   51 30 0   8   2   11       1.0 81 44 1 16   0 2     0   18   51 30 0   8 2 11     1 81
2572002 WA Kitsap   school 5301080 18401   Central Kitsap School District 530108000182 4015 Esquire Hills Elementary   Regular School No Elementary PK 05 2020   grade_1 33 3 8   2 1     3   8   35 24 0   1   1   14       0.0 59 33 3 8   2 1     3   8   35 24 0   1 1 14     0 59
2572014 WA Kitsap   school 5301080 18401   Central Kitsap School District 530108000530 4393 Green Mountain Elementary   Regular School No Elementary PK 05 2020   grade_1 42 0 5   0 0     0   6   27 26 0   0   0   9       1.0 53 42 0 5   0 0     0   6   27 26 0   0 0 9     1 53
2572022 WA Kitsap   school 5301080 18401   Central Kitsap School District 530108000184 3594 John D. Bud Hawk Elementary at Jackson Park   Regular School No Elementary PK 05 2020   grade_1 48 5 21   1 3     0   16   48 46 0   4   1   28       2.0 94 48 5 21   1 3     0   16   48 46 0   4 1 28     2 94
2572043 WA Kitsap   school 5301080 18401   Central Kitsap School District 530108002655 4527 Pinecrest Elementary   Regular School No Elementary PK 05 2020   grade_1 26 0 16   0 3     0   15   36 24 0   5   1   8       2.0 60 26 0 16   0 3     0   15   36 24 0   5 1 8     2 60
2572055 WA Kitsap   school 5301080 18401   Central Kitsap School District 530108002287 4372 Silver Ridge Elementary   Regular School No Elementary PK 05 2020   grade_1 33 3 14   0 2     0   15   31 36 0   5   0   6       0.0 67 33 3 14   0 2     0   15   31 36 0   5 0 6     0 67
2572063 WA Kitsap   school 5301080 18401   Central Kitsap School District 530108001754 4101 Silverdale Elementary   Regular School No Elementary PK 05 2020   grade_1 50 1 13   0 2     0   11   38 39 0   4   0   12       1.0 77 50 1 13   0 2     0   11   38 39 0   4 0 12     1 77
2572071 WA Kitsap   school 5301080 18401   Central Kitsap School District 530108001752 4135 Woodlands Elementary   Regular School No Elementary KG 05 2020   grade_1 44 5 19   1 4     1   9   40 43 0   6   0   16       0.0 83 44 5 19   1 4     1   9   40 43 0   6 0 16     0 83
2572079 WA Spokane   school 5301110 32356   Central Valley School District 530111000187 3259 Adams Elementary   Regular School No Elementary PK 05 2020   grade_1 60 2 1   0 1     1   4   40 29 0   5   2   33       0.0 69 60 2 1   0 1     1   4   40 29 0   5 2 33     0 69
2572091 WA Spokane   school 5301110 32356   Central Valley School District 530111000190 2892 Broadway Elementary   Regular School No Elementary PK 05 2020   grade_1 46 2 3   0 0     1   5   29 28 0   5   3   43       0.0 57 46 2 3   0 0     1   5   29 28 0   5 3 43     0 57
2572106 WA Spokane   school 5301110 32356   Central Valley School District 530111000192 3929 Chester Elementary School   Regular School No Elementary PK 05 2020   grade_1 68 2 5   1 2     0   3   39 42 0   1   7   31       0.0 81 68 2 5   1 2     0   3   39 42 0   1 7 31     0 81
2572122 WA Spokane   school 5301110 32356   Central Valley School District 530111000194 2157 Greenacres Elementary   Regular School No Elementary KG 05 2020   grade_1 90 3 6   1 3     1   4   58 50 0   5   3   44       0.0 108 90 3 6   1 3     1   4   58 50 0   5 3 44     0 108
2572139 WA Spokane   school 5301110 32356   Central Valley School District 530111003596 5507 Liberty Creek Elementary School   Regular School No Elementary KG 03 2020   grade_1 169 6 1   2 4     0   4   95 91 0   8   4   35       0.0 186 169 6 1   2 4     0   4   95 91 0   8 4 35     0 186
2572148 WA Spokane   school 5301110 32356   Central Valley School District 530111000197 3127 McDonald Elementary School   Regular School No Elementary PK 05 2020   grade_1 48 1 2   0 0     2   0   24 29 0   2   0   23       0.0 53 48 1 2   0 0     2   0   24 29 0   2 0 23     0 53
2572165 WA Spokane   school 5301110 32356   Central Valley School District 530111000199 2113 Opportunity Elementary   Regular School No Elementary PK 05 2020   grade_1 87 6 7   2 0     0   4   52 54 0   4   1   72       2.0 106 87 6 7   2 0     0   4   52 54 0   4 1 72     2 106
2572173 WA Spokane   school 5301110 32356   Central Valley School District 530111001756 4098 Ponderosa Elementary   Regular School No Elementary PK 05 2020   grade_1 63 3 2   0 0     1   0   38 31 0   0   1   25       1.0 69 63 3 2   0 0     1   0   38 31 0   0 1 25     1 69
2572182 WA Spokane   school 5301110 32356   Central Valley School District 530111000200 2953 Progress Elementary School   Regular School No Elementary PK 05 2020   grade_1 27 1 1   3 1     2   1   16 20 0   7   0   28       0.0 36 27 1 1   3 1     2   1   16 20 0   7 0 28     0 36
2572190 WA Spokane   school 5301110 32356   Central Valley School District 530111003629 5541 Riverbend Elementary School   Regular School No Elementary KG 05 2020   grade_1 67 1 5   2 1     0   0   33 43 0   3   0   21       1.0 76 67 1 5   2 1     0   0   33 43 0   3 0 21     1 76
2572204 WA Spokane   school 5301110 32356   Central Valley School District 530111000201 3307 South Pines Elementary   Regular School No Elementary PK 05 2020   grade_1 44 1 4   2 1     0   1   32 21 0   2   1   28       0.0 53 44 1 4   2 1     0   1   32 21 0   2 1 28     0 53
2572212 WA Spokane   school 5301110 32356   Central Valley School District 530111003137 1964 Spokane Valley Learning Academy   Regular School No Elementary KG 08 2020   grade_1 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
2572231 WA Spokane   school 5301110 32356   Central Valley School District 530111000188 3465 Summit School   Regular School No Elementary KG 08 2020   grade_1 44 1 1   0 0     0   2   24 24 0   3   0   9       0.0 48 44 1 1   0 0     0   2   24 24 0   3 0 9     0 48
2572242 WA Spokane   school 5301110 32356   Central Valley School District 530111001827 4160 Sunrise Elementary   Regular School No Elementary PK 05 2020   grade_1 104 1 1   1 1     0   2   56 54 0   0   2   16       2.0 110 104 1 1   1 1     0   2   56 54 0   0 2 16     2 110
2572249 WA Spokane   school 5301110 32356   Central Valley School District 530111000203 3064 University Elementary School   Regular School No Elementary PK 05 2020   grade_1 36 2 3   2 1     1   5   22 28 0   4   3   36       0.0 50 36 2 3   2 1     1   5   22 28 0   4 3 36     0 50
2572270 WA Lewis   school 5301140 21401   Centralia School District 530114003580 5463 Centralia School District SpEd Pre-school   Regular School No Prekindergarten PK PK 2020   grade_1 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
2572273 WA Lewis   school 5301140 21401   Centralia School District 530114000207 2244 Edison Elementary   Regular School No Elementary KG 06 2020   grade_1 27 0 14   0 1     0   4   25 21 0   5   2   34       0.0 46 27 0 14   0 1     0   4   25 21 0   5 2 34     0 46
2572281 WA Lewis   school 5301140 21401   Centralia School District 530114000208 2704 Fords Prairie Elementary   Regular School No Elementary KG 06 2020   grade_1 43 0 27   0 1     0   1   29 43 0   13   2   59       0.0 72 43 0 27   0 1     0   1   29 43 0   13 2 59     0 72
2572294 WA Lewis   school 5301140 21401   Centralia School District 530114000209 3172 Jefferson Lincoln Elementary   Regular School No Elementary KG 06 2020   grade_1 36 1 32   0 0     0   2   34 37 0   15   2   60       0.0 71 36 1 32   0 0     0   2   34 37 0   15 2 60     0 71
2572302 WA Lewis   school 5301140 21401   Centralia School District 530114000210 2291 Oakview Elementary School   Regular School No Elementary KG 06 2020   grade_1 26 0 17   0 0     0   2   23 22 0   12   4   42       1.0 45 26 0 17   0 0     0   2   23 22 0   12 4 42     1 45
2572310 WA Lewis   school 5301140 21401   Centralia School District 530114000211 2768 Washington Elementary School   Regular School No Elementary KG 06 2020   grade_1 28 0 21   0 0     0   2   24 26 1   9   1   46       1.0 51 28 0 21   0 0     0   2   24 26 1   9 1 46     1 51
2572326 WA Lewis   school 5301170 21302   Chehalis School District 530117003654 5509 James W Lintott Elementary School   Regular School No Elementary PK 02 2020   grade_1 148 1 54   1 1     0   16   104 117 0   16   4   122       3.0 221 148 1 54   1 1     0   16   104 117 0   16 4 122     3 221
2572354 WA Spokane   school 5301230 32360   Cheney School District 530123000221 2954 Betz Elementary   Regular School No Elementary PK 05 2020   grade_1 47 0 6   0 3     0   8   32 32 0   7   1   29       0.0 64 47 0 6   0 3     0   8   32 32 0   7 1 29     0 64
2572377 WA Spokane   school 5301230 32360   Cheney School District 530123003014 5035 HomeWorks   Alternative School No Other KG 12 2020   grade_1 4 0 1   1 0     0   0   2 4 0   1   0   2       0.0 6 4 0 1   1 0     0   0   2 4 0   1 0 2     0 6
2572387 WA Spokane   school 5301230 32360   Cheney School District 530123003413 5294 Phil Snowdon Elementary   Regular School No Elementary PK 05 2020   grade_1 57 1 9   2 0     1   6   46 30 0   3   3   40       2.0 76 57 1 9   2 0     1   6   46 30 0   3 3 40     2 76
2572395 WA Spokane   school 5301230 32360   Cheney School District 530123000226 3761 Salnave Elementary   Regular School No Elementary PK 05 2020   grade_1 34 0 7   0 0     0   8   26 23 0   1   1   36       0.0 49 34 0 7   0 0     0   8   26 23 0   1 1 36     0 49
2572403 WA Spokane   school 5301230 32360   Cheney School District 530123000227 2814 Sunset Elementary   Regular School No Elementary PK 05 2020   grade_1 56 3 21   7 4     3   13   55 52 0   15   6   84       3.0 107 56 3 21   7 4     3   13   55 52 0   15 6 84     3 107
2572420 WA Spokane   school 5301230 32360   Cheney School District 530123000228 3309 Windsor Elementary   Regular School No Elementary PK 05 2020   grade_1 84 1 4   2 0     2   7   51 49 0   15   3   49       0.0 100 84 1 4   2 0     2   7   51 49 0   15 3 49     0 100
2572431 WA Stevens   school 5301260 33036   Chewelah School District 530126000229 2664 Gess Elementary   Regular School No Elementary KG 06 2020   grade_1 45 0 2   0 0     0   3   25 25 0   0   3   36       3.0 50 45 0 2   0 0     0   3   25 25 0   0 3 36     3 50
2572450 WA Stevens   school 5301260 33036   Chewelah School District 530126002687 1763 Quartzite Learning   Alternative School No Other KG 12 2020   grade_1 8 0 0   0 0     0   0   3 5 0   0   0   5       0.0 8 8 0 0   0 0     0   0   3 5 0   0 0 5     0 8
2572464 WA Pierce   school   27901   Chief Leschi Schools   5549 Chief Leschi Schools             2020   grade_1 0 0 15   20 0     0   5   22 18 0   0   0   22       0.0 40 0 0 15   20 0     0   5   22 18 0   0 0 22     0 40
2572475 WA Jefferson   school 5301290 16049   Chimacum School District 530129002790 4552 Chimacum Creek Primary School   Regular School No Elementary PK 02 2020   grade_1 41 0 6   0 1     0   2   27 23 0   3   2   35       0.0 50 41 0 6   0 1     0   2   27 23 0   3 2 35     0 50
2572495 WA Jefferson   school 5301290 16049   Chimacum School District 530129002630 1724 PI Program   Alternative School No Other KG 12 2020   grade_1 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
2572519 WA Asotin   school 5301320 2250   Clarkston School District 530132000235 2962 Grantham Elementary   Regular School No Elementary KG 06 2020   grade_1 29 0 7   0 0     0   1   20 17 0   0   3   33       0.0 37 29 0 7   0 0     0   1   20 17 0   0 3 33     0 37
2572528 WA Asotin   school 5301320 2250   Clarkston School District 530132002433 4384 Heights Elementary   Regular School No Elementary KG 06 2020   grade_1 54 2 3   0 0     0   0   31 28 0   0   1   18       2.0 59 54 2 3   0 0     0   0   31 28 0   0 1 18     2 59
2572537 WA Asotin   school 5301320 2250   Clarkston School District 530132000236 3266 Highland Elementary   Regular School No Elementary KG 06 2020   grade_1 20 0 5   0 0     0   1   9 17 0   0   1   19       0.0 26 20 0 5   0 0     0   1   9 17 0   0 1 19     0 26
2572549 WA Asotin   school 5301320 2250   Clarkston School District 530132000238 2823 Parkway Elementary   Regular School No Elementary KG 06 2020   grade_1 42 0 3   0 1     0   5   30 21 0   1   1   33       2.0 51 42 0 3   0 1     0   5   30 21 0   1 1 33     2 51
2572558 WA Asotin   school 5301320 2250   Clarkston School District 530132002613 3616 Special Services   Special Education School No Other PK 12 2020   grade_1 5 0 0   1 0     0   0   5 1 0   0   0   0       0.0 6 5 0 0   1 0     0   0   5 1 0   0 0 0     0 6
2572566 WA Kittitas   school 5301350 19404   Cle Elum-Roslyn School District 530135000241 2328 Cle Elum Roslyn Elementary   Regular School No Elementary PK 05 2020   grade_1 51 0 1   0 0     0   4   26 30 0   0   1   20       3.0 56 51 0 1   0 0     0   4   26 30 0   0 1 20     3 56
2572600 WA Pierce   school 5301410 27400   Clover Park School District 530141000246 3454 Beachwood Elementary School   Regular School No Elementary PK 05 2020   grade_1 25 11 17   0 1     2   11   33 34 0   2   0   26       0.0 67 25 11 17   0 1     2   11   33 34 0   2 0 26     0 67
2572608 WA Pierce   school 5301410 27400   Clover Park School District 530141000247 3457 Carter Lake Elementary School   Regular School No Elementary PK 05 2020   grade_1 40 12 20   0 4     0   10   42 44 0   2   1   44       2.0 86 40 12 20   0 4     0   10   42 44 0   2 1 44     2 86
2572627 WA Pierce   school 5301410 27400   Clover Park School District 530141000251 2943 Custer Elementary School   Regular School No Elementary PK 05 2020   grade_1 12 3 10   0 0     2   17   24 20 0   4   2   43       0.0 44 12 3 10   0 0     2   17   24 20 0   4 2 43     0 44
2572635 WA Pierce   school 5301410 27400   Clover Park School District 530141000252 3455 Dower Elementary School   Regular School No Elementary PK 05 2020   grade_1 20 6 15   1 2     2   6   26 26 0   7   0   50       1.0 52 20 6 15   1 2     2   6   26 26 0   7 0 50     1 52
2572642 WA Pierce   school 5301410 27400   Clover Park School District 530141002438 4396 Evergreen Elementary School   Regular School No Elementary PK 05 2020   grade_1 45 13 28   0 2     3   8   62 37 0   6   2   63       4.0 99 45 13 28   0 2     3   8   62 37 0   6 2 63     4 99
2572657 WA Pierce   school 5301410 27400   Clover Park School District 530141003516 5387 Four Heroes Elementary   Regular School No Elementary PK 05 2020   grade_1 21 13 54   1 4     10   9   61 51 0   47   8   100       0.0 112 21 13 54   1 4     10   9   61 51 0   47 8 100     0 112
2572666 WA Pierce   school 5301410 27400   Clover Park School District 530141000256 3298 Hillside Elementary School   Regular School No Elementary PK 05 2020   grade_1 26 12 29   0 2     1   11   42 39 0   5   2   66       3.0 81 26 12 29   0 2     1   11   42 39 0   5 2 66     3 81
2572678 WA Pierce   school 5301410 27400   Clover Park School District 530141000258 3117 Idlewild Elementary School   Regular School No Elementary PK 05 2020   grade_1 34 6 15   0 5     1   22   40 43 0   5   0   36       1.0 83 34 6 15   0 5     1   22   40 43 0   5 0 36     1 83
2572686 WA Pierce   school 5301410 27400   Clover Park School District 530141000260 3351 Lake Louise Elementary School   Regular School No Elementary PK 05 2020   grade_1 28 10 23   1 0     7   11   39 41 0   10   1   70       0.0 80 28 10 23   1 0     7   11   39 41 0   10 1 70     0 80
2572699 WA Pierce   school 5301410 27400   Clover Park School District 530141000262 2652 Lakeview Hope Academy   Regular School No Elementary PK 05 2020   grade_1 13 8 57   0 3     11   13   58 47 0   42   2   103       0.0 105 13 8 57   0 3     11   13   58 47 0   42 2 103     0 105
2572715 WA Pierce   school 5301410 27400   Clover Park School District 530141003473 5364 Meriwether Elementary School   Regular School No Elementary PK 05 2020   grade_1 29 8 15   0 1     1   9   36 27 0   2   1   19       0.0 63 29 8 15   0 1     1   9   36 27 0   2 1 19     0 63
2572728 WA Pierce   school 5301410 27400   Clover Park School District 530141000265 3763 Oakbrook Elementary School   Regular School No Elementary PK 05 2020   grade_1 14 6 10   1 3     2   6   22 20 0   5   2   26       0.0 42 14 6 10   1 3     2   6   22 20 0   5 2 26     0 42
2572739 WA Pierce   school 5301410 27400   Clover Park School District 530141002581 2189 Park Lodge Elementary School   Regular School No Elementary PK 05 2020   grade_1 6 20 37   0 2     2   13   41 39 0   27   3   76       1.0 80 6 20 37   0 2     2   13   41 39 0   27 3 76     1 80
2572747 WA Pierce   school 5301410 27400   Clover Park School District 530141003472 5365 Rainier Elementary School   Regular School No Elementary PK 05 2020   grade_1 46 11 24   0 4     2   9   46 50 0   5   1   56       2.0 96 46 11 24   0 4     2   9   46 50 0   5 1 56     2 96
2572767 WA Pierce   school 5301410 27400   Clover Park School District 530141000158 2651 Tillicum Elementary School   Regular School No Elementary PK 05 2020   grade_1 15 2 20   0 0     6   12   27 28 0   15   2   54       1.0 55 15 2 20   0 0     6   12   27 28 0   15 2 54     1 55
2572783 WA Pierce   school 5301410 27400   Clover Park School District 530141000270 3249 Tyee Park Elementary School   Regular School No Elementary PK 05 2020   grade_1 10 8 21   0 1     7   16   29 34 0   18   4   59       0.0 63 10 8 21   0 1     7   16   29 34 0   18 4 59     0 63

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