Data source: Big Local News · About: Big Local

75,136 rows where state = "SD" sorted by asian descending

View and edit SQL

grade

year

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
254485 SD     school 4635480 2002   Huron 02-2 463548001369 19 Madison 2-3 Center   Regular School No Elementary 02 03 2018   k_12_total 190.0 4.0 126.0 7.0   92.0         13.0   245.0 187.0       41.7               432.0 190 4 126 7   92         13   245 187                 432
254499 SD     school 4635480 2002   Huron 02-2 463548001369 19 Madison 2-3 Center   Regular School No Elementary 02 03 2018   pk_12_total 190.0 4.0 126.0 7.0   92.0         13.0   245.0 187.0                       432.0 190 4 126 7   92         13   245 187                 432
258323 SD     school 4666270 49005   Sioux Falls 49-5 466627000770 20 Anne Sullivan Elementary   Regular School No Elementary PK 05 2018   k_12_total 152.0 163.0 87.0 14.0   92.0         37.0   279.0 266.0       41.8               545.0 152 163 87 14   92         37   279 266                 545
491983 SD     school 4635480 2002   Huron 02-2 463548001373 20 Washington 4-5 Center   Regular School Not applicable Elementary 04 05 2020   k_12_total 188.0 6.0 137.0 10.0   92.0       1.0 10.0   262.0 182.0       36.3               444.0 188 6 137 10   92       1 10   262 182                 444
491997 SD     school 4635480 2002   Huron 02-2 463548001373 20 Washington 4-5 Center   Regular School Not applicable Elementary 04 05 2020   pk_12_total 188.0 6.0 137.0 10.0   92.0       1.0 10.0   262.0 182.0                       444.0 188 6 137 10   92       1 10   262 182                 444
495871 SD     school 4666270 49005   Sioux Falls 49-5 466627000770 20 Anne Sullivan Elementary   Regular School Not applicable Elementary PK 05 2020   k_12_total 100.0 181.0 83.0 26.0   92.0         37.0   265.0 254.0       47.2               519.0 100 181 83 26   92         37   265 254                 519
365586 SD     school 4666270 49005   Sioux Falls 49-5 466627000770 20 Anne Sullivan Elementary   Regular School No Elementary PK 05 2019   k_12_total 125.0 171.0 89.0 27.0   90.0       1.0 37.0   275.0 265.0       45.2               540.0 125 171 89 27   90       1 37   275 265                 540
2961628 SD     school 4602070 6001   Aberdeen 06-1 460207000003 1 Central High School   Regular School No 3 09 12 2015   grade_11 235.0 6.0 10.0 18.0   9.0         4.0   143.0 139.0                       282.0 235 6 10 18   9         4   143 139                 282
2961718 SD     school 4602070 6001   Aberdeen 06-1 460207000003 1 Central High School   Regular School No 3 09 12 2015   grade_9 286.0 5.0 6.0 21.0   9.0         3.0   162.0 168.0                       330.0 286 5 6 21   9         3   162 168                 330
2961731 SD     school 4602070 6001   Aberdeen 06-1 460207000008 9 May Overby Elementary   Regular School No 1 KG 05 2015   k_12_total 334.0 17.0 15.0 20.0   9.0       6.0 28.0   209.0 220.0                       429.0 334 17 15 20   9       6 28   209 220                 429
2961751 SD     school 4602070 6001   Aberdeen 06-1 460207000008 9 May Overby Elementary   Regular School No 1 KG 05 2015   pk_12_total 334.0 17.0 15.0 20.0   9.0       6.0 28.0   209.0 220.0                       429.0 334 17 15 20   9       6 28   209 220                 429
2962810 SD     school 4608520 5001   Brookings 05-1 460852000086 5 Medary Elem   Regular School No 1 KG 03 2015   grade_1 140.0 4.0 7.0 5.0   9.0         7.0   86.0 86.0                       172.0 140 4 7 5   9         7   86 86                 172
2962837 SD     school 4608520 5001   Brookings 05-1 460852001298 6 Camelot Intermediate School   Regular School No 1 03 05 2015   grade_4 216.0 10.0 9.0 7.0   9.0       1.0 12.0   129.0 135.0                       264.0 216 10 9 7   9       1 12   129 135                 264
2962842 SD     school 4608520 5001   Brookings 05-1 460852001298 6 Camelot Intermediate School   Regular School No 1 03 05 2015   grade_5 207.0 0.0 9.0 11.0   9.0       0.0 9.0   129.0 116.0                       245.0 207 0 9 11   9       0 9   129 116                 245
2965706 SD     school 4631350 41002   Harrisburg 41-2 463135001334 8 Harrisburg North MS   Regular School No 2 06 08 2015   k_12_total 397.0 6.0 10.0 3.0   9.0         9.0   217.0 217.0                       434.0 397 6 10 3   9         9   217 217                 434
2965722 SD     school 4631350 41002   Harrisburg 41-2 463135001334 8 Harrisburg North MS   Regular School No 2 06 08 2015   pk_12_total 397.0 6.0 10.0 3.0   9.0         9.0   217.0 217.0                       434.0 397 6 10 3   9         9   217 217                 434
2968689 SD     school 4659820 51004   Rapid City Area 51-4 465982000529 41 Central Hi Sch   Regular School No 3 09 12 2015   grade_10 338.0 6.0 25.0 93.0   9.0         23.0   250.0 244.0                       494.0 338 6 25 93   9         23   250 244                 494
2968975 SD     school 4659820 51004   Rapid City Area 51-4 465982000547 11 Pinedale Elem   Regular School No 1 KG 05 2015   k_12_total 354.0 4.0 26.0 15.0   9.0         17.0   251.0 174.0       0.5               425.0 354 4 26 15   9         17   251 174                 425
2969025 SD     school 4659820 51004   Rapid City Area 51-4 465982000547 11 Pinedale Elem   Regular School No 1 KG 05 2015   pk_12_total 354.0 4.0 26.0 15.0   9.0         17.0   251.0 174.0                       425.0 354 4 26 15   9         17   251 174                 425
2969511 SD     school 4666270 49005   Sioux Falls 49-5 466627000770 20 Anne Sullivan Elementary   Regular School No 1 PK 05 2015   grade_1 40.0 21.0 12.0 2.0   9.0         7.0   48.0 43.0                       91.0 40 21 12 2   9         7   48 43                 91
2969942 SD     school 4666270 49005   Sioux Falls 49-5 466627001170 53 MS Immersion Center   Regular School No 2 06 08 2015   grade_7 1.0 9.0 1.0     9.0             7.0 13.0                       20.0 1 9 1     9             7 13                 20
2969992 SD     school 4666270 49005   Sioux Falls 49-5 466627000604 7 Patrick Henry Middle School   Regular School No 2 06 08 2015   grade_8 338.0 31.0 12.0 10.0   9.0         6.0   220.0 186.0                       406.0 338 31 12 10   9         6   220 186                 406
2970096 SD     school 4666270 49005   Sioux Falls 49-5 466627000770 20 Anne Sullivan Elementary   Regular School No 1 PK 05 2015   kindergarten 36.0 25.0 16.0 4.0   9.0         11.0   48.0 53.0                       101.0 36 25 16 4   9         11   48 53                 101
2970120 SD     school 4666270 49005   Sioux Falls 49-5 466627000601 27 Longfellow Elementary   Regular School No 1 KG 05 2015   kindergarten 11.0 20.0 21.0 3.0   9.0         9.0   40.0 33.0                       73.0 11 20 21 3   9         9   40 33                 73
2970201 SD     school 4666270 49005   Sioux Falls 49-5 466627000936 56 Hawthorne Elementary   Regular School No 1 PK 05 2015   pre_kindergarten 45.0 21.0 11.0 12.0   9.0       1.0 12.0   65.0 46.0                       111.0 45 21 11 12   9       1 12   65 46                 111
2970539 SD     school 4666930 40002   Spearfish 40-2 466693000623 1 Spearfish High School   Regular School No 3 09 12 2015   k_12_total 502.0 7.0 30.0 14.0   9.0         9.0   298.0 273.0                       571.0 502 7 30 14   9         9   298 273                 571
2970540 SD     school 4666930 40002   Spearfish 40-2 466693000622 5 Spearfish MS   Regular School No 2 06 08 2015   k_12_total 418.0 2.0 19.0 19.0   9.0         13.0   248.0 232.0                       480.0 418 2 19 19   9         13   248 232                 480
2970555 SD     school 4666930 40002   Spearfish 40-2 466693000623 1 Spearfish High School   Regular School No 3 09 12 2015   pk_12_total 502.0 7.0 30.0 14.0   9.0         9.0   298.0 273.0                       571.0 502 7 30 14   9         9   298 273                 571
2970556 SD     school 4666930 40002   Spearfish 40-2 466693000622 5 Spearfish MS   Regular School No 2 06 08 2015   pk_12_total 418.0 2.0 19.0 19.0   9.0         13.0   248.0 232.0                       480.0 418 2 19 19   9         13   248 232                 480
2972306 SD     school 4680430 63003   Yankton 63-3 468043000798 1 Yankton Hi Sch   Regular School No 3 09 12 2015   k_12_total 772.0 17.0 45.0 25.0   9.0         7.0   457.0 418.0                       875.0 772 17 45 25   9         7   457 418                 875
2972318 SD     school 4680430 63003   Yankton 63-3 468043000798 1 Yankton Hi Sch   Regular School No 3 09 12 2015   pk_12_total 772.0 17.0 45.0 25.0   9.0         7.0   457.0 418.0                       875.0 772 17 45 25   9         7   457 418                 875
3344184 SD     school 4602070 6001   Aberdeen 06-1 460207000003 1 Central High School   Regular School No 3 09 12 2016   grade_10 294.0 8.0 6.0 20.0   9.0       1.0 4.0   177.0 165.0                       342.0 294 8 6 20   9       1 4   177 165                 342
3344285 SD     school 4602070 6001   Aberdeen 06-1 460207000007 8 Lincoln Elementary   Regular School No 1 PK 05 2016   k_12_total 341.0 4.0 21.0 36.0   9.0         10.0   225.0 196.0                       421.0 341 4 21 36   9         10   225 196                 421
3344303 SD     school 4602070 6001   Aberdeen 06-1 460207000007 8 Lincoln Elementary   Regular School No 1 PK 05 2016   pk_12_total 371.0 4.0 21.0 36.0   9.0         10.0   234.0 217.0                       451.0 371 4 21 36   9         10   234 217                 451
3345220 SD     school 4607950 49002   Brandon Valley 49-2 460795001355 7 Brandon Valley Intermediate   Regular School No 2 05 06 2016   k_12_total 564.0 23.0 16.0     9.0       2.0 10.0   329.0 295.0       0.9               624.0 564 23 16     9       2 10   329 295                 624
3345234 SD     school 4607950 49002   Brandon Valley 49-2 460795001355 7 Brandon Valley Intermediate   Regular School No 2 05 06 2016   pk_12_total 564.0 23.0 16.0     9.0       2.0 10.0   329.0 295.0                       624.0 564 23 16     9       2 10   329 295                 624
3345412 SD     school 4608520 5001   Brookings 05-1 460852000082 1 Brookings Hi Sch   Regular School No 3 09 12 2016   grade_10 208.0 5.0 7.0 3.0   9.0       0.0 1.0   105.0 128.0                       233.0 208 5 7 3   9       0 1   105 128                 233
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
3346679 SD     school 4619410 51001   Douglas 51-1 461941000174 3 Douglas High School   Regular School No 3 09 12 2016   k_12_total 509.0 23.0 40.0 56.0   9.0       2.0 68.0   391.0 316.0       0.1               707.0 509 23 40 56   9       2 68   391 316                 707
3346691 SD     school 4619410 51001   Douglas 51-1 461941000174 3 Douglas High School   Regular School No 3 09 12 2016   pk_12_total 509.0 23.0 40.0 56.0   9.0       2.0 68.0   391.0 316.0                       707.0 509 23 40 56   9       2 68   391 316                 707
3348289 SD     school 4631350 41002   Harrisburg 41-2 463135000264 1 Harrisburg High School   Regular School No 3 09 12 2016   k_12_total 739.0 12.0 17.0 10.0   9.0         16.0   431.0 372.0       0.7               803.0 739 12 17 10   9         16   431 372                 803
3348305 SD     school 4631350 41002   Harrisburg 41-2 463135000264 1 Harrisburg High School   Regular School No 3 09 12 2016   pk_12_total 739.0 12.0 17.0 10.0   9.0         16.0   431.0 372.0                       803.0 739 12 17 10   9         16   431 372                 803
3351385 SD     school 4659820 51004   Rapid City Area 51-4 465982000529 41 Central Hi Sch   Regular School No 3 09 12 2016   grade_10 312.0 7.0 33.0 102.0   9.0         18.0   261.0 220.0                       481.0 312 7 33 102   9         18   261 220                 481
3351662 SD     school 4659820 51004   Rapid City Area 51-4 465982000528 30 East Middle Sch   Regular School No 2 06 08 2016   k_12_total 477.0 8.0 38.0 88.0   9.0         28.0   325.0 323.0       1.1               648.0 477 8 38 88   9         28   325 323                 648
3351712 SD     school 4659820 51004   Rapid City Area 51-4 465982000528 30 East Middle Sch   Regular School No 2 06 08 2016   pk_12_total 477.0 8.0 38.0 88.0   9.0         28.0   325.0 323.0                       648.0 477 8 38 88   9         28   325 323                 648
3352549 SD     school 4666270 49005   Sioux Falls 49-5 466627000583 6 Edison Middle School   Regular School No 2 06 08 2016   grade_8 207.0 23.0 18.0 18.0   9.0         7.0   152.0 130.0                       282.0 207 23 18 18   9         7   152 130                 282
3352566 SD     school 4666270 49005   Sioux Falls 49-5 466627001070 4 Memorial Middle School   Regular School No 2 06 08 2016   grade_8 364.0 11.0 14.0 7.0   9.0         6.0   200.0 211.0                       411.0 364 11 14 7   9         6   200 211                 411
3352641 SD     school 4666270 49005   Sioux Falls 49-5 466627000588 54 Harvey Dunn Elementary   Regular School No 1 PK 05 2016   k_12_total 488.0 29.0 20.0 8.0   9.0         34.0   291.0 297.0       1.4               588.0 488 29 20 8   9         34   291 297                 588
3352645 SD     school 4666270 49005   Sioux Falls 49-5 466627000976 57 John F Kennedy Elementary   Regular School No 1 KG 05 2016   k_12_total 542.0 27.0 21.0 9.0   9.0         53.0   310.0 351.0       0.3               661.0 542 27 21 9   9         53   310 351                 661
3352647 SD     school 4666270 49005   Sioux Falls 49-5 466627000597 10 Laura B. Anderson Elementary   Regular School No 1 PK 05 2016   k_12_total 126.0 64.0 107.0 23.0   9.0         25.0   165.0 189.0       22.3               354.0 126 64 107 23   9         25   165 189                 354
3352648 SD     school 4666270 49005   Sioux Falls 49-5 466627000598 31 Laura Wilder Elementary   Regular School No 1 KG 05 2016   k_12_total 346.0 49.0 55.0 27.0   9.0       1.0 39.0   256.0 270.0       2.2               526.0 346 49 55 27   9       1 39   256 270                 526
3352731 SD     school 4666270 49005   Sioux Falls 49-5 466627000976 57 John F Kennedy Elementary   Regular School No 1 KG 05 2016   pk_12_total 542.0 27.0 21.0 9.0   9.0         53.0   310.0 351.0                       661.0 542 27 21 9   9         53   310 351                 661
3352734 SD     school 4666270 49005   Sioux Falls 49-5 466627000598 31 Laura Wilder Elementary   Regular School No 1 KG 05 2016   pk_12_total 346.0 49.0 55.0 27.0   9.0       1.0 39.0   256.0 270.0                       526.0 346 49 55 27   9       1 39   256 270                 526
3354810 SD     school 4680430 63003   Yankton 63-3 468043000798 1 Yankton Hi Sch   Regular School No 3 09 12 2016   k_12_total 783.0 18.0 48.0 23.0   9.0         8.0   475.0 414.0       1.4               889.0 783 18 48 23   9         8   475 414                 889
3354822 SD     school 4680430 63003   Yankton 63-3 468043000798 1 Yankton Hi Sch   Regular School No 3 09 12 2016   pk_12_total 783.0 18.0 48.0 23.0   9.0         8.0   475.0 414.0                       889.0 783 18 48 23   9         8   475 414                 889
3006261 SD     school 4602070 6001   Aberdeen 06-1 460207000003 1 Central High School   Regular School No High 09 12 2017   grade_12 259.0 12.0 6.0 25.0   9.0       0.0 4.0   179.0 136.0                       315.0 259 12 6 25   9       0 4   179 136                 315
3006350 SD     school 4602070 6001   Aberdeen 06-1 460207000002 5 C.C. Lee Elementary   Regular School No Elementary KG 05 2017   k_12_total 346.0 11.0 11.0 10.0   9.0         23.0   226.0 184.0       2.7               410.0 346 11 11 10   9         23   226 184                 410
3006370 SD     school 4602070 6001   Aberdeen 06-1 460207000002 5 C.C. Lee Elementary   Regular School No Elementary KG 05 2017   pk_12_total 346.0 11.0 11.0 10.0   9.0         23.0   226.0 184.0                       410.0 346 11 11 10   9         23   226 184                 410
3007468 SD     school 4608520 5001   Brookings 05-1 460852000082 1 Brookings Hi Sch   Regular School No High 09 12 2017   grade_10 187.0 5.0 12.0 2.0   9.0       0.0 7.0   112.0 110.0                       222.0 187 5 12 2   9       0 7   112 110                 222
3011538 SD     school 4641300 40001   Lead-Deadwood 40-1 464130001145 10 Lead-Deadwood Career & Tech Ed   Alternative School No High 09 12 2017   grade_9 7.0 13.0 1.0 12.0   9.0       1.0 0.0   27.0 16.0                       43.0 7 13 1 12   9       1 0   27 16                 43
3012542 SD     school 4648390 17002   Mitchell 17-2 464839000437 2 Mitchell Middle School   Regular School No Middle 06 08 2017   k_12_total 528.0 6.0 19.0 28.0   9.0       3.0 8.0   313.0 288.0       1.2               601.0 528 6 19 28   9       3 8   313 288                 601
3012556 SD     school 4648390 17002   Mitchell 17-2 464839000437 2 Mitchell Middle School   Regular School No Middle 06 08 2017   pk_12_total 528.0 6.0 19.0 28.0   9.0       3.0 8.0   313.0 288.0                       601.0 528 6 19 28   9       3 8   313 288                 601
3013790 SD     school 4659820 51004   Rapid City Area 51-4 465982000525 42 Stevens Hi Sch   Regular School No High 09 12 2017   grade_9 385.0 2.0 27.0 36.0   9.0         10.0   232.0 237.0                       469.0 385 2 27 36   9         10   232 237                 469
3014502 SD     school 4666270 49005   Sioux Falls 49-5 466627000581 14 Cleveland Elementary   Regular School No Elementary PK 05 2017   grade_4 25.0 17.0 9.0 1.0   9.0       2.0 3.0   36.0 30.0                       66.0 25 17 9 1   9       2 3   36 30                 66
3014541 SD     school 4666270 49005   Sioux Falls 49-5 466627000770 20 Anne Sullivan Elementary   Regular School No Elementary PK 05 2017   grade_5 40.0 29.0 15.0 8.0   9.0         3.0   47.0 57.0                       104.0 40 29 15 8   9         3   47 57                 104
3014571 SD     school 4666270 49005   Sioux Falls 49-5 466627001275 15 Rosa Parks Elementary   Regular School No Elementary KG 05 2017   grade_5 61.0 22.0 7.0 1.0   9.0         2.0   49.0 53.0                       102.0 61 22 7 1   9         2   49 53                 102
3014636 SD     school 4666270 49005   Sioux Falls 49-5 466627001333 9 George McGovern Middle School   Regular School No Middle 06 08 2017   grade_7 94.0 53.0 56.0 38.0   9.0       0.0 14.0   130.0 134.0                       264.0 94 53 56 38   9       0 14   130 134                 264
3014650 SD     school 4666270 49005   Sioux Falls 49-5 466627000604 7 Patrick Henry Middle School   Regular School No Middle 06 08 2017   grade_7 302.0 27.0 17.0 12.0   9.0         10.0   197.0 180.0                       377.0 302 27 17 12   9         10   197 180                 377
3014772 SD     school 4666270 49005   Sioux Falls 49-5 466627001170 53 MS Immersion Center   Regular School No Middle 06 08 2017   k_12_total   34.0 21.0     9.0             38.0 26.0       100.0               64.0   34 21     9             38 26                 64
3014856 SD     school 4666270 49005   Sioux Falls 49-5 466627001170 53 MS Immersion Center   Regular School No Middle 06 08 2017   pk_12_total   34.0 21.0     9.0             38.0 26.0                       64.0   34 21     9             38 26                 64
3015198 SD     school 4666930 40002   Spearfish 40-2 466693000623 1 Spearfish High School   Regular School No High 09 12 2017   k_12_total 537.0 2.0 32.0 24.0   9.0         7.0   329.0 282.0       0.2               611.0 537 2 32 24   9         7   329 282                 611
3015212 SD     school 4666930 40002   Spearfish 40-2 466693000623 1 Spearfish High School   Regular School No High 09 12 2017   pk_12_total 537.0 2.0 32.0 24.0   9.0         7.0   329.0 282.0                       611.0 537 2 32 24   9         7   329 282                 611
3016139 SD     school 4676620 14004   Watertown 14-4 467662000717 1 Watertown High School   Regular School No High 09 12 2017   k_12_total 1114.0 9.0 45.0 37.0   9.0         18.0   644.0 588.0       0.7               1232.0 1114 9 45 37   9         18   644 588                 1232
3016155 SD     school 4676620 14004   Watertown 14-4 467662000717 1 Watertown High School   Regular School No High 09 12 2017   pk_12_total 1114.0 9.0 45.0 37.0   9.0         18.0   644.0 588.0                       1232.0 1114 9 45 37   9         18   644 588                 1232
250884 SD     school 4607950 49002   Brandon Valley 49-2 460795000072 2 Brandon Valley Middle Sch   Regular School No Middle 07 08 2018   k_12_total 572.0 20.0 14.0 4.0   9.0       2.0 11.0   334.0 298.0       0.3               632.0 572 20 14 4   9       2 11   334 298                 632
250898 SD     school 4607950 49002   Brandon Valley 49-2 460795000072 2 Brandon Valley Middle Sch   Regular School No Middle 07 08 2018   pk_12_total 572.0 20.0 14.0 4.0   9.0       2.0 11.0   334.0 298.0                       632.0 572 20 14 4   9       2 11   334 298                 632
251065 SD     school 4608520 5001   Brookings 05-1 460852000082 1 Brookings Hi Sch   Regular School No High 09 12 2018   grade_11 179.0 3.0 12.0 4.0   9.0       0.0 6.0   108.0 105.0                       213.0 179 3 12 4   9       0 6   108 105                 213
256117 SD     school 4648390 17002   Mitchell 17-2 464839000437 2 Mitchell Middle School   Regular School No Middle 06 08 2018   k_12_total 549.0 5.0 22.0 34.0   9.0       4.0 15.0   343.0 295.0       1.1               638.0 549 5 22 34   9       4 15   343 295                 638
256131 SD     school 4648390 17002   Mitchell 17-2 464839000437 2 Mitchell Middle School   Regular School No Middle 06 08 2018   pk_12_total 549.0 5.0 22.0 34.0   9.0       4.0 15.0   343.0 295.0                       638.0 549 5 22 34   9       4 15   343 295                 638
257099 SD     school 4659820 51004   Rapid City Area 51-4 465982000525 42 Stevens Hi Sch   Regular School No High 09 12 2018   grade_10 374.0 2.0 23.0 20.0   9.0       1.0 9.0   215.0 223.0                       438.0 374 2 23 20   9       1 9   215 223                 438
257811 SD     school 4666270 49005   Sioux Falls 49-5 466627000581 14 Cleveland Elementary   Regular School No Elementary PK 05 2018   grade_1 28.0 25.0 17.0 3.0   9.0       0.0 5.0   38.0 49.0                       87.0 28 25 17 3   9       0 5   38 49                 87
258174 SD     school 4666270 49005   Sioux Falls 49-5 466627001070 4 Memorial Middle School   Regular School No Middle 06 08 2018   grade_6 370.0 25.0 21.0 8.0   9.0         29.0   223.0 239.0                       462.0 370 25 21 8   9         29   223 239                 462
258201 SD     school 4666270 49005   Sioux Falls 49-5 466627000583 6 Edison Middle School   Regular School No Middle 06 08 2018   grade_7 244.0 25.0 38.0 16.0   9.0       2.0 15.0   178.0 171.0                       349.0 244 25 38 16   9       2 15   178 171                 349
258345 SD     school 4666270 49005   Sioux Falls 49-5 466627001170 53 MS Immersion Center   Regular School No Middle 06 08 2018   k_12_total   40.0 27.0     9.0             36.0 40.0       100.0               76.0   40 27     9             36 40                 76
258431 SD     school 4666270 49005   Sioux Falls 49-5 466627001170 53 MS Immersion Center   Regular School No Middle 06 08 2018   pk_12_total   40.0 27.0     9.0             36.0 40.0                       76.0   40 27     9             36 40                 76
260521 SD     school 4680430 63003   Yankton 63-3 468043000798 1 Yankton Hi Sch   Regular School No High 09 12 2018   k_12_total 745.0 10.0 60.0 38.0   9.0         5.0   453.0 414.0       1.6               867.0 745 10 60 38   9         5   453 414                 867
260533 SD     school 4680430 63003   Yankton 63-3 468043000798 1 Yankton Hi Sch   Regular School No High 09 12 2018   pk_12_total 745.0 10.0 60.0 38.0   9.0         5.0   453.0 414.0                       867.0 745 10 60 38   9         5   453 414                 867
357059 SD     school 4602070 6001   Aberdeen 06-1 460207000003 1 Central High School   Regular School No High 09 12 2019   grade_10 294.0 4.0 14.0 24.0   9.0       0.0 5.0   172.0 178.0                       350.0 294 4 14 24   9       0 5   172 178                 350
357176 SD     school 4602070 6001   Aberdeen 06-1 460207000010 10 Simmons Elementary   Regular School No Elementary KG 05 2019   k_12_total 302.0 7.0 19.0 24.0   9.0       2.0 22.0   194.0 191.0       4.2               385.0 302 7 19 24   9       2 22   194 191                 385
357196 SD     school 4602070 6001   Aberdeen 06-1 460207000010 10 Simmons Elementary   Regular School No Elementary KG 05 2019   pk_12_total 302.0 7.0 19.0 24.0   9.0       2.0 22.0   194.0 191.0                       385.0 302 7 19 24   9       2 22   194 191                 385
358114 SD     school 4607950 49002   Brandon Valley 49-2 460795001355 7 Brandon Valley Intermediate   Regular School No Middle 05 06 2019   grade_6 295.0 15.0 9.0 5.0   9.0       0.0 13.0   175.0 171.0                       346.0 295 15 9 5   9       0 13   175 171                 346
358143 SD     school 4607950 49002   Brandon Valley 49-2 460795000072 2 Brandon Valley Middle Sch   Regular School No Middle 07 08 2019   k_12_total 609.0 21.0 23.0 2.0   9.0         18.0   349.0 333.0       1.3               682.0 609 21 23 2   9         18   349 333                 682
358157 SD     school 4607950 49002   Brandon Valley 49-2 460795000072 2 Brandon Valley Middle Sch   Regular School No Middle 07 08 2019   pk_12_total 609.0 21.0 23.0 2.0   9.0         18.0   349.0 333.0                       682.0 609 21 23 2   9         18   349 333                 682
358330 SD     school 4608520 5001   Brookings 05-1 460852000082 1 Brookings Hi Sch   Regular School No High 09 12 2019   grade_12 165.0 5.0 10.0 2.0   9.0       0.0 5.0   99.0 97.0                       196.0 165 5 10 2   9       0 5   99 97                 196
358349 SD     school 4608520 5001   Brookings 05-1 460852001298 6 Camelot Intermediate School   Regular School No Elementary 04 05 2019   grade_4 194.0 6.0 13.0 5.0   9.0       0.0 12.0   108.0 131.0                       239.0 194 6 13 5   9       0 12   108 131                 239
359194 SD     school 4636990 61008   Dakota Valley 61-8 463699000809 3 Dakota Valley Middle School   Regular School No Middle 06 08 2019   k_12_total 274.0 7.0 22.0 7.0   9.0         12.0   165.0 166.0       1.2               331.0 274 7 22 7   9         12   165 166                 331
359202 SD     school 4636990 61008   Dakota Valley 61-8 463699000809 3 Dakota Valley Middle School   Regular School No Middle 06 08 2019   pk_12_total 274.0 7.0 22.0 7.0   9.0         12.0   165.0 166.0                       331.0 274 7 22 7   9         12   165 166                 331
359605 SD     school 4619410 51001   Douglas 51-1 461941000176 1 Douglas Middle School   Regular School No Middle 06 08 2019   k_12_total 508.0 26.0 60.0 50.0   9.0       5.0 53.0   344.0 367.0       0.0               711.0 508 26 60 50   9       5 53   344 367                 711
359615 SD     school 4619410 51001   Douglas 51-1 461941000176 1 Douglas Middle School   Regular School No Middle 06 08 2019   pk_12_total 508.0 26.0 60.0 50.0   9.0       5.0 53.0   344.0 367.0                       711.0 508 26 60 50   9       5 53   344 367                 711
365514 SD     school 4666270 49005   Sioux Falls 49-5 466627001333 9 George McGovern Middle School   Regular School No Middle 06 08 2019   grade_8 112.0 48.0 67.0 30.0   9.0       0.0 16.0   155.0 127.0                       282.0 112 48 67 30   9       0 16   155 127                 282

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