Data source: Big Local News · About: Big Local

1,263 rows where grade = "grade_2", state = "WA" and year = 2019

View and edit SQL

year

  • 2019 · 1,263

grade

  • grade_2 · 1,263
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
2412993 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000001 2834 A J West Elementary   Regular School No Elementary PK 06 2019   grade_2 31 0 19   0 0     0   8   29 29 0   12   2   46       2.0 58 31 0 19   0 0     0   8   29 29 0   12 2 46     2 58
2413003 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000005 3216 Central Park Elementary   Regular School No Elementary KG 06 2019   grade_2 14 0 1   0 0     0   1   9 7 0   0   0   11       1.0 16 14 0 1   0 0     0   1   9 7 0   0 0 11     1 16
2413035 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000008 2449 McDermoth Elementary   Regular School No Elementary KG 06 2019   grade_2 24 1 12   2 1     0   6   19 27 0   10   1   38       2.0 46 24 1 12   2 1     0   6   19 27 0   10 1 38     2 46
2413047 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000010 2763 Robert Gray Elementary   Regular School No Elementary PK 06 2019   grade_2 25 0 18   0 0     0   1   22 22 0   8   1   34       3.0 44 25 0 18   0 0     0   1   22 22 0   8 1 34     3 44
2413055 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000011 2971 Stevens Elementary School   Regular School No Elementary PK 06 2019   grade_2 27 0 26   1 0     0   7   28 33 0   25   4   55       0.0 61 27 0 26   1 0     0   7   28 33 0   25 4 55     0 61
2413067 WA Lewis   school 5300060 21226   Adna School District 530006000012 2227 Adna Elementary School   Regular School No Elementary PK 05 2019   grade_2 37 1 2   0 0     0   0   15 25 0   0   1   14       0.0 40 37 1 2   0 0     0   0   15 25 0   0 1 14     0 40
2413083 WA Lincoln   school 5300090 22017   Almira School District 530009000179 2860 Almira Elementary School   Regular School No Elementary PK 08 2019   grade_2 11 0 0   0 0     0   0   6 5 0   0   0   1       1.0 11 11 0 0   0 0     0   0   6 5 0   0 0 1     1 11
2413108 WA Skagit   school 5300150 29103   Anacortes School District 530015000017 3182 Fidalgo Elementary   Regular School No Elementary KG 05 2019   grade_2 39 0 6   0 1     0   1   24 23 0   2   0   10       1.0 47 39 0 6   0 1     0   1   24 23 0   2 0 10     1 47
2413115 WA Skagit   school 5300150 29103   Anacortes School District 530015000018 3252 Island View Elementary   Regular School No Elementary KG 05 2019   grade_2 55 1 7   1 3     0   3   35 35 0   1   1   28       3.0 70 55 1 7   1 3     0   3   35 35 0   1 1 28     3 70
2413122 WA Skagit   school 5300150 29103   Anacortes School District 530015000019 3057 Mount Erie Elementary   Regular School No Elementary KG 05 2019   grade_2 39 0 4   0 0     0   3   23 23 0   2   2   13       0.0 46 39 0 4   0 0     0   3   23 23 0   2 2 13     0 46
2413141 WA Snohomish   school 5300240 31016   Arlington School District 530024003065 2277 Arlington Special Educ School   Regular School No Other PK 12 2019   grade_2 1 0 0   0 0     0   0   0 1 0   0   0   0       0.0 1 1 0 0   0 0     0   0   0 1 0   0 0 0     0 1
2413146 WA Snohomish   school 5300240 31016   Arlington School District 530024002248 4327 Eagle Creek Elementary   Regular School No Elementary KG 05 2019   grade_2 72 0 24   1 2     0   5   53 51 0   15   5   46       1.0 104 72 0 24   1 2     0   5   53 51 0   15 5 46     1 104
2413159 WA Snohomish   school 5300240 31016   Arlington School District 530024001190 4436 Kent Prairie Elementary   Regular School No Elementary PK 05 2019   grade_2 84 0 12   2 2     1   11   63 49 0   8   3   37       2.0 112 84 0 12   2 2     1   11   63 49 0   8 3 37     2 112
2413167 WA Snohomish   school 5300240 31016   Arlington School District 530024002940 4573 Pioneer Elementary   Regular School No Elementary KG 05 2019   grade_2 58 0 19   0 2     0   13   48 44 0   6   3   32       0.0 92 58 0 19   0 2     0   13   48 44 0   6 3 32     0 92
2413179 WA Snohomish   school 5300240 31016   Arlington School District 530024001815 4154 Presidents Elementary   Regular School No Elementary PK 05 2019   grade_2 61 0 10   1 0     0   5   39 38 0   3   2   30       1.0 77 61 0 10   1 0     0   5   39 38 0   3 2 30     1 77
2413187 WA Snohomish   school 5300240 31016   Arlington School District 530024002589 1714 Stillaguamish Valley Learning Center   Alternative School No Elementary KG 08 2019   grade_2 4 0 4   0 0     0   0   1 7 0   0   0   2       0.0 8 4 0 4   0 0     0   0   1 7 0   0 0 2     0 8
2413202 WA Asotin   school 5300280 2420   Asotin-Anatone School District 530028000027 2507 Asotin Elementary   Regular School No Elementary PK 05 2019   grade_2 44 0 4   0 0     0   1   29 20 0   0   0   18       1.0 49 44 0 4   0 0     0   1   29 20 0   0 0 18     1 49
2413218 WA King   school 5300300 17408   Auburn School District 530030000029 3825 Alpac Elementary School   Regular School No Elementary PK 05 2019   grade_2 52 4 27   0 11     1   15   59 51 0   28   1   58       2.0 110 52 4 27   0 11     1   15   59 51 0   28 1 58     2 110
2413226 WA King   school 5300300 17408   Auburn School District 530030003174 5082 Arthur Jacobsen Elementary   Regular School No Elementary PK 05 2019   grade_2 33 4 26   0 14     2   10   54 35 0   25   1   45       3.0 89 33 4 26   0 14     2   10   54 35 0   25 1 45     3 89
2413257 WA King   school 5300300 17408   Auburn School District 530030000034 3439 Chinook Elementary School   Regular School No Elementary PK 05 2019   grade_2 15 5 26   14 4     3   13   43 37 0   27   0   56       1.0 80 15 5 26   14 4     3   13   43 37 0   27 0 56     1 80
2413265 WA King   school 5300300 17408   Auburn School District 530030000037 2932 Dick Scobee Elementary School   Regular School No Elementary PK 05 2019   grade_2 26 6 28   1 4     10   11   45 41 0   33   5   69       2.0 86 26 6 28   1 4     10   11   45 41 0   33 5 69     2 86
2413273 WA King   school 5300300 17408   Auburn School District 530030000035 3745 Evergreen Heights Elementary   Regular School No Elementary KG 05 2019   grade_2 30 8 33   0 17     3   17   50 58 0   32   2   52       4.0 108 30 8 33   0 17     3   17   50 58 0   32 2 52     4 108
2413280 WA King   school 5300300 17408   Auburn School District 530030000040 3669 Gildo Rey Elementary School   Regular School No Elementary PK 05 2019   grade_2 20 4 66   0 3     6   9   54 54 0   55   2   78       2.0 108 20 4 66   0 3     6   9   54 54 0   55 2 78     2 108
2413288 WA King   school 5300300 17408   Auburn School District 530030002277 4347 Hazelwood Elementary School   Regular School No Elementary KG 05 2019   grade_2 38 8 17   2 9     1   7   38 44 0   16   0   38       2.0 82 38 8 17   2 9     1   7   38 44 0   16 0 38     2 82
2413295 WA King   school 5300300 17408   Auburn School District 530030000698 4417 Ilalko Elementary School   Regular School No Elementary PK 05 2019   grade_2 34 6 32   0 12     3   17   51 53 0   32   2   61       3.0 104 34 6 32   0 12     3   17   51 53 0   32 2 61     3 104
2413303 WA King   school 5300300 17408   Auburn School District 530030001744 4120 Lake View Elementary School   Regular School No Elementary PK 05 2019   grade_2 39 0 19   0 0     1   6   31 34 0   12   0   30       1.0 65 39 0 19   0 0     1   6   31 34 0   12 0 30     1 65
2413311 WA King   school 5300300 17408   Auburn School District 530030003063 5051 Lakeland Hills Elementary   Regular School No Elementary KG 05 2019   grade_2 44 11 19   1 21     0   16   64 48 0   23   0   24       4.0 112 44 11 19   1 21     0   16   64 48 0   23 0 24     4 112
2413319 WA King   school 5300300 17408   Auburn School District 530030000036 3525 Lea Hill Elementary School   Regular School No Elementary PK 05 2019   grade_2 47 21 13   0 15     9   12   56 61 0   41   0   85       2.0 117 47 21 13   0 15     9   12   56 61 0   41 0 85     2 117
2413335 WA King   school 5300300 17408   Auburn School District 530030000039 3227 Pioneer Elementary School   Regular School No Elementary PK 05 2019   grade_2 14 0 47   0 3     0   3   39 28 0   47   3   54       1.0 67 14 0 47   0 3     0   3   39 28 0   47 3 54     1 67
2413357 WA King   school 5300300 17408   Auburn School District 530030000041 2659 Terminal Park Elementary School   Regular School No Elementary KG 05 2019   grade_2 18 8 30   0 3     5   16   47 33 0   30   3   64       1.0 80 18 8 30   0 3     5   16   47 33 0   30 3 64     1 80
2413365 WA King   school 5300300 17408   Auburn School District 530030000042 2326 Washington Elementary School   Regular School No Elementary PK 05 2019   grade_2 26 8 36   0 5     16   8   56 43 0   28   6   71       2.0 99 26 8 36   0 5     16   8   56 43 0   28 6 71     2 99
2413384 WA Kitsap   school 5300330 18303   Bainbridge Island School District 530033003113 1939 Bainbridge Special Education Services   Special Education School No Other PK 12 2019   grade_2 2 0 0   0 0     0   0   1 1 0   0   0   0       0.0 2 2 0 0   0 0     0   0   1 1 0   0 0 0     0 2
2413394 WA Kitsap   school 5300330 18303   Bainbridge Island School District 530033000045 3552 Capt Johnston Blakely Elem Sch   Regular School No Elementary KG 04 2019   grade_2 52 0 4   0 1     0   3   38 22 0   2   0   2       9.0 60 52 0 4   0 1     0   3   38 22 0   2 0 2     9 60
2413400 WA Kitsap   school 5300330 18303   Bainbridge Island School District 530033000044 3043 Capt. Charles Wilkes Elem School   Regular School No Elementary PK 04 2019   grade_2 56 0 8   0 4     0   6   35 39 0   2   0   0       8.0 74 56 0 8   0 4     0   6   35 39 0   2 0 0     8 74
2413412 WA Kitsap   school 5300330 18303   Bainbridge Island School District 530033002802 1841 Mosaic Home Education Partnership   Alternative School No Elementary KG 08 2019   grade_2 7 0 0   0 0     0   2   6 3 0   0   0   1       0.0 9 7 0 0   0 0     0   2   6 3 0   0 0 1     0 9
2413422 WA Kitsap   school 5300330 18303   Bainbridge Island School District 530033002523 1699 Odyssey Multiage Program   Regular School No Elementary KG 08 2019   grade_2 16 0 0   0 0     0   4   11 9 0   0   0   0       3.0 20 16 0 0   0 0     0   4   11 9 0   0 0 0     3 20
2413432 WA Kitsap   school 5300330 18303   Bainbridge Island School District 530033000047 4062 Ordway Elementary   Regular School No Elementary PK 04 2019   grade_2 45 1 9   0 1     1   6   34 29 0   2   0   9       8.0 63 45 1 9   0 1     1   6   34 29 0   2 0 9     8 63
2413471 WA Clark   school 5300380 6119   Battle Ground School District 530038002278 4352 Captain Strong   Regular School No Elementary PK 04 2019   grade_2 96 0 10   1 2     1   12   66 56 0   13   3   60       0.0 122 96 0 10   1 2     1   12   66 56 0   13 3 60     0 122
2413488 WA Clark   school 5300380 6119   Battle Ground School District 530038003194 5090 Daybreak Primary   Regular School No Elementary PK 04 2019   grade_2 81 4 12   0 1     0   3   58 43 0   14   2   44       6.0 101 81 4 12   0 1     0   3   58 43 0   14 2 44     6 101
2413500 WA Clark   school 5300380 6119   Battle Ground School District 530038000051 3018 Glenwood Heights Primary   Regular School No Elementary PK 04 2019   grade_2 96 0 25   0 6     0   12   58 81 0   35   3   55       4.0 139 96 0 25   0 6     0   12   58 81 0   35 3 55     4 139
2413510 WA Clark   school 5300380 6119   Battle Ground School District 530038002857 1875 Homelink River   Alternative School No Other KG 12 2019   grade_2 57 1 5   2 1     0   4   36 34 0   11   1   21       1.0 70 57 1 5   2 1     0   4   36 34 0   11 1 21     1 70
2413526 WA Clark   school 5300380 6119   Battle Ground School District 530038003409 5291 Maple Grove K-8 (Closed after 2018-2019 school year)   Regular School No Elementary PK 08 2019   grade_2 46 0 7   0 0     0   5   31 27 0   5   0   21       0.0 58 46 0 7   0 0     0   5   31 27 0   5 0 21     0 58
2413544 WA Clark   school 5300380 6119   Battle Ground School District 530038000055 3996 Pleasant Valley Primary   Regular School No Elementary PK 04 2019   grade_2 78 4 17   0 4     1   5   60 49 0   19   4   41       5.0 109 78 4 17   0 4     1   5   60 49 0   19 4 41     5 109
2413567 WA Clark   school 5300380 6119   Battle Ground School District 530038003228 5132 Tukes Valley Primary   Regular School No Elementary PK 04 2019   grade_2 101 1 10   0 0     0   4   63 53 0   7   0   37       2.0 116 101 1 10   0 0     0   4   63 53 0   7 0 37     2 116
2413574 WA Clark   school 5300380 6119   Battle Ground School District 530038000056 2910 Yacolt Primary   Regular School No Elementary PK 04 2019   grade_2 136 0 4   1 1     1   5   75 73 0   1   1   54       5.0 148 136 0 4   1 1     1   5   75 73 0   1 1 54     5 148
2413581 WA King   school 5300390 17405   Bellevue School District 530039000058 3633 Ardmore Elementary School   Regular School No Elementary PK 05 2019   grade_2 21 7 17   1 21     0   3   39 31 0   28   1   30       2.0 70 21 7 17   1 21     0   3   39 31 0   28 1 30     2 70
2413602 WA King   school 5300390 17405   Bellevue School District 530039000062 3705 Bennett Elementary School   Regular School No Elementary PK 05 2019   grade_2 26 3 7   0 40     0   8   46 38 0   14   0   8       3.0 84 26 3 7   0 40     0   8   46 38 0   14 0 8     3 84
2413626 WA King   school 5300390 17405   Bellevue School District 530039000063 3742 Cherry Crest Elementary School   Regular School No Elementary PK 05 2019   grade_2 30 1 3   1 75     0   2   51 61 0   13   1   1       1.0 112 30 1 3   1 75     0   2   51 61 0   13 1 1     1 112
2413638 WA King   school 5300390 17405   Bellevue School District 530039000065 2847 Clyde Hill Elementary   Regular School No Elementary PK 05 2019   grade_2 20 1 3   0 35     0   5   43 21 0   22   0   6       1.0 64 20 1 3   0 35     0   5   43 21 0   22 0 6     1 64
2413646 WA King   school 5300390 17405   Bellevue School District 530039000066 3036 Eastgate Elementary School   Regular School No Elementary PK 05 2019   grade_2 15 1 8   0 27     0   6   29 28 0   12   0   9       2.0 57 15 1 8   0 27     0   6   29 28 0   12 0 9     2 57
2413654 WA King   school 5300390 17405   Bellevue School District 530039000067 2846 Enatai Elementary School   Regular School No Elementary PK 05 2019   grade_2 45 3 8   0 21     0   9   41 45 0   19   2   13       2.0 86 45 3 8   0 21     0   9   41 45 0   19 2 13     2 86
2413679 WA King   school 5300390 17405   Bellevue School District 530039003455 5308 Jing Mei Elementary School   Regular School No Elementary PK 05 2019   grade_2 8 2 3   0 46     0   15   46 28 0   21   1   4       0.0 74 8 2 3   0 46     0   15   46 28 0   21 1 4     0 74
2413687 WA King   school 5300390 17405   Bellevue School District 530039000075 3225 Lake Hills Elementary   Regular School No Elementary PK 05 2019   grade_2 27 3 39   0 15     1   7   41 51 0   48   1   54       2.0 92 27 3 39   0 15     1   7   41 51 0   48 1 54     2 92
2413695 WA King   school 5300390 17405   Bellevue School District 530039000076 3436 Medina Elementary School   Regular School No Elementary PK 05 2019   grade_2 23 1 4   1 58     0   5   39 53 0   10   0   0       3.0 92 23 1 4   1 58     0   5   39 53 0   10 0 0     3 92
2413703 WA King   school 5300390 17405   Bellevue School District 530039000077 3437 Newport Heights Elementary   Regular School No Elementary PK 05 2019   grade_2 32 2 7   0 28     0   10   38 41 0   21   3   16       6.0 79 32 2 7   0 28     0   10   38 41 0   21 3 16     6 79
2413720 WA King   school 5300390 17405   Bellevue School District 530039000082 3168 Phantom Lake Elementary   Regular School No Elementary PK 05 2019   grade_2 24 0 4   0 12     0   7   24 23 0   15   0   14       1.0 47 24 0 4   0 12     0   7   24 23 0   15 0 14     1 47
2413728 WA King   school 5300390 17405   Bellevue School District 530039000090 3224 Puesta del Sol Elementary School   Regular School No Elementary PK 05 2019   grade_2 41 1 20   1 14     1   16   53 41 0   6   0   5       5.0 94 41 1 20   1 14     1   16   53 41 0   6 0 5     5 94
2413741 WA King   school 5300390 17405   Bellevue School District 530039000086 3339 Sherwood Forest Elementary   Regular School No Elementary PK 05 2019   grade_2 18 3 31   1 11     0   3   38 29 0   29   2   30       2.0 67 18 3 31   1 11     0   3   38 29 0   29 2 30     2 67
2413750 WA King   school 5300390 17405   Bellevue School District 530039000087 3789 Somerset Elementary School   Regular School No Elementary KG 05 2019   grade_2 25 0 5   0 74     0   6   52 58 0   21   0   9       2.0 110 25 0 5   0 74     0   6   52 58 0   21 0 9     2 110
2413757 WA King   school 5300390 17405   Bellevue School District 530039000088 3634 Spiritridge Elementary School   Regular School No Elementary KG 05 2019   grade_2 33 5 7   1 54     0   18   73 45 0   10   0   11       6.0 118 33 5 7   1 54     0   18   73 45 0   10 0 11     6 118
2413764 WA King   school 5300390 17405   Bellevue School District 530039000089 3100 Stevenson Elementary   Regular School No Elementary PK 05 2019   grade_2 5 2 32   0 55     3   4   47 54 0   54   2   40       2.0 101 5 2 32   0 55     3   4   47 54 0   54 2 40     2 101
2413780 WA King   school 5300390 17405   Bellevue School District 530039003638 5508 Wilburton Elementary School   Regular School No Elementary PK 05 2019   grade_2 23 0 10   0 30     0   4   27 40 0   22   0   11       0.0 67 23 0 10   0 30     0   4   27 40 0   22 0 11     0 67
2413788 WA King   school 5300390 17405   Bellevue School District 530039000096 3167 Woodridge Elementary   Regular School No Elementary KG 05 2019   grade_2 33 5 3   0 35     0   7   45 38 0   21   1   18       2.0 83 33 5 3   0 35     0   7   45 38 0   21 1 18     2 83
2413796 WA Whatcom   school 5300420 37501   Bellingham School District 530042000098 3200 Alderwood Elementary School   Regular School No Elementary PK 05 2019   grade_2 17 0 11   0 2     0   5   14 21 0   10   3   28       0.0 35 17 0 11   0 2     0   5   14 21 0   10 3 28     0 35
2413804 WA Whatcom   school 5300420 37501   Bellingham School District 530042003476 5366 Bellingham Family Partnership Program   Alternative School No Other KG 12 2019   grade_2 30 0 1   0 1     0   3   24 11 0   1   0   1       3.0 35 30 0 1   0 1     0   3   24 11 0   1 0 1     3 35
2413824 WA Whatcom   school 5300420 37501   Bellingham School District 530042000100 2431 Birchwood Elementary School   Regular School No Elementary PK 05 2019   grade_2 25 0 20   0 1     0   5   28 23 0   16   1   32       3.0 51 25 0 20   0 1     0   5   28 23 0   16 1 32     3 51
2413832 WA Whatcom   school 5300420 37501   Bellingham School District 530042000101 2817 Carl Cozier Elementary School   Regular School No Elementary PK 05 2019   grade_2 28 2 8   0 5     2   7   26 26 0   4   3   25       3.0 52 28 2 8   0 5     2   7   26 26 0   4 3 25     3 52
2413839 WA Whatcom   school 5300420 37501   Bellingham School District 530042000103 2365 Columbia Elementary School   Regular School No Elementary PK 05 2019   grade_2 46 0 1   1 3     0   3   31 23 0   2   1   15       4.0 54 46 0 1   1 3     0   3   31 23 0   2 1 15     4 54
2413847 WA Whatcom   school 5300420 37501   Bellingham School District 530042003358 5239 Cordata Elementary School   Regular School No Elementary PK 05 2019   grade_2 26 4 13   0 9     2   5   29 30 0   18   8   47       2.0 59 26 4 13   0 9     2   5   29 30 0   18 8 47     2 59
2413860 WA Whatcom   school 5300420 37501   Bellingham School District 530042000105 2262 Geneva Elementary School   Regular School No Elementary PK 05 2019   grade_2 66 1 8   1 0     1   2   35 44 0   4   0   24       4.0 79 66 1 8   1 0     1   2   35 44 0   4 0 24     4 79
2413868 WA Whatcom   school 5300420 37501   Bellingham School District 530042000106 3134 Happy Valley Elementary School   Regular School No Elementary PK 05 2019   grade_2 57 1 8   0 1     0   6   41 32 0   8   4   18       4.0 73 57 1 8   0 1     0   6   41 32 0   8 4 18     4 73
2413880 WA Whatcom   school 5300420 37501   Bellingham School District 530042000108 2225 Lowell Elementary School   Regular School No Elementary PK 05 2019   grade_2 39 1 2   0 2     0   5   24 25 0   1   4   17       2.0 49 39 1 2   0 2     0   5   24 25 0   1 4 17     2 49
2413887 WA Whatcom   school 5300420 37501   Bellingham School District 530042002939 4571 Northern Heights Elementary Schl   Regular School No Elementary PK 05 2019   grade_2 33 1 13   1 4     1   9   34 28 0   9   1   31       4.0 62 33 1 13   1 4     1   9   34 28 0   9 1 31     4 62
2413901 WA Whatcom   school 5300420 37501   Bellingham School District 530042000110 3202 Parkview Elementary School   Regular School No Elementary PK 05 2019   grade_2 41 1 7   0 1     0   6   30 26 0   0   6   25       3.0 56 41 1 7   0 1     0   6   30 26 0   0 6 25     3 56
2413908 WA Whatcom   school 5300420 37501   Bellingham School District 530042000112 2067 Roosevelt Elementary School   Regular School No Elementary PK 05 2019   grade_2 42 1 15   0 1     0   5   30 34 0   7   1   27       1.0 64 42 1 15   0 1     0   5   30 34 0   7 1 27     1 64
2413925 WA Whatcom   school 5300420 37501   Bellingham School District 530042000115 2175 Silver Beach Elementary School   Regular School No Elementary PK 05 2019   grade_2 67 0 9   1 3     0   12   52 40 0   1   0   20       2.0 92 67 0 9   1 3     0   12   52 40 0   1 0 20     2 92
2413938 WA Whatcom   school 5300420 37501   Bellingham School District 530042000116 2387 Sunnyland Elementary School   Regular School No Elementary PK 05 2019   grade_2 35 0 5   0 2     0   3   25 20 0   5   2   16       2.0 45 35 0 5   0 2     0   3   25 20 0   5 2 16     2 45
2413951 WA Whatcom   school 5300420 37501   Bellingham School District 530042003225 5125 Wade King Elementary School   Regular School No Elementary PK 05 2019   grade_2 53 1 5   0 5     0   7   33 38 0   4   1   13       2.0 71 53 1 5   0 5     0   7   33 38 0   4 1 13     2 71
2413963 WA Adams   school 5300450 1122   Benge School District 530045000118 3142 Benge Elementary   Regular School No Elementary KG 06 2019   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
2413975 WA Pierce   school 5300480 27403   Bethel School District 530048003624 5471 Bethel Elementary Learning Academy   Regular School No Elementary KG 05 2019   grade_2 3 0 1   0 0     0   0   2 2 0   0   0   1       0.0 4 3 0 1   0 0     0   0   2 2 0   0 0 1     0 4
2413991 WA Pierce   school 5300480 27403   Bethel School District 530048002202 4296 Camas Prairie Elementary   Regular School No Elementary KG 05 2019   grade_2 43 8 16   3 5     6   19   63 37 0   9   0   64       4.0 100 43 8 16   3 5     6   19   63 37 0   9 0 64     4 100
2414004 WA Pierce   school 5300480 27403   Bethel School District 530048002250 4331 Centennial Elementary   Regular School No Elementary KG 05 2019   grade_2 51 2 10   1 1     2   11   41 37 0   3   2   52       2.0 78 51 2 10   1 1     2   11   41 37 0   3 2 52     2 78
2414016 WA Pierce   school 5300480 27403   Bethel School District 530048000121 3649 Chester H Thompson Elementary   Regular School No Elementary KG 05 2019   grade_2 38 7 47   2 2     9   8   52 61 0   33   4   83       0.0 113 38 7 47   2 2     9   8   52 61 0   33 4 83     0 113
2414023 WA Pierce   school 5300480 27403   Bethel School District 530048000122 2576 Clover Creek Elementary   Regular School No Elementary KG 05 2019   grade_2 52 16 24   1 12     6   19   64 66 0   13   3   71       1.0 130 52 16 24   1 12     6   19   64 66 0   13 3 71     1 130
2414034 WA Pierce   school 5300480 27403   Bethel School District 530048000123 2877 Elk Plain School of Choice   Regular School No Elementary KG 08 2019   grade_2 47 2 7   0 1     0   18   40 35 0   1   2   22       1.0 75 47 2 7   0 1     0   18   40 35 0   1 2 22     1 75
2414044 WA Pierce   school 5300480 27403   Bethel School District 530048001748 4099 Evergreen Elementary   Regular School No Elementary KG 05 2019   grade_2 31 8 16   0 4     4   15   37 41 0   5   1   42       2.0 78 31 8 16   0 4     4   15   37 41 0   5 1 42     2 78
2414051 WA Pierce   school 5300480 27403   Bethel School District 530048003272 5159 Frederickson Elementary   Regular School No Elementary KG 05 2019   grade_2 55 9 24   0 6     4   12   54 56 0   13   4   48       2.0 110 55 9 24   0 6     4   12   54 56 0   13 4 48     2 110
2414062 WA Pierce   school 5300480 27403   Bethel School District 530048002203 4297 Graham Elementary   Regular School No Elementary KG 05 2019   grade_2 66 5 20   0 3     1   20   61 54 0   4   2   44       5.0 115 66 5 20   0 3     1   20   61 54 0   4 2 44     5 115
2414074 WA Pierce   school 5300480 27403   Bethel School District 530048000124 2748 Kapowsin Elementary   Regular School No Elementary KG 05 2019   grade_2 54 1 9   0 1     0   7   42 30 0   3   2   27       0.0 72 54 1 9   0 1     0   7   42 30 0   3 2 27     0 72
2414085 WA Pierce   school 5300480 27403   Bethel School District 530048001749 4102 Naches Trail Elementary   Regular School No Elementary KG 05 2019   grade_2 41 9 15   2 2     1   12   39 43 0   2   2   50       1.0 82 41 9 15   2 2     1   12   39 43 0   2 2 50     1 82
2414092 WA Pierce   school 5300480 27403   Bethel School District 530048003288 5160 Nelson Elementary School   Regular School No Elementary KG 05 2019   grade_2 55 3 16   0 3     1   14   42 50 0   4   2   37       0.0 92 55 3 16   0 3     1   14   42 50 0   4 2 37     0 92
2414099 WA Pierce   school 5300480 27403   Bethel School District 530048002747 4538 North Star Elementary   Regular School No Elementary KG 05 2019   grade_2 48 3 13   0 0     2   15   43 38 0   2   5   37       1.0 81 48 3 13   0 0     2   15   43 38 0   2 5 37     1 81
2414110 WA Pierce   school 5300480 27403   Bethel School District 530048002430 4381 Pioneer Valley Elementary   Regular School No Elementary KG 05 2019   grade_2 38 4 15   1 1     3   14   43 33 0   9   2   34       1.0 76 38 4 15   1 1     3   14   43 33 0   9 2 34     1 76
2414118 WA Pierce   school 5300480 27403   Bethel School District 530048001925 4227 Rocky Ridge Elementary   Regular School No Elementary KG 05 2019   grade_2 50 0 13   0 0     2   5   40 30 0   4   0   44       1.0 70 50 0 13   0 0     2   5   40 30 0   4 0 44     1 70
2414125 WA Pierce   school 5300480 27403   Bethel School District 530048000126 2543 Roy Elementary   Regular School No Elementary KG 05 2019   grade_2 39 2 3   0 2     0   7   26 27 0   1   4   30       0.0 53 39 2 3   0 2     0   7   26 27 0   1 4 30     0 53
2414132 WA Pierce   school 5300480 27403   Bethel School District 530048001750 4103 Shining Mountain Elementary   Regular School No Elementary KG 05 2019   grade_2 49 12 35   0 3     5   20   70 54 0   11   7   78       1.0 124 49 12 35   0 3     5   20   70 54 0   11 7 78     1 124
2414140 WA Pierce   school 5300480 27403   Bethel School District 530048000127 2399 Spanaway Elementary   Regular School No Elementary KG 05 2019   grade_2 28 8 16   0 2     1   14   43 26 0   12   3   46       1.0 69 28 8 16   0 2     1   14   43 26 0   12 3 46     1 69
2414161 WA Klickitat   school 5300510 20203   Bickleton School District 530051000129 3392 Bickleton Elementary & High Schl   Regular School No Other KG 12 2019   grade_2 4 0 5   0 0     0   0   5 4 0   0   1   3       0.0 9 4 0 5   0 0     0   0   5 4 0   0 1 3     0 9
2414182 WA Whatcom   school 5300570 37503   Blaine School District 530057003020 5021 Blaine Home Connections   Alternative School No Other KG 11 2019   grade_2 5 0 0   1 0     0   1   3 4 0   0   0   2       0.0 7 5 0 0   1 0     0   1   3 4 0   0 0 2     0 7
2414197 WA Whatcom   school 5300570 37503   Blaine School District 530057001741 4476 Blaine Primary School   Regular School No Elementary PK 02 2019   grade_2 101 3 29   5 7     2   12   88 71 0   17   4   89       5.0 159 101 3 29   5 7     2   12   88 71 0   17 4 89     5 159

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