Data source: Big Local News · About: Big Local

8,787 rows where grade = "grade_1" and state = "WA" sorted by district_state_id

View and edit SQL

year

grade

  • grade_1 · 8,787
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
465140 WA Ferry   school 5303870 10003   Keller School District 530387000586 2602 Keller Elementary School   Regular School No 1.0 KG 06 2015   grade_1 1 0 0   4 0     0   0   5 0 0   0   2   4       0.0 5 1 0 0   4 0     0   0   5 0 0   0 2 4     0 5
525099 WA Ferry   school 5303870 10003   Keller School District 530387000586 2602 Keller Elementary School   Regular School No 1 KG 06 2016   grade_1 0 0 0   9 0     0   0   6 3 0   0   5   7       0.0 9 0 0 0   9 0     0   0   6 3 0   0 5 7     0 9
622466 WA Ferry   school 5303870 10003   Keller School District 530387000586 2602 Keller Elementary School   Regular School No Elementary KG 06 2017   grade_1 0 0 0   3 0     0   0   1 2 0   0   1   2       0.0 3 0 0 0   3 0     0   0   1 2 0   0 1 2     0 3
2418344 WA Ferry   school 5303870 10003   Keller School District 530387000586 2602 Keller Elementary School   Regular School No Elementary KG 06 2019   grade_1 0 0 0   4 0     0   0   2 2 0   0   0   3       0.0 4 0 0 0   4 0     0   0   2 2 0   0 0 3     0 4
2462835 WA Ferry   school 5303870 10003   Keller School District 530387000586 2602 Keller Elementary School   Regular School No Elementary KG 06 2018   grade_1 0 0 0   3 0     0   0   1 3 0   0   0   4       0.0 4 0 0 0   3 0     0   0   1 3 0   0 0 4     0 4
2575691 WA Ferry   school 5303870 10003   Keller School District 530387000586 2602 Keller Elementary School   Regular School No Elementary KG 06 2020   grade_1 0 0 0   7 0     0   0   4 3 0   0   0   7       0.0 7 0 0 0   7 0     0   0   4 3 0   0 0 7     0 7
2936561 WA Ferry   school 5303870 10003   Keller School District 530387000586 2602 Keller Elementary School   Regular School No Elementary KG 06 2021   grade_1 0 0 0   7 0     0   0   5 2 0   0   0   6       0.0 7 0 0 0   7 0     0   0   5 2 0   0 0 6     0 7
462388 WA Ferry   school 5301890 10050   Curlew School District 530189000295 2006 Curlew Elem & High School   Regular School No 4.0 KG 12 2015   grade_1 6 0 1   0 0     0   0   4 3 0   0   0   3       0.0 7 6 0 1   0 0     0   0   4 3 0   0 0 3     0 7
522376 WA Ferry   school 5301890 10050   Curlew School District 530189000295 2006 Curlew Elem & High School   Regular School No 4 PK 12 2016   grade_1 9 0 0   0 0     0   0   5 4 0   0   0   4       0.0 9 9 0 0   0 0     0   0   5 4 0   0 0 4     0 9
619742 WA Ferry   school 5301890 10050   Curlew School District 530189000295 2006 Curlew Elem & High School   Regular School No Other KG 12 2017   grade_1 10 0 0   0 0     0   1   8 3 0   0   0   5       0.0 11 10 0 0   0 0     0   1   8 3 0   0 0 5     0 11
2415685 WA Ferry   school 5301890 10050   Curlew School District 530189000295 2006 Curlew Elem & High School   Regular School No Other PK 12 2019   grade_1 8 0 0   0 0     0   1   4 5 0   0   0   8       0.0 9 8 0 0   0 0     0   1   4 5 0   0 0 8     0 9
2460190 WA Ferry   school 5301890 10050   Curlew School District 530189000295 2006 Curlew Elem & High School   Regular School No Other KG 12 2018   grade_1 16 0 1   0 0     0   0   7 10 0   0   1   10       0.0 17 16 0 1   0 0     0   0   7 10 0   0 1 10     0 17
2573023 WA Ferry   school 5301890 10050   Curlew School District 530189000295 2006 Curlew Elem & High School   Regular School No Other PK 12 2020   grade_1 6 0 1   0 0     0   3   6 4 0   0   0   6       0.0 10 6 0 1   0 0     0   3   6 4 0   0 0 6     0 10
2933917 WA Ferry   school 5301890 10050   Curlew School District 530189000295 2006 Curlew Elem & High School   Regular School No Other PK 12 2021   grade_1 10 0 1   0 0     0   2   7 6 0   0   1   10       0.0 13 10 0 1   0 0     0   2   7 6 0   0 1 10     0 13
469123 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_1 7 0 0   0 1     0   0   4 4 0   0   0   2       0.0 8 7 0 0   0 1     0   0   4 4 0   0 0 2     0 8
469130 WA Ferry   school 5306360 10065   Orient School District 530636000948 2136 Orient Elementary School   Regular School No 1.0 KG 08 2015   grade_1 2 0 0   0 1     0   0   0 3 0   0   0   2       0.0 3 2 0 0   0 1     0   0   0 3 0   0 0 2     0 3
529016 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_1 5 0 1   0 1     0   1   1 7 0   0   2   0       0.0 8 5 0 1   0 1     0   1   1 7 0   0 2 0     0 8
529023 WA Ferry   school 5306360 10065   Orient School District 530636000948 2136 Orient Elementary School   Regular School No 1 KG 08 2016   grade_1 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
626440 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_1 4 0 2   0 1     0   0   3 4 0   0   0   0       0.0 7 4 0 2   0 1     0   0   3 4 0   0 0 0     0 7
626447 WA Ferry   school 5306360 10065   Orient School District 530636000948 2136 Orient Elementary School   Regular School No Elementary KG 08 2017   grade_1 4 0 0   0 0     0   0   2 2 0   0   0   2       0.0 4 4 0 0   0 0     0   0   2 2 0   0 0 2     0 4
2422179 WA Ferry   school 5306360 10065   Orient School District 530636000948 2136 Orient Elementary School   Regular School No Elementary KG 08 2019   grade_1 4 0 0   0 1     0   0   4 1 0   0   0   3       0.0 5 4 0 0   0 1     0   0   4 1 0   0 0 3     0 5
2466647 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_1 5 0 1   0 0     0   0   5 1 0   0   0   1       0.0 6 5 0 1   0 0     0   0   5 1 0   0 0 1     0 6
2466654 WA Ferry   school 5306360 10065   Orient School District 530636000948 2136 Orient Elementary School   Regular School No Elementary KG 08 2018   grade_1 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
2579524 WA Ferry   school 5306360 10065   Orient School District 530636000948 2136 Orient Elementary School   Regular School No Elementary KG 08 2020   grade_1 6 0 0   2 0     0   0   2 6 0   0   1   5       0.0 8 6 0 0   2 0     0   0   2 6 0   0 1 5     0 8
2940468 WA Ferry   school 5306360 10065   Orient School District 530636000948 2136 Orient Elementary School   Regular School No Elementary KG 08 2021   grade_1 6 0 0   0 0     0   0   3 3 0   0   0   3       0.0 6 6 0 0   0 0     0   0   3 3 0   0 0 3     0 6
464900 WA Ferry   school 5300002 10070   Inchelium School District 530000202871 4215 Inchelium Elementary School   Regular School No 1.0 KG 05 2015   grade_1 2 0 0   10 0     0   7   9 10 0   0   0   16       0.0 19 2 0 0   10 0     0   7   9 10 0   0 0 16     0 19
524855 WA Ferry   school 5300002 10070   Inchelium School District 530000202871 4215 Inchelium Elementary School   Regular School No 1 PK 05 2016   grade_1 0 0 1   13 0     0   2   7 9 0   0   0   15       0.0 16 0 0 1   13 0     0   2   7 9 0   0 0 15     0 16
622234 WA Ferry   school 5300002 10070   Inchelium School District 530000202871 4215 Inchelium Elementary School   Regular School No Elementary KG 05 2017   grade_1 0 0 0   16 0     0   1   7 10 0   10   0   13       0.0 17 0 0 0   16 0     0   1   7 10 0   10 0 13     0 17
2418115 WA Ferry   school 5300002 10070   Inchelium School District 530000202871 4215 Inchelium Elementary School   Regular School No Elementary KG 05 2019   grade_1 0 0 0   12 0     0   2   6 8 0   5   0   14       0.0 14 0 0 0   12 0     0   2   6 8 0   5 0 14     0 14
2462610 WA Ferry   school 5300002 10070   Inchelium School District 530000202871 4215 Inchelium Elementary School   Regular School No Elementary KG 05 2018   grade_1 2 0 1   11 0     0   5   10 9 0   11   2   19       0.0 19 2 0 1   11 0     0   5   10 9 0   11 2 19     0 19
2575456 WA Ferry   school 5300002 10070   Inchelium School District 530000202871 4215 Inchelium Elementary School   Regular School No Elementary KG 05 2020   grade_1 1 0 0   9 0     0   2   7 5 0   10   0   11       0.0 12 1 0 0   9 0     0   2   7 5 0   10 0 11     0 12
2936334 WA Ferry   school 5300002 10070   Inchelium School District 530000202871 4215 Inchelium Elementary School   Regular School No Elementary KG 05 2021   grade_1 1 0 0   13 0     0   0   4 10 0   0   0   13       0.0 14 1 0 0   13 0     0   0   4 10 0   0 0 13     0 14
470394 WA Ferry   school 5307260 10309   Republic School District 530726001088 2789 Republic Elementary School   Regular School No 1.0 PK 06 2015   grade_1 15 0 1   1 1     0   4   12 10 0   0   0   19       0.0 22 15 0 1   1 1     0   4   12 10 0   0 0 19     0 22
530325 WA Ferry   school 5307260 10309   Republic School District 530726001088 2789 Republic Elementary School   Regular School No 1 PK 06 2016   grade_1 11 0 1   1 0     0   4   11 6 0   0   1   14       0.0 17 11 0 1   1 0     0   4   11 6 0   0 1 14     0 17
530340 WA Ferry   school 5307260 10309   Republic School District 530726002888 1898 Republic Parent Partner   Alternative Education School No 4 KG 12 2016   grade_1 4 0 0   0 0     0   0   4 0 0   0   0   1       0.0 4 4 0 0   0 0     0   0   4 0 0   0 0 1     0 4
627753 WA Ferry   school 5307260 10309   Republic School District 530726001088 2789 Republic Elementary School   Regular School No Elementary KG 06 2017   grade_1 20 0 0   0 0     0   2   15 7 0   0   0   18       0.0 22 20 0 0   0 0     0   2   15 7 0   0 0 18     0 22
627768 WA Ferry   school 5307260 10309   Republic School District 530726002888 1898 Republic Parent Partner   Alternative School No Other KG 12 2017   grade_1 5 0 0   0 0     0   0   3 2 0   0   0   1       0.0 5 5 0 0   0 0     0   0   3 2 0   0 0 1     0 5
2423458 WA Ferry   school 5307260 10309   Republic School District 530726001088 2789 Republic Elementary School   Regular School No Elementary PK 06 2019   grade_1 28 0 1   0 0     0   1   17 13 0   0   0   23       0.0 30 28 0 1   0 0     0   1   17 13 0   0 0 23     0 30
2423473 WA Ferry   school 5307260 10309   Republic School District 530726002888 1898 Republic Parent Partner   Alternative School No Other KG 12 2019   grade_1 5 0 0   0 0     0   0   2 3 0   0   0   0       0.0 5 5 0 0   0 0     0   0   2 3 0   0 0 0     0 5
2467959 WA Ferry   school 5307260 10309   Republic School District 530726001088 2789 Republic Elementary School   Regular School No Elementary KG 06 2018   grade_1 17 0 1   2 0     0   1   10 11 0   0   0   18       0.0 21 17 0 1   2 0     0   1   10 11 0   0 0 18     0 21
2467973 WA Ferry   school 5307260 10309   Republic School District 530726002888 1898 Republic Parent Partner   Alternative School No Other KG 12 2018   grade_1 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
2580850 WA Ferry   school 5307260 10309   Republic School District 530726001088 2789 Republic Elementary School   Regular School No Elementary PK 06 2020   grade_1 18 0 1   0 0     0   1   14 6 0   0   0   13       0.0 20 18 0 1   0 0     0   1   14 6 0   0 0 13     0 20
2580865 WA Ferry   school 5307260 10309   Republic School District 530726002888 1898 Republic Parent Partner   Alternative School No Other KG 12 2020   grade_1 6 0 0   0 0     0   0   3 3 0   0   0   0       0.0 6 6 0 0   0 0     0   0   3 3 0   0 0 0     0 6
2941835 WA Ferry   school 5307260 10309   Republic School District 530726001088 2789 Republic Elementary School   Regular School No Elementary PK 06 2021   grade_1 15 0 2   2 0     0   1   10 10 0   0   0   13       0.0 20 15 0 2   2 0     0   1   10 10 0   0 0 13     0 20
2941850 WA Ferry   school 5307260 10309   Republic School District 530726002888 1898 Republic Parent Partner   Alternative School No Other KG 12 2021   grade_1 0 0 1   0 0     0   0   0 1 0   0   0   0       0.0 1 0 0 1   0 0     0   0   0 1 0   0 0 0     0 1
469274 WA Franklin   school 5306570 11001   Pasco School District 530657000963 3425 Edwin Markham Elementary   Regular School No 1.0 KG 05 2015   grade_1 29 0 16   0 0     0   2   25 22 0   16   3   26       0.0 47 29 0 16   0 0     0   2   25 22 0   16 3 26     0 47
469285 WA Franklin   school 5306570 11001   Pasco School District 530657000964 2967 Emerson Elementary   Regular School No 1.0 KG 05 2015   grade_1 5 1 109   0 1     0   1   51 66 0   81   8   112       2.0 117 5 1 109   0 1     0   1   51 66 0   81 8 112     2 117
469292 WA Franklin   school 5306570 11001   Pasco School District 530657001860 4155 James McGee Elementary   Regular School No 1.0 KG 05 2015   grade_1 66 2 59   0 2     0   8   64 73 0   23   5   71       3.0 137 66 2 59   0 2     0   8   64 73 0   23 5 71     3 137
469301 WA Franklin   school 5306570 11001   Pasco School District 530657000965 2790 Longfellow Elementary   Regular School No 1.0 KG 05 2015   grade_1 4 1 115   0 0     0   1   56 65 0   91   6   119       1.0 121 4 1 115   0 0     0   1   56 65 0   91 6 119     1 121
469307 WA Franklin   school 5306570 11001   Pasco School District 530657000966 3085 Mark Twain Elementary   Regular School No 1.0 KG 05 2015   grade_1 31 1 86   0 1     0   9   71 57 0   48   2   96       0.0 128 31 1 86   0 1     0   9   71 57 0   48 2 96     0 128
469316 WA Franklin   school 5306570 11001   Pasco School District 530657002950 4595 Maya Angelou Elementary   Regular School No 1.0 KG 05 2015   grade_1 65 0 64   0 5     1   4   68 71 0   40   1   68       0.0 139 65 0 64   0 5     1   4   68 71 0   40 1 68     0 139
469343 WA Franklin   school 5306570 11001   Pasco School District 530657000970 3515 Robert Frost Elementary   Regular School No 1.0 KG 05 2015   grade_1 19 1 96   0 0     0   4   57 63 0   89   3   115       0.0 120 19 1 96   0 0     0   4   57 63 0   89 3 115     0 120
469349 WA Franklin   school 5306570 11001   Pasco School District 530657003499 5345 Rosalind Franklin STEM Elementary   Regular School No 1.0 KG 05 2015   grade_1 81 1 55   0 3     0   6   73 73 0   31   1   71       0.0 146 81 1 55   0 3     0   6   73 73 0   31 1 71     0 146
469357 WA Franklin   school 5306570 11001   Pasco School District 530657002785 4555 Rowena Chess Elementary   Regular School No 1.0 KG 05 2015   grade_1 3 0 126   0 0     0   0   56 73 0   93   1   125       1.0 129 3 0 126   0 0     0   0   56 73 0   93 1 125     1 129
469365 WA Franklin   school 5306570 11001   Pasco School District 530657000971 4041 Ruth Livingston Elementary   Regular School No 1.0 KG 05 2015   grade_1 62 6 47   1 2     0   4   64 58 0   16   2   54       0.0 122 62 6 47   1 2     0   4   64 58 0   16 2 54     0 122
469377 WA Franklin   school 5306570 11001   Pasco School District 530657002951 5020 Virgie Robinson Elementary   Regular School No 1.0 KG 05 2015   grade_1 16 1 139   0 0     0   2   84 74 0   134   8   155       1.0 158 16 1 139   0 0     0   2   84 74 0   134 8 155     1 158
469385 WA Franklin   school 5306570 11001   Pasco School District 530657002621 4526 Whittier Elementary   Regular School No 1.0 KG 05 2015   grade_1 4 0 113   0 0     0   1   59 59 0   83   2   113       0.0 118 4 0 113   0 0     0   1   59 59 0   83 2 113     0 118
529154 WA Franklin   school 5306570 11001   Pasco School District 530657003520 5391 Barbara McClintock STEM Elementary   Regular School No 1 PK 06 2016   grade_1 41 0 46   0 0     0   5   50 42 0   14   2   48       1.0 92 41 0 46   0 0     0   5   50 42 0   14 2 48     1 92
529164 WA Franklin   school 5306570 11001   Pasco School District 530657003552 5392 Captain Gray STEM Elementary   Regular School No 1 PK 06 2016   grade_1 3 0 94   0 0     0   1   47 51 0   73   1   95       0.0 98 3 0 94   0 0     0   1   47 51 0   73 1 95     0 98
529181 WA Franklin   school 5306570 11001   Pasco School District 530657000963 3425 Edwin Markham Elementary   Regular School No 1 PK 06 2016   grade_1 37 0 14   1 0     0   1   34 19 0   13   0   29       0.0 53 37 0 14   1 0     0   1   34 19 0   13 0 29     0 53
529194 WA Franklin   school 5306570 11001   Pasco School District 530657000964 2967 Emerson Elementary   Regular School No 1 PK 06 2016   grade_1 8 0 100   0 0     0   1   62 47 0   70   1   105       0.0 109 8 0 100   0 0     0   1   62 47 0   70 1 105     0 109
529205 WA Franklin   school 5306570 11001   Pasco School District 530657001860 4155 James McGee Elementary   Regular School No 1 PK 06 2016   grade_1 34 1 54   0 1     1   5   52 44 0   22   0   59       1.0 96 34 1 54   0 1     1   5   52 44 0   22 0 59     1 96
529215 WA Franklin   school 5306570 11001   Pasco School District 530657000965 2790 Longfellow Elementary   Regular School No 1 PK 06 2016   grade_1 5 0 56   0 0     0   1   36 26 0   52   1   62       0.0 62 5 0 56   0 0     0   1   36 26 0   52 1 62     0 62
529229 WA Franklin   school 5306570 11001   Pasco School District 530657000966 3085 Mark Twain Elementary   Regular School No 1 PK 06 2016   grade_1 32 0 72   0 0     0   3   61 46 0   42   1   82       0.0 107 32 0 72   0 0     0   3   61 46 0   42 1 82     0 107
529238 WA Franklin   school 5306570 11001   Pasco School District 530657002950 4595 Maya Angelou Elementary   Regular School No 1 PK 06 2016   grade_1 48 2 60   0 7     1   5   65 58 0   38   1   56       0.0 123 48 2 60   0 7     1   5   65 58 0   38 1 56     0 123
529263 WA Franklin   school 5306570 11001   Pasco School District 530657000970 3515 Robert Frost Elementary   Regular School No 1 PK 06 2016   grade_1 19 1 54   0 0     0   1   41 34 0   65   1   71       1.0 75 19 1 54   0 0     0   1   41 34 0   65 1 71     1 75
529272 WA Franklin   school 5306570 11001   Pasco School District 530657003499 5345 Rosalind Franklin STEM Elementary   Regular School No 1 PK 06 2016   grade_1 41 0 71   0 2     0   5   71 48 0   46   1   73       0.0 119 41 0 71   0 2     0   5   71 48 0   46 1 73     0 119
529282 WA Franklin   school 5306570 11001   Pasco School District 530657002785 4555 Rowena Chess Elementary   Regular School No 1 PK 06 2016   grade_1 3 0 84   0 0     0   2   52 37 0   59   0   88       0.0 89 3 0 84   0 0     0   2   52 37 0   59 0 88     0 89
529292 WA Franklin   school 5306570 11001   Pasco School District 530657000971 4041 Ruth Livingston Elementary   Regular School No 1 PK 06 2016   grade_1 59 0 31   0 3     1   3   49 48 0   16   0   41       0.0 97 59 0 31   0 3     1   3   49 48 0   16 0 41     0 97
529304 WA Franklin   school 5306570 11001   Pasco School District 530657002951 5020 Virgie Robinson Elementary   Regular School No 1 KG 06 2016   grade_1 1 0 128   0 0     0   0   56 73 0   110   3   127       0.0 129 1 0 128   0 0     0   0   56 73 0   110 3 127     0 129
529312 WA Franklin   school 5306570 11001   Pasco School District 530657002621 4526 Whittier Elementary   Regular School No 1 KG 03 2016   grade_1 6 0 199   0 1     0   0   93 113 0   158   2   200       1.0 206 6 0 199   0 1     0   0   93 113 0   158 2 200     1 206
626587 WA Franklin   school 5306570 11001   Pasco School District 530657003520 5391 Barbara McClintock STEM Elementary   Regular School No Elementary PK 06 2017   grade_1 56 2 76   0 1     0   4   70 69 0   36   1   69       0.0 139 56 2 76   0 1     0   4   70 69 0   36 1 69     0 139
626597 WA Franklin   school 5306570 11001   Pasco School District 530657003552 5392 Captain Gray STEM Elementary   Regular School No Elementary PK 06 2017   grade_1 2 0 74   0 0     0   2   31 47 0   61   2   76       0.0 78 2 0 74   0 0     0   2   31 47 0   61 2 76     0 78
626613 WA Franklin   school 5306570 11001   Pasco School District 530657000963 3425 Edwin Markham Elementary   Regular School No Elementary KG 06 2017   grade_1 43 0 15   0 0     0   1   35 24 0   13   0   26       0.0 59 43 0 15   0 0     0   1   35 24 0   13 0 26     0 59
626625 WA Franklin   school 5306570 11001   Pasco School District 530657000964 2967 Emerson Elementary   Regular School No Elementary KG 06 2017   grade_1 6 2 87   0 0     0   0   51 44 0   65   10   94       1.0 95 6 2 87   0 0     0   0   51 44 0   65 10 94     1 95
626637 WA Franklin   school 5306570 11001   Pasco School District 530657001860 4155 James McGee Elementary   Regular School No Elementary KG 06 2017   grade_1 44 2 41   0 2     0   5   50 44 0   18   0   56       0.0 94 44 2 41   0 2     0   5   50 44 0   18 0 56     0 94
626647 WA Franklin   school 5306570 11001   Pasco School District 530657000965 2790 Longfellow Elementary   Regular School No Elementary PK 06 2017   grade_1 1 0 53   0 0     0   0   30 24 0   39   0   51       1.0 54 1 0 53   0 0     0   0   30 24 0   39 0 51     1 54
626662 WA Franklin   school 5306570 11001   Pasco School District 530657000966 3085 Mark Twain Elementary   Regular School No Elementary PK 06 2017   grade_1 40 1 63   0 1     0   3   46 62 0   44   1   71       1.0 108 40 1 63   0 1     0   3   46 62 0   44 1 71     1 108
626672 WA Franklin   school 5306570 11001   Pasco School District 530657002950 4595 Maya Angelou Elementary   Regular School No Elementary PK 06 2017   grade_1 51 2 58   0 0     1   8   61 59 0   35   4   56       2.0 120 51 2 58   0 0     1   8   61 59 0   35 4 56     2 120
626697 WA Franklin   school 5306570 11001   Pasco School District 530657000970 3515 Robert Frost Elementary   Regular School No Elementary PK 06 2017   grade_1 26 0 49   0 0     1   1   41 36 0   59   1   69       0.0 77 26 0 49   0 0     1   1   41 36 0   59 1 69     0 77
626706 WA Franklin   school 5306570 11001   Pasco School District 530657003499 5345 Rosalind Franklin STEM Elementary   Regular School No Elementary PK 06 2017   grade_1 38 0 51   0 1     0   5   47 48 0   16   0   42       1.0 95 38 0 51   0 1     0   5   47 48 0   16 0 42     1 95
626715 WA Franklin   school 5306570 11001   Pasco School District 530657002785 4555 Rowena Chess Elementary   Regular School No Elementary PK 06 2017   grade_1 4 0 81   0 0     0   1   50 36 0   55   1   81       0.0 86 4 0 81   0 0     0   1   50 36 0   55 1 81     0 86
626724 WA Franklin   school 5306570 11001   Pasco School District 530657000971 4041 Ruth Livingston Elementary   Regular School No Elementary PK 06 2017   grade_1 57 3 26   0 2     0   6   40 54 0   10   0   44       0.0 94 57 3 26   0 2     0   6   40 54 0   10 0 44     0 94
626736 WA Franklin   school 5306570 11001   Pasco School District 530657002951 5020 Virgie Robinson Elementary   Regular School No Elementary KG 06 2017   grade_1 2 2 96   0 1     0   0   57 44 0   76   0   95       0.0 101 2 2 96   0 1     0   0   57 44 0   76 0 95     0 101
626745 WA Franklin   school 5306570 11001   Pasco School District 530657002621 4526 Whittier Elementary   Regular School No Elementary KG 02 2017   grade_1 9 1 177   0 2     0   0   90 99 0   136   0   182       1.0 189 9 1 177   0 2     0   0   90 99 0   136 0 182     1 189
2422319 WA Franklin   school 5306570 11001   Pasco School District 530657003520 5391 Barbara McClintock STEM Elementary   Regular School No Elementary PK 06 2019   grade_1 46 0 84   0 3     1   6   70 70 0   38   2   62       1.0 140 46 0 84   0 3     1   6   70 70 0   38 2 62     1 140
2422328 WA Franklin   school 5306570 11001   Pasco School District 530657003552 5392 Captain Gray STEM Elementary   Regular School No Elementary PK 06 2019   grade_1 5 0 70   0 0     0   0   41 34 0   52   3   63       1.0 75 5 0 70   0 0     0   0   41 34 0   52 3 63     1 75
2422343 WA Franklin   school 5306570 11001   Pasco School District 530657000963 3425 Edwin Markham Elementary   Regular School No Elementary KG 06 2019   grade_1 36 0 20   0 0     0   0   27 29 0   13   2   24       0.0 56 36 0 20   0 0     0   0   27 29 0   13 2 24     0 56
2422355 WA Franklin   school 5306570 11001   Pasco School District 530657000964 2967 Emerson Elementary   Regular School No Elementary KG 06 2019   grade_1 4 0 85   0 0     0   1   34 56 0   61   3   83       0.0 90 4 0 85   0 0     0   1   34 56 0   61 3 83     0 90
2422364 WA Franklin   school 5306570 11001   Pasco School District 530657003547 5393 Internet Pasco Academy of Learning   Alternative School No Elementary KG 08 2019   grade_1 1 0 0   0 0     0   0   1 0 0   0   0   0       0.0 1 1 0 0   0 0     0   0   1 0 0   0 0 0     0 1
2422370 WA Franklin   school 5306570 11001   Pasco School District 530657001860 4155 James McGee Elementary   Regular School No Elementary KG 06 2019   grade_1 29 2 41   0 2     1   5   49 31 0   14   0   41       1.0 80 29 2 41   0 2     1   5   49 31 0   14 0 41     1 80
2422379 WA Franklin   school 5306570 11001   Pasco School District 530657000965 2790 Longfellow Elementary   Regular School No Elementary PK 06 2019   grade_1 4 0 48   0 1     0   0   21 32 0   36   0   53       0.0 53 4 0 48   0 1     0   0   21 32 0   36 0 53     0 53
2422392 WA Franklin   school 5306570 11001   Pasco School District 530657000966 3085 Mark Twain Elementary   Regular School No Elementary PK 06 2019   grade_1 24 2 86   0 2     0   2   56 60 0   35   2   86       0.0 116 24 2 86   0 2     0   2   56 60 0   35 2 86     0 116
2422401 WA Franklin   school 5306570 11001   Pasco School District 530657002950 4595 Maya Angelou Elementary   Regular School No Elementary PK 06 2019   grade_1 50 1 72   0 2     0   3   74 54 0   31   3   67       1.0 128 50 1 72   0 2     0   3   74 54 0   31 3 67     1 128
2422416 WA Franklin   school 5306570 11001   Pasco School District 530657003143 1970 Pasco Early Childhood   Regular School No Prekindergarten PK PK 2019   grade_1 1 0 0   0 0     0   0   1 0 0   0   0   0       0.0 1 1 0 0   0 0     0   0   1 0 0   0 0 0     0 1
2422427 WA Franklin   school 5306570 11001   Pasco School District 530657000970 3515 Robert Frost Elementary   Regular School No Elementary PK 06 2019   grade_1 21 1 56   0 0     0   1   42 37 0   63   1   69       1.0 79 21 1 56   0 0     0   1   42 37 0   63 1 69     1 79
2422435 WA Franklin   school 5306570 11001   Pasco School District 530657003499 5345 Rosalind Franklin STEM Elementary   Regular School No Elementary PK 06 2019   grade_1 57 4 43   0 1     1   2   62 46 0   25   1   53       1.0 108 57 4 43   0 1     1   2   62 46 0   25 1 53     1 108
2422444 WA Franklin   school 5306570 11001   Pasco School District 530657002785 4555 Rowena Chess Elementary   Regular School No Elementary PK 06 2019   grade_1 4 0 51   0 0     0   1   26 30 0   33   4   53       1.0 56 4 0 51   0 0     0   1   26 30 0   33 4 53     1 56
2422453 WA Franklin   school 5306570 11001   Pasco School District 530657000971 4041 Ruth Livingston Elementary   Regular School No Elementary PK 06 2019   grade_1 45 0 49   0 2     0   4   45 55 0   11   0   44       1.0 100 45 0 49   0 2     0   4   45 55 0   11 0 44     1 100
2422465 WA Franklin   school 5306570 11001   Pasco School District 530657002951 5020 Virgie Robinson Elementary   Regular School No Elementary KG 06 2019   grade_1 2 0 111   0 0     0   1   61 53 0   88   2   105       0.0 114 2 0 111   0 0     0   1   61 53 0   88 2 105     0 114

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