Data source: Big Local News · About: Big Local

8,808 rows where grade = "grade_2" and state = "WA" sorted by county_state_id

View and edit SQL

year

grade

  • grade_2 · 8,808
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
459711 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000001 2834 A J West Elementary   Regular School No 1.0 PK 06 2015   grade_2 36 0 26   0 3     0   1   33 33 0   11   11   55       2.0 66 36 0 26   0 3     0   1   33 33 0   11 11 55     2 66
459720 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000005 3216 Central Park Elementary   Regular School No 1.0 KG 06 2015   grade_2 14 0 5   0 1     0   1   10 11 0   2   1   12       0.0 21 14 0 5   0 1     0   1   10 11 0   2 1 12     0 21
459750 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000008 2449 McDermoth Elementary   Regular School No 1.0 KG 06 2015   grade_2 37 1 20   1 0     0   5   29 35 0   15   4   38       1.0 64 37 1 20   1 0     0   5   29 35 0   15 4 38     1 64
459761 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000010 2763 Robert Gray Elementary   Regular School No 1.0 PK 06 2015   grade_2 22 1 18   1 1     0   3   24 22 0   7   7   42       0.0 46 22 1 18   1 1     0   3   24 22 0   7 7 42     0 46
459770 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000011 2971 Stevens Elementary School   Regular School No 1.0 PK 06 2015   grade_2 32 0 28   2 2     0   2   28 38 0   14   10   59       0.0 66 32 0 28   2 2     0   2   28 38 0   14 10 59     0 66
459779 WA Lewis   school 5300060 21226   Adna School District 530006000012 2227 Adna Elementary School   Regular School No 1.0 PK 05 2015   grade_2 32 0 2   0 0     0   0   20 14 0   0   1   9       0.0 34 32 0 2   0 0     0   0   20 14 0   0 1 9     0 34
459795 WA Lincoln   school 5300090 22017   Almira School District 530009000179 2860 Almira Elementary School   Regular School No 1.0 KG 08 2015   grade_2 6 0 1   0 0     0   0   6 1 0   0   0   4       0.0 7 6 0 1   0 0     0   0   6 1 0   0 0 4     0 7
459820 WA Skagit   school 5300150 29103   Anacortes School District 530015000017 3182 Fidalgo Elementary   Regular School No 1.0 KG 06 2015   grade_2 63 1 7   0 2     1   2   38 38 0   1   1   19       5.0 76 63 1 7   0 2     1   2   38 38 0   1 1 19     5 76
459829 WA Skagit   school 5300150 29103   Anacortes School District 530015000018 3252 Island View Elementary   Regular School No 1.0 KG 06 2015   grade_2 53 1 7   1 0     0   3   39 26 0   3   5   33       3.0 65 53 1 7   1 0     0   3   39 26 0   3 5 33     3 65
459839 WA Skagit   school 5300150 29103   Anacortes School District 530015000019 3057 Mount Erie Elementary   Regular School No 1.0 KG 06 2015   grade_2 60 1 11   0 0     0   4   35 41 0   4   2   30       2.0 76 60 1 11   0 0     0   4   35 41 0   4 2 30     2 76
459858 WA Snohomish   school 5300240 31016   Arlington School District 530024002248 4327 Eagle Creek Elementary   Regular School No 1.0 KG 06 2015   grade_2 88 1 20   2 1     0   5   60 57 0   16   1   61       2.0 117 88 1 20   2 1     0   5   60 57 0   16 1 61     2 117
459870 WA Snohomish   school 5300240 31016   Arlington School District 530024001190 4436 Kent Prairie Elementary   Regular School No 1.0 KG 06 2015   grade_2 77 1 10   1 1     0   9   61 38 0   3   4   52       2.0 99 77 1 10   1 1     0   9   61 38 0   3 4 52     2 99
459879 WA Snohomish   school 5300240 31016   Arlington School District 530024002940 4573 Pioneer Elementary   Regular School No 1.0 KG 06 2015   grade_2 74 2 12   1 0     0   10   46 53 0   5   0   29       0.0 99 74 2 12   1 0     0   10   46 53 0   5 0 29     0 99
459892 WA Snohomish   school 5300240 31016   Arlington School District 530024001815 4154 Presidents Elementary   Regular School No 1.0 PK 06 2015   grade_2 77 1 7   2 0     0   11   46 52 0   6   2   45       2.0 98 77 1 7   2 0     0   11   46 52 0   6 2 45     2 98
459903 WA Snohomish   school 5300240 31016   Arlington School District 530024002589 1714 Stillaguamish Valley Learning Center   Alternative Education School No 4.0 KG 12 2015   grade_2 9 0 0   0 1     0   0   4 6 0   0   0   3       0.0 10 9 0 0   0 1     0   0   4 6 0   0 0 3     0 10
459919 WA Asotin   school 5300280 2420   Asotin-Anatone School District 530028000027 2507 Asotin Elementary   Regular School No 1.0 PK 06 2015   grade_2 34 0 4   1 0     0   3   21 21 0   0   0   21       0.0 42 34 0 4   1 0     0   3   21 21 0   0 0 21     0 42
459935 WA King   school 5300300 17408   Auburn School District 530030000029 3825 Alpac Elementary School   Regular School No 1.0 PK 05 2015   grade_2 49 1 26   1 10     6   6   50 49 0   33   2   78       0.0 99 49 1 26   1 10     6   6   50 49 0   33 2 78     0 99
459943 WA King   school 5300300 17408   Auburn School District 530030003174 5082 Arthur Jacobsen Elementary   Regular School No 1.0 KG 05 2015   grade_2 40 7 22   0 14     1   9   50 43 0   21   2   50       3.0 93 40 7 22   0 14     1   9   50 43 0   21 2 50     3 93
459969 WA King   school 5300300 17408   Auburn School District 530030000034 3439 Chinook Elementary School   Regular School No 1.0 PK 05 2015   grade_2 10 3 27   12 1     3   7   32 31 0   16   0   47       0.0 63 10 3 27   12 1     3   7   32 31 0   16 0 47     0 63
459977 WA King   school 5300300 17408   Auburn School District 530030000037 2932 Dick Scobee Elementary School   Regular School No 1.0 PK 05 2015   grade_2 33 12 15   0 1     9   16   45 41 0   25   8   77       0.0 86 33 12 15   0 1     9   16   45 41 0   25 8 77     0 86
459985 WA King   school 5300300 17408   Auburn School District 530030000035 3745 Evergreen Heights Elementary   Regular School No 1.0 PK 05 2015   grade_2 33 7 22   0 8     2   6   36 42 0   18   3   48       2.0 78 33 7 22   0 8     2   6   36 42 0   18 3 48     2 78
459993 WA King   school 5300300 17408   Auburn School District 530030000040 3669 Gildo Rey Elementary School   Regular School No 1.0 PK 05 2015   grade_2 21 1 62   1 5     5   9   53 51 0   55   4   98       1.0 104 21 1 62   1 5     5   9   53 51 0   55 4 98     1 104
460002 WA King   school 5300300 17408   Auburn School District 530030002277 4347 Hazelwood Elementary School   Regular School No 1.0 PK 05 2015   grade_2 41 2 27   0 8     1   15   44 50 0   28   2   55       3.0 94 41 2 27   0 8     1   15   44 50 0   28 2 55     3 94
460010 WA King   school 5300300 17408   Auburn School District 530030000698 4417 Ilalko Elementary School   Regular School No 1.0 PK 05 2015   grade_2 41 2 33   1 6     3   11   46 51 0   22   1   53       1.0 97 41 2 33   1 6     3   11   46 51 0   22 1 53     1 97
460018 WA King   school 5300300 17408   Auburn School District 530030001744 4120 Lake View Elementary School   Regular School No 1.0 PK 05 2015   grade_2 51 0 8   0 3     1   2   36 29 0   8   2   26       0.0 65 51 0 8   0 3     1   2   36 29 0   8 2 26     0 65
460026 WA King   school 5300300 17408   Auburn School District 530030003063 5051 Lakeland Hills Elementary   Regular School No 1.0 KG 05 2015   grade_2 69 5 18   0 14     0   13   58 61 0   14   0   26       0.0 119 69 5 18   0 14     0   13   58 61 0   14 0 26     0 119
460034 WA King   school 5300300 17408   Auburn School District 530030000036 3525 Lea Hill Elementary School   Regular School No 1.0 PK 05 2015   grade_2 26 12 9   0 5     2   6   32 28 0   7   1   32       1.0 60 26 12 9   0 5     2   6   32 28 0   7 1 32     1 60
460050 WA King   school 5300300 17408   Auburn School District 530030000039 3227 Pioneer Elementary School   Regular School No 1.0 PK 05 2015   grade_2 15 4 58   0 3     2   9   44 47 0   48   0   84       0.0 91 15 4 58   0 3     2   9   44 47 0   48 0 84     0 91
460064 WA King   school 5300300 17408   Auburn School District 530030002904 1915 Special Ed School   Special Education School No 4.0 PK 12 2015   grade_2 1 0 1   0 0     0   0   2 0 0   0   0   0       0.0 2 1 0 1   0 0     0   0   2 0 0   0 0 0     0 2
460072 WA King   school 5300300 17408   Auburn School District 530030000041 2659 Terminal Park Elementary School   Regular School No 1.0 KG 05 2015   grade_2 15 1 20   0 0     7   12   31 24 0   12   2   49       0.0 55 15 1 20   0 0     7   12   31 24 0   12 2 49     0 55
460079 WA King   school 5300300 17408   Auburn School District 530030000042 2326 Washington Elementary School   Regular School No 1.0 PK 05 2015   grade_2 30 4 22   0 2     9   12   42 37 0   22   0   67       2.0 79 30 4 22   0 2     9   12   42 37 0   22 0 67     2 79
460098 WA Kitsap   school 5300330 18303   Bainbridge Island School District 530033003113 1939 Bainbridge Special Education Services   Special Education School No 4.0 PK 12 2015   grade_2 2 0 0   0 0     0   0   2 0 0   0   0   0       0.0 2 2 0 0   0 0     0   0   2 0 0   0 0 0     0 2
460107 WA Kitsap   school 5300330 18303   Bainbridge Island School District 530033000045 3552 Capt Johnston Blakely Elem Sch   Regular School No 1.0 KG 04 2015   grade_2 61 0 4   3 1     0   7   46 30 0   1   0   9       2.0 76 61 0 4   3 1     0   7   46 30 0   1 0 9     2 76
460114 WA Kitsap   school 5300330 18303   Bainbridge Island School District 530033000044 3043 Capt. Charles Wilkes Elem School   Regular School No 1.0 PK 04 2015   grade_2 57 0 4   0 1     0   8   35 35 0   1   0   3       0.0 70 57 0 4   0 1     0   8   35 35 0   1 0 3     0 70
460126 WA Kitsap   school 5300330 18303   Bainbridge Island School District 530033002802 1841 Mosaic Home Education Partnership   Alternative Education School No 1.0 KG 08 2015   grade_2 4 0 1   0 0     0   0   4 1 0   0   0   0       0.0 5 4 0 1   0 0     0   0   4 1 0   0 0 0     0 5
460136 WA Kitsap   school 5300330 18303   Bainbridge Island School District 530033002523 1699 Odyssey Multiage Program   Regular School No 1.0 01 08 2015   grade_2 12 0 0   0 0     0   0   6 6 0   0   0   0       0.0 12 12 0 0   0 0     0   0   6 6 0   0 0 0     0 12
460145 WA Kitsap   school 5300330 18303   Bainbridge Island School District 530033000047 4062 Ordway Elementary   Regular School No 1.0 PK 04 2015   grade_2 55 1 8   0 4     0   15   39 44 0   2   0   12       2.0 83 55 1 8   0 4     0   15   39 44 0   2 0 12     2 83
460185 WA Clark   school 5300380 6119   Battle Ground School District 530038002278 4352 Captain Strong   Regular School No 1.0 KG 05 2015   grade_2 105 0 15   0 2     0   6   71 57 0   13   2   68       0.0 128 105 0 15   0 2     0   6   71 57 0   13 2 68     0 128
460203 WA Clark   school 5300380 6119   Battle Ground School District 530038003194 5090 Daybreak Primary   Regular School No 1.0 PK 04 2015   grade_2 113 0 16   0 1     0   8   74 64 0   21   4   77       0.0 138 113 0 16   0 1     0   8   74 64 0   21 4 77     0 138
460211 WA Clark   school 5300380 6119   Battle Ground School District 530038000051 3018 Glenwood Heights Primary   Regular School No 1.0 KG 04 2015   grade_2 103 2 13   0 7     0   9   64 70 0   28   1   49       1.0 134 103 2 13   0 7     0   9   64 70 0   28 1 49     1 134
460222 WA Clark   school 5300380 6119   Battle Ground School District 530038002857 1875 Homelink River   Alternative Education School No 4.0 KG 12 2015   grade_2 45 1 6   1 0     0   5   29 29 0   4   0   14       0.0 58 45 1 6   1 0     0   5   29 29 0   4 0 14     0 58
460238 WA Clark   school 5300380 6119   Battle Ground School District 530038003409 5291 Maple Grove K-8 (Closed after 2018-2019 school year)   Regular School No 1.0 KG 08 2015   grade_2 43 0 4   0 1     1   4   28 25 0   8   0   27       0.0 53 43 0 4   0 1     1   4   28 25 0   8 0 27     0 53
460257 WA Clark   school 5300380 6119   Battle Ground School District 530038000055 3996 Pleasant Valley Primary   Regular School No 1.0 KG 04 2015   grade_2 88 4 15   0 11     0   7   63 62 0   24   5   63       2.0 125 88 4 15   0 11     0   7   63 62 0   24 5 63     2 125
460284 WA Clark   school 5300380 6119   Battle Ground School District 530038003228 5132 Tukes Valley Primary   Regular School No 1.0 PK 04 2015   grade_2 107 0 7   0 1     0   6   72 49 0   7   1   44       0.0 121 107 0 7   0 1     0   6   72 49 0   7 1 44     0 121
460292 WA Clark   school 5300380 6119   Battle Ground School District 530038000056 2910 Yacolt Primary   Regular School No 1.0 KG 04 2015   grade_2 165 0 6   0 0     0   5   95 81 0   1   6   85       1.0 176 165 0 6   0 0     0   5   95 81 0   1 6 85     1 176
460299 WA King   school 5300390 17405   Bellevue School District 530039000058 3633 Ardmore Elementary School   Regular School No 1.0 KG 05 2015   grade_2 19 5 25   0 9     0   4   32 30 0   20   2   30       2.0 62 19 5 25   0 9     0   4   32 30 0   20 2 30     2 62
460320 WA King   school 5300390 17405   Bellevue School District 530039000062 3705 Bennett Elementary School   Regular School No 1.0 KG 05 2015   grade_2 34 1 9   0 33     0   9   54 32 0   8   0   4       0.0 86 34 1 9   0 33     0   9   54 32 0   8 0 4     0 86
460331 WA King   school 5300390 17405   Bellevue School District 530039003434 5281 Central Educational Services   Regular School No 4.0 PK 13 2015   grade_2 0 0 1   0 0     0   0   0 1 0   0   0   0       0.0 1 0 0 1   0 0     0   0   0 1 0   0 0 0     0 1
460343 WA King   school 5300390 17405   Bellevue School District 530039000063 3742 Cherry Crest Elementary School   Regular School No 1.0 KG 05 2015   grade_2 38 1 4   0 47     0   12   55 47 0   3   0   2       2.0 102 38 1 4   0 47     0   12   55 47 0   3 0 2     2 102
460355 WA King   school 5300390 17405   Bellevue School District 530039000065 2847 Clyde Hill Elementary   Regular School No 1.0 KG 05 2015   grade_2 43 2 8   1 44     0   10   55 53 0   12   0   6       1.0 108 43 2 8   1 44     0   10   55 53 0   12 0 6     1 108
460363 WA King   school 5300390 17405   Bellevue School District 530039000066 3036 Eastgate Elementary School   Regular School No 1.0 KG 05 2015   grade_2 35 5 5   2 30     0   9   59 27 0   6   0   18       2.0 86 35 5 5   2 30     0   9   59 27 0   6 0 18     2 86
460371 WA King   school 5300390 17405   Bellevue School District 530039000067 2846 Enatai Elementary School   Regular School No 1.0 KG 05 2015   grade_2 53 5 8   0 23     0   12   41 60 0   13   4   23       1.0 101 53 5 8   0 23     0   12   41 60 0   13 4 23     1 101
460396 WA King   school 5300390 17405   Bellevue School District 530039003455 5308 Jing Mei Elementary School   Regular School No 1.0 KG 05 2015   grade_2 3 0 1   0 14     0   8   10 16 0   4   0   2       1.0 26 3 0 1   0 14     0   8   10 16 0   4 0 2     1 26
460401 WA King   school 5300390 17405   Bellevue School District 530039000075 3225 Lake Hills Elementary   Regular School No 1.0 KG 05 2015   grade_2 18 3 36   1 17     0   6   40 41 0   29   3   57       2.0 81 18 3 36   1 17     0   6   40 41 0   29 3 57     2 81
460409 WA King   school 5300390 17405   Bellevue School District 530039000076 3436 Medina Elementary School   Regular School No 1.0 KG 05 2015   grade_2 48 0 7   0 45     0   4   61 43 0   4   0   4       2.0 104 48 0 7   0 45     0   4   61 43 0   4 0 4     2 104
460416 WA King   school 5300390 17405   Bellevue School District 530039000077 3437 Newport Heights Elementary   Regular School No 1.0 KG 05 2015   grade_2 45 6 11   0 32     0   12   57 49 0   9   0   26       4.0 106 45 6 11   0 32     0   12   57 49 0   9 0 26     4 106
460433 WA King   school 5300390 17405   Bellevue School District 530039000082 3168 Phantom Lake Elementary   Regular School No 1.0 PK 05 2015   grade_2 26 1 13   0 13     0   6   31 28 0   10   0   22       0.0 59 26 1 13   0 13     0   6   31 28 0   10 0 22     0 59
460442 WA King   school 5300390 17405   Bellevue School District 530039000090 3224 Puesta del Sol Elementary School   Regular School No 1.0 KG 05 2015   grade_2 53 1 33   0 11     0   6   47 57 0   5   0   9       6.0 104 53 1 33   0 11     0   6   47 57 0   5 0 9     6 104
460455 WA King   school 5300390 17405   Bellevue School District 530039000086 3339 Sherwood Forest Elementary   Regular School No 1.0 KG 05 2015   grade_2 19 9 23   0 19     0   5   39 36 0   15   3   39       2.0 75 19 9 23   0 19     0   5   39 36 0   15 3 39     2 75
460463 WA King   school 5300390 17405   Bellevue School District 530039000087 3789 Somerset Elementary School   Regular School No 1.0 KG 05 2015   grade_2 23 0 4   0 91     0   9   56 71 0   8   0   10       3.0 127 23 0 4   0 91     0   9   56 71 0   8 0 10     3 127
460471 WA King   school 5300390 17405   Bellevue School District 530039000088 3634 Spiritridge Elementary School   Regular School No 1.0 KG 05 2015   grade_2 46 3 6   0 54     0   6   58 57 0   4   0   13       2.0 115 46 3 6   0 54     0   6   58 57 0   4 0 13     2 115
460479 WA King   school 5300390 17405   Bellevue School District 530039000089 3100 Stevenson Elementary   Regular School No 1.0 KG 05 2015   grade_2 10 5 30   0 35     0   5   46 39 0   32   1   44       2.0 85 10 5 30   0 35     0   5   46 39 0   32 1 44     2 85
460495 WA King   school 5300390 17405   Bellevue School District 530039000096 3167 Woodridge Elementary   Regular School No 1.0 KG 05 2015   grade_2 44 2 8   0 44     3   5   51 55 0   12   1   28       1.0 106 44 2 8   0 44     3   5   51 55 0   12 1 28     1 106
460503 WA Whatcom   school 5300420 37501   Bellingham School District 530042000098 3200 Alderwood Elementary School   Regular School No 1.0 PK 05 2015   grade_2 18 2 21   1 2     0   0   25 19 0   17   5   37       3.0 44 18 2 21   1 2     0   0   25 19 0   17 5 37     3 44
460518 WA Whatcom   school 5300420 37501   Bellingham School District 530042000100 2431 Birchwood Elementary School   Regular School No 1.0 PK 05 2015   grade_2 22 2 20   0 3     3   4   22 32 0   20   4   44       3.0 54 22 2 20   0 3     3   4   22 32 0   20 4 44     3 54
460526 WA Whatcom   school 5300420 37501   Bellingham School District 530042000101 2817 Carl Cozier Elementary School   Regular School No 1.0 PK 05 2015   grade_2 25 2 13   0 0     0   1   23 18 0   9   2   27       5.0 41 25 2 13   0 0     0   1   23 18 0   9 2 27     5 41
460533 WA Whatcom   school 5300420 37501   Bellingham School District 530042000103 2365 Columbia Elementary School   Regular School No 1.0 PK 05 2015   grade_2 47 0 4   0 0     0   0   22 29 0   0   0   11       2.0 51 47 0 4   0 0     0   0   22 29 0   0 0 11     2 51
460540 WA Whatcom   school 5300420 37501   Bellingham School District 530042003358 5239 Cordata Elementary School   Regular School No 1.0 PK 05 2015   grade_2 32 4 8   1 9     0   8   33 29 0   17   4   42       3.0 62 32 4 8   1 9     0   8   33 29 0   17 4 42     3 62
460552 WA Whatcom   school 5300420 37501   Bellingham School District 530042000105 2262 Geneva Elementary School   Regular School No 1.0 PK 05 2015   grade_2 51 2 8   0 0     0   6   40 27 0   0   1   23       2.0 67 51 2 8   0 0     0   6   40 27 0   0 1 23     2 67
460560 WA Whatcom   school 5300420 37501   Bellingham School District 530042000106 3134 Happy Valley Elementary School   Regular School No 1.0 PK 05 2015   grade_2 46 1 10   0 3     1   4   39 26 0   2   0   23       1.0 65 46 1 10   0 3     1   4   39 26 0   2 0 23     1 65
460577 WA Whatcom   school 5300420 37501   Bellingham School District 530042000108 2225 Lowell Elementary School   Regular School No 1.0 PK 05 2015   grade_2 42 0 1   1 3     0   2   26 23 0   2   0   10       2.0 49 42 0 1   1 3     0   2   26 23 0   2 0 10     2 49
460585 WA Whatcom   school 5300420 37501   Bellingham School District 530042002939 4571 Northern Heights Elementary Schl   Regular School No 1.0 PK 05 2015   grade_2 44 2 10   2 5     0   4   30 37 0   6   1   28       3.0 67 44 2 10   2 5     0   4   30 37 0   6 1 28     3 67
460598 WA Whatcom   school 5300420 37501   Bellingham School District 530042000110 3202 Parkview Elementary School   Regular School No 1.0 PK 05 2015   grade_2 26 1 4   0 0     0   9   23 17 0   1   3   20       1.0 40 26 1 4   0 0     0   9   23 17 0   1 3 20     1 40
460606 WA Whatcom   school 5300420 37501   Bellingham School District 530042000112 2067 Roosevelt Elementary School   Regular School No 1.0 PK 05 2015   grade_2 38 2 16   1 2     0   7   31 35 0   8   1   43       2.0 66 38 2 16   1 2     0   7   31 35 0   8 1 43     2 66
460624 WA Whatcom   school 5300420 37501   Bellingham School District 530042000115 2175 Silver Beach Elementary School   Regular School No 1.0 PK 05 2015   grade_2 36 1 6   0 5     0   5   32 21 0   1   0   9       4.0 53 36 1 6   0 5     0   5   32 21 0   1 0 9     4 53
460637 WA Whatcom   school 5300420 37501   Bellingham School District 530042000116 2387 Sunnyland Elementary School   Regular School No 1.0 PK 05 2015   grade_2 25 2 9   0 2     0   2   22 18 0   9   1   25       4.0 40 25 2 9   0 2     0   2   22 18 0   9 1 25     4 40
460651 WA Whatcom   school 5300420 37501   Bellingham School District 530042003225 5125 Wade King Elementary School   Regular School No 1.0 PK 05 2015   grade_2 52 0 7   0 3     0   6   33 35 0   2   0   14       8.0 68 52 0 7   0 3     0   6   33 35 0   2 0 14     8 68
460662 WA Adams   school 5300450 1122   Benge School District 530045000118 3142 Benge Elementary   Regular School No 1.0 KG 06 2015   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
460686 WA Pierce   school 5300480 27403   Bethel School District 530048002202 4296 Camas Prairie Elementary   Regular School No 1.0 PK 06 2015   grade_2 47 12 21   2 7     7   11   55 52 0   2   2   70       2.0 107 47 12 21   2 7     7   11   55 52 0   2 2 70     2 107
460698 WA Pierce   school 5300480 27403   Bethel School District 530048002250 4331 Centennial Elementary   Regular School No 1.0 PK 06 2015   grade_2 48 4 8   1 2     2   7   43 29 0   0   1   44       0.0 72 48 4 8   1 2     2   7   43 29 0   0 1 44     0 72
460711 WA Pierce   school 5300480 27403   Bethel School District 530048000121 3649 Chester H Thompson Elementary   Regular School No 1.0 PK 06 2015   grade_2 37 7 26   1 3     9   11   43 51 0   0   1   75       1.0 94 37 7 26   1 3     9   11   43 51 0   0 1 75     1 94
460719 WA Pierce   school 5300480 27403   Bethel School District 530048000122 2576 Clover Creek Elementary   Regular School No 1.0 PK 06 2015   grade_2 70 13 18   1 3     6   12   60 63 0   1   1   72       0.0 123 70 13 18   1 3     6   12   60 63 0   1 1 72     0 123
460734 WA Pierce   school 5300480 27403   Bethel School District 530048000123 2877 Elk Plain School of Choice   Regular School No 1.0 PK 06 2015   grade_2 38 8 17   1 3     0   17   42 42 0   0   0   28       0.0 84 38 8 17   1 3     0   17   42 42 0   0 0 28     0 84
460743 WA Pierce   school 5300480 27403   Bethel School District 530048001748 4099 Evergreen Elementary   Regular School No 1.0 PK 06 2015   grade_2 32 3 20   1 8     9   12   47 38 0   19   2   61       0.0 85 32 3 20   1 8     9   12   47 38 0   19 2 61     0 85
460751 WA Pierce   school 5300480 27403   Bethel School District 530048003272 5159 Frederickson Elementary   Regular School No 1.0 PK 06 2015   grade_2 44 6 19   1 4     3   10   42 45 0   14   1   44       1.0 87 44 6 19   1 4     3   10   42 45 0   14 1 44     1 87
460764 WA Pierce   school 5300480 27403   Bethel School District 530048002203 4297 Graham Elementary   Regular School No 1.0 PK 06 2015   grade_2 87 1 21   1 1     1   17   63 66 0   0   0   45       3.0 129 87 1 21   1 1     1   17   63 66 0   0 0 45     3 129
460777 WA Pierce   school 5300480 27403   Bethel School District 530048000124 2748 Kapowsin Elementary   Regular School No 1.0 PK 06 2015   grade_2 55 1 4   0 0     0   8   40 28 0   0   1   33       1.0 68 55 1 4   0 0     0   8   40 28 0   0 1 33     1 68
460789 WA Pierce   school 5300480 27403   Bethel School District 530048001749 4102 Naches Trail Elementary   Regular School No 1.0 PK 06 2015   grade_2 39 2 10   2 1     4   16   35 39 0   0   4   38       0.0 74 39 2 10   2 1     4   16   35 39 0   0 4 38     0 74
460797 WA Pierce   school 5300480 27403   Bethel School District 530048003288 5160 Nelson Elementary School   Regular School No 1.0 PK 06 2015   grade_2 66 0 14   1 1     1   9   41 51 0   0   0   44       1.0 92 66 0 14   1 1     1   9   41 51 0   0 0 44     1 92
460806 WA Pierce   school 5300480 27403   Bethel School District 530048002747 4538 North Star Elementary   Regular School No 1.0 PK 06 2015   grade_2 49 6 7   0 1     0   9   40 32 0   0   1   28       0.0 72 49 6 7   0 1     0   9   40 32 0   0 1 28     0 72
460814 WA Pierce   school 5300480 27403   Bethel School District 530048002430 4381 Pioneer Valley Elementary   Regular School No 1.0 PK 06 2015   grade_2 39 5 21   0 2     4   9   43 37 0   0   1   39       1.0 80 39 5 21   0 2     4   9   43 37 0   0 1 39     1 80
460825 WA Pierce   school 5300480 27403   Bethel School District 530048001925 4227 Rocky Ridge Elementary   Regular School No 1.0 PK 06 2015   grade_2 52 1 18   0 0     1   10   39 43 0   11   0   59       0.0 82 52 1 18   0 0     1   10   39 43 0   11 0 59     0 82
460833 WA Pierce   school 5300480 27403   Bethel School District 530048000126 2543 Roy Elementary   Regular School No 1.0 PK 06 2015   grade_2 34 1 3   0 0     0   5   18 25 0   0   1   32       0.0 43 34 1 3   0 0     0   5   18 25 0   0 1 32     0 43
460841 WA Pierce   school 5300480 27403   Bethel School District 530048001750 4103 Shining Mountain Elementary   Regular School No 1.0 PK 06 2015   grade_2 49 1 26   1 4     8   18   60 47 0   1   1   75       3.0 107 49 1 26   1 4     8   18   60 47 0   1 1 75     3 107
460852 WA Pierce   school 5300480 27403   Bethel School District 530048000127 2399 Spanaway Elementary   Regular School No 1.0 PK 06 2015   grade_2 28 7 11   2 1     2   15   37 29 0   0   1   47       0.0 66 28 7 11   2 1     2   15   37 29 0   0 1 47     0 66
460880 WA Klickitat   school 5300510 20203   Bickleton School District 530051000129 3392 Bickleton Elementary & High Schl   Regular School No 4.0 KG 12 2015   grade_2 5 0 1   0 0     0   0   1 5 0   0   0   1       0.0 6 5 0 1   0 0     0   0   1 5 0   0 0 1     0 6
460903 WA Whatcom   school 5300570 37503   Blaine School District 530057003020 5021 Blaine Home Connections   Alternative Education School No 4.0 KG 11 2015   grade_2 8 1 0   0 0     0   0   8 1 0   0   0   0       0.0 9 8 1 0   0 0     0   0   8 1 0   0 0 0     0 9
460918 WA Whatcom   school 5300570 37503   Blaine School District 530057001741 4476 Blaine Primary School   Regular School No 1.0 KG 02 2015   grade_2 115 3 20   1 6     2   16   73 90 0   13   0   75       8.0 163 115 3 20   1 6     2   16   73 90 0   13 0 75     8 163
460923 WA Whatcom   school 5300570 37503   Blaine School District 530057001740 4459 Point Roberts Primary   Regular School No 1.0 KG 03 2015   grade_2 4 0 0   0 0     0   1   1 4 0   0   0   0       0.0 5 4 0 0   0 0     0   1   1 4 0   0 0 0     0 5
460928 WA Lewis   school 5300630 21234   Boistfort School District 530063000133 2516 Boistfort Elem   Regular School No 1.0 PK 08 2015   grade_2 13 0 1   0 0     0   0   11 3 0   0   0   7       0.0 14 13 0 1   0 0     0   0   11 3 0   0 0 7     0 14

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