Data source: Big Local News · About: Big Local

8,837 rows where grade = "grade_4" and state = "WA" sorted by district_state_id

View and edit SQL

year

grade

  • grade_4 · 8,837
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
465143 WA Ferry   school 5303870 10003   Keller School District 530387000586 2602 Keller Elementary School   Regular School No 1.0 KG 06 2015   grade_4 0 0 0   6 0     0   0   2 4 0   0   3   6       0.0 6 0 0 0   6 0     0   0   2 4 0   0 3 6     0 6
525102 WA Ferry   school 5303870 10003   Keller School District 530387000586 2602 Keller Elementary School   Regular School No 1 KG 06 2016   grade_4 0 0 0   4 0     0   0   4 0 0   0   1   3       0.0 4 0 0 0   4 0     0   0   4 0 0   0 1 3     0 4
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
2418347 WA Ferry   school 5303870 10003   Keller School District 530387000586 2602 Keller Elementary School   Regular School No Elementary KG 06 2019   grade_4 0 0 0   8 0     0   0   5 3 0   0   0   4       0.0 8 0 0 0   8 0     0   0   5 3 0   0 0 4     0 8
2462838 WA Ferry   school 5303870 10003   Keller School District 530387000586 2602 Keller Elementary School   Regular School No Elementary KG 06 2018   grade_4 0 0 0   2 0     0   0   2 1 0   0   0   2       0.0 3 0 0 0   2 0     0   0   2 1 0   0 0 2     0 3
2575694 WA Ferry   school 5303870 10003   Keller School District 530387000586 2602 Keller Elementary School   Regular School No Elementary KG 06 2020   grade_4 1 0 0   3 0     0   0   3 1 0   0   1   3       0.0 4 1 0 0   3 0     0   0   3 1 0   0 1 3     0 4
2936564 WA Ferry   school 5303870 10003   Keller School District 530387000586 2602 Keller Elementary School   Regular School No Elementary KG 06 2021   grade_4 0 0 0   3 0     0   0   1 2 0   0   0   3       0.0 3 0 0 0   3 0     0   0   1 2 0   0 0 3     0 3
462391 WA Ferry   school 5301890 10050   Curlew School District 530189000295 2006 Curlew Elem & High School   Regular School No 4.0 KG 12 2015   grade_4 13 0 0   0 0     0   1   6 8 0   0   1   7       0.0 14 13 0 0   0 0     0   1   6 8 0   0 1 7     0 14
522379 WA Ferry   school 5301890 10050   Curlew School District 530189000295 2006 Curlew Elem & High School   Regular School No 4 PK 12 2016   grade_4 9 0 2   1 0     0   0   6 6 0   0   0   10       0.0 12 9 0 2   1 0     0   0   6 6 0   0 0 10     0 12
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
2415688 WA Ferry   school 5301890 10050   Curlew School District 530189000295 2006 Curlew Elem & High School   Regular School No Other PK 12 2019   grade_4 6 1 0   0 0     0   0   3 4 0   0   0   7       0.0 7 6 1 0   0 0     0   0   3 4 0   0 0 7     0 7
2460193 WA Ferry   school 5301890 10050   Curlew School District 530189000295 2006 Curlew Elem & High School   Regular School No Other KG 12 2018   grade_4 10 0 1   0 0     0   0   5 6 0   0   0   4       0.0 11 10 0 1   0 0     0   0   5 6 0   0 0 4     0 11
2573026 WA Ferry   school 5301890 10050   Curlew School District 530189000295 2006 Curlew Elem & High School   Regular School No Other PK 12 2020   grade_4 12 1 0   0 0     0   1   8 6 0   0   1   9       0.0 14 12 1 0   0 0     0   1   8 6 0   0 1 9     0 14
2933920 WA Ferry   school 5301890 10050   Curlew School District 530189000295 2006 Curlew Elem & High School   Regular School No Other PK 12 2021   grade_4 15 0 2   0 0     0   0   7 10 0   0   2   10       0.0 17 15 0 2   0 0     0   0   7 10 0   0 2 10     0 17
469126 WA Ferry   school 5306360 10065   Orient School District 530636003257 5155 Columbia Virtual Academy-Orient (Closed after 2017-2018 school year)   Alternative Education School No 1.0 KG 08 2015   grade_4 6 0 0   0 0     0   1   2 5 0   0   0   2       0.0 7 6 0 0   0 0     0   1   2 5 0   0 0 2     0 7
469133 WA Ferry   school 5306360 10065   Orient School District 530636000948 2136 Orient Elementary School   Regular School No 1.0 KG 08 2015   grade_4 4 0 0   0 0     0   0   3 1 0   0   0   4       0.0 4 4 0 0   0 0     0   0   3 1 0   0 0 4     0 4
529019 WA Ferry   school 5306360 10065   Orient School District 530636003257 5155 Columbia Virtual Academy-Orient (Closed after 2017-2018 school year)   Alternative Education School No 1 KG 05 2016   grade_4 5 1 0   1 2     0   0   4 5 0   0   0   0       0.0 9 5 1 0   1 2     0   0   4 5 0   0 0 0     0 9
529026 WA Ferry   school 5306360 10065   Orient School District 530636000948 2136 Orient Elementary School   Regular School No 1 KG 08 2016   grade_4 2 0 0   0 0     0   0   1 1 0   0   0   2       0.0 2 2 0 0   0 0     0   0   1 1 0   0 0 2     0 2
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
2422182 WA Ferry   school 5306360 10065   Orient School District 530636000948 2136 Orient Elementary School   Regular School No Elementary KG 08 2019   grade_4 6 0 0   0 0     0   0   4 2 0   0   0   4       0.0 6 6 0 0   0 0     0   0   4 2 0   0 0 4     0 6
2466650 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 2018   grade_4 1 1 0   0 1     0   0   2 1 0   0   0   0       0.0 3 1 1 0   0 1     0   0   2 1 0   0 0 0     0 3
2466657 WA Ferry   school 5306360 10065   Orient School District 530636000948 2136 Orient Elementary School   Regular School No Elementary KG 08 2018   grade_4 3 0 0   0 0     0   0   2 1 0   0   0   3       0.0 3 3 0 0   0 0     0   0   2 1 0   0 0 3     0 3
2579527 WA Ferry   school 5306360 10065   Orient School District 530636000948 2136 Orient Elementary School   Regular School No Elementary KG 08 2020   grade_4 5 0 0   0 0     0   0   1 4 0   0   0   4       0.0 5 5 0 0   0 0     0   0   1 4 0   0 0 4     0 5
2940471 WA Ferry   school 5306360 10065   Orient School District 530636000948 2136 Orient Elementary School   Regular School No Elementary KG 08 2021   grade_4 6 0 0   0 0     0   0   4 2 0   0   0   2       0.0 6 6 0 0   0 0     0   0   4 2 0   0 0 2     0 6
464903 WA Ferry   school 5300002 10070   Inchelium School District 530000202871 4215 Inchelium Elementary School   Regular School No 1.0 KG 05 2015   grade_4 0 0 0   17 0     0   3   11 9 0   0   1   16       0.0 20 0 0 0   17 0     0   3   11 9 0   0 1 16     0 20
524858 WA Ferry   school 5300002 10070   Inchelium School District 530000202871 4215 Inchelium Elementary School   Regular School No 1 PK 05 2016   grade_4 0 0 0   14 0     0   5   7 12 0   0   0   19       0.0 19 0 0 0   14 0     0   5   7 12 0   0 0 19     0 19
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
2418118 WA Ferry   school 5300002 10070   Inchelium School District 530000202871 4215 Inchelium Elementary School   Regular School No Elementary KG 05 2019   grade_4 0 0 1   16 0     0   1   9 9 0   7   0   17       0.0 18 0 0 1   16 0     0   1   9 9 0   7 0 17     0 18
2462613 WA Ferry   school 5300002 10070   Inchelium School District 530000202871 4215 Inchelium Elementary School   Regular School No Elementary KG 05 2018   grade_4 2 0 0   10 0     0   6   7 11 0   9   2   18       1.0 18 2 0 0   10 0     0   6   7 11 0   9 2 18     1 18
2575459 WA Ferry   school 5300002 10070   Inchelium School District 530000202871 4215 Inchelium Elementary School   Regular School No Elementary KG 05 2020   grade_4 0 0 0   14 0     0   1   4 11 0   10   0   10       0.0 15 0 0 0   14 0     0   1   4 11 0   10 0 10     0 15
2936337 WA Ferry   school 5300002 10070   Inchelium School District 530000202871 4215 Inchelium Elementary School   Regular School No Elementary KG 05 2021   grade_4 4 0 0   11 0     0   3   9 9 0   11   0   17       0.0 18 4 0 0   11 0     0   3   9 9 0   11 0 17     0 18
470397 WA Ferry   school 5307260 10309   Republic School District 530726001088 2789 Republic Elementary School   Regular School No 1.0 PK 06 2015   grade_4 22 0 0   0 0     0   2   12 12 0   0   1   19       1.0 24 22 0 0   0 0     0   2   12 12 0   0 1 19     1 24
530328 WA Ferry   school 5307260 10309   Republic School District 530726001088 2789 Republic Elementary School   Regular School No 1 PK 06 2016   grade_4 19 0 2   1 0     0   1   10 13 0   0   0   14       0.0 23 19 0 2   1 0     0   1   10 13 0   0 0 14     0 23
530343 WA Ferry   school 5307260 10309   Republic School District 530726002888 1898 Republic Parent Partner   Alternative Education School No 4 KG 12 2016   grade_4 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
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
2423461 WA Ferry   school 5307260 10309   Republic School District 530726001088 2789 Republic Elementary School   Regular School No Elementary PK 06 2019   grade_4 13 0 2   0 0     0   2   12 5 0   0   0   12       0.0 17 13 0 2   0 0     0   2   12 5 0   0 0 12     0 17
2423476 WA Ferry   school 5307260 10309   Republic School District 530726002888 1898 Republic Parent Partner   Alternative School No Other KG 12 2019   grade_4 7 0 0   0 0     0   0   4 3 0   0   0   0       0.0 7 7 0 0   0 0     0   0   4 3 0   0 0 0     0 7
2467962 WA Ferry   school 5307260 10309   Republic School District 530726001088 2789 Republic Elementary School   Regular School No Elementary KG 06 2018   grade_4 13 0 2   1 1     0   7   16 8 0   0   0   19       0.0 24 13 0 2   1 1     0   7   16 8 0   0 0 19     0 24
2467976 WA Ferry   school 5307260 10309   Republic School District 530726002888 1898 Republic Parent Partner   Alternative School No Other KG 12 2018   grade_4 10 0 1   0 0     0   0   5 6 0   0   0   1       0.0 11 10 0 1   0 0     0   0   5 6 0   0 0 1     0 11
2580853 WA Ferry   school 5307260 10309   Republic School District 530726001088 2789 Republic Elementary School   Regular School No Elementary PK 06 2020   grade_4 22 0 0   0 0     0   2   16 8 0   0   0   19       0.0 24 22 0 0   0 0     0   2   16 8 0   0 0 19     0 24
2580868 WA Ferry   school 5307260 10309   Republic School District 530726002888 1898 Republic Parent Partner   Alternative School No Other KG 12 2020   grade_4 2 0 0   0 0     0   0   2 0 0   0   0   0       0.0 2 2 0 0   0 0     0   0   2 0 0   0 0 0     0 2
2941838 WA Ferry   school 5307260 10309   Republic School District 530726001088 2789 Republic Elementary School   Regular School No Elementary PK 06 2021   grade_4 23 0 3   1 0     0   1   17 11 0   0   0   21       0.0 28 23 0 3   1 0     0   1   17 11 0   0 0 21     0 28
2941853 WA Ferry   school 5307260 10309   Republic School District 530726002888 1898 Republic Parent Partner   Alternative School No Other KG 12 2021   grade_4 7 0 0   0 0     0   0   5 2 0   0   0   0       0.0 7 7 0 0   0 0     0   0   5 2 0   0 0 0     0 7
469277 WA Franklin   school 5306570 11001   Pasco School District 530657000963 3425 Edwin Markham Elementary   Regular School No 1.0 KG 05 2015   grade_4 39 0 18   0 0     0   0   31 26 0   12   1   27       1.0 57 39 0 18   0 0     0   0   31 26 0   12 1 27     1 57
469288 WA Franklin   school 5306570 11001   Pasco School District 530657000964 2967 Emerson Elementary   Regular School No 1.0 KG 05 2015   grade_4 10 2 93   0 0     0   0   54 51 0   62   12   97       3.0 105 10 2 93   0 0     0   0   54 51 0   62 12 97     3 105
469295 WA Franklin   school 5306570 11001   Pasco School District 530657001860 4155 James McGee Elementary   Regular School No 1.0 KG 05 2015   grade_4 49 0 55   0 1     0   2   57 50 0   16   1   59       1.0 107 49 0 55   0 1     0   2   57 50 0   16 1 59     1 107
469304 WA Franklin   school 5306570 11001   Pasco School District 530657000965 2790 Longfellow Elementary   Regular School No 1.0 KG 05 2015   grade_4 8 0 91   0 0     0   0   45 54 0   70   3   97       3.0 99 8 0 91   0 0     0   0   45 54 0   70 3 97     3 99
469310 WA Franklin   school 5306570 11001   Pasco School District 530657000966 3085 Mark Twain Elementary   Regular School No 1.0 KG 05 2015   grade_4 32 2 63   0 1     0   1   53 46 0   34   1   74       0.0 99 32 2 63   0 1     0   1   53 46 0   34 1 74     0 99
469319 WA Franklin   school 5306570 11001   Pasco School District 530657002950 4595 Maya Angelou Elementary   Regular School No 1.0 KG 05 2015   grade_4 65 2 69   0 4     0   7   74 73 0   30   2   83       2.0 147 65 2 69   0 4     0   7   74 73 0   30 2 83     2 147
469346 WA Franklin   school 5306570 11001   Pasco School District 530657000970 3515 Robert Frost Elementary   Regular School No 1.0 KG 05 2015   grade_4 20 0 101   0 1     0   2   56 68 0   86   6   117       0.0 124 20 0 101   0 1     0   2   56 68 0   86 6 117     0 124
469352 WA Franklin   school 5306570 11001   Pasco School District 530657003499 5345 Rosalind Franklin STEM Elementary   Regular School No 1.0 KG 05 2015   grade_4 70 0 51   0 3     1   5   79 51 0   24   1   69       2.0 130 70 0 51   0 3     1   5   79 51 0   24 1 69     2 130
469360 WA Franklin   school 5306570 11001   Pasco School District 530657002785 4555 Rowena Chess Elementary   Regular School No 1.0 KG 05 2015   grade_4 1 0 110   0 0     0   0   53 58 0   75   1   110       0.0 111 1 0 110   0 0     0   0   53 58 0   75 1 110     0 111
469368 WA Franklin   school 5306570 11001   Pasco School District 530657000971 4041 Ruth Livingston Elementary   Regular School No 1.0 KG 05 2015   grade_4 74 5 47   2 2     0   12   76 66 0   14   1   61       0.0 142 74 5 47   2 2     0   12   76 66 0   14 1 61     0 142
469380 WA Franklin   school 5306570 11001   Pasco School District 530657002951 5020 Virgie Robinson Elementary   Regular School No 1.0 KG 05 2015   grade_4 6 1 118   0 0     0   1   50 76 0   92   6   126       0.0 126 6 1 118   0 0     0   1   50 76 0   92 6 126     0 126
469388 WA Franklin   school 5306570 11001   Pasco School District 530657002621 4526 Whittier Elementary   Regular School No 1.0 KG 05 2015   grade_4 5 0 124   0 0     0   1   59 71 0   98   4   128       1.0 130 5 0 124   0 0     0   1   59 71 0   98 4 128     1 130
529157 WA Franklin   school 5306570 11001   Pasco School District 530657003520 5391 Barbara McClintock STEM Elementary   Regular School No 1 PK 06 2016   grade_4 36 0 30   0 1     0   5   29 43 0   7   0   44       0.0 72 36 0 30   0 1     0   5   29 43 0   7 0 44     0 72
529167 WA Franklin   school 5306570 11001   Pasco School District 530657003552 5392 Captain Gray STEM Elementary   Regular School No 1 PK 06 2016   grade_4 4 1 76   0 0     0   1   40 42 0   61   0   78       0.0 82 4 1 76   0 0     0   1   40 42 0   61 0 78     0 82
529184 WA Franklin   school 5306570 11001   Pasco School District 530657000963 3425 Edwin Markham Elementary   Regular School No 1 PK 06 2016   grade_4 34 0 17   1 0     0   1   26 27 0   15   0   29       0.0 53 34 0 17   1 0     0   1   26 27 0   15 0 29     0 53
529197 WA Franklin   school 5306570 11001   Pasco School District 530657000964 2967 Emerson Elementary   Regular School No 1 PK 06 2016   grade_4 9 1 78   0 0     0   1   52 37 0   61   2   86       1.0 89 9 1 78   0 0     0   1   52 37 0   61 2 86     1 89
529208 WA Franklin   school 5306570 11001   Pasco School District 530657001860 4155 James McGee Elementary   Regular School No 1 PK 06 2016   grade_4 40 1 47   0 2     1   5   54 42 0   10   1   47       0.0 96 40 1 47   0 2     1   5   54 42 0   10 1 47     0 96
529218 WA Franklin   school 5306570 11001   Pasco School District 530657000965 2790 Longfellow Elementary   Regular School No 1 PK 06 2016   grade_4 1 1 66   0 0     0   1   33 36 0   54   4   69       1.0 69 1 1 66   0 0     0   1   33 36 0   54 4 69     1 69
529225 WA Franklin   school 5306570 11001   Pasco School District 530657003542 5394 Marie Curie STEM Elementary   Regular School No 1 03 06 2016   grade_4 13 2 185   0 1     0   1   89 113 0   155   0   195       0.0 202 13 2 185   0 1     0   1   89 113 0   155 0 195     0 202
529232 WA Franklin   school 5306570 11001   Pasco School District 530657000966 3085 Mark Twain Elementary   Regular School No 1 PK 06 2016   grade_4 61 2 49   0 0     0   2   57 57 0   36   0   82       0.0 114 61 2 49   0 0     0   2   57 57 0   36 0 82     0 114
529241 WA Franklin   school 5306570 11001   Pasco School District 530657002950 4595 Maya Angelou Elementary   Regular School No 1 PK 06 2016   grade_4 58 3 75   0 4     1   3   66 78 0   31   0   80       3.0 144 58 3 75   0 4     1   3   66 78 0   31 0 80     3 144
529266 WA Franklin   school 5306570 11001   Pasco School District 530657000970 3515 Robert Frost Elementary   Regular School No 1 PK 06 2016   grade_4 23 1 84   0 0     0   1   57 52 0   77   0   106       2.0 109 23 1 84   0 0     0   1   57 52 0   77 0 106     2 109
529275 WA Franklin   school 5306570 11001   Pasco School District 530657003499 5345 Rosalind Franklin STEM Elementary   Regular School No 1 PK 06 2016   grade_4 44 1 49   0 6     0   3   46 57 0   27   1   60       1.0 103 44 1 49   0 6     0   3   46 57 0   27 1 60     1 103
529285 WA Franklin   school 5306570 11001   Pasco School District 530657002785 4555 Rowena Chess Elementary   Regular School No 1 PK 06 2016   grade_4 7 0 74   0 0     0   0   36 45 0   57   4   78       0.0 81 7 0 74   0 0     0   0   36 45 0   57 4 78     0 81
529295 WA Franklin   school 5306570 11001   Pasco School District 530657000971 4041 Ruth Livingston Elementary   Regular School No 1 PK 06 2016   grade_4 72 1 29   0 5     0   3   56 54 0   10   0   35       1.0 110 72 1 29   0 5     0   3   56 54 0   10 0 35     1 110
529307 WA Franklin   school 5306570 11001   Pasco School District 530657002951 5020 Virgie Robinson Elementary   Regular School No 1 KG 06 2016   grade_4 11 1 98   0 1     0   0   64 47 0   87   2   109       1.0 111 11 1 98   0 1     0   0   64 47 0   87 2 109     1 111
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
2422322 WA Franklin   school 5306570 11001   Pasco School District 530657003520 5391 Barbara McClintock STEM Elementary   Regular School No Elementary PK 06 2019   grade_4 37 0 48   0 0     0   3   45 43 0   13   1   44       1.0 88 37 0 48   0 0     0   3   45 43 0   13 1 44     1 88
2422331 WA Franklin   school 5306570 11001   Pasco School District 530657003552 5392 Captain Gray STEM Elementary   Regular School No Elementary PK 06 2019   grade_4 3 0 91   0 0     0   1   46 49 0   66   3   89       0.0 95 3 0 91   0 0     0   1   46 49 0   66 3 89     0 95
2422346 WA Franklin   school 5306570 11001   Pasco School District 530657000963 3425 Edwin Markham Elementary   Regular School No Elementary KG 06 2019   grade_4 36 0 17   0 1     0   4   35 23 0   9   0   25       1.0 58 36 0 17   0 1     0   4   35 23 0   9 0 25     1 58
2422358 WA Franklin   school 5306570 11001   Pasco School District 530657000964 2967 Emerson Elementary   Regular School No Elementary KG 06 2019   grade_4 6 1 87   0 0     0   1   47 48 0   57   6   86       0.0 95 6 1 87   0 0     0   1   47 48 0   57 6 86     0 95
2422365 WA Franklin   school 5306570 11001   Pasco School District 530657003547 5393 Internet Pasco Academy of Learning   Alternative School No Elementary KG 08 2019   grade_4 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
2422373 WA Franklin   school 5306570 11001   Pasco School District 530657001860 4155 James McGee Elementary   Regular School No Elementary KG 06 2019   grade_4 33 0 63   0 1     2   6   56 49 0   15   1   63       1.0 105 33 0 63   0 1     2   6   56 49 0   15 1 63     1 105
2422382 WA Franklin   school 5306570 11001   Pasco School District 530657000965 2790 Longfellow Elementary   Regular School No Elementary PK 06 2019   grade_4 6 1 65   0 0     0   0   43 29 0   51   1   69       1.0 72 6 1 65   0 0     0   0   43 29 0   51 1 69     1 72
2422388 WA Franklin   school 5306570 11001   Pasco School District 530657003542 5394 Marie Curie STEM Elementary   Regular School No Elementary 03 06 2019   grade_4 8 0 212   0 3     0   1   98 126 0   155   6   212       1.0 224 8 0 212   0 3     0   1   98 126 0   155 6 212     1 224
2422395 WA Franklin   school 5306570 11001   Pasco School District 530657000966 3085 Mark Twain Elementary   Regular School No Elementary PK 06 2019   grade_4 21 0 74   0 1     0   2   54 44 0   34   3   75       3.0 98 21 0 74   0 1     0   2   54 44 0   34 3 75     3 98
2422404 WA Franklin   school 5306570 11001   Pasco School District 530657002950 4595 Maya Angelou Elementary   Regular School No Elementary PK 06 2019   grade_4 50 2 72   0 7     1   5   76 61 0   37   1   75       2.0 137 50 2 72   0 7     1   5   76 61 0   37 1 75     2 137
2422430 WA Franklin   school 5306570 11001   Pasco School District 530657000970 3515 Robert Frost Elementary   Regular School No Elementary PK 06 2019   grade_4 22 1 67   0 1     0   1   47 45 0   51   2   84       0.0 92 22 1 67   0 1     0   1   47 45 0   51 2 84     0 92
2422438 WA Franklin   school 5306570 11001   Pasco School District 530657003499 5345 Rosalind Franklin STEM Elementary   Regular School No Elementary PK 06 2019   grade_4 39 0 82   0 1     1   5   76 52 0   37   1   85       0.0 128 39 0 82   0 1     1   5   76 52 0   37 1 85     0 128
2422447 WA Franklin   school 5306570 11001   Pasco School District 530657002785 4555 Rowena Chess Elementary   Regular School No Elementary PK 06 2019   grade_4 2 0 83   0 0     0   0   51 34 0   47   6   80       0.0 85 2 0 83   0 0     0   0   51 34 0   47 6 80     0 85
2422456 WA Franklin   school 5306570 11001   Pasco School District 530657000971 4041 Ruth Livingston Elementary   Regular School No Elementary PK 06 2019   grade_4 65 1 45   0 3     0   11   60 65 0   10   1   57       2.0 125 65 1 45   0 3     0   11   60 65 0   10 1 57     2 125
2422468 WA Franklin   school 5306570 11001   Pasco School District 530657002951 5020 Virgie Robinson Elementary   Regular School No Elementary KG 06 2019   grade_4 1 0 112   0 0     0   0   56 57 0   85   0   102       0.0 113 1 0 112   0 0     0   0   56 57 0   85 0 102     0 113

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