Data source: Big Local News · About: Big Local

10,768 rows where state = "SD" and year = 2020 sorted by pacific_islander descending

View and edit SQL

year

  • 2020 · 10,768
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
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
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
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
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
487461 SD     school 4602070 6001   Aberdeen 06-1 460207000010 10 Simmons Elementary   Regular School Not applicable Elementary KG 05 2020   k_12_total 296.0 5.0 26.0 24.0   10.0       3.0 23.0   188.0 199.0       4.9               387.0 296 5 26 24   10       3 23   188 199                 387
487481 SD     school 4602070 6001   Aberdeen 06-1 460207000010 10 Simmons Elementary   Regular School Not applicable Elementary KG 05 2020   pk_12_total 296.0 5.0 26.0 24.0   10.0       3.0 23.0   188.0 199.0                       387.0 296 5 26 24   10       3 23   188 199                 387
489455 SD     school 4636990 61008   Dakota Valley 61-8 463699000809 3 Dakota Valley Middle School   Regular School Not applicable Middle 06 08 2020   grade_8 93.0 3.0 8.0 3.0   2.0       3.0 5.0   54.0 63.0                       117.0 93 3 8 3   2       3 5   54 63                 117
489463 SD     school 4636990 61008   Dakota Valley 61-8 463699000809 3 Dakota Valley Middle School   Regular School Not applicable Middle 06 08 2020   k_12_total 291.0 12.0 25.0 8.0   5.0       3.0 18.0   176.0 186.0       3.0               362.0 291 12 25 8   5       3 18   176 186                 362
489471 SD     school 4636990 61008   Dakota Valley 61-8 463699000809 3 Dakota Valley Middle School   Regular School Not applicable Middle 06 08 2020   pk_12_total 291.0 12.0 25.0 8.0   5.0       3.0 18.0   176.0 186.0                       362.0 291 12 25 8   5       3 18   176 186                 362
489818 SD     school 4619410 51001   Douglas 51-1 461941000174 3 Douglas High School   Regular School Not applicable High 09 12 2020   grade_10 147.0 4.0 15.0 14.0   4.0       3.0 16.0   111.0 92.0                       203.0 147 4 15 14   4       3 16   111 92                 203
489864 SD     school 4619410 51001   Douglas 51-1 461941000176 1 Douglas Middle School   Regular School Not applicable Middle 06 08 2020   grade_8 148.0 4.0 10.0 15.0   4.0       3.0 17.0   104.0 97.0                       201.0 148 4 10 15   4       3 17   104 97                 201
489876 SD     school 4619410 51001   Douglas 51-1 461941001384 6 Patriot Elementary   Regular School Not applicable Elementary KG 03 2020   k_12_total 606.0 22.0 105.0 68.0   9.0       3.0 116.0   473.0 456.0       0.5               929.0 606 22 105 68   9       3 116   473 456                 929
489886 SD     school 4619410 51001   Douglas 51-1 461941001384 6 Patriot Elementary   Regular School Not applicable Elementary KG 03 2020   pk_12_total 606.0 22.0 105.0 68.0   9.0       3.0 116.0   473.0 456.0                       929.0 606 22 105 68   9       3 116   473 456                 929
490597 SD     school 4624390 50003   Flandreau 50-3 462439000207 4 Flandreau Elem   Regular School Not applicable Elementary KG 04 2020   k_12_total 108.0   43.0 76.0   4.0       3.0 31.0   142.0 123.0       9.8               265.0 108   43 76   4       3 31   142 123                 265
490605 SD     school 4624390 50003   Flandreau 50-3 462439000207 4 Flandreau Elem   Regular School Not applicable Elementary KG 04 2020   pk_12_total 108.0   43.0 76.0   4.0       3.0 31.0   142.0 123.0                       265.0 108   43 76   4       3 31   142 123                 265
491769 SD     school 4634480 23002   Hot Springs 23-2 463448000287 2 Hot Springs Elementary   Regular School Not applicable Elementary PK 05 2020   k_12_total 235.0 2.0 16.0 27.0   1.0       3.0 46.0   178.0 152.0       0.6               330.0 235 2 16 27   1       3 46   178 152                 330
491775 SD     school 4634480 23002   Hot Springs 23-2 463448000287 2 Hot Springs Elementary   Regular School Not applicable Elementary PK 05 2020   pk_12_total 257.0 2.0 18.0 29.0   1.0       3.0 49.0   194.0 165.0                       359.0 257 2 18 29   1       3 49   194 165                 359
491952 SD     school 4635480 2002   Huron 02-2 463548000314 2 Huron Middle School   Regular School Not applicable Middle 06 08 2020   grade_6 106.0 3.0 58.0 2.0   43.0       3.0 6.0   127.0 94.0                       221.0 106 3 58 2   43       3 6   127 94                 221
491984 SD     school 4635480 2002   Huron 02-2 463548001370 18 Buchanan K-1 Center   Regular School Not applicable Elementary KG 01 2020   kindergarten 83.0 3.0 82.0 2.0   52.0       3.0 11.0   107.0 129.0                       236.0 83 3 82 2   52       3 11   107 129                 236
493644 SD     school 4648390 17002   Mitchell 17-2 464839000442 1 Mitchell High School   Regular School Not applicable High 09 12 2020   k_12_total 685.0 6.0 40.0 42.0   9.0       3.0 19.0   399.0 405.0       2.1               804.0 685 6 40 42   9       3 19   399 405                 804
493658 SD     school 4648390 17002   Mitchell 17-2 464839000442 1 Mitchell High School   Regular School Not applicable High 09 12 2020   pk_12_total 685.0 6.0 40.0 42.0   9.0       3.0 19.0   399.0 405.0                       804.0 685 6 40 42   9       3 19   399 405                 804
495793 SD     school 4666270 49005   Sioux Falls 49-5 466627000583 6 Edison Middle School   Regular School Not applicable Middle 06 08 2020   grade_8 250.0 31.0 39.0 14.0   4.0       3.0 17.0   190.0 168.0                       358.0 250 31 39 14   4       3 17   190 168                 358
487454 SD     school 4602070 6001   Aberdeen 06-1 460207000003 1 Central High School   Regular School Not applicable High 09 12 2020   k_12_total 1081.0 30.0 85.0 79.0   46.0       2.0 26.0   671.0 678.0       2.8               1349.0 1081 30 85 79   46       2 26   671 678                 1349
487474 SD     school 4602070 6001   Aberdeen 06-1 460207000003 1 Central High School   Regular School Not applicable High 09 12 2020   pk_12_total 1081.0 30.0 85.0 79.0   46.0       2.0 26.0   671.0 678.0                       1349.0 1081 30 85 79   46       2 26   671 678                 1349
488657 SD     school 4608520 5001   Brookings 05-1 460852000085 4 Hillcrest Elem   Regular School Not applicable Elementary KG 03 2020   k_12_total 225.0 12.0 18.0 15.0   10.0       2.0 22.0   169.0 135.0       9.5               304.0 225 12 18 15   10       2 22   169 135                 304
488669 SD     school 4608520 5001   Brookings 05-1 460852000085 4 Hillcrest Elem   Regular School Not applicable Elementary KG 03 2020   pk_12_total 225.0 12.0 18.0 15.0   10.0       2.0 22.0   169.0 135.0                       304.0 225 12 18 15   10       2 22   169 135                 304
489398 SD     school 4616950 16001   Custer 16-1 461695000155 1 Custer High School   Regular School Not applicable High 09 12 2020   k_12_total 239.0 5.0 13.0 11.0   3.0       2.0 7.0   144.0 136.0       0.4               280.0 239 5 13 11   3       2 7   144 136                 280
489406 SD     school 4616950 16001   Custer 16-1 461695000155 1 Custer High School   Regular School Not applicable High 09 12 2020   pk_12_total 239.0 5.0 13.0 11.0   3.0       2.0 7.0   144.0 136.0                       280.0 239 5 13 11   3       2 7   144 136                 280
489462 SD     school 4636990 61008   Dakota Valley 61-8 463699000345 1 Dakota Valley High School   Regular School Not applicable High 09 12 2020   k_12_total 319.0 10.0 30.0 7.0   10.0       2.0 10.0   204.0 184.0       0.8               388.0 319 10 30 7   10       2 10   204 184                 388
489470 SD     school 4636990 61008   Dakota Valley 61-8 463699000345 1 Dakota Valley High School   Regular School Not applicable High 09 12 2020   pk_12_total 319.0 10.0 30.0 7.0   10.0       2.0 10.0   204.0 184.0                       388.0 319 10 30 7   10       2 10   204 184                 388
489854 SD     school 4619410 51001   Douglas 51-1 461941000176 1 Douglas Middle School   Regular School Not applicable Middle 06 08 2020   grade_6 153.0 4.0 26.0 16.0   0.0       2.0 16.0   122.0 95.0                       217.0 153 4 26 16   0       2 16   122 95                 217
489868 SD     school 4619410 51001   Douglas 51-1 461941000174 3 Douglas High School   Regular School Not applicable High 09 12 2020   grade_9 184.0 8.0 26.0 26.0   4.0       2.0 19.0   140.0 129.0                       269.0 184 8 26 26   4       2 19   140 129                 269
490962 SD     school 4629880 26004   Gregory 26-4 462988001296 4 Gregory Jr High School   Regular School Not applicable Middle 06 08 2020   grade_7 22.0 0.0 0.0 6.0   1.0       2.0 0.0   18.0 13.0                       31.0 22 0 0 6   1       2 0   18 13                 31
490971 SD     school 4629880 26004   Gregory 26-4 462988001296 4 Gregory Jr High School   Regular School Not applicable Middle 06 08 2020   k_12_total 67.0 1.0 2.0 18.0   2.0       2.0 1.0   47.0 46.0       0.0               93.0 67 1 2 18   2       2 1   47 46                 93
490977 SD     school 4629880 26004   Gregory 26-4 462988001296 4 Gregory Jr High School   Regular School Not applicable Middle 06 08 2020   pk_12_total 67.0 1.0 2.0 18.0   2.0       2.0 1.0   47.0 46.0                       93.0 67 1 2 18   2       2 1   47 46                 93
491427 SD     school 4631350 41002   Harrisburg 41-2 463135001318 6 Freedom Elementary   Regular School Not applicable Elementary KG 05 2020   k_12_total 402.0 5.0 16.0 6.0           2.0 21.0   232.0 220.0       1.3               452.0 402 5 16 6           2 21   232 220                 452
491445 SD     school 4631350 41002   Harrisburg 41-2 463135001318 6 Freedom Elementary   Regular School Not applicable Elementary KG 05 2020   pk_12_total 402.0 5.0 16.0 6.0           2.0 21.0   232.0 220.0                       452.0 402 5 16 6           2 21   232 220                 452
491893 SD     school 4635480 2002   Huron 02-2 463548001370 18 Buchanan K-1 Center   Regular School Not applicable Elementary KG 01 2020   grade_1 87.0 2.0 71.0 7.0   54.0       2.0 5.0   121.0 107.0                       228.0 87 2 71 7   54       2 5   121 107                 228
491932 SD     school 4635480 2002   Huron 02-2 463548001369 19 Madison 2-3 Center   Regular School Not applicable Elementary 02 03 2020   grade_3 91.0 4.0 77.0 8.0   53.0       2.0 7.0   125.0 117.0                       242.0 91 4 77 8   53       2 7   125 117                 242
491981 SD     school 4635480 2002   Huron 02-2 463548001369 19 Madison 2-3 Center   Regular School Not applicable Elementary 02 03 2020   k_12_total 166.0 8.0 156.0 11.0   119.0       2.0 16.0   253.0 225.0       44.8               478.0 166 8 156 11   119       2 16   253 225                 478
491995 SD     school 4635480 2002   Huron 02-2 463548001369 19 Madison 2-3 Center   Regular School Not applicable Elementary 02 03 2020   pk_12_total 166.0 8.0 156.0 11.0   119.0       2.0 16.0   253.0 225.0                       478.0 166 8 156 11   119       2 16   253 225                 478
492561 SD     school 4641300 40001   Lead-Deadwood 40-1 464130001145 10 Lead-Deadwood Career & Tech Ed   Alternative School Not applicable High 09 12 2020   grade_12 4.0 0.0 0.0 8.0   0.0       2.0 1.0   13.0 2.0                       15.0 4 0 0 8   0       2 1   13 2                 15
492593 SD     school 4641300 40001   Lead-Deadwood 40-1 464130001145 10 Lead-Deadwood Career & Tech Ed   Alternative School Not applicable High 09 12 2020   grade_9 4.0 7.0 2.0 15.0   1.0       2.0 0.0   19.0 12.0                       31.0 4 7 2 15   1       2 0   19 12                 31
493541 SD     school 4647942 29004   Miller 464794200429 2 Miller Elementary School   Regular School Not applicable Elementary KG 06 2020   k_12_total 241.0 4.0 4.0             2.0 1.0   132.0 120.0       0.0               252.0 241 4 4             2 1   132 120                 252
493543 SD     school 4647942 29004   Miller 464794201051 4 Miller Junior High   Regular School Not applicable Middle 07 08 2020   k_12_total 70.0 2.0 1.0             2.0     41.0 34.0       1.3               75.0 70 2 1             2     41 34                 75
493549 SD     school 4647942 29004   Miller 464794200429 2 Miller Elementary School   Regular School Not applicable Elementary KG 06 2020   pk_12_total 241.0 4.0 4.0             2.0 1.0   132.0 120.0                       252.0 241 4 4             2 1   132 120                 252
493551 SD     school 4647942 29004   Miller 464794201051 4 Miller Junior High   Regular School Not applicable Middle 07 08 2020   pk_12_total 70.0 2.0 1.0             2.0     41.0 34.0                       75.0 70 2 1             2     41 34                 75
493567 SD     school 4648390 17002   Mitchell 17-2 464839000442 1 Mitchell High School   Regular School Not applicable High 09 12 2020   grade_10 195.0 1.0 10.0 12.0   4.0       2.0 2.0   111.0 115.0                       226.0 195 1 10 12   4       2 2   111 115                 226
493643 SD     school 4648390 17002   Mitchell 17-2 464839000441 5 Longfellow Elementary   Regular School Not applicable Elementary KG 05 2020   k_12_total 254.0 3.0 31.0 30.0           2.0 10.0   175.0 155.0       5.8               330.0 254 3 31 30           2 10   175 155                 330
493657 SD     school 4648390 17002   Mitchell 17-2 464839000441 5 Longfellow Elementary   Regular School Not applicable Elementary KG 05 2020   pk_12_total 254.0 3.0 31.0 30.0           2.0 10.0   175.0 155.0                       330.0 254 3 31 30           2 10   175 155                 330
494250 SD     school 4654270 60004   Parker 60-4 465427000488 1 Parker High School   Regular School Not applicable High 09 12 2020   k_12_total 136.0 2.0 9.0             2.0 2.0   69.0 82.0       2.0               151.0 136 2 9             2 2   69 82                 151
494256 SD     school 4654270 60004   Parker 60-4 465427000488 1 Parker High School   Regular School Not applicable High 09 12 2020   pk_12_total 136.0 2.0 9.0             2.0 2.0   69.0 82.0                       151.0 136 2 9             2 2   69 82                 151
495766 SD     school 4666270 49005   Sioux Falls 49-5 466627001070 4 Memorial Middle School   Regular School Not applicable Middle 06 08 2020   grade_7 374.0 27.0 27.0 10.0   7.0       2.0 20.0   227.0 240.0                       467.0 374 27 27 10   7       2 20   227 240                 467
495876 SD     school 4666270 49005   Sioux Falls 49-5 466627001238 26 Discovery Elementary   Regular School Not applicable Elementary PK 05 2020   k_12_total 694.0 82.0 65.0 6.0   16.0       2.0 47.0   448.0 464.0       10.1               912.0 694 82 65 6   16       2 47   448 464                 912
495889 SD     school 4666270 49005   Sioux Falls 49-5 466627000598 31 Laura Wilder Elementary   Regular School Not applicable Elementary KG 05 2020   k_12_total 295.0 50.0 60.0 40.0   2.0       2.0 57.0   251.0 255.0       2.8               506.0 295 50 60 40   2       2 57   251 255                 506
495892 SD     school 4666270 49005   Sioux Falls 49-5 466627001070 4 Memorial Middle School   Regular School Not applicable Middle 06 08 2020   k_12_total 1101.0 79.0 77.0 20.0   19.0       2.0 73.0   646.0 725.0       1.9               1371.0 1101 79 77 20   19       2 73   646 725                 1371
495897 SD     school 4666270 49005   Sioux Falls 49-5 466627001300 17 R. F. Pettigrew Elementary   Regular School Not applicable Elementary PK 05 2020   k_12_total 688.0 40.0 48.0 13.0   12.0       2.0 57.0   448.0 412.0       1.3               860.0 688 40 48 13   12       2 57   448 412                 860
495960 SD     school 4666270 49005   Sioux Falls 49-5 466627001238 26 Discovery Elementary   Regular School Not applicable Elementary PK 05 2020   pk_12_total 706.0 82.0 67.0 6.0   17.0       2.0 48.0   460.0 468.0                       928.0 706 82 67 6   17       2 48   460 468                 928
495973 SD     school 4666270 49005   Sioux Falls 49-5 466627000598 31 Laura Wilder Elementary   Regular School Not applicable Elementary KG 05 2020   pk_12_total 295.0 50.0 60.0 40.0   2.0       2.0 57.0   251.0 255.0                       506.0 295 50 60 40   2       2 57   251 255                 506
495976 SD     school 4666270 49005   Sioux Falls 49-5 466627001070 4 Memorial Middle School   Regular School Not applicable Middle 06 08 2020   pk_12_total 1101.0 79.0 77.0 20.0   19.0       2.0 73.0   646.0 725.0                       1371.0 1101 79 77 20   19       2 73   646 725                 1371
495981 SD     school 4666270 49005   Sioux Falls 49-5 466627001300 17 R. F. Pettigrew Elementary   Regular School Not applicable Elementary PK 05 2020   pk_12_total 741.0 65.0 72.0 22.0   14.0       2.0 74.0   529.0 461.0                       990.0 741 65 72 22   14       2 74   529 461                 990
496294 SD     school 4666930 40002   Spearfish 40-2 466693000401 7 Creekside Elem   Regular School Not applicable Elementary 03 05 2020   k_12_total 496.0 7.0 29.0 11.0   8.0       2.0 19.0   306.0 266.0       0.9               572.0 496 7 29 11   8       2 19   306 266                 572
496310 SD     school 4666930 40002   Spearfish 40-2 466693000401 7 Creekside Elem   Regular School Not applicable Elementary 03 05 2020   pk_12_total 496.0 7.0 29.0 11.0   8.0       2.0 19.0   306.0 266.0                       572.0 496 7 29 11   8       2 19   306 266                 572
496917 SD     school 4674370 13001   Vermillion 13-1 467437000300 3 Austin Elementary School   Regular School Not applicable Elementary PK 01 2020   k_12_total 164.0 6.0 10.0 27.0   6.0       2.0 9.0   99.0 125.0       0.5               224.0 164 6 10 27   6       2 9   99 125                 224
496921 SD     school 4674370 13001   Vermillion 13-1 467437000300 3 Austin Elementary School   Regular School Not applicable Elementary PK 01 2020   kindergarten 92.0 4.0 6.0 12.0   4.0       2.0 6.0   60.0 66.0                       126.0 92 4 6 12   4       2 6   60 66                 126
496925 SD     school 4674370 13001   Vermillion 13-1 467437000300 3 Austin Elementary School   Regular School Not applicable Elementary PK 01 2020   pk_12_total 209.0 7.0 10.0 28.0   6.0       2.0 10.0   120.0 152.0                       272.0 209 7 10 28   6       2 10   120 152                 272
497046 SD     school 4675420 11004   Wagner Community 11-4 467542000694 2 Wagner Elementary School   Regular School Not applicable Elementary KG 04 2020   k_12_total 112.0   14.0 194.0           2.0 47.0   208.0 161.0       0.0               369.0 112   14 194           2 47   208 161                 369
497054 SD     school 4675420 11004   Wagner Community 11-4 467542000694 2 Wagner Elementary School   Regular School Not applicable Elementary KG 04 2020   pk_12_total 112.0   14.0 194.0           2.0 47.0   208.0 161.0                       369.0 112   14 194           2 47   208 161                 369
487344 SD     school 4602070 6001   Aberdeen 06-1 460207000003 1 Central High School   Regular School Not applicable High 09 12 2020   grade_10 263.0 9.0 27.0 22.0   7.0       1.0 10.0   168.0 171.0                       339.0 263 9 27 22   7       1 10   168 171                 339
487378 SD     school 4602070 6001   Aberdeen 06-1 460207001367 7 Mike Miller Elementary   Regular School Not applicable Elementary KG 05 2020   grade_2 23.0 2.0 1.0 3.0   4.0       1.0 6.0   21.0 19.0                       40.0 23 2 1 3   4       1 6   21 19                 40
487380 SD     school 4602070 6001   Aberdeen 06-1 460207000009 11 O.M. Tiffany Elementary   Regular School Not applicable Elementary KG 05 2020   grade_2 35.0 1.0 3.0 5.0   1.0       1.0 5.0   24.0 27.0                       51.0 35 1 3 5   1       1 5   24 27                 51
487391 SD     school 4602070 6001   Aberdeen 06-1 460207000010 10 Simmons Elementary   Regular School Not applicable Elementary KG 05 2020   grade_3 43.0 3.0 2.0 7.0   2.0       1.0 5.0   31.0 32.0                       63.0 43 3 2 7   2       1 5   31 32                 63
487401 SD     school 4602070 6001   Aberdeen 06-1 460207000010 10 Simmons Elementary   Regular School Not applicable Elementary KG 05 2020   grade_4 53.0 1.0 7.0 3.0   3.0       1.0 4.0   35.0 37.0                       72.0 53 1 7 3   3       1 4   35 37                 72
487407 SD     school 4602070 6001   Aberdeen 06-1 460207000008 9 May Overby Elementary   Regular School Not applicable Elementary KG 05 2020   grade_5 43.0 1.0 7.0 3.0   1.0       1.0 5.0   31.0 30.0                       61.0 43 1 7 3   1       1 5   31 30                 61
487425 SD     school 4602070 6001   Aberdeen 06-1 460207000005 2 Holgate Middle School   Regular School Not applicable Middle 06 08 2020   grade_7 154.0 8.0 7.0 13.0   2.0       1.0 7.0   101.0 91.0                       192.0 154 8 7 13   2       1 7   101 91                 192
487432 SD     school 4602070 6001   Aberdeen 06-1 460207000011 3 Simmons Middle School   Regular School Not applicable Middle 06 08 2020   grade_7 145.0 3.0 17.0 13.0   6.0       1.0 9.0   97.0 97.0                       194.0 145 3 17 13   6       1 9   97 97                 194
487444 SD     school 4602070 6001   Aberdeen 06-1 460207000003 1 Central High School   Regular School Not applicable High 09 12 2020   grade_9 282.0 4.0 18.0 11.0   16.0       1.0 6.0   167.0 171.0                       338.0 282 4 18 11   16       1 6   167 171                 338
487455 SD     school 4602070 6001   Aberdeen 06-1 460207000005 2 Holgate Middle School   Regular School Not applicable Middle 06 08 2020   k_12_total 423.0 17.0 27.0 34.0   13.0       1.0 29.0   287.0 257.0       1.7               544.0 423 17 27 34   13       1 29   287 257                 544
487457 SD     school 4602070 6001   Aberdeen 06-1 460207000008 9 May Overby Elementary   Regular School Not applicable Elementary KG 05 2020   k_12_total 250.0 14.0 45.0 22.0   17.0       1.0 22.0   182.0 189.0       8.9               371.0 250 14 45 22   17       1 22   182 189                 371
487458 SD     school 4602070 6001   Aberdeen 06-1 460207001367 7 Mike Miller Elementary   Regular School Not applicable Elementary KG 05 2020   k_12_total 182.0 7.0 11.0 14.0   14.0       1.0 23.0   132.0 120.0       8.3               252.0 182 7 11 14   14       1 23   132 120                 252
487460 SD     school 4602070 6001   Aberdeen 06-1 460207000009 11 O.M. Tiffany Elementary   Regular School Not applicable Elementary KG 05 2020   k_12_total 227.0 9.0 32.0 23.0   11.0       1.0 32.0   180.0 155.0       7.5               335.0 227 9 32 23   11       1 32   180 155                 335
487462 SD     school 4602070 6001   Aberdeen 06-1 460207000011 3 Simmons Middle School   Regular School Not applicable Middle 06 08 2020   k_12_total 418.0 7.0 47.0 34.0   22.0       1.0 30.0   292.0 267.0       4.7               559.0 418 7 47 34   22       1 30   292 267                 559
487471 SD     school 4602070 6001   Aberdeen 06-1 460207000010 10 Simmons Elementary   Regular School Not applicable Elementary KG 05 2020   kindergarten 52.0 0.0 4.0 3.0   1.0       1.0 3.0   28.0 36.0                       64.0 52 0 4 3   1       1 3   28 36                 64
487475 SD     school 4602070 6001   Aberdeen 06-1 460207000005 2 Holgate Middle School   Regular School Not applicable Middle 06 08 2020   pk_12_total 423.0 17.0 27.0 34.0   13.0       1.0 29.0   287.0 257.0                       544.0 423 17 27 34   13       1 29   287 257                 544

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