Data source: Big Local News · About: Big Local

1,244 rows where grade = "grade_4", state = "WA" and year = 2017 sorted by district_state_id

View and edit SQL

year

  • 2017 · 1,244

grade

  • grade_4 · 1,244
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
622469 WA Ferry   school 5303870 10003   Keller School District 530387000586 2602 Keller Elementary School   Regular School No Elementary KG 06 2017   grade_4 0 0 0   2 0     0   1   1 2 0   0   2   3       0.0 3 0 0 0   2 0     0   1   1 2 0   0 2 3     0 3
619745 WA Ferry   school 5301890 10050   Curlew School District 530189000295 2006 Curlew Elem & High School   Regular School No Other KG 12 2017   grade_4 11 1 1   0 0     0   4   11 6 0   0   1   14       1.0 17 11 1 1   0 0     0   4   11 6 0   0 1 14     1 17
626443 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_4 4 0 0   0 1     0   0   2 3 0   0   0   0       0.0 5 4 0 0   0 1     0   0   2 3 0   0 0 0     0 5
626450 WA Ferry   school 5306360 10065   Orient School District 530636000948 2136 Orient Elementary School   Regular School No Elementary KG 08 2017   grade_4 8 0 0   0 0     0   0   5 3 0   0   0   5       0.0 8 8 0 0   0 0     0   0   5 3 0   0 0 5     0 8
622237 WA Ferry   school 5300002 10070   Inchelium School District 530000202871 4215 Inchelium Elementary School   Regular School No Elementary KG 05 2017   grade_4 1 0 1   20 0     0   3   11 14 0   11   1   19       0.0 25 1 0 1   20 0     0   3   11 14 0   11 1 19     0 25
627756 WA Ferry   school 5307260 10309   Republic School District 530726001088 2789 Republic Elementary School   Regular School No Elementary KG 06 2017   grade_4 19 0 2   0 1     0   4   13 13 0   0   0   24       0.0 26 19 0 2   0 1     0   4   13 13 0   0 0 24     0 26
627771 WA Ferry   school 5307260 10309   Republic School District 530726002888 1898 Republic Parent Partner   Alternative School No Other KG 12 2017   grade_4 7 0 0   0 0     0   1   4 4 0   0   0   2       0.0 8 7 0 0   0 0     0   1   4 4 0   0 0 2     0 8
626590 WA Franklin   school 5306570 11001   Pasco School District 530657003520 5391 Barbara McClintock STEM Elementary   Regular School No Elementary PK 06 2017   grade_4 41 0 49   0 0     0   4   43 51 0   11   0   46       3.0 94 41 0 49   0 0     0   4   43 51 0   11 0 46     3 94
626600 WA Franklin   school 5306570 11001   Pasco School District 530657003552 5392 Captain Gray STEM Elementary   Regular School No Elementary PK 06 2017   grade_4 8 2 70   0 0     0   1   41 40 0   53   2   77       1.0 81 8 2 70   0 0     0   1   41 40 0   53 2 77     1 81
626616 WA Franklin   school 5306570 11001   Pasco School District 530657000963 3425 Edwin Markham Elementary   Regular School No Elementary KG 06 2017   grade_4 26 0 22   0 0     0   2   27 23 0   12   0   25       0.0 50 26 0 22   0 0     0   2   27 23 0   12 0 25     0 50
626628 WA Franklin   school 5306570 11001   Pasco School District 530657000964 2967 Emerson Elementary   Regular School No Elementary KG 06 2017   grade_4 7 0 79   0 0     0   0   48 38 0   41   4   83       1.0 86 7 0 79   0 0     0   0   48 38 0   41 4 83     1 86
626640 WA Franklin   school 5306570 11001   Pasco School District 530657001860 4155 James McGee Elementary   Regular School No Elementary KG 06 2017   grade_4 23 4 40   0 1     0   4   39 33 0   15   3   42       0.0 72 23 4 40   0 1     0   4   39 33 0   15 3 42     0 72
626650 WA Franklin   school 5306570 11001   Pasco School District 530657000965 2790 Longfellow Elementary   Regular School No Elementary PK 06 2017   grade_4 1 0 69   0 0     0   0   33 37 0   50   3   68       0.0 70 1 0 69   0 0     0   0   33 37 0   50 3 68     0 70
626658 WA Franklin   school 5306570 11001   Pasco School District 530657003542 5394 Marie Curie STEM Elementary   Regular School No Elementary 03 06 2017   grade_4 5 2 211   0 0     0   4   124 98 0   136   3   213       2.0 222 5 2 211   0 0     0   4   124 98 0   136 3 213     2 222
626665 WA Franklin   school 5306570 11001   Pasco School District 530657000966 3085 Mark Twain Elementary   Regular School No Elementary PK 06 2017   grade_4 33 1 74   1 0     0   3   56 56 0   33   1   79       1.0 112 33 1 74   1 0     0   3   56 56 0   33 1 79     1 112
626675 WA Franklin   school 5306570 11001   Pasco School District 530657002950 4595 Maya Angelou Elementary   Regular School No Elementary PK 06 2017   grade_4 51 1 61   0 2     0   10   58 67 0   23   0   63       1.0 125 51 1 61   0 2     0   10   58 67 0   23 0 63     1 125
626700 WA Franklin   school 5306570 11001   Pasco School District 530657000970 3515 Robert Frost Elementary   Regular School No Elementary PK 06 2017   grade_4 16 0 83   0 0     0   1   49 51 0   61   1   95       0.0 100 16 0 83   0 0     0   1   49 51 0   61 1 95     0 100
626709 WA Franklin   school 5306570 11001   Pasco School District 530657003499 5345 Rosalind Franklin STEM Elementary   Regular School No Elementary PK 06 2017   grade_4 60 3 61   0 1     0   4   66 63 0   21   1   66       3.0 129 60 3 61   0 1     0   4   66 63 0   21 1 66     3 129
626718 WA Franklin   school 5306570 11001   Pasco School District 530657002785 4555 Rowena Chess Elementary   Regular School No Elementary PK 06 2017   grade_4 3 0 90   0 0     0   2   42 53 0   59   2   92       1.0 95 3 0 90   0 0     0   2   42 53 0   59 2 92     1 95
626727 WA Franklin   school 5306570 11001   Pasco School District 530657000971 4041 Ruth Livingston Elementary   Regular School No Elementary PK 06 2017   grade_4 76 4 46   0 2     1   6   76 59 0   10   0   63       1.0 135 76 4 46   0 2     1   6   76 59 0   10 0 63     1 135
626739 WA Franklin   school 5306570 11001   Pasco School District 530657002951 5020 Virgie Robinson Elementary   Regular School No Elementary KG 06 2017   grade_4 3 2 130   0 0     0   0   71 64 0   95   5   134       0.0 135 3 2 130   0 0     0   0   71 64 0   95 5 134     0 135
625309 WA Franklin   school 5305730 11051   North Franklin School District 530573000846 3325 Basin City Elem   Regular School No Elementary KG 06 2017   grade_4 9 0 60   0 0     0   0   41 28 0   36   1   65       0.0 69 9 0 60   0 0     0   0   41 28 0   36 1 65     0 69
625317 WA Franklin   school 5305730 11051   North Franklin School District 530573000847 2918 Connell Elem   Regular School No Elementary KG 06 2017   grade_4 17 0 49   0 1     0   3   40 30 0   24   0   56       2.0 70 17 0 49   0 1     0   3   40 30 0   24 0 56     2 70
625333 WA Franklin   school 5305730 11051   North Franklin School District 530573000849 3086 Mesa Elem   Regular School No Elementary KG 06 2017   grade_4 8 0 16   0 0     0   0   13 11 0   8   0   21       0.0 24 8 0 16   0 0     0   0   13 11 0   8 0 21     0 24
625341 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_4 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
630273 WA Franklin   school 5308370 11054   Star School District No. 054 530837001426 2007 Star Elem School   Regular School No Elementary KG 05 2017   grade_4 1 0 1   0 0     0   0   0 2 0   0   0   0       0.0 2 1 0 1   0 0     0   0   0 2 0   0 0 0     0 2
622440 WA Franklin   school 5303780 11056   Kahlotus School District 530378000583 3214 Kahlotus Elem & High   Regular School No Other PK 12 2017   grade_4 3 0 0   0 0     0   0   2 1 0   0   0   2       0.0 3 3 0 0   0 0     0   0   2 1 0   0 0 2     0 3
632013 WA Adams   school 5309570 1109   Washtucna School District 530957001625 3075 Washtucna Elementary/High School   Regular School No Other KG 12 2017   grade_4 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
618013 WA Adams   school 5300450 1122   Benge School District 530045000118 3142 Benge Elementary   Regular School No Elementary KG 06 2017   grade_4 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
626521 WA Adams   school 5306480 1147   Othello School District 530648000954 2961 Hiawatha Elementary School   Regular School No Elementary KG 05 2017   grade_4 7 0 88   0 0     0   1   57 39 0   54   3   89       2.0 96 7 0 88   0 0     0   1   57 39 0   54 3 89     2 96
626530 WA Adams   school 5306480 1147   Othello School District 530648000955 2902 Lutacaga Elementary   Regular School No Elementary KG 05 2017   grade_4 5 0 92   0 0     0   0   48 49 0   55   2   85       3.0 97 5 0 92   0 0     0   0   48 49 0   55 2 85     3 97
626548 WA Adams   school 5306480 1147   Othello School District 530648000958 3730 Scootney Springs Elementary   Regular School No Elementary KG 05 2017   grade_4 8 0 81   0 0     0   0   47 42 0   46   0   77       1.0 89 8 0 81   0 0     0   0   47 42 0   46 0 77     1 89
626557 WA Adams   school 5306480 1147   Othello School District 530648003393 5285 Wahitis Elementary School   Regular School No Elementary KG 05 2017   grade_4 10 0 70   0 0     0   0   33 47 0   43   0   65       1.0 80 10 0 70   0 0     0   0   33 47 0   43 0 65     1 80
623751 WA Adams   school 5304410 1158   Lind School District 530441000695 3421 Lind Elementary School   Regular School No Elementary PK 05 2017   grade_4 14 0 6   0 0     0   0   11 9 0   4   2   19       0.0 20 14 0 6   0 0     0   0   11 9 0   4 2 19     0 20
627956 WA Adams   school 5307380 1160   Ritzville School District 530738001109 2719 Ritzville Grade School   Regular School No Elementary KG 05 2017   grade_4 24 1 2   0 1     0   0   13 15 0   0   0   13       0.0 28 24 1 2   0 1     0   0   13 15 0   0 0 13     0 28
626906 WA Garfield   school 5306780 12110   Pomeroy School District 530678000993 3087 Pomeroy Elementary School   Regular School No Elementary KG 06 2017   grade_4 18 0 3   0 0     0   0   10 11 0   2   1   13       0.0 21 18 0 3   0 0     0   0   10 11 0   2 1 13     0 21
631762 WA Grant   school 5309360 13073   Wahluke School District 530936001595 3152 Mattawa Elementary   Regular School No Elementary KG 05 2017   grade_4 1 0 57   1 0     0   1   30 30 0   38   2   60       3.0 60 1 0 57   1 0     0   1   30 30 0   38 2 60     3 60
631771 WA Grant   school 5309360 13073   Wahluke School District 530936001890 4222 Morris Schott Elementary   Regular School No Elementary KG 05 2017   grade_4 1 0 59   0 0     0   0   31 29 0   45   5   59       0.0 60 1 0 59   0 0     0   0   31 29 0   45 5 59     0 60
631778 WA Grant   school 5309360 13073   Wahluke School District 530936002514 4490 Saddle Mountain Elementary   Regular School No Elementary KG 05 2017   grade_4 3 0 86   0 0     0   1   53 37 0   57   1   89       0.0 90 3 0 86   0 0     0   1   53 37 0   57 1 89     0 90
627472 WA Grant   school 5307080 13144   Quincy School District 530708001052 3426 George Elementary   Regular School No Elementary KG 04 2017   grade_4 4 0 28   0 0     0   0   12 20 0   17   0   30       2.0 32 4 0 28   0 0     0   0   12 20 0   17 0 30     2 32
627475 WA Grant   school 5307080 13144   Quincy School District 530708002714 4536 Monument Elementary   Regular School No Elementary 04 06 2017   grade_4 18 0 171   0 0     0   1   94 96 0   91   9   178       7.0 190 18 0 171   0 0     0   1   94 96 0   91 9 178     7 190
631931 WA Grant   school 5309510 13146   Warden School District 530951001618 2792 Warden Elementary   Regular School No Elementary PK 05 2017   grade_4 15 0 66   0 0     0   1   40 42 0   45   15   81       1.0 82 15 0 66   0 0     0   1   40 42 0   45 15 81     1 82
619669 WA Grant   school 5303440 13151   Coulee-Hartline School District 530344000513 2693 Coulee City Elementary   Regular School No Elementary KG 05 2017   grade_4 12 0 2   0 0     0   0   9 5 0   0   0   9       0.0 14 12 0 2   0 0     0   0   9 5 0   0 0 9     0 14
629506 WA Grant   school 5308070 13156   Soap Lake School District 530807001334 2694 Soap Lake Elementary   Regular School No Elementary KG 05 2017   grade_4 21 0 16   0 0     0   0   20 17 0   11   7   34       0.0 37 21 0 16   0 0     0   0   20 17 0   11 7 34     0 37
628121 WA Grant   school 5307620 13160   Royal School District 530762003526 5388 Royal Intermediate School   Regular School No Elementary 04 06 2017   grade_4 26 0 109   0 0     0   0   71 64 0   76   14   111       7.0 135 26 0 109   0 0     0   0   71 64 0   76 14 111     7 135
624687 WA Grant   school 5305220 13161   Moses Lake School District 530522000787 3091 Garden Heights Elementary   Regular School No Elementary KG 05 2017   grade_4 38 0 37   0 1     0   2   45 33 0   8   0   47       3.0 78 38 0 37   0 1     0   2   45 33 0   8 0 47     3 78
624696 WA Grant   school 5305220 13161   Moses Lake School District 530522000788 2833 Knolls Vista Elementary   Regular School No Elementary KG 05 2017   grade_4 31 2 41   0 1     0   4   45 34 0   15   1   55       2.0 79 31 2 41   0 1     0   4   45 34 0   15 1 55     2 79
624705 WA Grant   school 5305220 13161   Moses Lake School District 530522000789 2969 Lakeview Terrace Elementary   Regular School No Elementary KG 05 2017   grade_4 40 1 38   0 0     0   1   37 43 0   8   1   53       5.0 80 40 1 38   0 0     0   1   37 43 0   8 1 53     5 80
624713 WA Grant   school 5305220 13161   Moses Lake School District 530522000790 3021 Larson Heights Elementary   Regular School No Elementary KG 05 2017   grade_4 16 0 27   0 0     0   0   22 21 0   14   1   42       2.0 43 16 0 27   0 0     0   0   22 21 0   14 1 42     2 43
624722 WA Grant   school 5305220 13161   Moses Lake School District 530522000791 3153 Longview Elementary   Regular School No Elementary KG 05 2017   grade_4 34 1 37   0 0     0   1   37 36 0   17   2   52       1.0 73 34 1 37   0 0     0   1   37 36 0   17 2 52     1 73
624729 WA Grant   school 5305220 13161   Moses Lake School District 530522001982 2970 Midway Elementary   Regular School No Elementary PK 06 2017   grade_4 18 0 20   0 0     0   1   20 19 0   6   5   34       2.0 39 18 0 20   0 0     0   1   20 19 0   6 5 34     2 39
624743 WA Grant   school 5305220 13161   Moses Lake School District 530522000793 3779 North Elementary   Regular School No Elementary KG 05 2017   grade_4 10 1 29   0 0     0   1   24 17 0   23   0   39       2.0 41 10 1 29   0 0     0   1   24 17 0   23 0 39     2 41
624752 WA Grant   school 5305220 13161   Moses Lake School District 530522003368 5251 Park Orchard Elementary School   Regular School No Elementary KG 05 2017   grade_4 37 2 40   0 0     0   2   40 41 0   20   1   54       3.0 81 37 2 40   0 0     0   2   40 41 0   20 1 54     3 81
624760 WA Grant   school 5305220 13161   Moses Lake School District 530522000794 2832 Peninsula Elementary   Regular School No Elementary KG 05 2017   grade_4 30 0 34   0 2     0   2   34 34 0   14   0   37       2.0 68 30 0 34   0 2     0   2   34 34 0   14 0 37     2 68
624769 WA Grant   school 5305220 13161   Moses Lake School District 530522003281 5173 Sage Point Elementary School   Regular School No Elementary KG 05 2017   grade_4 41 1 16   0 0     0   2   31 29 0   4   0   20       1.0 60 41 1 16   0 0     0   2   31 29 0   4 0 20     1 60
620599 WA Grant   school 5302610 13165   Ephrata School District 530261000384 2793 Columbia Ridge Elementary   Regular School No Elementary KG 04 2017   grade_4 62 0 32   0 0     0   2   46 50 0   13   1   67       4.0 96 62 0 32   0 0     0   2   46 50 0   13 1 67     4 96
620623 WA Grant   school 5302610 13165   Ephrata School District 530261000388 3092 Grant Elementary   Regular School No Elementary KG 04 2017   grade_4 70 1 24   0 1     0   2   50 48 0   8   0   54       6.0 98 70 1 24   0 1     0   2   50 48 0   8 0 54     6 98
632426 WA Grant   school 5309900 13167   Wilson Creek School District 530990001674 2472 Wilson Creek Elementary   Regular School No Elementary KG 06 2017   grade_4 10 0 5   0 0     0   0   4 11 0   1   0   7       1.0 15 10 0 5   0 0     0   0   4 11 0   1 0 7     1 15
621749 WA Grant   school 5303130 13301   Grand Coulee Dam School District 530313000494 2802 Lake Roosevelt Elementary   Regular School No Elementary PK 06 2017   grade_4 24 0 5   22 0     1   15   36 31 0   12   1   51       1.0 67 24 0 5   22 0     1   15   36 31 0   12 1 51     1 67
617044 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000001 2834 A J West Elementary   Regular School No Elementary PK 06 2017   grade_4 38 0 22   0 2     0   2   29 35 0   9   4   51       4.0 64 38 0 22   0 2     0   2   29 35 0   9 4 51     4 64
617054 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000005 3216 Central Park Elementary   Regular School No Elementary KG 06 2017   grade_4 13 0 5   0 1     0   2   12 9 0   2   3   13       2.0 21 13 0 5   0 1     0   2   12 9 0   2 3 13     2 21
617082 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000008 2449 McDermoth Elementary   Regular School No Elementary KG 06 2017   grade_4 34 1 22   0 0     0   4   29 32 0   13   3   41       1.0 61 34 1 22   0 0     0   4   29 32 0   13 3 41     1 61
617095 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000010 2763 Robert Gray Elementary   Regular School No Elementary PK 06 2017   grade_4 19 1 21   1 1     0   4   23 24 0   8   2   36       2.0 47 19 1 21   1 1     0   4   23 24 0   8 2 36     2 47
617104 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000011 2971 Stevens Elementary School   Regular School No Elementary PK 06 2017   grade_4 33 0 24   1 3     0   3   30 34 0   14   4   50       1.0 64 33 0 24   1 3     0   3   30 34 0   14 4 50     1 64
622205 WA Grays Harbor   school 5303660 14028   Hoquiam School District 530366000562 2972 Central Elementary School   Regular School No Elementary 04 05 2017   grade_4 81 1 24   7 0     0   13   71 55 0   8   2   83       2.0 126 81 1 24   7 0     0   13   71 55 0   8 2 83     2 126
625291 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_4 21 1 5   1 0     0   0   10 18 0   1   4   20       3.0 28 21 1 5   1 0     0   0   10 18 0   1 4 20     3 28
625300 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_4 9 0 0   6 0     0   2   12 5 0   0   2   15       2.0 17 9 0 0   6 0     0   2   12 5 0   0 2 15     2 17
624265 WA Grays Harbor   school 5304890 14065   McCleary School District 530489000742 2835 Mccleary Elem   Regular School No Elementary PK 08 2017   grade_4 27 0 1   0 0     0   3   14 17 0   0   3   17       1.0 31 27 0 1   0 0     0   3   14 17 0   0 3 17     1 31
624642 WA Grays Harbor   school 5305160 14066   Montesano School District 530516000781 3374 Simpson Avenue Elementary   Regular School No Elementary 03 06 2017   grade_4 98 0 9   1 1     0   11   54 66 0   2   1   47       4.0 120 98 0 9   1 1     0   11   54 66 0   2 1 47     4 120
620491 WA Grays Harbor   school 5302490 14068   Elma School District 530249000371 3217 Elma Elementary School   Regular School No Elementary PK 05 2017   grade_4 56 0 28   2 2     0   8   45 51 0   16   3   81       3.0 96 56 0 28   2 2     0   8   45 51 0   16 3 81     3 96
630966 WA Grays Harbor   school 5308730 14077   Taholah School District 530873002956 5032 Taholah Elementary & Middle School   Regular School No Elementary KG 08 2017   grade_4 0 0 2   6 0     0   2   5 5 0   0   0   8       0.0 10 0 0 2   6 0     0   2   5 5 0   0 0 8     0 10
623243 WA Grays Harbor   school 5307050 14097   Lake Quinault School District 530705001050 2921 Lake Quinault School   Regular School No Elementary KG 05 2017   grade_4 3 0 5   3 0     0   1   6 6 0   3   4   12       0.0 12 3 0 5   3 0     0   1   6 6 0   3 4 12     0 12
619655 WA Grays Harbor   school 5301710 14099   Cosmopolis School District 530171000288 3326 Cosmopolis Elementary School   Regular School No Elementary KG 06 2017   grade_4 17 0 2   0 0     0   1   7 13 0   0   0   10       1.0 20 17 0 2   0 0     0   1   7 13 0   0 0 10     1 20
632466 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_4 10 0 0   0 0     0   0   5 5 0   0   0   4       0.0 10 10 0 0   0 0     0   0   5 5 0   0 0 4     0 10
626073 WA Grays Harbor   school 5306090 14172   Ocosta School District 530609000913 3025 Ocosta Elementary School   Regular School No Elementary PK 06 2017   grade_4 29 0 12   1 0     0   5   23 24 0   4   16   43       0.0 47 29 0 12   1 0     0   5   23 24 0   4 16 43     0 47
626026 WA Grays Harbor   school 5306000 14400   Oakville School District 530600001858 2922 Oakville Elementary   Regular School No Elementary PK 06 2017   grade_4 7 0 7   3 0     0   2   10 9 0   1   1   12       0.0 19 7 0 7   3 0     0   2   10 9 0   1 1 12     0 19
625934 WA Island   school 5305940 15201   Oak Harbor School District 530594000898 3477 Broadview Elementary   Regular School No Elementary KG 05 2017   grade_4 59 3 13   0 9     1   17   41 61 0   4   2   39       2.0 102 59 3 13   0 9     1   17   41 61 0   4 2 39     2 102
625941 WA Island   school 5305940 15201   Oak Harbor School District 530594000900 3377 Crescent Harbor Elem   Regular School No Elementary KG 05 2017   grade_4 57 5 17   0 4     1   12   45 51 0   1   3   58       1.0 96 57 5 17   0 4     1   12   45 51 0   1 3 58     1 96
625949 WA Island   school 5305940 15201   Oak Harbor School District 530594002264 4328 Hillcrest Elementary   Regular School No Elementary 01 05 2017   grade_4 87 5 19   1 5     1   18   72 64 0   4   6   47       9.0 136 87 5 19   1 5     1   18   72 64 0   4 6 47     9 136
625958 WA Island   school 5305940 15201   Oak Harbor School District 530594002628 1758 Homeconnection   Alternative School No Other KG 12 2017   grade_4 17 1 0   0 0     0   1   13 6 0   0   1   3       0.0 19 17 1 0   0 0     0   1   13 6 0   0 1 3     0 19
625979 WA Island   school 5305940 15201   Oak Harbor School District 530594000902 2696 Oak Harbor Elementary   Regular School No Elementary PK 05 2017   grade_4 26 1 14   0 1     1   10   29 24 0   2   2   27       2.0 53 26 1 14   0 1     1   10   29 24 0   2 2 27     2 53
625997 WA Island   school 5305940 15201   Oak Harbor School District 530594000905 3566 Olympic View Elem   Regular School No Elementary KG 05 2017   grade_4 31 6 12   0 5     2   12   36 32 0   3   1   45       4.0 68 31 6 12   0 5     2   12   36 32 0   3 1 45     4 68
626002 WA Island   school 5305940 15201   Oak Harbor School District 530594002047 3662 Special Education   Special Education School No Elementary PK PK 2017   grade_4 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
619677 WA Island   school 5301800 15204   Coupeville School District 530180000289 3664 Coupeville Elementary School   Regular School No Elementary PK 05 2017   grade_4 59 0 16   0 0     0   8   46 37 0   4   4   33       1.0 83 59 0 16   0 0     0   8   46 37 0   4 4 33     1 83
629702 WA Island   school 5308190 15206   South Whidbey School District 530819002240 4321 South Whidbey Elementary   Regular School No Elementary PK 05 2017   grade_4 77 2 11   2 2     0   3   47 50 0   0   5   39       1.0 97 77 2 11   2 2     0   3   47 50 0   0 5 39     1 97
627384 WA Jefferson   school 5301380 16020   Queets-Clearwater School District 530138000243 2491 Queets-Clearwater Elementary   Regular School No Elementary KG 08 2017   grade_4 0 0 0   0 0     0   1   0 1 0   0   0   1       0.0 1 0 0 0   0 0     0   1   0 1 0   0 0 1     0 1
618410 WA Jefferson   school 5300750 16046   Brinnon School District 530075000153 2836 Brinnon Elementary   Regular School No Elementary KG 08 2017   grade_4 4 2 1   1 0     0   0   5 3 0   0   0   8       0.0 8 4 2 1   1 0     0   0   5 3 0   0 0 8     0 8
627397 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_4 21 0 1   0 1     0   0   12 11 0   0   0   0       0.0 23 21 0 1   0 1     0   0   12 11 0   0 0 0     0 23
627410 WA Jefferson   school 5306990 16048   Quilcene School District 530699001045 2474 Quilcene High And Elementary   Regular School No Other PK 12 2017   grade_4 13 0 1   1 0     0   3   9 9 0   0   0   8       0.0 18 13 0 1   1 0     0   3   9 9 0   0 0 8     0 18
619166 WA Jefferson   school 5301290 16049   Chimacum School District 530129000232 2697 Chimacum Elementary School   Regular School No Elementary 03 05 2017   grade_4 52 1 1   0 0     0   9   36 27 0   1   3   39       0.0 63 52 1 1   0 0     0   9   36 27 0   1 3 39     0 63
619187 WA Jefferson   school 5301290 16049   Chimacum School District 530129002630 1724 PI Program   Alternative School No Other KG 12 2017   grade_4 4 0 0   0 0     0   1   2 3 0   0   0   2       0.0 5 4 0 0   0 0     0   1   2 3 0   0 0 2     0 5
626992 WA Jefferson   school 5306840 16050   Port Townsend School District 530684001305 4475 Blue Heron Middle School   Regular School No Elementary 04 08 2017   grade_4 52 1 5   2 0     1   1   31 31 0   0   2   42       0.0 62 52 1 5   2 0     1   1   31 31 0   0 2 42     0 62
627004 WA Jefferson   school 5306840 16050   Port Townsend School District 530684002791 1798 OCEAN   Alternative School No Other KG 12 2017   grade_4 6 0 0   1 0     0   1   4 4 0   0   0   3       0.0 8 6 0 0   1 0     0   1   4 4 0   0 0 3     0 8
627019 WA Jefferson   school 5306840 16050   Port Townsend School District 530684001005 3094 Salish Coast Elementary   Regular School No Elementary KG 05 2017   grade_4 8 0 0   0 0     0   2   6 4 0   0   0   4       0.0 10 8 0 0   0 0     0   2   6 4 0   0 0 4     0 10
628155 WA King   school 5307710 17001   Seattle School District No. 1 530771001127 2138 Adams Elementary School   Regular School No Elementary KG 05 2017   grade_4 68 5 5   0 4     1   8   54 37 0   7   2   14       6.0 91 68 5 5   0 4     1   8   54 37 0   7 2 14     6 91
628171 WA King   school 5307710 17001   Seattle School District No. 1 530771001129 2181 Alki Elementary School   Regular School No Elementary PK 05 2017   grade_4 51 3 5   0 3     0   6   35 33 0   2   1   10       2.0 68 51 3 5   0 3     0   6   35 33 0   2 1 10     2 68
628178 WA King   school 5307710 17001   Seattle School District No. 1 530771001135 2730 Arbor Heights Elementary School   Regular School No Elementary KG 05 2017   grade_4 28 8 9   0 4     1   8   31 27 0   5   5   20       0.0 58 28 8 9   0 4     1   8   31 27 0   5 5 20     0 58
628186 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_4 17 10 2   0 3     0   6   19 19 0   5   6   20       0.0 38 17 10 2   0 3     0   6   19 19 0   5 6 20     0 38
628193 WA King   school 5307710 17001   Seattle School District No. 1 530771001173 2307 Bailey Gatzert Elementary School   Regular School No Elementary PK 05 2017   grade_4 1 27 9   0 7     0   4   30 18 0   17   11   38       0.0 48 1 27 9   0 7     0   4   30 18 0   17 11 38     0 48
628206 WA King   school 5307710 17001   Seattle School District No. 1 530771001140 2070 Beacon Hill International School   Regular School No Elementary KG 05 2017   grade_4 12 5 21   1 29     0   9   47 30 0   21   4   50       0.0 77 12 5 21   1 29     0   9   47 30 0   21 4 50     0 77

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