Data source: Big Local News · About: Big Local

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

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
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
2570395 WA Lincoln   school 5300090 22017   Almira School District 530009000179 2860 Almira Elementary School   Regular School No Elementary PK 08 2020   grade_2 2 0 0   0 0     0   2   2 2 0   0   0   2       0.0 4 2 0 0   0 0     0   2   2 2 0   0 0 2     0 4
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
2570428 WA Skagit   school 5300150 29103   Anacortes School District 530015000018 3252 Island View Elementary   Regular School No Elementary KG 05 2020   grade_2 61 1 5   0 0     0   7   39 35 0   2   1   18       4.0 74 61 1 5   0 0     0   7   39 35 0   2 1 18     4 74
2570435 WA Skagit   school 5300150 29103   Anacortes School District 530015000019 3057 Mount Erie Elementary   Regular School No Elementary KG 05 2020   grade_2 55 0 4   0 0     0   1   30 30 0   1   0   18       1.0 60 55 0 4   0 0     0   1   30 30 0   1 0 18     1 60
2570460 WA Snohomish   school 5300240 31016   Arlington School District 530024002248 4327 Eagle Creek Elementary   Regular School No Elementary KG 05 2020   grade_2 95 0 14   2 1     0   7   51 68 0   9   1   48       5.0 119 95 0 14   2 1     0   7   51 68 0   9 1 48     5 119
2570473 WA Snohomish   school 5300240 31016   Arlington School District 530024001190 4436 Kent Prairie Elementary   Regular School No Elementary PK 05 2020   grade_2 73 1 17   1 0     1   14   49 58 0   9   1   48       4.0 107 73 1 17   1 0     1   14   49 58 0   9 1 48     4 107
2570481 WA Snohomish   school 5300240 31016   Arlington School District 530024002940 4573 Pioneer Elementary   Regular School No Elementary KG 05 2020   grade_2 70 1 14   1 2     0   11   61 38 0   7   2   31       2.0 99 70 1 14   1 2     0   11   61 38 0   7 2 31     2 99
2570493 WA Snohomish   school 5300240 31016   Arlington School District 530024001815 4154 Presidents Elementary   Regular School No Elementary PK 05 2020   grade_2 63 1 12   0 0     0   8   41 43 0   7   2   35       3.0 84 63 1 12   0 0     0   8   41 43 0   7 2 35     3 84
2570501 WA Snohomish   school 5300240 31016   Arlington School District 530024002589 1714 Stillaguamish Valley Learning Center   Alternative School No Elementary KG 08 2020   grade_2 5 0 1   0 0     0   0   5 1 0   0   0   0       0.0 6 5 0 1   0 0     0   0   5 1 0   0 0 0     0 6
2570516 WA King   school 5300346 17915   Ashe Preparatory Academy 530034603713 5602 Ashe Preparatory Academy (Closed after 2019-2020 school year)   Regular School Yes Elementary KG 08 2020   grade_2 0 11 1   0 0     0   2   5 9 0   0   0   0       0.0 14 0 11 1   0 0     0   2   5 9 0   0 0 0     0 14
2570521 WA Asotin   school 5300280 2420   Asotin-Anatone School District 530028000027 2507 Asotin Elementary   Regular School No Elementary PK 05 2020   grade_2 34 0 1   0 1     0   3   15 24 0   0   1   20       0.0 39 34 0 1   0 1     0   3   15 24 0   0 1 20     0 39
2570537 WA King   school 5300300 17408   Auburn School District 530030000029 3825 Alpac Elementary School   Regular School No Elementary PK 05 2020   grade_2 39 4 39   0 9     1   11   54 49 0   34   3   69       2.0 103 39 4 39   0 9     1   11   54 49 0   34 3 69     2 103
2570545 WA King   school 5300300 17408   Auburn School District 530030003174 5082 Arthur Jacobsen Elementary   Regular School No Elementary PK 05 2020   grade_2 37 6 23   0 15     1   7   53 36 0   29   1   46       0.0 89 37 6 23   0 15     1   7   53 36 0   29 1 46     0 89
2570576 WA King   school 5300300 17408   Auburn School District 530030000034 3439 Chinook Elementary School   Regular School No Elementary PK 05 2020   grade_2 13 4 33   11 2     10   14   41 46 0   28   1   63       1.0 87 13 4 33   11 2     10   14   41 46 0   28 1 63     1 87
2570584 WA King   school 5300300 17408   Auburn School District 530030000037 2932 Dick Scobee Elementary School   Regular School No Elementary PK 05 2020   grade_2 29 13 25   0 3     6   8   40 44 0   25   1   73       0.0 84 29 13 25   0 3     6   8   40 44 0   25 1 73     0 84
2570592 WA King   school 5300300 17408   Auburn School District 530030000035 3745 Evergreen Heights Elementary   Regular School No Elementary KG 05 2020   grade_2 24 9 17   0 23     3   5   42 39 0   28   0   42       1.0 81 24 9 17   0 23     3   5   42 39 0   28 0 42     1 81
2570599 WA King   school 5300300 17408   Auburn School District 530030000040 3669 Gildo Rey Elementary School   Regular School No Elementary PK 05 2020   grade_2 21 3 47   0 7     11   4   56 37 0   47   0   66       1.0 93 21 3 47   0 7     11   4   56 37 0   47 0 66     1 93
2570607 WA King   school 5300300 17408   Auburn School District 530030002277 4347 Hazelwood Elementary School   Regular School No Elementary KG 05 2020   grade_2 50 5 26   0 14     1   10   65 41 0   30   1   51       0.0 106 50 5 26   0 14     1   10   65 41 0   30 1 51     0 106
2570614 WA King   school 5300300 17408   Auburn School District 530030000698 4417 Ilalko Elementary School   Regular School No Elementary KG 05 2020   grade_2 44 6 30   0 11     8   8   64 43 0   38   1   61       4.0 107 44 6 30   0 11     8   8   64 43 0   38 1 61     4 107
2570622 WA King   school 5300300 17408   Auburn School District 530030001744 4120 Lake View Elementary School   Regular School No Elementary PK 05 2020   grade_2 36 4 22   0 4     2   4   38 34 0   19   0   29       0.0 72 36 4 22   0 4     2   4   38 34 0   19 0 29     0 72
2570630 WA King   school 5300300 17408   Auburn School District 530030003063 5051 Lakeland Hills Elementary   Regular School No Elementary KG 05 2020   grade_2 50 7 27   0 13     1   21   56 63 0   20   0   31       3.0 119 50 7 27   0 13     1   21   56 63 0   20 0 31     3 119
2570637 WA King   school 5300300 17408   Auburn School District 530030000036 3525 Lea Hill Elementary School   Regular School No Elementary PK 05 2020   grade_2 37 19 21   0 12     3   17   62 47 0   45   4   82       1.0 109 37 19 21   0 12     3   17   62 47 0   45 4 82     1 109
2570653 WA King   school 5300300 17408   Auburn School District 530030000039 3227 Pioneer Elementary School   Regular School No Elementary PK 05 2020   grade_2 12 4 50   0 3     8   8   53 32 0   43   0   70       1.0 85 12 4 50   0 3     8   8   53 32 0   43 0 70     1 85
2570672 WA King   school 5300300 17408   Auburn School District 530030000041 2659 Terminal Park Elementary School   Regular School No Elementary KG 05 2020   grade_2 32 2 17   2 6     3   11   42 31 0   21   2   47       0.0 73 32 2 17   2 6     3   11   42 31 0   21 2 47     0 73
2570680 WA King   school 5300300 17408   Auburn School District 530030000042 2326 Washington Elementary School   Regular School No Elementary PK 05 2020   grade_2 24 7 27   0 1     11   16   46 40 0   30   2   72       0.0 86 24 7 27   0 1     11   16   46 40 0   30 2 72     0 86
2570699 WA Kitsap   school 5300330 18303   Bainbridge Island School District 530033003113 1939 Bainbridge Special Education Services   Special Education School No Other PK 12 2020   grade_2 1 0 1   0 0     0   0   0 2 0   0   0   0       0.0 2 1 0 1   0 0     0   0   0 2 0   0 0 0     0 2
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
2570728 WA Kitsap   school 5300330 18303   Bainbridge Island School District 530033002802 1841 Mosaic Home Education Partnership   Alternative School No Elementary KG 08 2020   grade_2 7 0 0   0 0     0   0   5 2 0   0   0   1       0.0 7 7 0 0   0 0     0   0   5 2 0   0 0 1     0 7
2570738 WA Kitsap   school 5300330 18303   Bainbridge Island School District 530033002523 1699 Odyssey Multiage Program   Regular School No Elementary KG 08 2020   grade_2 15 1 3   0 0     0   1   8 12 0   0   0   2       2.0 20 15 1 3   0 0     0   1   8 12 0   0 0 2     2 20
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
2570826 WA Clark   school 5300380 6119   Battle Ground School District 530038002857 1875 Homelink River   Alternative School No Other KG 12 2020   grade_2 44 0 4   0 0     0   3   28 23 0   4   0   12       2.0 51 44 0 4   0 0     0   3   28 23 0   4 0 12     2 51
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
2570898 WA King   school 5300390 17405   Bellevue School District 530039000058 3633 Ardmore Elementary School   Regular School No Elementary PK 05 2020   grade_2 13 5 12   0 30     0   0   27 33 0   22   0   21       0.0 60 13 5 12   0 30     0   0   27 33 0   22 0 21     0 60
2570919 WA King   school 5300390 17405   Bellevue School District 530039000062 3705 Bennett Elementary School   Regular School No Elementary PK 05 2020   grade_2 33 2 3   1 28     0   7   30 44 0   16   1   5       2.0 74 33 2 3   1 28     0   7   30 44 0   16 1 5     2 74
2570932 WA King   school 5300390 17405   Bellevue School District 530039003434 5281 Central Educational Services   Regular School No Other PK 12 2020   grade_2 1 0 0   0 0     0   0   1 0 0   0   0   0       0.0 1 1 0 0   0 0     0   0   1 0 0   0 0 0     0 1
2570944 WA King   school 5300390 17405   Bellevue School District 530039000063 3742 Cherry Crest Elementary School   Regular School No Elementary PK 05 2020   grade_2 35 0 1   0 71     0   9   59 57 0   12   0   4       2.0 116 35 0 1   0 71     0   9   59 57 0   12 0 4     2 116
2570957 WA King   school 5300390 17405   Bellevue School District 530039000065 2847 Clyde Hill Elementary   Regular School No Elementary PK 05 2020   grade_2 37 2 7   0 46     1   8   55 46 0   30   1   9       3.0 101 37 2 7   0 46     1   8   55 46 0   30 1 9     3 101
2570965 WA King   school 5300390 17405   Bellevue School District 530039000066 3036 Eastgate Elementary School   Regular School No Elementary PK 05 2020   grade_2 27 2 10   0 27     1   13   41 39 0   23   2   14       3.0 80 27 2 10   0 27     1   13   41 39 0   23 2 14     3 80
2570973 WA King   school 5300390 17405   Bellevue School District 530039000067 2846 Enatai Elementary School   Regular School No Elementary PK 05 2020   grade_2 22 2 7   0 29     0   7   34 33 0   14   2   10       1.0 67 22 2 7   0 29     0   7   34 33 0   14 2 10     1 67
2570998 WA King   school 5300390 17405   Bellevue School District 530039003455 5308 Jing Mei Elementary School   Regular School No Elementary PK 05 2020   grade_2 6 1 0   0 59     1   9   34 42 0   27   0   7       3.0 76 6 1 0   0 59     1   9   34 42 0   27 0 7     3 76
2571006 WA King   school 5300390 17405   Bellevue School District 530039000075 3225 Lake Hills Elementary   Regular School No Elementary PK 05 2020   grade_2 19 7 35   0 16     2   5   48 36 0   42   5   49       0.0 84 19 7 35   0 16     2   5   48 36 0   42 5 49     0 84
2571014 WA King   school 5300390 17405   Bellevue School District 530039000076 3436 Medina Elementary School   Regular School No Elementary PK 05 2020   grade_2 16 0 3   0 47     0   2   38 30 0   9   0   1       2.0 68 16 0 3   0 47     0   2   38 30 0   9 0 1     2 68
2571022 WA King   school 5300390 17405   Bellevue School District 530039000077 3437 Newport Heights Elementary   Regular School No Elementary PK 05 2020   grade_2 29 4 6   0 27     0   10   42 34 0   12   1   12       2.0 76 29 4 6   0 27     0   10   42 34 0   12 1 12     2 76
2571039 WA King   school 5300390 17405   Bellevue School District 530039000082 3168 Phantom Lake Elementary   Regular School No Elementary PK 05 2020   grade_2 25 4 8   0 13     0   15   33 32 0   17   1   13       1.0 65 25 4 8   0 13     0   15   33 32 0   17 1 13     1 65
2571047 WA King   school 5300390 17405   Bellevue School District 530039000090 3224 Puesta del Sol Elementary School   Regular School No Elementary PK 05 2020   grade_2 42 3 17   1 15     0   14   49 43 0   8   2   4       7.0 92 42 3 17   1 15     0   14   49 43 0   8 2 4     7 92
2571060 WA King   school 5300390 17405   Bellevue School District 530039000086 3339 Sherwood Forest Elementary   Regular School No Elementary PK 05 2020   grade_2 16 7 26   0 16     1   8   39 35 0   33   2   36       1.0 74 16 7 26   0 16     1   8   39 35 0   33 2 36     1 74
2571068 WA King   school 5300390 17405   Bellevue School District 530039000087 3789 Somerset Elementary School   Regular School No Elementary KG 05 2020   grade_2 15 0 7   0 65     0   8   42 53 0   14   0   7       2.0 95 15 0 7   0 65     0   8   42 53 0   14 0 7     2 95
2571075 WA King   school 5300390 17405   Bellevue School District 530039000088 3634 Spiritridge Elementary School   Regular School No Elementary KG 05 2020   grade_2 40 3 8   0 54     0   10   58 57 0   17   2   9       3.0 115 40 3 8   0 54     0   10   58 57 0   17 2 9     3 115
2571083 WA King   school 5300390 17405   Bellevue School District 530039000089 3100 Stevenson Elementary   Regular School No Elementary PK 05 2020   grade_2 6 7 34   0 51     0   5   55 48 0   54   3   41       1.0 103 6 7 34   0 51     0   5   55 48 0   54 3 41     1 103
2571099 WA King   school 5300390 17405   Bellevue School District 530039003638 5508 Wilburton Elementary School   Regular School No Elementary PK 05 2020   grade_2 20 2 11   0 36     0   5   36 38 0   30   0   15       2.0 74 20 2 11   0 36     0   5   36 38 0   30 0 15     2 74
2571108 WA King   school 5300390 17405   Bellevue School District 530039000096 3167 Woodridge Elementary   Regular School No Elementary PK 05 2020   grade_2 14 3 5   0 37     0   10   44 25 0   18   1   12       2.0 69 14 3 5   0 37     0   10   44 25 0   18 1 12     2 69
2571116 WA Whatcom   school 5300420 37501   Bellingham School District 530042000098 3200 Alderwood Elementary School   Regular School No Elementary PK 05 2020   grade_2 17 1 13   1 1     0   6   21 18 0   13   1   26       1.0 39 17 1 13   1 1     0   6   21 18 0   13 1 26     1 39
2571124 WA Whatcom   school 5300420 37501   Bellingham School District 530042003476 5366 Bellingham Family Partnership Program   Alternative School No Other KG 12 2020   grade_2 35 0 0   0 0     0   3   17 21 0   0   0   2       1.0 38 35 0 0   0 0     0   3   17 21 0   0 0 2     1 38
2571145 WA Whatcom   school 5300420 37501   Bellingham School District 530042000100 2431 Birchwood Elementary School   Regular School No Elementary PK 05 2020   grade_2 21 1 28   0 0     0   3   32 21 0   22   3   37       3.0 53 21 1 28   0 0     0   3   32 21 0   22 3 37     3 53
2571153 WA Whatcom   school 5300420 37501   Bellingham School District 530042000101 2817 Carl Cozier Elementary School   Regular School No Elementary PK 05 2020   grade_2 28 1 6   0 4     0   4   20 23 0   7   3   23       0.0 43 28 1 6   0 4     0   4   20 23 0   7 3 23     0 43
2571160 WA Whatcom   school 5300420 37501   Bellingham School District 530042000103 2365 Columbia Elementary School   Regular School No Elementary PK 05 2020   grade_2 55 0 6   0 0     0   1   40 22 0   2   2   10       2.0 62 55 0 6   0 0     0   1   40 22 0   2 2 10     2 62
2571168 WA Whatcom   school 5300420 37501   Bellingham School District 530042003358 5239 Cordata Elementary School   Regular School No Elementary PK 05 2020   grade_2 21 2 27   2 4     1   7   38 26 0   22   6   45       0.0 64 21 2 27   2 4     1   7   38 26 0   22 6 45     0 64
2571180 WA Whatcom   school 5300420 37501   Bellingham School District 530042000105 2262 Geneva Elementary School   Regular School No Elementary PK 05 2020   grade_2 63 1 9   1 0     1   3   45 33 0   2   0   22       4.0 78 63 1 9   1 0     1   3   45 33 0   2 0 22     4 78
2571188 WA Whatcom   school 5300420 37501   Bellingham School District 530042000106 3134 Happy Valley Elementary School   Regular School No Elementary PK 05 2020   grade_2 37 0 6   1 5     0   10   27 32 0   5   3   15       1.0 59 37 0 6   1 5     0   10   27 32 0   5 3 15     1 59
2571200 WA Whatcom   school 5300420 37501   Bellingham School District 530042000108 2225 Lowell Elementary School   Regular School No Elementary PK 05 2020   grade_2 34 1 3   0 1     0   4   22 21 0   1   1   13       0.0 43 34 1 3   0 1     0   4   22 21 0   1 1 13     0 43
2571208 WA Whatcom   school 5300420 37501   Bellingham School District 530042002939 4571 Northern Heights Elementary Schl   Regular School No Elementary PK 05 2020   grade_2 42 1 13   1 4     0   9   37 32 1   4   4   20       4.0 70 42 1 13   1 4     0   9   37 32 1   4 4 20     4 70
2571221 WA Whatcom   school 5300420 37501   Bellingham School District 530042000110 3202 Parkview Elementary School   Regular School No Elementary PK 05 2020   grade_2 37 0 7   0 1     0   6   29 22 0   4   2   14       3.0 51 37 0 7   0 1     0   6   29 22 0   4 2 14     3 51
2571229 WA Whatcom   school 5300420 37501   Bellingham School District 530042000112 2067 Roosevelt Elementary School   Regular School No Elementary PK 05 2020   grade_2 33 1 10   1 2     0   9   31 25 0   8   1   32       1.0 56 33 1 10   1 2     0   9   31 25 0   8 1 32     1 56
2571247 WA Whatcom   school 5300420 37501   Bellingham School District 530042000115 2175 Silver Beach Elementary School   Regular School No Elementary PK 05 2020   grade_2 61 0 5   0 2     0   11   41 38 0   1   1   16       4.0 79 61 0 5   0 2     0   11   41 38 0   1 1 16     4 79
2571260 WA Whatcom   school 5300420 37501   Bellingham School District 530042000116 2387 Sunnyland Elementary School   Regular School No Elementary PK 05 2020   grade_2 26 0 19   0 4     0   4   28 25 0   10   2   23       2.0 53 26 0 19   0 4     0   4   28 25 0   10 2 23     2 53
2571274 WA Whatcom   school 5300420 37501   Bellingham School District 530042003225 5125 Wade King Elementary School   Regular School No Elementary PK 05 2020   grade_2 53 1 7   0 5     0   2   37 31 0   4   0   14       2.0 68 53 1 7   0 5     0   2   37 31 0   4 0 14     2 68
2571286 WA Adams   school 5300450 1122   Benge School District 530045000118 3142 Benge Elementary   Regular School No Elementary KG 06 2020   grade_2 1 0 0   0 0     0   0   1 0 0   0   0   0       0.0 1 1 0 0   0 0     0   0   1 0 0   0 0 0     0 1
2571296 WA Pierce   school 5300480 27403   Bethel School District 530048003624 5471 Bethel Elementary Learning Academy   Regular School No Elementary KG 05 2020   grade_2 1 1 1   0 0     0   1   1 3 0   0   0   3       0.0 4 1 1 1   0 0     0   1   1 3 0   0 0 3     0 4
2571311 WA Pierce   school 5300480 27403   Bethel School District 530048002202 4296 Camas Prairie Elementary   Regular School No Elementary KG 05 2020   grade_2 42 8 21   0 5     4   10   44 46 0   11   5   61       1.0 90 42 8 21   0 5     4   10   44 46 0   11 5 61     1 90
2571322 WA Pierce   school 5300480 27403   Bethel School District 530048002250 4331 Centennial Elementary   Regular School No Elementary KG 05 2020   grade_2 60 1 14   0 0     1   16   41 51 0   3   5   49       1.0 92 60 1 14   0 0     1   16   41 51 0   3 5 49     1 92
2571334 WA Pierce   school 5300480 27403   Bethel School District 530048000121 3649 Chester H Thompson Elementary   Regular School No Elementary KG 05 2020   grade_2 43 3 39   1 3     6   33   63 65 0   21   2   83       1.0 128 43 3 39   1 3     6   33   63 65 0   21 2 83     1 128
2571341 WA Pierce   school 5300480 27403   Bethel School District 530048000122 2576 Clover Creek Elementary   Regular School No Elementary KG 05 2020   grade_2 55 12 28   1 13     5   23   79 58 0   8   1   68       0.0 137 55 12 28   1 13     5   23   79 58 0   8 1 68     0 137
2571353 WA Pierce   school 5300480 27403   Bethel School District 530048000123 2877 Elk Plain School of Choice   Regular School No Elementary KG 08 2020   grade_2 21 2 6   0 1     1   13   25 19 0   1   0   17       1.0 44 21 2 6   0 1     1   13   25 19 0   1 0 17     1 44
2571363 WA Pierce   school 5300480 27403   Bethel School District 530048001748 4099 Evergreen Elementary   Regular School No Elementary KG 05 2020   grade_2 31 9 24   1 4     8   18   52 43 0   8   2   59       1.0 95 31 9 24   1 4     8   18   52 43 0   8 2 59     1 95
2571370 WA Pierce   school 5300480 27403   Bethel School District 530048003272 5159 Frederickson Elementary   Regular School No Elementary KG 05 2020   grade_2 33 5 30   0 4     3   24   46 53 0   10   2   49       1.0 99 33 5 30   0 4     3   24   46 53 0   10 2 49     1 99
2571381 WA Pierce   school 5300480 27403   Bethel School District 530048002203 4297 Graham Elementary   Regular School No Elementary KG 05 2020   grade_2 72 3 17   0 1     1   21   62 53 0   5   0   44       0.0 115 72 3 17   0 1     1   21   62 53 0   5 0 44     0 115
2571394 WA Pierce   school 5300480 27403   Bethel School District 530048000124 2748 Kapowsin Elementary   Regular School No Elementary KG 05 2020   grade_2 39 2 9   0 0     1   1   23 29 0   4   3   24       0.0 52 39 2 9   0 0     1   1   23 29 0   4 3 24     0 52
2571405 WA Pierce   school 5300480 27403   Bethel School District 530048001749 4102 Naches Trail Elementary   Regular School No Elementary KG 05 2020   grade_2 39 6 15   0 4     5   14   45 38 0   12   4   51       0.0 83 39 6 15   0 4     5   14   45 38 0   12 4 51     0 83
2571412 WA Pierce   school 5300480 27403   Bethel School District 530048003288 5160 Nelson Elementary School   Regular School No Elementary KG 05 2020   grade_2 62 5 17   0 5     6   17   63 49 0   13   0   41       1.0 112 62 5 17   0 5     6   17   63 49 0   13 0 41     1 112
2571419 WA Pierce   school 5300480 27403   Bethel School District 530048002747 4538 North Star Elementary   Regular School No Elementary KG 05 2020   grade_2 48 3 13   1 2     1   17   36 49 0   4   3   46       6.0 85 48 3 13   1 2     1   17   36 49 0   4 3 46     6 85
2571430 WA Pierce   school 5300480 27403   Bethel School District 530048002430 4381 Pioneer Valley Elementary   Regular School No Elementary KG 05 2020   grade_2 46 2 12   0 3     4   9   39 37 0   5   0   39       1.0 76 46 2 12   0 3     4   9   39 37 0   5 0 39     1 76
2571437 WA Pierce   school 5300480 27403   Bethel School District 530048001925 4227 Rocky Ridge Elementary   Regular School No Elementary KG 05 2020   grade_2 54 1 8   0 1     2   4   39 31 0   6   0   43       0.0 70 54 1 8   0 1     2   4   39 31 0   6 0 43     0 70
2571444 WA Pierce   school 5300480 27403   Bethel School District 530048000126 2543 Roy Elementary   Regular School No Elementary KG 05 2020   grade_2 46 1 5   0 1     1   4   36 22 0   2   1   40       1.0 58 46 1 5   0 1     1   4   36 22 0   2 1 40     1 58
2571452 WA Pierce   school 5300480 27403   Bethel School District 530048001750 4103 Shining Mountain Elementary   Regular School No Elementary KG 05 2020   grade_2 51 4 34   0 6     8   31   75 59 0   16   1   85       0.0 134 51 4 34   0 6     8   31   75 59 0   16 1 85     0 134
2571459 WA Pierce   school 5300480 27403   Bethel School District 530048000127 2399 Spanaway Elementary   Regular School No Elementary KG 05 2020   grade_2 23 3 22   0 0     4   16   32 36 0   13   2   46       0.0 68 23 3 22   0 0     4   16   32 36 0   13 2 46     0 68
2571480 WA Klickitat   school 5300510 20203   Bickleton School District 530051000129 3392 Bickleton Elementary & High Schl   Regular School No Other KG 12 2020   grade_2 10 0 2   0 0     0   1   5 8 0   0   0   6       0.0 13 10 0 2   0 0     0   1   5 8 0   0 0 6     0 13
2571501 WA Whatcom   school 5300570 37503   Blaine School District 530057003020 5021 Blaine Home Connections   Alternative School No Other KG 11 2020   grade_2 1 0 0   0 1     0   0   1 1 0   0   0   0       0.0 2 1 0 0   0 1     0   0   1 1 0   0 0 0     0 2

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