Data source: Big Local News · About: Big Local

4,696 rows where grade = "grade_2" and state = "SD" sorted by female_int descending

View and edit SQL

year

grade

  • grade_2 · 4,696
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
3008722 SD     school 4619410 51001   Douglas 51-1 461941000439 4 Francis Case Elementary   Regular School No Elementary 02 03 2017   grade_2 180.0 6.0 29.0 17.0   2.0         20.0   124.0 130.0                       254.0 180 6 29 17   2         20   124 130                 254
451408 SD     school 4619410 51001   Douglas 51-1 461941001384 6 Patriot Elementary   Regular School Not applicable Elementary KG 03 2021   grade_2 157.0 1.0 35.0 15.0   4.0       0.0 25.0   116.0 121.0                       237.0 157 1 35 15   4       0 25   116 121                 237
252308 SD     school 4619410 51001   Douglas 51-1 461941001384 6 Patriot Elementary   Regular School No Elementary KG 03 2018   grade_2 165.0 7.0 26.0 11.0   0.0       1.0 34.0   124.0 120.0                       244.0 165 7 26 11   0       1 34   124 120                 244
359567 SD     school 4619410 51001   Douglas 51-1 461941001384 6 Patriot Elementary   Regular School No Elementary KG 03 2019   grade_2 169.0 9.0 18.0 16.0   4.0       0.0 32.0   130.0 118.0                       248.0 169 9 18 16   4       0 32   130 118                 248
361656 SD     school 4635480 2002   Huron 02-2 463548001369 19 Madison 2-3 Center   Regular School No Elementary 02 03 2019   grade_2 88.0 5.0 77.0 6.0   50.0       1.0 8.0   118.0 117.0                       235.0 88 5 77 6   50       1 8   118 117                 235
3346634 SD     school 4619410 51001   Douglas 51-1 461941000439 4 Francis Case Elementary   Regular School No 1 02 03 2016   grade_2 175.0 7.0 16.0 16.0   4.0         23.0   125.0 116.0                       241.0 175 7 16 16   4         23   125 116                 241
2964018 SD     school 4619410 51001   Douglas 51-1 461941000439 4 Francis Case Elementary   Regular School No 1 02 03 2015   grade_2 170.0 7.0 21.0 12.0   2.0       0.0 20.0   119.0 113.0                       232.0 170 7 21 12   2       0 20   119 113                 232
489836 SD     school 4619410 51001   Douglas 51-1 461941001384 6 Patriot Elementary   Regular School Not applicable Elementary KG 03 2020   grade_2 144.0 5.0 25.0 12.0   0.0       1.0 30.0   108.0 109.0                       217.0 144 5 25 12   0       1 30   108 109                 217
491925 SD     school 4635480 2002   Huron 02-2 463548001369 19 Madison 2-3 Center   Regular School Not applicable Elementary 02 03 2020   grade_2 75.0 4.0 79.0 3.0   66.0       0.0 9.0   128.0 108.0                       236.0 75 4 79 3   66       0 9   128 108                 236
453502 SD     school 4635480 2002   Huron 02-2 463548001369 19 Madison 2-3 Center   Regular School Not applicable Elementary 02 03 2021   grade_2 82.0 0.0 63.0 9.0   55.0       2.0 7.0   116.0 102.0                       218.0 82 0 63 9   55       2 7   116 102                 218
3353045 SD     school 4666930 40002   Spearfish 40-2 466693000392 3 West Elementary   Regular School No 1 01 02 2016   grade_2 177.0 2.0 8.0 5.0   0.0       0.0 6.0   100.0 98.0                       198.0 177 2 8 5   0       0 6   100 98                 198
254429 SD     school 4635480 2002   Huron 02-2 463548001369 19 Madison 2-3 Center   Regular School No Elementary 02 03 2018   grade_2 94.0 2.0 70.0 3.0   53.0         9.0   134.0 97.0                       231.0 94 2 70 3   53         9   134 97                 231
2970477 SD     school 4666930 40002   Spearfish 40-2 466693000392 3 West Elementary   Regular School No 1 01 02 2015   grade_2 170.0 0.0 10.0 6.0   1.0         4.0   95.0 96.0                       191.0 170 0 10 6   1         4   95 96                 191
365951 SD     school 4666930 40002   Spearfish 40-2 466693000392 3 West Elementary   Regular School No Elementary 01 02 2019   grade_2 157.0 1.0 8.0 3.0   5.0         9.0   91.0 92.0                       183.0 157 1 8 3   5         9   91 92                 183
3010886 SD     school 4635480 2002   Huron 02-2 463548001369 19 Madison 2-3 Center   Regular School No Elementary 02 03 2017   grade_2 96.0 1.0 52.0 4.0   40.0         5.0   106.0 92.0                       198.0 96 1 52 4   40         5   106 92                 198
2966187 SD     school 4635480 2002   Huron 02-2 463548001322 9 Huron Elem   Regular School No 1 KG 05 2015   grade_2 85.0 3.0 44.0 4.0   35.0       0.0 4.0   88.0 87.0                       175.0 85 3 44 4   35       0 4   88 87                 175
3352312 SD     school 4666270 49005   Sioux Falls 49-5 466627001300 17 R. F. Pettigrew Elementary   Regular School No 1 PK 05 2016   grade_2 125.0 1.0 10.0 0.0   2.0         7.0   58.0 87.0                       145.0 125 1 10 0   2         7   58 87                 145
496236 SD     school 4666930 40002   Spearfish 40-2 466693000392 3 West Elementary   Regular School Not applicable Elementary 01 02 2020   grade_2 143.0 0.0 6.0 4.0   0.0         4.0   72.0 85.0                       157.0 143 0 6 4   0         4   72 85                 157
3014420 SD     school 4666270 49005   Sioux Falls 49-5 466627001238 26 Discovery Elementary   Regular School No Elementary PK 05 2017   grade_2 126.0 7.0 13.0 0.0   3.0         10.0   74.0 85.0                       159.0 126 7 13 0   3         10   74 85                 159
3348771 SD     school 4635480 2002   Huron 02-2 463548001322 9 Huron Elem   Regular School No 1 KG 05 2016   grade_2 101.0 3.0 54.0 2.0   41.0       0.0 7.0   125.0 83.0                       208.0 101 3 54 2   41       0 7   125 83                 208
258724 SD     school 4666930 40002   Spearfish 40-2 466693000392 3 West Elementary   Regular School No Elementary 01 02 2018   grade_2 159.0 4.0 10.0 4.0   0.0         4.0   101.0 80.0                       181.0 159 4 10 4   0         4   101 80                 181
257985 SD     school 4666270 49005   Sioux Falls 49-5 466627001238 26 Discovery Elementary   Regular School No Elementary PK 05 2018   grade_2 121.0 11.0 11.0 1.0   3.0       0.0 12.0   80.0 79.0                       159.0 121 11 11 1   3       0 12   80 79                 159
457813 SD     school 4666930 40002   Spearfish 40-2 466693000392 3 West Elementary   Regular School Not applicable Elementary 01 02 2021   grade_2 140.0 0.0 10.0 2.0   1.0         5.0   80.0 78.0                       158.0 140 0 10 2   1         5   80 78                 158
365256 SD     school 4666270 49005   Sioux Falls 49-5 466627001238 26 Discovery Elementary   Regular School No Elementary PK 05 2019   grade_2 103.0 17.0 7.0 1.0   2.0       0.0 8.0   62.0 76.0                       138.0 103 17 7 1   2       0 8   62 76                 138
495561 SD     school 4666270 49005   Sioux Falls 49-5 466627001300 17 R. F. Pettigrew Elementary   Regular School Not applicable Elementary PK 05 2020   grade_2 120.0 5.0 8.0 2.0   3.0       0.0 10.0   77.0 71.0                       148.0 120 5 8 2   3       0 10   77 71                 148
3014441 SD     school 4666270 49005   Sioux Falls 49-5 466627001300 17 R. F. Pettigrew Elementary   Regular School No Elementary PK 05 2017   grade_2 122.0 8.0 6.0 0.0   1.0       0.0 10.0   76.0 71.0                       147.0 122 8 6 0   1       0 10   76 71                 147
3015144 SD     school 4666930 40002   Spearfish 40-2 466693000392 3 West Elementary   Regular School No Elementary 01 02 2017   grade_2 156.0 2.0 5.0 5.0   4.0       1.0 3.0   105.0 71.0                       176.0 156 2 5 5   4       1 3   105 71                 176
365276 SD     school 4666270 49005   Sioux Falls 49-5 466627001300 17 R. F. Pettigrew Elementary   Regular School No Elementary PK 05 2019   grade_2 114.0 7.0 3.0 2.0   3.0       1.0 9.0   69.0 70.0                       139.0 114 7 3 2   3       1 9   69 70                 139
258927 SD     school 4600052 41005   Tea Area 41-5 460005200388 1 Tea Area Legacy Elementary   Regular School No Elementary KG 04 2018   grade_2 132.0 0.0 4.0 1.0   0.0         7.0   75.0 69.0                       144.0 132 0 4 1   0         7   75 69                 144
3015337 SD     school 4600052 41005   Tea Area 41-5 460005200388 1 Tea Area Legacy Elementary   Regular School No Elementary KG 04 2017   grade_2 128.0 0.0 4.0 2.0   0.0         3.0   68.0 69.0                       137.0 128 0 4 2   0         3   68 69                 137
258006 SD     school 4666270 49005   Sioux Falls 49-5 466627001300 17 R. F. Pettigrew Elementary   Regular School No Elementary PK 05 2018   grade_2 108.0 3.0 11.0 3.0   1.0       1.0 11.0   70.0 68.0                       138.0 108 3 11 3   1       1 11   70 68                 138
358088 SD     school 4607950 49002   Brandon Valley 49-2 460795001302 6 Fred Assam Elementary   Regular School No Elementary KG 04 2019   grade_2 97.0 7.0 2.0     4.0         9.0   51.0 68.0                       119.0 97 7 2     4         9   51 68                 119
457138 SD     school 4666270 49005   Sioux Falls 49-5 466627001300 17 R. F. Pettigrew Elementary   Regular School Not applicable Elementary PK 05 2021   grade_2 127.0 8.0 5.0 1.0   2.0       0.0 7.0   82.0 68.0                       150.0 127 8 5 1   2       0 7   82 68                 150
488607 SD     school 4608520 5001   Brookings 05-1 460852001356 7 Dakota Prairie Elementary   Regular School Not applicable Elementary KG 03 2020   grade_2 117.0 3.0 2.0 1.0   3.0         5.0   63.0 68.0                       131.0 117 3 2 1   3         5   63 68                 131
495540 SD     school 4666270 49005   Sioux Falls 49-5 466627001238 26 Discovery Elementary   Regular School Not applicable Elementary PK 05 2020   grade_2 102.0 10.0 11.0 3.0   0.0       0.0 6.0   64.0 68.0                       132.0 102 10 11 3   0       0 6   64 68                 132
2962830 SD     school 4608520 5001   Brookings 05-1 460852000086 5 Medary Elem   Regular School No 1 KG 03 2015   grade_2 102.0 7.0 4.0 6.0   3.0         7.0   61.0 68.0                       129.0 102 7 4 6   3         7   61 68                 129
365281 SD     school 4666270 49005   Sioux Falls 49-5 466627001344 65 Sonia Sotomayor Elementary   Regular School No Elementary PK 05 2019   grade_2 96.0 5.0 14.0 0.0   0.0         7.0   55.0 67.0                       122.0 96 5 14 0   0         7   55 67                 122
2969723 SD     school 4666270 49005   Sioux Falls 49-5 466627001300 17 R. F. Pettigrew Elementary   Regular School No 1 PK 05 2015   grade_2 120.0 1.0 4.0 1.0   2.0         9.0   71.0 66.0                       137.0 120 1 4 1   2         9   71 66                 137
2969721 SD     school 4666270 49005   Sioux Falls 49-5 466627000813 58 Oscar Howe Elementary   Regular School No 1 KG 05 2015   grade_2 88.0 8.0 9.0 6.0   1.0       2.0 7.0   56.0 65.0                       121.0 88 8 9 6   1       2 7   56 65                 121
3352290 SD     school 4666270 49005   Sioux Falls 49-5 466627001238 26 Discovery Elementary   Regular School No 1 KG 05 2016   grade_2 116.0 6.0 8.0 1.0   4.0         3.0   73.0 65.0                       138.0 116 6 8 1   4         3   73 65                 138
2962829 SD     school 4608520 5001   Brookings 05-1 460852000085 4 Hillcrest Elem   Regular School No 1 KG 03 2015   grade_2 94.0 10.0 9.0 3.0   3.0       0.0 6.0   61.0 64.0                       125.0 94 10 9 3   3       0 6   61 64                 125
2969710 SD     school 4666270 49005   Sioux Falls 49-5 466627000976 57 John F Kennedy Elementary   Regular School No 1 KG 05 2015   grade_2 101.0 6.0 6.0 2.0   2.0         7.0   60.0 64.0                       124.0 101 6 6 2   2         7   60 64                 124
3352299 SD     school 4666270 49005   Sioux Falls 49-5 466627000590 38 Hayward Elementary   Regular School No 1 PK 05 2016   grade_2 71.0 8.0 29.0 15.0   2.0       0.0 9.0   70.0 64.0                       134.0 71 8 29 15   2       0 9   70 64                 134
457117 SD     school 4666270 49005   Sioux Falls 49-5 466627001238 26 Discovery Elementary   Regular School Not applicable Elementary PK 05 2021   grade_2 107.0 6.0 6.0 2.0   6.0       1.0 8.0   73.0 63.0                       136.0 107 6 6 2   6       1 8   73 63                 136
495566 SD     school 4666270 49005   Sioux Falls 49-5 466627001344 65 Sonia Sotomayor Elementary   Regular School Not applicable Elementary PK 05 2020   grade_2 106.0 2.0 9.0 1.0   0.0         2.0   57.0 63.0                       120.0 106 2 9 1   0         2   57 63                 120
3353405 SD     school 4672090 66001   Todd County 66-1 467209001349 16 Todd County Elem   Regular School No 1 KG 05 2016   grade_2 0.0   2.0 106.0           1.0 1.0   47.0 63.0                       110.0 0   2 106           1 1   47 63                 110
488353 SD     school 4607950 49002   Brandon Valley 49-2 460795000414 3 Brandon Elem   Regular School Not applicable Elementary PK 04 2020   grade_2 98.0 7.0 6.0 1.0   0.0       0.0 5.0   55.0 62.0                       117.0 98 7 6 1   0       0 5   55 62                 117
2962590 SD     school 4607950 49002   Brandon Valley 49-2 460795000414 3 Brandon Elem   Regular School No 1 PK 05 2015   grade_2 104.0 3.0 1.0 3.0   2.0       0.0 0.0   51.0 62.0                       113.0 104 3 1 3   2       0 0   51 62                 113
3014430 SD     school 4666270 49005   Sioux Falls 49-5 466627000976 57 John F Kennedy Elementary   Regular School No Elementary KG 05 2017   grade_2 84.0 4.0 3.0 3.0   0.0         12.0   44.0 62.0                       106.0 84 4 3 3   0         12   44 62                 106
255712 SD     school 4669930 46001   Meade 46-1 466993000637 3 Sturgis Elementary   Regular School No Elementary KG 04 2018   grade_2 113.0 1.0 4.0 2.0   1.0         3.0   63.0 61.0                       124.0 113 1 4 2   1         3   63 61                 124
495565 SD     school 4666270 49005   Sioux Falls 49-5 466627001275 15 Rosa Parks Elementary   Regular School Not applicable Elementary KG 05 2020   grade_2 61.0 16.0 24.0 3.0   7.0       0.0 5.0   55.0 61.0                       116.0 61 16 24 3   7       0 5   55 61                 116
2970885 SD     school 4672090 66001   Todd County 66-1 467209001349 16 Todd County Elem   Regular School No 1 KG 05 2015   grade_2 0.0   0.0 108.0   1.0         0.0   48.0 61.0                       109.0 0   0 108   1         0   48 61                 109
357648 SD     school 4605610 9001   Belle Fourche 09-1 460561000269 3 South Park Elementary   Regular School No Elementary 01 04 2019   grade_2 96.0   7.0 3.0             6.0   52.0 60.0                       112.0 96   7 3             6   52 60                 112
2968771 SD     school 4659820 51004   Rapid City Area 51-4 465982000539 8 Knollwood Heights Elem   Regular School No 1 KG 05 2015   grade_2 29.0 1.0 15.0 50.0   0.0         10.0   45.0 60.0                       105.0 29 1 15 50   0         10   45 60                 105
2969698 SD     school 4666270 49005   Sioux Falls 49-5 466627001238 26 Discovery Elementary   Regular School No 1 KG 05 2015   grade_2 98.0 9.0 2.0 2.0   2.0         4.0   57.0 60.0                       117.0 98 9 2 2   2         4   57 60                 117
3345435 SD     school 4608520 5001   Brookings 05-1 460852000086 5 Medary Elem   Regular School No 1 KG 03 2016   grade_2 91.0 4.0 6.0 2.0   9.0       0.0 5.0   57.0 60.0                       117.0 91 4 6 2   9       0 5   57 60                 117
257168 SD     school 4659820 51004   Rapid City Area 51-4 465982000823 12 Rapid Valley Elem   Regular School No Elementary PK 05 2018   grade_2 85.0 1.0 5.0 10.0   0.0       0.0 5.0   47.0 59.0                       106.0 85 1 5 10   0       0 5   47 59                 106
457128 SD     school 4666270 49005   Sioux Falls 49-5 466627001064 23 John Harris Elementary   Regular School Not applicable Elementary PK 05 2021   grade_2 87.0 6.0 0.0 2.0   3.0         2.0   41.0 59.0                       100.0 87 6 0 2   3         2   41 59                 100
2970742 SD     school 4600052 41005   Tea Area 41-5 460005200388 1 Tea Area Elementary School   Regular School No 1 KG 02 2015   grade_2 121.0 0.0 2.0 1.0   0.0       0.0 5.0   70.0 59.0                       129.0 121 0 2 1   0       0 5   70 59                 129
3353250 SD     school 4600052 41005   Tea Area 41-5 460005200388 1 Tea Area Elementary School   Regular School No 1 PK 02 2016   grade_2 104.0 3.0 2.0 2.0             4.0   56.0 59.0                       115.0 104 3 2 2             4   56 59                 115
365254 SD     school 4666270 49005   Sioux Falls 49-5 466627000581 14 Cleveland Elementary   Regular School No Elementary PK 05 2019   grade_2 28.0 27.0 18.0 4.0   8.0         5.0   32.0 58.0                       90.0 28 27 18 4   8         5   32 58                 90
449935 SD     school 4607950 49002   Brandon Valley 49-2 460795001237 5 Robert Bennis Elementary   Regular School Not applicable Elementary KG 04 2021   grade_2 110.0 1.0 5.0 0.0   1.0         10.0   69.0 58.0                       127.0 110 1 5 0   1         10   69 58                 127
457127 SD     school 4666270 49005   Sioux Falls 49-5 466627000976 57 John F Kennedy Elementary   Regular School Not applicable Elementary KG 05 2021   grade_2 76.0 9.0 8.0 3.0   2.0         12.0   52.0 58.0                       110.0 76 9 8 3   2         12   52 58                 110
495551 SD     school 4666270 49005   Sioux Falls 49-5 466627001064 23 John Harris Elementary   Regular School Not applicable Elementary PK 05 2020   grade_2 90.0 4.0 4.0 1.0   0.0       0.0 5.0   46.0 58.0                       104.0 90 4 4 1   0       0 5   46 58                 104
3352301 SD     school 4666270 49005   Sioux Falls 49-5 466627000976 57 John F Kennedy Elementary   Regular School No 1 KG 05 2016   grade_2 93.0 4.0 4.0 1.0   0.0         13.0   57.0 58.0                       115.0 93 4 4 1   0         13   57 58                 115
3352304 SD     school 4666270 49005   Sioux Falls 49-5 466627000598 31 Laura Wilder Elementary   Regular School No 1 KG 05 2016   grade_2 64.0 9.0 11.0 11.0   3.0       0.0 9.0   49.0 58.0                       107.0 64 9 11 11   3       0 9   49 58                 107
3352310 SD     school 4666270 49005   Sioux Falls 49-5 466627000813 58 Oscar Howe Elementary   Regular School No 1 KG 05 2016   grade_2 81.0 9.0 5.0 4.0   0.0       0.0 4.0   45.0 58.0                       103.0 81 9 5 4   0       0 4   45 58                 103
251079 SD     school 4608520 5001   Brookings 05-1 460852001356 7 Dakota Prairie Elementary   Regular School No Elementary KG 03 2018   grade_2 103.0 2.0 4.0 2.0   1.0         8.0   63.0 57.0                       120.0 103 2 4 2   1         8   63 57                 120
257992 SD     school 4666270 49005   Sioux Falls 49-5 466627000588 54 Harvey Dunn Elementary   Regular School No Elementary PK 05 2018   grade_2 92.0 5.0 3.0 3.0   2.0         5.0   53.0 57.0                       110.0 92 5 3 3   2         5   53 57                 110
258011 SD     school 4666270 49005   Sioux Falls 49-5 466627001344 65 Sonia Sotomayor Elementary   Career and Technical School No Elementary PK 05 2018   grade_2 85.0 1.0 15.0 1.0   0.0       0.0 5.0   50.0 57.0                       107.0 85 1 15 1   0       0 5   50 57                 107
365265 SD     school 4666270 49005   Sioux Falls 49-5 466627000590 38 Hayward Elementary   Regular School No Elementary PK 05 2019   grade_2 44.0 16.0 28.0 10.0   1.0         8.0   50.0 57.0                       107.0 44 16 28 10   1         8   50 57                 107
449934 SD     school 4607950 49002   Brandon Valley 49-2 460795001302 6 Fred Assam Elementary   Regular School Not applicable Elementary KG 04 2021   grade_2 91.0 8.0 9.0 0.0   2.0       0.0 5.0   58.0 57.0                       115.0 91 8 9 0   2       0 5   58 57                 115
457142 SD     school 4666270 49005   Sioux Falls 49-5 466627001275 15 Rosa Parks Elementary   Regular School Not applicable Elementary KG 05 2021   grade_2 58.0 31.0 15.0 8.0   10.0       1.0 11.0   77.0 57.0                       134.0 58 31 15 8   10       1 11   77 57                 134
457143 SD     school 4666270 49005   Sioux Falls 49-5 466627001344 65 Sonia Sotomayor Elementary   Regular School Not applicable Elementary PK 05 2021   grade_2 90.0 4.0 22.0 0.0   0.0         6.0   65.0 57.0                       122.0 90 4 22 0   0         6   65 57                 122
2968784 SD     school 4659820 51004   Rapid City Area 51-4 465982000969 13 Valley View Elem   Regular School No 1 KG 05 2015   grade_2 82.0 2.0 5.0 17.0   2.0       0.0 5.0   56.0 57.0                       113.0 82 2 5 17   2       0 5   56 57                 113
3014429 SD     school 4666270 49005   Sioux Falls 49-5 466627000590 38 Hayward Elementary   Regular School No Elementary PK 05 2017   grade_2 46.0 11.0 33.0 14.0   5.0         12.0   64.0 57.0                       121.0 46 11 33 14   5         12   64 57                 121
3352302 SD     school 4666270 49005   Sioux Falls 49-5 466627001064 23 John Harris Elementary   Regular School No 1 PK 05 2016   grade_2 98.0 5.0 7.0 1.0   3.0       0.0 1.0   58.0 57.0                       115.0 98 5 7 1   3       0 1   58 57                 115
365274 SD     school 4666270 49005   Sioux Falls 49-5 466627000813 58 Oscar Howe Elementary   Regular School No Elementary KG 05 2019   grade_2 72.0 6.0 6.0 6.0   0.0         8.0   42.0 56.0                       98.0 72 6 6 6   0         8   42 56                 98
2963622 SD     school 4636990 61008   Dakota Valley 61-8 463699000251 2 Dakota Valley Elementary School   Regular School No 1 KG 04 2015   grade_2 89.0 0.0 5.0 0.0   2.0       0.0 5.0   45.0 56.0                       101.0 89 0 5 0   2       0 5   45 56                 101
2968773 SD     school 4659820 51004   Rapid City Area 51-4 465982000549 10 Meadowbrook Elem   Regular School No 1 KG 05 2015   grade_2 84.0 1.0 9.0 7.0   2.0         2.0   49.0 56.0                       105.0 84 1 9 7   2         2   49 56                 105
2969711 SD     school 4666270 49005   Sioux Falls 49-5 466627001064 23 John Harris Elementary   Regular School No 1 KG 05 2015   grade_2 103.0 4.0 3.0 4.0   3.0       0.0 3.0   64.0 56.0                       120.0 103 4 3 4   3       0 3   64 56                 120
3345432 SD     school 4608520 5001   Brookings 05-1 460852001356 7 Dakota Prairie Elementary   Regular School No 1 KG 03 2016   grade_2 105.0 1.0 1.0 2.0   3.0         5.0   61.0 56.0                       117.0 105 1 1 2   3         5   61 56                 117
257996 SD     school 4666270 49005   Sioux Falls 49-5 466627001064 23 John Harris Elementary   Regular School No Elementary PK 05 2018   grade_2 98.0 5.0 5.0 0.0   1.0       0.0 6.0   60.0 55.0                       115.0 98 5 5 0   1       0 6   60 55                 115
495550 SD     school 4666270 49005   Sioux Falls 49-5 466627000976 57 John F Kennedy Elementary   Regular School Not applicable Elementary KG 05 2020   grade_2 83.0 6.0 3.0 3.0   0.0         12.0   52.0 55.0                       107.0 83 6 3 3   0         12   52 55                 107
3014415 SD     school 4666270 49005   Sioux Falls 49-5 466627000770 20 Anne Sullivan Elementary   Regular School No Elementary PK 05 2017   grade_2 31.0 29.0 15.0 4.0   17.0         7.0   48.0 55.0                       103.0 31 29 15 4   17         7   48 55                 103
3014427 SD     school 4666270 49005   Sioux Falls 49-5 466627000588 54 Harvey Dunn Elementary   Regular School No Elementary PK 05 2017   grade_2 89.0 4.0 4.0 1.0   2.0         6.0   51.0 55.0                       106.0 89 4 4 1   2         6   51 55                 106
3014431 SD     school 4666270 49005   Sioux Falls 49-5 466627001064 23 John Harris Elementary   Regular School No Elementary PK 05 2017   grade_2 92.0 5.0 6.0 0.0   3.0       1.0 3.0   55.0 55.0                       110.0 92 5 6 0   3       1 3   55 55                 110
3015482 SD     school 4672090 66001   Todd County 66-1 467209001349 16 Todd County Elem   Regular School No Elementary KG 05 2017   grade_2 0.0   1.0 100.0   1.0       0.0 2.0   49.0 55.0                       104.0 0   1 100   1       0 2   49 55                 104
3352297 SD     school 4666270 49005   Sioux Falls 49-5 466627000588 54 Harvey Dunn Elementary   Regular School No 1 PK 05 2016   grade_2 79.0 5.0 4.0 2.0   2.0         3.0   40.0 55.0                       95.0 79 5 4 2   2         3   40 55                 95
258010 SD     school 4666270 49005   Sioux Falls 49-5 466627001275 15 Rosa Parks Elementary   Regular School No Elementary KG 05 2018   grade_2 46.0 22.0 18.0 4.0   7.0         14.0   57.0 54.0                       111.0 46 22 18 4   7         14   57 54                 111
3350011 SD     school 4669930 46001   Meade 46-1 466993000644 5 Piedmont Valley Elementary   Regular School No 1 KG 06 2016   grade_2 83.0 0.0 3.0 2.0   1.0         5.0   40.0 54.0                       94.0 83 0 3 2   1         5   40 54                 94
2969707 SD     school 4666270 49005   Sioux Falls 49-5 466627000590 38 Hayward Elementary   Regular School No 1 PK 05 2015   grade_2 63.0 8.0 35.0 2.0   1.0         10.0   66.0 53.0                       119.0 63 8 35 2   1         10   66 53                 119
3012149 SD     school 4669930 46001   Meade 46-1 466993000637 3 Sturgis Elementary   Regular School No Elementary KG 05 2017   grade_2 91.0 0.0 4.0 3.0   0.0         7.0   52.0 53.0                       105.0 91 0 4 3   0         7   52 53                 105
250829 SD     school 4607950 49002   Brandon Valley 49-2 460795001302 6 Fred Assam Elementary   Regular School No Elementary KG 04 2018   grade_2 71.0 10.0 4.0 0.0   2.0         2.0   37.0 52.0                       89.0 71 10 4 0   2         2   37 52                 89
358338 SD     school 4608520 5001   Brookings 05-1 460852001356 7 Dakota Prairie Elementary   Regular School No Elementary KG 03 2019   grade_2 88.0 6.0 5.0 1.0   2.0         8.0   58.0 52.0                       110.0 88 6 5 1   2         8   58 52                 110
359160 SD     school 4636990 61008   Dakota Valley 61-8 463699000251 2 Dakota Valley Elementary School   Regular School No Elementary KG 03 2019   grade_2 87.0 1.0 10.0 1.0   4.0         6.0   57.0 52.0                       109.0 87 1 10 1   4         6   57 52                 109
365266 SD     school 4666270 49005   Sioux Falls 49-5 466627000976 57 John F Kennedy Elementary   Regular School No Elementary KG 05 2019   grade_2 80.0 6.0 10.0 4.0   1.0         6.0   55.0 52.0                       107.0 80 6 10 4   1         6   55 52                 107
449494 SD     school 4605610 9001   Belle Fourche 09-1 460561000269 3 South Park Elementary   Regular School Not applicable Elementary 01 04 2021   grade_2 77.0   12.0 7.0             7.0   51.0 52.0                       103.0 77   12 7             7   51 52                 103
449930 SD     school 4607950 49002   Brandon Valley 49-2 460795000414 3 Brandon Elem   Regular School Not applicable Elementary PK 04 2021   grade_2 96.0 4.0 5.0 4.0   0.0       0.0 11.0   68.0 52.0                       120.0 96 4 5 4   0       0 11   68 52                 120
458463 SD     school 4674370 13001   Vermillion 13-1 467437000301 4 Jolley Elementary School   Regular School Not applicable Elementary 02 05 2021   grade_2 66.0 3.0 5.0 10.0   1.0         7.0   40.0 52.0                       92.0 66 3 5 10   1         7   40 52                 92

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