Data source: Big Local News · About: Big Local

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

View and edit SQL

year

  • 2018 · 671

grade

  • pk_12_total · 671
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
252602 SD     school 4621300 16002   Elk Mountain 16-2 462130001371 4 Elk Mountain High School   Regular School No High 09 12 2018   pk_12_total 2.0                       1.0 1.0                       2.0 2                       1 1                 2
252950 SD     school 4622940 46002   Faith 46-2 462294001306 10 Faith PreSchool   Regular School No Prekindergarten PK PK 2018   pk_12_total 3.0     1.0                 3.0 1.0                       4.0 3     1                 3 1                 4
257411 SD     school 4659820 51004   Rapid City Area 51-4 465982001072 64 Jefferson Building   Special Education School No Other PK 12 2018   pk_12_total 2.0                       1.0 1.0                       2.0 2                       1 1                 2
258411 SD     school 4666270 49005   Sioux Falls 49-5 466627001305 37 Career and Technical Education Academy   Career and Technical School No High 09 12 2018   pk_12_total 3.0                       2.0 1.0                       3.0 3                       2 1                 3
258443 SD     school 4666270 49005   Sioux Falls 49-5 466627001121 39 Success Academy   Special Education School No High 06 12 2018   pk_12_total 12.0 4.0 1.0                   16.0 1.0                       17.0 12 4 1                   16 1                 17
252272 SD     school 4619170 56002   Doland 56-2 461917001101 5 Clark Colony Elementary   Regular School No Elementary KG 08 2018   pk_12_total 14.0                       4.0 10.0                       14.0 14                       4 10                 14
252274 SD     school 4619170 56002   Doland 56-2 461917000171 1 Doland High School   Regular School No High 09 12 2018   pk_12_total 26.0                       16.0 10.0                       26.0 26                       16 10                 26
252568 SD     school 4634440 22005   Edmunds Central 22-5 463444000032 2 Edmunds Central Middle School   Regular School No Middle 07 08 2018   pk_12_total 16.0   2.0 1.0                 9.0 10.0                       19.0 16   2 1                 9 10                 19
253042 SD     school 4624030 24004   Faulkton Area 462403001090 5 Brentwood Colony School   Regular School No Elementary KG 08 2018   pk_12_total 19.0                       9.0 10.0                       19.0 19                       9 10                 19
254329 SD     school 4634600 53002   Hoven 53-2 463460000912 3 Hoven Jr High School   Regular School No Middle 07 08 2018   pk_12_total 18.0                       8.0 10.0                       18.0 18                       8 10                 18
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
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
257413 SD     school 4659820 51004   Rapid City Area 51-4 465982001341 44 Lincoln Building   Special Education School No High 12 12 2018   pk_12_total 21.0   3.0 5.0   2.0         2.0   23.0 10.0                       33.0 21   3 5   2         2   23 10                 33
257640 SD     school 4664140 39004   Rutland 39-4 466414000932 3 Rutland Jr Hi   Regular School No Middle 06 08 2018   pk_12_total 28.0                   1.0   19.0 10.0                       29.0 28                   1   19 10                 29
260257 SD     school 4679350 12003   Willow Lake 12-3 467935001297 6 Collins Colony Elem   Regular School No Elementary KG 08 2018   pk_12_total 22.0                       12.0 10.0                       22.0 22                       12 10                 22
260258 SD     school 4679350 12003   Willow Lake 12-3 467935001067 4 Mayfield Colony Elem   Regular School No Elementary KG 08 2018   pk_12_total 16.0                       6.0 10.0                       16.0 16                       6 10                 16
260360 SD     school 4679710 59002   Winner 59-2 467971000781 1 Winner High School   Regular School No High 09 12 2018   pk_12_total 147.0 3.0 1.0 45.0   2.0       1.0     99.0 100.0                       199.0 147 3 1 45   2       1     99 100                 199
252648 SD     school 4621340 61007   Elk Point-Jefferson 61-7 462134000186 1 Elk Point Jefferson High School   Regular School No High 09 12 2018   pk_12_total 190.0 3.0 7.0     1.0       2.0 2.0   104.0 101.0                       205.0 190 3 7     1       2 2   104 101                 205
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
255961 SD     school 4600002 25004   Milbank 25-4 460000200425 2 Milbank Middle School   Regular School No Middle 06 08 2018   pk_12_total 192.0   16.0 2.0             3.0   111.0 102.0                       213.0 192   16 2             3   111 102                 213
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
255111 SD     school 4641300 40001   Lead-Deadwood 40-1 464130000374 1 Lead-Deadwood High School   Regular School No High 09 12 2018   pk_12_total 184.0 1.0 13.0 4.0   4.0         6.0   107.0 105.0                       212.0 184 1 13 4   4         6   107 105                 212
250071 SD     school 4600028 61001   Alcester-Hudson 61-1 460002800013 4 Alcester-Hudson Elementary   Regular School No Elementary PK 06 2018   pk_12_total 209.0   13.0     1.0       1.0 6.0   124.0 106.0                       230.0 209   13     1       1 6   124 106                 230
251880 SD     school 4616950 16001   Custer 16-1 461695000159 4 Hermosa Elem   Regular School No Elementary KG 08 2018   pk_12_total 166.0   8.0 13.0           1.0 16.0   98.0 106.0                       204.0 166   8 13           1 16   98 106                 204
259256 SD     school 4644940 49006   Tri-Valley 49-6 464494000405 1 Tri-Valley High School   Regular School No High 09 12 2018   pk_12_total 226.0 14.0 7.0 1.0   1.0         5.0   148.0 106.0                       254.0 226 14 7 1   1         5   148 106                 254
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
259528 SD     school 4675420 11004   Wagner Community 11-4 467542001278 4 Wagner Primary School   Regular School No Elementary PK KG 2018   pk_12_total 62.0   10.0 137.0             25.0   125.0 109.0                       234.0 62   10 137             25   125 109                 234
253041 SD     school 4624030 24004   Faulkton Area 462403001158 6 Blumengard Colony Elem   Regular School No Elementary KG 08 2018   pk_12_total 28.0                       17.0 11.0                       28.0 28                       17 11                 28
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
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
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
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
259335 SD     school 4672450 33005   Tripp-Delmont 33-5 467245000059 2 Tripp-Delmont JH   Regular School No Middle 07 08 2018   pk_12_total 20.0     1.0   1.0             11.0 11.0                       22.0 20     1   1             11 11                 22
251944 SD     school 4636990 61008   Dakota Valley 61-8 463699001075 4 Dakota Valley Upper Elem   Regular School No Elementary 04 05 2018   pk_12_total 180.0 2.0 14.0 1.0   3.0         13.0   103.0 110.0                       213.0 180 2 14 1   3         13   103 110                 213
251041 SD     school 4600041 45004   Britton-Hecla 45-4 460004101140 2 Britton-Hecla Elementary School   Regular School No Elementary KG 06 2018   pk_12_total 191.0 4.0 8.0 2.0   1.0         8.0   103.0 111.0                       214.0 191 4 8 2   1         8   103 111                 214
258536 SD     school 4666300 5005   Sioux Valley 05-5 466630000612 1 Sioux Valley High School   Regular School No High 09 12 2018   pk_12_total 185.0   9.0 2.0   3.0         3.0   91.0 111.0                       202.0 185   9 2   3         3   91 111                 202
259761 SD     school 4676620 14004   Watertown 14-4 467662000716 8 Roosevelt Elementary   Regular School No Elementary PK 04 2018   pk_12_total 208.0 3.0 13.0 12.0   2.0       1.0 16.0   144.0 111.0                       255.0 208 3 13 12   2       1 16   144 111                 255
250552 SD     school 4606360 61002   Beresford 61-2 460636000048 1 Beresford High School   Regular School No High 09 12 2018   pk_12_total 199.0 2.0 8.0     4.0         5.0   106.0 112.0                       218.0 199 2 8     4         5   106 112                 218
252472 SD     school 4620100 20001   Eagle Butte 20-1 462010000605 3 C-EB Upper Elementary   Regular School No Elementary 03 06 2018   pk_12_total 2.0     226.0   1.0             115.0 114.0                       229.0 2     226   1             115 114                 229
249950 SD     school 4602070 6001   Aberdeen 06-1 460207001367 7 Mike Miller Elementary   Regular School No Elementary KG 05 2018   pk_12_total 173.0 5.0 11.0 23.0   12.0       1.0 10.0   120.0 115.0                       235.0 173 5 11 23   12       1 10   120 115                 235
252407 SD     school 4619450 64002   Dupree 64-2 461945000799 2 Dupree Elem   Regular School No Elementary PK 06 2018   pk_12_total 35.0   5.0 189.0             1.0   115.0 115.0                       230.0 35   5 189             1   115 115                 230
258439 SD     school 4666270 49005   Sioux Falls 49-5 466627001063 3 Roosevelt High School   Regular School No High 09 12 2018   pk_12_total 1719.0 188.0 234.0 83.0   68.0       1.0 60.0   1200.0 1153.0                       2353.0 1719 188 234 83   68       1 60   1200 1153                 2353
251653 SD     school 4612940 12002   Clark 12-2 461294001082 5 Hillcrest Colony Elementary   Regular School No Elementary KG 08 2018   pk_12_total 29.0                       17.0 12.0                       29.0 29                       17 12                 29
253046 SD     school 4624030 24004   Faulkton Area 462403001160 10 Thunderbird Colony Elem   Regular School No Elementary KG 08 2018   pk_12_total 23.0                       11.0 12.0                       23.0 23                       11 12                 23
254985 SD     school 4639990 38003   Lake Preston 38-3 463999000918 3 Lake Preston Jr High   Regular School No Middle 07 08 2018   pk_12_total 24.0 1.0                 2.0   15.0 12.0                       27.0 24 1                 2   15 12                 27
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
257576 SD     school 4663360 54004   Rosholt 54-4 466336000558 3 White Rock Colony Elem   Regular School No Elementary KG 08 2018   pk_12_total 23.0                       11.0 12.0                       23.0 23                       11 12                 23
257704 SD     school 4603932 55005   Sanborn Central 55-5 460393200120 5 Upland Colony   Regular School No Elementary KG 08 2018   pk_12_total 25.0                       13.0 12.0                       25.0 25                       13 12                 25
258414 SD     school 4666270 49005   Sioux Falls 49-5 466627001122 41 Community Campus   Special Education School No High 12 12 2018   pk_12_total 21.0 4.0 1.0 2.0   2.0             18.0 12.0                       30.0 21 4 1 2   2             18 12                 30
259190 SD     school 4672090 66001   Todd County 66-1 467209000503 8 Klein Elementary   Regular School No Elementary KG 08 2018   pk_12_total 5.0   2.0 15.0   1.0             11.0 12.0                       23.0 5   2 15   1             11 12                 23
259197 SD     school 4672090 66001   Todd County 66-1 467209001386 18 Todd County Achievement Middle School   Alternative School No Middle 06 08 2018   pk_12_total       26.0                 14.0 12.0                       26.0       26                 14 12                 26
259461 SD     school 4674520 60006   Viborg-Hurley 60-6 467452001301 4 Cameron Colony   Regular School No Elementary KG 08 2018   pk_12_total 18.0   1.0                   7.0 12.0                       19.0 18   1                   7 12                 19
260053 SD     school 4631710 49007   West Central 49-7 463171000777 5 West Central Hartford Elem   Regular School No Elementary KG 02 2018   pk_12_total 229.0 2.0 7.0 2.0             7.0   127.0 120.0                       247.0 229 2 7 2             7   127 120                 247
259760 SD     school 4676620 14004   Watertown 14-4 467662000714 7 Mellette Elementary School   Regular School No Elementary KG 04 2018   pk_12_total 212.0 1.0 3.0 14.0   1.0         7.0   117.0 121.0                       238.0 212 1 3 14   1         7   117 121                 238
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
256711 SD     school 4654270 60004   Parker 60-4 465427000487 2 Parker Elementary School   Regular School No Elementary PK 06 2018   pk_12_total 220.0 1.0 8.0 3.0             14.0   123.0 123.0                       246.0 220 1 8 3             14   123 123                 246
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
259397 SD     school 4674370 13001   Vermillion 13-1 467437000300 3 Austin Elementary School   Regular School No Elementary PK 01 2018   pk_12_total 202.0 5.0 7.0 21.0   6.0         13.0   130.0 124.0                       254.0 202 5 7 21   6         13   130 124                 254
251878 SD     school 4616950 16001   Custer 16-1 461695000155 1 Custer High School   Regular School No High 09 12 2018   pk_12_total 214.0 2.0 12.0 7.0           1.0 4.0   115.0 125.0                       240.0 214 2 12 7           1 4   115 125                 240
252167 SD     school 4600036 19004   Deuel 19-4 460003601011 2 Clear Lake Elementary   Regular School No Elementary PK 05 2018   pk_12_total 257.0 2.0 16.0 6.0           1.0     157.0 125.0                       282.0 257 2 16 6           1     157 125                 282
255236 SD     school 4641550 41004   Lennox 41-4 464155000387 1 Lennox High School   Regular School No High 09 12 2018   pk_12_total 254.0 1.0 9.0 4.0   1.0         8.0   152.0 125.0                       277.0 254 1 9 4   1         8   152 125                 277
251448 SD     school 4612000 7001   Chamberlain 07-1 461200000119 1 Chamberlain High School   Regular School No High 09 12 2018   pk_12_total 134.0 3.0 13.0 98.0   3.0         4.0   129.0 126.0                       255.0 134 3 13 98   3         4   129 126                 255
257045 SD     school 4680438 11005   Platte-Geddes 11-5 468043801244 2 Platte-Geddes Elem   Regular School No Elementary KG 06 2018   pk_12_total 211.0 1.0 3.0 13.0             19.0   119.0 128.0                       247.0 211 1 3 13             19   119 128                 247
254280 SD     school 4634480 23002   Hot Springs 23-2 463448000288 1 Hot Springs Hi Sch   Regular School No High 09 12 2018   pk_12_total 200.0 6.0 12.0 23.0   2.0       1.0 15.0   130.0 129.0                       259.0 200 6 12 23   2       1 15   130 129                 259
250151 SD     school 4639540 11001   Andes Central 11-1 463954001379 6 Pease Creek Colony Elementary   Regular School No Elementary KG 08 2018   pk_12_total 26.0                       13.0 13.0                       26.0 26                       13 13                 26
250586 SD     school 4606960 25001   Big Stone City 25-1 460696000352 3 Big Stone MS   Regular School No Middle 06 08 2018   pk_12_total 28.0 1.0                     16.0 13.0                       29.0 28 1                     16 13                 29
254230 SD     school 4600046 56006   Hitchcock-Tulare 460004601164 2 Hitchcock-Tulare JH   Regular School No Middle 07 08 2018   pk_12_total 31.0     1.0                 19.0 13.0                       32.0 31     1                 19 13                 32
256661 SD     school 4601027 39005   Oldham-Ramona 39-5 460102701035 3 Oldham-Ramona Junior High School   Regular School No Middle 07 08 2018   pk_12_total 22.0                   1.0   10.0 13.0                       23.0 22                   1   10 13                 23
257044 SD     school 4680438 11005   Platte-Geddes 11-5 468043801267 10 Platte Colony School   Regular School No Elementary KG 08 2018   pk_12_total 28.0                       15.0 13.0                       28.0 28                       15 13                 28
251141 SD     school 4608520 5001   Brookings 05-1 460852000085 4 Hillcrest Elem   Regular School No Elementary KG 03 2018   pk_12_total 214.0 7.0 14.0 13.0   11.0         18.0   146.0 131.0                       277.0 214 7 14 13   11         18   146 131                 277
252040 SD     school 4618120 49003   Dell Rapids 49-3 461812000165 1 Dell Rapids High School   Regular School No High 09 12 2018   pk_12_total 259.0 2.0 3.0 10.0   1.0         4.0   148.0 131.0                       279.0 259 2 3 10   1         4   148 131                 279
256804 SD     school 4654300 33003   Parkston 33-3 465430000491 2 Parkston Elementary   Regular School No Elementary PK 06 2018   pk_12_total 245.0   8.0 2.0   2.0         8.0   134.0 131.0                       265.0 245   8 2   2         8   134 131                 265
259527 SD     school 4675420 11004   Wagner Community 11-4 467542000942 3 Wagner Middle School   Regular School No Middle 05 08 2018   pk_12_total 64.0   9.0 159.0   1.0         26.0   128.0 131.0                       259.0 64   9 159   1         26   128 131                 259
251287 SD     school 4610560 41001   Canton 41-1 461056000109 1 Canton High School   Regular School No High 09 12 2018   pk_12_total 248.0   5.0 4.0   7.0         3.0   135.0 132.0                       267.0 248   5 4   7         3   135 132                 267
259759 SD     school 4676620 14004   Watertown 14-4 467662000713 6 McKinley Elementary School   Regular School No Elementary PK 04 2018   pk_12_total 191.0   18.0 22.0             18.0   117.0 132.0                       249.0 191   18 22             18   117 132                 249
250375 SD     school 4604680 49001   Baltic 49-1 460468000035 2 Baltic Elem   Regular School No Elementary PK 05 2018   pk_12_total 241.0   11.0 4.0   2.0         7.0   130.0 135.0                       265.0 241   11 4   2         7   130 135                 265
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
259194 SD     school 4672090 66001   Todd County 66-1 467209000675 4 Rosebud Elementary   Regular School No Elementary KG 05 2018   pk_12_total     4.0 271.0             1.0   141.0 135.0                       276.0     4 271             1   141 135                 276
252041 SD     school 4618120 49003   Dell Rapids 49-3 461812000837 3 Dell Rapids Middle School   Regular School No Middle 05 08 2018   pk_12_total 265.0   6.0 3.0             8.0   146.0 136.0                       282.0 265   6 3             8   146 136                 282
260531 SD     school 4680430 63003   Yankton 63-3 468043000795 5 Stewart Elem   Regular School No Elementary KG 05 2018   pk_12_total 228.0 5.0 19.0 9.0   6.0         6.0   137.0 136.0                       273.0 228 5 19 9   6         6   137 136                 273
259911 SD     school 4676990 18005   Webster Area 467699000723 3 Webster Area Elementary School   Regular School No Elementary PK 05 2018   pk_12_total 255.0   8.0 6.0   1.0       1.0 12.0   145.0 138.0                       283.0 255   8 6   1       1 12   145 138                 283
257420 SD     school 4659820 51004   Rapid City Area 51-4 465982000527 15 South Canyon Elem   Regular School No Elementary KG 05 2018   pk_12_total 213.0 3.0 23.0 32.0   1.0       1.0 12.0   146.0 139.0                       285.0 213 3 23 32   1       1 12   146 139                 285
250633 SD     school 4607050 52001   Bison 52-1 460705000879 4 Bison JH   Regular School No Middle 07 08 2018   pk_12_total 20.0   2.0 3.0                 11.0 14.0                       25.0 20   2 3                 11 14                 25
252276 SD     school 4619170 56002   Doland 56-2 461917001100 4 Hillside Colony Elementary   Regular School No Elementary KG 08 2018   pk_12_total 26.0                       12.0 14.0                       26.0 26                       12 14                 26
253112 SD     school 4624390 50003   Flandreau 50-3 462439001119 6 Pleasant Valley Colony Elem   Regular School No Elementary KG 08 2018   pk_12_total 30.0                       16.0 14.0                       30.0 30                       16 14                 30
253287 SD     school 4625500 33001   Freeman 33-1 462550000222 4 Wolf Creek Colony Elementary   Regular School No Elementary KG 08 2018   pk_12_total 27.0                       13.0 14.0                       27.0 27                       13 14                 27
254105 SD     school 4680440 34002   Highmore-Harrold 468044001049 3 Highmore-Harrold Junior High   Regular School No Middle 07 08 2018   pk_12_total 35.0     1.0             5.0   27.0 14.0                       41.0 35     1             5   27 14                 41
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
257639 SD     school 4664140 39004   Rutland 39-4 466414000563 1 Rutland Hi Sch   Regular School No High 09 12 2018   pk_12_total 32.0     1.0                 19.0 14.0                       33.0 32     1                 19 14                 33
258410 SD     school 4666270 49005   Sioux Falls 49-5 466627001139 52 Bridges at Horace Mann   Regular School No Elementary KG 05 2018   pk_12_total 44.0 13.0 8.0 7.0             11.0   69.0 14.0                       83.0 44 13 8 7             11   69 14                 83
259990 SD     school 4677460 36002   Wessington Springs 36-2 467746001374 92 Wessington Springs High School Cyber Sch   Regular School No High 09 12 2018   pk_12_total 22.0   1.0 2.0                 11.0 14.0                       25.0 22   1 2                 11 14                 25
260104 SD     school 4678510 1003   White Lake 01-3 467851000746 1 White Lake High School   Regular School No High 09 12 2018   pk_12_total 28.0   4.0                   18.0 14.0                       32.0 28   4                   18 14                 32
260313 SD     school 4600003 54007   Wilmot 54-7 460000300872 3 Wilmot Jr. High   Regular School No Middle 07 08 2018   pk_12_total 22.0     8.0                 16.0 14.0                       30.0 22     8                 16 14                 30
255449 SD     school 4639600 39002   Madison Central 39-2 463960000364 2 Madison Middle School   Regular School No Middle 06 08 2018   pk_12_total 243.0 1.0 16.0 4.0   3.0         10.0   135.0 142.0                       277.0 243 1 16 4   3         10   135 142                 277
257422 SD     school 4659820 51004   Rapid City Area 51-4 465982000824 16 South Park Elem   Regular School No Elementary KG 05 2018   pk_12_total 117.0 1.0 36.0 110.0   3.0         36.0   161.0 142.0                       303.0 117 1 36 110   3         36   161 142                 303
259400 SD     school 4674370 13001   Vermillion 13-1 467437000690 2 Vermillion Middle School   Regular School No Middle 06 08 2018   pk_12_total 220.0 4.0 13.0 31.0   8.0         12.0   146.0 142.0                       288.0 220 4 13 31   8         12   146 142                 288
250551 SD     school 4606360 61002   Beresford 61-2 460636000047 2 Beresford Elementary   Regular School No Elementary KG 05 2018   pk_12_total 269.0 2.0 8.0 1.0   1.0         2.0   138.0 145.0                       283.0 269 2 8 1   1         2   138 145                 283
259525 SD     school 4675420 11004   Wagner Community 11-4 467542000694 2 Wagner Elementary School   Regular School No Elementary 01 04 2018   pk_12_total 77.0   15.0 179.0             37.0   163.0 145.0                       308.0 77   15 179             37   163 145                 308
250505 SD     school 4606240 3001   Bennett County 03-1 460624000045 3 Martin Elem   Regular School No Elementary PK 06 2018   pk_12_total 59.0   18.0 135.0             68.0   134.0 146.0                       280.0 59   18 135             68   134 146                 280
260056 SD     school 4631710 49007   West Central 49-7 463171000909 4 West Central MS   Regular School No Middle 06 08 2018   pk_12_total 296.0 4.0 4.0 9.0   1.0         7.0   172.0 149.0                       321.0 296 4 4 9   1         7   172 149                 321

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