Data source: Big Local News · About: Big Local

675 rows where grade = "pk_12_total", state = "SD" and year = 2021 sorted by ccd_school_lvl

View and edit SQL

year

  • 2021 · 675

grade

  • pk_12_total · 675
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
449050 SD     school 4602070 6001   Aberdeen 06-1 460207000002 5 C.C. Lee Elementary   Regular School Not applicable Elementary KG 05 2021   pk_12_total 311.0 9.0 9.0 10.0   9.0         19.0   190.0 177.0                       367.0 311 9 9 10   9         19   190 177                 367
449053 SD     school 4602070 6001   Aberdeen 06-1 460207000007 8 Lincoln Elementary   Regular School Not applicable Elementary PK 05 2021   pk_12_total 193.0 3.0 34.0 17.0   32.0         19.0   166.0 132.0                       298.0 193 3 34 17   32         19   166 132                 298
449054 SD     school 4602070 6001   Aberdeen 06-1 460207000008 9 May Overby Elementary   Regular School Not applicable Elementary KG 05 2021   pk_12_total 232.0 14.0 34.0 23.0   22.0         23.0   171.0 177.0                       348.0 232 14 34 23   22         23   171 177                 348
449055 SD     school 4602070 6001   Aberdeen 06-1 460207001367 7 Mike Miller Elementary   Regular School Not applicable Elementary KG 05 2021   pk_12_total 184.0 6.0 12.0 13.0   13.0       1.0 16.0   112.0 133.0                       245.0 184 6 12 13   13       1 16   112 133                 245
449057 SD     school 4602070 6001   Aberdeen 06-1 460207000009 11 O.M. Tiffany Elementary   Regular School Not applicable Elementary KG 05 2021   pk_12_total 226.0 10.0 33.0 15.0   12.0       2.0 26.0   171.0 153.0                       324.0 226 10 33 15   12       2 26   171 153                 324
449058 SD     school 4602070 6001   Aberdeen 06-1 460207000010 10 Simmons Elementary   Regular School Not applicable Elementary KG 05 2021   pk_12_total 299.0 2.0 37.0 20.0   14.0         30.0   200.0 202.0                       402.0 299 2 37 20   14         30   200 202                 402
449126 SD     school 4600042 58003   Agar-Blunt-Onida 58-3 460004200855 3 Blunt Elementary   Regular School Not applicable Elementary PK 04 2021   pk_12_total 20.0   6.0 7.0             5.0   19.0 19.0                       38.0 20   6 7             5   19 19                 38
449127 SD     school 4600042 58003   Agar-Blunt-Onida 58-3 460004200655 4 Onida Elementary   Regular School Not applicable Elementary KG 05 2021   pk_12_total 78.0   3.0 2.0             1.0   43.0 41.0                       84.0 78   3 2             1   43 41                 84
449176 SD     school 4600028 61001   Alcester-Hudson 61-1 460002800013 4 Alcester-Hudson Elementary   Regular School Not applicable Elementary PK 06 2021   pk_12_total 207.0   7.0 2.0   1.0         5.0   112.0 110.0                       222.0 207   7 2   1         5   112 110                 222
449238 SD     school 4639540 11001   Andes Central 11-1 463954000359 2 Andes Central Elementary   Regular School Not applicable Elementary PK 05 2021   pk_12_total 38.0   9.0 94.0             34.0   91.0 84.0                       175.0 38   9 94             34   91 84                 175
449241 SD     school 4639540 11001   Andes Central 11-1 463954001080 5 Lakeview Colony Elem   Regular School Not applicable Elementary KG 08 2021   pk_12_total 29.0                       10.0 19.0                       29.0 29                       10 19                 29
449302 SD     school 4603720 38001   Arlington 38-1 460372000021 2 Arlington Elementary   Regular School Not applicable Elementary KG 06 2021   pk_12_total 128.0   8.0               1.0   59.0 78.0                       137.0 128   8               1   59 78                 137
449352 SD     school 4603780 21001   Armour 21-1 460378000023 2 Armour Elementary   Regular School Not applicable Elementary PK 05 2021   pk_12_total 94.0 3.0 6.0 3.0             6.0   53.0 59.0                       112.0 94 3 6 3             6   53 59                 112
449414 SD     school 4604270 4001   Avon 04-1 460427000028 2 Avon Elementary School   Regular School Not applicable Elementary KG 06 2021   pk_12_total 89.0   4.0 6.0             11.0   57.0 53.0                       110.0 89   4 6             11   57 53                 110
449464 SD     school 4604680 49001   Baltic 49-1 460468000035 2 Baltic Elem   Regular School Not applicable Elementary PK 05 2021   pk_12_total 239.0 1.0 13.0 5.0   1.0         9.0   122.0 146.0                       268.0 239 1 13 5   1         9   122 146                 268
449543 SD     school 4605610 9001   Belle Fourche 09-1 460561000289 8 North Park Elementary   Regular School Not applicable Elementary KG KG 2021   pk_12_total 89.0   9.0 2.0             7.0   50.0 57.0                       107.0 89   9 2             7   50 57                 107
449544 SD     school 4605610 9001   Belle Fourche 09-1 460561000269 3 South Park Elementary   Regular School Not applicable Elementary 01 04 2021   pk_12_total 343.0   29.0 15.0             20.0   193.0 214.0                       407.0 343   29 15             20   193 214                 407
449594 SD     school 4606240 3001   Bennett County 03-1 460624000045 3 Martin Elem   Regular School Not applicable Elementary PK 05 2021   pk_12_total 44.0   15.0 137.0             58.0   141.0 113.0                       254.0 44   15 137             58   141 113                 254
449640 SD     school 4606360 61002   Beresford 61-2 460636000047 2 Beresford Elementary   Regular School Not applicable Elementary KG 05 2021   pk_12_total 283.0 2.0 21.0 2.0   2.0         3.0   160.0 153.0                       313.0 283 2 21 2   2         3   160 153                 313
449674 SD     school 4606960 25001   Big Stone City 25-1 460696000053 1 Big Stone City Elementary   Regular School Not applicable Elementary PK 05 2021   pk_12_total 66.0 1.0 1.0 4.0             1.0   32.0 41.0                       73.0 66 1 1 4             1   32 41                 73
449720 SD     school 4607050 52001   Bison 52-1 460705000054 2 Bison Elementary   Regular School Not applicable Elementary KG 06 2021   pk_12_total 72.0     1.0   1.0         1.0   33.0 42.0                       75.0 72     1   1         1   33 42                 75
449841 SD     school 4607400 4002   Bon Homme 04-2 460740001393 20 Dawson Colony School   Regular School Not applicable Elementary KG 08 2021   pk_12_total 11.0                       5.0 6.0                       11.0 11                       5 6                 11
449842 SD     school 4607400 4002   Bon Homme 04-2 460740000060 18 Hutterische Colony Elementary   Regular School Not applicable Elementary KG 08 2021   pk_12_total 46.0                       23.0 23.0                       46.0 46                       23 23                 46
449843 SD     school 4607400 4002   Bon Homme 04-2 460740000061 3 Springfield Elementary   Regular School Not applicable Elementary KG 05 2021   pk_12_total 38.0   1.0 1.0             1.0   16.0 25.0                       41.0 38   1 1             1   16 25                 41
449844 SD     school 4607400 4002   Bon Homme 04-2 460740000063 5 Tabor Elementary   Regular School Not applicable Elementary KG 05 2021   pk_12_total 34.0     2.0                 17.0 19.0                       36.0 34     2                 17 19                 36
449845 SD     school 4607400 4002   Bon Homme 04-2 460740000064 4 Tyndall Elementary   Regular School Not applicable Elementary KG 05 2021   pk_12_total 120.0   7.0 1.0             8.0   81.0 55.0                       136.0 120   7 1             8   81 55                 136
449896 SD     school 4607800 22001   Bowdle 22-1 460780000068 2 Bowdle Elementary   Regular School Not applicable Elementary PK 06 2021   pk_12_total 57.0   3.0 1.0   2.0         4.0   35.0 32.0                       67.0 57   3 1   2         4   35 32                 67
450000 SD     school 4607950 49002   Brandon Valley 49-2 460795000414 3 Brandon Elem   Regular School Not applicable Elementary PK 04 2021   pk_12_total 509.0 27.0 23.0 10.0   4.0       1.0 46.0   345.0 275.0                       620.0 509 27 23 10   4       1 46   345 275                 620
450004 SD     school 4607950 49002   Brandon Valley 49-2 460795001302 6 Fred Assam Elementary   Regular School Not applicable Elementary KG 04 2021   pk_12_total 466.0 32.0 28.0 5.0   20.0       3.0 21.0   287.0 288.0                       575.0 466 32 28 5   20       3 21   287 288                 575
450005 SD     school 4607950 49002   Brandon Valley 49-2 460795001237 5 Robert Bennis Elementary   Regular School Not applicable Elementary KG 04 2021   pk_12_total 583.0 12.0 21.0 6.0   8.0         32.0   359.0 303.0                       662.0 583 12 21 6   8         32   359 303                 662
450006 SD     school 4607950 49002   Brandon Valley 49-2 460795000073 4 Valley Springs Elem   Regular School Not applicable Elementary KG 04 2021   pk_12_total 85.0   2.0 3.0             7.0   57.0 40.0                       97.0 85   2 3             7   57 40                 97
450056 SD     school 4621420 30003   Bridgewater-Emery 30-3 462142010071 2 Bridgewater-Emery Elementary   Regular School Not applicable Elementary PK 05 2021   pk_12_total 150.0 1.0 9.0               7.0   85.0 82.0                       167.0 150 1 9               7   85 82                 167
450146 SD     school 4600041 45004   Britton-Hecla 45-4 460004101140 2 Britton-Hecla Elementary School   Regular School Not applicable Elementary KG 05 2021   pk_12_total 151.0 1.0 12.0               6.0   85.0 85.0                       170.0 151 1 12               6   85 85                 170
450149 SD     school 4600041 45004   Britton-Hecla 45-4 460004101143 4 Sunset Colony Elementary   Regular School Not applicable Elementary KG 08 2021   pk_12_total 24.0                       15.0 9.0                       24.0 24                       15 9                 24
450151 SD     school 4600041 45004   Britton-Hecla 45-4 460004101180 5 Westwood Rural Elementary   Regular School Not applicable Elementary KG 08 2021   pk_12_total 28.0                       17.0 11.0                       28.0 28                       17 11                 28
450243 SD     school 4608520 5001   Brookings 05-1 460852001298 6 Camelot Intermediate School   Regular School Not applicable Elementary 04 05 2021   pk_12_total 412.0 16.0 33.0 16.0   8.0         24.0   278.0 231.0                       509.0 412 16 33 16   8         24   278 231                 509
450244 SD     school 4608520 5001   Brookings 05-1 460852001356 7 Dakota Prairie Elementary   Regular School Not applicable Elementary KG 03 2021   pk_12_total 375.0 13.0 12.0 2.0   4.0         26.0   225.0 207.0                       432.0 375 13 12 2   4         26   225 207                 432
450246 SD     school 4608520 5001   Brookings 05-1 460852000085 4 Hillcrest Elem   Regular School Not applicable Elementary KG 03 2021   pk_12_total 202.0 8.0 21.0 6.0   7.0         20.0   145.0 119.0                       264.0 202 8 21 6   7         20   145 119                 264
450247 SD     school 4608520 5001   Brookings 05-1 460852000086 5 Medary Elem   Regular School Not applicable Elementary KG 03 2021   pk_12_total 244.0 16.0 37.0 9.0   10.0       1.0 16.0   178.0 155.0                       333.0 244 16 37 9   10       1 16   178 155                 333
450296 SD     school 4609512 26002   Burke 26-2 460951200100 2 Burke Elementary School   Regular School Not applicable Elementary PK 05 2021   pk_12_total 99.0   2.0 8.0             1.0   59.0 51.0                       110.0 99   2 8             1   59 51                 110
450344 SD     school 4610320 43001   Canistota 43-1 461032000104 2 Canistota Elementary School   Regular School Not applicable Elementary PK 05 2021   pk_12_total 108.0   5.0 3.0   2.0             57.0 61.0                       118.0 108   5 3   2             57 61                 118
450394 SD     school 4610560 41001   Canton 41-1 461056000108 2 Lawrence Elementary   Regular School Not applicable Elementary KG 05 2021   pk_12_total 372.0 1.0 3.0 1.0   3.0         5.0   206.0 179.0                       385.0 372 1 3 1   3         5   206 179                 385
450454 SD     school 4611280 28001   Castlewood 28-1 461128000113 2 Castlewood Elementary   Regular School Not applicable Elementary PK 06 2021   pk_12_total 170.0 1.0 10.0               3.0   91.0 93.0                       184.0 170 1 10               3   91 93                 184
450457 SD     school 4611280 28001   Castlewood 28-1 461128001126 4 Claremont Colony Elementary   Regular School Not applicable Elementary KG 08 2021   pk_12_total 12.0                       5.0 7.0                       12.0 12                       5 7                 12
450504 SD     school 4611760 60001   Centerville 60-1 461176000115 2 Centerville Elem   Regular School Not applicable Elementary PK 05 2021   pk_12_total 140.0   6.0               1.0   77.0 70.0                       147.0 140   6               1   77 70                 147
450552 SD     school 4612000 7001   Chamberlain 07-1 461200000118 3 Chamberlain Elementary School   Regular School Not applicable Elementary KG 05 2021   pk_12_total 176.0 3.0 10.0 166.0   1.0         37.0   218.0 175.0                       393.0 176 3 10 166   1         37   218 175                 393
450657 SD     school 4612300 39001   Chester Area 39-1 461230000131 2 Chester Area Elementary School   Regular School Not applicable Elementary PK 05 2021   pk_12_total 155.0 2.0 2.0               5.0   84.0 80.0                       164.0 155 2 2               5   84 80                 164
450660 SD     school 4612300 39001   Chester Area 39-1 461230001377 7 Gracevale Colony   Regular School Not applicable Elementary KG 08 2021   pk_12_total 16.0                       9.0 7.0                       16.0 16                       9 7                 16
450662 SD     school 4612300 39001   Chester Area 39-1 461230001092 4 Rustic Acres   Regular School Not applicable Elementary KG 08 2021   pk_12_total 32.0                       22.0 10.0                       32.0 32                       22 10                 32
450754 SD     school 4612940 12002   Clark 12-2 461294000132 2 Clark Elementary School   Regular School Not applicable Elementary PK 04 2021   pk_12_total 122.0 1.0 17.0               11.0   78.0 73.0                       151.0 122 1 17               11   78 73                 151
450757 SD     school 4612940 12002   Clark 12-2 461294001081 4 Fordham Colony Elementary   Regular School Not applicable Elementary KG 08 2021   pk_12_total 36.0                       15.0 21.0                       36.0 36                       15 21                 36
450758 SD     school 4612940 12002   Clark 12-2 461294001082 5 Hillcrest Colony Elementary   Regular School Not applicable Elementary KG 08 2021   pk_12_total 29.0                       16.0 13.0                       29.0 29                       16 13                 29
450759 SD     school 4612940 12002   Clark 12-2 461294001319 7 Silver Creek Colony   Regular School Not applicable Elementary KG 08 2021   pk_12_total 34.0                       17.0 17.0                       34.0 34                       17 17                 34
450808 SD     school 4614100 50005   Colman-Egan 50-5 461410000093 3 Colman Elem   Regular School Not applicable Elementary PK 06 2021   pk_12_total 133.0 1.0 12.0 4.0             4.0   63.0 91.0                       154.0 133 1 12 4             4   63 91                 154
450870 SD     school 4614130 59003   Colome Consolidated 461413000140 2 Colome Elementary School   Regular School Not applicable Elementary PK 05 2021   pk_12_total 61.0     14.0             8.0   51.0 32.0                       83.0 61     14             8   51 32                 83
450873 SD     school 4614130 59003   Colome Consolidated 461413000787 5 Wood Elementary   Regular School Not applicable Elementary KG 08 2021   pk_12_total 6.0     10.0                 4.0 12.0                       16.0 6     10                 4 12                 16
450920 SD     school 4680445 21003   Corsica-Stickney 21-3 468044501354 2 Corsica-Stickney Elementary   Regular School Not applicable Elementary PK 06 2021   pk_12_total 162.0   3.0 3.0   1.0         6.0   84.0 91.0                       175.0 162   3 3   1         6   84 91                 175
450982 SD     school 4616950 16001   Custer 16-1 461695000154 2 Custer Elementary   Regular School Not applicable Elementary KG 06 2021   pk_12_total 240.0 1.0 18.0 8.0             4.0   150.0 121.0                       271.0 240 1 18 8             4   150 121                 271
450985 SD     school 4616950 16001   Custer 16-1 461695000159 4 Hermosa Elem   Regular School Not applicable Elementary KG 08 2021   pk_12_total 194.0   9.0 16.0           1.0 13.0   114.0 119.0                       233.0 194   9 16           1 13   114 119                 233
451046 SD     school 4636990 61008   Dakota Valley 61-8 463699000251 2 Dakota Valley Elementary School   Regular School Not applicable Elementary KG 03 2021   pk_12_total 303.0 7.0 36.0 7.0   13.0       1.0 33.0   203.0 197.0                       400.0 303 7 36 7   13       1 33   203 197                 400
451049 SD     school 4636990 61008   Dakota Valley 61-8 463699001075 4 Dakota Valley Upper Elem   Regular School Not applicable Elementary 04 05 2021   pk_12_total 173.0 5.0 20.0     7.0       2.0 12.0   105.0 114.0                       219.0 173 5 20     7       2 12   105 114                 219
451098 SD     school 4617850 38002   De Smet 38-2 461785000162 2 Laura Ingalls Wilder Elem   Regular School Not applicable Elementary PK 05 2021   pk_12_total 142.0 3.0 5.0               1.0   86.0 65.0                       151.0 142 3 5               1   86 65                 151
451144 SD     school 4618120 49003   Dell Rapids 49-3 461812000164 2 Dell Rapids Elementary   Regular School Not applicable Elementary KG 04 2021   pk_12_total 374.0 1.0 6.0 5.0           1.0 11.0   222.0 176.0                       398.0 374 1 6 5           1 11   222 176                 398
451220 SD     school 4678300 5006   Deubrook Area 05-6 467830000559 3 Deubrook Elementary   Regular School Not applicable Elementary PK 06 2021   pk_12_total 188.0 2.0 3.0 2.0             2.0   103.0 94.0                       197.0 188 2 3 2             2   103 94                 197
451223 SD     school 4678300 5006   Deubrook Area 05-6 467830001154 7 Norfeld Colony School   Regular School Not applicable Elementary KG 08 2021   pk_12_total 25.0                       9.0 16.0                       25.0 25                       9 16                 25
451224 SD     school 4678300 5006   Deubrook Area 05-6 467830001320 9 Red Willow Colony School   Regular School Not applicable Elementary KG 08 2021   pk_12_total 17.0                       8.0 9.0                       17.0 17                       8 9                 17
451272 SD     school 4600036 19004   Deuel 19-4 460003601011 2 Clear Lake Elementary   Regular School Not applicable Elementary PK 05 2021   pk_12_total 237.0 2.0 14.0 2.0             4.0   162.0 97.0                       259.0 237 2 14 2             4   162 97                 259
451376 SD     school 4619170 56002   Doland 56-2 461917001299 6 Camrose Colony Elementary   Regular School Not applicable Elementary KG 08 2021   pk_12_total 10.0                       7.0 3.0                       10.0 10                       7 3                 10
451377 SD     school 4619170 56002   Doland 56-2 461917001101 5 Clark Colony Elementary   Regular School Not applicable Elementary KG 08 2021   pk_12_total 13.0                       5.0 8.0                       13.0 13                       5 8                 13
451378 SD     school 4619170 56002   Doland 56-2 461917000170 3 Doland Elementary   Regular School Not applicable Elementary PK 06 2021   pk_12_total 57.0   7.0                   35.0 29.0                       64.0 57   7                   35 29                 64
451381 SD     school 4619170 56002   Doland 56-2 461917001100 4 Hillside Colony Elementary   Regular School Not applicable Elementary KG 08 2021   pk_12_total 20.0                       11.0 9.0                       20.0 20                       11 9                 20
451448 SD     school 4619410 51001   Douglas 51-1 461941001384 6 Patriot Elementary   Regular School Not applicable Elementary KG 03 2021   pk_12_total 576.0 16.0 102.0 54.0   11.0       1.0 110.0   447.0 423.0                       870.0 576 16 102 54   11       1 110   447 423                 870
451449 SD     school 4619410 51001   Douglas 51-1 461941000436 2 Vandenberg Elementary   Regular School Not applicable Elementary 04 05 2021   pk_12_total 294.0 11.0 38.0 32.0   5.0       1.0 67.0   234.0 214.0                       448.0 294 11 38 32   5       1 67   234 214                 448
451496 SD     school 4619450 64002   Dupree 64-2 461945000799 2 Dupree Elem   Regular School Not applicable Elementary PK 06 2021   pk_12_total 23.0 1.0 10.0 164.0             16.0   109.0 105.0                       214.0 23 1 10 164             16   109 105                 214
451560 SD     school 4620100 20001   Eagle Butte 20-1 462010000897 2 C-EB Primary   Regular School Not applicable Elementary KG 02 2021   pk_12_total 3.0   1.0 55.0                 30.0 29.0                       59.0 3   1 55                 30 29                 59
451561 SD     school 4620100 20001   Eagle Butte 20-1 462010000605 3 C-EB Upper Elementary   Regular School Not applicable Elementary 03 06 2021   pk_12_total 1.0     248.0   2.0             124.0 127.0                       251.0 1     248   2             124 127                 251
451594 SD     school 4620850 23001   Edgemont 23-1 462085000181 3 Edgemont Elementary   Regular School Not applicable Elementary KG 08 2021   pk_12_total 91.0   3.0 6.0             6.0   57.0 49.0                       106.0 91   3 6             6   57 49                 106
451654 SD     school 4634440 22005   Edmunds Central 22-5 463444001385 6 Boulder Colony School   Regular School Not applicable Elementary KG 08 2021   pk_12_total 6.0                       3.0 3.0                       6.0 6                       3 3                 6
451655 SD     school 4634440 22005   Edmunds Central 22-5 463444001066 5 Edmunds Central Elementary   Regular School Not applicable Elementary PK 05 2021   pk_12_total 53.0   15.0 1.0   4.0             33.0 40.0                       73.0 53   15 1   4             33 40                 73
451676 SD     school 4621300 16002   Elk Mountain 16-2 462130000899 1 Elk Mountain Elem   Regular School Not applicable Elementary PK 08 2021   pk_12_total 7.0                       6.0 1.0                       7.0 7                       6 1                 7
451720 SD     school 4621340 61007   Elk Point-Jefferson 61-7 462134000185 2 Elk Point Jefferson Elementary   Regular School Not applicable Elementary KG 05 2021   pk_12_total 280.0 3.0 20.0 3.0             14.0   176.0 144.0                       320.0 280 3 20 3             14   176 144                 320
451796 SD     school 4621390 5003   Elkton 05-3 462139000187 2 Elkton Elementary School   Regular School Not applicable Elementary PK 06 2021   pk_12_total 150.0   36.0               7.0   94.0 99.0                       193.0 150   36               7   94 99                 193
451799 SD     school 4621390 5003   Elkton 05-3 462139001078 4 Newdale Colony Elem   Regular School Not applicable Elementary KG 08 2021   pk_12_total 25.0                       16.0 9.0                       25.0 25                       16 9                 25
451800 SD     school 4621390 5003   Elkton 05-3 462139001168 5 Rolland Colony Elem   Regular School Not applicable Elementary KG 08 2021   pk_12_total 14.0                       7.0 7.0                       14.0 14                       7 7                 14
451848 SD     school 4622410 28002   Estelline 28-2 462241000191 2 Estelline Elementary School   Regular School Not applicable Elementary PK 05 2021   pk_12_total 122.0 1.0 11.0               7.0   73.0 68.0                       141.0 122 1 11               7   73 68                 141
451896 SD     school 4622500 17001   Ethan 17-1 462250000193 2 Ethan Elementary   Regular School Not applicable Elementary PK 06 2021   pk_12_total 141.0 1.0 3.0 3.0             12.0   69.0 91.0                       160.0 141 1 3 3             12   69 91                 160
451944 SD     school 4622560 44001   Eureka 44-1 462256000195 2 Eureka Elementary School   Regular School Not applicable Elementary PK 06 2021   pk_12_total 95.0 1.0 1.0 1.0             3.0   54.0 47.0                       101.0 95 1 1 1             3   54 47                 101
452006 SD     school 4622940 46002   Faith 46-2 462294000805 2 Faith Elementary School   Regular School Not applicable Elementary KG 06 2021   pk_12_total 51.0   1.0 2.0   1.0       1.0 1.0   30.0 27.0                       57.0 51   1 2   1       1 1   30 27                 57
452009 SD     school 4622940 46002   Faith 46-2 462294000412 4 Maurine Elem.   Regular School Not applicable Elementary KG 08 2021   pk_12_total 17.0                       10.0 7.0                       17.0 17                       10 7                 17
452112 SD     school 4624030 24004   Faulkton Area 462403001158 6 Blumengard Colony Elem   Regular School Not applicable Elementary KG 08 2021   pk_12_total 32.0                       17.0 15.0                       32.0 32                       17 15                 32
452113 SD     school 4624030 24004   Faulkton Area 462403001090 5 Brentwood Colony School   Regular School Not applicable Elementary KG 08 2021   pk_12_total 18.0                       9.0 9.0                       18.0 18                       9 9                 18
452115 SD     school 4624030 24004   Faulkton Area 462403000202 2 Faulkton Elem   Regular School Not applicable Elementary PK 06 2021   pk_12_total 161.0 1.0 4.0 1.0             1.0   91.0 77.0                       168.0 161 1 4 1             1   91 77                 168
452118 SD     school 4624030 24004   Faulkton Area 462403001160 10 Thunderbird Colony Elem   Regular School Not applicable Elementary KG 08 2021   pk_12_total 30.0                       15.0 15.0                       30.0 30                       15 15                 30
452182 SD     school 4624390 50003   Flandreau 50-3 462439000207 4 Flandreau Elem   Regular School Not applicable Elementary KG 04 2021   pk_12_total 102.0   41.0 82.0   3.0       2.0 31.0   137.0 124.0                       261.0 102   41 82   3       2 31   137 124                 261
452185 SD     school 4624390 50003   Flandreau 50-3 462439001119 6 Pleasant Valley Colony Elem   Regular School Not applicable Elementary KG 08 2021   pk_12_total 31.0                       18.0 13.0                       31.0 31                       18 13                 31
452232 SD     school 4624540 14001   Florence 14-1 462454000208 2 Florence Elementary School   Regular School Not applicable Elementary PK 05 2021   pk_12_total 155.0     1.0             2.0   69.0 89.0                       158.0 155     1             2   69 89                 158
452280 SD     school 4621400 6002   Frederick Area 06-2 462140000189 2 Frederick Elementary   Regular School Not applicable Elementary KG 06 2021   pk_12_total 69.0   1.0     2.0         3.0   39.0 36.0                       75.0 69   1     2         3   39 36                 75
452356 SD     school 4625500 33001   Freeman 33-1 462550000219 2 Freeman Elem   Regular School Not applicable Elementary KG 05 2021   pk_12_total 111.0   16.0 3.0   2.0             70.0 62.0                       132.0 111   16 3   2             70 62                 132
452359 SD     school 4625500 33001   Freeman 33-1 462550000221 3 Tschetter Colony Elementary   Regular School Not applicable Elementary KG 08 2021   pk_12_total 35.0                       23.0 12.0                       35.0 35                       23 12                 35
452360 SD     school 4625500 33001   Freeman 33-1 462550000222 4 Wolf Creek Colony Elementary   Regular School Not applicable Elementary KG 08 2021   pk_12_total 30.0                       14.0 16.0                       30.0 30                       14 16                 30

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