Data source: Big Local News · About: Big Local

672 rows where grade = "k_12_total", state = "SD" and year = 2019 sorted by pacific_islander_int

View and edit SQL

year

  • 2019 · 672

grade

  • k_12_total · 672
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
359606 SD     school 4619410 51001   Douglas 51-1 461941001125 8 Douglas Preschool   Regular School No Prekindergarten PK PK 2019   k_12_total 0.0                 0.0 0.0   0.0 0.0                       0.0 0                 0 0   0 0                 0
361928 SD     school 4636150 2003   Iroquois 02-3 463615001144 4 Iroquois Elementary   Regular School No Elementary PK 05 2019   k_12_total 81.0 4.0 7.0 2.0           0.0 3.0   43.0 54.0       2.1               97.0 81 4 7 2           0 3   43 54                 97
365597 SD     school 4666270 49005   Sioux Falls 49-5 466627000587 19 Garfield Elementary   Regular School No Elementary PK 05 2019   k_12_total 174.0 110.0 73.0 47.0   13.0       0.0 42.0   233.0 226.0       22.7               459.0 174 110 73 47   13       0 42   233 226                 459
365600 SD     school 4666270 49005   Sioux Falls 49-5 466627000936 56 Hawthorne Elementary   Regular School No Elementary PK 05 2019   k_12_total 90.0 63.0 62.0 60.0   11.0       0.0 38.0   165.0 159.0       19.1               324.0 90 63 62 60   11       0 38   165 159                 324
357170 SD     school 4602070 6001   Aberdeen 06-1 460207000005 2 Holgate Middle School   Regular School No Middle 06 08 2019   k_12_total 442.0 11.0 21.0 27.0   12.0       1.0 26.0   272.0 268.0       1.7               540.0 442 11 21 27   12       1 26   272 268                 540
357172 SD     school 4602070 6001   Aberdeen 06-1 460207000008 9 May Overby Elementary   Regular School No Elementary KG 05 2019   k_12_total 281.0 11.0 44.0 28.0   10.0       1.0 32.0   209.0 198.0       6.1               407.0 281 11 44 28   10       1 32   209 198                 407
357173 SD     school 4602070 6001   Aberdeen 06-1 460207001367 7 Mike Miller Elementary   Regular School No Elementary KG 05 2019   k_12_total 182.0 5.0 10.0 18.0   15.0       1.0 16.0   123.0 124.0       6.9               247.0 182 5 10 18   15       1 16   123 124                 247
357175 SD     school 4602070 6001   Aberdeen 06-1 460207000009 11 O.M. Tiffany Elementary   Regular School No Elementary KG 05 2019   k_12_total 239.0 9.0 29.0 16.0   10.0       1.0 28.0   171.0 161.0       6.3               332.0 239 9 29 16   10       1 28   171 161                 332
357177 SD     school 4602070 6001   Aberdeen 06-1 460207000011 3 Simmons Middle School   Regular School No Middle 06 08 2019   k_12_total 410.0 10.0 34.0 24.0   23.0       1.0 23.0   266.0 259.0       3.4               525.0 410 10 34 24   23       1 23   266 259                 525
358140 SD     school 4607950 49002   Brandon Valley 49-2 460795000414 3 Brandon Elem   Regular School No Elementary PK 04 2019   k_12_total 479.0 11.0 17.0 6.0   1.0       1.0 26.0   297.0 244.0       0.0               541.0 479 11 17 6   1       1 26   297 244                 541
358141 SD     school 4607950 49002   Brandon Valley 49-2 460795000071 1 Brandon Valley Hi Sch   Regular School No High 09 12 2019   k_12_total 1004.0 29.0 33.0 4.0   19.0       1.0 32.0   599.0 523.0       1.4               1122.0 1004 29 33 4   19       1 32   599 523                 1122
358142 SD     school 4607950 49002   Brandon Valley 49-2 460795001355 7 Brandon Valley Intermediate   Regular School No Middle 05 06 2019   k_12_total 576.0 31.0 20.0 5.0   16.0       1.0 24.0   347.0 326.0       2.2               673.0 576 31 20 5   16       1 24   347 326                 673
358288 SD     school 4600041 45004   Britton-Hecla 45-4 460004101140 2 Britton-Hecla Elementary School   Regular School No Elementary KG 05 2019   k_12_total 174.0 2.0 13.0 3.0           1.0 5.0   95.0 103.0       1.0               198.0 174 2 13 3           1 5   95 103                 198
358384 SD     school 4608520 5001   Brookings 05-1 460852000082 1 Brookings Hi Sch   Regular School No High 09 12 2019   k_12_total 771.0 19.0 44.0 21.0   42.0       1.0 30.0   471.0 457.0       1.6               928.0 771 19 44 21   42       1 30   471 457                 928
358385 SD     school 4608520 5001   Brookings 05-1 460852001298 6 Camelot Intermediate School   Regular School No Elementary 04 05 2019   k_12_total 463.0 15.0 27.0 12.0   20.0       1.0 26.0   271.0 293.0       5.0               564.0 463 15 27 12   20       1 26   271 293                 564
358387 SD     school 4608520 5001   Brookings 05-1 460852000083 2 George S Mickelson Middle School   Regular School No Middle 06 08 2019   k_12_total 631.0 23.0 48.0 16.0   35.0       1.0 51.0   399.0 406.0       3.0               805.0 631 23 48 16   35       1 51   399 406                 805
358388 SD     school 4608520 5001   Brookings 05-1 460852000085 4 Hillcrest Elem   Regular School No Elementary KG 03 2019   k_12_total 213.0 8.0 16.0 13.0   13.0       1.0 20.0   151.0 133.0       9.2               284.0 213 8 16 13   13       1 20   151 133                 284
359292 SD     school 4618120 49003   Dell Rapids 49-3 461812000164 2 Dell Rapids Elementary   Regular School No Elementary KG 04 2019   k_12_total 347.0 1.0 5.0 5.0           1.0 10.0   202.0 167.0       0.3               369.0 347 1 5 5           1 10   202 167                 369
359420 SD     school 4600036 19004   Deuel 19-4 460003601011 2 Clear Lake Elementary   Regular School No Elementary PK 05 2019   k_12_total 226.0 2.0 14.0 10.0           1.0     144.0 109.0       1.2               253.0 226 2 14 10           1     144 109                 253
359607 SD     school 4619410 51001   Douglas 51-1 461941001384 6 Patriot Elementary   Regular School No Elementary KG 03 2019   k_12_total 662.0 23.0 98.0 63.0   6.0       1.0 125.0   504.0 474.0       0.6               978.0 662 23 98 63   6       1 125   504 474                 978
359608 SD     school 4619410 51001   Douglas 51-1 461941000436 2 Vandenberg Elementary   Regular School No Elementary 04 05 2019   k_12_total 349.0 9.0 52.0 25.0   3.0       1.0 32.0   246.0 225.0       0.6               471.0 349 9 52 25   3       1 32   246 225                 471
359710 SD     school 4620100 20001   Eagle Butte 20-1 462010000605 3 C-EB Upper Elementary   Regular School No Elementary 03 06 2019   k_12_total 2.0   1.0 242.0   1.0       1.0 1.0   125.0 123.0       0.0               248.0 2   1 242   1       1 1   125 123                 248
359886 SD     school 4621340 61007   Elk Point-Jefferson 61-7 462134000900 3 Elk Point Jefferson Middle School   Regular School No Middle 06 08 2019   k_12_total 151.0   6.0             1.0 3.0   89.0 72.0       0.0               161.0 151   6             1 3   89 72                 161
360329 SD     school 4624390 50003   Flandreau 50-3 462439000206 1 Flandreau High Sch   Regular School No High 09 12 2019   k_12_total 83.0   23.0 60.0   5.0       1.0 3.0   95.0 80.0       4.0               175.0 83   23 60   5       1 3   95 80                 175
360701 SD     school 4629880 26004   Gregory 26-4 462988000239 1 Gregory High School   Regular School No High 09 12 2019   k_12_total 84.0   1.0 13.0   2.0       1.0     55.0 46.0       0.0               101.0 84   1 13   2       1     55 46                 101
360702 SD     school 4629880 26004   Gregory 26-4 462988001296 4 Gregory Jr High School   Regular School No Middle 06 08 2019   k_12_total 59.0 1.0 1.0 16.0   3.0       1.0 4.0   43.0 42.0       0.0               85.0 59 1 1 16   3       1 4   43 42                 85
361030 SD     school 4609300 31001   Harding County 31-1 460930000088 1 Harding County High School   Regular School No High 09 12 2019   k_12_total 59.0 1.0 2.0 2.0           1.0     33.0 32.0       0.0               65.0 59 1 2 2           1     33 32                 65
361156 SD     school 4631350 41002   Harrisburg 41-2 463135001335 7 Endeavor Elem   Regular School No Elementary KG 05 2019   k_12_total 466.0 9.0 11.0 4.0   21.0       1.0 17.0   270.0 259.0       3.6               529.0 466 9 11 4   21       1 17   270 259                 529
361158 SD     school 4631350 41002   Harrisburg 41-2 463135001318 6 Freedom Elementary   Regular School No Elementary KG 05 2019   k_12_total 410.0 3.0 15.0 5.0           1.0 19.0   225.0 228.0       2.0               453.0 410 3 15 5           1 19   225 228                 453
361708 SD     school 4635480 2002   Huron 02-2 463548001370 18 Buchanan K-1 Center   Regular School No Elementary KG 01 2019   k_12_total 160.0 4.0 149.0 11.0   115.0       1.0 16.0   238.0 218.0       45.2               456.0 160 4 149 11   115       1 16   238 218                 456
361714 SD     school 4635480 2002   Huron 02-2 463548001373 20 Washington 4-5 Center   Regular School No Elementary 04 05 2019   k_12_total 197.0 5.0 109.0 6.0   77.0       1.0 10.0   233.0 172.0       29.9               405.0 197 5 109 6   77       1 10   233 172                 405
361929 SD     school 4636150 2003   Iroquois 02-3 463615000339 1 Iroquois High School   Regular School No High 09 12 2019   k_12_total 53.0 2.0 1.0 1.0           1.0     31.0 27.0       0.0               58.0 53 2 1 1           1     31 27                 58
361930 SD     school 4636150 2003   Iroquois 02-3 463615000916 2 Iroquois Middle School   Regular School No Middle 06 08 2019   k_12_total 48.0 3.0 1.0 3.0           1.0 2.0   24.0 34.0       0.0               58.0 48 3 1 3           1 2   24 34                 58
362329 SD     school 4641300 40001   Lead-Deadwood 40-1 464130000372 3 Lead-Deadwood Elementary   Regular School No Elementary KG 05 2019   k_12_total 256.0 2.0 16.0 9.0   3.0       1.0 15.0   157.0 145.0       0.7               302.0 256 2 16 9   3       1 15   157 145                 302
363038 SD     school 4669930 46001   Meade 46-1 466993001392 10 Stagebarn Middle School   Regular School No Middle 05 08 2019   k_12_total 272.0 3.0 11.0 11.0   2.0       1.0 13.0   150.0 163.0       0.0               313.0 272 3 11 11   2       1 13   150 163                 313
363039 SD     school 4669930 46001   Meade 46-1 466993000633 1 Sturgis Brown HS   Regular School No High 09 12 2019   k_12_total 604.0 8.0 28.0 30.0           1.0 20.0   341.0 350.0       0.0               691.0 604 8 28 30           1 20   341 350                 691
363040 SD     school 4669930 46001   Meade 46-1 466993000637 3 Sturgis Elementary   Regular School No Elementary KG 04 2019   k_12_total 470.0 5.0 25.0 14.0   6.0       1.0 24.0   293.0 252.0       0.6               545.0 470 5 25 14   6       1 24   293 252                 545
363258 SD     school 4647942 29004   Miller 464794201051 4 Miller Junior High   Regular School No Middle 07 08 2019   k_12_total 62.0 1.0       1.0       1.0     34.0 31.0       0.0               65.0 62 1       1       1     34 31                 65
363598 SD     school 4650670 51003   New Underwood 51-3 465067000456 4 New Underwood Jr Hi   Regular School No Middle 07 08 2019   k_12_total 27.0   1.0 1.0           1.0 3.0   16.0 17.0       0.0               33.0 27   1 1           1 3   16 17                 33
363645 SD     school 4650850 9002   Newell 09-2 465085000469 1 Newell High School   Regular School No High 09 12 2019   k_12_total 81.0 4.0 1.0 2.0   1.0       1.0 2.0   55.0 37.0       0.0               92.0 81 4 1 2   1       1 2   55 37                 92
363965 SD     school 4654270 60004   Parker 60-4 465427000488 1 Parker High School   Regular School No High 09 12 2019   k_12_total 124.0 1.0 4.0             1.0 3.0   66.0 67.0       0.8               133.0 124 1 4             1 3   66 67                 133
363966 SD     school 4654270 60004   Parker 60-4 465427000925 3 Parker JH   Regular School No Middle 07 08 2019   k_12_total 71.0   2.0 1.0           1.0 3.0   39.0 39.0       1.3               78.0 71   2 1           1 3   39 39                 78
364630 SD     school 4659820 51004   Rapid City Area 51-4 465982000529 41 Central Hi Sch   Regular School No High 09 12 2019   k_12_total 1188.0 33.0 120.0 366.0   26.0       1.0 153.0   916.0 971.0       1.0               1887.0 1188 33 120 366   26       1 153   916 971                 1887
364631 SD     school 4659820 51004   Rapid City Area 51-4 465982000542 21 Corral Drive Elem   Regular School No Elementary KG 05 2019   k_12_total 410.0 3.0 13.0 8.0   16.0       1.0 26.0   235.0 242.0       0.0               477.0 410 3 13 8   16       1 26   235 242                 477
364637 SD     school 4659820 51004   Rapid City Area 51-4 465982000539 8 Knollwood Heights Elem   Regular School No Elementary KG 05 2019   k_12_total 96.0 2.0 38.0 239.0   1.0       1.0 55.0   230.0 202.0       0.0               432.0 96 2 38 239   1       1 55   230 202                 432
364647 SD     school 4659820 51004   Rapid City Area 51-4 465982000824 16 South Park Elem   Regular School No Elementary KG 05 2019   k_12_total 131.0 1.0 39.0 112.0   1.0       1.0 41.0   170.0 156.0       0.3               326.0 131 1 39 112   1       1 41   170 156                 326
364651 SD     school 4659820 51004   Rapid City Area 51-4 465982000822 37 West Middle Sch   Regular School No Middle 06 08 2019   k_12_total 475.0 4.0 69.0 39.0   4.0       1.0 53.0   339.0 306.0       0.3               645.0 475 4 69 39   4       1 53   339 306                 645
364840 SD     school 4663360 54004   Rosholt 54-4 466336000556 2 Rosholt Elementary   Regular School No Elementary KG 06 2019   k_12_total 85.0   6.0 15.0           1.0 10.0   60.0 57.0       0.0               117.0 85   6 15           1 10   60 57                 117
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
365598 SD     school 4666270 49005   Sioux Falls 49-5 466627001333 9 George McGovern Middle School   Regular School No Middle 06 08 2019   k_12_total 352.0 154.0 209.0 83.0   27.0       1.0 64.0   471.0 419.0       16.0               890.0 352 154 209 83   27       1 64   471 419                 890
365603 SD     school 4666270 49005   Sioux Falls 49-5 466627001064 23 John Harris Elementary   Regular School No Elementary PK 05 2019   k_12_total 567.0 30.0 18.0 7.0   11.0       1.0 24.0   320.0 338.0       1.4               658.0 567 30 18 7   11       1 24   320 338                 658
365606 SD     school 4666270 49005   Sioux Falls 49-5 466627000600 2 Lincoln High School   Regular School No High 09 12 2019   k_12_total 1447.0 220.0 141.0 103.0   57.0       1.0 79.0   1029.0 1019.0       5.4               2048.0 1447 220 141 103   57       1 79   1029 1019                 2048
365607 SD     school 4666270 49005   Sioux Falls 49-5 466627000602 28 Lowell Elementary   Regular School No Elementary PK 05 2019   k_12_total 143.0 81.0 68.0 57.0   3.0       1.0 60.0   210.0 203.0       11.9               413.0 143 81 68 57   3       1 60   210 203                 413
365615 SD     school 4666270 49005   Sioux Falls 49-5 466627001063 3 Roosevelt High School   Regular School No High 09 12 2019   k_12_total 1721.0 184.0 261.0 95.0   72.0       1.0 70.0   1232.0 1172.0       6.6               2404.0 1721 184 261 95   72       1 70   1232 1172                 2404
365616 SD     school 4666270 49005   Sioux Falls 49-5 466627001275 15 Rosa Parks Elementary   Regular School No Elementary KG 05 2019   k_12_total 298.0 114.0 100.0 33.0   42.0       1.0 43.0   321.0 310.0       25.4               631.0 298 114 100 33   42       1 43   321 310                 631
365624 SD     school 4666270 49005   Sioux Falls 49-5 466627000610 1 Washington High School   Regular School No High 09 12 2019   k_12_total 1050.0 357.0 238.0 76.0   137.0       1.0 61.0   1000.0 920.0       16.0               1920.0 1050 357 238 76   137       1 61   1000 920                 1920
365625 SD     school 4666270 49005   Sioux Falls 49-5 466627000611 8 Whittier Middle School   Regular School No Middle 06 08 2019   k_12_total 333.0 238.0 181.0 63.0   89.0       1.0 57.0   507.0 455.0       20.2               962.0 333 238 181 63   89       1 57   507 455                 962
366009 SD     school 4666930 40002   Spearfish 40-2 466693000401 7 Creekside Elem   Regular School No Elementary 03 05 2019   k_12_total 513.0 8.0 30.0 12.0   4.0       1.0 15.0   311.0 272.0       1.4               583.0 513 8 30 12   4       1 15   311 272                 583
366013 SD     school 4666930 40002   Spearfish 40-2 466693000623 1 Spearfish High School   Regular School No High 09 12 2019   k_12_total 579.0 3.0 33.0 20.0   9.0       1.0 9.0   320.0 334.0       0.8               654.0 579 3 33 20   9       1 9   320 334                 654
366392 SD     school 4672090 66001   Todd County 66-1 467209000669 5 He Dog School   Regular School No Elementary KG 08 2019   k_12_total     5.0 157.0           1.0     91.0 72.0       1.8               163.0     5 157           1     91 72                 163
366394 SD     school 4672090 66001   Todd County 66-1 467209000504 9 Lakeview Elementary   Regular School No Elementary KG 08 2019   k_12_total 8.0   1.0 27.0   2.0       1.0     21.0 18.0       2.6               39.0 8   1 27   2       1     21 18                 39
367086 SD     school 4676740 14005   Waverly 14-5 467674000946 3 Waverly/South Shore Middle School   Regular School No Middle 06 08 2019   k_12_total 50.0     1.0           1.0     32.0 20.0       0.0               52.0 50     1           1     32 20                 52
367134 SD     school 4676990 18005   Webster Area 467699000947 2 Webster Area Middle School   Regular School No Middle 06 08 2019   k_12_total 105.0   2.0 3.0           1.0 6.0   62.0 55.0       0.0               117.0 105   2 3           1 6   62 55                 117
367356 SD     school 4678510 1003   White Lake 01-3 467851000745 2 White Lake Elementary   Regular School No Elementary PK 06 2019   k_12_total 67.0 1.0 2.0             1.0     38.0 33.0       0.0               71.0 67 1 2             1     38 33                 71
367417 SD     school 4678570 47001   White River 47-1 467857000753 2 White River Elementary   Regular School No Elementary PK 05 2019   k_12_total 7.0   1.0 135.0           1.0 6.0   83.0 67.0       0.0               150.0 7   1 135           1 6   83 67                 150
367418 SD     school 4678570 47001   White River 47-1 467857000754 1 White River High School   Regular School No High 09 12 2019   k_12_total 19.0 2.0   86.0           1.0 2.0   55.0 55.0       0.9               110.0 19 2   86           1 2   55 55                 110
357169 SD     school 4602070 6001   Aberdeen 06-1 460207000003 1 Central High School   Regular School No High 09 12 2019   k_12_total 1057.0 32.0 65.0 94.0   34.0       2.0 22.0   639.0 667.0       3.3               1306.0 1057 32 65 94   34       2 22   639 667                 1306
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
357788 SD     school 4606360 61002   Beresford 61-2 460636000047 2 Beresford Elementary   Regular School No Elementary KG 05 2019   k_12_total 256.0 3.0 15.0 2.0           2.0 2.0   140.0 140.0       3.6               280.0 256 3 15 2           2 2   140 140                 280
358446 SD     school 4609512 26002   Burke 26-2 460951201043 4 Burke Middle School   Regular School No Middle 06 08 2019   k_12_total 60.0 1.0 3.0 7.0           2.0     38.0 35.0       0.0               73.0 60 1 3 7           2     38 35                 73
359129 SD     school 4616950 16001   Custer 16-1 461695000155 1 Custer High School   Regular School No High 09 12 2019   k_12_total 238.0 7.0 16.0 15.0           2.0 7.0   139.0 146.0       0.7               285.0 238 7 16 15           2 7   139 146                 285
359885 SD     school 4621340 61007   Elk Point-Jefferson 61-7 462134000186 1 Elk Point Jefferson High School   Regular School No High 09 12 2019   k_12_total 177.0 2.0 12.0             2.0 2.0   93.0 102.0       0.0               195.0 177 2 12             2 2   93 102                 195
361712 SD     school 4635480 2002   Huron 02-2 463548001369 19 Madison 2-3 Center   Regular School No Elementary 02 03 2019   k_12_total 183.0 9.0 146.0 10.0   100.0       2.0 14.0   254.0 210.0       44.4               464.0 183 9 146 10   100       2 14   254 210                 464
363358 SD     school 4648390 17002   Mitchell 17-2 464839000441 5 Longfellow Elementary   Regular School No Elementary KG 05 2019   k_12_total 248.0 3.0 36.0 35.0           2.0 12.0   168.0 168.0       6.0               336.0 248 3 36 35           2 12   168 168                 336
363596 SD     school 4650670 51003   New Underwood 51-3 465067000463 2 New Underwood Elem   Regular School No Elementary KG 06 2019   k_12_total 86.0   4.0 5.0           2.0 15.0   58.0 54.0       0.0               112.0 86   4 5           2 15   58 54                 112
364634 SD     school 4659820 51004   Rapid City Area 51-4 465982000548 6 Grandview Elem   Regular School No Elementary KG 05 2019   k_12_total 316.0 13.0 32.0 58.0   7.0       2.0 24.0   260.0 192.0       1.1               452.0 316 13 32 58   7       2 24   260 192                 452
365592 SD     school 4666270 49005   Sioux Falls 49-5 466627001238 26 Discovery Elementary   Regular School No Elementary PK 05 2019   k_12_total 681.0 71.0 64.0 5.0   18.0       2.0 44.0   433.0 452.0       9.0               885.0 681 71 64 5   18       2 44   433 452                 885
365605 SD     school 4666270 49005   Sioux Falls 49-5 466627000598 31 Laura Wilder Elementary   Regular School No Elementary KG 05 2019   k_12_total 321.0 55.0 55.0 46.0   6.0       2.0 51.0   279.0 257.0       2.8               536.0 321 55 55 46   6       2 51   279 257                 536
365608 SD     school 4666270 49005   Sioux Falls 49-5 466627001070 4 Memorial Middle School   Regular School No Middle 06 08 2019   k_12_total 1089.0 83.0 70.0 23.0   28.0       2.0 62.0   655.0 702.0       1.5               1357.0 1089 83 70 23   28       2 62   655 702                 1357
365612 SD     school 4666270 49005   Sioux Falls 49-5 466627001300 17 R. F. Pettigrew Elementary   Regular School No Elementary PK 05 2019   k_12_total 705.0 30.0 40.0 8.0   13.0       2.0 50.0   427.0 421.0       1.1               848.0 705 30 40 8   13       2 50   427 421                 848
359604 SD     school 4619410 51001   Douglas 51-1 461941000174 3 Douglas High School   Regular School No High 09 12 2019   k_12_total 545.0 16.0 47.0 57.0   11.0       3.0 68.0   386.0 361.0       0.3               747.0 545 16 47 57   11       3 68   386 361                 747
361500 SD     school 4634480 23002   Hot Springs 23-2 463448000287 2 Hot Springs Elementary   Regular School No Elementary PK 05 2019   k_12_total 229.0   18.0 29.0   4.0       3.0 55.0   187.0 151.0       0.3               338.0 229   18 29   4       3 55   187 151                 338
363256 SD     school 4647942 29004   Miller 464794200429 2 Miller Elementary School   Regular School No Elementary KG 06 2019   k_12_total 242.0 5.0 4.0 3.0           3.0 1.0   131.0 127.0       0.4               258.0 242 5 4 3           3 1   131 127                 258
363359 SD     school 4648390 17002   Mitchell 17-2 464839000442 1 Mitchell High School   Regular School No High 09 12 2019   k_12_total 692.0 8.0 38.0 30.0   11.0       3.0 19.0   410.0 391.0       1.1               801.0 692 8 38 30   11       3 19   410 391                 801
365622 SD     school 4666270 49005   Sioux Falls 49-5 466627001351 66 Susan B. Anthony Elementary   Regular School No Elementary KG 05 2019   k_12_total 264.0 69.0 81.0 12.0   17.0       3.0 33.0   261.0 218.0       20.9               479.0 264 69 81 12   17       3 33   261 218                 479
366089 SD     school 4624850 57001   Stanley County 57-1 462485000213 8 Stanley County Elementary   Regular School No Elementary KG 05 2019   k_12_total 132.0   4.0 31.0           3.0 19.0   98.0 91.0       0.0               189.0 132   4 31           3 19   98 91                 189
367300 SD     school 4631710 49007   West Central 49-7 463171001389 8 Falls Academy   Alternative School No High 08 12 2019   k_12_total 9.0 1.0   7.0           3.0 1.0   17.0 4.0       0.0               21.0 9 1   7           3 1   17 4                 21
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
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
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
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
357168 SD     school 4602070 6001   Aberdeen 06-1 460207000002 5 C.C. Lee Elementary   Regular School No Elementary KG 05 2019   k_12_total 332.0 8.0 8.0 12.0   4.0         21.0   208.0 177.0       1.0               385.0 332 8 8 12   4         21   208 177                 385
357171 SD     school 4602070 6001   Aberdeen 06-1 460207000007 8 Lincoln Elementary   Regular School No Elementary PK 05 2019   k_12_total 210.0 2.0 32.0 22.0   28.0         14.0   165.0 143.0       12.0               308.0 210 2 32 22   28         14   165 143                 308
357174 SD     school 4602070 6001   Aberdeen 06-1 460207001130 89 New Beginnings   Alternative School No High 05 12 2019   k_12_total 1.0 2.0   11.0                 5.0 9.0       14.3               14.0 1 2   11                 5 9                 14
357256 SD     school 4600042 58003   Agar-Blunt-Onida 58-3 460004200855 3 Blunt Elementary   Regular School No Elementary KG 05 2019   k_12_total 24.0 1.0 3.0 4.0             3.0   19.0 16.0       8.6               35.0 24 1 3 4             3   19 16                 35
357257 SD     school 4600042 58003   Agar-Blunt-Onida 58-3 460004200655 4 Onida Elementary   Regular School No Elementary KG 06 2019   k_12_total 96.0   8.0 3.0   1.0         3.0   58.0 53.0       7.2               111.0 96   8 3   1         3   58 53                 111
357258 SD     school 4600042 58003   Agar-Blunt-Onida 58-3 460004200656 7 Sully Buttes High School   Regular School No High 09 12 2019   k_12_total 62.0   1.0 5.0             7.0   46.0 29.0       0.0               75.0 62   1 5             7   46 29                 75
357259 SD     school 4600042 58003   Agar-Blunt-Onida 58-3 460004200939 6 Sully Buttes Junior High   Regular School No Middle 07 08 2019   k_12_total 37.0 1.0 4.0 1.0             1.0   18.0 26.0       4.6               44.0 37 1 4 1             1   18 26                 44

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