Data source: Big Local News · About: Big Local

1,246 rows where grade = "grade_1", state = "WA" and year = 2017 sorted by school_nces_id

View and edit SQL

year

  • 2017 · 1,246

grade

  • grade_1 · 1,246
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
620533 WA King   school 5300001 17216   Enumclaw School District 530000100376 3430 Black Diamond Elementary   Regular School No Elementary KG 05 2017   grade_1 29 0 9   1 1     0   4   25 19 0   10   1   19       0.0 44 29 0 9   1 1     0   4   25 19 0   10 1 19     0 44
620540 WA King   school 5300001 17216   Enumclaw School District 530000100377 2980 Byron Kibler Elementary School   Regular School No Elementary KG 05 2017   grade_1 43 0 15   1 0     0   2   31 30 0   6   2   33       3.0 61 43 0 15   1 0     0   2   31 30 0   6 2 33     3 61
620558 WA King   school 5300001 17216   Enumclaw School District 530000100382 3739 Southwood Elementary School   Regular School No Elementary PK 05 2017   grade_1 29 1 6   0 0     0   3   23 16 0   5   2   14       0.0 39 29 1 6   0 0     0   3   23 16 0   5 2 14     0 39
620584 WA King   school 5300001 17216   Enumclaw School District 530000100383 3585 Westwood Elementary School   Regular School No Elementary PK 05 2017   grade_1 45 0 6   0 0     0   1   27 25 0   2   2   19       0.0 52 45 0 6   0 0     0   1   27 25 0   2 2 19     0 52
620572 WA King   school 5300001 17216   Enumclaw School District 530000100478 4289 Sunrise Elementary   Regular School No Elementary KG 05 2017   grade_1 51 1 13   0 0     1   4   36 34 0   10   1   27       0.0 70 51 1 13   0 0     1   4   36 34 0   10 1 27     0 70
622234 WA Ferry   school 5300002 10070   Inchelium School District 530000202871 4215 Inchelium Elementary School   Regular School No Elementary KG 05 2017   grade_1 0 0 0   16 0     0   1   7 10 0   10   0   13       0.0 17 0 0 0   16 0     0   1   7 10 0   10 0 13     0 17
622497 WA Cowlitz   school 5300003 8458   Kelso School District 530000300167 2913 Carrolls Elementary   Regular School No Elementary KG 05 2017   grade_1 21 0 1   0 3     0   1   12 14 0   1   1   11       0.0 26 21 0 1   0 3     0   1   12 14 0   1 1 11     0 26
622474 WA Cowlitz   school 5300003 8458   Kelso School District 530000300587 3323 Barnes Elementary   Regular School No Elementary KG 05 2017   grade_1 40 1 17   1 1     1   2   31 32 0   7   3   55       1.0 63 40 1 17   1 1     1   2   31 32 0   7 3 55     1 63
622483 WA Cowlitz   school 5300003 8458   Kelso School District 530000300588 3578 Beacon Hill Elementary   Regular School No Elementary KG 05 2017   grade_1 69 0 8   0 0     0   4   37 44 0   7   4   44       1.0 81 69 0 8   0 0     0   4   37 44 0   7 4 44     1 81
622490 WA Cowlitz   school 5300003 8458   Kelso School District 530000300589 3082 Butler Acres Elementary   Regular School No Elementary KG 05 2017   grade_1 49 0 12   1 1     1   0   30 34 0   6   1   34       0.0 64 49 0 12   1 1     1   0   30 34 0   6 1 34     0 64
622505 WA Cowlitz   school 5300003 8458   Kelso School District 530000300590 2691 Catlin Elementary   Regular School No Elementary KG 05 2017   grade_1 32 0 9   0 0     3   10   29 25 0   6   3   44       2.0 54 32 0 9   0 0     3   10   29 25 0   6 3 44     2 54
622536 WA Cowlitz   school 5300003 8458   Kelso School District 530000300594 2596 Rose Valley Elementary   Regular School No Elementary KG 05 2017   grade_1 18 0 2   0 0     1   0   8 13 0   0   1   8       0.0 21 18 0 2   0 0     1   0   8 13 0   0 1 8     0 21
622551 WA Cowlitz   school 5300003 8458   Kelso School District 530000300596 2624 Wallace Elementary   Regular School No Elementary KG 05 2017   grade_1 38 1 13   0 2     0   4   30 28 0   16   5   52       0.0 58 38 1 13   0 2     0   4   30 28 0   16 5 52     0 58
631949 WA Thurston   school 5300015 34975   Washington Center for Deaf and Hard of Hearing Youth 530001501016 4246 Washington State School for the Deaf   Regular School No Other PK 12 2017   grade_1 2 0 0   0 0     0   0   1 1 0   0   0   1       0.0 2 2 0 0   0 0     0   0   1 1 0   0 0 1     0 2
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
629520 WA Pierce   school 5300336 27909   SOAR Academy Charter District 530033603508 5379 SOAR Academy (Closed after 2018-2019 school year)   Regular School Yes Elementary KG 08 2017   grade_1 7 23 5   1 0     2   13   21 30 0   4   4   39       0.0 51 7 23 5   1 0     2   13   21 30 0   4 4 39     0 51
629729 WA Spokane   school 5300337 32901   Spokane International Academy 530033703539 5381 Spokane International Academy   Regular School Yes Elementary KG 07 2017   grade_1 37 2 4   0 0     0   5   20 28 0   0   0   26       0.0 48 37 2 4   0 0     0   5   20 28 0   0 0 26     0 48
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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

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