Data source: Big Local News · About: Big Local

8,808 rows where grade = "grade_2" and state = "WA" sorted by county

View and edit SQL

year

grade

  • grade_2 · 8,808
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
460662 WA Adams   school 5300450 1122   Benge School District 530045000118 3142 Benge Elementary   Regular School No 1.0 KG 06 2015   grade_2 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
466415 WA Adams   school 5304410 1158   Lind School District 530441000695 3421 Lind Elementary School   Regular School No 1.0 PK 06 2015   grade_2 12 0 5   0 1     0   0   10 8 0   5   2   13       0.0 18 12 0 5   0 1     0   0   10 8 0   5 2 13     0 18
469198 WA Adams   school 5306480 1147   Othello School District 530648000954 2961 Hiawatha Elementary School   Regular School No 1.0 KG 06 2015   grade_2 9 0 81   0 0     0   1   50 41 0   54   3   82       0.0 91 9 0 81   0 0     0   1   50 41 0   54 3 82     0 91
469205 WA Adams   school 5306480 1147   Othello School District 530648000955 2902 Lutacaga Elementary   Regular School No 1.0 KG 06 2015   grade_2 3 0 92   0 0     0   0   51 44 0   58   3   87       1.0 95 3 0 92   0 0     0   0   51 44 0   58 3 87     1 95
469218 WA Adams   school 5306480 1147   Othello School District 530648000957 3015 Othello High School   Regular School No 3.0 08 12 2015   grade_2 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
469224 WA Adams   school 5306480 1147   Othello School District 530648000958 3730 Scootney Springs Elementary   Regular School No 1.0 PK 06 2015   grade_2 9 0 85   0 0     0   1   53 42 0   57   2   79       0.0 95 9 0 85   0 0     0   1   53 42 0   57 2 79     0 95
469232 WA Adams   school 5306480 1147   Othello School District 530648003393 5285 Wahitis Elementary School   Regular School No 1.0 KG 05 2015   grade_2 10 0 62   0 0     0   0   24 48 0   40   3   59       0.0 72 10 0 62   0 0     0   0   24 48 0   40 3 59     0 72
470574 WA Adams   school 5307380 1160   Ritzville School District 530738001109 2719 Ritzville Grade School   Regular School No 1.0 KG 08 2015   grade_2 28 1 2   0 0     0   0   18 13 0   0   2   12       1.0 31 28 1 2   0 0     0   0   18 13 0   0 2 12     1 31
474721 WA Adams   school 5309570 1109   Washtucna School District 530957001625 3075 Washtucna Elementary/High School   Regular School No 4.0 KG 12 2015   grade_2 2 0 0   0 0     0   0   0 2 0   0   0   1       0.0 2 2 0 0   0 0     0   0   0 2 0   0 0 1     0 2
520646 WA Adams   school 5300450 1122   Benge School District 530045000118 3142 Benge Elementary   Regular School No 1 KG 06 2016   grade_2 3 0 0   0 0     0   0   2 1 0   0   0   0       0.0 3 3 0 0   0 0     0   0   2 1 0   0 0 0     0 3
526381 WA Adams   school 5304410 1158   Lind School District 530441000695 3421 Lind Elementary School   Regular School No 1 PK 05 2016   grade_2 11 0 6   0 0     0   0   11 6 0   3   2   12       0.0 17 11 0 6   0 0     0   0   11 6 0   3 2 12     0 17
529089 WA Adams   school 5306480 1147   Othello School District 530648000954 2961 Hiawatha Elementary School   Regular School No 1 KG 05 2016   grade_2 13 0 80   0 0     0   0   45 48 0   51   3   83       0.0 93 13 0 80   0 0     0   0   45 48 0   51 3 83     0 93
529097 WA Adams   school 5306480 1147   Othello School District 530648000955 2902 Lutacaga Elementary   Regular School No 1 KG 05 2016   grade_2 9 1 88   0 1     0   1   47 53 0   60   0   83       1.0 100 9 1 88   0 1     0   1   47 53 0   60 0 83     1 100
529114 WA Adams   school 5306480 1147   Othello School District 530648000958 3730 Scootney Springs Elementary   Regular School No 1 PK 05 2016   grade_2 15 0 90   0 0     0   0   60 45 0   65   3   94       1.0 105 15 0 90   0 0     0   0   60 45 0   65 3 94     1 105
529122 WA Adams   school 5306480 1147   Othello School District 530648003393 5285 Wahitis Elementary School   Regular School No 1 KG 05 2016   grade_2 10 0 86   0 0     0   0   53 43 0   57   1   84       1.0 96 10 0 86   0 0     0   0   53 43 0   57 1 84     1 96
530523 WA Adams   school 5307380 1160   Ritzville School District 530738001109 2719 Ritzville Grade School   Regular School No 1 PK 05 2016   grade_2 24 0 3   0 1     0   0   16 12 0   0   1   13       0.0 28 24 0 3   0 1     0   0   16 12 0   0 1 13     0 28
534676 WA Adams   school 5309570 1109   Washtucna School District 530957001625 3075 Washtucna Elementary/High School   Regular School No 4 PK 12 2016   grade_2 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
618011 WA Adams   school 5300450 1122   Benge School District 530045000118 3142 Benge Elementary   Regular School No Elementary KG 06 2017   grade_2 2 0 0   0 0     0   0   0 2 0   0   0   0       0.0 2 2 0 0   0 0     0   0   0 2 0   0 0 0     0 2
623749 WA Adams   school 5304410 1158   Lind School District 530441000695 3421 Lind Elementary School   Regular School No Elementary PK 05 2017   grade_2 10 0 4   0 0     0   0   8 6 0   3   3   13       0.0 14 10 0 4   0 0     0   0   8 6 0   3 3 13     0 14
626519 WA Adams   school 5306480 1147   Othello School District 530648000954 2961 Hiawatha Elementary School   Regular School No Elementary KG 05 2017   grade_2 10 0 75   0 0     0   0   43 42 0   57   0   75       1.0 85 10 0 75   0 0     0   0   43 42 0   57 0 75     1 85
626528 WA Adams   school 5306480 1147   Othello School District 530648000955 2902 Lutacaga Elementary   Regular School No Elementary KG 05 2017   grade_2 7 0 86   0 0     0   0   46 47 0   66   0   75       1.0 93 7 0 86   0 0     0   0   46 47 0   66 0 75     1 93
626546 WA Adams   school 5306480 1147   Othello School District 530648000958 3730 Scootney Springs Elementary   Regular School No Elementary KG 05 2017   grade_2 10 0 74   0 0     0   1   47 38 0   54   0   74       0.0 85 10 0 74   0 0     0   1   47 38 0   54 0 74     0 85
626555 WA Adams   school 5306480 1147   Othello School District 530648003393 5285 Wahitis Elementary School   Regular School No Elementary KG 05 2017   grade_2 7 0 84   0 0     0   0   53 38 0   59   2   86       0.0 91 7 0 84   0 0     0   0   53 38 0   59 2 86     0 91
627954 WA Adams   school 5307380 1160   Ritzville School District 530738001109 2719 Ritzville Grade School   Regular School No Elementary KG 05 2017   grade_2 22 1 1   0 0     0   1   17 8 0   0   0   17       0.0 25 22 1 1   0 0     0   1   17 8 0   0 0 17     0 25
632011 WA Adams   school 5309570 1109   Washtucna School District 530957001625 3075 Washtucna Elementary/High School   Regular School No Other KG 12 2017   grade_2 3 0 0   0 0     0   0   1 2 0   0   0   3       0.0 3 3 0 0   0 0     0   0   1 2 0   0 0 3     0 3
2413963 WA Adams   school 5300450 1122   Benge School District 530045000118 3142 Benge Elementary   Regular School No Elementary KG 06 2019   grade_2 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
2419637 WA Adams   school 5304410 1158   Lind School District 530441000695 3421 Lind Elementary School   Regular School No Elementary PK 05 2019   grade_2 9 0 5   0 0     0   1   9 6 0   4   1   10       0.0 15 9 0 5   0 0     0   1   9 6 0   4 1 10     0 15
2422250 WA Adams   school 5306480 1147   Othello School District 530648000954 2961 Hiawatha Elementary School   Regular School No Elementary KG 06 2019   grade_2 13 0 76   0 0     0   1   39 51 0   54   3   79       1.0 90 13 0 76   0 0     0   1   39 51 0   54 3 79     1 90
2422259 WA Adams   school 5306480 1147   Othello School District 530648000955 2902 Lutacaga Elementary   Regular School No Elementary KG 06 2019   grade_2 6 0 85   0 1     0   1   51 42 0   58   1   83       0.0 93 6 0 85   0 1     0   1   51 42 0   58 1 83     0 93
2422277 WA Adams   school 5306480 1147   Othello School District 530648000958 3730 Scootney Springs Elementary   Regular School No Elementary KG 06 2019   grade_2 8 0 84   0 0     0   0   53 39 0   51   3   74       2.0 92 8 0 84   0 0     0   0   53 39 0   51 3 74     2 92
2422286 WA Adams   school 5306480 1147   Othello School District 530648003393 5285 Wahitis Elementary School   Regular School No Elementary KG 06 2019   grade_2 7 0 76   0 0     0   0   44 40 0   48   2   72       0.0 84 7 0 76   0 0     0   0   44 40 0   48 2 72     0 84
2423658 WA Adams   school 5307380 1160   Ritzville School District 530738001109 2719 Ritzville Grade School   Regular School No Elementary PK 05 2019   grade_2 21 0 8   0 1     0   0   15 15 0   0   1   16       0.0 30 21 0 8   0 1     0   0   15 15 0   0 1 16     0 30
2427700 WA Adams   school 5309570 1109   Washtucna School District 530957001625 3075 Washtucna Elementary/High School   Regular School No Other PK 12 2019   grade_2 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
2458511 WA Adams   school 5300450 1122   Benge School District 530045000118 3142 Benge Elementary   Regular School No Elementary KG 06 2018   grade_2 2 0 0   0 0     0   0   1 1 0   0   0   0       0.0 2 2 0 0   0 0     0   0   1 1 0   0 0 0     0 2
2464088 WA Adams   school 5304410 1158   Lind School District 530441000695 3421 Lind Elementary School   Regular School No Elementary PK 05 2018   grade_2 11 0 5   0 0     0   2   9 9 0   1   1   9       0.0 18 11 0 5   0 0     0   2   9 9 0   1 1 9     0 18
2466727 WA Adams   school 5306480 1147   Othello School District 530648000954 2961 Hiawatha Elementary School   Regular School No Elementary KG 05 2018   grade_2 9 0 88   0 1     0   0   49 51 0   74   3   94       1.0 100 9 0 88   0 1     0   0   49 51 0   74 3 94     1 100
2466735 WA Adams   school 5306480 1147   Othello School District 530648000955 2902 Lutacaga Elementary   Regular School No Elementary KG 05 2018   grade_2 2 0 91   0 0     0   0   48 46 0   64   0   80       1.0 94 2 0 91   0 0     0   0   48 46 0   64 0 80     1 94
2466754 WA Adams   school 5306480 1147   Othello School District 530648000958 3730 Scootney Springs Elementary   Regular School No Elementary KG 05 2018   grade_2 12 1 82   0 1     0   1   49 48 0   45   2   82       2.0 97 12 1 82   0 1     0   1   49 48 0   45 2 82     2 97
2466762 WA Adams   school 5306480 1147   Othello School District 530648003393 5285 Wahitis Elementary School   Regular School No Elementary KG 05 2018   grade_2 5 0 80   0 0     0   1   44 45 0   55   1   75       1.0 89 5 0 80   0 0     0   1   44 45 0   55 1 75     1 89
2468165 WA Adams   school 5307380 1160   Ritzville School District 530738001109 2719 Ritzville Grade School   Regular School No Elementary KG 05 2018   grade_2 16 0 3   0 0     0   0   16 3 0   0   0   10       0.0 19 16 0 3   0 0     0   0   16 3 0   0 0 10     0 19
2472215 WA Adams   school 5309570 1109   Washtucna School District 530957001625 3075 Washtucna Elementary/High School   Regular School No Other PK 12 2018   grade_2 1 0 1   0 0     0   0   2 0 0   0   0   2       0.0 2 1 0 1   0 0     0   0   2 0 0   0 0 2     0 2
2571286 WA Adams   school 5300450 1122   Benge School District 530045000118 3142 Benge Elementary   Regular School No Elementary KG 06 2020   grade_2 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
2576984 WA Adams   school 5304410 1158   Lind School District 530441000695 3421 Lind Elementary School   Regular School No Elementary PK 05 2020   grade_2 10 0 6   0 0     0   0   8 8 0   4   1   10       0.0 16 10 0 6   0 0     0   0   8 8 0   4 1 10     0 16
2579596 WA Adams   school 5306480 1147   Othello School District 530648000954 2961 Hiawatha Elementary School   Regular School No Elementary KG 06 2020   grade_2 9 0 78   0 0     0   0   42 45 0   53   0   77       1.0 87 9 0 78   0 0     0   0   42 45 0   53 0 77     1 87
2579604 WA Adams   school 5306480 1147   Othello School District 530648000955 2902 Lutacaga Elementary   Regular School No Elementary KG 06 2020   grade_2 1 0 90   0 0     0   0   49 42 0   65   0   88       0.0 91 1 0 90   0 0     0   0   49 42 0   65 0 88     0 91
2579621 WA Adams   school 5306480 1147   Othello School District 530648000958 3730 Scootney Springs Elementary   Regular School No Elementary KG 06 2020   grade_2 9 1 66   0 0     0   0   35 41 0   43   1   62       1.0 76 9 1 66   0 0     0   0   35 41 0   43 1 62     1 76
2579629 WA Adams   school 5306480 1147   Othello School District 530648003393 5285 Wahitis Elementary School   Regular School No Elementary KG 06 2020   grade_2 14 0 65   0 0     0   0   41 38 0   42   0   65       1.0 79 14 0 65   0 0     0   0   41 38 0   42 0 65     1 79
2581039 WA Adams   school 5307380 1160   Ritzville School District 530738001109 2719 Ritzville Grade School   Regular School No Elementary PK 05 2020   grade_2 23 0 3   1 0     0   1   16 12 0   0   0   19       0.0 28 23 0 3   1 0     0   1   16 12 0   0 0 19     0 28
2585129 WA Adams   school 5309570 1109   Washtucna School District 530957001625 3075 Washtucna Elementary/High School   Regular School No Other PK 12 2020   grade_2 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
2932170 WA Adams   school 5300450 1122   Benge School District 530045000118 3142 Benge Elementary   Regular School No Elementary KG 06 2021   grade_2 5 0 0   0 0     0   0   1 4 0   0   0   1       0.0 5 5 0 0   0 0     0   0   1 4 0   0 0 1     0 5
2937856 WA Adams   school 5304410 1158   Lind School District 530441000695 3421 Lind Elementary School   Regular School No Elementary PK 05 2021   grade_2 13 0 3   0 0     0   0   10 6 0   0   0   10       0.0 16 13 0 3   0 0     0   0   10 6 0   0 0 10     0 16
2940559 WA Adams   school 5306480 1147   Othello School District 530648000954 2961 Hiawatha Elementary School   Regular School No Elementary KG 06 2021   grade_2 7 0 73   1 2     0   1   52 32 0   58   0   71       2.0 84 7 0 73   1 2     0   1   52 32 0   58 0 71     2 84
2940567 WA Adams   school 5306480 1147   Othello School District 530648000955 2902 Lutacaga Elementary   Regular School No Elementary KG 06 2021   grade_2 2 0 85   0 0     1   1   46 43 0   62   0   78       2.0 89 2 0 85   0 0     1   1   46 43 0   62 0 78     2 89
2940584 WA Adams   school 5306480 1147   Othello School District 530648000958 3730 Scootney Springs Elementary   Regular School No Elementary KG 06 2021   grade_2 10 0 77   0 1     0   0   51 37 0   46   0   73       1.0 88 10 0 77   0 1     0   0   51 37 0   46 0 73     1 88
2940592 WA Adams   school 5306480 1147   Othello School District 530648003393 5285 Wahitis Elementary School   Regular School No Elementary KG 06 2021   grade_2 2 0 83   0 0     0   0   39 46 0   46   0   67       1.0 85 2 0 83   0 0     0   0   39 46 0   46 0 67     1 85
2942030 WA Adams   school 5307380 1160   Ritzville School District 530738001109 2719 Ritzville Grade School   Regular School No Elementary PK 05 2021   grade_2 16 0 2   2 1     0   1   12 10 0   0   1   11       0.0 22 16 0 2   2 1     0   1   12 10 0   0 1 11     0 22
2946173 WA Adams   school 5309570 1109   Washtucna School District 530957001625 3075 Washtucna Elementary/High School   Regular School No Other PK 12 2021   grade_2 2 0 0   0 0     0   0   2 0 0   0   0   1       0.0 2 2 0 0   0 0     0   0   2 0 0   0 0 1     0 2
459919 WA Asotin   school 5300280 2420   Asotin-Anatone School District 530028000027 2507 Asotin Elementary   Regular School No 1.0 PK 06 2015   grade_2 34 0 4   1 0     0   3   21 21 0   0   0   21       0.0 42 34 0 4   1 0     0   3   21 21 0   0 0 21     0 42
461869 WA Asotin   school 5301320 2250   Clarkston School District 530132000235 2962 Grantham Elementary   Regular School No 1.0 KG 06 2015   grade_2 36 0 3   0 0     0   3   25 17 0   1   6   36       0.0 42 36 0 3   0 0     0   3   25 17 0   1 6 36     0 42
461877 WA Asotin   school 5301320 2250   Clarkston School District 530132002433 4384 Heights Elementary   Regular School No 1.0 KG 06 2015   grade_2 47 0 3   0 1     0   1   22 30 0   0   3   17       1.0 52 47 0 3   0 1     0   1   22 30 0   0 3 17     1 52
461885 WA Asotin   school 5301320 2250   Clarkston School District 530132000236 3266 Highland Elementary   Regular School No 1.0 KG 06 2015   grade_2 33 1 5   1 1     0   3   17 27 0   4   2   38       1.0 44 33 1 5   1 1     0   3   17 27 0   4 2 38     1 44
461896 WA Asotin   school 5301320 2250   Clarkston School District 530132000238 2823 Parkway Elementary   Regular School No 1.0 KG 06 2015   grade_2 46 1 2   0 0     0   1   26 24 0   0   2   40       2.0 50 46 1 2   0 0     0   1   26 24 0   0 2 40     2 50
461906 WA Asotin   school 5301320 2250   Clarkston School District 530132002613 3616 Special Services   Special Education School No 4.0 PK 12 2015   grade_2 1 0 0   0 0     0   0   0 1 0   0   0   0       0.0 1 1 0 0   0 0     0   0   0 1 0   0 0 0     0 1
519891 WA Asotin   school 5300280 2420   Asotin-Anatone School District 530028000027 2507 Asotin Elementary   Regular School No 1 PK 05 2016   grade_2 47 0 2   0 0     0   1   24 26 0   0   0   12       1.0 50 47 0 2   0 0     0   1   24 26 0   0 0 12     1 50
521853 WA Asotin   school 5301320 2250   Clarkston School District 530132000235 2962 Grantham Elementary   Regular School No 1 KG 06 2016   grade_2 33 0 6   0 0     0   8   29 18 0   1   6   42       0.0 47 33 0 6   0 0     0   8   29 18 0   1 6 42     0 47
521862 WA Asotin   school 5301320 2250   Clarkston School District 530132002433 4384 Heights Elementary   Regular School No 1 KG 06 2016   grade_2 47 1 2   0 0     0   2   22 30 0   0   0   21       1.0 52 47 1 2   0 0     0   2   22 30 0   0 0 21     1 52
521871 WA Asotin   school 5301320 2250   Clarkston School District 530132000236 3266 Highland Elementary   Regular School No 1 KG 06 2016   grade_2 40 0 6   0 2     0   0   23 25 0   3   3   38       2.0 48 40 0 6   0 2     0   0   23 25 0   3 3 38     2 48
521884 WA Asotin   school 5301320 2250   Clarkston School District 530132000238 2823 Parkway Elementary   Regular School No 1 KG 06 2016   grade_2 36 2 6   1 2     0   0   19 28 0   1   6   32       1.0 47 36 2 6   1 2     0   0   19 28 0   1 6 32     1 47
617259 WA Asotin   school 5300280 2420   Asotin-Anatone School District 530028000027 2507 Asotin Elementary   Regular School No Elementary PK 05 2017   grade_2 38 0 1   0 1     0   1   22 19 0   0   1   13       0.0 41 38 0 1   0 1     0   1   22 19 0   0 1 13     0 41
619208 WA Asotin   school 5301320 2250   Clarkston School District 530132000235 2962 Grantham Elementary   Regular School No Elementary KG 06 2017   grade_2 37 0 1   0 0     0   1   18 21 0   0   5   32       1.0 39 37 0 1   0 0     0   1   18 21 0   0 5 32     1 39
619218 WA Asotin   school 5301320 2250   Clarkston School District 530132002433 4384 Heights Elementary   Regular School No Elementary KG 06 2017   grade_2 39 0 5   0 1     0   3   32 16 0   0   3   22       2.0 48 39 0 5   0 1     0   3   32 16 0   0 3 22     2 48
619226 WA Asotin   school 5301320 2250   Clarkston School District 530132000236 3266 Highland Elementary   Regular School No Elementary KG 06 2017   grade_2 38 1 3   0 0     0   4   24 22 0   1   5   36       1.0 46 38 1 3   0 0     0   4   24 22 0   1 5 36     1 46
619238 WA Asotin   school 5301320 2250   Clarkston School District 530132000238 2823 Parkway Elementary   Regular School No Elementary KG 06 2017   grade_2 37 1 4   2 0     0   0   24 20 0   0   1   31       2.0 44 37 1 4   2 0     0   0   24 20 0   0 1 31     2 44
619247 WA Asotin   school 5301320 2250   Clarkston School District 530132002613 3616 Special Services   Special Education School No Other PK 12 2017   grade_2 1 0 0   0 1     0   0   2 0 0   0   0   1       0.0 2 1 0 0   0 1     0   0   2 0 0   0 0 1     0 2
2413202 WA Asotin   school 5300280 2420   Asotin-Anatone School District 530028000027 2507 Asotin Elementary   Regular School No Elementary PK 05 2019   grade_2 44 0 4   0 0     0   1   29 20 0   0   0   18       1.0 49 44 0 4   0 0     0   1   29 20 0   0 0 18     1 49
2415168 WA Asotin   school 5301320 2250   Clarkston School District 530132000235 2962 Grantham Elementary   Regular School No Elementary KG 06 2019   grade_2 37 2 6   0 0     0   5   30 20 0   0   1   38       2.0 50 37 2 6   0 0     0   5   30 20 0   0 1 38     2 50
2415176 WA Asotin   school 5301320 2250   Clarkston School District 530132002433 4384 Heights Elementary   Regular School No Elementary KG 06 2019   grade_2 44 1 0   1 0     0   2   19 29 0   0   1   14       2.0 48 44 1 0   1 0     0   2   19 29 0   0 1 14     2 48
2415185 WA Asotin   school 5301320 2250   Clarkston School District 530132000236 3266 Highland Elementary   Regular School No Elementary KG 06 2019   grade_2 32 0 5   1 1     0   2   19 22 0   4   3   33       0.0 41 32 0 5   1 1     0   2   19 22 0   4 3 33     0 41
2415197 WA Asotin   school 5301320 2250   Clarkston School District 530132000238 2823 Parkway Elementary   Regular School No Elementary KG 06 2019   grade_2 37 0 2   1 0     0   5   19 26 0   0   2   28       0.0 45 37 0 2   1 0     0   5   19 26 0   0 2 28     0 45
2415208 WA Asotin   school 5301320 2250   Clarkston School District 530132002613 3616 Special Services   Special Education School No Other PK 12 2019   grade_2 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
2457762 WA Asotin   school 5300280 2420   Asotin-Anatone School District 530028000027 2507 Asotin Elementary   Regular School No Elementary PK 05 2018   grade_2 31 0 2   0 1     0   2   15 21 0   0   0   14       0.0 36 31 0 2   0 1     0   2   15 21 0   0 0 14     0 36
2459687 WA Asotin   school 5301320 2250   Clarkston School District 530132000235 2962 Grantham Elementary   Regular School No Elementary KG 06 2018   grade_2 30 0 2   0 0     0   0   17 15 0   0   1   27       2.0 32 30 0 2   0 0     0   0   17 15 0   0 1 27     2 32
2459695 WA Asotin   school 5301320 2250   Clarkston School District 530132002433 4384 Heights Elementary   Regular School No Elementary KG 06 2018   grade_2 45 0 3   0 0     0   5   25 28 0   0   2   18       2.0 53 45 0 3   0 0     0   5   25 28 0   0 2 18     2 53
2459703 WA Asotin   school 5301320 2250   Clarkston School District 530132000236 3266 Highland Elementary   Regular School No Elementary KG 06 2018   grade_2 23 1 7   0 1     0   3   15 20 0   6   3   30       1.0 35 23 1 7   0 1     0   3   15 20 0   6 3 30     1 35
2459714 WA Asotin   school 5301320 2250   Clarkston School District 530132000238 2823 Parkway Elementary   Regular School No Elementary KG 06 2018   grade_2 35 1 5   3 0     0   1   22 23 0   0   1   31       1.0 45 35 1 5   3 0     0   1   22 23 0   0 1 31     1 45
2459722 WA Asotin   school 5301320 2250   Clarkston School District 530132002613 3616 Special Services   Special Education School No Other PK 12 2018   grade_2 1 0 0   0 0     0   1   1 1 0   0   0   1       0.0 2 1 0 0   0 0     0   1   1 1 0   0 0 1     0 2
2570521 WA Asotin   school 5300280 2420   Asotin-Anatone School District 530028000027 2507 Asotin Elementary   Regular School No Elementary PK 05 2020   grade_2 34 0 1   0 1     0   3   15 24 0   0   1   20       0.0 39 34 0 1   0 1     0   3   15 24 0   0 1 20     0 39
2572520 WA Asotin   school 5301320 2250   Clarkston School District 530132000235 2962 Grantham Elementary   Regular School No Elementary KG 06 2020   grade_2 41 0 5   1 0     0   4   28 23 0   0   7   45       1.0 51 41 0 5   1 0     0   4   28 23 0   0 7 45     1 51
2572529 WA Asotin   school 5301320 2250   Clarkston School District 530132002433 4384 Heights Elementary   Regular School No Elementary KG 06 2020   grade_2 38 0 1   1 0     0   5   20 25 0   0   0   16       2.0 45 38 0 1   1 0     0   5   20 25 0   0 0 16     2 45
2572538 WA Asotin   school 5301320 2250   Clarkston School District 530132000236 3266 Highland Elementary   Regular School No Elementary KG 06 2020   grade_2 33 0 6   1 0     0   3   18 25 0   2   7   34       2.0 43 33 0 6   1 0     0   3   18 25 0   2 7 34     2 43
2572550 WA Asotin   school 5301320 2250   Clarkston School District 530132000238 2823 Parkway Elementary   Regular School No Elementary KG 06 2020   grade_2 40 0 2   1 1     0   3   25 22 0   1   4   30       3.0 47 40 0 2   1 1     0   3   25 22 0   1 4 30     3 47
2572559 WA Asotin   school 5301320 2250   Clarkston School District 530132002613 3616 Special Services   Special Education School No Other PK 12 2020   grade_2 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
2931408 WA Asotin   school 5300280 2420   Asotin-Anatone School District 530028000027 2507 Asotin Elementary   Regular School No Elementary PK 05 2021   grade_2 47 0 3   0 1     2   3   34 22 0   0   0   25       0.0 56 47 0 3   0 1     2   3   34 22 0   0 0 25     0 56
2933412 WA Asotin   school 5301320 2250   Clarkston School District 530132003725 5644 Clarkston Home Alliance   Alternative School No Other KG 12 2021   grade_2 1 0 0   0 0     0   0   0 1 0   0   0   0       0.0 1 1 0 0   0 0     0   0   0 1 0   0 0 0     0 1
2933428 WA Asotin   school 5301320 2250   Clarkston School District 530132000235 2962 Grantham Elementary   Regular School No Elementary KG 06 2021   grade_2 20 0 7   0 0     0   1   17 11 0   0   3   24       1.0 28 20 0 7   0 0     0   1   17 11 0   0 3 24     1 28
2933437 WA Asotin   school 5301320 2250   Clarkston School District 530132002433 4384 Heights Elementary   Regular School No Elementary KG 06 2021   grade_2 50 1 3   0 1     0   0   27 28 0   1   0   12       1.0 55 50 1 3   0 1     0   0   27 28 0   1 0 12     1 55
2933445 WA Asotin   school 5301320 2250   Clarkston School District 530132000236 3266 Highland Elementary   Regular School No Elementary KG 06 2021   grade_2 17 0 1   0 0     0   4   10 12 0   0   3   17       0.0 22 17 0 1   0 0     0   4   10 12 0   0 3 17     0 22
2933456 WA Asotin   school 5301320 2250   Clarkston School District 530132000238 2823 Parkway Elementary   Regular School No Elementary KG 06 2021   grade_2 59 1 6   0 0     0   5   41 30 0   0   5   46       1.0 71 59 1 6   0 0     0   5   41 30 0   0 5 46     1 71
2933465 WA Asotin   school 5301320 2250   Clarkston School District 530132002613 3616 Special Services   Special Education School No Other PK 12 2021   grade_2 3 0 0   1 0     0   0   1 3 0   0   0   1       0.0 4 3 0 0   1 0     0   0   1 3 0   0 0 1     0 4
464224 WA Benton   school 5302910 3053   Finley School District 530291000468 3078 Finley Elementary   Regular School No 1.0 PK 05 2015   grade_2 38 0 20   0 0     0   4   34 28 0   11   0   52       0.0 62 38 0 20   0 0     0   4   34 28 0   11 0 52     0 62

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