Data source: Big Local News · About: Big Local

1,245 rows where grade = "grade_2", state = "WA" and year = 2017 sorted by district_state_id

View and edit SQL

year

  • 2017 · 1,245

grade

  • grade_2 · 1,245
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
622467 WA Ferry   school 5303870 10003   Keller School District 530387000586 2602 Keller Elementary School   Regular School No Elementary KG 06 2017   grade_2 0 0 0   8 0     0   0   5 3 0   0   3   5       0.0 8 0 0 0   8 0     0   0   5 3 0   0 3 5     0 8
619743 WA Ferry   school 5301890 10050   Curlew School District 530189000295 2006 Curlew Elem & High School   Regular School No Other KG 12 2017   grade_2 9 0 0   0 0     0   0   5 4 0   0   0   6       0.0 9 9 0 0   0 0     0   0   5 4 0   0 0 6     0 9
626441 WA Ferry   school 5306360 10065   Orient School District 530636003257 5155 Columbia Virtual Academy-Orient (Closed after 2017-2018 school year)   Alternative School No Elementary KG 05 2017   grade_2 7 0 1   0 1     0   0   5 4 0   0   0   0       0.0 9 7 0 1   0 1     0   0   5 4 0   0 0 0     0 9
626448 WA Ferry   school 5306360 10065   Orient School District 530636000948 2136 Orient Elementary School   Regular School No Elementary KG 08 2017   grade_2 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
622235 WA Ferry   school 5300002 10070   Inchelium School District 530000202871 4215 Inchelium Elementary School   Regular School No Elementary KG 05 2017   grade_2 0 0 1   15 0     0   1   9 8 0   10   2   16       0.0 17 0 0 1   15 0     0   1   9 8 0   10 2 16     0 17
627754 WA Ferry   school 5307260 10309   Republic School District 530726001088 2789 Republic Elementary School   Regular School No Elementary KG 06 2017   grade_2 13 0 2   1 0     0   3   12 7 0   0   0   18       0.0 19 13 0 2   1 0     0   3   12 7 0   0 0 18     0 19
627769 WA Ferry   school 5307260 10309   Republic School District 530726002888 1898 Republic Parent Partner   Alternative School No Other KG 12 2017   grade_2 8 0 0   0 0     0   0   5 3 0   0   0   1       0.0 8 8 0 0   0 0     0   0   5 3 0   0 0 1     0 8
626588 WA Franklin   school 5306570 11001   Pasco School District 530657003520 5391 Barbara McClintock STEM Elementary   Regular School No Elementary PK 06 2017   grade_2 33 0 46   0 0     0   5   46 38 0   16   2   46       0.0 84 33 0 46   0 0     0   5   46 38 0   16 2 46     0 84
626598 WA Franklin   school 5306570 11001   Pasco School District 530657003552 5392 Captain Gray STEM Elementary   Regular School No Elementary PK 06 2017   grade_2 4 2 92   0 0     0   1   48 51 0   69   1   95       0.0 99 4 2 92   0 0     0   1   48 51 0   69 1 95     0 99
626614 WA Franklin   school 5306570 11001   Pasco School District 530657000963 3425 Edwin Markham Elementary   Regular School No Elementary KG 06 2017   grade_2 31 0 11   1 0     0   1   31 13 0   12   0   24       0.0 44 31 0 11   1 0     0   1   31 13 0   12 0 24     0 44
626626 WA Franklin   school 5306570 11001   Pasco School District 530657000964 2967 Emerson Elementary   Regular School No Elementary KG 06 2017   grade_2 6 0 106   0 0     0   1   59 54 0   65   9   105       0.0 113 6 0 106   0 0     0   1   59 54 0   65 9 105     0 113
626634 WA Franklin   school 5306570 11001   Pasco School District 530657003547 5393 Internet Pasco Academy of Learning   Alternative School No Elementary KG 08 2017   grade_2 1 0 0   0 0     0   0   0 1 0   0   0   0       0.0 1 1 0 0   0 0     0   0   0 1 0   0 0 0     0 1
626638 WA Franklin   school 5306570 11001   Pasco School District 530657001860 4155 James McGee Elementary   Regular School No Elementary KG 06 2017   grade_2 33 2 49   0 1     1   5   51 40 0   18   1   54       1.0 91 33 2 49   0 1     1   5   51 40 0   18 1 54     1 91
626648 WA Franklin   school 5306570 11001   Pasco School District 530657000965 2790 Longfellow Elementary   Regular School No Elementary PK 06 2017   grade_2 3 0 62   0 0     0   1   41 25 0   47   3   66       0.0 66 3 0 62   0 0     0   1   41 25 0   47 3 66     0 66
626663 WA Franklin   school 5306570 11001   Pasco School District 530657000966 3085 Mark Twain Elementary   Regular School No Elementary PK 06 2017   grade_2 22 0 79   0 0     1   6   56 52 0   47   0   84       0.0 108 22 0 79   0 0     1   6   56 52 0   47 0 84     0 108
626673 WA Franklin   school 5306570 11001   Pasco School District 530657002950 4595 Maya Angelou Elementary   Regular School No Elementary PK 06 2017   grade_2 43 2 70   0 7     1   6   74 55 0   36   3   67       1.0 129 43 2 70   0 7     1   6   74 55 0   36 3 67     1 129
626698 WA Franklin   school 5306570 11001   Pasco School District 530657000970 3515 Robert Frost Elementary   Regular School No Elementary PK 06 2017   grade_2 22 0 65   0 0     0   1   50 38 0   62   0   82       1.0 88 22 0 65   0 0     0   1   50 38 0   62 0 82     1 88
626707 WA Franklin   school 5306570 11001   Pasco School District 530657003499 5345 Rosalind Franklin STEM Elementary   Regular School No Elementary PK 06 2017   grade_2 46 0 76   0 1     0   3   72 54 0   40   1   82       0.0 126 46 0 76   0 1     0   3   72 54 0   40 1 82     0 126
626716 WA Franklin   school 5306570 11001   Pasco School District 530657002785 4555 Rowena Chess Elementary   Regular School No Elementary PK 06 2017   grade_2 4 0 74   0 1     0   1   51 29 0   48   3   77       0.0 80 4 0 74   0 1     0   1   51 29 0   48 3 77     0 80
626725 WA Franklin   school 5306570 11001   Pasco School District 530657000971 4041 Ruth Livingston Elementary   Regular School No Elementary PK 06 2017   grade_2 62 0 35   2 3     0   4   55 51 0   13   0   45       1.0 106 62 0 35   2 3     0   4   55 51 0   13 0 45     1 106
626737 WA Franklin   school 5306570 11001   Pasco School District 530657002951 5020 Virgie Robinson Elementary   Regular School No Elementary KG 06 2017   grade_2 2 1 120   0 1     0   0   60 64 0   102   5   120       0.0 124 2 1 120   0 1     0   0   60 64 0   102 5 120     0 124
626746 WA Franklin   school 5306570 11001   Pasco School District 530657002621 4526 Whittier Elementary   Regular School No Elementary KG 02 2017   grade_2 6 0 200   0 1     0   1   88 120 0   158   0   204       1.0 208 6 0 200   0 1     0   1   88 120 0   158 0 204     1 208
625307 WA Franklin   school 5305730 11051   North Franklin School District 530573000846 3325 Basin City Elem   Regular School No Elementary KG 06 2017   grade_2 21 0 49   0 0     0   1   34 37 0   42   1   59       0.0 71 21 0 49   0 0     0   1   34 37 0   42 1 59     0 71
625315 WA Franklin   school 5305730 11051   North Franklin School District 530573000847 2918 Connell Elem   Regular School No Elementary KG 06 2017   grade_2 10 0 60   0 0     0   2   38 34 0   41   0   62       1.0 72 10 0 60   0 0     0   2   38 34 0   41 0 62     1 72
625331 WA Franklin   school 5305730 11051   North Franklin School District 530573000849 3086 Mesa Elem   Regular School No Elementary KG 06 2017   grade_2 8 0 16   0 0     0   0   14 10 0   13   0   17       0.0 24 8 0 16   0 0     0   0   14 10 0   13 0 17     0 24
625339 WA Franklin   school 5305730 11051   North Franklin School District 530573003364 5261 North Franklin Virtual Academy (Closed after 2019-2020 school year)   Alternative School No Elementary KG 06 2017   grade_2 1 0 0   0 0     0   0   0 1 0   0   0   0       0.0 1 1 0 0   0 0     0   0   0 1 0   0 0 0     0 1
622439 WA Franklin   school 5303780 11056   Kahlotus School District 530378000583 3214 Kahlotus Elem & High   Regular School No Other PK 12 2017   grade_2 2 0 2   0 0     0   1   3 2 0   0   0   4       0.0 5 2 0 2   0 0     0   1   3 2 0   0 0 4     0 5
632011 WA Adams   school 5309570 1109   Washtucna School District 530957001625 3075 Washtucna Elementary/High School   Regular School No Other KG 12 2017   grade_2 3 0 0   0 0     0   0   1 2 0   0   0   3       0.0 3 3 0 0   0 0     0   0   1 2 0   0 0 3     0 3
618011 WA Adams   school 5300450 1122   Benge School District 530045000118 3142 Benge Elementary   Regular School No Elementary KG 06 2017   grade_2 2 0 0   0 0     0   0   0 2 0   0   0   0       0.0 2 2 0 0   0 0     0   0   0 2 0   0 0 0     0 2
626519 WA Adams   school 5306480 1147   Othello School District 530648000954 2961 Hiawatha Elementary School   Regular School No Elementary KG 05 2017   grade_2 10 0 75   0 0     0   0   43 42 0   57   0   75       1.0 85 10 0 75   0 0     0   0   43 42 0   57 0 75     1 85
626528 WA Adams   school 5306480 1147   Othello School District 530648000955 2902 Lutacaga Elementary   Regular School No Elementary KG 05 2017   grade_2 7 0 86   0 0     0   0   46 47 0   66   0   75       1.0 93 7 0 86   0 0     0   0   46 47 0   66 0 75     1 93
626546 WA Adams   school 5306480 1147   Othello School District 530648000958 3730 Scootney Springs Elementary   Regular School No Elementary KG 05 2017   grade_2 10 0 74   0 0     0   1   47 38 0   54   0   74       0.0 85 10 0 74   0 0     0   1   47 38 0   54 0 74     0 85
626555 WA Adams   school 5306480 1147   Othello School District 530648003393 5285 Wahitis Elementary School   Regular School No Elementary KG 05 2017   grade_2 7 0 84   0 0     0   0   53 38 0   59   2   86       0.0 91 7 0 84   0 0     0   0   53 38 0   59 2 86     0 91
623749 WA Adams   school 5304410 1158   Lind School District 530441000695 3421 Lind Elementary School   Regular School No Elementary PK 05 2017   grade_2 10 0 4   0 0     0   0   8 6 0   3   3   13       0.0 14 10 0 4   0 0     0   0   8 6 0   3 3 13     0 14
627954 WA Adams   school 5307380 1160   Ritzville School District 530738001109 2719 Ritzville Grade School   Regular School No Elementary KG 05 2017   grade_2 22 1 1   0 0     0   1   17 8 0   0   0   17       0.0 25 22 1 1   0 0     0   1   17 8 0   0 0 17     0 25
626904 WA Garfield   school 5306780 12110   Pomeroy School District 530678000993 3087 Pomeroy Elementary School   Regular School No Elementary KG 06 2017   grade_2 24 0 2   0 0     0   0   14 12 0   1   0   18       0.0 26 24 0 2   0 0     0   0   14 12 0   1 0 18     0 26
631760 WA Grant   school 5309360 13073   Wahluke School District 530936001595 3152 Mattawa Elementary   Regular School No Elementary KG 05 2017   grade_2 5 0 66   2 0     0   0   37 36 0   52   3   73       1.0 73 5 0 66   2 0     0   0   37 36 0   52 3 73     1 73
631769 WA Grant   school 5309360 13073   Wahluke School District 530936001890 4222 Morris Schott Elementary   Regular School No Elementary KG 05 2017   grade_2 0 0 40   0 0     0   0   22 18 0   36   2   40       0.0 40 0 0 40   0 0     0   0   22 18 0   36 2 40     0 40
631776 WA Grant   school 5309360 13073   Wahluke School District 530936002514 4490 Saddle Mountain Elementary   Regular School No Elementary KG 05 2017   grade_2 4 0 72   0 0     0   0   42 34 0   63   3   72       1.0 76 4 0 72   0 0     0   0   42 34 0   63 3 72     1 76
627470 WA Grant   school 5307080 13144   Quincy School District 530708001052 3426 George Elementary   Regular School No Elementary KG 04 2017   grade_2 2 0 33   0 0     0   0   16 19 0   30   0   33       1.0 35 2 0 33   0 0     0   0   16 19 0   30 0 33     1 35
627481 WA Grant   school 5307080 13144   Quincy School District 530708001053 3020 Mountain View Elementary   Regular School No Elementary KG 03 2017   grade_2 14 1 93   0 0     0   0   43 65 0   71   1   95       3.0 108 14 1 93   0 0     0   0   43 65 0   71 1 95     3 108
627488 WA Grant   school 5307080 13144   Quincy School District 530708001054 2919 Pioneer Elementary   Regular School No Elementary KG 03 2017   grade_2 14 0 98   0 0     0   0   56 56 0   69   4   100       4.0 112 14 0 98   0 0     0   0   56 56 0   69 4 100     4 112
631929 WA Grant   school 5309510 13146   Warden School District 530951001618 2792 Warden Elementary   Regular School No Elementary PK 05 2017   grade_2 17 1 60   0 0     0   1   45 34 0   42   14   72       1.0 79 17 1 60   0 0     0   1   45 34 0   42 14 72     1 79
619667 WA Grant   school 5303440 13151   Coulee-Hartline School District 530344000513 2693 Coulee City Elementary   Regular School No Elementary KG 05 2017   grade_2 12 0 2   0 0     0   1   9 6 0   0   0   7       0.0 15 12 0 2   0 0     0   1   9 6 0   0 0 7     0 15
629504 WA Grant   school 5308070 13156   Soap Lake School District 530807001334 2694 Soap Lake Elementary   Regular School No Elementary KG 05 2017   grade_2 21 0 10   0 0     0   0   20 11 0   11   4   28       0.0 31 21 0 10   0 0     0   0   20 11 0   11 4 28     0 31
628111 WA Grant   school 5307620 13160   Royal School District 530762001122 3090 Red Rock Elementary   Regular School No Elementary KG 03 2017   grade_2 26 0 127   0 0     0   0   67 86 0   107   18   118       11.0 153 26 0 127   0 0     0   0   67 86 0   107 18 118     11 153
624685 WA Grant   school 5305220 13161   Moses Lake School District 530522000787 3091 Garden Heights Elementary   Regular School No Elementary KG 05 2017   grade_2 34 1 38   1 1     0   5   30 50 0   19   0   47       0.0 80 34 1 38   1 1     0   5   30 50 0   19 0 47     0 80
624694 WA Grant   school 5305220 13161   Moses Lake School District 530522000788 2833 Knolls Vista Elementary   Regular School No Elementary KG 05 2017   grade_2 26 1 42   0 1     0   3   39 34 0   23   1   57       2.0 73 26 1 42   0 1     0   3   39 34 0   23 1 57     2 73
624703 WA Grant   school 5305220 13161   Moses Lake School District 530522000789 2969 Lakeview Terrace Elementary   Regular School No Elementary KG 05 2017   grade_2 36 2 36   0 1     0   1   36 40 0   12   0   43       1.0 76 36 2 36   0 1     0   1   36 40 0   12 0 43     1 76
624711 WA Grant   school 5305220 13161   Moses Lake School District 530522000790 3021 Larson Heights Elementary   Regular School No Elementary KG 05 2017   grade_2 22 0 31   0 0     0   0   33 20 0   19   3   49       3.0 53 22 0 31   0 0     0   0   33 20 0   19 3 49     3 53
624720 WA Grant   school 5305220 13161   Moses Lake School District 530522000791 3153 Longview Elementary   Regular School No Elementary KG 05 2017   grade_2 44 0 35   0 0     1   0   43 37 0   25   3   57       0.0 80 44 0 35   0 0     1   0   43 37 0   25 3 57     0 80
624727 WA Grant   school 5305220 13161   Moses Lake School District 530522001982 2970 Midway Elementary   Regular School No Elementary PK 06 2017   grade_2 19 0 24   0 1     0   3   27 20 0   13   2   37       1.0 47 19 0 24   0 1     0   3   27 20 0   13 2 37     1 47
624741 WA Grant   school 5305220 13161   Moses Lake School District 530522000793 3779 North Elementary   Regular School No Elementary KG 05 2017   grade_2 23 0 21   0 0     0   0   19 25 0   11   2   38       0.0 44 23 0 21   0 0     0   0   19 25 0   11 2 38     0 44
624750 WA Grant   school 5305220 13161   Moses Lake School District 530522003368 5251 Park Orchard Elementary School   Regular School No Elementary KG 05 2017   grade_2 33 0 36   1 1     0   4   31 44 0   33   2   56       0.0 75 33 0 36   1 1     0   4   31 44 0   33 2 56     0 75
624758 WA Grant   school 5305220 13161   Moses Lake School District 530522000794 2832 Peninsula Elementary   Regular School No Elementary KG 05 2017   grade_2 34 1 37   0 0     0   2   38 36 0   21   0   56       0.0 74 34 1 37   0 0     0   2   38 36 0   21 0 56     0 74
624767 WA Grant   school 5305220 13161   Moses Lake School District 530522003281 5173 Sage Point Elementary School   Regular School No Elementary KG 05 2017   grade_2 40 0 16   0 0     0   0   25 31 0   4   1   22       0.0 56 40 0 16   0 0     0   0   25 31 0   4 1 22     0 56
620597 WA Grant   school 5302610 13165   Ephrata School District 530261000384 2793 Columbia Ridge Elementary   Regular School No Elementary KG 04 2017   grade_2 50 0 38   0 0     0   1   37 52 0   23   3   65       0.0 89 50 0 38   0 0     0   1   37 52 0   23 3 65     0 89
620621 WA Grant   school 5302610 13165   Ephrata School District 530261000388 3092 Grant Elementary   Regular School No Elementary KG 04 2017   grade_2 65 0 25   0 0     0   2   46 46 0   16   1   55       1.0 92 65 0 25   0 0     0   2   46 46 0   16 1 55     1 92
632424 WA Grant   school 5309900 13167   Wilson Creek School District 530990001674 2472 Wilson Creek Elementary   Regular School No Elementary KG 06 2017   grade_2 8 0 3   0 0     0   1   6 6 0   1   0   5       0.0 12 8 0 3   0 0     0   1   6 6 0   1 0 5     0 12
621747 WA Grant   school 5303130 13301   Grand Coulee Dam School District 530313000494 2802 Lake Roosevelt Elementary   Regular School No Elementary PK 06 2017   grade_2 12 0 3   19 0     0   18   33 19 0   11   1   43       0.0 52 12 0 3   19 0     0   18   33 19 0   11 1 43     0 52
617042 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000001 2834 A J West Elementary   Regular School No Elementary PK 06 2017   grade_2 38 0 38   3 0     0   5   42 42 0   24   4   71       0.0 84 38 0 38   3 0     0   5   42 42 0   24 4 71     0 84
617052 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000005 3216 Central Park Elementary   Regular School No Elementary KG 06 2017   grade_2 19 0 7   1 0     0   3   18 12 0   6   1   15       1.0 30 19 0 7   1 0     0   3   18 12 0   6 1 15     1 30
617080 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000008 2449 McDermoth Elementary   Regular School No Elementary KG 06 2017   grade_2 28 0 19   0 0     0   1   24 24 0   11   1   34       0.0 48 28 0 19   0 0     0   1   24 24 0   11 1 34     0 48
617093 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000010 2763 Robert Gray Elementary   Regular School No Elementary PK 06 2017   grade_2 22 0 19   1 0     1   4   26 21 0   14   1   36       1.0 47 22 0 19   1 0     1   4   26 21 0   14 1 36     1 47
617102 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000011 2971 Stevens Elementary School   Regular School No Elementary PK 06 2017   grade_2 34 2 22   0 2     0   4   36 28 0   16   5   55       1.0 64 34 2 22   0 2     0   4   36 28 0   16 5 55     1 64
622230 WA Grays Harbor   school 5303660 14028   Hoquiam School District 530366000566 3621 Lincoln Elementary   Regular School No Elementary PK 03 2017   grade_2 70 1 23   10 1     0   3   56 52 0   5   3   93       1.0 108 70 1 23   10 1     0   3   56 52 0   5 3 93     1 108
625289 WA Grays Harbor   school 5305700 14064   North Beach School District No. 64 530570000844 3787 Ocean Shores Elementary   Regular School No Elementary KG 06 2017   grade_2 24 0 4   6 0     0   0   19 15 0   0   5   29       0.0 34 24 0 4   6 0     0   0   19 15 0   0 5 29     0 34
625298 WA Grays Harbor   school 5305700 14064   North Beach School District No. 64 530570000845 3155 Pacific Beach Elementary School   Regular School No Elementary KG 06 2017   grade_2 3 0 5   7 0     0   4   7 12 0   1   1   18       0.0 19 3 0 5   7 0     0   4   7 12 0   1 1 18     0 19
624263 WA Grays Harbor   school 5304890 14065   McCleary School District 530489000742 2835 Mccleary Elem   Regular School No Elementary PK 08 2017   grade_2 42 2 2   0 0     0   2   29 19 0   1   5   33       0.0 48 42 2 2   0 0     0   2   29 19 0   1 5 33     0 48
624630 WA Grays Harbor   school 5305160 14066   Montesano School District 530516000779 3661 Beacon Avenue Elementary School   Regular School No Elementary KG 02 2017   grade_2 77 0 12   2 0     0   12   53 50 0   2   1   42       1.0 103 77 0 12   2 0     0   12   53 50 0   2 1 42     1 103
620489 WA Grays Harbor   school 5302490 14068   Elma School District 530249000371 3217 Elma Elementary School   Regular School No Elementary PK 05 2017   grade_2 67 1 24   1 0     0   10   60 43 0   14   3   89       1.0 103 67 1 24   1 0     0   10   60 43 0   14 3 89     1 103
630964 WA Grays Harbor   school 5308730 14077   Taholah School District 530873002956 5032 Taholah Elementary & Middle School   Regular School No Elementary KG 08 2017   grade_2 0 0 3   9 0     0   2   12 2 0   0   1   12       0.0 14 0 0 3   9 0     0   2   12 2 0   0 1 12     0 14
623241 WA Grays Harbor   school 5307050 14097   Lake Quinault School District 530705001050 2921 Lake Quinault School   Regular School No Elementary KG 05 2017   grade_2 4 0 10   3 0     0   1   9 9 0   7   4   18       0.0 18 4 0 10   3 0     0   1   9 9 0   7 4 18     0 18
619653 WA Grays Harbor   school 5301710 14099   Cosmopolis School District 530171000288 3326 Cosmopolis Elementary School   Regular School No Elementary KG 06 2017   grade_2 16 0 4   0 0     0   1   11 10 0   1   0   10       1.0 21 16 0 4   0 0     0   1   11 10 0   1 0 10     1 21
632464 WA Grays Harbor   school 5309990 14117   Wishkah Valley School District 530999001679 3375 Wishkah Valley Elementary/High School   Regular School No Other KG 12 2017   grade_2 11 0 0   0 0     0   0   4 7 0   0   0   10       0.0 11 11 0 0   0 0     0   0   4 7 0   0 0 10     0 11
626071 WA Grays Harbor   school 5306090 14172   Ocosta School District 530609000913 3025 Ocosta Elementary School   Regular School No Elementary PK 06 2017   grade_2 25 0 7   1 1     0   5   24 15 0   3   8   32       0.0 39 25 0 7   1 1     0   5   24 15 0   3 8 32     0 39
626024 WA Grays Harbor   school 5306000 14400   Oakville School District 530600001858 2922 Oakville Elementary   Regular School No Elementary PK 06 2017   grade_2 9 0 3   5 0     0   1   11 7 0   0   1   14       0.0 18 9 0 3   5 0     0   1   11 7 0   0 1 14     0 18
625932 WA Island   school 5305940 15201   Oak Harbor School District 530594000898 3477 Broadview Elementary   Regular School No Elementary KG 05 2017   grade_2 48 3 11   0 13     0   7   45 37 0   5   3   42       4.0 82 48 3 11   0 13     0   7   45 37 0   5 3 42     4 82
625939 WA Island   school 5305940 15201   Oak Harbor School District 530594000900 3377 Crescent Harbor Elem   Regular School No Elementary KG 05 2017   grade_2 56 2 12   0 1     0   16   50 37 0   7   3   50       2.0 87 56 2 12   0 1     0   16   50 37 0   7 3 50     2 87
625947 WA Island   school 5305940 15201   Oak Harbor School District 530594002264 4328 Hillcrest Elementary   Regular School No Elementary 01 05 2017   grade_2 61 2 21   0 6     1   13   50 54 0   3   2   31       3.0 104 61 2 21   0 6     1   13   50 54 0   3 2 31     3 104
625956 WA Island   school 5305940 15201   Oak Harbor School District 530594002628 1758 Homeconnection   Alternative School No Other KG 12 2017   grade_2 29 0 1   0 0     0   1   15 16 0   0   1   4       0.0 31 29 0 1   0 0     0   1   15 16 0   0 1 4     0 31
625977 WA Island   school 5305940 15201   Oak Harbor School District 530594000902 2696 Oak Harbor Elementary   Regular School No Elementary PK 05 2017   grade_2 39 1 18   0 5     1   7   32 39 0   7   2   21       2.0 71 39 1 18   0 5     1   7   32 39 0   7 2 21     2 71
625995 WA Island   school 5305940 15201   Oak Harbor School District 530594000905 3566 Olympic View Elem   Regular School No Elementary KG 05 2017   grade_2 46 3 23   0 3     1   17   55 38 0   9   3   55       5.0 93 46 3 23   0 3     1   17   55 38 0   9 3 55     5 93
619675 WA Island   school 5301800 15204   Coupeville School District 530180000289 3664 Coupeville Elementary School   Regular School No Elementary PK 05 2017   grade_2 35 0 7   0 0     0   11   24 29 0   3   4   26       2.0 53 35 0 7   0 0     0   11   24 29 0   3 4 26     2 53
629700 WA Island   school 5308190 15206   South Whidbey School District 530819002240 4321 South Whidbey Elementary   Regular School No Elementary PK 05 2017   grade_2 67 3 11   0 1     0   2   44 40 0   0   6   36       2.0 84 67 3 11   0 1     0   2   44 40 0   0 6 36     2 84
627382 WA Jefferson   school 5301380 16020   Queets-Clearwater School District 530138000243 2491 Queets-Clearwater Elementary   Regular School No Elementary KG 08 2017   grade_2 0 0 0   4 0     0   1   1 4 0   0   0   5       0.0 5 0 0 0   4 0     0   1   1 4 0   0 0 5     0 5
618408 WA Jefferson   school 5300750 16046   Brinnon School District 530075000153 2836 Brinnon Elementary   Regular School No Elementary KG 08 2017   grade_2 3 0 0   0 0     0   0   1 2 0   0   0   2       0.0 3 3 0 0   0 0     0   0   1 2 0   0 0 2     0 3
627395 WA Jefferson   school 5306990 16048   Quilcene School District 530699003353 5236 Partnership for Excellence in Alternative Remote Learning   Alternative School No Elementary KG 08 2017   grade_2 17 1 1   0 0     0   3   12 10 0   0   0   0       0.0 22 17 1 1   0 0     0   3   12 10 0   0 0 0     0 22
627408 WA Jefferson   school 5306990 16048   Quilcene School District 530699001045 2474 Quilcene High And Elementary   Regular School No Other PK 12 2017   grade_2 8 0 2   0 1     0   0   4 7 0   0   1   9       0.0 11 8 0 2   0 1     0   0   4 7 0   0 1 9     0 11
619161 WA Jefferson   school 5301290 16049   Chimacum School District 530129002790 4552 Chimacum Creek Primary School   Regular School No Elementary KG 02 2017   grade_2 64 0 9   0 0     0   3   43 33 0   1   2   45       0.0 76 64 0 9   0 0     0   3   43 33 0   1 2 45     0 76
619185 WA Jefferson   school 5301290 16049   Chimacum School District 530129002630 1724 PI Program   Alternative School No Other KG 12 2017   grade_2 3 0 0   0 0     0   0   0 3 0   0   0   0       0.0 3 3 0 0   0 0     0   0   0 3 0   0 0 0     0 3
627002 WA Jefferson   school 5306840 16050   Port Townsend School District 530684002791 1798 OCEAN   Alternative School No Other KG 12 2017   grade_2 4 0 0   0 0     0   0   3 1 0   0   0   1       0.0 4 4 0 0   0 0     0   0   3 1 0   0 0 1     0 4
627017 WA Jefferson   school 5306840 16050   Port Townsend School District 530684001005 3094 Salish Coast Elementary   Regular School No Elementary KG 05 2017   grade_2 64 1 6   0 2     0   2   36 39 0   5   0   42       3.0 75 64 1 6   0 2     0   2   36 39 0   5 0 42     3 75
628153 WA King   school 5307710 17001   Seattle School District No. 1 530771001127 2138 Adams Elementary School   Regular School No Elementary KG 05 2017   grade_2 65 5 7   1 1     0   12   50 41 0   7   5   17       1.0 91 65 5 7   1 1     0   12   50 41 0   7 5 17     1 91
628169 WA King   school 5307710 17001   Seattle School District No. 1 530771001129 2181 Alki Elementary School   Regular School No Elementary PK 05 2017   grade_2 60 3 7   0 2     0   11   46 37 0   5   2   19       0.0 83 60 3 7   0 2     0   11   46 37 0   5 2 19     0 83
628176 WA King   school 5307710 17001   Seattle School District No. 1 530771001135 2730 Arbor Heights Elementary School   Regular School No Elementary KG 05 2017   grade_2 51 3 3   0 7     1   10   45 30 0   4   1   21       2.0 75 51 3 3   0 7     1   10   45 30 0   4 1 21     2 75
628184 WA King   school 5307710 17001   Seattle School District No. 1 530771001157 3717 B F Day Elementary School   Regular School No Elementary KG 05 2017   grade_2 34 3 4   0 1     0   6   22 26 0   3   0   8       1.0 48 34 3 4   0 1     0   6   22 26 0   3 0 8     1 48
628191 WA King   school 5307710 17001   Seattle School District No. 1 530771001173 2307 Bailey Gatzert Elementary School   Regular School No Elementary PK 05 2017   grade_2 2 36 7   0 8     0   3   31 25 0   27   12   50       0.0 56 2 36 7   0 8     0   3   31 25 0   27 12 50     0 56
628204 WA King   school 5307710 17001   Seattle School District No. 1 530771001140 2070 Beacon Hill International School   Regular School No Elementary KG 05 2017   grade_2 11 5 22   2 23     0   13   31 45 0   24   5   44       0.0 76 11 5 22   2 23     0   13   31 45 0   24 5 44     0 76
628221 WA King   school 5307710 17001   Seattle School District No. 1 530771001145 2209 Broadview-Thomson K-8 School   Regular School No Elementary PK 08 2017   grade_2 22 16 21   0 2     0   8   43 26 0   27   5   48       1.0 69 22 16 21   0 2     0   8   43 26 0   27 5 48     1 69

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