Data source: Big Local News · About: Big Local

671 rows where grade = "k_12_total", state = "SD" and year = 2018 sorted by black_int

View and edit SQL

year

  • 2018 · 571

grade

  • k_12_total · 571
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
251638 SD     school 4612940 12002   Clark 12-2 461294000133 1 Clark High School   Regular School No High 09 12 2018   k_12_total 53.0 2.0 4.0     1.0       1.0     29.0 32.0       1.6               61.0 53 2 4     1       1     29 32                 61
251639 SD     school 4612940 12002   Clark 12-2 461294000890 3 Clark Middle School   Regular School No Middle 05 08 2018   k_12_total 71.0 2.0 5.0                   45.0 33.0       2.6               78.0 71 2 5                   45 33                 78
251697 SD     school 4614100 50005   Colman-Egan 50-5 461410000093 3 Colman Elem   Regular School No Elementary PK 06 2018   k_12_total 125.0 2.0 1.0               2.0   62.0 68.0       0.0               130.0 125 2 1               2   62 68                 130
251870 SD     school 4616950 16001   Custer 16-1 461695000155 1 Custer High School   Regular School No High 09 12 2018   k_12_total 214.0 2.0 12.0 7.0           1.0 4.0   115.0 125.0       0.8               240.0 214 2 12 7           1 4   115 125                 240
251871 SD     school 4616950 16001   Custer 16-1 461695000992 5 Custer JH   Regular School No Middle 07 08 2018   k_12_total 92.0 2.0 7.0 5.0             2.0   48.0 60.0       0.0               108.0 92 2 7 5             2   48 60                 108
251936 SD     school 4636990 61008   Dakota Valley 61-8 463699001075 4 Dakota Valley Upper Elem   Regular School No Elementary 04 05 2018   k_12_total 180.0 2.0 14.0 1.0   3.0         13.0   103.0 110.0       1.9               213.0 180 2 14 1   3         13   103 110                 213
252034 SD     school 4618120 49003   Dell Rapids 49-3 461812000165 1 Dell Rapids High School   Regular School No High 09 12 2018   k_12_total 259.0 2.0 3.0 10.0   1.0         4.0   148.0 131.0       0.4               279.0 259 2 3 10   1         4   148 131                 279
252161 SD     school 4600036 19004   Deuel 19-4 460003601011 2 Clear Lake Elementary   Regular School No Elementary PK 05 2018   k_12_total 220.0 2.0 16.0 5.0           1.0     134.0 110.0       1.2               244.0 220 2 16 5           1     134 110                 244
253103 SD     school 4624390 50003   Flandreau 50-3 462439000205 3 Flandreau Middle Sch   Regular School No Middle 06 08 2018   k_12_total 77.0 2.0 8.0 49.0   2.0       3.0 3.0   76.0 68.0       0.0               144.0 77 2 8 49   2       3 3   76 68                 144
253273 SD     school 4625500 33001   Freeman 33-1 462550000219 2 Freeman Elem   Regular School No Elementary KG 06 2018   k_12_total 127.0 2.0 15.0 1.0   1.0         3.0   69.0 80.0       6.7               149.0 127 2 15 1   1         3   69 80                 149
253330 SD     school 4626370 49004   Garretson 49-4 462637000224 1 Garretson High School   Regular School No High 09 12 2018   k_12_total 137.0 2.0 11.0 2.0   1.0         6.0   89.0 70.0       0.6               159.0 137 2 11 2   1         6   89 70                 159
254002 SD     school 4632340 14002   Henry 14-2 463234000276 1 Henry High School   Regular School No High 09 12 2018   k_12_total 54.0 2.0   1.0                 29.0 28.0       0.0               57.0 54 2   1                 29 28                 57
254481 SD     school 4635480 2002   Huron 02-2 463548001370 18 Buchanan K-1 Center   Regular School No Elementary KG 01 2018   k_12_total 177.0 2.0 162.0 7.0   111.0       1.0 18.0   254.0 224.0       45.8               478.0 177 2 162 7   111       1 18   254 224                 478
255104 SD     school 4641300 40001   Lead-Deadwood 40-1 464130000373 2 Lead-Deadwood Middle School   Regular School No Middle 06 08 2018   k_12_total 143.0 2.0 11.0 6.0   1.0         11.0   95.0 79.0       0.6               174.0 143 2 11 6   1         11   95 79                 174
255225 SD     school 4641550 41004   Lennox 41-4 464155000386 2 Lennox Elementary   Regular School No Elementary PK 04 2018   k_12_total 331.0 2.0 7.0 3.0   1.0         11.0   179.0 176.0       0.3               355.0 331 2 7 3   1         11   179 176                 355
255602 SD     school 4646260 15001   McIntosh 15-1 464626000411 1 McIntosh High School   Regular School No High 09 12 2018   k_12_total 34.0 2.0 1.0 14.0   1.0         1.0   26.0 27.0       0.0               53.0 34 2 1 14   1         1   26 27                 53
255798 SD     school 4669930 46001   Meade 46-1 466993000644 5 Piedmont Valley Elementary   Regular School No Elementary KG 06 2018   k_12_total 573.0 2.0 26.0 18.0   2.0         26.0   332.0 315.0       0.0               647.0 573 2 26 18   2         26   332 315                 647
256189 SD     school 4680441 62006   Mobridge-Pollock 62-6 468044100486 3 Freeman Davis Elementary   Regular School No Elementary KG 02 2018   k_12_total 67.0 2.0 4.0 59.0   2.0             66.0 68.0       0.0               134.0 67 2 4 59   2             66 68                 134
256255 SD     school 4648780 43002   Montrose 43-2 464878000966 3 Montrose Middle School   Regular School No Middle 06 08 2018   k_12_total 42.0 2.0 1.0     1.0             20.0 26.0       2.2               46.0 42 2 1     1             20 26                 46
256305 SD     school 4649650 17003   Mount Vernon 17-3 464965000454 2 Mount Vernon Elementary   Regular School No Elementary PK 05 2018   k_12_total 89.0 2.0 1.0 2.0                 50.0 44.0       0.0               94.0 89 2 1 2                 50 44                 94
256791 SD     school 4654300 33003   Parkston 33-3 465430001132 88 Our Home   Alternative School No High 05 12 2018   k_12_total 15.0 2.0 1.0 13.0                 7.0 24.0       0.0               31.0 15 2 1 13                 7 24                 31
256873 SD     school 4655260 32002   Pierre 32-2 465526000494 3 Buchanan Elementary   Regular School No Elementary KG 05 2018   k_12_total 319.0 2.0 17.0 66.0   7.0         45.0   232.0 224.0       0.9               456.0 319 2 17 66   7         45   232 224                 456
256877 SD     school 4655260 32002   Pierre 32-2 465526000500 1 T F Riggs High School   Regular School No High 09 12 2018   k_12_total 560.0 2.0 35.0 90.0   6.0       1.0 33.0   365.0 362.0       0.8               727.0 560 2 35 90   6       1 33   365 362                 727
257377 SD     school 4659820 51004   Rapid City Area 51-4 465982000530 17 Woodrow Wilson Elem   Regular School No Elementary KG 05 2018   k_12_total 212.0 2.0 27.0 70.0   7.0       1.0 34.0   170.0 183.0       0.9               353.0 212 2 27 70   7       1 34   170 183                 353
258322 SD     school 4666270 49005   Sioux Falls 49-5 466627001128 50 All City Elementary   Regular School No Elementary KG 05 2018   k_12_total 140.0 2.0 4.0               2.0   82.0 66.0       0.7               148.0 140 2 4               2   82 66                 148
258787 SD     school 4666930 40002   Spearfish 40-2 466693000622 5 Spearfish MS   Regular School No Middle 06 08 2018   k_12_total 503.0 2.0 36.0 25.0   3.0       1.0 17.0   302.0 285.0       0.3               587.0 503 2 36 25   3       1 17   302 285                 587
259456 SD     school 4674520 60006   Viborg-Hurley 60-6 467452000961 3 Viborg-Hurley Middle School   Regular School No Middle 05 08 2018   k_12_total 82.0 2.0                 2.0   46.0 40.0       0.0               86.0 82 2                 2   46 40                 86
259582 SD     school 4675660 51005   Wall 51-5 467566000704 2 Wall Elementary School   Regular School No Elementary KG 05 2018   k_12_total 103.0 2.0 1.0 14.0   1.0         1.0   57.0 65.0       0.0               122.0 103 2 1 14   1         1   57 65                 122
259633 SD     school 4676020 6005   Warner 06-5 467602000708 2 Warner Elementary School   Regular School No Elementary KG 05 2018   k_12_total 140.0 2.0 2.0 2.0             5.0   73.0 78.0       0.0               151.0 140 2 2 2             5   73 78                 151
259634 SD     school 4676020 6005   Warner 06-5 467602000709 1 Warner Hi Sch   Regular School No High 09 12 2018   k_12_total 86.0 2.0 1.0 4.0   1.0             49.0 45.0       1.1               94.0 86 2 1 4   1             49 45                 94
259742 SD     school 4676620 14004   Watertown 14-4 467662000944 5 Lincoln Elementary School   Regular School No Elementary KG 04 2018   k_12_total 355.0 2.0 11.0 5.0   7.0         6.0   199.0 187.0       2.3               386.0 355 2 11 5   7         6   199 187                 386
260045 SD     school 4631710 49007   West Central 49-7 463171000777 5 West Central Hartford Elem   Regular School No Elementary KG 02 2018   k_12_total 229.0 2.0 7.0 2.0             7.0   127.0 120.0       0.4               247.0 229 2 7 2             7   127 120                 247
260160 SD     school 4678570 47001   White River 47-1 467857000951 4 White River Middle Sch   Regular School No Middle 06 08 2018   k_12_total 5.0 2.0 2.0 87.0             5.0   52.0 49.0       2.0               101.0 5 2 2 87             5   52 49                 101
260305 SD     school 4600003 54007   Wilmot 54-7 460000300757 2 Wilmot Elem   Regular School No Elementary PK 06 2018   k_12_total 78.0 2.0 3.0 34.0             1.0   61.0 57.0       0.0               118.0 78 2 3 34             1   61 57                 118
260401 SD     school 4680100 2006   Wolsey-Wessington 02-6 468010000783 2 Wolsey-Wessington Elementary   Regular School No Elementary PK 04 2018   k_12_total 115.0 2.0 13.0               3.0   67.0 66.0       2.3               133.0 115 2 13               3   67 66                 133
250945 SD     school 4621420 30003   Bridgewater-Emery 30-3 462142010071 2 Bridgewater-Emery Elementary   Regular School No Elementary PK 05 2018   k_12_total 135.0 3.0 14.0                   89.0 63.0       2.6               152.0 135 3 14                   89 63                 152
251282 SD     school 4610560 41001   Canton 41-1 461056000831 4 Canton Middle School   Regular School No Middle 06 08 2018   k_12_total 192.0 3.0 4.0 1.0   1.0         6.0   109.0 98.0       0.5               207.0 192 3 4 1   1         6   109 98                 207
251442 SD     school 4612000 7001   Chamberlain 07-1 461200000119 1 Chamberlain High School   Regular School No High 09 12 2018   k_12_total 134.0 3.0 13.0 98.0   3.0         4.0   129.0 126.0       0.4               255.0 134 3 13 98   3         4   129 126                 255
251933 SD     school 4636990 61008   Dakota Valley 61-8 463699000251 2 Dakota Valley Elementary School   Regular School No Elementary KG 03 2018   k_12_total 332.0 3.0 27.0 1.0   15.0         18.0   204.0 192.0       1.0               396.0 332 3 27 1   15         18   204 192                 396
252642 SD     school 4621340 61007   Elk Point-Jefferson 61-7 462134000186 1 Elk Point Jefferson High School   Regular School No High 09 12 2018   k_12_total 190.0 3.0 7.0     1.0       2.0 2.0   104.0 101.0       0.0               205.0 190 3 7     1       2 2   104 101                 205
253522 SD     school 4600045 6006   Groton Area 460004501155 1 Groton Area High School   Regular School No High 09 12 2018   k_12_total 157.0 3.0 2.0 2.0   1.0             73.0 92.0       0.0               165.0 157 3 2 2   1             73 92                 165
253633 SD     school 4630800 28003   Hamlin 28-3 463080001111 9 Hamlin Elementary   Regular School No Elementary PK 05 2018   k_12_total 373.0 3.0 8.0 2.0   1.0         3.0   219.0 171.0       1.5               390.0 373 3 8 2   1         3   219 171                 390
253931 SD     school 4631350 41002   Harrisburg 41-2 463135001318 6 Freedom Elementary   Regular School No Elementary KG 05 2018   k_12_total 405.0 3.0 12.0 1.0   2.0       1.0 18.0   214.0 228.0       1.6               442.0 405 3 12 1   2       1 18   214 228                 442
254383 SD     school 4600025 48003   Howard 48-3 460002500913 5 Howard Jr Hi   Regular School No Middle 07 08 2018   k_12_total 52.0 3.0 1.0               2.0   33.0 25.0       0.0               58.0 52 3 1               2   33 25                 58
255601 SD     school 4646260 15001   McIntosh 15-1 464626000410 2 McIntosh Elementary   Regular School No Elementary PK 06 2018   k_12_total 52.0 3.0 3.0 31.0             10.0   49.0 50.0       0.0               99.0 52 3 3 31             10   49 50                 99
255800 SD     school 4669930 46001   Meade 46-1 466993000637 3 Sturgis Elementary   Regular School No Elementary KG 04 2018   k_12_total 508.0 3.0 26.0 18.0   5.0         27.0   313.0 274.0       0.3               587.0 508 3 26 18   5         27   313 274                 587
256115 SD     school 4648390 17002   Mitchell 17-2 464839000441 5 Longfellow Elementary   Regular School No Elementary KG 05 2018   k_12_total 269.0 3.0 27.0 33.0             15.0   172.0 175.0       3.5               347.0 269 3 27 33             15   172 175                 347
256192 SD     school 4680441 62006   Mobridge-Pollock 62-6 468044100493 4 Mobridge Upper Elementary   Regular School No Elementary 03 05 2018   k_12_total 89.0 3.0 6.0 45.0   1.0             66.0 78.0       0.0               144.0 89 3 6 45   1             66 78                 144
256402 SD     school 4650850 9002   Newell 09-2 465085000469 1 Newell High School   Regular School No High 09 12 2018   k_12_total 87.0 3.0 1.0 1.0           1.0 1.0   52.0 42.0       0.0               94.0 87 3 1 1           1 1   52 42                 94
256403 SD     school 4650850 9002   Newell 09-2 465085000968 4 Newell Middle Sch   Regular School No Middle 06 08 2018   k_12_total 63.0 3.0 1.0 9.0   3.0         2.0   49.0 32.0       0.0               81.0 63 3 1 9   3         2   49 32                 81
256875 SD     school 4655260 32002   Pierre 32-2 465526000495 6 Jefferson Elementary   Regular School No Elementary KG 05 2018   k_12_total 287.0 3.0 28.0 82.0             40.0   244.0 196.0       0.0               440.0 287 3 28 82             40   244 196                 440
257356 SD     school 4659820 51004   Rapid City Area 51-4 465982000542 21 Corral Drive Elem   Regular School No Elementary KG 05 2018   k_12_total 431.0 3.0 9.0 7.0   13.0         7.0   238.0 232.0       0.4               470.0 431 3 9 7   13         7   238 232                 470
257368 SD     school 4659820 51004   Rapid City Area 51-4 465982000823 12 Rapid Valley Elem   Regular School No Elementary PK 05 2018   k_12_total 415.0 3.0 25.0 53.0   1.0       2.0 48.0   259.0 288.0       0.0               547.0 415 3 25 53   1       2 48   259 288                 547
257370 SD     school 4659820 51004   Rapid City Area 51-4 465982000527 15 South Canyon Elem   Regular School No Elementary KG 05 2018   k_12_total 213.0 3.0 23.0 32.0   1.0       1.0 12.0   146.0 139.0       0.4               285.0 213 3 23 32   1       1 12   146 139                 285
257504 SD     school 4660450 56004   Redfield 56-4 466045000858 2 Redfield Junior High School   Regular School No Middle 07 08 2018   k_12_total 93.0 3.0 2.0 2.0                 55.0 45.0       0.0               100.0 93 3 2 2                 55 45                 100
258356 SD     school 4666270 49005   Sioux Falls 49-5 466627001138 12 Structured Teaching Program   Special Education School No High 06 12 2018   k_12_total 9.0 3.0   4.0             1.0   15.0 2.0       11.8               17.0 9 3   4             1   15 2                 17
258358 SD     school 4666270 49005   Sioux Falls 49-5 466627000609 40 Summit Oaks Day Program   Special Education School No Other KG 12 2018   k_12_total 8.0 3.0 3.0                   10.0 4.0       0.0               14.0 8 3 3                   10 4                 14
258359 SD     school 4666270 49005   Sioux Falls 49-5 466627001133 48 Summit Oaks Residential Program   Alternative School No Other KG 12 2018   k_12_total 13.0 3.0   11.0             1.0   11.0 17.0       0.0               28.0 13 3   11             1   11 17                 28
258577 SD     school 4600053 54002   Sisseton 54-2 460005301239 1 Sisseton High School   Regular School No High 09 12 2018   k_12_total 96.0 3.0 10.0 99.0   1.0         10.0   126.0 93.0       0.9               219.0 96 3 10 99   1         10   126 93                 219
259454 SD     school 4674520 60006   Viborg-Hurley 60-6 467452000692 2 Viborg-Hurley Elementary   Regular School No Elementary PK 04 2018   k_12_total 114.0 3.0 4.0 2.0           1.0 3.0   58.0 69.0       1.6               127.0 114 3 4 2           1 3   58 69                 127
259745 SD     school 4676620 14004   Watertown 14-4 467662000716 8 Roosevelt Elementary   Regular School No Elementary PK 04 2018   k_12_total 181.0 3.0 8.0 12.0   1.0       1.0 15.0   126.0 95.0       1.4               221.0 181 3 8 12   1       1 15   126 95                 221
259747 SD     school 4676620 14004   Watertown 14-4 467662001378 13 Watertown Intermediate   Regular School No Middle 05 06 2018   k_12_total 543.0 3.0 27.0 21.0   8.0         27.0   316.0 313.0       0.8               629.0 543 3 27 21   8         27   316 313                 629
260354 SD     school 4679710 59002   Winner 59-2 467971000781 1 Winner High School   Regular School No High 09 12 2018   k_12_total 147.0 3.0 1.0 45.0   2.0       1.0     99.0 100.0       0.5               199.0 147 3 1 45   2       1     99 100                 199
260520 SD     school 4680430 63003   Yankton 63-3 468043001009 6 Webster Elem   Regular School No Elementary PK 05 2018   k_12_total 139.0 3.0 21.0 18.0   2.0         5.0   99.0 89.0       3.2               188.0 139 3 21 18   2         5   99 89                 188
249928 SD     school 4602070 6001   Aberdeen 06-1 460207000007 8 Lincoln Elementary   Regular School No Elementary PK 05 2018   k_12_total 239.0 4.0 33.0 31.0   27.0       3.0 11.0   185.0 163.0       8.1               348.0 239 4 33 31   27       3 11   185 163                 348
251029 SD     school 4600041 45004   Britton-Hecla 45-4 460004101140 2 Britton-Hecla Elementary School   Regular School No Elementary KG 06 2018   k_12_total 191.0 4.0 8.0 2.0   1.0         8.0   103.0 111.0       0.0               214.0 191 4 8 2   1         8   103 111                 214
251233 SD     school 4610320 43001   Canistota 43-1 461032000104 2 Canistota Elementary School   Regular School No Elementary PK 05 2018   k_12_total 94.0 4.0 5.0                   57.0 46.0       0.0               103.0 94 4 5                   57 46                 103
251987 SD     school 4617850 38002   De Smet 38-2 461785000162 2 Laura Ingalls Wilder Elem   Regular School No Elementary PK 05 2018   k_12_total 144.0 4.0   3.0             1.0   84.0 68.0       0.7               152.0 144 4   3             1   84 68                 152
253936 SD     school 4631350 41002   Harrisburg 41-2 463135001288 5 Journey Elementary   Regular School No Elementary KG 05 2018   k_12_total 369.0 4.0 7.0 4.0   8.0         7.0   199.0 200.0       2.5               399.0 369 4 7 4   8         7   199 200                 399
254485 SD     school 4635480 2002   Huron 02-2 463548001369 19 Madison 2-3 Center   Regular School No Elementary 02 03 2018   k_12_total 190.0 4.0 126.0 7.0   92.0         13.0   245.0 187.0       41.7               432.0 190 4 126 7   92         13   245 187                 432
255102 SD     school 4641300 40001   Lead-Deadwood 40-1 464130000372 3 Lead-Deadwood Elementary   Regular School No Elementary KG 05 2018   k_12_total 274.0 4.0 14.0 8.0   5.0       1.0 11.0   162.0 155.0       0.3               317.0 274 4 14 8   5       1 11   162 155                 317
255228 SD     school 4641550 41004   Lennox 41-4 464155000963 8 Lennox Jr. High   Regular School No Middle 07 08 2018   k_12_total 166.0 4.0 5.0 3.0             4.0   88.0 94.0       0.0               182.0 166 4 5 3             4   88 94                 182
255441 SD     school 4639600 39002   Madison Central 39-2 463960001189 7 Madison Elementary School   Regular School No Elementary KG 05 2018   k_12_total 452.0 4.0 55.0 8.0   3.0         21.0   270.0 273.0       1.8               543.0 452 4 55 8   3         21   270 273                 543
255802 SD     school 4669930 46001   Meade 46-1 466993000653 2 Sturgis Williams MS   Regular School No Middle 06 08 2018   k_12_total 477.0 4.0 23.0 33.0   1.0         27.0   285.0 280.0       0.0               565.0 477 4 23 33   1         27   285 280                 565
256954 SD     school 4655710 1001   Plankinton 01-1 465571001276 4 Aurora Plains Academy Middle School   Alternative School No Middle 04 08 2018   k_12_total 13.0 4.0 2.0 6.0                 22.0 3.0       0.0               25.0 13 4 2 6                 22 3                 25
257353 SD     school 4659820 51004   Rapid City Area 51-4 465982000538 3 Black Hawk Elem   Regular School No Elementary KG 05 2018   k_12_total 314.0 4.0 17.0 28.0             31.0   194.0 200.0       0.0               394.0 314 4 17 28             31   194 200                 394
258326 SD     school 4666270 49005   Sioux Falls 49-5 466627001129 51 Challenge Center   Regular School No Elementary 02 05 2018   k_12_total 126.0 4.0 4.0 1.0   13.0         8.0   85.0 71.0       0.6               156.0 126 4 4 1   13         8   85 71                 156
258328 SD     school 4666270 49005   Sioux Falls 49-5 466627001122 41 Community Campus   Special Education School No High 12 12 2018   k_12_total 21.0 4.0 1.0 2.0   2.0             18.0 12.0       3.3               30.0 21 4 1 2   2             18 12                 30
258357 SD     school 4666270 49005   Sioux Falls 49-5 466627001121 39 Success Academy   Special Education School No High 06 12 2018   k_12_total 12.0 4.0 1.0                   16.0 1.0       0.0               17.0 12 4 1                   16 1                 17
258786 SD     school 4666930 40002   Spearfish 40-2 466693000623 1 Spearfish High School   Regular School No High 09 12 2018   k_12_total 561.0 4.0 27.0 13.0   10.0         11.0   312.0 314.0       0.2               626.0 561 4 27 13   10         11   312 314                 626
259392 SD     school 4674370 13001   Vermillion 13-1 467437000690 2 Vermillion Middle School   Regular School No Middle 06 08 2018   k_12_total 220.0 4.0 13.0 31.0   8.0         12.0   146.0 142.0       1.0               288.0 220 4 13 31   8         12   146 142                 288
260048 SD     school 4631710 49007   West Central 49-7 463171000909 4 West Central MS   Regular School No Middle 06 08 2018   k_12_total 296.0 4.0 4.0 9.0   1.0         7.0   172.0 149.0       0.3               321.0 296 4 4 9   1         7   172 149                 321
260403 SD     school 4680100 2006   Wolsey-Wessington 02-6 468010000546 3 Wolsey-Wessington Middle School   Regular School No Middle 05 08 2018   k_12_total 96.0 4.0 13.0               7.0   51.0 69.0       3.3               120.0 96 4 13               7   51 69                 120
260518 SD     school 4680430 63003   Yankton 63-3 468043000793 4 Lincoln Elem   Regular School No Elementary KG 05 2018   k_12_total 298.0 4.0 25.0 18.0   2.0         13.0   179.0 181.0       3.3               360.0 298 4 25 18   2         13   179 181                 360
249930 SD     school 4602070 6001   Aberdeen 06-1 460207001367 7 Mike Miller Elementary   Regular School No Elementary KG 05 2018   k_12_total 173.0 5.0 11.0 23.0   12.0       1.0 10.0   120.0 115.0       6.8               235.0 173 5 11 23   12       1 10   120 115                 235
250257 SD     school 4603780 21001   Armour 21-1 460378000023 2 Armour Elementary   Regular School No Elementary KG 05 2018   k_12_total 63.0 5.0 1.0 1.0             2.0   46.0 26.0       0.0               72.0 63 5 1 1             2   46 26                 72
256113 SD     school 4648390 17002   Mitchell 17-2 464839000591 4 Gertie Belle Rogers Elem   Regular School No Elementary KG 05 2018   k_12_total 343.0 5.0 18.0 48.0   2.0         8.0   211.0 213.0       1.2               424.0 343 5 18 48   2         8   211 213                 424
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
256874 SD     school 4655260 32002   Pierre 32-2 465526000501 2 Georgia Morse Middle School   Regular School No Middle 06 08 2018   k_12_total 458.0 5.0 31.0 79.0   2.0         56.0   318.0 313.0       0.3               631.0 458 5 31 79   2         56   318 313                 631
256953 SD     school 4655710 1001   Plankinton 01-1 465571001274 5 Aurora Plains Academy High School   Alternative School No High 09 12 2018   k_12_total 18.0 5.0 3.0 15.0             4.0   25.0 20.0       2.2               45.0 18 5 3 15             4   25 20                 45
257359 SD     school 4659820 51004   Rapid City Area 51-4 465982000548 6 Grandview Elem   Regular School No Elementary KG 05 2018   k_12_total 349.0 5.0 22.0 69.0   4.0       1.0 22.0   262.0 210.0       0.4               472.0 349 5 22 69   4       1 22   262 210                 472
257369 SD     school 4659820 51004   Rapid City Area 51-4 465982000541 14 Robbinsdale Elem   Regular School No Elementary PK 05 2018   k_12_total 239.0 5.0 52.0 124.0   7.0       1.0 62.0   262.0 228.0       0.8               490.0 239 5 52 124   7       1 62   262 228                 490
257371 SD     school 4659820 51004   Rapid City Area 51-4 465982000533 36 South Middle Sch   Regular School No Middle 06 08 2018   k_12_total 397.0 5.0 58.0 165.0   3.0         44.0   343.0 329.0       0.3               672.0 397 5 58 165   3         44   343 329                 672
257373 SD     school 4659820 51004   Rapid City Area 51-4 465982000457 38 Southwest Middle Sch   Regular School No Middle 06 08 2018   k_12_total 554.0 5.0 35.0 31.0   15.0         20.0   329.0 331.0       0.9               660.0 554 5 35 31   15         20   329 331                 660
257376 SD     school 4659820 51004   Rapid City Area 51-4 465982000822 37 West Middle Sch   Regular School No Middle 06 08 2018   k_12_total 515.0 5.0 56.0 35.0   6.0         39.0   353.0 303.0       0.6               656.0 515 5 56 35   6         39   353 303                 656
258788 SD     school 4666930 40002   Spearfish 40-2 466693000392 3 West Elementary   Regular School No Elementary 01 02 2018   k_12_total 315.0 5.0 18.0 9.0   5.0         13.0   195.0 170.0       0.8               365.0 315 5 18 9   5         13   195 170                 365
259389 SD     school 4674370 13001   Vermillion 13-1 467437000300 3 Austin Elementary School   Regular School No Elementary PK 01 2018   k_12_total 155.0 5.0 5.0 21.0   5.0         11.0   109.0 93.0       1.5               202.0 155 5 5 21   5         11   109 93                 202
259390 SD     school 4674370 13001   Vermillion 13-1 467437000301 4 Jolley Elementary School   Regular School No Elementary 02 05 2018   k_12_total 257.0 5.0 12.0 39.0   7.0       3.0 25.0   182.0 166.0       1.2               348.0 257 5 12 39   7       3 25   182 166                 348
259748 SD     school 4676620 14004   Watertown 14-4 467662000718 2 Watertown Middle School   Regular School No Middle 07 08 2018   k_12_total 550.0 5.0 20.0 32.0   6.0         14.0   313.0 314.0       0.3               627.0 550 5 20 32   6         14   313 314                 627
260046 SD     school 4631710 49007   West Central 49-7 463171000274 1 West Central Hi Sch   Regular School No High 09 12 2018   k_12_total 386.0 5.0 2.0 3.0             6.0   192.0 210.0       0.5               402.0 386 5 2 3             6   192 210                 402

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