enrollments

Data source: Big Local News · About: Big Local

10,800 rows where state = "SD" and year = 2021 sorted by ccd_school_high_grade

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2021 · 10,700 ✖
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
450168 450168 SD     school 4608520 5001   Brookings 05-1 460852000085 4 Hillcrest Elem   Regular School Not applicable Elementary KG 03 2021   grade_10 0.0 0.0 0.0 0.0   0.0         0.0   0.0 0.0                       0.0 0 0 0 0   0         0   0 0                 0
450169 450169 SD     school 4608520 5001   Brookings 05-1 460852000086 5 Medary Elem   Regular School Not applicable Elementary KG 03 2021   grade_10 0.0 0.0 0.0 0.0   0.0       0.0 0.0   0.0 0.0                       0.0 0 0 0 0   0       0 0   0 0                 0
450172 450172 SD     school 4608520 5001   Brookings 05-1 460852001356 7 Dakota Prairie Elementary   Regular School Not applicable Elementary KG 03 2021   grade_11 0.0 0.0 0.0 0.0   0.0         0.0   0.0 0.0                       0.0 0 0 0 0   0         0   0 0                 0
450174 450174 SD     school 4608520 5001   Brookings 05-1 460852000085 4 Hillcrest Elem   Regular School Not applicable Elementary KG 03 2021   grade_11 0.0 0.0 0.0 0.0   0.0         0.0   0.0 0.0                       0.0 0 0 0 0   0         0   0 0                 0
450175 450175 SD     school 4608520 5001   Brookings 05-1 460852000086 5 Medary Elem   Regular School Not applicable Elementary KG 03 2021   grade_11 0.0 0.0 0.0 0.0   0.0       0.0 0.0   0.0 0.0                       0.0 0 0 0 0   0       0 0   0 0                 0
450178 450178 SD     school 4608520 5001   Brookings 05-1 460852001356 7 Dakota Prairie Elementary   Regular School Not applicable Elementary KG 03 2021   grade_12 0.0 0.0 0.0 0.0   0.0         0.0   0.0 0.0                       0.0 0 0 0 0   0         0   0 0                 0
450180 450180 SD     school 4608520 5001   Brookings 05-1 460852000085 4 Hillcrest Elem   Regular School Not applicable Elementary KG 03 2021   grade_12 0.0 0.0 0.0 0.0   0.0         0.0   0.0 0.0                       0.0 0 0 0 0   0         0   0 0                 0
450181 450181 SD     school 4608520 5001   Brookings 05-1 460852000086 5 Medary Elem   Regular School Not applicable Elementary KG 03 2021   grade_12 0.0 0.0 0.0 0.0   0.0       0.0 0.0   0.0 0.0                       0.0 0 0 0 0   0       0 0   0 0                 0
450184 450184 SD     school 4608520 5001   Brookings 05-1 460852001356 7 Dakota Prairie Elementary   Regular School Not applicable Elementary KG 03 2021   grade_2 75.0 3.0 1.0 0.0   1.0         5.0   43.0 42.0                       85.0 75 3 1 0   1         5   43 42                 85
450186 450186 SD     school 4608520 5001   Brookings 05-1 460852000085 4 Hillcrest Elem   Regular School Not applicable Elementary KG 03 2021   grade_2 47.0 1.0 4.0 1.0   0.0         5.0   29.0 29.0                       58.0 47 1 4 1   0         5   29 29                 58
450187 450187 SD     school 4608520 5001   Brookings 05-1 460852000086 5 Medary Elem   Regular School Not applicable Elementary KG 03 2021   grade_2 62.0 2.0 8.0 4.0   4.0       1.0 5.0   48.0 38.0                       86.0 62 2 8 4   4       1 5   48 38                 86
450190 450190 SD     school 4608520 5001   Brookings 05-1 460852001356 7 Dakota Prairie Elementary   Regular School Not applicable Elementary KG 03 2021   grade_3 109.0 3.0 2.0 2.0   3.0         5.0   62.0 62.0                       124.0 109 3 2 2   3         5   62 62                 124
450192 450192 SD     school 4608520 5001   Brookings 05-1 460852000085 4 Hillcrest Elem   Regular School Not applicable Elementary KG 03 2021   grade_3 42.0 3.0 3.0 1.0   1.0         2.0   30.0 22.0                       52.0 42 3 3 1   1         2   30 22                 52
450193 450193 SD     school 4608520 5001   Brookings 05-1 460852000086 5 Medary Elem   Regular School Not applicable Elementary KG 03 2021   grade_3 60.0 6.0 8.0 2.0   2.0       0.0 3.0   39.0 42.0                       81.0 60 6 8 2   2       0 3   39 42                 81
450196 450196 SD     school 4608520 5001   Brookings 05-1 460852001356 7 Dakota Prairie Elementary   Regular School Not applicable Elementary KG 03 2021   grade_4 0.0 0.0 0.0 0.0   0.0         0.0   0.0 0.0                       0.0 0 0 0 0   0         0   0 0                 0
450198 450198 SD     school 4608520 5001   Brookings 05-1 460852000085 4 Hillcrest Elem   Regular School Not applicable Elementary KG 03 2021   grade_4 0.0 0.0 0.0 0.0   0.0         0.0   0.0 0.0                       0.0 0 0 0 0   0         0   0 0                 0
450199 450199 SD     school 4608520 5001   Brookings 05-1 460852000086 5 Medary Elem   Regular School Not applicable Elementary KG 03 2021   grade_4 0.0 0.0 0.0 0.0   0.0       0.0 0.0   0.0 0.0                       0.0 0 0 0 0   0       0 0   0 0                 0
450202 450202 SD     school 4608520 5001   Brookings 05-1 460852001356 7 Dakota Prairie Elementary   Regular School Not applicable Elementary KG 03 2021   grade_5 0.0 0.0 0.0 0.0   0.0         0.0   0.0 0.0                       0.0 0 0 0 0   0         0   0 0                 0
450204 450204 SD     school 4608520 5001   Brookings 05-1 460852000085 4 Hillcrest Elem   Regular School Not applicable Elementary KG 03 2021   grade_5 0.0 0.0 0.0 0.0   0.0         0.0   0.0 0.0                       0.0 0 0 0 0   0         0   0 0                 0
450205 450205 SD     school 4608520 5001   Brookings 05-1 460852000086 5 Medary Elem   Regular School Not applicable Elementary KG 03 2021   grade_5 0.0 0.0 0.0 0.0   0.0       0.0 0.0   0.0 0.0                       0.0 0 0 0 0   0       0 0   0 0                 0
450208 450208 SD     school 4608520 5001   Brookings 05-1 460852001356 7 Dakota Prairie Elementary   Regular School Not applicable Elementary KG 03 2021   grade_6 0.0 0.0 0.0 0.0   0.0         0.0   0.0 0.0                       0.0 0 0 0 0   0         0   0 0                 0
450210 450210 SD     school 4608520 5001   Brookings 05-1 460852000085 4 Hillcrest Elem   Regular School Not applicable Elementary KG 03 2021   grade_6 0.0 0.0 0.0 0.0   0.0         0.0   0.0 0.0                       0.0 0 0 0 0   0         0   0 0                 0
450211 450211 SD     school 4608520 5001   Brookings 05-1 460852000086 5 Medary Elem   Regular School Not applicable Elementary KG 03 2021   grade_6 0.0 0.0 0.0 0.0   0.0       0.0 0.0   0.0 0.0                       0.0 0 0 0 0   0       0 0   0 0                 0
450214 450214 SD     school 4608520 5001   Brookings 05-1 460852001356 7 Dakota Prairie Elementary   Regular School Not applicable Elementary KG 03 2021   grade_7 0.0 0.0 0.0 0.0   0.0         0.0   0.0 0.0                       0.0 0 0 0 0   0         0   0 0                 0
450216 450216 SD     school 4608520 5001   Brookings 05-1 460852000085 4 Hillcrest Elem   Regular School Not applicable Elementary KG 03 2021   grade_7 0.0 0.0 0.0 0.0   0.0         0.0   0.0 0.0                       0.0 0 0 0 0   0         0   0 0                 0
450217 450217 SD     school 4608520 5001   Brookings 05-1 460852000086 5 Medary Elem   Regular School Not applicable Elementary KG 03 2021   grade_7 0.0 0.0 0.0 0.0   0.0       0.0 0.0   0.0 0.0                       0.0 0 0 0 0   0       0 0   0 0                 0
450220 450220 SD     school 4608520 5001   Brookings 05-1 460852001356 7 Dakota Prairie Elementary   Regular School Not applicable Elementary KG 03 2021   grade_8 0.0 0.0 0.0 0.0   0.0         0.0   0.0 0.0                       0.0 0 0 0 0   0         0   0 0                 0
450222 450222 SD     school 4608520 5001   Brookings 05-1 460852000085 4 Hillcrest Elem   Regular School Not applicable Elementary KG 03 2021   grade_8 0.0 0.0 0.0 0.0   0.0         0.0   0.0 0.0                       0.0 0 0 0 0   0         0   0 0                 0
450223 450223 SD     school 4608520 5001   Brookings 05-1 460852000086 5 Medary Elem   Regular School Not applicable Elementary KG 03 2021   grade_8 0.0 0.0 0.0 0.0   0.0       0.0 0.0   0.0 0.0                       0.0 0 0 0 0   0       0 0   0 0                 0
450226 450226 SD     school 4608520 5001   Brookings 05-1 460852001356 7 Dakota Prairie Elementary   Regular School Not applicable Elementary KG 03 2021   grade_9 0.0 0.0 0.0 0.0   0.0         0.0   0.0 0.0                       0.0 0 0 0 0   0         0   0 0                 0
450228 450228 SD     school 4608520 5001   Brookings 05-1 460852000085 4 Hillcrest Elem   Regular School Not applicable Elementary KG 03 2021   grade_9 0.0 0.0 0.0 0.0   0.0         0.0   0.0 0.0                       0.0 0 0 0 0   0         0   0 0                 0
450229 450229 SD     school 4608520 5001   Brookings 05-1 460852000086 5 Medary Elem   Regular School Not applicable Elementary KG 03 2021   grade_9 0.0 0.0 0.0 0.0   0.0       0.0 0.0   0.0 0.0                       0.0 0 0 0 0   0       0 0   0 0                 0
450232 450232 SD     school 4608520 5001   Brookings 05-1 460852001356 7 Dakota Prairie Elementary   Regular School Not applicable Elementary KG 03 2021   k_12_total 375.0 13.0 12.0 2.0   4.0         26.0   225.0 207.0       2.6               432.0 375 13 12 2   4         26   225 207                 432
450234 450234 SD     school 4608520 5001   Brookings 05-1 460852000085 4 Hillcrest Elem   Regular School Not applicable Elementary KG 03 2021   k_12_total 202.0 8.0 21.0 6.0   7.0         20.0   145.0 119.0       9.9               264.0 202 8 21 6   7         20   145 119                 264
450235 450235 SD     school 4608520 5001   Brookings 05-1 460852000086 5 Medary Elem   Regular School Not applicable Elementary KG 03 2021   k_12_total 244.0 16.0 37.0 9.0   10.0       1.0 16.0   178.0 155.0       14.4               333.0 244 16 37 9   10       1 16   178 155                 333
450238 450238 SD     school 4608520 5001   Brookings 05-1 460852001356 7 Dakota Prairie Elementary   Regular School Not applicable Elementary KG 03 2021   kindergarten 102.0 5.0 2.0 0.0   0.0         8.0   63.0 54.0                       117.0 102 5 2 0   0         8   63 54                 117
450240 450240 SD     school 4608520 5001   Brookings 05-1 460852000085 4 Hillcrest Elem   Regular School Not applicable Elementary KG 03 2021   kindergarten 64.0 3.0 6.0 0.0   2.0         3.0   39.0 39.0                       78.0 64 3 6 0   2         3   39 39                 78
450241 450241 SD     school 4608520 5001   Brookings 05-1 460852000086 5 Medary Elem   Regular School Not applicable Elementary KG 03 2021   kindergarten 70.0 3.0 13.0 0.0   3.0       0.0 4.0   52.0 41.0                       93.0 70 3 13 0   3       0 4   52 41                 93
450244 450244 SD     school 4608520 5001   Brookings 05-1 460852001356 7 Dakota Prairie Elementary   Regular School Not applicable Elementary KG 03 2021   pk_12_total 375.0 13.0 12.0 2.0   4.0         26.0   225.0 207.0                       432.0 375 13 12 2   4         26   225 207                 432
450246 450246 SD     school 4608520 5001   Brookings 05-1 460852000085 4 Hillcrest Elem   Regular School Not applicable Elementary KG 03 2021   pk_12_total 202.0 8.0 21.0 6.0   7.0         20.0   145.0 119.0                       264.0 202 8 21 6   7         20   145 119                 264
450247 450247 SD     school 4608520 5001   Brookings 05-1 460852000086 5 Medary Elem   Regular School Not applicable Elementary KG 03 2021   pk_12_total 244.0 16.0 37.0 9.0   10.0       1.0 16.0   178.0 155.0                       333.0 244 16 37 9   10       1 16   178 155                 333
450250 450250 SD     school 4608520 5001   Brookings 05-1 460852001356 7 Dakota Prairie Elementary   Regular School Not applicable Elementary KG 03 2021   pre_kindergarten 0.0 0.0 0.0 0.0   0.0         0.0   0.0 0.0                       0.0 0 0 0 0   0         0   0 0                 0
450252 450252 SD     school 4608520 5001   Brookings 05-1 460852000085 4 Hillcrest Elem   Regular School Not applicable Elementary KG 03 2021   pre_kindergarten 0.0 0.0 0.0 0.0   0.0         0.0   0.0 0.0                       0.0 0 0 0 0   0         0   0 0                 0
450253 450253 SD     school 4608520 5001   Brookings 05-1 460852000086 5 Medary Elem   Regular School Not applicable Elementary KG 03 2021   pre_kindergarten 0.0 0.0 0.0 0.0   0.0       0.0 0.0   0.0 0.0                       0.0 0 0 0 0   0       0 0   0 0                 0
450990 450990 SD     school 4636990 61008   Dakota Valley 61-8 463699000251 2 Dakota Valley Elementary School   Regular School Not applicable Elementary KG 03 2021   grade_1 67.0 1.0 4.0 2.0   3.0       0.0 7.0   39.0 45.0                       84.0 67 1 4 2   3       0 7   39 45                 84
450994 450994 SD     school 4636990 61008   Dakota Valley 61-8 463699000251 2 Dakota Valley Elementary School   Regular School Not applicable Elementary KG 03 2021   grade_10 0.0 0.0 0.0 0.0   0.0       0.0 0.0   0.0 0.0                       0.0 0 0 0 0   0       0 0   0 0                 0
450998 450998 SD     school 4636990 61008   Dakota Valley 61-8 463699000251 2 Dakota Valley Elementary School   Regular School Not applicable Elementary KG 03 2021   grade_11 0.0 0.0 0.0 0.0   0.0       0.0 0.0   0.0 0.0                       0.0 0 0 0 0   0       0 0   0 0                 0
451002 451002 SD     school 4636990 61008   Dakota Valley 61-8 463699000251 2 Dakota Valley Elementary School   Regular School Not applicable Elementary KG 03 2021   grade_12 0.0 0.0 0.0 0.0   0.0       0.0 0.0   0.0 0.0                       0.0 0 0 0 0   0       0 0   0 0                 0
451006 451006 SD     school 4636990 61008   Dakota Valley 61-8 463699000251 2 Dakota Valley Elementary School   Regular School Not applicable Elementary KG 03 2021   grade_2 74.0 2.0 10.0 2.0   5.0       0.0 12.0   57.0 48.0                       105.0 74 2 10 2   5       0 12   57 48                 105
451010 451010 SD     school 4636990 61008   Dakota Valley 61-8 463699000251 2 Dakota Valley Elementary School   Regular School Not applicable Elementary KG 03 2021   grade_3 90.0 2.0 10.0 1.0   4.0       0.0 5.0   58.0 54.0                       112.0 90 2 10 1   4       0 5   58 54                 112
451014 451014 SD     school 4636990 61008   Dakota Valley 61-8 463699000251 2 Dakota Valley Elementary School   Regular School Not applicable Elementary KG 03 2021   grade_4 0.0 0.0 0.0 0.0   0.0       0.0 0.0   0.0 0.0                       0.0 0 0 0 0   0       0 0   0 0                 0
451018 451018 SD     school 4636990 61008   Dakota Valley 61-8 463699000251 2 Dakota Valley Elementary School   Regular School Not applicable Elementary KG 03 2021   grade_5 0.0 0.0 0.0 0.0   0.0       0.0 0.0   0.0 0.0                       0.0 0 0 0 0   0       0 0   0 0                 0
451022 451022 SD     school 4636990 61008   Dakota Valley 61-8 463699000251 2 Dakota Valley Elementary School   Regular School Not applicable Elementary KG 03 2021   grade_6 0.0 0.0 0.0 0.0   0.0       0.0 0.0   0.0 0.0                       0.0 0 0 0 0   0       0 0   0 0                 0
451026 451026 SD     school 4636990 61008   Dakota Valley 61-8 463699000251 2 Dakota Valley Elementary School   Regular School Not applicable Elementary KG 03 2021   grade_7 0.0 0.0 0.0 0.0   0.0       0.0 0.0   0.0 0.0                       0.0 0 0 0 0   0       0 0   0 0                 0
451030 451030 SD     school 4636990 61008   Dakota Valley 61-8 463699000251 2 Dakota Valley Elementary School   Regular School Not applicable Elementary KG 03 2021   grade_8 0.0 0.0 0.0 0.0   0.0       0.0 0.0   0.0 0.0                       0.0 0 0 0 0   0       0 0   0 0                 0
451034 451034 SD     school 4636990 61008   Dakota Valley 61-8 463699000251 2 Dakota Valley Elementary School   Regular School Not applicable Elementary KG 03 2021   grade_9 0.0 0.0 0.0 0.0   0.0       0.0 0.0   0.0 0.0                       0.0 0 0 0 0   0       0 0   0 0                 0
451038 451038 SD     school 4636990 61008   Dakota Valley 61-8 463699000251 2 Dakota Valley Elementary School   Regular School Not applicable Elementary KG 03 2021   k_12_total 303.0 7.0 36.0 7.0   13.0       1.0 33.0   203.0 197.0       0.3               400.0 303 7 36 7   13       1 33   203 197                 400
451042 451042 SD     school 4636990 61008   Dakota Valley 61-8 463699000251 2 Dakota Valley Elementary School   Regular School Not applicable Elementary KG 03 2021   kindergarten 72.0 2.0 12.0 2.0   1.0       1.0 9.0   49.0 50.0                       99.0 72 2 12 2   1       1 9   49 50                 99
451046 451046 SD     school 4636990 61008   Dakota Valley 61-8 463699000251 2 Dakota Valley Elementary School   Regular School Not applicable Elementary KG 03 2021   pk_12_total 303.0 7.0 36.0 7.0   13.0       1.0 33.0   203.0 197.0                       400.0 303 7 36 7   13       1 33   203 197                 400
451050 451050 SD     school 4636990 61008   Dakota Valley 61-8 463699000251 2 Dakota Valley Elementary School   Regular School Not applicable Elementary KG 03 2021   pre_kindergarten 0.0 0.0 0.0 0.0   0.0       0.0 0.0   0.0 0.0                       0.0 0 0 0 0   0       0 0   0 0                 0
451392 451392 SD     school 4619410 51001   Douglas 51-1 461941001384 6 Patriot Elementary   Regular School Not applicable Elementary KG 03 2021   grade_1 135.0 5.0 20.0 11.0   4.0       0.0 32.0   100.0 107.0                       207.0 135 5 20 11   4       0 32   100 107                 207
451396 451396 SD     school 4619410 51001   Douglas 51-1 461941001384 6 Patriot Elementary   Regular School Not applicable Elementary KG 03 2021   grade_10 0.0 0.0 0.0 0.0   0.0       0.0 0.0   0.0 0.0                       0.0 0 0 0 0   0       0 0   0 0                 0
451400 451400 SD     school 4619410 51001   Douglas 51-1 461941001384 6 Patriot Elementary   Regular School Not applicable Elementary KG 03 2021   grade_11 0.0 0.0 0.0 0.0   0.0       0.0 0.0   0.0 0.0                       0.0 0 0 0 0   0       0 0   0 0                 0
451404 451404 SD     school 4619410 51001   Douglas 51-1 461941001384 6 Patriot Elementary   Regular School Not applicable Elementary KG 03 2021   grade_12 0.0 0.0 0.0 0.0   0.0       0.0 0.0   0.0 0.0                       0.0 0 0 0 0   0       0 0   0 0                 0
451408 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
451412 451412 SD     school 4619410 51001   Douglas 51-1 461941001384 6 Patriot Elementary   Regular School Not applicable Elementary KG 03 2021   grade_3 132.0 5.0 25.0 11.0   0.0       1.0 26.0   108.0 92.0                       200.0 132 5 25 11   0       1 26   108 92                 200
451416 451416 SD     school 4619410 51001   Douglas 51-1 461941001384 6 Patriot Elementary   Regular School Not applicable Elementary KG 03 2021   grade_4 0.0 0.0 0.0 0.0   0.0       0.0 0.0   0.0 0.0                       0.0 0 0 0 0   0       0 0   0 0                 0
451420 451420 SD     school 4619410 51001   Douglas 51-1 461941001384 6 Patriot Elementary   Regular School Not applicable Elementary KG 03 2021   grade_5 0.0 0.0 0.0 0.0   0.0       0.0 0.0   0.0 0.0                       0.0 0 0 0 0   0       0 0   0 0                 0
451424 451424 SD     school 4619410 51001   Douglas 51-1 461941001384 6 Patriot Elementary   Regular School Not applicable Elementary KG 03 2021   grade_6 0.0 0.0 0.0 0.0   0.0       0.0 0.0   0.0 0.0                       0.0 0 0 0 0   0       0 0   0 0                 0
451428 451428 SD     school 4619410 51001   Douglas 51-1 461941001384 6 Patriot Elementary   Regular School Not applicable Elementary KG 03 2021   grade_7 0.0 0.0 0.0 0.0   0.0       0.0 0.0   0.0 0.0                       0.0 0 0 0 0   0       0 0   0 0                 0
451432 451432 SD     school 4619410 51001   Douglas 51-1 461941001384 6 Patriot Elementary   Regular School Not applicable Elementary KG 03 2021   grade_8 0.0 0.0 0.0 0.0   0.0       0.0 0.0   0.0 0.0                       0.0 0 0 0 0   0       0 0   0 0                 0
451436 451436 SD     school 4619410 51001   Douglas 51-1 461941001384 6 Patriot Elementary   Regular School Not applicable Elementary KG 03 2021   grade_9 0.0 0.0 0.0 0.0   0.0       0.0 0.0   0.0 0.0                       0.0 0 0 0 0   0       0 0   0 0                 0
451440 451440 SD     school 4619410 51001   Douglas 51-1 461941001384 6 Patriot Elementary   Regular School Not applicable Elementary KG 03 2021   k_12_total 576.0 16.0 102.0 54.0   11.0       1.0 110.0   447.0 423.0       0.8               870.0 576 16 102 54   11       1 110   447 423                 870
451444 451444 SD     school 4619410 51001   Douglas 51-1 461941001384 6 Patriot Elementary   Regular School Not applicable Elementary KG 03 2021   kindergarten 152.0 5.0 22.0 17.0   3.0       0.0 27.0   123.0 103.0                       226.0 152 5 22 17   3       0 27   123 103                 226
451448 451448 SD     school 4619410 51001   Douglas 51-1 461941001384 6 Patriot Elementary   Regular School Not applicable Elementary KG 03 2021   pk_12_total 576.0 16.0 102.0 54.0   11.0       1.0 110.0   447.0 423.0                       870.0 576 16 102 54   11       1 110   447 423                 870
451452 451452 SD     school 4619410 51001   Douglas 51-1 461941001384 6 Patriot Elementary   Regular School Not applicable Elementary KG 03 2021   pre_kindergarten 0.0 0.0 0.0 0.0   0.0       0.0 0.0   0.0 0.0                       0.0 0 0 0 0   0       0 0   0 0                 0
453474 453474 SD     school 4635480 2002   Huron 02-2 463548001369 19 Madison 2-3 Center   Regular School Not applicable Elementary 02 03 2021   grade_1 0.0 0.0 0.0 0.0   0.0       0.0 0.0   0.0 0.0                       0.0 0 0 0 0   0       0 0   0 0                 0
453481 453481 SD     school 4635480 2002   Huron 02-2 463548001369 19 Madison 2-3 Center   Regular School Not applicable Elementary 02 03 2021   grade_10 0.0 0.0 0.0 0.0   0.0       0.0 0.0   0.0 0.0                       0.0 0 0 0 0   0       0 0   0 0                 0
453488 453488 SD     school 4635480 2002   Huron 02-2 463548001369 19 Madison 2-3 Center   Regular School Not applicable Elementary 02 03 2021   grade_11 0.0 0.0 0.0 0.0   0.0       0.0 0.0   0.0 0.0                       0.0 0 0 0 0   0       0 0   0 0                 0
453495 453495 SD     school 4635480 2002   Huron 02-2 463548001369 19 Madison 2-3 Center   Regular School Not applicable Elementary 02 03 2021   grade_12 0.0 0.0 0.0 0.0   0.0       0.0 0.0   0.0 0.0                       0.0 0 0 0 0   0       0 0   0 0                 0
453502 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
453509 453509 SD     school 4635480 2002   Huron 02-2 463548001369 19 Madison 2-3 Center   Regular School Not applicable Elementary 02 03 2021   grade_3 81.0 2.0 74.0 5.0   64.0       0.0 7.0   131.0 102.0                       233.0 81 2 74 5   64       0 7   131 102                 233
453516 453516 SD     school 4635480 2002   Huron 02-2 463548001369 19 Madison 2-3 Center   Regular School Not applicable Elementary 02 03 2021   grade_4 0.0 0.0 0.0 0.0   0.0       0.0 0.0   0.0 0.0                       0.0 0 0 0 0   0       0 0   0 0                 0
453523 453523 SD     school 4635480 2002   Huron 02-2 463548001369 19 Madison 2-3 Center   Regular School Not applicable Elementary 02 03 2021   grade_5 0.0 0.0 0.0 0.0   0.0       0.0 0.0   0.0 0.0                       0.0 0 0 0 0   0       0 0   0 0                 0
453530 453530 SD     school 4635480 2002   Huron 02-2 463548001369 19 Madison 2-3 Center   Regular School Not applicable Elementary 02 03 2021   grade_6 0.0 0.0 0.0 0.0   0.0       0.0 0.0   0.0 0.0                       0.0 0 0 0 0   0       0 0   0 0                 0
453537 453537 SD     school 4635480 2002   Huron 02-2 463548001369 19 Madison 2-3 Center   Regular School Not applicable Elementary 02 03 2021   grade_7 0.0 0.0 0.0 0.0   0.0       0.0 0.0   0.0 0.0                       0.0 0 0 0 0   0       0 0   0 0                 0
453544 453544 SD     school 4635480 2002   Huron 02-2 463548001369 19 Madison 2-3 Center   Regular School Not applicable Elementary 02 03 2021   grade_8 0.0 0.0 0.0 0.0   0.0       0.0 0.0   0.0 0.0                       0.0 0 0 0 0   0       0 0   0 0                 0
453551 453551 SD     school 4635480 2002   Huron 02-2 463548001369 19 Madison 2-3 Center   Regular School Not applicable Elementary 02 03 2021   grade_9 0.0 0.0 0.0 0.0   0.0       0.0 0.0   0.0 0.0                       0.0 0 0 0 0   0       0 0   0 0                 0
453558 453558 SD     school 4635480 2002   Huron 02-2 463548001369 19 Madison 2-3 Center   Regular School Not applicable Elementary 02 03 2021   k_12_total 163.0 2.0 137.0 14.0   119.0       2.0 14.0   247.0 204.0       43.5               451.0 163 2 137 14   119       2 14   247 204                 451
453565 453565 SD     school 4635480 2002   Huron 02-2 463548001369 19 Madison 2-3 Center   Regular School Not applicable Elementary 02 03 2021   kindergarten 0.0 0.0 0.0 0.0   0.0       0.0 0.0   0.0 0.0                       0.0 0 0 0 0   0       0 0   0 0                 0
453572 453572 SD     school 4635480 2002   Huron 02-2 463548001369 19 Madison 2-3 Center   Regular School Not applicable Elementary 02 03 2021   pk_12_total 163.0 2.0 137.0 14.0   119.0       2.0 14.0   247.0 204.0                       451.0 163 2 137 14   119       2 14   247 204                 451
453579 453579 SD     school 4635480 2002   Huron 02-2 463548001369 19 Madison 2-3 Center   Regular School Not applicable Elementary 02 03 2021   pre_kindergarten 0.0 0.0 0.0 0.0   0.0       0.0 0.0   0.0 0.0                       0.0 0 0 0 0   0       0 0   0 0                 0
449070 449070 SD     school 4600042 58003   Agar-Blunt-Onida 58-3 460004200855 3 Blunt Elementary   Regular School Not applicable Elementary PK 04 2021   grade_1 2.0   2.0 2.0             0.0   2.0 4.0                       6.0 2   2 2             0   2 4                 6
449074 449074 SD     school 4600042 58003   Agar-Blunt-Onida 58-3 460004200855 3 Blunt Elementary   Regular School Not applicable Elementary PK 04 2021   grade_10 0.0   0.0 0.0             0.0   0.0 0.0                       0.0 0   0 0             0   0 0                 0
449078 449078 SD     school 4600042 58003   Agar-Blunt-Onida 58-3 460004200855 3 Blunt Elementary   Regular School Not applicable Elementary PK 04 2021   grade_11 0.0   0.0 0.0             0.0   0.0 0.0                       0.0 0   0 0             0   0 0                 0
449082 449082 SD     school 4600042 58003   Agar-Blunt-Onida 58-3 460004200855 3 Blunt Elementary   Regular School Not applicable Elementary PK 04 2021   grade_12 0.0   0.0 0.0             0.0   0.0 0.0                       0.0 0   0 0             0   0 0                 0
449086 449086 SD     school 4600042 58003   Agar-Blunt-Onida 58-3 460004200855 3 Blunt Elementary   Regular School Not applicable Elementary PK 04 2021   grade_2 5.0   1.0 1.0             2.0   3.0 6.0                       9.0 5   1 1             2   3 6                 9
449090 449090 SD     school 4600042 58003   Agar-Blunt-Onida 58-3 460004200855 3 Blunt Elementary   Regular School Not applicable Elementary PK 04 2021   grade_3 1.0   1.0 0.0             0.0   0.0 2.0                       2.0 1   1 0             0   0 2                 2
449094 449094 SD     school 4600042 58003   Agar-Blunt-Onida 58-3 460004200855 3 Blunt Elementary   Regular School Not applicable Elementary PK 04 2021   grade_4 7.0   0.0 2.0             1.0   5.0 5.0                       10.0 7   0 2             1   5 5                 10
449098 449098 SD     school 4600042 58003   Agar-Blunt-Onida 58-3 460004200855 3 Blunt Elementary   Regular School Not applicable Elementary PK 04 2021   grade_5 0.0   0.0 0.0             0.0   0.0 0.0                       0.0 0   0 0             0   0 0                 0

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