Data source: Big Local News · About: Big Local

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

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
460664 WA Adams   school 5300450 1122   Benge School District 530045000118 3142 Benge Elementary   Regular School No 1.0 KG 06 2015   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
466417 WA Adams   school 5304410 1158   Lind School District 530441000695 3421 Lind Elementary School   Regular School No 1.0 PK 06 2015   grade_4 9 0 0   0 0     0   0   5 4 0   0   1   3       0.0 9 9 0 0   0 0     0   0   5 4 0   0 1 3     0 9
469200 WA Adams   school 5306480 1147   Othello School District 530648000954 2961 Hiawatha Elementary School   Regular School No 1.0 KG 06 2015   grade_4 16 0 69   0 0     0   0   46 39 0   32   4   79       1.0 85 16 0 69   0 0     0   0   46 39 0   32 4 79     1 85
469207 WA Adams   school 5306480 1147   Othello School District 530648000955 2902 Lutacaga Elementary   Regular School No 1.0 KG 06 2015   grade_4 4 0 82   0 0     0   1   48 39 0   44   2   72       0.0 87 4 0 82   0 0     0   1   48 39 0   44 2 72     0 87
469226 WA Adams   school 5306480 1147   Othello School District 530648000958 3730 Scootney Springs Elementary   Regular School No 1.0 PK 06 2015   grade_4 11 0 83   0 0     0   1   49 46 0   36   0   81       1.0 95 11 0 83   0 0     0   1   49 46 0   36 0 81     1 95
469234 WA Adams   school 5306480 1147   Othello School District 530648003393 5285 Wahitis Elementary School   Regular School No 1.0 KG 05 2015   grade_4 2 0 65   0 0     0   0   32 35 0   25   2   57       0.0 67 2 0 65   0 0     0   0   32 35 0   25 2 57     0 67
470576 WA Adams   school 5307380 1160   Ritzville School District 530738001109 2719 Ritzville Grade School   Regular School No 1.0 KG 08 2015   grade_4 18 0 1   0 0     0   0   11 8 0   0   1   7       2.0 19 18 0 1   0 0     0   0   11 8 0   0 1 7     2 19
474723 WA Adams   school 5309570 1109   Washtucna School District 530957001625 3075 Washtucna Elementary/High School   Regular School No 4.0 KG 12 2015   grade_4 2 0 1   0 0     0   0   3 0 0   0   0   1       0.0 3 2 0 1   0 0     0   0   3 0 0   0 0 1     0 3
520647 WA Adams   school 5300450 1122   Benge School District 530045000118 3142 Benge Elementary   Regular School No 1 KG 06 2016   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
526383 WA Adams   school 5304410 1158   Lind School District 530441000695 3421 Lind Elementary School   Regular School No 1 PK 05 2016   grade_4 7 0 3   0 0     0   0   5 5 0   3   1   6       0.0 10 7 0 3   0 0     0   0   5 5 0   3 1 6     0 10
529091 WA Adams   school 5306480 1147   Othello School District 530648000954 2961 Hiawatha Elementary School   Regular School No 1 KG 05 2016   grade_4 10 0 76   0 0     0   0   41 45 0   45   3   82       2.0 86 10 0 76   0 0     0   0   41 45 0   45 3 82     2 86
529099 WA Adams   school 5306480 1147   Othello School District 530648000955 2902 Lutacaga Elementary   Regular School No 1 KG 05 2016   grade_4 2 0 87   0 0     0   0   42 47 0   49   1   79       1.0 89 2 0 87   0 0     0   0   42 47 0   49 1 79     1 89
529116 WA Adams   school 5306480 1147   Othello School District 530648000958 3730 Scootney Springs Elementary   Regular School No 1 PK 05 2016   grade_4 13 0 74   0 1     0   1   51 38 0   42   3   75       0.0 89 13 0 74   0 1     0   1   51 38 0   42 3 75     0 89
529124 WA Adams   school 5306480 1147   Othello School District 530648003393 5285 Wahitis Elementary School   Regular School No 1 KG 05 2016   grade_4 9 0 68   0 0     0   1   40 38 0   32   1   59       0.0 78 9 0 68   0 0     0   1   40 38 0   32 1 59     0 78
530525 WA Adams   school 5307380 1160   Ritzville School District 530738001109 2719 Ritzville Grade School   Regular School No 1 PK 05 2016   grade_4 27 1 2   0 1     0   1   19 13 0   0   0   16       1.0 32 27 1 2   0 1     0   1   19 13 0   0 0 16     1 32
534678 WA Adams   school 5309570 1109   Washtucna School District 530957001625 3075 Washtucna Elementary/High School   Regular School No 4 PK 12 2016   grade_4 1 0 0   0 0     0   0   1 0 0   0   0   1       0.0 1 1 0 0   0 0     0   0   1 0 0   0 0 1     0 1
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
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
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
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
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
2413965 WA Adams   school 5300450 1122   Benge School District 530045000118 3142 Benge Elementary   Regular School No Elementary KG 06 2019   grade_4 2 0 0   0 0     0   1   1 2 0   0   0   1       0.0 3 2 0 0   0 0     0   1   1 2 0   0 0 1     0 3
2419639 WA Adams   school 5304410 1158   Lind School District 530441000695 3421 Lind Elementary School   Regular School No Elementary PK 05 2019   grade_4 7 0 6   0 0     0   0   6 7 0   4   0   12       0.0 13 7 0 6   0 0     0   0   6 7 0   4 0 12     0 13
2422252 WA Adams   school 5306480 1147   Othello School District 530648000954 2961 Hiawatha Elementary School   Regular School No Elementary KG 06 2019   grade_4 10 0 74   0 0     0   0   42 42 0   36   1   79       4.0 84 10 0 74   0 0     0   0   42 42 0   36 1 79     4 84
2422261 WA Adams   school 5306480 1147   Othello School District 530648000955 2902 Lutacaga Elementary   Regular School No Elementary KG 06 2019   grade_4 4 0 81   0 0     0   0   42 43 0   42   0   76       1.0 85 4 0 81   0 0     0   0   42 43 0   42 0 76     1 85
2422279 WA Adams   school 5306480 1147   Othello School District 530648000958 3730 Scootney Springs Elementary   Regular School No Elementary KG 06 2019   grade_4 10 0 80   0 0     0   0   51 39 0   36   0   78       1.0 90 10 0 80   0 0     0   0   51 39 0   36 0 78     1 90
2422288 WA Adams   school 5306480 1147   Othello School District 530648003393 5285 Wahitis Elementary School   Regular School No Elementary KG 06 2019   grade_4 7 0 79   0 0     0   0   52 34 0   42   3   80       0.0 86 7 0 79   0 0     0   0   52 34 0   42 3 80     0 86
2423660 WA Adams   school 5307380 1160   Ritzville School District 530738001109 2719 Ritzville Grade School   Regular School No Elementary PK 05 2019   grade_4 23 0 2   0 0     0   1   16 10 0   0   0   19       0.0 26 23 0 2   0 0     0   1   16 10 0   0 0 19     0 26
2427702 WA Adams   school 5309570 1109   Washtucna School District 530957001625 3075 Washtucna Elementary/High School   Regular School No Other PK 12 2019   grade_4 6 0 0   0 0     0   1   3 4 0   0   0   7       0.0 7 6 0 0   0 0     0   1   3 4 0   0 0 7     0 7
2458513 WA Adams   school 5300450 1122   Benge School District 530045000118 3142 Benge Elementary   Regular School No Elementary KG 06 2018   grade_4 4 0 0   0 0     0   0   2 2 0   0   0   1       0.0 4 4 0 0   0 0     0   0   2 2 0   0 0 1     0 4
2464090 WA Adams   school 5304410 1158   Lind School District 530441000695 3421 Lind Elementary School   Regular School No Elementary PK 05 2018   grade_4 9 0 5   0 0     0   1   7 8 0   1   0   10       0.0 15 9 0 5   0 0     0   1   7 8 0   1 0 10     0 15
2466729 WA Adams   school 5306480 1147   Othello School District 530648000954 2961 Hiawatha Elementary School   Regular School No Elementary KG 05 2018   grade_4 10 0 87   0 0     0   1   55 46 0   42   4   89       3.0 101 10 0 87   0 0     0   1   55 46 0   42 4 89     3 101
2466737 WA Adams   school 5306480 1147   Othello School District 530648000955 2902 Lutacaga Elementary   Regular School No Elementary KG 05 2018   grade_4 6 1 90   0 1     0   1   47 54 0   55   0   80       3.0 101 6 1 90   0 1     0   1   47 54 0   55 0 80     3 101
2466756 WA Adams   school 5306480 1147   Othello School District 530648000958 3730 Scootney Springs Elementary   Regular School No Elementary KG 05 2018   grade_4 12 0 92   0 0     0   0   63 41 0   48   1   93       0.0 104 12 0 92   0 0     0   0   63 41 0   48 1 93     0 104
2466764 WA Adams   school 5306480 1147   Othello School District 530648003393 5285 Wahitis Elementary School   Regular School No Elementary KG 05 2018   grade_4 8 0 87   0 0     0   1   59 42 0   52   0   93       1.0 101 8 0 87   0 0     0   1   59 42 0   52 0 93     1 101
2468167 WA Adams   school 5307380 1160   Ritzville School District 530738001109 2719 Ritzville Grade School   Regular School No Elementary KG 05 2018   grade_4 23 0 4   0 1     0   0   17 11 0   0   1   12       0.0 28 23 0 4   0 1     0   0   17 11 0   0 1 12     0 28
2472217 WA Adams   school 5309570 1109   Washtucna School District 530957001625 3075 Washtucna Elementary/High School   Regular School No Other PK 12 2018   grade_4 1 0 0   0 0     0   0   1 0 0   0   0   1       0.0 1 1 0 0   0 0     0   0   1 0 0   0 0 1     0 1
2571287 WA Adams   school 5300450 1122   Benge School District 530045000118 3142 Benge Elementary   Regular School No Elementary KG 06 2020   grade_4 2 0 1   0 0     0   0   1 2 0   0   0   0       0.0 3 2 0 1   0 0     0   0   1 2 0   0 0 0     0 3
2576986 WA Adams   school 5304410 1158   Lind School District 530441000695 3421 Lind Elementary School   Regular School No Elementary PK 05 2020   grade_4 14 0 4   0 0     0   0   8 10 0   1   0   9       0.0 18 14 0 4   0 0     0   0   8 10 0   1 0 9     0 18
2579598 WA Adams   school 5306480 1147   Othello School District 530648000954 2961 Hiawatha Elementary School   Regular School No Elementary KG 06 2020   grade_4 11 0 84   0 1     0   1   49 48 0   52   2   87       0.0 97 11 0 84   0 1     0   1   49 48 0   52 2 87     0 97
2579606 WA Adams   school 5306480 1147   Othello School District 530648000955 2902 Lutacaga Elementary   Regular School No Elementary KG 06 2020   grade_4 1 0 93   0 0     0   0   47 47 0   47   0   80       2.0 94 1 0 93   0 0     0   0   47 47 0   47 0 80     2 94
2579623 WA Adams   school 5306480 1147   Othello School District 530648000958 3730 Scootney Springs Elementary   Regular School No Elementary KG 06 2020   grade_4 13 0 80   0 1     0   1   45 50 0   30   1   83       3.0 95 13 0 80   0 1     0   1   45 50 0   30 1 83     3 95
2579631 WA Adams   school 5306480 1147   Othello School District 530648003393 5285 Wahitis Elementary School   Regular School No Elementary KG 06 2020   grade_4 8 0 79   0 0     0   2   38 51 0   42   0   77       2.0 89 8 0 79   0 0     0   2   38 51 0   42 0 77     2 89
2581041 WA Adams   school 5307380 1160   Ritzville School District 530738001109 2719 Ritzville Grade School   Regular School No Elementary PK 05 2020   grade_4 16 0 2   0 0     0   2   15 5 0   0   0   13       0.0 20 16 0 2   0 0     0   2   15 5 0   0 0 13     0 20
2585131 WA Adams   school 5309570 1109   Washtucna School District 530957001625 3075 Washtucna Elementary/High School   Regular School No Other PK 12 2020   grade_4 4 0 1   0 0     0   0   3 2 0   0   0   4       0.0 5 4 0 1   0 0     0   0   3 2 0   0 0 4     0 5
2937858 WA Adams   school 5304410 1158   Lind School District 530441000695 3421 Lind Elementary School   Regular School No Elementary PK 05 2021   grade_4 12 0 6   0 0     0   0   8 10 0   5   0   12       0.0 18 12 0 6   0 0     0   0   8 10 0   5 0 12     0 18
2940561 WA Adams   school 5306480 1147   Othello School District 530648000954 2961 Hiawatha Elementary School   Regular School No Elementary KG 06 2021   grade_4 14 0 77   0 0     0   1   43 49 0   43   3   74       2.0 92 14 0 77   0 0     0   1   43 49 0   43 3 74     2 92
2940569 WA Adams   school 5306480 1147   Othello School District 530648000955 2902 Lutacaga Elementary   Regular School No Elementary KG 06 2021   grade_4 5 0 87   0 1     0   1   51 43 0   43   0   75       0.0 94 5 0 87   0 1     0   1   51 43 0   43 0 75     0 94
2940586 WA Adams   school 5306480 1147   Othello School District 530648000958 3730 Scootney Springs Elementary   Regular School No Elementary KG 06 2021   grade_4 5 0 84   0 0     0   0   53 36 0   37   0   64       2.0 89 5 0 84   0 0     0   0   53 36 0   37 0 64     2 89
2940594 WA Adams   school 5306480 1147   Othello School District 530648003393 5285 Wahitis Elementary School   Regular School No Elementary KG 06 2021   grade_4 8 0 85   0 0     0   0   45 48 0   32   0   77       0.0 93 8 0 85   0 0     0   0   45 48 0   32 0 77     0 93
2942032 WA Adams   school 5307380 1160   Ritzville School District 530738001109 2719 Ritzville Grade School   Regular School No Elementary PK 05 2021   grade_4 18 0 9   0 1     0   0   14 14 0   0   0   16       0.0 28 18 0 9   0 1     0   0   14 14 0   0 0 16     0 28
2946175 WA Adams   school 5309570 1109   Washtucna School District 530957001625 3075 Washtucna Elementary/High School   Regular School No Other PK 12 2021   grade_4 4 0 0   0 0     0   0   2 2 0   0   0   4       0.0 4 4 0 0   0 0     0   0   2 2 0   0 0 4     0 4
459921 WA Asotin   school 5300280 2420   Asotin-Anatone School District 530028000027 2507 Asotin Elementary   Regular School No 1.0 PK 06 2015   grade_4 42 0 5   0 0     0   4   21 30 0   0   0   19       0.0 51 42 0 5   0 0     0   4   21 30 0   0 0 19     0 51
461871 WA Asotin   school 5301320 2250   Clarkston School District 530132000235 2962 Grantham Elementary   Regular School No 1.0 KG 06 2015   grade_4 28 0 4   0 0     0   3   21 14 0   0   4   30       0.0 35 28 0 4   0 0     0   3   21 14 0   0 4 30     0 35
461879 WA Asotin   school 5301320 2250   Clarkston School District 530132002433 4384 Heights Elementary   Regular School No 1.0 KG 06 2015   grade_4 48 0 2   1 0     0   1   25 27 0   0   2   23       3.0 52 48 0 2   1 0     0   1   25 27 0   0 2 23     3 52
461887 WA Asotin   school 5301320 2250   Clarkston School District 530132000236 3266 Highland Elementary   Regular School No 1.0 KG 06 2015   grade_4 36 0 3   0 0     0   7   18 28 0   1   4   35       0.0 46 36 0 3   0 0     0   7   18 28 0   1 4 35     0 46
461898 WA Asotin   school 5301320 2250   Clarkston School District 530132000238 2823 Parkway Elementary   Regular School No 1.0 KG 06 2015   grade_4 47 2 2   1 0     0   1   26 27 0   0   2   37       1.0 53 47 2 2   1 0     0   1   26 27 0   0 2 37     1 53
519893 WA Asotin   school 5300280 2420   Asotin-Anatone School District 530028000027 2507 Asotin Elementary   Regular School No 1 PK 05 2016   grade_4 38 1 0   0 0     0   4   23 20 0   0   0   12       2.0 43 38 1 0   0 0     0   4   23 20 0   0 0 12     2 43
521855 WA Asotin   school 5301320 2250   Clarkston School District 530132000235 2962 Grantham Elementary   Regular School No 1 KG 06 2016   grade_4 34 0 1   0 0     0   5   26 14 0   1   5   32       0.0 40 34 0 1   0 0     0   5   26 14 0   1 5 32     0 40
521864 WA Asotin   school 5301320 2250   Clarkston School District 530132002433 4384 Heights Elementary   Regular School No 1 KG 06 2016   grade_4 63 1 2   0 0     0   3   34 35 0   0   2   27       1.0 69 63 1 2   0 0     0   3   34 35 0   0 2 27     1 69
521873 WA Asotin   school 5301320 2250   Clarkston School District 530132000236 3266 Highland Elementary   Regular School No 1 KG 06 2016   grade_4 35 1 9   1 0     0   3   24 25 0   3   3   41       0.0 49 35 1 9   1 0     0   3   24 25 0   3 3 41     0 49
521886 WA Asotin   school 5301320 2250   Clarkston School District 530132000238 2823 Parkway Elementary   Regular School No 1 KG 06 2016   grade_4 44 1 4   0 1     0   0   28 22 0   1   1   35       1.0 50 44 1 4   0 1     0   0   28 22 0   1 1 35     1 50
521895 WA Asotin   school 5301320 2250   Clarkston School District 530132002613 3616 Special Services   Special Education School No 4 PK 12 2016   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
617261 WA Asotin   school 5300280 2420   Asotin-Anatone School District 530028000027 2507 Asotin Elementary   Regular School No Elementary PK 05 2017   grade_4 37 0 3   1 1     0   3   24 21 0   0   0   23       0.0 45 37 0 3   1 1     0   3   24 21 0   0 0 23     0 45
619210 WA Asotin   school 5301320 2250   Clarkston School District 530132000235 2962 Grantham Elementary   Regular School No Elementary KG 06 2017   grade_4 32 0 4   2 0     0   5   21 22 0   1   5   34       2.0 43 32 0 4   2 0     0   5   21 22 0   1 5 34     2 43
619220 WA Asotin   school 5301320 2250   Clarkston School District 530132002433 4384 Heights Elementary   Regular School No Elementary KG 06 2017   grade_4 47 1 5   0 1     0   1   24 31 0   0   2   19       2.0 55 47 1 5   0 1     0   1   24 31 0   0 2 19     2 55
619228 WA Asotin   school 5301320 2250   Clarkston School District 530132000236 3266 Highland Elementary   Regular School No Elementary KG 06 2017   grade_4 37 0 5   1 2     0   2   21 26 0   6   5   36       1.0 47 37 0 5   1 2     0   2   21 26 0   6 5 36     1 47
619240 WA Asotin   school 5301320 2250   Clarkston School District 530132000238 2823 Parkway Elementary   Regular School No Elementary KG 06 2017   grade_4 47 1 2   0 0     0   1   28 23 0   0   1   41       2.0 51 47 1 2   0 0     0   1   28 23 0   0 1 41     2 51
619249 WA Asotin   school 5301320 2250   Clarkston School District 530132002613 3616 Special Services   Special Education School No Other PK 12 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
2413204 WA Asotin   school 5300280 2420   Asotin-Anatone School District 530028000027 2507 Asotin Elementary   Regular School No Elementary PK 05 2019   grade_4 37 0 2   0 0     0   3   23 19 0   0   0   15       3.0 42 37 0 2   0 0     0   3   23 19 0   0 0 15     3 42
2415170 WA Asotin   school 5301320 2250   Clarkston School District 530132000235 2962 Grantham Elementary   Regular School No Elementary KG 06 2019   grade_4 25 0 0   0 0     0   3   12 16 0   0   2   24       2.0 28 25 0 0   0 0     0   3   12 16 0   0 2 24     2 28
2415178 WA Asotin   school 5301320 2250   Clarkston School District 530132002433 4384 Heights Elementary   Regular School No Elementary KG 06 2019   grade_4 41 0 5   0 0     0   3   29 20 0   0   0   17       4.0 49 41 0 5   0 0     0   3   29 20 0   0 0 17     4 49
2415187 WA Asotin   school 5301320 2250   Clarkston School District 530132000236 3266 Highland Elementary   Regular School No Elementary KG 06 2019   grade_4 39 1 2   0 0     0   2   20 24 0   0   4   32       2.0 44 39 1 2   0 0     0   2   20 24 0   0 4 32     2 44
2415199 WA Asotin   school 5301320 2250   Clarkston School District 530132000238 2823 Parkway Elementary   Regular School No Elementary KG 06 2019   grade_4 42 1 3   2 0     0   1   26 23 0   0   1   33       3.0 49 42 1 3   2 0     0   1   26 23 0   0 1 33     3 49
2457764 WA Asotin   school 5300280 2420   Asotin-Anatone School District 530028000027 2507 Asotin Elementary   Regular School No Elementary PK 05 2018   grade_4 52 0 2   0 0     0   2   27 29 0   0   0   17       1.0 56 52 0 2   0 0     0   2   27 29 0   0 0 17     1 56
2459689 WA Asotin   school 5301320 2250   Clarkston School District 530132000235 2962 Grantham Elementary   Regular School No Elementary KG 06 2018   grade_4 31 1 5   0 0     0   6   25 18 0   0   1   39       1.0 43 31 1 5   0 0     0   6   25 18 0   0 1 39     1 43
2459697 WA Asotin   school 5301320 2250   Clarkston School District 530132002433 4384 Heights Elementary   Regular School No Elementary KG 06 2018   grade_4 60 1 4   0 1     0   4   25 45 0   1   1   27       2.0 70 60 1 4   0 1     0   4   25 45 0   1 1 27     2 70
2459705 WA Asotin   school 5301320 2250   Clarkston School District 530132000236 3266 Highland Elementary   Regular School No Elementary KG 06 2018   grade_4 30 0 8   0 2     0   3   23 20 0   0   3   32       2.0 43 30 0 8   0 2     0   3   23 20 0   0 3 32     2 43
2459716 WA Asotin   school 5301320 2250   Clarkston School District 530132000238 2823 Parkway Elementary   Regular School No Elementary KG 06 2018   grade_4 29 3 3   1 1     0   0   17 20 0   1   4   30       1.0 37 29 3 3   1 1     0   0   17 20 0   1 4 30     1 37
2459724 WA Asotin   school 5301320 2250   Clarkston School District 530132002613 3616 Special Services   Special Education School No Other PK 12 2018   grade_4 4 0 0   0 1     0   0   4 1 0   0   0   2       0.0 5 4 0 0   0 1     0   0   4 1 0   0 0 2     0 5
2570523 WA Asotin   school 5300280 2420   Asotin-Anatone School District 530028000027 2507 Asotin Elementary   Regular School No Elementary PK 05 2020   grade_4 35 0 3   0 1     0   2   18 23 0   0   0   21       0.0 41 35 0 3   0 1     0   2   18 23 0   0 0 21     0 41
2572522 WA Asotin   school 5301320 2250   Clarkston School District 530132000235 2962 Grantham Elementary   Regular School No Elementary KG 06 2020   grade_4 28 0 1   0 0     0   2   15 16 0   0   5   22       3.0 31 28 0 1   0 0     0   2   15 16 0   0 5 22     3 31
2572531 WA Asotin   school 5301320 2250   Clarkston School District 530132002433 4384 Heights Elementary   Regular School No Elementary KG 06 2020   grade_4 50 0 3   0 0     0   4   24 33 0   0   1   15       1.0 57 50 0 3   0 0     0   4   24 33 0   0 1 15     1 57
2572540 WA Asotin   school 5301320 2250   Clarkston School District 530132000236 3266 Highland Elementary   Regular School No Elementary KG 06 2020   grade_4 28 1 9   0 1     0   2   19 22 0   4   3   34       1.0 41 28 1 9   0 1     0   2   19 22 0   4 3 34     1 41
2572552 WA Asotin   school 5301320 2250   Clarkston School District 530132000238 2823 Parkway Elementary   Regular School No Elementary KG 06 2020   grade_4 29 0 4   3 0     0   1   15 22 0   0   0   24       0.0 37 29 0 4   3 0     0   1   15 22 0   0 0 24     0 37
2572560 WA Asotin   school 5301320 2250   Clarkston School District 530132002613 3616 Special Services   Special Education School No Other PK 12 2020   grade_4 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
2931410 WA Asotin   school 5300280 2420   Asotin-Anatone School District 530028000027 2507 Asotin Elementary   Regular School No Elementary PK 05 2021   grade_4 40 0 4   0 0     0   1   28 17 0   0   0   16       1.0 45 40 0 4   0 0     0   1   28 17 0   0 0 16     1 45
2933414 WA Asotin   school 5301320 2250   Clarkston School District 530132003725 5644 Clarkston Home Alliance   Alternative School No Other KG 12 2021   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
2933430 WA Asotin   school 5301320 2250   Clarkston School District 530132000235 2962 Grantham Elementary   Regular School No Elementary KG 06 2021   grade_4 23 1 4   0 0     0   5   16 17 0   0   1   26       0.0 33 23 1 4   0 0     0   5   16 17 0   0 1 26     0 33
2933439 WA Asotin   school 5301320 2250   Clarkston School District 530132002433 4384 Heights Elementary   Regular School No Elementary KG 06 2021   grade_4 35 1 0   1 1     0   1   21 18 0   0   0   8       1.0 39 35 1 0   1 1     0   1   21 18 0   0 0 8     1 39
2933447 WA Asotin   school 5301320 2250   Clarkston School District 530132000236 3266 Highland Elementary   Regular School No Elementary KG 06 2021   grade_4 52 1 8   1 1     0   5   30 38 0   2   8   49       2.0 68 52 1 8   1 1     0   5   30 38 0   2 8 49     2 68
2933458 WA Asotin   school 5301320 2250   Clarkston School District 530132000238 2823 Parkway Elementary   Regular School No Elementary KG 06 2021   grade_4 25 0 1   1 0     0   3   12 18 0   0   0   15       0.0 30 25 0 1   1 0     0   3   12 18 0   0 0 15     0 30
464226 WA Benton   school 5302910 3053   Finley School District 530291000468 3078 Finley Elementary   Regular School No 1.0 PK 05 2015   grade_4 35 0 28   1 0     0   4   39 29 0   13   1   51       2.0 68 35 0 28   1 0     0   4   39 29 0   13 1 51     2 68
465226 WA Benton   school 5303930 3017   Kennewick School District 530393000701 4418 Amistad Elementary School   Regular School No 1.0 PK 05 2015   grade_4 17 5 57   0 1     0   0   40 40 0   23   5   76       0.0 80 17 5 57   0 1     0   0   40 40 0   23 5 76     0 80
465241 WA Benton   school 5303930 3017   Kennewick School District 530393000597 4072 Canyon View Elementary School   Regular School No 1.0 KG 05 2015   grade_4 41 0 31   1 0     1   4   42 36 0   9   0   56       0.0 78 41 0 31   1 0     1   4   42 36 0   9 0 56     0 78
465248 WA Benton   school 5303930 3017   Kennewick School District 530393001839 4202 Cascade Elementary School   Regular School No 1.0 KG 05 2015   grade_4 62 3 14   1 1     0   8   49 40 0   4   0   43       0.0 89 62 3 14   1 1     0   8   49 40 0   4 0 43     0 89
465257 WA Benton   school 5303930 3017   Kennewick School District 530393003330 5220 Cottonwood Elementary   Regular School No 1.0 KG 05 2015   grade_4 93 3 4   1 1     0   4   52 54 0   1   0   20       1.0 106 93 3 4   1 1     0   4   52 54 0   1 0 20     1 106

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