Data source: Big Local News · About: Big Local

75,136 rows where state = "SD" sorted by pacific_islander 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
3006351 SD     school 4602070 6001   Aberdeen 06-1 460207000003 1 Central High School   Regular School No High 09 12 2017   k_12_total 1044.0 40.0 40.0 87.0   34.0       7.0 11.0   652.0 611.0       2.5               1263.0 1044 40 40 87   34       7 11   652 611                 1263
3006371 SD     school 4602070 6001   Aberdeen 06-1 460207000003 1 Central High School   Regular School No High 09 12 2017   pk_12_total 1044.0 40.0 40.0 87.0   34.0       7.0 11.0   652.0 611.0                       1263.0 1044 40 40 87   34       7 11   652 611                 1263
491979 SD     school 4635480 2002   Huron 02-2 463548000313 1 Huron High School   Regular School Not applicable High 09 12 2020   k_12_total 369.0 15.0 188.0 7.0   144.0       7.0 7.0   387.0 350.0       24.7               737.0 369 15 188 7   144       7 7   387 350                 737
491993 SD     school 4635480 2002   Huron 02-2 463548000313 1 Huron High School   Regular School Not applicable High 09 12 2020   pk_12_total 369.0 15.0 188.0 7.0   144.0       7.0 7.0   387.0 350.0                       737.0 369 15 188 7   144       7 7   387 350                 737
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
3344283 SD     school 4602070 6001   Aberdeen 06-1 460207000003 1 Central High School   Regular School No 3 09 12 2016   k_12_total 1091.0 31.0 27.0 98.0   36.0       6.0 16.0   685.0 620.0                       1305.0 1091 31 27 98   36       6 16   685 620                 1305
3344301 SD     school 4602070 6001   Aberdeen 06-1 460207000003 1 Central High School   Regular School No 3 09 12 2016   pk_12_total 1091.0 31.0 27.0 98.0   36.0       6.0 16.0   685.0 620.0                       1305.0 1091 31 27 98   36       6 16   685 620                 1305
3345219 SD     school 4607950 49002   Brandon Valley 49-2 460795000071 1 Brandon Valley Hi Sch   Regular School No 3 09 12 2016   k_12_total 948.0 28.0 17.0 2.0   17.0       6.0 6.0   505.0 519.0       0.7               1024.0 948 28 17 2   17       6 6   505 519                 1024
3345233 SD     school 4607950 49002   Brandon Valley 49-2 460795000071 1 Brandon Valley Hi Sch   Regular School No 3 09 12 2016   pk_12_total 948.0 28.0 17.0 2.0   17.0       6.0 6.0   505.0 519.0                       1024.0 948 28 17 2   17       6 6   505 519                 1024
489873 SD     school 4619410 51001   Douglas 51-1 461941000174 3 Douglas High School   Regular School Not applicable High 09 12 2020   k_12_total 570.0 16.0 61.0 53.0   12.0       6.0 66.0   414.0 370.0       0.6               784.0 570 16 61 53   12       6 66   414 370                 784
489883 SD     school 4619410 51001   Douglas 51-1 461941000174 3 Douglas High School   Regular School Not applicable High 09 12 2020   pk_12_total 570.0 16.0 61.0 53.0   12.0       6.0 66.0   414.0 370.0                       784.0 570 16 61 53   12       6 66   414 370                 784
453556 SD     school 4635480 2002   Huron 02-2 463548000313 1 Huron High School   Regular School Not applicable High 09 12 2021   k_12_total 365.0 10.0 188.0 9.0   150.0       6.0 12.0   385.0 355.0       21.6               740.0 365 10 188 9   150       6 12   385 355                 740
453570 SD     school 4635480 2002   Huron 02-2 463548000313 1 Huron High School   Regular School Not applicable High 09 12 2021   pk_12_total 365.0 10.0 188.0 9.0   150.0       6.0 12.0   385.0 355.0                       740.0 365 10 188 9   150       6 12   385 355                 740
455711 SD     school 4665460 65001   Oglala Lakota 65-1 466546000575 4 Red Shirt School   Regular School Not applicable Elementary PK 08 2021   kindergarten     0.0 1.0           6.0 0.0   2.0 5.0                       7.0     0 1           6 0   2 5                 7
2961735 SD     school 4602070 6001   Aberdeen 06-1 460207000011 3 Simmons Middle School   Regular School No 2 06 08 2015   k_12_total 405.0 14.0 12.0 40.0   10.0       5.0 2.0   233.0 255.0                       488.0 405 14 12 40   10       5 2   233 255                 488
2961755 SD     school 4602070 6001   Aberdeen 06-1 460207000011 3 Simmons Middle School   Regular School No 2 06 08 2015   pk_12_total 405.0 14.0 12.0 40.0   10.0       5.0 2.0   233.0 255.0                       488.0 405 14 12 40   10       5 2   233 255                 488
2962639 SD     school 4607950 49002   Brandon Valley 49-2 460795000071 1 Brandon Valley Hi Sch   Regular School No 3 09 12 2015   k_12_total 926.0 23.0 15.0 3.0   14.0       5.0 5.0   491.0 500.0                       991.0 926 23 15 3   14       5 5   491 500                 991
2962651 SD     school 4607950 49002   Brandon Valley 49-2 460795000071 1 Brandon Valley Hi Sch   Regular School No 3 09 12 2015   pk_12_total 926.0 23.0 15.0 3.0   14.0       5.0 5.0   491.0 500.0                       991.0 926 23 15 3   14       5 5   491 500                 991
249926 SD     school 4602070 6001   Aberdeen 06-1 460207000003 1 Central High School   Regular School No High 09 12 2018   k_12_total 1087.0 39.0 58.0 98.0   44.0       5.0 13.0   674.0 670.0       3.4               1344.0 1087 39 58 98   44       5 13   674 670                 1344
249946 SD     school 4602070 6001   Aberdeen 06-1 460207000003 1 Central High School   Regular School No High 09 12 2018   pk_12_total 1087.0 39.0 58.0 98.0   44.0       5.0 13.0   674.0 670.0                       1344.0 1087 39 58 98   44       5 13   674 670                 1344
252346 SD     school 4619410 51001   Douglas 51-1 461941000176 1 Douglas Middle School   Regular School No Middle 06 08 2018   k_12_total 495.0 20.0 62.0 67.0   10.0       5.0 50.0   371.0 338.0       0.1               709.0 495 20 62 67   10       5 50   371 338                 709
252356 SD     school 4619410 51001   Douglas 51-1 461941000176 1 Douglas Middle School   Regular School No Middle 06 08 2018   pk_12_total 495.0 20.0 62.0 67.0   10.0       5.0 50.0   371.0 338.0                       709.0 495 20 62 67   10       5 50   371 338                 709
258330 SD     school 4666270 49005   Sioux Falls 49-5 466627000583 6 Edison Middle School   Regular School No Middle 06 08 2018   k_12_total 749.0 80.0 93.0 51.0   25.0       5.0 44.0   540.0 507.0       2.5               1047.0 749 80 93 51   25       5 44   540 507                 1047
258416 SD     school 4666270 49005   Sioux Falls 49-5 466627000583 6 Edison Middle School   Regular School No Middle 06 08 2018   pk_12_total 749.0 80.0 93.0 51.0   25.0       5.0 44.0   540.0 507.0                       1047.0 749 80 93 51   25       5 44   540 507                 1047
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
361710 SD     school 4635480 2002   Huron 02-2 463548000313 1 Huron High School   Regular School No High 09 12 2019   k_12_total 375.0 13.0 152.0 8.0   152.0       5.0 2.0   365.0 342.0       24.6               707.0 375 13 152 8   152       5 2   365 342                 707
361711 SD     school 4635480 2002   Huron 02-2 463548000314 2 Huron Middle School   Regular School No Middle 06 08 2019   k_12_total 280.0 13.0 125.0 9.0   109.0       5.0 10.0   292.0 259.0       17.2               551.0 280 13 125 9   109       5 10   292 259                 551
361724 SD     school 4635480 2002   Huron 02-2 463548000313 1 Huron High School   Regular School No High 09 12 2019   pk_12_total 375.0 13.0 152.0 8.0   152.0       5.0 2.0   365.0 342.0                       707.0 375 13 152 8   152       5 2   365 342                 707
361725 SD     school 4635480 2002   Huron 02-2 463548000314 2 Huron Middle School   Regular School No Middle 06 08 2019   pk_12_total 280.0 13.0 125.0 9.0   109.0       5.0 10.0   292.0 259.0                       551.0 280 13 125 9   109       5 10   292 259                 551
365593 SD     school 4666270 49005   Sioux Falls 49-5 466627000583 6 Edison Middle School   Regular School No Middle 06 08 2019   k_12_total 752.0 90.0 121.0 42.0   17.0       5.0 51.0   558.0 520.0       2.5               1078.0 752 90 121 42   17       5 51   558 520                 1078
365677 SD     school 4666270 49005   Sioux Falls 49-5 466627000583 6 Edison Middle School   Regular School No Middle 06 08 2019   pk_12_total 752.0 90.0 121.0 42.0   17.0       5.0 51.0   558.0 520.0                       1078.0 752 90 121 42   17       5 51   558 520                 1078
489874 SD     school 4619410 51001   Douglas 51-1 461941000176 1 Douglas Middle School   Regular School Not applicable Middle 06 08 2020   k_12_total 478.0 14.0 54.0 42.0   7.0       5.0 51.0   333.0 318.0       0.0               651.0 478 14 54 42   7       5 51   333 318                 651
489884 SD     school 4619410 51001   Douglas 51-1 461941000176 1 Douglas Middle School   Regular School Not applicable Middle 06 08 2020   pk_12_total 478.0 14.0 54.0 42.0   7.0       5.0 51.0   333.0 318.0                       651.0 478 14 54 42   7       5 51   333 318                 651
491972 SD     school 4635480 2002   Huron 02-2 463548000313 1 Huron High School   Regular School Not applicable High 09 12 2020   grade_9 117.0 6.0 74.0 3.0   36.0       5.0 5.0   139.0 107.0                       246.0 117 6 74 3   36       5 5   139 107                 246
491977 SD     school 4635480 2002   Huron 02-2 463548001370 18 Buchanan K-1 Center   Regular School Not applicable Elementary KG 01 2020   k_12_total 170.0 5.0 153.0 9.0   106.0       5.0 16.0   228.0 236.0       46.1               464.0 170 5 153 9   106       5 16   228 236                 464
491980 SD     school 4635480 2002   Huron 02-2 463548000314 2 Huron Middle School   Regular School Not applicable Middle 06 08 2020   k_12_total 297.0 10.0 152.0 10.0   126.0       5.0 17.0   333.0 284.0       22.5               617.0 297 10 152 10   126       5 17   333 284                 617
491991 SD     school 4635480 2002   Huron 02-2 463548001370 18 Buchanan K-1 Center   Regular School Not applicable Elementary KG 01 2020   pk_12_total 170.0 5.0 153.0 9.0   106.0       5.0 16.0   228.0 236.0                       464.0 170 5 153 9   106       5 16   228 236                 464
491994 SD     school 4635480 2002   Huron 02-2 463548000314 2 Huron Middle School   Regular School Not applicable Middle 06 08 2020   pk_12_total 297.0 10.0 152.0 10.0   126.0       5.0 17.0   333.0 284.0                       617.0 297 10 152 10   126       5 17   333 284                 617
494913 SD     school 4659820 51004   Rapid City Area 51-4 465982000538 3 Black Hawk Elem   Regular School Not applicable Elementary KG 05 2020   k_12_total 289.0 3.0 34.0 31.0   1.0       5.0 42.0   207.0 198.0       0.7               405.0 289 3 34 31   1       5 42   207 198                 405
494938 SD     school 4659820 51004   Rapid City Area 51-4 465982000538 3 Black Hawk Elem   Regular School Not applicable Elementary KG 05 2020   kindergarten 46.0 0.0 5.0 5.0   0.0       5.0 5.0   26.0 40.0                       66.0 46 0 5 5   0       5 5   26 40                 66
494963 SD     school 4659820 51004   Rapid City Area 51-4 465982000538 3 Black Hawk Elem   Regular School Not applicable Elementary KG 05 2020   pk_12_total 289.0 3.0 34.0 31.0   1.0       5.0 42.0   207.0 198.0                       405.0 289 3 34 31   1       5 42   207 198                 405
451039 SD     school 4636990 61008   Dakota Valley 61-8 463699000345 1 Dakota Valley High School   Regular School Not applicable High 09 12 2021   k_12_total 319.0 9.0 31.0 8.0   10.0       5.0 14.0   196.0 200.0       1.5               396.0 319 9 31 8   10       5 14   196 200                 396
451047 SD     school 4636990 61008   Dakota Valley 61-8 463699000345 1 Dakota Valley High School   Regular School Not applicable High 09 12 2021   pk_12_total 319.0 9.0 31.0 8.0   10.0       5.0 14.0   196.0 200.0                       396.0 319 9 31 8   10       5 14   196 200                 396
455723 SD     school 4665460 65001   Oglala Lakota 65-1 466546000575 4 Red Shirt School   Regular School Not applicable Elementary PK 08 2021   pre_kindergarten     1.0 2.0           5.0 0.0   7.0 1.0                       8.0     1 2           5 0   7 1                 8
2961715 SD     school 4602070 6001   Aberdeen 06-1 460207000011 3 Simmons Middle School   Regular School No 2 06 08 2015   grade_8 140.0 3.0 3.0 14.0   4.0       4.0 1.0   82.0 87.0                       169.0 140 3 3 14   4       4 1   82 87                 169
2967702 SD     school 4647942 29004   Miller 464794200429 2 Miller Elementary School   Regular School No 1 PK 06 2015   k_12_total 238.0 1.0 5.0 1.0   1.0       4.0     125.0 125.0                       250.0 238 1 5 1   1       4     125 125                 250
2967710 SD     school 4647942 29004   Miller 464794200429 2 Miller Elementary School   Regular School No 1 PK 06 2015   pk_12_total 238.0 1.0 5.0 1.0   1.0       4.0     125.0 125.0                       250.0 238 1 5 1   1       4     125 125                 250
2970063 SD     school 4666270 49005   Sioux Falls 49-5 466627000587 19 Garfield Elementary   Regular School No 1 PK 05 2015   k_12_total 200.0 42.0 43.0 26.0   1.0       4.0 35.0   177.0 174.0       8.3               351.0 200 42 43 26   1       4 35   177 174                 351
2970153 SD     school 4666270 49005   Sioux Falls 49-5 466627000587 19 Garfield Elementary   Regular School No 1 PK 05 2015   pk_12_total 227.0 58.0 47.0 30.0   3.0       4.0 44.0   215.0 198.0                       413.0 227 58 47 30   3       4 44   215 198                 413
3344274 SD     school 4602070 6001   Aberdeen 06-1 460207000003 1 Central High School   Regular School No 3 09 12 2016   grade_9 291.0 7.0 4.0 27.0   6.0       4.0 2.0   176.0 165.0                       341.0 291 7 4 27   6       4 2   176 165                 341
3344286 SD     school 4602070 6001   Aberdeen 06-1 460207000008 9 May Overby Elementary   Regular School No 1 KG 05 2016   k_12_total 313.0 7.0 19.0 23.0   11.0       4.0 37.0   204.0 210.0                       414.0 313 7 19 23   11       4 37   204 210                 414
3344304 SD     school 4602070 6001   Aberdeen 06-1 460207000008 9 May Overby Elementary   Regular School No 1 KG 05 2016   pk_12_total 313.0 7.0 19.0 23.0   11.0       4.0 37.0   204.0 210.0                       414.0 313 7 19 23   11       4 37   204 210                 414
3346680 SD     school 4619410 51001   Douglas 51-1 461941000176 1 Douglas Middle School   Regular School No 2 06 08 2016   k_12_total 445.0 10.0 48.0 48.0   8.0       4.0 58.0   313.0 308.0       0.0               621.0 445 10 48 48   8       4 58   313 308                 621
3346692 SD     school 4619410 51001   Douglas 51-1 461941000176 1 Douglas Middle School   Regular School No 2 06 08 2016   pk_12_total 445.0 10.0 48.0 48.0   8.0       4.0 58.0   313.0 308.0                       621.0 445 10 48 48   8       4 58   313 308                 621
3350302 SD     school 4647942 29004   Miller 464794200429 2 Miller Elementary School   Regular School No 1 PK 06 2016   k_12_total 259.0 1.0 1.0 2.0   1.0       4.0     143.0 125.0       0.4               268.0 259 1 1 2   1       4     143 125                 268
3350310 SD     school 4647942 29004   Miller 464794200429 2 Miller Elementary School   Regular School No 1 PK 06 2016   pk_12_total 259.0 1.0 1.0 2.0   1.0       4.0     143.0 125.0                       268.0 259 1 1 2   1       4     143 125                 268
3006241 SD     school 4602070 6001   Aberdeen 06-1 460207000003 1 Central High School   Regular School No High 09 12 2017   grade_10 270.0 8.0 8.0 25.0   7.0       4.0 1.0   162.0 161.0                       323.0 270 8 8 25   7       4 1   162 161                 323
3008768 SD     school 4619410 51001   Douglas 51-1 461941000176 1 Douglas Middle School   Regular School No Middle 06 08 2017   k_12_total 453.0 19.0 50.0 56.0   8.0       4.0 55.0   338.0 307.0       0.0               645.0 453 19 50 56   8       4 55   338 307                 645
3008780 SD     school 4619410 51001   Douglas 51-1 461941000176 1 Douglas Middle School   Regular School No Middle 06 08 2017   pk_12_total 453.0 19.0 50.0 56.0   8.0       4.0 55.0   338.0 307.0                       645.0 453 19 50 56   8       4 55   338 307                 645
3012438 SD     school 4647942 29004   Miller 464794200429 2 Miller Elementary School   Regular School No Elementary KG 06 2017   k_12_total 265.0 1.0 2.0 1.0   1.0       4.0     150.0 124.0       0.4               274.0 265 1 2 1   1       4     150 124                 274
3012446 SD     school 4647942 29004   Miller 464794200429 2 Miller Elementary School   Regular School No Elementary KG 06 2017   pk_12_total 265.0 1.0 2.0 1.0   1.0       4.0     150.0 124.0                       274.0 265 1 2 1   1       4     150 124                 274
3014761 SD     school 4666270 49005   Sioux Falls 49-5 466627000587 19 Garfield Elementary   Regular School No Elementary PK 05 2017   k_12_total 233.0 99.0 66.0 39.0   16.0       4.0 48.0   263.0 242.0       15.3               505.0 233 99 66 39   16       4 48   263 242                 505
3014845 SD     school 4666270 49005   Sioux Falls 49-5 466627000587 19 Garfield Elementary   Regular School No Elementary PK 05 2017   pk_12_total 251.0 119.0 73.0 48.0   16.0       4.0 52.0   294.0 269.0                       563.0 251 119 73 48   16       4 52   294 269                 563
253101 SD     school 4624390 50003   Flandreau 50-3 462439000207 4 Flandreau Elem   Regular School No Elementary KG 05 2018   k_12_total 136.0 1.0 44.0 100.0   6.0       4.0 24.0   164.0 151.0       10.2               315.0 136 1 44 100   6       4 24   164 151                 315
253109 SD     school 4624390 50003   Flandreau 50-3 462439000207 4 Flandreau Elem   Regular School No Elementary KG 05 2018   pk_12_total 136.0 1.0 44.0 100.0   6.0       4.0 24.0   164.0 151.0                       315.0 136 1 44 100   6       4 24   164 151                 315
256013 SD     school 4647942 29004   Miller 464794200429 2 Miller Elementary School   Regular School No Elementary KG 06 2018   k_12_total 269.0 1.0 5.0 2.0           4.0 1.0   147.0 135.0       0.4               282.0 269 1 5 2           4 1   147 135                 282
256021 SD     school 4647942 29004   Miller 464794200429 2 Miller Elementary School   Regular School No Elementary KG 06 2018   pk_12_total 269.0 1.0 5.0 2.0           4.0 1.0   147.0 135.0                       282.0 269 1 5 2           4 1   147 135                 282
256103 SD     school 4648390 17002   Mitchell 17-2 464839000437 2 Mitchell Middle School   Regular School No Middle 06 08 2018   grade_8 190.0 1.0 4.0 11.0   5.0       4.0 1.0   113.0 103.0                       216.0 190 1 4 11   5       4 1   113 103                 216
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
360328 SD     school 4624390 50003   Flandreau 50-3 462439000207 4 Flandreau Elem   Regular School No Elementary KG 04 2019   k_12_total 103.0   37.0 72.0   5.0       4.0 31.0   132.0 120.0       10.3               252.0 103   37 72   5       4 31   132 120                 252
360330 SD     school 4624390 50003   Flandreau 50-3 462439000205 3 Flandreau Middle Sch   Regular School No Middle 05 08 2019   k_12_total 114.0 2.0 21.0 74.0   2.0       4.0 4.0   110.0 111.0       3.6               221.0 114 2 21 74   2       4 4   110 111                 221
360336 SD     school 4624390 50003   Flandreau 50-3 462439000207 4 Flandreau Elem   Regular School No Elementary KG 04 2019   pk_12_total 103.0   37.0 72.0   5.0       4.0 31.0   132.0 120.0                       252.0 103   37 72   5       4 31   132 120                 252
360338 SD     school 4624390 50003   Flandreau 50-3 462439000205 3 Flandreau Middle Sch   Regular School No Middle 05 08 2019   pk_12_total 114.0 2.0 21.0 74.0   2.0       4.0 4.0   110.0 111.0                       221.0 114 2 21 74   2       4 4   110 111                 221
361697 SD     school 4635480 2002   Huron 02-2 463548000314 2 Huron Middle School   Regular School No Middle 06 08 2019   grade_8 97.0 6.0 38.0 1.0   33.0       4.0 2.0   98.0 83.0                       181.0 97 6 38 1   33       4 2   98 83                 181
492597 SD     school 4641300 40001   Lead-Deadwood 40-1 464130001145 10 Lead-Deadwood Career & Tech Ed   Alternative School Not applicable High 09 12 2020   k_12_total 20.0 10.0 2.0 33.0   2.0       4.0 4.0   51.0 24.0       17.3               75.0 20 10 2 33   2       4 4   51 24                 75
492605 SD     school 4641300 40001   Lead-Deadwood 40-1 464130001145 10 Lead-Deadwood Career & Tech Ed   Alternative School Not applicable High 09 12 2020   pk_12_total 20.0 10.0 2.0 33.0   2.0       4.0 4.0   51.0 24.0                       75.0 20 10 2 33   2       4 4   51 24                 75
495877 SD     school 4666270 49005   Sioux Falls 49-5 466627000583 6 Edison Middle School   Regular School Not applicable Middle 06 08 2020   k_12_total 766.0 91.0 135.0 45.0   19.0       4.0 65.0   583.0 542.0       3.1               1125.0 766 91 135 45   19       4 65   583 542                 1125
495907 SD     school 4666270 49005   Sioux Falls 49-5 466627001351 66 Susan B. Anthony Elementary   Regular School Not applicable Elementary KG 05 2020   k_12_total 280.0 79.0 81.0 14.0   19.0       4.0 32.0   283.0 226.0       19.7               509.0 280 79 81 14   19       4 32   283 226                 509
495961 SD     school 4666270 49005   Sioux Falls 49-5 466627000583 6 Edison Middle School   Regular School Not applicable Middle 06 08 2020   pk_12_total 766.0 91.0 135.0 45.0   19.0       4.0 65.0   583.0 542.0                       1125.0 766 91 135 45   19       4 65   583 542                 1125
495991 SD     school 4666270 49005   Sioux Falls 49-5 466627001351 66 Susan B. Anthony Elementary   Regular School Not applicable Elementary KG 05 2020   pk_12_total 280.0 79.0 81.0 14.0   19.0       4.0 32.0   283.0 226.0                       509.0 280 79 81 14   19       4 32   283 226                 509
451438 SD     school 4619410 51001   Douglas 51-1 461941000174 3 Douglas High School   Regular School Not applicable High 09 12 2021   k_12_total 559.0 22.0 62.0 55.0   13.0       4.0 62.0   418.0 359.0       0.4               777.0 559 22 62 55   13       4 62   418 359                 777
451446 SD     school 4619410 51001   Douglas 51-1 461941000174 3 Douglas High School   Regular School Not applicable High 09 12 2021   pk_12_total 559.0 22.0 62.0 55.0   13.0       4.0 62.0   418.0 359.0                       777.0 559 22 62 55   13       4 62   418 359                 777
453554 SD     school 4635480 2002   Huron 02-2 463548001370 18 Buchanan K-1 Center   Regular School Not applicable Elementary KG 01 2021   k_12_total 163.0 4.0 146.0 8.0   105.0       4.0 16.0   211.0 235.0       46.6               446.0 163 4 146 8   105       4 16   211 235                 446
453557 SD     school 4635480 2002   Huron 02-2 463548000314 2 Huron Middle School   Regular School Not applicable Middle 06 08 2021   k_12_total 291.0 9.0 166.0 12.0   114.0       4.0 19.0   346.0 269.0       22.9               615.0 291 9 166 12   114       4 19   346 269                 615
453568 SD     school 4635480 2002   Huron 02-2 463548001370 18 Buchanan K-1 Center   Regular School Not applicable Elementary KG 01 2021   pk_12_total 163.0 4.0 146.0 8.0   105.0       4.0 16.0   211.0 235.0                       446.0 163 4 146 8   105       4 16   211 235                 446
453571 SD     school 4635480 2002   Huron 02-2 463548000314 2 Huron Middle School   Regular School Not applicable Middle 06 08 2021   pk_12_total 291.0 9.0 166.0 12.0   114.0       4.0 19.0   346.0 269.0                       615.0 291 9 166 12   114       4 19   346 269                 615
457486 SD     school 4666270 49005   Sioux Falls 49-5 466627000610 1 Washington High School   Regular School Not applicable High 09 12 2021   k_12_total 968.0 415.0 295.0 91.0   128.0       4.0 78.0   974.0 1005.0       15.8               1979.0 968 415 295 91   128       4 78   974 1005                 1979
457570 SD     school 4666270 49005   Sioux Falls 49-5 466627000610 1 Washington High School   Regular School Not applicable High 09 12 2021   pk_12_total 968.0 415.0 295.0 91.0   128.0       4.0 78.0   974.0 1005.0                       1979.0 968 415 295 91   128       4 78   974 1005                 1979
2962633 SD     school 4607950 49002   Brandon Valley 49-2 460795000071 1 Brandon Valley Hi Sch   Regular School No 3 09 12 2015   grade_9 245.0 4.0 3.0 1.0   5.0       3.0 2.0   133.0 130.0                       263.0 245 4 3 1   5       3 2   133 130                 263
2964063 SD     school 4619410 51001   Douglas 51-1 461941000174 3 Douglas High School   Regular School No 3 09 12 2015   k_12_total 533.0 21.0 43.0 45.0   8.0       3.0 64.0   401.0 316.0                       717.0 533 21 43 45   8       3 64   401 316                 717
2964075 SD     school 4619410 51001   Douglas 51-1 461941000174 3 Douglas High School   Regular School No 3 09 12 2015   pk_12_total 533.0 21.0 43.0 45.0   8.0       3.0 64.0   401.0 316.0                       717.0 533 21 43 45   8       3 64   401 316                 717
2964822 SD     school 4624390 50003   Flandreau 50-3 462439000207 4 Flandreau Elem   Regular School No 1 KG 05 2015   k_12_total 167.0   26.0 111.0   4.0       3.0 4.0   173.0 142.0                       315.0 167   26 111   4       3 4   173 142                 315
2964830 SD     school 4624390 50003   Flandreau 50-3 462439000207 4 Flandreau Elem   Regular School No 1 KG 05 2015   pk_12_total 167.0   26.0 111.0   4.0       3.0 4.0   173.0 142.0                       315.0 167   26 111   4       3 4   173 142                 315
2967878 SD     school 4680441 62006   Mobridge-Pollock 62-6 468044100486 3 Freeman Davis Elementary   Regular School No 1 PK 02 2015   k_12_total 91.0   7.0 64.0   1.0       3.0     65.0 101.0                       166.0 91   7 64   1       3     65 101                 166
2967882 SD     school 4680441 62006   Mobridge-Pollock 62-6 468044100486 3 Freeman Davis Elementary   Regular School No 1 PK 02 2015   kindergarten 29.0   3.0 23.0   0.0       3.0     22.0 36.0                       58.0 29   3 23   0       3     22 36                 58
2967886 SD     school 4680441 62006   Mobridge-Pollock 62-6 468044100486 3 Freeman Davis Elementary   Regular School No 1 PK 02 2015   pk_12_total 91.0   7.0 64.0   1.0       3.0     65.0 101.0                       166.0 91   7 64   1       3     65 101                 166
2970073 SD     school 4666270 49005   Sioux Falls 49-5 466627000598 31 Laura Wilder Elementary   Regular School No 1 KG 05 2015   k_12_total 303.0 52.0 48.0 35.0   17.0       3.0 25.0   241.0 242.0       3.7               483.0 303 52 48 35   17       3 25   241 242                 483

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