Data source: Big Local News · About: Big Local

15,758 rows where state = "WA" and year = 2017 sorted by grade

View and edit SQL

grade

year

  • 2017 · 15,758
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
617041 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000001 2834 A J West Elementary   Regular School No Elementary PK 06 2017   grade_1 26 1 22   1 0     0   5   25 30 0   14   4   49       1.0 55 26 1 22   1 0     0   5   25 30 0   14 4 49     1 55
617051 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000005 3216 Central Park Elementary   Regular School No Elementary KG 06 2017   grade_1 12 0 1   0 1     0   2   6 10 0   1   0   6       0.0 16 12 0 1   0 1     0   2   6 10 0   1 0 6     0 16
617079 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000008 2449 McDermoth Elementary   Regular School No Elementary KG 06 2017   grade_1 29 0 15   2 0     0   10   30 26 0   10   5   42       0.0 56 29 0 15   2 0     0   10   30 26 0   10 5 42     0 56
617092 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000010 2763 Robert Gray Elementary   Regular School No Elementary PK 06 2017   grade_1 26 0 23   1 1     0   4   29 26 0   17   4   47       1.0 55 26 0 23   1 1     0   4   29 26 0   17 4 47     1 55
617101 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000011 2971 Stevens Elementary School   Regular School No Elementary PK 06 2017   grade_1 36 1 19   0 0     0   6   24 38 0   12   3   47       0.0 62 36 1 19   0 0     0   6   24 38 0   12 3 47     0 62
617113 WA Lewis   school 5300060 21226   Adna School District 530006000012 2227 Adna Elementary School   Regular School No Elementary PK 05 2017   grade_1 34 0 2   1 0     0   0   18 19 0   1   0   9       0.0 37 34 0 2   1 0     0   0   18 19 0   1 0 9     0 37
617129 WA Lincoln   school 5300090 22017   Almira School District 530009000179 2860 Almira Elementary School   Regular School No Elementary KG 08 2017   grade_1 4 0 0   0 0     0   0   2 2 0   0   0   2       0.0 4 4 0 0   0 0     0   0   2 2 0   0 0 2     0 4
617154 WA Skagit   school 5300150 29103   Anacortes School District 530015000017 3182 Fidalgo Elementary   Regular School No Elementary KG 06 2017   grade_1 53 0 5   1 2     0   2   36 27 0   2   0   23       1.0 63 53 0 5   1 2     0   2   36 27 0   2 0 23     1 63
617163 WA Skagit   school 5300150 29103   Anacortes School District 530015000018 3252 Island View Elementary   Regular School No Elementary KG 06 2017   grade_1 58 2 10   0 1     0   4   36 39 0   6   1   22       3.0 75 58 2 10   0 1     0   4   36 39 0   6 1 22     3 75
617172 WA Skagit   school 5300150 29103   Anacortes School District 530015000019 3057 Mount Erie Elementary   Regular School No Elementary KG 06 2017   grade_1 56 0 7   0 2     0   2   34 33 0   5   0   23       1.0 67 56 0 7   0 2     0   2   34 33 0   5 0 23     1 67
617190 WA Snohomish   school 5300240 31016   Arlington School District 530024003065 2277 Arlington Special Educ School   Regular School No Other PK 12 2017   grade_1 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
617196 WA Snohomish   school 5300240 31016   Arlington School District 530024002248 4327 Eagle Creek Elementary   Regular School No Elementary KG 05 2017   grade_1 67 0 26   1 0     0   6   41 59 0   18   3   45       0.0 100 67 0 26   1 0     0   6   41 59 0   18 3 45     0 100
617209 WA Snohomish   school 5300240 31016   Arlington School District 530024001190 4436 Kent Prairie Elementary   Regular School No Elementary KG 05 2017   grade_1 80 0 11   0 0     0   12   45 58 0   6   5   53       0.0 103 80 0 11   0 0     0   12   45 58 0   6 5 53     0 103
617218 WA Snohomish   school 5300240 31016   Arlington School District 530024002940 4573 Pioneer Elementary   Regular School No Elementary KG 05 2017   grade_1 63 0 13   0 1     0   8   40 45 0   7   0   23       0.0 85 63 0 13   0 1     0   8   40 45 0   7 0 23     0 85
617230 WA Snohomish   school 5300240 31016   Arlington School District 530024001815 4154 Presidents Elementary   Regular School No Elementary PK 05 2017   grade_1 71 0 11   0 2     0   5   53 36 0   5   5   38       0.0 89 71 0 11   0 2     0   5   53 36 0   5 5 38     0 89
617242 WA Snohomish   school 5300240 31016   Arlington School District 530024002589 1714 Stillaguamish Valley Learning Center   Alternative School No Other KG 12 2017   grade_1 6 0 1   0 0     0   1   2 6 0   0   0   1       0.0 8 6 0 1   0 0     0   1   2 6 0   0 0 1     0 8
617258 WA Asotin   school 5300280 2420   Asotin-Anatone School District 530028000027 2507 Asotin Elementary   Regular School No Elementary PK 05 2017   grade_1 35 0 3   0 1     0   1   16 24 0   0   1   17       0.0 40 35 0 3   0 1     0   1   16 24 0   0 1 17     0 40
617274 WA King   school 5300300 17408   Auburn School District 530030000029 3825 Alpac Elementary School   Regular School No Elementary PK 05 2017   grade_1 38 4 22   0 8     1   18   45 46 0   25   0   62       1.0 91 38 4 22   0 8     1   18   45 46 0   25 0 62     1 91
617283 WA King   school 5300300 17408   Auburn School District 530030003174 5082 Arthur Jacobsen Elementary   Regular School No Elementary KG 05 2017   grade_1 44 5 17   0 10     0   14   47 43 0   39   2   42       1.0 90 44 5 17   0 10     0   14   47 43 0   39 2 42     1 90
617309 WA King   school 5300300 17408   Auburn School District 530030000034 3439 Chinook Elementary School   Regular School No Elementary PK 05 2017   grade_1 18 3 38   10 2     6   8   45 40 0   30   1   65       0.0 85 18 3 38   10 2     6   8   45 40 0   30 1 65     0 85
617317 WA King   school 5300300 17408   Auburn School District 530030000037 2932 Dick Scobee Elementary School   Regular School No Elementary PK 05 2017   grade_1 33 5 24   0 3     2   7   35 39 0   15   1   47       0.0 74 33 5 24   0 3     2   7   35 39 0   15 1 47     0 74
617326 WA King   school 5300300 17408   Auburn School District 530030000035 3745 Evergreen Heights Elementary   Regular School No Elementary KG 05 2017   grade_1 25 8 9   0 13     2   10   33 34 0   21   0   35       1.0 67 25 8 9   0 13     2   10   33 34 0   21 0 35     1 67
617333 WA King   school 5300300 17408   Auburn School District 530030000040 3669 Gildo Rey Elementary School   Regular School No Elementary PK 05 2017   grade_1 18 4 38   0 3     8   10   37 44 0   40   4   61       1.0 81 18 4 38   0 3     8   10   37 44 0   40 4 61     1 81
617341 WA King   school 5300300 17408   Auburn School District 530030002277 4347 Hazelwood Elementary School   Regular School No Elementary KG 05 2017   grade_1 46 2 26   1 8     2   8   52 41 0   30   0   40       2.0 93 46 2 26   1 8     2   8   52 41 0   30 0 40     2 93
617349 WA King   school 5300300 17408   Auburn School District 530030000698 4417 Ilalko Elementary School   Regular School No Elementary KG 05 2017   grade_1 43 3 30   1 9     5   14   55 50 0   26   0   50       1.0 105 43 3 30   1 9     5   14   55 50 0   26 0 50     1 105
617357 WA King   school 5300300 17408   Auburn School District 530030001744 4120 Lake View Elementary School   Regular School No Elementary PK 05 2017   grade_1 53 2 6   1 1     0   8   34 37 0   2   1   28       0.0 71 53 2 6   1 1     0   8   34 37 0   2 1 28     0 71
617365 WA King   school 5300300 17408   Auburn School District 530030003063 5051 Lakeland Hills Elementary   Regular School No Elementary KG 05 2017   grade_1 52 8 23   1 15     0   15   58 56 0   24   0   24       1.0 114 52 8 23   1 15     0   15   58 56 0   24 0 24     1 114
617372 WA King   school 5300300 17408   Auburn School District 530030000036 3525 Lea Hill Elementary School   Regular School No Elementary PK 05 2017   grade_1 17 15 10   0 10     1   13   33 33 0   19   1   43       1.0 66 17 15 10   0 10     1   13   33 33 0   19 1 43     1 66
617388 WA King   school 5300300 17408   Auburn School District 530030000039 3227 Pioneer Elementary School   Regular School No Elementary PK 05 2017   grade_1 15 3 52   0 5     8   5   57 31 0   56   1   75       0.0 88 15 3 52   0 5     8   5   57 31 0   56 1 75     0 88
617403 WA King   school 5300300 17408   Auburn School District 530030002904 1915 Special Ed School   Special Education School No Other PK 12 2017   grade_1 1 1 0   0 0     0   0   1 1 0   0   0   0       0.0 2 1 1 0   0 0     0   0   1 1 0   0 0 0     0 2
617413 WA King   school 5300300 17408   Auburn School District 530030000041 2659 Terminal Park Elementary School   Regular School No Elementary KG 05 2017   grade_1 34 7 16   0 0     7   12   41 35 0   22   1   58       0.0 76 34 7 16   0 0     7   12   41 35 0   22 1 58     0 76
617421 WA King   school 5300300 17408   Auburn School District 530030000042 2326 Washington Elementary School   Regular School No Elementary KG 05 2017   grade_1 31 5 39   0 4     2   15   48 48 0   24   3   73       4.0 96 31 5 39   0 4     2   15   48 48 0   24 3 73     4 96
617448 WA Kitsap   school 5300330 18303   Bainbridge Island School District 530033000045 3552 Capt Johnston Blakely Elem Sch   Regular School No Elementary KG 04 2017   grade_1 55 0 4   1 0     0   2   34 28 0   0   0   4       10.0 62 55 0 4   1 0     0   2   34 28 0   0 0 4     10 62
617454 WA Kitsap   school 5300330 18303   Bainbridge Island School District 530033000044 3043 Capt. Charles Wilkes Elem School   Regular School No Elementary PK 04 2017   grade_1 63 0 3   0 1     0   4   44 27 0   0   0   4       2.0 71 63 0 3   0 1     0   4   44 27 0   0 0 4     2 71
617466 WA Kitsap   school 5300330 18303   Bainbridge Island School District 530033002802 1841 Mosaic Home Education Partnership   Alternative School No Elementary KG 08 2017   grade_1 3 0 0   0 0     0   0   2 1 0   0   0   1       0.0 3 3 0 0   0 0     0   0   2 1 0   0 0 1     0 3
617476 WA Kitsap   school 5300330 18303   Bainbridge Island School District 530033002523 1699 Odyssey Multiage Program   Regular School No Elementary 01 08 2017   grade_1 10 0 0   0 0     0   0   4 6 0   0   0   1       0.0 10 10 0 0   0 0     0   0   4 6 0   0 0 1     0 10
617485 WA Kitsap   school 5300330 18303   Bainbridge Island School District 530033000047 4062 Ordway Elementary   Regular School No Elementary PK 04 2017   grade_1 58 1 7   0 3     0   5   39 35 0   3   1   9       0.0 74 58 1 7   0 3     0   5   39 35 0   3 1 9     0 74
617520 WA Clark   school 5300380 6119   Battle Ground School District 530038002278 4352 Captain Strong   Regular School No Elementary PK 04 2017   grade_1 124 1 9   0 0     1   7   78 64 0   12   3   55       1.0 142 124 1 9   0 0     1   7   78 64 0   12 3 55     1 142
617538 WA Clark   school 5300380 6119   Battle Ground School District 530038003194 5090 Daybreak Primary   Regular School No Elementary PK 04 2017   grade_1 75 1 4   0 2     0   1   51 32 0   14   2   40       1.0 83 75 1 4   0 2     0   1   51 32 0   14 2 40     1 83
617545 WA Clark   school 5300380 6119   Battle Ground School District 530038000051 3018 Glenwood Heights Primary   Regular School No Elementary PK 04 2017   grade_1 125 1 17   0 11     2   3   81 78 0   38   4   69       2.0 159 125 1 17   0 11     2   3   81 78 0   38 4 69     2 159
617556 WA Clark   school 5300380 6119   Battle Ground School District 530038002857 1875 Homelink River   Alternative School No Other KG 12 2017   grade_1 60 1 3   0 1     0   5   35 35 0   5   0   9       0.0 70 60 1 3   0 1     0   5   35 35 0   5 0 9     0 70
617572 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 2017   grade_1 38 0 7   0 2     0   2   24 25 0   7   0   23       0.0 49 38 0 7   0 2     0   2   24 25 0   7 0 23     0 49
617591 WA Clark   school 5300380 6119   Battle Ground School District 530038000055 3996 Pleasant Valley Primary   Regular School No Elementary PK 04 2017   grade_1 98 0 13   0 4     2   8   68 57 0   25   4   45       0.0 125 98 0 13   0 4     2   8   68 57 0   25 4 45     0 125
617618 WA Clark   school 5300380 6119   Battle Ground School District 530038003228 5132 Tukes Valley Primary   Regular School No Elementary PK 04 2017   grade_1 117 1 14   0 0     0   10   78 64 0   10   1   60       0.0 142 117 1 14   0 0     0   10   78 64 0   10 1 60     0 142
617626 WA Clark   school 5300380 6119   Battle Ground School District 530038000056 2910 Yacolt Primary   Regular School No Elementary PK 04 2017   grade_1 159 0 3   1 1     0   5   95 74 0   1   1   74       0.0 169 159 0 3   1 1     0   5   95 74 0   1 1 74     0 169
617633 WA King   school 5300390 17405   Bellevue School District 530039000058 3633 Ardmore Elementary School   Regular School No Elementary PK 05 2017   grade_1 17 5 22   0 45     0   7   51 45 0   52   2   35       1.0 96 17 5 22   0 45     0   7   51 45 0   52 2 35     1 96
617654 WA King   school 5300390 17405   Bellevue School District 530039000062 3705 Bennett Elementary School   Regular School No Elementary PK 05 2017   grade_1 25 1 2   0 21     0   9   26 32 0   14   0   2       1.0 58 25 1 2   0 21     0   9   26 32 0   14 0 2     1 58
617666 WA King   school 5300390 17405   Bellevue School District 530039003434 5281 Central Educational Services   Regular School No Other PK 13 2017   grade_1 3 0 0   0 0     0   0   3 0 0   0   0   0       0.0 3 3 0 0   0 0     0   0   3 0 0   0 0 0     0 3
617677 WA King   school 5300390 17405   Bellevue School District 530039000063 3742 Cherry Crest Elementary School   Regular School No Elementary PK 05 2017   grade_1 33 1 4   0 26     0   7   43 28 0   15   0   2       0.0 71 33 1 4   0 26     0   7   43 28 0   15 0 2     0 71
617689 WA King   school 5300390 17405   Bellevue School District 530039000065 2847 Clyde Hill Elementary   Regular School No Elementary PK 05 2017   grade_1 42 0 10   0 59     0   9   66 54 0   47   0   6       1.0 120 42 0 10   0 59     0   9   66 54 0   47 0 6     1 120
617697 WA King   school 5300390 17405   Bellevue School District 530039000066 3036 Eastgate Elementary School   Regular School No Elementary PK 05 2017   grade_1 33 1 3   0 28     0   9   41 33 0   18   1   7       1.0 74 33 1 3   0 28     0   9   41 33 0   18 1 7     1 74
617705 WA King   school 5300390 17405   Bellevue School District 530039000067 2846 Enatai Elementary School   Regular School No Elementary PK 05 2017   grade_1 32 1 7   0 38     0   18   46 50 0   29   1   13       0.0 96 32 1 7   0 38     0   18   46 50 0   29 1 13     0 96
617730 WA King   school 5300390 17405   Bellevue School District 530039003455 5308 Jing Mei Elementary School   Regular School No Elementary PK 05 2017   grade_1 8 1 1   0 52     0   16   40 38 0   30   0   3       0.0 78 8 1 1   0 52     0   16   40 38 0   30 0 3     0 78
617739 WA King   school 5300390 17405   Bellevue School District 530039000075 3225 Lake Hills Elementary   Regular School No Elementary PK 05 2017   grade_1 25 4 37   0 14     0   5   45 40 0   46   6   48       0.0 85 25 4 37   0 14     0   5   45 40 0   46 6 48     0 85
617747 WA King   school 5300390 17405   Bellevue School District 530039000076 3436 Medina Elementary School   Regular School No Elementary PK 05 2017   grade_1 25 1 3   0 22     0   4   24 31 0   11   0   1       2.0 55 25 1 3   0 22     0   4   24 31 0   11 0 1     2 55
617755 WA King   school 5300390 17405   Bellevue School District 530039000077 3437 Newport Heights Elementary   Regular School No Elementary KG 05 2017   grade_1 34 5 4   0 35     0   11   42 47 0   29   1   19       1.0 89 34 5 4   0 35     0   11   42 47 0   29 1 19     1 89
617771 WA King   school 5300390 17405   Bellevue School District 530039000082 3168 Phantom Lake Elementary   Regular School No Elementary PK 05 2017   grade_1 24 0 4   0 13     0   3   26 18 0   14   0   9       3.0 44 24 0 4   0 13     0   3   26 18 0   14 0 9     3 44
617780 WA King   school 5300390 17405   Bellevue School District 530039000090 3224 Puesta del Sol Elementary School   Regular School No Elementary PK 05 2017   grade_1 51 1 23   0 9     0   13   46 51 0   8   0   9       4.0 97 51 1 23   0 9     0   13   46 51 0   8 0 9     4 97
617793 WA King   school 5300390 17405   Bellevue School District 530039000086 3339 Sherwood Forest Elementary   Regular School No Elementary PK 05 2017   grade_1 20 2 22   0 21     1   8   38 36 0   29   2   35       2.0 74 20 2 22   0 21     1   8   38 36 0   29 2 35     2 74
617801 WA King   school 5300390 17405   Bellevue School District 530039000087 3789 Somerset Elementary School   Regular School No Elementary KG 05 2017   grade_1 9 2 1   0 73     0   6   52 39 0   23   0   4       0.0 91 9 2 1   0 73     0   6   52 39 0   23 0 4     0 91
617808 WA King   school 5300390 17405   Bellevue School District 530039000088 3634 Spiritridge Elementary School   Regular School No Elementary KG 05 2017   grade_1 39 1 3   0 39     0   8   50 40 0   23   2   5       0.0 90 39 1 3   0 39     0   8   50 40 0   23 2 5     0 90
617815 WA King   school 5300390 17405   Bellevue School District 530039000089 3100 Stevenson Elementary   Regular School No Elementary PK 05 2017   grade_1 11 2 27   0 94     0   1   69 66 0   98   4   47       1.0 135 11 2 27   0 94     0   1   69 66 0   98 4 47     1 135
617831 WA King   school 5300390 17405   Bellevue School District 530039000096 3167 Woodridge Elementary   Regular School No Elementary KG 05 2017   grade_1 45 3 12   1 49     0   7   55 62 0   33   0   17       0.0 117 45 3 12   1 49     0   7   55 62 0   33 0 17     0 117
617838 WA Whatcom   school 5300420 37501   Bellingham School District 530042000098 3200 Alderwood Elementary School   Regular School No Elementary PK 05 2017   grade_1 17 0 19   0 3     0   1   18 22 0   13   1   32       2.0 40 17 0 19   0 3     0   1   18 22 0   13 1 32     2 40
617846 WA Whatcom   school 5300420 37501   Bellingham School District 530042003476 5366 Bellingham Family Partnership Program   Alternative School No Other KG 12 2017   grade_1 18 0 2   0 0     0   2   12 10 0   2   0   3       1.0 22 18 0 2   0 0     0   2   12 10 0   2 0 3     1 22
617864 WA Whatcom   school 5300420 37501   Bellingham School District 530042000100 2431 Birchwood Elementary School   Regular School No Elementary PK 05 2017   grade_1 21 1 34   0 3     0   8   37 30 0   20   8   49       0.0 67 21 1 34   0 3     0   8   37 30 0   20 8 49     0 67
617872 WA Whatcom   school 5300420 37501   Bellingham School District 530042000101 2817 Carl Cozier Elementary School   Regular School No Elementary PK 05 2017   grade_1 30 2 5   4 1     0   7   21 28 0   3   5   29       1.0 49 30 2 5   4 1     0   7   21 28 0   3 5 29     1 49
617880 WA Whatcom   school 5300420 37501   Bellingham School District 530042000103 2365 Columbia Elementary School   Regular School No Elementary PK 05 2017   grade_1 44 1 2   0 1     0   2   24 26 0   0   0   14       2.0 50 44 1 2   0 1     0   2   24 26 0   0 0 14     2 50
617887 WA Whatcom   school 5300420 37501   Bellingham School District 530042003358 5239 Cordata Elementary School   Regular School No Elementary PK 05 2017   grade_1 36 5 24   1 14     0   10   56 34 0   24   2   58       4.0 90 36 5 24   1 14     0   10   56 34 0   24 2 58     4 90
617900 WA Whatcom   school 5300420 37501   Bellingham School District 530042000105 2262 Geneva Elementary School   Regular School No Elementary PK 05 2017   grade_1 60 2 9   0 0     0   1   37 35 0   0   2   20       4.0 72 60 2 9   0 0     0   1   37 35 0   0 2 20     4 72
617908 WA Whatcom   school 5300420 37501   Bellingham School District 530042000106 3134 Happy Valley Elementary School   Regular School No Elementary PK 05 2017   grade_1 38 1 15   0 0     1   7   35 27 0   6   1   22       1.0 62 38 1 15   0 0     1   7   35 27 0   6 1 22     1 62
617926 WA Whatcom   school 5300420 37501   Bellingham School District 530042000108 2225 Lowell Elementary School   Regular School No Elementary PK 05 2017   grade_1 36 2 9   0 3     0   2   26 26 0   3   4   18       2.0 52 36 2 9   0 3     0   2   26 26 0   3 4 18     2 52
617934 WA Whatcom   school 5300420 37501   Bellingham School District 530042002939 4571 Northern Heights Elementary Schl   Regular School No Elementary PK 05 2017   grade_1 38 1 7   2 4     1   7   36 24 0   3   2   18       4.0 60 38 1 7   2 4     1   7   36 24 0   3 2 18     4 60
617947 WA Whatcom   school 5300420 37501   Bellingham School District 530042000110 3202 Parkview Elementary School   Regular School No Elementary PK 05 2017   grade_1 41 1 9   0 0     0   5   29 27 0   2   1   20       2.0 56 41 1 9   0 0     0   5   29 27 0   2 1 20     2 56
617955 WA Whatcom   school 5300420 37501   Bellingham School District 530042000112 2067 Roosevelt Elementary School   Regular School No Elementary PK 05 2017   grade_1 35 0 20   1 0     0   6   30 32 0   11   3   39       3.0 62 35 0 20   1 0     0   6   30 32 0   11 3 39     3 62
617971 WA Whatcom   school 5300420 37501   Bellingham School District 530042000115 2175 Silver Beach Elementary School   Regular School No Elementary PK 05 2017   grade_1 62 0 4   0 1     0   9   32 44 0   3   0   6       2.0 76 62 0 4   0 1     0   9   32 44 0   3 0 6     2 76
617984 WA Whatcom   school 5300420 37501   Bellingham School District 530042000116 2387 Sunnyland Elementary School   Regular School No Elementary PK 05 2017   grade_1 39 0 10   0 5     0   4   28 30 0   8   3   26       2.0 58 39 0 10   0 5     0   4   28 30 0   8 3 26     2 58
617998 WA Whatcom   school 5300420 37501   Bellingham School District 530042003225 5125 Wade King Elementary School   Regular School No Elementary PK 05 2017   grade_1 37 1 4   0 3     0   4   33 16 0   3   0   15       1.0 49 37 1 4   0 3     0   4   33 16 0   3 0 15     1 49
618010 WA Adams   school 5300450 1122   Benge School District 530045000118 3142 Benge Elementary   Regular School No Elementary KG 06 2017   grade_1 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
618022 WA Pierce   school   27403   Bethel School District   5471 Bethel Elementary Learning Academy             2017   grade_1 0 0 1   0 0     0   0   1 0 0   0   0   1       0.0 1 0 0 1   0 0     0   0   1 0 0   0 0 1     0 1
618038 WA Pierce   school 5300480 27403   Bethel School District 530048002202 4296 Camas Prairie Elementary   Regular School No Elementary KG 05 2017   grade_1 38 8 11   1 4     3   9   37 37 0   7   3   38       2.0 74 38 8 11   1 4     3   9   37 37 0   7 3 38     2 74
618051 WA Pierce   school 5300480 27403   Bethel School District 530048002250 4331 Centennial Elementary   Regular School No Elementary KG 05 2017   grade_1 67 2 12   0 0     3   13   49 48 0   2   4   58       1.0 97 67 2 12   0 0     3   13   49 48 0   2 4 58     1 97
618063 WA Pierce   school 5300480 27403   Bethel School District 530048000121 3649 Chester H Thompson Elementary   Regular School No Elementary KG 05 2017   grade_1 36 8 34   0 1     12   14   44 61 0   14   5   80       1.0 105 36 8 34   0 1     12   14   44 61 0   14 5 80     1 105
618071 WA Pierce   school 5300480 27403   Bethel School District 530048000122 2576 Clover Creek Elementary   Regular School No Elementary PK 05 2017   grade_1 57 8 23   0 9     5   15   67 50 0   3   1   65       0.0 117 57 8 23   0 9     5   15   67 50 0   3 1 65     0 117
618083 WA Pierce   school 5300480 27403   Bethel School District 530048000123 2877 Elk Plain School of Choice   Regular School No Elementary KG 08 2017   grade_1 34 0 7   1 1     0   8   25 26 0   0   0   15       0.0 51 34 0 7   1 1     0   8   25 26 0   0 0 15     0 51
618094 WA Pierce   school 5300480 27403   Bethel School District 530048001748 4099 Evergreen Elementary   Regular School No Elementary KG 05 2017   grade_1 36 4 15   0 6     8   18   52 35 0   20   2   57       1.0 87 36 4 15   0 6     8   18   52 35 0   20 2 57     1 87
618101 WA Pierce   school 5300480 27403   Bethel School District 530048003272 5159 Frederickson Elementary   Regular School No Elementary PK 05 2017   grade_1 41 5 24   1 0     0   10   39 42 0   6   2   35       0.0 81 41 5 24   1 0     0   10   39 42 0   6 2 35     0 81
618113 WA Pierce   school 5300480 27403   Bethel School District 530048002203 4297 Graham Elementary   Regular School No Elementary KG 05 2017   grade_1 88 4 10   0 3     0   11   62 55 0   2   1   38       1.0 117 88 4 10   0 3     0   11   62 55 0   2 1 38     1 117
618127 WA Pierce   school 5300480 27403   Bethel School District 530048000124 2748 Kapowsin Elementary   Regular School No Elementary KG 05 2017   grade_1 47 0 3   1 1     0   7   33 26 0   2   1   32       2.0 59 47 0 3   1 1     0   7   33 26 0   2 1 32     2 59
618138 WA Pierce   school 5300480 27403   Bethel School District 530048001749 4102 Naches Trail Elementary   Regular School No Elementary KG 05 2017   grade_1 41 8 14   5 2     3   14   48 39 0   5   3   46       0.0 87 41 8 14   5 2     3   14   48 39 0   5 3 46     0 87
618146 WA Pierce   school 5300480 27403   Bethel School District 530048003288 5160 Nelson Elementary School   Regular School No Elementary PK 05 2017   grade_1 58 2 15   0 0     2   13   41 49 0   2   1   40       1.0 90 58 2 15   0 0     2   13   41 49 0   2 1 40     1 90
618154 WA Pierce   school 5300480 27403   Bethel School District 530048002747 4538 North Star Elementary   Regular School No Elementary KG 05 2017   grade_1 45 5 10   1 2     3   9   30 46 0   3   1   47       1.0 76 45 5 10   1 2     3   9   30 46 0   3 1 47     1 76
618165 WA Pierce   school 5300480 27403   Bethel School District 530048002430 4381 Pioneer Valley Elementary   Regular School No Elementary KG 05 2017   grade_1 31 5 7   0 4     6   9   40 22 0   2   0   29       1.0 62 31 5 7   0 4     6   9   40 22 0   2 0 29     1 62
618173 WA Pierce   school 5300480 27403   Bethel School District 530048001925 4227 Rocky Ridge Elementary   Regular School No Elementary KG 05 2017   grade_1 46 2 14   4 2     1   4   41 32 0   8   2   47       0.0 73 46 2 14   4 2     1   4   41 32 0   8 2 47     0 73
618181 WA Pierce   school 5300480 27403   Bethel School District 530048000126 2543 Roy Elementary   Regular School No Elementary KG 05 2017   grade_1 39 0 3   1 0     0   7   30 20 0   1   1   28       3.0 50 39 0 3   1 0     0   7   30 20 0   1 1 28     3 50
618189 WA Pierce   school 5300480 27403   Bethel School District 530048001750 4103 Shining Mountain Elementary   Regular School No Elementary PK 05 2017   grade_1 49 2 24   0 5     7   32   55 64 0   7   8   76       3.0 119 49 2 24   0 5     7   32   55 64 0   7 8 76     3 119
618198 WA Pierce   school 5300480 27403   Bethel School District 530048000127 2399 Spanaway Elementary   Regular School No Elementary KG 05 2017   grade_1 30 2 16   1 0     2   16   33 34 0   14   7   50       0.0 67 30 2 16   1 0     2   16   33 34 0   14 7 50     0 67
618221 WA Klickitat   school 5300510 20203   Bickleton School District 530051000129 3392 Bickleton Elementary & High Schl   Regular School No Other KG 12 2017   grade_1 4 0 5   0 0     0   0   7 2 0   0   0   4       0.0 9 4 0 5   0 0     0   0   7 2 0   0 0 4     0 9
618242 WA Whatcom   school 5300570 37503   Blaine School District 530057003020 5021 Blaine Home Connections   Alternative School No Other KG 11 2017   grade_1 7 0 0   1 0     0   1   5 4 0   0   0   4       0.0 9 7 0 0   1 0     0   1   5 4 0   0 0 4     0 9
618257 WA Whatcom   school 5300570 37503   Blaine School District 530057001741 4476 Blaine Primary School   Regular School No Elementary KG 02 2017   grade_1 120 3 15   0 6     0   11   75 80 0   16   2   86       4.0 155 120 3 15   0 6     0   11   75 80 0   16 2 86     4 155

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