Data source: Big Local News · About: Big Local

671 rows where grade = "pk_12_total", state = "SD" and year = 2018 sorted by ccd_school_lvl

View and edit SQL

year

  • 2018 · 571

grade

  • pk_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
253335 SD     school 4626370 49004   Garretson 49-4 462637000223 2 Garretson Elementary   Regular School No Elementary PK 05 2018   pk_12_total 206.0   8.0 7.0   1.0         9.0   109.0 122.0                       231.0 206   8 7   1         9   109 122                 231
253383 SD     school 4626490 63001   Gayville-Volin 63-1 462649000228 2 Gayville-Volin Elementary   Regular School No Elementary PK 06 2018   pk_12_total 159.0   10.0     1.0         3.0   92.0 81.0                       173.0 159   10     1         3   92 81                 173
253431 SD     school 4626970 53001   Gettysburg 53-1 462697000231 2 Gettysburg Elem   Regular School No Elementary KG 06 2018   pk_12_total 108.0   4.0 3.0             4.0   64.0 55.0                       119.0 108   4 3             4   64 55                 119
253479 SD     school 4629880 26004   Gregory 26-4 462988000238 2 Gregory Elementary School   Regular School No Elementary KG 05 2018   pk_12_total 143.0 1.0 4.0 24.0   4.0       1.0 7.0   92.0 92.0                       184.0 143 1 4 24   4       1 7   92 92                 184
253527 SD     school 4600045 6006   Groton Area 460004501156 2 Groton Area Elementary School   Regular School No Elementary PK 05 2018   pk_12_total 277.0   2.0 3.0   2.0         1.0   161.0 124.0                       285.0 277   2 3   2         1   161 124                 285
253589 SD     school 4630490 27001   Haakon 27-1 463049000647 8 Milesville Elem   Regular School No Elementary KG 08 2018   pk_12_total 10.0                       6.0 4.0                       10.0 10                       6 4                 10
253590 SD     school 4630490 27001   Haakon 27-1 463049000255 2 Philip Elementary School   Regular School No Elementary KG 06 2018   pk_12_total 130.0   4.0 1.0   1.0         9.0   75.0 70.0                       145.0 130   4 1   1         9   75 70                 145
253639 SD     school 4630800 28003   Hamlin 28-3 463080001111 9 Hamlin Elementary   Regular School No Elementary PK 05 2018   pk_12_total 411.0 3.0 10.0 2.0   1.0         3.0   241.0 189.0                       430.0 411 3 10 2   1         3   241 189                 430
253730 SD     school 4602640 30001   Hanson 30-1 460264000876 6 Hanson Elementary School   Regular School No Elementary PK 05 2018   pk_12_total 175.0   4.0               5.0   88.0 96.0                       184.0 175   4               5   88 96                 184
253733 SD     school 4602640 30001   Hanson 30-1 460264000015 4 Millbrook Colony Elementary   Regular School No Elementary KG 08 2018   pk_12_total 10.0                       6.0 4.0                       10.0 10                       6 4                 10
253734 SD     school 4602640 30001   Hanson 30-1 460264000875 5 Oaklane Colony   Regular School No Elementary KG 08 2018   pk_12_total 29.0   1.0                   15.0 15.0                       30.0 29   1                   15 15                 30
253811 SD     school 4609300 31001   Harding County 31-1 460930000087 2 Buffalo Elementary   Regular School No Elementary KG 05 2018   pk_12_total 75.0 1.0   1.0             2.0   36.0 43.0                       79.0 75 1   1             2   36 43                 79
253812 SD     school 4609300 31001   Harding County 31-1 460930000701 8 Camp Crook Elementary   Regular School No Elementary KG 08 2018   pk_12_total 12.0                       5.0 7.0                       12.0 12                       5 7                 12
253815 SD     school 4609300 31001   Harding County 31-1 460930000667 6 Ludlow Elementary   Regular School No Elementary KG 08 2018   pk_12_total 8.0                       2.0 6.0                       8.0 8                       2 6                 8
253947 SD     school 4631350 41002   Harrisburg 41-2 463135001335 7 Endeavor Elem   Regular School No Elementary KG 05 2018   pk_12_total 458.0 11.0 11.0 5.0   19.0         17.0   274.0 247.0                       521.0 458 11 11 5   19         17   274 247                 521
253948 SD     school 4631350 41002   Harrisburg 41-2 463135001169 4 Explorer Elementary   Regular School No Elementary PK 05 2018   pk_12_total 369.0 20.0 17.0 9.0   8.0         20.0   228.0 215.0                       443.0 369 20 17 9   8         20   228 215                 443
253949 SD     school 4631350 41002   Harrisburg 41-2 463135001318 6 Freedom Elementary   Regular School No Elementary KG 05 2018   pk_12_total 405.0 3.0 12.0 1.0   2.0       1.0 18.0   214.0 228.0                       442.0 405 3 12 1   2       1 18   214 228                 442
253953 SD     school 4631350 41002   Harrisburg 41-2 463135001375 9 Horizon Elementary   Regular School No Elementary KG 05 2018   pk_12_total 177.0 8.0 8.0     5.0         7.0   102.0 103.0                       205.0 177 8 8     5         7   102 103                 205
253954 SD     school 4631350 41002   Harrisburg 41-2 463135001288 5 Journey Elementary   Regular School No Elementary KG 05 2018   pk_12_total 369.0 4.0 7.0 4.0   8.0         7.0   199.0 200.0                       399.0 369 4 7 4   8         7   199 200                 399
253955 SD     school 4631350 41002   Harrisburg 41-2 463135000263 2 Liberty Elementary   Regular School No Elementary PK 05 2018   pk_12_total 471.0 7.0 11.0 5.0   3.0         13.0   277.0 233.0                       510.0 471 7 11 5   3         13   277 233                 510
254007 SD     school 4632340 14002   Henry 14-2 463234000275 2 Henry Elementary   Regular School No Elementary PK 04 2018   pk_12_total 63.0 1.0       1.0             26.0 39.0                       65.0 63 1       1             26 39                 65
254055 SD     school 4632430 10001   Herreid 10-1 463243000277 2 Herreid Elem   Regular School No Elementary KG 05 2018   pk_12_total 45.0     1.0             1.0   26.0 21.0                       47.0 45     1             1   26 21                 47
254103 SD     school 4680440 34002   Highmore-Harrold 468044000323 2 Highmore Elementary   Regular School No Elementary PK 06 2018   pk_12_total 107.0 1.0 2.0 14.0             3.0   60.0 67.0                       127.0 107 1 2 14             3   60 67                 127
254151 SD     school 4633360 51002   Hill City 51-2 463336000279 2 Hill City Elementary   Regular School No Elementary PK 05 2018   pk_12_total 133.0   47.0 5.0             9.0   95.0 99.0                       194.0 133   47 5             9   95 99                 194
254227 SD     school 4600046 56006   Hitchcock-Tulare 460004601166 4 Glendale Colony Elem   Regular School No Elementary KG 08 2018   pk_12_total 23.0                       12.0 11.0                       23.0 23                       12 11                 23
254228 SD     school 4600046 56006   Hitchcock-Tulare 460004601167 5 Hitchcock-Tulare Elementary   Regular School No Elementary KG 06 2018   pk_12_total 97.0   1.0 1.0                 57.0 42.0                       99.0 97   1 1                 57 42                 99
254231 SD     school 4600046 56006   Hitchcock-Tulare 460004601165 3 Spink Colony Elem   Regular School No Elementary KG 08 2018   pk_12_total 28.0                       14.0 14.0                       28.0 28                       14 14                 28
254279 SD     school 4634480 23002   Hot Springs 23-2 463448000287 2 Hot Springs Elementary   Regular School No Elementary PK 05 2018   pk_12_total 264.0 1.0 14.0 33.0   5.0       2.0 56.0   198.0 177.0                       375.0 264 1 14 33   5       2 56   198 177                 375
254327 SD     school 4634600 53002   Hoven 53-2 463460000297 2 Hoven Elementary   Regular School No Elementary PK 06 2018   pk_12_total 55.0     3.0                 29.0 29.0                       58.0 55     3                 29 29                 58
254389 SD     school 4600025 48003   Howard 48-3 460002500304 2 Howard Elem   Regular School No Elementary KG 06 2018   pk_12_total 163.0 1.0 6.0 1.0                 95.0 76.0                       171.0 163 1 6 1                 95 76                 171
254392 SD     school 4600025 48003   Howard 48-3 460002501161 8 Shannon Colony   Regular School No Elementary KG 08 2018   pk_12_total 28.0                       13.0 15.0                       28.0 28                       13 15                 28
254495 SD     school 4635480 2002   Huron 02-2 463548001370 18 Buchanan K-1 Center   Regular School No Elementary KG 01 2018   pk_12_total 177.0 2.0 162.0 7.0   111.0       1.0 18.0   254.0 224.0                       478.0 177 2 162 7   111       1 18   254 224                 478
254496 SD     school 4635480 2002   Huron 02-2 463548000312 13 Huron Colony Elementary   Regular School No Elementary KG 08 2018   pk_12_total 20.0                       13.0 7.0                       20.0 20                       13 7                 20
254499 SD     school 4635480 2002   Huron 02-2 463548001369 19 Madison 2-3 Center   Regular School No Elementary 02 03 2018   pk_12_total 190.0 4.0 126.0 7.0   92.0         13.0   245.0 187.0                       432.0 190 4 126 7   92         13   245 187                 432
254500 SD     school 4635480 2002   Huron 02-2 463548000318 15 Riverside Colony Elementary   Regular School No Elementary KG 08 2018   pk_12_total 15.0                       10.0 5.0                       15.0 15                       10 5                 15
254501 SD     school 4635480 2002   Huron 02-2 463548001373 20 Washington 4-5 Center   Regular School No Elementary 04 05 2018   pk_12_total 190.0 8.0 95.0 5.0   73.0         12.0   213.0 170.0                       383.0 190 8 95 5   73         12   213 170                 383
254593 SD     school 4636060 22006   Ipswich Public 22-6 463606001085 5 Deerfield Colony Elem   Regular School No Elementary PK 08 2018   pk_12_total 24.0                       13.0 11.0                       24.0 24                       13 11                 24
254594 SD     school 4636060 22006   Ipswich Public 22-6 463606000332 2 Ipswich Elem   Regular School No Elementary PK 05 2018   pk_12_total 179.0 1.0 6.0 1.0   1.0         3.0   90.0 101.0                       191.0 179 1 6 1   1         3   90 101                 191
254597 SD     school 4636060 22006   Ipswich Public 22-6 463606001086 6 Pembrook Colony Elem   Regular School No Elementary PK 08 2018   pk_12_total 22.0                       14.0 8.0                       22.0 22                       14 8                 22
254598 SD     school 4636060 22006   Ipswich Public 22-6 463606000334 3 Rosette Colony Elem   Regular School No Elementary PK 08 2018   pk_12_total 18.0                       12.0 6.0                       18.0 18                       12 6                 18
254647 SD     school 4680439 13003   Irene-Wakonda 13-3 468043901255 2 Irene-Wakonda Elementary School   Regular School No Elementary PK 06 2018   pk_12_total 168.0   2.0 4.0             4.0   85.0 93.0                       178.0 168   2 4             4   85 93                 178
254709 SD     school 4636150 2003   Iroquois 02-3 463615001144 4 Iroquois Elementary   Regular School No Elementary PK 05 2018   pk_12_total 92.0 6.0 4.0 2.0                 44.0 60.0                       104.0 92 6 4 2                 44 60                 104
254759 SD     school 4619580 37003   Jones County 37-3 461958000358 2 Jones County Elem   Regular School No Elementary KG 04 2018   pk_12_total 63.0   3.0 7.0             6.0   47.0 32.0                       79.0 63   3 7             6   47 32                 79
254849 SD     school 4680437 35002   Kadoka Area 35-2 468043701245 9 Interior Elementary   Regular School No Elementary KG 08 2018   pk_12_total 13.0   1.0 28.0                 21.0 21.0                       42.0 13   1 28                 21 21                 42
254851 SD     school 4680437 35002   Kadoka Area 35-2 468043701249 2 Kadoka Elementary School   Regular School No Elementary PK 05 2018   pk_12_total 52.0     49.0                 52.0 49.0                       101.0 52     49                 52 49                 101
254853 SD     school 4680437 35002   Kadoka Area 35-2 468043701256 10 Long Valley Elementary   Regular School No Elementary KG 08 2018   pk_12_total 23.0     18.0                 25.0 16.0                       41.0 23     18                 25 16                 41
254854 SD     school 4680437 35002   Kadoka Area 35-2 468043701257 11 Midland Elementary   Regular School No Elementary KG 08 2018   pk_12_total 32.0     1.0                 13.0 20.0                       33.0 32     1                 13 20                 33
254931 SD     school 4638220 7002   Kimball 07-2 463822000917 13 Grass Ranch Colony Elem   Regular School No Elementary KG 08 2018   pk_12_total 37.0                       21.0 16.0                       37.0 37                       21 16                 37
254933 SD     school 4638220 7002   Kimball 07-2 463822000354 2 Kimball Elementary   Regular School No Elementary PK 04 2018   pk_12_total 109.0   4.0 3.0             3.0   67.0 52.0                       119.0 109   4 3             3   67 52                 119
254983 SD     school 4639990 38003   Lake Preston 38-3 463999000367 2 Lake Preston Elementary   Regular School No Elementary PK 06 2018   pk_12_total 83.0   2.0 2.0             4.0   46.0 45.0                       91.0 83   2 2             4   46 45                 91
255045 SD     school 4640860 45005   Langford Area 464086000369 2 Langford Area Elem   Regular School No Elementary PK 05 2018   pk_12_total 66.0   1.0 5.0             3.0   39.0 36.0                       75.0 66   1 5             3   39 36                 75
255048 SD     school 4640860 45005   Langford Area 464086001097 4 Newport Colony Elem   Regular School No Elementary KG 08 2018   pk_12_total 29.0                       14.0 15.0                       29.0 29                       14 15                 29
255110 SD     school 4641300 40001   Lead-Deadwood 40-1 464130000372 3 Lead-Deadwood Elementary   Regular School No Elementary KG 05 2018   pk_12_total 274.0 4.0 14.0 8.0   5.0       1.0 11.0   162.0 155.0                       317.0 274 4 14 8   5       1 11   162 155                 317
255159 SD     school 4641520 52004   Lemmon 52-4 464152000381 2 Lemmon Elem   Regular School No Elementary KG 06 2018   pk_12_total 140.0   4.0 3.0             4.0   74.0 77.0                       151.0 140   4 3             4   74 77                 151
255235 SD     school 4641550 41004   Lennox 41-4 464155000386 2 Lennox Elementary   Regular School No Elementary PK 04 2018   pk_12_total 390.0 2.0 8.0 4.0   1.0         14.0   212.0 207.0                       419.0 390 2 8 4   1         14   212 207                 419
255239 SD     school 4641550 41004   Lennox 41-4 464155000389 5 Worthing Elem   Regular School No Elementary PK 04 2018   pk_12_total 91.0   3.0 2.0                 55.0 41.0                       96.0 91   3 2                 55 41                 96
255329 SD     school 4641640 44002   Leola 44-2 464164001069 6 Grassland Colony Elem   Regular School No Elementary KG 08 2018   pk_12_total 21.0                       11.0 10.0                       21.0 21                       11 10                 21
255330 SD     school 4641640 44002   Leola 44-2 464164000390 2 Leola Elem   Regular School No Elementary KG 06 2018   pk_12_total 69.0   2.0               6.0   44.0 33.0                       77.0 69   2               6   44 33                 77
255333 SD     school 4641640 44002   Leola 44-2 464164000393 5 Long Lake Colony Elem   Regular School No Elementary KG 08 2018   pk_12_total 22.0                       13.0 9.0                       22.0 22                       13 9                 22
255334 SD     school 4641640 44002   Leola 44-2 464164000394 4 Spring Creek Colony Elementary   Regular School No Elementary KG 08 2018   pk_12_total 29.0                       20.0 9.0                       29.0 29                       20 9                 29
255397 SD     school 4644770 42001   Lyman 42-1 464477000728 4 Kennebec Elementary   Regular School No Elementary KG 05 2018   pk_12_total 32.0     59.0             4.0   49.0 46.0                       95.0 32     59             4   49 46                 95
255400 SD     school 4644770 42001   Lyman 42-1 464477000397 3 Presho Elementary   Regular School No Elementary PK 05 2018   pk_12_total 80.0   1.0 14.0             4.0   59.0 40.0                       99.0 80   1 14             4   59 40                 99
255447 SD     school 4639600 39002   Madison Central 39-2 463960001189 7 Madison Elementary School   Regular School No Elementary KG 05 2018   pk_12_total 452.0 4.0 55.0 8.0   3.0         21.0   270.0 273.0                       543.0 452 4 55 8   3         21   270 273                 543
255495 SD     school 4645450 60003   Marion 60-3 464545000407 2 Marion Elementary School   Regular School No Elementary PK 05 2018   pk_12_total 81.0   10.0               6.0   51.0 46.0                       97.0 81   10               6   51 46                 97
255557 SD     school 4601026 43007   McCook Central 43-7 460102601281 4 Golden View Colony Elementary   Regular School No Elementary KG 08 2018   pk_12_total 21.0                       9.0 12.0                       21.0 21                       9 12                 21
255558 SD     school 4601026 43007   McCook Central 43-7 460102600404 2 McCook Central Elementary   Regular School No Elementary PK 04 2018   pk_12_total 156.0 1.0 10.0               9.0   107.0 69.0                       176.0 156 1 10               9   107 69                 176
255607 SD     school 4646260 15001   McIntosh 15-1 464626000410 2 McIntosh Elementary   Regular School No Elementary PK 06 2018   pk_12_total 58.0 3.0 3.0 34.0             12.0   55.0 55.0                       110.0 58 3 3 34             12   55 55                 110
255655 SD     school 4646380 15002   McLaughlin 15-2 464638000415 2 McLaughlin Elementary   Regular School No Elementary PK 05 2018   pk_12_total 5.0   3.0 209.0             1.0   110.0 108.0                       218.0 5   3 209             1   110 108                 218
255815 SD     school 4669930 46001   Meade 46-1 466993001236 17 Atall Elem   Regular School No Elementary KG 08 2018   pk_12_total 14.0                       7.0 7.0                       14.0 14                       7 7                 14
255816 SD     school 4669930 46001   Meade 46-1 466993000740 13 Elm Springs Elementary   Regular School No Elementary KG 08 2018   pk_12_total 10.0                   3.0   7.0 6.0                       13.0 10                   3   7 6                 13
255817 SD     school 4669930 46001   Meade 46-1 466993000736 9 Enning/Union Center Elem   Regular School No Elementary KG 08 2018   pk_12_total 48.0                   6.0   31.0 23.0                       54.0 48                   6   31 23                 54
255818 SD     school 4669930 46001   Meade 46-1 466993000735 8 Hereford Elementary   Regular School No Elementary KG 08 2018   pk_12_total 14.0                   1.0   12.0 3.0                       15.0 14                   1   12 3                 15
255819 SD     school 4669930 46001   Meade 46-1 466993000741 15 Opal Elementary   Regular School No Elementary KG 08 2018   pk_12_total 17.0                       7.0 10.0                       17.0 17                       7 10                 17
255820 SD     school 4669930 46001   Meade 46-1 466993000644 5 Piedmont Valley Elementary   Regular School No Elementary KG 06 2018   pk_12_total 573.0 2.0 26.0 18.0   2.0         26.0   332.0 315.0                       647.0 573 2 26 18   2         26   332 315                 647
255822 SD     school 4669930 46001   Meade 46-1 466993000637 3 Sturgis Elementary   Regular School No Elementary KG 04 2018   pk_12_total 508.0 3.0 26.0 18.0   5.0         27.0   313.0 274.0                       587.0 508 3 26 18   5         27   313 274                 587
255825 SD     school 4669930 46001   Meade 46-1 466993000652 4 Whitewood Elementary   Regular School No Elementary KG 06 2018   pk_12_total 85.0   3.0 4.0           1.0 4.0   45.0 52.0                       97.0 85   3 4           1 4   45 52                 97
255907 SD     school 4647100 33002   Menno 33-2 464710000417 3 Jamesville Colony Elementary   Regular School No Elementary KG 08 2018   pk_12_total 16.0                       9.0 7.0                       16.0 16                       9 7                 16
255908 SD     school 4647100 33002   Menno 33-2 464710000418 4 Maxwell Colony Elementary   Regular School No Elementary KG 08 2018   pk_12_total 62.0                       28.0 34.0                       62.0 62                       28 34                 62
255909 SD     school 4647100 33002   Menno 33-2 464710000419 2 Menno Elementary   Regular School No Elementary PK 05 2018   pk_12_total 92.0   1.0                   41.0 52.0                       93.0 92   1                   41 52                 93
255959 SD     school 4600002 25004   Milbank 25-4 460000200423 3 Koch Elementary   Regular School No Elementary KG 05 2018   pk_12_total 353.0 6.0 36.0 1.0             12.0   224.0 184.0                       408.0 353 6 36 1             12   224 184                 408
256021 SD     school 4647942 29004   Miller 464794200429 2 Miller Elementary School   Regular School No Elementary KG 06 2018   pk_12_total 269.0 1.0 5.0 2.0           4.0 1.0   147.0 135.0                       282.0 269 1 5 2           4 1   147 135                 282
256024 SD     school 4647942 29004   Miller 464794200431 11 Millerdale Colony Elem   Regular School No Elementary KG 08 2018   pk_12_total 17.0                       8.0 9.0                       17.0 17                       8 9                 17
256127 SD     school 4648390 17002   Mitchell 17-2 464839000591 4 Gertie Belle Rogers Elem   Regular School No Elementary KG 05 2018   pk_12_total 343.0 5.0 18.0 48.0   2.0         8.0   211.0 213.0                       424.0 343 5 18 48   2         8   211 213                 424
256128 SD     school 4648390 17002   Mitchell 17-2 464839000520 3 L B Williams Elementary   Regular School No Elementary KG 05 2018   pk_12_total 418.0 8.0 36.0 36.0   1.0         14.0   257.0 256.0                       513.0 418 8 36 36   1         14   257 256                 513
256129 SD     school 4648390 17002   Mitchell 17-2 464839000441 5 Longfellow Elementary   Regular School No Elementary KG 05 2018   pk_12_total 269.0 3.0 27.0 33.0             15.0   172.0 175.0                       347.0 269 3 27 33             15   172 175                 347
256132 SD     school 4648390 17002   Mitchell 17-2 464839000444 10 Rockport Colony Elem   Regular School No Elementary KG 08 2018   pk_12_total 17.0                       6.0 11.0                       17.0 17                       6 11                 17
256133 SD     school 4648390 17002   Mitchell 17-2 464839000445 11 Rosedale Colony Elem   Regular School No Elementary KG 08 2018   pk_12_total 23.0                       14.0 9.0                       23.0 23                       14 9                 23
256197 SD     school 4680441 62006   Mobridge-Pollock 62-6 468044100486 3 Freeman Davis Elementary   Regular School No Elementary KG 02 2018   pk_12_total 67.0 2.0 4.0 59.0   2.0             66.0 68.0                       134.0 67 2 4 59   2             66 68                 134
256200 SD     school 4680441 62006   Mobridge-Pollock 62-6 468044100493 4 Mobridge Upper Elementary   Regular School No Elementary 03 05 2018   pk_12_total 89.0 3.0 6.0 45.0   1.0             66.0 78.0                       144.0 89 3 6 45   1             66 78                 144
256261 SD     school 4648780 43002   Montrose 43-2 464878000451 2 Montrose Elementary School   Regular School No Elementary PK 05 2018   pk_12_total 105.0 1.0 5.0     1.0             55.0 57.0                       112.0 105 1 5     1             55 57                 112
256264 SD     school 4648780 43002   Montrose 43-2 464878001095 4 Orland Colony   Regular School No Elementary KG 08 2018   pk_12_total 29.0                       18.0 11.0                       29.0 29                       18 11                 29
256311 SD     school 4649650 17003   Mount Vernon 17-3 464965000454 2 Mount Vernon Elementary   Regular School No Elementary PK 05 2018   pk_12_total 105.0 2.0 1.0 2.0                 56.0 54.0                       110.0 105 2 1 2                 56 54                 110
256359 SD     school 4650670 51003   New Underwood 51-3 465067000463 2 New Underwood Elem   Regular School No Elementary KG 06 2018   pk_12_total 84.0   5.0 2.0           2.0 16.0   56.0 53.0                       109.0 84   5 2           2 16   56 53                 109
256407 SD     school 4650850 9002   Newell 09-2 465085000468 2 Newell Elem   Regular School No Elementary PK 05 2018   pk_12_total 110.0 1.0 7.0 14.0             5.0   65.0 72.0                       137.0 110 1 7 14             5   65 72                 137
256455 SD     school 4651750 56007   Northwestern Area 56-7 465175000820 4 Northwestern Elementary   Regular School No Elementary PK 05 2018   pk_12_total 118.0 1.0 1.0               4.0   64.0 60.0                       124.0 118 1 1               4   64 60                 124
256503 SD     school 4652770 23003   Oelrichs 23-3 465277000481 2 Oelrichs Elem   Regular School No Elementary PK 05 2018   pk_12_total 3.0   4.0 35.0             2.0   21.0 23.0                       44.0 3   4 35             2   21 23                 44
256579 SD     school 4665460 65001   Oglala Lakota 65-1 466546000573 1 Batesland School   Regular School No Elementary PK 08 2018   pk_12_total     1.0 179.0             1.0   88.0 93.0                       181.0     1 179             1   88 93                 181
256581 SD     school 4665460 65001   Oglala Lakota 65-1 466546000575 4 Red Shirt School   Regular School No Elementary PK 08 2018   pk_12_total     2.0 86.0                 44.0 44.0                       88.0     2 86                 44 44                 88
256582 SD     school 4665460 65001   Oglala Lakota 65-1 466546000576 3 Rockyford School   Regular School No Elementary PK 08 2018   pk_12_total     20.0 368.0           1.0 5.0   212.0 182.0                       394.0     20 368           1 5   212 182                 394
256583 SD     school 4665460 65001   Oglala Lakota 65-1 466546000574 2 Wolf Creek School   Regular School No Elementary PK 08 2018   pk_12_total 4.0   9.0 669.0             2.0   366.0 318.0                       684.0 4   9 669             2   366 318                 684

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